Symfony Profiler

Query Metrics

85 Database Queries

19 Different statements

11.20 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 = 2 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 documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT documents.id FROM documents
            LEFT JOIN documents_page ON documents.id = documents_page.id
            WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
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 documents.id, concat(documents.path, documents.`key`) as fullPath
    from documents,
         documents_page,
         sites
    where sites.rootId = documents_page.id
      and documents.id = documents_page.id
      and documents_page.controller = ?
SELECT name FROM classes 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 item_id, 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_relations_portaluser WHERE src_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 item_id, 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 name FROM classes 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 item_id, 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 = ?
DELETE FROM tmp_store 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 item_id, 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 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 item_id, 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 item_id, 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_relations_portalusergroup WHERE src_id = ?
SELECT id FROM assets WHERE id IN (6,19800,26159,19735,19433,56100)
SELECT * FROM object_metadata_portalusergroup WHERE object_metadata_portalusergroup.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
SELECT * FROM object_metadata_portalusergroup WHERE object_metadata_portalusergroup.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
SELECT * FROM object_metadata_portalusergroup WHERE object_metadata_portalusergroup.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
SELECT * FROM object_metadata_portalusergroup WHERE object_metadata_portalusergroup.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
SELECT * FROM object_metadata_portalusergroup WHERE object_metadata_portalusergroup.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
SELECT * FROM object_metadata_portalusergroup WHERE object_metadata_portalusergroup.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ?  AND `type` = 'asset'
SELECT item_id, 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 translations_portal_engine_frontend 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 (?)
SELECT item_id, 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 assets WHERE `path` = BINARY ? AND `filename` = BINARY ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?

