https://axone-dev.wetd.fr/l-axone

Query Metrics

25 Database Queries
8 Different statements
19.26 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
12.94 ms
(67.20%)
3
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_.seo_breadcrumb AS seo_breadcrumb_31, c1_.og_title AS og_title_32, c1_.og_type AS og_type_33, c1_.og_description AS og_description_34, c1_.og_site_name AS og_site_name_35, c1_.twitter_card AS twitter_card_36, c1_.twitter_site AS twitter_site_37, c1_.twitter_title AS twitter_title_38, c1_.twitter_description AS twitter_description_39, c1_.twitter_creator AS twitter_creator_40, c1_.created_at AS created_at_41, c1_.updated_at AS updated_at_42, c2_.id AS id_43, c2_.name AS name_44, c2_.methods AS methods_45, c2_.path AS path_46, c2_.controller AS controller_47, c2_.defaults AS defaults_48, c2_.requirements AS requirements_49, c3_.id AS id_50, c3_.name AS name_51, c3_.information AS information_52, c3_.link_type AS link_type_53, c3_.link_value AS link_value_54, c3_.is_visible AS is_visible_55, c3_.lvl AS lvl_56, c3_.lft AS lft_57, c3_.rgt AS rgt_58, c3_.li_class AS li_class_59, c3_.ul_class AS ul_class_60, c3_.link_class AS link_class_61, c3_.icon_class AS icon_class_62, c3_.connected AS connected_63, c3_.role AS role_64, c3_.params AS params_65, c3_.blank AS blank_66, c3_.anchor AS anchor_67, c4_.id AS id_68, c4_.slug AS slug_69, c4_.label AS label_70, c4_.locale AS locale_71, c4_.host AS host_72, c4_.localhost AS localhost_73, c4_.host_multilingual AS host_multilingual_74, c4_.`default` AS default_75, c4_.flag_icon AS flag_icon_76, c4_.visible AS visible_77, c4_.template_filter AS template_filter_78, c5_.id AS id_79, c5_.code AS code_80, c5_.label AS label_81, c5_.type AS type_82, c5_.value AS value_83, c5_.position AS position_84, c5_.parent_heritance AS parent_heritance_85, c5_.active AS active_86, c0_.page_id AS page_id_87, c0_.tree_root AS tree_root_88, c0_.parent_id AS parent_id_89, c0_.menu_id AS menu_id_90, c1_.route_id AS route_id_91, c1_.site_id AS site_id_92, c1_.tree_root AS tree_root_93, c1_.parent_id AS parent_id_94, c1_.og_image_id AS og_image_id_95, c1_.twitter_image_id AS twitter_image_id_96, c2_.discr AS discr_97, c3_.page_id AS page_id_98, c3_.tree_root AS tree_root_99, c3_.parent_id AS parent_id_100, c3_.menu_id AS menu_id_101, c5_.page_id AS page_id_102, c5_.shared_block_parent_id AS shared_block_parent_id_103, c5_.declination_id AS declination_id_104 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.44 ms
(7.47%)
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_.seo_breadcrumb AS seo_breadcrumb_13, c0_.og_title AS og_title_14, c0_.og_type AS og_type_15, c0_.og_description AS og_description_16, c0_.og_site_name AS og_site_name_17, c0_.twitter_card AS twitter_card_18, c0_.twitter_site AS twitter_site_19, c0_.twitter_title AS twitter_title_20, c0_.twitter_description AS twitter_description_21, c0_.twitter_creator AS twitter_creator_22, c0_.created_at AS created_at_23, c0_.updated_at AS updated_at_24, c1_.id AS id_25, c1_.name AS name_26, c1_.methods AS methods_27, c1_.path AS path_28, c1_.controller AS controller_29, c1_.defaults AS defaults_30, c1_.requirements AS requirements_31, c2_.id AS id_32, c2_.slug AS slug_33, c2_.label AS label_34, c2_.locale AS locale_35, c2_.host AS host_36, c2_.localhost AS localhost_37, c2_.host_multilingual AS host_multilingual_38, c2_.`default` AS default_39, c2_.flag_icon AS flag_icon_40, c2_.visible AS visible_41, c2_.template_filter AS template_filter_42, c3_.id AS id_43, c3_.title AS title_44, c3_.technic_name AS technic_name_45, c3_.locale AS locale_46, c3_.active AS active_47, c3_.params AS params_48, c3_.seo_title AS seo_title_49, c3_.seo_description AS seo_description_50, c3_.seo_keywords AS seo_keywords_51, c3_.seo_breadcrumb AS seo_breadcrumb_52, c3_.og_title AS og_title_53, c3_.og_type AS og_type_54, c3_.og_description AS og_description_55, c3_.og_site_name AS og_site_name_56, c3_.twitter_card AS twitter_card_57, c3_.twitter_site AS twitter_site_58, c3_.twitter_title AS twitter_title_59, c3_.twitter_description AS twitter_description_60, c3_.twitter_creator AS twitter_creator_61, c0_.route_id AS route_id_62, c0_.site_id AS site_id_63, c0_.tree_root AS tree_root_64, c0_.parent_id AS parent_id_65, c0_.og_image_id AS og_image_id_66, c0_.twitter_image_id AS twitter_image_id_67, c1_.discr AS discr_68, c3_.page_id AS page_id_69, c3_.og_image_id AS og_image_id_70, c3_.twitter_image_id AS twitter_image_id_71 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:
[
  "cms_route_5"
]
1.07 ms
(5.54%)
6
SELECT t0.id AS id_1, t0.label AS label_2, t0.category AS category_3, t0.file_name AS file_name_4, t0.mime_type AS mime_type_5, t0.extension AS extension_6, t0.crop_data AS crop_data_7, t0.description AS description_8, t0.permalink AS permalink_9, t0.alt AS alt_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12 FROM wd_media__media t0 WHERE t0.id = ?
Parameters:
[
  48
]
0.95 ms
(4.92%)
3
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 = ? LIMIT 1
Parameters:
[
  "main_menu"
]
0.88 ms
(4.55%)
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:
[
  "banner"
  5
]
0.80 ms
(4.15%)
3
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.75 ms
(3.89%)
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.44 ms
(2.28%)
1
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.seo_breadcrumb AS seo_breadcrumb_14, t0.og_title AS og_title_15, t0.og_type AS og_type_16, t0.og_description AS og_description_17, t0.og_site_name AS og_site_name_18, t0.twitter_card AS twitter_card_19, t0.twitter_site AS twitter_site_20, t0.twitter_title AS twitter_title_21, t0.twitter_description AS twitter_description_22, t0.twitter_creator AS twitter_creator_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.route_id AS route_id_26, t0.site_id AS site_id_27, t0.tree_root AS tree_root_28, t0.parent_id AS parent_id_29, t0.og_image_id AS og_image_id_30, t0.twitter_image_id AS twitter_image_id_31 FROM cms__page 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\Partner No errors.
WebEtDesign\ParameterBundle\Entity\Parameter No errors.
WebEtDesign\CmsBundle\Entity\CmsPage No errors.
WebEtDesign\CmsBundle\Entity\AbstractCmsRoute No errors.
WebEtDesign\CmsBundle\Entity\CmsRoute No errors.
WebEtDesign\CmsBundle\Entity\CmsSite No errors.
WebEtDesign\CmsBundle\Entity\CmsPageDeclination No errors.
WebEtDesign\MediaBundle\Entity\Media No errors.
WebEtDesign\CmsBundle\Entity\CmsContent No errors.
WebEtDesign\CmsBundle\Entity\CmsMenuItem No errors.
WebEtDesign\CmsBundle\Entity\CmsMenu No errors.
WebEtDesign\CmsBundle\Entity\CmsSharedBlock No errors.