Query Metrics
443
Database Queries
74
Different statements
109.77 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
32.70 ms (29.79%) |
160 |
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:
[ 1761639963 "site_domain_8599d45a90b49dc8f8a77adf48103a99" ] |
|
10.57 ms (9.62%) |
48 |
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:
[ 1761639963 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
|
10.22 ms (9.31%) |
45 |
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:
[ 1761639963 "system\x01tags\x01" "site\x01tags\x01" ] |
|
8.57 ms (7.81%) |
39 |
SELECT * FROM object_relations_CAR WHERE src_id = ?
Parameters:
[
259
]
|
|
4.95 ms (4.51%) |
22 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
202
]
|
|
4.67 ms (4.26%) |
9 |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
1
]
|
|
4.54 ms (4.14%) |
22 |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
202
]
|
|
2.35 ms (2.14%) |
1 |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
|
1.67 ms (1.52%) |
7 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
|
1.61 ms (1.47%) |
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:
[ 1761639964 "object_265\x01tags\x01" "class_CAR\x01tags\x01" "asset_205\x01tags\x01" "asset_206\x01tags\x01" ] |
|
1.59 ms (1.45%) |
1 |
SELECT dest as `value`, count(*) as `count` FROM shop_productindex_relations a WHERE fieldname = 'manufacturer' AND src IN (SELECT a.id FROM shop_productindex a WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND `type` = 'variant' AND (parentCategoryIds LIKE '%,390,%')) GROUP BY dest
Parameters:
[] |
|
1.48 ms (1.35%) |
6 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"CA"
]
|
|
1.45 ms (1.32%) |
5 |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/Customer Management/segments/calculated/Interest-Target-Groups/" "Sports-Cars-Fan" ] |
|
1.25 ms (1.14%) |
1 |
SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM shop_productindex a WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND `type` = 'variant' AND (parentCategoryIds LIKE '%,390,%') LIMIT 110, 22
Parameters:
[] |
|
1.22 ms (1.11%) |
1 |
SELECT PLUGIN_CMF_COLLECT_OBJECT_SEGMENT_ASSIGNMENTS(?)
Parameters:
[
"390"
]
|
|
1.18 ms (1.08%) |
5 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/en/shop/" "Cars~c390" ] |
|
1.17 ms (1.06%) |
1 |
SELECT TRIM(`color`) as `value`, count(*) as `count` FROM shop_productindex a WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND `type` = 'variant' AND (parentCategoryIds LIKE '%,390,%') GROUP BY TRIM(`color`)
Parameters:
[] |
|
0.86 ms (0.79%) |
1 |
SELECT TRIM(`parentCategoryIds`) as `value`, count(*) as `count` FROM shop_productindex a WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND `type` = 'variant' GROUP BY TRIM(`parentCategoryIds`)
Parameters:
[] |
|
0.85 ms (0.77%) |
1 |
SELECT TRIM(`carClass`) as `value`, count(*) as `count` FROM shop_productindex a WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND `type` = 'variant' AND (parentCategoryIds LIKE '%,390,%') GROUP BY TRIM(`carClass`)
Parameters:
[] |
|
0.79 ms (0.72%) |
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:
[ "/en/shop/Cars~c390" "path" "auto_create" "/en/shop/Cars~c390?page=6" "path_query" "https://pimcore.demo.bdapi.dev/en/shop/Cars~c390?page=6" "entire_uri" ] |
|
0.68 ms (0.62%) |
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:
[ 1761639964 "document_1\x01tags\x01" "asset_337\x01tags\x01" "asset_3\x01tags\x01" "asset_319\x01tags\x01" "asset_361\x01tags\x01" "asset_320\x01tags\x01" "asset_318\x01tags\x01" "asset_321\x01tags\x01" "asset_224\x01tags\x01" "asset_35\x01tags\x01" "asset_211\x01tags\x01" "asset_90\x01tags\x01" "asset_58\x01tags\x01" "asset_180\x01tags\x01" "asset_124\x01tags\x01" "asset_164\x01tags\x01" "asset_81\x01tags\x01" ] |
|
0.65 ms (0.59%) |
2 |
SELECT * FROM object_relations_CA WHERE src_id = ?
Parameters:
[
390
]
|
|
0.55 ms (0.50%) |
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:
[
390
]
|
|
0.54 ms (0.49%) |
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:
[ 1761639964 "output\x01tags\x01" "navigation\x01tags\x01" "document_74\x01tags\x01" "document_97\x01tags\x01" "document_45\x01tags\x01" "document_99\x01tags\x01" "document_100\x01tags\x01" "document_101\x01tags\x01" "document_102\x01tags\x01" "document_103\x01tags\x01" "document_104\x01tags\x01" "document_123\x01tags\x01" "document_46\x01tags\x01" "document_65\x01tags\x01" "document_200\x01tags\x01" "document_54\x01tags\x01" "document_55\x01tags\x01" "document_56\x01tags\x01" "document_57\x01tags\x01" "document_53\x01tags\x01" "document_48\x01tags\x01" "document_52\x01tags\x01" "document_112\x01tags\x01" "document_49\x01tags\x01" "document_113\x01tags\x01" "document_39\x01tags\x01" "document_121\x01tags\x01" "document_50\x01tags\x01" "document_38\x01tags\x01" "document_51\x01tags\x01" "document_118\x01tags\x01" "document_115\x01tags\x01" "document_199\x01tags\x01" "document_58\x01tags\x01" "document_95\x01tags\x01" "document_110\x01tags\x01" "document_193\x01tags\x01" "document_194\x01tags\x01" "document_195\x01tags\x01" "document_94\x01tags\x01" "document_88\x01tags\x01" "document_47\x01tags\x01" "document_12\x01tags\x01" "document_11\x01tags\x01" "document_30\x01tags\x01" "document_10\x01tags\x01" "document_59\x01tags\x01" "document_108\x01tags\x01" "document_198\x01tags\x01" ] |
|
0.53 ms (0.48%) |
3 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/en/shop/Cars~c390"
]
|
|
0.46 ms (0.42%) |
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:
[ 1761639964 "object_269\x01tags\x01" "class_CAR\x01tags\x01" "asset_208\x01tags\x01" "asset_209\x01tags\x01" "asset_210\x01tags\x01" ] |
|
0.43 ms (0.39%) |
1 |
SELECT id FROM targeting_rules WHERE active = 1 ORDER BY `prio` ASC
Parameters:
[] |
|
0.38 ms (0.35%) |
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:
[ "defaultTaxClass" null null ] |
|
0.34 ms (0.31%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '262'
Parameters:
[] |
|
0.34 ms (0.31%) |
1 |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
|
0.33 ms (0.30%) |
1 |
SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1 ORDER BY `prio` ASC
Parameters:
[] |
|
0.33 ms (0.30%) |
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:
[ 1761639963 "document_3\x01tags\x01" "document_1\x01tags\x01" "asset_337\x01tags\x01" "asset_3\x01tags\x01" "asset_319\x01tags\x01" "asset_361\x01tags\x01" "asset_320\x01tags\x01" "asset_318\x01tags\x01" "asset_321\x01tags\x01" "asset_224\x01tags\x01" "asset_35\x01tags\x01" "asset_211\x01tags\x01" "asset_90\x01tags\x01" "asset_58\x01tags\x01" "asset_180\x01tags\x01" "asset_124\x01tags\x01" "asset_164\x01tags\x01" "asset_81\x01tags\x01" ] |
|
0.32 ms (0.29%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '259'
Parameters:
[] |
|
0.31 ms (0.28%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '263'
Parameters:
[] |
|
0.30 ms (0.27%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '265'
Parameters:
[] |
|
0.29 ms (0.27%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '285'
Parameters:
[] |
|
0.29 ms (0.27%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '278'
Parameters:
[] |
|
0.29 ms (0.27%) |
1 |
SELECT id,language FROM documents_translations WHERE sourceId IN(?, ?) UNION SELECT sourceId as id,"source" FROM documents_translations WHERE id = ?
Parameters:
[ 1 1 1 ] |
|
0.29 ms (0.26%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '282'
Parameters:
[] |
|
0.29 ms (0.26%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '269'
Parameters:
[] |
|
0.28 ms (0.26%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '271'
Parameters:
[] |
|
0.28 ms (0.26%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '279'
Parameters:
[] |
|
0.28 ms (0.25%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '286'
Parameters:
[] |
|
0.28 ms (0.25%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '283'
Parameters:
[] |
|
0.28 ms (0.25%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '277'
Parameters:
[] |
|
0.27 ms (0.25%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '274'
Parameters:
[] |
|
0.27 ms (0.25%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '292'
Parameters:
[] |
|
0.27 ms (0.24%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '266'
Parameters:
[] |
|
0.27 ms (0.24%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '293'
Parameters:
[] |
|
0.27 ms (0.24%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '288'
Parameters:
[] |
|
0.27 ms (0.24%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '287'
Parameters:
[] |
|
0.26 ms (0.24%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '280'
Parameters:
[] |
|
0.26 ms (0.24%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '273'
Parameters:
[] |
|
0.26 ms (0.24%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '276'
Parameters:
[] |
|
0.25 ms (0.23%) |
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:
[ 1761639965 "document_48\x01tags\x01" "asset_62\x01tags\x01" "asset_63\x01tags\x01" "asset_321\x01tags\x01" "asset_319\x01tags\x01" "asset_362\x01tags\x01" "asset_340\x01tags\x01" "asset_317\x01tags\x01" ] |
|
0.25 ms (0.22%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='6'
Parameters:
[] |
|
0.24 ms (0.22%) |
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.22%) |
1 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
12
]
|
|
0.24 ms (0.22%) |
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:
[ 1761639965 "document_110\x01tags\x01" "document_104\x01tags\x01" "document_54\x01tags\x01" "document_55\x01tags\x01" "document_56\x01tags\x01" "document_57\x01tags\x01" "object_548\x01tags\x01" "object_561\x01tags\x01" "object_551\x01tags\x01" "object_550\x01tags\x01" "asset_390\x01tags\x01" "asset_391\x01tags\x01" "asset_392\x01tags\x01" "asset_389\x01tags\x01" ] |
|
0.23 ms (0.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:
[ 1761639965 "document_103\x01tags\x01" "asset_25\x01tags\x01" "asset_340\x01tags\x01" "asset_341\x01tags\x01" "asset_35\x01tags\x01" "asset_123\x01tags\x01" "asset_114\x01tags\x01" "asset_186\x01tags\x01" "asset_127\x01tags\x01" "asset_277\x01tags\x01" ] |
|
0.23 ms (0.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:
[ 1761639965 "document_101\x01tags\x01" "asset_319\x01tags\x01" "asset_321\x01tags\x01" "asset_341\x01tags\x01" "asset_14\x01tags\x01" "asset_46\x01tags\x01" "asset_57\x01tags\x01" "asset_13\x01tags\x01" "asset_81\x01tags\x01" ] |
|
0.23 ms (0.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:
[ 1761639965 "document_100\x01tags\x01" "asset_341\x01tags\x01" "asset_360\x01tags\x01" "document_57\x01tags\x01" "document_54\x01tags\x01" "document_55\x01tags\x01" ] |
|
0.22 ms (0.20%) |
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:
[ 1761639965 "document_49\x01tags\x01" "asset_252\x01tags\x01" "asset_250\x01tags\x01" "asset_249\x01tags\x01" "asset_251\x01tags\x01" "asset_115\x01tags\x01" "asset_117\x01tags\x01" "asset_114\x01tags\x01" "asset_35\x01tags\x01" "asset_36\x01tags\x01" "asset_41\x01tags\x01" ] |
|
0.22 ms (0.20%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='8'
Parameters:
[] |
|
0.22 ms (0.20%) |
1 |
SELECT sourceId FROM documents_translations WHERE id = ?
Parameters:
[
1
]
|
|
0.22 ms (0.20%) |
1 |
SELECT * FROM object_relations_EF_FD WHERE src_id = ?
Parameters:
[
563
]
|
|
0.21 ms (0.19%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='9'
Parameters:
[] |
|
0.21 ms (0.19%) |
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:
[ 1761639965 "document_95\x01tags\x01" "object_75\x01tags\x01" "object_74\x01tags\x01" "object_399\x01tags\x01" "asset_384\x01tags\x01" "asset_385\x01tags\x01" "asset_386\x01tags\x01" ] |
|
0.21 ms (0.19%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='10'
Parameters:
[] |
|
0.21 ms (0.19%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
|
0.21 ms (0.19%) |
1 |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='7'
Parameters:
[] |
|
0.19 ms (0.17%) |
1 |
SELECT * FROM translations_admin LIMIT 1;
Parameters:
[] |
|
0.17 ms (0.16%) |
1 |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
2
]
|
|
0.12 ms (0.11%) |
1 |
SELECT FOUND_ROWS()
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| pimcore | doctrine.orm.pimcore_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
No loaded entities.