Query Metrics
73
Database Queries
23
Different statements
69.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
20.32 ms (29.09%) |
2 |
"COMMIT"
Parameters:
[] |
|
9.81 ms (14.05%) |
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_id AS page_id_7 FROM cms_page_translation t0 WHERE t0.page_id = ?
Parameters:
[
1
]
|
|
7.45 ms (10.66%) |
10 |
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 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_Bar"
]
|
|
6.17 ms (8.84%) |
3 |
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_.id AS id_27, c4_.created_at AS created_at_28, c4_.updated_at AS updated_at_29, c5_.background_position AS background_position_30, c5_.background_repeat AS background_repeat_31, c5_.background_size AS background_size_32, c5_.id AS id_33, c5_.created_at AS created_at_34, c5_.updated_at AS updated_at_35, c6_.video_id AS video_id_36, c6_.width AS width_37, c6_.ratio AS ratio_38, c6_.controls AS controls_39, c6_.loop_video AS loop_video_40, c6_.mute AS mute_41, c6_.autoplay AS autoplay_42, c6_.fullscreen AS fullscreen_43, c6_.id AS id_44, c6_.created_at AS created_at_45, c6_.updated_at AS updated_at_46, c7_.locale AS locale_47, c7_.field_name AS field_name_48, c7_.translation AS translation_49, c7_.id AS id_50, c7_.created_at AS created_at_51, c7_.updated_at AS updated_at_52, c8_.locale AS locale_53, c8_.field_name AS field_name_54, c8_.translation AS translation_55, c8_.id AS id_56, c8_.created_at AS created_at_57, c8_.updated_at AS updated_at_58, c9_.locale AS locale_59, c9_.field_name AS field_name_60, c9_.translation AS translation_61, c9_.id AS id_62, c9_.created_at AS created_at_63, c9_.updated_at AS updated_at_64, c10_.locale AS locale_65, c10_.field_name AS field_name_66, c10_.translation AS translation_67, c10_.id AS id_68, c10_.created_at AS created_at_69, c10_.updated_at AS updated_at_70, c0_.page_id AS page_id_71, c0_.page_content_text_id AS page_content_text_id_72, c0_.page_content_link_id AS page_content_link_id_73, c0_.page_content_editor_id AS page_content_editor_id_74, c0_.page_content_image_id AS page_content_image_id_75, c0_.page_content_background_id AS page_content_background_id_76, c0_.page_content_icon_id AS page_content_icon_id_77, c0_.page_content_video_id AS page_content_video_id_78, c0_.page_content_blog_category_id AS page_content_blog_category_id_79, c0_.page_content_date_id AS page_content_date_id_80, c0_.page_content_anchor_id AS page_content_anchor_id_81, c0_.page_content_blog_id AS page_content_blog_id_82, c0_.page_content_list_id AS page_content_list_id_83, c2_.link_page_id AS link_page_id_84, c4_.image_id AS image_id_85, c4_.link_page_id AS link_page_id_86, c5_.image_id AS image_id_87, c7_.page_content_text_id AS page_content_text_id_88, c8_.page_content_link_id AS page_content_link_id_89, c9_.page_content_editor_id AS page_content_editor_id_90, c10_.page_content_image_id AS page_content_image_id_91 FROM cms_page_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" 16 ] |
|
4.21 ms (6.03%) |
6 |
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_editor_id AS page_content_editor_id_11, t0.page_content_image_id AS page_content_image_id_12, t0.page_content_background_id AS page_content_background_id_13, t0.page_content_icon_id AS page_content_icon_id_14, t0.page_content_video_id AS page_content_video_id_15, t0.page_content_blog_category_id AS page_content_blog_category_id_16, t0.page_content_date_id AS page_content_date_id_17, t0.page_content_anchor_id AS page_content_anchor_id_18, t0.page_content_blog_id AS page_content_blog_id_19, t0.page_content_list_id AS page_content_list_id_20 FROM cms_page_extra_field_content t0 WHERE t0.page_id = ?
Parameters:
[
2
]
|
|
3.68 ms (5.26%) |
7 |
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:
[] |
|
3.45 ms (4.94%) |
6 |
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.90 ms (4.15%) |
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 FROM image t0 WHERE t0.id = ?
Parameters:
[
13
]
|
|
1.89 ms (2.71%) |
1 |
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_.id AS id_27, c4_.created_at AS created_at_28, c4_.updated_at AS updated_at_29, c5_.background_position AS background_position_30, c5_.background_repeat AS background_repeat_31, c5_.background_size AS background_size_32, c5_.id AS id_33, c5_.created_at AS created_at_34, c5_.updated_at AS updated_at_35, c6_.video_id AS video_id_36, c6_.width AS width_37, c6_.ratio AS ratio_38, c6_.controls AS controls_39, c6_.loop_video AS loop_video_40, c6_.mute AS mute_41, c6_.autoplay AS autoplay_42, c6_.fullscreen AS fullscreen_43, c6_.id AS id_44, c6_.created_at AS created_at_45, c6_.updated_at AS updated_at_46, c0_.page_id AS page_id_47, c0_.page_content_text_id AS page_content_text_id_48, c0_.page_content_link_id AS page_content_link_id_49, c0_.page_content_editor_id AS page_content_editor_id_50, c0_.page_content_image_id AS page_content_image_id_51, c0_.page_content_background_id AS page_content_background_id_52, c0_.page_content_icon_id AS page_content_icon_id_53, c0_.page_content_video_id AS page_content_video_id_54, c0_.page_content_blog_category_id AS page_content_blog_category_id_55, c0_.page_content_date_id AS page_content_date_id_56, c0_.page_content_anchor_id AS page_content_anchor_id_57, c0_.page_content_blog_id AS page_content_blog_id_58, c0_.page_content_list_id AS page_content_list_id_59, c2_.link_page_id AS link_page_id_60, c4_.image_id AS image_id_61, c4_.link_page_id AS link_page_id_62, c5_.image_id AS image_id_63 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" 16 ] |
|
1.17 ms (1.68%) |
2 |
DELETE FROM cms_visit WHERE date_visit <= ?
Parameters:
[
"2025-12-07 13:29:17"
]
|
|
0.84 ms (1.20%) |
1 |
SELECT t0.ip AS ip_1, t0.country AS country_2, t0.nb_visit AS nb_visit_3, t0.date_visit AS date_visit_4, t0.language AS language_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.page_id AS page_id_9 FROM cms_visit t0 WHERE t0.ip = ? AND t0.date_visit = ? LIMIT 1
Parameters:
[ "216.73.216.29" "2025-12-10" ] |
|
0.83 ms (1.18%) |
1 |
SELECT t0.year AS year_1, t0.month AS month_2, t0.day AS day_3, t0.hour AS hour_4, t0.visits AS visits_5, t0.visits_total AS visits_total_6, t0.country AS country_7, t0.language AS language_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.page_id AS page_id_12 FROM cms_visit_hour t0 WHERE t0.year = ? AND t0.month = ? AND t0.day = ? AND t0.hour = ? AND t0.country = ? AND t0.page_id = ? AND t0.language = ? LIMIT 1
Parameters:
[ "2025" "12" "10" "13" "US" 16 "en" ] |
|
0.81 ms (1.16%) |
1 |
SELECT t0.year AS year_1, t0.month AS month_2, t0.day AS day_3, t0.hour AS hour_4, t0.visits AS visits_5, t0.visits_total AS visits_total_6, t0.country AS country_7, t0.language AS language_8, t0.id AS id_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.page_id AS page_id_12 FROM cms_visit_hour t0 WHERE t0.year = ? AND t0.month = ? AND t0.day = ? AND t0.hour = ? AND t0.country = ? AND t0.page_id IS NULL AND t0.language IS NULL LIMIT 1
Parameters:
[ "2025" "12" "10" "13" "US" ] |
|
0.78 ms (1.11%) |
1 |
SELECT t0.ip AS ip_1, t0.country AS country_2, t0.nb_visit AS nb_visit_3, t0.date_visit AS date_visit_4, t0.language AS language_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.page_id AS page_id_9 FROM cms_visit t0 WHERE t0.ip = ? AND t0.page_id = ? AND t0.language = ? AND t0.date_visit = ? LIMIT 1
Parameters:
[ "216.73.216.29" 16 "en" "2025-12-10" ] |
|
0.76 ms (1.09%) |
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 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.74 ms (1.07%) |
2 |
"START TRANSACTION"
Parameters:
[] |
|
0.73 ms (1.05%) |
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.59 ms (0.85%) |
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_text_id AS page_content_text_id_7 FROM cms_page_content_text_translation t0 WHERE t0.page_content_text_id = ?
Parameters:
[
78
]
|
|
0.58 ms (0.83%) |
1 |
INSERT INTO cms_visit (ip, country, nb_visit, date_visit, language, created_at, updated_at, page_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "216.73.216.29" "US" 1 "2025-12-10" "en" "2025-12-10 13:29:17" null 16 ] |
|
0.57 ms (0.82%) |
1 |
UPDATE cms_visit SET nb_visit = ?, updated_at = ? WHERE id = ?
Parameters:
[ 7 "2025-12-10 13:29:17" 2172 ] |
|
0.55 ms (0.78%) |
1 |
UPDATE cms_visit_hour SET visits_total = ?, updated_at = ? WHERE id = ?
Parameters:
[ 7 "2025-12-10 13:29:17" 3862 ] |
|
0.54 ms (0.77%) |
1 |
INSERT INTO cms_visit_hour (year, month, day, hour, visits, visits_total, country, language, created_at, updated_at, page_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 2025 12 10 13 1 1 "US" "en" "2025-12-10 13:29:17" null 16 ] |
|
0.47 ms (0.67%) |
1 |
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
]
|
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.