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

Query Metrics

129 Database Queries
39 Different statements
75.80 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.45 ms
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:
[
  1732194518
  "\x01tags\x01site_domain_453fabf2efae3e63267c3b6c64603e3a"
  "site_domain_453fabf2efae3e63267c3b6c64603e3a"
]
2 0.12 ms
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:
[
  1732194518
  "system\x01tags\x01"
  "site\x01tags\x01"
]
3 0.05 ms
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
  "maintenace_mode"
]
4 0.06 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/pimcore-graphql-webservices/"
  "1808_wurst"
]
5 0.04 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/pimcore-graphql-webservices/1808_wurst"
]
6 0.04 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  "pimcore-graphql-webservices"
]
7 0.03 ms
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
  "/pimcore-graphql-webservices"
]
8 0.03 ms
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[
  "/"
  ""
]
9 0.15 ms
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:
[
  1732194518
  "\x01tags\x01document_1"
  "document_1"
]
10 9.74 ms
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:
[
  1732194518
  "document_1\x01tags\x01"
]
11 1.02 ms
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:
[
  1732194518
  "\x01tags\x01document_properties_1"
  "document_properties_1"
]
12 0.06 ms
SELECT * FROM properties WHERE
                             (
                                 (cid IN (1) AND inheritable = 1) OR cid = ?
                             ) AND ctype='document'
