Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

93 Database Queries

18 Different statements

16.28 ms Query time

0 Invalid entities

Queries

Group similar statements


SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM redirects WHERE
            (
                (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR
                (source = :sourcePathQuery AND `type` = :typePathQuery) OR
                (source = :sourceEntireUri AND `type` = :typeEntireUri)
            ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE 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 = '/aktualitasok' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
SELECT id FROM settings_store WHERE scope = ?
SELECT t0.name AS name_1, t0.template AS template_2, t0.isDefault AS isDefault_3, t0.siteId AS siteId_4, t0.creationDate AS creationDate_5, t0.modificationDate AS modificationDate_6, t0.id AS id_7, t0.useGrossPrice AS useGrossPrice_8, t0.currencyId AS currencyId_9, t10.configKey AS configKey_11, t10.data AS data_12, t10.creationDate AS creationDate_13, t10.modificationDate AS modificationDate_14, t10.id AS id_15, t10.store_id AS store_id_16, t0.baseCountryId AS baseCountryId_17, t18.isoCode AS isoCode_19, t18.active AS active_20, t18.addressFormat AS addressFormat_21, t18.salutations AS salutations_22, t18.creationDate AS creationDate_23, t18.modificationDate AS modificationDate_24, t18.id AS id_25, t18.zoneId AS zoneId_26, t18.currencyId AS currencyId_27 FROM coreshop_store t0 LEFT JOIN coreshop_configuration t10 ON t10.store_id = t0.id LEFT JOIN coreshop_country t18 ON t0.baseCountryId = t18.id WHERE t0.id = ?
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 id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
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 item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE 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 object_4.o_id as o_id, object_4.o_type as o_type FROM object_4 WHERE (`site` = 'boutique'  AND  object_4.o_type IN ('object','folder')) AND object_4.o_published = 1
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT object_3.o_id as o_id, object_3.o_type as o_type FROM object_3 WHERE (hiddenFromList IS NOT TRUE AND (category__id IN (0,375317,375322,723650,723676))  AND  object_3.o_type IN ('object','folder')) AND object_3.o_published = 1 ORDER BY `highlighted` DESC, `date` DESC   LIMIT 15
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT COUNT(*) FROM object_3 WHERE (hiddenFromList IS NOT TRUE AND (category__id IN (0,375317,375322,723650,723676))  AND  object_3.o_type IN ('object','folder')) AND object_3.o_published = 1
SELECT id FROM tags WHERE ISNULL(parentId) OR parentId = 0  ORDER BY `name`
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT * FROM tags WHERE id = ?
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT id FROM settings_store WHERE scope = ?
SELECT t0.name AS name_1, t0.template AS template_2, t0.isDefault AS isDefault_3, t0.siteId AS siteId_4, t0.creationDate AS creationDate_5, t0.modificationDate AS modificationDate_6, t0.id AS id_7, t0.useGrossPrice AS useGrossPrice_8, t0.currencyId AS currencyId_9, t10.configKey AS configKey_11, t10.data AS data_12, t10.creationDate AS creationDate_13, t10.modificationDate AS modificationDate_14, t10.id AS id_15, t10.store_id AS store_id_16, t0.baseCountryId AS baseCountryId_17, t18.isoCode AS isoCode_19, t18.active AS active_20, t18.addressFormat AS addressFormat_21, t18.salutations AS salutations_22, t18.creationDate AS creationDate_23, t18.modificationDate AS modificationDate_24, t18.id AS id_25, t18.zoneId AS zoneId_26, t18.currencyId AS currencyId_27 FROM coreshop_store t0 LEFT JOIN coreshop_configuration t10 ON t10.store_id = t0.id LEFT JOIN coreshop_country t18 ON t0.baseCountryId = t18.id
SELECT DISTINCT c0_.isoCode AS isoCode_0, c0_.name AS name_1, c0_.numericIsoCode AS numericIsoCode_2, c0_.symbol AS symbol_3, c0_.creationDate AS creationDate_4, c0_.modificationDate AS modificationDate_5, c0_.id AS id_6 FROM coreshop_currency c0_ LEFT JOIN coreshop_country c1_ ON c0_.id = c1_.currencyId INNER JOIN coreshop_store_countries c3_ ON c1_.id = c3_.country_id INNER JOIN coreshop_store c2_ ON c2_.id = c3_.store_id WHERE c1_.active = 1 AND c2_.id = ?
SELECT t0.name AS name_1, t0.creationDate AS creationDate_2, t0.modificationDate AS modificationDate_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM coreshop_country_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1

#▲	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: [`1769206502 [ "\x00tags\x00site_domain_30b361376c41bdfc6ac22d9a0797cc4b" "site_domain_30b361376c41bdfc6ac22d9a0797cc4b" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_domain_30b361376c41bdfc6ac22d9a0797cc4b', 'site_domain_30b361376c41bdfc6ac22d9a0797cc4b');
2	0.21 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1769206502 [ "system\x00tags\x00" "site\x00tags\x00" "site_domain_30b361376c41bdfc6ac22d9a0797cc4b\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'site\0tags\0', 'site_domain_30b361376c41bdfc6ac22d9a0797cc4b\0tags\0');
3	0.27 ms	SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC Parameters: [`"sourcePath" => "/aktualitasok" "sourcePathQuery" => "/aktualitasok" "sourceEntireUri" => "https://boutique.local.szerver.online/aktualitasok" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = :sourcePath AND ( `type` = :typePath OR `type` = :typeAuto ) ) OR ( source = :sourcePathQuery AND `type` = :typePathQuery ) OR ( source = :sourceEntireUri AND `type` = :typeEntireUri ) ) AND active = 1 AND regex IS NULL AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/aktualitasok' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/aktualitasok' AND `type` = 'path_query') OR (source = 'https://boutique.local.szerver.online/aktualitasok' AND `type` = 'entire_uri') ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC;
4	0.20 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1769206502 [ "\x00tags\x00system_route_redirect" "system_route_redirect" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_route_redirect', 'system_route_redirect');
5	0.23 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1769206502 [ "system\x00tags\x00" "redirect\x00tags\x00" "route\x00tags\x00" "system_route_redirect\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'redirect\0tags\0', 'route\0tags\0', 'system_route_redirect\0tags\0');
6	0.17 ms	SELECT * FROM settings_store WHERE id = :id AND scope = :scope Parameters: [`"id" => "reports" "scope" => "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = :id AND scope = :scope SELECT * FROM settings_store WHERE id = 'reports' AND scope = 'pimcore';
7	0.25 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "aktualitasok" "path" => "/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/' AND `key` = BINARY 'aktualitasok';
8	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: [`1769206502 [ "\x00tags\x00document_12" "document_12" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_12', 'document_12');
9	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: [`1769206502 [ "document_12\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_12\0tags\0');
10	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: [`1769206502 [ "\x00tags\x00document_properties_12" "document_properties_12" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_12', 'document_properties_12');
11	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: [`1769206502 [ "document_properties\x00tags\x00" "document_12\x00tags\x00" "document_properties_12\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0', 'document_12\0tags\0', 'document_properties_12\0tags\0');
12	0.18 ms	SELECT * FROM object_url_slugs WHERE slug = '/aktualitasok' 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 = '/aktualitasok' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/aktualitasok' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
13	0.19 ms	SELECT id FROM settings_store WHERE scope = ? Parameters: [`"pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT id FROM settings_store WHERE scope = ? SELECT id FROM settings_store WHERE scope = 'pimcore_staticroutes';
14	0.33 ms	SELECT t0.name AS name_1, t0.template AS template_2, t0.isDefault AS isDefault_3, t0.siteId AS siteId_4, t0.creationDate AS creationDate_5, t0.modificationDate AS modificationDate_6, t0.id AS id_7, t0.useGrossPrice AS useGrossPrice_8, t0.currencyId AS currencyId_9, t10.configKey AS configKey_11, t10.data AS data_12, t10.creationDate AS creationDate_13, t10.modificationDate AS modificationDate_14, t10.id AS id_15, t10.store_id AS store_id_16, t0.baseCountryId AS baseCountryId_17, t18.isoCode AS isoCode_19, t18.active AS active_20, t18.addressFormat AS addressFormat_21, t18.salutations AS salutations_22, t18.creationDate AS creationDate_23, t18.modificationDate AS modificationDate_24, t18.id AS id_25, t18.zoneId AS zoneId_26, t18.currencyId AS currencyId_27 FROM coreshop_store t0 LEFT JOIN coreshop_configuration t10 ON t10.store_id = t0.id LEFT JOIN coreshop_country t18 ON t0.baseCountryId = t18.id WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.template AS template_2, t0.isDefault AS isDefault_3, t0.siteId AS siteId_4, t0.creationDate AS creationDate_5, t0.modificationDate AS modificationDate_6, t0.id AS id_7, t0.useGrossPrice AS useGrossPrice_8, t0.currencyId AS currencyId_9, t10.configKey AS configKey_11, t10.data AS data_12, t10.creationDate AS creationDate_13, t10.modificationDate AS modificationDate_14, t10.id AS id_15, t10.store_id AS store_id_16, t0.baseCountryId AS baseCountryId_17, t18.isoCode AS isoCode_19, t18.active AS active_20, t18.addressFormat AS addressFormat_21, t18.salutations AS salutations_22, t18.creationDate AS creationDate_23, t18.modificationDate AS modificationDate_24, t18.id AS id_25, t18.zoneId AS zoneId_26, t18.currencyId AS currencyId_27 FROM coreshop_store t0 LEFT JOIN coreshop_configuration t10 ON t10.store_id = t0.id LEFT JOIN coreshop_country t18 ON t0.baseCountryId = t18.id WHERE t0.id = ? SELECT t0.name AS name_1, t0.template AS template_2, t0.isDefault AS isDefault_3, t0.siteId AS siteId_4, t0.creationDate AS creationDate_5, t0.modificationDate AS modificationDate_6, t0.id AS id_7, t0.useGrossPrice AS useGrossPrice_8, t0.currencyId AS currencyId_9, t10.configKey AS configKey_11, t10.data AS data_12, t10.creationDate AS creationDate_13, t10.modificationDate AS modificationDate_14, t10.id AS id_15, t10.store_id AS store_id_16, t0.baseCountryId AS baseCountryId_17, t18.isoCode AS isoCode_19, t18.active AS active_20, t18.addressFormat AS addressFormat_21, t18.salutations AS salutations_22, t18.creationDate AS creationDate_23, t18.modificationDate AS modificationDate_24, t18.id AS id_25, t18.zoneId AS zoneId_26, t18.currencyId AS currencyId_27 FROM coreshop_store t0 LEFT JOIN coreshop_configuration t10 ON t10.store_id = t0.id LEFT JOIN coreshop_country t18 ON t0.baseCountryId = t18.id WHERE t0.id = 1;
15	0.27 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"cs_order"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'cs_order';
16	0.26 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1769206502 [ "\x00tags\x00system_supported_locales_hu" "system_supported_locales_hu" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_supported_locales_hu', 'system_supported_locales_hu');
17	0.18 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1769206502 [ "system\x00tags\x00" "system_supported_locales_hu\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'system_supported_locales_hu\0tags\0');
18	0.19 ms	SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;
19	0.18 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 ;
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: [`1769206502 [ "\x00tags\x00site_id_1" "site_id_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 > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_id_1', 'site_id_1');
21	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: [`1769206502 [ "system\x00tags\x00" "site\x00tags\x00" "site_id_1\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'site\0tags\0', 'site_id_1\0tags\0');
22	0.22 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1769206502 [ "\x00tags\x00site_id_2" "site_id_2" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_id_2', 'site_id_2');
23	0.18 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1769206502 [ "system\x00tags\x00" "site\x00tags\x00" "site_id_2\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'site\0tags\0', 'site_id_2\0tags\0');
24	0.33 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1769206502 [ "\x00tags\x00document_1" "document_1" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_1', 'document_1');
25	0.25 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [1769206502 [ "document_1\x00tags\x00" "asset_23694\x00tags\x00" "asset_23875\x00tags\x00" "asset_23880\x00tags\x00" "asset_23876\x00tags\x00" "asset_23879\x00tags\x00" "asset_23877\x00tags\x00" "asset_23886\x00tags\x00" "asset_15451\x00tags\x00" "asset_23884\x00tags\x00" "asset_15452\x00tags\x00" "asset_23899\x00tags\x00" "asset_15462\x00tags\x00" "asset_23890\x00tags\x00" "asset_15463\x00tags\x00" "asset_23895\x00tags\x00" "asset_15464\x00tags\x00" "asset_23888\x00tags\x00" "asset_15544\x00tags\x00" ]] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1\0tags\0', 'asset_23694\0tags\0', 'asset_23875\0tags\0', 'asset_23880\0tags\0', 'asset_23876\0tags\0', 'asset_23879\0tags\0', 'asset_23877\0tags\0', 'asset_23886\0tags\0', 'asset_15451\0tags\0', 'asset_23884\0tags\0', 'asset_15452\0tags\0', 'asset_23899\0tags\0', 'asset_15462\0tags\0', 'asset_23890\0tags\0', 'asset_15463\0tags\0', 'asset_23895\0tags\0', 'asset_15464\0tags\0', 'asset_23888\0tags\0', 'asset_15544\0tags\0');
26	0.17 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"4"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = '4';
27	0.40 ms	SELECT object_4.o_id as o_id, object_4.o_type as o_type FROM object_4 WHERE (`site` = 'boutique' AND object_4.o_type IN ('object','folder')) AND object_4.o_published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_4.o_id as o_id, object_4.o_type as o_type FROM object_4 WHERE ( `site` = 'boutique' AND object_4.o_type IN ('object', 'folder') ) AND object_4.o_published = 1 SELECT object_4.o_id as o_id, object_4.o_type as o_type FROM object_4 WHERE (`site` = 'boutique' AND object_4.o_type IN ('object','folder')) AND object_4.o_published = 1;
28	0.20 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1769206502 [ "\x00tags\x00object_375317" "object_375317" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_375317', 'object_375317');
29	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: [`1769206502 [ "object_375317\x00tags\x00" "class_4\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375317\0tags\0', 'class_4\0tags\0');
30	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: [`1769206502 [ "\x00tags\x00object_375322" "object_375322" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_375322', 'object_375322');
31	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: [`1769206502 [ "object_375322\x00tags\x00" "class_4\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375322\0tags\0', 'class_4\0tags\0');
32	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: [`1769206502 [ "\x00tags\x00object_723650" "object_723650" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_723650', 'object_723650');
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: [`1769206502 [ "object_723650\x00tags\x00" "class_4\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_723650\0tags\0', 'class_4\0tags\0');
34	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: [`1769206502 [ "\x00tags\x00object_723676" "object_723676" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_723676', 'object_723676');
35	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: [`1769206502 [ "object_723676\x00tags\x00" "class_4\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_723676\0tags\0', 'class_4\0tags\0');
36	0.73 ms	SELECT object_3.o_id as o_id, object_3.o_type as o_type FROM object_3 WHERE (hiddenFromList IS NOT TRUE AND (category__id IN (0,375317,375322,723650,723676)) AND object_3.o_type IN ('object','folder')) AND object_3.o_published = 1 ORDER BY `highlighted` DESC, `date` DESC LIMIT 15 Parameters: [] View formatted query View runnable query Explain query SELECT object_3.o_id as o_id, object_3.o_type as o_type FROM object_3 WHERE ( hiddenFromList IS NOT TRUE AND ( category__id IN (0, 375317, 375322, 723650, 723676) ) AND object_3.o_type IN ('object', 'folder') ) AND object_3.o_published = 1 ORDER BY `highlighted` DESC, `date` DESC LIMIT 15 SELECT object_3.o_id as o_id, object_3.o_type as o_type FROM object_3 WHERE (hiddenFromList IS NOT TRUE AND (category__id IN (0,375317,375322,723650,723676)) AND object_3.o_type IN ('object','folder')) AND object_3.o_published = 1 ORDER BY `highlighted` DESC, `date` DESC LIMIT 15;
37	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: [`1769206502 [ "\x00tags\x00object_740571" "object_740571" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_740571', 'object_740571');
38	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: [`1769206502 [ "object_740571\x00tags\x00" "class_3\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_740571\0tags\0', 'class_3\0tags\0');
39	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: [`1769206502 [ "\x00tags\x00object_740276" "object_740276" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_740276', 'object_740276');
40	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: [`1769206502 [ "object_740276\x00tags\x00" "class_3\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_740276\0tags\0', 'class_3\0tags\0');
41	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: [`1769206502 [ "\x00tags\x00object_740278" "object_740278" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_740278', 'object_740278');
42	0.10 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1769206502 [ "object_740278\x00tags\x00" "class_3\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_740278\0tags\0', 'class_3\0tags\0');
43	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: [`1769206502 [ "\x00tags\x00object_739227" "object_739227" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_739227', 'object_739227');
44	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: [`1769206502 [ "object_739227\x00tags\x00" "class_3\x00tags\x00" "asset_27829\x00tags\x00" "asset_27830\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_739227\0tags\0', 'class_3\0tags\0', 'asset_27829\0tags\0', 'asset_27830\0tags\0');
45	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: [`1769206502 [ "\x00tags\x00object_738409" "object_738409" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_738409', 'object_738409');
46	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: [`1769206502 [ "object_738409\x00tags\x00" "class_3\x00tags\x00" "asset_27822\x00tags\x00" "asset_27821\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_738409\0tags\0', 'class_3\0tags\0', 'asset_27822\0tags\0', 'asset_27821\0tags\0');
47	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: [`1769206502 [ "\x00tags\x00object_736634" "object_736634" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_736634', 'object_736634');
48	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: [`1769206502 [ "object_736634\x00tags\x00" "class_3\x00tags\x00" "asset_27761\x00tags\x00" "asset_27760\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_736634\0tags\0', 'class_3\0tags\0', 'asset_27761\0tags\0', 'asset_27760\0tags\0');
49	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: [`1769206502 [ "\x00tags\x00object_735840" "object_735840" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_735840', 'object_735840');
50	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: [`1769206502 [ "object_735840\x00tags\x00" "class_3\x00tags\x00" "asset_27719\x00tags\x00" "asset_27720\x00tags\x00" "asset_27735\x00tags\x00" "asset_27721\x00tags\x00" "asset_27726\x00tags\x00" "asset_27734\x00tags\x00" "asset_27723\x00tags\x00" "asset_27725\x00tags\x00" "asset_27728\x00tags\x00" "asset_27736\x00tags\x00" "asset_27724\x00tags\x00" "asset_27727\x00tags\x00" "asset_27729\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_735840\0tags\0', 'class_3\0tags\0', 'asset_27719\0tags\0', 'asset_27720\0tags\0', 'asset_27735\0tags\0', 'asset_27721\0tags\0', 'asset_27726\0tags\0', 'asset_27734\0tags\0', 'asset_27723\0tags\0', 'asset_27725\0tags\0', 'asset_27728\0tags\0', 'asset_27736\0tags\0', 'asset_27724\0tags\0', 'asset_27727\0tags\0', 'asset_27729\0tags\0');
51	0.29 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1769206502 [ "\x00tags\x00object_735511" "object_735511" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_735511', 'object_735511');
52	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: [`1769206502 [ "object_735511\x00tags\x00" "class_3\x00tags\x00" "asset_27699\x00tags\x00" "asset_27838\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_735511\0tags\0', 'class_3\0tags\0', 'asset_27699\0tags\0', 'asset_27838\0tags\0');
53	1.25 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1769206502 [ "\x00tags\x00object_734277" "object_734277" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_734277', 'object_734277');
54	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: [`1769206502 [ "object_734277\x00tags\x00" "class_3\x00tags\x00" "asset_27640\x00tags\x00" "asset_27641\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_734277\0tags\0', 'class_3\0tags\0', 'asset_27640\0tags\0', 'asset_27641\0tags\0');
55	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: [`1769206502 [ "\x00tags\x00object_733888" "object_733888" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_733888', 'object_733888');
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: [1769206502 [ "object_733888\x00tags\x00" "class_3\x00tags\x00" "asset_27613\x00tags\x00" "asset_27615\x00tags\x00" "asset_27614\x00tags\x00" "asset_27611\x00tags\x00" "asset_27612\x00tags\x00" "asset_27603\x00tags\x00" "asset_27606\x00tags\x00" "asset_27608\x00tags\x00" "asset_27616\x00tags\x00" "asset_27618\x00tags\x00" "asset_27617\x00tags\x00" "asset_27624\x00tags\x00" "asset_27619\x00tags\x00" "asset_27621\x00tags\x00" "asset_27623\x00tags\x00" "asset_27620\x00tags\x00" "asset_27622\x00tags\x00" "asset_27625\x00tags\x00" ]] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_733888\0tags\0', 'class_3\0tags\0', 'asset_27613\0tags\0', 'asset_27615\0tags\0', 'asset_27614\0tags\0', 'asset_27611\0tags\0', 'asset_27612\0tags\0', 'asset_27603\0tags\0', 'asset_27606\0tags\0', 'asset_27608\0tags\0', 'asset_27616\0tags\0', 'asset_27618\0tags\0', 'asset_27617\0tags\0', 'asset_27624\0tags\0', 'asset_27619\0tags\0', 'asset_27621\0tags\0', 'asset_27623\0tags\0', 'asset_27620\0tags\0', 'asset_27622\0tags\0', 'asset_27625\0tags\0');
57	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: [`1769206502 [ "\x00tags\x00object_732853" "object_732853" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_732853', 'object_732853');
58	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: [`1769206502 [ "object_732853\x00tags\x00" "class_3\x00tags\x00" "asset_27567\x00tags\x00" "asset_27580\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_732853\0tags\0', 'class_3\0tags\0', 'asset_27567\0tags\0', 'asset_27580\0tags\0');
59	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: [`1769206502 [ "\x00tags\x00object_731447" "object_731447" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_731447', 'object_731447');
60	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: [`1769206502 [ "object_731447\x00tags\x00" "class_3\x00tags\x00" "asset_27420\x00tags\x00" "asset_27496\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_731447\0tags\0', 'class_3\0tags\0', 'asset_27420\0tags\0', 'asset_27496\0tags\0');
61	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: [`1769206502 [ "\x00tags\x00object_731497" "object_731497" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_731497', 'object_731497');
62	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: [`1769206502 [ "object_731497\x00tags\x00" "class_3\x00tags\x00" "asset_27425\x00tags\x00" "asset_27427\x00tags\x00" "asset_27426\x00tags\x00" "asset_27422\x00tags\x00" "asset_27423\x00tags\x00" "asset_27424\x00tags\x00" "asset_27428\x00tags\x00" "asset_27429\x00tags\x00" "asset_27430\x00tags\x00" "asset_27431\x00tags\x00" "asset_27432\x00tags\x00" "asset_27433\x00tags\x00" "asset_27434\x00tags\x00" "asset_27435\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_731497\0tags\0', 'class_3\0tags\0', 'asset_27425\0tags\0', 'asset_27427\0tags\0', 'asset_27426\0tags\0', 'asset_27422\0tags\0', 'asset_27423\0tags\0', 'asset_27424\0tags\0', 'asset_27428\0tags\0', 'asset_27429\0tags\0', 'asset_27430\0tags\0', 'asset_27431\0tags\0', 'asset_27432\0tags\0', 'asset_27433\0tags\0', 'asset_27434\0tags\0', 'asset_27435\0tags\0');
63	0.09 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1769206502 [ "\x00tags\x00object_731435" "object_731435" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_731435', 'object_731435');
64	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: [`1769206502 [ "object_731435\x00tags\x00" "class_3\x00tags\x00" "asset_27414\x00tags\x00" "asset_27413\x00tags\x00" "asset_27856\x00tags\x00" "document_1\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_731435\0tags\0', 'class_3\0tags\0', 'asset_27414\0tags\0', 'asset_27413\0tags\0', 'asset_27856\0tags\0', 'document_1\0tags\0');
65	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: [`1769206502 [ "\x00tags\x00object_729920" "object_729920" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_729920', 'object_729920');
66	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: [`1769206502 [ "object_729920\x00tags\x00" "class_3\x00tags\x00" "asset_27370\x00tags\x00" "asset_27372\x00tags\x00" "asset_27371\x00tags\x00" "asset_27369\x00tags\x00" "asset_27364\x00tags\x00" "asset_27365\x00tags\x00" "asset_27368\x00tags\x00" "asset_27367\x00tags\x00" "asset_27366\x00tags\x00" "asset_27373\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_729920\0tags\0', 'class_3\0tags\0', 'asset_27370\0tags\0', 'asset_27372\0tags\0', 'asset_27371\0tags\0', 'asset_27369\0tags\0', 'asset_27364\0tags\0', 'asset_27365\0tags\0', 'asset_27368\0tags\0', 'asset_27367\0tags\0', 'asset_27366\0tags\0', 'asset_27373\0tags\0');
67	1.13 ms	SELECT COUNT() FROM object_3 WHERE (hiddenFromList IS NOT TRUE AND (category__id IN (0,375317,375322,723650,723676)) AND object_3.o_type IN ('object','folder')) AND object_3.o_published = 1 Parameters: [] View formatted query View runnable query Explain query SELECT COUNT() FROM object_3 WHERE ( hiddenFromList IS NOT TRUE AND ( category__id IN (0, 375317, 375322, 723650, 723676) ) AND object_3.o_type IN ('object', 'folder') ) AND object_3.o_published = 1 SELECT COUNT(*) FROM object_3 WHERE (hiddenFromList IS NOT TRUE AND (category__id IN (0,375317,375322,723650,723676)) AND object_3.o_type IN ('object','folder')) AND object_3.o_published = 1;
68	0.14 ms	SELECT id FROM tags WHERE ISNULL(parentId) OR parentId = 0 ORDER BY `name` Parameters: [] View formatted query View runnable query Explain query SELECT id FROM tags WHERE ISNULL(parentId) OR parentId = 0 ORDER BY `name` SELECT id FROM tags WHERE ISNULL(parentId) OR parentId = 0 ORDER BY `name` ;
69	0.11 ms	SELECT * FROM tags WHERE id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 8;
70	0.06 ms	SELECT * FROM tags WHERE id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 9;
71	0.05 ms	SELECT * FROM tags WHERE id = ? Parameters: [`14`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 14;
72	0.04 ms	SELECT * FROM tags WHERE id = ? Parameters: [`10`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 10;
73	0.03 ms	SELECT * FROM tags WHERE id = ? Parameters: [`18`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 18;
74	0.03 ms	SELECT * FROM tags WHERE id = ? Parameters: [`17`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 17;
75	0.03 ms	SELECT * FROM tags WHERE id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 3;
76	0.03 ms	SELECT * FROM tags WHERE id = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 5;
77	0.03 ms	SELECT * FROM tags WHERE id = ? Parameters: [`4`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 4;
78	0.03 ms	SELECT * FROM tags WHERE id = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 6;
79	0.03 ms	SELECT * FROM tags WHERE id = ? Parameters: [`16`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 16;
80	0.03 ms	SELECT * FROM tags WHERE id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 1;
81	0.03 ms	SELECT * FROM tags WHERE id = ? Parameters: [`13`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 13;
82	0.03 ms	SELECT * FROM tags WHERE id = ? Parameters: [`11`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 11;
83	0.03 ms	SELECT * FROM tags WHERE id = ? Parameters: [`12`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 12;
84	0.03 ms	SELECT * FROM tags WHERE id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT * FROM tags WHERE id = ? SELECT * FROM tags WHERE id = 2;
85	0.21 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "header" "path" => "/shared/"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key SELECT id FROM documents WHERE path = BINARY '/shared/' AND `key` = BINARY 'header';
86	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: [`1769206502 [ "\x00tags\x00document_76" "document_76" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_76', 'document_76');
87	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: [`1769206502 [ "document_76\x00tags\x00" "asset_16823\x00tags\x00" "asset_16821\x00tags\x00" "asset_16825\x00tags\x00" "asset_16824\x00tags\x00" "asset_16820\x00tags\x00" "asset_20642\x00tags\x00" "asset_21858\x00tags\x00" "asset_20603\x00tags\x00" "asset_20600\x00tags\x00" "asset_20602\x00tags\x00" "asset_20601\x00tags\x00" "asset_20599\x00tags\x00" "asset_16826\x00tags\x00" "asset_20648\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_76\0tags\0', 'asset_16823\0tags\0', 'asset_16821\0tags\0', 'asset_16825\0tags\0', 'asset_16824\0tags\0', 'asset_16820\0tags\0', 'asset_20642\0tags\0', 'asset_21858\0tags\0', 'asset_20603\0tags\0', 'asset_20600\0tags\0', 'asset_20602\0tags\0', 'asset_20601\0tags\0', 'asset_20599\0tags\0', 'asset_16826\0tags\0', 'asset_20648\0tags\0');
88	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: [`1769206502 [ "\x00tags\x00document_properties_76" "document_properties_76" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_76', 'document_properties_76');
89	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: [`1769206502 [ "document_properties\x00tags\x00" "document_76\x00tags\x00" "document_properties_76\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769206502 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0', 'document_76\0tags\0', 'document_properties_76\0tags\0');
90	0.17 ms	SELECT id FROM settings_store WHERE scope = ? Parameters: [`"pimcore_staticroutes"`] View formatted query View runnable query Explain query SELECT id FROM settings_store WHERE scope = ? SELECT id FROM settings_store WHERE scope = 'pimcore_staticroutes';
91	0.34 ms	SELECT t0.name AS name_1, t0.template AS template_2, t0.isDefault AS isDefault_3, t0.siteId AS siteId_4, t0.creationDate AS creationDate_5, t0.modificationDate AS modificationDate_6, t0.id AS id_7, t0.useGrossPrice AS useGrossPrice_8, t0.currencyId AS currencyId_9, t10.configKey AS configKey_11, t10.data AS data_12, t10.creationDate AS creationDate_13, t10.modificationDate AS modificationDate_14, t10.id AS id_15, t10.store_id AS store_id_16, t0.baseCountryId AS baseCountryId_17, t18.isoCode AS isoCode_19, t18.active AS active_20, t18.addressFormat AS addressFormat_21, t18.salutations AS salutations_22, t18.creationDate AS creationDate_23, t18.modificationDate AS modificationDate_24, t18.id AS id_25, t18.zoneId AS zoneId_26, t18.currencyId AS currencyId_27 FROM coreshop_store t0 LEFT JOIN coreshop_configuration t10 ON t10.store_id = t0.id LEFT JOIN coreshop_country t18 ON t0.baseCountryId = t18.id Parameters: [] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.template AS template_2, t0.isDefault AS isDefault_3, t0.siteId AS siteId_4, t0.creationDate AS creationDate_5, t0.modificationDate AS modificationDate_6, t0.id AS id_7, t0.useGrossPrice AS useGrossPrice_8, t0.currencyId AS currencyId_9, t10.configKey AS configKey_11, t10.data AS data_12, t10.creationDate AS creationDate_13, t10.modificationDate AS modificationDate_14, t10.id AS id_15, t10.store_id AS store_id_16, t0.baseCountryId AS baseCountryId_17, t18.isoCode AS isoCode_19, t18.active AS active_20, t18.addressFormat AS addressFormat_21, t18.salutations AS salutations_22, t18.creationDate AS creationDate_23, t18.modificationDate AS modificationDate_24, t18.id AS id_25, t18.zoneId AS zoneId_26, t18.currencyId AS currencyId_27 FROM coreshop_store t0 LEFT JOIN coreshop_configuration t10 ON t10.store_id = t0.id LEFT JOIN coreshop_country t18 ON t0.baseCountryId = t18.id SELECT t0.name AS name_1, t0.template AS template_2, t0.isDefault AS isDefault_3, t0.siteId AS siteId_4, t0.creationDate AS creationDate_5, t0.modificationDate AS modificationDate_6, t0.id AS id_7, t0.useGrossPrice AS useGrossPrice_8, t0.currencyId AS currencyId_9, t10.configKey AS configKey_11, t10.data AS data_12, t10.creationDate AS creationDate_13, t10.modificationDate AS modificationDate_14, t10.id AS id_15, t10.store_id AS store_id_16, t0.baseCountryId AS baseCountryId_17, t18.isoCode AS isoCode_19, t18.active AS active_20, t18.addressFormat AS addressFormat_21, t18.salutations AS salutations_22, t18.creationDate AS creationDate_23, t18.modificationDate AS modificationDate_24, t18.id AS id_25, t18.zoneId AS zoneId_26, t18.currencyId AS currencyId_27 FROM coreshop_store t0 LEFT JOIN coreshop_configuration t10 ON t10.store_id = t0.id LEFT JOIN coreshop_country t18 ON t0.baseCountryId = t18.id;
92	0.75 ms	SELECT DISTINCT c0_.isoCode AS isoCode_0, c0_.name AS name_1, c0_.numericIsoCode AS numericIsoCode_2, c0_.symbol AS symbol_3, c0_.creationDate AS creationDate_4, c0_.modificationDate AS modificationDate_5, c0_.id AS id_6 FROM coreshop_currency c0_ LEFT JOIN coreshop_country c1_ ON c0_.id = c1_.currencyId INNER JOIN coreshop_store_countries c3_ ON c1_.id = c3_.country_id INNER JOIN coreshop_store c2_ ON c2_.id = c3_.store_id WHERE c1_.active = 1 AND c2_.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT DISTINCT c0_.isoCode AS isoCode_0, c0_.name AS name_1, c0_.numericIsoCode AS numericIsoCode_2, c0_.symbol AS symbol_3, c0_.creationDate AS creationDate_4, c0_.modificationDate AS modificationDate_5, c0_.id AS id_6 FROM coreshop_currency c0_ LEFT JOIN coreshop_country c1_ ON c0_.id = c1_.currencyId INNER JOIN coreshop_store_countries c3_ ON c1_.id = c3_.country_id INNER JOIN coreshop_store c2_ ON c2_.id = c3_.store_id WHERE c1_.active = 1 AND c2_.id = ? SELECT DISTINCT c0_.isoCode AS isoCode_0, c0_.name AS name_1, c0_.numericIsoCode AS numericIsoCode_2, c0_.symbol AS symbol_3, c0_.creationDate AS creationDate_4, c0_.modificationDate AS modificationDate_5, c0_.id AS id_6 FROM coreshop_currency c0_ LEFT JOIN coreshop_country c1_ ON c0_.id = c1_.currencyId INNER JOIN coreshop_store_countries c3_ ON c1_.id = c3_.country_id INNER JOIN coreshop_store c2_ ON c2_.id = c3_.store_id WHERE c1_.active = 1 AND c2_.id = 1;
93	0.24 ms	SELECT t0.name AS name_1, t0.creationDate AS creationDate_2, t0.modificationDate AS modificationDate_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM coreshop_country_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1 Parameters: [`11 "hu_HU"`] View formatted query View runnable query Explain query SELECT t0.name AS name_1, t0.creationDate AS creationDate_2, t0.modificationDate AS modificationDate_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM coreshop_country_translation t0 WHERE t0.translatable_id = ? AND t0.locale = ? LIMIT 1 SELECT t0.name AS name_1, t0.creationDate AS creationDate_2, t0.modificationDate AS modificationDate_3, t0.id AS id_4, t0.locale AS locale_5, t0.translatable_id AS translatable_id_6 FROM coreshop_country_translation t0 WHERE t0.translatable_id = 11 AND t0.locale = 'hu_HU' LIMIT 1;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
CoreShop\Component\Store\Model\Store	No errors.
CoreShop\Component\Core\Model\Store	No errors.
CoreShop\Component\Currency\Model\ExchangeRate	No errors.
CoreShop\Component\Currency\Model\Currency	No errors.
CoreShop\Component\Core\Model\Currency	No errors.
CoreShop\Component\Product\Model\ProductPriceRule	No errors.
CoreShop\Component\Taxation\Model\TaxRule	No errors.
CoreShop\Component\Core\Model\TaxRule	No errors.
CoreShop\Component\Configuration\Model\Configuration	No errors.
CoreShop\Component\Core\Model\Configuration	No errors.
CoreShop\Component\Taxation\Model\TaxRate	No errors.
CoreShop\Component\Shipping\Model\ShippingRule	No errors.
CoreShop\Component\Shipping\Model\Carrier	No errors.
CoreShop\Component\Core\Model\Carrier	No errors.
CoreShop\Component\Order\Model\CartPriceRule	No errors.
CoreShop\Component\Order\Model\CartPriceRuleVoucherCode	No errors.
CoreShop\Component\Payment\Model\PaymentProviderRule	No errors.
CoreShop\Component\Address\Model\Country	No errors.
CoreShop\Component\Core\Model\Country	No errors.
CoreShop\Component\Address\Model\Zone	No errors.
CoreShop\Component\Address\Model\CountryTranslation	No errors.
CoreShop\Component\Address\Model\State	No errors.
CoreShop\Component\Product\Model\ProductPriceRuleTranslation	No errors.
CoreShop\Component\Rule\Model\Condition	No errors.
CoreShop\Component\Rule\Model\Action	No errors.
CoreShop\Component\Taxation\Model\TaxRuleGroup	No errors.
CoreShop\Component\Taxation\Model\TaxRateTranslation	No errors.
CoreShop\Component\Shipping\Model\ShippingRuleGroup	No errors.
CoreShop\Component\Shipping\Model\CarrierTranslation	No errors.
CoreShop\Component\Order\Model\CartPriceRuleTranslation	No errors.
CoreShop\Component\Address\Model\StateTranslation	No errors.

Symfony Profiler

https://boutique.local.szerver.online/_fragment?_path=_format%3Dhtml%26_locale%3Dhu%26_controller%3DApp%255CEcommerce%255CController%255CCartController%253A%253AwidgetAction

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping