Query Metrics
81
Database Queries
32
Different statements
638.62 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 0.58 ms |
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 ] |
| 2 | 1.45 ms |
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:
[ 1769379933 "pfOnV5ZbFG:std_features" ] |
| 3 | 0.81 ms |
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"
""
]
|
| 4 | 0.89 ms |
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_USERNAME"
""
]
|
| 5 | 0.78 ms |
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_PASSWORD"
""
]
|
| 6 | 0.56 ms |
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_HOST"
""
]
|
| 7 | 0.55 ms |
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_ENCRYPTION"
""
]
|
| 8 | 0.61 ms |
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_AUTH"
""
]
|
| 9 | 0.62 ms |
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_PORT"
""
]
|
| 10 | 0.71 ms |
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:
[
"tracking_enable"
""
]
|
| 11 | 0.81 ms |
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:
[
"tracking_same_page_min_interval_seconds"
""
]
|
| 12 | 0.65 ms |
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:
[
"tracking_ask_precise_location"
""
]
|
| 13 | 0.65 ms |
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:
[
"tracking_precise_location_hours"
""
]
|
| 14 | 0.68 ms |
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:
[
"use_geo_map_for_tracking"
""
]
|
| 15 | 1.02 ms |
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:
[
"use_api_for_tracking"
""
]
|
| 16 | 0.69 ms |
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 ] |
| 17 | 0.56 ms |
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:
[ 1769379933 "wGziWeNk0O:std_redirects_478a02fc2308ed3b81dda3fa8d19e368" ] |
| 18 | 0.62 ms |
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/projeto-atos-a-missao-de-levar-a-cultura-a-todo-o-pais"
]
|
| 19 | 5.41 ms |
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 => 1769379933 0 => "wGziWeNk0O:std_redirects_478a02fc2308ed3b81dda3fa8d19e368" 1 => "N;" ] |
| 20 | 68.21 ms |
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/projeto-atos-a-missao-de-levar-a-cultura-a-todo-o-pais"
]
|
| 21 | 1.57 ms |
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:
[ 413 "pt" ] |
| 22 | 0.73 ms |
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:
[
413
]
|
| 23 | 0.83 ms |
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:
[
413
]
|
| 24 | 0.66 ms |
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
]
|
| 25 | 0.69 ms |
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:
[ "a03970077c094bf4989d656a3f037e23d34a3cff78ad6ee181049a761c49af6c" 413 "open_page" ] |
| 26 | 0.66 ms |
"START TRANSACTION"
Parameters:
[] |
| 27 | 0.63 ms |
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:33" "cb3e1f92ba3f7f84ef0763c8f9a9ba1c484df315bbcb07e3f4a2da9490b6c962" "a03970077c094bf4989d656a3f037e23d34a3cff78ad6ee181049a761c49af6c" "f81d000f287a6e42859881548ca3c245e89d06e1b92c944956163f1b3a6e3e27" "60bb41650dde66550ab348e5c2404cd9c70b9fff4d6164249fbc2a7672393162" null null null null "open_page" 413 null ] |
| 28 | 0.58 ms |
INSERT INTO std_tag_tracking (tag_id, tracking_id) VALUES (?, ?)
Parameters:
[ 656 61843 ] |
| 29 | 0.50 ms |
INSERT INTO std_tag_tracking (tag_id, tracking_id) VALUES (?, ?)
Parameters:
[ 657 61843 ] |
| 30 | 0.63 ms |
INSERT INTO std_tag_tracking (tag_id, tracking_id) VALUES (?, ?)
Parameters:
[ 1043 61843 ] |
| 31 | 0.52 ms |
INSERT INTO std_tag_tracking (tag_id, tracking_id) VALUES (?, ?)
Parameters:
[ 1044 61843 ] |
| 32 | 0.55 ms |
INSERT INTO std_tag_tracking (tag_id, tracking_id) VALUES (?, ?)
Parameters:
[ 1045 61843 ] |
| 33 | 0.46 ms |
INSERT INTO std_tag_tracking (tag_id, tracking_id) VALUES (?, ?)
Parameters:
[ 1046 61843 ] |
| 34 | 0.46 ms |
INSERT INTO std_tag_tracking (tag_id, tracking_id) VALUES (?, ?)
Parameters:
[ 1047 61843 ] |
| 35 | 0.65 ms |
INSERT INTO std_tag_tracking (tag_id, tracking_id) VALUES (?, ?)
Parameters:
[ 1048 61843 ] |
| 36 | 0.74 ms |
INSERT INTO std_tag_tracking (tag_id, tracking_id) VALUES (?, ?)
Parameters:
[ 1049 61843 ] |
| 37 | 6.43 ms |
"COMMIT"
Parameters:
[] |
| 38 | 67.77 ms |
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:
[
413
]
|
| 39 | 0.89 ms |
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" ] |
| 40 | 0.95 ms |
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" ] |
| 41 | 0.78 ms |
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:
[ 221 "pt" ] |
| 42 | 0.63 ms |
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/cultura-e-gastronomia"
]
|
| 43 | 0.72 ms |
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:
[ 134 "pt" ] |
| 44 | 0.90 ms |
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:
[ 413 "pt" ] |
| 45 | 0.69 ms |
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:
[ 413 1 "pt" ] |
| 46 | 0.94 ms |
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" => 413 ] |
| 47 | 0.59 ms |
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:
[ 413 "pt" ] |
| 48 | 1.16 ms |
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:
[
413
]
|
| 49 | 0.61 ms |
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
]
|
| 50 | 0.87 ms |
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:
[
"favicon"
""
]
|
| 51 | 0.56 ms |
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:
[ "extra_text_title" "pt" ] |
| 52 | 0.55 ms |
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:
[ "extra_text_left" "pt" ] |
| 53 | 1.61 ms |
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:
[ "default_meta_page_name" "pt" ] |
| 54 | 425.08 ms |
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"
]
|
| 55 | 1.37 ms |
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:
[
"notificationsbar_page"
""
]
|
| 56 | 1.82 ms |
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:
[ "scripts_header" "pt" ] |
| 57 | 0.61 ms |
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:
[
"logo_mobile"
""
]
|
| 58 | 0.71 ms |
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:
[
413
]
|
| 59 | 0.84 ms |
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:
[ "scripts_body" "pt" ] |
| 60 | 0.71 ms |
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:
[
"header_style"
""
]
|
| 61 | 0.82 ms |
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:
[
"logo_link"
""
]
|
| 62 | 1.02 ms |
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:
[ 1769379934 "pfOnV5ZbFG:std_features" ] |
| 63 | 0.75 ms |
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:
[ "menutop" "pt" ] |
| 64 | 0.63 ms |
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:
[ 1769379934 "menu1-menutoppt" ] |
| 65 | 0.79 ms |
SELECT DATABASE()
Parameters:
[] |
| 66 | 2.29 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"studio5"
]
|
| 67 | 0.37 ms |
SELECT DATABASE()
Parameters:
[] |
| 68 | 1.89 ms |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"studio5"
]
|
| 69 | 0.76 ms |
SELECT DATABASE()
Parameters:
[] |
| 70 | 1.55 ms |
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" ] |
| 71 | 0.49 ms |
SELECT DATABASE()
Parameters:
[] |
| 72 | 2.73 ms |
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" ] |
| 73 | 2.73 ms |
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" ] |
| 74 | 0.51 ms |
SELECT DATABASE()
Parameters:
[] |
| 75 | 1.11 ms |
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" ] |
| 76 | 1.21 ms |
SELECT * FROM doctrine_migration_versions
Parameters:
[] |
| 77 | 0.71 ms |
SELECT DATABASE()
Parameters:
[] |
| 78 | 0.85 ms |
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:
[
"watchtv_pages"
""
]
|
| 79 | 0.79 ms |
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:
[ 1769379934 "pfOnV5ZbFG:std_features" ] |
| 80 | 0.56 ms |
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:
[ "menutop2" "pt" ] |
| 81 | 0.55 ms |
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:
[ 1769379934 "menu31-menutop2pt" ] |
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.