Symfony Profiler

Query Metrics

437 Database Queries

30 Different statements

13.28 ms Query time

0 Invalid entities

4 Managed entities

Grouped Statements

Time▼	Count	Info
8.66 ms (65.19%)	312	SELECT item_id, 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: [`1790520730 "site_domain_c455a2a1012563c6c6dbec7cba3fc274"`] 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 > 1790520730 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('site_domain_c455a2a1012563c6c6dbec7cba3fc274');
0.92 ms (6.92%)	23	SELECT item_id, 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: [`1790520730 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790520730 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'redirecttags', 'routetags');
0.53 ms (4.01%)	2	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: [`"/en/contact/sales" "path" "auto_create" "/en/contact/sales" "path_query" "https://langmatz-redesign.swhosting8b.de/en/contact/sales" "entire_uri"`] View formatted query View runnable query Explain query SELECT * FROM redirects WHERE ( ( source = ? AND ( `type` = ? OR `type` = ? ) ) OR ( source = ? AND `type` = ? ) OR ( source = ? AND `type` = ? ) ) AND active = 1 AND ( regex IS NULL OR regex = 0 ) AND ( expiry > UNIX_TIMESTAMP() OR expiry IS NULL ) AND ( sourceSite IS NULL OR sourceSite = 0 ) AND priority = 99 ORDER BY `priority` DESC SELECT * FROM redirects WHERE ( (source = '/en/contact/sales' AND (`type` = 'path' OR `type` = 'auto_create')) OR (source = '/en/contact/sales' AND `type` = 'path_query') OR (source = 'https://langmatz-redesign.swhosting8b.de/en/contact/sales' AND `type` = 'entire_uri') ) AND active = 1 AND (regex IS NULL OR regex = 0) AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND (sourceSite IS NULL OR sourceSite = 0) AND priority = 99 ORDER BY `priority` DESC;
0.38 ms (2.85%)	7	SELECT item_id, 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: [`1790520730 "system\x01tags\x01" "site\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790520730 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('systemtags', 'sitetags');
0.35 ms (2.60%)	15	SELECT * FROM settings_store WHERE id = ? AND scope = ? Parameters: [`"BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore"`] View formatted query View runnable query Explain query SELECT * FROM settings_store WHERE id = ? AND scope = ? SELECT * FROM settings_store WHERE id = 'BUNDLE_INSTALLED__Pimcore\\Bundle\\SeoBundle\\PimcoreSeoBundle' AND scope = 'pimcore';
0.27 ms (2.01%)	9	SELECT customSettings FROM assets WHERE id = ? Parameters: [`1679`] View formatted query View runnable query Explain query SELECT customSettings FROM assets WHERE id = ? SELECT customSettings FROM assets WHERE id = 1679;
0.22 ms (1.67%)	12	SELECT * FROM tmp_store WHERE id = ? Parameters: [`"thumb_1679__0d4362de281d19ea05c93506a9bc3416"`] View formatted query View runnable query Explain query SELECT * FROM tmp_store WHERE id = ? SELECT * FROM tmp_store WHERE id = 'thumb_1679__0d4362de281d19ea05c93506a9bc3416';
0.22 ms (1.64%)	9	SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? Parameters: [`1679`] View formatted query View runnable query Explain query SELECT * FROM assets_image_thumbnail_cache WHERE cid = ? SELECT * FROM assets_image_thumbnail_cache WHERE cid = 1679;
0.21 ms (1.60%)	8	SELECT * FROM object_relations_kon WHERE src_id = ? Parameters: [`243`] View formatted query View runnable query Explain query SELECT * FROM object_relations_kon WHERE src_id = ? SELECT * FROM object_relations_kon WHERE src_id = 243;
0.16 ms (1.24%)	1	SELECT sourceId FROM documents_translations WHERE id = ? Parameters: [`393`] View formatted query View runnable query Explain query SELECT sourceId FROM documents_translations WHERE id = ? SELECT sourceId FROM documents_translations WHERE id = 393;
0.16 ms (1.22%)	2	SELECT * FROM documents_editables WHERE documentId = ? Parameters: [`393`] View formatted query View runnable query Explain query SELECT * FROM documents_editables WHERE documentId = ? SELECT * FROM documents_editables WHERE documentId = 393;
0.16 ms (1.21%)	9	SELECT item_id, 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: [`1790520730 "document_1150\x01tags\x01" "asset_1757\x01tags\x01" "asset_1875\x01tags\x01" "asset_1981\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790520730 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1150tags', 'asset_1757tags', 'asset_1875tags', 'asset_1981tags');
0.13 ms (0.96%)	1	SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`388 393 393`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId IN(388, 393) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 393;
0.12 ms (0.93%)	1	SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? Parameters: [`"/en/contact/" "sales"`] View formatted query View runnable query Explain query SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ? SELECT id FROM documents WHERE `path` = BINARY '/en/contact/' AND `key` = BINARY 'sales';
0.09 ms (0.66%)	3	SELECT `id`, `name` FROM classes WHERE id = ? Parameters: [`"cs_order"`] View formatted query View runnable query Explain query SELECT `id`, `name` FROM classes WHERE id = ? SELECT `id`, `name` FROM classes WHERE id = 'cs_order' ;
0.08 ms (0.58%)	4	SELECT id,language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ? Parameters: [`494 494`] View formatted query View runnable query Explain query SELECT id, language FROM documents_translations WHERE sourceId = ? UNION SELECT sourceId as id, "source" FROM documents_translations WHERE id = ? SELECT id,language FROM documents_translations WHERE sourceId = 494 UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = 494;
0.07 ms (0.56%)	1	SELECT * FROM object_url_slugs WHERE slug = '/en/contact/sales' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 Parameters: [] View formatted query View runnable query Explain query SELECT * FROM object_url_slugs WHERE slug = '/en/contact/sales' AND siteId = 0 ORDER BY siteId DESC LIMIT 1 SELECT * FROM object_url_slugs WHERE slug = '/en/contact/sales' AND siteId = 0 ORDER BY siteId DESC LIMIT 1;
0.07 ms (0.55%)	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: [] View formatted query View runnable query Explain query 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 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;
0.07 ms (0.52%)	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 (?, ?, ?, ?, ?, ?) Parameters: [`1790520730 "document_1082\x01tags\x01" "asset_2397\x01tags\x01" "asset_2398\x01tags\x01" "asset_2527\x01tags\x01" "asset_2528\x01tags\x01" "asset_2529\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790520730 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1082tags', 'asset_2397tags', 'asset_2398tags', 'asset_2527tags', 'asset_2528tags', 'asset_2529tags');
0.06 ms (0.47%)	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: [] View formatted query View runnable query Explain query 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 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;
0.06 ms (0.44%)	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 (?, ?, ?, ?, ?) Parameters: [`1790520730 "document_54\x01tags\x01" "asset_1640\x01tags\x01" "asset_2068\x01tags\x01" "asset_2720\x01tags\x01" "asset_2711\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790520730 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_54tags', 'asset_1640tags', 'asset_2068tags', 'asset_2720tags', 'asset_2711tags');
0.05 ms (0.39%)	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: [1790520730 "output\x01tags\x01" "navigation\x01tags\x01" "document_1098\x01tags\x01" "document_1099\x01tags\x01" "document_1100\x01tags\x01" "document_1101\x01tags\x01" "document_1097\x01tags\x01" "document_1150\x01tags\x01" "document_1096\x01tags\x01" "document_1163\x01tags\x01" "document_1164\x01tags\x01" "document_1165\x01tags\x01" "document_1162\x01tags\x01" "document_1166\x01tags\x01" "document_1167\x01tags\x01" "document_1168\x01tags\x01" "document_1169\x01tags\x01" "document_1170\x01tags\x01" "document_1171\x01tags\x01" "document_1172\x01tags\x01" "document_1173\x01tags\x01" "document_1174\x01tags\x01" "document_1175\x01tags\x01" "document_686\x01tags\x01" "document_1176\x01tags\x01" "document_1152\x01tags\x01" "document_1153\x01tags\x01" "document_1154\x01tags\x01" "document_1155\x01tags\x01" "document_1156\x01tags\x01" "document_1157\x01tags\x01" "document_1158\x01tags\x01" "document_1159\x01tags\x01" "document_1160\x01tags\x01" "document_1161\x01tags\x01" "document_1151\x01tags\x01" "document_1110\x01tags\x01" "document_1106\x01tags\x01" "document_1107\x01tags\x01" "document_1105\x01tags\x01" "document_1104\x01tags\x01" "document_1103\x01tags\x01" "document_1108\x01tags\x01" "document_1109\x01tags\x01" "document_1187\x01tags\x01" "document_1177\x01tags\x01" "document_1196\x01tags\x01" "document_1197\x01tags\x01" "document_1195\x01tags\x01" "document_1189\x01tags\x01" "document_1190\x01tags\x01" "document_1191\x01tags\x01" "document_1192\x01tags\x01" "document_1193\x01tags\x01" "document_1194\x01tags\x01" "document_1188\x01tags\x01" "document_403\x01tags\x01" "document_702\x01tags\x01" "document_120\x01tags\x01" "document_573\x01tags\x01" "document_574\x01tags\x01" "document_575\x01tags\x01" "document_576\x01tags\x01" "document_1374\x01tags\x01" "document_1375\x01tags\x01" "document_276\x01tags\x01" "document_119\x01tags\x01" "document_577\x01tags\x01" "document_578\x01tags\x01" "document_579\x01tags\x01" "document_580\x01tags\x01" "document_581\x01tags\x01" "document_582\x01tags\x01" "document_583\x01tags\x01" "document_584\x01tags\x01" "document_585\x01tags\x01" "document_586\x01tags\x01" "document_102\x01tags\x01" "document_587\x01tags\x01" "document_588\x01tags\x01" "document_589\x01tags\x01" "document_590\x01tags\x01" "document_591\x01tags\x01" "document_118\x01tags\x01" "document_1082\x01tags\x01" "document_1083\x01tags\x01" "document_1084\x01tags\x01" "document_1085\x01tags\x01" "document_1086\x01tags\x01" "document_1076\x01tags\x01" "document_1074\x01tags\x01" "document_592\x01tags\x01" "document_593\x01tags\x01" "document_594\x01tags\x01" "document_97\x01tags\x01" "document_595\x01tags\x01" "document_1090\x01tags\x01" "document_1091\x01tags\x01" "document_91\x01tags\x01" "document_596\x01tags\x01" "document_597\x01tags\x01" "document_598\x01tags\x01" "document_599\x01tags\x01" "document_92\x01tags\x01" "document_600\x01tags\x01" "document_601\x01tags\x01" "document_602\x01tags\x01" "document_93\x01tags\x01" "document_603\x01tags\x01" "document_604\x01tags\x01" "document_605\x01tags\x01" "document_606\x01tags\x01" "document_107\x01tags\x01" "document_607\x01tags\x01" "document_608\x01tags\x01" "document_610\x01tags\x01" "document_611\x01tags\x01" "document_90\x01tags\x01" "document_88\x01tags\x01" "document_612\x01tags\x01" "document_613\x01tags\x01" "document_614\x01tags\x01" "document_615\x01tags\x01" "document_616\x01tags\x01" "document_406\x01tags\x01" "document_617\x01tags\x01" "document_618\x01tags\x01" "document_619\x01tags\x01" "document_621\x01tags\x01" "document_622\x01tags\x01" "document_1224\x01tags\x01" "document_1226\x01tags\x01" "document_1225\x01tags\x01" "document_1223\x01tags\x01" "document_407\x01tags\x01" "document_405\x01tags\x01" "document_362\x01tags\x01" "document_357\x01tags\x01" "document_358\x01tags\x01" "document_359\x01tags\x01" "document_360\x01tags\x01" "document_361\x01tags\x01" "document_623\x01tags\x01" "document_368\x01tags\x01" "document_369\x01tags\x01" "document_370\x01tags\x01" "document_371\x01tags\x01" "document_123\x01tags\x01" "document_378\x01tags\x01" "document_687\x01tags\x01" "document_65\x01tags\x01" "document_106\x01tags\x01" "document_105\x01tags\x01" "document_741\x01tags\x01" "document_731\x01tags\x01" "document_732\x01tags\x01" "document_733\x01tags\x01" "document_734\x01tags\x01" "document_735\x01tags\x01" "document_736\x01tags\x01" "document_737\x01tags\x01" "document_738\x01tags\x01" "document_739\x01tags\x01" "document_740\x01tags\x01" "document_730\x01tags\x01" "document_389\x01tags\x01" "document_390\x01tags\x01" "document_391\x01tags\x01" "document_393\x01tags\x01" "document_888\x01tags\x01" "document_394\x01tags\x01" "document_758\x01tags\x01" "document_116\x01tags\x01" "document_128\x01tags\x01" "document_130\x01tags\x01" "document_131\x01tags\x01" "document_136\x01tags\x01" "document_137\x01tags\x01" "document_138\x01tags\x01" "document_139\x01tags\x01" "document_134\x01tags\x01" "document_140\x01tags\x01" "document_141\x01tags\x01" "document_144\x01tags\x01" "document_146\x01tags\x01" "document_322\x01tags\x01" "document_409\x01tags\x01"] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790520730 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('outputtags', 'navigationtags', 'document_1098tags', 'document_1099tags', 'document_1100tags', 'document_1101tags', 'document_1097tags', 'document_1150tags', 'document_1096tags', 'document_1163tags', 'document_1164tags', 'document_1165tags', 'document_1162tags', 'document_1166tags', 'document_1167tags', 'document_1168tags', 'document_1169tags', 'document_1170tags', 'document_1171tags', 'document_1172tags', 'document_1173tags', 'document_1174tags', 'document_1175tags', 'document_686tags', 'document_1176tags', 'document_1152tags', 'document_1153tags', 'document_1154tags', 'document_1155tags', 'document_1156tags', 'document_1157tags', 'document_1158tags', 'document_1159tags', 'document_1160tags', 'document_1161tags', 'document_1151tags', 'document_1110tags', 'document_1106tags', 'document_1107tags', 'document_1105tags', 'document_1104tags', 'document_1103tags', 'document_1108tags', 'document_1109tags', 'document_1187tags', 'document_1177tags', 'document_1196tags', 'document_1197tags', 'document_1195tags', 'document_1189tags', 'document_1190tags', 'document_1191tags', 'document_1192tags', 'document_1193tags', 'document_1194tags', 'document_1188tags', 'document_403tags', 'document_702tags', 'document_120tags', 'document_573tags', 'document_574tags', 'document_575tags', 'document_576tags', 'document_1374tags', 'document_1375tags', 'document_276tags', 'document_119tags', 'document_577tags', 'document_578tags', 'document_579tags', 'document_580tags', 'document_581tags', 'document_582tags', 'document_583tags', 'document_584tags', 'document_585tags', 'document_586tags', 'document_102tags', 'document_587tags', 'document_588tags', 'document_589tags', 'document_590tags', 'document_591tags', 'document_118tags', 'document_1082tags', 'document_1083tags', 'document_1084tags', 'document_1085tags', 'document_1086tags', 'document_1076tags', 'document_1074tags', 'document_592tags', 'document_593tags', 'document_594tags', 'document_97tags', 'document_595tags', 'document_1090tags', 'document_1091tags', 'document_91tags', 'document_596tags', 'document_597tags', 'document_598tags', 'document_599tags', 'document_92tags', 'document_600tags', 'document_601tags', 'document_602tags', 'document_93tags', 'document_603tags', 'document_604tags', 'document_605tags', 'document_606tags', 'document_107tags', 'document_607tags', 'document_608tags', 'document_610tags', 'document_611tags', 'document_90tags', 'document_88tags', 'document_612tags', 'document_613tags', 'document_614tags', 'document_615tags', 'document_616tags', 'document_406tags', 'document_617tags', 'document_618tags', 'document_619tags', 'document_621tags', 'document_622tags', 'document_1224tags', 'document_1226tags', 'document_1225tags', 'document_1223tags', 'document_407tags', 'document_405tags', 'document_362tags', 'document_357tags', 'document_358tags', 'document_359tags', 'document_360tags', 'document_361tags', 'document_623tags', 'document_368tags', 'document_369tags', 'document_370tags', 'document_371tags', 'document_123tags', 'document_378tags', 'document_687tags', 'document_65tags', 'document_106tags', 'document_105tags', 'document_741tags', 'document_731tags', 'document_732tags', 'document_733tags', 'document_734tags', 'document_735tags', 'document_736tags', 'document_737tags', 'document_738tags', 'document_739tags', 'document_740tags', 'document_730tags', 'document_389tags', 'document_390tags', 'document_391tags', 'document_393tags', 'document_888tags', 'document_394tags', 'document_758tags', 'document_116tags', 'document_128tags', 'document_130tags', 'document_131tags', 'document_136tags', 'document_137tags', 'document_138tags', 'document_139tags', 'document_134tags', 'document_140tags', 'document_141tags', 'document_144tags', 'document_146tags', 'document_322tags', 'document_409tags');
0.04 ms (0.33%)	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`] View formatted query View runnable query Explain query 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 (?) 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 (56);
0.04 ms (0.28%)	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`] 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;
0.03 ms (0.23%)	1	SELECT * FROM translations_messages LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_messages LIMIT 1; SELECT * FROM translations_messages LIMIT 1;;
0.03 ms (0.23%)	1	SELECT * FROM object_relations_konl WHERE src_id = ? Parameters: [`491`] View formatted query View runnable query Explain query SELECT * FROM object_relations_konl WHERE src_id = ? SELECT * FROM object_relations_konl WHERE src_id = 491;
0.03 ms (0.23%)	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`] View formatted query View runnable query Explain query SELECT t0.configKey AS configKey_1, t0.data AS data_2, t0.creationDate AS creationDate_3, t0.modificationDate AS modificationDate_4, t0.id AS id_5, t0.store_id AS store_id_6 FROM coreshop_configuration t0 WHERE t0.store_id IN (?) SELECT t0.configKey AS configKey_1, t0.data AS data_2, t0.creationDate AS creationDate_3, t0.modificationDate AS modificationDate_4, t0.id AS id_5, t0.store_id AS store_id_6 FROM coreshop_configuration t0 WHERE t0.store_id IN (1);
0.03 ms (0.20%)	1	SELECT * FROM translations_admin LIMIT 1; Parameters: [] View formatted query View runnable query Explain query SELECT * FROM translations_admin LIMIT 1; SELECT * FROM translations_admin LIMIT 1;;
0.02 ms (0.15%)	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: [`1790520730 "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"`] 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 > 1790520730 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_1tags', 'asset_2840tags', 'asset_1640tags', 'asset_693tags', 'asset_823tags', 'asset_314tags', 'asset_663tags', 'asset_714tags', 'asset_727tags', 'asset_887tags', 'asset_1633tags', 'asset_1631tags', 'asset_1632tags', 'asset_2067tags', 'asset_2724tags', 'asset_2281tags', 'asset_2710tags', 'asset_2799tags');
0.02 ms (0.13%)	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: [`1790520730 "document_118\x01tags\x01" "asset_1297\x01tags\x01" "asset_1760\x01tags\x01" "asset_975\x01tags\x01" "asset_973\x01tags\x01" "asset_971\x01tags\x01" "asset_972\x01tags\x01" "asset_976\x01tags\x01"`] View formatted query View runnable query Explain query SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > ? THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN (?, ?, ?, ?, ?, ?, ?, ?) SELECT item_id, CASE WHEN item_lifetime IS NULL OR item_lifetime + item_time > 1790520730 THEN item_data ELSE NULL END FROM cache_items WHERE item_id IN ('document_118tags', 'asset_1297tags', 'asset_1760tags', 'asset_975tags', 'asset_973tags', 'asset_971tags', 'asset_972tags', 'asset_976tags');

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

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\Order\Model\CartPriceRuleVoucherCodeCustomer	No errors.
CoreShop\Component\Payment\Model\PaymentProviderRule	No errors.
CoreShop\Component\Address\Model\Country	No errors.
CoreShop\Component\Core\Model\Country	No errors.
CoreShop\Component\Address\Model\Zone	No errors.
CoreShop\Component\Address\Model\State	No errors.
CoreShop\Component\Address\Model\CountryTranslation	No errors.

Symfony Profiler

GET https://langmatz-redesign.swhosting8b.de/_fragment?_path=_format%3Dhtml%26_locale%3Den%26_controller%3DReplacementBrickExtensionBundle%255CController%255CObject…

Configuration Settings

Theme

Page Width

Query Metrics

Grouped Statements

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping