Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

133 Database Queries

29 Different statements

305.94 ms Query time

0 Invalid entities

Queries

Group similar statements

default connection


SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT name FROM classes WHERE id = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT name FROM classes WHERE id = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT SQL_CALC_FOUND_ROWS a.o_id, priceSystemName FROM ecommerceframework_productindex a WHERE active = 1 AND o_virtualProductActive = 1 AND inProductList = 1 AND parentCategoryIds LIKE '%,1723554,%' ORDER BY `group` ASC,a.o_id ASC LIMIT 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 * 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 '%,1723554,%' 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 '%,1723554,%') 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 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 item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '354'
SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1169'
SELECT name FROM classes WHERE id = ?
SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0'  AND  object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1176'
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 = '1180'
SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1228'
SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1306'
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 = '6786'
SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '6787'
SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '7779'
SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '717013'
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 = '800138'
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 = '1432971'
SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0'  AND  object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE 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	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: [`1793027210 [ "\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_domain_2ac2a3e12cbba3cc8614530bed758092', 'site_domain_2ac2a3e12cbba3cc8614530bed758092');
2	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: [`1793027210 [ "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 > 1793027210 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.58 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/Jus~c1723554" "sourcePathQuery" => "/nl/producten/Jus~c1723554" "sourceEntireUri" => "https://dev.devliegerfilip.dspdev.be/nl/producten/Jus~c1723554" "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/Jus~c1723554' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/nl/producten/Jus~c1723554' AND `type` = 'path_query') OR (source = 'https://dev.devliegerfilip.dspdev.be/nl/producten/Jus~c1723554' 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.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: [`1793027210 [ "\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_route_redirect', 'system_route_redirect');
5	0.31 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "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 > 1793027210 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.40 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.50 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "Jus~c1723554" "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 'Jus~c1723554';
8	0.61 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/nl/producten/Jus~c1723554"`] 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/Jus~c1723554';
9	0.31 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.47 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.86 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.65 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_2', 'document_2');
13	0.72 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_2\0tags\0', 'document_1\0tags\0');
14	5.84 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_2', 'document_properties_2');
15	1.06 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "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 > 1793027210 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	2.14 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	4.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: [`1793027210 [ "\x00tags\x00object_1723554" "object_1723554" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1723554', 'object_1723554');
18	0.45 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "object_1723554\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1723554\0tags\0', 'class_9\0tags\0');
19	3.13 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	2.80 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "\x00tags\x00object_2625" "object_2625" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_2625', 'object_2625');
21	2.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: [`1793027210 [ "object_2625\x00tags\x00" "class_9\x00tags\x00" "asset_25\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_2625\0tags\0', 'class_9\0tags\0', 'asset_25\0tags\0');
22	2.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: [`1793027210 [ "\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_2467', 'object_2467');
23	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: [`1793027210 [ "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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_2467\0tags\0', 'class_9\0tags\0', 'asset_10\0tags\0');
24	0.91 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_2466', 'object_2466');
25	0.30 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_2466\0tags\0');
26	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: [`1793027210 [ "\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0website_config', 'website_config');
27	3.02 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('website_config\0tags\0', 'system\0tags\0', 'config\0tags\0', 'output\0tags\0', 'object_41\0tags\0');
28	0.34 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"EF_FD"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'EF_FD';
29	1.91 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_40', 'object_40');
30	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: [`1793027210 [ "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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_40\0tags\0');
31	1.67 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_34', 'object_34');
32	0.88 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_34\0tags\0');
33	2.69 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1', 'object_1');
34	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: [`1793027210 [ "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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1\0tags\0');
35	34.52 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 '%,1723554,%' ORDER BY `group` ASC,a.o_id ASC LIMIT 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 '%,1723554,%' ORDER BY `group` ASC, a.o_id ASC LIMIT 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 '%,1723554,%' ORDER BY `group` ASC,a.o_id ASC LIMIT 25;
36	0.21 ms	SELECT FOUND_ROWS() Parameters: [] View formatted query View runnable query Explain query SELECT FOUND_ROWS() SELECT FOUND_ROWS();
37	3.81 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "\x00tags\x00object_354" "object_354" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_354', 'object_354');
38	2.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: [`1793027210 [ "object_354\x00tags\x00" "class_8\x00tags\x00" "asset_1218\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_354\0tags\0', 'class_8\0tags\0', 'asset_1218\0tags\0');
39	0.28 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"8"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '8';
40	4.16 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "\x00tags\x00object_1169" "object_1169" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1169', 'object_1169');
41	1.66 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "object_1169\x00tags\x00" "class_8\x00tags\x00" "asset_16078\x00tags\x00" "asset_16079\x00tags\x00" "asset_16080\x00tags\x00" "asset_16081\x00tags\x00" "asset_16082\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1169\0tags\0', 'class_8\0tags\0', 'asset_16078\0tags\0', 'asset_16079\0tags\0', 'asset_16080\0tags\0', 'asset_16081\0tags\0', 'asset_16082\0tags\0');
42	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: [`1793027210 [ "\x00tags\x00object_1176" "object_1176" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1176', 'object_1176');
43	1.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: [`1793027210 [ "object_1176\x00tags\x00" "class_8\x00tags\x00" "asset_16458\x00tags\x00" "asset_16459\x00tags\x00" "asset_16460\x00tags\x00" "asset_16461\x00tags\x00" "asset_16462\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1176\0tags\0', 'class_8\0tags\0', 'asset_16458\0tags\0', 'asset_16459\0tags\0', 'asset_16460\0tags\0', 'asset_16461\0tags\0', 'asset_16462\0tags\0');
44	2.89 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "\x00tags\x00object_1180" "object_1180" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1180', 'object_1180');
45	1.02 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "object_1180\x00tags\x00" "class_8\x00tags\x00" "asset_16607\x00tags\x00" "asset_16608\x00tags\x00" "asset_16609\x00tags\x00" "asset_16610\x00tags\x00" "asset_16611\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1180\0tags\0', 'class_8\0tags\0', 'asset_16607\0tags\0', 'asset_16608\0tags\0', 'asset_16609\0tags\0', 'asset_16610\0tags\0', 'asset_16611\0tags\0');
46	5.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: [`1793027210 [ "\x00tags\x00object_1228" "object_1228" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1228', 'object_1228');
47	2.64 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "object_1228\x00tags\x00" "class_8\x00tags\x00" "asset_16174\x00tags\x00" "asset_16175\x00tags\x00" "asset_16176\x00tags\x00" "asset_16177\x00tags\x00" "asset_16178\x00tags\x00" "asset_16179\x00tags\x00" "asset_16180\x00tags\x00" "asset_16181\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1228\0tags\0', 'class_8\0tags\0', 'asset_16174\0tags\0', 'asset_16175\0tags\0', 'asset_16176\0tags\0', 'asset_16177\0tags\0', 'asset_16178\0tags\0', 'asset_16179\0tags\0', 'asset_16180\0tags\0', 'asset_16181\0tags\0');
48	4.93 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "\x00tags\x00object_1306" "object_1306" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1306', 'object_1306');
49	1.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: [`1793027210 [ "object_1306\x00tags\x00" "class_8\x00tags\x00" "asset_16584\x00tags\x00" "asset_16585\x00tags\x00" "asset_16586\x00tags\x00" "asset_16587\x00tags\x00" "asset_16588\x00tags\x00" "asset_16589\x00tags\x00" "asset_16590\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1306\0tags\0', 'class_8\0tags\0', 'asset_16584\0tags\0', 'asset_16585\0tags\0', 'asset_16586\0tags\0', 'asset_16587\0tags\0', 'asset_16588\0tags\0', 'asset_16589\0tags\0', 'asset_16590\0tags\0');
50	3.17 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "\x00tags\x00object_6786" "object_6786" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_6786', 'object_6786');
51	1.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: [`1793027210 [ "object_6786\x00tags\x00" "class_8\x00tags\x00" "asset_2865\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_6786\0tags\0', 'class_8\0tags\0', 'asset_2865\0tags\0');
52	2.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: [`1793027210 [ "\x00tags\x00object_6787" "object_6787" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_6787', 'object_6787');
53	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: [`1793027210 [ "object_6787\x00tags\x00" "class_8\x00tags\x00" "asset_2866\x00tags\x00" "asset_2867\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_6787\0tags\0', 'class_8\0tags\0', 'asset_2866\0tags\0', 'asset_2867\0tags\0');
54	2.68 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "\x00tags\x00object_7779" "object_7779" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_7779', 'object_7779');
55	2.13 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "object_7779\x00tags\x00" "class_8\x00tags\x00" "asset_16789\x00tags\x00" "asset_16790\x00tags\x00" "asset_16791\x00tags\x00" "asset_16792\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_7779\0tags\0', 'class_8\0tags\0', 'asset_16789\0tags\0', 'asset_16790\0tags\0', 'asset_16791\0tags\0', 'asset_16792\0tags\0');
56	3.83 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "\x00tags\x00object_717013" "object_717013" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_717013', 'object_717013');
57	1.84 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "object_717013\x00tags\x00" "class_8\x00tags\x00" "asset_15241\x00tags\x00" "asset_15242\x00tags\x00" "asset_15243\x00tags\x00" "asset_15244\x00tags\x00" "asset_15245\x00tags\x00" "asset_15246\x00tags\x00" "asset_15247\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_717013\0tags\0', 'class_8\0tags\0', 'asset_15241\0tags\0', 'asset_15242\0tags\0', 'asset_15243\0tags\0', 'asset_15244\0tags\0', 'asset_15245\0tags\0', 'asset_15246\0tags\0', 'asset_15247\0tags\0');
58	2.95 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "\x00tags\x00object_800138" "object_800138" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_800138', 'object_800138');
59	0.29 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "object_800138\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_800138\0tags\0', 'class_8\0tags\0');
60	2.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: [`1793027210 [ "\x00tags\x00object_1432971" "object_1432971" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1432971', 'object_1432971');
61	1.10 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "object_1432971\x00tags\x00" "class_8\x00tags\x00" "asset_18532\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1432971\0tags\0', 'class_8\0tags\0', 'asset_18532\0tags\0');
62	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: [`1793027210 [ "\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_1', 'document_1');
63	0.49 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1\0tags\0');
64	2.45 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_3', 'object_3');
65	2.68 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_3\0tags\0', 'class_1\0tags\0');
66	8.69 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;;
67	1.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: [`1793027210 [ "\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0translation_data_2b0562963ad619f7386bc0e9856ed713', 'translation_data_2b0562963ad619f7386bc0e9856ed713');
68	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: [`1793027210 [ "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 > 1793027210 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');
69	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: [`1793027210 [ "\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_1', 'document_properties_1');
70	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: [`1793027210 [ "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 > 1793027210 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');
71	46.68 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 ;
72	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: [`1793027210 [ "\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_3117', 'object_3117');
73	2.65 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "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 > 1793027210 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');
74	1.99 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_3210', 'object_3210');
75	1.98 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "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 > 1793027210 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');
76	2.03 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0nav_5c4b242e936ff98d9730282bb67058e8', 'nav_5c4b242e936ff98d9730282bb67058e8');
77	1.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: [1793027210 [ "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 > 1793027210 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');
78	7.00 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 '%,1723554,%' 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 '%,1723554,%' 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 '%,1723554,%' GROUP BY TRIM(`parentCategoryIds`);
79	2.24 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: [`1723554`] 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 = 1723554 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;
80	19.37 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 '%,1723554,%') 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 '%,1723554,%' ) 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 '%,1723554,%') GROUP BY dest;
81	2.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: [`1793027210 [ "\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_932744', 'object_932744');
82	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: [`1793027210 [ "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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_932744\0tags\0', 'class_14\0tags\0');
83	0.23 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';
84	2.99 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_932742', 'object_932742');
85	1.18 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_932742\0tags\0', 'class_14\0tags\0');
86	0.93 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_932741', 'object_932741');
87	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: [`1793027210 [ "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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_932741\0tags\0');
88	3.30 ms	SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC Parameters: [`932741`] View formatted query View runnable query Explain query SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE ( o_parentId = ? AND objects.o_type IN ('object', 'folder') ) AND objects.o_published = 1 ORDER BY `o_key` ASC SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = 932741 AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC ;
89	0.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: [`1793027210 [ "\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_932743', 'object_932743');
90	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: [`1793027210 [ "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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_932743\0tags\0', 'class_14\0tags\0');
91	1.66 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027210 [ "\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_932746', 'object_932746');
92	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: [`1793027210 [ "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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_932746\0tags\0', 'class_14\0tags\0');
93	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: [`1793027210 [ "\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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_932745', 'object_932745');
94	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: [`1793027210 [ "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 > 1793027210 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_932745\0tags\0', 'class_14\0tags\0');
95	4.94 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '354' 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 = '354' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '354';
96	0.43 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1169' 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 = '1169' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1169';
97	0.39 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';
98	5.13 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;
99	1.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: [`1793027211 [ "\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 > 1793027211 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1454319', 'object_1454319');
100	2.04 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027211 [ "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 > 1793027211 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1454319\0tags\0', 'class_15\0tags\0');
101	0.38 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1176' 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 = '1176' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1176';
102	0.87 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;
103	0.52 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1180' 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 = '1180' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1180';
104	0.97 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1228' 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 = '1228' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1228';
105	0.32 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1306' 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 = '1306' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1306';
106	0.56 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;
107	0.56 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '6786' 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 = '6786' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '6786';
108	0.28 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '6787' 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 = '6787' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '6787';
109	0.29 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '7779' 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 = '7779' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '7779';
110	0.32 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '717013' 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 = '717013' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '717013';
111	0.56 ms	SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE ( `PapyrusId` = '0' AND object_15.o_type IN ('object', 'folder') ) AND object_15.o_published = 1 LIMIT 1 SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1;
112	0.30 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '800138' 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 = '800138' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '800138';
113	0.45 ms	SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE ( `PapyrusId` = '0' AND object_15.o_type IN ('object', 'folder') ) AND object_15.o_published = 1 LIMIT 1 SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1;
114	0.27 ms	SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1432971' 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 = '1432971' SELECT * FROM object_url_slugs WHERE fieldname = 'slug' AND ownertype = 'localizedfield' AND position = 'nl' AND objectId = '1432971';
115	0.56 ms	SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE ( `PapyrusId` = '0' AND object_15.o_type IN ('object', 'folder') ) AND object_15.o_published = 1 LIMIT 1 SELECT object_15.o_id as o_id, object_15.o_type as o_type FROM object_15 WHERE (`PapyrusId` = '0' AND object_15.o_type IN ('object','folder')) AND object_15.o_published = 1 LIMIT 1;
116	0.49 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027211 [ "\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 > 1793027211 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_11', 'document_11');
117	2.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: [`1793027211 [ "\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 > 1793027211 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0nav_de78686b5603782418c9dfa609d38233', 'nav_de78686b5603782418c9dfa609d38233');
118	1.63 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027211 [ "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 > 1793027211 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('output\0tags\0', 'navigation\0tags\0', 'document_46\0tags\0', 'document_47\0tags\0', 'document_14\0tags\0', 'document_13\0tags\0', 'document_12\0tags\0', 'nav_de78686b5603782418c9dfa609d38233\0tags\0');
119	2.83 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027211 [ "\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 > 1793027211 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_8', 'document_8');
120	2.82 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027211 [ "document_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 > 1793027211 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_8\0tags\0');
121	1.01 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027211 [ "\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 > 1793027211 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0nav_fb4388bafeb6a3b0411e289b0db7d628', 'nav_fb4388bafeb6a3b0411e289b0db7d628');
122	0.80 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027211 [ "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 > 1793027211 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');
123	0.57 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027211 [ "\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 > 1793027211 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_10', 'document_10');
124	0.65 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';
125	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: [`1793027211 [ "\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 > 1793027211 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_51', 'document_51');
126	3.09 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027211 [ "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 > 1793027211 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_51\0tags\0', 'asset_18538\0tags\0');
127	5.54 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;
128	1.65 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027211 [ "\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 > 1793027211 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_51', 'document_properties_51');
129	1.00 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027211 [ "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 > 1793027211 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');
130	1.13 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027211 [ "\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 > 1793027211 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_18538', 'asset_18538');
131	4.34 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;
132	1.16 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1793027211 [ "\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 > 1793027211 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0imagick_format_webp', 'imagick_format_webp');
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: [`1793027211 [ "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 > 1793027211 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('imagick_format_webp\0tags\0');

papyrus connection

No database queries were performed.

Database Connections

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

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
FormBuilderBundle\Model\FormDefinition	No errors.

Symfony Profiler

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

Configuration Settings

Theme

Page Width

Query Metrics

Queries

default connection

papyrus connection

Database Connections

Entity Managers

Second Level Cache

Entities Mapping