Query Metrics
122
Database Queries
14
Different statements
107.24 ms
Query time
4
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
43.79 ms (40.83%) |
40 |
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"
]
|
20.98 ms (19.57%) |
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"
]
|
18.14 ms (16.92%) |
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" ] |
6.08 ms (5.67%) |
8 |
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"
]
|
4.21 ms (3.93%) |
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.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
]
|
2.95 ms (2.75%) |
1 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"tce2024_preprod"
]
|
2.44 ms (2.28%) |
3 |
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
]
|
2.39 ms (2.23%) |
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
]
|
1.66 ms (1.55%) |
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_.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
""
]
|
0.98 ms (0.91%) |
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:
[] |
0.93 ms (0.86%) |
2 |
SELECT DATABASE()
Parameters:
[] |
0.90 ms (0.84%) |
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.id = ?
Parameters:
[
1
]
|
0.90 ms (0.83%) |
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:
[
"/"
]
|
0.88 ms (0.82%) |
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:
[] |
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.