Parameters:
[
  1
]
13 0.06 ms
SELECT id, name FROM classes
Parameters:
[]
14 0.05 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "7"
]
15 0.07 ms
SELECT name FROM classes WHERE id = ?
Parameters:
[
  "6"
]
16 0.07 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "Taxonomie"
]
17 0.04 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "Gegenstand"
]
18 0.04 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "Gegenstand"
]
19 0.05 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "Taxonomie"
]
20 0.07 ms
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 '%poltrona frau%') )  AND  object_6.type IN ('object','folder','variant')) AND object_6.published = 1
Parameters:
[]
21 0.29 ms
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:
[
  1732194518
  "\x01tags\x01object_2294"
  "object_2294"
]
22 0.21 ms
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:
[
  1732194518
  "object_2294\x01tags\x01"
  "class_6\x01tags\x01"
]
23 0.30 ms
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:
[
  1732194518
  "\x01tags\x01object_2236"
  "object_2236"
]
24 0.15 ms
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:
[
  1732194518
  "object_2236\x01tags\x01"
  "class_6\x01tags\x01"
]
25 0.15 ms
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:
[
  1732194518
  "\x01tags\x01object_2245"
  "object_2245"
]
26 0.12 ms
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:
[
  1732194518
  "object_2245\x01tags\x01"
]
27 0.14 ms
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:
[
  1732194518
  "\x01tags\x01object_2235"
  "object_2235"
]
28 0.12 ms
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:
[
  1732194518
  "object_2235\x01tags\x01"
]
29 3.15 ms
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:
[
  1732194518
  "\x01tags\x01object_1"
  "object_1"
]
30 0.16 ms
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:
[
  1732194518
  "object_1\x01tags\x01"
]
31 0.05 ms
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2236,2245,2235,1,2294) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
32 0.05 ms
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2236,2245,2235,1,2294) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
33 0.07 ms
SELECT id FROM classes WHERE name = ?
Parameters:
[
  "Gegenstand"
]
34 0.07 ms
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"
  2294
  "taxonomie"
  2294
  "taxonomie"
  2294
]
35 0.20 ms
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:
[
  1732194518
  "\x01tags\x01object_2933"
  "object_2933"
]
36 0.20 ms
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:
[
  1732194518
  "object_2933\x01tags\x01"
  "class_7\x01tags\x01"
  "asset_13043\x01tags\x01"
]
37 0.07 ms
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,2933) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
38 0.21 ms
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:
[
  1732194518
  "\x01tags\x01object_2926"
  "object_2926"
]
39 0.71 ms
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:
[
  1732194518
  "object_2926\x01tags\x01"
  "class_7\x01tags\x01"
  "asset_13036\x01tags\x01"
]
40 0.06 ms
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,2926) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
41 0.20 ms
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:
[
  1732194518
  "\x01tags\x01object_2935"
  "object_2935"
]
42 0.15 ms
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:
[
  1732194518
  "object_2935\x01tags\x01"
  "class_7\x01tags\x01"
  "asset_13045\x01tags\x01"
]
43 0.05 ms
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,2935) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
44 0.19 ms
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:
[
  1732194518
  "\x01tags\x01object_2927"
  "object_2927"
]
45 35.71 ms
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:
[
  1732194518
  "object_2927\x01tags\x01"
  "class_7\x01tags\x01"
  "asset_13037\x01tags\x01"
]
46 0.10 ms
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,2927) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
47 0.18 ms
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:
[
  1732194518
  "\x01tags\x01object_2930"
  "object_2930"
]
48 1.36 ms
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:
[
  1732194518
  "object_2930\x01tags\x01"
  "class_7\x01tags\x01"
  "asset_13040\x01tags\x01"
]
49 0.05 ms
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,2930) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
50 0.14 ms
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:
[
  1732194518
  "\x01tags\x01object_2936"
  "object_2936"
]
51 1.26 ms
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:
[
  1732194518
  "object_2936\x01tags\x01"
  "class_7\x01tags\x01"
  "asset_13046\x01tags\x01"
]
52 0.05 ms
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,2936) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
53 0.21 ms
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:
[
  1732194518
  "\x01tags\x01object_2928"
  "object_2928"
]
54 0.16 ms
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:
[
  1732194518
  "object_2928\x01tags\x01"
  "class_7\x01tags\x01"
  "asset_13038\x01tags\x01"
]
55 0.05 ms
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,2928) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
56 1.04 ms
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:
[
  1732194518
  "\x01tags\x01object_2931"
  "object_2931"
]
57 0.14 ms
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:
[
  1732194518
  "object_2931\x01tags\x01"
  "class_7\x01tags\x01"
  "asset_13041\x01tags\x01"
]
58 0.05 ms
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,2931) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
59 0.80 ms
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:
[
  1732194518
  "\x01tags\x01object_2929"
  "object_2929"
]
60 0.16 ms
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:
[
  1732194518
  "object_2929\x01tags\x01"
  "class_7\x01tags\x01"
  "asset_13039\x01tags\x01"
]
61 0.05 ms
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,2929) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
62 0.17 ms
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:
[
  1732194518
  "\x01tags\x01object_2932"
  "object_2932"
]
63 0.56 ms
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:
[
  1732194518
  "object_2932\x01tags\x01"
  "class_7\x01tags\x01"
  "asset_13042\x01tags\x01"
]
64 0.05 ms
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,2932) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
65 0.27 ms
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:
[
  1732194518
  "\x01tags\x01object_2938"
  "object_2938"
]
66 0.99 ms
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:
[
  1732194518
  "object_2938\x01tags\x01"
  "class_7\x01tags\x01"
  "asset_13048\x01tags\x01"
]
67 0.06 ms
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,2938) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
68 0.17 ms
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:
[
  1732194518
  "\x01tags\x01object_2934"
  "object_2934"
]
69 0.81 ms
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:
[
  1732194518
  "object_2934\x01tags\x01"
  "class_7\x01tags\x01"
  "asset_13044\x01tags\x01"
]
70 0.05 ms
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,2934) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
71 0.14 ms
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:
[
  1732194518
  "\x01tags\x01object_2937"
  "object_2937"
]
72 0.81 ms
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:
[
  1732194518
  "object_2937\x01tags\x01"
  "class_7\x01tags\x01"
  "asset_13047\x01tags\x01"
]
73 0.05 ms
SELECT `read` FROM plugin_datahub_workspaces_object WHERE cid IN (1,2235,1,2937) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
74 0.14 ms
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:
[
  1732194518
  "\x01tags\x01asset_10901"
  "asset_10901"
]
75 0.17 ms
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:
[
  1732194518
  "asset_10901\x01tags\x01"
]
76 1.86 ms
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:
[
  1732194518
  "\x01tags\x01asset_1"
  "asset_1"
]
77 0.12 ms
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:
[
  1732194518
  "asset_1\x01tags\x01"
]
78 0.05 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13043) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
79 0.79 ms
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:
[
  1732194518
  "\x01tags\x01asset_13043"
  "asset_13043"
]
80 0.04 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13043) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
81 0.06 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13043) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
82 0.06 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13036) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
83 0.21 ms
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:
[
  1732194518
  "\x01tags\x01asset_13036"
  "asset_13036"
]
84 0.04 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13036) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
85 0.04 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13036) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
86 0.05 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13045) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
87 0.15 ms
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:
[
  1732194518
  "\x01tags\x01asset_13045"
  "asset_13045"
]
88 0.04 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13045) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
89 0.04 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13045) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
90 0.05 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13037) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
91 0.14 ms
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:
[
  1732194518
  "\x01tags\x01asset_13037"
  "asset_13037"
]
92 0.04 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13037) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
93 0.04 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13037) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
94 0.05 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13040) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
95 0.14 ms
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:
[
  1732194518
  "\x01tags\x01asset_13040"
  "asset_13040"
]
96 0.04 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13040) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
97 0.04 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13040) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
98 0.05 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13046) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
99 1.11 ms
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:
[
  1732194518
  "\x01tags\x01asset_13046"
  "asset_13046"
]
100 0.04 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13046) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
101 0.04 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13046) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
102 0.05 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13038) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
103 2.06 ms
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:
[
  1732194518
  "\x01tags\x01asset_13038"
  "asset_13038"
]
104 0.05 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13038) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
105 0.04 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13038) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
106 0.05 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13041) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
107 0.19 ms
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:
[
  1732194518
  "\x01tags\x01asset_13041"
  "asset_13041"
]
108 0.04 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13041) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
109 0.04 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13041) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
110 0.05 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13039) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
111 0.75 ms
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:
[
  1732194518
  "\x01tags\x01asset_13039"
  "asset_13039"
]
112 0.04 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13039) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
113 0.04 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13039) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
114 0.05 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13042) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
115 0.19 ms
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:
[
  1732194518
  "\x01tags\x01asset_13042"
  "asset_13042"
]
116 0.04 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13042) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
117 0.04 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13042) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
118 0.05 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13048) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
119 0.16 ms
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:
[
  1732194518
  "\x01tags\x01asset_13048"
  "asset_13048"
]
120 0.04 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13048) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
121 0.04 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13048) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
122 0.05 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13044) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
123 0.16 ms
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:
[
  1732194518
  "\x01tags\x01asset_13044"
  "asset_13044"
]
124 0.04 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13044) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
125 0.04 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13044) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
126 0.05 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13047) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
127 0.82 ms
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:
[
  1732194518
  "\x01tags\x01asset_13047"
  "asset_13047"
]
128 0.04 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13047) AND configuration = '1808_wurst' AND `read`=1 ORDER BY LENGTH(cpath) DESC LIMIT 1
Parameters:
[]
129 0.04 ms
SELECT `read` FROM plugin_datahub_workspaces_asset WHERE cid IN (1,10901,1,13047) 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.