Query Metrics
331
Database Queries
66
Different statements
48.37 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
8.42 ms (17.40%) |
65 |
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:
[ 1769002402 "site_domain_2d1cd7fe70c34190cb9021c760231b92" ] |
|
3.62 ms (7.49%) |
31 |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
844
]
|
|
1.80 ms (3.72%) |
12 |
SELECT * FROM object_relations_STRU WHERE src_id = ?
Parameters:
[
714
]
|
|
1.68 ms (3.48%) |
15 |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"NEWS"
]
|
|
1.53 ms (3.17%) |
15 |
SELECT id FROM classes WHERE name = ?
Parameters:
[
"Ristorante"
]
|
|
1.41 ms (2.91%) |
10 |
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:
[ 1769002402 "object_715\x01tags\x01" "class_STRU\x01tags\x01" "asset_863\x01tags\x01" "asset_864\x01tags\x01" ] |
|
1.20 ms (2.48%) |
7 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,156,154,1,160) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.98 ms (2.02%) |
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:
[ 1769002402 "system\x01tags\x01" "site\x01tags\x01" ] |
|
0.83 ms (1.71%) |
1 |
SELECT object_localized_STRU_it.id AS id, object_localized_STRU_it.type AS `type` FROM object_localized_STRU_it WHERE ( ( ( SELECT `read` FROM `plugin_datahub_workspaces_object` WHERE `plugin_datahub_workspaces_object`.configuration = 'gattinara' AND LOCATE(CONCAT(`object_localized_STRU_it`.path,`object_localized_STRU_it`.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 = 'gattinara' AND LOCATE(`plugin_datahub_workspaces_object`.cpath,CONCAT(`object_localized_STRU_it`.path,`object_localized_STRU_it`.key))=1 ORDER BY LENGTH(`plugin_datahub_workspaces_object`.cpath) DESC LIMIT 1 )=1 ) AND object_localized_STRU_it.type IN ('object','folder','variant')) AND object_localized_STRU_it.published = 1
Parameters:
[] |
|
0.78 ms (1.62%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,853) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.71 ms (1.47%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,854) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.71 ms (1.46%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,852) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.71 ms (1.46%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,857) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.69 ms (1.43%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,851) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.69 ms (1.42%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,858) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.69 ms (1.42%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,849) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.68 ms (1.41%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,871) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.68 ms (1.40%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,850) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.67 ms (1.39%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,847) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.67 ms (1.39%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,846) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.67 ms (1.39%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,848) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.67 ms (1.39%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,855) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.67 ms (1.39%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,870) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.64 ms (1.33%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,856) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.63 ms (1.30%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,843) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.62 ms (1.29%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,156,154,1,157) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.61 ms (1.26%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,862) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.61 ms (1.25%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,860) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.60 ms (1.24%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,844) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.60 ms (1.24%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,866) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.60 ms (1.23%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,865) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.60 ms (1.23%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,864) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.60 ms (1.23%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,842) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.59 ms (1.22%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,931) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.58 ms (1.21%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,845) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.58 ms (1.21%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,863) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.58 ms (1.20%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,929) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.57 ms (1.18%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,933) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.57 ms (1.17%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,928) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.57 ms (1.17%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,932) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.56 ms (1.16%) |
4 |
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,6,1,930) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.46 ms (0.95%) |
3 |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/pimcore-graphql-webservices/" "gattinara" ] |
|
0.35 ms (0.73%) |
2 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,155,154,1,714) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.33 ms (0.69%) |
2 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,155,154,1,716) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.32 ms (0.66%) |
2 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,155,154,1,719) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.31 ms (0.65%) |
2 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,155,154,1,720) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.31 ms (0.65%) |
2 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,155,154,1,723) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.31 ms (0.65%) |
2 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,155,154,1,721) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.31 ms (0.65%) |
2 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,155,154,1,884) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.31 ms (0.64%) |
2 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,155,154,1,722) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.31 ms (0.64%) |
2 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,155,154,1,724) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.30 ms (0.62%) |
2 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,155,154,1,715) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.30 ms (0.62%) |
2 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,155,154,1,717) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.30 ms (0.62%) |
2 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,155,154,1,718) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.29 ms (0.60%) |
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:
[ "/pimcore-graphql-webservices/gattinara" "path" "auto_create" "/pimcore-graphql-webservices/gattinara" "path_query" "https://editor.visitgattinara.it/pimcore-graphql-webservices/gattinara" "entire_uri" ] |
|
0.28 ms (0.59%) |
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:
[ 1769002402 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
|
0.25 ms (0.52%) |
2 |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/pimcore-graphql-webservices/gattinara"
]
|
|
0.22 ms (0.46%) |
1 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,156,154,1,161) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.21 ms (0.43%) |
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:
[ 1769002402 "object_714\x01tags\x01" "class_STRU\x01tags\x01" "asset_844\x01tags\x01" "asset_845\x01tags\x01" "asset_928\x01tags\x01" "asset_930\x01tags\x01" "asset_929\x01tags\x01" "asset_931\x01tags\x01" "asset_932\x01tags\x01" "asset_933\x01tags\x01" ] |
|
0.15 ms (0.32%) |
1 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,156,154,1,162) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.15 ms (0.31%) |
1 |
SELECT * FROM properties WHERE ( (cid IN (1) AND inheritable = 1) OR cid = ? ) AND ctype='document'
Parameters:
[
1
]
|
|
0.15 ms (0.31%) |
1 |
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,156,154,1,163) AND configuration = 'gattinara' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[] |
|
0.15 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:
[ 1769002402 "object_719\x01tags\x01" "class_STRU\x01tags\x01" "asset_856\x01tags\x01" "asset_857\x01tags\x01" "asset_858\x01tags\x01" ] |
|
0.15 ms (0.30%) |
1 |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
|
0.13 ms (0.26%) |
1 |
SELECT id, name FROM classes
Parameters:
[] |
|
0.12 ms (0.26%) |
1 |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
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 |
| pimcore | doctrine.orm.pimcore_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
pimcore_generic_data_index entity manager
No loaded entities.
pimcore entity manager
No loaded entities.