Query Metrics
651
Database Queries
33
Different statements
51.73 ms
Query time
0
Invalid entities
4
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
36.79 ms (71.12%) |
464 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?)
Parameters:
[ 1790521170 "site_domain_c455a2a1012563c6c6dbec7cba3fc274" ] |
|
3.16 ms (6.11%) |
30 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?)
Parameters:
[ 1790521170 "system\x01tags\x01" "site\x01tags\x01" ] |
|
2.23 ms (4.31%) |
28 |
SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?)
Parameters:
[ 1790521170 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
|
1.86 ms (3.60%) |
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:
[ 1790521170 "document_417\x01tags\x01" "asset_1757\x01tags\x01" "asset_1875\x01tags\x01" "asset_1981\x01tags\x01" ] |
|
1.20 ms (2.31%) |
24 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_1055__320a2bbe84bc9e97cdc9e4c6be4afd69"
]
|
|
0.94 ms (1.81%) |
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:
[ 1790521170 "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.81 ms (1.56%) |
6 |
DELETE FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_2391__510387d18278e22cd419263b8e47ca9b"
]
|
|
0.70 ms (1.35%) |
26 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
|
0.68 ms (1.31%) |
6 |
INSERT INTO tmp_store (`id`, `data`, `tag`, `date`, `expiryDate`, `serialized`) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ "thumb_2391__510387d18278e22cd419263b8e47ca9b" "O:42:"Pimcore\Model\Asset\Image\Thumbnail\Config":18:{s:8:"\x00*\x00items";a:1:{i:0;a:2:{s:6:"method";s:12:"scaleByWidth";s:9:"arguments";a:2:{s:5:"width";i:600;s:11:"forceResize";b:0;}}}s:9:"\x00*\x00medias";a:0:{}s:7:"\x00*\x00name";s:38:"_auto_8cab7b8fbaad90d887e64d81fa53fec4";s:14:"\x00*\x00description";s:0:"";s:8:"\x00*\x00group";s:0:"";s:9:"\x00*\x00format";s:6:"SOURCE";s:10:"\x00*\x00quality";i:85;s:17:"\x00*\x00highResolution";d:1;s:16:"\x00*\x00preserveColor";b:0;s:26:"\x00*\x00forceProcessICCProfiles";b:0;s:19:"\x00*\x00preserveMetaData";b:0;s:15:"\x00*\x00rasterizeSVG";b:0;s:13:"\x00*\x00useCropBox";b:0;s:15:"\x00*\x00downloadable";b:0;s:19:"\x00*\x00modificationDate";N;s:15:"\x00*\x00creationDate";N;s:17:"\x00*\x00filenameSuffix";N;s:20:"\x00*\x00preserveAnimation";b:0;}" "thumbnail_deferred" 1790521170 1791125970 1 ] |
|
0.40 ms (0.77%) |
3 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/de/karriere/offene-stellen/" "ferienarbeiter-montage-logistik-m-w-d" ] |
|
0.37 ms (0.72%) |
2 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/de/karriere/offene-stellen/ferienarbeiter-montage-logistik-m-w-d"
]
|
|
0.36 ms (0.70%) |
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:
[ 1790521170 "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.29 ms (0.57%) |
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:
[ 1790521170 "document_1055\x01tags\x01" "asset_2839\x01tags\x01" "asset_2734\x01tags\x01" "asset_2736\x01tags\x01" "asset_2744\x01tags\x01" ] |
|
0.26 ms (0.51%) |
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:
[ 1790521170 "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.24 ms (0.47%) |
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/karriere/offene-stellen/ferienarbeiter-montage-logistik-m-w-d" "path" "auto_create" "/de/karriere/offene-stellen/ferienarbeiter-montage-logistik-m-w-d" "path_query" "https://langmatz-redesign.swhosting8b.de/de/karriere/offene-stellen/ferienarbeiter-montage-logistik-m-w-d" "entire_uri" ] |
|
0.14 ms (0.28%) |
4 |
SELECT `id`, `name` FROM classes WHERE id = ?
Parameters:
[
"cs_order"
]
|
|
0.14 ms (0.26%) |
2 |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
1055
]
|
|
0.13 ms (0.26%) |
2 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
1055
]
|
|
0.13 ms (0.25%) |
1 |
SELECT * FROM translations_messages
Parameters:
[] |
|
0.10 ms (0.19%) |
2 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
|
0.09 ms (0.18%) |
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:
[ 1790521170 "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.18%) |
2 |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
412
]
|
|
0.09 ms (0.18%) |
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:
[ 1790521170 "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.16%) |
1 |
SELECT * FROM object_relations_ste WHERE src_id = ?
Parameters:
[
1846
]
|
|
0.08 ms (0.15%) |
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.06 ms (0.12%) |
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.06 ms (0.11%) |
1 |
SELECT object_localized_ste_de.id as id, object_localized_ste_de.type as `type` FROM object_localized_ste_de WHERE ( object_localized_ste_de.type IN ('object','variant','folder')) AND object_localized_ste_de.published = 1
Parameters:
[] |
|
0.05 ms (0.09%) |
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.05 ms (0.09%) |
2 |
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 412 412 412 ] |
|
0.04 ms (0.08%) |
1 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
412
]
|
|
0.04 ms (0.08%) |
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.07%) |
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.05%) |
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 |