Query Metrics
6
Database Queries
6
Different statements
28.10 ms
Query time
2
Invalid entities
Grouped Statements
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 |
|
App\Entity\Commentaire |
|
App\Entity\Protocoleinstrimg | No errors. |
App\Entity\Protocolephoto | No errors. |
App\Entity\Materiel | No errors. |
App\Entity\Article | No errors. |