GET https://lodeao.com/recherche?txtrecherche=finger

Query Metrics

6 Database Queries
6 Different statements
28.10 ms Query time
2 Invalid entities

Grouped Statements

Show all queries

Time Count Info
8.10 ms
(28.83%)
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_ WHERE p0_.archive = 0 AND ((p0_.resume LIKE ? OR p0_.protocole LIKE ? OR p0_.administration LIKE ? OR p0_.information LIKE ?)) ORDER BY p0_.titre ASC
Parameters:
[
  "%finger%"
  "%finger%"
  "%finger%"
  "%finger%"
]
6.39 ms
(22.76%)
1
SELECT c0_.id AS id_0, c0_.titre AS titre_1, c0_.url AS url_2, c0_.description AS description_3, c0_.image AS image_4, c0_.resume AS resume_5, c0_.parent_id AS parent_id_6 FROM categorie c0_ WHERE c0_.titre LIKE ? OR c0_.description LIKE ? ORDER BY c0_.titre ASC
Parameters:
[
  "%finger%"
  "%finger%"
]
5.16 ms
(18.37%)
1
SELECT m0_.id AS id_0, m0_.nom AS nom_1, m0_.description AS description_2, m0_.presentation AS presentation_3, m0_.tarif AS tarif_4, m0_.code_sc AS code_sc_5, m0_.code_pa AS code_pa_6, m0_.archive AS archive_7, m0_.reference AS reference_8 FROM materiel m0_ WHERE m0_.archive = 0 AND ((m0_.description LIKE ? OR m0_.presentation LIKE ?)) ORDER BY m0_.nom ASC
Parameters:
[
  "%finger%"
  "%finger%"
]
3.35 ms
(11.93%)
1
SELECT m0_.id AS id_0, m0_.nom AS nom_1, m0_.description AS description_2, m0_.presentation AS presentation_3, m0_.tarif AS tarif_4, m0_.code_sc AS code_sc_5, m0_.code_pa AS code_pa_6, m0_.archive AS archive_7, m0_.reference AS reference_8 FROM materiel m0_ WHERE m0_.archive = 0 AND m0_.nom LIKE ? ORDER BY m0_.nom ASC
Parameters:
[
  "%finger%"
]
2.75 ms
(9.80%)
1
SELECT a0_.id AS id_0, a0_.titre AS titre_1, a0_.dtpubli AS dtpubli_2, a0_.description AS description_3, a0_.url AS url_4, a0_.content AS content_5 FROM article a0_ WHERE a0_.titre LIKE ? OR a0_.content LIKE ? OR a0_.description LIKE ? ORDER BY a0_.titre ASC
Parameters:
[
  "%finger%"
  "%finger%"
  "%finger%"
]
2.34 ms
(8.32%)
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_ WHERE p0_.archive = 0 AND p0_.titre LIKE ? ORDER BY p0_.titre ASC
Parameters:
[
  "%finger%"
]

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\Protocole
  • The association App\Entity\Protocole#commentaires refers to the owning side field App\Entity\Commentaire#protocoles which does not exist.
App\Entity\Commentaire
  • The mappings App\Entity\Commentaire#protocole and App\Entity\Protocole#commentaires are inconsistent with each other.
App\Entity\Protocoleinstrimg No errors.
App\Entity\Protocolephoto No errors.
App\Entity\Materiel No errors.
App\Entity\Article No errors.