https://cajo-test.squat.net/lire-actu/201

Query Metrics

7 Database Queries
7 Different statements
7.55 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.90 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.title AS title_3, t0.content AS content_4, t0.created_at AS created_at_5, t0.pdf AS pdf_6, t0.author_id AS author_id_7, t0.category_id AS category_id_8 FROM news t0 WHERE t0.id = ?
Parameters:
[
  201
]
2 0.94 ms
SELECT t0.id AS id_1, t0.category AS category_2, t0.type AS type_3, t0.counter AS counter_4, t0.page_id AS page_id_5 FROM visitor_count t0 WHERE t0.category = ? AND t0.page_id = ? LIMIT 1
Parameters:
[
  "App\Entity\News"
  201
]
3 0.22 ms
"START TRANSACTION"
Parameters:
[]
4 0.49 ms
UPDATE visitor_count SET counter = ? WHERE id = ?
Parameters:
[
  9
  229
]
5 1.48 ms
"COMMIT"
Parameters:
[]
6 0.99 ms
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.created_at AS created_at_3 FROM keywords t0 INNER JOIN news_keywords ON t0.id = news_keywords.keywords_id WHERE news_keywords.news_id = ? ORDER BY t0.keyword ASC
Parameters:
[
  201
]
7 2.54 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.word AS word_3, t0.definition AS definition_4, t0.created_at AS created_at_5 FROM lexique t0 INNER JOIN news_lexiques ON t0.id = news_lexiques.lexique_id WHERE news_lexiques.news_id = ? ORDER BY t0.word ASC
Parameters:
[
  201
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\News No errors.
App\Entity\User No errors.
App\Entity\NewsCategory No errors.
App\Entity\Keywords No errors.
App\Entity\Lexique No errors.
App\Entity\VisitorCount No errors.
App\Entity\Tuto No errors.
App\Entity\Jurisprudence No errors.