Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/library/db/mysqli.php on line 21Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/library/db/mysqli.php on line 29Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/library/db/mysqli.php on line 21Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/library/db/mysqli.php on line 29Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/engine/action.php on line 61Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/engine/action.php on line 88Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/library/db/mysqli.php on line 21Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/library/db/mysqli.php on line 29Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/engine/action.php on line 61Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/engine/action.php on line 88Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/library/db/mysqli.php on line 21Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/library/db/mysqli.php on line 29Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/engine/action.php on line 61Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/engine/action.php on line 88Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/library/db/mysqli.php on line 21Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/library/db/mysqli.php on line 29Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/library/db/mysqli.php on line 21Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/library/db/mysqli.php on line 29Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/library/db/mysqli.php on line 21Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/library/db/mysqli.php on line 29Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/library/db/mysqli.php on line 21Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/library/db/mysqli.php on line 29Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/library/db/mysqli.php on line 21Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/library/db/mysqli.php on line 29Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/library/db/mysqli.php on line 21Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/library/db/mysqli.php on line 29Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/engine/action.php on line 61Notice: Undefined index: OCSESSID in /var/www/homium_ua/data/storage/modification/system/engine/action.php on line 88 Квартиры в Святом Власе, Болгария

Квартиры в Святом Власе, Болгария

Найдено 41 - 60 из 231

Двухкомнатная квартира в Каприз
Двухкомнатная квартира в Каприз
Двухкомнатная квартира в Каприз
Двухкомнатная квартира в Каприз
200 m
2
2
135 m²
Двухкомнатная квартира в Каса дел Мар
Двухкомнатная квартира в Каса дел Мар
Двухкомнатная квартира в Каса дел Мар
Двухкомнатная квартира в Каса дел Мар
300 m
2
1
67 m²
Двухкомнатная квартира в комплексе Топ
Двухкомнатная квартира в комплексе Топ
Двухкомнатная квартира в комплексе Топ
Двухкомнатная квартира в комплексе Топ
50 m
2
1
65 m²
Двухкомнатная квартира в Корал Бич
Двухкомнатная квартира в Корал Бич
Двухкомнатная квартира в Корал Бич
Двухкомнатная квартира в Корал Бич
50 m
2
1
77 m²

Ищете квартиру в Святом Власе, Болгария?

Позвоните нам — и мы быстро подберем лучшие варианты по вашим критериям!

Двухкомнатная квартира в Краун Форт Клуб
Двухкомнатная квартира в Краун Форт Клуб
Двухкомнатная квартира в Краун Форт Клуб
Двухкомнатная квартира в Краун Форт Клуб
300 m
2
1
76 m²
Двухкомнатная квартира в Лазур 1
Двухкомнатная квартира в Лазур 1
Двухкомнатная квартира в Лазур 1
Двухкомнатная квартира в Лазур 1
250 m
2
1
66 m²
Двухкомнатная квартира в Луксор
Двухкомнатная квартира в Луксор
Двухкомнатная квартира в Луксор
Двухкомнатная квартира в Луксор
250 m
2
1
129 m²
Двухкомнатная квартира в Луксор
Двухкомнатная квартира в Луксор
Двухкомнатная квартира в Луксор
Двухкомнатная квартира в Луксор
400 m
2
2
91 m²
Двухкомнатная квартира в Луксор
Двухкомнатная квартира в Луксор
Двухкомнатная квартира в Луксор
Двухкомнатная квартира в Луксор
400 m
2
1
82 m²
Двухкомнатная квартира в Манастира 2
Двухкомнатная квартира в Манастира 2
Двухкомнатная квартира в Манастира 2
Двухкомнатная квартира в Манастира 2
50 m
2
1
62 m²
Двухкомнатная квартира в Марина Парк
Двухкомнатная квартира в Марина Парк
Двухкомнатная квартира в Марина Парк
Двухкомнатная квартира в Марина Парк
200 m
2
1
60 m²
Двухкомнатная квартира в Марина Форт
Двухкомнатная квартира в Марина Форт
Двухкомнатная квартира в Марина Форт
Двухкомнатная квартира в Марина Форт
50 m
2
1
79 m²

Святой Влас, Болгария: подберем вам идеальную квартиру

Мгновенная консультация — звоните или пишите сейчас!

