Query Metrics
200
Database Queries
17
Different statements
166.78 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.98 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:
[ 1729582592 [ "\x00tags\x00site_domain_cf9606ab2a0c9ff7a0fa994399f7b5e9" "site_domain_cf9606ab2a0c9ff7a0fa994399f7b5e9" ] ] |
2 | 0.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:
[ 1729582592 [ "system\x00tags\x00" "site\x00tags\x00" "site_domain_cf9606ab2a0c9ff7a0fa994399f7b5e9\x00tags\x00" ] ] |
3 | 0.65 ms |
SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "sourcePath" => "/productoverview" "sourcePathQuery" => "/productoverview?brand=85&collection=342" "sourceEntireUri" => "http://zeit.at/productoverview?brand=85&collection=342" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
4 | 0.69 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:
[ 1729582592 [ "\x00tags\x00system_route_redirect" "system_route_redirect" ] ] |
5 | 0.63 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:
[ 1729582592 [ "system\x00tags\x00" "redirect\x00tags\x00" "route\x00tags\x00" "system_route_redirect\x00tags\x00" ] ] |
6 | 0.60 ms |
SELECT * FROM settings_store WHERE id = :id AND scope = :scope
Parameters:
[ "id" => "reports" "scope" => "pimcore" ] |
7 | 0.69 ms |
SELECT id FROM documents WHERE path = BINARY :path AND `key` = BINARY :key
Parameters:
[ "key" => "productoverview" "path" => "/" ] |
8 | 0.59 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:
[ 1729582592 [ "\x00tags\x00document_34" "document_34" ] ] |
9 | 0.52 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:
[ 1729582592 [ "document_34\x00tags\x00" ] ] |
10 | 0.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:
[ 1729582592 [ "\x00tags\x00document_properties_34" "document_properties_34" ] ] |
11 | 0.77 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:
[ 1729582592 [ "document_properties\x00tags\x00" "document_34\x00tags\x00" "document_properties_34\x00tags\x00" ] ] |
12 | 0.66 ms |
SELECT * FROM object_url_slugs WHERE slug = '/productoverview' AND siteId = 0 ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
13 | 0.78 ms |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
14 | 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:
[ 1729582592 [ "\x00tags\x00object_85" "object_85" ] ] |
15 | 0.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:
[ 1729582592 [ "object_85\x00tags\x00" "class_BRAND\x00tags\x00" "asset_173\x00tags\x00" ] ] |
16 | 0.63 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"BRAND"
]
|
17 | 0.90 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:
[ 1729582592 [ "\x00tags\x00object_267" "object_267" ] ] |
18 | 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:
[ 1729582592 [ "object_267\x00tags\x00" ] ] |
19 | 1.10 ms |
SELECT objects.o_id as o_id, objects.o_type as o_type FROM objects WHERE (o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1 ORDER BY `o_key` ASC
Parameters:
[
267
]
|
20 | 0.87 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:
[ 1729582592 [ "\x00tags\x00object_334" "object_334" ] ] |
21 | 0.83 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:
[ 1729582592 [ "object_334\x00tags\x00" "class_CATEGORY\x00tags\x00" ] ] |
22 | 0.43 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"CATEGORY"
]
|
23 | 0.62 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:
[ 1729582592 [ "\x00tags\x00object_335" "object_335" ] ] |
24 | 0.47 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:
[ 1729582592 [ "object_335\x00tags\x00" "class_CATEGORY\x00tags\x00" ] ] |
25 | 0.78 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:
[ 1729582592 [ "\x00tags\x00object_336" "object_336" ] ] |
26 | 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:
[ 1729582592 [ "object_336\x00tags\x00" "class_CATEGORY\x00tags\x00" ] ] |
27 | 0.52 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:
[ 1729582592 [ "\x00tags\x00object_337" "object_337" ] ] |
28 | 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:
[ 1729582592 [ "object_337\x00tags\x00" "class_CATEGORY\x00tags\x00" ] ] |
29 | 0.76 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:
[ 1729582592 [ "\x00tags\x00object_338" "object_338" ] ] |
30 | 0.66 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:
[ 1729582592 [ "object_338\x00tags\x00" "class_CATEGORY\x00tags\x00" ] ] |
31 | 0.60 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:
[ 1729582592 [ "\x00tags\x00object_339" "object_339" ] ] |
32 | 0.44 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:
[ 1729582592 [ "object_339\x00tags\x00" "class_CATEGORY\x00tags\x00" ] ] |
33 | 0.51 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:
[ 1729582592 [ "\x00tags\x00object_340" "object_340" ] ] |
34 | 0.48 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:
[ 1729582592 [ "object_340\x00tags\x00" "class_CATEGORY\x00tags\x00" ] ] |
35 | 0.51 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:
[ 1729582592 [ "\x00tags\x00object_341" "object_341" ] ] |
36 | 0.54 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:
[ 1729582592 [ "object_341\x00tags\x00" "class_CATEGORY\x00tags\x00" ] ] |
37 | 0.66 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:
[ 1729582592 [ "\x00tags\x00object_342" "object_342" ] ] |
38 | 0.58 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:
[ 1729582592 [ "object_342\x00tags\x00" "class_CATEGORY\x00tags\x00" ] ] |
39 | 0.70 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:
[ 1729582592 [ "\x00tags\x00object_343" "object_343" ] ] |
40 | 0.43 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:
[ 1729582592 [ "object_343\x00tags\x00" "class_CATEGORY\x00tags\x00" ] ] |
41 | 0.59 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:
[ 1729582592 [ "\x00tags\x00object_344" "object_344" ] ] |
42 | 0.54 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:
[ 1729582592 [ "object_344\x00tags\x00" "class_CATEGORY\x00tags\x00" ] ] |
43 | 0.73 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:
[ 1729582592 [ "\x00tags\x00object_345" "object_345" ] ] |
44 | 0.67 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:
[ 1729582592 [ "object_345\x00tags\x00" "class_CATEGORY\x00tags\x00" ] ] |
45 | 0.54 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:
[ 1729582592 [ "\x00tags\x00object_346" "object_346" ] ] |
46 | 0.70 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:
[ 1729582592 [ "object_346\x00tags\x00" "class_CATEGORY\x00tags\x00" ] ] |
47 | 8.38 ms |
SELECT object_localized_PRODUCT_de.o_id as o_id, object_localized_PRODUCT_de.o_type as o_type FROM object_localized_PRODUCT_de WHERE ((categories LIKE ?) AND (brand__id = ?) AND object_localized_PRODUCT_de.o_type IN ('object','folder')) AND object_localized_PRODUCT_de.o_published = 1 ORDER BY `stockInputDate` DESC
Parameters:
[ "%object|342%" "85" ] |
48 | 1.00 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:
[ 1729582592 [ "\x00tags\x00object_9708" "object_9708" ] ] |
49 | 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:
[ 1729582592 [ "object_9708\x00tags\x00" "class_PRODUCT\x00tags\x00" "asset_225362\x00tags\x00" ] ] |
50 | 0.52 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"PRODUCT"
]
|
51 | 0.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:
[ 1729582592 [ "\x00tags\x00object_7902" "object_7902" ] ] |
52 | 0.39 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:
[ 1729582592 [ "object_7902\x00tags\x00" "class_PRODUCT\x00tags\x00" "asset_331788\x00tags\x00" "asset_331789\x00tags\x00" ] ] |
53 | 0.55 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:
[ 1729582592 [ "\x00tags\x00object_7884" "object_7884" ] ] |
54 | 0.53 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:
[ 1729582592 [ "object_7884\x00tags\x00" "class_PRODUCT\x00tags\x00" "asset_329664\x00tags\x00" ] ] |
55 | 0.50 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:
[ 1729582592 [ "\x00tags\x00object_7880" "object_7880" ] ] |
56 | 0.66 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:
[ 1729582592 [ "object_7880\x00tags\x00" "class_PRODUCT\x00tags\x00" "asset_328836\x00tags\x00" ] ] |
57 | 2.13 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:
[ 1729582592 [ "\x00tags\x00object_7750" "object_7750" ] ] |
58 | 0.76 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:
[ 1729582592 [ "object_7750\x00tags\x00" "class_PRODUCT\x00tags\x00" "asset_312433\x00tags\x00" ] ] |
59 | 0.58 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
7750
]
|
60 | 0.73 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
7750
]
|
61 | 0.64 ms |
SELECT * FROM object_store_PRODUCT WHERE oo_id = ?
Parameters:
[
7750
]
|
62 | 0.69 ms |
SELECT * FROM object_localized_data_PRODUCT WHERE ooo_id = ? AND language IN ('en','de')
Parameters:
[
7750
]
|
63 | 0.84 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:
[ 1729582592 [ "\x00tags\x00asset_312433" "asset_312433" ] ] |
64 | 0.78 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:
[ 1729582592 [ "asset_312433\x00tags\x00" ] ] |
65 | 3.41 ms |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
312433
]
|
66 | 0.77 ms |
SELECT * FROM object_relations_PRODUCT WHERE src_id = ?
Parameters:
[
7750
]
|
67 | 1.03 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:
[ 1729582592 [ "\x00tags\x00object_7717" "object_7717" ] ] |
68 | 4.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:
[ 1729582592 [ "object_7717\x00tags\x00" "class_PRODUCT\x00tags\x00" "asset_309870\x00tags\x00" "asset_309871\x00tags\x00" ] ] |
69 | 0.47 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
7717
]
|
70 | 0.77 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
7717
]
|
71 | 0.43 ms |
SELECT * FROM object_store_PRODUCT WHERE oo_id = ?
Parameters:
[
7717
]
|
72 | 0.64 ms |
SELECT * FROM object_localized_data_PRODUCT WHERE ooo_id = ? AND language IN ('en','de')
Parameters:
[
7717
]
|
73 | 0.69 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:
[ 1729582592 [ "\x00tags\x00asset_309870" "asset_309870" ] ] |
74 | 0.63 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:
[ 1729582592 [ "asset_309870\x00tags\x00" ] ] |
75 | 2.05 ms |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
309870
]
|
76 | 0.85 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:
[ 1729582592 [ "\x00tags\x00asset_309871" "asset_309871" ] ] |
77 | 0.67 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:
[ 1729582592 [ "asset_309871\x00tags\x00" ] ] |
78 | 0.83 ms |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
309871
]
|
79 | 0.78 ms |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
309871
]
|
80 | 0.68 ms |
SELECT * FROM object_relations_PRODUCT WHERE src_id = ?
Parameters:
[
7717
]
|
81 | 2.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:
[ 1729582592 [ "\x00tags\x00object_5290" "object_5290" ] ] |
82 | 0.76 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:
[ 1729582592 [ "object_5290\x00tags\x00" "class_PRODUCT\x00tags\x00" "asset_243721\x00tags\x00" ] ] |
83 | 0.70 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
5290
]
|
84 | 0.80 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
5290
]
|
85 | 0.59 ms |
SELECT * FROM object_store_PRODUCT WHERE oo_id = ?
Parameters:
[
5290
]
|
86 | 0.52 ms |
SELECT * FROM object_localized_data_PRODUCT WHERE ooo_id = ? AND language IN ('en','de')
Parameters:
[
5290
]
|
87 | 0.60 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:
[ 1729582592 [ "\x00tags\x00asset_243721" "asset_243721" ] ] |
88 | 0.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:
[ 1729582592 [ "asset_243721\x00tags\x00" ] ] |
89 | 3.33 ms |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
243721
]
|
90 | 0.39 ms |
SELECT * FROM object_relations_PRODUCT WHERE src_id = ?
Parameters:
[
5290
]
|
91 | 1.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:
[ 1729582592 [ "\x00tags\x00object_5270" "object_5270" ] ] |
92 | 0.37 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:
[ 1729582592 [ "object_5270\x00tags\x00" "class_PRODUCT\x00tags\x00" "asset_243691\x00tags\x00" ] ] |
93 | 0.39 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
5270
]
|
94 | 0.68 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
5270
]
|
95 | 0.74 ms |
SELECT * FROM object_store_PRODUCT WHERE oo_id = ?
Parameters:
[
5270
]
|
96 | 0.68 ms |
SELECT * FROM object_localized_data_PRODUCT WHERE ooo_id = ? AND language IN ('en','de')
Parameters:
[
5270
]
|
97 | 0.66 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:
[ 1729582592 [ "\x00tags\x00asset_243691" "asset_243691" ] ] |
98 | 0.34 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:
[ 1729582592 [ "asset_243691\x00tags\x00" ] ] |
99 | 0.99 ms |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
243691
]
|
100 | 0.79 ms |
SELECT * FROM object_relations_PRODUCT WHERE src_id = ?
Parameters:
[
5270
]
|
101 | 0.85 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:
[ 1729582592 [ "\x00tags\x00object_5284" "object_5284" ] ] |
102 | 1.85 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:
[ 1729582592 [ "object_5284\x00tags\x00" "class_PRODUCT\x00tags\x00" "asset_243715\x00tags\x00" ] ] |
103 | 0.39 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
5284
]
|
104 | 0.64 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
5284
]
|
105 | 0.36 ms |
SELECT * FROM object_store_PRODUCT WHERE oo_id = ?
Parameters:
[
5284
]
|
106 | 0.37 ms |
SELECT * FROM object_localized_data_PRODUCT WHERE ooo_id = ? AND language IN ('en','de')
Parameters:
[
5284
]
|
107 | 0.62 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:
[ 1729582592 [ "\x00tags\x00asset_243715" "asset_243715" ] ] |
108 | 0.32 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:
[ 1729582592 [ "asset_243715\x00tags\x00" ] ] |
109 | 1.63 ms |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
243715
]
|
110 | 0.41 ms |
SELECT * FROM object_relations_PRODUCT WHERE src_id = ?
Parameters:
[
5284
]
|
111 | 2.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:
[ 1729582592 [ "\x00tags\x00object_5265" "object_5265" ] ] |
112 | 0.83 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:
[ 1729582592 [ "object_5265\x00tags\x00" "class_PRODUCT\x00tags\x00" "asset_243687\x00tags\x00" ] ] |
113 | 0.54 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
5265
]
|
114 | 0.68 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
5265
]
|
115 | 0.75 ms |
SELECT * FROM object_store_PRODUCT WHERE oo_id = ?
Parameters:
[
5265
]
|
116 | 0.63 ms |
SELECT * FROM object_localized_data_PRODUCT WHERE ooo_id = ? AND language IN ('en','de')
Parameters:
[
5265
]
|
117 | 0.77 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:
[ 1729582592 [ "\x00tags\x00asset_243687" "asset_243687" ] ] |
118 | 0.65 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:
[ 1729582592 [ "asset_243687\x00tags\x00" ] ] |
119 | 0.70 ms |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
243687
]
|
120 | 0.73 ms |
SELECT * FROM object_relations_PRODUCT WHERE src_id = ?
Parameters:
[
5265
]
|
121 | 2.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:
[ 1729582592 [ "\x00tags\x00object_5269" "object_5269" ] ] |
122 | 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:
[ 1729582592 [ "object_5269\x00tags\x00" "class_PRODUCT\x00tags\x00" "asset_243690\x00tags\x00" ] ] |
123 | 0.53 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
5269
]
|
124 | 0.53 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
5269
]
|
125 | 0.47 ms |
SELECT * FROM object_store_PRODUCT WHERE oo_id = ?
Parameters:
[
5269
]
|
126 | 0.51 ms |
SELECT * FROM object_localized_data_PRODUCT WHERE ooo_id = ? AND language IN ('en','de')
Parameters:
[
5269
]
|
127 | 0.62 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:
[ 1729582592 [ "\x00tags\x00asset_243690" "asset_243690" ] ] |
128 | 0.44 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:
[ 1729582592 [ "asset_243690\x00tags\x00" ] ] |
129 | 0.50 ms |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
243690
]
|
130 | 0.73 ms |
SELECT * FROM object_relations_PRODUCT WHERE src_id = ?
Parameters:
[
5269
]
|
131 | 0.42 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:
[ 1729582592 [ "\x00tags\x00object_5281" "object_5281" ] ] |
132 | 0.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:
[ 1729582592 [ "object_5281\x00tags\x00" "class_PRODUCT\x00tags\x00" "asset_243711\x00tags\x00" "asset_243712\x00tags\x00" ] ] |
133 | 0.29 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
5281
]
|
134 | 0.32 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
5281
]
|
135 | 0.24 ms |
SELECT * FROM object_store_PRODUCT WHERE oo_id = ?
Parameters:
[
5281
]
|
136 | 0.28 ms |
SELECT * FROM object_localized_data_PRODUCT WHERE ooo_id = ? AND language IN ('en','de')
Parameters:
[
5281
]
|
137 | 0.65 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:
[ 1729582592 [ "\x00tags\x00asset_243711" "asset_243711" ] ] |
138 | 0.47 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:
[ 1729582592 [ "asset_243711\x00tags\x00" ] ] |
139 | 2.01 ms |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
243711
]
|
140 | 0.73 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:
[ 1729582592 [ "\x00tags\x00asset_243712" "asset_243712" ] ] |
141 | 0.55 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:
[ 1729582592 [ "asset_243712\x00tags\x00" ] ] |
142 | 0.59 ms |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
243712
]
|
143 | 0.46 ms |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
243712
]
|
144 | 0.58 ms |
SELECT * FROM object_relations_PRODUCT WHERE src_id = ?
Parameters:
[
5281
]
|
145 | 4.47 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:
[ 1729582592 [ "\x00tags\x00object_5274" "object_5274" ] ] |
146 | 0.52 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:
[ 1729582592 [ "object_5274\x00tags\x00" "class_PRODUCT\x00tags\x00" "asset_243696\x00tags\x00" ] ] |
147 | 0.35 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
5274
]
|
148 | 0.40 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
5274
]
|
149 | 0.34 ms |
SELECT * FROM object_store_PRODUCT WHERE oo_id = ?
Parameters:
[
5274
]
|
150 | 0.41 ms |
SELECT * FROM object_localized_data_PRODUCT WHERE ooo_id = ? AND language IN ('en','de')
Parameters:
[
5274
]
|
151 | 0.41 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:
[ 1729582592 [ "\x00tags\x00asset_243696" "asset_243696" ] ] |
152 | 0.73 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:
[ 1729582592 [ "asset_243696\x00tags\x00" ] ] |
153 | 0.41 ms |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
243696
]
|
154 | 0.73 ms |
SELECT * FROM object_relations_PRODUCT WHERE src_id = ?
Parameters:
[
5274
]
|
155 | 1.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:
[ 1729582592 [ "\x00tags\x00object_5282" "object_5282" ] ] |
156 | 0.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:
[ 1729582592 [ "object_5282\x00tags\x00" "class_PRODUCT\x00tags\x00" "asset_243713\x00tags\x00" ] ] |
157 | 0.30 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
5282
]
|
158 | 0.50 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
5282
]
|
159 | 0.34 ms |
SELECT * FROM object_store_PRODUCT WHERE oo_id = ?
Parameters:
[
5282
]
|
160 | 0.34 ms |
SELECT * FROM object_localized_data_PRODUCT WHERE ooo_id = ? AND language IN ('en','de')
Parameters:
[
5282
]
|
161 | 0.58 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:
[ 1729582592 [ "\x00tags\x00asset_243713" "asset_243713" ] ] |
162 | 0.38 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:
[ 1729582592 [ "asset_243713\x00tags\x00" ] ] |
163 | 0.47 ms |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
243713
]
|
164 | 0.37 ms |
SELECT * FROM object_relations_PRODUCT WHERE src_id = ?
Parameters:
[
5282
]
|
165 | 1.87 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:
[ 1729582592 [ "\x00tags\x00object_5280" "object_5280" ] ] |
166 | 0.60 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:
[ 1729582592 [ "object_5280\x00tags\x00" "class_PRODUCT\x00tags\x00" "asset_243710\x00tags\x00" ] ] |
167 | 0.43 ms |
SELECT o_type,o_className,o_classId FROM objects WHERE o_id = ?
Parameters:
[
5280
]
|
168 | 0.44 ms |
SELECT objects.*, tree_locks.locked as o_locked FROM objects LEFT JOIN tree_locks ON objects.o_id = tree_locks.id AND tree_locks.type = 'object' WHERE o_id = ?
Parameters:
[
5280
]
|
169 | 0.35 ms |
SELECT * FROM object_store_PRODUCT WHERE oo_id = ?
Parameters:
[
5280
]
|
170 | 0.49 ms |
SELECT * FROM object_localized_data_PRODUCT WHERE ooo_id = ? AND language IN ('en','de')
Parameters:
[
5280
]
|
171 | 0.49 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:
[ 1729582592 [ "\x00tags\x00asset_243710" "asset_243710" ] ] |
172 | 0.62 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:
[ 1729582592 [ "asset_243710\x00tags\x00" ] ] |
173 | 0.49 ms |
SELECT assets.*, tree_locks.locked FROM assets LEFT JOIN tree_locks ON assets.id = tree_locks.id AND tree_locks.type = 'asset' WHERE assets.id = ?
Parameters:
[
243710
]
|
174 | 0.40 ms |
SELECT * FROM object_relations_PRODUCT WHERE src_id = ?
Parameters:
[
5280
]
|
175 | 0.50 ms |
SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ 334 "object" ] |
176 | 6.12 ms |
SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ "object" 334 ] |
177 | 6.26 ms |
SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ 335 "object" ] |
178 | 0.72 ms |
SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ "object" 335 ] |
179 | 0.62 ms |
SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ 336 "object" ] |
180 | 0.95 ms |
SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ "object" 336 ] |
181 | 1.13 ms |
SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ 337 "object" ] |
182 | 0.62 ms |
SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ "object" 337 ] |
183 | 0.59 ms |
SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ 338 "object" ] |
184 | 0.66 ms |
SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ "object" 338 ] |
185 | 0.69 ms |
SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ 339 "object" ] |
186 | 0.47 ms |
SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ "object" 339 ] |
187 | 0.48 ms |
SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ 340 "object" ] |
188 | 0.51 ms |
SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ "object" 340 ] |
189 | 0.40 ms |
SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ 341 "object" ] |
190 | 0.45 ms |
SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ "object" 341 ] |
191 | 0.35 ms |
SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ 342 "object" ] |
192 | 0.68 ms |
SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ "object" 342 ] |
193 | 0.37 ms |
SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ 343 "object" ] |
194 | 0.59 ms |
SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ "object" 343 ] |
195 | 0.51 ms |
SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ 344 "object" ] |
196 | 0.44 ms |
SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ "object" 344 ] |
197 | 0.47 ms |
SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ 345 "object" ] |
198 | 0.54 ms |
SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ "object" 345 ] |
199 | 0.39 ms |
SELECT dependencies.targetid,dependencies.targettype FROM dependencies LEFT JOIN objects ON dependencies.targettype="object" AND dependencies.targetid=objects.o_id LEFT JOIN assets ON dependencies.targettype="asset" AND dependencies.targetid=assets.id LEFT JOIN documents ON dependencies.targettype="document" AND dependencies.targetid=documents.id WHERE dependencies.sourceid = ? AND dependencies.sourcetype = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ 346 "object" ] |
200 | 0.40 ms |
SELECT dependencies.sourceid, dependencies.sourcetype FROM dependencies LEFT JOIN objects ON dependencies.sourceid=objects.o_id AND dependencies.sourcetype="object" LEFT JOIN assets ON dependencies.sourceid=assets.id AND dependencies.sourcetype="asset" LEFT JOIN documents ON dependencies.sourceid=documents.id AND dependencies.sourcetype="document" WHERE dependencies.targettype = ? AND dependencies.targetid = ? ORDER BY objects.o_path, objects.o_key, documents.path, documents.key, assets.path, assets.filename
Parameters:
[ "object" 346 ] |
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.