Symfony Profiler

Last 10 Latest Search

Settings

Query Metrics

76 Database Queries

19 Different statements

35.87 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 id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT 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 name FROM classes WHERE id = ?
SELECT object_localized_cs_product_hu_HU.o_id as o_id, object_localized_cs_product_hu_HU.o_type as o_type FROM object_localized_cs_product_hu_HU WHERE `sku` = 'SRPL64J1'  AND  object_localized_cs_product_hu_HU.o_type IN ('object','folder') LIMIT 1
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE 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 c0_.product AS product_0, c0_.price AS price_1, c0_.id AS id_2, c0_.store AS store_3 FROM coreshop_product_store_values c0_ WHERE c0_.product = ?
SELECT c0_.name AS name_0, c0_.description AS description_1, c0_.priority AS priority_2, c0_.active AS active_3, c0_.stopPropagation AS stopPropagation_4, c0_.creationDate AS creationDate_5, c0_.modificationDate AS modificationDate_6, c0_.id AS id_7 FROM coreshop_product_price_rule c0_ WHERE c0_.active = 1 ORDER BY c0_.priority ASC
SELECT c0_.name AS name_0, c0_.priority AS priority_1, c0_.active AS active_2, c0_.inherit AS inherit_3, c0_.product AS product_4, c0_.stopPropagation AS stopPropagation_5, c0_.creationDate AS creationDate_6, c0_.modificationDate AS modificationDate_7, c0_.id AS id_8 FROM coreshop_product_specific_price_rule c0_ WHERE c0_.product = ? ORDER BY c0_.priority ASC
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT name FROM classes WHERE id = ?
SELECT t0.isoCode AS isoCode_1, t0.name AS name_2, t0.numericIsoCode AS numericIsoCode_3, t0.symbol AS symbol_4, t0.creationDate AS creationDate_5, t0.modificationDate AS modificationDate_6, t0.id AS id_7 FROM coreshop_currency t0 WHERE t0.id = ?
SELECT object_localized_cs_product_hu_HU.o_id as o_id, object_localized_cs_product_hu_HU.o_type as o_type FROM object_localized_cs_product_hu_HU WHERE (o_id NOT IN (?) AND series = ? AND  object_localized_cs_product_hu_HU.o_type IN ('object','folder')) AND object_localized_cs_product_hu_HU.o_published = 1 ORDER BY `o_creationDate` DESC   LIMIT 5
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE 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_localized_cs_product_hu_HU.o_id as o_id, object_localized_cs_product_hu_HU.o_type as o_type FROM object_localized_cs_product_hu_HU WHERE (o_id NOT IN (?) AND subcollection = ? AND  object_localized_cs_product_hu_HU.o_type IN ('object','folder')) AND object_localized_cs_product_hu_HU.o_published = 1 ORDER BY `o_creationDate` DESC   LIMIT 3
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE 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_localized_cs_product_hu_HU.o_id as o_id, object_localized_cs_product_hu_HU.o_type as o_type FROM object_localized_cs_product_hu_HU WHERE (o_id NOT IN (?) AND series = ? AND  object_localized_cs_product_hu_HU.o_type IN ('object','folder')) AND object_localized_cs_product_hu_HU.o_published = 1 ORDER BY `o_creationDate` DESC   LIMIT 5
SELECT object_localized_cs_product_hu_HU.o_id as o_id, object_localized_cs_product_hu_HU.o_type as o_type FROM object_localized_cs_product_hu_HU WHERE (o_id NOT IN (?) AND subcollection = ? AND  object_localized_cs_product_hu_HU.o_type IN ('object','folder')) AND object_localized_cs_product_hu_HU.o_published = 1 ORDER BY `o_creationDate` DESC   LIMIT 3
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 item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
SELECT item_id, CASE 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 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.43 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1769212886 [ "\x00tags\x00site_domain_3808adc20ecab895921e2047a17d2dd8" "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 > 1769212886 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0site_domain_3808adc20ecab895921e2047a17d2dd8', 'site_domain_3808adc20ecab895921e2047a17d2dd8');
2	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: [`1769212886 [ "system\x00tags\x00" "site\x00tags\x00" "site_domain_3808adc20ecab895921e2047a17d2dd8\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 > 1769212886 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'site\0tags\0', 'site_domain_3808adc20ecab895921e2047a17d2dd8\0tags\0');
3	0.56 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" => "/ora/SRPL64J1" "sourcePathQuery" => "/ora/SRPL64J1" "sourceEntireUri" => "https://www.boutique.local.szerver.online/ora/SRPL64J1" "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 = '/ora/SRPL64J1' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/ora/SRPL64J1' AND `type` = 'path_query') OR (source = 'https://www.boutique.local.szerver.online/ora/SRPL64J1' 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.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: [`1769212886 [ "\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 > 1769212886 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_route_redirect', 'system_route_redirect');
5	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: [`1769212886 [ "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 > 1769212886 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.24 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.30 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "SRPL64J1" "path" => "/ora/"`] 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 '/ora/' AND `key` = BINARY 'SRPL64J1';
8	0.27 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/ora/SRPL64J1"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/ora/SRPL64J1';
9	0.30 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "ora" "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 'ora';
10	0.19 ms	SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl Parameters: [`"prettyUrl" => "/ora"`] View formatted query View runnable query Explain query SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl SELECT id FROM documents_page WHERE prettyUrl = '/ora';
11	0.30 ms	SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key Parameters: [`"key" => "" "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 '';
12	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: [`1769212886 [ "\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 > 1769212886 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_1', 'document_1');
13	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: [1769212886 [ "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 > 1769212886 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');
14	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: [`1769212886 [ "\x00tags\x00document_properties_1" "document_properties_1" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769212886 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_1', 'document_properties_1');
15	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: [`1769212886 [ "document_properties\x00tags\x00" "document_1\x00tags\x00" "document_properties_1\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769212886 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_properties\0tags\0', 'document_1\0tags\0', 'document_properties_1\0tags\0');
16	0.48 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;
17	0.25 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';
18	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: [`1769212888 [ "\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 > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0system_supported_locales_hu', 'system_supported_locales_hu');
19	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: [`1769212888 [ "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 > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('system\0tags\0', 'system_supported_locales_hu\0tags\0');
20	0.40 ms	SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1 SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1;
21	0.38 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"cs_product"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'cs_product';
22	0.76 ms	SELECT object_localized_cs_product_hu_HU.o_id as o_id, object_localized_cs_product_hu_HU.o_type as o_type FROM object_localized_cs_product_hu_HU WHERE `sku` = 'SRPL64J1' AND object_localized_cs_product_hu_HU.o_type IN ('object','folder') LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT object_localized_cs_product_hu_HU.o_id as o_id, object_localized_cs_product_hu_HU.o_type as o_type FROM object_localized_cs_product_hu_HU WHERE `sku` = 'SRPL64J1' AND object_localized_cs_product_hu_HU.o_type IN ('object', 'folder') LIMIT 1 SELECT object_localized_cs_product_hu_HU.o_id as o_id, object_localized_cs_product_hu_HU.o_type as o_type FROM object_localized_cs_product_hu_HU WHERE `sku` = 'SRPL64J1' AND object_localized_cs_product_hu_HU.o_type IN ('object','folder') LIMIT 1;
23	0.70 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1769212888 [ "\x00tags\x00object_727244" "object_727244" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_727244', 'object_727244');
24	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: [`1769212888 [ "object_727244\x00tags\x00" "class_cs_product\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 > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_727244\0tags\0', 'class_cs_product\0tags\0');
25	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: [`1769212888 [ "\x00tags\x00asset_27476" "asset_27476" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_27476', 'asset_27476');
26	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: [`1769212888 [ "asset_27476\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 > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_27476\0tags\0');
27	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: [`1769212888 [ "\x00tags\x00asset_27477" "asset_27477" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_27477', 'asset_27477');
28	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: [`1769212888 [ "asset_27477\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 > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_27477\0tags\0');
29	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: [`1769212888 [ "\x00tags\x00asset_27478" "asset_27478" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_27478', 'asset_27478');
30	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: [`1769212888 [ "asset_27478\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 > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_27478\0tags\0');
31	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: [`1769212888 [ "\x00tags\x00asset_27479" "asset_27479" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0asset_27479', 'asset_27479');
32	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: [`1769212888 [ "asset_27479\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 > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('asset_27479\0tags\0');
33	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: [`1769212888 [ "\x00tags\x00object_375232" "object_375232" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_375232', 'object_375232');
34	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: [`1769212888 [ "object_375232\x00tags\x00" "class_cs_category\x00tags\x00" "asset_16791\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 > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375232\0tags\0', 'class_cs_category\0tags\0', 'asset_16791\0tags\0');
35	0.23 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"cs_category"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'cs_category';
36	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: [`1769212888 [ "\x00tags\x00object_375259" "object_375259" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_375259', 'object_375259');
37	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: [`1769212888 [ "object_375259\x00tags\x00" "class_cs_category\x00tags\x00" "asset_25765\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 > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375259\0tags\0', 'class_cs_category\0tags\0', 'asset_25765\0tags\0');
38	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: [`1769212888 [ "\x00tags\x00object_375262" "object_375262" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_375262', 'object_375262');
39	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: [`1769212888 [ "object_375262\x00tags\x00" "class_cs_category\x00tags\x00" "asset_22523\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 > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375262\0tags\0', 'class_cs_category\0tags\0', 'asset_22523\0tags\0');
40	0.46 ms	SELECT c0_.product AS product_0, c0_.price AS price_1, c0_.id AS id_2, c0_.store AS store_3 FROM coreshop_product_store_values c0_ WHERE c0_.product = ? Parameters: [`727244`] View formatted query View runnable query Explain query SELECT c0_.product AS product_0, c0_.price AS price_1, c0_.id AS id_2, c0_.store AS store_3 FROM coreshop_product_store_values c0_ WHERE c0_.product = ? SELECT c0_.product AS product_0, c0_.price AS price_1, c0_.id AS id_2, c0_.store AS store_3 FROM coreshop_product_store_values c0_ WHERE c0_.product = 727244;
41	0.43 ms	SELECT c0_.name AS name_0, c0_.description AS description_1, c0_.priority AS priority_2, c0_.active AS active_3, c0_.stopPropagation AS stopPropagation_4, c0_.creationDate AS creationDate_5, c0_.modificationDate AS modificationDate_6, c0_.id AS id_7 FROM coreshop_product_price_rule c0_ WHERE c0_.active = 1 ORDER BY c0_.priority ASC Parameters: [] View formatted query View runnable query Explain query SELECT c0_.name AS name_0, c0_.description AS description_1, c0_.priority AS priority_2, c0_.active AS active_3, c0_.stopPropagation AS stopPropagation_4, c0_.creationDate AS creationDate_5, c0_.modificationDate AS modificationDate_6, c0_.id AS id_7 FROM coreshop_product_price_rule c0_ WHERE c0_.active = 1 ORDER BY c0_.priority ASC SELECT c0_.name AS name_0, c0_.description AS description_1, c0_.priority AS priority_2, c0_.active AS active_3, c0_.stopPropagation AS stopPropagation_4, c0_.creationDate AS creationDate_5, c0_.modificationDate AS modificationDate_6, c0_.id AS id_7 FROM coreshop_product_price_rule c0_ WHERE c0_.active = 1 ORDER BY c0_.priority ASC;
42	0.60 ms	SELECT c0_.name AS name_0, c0_.priority AS priority_1, c0_.active AS active_2, c0_.inherit AS inherit_3, c0_.product AS product_4, c0_.stopPropagation AS stopPropagation_5, c0_.creationDate AS creationDate_6, c0_.modificationDate AS modificationDate_7, c0_.id AS id_8 FROM coreshop_product_specific_price_rule c0_ WHERE c0_.product = ? ORDER BY c0_.priority ASC Parameters: [`727244`] View formatted query View runnable query Explain query SELECT c0_.name AS name_0, c0_.priority AS priority_1, c0_.active AS active_2, c0_.inherit AS inherit_3, c0_.product AS product_4, c0_.stopPropagation AS stopPropagation_5, c0_.creationDate AS creationDate_6, c0_.modificationDate AS modificationDate_7, c0_.id AS id_8 FROM coreshop_product_specific_price_rule c0_ WHERE c0_.product = ? ORDER BY c0_.priority ASC SELECT c0_.name AS name_0, c0_.priority AS priority_1, c0_.active AS active_2, c0_.inherit AS inherit_3, c0_.product AS product_4, c0_.stopPropagation AS stopPropagation_5, c0_.creationDate AS creationDate_6, c0_.modificationDate AS modificationDate_7, c0_.id AS id_8 FROM coreshop_product_specific_price_rule c0_ WHERE c0_.product = 727244 ORDER BY c0_.priority ASC;
43	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: [`1769212888 [ "\x00tags\x00object_4" "object_4" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_4', 'object_4');
44	0.37 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1769212888 [ "object_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 > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_4\0tags\0');
45	0.37 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1769212888 [ "\x00tags\x00object_2" "object_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 > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_2', 'object_2');
46	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: [`1769212888 [ "object_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 > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_2\0tags\0');
47	0.43 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1769212888 [ "\x00tags\x00object_1" "object_1" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_1', 'object_1');
48	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: [`1769212888 [ "object_1\x00tags\x00" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_1\0tags\0');
49	0.45 ms	SELECT name FROM classes WHERE id = ? Parameters: [`"cs_address"`] View formatted query View runnable query Explain query SELECT name FROM classes WHERE id = ? SELECT name FROM classes WHERE id = 'cs_address';
50	0.41 ms	SELECT t0.isoCode AS isoCode_1, t0.name AS name_2, t0.numericIsoCode AS numericIsoCode_3, t0.symbol AS symbol_4, t0.creationDate AS creationDate_5, t0.modificationDate AS modificationDate_6, t0.id AS id_7 FROM coreshop_currency t0 WHERE t0.id = ? Parameters: [`65`] View formatted query View runnable query Explain query SELECT t0.isoCode AS isoCode_1, t0.name AS name_2, t0.numericIsoCode AS numericIsoCode_3, t0.symbol AS symbol_4, t0.creationDate AS creationDate_5, t0.modificationDate AS modificationDate_6, t0.id AS id_7 FROM coreshop_currency t0 WHERE t0.id = ? SELECT t0.isoCode AS isoCode_1, t0.name AS name_2, t0.numericIsoCode AS numericIsoCode_3, t0.symbol AS symbol_4, t0.creationDate AS creationDate_5, t0.modificationDate AS modificationDate_6, t0.id AS id_7 FROM coreshop_currency t0 WHERE t0.id = 65;
51	3.28 ms	SELECT object_localized_cs_product_hu_HU.o_id as o_id, object_localized_cs_product_hu_HU.o_type as o_type FROM object_localized_cs_product_hu_HU WHERE (o_id NOT IN (?) AND series = ? AND object_localized_cs_product_hu_HU.o_type IN ('object','folder')) AND object_localized_cs_product_hu_HU.o_published = 1 ORDER BY `o_creationDate` DESC LIMIT 5 Parameters: [`[ 727244 ] "Seiko 2025. Vol.1 - Presage 13"`] View formatted query View runnable query Explain query SELECT object_localized_cs_product_hu_HU.o_id as o_id, object_localized_cs_product_hu_HU.o_type as o_type FROM object_localized_cs_product_hu_HU WHERE ( o_id NOT IN (?) AND series = ? AND object_localized_cs_product_hu_HU.o_type IN ('object', 'folder') ) AND object_localized_cs_product_hu_HU.o_published = 1 ORDER BY `o_creationDate` DESC LIMIT 5 SELECT object_localized_cs_product_hu_HU.o_id as o_id, object_localized_cs_product_hu_HU.o_type as o_type FROM object_localized_cs_product_hu_HU WHERE (o_id NOT IN (727244) AND series = 'Seiko 2025. Vol.1 - Presage 13' AND object_localized_cs_product_hu_HU.o_type IN ('object','folder')) AND object_localized_cs_product_hu_HU.o_published = 1 ORDER BY `o_creationDate` DESC LIMIT 5;
52	0.48 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1769212888 [ "\x00tags\x00object_727243" "object_727243" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_727243', 'object_727243');
53	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: [`1769212888 [ "object_727243\x00tags\x00" "class_cs_product\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 > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_727243\0tags\0', 'class_cs_product\0tags\0');
54	0.50 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1769212888 [ "\x00tags\x00object_727242" "object_727242" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_727242', 'object_727242');
55	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: [`1769212888 [ "object_727242\x00tags\x00" "class_cs_product\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 > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_727242\0tags\0', 'class_cs_product\0tags\0');
56	1.29 ms	SELECT object_localized_cs_product_hu_HU.o_id as o_id, object_localized_cs_product_hu_HU.o_type as o_type FROM object_localized_cs_product_hu_HU WHERE (o_id NOT IN (?) AND subcollection = ? AND object_localized_cs_product_hu_HU.o_type IN ('object','folder')) AND object_localized_cs_product_hu_HU.o_published = 1 ORDER BY `o_creationDate` DESC LIMIT 3 Parameters: [`[ 727244 727243 727242 ] "Cocktail"`] View formatted query View runnable query Explain query SELECT object_localized_cs_product_hu_HU.o_id as o_id, object_localized_cs_product_hu_HU.o_type as o_type FROM object_localized_cs_product_hu_HU WHERE ( o_id NOT IN (?) AND subcollection = ? AND object_localized_cs_product_hu_HU.o_type IN ('object', 'folder') ) AND object_localized_cs_product_hu_HU.o_published = 1 ORDER BY `o_creationDate` DESC LIMIT 3 SELECT object_localized_cs_product_hu_HU.o_id as o_id, object_localized_cs_product_hu_HU.o_type as o_type FROM object_localized_cs_product_hu_HU WHERE (o_id NOT IN (727244, 727243, 727242) AND subcollection = 'Cocktail' AND object_localized_cs_product_hu_HU.o_type IN ('object','folder')) AND object_localized_cs_product_hu_HU.o_published = 1 ORDER BY `o_creationDate` DESC LIMIT 3;
57	0.65 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1769212888 [ "\x00tags\x00object_562053" "object_562053" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_562053', 'object_562053');
58	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: [`1769212888 [ "object_562053\x00tags\x00" "class_cs_product\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 > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_562053\0tags\0', 'class_cs_product\0tags\0');
59	0.48 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1769212888 [ "\x00tags\x00object_562051" "object_562051" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_562051', 'object_562051');
60	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: [`1769212888 [ "object_562051\x00tags\x00" "class_cs_product\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 > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_562051\0tags\0', 'class_cs_product\0tags\0');
61	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: [`1769212888 [ "\x00tags\x00object_562052" "object_562052" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_562052', 'object_562052');
62	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: [`1769212888 [ "object_562052\x00tags\x00" "class_cs_product\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 > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_562052\0tags\0', 'class_cs_product\0tags\0');
63	4.46 ms	SELECT object_localized_cs_product_hu_HU.o_id as o_id, object_localized_cs_product_hu_HU.o_type as o_type FROM object_localized_cs_product_hu_HU WHERE (o_id NOT IN (?) AND series = ? AND object_localized_cs_product_hu_HU.o_type IN ('object','folder')) AND object_localized_cs_product_hu_HU.o_published = 1 ORDER BY `o_creationDate` DESC LIMIT 5 Parameters: [`[ 727244 ] "Seiko 2025. Vol.1 - Presage 13"`] View formatted query View runnable query Explain query SELECT object_localized_cs_product_hu_HU.o_id as o_id, object_localized_cs_product_hu_HU.o_type as o_type FROM object_localized_cs_product_hu_HU WHERE ( o_id NOT IN (?) AND series = ? AND object_localized_cs_product_hu_HU.o_type IN ('object', 'folder') ) AND object_localized_cs_product_hu_HU.o_published = 1 ORDER BY `o_creationDate` DESC LIMIT 5 SELECT object_localized_cs_product_hu_HU.o_id as o_id, object_localized_cs_product_hu_HU.o_type as o_type FROM object_localized_cs_product_hu_HU WHERE (o_id NOT IN (727244) AND series = 'Seiko 2025. Vol.1 - Presage 13' AND object_localized_cs_product_hu_HU.o_type IN ('object','folder')) AND object_localized_cs_product_hu_HU.o_published = 1 ORDER BY `o_creationDate` DESC LIMIT 5;
64	1.39 ms	SELECT object_localized_cs_product_hu_HU.o_id as o_id, object_localized_cs_product_hu_HU.o_type as o_type FROM object_localized_cs_product_hu_HU WHERE (o_id NOT IN (?) AND subcollection = ? AND object_localized_cs_product_hu_HU.o_type IN ('object','folder')) AND object_localized_cs_product_hu_HU.o_published = 1 ORDER BY `o_creationDate` DESC LIMIT 3 Parameters: [`[ 727244 727243 727242 ] "Cocktail"`] View formatted query View runnable query Explain query SELECT object_localized_cs_product_hu_HU.o_id as o_id, object_localized_cs_product_hu_HU.o_type as o_type FROM object_localized_cs_product_hu_HU WHERE ( o_id NOT IN (?) AND subcollection = ? AND object_localized_cs_product_hu_HU.o_type IN ('object', 'folder') ) AND object_localized_cs_product_hu_HU.o_published = 1 ORDER BY `o_creationDate` DESC LIMIT 3 SELECT object_localized_cs_product_hu_HU.o_id as o_id, object_localized_cs_product_hu_HU.o_type as o_type FROM object_localized_cs_product_hu_HU WHERE (o_id NOT IN (727244, 727243, 727242) AND subcollection = 'Cocktail' AND object_localized_cs_product_hu_HU.o_type IN ('object','folder')) AND object_localized_cs_product_hu_HU.o_published = 1 ORDER BY `o_creationDate` DESC LIMIT 3;
65	0.46 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';
66	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: [`1769212888 [ "\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 > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_76', 'document_76');
67	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: [`1769212888 [ "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 > 1769212888 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');
68	0.29 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1769212888 [ "\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 > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0document_properties_76', 'document_properties_76');
69	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: [`1769212888 [ "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 > 1769212888 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');
70	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: [`1769212888 [ "\x00tags\x00object_375163" "object_375163" ]`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('\0tags\0object_375163', 'object_375163');
71	0.24 ms	SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?) Parameters: [`1769212888 [ "object_375163\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 > 1769212888 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('object_375163\0tags\0');
72	0.43 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';
73	0.26 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';
74	0.37 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;
75	0.94 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;
76	0.27 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\Core\Model\ProductStoreValues	No errors.
CoreShop\Component\Product\Model\ProductUnitDefinitionPrice	No errors.
CoreShop\Component\Core\Model\ProductUnitDefinitionPrice	No errors.
CoreShop\Component\Product\Model\ProductSpecificPriceRule	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.
CoreShop\Component\Product\Model\ProductUnitDefinition	No errors.
CoreShop\Component\Product\Model\ProductSpecificPriceRuleTranslation	No errors.

Symfony Profiler

https://www.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