Query Metrics
175
Database Queries
10
Different statements
9.32 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
7.68 ms (82.37%) |
160 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.type_lien AS type_lien_3, t0.lien AS lien_4, t0.position AS position_5, t0.type_fichier AS type_fichier_6, t0.gallery_type AS gallery_type_7, t0.niveau_id AS niveau_id_8, t0.rubric_id AS rubric_id_9, t0.parent_id AS parent_id_10 FROM menu_item t0 WHERE t0.parent_id = ?
Parameters:
[
1
]
|
|
0.53 ms (5.70%) |
7 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.type_lien AS type_lien_3, t0.lien AS lien_4, t0.position AS position_5, t0.type_fichier AS type_fichier_6, t0.gallery_type AS gallery_type_7, t0.niveau_id AS niveau_id_8, t0.rubric_id AS rubric_id_9, t0.parent_id AS parent_id_10 FROM menu_item t0 WHERE t0.rubric_id = ? ORDER BY t0.position ASC
Parameters:
[
1
]
|
|
0.22 ms (2.41%) |
1 |
SELECT t0.id AS id_1, t0.nom AS nom_2, t0.created_at AS created_at_3, t0.slug AS slug_4, t0.position AS position_5, t0.lien AS lien_6, t0.type_lien AS type_lien_7, t0.type_fichier AS type_fichier_8, t0.gallery_type AS gallery_type_9 FROM rubrics t0
Parameters:
[] |
|
0.22 ms (2.40%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.image AS image_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.prenom AS prenom_6, t0.nom_famille AS nom_famille_7, t0.email AS email_8, t0.telephone AS telephone_9, t0.lien_bouton AS lien_bouton_10, t0.is_actu AS is_actu_11, t0.caroussel AS caroussel_12, t0.description AS description_13, t0.type_lien_bouton AS type_lien_bouton_14, t0.gabarit AS gabarit_15, t0.vues AS vues_16, t0.texte_libre AS texte_libre_17, t0.img_description AS img_description_18, t0.img_long_description AS img_long_description_19, t0.is_actu_visible AS is_actu_visible_20, t0.special AS special_21, t0.user_id AS user_id_22, t0.seo_id AS seo_id_23, t24.id AS id_25, t24.titre AS titre_26, t24.clefs AS clefs_27, t24.description AS description_28, t0.menu_footer_id AS menu_footer_id_29, t30.id AS id_31, t30.vues AS vues_32, t30.created_at AS created_at_33, t30.updated_at AS updated_at_34, t30.page_id AS page_id_35 FROM page t0 LEFT JOIN seo t24 ON t0.seo_id = t24.id LEFT JOIN analytics t30 ON t30.page_id = t0.id WHERE t0.is_actu = ? AND t0.caroussel = ? ORDER BY t0.created_at DESC LIMIT 6
Parameters:
[ 1 1 ] |
|
0.19 ms (2.05%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.clefs AS clefs_3, t0.description AS description_4, t0.actif AS actif_5 FROM seo_accueil t0 WHERE t0.actif = ? LIMIT 1
Parameters:
[
1
]
|
|
0.17 ms (1.88%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.contenu AS contenu_3, t0.afficher AS afficher_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6 FROM banniere t0
Parameters:
[] |
|
0.10 ms (1.09%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.visible AS visible_3, t0.lien AS lien_4, t0.type_lien AS type_lien_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7, t0.image_type AS image_type_8, t0.image AS image_9, t0.pictogramme AS pictogramme_10, t0.position AS position_11, t0.text_alternatif AS text_alternatif_12 FROM damier t0 WHERE t0.visible = ? ORDER BY t0.position ASC
Parameters:
[
1
]
|
|
0.10 ms (1.06%) |
1 |
SELECT t0.id AS id_1, t0.pictogramme AS pictogramme_2, t0.description AS description_3, t0.nombre AS nombre_4, t0.lien AS lien_5, t0.type_lien AS type_lien_6, t0.type_image AS type_image_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.visible AS visible_10, t0.count_auto AS count_auto_11, t0.text_alternatif AS text_alternatif_12 FROM chiffres_clefs t0 WHERE t0.visible = ?
Parameters:
[
1
]
|
|
0.05 ms (0.51%) |
1 |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.actif AS actif_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM titre_accueil t0 WHERE t0.actif = ? LIMIT 1
Parameters:
[
1
]
|
|
0.05 ms (0.51%) |
1 |
SELECT t0.id AS id_1, t0.lien AS lien_2, t0.type AS type_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.titre AS titre_6 FROM brief t0 ORDER BY t0.created_at ASC
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\Banniere | No errors. |
| App\Entity\Brief | No errors. |
| App\Entity\Damier | No errors. |
| App\Entity\Page | No errors. |
| App\Entity\TitreAccueil | No errors. |
| App\Entity\SeoAccueil | No errors. |
| App\Entity\ChiffresClefs | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Seo | No errors. |
| App\Entity\MenuFooter | No errors. |
| App\Entity\Analytics | No errors. |
| App\Entity\Blocs | No errors. |
| App\Entity\Pages | No errors. |
| App\Entity\NewsCategories | No errors. |
| App\Entity\Rubrics | No errors. |
| App\Entity\MenuItem | No errors. |
| App\Entity\Menu | No errors. |