+7 (727) 310-02-31
тг.

Поиск



Товары, соответствующие критериям поиска

Очищающий массажер для лица Xiaomi WellSkins Ultrasonic Cleansing Shovel

20213 тг. 21143 тг.

Очищающий массажер для лица Xiaomi WellSkins Ultrasonic Cleansing Shovel

Статус: Есть в наличии

Артикул: 6971

Компания Xiaomi продолжает выпускать различные гаджеты для красоты и здоровья - в этот раз компан..

Портативный массажер XiaoMi Yarrasonic RF Body Shaper

60480 тг. 63262 тг.

Портативный массажер XiaoMi Yarrasonic RF Body Shaper

Статус: Есть в наличии

Артикул: 6980

Четыре режима работы, шесть регулировок мощности, удобная ручка и корпус с защитой от влаги. ..

Сменная насадка для зубной щеки Dr. B Sonic Electric Brush Head

2880 тг. 3012 тг.

Сменная насадка для зубной щеки Dr. B Sonic Electric Brush Head

Статус: Есть в наличии

Артикул: 6421

Сменная насадка для зубной щеки Dr. B Sonic Electric Brush Head (поставляются в количестве 2х шту..

Сменная насадка для зубной щетки Xiaomi Mijia Sonic Electric Toothbrush T100, 3 шт

4128 тг. 4318 тг.

Сменная насадка для зубной щетки Xiaomi Mijia Sonic Electric Toothbrush T100, 3 шт

Статус: Есть в наличии

Артикул: 6881

Сменная насадка для зубной щетки Xiaomi Mijia Sonic Electric Toothbrush T100 состоит из мягких и ..

Сменные насадки для зубной щетки (3 штуки) XiaoMi Mijia Sonic Electric Toothbrush T100 White

2400 тг. 2510 тг.

Сменные насадки для зубной щетки (3 штуки) XiaoMi Mijia Sonic Electric Toothbrush T100 White

Статус: Есть в наличии

Артикул: 7049

Для здоровья Ваших зубов, стоматологи рекомендуют заменять зубную щетку каждые 2 месяца. Если Вы ..

Ультразвуковой скрабер для лица Xiaomi Inface Ultrasonic Ion Skin cleanser MS7100

16800 тг. 17573 тг.

Ультразвуковой скрабер для лица Xiaomi Inface Ultrasonic Ion Skin cleanser MS7100

Статус: Есть в наличии

Артикул: 6837

В последнее время все большую популярность приобретают различные бьюти-гаджеты для домашнего уход..

Электрическая зубная щетка Xiaomi Mijia Sonic Electric Toothbrush T302

16224 тг. 16970 тг.

Электрическая зубная щетка Xiaomi Mijia Sonic Electric Toothbrush T302

Статус: Есть в наличии

Артикул: 7330

Электрическая зубная щетка Mijia Sonic Electric Toothbrush T302 от Xiaomi представляет собой авто..

Электрическая зубная щетка Xiaomi Mijia Sonic Electric Toothbrush T700

25920 тг. 27112 тг.

Электрическая зубная щетка Xiaomi Mijia Sonic Electric Toothbrush T700

Статус: Есть в наличии

Артикул: 7329

Электрическая зубная щетка Xiaomi Mi Electric Toothbrush T700 обладает тремя режимами, предназнач..

Электрическая зубная щетка Xiaomi SO WHITE Sonic Electric Toothbrush, sakura Pink

15744 тг. 16468 тг.

Электрическая зубная щетка Xiaomi SO WHITE Sonic Electric Toothbrush, sakura Pink

Статус: Есть в наличии

Артикул: 6484

Компания Xiaomi пополнила свою линейку умных устройств для дома новой зубной щеткой Xiaomi SO WHI..

Косметологический массажер для шеи Xiaomi WellSkins Sonic Color Light Neck Massager

22848 тг. 23899 тг.

Косметологический массажер для шеи Xiaomi WellSkins Sonic Color Light Neck Massager

Статус: Ожидаем поступления

Артикул: 7056

В арсенале компании Xiaomi имеется множество полюбившимся пользователям массажеров для лица, приз..

Очищающий массажер для лица Xiaomi inFace sonic cleansing massager

13440 тг. 14058 тг.

Очищающий массажер для лица Xiaomi inFace sonic cleansing massager

Статус: Ожидаем поступления

Артикул: 6356

Xiaomi продолжает радовать пользователей выпуском новых интересных гаджетов для здоровья и красот..

Сменная насадка для зубной щетки Xiaomi Mijia Smart Sonic (3 шт)

5760 тг. 6025 тг.

Сменная насадка для зубной щетки Xiaomi Mijia Smart Sonic (3 шт)

Статус: Ожидаем поступления

Артикул: 5705

Когда речь идёт о такой привычной вещи, как зубная щетка, кажется, что открытий в этой сфере сдел..

Ультразвуковая зубная щетка Xiaomi Oclean One Sonic Electric Toothbrush

27024 тг. 28267 тг.

Ультразвуковая зубная щетка Xiaomi Oclean One Sonic Electric Toothbrush

Статус: Ожидаем поступления

Артикул: 6359

Когда речь заходит об электрических зубных щетках, то люди обычно делятся на две категории: на те..

Умная ультразвуковая зубная щетка Xiaomi Mijia Smart Sonic Electric Toothbrush

17280 тг. 18075 тг.

Умная ультразвуковая зубная щетка Xiaomi Mijia Smart Sonic Electric Toothbrush

Статус: Ожидаем поступления

Артикул: 5475

Компания Xiaomi продолжает развивать линейку продукции "умный дом", и выпускает различные гаджеты..

Электрическая зубная щетка Xiaomi Doctor B Sonic Toothbrush

15840 тг. 16569 тг.

Электрическая зубная щетка Xiaomi Doctor B Sonic Toothbrush

Статус: Ожидаем поступления

Артикул: 5963

31 000 звуковых колебаний DOCTOR B Sonic Electric Toothbrush - современная зубная электрощ..

Электрическая зубная щетка Xiaomi Mijia Sonic Electric Toothbrush T100

3360 тг. 3515 тг.

Электрическая зубная щетка Xiaomi Mijia Sonic Electric Toothbrush T100

Статус: Ожидаем поступления

Артикул: 6548

С самого детства мы знаем о необходимости регулярно чистить зубы, но порой на правильный уход за ..

Электрическая зубная щетка Xiaomi SO WHITE Sonic Electric Toothbrush EX3, silent Blue

6144 тг. 6427 тг.

Электрическая зубная щетка Xiaomi SO WHITE Sonic Electric Toothbrush EX3, silent Blue

Статус: Ожидаем поступления

Артикул: 6483

Компания Xiaomi пополнила свою линейку умных устройств для дома новой зубной щеткой Xiaomi SO W..

Электрическая щетка для очистки обуви Xiaomi YunLun Sonic cleansing Shoe Brush

12960 тг. 13556 тг.

Электрическая щетка для очистки обуви Xiaomi YunLun Sonic cleansing Shoe Brush

Статус: Ожидаем поступления

Артикул: 6946

Xiaomi уже имеет в своем арсенале различные моделей сушилок для обуви, и вот компания выпустила о..

Показано с 1 по 18 из 18 (всего 1 страниц)
Queries: 102, Total time: 270.735 ms [By time] [By id] [By file]
1 (0.485)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://micom.kz/'
/home/micom/public_html/index.php:39,
2 (11.763)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/home/micom/public_html/index.php:51,
3 (0.368)
SELECT *
FROM `oc_language`
WHERE status = '1'
/home/micom/public_html/index.php:135,
4 (0.368)
SELECT *
FROM oc_currency
/home/micom/public_html/system/library/currency.php:13, /home/micom/public_html/index.php:215,
5 (2.870)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '109' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/home/micom/public_html/system/library/tax.php:26, /home/micom/public_html/system/library/tax.php:13, /home/micom/public_html/index.php:218,
6 (2.398)
SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority
FROM oc_tax_rule tr1
LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id)
INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id)
LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id)
LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id)
WHERE tr1.based = 'store' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '109' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/home/micom/public_html/system/library/tax.php:54, /home/micom/public_html/system/library/tax.php:22, /home/micom/public_html/index.php:218,
7 (0.578)
SELECT *
FROM oc_weight_class wc
LEFT JOIN oc_weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id)
WHERE wcd.language_id = '3'
/home/micom/public_html/system/library/weight.php:9, /home/micom/public_html/index.php:221,
8 (0.520)
SELECT *
FROM oc_length_class mc
LEFT JOIN oc_length_class_description mcd ON (mc.length_class_id = mcd.length_class_id)
WHERE mcd.language_id = '3'
/home/micom/public_html/system/library/length.php:9, /home/micom/public_html/index.php:224,
9 (1.574)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/home/micom/public_html/system/library/openbay.php:116, /home/micom/public_html/system/library/openbay.php:10, /home/micom/public_html/index.php:233,
10 (0.256)
SELECT *
FROM oc_event
/home/micom/public_html/index.php:239,
11 (4.916)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:215, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
12 (1.348)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '134' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:220, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
13 (0.387)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '140' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
14 (0.407)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '143' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
15 (0.370)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '145' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
16 (0.428)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '144' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
17 (0.369)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '142' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
18 (0.368)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '135' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
19 (0.435)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '136' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
20 (0.397)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '139' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
21 (0.370)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '141' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
22 (0.381)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '186' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:220, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
23 (1.012)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '146' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:220, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
24 (0.636)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '151' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
25 (0.372)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '150' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
26 (0.423)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '152' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
27 (0.370)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '148' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
28 (0.454)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '147' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
29 (0.458)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '149' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
30 (0.795)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '153' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:220, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
31 (0.391)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '154' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
32 (0.396)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '156' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
33 (0.446)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '157' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
34 (0.371)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '155' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
35 (1.096)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '158' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:220, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
36 (0.444)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '162' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
37 (0.427)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '161' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
38 (0.422)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '194' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
39 (0.370)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '160' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
40 (0.370)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '159' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
41 (0.704)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '193' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
42 (0.539)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '192' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
43 (1.184)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '167' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:220, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
44 (0.409)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '171' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
45 (0.410)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '172' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
46 (0.483)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '168' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
47 (0.416)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '196' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
48 (0.376)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '170' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
49 (0.392)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '169' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
50 (1.099)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '163' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
51 (1.575)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '173' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:220, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
52 (0.394)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '178' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
53 (0.446)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '175' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
54 (0.875)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '174' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
55 (0.752)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '177' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
56 (0.377)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '176' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
57 (0.962)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '179' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:220, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
58 (0.554)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '182' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
59 (0.546)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '181' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
60 (0.406)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '183' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
61 (0.434)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '180' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
62 (1.079)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '184' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:220, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
63 (0.384)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '185' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
64 (0.478)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '188' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
65 (0.391)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '187' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
66 (0.810)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '190' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
67 (0.414)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '189' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:225, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
68 (0.444)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '191' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/home/micom/public_html/catalog/model/catalog/category.php:10, /home/micom/public_html/system/modification/catalog/controller/product/search.php:220, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
69 (79.385)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND (pd.tag LIKE '%sonic%')
/home/micom/public_html/system/modification/catalog/model/catalog/product.php:626, /home/micom/public_html/system/modification/catalog/controller/product/search.php:263, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
70 (81.088)
SELECT p.product_id, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
WHERE pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND (pd.tag LIKE '%Sonic%') GROUP BY p.product_id
ORDER BY p.stock_status_id DESC, p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,99
/home/micom/public_html/system/modification/catalog/model/catalog/product.php:260, /home/micom/public_html/system/modification/catalog/controller/product/search.php:265, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
71 (2.874)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1339' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/micom/public_html/system/modification/catalog/model/catalog/product.php:8, /home/micom/public_html/system/modification/catalog/model/catalog/product.php:263, /home/micom/public_html/system/modification/catalog/controller/product/search.php:265, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
72 (1.715)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1345' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/micom/public_html/system/modification/catalog/model/catalog/product.php:8, /home/micom/public_html/system/modification/catalog/model/catalog/product.php:263, /home/micom/public_html/system/modification/catalog/controller/product/search.php:265, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
73 (1.640)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1115' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/micom/public_html/system/modification/catalog/model/catalog/product.php:8, /home/micom/public_html/system/modification/catalog/model/catalog/product.php:263, /home/micom/public_html/system/modification/catalog/controller/product/search.php:265, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
74 (1.383)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1282' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/micom/public_html/system/modification/catalog/model/catalog/product.php:8, /home/micom/public_html/system/modification/catalog/model/catalog/product.php:263, /home/micom/public_html/system/modification/catalog/controller/product/search.php:265, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
75 (1.554)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1352' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/micom/public_html/system/modification/catalog/model/catalog/product.php:8, /home/micom/public_html/system/modification/catalog/model/catalog/product.php:263, /home/micom/public_html/system/modification/catalog/controller/product/search.php:265, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
76 (1.603)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1267' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/micom/public_html/system/modification/catalog/model/catalog/product.php:8, /home/micom/public_html/system/modification/catalog/model/catalog/product.php:263, /home/micom/public_html/system/modification/catalog/controller/product/search.php:265, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
77 (2.019)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1507' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/micom/public_html/system/modification/catalog/model/catalog/product.php:8, /home/micom/public_html/system/modification/catalog/model/catalog/product.php:263, /home/micom/public_html/system/modification/catalog/controller/product/search.php:265, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
78 (1.695)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1501' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/micom/public_html/system/modification/catalog/model/catalog/product.php:8, /home/micom/public_html/system/modification/catalog/model/catalog/product.php:263, /home/micom/public_html/system/modification/catalog/controller/product/search.php:265, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
79 (1.904)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1131' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/micom/public_html/system/modification/catalog/model/catalog/product.php:8, /home/micom/public_html/system/modification/catalog/model/catalog/product.php:263, /home/micom/public_html/system/modification/catalog/controller/product/search.php:265, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
80 (1.547)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1361' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/micom/public_html/system/modification/catalog/model/catalog/product.php:8, /home/micom/public_html/system/modification/catalog/model/catalog/product.php:263, /home/micom/public_html/system/modification/catalog/controller/product/search.php:265, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
81 (2.465)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1088' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/micom/public_html/system/modification/catalog/model/catalog/product.php:8, /home/micom/public_html/system/modification/catalog/model/catalog/product.php:263, /home/micom/public_html/system/modification/catalog/controller/product/search.php:265, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
82 (1.453)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '978' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/micom/public_html/system/modification/catalog/model/catalog/product.php:8, /home/micom/public_html/system/modification/catalog/model/catalog/product.php:263, /home/micom/public_html/system/modification/catalog/controller/product/search.php:265, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
83 (1.955)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1086' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/micom/public_html/system/modification/catalog/model/catalog/product.php:8, /home/micom/public_html/system/modification/catalog/model/catalog/product.php:263, /home/micom/public_html/system/modification/catalog/controller/product/search.php:265, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
84 (1.394)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '858' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/micom/public_html/system/modification/catalog/model/catalog/product.php:8, /home/micom/public_html/system/modification/catalog/model/catalog/product.php:263, /home/micom/public_html/system/modification/catalog/controller/product/search.php:265, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
85 (1.922)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1029' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/micom/public_html/system/modification/catalog/model/catalog/product.php:8, /home/micom/public_html/system/modification/catalog/model/catalog/product.php:263, /home/micom/public_html/system/modification/catalog/controller/product/search.php:265, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
86 (2.069)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1162' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/micom/public_html/system/modification/catalog/model/catalog/product.php:8, /home/micom/public_html/system/modification/catalog/model/catalog/product.php:263, /home/micom/public_html/system/modification/catalog/controller/product/search.php:265, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
87 (1.655)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1130' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/micom/public_html/system/modification/catalog/model/catalog/product.php:8, /home/micom/public_html/system/modification/catalog/model/catalog/product.php:263, /home/micom/public_html/system/modification/catalog/controller/product/search.php:265, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
88 (1.873)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_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 oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1296' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/home/micom/public_html/system/modification/catalog/model/catalog/product.php:8, /home/micom/public_html/system/modification/catalog/model/catalog/product.php:263, /home/micom/public_html/system/modification/catalog/controller/product/search.php:265, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
89 (1.139)
SELECT *
FROM oc_layout_route
WHERE 'product/search' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/micom/public_html/catalog/model/design/layout.php:4, /home/micom/public_html/catalog/controller/common/column_left.php:35, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /home/micom/public_html/system/modification/catalog/controller/product/search.php:531, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
90 (0.905)
SELECT *
FROM oc_layout_module
WHERE layout_id = '13' AND position = 'column_left'
ORDER BY sort_order
/home/micom/public_html/catalog/model/design/layout.php:14, /home/micom/public_html/catalog/controller/common/column_left.php:46, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /home/micom/public_html/system/modification/catalog/controller/product/search.php:531, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
91 (0.411)
SELECT *
FROM oc_module
WHERE module_id = '48'
/home/micom/public_html/catalog/model/extension/module.php:4, /home/micom/public_html/catalog/controller/common/column_left.php:56, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /home/micom/public_html/system/modification/catalog/controller/product/search.php:531, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
92 (0.992)
SELECT *
FROM oc_layout_route
WHERE 'product/search' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/micom/public_html/catalog/model/design/layout.php:4, /home/micom/public_html/catalog/controller/common/column_right.php:35, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /home/micom/public_html/system/modification/catalog/controller/product/search.php:532, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
93 (0.488)
SELECT *
FROM oc_layout_module
WHERE layout_id = '13' AND position = 'column_right'
ORDER BY sort_order
/home/micom/public_html/catalog/model/design/layout.php:14, /home/micom/public_html/catalog/controller/common/column_right.php:44, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /home/micom/public_html/system/modification/catalog/controller/product/search.php:532, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
94 (0.979)
SELECT *
FROM oc_layout_route
WHERE 'product/search' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/micom/public_html/catalog/model/design/layout.php:4, /home/micom/public_html/catalog/controller/common/content_top.php:35, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /home/micom/public_html/system/modification/catalog/controller/product/search.php:533, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
95 (0.507)
SELECT *
FROM oc_layout_module
WHERE layout_id = '13' AND position = 'content_top'
ORDER BY sort_order
/home/micom/public_html/catalog/model/design/layout.php:14, /home/micom/public_html/catalog/controller/common/content_top.php:44, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /home/micom/public_html/system/modification/catalog/controller/product/search.php:533, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
96 (0.848)
SELECT *
FROM oc_layout_route
WHERE 'product/search' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/micom/public_html/catalog/model/design/layout.php:4, /home/micom/public_html/catalog/controller/common/content_bottom.php:35, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /home/micom/public_html/system/modification/catalog/controller/product/search.php:534, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
97 (0.452)
SELECT *
FROM oc_layout_module
WHERE layout_id = '13' AND position = 'content_bottom'
ORDER BY sort_order
/home/micom/public_html/catalog/model/design/layout.php:14, /home/micom/public_html/catalog/controller/common/content_bottom.php:44, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /home/micom/public_html/system/modification/catalog/controller/product/search.php:534, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
98 (4.933)
SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/home/micom/public_html/catalog/model/catalog/information.php:10, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_catalog_controller_common_footer.php:46, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /home/micom/public_html/system/modification/catalog/controller/product/search.php:535, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
99 (0.880)
SELECT *
FROM oc_layout_route
WHERE 'product/search' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/home/micom/public_html/catalog/model/design/layout.php:4, /home/micom/public_html/catalog/controller/common/footer_top.php:35, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_catalog_controller_common_footer.php:74, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /home/micom/public_html/system/modification/catalog/controller/product/search.php:535, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
100 (0.457)
SELECT *
FROM oc_layout_module
WHERE layout_id = '13' AND position = 'footer_top'
ORDER BY sort_order
/home/micom/public_html/catalog/model/design/layout.php:14, /home/micom/public_html/catalog/controller/common/footer_top.php:44, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_catalog_controller_common_footer.php:74, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /home/micom/public_html/system/modification/catalog/controller/product/search.php:535, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
101 (4.664)
SELECT *
FROM oc_information i
LEFT JOIN oc_information_description id ON (i.information_id = id.information_id)
LEFT JOIN oc_information_to_store i2s ON (i.information_id = i2s.information_id)
WHERE id.language_id = '3' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/home/micom/public_html/catalog/model/catalog/information.php:10, /home/micom/public_html/system/modification/catalog/controller/common/header.php:43, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /home/micom/public_html/system/modification/catalog/controller/product/search.php:536, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,
102 (1.945)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/home/micom/public_html/catalog/model/extension/extension.php:4, /home/micom/public_html/system/modification/catalog/controller/common/cart.php:17, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /home/micom/public_html/system/modification/catalog/controller/common/header.php:201, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /home/micom/public_html/system/modification/catalog/controller/product/search.php:536, /home/micom/public_html/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /home/micom/public_html/system/modification/system/engine/front.php:37, /home/micom/public_html/system/modification/system/engine/front.php:30, /home/micom/public_html/index.php:262,