#▲	Time	Info
1	0.14 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: [`1730258818 "site_domain_68d4de3af23305fd99eb079461b04641"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_68d4de3af23305fd99eb079461b04641');
2	0.11 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: [`1730258818 "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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
3	0.10 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.22 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 = 2 AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/_portal-engine/api/download/do-single-download/6721a782644d2" "path" "auto_create" "/_portal-engine/api/download/do-single-download/6721a782644d2" "path_query" "https://library.flos.com/_portal-engine/api/download/do-single-download/6721a782644d2" "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 = 2 AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/_portal-engine/api/download/do-single-download/6721a782644d2' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/_portal-engine/api/download/do-single-download/6721a782644d2' AND `type` = 'path_query') OR (source = 'https://library.flos.com/_portal-engine/api/download/do-single-download/6721a782644d2' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite = 2 AND priority = 99 ORDER BY `priority` DESC;
5	0.09 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: [`1730258818 "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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_route_redirect');
6	0.09 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: [`1730258818 "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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'redirecttags', 'routetags');
7	0.08 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.10 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/FLOS/_portal-engine/api/download/do-single-download/" "6721a782644d2"`] 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 '/FLOS/_portal-engine/api/download/do-single-download/' AND `key` = BINARY '6721a782644d2';
9	0.08 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/FLOS/_portal-engine/api/download/do-single-download/6721a782644d2"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/FLOS/_portal-engine/api/download/do-single-download/6721a782644d2';
10	0.11 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/FLOS/%" "/_portal-engine/api/download/do-single-download/6721a782644d2"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/FLOS/%' AND documents_page.prettyUrl = '/_portal-engine/api/download/do-single-download/6721a782644d2';
11	0.07 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/FLOS/_portal-engine/api/download/" "do-single-download"`] 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 '/FLOS/_portal-engine/api/download/' AND `key` = BINARY 'do-single-download';
12	0.06 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/FLOS/_portal-engine/api/download/do-single-download"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/FLOS/_portal-engine/api/download/do-single-download';
13	0.09 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/FLOS/%" "/_portal-engine/api/download/do-single-download"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/FLOS/%' AND documents_page.prettyUrl = '/_portal-engine/api/download/do-single-download';
14	0.06 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/FLOS/_portal-engine/api/" "download"`] 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 '/FLOS/_portal-engine/api/' AND `key` = BINARY 'download';
15	0.06 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/FLOS/_portal-engine/api/download"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/FLOS/_portal-engine/api/download';
16	0.08 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/FLOS/%" "/_portal-engine/api/download"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/FLOS/%' AND documents_page.prettyUrl = '/_portal-engine/api/download';
17	0.06 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/FLOS/_portal-engine/" "api"`] 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 '/FLOS/_portal-engine/' AND `key` = BINARY 'api';
18	0.06 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/FLOS/_portal-engine/api"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/FLOS/_portal-engine/api';
19	0.08 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/FLOS/%" "/_portal-engine/api"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/FLOS/%' AND documents_page.prettyUrl = '/_portal-engine/api';
20	0.06 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/FLOS/" "_portal-engine"`] 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 '/FLOS/' AND `key` = BINARY '_portal-engine';
21	0.06 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/FLOS/_portal-engine"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/FLOS/_portal-engine';
22	0.08 ms	SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? Parameters: [`"/FLOS/%" "/_portal-engine"`] View formatted query View runnable query Explain query SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ? SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE '/FLOS/%' AND documents_page.prettyUrl = '/_portal-engine';
23	0.06 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "FLOS"`] 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 '/' AND `key` = BINARY 'FLOS';
24	0.08 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: [`1730258818 "document_2"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_2');
25	0.08 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: [`1730258818 "document_2\x01tags\x01" "asset_3217\x01tags\x01" "asset_3216\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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_2tags', 'asset_3217tags', 'asset_3216tags');
26	0.07 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: [`1730258818 "document_properties_2"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_2');
27	0.16 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: [`1730258818 "document_properties\x01tags\x01" "document_2\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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_propertiestags', 'document_2tags');
28	1.01 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: [`1730258818 "object_2810"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_2810');
29	0.11 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: [`1730258818 "object_2810\x01tags\x01" "class_portaluser\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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_2810tags', 'class_portalusertags');
30	0.17 ms	select documents.id, concat(documents.path, documents.`key`) as fullPath from documents, documents_page, sites where sites.rootId = documents_page.id and documents.id = documents_page.id and documents_page.controller = ? Parameters: [`"Pimcore\Bundle\PortalEngineBundle\Controller\PortalController::pageAction"`] View formatted query View runnable query Explain query select documents.id, concat(documents.path, documents.`key`) as fullPath from documents, documents_page, sites where sites.rootId = documents_page.id and documents.id = documents_page.id and documents_page.controller = ? select documents.id, concat(documents.path, documents.`key`) as fullPath from documents, documents_page, sites where sites.rootId = documents_page.id and documents.id = documents_page.id and documents_page.controller = 'Pimcore\\Bundle\\PortalEngineBundle\\Controller\\PortalController::pageAction';
31	0.11 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"portaluser"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'portaluser';
32	0.13 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: [`1730258818 "system_supported_locales_en"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_supported_locales_en');
33	0.10 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: [`1730258818 "system_supported_locales_en"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_supported_locales_en');
34	0.11 ms	SELECT * FROM object_relations_portaluser WHERE src_id = ? Parameters: [`2810`] View formatted query View runnable query Explain query SELECT * FROM object_relations_portaluser WHERE src_id = ? SELECT * FROM object_relations_portaluser WHERE src_id = 2810;
35	0.16 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: [`1730258818 "object_1387"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1387');
36	0.08 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: [`1730258818 "object_1387\x01tags\x01" "class_portalusergroup\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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1387tags', 'class_portalusergrouptags');
37	0.06 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"portalusergroup"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'portalusergroup';
38	0.10 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: [`1730258818 "system_supported_locales_en"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_supported_locales_en');
39	0.08 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: [`1730258818 "system_supported_locales_en"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_supported_locales_en');
40	0.10 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"portal-engine:single-download:6721a782644d2"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'portal-engine:single-download:6721a782644d2';
41	1.60 ms	DELETE FROM tmp_store WHERE id = ? Parameters: [`"portal-engine:single-download:6721a782644d2"`] View formatted query View runnable query Explain query DELETE FROM tmp_store WHERE id = ? DELETE FROM tmp_store WHERE id = 'portal-engine:single-download:6721a782644d2';
42	0.10 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: [`1730258818 "document_6"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_6');
43	0.08 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: [`1730258818 "document_6\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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_6tags');
44	0.09 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: [`1730258818 "asset_60268"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_60268');
45	0.07 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: [`1730258818 "asset_60268\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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_60268tags');
46	0.21 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 6;
47	0.10 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: [`1730258818 "asset_56100"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_56100');
48	0.07 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: [`1730258818 "asset_56100\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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_56100tags');
49	0.07 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: [`1730258818 "asset_62100"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_62100');
50	0.07 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: [`1730258818 "asset_62100\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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_62100tags');
51	0.10 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: [`1730258818 "asset_6"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_6');
52	0.12 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: [`1730258818 "asset_6\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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_6tags');
53	0.07 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: [`1730258818 "asset_60432"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_60432');
54	0.06 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: [`1730258818 "asset_60432\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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_60432tags');
55	0.07 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: [`1730258818 "asset_19433"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_19433');
56	0.11 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: [`1730258818 "asset_19433\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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_19433tags');
57	0.10 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: [`1730258818 "asset_55115"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_55115');
58	0.13 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: [`1730258818 "asset_55115\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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_55115tags');
59	0.13 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: [`1730258818 "asset_19735"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_19735');
60	0.07 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: [`1730258818 "asset_19735\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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_19735tags');
61	0.06 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: [`1730258818 "asset_19800"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_19800');
62	0.06 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: [`1730258818 "asset_19800\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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_19800tags');
63	0.09 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: [`1730258818 "asset_22593"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_22593');
64	0.06 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: [`1730258818 "asset_22593\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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_22593tags');
65	0.06 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: [`1730258818 "asset_26159"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_26159');
66	0.07 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: [`1730258818 "asset_26159\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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_26159tags');
67	0.14 ms	SELECT * FROM object_relations_portalusergroup WHERE src_id = ? Parameters: [`1387`] View formatted query View runnable query Explain query SELECT * FROM object_relations_portalusergroup WHERE src_id = ? SELECT * FROM object_relations_portalusergroup WHERE src_id = 1387;
68	0.16 ms	SELECT id FROM assets WHERE id IN (6,19800,26159,19735,19433,56100) Parameters: [] View formatted query View runnable query Explain query SELECT id FROM assets WHERE id IN ( 6, 19800, 26159, 19735, 19433, 56100 ) SELECT id FROM assets WHERE id IN (6,19800,26159,19735,19433,56100);
69	0.22 ms	SELECT * FROM object_metadata_portalusergroup WHERE object_metadata_portalusergroup.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' Parameters: [`1387 6 "assetWorkspaceDefinition" "object" "" "0" 1`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_portalusergroup WHERE object_metadata_portalusergroup.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' SELECT * FROM object_metadata_portalusergroup WHERE object_metadata_portalusergroup.id = 1387 AND dest_id = 6 AND fieldname = 'assetWorkspaceDefinition' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 1 AND `type` = 'asset';
70	0.18 ms	SELECT * FROM object_metadata_portalusergroup WHERE object_metadata_portalusergroup.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' Parameters: [`1387 19800 "assetWorkspaceDefinition" "object" "" "0" 2`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_portalusergroup WHERE object_metadata_portalusergroup.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' SELECT * FROM object_metadata_portalusergroup WHERE object_metadata_portalusergroup.id = 1387 AND dest_id = 19800 AND fieldname = 'assetWorkspaceDefinition' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 2 AND `type` = 'asset';
71	0.17 ms	SELECT * FROM object_metadata_portalusergroup WHERE object_metadata_portalusergroup.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' Parameters: [`1387 26159 "assetWorkspaceDefinition" "object" "" "0" 3`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_portalusergroup WHERE object_metadata_portalusergroup.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' SELECT * FROM object_metadata_portalusergroup WHERE object_metadata_portalusergroup.id = 1387 AND dest_id = 26159 AND fieldname = 'assetWorkspaceDefinition' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 3 AND `type` = 'asset';
72	0.16 ms	SELECT * FROM object_metadata_portalusergroup WHERE object_metadata_portalusergroup.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' Parameters: [`1387 19735 "assetWorkspaceDefinition" "object" "" "0" 4`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_portalusergroup WHERE object_metadata_portalusergroup.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' SELECT * FROM object_metadata_portalusergroup WHERE object_metadata_portalusergroup.id = 1387 AND dest_id = 19735 AND fieldname = 'assetWorkspaceDefinition' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 4 AND `type` = 'asset';
73	0.18 ms	SELECT * FROM object_metadata_portalusergroup WHERE object_metadata_portalusergroup.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' Parameters: [`1387 19433 "assetWorkspaceDefinition" "object" "" "0" 5`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_portalusergroup WHERE object_metadata_portalusergroup.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' SELECT * FROM object_metadata_portalusergroup WHERE object_metadata_portalusergroup.id = 1387 AND dest_id = 19433 AND fieldname = 'assetWorkspaceDefinition' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 5 AND `type` = 'asset';
74	0.24 ms	SELECT * FROM object_metadata_portalusergroup WHERE object_metadata_portalusergroup.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' Parameters: [`1387 56100 "assetWorkspaceDefinition" "object" "" "0" 6`] View formatted query View runnable query Explain query SELECT * FROM object_metadata_portalusergroup WHERE object_metadata_portalusergroup.id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND `type` = 'asset' SELECT * FROM object_metadata_portalusergroup WHERE object_metadata_portalusergroup.id = 1387 AND dest_id = 56100 AND fieldname = 'assetWorkspaceDefinition' AND ownertype = 'object' AND ownername = '' and position = '0' and `index` = 6 AND `type` = 'asset';
75	0.14 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: [`1730258818 "object_597"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_597');
76	0.09 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: [`1730258818 "object_597\x01tags\x01" "class_permission\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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_597tags', 'class_permissiontags');
77	0.13 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: [`1730258818 "document_properties_6"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_6');
78	0.09 ms	SELECT * FROM translations_portal_engine_frontend LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_portal_engine_frontend LIMIT 1; SELECT * FROM translations_portal_engine_frontend LIMIT 1;;
79	0.15 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: [`1730258818 "translation_data_261908ff69ba47343efb67cc61df1a24"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translation_data_261908ff69ba47343efb67cc61df1a24');
80	0.12 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: [`1730258818 "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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translatortags', 'translator_websitetags', 'translatetags');
81	0.14 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: [`1730258818 "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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('sites_path_mapping');
82	0.11 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: [`1730258818 "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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'resourcetags');
83	0.08 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: [`1730258818 "site_id_2"`] 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 > 1730258818 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_id_2');
84	0.11 ms	SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ? Parameters: [`"/Product Catalogue/IC Lights/PIM Image/" "Flos-Pim-Image-Luminaire-Suspension-IC_Lights-S3-Brass.jpg"`] View formatted query View runnable query Explain query SELECT id FROM assets WHERE `path` = BINARY ? AND `filename` = BINARY ? SELECT id FROM assets WHERE `path` = BINARY '/Product Catalogue/IC Lights/PIM Image/' AND `filename` = BINARY 'Flos-Pim-Image-Luminaire-Suspension-IC_Lights-S3-Brass.jpg';
85	0.08 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"original" "pimcore_image_thumbnails"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'original' AND scope = 'pimcore_image_thumbnails';

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
pimcore_generic_data_index	doctrine.orm.pimcore_generic_data_index_entity_manager
portal_engine	doctrine.orm.portal_engine_entity_manager
pimcore_direct_edit	doctrine.orm.pimcore_direct_edit_entity_manager
statistics_explorer	doctrine.orm.statistics_explorer_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

pimcore_generic_data_index entity manager

No loaded entities.

portal_engine entity manager

No loaded entities.

pimcore_direct_edit entity manager

No loaded entities.

statistics_explorer entity manager

No loaded entities.

Symfony Profiler

GET https://library.flos.com/_portal-engine/api/download/do-single-download/6721a782644d2

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping

pimcore_generic_data_index entity manager

portal_engine entity manager

pimcore_direct_edit entity manager

statistics_explorer entity manager