Query Metrics
22
Database Queries
10
Different statements
16.14 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.18 ms |
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_.no_index AS no_index_10, c0_.seo_title AS seo_title_11, c0_.seo_description AS seo_description_12, c0_.seo_keywords AS seo_keywords_13, c0_.seo_sitemap_priority AS seo_sitemap_priority_14, c0_.seo_sitemap_change_freq AS seo_sitemap_change_freq_15, c0_.og_title AS og_title_16, c0_.og_type AS og_type_17, c0_.og_description AS og_description_18, c0_.og_site_name AS og_site_name_19, c0_.twitter_card AS twitter_card_20, c0_.twitter_site AS twitter_site_21, c0_.twitter_title AS twitter_title_22, c0_.twitter_description AS twitter_description_23, c0_.twitter_creator AS twitter_creator_24, c0_.created_at AS created_at_25, c0_.updated_at AS updated_at_26, c1_.id AS id_27, c1_.name AS name_28, c1_.methods AS methods_29, c1_.path AS path_30, c1_.controller AS controller_31, c1_.defaults AS defaults_32, c1_.requirements AS requirements_33, c2_.id AS id_34, c2_.slug AS slug_35, c2_.label AS label_36, c2_.locale AS locale_37, c2_.host AS host_38, c2_.localhost AS localhost_39, c2_.host_multilingual AS host_multilingual_40, c2_.`default` AS default_41, c2_.flag_icon AS flag_icon_42, c2_.visible AS visible_43, c2_.template_filter AS template_filter_44, c3_.id AS id_45, c3_.title AS title_46, c3_.technic_name AS technic_name_47, c3_.locale AS locale_48, c3_.active AS active_49, c3_.params AS params_50, c3_.seo_title AS seo_title_51, c3_.seo_description AS seo_description_52, c3_.seo_keywords AS seo_keywords_53, c3_.seo_sitemap_priority AS seo_sitemap_priority_54, c3_.seo_sitemap_change_freq AS seo_sitemap_change_freq_55, c3_.og_title AS og_title_56, c3_.og_type AS og_type_57, c3_.og_description AS og_description_58, c3_.og_site_name AS og_site_name_59, c3_.twitter_card AS twitter_card_60, c3_.twitter_site AS twitter_site_61, c3_.twitter_title AS twitter_title_62, c3_.twitter_description AS twitter_description_63, c3_.twitter_creator AS twitter_creator_64, c0_.route_id AS route_id_65, c0_.site_id AS site_id_66, c0_.tree_root AS tree_root_67, c0_.parent_id AS parent_id_68, c0_.og_image_id AS og_image_id_69, c0_.twitter_image_id AS twitter_image_id_70, c1_.discr AS discr_71, c3_.page_id AS page_id_72, c3_.og_image_id AS og_image_id_73, c3_.twitter_image_id AS twitter_image_id_74 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:
[
"app_contact"
]
|
| 2 | 0.66 ms |
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.no_index AS no_index_11, t0.seo_title AS seo_title_12, t0.seo_description AS seo_description_13, t0.seo_keywords AS seo_keywords_14, t0.seo_sitemap_priority AS seo_sitemap_priority_15, t0.seo_sitemap_change_freq AS seo_sitemap_change_freq_16, t0.og_title AS og_title_17, t0.og_type AS og_type_18, t0.og_description AS og_description_19, t0.og_site_name AS og_site_name_20, t0.twitter_card AS twitter_card_21, t0.twitter_site AS twitter_site_22, t0.twitter_title AS twitter_title_23, t0.twitter_description AS twitter_description_24, t0.twitter_creator AS twitter_creator_25, t0.created_at AS created_at_26, t0.updated_at AS updated_at_27, t0.route_id AS route_id_28, t0.site_id AS site_id_29, t0.tree_root AS tree_root_30, t0.parent_id AS parent_id_31, t0.og_image_id AS og_image_id_32, t0.twitter_image_id AS twitter_image_id_33 FROM cms__page t0 WHERE t0.id = ?
Parameters:
[
1
]
|
| 3 | 0.39 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"
]
|
| 4 | 6.46 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:
[
1
]
|
| 5 | 0.33 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:
[
1
]
|
| 6 | 0.43 ms |
SELECT p0_.code AS code_0, p0_.type AS type_1, p0_.config AS config_2, p0_.label AS label_3, p0_.value AS value_4, p0_.deletable AS deletable_5 FROM parameter p0_ WHERE p0_.code = ?
Parameters:
[
"getting_started_url"
]
|
| 7 | 0.26 ms |
SELECT p0_.code AS code_0, p0_.type AS type_1, p0_.config AS config_2, p0_.label AS label_3, p0_.value AS value_4, p0_.deletable AS deletable_5 FROM parameter p0_ WHERE p0_.code = ?
Parameters:
[
"github_url"
]
|
| 8 | 0.35 ms |
SELECT p0_.code AS code_0, p0_.type AS type_1, p0_.config AS config_2, p0_.label AS label_3, p0_.value AS value_4, p0_.deletable AS deletable_5 FROM parameter p0_ WHERE p0_.code = ?
Parameters:
[
"github_support_url"
]
|
| 9 | 0.33 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:
[
"footer_menu"
]
|
| 10 | 4.02 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:
[
2
]
|
| 11 | 0.18 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:
[
2
]
|
| 12 | 0.11 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.active AS active_4, t0.template AS template_5, t0.site_id AS site_id_6 FROM cms__shared_block t0 WHERE t0.code = ? LIMIT 1
Parameters:
[
"CLONE"
]
|
| 13 | 0.16 ms |
SELECT t0.id AS id_1, t0.code AS code_2, t0.label AS label_3, t0.type AS type_4, t0.value AS value_5, t0.position AS position_6, t0.parent_heritance AS parent_heritance_7, t0.active AS active_8, t0.page_id AS page_id_9, t0.shared_block_parent_id AS shared_block_parent_id_10, t0.declination_id AS declination_id_11 FROM cms__content t0 WHERE t0.shared_block_parent_id = ? ORDER BY t0.position ASC
Parameters:
[
3
]
|
| 14 | 0.13 ms |
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
]
|
| 15 | 0.13 ms |
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_.shared_block_parent_id = ? LIMIT 1
Parameters:
[ "title" 3 ] |
| 16 | 0.12 ms |
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
]
|
| 17 | 0.14 ms |
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_.shared_block_parent_id = ? LIMIT 1
Parameters:
[ "description" 3 ] |
| 18 | 0.15 ms |
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
]
|
| 19 | 0.14 ms |
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_.shared_block_parent_id = ? LIMIT 1
Parameters:
[ "code" 3 ] |
| 20 | 0.16 ms |
SELECT p0_.code AS code_0, p0_.type AS type_1, p0_.config AS config_2, p0_.label AS label_3, p0_.value AS value_4, p0_.deletable AS deletable_5 FROM parameter p0_ WHERE p0_.code = ?
Parameters:
[
"linkedin_url"
]
|
| 21 | 0.16 ms |
SELECT p0_.code AS code_0, p0_.type AS type_1, p0_.config AS config_2, p0_.label AS label_3, p0_.value AS value_4, p0_.deletable AS deletable_5 FROM parameter p0_ WHERE p0_.code = ?
Parameters:
[
"product_hunt_url"
]
|
| 22 | 0.15 ms |
SELECT p0_.code AS code_0, p0_.type AS type_1, p0_.config AS config_2, p0_.label AS label_3, p0_.value AS value_4, p0_.deletable AS deletable_5 FROM parameter p0_ WHERE p0_.code = ?
Parameters:
[
"society_info_footer"
]
|
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 |
|---|---|
| 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. |
| WebEtDesign\ParameterBundle\Entity\Parameter | No errors. |