Symfony Profiler

Query Metrics

164 Database Queries

24 Different statements

20.25 ms Query time

0 Invalid entities

Queries


SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite 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 tmp_store WHERE id = ?
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) 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 object_url_slugs WHERE slug = '/' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM assets_image_thumbnail_cache WHERE 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 (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?)
SELECT * FROM documents_editables WHERE documentId = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
SELECT sourceId FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT sourceId FROM documents_translations WHERE id = ?
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
SELECT id FROM documents_page WHERE prettyUrl = ?
SELECT * FROM translations_admin 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 tmp_store WHERE id = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT * FROM tmp_store WHERE id = ?
SELECT 1 FROM objects o WHERE parentId = ?  AND published = 1 AND `type` IN ('object','variant','folder') LIMIT 1
SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = ? AND  objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `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 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 * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT object_localized_2_de.id as id, object_localized_2_de.type as `type` FROM object_localized_2_de WHERE (parentId = ? AND  object_localized_2_de.type IN ('object','variant','folder')) AND object_localized_2_de.published = 1 ORDER BY `sortOrder` 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 item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE 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_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM assets_image_thumbnail_cache WHERE 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 (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
SELECT * FROM settings_store WHERE id = ? AND scope = ?
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
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 (?, ?)

#▲	Time	Info
1	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: [`1762159270 "\x01tags\x01site_domain_f921062dd5382c1bb0719fb02ba12b07" "site_domain_f921062dd5382c1bb0719fb02ba12b07"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagssite_domain_f921062dd5382c1bb0719fb02ba12b07', 'site_domain_f921062dd5382c1bb0719fb02ba12b07');
2	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "system\x01tags\x01" "site\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
3	0.14 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
4	0.25 ms	SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/" "path" "auto_create" "/" "path_query" "https://www.room-living.de/" "entire_uri"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = ? AND ( `type` = ? OR `type` = ? ) ) OR ( source = ? AND `type` = ? ) OR ( source = ? AND `type` = ? ) ) AND active = 1 AND ( regex IS NULL OR regex = 0 ) AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/' AND `type` = 'path_query') OR (source = 'https://www.room-living.de/' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;
5	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01system_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 > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagssystem_route_redirect', 'system_route_redirect');
6	0.12 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) Parameters: [`1762159270 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'redirecttags', 'routetags');
7	0.12 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"maintenance_mode"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'maintenance_mode';
8	0.10 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"reports" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';
9	0.12 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" ""`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY '';
10	0.12 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01document_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 > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsdocument_1', 'document_1');
11	0.12 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "document_1\x01tags\x01" "asset_81\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1tags', 'asset_81tags');
12	0.12 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01sites_path_mapping" "sites_path_mapping"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagssites_path_mapping', 'sites_path_mapping');
13	0.14 ms	SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC Parameters: [] View formatted query View runnable query Explain query SELECT id FROM sites ORDER BY ( SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId ) DESC SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC ;
14	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01document_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 > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsdocument_properties_1', 'document_properties_1');
15	0.12 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "document_properties\x01tags\x01" "document_1\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_propertiestags', 'document_1tags');
16	0.12 ms	SELECT * FROM object_url_slugs WHERE slug = '/' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE slug = '/' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
17	0.13 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01asset_78" "asset_78"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_78', 'asset_78');
18	0.10 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1762159270 "asset_78\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_78tags');
19	0.15 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`78`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 78;
20	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01document_13" "document_13"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsdocument_13', 'document_13');
21	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1762159270 "document_13\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_13tags');
22	0.12 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01website_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 > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagswebsite_config', 'website_config');
23	0.14 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?) Parameters: [`1762159270 "website_config\x01tags\x01" "system\x01tags\x01" "config\x01tags\x01" "output\x01tags\x01" "asset_76\x01tags\x01" "object_33\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('website_configtags', 'systemtags', 'configtags', 'outputtags', 'asset_76tags', 'object_33tags');
24	0.30 ms	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 1;
25	0.12 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01object_54" "object_54"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_54', 'object_54');
26	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1762159270 "object_54\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_54tags');
27	0.12 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01object_14" "object_14"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_14', 'object_14');
28	0.10 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1762159270 "object_14\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_14tags');
29	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01object_42" "object_42"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_42', 'object_42');
30	0.10 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1762159270 "object_42\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_42tags');
31	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01asset_63" "asset_63"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_63', 'asset_63');
32	0.10 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1762159270 "asset_63\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_63tags');
33	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01asset_65" "asset_65"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_65', 'asset_65');
34	0.10 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1762159270 "asset_65\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_65tags');
35	0.13 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01nav_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 > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsnav_5c4b242e936ff98d9730282bb67058e8', 'nav_5c4b242e936ff98d9730282bb67058e8');
36	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: [`1762159270 "output\x01tags\x01" "navigation\x01tags\x01" "document_9\x01tags\x01" "document_18\x01tags\x01" "document_10\x01tags\x01" "document_11\x01tags\x01" "document_19\x01tags\x01" "document_12\x01tags\x01" "document_22\x01tags\x01" "document_2\x01tags\x01" "document_3\x01tags\x01" "document_20\x01tags\x01" "document_4\x01tags\x01" "document_6\x01tags\x01" "document_14\x01tags\x01" "document_15\x01tags\x01" "document_21\x01tags\x01" "document_13\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('outputtags', 'navigationtags', 'document_9tags', 'document_18tags', 'document_10tags', 'document_11tags', 'document_19tags', 'document_12tags', 'document_22tags', 'document_2tags', 'document_3tags', 'document_20tags', 'document_4tags', 'document_6tags', 'document_14tags', 'document_15tags', 'document_21tags', 'document_13tags');
37	0.11 ms	SELECT sourceId FROM documents_translations WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT sourceId FROM documents_translations WHERE id = ? SELECT sourceId FROM documents_translations WHERE id = 1;
38	0.16 ms	SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`1 1 1`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId IN(1, 1) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 1;
39	0.12 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "en"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY 'en';
40	0.12 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/en"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/en';
41	0.09 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "de"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY 'de';
42	0.09 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/de"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/de';
43	0.09 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "fr"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY 'fr';
44	0.09 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/fr"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/fr';
45	0.16 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`76`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 76;
46	0.11 ms	SELECT sourceId FROM documents_translations WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT sourceId FROM documents_translations WHERE id = ? SELECT sourceId FROM documents_translations WHERE id = 1;
47	0.16 ms	SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`1 1 1`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId IN(1, 1) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 1;
48	0.09 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "en"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY 'en';
49	0.09 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/en"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/en';
50	0.08 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "de"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY 'de';
51	0.09 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/de"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/de';
52	0.09 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "fr"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/' AND `key` = BINARY 'fr';
53	0.09 ms	SELECT id FROM documents_page WHERE prettyUrl = ? Parameters: [`"/fr"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = ? SELECT id FROM documents_page WHERE prettyUrl = '/fr';
54	0.10 ms	SELECT * FROM translations_admin LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_admin LIMIT 1; SELECT * FROM translations_admin LIMIT 1;;
55	0.14 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01translation_data_97d20181b29e38ccdfcc2249cc63ac4a" "translation_data_97d20181b29e38ccdfcc2249cc63ac4a"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagstranslation_data_97d20181b29e38ccdfcc2249cc63ac4a', 'translation_data_97d20181b29e38ccdfcc2249cc63ac4a');
56	0.13 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) Parameters: [`1762159270 "translator\x01tags\x01" "translator_website\x01tags\x01" "translate\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('translatortags', 'translator_websitetags', 'translatetags');
57	0.12 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_78__d296f191b207b90dc571830e51033922"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_78__d296f191b207b90dc571830e51033922';
58	0.11 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_78__ab0e25aa1c3daa90772bd1382a3e9d30"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_78__ab0e25aa1c3daa90772bd1382a3e9d30';
59	0.10 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_78__98811f1aa9f1092b3fc1e4a70c0f4589"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_78__98811f1aa9f1092b3fc1e4a70c0f4589';
60	0.10 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_78__2cc150b8f1f8c8d913479080aa8811b5"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_78__2cc150b8f1f8c8d913479080aa8811b5';
61	0.09 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_78__fed8cada97e3b9f9f8d4311d6d9efc9b"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_78__fed8cada97e3b9f9f8d4311d6d9efc9b';
62	0.09 ms	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_78__31b99b6f39a6f324add79c3f11c61b95"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_78__31b99b6f39a6f324add79c3f11c61b95';
63	0.16 ms	SELECT 1 FROM objects o WHERE parentId = ? AND published = 1 AND `type` IN ('object','variant','folder') LIMIT 1 Parameters: [`54`] View formatted query View runnable query Explain query SELECT 1 FROM objects o WHERE parentId = ? AND published = 1 AND `type` IN ('object', 'variant', 'folder') LIMIT 1 SELECT 1 FROM objects o WHERE parentId = 54 AND published = 1 AND `type` IN ('object','variant','folder') LIMIT 1;
64	0.18 ms	SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = ? AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC Parameters: [`54`] View formatted query View runnable query Explain query SELECT objects.id as id, objects.type as `type` FROM objects WHERE ( parentId = ? AND objects.type IN ('object', 'variant', 'folder') ) AND objects.published = 1 ORDER BY `key` ASC SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = 54 AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC ;
65	0.12 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01object_56" "object_56"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_56', 'object_56');
66	0.09 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"2"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '2';
67	0.13 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "object_56\x01tags\x01" "class_2\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_56tags', 'class_2tags');
68	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01object_57" "object_57"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_57', 'object_57');
69	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "object_57\x01tags\x01" "class_2\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_57tags', 'class_2tags');
70	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01object_58" "object_58"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_58', 'object_58');
71	0.13 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "object_58\x01tags\x01" "class_2\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_58tags', 'class_2tags');
72	0.13 ms	SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`57 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemImage_2 WHERE id = 57 AND fieldname = 'asset' ORDER BY `index` ASC;
73	0.14 ms	SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`57 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = 57 AND fieldname = 'asset' ORDER BY `index` ASC;
74	0.12 ms	SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`57 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = 57 AND fieldname = 'asset' ORDER BY `index` ASC;
75	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01asset_81" "asset_81"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_81', 'asset_81');
76	0.12 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`81`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 81;
77	0.46 ms	SELECT object_localized_2_de.id as id, object_localized_2_de.type as `type` FROM object_localized_2_de WHERE (parentId = ? AND object_localized_2_de.type IN ('object','variant','folder')) AND object_localized_2_de.published = 1 ORDER BY `sortOrder` DESC Parameters: [`42`] View formatted query View runnable query Explain query SELECT object_localized_2_de.id as id, object_localized_2_de.type as `type` FROM object_localized_2_de WHERE ( parentId = ? AND object_localized_2_de.type IN ('object', 'variant', 'folder') ) AND object_localized_2_de.published = 1 ORDER BY `sortOrder` DESC SELECT object_localized_2_de.id as id, object_localized_2_de.type as `type` FROM object_localized_2_de WHERE (parentId = 42 AND object_localized_2_de.type IN ('object','variant','folder')) AND object_localized_2_de.published = 1 ORDER BY `sortOrder` DESC ;
78	0.13 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01object_60" "object_60"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_60', 'object_60');
79	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "object_60\x01tags\x01" "class_2\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_60tags', 'class_2tags');
80	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01object_51" "object_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 > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_51', 'object_51');
81	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "object_51\x01tags\x01" "class_2\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_51tags', 'class_2tags');
82	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01object_52" "object_52"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_52', 'object_52');
83	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "object_52\x01tags\x01" "class_2\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_52tags', 'class_2tags');
84	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01object_53" "object_53"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_53', 'object_53');
85	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "object_53\x01tags\x01" "class_2\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_53tags', 'class_2tags');
86	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01object_50" "object_50"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_50', 'object_50');
87	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "object_50\x01tags\x01" "class_2\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_50tags', 'class_2tags');
88	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01object_49" "object_49"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_49', 'object_49');
89	0.12 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "object_49\x01tags\x01" "class_2\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_49tags', 'class_2tags');
90	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01object_48" "object_48"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_48', 'object_48');
91	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "object_48\x01tags\x01" "class_2\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_48tags', 'class_2tags');
92	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01object_46" "object_46"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_46', 'object_46');
93	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "object_46\x01tags\x01" "class_2\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_46tags', 'class_2tags');
94	0.12 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01object_45" "object_45"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_45', 'object_45');
95	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "object_45\x01tags\x01" "class_2\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_45tags', 'class_2tags');
96	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01object_47" "object_47"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsobject_47', 'object_47');
97	0.14 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "object_47\x01tags\x01" "class_2\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_47tags', 'class_2tags');
98	0.16 ms	SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`60 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemImage_2 WHERE id = 60 AND fieldname = 'asset' ORDER BY `index` ASC;
99	0.12 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01asset_82" "asset_82"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_82', 'asset_82');
100	0.10 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1762159270 "asset_82\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_82tags');
101	0.11 ms	SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`60 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = 60 AND fieldname = 'asset' ORDER BY `index` ASC;
102	0.11 ms	SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`60 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = 60 AND fieldname = 'asset' ORDER BY `index` ASC;
103	0.11 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`82`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 82;
104	0.12 ms	SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`51 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemImage_2 WHERE id = 51 AND fieldname = 'asset' ORDER BY `index` ASC;
105	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01asset_54" "asset_54"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_54', 'asset_54');
106	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1762159270 "asset_54\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_54tags');
107	0.10 ms	SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`51 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = 51 AND fieldname = 'asset' ORDER BY `index` ASC;
108	0.09 ms	SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`51 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = 51 AND fieldname = 'asset' ORDER BY `index` ASC;
109	0.14 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`54`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 54;
110	0.15 ms	SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`52 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemImage_2 WHERE id = 52 AND fieldname = 'asset' ORDER BY `index` ASC;
111	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01asset_60" "asset_60"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_60', 'asset_60');
112	0.08 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1762159270 "asset_60\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_60tags');
113	0.10 ms	SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`52 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = 52 AND fieldname = 'asset' ORDER BY `index` ASC;
114	0.09 ms	SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`52 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = 52 AND fieldname = 'asset' ORDER BY `index` ASC;
115	0.13 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`60`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 60;
116	0.15 ms	SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`53 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemImage_2 WHERE id = 53 AND fieldname = 'asset' ORDER BY `index` ASC;
117	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01asset_52" "asset_52"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_52', 'asset_52');
118	0.09 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1762159270 "asset_52\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_52tags');
119	0.10 ms	SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`53 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = 53 AND fieldname = 'asset' ORDER BY `index` ASC;
120	0.09 ms	SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`53 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = 53 AND fieldname = 'asset' ORDER BY `index` ASC;
121	0.13 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`52`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 52;
122	0.12 ms	SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`50 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemImage_2 WHERE id = 50 AND fieldname = 'asset' ORDER BY `index` ASC;
123	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01asset_55" "asset_55"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_55', 'asset_55');
124	0.09 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1762159270 "asset_55\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_55tags');
125	0.10 ms	SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`50 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = 50 AND fieldname = 'asset' ORDER BY `index` ASC;
126	0.09 ms	SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`50 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = 50 AND fieldname = 'asset' ORDER BY `index` ASC;
127	0.12 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`55`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 55;
128	0.13 ms	SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`49 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemImage_2 WHERE id = 49 AND fieldname = 'asset' ORDER BY `index` ASC;
129	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01asset_59" "asset_59"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_59', 'asset_59');
130	0.09 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1762159270 "asset_59\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_59tags');
131	0.11 ms	SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`49 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = 49 AND fieldname = 'asset' ORDER BY `index` ASC;
132	0.10 ms	SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`49 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = 49 AND fieldname = 'asset' ORDER BY `index` ASC;
133	0.13 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`59`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 59;
134	0.12 ms	SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`48 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemImage_2 WHERE id = 48 AND fieldname = 'asset' ORDER BY `index` ASC;
135	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01asset_61" "asset_61"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_61', 'asset_61');
136	0.09 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1762159270 "asset_61\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_61tags');
137	0.10 ms	SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`48 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = 48 AND fieldname = 'asset' ORDER BY `index` ASC;
138	0.09 ms	SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`48 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = 48 AND fieldname = 'asset' ORDER BY `index` ASC;
139	0.13 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`61`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 61;
140	0.12 ms	SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`46 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemImage_2 WHERE id = 46 AND fieldname = 'asset' ORDER BY `index` ASC;
141	0.10 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01asset_56" "asset_56"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_56', 'asset_56');
142	0.09 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1762159270 "asset_56\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_56tags');
143	0.10 ms	SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`46 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = 46 AND fieldname = 'asset' ORDER BY `index` ASC;
144	0.09 ms	SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`46 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = 46 AND fieldname = 'asset' ORDER BY `index` ASC;
145	0.13 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`56`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 56;
146	0.12 ms	SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`45 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemImage_2 WHERE id = 45 AND fieldname = 'asset' ORDER BY `index` ASC;
147	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01asset_57" "asset_57"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_57', 'asset_57');
148	0.09 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1762159270 "asset_57\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_57tags');
149	0.11 ms	SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`45 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = 45 AND fieldname = 'asset' ORDER BY `index` ASC;
150	0.09 ms	SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`45 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = 45 AND fieldname = 'asset' ORDER BY `index` ASC;
151	0.13 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`57`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 57;
152	0.13 ms	SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`47 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemImage_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemImage_2 WHERE id = 47 AND fieldname = 'asset' ORDER BY `index` ASC;
153	0.14 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01asset_53" "asset_53"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsasset_53', 'asset_53');
154	0.11 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1762159270 "asset_53\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_53tags');
155	0.11 ms	SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`47 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemVideo_2 WHERE id = 47 AND fieldname = 'asset' ORDER BY `index` ASC;
156	0.09 ms	SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`47 "asset"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_AssetItemDocument_2 WHERE id = 47 AND fieldname = 'asset' ORDER BY `index` ASC;
157	0.13 ms	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`53`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 53;
158	0.35 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01document_5" "document_5"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsdocument_5', 'document_5');
159	0.13 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1762159270 "document_5\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_5tags');
160	0.13 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01document_properties_5" "document_properties_5"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsdocument_properties_5', 'document_properties_5');
161	0.13 ms	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
162	0.28 ms	SELECT * FROM redirects WHERE ( (source = ? AND (`type` = ? OR `type` = ?)) OR (source = ? AND `type` = ?) OR (source = ? AND `type` = ?) ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC Parameters: [`"/_fragment" "path" "auto_create" "/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CSnippetController%3A%3AfooterAction" "path_query" "https://www.room-living.de/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CSnippetController%3A%3AfooterAction" "entire_uri"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = ? AND ( `type` = ? OR `type` = ? ) ) OR ( source = ? AND `type` = ? ) OR ( source = ? AND `type` = ? ) ) AND active = 1 AND ( regex IS NULL OR regex = 0 ) AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/_fragment' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CSnippetController%3A%3AfooterAction' AND `type` = 'path_query') OR (source = 'https://www.room-living.de/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CSnippetController%3A%3AfooterAction' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;
163	0.15 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"3"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '3';
164	0.15 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1762159270 "\x01tags\x01nav_9016a518fcf0e57e54c352f483ebd2af" "nav_9016a518fcf0e57e54c352f483ebd2af"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1762159270 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('tagsnav_9016a518fcf0e57e54c352f483ebd2af', 'nav_9016a518fcf0e57e54c352f483ebd2af');

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

There are no configured entity managers.

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

No mapped entities.

Symfony Profiler

GET https://www.room-living.de/_fragment?_path=_locale%3Dde%26_format%3Dhtml%26_controller%3DApp%255CController%255CSnippetController%253A%253AfooterAction

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping