Queries: 191, Total time: 35.596 ms [By time] [By id]
1 (0.098)
SELECT *
FROM oc2_store
WHERE REPLACE(`url`, 'www.', '') = 'http://zit-statafel.nl/'
2 (0.807)
SELECT *
FROM `oc2_setting`
WHERE store_id = '0' OR store_id = '1'
ORDER BY store_id ASC
3 (0.087)
SELECT *
FROM `oc2_language`
WHERE status = '1'
4 (0.093)
SELECT *
FROM oc2_currency
5 (0.239)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc2_tax_rule tr1
LEFT JOIN oc2_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc2_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc2_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc2_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '2' AND z2gz.country_id = '150' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2332')
ORDER BY tr1.priority ASC
6 (0.198)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc2_tax_rule tr1
LEFT JOIN oc2_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc2_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc2_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc2_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '2' AND z2gz.country_id = '150' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2332')
ORDER BY tr1.priority ASC
7 (0.103)
SELECT *
FROM oc2_weight_class wc
LEFT JOIN oc2_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'
8 (0.090)
SELECT *
FROM oc2_length_class mc
LEFT JOIN oc2_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'
9 (0.135)
DELETE
FROM oc2_cart
WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
10 (0.143)
SELECT *
FROM oc2_extension
WHERE `type` = 'openbay'
11 (0.115)
SELECT *
FROM oc2_event
12 (0.201)
SELECT *
FROM oc2_url_alias
WHERE keyword = 'hooglaagtafels'
13 (0.222)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'common/home'
14 (0.220)
SELECT DISTINCT *
FROM oc2_category c
LEFT JOIN oc2_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc2_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '41' AND cd.language_id = '2' AND c2s.store_id = '1' AND c.status = '1'
15 (0.186)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
16 (0.132)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
17 (0.184)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/compare'
18 (2.274)
SELECT *
FROM oc2_category c
LEFT JOIN oc2_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc2_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '41' AND cd.language_id = '2' AND c2s.store_id = '1' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
19 (0.447)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc2_category_path cp
LEFT JOIN oc2_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc2_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc2_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc2_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1' AND cp.path_id = '148'
20 (0.185)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
21 (0.096)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
22 (0.086)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=148'
23 (0.388)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc2_category_path cp
LEFT JOIN oc2_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc2_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc2_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc2_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1' AND cp.path_id = '149'
24 (0.167)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
25 (0.095)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
26 (0.086)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=149'
27 (0.345)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc2_category_path cp
LEFT JOIN oc2_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc2_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc2_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc2_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1' AND cp.path_id = '151'
28 (0.172)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
29 (0.106)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
30 (0.098)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=151'
31 (0.352)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc2_category_path cp
LEFT JOIN oc2_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc2_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc2_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc2_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1' AND cp.path_id = '156'
32 (0.232)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
33 (0.147)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
34 (0.121)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=156'
35 (0.243)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc2_product_to_category p2c
LEFT JOIN oc2_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc2_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc2_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1' AND p2c.category_id = '41'
36 (0.300)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM oc2_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc2_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '2' 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 oc2_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '2' 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 oc2_product_to_category p2c
LEFT JOIN oc2_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc2_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc2_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1' AND p2c.category_id = '41' GROUP BY p.product_id
ORDER BY p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,15
37 (0.187)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
38 (0.120)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
39 (0.178)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'sort=0' OR `query` = 'p.sort_order'
40 (0.138)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'order=0' OR `query` = 'ASC'
41 (0.177)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
42 (0.139)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
43 (0.177)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'sort=0' OR `query` = 'pd.name'
44 (0.127)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'order=0' OR `query` = 'ASC'
45 (0.176)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
46 (0.136)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
47 (0.175)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'sort=0' OR `query` = 'pd.name'
48 (0.145)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'order=0' OR `query` = 'DESC'
49 (0.179)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
50 (0.117)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
51 (0.175)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'sort=0' OR `query` = 'p.price'
52 (0.127)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'order=0' OR `query` = 'ASC'
53 (0.175)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
54 (0.116)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
55 (0.176)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'sort=0' OR `query` = 'p.price'
56 (0.133)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'order=0' OR `query` = 'DESC'
57 (0.175)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
58 (0.116)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
59 (0.214)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'sort=0' OR `query` = 'rating'
60 (0.136)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'order=0' OR `query` = 'DESC'
61 (0.176)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
62 (0.125)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
63 (0.232)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'sort=0' OR `query` = 'rating'
64 (0.173)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'order=0' OR `query` = 'ASC'
65 (0.200)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
66 (0.109)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
67 (0.150)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'sort=0' OR `query` = 'p.model'
68 (0.098)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'order=0' OR `query` = 'ASC'
69 (0.145)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
70 (0.095)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
71 (0.146)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'sort=0' OR `query` = 'p.model'
72 (0.103)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'order=0' OR `query` = 'DESC'
73 (0.145)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
74 (0.090)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
75 (0.097)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'limit=15' OR `query` = '15'
76 (0.143)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
77 (0.088)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
78 (0.097)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'limit=25' OR `query` = '25'
79 (0.146)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
80 (0.089)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
81 (0.097)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'limit=50' OR `query` = '50'
82 (0.144)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
83 (0.089)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
84 (0.097)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'limit=75' OR `query` = '75'
85 (0.144)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
86 (0.089)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
87 (0.101)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'limit=100' OR `query` = '100'
88 (0.149)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
89 (0.090)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
90 (0.145)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'page=0' OR `query` = '{page}'
91 (0.144)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
92 (0.089)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
93 (0.152)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'common/home'
94 (0.068)
SELECT *
FROM oc2_category_to_layout
WHERE category_id = '41' AND store_id = '1'
95 (0.082)
SELECT *
FROM oc2_layout_route
WHERE 'product/category' LIKE route AND store_id = '1'
ORDER BY route DESC LIMIT 1
96 (0.080)
SELECT *
FROM oc2_layout_module
WHERE layout_id = '3' AND position = 'column_left'
ORDER BY sort_order
97 (1.444)
SELECT *
FROM oc2_category c
LEFT JOIN oc2_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc2_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 = '1' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
98 (1.347)
SELECT *
FROM oc2_category c
LEFT JOIN oc2_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc2_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '41' AND cd.language_id = '2' AND c2s.store_id = '1' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
99 (0.165)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
100 (0.093)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
101 (0.086)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=148'
102 (0.150)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
103 (0.089)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
104 (0.083)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=149'
105 (0.145)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
106 (0.089)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
107 (0.083)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=151'
108 (0.145)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
109 (0.088)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
110 (0.084)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=156'
111 (0.146)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
112 (0.088)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
113 (0.061)
SELECT *
FROM oc2_module
WHERE module_id = '30'
114 (0.136)
SELECT *
FROM oc2_banner_image bi
LEFT JOIN oc2_banner_image_description bid ON (bi.banner_image_id = bid.banner_image_id)
WHERE bi.banner_id = '6' AND bid.language_id = '2'
ORDER BY bi.sort_order ASC
115 (0.101)
SELECT *
FROM oc2_category_to_layout
WHERE category_id = '41' AND store_id = '1'
116 (0.077)
SELECT *
FROM oc2_layout_route
WHERE 'product/category' LIKE route AND store_id = '1'
ORDER BY route DESC LIMIT 1
117 (0.094)
SELECT *
FROM oc2_layout_module
WHERE layout_id = '3' AND position = 'column_right'
ORDER BY sort_order
118 (0.074)
SELECT *
FROM oc2_category_to_layout
WHERE category_id = '41' AND store_id = '1'
119 (0.075)
SELECT *
FROM oc2_layout_route
WHERE 'product/category' LIKE route AND store_id = '1'
ORDER BY route DESC LIMIT 1
120 (0.075)
SELECT *
FROM oc2_layout_module
WHERE layout_id = '3' AND position = 'content_top'
ORDER BY sort_order
121 (0.094)
SELECT *
FROM oc2_category_to_layout
WHERE category_id = '41' AND store_id = '1'
122 (0.076)
SELECT *
FROM oc2_layout_route
WHERE 'product/category' LIKE route AND store_id = '1'
ORDER BY route DESC LIMIT 1
123 (0.064)
SELECT *
FROM oc2_layout_module
WHERE layout_id = '3' AND position = 'content_bottom'
ORDER BY sort_order
124 (1.350)
SELECT *
FROM oc2_information i
LEFT JOIN oc2_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc2_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '2' AND i2s.store_id = '1' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
125 (0.164)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'information/information'
126 (0.111)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'information_id=7' OR `query` = '7'
127 (0.150)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'information/information'
128 (0.110)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'information_id=8' OR `query` = '8'
129 (0.155)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'information/information'
130 (0.106)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'information_id=9' OR `query` = '9'
131 (0.144)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'information/information'
132 (0.102)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'information_id=10' OR `query` = '10'
133 (0.144)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'information/information'
134 (0.106)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'information_id=11' OR `query` = '11'
135 (0.136)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/return/add'
136 (0.143)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/manufacturer'
137 (0.143)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/voucher'
138 (0.134)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'affiliate/account'
139 (0.133)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/account'
140 (0.134)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/order'
141 (0.165)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/wishlist'
142 (0.136)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/newsletter'
143 (0.080)
SELECT *
FROM oc2_extension
WHERE `type` = 'analytics'
144 (0.155)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/account'
145 (0.140)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/logout'
146 (0.150)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'common/home'
147 (0.137)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/wishlist'
148 (0.133)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/account'
149 (0.134)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/register'
150 (0.133)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/login'
151 (0.133)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/order'
152 (0.140)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/transaction'
153 (0.134)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/download'
154 (0.134)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/logout'
155 (0.141)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'checkout/cart'
156 (0.141)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'checkout/checkout'
157 (0.150)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'information/contact'
158 (1.310)
SELECT *
FROM oc2_category c
LEFT JOIN oc2_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc2_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 = '1' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
159 (1.250)
SELECT *
FROM oc2_category c
LEFT JOIN oc2_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc2_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '41' AND cd.language_id = '2' AND c2s.store_id = '1' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
160 (0.371)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc2_category_path cp
LEFT JOIN oc2_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc2_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc2_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc2_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1' AND cp.path_id = '148'
161 (0.162)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
162 (0.096)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
163 (0.086)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=148'
164 (0.331)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc2_category_path cp
LEFT JOIN oc2_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc2_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc2_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc2_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1' AND cp.path_id = '149'
165 (0.163)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
166 (0.093)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
167 (0.087)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=149'
168 (0.314)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc2_category_path cp
LEFT JOIN oc2_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc2_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc2_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc2_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1' AND cp.path_id = '151'
169 (0.164)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
170 (0.088)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
171 (0.085)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=151'
172 (0.327)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc2_category_path cp
LEFT JOIN oc2_product_to_category p2c ON (cp.category_id = p2c.category_id)
LEFT JOIN oc2_product p ON (p2c.product_id = p.product_id)
LEFT JOIN oc2_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc2_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '1' AND cp.path_id = '156'
173 (0.165)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
174 (0.089)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
175 (0.086)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=156'
176 (0.149)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
177 (0.090)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
178 (0.167)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'common/language/language'
179 (0.161)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
180 (0.095)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
181 (0.170)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'common/currency/currency'
182 (0.151)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
183 (0.091)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
184 (0.147)
SELECT *
FROM oc2_cart
WHERE customer_id = '0' AND session_id = '36c20ffd6d0f6bc0f7d14e07117d8fff'
185 (0.082)
SELECT *
FROM oc2_extension
WHERE `type` = 'total'
186 (0.098)
SELECT *
FROM oc2_cart
WHERE customer_id = '0' AND session_id = '36c20ffd6d0f6bc0f7d14e07117d8fff'
187 (0.087)
SELECT *
FROM oc2_cart
WHERE customer_id = '0' AND session_id = '36c20ffd6d0f6bc0f7d14e07117d8fff'
188 (0.079)
SELECT *
FROM oc2_cart
WHERE customer_id = '0' AND session_id = '36c20ffd6d0f6bc0f7d14e07117d8fff'
189 (0.093)
SELECT *
FROM oc2_cart
WHERE customer_id = '0' AND session_id = '36c20ffd6d0f6bc0f7d14e07117d8fff'
190 (0.154)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'checkout/cart'
191 (0.148)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'checkout/checkout'