POST https://editor.visitgattinara.it/pimcore-graphql-webservices/gattinara

Query Metrics

331 Database Queries
66 Different statements
48.37 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.