Query Metrics
199
Database Queries
50
Different statements
1098.29 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
421.90 ms (38.41%) |
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"
]
|
|
159.68 ms (14.54%) |
62 |
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"
""
]
|
|
142.86 ms (13.01%) |
1 |
SELECT s0_.id AS id_0, s0_.machine_name AS machine_name_1, s0_.description AS description_2, s0_.is_active AS is_active_3, s0_.created_date AS created_date_4, s0_.updated_date AS updated_date_5, s0_.erp_code AS erp_code_6, s0_.domain_type AS domain_type_7, s0_.icon AS icon_8, s0_.order_value AS order_value_9, s0_.updated_by AS updated_by_10, s0_.language_code AS language_code_11, s0_.created_by AS created_by_12, s0_.domain_id AS domain_id_13, s0_.parent_domain_value_id AS parent_domain_value_id_14, s0_.geo_map_id AS geo_map_id_15 FROM std_domains_values s0_ LEFT JOIN std_geo_map s1_ ON s0_.geo_map_id = s1_.id WHERE s0_.is_active = 1 AND s1_.type IN (?, ?) ORDER BY s0_.description ASC
Parameters:
[ "municipality" "district" ] |
|
79.11 ms (7.20%) |
2 |
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:
[
294
]
|
|
72.90 ms (6.64%) |
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" ] |
|
55.63 ms (5.07%) |
22 |
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:
[ 1769388261 "pfOnV5ZbFG:std_features" ] |
|
52.87 ms (4.81%) |
6 |
SELECT DATABASE()
Parameters:
[] |
|
9.17 ms (0.83%) |
1 |
"COMMIT"
Parameters:
[] |
|
8.52 ms (0.78%) |
10 |
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" ] |
|
7.94 ms (0.72%) |
12 |
SELECT t0.id AS id_1, t0.description AS description_2, t0.attributes AS attributes_3, t0.domain_value_id AS domain_value_id_4, t0.language_code AS language_code_5 FROM std_domains_values_content t0 WHERE (t0.language_code = ? AND t0.domain_value_id = ?) LIMIT 1
Parameters:
[ "pt" 813 ] |
|
7.32 ms (0.67%) |
1 |
SELECT MIN(s0_.relation_id) AS sclr_0, s0_.page_id AS sclr_1, MIN(s0_.id) AS sclr_2, MIN(s0_.order_value) AS sclr_3, s1_.name AS name_4, s2_.machine_name AS machine_name_5 FROM std_pages_pages s0_ INNER JOIN std_pages s1_ ON s0_.page_id = s1_.id INNER JOIN std_content_types s2_ ON s1_.content_type = s2_.id INNER JOIN std_pages_content s3_ WHERE s1_.is_active = 1 AND ((s1_.publish_date IS NULL OR s1_.publish_date <= ?)) AND ((s1_.expire_date IS NULL OR s1_.expire_date > ?)) AND s3_.page_id = s1_.id AND s3_.language_code = ? AND (s0_.relation_id = ? OR s0_.relation_id IN (SELECT DISTINCT s4_.id FROM std_pages_pages s4_ WHERE s4_.relation_id = ?)) AND s1_.id <> ? AND s1_.content_type IN ('101', '294') GROUP BY s1_.id, s1_.name, s2_.machine_name ORDER BY s1_.order_value ASC, s1_.publish_date DESC LIMIT 3
Parameters:
[ "2026-01-26 00:44:23" "2026-01-26 00:44:23" "pt" 215 215 363 ] |
|
6.56 ms (0.60%) |
2 |
SELECT TABLE_NAME FROM information_schema.TABLES WHERE TABLE_SCHEMA = ? AND TABLE_TYPE = 'BASE TABLE' ORDER BY TABLE_NAME
Parameters:
[
"studio5"
]
|
|
6.40 ms (0.58%) |
8 |
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:
[
363
]
|
|
5.78 ms (0.53%) |
8 |
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:
[
363
]
|
|
5.67 ms (0.52%) |
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 => 1769388261 0 => "wGziWeNk0O:std_redirects_326f9d51215f44596e6c4d3b67a5888c" 1 => "N;" ] |
|
5.23 ms (0.48%) |
5 |
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:
[
363
]
|
|
4.13 ms (0.38%) |
6 |
INSERT INTO std_tag_tracking (tag_id, tracking_id) VALUES (?, ?)
Parameters:
[ 442 62021 ] |
|
3.21 ms (0.29%) |
4 |
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:
[ 363 "pt" ] |
|
2.98 ms (0.27%) |
2 |
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.title = ? AND t0.language_code = ? LIMIT 1
Parameters:
[ "Temas" "pt" ] |
|
2.78 ms (0.25%) |
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" ] |
|
2.77 ms (0.25%) |
4 |
SELECT t0.id AS id_1, t0.machine_name AS machine_name_2, t0.name AS name_3, t0.description AS description_4, t0.width AS width_5, t0.height AS height_6, t0.position AS position_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10 FROM std_ads_zones t0 WHERE t0.machine_name = ? LIMIT 1
Parameters:
[
"halfpage"
]
|
|
2.61 ms (0.24%) |
1 |
"START TRANSACTION"
Parameters:
[] |
|
2.59 ms (0.24%) |
5 |
SELECT t0.id AS id_1, t0.relation_id AS relation_id_2, t0.order_value AS order_value_3, t0.page_id AS page_id_4, t0.content_type AS content_type_5 FROM std_pages_pages t0 WHERE t0.id = ?
Parameters:
[
215
]
|
|
2.56 ms (0.23%) |
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:
[ "92e2ba94c12570a751135d5d6bfee750cee823107fc76e9edbcb801fe3a9f020" 363 "open_page" ] |
|
2.48 ms (0.23%) |
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.26 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/trocou-a-engenharia-pela-agricultura-e-hoje-fornece-quase-30-restaurantes"
]
|
|
2.01 ms (0.18%) |
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.93 ms (0.18%) |
2 |
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.machine_name = ? LIMIT 1
Parameters:
[
"temas"
]
|
|
1.50 ms (0.14%) |
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.44 ms (0.13%) |
2 |
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
]
|
|
1.36 ms (0.12%) |
2 |
SELECT t0.id AS id_1, t0.relation_id AS relation_id_2, t0.order_value AS order_value_3, t0.page_id AS page_id_4, t0.content_type AS content_type_5 FROM std_pages_pages t0 WHERE t0.page_id = ?
Parameters:
[
363
]
|
|
1.29 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/trocou-a-engenharia-pela-agricultura-e-hoje-fornece-quase-30-restaurantes"
]
|
|
1.29 ms (0.12%) |
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" => 363 ] |
|
1.14 ms (0.10%) |
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:44:21" "769e5599702ff16d1b3907f2484600db9bf7074bca543c9304e10244be59cd03" "92e2ba94c12570a751135d5d6bfee750cee823107fc76e9edbcb801fe3a9f020" "f81d000f287a6e42859881548ca3c245e89d06e1b92c944956163f1b3a6e3e27" "d96861e4c63d1f711db8f0ada59b82a20b88fc5eec5ca7bca8dac25300ffa15e" null null null null "open_page" 363 null ] |
|
1.09 ms (0.10%) |
1 |
SELECT * FROM doctrine_migration_versions
Parameters:
[] |
|
1.02 ms (0.09%) |
2 |
SELECT t0.id AS id_1, t0.relation_id AS relation_id_2, t0.order_value AS order_value_3, t0.page_id AS page_id_4, t0.content_type AS content_type_5 FROM std_pages_pages t0 WHERE t0.page_id = ? AND t0.relation_id = ? LIMIT 1
Parameters:
[ 157 0 ] |
|
0.76 ms (0.07%) |
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.machine_name = ? LIMIT 1
Parameters:
[
"programs"
]
|
|
0.71 ms (0.06%) |
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:
[
363
]
|
|
0.68 ms (0.06%) |
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.language_code = ? AND t0.is_canonical = ? LIMIT 1
Parameters:
[ 363 "pt" 1 ] |
|
0.68 ms (0.06%) |
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:
[
363
]
|
|
0.67 ms (0.06%) |
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.machine_name AS machine_name_6, t0.description AS description_7, t0.is_hidden AS is_hidden_8, t0.created_by AS created_by_9, t0.updated_by AS updated_by_10 FROM std_snippets t0 WHERE t0.id = ?
Parameters:
[
"2"
]
|
|
0.66 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.language_code = ? AND t0.is_active = ? AND t0.is_public = ? LIMIT 1
Parameters:
[ "pt" 1 1 ] |
|
0.62 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 ] |
|
0.60 ms (0.05%) |
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:
[ 363 1 "pt" ] |
|
0.53 ms (0.05%) |
1 |
SELECT t0.id AS id_1, t0.machine_name AS machine_name_2, t0.description AS description_3, t0.webservice_value AS webservice_value_4, t0.webservice_description AS webservice_description_5, t0.is_active AS is_active_6, t0.created_date AS created_date_7, t0.updated_date AS updated_date_8, t0.erp_code AS erp_code_9, t0.updated_by AS updated_by_10, t0.language_code AS language_code_11, t0.created_by AS created_by_12, t0.webservice_id AS webservice_id_13, t0.parent_domain_id AS parent_domain_id_14 FROM std_domains t0 WHERE t0.id = ?
Parameters:
[
5
]
|
|
0.53 ms (0.05%) |
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 = ? LIMIT 1
Parameters:
[
"pt"
]
|
|
0.50 ms (0.05%) |
1 |
SELECT t0.is_active AS is_active_1, t0.created_date AS created_date_2, t0.updated_date AS updated_date_3, t0.content AS content_4, t0.snippet_id AS snippet_id_5, t0.language_code AS language_code_6, t0.created_by AS created_by_7, t0.updated_by AS updated_by_8 FROM std_snippets_content t0 WHERE (t0.language_code = ? AND t0.snippet_id = ?) LIMIT 1
Parameters:
[ "pt" 2 ] |
|
0.47 ms (0.04%) |
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 = ? LIMIT 1
Parameters:
[
363
]
|
|
0.44 ms (0.04%) |
1 |
SELECT t0.id AS id_1, t0.machine_name AS machine_name_2, t0.is_active AS is_active_3, t0.created_date AS created_date_4, t0.updated_date AS updated_date_5, t0.name AS name_6, t0.settings AS settings_7, t0.created_by AS created_by_8, t0.updated_by AS updated_by_9 FROM std_blocks t0 WHERE t0.machine_name = ? LIMIT 1
Parameters:
[
"block_list"
]
|
|
0.44 ms (0.04%) |
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 = ? LIMIT 1
Parameters:
[
"101"
]
|
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.