https://cajo-test.squat.net/jurisprudence/165

Query Metrics

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

Queries

Group similar statements

# Time Info
1 1.09 ms
SELECT t0.id AS id_1, t0.active AS active_2, t0.name AS name_3, t0.content AS content_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.date AS date_7, t0.tags AS tags_8, t0.pdf AS pdf_9, t0.quality AS quality_10, t0.justice_court AS justice_court_11, t0.author_id AS author_id_12, t0.category_id AS category_id_13 FROM jurisprudence t0 WHERE t0.id = ?
Parameters:
[
  165
]
2 1.33 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.enabled AS enabled_3, t0.created_at AS created_at_4, t0.parent_id AS parent_id_5 FROM jurisprudence_category t0 WHERE t0.id = ?
Parameters:
[
  24
]
3 0.81 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\Jurisprudence"
  165
]
4 0.27 ms
"START TRANSACTION"
Parameters:
[]
5 0.55 ms
UPDATE visitor_count SET counter = ? WHERE id = ?
Parameters:
[
  42
  211
]
6 1.68 ms
"COMMIT"
Parameters:
[]
7 2.73 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 jp_lexiques ON t0.id = jp_lexiques.lexique_id WHERE jp_lexiques.jurisprudence_id = ? ORDER BY t0.word ASC
Parameters:
[
  165
]

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\JurisprudenceCategory No errors.
App\Entity\Jurisprudence No errors.
App\Entity\VisitorCount No errors.
App\Entity\User No errors.
App\Entity\Lexique No errors.
App\Entity\News No errors.
App\Entity\Tuto No errors.