Двухкомнатная квартира в Мерри Мар
Двухкомнатная квартира в Мерри Мар
Двухкомнатная квартира в Мерри Мар
Двухкомнатная квартира в Мерри Мар
200 m
2
1
110 m²
Двухкомнатная квартира в Миллениум 2
Двухкомнатная квартира в Миллениум 2
Двухкомнатная квартира в Миллениум 2
Двухкомнатная квартира в Миллениум 2
150 m
2
1
81 m²
Двухкомнатная квартира в Миллениум 2
Двухкомнатная квартира в Миллениум 2
Двухкомнатная квартира в Миллениум 2
Двухкомнатная квартира в Миллениум 2
150 m
2
1
91 m²
Двухкомнатная квартира в Миллениум 2
Двухкомнатная квартира в Миллениум 2
Двухкомнатная квартира в Миллениум 2
Двухкомнатная квартира в Миллениум 2
150 m
2
1
69 m²
Двухкомнатная квартира в Миллениум 2
Двухкомнатная квартира в Миллениум 2
Двухкомнатная квартира в Миллениум 2
Двухкомнатная квартира в Миллениум 2
150 m
2
1
113 m²
Двухкомнатная квартира в Миллениум 2
Двухкомнатная квартира в Миллениум 2
Двухкомнатная квартира в Миллениум 2
Двухкомнатная квартира в Миллениум 2
200 m
2
1
79 m²
Двухкомнатная квартира в Миллениум 2
Двухкомнатная квартира в Миллениум 2
Двухкомнатная квартира в Миллениум 2
Двухкомнатная квартира в Миллениум 2
150 m
2
1
61 m²
Двухкомнатная квартира в Морской Маяк
Двухкомнатная квартира в Морской Маяк
Двухкомнатная квартира в Морской Маяк
Двухкомнатная квартира в Морской Маяк
200 m
2
1
85 m²
Показано с 41 по 60 из 231 (всего 12 страниц)
+380 97 275 33 33 +380 97 275 33 33 @homium_com 0800 30 23 07 +380 73 275 33 33 +380 95 275 33 33 +380 97 275 33 33
Позвоните
мне
Debug SQL and Controllers
0.3553631306SELECT p.product_id, (SELECT AVG(rating) AS total FROM hm_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating FROM hm_category_path cp, hm_product_to_category p2c, hm_product p, hm_product_description pd WHERE pd.language_id = '1' AND p.status = '1' AND cp.path_id = '440' AND cp.category_id = p2c.category_id AND p2c.product_id = p.product_id AND p.property_type_id='1' AND p.product_id = pd.product_id AND p.property_type_id='1' GROUP BY p.product_id ORDER BY p.parser ASC, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 40,20
0.1294000149SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '84' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.1211268902SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '84' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0987608433DELETE FROM `hm_customer_online` WHERE date_added < '2025-12-04 01:12:53'
0.0777270794SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '195' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0704090595SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '195' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0475862026SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '215' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0424351692SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '215' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0393111706SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '38' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0375609398DELETE FROM `hm_session` WHERE `expire` < '2025-12-04 00:12:51'
0.0333011150SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '55' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0264780521SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '242' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0189659595SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '55' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0171639919SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '242' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0139889717SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '33' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0133650303SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '33' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0132589340SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '33' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0097820759SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '171' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0070350170SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '171' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0058221817SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '271' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0046808720REPLACE INTO `hm_customer_online` SET `ip` = '216.73.216.185', `customer_id` = '0', `url` = 'https://homium.ua/bulgaria/sveti-vlas/apartments/?page=3', `referer` = '', `date_added` = '2025-12-04 02:12:53'
0.0045208931SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '223' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0038509369SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '435' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0036139488SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0036070347SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='1' AND ((p.price >=142500 AND p.price <=262500) OR (p.min_price >=142500 AND p.min_price <=262500) OR (p.max_price >=142500 AND p.max_price <=262500))
0.0035889149SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='1' AND ((p.price >=66500 AND p.price <=105000) OR (p.min_price >=66500 AND p.min_price <=105000) OR (p.max_price >=66500 AND p.max_price <=105000))
0.0035600662SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='1' AND ((p.price >=95000 AND p.price <=157500) OR (p.min_price >=95000 AND p.min_price <=157500) OR (p.max_price >=95000 AND p.max_price <=157500))
0.0035488605SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='1' AND ((p.price >=237500 AND p.price <=525000) OR (p.min_price >=237500 AND p.min_price <=525000) OR (p.max_price >=237500 AND p.max_price <=525000))
0.0034909248SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '271' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0034360886SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='1' AND ((p.price >=475000 AND p.price <=1050000) OR (p.min_price >=475000 AND p.min_price <=1050000) OR (p.max_price >=475000 AND p.max_price <=1050000))
0.0032839775SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='1' AND ((p.price <=73500 AND p.price > 0) OR (p.min_price <=73500 AND p.min_price > 0) OR (p.max_price <=73500 AND p.max_price > 0))
0.0031659603SELECT * FROM `hm_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
0.0029959679SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='3'
0.0029079914SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='6'
0.0029029846SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='4'
0.0028910637SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='5'
0.0028908253SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='8'
0.0028009415SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '2' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0025451183SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='7'
0.0022220612SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0021989346SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='2'
0.0020968914SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '14' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0020499229SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '2' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0020339489SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '14' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0020241737SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='1' AND ((p.area >=110 AND p.area <=160) OR (p.min_area >=110 AND p.min_area <=160) OR (p.max_area >=110 AND p.max_area <=160))
0.0020051003SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='1' AND ((p.price >=950000) OR (p.min_price >=950000) OR (p.max_price >=950000))
0.0019769669SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='1' AND ((p.area >=45 AND p.area <=70) OR (p.min_area >=45 AND p.min_area <=70) OR (p.max_area >=45 AND p.max_area <=70))
0.0019760132SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='1' AND ((p.area >=160 AND p.area <=250) OR (p.min_area >=160 AND p.min_area <=250) OR (p.max_area >=160 AND p.max_area <=250))
0.0019750595SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='1' AND ((p.area >=70 AND p.area <=110) OR (p.min_area >=70 AND p.min_area <=110) OR (p.max_area >=70 AND p.max_area <=110))
0.0019738674SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='1' AND ((p.area <=45 AND p.area > 0) OR (p.min_area <=45 AND p.min_area > 0) OR (p.max_area <=45 AND p.max_area > 0))
0.0019729137SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '209' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0019509792SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='1' AND ((p.area >=400 AND p.area <=700) OR (p.min_area >=400 AND p.min_area <=700) OR (p.max_area >=400 AND p.max_area <=700))
0.0019490719SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='1' AND ((p.area >=250 AND p.area <=400) OR (p.min_area >=250 AND p.min_area <=400) OR (p.max_area >=250 AND p.max_area <=400))
0.0019330978SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0019230843SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id AND p.property_type_id='1' AND ((p.area >=700) OR (p.min_area >=700) OR (p.max_area >=700))
0.0017590523SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '56' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0016601086SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '221' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0013420582SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '56' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0012550354SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '221' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0011239052SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '81' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0010681152SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '53' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0010139942SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '440' AND p.product_id = p2c.product_id
0.0008769035SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '53' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0008149147SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '81' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0007569790SELECT * FROM hm_information i LEFT JOIN hm_information_description id ON (i.information_id = id.information_id) LEFT JOIN hm_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC
0.0007479191SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29063' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0006811619SELECT * FROM hm_information i LEFT JOIN hm_information_description id ON (i.information_id = id.information_id) LEFT JOIN hm_information_to_store i2s ON (i.information_id = i2s.information_id) WHERE id.language_id = '1' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC
0.0006289482SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '170' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0005860329SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29024' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0005810261SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '441' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0005779266SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '439' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0005369186SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28969' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0005180836SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '80' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0005171299SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '100' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0005140305SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28995' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0004990101SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '170' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0004720688SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '435' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004599094SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '190' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0004589558SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29000' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004470348SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29116' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004410744SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '440' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004379749SELECT * FROM hm_product_image WHERE product_id = '32541' ORDER BY sort_order ASC
0.0004329681SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29045' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004320145SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29012' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004320145SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29087' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004289150SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '49184' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004270077SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29127' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004260540SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29079' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004258156SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28973' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004251003SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29027' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004241467SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29032' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004229546SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28958' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004229546SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29111' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004210472SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29019' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004189014SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28985' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004179478SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29064' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004160404SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29084' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004160404SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28965' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004148483SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29090' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004129410SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '438' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0004122257SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29023' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004119873SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29067' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004119873SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29009' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004110336SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29049' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004100800SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29038' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004091263SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29102' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004088879SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29042' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004081726SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29025' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004069805SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28966' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004060268SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29077' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004050732SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28998' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004048347SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '49177' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004041195SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29003' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004041195SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29082' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004038811SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29059' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004038811SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28955' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004038811SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29021' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0004029274SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29040' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003991127SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29097' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003979206SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '49174' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003969669SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28999' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003960133SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29013' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003948212SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29014' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003941059SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28981' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003938675SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '41020' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003929138SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '41019' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003919601SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '49181' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003919601SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29101' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003910065SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28950' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003900528SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28984' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003881454SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '437' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003869534SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29058' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003859997SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28993' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003859997SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29089' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003850460SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '41022' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003819466SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '49178' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003819466SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29125' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003809929SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29001' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003800392SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28951' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003790855SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29113' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003788471SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '49183' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003788471SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29076' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003788471SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29061' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003781319SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29108' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003781319SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29130' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003759861SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29092' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003750324SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29035' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003740788SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28992' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003728867SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29109' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003728867SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28947' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003728867SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29073' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003728867SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29106' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003721714SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28954' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003719330SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '41021' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003709793SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29070' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003709793SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29115' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003700256SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29033' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003690720SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29099' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003690720SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29028' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003690720SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29094' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003690720SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29081' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003688335SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '49172' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003681183SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29105' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003669262SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29065' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003669262SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '436' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003662109SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29047' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003659725SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29029' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003659725SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29034' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003659725SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28989' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003640652SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29078' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003631115SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28968' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003628731SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '41018' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003619194SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29071' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003619194SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28963' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003619194SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28974' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003609657SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28988' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003609657SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28990' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003609657SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29128' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003600121SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29053' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003600121SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29037' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003600121SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28964' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003588200SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29072' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003581047SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28942' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003578663SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29118' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003569126SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29085' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003569126SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28975' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003561974SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29107' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003559589SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28972' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003559589SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29046' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003559589SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29016' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003559589SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29052' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003550053SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29110' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003550053SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '49176' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003530979SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29069' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003528595SELECT * FROM hm_product_image WHERE product_id = '32472' ORDER BY sort_order ASC
0.0003528595SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29123' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003511906SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28987' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003480911SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29044' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003480911SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29026' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003478527SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28944' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003471375SELECT * FROM hm_product_image WHERE product_id = '32536' ORDER BY sort_order ASC
0.0003468990SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28982' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003468990SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28980' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003459454SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29119' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003459454SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29022' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003449917SELECT * FROM hm_product_image WHERE product_id = '32590' ORDER BY sort_order ASC
0.0003440380SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28979' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003440380SELECT * FROM hm_product_image WHERE product_id = '32429' ORDER BY sort_order ASC
0.0003421307SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29083' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003421307SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28967' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003418922SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28949' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003409386SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '80' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0003399849SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29010' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003390312SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28997' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003380775SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, (SELECT AVG(rating) AS total FROM hm_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 hm_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM hm_product p LEFT JOIN hm_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '32586' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0003380775SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29088' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003380775SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29004' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003361702SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29129' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003359318SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28975' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0003359318SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28995' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003359318SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29063' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003340244SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29117' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003337860SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28941' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0003321171SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29075' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0003309250SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29095' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003299713SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29045' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0003287792SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29002' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003280640SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29054' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003280640SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29091' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003259182SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29124' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003249645SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28970' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0003240108SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '49182' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003230572SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29030' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003230572SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28960' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003221035SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29121' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003221035SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28969' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003211498SELECT * FROM `hm_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC
0.0003199577SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '50591' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003180504SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29036' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003149509SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29055' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003139973SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29080' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003139973SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29057' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003130436SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '439' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003120899SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28983' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003111362SELECT * FROM hm_currency WHERE code='EUR'
0.0003099442SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29024' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003080368SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29018' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003080368SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29112' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003070831SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29008' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003068447SELECT * FROM hm_product_image WHERE product_id = '32535' ORDER BY sort_order ASC
0.0003068447SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29114' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003058910SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28941' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003058910SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28970' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003051758SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29056' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003051758SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29104' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003049374SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '438' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003039837SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29005' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003030300SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28959' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003030300SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28956' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003027916SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28955' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0003020763SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28945' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003008842SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28961' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0003001690SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28994' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002999306SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28943' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002989769SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29031' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002980232SELECT * FROM hm_product_image WHERE product_id = '32422' ORDER BY sort_order ASC
0.0002977848SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29041' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002970695SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29007' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002970695SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29062' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002951622SELECT * FROM hm_product_image WHERE product_id = '32444' ORDER BY sort_order ASC
0.0002951622SELECT * FROM hm_product_image WHERE product_id = '32369' ORDER BY sort_order ASC
0.0002939701SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='32577' AND pc.main_category='0' AND cd.category_id=pc.category_id AND cd.language_id='1' AND c.type=0 AND pc.category_id=c.category_id
0.0002930164SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29060' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002920628SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, (SELECT AVG(rating) AS total FROM hm_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 hm_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM hm_product p LEFT JOIN hm_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '32429' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002918243SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '49180' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002880096SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29103' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002870560SELECT * FROM hm_product_image WHERE product_id = '32529' ORDER BY sort_order ASC
0.0002868176SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29011' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002861023SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29035' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002858639SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28996' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002849102SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29039' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002839565SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29132' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002839565SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29060' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002830029SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29112' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002820492SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28971' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002820492SELECT * FROM hm_product_image WHERE product_id = '32389' ORDER BY sort_order ASC
0.0002820492SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, (SELECT AVG(rating) AS total FROM hm_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 hm_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM hm_product p LEFT JOIN hm_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '32577' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002810955SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29120' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002808571SELECT * FROM hm_product_image WHERE product_id = '32577' ORDER BY sort_order ASC
0.0002801418SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28991' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002799034SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28976' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002799034SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29093' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002789497SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29074' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002789497SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28986' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002779961SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29006' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002779961SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '63' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002779961SELECT * FROM hm_product_image WHERE product_id = '32419' ORDER BY sort_order ASC
0.0002768040SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29098' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002758503SELECT * FROM hm_product_image WHERE product_id = '32440' ORDER BY sort_order ASC
0.0002751350SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28957' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002751350SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29090' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002741814SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '441' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002739429SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29048' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002739429SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, (SELECT AVG(rating) AS total FROM hm_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 hm_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM hm_product p LEFT JOIN hm_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '32440' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002729893SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, (SELECT AVG(rating) AS total FROM hm_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 hm_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM hm_product p LEFT JOIN hm_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '32419' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002729893SELECT * FROM hm_product_image WHERE product_id = '32385' ORDER BY sort_order ASC
0.0002729893SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29096' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002720356SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '49175' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002710819SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29086' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002710819SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28962' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002708435SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29131' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002689362SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29043' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002679825SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28948' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002670288SELECT * FROM hm_product_image WHERE product_id = '32466' ORDER BY sort_order ASC
0.0002670288SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, (SELECT AVG(rating) AS total FROM hm_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 hm_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM hm_product p LEFT JOIN hm_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '32444' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002660751SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, (SELECT AVG(rating) AS total FROM hm_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 hm_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM hm_product p LEFT JOIN hm_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '32389' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002660751SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29100' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002651215SELECT * FROM hm_product_image WHERE product_id = '32546' ORDER BY sort_order ASC
0.0002648830SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, (SELECT AVG(rating) AS total FROM hm_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 hm_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM hm_product p LEFT JOIN hm_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '32466' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002639294SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, (SELECT AVG(rating) AS total FROM hm_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 hm_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM hm_product p LEFT JOIN hm_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '32369' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002632141SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28953' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002629757SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28977' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002620220SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '49173' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002620220SELECT * FROM hm_property_type pt, hm_property_type_description ptd WHERE ptd.property_type_id = pt.property_type_id AND ptd.language_id='1' ORDER BY pt.property_type_group DESC, pt.sort_order ASC
0.0002620220SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29019' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002620220SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29068' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002610683SELECT * FROM hm_layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order
0.0002608299SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='32389' AND pc.main_category='0' AND cd.category_id=pc.category_id AND cd.language_id='1' AND c.type=0 AND pc.category_id=c.category_id
0.0002601147SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29122' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002598763SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='32385' AND pc.main_category='0' AND cd.category_id=pc.category_id AND cd.language_id='1' AND c.type=0 AND pc.category_id=c.category_id
0.0002589226SELECT * FROM hm_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
0.0002589226SELECT * FROM hm_weight_class wc LEFT JOIN hm_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1'
0.0002579689SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28946' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002570152SELECT * FROM hm_category_path cp, hm_category_description cd WHERE cp.category_id='440' AND cp.level=0 AND cd.category_id=cp.path_id AND cd.language_id='1'
0.0002570152SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28978' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002570152SELECT * FROM hm_layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order
0.0002570152SELECT * FROM hm_product_image WHERE product_id = '32586' ORDER BY sort_order ASC
0.0002560616SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='32429' AND pc.main_category='0' AND cd.category_id=pc.category_id AND cd.language_id='1' AND c.type=0 AND pc.category_id=c.category_id
0.0002551079SELECT * FROM hm_extension WHERE `type` = 'analytics'
0.0002541542SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29012' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002539158SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='32472' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0002529621SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29075' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002501011SELECT * FROM hm_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
0.0002489090SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, (SELECT AVG(rating) AS total FROM hm_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 hm_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM hm_product p LEFT JOIN hm_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '32541' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002489090SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29020' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002481937SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='32444' AND pc.main_category='0' AND cd.category_id=pc.category_id AND cd.language_id='1' AND c.type=0 AND pc.category_id=c.category_id
0.0002479553SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='32590' AND pc.main_category='0' AND cd.category_id=pc.category_id AND cd.language_id='1' AND c.type=0 AND pc.category_id=c.category_id
0.0002479553SELECT * FROM hm_category_description WHERE category_id='440' AND language_id='1'
0.0002479553SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '74' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002470016SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '15' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002470016SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29095' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002470016SELECT * FROM hm_product_image WHERE product_id = '32589' ORDER BY sort_order ASC
0.0002470016SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, (SELECT AVG(rating) AS total FROM hm_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 hm_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM hm_product p LEFT JOIN hm_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '32546' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002460480SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28951' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002460480SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='32577' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0002450943SELECT * FROM hm_currency WHERE `code`=''
0.0002450943SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29016' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002441406SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, (SELECT AVG(rating) AS total FROM hm_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 hm_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM hm_product p LEFT JOIN hm_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '32529' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002439022SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='32586' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0002429485SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '105' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002429485SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, (SELECT AVG(rating) AS total FROM hm_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 hm_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM hm_product p LEFT JOIN hm_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '32385' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002419949SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29000' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002419949SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, (SELECT AVG(rating) AS total FROM hm_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 hm_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM hm_product p LEFT JOIN hm_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '32422' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002410412SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='32422' AND pc.main_category='0' AND cd.category_id=pc.category_id AND cd.language_id='1' AND c.type=0 AND pc.category_id=c.category_id
0.0002408028SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='32369' AND pc.main_category='0' AND cd.category_id=pc.category_id AND cd.language_id='1' AND c.type=0 AND pc.category_id=c.category_id
0.0002400875SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '28952' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002391338SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29106' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002391338SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='32535' AND pc.main_category='0' AND cd.category_id=pc.category_id AND cd.language_id='1' AND c.type=0 AND pc.category_id=c.category_id
0.0002388954SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29051' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002388954SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='32586' AND pc.main_category='0' AND cd.category_id=pc.category_id AND cd.language_id='1' AND c.type=0 AND pc.category_id=c.category_id
0.0002381802SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29066' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002381802SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '30' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002372265SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='32529' AND pc.main_category='0' AND cd.category_id=pc.category_id AND cd.language_id='1' AND c.type=0 AND pc.category_id=c.category_id
0.0002372265SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '436' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002369881SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '175' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002360344SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29064' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002360344SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, (SELECT AVG(rating) AS total FROM hm_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 hm_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM hm_product p LEFT JOIN hm_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '32536' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002360344SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='32546' AND pc.main_category='0' AND cd.category_id=pc.category_id AND cd.language_id='1' AND c.type=0 AND pc.category_id=c.category_id
0.0002348423SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29083' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002348423SELECT * FROM hm_property_type_description WHERE language_id='1' AND property_type_id='1'
0.0002338886SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='32541' AND pc.main_category='0' AND cd.category_id=pc.category_id AND cd.language_id='1' AND c.type=0 AND pc.category_id=c.category_id
0.0002319813SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='32472' AND pc.main_category='0' AND cd.category_id=pc.category_id AND cd.language_id='1' AND c.type=0 AND pc.category_id=c.category_id
0.0002319813SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='32369' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0002319813SELECT * FROM hm_currency WHERE `code`=''
0.0002319813SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='32589' AND pc.main_category='0' AND cd.category_id=pc.category_id AND cd.language_id='1' AND c.type=0 AND pc.category_id=c.category_id
0.0002310276SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='32512' AND pc.main_category='0' AND cd.category_id=pc.category_id AND cd.language_id='1' AND c.type=0 AND pc.category_id=c.category_id
0.0002298355SELECT c.iso_code_2, cd.* FROM hm_category c, hm_category_description cd WHERE c.category_id='33' AND cd.category_id=c.category_id
0.0002298355SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='32466' AND pc.main_category='0' AND cd.category_id=pc.category_id AND cd.language_id='1' AND c.type=0 AND pc.category_id=c.category_id
0.0002291203SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='32440' AND pc.main_category='0' AND cd.category_id=pc.category_id AND cd.language_id='1' AND c.type=0 AND pc.category_id=c.category_id
0.0002291203SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28973' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002288818SELECT * FROM hm_product_image WHERE product_id = '32512' ORDER BY sort_order ASC
0.0002281666SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29126' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002279282SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='32536' AND pc.main_category='0' AND cd.category_id=pc.category_id AND cd.language_id='1' AND c.type=0 AND pc.category_id=c.category_id
0.0002279282SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28991' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002269745SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28993' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002269745SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29050' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002269745SELECT * FROM hm_layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order
0.0002269745SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29076' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002269745SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29017' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002269745SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28999' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002269745SELECT * FROM hm_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
0.0002260208SELECT * FROM hm_currency WHERE `code`=''
0.0002241135SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29111'
0.0002241135SELECT *, (SELECT count(*) FROM hm_product_to_category p2c WHERE p2c.category_id=c.category_id) AS totals FROM hm_category c, hm_category_description cd WHERE c.parent_id = '29015' AND cd.category_id = c.category_id AND cd.language_id='1' AND c.status=1 ORDER BY totals DESC, c.sort_order ASC, c.filter_order DESC, LCASE(cd.name) ASC
0.0002241135SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28986' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002238750SELECT * FROM hm_currency WHERE `code`=''
0.0002238750SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, (SELECT AVG(rating) AS total FROM hm_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 hm_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM hm_product p LEFT JOIN hm_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '32535' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002231598SELECT * FROM hm_layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order
0.0002210140SELECT * FROM hm_currency WHERE `code`=''
0.0002210140SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '41019' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002191067SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29027' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002191067SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='32419' AND pc.main_category='0' AND cd.category_id=pc.category_id AND cd.language_id='1' AND c.type=0 AND pc.category_id=c.category_id
0.0002188683SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, (SELECT AVG(rating) AS total FROM hm_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 hm_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM hm_product p LEFT JOIN hm_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '32472' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002179146SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29082' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002179146SELECT * FROM hm_currency WHERE `code`=''
0.0002179146SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29025' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002169609SELECT * FROM hm_length_class mc LEFT JOIN hm_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1'
0.0002169609SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='32444' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0002160072SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '132' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002160072SELECT *, c.iso_code_2 iso_code_2 FROM hm_category c, hm_category_path cp WHERE cp.category_id='440' AND c.category_id = cp.path_id AND cp.level=0
0.0002160072SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29097' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002148151SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, (SELECT AVG(rating) AS total FROM hm_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 hm_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM hm_product p LEFT JOIN hm_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '32512' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002140999SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29116' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002140999SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29033' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002138615SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '6' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002138615SELECT * FROM hm_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
0.0002131462SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28981' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002131462SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '189' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002119541SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28968' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002119541SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='32466' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0002119541SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29036' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002110004SELECT * FROM hm_currency WHERE `code`=''
0.0002110004SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29059' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002100468SELECT * FROM hm_currency WHERE code='EUR'
0.0002090931SELECT * FROM hm_currency WHERE `code`=''
0.0002090931SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '222' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002081394SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '41021' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002081394SELECT category_id FROM hm_product_to_category WHERE product_id = '32586' ORDER BY main_category DESC LIMIT 1
0.0002081394SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29049' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002079010SELECT * FROM hm_currency WHERE `code`=''
0.0002079010SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29047' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002071857SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='32529' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0002069473SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='32429' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0002069473SELECT * FROM hm_category_description WHERE language_id='1' AND category_id='33'
0.0002059937SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '437' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002059937SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29008' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002059937SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28965' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002059937SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28966' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002059937SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, (SELECT AVG(rating) AS total FROM hm_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 hm_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM hm_product p LEFT JOIN hm_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '32589' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002050400SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '96' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002050400SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29019'
0.0002050400SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29127' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002048016SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28958' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002040863SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='32440' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0002040863SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '67' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002040863SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29031' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002040863SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29032' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002040863SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='32422' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0002038479SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '139' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002031326SELECT * FROM hm_currency WHERE `code`=''
0.0002031326SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='41020'
0.0002028942SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '72' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002028942SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28983' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002028942SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29018' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002028942SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29076'
0.0002028942SELECT * FROM hm_currency WHERE `code`=''
0.0002028942SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29104' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002019405SELECT * FROM hm_currency WHERE `code`=''
0.0002019405SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29023' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002019405SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29042'
0.0002019405SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '110' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002019405SELECT * FROM hm_currency WHERE `code`=''
0.0002009869SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29109' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002009869SELECT * FROM hm_currency WHERE `code`=''
0.0002009869SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '49184' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002009869SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '57' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002000332SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29131' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002000332SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29102' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0002000332SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='32419' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001990795SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'common/menu_footer'
0.0001990795SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28953' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001990795SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '11' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001990795SELECT * FROM hm_currency WHERE `code`=''
0.0001990795SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='32546' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001988411SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29067' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001981258SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='32589' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001981258SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29084' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001981258SELECT * FROM hm_currency
0.0001978874SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='32536' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001978874SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '41018' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001971722SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '98' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001969337SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='32535' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001969337SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '161' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001959801SELECT * FROM hm_currency WHERE code='EUR'
0.0001959801SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/menu' OR route = 'ru-ru')
0.0001959801SELECT * FROM hm_currency WHERE code='EUR'
0.0001959801SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29003' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001950264SELECT * FROM hm_currency WHERE `code`=''
0.0001940727SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29083'
0.0001940727SELECT * FROM hm_currency WHERE `code`=''
0.0001940727SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '3' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001940727SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='32590' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001938343SELECT * FROM hm_currency WHERE `code`=''
0.0001938343SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '21' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001938343SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29070' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001931190SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29004' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001921654SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '109' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001921654SELECT * FROM hm_currency WHERE `code`=''
0.0001921654SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='32385' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001919270SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '49177' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001919270SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29114' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001919270SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='32541' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001919270SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29062' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001919270SELECT * FROM hm_currency WHERE `code`=''
0.0001912117SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29065' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001909733SELECT * FROM hm_currency WHERE `code`=''
0.0001909733SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29092' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001909733SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29052' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001909733SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='435'
0.0001909733SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29030' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001900196SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
0.0001900196SELECT * FROM hm_currency WHERE `code`=''
0.0001900196SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28968'
0.0001900196SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '220' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001900196SELECT * FROM hm_currency WHERE `code`=''
0.0001900196SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '63' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001897812SELECT * FROM hm_property_type_description WHERE property_type_id='1' AND language_id='1'
0.0001890659SELECT * FROM hm_currency WHERE `code`=''
0.0001890659SELECT * FROM hm_currency WHERE `code`=''
0.0001890659SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '173' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001888275SELECT * FROM hm_currency WHERE `code`=''
0.0001888275SELECT * FROM hm_currency WHERE `code`=''
0.0001888275SELECT * FROM hm_currency WHERE `code`=''
0.0001888275SELECT * FROM hm_currency WHERE `code`=''
0.0001881123SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29113'
0.0001881123SELECT * FROM hm_currency WHERE code='EUR'
0.0001881123SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='32512' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001881123SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29077' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001881123SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29053' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001881123SELECT * FROM hm_currency WHERE `code`=''
0.0001881123SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '49182' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001881123SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29007' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001881123SELECT * FROM hm_currency WHERE `code`=''
0.0001881123SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29040' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001878738SELECT * FROM hm_currency WHERE `code`=''
0.0001878738SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28945' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001878738SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '204' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001878738SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '49181' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001878738SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28950' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001871586SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'common/menu_top'
0.0001871586SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='437'
0.0001871586SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '19' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001871586SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29107' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001869202SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29115' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001869202SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29001' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001869202SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28984'
0.0001869202SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29013' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001869202SELECT * FROM hm_currency WHERE `code`=''
0.0001869202SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '49172' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001869202SELECT * FROM hm_currency WHERE `code`=''
0.0001859665SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29011'
0.0001859665SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28954' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001859665SELECT * FROM hm_currency WHERE `code`=''
0.0001859665SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29113' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001859665SELECT * FROM hm_currency WHERE `code`=''
0.0001859665SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29063'
0.0001850128SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28975'
0.0001850128SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28956' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001850128SELECT category_id FROM hm_product_to_category WHERE product_id = '32466' ORDER BY main_category DESC LIMIT 1
0.0001850128SELECT * FROM hm_currency WHERE `code`=''
0.0001840591SELECT DISTINCT *, pd.name AS name, p.image, p.noindex AS noindex, (SELECT AVG(rating) AS total FROM hm_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 hm_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM hm_product p LEFT JOIN hm_product_description pd ON (p.product_id = pd.product_id) WHERE p.product_id = '32590' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0001840591SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28985' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001840591SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29109'
0.0001840591SELECT * FROM hm_currency WHERE `code`=''
0.0001840591SELECT * FROM hm_property_type_description WHERE language_id='1'
0.0001840591SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '49178' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001840591SELECT * FROM hm_currency WHERE `code`=''
0.0001838207SELECT category_id FROM hm_product_to_category WHERE product_id = '32429' ORDER BY main_category DESC LIMIT 1
0.0001838207SELECT * FROM hm_currency WHERE `code`=''
0.0001838207SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29028' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001831055SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29079' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001831055SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '49174' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001831055SELECT * FROM hm_currency WHERE `code`=''
0.0001831055SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29088' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001831055SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29016'
0.0001831055SELECT * FROM hm_currency WHERE `code`=''
0.0001831055SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28990' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001828671SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='440'
0.0001828671SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28987' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001828671SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '17' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001828671SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='441'
0.0001828671SELECT * FROM hm_currency WHERE `code`=''
0.0001819134SELECT * FROM hm_currency WHERE `code`=''
0.0001819134SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29101' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001819134SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28972'
0.0001819134SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28947' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001819134SELECT * FROM hm_currency WHERE `code`=''
0.0001819134DELETE FROM hm_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
0.0001811981SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28994'
0.0001811981SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28961'
0.0001811981SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '41022' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001809597SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29042' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001809597SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28989' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001809597SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '245' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001809597SELECT * FROM hm_currency WHERE `code`=''
0.0001809597SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28951'
0.0001809597SELECT * FROM hm_currency WHERE `code`=''
0.0001809597SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='439'
0.0001809597SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29022' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001809597SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28997' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001809597SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29066' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001800060SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29033'
0.0001800060SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29002'
0.0001800060SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29130' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001800060SELECT category_id FROM hm_product_to_category WHERE product_id = '32389' ORDER BY main_category DESC LIMIT 1
0.0001800060SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28955'
0.0001800060SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29078' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001800060SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '99' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001800060SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29090'
0.0001800060SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='436'
0.0001800060SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='32389' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001800060SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28958'
0.0001800060SELECT category_id FROM hm_product_to_category WHERE product_id = '32577' ORDER BY main_category DESC LIMIT 1
0.0001800060SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '12' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001800060SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29104'
0.0001800060SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29075'
0.0001790524SELECT category_id FROM hm_product_to_category WHERE product_id = '32440' ORDER BY main_category DESC LIMIT 1
0.0001790524SELECT * FROM hm_currency WHERE `code`=''
0.0001790524SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28957' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001788139SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29099' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001780987SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '105' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001780987SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28964' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001780987SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29111' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001780987SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29068' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001780987SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29046' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001780987SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '104' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001780987SELECT * FROM hm_currency WHERE `code`=''
0.0001778603SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29002' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001778603SELECT * FROM hm_currency WHERE `code`=''
0.0001771450SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28949' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001771450SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29043' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001771450SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28942' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001771450SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29014' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001771450SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28948' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001769066SELECT * FROM hm_currency WHERE `code`=''
0.0001769066SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29012'
0.0001769066SELECT * FROM hm_currency WHERE `code`=''
0.0001769066SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '243' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001769066SELECT * FROM hm_currency WHERE `code`=''
0.0001761913SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29062'
0.0001759529SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28983'
0.0001759529SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29108' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001759529SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '49183' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001759529SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29074' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001759529SELECT * FROM hm_currency WHERE `code`=''
0.0001759529SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29041' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001759529SELECT * FROM hm_currency WHERE `code`=''
0.0001759529SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29011' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001759529SELECT * FROM hm_currency WHERE `code`=''
0.0001759529SELECT * FROM hm_currency WHERE `code`=''
0.0001749992SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29105' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001749992SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28960' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001749992SELECT * FROM hm_currency WHERE `code`=''
0.0001749992SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29116'
0.0001749992SELECT * FROM hm_currency WHERE code='EUR'
0.0001749992SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='41019'
0.0001749992SELECT * FROM hm_currency WHERE `code`=''
0.0001749992SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '41020' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001749992SELECT * FROM hm_currency WHERE `code`=''
0.0001740456SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '86' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001740456SELECT * FROM hm_currency WHERE `code`=''
0.0001740456SELECT category_id FROM hm_product_to_category WHERE product_id = '32472' ORDER BY main_category DESC LIMIT 1
0.0001738071SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29026' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001738071SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '26' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001738071SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28980' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001738071SELECT * FROM hm_currency WHERE `code`=''
0.0001730919SELECT * FROM hm_currency WHERE `code`=''
0.0001730919SELECT * FROM hm_currency WHERE code='EUR'
0.0001730919SELECT * FROM hm_currency WHERE `code`=''
0.0001730919SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29032'
0.0001730919SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28963' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001730919SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '16' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001730919SELECT * FROM hm_currency WHERE `code`=''
0.0001728535SELECT * FROM hm_currency WHERE `code`=''
0.0001728535SELECT * FROM hm_currency WHERE `code`=''
0.0001728535SELECT * FROM hm_currency WHERE `code`=''
0.0001728535SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28961' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001728535SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29005' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001721382SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29097'
0.0001721382SELECT * FROM hm_currency WHERE `code`=''
0.0001721382SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28998'
0.0001721382SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '83' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001721382SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29024'
0.0001721382SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='438'
0.0001718998SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28988' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001718998SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29037' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001718998SELECT * FROM hm_currency WHERE `code`=''
0.0001709461SELECT * FROM hm_currency WHERE `code`=''
0.0001709461SELECT * FROM hm_currency WHERE `code`=''
0.0001709461SELECT * FROM hm_currency WHERE `code`=''
0.0001709461SELECT * FROM hm_currency WHERE `code`=''
0.0001709461SELECT * FROM hm_currency WHERE `code`=''
0.0001709461SELECT * FROM hm_currency WHERE `code`=''
0.0001709461SELECT * FROM hm_currency WHERE `code`=''
0.0001709461SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28967' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001709461SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29018'
0.0001709461SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29072' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001702309SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28969'
0.0001699924SELECT * FROM hm_currency WHERE `code`=''
0.0001699924SELECT * FROM hm_currency WHERE `code`=''
0.0001699924SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '22' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001699924SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '27' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001699924SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29000'
0.0001699924SELECT * FROM hm_currency WHERE code='EUR'
0.0001699924SELECT * FROM hm_currency WHERE `code`=''
0.0001699924SELECT * FROM hm_currency WHERE `code`=''
0.0001699924SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '49176' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001699924SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28948'
0.0001699924SELECT * FROM hm_currency WHERE `code`=''
0.0001699924SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28998' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001699924SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'product/category'
0.0001699924SELECT * FROM hm_currency WHERE `code`=''
0.0001690388SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '49173' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001690388SELECT * FROM hm_currency WHERE `code`=''
0.0001690388SELECT * FROM hm_currency WHERE `code`=''
0.0001690388SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29129' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001690388SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29079'
0.0001690388SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29117' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001690388SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '107' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001690388SELECT * FROM hm_currency WHERE `code`=''
0.0001690388SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29073' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001690388SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29098' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001690388SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28973'
0.0001690388SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29034' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001690388SELECT * FROM hm_currency WHERE `code`=''
0.0001690388SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29035'
0.0001690388SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29056' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001688004SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '123' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001688004SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '106' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001680851SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28996' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001680851SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29020' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001680851SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28979'
0.0001680851SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28956'
0.0001680851SELECT * FROM hm_currency WHERE `code`=''
0.0001680851SELECT * FROM hm_currency WHERE `code`=''
0.0001680851SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50591'
0.0001680851SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29040'
0.0001680851SELECT * FROM hm_property_type_description WHERE property_type_id='1' AND language_id='1'
0.0001680851SELECT * FROM hm_currency WHERE `code`=''
0.0001680851SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28984' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001678467SELECT * FROM hm_currency WHERE `code`=''
0.0001678467SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29008'
0.0001678467SELECT * FROM hm_currency WHERE `code`=''
0.0001671314SELECT * FROM hm_currency WHERE `code`=''
0.0001671314SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '10' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001671314SELECT * FROM hm_currency WHERE `code`=''
0.0001668930SELECT * FROM hm_currency WHERE `code`=''
0.0001668930SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28959' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001668930SELECT * FROM hm_currency WHERE `code`=''
0.0001668930SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29027'
0.0001668930SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29069' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001668930SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29058' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001668930SELECT * FROM hm_currency WHERE `code`=''
0.0001668930SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28993'
0.0001668930SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29057' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001668930SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29121' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001668930SELECT * FROM hm_currency WHERE `code`=''
0.0001661777SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29051' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001661777SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29084'
0.0001661777SELECT * FROM hm_currency WHERE `code`=''
0.0001659393SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '203' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001659393SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29131'
0.0001659393SELECT * FROM hm_currency WHERE `code`=''
0.0001659393SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru')
0.0001659393SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '102' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001659393SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28972' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001659393SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29128' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001659393SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '239' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001649857SELECT * FROM hm_currency WHERE `code`=''
0.0001649857SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28950'
0.0001649857SELECT category_id FROM hm_product_to_category WHERE product_id = '32444' ORDER BY main_category DESC LIMIT 1
0.0001649857SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '141' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001649857SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '101' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001649857SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29089' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001649857SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29059'
0.0001649857SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29031'
0.0001649857SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29118' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001649857SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29132' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001649857SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29127'
0.0001649857SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '184' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001649857SELECT * FROM hm_currency WHERE `code`=''
0.0001640320SELECT * FROM hm_currency WHERE `code`=''
0.0001640320SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '193' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001640320SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='49177'
0.0001640320SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29061' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001640320SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '97' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001640320SELECT * FROM hm_currency WHERE `code`=''
0.0001640320SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '172' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001637936SELECT * FROM hm_currency WHERE `code`=''
0.0001630783SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '150' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001630783SELECT * FROM hm_currency WHERE `code`=''
0.0001630783SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29004'
0.0001630783SELECT * FROM hm_currency WHERE `code`=''
0.0001630783SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '40' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001630783SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29044' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001630783SELECT * FROM hm_currency WHERE `code`=''
0.0001630783SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '162' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001630783SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29030'
0.0001628399SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29077'
0.0001628399SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '108' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001621246SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '50591' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001621246SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '103' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001618862SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '117' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001618862SELECT * FROM hm_currency WHERE `code`=''
0.0001618862SELECT * FROM hm_currency WHERE `code`=''
0.0001618862SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '13' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001618862SELECT * FROM hm_currency WHERE `code`=''
0.0001618862SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28992' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001611710SELECT * FROM hm_currency WHERE `code`=''
0.0001611710SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'common/currency'
0.0001611710SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28982' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001611710SELECT * FROM hm_currency WHERE `code`=''
0.0001609325SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28962' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001609325SELECT * FROM hm_currency WHERE `code`=''
0.0001609325SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '134' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001609325SELECT * FROM hm_currency WHERE `code`=''
0.0001609325SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29010'
0.0001609325SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '160' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001609325SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29081' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001609325SELECT * FROM hm_currency WHERE `code`=''
0.0001602173SELECT * FROM hm_currency WHERE `code`=''
0.0001599789SELECT * FROM hm_currency WHERE `code`=''
0.0001599789SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29106'
0.0001599789SELECT * FROM hm_currency WHERE `code`=''
0.0001599789SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28965'
0.0001599789SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29029' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001599789SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '95' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001599789SELECT category_id FROM hm_product_to_category WHERE product_id = '32546' ORDER BY main_category DESC LIMIT 1
0.0001590252SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28994' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001590252SELECT * FROM hm_currency WHERE `code`=''
0.0001590252SELECT category_id FROM hm_product_to_category WHERE product_id = '32512' ORDER BY main_category DESC LIMIT 1
0.0001590252SELECT * FROM hm_currency WHERE `code`=''
0.0001590252SELECT category_id FROM hm_product_to_category WHERE product_id = '32529' ORDER BY main_category DESC LIMIT 1
0.0001590252SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')
0.0001590252SELECT * FROM hm_currency WHERE `code`=''
0.0001587868SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '7' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001587868SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29102'
0.0001580715SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29029'
0.0001580715SELECT category_id FROM hm_product_to_category WHERE product_id = '32589' ORDER BY main_category DESC LIMIT 1
0.0001580715SELECT * FROM hm_currency WHERE `code`=''
0.0001580715SELECT category_id FROM hm_product_to_category WHERE product_id = '32541' ORDER BY main_category DESC LIMIT 1
0.0001580715SELECT * FROM hm_currency WHERE `code`=''
0.0001580715SELECT * FROM hm_currency WHERE `code`=''
0.0001580715SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='49184'
0.0001580715SELECT category_id FROM hm_product_to_category WHERE product_id = '32590' ORDER BY main_category DESC LIMIT 1
0.0001580715SELECT * FROM hm_currency WHERE `code`=''
0.0001580715SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28981'
0.0001580715SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29010' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001580715SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29120' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001578331SELECT * FROM hm_currency WHERE `code`=''
0.0001578331SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '54' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001578331SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '64' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001578331SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '214' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001578331SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28960'
0.0001578331SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='49176'
0.0001578331SELECT * FROM hm_currency WHERE `code`=''
0.0001578331SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '229' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001571178SELECT * FROM hm_currency WHERE `code`=''
0.0001571178SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29071' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001571178SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29020'
0.0001571178SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '230' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001571178SELECT * FROM hm_currency WHERE `code`=''
0.0001571178SELECT * FROM hm_currency WHERE `code`=''
0.0001568794SELECT * FROM hm_currency WHERE `code`=''
0.0001568794SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28995'
0.0001568794SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '167' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001568794SELECT * FROM hm_currency WHERE `code`=''
0.0001568794SELECT * FROM hm_currency WHERE `code`=''
0.0001561642SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '36' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001561642SELECT category_id FROM hm_product_to_category WHERE product_id = '32422' ORDER BY main_category DESC LIMIT 1
0.0001561642SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28976' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001559258SELECT * FROM hm_currency WHERE `code`=''
0.0001559258SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '163' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001559258SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '59' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001559258SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/nice' OR route = 'ru-ru')
0.0001559258SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '60' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001559258SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '39' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001559258SELECT * FROM hm_currency WHERE code='EUR'
0.0001559258SELECT * FROM hm_currency WHERE `code`=''
0.0001559258SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29082'
0.0001559258SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29064'
0.0001559258SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29041'
0.0001559258SELECT * FROM hm_currency WHERE code='EUR'
0.0001559258SELECT * FROM hm_currency WHERE code='EUR'
0.0001552105SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28943'
0.0001549721SELECT * FROM hm_currency WHERE `code`=''
0.0001549721SELECT * FROM hm_currency WHERE `code`=''
0.0001549721SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28978' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001549721SELECT * FROM hm_currency WHERE `code`=''
0.0001549721SELECT * FROM hm_currency WHERE `code`=''
0.0001549721SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '93' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001549721SELECT category_id FROM hm_product_to_category WHERE product_id = '32535' ORDER BY main_category DESC LIMIT 1
0.0001549721SELECT * FROM hm_currency WHERE `code`=''
0.0001549721SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29086' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001549721SELECT * FROM hm_currency WHERE `code`=''
0.0001549721SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '89' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001549721SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28979' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001549721SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='49180'
0.0001540184SELECT * FROM hm_currency WHERE `code`=''
0.0001540184SELECT * FROM hm_currency WHERE `code`=''
0.0001540184SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29123' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001540184SELECT * FROM hm_currency WHERE `code`=''
0.0001540184SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28991'
0.0001540184SELECT * FROM hm_currency WHERE `code`=''
0.0001540184SELECT category_id FROM hm_product_to_category WHERE product_id = '32385' ORDER BY main_category DESC LIMIT 1
0.0001540184SELECT * FROM hm_currency WHERE `code`=''
0.0001540184SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '165' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001540184SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '186' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001540184SELECT * FROM hm_currency WHERE `code`=''
0.0001540184SELECT * FROM hm_currency WHERE `code`=''
0.0001540184SELECT * FROM hm_currency WHERE `code`=''
0.0001540184SELECT * FROM hm_currency WHERE `code`=''
0.0001540184SELECT * FROM hm_currency WHERE `code`=''
0.0001530647SELECT * FROM hm_currency WHERE `code`=''
0.0001530647SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='41018'
0.0001530647SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28946' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001530647SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29061'
0.0001530647SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/menu' OR route = 'ru-ru')
0.0001530647SELECT * FROM hm_currency WHERE code='EUR'
0.0001530647SELECT * FROM hm_currency WHERE `code`=''
0.0001530647SELECT * FROM hm_currency WHERE `code`=''
0.0001530647SELECT * FROM hm_currency WHERE `code`=''
0.0001530647SELECT * FROM hm_currency WHERE `code`=''
0.0001528263SELECT * FROM hm_currency WHERE `code`=''
0.0001528263SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='49183'
0.0001521111SELECT * FROM hm_currency WHERE `code`=''
0.0001521111SELECT * FROM hm_currency WHERE `code`=''
0.0001521111SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29093' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001521111SELECT * FROM hm_currency WHERE `code`=''
0.0001521111SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28990'
0.0001521111SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29009' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001521111SELECT * FROM hm_currency WHERE `code`=''
0.0001521111SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '122' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001521111SELECT * FROM hm_currency WHERE `code`=''
0.0001521111SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '88' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001521111SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28974' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001521111SELECT * FROM hm_currency WHERE `code`=''
0.0001518726SELECT * FROM hm_currency WHERE `code`=''
0.0001518726SELECT * FROM hm_currency WHERE `code`=''
0.0001518726SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '153' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001518726SELECT * FROM hm_currency WHERE code='EUR'
0.0001518726SELECT category_id FROM hm_product_to_category WHERE product_id = '32536' ORDER BY main_category DESC LIMIT 1
0.0001511574SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29025'
0.0001511574SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29085' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001511574SELECT * FROM hm_currency WHERE `code`=''
0.0001511574SELECT * FROM hm_currency WHERE `code`=''
0.0001509190SELECT * FROM hm_currency WHERE `code`=''
0.0001509190SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28980'
0.0001509190SELECT * FROM hm_currency WHERE `code`=''
0.0001509190SELECT * FROM hm_currency WHERE `code`=''
0.0001509190SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '44' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001509190SELECT * FROM hm_currency WHERE `code`=''
0.0001509190SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28970'
0.0001509190SELECT * FROM hm_currency WHERE `code`=''
0.0001509190SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29049'
0.0001509190SELECT * FROM hm_currency WHERE `code`=''
0.0001499653SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28943' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001499653SELECT * FROM hm_currency WHERE code='EUR'
0.0001499653SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29107'
0.0001499653SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28971' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001499653SELECT * FROM hm_currency WHERE `code`=''
0.0001499653SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29132'
0.0001499653SELECT * FROM hm_currency WHERE code='EUR'
0.0001499653SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28944' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001499653SELECT * FROM hm_currency WHERE `code`=''
0.0001499653SELECT * FROM hm_currency WHERE `code`=''
0.0001499653SELECT * FROM hm_currency WHERE `code`=''
0.0001490116SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28985'
0.0001490116SELECT * FROM hm_currency WHERE code='EUR'
0.0001490116SELECT * FROM hm_currency WHERE `code`=''
0.0001490116SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29124' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001490116SELECT * FROM hm_currency WHERE `code`=''
0.0001490116SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29094'
0.0001490116SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29100' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001490116SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29122' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001490116SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '49180' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001490116SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='49174'
0.0001490116SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29119' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001490116SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29056'
0.0001480579SELECT * FROM hm_currency WHERE code='EUR'
0.0001480579SELECT * FROM hm_currency WHERE code='EUR'
0.0001480579SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29103' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001480579SELECT * FROM hm_currency WHERE code='EUR'
0.0001480579SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '51' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001480579SELECT * FROM hm_currency WHERE `code`=''
0.0001480579SELECT * FROM hm_currency WHERE `code`=''
0.0001480579SELECT * FROM hm_currency WHERE `code`=''
0.0001480579SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28977'
0.0001478195SELECT * FROM hm_currency WHERE `code`=''
0.0001478195SELECT * FROM hm_currency WHERE `code`=''
0.0001478195SELECT * FROM hm_currency WHERE `code`=''
0.0001478195SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29098'
0.0001478195SELECT * FROM hm_currency WHERE `code`=''
0.0001478195SELECT * FROM hm_currency WHERE `code`=''
0.0001471043SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29091' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001471043SELECT * FROM hm_currency WHERE `code`=''
0.0001471043SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29005'
0.0001471043SELECT * FROM hm_currency WHERE `code`=''
0.0001471043SELECT * FROM hm_currency WHERE `code`=''
0.0001471043SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28987'
0.0001471043SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29003'
0.0001471043SELECT * FROM hm_currency WHERE `code`=''
0.0001471043SELECT * FROM hm_currency WHERE `code`=''
0.0001468658SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29073'
0.0001468658SELECT * FROM hm_currency WHERE code='EUR'
0.0001468658SELECT * FROM hm_currency WHERE `code`=''
0.0001468658SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/category' OR route = 'ru-ru')
0.0001468658SELECT * FROM hm_currency WHERE `code`=''
0.0001461506SELECT * FROM hm_currency WHERE `code`=''
0.0001461506SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29130'
0.0001461506SELECT * FROM hm_currency WHERE `code`=''
0.0001461506SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '164' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001461506SELECT * FROM hm_currency WHERE `code`=''
0.0001461506SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28989'
0.0001459122SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29039'
0.0001459122SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29051'
0.0001459122SELECT * FROM hm_currency WHERE `code`=''
0.0001459122SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29092'
0.0001459122SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='49178'
0.0001459122SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29110' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001459122SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29065'
0.0001459122SELECT * FROM hm_currency WHERE `code`=''
0.0001451969SELECT * FROM hm_currency WHERE `code`=''
0.0001449585SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29043'
0.0001449585SELECT * FROM hm_category_to_layout WHERE category_id = '440' AND store_id = '0'
0.0001449585SELECT * FROM hm_currency WHERE `code`=''
0.0001449585SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29047'
0.0001449585SELECT category_id FROM hm_product_to_category WHERE product_id = '32369' ORDER BY main_category DESC LIMIT 1
0.0001449585SELECT * FROM hm_currency WHERE `code`=''
0.0001449585SELECT * FROM hm_currency WHERE `code`=''
0.0001449585SELECT * FROM hm_currency WHERE `code`=''
0.0001449585SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28959'
0.0001449585SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28957'
0.0001449585SELECT * FROM hm_currency WHERE code='EUR'
0.0001449585SELECT * FROM hm_currency WHERE `code`=''
0.0001449585SELECT * FROM hm_currency WHERE `code`=''
0.0001440048SELECT * FROM hm_currency WHERE `code`=''
0.0001440048SELECT * FROM hm_currency WHERE `code`=''
0.0001440048SELECT * FROM hm_currency WHERE `code`=''
0.0001440048SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '168' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001440048SELECT * FROM hm_currency WHERE `code`=''
0.0001440048SELECT * FROM hm_currency WHERE `code`=''
0.0001440048SELECT * FROM hm_currency WHERE `code`=''
0.0001440048SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29046'
0.0001440048SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29110'
0.0001440048SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29053'
0.0001440048SELECT * FROM hm_currency WHERE `code`=''
0.0001440048SELECT * FROM hm_currency WHERE `code`=''
0.0001430511SELECT * FROM hm_currency WHERE `code`=''
0.0001430511SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28966'
0.0001430511SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28945'
0.0001430511SELECT * FROM hm_currency WHERE `code`=''
0.0001430511SELECT * FROM hm_currency WHERE `code`=''
0.0001430511SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29034'
0.0001430511SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29021' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001430511SELECT * FROM hm_currency WHERE `code`=''
0.0001430511SELECT * FROM hm_currency WHERE `code`=''
0.0001430511SELECT * FROM hm_currency WHERE `code`=''
0.0001428127SELECT * FROM hm_currency WHERE `code`=''
0.0001428127SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28962'
0.0001420975SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29045'
0.0001420975SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/recently_viewed' OR route = 'ru-ru')
0.0001420975SELECT * FROM hm_currency WHERE `code`=''
0.0001420975SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29080' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001420975SELECT * FROM hm_currency WHERE `code`=''
0.0001420975SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '49175' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001420975SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='49181'
0.0001420975SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru')
0.0001420975SELECT * FROM hm_currency WHERE `code`=''
0.0001420975SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29038' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001418591SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29125' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001418591SELECT * FROM hm_currency WHERE `code`=''
0.0001418591SELECT * FROM hm_currency WHERE `code`=''
0.0001418591SELECT * FROM hm_currency WHERE `code`=''
0.0001418591SELECT * FROM hm_currency WHERE `code`=''
0.0001411438SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28952' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001411438SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '129' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001411438SELECT * FROM hm_currency WHERE `code`=''
0.0001411438SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='41022'
0.0001411438SELECT * FROM hm_currency WHERE `code`=''
0.0001409054SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29072'
0.0001409054SELECT * FROM hm_currency WHERE `code`=''
0.0001409054SELECT * FROM hm_currency WHERE `code`=''
0.0001409054SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29036'
0.0001409054SELECT * FROM hm_currency WHERE `code`=''
0.0001409054SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28977' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001409054SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29096' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001409054SELECT * FROM hm_currency WHERE `code`=''
0.0001401901SELECT * FROM hm_currency WHERE `code`=''
0.0001401901SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28947'
0.0001399517SELECT * FROM hm_currency WHERE `code`=''
0.0001399517SELECT * FROM hm_currency WHERE `code`=''
0.0001399517SELECT * FROM hm_currency WHERE `code`=''
0.0001399517SELECT * FROM hm_currency WHERE `code`=''
0.0001399517SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29101'
0.0001399517SELECT * FROM hm_currency WHERE `code`=''
0.0001399517SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29108'
0.0001389980SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/nice' OR route = 'ru-ru')
0.0001389980SELECT * FROM hm_currency WHERE `code`=''
0.0001389980SELECT * FROM hm_currency WHERE `code`=''
0.0001389980SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
0.0001389980SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'extension/captcha/google'
0.0001389980SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/nice' OR route = 'ru-ru')
0.0001389980SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'common/content_bottom'
0.0001389980SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29088'
0.0001389980SELECT * FROM hm_currency WHERE `code`=''
0.0001389980SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29021'
0.0001389980SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29048' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001389980SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28964'
0.0001380444SELECT * FROM hm_category_to_layout WHERE category_id = '440' AND store_id = '0'
0.0001380444SELECT * FROM hm_currency WHERE `code`=''
0.0001380444SELECT * FROM hm_currency WHERE `code`=''
0.0001380444SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29006' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001380444SELECT `data` FROM `hm_session` WHERE `session_id` = '24fc4ec28339d8e6597cd3315d' AND `expire` > '2025-12-04 00:12:51'
0.0001380444SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='49172'
0.0001380444SELECT category_id FROM hm_product_to_category WHERE product_id = '32419' ORDER BY main_category DESC LIMIT 1
0.0001380444SELECT * FROM hm_currency WHERE `code`=''
0.0001380444SELECT * FROM hm_currency WHERE `code`=''
0.0001380444SELECT * FROM hm_currency WHERE `code`=''
0.0001380444SELECT * FROM hm_currency WHERE `code`=''
0.0001370907SELECT * FROM hm_currency WHERE `code`=''
0.0001370907SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '130' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001370907SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'common/header'
0.0001370907SELECT * FROM hm_currency WHERE `code`=''
0.0001368523SELECT * FROM hm_currency WHERE `code`=''
0.0001368523SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29070'
0.0001368523SELECT * FROM hm_currency WHERE `code`=''
0.0001368523SELECT * FROM hm_currency WHERE `code`=''
0.0001368523SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='49175'
0.0001368523SELECT * FROM hm_currency WHERE `code`=''
0.0001368523SELECT * FROM hm_currency WHERE `code`=''
0.0001368523SELECT * FROM hm_currency WHERE `code`=''
0.0001368523SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29054' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001361370SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29122'
0.0001361370SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28999'
0.0001361370SELECT * FROM hm_currency WHERE `code`=''
0.0001361370SELECT * FROM hm_currency WHERE `code`=''
0.0001361370SELECT * FROM hm_currency WHERE `code`=''
0.0001361370SELECT * FROM hm_currency WHERE `code`=''
0.0001361370SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '219' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001358986SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '118' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001358986SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29057'
0.0001358986SELECT * FROM hm_currency WHERE `code`=''
0.0001358986SELECT * FROM hm_currency WHERE `code`=''
0.0001358986SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '136' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001351833SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28963'
0.0001351833SELECT * FROM hm_currency WHERE `code`=''
0.0001351833SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29028'
0.0001351833SELECT * FROM hm_currency WHERE `code`=''
0.0001351833SELECT * FROM hm_currency WHERE `code`=''
0.0001349449SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29007'
0.0001349449SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29058'
0.0001349449SELECT * FROM hm_currency WHERE `code`=''
0.0001349449SELECT * FROM hm_currency WHERE `code`=''
0.0001349449SELECT * FROM hm_currency WHERE `code`=''
0.0001349449SELECT * FROM hm_currency WHERE `code`=''
0.0001349449SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '28' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001349449SELECT * FROM hm_currency WHERE `code`=''
0.0001349449SELECT * FROM hm_currency WHERE `code`=''
0.0001339912SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '156' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001339912SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29086'
0.0001339912SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='49182'
0.0001339912SELECT * FROM hm_currency WHERE `code`=''
0.0001339912SELECT * FROM hm_currency WHERE `code`=''
0.0001339912SELECT * FROM hm_currency WHERE `code`=''
0.0001339912SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '114' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001339912SELECT * FROM hm_currency WHERE `code`=''
0.0001339912SELECT * FROM hm_currency WHERE `code`=''
0.0001339912SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29105'
0.0001339912SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29099'
0.0001339912SELECT * FROM hm_currency WHERE `code`=''
0.0001330376SELECT * FROM hm_currency WHERE `code`=''
0.0001330376SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28982'
0.0001330376SELECT * FROM hm_currency WHERE `code`=''
0.0001330376SELECT * FROM hm_currency WHERE `code`=''
0.0001330376SELECT * FROM hm_currency WHERE `code`=''
0.0001330376SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/captcha/google' OR route = 'ru-ru')
0.0001330376SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '250' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001330376SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29087' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001330376SELECT * FROM hm_currency WHERE `code`=''
0.0001330376SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29037'
0.0001330376SELECT * FROM hm_currency WHERE `code`=''
0.0001330376SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '47' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001330376SELECT * FROM hm_currency WHERE `code`=''
0.0001327991SELECT * FROM hm_currency WHERE `code`=''
0.0001327991SELECT * FROM hm_currency WHERE `code`=''
0.0001327991SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29054'
0.0001320839SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29078'
0.0001320839SELECT * FROM hm_currency WHERE `code`=''
0.0001320839SELECT * FROM hm_currency WHERE `code`=''
0.0001320839SELECT * FROM hm_currency WHERE `code`=''
0.0001320839SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29126' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001320839SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29039' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001320839SELECT * FROM hm_currency WHERE `code`=''
0.0001320839SELECT * FROM hm_currency WHERE `code`=''
0.0001318455SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29026'
0.0001318455SELECT * FROM hm_currency WHERE `code`=''
0.0001318455SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='41021'
0.0001318455SELECT * FROM hm_currency WHERE `code`=''
0.0001311302SELECT * FROM hm_currency WHERE `code`=''
0.0001311302SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28949'
0.0001311302SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29128'
0.0001311302SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28997'
0.0001311302SELECT * FROM hm_currency WHERE `code`=''
0.0001308918SELECT * FROM hm_currency WHERE `code`=''
0.0001308918SELECT * FROM hm_currency WHERE `code`=''
0.0001308918SELECT * FROM hm_currency WHERE `code`=''
0.0001308918SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='49173'
0.0001301765SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '147' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001301765SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28978'
0.0001299381SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '62' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001299381SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29100'
0.0001299381SELECT * FROM hm_currency WHERE `code`=''
0.0001299381SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '154' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001299381SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29001'
0.0001299381SELECT * FROM hm_currency WHERE `code`=''
0.0001299381SELECT * FROM hm_currency WHERE `code`=''
0.0001289845SELECT * FROM hm_currency WHERE `code`=''
0.0001289845SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'common/footer'
0.0001289845SELECT * FROM hm_currency WHERE `code`=''
0.0001289845SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29095'
0.0001289845SELECT * FROM hm_currency WHERE `code`=''
0.0001289845SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28942'
0.0001289845SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '225' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001289845SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29125'
0.0001289845SELECT * FROM hm_currency WHERE `code`=''
0.0001289845SELECT * FROM hm_category_to_layout WHERE category_id = '440' AND store_id = '0'
0.0001289845SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29067'
0.0001289845SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29015' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001289845SELECT * FROM hm_currency WHERE `code`=''
0.0001280308SELECT * FROM hm_currency WHERE `code`=''
0.0001280308SELECT * FROM hm_currency WHERE `code`=''
0.0001280308SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'common/content_top'
0.0001280308SELECT * FROM hm_currency WHERE `code`=''
0.0001280308SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '43' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001280308SELECT * FROM hm_currency WHERE `code`=''
0.0001280308SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29014'
0.0001277924SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29013'
0.0001270771SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29052'
0.0001270771SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28986'
0.0001270771SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28946'
0.0001270771SELECT * FROM hm_currency WHERE `code`=''
0.0001270771SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29115'
0.0001270771SELECT * FROM hm_currency WHERE `code`=''
0.0001268387SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29119'
0.0001268387SELECT * FROM hm_currency WHERE `code`=''
0.0001261234SELECT * FROM hm_currency WHERE `code`=''
0.0001261234SELECT * FROM hm_currency WHERE `code`=''
0.0001261234SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '217' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001261234SELECT * FROM hm_currency WHERE `code`=''
0.0001261234SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29085'
0.0001261234SELECT * FROM hm_currency WHERE `code`=''
0.0001261234SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29121'
0.0001261234SELECT * FROM hm_currency WHERE `code`=''
0.0001258850SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29081'
0.0001258850SELECT * FROM hm_currency WHERE `code`=''
0.0001258850SELECT * FROM hm_currency WHERE `code`=''
0.0001258850SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '9' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001258850SELECT * FROM hm_currency WHERE `code`=''
0.0001251698SELECT * FROM hm_module WHERE module_id = '39'
0.0001251698SELECT * FROM hm_currency WHERE `code`=''
0.0001251698SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29112'
0.0001251698SELECT * FROM hm_currency WHERE `code`=''
0.0001251698SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28996'
0.0001249313SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29080'
0.0001249313SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29060'
0.0001249313SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29068'
0.0001249313SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '18' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001249313SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29114'
0.0001242161SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '87' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001242161SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28988'
0.0001242161SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29117'
0.0001239777SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29071'
0.0001239777SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29069'
0.0001239777SELECT * FROM hm_currency WHERE `code`=''
0.0001239777SELECT * FROM hm_currency WHERE `code`=''
0.0001239777SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29023'
0.0001239777SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28974'
0.0001239777SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '145' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001230240SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29126'
0.0001230240SELECT * FROM hm_currency WHERE `code`=''
0.0001230240SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '238' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001230240SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '142' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001230240SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '166' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001230240SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29103'
0.0001230240SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29055'
0.0001230240SELECT * FROM hm_currency WHERE `code`=''
0.0001230240SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29120'
0.0001227856SELECT * FROM hm_currency WHERE `code`=''
0.0001227856SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29050' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001220703SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29044'
0.0001220703SELECT * FROM hm_currency WHERE `code`=''
0.0001220703SELECT * FROM hm_currency WHERE `code`=''
0.0001220703SELECT * FROM hm_currency WHERE `code`=''
0.0001220703SELECT * FROM hm_currency WHERE `code`=''
0.0001220703SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29006'
0.0001218319SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '144' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001218319SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29066'
0.0001218319SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '246' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001218319SELECT * FROM hm_currency WHERE `code`=''
0.0001211166SELECT * FROM hm_currency WHERE `code`=''
0.0001211166SELECT * FROM hm_currency WHERE `code`=''
0.0001211166SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28992'
0.0001211166SELECT * FROM hm_currency WHERE `code`=''
0.0001211166SELECT * FROM hm_currency WHERE `code`=''
0.0001211166SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
0.0001211166SELECT * FROM hm_currency WHERE `code`=''
0.0001211166SELECT * FROM hm_currency WHERE `code`=''
0.0001208782SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29017' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001208782SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29055' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001208782SELECT * FROM hm_currency WHERE `code`=''
0.0001208782SELECT * FROM hm_category_to_layout WHERE category_id = '440' AND store_id = '0'
0.0001208782SELECT * FROM hm_currency WHERE `code`=''
0.0001208782SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '124' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001201630SELECT * FROM hm_currency WHERE `code`=''
0.0001201630SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '29094' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001199245SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '208' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001199245SELECT * FROM hm_currency WHERE `code`=''
0.0001199245SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '231' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001199245SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '188' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001199245SELECT * FROM hm_currency WHERE `code`=''
0.0001199245SELECT * FROM hm_currency WHERE `code`=''
0.0001192093SELECT * FROM hm_currency WHERE `code`=''
0.0001189709SELECT * FROM hm_currency WHERE `code`=''
0.0001189709SELECT * FROM hm_currency WHERE `code`=''
0.0001189709SELECT * FROM hm_currency WHERE `code`=''
0.0001189709SELECT * FROM hm_currency WHERE `code`=''
0.0001189709SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29022'
0.0001189709SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29124'
0.0001180172SELECT * FROM hm_currency WHERE `code`=''
0.0001180172SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29123'
0.0001180172SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '138' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001180172SELECT * FROM hm_currency WHERE `code`=''
0.0001180172SELECT * FROM hm_currency WHERE `code`=''
0.0001180172SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28976'
0.0001180172SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29118'
0.0001180172SELECT * FROM hm_currency WHERE `code`=''
0.0001170635SELECT * FROM hm_currency WHERE `code`=''
0.0001170635SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29129'
0.0001170635SELECT * FROM hm_currency WHERE `code`=''
0.0001170635SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'common/column_right'
0.0001170635SELECT * FROM hm_currency WHERE `code`=''
0.0001170635SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28944'
0.0001170635SELECT * FROM hm_currency WHERE `code`=''
0.0001168251SELECT * FROM hm_currency WHERE `code`=''
0.0001161098SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29091'
0.0001161098SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28953'
0.0001158714SELECT * FROM hm_currency WHERE `code`=''
0.0001158714SELECT * FROM hm_currency WHERE `code`=''
0.0001158714SELECT * FROM hm_currency WHERE `code`=''
0.0001158714SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/captcha/google' OR route = 'ru-ru')
0.0001151562SELECT * FROM hm_currency WHERE `code`=''
0.0001149178SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'extension/captcha/google'
0.0001149178SELECT * FROM hm_currency WHERE `code`=''
0.0001149178SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'common/column_left'
0.0001142025SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28967'
0.0001139641SELECT * FROM hm_currency WHERE `code`=''
0.0001139641SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28952'
0.0001139641SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29074'
0.0001139641SELECT * FROM hm_currency WHERE `code`=''
0.0001139641SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'common/language'
0.0001139641SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29087'
0.0001130104SELECT * FROM hm_currency WHERE `code`=''
0.0001130104SELECT * FROM hm_currency WHERE `code`=''
0.0001130104SELECT * FROM hm_currency WHERE `code`=''
0.0001130104SELECT * FROM hm_currency WHERE `code`=''
0.0001130104SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28971'
0.0001120567SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28954'
0.0001111031SELECT * FROM hm_currency WHERE `code`=''
0.0001111031SELECT * FROM hm_currency WHERE `code`=''
0.0001111031SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '24' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001111031SELECT * FROM hm_currency WHERE `code`=''
0.0001108646SELECT * FROM hm_currency WHERE `code`=''
0.0001108646SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29038'
0.0001101494SELECT * FROM hm_currency WHERE `code`=''
0.0001101494SELECT * FROM hm_currency WHERE `code`=''
0.0001101494SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29009'
0.0001101494SELECT * FROM hm_currency WHERE `code`=''
0.0001099110SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='28941'
0.0001099110SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29096'
0.0001099110SELECT * FROM hm_currency WHERE `code`=''
0.0001099110SELECT * FROM hm_currency WHERE `code`=''
0.0001099110SELECT * FROM hm_currency WHERE `code`=''
0.0001091957SELECT * FROM hm_currency WHERE `code`=''
0.0001089573SELECT * FROM hm_currency WHERE `code`=''
0.0001089573SELECT * FROM hm_currency WHERE `code`=''
0.0001089573SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29093'
0.0001089573SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '213' AND p.product_id = p2c.product_id AND p.property_type_id='1'
0.0001089573SELECT * FROM hm_currency WHERE `code`=''
0.0001089573SELECT * FROM hm_currency WHERE `code`=''
0.0001089573SELECT * FROM hm_currency WHERE `code`=''
0.0001089573SELECT * FROM hm_currency WHERE `code`=''
0.0001080036SELECT * FROM hm_currency WHERE `code`=''
0.0001080036SELECT * FROM hm_currency WHERE `code`=''
0.0001080036SELECT * FROM hm_currency WHERE `code`=''
0.0001070499SELECT * FROM hm_currency WHERE `code`=''
0.0001070499SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29089'
0.0001070499SELECT * FROM hm_currency WHERE `code`=''
0.0001070499SELECT * FROM hm_currency WHERE `code`=''
0.0001051426SELECT * FROM hm_currency WHERE `code`=''
0.0001041889SELECT * FROM hm_currency WHERE `code`=''
0.0001041889SELECT * FROM hm_currency WHERE `code`=''
0.0001010895SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29048'
0.0000998974SELECT * FROM hm_currency WHERE `code`=''
0.0000979900SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29050'
0.0000970364SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29015'
0.0000929832SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='29017'
0.0000898838SET time_zone = '+02:00'
0.0000779629SET time_zone = '+00:00'

event

0.0034213066event/translation (15 action)
0.0029003620event/theme (13 action)
0.0025539397event/language (43 action)

startup

1.8403201103startup/router (1 action)
0.1759707928startup/seo_url (1 action)
0.0054678917startup/startup (1 action)
0.0004129410startup/event (1 action)
0.0002379417startup/session (1 action)
0.0000581741startup/error (1 action)
0.0000479221startup/maintenance (1 action)

extension

0.0020279884extension/captcha/google (2 action)
0.0003139973extension/module/recently_viewed (1 action)
0.0002310276extension/module/langdir (1 action)

common

0.4548301697common/footer (1 action)
0.0120310783common/header (1 action)
0.0050809383common/menu_top (1 action)
0.0025711060common/menu_footer (1 action)
0.0020768642common/content_bottom (1 action)
0.0014150143common/column_left (1 action)
0.0013458729common/content_top (1 action)
0.0012948513common/currency (1 action)
0.0012278557common/column_right (1 action)
0.0010938644common/language (1 action)

product

1.8401169777product/category (1 action)