1 (0.392)
SELECT *
FROM store
WHERE store_id = 0
/home/stereoplanet/public_html/index.php:112
2 (2.151)
SELECT *
FROM setting
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/stereoplanet/public_html/index.php:122
3 (0.300)
SELECT *
FROM language
WHERE status = '1'
/home/stereoplanet/public_html/index.php:203
4 (0.229)
SELECT *
FROM currency
/home/stereoplanet/public_html/system/library/currency.php:13
5 (0.317)
SELECT *
FROM weight_class wc
LEFT JOIN weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '2'
/home/stereoplanet/public_html/system/library/weight.php:9
6 (0.273)
SELECT *
FROM length_class mc
LEFT JOIN length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '2'
/home/stereoplanet/public_html/system/library/length.php:9
7 (0.289)
SELECT *
FROM url_alias
WHERE keyword = 'cabluri'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:55
8 (0.391)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '14' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:4
9 (0.258)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
10 (0.138)
SELECT DISTINCT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.category_id = '14' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:4
11 (0.705)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '14' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/stereoplanet/public_html/catalog/model/catalog/category.php:10
12 (0.154)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
13 (0.130)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=248'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
14 (0.120)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
15 (0.141)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=261'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
16 (0.119)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
17 (0.128)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=255'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
18 (0.124)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
19 (0.133)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=268'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
20 (0.124)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
21 (0.173)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=516'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
22 (0.118)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
23 (0.131)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=249'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
24 (0.119)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
25 (0.137)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=262'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
26 (0.139)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
27 (0.133)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=259'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
28 (0.132)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
29 (0.133)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=271'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
30 (0.123)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
31 (0.131)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=269'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
32 (0.119)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
33 (0.157)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=487'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
34 (0.140)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
35 (0.130)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=272'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
36 (0.128)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
37 (0.132)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=273'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
38 (0.118)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
39 (0.131)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=256'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
40 (0.131)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
41 (0.152)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=486'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
42 (0.127)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
43 (0.134)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=263'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
44 (0.123)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
45 (0.146)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=434'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
46 (0.135)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
47 (0.225)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=435'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
48 (0.198)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
49 (0.210)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=278'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
50 (0.191)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
51 (0.221)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=446'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
52 (0.187)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
53 (0.216)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=251'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
54 (0.190)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
55 (0.424)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=252'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
56 (0.193)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
57 (0.199)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=250'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
58 (0.132)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
59 (0.160)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=510'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
60 (0.128)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
61 (0.174)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=513'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
62 (0.127)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
63 (0.155)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=462'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
64 (0.129)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
65 (0.168)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=463'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
66 (0.156)
SELECT category_id
FROM category
WHERE parent_id = '14'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
67 (0.129)
SELECT category_id
FROM category
WHERE parent_id = '510'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
68 (0.096)
SELECT category_id
FROM category
WHERE parent_id = '450'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
69 (0.097)
SELECT category_id
FROM category
WHERE parent_id = '451'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
70 (0.069)
SELECT category_id
FROM category
WHERE parent_id = '452'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
71 (0.094)
SELECT category_id
FROM category
WHERE parent_id = '453'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
72 (0.082)
SELECT category_id
FROM category
WHERE parent_id = '455'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
73 (0.064)
SELECT category_id
FROM category
WHERE parent_id = '456'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
74 (0.061)
SELECT category_id
FROM category
WHERE parent_id = '457'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
75 (0.077)
SELECT category_id
FROM category
WHERE parent_id = '458'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
76 (0.069)
SELECT category_id
FROM category
WHERE parent_id = '459'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
77 (0.058)
SELECT category_id
FROM category
WHERE parent_id = '460'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
78 (0.060)
SELECT category_id
FROM category
WHERE parent_id = '461'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
79 (0.059)
SELECT category_id
FROM category
WHERE parent_id = '464'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
80 (0.068)
SELECT category_id
FROM category
WHERE parent_id = '491'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
81 (0.069)
SELECT category_id
FROM category
WHERE parent_id = '248'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
82 (0.061)
SELECT category_id
FROM category
WHERE parent_id = '328'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
83 (0.059)
SELECT category_id
FROM category
WHERE parent_id = '330'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
84 (0.058)
SELECT category_id
FROM category
WHERE parent_id = '331'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
85 (0.067)
SELECT category_id
FROM category
WHERE parent_id = '261'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
86 (0.061)
SELECT category_id
FROM category
WHERE parent_id = '332'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
87 (0.058)
SELECT category_id
FROM category
WHERE parent_id = '333'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
88 (0.059)
SELECT category_id
FROM category
WHERE parent_id = '334'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
89 (0.067)
SELECT category_id
FROM category
WHERE parent_id = '255'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
90 (0.060)
SELECT category_id
FROM category
WHERE parent_id = '335'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
91 (0.058)
SELECT category_id
FROM category
WHERE parent_id = '336'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
92 (0.057)
SELECT category_id
FROM category
WHERE parent_id = '337'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
93 (0.057)
SELECT category_id
FROM category
WHERE parent_id = '268'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
94 (0.065)
SELECT category_id
FROM category
WHERE parent_id = '249'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
95 (0.061)
SELECT category_id
FROM category
WHERE parent_id = '338'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
96 (0.060)
SELECT category_id
FROM category
WHERE parent_id = '339'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
97 (0.073)
SELECT category_id
FROM category
WHERE parent_id = '262'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
98 (0.060)
SELECT category_id
FROM category
WHERE parent_id = '340'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
99 (0.058)
SELECT category_id
FROM category
WHERE parent_id = '341'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
100 (0.058)
SELECT category_id
FROM category
WHERE parent_id = '259'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
101 (0.065)
SELECT category_id
FROM category
WHERE parent_id = '271'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
102 (0.059)
SELECT category_id
FROM category
WHERE parent_id = '269'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
103 (0.057)
SELECT category_id
FROM category
WHERE parent_id = '272'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
104 (0.057)
SELECT category_id
FROM category
WHERE parent_id = '273'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
105 (0.057)
SELECT category_id
FROM category
WHERE parent_id = '256'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
106 (0.056)
SELECT category_id
FROM category
WHERE parent_id = '263'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
107 (0.058)
SELECT category_id
FROM category
WHERE parent_id = '278'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
108 (0.067)
SELECT category_id
FROM category
WHERE parent_id = '251'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
109 (0.061)
SELECT category_id
FROM category
WHERE parent_id = '342'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
110 (0.060)
SELECT category_id
FROM category
WHERE parent_id = '343'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
111 (0.066)
SELECT category_id
FROM category
WHERE parent_id = '344'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
112 (0.059)
SELECT category_id
FROM category
WHERE parent_id = '252'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
113 (0.057)
SELECT category_id
FROM category
WHERE parent_id = '250'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
114 (0.064)
SELECT category_id
FROM category
WHERE parent_id = '516'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
115 (0.064)
SELECT category_id
FROM category
WHERE parent_id = '434'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
116 (0.059)
SELECT category_id
FROM category
WHERE parent_id = '435'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
117 (0.058)
SELECT category_id
FROM category
WHERE parent_id = '446'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
118 (0.059)
SELECT category_id
FROM category
WHERE parent_id = '462'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
119 (0.058)
SELECT category_id
FROM category
WHERE parent_id = '463'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
120 (0.063)
SELECT category_id
FROM category
WHERE parent_id = '486'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
121 (0.062)
SELECT category_id
FROM category
WHERE parent_id = '487'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
122 (0.059)
SELECT category_id
FROM category
WHERE parent_id = '513'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
123 (37.043)
SELECT COUNT(DISTINCT p2c.product_id) AS total
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id) AND p2c.category_id IN (14, 342, 343, 344, 340, 341, 338, 339, 335, 336, 337, 332, 333, 334, 328, 330, 331, 450, 451, 452, 453, 455, 456, 457, 458, 459, 460, 461, 464, 491, 510, 248, 261, 255, 268, 249, 262, 259, 271, 269, 272, 273, 256, 263, 278, 251, 252, 250, 516, 434, 435, 446, 462, 463, 486, 487, 513)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:2159
124 (0.279)
SELECT category_id
FROM category
WHERE parent_id = '14'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
125 (0.141)
SELECT category_id
FROM category
WHERE parent_id = '510'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
126 (0.087)
SELECT category_id
FROM category
WHERE parent_id = '450'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
127 (0.078)
SELECT category_id
FROM category
WHERE parent_id = '451'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
128 (0.077)
SELECT category_id
FROM category
WHERE parent_id = '452'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
129 (0.077)
SELECT category_id
FROM category
WHERE parent_id = '453'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
130 (0.078)
SELECT category_id
FROM category
WHERE parent_id = '455'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
131 (0.072)
SELECT category_id
FROM category
WHERE parent_id = '456'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
132 (0.110)
SELECT category_id
FROM category
WHERE parent_id = '457'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
133 (0.080)
SELECT category_id
FROM category
WHERE parent_id = '458'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
134 (0.074)
SELECT category_id
FROM category
WHERE parent_id = '459'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
135 (0.073)
SELECT category_id
FROM category
WHERE parent_id = '460'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
136 (0.081)
SELECT category_id
FROM category
WHERE parent_id = '461'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
137 (0.078)
SELECT category_id
FROM category
WHERE parent_id = '464'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
138 (0.206)
SELECT category_id
FROM category
WHERE parent_id = '491'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
139 (0.120)
SELECT category_id
FROM category
WHERE parent_id = '248'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
140 (0.088)
SELECT category_id
FROM category
WHERE parent_id = '328'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
141 (0.085)
SELECT category_id
FROM category
WHERE parent_id = '330'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
142 (0.081)
SELECT category_id
FROM category
WHERE parent_id = '331'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
143 (0.099)
SELECT category_id
FROM category
WHERE parent_id = '261'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
144 (0.088)
SELECT category_id
FROM category
WHERE parent_id = '332'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
145 (0.091)
SELECT category_id
FROM category
WHERE parent_id = '333'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
146 (0.078)
SELECT category_id
FROM category
WHERE parent_id = '334'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
147 (0.092)
SELECT category_id
FROM category
WHERE parent_id = '255'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
148 (0.082)
SELECT category_id
FROM category
WHERE parent_id = '335'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
149 (0.072)
SELECT category_id
FROM category
WHERE parent_id = '336'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
150 (0.076)
SELECT category_id
FROM category
WHERE parent_id = '337'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
151 (0.072)
SELECT category_id
FROM category
WHERE parent_id = '268'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
152 (0.082)
SELECT category_id
FROM category
WHERE parent_id = '249'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
153 (0.082)
SELECT category_id
FROM category
WHERE parent_id = '338'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
154 (0.079)
SELECT category_id
FROM category
WHERE parent_id = '339'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
155 (0.081)
SELECT category_id
FROM category
WHERE parent_id = '262'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
156 (0.080)
SELECT category_id
FROM category
WHERE parent_id = '340'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
157 (0.072)
SELECT category_id
FROM category
WHERE parent_id = '341'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
158 (0.080)
SELECT category_id
FROM category
WHERE parent_id = '259'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
159 (0.081)
SELECT category_id
FROM category
WHERE parent_id = '271'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
160 (0.076)
SELECT category_id
FROM category
WHERE parent_id = '269'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
161 (0.074)
SELECT category_id
FROM category
WHERE parent_id = '272'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
162 (0.075)
SELECT category_id
FROM category
WHERE parent_id = '273'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
163 (0.071)
SELECT category_id
FROM category
WHERE parent_id = '256'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
164 (0.077)
SELECT category_id
FROM category
WHERE parent_id = '263'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
165 (0.082)
SELECT category_id
FROM category
WHERE parent_id = '278'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
166 (0.094)
SELECT category_id
FROM category
WHERE parent_id = '251'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
167 (0.079)
SELECT category_id
FROM category
WHERE parent_id = '342'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
168 (0.097)
SELECT category_id
FROM category
WHERE parent_id = '343'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
169 (0.078)
SELECT category_id
FROM category
WHERE parent_id = '344'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
170 (0.081)
SELECT category_id
FROM category
WHERE parent_id = '252'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
171 (0.084)
SELECT category_id
FROM category
WHERE parent_id = '250'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
172 (0.085)
SELECT category_id
FROM category
WHERE parent_id = '516'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
173 (0.077)
SELECT category_id
FROM category
WHERE parent_id = '434'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
174 (0.077)
SELECT category_id
FROM category
WHERE parent_id = '435'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
175 (0.071)
SELECT category_id
FROM category
WHERE parent_id = '446'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
176 (0.072)
SELECT category_id
FROM category
WHERE parent_id = '462'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
177 (0.070)
SELECT category_id
FROM category
WHERE parent_id = '463'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
178 (0.071)
SELECT category_id
FROM category
WHERE parent_id = '486'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
179 (0.071)
SELECT category_id
FROM category
WHERE parent_id = '487'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
180 (0.074)
SELECT category_id
FROM category
WHERE parent_id = '513'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:18
181 (60.690)
SELECT p.product_id,
(SELECT AVG(rating) AS total
FROM review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, m.name as manufacturername
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
LEFT JOIN product_to_category p2c ON (p.product_id = p2c.product_id)
WHERE pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id IN (14, 342, 343, 344, 340, 341, 338, 339, 335, 336, 337, 332, 333, 334, 328, 330, 331, 450, 451, 452, 453, 455, 456, 457, 458, 459, 460, 461, 464, 491, 510, 248, 261, 255, 268, 249, 262, 259, 271, 269, 272, 273, 256, 263, 278, 251, 252, 250, 516, 434, 435, 446, 462, 463, 486, 487, 513) GROUP BY p.product_id
ORDER BY p.price ASC, LCASE(pd.name) ASC LIMIT 192,12
/home/stereoplanet/public_html/catalog/model/catalog/product.php:587
182 (1.626)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty,
(SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '10798' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:145
183 (1.432)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty,
(SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '10517' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:145
184 (1.445)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty,
(SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '10523' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:145
185 (1.369)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty,
(SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '9637' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:145
186 (1.368)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty,
(SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '9784' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:145
187 (1.320)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty,
(SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11173' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:145
188 (1.423)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty,
(SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11234' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:145
189 (1.309)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty,
(SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '9797' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:145
190 (1.340)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty,
(SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11525' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:145
191 (1.362)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty,
(SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11160' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:145
192 (1.335)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty,
(SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '12226' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:145
193 (1.356)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, p.warranty,
(SELECT price
FROM 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 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 product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '2') AS stock_status, (SELECT wcd.unit
FROM 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 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 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 review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM product p
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '11183' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/product.php:145
194 (4.320)
SELECT IFNULL(COUNT(*),0) AS total
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE r.show_bottom=1 and p.product_id = '10798' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'
/home/stereoplanet/public_html/catalog/model/catalog/review_award.php:73
195 (0.153)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
196 (0.130)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=10798'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
197 (4.214)
SELECT IFNULL(COUNT(*),0) AS total
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE r.show_bottom=1 and p.product_id = '10517' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'
/home/stereoplanet/public_html/catalog/model/catalog/review_award.php:73
198 (0.135)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
199 (0.136)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=10517'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
200 (4.268)
SELECT IFNULL(COUNT(*),0) AS total
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE r.show_bottom=1 and p.product_id = '10523' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'
/home/stereoplanet/public_html/catalog/model/catalog/review_award.php:73
201 (0.134)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
202 (0.125)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=10523'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
203 (0.246)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN 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 = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC
/home/stereoplanet/public_html/system/library/tax.php:91
204 (0.185)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN 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 = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC
/home/stereoplanet/public_html/system/library/tax.php:119
205 (4.102)
SELECT IFNULL(COUNT(*),0) AS total
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE r.show_bottom=1 and p.product_id = '9637' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'
/home/stereoplanet/public_html/catalog/model/catalog/review_award.php:73
206 (0.138)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
207 (0.143)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=9637'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
208 (4.232)
SELECT IFNULL(COUNT(*),0) AS total
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE r.show_bottom=1 and p.product_id = '9784' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'
/home/stereoplanet/public_html/catalog/model/catalog/review_award.php:73
209 (0.149)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
210 (0.145)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=9784'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
211 (4.150)
SELECT IFNULL(COUNT(*),0) AS total
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE r.show_bottom=1 and p.product_id = '11173' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'
/home/stereoplanet/public_html/catalog/model/catalog/review_award.php:73
212 (0.132)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
213 (0.176)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=11173'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
214 (4.240)
SELECT IFNULL(COUNT(*),0) AS total
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE r.show_bottom=1 and p.product_id = '11234' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'
/home/stereoplanet/public_html/catalog/model/catalog/review_award.php:73
215 (0.129)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
216 (0.131)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=11234'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
217 (4.224)
SELECT IFNULL(COUNT(*),0) AS total
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE r.show_bottom=1 and p.product_id = '9797' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'
/home/stereoplanet/public_html/catalog/model/catalog/review_award.php:73
218 (0.140)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
219 (0.139)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=9797'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
220 (4.289)
SELECT IFNULL(COUNT(*),0) AS total
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE r.show_bottom=1 and p.product_id = '11525' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'
/home/stereoplanet/public_html/catalog/model/catalog/review_award.php:73
221 (0.139)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
222 (0.151)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=11525'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
223 (4.184)
SELECT IFNULL(COUNT(*),0) AS total
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE r.show_bottom=1 and p.product_id = '11160' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'
/home/stereoplanet/public_html/catalog/model/catalog/review_award.php:73
224 (0.134)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
225 (0.163)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=11160'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
226 (0.207)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN 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 = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC
/home/stereoplanet/public_html/system/library/tax.php:91
227 (0.194)
SELECT tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM tax_rule tr1
LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN 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 = '175' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '2688')
ORDER BY tr1.priority ASC
/home/stereoplanet/public_html/system/library/tax.php:119
228 (4.149)
SELECT IFNULL(COUNT(*),0) AS total
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE r.show_bottom=1 and p.product_id = '12226' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'
/home/stereoplanet/public_html/catalog/model/catalog/review_award.php:73
229 (0.133)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
230 (0.168)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=12226'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
231 (4.270)
SELECT IFNULL(COUNT(*),0) AS total
FROM review_awards r
LEFT JOIN product_review_awards pra ON (pra.review_awards_id = r.review_id)
LEFT JOIN product p ON (pra.product_id = p.product_id)
LEFT JOIN product_description pd ON (p.product_id = pd.product_id)
WHERE r.show_bottom=1 and p.product_id = '11183' AND p.date_available <= NOW() AND p.status = '1' AND r.status = '1' AND pd.language_id = '2'
/home/stereoplanet/public_html/catalog/model/catalog/review_award.php:73
232 (0.138)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
233 (0.163)
SELECT *
FROM url_alias
WHERE `query` = 'product_id=11183'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
234 (0.116)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
235 (0.138)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
236 (0.119)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
237 (0.120)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
238 (0.118)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
239 (0.130)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
240 (0.125)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
241 (0.114)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
242 (0.109)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
243 (0.129)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
244 (0.115)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
245 (0.110)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
246 (0.122)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
247 (0.127)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
248 (0.134)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
249 (0.114)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
250 (0.111)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
251 (0.108)
SELECT *
FROM category_to_layout
WHERE category_id = '14' AND store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:34
252 (0.135)
SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/home/stereoplanet/public_html/catalog/model/design/layout.php:4
253 (0.185)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
254 (0.550)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN 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/stereoplanet/public_html/catalog/model/catalog/category.php:10
255 (0.266)
SELECT *
FROM banner_image bi
LEFT JOIN 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, bid.title ASC
/home/stereoplanet/public_html/catalog/model/design/banner.php:5
256 (0.150)
CREATE TABLE IF NOT EXISTS subscribe (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`email_id` varchar(225) NOT NULL,
`name` varchar(225) NOT NULL,
`option1` varchar(225) NOT NULL,
`option2` varchar(225) NOT NULL,
`option3` varchar(225) NOT NULL,
`option4` varchar(225) NOT NULL,
`option5` varchar(225) NOT NULL,
`option6` varchar(225) NOT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `Index_2` (`email_id`)
) ENGINE=InnoDB DEFAULT CHARSET=utf8 ROW_FORMAT=DYNAMIC;
/home/stereoplanet/public_html/catalog/model/account/newslettersubscribe.php:46
257 (0.114)
SELECT *
FROM category_to_layout
WHERE category_id = '14' AND store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:34
258 (0.115)
SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/home/stereoplanet/public_html/catalog/model/design/layout.php:4
259 (0.144)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
260 (0.069)
SELECT *
FROM category_to_layout
WHERE category_id = '14' AND store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:34
261 (0.085)
SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/home/stereoplanet/public_html/catalog/model/design/layout.php:4
262 (0.089)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
263 (0.205)
SELECT category_id
FROM category
WHERE category_id = 14 or parent_id = 14
/home/stereoplanet/public_html/catalog/model/filters/filters.php:114
264 (44.949)
SELECT distinct(M.manufacturer_id), M.name, M.image
from product P
join product_to_category PTC
on PTC.product_id=P.product_id
join manufacturer M
on M.manufacturer_id = P.manufacturer_id
where (category_id IN( SELECT category_id
FROM category
WHERE category_id = 14 or parent_id = 14) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 14 or parent_id = 14) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 510 or parent_id = 510) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 248 or parent_id = 248) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 261 or parent_id = 261) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 255 or parent_id = 255) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 268 or parent_id = 268) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 249 or parent_id = 249) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 262 or parent_id = 262) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 259 or parent_id = 259) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 271 or parent_id = 271) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 269 or parent_id = 269) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 272 or parent_id = 272) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 273 or parent_id = 273) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 256 or parent_id = 256) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 263 or parent_id = 263) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 278 or parent_id = 278) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 251 or parent_id = 251) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 252 or parent_id = 252) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 250 or parent_id = 250) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 516 or parent_id = 516) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 434 or parent_id = 434) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 435 or parent_id = 435) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 446 or parent_id = 446) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 462 or parent_id = 462) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 463 or parent_id = 463) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 486 or parent_id = 486) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 487 or parent_id = 487) OR category_id IN( SELECT category_id
FROM category
WHERE category_id = 513 or parent_id = 513)) AND P.status = 1 AND M.status = 1
ORDER BY M.name ASC
/home/stereoplanet/public_html/catalog/model/filters/filters.php:123
265 (0.215)
SELECT PO.option_id, OD.name as parent_option, OVD.option_value_id as child_id, OVD.name as child_name
FROM
product_option PO
join option_description OD
on PO.option_id = OD.option_id
join option_value_description OVD
on OVD.option_id = PO.option_id
join product_to_category PTC
on PTC.product_id = PO.product_id
join product P
on P.product_id = PO.product_id
AND P.status = 1
where PTC.category_id IN( SELECT category_id
FROM category
WHERE category_id = 14 or parent_id = 14) group by OD.name,OVD.name
/home/stereoplanet/public_html/catalog/model/filters/filters.php:71
266 (4.396)
SELECT round(min(price)) as min, round(max(price)) as max
FROM product P
join product_to_category POC
on POC.product_id = P.product_id
where POC.category_id IN( SELECT category_id
FROM category
WHERE category_id = 14 or parent_id = 14) AND P.status = 1
/home/stereoplanet/public_html/catalog/model/filters/filters.php:15
267 (0.122)
SELECT *
FROM category_to_layout
WHERE category_id = '14' AND store_id = '0'
/home/stereoplanet/public_html/catalog/model/catalog/category.php:34
268 (0.118)
SELECT *
FROM layout_route
WHERE 'product/category' LIKE CONCAT(route, '%') AND store_id = '0'
ORDER BY route ASC LIMIT 1
/home/stereoplanet/public_html/catalog/model/design/layout.php:4
269 (0.138)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
270 (0.137)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
271 (4.422)
SELECT *
FROM banner_image bi
LEFT JOIN banner_image_description bid ON ( bi.banner_image_id = bid.banner_image_id )
LEFT JOIN (
SELECT `manufacturer_id` , CONCAT( 'index.php?route=product/manufacturer/info&manufacturer_id=', manufacturer.manufacturer_id ) AS manlink, CONCAT( 'manufacturer_id=', manufacturer.manufacturer_id ) AS manquery
FROM `manufacturer`
) AS tmpman ON ( tmpman.manlink = bi.link )
LEFT JOIN url_alias ua ON ( tmpman.manquery = ua.query )
WHERE bi.banner_id = '8'
AND bid.language_id = '2'
ORDER BY bi.sort_order ASC , bid.title ASC
/home/stereoplanet/public_html/catalog/model/design/banner.php:22
272 (0.629)
SELECT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN 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 CAST(i.sort_order AS CHAR), LCASE(id.title) ASC
/home/stereoplanet/public_html/catalog/model/catalog/information.php:31
273 (0.176)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=23'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
274 (0.162)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=5'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
275 (0.159)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=4'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
276 (0.159)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=25'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
277 (0.148)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=6'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
278 (0.146)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=3'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
279 (0.794)
SELECT *
FROM category c
LEFT JOIN category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN 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/stereoplanet/public_html/catalog/model/catalog/category.php:10
280 (0.213)
SELECT *
FROM extension
WHERE `type` = 'module'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
281 (0.874)
SELECT *
FROM information i
LEFT JOIN information_description id ON (i.information_id = id.information_id)
LEFT JOIN 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 CAST(i.sort_order AS CHAR), LCASE(id.title) ASC
/home/stereoplanet/public_html/catalog/model/catalog/information.php:31
282 (0.327)
SELECT *
from url_alias
where query='information_id=23' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
283 (0.287)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=23'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
284 (0.256)
SELECT *
from url_alias
where query='information_id=5' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
285 (0.244)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=5'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
286 (0.263)
SELECT *
from url_alias
where query='information_id=4' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
287 (0.256)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=4'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
288 (0.262)
SELECT *
from url_alias
where query='information_id=25' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
289 (0.248)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=25'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
290 (0.266)
SELECT *
from url_alias
where query='information_id=6' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
291 (0.245)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=6'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
292 (0.255)
SELECT *
from url_alias
where query='information_id=3' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
293 (0.265)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=3'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
294 (0.259)
SELECT *
from url_alias
where query='information_id=7' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
295 (0.274)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=7'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
296 (0.290)
SELECT *
from url_alias
where query='information_id=24' limit 1;
/home/stereoplanet/public_html/catalog/model/catalog/information.php:23
297 (0.248)
SELECT *
FROM url_alias
WHERE `query` = 'information_id=24'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:132
298 (0.205)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
299 (0.190)
SELECT *
FROM url_alias
WHERE `query` = 'category_id=14'
/home/stereoplanet/public_html/catalog/controller/common/seo_url.php:143
300 (0.201)
SELECT *
FROM extension
WHERE `type` = 'total'
/home/stereoplanet/public_html/catalog/model/setting/extension.php:4
301 (0.131)
SELECT SUM(amount) AS total
FROM customer_transaction
WHERE customer_id = '0'
/home/stereoplanet/public_html/system/library/customer.php:201