Query Metrics
11
Database Queries
11
Different statements
7.57 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.59 ms |
SELECT t0.id AS id_1, t0.ordre AS ordre_2, t0.libelle AS libelle_3, t0.kind AS kind_4, t0.type_api AS type_api_5, t0.url AS url_6 FROM menu_libelle t0 WHERE t0.ordre = ?
Parameters:
[
0
]
|
| 2 | 0.49 ms |
SELECT m0_.libelle AS libelle_0, m0_.url AS url_1 FROM menu_libelle m0_ WHERE m0_.ordre <> 0 ORDER BY m0_.ordre ASC
Parameters:
[] |
| 3 | 0.63 ms |
SELECT t0.id AS id_1, t0.adresse AS adresse_2, t0.lien_acceo AS lien_acceo_3, t0.telephone AS telephone_4, t0.telephone_url AS telephone_url_5, t0.reseaux_sociaux AS reseaux_sociaux_6 FROM footer t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 4 | 0.84 ms |
SELECT c0_.id AS id_0, c0_.first_name AS first_name_1, c0_.last_name AS last_name_2, c0_.picture AS picture_3, c0_.short_description AS short_description_4, c0_.long_description AS long_description_5, c0_.display_address AS display_address_6, c0_.email AS email_7, c0_.phone AS phone_8, c0_.acceo AS acceo_9, c0_.link_1 AS link_1_10, c0_.link_2 AS link_2_11, c0_.rue AS rue_12, c0_.code_postal AS code_postal_13, c0_.ville AS ville_14, c0_.lat AS lat_15, c0_.lng AS lng_16, c0_.type AS type_17, c0_.slug AS slug_18, c0_.date_update AS date_update_19, c0_.active AS active_20, c0_.civilite AS civilite_21, c0_.territory_id AS territory_id_22, c0_.canton_id AS canton_id_23, c0_.type_contact_id AS type_contact_id_24 FROM contact c0_ WHERE c0_.slug = ?
Parameters:
[
"Jean-Noël-VERFAILLIE"
]
|
| 5 | 1.08 ms |
SELECT t0.id AS id_1, t0.illustrationfil_name AS illustrationfil_name_2, t0.illustrationdetail_name AS illustrationdetail_name_3, t0.document_name1 AS document_name1_4, t0.document_name2 AS document_name2_5, t0.document_name3 AS document_name3_6, t0.image_url AS image_url_7, t0.thumb_url AS thumb_url_8, t0.title AS title_9, t0.short_description AS short_description_10, t0.content_duration AS content_duration_11, t0.restriction AS restriction_12, t0.state AS state_13, t0.suggested_by AS suggested_by_14, t0.published_at AS published_at_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.link1 AS link1_18, t0.url1 AS url1_19, t0.link2 AS link2_20, t0.url2 AS url2_21, t0.link3 AS link3_22, t0.url3 AS url3_23, t0.date_debut AS date_debut_24, t0.date_fin AS date_fin_25, t0.commentaires AS commentaires_26, t0.subtitle AS subtitle_27, t0.chapo AS chapo_28, t0.horaires AS horaires_29, t0.tarifs AS tarifs_30, t0.lieu AS lieu_31, t0.ville AS ville_32, t0.credits AS credits_33, t0.content AS content_34, t0.defaut_fil AS defaut_fil_35, t0.epingle1 AS epingle1_36, t0.epingle2 AS epingle2_37, t0.organized_by AS organized_by_38, t0.bool_date_maj AS bool_date_maj_39, t0.updated_date_display AS updated_date_display_40, t0.slug AS slug_41, t0.date_dernier_statut AS date_dernier_statut_42, t0.duree AS duree_43, t0.bool_actu AS bool_actu_44, t0.grand_format AS grand_format_45, t0.like_count AS like_count_46, t0.comment_count AS comment_count_47, t0.in_use AS in_use_48, t0.edit_date AS edit_date_49, t0.organisation4 AS organisation4_50, t0.affichage_type_map AS affichage_type_map_51, t0.affichage_type_map2 AS affichage_type_map2_52, t0.affichage_type_map3 AS affichage_type_map3_53, t0.musee_name AS musee_name_54, t0.musee_id AS musee_id_55, t0.order_folder AS order_folder_56, t0.order_tag AS order_tag_57, t0.openagenda_id AS openagenda_id_58, t0.archive AS archive_59, t0.date_update AS date_update_60, t0.json AS json_61, t0.openagenda_lieu AS openagenda_lieu_62, t0.openagenda_name AS openagenda_name_63, t0.markdown_description AS markdown_description_64, t0.musee_type AS musee_type_65, t0.type_id AS type_id_66, t0.created_by_id AS created_by_id_67, t0.updated_by_id AS updated_by_id_68, t0.status_id AS status_id_69, t0.contact1_id AS contact1_id_70, t0.contact2_id AS contact2_id_71, t0.contact3_id AS contact3_id_72, t0.organisation1_id AS organisation1_id_73, t0.organisation2_id AS organisation2_id_74, t0.organisation3_id AS organisation3_id_75, t0.related_post1_id AS related_post1_id_76, t0.related_post2_id AS related_post2_id_77, t0.related_post3_id AS related_post3_id_78, t0.palettecouleur_id AS palettecouleur_id_79, t0.old_status_id AS old_status_id_80, t0.edit_user_id AS edit_user_id_81, t0.position_image_id AS position_image_id_82, t0.lieu_new_id AS lieu_new_id_83, t0.couleur_id AS couleur_id_84, t0.couleur_mode_nuit_id AS couleur_mode_nuit_id_85, t0.couleur_texte_id AS couleur_texte_id_86 FROM post t0 WHERE t0.contact1_id = ?
Parameters:
[
126
]
|
| 6 | 0.87 ms |
SELECT t0.id AS id_1, t0.illustrationfil_name AS illustrationfil_name_2, t0.illustrationdetail_name AS illustrationdetail_name_3, t0.document_name1 AS document_name1_4, t0.document_name2 AS document_name2_5, t0.document_name3 AS document_name3_6, t0.image_url AS image_url_7, t0.thumb_url AS thumb_url_8, t0.title AS title_9, t0.short_description AS short_description_10, t0.content_duration AS content_duration_11, t0.restriction AS restriction_12, t0.state AS state_13, t0.suggested_by AS suggested_by_14, t0.published_at AS published_at_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.link1 AS link1_18, t0.url1 AS url1_19, t0.link2 AS link2_20, t0.url2 AS url2_21, t0.link3 AS link3_22, t0.url3 AS url3_23, t0.date_debut AS date_debut_24, t0.date_fin AS date_fin_25, t0.commentaires AS commentaires_26, t0.subtitle AS subtitle_27, t0.chapo AS chapo_28, t0.horaires AS horaires_29, t0.tarifs AS tarifs_30, t0.lieu AS lieu_31, t0.ville AS ville_32, t0.credits AS credits_33, t0.content AS content_34, t0.defaut_fil AS defaut_fil_35, t0.epingle1 AS epingle1_36, t0.epingle2 AS epingle2_37, t0.organized_by AS organized_by_38, t0.bool_date_maj AS bool_date_maj_39, t0.updated_date_display AS updated_date_display_40, t0.slug AS slug_41, t0.date_dernier_statut AS date_dernier_statut_42, t0.duree AS duree_43, t0.bool_actu AS bool_actu_44, t0.grand_format AS grand_format_45, t0.like_count AS like_count_46, t0.comment_count AS comment_count_47, t0.in_use AS in_use_48, t0.edit_date AS edit_date_49, t0.organisation4 AS organisation4_50, t0.affichage_type_map AS affichage_type_map_51, t0.affichage_type_map2 AS affichage_type_map2_52, t0.affichage_type_map3 AS affichage_type_map3_53, t0.musee_name AS musee_name_54, t0.musee_id AS musee_id_55, t0.order_folder AS order_folder_56, t0.order_tag AS order_tag_57, t0.openagenda_id AS openagenda_id_58, t0.archive AS archive_59, t0.date_update AS date_update_60, t0.json AS json_61, t0.openagenda_lieu AS openagenda_lieu_62, t0.openagenda_name AS openagenda_name_63, t0.markdown_description AS markdown_description_64, t0.musee_type AS musee_type_65, t0.type_id AS type_id_66, t0.created_by_id AS created_by_id_67, t0.updated_by_id AS updated_by_id_68, t0.status_id AS status_id_69, t0.contact1_id AS contact1_id_70, t0.contact2_id AS contact2_id_71, t0.contact3_id AS contact3_id_72, t0.organisation1_id AS organisation1_id_73, t0.organisation2_id AS organisation2_id_74, t0.organisation3_id AS organisation3_id_75, t0.related_post1_id AS related_post1_id_76, t0.related_post2_id AS related_post2_id_77, t0.related_post3_id AS related_post3_id_78, t0.palettecouleur_id AS palettecouleur_id_79, t0.old_status_id AS old_status_id_80, t0.edit_user_id AS edit_user_id_81, t0.position_image_id AS position_image_id_82, t0.lieu_new_id AS lieu_new_id_83, t0.couleur_id AS couleur_id_84, t0.couleur_mode_nuit_id AS couleur_mode_nuit_id_85, t0.couleur_texte_id AS couleur_texte_id_86 FROM post t0 WHERE t0.contact2_id = ?
Parameters:
[
126
]
|
| 7 | 0.82 ms |
SELECT t0.id AS id_1, t0.illustrationfil_name AS illustrationfil_name_2, t0.illustrationdetail_name AS illustrationdetail_name_3, t0.document_name1 AS document_name1_4, t0.document_name2 AS document_name2_5, t0.document_name3 AS document_name3_6, t0.image_url AS image_url_7, t0.thumb_url AS thumb_url_8, t0.title AS title_9, t0.short_description AS short_description_10, t0.content_duration AS content_duration_11, t0.restriction AS restriction_12, t0.state AS state_13, t0.suggested_by AS suggested_by_14, t0.published_at AS published_at_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.link1 AS link1_18, t0.url1 AS url1_19, t0.link2 AS link2_20, t0.url2 AS url2_21, t0.link3 AS link3_22, t0.url3 AS url3_23, t0.date_debut AS date_debut_24, t0.date_fin AS date_fin_25, t0.commentaires AS commentaires_26, t0.subtitle AS subtitle_27, t0.chapo AS chapo_28, t0.horaires AS horaires_29, t0.tarifs AS tarifs_30, t0.lieu AS lieu_31, t0.ville AS ville_32, t0.credits AS credits_33, t0.content AS content_34, t0.defaut_fil AS defaut_fil_35, t0.epingle1 AS epingle1_36, t0.epingle2 AS epingle2_37, t0.organized_by AS organized_by_38, t0.bool_date_maj AS bool_date_maj_39, t0.updated_date_display AS updated_date_display_40, t0.slug AS slug_41, t0.date_dernier_statut AS date_dernier_statut_42, t0.duree AS duree_43, t0.bool_actu AS bool_actu_44, t0.grand_format AS grand_format_45, t0.like_count AS like_count_46, t0.comment_count AS comment_count_47, t0.in_use AS in_use_48, t0.edit_date AS edit_date_49, t0.organisation4 AS organisation4_50, t0.affichage_type_map AS affichage_type_map_51, t0.affichage_type_map2 AS affichage_type_map2_52, t0.affichage_type_map3 AS affichage_type_map3_53, t0.musee_name AS musee_name_54, t0.musee_id AS musee_id_55, t0.order_folder AS order_folder_56, t0.order_tag AS order_tag_57, t0.openagenda_id AS openagenda_id_58, t0.archive AS archive_59, t0.date_update AS date_update_60, t0.json AS json_61, t0.openagenda_lieu AS openagenda_lieu_62, t0.openagenda_name AS openagenda_name_63, t0.markdown_description AS markdown_description_64, t0.musee_type AS musee_type_65, t0.type_id AS type_id_66, t0.created_by_id AS created_by_id_67, t0.updated_by_id AS updated_by_id_68, t0.status_id AS status_id_69, t0.contact1_id AS contact1_id_70, t0.contact2_id AS contact2_id_71, t0.contact3_id AS contact3_id_72, t0.organisation1_id AS organisation1_id_73, t0.organisation2_id AS organisation2_id_74, t0.organisation3_id AS organisation3_id_75, t0.related_post1_id AS related_post1_id_76, t0.related_post2_id AS related_post2_id_77, t0.related_post3_id AS related_post3_id_78, t0.palettecouleur_id AS palettecouleur_id_79, t0.old_status_id AS old_status_id_80, t0.edit_user_id AS edit_user_id_81, t0.position_image_id AS position_image_id_82, t0.lieu_new_id AS lieu_new_id_83, t0.couleur_id AS couleur_id_84, t0.couleur_mode_nuit_id AS couleur_mode_nuit_id_85, t0.couleur_texte_id AS couleur_texte_id_86 FROM post t0 WHERE t0.contact3_id = ?
Parameters:
[
126
]
|
| 8 | 0.63 ms |
SELECT t0.id AS id_1, t0.titre AS titre_2, t0.active AS active_3, t0.couleur AS couleur_4, t0.contenu AS contenu_5, t0.visible_nordinfo AS visible_nordinfo_6, t0.visible_lenord AS visible_lenord_7, t0.visible_services AS visible_services_8, t0.visible_section_politiques AS visible_section_politiques_9, t0.visible_section_institution AS visible_section_institution_10, t0.visible_section_services AS visible_section_services_11, t0.visible_accueil_lenord AS visible_accueil_lenord_12, t0.visible_accueil_services AS visible_accueil_services_13, t0.visible_espace_documentaire AS visible_espace_documentaire_14, t0.visible_pages_legales_lenord AS visible_pages_legales_lenord_15, t0.visible_pages_legales_services AS visible_pages_legales_services_16, t0.visible_pages_legales_nordinfo AS visible_pages_legales_nordinfo_17, t0.visible_glossaire_lenord AS visible_glossaire_lenord_18, t0.visible_glossaire_services AS visible_glossaire_services_19, t0.visible_mesinfos AS visible_mesinfos_20, t0.visible_a_la_une AS visible_a_la_une_21, t0.visible_agenda AS visible_agenda_22, t0.visible_videos AS visible_videos_23, t0.visible_nordinfo_ledepartement AS visible_nordinfo_ledepartement_24, t0.visible_cartographie AS visible_cartographie_25, t0.color_id AS color_id_26 FROM epingle t0 WHERE t0.active = ? AND t0.visible_nordinfo = ?
Parameters:
[ 1 1 ] |
| 9 | 0.58 ms |
SELECT t0.id AS id_1, t0.name AS name_2 FROM type_contact t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 10 | 0.58 ms |
SELECT t0.id AS id_1, t0.canton AS canton_2, t0.territoire AS territoire_3, t0.communes AS communes_4, t0.multipoints AS multipoints_5, t0.territory_id AS territory_id_6 FROM cantons t0 WHERE t0.id = ?
Parameters:
[
39
]
|
| 11 | 0.48 ms |
SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.kind AS kind_3, t0.ordre AS ordre_4 FROM territory t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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\MenuLibelle | No errors. |
| App\Entity\Footer | No errors. |
| App\Entity\Contact | No errors. |
| App\Entity\Territory | No errors. |
| App\Entity\Cantons | No errors. |
| App\Entity\TypeContact | No errors. |
| App\Entity\Post | No errors. |
| App\Entity\Pages | No errors. |
| App\Entity\Citation | No errors. |
| App\Entity\PolitiqueDepartementale | No errors. |
| App\Entity\PageSatellite | No errors. |
| App\Entity\PostType | No errors. |
| App\Entity\User | No errors. |
| App\Entity\Statut | No errors. |
| App\Entity\Organization | No errors. |
| App\Entity\PaletteCouleur | No errors. |
| App\Entity\PlacementImage | No errors. |
| App\Entity\Lieu | No errors. |
| App\Entity\CouleurDePost | No errors. |
| App\Entity\Epingle | No errors. |
| App\Entity\EpingleColor | No errors. |
| App\Entity\RssArticle | No errors. |
| App\Entity\RssEvent | No errors. |
| App\Entity\Commune | No errors. |