1 (0.369)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://mini-love.nl/'
/home/minilove/domains/mini-love.nl/public_html/index.php:75
2 (7.469)
SELECT *
FROM oc_setting
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/minilove/domains/mini-love.nl/public_html/index.php:87
3 (0.495)
SELECT *
FROM `oc_language`
WHERE status = '1'
/home/minilove/domains/mini-love.nl/public_html/index.php:166
4 (0.417)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/dutch.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
5 (0.330)
SELECT *
FROM oc_currency
/home/minilove/domains/mini-love.nl/public_html/system/library/currency.php:13
6 (0.442)
SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'
/home/minilove/domains/mini-love.nl/public_html/system/library/weight.php:9
7 (0.410)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'
/home/minilove/domains/mini-love.nl/public_html/system/library/length.php:9
8 (0.812)
SELECT *
FROM oc_setting
WHERE `store_id` = 0 AND
`key` = 'shoppica2' AND `group` = 'shoppica2'
/home/minilove/domains/mini-love.nl/public_html/tb_themes/shoppica2/library/DbSettingsHelper.php:38
9 (0.306)
SELECT *
FROM oc_language
ORDER BY sort_order, name
/home/minilove/domains/mini-love.nl/public_html/tb_themes/shoppica2/library/ExtensionModel.php:145
10 (0.693)
SELECT *
FROM oc_setting
WHERE `store_id` = 0 AND
`key` = 'extensions' AND `group` = 'shoppica2'
/home/minilove/domains/mini-love.nl/public_html/tb_themes/shoppica2/library/DbSettingsHelper.php:38
11 (0.605)
SELECT *
FROM oc_url_alias
WHERE keyword = 'mama-amp-papa'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:120
12 (1.013)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '95' AND store_id = '0'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:56
13 (0.400)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/minilove/domains/mini-love.nl/public_html/catalog/model/design/layout.php:4
14 (2.416)
SELECT c.*, cd.*, COUNT(p2c.category_id) AS products_count
FROM oc_category c
INNER JOIN oc_category_description cd ON (c.category_id = cd.category_id)
INNER JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
LEFT JOIN oc_product_to_store AS p2s ON p2s.store_id = c2s.store_id
LEFT JOIN oc_product_to_category AS p2c ON c.category_id = p2c.category_id AND p2c.product_id = p2s.product_id
LEFT JOIN oc_product p ON p.product_id = p2s.product_id
WHERE c.parent_id = 95
AND cd.language_id = 2
AND c2s.store_id = 0
AND c.status = 1 AND c.sort_order <> -1
AND p.status=1
GROUP BY c.category_id
ORDER BY c.sort_order, LCASE(cd.name)
/home/minilove/domains/mini-love.nl/public_html/tb_themes/shoppica2/model/categoryModel.php:42
15 (0.390)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/common/footer.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
16 (3.283)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE cd.language_id = '2' AND
c2s.store_id = '0' AND
c.status = '1' AND c.sort_order <> '-1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/minilove/domains/mini-love.nl/public_html/tb_themes/shoppica2/model/categoryModel.php:145
17 (0.741)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
18 (0.575)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
19 (0.567)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
20 (0.562)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=125'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
21 (0.543)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
22 (0.562)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=121'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
23 (0.564)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
24 (0.554)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=117'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
25 (0.554)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
26 (0.560)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=115'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
27 (0.548)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
28 (0.555)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=105'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
29 (0.565)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
30 (0.547)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=103'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
31 (0.554)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
32 (0.563)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=114'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
33 (0.550)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
34 (0.562)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=113'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
35 (0.558)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
36 (0.542)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=110'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
37 (0.571)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
38 (0.563)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=118'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
39 (0.549)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
40 (0.562)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=119'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
41 (0.588)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
42 (0.542)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=109'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
43 (0.565)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
44 (0.564)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=107'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
45 (0.549)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
46 (0.554)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=112'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
47 (0.568)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
48 (0.548)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=131'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
49 (0.554)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
50 (0.556)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
51 (0.550)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
52 (0.565)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
53 (0.565)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
54 (0.547)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=108'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
55 (0.561)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
56 (0.572)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=129'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
57 (0.551)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
58 (0.554)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=78'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
59 (0.562)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=122'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
60 (0.564)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=133'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
61 (0.549)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=141'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
62 (0.555)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=133'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
63 (0.549)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=142'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
64 (0.553)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=133'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
65 (0.554)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=143'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
66 (0.560)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=133'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
67 (0.551)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=130'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
68 (0.562)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=97'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
69 (0.572)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
70 (0.548)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=135'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
71 (0.563)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
72 (0.562)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=136'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
73 (0.549)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
74 (0.556)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=126'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
75 (0.565)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
76 (0.551)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=137'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
77 (0.555)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
78 (0.562)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=144'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
79 (0.543)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
80 (0.574)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=138'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
81 (0.559)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
82 (0.550)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
83 (0.562)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
84 (0.565)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=104'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
85 (0.551)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=123'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
86 (0.553)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
87 (0.565)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=124'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
88 (0.563)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=134'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
89 (0.552)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=140'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
90 (5.956)
SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0'
AND p2c.category_id IN (106,125,121,117,115,105,103,114,113,110,118,119,109,107,112,131,111,120,108,129,100)
ORDER BY m.sort_order, LCASE(m.name) ASC
/home/minilove/domains/mini-love.nl/public_html/tb_themes/shoppica2/catalog/model/manufacturerModel.php:15
91 (4.424)
SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0'
AND p2c.category_id IN (78)
ORDER BY m.sort_order, LCASE(m.name) ASC
/home/minilove/domains/mini-love.nl/public_html/tb_themes/shoppica2/catalog/model/manufacturerModel.php:15
92 (4.280)
SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0'
AND p2c.category_id IN (122)
ORDER BY m.sort_order, LCASE(m.name) ASC
/home/minilove/domains/mini-love.nl/public_html/tb_themes/shoppica2/catalog/model/manufacturerModel.php:15
93 (4.739)
SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0'
AND p2c.category_id IN (141,142,143,133)
ORDER BY m.sort_order, LCASE(m.name) ASC
/home/minilove/domains/mini-love.nl/public_html/tb_themes/shoppica2/catalog/model/manufacturerModel.php:15
94 (4.209)
SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0'
AND p2c.category_id IN (130)
ORDER BY m.sort_order, LCASE(m.name) ASC
/home/minilove/domains/mini-love.nl/public_html/tb_themes/shoppica2/catalog/model/manufacturerModel.php:15
95 (4.545)
SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0'
AND p2c.category_id IN (97)
ORDER BY m.sort_order, LCASE(m.name) ASC
/home/minilove/domains/mini-love.nl/public_html/tb_themes/shoppica2/catalog/model/manufacturerModel.php:15
96 (4.970)
SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0'
AND p2c.category_id IN (135,136,126,137,144,138,79)
ORDER BY m.sort_order, LCASE(m.name) ASC
/home/minilove/domains/mini-love.nl/public_html/tb_themes/shoppica2/catalog/model/manufacturerModel.php:15
97 (4.984)
SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0'
AND p2c.category_id IN (95)
ORDER BY m.sort_order, LCASE(m.name) ASC
/home/minilove/domains/mini-love.nl/public_html/tb_themes/shoppica2/catalog/model/manufacturerModel.php:15
98 (4.507)
SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0'
AND p2c.category_id IN (98)
ORDER BY m.sort_order, LCASE(m.name) ASC
/home/minilove/domains/mini-love.nl/public_html/tb_themes/shoppica2/catalog/model/manufacturerModel.php:15
99 (4.309)
SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0'
AND p2c.category_id IN (104)
ORDER BY m.sort_order, LCASE(m.name) ASC
/home/minilove/domains/mini-love.nl/public_html/tb_themes/shoppica2/catalog/model/manufacturerModel.php:15
100 (4.747)
SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0'
AND p2c.category_id IN (123)
ORDER BY m.sort_order, LCASE(m.name) ASC
/home/minilove/domains/mini-love.nl/public_html/tb_themes/shoppica2/catalog/model/manufacturerModel.php:15
101 (4.811)
SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0'
AND p2c.category_id IN (128)
ORDER BY m.sort_order, LCASE(m.name) ASC
/home/minilove/domains/mini-love.nl/public_html/tb_themes/shoppica2/catalog/model/manufacturerModel.php:15
102 (4.439)
SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0'
AND p2c.category_id IN (124)
ORDER BY m.sort_order, LCASE(m.name) ASC
/home/minilove/domains/mini-love.nl/public_html/tb_themes/shoppica2/catalog/model/manufacturerModel.php:15
103 (4.150)
SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0'
AND p2c.category_id IN (134)
ORDER BY m.sort_order, LCASE(m.name) ASC
/home/minilove/domains/mini-love.nl/public_html/tb_themes/shoppica2/catalog/model/manufacturerModel.php:15
104 (4.204)
SELECT DISTINCT(m.manufacturer_id), m.*
FROM oc_manufacturer m
LEFT JOIN oc_manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id)
INNER JOIN oc_product AS p ON m.manufacturer_id = p.manufacturer_id
INNER JOIN oc_product_to_category AS p2c ON p.product_id = p2c.product_id
WHERE m2s.store_id = '0'
AND p2c.category_id IN (140)
ORDER BY m.sort_order, LCASE(m.name) ASC
/home/minilove/domains/mini-love.nl/public_html/tb_themes/shoppica2/catalog/model/manufacturerModel.php:15
105 (1.422)
SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/information.php:10
106 (0.593)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=8'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
107 (0.548)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=4'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
108 (0.559)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=9'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
109 (0.631)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=6'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
110 (0.609)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=5'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
111 (0.509)
SELECT *
FROM oc_category AS c
LEFT JOIN oc_category_description AS cd ON (c.category_id = cd.category_id)
WHERE c.category_id = 95
AND cd.language_id = 2
/home/minilove/domains/mini-love.nl/public_html/tb_themes/shoppica2/model/categoryModel.php:124
112 (0.473)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/extension.php:4
113 (0.854)
SELECT *
FROM oc_setting
WHERE `store_id` = 0 AND
`key` = 'custom_stylesheet' AND `group` = 'shoppica2'
/home/minilove/domains/mini-love.nl/public_html/tb_themes/shoppica2/library/DbSettingsHelper.php:38
114 (0.450)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/product/category.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
115 (0.504)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '95' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:4
116 (0.539)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '95' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:4
117 (0.627)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
118 (0.621)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
119 (2.091)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '95' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:10
120 (19.107)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND (SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1) IS NULL AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '95'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:745
121 (33.468)
SELECT p.product_id,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special
FROM oc_product_to_category p2c
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND (SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1) IS NULL AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '95' GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,20
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:290
122 (2.303)
SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status,
(SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2')
AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15556' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
123 (1.950)
SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status,
(SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2')
AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15555' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
124 (1.920)
SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status,
(SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2')
AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15748' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
125 (1.953)
SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status,
(SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2')
AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15749' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
126 (1.919)
SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status,
(SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2')
AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15747' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
127 (1.924)
SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status,
(SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2')
AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15573' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
128 (1.904)
SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status,
(SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2')
AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15558' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
129 (1.918)
SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status,
(SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2')
AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15557' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
130 (1.954)
SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status,
(SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2')
AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14810' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
131 (1.955)
SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status,
(SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2')
AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15012' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
132 (1.971)
SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status,
(SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2')
AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14809' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
133 (1.952)
SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status,
(SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2')
AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15011' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
134 (1.954)
SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status,
(SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2')
AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15008' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
135 (1.944)
SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status,
(SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2')
AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14849' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
136 (1.997)
SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status,
(SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2')
AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '14848' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
137 (1.945)
SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status,
(SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2')
AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15003' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
138 (1.939)
SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status,
(SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2')
AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15005' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
139 (1.963)
SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status,
(SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2')
AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15007' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
140 (1.942)
SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status,
(SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2')
AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15609' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
141 (1.941)
SELECT DISTINCT *,(SELECT CASE WHEN p2p.product_id IS NOT NULL THEN MIN(pr2.quantity - p2p.quantity)+1 ELSE p.quantity END
FROM oc_product_to_product p2p
INNER JOIN oc_product AS pr2 ON p2p.related_id = pr2.product_id
WHERE p2p.product_id = p.product_id) As quantity, IFNULL((SELECT 1
FROM oc_product p2
INNER JOIN oc_product_to_product p2p ON p2.product_id = p2p.product_id
WHERE p.product_id = p2p.related_id AND p2.product_bundle_hidden = 1 LIMIT 1),0) As product_hidden, pd.name AS name, p.image, p.topleft_png, p.topright_png, p.bottomleft_png, p.bottomright_png,pd.description, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status,
(SELECT ds.name
FROM oc_delivery AS d
LEFT JOIN oc_delivery_status AS ds ON d.delivery_id = ds.delivery_status_id
WHERE d.delivery_id = p.delivery_id AND ds.language_id = '2')
AS delivery, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '2') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '15598' AND pd.language_id = '2' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p.status = '1'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-catalog_model_catalog_product.php:33
142 (0.770)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
143 (0.680)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
144 (0.567)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
145 (0.631)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15556'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
146 (0.706)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
147 (0.714)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
148 (0.566)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
149 (0.625)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15555'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
150 (0.716)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
151 (0.709)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
152 (0.587)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
153 (0.627)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15748'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
154 (0.739)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
155 (0.726)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
156 (0.583)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
157 (0.643)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15749'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
158 (0.716)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
159 (0.689)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
160 (0.572)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
161 (0.679)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15747'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
162 (0.702)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
163 (0.695)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
164 (0.569)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
165 (0.656)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15573'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
166 (0.704)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
167 (0.694)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
168 (0.571)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
169 (0.635)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15558'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
170 (0.732)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
171 (0.726)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
172 (0.576)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
173 (0.622)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15557'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
174 (0.724)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
175 (0.706)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
176 (0.580)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
177 (0.645)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=14810'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
178 (0.709)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
179 (0.722)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
180 (0.592)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
181 (0.672)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15012'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
182 (0.753)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
183 (0.725)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
184 (0.602)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
185 (0.649)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=14809'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
186 (0.748)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
187 (0.717)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
188 (0.609)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
189 (0.661)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15011'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
190 (0.734)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
191 (0.718)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
192 (0.597)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
193 (0.666)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15008'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
194 (0.721)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
195 (0.728)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
196 (0.588)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
197 (0.662)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=14849'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
198 (0.737)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
199 (0.725)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
200 (5.822)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '150' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2332')
ORDER BY tr1.priority ASC
/home/minilove/domains/mini-love.nl/public_html/system/library/tax.php:91
201 (1.658)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.tax_class_id = '9' AND tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '150' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2332')
ORDER BY tr1.priority ASC
/home/minilove/domains/mini-love.nl/public_html/system/library/tax.php:119
202 (0.631)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
203 (0.685)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=14848'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
204 (0.821)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
205 (0.738)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
206 (0.597)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
207 (0.714)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15003'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
208 (0.780)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
209 (0.734)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
210 (0.594)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
211 (0.651)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15005'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
212 (0.775)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
213 (0.762)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
214 (0.622)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
215 (0.663)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15007'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
216 (0.801)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
217 (0.726)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
218 (0.603)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
219 (0.626)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15609'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
220 (0.723)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
221 (0.713)
SELECT *
FROM oc_setting
WHERE store_id = '0' AND `group` = 'labelimage'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/setting.php:6
222 (0.581)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
223 (0.636)
SELECT *
FROM oc_url_alias
WHERE `query` = 'product_id=15598'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
224 (0.560)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
225 (0.576)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
226 (0.572)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
227 (0.562)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
228 (0.571)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
229 (0.576)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
230 (0.564)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
231 (0.574)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
232 (0.569)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
233 (0.554)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
234 (0.575)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
235 (0.584)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
236 (0.576)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
237 (0.579)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
238 (0.588)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
239 (0.555)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
240 (0.596)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
241 (0.296)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '95' AND store_id = '0'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:56
242 (0.456)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/minilove/domains/mini-love.nl/public_html/catalog/model/design/layout.php:4
243 (0.384)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/extension.php:4
244 (0.529)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '95' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:4
245 (0.399)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/module/filter.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
246 (0.589)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
247 (1.096)
SELECT pf.filter_id
FROM oc_product_filter pf join oc_product_to_category ptc on pf.product_id = ptc.product_id
WHERE ptc.category_id = '95'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:18
248 (0.369)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/module/information.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
249 (1.425)
SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/information.php:10
250 (0.588)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=8'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
251 (0.580)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=4'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
252 (0.568)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=9'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
253 (0.551)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=6'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
254 (0.577)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=5'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
255 (0.295)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '95' AND store_id = '0'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:56
256 (0.415)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/minilove/domains/mini-love.nl/public_html/catalog/model/design/layout.php:4
257 (0.362)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/extension.php:4
258 (0.311)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '95' AND store_id = '0'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:56
259 (0.409)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/minilove/domains/mini-love.nl/public_html/catalog/model/design/layout.php:4
260 (0.375)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/extension.php:4
261 (0.364)
SELECT *
FROM `oc_smartbar`
WHERE smartbar_id = 1 AND `status` = 1
/home/minilove/domains/mini-love.nl/public_html/catalog/model/module/smartbar.php:8
262 (0.300)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '95' AND store_id = '0'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:56
263 (0.407)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/minilove/domains/mini-love.nl/public_html/catalog/model/design/layout.php:4
264 (0.415)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/extension.php:4
265 (0.373)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/common/footer.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
266 (1.472)
SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/information.php:10
267 (0.576)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=8'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
268 (0.591)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=4'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
269 (0.551)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=9'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
270 (0.563)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=6'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
271 (0.566)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=5'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
272 (1.022)
DELETE
FROM `oc_customer_online`
WHERE (UNIX_TIMESTAMP(`date_added`) + 3600) < UNIX_TIMESTAMP(NOW())
/home/minilove/domains/mini-love.nl/public_html/catalog/model/tool/online.php:4
273 (0.857)
REPLACE INTO `oc_customer_online` SET `ip` = '3.235.41.241', `customer_id` = '0', `url` = 'http://mini-love.nl/mama-amp-papa', `referer` = '', `date_added` = NOW()
/home/minilove/domains/mini-love.nl/public_html/catalog/model/tool/online.php:6
274 (0.347)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/module/language.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
275 (0.581)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
276 (0.345)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/module/currency.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
277 (0.579)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
278 (0.355)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/module/cart.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
279 (1.095)
SHOW TABLES
FROM `minilove_adva1` LIKE 'oc_product_to_product'
/home/minilove/domains/mini-love.nl/public_html/system/library/cart.php:28
280 (0.368)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/extension.php:4
281 (0.345)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/total/sub_total.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
282 (1.003)
SHOW TABLES
FROM `minilove_adva1` LIKE 'oc_product_to_product'
/home/minilove/domains/mini-love.nl/public_html/system/library/cart.php:28
283 (0.945)
SHOW TABLES
FROM `minilove_adva1` LIKE 'oc_product_to_product'
/home/minilove/domains/mini-love.nl/public_html/system/library/cart.php:28
284 (0.348)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/total/credit.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
285 (0.298)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/home/minilove/domains/mini-love.nl/public_html/system/library/customer.php:162
286 (0.333)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/total/total.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
287 (0.922)
SHOW TABLES
FROM `minilove_adva1` LIKE 'oc_product_to_product'
/home/minilove/domains/mini-love.nl/public_html/system/library/cart.php:28
288 (0.913)
SHOW TABLES
FROM `minilove_adva1` LIKE 'oc_product_to_product'
/home/minilove/domains/mini-love.nl/public_html/system/library/cart.php:28
289 (0.347)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/module/wrdprss.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
290 (0.345)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/common/header.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
291 (2.641)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:10
292 (2.774)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '100' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:10
293 (0.679)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
294 (0.607)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=106'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
295 (0.642)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
296 (0.614)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=125'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
297 (0.574)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
298 (0.668)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=121'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
299 (0.620)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
300 (0.634)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=117'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
301 (0.582)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
302 (0.584)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=115'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
303 (0.653)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
304 (0.652)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=105'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
305 (0.573)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
306 (0.579)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=103'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
307 (0.645)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
308 (0.599)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=114'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
309 (0.581)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
310 (0.616)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=113'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
311 (0.634)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
312 (0.552)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=110'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
313 (0.552)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
314 (0.543)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=118'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
315 (0.638)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
316 (0.606)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=119'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
317 (0.614)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
318 (0.569)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=109'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
319 (0.614)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
320 (0.578)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=107'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
321 (0.592)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
322 (0.592)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=112'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
323 (0.595)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
324 (0.611)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=131'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
325 (0.607)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
326 (0.630)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=111'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
327 (0.595)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
328 (0.628)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=120'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
329 (0.604)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
330 (0.608)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=108'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
331 (0.580)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
332 (0.614)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=129'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
333 (0.574)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=100'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
334 (2.045)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '78' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:10
335 (0.637)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=78'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
336 (1.994)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '122' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:10
337 (0.622)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=122'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
338 (2.223)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '133' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:10
339 (0.642)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=133'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
340 (0.577)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=141'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
341 (0.571)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=133'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
342 (0.585)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=142'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
343 (0.579)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=133'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
344 (0.596)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=143'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
345 (0.612)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=133'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
346 (1.935)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '130' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:10
347 (0.609)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=130'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
348 (1.934)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '97' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:10
349 (0.585)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=97'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
350 (2.223)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '79' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:10
351 (0.583)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
352 (0.561)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=135'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
353 (0.566)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
354 (0.552)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=136'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
355 (0.572)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
356 (0.564)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=126'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
357 (0.604)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
358 (0.588)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=137'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
359 (0.553)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
360 (0.541)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=144'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
361 (0.560)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
362 (0.538)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=138'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
363 (0.562)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=79'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
364 (1.835)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '95' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:10
365 (0.567)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
366 (1.833)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '98' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:10
367 (0.574)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=98'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
368 (1.822)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '104' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:10
369 (0.569)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=104'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
370 (1.832)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '123' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:10
371 (0.553)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=123'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
372 (1.810)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '128' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:10
373 (0.587)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=128'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
374 (1.838)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '124' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:10
375 (0.564)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=124'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
376 (1.846)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '134' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:10
377 (0.594)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=134'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
378 (1.934)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '140' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:10
379 (0.622)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=140'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
380 (0.325)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '95' AND store_id = '0'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:56
381 (0.410)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/minilove/domains/mini-love.nl/public_html/catalog/model/design/layout.php:4
382 (0.415)
SELECT *
FROM oc_extension
WHERE `type` = 'module'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/extension.php:4
383 (0.569)
SELECT DISTINCT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '95' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:4
384 (0.405)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/module/filter.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
385 (0.614)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
386 (0.398)
SELECT pf.filter_id
FROM oc_product_filter pf join oc_product_to_category ptc on pf.product_id = ptc.product_id
WHERE ptc.category_id = '95'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/category.php:18
387 (0.381)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/module/information.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
388 (1.485)
SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/home/minilove/domains/mini-love.nl/public_html/catalog/model/catalog/information.php:10
389 (0.587)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=8'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
390 (0.589)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=4'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
391 (0.599)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=9'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
392 (0.593)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=6'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
393 (0.585)
SELECT *
FROM oc_url_alias
WHERE `query` = 'information_id=5'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:227
394 (0.367)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/module/language.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
395 (0.602)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
396 (0.383)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/module/currency.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
397 (0.615)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
398 (0.399)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/module/cart.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
399 (0.967)
SHOW TABLES
FROM `minilove_adva1` LIKE 'oc_product_to_product'
/home/minilove/domains/mini-love.nl/public_html/system/library/cart.php:28
400 (0.436)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/extension.php:4
401 (0.368)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/total/sub_total.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
402 (0.950)
SHOW TABLES
FROM `minilove_adva1` LIKE 'oc_product_to_product'
/home/minilove/domains/mini-love.nl/public_html/system/library/cart.php:28
403 (0.952)
SHOW TABLES
FROM `minilove_adva1` LIKE 'oc_product_to_product'
/home/minilove/domains/mini-love.nl/public_html/system/library/cart.php:28
404 (0.375)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/total/credit.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
405 (0.309)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/home/minilove/domains/mini-love.nl/public_html/system/library/customer.php:162
406 (0.383)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/total/total.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
407 (0.955)
SHOW TABLES
FROM `minilove_adva1` LIKE 'oc_product_to_product'
/home/minilove/domains/mini-love.nl/public_html/system/library/cart.php:28
408 (0.957)
SHOW TABLES
FROM `minilove_adva1` LIKE 'oc_product_to_product'
/home/minilove/domains/mini-love.nl/public_html/system/library/cart.php:28
409 (0.631)
SELECT *
FROM oc_url_alias
WHERE keyword = 'mama-amp-papa'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:299
410 (0.603)
SELECT *
FROM oc_url_alias
WHERE query = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:303
411 (0.448)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/checkout/cart.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
412 (0.986)
SHOW TABLES
FROM `minilove_adva1` LIKE 'oc_product_to_product'
/home/minilove/domains/mini-love.nl/public_html/system/library/cart.php:28
413 (0.938)
SHOW TABLES
FROM `minilove_adva1` LIKE 'oc_product_to_product'
/home/minilove/domains/mini-love.nl/public_html/system/library/cart.php:28
414 (0.409)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/extension.php:4
415 (0.380)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/total/sub_total.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
416 (0.952)
SHOW TABLES
FROM `minilove_adva1` LIKE 'oc_product_to_product'
/home/minilove/domains/mini-love.nl/public_html/system/library/cart.php:28
417 (0.950)
SHOW TABLES
FROM `minilove_adva1` LIKE 'oc_product_to_product'
/home/minilove/domains/mini-love.nl/public_html/system/library/cart.php:28
418 (0.380)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/total/credit.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
419 (0.327)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/home/minilove/domains/mini-love.nl/public_html/system/library/customer.php:162
420 (0.377)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/total/total.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
421 (0.949)
SHOW TABLES
FROM `minilove_adva1` LIKE 'oc_product_to_product'
/home/minilove/domains/mini-love.nl/public_html/system/library/cart.php:28
422 (0.384)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/checkout/cart.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
423 (0.946)
SHOW TABLES
FROM `minilove_adva1` LIKE 'oc_product_to_product'
/home/minilove/domains/mini-love.nl/public_html/system/library/cart.php:28
424 (0.936)
SHOW TABLES
FROM `minilove_adva1` LIKE 'oc_product_to_product'
/home/minilove/domains/mini-love.nl/public_html/system/library/cart.php:28
425 (0.410)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/minilove/domains/mini-love.nl/public_html/catalog/model/setting/extension.php:4
426 (0.371)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/total/sub_total.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
427 (0.946)
SHOW TABLES
FROM `minilove_adva1` LIKE 'oc_product_to_product'
/home/minilove/domains/mini-love.nl/public_html/system/library/cart.php:28
428 (0.959)
SHOW TABLES
FROM `minilove_adva1` LIKE 'oc_product_to_product'
/home/minilove/domains/mini-love.nl/public_html/system/library/cart.php:28
429 (0.390)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/total/credit.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
430 (0.301)
SELECT SUM(amount) AS total
FROM oc_customer_transaction
WHERE customer_id = '0'
/home/minilove/domains/mini-love.nl/public_html/system/library/customer.php:162
431 (0.360)
SELECT *
FROM oc_translations
WHERE lang_file = '/home/minilove/domains/mini-love.nl/public_html/catalog/language/dutch/total/total.php'
/home/minilove/domains/mini-love.nl/public_html/vqmod/vqcache/vq2-system_library_language.php:53
432 (0.949)
SHOW TABLES
FROM `minilove_adva1` LIKE 'oc_product_to_product'
/home/minilove/domains/mini-love.nl/public_html/system/library/cart.php:28
433 (0.605)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238
434 (0.604)
SELECT *
FROM oc_url_alias
WHERE `query` = 'category_id=95'
/home/minilove/domains/mini-love.nl/public_html/catalog/controller/common/seo_url.php:238