Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

148 Database Queries

33 Different statements

83.68 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 item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 '%,2528,%' ORDER BY `group` ASC,a.o_id ASC LIMIT 50, 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 item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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 object_EF_OSO.o_id as o_id, object_EF_OSO.o_type as o_type FROM object_EF_OSO WHERE (cartId = ? AND IFNULL(successorOrder__id , "") = "" AND  object_EF_OSO.o_type IN ('object','folder')) AND object_EF_OSO.o_published = 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 * 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 '%,2528,%' 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 '%,2528,%') 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 = '982014'
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` = '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 = '982015'
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 * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '982017'
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 * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1139465'
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 * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1139466'
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 * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1201801'
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 * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1246678'
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 = '1293723'
SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1363469'
SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1370402'
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 = '1470013'
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 * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1583322'
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 * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1583323'
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 * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1723565'
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data 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.05 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: [`1793017837 [ "\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 > 1793017837 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_domain_2ac2a3e12cbba3cc8614530bed758092', 'site_domain_2ac2a3e12cbba3cc8614530bed758092');
2	0.44 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793017837 [ "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 > 1793017837 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	0.66 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/Zuidelijke-wateren~c2528" "sourcePathQuery" => "/nl/producten/Zuidelijke-wateren~c2528?page=3" "sourceEntireUri" => "https://dev.devliegerfilip.dspdev.be/nl/producten/Zuidelijke-wateren~c2528?page=3" "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/Zuidelijke-wateren~c2528' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/nl/producten/Zuidelijke-wateren~c2528?page=3' AND `type` = 'path_query') OR (source = 'https://dev.devliegerfilip.dspdev.be/nl/producten/Zuidelijke-wateren~c2528?page=3' 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.77 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: [`1793017837 [ "\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 > 1793017837 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_route_redirect', 'system_route_redirect');
5	0.79 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: [`1793017837 [ "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 > 1793017837 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.41 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	0.46 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Zuidelijke-wateren~c2528" "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 'Zuidelijke-wateren~c2528';
8	0.42 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/nl/producten/Zuidelijke-wateren~c2528"`] 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/Zuidelijke-wateren~c2528';
9	0.32 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.26 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.38 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.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: [`1793017837 [ "\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 > 1793017837 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_2', 'document_2');
13	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: [`1793017837 [ "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 > 1793017837 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_2\0tags\0', 'document_1\0tags\0');
14	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: [`1793017837 [ "\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 > 1793017837 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_2', 'document_properties_2');
15	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: [`1793017837 [ "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 > 1793017837 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	0.40 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.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: [`1793017841 [ "\x00tags\x00object_2528" "object_2528" ]`] 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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_2528', 'object_2528');
18	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: [`1793017841 [ "object_2528\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_2528\0tags\0', 'class_9\0tags\0');
19	0.33 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.55 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793017841 [ "\x00tags\x00object_2525" "object_2525" ]`] 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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_2525', 'object_2525');
21	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: [`1793017841 [ "object_2525\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_2525\0tags\0', 'class_9\0tags\0');
22	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: [`1793017841 [ "\x00tags\x00object_2524" "object_2524" ]`] 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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_2524', 'object_2524');
23	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: [`1793017841 [ "object_2524\x00tags\x00" "class_9\x00tags\x00" "asset_60\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_2524\0tags\0', 'class_9\0tags\0', 'asset_60\0tags\0');
24	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_2467', 'object_2467');
25	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: [`1793017841 [ "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 > 1793017841 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');
26	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_2466', 'object_2466');
27	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: [`1793017841 [ "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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_2466\0tags\0');
28	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0website_config', 'website_config');
29	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: [`1793017841 [ "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 > 1793017841 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');
30	0.37 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';
31	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_40', 'object_40');
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: [`1793017841 [ "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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_40\0tags\0');
33	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_34', 'object_34');
34	0.19 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793017841 [ "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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_34\0tags\0');
35	0.21 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1', 'object_1');
36	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: [`1793017841 [ "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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1\0tags\0');
37	8.91 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 '%,2528,%' ORDER BY `group` ASC,a.o_id ASC LIMIT 50, 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 '%,2528,%' ORDER BY `group` ASC, a.o_id ASC LIMIT 50, 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 '%,2528,%' ORDER BY `group` ASC,a.o_id ASC LIMIT 50, 25;
38	0.23 ms	SELECT FOUND_ROWS() Parameters: [] View formatted query View runnable query Explain query SELECT FOUND_ROWS() SELECT FOUND_ROWS();
39	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: [`1793017841 [ "\x00tags\x00object_982014" "object_982014" ]`] 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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_982014', 'object_982014');
40	0.20 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793017841 [ "object_982014\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_982014\0tags\0', 'class_8\0tags\0');
41	0.41 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';
42	1.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793017841 [ "\x00tags\x00object_982015" "object_982015" ]`] 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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_982015', 'object_982015');
43	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: [`1793017841 [ "object_982015\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_982015\0tags\0', 'class_8\0tags\0');
44	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: [`1793017841 [ "\x00tags\x00object_982017" "object_982017" ]`] 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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_982017', 'object_982017');
45	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: [`1793017841 [ "object_982017\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_982017\0tags\0', 'class_8\0tags\0');
46	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: [`1793017841 [ "\x00tags\x00object_1139465" "object_1139465" ]`] 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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1139465', 'object_1139465');
47	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: [`1793017841 [ "object_1139465\x00tags\x00" "class_8\x00tags\x00" "asset_17549\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1139465\0tags\0', 'class_8\0tags\0', 'asset_17549\0tags\0');
48	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: [`1793017841 [ "\x00tags\x00object_1139466" "object_1139466" ]`] 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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1139466', 'object_1139466');
49	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: [`1793017841 [ "object_1139466\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1139466\0tags\0', 'class_8\0tags\0');
50	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: [`1793017841 [ "\x00tags\x00object_1201801" "object_1201801" ]`] 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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1201801', 'object_1201801');
51	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: [`1793017841 [ "object_1201801\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1201801\0tags\0', 'class_8\0tags\0');
52	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: [`1793017841 [ "\x00tags\x00object_1246678" "object_1246678" ]`] 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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1246678', 'object_1246678');
53	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: [`1793017841 [ "object_1246678\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1246678\0tags\0', 'class_8\0tags\0');
54	1.08 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793017841 [ "\x00tags\x00object_1293723" "object_1293723" ]`] 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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1293723', 'object_1293723');
55	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: [`1793017841 [ "object_1293723\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1293723\0tags\0', 'class_8\0tags\0');
56	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: [`1793017841 [ "\x00tags\x00object_1363469" "object_1363469" ]`] 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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1363469', 'object_1363469');
57	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: [`1793017841 [ "object_1363469\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1363469\0tags\0', 'class_8\0tags\0');
58	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: [`1793017841 [ "\x00tags\x00object_1370402" "object_1370402" ]`] 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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1370402', 'object_1370402');
59	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: [`1793017841 [ "object_1370402\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1370402\0tags\0', 'class_8\0tags\0');
60	0.86 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793017841 [ "\x00tags\x00object_1470013" "object_1470013" ]`] 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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1470013', 'object_1470013');
61	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: [`1793017841 [ "object_1470013\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1470013\0tags\0', 'class_8\0tags\0');
62	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: [`1793017841 [ "\x00tags\x00object_1583322" "object_1583322" ]`] 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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1583322', 'object_1583322');
63	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: [`1793017841 [ "object_1583322\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1583322\0tags\0', 'class_8\0tags\0');
64	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: [`1793017841 [ "\x00tags\x00object_1583323" "object_1583323" ]`] 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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1583323', 'object_1583323');
65	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: [`1793017841 [ "object_1583323\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1583323\0tags\0', 'class_8\0tags\0');
66	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: [`1793017841 [ "\x00tags\x00object_1723565" "object_1723565" ]`] 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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1723565', 'object_1723565');
67	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: [`1793017841 [ "object_1723565\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1723565\0tags\0', 'class_8\0tags\0');
68	0.87 ms	SELECT object_EF_OSO.o_id as o_id, object_EF_OSO.o_type as o_type FROM object_EF_OSO WHERE (cartId = ? AND IFNULL(successorOrder__id , "") = "" AND object_EF_OSO.o_type IN ('object','folder')) AND object_EF_OSO.o_published = 1 Parameters: [`"Pimcore\Bundle\EcommerceFrameworkBundle\CartManager\SessionCart_sesscart_6adf47eb937c9"`] View formatted query View runnable query Explain query SELECT object_EF_OSO.o_id as o_id, object_EF_OSO.o_type as o_type FROM object_EF_OSO WHERE ( cartId = ? AND IFNULL(successorOrder__id, "") = "" AND object_EF_OSO.o_type IN ('object', 'folder') ) AND object_EF_OSO.o_published = 1 SELECT object_EF_OSO.o_id as o_id, object_EF_OSO.o_type as o_type FROM object_EF_OSO WHERE (cartId = 'Pimcore\\Bundle\\EcommerceFrameworkBundle\\CartManager\\SessionCart_sesscart_6adf47eb937c9' AND IFNULL(successorOrder__id , "") = "" AND object_EF_OSO.o_type IN ('object','folder')) AND object_EF_OSO.o_published = 1;
69	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_1', 'document_1');
70	0.19 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793017841 [ "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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1\0tags\0');
71	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_3', 'object_3');
72	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: [`1793017841 [ "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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_3\0tags\0', 'class_1\0tags\0');
73	0.41 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;;
74	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0translation_data_2b0562963ad619f7386bc0e9856ed713', 'translation_data_2b0562963ad619f7386bc0e9856ed713');
75	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: [`1793017841 [ "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 > 1793017841 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');
76	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_1', 'document_properties_1');
77	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: [`1793017841 [ "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 > 1793017841 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');
78	0.56 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 ;
79	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_3117', 'object_3117');
80	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: [`1793017841 [ "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 > 1793017841 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');
81	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_3210', 'object_3210');
82	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: [`1793017841 [ "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 > 1793017841 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');
83	0.62 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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0nav_5c4b242e936ff98d9730282bb67058e8', 'nav_5c4b242e936ff98d9730282bb67058e8');
84	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: [1793017841 [ "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 > 1793017841 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');
85	10.33 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 '%,2528,%' 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 '%,2528,%' 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 '%,2528,%' GROUP BY TRIM(`parentCategoryIds`);
86	0.79 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: [`2528`] 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 = 2528 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;
87	9.38 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 '%,2528,%') 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 '%,2528,%' ) 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 '%,2528,%') GROUP BY dest;
88	0.96 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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_932742', 'object_932742');
89	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: [`1793017841 [ "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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_932742\0tags\0', 'class_14\0tags\0');
90	0.38 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';
91	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_932744', 'object_932744');
92	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: [`1793017841 [ "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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_932744\0tags\0', 'class_14\0tags\0');
93	0.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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_932745', 'object_932745');
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: [`1793017841 [ "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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_932745\0tags\0', 'class_14\0tags\0');
95	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_932743', 'object_932743');
96	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: [`1793017841 [ "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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_932743\0tags\0', 'class_14\0tags\0');
97	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_932741', 'object_932741');
98	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: [`1793017841 [ "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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_932741\0tags\0');
99	0.50 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 ;
100	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_932746', 'object_932746');
101	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: [`1793017841 [ "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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_932746\0tags\0', 'class_14\0tags\0');
102	0.71 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '982014' 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 = '982014' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '982014';
103	0.35 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';
104	0.65 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;
105	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1454321', 'object_1454321');
106	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: [`1793017841 [ "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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1454321\0tags\0', 'class_15\0tags\0');
107	0.34 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '982015' 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 = '982015' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '982015';
108	0.54 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;
109	0.32 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '982017' 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 = '982017' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '982017';
110	0.43 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;
111	0.32 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1139465' 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 = '1139465' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1139465';
112	0.40 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;
113	0.28 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1139466' 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 = '1139466' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1139466';
114	0.46 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;
115	0.33 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1201801' 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 = '1201801' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1201801';
116	0.42 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;
117	0.37 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1246678' 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 = '1246678' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1246678';
118	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;
119	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1454319', 'object_1454319');
120	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: [`1793017841 [ "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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1454319\0tags\0', 'class_15\0tags\0');
121	0.30 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1293723' 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 = '1293723' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1293723';
122	0.35 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1363469' 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 = '1363469' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1363469';
123	0.28 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1370402' 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 = '1370402' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1370402';
124	0.50 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;
125	0.28 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1470013' 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 = '1470013' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1470013';
126	0.49 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;
127	0.30 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1583322' 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 = '1583322' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1583322';
128	0.43 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;
129	0.28 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1583323' 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 = '1583323' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1583323';
130	0.40 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;
131	0.28 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1723565' 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 = '1723565' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1723565';
132	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_11', 'document_11');
133	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0nav_de78686b5603782418c9dfa609d38233', 'nav_de78686b5603782418c9dfa609d38233');
134	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: [`1793017841 [ "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 > 1793017841 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');
135	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_8', 'document_8');
136	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0nav_fb4388bafeb6a3b0411e289b0db7d628', 'nav_fb4388bafeb6a3b0411e289b0db7d628');
137	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: [`1793017841 [ "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 > 1793017841 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');
138	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_10', 'document_10');
139	0.41 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';
140	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_51', 'document_51');
141	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: [`1793017841 [ "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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_51\0tags\0', 'asset_18538\0tags\0');
142	0.35 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;
143	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_51', 'document_properties_51');
144	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: [`1793017841 [ "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 > 1793017841 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');
145	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_18538', 'asset_18538');
146	0.50 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;
147	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: [`1793017841 [ "\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 > 1793017841 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0imagick_format_webp', 'imagick_format_webp');
148	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: [`1793017841 [ "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 > 1793017841 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.
FormBuilderBundle\Model\OutputWorkflow	No errors.

Symfony Profiler

https://dev.devliegerfilip.dspdev.be/nl/producten/Zuidelijke-wateren~c2528?page=3

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

papyrus connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping