Query Metrics
192
Database Queries
18
Different statements
112.36 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
42.49 ms (37.82%) |
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
]
|
||||||||||||||||||||||||||||||||
|
11.14 ms (9.92%) |
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.22 ms (8.20%) |
17 |
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
]
|
||||||||||||||||||||||||||||||||
|
8.64 ms (7.69%) |
17 |
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.92 ms (7.05%) |
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" 88 ]
|
||||||||||||||||||||||||||||||||
|
7.41 ms (6.60%) |
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:
[] |
||||||||||||||||||||||||||||||||
|
6.96 ms (6.19%) |
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_.class AS class_7, c1_.style AS style_8, c1_.id AS id_9, c1_.created_at AS created_at_10, c1_.updated_at AS updated_at_11, c2_.anchor AS anchor_12, c2_.external_link AS external_link_13, c2_.target AS target_14, c2_.id AS id_15, c2_.created_at AS created_at_16, c2_.updated_at AS updated_at_17, c3_.id AS id_18, c3_.created_at AS created_at_19, c3_.updated_at AS updated_at_20, c4_.class AS class_21, c4_.style AS style_22, c4_.external_link AS external_link_23, c4_.link_class AS link_class_24, c4_.link_style AS link_style_25, c4_.target AS target_26, c4_.lazy_loading AS lazy_loading_27, c4_.id AS id_28, c4_.created_at AS created_at_29, c4_.updated_at AS updated_at_30, c5_.background_position AS background_position_31, c5_.background_repeat AS background_repeat_32, c5_.background_size AS background_size_33, c5_.id AS id_34, c5_.created_at AS created_at_35, c5_.updated_at AS updated_at_36, c6_.video_id AS video_id_37, c6_.width AS width_38, c6_.ratio AS ratio_39, c6_.controls AS controls_40, c6_.loop_video AS loop_video_41, c6_.mute AS mute_42, c6_.autoplay AS autoplay_43, c6_.fullscreen AS fullscreen_44, c6_.id AS id_45, c6_.created_at AS created_at_46, c6_.updated_at AS updated_at_47, c0_.page_id AS page_id_48, c0_.page_content_text_id AS page_content_text_id_49, c0_.page_content_link_id AS page_content_link_id_50, c0_.page_content_text_link_id AS page_content_text_link_id_51, c0_.page_content_editor_id AS page_content_editor_id_52, c0_.page_content_image_id AS page_content_image_id_53, c0_.page_content_background_id AS page_content_background_id_54, c0_.page_content_icon_id AS page_content_icon_id_55, c0_.page_content_video_id AS page_content_video_id_56, c0_.page_content_blog_category_id AS page_content_blog_category_id_57, c0_.page_content_date_id AS page_content_date_id_58, c0_.page_content_anchor_id AS page_content_anchor_id_59, c0_.page_content_blog_id AS page_content_blog_id_60, c0_.page_content_list_id AS page_content_list_id_61, c0_.page_content_carousel_id AS page_content_carousel_id_62, c0_.page_content_countdown_id AS page_content_countdown_id_63, c0_.page_content_element_id AS page_content_element_id_64, c0_.page_content_element_child_item_id AS page_content_element_child_item_id_65, c0_.page_content_gallery_id AS page_content_gallery_id_66, c2_.link_page_id AS link_page_id_67, c4_.image_id AS image_id_68, c4_.link_page_id AS link_page_id_69, c5_.image_id AS image_id_70 FROM cms_page_extra_field_content c0_ LEFT JOIN cms_page_content_text c1_ ON c0_.page_content_text_id = c1_.id LEFT JOIN cms_page_content_link c2_ ON c0_.page_content_link_id = c2_.id LEFT JOIN cms_page_content_editor c3_ ON c0_.page_content_editor_id = c3_.id LEFT JOIN cms_page_content_image c4_ ON c0_.page_content_image_id = c4_.id LEFT JOIN cms_page_content_background c5_ ON c0_.page_content_background_id = c5_.id LEFT JOIN cms_page_content_video c6_ ON c0_.page_content_video_id = c6_.id LEFT JOIN cms_page_content_text_translation c7_ ON c1_.id = c7_.page_content_text_id AND (c7_.locale = ?) LEFT JOIN cms_page_content_link_translation c8_ ON c2_.id = c8_.page_content_link_id AND (c8_.locale = ?) LEFT JOIN cms_page_content_editor_translation c9_ ON c3_.id = c9_.page_content_editor_id AND (c9_.locale = ?) LEFT JOIN cms_page_content_image_translation c10_ ON c4_.id = c10_.page_content_image_id AND (c10_.locale = ?) WHERE c0_.page_id = ?
Parameters:
[ "en" "en" "en" "en" 88 ] |
||||||||||||||||||||||||||||||||
|
5.66 ms (5.03%) |
8 |
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.59 ms (3.19%) |
7 |
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_category_id AS page_category_id_7 FROM cms_page_category_translation t0 WHERE t0.page_category_id = ?
Parameters:
[
1
]
|
||||||||||||||||||||||||||||||||
|
2.93 ms (2.60%) |
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.76 ms (1.57%) |
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:
[]
|
||||||||||||||||||||||||||||||||
|
1.07 ms (0.95%) |
2 |
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_id AS page_content_text_id_7 FROM cms_page_content_text_translation t0 WHERE t0.page_content_text_id = ?
Parameters:
[
294
]
|
||||||||||||||||||||||||||||||||
|
0.88 ms (0.78%) |
2 |
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
]
|
||||||||||||||||||||||||||||||||
|
0.61 ms (0.55%) |
1 |
SELECT t0.category_name AS category_name_1, t0.category_type AS category_type_2, t0.category_role AS category_role_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_page_category t0
Parameters:
[]
|
||||||||||||||||||||||||||||||||
|
0.54 ms (0.48%) |
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:
[
74
]
|
||||||||||||||||||||||||||||||||
|
0.53 ms (0.47%) |
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_editor_id AS page_content_editor_id_7 FROM cms_page_content_editor_translation t0 WHERE t0.page_content_editor_id = ?
Parameters:
[
108
]
|
||||||||||||||||||||||||||||||||
|
0.51 ms (0.46%) |
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_image_id AS page_content_image_id_7 FROM cms_page_content_image_translation t0 WHERE t0.page_content_image_id = ?
Parameters:
[
43
]
|
||||||||||||||||||||||||||||||||
|
0.50 ms (0.44%) |
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:
[
74
]
|
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.