Query Metrics
57
Database Queries
25
Different statements
489.86 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
432.62 ms (88.31%) |
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"
]
|
|
24.14 ms (4.93%) |
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"
""
]
|
|
5.89 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 => 1769379614 0 => "wGziWeNk0O:std_redirects_3cabfeaaa4a7dab7d34750883647fc0b" 1 => "N;" ] |
|
5.74 ms (1.17%) |
1 |
"COMMIT"
Parameters:
[] |
|
3.13 ms (0.64%) |
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" ] |
|
2.48 ms (0.51%) |
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:
[ 1769379614 "pfOnV5ZbFG:std_features" ] |
|
1.42 ms (0.29%) |
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.40 ms (0.29%) |
3 |
INSERT INTO std_tag_tracking (tag_id, tracking_id) VALUES (?, ?)
Parameters:
[ 2072 61725 ] |
|
1.34 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:
[ "5e45ce1092cdbad92531ae02e9061d529629cdd712847d0e621971047a9b1204" 776 "open_page" ] |
|
0.99 ms (0.20%) |
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:
[
776
]
|
|
0.96 ms (0.20%) |
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:
[
776
]
|
|
0.88 ms (0.18%) |
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:
[
776
]
|
|
0.88 ms (0.18%) |
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:
[
776
]
|
|
0.86 ms (0.18%) |
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:
[ 776 "pt" ] |
|
0.77 ms (0.16%) |
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" => 776 ] |
|
0.74 ms (0.15%) |
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.74 ms (0.15%) |
1 |
"START TRANSACTION"
Parameters:
[] |
|
0.72 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 WHERE t0.id = ?
Parameters:
[
36
]
|
|
0.71 ms (0.15%) |
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:20:14" "6d20aac07d0ee191aa4eda6f3d5a8254dcb7e0ccd5da750e5807ceb64da08d92" "5e45ce1092cdbad92531ae02e9061d529629cdd712847d0e621971047a9b1204" "6a78b3889de73317150325b27f5ad5c8b5e99354cc8c89249de6db2e79f47c0d" "ad6488125376b041e1cbdc89da8d14de0252cbe5d1e193f426885cb2033e6d9b" null null null null "open_page" 776 null ] |
|
0.69 ms (0.14%) |
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/habitacao-1"
]
|
|
0.64 ms (0.13%) |
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/habitacao-1"
]
|
|
0.61 ms (0.13%) |
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:
[
776
]
|
|
0.55 ms (0.11%) |
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.50 ms (0.10%) |
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
]
|
|
0.47 ms (0.10%) |
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:
[ 776 1 "pt" ] |
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.