Query Metrics
120
Database Queries
18
Different statements
36.84 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
9.79 ms (26.56%) |
37 |
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:
[ 1730218061 "site_domain_acb4e494e0c66d128fa7d826d0416529" ] |
5.21 ms (14.15%) |
16 |
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:
[ 1730218061 "object_4\x01tags\x01" "class_Teams\x01tags\x01" "asset_12\x01tags\x01" ] |
4.25 ms (11.53%) |
22 |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
5
]
|
4.06 ms (11.02%) |
22 |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
5
]
|
3.05 ms (8.28%) |
2 |
SELECT object_Teams.id AS id, object_Teams.type AS `type` FROM object_Teams WHERE ( object_Teams.type IN ('object','variant','folder')) AND object_Teams.published = 1 ORDER BY `orderId` ASC
Parameters:
[] |
2.02 ms (5.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:
[ 1730218061 "output\x01tags\x01" "navigation\x01tags\x01" "document_2\x01tags\x01" "document_4\x01tags\x01" "document_28\x01tags\x01" "document_32\x01tags\x01" "document_33\x01tags\x01" "document_34\x01tags\x01" "document_35\x01tags\x01" "document_6\x01tags\x01" "document_5\x01tags\x01" "document_7\x01tags\x01" "document_8\x01tags\x01" "document_9\x01tags\x01" "document_23\x01tags\x01" "document_24\x01tags\x01" "document_25\x01tags\x01" "document_41\x01tags\x01" "document_21\x01tags\x01" "document_10\x01tags\x01" "document_12\x01tags\x01" "document_17\x01tags\x01" "document_18\x01tags\x01" "document_19\x01tags\x01" "document_20\x01tags\x01" "document_11\x01tags\x01" "document_26\x01tags\x01" "document_27\x01tags\x01" "document_37\x01tags\x01" "document_39\x01tags\x01" "document_40\x01tags\x01" "document_42\x01tags\x01" "document_43\x01tags\x01" "document_44\x01tags\x01" "document_45\x01tags\x01" "document_46\x01tags\x01" "document_36\x01tags\x01" "document_29\x01tags\x01" "document_48\x01tags\x01" "document_49\x01tags\x01" "document_47\x01tags\x01" "document_53\x01tags\x01" "document_52\x01tags\x01" "document_51\x01tags\x01" "document_50\x01tags\x01" "document_55\x01tags\x01" "document_56\x01tags\x01" "document_57\x01tags\x01" "document_58\x01tags\x01" "document_59\x01tags\x01" "document_60\x01tags\x01" "document_61\x01tags\x01" "document_62\x01tags\x01" "document_63\x01tags\x01" "document_64\x01tags\x01" "document_65\x01tags\x01" "document_66\x01tags\x01" "document_67\x01tags\x01" "document_68\x01tags\x01" "document_69\x01tags\x01" "document_70\x01tags\x01" "document_71\x01tags\x01" "document_72\x01tags\x01" "document_73\x01tags\x01" "document_74\x01tags\x01" "document_54\x01tags\x01" "document_75\x01tags\x01" ] |
1.89 ms (5.12%) |
2 |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
1
]
|
1.10 ms (2.97%) |
2 |
SELECT object_Features.id AS id, object_Features.type AS `type` FROM object_Features WHERE ( object_Features.type IN ('object','variant','folder')) AND object_Features.published = 1
Parameters:
[] |
0.88 ms (2.38%) |
2 |
SELECT object_Testimonials.id AS id, object_Testimonials.type AS `type` FROM object_Testimonials WHERE ( object_Testimonials.type IN ('object','variant','folder')) AND object_Testimonials.published = 1
Parameters:
[] |
0.81 ms (2.20%) |
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:
[ 1730218061 "system\x01tags\x01" "site\x01tags\x01" ] |
0.72 ms (1.94%) |
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:
[ 1730218061 "document_1\x01tags\x01" "asset_5\x01tags\x01" "asset_8\x01tags\x01" "asset_9\x01tags\x01" "asset_10\x01tags\x01" "asset_7\x01tags\x01" ] |
0.67 ms (1.83%) |
1 |
SELECT id FROM sites ORDER BY (SELECT LENGTH(`path`) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[] |
0.56 ms (1.51%) |
2 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"Teams"
]
|
0.54 ms (1.47%) |
1 |
SELECT * FROM object_url_slugs WHERE slug = '/' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
0.47 ms (1.28%) |
2 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
0.33 ms (0.90%) |
1 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
"/"
""
]
|
0.30 ms (0.81%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
0.20 ms (0.54%) |
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:
[ 1730218062 "document_53\x01tags\x01" "asset_253\x01tags\x01" "asset_255\x01tags\x01" "asset_258\x01tags\x01" "asset_259\x01tags\x01" "asset_260\x01tags\x01" "asset_257\x01tags\x01" "asset_256\x01tags\x01" ] |
Database Connections
Name | Service |
---|---|
default | doctrine.dbal.default_connection |
Entity Managers
There are no configured entity managers.
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
No mapped entities.