Query Metrics
140
Database Queries
14
Different statements
85.83 ms
Query time
4
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
27.55 ms (32.10%) |
50 |
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.68 ms (24.10%) |
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.28 ms (21.30%) |
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" ] |
4.80 ms (5.59%) |
11 |
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.41 ms (3.97%) |
8 |
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.slug = ? LIMIT 1
Parameters:
[
"_fragment"
]
|
2.56 ms (2.98%) |
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.80 ms (2.10%) |
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 "_fragment" ] |
1.46 ms (1.70%) |
1 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"tce2024_preprod"
]
|
1.45 ms (1.68%) |
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.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
]
|
1.15 ms (1.34%) |
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 (1.08%) |
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.80 ms (0.93%) |
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:
[
"/_fragment"
]
|
0.56 ms (0.65%) |
2 |
SELECT DATABASE()
Parameters:
[] |
0.41 ms (0.48%) |
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:
[ 1 "_fragment" ] |
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.