Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

132 Database Queries

28 Different statements

110.77 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection


SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 targeting_target_groups UNION SELECT id FROM targeting_rules 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 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 item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 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 item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 SQL_CALC_FOUND_ROWS a.o_id, priceSystemName FROM ecommerceframework_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND parentCategoryIds LIKE '%,2705,%' ORDER BY `group` ASC,a.o_id ASC LIMIT 75, 25
SELECT FOUND_ROWS()
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 translations_messages LIMIT 1;
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_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 TRIM(`parentCategoryIds`) as `value`, count(*) as `count` FROM ecommerceframework_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND parentCategoryIds LIKE '%,2705,%' GROUP BY TRIM(`parentCategoryIds`)
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC
SELECT dest as `value`, count(*) as `count` FROM ecommerceframework_productindex_relations a WHERE fieldname = 'categoryTypes' AND src IN (SELECT a.o_id FROM ecommerceframework_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND parentCategoryIds LIKE '%,2705,%') GROUP BY dest
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND  objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` 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 * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '838639'
SELECT name FROM classes WHERE id = ?
SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0'  AND  object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '870246'
SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0'  AND  object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1
SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '981736'
SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '3'  AND  object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1132904'
SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0'  AND  object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1
SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1163538'
SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0'  AND  object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1
SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1244771'
SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0'  AND  object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1
SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1307206'
SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0'  AND  object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1
SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1441728'
SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0'  AND  object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1
SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1441729'
SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0'  AND  object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1
SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1723645'
SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0'  AND  object_15.o_type IN ('object','folder')) AND object_15.o_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 (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 * FROM assets_image_thumbnail_cache WHERE cid = :cid
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)

#▲	Time	Info
1	1.43 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: [`1793080874 [ "\x00tags\x00site_domain_2ac2a3e12cbba3cc8614530bed758092" "site_domain_2ac2a3e12cbba3cc8614530bed758092" ]`] 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 > 1793080874 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_domain_2ac2a3e12cbba3cc8614530bed758092', 'site_domain_2ac2a3e12cbba3cc8614530bed758092');
2	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: [`1793080874 [ "system\x00tags\x00" "site\x00tags\x00" "site_domain_2ac2a3e12cbba3cc8614530bed758092\x00tags\x00" ]`] 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 > 1793080874 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'site\0tags\0', 'site_domain_2ac2a3e12cbba3cc8614530bed758092\0tags\0');
3	1.23 ms	SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC Parameters: [`"sourcePath" => "/nl/producten/Soepen~c2705" "sourcePathQuery" => "/nl/producten/Soepen~c2705?page=4" "sourceEntireUri" => "https://dev.devliegerfilip.dspdev.be/nl/producten/Soepen~c2705?page=4" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = :sourcePath AND ( `type` = :typePath OR `type` = :typeAuto ) ) OR ( source = :sourcePathQuery AND `type` = :typePathQuery ) OR ( source = :sourceEntireUri AND `type` = :typeEntireUri ) ) AND active = 1 AND regex IS NULL AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/nl/producten/Soepen~c2705' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/nl/producten/Soepen~c2705?page=4' AND `type` = 'path_query') OR (source = 'https://dev.devliegerfilip.dspdev.be/nl/producten/Soepen~c2705?page=4' AND `type` = 'entire_uri') ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;
4	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: [`1793080874 [ "\x00tags\x00system_route_redirect" "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 > 1793080874 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_route_redirect', 'system_route_redirect');
5	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: [`1793080874 [ "system\x00tags\x00" "redirect\x00tags\x00" "route\x00tags\x00" "system_route_redirect\x00tags\x00" ]`] 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 > 1793080874 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'redirect\0tags\0', 'route\0tags\0', 'system_route_redirect\0tags\0');
6	0.78 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "reports" "scope" => "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';
7	1.37 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Soepen~c2705" "path" => "/nl/producten/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/nl/producten/' AND `key` = BINARY 'Soepen~c2705';
8	0.79 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/nl/producten/Soepen~c2705"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/nl/producten/Soepen~c2705';
9	6.29 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "producten" "path" => "/nl/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/nl/' AND `key` = BINARY 'producten';
10	0.43 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/nl/producten"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/nl/producten';
11	0.50 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "nl" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/' AND `key` = BINARY 'nl';
12	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: [`1793080874 [ "\x00tags\x00document_2" "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 > 1793080874 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_2', 'document_2');
13	0.58 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: [`1793080874 [ "document_2\x00tags\x00" "document_1\x00tags\x00" ]`] 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 > 1793080874 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_2\0tags\0', 'document_1\0tags\0');
14	0.54 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: [`1793080874 [ "\x00tags\x00document_properties_2" "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 > 1793080874 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_2', 'document_properties_2');
15	0.39 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080874 [ "document_properties\x00tags\x00" "document_2\x00tags\x00" "document_properties_2\x00tags\x00" ]`] 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 > 1793080874 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0', 'document_2\0tags\0', 'document_properties_2\0tags\0');
16	1.56 ms	SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;
17	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: [`1793080875 [ "\x00tags\x00object_2705" "object_2705" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_2705', 'object_2705');
18	0.24 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "object_2705\x00tags\x00" "class_9\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_2705\0tags\0', 'class_9\0tags\0');
19	0.92 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"9"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '9';
20	0.82 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: [`1793080875 [ "\x00tags\x00object_2698" "object_2698" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_2698', 'object_2698');
21	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: [`1793080875 [ "object_2698\x00tags\x00" "class_9\x00tags\x00" "asset_27\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_2698\0tags\0', 'class_9\0tags\0', 'asset_27\0tags\0');
22	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: [`1793080875 [ "\x00tags\x00object_2467" "object_2467" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_2467', 'object_2467');
23	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: [`1793080875 [ "object_2467\x00tags\x00" "class_9\x00tags\x00" "asset_10\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_2467\0tags\0', 'class_9\0tags\0', 'asset_10\0tags\0');
24	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: [`1793080875 [ "\x00tags\x00object_2466" "object_2466" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_2466', 'object_2466');
25	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: [`1793080875 [ "object_2466\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_2466\0tags\0');
26	0.45 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: [`1793080875 [ "\x00tags\x00website_config" "website_config" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0website_config', 'website_config');
27	0.40 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: [`1793080875 [ "website_config\x00tags\x00" "system\x00tags\x00" "config\x00tags\x00" "output\x00tags\x00" "object_41\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('website_config\0tags\0', 'system\0tags\0', 'config\0tags\0', 'output\0tags\0', 'object_41\0tags\0');
28	0.26 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"EF_FD"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'EF_FD';
29	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: [`1793080875 [ "\x00tags\x00object_40" "object_40" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_40', 'object_40');
30	0.34 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "object_40\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_40\0tags\0');
31	0.93 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: [`1793080875 [ "\x00tags\x00object_34" "object_34" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_34', 'object_34');
32	0.23 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "object_34\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_34\0tags\0');
33	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: [`1793080875 [ "\x00tags\x00object_1" "object_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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1', 'object_1');
34	0.84 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: [`1793080875 [ "object_1\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1\0tags\0');
35	16.83 ms	SELECT SQL_CALC_FOUND_ROWS a.o_id, priceSystemName FROM ecommerceframework_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND parentCategoryIds LIKE '%,2705,%' ORDER BY `group` ASC,a.o_id ASC LIMIT 75, 25 Parameters: [] View formatted query View runnable query Explain query SELECT SQL_CALC_FOUND_ROWS a.o_id, priceSystemName FROM ecommerceframework_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND parentCategoryIds LIKE '%,2705,%' ORDER BY `group` ASC, a.o_id ASC LIMIT 75, 25 SELECT SQL_CALC_FOUND_ROWS a.o_id, priceSystemName FROM ecommerceframework_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND parentCategoryIds LIKE '%,2705,%' ORDER BY `group` ASC,a.o_id ASC LIMIT 75, 25;
36	1.44 ms	SELECT FOUND_ROWS() Parameters: [] View formatted query View runnable query Explain query SELECT FOUND_ROWS() SELECT FOUND_ROWS();
37	0.40 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: [`1793080875 [ "\x00tags\x00object_838639" "object_838639" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_838639', 'object_838639');
38	0.60 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: [`1793080875 [ "object_838639\x00tags\x00" "class_8\x00tags\x00" "asset_17145\x00tags\x00" "asset_17146\x00tags\x00" "asset_17147\x00tags\x00" "asset_17148\x00tags\x00" "asset_17149\x00tags\x00" "asset_17150\x00tags\x00" "asset_17151\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_838639\0tags\0', 'class_8\0tags\0', 'asset_17145\0tags\0', 'asset_17146\0tags\0', 'asset_17147\0tags\0', 'asset_17148\0tags\0', 'asset_17149\0tags\0', 'asset_17150\0tags\0', 'asset_17151\0tags\0');
39	0.39 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"8"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '8';
40	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: [`1793080875 [ "\x00tags\x00object_870246" "object_870246" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_870246', 'object_870246');
41	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: [`1793080875 [ "object_870246\x00tags\x00" "class_8\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_870246\0tags\0', 'class_8\0tags\0');
42	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: [`1793080875 [ "\x00tags\x00object_981736" "object_981736" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_981736', 'object_981736');
43	0.34 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "object_981736\x00tags\x00" "class_8\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_981736\0tags\0', 'class_8\0tags\0');
44	0.27 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "\x00tags\x00object_1132904" "object_1132904" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1132904', 'object_1132904');
45	0.24 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "object_1132904\x00tags\x00" "class_8\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1132904\0tags\0', 'class_8\0tags\0');
46	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: [`1793080875 [ "\x00tags\x00object_1163538" "object_1163538" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1163538', 'object_1163538');
47	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: [`1793080875 [ "object_1163538\x00tags\x00" "class_8\x00tags\x00" "asset_17280\x00tags\x00" "asset_17281\x00tags\x00" "asset_17282\x00tags\x00" "asset_17283\x00tags\x00" "asset_17284\x00tags\x00" "asset_17285\x00tags\x00" "asset_17286\x00tags\x00" "asset_17287\x00tags\x00" "asset_17288\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1163538\0tags\0', 'class_8\0tags\0', 'asset_17280\0tags\0', 'asset_17281\0tags\0', 'asset_17282\0tags\0', 'asset_17283\0tags\0', 'asset_17284\0tags\0', 'asset_17285\0tags\0', 'asset_17286\0tags\0', 'asset_17287\0tags\0', 'asset_17288\0tags\0');
48	0.26 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "\x00tags\x00object_1244771" "object_1244771" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1244771', 'object_1244771');
49	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: [`1793080875 [ "object_1244771\x00tags\x00" "class_8\x00tags\x00" "asset_15718\x00tags\x00" "asset_15719\x00tags\x00" "asset_15720\x00tags\x00" "asset_15721\x00tags\x00" "asset_15722\x00tags\x00" "asset_15723\x00tags\x00" "asset_15724\x00tags\x00" "asset_15725\x00tags\x00" "asset_15726\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1244771\0tags\0', 'class_8\0tags\0', 'asset_15718\0tags\0', 'asset_15719\0tags\0', 'asset_15720\0tags\0', 'asset_15721\0tags\0', 'asset_15722\0tags\0', 'asset_15723\0tags\0', 'asset_15724\0tags\0', 'asset_15725\0tags\0', 'asset_15726\0tags\0');
50	0.41 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: [`1793080875 [ "\x00tags\x00object_1307206" "object_1307206" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1307206', 'object_1307206');
51	0.30 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "object_1307206\x00tags\x00" "class_8\x00tags\x00" "asset_15155\x00tags\x00" "asset_15156\x00tags\x00" "asset_15157\x00tags\x00" "asset_15158\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1307206\0tags\0', 'class_8\0tags\0', 'asset_15155\0tags\0', 'asset_15156\0tags\0', 'asset_15157\0tags\0', 'asset_15158\0tags\0');
52	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: [`1793080875 [ "\x00tags\x00object_1441728" "object_1441728" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1441728', 'object_1441728');
53	0.26 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "object_1441728\x00tags\x00" "class_8\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1441728\0tags\0', 'class_8\0tags\0');
54	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: [`1793080875 [ "\x00tags\x00object_1441729" "object_1441729" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1441729', 'object_1441729');
55	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: [`1793080875 [ "object_1441729\x00tags\x00" "class_8\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1441729\0tags\0', 'class_8\0tags\0');
56	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: [`1793080875 [ "\x00tags\x00object_1723645" "object_1723645" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1723645', 'object_1723645');
57	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: [`1793080875 [ "object_1723645\x00tags\x00" "class_8\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1723645\0tags\0', 'class_8\0tags\0');
58	0.40 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: [`1793080875 [ "\x00tags\x00document_1" "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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_1', 'document_1');
59	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: [`1793080875 [ "document_1\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1\0tags\0');
60	0.41 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: [`1793080875 [ "\x00tags\x00object_3" "object_3" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_3', 'object_3');
61	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: [`1793080875 [ "object_3\x00tags\x00" "class_1\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_3\0tags\0', 'class_1\0tags\0');
62	1.07 ms	SELECT * FROM translations_messages LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_messages LIMIT 1; SELECT * FROM translations_messages LIMIT 1;;
63	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: [`1793080875 [ "\x00tags\x00translation_data_2b0562963ad619f7386bc0e9856ed713" "translation_data_2b0562963ad619f7386bc0e9856ed713" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0translation_data_2b0562963ad619f7386bc0e9856ed713', 'translation_data_2b0562963ad619f7386bc0e9856ed713');
64	0.28 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "translator\x00tags\x00" "translator_website\x00tags\x00" "translate\x00tags\x00" "translation_data_2b0562963ad619f7386bc0e9856ed713\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translator\0tags\0', 'translator_website\0tags\0', 'translate\0tags\0', 'translation_data_2b0562963ad619f7386bc0e9856ed713\0tags\0');
65	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: [`1793080875 [ "\x00tags\x00document_properties_1" "document_properties_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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_1', 'document_properties_1');
66	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: [`1793080875 [ "document_properties\x00tags\x00" "document_1\x00tags\x00" "document_properties_1\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0', 'document_1\0tags\0', 'document_properties_1\0tags\0');
67	2.82 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_index` ASC Parameters: [`2466`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_index` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 2466 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_index` ASC ;
68	0.39 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "\x00tags\x00object_3117" "object_3117" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_3117', 'object_3117');
69	0.56 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: [`1793080875 [ "object_3117\x00tags\x00" "class_9\x00tags\x00" "asset_4\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_3117\0tags\0', 'class_9\0tags\0', 'asset_4\0tags\0');
70	0.40 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: [`1793080875 [ "\x00tags\x00object_3210" "object_3210" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_3210', 'object_3210');
71	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: [`1793080875 [ "object_3210\x00tags\x00" "class_9\x00tags\x00" "asset_11\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_3210\0tags\0', 'class_9\0tags\0', 'asset_11\0tags\0');
72	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: [`1793080875 [ "\x00tags\x00nav_5c4b242e936ff98d9730282bb67058e8" "nav_5c4b242e936ff98d9730282bb67058e8" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0nav_5c4b242e936ff98d9730282bb67058e8', 'nav_5c4b242e936ff98d9730282bb67058e8');
73	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: [1793080875 [ "output\x00tags\x00" "navigation\x00tags\x00" "document_46\x00tags\x00" "document_47\x00tags\x00" "document_14\x00tags\x00" "document_13\x00tags\x00" "document_12\x00tags\x00" "document_11\x00tags\x00" "document_9\x00tags\x00" "document_10\x00tags\x00" "document_50\x00tags\x00" "document_8\x00tags\x00" "document_4\x00tags\x00" "document_19\x00tags\x00" "document_20\x00tags\x00" "document_39\x00tags\x00" "document_21\x00tags\x00" "document_45\x00tags\x00" "document_18\x00tags\x00" "document_24\x00tags\x00" "document_25\x00tags\x00" "document_26\x00tags\x00" "document_27\x00tags\x00" "document_23\x00tags\x00" "document_32\x00tags\x00" "document_41\x00tags\x00" "document_43\x00tags\x00" "document_2\x00tags\x00" "nav_5c4b242e936ff98d9730282bb67058e8\x00tags\x00" ]] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output\0tags\0', 'navigation\0tags\0', 'document_46\0tags\0', 'document_47\0tags\0', 'document_14\0tags\0', 'document_13\0tags\0', 'document_12\0tags\0', 'document_11\0tags\0', 'document_9\0tags\0', 'document_10\0tags\0', 'document_50\0tags\0', 'document_8\0tags\0', 'document_4\0tags\0', 'document_19\0tags\0', 'document_20\0tags\0', 'document_39\0tags\0', 'document_21\0tags\0', 'document_45\0tags\0', 'document_18\0tags\0', 'document_24\0tags\0', 'document_25\0tags\0', 'document_26\0tags\0', 'document_27\0tags\0', 'document_23\0tags\0', 'document_32\0tags\0', 'document_41\0tags\0', 'document_43\0tags\0', 'document_2\0tags\0', 'nav_5c4b242e936ff98d9730282bb67058e8\0tags\0');
74	8.97 ms	SELECT TRIM(`parentCategoryIds`) as `value`, count() as `count` FROM ecommerceframework_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND parentCategoryIds LIKE '%,2705,%' GROUP BY TRIM(`parentCategoryIds`) Parameters: [] View formatted query View runnable query Explain query SELECT TRIM(`parentCategoryIds`) as `value`, count() as `count` FROM ecommerceframework_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND parentCategoryIds LIKE '%,2705,%' GROUP BY TRIM(`parentCategoryIds`) SELECT TRIM(`parentCategoryIds`) as `value`, count(*) as `count` FROM ecommerceframework_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND parentCategoryIds LIKE '%,2705,%' GROUP BY TRIM(`parentCategoryIds`);
75	0.70 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`2705`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 2705 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;
76	14.31 ms	SELECT dest as `value`, count() as `count` FROM ecommerceframework_productindex_relations a WHERE fieldname = 'categoryTypes' AND src IN (SELECT a.o_id FROM ecommerceframework_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND parentCategoryIds LIKE '%,2705,%') GROUP BY dest Parameters: [] View formatted query View runnable query Explain query SELECT dest as `value`, count() as `count` FROM ecommerceframework_productindex_relations a WHERE fieldname = 'categoryTypes' AND src IN ( SELECT a.o_id FROM ecommerceframework_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND parentCategoryIds LIKE '%,2705,%' ) GROUP BY dest SELECT dest as `value`, count(*) as `count` FROM ecommerceframework_productindex_relations a WHERE fieldname = 'categoryTypes' AND src IN (SELECT a.o_id FROM ecommerceframework_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND parentCategoryIds LIKE '%,2705,%') GROUP BY dest;
77	0.74 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: [`1793080875 [ "\x00tags\x00object_932742" "object_932742" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_932742', 'object_932742');
78	0.36 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "object_932742\x00tags\x00" "class_14\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_932742\0tags\0', 'class_14\0tags\0');
79	0.37 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"14"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '14';
80	0.66 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: [`1793080875 [ "\x00tags\x00object_932745" "object_932745" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_932745', 'object_932745');
81	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: [`1793080875 [ "object_932745\x00tags\x00" "class_14\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_932745\0tags\0', 'class_14\0tags\0');
82	0.42 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "\x00tags\x00object_932746" "object_932746" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_932746', 'object_932746');
83	0.34 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "object_932746\x00tags\x00" "class_14\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_932746\0tags\0', 'class_14\0tags\0');
84	0.28 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "\x00tags\x00object_932743" "object_932743" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_932743', 'object_932743');
85	0.28 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "object_932743\x00tags\x00" "class_14\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_932743\0tags\0', 'class_14\0tags\0');
86	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: [`1793080875 [ "\x00tags\x00object_932741" "object_932741" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_932741', 'object_932741');
87	0.25 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "object_932741\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_932741\0tags\0');
88	0.41 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`932741`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 932741 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;
89	0.25 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "\x00tags\x00object_932744" "object_932744" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_932744', 'object_932744');
90	0.25 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "object_932744\x00tags\x00" "class_14\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_932744\0tags\0', 'class_14\0tags\0');
91	1.55 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '838639' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '838639' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '838639';
92	1.20 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"15"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '15';
93	2.60 ms	SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE ( `PapyrusId` = '0' AND object_15.o_type IN ('object', 'folder') ) AND object_15.o_published = 1 LIMIT 1 SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1;
94	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: [`1793080875 [ "\x00tags\x00object_1454319" "object_1454319" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1454319', 'object_1454319');
95	0.34 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "object_1454319\x00tags\x00" "class_15\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1454319\0tags\0', 'class_15\0tags\0');
96	0.33 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '870246' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '870246' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '870246';
97	0.49 ms	SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE ( `PapyrusId` = '0' AND object_15.o_type IN ('object', 'folder') ) AND object_15.o_published = 1 LIMIT 1 SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1;
98	0.26 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '981736' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '981736' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '981736';
99	0.45 ms	SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '3' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE ( `PapyrusId` = '3' AND object_15.o_type IN ('object', 'folder') ) AND object_15.o_published = 1 LIMIT 1 SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '3' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1;
100	0.27 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "\x00tags\x00object_1454321" "object_1454321" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1454321', 'object_1454321');
101	0.24 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "object_1454321\x00tags\x00" "class_15\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1454321\0tags\0', 'class_15\0tags\0');
102	0.72 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1132904' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1132904' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1132904';
103	0.43 ms	SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE ( `PapyrusId` = '0' AND object_15.o_type IN ('object', 'folder') ) AND object_15.o_published = 1 LIMIT 1 SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1;
104	0.31 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1163538' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1163538' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1163538';
105	0.43 ms	SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE ( `PapyrusId` = '0' AND object_15.o_type IN ('object', 'folder') ) AND object_15.o_published = 1 LIMIT 1 SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1;
106	0.34 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1244771' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1244771' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1244771';
107	0.52 ms	SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE ( `PapyrusId` = '0' AND object_15.o_type IN ('object', 'folder') ) AND object_15.o_published = 1 LIMIT 1 SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1;
108	0.27 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1307206' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1307206' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1307206';
109	0.44 ms	SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE ( `PapyrusId` = '0' AND object_15.o_type IN ('object', 'folder') ) AND object_15.o_published = 1 LIMIT 1 SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1;
110	0.29 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1441728' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1441728' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1441728';
111	0.40 ms	SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE ( `PapyrusId` = '0' AND object_15.o_type IN ('object', 'folder') ) AND object_15.o_published = 1 LIMIT 1 SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1;
112	0.42 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1441729' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1441729' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1441729';
113	0.37 ms	SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE ( `PapyrusId` = '0' AND object_15.o_type IN ('object', 'folder') ) AND object_15.o_published = 1 LIMIT 1 SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1;
114	0.30 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1723645' Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1723645' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1723645';
115	0.40 ms	SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE ( `PapyrusId` = '0' AND object_15.o_type IN ('object', 'folder') ) AND object_15.o_published = 1 LIMIT 1 SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1;
116	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: [`1793080875 [ "\x00tags\x00document_11" "document_11" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_11', 'document_11');
117	0.36 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "\x00tags\x00nav_de78686b5603782418c9dfa609d38233" "nav_de78686b5603782418c9dfa609d38233" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0nav_de78686b5603782418c9dfa609d38233', 'nav_de78686b5603782418c9dfa609d38233');
118	0.97 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: [`1793080875 [ "output\x00tags\x00" "navigation\x00tags\x00" "document_46\x00tags\x00" "document_47\x00tags\x00" "document_14\x00tags\x00" "document_13\x00tags\x00" "document_12\x00tags\x00" "nav_de78686b5603782418c9dfa609d38233\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output\0tags\0', 'navigation\0tags\0', 'document_46\0tags\0', 'document_47\0tags\0', 'document_14\0tags\0', 'document_13\0tags\0', 'document_12\0tags\0', 'nav_de78686b5603782418c9dfa609d38233\0tags\0');
119	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: [`1793080875 [ "\x00tags\x00document_8" "document_8" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_8', 'document_8');
120	0.27 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "\x00tags\x00nav_fb4388bafeb6a3b0411e289b0db7d628" "nav_fb4388bafeb6a3b0411e289b0db7d628" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0nav_fb4388bafeb6a3b0411e289b0db7d628', 'nav_fb4388bafeb6a3b0411e289b0db7d628');
121	0.28 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "output\x00tags\x00" "navigation\x00tags\x00" "document_9\x00tags\x00" "document_10\x00tags\x00" "document_50\x00tags\x00" "nav_fb4388bafeb6a3b0411e289b0db7d628\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output\0tags\0', 'navigation\0tags\0', 'document_9\0tags\0', 'document_10\0tags\0', 'document_50\0tags\0', 'nav_fb4388bafeb6a3b0411e289b0db7d628\0tags\0');
122	0.28 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "\x00tags\x00document_10" "document_10" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_10', 'document_10');
123	0.37 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "popup" "path" => "/nl/snippets/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/nl/snippets/' AND `key` = BINARY 'popup';
124	0.23 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "\x00tags\x00document_51" "document_51" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_51', 'document_51');
125	0.23 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "document_51\x00tags\x00" "asset_18538\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_51\0tags\0', 'asset_18538\0tags\0');
126	0.92 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`51`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 51;
127	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: [`1793080875 [ "\x00tags\x00document_properties_51" "document_properties_51" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_51', 'document_properties_51');
128	0.25 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "document_properties\x00tags\x00" "document_51\x00tags\x00" "document_properties_51\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0', 'document_51\0tags\0', 'document_properties_51\0tags\0');
129	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: [`1793080875 [ "\x00tags\x00asset_18538" "asset_18538" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_18538', 'asset_18538');
130	0.95 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid Parameters: [`"cid" => 18538`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid SELECT * FROM assets_image_thumbnail_cache WHERE cid = 18538;
131	0.26 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "\x00tags\x00imagick_format_webp" "imagick_format_webp" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0imagick_format_webp', 'imagick_format_webp');
132	0.22 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793080875 [ "imagick_format_webp\x00tags\x00" ]`] 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 > 1793080875 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('imagick_format_webp\0tags\0');

papyrus connection

No database queries were performed.

Database Connections

Name	Service
default	doctrine.dbal.default_connection
papyrus	doctrine.dbal.papyrus_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
FormBuilderBundle\Model\FormDefinition	No errors.

Symfony Profiler

https://dev.devliegerfilip.dspdev.be/_fragment?_path=_locale%3Dnl%26_format%3Dhtml%26_controller%3DApp%255CController%255CDefaultController%253A%253AdefaultAction

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

papyrus connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping