Query Metrics
243
Database Queries
60
Different statements
91.58 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
24.91 ms (27.20%) |
96 |
SELECT item_id, 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:
[ 1773713015 "site_domain_0bec009be5d9a1dcfab1016e676491c8" ] |
|
14.64 ms (15.99%) |
4 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
821
]
|
|
7.29 ms (7.96%) |
1 |
SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = ? AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC
Parameters:
[
1189
]
|
|
6.63 ms (7.24%) |
22 |
SELECT item_id, 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:
[ 1773713015 "system\x01tags\x01" "site\x01tags\x01" ] |
|
4.27 ms (4.66%) |
1 |
SELECT TRIM(`parentCategoryIds`) as `value`, count(*) as `count` FROM shop_productindex a WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 GROUP BY TRIM(`parentCategoryIds`)
Parameters:
[] |
|
2.37 ms (2.59%) |
9 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
|
2.34 ms (2.55%) |
12 |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
865
]
|
|
2.32 ms (2.54%) |
8 |
SELECT item_id, 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:
[ 1773713015 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
|
2.15 ms (2.35%) |
8 |
SELECT objects.*, tree_locks.locked as locked FROM objects LEFT JOIN tree_locks ON objects.id = tree_locks.id AND tree_locks.type = 'object' WHERE objects.id = ?
Parameters:
[
3098
]
|
|
1.92 ms (2.09%) |
9 |
SELECT `type`,`className`,`classId` FROM objects WHERE `id` = ?
Parameters:
[
1277
]
|
|
1.71 ms (1.87%) |
9 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"CA"
]
|
|
1.31 ms (1.43%) |
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 AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "/de/shop/Mietprogramm~c1189" "path" "auto_create" "/de/shop/Mietprogramm~c1189?page=17" "path_query" "https://cramer-pimcore-demo.xim-test.de/de/shop/Mietprogramm~c1189?page=17" "entire_uri" ] |
|
1.27 ms (1.39%) |
1 |
SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM shop_productindex a WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (parentCategoryIds LIKE '%,1189,%') LIMIT 352, 22
Parameters:
[] |
|
1.11 ms (1.21%) |
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:
[ 1773713015 "output\x01tags\x01" "navigation\x01tags\x01" "document_138\x01tags\x01" "document_252\x01tags\x01" "document_432\x01tags\x01" "document_240\x01tags\x01" "document_298\x01tags\x01" "document_300\x01tags\x01" "document_302\x01tags\x01" "document_299\x01tags\x01" "document_303\x01tags\x01" "document_304\x01tags\x01" "document_305\x01tags\x01" "document_306\x01tags\x01" "document_307\x01tags\x01" "document_308\x01tags\x01" "document_309\x01tags\x01" "document_310\x01tags\x01" "document_311\x01tags\x01" "document_312\x01tags\x01" "document_443\x01tags\x01" "document_301\x01tags\x01" "document_258\x01tags\x01" "document_273\x01tags\x01" "document_271\x01tags\x01" "document_272\x01tags\x01" "document_270\x01tags\x01" "document_279\x01tags\x01" "document_437\x01tags\x01" "document_274\x01tags\x01" "document_318\x01tags\x01" "document_323\x01tags\x01" "document_324\x01tags\x01" "document_325\x01tags\x01" "document_326\x01tags\x01" "document_317\x01tags\x01" "document_427\x01tags\x01" "document_281\x01tags\x01" "document_282\x01tags\x01" "document_280\x01tags\x01" "document_253\x01tags\x01" "document_170\x01tags\x01" "document_289\x01tags\x01" "document_433\x01tags\x01" "document_148\x01tags\x01" "document_149\x01tags\x01" "document_137\x01tags\x01" "document_141\x01tags\x01" "document_245\x01tags\x01" "document_333\x01tags\x01" "document_334\x01tags\x01" "document_335\x01tags\x01" "document_336\x01tags\x01" "document_424\x01tags\x01" "document_331\x01tags\x01" "document_339\x01tags\x01" "document_340\x01tags\x01" "document_341\x01tags\x01" "document_342\x01tags\x01" "document_343\x01tags\x01" "document_338\x01tags\x01" "document_345\x01tags\x01" "document_346\x01tags\x01" "document_347\x01tags\x01" "document_348\x01tags\x01" "document_349\x01tags\x01" "document_350\x01tags\x01" "document_344\x01tags\x01" "document_352\x01tags\x01" "document_353\x01tags\x01" "document_355\x01tags\x01" "document_356\x01tags\x01" "document_357\x01tags\x01" "document_351\x01tags\x01" "document_359\x01tags\x01" "document_362\x01tags\x01" "document_363\x01tags\x01" "document_358\x01tags\x01" "document_365\x01tags\x01" "document_367\x01tags\x01" "document_368\x01tags\x01" "document_364\x01tags\x01" "document_370\x01tags\x01" "document_371\x01tags\x01" "document_372\x01tags\x01" "document_373\x01tags\x01" "document_374\x01tags\x01" "document_369\x01tags\x01" "document_376\x01tags\x01" "document_377\x01tags\x01" "document_378\x01tags\x01" "document_379\x01tags\x01" "document_380\x01tags\x01" "document_381\x01tags\x01" "document_375\x01tags\x01" "document_383\x01tags\x01" "document_384\x01tags\x01" "document_386\x01tags\x01" "document_387\x01tags\x01" "document_388\x01tags\x01" "document_382\x01tags\x01" "document_390\x01tags\x01" "document_391\x01tags\x01" "document_392\x01tags\x01" "document_393\x01tags\x01" "document_389\x01tags\x01" "document_395\x01tags\x01" "document_396\x01tags\x01" "document_397\x01tags\x01" "document_398\x01tags\x01" "document_394\x01tags\x01" "document_401\x01tags\x01" "document_402\x01tags\x01" "document_403\x01tags\x01" "document_404\x01tags\x01" "document_405\x01tags\x01" "document_406\x01tags\x01" "document_400\x01tags\x01" "document_408\x01tags\x01" "document_409\x01tags\x01" "document_410\x01tags\x01" "document_411\x01tags\x01" "document_407\x01tags\x01" "document_413\x01tags\x01" "document_414\x01tags\x01" "document_415\x01tags\x01" "document_416\x01tags\x01" "document_412\x01tags\x01" "document_418\x01tags\x01" "document_420\x01tags\x01" "document_421\x01tags\x01" "document_423\x01tags\x01" "document_417\x01tags\x01" "document_440\x01tags\x01" "document_441\x01tags\x01" "document_442\x01tags\x01" "document_439\x01tags\x01" "document_290\x01tags\x01" "document_429\x01tags\x01" "document_428\x01tags\x01" "document_435\x01tags\x01" ] |
|
1.02 ms (1.12%) |
2 |
SELECT * FROM object_relations_CA WHERE src_id = ?
Parameters:
[
1189
]
|
|
0.85 ms (0.93%) |
1 |
SELECT object_localized_TRAINING_EVENT_de.id as id, object_localized_TRAINING_EVENT_de.type as `type` FROM object_localized_TRAINING_EVENT_de WHERE ((`startDate` >= ?) AND object_localized_TRAINING_EVENT_de.type IN ('object','variant','folder')) AND object_localized_TRAINING_EVENT_de.published = 1
Parameters:
[
"2026-03-17 00:00:00"
]
|
|
0.63 ms (0.69%) |
2 |
SELECT * FROM object_store_BOOMLIFT WHERE oo_id = ? FOR UPDATE
Parameters:
[
3126
]
|
|
0.58 ms (0.64%) |
3 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/de/shop/" "Mietprogramm~c1189" ] |
|
0.56 ms (0.61%) |
1 |
SELECT * FROM object_store_TRAILERMOUNTEDPLATFORM WHERE oo_id = ? FOR UPDATE
Parameters:
[
3192
]
|
|
0.55 ms (0.60%) |
1 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
170
]
|
|
0.51 ms (0.56%) |
2 |
SELECT * FROM object_store_SCISSORLIFT WHERE oo_id = ? FOR UPDATE
Parameters:
[
3288
]
|
|
0.49 ms (0.53%) |
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:
[ 1773713015 "document_270\x01tags\x01" "asset_1187\x01tags\x01" "asset_2339\x01tags\x01" "asset_2336\x01tags\x01" "asset_2335\x01tags\x01" "asset_2333\x01tags\x01" "asset_2334\x01tags\x01" "asset_2332\x01tags\x01" "asset_2331\x01tags\x01" "asset_2330\x01tags\x01" "asset_2329\x01tags\x01" "asset_2328\x01tags\x01" "asset_2323\x01tags\x01" "asset_2327\x01tags\x01" "asset_2326\x01tags\x01" "asset_2320\x01tags\x01" "asset_2337\x01tags\x01" "asset_2322\x01tags\x01" "asset_2321\x01tags\x01" "asset_2325\x01tags\x01" "asset_2324\x01tags\x01" "asset_2317\x01tags\x01" ] |
|
0.47 ms (0.52%) |
2 |
SELECT * FROM object_collection_strings_SCISSORLIFT WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 3288 "youtubeVideo" ] |
|
0.47 ms (0.51%) |
2 |
SELECT * FROM object_localized_data_BOOMLIFT WHERE ooo_id = ? AND language IN ('en','de','fr')
Parameters:
[
3126
]
|
|
0.47 ms (0.51%) |
2 |
SELECT * FROM object_localized_data_SCISSORLIFT WHERE ooo_id = ? AND language IN ('en','de','fr')
Parameters:
[
3288
]
|
|
0.44 ms (0.48%) |
1 |
SELECT * FROM object_localized_data_ATTACHMENT WHERE ooo_id = ? AND language IN ('en','de','fr')
Parameters:
[
3098
]
|
|
0.43 ms (0.47%) |
2 |
SELECT * FROM object_collection_strings_BOOMLIFT WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 3126 "youtubeVideo" ] |
|
0.42 ms (0.46%) |
2 |
SELECT * FROM object_relations_BOOMLIFT WHERE src_id = ?
Parameters:
[
3126
]
|
|
0.42 ms (0.46%) |
1 |
SELECT * FROM object_relations_EF_FD WHERE src_id = ?
Parameters:
[
563
]
|
|
0.42 ms (0.46%) |
1 |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
1086
]
|
|
0.41 ms (0.45%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
|
0.41 ms (0.45%) |
1 |
SELECT * FROM object_store_ATTACHMENT WHERE oo_id = ? FOR UPDATE
Parameters:
[
3098
]
|
|
0.39 ms (0.42%) |
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:
[ 1773713015 "document_271\x01tags\x01" "asset_2074\x01tags\x01" "asset_2072\x01tags\x01" "asset_1178\x01tags\x01" "asset_1264\x01tags\x01" "asset_1184\x01tags\x01" "asset_1180\x01tags\x01" "asset_1262\x01tags\x01" "asset_1258\x01tags\x01" "asset_1260\x01tags\x01" "asset_2070\x01tags\x01" "asset_2076\x01tags\x01" ] |
|
0.38 ms (0.42%) |
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:
[ 1773713015 "document_272\x01tags\x01" "asset_1168\x01tags\x01" "asset_1171\x01tags\x01" "asset_1172\x01tags\x01" "asset_1174\x01tags\x01" ] |
|
0.38 ms (0.42%) |
1 |
SELECT * FROM object_store_TELESCOPICFORKLIFT WHERE oo_id = ? FOR UPDATE
Parameters:
[
3101
]
|
|
0.37 ms (0.40%) |
2 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/de/shop/Mietprogramm~c1189"
]
|
|
0.36 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:
[ 1773713015 "document_258\x01tags\x01" "asset_1222\x01tags\x01" "asset_1236\x01tags\x01" "asset_1989\x01tags\x01" "asset_1988\x01tags\x01" "asset_2056\x01tags\x01" "asset_1232\x01tags\x01" "asset_1246\x01tags\x01" "asset_1240\x01tags\x01" ] |
|
0.36 ms (0.39%) |
2 |
SELECT * FROM object_relations_SCISSORLIFT WHERE src_id = ?
Parameters:
[
3288
]
|
|
0.36 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:
[ 1773713015 "document_280\x01tags\x01" "asset_1196\x01tags\x01" "asset_1220\x01tags\x01" "asset_1197\x01tags\x01" ] |
|
0.35 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:
[ 1773713015 "document_136\x01tags\x01" "asset_456\x01tags\x01" "asset_1069\x01tags\x01" "asset_1072\x01tags\x01" "asset_1070\x01tags\x01" "asset_2039\x01tags\x01" "asset_1196\x01tags\x01" "asset_1194\x01tags\x01" "asset_1195\x01tags\x01" "asset_1105\x01tags\x01" "asset_1103\x01tags\x01" "asset_2341\x01tags\x01" "asset_2345\x01tags\x01" "asset_2340\x01tags\x01" "asset_2344\x01tags\x01" "asset_1226\x01tags\x01" "asset_1244\x01tags\x01" "asset_1227\x01tags\x01" "asset_1228\x01tags\x01" "asset_1229\x01tags\x01" "asset_1223\x01tags\x01" "asset_1215\x01tags\x01" "asset_1225\x01tags\x01" ] |
|
0.34 ms (0.37%) |
2 |
SELECT * FROM object_brick_store_SaleInformation_BOOMLIFT WHERE id = ? AND fieldname = ?
Parameters:
[ 3126 "saleInformation" ] |
|
0.33 ms (0.36%) |
1 |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/Training/" "ttwardoch" ] |
|
0.31 ms (0.34%) |
2 |
SELECT * FROM object_brick_store_SaleInformation_SCISSORLIFT WHERE id = ? AND fieldname = ?
Parameters:
[ 3288 "saleInformation" ] |
|
0.30 ms (0.33%) |
1 |
SELECT * FROM object_localized_data_TELESCOPICFORKLIFT WHERE ooo_id = ? AND language IN ('en','de','fr')
Parameters:
[
3101
]
|
|
0.30 ms (0.33%) |
1 |
SELECT * FROM object_collection_strings_ATTACHMENT WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 3098 "youtubeVideo" ] |
|
0.29 ms (0.32%) |
1 |
SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters:
[ "DEFAULT_TRAINER_PATH" null "de" ] |
|
0.28 ms (0.31%) |
1 |
SELECT id FROM sites ORDER BY (SELECT LENGTH(CONCAT(`path`, `key`)) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[] |
|
0.24 ms (0.27%) |
1 |
SELECT * FROM object_collection_strings_TELESCOPICFORKLIFT WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 3101 "youtubeVideo" ] |
|
0.24 ms (0.26%) |
1 |
SELECT * FROM object_relations_SPIDERWORKPLATFORM WHERE src_id = ?
Parameters:
[
3187
]
|
|
0.24 ms (0.26%) |
1 |
SELECT * FROM object_relations_ATTACHMENT WHERE src_id = ?
Parameters:
[
3098
]
|
|
0.23 ms (0.25%) |
1 |
SELECT * FROM object_localized_data_TRAILERMOUNTEDPLATFORM WHERE ooo_id = ? AND language IN ('en','de','fr')
Parameters:
[
3192
]
|
|
0.23 ms (0.25%) |
1 |
SELECT * FROM object_relations_TELESCOPICFORKLIFT WHERE src_id = ?
Parameters:
[
3101
]
|
|
0.22 ms (0.24%) |
1 |
SELECT * FROM object_relations_TRAILERMOUNTEDPLATFORM WHERE src_id = ?
Parameters:
[
3192
]
|
|
0.21 ms (0.23%) |
1 |
SELECT * FROM object_brick_store_SaleInformation_ATTACHMENT WHERE id = ? AND fieldname = ?
Parameters:
[ 3098 "saleInformation" ] |
|
0.20 ms (0.22%) |
1 |
SELECT * FROM object_brick_store_SaleInformation_TELESCOPICFORKLIFT WHERE id = ? AND fieldname = ?
Parameters:
[ 3101 "saleInformation" ] |
|
0.20 ms (0.21%) |
1 |
SELECT * FROM object_collection_strings_TRAILERMOUNTEDPLATFORM WHERE id = ? AND fieldname = ? ORDER BY `index` ASC
Parameters:
[ 3192 "youtubeVideo" ] |
|
0.19 ms (0.21%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
|
0.18 ms (0.20%) |
1 |
SELECT * FROM object_brick_store_SaleInformation_TRAILERMOUNTEDPLATFORM WHERE id = ? AND fieldname = ?
Parameters:
[ 3192 "saleInformation" ] |
|
0.16 ms (0.17%) |
1 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
11
]
|
|
0.15 ms (0.16%) |
1 |
SELECT FOUND_ROWS()
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| pimcore_generic_data_index | doctrine.orm.pimcore_generic_data_index_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Managed Entities
pimcore_generic_data_index entity manager
| Class | Amount of managed objects |
|---|
Entities Mapping
No loaded entities.