GET https://cce28.webetdesign.com/procedure/88

Query Metrics

22 Database Queries
12 Different statements
18.14 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
8.52 ms
(46.94%)
2
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.information AS information_2, c0_.link_type AS link_type_3, c0_.link_value AS link_value_4, c0_.is_visible AS is_visible_5, c0_.lvl AS lvl_6, c0_.lft AS lft_7, c0_.rgt AS rgt_8, c0_.li_class AS li_class_9, c0_.ul_class AS ul_class_10, c0_.link_class AS link_class_11, c0_.icon_class AS icon_class_12, c0_.connected AS connected_13, c0_.role AS role_14, c0_.params AS params_15, c0_.blank AS blank_16, c0_.anchor AS anchor_17, c1_.id AS id_18, c1_.title AS title_19, c1_.template AS template_20, c1_.slug AS slug_21, c1_.breadcrumb AS breadcrumb_22, c1_.active AS active_23, c1_.roles AS roles_24, c1_.lft AS lft_25, c1_.lvl AS lvl_26, c1_.rgt AS rgt_27, c1_.seo_title AS seo_title_28, c1_.seo_description AS seo_description_29, c1_.seo_keywords AS seo_keywords_30, c1_.og_title AS og_title_31, c1_.og_type AS og_type_32, c1_.og_description AS og_description_33, c1_.og_site_name AS og_site_name_34, c1_.twitter_card AS twitter_card_35, c1_.twitter_site AS twitter_site_36, c1_.twitter_title AS twitter_title_37, c1_.twitter_description AS twitter_description_38, c1_.twitter_creator AS twitter_creator_39, c1_.created_at AS created_at_40, c1_.updated_at AS updated_at_41, c2_.id AS id_42, c2_.name AS name_43, c2_.methods AS methods_44, c2_.path AS path_45, c2_.controller AS controller_46, c2_.defaults AS defaults_47, c2_.requirements AS requirements_48, c3_.id AS id_49, c3_.name AS name_50, c3_.information AS information_51, c3_.link_type AS link_type_52, c3_.link_value AS link_value_53, c3_.is_visible AS is_visible_54, c3_.lvl AS lvl_55, c3_.lft AS lft_56, c3_.rgt AS rgt_57, c3_.li_class AS li_class_58, c3_.ul_class AS ul_class_59, c3_.link_class AS link_class_60, c3_.icon_class AS icon_class_61, c3_.connected AS connected_62, c3_.role AS role_63, c3_.params AS params_64, c3_.blank AS blank_65, c3_.anchor AS anchor_66, c4_.id AS id_67, c4_.slug AS slug_68, c4_.label AS label_69, c4_.locale AS locale_70, c4_.host AS host_71, c4_.localhost AS localhost_72, c4_.host_multilingual AS host_multilingual_73, c4_.`default` AS default_74, c4_.flag_icon AS flag_icon_75, c4_.visible AS visible_76, c4_.template_filter AS template_filter_77, c5_.id AS id_78, c5_.code AS code_79, c5_.label AS label_80, c5_.type AS type_81, c5_.value AS value_82, c5_.position AS position_83, c5_.parent_heritance AS parent_heritance_84, c5_.active AS active_85, c0_.page_id AS page_id_86, c0_.tree_root AS tree_root_87, c0_.parent_id AS parent_id_88, c0_.menu_id AS menu_id_89, c1_.route_id AS route_id_90, c1_.site_id AS site_id_91, c1_.tree_root AS tree_root_92, c1_.parent_id AS parent_id_93, c1_.og_image_id AS og_image_id_94, c1_.twitter_image_id AS twitter_image_id_95, c2_.discr AS discr_96, c3_.page_id AS page_id_97, c3_.tree_root AS tree_root_98, c3_.parent_id AS parent_id_99, c3_.menu_id AS menu_id_100, c5_.page_id AS page_id_101, c5_.shared_block_parent_id AS shared_block_parent_id_102, c5_.declination_id AS declination_id_103 FROM cms__menu_item c0_ LEFT JOIN cms__page c1_ ON c0_.page_id = c1_.id LEFT JOIN cms__route c2_ ON c1_.route_id = c2_.id AND c2_.discr IN ('base') LEFT JOIN cms__menu_item c3_ ON c0_.id = c3_.parent_id LEFT JOIN cms__site c4_ ON c1_.site_id = c4_.id LEFT JOIN cms__content c5_ ON c1_.id = c5_.page_id WHERE c0_.menu_id = ? ORDER BY c0_.lft ASC, c3_.lft ASC, c5_.position ASC
Parameters:
[
  1
]
1.23 ms
(6.76%)
4
SELECT c0_.id AS id_0, c0_.code AS code_1, c0_.label AS label_2, c0_.type AS type_3, c0_.value AS value_4, c0_.position AS position_5, c0_.parent_heritance AS parent_heritance_6, c0_.active AS active_7, c0_.page_id AS page_id_8, c0_.shared_block_parent_id AS shared_block_parent_id_9, c0_.declination_id AS declination_id_10 FROM cms__content c0_ WHERE c0_.code = ? AND c0_.page_id = ? LIMIT 1
Parameters:
[
  "header_picture"
  30
]
1.21 ms
(6.69%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.logo AS logo_4, t0.domain AS domain_5, t0.matomo_id AS matomo_id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t9.id AS id_10, t9.title_edito AS title_edito_11, t9.subtitle_edito AS subtitle_edito_12, t9.picture_edito AS picture_edito_13, t9.content_edito AS content_edito_14, t9.button_edito AS button_edito_15, t9.link_button_edito AS link_button_edito_16, t9.title_highlight AS title_highlight_17, t9.subtitle_highlight AS subtitle_highlight_18, t9.picture_highlight AS picture_highlight_19, t9.content_highlight AS content_highlight_20, t9.button_highlight AS button_highlight_21, t9.link_button_highlight AS link_button_highlight_22, t9.created_at AS created_at_23, t9.updated_at AS updated_at_24, t9.box_id AS box_id_25, t26.id AS id_27, t26.title_menu AS title_menu_28, t26.slug AS slug_29, t26.title AS title_30, t26.subtitle AS subtitle_31, t26.picture_introduction AS picture_introduction_32, t26.introduction AS introduction_33, t26.content AS content_34, t26.created_at AS created_at_35, t26.updated_at AS updated_at_36, t26.box_id AS box_id_37, t38.id AS id_39, t38.title_menu AS title_menu_40, t38.slug AS slug_41, t38.title AS title_42, t38.subtitle AS subtitle_43, t38.picture_introduction AS picture_introduction_44, t38.introduction AS introduction_45, t38.content AS content_46, t38.created_at AS created_at_47, t38.updated_at AS updated_at_48, t38.box_id AS box_id_49, t50.id AS id_51, t50.title_menu AS title_menu_52, t50.title AS title_53, t50.subtitle AS subtitle_54, t50.picture_introduction AS picture_introduction_55, t50.introduction AS introduction_56, t50.content AS content_57, t50.created_at AS created_at_58, t50.updated_at AS updated_at_59, t50.box_id AS box_id_60, t61.id AS id_62, t61.title_menu AS title_menu_63, t61.title AS title_64, t61.subtitle AS subtitle_65, t61.picture_introduction AS picture_introduction_66, t61.introduction AS introduction_67, t61.content AS content_68, t61.created_at AS created_at_69, t61.updated_at AS updated_at_70, t61.box_id AS box_id_71, t72.id AS id_73, t72.title_menu AS title_menu_74, t72.title AS title_75, t72.subtitle AS subtitle_76, t72.picture_introduction AS picture_introduction_77, t72.introduction AS introduction_78, t72.content AS content_79, t72.created_at AS created_at_80, t72.updated_at AS updated_at_81, t72.box_id AS box_id_82 FROM box__box t0 LEFT JOIN box__home t9 ON t9.box_id = t0.id LEFT JOIN box__custom t26 ON t26.box_id = t0.id LEFT JOIN box__custom_2 t38 ON t38.box_id = t0.id LEFT JOIN box__team t50 ON t50.box_id = t0.id LEFT JOIN box__who_are_we t61 ON t61.box_id = t0.id LEFT JOIN box__why_join t72 ON t72.box_id = t0.id WHERE t0.domain = ? LIMIT 1
Parameters:
[
  "cce28.webetdesign.com"
]
1.17 ms
(6.42%)
1
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.template AS template_2, c0_.slug AS slug_3, c0_.breadcrumb AS breadcrumb_4, c0_.active AS active_5, c0_.roles AS roles_6, c0_.lft AS lft_7, c0_.lvl AS lvl_8, c0_.rgt AS rgt_9, c0_.seo_title AS seo_title_10, c0_.seo_description AS seo_description_11, c0_.seo_keywords AS seo_keywords_12, c0_.og_title AS og_title_13, c0_.og_type AS og_type_14, c0_.og_description AS og_description_15, c0_.og_site_name AS og_site_name_16, c0_.twitter_card AS twitter_card_17, c0_.twitter_site AS twitter_site_18, c0_.twitter_title AS twitter_title_19, c0_.twitter_description AS twitter_description_20, c0_.twitter_creator AS twitter_creator_21, c0_.created_at AS created_at_22, c0_.updated_at AS updated_at_23, c1_.id AS id_24, c1_.name AS name_25, c1_.methods AS methods_26, c1_.path AS path_27, c1_.controller AS controller_28, c1_.defaults AS defaults_29, c1_.requirements AS requirements_30, c2_.id AS id_31, c2_.slug AS slug_32, c2_.label AS label_33, c2_.locale AS locale_34, c2_.host AS host_35, c2_.localhost AS localhost_36, c2_.host_multilingual AS host_multilingual_37, c2_.`default` AS default_38, c2_.flag_icon AS flag_icon_39, c2_.visible AS visible_40, c2_.template_filter AS template_filter_41, c3_.id AS id_42, c3_.title AS title_43, c3_.technic_name AS technic_name_44, c3_.locale AS locale_45, c3_.active AS active_46, c3_.params AS params_47, c3_.seo_title AS seo_title_48, c3_.seo_description AS seo_description_49, c3_.seo_keywords AS seo_keywords_50, c3_.og_title AS og_title_51, c3_.og_type AS og_type_52, c3_.og_description AS og_description_53, c3_.og_site_name AS og_site_name_54, c3_.twitter_card AS twitter_card_55, c3_.twitter_site AS twitter_site_56, c3_.twitter_title AS twitter_title_57, c3_.twitter_description AS twitter_description_58, c3_.twitter_creator AS twitter_creator_59, c0_.route_id AS route_id_60, c0_.site_id AS site_id_61, c0_.tree_root AS tree_root_62, c0_.parent_id AS parent_id_63, c0_.og_image_id AS og_image_id_64, c0_.twitter_image_id AS twitter_image_id_65, c1_.discr AS discr_66, c3_.page_id AS page_id_67, c3_.og_image_id AS og_image_id_68, c3_.twitter_image_id AS twitter_image_id_69 FROM cms__page c0_ LEFT JOIN cms__route c1_ ON c0_.route_id = c1_.id AND c1_.discr IN ('base') LEFT JOIN cms__site c2_ ON c0_.site_id = c2_.id LEFT JOIN cms__page_declination c3_ ON c0_.id = c3_.page_id WHERE c1_.name = ?
Parameters:
[
  "show_enquiry"
]
1.16 ms
(6.39%)
1
SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.match_name AS match_name_2, d0_.code AS code_3, d0_.region_id AS region_id_4 FROM department d0_ ORDER BY d0_.name ASC
Parameters:
[]
1.14 ms
(6.27%)
4
SELECT t0.id AS id_1, t0.slug AS slug_2, t0.label AS label_3, t0.locale AS locale_4, t0.host AS host_5, t0.localhost AS localhost_6, t0.host_multilingual AS host_multilingual_7, t0.`default` AS default_8, t0.flag_icon AS flag_icon_9, t0.visible AS visible_10, t0.template_filter AS template_filter_11 FROM cms__site t0 WHERE t0.`default` = ? LIMIT 1
Parameters:
[
  1
]
0.95 ms
(5.22%)
2
SELECT t0.id AS id_1, t0.name AS name_2, t0.information AS information_3, t0.link_type AS link_type_4, t0.link_value AS link_value_5, t0.is_visible AS is_visible_6, t0.lvl AS lvl_7, t0.lft AS lft_8, t0.rgt AS rgt_9, t0.li_class AS li_class_10, t0.ul_class AS ul_class_11, t0.link_class AS link_class_12, t0.icon_class AS icon_class_13, t0.connected AS connected_14, t0.role AS role_15, t0.params AS params_16, t0.blank AS blank_17, t0.anchor AS anchor_18, t0.page_id AS page_id_19, t0.tree_root AS tree_root_20, t0.parent_id AS parent_id_21, t0.menu_id AS menu_id_22 FROM cms__menu_item t0 WHERE t0.menu_id = ?
Parameters:
[
  1
]
0.92 ms
(5.05%)
2
SELECT t0.id AS id_1, t0.title AS title_2, t0.template AS template_3, t0.slug AS slug_4, t0.breadcrumb AS breadcrumb_5, t0.active AS active_6, t0.roles AS roles_7, t0.lft AS lft_8, t0.lvl AS lvl_9, t0.rgt AS rgt_10, t0.seo_title AS seo_title_11, t0.seo_description AS seo_description_12, t0.seo_keywords AS seo_keywords_13, t0.og_title AS og_title_14, t0.og_type AS og_type_15, t0.og_description AS og_description_16, t0.og_site_name AS og_site_name_17, t0.twitter_card AS twitter_card_18, t0.twitter_site AS twitter_site_19, t0.twitter_title AS twitter_title_20, t0.twitter_description AS twitter_description_21, t0.twitter_creator AS twitter_creator_22, t0.created_at AS created_at_23, t0.updated_at AS updated_at_24, t0.route_id AS route_id_25, t0.site_id AS site_id_26, t0.tree_root AS tree_root_27, t0.parent_id AS parent_id_28, t0.og_image_id AS og_image_id_29, t0.twitter_image_id AS twitter_image_id_30 FROM cms__page t0 WHERE t0.id = ?
Parameters:
[
  29
]
0.68 ms
(3.77%)
2
SELECT t0.id AS id_1, t0.label AS label_2, t0.code AS code_3, t0.type AS type_4, t0.site_id AS site_id_5 FROM cms__menu t0 WHERE t0.code = ? AND t0.site_id = ? LIMIT 1
Parameters:
[
  "main_menu"
  1
]
0.55 ms
(3.05%)
1
SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.picture AS picture_4, t0.link AS link_5, t0.begin_date AS begin_date_6, t0.end_date AS end_date_7, t0.extension_date AS extension_date_8, t0.document_order_public_enquiry AS document_order_public_enquiry_9, t0.document_notice_public_enquiry AS document_notice_public_enquiry_10, t0.document_report_public_enquiry AS document_report_public_enquiry_11, t0.document_decision AS document_decision_12, t0.link_order_public_enquiry AS link_order_public_enquiry_13, t0.link_notice_public_enquiry AS link_notice_public_enquiry_14, t0.link_report_public_enquiry AS link_report_public_enquiry_15, t0.link_decision AS link_decision_16, t0.publication_status AS publication_status_17, t0.is_published AS is_published_18, t0.nb_persons_received AS nb_persons_received_19, t0.nb_observations_filed AS nb_observations_filed_20, t0.nb_observations_numeric AS nb_observations_numeric_21, t0.nb_observations_paper AS nb_observations_paper_22, t0.nb_observations_oral AS nb_observations_oral_23, t0.nb_public_meeting_done AS nb_public_meeting_done_24, t0.created_at AS created_at_25, t0.updated_at AS updated_at_26, t0.reportUpdatedAt AS reportUpdatedAt_27, t0.alert_sent_at AS alert_sent_at_28, t0.designation AS designation_29, t0.place AS place_30, t0.actors AS actors_31, t0.project_owner_type AS project_owner_type_32, t0.type_id AS type_id_33, t0.provider_id AS provider_id_34, t0.user_id AS user_id_35 FROM public_enquiry__public_enquiry t0 WHERE t0.id = ?
Parameters:
[
  "88"
]
0.42 ms
(2.32%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.match_name AS match_name_3, t0.code AS code_4, t0.region_id AS region_id_5 FROM department t0 INNER JOIN public_enquiry__public_enquiry_has_department ON t0.id = public_enquiry__public_enquiry_has_department.department_id WHERE public_enquiry__public_enquiry_has_department.public_enquiry_id = ?
Parameters:
[
  88
]
0.20 ms
(1.12%)
1
SELECT t0.id AS id_1, t0.title AS title_2 FROM public_enquiry__type t0 WHERE t0.id = ?
Parameters:
[
  6
]

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.