Symfony Profiler

Query Metrics

41 Database Queries

15 Different statements

34.09 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 = 5 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 = 5 OR siteId = 0) ORDER BY siteId DESC 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 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 * FROM properties WHERE
                             (
                                 (cid IN (1,168,96) 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 item_id, 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,171,168,96) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
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.55 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1784225840 "site_domain_bdf9cead241a94b715e1124e54cab384"`] 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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_bdf9cead241a94b715e1124e54cab384');
2	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: [`1784225840 "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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
3	0.39 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.68 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 = 5 AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/Documentation" "path" "auto_create" "/Documentation" "path_query" "http://cms-requestador.xiphias-digital.com/Documentation" "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 = 5 AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/Documentation' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/Documentation' AND `type` = 'path_query') OR (source = 'http://cms-requestador.xiphias-digital.com/Documentation' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = 5 AND priority = 99 ORDER BY `priority` DESC;
5	0.38 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: [`1784225840 "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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_route_redirect');
6	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: [`1784225840 "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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'redirecttags', 'routetags');
7	0.28 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.31 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/Requestador/" "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 '/Requestador/' AND `key` = BINARY 'Documentation';
9	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: [`1784225840 "document_168"`] 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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_168');
10	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: [`1784225840 "document_168\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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_168tags');
11	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: [`1784225840 "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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('sites_path_mapping');
12	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: [`1784225840 "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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'resourcetags');
13	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: [`1784225840 "site_id_5"`] 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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_id_5');
14	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: [`1784225840 "document_properties_168"`] 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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_168');
15	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: [`1784225840 "document_properties\x01tags\x01" "document_168\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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_propertiestags', 'document_168tags');
16	0.74 ms	SELECT * FROM object_url_slugs WHERE slug = '/Documentation' AND (siteId = 5 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 = 5 OR siteId = 0 ) ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/Documentation' AND (siteId = 5 OR siteId = 0) ORDER BY siteId DESC LIMIT 1;
17	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: [`1784225840 "nav_057fec0aa034d1a5664ff9bd42358066"`] 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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('nav_057fec0aa034d1a5664ff9bd42358066');
18	0.53 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: [`1784225840 "output\x01tags\x01" "navigation\x01tags\x01" "document_172\x01tags\x01" "document_171\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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('outputtags', 'navigationtags', 'document_172tags', 'document_171tags');
19	0.53 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`168`] 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 = 168 AND published = 1 LIMIT 1;
20	0.56 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`168`] 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 = 168) AND published = 1 ORDER BY `index` ASC ;
21	0.47 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: [`1784225840 "document_171"`] 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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_171');
22	0.47 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: [`1784225840 "document_properties_171"`] 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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_171');
23	0.51 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: [`1784225840 "document_properties\x01tags\x01" "document_171\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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_propertiestags', 'document_171tags');
24	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: [`1784225840 "document_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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_96');
25	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: [`1784225840 "document_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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_96tags');
26	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: [`1784225840 "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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1');
27	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: [`1784225840 "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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1tags');
28	0.62 ms	SELECT * FROM properties WHERE ( (cid IN (1,168,96) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`171`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 168, 96) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,168,96) AND inheritable = 1) OR cid = 171 ) AND ctype='document';
29	0.51 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`171`] 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 = 171 AND published = 1 LIMIT 1;
30	0.55 ms	SELECT documents.id, documents.type FROM documents WHERE (parentId = ?) AND published = 1 ORDER BY `index` ASC Parameters: [`171`] 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 = 171) AND published = 1 ORDER BY `index` ASC ;
31	0.47 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: [`1784225840 "document_172"`] 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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_172');
32	0.48 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: [`1784225840 "document_properties_172"`] 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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_172');
33	0.50 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: [`1784225840 "document_properties\x01tags\x01" "document_172\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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_propertiestags', 'document_172tags');
34	0.61 ms	SELECT * FROM properties WHERE ( (cid IN (1,171,168,96) AND inheritable = 1) OR cid = ? ) AND ctype='document' Parameters: [`172`] View formatted query View runnable query Explain query SELECT * FROM properties WHERE ( ( cid IN (1, 171, 168, 96) AND inheritable = 1 ) OR cid = ? ) AND ctype = 'document' SELECT * FROM properties WHERE ( (cid IN (1,171,168,96) AND inheritable = 1) OR cid = 172 ) AND ctype='document';
35	0.50 ms	SELECT id FROM documents d WHERE parentId = ? AND published = 1 LIMIT 1 Parameters: [`172`] 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 = 172 AND published = 1 LIMIT 1;
36	0.48 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: [`1784225840 "nav_057fec0aa034d1a5664ff9bd42358066"`] 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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('nav_057fec0aa034d1a5664ff9bd42358066');
37	0.52 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: [`1784225840 "output\x01tags\x01" "navigation\x01tags\x01" "document_172\x01tags\x01" "document_171\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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('outputtags', 'navigationtags', 'document_172tags', 'document_171tags');
38	0.53 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: [`1784225840 "output\x01tags\x01" "navigation\x01tags\x01" "document_172\x01tags\x01" "document_171\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 > 1784225840 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('outputtags', 'navigationtags', 'document_172tags', 'document_171tags');
39	6.92 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 => 1784225840 0 => "output\x01tags\x01" 1 => b"s:6:"Æ““\x0EDZ";"`] 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', 0x733A363A22C693930E445A223B, NULL, 1784225840) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
40	9.29 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 => 1784225840 0 => "nav_057fec0aa034d1a5664ff9bd42358066" 1 => b"O:1:"©":5:{s:6:"ÿÿÿ\x7FÀ\x1E";O:28:"Pimcore\Navigation\Container":3:{s:9:"\x00\x00_pages";a:1:{i:2381;O:32:"Pimcore\Navigation\Page\Document":25:{s:9:"\x00\x00_pages";a:1:{i:2370;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:67:"Configuring an AI Endpoint in Requestador: Steps and Best Practices";s:12:"\x00\x00_fragment";N;s:6:"\x00\x00_id";s:3:"172";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:128:"/Documentation/Requestador%20Documentation/Configuring%20an%20AI%20Endpoint%20in%20Requestador-%20Steps%20and%20Best%20Practices";s:12:"\x00\x00_tabindex";N;s:12:"\x00\x00_relation";N;s:14:"\x00\x00_documentId";i:172;s:15:"\x00\x00documentType";s:4:"page";s:15:"\x00\x00realFullPath";s:120:"/Requestador/Documentation/Requestador Documentation/Configuring an AI Endpoint in Requestador- Steps and Best Practices";s:17:"\x00\x00customSettings";a:0:{}}}s:9:"\x00\x00_index";a:1:{i:2370;N;}s:14:"\x00\x00_dirtyIndex";b:1;s:9:"\x00\x00_label";s:25:"Requestador Documentation";s:12:"\x00\x00_fragment";N;s:6:"\x00\x00_id";s:3:"171";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:42:"/Documentation/Requestador%20Documentation";s:12:"\x00\x00_tabindex";N;s:12:"\x00\x00_relation";N;s:14:"\x00\x00_documentId";i:171;s:15:"\x00\x00documentType";s:4:"page";s:15:"\x00\x00realFullPath";s:52:"/Requestador/Documentation/Requestador Documentation";s:17:"\x00\x00customSettings";a:0:{}}}s:9:"\x00\x00_index";a:1:{i:2381;N;}s:14:"\x00*\x00_dirtyIndex";b:1;}s:6:"output";s:6:"Æ““\x0EDZ";s:10:"navigation";s:6:"Ü±½çÂÍ";s:12:"document_172";s:6:"\x10‹fáWd";s:12:"document_171";s:6:"Jú\x11Äþ,";}"] 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_057fec0aa034d1a5664ff9bd42358066', 0x4F3A313A22A9223A353A7B733A363A22FFFFFF7FC01E223B4F3A32383A2250696D636F72655C4E617669676174696F6E5C436F6E7461696E6572223A333A7B733A393A22002A005F7061676573223B613A313A7B693A323338313B4F3A33323A2250696D636F72655C4E617669676174696F6E5C506167655C446F63756D656E74223A32353A7B733A393A22002A005F7061676573223B613A313A7B693A323337303B4F3A33323A2250696D636F72655C4E617669676174696F6E5C506167655C446F63756D656E74223A32353A7B733A393A22002A005F7061676573223B613A303A7B7D733A393A22002A005F696E646578223B613A303A7B7D733A31343A22002A005F6469727479496E646578223B623A303B733A393A22002A005F6C6162656C223B733A36373A22436F6E6669677572696E6720616E20414920456E64706F696E7420696E205265717565737461646F723A20537465707320616E64204265737420507261637469636573223B733A31323A22002A005F667261676D656E74223B4E3B733A363A22002A005F6964223B733A333A22313732223B733A393A22002A005F636C617373223B733A303A22223B733A393A22002A005F7469746C65223B4E3B733A31303A22002A005F746172676574223B4E3B733A31333A22002A005F6163636573736B6579223B4E3B733A373A22002A005F72656C223B613A303A7B7D733A373A22002A005F726576223B613A303A7B7D733A393A22002A005F6F72646572223B4E3B733A31303A22002A005F616374697665223B623A303B733A31313A22002A005F76697369626C65223B623A313B733A31303A22002A005F706172656E74223B723A343B733A31343A22002A005F70726F70657274696573223B613A303A7B7D733A32313A22002A005F637573746F6D48746D6C41747472696273223B613A303A7B7D733A373A22002A005F757269223B733A3132383A222F446F63756D656E746174696F6E2F5265717565737461646F72253230446F63756D656E746174696F6E2F436F6E6669677572696E67253230616E2532304149253230456E64706F696E74253230696E2532305265717565737461646F722D2532305374657073253230616E6425323042657374253230507261637469636573223B733A31323A22002A005F746162696E646578223B4E3B733A31323A22002A005F72656C6174696F6E223B4E3B733A31343A22002A005F646F63756D656E744964223B693A3137323B733A31353A22002A00646F63756D656E7454797065223B733A343A2270616765223B733A31353A22002A007265616C46756C6C50617468223B733A3132303A222F5265717565737461646F722F446F63756D656E746174696F6E2F5265717565737461646F7220446F63756D656E746174696F6E2F436F6E6669677572696E6720616E20414920456E64706F696E7420696E205265717565737461646F722D20537465707320616E64204265737420507261637469636573223B733A31373A22002A00637573746F6D53657474696E6773223B613A303A7B7D7D7D733A393A22002A005F696E646578223B613A313A7B693A323337303B4E3B7D733A31343A22002A005F6469727479496E646578223B623A313B733A393A22002A005F6C6162656C223B733A32353A225265717565737461646F7220446F63756D656E746174696F6E223B733A31323A22002A005F667261676D656E74223B4E3B733A363A22002A005F6964223B733A333A22313731223B733A393A22002A005F636C617373223B733A353A22206D61696E223B733A393A22002A005F7469746C65223B4E3B733A31303A22002A005F746172676574223B4E3B733A31333A22002A005F6163636573736B6579223B4E3B733A373A22002A005F72656C223B613A303A7B7D733A373A22002A005F726576223B613A303A7B7D733A393A22002A005F6F72646572223B4E3B733A31303A22002A005F616374697665223B623A303B733A31313A22002A005F76697369626C65223B623A313B733A31303A22002A005F706172656E74223B723A323B733A31343A22002A005F70726F70657274696573223B613A303A7B7D733A32313A22002A005F637573746F6D48746D6C41747472696273223B613A303A7B7D733A373A22002A005F757269223B733A34323A222F446F63756D656E746174696F6E2F5265717565737461646F72253230446F63756D656E746174696F6E223B733A31323A22002A005F746162696E646578223B4E3B733A31323A22002A005F72656C6174696F6E223B4E3B733A31343A22002A005F646F63756D656E744964223B693A3137313B733A31353A22002A00646F63756D656E7454797065223B733A343A2270616765223B733A31353A22002A007265616C46756C6C50617468223B733A35323A222F5265717565737461646F722F446F63756D656E746174696F6E2F5265717565737461646F7220446F63756D656E746174696F6E223B733A31373A22002A00637573746F6D53657474696E6773223B613A303A7B7D7D7D733A393A22002A005F696E646578223B613A313A7B693A323338313B4E3B7D733A31343A22002A005F6469727479496E646578223B623A313B7D733A363A226F7574707574223B733A363A22C693930E445A223B733A31303A226E617669676174696F6E223B733A363A22DCB1BDE7C2CD223B733A31323A22646F63756D656E745F313732223B733A363A22108B66E15764223B733A31323A22646F63756D656E745F313731223B733A363A224AFA11C4FE2C223B7D, 31536000, 1784225840) ON DUPLICATE KEY UPDATE item_data = VALUES(item_data), item_lifetime = VALUES(item_lifetime), item_time = VALUES(item_time);
41	0.32 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`168`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 168;

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://cms-requestador.xiphias-digital.com/Documentation

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

pimcore entity manager

Entities Mapping