Query Metrics
86
Database Queries
12
Different statements
136.34 ms
Query time
2
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
45.38 ms (33.29%) |
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"
]
|
26.85 ms (19.70%) |
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
]
|
22.14 ms (16.24%) |
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" ] |
17.43 ms (12.78%) |
8 |
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"
]
|
6.44 ms (4.72%) |
2 |
SELECT DATABASE()
Parameters:
[] |
5.98 ms (4.38%) |
5 |
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"
]
|
3.55 ms (2.61%) |
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:
[] |
2.70 ms (1.98%) |
1 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"troisiemetype"
]
|
1.73 ms (1.27%) |
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_.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" ] |
1.65 ms (1.21%) |
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.slug = ? LIMIT 1
Parameters:
[
"spectacles/meduses"
]
|
1.42 ms (1.04%) |
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 "meduses" ] |
1.06 ms (0.78%) |
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:
[] |
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.