Query Metrics
187
Database Queries
12
Different statements
101.25 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
45.09 ms (44.54%) |
90 |
SELECT t0.locale AS locale_1, t0.field_name AS field_name_2, t0.translation AS translation_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.page_id AS page_id_7 FROM cms_page_translation t0 WHERE t0.page_id = ?
Parameters:
[
4
]
|
||||||||||||||||||||||||||||||||
|
10.22 ms (10.10%) |
15 |
SELECT c0_.page_name AS page_name_0, c0_.page_published AS page_published_1, c0_.page_css_file_global AS page_css_file_global_2, c0_.page_css_global AS page_css_global_3, c0_.page_js_file_global AS page_js_file_global_4, c0_.page_js_global AS page_js_global_5, c0_.page_order AS page_order_6, c0_.id AS id_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.uuid AS uuid_10, c1_.template_name AS template_name_11, c1_.template_html AS template_html_12, c1_.template_type AS template_type_13, c1_.id AS id_14, c1_.created_at AS created_at_15, c1_.updated_at AS updated_at_16, c1_.uuid AS uuid_17, c0_.template_id AS template_id_18, c0_.page_category_id AS page_category_id_19, c0_.page_content_seo_id AS page_content_seo_id_20 FROM cms_page c0_ INNER JOIN cms_page_category c2_ ON c0_.page_category_id = c2_.id INNER JOIN cms_template c1_ ON c0_.template_id = c1_.id WHERE c0_.page_name = ?
Parameters:
[
"Menu"
]
|
||||||||||||||||||||||||||||||||
|
9.85 ms (9.73%) |
20 |
SELECT t0.locale AS locale_1, t0.field_name AS field_name_2, t0.translation AS translation_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.page_content_text_link_id AS page_content_text_link_id_7 FROM cms_page_content_text_link_translation t0 WHERE t0.page_content_text_link_id = ?
Parameters:
[
13
]
|
||||||||||||||||||||||||||||||||
|
9.04 ms (8.93%) |
20 |
SELECT t0.anchor AS anchor_1, t0.external_link AS external_link_2, t0.target AS target_3, t0.class AS class_4, t0.style AS style_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.text_link_page_id AS text_link_page_id_9 FROM cms_page_content_text_link t0 WHERE t0.id = ?
Parameters:
[
13
]
|
||||||||||||||||||||||||||||||||
|
7.37 ms (7.28%) |
4 |
SELECT c0_.content_type AS content_type_0, c0_.content_name AS content_name_1, c0_.content_order AS content_order_2, c0_.id AS id_3, c0_.created_at AS created_at_4, c0_.updated_at AS updated_at_5, c0_.uuid AS uuid_6, c1_.id AS id_7, c1_.created_at AS created_at_8, c1_.updated_at AS updated_at_9, c2_.class AS class_10, c2_.style AS style_11, c2_.id AS id_12, c2_.created_at AS created_at_13, c2_.updated_at AS updated_at_14, c3_.anchor AS anchor_15, c3_.external_link AS external_link_16, c3_.target AS target_17, c3_.id AS id_18, c3_.created_at AS created_at_19, c3_.updated_at AS updated_at_20, c4_.id AS id_21, c4_.created_at AS created_at_22, c4_.updated_at AS updated_at_23, c5_.class AS class_24, c5_.style AS style_25, c5_.external_link AS external_link_26, c5_.link_class AS link_class_27, c5_.link_style AS link_style_28, c5_.target AS target_29, c5_.lazy_loading AS lazy_loading_30, c5_.id AS id_31, c5_.created_at AS created_at_32, c5_.updated_at AS updated_at_33, c6_.background_position AS background_position_34, c6_.background_repeat AS background_repeat_35, c6_.background_size AS background_size_36, c6_.id AS id_37, c6_.created_at AS created_at_38, c6_.updated_at AS updated_at_39, c7_.video_id AS video_id_40, c7_.width AS width_41, c7_.ratio AS ratio_42, c7_.controls AS controls_43, c7_.loop_video AS loop_video_44, c7_.mute AS mute_45, c7_.autoplay AS autoplay_46, c7_.fullscreen AS fullscreen_47, c7_.id AS id_48, c7_.created_at AS created_at_49, c7_.updated_at AS updated_at_50, c8_.locale AS locale_51, c8_.field_name AS field_name_52, c8_.translation AS translation_53, c8_.id AS id_54, c8_.created_at AS created_at_55, c8_.updated_at AS updated_at_56, c9_.locale AS locale_57, c9_.field_name AS field_name_58, c9_.translation AS translation_59, c9_.id AS id_60, c9_.created_at AS created_at_61, c9_.updated_at AS updated_at_62, c10_.locale AS locale_63, c10_.field_name AS field_name_64, c10_.translation AS translation_65, c10_.id AS id_66, c10_.created_at AS created_at_67, c10_.updated_at AS updated_at_68, c11_.locale AS locale_69, c11_.field_name AS field_name_70, c11_.translation AS translation_71, c11_.id AS id_72, c11_.created_at AS created_at_73, c11_.updated_at AS updated_at_74, c0_.page_id AS page_id_75, c0_.page_content_text_id AS page_content_text_id_76, c0_.page_content_link_id AS page_content_link_id_77, c0_.page_content_text_link_id AS page_content_text_link_id_78, c0_.page_content_editor_id AS page_content_editor_id_79, c0_.page_content_image_id AS page_content_image_id_80, c0_.page_content_background_id AS page_content_background_id_81, c0_.page_content_icon_id AS page_content_icon_id_82, c0_.page_content_video_id AS page_content_video_id_83, c0_.page_content_blog_category_id AS page_content_blog_category_id_84, c0_.page_content_date_id AS page_content_date_id_85, c0_.page_content_anchor_id AS page_content_anchor_id_86, c0_.page_content_blog_id AS page_content_blog_id_87, c0_.page_content_list_id AS page_content_list_id_88, c0_.page_content_carousel_id AS page_content_carousel_id_89, c0_.page_content_countdown_id AS page_content_countdown_id_90, c0_.page_content_element_id AS page_content_element_id_91, c0_.page_content_element_child_item_id AS page_content_element_child_item_id_92, c0_.page_content_gallery_id AS page_content_gallery_id_93, c1_.category_id AS category_id_94, c1_.page_id AS page_id_95, c1_.template_id AS template_id_96, c3_.link_page_id AS link_page_id_97, c5_.image_id AS image_id_98, c5_.link_page_id AS link_page_id_99, c6_.image_id AS image_id_100, c8_.page_content_text_id AS page_content_text_id_101, c9_.page_content_link_id AS page_content_link_id_102, c10_.page_content_editor_id AS page_content_editor_id_103, c11_.page_content_image_id AS page_content_image_id_104 FROM cms_page_content c0_ LEFT JOIN cms_page_content_element c1_ ON c0_.page_content_element_id = c1_.id LEFT JOIN cms_page_content_text c2_ ON c0_.page_content_text_id = c2_.id LEFT JOIN cms_page_content_link c3_ ON c0_.page_content_link_id = c3_.id LEFT JOIN cms_page_content_editor c4_ ON c0_.page_content_editor_id = c4_.id LEFT JOIN cms_page_content_image c5_ ON c0_.page_content_image_id = c5_.id LEFT JOIN cms_page_content_background c6_ ON c0_.page_content_background_id = c6_.id LEFT JOIN cms_page_content_video c7_ ON c0_.page_content_video_id = c7_.id LEFT JOIN cms_page_content_text_translation c8_ ON c2_.id = c8_.page_content_text_id AND (c8_.locale = ?) LEFT JOIN cms_page_content_link_translation c9_ ON c3_.id = c9_.page_content_link_id AND (c9_.locale = ?) LEFT JOIN cms_page_content_editor_translation c10_ ON c4_.id = c10_.page_content_editor_id AND (c10_.locale = ?) LEFT JOIN cms_page_content_image_translation c11_ ON c5_.id = c11_.page_content_image_id AND (c11_.locale = ?) WHERE c0_.page_id = ?
Parameters:
[ "en" "en" "en" "en" 31 ]
|
||||||||||||||||||||||||||||||||
|
6.91 ms (6.83%) |
15 |
SELECT t0.configuration_name AS configuration_name_1, t0.configuration_type AS configuration_type_2, t0.configuration_value AS configuration_value_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.uuid AS uuid_7 FROM cms_configuration t0
Parameters:
[] |
||||||||||||||||||||||||||||||||
|
4.46 ms (4.40%) |
7 |
SELECT t0.content_type AS content_type_1, t0.content_name AS content_name_2, t0.content_order AS content_order_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.uuid AS uuid_7, t0.page_id AS page_id_8, t0.page_content_text_id AS page_content_text_id_9, t0.page_content_link_id AS page_content_link_id_10, t0.page_content_text_link_id AS page_content_text_link_id_11, t0.page_content_editor_id AS page_content_editor_id_12, t0.page_content_image_id AS page_content_image_id_13, t0.page_content_background_id AS page_content_background_id_14, t0.page_content_icon_id AS page_content_icon_id_15, t0.page_content_video_id AS page_content_video_id_16, t0.page_content_blog_category_id AS page_content_blog_category_id_17, t0.page_content_date_id AS page_content_date_id_18, t0.page_content_anchor_id AS page_content_anchor_id_19, t0.page_content_blog_id AS page_content_blog_id_20, t0.page_content_list_id AS page_content_list_id_21, t0.page_content_carousel_id AS page_content_carousel_id_22, t0.page_content_countdown_id AS page_content_countdown_id_23, t0.page_content_element_id AS page_content_element_id_24, t0.page_content_element_child_item_id AS page_content_element_child_item_id_25, t0.page_content_gallery_id AS page_content_gallery_id_26 FROM cms_page_extra_field_content t0 WHERE t0.page_id = ?
Parameters:
[
9
]
|
||||||||||||||||||||||||||||||||
|
3.26 ms (3.22%) |
8 |
SELECT t0.class AS class_1, t0.style AS style_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5 FROM cms_page_content_icon t0 WHERE t0.id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
|
2.65 ms (2.62%) |
5 |
SELECT t0.image_name AS image_name_1, t0.image_mime_type AS image_mime_type_2, t0.image_filename AS image_filename_3, t0.image_alt AS image_alt_4, t0.image_directory AS image_directory_5, t0.image_category AS image_category_6, t0.preview_background AS preview_background_7, t0.image_width AS image_width_8, t0.image_height AS image_height_9, t0.id AS id_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.uuid AS uuid_13, t0.image_category_id AS image_category_id_14 FROM image t0 WHERE t0.id = ?
Parameters:
[
2
]
|
||||||||||||||||||||||||||||||||
|
1.38 ms (1.37%) |
1 |
SELECT c0_.page_name AS page_name_0, c0_.page_published AS page_published_1, c0_.page_css_file_global AS page_css_file_global_2, c0_.page_css_global AS page_css_global_3, c0_.page_js_file_global AS page_js_file_global_4, c0_.page_js_global AS page_js_global_5, c0_.page_order AS page_order_6, c0_.id AS id_7, c0_.created_at AS created_at_8, c0_.updated_at AS updated_at_9, c0_.uuid AS uuid_10, c1_.template_name AS template_name_11, c1_.template_html AS template_html_12, c1_.template_type AS template_type_13, c1_.id AS id_14, c1_.created_at AS created_at_15, c1_.updated_at AS updated_at_16, c1_.uuid AS uuid_17, c0_.template_id AS template_id_18, c0_.page_category_id AS page_category_id_19, c0_.page_content_seo_id AS page_content_seo_id_20 FROM cms_page c0_ INNER JOIN cms_page_category c2_ ON c0_.page_category_id = c2_.id INNER JOIN cms_template c1_ ON c0_.template_id = c1_.id
Parameters:
[]
|
||||||||||||||||||||||||||||||||
|
0.52 ms (0.51%) |
1 |
SELECT t0.locale AS locale_1, t0.field_name AS field_name_2, t0.translation AS translation_3, t0.id AS id_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.page_content_seo_id AS page_content_seo_id_7 FROM cms_page_content_seo_translation t0 WHERE t0.page_content_seo_id = ?
Parameters:
[
23
]
|
||||||||||||||||||||||||||||||||
|
0.49 ms (0.48%) |
1 |
SELECT t0.robot_no_index AS robot_no_index_1, t0.robot_no_follow AS robot_no_follow_2, t0.id AS id_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.uuid AS uuid_6, t0.og_image_id AS og_image_id_7 FROM cms_page_content_seo t0 WHERE t0.id = ?
Parameters:
[
23
]
|
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.