Query Metrics
10
Database Queries
4
Different statements
16.57 ms
Query time
0
Invalid entities
62
Managed entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.47 ms |
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"
]
|
| 2 | 5.44 ms |
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_.no_index AS no_index_28, c1_.seo_title AS seo_title_29, c1_.seo_description AS seo_description_30, c1_.seo_keywords AS seo_keywords_31, c1_.seo_sitemap_priority AS seo_sitemap_priority_32, c1_.seo_sitemap_change_freq AS seo_sitemap_change_freq_33, c1_.og_title AS og_title_34, c1_.og_type AS og_type_35, c1_.og_description AS og_description_36, c1_.og_site_name AS og_site_name_37, c1_.twitter_card AS twitter_card_38, c1_.twitter_site AS twitter_site_39, c1_.twitter_title AS twitter_title_40, c1_.twitter_description AS twitter_description_41, c1_.twitter_creator AS twitter_creator_42, c1_.created_at AS created_at_43, c1_.updated_at AS updated_at_44, c2_.id AS id_45, c2_.name AS name_46, c2_.methods AS methods_47, c2_.path AS path_48, c2_.controller AS controller_49, c2_.defaults AS defaults_50, c2_.requirements AS requirements_51, c3_.id AS id_52, c3_.name AS name_53, c3_.information AS information_54, c3_.link_type AS link_type_55, c3_.link_value AS link_value_56, c3_.is_visible AS is_visible_57, c3_.lvl AS lvl_58, c3_.lft AS lft_59, c3_.rgt AS rgt_60, c3_.li_class AS li_class_61, c3_.ul_class AS ul_class_62, c3_.link_class AS link_class_63, c3_.icon_class AS icon_class_64, c3_.connected AS connected_65, c3_.role AS role_66, c3_.params AS params_67, c3_.blank AS blank_68, c3_.anchor AS anchor_69, c4_.id AS id_70, c4_.slug AS slug_71, c4_.label AS label_72, c4_.locale AS locale_73, c4_.host AS host_74, c4_.localhost AS localhost_75, c4_.host_multilingual AS host_multilingual_76, c4_.`default` AS default_77, c4_.flag_icon AS flag_icon_78, c4_.visible AS visible_79, c4_.template_filter AS template_filter_80, c5_.id AS id_81, c5_.code AS code_82, c5_.label AS label_83, c5_.type AS type_84, c5_.value AS value_85, c5_.position AS position_86, c5_.parent_heritance AS parent_heritance_87, c5_.active AS active_88, c0_.page_id AS page_id_89, c0_.tree_root AS tree_root_90, c0_.parent_id AS parent_id_91, c0_.menu_id AS menu_id_92, c1_.route_id AS route_id_93, c1_.site_id AS site_id_94, c1_.tree_root AS tree_root_95, c1_.parent_id AS parent_id_96, c1_.og_image_id AS og_image_id_97, c1_.twitter_image_id AS twitter_image_id_98, c2_.discr AS discr_99, c3_.page_id AS page_id_100, c3_.tree_root AS tree_root_101, c3_.parent_id AS parent_id_102, c3_.menu_id AS menu_id_103, c5_.page_id AS page_id_104, c5_.shared_block_parent_id AS shared_block_parent_id_105, c5_.declination_id AS declination_id_106 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:
[
54
]
|
| 3 | 0.38 ms |
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:
[
54
]
|
| 4 | 0.22 ms |
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_menu2"
]
|
| 5 | 4.37 ms |
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_.no_index AS no_index_28, c1_.seo_title AS seo_title_29, c1_.seo_description AS seo_description_30, c1_.seo_keywords AS seo_keywords_31, c1_.seo_sitemap_priority AS seo_sitemap_priority_32, c1_.seo_sitemap_change_freq AS seo_sitemap_change_freq_33, c1_.og_title AS og_title_34, c1_.og_type AS og_type_35, c1_.og_description AS og_description_36, c1_.og_site_name AS og_site_name_37, c1_.twitter_card AS twitter_card_38, c1_.twitter_site AS twitter_site_39, c1_.twitter_title AS twitter_title_40, c1_.twitter_description AS twitter_description_41, c1_.twitter_creator AS twitter_creator_42, c1_.created_at AS created_at_43, c1_.updated_at AS updated_at_44, c2_.id AS id_45, c2_.name AS name_46, c2_.methods AS methods_47, c2_.path AS path_48, c2_.controller AS controller_49, c2_.defaults AS defaults_50, c2_.requirements AS requirements_51, c3_.id AS id_52, c3_.name AS name_53, c3_.information AS information_54, c3_.link_type AS link_type_55, c3_.link_value AS link_value_56, c3_.is_visible AS is_visible_57, c3_.lvl AS lvl_58, c3_.lft AS lft_59, c3_.rgt AS rgt_60, c3_.li_class AS li_class_61, c3_.ul_class AS ul_class_62, c3_.link_class AS link_class_63, c3_.icon_class AS icon_class_64, c3_.connected AS connected_65, c3_.role AS role_66, c3_.params AS params_67, c3_.blank AS blank_68, c3_.anchor AS anchor_69, c4_.id AS id_70, c4_.slug AS slug_71, c4_.label AS label_72, c4_.locale AS locale_73, c4_.host AS host_74, c4_.localhost AS localhost_75, c4_.host_multilingual AS host_multilingual_76, c4_.`default` AS default_77, c4_.flag_icon AS flag_icon_78, c4_.visible AS visible_79, c4_.template_filter AS template_filter_80, c5_.id AS id_81, c5_.code AS code_82, c5_.label AS label_83, c5_.type AS type_84, c5_.value AS value_85, c5_.position AS position_86, c5_.parent_heritance AS parent_heritance_87, c5_.active AS active_88, c0_.page_id AS page_id_89, c0_.tree_root AS tree_root_90, c0_.parent_id AS parent_id_91, c0_.menu_id AS menu_id_92, c1_.route_id AS route_id_93, c1_.site_id AS site_id_94, c1_.tree_root AS tree_root_95, c1_.parent_id AS parent_id_96, c1_.og_image_id AS og_image_id_97, c1_.twitter_image_id AS twitter_image_id_98, c2_.discr AS discr_99, c3_.page_id AS page_id_100, c3_.tree_root AS tree_root_101, c3_.parent_id AS parent_id_102, c3_.menu_id AS menu_id_103, c5_.page_id AS page_id_104, c5_.shared_block_parent_id AS shared_block_parent_id_105, c5_.declination_id AS declination_id_106 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:
[
55
]
|
| 6 | 0.27 ms |
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:
[
55
]
|
| 7 | 0.35 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.methods AS methods_3, t0.path AS path_4, t0.controller AS controller_5, t0.defaults AS defaults_6, t0.requirements AS requirements_7, t8.id AS id_9, t8.title AS title_10, t8.template AS template_11, t8.slug AS slug_12, t8.breadcrumb AS breadcrumb_13, t8.active AS active_14, t8.roles AS roles_15, t8.lft AS lft_16, t8.lvl AS lvl_17, t8.rgt AS rgt_18, t8.no_index AS no_index_19, t8.seo_title AS seo_title_20, t8.seo_description AS seo_description_21, t8.seo_keywords AS seo_keywords_22, t8.seo_sitemap_priority AS seo_sitemap_priority_23, t8.seo_sitemap_change_freq AS seo_sitemap_change_freq_24, t8.og_title AS og_title_25, t8.og_type AS og_type_26, t8.og_description AS og_description_27, t8.og_site_name AS og_site_name_28, t8.twitter_card AS twitter_card_29, t8.twitter_site AS twitter_site_30, t8.twitter_title AS twitter_title_31, t8.twitter_description AS twitter_description_32, t8.twitter_creator AS twitter_creator_33, t8.created_at AS created_at_34, t8.updated_at AS updated_at_35, t8.route_id AS route_id_36, t8.site_id AS site_id_37, t8.tree_root AS tree_root_38, t8.parent_id AS parent_id_39, t8.og_image_id AS og_image_id_40, t8.twitter_image_id AS twitter_image_id_41, t0.discr FROM cms__route t0 LEFT JOIN cms__page t8 ON t8.route_id = t0.id WHERE t0.discr IN ('base')
Parameters:
[] |
| 8 | 0.28 ms |
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_menu3"
]
|
| 9 | 4.56 ms |
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_.no_index AS no_index_28, c1_.seo_title AS seo_title_29, c1_.seo_description AS seo_description_30, c1_.seo_keywords AS seo_keywords_31, c1_.seo_sitemap_priority AS seo_sitemap_priority_32, c1_.seo_sitemap_change_freq AS seo_sitemap_change_freq_33, c1_.og_title AS og_title_34, c1_.og_type AS og_type_35, c1_.og_description AS og_description_36, c1_.og_site_name AS og_site_name_37, c1_.twitter_card AS twitter_card_38, c1_.twitter_site AS twitter_site_39, c1_.twitter_title AS twitter_title_40, c1_.twitter_description AS twitter_description_41, c1_.twitter_creator AS twitter_creator_42, c1_.created_at AS created_at_43, c1_.updated_at AS updated_at_44, c2_.id AS id_45, c2_.name AS name_46, c2_.methods AS methods_47, c2_.path AS path_48, c2_.controller AS controller_49, c2_.defaults AS defaults_50, c2_.requirements AS requirements_51, c3_.id AS id_52, c3_.name AS name_53, c3_.information AS information_54, c3_.link_type AS link_type_55, c3_.link_value AS link_value_56, c3_.is_visible AS is_visible_57, c3_.lvl AS lvl_58, c3_.lft AS lft_59, c3_.rgt AS rgt_60, c3_.li_class AS li_class_61, c3_.ul_class AS ul_class_62, c3_.link_class AS link_class_63, c3_.icon_class AS icon_class_64, c3_.connected AS connected_65, c3_.role AS role_66, c3_.params AS params_67, c3_.blank AS blank_68, c3_.anchor AS anchor_69, c4_.id AS id_70, c4_.slug AS slug_71, c4_.label AS label_72, c4_.locale AS locale_73, c4_.host AS host_74, c4_.localhost AS localhost_75, c4_.host_multilingual AS host_multilingual_76, c4_.`default` AS default_77, c4_.flag_icon AS flag_icon_78, c4_.visible AS visible_79, c4_.template_filter AS template_filter_80, c5_.id AS id_81, c5_.code AS code_82, c5_.label AS label_83, c5_.type AS type_84, c5_.value AS value_85, c5_.position AS position_86, c5_.parent_heritance AS parent_heritance_87, c5_.active AS active_88, c0_.page_id AS page_id_89, c0_.tree_root AS tree_root_90, c0_.parent_id AS parent_id_91, c0_.menu_id AS menu_id_92, c1_.route_id AS route_id_93, c1_.site_id AS site_id_94, c1_.tree_root AS tree_root_95, c1_.parent_id AS parent_id_96, c1_.og_image_id AS og_image_id_97, c1_.twitter_image_id AS twitter_image_id_98, c2_.discr AS discr_99, c3_.page_id AS page_id_100, c3_.tree_root AS tree_root_101, c3_.parent_id AS parent_id_102, c3_.menu_id AS menu_id_103, c5_.page_id AS page_id_104, c5_.shared_block_parent_id AS shared_block_parent_id_105, c5_.declination_id AS declination_id_106 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:
[
56
]
|
| 10 | 0.24 ms |
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:
[
56
]
|
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.
Managed Entities
default entity manager
| Class | Amount of managed objects |
|---|---|
| WebEtDesign\CmsBundle\Entity\CmsContent | 20 |
| WebEtDesign\CmsBundle\Entity\CmsMenuItem | 16 |
| WebEtDesign\CmsBundle\Entity\CmsPage | 11 |
| WebEtDesign\CmsBundle\Entity\AbstractCmsRoute | 11 |
| WebEtDesign\CmsBundle\Entity\CmsMenu | 3 |
| WebEtDesign\CmsBundle\Entity\CmsSite | 1 |
Entities Mapping
| Class | Mapping errors |
|---|---|
| WebEtDesign\CmsBundle\Entity\CmsMenuItem | No errors. |
| WebEtDesign\CmsBundle\Entity\CmsMenu | No errors. |
| WebEtDesign\CmsBundle\Entity\CmsSite | No errors. |
| WebEtDesign\CmsBundle\Entity\CmsPage | No errors. |
| WebEtDesign\CmsBundle\Entity\AbstractCmsRoute | No errors. |
| WebEtDesign\CmsBundle\Entity\CmsRoute | No errors. |
| WebEtDesign\CmsBundle\Entity\CmsContent | No errors. |
| WebEtDesign\MediaBundle\Entity\Media | No errors. |
| WebEtDesign\CmsBundle\Entity\CmsSharedBlock | No errors. |
| WebEtDesign\CmsBundle\Entity\CmsPageDeclination | No errors. |