Query Metrics
543
Database Queries
46
Different statements
167.31 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 1.26 ms |
SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters:
[ "defaultShopConfig" null null ] |
2 | 0.15 ms |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
2
]
|
3 | 0.31 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:
[ 1760800148 "site_domain_5bf78f8413264a3d609636c85ff8920c" ] |
4 | 0.24 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:
[ 1760800148 "system\x01tags\x01" "site\x01tags\x01" ] |
5 | 0.26 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
6 | 0.38 ms |
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 = 3 AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "/produkte/karten_mc623/gluckwunschkarten_sc626" "path" "auto_create" "/produkte/karten_mc623/gluckwunschkarten_sc626" "path_query" "https://shop.bsz-stiftung.a4interactive.ch/produkte/karten_mc623/gluckwunschkarten_sc626" "entire_uri" ] |
7 | 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:
[ 1760800148 "system_route_redirect" ] |
8 | 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:
[ 1760800148 "system\x01tags\x01" "redirect\x01tags\x01" "route\x01tags\x01" ] |
9 | 0.25 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"maintenance_mode"
]
|
10 | 0.17 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "reports" "pimcore" ] |
11 | 0.24 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/produkte/karten_mc623/" "gluckwunschkarten_sc626" ] |
12 | 0.16 ms |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/shop/produkte/karten_mc623/gluckwunschkarten_sc626"
]
|
13 | 0.20 ms |
SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[ "/shop/%" "/produkte/karten_mc623/gluckwunschkarten_sc626" ] |
14 | 0.11 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/produkte/" "karten_mc623" ] |
15 | 0.12 ms |
SELECT id FROM documents_page WHERE prettyUrl = ?
Parameters:
[
"/shop/produkte/karten_mc623"
]
|
16 | 0.15 ms |
SELECT documents.id FROM documents LEFT JOIN documents_page ON documents.id = documents_page.id WHERE documents.path LIKE ? AND documents_page.prettyUrl = ?
Parameters:
[ "/shop/%" "/produkte/karten_mc623" ] |
17 | 0.11 ms |
SELECT id FROM documents WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/" "produkte" ] |
18 | 0.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:
[ 1760800148 "document_8" ] |
19 | 0.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:
[ 1760800148 "document_8\x01tags\x01" "asset_7\x01tags\x01" ] |
20 | 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:
[ 1760800148 "document_properties_8" ] |
21 | 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:
[ 1760800148 "document_properties\x01tags\x01" "document_8\x01tags\x01" ] |
22 | 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:
[ 1760800148 "object_626" ] |
23 | 0.26 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"8"
]
|
24 | 0.22 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:
[ 1760800148 "object_626\x01tags\x01" "class_8\x01tags\x01" ] |
25 | 0.24 ms |
SELECT * FROM object_relations_8 WHERE src_id = ?
Parameters:
[
626
]
|
26 | 0.35 ms |
SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters:
[ "fallbackFilterdefinition" null null ] |
27 | 0.14 ms |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
1
]
|
28 | 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:
[ 1760800148 "object_14" ] |
29 | 0.28 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:
[ 1760800148 "object_14\x01tags\x01" "class_EF_FD\x01tags\x01" ] |
30 | 0.25 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"EF_FD"
]
|
31 | 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:
[ 1760800148 "object_10" ] |
32 | 0.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:
[ 1760800148 "object_10\x01tags\x01" ] |
33 | 0.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:
[ 1760800148 "object_9" ] |
34 | 0.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:
[ 1760800148 "object_9\x01tags\x01" ] |
35 | 0.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:
[ 1760800148 "object_4" ] |
36 | 0.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:
[ 1760800148 "object_4\x01tags\x01" ] |
37 | 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:
[ 1760800148 "object_1" ] |
38 | 0.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:
[ 1760800148 "object_1\x01tags\x01" ] |
39 | 0.61 ms |
SELECT SQL_CALC_FOUND_ROWS a.id, priceSystemName FROM shop_productindex a WHERE active = 1 AND virtualProductActive = 1 AND inProductList = 1 AND (parentCategoryIds LIKE '%,626,%') LIMIT 12
Parameters:
[] |
40 | 0.07 ms |
SELECT FOUND_ROWS()
Parameters:
[] |
41 | 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:
[ 1760800148 "object_839" ] |
42 | 0.34 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"7"
]
|
43 | 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:
[ 1760800148 "object_839\x01tags\x01" "class_7\x01tags\x01" "asset_4062\x01tags\x01" "asset_4059\x01tags\x01" ] |
44 | 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:
[ 1760800148 "object_840" ] |
45 | 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:
[ 1760800148 "object_840\x01tags\x01" "class_7\x01tags\x01" "asset_3727\x01tags\x01" "asset_3714\x01tags\x01" "asset_3713\x01tags\x01" "asset_3718\x01tags\x01" ] |
46 | 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:
[ 1760800148 "object_875" ] |
47 | 0.33 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:
[ 1760800148 "object_875\x01tags\x01" "class_7\x01tags\x01" "asset_2243\x01tags\x01" ] |
48 | 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:
[ 1760800148 "object_877" ] |
49 | 0.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:
[ 1760800148 "object_877\x01tags\x01" "class_7\x01tags\x01" "asset_2247\x01tags\x01" ] |
50 | 0.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:
[ 1760800148 "object_878" ] |
51 | 0.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:
[ 1760800148 "object_878\x01tags\x01" "class_7\x01tags\x01" "asset_2249\x01tags\x01" ] |
52 | 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:
[ 1760800148 "object_884" ] |
53 | 0.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:
[ 1760800148 "object_884\x01tags\x01" "class_7\x01tags\x01" "asset_2263\x01tags\x01" ] |
54 | 0.31 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:
[ 1760800148 "object_958" ] |
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:
[ 1760800148 "object_958\x01tags\x01" "class_7\x01tags\x01" "asset_2531\x01tags\x01" ] |
56 | 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:
[ 1760800148 "object_963" ] |
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:
[ 1760800148 "object_963\x01tags\x01" "class_7\x01tags\x01" "asset_2541\x01tags\x01" ] |
58 | 0.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:
[ 1760800148 "object_965" ] |
59 | 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:
[ 1760800148 "object_965\x01tags\x01" "class_7\x01tags\x01" "asset_2545\x01tags\x01" ] |
60 | 0.31 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:
[ 1760800148 "object_2195" ] |
61 | 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:
[ 1760800148 "object_2195\x01tags\x01" "class_7\x01tags\x01" "asset_3717\x01tags\x01" "asset_3714\x01tags\x01" "asset_3713\x01tags\x01" "asset_3718\x01tags\x01" ] |
62 | 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:
[ 1760800148 "object_4876" ] |
63 | 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:
[ 1760800148 "object_4876\x01tags\x01" "class_7\x01tags\x01" "asset_4579\x01tags\x01" "asset_4568\x01tags\x01" ] |
64 | 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:
[ 1760800148 "object_4878" ] |
65 | 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:
[ 1760800148 "object_4878\x01tags\x01" "class_7\x01tags\x01" "asset_4570\x01tags\x01" "asset_4571\x01tags\x01" ] |
66 | 0.20 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
8
]
|
67 | 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:
[ 1760800148 "website_config_de_site_3" ] |
68 | 0.16 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"9"
]
|
69 | 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:
[ 1760800148 "website_config\x01tags\x01" "system\x01tags\x01" "config\x01tags\x01" "output\x01tags\x01" "document_76\x01tags\x01" "object_14\x01tags\x01" "object_15\x01tags\x01" "object_18\x01tags\x01" "document_8\x01tags\x01" "asset_3602\x01tags\x01" "document_46\x01tags\x01" "asset_4914\x01tags\x01" "asset_3607\x01tags\x01" "asset_2806\x01tags\x01" "asset_4913\x01tags\x01" "document_52\x01tags\x01" "object_2271\x01tags\x01" "document_75\x01tags\x01" "object_4004\x01tags\x01" ] |
70 | 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:
[ 1760800148 "document_19" ] |
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:
[ 1760800148 "document_19\x01tags\x01" "asset_7\x01tags\x01" ] |
72 | 0.32 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
73 | 0.32 ms |
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:
[ "/_fragment" "path" "auto_create" "/_fragment?_path=_format=html&_locale=de&_controller=App%5CController%5CFavouriteController%3A%3AfavouritesCounterAction" "path_query" "https://shop.bsz-stiftung.a4interactive.ch/_fragment?_path=_format=html&_locale=de&_controller=App%5CController%5CFavouriteController%3A%3AfavouritesCounterAction" "entire_uri" ] |
74 | 0.31 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
75 | 0.32 ms |
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:
[ "/_fragment" "path" "auto_create" "/_fragment?_path=_format=html&_locale=de&_controller=App%5CController%5CCartController%3A%3AcartCounterAction" "path_query" "https://shop.bsz-stiftung.a4interactive.ch/_fragment?_path=_format=html&_locale=de&_controller=App%5CController%5CCartController%3A%3AcartCounterAction" "entire_uri" ] |
76 | 0.22 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
77 | 0.28 ms |
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:
[ "/_fragment" "path" "auto_create" "/_fragment?_path=_format=html&_locale=de&_controller=App%5CController%5CCategoriesController%3A%3AallCategoriesAction" "path_query" "https://shop.bsz-stiftung.a4interactive.ch/_fragment?_path=_format=html&_locale=de&_controller=App%5CController%5CCategoriesController%3A%3AallCategoriesAction" "entire_uri" ] |
78 | 0.23 ms |
SELECT * FROM website_settings WHERE name = ? AND ( siteId IS NULL OR siteId = 0 OR siteId = ? ) AND ( language IS NULL OR language = '' OR language = ? ) ORDER BY CONCAT(siteId, language) DESC, siteId DESC, language DESC
Parameters:
[ "rootCategory" null null ] |
79 | 0.14 ms |
SELECT * FROM website_settings WHERE id = ?
Parameters:
[
4
]
|
80 | 0.17 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/kategorien/" "hauptkategorie" ] |
81 | 0.32 ms |
SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = ? AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `index` ASC
Parameters:
[
18
]
|
82 | 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:
[ 1760800148 "object_40" ] |
83 | 0.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:
[ 1760800148 "object_40\x01tags\x01" "class_8\x01tags\x01" ] |
84 | 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:
[ 1760800148 "object_1355" ] |
85 | 0.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:
[ 1760800148 "object_1355\x01tags\x01" "class_8\x01tags\x01" ] |
86 | 0.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:
[ 1760800148 "object_623" ] |
87 | 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:
[ 1760800148 "object_623\x01tags\x01" "class_8\x01tags\x01" ] |
88 | 0.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:
[ 1760800148 "object_602" ] |
89 | 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:
[ 1760800148 "object_602\x01tags\x01" "class_8\x01tags\x01" ] |
90 | 0.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:
[ 1760800148 "object_596" ] |
91 | 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:
[ 1760800148 "object_596\x01tags\x01" "class_8\x01tags\x01" ] |
92 | 0.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:
[ 1760800148 "object_641" ] |
93 | 0.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:
[ 1760800148 "object_641\x01tags\x01" "class_8\x01tags\x01" ] |
94 | 0.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:
[ 1760800148 "object_597" ] |
95 | 0.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:
[ 1760800148 "object_597\x01tags\x01" "class_8\x01tags\x01" ] |
96 | 0.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:
[ 1760800148 "object_7144" ] |
97 | 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:
[ 1760800148 "object_7144\x01tags\x01" "class_8\x01tags\x01" ] |
98 | 0.56 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:
[ "categories" 40 "categories" 40 "categories" 40 ] |
99 | 0.19 ms |
SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = ? AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC
Parameters:
[
40
]
|
100 | 0.40 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:
[ "categories" 1355 "categories" 1355 "categories" 1355 ] |
101 | 0.18 ms |
SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = ? AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC
Parameters:
[
1355
]
|
102 | 0.94 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:
[ "categories" 623 "categories" 623 "categories" 623 ] |
103 | 0.22 ms |
SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = ? AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC
Parameters:
[
623
]
|
104 | 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:
[ 1760800148 "object_708" ] |
105 | 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:
[ 1760800148 "object_708\x01tags\x01" "class_8\x01tags\x01" ] |
106 | 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:
[ 1760800148 "object_624" ] |
107 | 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:
[ 1760800148 "object_624\x01tags\x01" "class_8\x01tags\x01" ] |
108 | 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:
[ 1760800148 "object_6315" ] |
109 | 0.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:
[ 1760800148 "object_6315\x01tags\x01" "class_8\x01tags\x01" ] |
110 | 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:
[ 1760800148 "object_4872" ] |
111 | 0.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:
[ 1760800148 "object_4872\x01tags\x01" "class_8\x01tags\x01" ] |
112 | 0.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:
[ 1760800148 "object_633" ] |
113 | 0.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:
[ 1760800148 "object_633\x01tags\x01" "class_8\x01tags\x01" ] |
114 | 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:
[ 1760800148 "object_832" ] |
115 | 0.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:
[ 1760800148 "object_832\x01tags\x01" "class_8\x01tags\x01" ] |
116 | 0.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:
[ 1760800148 "object_628" ] |
117 | 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:
[ 1760800148 "object_628\x01tags\x01" "class_8\x01tags\x01" ] |
118 | 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:
[ 1760800148 "object_658" ] |
119 | 0.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:
[ 1760800148 "object_658\x01tags\x01" "class_8\x01tags\x01" ] |
120 | 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:
[ 1760800148 "object_631" ] |
121 | 0.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:
[ 1760800148 "object_631\x01tags\x01" "class_8\x01tags\x01" ] |
122 | 0.84 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:
[ "categories" 708 "categories" 708 "categories" 708 ] |
123 | 0.45 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:
[ "categories" 624 "categories" 624 "categories" 624 ] |
124 | 0.48 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:
[ "categories" 6315 "categories" 6315 "categories" 6315 ] |
125 | 0.42 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:
[ "categories" 4872 "categories" 4872 "categories" 4872 ] |
126 | 0.44 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:
[ "categories" 633 "categories" 633 "categories" 633 ] |
127 | 0.44 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:
[ "categories" 832 "categories" 832 "categories" 832 ] |
128 | 0.48 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:
[ "categories" 626 "categories" 626 "categories" 626 ] |
129 | 0.42 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:
[ "categories" 628 "categories" 628 "categories" 628 ] |
130 | 0.43 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:
[ "categories" 658 "categories" 658 "categories" 658 ] |
131 | 0.48 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:
[ "categories" 631 "categories" 631 "categories" 631 ] |
132 | 0.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:
[ 1760800148 "sites_path_mapping" ] |
133 | 0.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:
[ 1760800148 "system\x01tags\x01" "resource\x01tags\x01" ] |
134 | 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:
[ 1760800148 "site_id_3" ] |
135 | 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:
[ 1760800148 "system\x01tags\x01" "site\x01tags\x01" ] |
136 | 0.78 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:
[ "categories" 708 "categories" 708 "categories" 708 ] |
137 | 0.46 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:
[ "categories" 624 "categories" 624 "categories" 624 ] |
138 | 0.48 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:
[ "categories" 6315 "categories" 6315 "categories" 6315 ] |
139 | 0.43 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:
[ "categories" 4872 "categories" 4872 "categories" 4872 ] |
140 | 0.43 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:
[ "categories" 633 "categories" 633 "categories" 633 ] |
141 | 0.43 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:
[ "categories" 832 "categories" 832 "categories" 832 ] |
142 | 0.48 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:
[ "categories" 626 "categories" 626 "categories" 626 ] |
143 | 0.42 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:
[ "categories" 628 "categories" 628 "categories" 628 ] |
144 | 0.44 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:
[ "categories" 658 "categories" 658 "categories" 658 ] |
145 | 0.50 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:
[ "categories" 631 "categories" 631 "categories" 631 ] |
146 | 0.97 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:
[ "categories" 602 "categories" 602 "categories" 602 ] |
147 | 0.23 ms |
SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = ? AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC
Parameters:
[
602
]
|
148 | 0.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:
[ 1760800148 "object_818" ] |
149 | 0.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:
[ 1760800148 "object_818\x01tags\x01" "class_8\x01tags\x01" ] |
150 | 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:
[ 1760800148 "object_634" ] |
151 | 0.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:
[ 1760800148 "object_634\x01tags\x01" "class_8\x01tags\x01" ] |
152 | 0.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:
[ 1760800148 "object_604" ] |
153 | 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:
[ 1760800148 "object_604\x01tags\x01" "class_8\x01tags\x01" ] |
154 | 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:
[ 1760800148 "object_792" ] |
155 | 0.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:
[ 1760800148 "object_792\x01tags\x01" "class_8\x01tags\x01" ] |
156 | 0.46 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:
[ "categories" 818 "categories" 818 "categories" 818 ] |
157 | 0.42 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:
[ "categories" 634 "categories" 634 "categories" 634 ] |
158 | 0.48 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:
[ "categories" 604 "categories" 604 "categories" 604 ] |
159 | 0.61 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:
[ "categories" 792 "categories" 792 "categories" 792 ] |
160 | 0.45 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:
[ "categories" 818 "categories" 818 "categories" 818 ] |
161 | 0.41 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:
[ "categories" 634 "categories" 634 "categories" 634 ] |
162 | 0.48 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:
[ "categories" 604 "categories" 604 "categories" 604 ] |
163 | 0.61 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:
[ "categories" 792 "categories" 792 "categories" 792 ] |
164 | 0.70 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:
[ "categories" 596 "categories" 596 "categories" 596 ] |
165 | 0.23 ms |
SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = ? AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC
Parameters:
[
596
]
|
166 | 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:
[ 1760800148 "object_603" ] |
167 | 0.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:
[ 1760800148 "object_603\x01tags\x01" "class_8\x01tags\x01" ] |
168 | 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:
[ 1760800148 "object_843" ] |
169 | 0.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:
[ 1760800148 "object_843\x01tags\x01" "class_8\x01tags\x01" ] |
170 | 0.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:
[ 1760800148 "object_598" ] |
171 | 0.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:
[ 1760800148 "object_598\x01tags\x01" "class_8\x01tags\x01" ] |
172 | 0.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:
[ 1760800148 "object_607" ] |
173 | 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:
[ 1760800148 "object_607\x01tags\x01" "class_8\x01tags\x01" ] |
174 | 0.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:
[ 1760800148 "object_829" ] |
175 | 0.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:
[ 1760800148 "object_829\x01tags\x01" "class_8\x01tags\x01" ] |
176 | 0.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:
[ 1760800148 "object_611" ] |
177 | 0.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:
[ 1760800148 "object_611\x01tags\x01" "class_8\x01tags\x01" ] |
178 | 0.64 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:
[ "categories" 603 "categories" 603 "categories" 603 ] |
179 | 0.47 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:
[ "categories" 843 "categories" 843 "categories" 843 ] |
180 | 0.49 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:
[ "categories" 598 "categories" 598 "categories" 598 ] |
181 | 0.44 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:
[ "categories" 607 "categories" 607 "categories" 607 ] |
182 | 0.43 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:
[ "categories" 829 "categories" 829 "categories" 829 ] |
183 | 0.48 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:
[ "categories" 611 "categories" 611 "categories" 611 ] |
184 | 0.60 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:
[ "categories" 603 "categories" 603 "categories" 603 ] |
185 | 0.45 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:
[ "categories" 843 "categories" 843 "categories" 843 ] |
186 | 0.50 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:
[ "categories" 598 "categories" 598 "categories" 598 ] |
187 | 0.43 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:
[ "categories" 607 "categories" 607 "categories" 607 ] |
188 | 0.43 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:
[ "categories" 829 "categories" 829 "categories" 829 ] |
189 | 0.49 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:
[ "categories" 611 "categories" 611 "categories" 611 ] |
190 | 0.99 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:
[ "categories" 641 "categories" 641 "categories" 641 ] |
191 | 0.24 ms |
SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = ? AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC
Parameters:
[
641
]
|
192 | 0.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:
[ 1760800148 "object_805" ] |
193 | 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:
[ 1760800148 "object_805\x01tags\x01" "class_8\x01tags\x01" ] |
194 | 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:
[ 1760800148 "object_3850" ] |
195 | 0.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:
[ 1760800148 "object_3850\x01tags\x01" "class_8\x01tags\x01" ] |
196 | 0.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:
[ 1760800148 "object_850" ] |
197 | 0.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:
[ 1760800148 "object_850\x01tags\x01" "class_8\x01tags\x01" ] |
198 | 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:
[ 1760800148 "object_1010" ] |
199 | 0.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:
[ 1760800148 "object_1010\x01tags\x01" "class_8\x01tags\x01" ] |
200 | 0.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:
[ 1760800148 "object_6831" ] |
201 | 0.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:
[ 1760800148 "object_6831\x01tags\x01" "class_8\x01tags\x01" ] |
202 | 0.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:
[ 1760800148 "object_5352" ] |
203 | 0.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:
[ 1760800148 "object_5352\x01tags\x01" "class_8\x01tags\x01" ] |
204 | 0.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:
[ 1760800148 "object_5353" ] |
205 | 0.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:
[ 1760800148 "object_5353\x01tags\x01" "class_8\x01tags\x01" ] |
206 | 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:
[ 1760800148 "object_649" ] |
207 | 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:
[ 1760800148 "object_649\x01tags\x01" "class_8\x01tags\x01" ] |
208 | 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:
[ 1760800148 "object_5354" ] |
209 | 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:
[ 1760800148 "object_5354\x01tags\x01" "class_8\x01tags\x01" ] |
210 | 0.57 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:
[ "categories" 805 "categories" 805 "categories" 805 ] |
211 | 0.46 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:
[ "categories" 3850 "categories" 3850 "categories" 3850 ] |
212 | 0.44 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:
[ "categories" 850 "categories" 850 "categories" 850 ] |
213 | 0.41 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:
[ "categories" 1010 "categories" 1010 "categories" 1010 ] |
214 | 0.44 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:
[ "categories" 6831 "categories" 6831 "categories" 6831 ] |
215 | 0.47 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:
[ "categories" 5352 "categories" 5352 "categories" 5352 ] |
216 | 0.49 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:
[ "categories" 5353 "categories" 5353 "categories" 5353 ] |
217 | 0.51 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:
[ "categories" 649 "categories" 649 "categories" 649 ] |
218 | 0.51 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:
[ "categories" 5354 "categories" 5354 "categories" 5354 ] |
219 | 0.49 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:
[ "categories" 805 "categories" 805 "categories" 805 ] |
220 | 0.43 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:
[ "categories" 3850 "categories" 3850 "categories" 3850 ] |
221 | 0.43 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:
[ "categories" 850 "categories" 850 "categories" 850 ] |
222 | 0.41 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:
[ "categories" 1010 "categories" 1010 "categories" 1010 ] |
223 | 0.45 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:
[ "categories" 6831 "categories" 6831 "categories" 6831 ] |
224 | 0.47 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:
[ "categories" 5352 "categories" 5352 "categories" 5352 ] |
225 | 0.46 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:
[ "categories" 5353 "categories" 5353 "categories" 5353 ] |
226 | 0.51 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:
[ "categories" 649 "categories" 649 "categories" 649 ] |
227 | 0.52 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:
[ "categories" 5354 "categories" 5354 "categories" 5354 ] |
228 | 0.55 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:
[ "categories" 597 "categories" 597 "categories" 597 ] |
229 | 0.24 ms |
SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = ? AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC
Parameters:
[
597
]
|
230 | 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:
[ 1760800148 "object_599" ] |
231 | 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:
[ 1760800148 "object_599\x01tags\x01" "class_8\x01tags\x01" ] |
232 | 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:
[ 1760800148 "object_6790" ] |
233 | 0.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:
[ 1760800148 "object_6790\x01tags\x01" "class_8\x01tags\x01" ] |
234 | 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:
[ 1760800148 "object_6462" ] |
235 | 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:
[ 1760800148 "object_6462\x01tags\x01" "class_8\x01tags\x01" ] |
236 | 0.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:
[ 1760800148 "object_931" ] |
237 | 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:
[ 1760800148 "object_931\x01tags\x01" "class_8\x01tags\x01" ] |
238 | 0.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:
[ 1760800148 "object_663" ] |
239 | 0.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:
[ 1760800148 "object_663\x01tags\x01" "class_8\x01tags\x01" ] |
240 | 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:
[ 1760800148 "object_608" ] |
241 | 0.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:
[ 1760800148 "object_608\x01tags\x01" "class_8\x01tags\x01" ] |
242 | 0.50 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:
[ "categories" 599 "categories" 599 "categories" 599 ] |
243 | 0.42 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:
[ "categories" 6790 "categories" 6790 "categories" 6790 ] |
244 | 0.41 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:
[ "categories" 6462 "categories" 6462 "categories" 6462 ] |
245 | 0.41 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:
[ "categories" 931 "categories" 931 "categories" 931 ] |
246 | 0.54 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:
[ "categories" 663 "categories" 663 "categories" 663 ] |
247 | 0.53 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:
[ "categories" 608 "categories" 608 "categories" 608 ] |
248 | 0.47 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:
[ "categories" 599 "categories" 599 "categories" 599 ] |
249 | 0.42 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:
[ "categories" 6790 "categories" 6790 "categories" 6790 ] |
250 | 0.40 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:
[ "categories" 6462 "categories" 6462 "categories" 6462 ] |
251 | 0.46 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:
[ "categories" 931 "categories" 931 "categories" 931 ] |
252 | 0.57 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:
[ "categories" 663 "categories" 663 "categories" 663 ] |
253 | 0.48 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:
[ "categories" 608 "categories" 608 "categories" 608 ] |
254 | 0.43 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:
[ "categories" 7144 "categories" 7144 "categories" 7144 ] |
255 | 0.20 ms |
SELECT objects.id as id, objects.type as `type` FROM objects WHERE (parentId = ? AND objects.type IN ('object','variant','folder')) AND objects.published = 1 ORDER BY `key` ASC
Parameters:
[
7144
]
|
256 | 0.25 ms |
SELECT * FROM translations_messages LIMIT 1;
Parameters:
[] |
257 | 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:
[ 1760800148 "translation_data_1d19e47125946f5a6366d64de93b5d4f" ] |
258 | 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:
[ 1760800148 "translator\x01tags\x01" "translator_website\x01tags\x01" "translate\x01tags\x01" ] |
259 | 0.17 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
260 | 0.32 ms |
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:
[ "/_fragment" "path" "auto_create" "/_fragment?_path=_format=html&_locale=de&_controller=App%5CController%5CFavouriteController%3A%3AfavouritesNavigationAction" "path_query" "https://shop.bsz-stiftung.a4interactive.ch/_fragment?_path=_format=html&_locale=de&_controller=App%5CController%5CFavouriteController%3A%3AfavouritesNavigationAction" "entire_uri" ] |
261 | 0.20 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
262 | 0.28 ms |
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:
[ "/_fragment" "path" "auto_create" "/_fragment?_path=_format=html&_locale=de&_controller=App%5CController%5CCartController%3A%3AcartNavigationAction" "path_query" "https://shop.bsz-stiftung.a4interactive.ch/_fragment?_path=_format=html&_locale=de&_controller=App%5CController%5CCartController%3A%3AcartNavigationAction" "entire_uri" ] |
263 | 0.26 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
264 | 0.37 ms |
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:
[ "/_fragment" "path" "auto_create" "/_fragment?_path=_format=html&_locale=de&_controller=App%5CController%5CCategoriesController%3A%3AmainCategoriesAction" "path_query" "https://shop.bsz-stiftung.a4interactive.ch/_fragment?_path=_format=html&_locale=de&_controller=App%5CController%5CCategoriesController%3A%3AmainCategoriesAction" "entire_uri" ] |
265 | 0.18 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/kategorien/" "hauptkategorie" ] |
266 | 0.65 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:
[ "categories" 40 "categories" 40 "categories" 40 ] |
267 | 0.45 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:
[ "categories" 1355 "categories" 1355 "categories" 1355 ] |
268 | 1.04 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:
[ "categories" 623 "categories" 623 "categories" 623 ] |
269 | 0.70 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:
[ "categories" 708 "categories" 708 "categories" 708 ] |
270 | 0.43 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:
[ "categories" 624 "categories" 624 "categories" 624 ] |
271 | 0.47 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:
[ "categories" 6315 "categories" 6315 "categories" 6315 ] |
272 | 0.42 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:
[ "categories" 4872 "categories" 4872 "categories" 4872 ] |
273 | 0.44 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:
[ "categories" 633 "categories" 633 "categories" 633 ] |
274 | 0.43 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:
[ "categories" 832 "categories" 832 "categories" 832 ] |
275 | 0.47 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:
[ "categories" 626 "categories" 626 "categories" 626 ] |
276 | 0.42 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:
[ "categories" 628 "categories" 628 "categories" 628 ] |
277 | 0.44 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:
[ "categories" 658 "categories" 658 "categories" 658 ] |
278 | 0.48 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:
[ "categories" 631 "categories" 631 "categories" 631 ] |
279 | 0.92 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:
[ "categories" 602 "categories" 602 "categories" 602 ] |
280 | 0.45 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:
[ "categories" 818 "categories" 818 "categories" 818 ] |
281 | 0.43 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:
[ "categories" 634 "categories" 634 "categories" 634 ] |
282 | 0.48 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:
[ "categories" 604 "categories" 604 "categories" 604 ] |
283 | 0.62 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:
[ "categories" 792 "categories" 792 "categories" 792 ] |
284 | 0.74 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:
[ "categories" 596 "categories" 596 "categories" 596 ] |
285 | 0.60 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:
[ "categories" 603 "categories" 603 "categories" 603 ] |
286 | 0.46 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:
[ "categories" 843 "categories" 843 "categories" 843 ] |
287 | 0.48 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:
[ "categories" 598 "categories" 598 "categories" 598 ] |
288 | 0.44 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:
[ "categories" 607 "categories" 607 "categories" 607 ] |
289 | 0.43 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:
[ "categories" 829 "categories" 829 "categories" 829 ] |
290 | 0.49 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:
[ "categories" 611 "categories" 611 "categories" 611 ] |
291 | 0.97 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:
[ "categories" 641 "categories" 641 "categories" 641 ] |
292 | 0.49 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:
[ "categories" 805 "categories" 805 "categories" 805 ] |
293 | 0.42 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:
[ "categories" 3850 "categories" 3850 "categories" 3850 ] |
294 | 0.42 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:
[ "categories" 850 "categories" 850 "categories" 850 ] |
295 | 0.40 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:
[ "categories" 1010 "categories" 1010 "categories" 1010 ] |
296 | 0.42 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:
[ "categories" 6831 "categories" 6831 "categories" 6831 ] |
297 | 0.45 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:
[ "categories" 5352 "categories" 5352 "categories" 5352 ] |
298 | 0.45 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:
[ "categories" 5353 "categories" 5353 "categories" 5353 ] |
299 | 0.49 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:
[ "categories" 649 "categories" 649 "categories" 649 ] |
300 | 0.50 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:
[ "categories" 5354 "categories" 5354 "categories" 5354 ] |
301 | 0.53 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:
[ "categories" 597 "categories" 597 "categories" 597 ] |
302 | 0.45 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:
[ "categories" 599 "categories" 599 "categories" 599 ] |
303 | 0.41 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:
[ "categories" 6790 "categories" 6790 "categories" 6790 ] |
304 | 0.41 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:
[ "categories" 6462 "categories" 6462 "categories" 6462 ] |
305 | 0.40 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:
[ "categories" 931 "categories" 931 "categories" 931 ] |
306 | 0.44 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:
[ "categories" 663 "categories" 663 "categories" 663 ] |
307 | 0.43 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:
[ "categories" 608 "categories" 608 "categories" 608 ] |
308 | 0.41 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:
[ "categories" 7144 "categories" 7144 "categories" 7144 ] |
309 | 0.22 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
310 | 0.35 ms |
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:
[ "/_fragment" "path" "auto_create" "/_fragment?_path=_format=html&_locale=de&_controller=App%5CController%5CFavouriteController%3A%3AfavouritesCounterAction" "path_query" "https://shop.bsz-stiftung.a4interactive.ch/_fragment?_path=_format=html&_locale=de&_controller=App%5CController%5CFavouriteController%3A%3AfavouritesCounterAction" "entire_uri" ] |
311 | 0.17 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
312 | 0.29 ms |
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:
[ "/_fragment" "path" "auto_create" "/_fragment?_path=_format=html&_locale=de&_controller=App%5CController%5CFavouriteController%3A%3AfavouritesNavigationAction" "path_query" "https://shop.bsz-stiftung.a4interactive.ch/_fragment?_path=_format=html&_locale=de&_controller=App%5CController%5CFavouriteController%3A%3AfavouritesNavigationAction" "entire_uri" ] |
313 | 0.22 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
314 | 0.35 ms |
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:
[ "/_fragment" "path" "auto_create" "/_fragment?_path=_format=html&_locale=de&_controller=App%5CController%5CCartController%3A%3AcartCounterAction" "path_query" "https://shop.bsz-stiftung.a4interactive.ch/_fragment?_path=_format=html&_locale=de&_controller=App%5CController%5CCartController%3A%3AcartCounterAction" "entire_uri" ] |
315 | 0.30 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
316 | 0.31 ms |
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:
[ "/_fragment" "path" "auto_create" "/_fragment?_path=_format=html&_locale=de&_controller=App%5CController%5CCartController%3A%3AcartNavigationAction" "path_query" "https://shop.bsz-stiftung.a4interactive.ch/_fragment?_path=_format=html&_locale=de&_controller=App%5CController%5CCartController%3A%3AcartNavigationAction" "entire_uri" ] |
317 | 0.62 ms |
SELECT COUNT(*) FROM object_10 WHERE ( object_10.type IN ('object','variant','folder')) AND object_10.published = 1
Parameters:
[] |
318 | 0.41 ms |
SELECT object_10.id as id, object_10.type as `type` FROM object_10 WHERE ( object_10.type IN ('object','variant','folder')) AND object_10.published = 1 ORDER BY RAND()
Parameters:
[] |
319 | 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:
[ 1760800148 "object_104" ] |
320 | 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:
[ 1760800149 "object_104\x01tags\x01" "class_10\x01tags\x01" "asset_5218\x01tags\x01" ] |
321 | 0.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:
[ 1760800149 "object_6755" ] |
322 | 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:
[ 1760800149 "object_6755\x01tags\x01" "class_10\x01tags\x01" "asset_4254\x01tags\x01" ] |
323 | 0.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:
[ 1760800149 "object_105" ] |
324 | 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:
[ 1760800149 "object_105\x01tags\x01" "class_10\x01tags\x01" "asset_4789\x01tags\x01" ] |
325 | 0.16 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "shopHeroS" "pimcore_image_thumbnails" ] |
326 | 0.15 ms |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
5218
]
|
327 | 0.27 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
5218
]
|
328 | 0.15 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "shopHeroXS" "pimcore_image_thumbnails" ] |
329 | 0.12 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "shopHeroM" "pimcore_image_thumbnails" ] |
330 | 0.12 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "shopHeroXM" "pimcore_image_thumbnails" ] |
331 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "shopHeroL" "pimcore_image_thumbnails" ] |
332 | 0.12 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "shopHeroXL" "pimcore_image_thumbnails" ] |
333 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "shopHeroXXL" "pimcore_image_thumbnails" ] |
334 | 0.11 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"10"
]
|
335 | 0.18 ms |
SELECT * FROM object_relations_10 WHERE src_id = ?
Parameters:
[
104
]
|
336 | 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:
[ 1760800149 "object_891" ] |
337 | 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:
[ 1760800149 "object_891\x01tags\x01" "class_7\x01tags\x01" "asset_2283\x01tags\x01" "asset_2284\x01tags\x01" "asset_2285\x01tags\x01" "asset_2286\x01tags\x01" "asset_2287\x01tags\x01" ] |
338 | 0.17 ms |
SELECT * FROM object_relations_7 WHERE src_id = ?
Parameters:
[
891
]
|
339 | 0.70 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
340 | 0.16 ms |
SELECT * FROM object_relations_9 WHERE src_id = ?
Parameters:
[
15
]
|
341 | 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:
[ 1760800149 "object_16" ] |
342 | 0.11 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"EF_OSTC"
]
|
343 | 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:
[ 1760800149 "object_16\x01tags\x01" "class_EF_OSTC\x01tags\x01" ] |
344 | 0.12 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
345 | 0.50 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
346 | 0.21 ms |
SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1 ORDER BY `prio` ASC
Parameters:
[] |
347 | 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:
[ 1760800149 "system_resource_columns_ecommerceframework_pricing_rule" ] |
348 | 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:
[ 1760800149 "system\x01tags\x01" "resource\x01tags\x01" ] |
349 | 0.12 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='7'
Parameters:
[] |
350 | 0.12 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='10'
Parameters:
[] |
351 | 0.11 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='13'
Parameters:
[] |
352 | 0.11 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='14'
Parameters:
[] |
353 | 0.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:
[ 1760800149 "object_661" ] |
354 | 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:
[ 1760800149 "object_661\x01tags\x01" "class_8\x01tags\x01" ] |
355 | 0.12 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='15'
Parameters:
[] |
356 | 0.11 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='16'
Parameters:
[] |
357 | 0.11 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='17'
Parameters:
[] |
358 | 0.10 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='18'
Parameters:
[] |
359 | 0.10 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='19'
Parameters:
[] |
360 | 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:
[ 1760800149 "object_4248" ] |
361 | 0.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:
[ 1760800149 "object_4248\x01tags\x01" ] |
362 | 0.13 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
363 | 0.51 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
364 | 0.61 ms |
SELECT object_localized_9_de.id as id, object_localized_9_de.type as `type` FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
365 | 0.15 ms |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
4254
]
|
366 | 0.17 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
4254
]
|
367 | 0.17 ms |
SELECT * FROM object_relations_10 WHERE src_id = ?
Parameters:
[
6755
]
|
368 | 0.15 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
369 | 0.59 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
370 | 0.53 ms |
SELECT object_localized_9_de.id as id, object_localized_9_de.type as `type` FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
371 | 0.14 ms |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
4789
]
|
372 | 0.15 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
4789
]
|
373 | 0.15 ms |
SELECT * FROM object_relations_10 WHERE src_id = ?
Parameters:
[
105
]
|
374 | 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:
[ 1760800149 "object_677" ] |
375 | 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:
[ 1760800149 "object_677\x01tags\x01" "class_7\x01tags\x01" "asset_3884\x01tags\x01" "asset_3885\x01tags\x01" ] |
376 | 0.17 ms |
SELECT * FROM object_relations_7 WHERE src_id = ?
Parameters:
[
677
]
|
377 | 0.55 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
378 | 0.14 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
379 | 0.52 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
380 | 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:
[ 1760800149 "object_7276" ] |
381 | 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:
[ 1760800149 "object_7276\x01tags\x01" ] |
382 | 0.13 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
383 | 0.54 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
384 | 0.52 ms |
SELECT object_localized_9_de.id as id, object_localized_9_de.type as `type` FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
385 | 0.15 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
386 | 0.35 ms |
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:
[ "/_fragment" "path" "auto_create" "/_fragment?_path=_format=html&_locale=de&_controller=App%5CController%5CCategoriesController%3A%3AsubCategoriesAction" "path_query" "https://shop.bsz-stiftung.a4interactive.ch/_fragment?_path=_format=html&_locale=de&_controller=App%5CController%5CCategoriesController%3A%3AsubCategoriesAction" "entire_uri" ] |
387 | 0.15 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/kategorien/" "hauptkategorie" ] |
388 | 1.30 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:
[ "categories" 708 "categories" 708 "categories" 708 ] |
389 | 0.60 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:
[ "categories" 624 "categories" 624 "categories" 624 ] |
390 | 0.61 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:
[ "categories" 6315 "categories" 6315 "categories" 6315 ] |
391 | 0.53 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:
[ "categories" 4872 "categories" 4872 "categories" 4872 ] |
392 | 0.55 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:
[ "categories" 633 "categories" 633 "categories" 633 ] |
393 | 0.55 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:
[ "categories" 832 "categories" 832 "categories" 832 ] |
394 | 0.60 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:
[ "categories" 626 "categories" 626 "categories" 626 ] |
395 | 0.53 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:
[ "categories" 628 "categories" 628 "categories" 628 ] |
396 | 0.56 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:
[ "categories" 658 "categories" 658 "categories" 658 ] |
397 | 0.62 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:
[ "categories" 631 "categories" 631 "categories" 631 ] |
398 | 0.90 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:
[ "categories" 708 "categories" 708 "categories" 708 ] |
399 | 0.57 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:
[ "categories" 624 "categories" 624 "categories" 624 ] |
400 | 0.59 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:
[ "categories" 6315 "categories" 6315 "categories" 6315 ] |
401 | 0.54 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:
[ "categories" 4872 "categories" 4872 "categories" 4872 ] |
402 | 0.55 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:
[ "categories" 633 "categories" 633 "categories" 633 ] |
403 | 0.55 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:
[ "categories" 832 "categories" 832 "categories" 832 ] |
404 | 0.59 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:
[ "categories" 626 "categories" 626 "categories" 626 ] |
405 | 0.54 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:
[ "categories" 628 "categories" 628 "categories" 628 ] |
406 | 0.55 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:
[ "categories" 658 "categories" 658 "categories" 658 ] |
407 | 0.61 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:
[ "categories" 631 "categories" 631 "categories" 631 ] |
408 | 0.76 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
409 | 0.15 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
410 | 0.57 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
411 | 0.18 ms |
SELECT * FROM object_relations_7 WHERE src_id = ?
Parameters:
[
839
]
|
412 | 0.16 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "shopListingS" "pimcore_image_thumbnails" ] |
413 | 0.45 ms |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
4062
]
|
414 | 0.15 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
4062
]
|
415 | 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:
[ 1760800149 "object_622" ] |
416 | 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:
[ 1760800149 "object_622\x01tags\x01" ] |
417 | 0.15 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
418 | 0.66 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
419 | 0.57 ms |
SELECT object_localized_9_de.id as id, object_localized_9_de.type as `type` FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
420 | 0.58 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
421 | 0.15 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
422 | 0.54 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
423 | 0.19 ms |
SELECT * FROM object_relations_7 WHERE src_id = ?
Parameters:
[
840
]
|
424 | 0.45 ms |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
3727
]
|
425 | 0.34 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
3727
]
|
426 | 0.14 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
427 | 0.58 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
428 | 0.54 ms |
SELECT object_localized_9_de.id as id, object_localized_9_de.type as `type` FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
429 | 0.54 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
430 | 0.14 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
431 | 0.53 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
432 | 0.18 ms |
SELECT * FROM object_relations_7 WHERE src_id = ?
Parameters:
[
875
]
|
433 | 0.42 ms |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
2243
]
|
434 | 0.33 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
2243
]
|
435 | 0.15 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
436 | 0.58 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
437 | 0.54 ms |
SELECT object_localized_9_de.id as id, object_localized_9_de.type as `type` FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
438 | 0.55 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
439 | 0.14 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
440 | 0.54 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
441 | 0.17 ms |
SELECT * FROM object_relations_7 WHERE src_id = ?
Parameters:
[
877
]
|
442 | 0.14 ms |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
2247
]
|
443 | 0.15 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
2247
]
|
444 | 0.14 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
445 | 0.57 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
446 | 0.54 ms |
SELECT object_localized_9_de.id as id, object_localized_9_de.type as `type` FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
447 | 0.53 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
448 | 0.14 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
449 | 0.52 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
450 | 0.18 ms |
SELECT * FROM object_relations_7 WHERE src_id = ?
Parameters:
[
878
]
|
451 | 0.14 ms |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
2249
]
|
452 | 0.16 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
2249
]
|
453 | 0.14 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
454 | 0.58 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
455 | 0.60 ms |
SELECT object_localized_9_de.id as id, object_localized_9_de.type as `type` FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
456 | 0.59 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
457 | 0.14 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
458 | 0.60 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
459 | 0.19 ms |
SELECT * FROM object_relations_7 WHERE src_id = ?
Parameters:
[
884
]
|
460 | 0.14 ms |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
2263
]
|
461 | 0.15 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
2263
]
|
462 | 0.15 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
463 | 0.63 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
464 | 0.47 ms |
SELECT object_localized_9_de.id as id, object_localized_9_de.type as `type` FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
465 | 0.47 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
466 | 0.13 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
467 | 0.44 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
468 | 0.50 ms |
SELECT * FROM object_relations_7 WHERE src_id = ?
Parameters:
[
958
]
|
469 | 0.29 ms |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
2531
]
|
470 | 0.35 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
2531
]
|
471 | 0.19 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
472 | 0.67 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
473 | 0.48 ms |
SELECT object_localized_9_de.id as id, object_localized_9_de.type as `type` FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
474 | 0.46 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
475 | 0.13 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
476 | 0.45 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
477 | 0.17 ms |
SELECT * FROM object_relations_7 WHERE src_id = ?
Parameters:
[
963
]
|
478 | 0.12 ms |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
2541
]
|
479 | 0.13 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
2541
]
|
480 | 0.12 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
481 | 0.47 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
482 | 0.46 ms |
SELECT object_localized_9_de.id as id, object_localized_9_de.type as `type` FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
483 | 0.47 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
484 | 0.12 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
485 | 0.44 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
486 | 0.16 ms |
SELECT * FROM object_relations_7 WHERE src_id = ?
Parameters:
[
965
]
|
487 | 0.12 ms |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
2545
]
|
488 | 0.12 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
2545
]
|
489 | 0.12 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
490 | 0.47 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
491 | 0.46 ms |
SELECT object_localized_9_de.id as id, object_localized_9_de.type as `type` FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
492 | 0.45 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
493 | 0.12 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
494 | 0.45 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
495 | 0.15 ms |
SELECT * FROM object_relations_7 WHERE src_id = ?
Parameters:
[
2195
]
|
496 | 0.11 ms |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
3717
]
|
497 | 0.13 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
3717
]
|
498 | 0.15 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
499 | 0.47 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
500 | 0.45 ms |
SELECT object_localized_9_de.id as id, object_localized_9_de.type as `type` FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
501 | 0.47 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
502 | 0.12 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
503 | 0.42 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
504 | 0.15 ms |
SELECT * FROM object_relations_7 WHERE src_id = ?
Parameters:
[
4876
]
|
505 | 0.35 ms |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
4579
]
|
506 | 0.13 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
4579
]
|
507 | 0.12 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
508 | 0.45 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
509 | 0.42 ms |
SELECT object_localized_9_de.id as id, object_localized_9_de.type as `type` FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
510 | 0.45 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
511 | 0.12 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
512 | 0.43 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[ "" ] |
513 | 0.15 ms |
SELECT * FROM object_relations_7 WHERE src_id = ?
Parameters:
[
4878
]
|
514 | 0.45 ms |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
4570
]
|
515 | 0.13 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
4570
]
|
516 | 0.12 ms |
SELECT id FROM objects WHERE `path` = BINARY ? AND `key` = BINARY ?
Parameters:
[ "/shop/konfiguration/laender/" "schweiz" ] |
517 | 0.48 ms |
SELECT COUNT(*) FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
518 | 0.42 ms |
SELECT object_localized_9_de.id as id, object_localized_9_de.type as `type` FROM object_localized_9_de WHERE (shortName LIKE ? AND object_localized_9_de.type IN ('object','variant','folder')) AND object_localized_9_de.published = 1
Parameters:
[
"ch"
]
|
519 | 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:
[ 1760800149 "asset_7" ] |
520 | 0.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:
[ 1760800149 "asset_7\x01tags\x01" ] |
521 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "shopLeftrightS" "pimcore_image_thumbnails" ] |
522 | 0.11 ms |
SELECT customSettings FROM assets WHERE id = ?
Parameters:
[
7
]
|
523 | 0.13 ms |
SELECT * FROM assets_image_thumbnail_cache WHERE cid = ?
Parameters:
[
7
]
|
524 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "shopLeftrightXS" "pimcore_image_thumbnails" ] |
525 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "shopLeftrightM" "pimcore_image_thumbnails" ] |
526 | 0.11 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "shopLeftrightXM" "pimcore_image_thumbnails" ] |
527 | 0.10 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "shopLeftrightL" "pimcore_image_thumbnails" ] |
528 | 0.10 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "shopLeftrightXL" "pimcore_image_thumbnails" ] |
529 | 0.10 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "shopLeftrightXXL" "pimcore_image_thumbnails" ] |
530 | 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:
[ 1760800149 "document_1" ] |
531 | 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:
[ 1760800149 "document_1\x01tags\x01" "asset_2988\x01tags\x01" "asset_5037\x01tags\x01" "asset_2811\x01tags\x01" ] |
532 | 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:
[ 1760800149 "document_12" ] |
533 | 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:
[ 1760800149 "document_12\x01tags\x01" ] |
534 | 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:
[ 1760800149 "document_properties_12" ] |
535 | 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:
[ 1760800149 "document_properties\x01tags\x01" "document_12\x01tags\x01" ] |
536 | 0.13 ms |
SELECT * FROM settings_store WHERE id = ? AND scope = ?
Parameters:
[ "BUNDLE_INSTALLED__Pimcore\Bundle\SeoBundle\PimcoreSeoBundle" "pimcore" ] |
537 | 0.31 ms |
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:
[ "/_fragment" "path" "auto_create" "/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CShopContentController%3A%3AfooterAction" "path_query" "https://shop.bsz-stiftung.a4interactive.ch/_fragment?_path=_locale=de&_format=html&_controller=App%5CController%5CShopContentController%3A%3AfooterAction" "entire_uri" ] |
538 | 0.22 ms |
SELECT * FROM documents_editables WHERE documentId = ?
Parameters:
[
12
]
|
539 | 0.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:
[ 1760800149 "document_13" ] |
540 | 0.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:
[ 1760800149 "document_13\x01tags\x01" ] |
541 | 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:
[ 1760800149 "nav_52ebdb4d2913709c6f6111300cd61325" ] |
542 | 0.22 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:
[ 1760800149 "output\x01tags\x01" "navigation\x01tags\x01" "document_14\x01tags\x01" "document_15\x01tags\x01" "document_16\x01tags\x01" ] |
543 | 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:
[ 1760800149 "document_15" ] |
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.