Categorieën

Queries: 277, Total time: 84.449 ms [By time] [By id]
1 (0.135)
SELECT *
FROM oc2_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://werkplekmeubilair.nl/'
2 (0.713)
SELECT *
FROM `oc2_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
3 (0.088)
SELECT *
FROM `oc2_language`
WHERE status = '1'
4 (0.066)
SELECT *
FROM oc2_currency
5 (0.278)
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
6 (0.101)
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'
7 (26.712)
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'
8 (0.140)
DELETE
FROM oc2_cart
WHERE customer_id = '0' AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
9 (0.086)
SELECT *
FROM oc2_extension
WHERE `type` = 'openbay'
10 (0.063)
SELECT *
FROM oc2_event
11 (0.103)
SELECT *
FROM oc2_layout_route
WHERE 'common/home' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
12 (0.123)
SELECT *
FROM oc2_layout_module
WHERE layout_id = '1' AND position = 'column_left'
ORDER BY sort_order
13 (0.062)
SELECT *
FROM oc2_module
WHERE module_id = '37'
14 (3.371)
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 = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
15 (0.327)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
16 (0.184)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=40'
17 (0.279)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
18 (0.166)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
19 (0.276)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
20 (0.169)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=37'
21 (0.269)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
22 (0.160)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=38'
23 (0.266)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
24 (0.165)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=36'
25 (0.147)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
26 (0.091)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=62'
27 (0.146)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
28 (0.077)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=117'
29 (0.145)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
30 (0.088)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=42'
31 (0.149)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
32 (0.106)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=157'
33 (0.157)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
34 (0.100)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=35'
35 (0.156)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
36 (0.082)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=123'
37 (0.144)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
38 (0.090)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=47'
39 (0.156)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
40 (0.081)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=122'
41 (0.144)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
42 (0.090)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=85'
43 (0.144)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
44 (0.088)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=43'
45 (0.099)
SELECT *
FROM oc2_layout_route
WHERE 'common/home' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
46 (0.070)
SELECT *
FROM oc2_layout_module
WHERE layout_id = '1' AND position = 'column_right'
ORDER BY sort_order
47 (0.091)
SELECT *
FROM oc2_layout_route
WHERE 'common/home' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
48 (0.084)
SELECT *
FROM oc2_layout_module
WHERE layout_id = '1' AND position = 'content_top'
ORDER BY sort_order
49 (0.068)
SELECT *
FROM oc2_module
WHERE module_id = '33'
50 (0.179)
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 = '7' AND bid.language_id = '2'
ORDER BY bi.sort_order ASC
51 (1.433)
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 = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
52 (0.170)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
53 (0.095)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=40'
54 (0.151)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
55 (0.094)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
56 (0.148)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
57 (0.087)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=37'
58 (0.146)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
59 (0.089)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=38'
60 (0.162)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
61 (0.092)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=36'
62 (0.159)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
63 (0.091)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=62'
64 (0.149)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
65 (0.078)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=117'
66 (0.145)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
67 (0.088)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=42'
68 (0.144)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
69 (0.110)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=157'
70 (0.147)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
71 (0.088)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=35'
72 (0.146)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
73 (0.080)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=123'
74 (0.159)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
75 (0.093)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=47'
76 (0.158)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
77 (0.078)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=122'
78 (0.148)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
79 (0.093)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=85'
80 (0.145)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
81 (0.088)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=43'
82 (0.097)
SELECT *
FROM oc2_layout_route
WHERE 'common/home' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
83 (0.081)
SELECT *
FROM oc2_layout_module
WHERE layout_id = '1' AND position = 'content_bottom'
ORDER BY sort_order
84 (1.293)
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 = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
85 (0.168)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'information/information'
86 (0.111)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'information_id=7' OR `query` = '7'
87 (0.147)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'information/information'
88 (0.105)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'information_id=8' OR `query` = '8'
89 (0.143)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'information/information'
90 (0.104)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'information_id=9' OR `query` = '9'
91 (0.142)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'information/information'
92 (0.101)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'information_id=10' OR `query` = '10'
93 (0.145)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'information/information'
94 (0.103)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'information_id=11' OR `query` = '11'
95 (0.137)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/return/add'
96 (0.142)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/manufacturer'
97 (0.133)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/voucher'
98 (0.132)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'affiliate/account'
99 (0.137)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/account'
100 (0.135)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/order'
101 (0.133)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/wishlist'
102 (0.135)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/newsletter'
103 (0.079)
SELECT *
FROM oc2_extension
WHERE `type` = 'analytics'
104 (0.178)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/account'
105 (0.136)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/logout'
106 (0.150)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'common/home'
107 (0.135)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/wishlist'
108 (0.134)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/account'
109 (0.134)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/register'
110 (0.134)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/login'
111 (0.134)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/order'
112 (0.134)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/transaction'
113 (0.133)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/download'
114 (0.133)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'account/logout'
115 (0.141)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'checkout/cart'
116 (0.140)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'checkout/checkout'
117 (0.153)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'information/contact'
118 (1.379)
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 = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
119 (1.206)
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 = '40' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
120 (0.418)
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 = '0' AND cp.path_id = '121'
121 (0.162)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
122 (0.093)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=40'
123 (0.079)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=121'
124 (0.322)
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 = '0' AND cp.path_id = '115'
125 (0.160)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
126 (0.091)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=40'
127 (0.077)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=115'
128 (0.325)
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 = '0' AND cp.path_id = '114'
129 (0.160)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
130 (0.092)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=40'
131 (0.080)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=114'
132 (0.322)
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 = '0' AND cp.path_id = '120'
133 (0.157)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
134 (0.093)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=40'
135 (0.078)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=120'
136 (0.145)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
137 (0.087)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=40'
138 (1.247)
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 = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
139 (0.368)
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 = '0' AND cp.path_id = '148'
140 (0.162)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
141 (0.094)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
142 (0.095)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=148'
143 (0.330)
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 = '0' AND cp.path_id = '149'
144 (0.159)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
145 (0.093)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
146 (0.085)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=149'
147 (0.312)
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 = '0' AND cp.path_id = '151'
148 (0.161)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
149 (0.093)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
150 (0.086)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=151'
151 (0.311)
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 = '0' AND cp.path_id = '156'
152 (0.163)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
153 (0.092)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
154 (0.088)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=156'
155 (0.147)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
156 (0.088)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=41'
157 (1.139)
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 = '37' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
158 (0.169)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
159 (0.092)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=37'
160 (1.247)
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 = '38' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
161 (0.380)
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 = '0' AND cp.path_id = '108'
162 (0.162)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
163 (0.094)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=38'
164 (0.076)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=108'
165 (0.329)
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 = '0' AND cp.path_id = '110'
166 (0.181)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
167 (0.093)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=38'
168 (0.076)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=110'
169 (0.325)
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 = '0' AND cp.path_id = '113'
170 (0.161)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
171 (0.097)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=38'
172 (0.077)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=113'
173 (0.317)
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 = '0' AND cp.path_id = '109'
174 (0.161)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
175 (0.093)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=38'
176 (0.075)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=109'
177 (0.332)
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 = '0' AND cp.path_id = '111'
178 (0.161)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
179 (0.092)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=38'
180 (0.075)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=111'
181 (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 = '0' AND cp.path_id = '112'
182 (0.166)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
183 (0.089)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=38'
184 (0.077)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=112'
185 (0.305)
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 = '0' AND cp.path_id = '67'
186 (0.161)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
187 (0.089)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=38'
188 (0.092)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=67'
189 (0.341)
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 = '0' AND cp.path_id = '119'
190 (0.161)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
191 (0.093)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=38'
192 (0.078)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=119'
193 (0.313)
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 = '0' AND cp.path_id = '154'
194 (0.165)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
195 (0.095)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=38'
196 (0.087)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=154'
197 (0.146)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
198 (0.087)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=38'
199 (1.135)
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 = '36' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
200 (0.165)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
201 (0.093)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=36'
202 (1.129)
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 = '62' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
203 (0.174)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
204 (0.096)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=62'
205 (1.198)
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 = '117' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
206 (0.386)
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 = '0' AND cp.path_id = '130'
207 (0.164)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
208 (0.084)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=117'
209 (0.081)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=130'
210 (0.320)
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 = '0' AND cp.path_id = '158'
211 (0.162)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
212 (0.082)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=117'
213 (0.096)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=158'
214 (0.426)
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 = '0' AND cp.path_id = '139'
215 (0.162)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
216 (0.078)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=117'
217 (0.083)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=139'
218 (0.348)
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 = '0' AND cp.path_id = '118'
219 (0.161)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
220 (0.083)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=117'
221 (0.077)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=118'
222 (0.382)
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 = '0' AND cp.path_id = '136'
223 (0.166)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
224 (0.082)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=117'
225 (0.082)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=136'
226 (0.146)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
227 (0.078)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=117'
228 (1.180)
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 = '42' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
229 (0.337)
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 = '0' AND cp.path_id = '142'
230 (0.164)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
231 (0.094)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=42'
232 (0.086)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=142'
233 (0.344)
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 = '0' AND cp.path_id = '81'
234 (0.162)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
235 (0.098)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=42'
236 (0.091)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=81'
237 (0.146)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
238 (0.089)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=42'
239 (1.239)
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 = '35' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
240 (0.370)
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 = '0' AND cp.path_id = '45'
241 (0.165)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
242 (0.093)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=35'
243 (0.090)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=45'
244 (0.344)
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 = '0' AND cp.path_id = '44'
245 (0.163)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
246 (0.097)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=35'
247 (0.090)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=44'
248 (0.311)
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 = '0' AND cp.path_id = '46'
249 (0.162)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
250 (0.088)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=35'
251 (0.090)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=46'
252 (0.330)
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 = '0' AND cp.path_id = '144'
253 (0.162)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
254 (0.089)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=35'
255 (0.084)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=144'
256 (0.367)
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 = '0' AND cp.path_id = '146'
257 (0.171)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
258 (0.091)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=35'
259 (0.084)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=146'
260 (0.317)
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 = '0' AND cp.path_id = '147'
261 (0.162)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
262 (0.087)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=35'
263 (0.083)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=147'
264 (0.153)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'product/category'
265 (0.088)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'category_id=35'
266 (0.151)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'common/language/language'
267 (0.170)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'common/home'
268 (0.162)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'common/currency/currency'
269 (0.169)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'common/home'
270 (0.112)
SELECT *
FROM oc2_cart
WHERE customer_id = '0' AND session_id = 'f19a1cb557e7ba70f13683b4c6769f7c'
271 (0.067)
SELECT *
FROM oc2_extension
WHERE `type` = 'total'
272 (0.096)
SELECT *
FROM oc2_cart
WHERE customer_id = '0' AND session_id = 'f19a1cb557e7ba70f13683b4c6769f7c'
273 (0.086)
SELECT *
FROM oc2_cart
WHERE customer_id = '0' AND session_id = 'f19a1cb557e7ba70f13683b4c6769f7c'
274 (0.111)
SELECT *
FROM oc2_cart
WHERE customer_id = '0' AND session_id = 'f19a1cb557e7ba70f13683b4c6769f7c'
275 (0.109)
SELECT *
FROM oc2_cart
WHERE customer_id = '0' AND session_id = 'f19a1cb557e7ba70f13683b4c6769f7c'
276 (0.180)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'checkout/cart'
277 (0.181)
SELECT *
FROM oc2_url_alias
WHERE `query` = 'route=0' OR `query` = 'checkout/checkout'