Query Metrics

170 Database Queries
23 Different statements
51.29 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 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:
[
  1769237156
  [
    "\x00tags\x00site_domain_30b361376c41bdfc6ac22d9a0797cc4b"
    "site_domain_30b361376c41bdfc6ac22d9a0797cc4b"
  ]
]
2 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:
[
  1769237156
  [
    "system\x00tags\x00"
    "site\x00tags\x00"
    "site_domain_30b361376c41bdfc6ac22d9a0797cc4b\x00tags\x00"
  ]
]
3 0.41 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/SPB155J1"
  "sourcePathQuery" => "/ora/SPB155J1"
  "sourceEntireUri" => "https://boutique.local.szerver.online/ora/SPB155J1"
  "typePath" => "path"
  "typePathQuery" => "path_query"
  "typeEntireUri" => "entire_uri"
  "typeAuto" => "auto_create"
]
4 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:
[
  1769237156
  [
    "\x00tags\x00system_route_redirect"
    "system_route_redirect"
  ]
]
5 0.23 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237156
  [
    "system\x00tags\x00"
    "redirect\x00tags\x00"
    "route\x00tags\x00"
    "system_route_redirect\x00tags\x00"
  ]
]
6 0.17 ms
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[
  "id" => "reports"
  "scope" => "pimcore"
]
7 0.22 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "SPB155J1"
  "path" => "/ora/"
]
8 0.14 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/ora/SPB155J1"
]
9 0.15 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "ora"
  "path" => "/"
]
10 0.11 ms
SELECT id FROM documents_page WHERE prettyUrl = :prettyUrl
Parameters:
[
  "prettyUrl" => "/ora"
]
11 0.13 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => ""
  "path" => "/"
]
12 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:
[
  1769237156
  [
    "\x00tags\x00document_1"
    "document_1"
  ]
]
13 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:
[
  1769237156
  [
    "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"
  ]
]
14 0.15 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237156
  [
    "\x00tags\x00document_properties_1"
    "document_properties_1"
  ]
]
15 0.14 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237156
  [
    "document_properties\x00tags\x00"
    "document_1\x00tags\x00"
    "document_properties_1\x00tags\x00"
  ]
]
16 0.69 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
]
17 0.38 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "cs_order"
]
18 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:
[
  1769237157
  [
    "\x00tags\x00system_supported_locales_hu"
    "system_supported_locales_hu"
  ]
]
19 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:
[
  1769237157
  [
    "system\x00tags\x00"
    "system_supported_locales_hu\x00tags\x00"
  ]
]
20 0.35 ms
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[]
21 0.37 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "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` = 'SPB155J1'  AND  object_localized_cs_product_hu_HU.o_type IN ('object','folder') LIMIT 1
Parameters:
[]
23 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:
[
  1769237157
  [
    "\x00tags\x00object_4124"
    "object_4124"
  ]
]
24 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:
[
  1769237157
  [
    "object_4124\x00tags\x00"
    "class_cs_product\x00tags\x00"
  ]
]
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:
[
  1769237157
  [
    "\x00tags\x00asset_20209"
    "asset_20209"
  ]
]
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:
[
  1769237157
  [
    "asset_20209\x00tags\x00"
  ]
]
27 0.45 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "\x00tags\x00object_375232"
    "object_375232"
  ]
]
28 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:
[
  1769237157
  [
    "object_375232\x00tags\x00"
    "class_cs_category\x00tags\x00"
    "asset_16791\x00tags\x00"
  ]
]
29 0.20 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "cs_category"
]
30 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:
[
  1769237157
  [
    "\x00tags\x00object_375256"
    "object_375256"
  ]
]
31 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:
[
  1769237157
  [
    "object_375256\x00tags\x00"
    "class_cs_category\x00tags\x00"
    "asset_25766\x00tags\x00"
  ]
]
32 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:
[
  1769237157
  [
    "\x00tags\x00object_598267"
    "object_598267"
  ]
]
33 0.20 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "object_598267\x00tags\x00"
    "class_cs_category\x00tags\x00"
    "asset_21649\x00tags\x00"
  ]
]
34 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:
[
  1769237157
  [
    "\x00tags\x00object_598268"
    "object_598268"
  ]
]
35 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:
[
  1769237157
  [
    "object_598268\x00tags\x00"
    "class_cs_category\x00tags\x00"
    "asset_23442\x00tags\x00"
    "asset_16665\x00tags\x00"
  ]
]
36 0.38 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:
[
  4124
]
37 0.24 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:
[]
38 0.41 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:
[
  4124
]
39 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:
[
  1769237157
  [
    "\x00tags\x00object_4"
    "object_4"
  ]
]
40 0.08 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "object_4\x00tags\x00"
  ]
]
41 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:
[
  1769237157
  [
    "\x00tags\x00object_2"
    "object_2"
  ]
]
42 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:
[
  1769237157
  [
    "object_2\x00tags\x00"
  ]
]
43 0.08 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "\x00tags\x00object_1"
    "object_1"
  ]
]
44 0.04 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "object_1\x00tags\x00"
  ]
]
45 0.11 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "cs_address"
]
46 0.27 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
]
47 2.86 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:
[
  [
    4124
  ]
  "Seiko - Prospex Alpinist"
]
48 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:
[
  1769237157
  [
    "\x00tags\x00object_4102"
    "object_4102"
  ]
]
49 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:
[
  1769237157
  [
    "object_4102\x00tags\x00"
    "class_cs_product\x00tags\x00"
  ]
]
50 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:
[
  1769237157
  [
    "\x00tags\x00object_4082"
    "object_4082"
  ]
]
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:
[
  1769237157
  [
    "object_4082\x00tags\x00"
    "class_cs_product\x00tags\x00"
  ]
]
52 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:
[
  1769237157
  [
    "\x00tags\x00object_4058"
    "object_4058"
  ]
]
53 0.20 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "object_4058\x00tags\x00"
    "class_cs_product\x00tags\x00"
  ]
]
54 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:
[
  1769237157
  [
    "\x00tags\x00object_3453"
    "object_3453"
  ]
]
55 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:
[
  1769237157
  [
    "object_3453\x00tags\x00"
    "class_cs_product\x00tags\x00"
  ]
]
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 1
Parameters:
[
  [
    4124
    4102
    4082
    4058
    3453
  ]
  "Land"
]
57 0.45 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "\x00tags\x00object_458642"
    "object_458642"
  ]
]
58 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:
[
  1769237157
  [
    "object_458642\x00tags\x00"
    "class_cs_product\x00tags\x00"
  ]
]
59 4.84 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:
[
  [
    4124
  ]
  "Seiko - Prospex Alpinist"
]
60 1.10 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 1
Parameters:
[
  [
    4124
    4102
    4082
    4058
    3453
  ]
  "Land"
]
61 0.41 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "header"
  "path" => "/shared/"
]
62 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:
[
  1769237157
  [
    "\x00tags\x00document_76"
    "document_76"
  ]
]
63 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:
[
  1769237157
  [
    "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"
  ]
]
64 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:
[
  1769237157
  [
    "\x00tags\x00document_properties_76"
    "document_properties_76"
  ]
]
65 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:
[
  1769237157
  [
    "document_properties\x00tags\x00"
    "document_76\x00tags\x00"
    "document_properties_76\x00tags\x00"
  ]
]
66 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:
[
  1769237157
  [
    "\x00tags\x00object_375163"
    "object_375163"
  ]
]
67 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:
[
  1769237157
  [
    "object_375163\x00tags\x00"
  ]
]
68 0.35 ms
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
69 0.23 ms
SELECT id FROM settings_store WHERE scope = ?
Parameters:
[
  "pimcore_staticroutes"
]
70 0.52 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:
[]
71 2.02 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
]
72 0.43 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"
]
73 0.45 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  76
]
74 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:
[
  1769237157
  [
    "\x00tags\x00document_12"
    "document_12"
  ]
]
75 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:
[
  1769237157
  [
    "document_12\x00tags\x00"
  ]
]
76 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:
[
  1769237157
  [
    "\x00tags\x00document_78"
    "document_78"
  ]
]
77 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:
[
  1769237157
  [
    "document_78\x00tags\x00"
    "asset_17203\x00tags\x00"
    "asset_17204\x00tags\x00"
    "asset_17205\x00tags\x00"
    "asset_17211\x00tags\x00"
    "asset_17216\x00tags\x00"
    "asset_17215\x00tags\x00"
    "asset_17214\x00tags\x00"
    "asset_17213\x00tags\x00"
    "asset_17212\x00tags\x00"
  ]
]
78 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:
[
  1769237157
  [
    "\x00tags\x00document_101"
    "document_101"
  ]
]
79 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:
[
  1769237157
  [
    "document_101\x00tags\x00"
    "asset_25124\x00tags\x00"
    "asset_25745\x00tags\x00"
    "asset_25123\x00tags\x00"
    "asset_25744\x00tags\x00"
    "asset_25122\x00tags\x00"
    "asset_25743\x00tags\x00"
    "asset_26588\x00tags\x00"
    "asset_26589\x00tags\x00"
  ]
]
80 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:
[
  1769237157
  [
    "\x00tags\x00document_73"
    "document_73"
  ]
]
81 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:
[
  1769237157
  [
    "document_73\x00tags\x00"
  ]
]
82 0.17 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "\x00tags\x00document_13"
    "document_13"
  ]
]
83 0.12 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "document_13\x00tags\x00"
  ]
]
84 0.20 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "\x00tags\x00document_71"
    "document_71"
  ]
]
85 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:
[
  1769237157
  [
    "document_71\x00tags\x00"
    "asset_15304\x00tags\x00"
  ]
]
86 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:
[
  1769237157
  [
    "\x00tags\x00asset_16826"
    "asset_16826"
  ]
]
87 0.20 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "\x00tags\x00asset_20648"
    "asset_20648"
  ]
]
88 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:
[
  1769237157
  [
    "\x00tags\x00document_91"
    "document_91"
  ]
]
89 0.20 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "document_91\x00tags\x00"
    "asset_9832\x00tags\x00"
  ]
]
90 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:
[
  1769237157
  [
    "\x00tags\x00asset_20603"
    "asset_20603"
  ]
]
91 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:
[
  1769237157
  [
    "\x00tags\x00document_92"
    "document_92"
  ]
]
92 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:
[
  1769237157
  [
    "document_92\x00tags\x00"
    "asset_15672\x00tags\x00"
    "asset_10633\x00tags\x00"
  ]
]
93 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:
[
  1769237157
  [
    "\x00tags\x00asset_20600"
    "asset_20600"
  ]
]
94 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:
[
  1769237157
  [
    "\x00tags\x00document_90"
    "document_90"
  ]
]
95 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:
[
  1769237157
  [
    "document_90\x00tags\x00"
    "asset_10656\x00tags\x00"
  ]
]
96 0.17 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "\x00tags\x00asset_20602"
    "asset_20602"
  ]
]
97 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:
[
  1769237157
  [
    "\x00tags\x00document_93"
    "document_93"
  ]
]
98 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:
[
  1769237157
  [
    "document_93\x00tags\x00"
    "asset_9855\x00tags\x00"
  ]
]
99 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:
[
  1769237157
  [
    "\x00tags\x00asset_20601"
    "asset_20601"
  ]
]
100 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:
[
  1769237157
  [
    "\x00tags\x00document_94"
    "document_94"
  ]
]
101 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:
[
  1769237157
  [
    "document_94\x00tags\x00"
  ]
]
102 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:
[
  1769237157
  [
    "\x00tags\x00asset_20599"
    "asset_20599"
  ]
]
103 0.17 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "\x00tags\x00document_25"
    "document_25"
  ]
]
104 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:
[
  1769237157
  [
    "document_25\x00tags\x00"
    "asset_15787\x00tags\x00"
    "asset_11600\x00tags\x00"
  ]
]
105 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:
[
  1769237157
  [
    "\x00tags\x00asset_16823"
    "asset_16823"
  ]
]
106 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:
[
  1769237157
  [
    "\x00tags\x00document_20"
    "document_20"
  ]
]
107 0.14 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "document_20\x00tags\x00"
    "asset_15674\x00tags\x00"
    "asset_12989\x00tags\x00"
  ]
]
108 0.14 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "\x00tags\x00asset_16821"
    "asset_16821"
  ]
]
109 0.14 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "\x00tags\x00document_22"
    "document_22"
  ]
]
110 0.13 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "document_22\x00tags\x00"
    "asset_15785\x00tags\x00"
    "asset_12860\x00tags\x00"
  ]
]
111 0.14 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "\x00tags\x00asset_16825"
    "asset_16825"
  ]
]
112 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:
[
  1769237157
  [
    "\x00tags\x00document_23"
    "document_23"
  ]
]
113 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:
[
  1769237157
  [
    "document_23\x00tags\x00"
    "asset_15782\x00tags\x00"
    "asset_12077\x00tags\x00"
  ]
]
114 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:
[
  1769237157
  [
    "\x00tags\x00asset_16824"
    "asset_16824"
  ]
]
115 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:
[
  1769237157
  [
    "\x00tags\x00document_24"
    "document_24"
  ]
]
116 0.14 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "document_24\x00tags\x00"
    "asset_15784\x00tags\x00"
    "asset_12043\x00tags\x00"
  ]
]
117 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:
[
  1769237157
  [
    "\x00tags\x00asset_16820"
    "asset_16820"
  ]
]
118 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:
[
  1769237157
  [
    "\x00tags\x00asset_20642"
    "asset_20642"
  ]
]
119 0.17 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "\x00tags\x00asset_21858"
    "asset_21858"
  ]
]
120 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:
[
  1769237157
  [
    "\x00tags\x00object_270"
    "object_270"
  ]
]
121 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:
[
  1769237157
  [
    "object_270\x00tags\x00"
    "class_1\x00tags\x00"
  ]
]
122 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:
[
  1769237157
  [
    "\x00tags\x00website_config"
    "website_config"
  ]
]
123 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:
[
  1769237157
  [
    "website_config\x00tags\x00"
    "system\x00tags\x00"
    "config\x00tags\x00"
    "output\x00tags\x00"
    "asset_15304\x00tags\x00"
  ]
]
124 0.35 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 20209
]
125 0.24 ms
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
126 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:
[
  1769237157
  [
    "\x00tags\x00translation_data_6431352cea3285deadebc5c2a566a87b"
    "translation_data_6431352cea3285deadebc5c2a566a87b"
  ]
]
127 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:
[
  1769237157
  [
    "translator\x00tags\x00"
    "translator_website\x00tags\x00"
    "translate\x00tags\x00"
    "translation_data_6431352cea3285deadebc5c2a566a87b\x00tags\x00"
  ]
]
128 0.17 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "2"
]
129 0.39 ms
SELECT object_2.o_id as o_id, object_2.o_type as o_type FROM object_2 WHERE (`title` = '6R35'  AND  object_2.o_type IN ('object','folder')) AND object_2.o_published = 1 LIMIT 1
Parameters:
[]
130 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:
[
  1769237157
  [
    "\x00tags\x00object_724626"
    "object_724626"
  ]
]
131 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:
[
  1769237157
  [
    "object_724626\x00tags\x00"
    "class_2\x00tags\x00"
  ]
]
132 0.17 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "\x00tags\x00asset_15762"
    "asset_15762"
  ]
]
133 0.13 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "asset_15762\x00tags\x00"
  ]
]
134 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:
[
  1769237157
  [
    "\x00tags\x00asset_11519"
    "asset_11519"
  ]
]
135 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:
[
  1769237157
  [
    "asset_11519\x00tags\x00"
  ]
]
136 0.24 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 11519
]
137 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:
[
  1769237157
  [
    "\x00tags\x00asset_11562"
    "asset_11562"
  ]
]
138 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:
[
  1769237157
  [
    "asset_11562\x00tags\x00"
  ]
]
139 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:
[
  1769237157
  [
    "\x00tags\x00asset_11563"
    "asset_11563"
  ]
]
140 0.17 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "asset_11563\x00tags\x00"
  ]
]
141 0.26 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 11562
]
142 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:
[
  1769237157
  [
    "\x00tags\x00asset_11566"
    "asset_11566"
  ]
]
143 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:
[
  1769237157
  [
    "asset_11566\x00tags\x00"
  ]
]
144 0.18 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 11566
]
145 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:
[
  1769237157
  [
    "\x00tags\x00asset_20214"
    "asset_20214"
  ]
]
146 0.14 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "asset_20214\x00tags\x00"
  ]
]
147 0.27 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 20214
]
148 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:
[
  1769237157
  [
    "\x00tags\x00asset_17359"
    "asset_17359"
  ]
]
149 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:
[
  1769237157
  [
    "asset_17359\x00tags\x00"
  ]
]
150 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:
[
  1769237157
  [
    "\x00tags\x00asset_17360"
    "asset_17360"
  ]
]
151 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:
[
  1769237157
  [
    "asset_17360\x00tags\x00"
  ]
]
152 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:
[
  1769237157
  [
    "\x00tags\x00asset_17361"
    "asset_17361"
  ]
]
153 0.14 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "asset_17361\x00tags\x00"
  ]
]
154 0.14 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "\x00tags\x00asset_17362"
    "asset_17362"
  ]
]
155 0.12 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "asset_17362\x00tags\x00"
  ]
]
156 0.17 ms
SELECT * FROM assets_image_thumbnail_cache WHERE cid = :cid
Parameters:
[
  "cid" => 17359
]
157 0.19 ms
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[
  "key" => "footer"
  "path" => "/shared/"
]
158 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:
[
  1769237157
  [
    "\x00tags\x00document_77"
    "document_77"
  ]
]
159 0.12 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "document_77\x00tags\x00"
  ]
]
160 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:
[
  1769237157
  [
    "\x00tags\x00document_properties_77"
    "document_properties_77"
  ]
]
161 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:
[
  1769237157
  [
    "document_properties\x00tags\x00"
    "document_77\x00tags\x00"
    "document_properties_77\x00tags\x00"
  ]
]
162 0.23 ms
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  77
]
163 0.17 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "\x00tags\x00document_19"
    "document_19"
  ]
]
164 0.15 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "document_19\x00tags\x00"
    "asset_15672\x00tags\x00"
    "asset_10642\x00tags\x00"
  ]
]
165 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:
[
  1769237157
  [
    "\x00tags\x00document_108"
    "document_108"
  ]
]
166 0.13 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "document_108\x00tags\x00"
  ]
]
167 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:
[
  1769237157
  [
    "\x00tags\x00document_17"
    "document_17"
  ]
]
168 0.12 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "document_17\x00tags\x00"
  ]
]
169 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:
[
  1769237157
  [
    "\x00tags\x00document_18"
    "document_18"
  ]
]
170 0.12 ms
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1769237157
  [
    "document_18\x00tags\x00"
  ]
]

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.
CoreShop\Component\Product\Model\ProductUnitDefinitions No errors.
CoreShop\Component\Product\Model\ProductUnit No errors.
CoreShop\Component\Product\Model\ProductUnitTranslation No errors.