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

Query Metrics

13 Database Queries
8 Different statements
53.86 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
25.47 ms
(47.29%)
6
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:
[
  1277
]
9.28 ms
(17.22%)
1
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.pdf AS pdf_8, t0.quality AS quality_9, t0.justice_court AS justice_court_10, t0.author_id AS author_id_11, t0.category_id AS category_id_12 FROM jurisprudence t0 WHERE t0.id = ?
Parameters:
[
  186
]
4.11 ms
(7.63%)
1
"START TRANSACTION"
Parameters:
[]
4.03 ms
(7.48%)
1
SELECT t0.id AS id_1, t0.keyword AS keyword_2, t0.created_at AS created_at_3 FROM keywords t0 INNER JOIN jp_keywords ON t0.id = jp_keywords.keywords_id WHERE jp_keywords.jurisprudence_id = ? ORDER BY t0.keyword ASC
Parameters:
[
  186
]
3.65 ms
(6.77%)
1
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:
[
  186
]
2.98 ms
(5.53%)
1
"COMMIT"
Parameters:
[]
2.80 ms
(5.21%)
1
UPDATE visitor_count SET counter = ? WHERE id = ?
Parameters:
[
  24
  225
]
1.55 ms
(2.87%)
1
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"
  186
]

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