GET https://villereau45.fr/article/list/category

Query Metrics

5 Database Queries
5 Different statements
2.16 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
0.74 ms
(34.26%)
1
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.text AS text_2, e0_.picture AS picture_3, e0_.picture_size AS picture_size_4, e0_.updated_at AS updated_at_5, e0_.date AS date_6, e0_.place AS place_7, e0_.restricted AS restricted_8, e0_.contact AS contact_9 FROM event e0_ WHERE e0_.date > ? AND e0_.restricted = 0 ORDER BY e0_.date ASC LIMIT 4
Parameters:
[
  "2024-11-18 17:13:37"
]
0.49 ms
(22.91%)
1
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.date AS date_2, c0_.text AS text_3, c0_.picture AS picture_4, c0_.picture_size AS picture_size_5, c0_.updated_at AS updated_at_6, c0_.writer AS writer_7, c0_.category_id AS category_id_8 FROM content c0_ WHERE c0_.date < ? ORDER BY c0_.date DESC LIMIT 4
Parameters:
[
  "2024-11-18 17:13:37"
]
0.35 ms
(16.11%)
1
SELECT t0.id AS id_1, t0.document AS document_2, t0.document_size AS document_size_3, t0.annex AS annex_4, t0.annex_size AS annex_size_5, t0.updated_at AS updated_at_6, t0.date AS date_7 FROM report t0 ORDER BY t0.date DESC LIMIT 1
Parameters:
[]
0.33 ms
(15.14%)
1
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.is_verified AS is_verified_5, t0.name AS name_6 FROM user t0 WHERE t0.id = ?
Parameters:
[
  10
]
0.25 ms
(11.57%)
1
SELECT t0.id AS id_1, t0.name AS name_2 FROM category t0
Parameters:
[]

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\Event No errors.
App\Entity\Content No errors.
App\Entity\Category No errors.
App\Entity\NewspaperSubject2 No errors.
App\Entity\Report No errors.
App\Entity\ReportSubject No errors.
App\Entity\User No errors.