Query Metrics
372
Database Queries
79
Different statements
230.35 ms
Query time
0
Invalid entities
Queries
#▲ | Time | Info |
---|---|---|
1 | 0.33 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "site_domain_a909396f20e21773e9ea4952001fa17b" ] ] |
2 | 0.32 ms |
SELECT * FROM redirects WHERE ( (source = :sourcePath AND (`type` = :typePath OR `type` = :typeAuto)) OR (source = :sourcePathQuery AND `type` = :typePathQuery) OR (source = :sourceEntireUri AND `type` = :typeEntireUri) ) AND active = 1 AND regex IS NULL AND (expiry > UNIX_TIMESTAMP() OR expiry IS NULL) AND sourceSite IS NULL AND priority = 99 ORDER BY `priority` DESC
Parameters:
[ "sourcePath" => "/Bbque/de/shop" "sourcePathQuery" => "/Bbque/de/shop" "sourceEntireUri" => "https://pim.develey.blackbit.io/Bbque/de/shop" "typePath" => "path" "typePathQuery" => "path_query" "typeEntireUri" => "entire_uri" "typeAuto" => "auto_create" ] |
3 | 0.19 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "system_route_redirect" ] ] |
4 | 0.17 ms |
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters:
[ "key" => "shop" "path" => "/Bbque/de/" ] |
5 | 0.11 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "document_470" ] ] |
6 | 0.81 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "document_properties_470" ] ] |
7 | 0.32 ms |
SELECT * FROM object_url_slugs WHERE slug = '/Bbque/de/shop' AND (siteId = 0 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
8 | 0.04 ms |
SELECT * FROM object_url_slugs WHERE slug = '/Bbque/de/shop' AND (siteId = 0 OR siteId = 0) ORDER BY siteId DESC LIMIT 1
Parameters:
[] |
9 | 0.03 ms |
SELECT id FROM targeting_target_groups UNION SELECT id FROM targeting_rules LIMIT 1
Parameters:
[] |
10 | 0.22 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_24907" ] ] |
11 | 0.04 ms |
SELECT id FROM sites ORDER BY (SELECT LENGTH(path) FROM documents WHERE documents.id = sites.rootId) DESC
Parameters:
[] |
12 | 0.15 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "site_id_1" ] ] |
13 | 0.09 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "site_id_12" ] ] |
14 | 0.08 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "site_id_11" ] ] |
15 | 0.10 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "site_id_10" ] ] |
16 | 0.19 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "site_id_9" ] ] |
17 | 0.08 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "site_id_8" ] ] |
18 | 0.14 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "site_id_7" ] ] |
19 | 0.10 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "site_id_6" ] ] |
20 | 0.08 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "site_id_5" ] ] |
21 | 0.55 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "site_id_4" ] ] |
22 | 0.11 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "site_id_3" ] ] |
23 | 0.11 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "site_id_2" ] ] |
24 | 0.19 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "site_id_13" ] ] |
25 | 0.11 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "document_properties_403" ] ] |
26 | 0.12 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "document_404" ] ] |
27 | 0.12 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "nav_120a8d40eb8ec8721ec14650bc0e001c" ] ] |
28 | 0.28 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "translation_data_messages_de" ] ] |
29 | 0.62 ms |
SELECT * FROM documents_elements WHERE documentId = ?
Parameters:
[
470
]
|
30 | 0.44 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_33739" ] ] |
31 | 0.04 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"11"
]
|
32 | 0.46 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_33736" ] ] |
33 | 0.39 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_33744" ] ] |
34 | 0.61 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_33943" ] ] |
35 | 0.46 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_33754" ] ] |
36 | 0.05 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"9"
]
|
37 | 0.64 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_33752" ] ] |
38 | 0.73 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_33733" ] ] |
39 | 0.13 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_33737" ] ] |
40 | 0.15 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_33735" ] ] |
41 | 0.13 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_33734" ] ] |
42 | 0.06 ms |
SELECT object_EF_OSTC.o_id as o_id, `object_EF_OSTC`.`o_type` FROM `object_EF_OSTC` WHERE (((o_key LIKE ?) AND object_EF_OSTC.o_type IN ('object','folder')) AND object_EF_OSTC.o_published = 1)
Parameters:
[ "" ] |
43 | 0.05 ms |
SELECT object_EF_OSTC.o_id as o_id, `object_EF_OSTC`.`o_type` FROM `object_EF_OSTC` WHERE (((o_key LIKE ?) AND object_EF_OSTC.o_type IN ('object','folder')) AND object_EF_OSTC.o_published = 1) LIMIT 1
Parameters:
[ "" ] |
44 | 0.03 ms |
SELECT object_EF_OSTC.o_id as o_id, `object_EF_OSTC`.`o_type` FROM `object_EF_OSTC` WHERE (( object_EF_OSTC.o_type IN ('object','folder')) AND object_EF_OSTC.o_published = 1)
Parameters:
[] |
45 | 0.14 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_99" ] ] |
46 | 0.13 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_100" ] ] |
47 | 0.09 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_2094" ] ] |
48 | 0.08 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_2095" ] ] |
49 | 0.08 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_2096" ] ] |
50 | 0.08 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_149596" ] ] |
51 | 0.08 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_149662" ] ] |
52 | 0.08 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_149837" ] ] |
53 | 0.08 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_149838" ] ] |
54 | 0.08 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_149843" ] ] |
55 | 0.08 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_149844" ] ] |
56 | 0.08 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_149847" ] ] |
57 | 0.08 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_149850" ] ] |
58 | 0.07 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_149851" ] ] |
59 | 0.07 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_149854" ] ] |
60 | 0.08 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_149855" ] ] |
61 | 0.14 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "document_488" ] ] |
62 | 0.47 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "asset_3340" ] ] |
63 | 0.39 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "document_489" ] ] |
64 | 0.34 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "asset_3131" ] ] |
65 | 0.15 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "document_490" ] ] |
66 | 0.13 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "asset_3132" ] ] |
67 | 0.15 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "document_775" ] ] |
68 | 0.71 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "asset_3175" ] ] |
69 | 0.58 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "product_price_history_33739_all_30" ] ] |
70 | 0.04 ms |
SELECT o_id FROM objects WHERE o_id IN (149533,149594,149848,149654,149839,149852,149845)
Parameters:
[] |
71 | 1.27 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33739 "149533" "prices" "object" "" "0" 1 ] |
72 | 0.69 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33739 "149594" "prices" "object" "" "0" 2 ] |
73 | 0.51 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33739 "149848" "prices" "object" "" "0" 3 ] |
74 | 0.26 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33739 "149654" "prices" "object" "" "0" 4 ] |
75 | 0.40 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33739 "149839" "prices" "object" "" "0" 5 ] |
76 | 0.39 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33739 "149852" "prices" "object" "" "0" 6 ] |
77 | 0.23 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33739 "149845" "prices" "object" "" "0" 7 ] |
78 | 0.03 ms |
SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (149533,149594,149848,149654,149839,149852,149845);
Parameters:
[] |
79 | 0.29 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_149533" ] ] |
80 | 1.07 ms |
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
Parameters:
[ ":id" => 33739 ":countryCode" => "AT" ":startDate" => Carbon\Carbon {#4046 : "2025-07-05 00:00:00" } ] |
81 | 0.60 ms |
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
Parameters:
[ ":id" => 33739 ":countryCode" => "AT" ] |
82 | 0.11 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_149594" ] ] |
83 | 0.41 ms |
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
Parameters:
[ ":id" => 33739 ":countryCode" => "ES" ":startDate" => Carbon\Carbon {#4046 : "2025-07-05 00:00:00" } ] |
84 | 0.24 ms |
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
Parameters:
[ ":id" => 33739 ":countryCode" => "ES" ] |
85 | 0.12 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_149848" ] ] |
86 | 0.56 ms |
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
Parameters:
[ ":id" => 33739 ":countryCode" => "FR" ":startDate" => Carbon\Carbon {#4046 : "2025-07-05 00:00:00" } ] |
87 | 0.44 ms |
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
Parameters:
[ ":id" => 33739 ":countryCode" => "FR" ] |
88 | 0.10 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_149654" ] ] |
89 | 0.50 ms |
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
Parameters:
[ ":id" => 33739 ":countryCode" => "IT" ":startDate" => Carbon\Carbon {#4046 : "2025-07-05 00:00:00" } ] |
90 | 0.24 ms |
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
Parameters:
[ ":id" => 33739 ":countryCode" => "IT" ] |
91 | 0.12 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_149839" ] ] |
92 | 0.23 ms |
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
Parameters:
[ ":id" => 33739 ":countryCode" => "LU" ":startDate" => Carbon\Carbon {#4046 : "2025-07-05 00:00:00" } ] |
93 | 0.23 ms |
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
Parameters:
[ ":id" => 33739 ":countryCode" => "LU" ] |
94 | 0.10 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_149852" ] ] |
95 | 0.57 ms |
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
Parameters:
[ ":id" => 33739 ":countryCode" => "SE" ":startDate" => Carbon\Carbon {#4046 : "2025-07-05 00:00:00" } ] |
96 | 0.67 ms |
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
Parameters:
[ ":id" => 33739 ":countryCode" => "SE" ] |
97 | 0.11 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_149845" ] ] |
98 | 0.28 ms |
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
Parameters:
[ ":id" => 33739 ":countryCode" => "MT" ":startDate" => Carbon\Carbon {#4046 : "2025-07-05 00:00:00" } ] |
99 | 0.25 ms |
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
Parameters:
[ ":id" => 33739 ":countryCode" => "MT" ] |
100 | 0.26 ms |
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = 'DE' AND changedDateTime >= :startDate
Parameters:
[ ":id" => 33739 ":startDate" => Carbon\Carbon {#4046 : "2025-07-05 00:00:00" } ] |
101 | 0.26 ms |
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
Parameters:
[ ":id" => 33739 ":countryCode" => "DE" ] |
102 | 0.03 ms |
"START TRANSACTION"
Parameters:
[] |
103 | 146.41 ms |
INSERT INTO cache (id, data, expire, mtime) VALUES (:id, :data, :expire, :mtime) ON DUPLICATE KEY UPDATE data = VALUES(data), expire = VALUES(expire), mtime = VALUES(mtime)
Parameters:
[ "id" => "product_price_history_33739_all_30" "data" => "s:142:"a:8:{s:2:"DE";d:16.67;s:2:"AT";d:17.14;s:2:"ES";d:17.14;s:2:"FR";d:16.44;s:2:"IT";d:17.14;s:2:"LU";d:16.05;s:2:"SE";d:17.45;s:2:"MT";d:18.38;}";" "expire" => 1754346790 "mtime" => 1754260390 ] |
104 | 3.88 ms |
DELETE FROM cache_tags WHERE id = ? AND tag NOT IN (?)
Parameters:
[ "product_price_history_33739_all_30" [ "22_getMinimumPrice" ] ] |
105 | 0.11 ms |
INSERT INTO cache_tags (id, tag) VALUES (?, ?) ON DUPLICATE KEY UPDATE tag = VALUES(tag)
Parameters:
[ "product_price_history_33739_all_30" "22_getMinimumPrice" ] |
106 | 2.19 ms |
"COMMIT"
Parameters:
[] |
107 | 0.17 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "product_price_history_33736_all_30" ] ] |
108 | 0.11 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "product_price_history_33744_all_30" ] ] |
109 | 0.03 ms |
SELECT o_id FROM objects WHERE o_id IN (149533,149594,149848,149654,149839,149852,149845)
Parameters:
[] |
110 | 0.29 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33744 "149533" "prices" "object" "" "0" 1 ] |
111 | 0.23 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33744 "149594" "prices" "object" "" "0" 2 ] |
112 | 0.19 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33744 "149848" "prices" "object" "" "0" 3 ] |
113 | 0.18 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33744 "149654" "prices" "object" "" "0" 4 ] |
114 | 0.18 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33744 "149839" "prices" "object" "" "0" 5 ] |
115 | 0.18 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33744 "149852" "prices" "object" "" "0" 6 ] |
116 | 0.18 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33744 "149845" "prices" "object" "" "0" 7 ] |
117 | 0.03 ms |
SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (149533,149594,149848,149654,149839,149852,149845);
Parameters:
[] |
118 | 0.32 ms |
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
Parameters:
[ ":id" => 33744 ":countryCode" => "AT" ":startDate" => Carbon\Carbon {#4342 : "2025-07-05 00:00:00" } ] |
119 | 0.27 ms |
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
Parameters:
[ ":id" => 33744 ":countryCode" => "AT" ] |
120 | 0.24 ms |
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
Parameters:
[ ":id" => 33744 ":countryCode" => "ES" ":startDate" => Carbon\Carbon {#4342 : "2025-07-05 00:00:00" } ] |
121 | 0.23 ms |
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
Parameters:
[ ":id" => 33744 ":countryCode" => "ES" ] |
122 | 0.22 ms |
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
Parameters:
[ ":id" => 33744 ":countryCode" => "FR" ":startDate" => Carbon\Carbon {#4342 : "2025-07-05 00:00:00" } ] |
123 | 0.22 ms |
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
Parameters:
[ ":id" => 33744 ":countryCode" => "FR" ] |
124 | 0.24 ms |
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
Parameters:
[ ":id" => 33744 ":countryCode" => "IT" ":startDate" => Carbon\Carbon {#4342 : "2025-07-05 00:00:00" } ] |
125 | 0.22 ms |
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
Parameters:
[ ":id" => 33744 ":countryCode" => "IT" ] |
126 | 0.21 ms |
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
Parameters:
[ ":id" => 33744 ":countryCode" => "LU" ":startDate" => Carbon\Carbon {#4342 : "2025-07-05 00:00:00" } ] |
127 | 0.22 ms |
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
Parameters:
[ ":id" => 33744 ":countryCode" => "LU" ] |
128 | 0.22 ms |
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
Parameters:
[ ":id" => 33744 ":countryCode" => "SE" ":startDate" => Carbon\Carbon {#4342 : "2025-07-05 00:00:00" } ] |
129 | 0.23 ms |
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
Parameters:
[ ":id" => 33744 ":countryCode" => "SE" ] |
130 | 0.21 ms |
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
Parameters:
[ ":id" => 33744 ":countryCode" => "MT" ":startDate" => Carbon\Carbon {#4342 : "2025-07-05 00:00:00" } ] |
131 | 0.22 ms |
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
Parameters:
[ ":id" => 33744 ":countryCode" => "MT" ] |
132 | 0.21 ms |
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = 'DE' AND changedDateTime >= :startDate
Parameters:
[ ":id" => 33744 ":startDate" => Carbon\Carbon {#4342 : "2025-07-05 00:00:00" } ] |
133 | 0.22 ms |
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
Parameters:
[ ":id" => 33744 ":countryCode" => "DE" ] |
134 | 0.03 ms |
"START TRANSACTION"
Parameters:
[] |
135 | 0.27 ms |
INSERT INTO cache (id, data, expire, mtime) VALUES (:id, :data, :expire, :mtime) ON DUPLICATE KEY UPDATE data = VALUES(data), expire = VALUES(expire), mtime = VALUES(mtime)
Parameters:
[ "id" => "product_price_history_33744_all_30" "data" => "s:141:"a:8:{s:2:"DE";d:21.8;s:2:"AT";d:22.41;s:2:"ES";d:22.41;s:2:"FR";d:21.49;s:2:"IT";d:22.41;s:2:"LU";d:20.99;s:2:"SE";d:22.82;s:2:"MT";d:24.04;}";" "expire" => 1754346790 "mtime" => 1754260390 ] |
136 | 0.11 ms |
DELETE FROM cache_tags WHERE id = ? AND tag NOT IN (?)
Parameters:
[ "product_price_history_33744_all_30" [ "22_getMinimumPrice" ] ] |
137 | 0.05 ms |
INSERT INTO cache_tags (id, tag) VALUES (?, ?) ON DUPLICATE KEY UPDATE tag = VALUES(tag)
Parameters:
[ "product_price_history_33744_all_30" "22_getMinimumPrice" ] |
138 | 0.96 ms |
"COMMIT"
Parameters:
[] |
139 | 0.37 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "product_price_history_33943_all_30" ] ] |
140 | 0.10 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "product_price_history_33754_all_30" ] ] |
141 | 0.09 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "product_price_history_33752_all_30" ] ] |
142 | 0.03 ms |
SELECT o_id FROM objects WHERE o_id IN (149533,149594,149848,149654,149839,149852,149845)
Parameters:
[] |
143 | 0.24 ms |
SELECT * FROM object_metadata_9 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33752 "149533" "prices" "object" "" "0" 1 ] |
144 | 0.19 ms |
SELECT * FROM object_metadata_9 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33752 "149594" "prices" "object" "" "0" 2 ] |
145 | 0.18 ms |
SELECT * FROM object_metadata_9 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33752 "149848" "prices" "object" "" "0" 3 ] |
146 | 0.16 ms |
SELECT * FROM object_metadata_9 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33752 "149654" "prices" "object" "" "0" 4 ] |
147 | 0.16 ms |
SELECT * FROM object_metadata_9 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33752 "149839" "prices" "object" "" "0" 5 ] |
148 | 0.16 ms |
SELECT * FROM object_metadata_9 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33752 "149852" "prices" "object" "" "0" 6 ] |
149 | 0.15 ms |
SELECT * FROM object_metadata_9 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33752 "149845" "prices" "object" "" "0" 7 ] |
150 | 0.03 ms |
SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (149533,149594,149848,149654,149839,149852,149845);
Parameters:
[] |
151 | 0.62 ms |
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
Parameters:
[ ":id" => 33752 ":countryCode" => "AT" ":startDate" => Carbon\Carbon {#4379 : "2025-07-05 00:00:00" } ] |
152 | 0.54 ms |
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
Parameters:
[ ":id" => 33752 ":countryCode" => "AT" ] |
153 | 0.23 ms |
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
Parameters:
[ ":id" => 33752 ":countryCode" => "ES" ":startDate" => Carbon\Carbon {#4379 : "2025-07-05 00:00:00" } ] |
154 | 0.25 ms |
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
Parameters:
[ ":id" => 33752 ":countryCode" => "ES" ] |
155 | 0.23 ms |
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
Parameters:
[ ":id" => 33752 ":countryCode" => "FR" ":startDate" => Carbon\Carbon {#4379 : "2025-07-05 00:00:00" } ] |
156 | 0.27 ms |
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
Parameters:
[ ":id" => 33752 ":countryCode" => "FR" ] |
157 | 0.22 ms |
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
Parameters:
[ ":id" => 33752 ":countryCode" => "IT" ":startDate" => Carbon\Carbon {#4379 : "2025-07-05 00:00:00" } ] |
158 | 0.24 ms |
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
Parameters:
[ ":id" => 33752 ":countryCode" => "IT" ] |
159 | 0.22 ms |
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
Parameters:
[ ":id" => 33752 ":countryCode" => "LU" ":startDate" => Carbon\Carbon {#4379 : "2025-07-05 00:00:00" } ] |
160 | 0.23 ms |
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
Parameters:
[ ":id" => 33752 ":countryCode" => "LU" ] |
161 | 0.22 ms |
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
Parameters:
[ ":id" => 33752 ":countryCode" => "SE" ":startDate" => Carbon\Carbon {#4379 : "2025-07-05 00:00:00" } ] |
162 | 0.23 ms |
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
Parameters:
[ ":id" => 33752 ":countryCode" => "SE" ] |
163 | 0.22 ms |
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = :countryCode AND changedDateTime >= :startDate
Parameters:
[ ":id" => 33752 ":countryCode" => "MT" ":startDate" => Carbon\Carbon {#4379 : "2025-07-05 00:00:00" } ] |
164 | 0.23 ms |
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
Parameters:
[ ":id" => 33752 ":countryCode" => "MT" ] |
165 | 0.23 ms |
SELECT MIN(price) FROM object_22 WHERE product__id = :id AND countryCode = 'DE' AND changedDateTime >= :startDate
Parameters:
[ ":id" => 33752 ":startDate" => Carbon\Carbon {#4379 : "2025-07-05 00:00:00" } ] |
166 | 0.24 ms |
SELECT price FROM object_22 WHERE product__id = :id AND countryCode = :countryCode ORDER BY changedDateTime DESC LIMIT 2
Parameters:
[ ":id" => 33752 ":countryCode" => "DE" ] |
167 | 0.03 ms |
"START TRANSACTION"
Parameters:
[] |
168 | 0.29 ms |
INSERT INTO cache (id, data, expire, mtime) VALUES (:id, :data, :expire, :mtime) ON DUPLICATE KEY UPDATE data = VALUES(data), expire = VALUES(expire), mtime = VALUES(mtime)
Parameters:
[ "id" => "product_price_history_33752_all_30" "data" => "s:140:"a:8:{s:2:"DE";d:24.99;s:2:"AT";d:25.2;s:2:"ES";d:25.41;s:2:"FR";d:25.2;s:2:"IT";d:25.62;s:2:"LU";d:24.57;s:2:"SE";d:26.25;s:2:"MT";d:24.78;}";" "expire" => 1754346790 "mtime" => 1754260390 ] |
169 | 0.10 ms |
DELETE FROM cache_tags WHERE id = ? AND tag NOT IN (?)
Parameters:
[ "product_price_history_33752_all_30" [ "22_getMinimumPrice" ] ] |
170 | 0.05 ms |
INSERT INTO cache_tags (id, tag) VALUES (?, ?) ON DUPLICATE KEY UPDATE tag = VALUES(tag)
Parameters:
[ "product_price_history_33752_all_30" "22_getMinimumPrice" ] |
171 | 1.91 ms |
"COMMIT"
Parameters:
[] |
172 | 0.12 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "product_price_history_33733_all_30" ] ] |
173 | 0.10 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "product_price_history_33737_all_30" ] ] |
174 | 0.10 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "product_price_history_33735_all_30" ] ] |
175 | 0.10 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "product_price_history_33734_all_30" ] ] |
176 | 0.68 ms |
SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ((o_parentId = ? AND objects.o_type IN ('variant')) AND objects.o_published = 1) ORDER BY `o_key` ASC
Parameters:
[
33739
]
|
177 | 0.32 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_155687" ] ] |
178 | 0.11 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_33738" ] ] |
179 | 0.23 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_24914" ] ] |
180 | 0.17 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_24909" ] ] |
181 | 0.09 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_129" ] ] |
182 | 0.08 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_1" ] ] |
183 | 0.05 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"EF_OSTC"
]
|
184 | 0.10 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_149532" ] ] |
185 | 0.03 ms |
SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (149533,149594,149848,149654,149839,149852,149845);
Parameters:
[] |
186 | 0.10 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_33815" ] ] |
187 | 0.04 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"7"
]
|
188 | 0.04 ms |
SELECT id FROM ecommerceframework_pricing_rule WHERE active = 1 ORDER BY `prio` ASC
Parameters:
[] |
189 | 0.09 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "system_resource_columns_ecommerceframework_pricing_rule" ] ] |
190 | 0.03 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='68'
Parameters:
[] |
191 | 0.51 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_37575" ] ] |
192 | 0.55 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_37570" ] ] |
193 | 0.58 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_41104" ] ] |
194 | 0.12 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_41103" ] ] |
195 | 0.65 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_37649" ] ] |
196 | 0.47 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_37657" ] ] |
197 | 0.41 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_37661" ] ] |
198 | 0.11 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_37668" ] ] |
199 | 0.06 ms |
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[ "key" => "Develey Süß-Saure Sauce 250 ml Squeeze" "path" => "/Marken/Brand/Produkte/Saucen/" ] |
200 | 0.77 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_37682" ] ] |
201 | 0.04 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='48'
Parameters:
[] |
202 | 0.03 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='47'
Parameters:
[] |
203 | 0.03 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='46'
Parameters:
[] |
204 | 0.03 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='45'
Parameters:
[] |
205 | 0.03 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='44'
Parameters:
[] |
206 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='43'
Parameters:
[] |
207 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='42'
Parameters:
[] |
208 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='41'
Parameters:
[] |
209 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='40'
Parameters:
[] |
210 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='38'
Parameters:
[] |
211 | 0.03 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='49'
Parameters:
[] |
212 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='50'
Parameters:
[] |
213 | 0.03 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='53'
Parameters:
[] |
214 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='67'
Parameters:
[] |
215 | 0.04 ms |
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[ "key" => "Bautz'ner Senf-Brotaufstrich Eier 200ml Glas" "path" => "/Marken/Bautzner/Produkte/Aufstrich/" ] |
216 | 0.92 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_47264" ] ] |
217 | 0.03 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='65'
Parameters:
[] |
218 | 0.04 ms |
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[ "key" => "BBQUE "Das Original" 400 ml" "path" => "/Marken/Bbque/Produkte/Saucen/" ] |
219 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='64'
Parameters:
[] |
220 | 0.04 ms |
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[ "key" => "BORN Grillzange" "path" => "/Marken/Born/Produkte/Fanartikel/" ] |
221 | 0.46 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_8948" ] ] |
222 | 0.04 ms |
SELECT name FROM classes WHERE id = ?
Parameters:
[
"6"
]
|
223 | 0.05 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='63'
Parameters:
[] |
224 | 0.06 ms |
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[ "key" => "Löwensenf Spezialitäten Set" "path" => "/Marken/Loewensenf/Produkte/Fanartikel/" ] |
225 | 0.55 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_25199" ] ] |
226 | 0.04 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='62'
Parameters:
[] |
227 | 0.04 ms |
SELECT o_id FROM objects WHERE o_path = :path AND `o_key` = :key
Parameters:
[ "key" => "TABASCO® Grillgabel" "path" => "/Marken/TABASCO®/Produkte/Kleidung & Zubehör/" ] |
228 | 0.57 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_179" ] ] |
229 | 0.04 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='60'
Parameters:
[] |
230 | 0.03 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='58'
Parameters:
[] |
231 | 0.03 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='56'
Parameters:
[] |
232 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='55'
Parameters:
[] |
233 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='54'
Parameters:
[] |
234 | 0.03 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='37'
Parameters:
[] |
235 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='36'
Parameters:
[] |
236 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='34'
Parameters:
[] |
237 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='15'
Parameters:
[] |
238 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='14'
Parameters:
[] |
239 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='12'
Parameters:
[] |
240 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='10'
Parameters:
[] |
241 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='9'
Parameters:
[] |
242 | 0.03 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='7'
Parameters:
[] |
243 | 0.03 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='5'
Parameters:
[] |
244 | 0.03 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='4'
Parameters:
[] |
245 | 0.03 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='3'
Parameters:
[] |
246 | 0.03 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='2'
Parameters:
[] |
247 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='17'
Parameters:
[] |
248 | 0.04 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='18'
Parameters:
[] |
249 | 0.04 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='21'
Parameters:
[] |
250 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='33'
Parameters:
[] |
251 | 0.03 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='32'
Parameters:
[] |
252 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='31'
Parameters:
[] |
253 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='30'
Parameters:
[] |
254 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='29'
Parameters:
[] |
255 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='28'
Parameters:
[] |
256 | 0.03 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='25'
Parameters:
[] |
257 | 0.04 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='24'
Parameters:
[] |
258 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='23'
Parameters:
[] |
259 | 0.02 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='22'
Parameters:
[] |
260 | 0.03 ms |
SELECT * FROM ecommerceframework_pricing_rule WHERE id='1'
Parameters:
[] |
261 | 0.61 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_3495__08530ec7fbba514adfd71b11a077babd"
]
|
262 | 0.29 ms |
SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ((o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1) ORDER BY `o_key` ASC
Parameters:
[
33739
]
|
263 | 0.16 ms |
SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ((o_parentId = ? AND objects.o_type IN ('variant')) AND objects.o_published = 1) ORDER BY `o_key` ASC
Parameters:
[
33744
]
|
264 | 0.03 ms |
SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (149533,149594,149848,149654,149839,149852,149845);
Parameters:
[] |
265 | 0.10 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_3497__836b29cafdf9f0d3966389d3c647c9fc"
]
|
266 | 0.15 ms |
SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ((o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1) ORDER BY `o_key` ASC
Parameters:
[
33744
]
|
267 | 0.15 ms |
SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ((o_parentId = ? AND objects.o_type IN ('variant')) AND objects.o_published = 1) ORDER BY `o_key` ASC
Parameters:
[
33943
]
|
268 | 0.03 ms |
SELECT o_id FROM objects WHERE o_id IN (149533,149594,149848,149654,149839,149852,149845)
Parameters:
[] |
269 | 0.26 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33943 "149533" "prices" "object" "" "0" 1 ] |
270 | 0.23 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33943 "149594" "prices" "object" "" "0" 2 ] |
271 | 0.20 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33943 "149848" "prices" "object" "" "0" 3 ] |
272 | 0.19 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33943 "149654" "prices" "object" "" "0" 4 ] |
273 | 0.18 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33943 "149839" "prices" "object" "" "0" 5 ] |
274 | 0.18 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33943 "149852" "prices" "object" "" "0" 6 ] |
275 | 0.19 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33943 "149845" "prices" "object" "" "0" 7 ] |
276 | 0.03 ms |
SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (149533,149594,149848,149654,149839,149852,149845);
Parameters:
[] |
277 | 0.10 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_3496__3284a0fc8291fd1c290804ef30b24c6b"
]
|
278 | 0.22 ms |
SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ((o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1) ORDER BY `o_key` ASC
Parameters:
[
33943
]
|
279 | 0.16 ms |
SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ((o_parentId = ? AND objects.o_type IN ('variant')) AND objects.o_published = 1) ORDER BY `o_key` ASC
Parameters:
[
33754
]
|
280 | 0.03 ms |
SELECT o_id FROM objects WHERE o_id IN (149533,149594,149848,149654,149839,149852,149845)
Parameters:
[] |
281 | 0.19 ms |
SELECT * FROM object_metadata_9 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33754 "149533" "prices" "object" "" "0" 1 ] |
282 | 0.17 ms |
SELECT * FROM object_metadata_9 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33754 "149594" "prices" "object" "" "0" 2 ] |
283 | 0.16 ms |
SELECT * FROM object_metadata_9 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33754 "149848" "prices" "object" "" "0" 3 ] |
284 | 0.16 ms |
SELECT * FROM object_metadata_9 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33754 "149654" "prices" "object" "" "0" 4 ] |
285 | 0.16 ms |
SELECT * FROM object_metadata_9 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33754 "149839" "prices" "object" "" "0" 5 ] |
286 | 0.16 ms |
SELECT * FROM object_metadata_9 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33754 "149852" "prices" "object" "" "0" 6 ] |
287 | 0.15 ms |
SELECT * FROM object_metadata_9 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33754 "149845" "prices" "object" "" "0" 7 ] |
288 | 0.03 ms |
SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (149533,149594,149848,149654,149839,149852,149845);
Parameters:
[] |
289 | 0.13 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_33817" ] ] |
290 | 0.10 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_33751" ] ] |
291 | 0.10 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_3498__2f0bd129b886714c39aa4a4172fd4df3"
]
|
292 | 0.15 ms |
SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ((o_parentId = ? AND objects.o_type IN ('variant')) AND objects.o_published = 1) ORDER BY `o_key` ASC
Parameters:
[
33752
]
|
293 | 0.03 ms |
SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (149533,149594,149848,149654,149839,149852,149845);
Parameters:
[] |
294 | 0.11 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_24913" ] ] |
295 | 0.58 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_3499__70a1deed89a2409ccb6a26abb3fe814f"
]
|
296 | 0.15 ms |
SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ((o_parentId = ? AND objects.o_type IN ('variant')) AND objects.o_published = 1) ORDER BY `o_key` ASC
Parameters:
[
33733
]
|
297 | 0.04 ms |
SELECT o_id FROM objects WHERE o_id IN (149533,149594,149848,149654,149839,149852,149845)
Parameters:
[] |
298 | 0.58 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33733 "149533" "prices" "object" "" "0" 1 ] |
299 | 0.23 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33733 "149594" "prices" "object" "" "0" 2 ] |
300 | 0.19 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33733 "149848" "prices" "object" "" "0" 3 ] |
301 | 0.18 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33733 "149654" "prices" "object" "" "0" 4 ] |
302 | 0.18 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33733 "149839" "prices" "object" "" "0" 5 ] |
303 | 0.17 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33733 "149852" "prices" "object" "" "0" 6 ] |
304 | 0.17 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33733 "149845" "prices" "object" "" "0" 7 ] |
305 | 0.03 ms |
SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (149533,149594,149848,149654,149839,149852,149845);
Parameters:
[] |
306 | 0.12 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_33816" ] ] |
307 | 0.09 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_24915" ] ] |
308 | 0.78 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_3278__42503880c2724a1ffedc139cdef0b84f"
]
|
309 | 0.17 ms |
SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ((o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1) ORDER BY `o_key` ASC
Parameters:
[
33733
]
|
310 | 0.14 ms |
SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ((o_parentId = ? AND objects.o_type IN ('variant')) AND objects.o_published = 1) ORDER BY `o_key` ASC
Parameters:
[
33737
]
|
311 | 0.03 ms |
SELECT o_id FROM objects WHERE o_id IN (149533,149594,149848,149654,149839,149852,149845)
Parameters:
[] |
312 | 0.21 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33737 "149533" "prices" "object" "" "0" 1 ] |
313 | 0.19 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33737 "149594" "prices" "object" "" "0" 2 ] |
314 | 0.19 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33737 "149848" "prices" "object" "" "0" 3 ] |
315 | 0.18 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33737 "149654" "prices" "object" "" "0" 4 ] |
316 | 0.19 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33737 "149839" "prices" "object" "" "0" 5 ] |
317 | 0.17 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33737 "149852" "prices" "object" "" "0" 6 ] |
318 | 0.17 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33737 "149845" "prices" "object" "" "0" 7 ] |
319 | 0.03 ms |
SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (149533,149594,149848,149654,149839,149852,149845);
Parameters:
[] |
320 | 0.65 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_3397__698b9bbfff2bc838ccef198b5b20be08"
]
|
321 | 0.16 ms |
SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ((o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1) ORDER BY `o_key` ASC
Parameters:
[
33737
]
|
322 | 0.15 ms |
SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ((o_parentId = ? AND objects.o_type IN ('variant')) AND objects.o_published = 1) ORDER BY `o_key` ASC
Parameters:
[
33735
]
|
323 | 0.18 ms |
SELECT o_id FROM objects WHERE o_id IN (149533,149594,149848,149654,149839,149852,149845)
Parameters:
[] |
324 | 0.21 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33735 "149533" "prices" "object" "" "0" 1 ] |
325 | 0.18 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33735 "149594" "prices" "object" "" "0" 2 ] |
326 | 0.18 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33735 "149848" "prices" "object" "" "0" 3 ] |
327 | 0.17 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33735 "149654" "prices" "object" "" "0" 4 ] |
328 | 0.17 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33735 "149839" "prices" "object" "" "0" 5 ] |
329 | 0.17 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33735 "149852" "prices" "object" "" "0" 6 ] |
330 | 0.19 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33735 "149845" "prices" "object" "" "0" 7 ] |
331 | 0.03 ms |
SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (149533,149594,149848,149654,149839,149852,149845);
Parameters:
[] |
332 | 0.11 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_3402__764df2ea6a4cd294a0759ff9003c3347"
]
|
333 | 0.17 ms |
SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ((o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1) ORDER BY `o_key` ASC
Parameters:
[
33735
]
|
334 | 1.29 ms |
SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ((o_parentId = ? AND objects.o_type IN ('variant')) AND objects.o_published = 1) ORDER BY `o_key` ASC
Parameters:
[
33734
]
|
335 | 0.27 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_155688" ] ] |
336 | 0.11 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "object_155689" ] ] |
337 | 0.04 ms |
SELECT o_id FROM objects WHERE o_id IN (149533,149594,149848,149654,149839,149852,149845)
Parameters:
[] |
338 | 1.48 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 155688 "149533" "prices" "object" "" "0" 1 ] |
339 | 0.46 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 155688 "149594" "prices" "object" "" "0" 2 ] |
340 | 0.49 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 155688 "149848" "prices" "object" "" "0" 3 ] |
341 | 0.47 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 155688 "149654" "prices" "object" "" "0" 4 ] |
342 | 0.42 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 155688 "149839" "prices" "object" "" "0" 5 ] |
343 | 0.22 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 155688 "149852" "prices" "object" "" "0" 6 ] |
344 | 0.21 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 155688 "149845" "prices" "object" "" "0" 7 ] |
345 | 0.04 ms |
SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (149533,149594,149848,149654,149839,149852,149845);
Parameters:
[] |
346 | 0.28 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_3401__67315e57e2d50bb3ed12ef0944550921"
]
|
347 | 0.24 ms |
SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ((o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1) ORDER BY `o_key` ASC
Parameters:
[
33734
]
|
348 | 0.18 ms |
SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ((o_parentId = ? AND objects.o_type IN ('variant')) AND objects.o_published = 1) ORDER BY `o_key` ASC
Parameters:
[
33736
]
|
349 | 0.09 ms |
SELECT o_id FROM objects WHERE o_id IN (149533,149594,149848,149654,149839,149852,149845)
Parameters:
[] |
350 | 0.35 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33736 "149533" "prices" "object" "" "0" 1 ] |
351 | 0.29 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33736 "149594" "prices" "object" "" "0" 2 ] |
352 | 0.28 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33736 "149848" "prices" "object" "" "0" 3 ] |
353 | 0.25 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33736 "149654" "prices" "object" "" "0" 4 ] |
354 | 0.24 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33736 "149839" "prices" "object" "" "0" 5 ] |
355 | 0.27 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33736 "149852" "prices" "object" "" "0" 6 ] |
356 | 0.25 ms |
SELECT * FROM object_metadata_11 WHERE o_id = ? AND dest_id = ? AND fieldname = ? AND ownertype = ? AND ownername = ? and position = ? and `index` = ? AND (type = 'object' or type = '')
Parameters:
[ 33736 "149845" "prices" "object" "" "0" 7 ] |
357 | 0.04 ms |
SELECT o_id FROM objects WHERE o_published=1 AND o_id IN (149533,149594,149848,149654,149839,149852,149845);
Parameters:
[] |
358 | 0.65 ms |
SELECT * FROM tmp_store WHERE id = ?
Parameters:
[
"thumb_3400__c884654d7359bb66eb40f13584e67602"
]
|
359 | 0.83 ms |
SELECT objects.o_id as o_id, `objects`.`o_type` FROM `objects` WHERE ((o_parentId = ? AND objects.o_type IN ('object','folder')) AND objects.o_published = 1) ORDER BY `o_key` ASC
Parameters:
[
33736
]
|
360 | 0.08 ms |
SELECT id FROM documents WHERE path = :path AND `key` = :key
Parameters:
[ "key" => "footer" "path" => "/Bbque/de/includes/" ] |
361 | 0.17 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "document_414" ] ] |
362 | 0.24 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "document_properties_414" ] ] |
363 | 0.09 ms |
SELECT * FROM documents_elements WHERE documentId = ?
Parameters:
[
414
]
|
364 | 0.21 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "asset_2930" ] ] |
365 | 0.16 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "document_592" ] ] |
366 | 0.22 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "document_598" ] ] |
367 | 0.17 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "document_595" ] ] |
368 | 0.19 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "document_596" ] ] |
369 | 0.14 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "document_597" ] ] |
370 | 0.16 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "document_593" ] ] |
371 | 0.16 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "document_411" ] ] |
372 | 0.18 ms |
SELECT id, (CASE WHEN expire IS NULL OR expire > ? THEN data ELSE NULL END) as data FROM cache WHERE id IN (?)
Parameters:
[ 1754260390 [ "document_410" ] ] |
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.