Query Metrics
148
Database Queries
32
Different statements
86.76 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
25.56 ms (29.46%) |
2 |
"COMMIT"
Parameters:
[] |
|
19.37 ms (22.33%) |
26 |
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" 6 ] |
|
6.88 ms (7.92%) |
8 |
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" 2 ] |
|
4.06 ms (4.68%) |
11 |
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:
[
"Homepage"
]
|
|
3.68 ms (4.25%) |
14 |
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.46 ms (3.99%) |
10 |
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
]
|
|
2.93 ms (3.38%) |
10 |
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:
[
23
]
|
|
2.91 ms (3.35%) |
10 |
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:
[
2
]
|
|
2.16 ms (2.48%) |
8 |
SELECT t0.template_name AS template_name_1, t0.template_html AS template_html_2, t0.template_type AS template_type_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_template t0 WHERE t0.id = ?
Parameters:
[
8
]
|
|
1.99 ms (2.29%) |
7 |
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.68 ms (1.94%) |
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, c0_.template_id AS template_id_11, c0_.page_category_id AS page_category_id_12 FROM cms_page c0_ INNER JOIN cms_page_extra_field_content c1_ ON c0_.id = c1_.page_id INNER JOIN cms_page_content_date c2_ ON c1_.page_content_date_id = c2_.id WHERE (c0_.id IN (SELECT c3_.id FROM cms_page c3_ INNER JOIN cms_page_category c4_ ON c3_.page_category_id = c4_.id INNER JOIN cms_page_extra_field_content c5_ ON c3_.id = c5_.page_id INNER JOIN cms_page_content_blog_category c6_ ON c5_.page_content_blog_category_id = c6_.id INNER JOIN cms_blog_category c7_ ON c6_.blog_category_id = c7_.id WHERE c4_.category_type = ? AND c7_.category_name = ? AND c3_.page_published = 1)) AND c1_.content_name = ? ORDER BY c2_.date DESC LIMIT 3
Parameters:
[ "blog" "News" "date" ] |
|
1.41 ms (1.63%) |
5 |
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_link_id AS page_content_link_id_7 FROM cms_page_content_link_translation t0 WHERE t0.page_content_link_id = ?
Parameters:
[
10
]
|
|
1.31 ms (1.51%) |
5 |
SELECT t0.date AS date_1, t0.class AS class_2, t0.style AS style_3, t0.improved_format AS improved_format_4, t0.id AS id_5, t0.created_at AS created_at_6, t0.updated_at AS updated_at_7 FROM cms_page_content_date t0 WHERE t0.id = ?
Parameters:
[
3
]
|
|
1.17 ms (1.35%) |
4 |
SELECT t0.page_name AS page_name_1, t0.page_published AS page_published_2, t0.page_css_file_global AS page_css_file_global_3, t0.page_css_global AS page_css_global_4, t0.page_js_file_global AS page_js_file_global_5, t0.page_js_global AS page_js_global_6, t0.page_order AS page_order_7, t0.id AS id_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t0.uuid AS uuid_11, t0.template_id AS template_id_12, t0.page_category_id AS page_category_id_13 FROM cms_page t0 WHERE t0.id = ?
Parameters:
[
11
]
|
|
0.81 ms (0.94%) |
3 |
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, t0.blog_category_id AS blog_category_id_6 FROM cms_page_content_blog_category t0 WHERE t0.id = ?
Parameters:
[
3
]
|
|
0.65 ms (0.75%) |
2 |
INSERT INTO cms_visit_hour (year, month, day, hour, visits, visits_total, country, language, created_at, updated_at, page_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 2026 1 29 12 1 1 "US" null "2026-01-29 12:04:13" null null ] |
|
0.61 ms (0.71%) |
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_category_id AS page_category_id_7 FROM cms_page_category_translation t0 WHERE t0.page_category_id = ?
Parameters:
[
3
]
|
|
0.58 ms (0.67%) |
2 |
UPDATE cms_visit SET nb_visit = ?, updated_at = ? WHERE id = ?
Parameters:
[ 2 "2026-01-29 12:04:13" 2430 ] |
|
0.58 ms (0.67%) |
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_editor_id AS page_content_editor_id_7 FROM cms_page_content_editor_translation t0 WHERE t0.page_content_editor_id = ?
Parameters:
[
31
]
|
|
0.57 ms (0.65%) |
2 |
DELETE FROM cms_visit WHERE date_visit <= ?
Parameters:
[
"2026-01-26 12:04:13"
]
|
|
0.51 ms (0.59%) |
2 |
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 WHERE t0.id = ?
Parameters:
[
3
]
|
|
0.49 ms (0.56%) |
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.63" "2026-01-29" ] |
|
0.40 ms (0.47%) |
2 |
"START TRANSACTION"
Parameters:
[] |
|
0.40 ms (0.46%) |
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, c0_.template_id AS template_id_11, c0_.page_category_id AS page_category_id_12 FROM cms_page c0_ WHERE c0_.id IN (SELECT c1_.id FROM cms_page c1_ INNER JOIN cms_page_category c2_ ON c1_.page_category_id = c2_.id WHERE c2_.category_name = ? AND c1_.page_published = 1) LIMIT 2
Parameters:
[
"event"
]
|
|
0.40 ms (0.46%) |
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:
[ "2026" "01" "29" "12" "US" ] |
|
0.39 ms (0.45%) |
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:
[ "2026" "01" "29" "12" "US" 2 "en" ] |
|
0.39 ms (0.44%) |
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.63" 2 "en" "2026-01-29" ] |
|
0.30 ms (0.34%) |
1 |
SELECT t0.nb_lines AS nb_lines_1, t0.nb_items_per_line AS nb_items_per_line_2, t0.pagination AS pagination_3, t0.class AS class_4, t0.order_by AS order_by_5, t0.id AS id_6, t0.created_at AS created_at_7, t0.updated_at AS updated_at_8, t0.page_category_id AS page_category_id_9, t0.template_id AS template_id_10 FROM cms_page_content_list t0 WHERE t0.id = ?
Parameters:
[
2
]
|
|
0.30 ms (0.34%) |
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.blog_category_id AS blog_category_id_7 FROM cms_blog_category_translation t0 WHERE t0.blog_category_id = ?
Parameters:
[
1
]
|
|
0.30 ms (0.34%) |
1 |
SELECT t0.first_large_item AS first_large_item_1, t0.nb_lines AS nb_lines_2, t0.nb_items_per_line AS nb_items_per_line_3, t0.pagination AS pagination_4, t0.class AS class_5, t0.order_by AS order_by_6, t0.id AS id_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9, t0.blog_category_id AS blog_category_id_10, t0.template_id AS template_id_11 FROM cms_page_content_blog t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
0.27 ms (0.31%) |
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
]
|
|
0.26 ms (0.30%) |
1 |
SELECT t0.category_name AS category_name_1, t0.id AS id_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.uuid AS uuid_5 FROM cms_blog_category 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.