Query Metrics
20
Database Queries
13
Different statements
25.89 ms
Query time
2
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
5.10 ms (19.69%) |
4 |
SELECT t0.id AS id_1, t0.route AS route_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.libelles_traduits AS libelles_traduits_5, t0.langue_id AS langue_id_6 FROM traduction t0 WHERE t0.route = ? AND t0.langue_id = ? LIMIT 1
Parameters:
[ "footer" 1 ]
|
||||||||||||||||||||||
|
4.95 ms (19.12%) |
4 |
SELECT t0.id AS id_1, t0.pays AS pays_2, t0.code AS code_3, t0.langue AS langue_4, t0.encodage AS encodage_5, t0.img AS img_6, t0.dir AS dir_7, t0.date_creation AS date_creation_8 FROM langue t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"FR"
]
|
||||||||||||||||||||||
|
2.78 ms (10.72%) |
2 |
SELECT t0.id AS id_1, t0.display_position AS display_position_2, t0.titre AS titre_3, t0.link AS link_4, t0.status AS status_5, t0.date_creation AS date_creation_6, t0.date_update AS date_update_7, t0.titre_fr AS titre_fr_8, t0.titre_en AS titre_en_9, t0.titre_de AS titre_de_10, t0.titre_be AS titre_be_11 FROM menu_links t0 WHERE t0.display_position = ? AND t0.status = ?
Parameters:
[ "footer_centre" "Actif" ]
|
||||||||||||||||||||||
|
1.89 ms (7.29%) |
1 |
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.nom AS nom_3, t0.cp AS cp_4, t0.date_creation AS date_creation_5, t0.date_update AS date_update_6, t0.pays_id AS pays_id_7, t0.region_id AS region_id_8 FROM departement t0 WHERE t0.pays_id = ? ORDER BY t0.nom ASC
Parameters:
[
75
]
|
||||||||||||||||||||||
|
1.68 ms (6.50%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.alpha2 AS alpha2_3, t0.alpha3 AS alpha3_4, t0.nom_en_gb AS nom_en_gb_5, t0.nom_fr_fr AS nom_fr_fr_6, t0.tva AS tva_7 FROM pays t0
Parameters:
[]
|
||||||||||||||||||||||
|
1.53 ms (5.92%) |
1 |
SELECT t0.id AS id_1, t0.contenu AS contenu_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.display_position AS display_position_5, t0.langue_id AS langue_id_6 FROM cgi t0 WHERE t0.langue_id = ? LIMIT 1
Parameters:
[
1
]
|
||||||||||||||||||||||
|
1.49 ms (5.75%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.icon AS icon_3, t0.dir AS dir_4, t0.link AS link_5, t0.status AS status_6, t0.display_position AS display_position_7, t0.date_creation AS date_creation_8, t0.date_update AS date_update_9 FROM social_links t0 WHERE t0.status = ?
Parameters:
[
"Actif"
]
|
||||||||||||||||||||||
|
1.43 ms (5.53%) |
1 |
SELECT t0.id AS id_1, t0.contenu AS contenu_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.display_position AS display_position_5, t0.langue_id AS langue_id_6 FROM condition_generale t0 WHERE t0.langue_id = ? LIMIT 1
Parameters:
[
1
]
|
||||||||||||||||||||||
|
1.30 ms (5.01%) |
1 |
SELECT t0.id AS id_1, t0.numero AS numero_2, t0.nom AS nom_3, t0.cp AS cp_4, t0.date_creation AS date_creation_5, t0.date_update AS date_update_6, t0.pays_id AS pays_id_7, t0.region_id AS region_id_8 FROM departement t0 WHERE t0.pays_id = ?
Parameters:
[
75
]
|
||||||||||||||||||||||
|
1.27 ms (4.91%) |
1 |
SELECT t0.id AS id_1, t0.pays AS pays_2, t0.code AS code_3, t0.langue AS langue_4, t0.encodage AS encodage_5, t0.img AS img_6, t0.dir AS dir_7, t0.date_creation AS date_creation_8 FROM langue t0
Parameters:
[]
|
||||||||||||||||||||||
|
1.05 ms (4.06%) |
1 |
SELECT t0.id AS id_1, t0.contenu AS contenu_2, t0.date_creation AS date_creation_3, t0.date_update AS date_update_4, t0.display_position AS display_position_5, t0.langue_id AS langue_id_6 FROM mentions_legales t0 WHERE t0.langue_id = ? LIMIT 1
Parameters:
[
1
]
|
||||||||||||||||||||||
|
0.90 ms (3.47%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.alpha2 AS alpha2_3, t0.alpha3 AS alpha3_4, t0.nom_en_gb AS nom_en_gb_5, t0.nom_fr_fr AS nom_fr_fr_6, t0.tva AS tva_7 FROM pays t0 WHERE t0.alpha2 = ? LIMIT 1
Parameters:
[
"FR"
]
|
||||||||||||||||||||||
|
0.53 ms (2.04%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.icon AS icon_3, t0.dir AS dir_4, t0.link AS link_5, t0.status AS status_6, t0.display_position AS display_position_7, t0.date_creation AS date_creation_8, t0.date_update AS date_update_9 FROM social_links t0 WHERE t0.link IS NULL
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\Langue |
|
| App\Entity\Traduction | No errors. |
| App\Entity\Pays | No errors. |
| App\Entity\Departement | No errors. |
| App\Entity\Region |
|
| App\Entity\MenuLinks | No errors. |
| App\Entity\SocialLinks | No errors. |
| App\Entity\ConditionGenerale | No errors. |
| App\Entity\Cgi | No errors. |
| App\Entity\MentionsLegales | No errors. |