Symfony Profiler

Query Metrics

99 Database Queries

26 Different statements

42.35 ms Query time

0 Invalid entities

177 Managed 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 item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
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, t0.baseCountryId AS baseCountryId_10, t11.isoCode AS isoCode_12, t11.active AS active_13, t11.addressFormat AS addressFormat_14, t11.salutations AS salutations_15, t11.creationDate AS creationDate_16, t11.modificationDate AS modificationDate_17, t11.id AS id_18, t11.zoneId AS zoneId_19, t11.currencyId AS currencyId_20 FROM coreshop_store t0 LEFT JOIN coreshop_country t11 ON t0.baseCountryId = t11.id WHERE t0.id = ?
SELECT t0.configKey AS configKey_1, t0.data AS data_2, t0.creationDate AS creationDate_3, t0.modificationDate AS modificationDate_4, t0.id AS id_5, t0.store_id AS store_id_6 FROM coreshop_configuration t0 WHERE t0.store_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 name FROM classes WHERE id = ?
SELECT object_4.id as id, object_4.type as `type` FROM object_4 WHERE ((`site` = ?)  AND (hidden IS NULL OR hidden = 0)  AND  object_4.type IN ('object','variant','folder')) AND object_4.published = 1 ORDER BY `name` ASC
SELECT object_3.id as id, object_3.type as `type` FROM object_3 WHERE (hiddenFromList IS NOT TRUE AND (category__id IN (?))  AND  object_3.type IN ('object','variant','folder')) AND object_3.published = 1 ORDER BY `highlighted` DESC, `date` DESC   LIMIT 15 OFFSET 210
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
SELECT name FROM classes WHERE id = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_3 WHERE oo_id = ? FOR UPDATE
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE 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_NewsTextContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_NewsImageContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_NewsElementorContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_NewsEmbedContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_NewsGalleryContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_relations_3 WHERE src_id = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_3 WHERE oo_id = ? FOR UPDATE
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE 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_NewsTextContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_NewsImageContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_NewsElementorContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_NewsEmbedContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_NewsGalleryContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_relations_3 WHERE src_id = ?
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
SELECT objects.*, tree_locks.locked as locked FROM objects
            LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object'
                WHERE objects.id = ?
SELECT * FROM object_store_3 WHERE oo_id = ? FOR UPDATE
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE 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_NewsTextContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_NewsImageContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_NewsElementorContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_NewsEmbedContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_collection_NewsGalleryContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
SELECT * FROM object_relations_3 WHERE src_id = ?
SELECT COUNT(*) FROM object_3 WHERE (hiddenFromList IS NOT TRUE AND (category__id IN (?))  AND  object_3.type IN ('object','variant','folder')) AND object_3.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 customSettings FROM assets WHERE id = ?
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 item_id, CASE 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 * 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 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 = ?

