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

Все для ванной

Все для ванной

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

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

Артикул: 7049

Для здоровья Ваших зубов, стоматологи рекомендуют заменять зубную щетку каждые 2 месяца. Если Вы ..
Сменная насадка для зубной щеки Dr. B Sonic Electric Brush Head
3060 тг. 3201 тг.

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

Артикул: 6421

Сменная насадка для зубной щеки Dr. B Sonic Electric Brush Head (поставляются в количестве 2х шту..
Электрическая зубная щетка Xiaomi Mijia Sonic Electric Toothbrush T100
3570 тг. 3734 тг.

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

Артикул: 6548

С самого детства мы знаем о необходимости регулярно чистить зубы, но порой на правильный уход за ..
Триммер-стайлер для носа, ушей, бороды и усов Xiaomi Soocas Hair Trimmer N1
4539 тг. 4748 тг.

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

Артикул: 6497

Компания Soocas, суббренд техногиганта Xiaomi  - уже давно известна на рынке благодаря своим элек..
Триммер для ухода за лицом Xiaomi ShowSee Nose Hair Trimmer C1-BK
5100 тг. 5335 тг.

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

Артикул: 6545

Красивый, чистый и опрятный внешний вид мужчины может испортить одна незначительная деталь – види..
Набор для ухода за полостью рта Xiaomi Daily Elements Oral Care Gift Box
5610 тг. 5868 тг.

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

Артикул: 7361

Набор для ухода за зубами Xiaomi Daily Elements Oral Care Gift Box предоставляет возможность ..
Картриджи с мылом для Xiaomi MiJia Soap Dispenser, (3 шт\уп)
7140 тг. 7468 тг.

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

Артикул: 6353

Набор Xiaomi MiJia Foam Soap Sanitizer представляет с собой картриджи с мылом для автоматического..
Маникюрный набор Xiaomi Mijia Nail Clipper 5 pcs Set
7650 тг. 8002 тг.

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

Артикул: 6833

Xiaomi Mijia Nail Clipper 5 pcs Set - это стильный маникюрный набор "унисекс" для мужчин и женщин..
Портативная электробритва Xiaomi Mijia Electric Shaver S100 Rotating Double Heads
8670 тг. 9069 тг.

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

Артикул: 7331

Xiaomi Mijia Electric Shaver S100 - это портативная электробритва с плавающей головкой, которая..
Портативная машинка для маникюра и педикюра Xiaomi ShowSee Electric Pedicure B1-W
8726 тг. 9128 тг.

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

Артикул: 7148

Благодаря роликовой пилке Xiaomi ShowSee Electric Pedicure B1-W ваши стопы всегда будут иметь ухоже..
Электрический маникюрный аппарат Xiaomi Seemagic Electric Nail Clipper Pro
9894 тг. 10349 тг.

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

Артикул: 7358

Электрический ножничный маникюрный аппарат Seemagic Electric Nail Clipper Pro от Xiaomi (SMPH..
Вакуумный очиститель пор Xiaomi InFace vacuum Skin Pore Cleanser,
10098 тг. 10563 тг.

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

Артикул: 7051

Почти каждый человек сталкивается в своей жизни с такой проблемой, как забитые поры и комедоны на..
Дозатор для мыла (мыло в комплекте) Xiaomi MiJia Auromatic Foam Soap Dispenser
10149 тг. 10616 тг.

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

Артикул: 6177

Не так давно Mijia - суббренд компании Xiaomi, представила  новый продукт для дома под названием ..
Зеркало для макияжа с подсветкой Xiaomi Jordan Judy LED 3 Color Mirror + увеличительное мини-зеркало
10985 тг. 11491 тг.

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

Артикул: 7092

Xiaomi выпустили "старшую" модель в линейке зеркал Jotun (Jordan) Judy Desktop LED 3 Color Makeup..
Набор сменных тряпок для швабры Deerma (8 шт) Xiaomi Deerma MOP Set
11526 тг. 12056 тг.

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

Артикул: 6684

Швабра с распрыскивателем воды Xiaomi Deerma Water Spray Mop уже успела полюбиться пользователям ..
Набор для бритья (6 предметов) Xiaomi HandX Refresh Manual Shaver Set H300-6
11730 тг. 12270 тг.

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

Артикул: 6917

У Xiaomi в арсенале есть очень много бьюти-гаджетов для женщин, но компания уделяет внимание такж..
Набор сменных лезвий для бритвы Xiaomi Refresh Manual Shaver (4 шт)
11730 тг. 12270 тг.

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

Артикул: 6995

Набор сменных лезвий для бритвы Xiaomi Refresh Manual Shaver (4 шт) Используемые в наборе Xiao..
Машинка для стрижки волос Xiaomi Mijia Electric Hair Clipper
14790 тг. 15470 тг.

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

Артикул: 6835

Новый гаджет, который несомненно полюбится пользователям, особенно сильной половине человечества ..
Оригинальный подарочный набор (Фен и Зеркало) Xiaomi Heart Gift Box, Hair Dryer + Mirror
15198 тг. 15897 тг.

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

Артикул: 7151

Оригинальный подарочный набор от компании Xiaomi включает в себя фен ShowSee, и зеркало с подсвет..
Электрическая зубная щетка Xiaomi SO WHITE Sonic Electric Toothbrush, sakura Pink
16728 тг. 17497 тг.

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

Артикул: 6484

Компания Xiaomi пополнила свою линейку умных устройств для дома новой зубной щеткой Xiaomi SO WHI..
Электрическая зубная щетка Xiaomi Mijia Sonic Electric Toothbrush T302
17238 тг. 18031 тг.

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

Артикул: 7330

Электрическая зубная щетка Mijia Sonic Electric Toothbrush T302 от Xiaomi представляет собой авто..
Набор для бритья (8 предметов) Xiaomi HandX Refresh Manual Shaver Set H305-8
17850 тг. 18671 тг.

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

Артикул: 6931

У Xiaomi в арсенале есть очень много бьюти-гаджетов для женщин, но компания уделяет внимание такж..
Ультразвуковой скрабер для лица Xiaomi Inface Ultrasonic Ion Skin cleanser MS7100
17850 тг. 18671 тг.

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

Артикул: 6837

В последнее время все большую популярность приобретают различные бьюти-гаджеты для домашнего уход..
Стерилизатор для зубных щеток Xiaomi Dr.Meng Disinfection Toothbrush Holder
21695 тг. 22693 тг.

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

Артикул: 6709

Многчисленные исследования в области здравоохранения доказали, что на щетках, которыми пользуются..
Умная ультразвуковая зубная щетка Xiaomi Soocas X3U Electric Toothbrush
21930 тг. 22939 тг.

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

Артикул: 6557

Компания Xiaomi уже давно стала одним из лидеров на рынке устройств для очистки полости рта - в а..
Умная ультразвуковая электрическая зубная щетка (белая) Xiaomi Soocare X3U Electric Toothbrush white
21930 тг. 22939 тг.

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

Артикул: 6615

Компания Xiaomi уже давно стала одним из лидеров на рынке устройств для очистки полости рта - в а..
Подарочный набор Xiaomi Exclusive Gift Box (зеркало + расческа)
22083 тг. 23099 тг.

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

Артикул: 7102

Состоит из двух предметов без которых не обойдется ни одна девушка: зеркала для макияжа и расческа...
Ирригатор для полости рта Xiaomi MiJia Irrigator (MiJia Electric Flusher)
22746 тг. 23792 тг.

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

Артикул: 7060

Ирригатор Xiaomi Mijia Electric Flusher Портативный ирригатор полости рта с интеллектуальной с..
Большое зеркало для макияжа с подсветкой Xiaomi Jordan Judy LED Counter Top Mirror
22950 тг. 24006 тг.

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

Артикул: 6888

Новинка от Xiaomi в сфере красоты и ухода за собой - девайс, получивший название Jordan Judy Larg..
Умная корзина для мусора Xiaomi Quange GA1 Garbage Bin
26479 тг. 27697 тг.

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

Артикул: 6882

Xiaomi продолжает расширять линейку умных корзин для мусора, и на этот раз компания представила р..
Электрическая зубная щетка Xiaomi Mijia Sonic Electric Toothbrush T700
27540 тг. 28807 тг.

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

Артикул: 7329

Электрическая зубная щетка Xiaomi Mi Electric Toothbrush T700 обладает тремя режимами, предназнач..
Электрическая массажная щетка Xiaomi inFace Smart Body Cleansing Brush
28560 тг. 29874 тг.

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

Артикул: 7050

 Xiaomi выпустили инновационный гаджет для красоты и здоровья - электрическая массажная щетка..
Портативная складная стиральная машина Xiaomi Moyu MINI Foldable Washing Machine 0.8
37730 тг. 39465 тг.

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

Артикул: 7127

Главные минусы стандартных стиральных машин Компактная и портативная  Стиральная машина X..
Фотоэпилятор Xiaomi InFace IPL Hair Removal Device
46410 тг. 48545 тг.

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

Артикул: 6932

Фотоэпилятор Xiaomi inFace IPL Hair Removal Instrument Для тех, кто желает выглядеть эффектно ..
Умное мусорное ведро Xiaomi Townew T1S Smart Trash Bin, 15,5L, запаивает пакеты
49898 тг. 52194 тг.

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

Артикул: 7221

Умное мусорное ведро Xiaomi Townew T1S Smart Trash Bin - разработано инженерами Xiaomi специально..
Портативный мини-холодильник Xiaomi Baseus Igloo Mini Refrigerator 6L
56100 тг. 58681 тг.

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

Артикул: 6958

Xiaomi в сотрудничестве с Baseus выпустили серию многофункциональных и полезных гаджетов,..
Массажная ванночка для ног Xiaomi HITH Smart Foot Bath X5
73950 тг. 77352 тг.

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

Артикул: 7155

Устали после тяжелого рабочего дня? У Xiaomi есть решение для вас - новый стильны..
Гидромассажная ванна для ног Xiaomi HITH Smart Foot Bath T1
75699 тг. 79181 тг.

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

Артикул: 7156

Умная ванна для ног  Smart Foot Bath устройство для дома, которое заботится о вашем здоровье. Полно..
Зубная щетка Xiaomi Doctor B toothbrush travel package
1836 тг. 1920 тг.

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

Артикул: 5661

Xiaomi постепенно проникает во все сферы нашей жизни. Команда профессионалов Xiaomi в лице соврем..
Зубная паста 0+ для детей и взрослых (3 шт в упаковке) Xiaomi Doctor B toothpaste
4294 тг. 4492 тг.

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

Артикул: 5952

Ежедневное вкушение пищи, требует регулярного ухода за полостью рта, для удаления остатков еды и ..
Набор зубных щеток Xiaomi Doctor B toothbrush travel package 4-in-1
4590 тг. 4801 тг.

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

Артикул: 6313

Команда профессионалов Xiaomi в лице современных удобных и полезных гаджетов постоянно следит за ..
Сумка для ванных принадлежностей Xiaomi 90 points Travel Wash Bag
5100 тг. 5335 тг.

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

Артикул: 6423

Те, кто часто бывают в командировках и поездках - знают, как порой бывает сложно найти нужный фла..
Набор сменных тряпок для швабры Deerma (4 шт) Xiaomi Deerma MOP Set
6120 тг. 6402 тг.

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

Артикул: 6542

Швабра с распрыскивателем воды Xiaomi Deerma Water Spray Mop уже успела полюбиться пользователям ..
Сменный картридж (3 шт) Xiaomi Xiaoji Foam Hand Sanitizer
6120 тг. 6402 тг.

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

Артикул: 6184

Xiaomi Xiaoji Foam Hand Sanitizer - сменный картридж для сенсорного бесконтактного диспенсора для..
Маникюрный набор Xiaomi Nextool Nail Clipper Set, 5 предметов
6324 тг. 6615 тг.

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

Артикул: 6975

Маникюрный набор Xiaomi Nextool Nail Clipper Set (MS20011) – компактный маникюрный набор, состоящ..
Электрическая зубная щетка Xiaomi SO WHITE Sonic Electric Toothbrush EX3, silent Blue
6528 тг. 6828 тг.

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

Артикул: 6483

Компания Xiaomi пополнила свою линейку умных устройств для дома новой зубной щеткой Xiaomi SO W..
Зеркало для макияжа с подсветкой Xiaomi Jotun (Jordan) Judy Desktop LED Makeup Mirror
8670 тг. 9069 тг.

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

Артикул: 6432

Пользователям уже полюбилась предыдущая модель зеркала для макияжа от Xiaomi - Amiro Lux Mirror. ..
Портативная электробритва Xiaomi Enchen Blackstone Shaver
9180 тг. 9602 тг.

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

Артикул: 6836

Гаджет от Xiaomi для настоящих мужчин! Xiaomi Enchen Blackstone Shaver - компактная водонепроница..
Умный дозатор для мыла Xiaomi XiaoJi Automatic Foam Soap Dispenser
11220 тг. 11736 тг.

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

Артикул: 5723

Встречайте новинку XiaoJi Automatic Foam Soap Dispenser - великолепный автоматический дозатор для..
Машинка для стрижки Xiaomi ShowSee Electric Hair Clipper C2
11475 тг. 12003 тг.

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

Артикул: 6834

Xiaomi ShowSee Electric Hair Clipper C2 - новый гаджет от компании Xiaomi для ухода за собой. Три..
Портативная электробритва Xiaomi So White Mini Electric Shaver
11730 тг. 12270 тг.

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

Артикул: 6420

В ассортименте компании Xiaomi уже представлены различные бритвы - стандартные проводные, бритвен..
Умные весы Xiaomi Mi Body Composition Scale 2
12087 тг. 12643 тг.

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

Артикул: 6489

Обычно о степени стройности человека судят по его весу, однако такой подход имеет существенные не..
Утюжок для волос с ионизацией Xiaomi RiWA Hair Straightener
13306 тг. 13918 тг.

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

Артикул: 6554

Выпрямитель для волос Xiaomi RiWA Hair Straightener придется по вкусу представительницам прекрасн..
Очищающий массажер для лица Xiaomi inFace sonic cleansing massager
14280 тг. 14937 тг.

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

Артикул: 6356

Xiaomi продолжает радовать пользователей выпуском новых интересных гаджетов для здоровья и красот..
Вакуумный аппарат для чистки лица Xiaomi DOCO Ultra Micro Bubble Pore Vacuum Cleaner
15912 тг. 16644 тг.

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

Артикул: 6890

Xiaomi выпустили очередной гаджет, призванный обеспечить профессиональный косметологический уход ..
Электрическая зубная щетка Xiaomi Doctor B Sonic Toothbrush
16830 тг. 17604 тг.

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

Артикул: 5963

31 000 звуковых колебаний DOCTOR B Sonic Electric Toothbrush - современная зубная электрощ..
Умное мусорное ведро с датчиком открытия, 12л Xiaomi Gipin Smart Sensor Trash Can (LJT-01)
17162 тг. 17951 тг.

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

Артикул: 7124

Быстрая реакция индукционного датчика 0,35 с  Дальняя дистанция обнаружения Умный чип Бесш..
Детская электрическая зубная щетка Xiaomi Soocas Electric Kids
17595 тг. 18404 тг.

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

Артикул: 6481

Электрическая щетка Xiaomi Soocas Electric Kids - разработана специально для детей и относится к ..
Зеркало для макияжа с подсветкой Xiaomi DOCO Daylight Mirror
17850 тг. 18671 тг.

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

Артикул: 6555

Xiaomi продолжает расширять линейку зеркал с подсветкой - новинка DOCO Daylight Mirror представля..
Электрощетка кухонная Xiaomi ShunZao Handheld Kitchen Brush
17850 тг. 18671 тг.

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

Артикул: 6994

Ваш универсальный помощник для наведения чистоты в Вашем доме - электрощетка Xiaomi Shunzao Handh..
Ирригатор для полости рта Xiaomi Soocas Irrigator W3
19278 тг. 20165 тг.

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

Артикул: 6182

Xiaomi продолжает выпускать различные полезные устройства для здорового образа жизни. Недавно инж..
Умная мусорная корзина (ведро) Xiaomi Ninestars Sensor Trash Can
19380 тг. 20271 тг.

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

Артикул: 6463

Пользователям уже успел полюбиться полезный гаджет от Xiaomi - умное мусорное ведро Townew T1. И ..
Гибридный стайлер для волос Xiaomi Wellskins Hot Air Comb
20400 тг. 21338 тг.

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

Артикул: 6429

Нет ничего красивее, чем здоровые и ухоженные волосы. Но иногда даже самого грамотного ухода оказ..
Массажер для лица Xiaomi inFace Gold Beauty Face Massager MS3000
20910 тг. 21872 тг.

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

Артикул: 6109

Постоянный стресс, недостаточный уход за лицом и кожей, загрязненная атмосфера крупных городов, б..
Ультразвуковая зубная щетка Xiaomi Soocas Electric Toothbrush X5 Sea Blue (синяя), Gift Box
21930 тг. 22939 тг.

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

Артикул: 6913

Xiaomi Soocas Sonic Electric Toothbrush X5 Gift Box - электрическая зубная щетка нового поколения..
Настольное зеркало с подсветкой Xiaomi Amiro Lux HD LED Mirror
23103 тг. 24166 тг.

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

Артикул: 5951

Каждая девушка знает, как неприятно выйти на улицу и обнаружить, что тональная основа не сочетает..
Складное трехстворчатое зеркало для макияжа с подсветкой и увеличением Xiaomi Jordan Judy Folding Make-up LED Mirror
23460 тг. 24539 тг.

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

Артикул: 6889

В макияже и уходе за собой - свет также важен, как и в фотографии или кино! Поэтому во всех фильм..
Электрическая зубная щетка Xiaomi Oclean X
23970 тг. 25073 тг.

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

Артикул: 6504

Oclean X – электрическая зубная щетка нового поколения с интегрированным цветным дисплеем. ..
Косметологический массажер для шеи Xiaomi WellSkins Sonic Color Light Neck Massager
24276 тг. 25393 тг.

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

Артикул: 7056

В арсенале компании Xiaomi имеется множество полюбившимся пользователям массажеров для лица, приз..
Ультразвуковая зубная щетка Xiaomi Soocas Electric Toothbrush X5 Powder (розовая), Gift Box
24990 тг. 26140 тг.

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

Артикул: 6912

Xiaomi Soocas Sonic Electric Toothbrush X5 Gift Box - электрическая зубная щетка нового поколения..
Складной ирригатор Xiaomi Olybo Telescopic Portable Teeth Cleaner WL8
25755 тг. 26940 тг.

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

Артикул: 6482

Стоматологи по всему миру давно добавили электрические зубные щетки и ирригаторы в обязательный н..
Ультразвуковая зубная щетка Xiaomi Oclean One Sonic Electric Toothbrush
28713 тг. 30034 тг.

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

Артикул: 6359

Когда речь заходит об электрических зубных щетках, то люди обычно делятся на две категории: на те..
Портативная складная стиральная машина, Xiaomi Moyu MINI Foldable Washing Machine 05
31380 тг. 32824 тг.

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

Артикул: 7128

Moyu Mini — это складная стиральная машина, которая благодаря системе складывания в виде гармошки, ..
Фен-расческа для выпрямления волос Xiaomi Reepro Styling Comb
34680 тг. 36275 тг.

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

Артикул: 6428

С принципом работы утюжка для выпрямления волос сегодня знакома уже каждая девушка. Кто-то не пре..
Показано с 1 по 74 из 74 (всего 1 страниц)
Queries: 108, Total time: 209.760 ms [By time] [By id] [By file]
1 (0.437)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://micom.kz/'
/home/micom/public_html/index.php:39,
2 (12.326)
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.466)
SELECT *
FROM `oc_language`
WHERE status = '1'
/home/micom/public_html/index.php:135,
4 (0.434)
SELECT *
FROM oc_currency
/home/micom/public_html/system/library/currency.php:13, /home/micom/public_html/index.php:215,
5 (2.873)
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.340)
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.537)
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.463)
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.528)
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 (0.705)
SELECT DISTINCT *
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.category_id = '146' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
/home/micom/public_html/catalog/model/catalog/category.php:4, /home/micom/public_html/system/modification/catalog/controller/product/category.php:77, /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 (0.431)
SELECT DISTINCT *
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.category_id = '151' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
/home/micom/public_html/catalog/model/catalog/category.php:4, /home/micom/public_html/system/modification/catalog/controller/product/category.php:90, /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.500)
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/category.php:154, /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 (5.103)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_product_to_category p2c
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
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 p2c.category_id = '151'
/home/micom/public_html/system/modification/catalog/model/catalog/product.php:626, /home/micom/public_html/system/modification/catalog/controller/product/category.php:181, /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 (18.008)
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_to_category p2c
LEFT JOIN oc_product p ON (p2c.product_id = p.product_id)
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 p2c.category_id = '151' GROUP BY p.product_id
ORDER BY p.stock_status_id DESC, (CASE WHEN special IS NOT NULL THEN special WHEN discount IS NOT NULL THEN discount ELSE p.price END) 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/category.php:183, /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 (2.311)
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/category.php:183, /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 (1.454)
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/category.php:183, /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 (1.643)
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/category.php:183, /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 (1.818)
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 = '1134' 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/category.php:183, /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 (1.530)
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 = '1155' 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/category.php:183, /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 (1.354)
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 = '1515' 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/category.php:183, /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 (1.333)
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 = '1082' 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/category.php:183, /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.623)
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 = '1262' 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/category.php:183, /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 (1.435)
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 = '1502' 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/category.php:183, /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 (1.498)
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 = '1409' 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/category.php:183, /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 (1.486)
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 = '1513' 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/category.php:183, /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 (1.957)
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 = '1355' 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/category.php:183, /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 (1.995)
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 = '1061' 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/category.php:183, /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 (1.445)
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 = '1472' 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/category.php:183, /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 (1.448)
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 = '1223' 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/category.php:183, /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 (1.893)
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 = '1299' 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/category.php:183, /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 (1.399)
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 = '1368' 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/category.php:183, /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 (1.512)
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 = '1264' 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/category.php:183, /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 (1.742)
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 = '1437' 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/category.php:183, /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.731)
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/category.php:183, /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 (1.451)
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/category.php:183, /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 (1.576)
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 = '1300' 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/category.php:183, /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 (1.956)
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/category.php:183, /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 (2.633)
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 = '1242' 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/category.php:183, /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 (1.740)
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 = '1170' 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/category.php:183, /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 (2.783)
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 = '1212' 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/category.php:183, /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 (1.505)
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 = '1377' 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/category.php:183, /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.536)
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 = '1360' 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/category.php:183, /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 (2.062)
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 = '1284' 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/category.php:183, /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 (1.481)
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 = '1277' 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/category.php:183, /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 (1.638)
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/category.php:183, /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 (2.026)
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 = '1354' 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/category.php:183, /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 (1.654)
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 = '1392' 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/category.php:183, /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 (4.979)
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 = '1330' 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/category.php:183, /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.490)
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 = '1455' 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/category.php:183, /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.493)
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 = '1308' 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/category.php:183, /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 (1.623)
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 = '1429' 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/category.php:183, /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 (1.479)
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 = '1416' 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/category.php:183, /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 (1.729)
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 = '1093' 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/category.php:183, /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 (2.080)
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 = '1012' 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/category.php:183, /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 (1.523)
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 = '1092' 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/category.php:183, /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 (1.716)
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 = '1117' 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/category.php:183, /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 (1.471)
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 = '1152' 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/category.php:183, /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 (1.681)
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 = '1072' 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/category.php:183, /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 (1.941)
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 = '1321' 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/category.php:183, /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 (1.959)
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/category.php:183, /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.748)
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 = '1110' 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/category.php:183, /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 (2.083)
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 = '1266' 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/category.php:183, /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 (1.891)
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 = '937' 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/category.php:183, /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 (1.608)
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 = '1263' 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/category.php:183, /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 (2.057)
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 = '1114' 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/category.php:183, /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 (2.091)
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 = '1141' 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/category.php:183, /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 (1.919)
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 = '1193' 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/category.php:183, /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 (2.700)
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/category.php:183, /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 (1.449)
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 = '1287' 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/category.php:183, /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.536)
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/category.php:183, /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.618)
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 = '1394' 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/category.php:183, /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.754)
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 = '1133' 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/category.php:183, /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.894)
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 = '1192' 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/category.php:183, /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 (2.004)
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 = '1367' 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/category.php:183, /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 (2.041)
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 = '1065' 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/category.php:183, /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.122)
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 = '1124' 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/category.php:183, /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 (2.644)
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 = '1113' 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/category.php:183, /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 (2.446)
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 = '1060' 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/category.php:183, /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 (2.853)
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 = '1293' 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/category.php:183, /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 (3.017)
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 = '1005' 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/category.php:183, /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 (2.139)
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 = '1285' 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/category.php:183, /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 (2.076)
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 = '1148' 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/category.php:183, /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.728)
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/category.php:183, /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 (2.513)
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 = '1294' 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/category.php:183, /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.027)
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 = '1171' 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/category.php:183, /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 (2.720)
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/category.php:183, /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.654)
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 = '1400' 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/category.php:183, /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.708)
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 = '1111' 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/category.php:183, /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 (1.175)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '151' AND store_id = '0'
/home/micom/public_html/catalog/model/catalog/category.php:55, /home/micom/public_html/catalog/controller/common/column_left.php:19, /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/category.php:397, /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.916)
SELECT *
FROM oc_layout_route
WHERE 'product/category' 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/category.php:397, /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.472)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' 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/category.php:397, /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.919)
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/category.php:397, /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.414)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '151' AND store_id = '0'
/home/micom/public_html/catalog/model/catalog/category.php:55, /home/micom/public_html/catalog/controller/common/column_right.php:19, /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/category.php:398, /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.984)
SELECT *
FROM oc_layout_route
WHERE 'product/category' 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/category.php:398, /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.494)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' 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/category.php:398, /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.323)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '151' AND store_id = '0'
/home/micom/public_html/catalog/model/catalog/category.php:55, /home/micom/public_html/catalog/controller/common/content_top.php:19, /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/category.php:399, /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 (0.915)
SELECT *
FROM oc_layout_route
WHERE 'product/category' 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/category.php:399, /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.476)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' 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/category.php:399, /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.658)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '151' AND store_id = '0'
/home/micom/public_html/catalog/model/catalog/category.php:55, /home/micom/public_html/catalog/controller/common/content_bottom.php:19, /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/category.php:400, /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 (0.949)
SELECT *
FROM oc_layout_route
WHERE 'product/category' 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/category.php:400, /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.068)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' 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/category.php:400, /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,
103 (3.982)
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/category.php:401, /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,
104 (0.505)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '151' AND store_id = '0'
/home/micom/public_html/catalog/model/catalog/category.php:55, /home/micom/public_html/catalog/controller/common/footer_top.php:19, /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/category.php:401, /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,
105 (0.976)
SELECT *
FROM oc_layout_route
WHERE 'product/category' 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/category.php:401, /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,
106 (0.512)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' 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/category.php:401, /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,
107 (3.974)
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/category.php:402, /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,
108 (2.789)
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/category.php:402, /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,