Query Metrics
73
Database Queries
16
Different statements
41.34 ms
Query time
0
Invalid entities
0
Managed entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
11.81 ms (28.56%) |
21 |
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:
[ 1752086625 "site_domain_265afac0d46e18bad3c70f635259ed23" ] |
6.97 ms (16.87%) |
6 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/en/shop/Products/Spare-Parts/Lights/" "Buick-Special-Head-lamps~p422" ] |
6.20 ms (15.01%) |
5 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/en/shop/Products/Spare-Parts/Lights/Buick-Special-Head-lamps~p422"
]
|
5.04 ms (12.20%) |
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:
[ 1752086625 "system\x01tags\x01" "site\x01tags\x01" ] |
2.15 ms (5.21%) |
9 |
SELECT * FROM targeting_rules WHERE id = ?
Parameters:
[
1
]
|
1.85 ms (4.47%) |
4 |
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:
[ 1752086625 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
1.56 ms (3.76%) |
1 |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
1.44 ms (3.48%) |
5 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "system_settings" "pimcore_system_settings" ] |
0.91 ms (2.20%) |
5 |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/Customer Management/segments/calculated/Interest-Target-Groups/" "Sports-Cars-Fan" ] |
0.74 ms (1.79%) |
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:
[ 1752086625 "document_3\x01tags\x01" "document_1\x01tags\x01" "asset_410\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.70 ms (1.68%) |
3 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"AP"
]
|
0.49 ms (1.19%) |
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 AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "/en/shop/Products/Spare-Parts/Lights/Buick-Special-Head-lamps~p422" "path" "auto_create" "/en/shop/Products/Spare-Parts/Lights/Buick-Special-Head-lamps~p422" "path_query" "http://kosice.city/en/shop/Products/Spare-Parts/Lights/Buick-Special-Head-lamps~p422" "entire_uri" ] |
0.40 ms (0.97%) |
1 |
SELECT * FROM object_relations_AP WHERE src_id = ?
Parameters:
[
422
]
|
0.40 ms (0.97%) |
1 |
SELECT id FROM targeting_rules WHERE active = 1 ORDER BY `prio` ASC
Parameters:
[] |
0.38 ms (0.93%) |
1 |
SELECT * FROM object_url_slugs WHERE fieldname = 'urlSlug' AND ownertype = 'object' AND objectId = '422'
Parameters:
[] |
0.29 ms (0.70%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
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.
Managed Entities
pimcore entity manager
Class | Amount of managed objects |
---|
Entities Mapping
No loaded entities.