Query Metrics
178
Database Queries
53
Different statements
172.06 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
123.35 ms (71.69%) |
53 |
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:
[ 1772684900 "\x01tags\x01site_domain_453fabf2efae3e63267c3b6c64603e3a" "site_domain_453fabf2efae3e63267c3b6c64603e3a" ] |
|
39.72 ms (23.09%) |
20 |
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:
[ 1772684900 "object_3669\x01tags\x01" "class_7\x01tags\x01" "asset_16309\x01tags\x01" ] |
|
2.23 ms (1.30%) |
6 |
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:
[ 1772684900 "document_1\x01tags\x01" ] |
|
0.37 ms (0.21%) |
3 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,16286) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.36 ms (0.21%) |
3 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,16300) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.36 ms (0.21%) |
3 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,16304) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.34 ms (0.20%) |
3 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,16294) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.31 ms (0.18%) |
3 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,16288) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.29 ms (0.17%) |
3 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,16312) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.29 ms (0.17%) |
3 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,16308) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.27 ms (0.16%) |
3 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,16297) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.23 ms (0.13%) |
5 |
SELECT id FROM classes WHERE name = ?
Parameters:
[
"Taxonomie"
]
|
|
0.22 ms (0.13%) |
3 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,16307) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.22 ms (0.12%) |
3 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,16302) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.21 ms (0.12%) |
3 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,16289) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.21 ms (0.12%) |
3 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,16303) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.20 ms (0.12%) |
3 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,16292) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.19 ms (0.11%) |
3 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,16310) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.17 ms (0.10%) |
3 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,16306) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.15 ms (0.09%) |
3 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,16301) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.15 ms (0.09%) |
3 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,16298) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.15 ms (0.09%) |
3 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,16311) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.14 ms (0.08%) |
3 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/pimcore-graphql-webservices/" "1808_wurst" ] |
|
0.13 ms (0.08%) |
3 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,16293) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.13 ms (0.08%) |
3 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,16309) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.13 ms (0.08%) |
1 |
SELECT object_6.id as id, object_6.type as `type` FROM object_6 WHERE ( ( ( SELECT `read` from `plugin_datahub_workspaces_object` WHERE `plugin_datahub_workspaces_object`.configuration = '1808_wurst' AND LOCATE(CONCAT(`object_6`.path,`object_6`.key),`plugin_datahub_workspaces_object`.cpath)=1 ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC LIMIT 1 )=1 OR ( SELECT `read` from `plugin_datahub_workspaces_object` WHERE `plugin_datahub_workspaces_object`.configuration = '1808_wurst' AND LOCATE(`plugin_datahub_workspaces_object`.cpath,CONCAT(`object_6`.path,`object_6`.key))=1 ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC LIMIT 1 )=1 ) AND ((`object_6`.`bezeichnung` LIKE '%riva 1920%') ) AND object_6.type IN ('object','folder','variant')) AND object_6.published = 1
Parameters:
[] |
|
0.12 ms (0.07%) |
2 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"7"
]
|
|
0.11 ms (0.06%) |
2 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/pimcore-graphql-webservices/1808_wurst"
]
|
|
0.09 ms (0.05%) |
1 |
SELECT id, name FROM classes
Parameters:
[] |
|
0.09 ms (0.05%) |
2 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2236,2245,2235,1,2291) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.09 ms (0.05%) |
1 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,3669) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.06 ms (0.04%) |
1 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,3652) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.06 ms (0.03%) |
1 |
SELECT r.src_id as dest_id, r.src_id as id, r.type, o.className as subtype, o.published as published, concat(o.path ,o.key) as `path` , r.index FROM objects o, object_relations_7 r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.dest_id = ? AND o.id = r.src_id AND r.type='object' UNION SELECT r.src_id as dest_id, r.src_id as id, r.type, a.type as subtype, "null" as published, concat(a.path,a.filename) as `path`, r.index FROM assets a, object_relations_7 r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.dest_id = ? AND a.id = r.src_id AND r.type='asset' UNION SELECT r.src_id as dest_id, r.src_id as id, r.type, d.type as subtype, d.published as published, concat(d.path,d.key) as `path`, r.index FROM documents d, object_relations_7 r WHERE r.fieldname= ? AND r.ownertype = 'object' AND r.dest_id = ? AND d.id = r.src_id AND r.type='document' ORDER BY `index` ASC
Parameters:
[ "taxonomie" 2291 "taxonomie" 2291 "taxonomie" 2291 ] |
|
0.05 ms (0.03%) |
1 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,3646) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.05 ms (0.03%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenace_mode"
]
|
|
0.05 ms (0.03%) |
1 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,3649) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.05 ms (0.03%) |
1 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,3654) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.05 ms (0.03%) |
1 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,3666) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.05 ms (0.03%) |
1 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,3671) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.05 ms (0.03%) |
1 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,3653) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.05 ms (0.03%) |
1 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,3648) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.05 ms (0.03%) |
1 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,3667) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.05 ms (0.03%) |
1 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,3657) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.05 ms (0.03%) |
1 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,3661) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.05 ms (0.03%) |
1 |
SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1
]
|
|
0.05 ms (0.03%) |
1 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,3663) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.05 ms (0.03%) |
1 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,3672) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.05 ms (0.03%) |
1 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,3668) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.04 ms (0.03%) |
1 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,3664) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.04 ms (0.02%) |
1 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,3658) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.04 ms (0.02%) |
1 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,3670) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.04 ms (0.02%) |
1 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,3662) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.04 ms (0.02%) |
1 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,3660) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
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.