Query Metrics
10
Database Queries
7
Different statements
7.05 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
3.06 ms (43.35%) |
4 |
SELECT t0.id AS id_1, t0.analytics AS analytics_2, t0.add_this AS add_this_3, t0.copyright AS copyright_4, t0.social AS social_5, t0.facebook_link AS facebook_link_6, t0.facebook_app_id AS facebook_app_id_7, t0.facebook_app_secret AS facebook_app_secret_8, t0.facebook_page_id AS facebook_page_id_9, t0.twitter_link AS twitter_link_10, t0.twitter_api_key AS twitter_api_key_11, t0.twitter_api_secret AS twitter_api_secret_12, t0.twitter_access_token AS twitter_access_token_13, t0.twitter_access_token_secret AS twitter_access_token_secret_14, t0.instagram_link AS instagram_link_15, t0.instagram_client_id AS instagram_client_id_16, t0.instagram_client_secret AS instagram_client_secret_17, t0.instagram_access_token AS instagram_access_token_18, t0.google_plus_link AS google_plus_link_19, t0.linkedin_link AS linkedin_link_20, t0.viadeo_link AS viadeo_link_21, t0.tumblr_link AS tumblr_link_22, t0.pinterest_link AS pinterest_link_23, t0.youtube_link AS youtube_link_24, t0.vimeo_link AS vimeo_link_25, t0.weibo_link AS weibo_link_26, t0.active AS active_27, t0.cookie_banner AS cookie_banner_28, t0.robot AS robot_29, t0.modules AS modules_30, t0.custom_theme AS custom_theme_31, t0.language_menu AS language_menu_32, t0.maintenance AS maintenance_33, t0.maintenance_code AS maintenance_code_34, t0.main_site AS main_site_35, t0.keep_page_versions_history AS keep_page_versions_history_36, t0.user_id AS user_id_37, t0.default_language_id AS default_language_id_38, t39.id AS id_40, t39.font AS font_41, t39.type_template AS type_template_42, t39.font_size AS font_size_43, t39.text_size AS text_size_44, t39.text_color AS text_color_45, t39.h1text_size AS h1text_size_46, t39.h1text_color AS h1text_color_47, t39.h2text_size AS h2text_size_48, t39.h2text_color AS h2text_color_49, t39.h3text_size AS h3text_size_50, t39.h3text_color AS h3text_color_51, t39.h4text_size AS h4text_size_52, t39.h4text_color AS h4text_color_53, t39.h5text_size AS h5text_size_54, t39.h5text_color AS h5text_color_55, t39.h6text_size AS h6text_size_56, t39.h6text_color AS h6text_color_57, t39.link_text_size AS link_text_size_58, t39.link_text_color AS link_text_color_59, t39.link_hover_text_size AS link_hover_text_size_60, t39.link_hover_text_color AS link_hover_text_color_61, t39.link_button_size AS link_button_size_62, t39.link_button_text_color AS link_button_text_color_63, t39.link_hover_button_background_color AS link_hover_button_background_color_64, t39.link_button_background_color AS link_button_background_color_65, t39.header_text_size1 AS header_text_size1_66, t39.header_color1 AS header_color1_67, t39.header_color2 AS header_color2_68, t39.header_color3 AS header_color3_69, t39.footer_text_size1 AS footer_text_size1_70, t39.footer_color1 AS footer_color1_71, t39.footer_color2 AS footer_color2_72, t39.footer_color3 AS footer_color3_73, t39.style AS style_74, t39.javascript AS javascript_75, t39.config_tinymce AS config_tinymce_76, t39.grid_width AS grid_width_77, t39.display_breadcrumbs AS display_breadcrumbs_78, t39.default_color1 AS default_color1_79, t39.default_color2 AS default_color2_80, t39.default_color3 AS default_color3_81, t39.default_color4 AS default_color4_82, t39.default_color5 AS default_color5_83, t39.default_color6 AS default_color6_84, t39.default_color7 AS default_color7_85, t39.default_color8 AS default_color8_86, t39.cookie_banner_background_color AS cookie_banner_background_color_87, t39.cookie_banner_text_color AS cookie_banner_text_color_88, t39.cookie_button_background_color AS cookie_button_background_color_89, t39.cookie_button_text_color AS cookie_button_text_color_90, t39.cookie_button_hover_background_color AS cookie_button_hover_background_color_91, t39.cookie_button_hover_text_color AS cookie_button_hover_text_color_92, t39.site_background_color AS site_background_color_93, t39.header_type AS header_type_94, t39.json_config AS json_config_95, t39.site_id AS site_id_96, t39.footer_template_id AS footer_template_id_97, t39.header_template_id AS header_template_id_98, t39.logo_id AS logo_id_99, t39.responsive_logo_id AS responsive_logo_id_100, t39.favicon_id AS favicon_id_101, t39.site_background_image_id AS site_background_image_id_102, t0.page_products_id AS page_products_id_103, t0.redirect_page_on_404 AS redirect_page_on_404_104 FROM sites t0 LEFT JOIN themes t39 ON t39.site_id = t0.id WHERE t0.main_site = ? LIMIT 1
Parameters:
[
1
]
|
0.89 ms (12.61%) |
1 |
SELECT s0_.id AS id_0, s0_.analytics AS analytics_1, s0_.add_this AS add_this_2, s0_.copyright AS copyright_3, s0_.social AS social_4, s0_.facebook_link AS facebook_link_5, s0_.facebook_app_id AS facebook_app_id_6, s0_.facebook_app_secret AS facebook_app_secret_7, s0_.facebook_page_id AS facebook_page_id_8, s0_.twitter_link AS twitter_link_9, s0_.twitter_api_key AS twitter_api_key_10, s0_.twitter_api_secret AS twitter_api_secret_11, s0_.twitter_access_token AS twitter_access_token_12, s0_.twitter_access_token_secret AS twitter_access_token_secret_13, s0_.instagram_link AS instagram_link_14, s0_.instagram_client_id AS instagram_client_id_15, s0_.instagram_client_secret AS instagram_client_secret_16, s0_.instagram_access_token AS instagram_access_token_17, s0_.google_plus_link AS google_plus_link_18, s0_.linkedin_link AS linkedin_link_19, s0_.viadeo_link AS viadeo_link_20, s0_.tumblr_link AS tumblr_link_21, s0_.pinterest_link AS pinterest_link_22, s0_.youtube_link AS youtube_link_23, s0_.vimeo_link AS vimeo_link_24, s0_.weibo_link AS weibo_link_25, s0_.active AS active_26, s0_.cookie_banner AS cookie_banner_27, s0_.robot AS robot_28, s0_.modules AS modules_29, s0_.custom_theme AS custom_theme_30, s0_.language_menu AS language_menu_31, s0_.maintenance AS maintenance_32, s0_.maintenance_code AS maintenance_code_33, s0_.main_site AS main_site_34, s0_.keep_page_versions_history AS keep_page_versions_history_35, s0_.user_id AS user_id_36, s0_.default_language_id AS default_language_id_37, s0_.page_products_id AS page_products_id_38, s0_.redirect_page_on_404 AS redirect_page_on_404_39 FROM sites s0_ INNER JOIN hosts h1_ ON s0_.id = h1_.site_id WHERE h1_.url = ? OR h1_.url = ? OR h1_.url = ?
Parameters:
[ "http://localhost" "www.http://localhost" "localhost" ] |
0.86 ms (12.21%) |
1 |
SELECT t0.id AS id_1, t0.analytics AS analytics_2, t0.add_this AS add_this_3, t0.copyright AS copyright_4, t0.social AS social_5, t0.facebook_link AS facebook_link_6, t0.facebook_app_id AS facebook_app_id_7, t0.facebook_app_secret AS facebook_app_secret_8, t0.facebook_page_id AS facebook_page_id_9, t0.twitter_link AS twitter_link_10, t0.twitter_api_key AS twitter_api_key_11, t0.twitter_api_secret AS twitter_api_secret_12, t0.twitter_access_token AS twitter_access_token_13, t0.twitter_access_token_secret AS twitter_access_token_secret_14, t0.instagram_link AS instagram_link_15, t0.instagram_client_id AS instagram_client_id_16, t0.instagram_client_secret AS instagram_client_secret_17, t0.instagram_access_token AS instagram_access_token_18, t0.google_plus_link AS google_plus_link_19, t0.linkedin_link AS linkedin_link_20, t0.viadeo_link AS viadeo_link_21, t0.tumblr_link AS tumblr_link_22, t0.pinterest_link AS pinterest_link_23, t0.youtube_link AS youtube_link_24, t0.vimeo_link AS vimeo_link_25, t0.weibo_link AS weibo_link_26, t0.active AS active_27, t0.cookie_banner AS cookie_banner_28, t0.robot AS robot_29, t0.modules AS modules_30, t0.custom_theme AS custom_theme_31, t0.language_menu AS language_menu_32, t0.maintenance AS maintenance_33, t0.maintenance_code AS maintenance_code_34, t0.main_site AS main_site_35, t0.keep_page_versions_history AS keep_page_versions_history_36, t0.user_id AS user_id_37, t0.default_language_id AS default_language_id_38, t39.id AS id_40, t39.font AS font_41, t39.type_template AS type_template_42, t39.font_size AS font_size_43, t39.text_size AS text_size_44, t39.text_color AS text_color_45, t39.h1text_size AS h1text_size_46, t39.h1text_color AS h1text_color_47, t39.h2text_size AS h2text_size_48, t39.h2text_color AS h2text_color_49, t39.h3text_size AS h3text_size_50, t39.h3text_color AS h3text_color_51, t39.h4text_size AS h4text_size_52, t39.h4text_color AS h4text_color_53, t39.h5text_size AS h5text_size_54, t39.h5text_color AS h5text_color_55, t39.h6text_size AS h6text_size_56, t39.h6text_color AS h6text_color_57, t39.link_text_size AS link_text_size_58, t39.link_text_color AS link_text_color_59, t39.link_hover_text_size AS link_hover_text_size_60, t39.link_hover_text_color AS link_hover_text_color_61, t39.link_button_size AS link_button_size_62, t39.link_button_text_color AS link_button_text_color_63, t39.link_hover_button_background_color AS link_hover_button_background_color_64, t39.link_button_background_color AS link_button_background_color_65, t39.header_text_size1 AS header_text_size1_66, t39.header_color1 AS header_color1_67, t39.header_color2 AS header_color2_68, t39.header_color3 AS header_color3_69, t39.footer_text_size1 AS footer_text_size1_70, t39.footer_color1 AS footer_color1_71, t39.footer_color2 AS footer_color2_72, t39.footer_color3 AS footer_color3_73, t39.style AS style_74, t39.javascript AS javascript_75, t39.config_tinymce AS config_tinymce_76, t39.grid_width AS grid_width_77, t39.display_breadcrumbs AS display_breadcrumbs_78, t39.default_color1 AS default_color1_79, t39.default_color2 AS default_color2_80, t39.default_color3 AS default_color3_81, t39.default_color4 AS default_color4_82, t39.default_color5 AS default_color5_83, t39.default_color6 AS default_color6_84, t39.default_color7 AS default_color7_85, t39.default_color8 AS default_color8_86, t39.cookie_banner_background_color AS cookie_banner_background_color_87, t39.cookie_banner_text_color AS cookie_banner_text_color_88, t39.cookie_button_background_color AS cookie_button_background_color_89, t39.cookie_button_text_color AS cookie_button_text_color_90, t39.cookie_button_hover_background_color AS cookie_button_hover_background_color_91, t39.cookie_button_hover_text_color AS cookie_button_hover_text_color_92, t39.site_background_color AS site_background_color_93, t39.header_type AS header_type_94, t39.json_config AS json_config_95, t39.site_id AS site_id_96, t39.footer_template_id AS footer_template_id_97, t39.header_template_id AS header_template_id_98, t39.logo_id AS logo_id_99, t39.responsive_logo_id AS responsive_logo_id_100, t39.favicon_id AS favicon_id_101, t39.site_background_image_id AS site_background_image_id_102, t0.page_products_id AS page_products_id_103, t0.redirect_page_on_404 AS redirect_page_on_404_104 FROM sites t0 LEFT JOIN themes t39 ON t39.site_id = t0.id
Parameters:
[] |
0.63 ms (8.98%) |
1 |
SELECT t0.id AS id_1, t0.background_color AS background_color_2, t0.background_color_after_scroll AS background_color_after_scroll_3, t0.position_of_links AS position_of_links_4, t0.color_of_link AS color_of_link_5, t0.color_of_hover_link AS color_of_hover_link_6, t0.color_of_link_background AS color_of_link_background_7, t0.color_of_hover_background AS color_of_hover_background_8, t0.theme_id AS theme_id_9, t0.dtype FROM theme_top_header t0 WHERE t0.theme_id = ?
Parameters:
[
2
]
|
0.55 ms (7.84%) |
1 |
SELECT t0.id AS id_1, t0.country AS country_2, t0.code AS code_3 FROM language t0 INNER JOIN sites_languages ON t0.id = sites_languages.language_id WHERE sites_languages.site_id = ?
Parameters:
[
2
]
|
0.55 ms (7.77%) |
1 |
SELECT t0.id AS id_1, t0.country AS country_2, t0.code AS code_3 FROM language t0 INNER JOIN sites_enabled_languages ON t0.id = sites_enabled_languages.language_id WHERE sites_enabled_languages.site_id = ?
Parameters:
[
2
]
|
0.51 ms (7.23%) |
1 |
SELECT t0.id AS id_3, t0.color_of_link AS color_of_link_4, t0.color_of_link_hover AS color_of_link_hover_5, t0.background_color_of_link AS background_color_of_link_6, t0.background_color_of_hover_link AS background_color_of_hover_link_7, t0.background_color_of_mobile_bar AS background_color_of_mobile_bar_8, t0.background_color_of_mobile_bar_after_scroll AS background_color_of_mobile_bar_after_scroll_9, t0.background_color_open_burger_menu AS background_color_open_burger_menu_10, t0.color_of_burger_icon_button AS color_of_burger_icon_button_11, t0.color_of_burger_icon_button_hover AS color_of_burger_icon_button_hover_12, t0.background_color_of_burger_icon_button AS background_color_of_burger_icon_button_13, t0.background_color_of_burger_icon_button_hover AS background_color_of_burger_icon_button_hover_14, t0.position_of_burger_icon AS position_of_burger_icon_15, t0.position_of_logo_in_mobile_bar AS position_of_logo_in_mobile_bar_16, t0.position_of_links_in_burger AS position_of_links_in_burger_17, t0.scroll_position_mobile_bar AS scroll_position_mobile_bar_18, t0.size_open_menu AS size_open_menu_19, t0.display_of_language_menu AS display_of_language_menu_20, t0.position_of_language_selection AS position_of_language_selection_21, t0.position_of_ecommerce_menu AS position_of_ecommerce_menu_22, t0.enabled AS enabled_23, t0.theme_id AS theme_id_24, t0.dtype, t2.background_color_of_menu AS background_color_of_menu_25, t2.background_color_of_menu_after_scroll AS background_color_of_menu_after_scroll_26, t2.position_of_menu AS position_of_menu_27, t2.alignment_logo_menu AS alignment_logo_menu_28, t2.scroll_position_menu AS scroll_position_menu_29, t2.break_point_burger_menu AS break_point_burger_menu_30, t2.position_of_logo_menu AS position_of_logo_menu_31 FROM theme_header t0 LEFT JOIN theme_header_burger t1 ON t0.id = t1.id LEFT JOIN theme_header_classic t2 ON t0.id = t2.id WHERE t0.theme_id = ?
Parameters:
[
2
]
|
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 |
---|---|
AWCmsBundle\Entity\Site | No errors. |
AWCmsBundle\Entity\Host | No errors. |
AWCmsBundle\Entity\User | No errors. |
AppBundle\Entity\User | No errors. |
AWCmsBundle\Entity\Language | No errors. |
AWCmsBundle\Entity\Page | No errors. |
AWCmsBundle\Entity\Theme | No errors. |
AWCmsBundle\Entity\Template | No errors. |
AWEdmBundle\Entity\Document | No errors. |
AWEdmBundle\Entity\File | No errors. |
AWCmsBundle\Entity\MenuTree | No errors. |
AWCmsBundle\Entity\Module | No errors. |
AWCmsBundle\Entity\SiteTranslation | No errors. |
AWCmsBundle\Entity\ThemeHeader | No errors. |
AWCmsBundle\Entity\ThemeHeaderBurger | No errors. |
AWCmsBundle\Entity\ThemeHeaderClassic | No errors. |
AWCmsBundle\Entity\ThemeTopHeader | No errors. |