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 offset: 2 in /var/www/homium_ua/data/storage/modification/catalog/controller/startup/startup.php on line 38Notice: 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 Недвижимость в Черногории

Недвижимость в Черногории

Найдено 1661 - 1680 из 2068

Продается  дом на море,  в  Которской бухте
Продается  дом на море,  в  Которской бухте
Продается  дом на море,  в  Которской бухте
4
255 m²

Ищете недвижимость в Черногории?

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

Продается видовая квартира в Петроваце!
Продается видовая квартира в Петроваце!
Продается видовая квартира в Петроваце!
3
79 m²

Черногория: подберем вам идеальную недвижимость

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

Продается готовый дом в Добра Вода с бассейном
Продается готовый дом в Добра Вода с бассейном
3
480 m²
Продаётся двухэтажный дом у моря в Сутоморе (Брца)
Продаётся двухэтажный дом у моря в Сутоморе (Брца)
Продаётся двухэтажный дом у моря в Сутоморе (Брца)
4
96 m²
Продается дом в городе Бар, район Полье
Продается дом в городе Бар, район Полье
Продается дом в городе Бар, район Полье
3
120 m²
Продаётся дом в Шкаляри, Которский залив!
Продаётся дом в Шкаляри, Которский залив!
Продаётся дом в Шкаляри, Которский залив!
170 m²
Продается дом в Шушани
Продается дом в Шушани
Продается дом в Шушани
Продажа
405 000 €
4
280 m²
Показано с 1661 по 1680 из 2068 (всего 104 страниц)
+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
1.0375921726SELECT 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 = '242' AND cp.category_id = p2c.category_id AND p2c.product_id = p.product_id AND p.product_id = pd.product_id GROUP BY p.product_id ORDER BY p.parser ASC, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 1660,20
0.0667378902SELECT 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
0.0578022003SELECT 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
0.0559310913SELECT 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
0.0498318672SELECT 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
0.0436201096SELECT 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
0.0329849720SELECT 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
0.0272099972SELECT 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
0.0230000019SELECT 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
0.0200049877SELECT 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
0.0191099644SELECT 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
0.0189099312DELETE FROM `hm_session` WHERE `expire` < '2025-10-21 23:31:49'
0.0178658962SELECT 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
0.0165979862SELECT 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
0.0146160126SELECT 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
0.0140309334SELECT 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
0.0130779743SELECT 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
0.0114150047SELECT 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
0.0105519295SELECT 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
0.0102560520SELECT 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
0.0101640224SELECT 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
0.0080080032SELECT 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
0.0071260929SELECT 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
0.0057861805SELECT 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
0.0056650639SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35362' AND p.product_id = p2c.product_id
0.0052969456SELECT category_id, parent_id FROM hm_category ORDER BY parent_id
0.0050020218SELECT *, (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 = '35405' 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.0049600601SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35370' AND p.product_id = p2c.product_id
0.0047149658SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=171' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0035390854SELECT 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
0.0034439564SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '35410'
0.0033869743SELECT 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
0.0032510757SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0031499863SELECT *, (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 = '35392' 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.0030510426SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50266'
0.0025629997SELECT 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
0.0022029877SELECT 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
0.0021591187SELECT 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
0.0019650459SELECT 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
0.0017149448SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '41023' AND p.product_id = p2c.product_id
0.0013339520SELECT 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
0.0013279915SELECT * FROM `hm_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
0.0012300014SELECT 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
0.0011870861SELECT 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
0.0009520054SELECT 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
0.0009250641SELECT 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
0.0008258820SELECT 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
0.0008139610SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35402'
0.0007889271SELECT 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
0.0007569790SELECT 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
0.0007560253SELECT 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
0.0007400513SELECT 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
0.0007159710SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35414' AND p.product_id = p2c.product_id
0.0006959438SELECT * 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.0006649494SELECT 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
0.0006570816SELECT *, (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 = '35400' 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.0006189346SELECT 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
0.0006020069SELECT 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
0.0006008148SELECT 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
0.0005910397SELECT 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
0.0005729198SELECT * FROM hm_product_image WHERE product_id = '28026' ORDER BY sort_order ASC
0.0005679131SELECT * 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.0005519390SELECT 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
0.0005149841SELECT *, (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 = '50266' 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.0005121231SELECT *, (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 = '50262' 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.0005118847SELECT 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
0.0005080700SELECT *, (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 = '35410' 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.0005059242SELECT *, (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 = '50239' 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.0005040169SELECT 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
0.0005002022SELECT *, (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 = '35399' 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.0004959106SELECT 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
0.0004909039SELECT 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 = '27004' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0004870892SELECT 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
0.0004839897SELECT 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
0.0004818439SELECT *, (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 = '35413' 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.0004730225SELECT *, (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 = '35402' 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.0004730225SELECT *, (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 = '35389' 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.0004708767SELECT *, (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 = '35371' 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.0004680157SELECT *, (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 = '35417' 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.0004670620SELECT *, (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 = '35363' 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.0004642010SELECT 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
0.0004627705SELECT *, (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 = '35366' 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.0004618168SELECT *, (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 = '50268' 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.0004589558SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35366' AND p.product_id = p2c.product_id
0.0004560947SELECT query FROM hm_seo_url WHERE keyword = 'montenegro' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0004551411SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35395' AND p.product_id = p2c.product_id
0.0004489422SELECT *, (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 = '50272' 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.0004482269SELECT *, (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 = '35378' 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 count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35382' AND p.product_id = p2c.product_id
0.0004370213SELECT *, (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 = '35361' 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.0004370213SELECT 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 = '27984' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0004341602SELECT *, (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 = '50253' 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.0004329681SELECT 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
0.0004291534SELECT *, (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 = '50484' 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.0004248619SELECT *, (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 = '35418' 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 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 = '27909' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0004229546SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=41023' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0004220009SELECT *, (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 = '35394' 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.0004220009SELECT *, (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 = '50485' 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 = '50261' 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.0004200935SELECT *, (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 = '35396' 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.0004198551SELECT *, (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 = '35412' 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 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
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 = '41027' 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 = '41025' 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 = '35379' 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 = '50244' 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.0004150867SELECT 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
0.0004138947SELECT *, (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 = '35377' 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 = '35415' 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 meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50253'
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 = '35422' 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 = '35367' 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 = '35406' 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 = '50271' 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 = '50249' 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.0004079342SELECT *, (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 = '50257' 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 LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=33' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
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 = '50265' 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.0004010201SELECT *, (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 = '50248' 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.0004000664SELECT *, (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 = '35369' 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 = '35401' 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 = '35403' 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 = '50260' 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 = '35360' 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.0003950596SELECT *, (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 = '50269' 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 = '50274' 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 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
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 = '35419' 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 = '50246' 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 = '41028' 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 LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
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 = '35407' 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.0003890991SELECT 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
0.0003829002SELECT *, (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 = '50275' 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 = '50251' 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.0003769398SELECT *, (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 = '50250' 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.0003769398SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0003769398SELECT *, (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 = '41026' 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.0003769398SELECT *, (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 = '35409' 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 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 = '27749' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0003747940SELECT *, (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 = '35372' 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.0003738403SELECT *, (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 = '41024' 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.0003731251SELECT *, (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 = '41029' 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.0003731251SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
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 = '35375' 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 = '35390' 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 = '50252' 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 * FROM hm_product_image WHERE product_id = '28017' ORDER BY sort_order ASC
0.0003681183SELECT 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 = '27966' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
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 = '35381' 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.0003671646SELECT 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 = '27241' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0003669262SELECT 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 = '28000' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
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 = '50254' 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.0003650188SELECT *, (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 = '35376' 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 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
0.0003621578SELECT 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 = '28108' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
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 = '35420' 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 = '50488' 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 = '50273' 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 LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=72' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
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 = '35397' 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 = '50267' 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 = '35384' 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 = '35408' 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 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 = '27914' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
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 = '50264' 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 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 = '28017' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0003528595SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=38' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0003509521SELECT *, (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 = '35395' 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.0003509521SELECT *, (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 = '35386' 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 = '35388' 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 count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '50239' AND p.product_id = p2c.product_id
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 = '35364' 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 *, (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 = '35380' 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.0003430843SELECT *, (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 = '35414' 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 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
0.0003349781SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=138' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0003330708SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35361' AND p.product_id = p2c.product_id
0.0003318787SELECT *, (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 = '35411' 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.0003318787SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=215' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0003299713SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=55' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0003299713SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=195' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
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 = '50263' 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 * FROM hm_product_image WHERE product_id = '27004' ORDER BY sort_order ASC
0.0003249645SELECT *, (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 = '35423' 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.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 = '50487' 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.0003218651SELECT *, (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 = '35385' 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.0003218651SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0003190041SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50261' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0003190041SELECT *, (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 = '35365' 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.0003170967SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=188' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0003161430SELECT *, (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 = '35393' 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 = '50242' 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 = '35391' 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 count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35389' AND p.product_id = p2c.product_id
0.0003139973SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '50253' AND p.product_id = p2c.product_id
0.0003128052SELECT *, (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 = '35383' 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.0003118515SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35417' AND p.product_id = p2c.product_id
0.0003099442SELECT 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
0.0003089905SELECT *, (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 = '35368' 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 = '50247' 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 count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '50261' AND p.product_id = p2c.product_id
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 = '50492' 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 = '35421' 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 * FROM hm_extension WHERE `type` = 'analytics'
0.0003020763SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0003018379SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35371' AND p.product_id = p2c.product_id
0.0003008842SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=55' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
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 = '35373' 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 * FROM `hm_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` 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 = '50490' 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 count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '50272' AND p.product_id = p2c.product_id
0.0002970695SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=55' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002970695SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35419' AND p.product_id = p2c.product_id
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 = '50489' 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.0002961159SELECT *, (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 = '35398' 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.0002939701SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35422' AND p.product_id = p2c.product_id
0.0002920628SELECT *, (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 = '35374' 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.0002908707SELECT 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
0.0002899170SELECT 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
0.0002849102SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='28279' 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.0002810955SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=67' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002789497SELECT 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 = '28097' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002779961SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '50484' AND p.product_id = p2c.product_id
0.0002779961SELECT c.iso_code_2, cd.* FROM hm_category c, hm_category_description cd WHERE c.category_id='242' AND cd.category_id=c.category_id
0.0002779961SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '50271' AND p.product_id = p2c.product_id
0.0002758503SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=271' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002748966SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '50264' AND p.product_id = p2c.product_id
0.0002748966SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002739429SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=56' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002729893SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002720356SELECT * FROM hm_category_path cp, hm_category_description cd WHERE cp.category_id='242' AND cp.level=0 AND cd.category_id=cp.path_id AND cd.language_id='1'
0.0002698898SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35404' AND p.product_id = p2c.product_id
0.0002691746SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '50260' AND p.product_id = p2c.product_id
0.0002689362SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35386' AND p.product_id = p2c.product_id
0.0002679825SELECT 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 = '28279' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002670288SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=221' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002651215SELECT 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 = '27680' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002651215SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50241' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002651215SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=87' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
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 = '28159' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002629757SELECT 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 = '27960' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002601147SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=47' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002598763SELECT 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 = '28167' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002598763SELECT 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
0.0002589226SELECT 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 = '27503' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002589226SELECT * FROM hm_product_image WHERE product_id = '28279' ORDER BY sort_order ASC
0.0002582073SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=44' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002579689SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '35363'
0.0002570152SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=33' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002560616SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35403' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002551079SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=26' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002548695SELECT 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 = '27024' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002548695SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=195' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002539158SELECT 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 = '28026' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002539158SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=33' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002532005SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35397' AND p.product_id = p2c.product_id
0.0002529621SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '35413'
0.0002529621SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50488' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002520084SELECT 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 = '27989' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW()
0.0002520084SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002520084SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002520084SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002520084SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='27004' 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.0002508163SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=9' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002508163SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=51' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002508163SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=9' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002501011SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002501011SELECT 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
0.0002501011SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002501011SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35417' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002498627SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002498627SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=99' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002489090SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=74' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002479553SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=84' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002479553SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '50273' AND p.product_id = p2c.product_id
0.0002479553SELECT 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
0.0002479553SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'information_id=1' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002460480SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=97' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002458096SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=84' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002450943SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50485' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002450943SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='28159' 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.0002448559SELECT c.category_id FROM hm_category_path cp, hm_category c WHERE cp.category_id='242' AND cp.path_id = c.category_id AND c.type=0
0.0002448559SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '50257' AND p.product_id = p2c.product_id
0.0002441406SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=53' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002441406SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002439022SELECT 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
0.0002429485SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '50254' AND p.product_id = p2c.product_id
0.0002429485SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=175' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002429485SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35405' AND p.product_id = p2c.product_id
0.0002419949SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=6' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002419949SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002419949SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=56' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002419949SELECT * FROM hm_product_image WHERE product_id = '27241' ORDER BY sort_order ASC
0.0002419949SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002410412SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=93' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002410412SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=83' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002410412SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35365' AND p.product_id = p2c.product_id
0.0002400875SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=80' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002400875SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=81' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002400875SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=64' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002398491SELECT * FROM hm_product_image WHERE product_id = '27989' ORDER BY sort_order ASC
0.0002391338SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'common/currency/currency' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002391338SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='28097' 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 count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '50488' AND p.product_id = p2c.product_id
0.0002388954SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '50485' AND p.product_id = p2c.product_id
0.0002379417SELECT * 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.0002379417SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35371' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002379417SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002379417SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '10193' AND p.product_id = p2c.product_id
0.0002369881SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002369881SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='27024' 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.0002369881SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=57' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002360344SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '50244' AND p.product_id = p2c.product_id
0.0002360344SELECT * FROM hm_product_image WHERE product_id = '27914' ORDER BY sort_order ASC
0.0002360344SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002350807SELECT * FROM hm_product_image WHERE product_id = '28167' ORDER BY sort_order ASC
0.0002350807SELECT * FROM hm_property_type_description WHERE language_id='1'
0.0002350807SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=271' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002348423SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35416' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002338886SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=62' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002331734SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '3' LIMIT 1
0.0002331734SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35390' AND p.product_id = p2c.product_id
0.0002331734SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=88' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002329350SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=98' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002329350SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002329350SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002319813SELECT * FROM hm_product_image WHERE product_id = '27966' ORDER BY sort_order ASC
0.0002319813SELECT 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
0.0002319813SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=59' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002319813SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=95' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002310276SELECT 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
0.0002310276SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002310276SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=89' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002307892SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=6' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002300739SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35388' AND p.product_id = p2c.product_id
0.0002300739SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35389' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002298355SELECT * FROM hm_product_image WHERE product_id = '28000' ORDER BY sort_order ASC
0.0002291203SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '50268' AND p.product_id = p2c.product_id
0.0002291203SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=81' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002291203SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=96' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002288818SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002279282SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=7' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002279282SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=7' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002279282SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='27966' 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 LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=84' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002269745SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=60' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002260208SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50246' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002260208SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35414' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002260208SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002260208SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002250671SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=86' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002250671SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '35416'
0.0002250671SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=2' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002248287SELECT * FROM hm_product_image WHERE product_id = '27749' ORDER BY sort_order ASC
0.0002241135SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='28000' 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.0002238750SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=99' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002238750SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=215' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002238750SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002238750SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35410'
0.0002231598SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='28279' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0002229214SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='27503' 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.0002219677SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35423' AND p.product_id = p2c.product_id
0.0002219677SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35403' AND p.product_id = p2c.product_id
0.0002219677SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=97' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002219677SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002219677SELECT 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
0.0002210140SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35397' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002210140SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50239'
0.0002210140SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'information_id=3' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002210140SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=87' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002210140SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='27914' 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.0002200603SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35378' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002200603SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=221' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002191067SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002188683SELECT * FROM hm_product_image WHERE product_id = '27024' ORDER BY sort_order ASC
0.0002188683SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002188683SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='27909' 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 LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=54' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002188683SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=41025' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002181530SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='27749' 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.0002179146SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=24' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002179146SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='27989' 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.0002169609SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=74' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002169609SELECT * FROM hm_product_image WHERE product_id = '27984' ORDER BY sort_order ASC
0.0002169609SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='28017' 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.0002169609SELECT * FROM hm_product_image WHERE product_id = '28159' ORDER BY sort_order ASC
0.0002169609SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'information_id=2' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002169609SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=80' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002160072SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='27960' 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 = '18' AND p.product_id = p2c.product_id
0.0002150536SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=41027' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002150536SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=195' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002150536SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002150536SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=62' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002150536SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=186' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002148151SELECT 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
0.0002140999SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35392' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002140999SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002140999SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=93' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002140999SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35362' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002140999SELECT 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
0.0002138615SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='28108' 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.0002138615SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002131462SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=53' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002131462SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002131462SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='27960' 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.0002131462SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='28026' 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.0002129078SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50239' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002129078SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002129078SELECT 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
0.0002129078SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='28159' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0002121925SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002119541SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='28026' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0002119541SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=63' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002119541SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002119541SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002119541SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=40' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002119541SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=170' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002110004SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=41024' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002110004SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '50248' AND p.product_id = p2c.product_id
0.0002110004SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='27241' 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.0002110004SELECT * FROM hm_product_image WHERE product_id = '27909' ORDER BY sort_order ASC
0.0002110004SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002100468SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002100468SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=214' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002100468SELECT 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
0.0002098083SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=67' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002098083SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002090931SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='27984' 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.0002090931SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='27004' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0002090931SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=64' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002090931SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002090931SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50260' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002088547SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=47' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002088547SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002088547SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50266' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002088547SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002088547SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002081394SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50272' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002079010SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35361' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002079010SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002071857SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002071857SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35402' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002071857SELECT 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
0.0002069473SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002069473SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35410' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002069473SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35406' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002069473SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=43' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002069473SELECT 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
0.0002069473SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35394' AND p.product_id = p2c.product_id
0.0002059937SELECT 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
0.0002059937SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=96' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002059937SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002059937SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002059937SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35399' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002059937SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=271' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002059937SELECT 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
0.0002050400SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002050400SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35375' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002050400SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35384' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002050400SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002050400SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=231' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002050400SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=95' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002048016SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50262'
0.0002048016SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35407' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002040863SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=81' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002040863SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='27680' 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.0002038479SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=72' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002038479SELECT 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
0.0002038479SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35422' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002038479SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35370' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002038479SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002031326SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35400' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002031326SELECT 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
0.0002031326SELECT * FROM hm_currency WHERE code='EUR'
0.0002031326SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35415' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002028942SELECT * FROM hm_product_image WHERE product_id = '28108' ORDER BY sort_order ASC
0.0002028942SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35407' AND p.product_id = p2c.product_id
0.0002028942SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35404' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002028942SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35385' AND p.product_id = p2c.product_id
0.0002028942SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002019405SELECT 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
0.0002019405SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=63' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002009869SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=39' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002009869SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35369' AND p.product_id = p2c.product_id
0.0002009869SELECT 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
0.0002009869SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=54' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002009869SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=170' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002009869SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35418' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002009869SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35364' AND p.product_id = p2c.product_id
0.0002009869SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35402' AND p.product_id = p2c.product_id
0.0002009869SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=250' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002009869SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002000332SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002000332SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=217' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002000332SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35398' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002000332SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=51' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002000332SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=83' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0002000332SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=56' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001997948SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='27984' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001997948SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35392' AND p.product_id = p2c.product_id
0.0001997948SELECT 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
0.0001997948SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=147' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001990795SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001990795SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=161' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001990795SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001990795SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35363' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001990795SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35382' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001981258SELECT 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
0.0001981258SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=190' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001981258SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001981258SELECT 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
0.0001978874SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=246' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001978874SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001978874SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35413' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001978874SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=214' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001978874SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=24' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001978874SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '50266'
0.0001971722SELECT 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
0.0001971722SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001971722SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35362'
0.0001971722SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35383' AND p.product_id = p2c.product_id
0.0001969337SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=173' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001969337SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'information_id=4' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001969337SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50274' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001969337SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=243' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001969337SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=36' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001969337SELECT 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
0.0001962185SELECT 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
0.0001959801SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35423' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001959801SELECT 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
0.0001959801SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35372' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001959801SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=88' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001959801SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='27914' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001959801SELECT 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
0.0001959801SELECT 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
0.0001959801SELECT 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
0.0001950264SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001950264SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001950264SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'information/contact' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001950264SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=222' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001950264SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35412' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001950264SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35381' AND p.product_id = p2c.product_id
0.0001950264SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=239' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001950264SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=43' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001950264SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35365' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001950264SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=2' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001950264SELECT * FROM hm_product_image WHERE product_id = '28097' ORDER BY sort_order ASC
0.0001947880SELECT 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
0.0001940727SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=220' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001940727SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=28' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001940727SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=175' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001940727SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=168' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001940727SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=40' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001940727SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001940727SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001940727SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001940727SELECT 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
0.0001931190SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=2' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001931190SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001931190SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'product_id=27960' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001928806SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=166' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001928806SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='28000' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001928806SELECT 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
0.0001928806SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001921654SELECT 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
0.0001921654SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001919270SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=80' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001919270SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd, hm_category c WHERE pc.product_id='28167' 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.0001919270SELECT 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
0.0001909733SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=21' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001909733SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=161' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001909733SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001909733SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001909733SELECT * FROM hm_product_image WHERE product_id = '27960' ORDER BY sort_order ASC
0.0001909733SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '35387'
0.0001909733SELECT 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
0.0001909733SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='27680' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001909733SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='28017' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001909733SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001909733SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001909733SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='27909' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001900196SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=225' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001900196SELECT 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
0.0001900196SELECT 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
0.0001900196SELECT 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
0.0001900196SELECT * FROM hm_category_description WHERE language_id='1' AND category_id='242'
0.0001900196SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=238' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001900196SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=63' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001900196SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001900196SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='27241' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001900196SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001897812SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=86' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001897812SELECT * FROM hm_category_description WHERE category_id='242' AND language_id='1'
0.0001897812SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35389'
0.0001890659SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=153' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001890659SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50484' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001890659SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=215' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001890659SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35394' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001890659SELECT 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
0.0001890659SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001890659SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50273' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001888275SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=53' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001881123SELECT 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
0.0001881123SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001881123SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50260'
0.0001881123SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001881123SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35384' AND p.product_id = p2c.product_id
0.0001881123SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35401' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001878738SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001878738SELECT 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
0.0001878738SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=231' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001878738SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'product/compare' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001878738SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=59' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001871586SELECT 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
0.0001871586SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=225' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001871586SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=195' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001869202SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50257' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001869202SELECT 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
0.0001869202SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001862049SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'product_id=27984' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001862049SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=14' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001859665SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001859665SELECT 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
0.0001859665SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '50246'
0.0001859665SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=162' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001859665SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=171' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001859665SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=213' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001859665SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001859665SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=27' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001859665SELECT 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
0.0001859665SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=230' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001859665SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35417'
0.0001859665SELECT 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
0.0001859665SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35411' AND p.product_id = p2c.product_id
0.0001850128SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35387' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001850128SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=6' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001850128SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001850128SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35401' AND p.product_id = p2c.product_id
0.0001850128SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='27024' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001850128SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=190' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001850128SELECT 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
0.0001850128SELECT 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
0.0001850128SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '50487' AND p.product_id = p2c.product_id
0.0001850128SELECT 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
0.0001850128SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50265' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001850128SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35370'
0.0001850128SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=193' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001850128SELECT 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
0.0001850128SELECT 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
0.0001847744SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='28097' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001847744SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=89' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001840591SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=172' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001840591SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001840591SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35396' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001840591SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35409' AND p.product_id = p2c.product_id
0.0001840591SELECT 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
0.0001840591SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=204' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001840591SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='27503' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001840591SELECT 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
0.0001840591SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=154' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001840591SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '35400'
0.0001840591SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'information_id=13' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001840591SELECT 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
0.0001840591SELECT 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
0.0001831055SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001831055SELECT 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
0.0001831055SELECT 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
0.0001831055SELECT 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
0.0001831055SELECT 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
0.0001828671SELECT 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
0.0001828671SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=219' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001828671SELECT 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
0.0001828671SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=229' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001828671SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '35378'
0.0001828671SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35419' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001821518SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=208' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001821518SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=250' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001821518SELECT 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
0.0001821518SELECT 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
0.0001821518SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35375' AND p.product_id = p2c.product_id
0.0001821518SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='27989' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001821518SELECT 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
0.0001821518SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35420' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001819134SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=245' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001819134SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='27966' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001819134SELECT 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
0.0001819134SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'account/account' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001819134SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=14' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001819134SELECT 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
0.0001819134SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=172' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001819134SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '50492' AND p.product_id = p2c.product_id
0.0001819134SELECT 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
0.0001819134SELECT 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
0.0001811981SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='27749' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001811981SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001809597SELECT 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
0.0001809597SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=41029' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001809597SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'account/transaction' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001809597SELECT 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
0.0001809597SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=102' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 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
0.0001809597SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=246' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001809597SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '50265'
0.0001809597SELECT * FROM hm_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
0.0001800060SELECT 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
0.0001800060SELECT 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
0.0001800060SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'common/language/language' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001800060SELECT 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
0.0001800060SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35376' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001800060SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=38' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001800060SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '35420'
0.0001800060SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=60' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001800060SELECT 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
0.0001800060SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35390' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001800060SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001800060SELECT 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
0.0001800060SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'product_id=27024' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001800060SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001800060SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=39' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001800060SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=220' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001800060SELECT 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
0.0001800060SELECT 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
0.0001797676SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=22' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001790524SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35409' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001790524SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=203' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001790524SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=105' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001790524SELECT 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
0.0001790524SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '35376'
0.0001790524SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=41028' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001790524SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001790524SELECT 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
0.0001790524SELECT 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
0.0001790524DELETE FROM hm_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
0.0001788139SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50272'
0.0001788139SELECT * FROM hm_layout_module WHERE layout_id = '3' AND position = 'column_left' ORDER BY sort_order
0.0001788139SELECT 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
0.0001788139SELECT * 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.0001788139SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50248' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001788139SELECT 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
0.0001788139SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35371'
0.0001788139SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50254' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001780987SELECT 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
0.0001780987SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35379' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001780987SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50251' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001780987SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='28108' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001780987SELECT 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
0.0001780987SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=215' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001780987SELECT 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
0.0001780987SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001778603SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=107' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001778603SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=160' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001778603SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=203' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001778603SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '50251'
0.0001771450SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=163' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001771450SELECT * FROM hm_layout_module WHERE layout_id = '3' AND position = 'column_right' ORDER BY sort_order
0.0001771450SELECT 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
0.0001771450SELECT cd.name FROM hm_product_to_category pc, hm_category_description cd WHERE pc.product_id='28167' AND pc.main_category='1' AND cd.category_id=pc.category_id AND cd.language_id='1'
0.0001771450SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001771450SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35398' AND p.product_id = p2c.product_id
0.0001771450SELECT 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
0.0001771450SELECT 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
0.0001771450SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001771450SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001769066SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=17' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001769066SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35367' AND p.product_id = p2c.product_id
0.0001769066SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=141' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001769066SELECT 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
0.0001769066SELECT 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
0.0001769066SELECT 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
0.0001761913SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001761913SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '35406'
0.0001761913SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50269' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001761913SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50250' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001759529SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=213' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001759529SELECT * FROM hm_layout_module WHERE layout_id = '3' AND position = 'content_bottom' ORDER BY sort_order
0.0001759529SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '50242' AND p.product_id = p2c.product_id
0.0001759529SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35396' AND p.product_id = p2c.product_id
0.0001759529SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35386' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001759529SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001759529SELECT 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
0.0001759529SELECT category_id FROM hm_product_to_category WHERE product_id = '27984' ORDER BY main_category DESC LIMIT 1
0.0001759529SELECT 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
0.0001759529SELECT category_id FROM hm_product_to_category WHERE product_id = '28159' ORDER BY main_category DESC LIMIT 1
0.0001759529SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=26' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001749992SELECT 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
0.0001749992SELECT 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
0.0001749992SELECT 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
0.0001749992SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '50247' AND p.product_id = p2c.product_id
0.0001749992SELECT 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
0.0001749992SELECT 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
0.0001749992SELECT 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
0.0001749992SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=44' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001749992SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35360' AND p.product_id = p2c.product_id
0.0001749992SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=167' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001749992SELECT 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
0.0001749992SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=41026' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001749992SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'product_id=27989' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001749992SELECT 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
0.0001749992SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '50490' AND p.product_id = p2c.product_id
0.0001749992SELECT 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
0.0001749992SELECT 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
0.0001749992SELECT 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
0.0001749992SELECT * FROM hm_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
0.0001749992SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=166' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001749992SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001749992SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=245' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001749992SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=18' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001749992SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001749992SELECT 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
0.0001740456SELECT 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
0.0001740456SELECT 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
0.0001740456SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'product_id=27909' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001740456SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001740456SELECT 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
0.0001740456SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001740456SELECT 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
0.0001740456SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=19' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001740456SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '50240'
0.0001740456SELECT 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
0.0001740456SELECT 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
0.0001740456SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'product_id=27966' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001738071SELECT 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
0.0001738071SELECT 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
0.0001738071SELECT 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
0.0001730919SELECT * FROM hm_layout_module WHERE layout_id = '3' AND position = 'content_top' ORDER BY sort_order
0.0001730919SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'product_id=27241' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001730919SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50245' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001730919SELECT 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
0.0001730919SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50240' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001730919SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=134' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001730919SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=2' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001730919SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35418' AND p.product_id = p2c.product_id
0.0001730919SELECT 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
0.0001730919SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35395' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001728535SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35401'
0.0001728535SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=15' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001728535SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001728535SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=188' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001728535SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'product_id=27004' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001728535SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'product_id=28159' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001728535SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=18' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001728535SELECT 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
0.0001721382SELECT 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
0.0001721382SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=150' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001721382SELECT 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
0.0001721382SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=156' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001721382SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='41023'
0.0001721382SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '50263' AND p.product_id = p2c.product_id
0.0001721382SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35366' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001718998SELECT 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
0.0001718998SELECT 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
0.0001718998SELECT 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
0.0001718998SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=154' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001718998SELECT 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
0.0001711845SELECT 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
0.0001711845SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001711845SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=56' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001709461SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=217' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001709461SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '50269'
0.0001709461SELECT 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
0.0001709461SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=219' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001709461SELECT 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
0.0001709461SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35364' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001709461SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50490' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001709461SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=105' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001709461SELECT 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
0.0001709461SELECT 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
0.0001709461SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001709461SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001709461SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'information_id=1' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001699924SELECT 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
0.0001699924SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '35399'
0.0001699924SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=27' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001699924SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35411' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001699924SELECT 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
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
0.0001699924SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=139' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001699924SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50487' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001699924SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35373' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001699924SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=173' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001699924SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=100' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001699924SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50492' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001699924SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001699924SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50263' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001699924SELECT 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
0.0001699924SELECT 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
0.0001699924SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=108' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001690388SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001690388SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'product_id=27914' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001690388SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=238' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001690388SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001690388SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001690388SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '50267'
0.0001690388SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=204' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001690388SELECT 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
0.0001690388SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'product_id=28167' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001690388SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=209' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001690388SELECT 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
0.0001690388SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50265'
0.0001690388SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001690388SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'account/logout' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001690388SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=193' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001690388SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=101' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001690388SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001690388SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35380' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001690388SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35379' AND p.product_id = p2c.product_id
0.0001690388SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001690388SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=230' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001690388SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=16' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001690388SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=229' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001690388SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '50274'
0.0001688004SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001688004SELECT 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
0.0001688004SELECT 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
0.0001688004SELECT 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
0.0001680851SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '50489' AND p.product_id = p2c.product_id
0.0001680851SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=13' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001680851SELECT * FROM hm_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
0.0001680851SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'information_id=16' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001680851SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'product_id=27503' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001680851SELECT * FROM hm_layout_route WHERE 'product/category' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
0.0001680851SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '35415'
0.0001680851SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35383' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001680851SELECT 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
0.0001680851SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50489' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001680851SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001680851SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=165' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001678467SELECT 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
0.0001678467SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=164' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001678467SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=123' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001678467SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=132' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001678467SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35397'
0.0001678467SELECT 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
0.0001671314SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50253' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001671314SELECT 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
0.0001671314SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '35372'
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
0.0001671314SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '50262'
0.0001671314SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'account/wishlist' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001671314SELECT 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
0.0001671314SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'information_id=15' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001671314SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'information_id=10' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001671314SELECT 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
0.0001671314SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001671314SELECT 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
0.0001668930SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001668930SELECT 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
0.0001668930SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=147' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001668930SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=167' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001668930SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=28' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001668930SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50268' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001668930SELECT 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
0.0001668930SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=10' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001668930SELECT category_id FROM hm_product_to_category WHERE product_id = '27909' ORDER BY main_category DESC LIMIT 1
0.0001668930SELECT 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
0.0001668930SELECT 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
0.0001668930SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=184' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001668930SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50267' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001668930SELECT 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
0.0001661777SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=30' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001661777SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001661777SELECT 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
0.0001661777SELECT * FROM hm_product_image WHERE product_id = '27503' ORDER BY sort_order ASC
0.0001659393SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001659393SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=110' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001659393SELECT 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
0.0001659393SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=221' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001659393SELECT 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
0.0001659393SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001659393SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35381' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001659393SELECT 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
0.0001659393SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001659393SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35388' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001652241SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001649857SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=208' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001649857SELECT `data` FROM `hm_session` WHERE `session_id` = 'a0ddd68cbf9a7b091a5b19875c' AND `expire` > '2025-10-21 23:31:49'
0.0001649857SELECT 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
0.0001649857SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35408' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001649857SELECT 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
0.0001649857SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=3' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001649857SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35366'
0.0001649857SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001649857SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50485'
0.0001649857SELECT 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
0.0001649857SELECT 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
0.0001649857SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35377' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001649857SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=22' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001649857SELECT 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
0.0001649857SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '41027'
0.0001649857SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001649857SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'product_id=28108' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001649857SELECT 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
0.0001640320SELECT 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
0.0001640320SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001640320SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '41024'
0.0001640320SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35378'
0.0001640320SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001640320SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=114' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001640320SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001640320SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=36' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001640320SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
0.0001640320SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'account/order' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001640320SELECT 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
0.0001640320SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50262' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001640320SELECT 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
0.0001640320SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=98' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001640320SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=104' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001640320SELECT category_id FROM hm_product_to_category WHERE product_id = '28108' ORDER BY main_category DESC LIMIT 1
0.0001640320SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'information_id=8' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001640320SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
0.0001640320SELECT 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
0.0001630783SELECT 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
0.0001630783SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=163' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001630783SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35403'
0.0001630783SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'product_id=28097' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001630783SELECT 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
0.0001630783SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35360' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001630783SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=145' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001630783SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001630783SELECT 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
0.0001630783SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
0.0001621246SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35406'
0.0001621246SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '50250'
0.0001621246SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35394'
0.0001621246SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=164' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001621246SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35393' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001621246SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001621246SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001618862SELECT 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
0.0001618862SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=118' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001618862SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '50249'
0.0001618862SELECT 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
0.0001618862SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35421' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001618862SELECT 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
0.0001618862SELECT category_id FROM hm_product_to_category WHERE product_id = '28026' ORDER BY main_category DESC LIMIT 1
0.0001618862SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35367' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001611710SELECT 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
0.0001611710SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=186' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001611710SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=103' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001611710SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35393' AND p.product_id = p2c.product_id
0.0001611710SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001611710SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001611710SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=109' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001611710SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50248'
0.0001611710SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=134' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001611710SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru')
0.0001609325SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50252' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001609325SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001609325SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=184' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001609325SELECT category_id FROM hm_product_to_category WHERE product_id = '27989' ORDER BY main_category DESC LIMIT 1
0.0001609325SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=57' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001609325SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=12' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001609325SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'product_id=27749' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001609325SELECT 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
0.0001609325SELECT 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
0.0001609325SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'product_id=28000' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001602173SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50241'
0.0001599789SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001599789SELECT 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
0.0001599789SELECT 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
0.0001599789SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=136' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001599789SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '41029'
0.0001599789SELECT 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
0.0001599789SELECT 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
0.0001599789SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'account/logout' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001599789SELECT * FROM hm_product_image WHERE product_id = '27680' ORDER BY sort_order ASC
0.0001599789SELECT 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
0.0001599789SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=11' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001599789SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50244'
0.0001599789SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'information_id=12' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001599789SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '50245'
0.0001590252SELECT 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
0.0001590252SELECT 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
0.0001590252SELECT 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
0.0001590252SELECT 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
0.0001590252SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=117' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001590252SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001590252SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50254'
0.0001590252SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'product_id=28017' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001590252SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001590252SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35405' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001590252SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '50241'
0.0001590252SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='41027'
0.0001580715SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=17' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001580715SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=168' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001580715SELECT 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
0.0001580715SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '35408'
0.0001580715SELECT 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
0.0001580715SELECT 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
0.0001580715SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=106' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001580715SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50246'
0.0001580715SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'information_id=2' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001578331SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001578331SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'product_id=28279' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001578331SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35421' AND p.product_id = p2c.product_id
0.0001578331SELECT 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
0.0001571178SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'information_id=11' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001571178SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'information_id=17' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001571178SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=170' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001571178SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=104' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001571178SELECT 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
0.0001568794SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35368' AND p.product_id = p2c.product_id
0.0001568794SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35368' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001568794SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50273'
0.0001568794SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'information_id=14' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001568794SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35399'
0.0001568794SELECT 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
0.0001568794SELECT category_id FROM hm_product_to_category WHERE product_id = '27960' ORDER BY main_category DESC LIMIT 1
0.0001568794SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'information_id=4' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001561642SELECT 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
0.0001561642SELECT category_id FROM hm_product_to_category WHERE product_id = '27004' 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 = '62' AND p.product_id = p2c.product_id
0.0001561642SELECT 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
0.0001561642SELECT 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
0.0001561642SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=0' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001559258SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'account/register' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001559258SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=16' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001559258SELECT 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
0.0001559258SELECT 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
0.0001559258SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '35380'
0.0001559258SELECT 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
0.0001559258SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50247' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001552105SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50249' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001552105SELECT 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
0.0001549721SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50484'
0.0001549721SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=150' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001549721SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '35412'
0.0001549721SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=14' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001549721SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=19' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001549721SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=138' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001549721SELECT * FROM hm_currency WHERE code='EUR'
0.0001549721SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=129' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001549721SELECT 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
0.0001549721SELECT 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
0.0001549721SELECT 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
0.0001540184SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=189' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001540184SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001540184SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=114' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001540184SELECT 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
0.0001540184SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=209' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001540184SELECT 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
0.0001540184SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=239' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001540184SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=122' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001540184SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=162' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001540184SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=30' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001540184SELECT 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
0.0001540184SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35369' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001540184SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'account/account' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001540184SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'account/login' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001540184SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35363'
0.0001540184SELECT 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
0.0001540184SELECT 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
0.0001540184SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35400'
0.0001537800SELECT 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
0.0001530647SELECT 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
0.0001530647SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=160' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001530647SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=223' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001530647SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=130' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001530647SELECT 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
0.0001530647SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35379'
0.0001530647SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=145' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001530647SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'information_id=3' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001530647SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '50252'
0.0001528263SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=142' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001528263SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50259' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001528263SELECT category_id FROM hm_product_to_category WHERE product_id = '27024' ORDER BY main_category DESC LIMIT 1
0.0001528263SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=165' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001528263SELECT 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
0.0001528263SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=100' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001528263SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=189' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001521111SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35381'
0.0001521111SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '50258'
0.0001521111SELECT category_id FROM hm_product_to_category WHERE product_id = '28000' ORDER BY main_category DESC LIMIT 1
0.0001521111SELECT 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
0.0001521111SELECT category_id FROM hm_product_to_category WHERE product_id = '27966' ORDER BY main_category DESC LIMIT 1
0.0001521111SELECT 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
0.0001518726SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '50255'
0.0001518726SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'product_id=28026' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001518726SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'product/category'
0.0001518726SELECT category_id FROM hm_product_to_category WHERE product_id = '28017' ORDER BY main_category DESC LIMIT 1
0.0001518726SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001518726SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=139' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001518726SELECT category_id FROM hm_product_to_category WHERE product_id = '27914' ORDER BY main_category DESC LIMIT 1
0.0001518726SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '41026'
0.0001518726SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35364'
0.0001518726SELECT 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
0.0001518726SELECT * FROM hm_currency WHERE code='EUR'
0.0001511574SELECT * FROM hm_currency WHERE code='EUR'
0.0001511574SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35419'
0.0001511574SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35361'
0.0001511574SELECT 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
0.0001511574SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001509190SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=3' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001509190SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50257'
0.0001509190SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35414'
0.0001509190SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '50256'
0.0001509190SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35416'
0.0001509190SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50251'
0.0001509190SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50488'
0.0001509190SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35374' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001502037SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35384'
0.0001499653SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=124' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001499653SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=223' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001499653SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=123' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001499653SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35385' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001499653SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50269'
0.0001499653SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=144' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001490116SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50240'
0.0001490116SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '50275'
0.0001490116SELECT category_id FROM hm_product_to_category WHERE product_id = '27680' ORDER BY main_category DESC LIMIT 1
0.0001490116SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'information_id=9' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001490116SELECT * FROM hm_currency WHERE code='EUR'
0.0001487732SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35382'
0.0001480579SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50271' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001480579SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35405'
0.0001480579SELECT category_id FROM hm_product_to_category WHERE product_id = '27749' ORDER BY main_category DESC LIMIT 1
0.0001480579SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '35373'
0.0001480579SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=141' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001480579SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=10' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001480579SELECT 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
0.0001480579SELECT 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
0.0001480579SELECT category_id FROM hm_product_to_category WHERE product_id = '28167' ORDER BY main_category DESC LIMIT 1
0.0001478195SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50245'
0.0001478195SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35422'
0.0001478195SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=109' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001471043SELECT 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
0.0001471043SELECT category_id FROM hm_product_to_category WHERE product_id = '27241' ORDER BY main_category DESC LIMIT 1
0.0001471043SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=12' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001468658SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=117' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001461506SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=142' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001461506SELECT category_id FROM hm_product_to_category WHERE product_id = '28279' ORDER BY main_category DESC LIMIT 1
0.0001461506SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35392'
0.0001461506SELECT 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
0.0001459122SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'product_id=27680' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001459122SELECT 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
0.0001459122SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50255' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001459122SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50271'
0.0001459122SELECT 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
0.0001451969SELECT category_id FROM hm_product_to_category WHERE product_id = '27503' ORDER BY main_category DESC LIMIT 1
0.0001449585SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=103' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001449585SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=130' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001449585SELECT 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
0.0001449585SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35415'
0.0001449585SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '41025'
0.0001440048SELECT category_id FROM hm_product_to_category WHERE product_id = '28097' ORDER BY main_category DESC LIMIT 1
0.0001440048SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50244' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001440048SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=106' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001440048SELECT * FROM hm_currency
0.0001440048SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=102' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001437664SELECT * FROM hm_currency WHERE code='EUR'
0.0001430511SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=132' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001430511SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')
0.0001430511SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '41028'
0.0001430511SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'common/footer'
0.0001430511SELECT 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
0.0001428127SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=124' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001428127SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50258' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001428127SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='41029'
0.0001428127SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/nice' OR route = 'ru-ru')
0.0001428127SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35385'
0.0001420975SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50249'
0.0001420975SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35365'
0.0001420975SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50268'
0.0001420975SELECT 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
0.0001420975SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50264' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001420975SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=101' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001418591SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=171' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001418591SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=105' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001418591SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50264'
0.0001411438SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50256' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001411438SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35393'
0.0001409054SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50275' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001409054SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'common/menu_footer'
0.0001399517SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='41024'
0.0001399517SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35390'
0.0001399517SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/menu' OR route = 'ru-ru')
0.0001399517SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '35377'
0.0001399517SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35377'
0.0001389980SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35386'
0.0001389980SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=35391' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001389980SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=144' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001389980SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=50242' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001389980SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=110' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001389980SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35372'
0.0001389980SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35388'
0.0001380444SELECT count(p.product_id) AS total FROM hm_product p, hm_product_to_category p2c WHERE p2c.category_id = '35391' AND p.product_id = p2c.product_id
0.0001380444SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35407'
0.0001380444SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35395'
0.0001380444SELECT 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
0.0001380444SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/menu' OR route = 'ru-ru')
0.0001370907SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=21' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001370907SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='41028'
0.0001370907SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50259'
0.0001370907SELECT 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
0.0001370907SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50247'
0.0001368523SELECT * FROM hm_category_to_layout WHERE category_id = '242' AND store_id = '0'
0.0001368523SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/nice' OR route = 'ru-ru')
0.0001368523SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='41026'
0.0001361370SELECT * FROM hm_currency WHERE code='EUR'
0.0001358986SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=11' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001358986SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'product/manufacturer' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001358986SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35413'
0.0001349449SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35367'
0.0001349449SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'common/currency'
0.0001349449SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/captcha/google' OR route = 'ru-ru')
0.0001349449SELECT 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
0.0001349449SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50258'
0.0001349449SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35408'
0.0001349449SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35412'
0.0001349449SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=108' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001342297SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35380'
0.0001339912SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50250'
0.0001339912SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '50259'
0.0001339912SELECT 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
0.0001330376SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='41025'
0.0001330376SELECT * FROM hm_module WHERE module_id = '39'
0.0001330376SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=13' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001330376SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35375'
0.0001330376SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50255'
0.0001330376SELECT * FROM hm_category_to_layout WHERE category_id = '242' AND store_id = '0'
0.0001330376SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=15' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001330376SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35409'
0.0001330376SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=136' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001330376SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/category' OR route = 'ru-ru')
0.0001330376SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=118' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001330376SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35418'
0.0001327991SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35420'
0.0001320839SELECT 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
0.0001320839SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35391'
0.0001318455SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'information/contact' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001318455SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50267'
0.0001318455SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=243' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001311302SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'product/compare' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001311302SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50252'
0.0001311302SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'information/sitemap' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001311302SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'product/special' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001311302SELECT * FROM hm_currency WHERE code='EUR'
0.0001308918SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=222' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001308918SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'common/language'
0.0001301765SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'extension/captcha/google'
0.0001299381SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35383'
0.0001299381SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35411'
0.0001299381SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50274'
0.0001299381SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35396'
0.0001292229SELECT * FROM hm_currency WHERE code='EUR'
0.0001289845SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35398'
0.0001289845SELECT 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
0.0001289845SELECT count(*) counts FROM hm_product_to_category WHERE category_id = '35374'
0.0001280308SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35376'
0.0001280308SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'common/menu_top'
0.0001280308SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'common/header'
0.0001280308SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50261'
0.0001280308SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35360'
0.0001280308SELECT * FROM hm_currency WHERE code='EUR'
0.0001277924SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50263'
0.0001277924SELECT * FROM hm_currency WHERE code='EUR'
0.0001270771SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50256'
0.0001270771SELECT * FROM hm_currency WHERE code='EUR'
0.0001270771SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50275'
0.0001268387SELECT 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
0.0001261234SELECT * FROM hm_category_to_layout WHERE category_id = '242' AND store_id = '0'
0.0001261234SELECT * FROM hm_currency WHERE code='EUR'
0.0001258850SELECT * FROM hm_currency WHERE code='EUR'
0.0001258850SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50487'
0.0001251698SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50490'
0.0001251698SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35423'
0.0001251698SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50492'
0.0001249313SELECT * FROM hm_currency WHERE code='EUR'
0.0001249313SELECT 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
0.0001249313SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50242'
0.0001242161SELECT * FROM hm_currency WHERE code='EUR'
0.0001239777SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=107' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001239777SELECT 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
0.0001239777SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'account/newsletter' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001239777SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35404'
0.0001239777SELECT * FROM hm_currency WHERE code='EUR'
0.0001239777SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35421'
0.0001230240SELECT * FROM hm_currency WHERE code='EUR'
0.0001230240SELECT * FROM hm_currency WHERE code='EUR'
0.0001230240SELECT * FROM hm_category_to_layout WHERE category_id = '242' AND store_id = '0'
0.0001230240SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35368'
0.0001230240SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=156' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001230240SELECT * FROM hm_currency WHERE code='EUR'
0.0001230240SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35373'
0.0001230240SELECT 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
0.0001230240SELECT * FROM hm_currency WHERE code='EUR'
0.0001220703SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='50489'
0.0001220703SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35387'
0.0001211166SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=129' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001201630SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=153' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001199245SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/recently_viewed' OR route = 'ru-ru')
0.0001189709SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35369'
0.0001180172SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'category_id=122' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001170635SELECT meta_h1 FROM hm_category_description cd WHERE cd.language_id=2 AND cd.category_id='35374'
0.0001168251SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'affiliate/login' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001168251SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'account/order' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001161098SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'information/tracking' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001151562SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'account/account' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001149178SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'common/column_left'
0.0001149178SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru')
0.0001142025SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'common/column_right'
0.0001130104SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'account/wishlist' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001130104SELECT * FROM hm_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/nice' OR route = 'ru-ru')
0.0001108646SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'account/return/add' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001101494SELECT LCASE(keyword) as keyword FROM hm_seo_url WHERE query = 'account/voucher' /*AND store_id = '0'*/ AND language_id = '1' LIMIT 1
0.0001099110SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'common/content_top'
0.0001080036SELECT * FROM hm_theme WHERE store_id = '0' AND theme = 'nice' AND route = 'common/content_bottom'
0.0000820160SET time_zone = '+03:00'
0.0000650883SET time_zone = '+00:00'

event

0.0039196013event/translation (14 action)
0.0030808448event/theme (12 action)
0.0022253989event/language (40 action)

startup

2.0765500069startup/router (1 action)
0.0207970142startup/seo_url (1 action)
0.0037899017startup/startup (1 action)
0.0006909370startup/event (1 action)
0.0002648830startup/session (1 action)
0.0000669956startup/error (1 action)
0.0000588894startup/maintenance (1 action)

common

0.2939019203common/header (1 action)
0.2803001404common/menu_top (1 action)
0.2059071064common/footer (1 action)
0.0059618950common/menu_footer (1 action)
0.0022408962common/column_left (1 action)
0.0021259785common/currency (1 action)
0.0019381046common/content_bottom (1 action)
0.0017721653common/language (1 action)
0.0011918545common/column_right (1 action)
0.0011768341common/content_top (1 action)

extension

0.0012857914extension/captcha/google (1 action)
0.0009491444extension/module/langdir (1 action)
0.0003998280extension/module/recently_viewed (1 action)

product

2.0761659145product/category (1 action)