Query Metrics
59
Database Queries
25
Different statements
519.10 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
405.30 ms (78.08%) |
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"
]
|
|
62.14 ms (11.97%) |
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:
[ 197 "pt" ] |
|
18.95 ms (3.65%) |
24 |
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"
""
]
|
|
6.81 ms (1.31%) |
1 |
"COMMIT"
Parameters:
[] |
|
6.21 ms (1.20%) |
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 => 1769379922 0 => "wGziWeNk0O:std_redirects_dccbcb27e0ec10d258c0df1bf3c7fbe0" 1 => "N;" ] |
|
2.76 ms (0.53%) |
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:
[ 157 "pt" ] |
|
2.75 ms (0.53%) |
4 |
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:
[ 1769379922 "pfOnV5ZbFG:std_features" ] |
|
2.12 ms (0.41%) |
4 |
INSERT INTO std_tag_tracking (tag_id, tracking_id) VALUES (?, ?)
Parameters:
[ 420 61832 ] |
|
1.08 ms (0.21%) |
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:
[
357
]
|
|
1.07 ms (0.21%) |
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.url = ? LIMIT 1
Parameters:
[
"/pt/no-relvado-dos-sonhos-irene-entra-em-campo-para-inspirar-os-mais-novos"
]
|
|
0.88 ms (0.17%) |
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 ] |
|
0.79 ms (0.15%) |
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:
[
357
]
|
|
0.77 ms (0.15%) |
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" => 357 ] |
|
0.77 ms (0.15%) |
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:
[
357
]
|
|
0.76 ms (0.15%) |
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:
[
357
]
|
|
0.75 ms (0.14%) |
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:
[ 357 "pt" ] |
|
0.71 ms (0.14%) |
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:
[
357
]
|
|
0.66 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:
[
11
]
|
|
0.65 ms (0.13%) |
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:
[ "df3ff607ef01405eb14b2c462d1be8bbd1bfdeb7adf8d019bf4bc442833171a8" 357 "open_page" ] |
|
0.64 ms (0.12%) |
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/no-relvado-dos-sonhos-irene-entra-em-campo-para-inspirar-os-mais-novos"
]
|
|
0.63 ms (0.12%) |
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-25 22:25:22" "a3d08349bacecda8546feddf7002fd5b03bcbaaf817ead9e69fe2f9da160255a" "df3ff607ef01405eb14b2c462d1be8bbd1bfdeb7adf8d019bf4bc442833171a8" "f81d000f287a6e42859881548ca3c245e89d06e1b92c944956163f1b3a6e3e27" "012b108ce764fd802641db53cd81043ff60297293dcf77859c44c206e5564306" null null null null "open_page" 357 null ] |
|
0.52 ms (0.10%) |
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 ] |
|
0.48 ms (0.09%) |
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:
[ 357 1 "pt" ] |
|
0.48 ms (0.09%) |
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:
[
101
]
|
|
0.42 ms (0.08%) |
1 |
"START TRANSACTION"
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.