#▲	Time	Info
1	0.44 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1773970439 "site_domain_3808adc20ecab895921e2047a17d2dd8"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_3808adc20ecab895921e2047a17d2dd8');
2	0.39 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1773970439 "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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
3	0.37 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.66 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: [`"/aktualitasok" "path" "auto_create" "/aktualitasok?page=15" "path_query" "https://www.boutique.local.szerver.online/aktualitasok?page=15" "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 = '/aktualitasok' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/aktualitasok?page=15' AND `type` = 'path_query') OR (source = 'https://www.boutique.local.szerver.online/aktualitasok?page=15' 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.36 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1773970439 "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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system_route_redirect');
6	0.40 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) Parameters: [`1773970439 "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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'redirecttags', 'routetags');
7	0.43 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.37 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.47 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/" "aktualitasok"`] 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 'aktualitasok';
10	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: [`1773970439 "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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_12');
11	0.34 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1773970439 "document_12\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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_12tags');
12	0.34 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1773970439 "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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_12');
13	0.39 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1773970439 "document_properties\x01tags\x01" "document_12\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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_propertiestags', 'document_12tags');
14	0.43 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, t0.baseCountryId AS baseCountryId_10, t11.isoCode AS isoCode_12, t11.active AS active_13, t11.addressFormat AS addressFormat_14, t11.salutations AS salutations_15, t11.creationDate AS creationDate_16, t11.modificationDate AS modificationDate_17, t11.id AS id_18, t11.zoneId AS zoneId_19, t11.currencyId AS currencyId_20 FROM coreshop_store t0 LEFT JOIN coreshop_country t11 ON t0.baseCountryId = t11.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, t0.baseCountryId AS baseCountryId_10, t11.isoCode AS isoCode_12, t11.active AS active_13, t11.addressFormat AS addressFormat_14, t11.salutations AS salutations_15, t11.creationDate AS creationDate_16, t11.modificationDate AS modificationDate_17, t11.id AS id_18, t11.zoneId AS zoneId_19, t11.currencyId AS currencyId_20 FROM coreshop_store t0 LEFT JOIN coreshop_country t11 ON t0.baseCountryId = t11.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, t0.baseCountryId AS baseCountryId_10, t11.isoCode AS isoCode_12, t11.active AS active_13, t11.addressFormat AS addressFormat_14, t11.salutations AS salutations_15, t11.creationDate AS creationDate_16, t11.modificationDate AS modificationDate_17, t11.id AS id_18, t11.zoneId AS zoneId_19, t11.currencyId AS currencyId_20 FROM coreshop_store t0 LEFT JOIN coreshop_country t11 ON t0.baseCountryId = t11.id WHERE t0.id = 1;
15	0.59 ms	SELECT t0.configKey AS configKey_1, t0.data AS data_2, t0.creationDate AS creationDate_3, t0.modificationDate AS modificationDate_4, t0.id AS id_5, t0.store_id AS store_id_6 FROM coreshop_configuration t0 WHERE t0.store_id IN (?) Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.configKey AS configKey_1, t0.data AS data_2, t0.creationDate AS creationDate_3, t0.modificationDate AS modificationDate_4, t0.id AS id_5, t0.store_id AS store_id_6 FROM coreshop_configuration t0 WHERE t0.store_id IN (?) SELECT t0.configKey AS configKey_1, t0.data AS data_2, t0.creationDate AS creationDate_3, t0.modificationDate AS modificationDate_4, t0.id AS id_5, t0.store_id AS store_id_6 FROM coreshop_configuration t0 WHERE t0.store_id IN (1);
16	0.47 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';
17	0.58 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1773970439 "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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('sites_path_mapping');
18	0.42 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1773970439 "system\x01tags\x01" "resource\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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'resourcetags');
19	0.43 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';
20	0.81 ms	SELECT object_4.id as id, object_4.type as `type` FROM object_4 WHERE ((`site` = ?) AND (hidden IS NULL OR hidden = 0) AND object_4.type IN ('object','variant','folder')) AND object_4.published = 1 ORDER BY `name` ASC Parameters: [`"boutique"`] View formatted query View runnable query Explain query SELECT object_4.id as id, object_4.type as `type` FROM object_4 WHERE ( (`site` = ?) AND ( hidden IS NULL OR hidden = 0 ) AND object_4.type IN ('object', 'variant', 'folder') ) AND object_4.published = 1 ORDER BY `name` ASC SELECT object_4.id as id, object_4.type as `type` FROM object_4 WHERE ((`site` = 'boutique') AND (hidden IS NULL OR hidden = 0) AND object_4.type IN ('object','variant','folder')) AND object_4.published = 1 ORDER BY `name` ASC ;
21	2.34 ms	SELECT object_3.id as id, object_3.type as `type` FROM object_3 WHERE (hiddenFromList IS NOT TRUE AND (category__id IN (?)) AND object_3.type IN ('object','variant','folder')) AND object_3.published = 1 ORDER BY `highlighted` DESC, `date` DESC LIMIT 15 OFFSET 210 Parameters: [`"375317,375322"`] View formatted query View runnable query Explain query SELECT object_3.id as id, object_3.type as `type` FROM object_3 WHERE ( hiddenFromList IS NOT TRUE AND ( category__id IN (?) ) AND object_3.type IN ('object', 'variant', 'folder') ) AND object_3.published = 1 ORDER BY `highlighted` DESC, `date` DESC LIMIT 15 OFFSET 210 SELECT object_3.id as id, object_3.type as `type` FROM object_3 WHERE (hiddenFromList IS NOT TRUE AND (category__id IN ('375317,375322')) AND object_3.type IN ('object','variant','folder')) AND object_3.published = 1 ORDER BY `highlighted` DESC, `date` DESC LIMIT 15 OFFSET 210;
22	0.36 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1773970439 "object_375514"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375514');
23	0.52 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) Parameters: [`1773970439 "object_375514\x01tags\x01" "class_3\x01tags\x01" "asset_13926\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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375514tags', 'class_3tags', 'asset_13926tags');
24	0.31 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';
25	0.47 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1773970439 "object_375517"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375517');
26	0.46 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) Parameters: [`1773970439 "object_375517\x01tags\x01" "class_3\x01tags\x01" "asset_13929\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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375517tags', 'class_3tags', 'asset_13929tags');
27	0.32 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1773970439 "object_375519"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375519');
28	0.39 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) Parameters: [`1773970439 "object_375519\x01tags\x01" "class_3\x01tags\x01" "asset_13931\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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375519tags', 'class_3tags', 'asset_13931tags');
29	0.34 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1773970439 "object_375525"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375525');
30	0.38 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) Parameters: [`1773970439 "object_375525\x01tags\x01" "class_3\x01tags\x01" "asset_13936\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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375525tags', 'class_3tags', 'asset_13936tags');
31	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: [`1773970439 "object_375526"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375526');
32	0.30 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1773970439 "\x00tags\x00object_375526"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_375526');
33	0.33 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`375526`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 375526;
34	0.36 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`375526`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 375526;
35	0.34 ms	SELECT * FROM object_store_3 WHERE oo_id = ? FOR UPDATE Parameters: [`375526`] View formatted query View runnable query Explain query SELECT * FROM object_store_3 WHERE oo_id = ? FOR UPDATE SELECT * FROM object_store_3 WHERE oo_id = 375526 FOR UPDATE;
36	0.34 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1773970439 "asset_13937"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_13937');
37	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: [`1773970439 "asset_13937\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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_13937tags');
38	0.39 ms	SELECT * FROM object_collection_NewsTextContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`375526 "content"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_NewsTextContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_NewsTextContent_3 WHERE id = 375526 AND fieldname = 'content' ORDER BY `index` ASC;
39	0.30 ms	SELECT * FROM object_collection_NewsImageContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`375526 "content"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_NewsImageContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_NewsImageContent_3 WHERE id = 375526 AND fieldname = 'content' ORDER BY `index` ASC;
40	0.87 ms	SELECT * FROM object_collection_NewsElementorContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`375526 "content"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_NewsElementorContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_NewsElementorContent_3 WHERE id = 375526 AND fieldname = 'content' ORDER BY `index` ASC;
41	0.45 ms	SELECT * FROM object_collection_NewsEmbedContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`375526 "content"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_NewsEmbedContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_NewsEmbedContent_3 WHERE id = 375526 AND fieldname = 'content' ORDER BY `index` ASC;
42	0.41 ms	SELECT * FROM object_collection_NewsGalleryContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`375526 "content"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_NewsGalleryContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_NewsGalleryContent_3 WHERE id = 375526 AND fieldname = 'content' ORDER BY `index` ASC;
43	0.40 ms	SELECT * FROM object_relations_3 WHERE src_id = ? Parameters: [`375526`] View formatted query View runnable query Explain query SELECT * FROM object_relations_3 WHERE src_id = ? SELECT * FROM object_relations_3 WHERE src_id = 375526;
44	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: [`1773970439 "object_375530"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375530');
45	0.34 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) Parameters: [`1773970439 "object_375530\x01tags\x01" "class_3\x01tags\x01" "asset_13941\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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375530tags', 'class_3tags', 'asset_13941tags');
46	0.32 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1773970439 "object_375532"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375532');
47	0.38 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) Parameters: [`1773970439 "object_375532\x01tags\x01" "class_3\x01tags\x01" "asset_13943\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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375532tags', 'class_3tags', 'asset_13943tags');
48	0.32 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1773970439 "object_375533"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375533');
49	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: [`1773970439 "object_375533\x01tags\x01" "class_3\x01tags\x01" "asset_13944\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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375533tags', 'class_3tags', 'asset_13944tags');
50	0.30 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1773970439 "object_375537"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375537');
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: [`1773970439 "object_375537\x01tags\x01" "class_3\x01tags\x01" "asset_13947\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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375537tags', 'class_3tags', 'asset_13947tags');
52	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: [`1773970439 "object_375538"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375538');
53	0.28 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) Parameters: [`1773970439 "object_375538\x01tags\x01" "class_3\x01tags\x01" "asset_13948\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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375538tags', 'class_3tags', 'asset_13948tags');
54	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: [`1773970439 "object_375544"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375544');
55	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: [`1773970439 "\x00tags\x00object_375544"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_375544');
56	0.21 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`375544`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 375544;
57	0.30 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`375544`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 375544;
58	0.26 ms	SELECT * FROM object_store_3 WHERE oo_id = ? FOR UPDATE Parameters: [`375544`] View formatted query View runnable query Explain query SELECT * FROM object_store_3 WHERE oo_id = ? FOR UPDATE SELECT * FROM object_store_3 WHERE oo_id = 375544 FOR UPDATE;
59	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: [`1773970439 "asset_13953"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_13953');
60	0.24 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1773970439 "asset_13953\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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_13953tags');
61	0.33 ms	SELECT * FROM object_collection_NewsTextContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`375544 "content"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_NewsTextContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_NewsTextContent_3 WHERE id = 375544 AND fieldname = 'content' ORDER BY `index` ASC;
62	0.28 ms	SELECT * FROM object_collection_NewsImageContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`375544 "content"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_NewsImageContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_NewsImageContent_3 WHERE id = 375544 AND fieldname = 'content' ORDER BY `index` ASC;
63	0.31 ms	SELECT * FROM object_collection_NewsElementorContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`375544 "content"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_NewsElementorContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_NewsElementorContent_3 WHERE id = 375544 AND fieldname = 'content' ORDER BY `index` ASC;
64	0.28 ms	SELECT * FROM object_collection_NewsEmbedContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`375544 "content"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_NewsEmbedContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_NewsEmbedContent_3 WHERE id = 375544 AND fieldname = 'content' ORDER BY `index` ASC;
65	0.25 ms	SELECT * FROM object_collection_NewsGalleryContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`375544 "content"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_NewsGalleryContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_NewsGalleryContent_3 WHERE id = 375544 AND fieldname = 'content' ORDER BY `index` ASC;
66	0.28 ms	SELECT * FROM object_relations_3 WHERE src_id = ? Parameters: [`375544`] View formatted query View runnable query Explain query SELECT * FROM object_relations_3 WHERE src_id = ? SELECT * FROM object_relations_3 WHERE src_id = 375544;
67	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: [`1773970439 "object_375546"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375546');
68	0.27 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) Parameters: [`1773970439 "object_375546\x01tags\x01" "class_3\x01tags\x01" "asset_13955\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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375546tags', 'class_3tags', 'asset_13955tags');
69	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: [`1773970439 "object_375549"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375549');
70	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: [`1773970439 "object_375549\x01tags\x01" "class_3\x01tags\x01" "asset_13958\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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375549tags', 'class_3tags', 'asset_13958tags');
71	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: [`1773970439 "object_375551"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375551');
72	0.24 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) Parameters: [`1773970439 "object_375551\x01tags\x01" "class_3\x01tags\x01" "asset_13960\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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375551tags', 'class_3tags', 'asset_13960tags');
73	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: [`1773970439 "object_375553"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375553');
74	0.16 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1773970439 "\x00tags\x00object_375553"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_375553');
75	0.20 ms	SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ? Parameters: [`375553`] View formatted query View runnable query Explain query SELECT `type`, `className`, `classId` FROM objects WHERE `id` = ? SELECT `type`,`className`,`classId` FROM objects WHERE `id` = 375553;
76	0.25 ms	SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? Parameters: [`375553`] View formatted query View runnable query Explain query SELECT objects., tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ? SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = 375553;
77	0.20 ms	SELECT * FROM object_store_3 WHERE oo_id = ? FOR UPDATE Parameters: [`375553`] View formatted query View runnable query Explain query SELECT * FROM object_store_3 WHERE oo_id = ? FOR UPDATE SELECT * FROM object_store_3 WHERE oo_id = 375553 FOR UPDATE;
78	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: [`1773970439 "asset_13962"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_13962');
79	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: [`1773970439 "asset_13962\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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_13962tags');
80	0.28 ms	SELECT * FROM object_collection_NewsTextContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`375553 "content"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_NewsTextContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_NewsTextContent_3 WHERE id = 375553 AND fieldname = 'content' ORDER BY `index` ASC;
81	0.24 ms	SELECT * FROM object_collection_NewsImageContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`375553 "content"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_NewsImageContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_NewsImageContent_3 WHERE id = 375553 AND fieldname = 'content' ORDER BY `index` ASC;
82	2.06 ms	SELECT * FROM object_collection_NewsElementorContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`375553 "content"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_NewsElementorContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_NewsElementorContent_3 WHERE id = 375553 AND fieldname = 'content' ORDER BY `index` ASC;
83	0.25 ms	SELECT * FROM object_collection_NewsEmbedContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`375553 "content"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_NewsEmbedContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_NewsEmbedContent_3 WHERE id = 375553 AND fieldname = 'content' ORDER BY `index` ASC;
84	0.22 ms	SELECT * FROM object_collection_NewsGalleryContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC Parameters: [`375553 "content"`] View formatted query View runnable query Explain query SELECT * FROM object_collection_NewsGalleryContent_3 WHERE id = ? AND fieldname = ? ORDER BY `index` ASC SELECT * FROM object_collection_NewsGalleryContent_3 WHERE id = 375553 AND fieldname = 'content' ORDER BY `index` ASC;
85	0.21 ms	SELECT * FROM object_relations_3 WHERE src_id = ? Parameters: [`375553`] View formatted query View runnable query Explain query SELECT * FROM object_relations_3 WHERE src_id = ? SELECT * FROM object_relations_3 WHERE src_id = 375553;
86	2.50 ms	SELECT COUNT() FROM object_3 WHERE (hiddenFromList IS NOT TRUE AND (category__id IN (?)) AND object_3.type IN ('object','variant','folder')) AND object_3.published = 1 Parameters: [`"375317,375322"`] View formatted query View runnable query Explain query SELECT COUNT() FROM object_3 WHERE ( hiddenFromList IS NOT TRUE AND ( category__id IN (?) ) AND object_3.type IN ('object', 'variant', 'folder') ) AND object_3.published = 1 SELECT COUNT(*) FROM object_3 WHERE (hiddenFromList IS NOT TRUE AND (category__id IN ('375317,375322')) AND object_3.type IN ('object','variant','folder')) AND object_3.published = 1;
87	0.51 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1773970439 "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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('website_config');
88	0.41 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?) Parameters: [`1773970439 "website_config\x01tags\x01" "system\x01tags\x01" "config\x01tags\x01" "output\x01tags\x01" "asset_15304\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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('website_configtags', 'systemtags', 'configtags', 'outputtags', 'asset_15304tags');
89	0.33 ms	SELECT customSettings FROM assets WHERE id = ? Parameters: [`15304`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 15304;
90	0.39 ms	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/shared/" "header"`] 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 '/shared/' AND `key` = BINARY 'header';
91	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: [`1773970439 "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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_76');
92	0.44 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) Parameters: [`1773970439 "document_76\x01tags\x01" "asset_16823\x01tags\x01" "asset_16821\x01tags\x01" "asset_16825\x01tags\x01" "asset_16824\x01tags\x01" "asset_16820\x01tags\x01" "asset_20642\x01tags\x01" "asset_21858\x01tags\x01" "asset_20603\x01tags\x01" "asset_20600\x01tags\x01" "asset_20602\x01tags\x01" "asset_20601\x01tags\x01" "asset_20599\x01tags\x01" "asset_16826\x01tags\x01" "asset_20648\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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_76tags', 'asset_16823tags', 'asset_16821tags', 'asset_16825tags', 'asset_16824tags', 'asset_16820tags', 'asset_20642tags', 'asset_21858tags', 'asset_20603tags', 'asset_20600tags', 'asset_20602tags', 'asset_20601tags', 'asset_20599tags', 'asset_16826tags', 'asset_20648tags');
93	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: [`1773970439 "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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties_76');
94	0.30 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) Parameters: [`1773970439 "document_properties\x01tags\x01" "document_76\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 > 1773970439 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_propertiestags', 'document_76tags');
95	0.32 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';
96	0.59 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=_format=html&_locale=hu&_controller=App%5CController%5CFrontend%5CDefaultController" "path_query" "https://www.boutique.local.szerver.online/_fragment?_path=_format=html&_locale=hu&_controller=App%5CController%5CFrontend%5CDefaultController" "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=_format=html&_locale=hu&_controller=App%5CController%5CFrontend%5CDefaultController' AND `type` = 'path_query') OR (source = 'https://www.boutique.local.szerver.online/_fragment?_path=_format=html&_locale=hu&_controller=App%5CController%5CFrontend%5CDefaultController' 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;
97	0.60 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';
98	0.68 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=_format=html&_locale=hu&_controller=App%5CController%5CFrontend%5CWishlistController%3A%3AwishlistWidgetAction" "path_query" "https://www.boutique.local.szerver.online/_fragment?_path=_format=html&_locale=hu&_controller=App%5CController%5CFrontend%5CWishlistController%3A%3AwishlistWidgetAction" "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=_format=html&_locale=hu&_controller=App%5CController%5CFrontend%5CWishlistController%3A%3AwishlistWidgetAction' AND `type` = 'path_query') OR (source = 'https://www.boutique.local.szerver.online/_fragment?_path=_format=html&_locale=hu&_controller=App%5CController%5CFrontend%5CWishlistController%3A%3AwishlistWidgetAction' 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;
99	1.93 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;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager
pimcore	doctrine.orm.pimcore_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
CoreShop\Component\Core\Model\Currency	156
CoreShop\Component\Core\Model\Configuration	18
CoreShop\Component\Core\Model\Store	1
CoreShop\Component\Core\Model\Country	1
CoreShop\Component\Address\Model\Zone	1

pimcore entity manager

Class	Amount of managed objects

Entities Mapping

default entity manager

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\Order\Model\CartPriceRuleVoucherCodeCustomer	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.

pimcore entity manager

No loaded entities.

Symfony Profiler

GET https://www.boutique.local.szerver.online/_fragment?_path=_format%3Dhtml%26_locale%3Dhu%26_controller%3DApp%255CController%255CFrontend%255CWishlistController%2…

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

pimcore entity manager

Entities Mapping

default entity manager

pimcore entity manager