POST https://pim.unimess.de/pimcore-graphql-webservices/1808_wurst

Query Metrics

178 Database Queries
53 Different statements
172.06 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

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.