GET https://langmatz-redesign.swhosting8b.de/de/produkte/kabelschaechte/details-qabo/bodenplatte

Query Metrics

565 Database Queries
30 Different statements
33.00 ms Query time
0 Invalid entities
4 Managed entities

Grouped Statements

Show all queries

Time▼ Count Info
26.10 ms
(79.09%)
438
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[
  1790517581
  "site_domain_c455a2a1012563c6c6dbec7cba3fc274"
]
1.04 ms
(3.15%)
25
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?)
Parameters:
[
  1790517581
  "document_984\x01tags\x01"
  "asset_1757\x01tags\x01"
  "asset_2709\x01tags\x01"
  "asset_2708\x01tags\x01"
]
0.99 ms
(3.01%)
17
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
Parameters:
[
  1790517581
  "system\x01tags\x01"
  "redirect\x01tags\x01"
  "route\x01tags\x01"
]
0.72 ms
(2.18%)
10
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[
  1790517581
  "system\x01tags\x01"
  "site\x01tags\x01"
]
0.61 ms
(1.86%)
18
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "thumb_1757__fe062e004cab042641327fd0803ae5db"
]
0.56 ms
(1.70%)
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1790517582
  "output\x01tags\x01"
  "navigation\x01tags\x01"
  "document_975\x01tags\x01"
  "document_976\x01tags\x01"
  "document_977\x01tags\x01"
  "document_978\x01tags\x01"
  "document_1067\x01tags\x01"
  "document_417\x01tags\x01"
  "document_970\x01tags\x01"
  "document_964\x01tags\x01"
  "document_966\x01tags\x01"
  "document_967\x01tags\x01"
  "document_968\x01tags\x01"
  "document_969\x01tags\x01"
  "document_986\x01tags\x01"
  "document_987\x01tags\x01"
  "document_988\x01tags\x01"
  "document_989\x01tags\x01"
  "document_990\x01tags\x01"
  "document_991\x01tags\x01"
  "document_992\x01tags\x01"
  "document_993\x01tags\x01"
  "document_994\x01tags\x01"
  "document_672\x01tags\x01"
  "document_995\x01tags\x01"
  "document_1044\x01tags\x01"
  "document_1045\x01tags\x01"
  "document_1046\x01tags\x01"
  "document_1047\x01tags\x01"
  "document_1048\x01tags\x01"
  "document_1049\x01tags\x01"
  "document_1050\x01tags\x01"
  "document_1051\x01tags\x01"
  "document_1052\x01tags\x01"
  "document_1053\x01tags\x01"
  "document_965\x01tags\x01"
  "document_985\x01tags\x01"
  "document_980\x01tags\x01"
  "document_981\x01tags\x01"
  "document_1066\x01tags\x01"
  "document_1065\x01tags\x01"
  "document_1064\x01tags\x01"
  "document_983\x01tags\x01"
  "document_984\x01tags\x01"
  "document_1120\x01tags\x01"
  "document_1119\x01tags\x01"
  "document_1148\x01tags\x01"
  "document_1149\x01tags\x01"
  "document_1121\x01tags\x01"
  "document_1061\x01tags\x01"
  "document_1114\x01tags\x01"
  "document_1115\x01tags\x01"
  "document_1116\x01tags\x01"
  "document_1117\x01tags\x01"
  "document_1118\x01tags\x01"
  "document_1055\x01tags\x01"
  "document_342\x01tags\x01"
  "document_572\x01tags\x01"
  "document_87\x01tags\x01"
  "document_523\x01tags\x01"
  "document_524\x01tags\x01"
  "document_525\x01tags\x01"
  "document_526\x01tags\x01"
  "document_1372\x01tags\x01"
  "document_1373\x01tags\x01"
  "document_147\x01tags\x01"
  "document_94\x01tags\x01"
  "document_1250\x01tags\x01"
  "document_1251\x01tags\x01"
  "document_1252\x01tags\x01"
  "document_1253\x01tags\x01"
  "document_1255\x01tags\x01"
  "document_1249\x01tags\x01"
  "document_527\x01tags\x01"
  "document_528\x01tags\x01"
  "document_529\x01tags\x01"
  "document_530\x01tags\x01"
  "document_531\x01tags\x01"
  "document_532\x01tags\x01"
  "document_533\x01tags\x01"
  "document_534\x01tags\x01"
  "document_959\x01tags\x01"
  "document_101\x01tags\x01"
  "document_925\x01tags\x01"
  "document_926\x01tags\x01"
  "document_927\x01tags\x01"
  "document_928\x01tags\x01"
  "document_929\x01tags\x01"
  "document_924\x01tags\x01"
  "document_954\x01tags\x01"
  "document_957\x01tags\x01"
  "document_955\x01tags\x01"
  "document_956\x01tags\x01"
  "document_958\x01tags\x01"
  "document_948\x01tags\x01"
  "document_930\x01tags\x01"
  "document_540\x01tags\x01"
  "document_541\x01tags\x01"
  "document_542\x01tags\x01"
  "document_755\x01tags\x01"
  "document_756\x01tags\x01"
  "document_272\x01tags\x01"
  "document_543\x01tags\x01"
  "document_961\x01tags\x01"
  "document_962\x01tags\x01"
  "document_85\x01tags\x01"
  "document_544\x01tags\x01"
  "document_545\x01tags\x01"
  "document_1113\x01tags\x01"
  "document_546\x01tags\x01"
  "document_547\x01tags\x01"
  "document_84\x01tags\x01"
  "document_548\x01tags\x01"
  "document_549\x01tags\x01"
  "document_550\x01tags\x01"
  "document_56\x01tags\x01"
  "document_669\x01tags\x01"
  "document_552\x01tags\x01"
  "document_553\x01tags\x01"
  "document_554\x01tags\x01"
  "document_51\x01tags\x01"
  "document_555\x01tags\x01"
  "document_556\x01tags\x01"
  "document_558\x01tags\x01"
  "document_559\x01tags\x01"
  "document_55\x01tags\x01"
  "document_41\x01tags\x01"
  "document_565\x01tags\x01"
  "document_566\x01tags\x01"
  "document_567\x01tags\x01"
  "document_1219\x01tags\x01"
  "document_1222\x01tags\x01"
  "document_1220\x01tags\x01"
  "document_1218\x01tags\x01"
  "document_569\x01tags\x01"
  "document_570\x01tags\x01"
  "document_571\x01tags\x01"
  "document_333\x01tags\x01"
  "document_1238\x01tags\x01"
  "document_1241\x01tags\x01"
  "document_1240\x01tags\x01"
  "document_1236\x01tags\x01"
  "document_1235\x01tags\x01"
  "document_401\x01tags\x01"
  "document_351\x01tags\x01"
  "document_352\x01tags\x01"
  "document_353\x01tags\x01"
  "document_354\x01tags\x01"
  "document_355\x01tags\x01"
  "document_356\x01tags\x01"
  "document_382\x01tags\x01"
  "document_363\x01tags\x01"
  "document_412\x01tags\x01"
  "document_805\x01tags\x01"
  "document_806\x01tags\x01"
  "document_807\x01tags\x01"
  "document_809\x01tags\x01"
  "document_810\x01tags\x01"
  "document_811\x01tags\x01"
  "document_812\x01tags\x01"
  "document_813\x01tags\x01"
  "document_823\x01tags\x01"
  "document_830\x01tags\x01"
  "document_365\x01tags\x01"
  "document_814\x01tags\x01"
  "document_816\x01tags\x01"
  "document_817\x01tags\x01"
  "document_818\x01tags\x01"
  "document_819\x01tags\x01"
  "document_366\x01tags\x01"
  "document_367\x01tags\x01"
  "document_46\x01tags\x01"
  "document_374\x01tags\x01"
  "document_375\x01tags\x01"
  "document_1229\x01tags\x01"
  "document_1230\x01tags\x01"
  "document_1231\x01tags\x01"
  "document_1232\x01tags\x01"
  "document_1233\x01tags\x01"
  "document_1234\x01tags\x01"
  "document_1228\x01tags\x01"
  "document_49\x01tags\x01"
  "document_729\x01tags\x01"
  "document_719\x01tags\x01"
  "document_751\x01tags\x01"
  "document_752\x01tags\x01"
  "document_753\x01tags\x01"
  "document_754\x01tags\x01"
  "document_720\x01tags\x01"
  "document_760\x01tags\x01"
  "document_761\x01tags\x01"
  "document_762\x01tags\x01"
  "document_763\x01tags\x01"
  "document_764\x01tags\x01"
  "document_765\x01tags\x01"
  "document_766\x01tags\x01"
  "document_767\x01tags\x01"
  "document_794\x01tags\x01"
  "document_795\x01tags\x01"
  "document_721\x01tags\x01"
  "document_768\x01tags\x01"
  "document_769\x01tags\x01"
  "document_770\x01tags\x01"
  "document_771\x01tags\x01"
  "document_772\x01tags\x01"
  "document_722\x01tags\x01"
  "document_773\x01tags\x01"
  "document_774\x01tags\x01"
  "document_775\x01tags\x01"
  "document_776\x01tags\x01"
  "document_777\x01tags\x01"
  "document_723\x01tags\x01"
  "document_778\x01tags\x01"
  "document_1087\x01tags\x01"
  "document_1088\x01tags\x01"
  "document_724\x01tags\x01"
  "document_779\x01tags\x01"
  "document_780\x01tags\x01"
  "document_781\x01tags\x01"
  "document_782\x01tags\x01"
  "document_725\x01tags\x01"
  "document_783\x01tags\x01"
  "document_784\x01tags\x01"
  "document_785\x01tags\x01"
  "document_726\x01tags\x01"
  "document_786\x01tags\x01"
  "document_787\x01tags\x01"
  "document_788\x01tags\x01"
  "document_789\x01tags\x01"
  "document_727\x01tags\x01"
  "document_790\x01tags\x01"
  "document_791\x01tags\x01"
  "document_792\x01tags\x01"
  "document_793\x01tags\x01"
  "document_728\x01tags\x01"
  "document_718\x01tags\x01"
  "document_383\x01tags\x01"
  "document_384\x01tags\x01"
  "document_387\x01tags\x01"
  "document_388\x01tags\x01"
  "document_921\x01tags\x01"
  "document_385\x01tags\x01"
  "document_386\x01tags\x01"
  "document_1212\x01tags\x01"
  "document_1215\x01tags\x01"
  "document_1216\x01tags\x01"
  "document_1217\x01tags\x01"
  "document_1213\x01tags\x01"
  "document_61\x01tags\x01"
  "document_104\x01tags\x01"
  "document_103\x01tags\x01"
  "document_109\x01tags\x01"
  "document_114\x01tags\x01"
  "document_113\x01tags\x01"
  "document_115\x01tags\x01"
  "document_111\x01tags\x01"
  "document_815\x01tags\x01"
  "document_112\x01tags\x01"
  "document_126\x01tags\x01"
  "document_127\x01tags\x01"
  "document_132\x01tags\x01"
  "document_133\x01tags\x01"
  "document_143\x01tags\x01"
  "document_145\x01tags\x01"
  "document_148\x01tags\x01"
  "document_153\x01tags\x01"
  "document_152\x01tags\x01"
  "document_154\x01tags\x01"
  "document_325\x01tags\x01"
  "document_347\x01tags\x01"
  "document_879\x01tags\x01"
  "document_878\x01tags\x01"
]
0.48 ms
(1.46%)
20
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[
  "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle"
  "pimcore"
]
0.36 ms
(1.09%)
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 (?, ?, ?, ?, ?, ?)
Parameters:
[
  1790517582
  "document_954\x01tags\x01"
  "asset_2397\x01tags\x01"
  "asset_2398\x01tags\x01"
  "asset_2527\x01tags\x01"
  "asset_2528\x01tags\x01"
  "asset_2529\x01tags\x01"
]
0.21 ms
(0.63%)
1
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
  984
]
0.17 ms
(0.53%)
1
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/de/produkte/kabelschaechte/details-qabo/"
  "bodenplatte"
]
0.16 ms
(0.47%)
2
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[
  984
  984
  984
]
0.15 ms
(0.46%)
1
SELECT * FROM redirects WHERE
            (
                (source = ? AND (`type` = ? OR `type` = ?)) OR
                (source = ? AND `type` = ?) OR
                (source = ? AND `type` = ?)
            ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC
Parameters:
[
  "/de/produkte/kabelschaechte/details-qabo/bodenplatte"
  "path"
  "auto_create"
  "/de/produkte/kabelschaechte/details-qabo/bodenplatte"
  "path_query"
  "https://langmatz-redesign.swhosting8b.de/de/produkte/kabelschaechte/details-qabo/bodenplatte"
  "entire_uri"
]
0.14 ms
(0.44%)
2
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
  984
]
0.12 ms
(0.37%)
2
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
  1757
]
0.12 ms
(0.36%)
2
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?)
Parameters:
[
  1790517582
  "document_1055\x01tags\x01"
  "asset_2839\x01tags\x01"
  "asset_2734\x01tags\x01"
  "asset_2736\x01tags\x01"
  "asset_2744\x01tags\x01"
]
0.12 ms
(0.35%)
1
SELECT * FROM translations_messages
Parameters:
[]
0.11 ms
(0.35%)
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1790517582
  "document_3\x01tags\x01"
  "document_1\x01tags\x01"
  "asset_2840\x01tags\x01"
  "asset_1640\x01tags\x01"
  "asset_693\x01tags\x01"
  "asset_823\x01tags\x01"
  "asset_314\x01tags\x01"
  "asset_663\x01tags\x01"
  "asset_714\x01tags\x01"
  "asset_727\x01tags\x01"
  "asset_887\x01tags\x01"
  "asset_1633\x01tags\x01"
  "asset_1631\x01tags\x01"
  "asset_1632\x01tags\x01"
  "asset_2067\x01tags\x01"
  "asset_2724\x01tags\x01"
  "asset_2281\x01tags\x01"
  "asset_2710\x01tags\x01"
  "asset_2799\x01tags\x01"
]
0.11 ms
(0.35%)
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 (?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1790517582
  "document_384\x01tags\x01"
  "asset_1679\x01tags\x01"
  "asset_1015\x01tags\x01"
  "asset_1019\x01tags\x01"
  "asset_1016\x01tags\x01"
  "asset_1018\x01tags\x01"
  "asset_1017\x01tags\x01"
  "asset_1020\x01tags\x01"
  "asset_1023\x01tags\x01"
  "asset_1022\x01tags\x01"
]
0.09 ms
(0.26%)
1
SELECT * FROM object_url_slugs WHERE slug = '/de/produkte/kabelschaechte/details-qabo/bodenplatte' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[]
0.09 ms
(0.26%)
2
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
  1757
]
0.09 ms
(0.26%)
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 (?, ?, ?, ?, ?, ?, ?)
Parameters:
[
  1790517582
  "document_924\x01tags\x01"
  "asset_1297\x01tags\x01"
  "asset_1760\x01tags\x01"
  "asset_975\x01tags\x01"
  "asset_971\x01tags\x01"
  "asset_976\x01tags\x01"
  "asset_972\x01tags\x01"
]
0.08 ms
(0.24%)
2
SELECT object_srchSg.id as id, object_srchSg.type as `type` FROM object_srchSg WHERE ( object_srchSg.type IN ('object','variant','folder')) AND object_srchSg.published = 1
Parameters:
[]
0.07 ms
(0.21%)
2
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
  "cs_order"
]
0.06 ms
(0.20%)
2
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[]
0.06 ms
(0.17%)
2
SELECT * FROM translations_admin LIMIT 1;
Parameters:
[]
0.04 ms
(0.13%)
1
SELECT c0_.name AS name_0, c0_.template AS template_1, c0_.isDefault AS isDefault_2, c0_.siteId AS siteId_3, c0_.creationDate AS creationDate_4, c0_.modificationDate AS modificationDate_5, c0_.id AS id_6, c0_.useGrossPrice AS useGrossPrice_7, c0_.currencyId AS currencyId_8, c0_.baseCountryId AS baseCountryId_9 FROM coreshop_store c0_ WHERE c0_.isDefault = 1
Parameters:
[]
0.04 ms
(0.12%)
1
SELECT t0.isoCode AS isoCode_1, t0.active AS active_2, t0.addressFormat AS addressFormat_3, t0.salutations AS salutations_4, t0.creationDate AS creationDate_5, t0.modificationDate AS modificationDate_6, t0.id AS id_7, t0.zoneId AS zoneId_8, t0.currencyId AS currencyId_9 FROM coreshop_country t0 WHERE t0.id IN (?)
Parameters:
[
  56
]
0.04 ms
(0.12%)
1
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
]
0.04 ms
(0.11%)
1
SELECT t0.configKey AS configKey_1, t0.data AS data_2, t0.creationDate AS creationDate_3, t0.modificationDate AS modificationDate_4, t0.id AS id_5, t0.store_id AS store_id_6 FROM coreshop_configuration t0 WHERE t0.store_id IN (?)
Parameters:
[
  1
]
0.02 ms
(0.07%)
1
SELECT * FROM translations_website
Parameters:
[]

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.

Managed Entities

default entity manager

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