Query Metrics
85
Database Queries
32
Different statements
1088.41 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
430.98 ms (39.60%) |
1 |
SELECT s0_.domain AS domain_0, s0_.label AS label_1, s1_.content AS content_2 FROM std_translations s0_ INNER JOIN std_translations_content s1_ ON (s0_.id = s1_.translation_id) WHERE s1_.language_code = ? ORDER BY s0_.domain ASC, s0_.label ASC
Parameters:
[
"pt"
]
|
|
182.03 ms (16.72%) |
8 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1769387659 "pfOnV5ZbFG:std_features" ] |
|
161.74 ms (14.86%) |
35 |
SELECT t0.machine_name AS machine_name_1, t0.label AS label_2, t0.value AS value_3, t0.description_machine_name AS description_machine_name_4, t0.details_machine_name AS details_machine_name_5, t0.parent_name AS parent_name_6, t0.variable_type AS variable_type_7, t0.order_value AS order_value_8, t0.is_hidden AS is_hidden_9, t0.is_active AS is_active_10, t0.created_date AS created_date_11, t0.updated_date AS updated_date_12, t0.content AS content_13, t0.language_code AS language_code_14, t0.roles AS roles_15, t0.created_by AS created_by_16, t0.updated_by AS updated_by_17 FROM std_config t0 WHERE t0.machine_name = ? AND t0.language_code = ? LIMIT 1
Parameters:
[
"MAIL_DRIVER"
""
]
|
|
86.10 ms (7.91%) |
1 |
"COMMIT"
Parameters:
[] |
|
83.84 ms (7.70%) |
1 |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.machine_name AS machine_name_2, s0_.type AS type_3, s0_.is_active AS is_active_4, s0_.created_date AS created_date_5, s0_.updated_date AS updated_date_6, s0_.order_value AS order_value_7, s1_.id AS id_8, s1_.attribute_machine_name AS attribute_machine_name_9, s1_.label AS label_10, s1_.value AS value_11, s1_.order_value AS order_value_12, s1_.color AS color_13, s1_.image AS image_14, s1_.created_date AS created_date_15, s1_.updated_date AS updated_date_16, s0_.created_by AS created_by_17, s0_.updated_by AS updated_by_18, s1_.attribute_id AS attribute_id_19, s1_.created_by AS created_by_20, s1_.updated_by AS updated_by_21 FROM std_pages_attributes_values s2_ INNER JOIN std_attributes s0_ ON (s2_.attribute_machine_name = s0_.machine_name) INNER JOIN std_attributes_values s1_ ON (s0_.id = s1_.attribute_id AND s2_.value = s1_.value) WHERE s2_.page_id = ? ORDER BY s0_.order_value ASC, s1_.order_value ASC
Parameters:
[
581
]
|
|
79.58 ms (7.31%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.machine_name AS machine_name_3, t0.machine_name_categories AS machine_name_categories_4, t0.is_category AS is_category_5, t0.is_active AS is_active_6, t0.created_by AS created_by_7, t0.created_date AS created_date_8, t0.updated_by AS updated_by_9, t0.updated_date AS updated_date_10, t0.in_navigation AS in_navigation_11 FROM std_content_types t0 WHERE t0.id = ?
Parameters:
[
419
]
|
|
9.51 ms (0.87%) |
6 |
SELECT DATABASE()
Parameters:
[] |
|
6.73 ms (0.62%) |
1 |
INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES (?, ?, ?, ?) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time)
Parameters:
[ 2 => 1800 3 => 1769387659 0 => "wGziWeNk0O:std_redirects_6437420e8d674de543874b286f30a396" 1 => "N;" ] |
|
6.49 ms (0.60%) |
1 |
SELECT t0.id AS id_1, t0.url AS url_2, t0.language_code AS language_code_3, t0.relation_tree AS relation_tree_4, t0.is_canonical AS is_canonical_5, t0.page_id AS page_id_6, t0.relation_id AS relation_id_7 FROM std_friendly_url t0 WHERE t0.url = ? LIMIT 1
Parameters:
[
"/pt/corredores-do-leca"
]
|
|
4.86 ms (0.45%) |
2 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"studio5"
]
|
|
3.67 ms (0.34%) |
4 |
SELECT t0.is_active AS is_active_1, t0.created_date AS created_date_2, t0.updated_date AS updated_date_3, t0.title AS title_4, t0.url AS url_5, t0.meta_title AS meta_title_6, t0.meta_keywords AS meta_keywords_7, t0.meta_description AS meta_description_8, t0.og_title AS og_title_9, t0.og_image AS og_image_10, t0.og_description AS og_description_11, t0.og_url AS og_url_12, t0.canonical_url AS canonical_url_13, t0.scripts_head AS scripts_head_14, t0.scripts_body AS scripts_body_15, t0.scripts_footer AS scripts_footer_16, t0.content AS content_17, t0.page_id AS page_id_18, t0.language_code AS language_code_19, t0.created_by AS created_by_20, t0.updated_by AS updated_by_21 FROM std_pages_content t0 WHERE t0.page_id = ? AND t0.language_code = ? LIMIT 1
Parameters:
[ 158 "pt" ] |
|
3.49 ms (0.32%) |
1 |
SELECT DISTINCT k.CONSTRAINT_NAME, k.COLUMN_NAME, k.REFERENCED_TABLE_NAME, k.REFERENCED_COLUMN_NAME, k.ORDINAL_POSITION /*!50116, c.UPDATE_RULE, c.DELETE_RULE */ FROM information_schema.key_column_usage k /*!50116 INNER JOIN information_schema.referential_constraints c ON c.CONSTRAINT_NAME = k.CONSTRAINT_NAME AND c.TABLE_NAME = k.TABLE_NAME */ WHERE k.TABLE_SCHEMA = ? AND k.TABLE_NAME = ? AND k.REFERENCED_COLUMN_NAME IS NOT NULL /*!50116 AND c.CONSTRAINT_SCHEMA = 'studio5' */ ORDER BY k.ORDINAL_POSITION
Parameters:
[ "studio5" "doctrine_migration_versions" ] |
|
3.00 ms (0.28%) |
1 |
SELECT c.COLUMN_NAME AS field, c.COLUMN_TYPE AS type, c.IS_NULLABLE AS `null`, c.COLUMN_KEY AS `key`, c.COLUMN_DEFAULT AS `default`, c.EXTRA, c.COLUMN_COMMENT AS comment, c.CHARACTER_SET_NAME AS characterset, c.COLLATION_NAME AS collation FROM information_schema.COLUMNS c INNER JOIN information_schema.TABLES t ON t.TABLE_NAME = c.TABLE_NAME WHERE c.TABLE_SCHEMA = ? AND t.TABLE_SCHEMA = ? AND t.TABLE_TYPE = 'BASE TABLE' AND t.TABLE_NAME = ? ORDER BY ORDINAL_POSITION
Parameters:
[ "studio5" "studio5" "doctrine_migration_versions" ] |
|
2.96 ms (0.27%) |
1 |
SELECT t0.id AS id_1, t0.visited_at AS visited_at_2, t0.session_hash AS session_hash_3, t0.tracking_id AS tracking_id_4, t0.hashed_ip AS hashed_ip_5, t0.fingerprint AS fingerprint_6, t0.country AS country_7, t0.city AS city_8, t0.precise_country AS precise_country_9, t0.precise_city AS precise_city_10, t0.event AS event_11, t0.page_id AS page_id_12, t0.web_user_id AS web_user_id_13 FROM std_pages_tracking t0 WHERE t0.tracking_id = ? AND t0.page_id = ? AND t0.event = ? ORDER BY t0.visited_at DESC LIMIT 1
Parameters:
[ "894fd29bc9227e327691b07343d397a5de230fb177efca67c8fab03c13fd1220" 581 "open_page" ] |
|
2.94 ms (0.27%) |
1 |
SELECT t0.language_code AS language_code_1, t0.name AS name_2, t0.is_public AS is_public_3, t0.is_available_in_backoffice AS is_available_in_backoffice_4, t0.is_active AS is_active_5, t0.is_default AS is_default_6, t0.order_value AS order_value_7, t0.locale AS locale_8 FROM std_languages t0 WHERE t0.language_code = ? AND t0.is_active = ? AND t0.is_public = ? LIMIT 1
Parameters:
[ "pt" 1 1 ] |
|
2.03 ms (0.19%) |
3 |
INSERT INTO std_tag_tracking (tag_id, tracking_id) VALUES (?, ?)
Parameters:
[ 1364 61912 ] |
|
1.55 ms (0.14%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.password_date AS password_date_6, t0.failed_attempts AS failed_attempts_7, t0.force_password_change AS force_password_change_8, t0.last_login_date AS last_login_date_9, t0.penultimate_login_date AS penultimate_login_date_10, t0.language AS language_11, t0.is_locked AS is_locked_12, t0.is_super_user AS is_super_user_13, t0.is_deleted AS is_deleted_14, t0.is_active AS is_active_15, t0.created_date AS created_date_16, t0.updated_date AS updated_date_17, t0.author_function AS author_function_18, t0.user_image AS user_image_19, t0.created_by AS created_by_20, t0.updated_by AS updated_by_21 FROM std_users t0 INNER JOIN std_pages_authors ON t0.id = std_pages_authors.std_users_id WHERE std_pages_authors.std_pages_id = ?
Parameters:
[
581
]
|
|
1.48 ms (0.14%) |
1 |
INSERT INTO std_pages_tracking (visited_at, session_hash, tracking_id, hashed_ip, fingerprint, country, city, precise_country, precise_city, event, page_id, web_user_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ "2026-01-26 00:34:19" "6d20aac07d0ee191aa4eda6f3d5a8254dcb7e0ccd5da750e5807ceb64da08d92" "894fd29bc9227e327691b07343d397a5de230fb177efca67c8fab03c13fd1220" "6a78b3889de73317150325b27f5ad5c8b5e99354cc8c89249de6db2e79f47c0d" "f9e9f7754740c8215fa556e4deb32686945923ad040a80fcea01364bea6881a9" null null null null "open_page" 581 null ] |
|
1.47 ms (0.13%) |
1 |
SELECT t.TABLE_NAME, t.ENGINE, t.AUTO_INCREMENT, t.TABLE_COMMENT, t.CREATE_OPTIONS, t.TABLE_COLLATION, ccsa.CHARACTER_SET_NAME FROM information_schema.TABLES t INNER JOIN information_schema.COLLATION_CHARACTER_SET_APPLICABILITY ccsa ON ccsa.COLLATION_NAME = t.TABLE_COLLATION WHERE t.TABLE_SCHEMA = ? AND t.TABLE_NAME = ? AND t.TABLE_TYPE = 'BASE TABLE'
Parameters:
[ "studio5" "doctrine_migration_versions" ] |
|
1.46 ms (0.13%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.username AS username_3, t0.email AS email_4, t0.password AS password_5, t0.password_date AS password_date_6, t0.failed_attempts AS failed_attempts_7, t0.force_password_change AS force_password_change_8, t0.last_login_date AS last_login_date_9, t0.penultimate_login_date AS penultimate_login_date_10, t0.language AS language_11, t0.is_locked AS is_locked_12, t0.is_super_user AS is_super_user_13, t0.is_deleted AS is_deleted_14, t0.is_active AS is_active_15, t0.created_date AS created_date_16, t0.updated_date AS updated_date_17, t0.author_function AS author_function_18, t0.user_image AS user_image_19, t0.created_by AS created_by_20, t0.updated_by AS updated_by_21 FROM std_users t0 WHERE t0.id = ?
Parameters:
[
68
]
|
|
1.44 ms (0.13%) |
1 |
"START TRANSACTION"
Parameters:
[] |
|
1.44 ms (0.13%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.image AS image_3, t0.is_active AS is_active_4, t0.is_default AS is_default_5, t0.created_date AS created_date_6, t0.updated_date AS updated_date_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9 FROM std_web_roles t0 INNER JOIN std_page_web_role ON t0.id = std_page_web_role.webrole_id WHERE std_page_web_role.page_id = ?
Parameters:
[
581
]
|
|
1.43 ms (0.13%) |
2 |
SELECT t0.id AS id_1, t0.url AS url_2, t0.language_code AS language_code_3, t0.relation_tree AS relation_tree_4, t0.is_canonical AS is_canonical_5, t0.page_id AS page_id_6, t0.relation_id AS relation_id_7 FROM std_friendly_url t0 WHERE t0.relation_id = ? AND t0.language_code = ? LIMIT 1
Parameters:
[ 198 "pt" ] |
|
1.39 ms (0.13%) |
1 |
SELECT NON_UNIQUE AS Non_Unique, INDEX_NAME AS Key_name, COLUMN_NAME AS Column_Name, SUB_PART AS Sub_Part, INDEX_TYPE AS Index_Type FROM information_schema.STATISTICS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? ORDER BY SEQ_IN_INDEX
Parameters:
[ "studio5" "doctrine_migration_versions" ] |
|
1.04 ms (0.10%) |
1 |
SELECT t0.id AS id_1, t0.page_id AS page_id_2, t0.domain_value_id AS domain_value_id_3, t4.id AS id_5, t4.machine_name AS machine_name_6, t4.description AS description_7, t4.is_active AS is_active_8, t4.created_date AS created_date_9, t4.updated_date AS updated_date_10, t4.erp_code AS erp_code_11, t4.domain_type AS domain_type_12, t4.icon AS icon_13, t4.order_value AS order_value_14, t4.updated_by AS updated_by_15, t4.language_code AS language_code_16, t4.created_by AS created_by_17, t4.domain_id AS domain_id_18, t4.parent_domain_value_id AS parent_domain_value_id_19, t4.geo_map_id AS geo_map_id_20 FROM std_pages_tags t0 INNER JOIN std_domains_values t4 ON t0.domain_value_id = t4.id WHERE t0.page_id IN (?)
Parameters:
[
581
]
|
|
0.97 ms (0.09%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.is_active AS is_active_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.order_value AS order_value_6, t0.publish_date AS publish_date_7, t0.expire_date AS expire_date_8, t0.layout AS layout_9, t0.machine_name AS machine_name_10, t0.include_sitemap AS include_sitemap_11, t0.content_type AS content_type_12, t0.template_id AS template_id_13, t14.id AS id_15, t14.status AS status_16, t14.page_id AS page_id_17, t14.last_approver_id AS last_approver_id_18, t0.created_by AS created_by_19, t0.updated_by AS updated_by_20 FROM std_pages t0 LEFT JOIN std_pages_approval_status t14 ON t14.page_id = t0.id WHERE t0.id = ?
Parameters:
[
581
]
|
|
0.97 ms (0.09%) |
1 |
SELECT l.language_code,l.`name`,u.url,l.is_default,l.locale FROM std_languages l INNER JOIN std_pages_content pc ON l.language_code=pc.language_code AND pc.page_id=:pageId INNER JOIN std_friendly_url u ON pc.page_id = u.page_id AND pc.language_code=u.language_code WHERE l.is_public=1 AND l.is_active=1 AND u.relation_id IS NULL ORDER BY l.order_value
Parameters:
[ "pageId" => 581 ] |
|
0.91 ms (0.08%) |
1 |
SELECT * FROM doctrine_migration_versions
Parameters:
[] |
|
0.81 ms (0.07%) |
1 |
SELECT t0.id AS id_1, t0.url AS url_2, t0.language_code AS language_code_3, t0.relation_tree AS relation_tree_4, t0.is_canonical AS is_canonical_5, t0.page_id AS page_id_6, t0.relation_id AS relation_id_7 FROM std_friendly_url t0 WHERE t0.page_id = ? AND t0.is_canonical = ? AND t0.language_code = ? LIMIT 1
Parameters:
[ 581 1 "pt" ] |
|
0.77 ms (0.07%) |
1 |
SELECT s0_.id AS id_0, s0_.url AS url_1, s0_.language_code AS language_code_2, s0_.relation_tree AS relation_tree_3, s0_.is_canonical AS is_canonical_4, s0_.page_id AS page_id_5, s0_.relation_id AS relation_id_6 FROM std_friendly_url s0_ WHERE s0_.relation_tree NOT LIKE '[]' AND s0_.page_id = ? AND s0_.language_code = ? LIMIT 1
Parameters:
[ 581 "pt" ] |
|
0.71 ms (0.07%) |
1 |
SELECT s0_.id AS id_0, s0_.url_origin AS url_origin_1, s0_.url_destination AS url_destination_2, s0_.code AS code_3, s0_.priority AS priority_4, s0_.is_active AS is_active_5, s0_.created_date AS created_date_6, s0_.updated_date AS updated_date_7, s0_.created_by AS created_by_8, s0_.updated_by AS updated_by_9 FROM std_redirects s0_ WHERE (? REGEXP s0_.url_origin) = 1 AND s0_.is_active = 1 ORDER BY s0_.priority ASC LIMIT 1
Parameters:
[
"pt/corredores-do-leca"
]
|
|
0.63 ms (0.06%) |
1 |
SELECT t0.language_code AS language_code_1, t0.name AS name_2, t0.is_public AS is_public_3, t0.is_available_in_backoffice AS is_available_in_backoffice_4, t0.is_active AS is_active_5, t0.is_default AS is_default_6, t0.order_value AS order_value_7, t0.locale AS locale_8 FROM std_languages t0 WHERE t0.is_active = ? AND t0.is_public = ?
Parameters:
[ 1 1 ] |
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.