Query Metrics
589
Database Queries
43
Different statements
520.00 ms
Query time
4
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
109.06 ms (20.97%) |
150 |
SELECT l0_.created_at AS created_at_0, l0_.updated_at AS updated_at_1, l0_.active AS active_2, l0_.id AS id_3, l0_.name AS name_4, l0_.iso_code AS iso_code_5, l0_.locale AS locale_6, l0_.datetime_format AS datetime_format_7, l0_.date_format AS date_format_8, l0_.time_format AS time_format_9, l0_.is_default AS is_default_10 FROM language l0_ WHERE l0_.active = 1 AND l0_.locale = ?
Parameters:
[
"en"
]
|
100.19 ms (19.27%) |
131 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.active AS active_3, t0.id AS id_4, t0.alt AS alt_5, t0.legend AS legend_6, t0.title AS title_7, t0.slug AS slug_8, t0.iframe AS iframe_9, t0.document_file_name AS document_file_name_10, t0.document_type AS document_type_11, t0.document_size AS document_size_12, t0.document_url AS document_url_13, t0.description AS description_14, t0.subtitle AS subtitle_15, t0.begin_date AS begin_date_16, t0.end_date AS end_date_17, t0.main_category_id AS main_category_id_18, t0.thumbnail_id AS thumbnail_id_19 FROM media t0 WHERE t0.id = ?
Parameters:
[
1994
]
|
49.49 ms (9.52%) |
1 |
SELECT e0_.created_at AS created_at_0, e0_.updated_at AS updated_at_1, e0_.active AS active_2, e0_.id AS id_3, e0_.name AS name_4, e0_.slug AS slug_5, e0_.language_group AS language_group_6, e0_.chapo AS chapo_7, e0_.description AS description_8, e0_.ticketing_reference AS ticketing_reference_9, e0_.display_booking_button AS display_booking_button_10, e0_.event_length AS event_length_11, e0_.italic_title AS italic_title_12, e0_.short_title AS short_title_13, e0_.short_subtitle AS short_subtitle_14, e0_.calendar_title AS calendar_title_15, e0_.title AS title_16, e0_.tweet_sentence AS tweet_sentence_17, e0_.program_url AS program_url_18, e0_.distribution AS distribution_19, e0_.program AS program_20, e0_.to_read AS to_read_21, e0_.poster_displayed AS poster_displayed_22, e0_.calendar_displayed AS calendar_displayed_23, e0_.young_displayed AS young_displayed_24, e0_.subscription_active AS subscription_active_25, e0_.phone_booking_only AS phone_booking_only_26, e0_.information AS information_27, e0_.meta_title AS meta_title_28, e0_.meta_description AS meta_description_29, e0_.fb_title AS fb_title_30, e0_.fb_description AS fb_description_31, e0_.tw_title AS tw_title_32, e0_.tw_description AS tw_description_33, e0_.indexed AS indexed_34, e1_.created_at AS created_at_35, e1_.updated_at AS updated_at_36, e1_.active AS active_37, e1_.id AS id_38, e1_.name AS name_39, e1_.language_group AS language_group_40, e1_.slug AS slug_41, e1_.position AS position_42, e1_.keyword AS keyword_43, e1_.lft AS lft_44, e1_.rgt AS rgt_45, e1_.lvl AS lvl_46, e1_.calendar_displayed AS calendar_displayed_47, e1_.subtitle AS subtitle_48, e1_.meta_title AS meta_title_49, e1_.meta_description AS meta_description_50, e1_.fb_title AS fb_title_51, e1_.fb_description AS fb_description_52, e1_.tw_title AS tw_title_53, e1_.tw_description AS tw_description_54, e1_.indexed AS indexed_55, e2_.id AS id_56, e2_.position AS position_57, e2_.header_video AS header_video_58, m3_.created_at AS created_at_59, m3_.updated_at AS updated_at_60, m3_.active AS active_61, m3_.id AS id_62, m3_.alt AS alt_63, m3_.legend AS legend_64, m3_.title AS title_65, m3_.slug AS slug_66, m3_.iframe AS iframe_67, m3_.document_file_name AS document_file_name_68, m3_.document_type AS document_type_69, m3_.document_size AS document_size_70, m3_.document_url AS document_url_71, m3_.description AS description_72, m3_.subtitle AS subtitle_73, m3_.begin_date AS begin_date_74, m3_.end_date AS end_date_75, e4_.id AS id_76, e4_.language_group AS language_group_77, e4_.name AS name_78, e5_.id AS id_79, e5_.language_group AS language_group_80, e5_.event_date AS event_date_81, e5_.state AS state_82, e5_.report_date AS report_date_83, e5_.annotation AS annotation_84, e0_.main_category_id AS main_category_id_85, e0_.room_id AS room_id_86, e0_.season_id AS season_id_87, e0_.lang_id AS lang_id_88, e0_.ticketing_id AS ticketing_id_89, e0_.event_type_id AS event_type_id_90, e0_.seating_plan_id AS seating_plan_id_91, e0_.social_image_id AS social_image_id_92, e1_.tree_root AS tree_root_93, e1_.parent_id AS parent_id_94, e1_.lang_id AS lang_id_95, e1_.social_image_id AS social_image_id_96, e2_.event_id AS event_id_97, e2_.media_id AS media_id_98, m3_.main_category_id AS main_category_id_99, m3_.thumbnail_id AS thumbnail_id_100, e4_.event_id AS event_id_101, e4_.lang_id AS lang_id_102, e5_.event_date_block_id AS event_date_block_id_103, e5_.lang_id AS lang_id_104 FROM event e0_ INNER JOIN language l6_ ON e0_.lang_id = l6_.id AND (l6_.id = ?) INNER JOIN event_category e1_ ON e0_.main_category_id = e1_.id INNER JOIN event_media e2_ ON e0_.id = e2_.event_id INNER JOIN media m3_ ON e2_.media_id = m3_.id LEFT JOIN room r7_ ON e0_.room_id = r7_.id LEFT JOIN season s8_ ON e0_.season_id = s8_.id LEFT JOIN event_date_block e4_ ON e0_.id = e4_.event_id LEFT JOIN event_date e5_ ON e4_.id = e5_.event_date_block_id WHERE e0_.active = 1 AND e0_.poster_displayed = 1 AND e5_.event_date >= ? ORDER BY e5_.event_date ASC
Parameters:
[ 2 "2025-04-26 04:14:28" ] |
40.14 ms (7.72%) |
36 |
SELECT p0_.created_at AS created_at_0, p0_.updated_at AS updated_at_1, p0_.active AS active_2, p0_.id AS id_3, p0_.title AS title_4, p0_.subtitle AS subtitle_5, p0_.slug AS slug_6, p0_.keyword AS keyword_7, p0_.controller AS controller_8, p0_.language_group AS language_group_9, p0_.type AS type_10, p0_.meta_title AS meta_title_11, p0_.meta_description AS meta_description_12, p0_.fb_title AS fb_title_13, p0_.fb_description AS fb_description_14, p0_.tw_title AS tw_title_15, p0_.tw_description AS tw_description_16, p0_.indexed AS indexed_17, c1_.created_at AS created_at_18, c1_.updated_at AS updated_at_19, c1_.active AS active_20, c1_.id AS id_21, c1_.title AS title_22, c1_.slug AS slug_23, c1_.language_group AS language_group_24, c1_.fields AS fields_25, c1_.meta_title AS meta_title_26, c1_.meta_description AS meta_description_27, c1_.fb_title AS fb_title_28, c1_.fb_description AS fb_description_29, c1_.tw_title AS tw_title_30, c1_.tw_description AS tw_description_31, c1_.indexed AS indexed_32, p0_.lang_id AS lang_id_33, p0_.parent_id AS parent_id_34, p0_.social_image_id AS social_image_id_35, c1_.content_type_id AS content_type_id_36, c1_.lang_id AS lang_id_37, c1_.page_id AS page_id_38, c1_.social_image_id AS social_image_id_39 FROM PAGE p0_ INNER JOIN language l2_ ON p0_.lang_id = l2_.id AND (l2_.id = ?) LEFT JOIN content c1_ ON p0_.id = c1_.page_id WHERE p0_.id = ?
Parameters:
[ 2 65 ] |
23.21 ms (4.46%) |
23 |
SELECT s0_.created_at AS created_at_0, s0_.updated_at AS updated_at_1, s0_.active AS active_2, s0_.id AS id_3, s0_.name AS name_4, s0_.slug AS slug_5, s0_.language_group AS language_group_6, s0_.begin_year AS begin_year_7, s0_.translation_enabled AS translation_enabled_8, s0_.primary_color AS primary_color_9, s0_.secondary_color AS secondary_color_10, s0_.subtitle AS subtitle_11, s0_.meta_title AS meta_title_12, s0_.meta_description AS meta_description_13, s0_.fb_title AS fb_title_14, s0_.fb_description AS fb_description_15, s0_.tw_title AS tw_title_16, s0_.tw_description AS tw_description_17, s0_.indexed AS indexed_18, s0_.lang_id AS lang_id_19, s0_.logo_id AS logo_id_20, s0_.header_id AS header_id_21, s0_.social_image_id AS social_image_id_22 FROM season s0_ INNER JOIN language l1_ ON s0_.lang_id = l1_.id AND (l1_.id = ?) WHERE s0_.begin_year = ?
Parameters:
[ 2 2024 ] |
20.06 ms (3.86%) |
31 |
SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.classname AS classname_2, h0_.position AS position_3, h0_.display_hook AS display_hook_4, h0_.module_id AS module_id_5 FROM hook h0_ WHERE h0_.name = ?
Parameters:
[
"ContentSaved"
]
|
17.83 ms (3.43%) |
26 |
SELECT u0_.created_at AS created_at_0, u0_.updated_at AS updated_at_1, u0_.active AS active_2, u0_.id AS id_3, u0_.name AS name_4, u0_.slug AS slug_5, u0_.keyword AS keyword_6, u0_.entity AS entity_7, u0_.controller AS controller_8, u0_.position AS position_9, u0_.manager AS manager_10, u0_.page_id AS page_id_11 FROM url u0_ WHERE u0_.active = 1 AND u0_.entity = ?
Parameters:
[
"Season"
]
|
17.41 ms (3.35%) |
23 |
SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.classname AS classname_2, h0_.position AS position_3, h0_.display_hook AS display_hook_4, h0_.module_id AS module_id_5 FROM hook h0_ INNER JOIN module m1_ ON h0_.module_id = m1_.id WHERE m1_.name = ? AND h0_.name = ?
Parameters:
[ "TceModule" "actionEventCategoryFormPreSetData" ] |
14.12 ms (2.72%) |
11 |
SELECT p0_.created_at AS created_at_0, p0_.updated_at AS updated_at_1, p0_.active AS active_2, p0_.id AS id_3, p0_.title AS title_4, p0_.subtitle AS subtitle_5, p0_.slug AS slug_6, p0_.keyword AS keyword_7, p0_.controller AS controller_8, p0_.language_group AS language_group_9, p0_.type AS type_10, p0_.meta_title AS meta_title_11, p0_.meta_description AS meta_description_12, p0_.fb_title AS fb_title_13, p0_.fb_description AS fb_description_14, p0_.tw_title AS tw_title_15, p0_.tw_description AS tw_description_16, p0_.indexed AS indexed_17, p0_.lang_id AS lang_id_18, p0_.parent_id AS parent_id_19, p0_.social_image_id AS social_image_id_20 FROM PAGE p0_ INNER JOIN language l1_ ON p0_.lang_id = l1_.id AND (l1_.id = ?) WHERE p0_.language_group = ?
Parameters:
[ 2 b"h\x19\x12ާÓ\x11íUMV‚Ó¹¯" ] |
14.02 ms (2.70%) |
18 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.active AS active_3, t0.id AS id_4, t0.title AS title_5, t0.subtitle AS subtitle_6, t0.slug AS slug_7, t0.keyword AS keyword_8, t0.controller AS controller_9, t0.language_group AS language_group_10, t0.type AS type_11, t0.meta_title AS meta_title_12, t0.meta_description AS meta_description_13, t0.fb_title AS fb_title_14, t0.fb_description AS fb_description_15, t0.tw_title AS tw_title_16, t0.tw_description AS tw_description_17, t0.indexed AS indexed_18, t0.lang_id AS lang_id_19, t0.parent_id AS parent_id_20, t0.social_image_id AS social_image_id_21 FROM PAGE t0 WHERE t0.id = ?
Parameters:
[
4
]
|
13.38 ms (2.57%) |
9 |
SELECT p0_.created_at AS created_at_0, p0_.updated_at AS updated_at_1, p0_.active AS active_2, p0_.id AS id_3, p0_.title AS title_4, p0_.subtitle AS subtitle_5, p0_.slug AS slug_6, p0_.keyword AS keyword_7, p0_.controller AS controller_8, p0_.language_group AS language_group_9, p0_.type AS type_10, p0_.meta_title AS meta_title_11, p0_.meta_description AS meta_description_12, p0_.fb_title AS fb_title_13, p0_.fb_description AS fb_description_14, p0_.tw_title AS tw_title_15, p0_.tw_description AS tw_description_16, p0_.indexed AS indexed_17, c1_.created_at AS created_at_18, c1_.updated_at AS updated_at_19, c1_.active AS active_20, c1_.id AS id_21, c1_.title AS title_22, c1_.slug AS slug_23, c1_.language_group AS language_group_24, c1_.fields AS fields_25, c1_.meta_title AS meta_title_26, c1_.meta_description AS meta_description_27, c1_.fb_title AS fb_title_28, c1_.fb_description AS fb_description_29, c1_.tw_title AS tw_title_30, c1_.tw_description AS tw_description_31, c1_.indexed AS indexed_32, p0_.lang_id AS lang_id_33, p0_.parent_id AS parent_id_34, p0_.social_image_id AS social_image_id_35, c1_.content_type_id AS content_type_id_36, c1_.lang_id AS lang_id_37, c1_.page_id AS page_id_38, c1_.social_image_id AS social_image_id_39 FROM PAGE p0_ INNER JOIN language l2_ ON p0_.lang_id = l2_.id AND (l2_.id = ?) LEFT JOIN content c1_ ON p0_.id = c1_.page_id WHERE p0_.keyword = ?
Parameters:
[ 2 "home" ] |
11.43 ms (2.20%) |
13 |
SELECT e0_.created_at AS created_at_0, e0_.updated_at AS updated_at_1, e0_.active AS active_2, e0_.id AS id_3, e0_.name AS name_4, e0_.language_group AS language_group_5, e0_.slug AS slug_6, e0_.position AS position_7, e0_.keyword AS keyword_8, e0_.lft AS lft_9, e0_.rgt AS rgt_10, e0_.lvl AS lvl_11, e0_.calendar_displayed AS calendar_displayed_12, e0_.subtitle AS subtitle_13, e0_.meta_title AS meta_title_14, e0_.meta_description AS meta_description_15, e0_.fb_title AS fb_title_16, e0_.fb_description AS fb_description_17, e0_.tw_title AS tw_title_18, e0_.tw_description AS tw_description_19, e0_.indexed AS indexed_20, e0_.tree_root AS tree_root_21, e0_.parent_id AS parent_id_22, e0_.lang_id AS lang_id_23, e0_.social_image_id AS social_image_id_24 FROM event_category e0_ INNER JOIN language l1_ ON e0_.lang_id = l1_.id AND (l1_.id = ?) WHERE e0_.active = 1 AND e0_.id = ?
Parameters:
[ 2 24 ] |
11.34 ms (2.18%) |
18 |
SELECT t0_.id AS id_0, t0_.name AS name_1 FROM theme t0_ WHERE t0_.name = ?
Parameters:
[
"Countdown"
]
|
9.89 ms (1.90%) |
13 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.active AS active_3, t0.id AS id_4, t0.name AS name_5, t0.slug AS slug_6, t0.height AS height_7, t0.width AS width_8, t0.theme_use AS theme_use_9 FROM image_format t0 INNER JOIN media_image_format ON t0.id = media_image_format.image_format_id WHERE media_image_format.media_id = ?
Parameters:
[
5752
]
|
9.48 ms (1.82%) |
13 |
SELECT u0_.created_at AS created_at_0, u0_.updated_at AS updated_at_1, u0_.active AS active_2, u0_.id AS id_3, u0_.name AS name_4, u0_.slug AS slug_5, u0_.keyword AS keyword_6, u0_.entity AS entity_7, u0_.controller AS controller_8, u0_.position AS position_9, u0_.manager AS manager_10, u0_.page_id AS page_id_11 FROM url u0_ WHERE u0_.active = 1 AND u0_.keyword = ?
Parameters:
[
"eventCategory"
]
|
8.53 ms (1.64%) |
10 |
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.type AS type_2, p0_.param_key AS param_key_3, p0_.param_value AS param_value_4, p0_.available_value AS available_value_5, p0_.validations AS validations_6, p0_.tab_name AS tab_name_7, p0_.block_name AS block_name_8, p0_.breakpoints_value AS breakpoints_value_9, p0_.general_parameter AS general_parameter_10 FROM parameter p0_ WHERE p0_.param_key = ?
Parameters:
[
"module_TceModule_allow_auto_slide"
]
|
8.12 ms (1.56%) |
13 |
SELECT i0_.created_at AS created_at_0, i0_.updated_at AS updated_at_1, i0_.active AS active_2, i0_.id AS id_3, i0_.name AS name_4, i0_.slug AS slug_5, i0_.height AS height_6, i0_.width AS width_7, i0_.theme_use AS theme_use_8 FROM image_format i0_ WHERE i0_.active = 1 AND i0_.slug = ?
Parameters:
[
"home-slider"
]
|
7.21 ms (1.39%) |
10 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.active AS active_3, t0.id AS id_4, t0.name AS name_5, t0.page_type AS page_type_6, t0.display_blocks AS display_blocks_7, t0.max_object_nb AS max_object_nb_8, t0.keyword AS keyword_9, t0.fields AS fields_10, t0.page_parent_id AS page_parent_id_11 FROM content_type t0 WHERE t0.id = ?
Parameters:
[
1
]
|
3.02 ms (0.58%) |
5 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.active AS active_3, t0.id AS id_4, t0.name AS name_5 FROM module t0 WHERE t0.id = ?
Parameters:
[
44
]
|
2.99 ms (0.57%) |
2 |
SELECT p0_.created_at AS created_at_0, p0_.updated_at AS updated_at_1, p0_.active AS active_2, p0_.id AS id_3, p0_.title AS title_4, p0_.subtitle AS subtitle_5, p0_.slug AS slug_6, p0_.keyword AS keyword_7, p0_.controller AS controller_8, p0_.language_group AS language_group_9, p0_.type AS type_10, p0_.meta_title AS meta_title_11, p0_.meta_description AS meta_description_12, p0_.fb_title AS fb_title_13, p0_.fb_description AS fb_description_14, p0_.tw_title AS tw_title_15, p0_.tw_description AS tw_description_16, p0_.indexed AS indexed_17, p0_.lang_id AS lang_id_18, p0_.parent_id AS parent_id_19, p0_.social_image_id AS social_image_id_20 FROM PAGE p0_ INNER JOIN language l1_ ON p0_.lang_id = l1_.id WHERE p0_.language_group = ? AND l1_.id = ?
Parameters:
[ b"H‚¾¤§Ñ\x11í¦Àã\x01X*€\x14" 1 ] |
2.71 ms (0.52%) |
2 |
SELECT p0_.created_at AS created_at_0, p0_.updated_at AS updated_at_1, p0_.active AS active_2, p0_.id AS id_3, p0_.title AS title_4, p0_.subtitle AS subtitle_5, p0_.slug AS slug_6, p0_.keyword AS keyword_7, p0_.controller AS controller_8, p0_.language_group AS language_group_9, p0_.type AS type_10, p0_.meta_title AS meta_title_11, p0_.meta_description AS meta_description_12, p0_.fb_title AS fb_title_13, p0_.fb_description AS fb_description_14, p0_.tw_title AS tw_title_15, p0_.tw_description AS tw_description_16, p0_.indexed AS indexed_17, c1_.created_at AS created_at_18, c1_.updated_at AS updated_at_19, c1_.active AS active_20, c1_.id AS id_21, c1_.title AS title_22, c1_.slug AS slug_23, c1_.language_group AS language_group_24, c1_.fields AS fields_25, c1_.meta_title AS meta_title_26, c1_.meta_description AS meta_description_27, c1_.fb_title AS fb_title_28, c1_.fb_description AS fb_description_29, c1_.tw_title AS tw_title_30, c1_.tw_description AS tw_description_31, c1_.indexed AS indexed_32, p0_.lang_id AS lang_id_33, p0_.parent_id AS parent_id_34, p0_.social_image_id AS social_image_id_35, c1_.content_type_id AS content_type_id_36, c1_.lang_id AS lang_id_37, c1_.page_id AS page_id_38, c1_.social_image_id AS social_image_id_39 FROM PAGE p0_ INNER JOIN language l2_ ON p0_.lang_id = l2_.id AND (l2_.id = ?) LEFT JOIN content c1_ ON p0_.id = c1_.page_id WHERE p0_.slug = ?
Parameters:
[ 2 "home" ] |
2.63 ms (0.51%) |
1 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"tce2024_preprod"
]
|
2.53 ms (0.49%) |
3 |
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_3 FROM (SELECT m0_.created_at AS created_at_0, m0_.updated_at AS updated_at_1, m0_.active AS active_2, m0_.id AS id_3, m0_.name AS name_4 FROM module m0_ WHERE m0_.active = ? ORDER BY m0_.name ASC) dctrn_result) dctrn_table
Parameters:
[
1
]
|
2.23 ms (0.43%) |
3 |
SELECT m0_.created_at AS created_at_0, m0_.updated_at AS updated_at_1, m0_.active AS active_2, m0_.id AS id_3, m0_.name AS name_4 FROM module m0_ WHERE m0_.active = ? ORDER BY m0_.name ASC
Parameters:
[
1
]
|
2.06 ms (0.40%) |
3 |
SELECT l0_.created_at AS created_at_0, l0_.updated_at AS updated_at_1, l0_.active AS active_2, l0_.id AS id_3, l0_.name AS name_4, l0_.iso_code AS iso_code_5, l0_.locale AS locale_6, l0_.datetime_format AS datetime_format_7, l0_.date_format AS date_format_8, l0_.time_format AS time_format_9, l0_.is_default AS is_default_10 FROM language l0_ WHERE l0_.is_default = 1
Parameters:
[] |
1.58 ms (0.30%) |
2 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.active AS active_3, t0.id AS id_4, t0.name AS name_5, t0.short_description AS short_description_6, t0.slug AS slug_7, t0.position AS position_8, t0.keyword AS keyword_9, t0.lft AS lft_10, t0.rgt AS rgt_11, t0.lvl AS lvl_12, t0.language_group AS language_group_13, t0.tree_root AS tree_root_14, t0.parent_id AS parent_id_15, t0.lang_id AS lang_id_16 FROM media_category t0 INNER JOIN media_media_category ON t0.id = media_media_category.media_category_id WHERE media_media_category.media_id = ?
Parameters:
[
5735
]
|
1.28 ms (0.25%) |
2 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.active AS active_3, t0.id AS id_4, t0.name AS name_5, t0.short_description AS short_description_6, t0.slug AS slug_7, t0.position AS position_8, t0.keyword AS keyword_9, t0.lft AS lft_10, t0.rgt AS rgt_11, t0.lvl AS lvl_12, t0.language_group AS language_group_13, t0.tree_root AS tree_root_14, t0.parent_id AS parent_id_15, t0.lang_id AS lang_id_16 FROM media_category t0 WHERE t0.id = ?
Parameters:
[
3
]
|
1.16 ms (0.22%) |
2 |
SELECT DATABASE()
Parameters:
[] |
1.03 ms (0.20%) |
1 |
SELECT h0_.id AS id_0, h0_.name AS name_1, h0_.classname AS classname_2, h0_.position AS position_3, h0_.display_hook AS display_hook_4, h0_.module_id AS module_id_5 FROM hook h0_ ORDER BY h0_.name ASC, h0_.position ASC
Parameters:
[] |
1.02 ms (0.20%) |
1 |
SELECT s0_.created_at AS created_at_0, s0_.updated_at AS updated_at_1, s0_.active AS active_2, s0_.id AS id_3, s0_.name AS name_4, s0_.slug AS slug_5, s0_.slider_position AS slider_position_6, s0_.title AS title_7, s0_.subtitle AS subtitle_8, s0_.url AS url_9, s0_.dates AS dates_10, s0_.display_event AS display_event_11, s0_.language_group AS language_group_12, s0_.image_id AS image_id_13, s0_.event_id AS event_id_14, s0_.lang_id AS lang_id_15 FROM slider_element s0_ INNER JOIN language l1_ ON s0_.lang_id = l1_.id AND (l1_.id = ?) WHERE s0_.active = 1 ORDER BY s0_.slider_position ASC
Parameters:
[
2
]
|
1.01 ms (0.19%) |
1 |
SELECT f0_.created_at AS created_at_0, f0_.updated_at AS updated_at_1, f0_.active AS active_2, f0_.id AS id_3, f0_.title AS title_4, f0_.slug AS slug_5, f0_.description AS description_6, f0_.begin_date AS begin_date_7, f0_.end_date AS end_date_8, f0_.language_group AS language_group_9, f0_.lang_id AS lang_id_10 FROM flash_info f0_ INNER JOIN language l1_ ON f0_.lang_id = l1_.id AND (l1_.id = ?) WHERE f0_.active = 1 AND ((f0_.begin_date IS NULL OR f0_.begin_date < ?)) AND ((f0_.end_date IS NULL OR f0_.end_date > ?)) ORDER BY f0_.created_at ASC
Parameters:
[ 2 "2025-04-26 07:14:28" "2025-04-26 07:14:28" ] |
0.95 ms (0.18%) |
1 |
SELECT s0_.created_at AS created_at_0, s0_.updated_at AS updated_at_1, s0_.active AS active_2, s0_.id AS id_3, s0_.name AS name_4, s0_.slug AS slug_5, s0_.language_group AS language_group_6, s0_.begin_year AS begin_year_7, s0_.translation_enabled AS translation_enabled_8, s0_.primary_color AS primary_color_9, s0_.secondary_color AS secondary_color_10, s0_.subtitle AS subtitle_11, s0_.meta_title AS meta_title_12, s0_.meta_description AS meta_description_13, s0_.fb_title AS fb_title_14, s0_.fb_description AS fb_description_15, s0_.tw_title AS tw_title_16, s0_.tw_description AS tw_description_17, s0_.indexed AS indexed_18, s0_.lang_id AS lang_id_19, s0_.logo_id AS logo_id_20, s0_.header_id AS header_id_21, s0_.social_image_id AS social_image_id_22 FROM season s0_ INNER JOIN language l1_ ON s0_.lang_id = l1_.id AND (l1_.id = ?) WHERE s0_.active = 1 ORDER BY s0_.id ASC
Parameters:
[
2
]
|
0.91 ms (0.17%) |
1 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.active AS active_3, t0.id AS id_4, t0.title AS title_5, t0.subtitle AS subtitle_6, t0.description AS description_7, t0.slug AS slug_8, t0.publication_date AS publication_date_9, t0.language_group AS language_group_10, t0.meta_title AS meta_title_11, t0.meta_description AS meta_description_12, t0.fb_title AS fb_title_13, t0.fb_description AS fb_description_14, t0.tw_title AS tw_title_15, t0.tw_description AS tw_description_16, t0.indexed AS indexed_17, t0.lang_id AS lang_id_18, t0.main_media_id AS main_media_id_19, t0.main_category_id AS main_category_id_20, t0.social_image_id AS social_image_id_21 FROM article t0 INNER JOIN article_media_category ON t0.id = article_media_category.article_id WHERE article_media_category.media_category_id = ?
Parameters:
[
56
]
|
0.88 ms (0.17%) |
1 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.active AS active_3, t0.id AS id_4, t0.alt AS alt_5, t0.legend AS legend_6, t0.title AS title_7, t0.slug AS slug_8, t0.iframe AS iframe_9, t0.document_file_name AS document_file_name_10, t0.document_type AS document_type_11, t0.document_size AS document_size_12, t0.document_url AS document_url_13, t0.description AS description_14, t0.subtitle AS subtitle_15, t0.begin_date AS begin_date_16, t0.end_date AS end_date_17, t0.main_category_id AS main_category_id_18, t0.thumbnail_id AS thumbnail_id_19 FROM media t0 INNER JOIN media_media_category ON t0.id = media_media_category.media_id WHERE media_media_category.media_category_id = ?
Parameters:
[
56
]
|
0.88 ms (0.17%) |
1 |
SELECT s0_.created_at AS created_at_0, s0_.updated_at AS updated_at_1, s0_.active AS active_2, s0_.id AS id_3, s0_.name AS name_4, s0_.slug AS slug_5, s0_.language_group AS language_group_6, s0_.begin_year AS begin_year_7, s0_.translation_enabled AS translation_enabled_8, s0_.primary_color AS primary_color_9, s0_.secondary_color AS secondary_color_10, s0_.subtitle AS subtitle_11, s0_.meta_title AS meta_title_12, s0_.meta_description AS meta_description_13, s0_.fb_title AS fb_title_14, s0_.fb_description AS fb_description_15, s0_.tw_title AS tw_title_16, s0_.tw_description AS tw_description_17, s0_.indexed AS indexed_18, s0_.lang_id AS lang_id_19, s0_.logo_id AS logo_id_20, s0_.header_id AS header_id_21, s0_.social_image_id AS social_image_id_22 FROM season s0_ INNER JOIN language l1_ ON s0_.lang_id = l1_.id AND (l1_.id = ?) WHERE s0_.active = 1 AND s0_.slug = ?
Parameters:
[ 2 "home" ] |
0.87 ms (0.17%) |
1 |
SELECT u0_.created_at AS created_at_0, u0_.updated_at AS updated_at_1, u0_.active AS active_2, u0_.id AS id_3, u0_.name AS name_4, u0_.slug AS slug_5, u0_.keyword AS keyword_6, u0_.entity AS entity_7, u0_.controller AS controller_8, u0_.position AS position_9, u0_.manager AS manager_10, u0_.page_id AS page_id_11 FROM url u0_ WHERE u0_.active = 1 ORDER BY u0_.position ASC
Parameters:
[] |
0.87 ms (0.17%) |
1 |
SELECT s0_.created_at AS created_at_0, s0_.updated_at AS updated_at_1, s0_.active AS active_2, s0_.id AS id_3, s0_.name AS name_4, s0_.slug AS slug_5, s0_.language_group AS language_group_6, s0_.begin_year AS begin_year_7, s0_.translation_enabled AS translation_enabled_8, s0_.primary_color AS primary_color_9, s0_.secondary_color AS secondary_color_10, s0_.subtitle AS subtitle_11, s0_.meta_title AS meta_title_12, s0_.meta_description AS meta_description_13, s0_.fb_title AS fb_title_14, s0_.fb_description AS fb_description_15, s0_.tw_title AS tw_title_16, s0_.tw_description AS tw_description_17, s0_.indexed AS indexed_18, s0_.lang_id AS lang_id_19, s0_.logo_id AS logo_id_20, s0_.header_id AS header_id_21, s0_.social_image_id AS social_image_id_22 FROM season s0_ INNER JOIN language l1_ ON s0_.lang_id = l1_.id AND (l1_.id = ?) WHERE s0_.active = 1 AND s0_.id = ?
Parameters:
[ 2 14 ] |
0.85 ms (0.16%) |
1 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.active AS active_3, t0.id AS id_4, t0.name AS name_5, t0.short_description AS short_description_6, t0.slug AS slug_7, t0.position AS position_8, t0.keyword AS keyword_9, t0.lft AS lft_10, t0.rgt AS rgt_11, t0.lvl AS lvl_12, t0.language_group AS language_group_13, t0.tree_root AS tree_root_14, t0.parent_id AS parent_id_15, t0.lang_id AS lang_id_16 FROM media_category t0 INNER JOIN article_media_category ON t0.id = article_media_category.media_category_id WHERE article_media_category.article_id = ?
Parameters:
[
422
]
|
0.83 ms (0.16%) |
1 |
SELECT m0_.created_at AS created_at_0, m0_.updated_at AS updated_at_1, m0_.active AS active_2, m0_.id AS id_3, m0_.name AS name_4, m0_.short_description AS short_description_5, m0_.slug AS slug_6, m0_.position AS position_7, m0_.keyword AS keyword_8, m0_.lft AS lft_9, m0_.rgt AS rgt_10, m0_.lvl AS lvl_11, m0_.language_group AS language_group_12, m0_.tree_root AS tree_root_13, m0_.parent_id AS parent_id_14, m0_.lang_id AS lang_id_15 FROM media_category m0_ INNER JOIN language l1_ ON m0_.lang_id = l1_.id AND (l1_.id = ?) WHERE m0_.active = 1 AND m0_.lvl = ? AND m0_.slug = ? ORDER BY m0_.tree_root ASC, m0_.position ASC
Parameters:
[ 1 1 "home-du-site" ] |
0.80 ms (0.15%) |
1 |
SELECT r0_.created_at AS created_at_0, r0_.updated_at AS updated_at_1, r0_.active AS active_2, r0_.id AS id_3, r0_.redirect_type AS redirect_type_4, r0_.redirect_from AS redirect_from_5, r0_.redirect_to AS redirect_to_6 FROM redirection r0_ WHERE r0_.active = 1 AND r0_.redirect_from = ? ORDER BY r0_.created_at DESC
Parameters:
[
"/en/home"
]
|
0.80 ms (0.15%) |
1 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.active AS active_3, t0.id AS id_4, t0.name AS name_5, t0.page_type AS page_type_6, t0.display_blocks AS display_blocks_7, t0.max_object_nb AS max_object_nb_8, t0.keyword AS keyword_9, t0.fields AS fields_10, t0.page_parent_id AS page_parent_id_11 FROM content_type t0 WHERE t0.page_parent_id = ?
Parameters:
[
64
]
|
0.65 ms (0.12%) |
1 |
SELECT t0.created_at AS created_at_1, t0.updated_at AS updated_at_2, t0.active AS active_3, t0.id AS id_4, t0.name AS name_5, t0.data AS data_6, t0.type AS type_7, t0.catalog_synchronization AS catalog_synchronization_8, t0.customer_profile AS customer_profile_9, t0.order_tunnel AS order_tunnel_10, t0.default_ticketing AS default_ticketing_11, t0.last_sync_at AS last_sync_at_12, t0.module_id AS module_id_13 FROM ticketing t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.57 ms (0.11%) |
1 |
SELECT l0_.created_at AS created_at_0, l0_.updated_at AS updated_at_1, l0_.active AS active_2, l0_.id AS id_3, l0_.name AS name_4, l0_.iso_code AS iso_code_5, l0_.locale AS locale_6, l0_.datetime_format AS datetime_format_7, l0_.date_format AS date_format_8, l0_.time_format AS time_format_9, l0_.is_default AS is_default_10 FROM language l0_ WHERE l0_.active = 1 AND l0_.is_default = 1
Parameters:
[] |
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.