Query Metrics
595
Database Queries
39
Different statements
1015.82 ms
Query time
4
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
227.94 ms (22.44%) |
124 |
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:
[
5465
]
|
190.53 ms (18.76%) |
126 |
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:
[
"fr"
]
|
164.15 ms (16.16%) |
109 |
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:
[
"core_maintenance_mode"
]
|
56.31 ms (5.54%) |
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" ] |
55.58 ms (5.47%) |
15 |
SELECT t0_.id AS id_0, t0_.name AS name_1 FROM theme t0_ WHERE t0_.name = ?
Parameters:
[
"FlashInfo"
]
|
46.92 ms (4.62%) |
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"
]
|
46.77 ms (4.60%) |
37 |
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:
[ 1 42 ] |
31.79 ms (3.13%) |
22 |
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:
[ 1 2024 ] |
27.33 ms (2.69%) |
14 |
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:
[
15
]
|
18.94 ms (1.86%) |
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:
[] |
17.83 ms (1.76%) |
10 |
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:
[ 1 "home" ] |
14.35 ms (1.41%) |
9 |
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
]
|
11.59 ms (1.14%) |
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:
[ 1 7 ] |
11.46 ms (1.13%) |
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"
]
|
11.46 ms (1.13%) |
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_.tree_root = ? AND m0_.lvl = ? AND m0_.lft > ? AND m0_.rgt < ? ORDER BY m0_.tree_root ASC, m0_.position ASC
Parameters:
[ 1 1 2 2 81 ] |
8.84 ms (0.87%) |
4 |
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
]
|
8.72 ms (0.86%) |
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, e0_.main_category_id AS main_category_id_35, e0_.room_id AS room_id_36, e0_.season_id AS season_id_37, e0_.lang_id AS lang_id_38, e0_.ticketing_id AS ticketing_id_39, e0_.event_type_id AS event_type_id_40, e0_.seating_plan_id AS seating_plan_id_41, e0_.social_image_id AS social_image_id_42 FROM event e0_ INNER JOIN language l1_ ON e0_.lang_id = l1_.id AND (l1_.id = ?) WHERE e0_.slug = ? AND e0_.active = 1
Parameters:
[ 1 "un-dimanche-avec-liya-petrova" ] |
8.68 ms (0.85%) |
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:
[] |
7.61 ms (0.75%) |
2 |
SELECT a0_.created_at AS created_at_0, a0_.updated_at AS updated_at_1, a0_.active AS active_2, a0_.id AS id_3, a0_.title AS title_4, a0_.subtitle AS subtitle_5, a0_.description AS description_6, a0_.slug AS slug_7, a0_.publication_date AS publication_date_8, a0_.language_group AS language_group_9, a0_.meta_title AS meta_title_10, a0_.meta_description AS meta_description_11, a0_.fb_title AS fb_title_12, a0_.fb_description AS fb_description_13, a0_.tw_title AS tw_title_14, a0_.tw_description AS tw_description_15, a0_.indexed AS indexed_16, a0_.lang_id AS lang_id_17, a0_.main_media_id AS main_media_id_18, a0_.main_category_id AS main_category_id_19, a0_.social_image_id AS social_image_id_20 FROM article a0_ INNER JOIN language l1_ ON a0_.lang_id = l1_.id WHERE a0_.language_group = ? AND l1_.id = ?
Parameters:
[ b"b:¿\x02‗ô\x11´¬<çcì4î)" 2 ] |
7.13 ms (0.70%) |
1 |
SELECT a0_.created_at AS created_at_0, a0_.updated_at AS updated_at_1, a0_.active AS active_2, a0_.id AS id_3, a0_.title AS title_4, a0_.subtitle AS subtitle_5, a0_.description AS description_6, a0_.slug AS slug_7, a0_.publication_date AS publication_date_8, a0_.language_group AS language_group_9, a0_.meta_title AS meta_title_10, a0_.meta_description AS meta_description_11, a0_.fb_title AS fb_title_12, a0_.fb_description AS fb_description_13, a0_.tw_title AS tw_title_14, a0_.tw_description AS tw_description_15, a0_.indexed AS indexed_16, a0_.lang_id AS lang_id_17, a0_.main_media_id AS main_media_id_18, a0_.main_category_id AS main_category_id_19, a0_.social_image_id AS social_image_id_20 FROM article a0_ INNER JOIN language l1_ ON a0_.lang_id = l1_.id WHERE a0_.active = 1 AND a0_.slug = ?
Parameters:
[
"un-dimanche-avec-liya-petrova"
]
|
6.81 ms (0.67%) |
4 |
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:
[] |
5.15 ms (0.51%) |
1 |
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.keyword AS keyword_2, m0_.language_group AS language_group_3, m0_.menu_type AS menu_type_4, m0_.value AS value_5, m0_.target AS target_6, m0_.active AS active_7, m0_.no_follow AS no_follow_8, m0_.lft AS lft_9, m0_.rgt AS rgt_10, m0_.lvl AS lvl_11, m1_.created_at AS created_at_12, m1_.updated_at AS updated_at_13, m1_.active AS active_14, m1_.id AS id_15, m1_.alt AS alt_16, m1_.legend AS legend_17, m1_.title AS title_18, m1_.slug AS slug_19, m1_.iframe AS iframe_20, m1_.document_file_name AS document_file_name_21, m1_.document_type AS document_type_22, m1_.document_size AS document_size_23, m1_.document_url AS document_url_24, m1_.description AS description_25, m1_.subtitle AS subtitle_26, m1_.begin_date AS begin_date_27, m1_.end_date AS end_date_28 FROM menu_entry m0_ LEFT JOIN media m1_ ON m0_.media_id = m1_.id INNER JOIN language l2_ ON m0_.lang_id = l2_.id AND (l2_.id = ?) ORDER BY m0_.tree_root ASC, m0_.lft ASC
Parameters:
[
1
]
|
4.11 ms (0.40%) |
8 |
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:
[
"MediaCategory"
]
|
4.09 ms (0.40%) |
1 |
SELECT a0_.created_at AS created_at_0, a0_.updated_at AS updated_at_1, a0_.active AS active_2, a0_.id AS id_3, a0_.title AS title_4, a0_.subtitle AS subtitle_5, a0_.description AS description_6, a0_.slug AS slug_7, a0_.publication_date AS publication_date_8, a0_.language_group AS language_group_9, a0_.meta_title AS meta_title_10, a0_.meta_description AS meta_description_11, a0_.fb_title AS fb_title_12, a0_.fb_description AS fb_description_13, a0_.tw_title AS tw_title_14, a0_.tw_description AS tw_description_15, a0_.indexed AS indexed_16, a0_.lang_id AS lang_id_17, a0_.main_media_id AS main_media_id_18, a0_.main_category_id AS main_category_id_19, a0_.social_image_id AS social_image_id_20 FROM article a0_ LEFT JOIN media_category m1_ ON a0_.main_category_id = m1_.id WHERE a0_.active = 1 AND a0_.id <> ? AND a0_.publication_date <= ? ORDER BY a0_.publication_date DESC, a0_.created_at DESC LIMIT 1
Parameters:
[ 421 "2025-02-25 00:00:00" ] |
3.66 ms (0.36%) |
1 |
SELECT m0_.id AS id_0, m0_.name AS name_1, m0_.keyword AS keyword_2, m0_.language_group AS language_group_3, m0_.menu_type AS menu_type_4, m0_.value AS value_5, m0_.target AS target_6, m0_.active AS active_7, m0_.no_follow AS no_follow_8, m0_.lft AS lft_9, m0_.rgt AS rgt_10, m0_.lvl AS lvl_11 FROM menu_entry m0_ INNER JOIN language l1_ ON m0_.lang_id = l1_.id AND (l1_.id = ?) ORDER BY m0_.tree_root ASC, m0_.lft ASC
Parameters:
[
1
]
|
2.50 ms (0.25%) |
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.41 ms (0.24%) |
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
]
|
1.93 ms (0.19%) |
1 |
SELECT a0_.created_at AS created_at_0, a0_.updated_at AS updated_at_1, a0_.active AS active_2, a0_.id AS id_3, a0_.title AS title_4, a0_.subtitle AS subtitle_5, a0_.description AS description_6, a0_.slug AS slug_7, a0_.publication_date AS publication_date_8, a0_.language_group AS language_group_9, a0_.meta_title AS meta_title_10, a0_.meta_description AS meta_description_11, a0_.fb_title AS fb_title_12, a0_.fb_description AS fb_description_13, a0_.tw_title AS tw_title_14, a0_.tw_description AS tw_description_15, a0_.indexed AS indexed_16, a0_.lang_id AS lang_id_17, a0_.main_media_id AS main_media_id_18, a0_.main_category_id AS main_category_id_19, a0_.social_image_id AS social_image_id_20 FROM article a0_ LEFT JOIN media_category m1_ ON a0_.main_category_id = m1_.id WHERE a0_.active = 1 AND a0_.id <> ? AND a0_.publication_date >= ? ORDER BY a0_.publication_date DESC, a0_.created_at DESC LIMIT 1
Parameters:
[ 421 "2025-02-25 00:00:00" ] |
1.75 ms (0.17%) |
1 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"tce2024_preprod"
]
|
1.62 ms (0.16%) |
2 |
SELECT DATABASE()
Parameters:
[] |
1.31 ms (0.13%) |
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, m1_.created_at AS created_at_13, m1_.updated_at AS updated_at_14, m1_.active AS active_15, m1_.id AS id_16, m1_.name AS name_17, m1_.short_description AS short_description_18, m1_.slug AS slug_19, m1_.position AS position_20, m1_.keyword AS keyword_21, m1_.lft AS lft_22, m1_.rgt AS rgt_23, m1_.lvl AS lvl_24, m1_.language_group AS language_group_25, m2_.created_at AS created_at_26, m2_.updated_at AS updated_at_27, m2_.active AS active_28, m2_.id AS id_29, m2_.name AS name_30, m2_.short_description AS short_description_31, m2_.slug AS slug_32, m2_.position AS position_33, m2_.keyword AS keyword_34, m2_.lft AS lft_35, m2_.rgt AS rgt_36, m2_.lvl AS lvl_37, m2_.language_group AS language_group_38, m0_.tree_root AS tree_root_39, m0_.parent_id AS parent_id_40, m0_.lang_id AS lang_id_41, m1_.tree_root AS tree_root_42, m1_.parent_id AS parent_id_43, m1_.lang_id AS lang_id_44, m2_.tree_root AS tree_root_45, m2_.parent_id AS parent_id_46, m2_.lang_id AS lang_id_47 FROM media_category m0_ INNER JOIN language l3_ ON m0_.lang_id = l3_.id AND (l3_.id = ?) LEFT JOIN media_category m1_ ON m0_.id = m1_.parent_id LEFT JOIN media_category m2_ ON m1_.id = m2_.parent_id WHERE m0_.active = 1 AND m0_.slug = ? ORDER BY m0_.tree_root ASC, m0_.position ASC, m1_.position ASC, m2_.position ASC, m1_.lft ASC, m2_.lft ASC
Parameters:
[ 1 "lire" ] |
1.23 ms (0.12%) |
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:
[ 1 "medias-hors-champs" ] |
1.21 ms (0.12%) |
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 "types" ] |
1.09 ms (0.11%) |
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:
[ 1 13 ] |
0.95 ms (0.09%) |
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:
[
1
]
|
0.90 ms (0.09%) |
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 article_media_category ON t0.id = article_media_category.media_category_id WHERE article_media_category.article_id = ?
Parameters:
[
420
]
|
0.43 ms (0.04%) |
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.42 ms (0.04%) |
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:
[
"/medias-hors-champs/lire/un-dimanche-avec-liya-petrova"
]
|
0.37 ms (0.04%) |
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.language_group AS language_group_6, t0.columns AS columns_7, t0.article_id AS article_id_8, t0.lang_id AS lang_id_9 FROM article_block t0 WHERE t0.article_id = ?
Parameters:
[
421
]
|
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.