GET https://lodeao.com/categoriefiltre/1/27

Query Metrics

54 Database Queries
8 Different statements
268.17 ms Query time
1 Invalid entities

Grouped Statements

Show all queries

Time Count Info
232.56 ms
(86.72%)
1
SELECT t0.id AS id_1, t0.url AS url_2, t0.date_log AS date_log_3, t0.nbvues AS nbvues_4, t0.page AS page_5, t0.user_id AS user_id_6 FROM log_page t0 WHERE t0.page = ? AND t0.date_log = ? AND t0.user_id IS NULL LIMIT 1
Parameters:
[
  "Protocoles Prothèse fixée"
  "2024-12-22"
]
25.58 ms
(9.54%)
46
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url AS url_3, t0.description AS description_4, t0.image AS image_5, t0.resume AS resume_6, t0.parent_id AS parent_id_7 FROM categorie t0 WHERE t0.parent_id = ?
Parameters:
[
  1
]
4.55 ms
(1.70%)
1
SELECT p0_.id AS id_0, p0_.titre AS titre_1, p0_.resume AS resume_2, p0_.protocole AS protocole_3, p0_.administration AS administration_4, p0_.information AS information_5, p0_.code_dent AS code_dent_6, p0_.code_fracture AS code_fracture_7, p0_.fracture AS fracture_8, p0_.urgence AS urgence_9, p0_.favori AS favori_10, p0_.archive AS archive_11, p0_.urlvideo AS urlvideo_12, p0_.reference AS reference_13 FROM protocole p0_ INNER JOIN protocole_categorie p2_ ON p0_.id = p2_.protocole_id INNER JOIN categorie c1_ ON c1_.id = p2_.categorie_id WHERE c1_.id = 27 AND p0_.archive = 0 ORDER BY p0_.titre ASC
Parameters:
[]
2.35 ms
(0.88%)
2
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url AS url_3, t0.description AS description_4, t0.image AS image_5, t0.resume AS resume_6, t0.parent_id AS parent_id_7 FROM categorie t0 WHERE t0.id = ?
Parameters:
[
  27
]
1.12 ms
(0.42%)
1
"COMMIT"
Parameters:
[]
1.06 ms
(0.39%)
1
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.url AS url_3, t0.description AS description_4, t0.image AS image_5, t0.resume AS resume_6, t0.parent_id AS parent_id_7 FROM categorie t0 WHERE t0.parent_id = ? ORDER BY t0.titre ASC
Parameters:
[
  27
]
0.48 ms
(0.18%)
1
"START TRANSACTION"
Parameters:
[]
0.47 ms
(0.18%)
1
UPDATE log_page SET nbvues = ? WHERE id = ?
Parameters:
[
  3
  170125
]

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\Categorie No errors.
App\Entity\Materiel No errors.
App\Entity\Protocole
  • The association App\Entity\Protocole#commentaires refers to the owning side field App\Entity\Commentaire#protocoles which does not exist.
App\Entity\LogPage No errors.
App\Entity\User No errors.