Symfony Profiler

Query Metrics

97 Database Queries

25 Different statements

55.10 ms Query time

0 Invalid entities

Queries


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 (?)
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 (?, ?)
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
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 (?)
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 (?, ?, ?)
SELECT * FROM tmp_store WHERE id = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
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 (?)
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 (?, ?, ?)
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 (?)
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 (?)
SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC
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 (?)
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 (?, ?)
SELECT * FROM object_url_slugs WHERE slug = '/vi/gioi-thieu' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
SELECT * FROM website_settings WHERE id = ?
SELECT * FROM documents_editables WHERE documentId = ?
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 (?)
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 (?)
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 (?)
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 (?, ?, ?, ?, ?)
SELECT id FROM website_settings
SELECT * FROM website_settings WHERE id = ?
SELECT * FROM website_settings WHERE id = ?
SELECT * FROM website_settings WHERE id = ?
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 (?)
SELECT * FROM builder_seo WHERE element = ? AND elementType = ?
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 (?)
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 (?, ?)
UPDATE builder_seo SET id = ?, elementType = ?, element = ?, title = ?, description = ?, keyword = ?, language = ?, indexing = ?, nofollow = ?, canonicalUrl = ?, redirectLink = ?, redirectType = ?, destinationUrl = ?, schemaBlock = ?, image = ?, imageAsset = ?, redirectId = ?, metaData = ?, generateSitemap = ? WHERE id = ?
SELECT * FROM builder_options WHERE name = ?
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 (?)
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 (?, ?)
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 (?)
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
SELECT * FROM documents_editables WHERE documentId = ?
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 (?)
SELECT *
            FROM website_settings
            WHERE name = ?
                AND (
                    siteId IS NULL
                    OR siteId = 0
                    OR siteId = ?
                )
                AND (
                    language IS NULL
                    OR language = ''
                    OR language = ?
                )
            ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
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 (?)
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 (?, ?, ?, ?, ?)
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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 (?)
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 (?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (parentId = ?) AND published = 1 ORDER BY `index` ASC
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 (?)
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 (?, ?, ?)
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 (?)
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 (?)
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 (?, ?)
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 (?)
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 (?, ?)
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 (?)
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 (?, ?)
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 (?)
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 (?, ?)
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 (?)
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 (?, ?)
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 (?)
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 (?)
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
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 (?)
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
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 (?)
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
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 (?)
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
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 (?)
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
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 (?)
SELECT id FROM documents d WHERE parentId = ?  AND published = 1 LIMIT 1
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 (?)
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 (?, ?, ?, ?, ?, ?, ?, ?, ?)
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 (?, ?, ?, ?, ?, ?, ?, ?, ?)
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)
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)
SELECT * FROM translations_messages LIMIT 1;
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 (?)
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 (?, ?, ?)
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
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 (?)
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
SELECT * FROM documents_editables WHERE documentId = ?
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 (?)
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 (?)
SELECT customSettings FROM assets WHERE id = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?

