Query Metrics
426
Database Queries
44
Different statements
621.00 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
144.80 ms (23.32%) |
102 |
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"
]
|
107.50 ms (17.31%) |
48 |
SELECT t0_.id AS id_0, t0_.name AS name_1 FROM theme t0_ WHERE t0_.name = ?
Parameters:
[
"Brevo"
]
|
104.33 ms (16.80%) |
76 |
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"
]
|
35.47 ms (5.71%) |
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"
]
|
29.88 ms (4.81%) |
18 |
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:
[ "EventArticle" "actionEventFormPreSetData" ] |
28.52 ms (4.59%) |
21 |
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.main_category_id AS main_category_id_14, t0.thumbnail_id AS thumbnail_id_15 FROM media t0 WHERE t0.id = ?
Parameters:
[
338
]
|
24.08 ms (3.88%) |
21 |
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_.meta_title AS meta_title_10, p0_.meta_description AS meta_description_11, p0_.fb_title AS fb_title_12, p0_.fb_description AS fb_description_13, p0_.tw_title AS tw_title_14, p0_.tw_description AS tw_description_15, p0_.indexed AS indexed_16, c1_.created_at AS created_at_17, c1_.updated_at AS updated_at_18, c1_.active AS active_19, c1_.id AS id_20, c1_.title AS title_21, c1_.slug AS slug_22, c1_.language_group AS language_group_23, c1_.fields AS fields_24, c1_.meta_title AS meta_title_25, c1_.meta_description AS meta_description_26, c1_.fb_title AS fb_title_27, c1_.fb_description AS fb_description_28, c1_.tw_title AS tw_title_29, c1_.tw_description AS tw_description_30, c1_.indexed AS indexed_31, p0_.lang_id AS lang_id_32, p0_.parent_id AS parent_id_33, p0_.social_image_id AS social_image_id_34, c1_.content_type_id AS content_type_id_35, c1_.lang_id AS lang_id_36, c1_.page_id AS page_id_37, c1_.social_image_id AS social_image_id_38 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 51 ] |
16.48 ms (2.65%) |
10 |
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:
[
"Event"
]
|
13.60 ms (2.19%) |
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:
[] |
11.74 ms (1.89%) |
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.name AS name_5 FROM module t0 WHERE t0.id = ?
Parameters:
[
62
]
|
8.44 ms (1.36%) |
13 |
SELECT t0.id AS id_1, t0.value AS value_2, t0.custom AS custom_3, t0.feature_id AS feature_id_4 FROM feature_value t0 WHERE t0.id = ?
Parameters:
[
164
]
|
8.27 ms (1.33%) |
3 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.event_id AS event_id_3, t0.media_id AS media_id_4 FROM event_media t0 WHERE t0.event_id = ?
Parameters:
[
72
]
|
6.66 ms (1.07%) |
2 |
SELECT f0_.id AS id_0, e1_.created_at AS created_at_1, e1_.updated_at AS updated_at_2, e1_.active AS active_3, e1_.id AS id_4, e1_.name AS name_5, e1_.slug AS slug_6, e1_.language_group AS language_group_7, e1_.chapo AS chapo_8, e1_.description AS description_9, e1_.ticketing_reference AS ticketing_reference_10, e1_.display_booking_button AS display_booking_button_11, e1_.event_length AS event_length_12, e1_.about_event AS about_event_13, e1_.meta_title AS meta_title_14, e1_.meta_description AS meta_description_15, e1_.fb_title AS fb_title_16, e1_.fb_description AS fb_description_17, e1_.tw_title AS tw_title_18, e1_.tw_description AS tw_description_19, e1_.indexed AS indexed_20, f2_.created_at AS created_at_21, f2_.updated_at AS updated_at_22, f2_.active AS active_23, f2_.id AS id_24, f2_.name AS name_25, f2_.slug AS slug_26, f2_.keyword AS keyword_27, f2_.type AS type_28, f2_.position AS position_29, f2_.filter AS filter_30, f2_.filter_type AS filter_type_31, f2_.language_group AS language_group_32, f3_.created_at AS created_at_33, f3_.updated_at AS updated_at_34, f3_.active AS active_35, f3_.id AS id_36, f3_.name AS name_37, f3_.slug AS slug_38, f3_.keyword AS keyword_39, f3_.language_group AS language_group_40, f0_.event_id AS event_id_41, f0_.product_id AS product_id_42, f0_.feature_id AS feature_id_43, f0_.feature_value_id AS feature_value_id_44, e1_.main_category_id AS main_category_id_45, e1_.room_id AS room_id_46, e1_.season_id AS season_id_47, e1_.lang_id AS lang_id_48, e1_.ticketing_id AS ticketing_id_49, e1_.event_type_id AS event_type_id_50, e1_.social_image_id AS social_image_id_51, f2_.feature_category_id AS feature_category_id_52, f2_.lang_id AS lang_id_53, f3_.lang_id AS lang_id_54 FROM feature_link f0_ INNER JOIN event e1_ ON f0_.event_id = e1_.id AND (e1_.id = ?) INNER JOIN feature f2_ ON f0_.feature_id = f2_.id INNER JOIN feature_category f3_ ON f2_.feature_category_id = f3_.id AND (f3_.keyword = ?) WHERE e1_.active = 1 AND f2_.active = 1
Parameters:
[ 72 "distribution" ] |
6.32 ms (1.02%) |
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, 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:
[
9
]
|
6.15 ms (0.99%) |
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.slug AS slug_6, t0.image_to_crop AS image_to_crop_7, t0.height AS height_8, t0.width AS width_9, t0.theme_use AS theme_use_10 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:
[
338
]
|
6.00 ms (0.97%) |
1 |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.language_group AS language_group_2, e1_.id AS id_3, e1_.name AS name_4, e1_.language_group AS language_group_5, e1_.annotation AS annotation_6, e1_.price AS price_7, e1_.ticketing_reference AS ticketing_reference_8, e0_.event_id AS event_id_9, e0_.lang_id AS lang_id_10, e1_.event_price_block_id AS event_price_block_id_11, e1_.lang_id AS lang_id_12 FROM event_price_block e0_ INNER JOIN event e2_ ON e0_.event_id = e2_.id INNER JOIN event_price e1_ ON e0_.id = e1_.event_price_block_id WHERE e2_.id = ? ORDER BY e0_.id ASC, e1_.price DESC
Parameters:
[
72
]
|
5.91 ms (0.95%) |
1 |
SELECT e0_.id AS id_0, e0_.language_group AS language_group_1, e0_.name AS name_2, e1_.id AS id_3, e1_.language_group AS language_group_4, e1_.event_date AS event_date_5, e1_.state AS state_6, e1_.report_date AS report_date_7, e1_.annotation AS annotation_8, e0_.event_id AS event_id_9, e0_.lang_id AS lang_id_10, e1_.event_date_block_id AS event_date_block_id_11, e1_.lang_id AS lang_id_12 FROM event_date_block e0_ INNER JOIN event e2_ ON e0_.event_id = e2_.id INNER JOIN event_date e1_ ON e0_.id = e1_.event_date_block_id WHERE e2_.id = ? ORDER BY e0_.id ASC, e1_.event_date ASC
Parameters:
[
72
]
|
5.40 ms (0.87%) |
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.slug AS slug_7, t0.keyword AS keyword_8, t0.controller AS controller_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.parent_id AS parent_id_19, t0.social_image_id AS social_image_id_20 FROM PAGE t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
"spectacles/vinegar-tom"
]
|
4.99 ms (0.80%) |
2 |
SELECT DATABASE()
Parameters:
[] |
4.68 ms (0.75%) |
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.slug AS slug_6, t0.language_group AS language_group_7, t0.seats_nb AS seats_nb_8, t0.area AS area_9, t0.meta_title AS meta_title_10, t0.meta_description AS meta_description_11, t0.fb_title AS fb_title_12, t0.fb_description AS fb_description_13, t0.tw_title AS tw_title_14, t0.tw_description AS tw_description_15, t0.indexed AS indexed_16, t0.lang_id AS lang_id_17, t0.social_image_id AS social_image_id_18 FROM room t0 WHERE t0.id = ?
Parameters:
[
12
]
|
3.92 ms (0.63%) |
2 |
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.language_group AS language_group_2, e0_.annotation AS annotation_3, e0_.price AS price_4, e0_.ticketing_reference AS ticketing_reference_5, e1_.id AS id_6, e1_.name AS name_7, e1_.language_group AS language_group_8, e2_.created_at AS created_at_9, e2_.updated_at AS updated_at_10, e2_.active AS active_11, e2_.id AS id_12, e2_.name AS name_13, e2_.slug AS slug_14, e2_.language_group AS language_group_15, e2_.chapo AS chapo_16, e2_.description AS description_17, e2_.ticketing_reference AS ticketing_reference_18, e2_.display_booking_button AS display_booking_button_19, e2_.event_length AS event_length_20, e2_.about_event AS about_event_21, e2_.meta_title AS meta_title_22, e2_.meta_description AS meta_description_23, e2_.fb_title AS fb_title_24, e2_.fb_description AS fb_description_25, e2_.tw_title AS tw_title_26, e2_.tw_description AS tw_description_27, e2_.indexed AS indexed_28, e0_.event_price_block_id AS event_price_block_id_29, e0_.lang_id AS lang_id_30, e1_.event_id AS event_id_31, e1_.lang_id AS lang_id_32, e2_.main_category_id AS main_category_id_33, e2_.room_id AS room_id_34, e2_.season_id AS season_id_35, e2_.lang_id AS lang_id_36, e2_.ticketing_id AS ticketing_id_37, e2_.event_type_id AS event_type_id_38, e2_.social_image_id AS social_image_id_39 FROM event_price e0_ INNER JOIN event_price_block e1_ ON e0_.event_price_block_id = e1_.id INNER JOIN event e2_ ON e1_.event_id = e2_.id WHERE e2_.id = ? ORDER BY e0_.price ASC
Parameters:
[
72
]
|
3.92 ms (0.63%) |
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_.about_event AS about_event_12, e0_.meta_title AS meta_title_13, e0_.meta_description AS meta_description_14, e0_.fb_title AS fb_title_15, e0_.fb_description AS fb_description_16, e0_.tw_title AS tw_title_17, e0_.tw_description AS tw_description_18, e0_.indexed AS indexed_19, e0_.main_category_id AS main_category_id_20, e0_.room_id AS room_id_21, e0_.season_id AS season_id_22, e0_.lang_id AS lang_id_23, e0_.ticketing_id AS ticketing_id_24, e0_.event_type_id AS event_type_id_25, e0_.social_image_id AS social_image_id_26 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 "vinegar-tom" ] |
3.65 ms (0.59%) |
6 |
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_.image_to_crop AS image_to_crop_6, i0_.height AS height_7, i0_.width AS width_8, i0_.theme_use AS theme_use_9 FROM image_format i0_ WHERE i0_.active = 1 AND i0_.slug = ?
Parameters:
[
"event-header-slider"
]
|
3.59 ms (0.58%) |
1 |
SELECT t0.id AS id_1, t0.content AS content_2, t0.name AS name_3, t0.rating AS rating_4, t0.event_id AS event_id_5 FROM feedback t0 WHERE t0.event_id = ?
Parameters:
[
72
]
|
3.55 ms (0.57%) |
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.52 ms (0.41%) |
3 |
SELECT t0.id AS id_1, t0.language_group AS language_group_2, t0.name AS name_3, t0.event_id AS event_id_4, t0.lang_id AS lang_id_5 FROM event_date_block t0 WHERE t0.event_id = ?
Parameters:
[
72
]
|
2.22 ms (0.36%) |
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.33%) |
1 |
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_.meta_title AS meta_title_10, p0_.meta_description AS meta_description_11, p0_.fb_title AS fb_title_12, p0_.fb_description AS fb_description_13, p0_.tw_title AS tw_title_14, p0_.tw_description AS tw_description_15, p0_.indexed AS indexed_16, c1_.created_at AS created_at_17, c1_.updated_at AS updated_at_18, c1_.active AS active_19, c1_.id AS id_20, c1_.title AS title_21, c1_.slug AS slug_22, c1_.language_group AS language_group_23, c1_.fields AS fields_24, c1_.meta_title AS meta_title_25, c1_.meta_description AS meta_description_26, c1_.fb_title AS fb_title_27, c1_.fb_description AS fb_description_28, c1_.tw_title AS tw_title_29, c1_.tw_description AS tw_description_30, c1_.indexed AS indexed_31, p0_.lang_id AS lang_id_32, p0_.parent_id AS parent_id_33, p0_.social_image_id AS social_image_id_34, c1_.content_type_id AS content_type_id_35, c1_.lang_id AS lang_id_36, c1_.page_id AS page_id_37, c1_.social_image_id AS social_image_id_38 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 "spectacles" ] |
2.05 ms (0.33%) |
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.95 ms (0.31%) |
3 |
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_.meta_title AS meta_title_10, p0_.meta_description AS meta_description_11, p0_.fb_title AS fb_title_12, p0_.fb_description AS fb_description_13, p0_.tw_title AS tw_title_14, p0_.tw_description AS tw_description_15, p0_.indexed AS indexed_16, c1_.created_at AS created_at_17, c1_.updated_at AS updated_at_18, c1_.active AS active_19, c1_.id AS id_20, c1_.title AS title_21, c1_.slug AS slug_22, c1_.language_group AS language_group_23, c1_.fields AS fields_24, c1_.meta_title AS meta_title_25, c1_.meta_description AS meta_description_26, c1_.fb_title AS fb_title_27, c1_.fb_description AS fb_description_28, c1_.tw_title AS tw_title_29, c1_.tw_description AS tw_description_30, c1_.indexed AS indexed_31, p0_.lang_id AS lang_id_32, p0_.parent_id AS parent_id_33, p0_.social_image_id AS social_image_id_34, c1_.content_type_id AS content_type_id_35, c1_.lang_id AS lang_id_36, c1_.page_id AS page_id_37, c1_.social_image_id AS social_image_id_38 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" ] |
1.75 ms (0.28%) |
1 |
SELECT e0_.id AS id_0, e0_.language_group AS language_group_1, e0_.event_date AS event_date_2, e0_.state AS state_3, e0_.report_date AS report_date_4, e0_.annotation AS annotation_5, e1_.id AS id_6, e1_.language_group AS language_group_7, e1_.name AS name_8, e2_.created_at AS created_at_9, e2_.updated_at AS updated_at_10, e2_.active AS active_11, e2_.id AS id_12, e2_.name AS name_13, e2_.slug AS slug_14, e2_.language_group AS language_group_15, e2_.chapo AS chapo_16, e2_.description AS description_17, e2_.ticketing_reference AS ticketing_reference_18, e2_.display_booking_button AS display_booking_button_19, e2_.event_length AS event_length_20, e2_.about_event AS about_event_21, e2_.meta_title AS meta_title_22, e2_.meta_description AS meta_description_23, e2_.fb_title AS fb_title_24, e2_.fb_description AS fb_description_25, e2_.tw_title AS tw_title_26, e2_.tw_description AS tw_description_27, e2_.indexed AS indexed_28, e0_.event_date_block_id AS event_date_block_id_29, e0_.lang_id AS lang_id_30, e1_.event_id AS event_id_31, e1_.lang_id AS lang_id_32, e2_.main_category_id AS main_category_id_33, e2_.room_id AS room_id_34, e2_.season_id AS season_id_35, e2_.lang_id AS lang_id_36, e2_.ticketing_id AS ticketing_id_37, e2_.event_type_id AS event_type_id_38, e2_.social_image_id AS social_image_id_39 FROM event_date e0_ INNER JOIN event_date_block e1_ ON e0_.event_date_block_id = e1_.id INNER JOIN event e2_ ON e1_.event_id = e2_.id WHERE e2_.id = ? ORDER BY e0_.event_date ASC
Parameters:
[
72
]
|
1.50 ms (0.24%) |
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:
[] |
1.46 ms (0.24%) |
1 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"troisiemetype"
]
|
1.16 ms (0.19%) |
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.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.meta_title AS meta_title_13, t0.meta_description AS meta_description_14, t0.fb_title AS fb_title_15, t0.fb_description AS fb_description_16, t0.tw_title AS tw_title_17, t0.tw_description AS tw_description_18, t0.indexed AS indexed_19, t0.tree_root AS tree_root_20, t0.parent_id AS parent_id_21, t0.lang_id AS lang_id_22, t0.social_image_id AS social_image_id_23 FROM event_category t0 WHERE t0.id = ?
Parameters:
[
4
]
|
1.10 ms (0.18%) |
2 |
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
]
|
0.99 ms (0.16%) |
2 |
SELECT t0.id AS id_1, t0.language_group AS language_group_2, t0.event_date AS event_date_3, t0.state AS state_4, t0.report_date AS report_date_5, t0.annotation AS annotation_6, t0.event_date_block_id AS event_date_block_id_7, t0.lang_id AS lang_id_8 FROM event_date t0 WHERE t0.event_date_block_id = ?
Parameters:
[
157
]
|
0.83 ms (0.13%) |
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.slug AS slug_6, t0.language_group AS language_group_7, t0.chapo AS chapo_8, t0.description AS description_9, t0.ticketing_reference AS ticketing_reference_10, t0.display_booking_button AS display_booking_button_11, t0.event_length AS event_length_12, t0.about_event AS about_event_13, t0.meta_title AS meta_title_14, t0.meta_description AS meta_description_15, t0.fb_title AS fb_title_16, t0.fb_description AS fb_description_17, t0.tw_title AS tw_title_18, t0.tw_description AS tw_description_19, t0.indexed AS indexed_20, t0.main_category_id AS main_category_id_21, t0.room_id AS room_id_22, t0.season_id AS season_id_23, t0.lang_id AS lang_id_24, t0.ticketing_id AS ticketing_id_25, t0.event_type_id AS event_type_id_26, t0.social_image_id AS social_image_id_27 FROM event t0 WHERE t0.id = ?
Parameters:
[
73
]
|
0.80 ms (0.13%) |
2 |
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_.meta_title AS meta_title_8, s0_.meta_description AS meta_description_9, s0_.fb_title AS fb_title_10, s0_.fb_description AS fb_description_11, s0_.tw_title AS tw_title_12, s0_.tw_description AS tw_description_13, s0_.indexed AS indexed_14, s0_.lang_id AS lang_id_15, s0_.social_image_id AS social_image_id_16 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 1 ] |
0.73 ms (0.12%) |
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.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.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.parent_id AS parent_id_19, t0.social_image_id AS social_image_id_20 FROM PAGE t0 WHERE t0.id = ?
Parameters:
[
42
]
|
0.49 ms (0.08%) |
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.slug AS slug_6, t0.language_group AS language_group_7, t0.description AS description_8, t0.meta_title AS meta_title_9, t0.meta_description AS meta_description_10, t0.fb_title AS fb_title_11, t0.fb_description AS fb_description_12, t0.tw_title AS tw_title_13, t0.tw_description AS tw_description_14, t0.indexed AS indexed_15, t0.lang_id AS lang_id_16, t0.social_image_id AS social_image_id_17 FROM tag t0 INNER JOIN event_tag ON t0.id = event_tag.tag_id WHERE event_tag.event_id = ?
Parameters:
[
72
]
|
0.39 ms (0.06%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.document_file_name AS document_file_name_3, t0.document_type AS document_type_4, t0.document_size AS document_size_5, t0.document_url AS document_url_6, t0.event_id AS event_id_7 FROM document t0 WHERE t0.event_id = ?
Parameters:
[
72
]
|
0.39 ms (0.06%) |
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:
[
8
]
|
0.36 ms (0.06%) |
1 |
SELECT t0.id AS id_1, t0.position AS position_2, t0.content AS content_3, t0.author AS author_4, t0.event_id AS event_id_5 FROM event_article t0 WHERE t0.event_id = ?
Parameters:
[
72
]
|
0.35 ms (0.06%) |
1 |
SELECT t0.id AS id_1, t0.link_position AS link_position_2, t0.event_from_id AS event_from_id_3, t0.event_to_id AS event_to_id_4 FROM event_link t0 WHERE t0.event_from_id = ?
Parameters:
[
72
]
|
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.