Symfony Profiler

Query Metrics

54 Database Queries

16 Different statements

29.20 ms Query time

0 Invalid entities

0 Managed 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 = 7 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 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 * FROM object_url_slugs WHERE slug = '/Documentation' AND (siteId = 7 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
SELECT documents.id, documents.type FROM documents WHERE  (`key` = ?) 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 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 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 * FROM properties WHERE
                             (
                                 (cid IN (1,156,155) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
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 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 * FROM properties WHERE
                             (
                                 (cid IN (1,156,155) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
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 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 documents_editables WHERE documentId = ?

#▲	Time	Info
1	0.34 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: [`1772527601 "site_domain_9bdaed04d5626f78766ac3a34c34a542"`] 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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_9bdaed04d5626f78766ac3a34c34a542');
2	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: [`1772527601 "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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
3	0.29 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.46 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 = 7 AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/Documentation" "path" "auto_create" "/Documentation?version=Latest" "path_query" "http://blade-fx.xiphias-digital.com/Documentation?version=Latest" "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 = 7 AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/Documentation' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/Documentation?version=Latest' AND `type` = 'path_query') OR (source = 'http://blade-fx.xiphias-digital.com/Documentation?version=Latest' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = 7 AND priority = 99 ORDER BY `priority` DESC;
5	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: [`1772527601 "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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_route_redirect');
6	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: [`1772527601 "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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'redirecttags', 'routetags');
7	0.25 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.45 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/BladeFx/" "Documentation"`] 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 '/BladeFx/' AND `key` = BINARY 'Documentation';
9	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: [`1772527601 "document_156"`] 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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_156');
10	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: [`1772527601 "document_156\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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_156tags');
11	0.28 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: [`1772527601 "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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('sites_path_mapping');
12	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: [`1772527601 "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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'resourcetags');
13	0.39 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: [`1772527601 "site_id_7"`] 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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_id_7');
14	0.44 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: [`1772527601 "document_properties_156"`] 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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_156');
15	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: [`1772527601 "document_properties\x01tags\x01" "document_156\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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_propertiestags', 'document_156tags');
16	0.31 ms	SELECT * FROM object_url_slugs WHERE slug = '/Documentation' AND (siteId = 7 OR siteId = 0) ORDER BY siteId DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE slug = '/Documentation' AND ( siteId = 7 OR siteId = 0 ) ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/Documentation' AND (siteId = 7 OR siteId = 0) ORDER BY siteId DESC LIMIT 1;
17	0.31 ms	SELECT documents.id, documents.type FROM documents WHERE (`key` = ?) AND published = 1 LIMIT 1 Parameters: [`"Documentation"`] View formatted query View runnable query Explain query SELECT documents.id, documents.type FROM documents WHERE (`key` = ?) AND published = 1 LIMIT 1 SELECT documents.id, documents.type FROM documents WHERE (`key` = 'Documentation') AND published = 1 LIMIT 1;
18	0.27 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`156`] 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 = 156) AND published = 1 ORDER BY `index` ASC ;
19	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: [`1772527601 "document_157"`] 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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_157');
20	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: [`1772527601 "document_157\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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_157tags');
21	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: [`1772527601 "document_158"`] 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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_158');
22	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: [`1772527601 "document_158\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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_158tags');
23	0.26 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/Documentation/" "Latest"`] 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 '/Documentation/' AND `key` = BINARY 'Latest';
24	0.25 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/Documentation/Latest"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/Documentation/Latest';
25	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: [`1772527601 "nav_c7fe37540ab65ab1b2cd1165dcab1456"`] 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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('nav_c7fe37540ab65ab1b2cd1165dcab1456');
26	0.28 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: [`1772527601 "output\x01tags\x01" "navigation\x01tags\x01" "document_159\x01tags\x01" "document_157\x01tags\x01" "document_160\x01tags\x01" "document_158\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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('outputtags', 'navigationtags', 'document_159tags', 'document_157tags', 'document_160tags', 'document_158tags');
27	0.35 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`156`] 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 = 156 AND published = 1 LIMIT 1;
28	0.31 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`156`] 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 = 156) AND published = 1 ORDER BY `index` ASC ;
29	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: [`1772527601 "document_properties_157"`] 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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_157');
30	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: [`1772527601 "\x00tags\x00document_properties_157"`] 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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_157');
31	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: [`1772527601 "document_155"`] 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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_155');
32	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: [`1772527601 "document_155\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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_155tags');
33	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: [`1772527601 "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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1');
34	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: [`1772527601 "document_1\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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1tags');
35	0.28 ms	SELECT * FROM properties WHERE ( (cid IN (1,156,155) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`157`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 156, 155) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,156,155) AND inheritable = 1) OR cid = 157 ) AND ctype='document';
36	0.27 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`157`] 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 = 157 AND published = 1 LIMIT 1;
37	0.29 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`157`] 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 = 157) AND published = 1 ORDER BY `index` ASC ;
38	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: [`1772527601 "document_159"`] 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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_159');
39	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: [`1772527601 "document_properties_159"`] 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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_159');
40	0.25 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`159`] 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 = 159 AND published = 1 LIMIT 1;
41	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: [`1772527601 "document_properties_158"`] 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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_158');
42	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: [`1772527601 "\x00tags\x00document_properties_158"`] 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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_158');
43	0.32 ms	SELECT * FROM properties WHERE ( (cid IN (1,156,155) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`158`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 156, 155) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,156,155) AND inheritable = 1) OR cid = 158 ) AND ctype='document';
44	0.21 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`158`] 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 = 158 AND published = 1 LIMIT 1;
45	0.22 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`158`] 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 = 158) AND published = 1 ORDER BY `index` ASC ;
46	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: [`1772527601 "document_160"`] 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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_160');
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: [`1772527601 "document_properties_160"`] 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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_160');
48	0.25 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`160`] 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 = 160 AND published = 1 LIMIT 1;
49	0.28 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: [`1772527601 "nav_c7fe37540ab65ab1b2cd1165dcab1456"`] 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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('nav_c7fe37540ab65ab1b2cd1165dcab1456');
50	0.31 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: [`1772527601 "output\x01tags\x01" "navigation\x01tags\x01" "document_159\x01tags\x01" "document_157\x01tags\x01" "document_160\x01tags\x01" "document_158\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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('outputtags', 'navigationtags', 'document_159tags', 'document_157tags', 'document_160tags', 'document_158tags');
51	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: [`1772527601 "output\x01tags\x01" "navigation\x01tags\x01" "document_159\x01tags\x01" "document_157\x01tags\x01" "document_160\x01tags\x01" "document_158\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 > 1772527601 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('outputtags', 'navigationtags', 'document_159tags', 'document_157tags', 'document_160tags', 'document_158tags');
52	9.33 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 => 1772527601 0 => "output\x01tags\x01" 1 => b"s:6:"••“›ÈË";"`] 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', 0x733A363A229595939BC8CB223B, NULL, 1772527601) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
53	5.40 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 => 1772527601 0 => "nav_c7fe37540ab65ab1b2cd1165dcab1456" 1 => b"O:1:"©":7:{s:6:"ÿÿÿ\x7FÀ\x1E";O:28:"Pimcore\Navigation\Container":3:{s:9:"\x00\x00_pages";a:2:{i:2419;O:32:"Pimcore\Navigation\Page\Document":25:{s:9:"\x00\x00_pages";a:1:{i:2450;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:4:"Test";s:12:"\x00\x00_fragment";N;s:6:"\x00\x00_id";s:3:"159";s:9:"\x00\x00_class";s:0:"";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:4;s:14:"\x00\x00_properties";a:0:{}s:21:"\x00\x00_customHtmlAttribs";a:0:{}s:7:"\x00\x00_uri";s:26:"/Documentation/Latest/Test";s:12:"\x00\x00_tabindex";N;s:12:"\x00\x00_relation";N;s:14:"\x00\x00_documentId";i:159;s:15:"\x00\x00documentType";s:4:"page";s:15:"\x00\x00realFullPath";s:34:"/BladeFx/Documentation/Latest/Test";s:17:"\x00\x00customSettings";a:0:{}}}s:9:"\x00\x00_index";a:1:{i:2450;N;}s:14:"\x00\x00_dirtyIndex";b:1;s:9:"\x00\x00_label";N;s:12:"\x00\x00_fragment";N;s:6:"\x00\x00_id";s:3:"157";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: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";N;s:12:"\x00\x00_tabindex";N;s:12:"\x00\x00_relation";N;s:14:"\x00\x00_documentId";i:157;s:15:"\x00\x00documentType";s:6:"folder";s:15:"\x00\x00realFullPath";s:29:"/BladeFx/Documentation/Latest";s:17:"\x00\x00customSettings";a:0:{}}i:2478;O:32:"Pimcore\Navigation\Page\Document":25:{s:9:"\x00\x00_pages";a:1:{i:2479;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:6:"test 2";s:12:"\x00\x00_fragment";N;s:6:"\x00\x00_id";s:3:"160";s:9:"\x00\x00_class";s:0:"";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:57;s:14:"\x00\x00_properties";a:0:{}s:21:"\x00\x00_customHtmlAttribs";a:0:{}s:7:"\x00\x00_uri";s:28:"/Documentation/v1.5/test%202";s:12:"\x00\x00_tabindex";N;s:12:"\x00\x00_relation";N;s:14:"\x00\x00_documentId";i:160;s:15:"\x00\x00documentType";s:4:"page";s:15:"\x00\x00realFullPath";s:34:"/BladeFx/Documentation/v1.5/test 2";s:17:"\x00\x00customSettings";a:0:{}}}s:9:"\x00\x00_index";a:1:{i:2479;N;}s:14:"\x00\x00_dirtyIndex";b:1;s:9:"\x00\x00_label";N;s:12:"\x00\x00_fragment";N;s:6:"\x00\x00_id";s:3:"158";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: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";N;s:12:"\x00\x00_tabindex";N;s:12:"\x00\x00_relation";N;s:14:"\x00\x00_documentId";i:158;s:15:"\x00\x00documentType";s:6:"folder";s:15:"\x00\x00realFullPath";s:27:"/BladeFx/Documentation/v1.5";s:17:"\x00\x00customSettings";a:0:{}}}s:9:"\x00\x00_index";a:2:{i:2419;N;i:2478;N;}s:14:"\x00*\x00_dirtyIndex";b:1;}s:6:"output";s:6:"••“›ÈË";s:10:"navigation";s:6:"Ü±½çÂÍ";s:12:"document_159";s:6:"³8áPÕ@";s:12:"document_157";s:6:"«([ä“ö";s:12:"document_160";s:6:"º¯]\x0F\x0Fª";s:12:"document_158";s:6:"¼}¡~“-";}"] 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_c7fe37540ab65ab1b2cd1165dcab1456', 0x4F3A313A22A9223A373A7B733A363A22FFFFFF7FC01E223B4F3A32383A2250696D636F72655C4E617669676174696F6E5C436F6E7461696E6572223A333A7B733A393A22002A005F7061676573223B613A323A7B693A323431393B4F3A33323A2250696D636F72655C4E617669676174696F6E5C506167655C446F63756D656E74223A32353A7B733A393A22002A005F7061676573223B613A313A7B693A323435303B4F3A33323A2250696D636F72655C4E617669676174696F6E5C506167655C446F63756D656E74223A32353A7B733A393A22002A005F7061676573223B613A303A7B7D733A393A22002A005F696E646578223B613A303A7B7D733A31343A22002A005F6469727479496E646578223B623A303B733A393A22002A005F6C6162656C223B733A343A2254657374223B733A31323A22002A005F667261676D656E74223B4E3B733A363A22002A005F6964223B733A333A22313539223B733A393A22002A005F636C617373223B733A303A22223B733A393A22002A005F7469746C65223B4E3B733A31303A22002A005F746172676574223B4E3B733A31333A22002A005F6163636573736B6579223B4E3B733A373A22002A005F72656C223B613A303A7B7D733A373A22002A005F726576223B613A303A7B7D733A393A22002A005F6F72646572223B4E3B733A31303A22002A005F616374697665223B623A303B733A31313A22002A005F76697369626C65223B623A313B733A31303A22002A005F706172656E74223B723A343B733A31343A22002A005F70726F70657274696573223B613A303A7B7D733A32313A22002A005F637573746F6D48746D6C41747472696273223B613A303A7B7D733A373A22002A005F757269223B733A32363A222F446F63756D656E746174696F6E2F4C61746573742F54657374223B733A31323A22002A005F746162696E646578223B4E3B733A31323A22002A005F72656C6174696F6E223B4E3B733A31343A22002A005F646F63756D656E744964223B693A3135393B733A31353A22002A00646F63756D656E7454797065223B733A343A2270616765223B733A31353A22002A007265616C46756C6C50617468223B733A33343A222F426C61646546782F446F63756D656E746174696F6E2F4C61746573742F54657374223B733A31373A22002A00637573746F6D53657474696E6773223B613A303A7B7D7D7D733A393A22002A005F696E646578223B613A313A7B693A323435303B4E3B7D733A31343A22002A005F6469727479496E646578223B623A313B733A393A22002A005F6C6162656C223B4E3B733A31323A22002A005F667261676D656E74223B4E3B733A363A22002A005F6964223B733A333A22313537223B733A393A22002A005F636C617373223B733A353A22206D61696E223B733A393A22002A005F7469746C65223B4E3B733A31303A22002A005F746172676574223B4E3B733A31333A22002A005F6163636573736B6579223B4E3B733A373A22002A005F72656C223B613A303A7B7D733A373A22002A005F726576223B613A303A7B7D733A393A22002A005F6F72646572223B4E3B733A31303A22002A005F616374697665223B623A303B733A31313A22002A005F76697369626C65223B623A303B733A31303A22002A005F706172656E74223B723A323B733A31343A22002A005F70726F70657274696573223B613A303A7B7D733A32313A22002A005F637573746F6D48746D6C41747472696273223B613A303A7B7D733A373A22002A005F757269223B4E3B733A31323A22002A005F746162696E646578223B4E3B733A31323A22002A005F72656C6174696F6E223B4E3B733A31343A22002A005F646F63756D656E744964223B693A3135373B733A31353A22002A00646F63756D656E7454797065223B733A363A22666F6C646572223B733A31353A22002A007265616C46756C6C50617468223B733A32393A222F426C61646546782F446F63756D656E746174696F6E2F4C6174657374223B733A31373A22002A00637573746F6D53657474696E6773223B613A303A7B7D7D693A323437383B4F3A33323A2250696D636F72655C4E617669676174696F6E5C506167655C446F63756D656E74223A32353A7B733A393A22002A005F7061676573223B613A313A7B693A323437393B4F3A33323A2250696D636F72655C4E617669676174696F6E5C506167655C446F63756D656E74223A32353A7B733A393A22002A005F7061676573223B613A303A7B7D733A393A22002A005F696E646578223B613A303A7B7D733A31343A22002A005F6469727479496E646578223B623A303B733A393A22002A005F6C6162656C223B733A363A22746573742032223B733A31323A22002A005F667261676D656E74223B4E3B733A363A22002A005F6964223B733A333A22313630223B733A393A22002A005F636C617373223B733A303A22223B733A393A22002A005F7469746C65223B4E3B733A31303A22002A005F746172676574223B4E3B733A31333A22002A005F6163636573736B6579223B4E3B733A373A22002A005F72656C223B613A303A7B7D733A373A22002A005F726576223B613A303A7B7D733A393A22002A005F6F72646572223B4E3B733A31303A22002A005F616374697665223B623A303B733A31313A22002A005F76697369626C65223B623A313B733A31303A22002A005F706172656E74223B723A35373B733A31343A22002A005F70726F70657274696573223B613A303A7B7D733A32313A22002A005F637573746F6D48746D6C41747472696273223B613A303A7B7D733A373A22002A005F757269223B733A32383A222F446F63756D656E746174696F6E2F76312E352F7465737425323032223B733A31323A22002A005F746162696E646578223B4E3B733A31323A22002A005F72656C6174696F6E223B4E3B733A31343A22002A005F646F63756D656E744964223B693A3136303B733A31353A22002A00646F63756D656E7454797065223B733A343A2270616765223B733A31353A22002A007265616C46756C6C50617468223B733A33343A222F426C61646546782F446F63756D656E746174696F6E2F76312E352F746573742032223B733A31373A22002A00637573746F6D53657474696E6773223B613A303A7B7D7D7D733A393A22002A005F696E646578223B613A313A7B693A323437393B4E3B7D733A31343A22002A005F6469727479496E646578223B623A313B733A393A22002A005F6C6162656C223B4E3B733A31323A22002A005F667261676D656E74223B4E3B733A363A22002A005F6964223B733A333A22313538223B733A393A22002A005F636C617373223B733A353A22206D61696E223B733A393A22002A005F7469746C65223B4E3B733A31303A22002A005F746172676574223B4E3B733A31333A22002A005F6163636573736B6579223B4E3B733A373A22002A005F72656C223B613A303A7B7D733A373A22002A005F726576223B613A303A7B7D733A393A22002A005F6F72646572223B4E3B733A31303A22002A005F616374697665223B623A303B733A31313A22002A005F76697369626C65223B623A303B733A31303A22002A005F706172656E74223B723A323B733A31343A22002A005F70726F70657274696573223B613A303A7B7D733A32313A22002A005F637573746F6D48746D6C41747472696273223B613A303A7B7D733A373A22002A005F757269223B4E3B733A31323A22002A005F746162696E646578223B4E3B733A31323A22002A005F72656C6174696F6E223B4E3B733A31343A22002A005F646F63756D656E744964223B693A3135383B733A31353A22002A00646F63756D656E7454797065223B733A363A22666F6C646572223B733A31353A22002A007265616C46756C6C50617468223B733A32373A222F426C61646546782F446F63756D656E746174696F6E2F76312E35223B733A31373A22002A00637573746F6D53657474696E6773223B613A303A7B7D7D7D733A393A22002A005F696E646578223B613A323A7B693A323431393B4E3B693A323437383B4E3B7D733A31343A22002A005F6469727479496E646578223B623A313B7D733A363A226F7574707574223B733A363A229595939BC8CB223B733A31303A226E617669676174696F6E223B733A363A22DCB1BDE7C2CD223B733A31323A22646F63756D656E745F313539223B733A363A22B338E150D540223B733A31323A22646F63756D656E745F313537223B733A363A22AB285BE493F6223B733A31323A22646F63756D656E745F313630223B733A363A22BAAF5D0F0FAA223B733A31323A22646F63756D656E745F313538223B733A363A22BC7DA17E932D223B7D, 31536000, 1772527601) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
54	0.26 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`156`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 156;

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.

Managed Entities

pimcore entity manager

Class	Amount of managed objects

Entities Mapping

No loaded entities.

Symfony Profiler

GET http://blade-fx.xiphias-digital.com/Documentation?version=Latest

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

pimcore entity manager

Entities Mapping