#▲	Time	Info
1	0.68 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: [`1764991935 "site_domain_1130d4aff1f252faaab8897dc51407a6"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_1130d4aff1f252faaab8897dc51407a6');
2	0.35 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: [`1764991935 "system\x01tags\x01" "site\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
3	0.40 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
4	0.53 ms	SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/vi/gioi-thieu" "path" "auto_create" "/vi/gioi-thieu" "path_query" "https://namdan.goterest.com/vi/gioi-thieu" "entire_uri"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = ? AND ( `type` = ? OR `type` = ? ) ) OR ( source = ? AND `type` = ? ) OR ( source = ? AND `type` = ? ) ) AND active = 1 AND ( regex IS NULL OR regex = 0 ) AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/vi/gioi-thieu' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/vi/gioi-thieu' AND `type` = 'path_query') OR (source = 'https://namdan.goterest.com/vi/gioi-thieu' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;
5	0.24 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: [`1764991935 "system_route_redirect"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_route_redirect');
6	0.23 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: [`1764991935 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'redirecttags', 'routetags');
7	2.76 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"maintenance_mode"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'maintenance_mode';
8	0.39 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/vi/" "gioi-thieu"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/vi/' AND `key` = BINARY 'gioi-thieu';
9	0.32 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/vi/gioi-thieu"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/vi/gioi-thieu';
10	0.25 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: [`1764991935 "document_39"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_39');
11	0.46 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: [`1764991935 "document_39\x01tags\x01" "asset_84\x01tags\x01" "asset_86\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_39tags', 'asset_84tags', 'asset_86tags');
12	3.61 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: [`1764991935 "sites_path_mapping"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('sites_path_mapping');
13	0.32 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: [`1764991935 "\x00tags\x00sites_path_mapping"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0sites_path_mapping');
14	0.45 ms	SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites ORDER BY ( SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId ) DESC SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC ;
15	0.25 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: [`1764991935 "document_properties_39"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_39');
16	0.27 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: [`1764991935 "document_properties\x01tags\x01" "document_39\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_propertiestags', 'document_39tags');
17	0.26 ms	SELECT * FROM object_url_slugs WHERE slug = '/vi/gioi-thieu' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE slug = '/vi/gioi-thieu' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/vi/gioi-thieu' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
18	0.59 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"siteTemplate" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'siteTemplate' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
19	0.23 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 5;
20	0.23 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`39`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 39;
21	2.78 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: [`1764991935 "asset_84"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_84');
22	0.36 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: [`1764991935 "asset_86"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_86');
23	0.30 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: [`1764991935 "website_config"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('website_config');
24	0.27 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: [`1764991935 "website_config\x01tags\x01" "system\x01tags\x01" "config\x01tags\x01" "output\x01tags\x01" "asset_96\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('website_configtags', 'systemtags', 'configtags', 'outputtags', 'asset_96tags');
25	0.33 ms	SELECT id FROM website_settings Parameters: [] View formatted query View runnable query Explain query SELECT id FROM website_settings SELECT id FROM website_settings;
26	0.26 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`7`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 7;
27	0.17 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 9;
28	0.16 ms	SELECT * FROM website_settings WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE id = ? SELECT * FROM website_settings WHERE id = 2;
29	0.23 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: [`1764991935 "asset_96"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_96');
30	0.47 ms	SELECT * FROM builder_seo WHERE element = ? AND elementType = ? Parameters: [`39 "document"`] View formatted query View runnable query Explain query SELECT * FROM builder_seo WHERE element = ? AND elementType = ? SELECT * FROM builder_seo WHERE element = 39 AND elementType = 'document';
31	0.25 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: [`1764991935 "system_resource_columns_builder_seo"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_resource_columns_builder_seo');
32	0.23 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: [`1764991935 "system\x01tags\x01" "resource\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'resourcetags');
33	0.28 ms	UPDATE builder_seo SET id = ?, elementType = ?, element = ?, title = ?, description = ?, keyword = ?, language = ?, indexing = ?, nofollow = ?, canonicalUrl = ?, redirectLink = ?, redirectType = ?, destinationUrl = ?, schemaBlock = ?, image = ?, imageAsset = ?, redirectId = ?, metaData = ?, generateSitemap = ? WHERE id = ? Parameters: [`7 "document" 39 null null null "vi" 1 0 null 0 null null null null null null null 1 7`] View formatted query View runnable query Explain query UPDATE builder_seo SET id = ?, elementType = ?, element = ?, title = ?, description = ?, keyword = ?, language = ?, indexing = ?, nofollow = ?, canonicalUrl = ?, redirectLink = ?, redirectType = ?, destinationUrl = ?, schemaBlock = ?, image = ?, imageAsset = ?, redirectId = ?, metaData = ?, generateSitemap = ? WHERE id = ? UPDATE builder_seo SET id = 7, elementType = 'document', element = 39, title = NULL, description = NULL, keyword = NULL, language = 'vi', indexing = 1, nofollow = 0, canonicalUrl = NULL, redirectLink = 0, redirectType = NULL, destinationUrl = NULL, schemaBlock = NULL, image = NULL, imageAsset = NULL, redirectId = NULL, metaData = NULL, generateSitemap = 1 WHERE id = 7;
34	0.19 ms	SELECT * FROM builder_options WHERE name = ? Parameters: [`"main_domain"`] View formatted query View runnable query Explain query SELECT * FROM builder_options WHERE name = ? SELECT * FROM builder_options WHERE name = 'main_domain';
35	1.42 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: [`1764991935 "document_29"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_29');
36	0.25 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: [`1764991935 "document_29\x01tags\x01" "asset_113\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_29tags', 'asset_113tags');
37	0.24 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: [`1764991935 "document_properties_29"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_29');
38	0.21 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
39	0.41 ms	SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/_fragment" "path" "auto_create" "/_fragment?_path=_locale=vi&_format=html&_controller=App%5CController%5CContentController%3A%3AheaderAction" "path_query" "https://namdan.goterest.com/_fragment?_path=_locale=vi&_format=html&_controller=App%5CController%5CContentController%3A%3AheaderAction" "entire_uri"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = ? AND ( `type` = ? OR `type` = ? ) ) OR ( source = ? AND `type` = ? ) OR ( source = ? AND `type` = ? ) ) AND active = 1 AND ( regex IS NULL OR regex = 0 ) AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/_fragment' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/_fragment?_path=_locale=vi&_format=html&_controller=App%5CController%5CContentController%3A%3AheaderAction' AND `type` = 'path_query') OR (source = 'https://namdan.goterest.com/_fragment?_path=_locale=vi&_format=html&_controller=App%5CController%5CContentController%3A%3AheaderAction' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;
40	0.36 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`29`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 29;
41	0.26 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: [`1764991935 "asset_113"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_113');
42	0.46 ms	SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC Parameters: [`"siteSrc" null null`] View formatted query View runnable query Explain query SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC SELECT * FROM website_settings WHERE name = 'siteSrc' AND ( siteId IS NULL OR siteId = 0 OR siteId = NULL ) AND ( language IS NULL OR language = '' OR language = NULL ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC;
43	0.23 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: [`1764991935 "document_26"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_26');
44	0.30 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: [`1764991935 "document_26\x01tags\x01" "document_1\x01tags\x01" "asset_92\x01tags\x01" "asset_267\x01tags\x01" "asset_268\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_26tags', 'document_1tags', 'asset_92tags', 'asset_267tags', 'asset_268tags');
45	0.26 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`113`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 113;
46	0.25 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`113`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 113;
47	0.25 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: [`1764991935 "nav_74f453ad06eabb5287a2c5eeb7712735"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('nav_74f453ad06eabb5287a2c5eeb7712735');
48	0.32 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: [`1764991935 "output\x01tags\x01" "navigation\x01tags\x01" "document_51\x01tags\x01" "document_39\x01tags\x01" "document_48\x01tags\x01" "document_45\x01tags\x01" "document_73\x01tags\x01" "document_46\x01tags\x01" "document_53\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('outputtags', 'navigationtags', 'document_51tags', 'document_39tags', 'document_48tags', 'document_45tags', 'document_73tags', 'document_46tags', 'document_53tags');
49	13.47 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`26`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 26 AND published = 1 LIMIT 1;
50	1.24 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`26`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC SELECT documents.id, documents.type FROM documents WHERE (parentId = 26) AND published = 1 ORDER BY `index` ASC ;
51	0.33 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: [`1764991935 "document_27"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_27');
52	0.33 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: [`1764991935 "document_27\x01tags\x01" "asset_81\x01tags\x01" "asset_116\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_27tags', 'asset_81tags', 'asset_116tags');
53	0.21 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: [`1764991935 "document_51"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_51');
54	0.19 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: [`1764991935 "document_48"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_48');
55	0.42 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: [`1764991935 "document_48\x01tags\x01" "asset_73\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_48tags', 'asset_73tags');
56	0.18 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: [`1764991935 "document_45"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_45');
57	0.21 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: [`1764991935 "document_45\x01tags\x01" "asset_127\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_45tags', 'asset_127tags');
58	0.20 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: [`1764991935 "document_73"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_73');
59	0.21 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: [`1764991935 "document_73\x01tags\x01" "asset_103\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_73tags', 'asset_103tags');
60	0.18 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: [`1764991935 "document_46"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_46');
61	0.20 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: [`1764991935 "document_46\x01tags\x01" "asset_82\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_46tags', 'asset_82tags');
62	0.17 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: [`1764991935 "document_53"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_53');
63	0.22 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: [`1764991935 "document_53\x01tags\x01" "asset_78\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_53tags', 'asset_78tags');
64	0.19 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: [`1764991935 "document_1"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1');
65	0.20 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: [`1764991935 "document_properties_51"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_51');
66	0.22 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`51`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 51 AND published = 1 LIMIT 1;
67	0.21 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`39`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 39 AND published = 1 LIMIT 1;
68	0.20 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: [`1764991935 "document_properties_48"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_48');
69	0.20 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`48`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 48 AND published = 1 LIMIT 1;
70	0.19 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: [`1764991935 "document_properties_45"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_45');
71	0.19 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`45`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 45 AND published = 1 LIMIT 1;
72	0.21 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: [`1764991935 "document_properties_73"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_73');
73	0.20 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`73`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 73 AND published = 1 LIMIT 1;
74	0.19 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: [`1764991935 "document_properties_46"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_46');
75	0.19 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`46`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 46 AND published = 1 LIMIT 1;
76	0.86 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: [`1764991935 "document_properties_53"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_53');
77	0.19 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`53`] View formatted query View runnable query Explain query SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 SELECT id FROM documents d WHERE parentId = 53 AND published = 1 LIMIT 1;
78	0.37 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: [`1764991935 "nav_74f453ad06eabb5287a2c5eeb7712735"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('nav_74f453ad06eabb5287a2c5eeb7712735');
79	0.33 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: [`1764991935 "output\x01tags\x01" "navigation\x01tags\x01" "document_51\x01tags\x01" "document_39\x01tags\x01" "document_48\x01tags\x01" "document_45\x01tags\x01" "document_73\x01tags\x01" "document_46\x01tags\x01" "document_53\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('outputtags', 'navigationtags', 'document_51tags', 'document_39tags', 'document_48tags', 'document_45tags', 'document_73tags', 'document_46tags', 'document_53tags');
80	0.25 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: [`1764991935 "output\x01tags\x01" "navigation\x01tags\x01" "document_51\x01tags\x01" "document_39\x01tags\x01" "document_48\x01tags\x01" "document_45\x01tags\x01" "document_73\x01tags\x01" "document_46\x01tags\x01" "document_53\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?, ?, ?, ?, ?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('outputtags', 'navigationtags', 'document_51tags', 'document_39tags', 'document_48tags', 'document_45tags', 'document_73tags', 'document_46tags', 'document_53tags');
81	0.27 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 => null 3 => 1764991935 0 => "output\x01tags\x01" 1 => b"s:6:"fÄ\t9˜‰";"`] View formatted query View runnable query Explain query 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) INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES ('outputtags', 0x733A363A2266C409399889223B, NULL, 1764991935) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
82	1.73 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 => 31536000 3 => 1764991935 0 => "nav_74f453ad06eabb5287a2c5eeb7712735" 1 => b"O:1:"®":10:{s:6:" \x7F└\x1E";O:28:"Pimcore\Navigation\Container":3:{s:9:"\x00\x00_pages";a:7:{i:3007;O:32:"Pimcore\Navigation\Page\Document":25:{s:9:"\x00\x00_pages";a:0:{}s:9:"\x00\x00_index";a:0:{}s:14:"\x00\x00_dirtyIndex";b:0;s:9:"\x00\x00_label";s:11:"Trang chß╗º";s:12:"\x00\x00_fragment";N;s:6:"\x00\x00_id";s:2:"51";s:9:"\x00\x00_class";s:5:" main";s:9:"\x00\x00_title";s:0:"";s:10:"\x00\x00_target";N;s:13:"\x00\x00_accesskey";s:0:"";s:7:"\x00\x00_rel";a:0:{}s:7:"\x00\x00_rev";a:0:{}s:9:"\x00\x00_order";N;s:10:"\x00\x00_active";b:0;s:11:"\x00\x00_visible";b:1;s:10:"\x00\x00_parent";r:2;s:14:"\x00\x00_properties";a:0:{}s:21:"\x00\x00_customHtmlAttribs";a:0:{}s:7:"\x00\x00_uri";s:1:"/";s:12:"\x00\x00_tabindex";s:0:"";s:12:"\x00\x00_relation";s:0:"";s:14:"\x00\x00_documentId";i:51;s:15:"\x00\x00documentType";s:4:"link";s:15:"\x00\x00realFullPath";s:15:"/vi/Trang chß╗º";s:17:"\x00\x00customSettings";a:0:{}}i:3026;O:32:"Pimcore\Navigation\Page\Document":25:{s:9:"\x00\x00_pages";a:0:{}s:9:"\x00\x00_index";a:0:{}s:14:"\x00\x00_dirtyIndex";b:0;s:9:"\x00\x00_label";s:14:"Giß╗øi thiß╗çu";s:12:"\x00\x00_fragment";N;s:6:"\x00\x00_id";s:2:"39";s:9:"\x00\x00_class";s:5:" main";s:9:"\x00\x00_title";s:14:"Giß╗øi thiß╗çu";s:10:"\x00\x00_target";N;s:13:"\x00\x00_accesskey";s:0:"";s:7:"\x00\x00_rel";a:0:{}s:7:"\x00\x00_rev";a:0:{}s:9:"\x00\x00_order";N;s:10:"\x00\x00_active";b:0;s:11:"\x00\x00_visible";b:1;s:10:"\x00\x00_parent";r:2;s:14:"\x00\x00_properties";a:0:{}s:21:"\x00\x00_customHtmlAttribs";a:0:{}s:7:"\x00\x00_uri";s:14:"/vi/gioi-thieu";s:12:"\x00\x00_tabindex";s:0:"";s:12:"\x00\x00_relation";s:0:"";s:14:"\x00\x00_documentId";i:39;s:15:"\x00\x00documentType";s:4:"page";s:15:"\x00\x00realFullPath";s:18:"/vi/Giß╗øi thiß╗çu";s:17:"\x00\x00customSettings";a:0:{}}i:3044;O:32:"Pimcore\Navigation\Page\Document":25:{s:9:"\x00\x00_pages";a:0:{}s:9:"\x00\x00_index";a:0:{}s:14:"\x00\x00_dirtyIndex";b:0;s:9:"\x00\x00_label";s:11:"Bß║ún ─æß╗ô";s:12:"\x00\x00_fragment";N;s:6:"\x00\x00_id";s:2:"48";s:9:"\x00\x00_class";s:5:" main";s:9:"\x00\x00_title";s:0:"";s:10:"\x00\x00_target";N;s:13:"\x00\x00_accesskey";s:0:"";s:7:"\x00\x00_rel";a:0:{}s:7:"\x00\x00_rev";a:0:{}s:9:"\x00\x00_order";N;s:10:"\x00\x00_active";b:0;s:11:"\x00\x00_visible";b:1;s:10:"\x00\x00_parent";r:2;s:14:"\x00\x00_properties";a:0:{}s:21:"\x00\x00_customHtmlAttribs";a:0:{}s:7:"\x00\x00_uri";s:13:"/vi/ban-do-so";s:12:"\x00\x00_tabindex";s:0:"";s:12:"\x00\x00_relation";s:0:"";s:14:"\x00\x00_documentId";i:48;s:15:"\x00\x00documentType";s:4:"page";s:15:"\x00\x00realFullPath";s:20:"/vi/Bß║ún ─æß╗ô sß╗æ";s:17:"\x00\x00customSettings";a:0:{}}i:3047;O:32:"Pimcore\Navigation\Page\Document":25:{s:9:"\x00\x00_pages";a:0:{}s:9:"\x00\x00_index";a:0:{}s:14:"\x00\x00_dirtyIndex";b:0;s:9:"\x00\x00_label";s:11:"Sß╗▒ kiß╗çn";s:12:"\x00\x00_fragment";N;s:6:"\x00\x00_id";s:2:"45";s:9:"\x00\x00_class";s:5:" main";s:9:"\x00\x00_title";s:11:"Sß╗▒ kiß╗çn";s:10:"\x00\x00_target";N;s:13:"\x00\x00_accesskey";s:0:"";s:7:"\x00\x00_rel";a:0:{}s:7:"\x00\x00_rev";a:0:{}s:9:"\x00\x00_order";N;s:10:"\x00\x00_active";b:0;s:11:"\x00\x00_visible";b:1;s:10:"\x00\x00_parent";r:2;s:14:"\x00\x00_properties";a:0:{}s:21:"\x00\x00_customHtmlAttribs";a:0:{}s:7:"\x00\x00_uri";s:10:"/vi/le-hoi";s:12:"\x00\x00_tabindex";s:0:"";s:12:"\x00\x00_relation";s:0:"";s:14:"\x00\x00_documentId";i:45;s:15:"\x00\x00documentType";s:4:"page";s:15:"\x00\x00realFullPath";s:15:"/vi/Sß╗▒ kiß╗çn";s:17:"\x00\x00customSettings";a:0:{}}i:3070;O:32:"Pimcore\Navigation\Page\Document":25:{s:9:"\x00\x00_pages";a:0:{}s:9:"\x00\x00_index";a:0:{}s:14:"\x00\x00_dirtyIndex";b:0;s:9:"\x00\x00_label";s:12:"─Éß║Àc sß║ún";s:12:"\x00\x00_fragment";N;s:6:"\x00\x00_id";s:2:"73";s:9:"\x00\x00_class";s:5:" main";s:9:"\x00\x00_title";s:0:"";s:10:"\x00\x00_target";N;s:13:"\x00\x00_accesskey";s:0:"";s:7:"\x00\x00_rel";a:0:{}s:7:"\x00\x00_rev";a:0:{}s:9:"\x00\x00_order";N;s:10:"\x00\x00_active";b:0;s:11:"\x00\x00_visible";b:1;s:10:"\x00\x00_parent";r:2;s:14:"\x00\x00_properties";a:0:{}s:21:"\x00\x00_customHtmlAttribs";a:0:{}s:7:"\x00\x00_uri";s:11:"/vi/dac-san";s:12:"\x00\x00_tabindex";s:0:"";s:12:"\x00\x00_relation";s:0:"";s:14:"\x00\x00_documentId";i:73;s:15:"\x00\x00documentType";s:4:"page";s:15:"\x00\x00realFullPath";s:16:"/vi/─Éß║Àc sß║ún";s:17:"\x00\x00customSettings";a:0:{}}i:3093;O:32:"Pimcore\Navigation\Page\Document":25:{s:9:"\x00\x00_pages";a:0:{}s:9:"\x00\x00_index";a:0:{}s:14:"\x00\x00_dirtyIndex";b:0;s:9:"\x00\x00_label";s:10:"Li├¬n hß╗ç";s:12:"\x00\x00_fragment";N;s:6:"\x00\x00_id";s:2:"46";s:9:"\x00\x00_class";s:5:" main";s:9:"\x00\x00_title";N;s:10:"\x00\x00_target";N;s:13:"\x00\x00_accesskey";N;s:7:"\x00\x00_rel";a:0:{}s:7:"\x00\x00_rev";a:0:{}s:9:"\x00\x00_order";N;s:10:"\x00\x00_active";b:0;s:11:"\x00\x00_visible";b:1;s:10:"\x00\x00_parent";r:2;s:14:"\x00\x00_properties";a:0:{}s:21:"\x00\x00_customHtmlAttribs";a:0:{}s:7:"\x00\x00_uri";s:11:"/vi/lien-he";s:12:"\x00\x00_tabindex";N;s:12:"\x00\x00_relation";N;s:14:"\x00\x00_documentId";i:46;s:15:"\x00\x00documentType";s:4:"page";s:15:"\x00\x00realFullPath";s:14:"/vi/Li├¬n hß╗ç";s:17:"\x00\x00customSettings";a:0:{}}i:3116;O:32:"Pimcore\Navigation\Page\Document":25:{s:9:"\x00\x00_pages";a:0:{}s:9:"\x00\x00_index";a:0:{}s:14:"\x00\x00_dirtyIndex";b:0;s:9:"\x00\x00_label";s:0:"";s:12:"\x00\x00_fragment";N;s:6:"\x00\x00_id";s:2:"53";s:9:"\x00\x00_class";s:5:" main";s:9:"\x00\x00_title";s:0:"";s:10:"\x00\x00_target";N;s:13:"\x00\x00_accesskey";s:0:"";s:7:"\x00\x00_rel";a:0:{}s:7:"\x00\x00_rev";a:0:{}s:9:"\x00\x00_order";N;s:10:"\x00\x00_active";b:0;s:11:"\x00\x00_visible";b:0;s:10:"\x00\x00_parent";r:2;s:14:"\x00\x00_properties";a:0:{}s:21:"\x00\x00_customHtmlAttribs";a:0:{}s:7:"\x00\x00_uri";s:10:"/vi/search";s:12:"\x00\x00_tabindex";s:0:"";s:12:"\x00\x00_relation";s:0:"";s:14:"\x00\x00_documentId";i:53;s:15:"\x00\x00documentType";s:4:"page";s:15:"\x00\x00realFullPath";s:15:"/vi/T├¼m kiß║┐m";s:17:"\x00\x00customSettings";a:0:{}}}s:9:"\x00\x00_index";a:7:{i:3007;N;i:3026;N;i:3044;N;i:3047;N;i:3070;N;i:3093;N;i:3116;N;}s:14:"\x00\x00_dirtyIndex";b:1;}s:6:"output";s:6:"f─\t9ÿë";s:10:"navigation";s:6:"▀╬\x07y·×";s:11:"document_51";s:6:"▀╬\x07y·×";s:11:"document_39";s:6:"▀╬\x07y·×";s:11:"document_48";s:6:"▀╬\x07y·×";s:11:"document_45";s:6:"▀╬\x07y·×";s:11:"document_73";s:6:"▀╬\x07y·×";s:11:"document_46";s:6:"▀╬\x07y·×";s:11:"document_53";s:6:"▀╬\x07y·×";}"] View formatted query View runnable query Explain query 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) INSERT INTO cache_items (item_id, item_data, item_lifetime, item_time) VALUES ('nav_74f453ad06eabb5287a2c5eeb7712735', 0x4F3A313A22A9223A31303A7B733A363A22FFFFFF7FC01E223B4F3A32383A2250696D636F72655C4E617669676174696F6E5C436F6E7461696E6572223A333A7B733A393A22002A005F7061676573223B613A373A7B693A333030373B4F3A33323A2250696D636F72655C4E617669676174696F6E5C506167655C446F63756D656E74223A32353A7B733A393A22002A005F7061676573223B613A303A7B7D733A393A22002A005F696E646578223B613A303A7B7D733A31343A22002A005F6469727479496E646578223B623A303B733A393A22002A005F6C6162656C223B733A31313A225472616E67206368E1BBA7223B733A31323A22002A005F667261676D656E74223B4E3B733A363A22002A005F6964223B733A323A223531223B733A393A22002A005F636C617373223B733A353A22206D61696E223B733A393A22002A005F7469746C65223B733A303A22223B733A31303A22002A005F746172676574223B4E3B733A31333A22002A005F6163636573736B6579223B733A303A22223B733A373A22002A005F72656C223B613A303A7B7D733A373A22002A005F726576223B613A303A7B7D733A393A22002A005F6F72646572223B4E3B733A31303A22002A005F616374697665223B623A303B733A31313A22002A005F76697369626C65223B623A313B733A31303A22002A005F706172656E74223B723A323B733A31343A22002A005F70726F70657274696573223B613A303A7B7D733A32313A22002A005F637573746F6D48746D6C41747472696273223B613A303A7B7D733A373A22002A005F757269223B733A313A222F223B733A31323A22002A005F746162696E646578223B733A303A22223B733A31323A22002A005F72656C6174696F6E223B733A303A22223B733A31343A22002A005F646F63756D656E744964223B693A35313B733A31353A22002A00646F63756D656E7454797065223B733A343A226C696E6B223B733A31353A22002A007265616C46756C6C50617468223B733A31353A222F76692F5472616E67206368E1BBA7223B733A31373A22002A00637573746F6D53657474696E6773223B613A303A7B7D7D693A333032363B4F3A33323A2250696D636F72655C4E617669676174696F6E5C506167655C446F63756D656E74223A32353A7B733A393A22002A005F7061676573223B613A303A7B7D733A393A22002A005F696E646578223B613A303A7B7D733A31343A22002A005F6469727479496E646578223B623A303B733A393A22002A005F6C6162656C223B733A31343A224769E1BB9B6920746869E1BB8775223B733A31323A22002A005F667261676D656E74223B4E3B733A363A22002A005F6964223B733A323A223339223B733A393A22002A005F636C617373223B733A353A22206D61696E223B733A393A22002A005F7469746C65223B733A31343A224769E1BB9B6920746869E1BB8775223B733A31303A22002A005F746172676574223B4E3B733A31333A22002A005F6163636573736B6579223B733A303A22223B733A373A22002A005F72656C223B613A303A7B7D733A373A22002A005F726576223B613A303A7B7D733A393A22002A005F6F72646572223B4E3B733A31303A22002A005F616374697665223B623A303B733A31313A22002A005F76697369626C65223B623A313B733A31303A22002A005F706172656E74223B723A323B733A31343A22002A005F70726F70657274696573223B613A303A7B7D733A32313A22002A005F637573746F6D48746D6C41747472696273223B613A303A7B7D733A373A22002A005F757269223B733A31343A222F76692F67696F692D7468696575223B733A31323A22002A005F746162696E646578223B733A303A22223B733A31323A22002A005F72656C6174696F6E223B733A303A22223B733A31343A22002A005F646F63756D656E744964223B693A33393B733A31353A22002A00646F63756D656E7454797065223B733A343A2270616765223B733A31353A22002A007265616C46756C6C50617468223B733A31383A222F76692F4769E1BB9B6920746869E1BB8775223B733A31373A22002A00637573746F6D53657474696E6773223B613A303A7B7D7D693A333034343B4F3A33323A2250696D636F72655C4E617669676174696F6E5C506167655C446F63756D656E74223A32353A7B733A393A22002A005F7061676573223B613A303A7B7D733A393A22002A005F696E646578223B613A303A7B7D733A31343A22002A005F6469727479496E646578223B623A303B733A393A22002A005F6C6162656C223B733A31313A2242E1BAA36E20C491E1BB93223B733A31323A22002A005F667261676D656E74223B4E3B733A363A22002A005F6964223B733A323A223438223B733A393A22002A005F636C617373223B733A353A22206D61696E223B733A393A22002A005F7469746C65223B733A303A22223B733A31303A22002A005F746172676574223B4E3B733A31333A22002A005F6163636573736B6579223B733A303A22223B733A373A22002A005F72656C223B613A303A7B7D733A373A22002A005F726576223B613A303A7B7D733A393A22002A005F6F72646572223B4E3B733A31303A22002A005F616374697665223B623A303B733A31313A22002A005F76697369626C65223B623A313B733A31303A22002A005F706172656E74223B723A323B733A31343A22002A005F70726F70657274696573223B613A303A7B7D733A32313A22002A005F637573746F6D48746D6C41747472696273223B613A303A7B7D733A373A22002A005F757269223B733A31333A222F76692F62616E2D646F2D736F223B733A31323A22002A005F746162696E646578223B733A303A22223B733A31323A22002A005F72656C6174696F6E223B733A303A22223B733A31343A22002A005F646F63756D656E744964223B693A34383B733A31353A22002A00646F63756D656E7454797065223B733A343A2270616765223B733A31353A22002A007265616C46756C6C50617468223B733A32303A222F76692F42E1BAA36E20C491E1BB932073E1BB91223B733A31373A22002A00637573746F6D53657474696E6773223B613A303A7B7D7D693A333034373B4F3A33323A2250696D636F72655C4E617669676174696F6E5C506167655C446F63756D656E74223A32353A7B733A393A22002A005F7061676573223B613A303A7B7D733A393A22002A005F696E646578223B613A303A7B7D733A31343A22002A005F6469727479496E646578223B623A303B733A393A22002A005F6C6162656C223B733A31313A2253E1BBB1206B69E1BB876E223B733A31323A22002A005F667261676D656E74223B4E3B733A363A22002A005F6964223B733A323A223435223B733A393A22002A005F636C617373223B733A353A22206D61696E223B733A393A22002A005F7469746C65223B733A31313A2253E1BBB1206B69E1BB876E223B733A31303A22002A005F746172676574223B4E3B733A31333A22002A005F6163636573736B6579223B733A303A22223B733A373A22002A005F72656C223B613A303A7B7D733A373A22002A005F726576223B613A303A7B7D733A393A22002A005F6F72646572223B4E3B733A31303A22002A005F616374697665223B623A303B733A31313A22002A005F76697369626C65223B623A313B733A31303A22002A005F706172656E74223B723A323B733A31343A22002A005F70726F70657274696573223B613A303A7B7D733A32313A22002A005F637573746F6D48746D6C41747472696273223B613A303A7B7D733A373A22002A005F757269223B733A31303A222F76692F6C652D686F69223B733A31323A22002A005F746162696E646578223B733A303A22223B733A31323A22002A005F72656C6174696F6E223B733A303A22223B733A31343A22002A005F646F63756D656E744964223B693A34353B733A31353A22002A00646F63756D656E7454797065223B733A343A2270616765223B733A31353A22002A007265616C46756C6C50617468223B733A31353A222F76692F53E1BBB1206B69E1BB876E223B733A31373A22002A00637573746F6D53657474696E6773223B613A303A7B7D7D693A333037303B4F3A33323A2250696D636F72655C4E617669676174696F6E5C506167655C446F63756D656E74223A32353A7B733A393A22002A005F7061676573223B613A303A7B7D733A393A22002A005F696E646578223B613A303A7B7D733A31343A22002A005F6469727479496E646578223B623A303B733A393A22002A005F6C6162656C223B733A31323A22C490E1BAB7632073E1BAA36E223B733A31323A22002A005F667261676D656E74223B4E3B733A363A22002A005F6964223B733A323A223733223B733A393A22002A005F636C617373223B733A353A22206D61696E223B733A393A22002A005F7469746C65223B733A303A22223B733A31303A22002A005F746172676574223B4E3B733A31333A22002A005F6163636573736B6579223B733A303A22223B733A373A22002A005F72656C223B613A303A7B7D733A373A22002A005F726576223B613A303A7B7D733A393A22002A005F6F72646572223B4E3B733A31303A22002A005F616374697665223B623A303B733A31313A22002A005F76697369626C65223B623A313B733A31303A22002A005F706172656E74223B723A323B733A31343A22002A005F70726F70657274696573223B613A303A7B7D733A32313A22002A005F637573746F6D48746D6C41747472696273223B613A303A7B7D733A373A22002A005F757269223B733A31313A222F76692F6461632D73616E223B733A31323A22002A005F746162696E646578223B733A303A22223B733A31323A22002A005F72656C6174696F6E223B733A303A22223B733A31343A22002A005F646F63756D656E744964223B693A37333B733A31353A22002A00646F63756D656E7454797065223B733A343A2270616765223B733A31353A22002A007265616C46756C6C50617468223B733A31363A222F76692FC490E1BAB7632073E1BAA36E223B733A31373A22002A00637573746F6D53657474696E6773223B613A303A7B7D7D693A333039333B4F3A33323A2250696D636F72655C4E617669676174696F6E5C506167655C446F63756D656E74223A32353A7B733A393A22002A005F7061676573223B613A303A7B7D733A393A22002A005F696E646578223B613A303A7B7D733A31343A22002A005F6469727479496E646578223B623A303B733A393A22002A005F6C6162656C223B733A31303A224C69C3AA6E2068E1BB87223B733A31323A22002A005F667261676D656E74223B4E3B733A363A22002A005F6964223B733A323A223436223B733A393A22002A005F636C617373223B733A353A22206D61696E223B733A393A22002A005F7469746C65223B4E3B733A31303A22002A005F746172676574223B4E3B733A31333A22002A005F6163636573736B6579223B4E3B733A373A22002A005F72656C223B613A303A7B7D733A373A22002A005F726576223B613A303A7B7D733A393A22002A005F6F72646572223B4E3B733A31303A22002A005F616374697665223B623A303B733A31313A22002A005F76697369626C65223B623A313B733A31303A22002A005F706172656E74223B723A323B733A31343A22002A005F70726F70657274696573223B613A303A7B7D733A32313A22002A005F637573746F6D48746D6C41747472696273223B613A303A7B7D733A373A22002A005F757269223B733A31313A222F76692F6C69656E2D6865223B733A31323A22002A005F746162696E646578223B4E3B733A31323A22002A005F72656C6174696F6E223B4E3B733A31343A22002A005F646F63756D656E744964223B693A34363B733A31353A22002A00646F63756D656E7454797065223B733A343A2270616765223B733A31353A22002A007265616C46756C6C50617468223B733A31343A222F76692F4C69C3AA6E2068E1BB87223B733A31373A22002A00637573746F6D53657474696E6773223B613A303A7B7D7D693A333131363B4F3A33323A2250696D636F72655C4E617669676174696F6E5C506167655C446F63756D656E74223A32353A7B733A393A22002A005F7061676573223B613A303A7B7D733A393A22002A005F696E646578223B613A303A7B7D733A31343A22002A005F6469727479496E646578223B623A303B733A393A22002A005F6C6162656C223B733A303A22223B733A31323A22002A005F667261676D656E74223B4E3B733A363A22002A005F6964223B733A323A223533223B733A393A22002A005F636C617373223B733A353A22206D61696E223B733A393A22002A005F7469746C65223B733A303A22223B733A31303A22002A005F746172676574223B4E3B733A31333A22002A005F6163636573736B6579223B733A303A22223B733A373A22002A005F72656C223B613A303A7B7D733A373A22002A005F726576223B613A303A7B7D733A393A22002A005F6F72646572223B4E3B733A31303A22002A005F616374697665223B623A303B733A31313A22002A005F76697369626C65223B623A303B733A31303A22002A005F706172656E74223B723A323B733A31343A22002A005F70726F70657274696573223B613A303A7B7D733A32313A22002A005F637573746F6D48746D6C41747472696273223B613A303A7B7D733A373A22002A005F757269223B733A31303A222F76692F736561726368223B733A31323A22002A005F746162696E646578223B733A303A22223B733A31323A22002A005F72656C6174696F6E223B733A303A22223B733A31343A22002A005F646F63756D656E744964223B693A35333B733A31353A22002A00646F63756D656E7454797065223B733A343A2270616765223B733A31353A22002A007265616C46756C6C50617468223B733A31353A222F76692F54C3AC6D206B69E1BABF6D223B733A31373A22002A00637573746F6D53657474696E6773223B613A303A7B7D7D7D733A393A22002A005F696E646578223B613A373A7B693A333030373B4E3B693A333032363B4E3B693A333034343B4E3B693A333034373B4E3B693A333037303B4E3B693A333039333B4E3B693A333131363B4E3B7D733A31343A22002A005F6469727479496E646578223B623A313B7D733A363A226F7574707574223B733A363A2266C409399889223B733A31303A226E617669676174696F6E223B733A363A22DFCE0779FA9E223B733A31313A22646F63756D656E745F3531223B733A363A22DFCE0779FA9E223B733A31313A22646F63756D656E745F3339223B733A363A22DFCE0779FA9E223B733A31313A22646F63756D656E745F3438223B733A363A22DFCE0779FA9E223B733A31313A22646F63756D656E745F3435223B733A363A22DFCE0779FA9E223B733A31313A22646F63756D656E745F3733223B733A363A22DFCE0779FA9E223B733A31313A22646F63756D656E745F3436223B733A363A22DFCE0779FA9E223B733A31313A22646F63756D656E745F3533223B733A363A22DFCE0779FA9E223B7D, 31536000, 1764991935) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
83	0.34 ms	SELECT * FROM translations_messages LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_messages LIMIT 1; SELECT * FROM translations_messages LIMIT 1;;
84	0.29 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: [`1764991935 "translation_data_ddfbd54331382cb68f24aa0c6af8319a"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translation_data_ddfbd54331382cb68f24aa0c6af8319a');
85	0.25 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: [`1764991935 "translator\x01tags\x01" "translator_website\x01tags\x01" "translate\x01tags\x01"`] View formatted query View runnable query Explain query 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 (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translatortags', 'translator_websitetags', 'translatetags');
86	0.37 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`84`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 84;
87	0.27 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`84`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 84;
88	0.34 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`86`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 86;
89	2.30 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`86`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 86;
90	0.29 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: [`1764991935 "document_properties_27"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_27');
91	0.24 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
92	0.51 ms	SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/_fragment" "path" "auto_create" "/_fragment?_path=_locale=vi&_format=html&_controller=App%5CController%5CContentController%3A%3AfooterAction" "path_query" "https://namdan.goterest.com/_fragment?_path=_locale=vi&_format=html&_controller=App%5CController%5CContentController%3A%3AfooterAction" "entire_uri"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = ? AND ( `type` = ? OR `type` = ? ) ) OR ( source = ? AND `type` = ? ) OR ( source = ? AND `type` = ? ) ) AND active = 1 AND ( regex IS NULL OR regex = 0 ) AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/_fragment' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/_fragment?_path=_locale=vi&_format=html&_controller=App%5CController%5CContentController%3A%3AfooterAction' AND `type` = 'path_query') OR (source = 'https://namdan.goterest.com/_fragment?_path=_locale=vi&_format=html&_controller=App%5CController%5CContentController%3A%3AfooterAction' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;
93	0.30 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`27`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 27;
94	0.23 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: [`1764991935 "asset_81"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_81');
95	0.19 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: [`1764991935 "asset_116"`] View formatted query View runnable query Explain query 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 (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1764991935 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_116');
96	0.40 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`116`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 116;
97	0.28 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`116`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 116;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
pimcore	doctrine.orm.pimcore_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No loaded entities.

Symfony Profiler

GET https://namdan.goterest.com/_fragment?_path=_locale%3Dvi%26_format%3Dhtml%26_controller%3DApp%255CController%255CContentController%253A%253AfooterAction

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping