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

Освещение

Освещение

Лампа для съемки сэлфи Xiaomi Selfie LED flash light
4160 тг. 4351 тг.

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

Артикул: 4632

Настоящий маст-хэв для любителей сэлфи-съемок: мини-лампа Xiaomi Selfie LED flash light!  Селф..
Лампочка Xiaomi Mijia LED Bulb, Bluetooth, MESH Version
7800 тг. 8159 тг.

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

Артикул: 6915

Поставьте новую лампочку и сделайте из обычного светильника умный Вы очень долго выбирали красив..
Умный выключатель света, встраиваемый Xiaomi MiJia Smart Wall Switch
9043 тг. 9459 тг.

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

Артикул: 6839

Новый гаджет в линейке умных выключателей света от Xiaomi - MiJia Smart Wall Switch, который може..
Беспроводной автономный ночник с датчиком движения XiaoMi Aqara smart sensor night light.
9256 тг. 9682 тг.

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

Артикул: 6944

Минималистичен и простой дизайн, в стиле Xiaomi. Белая упаковка с иероглифами и брендом, внутри пак..
Беспроводной настенный выключатель света, одинарный Xiaomi Aqara Smart Light Switch single, ZigBee
9360 тг. 9791 тг.

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

Артикул: 5271

Xiaomi продолжает активное инновационное наступление на традиционные технологии, делая из простых..
Противомоскитная лампа репеллент Xiaomi Pretty Dragonfly Portable Anti-Mosquito  Lamp
9360 тг. 9791 тг.

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

Артикул: 7100

Противомоскитная лампа-репеллент Xiaomi обеспечивает эффективное устранение комаров на 85 %. ..
Зеркало для макияжа с подсветкой Xiaomi Jotun (Jordan) Judy Desktop LED Makeup Mirror
9880 тг. 10334 тг.

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

Артикул: 6432

Пользователям уже полюбилась предыдущая модель зеркала для макияжа от Xiaomi - Amiro Lux Mirror. ..
Бактерицидная UV лампа (настольная) Xiaomi Xiaoda UV Sterilization lamp
10400 тг. 10878 тг.

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

Артикул: 6584

Вспышка коронавируса сделала крайне популярными во всем мире не только маски для лица, но и ультр..
Беспроводной настенный выключатель света, двойной Xiaomi Aqara Smart Light Switch dual, ZigBee
10920 тг. 11422 тг.

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

Артикул: 5270

Xiaomi продолжает активное инновационное наступление на традиционные технологии, делая из простых..
Умный магнитный ночник Seebest Small Night lamp
10920 тг. 11422 тг.

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

Артикул: 7059

..
Умный ночник с магнитной подставкой-креплениемXiaomi MiJia Night Light 2 Bluetooth
10920 тг. 11422 тг.

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

Артикул: 6884

Xiaomi MiJia Night Light 2 Bluetooth - это "старшая" модель в линейке ночных светильников серии M..
Проекционная лампа Xiaomi Yeelight Dream Atmosphere Light
15080 тг. 15774 тг.

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

Артикул: 6950

Настольная лампа мягко освещает комнату теплым атмосферным светом, а лампочка с регулируемой ярко..
Умная лампочка Xiaomi Yeelight LED bulb 1S (16млн цветов) Е27
15080 тг. 15774 тг.

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

Артикул: 6914

Лампа Yeelight с возможностью настройки цветовой температуры подарит дому мягкое тепло или бодрящ..
Зеркало для макияжа с подсветкой Xiaomi DOCO Daylight Mirror
18200 тг. 19037 тг.

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

Артикул: 6555

Xiaomi продолжает расширять линейку зеркал с подсветкой - новинка DOCO Daylight Mirror представля..
Встраиваемый переключатель (выключатель), двойной Xiaomi Aqara Smart Light control dual
19292 тг. 20179 тг.

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

Артикул: 5590

Xiaomi продолжает выпускать устройства в линейке умных переключателей света. Предыдущая модель - ..
Умная настольная лампа Xiaomi Mi Smart Desk Lamp
20072 тг. 20995 тг.

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

Артикул: 4783

Xiaomi представила новый полезный гаджет - Mi Smart LED Desk Lamp, умную настольную ламу, которая..
Настольное зеркало с подсветкой Xiaomi Amiro Lux HD LED Mirror
23556 тг. 24640 тг.

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

Артикул: 5951

Каждая девушка знает, как неприятно выйти на улицу и обнаружить, что тональная основа не сочетает..
Умная настольная лампа Xiaomi Philips Eyecare Smart Lamp 2
23920 тг. 25020 тг.

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

Артикул: 5503

Компания Philips на протяжении долгого времени была признана мировым лидером на рынке осветительн..
Умная светодиодная лента Xiaomi MIJIA Ambient Light Strip
30992 тг. 32418 тг.

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

Артикул: 7058

Компания Xiaomi представила новую умную светодиодную ленту Xiaomi MIJIA Ambient Light Strip с подде..
Потолочный светильник Xiaomi OPPLE Ceiling Lamp Starry Sky 417*90mm
41496 тг. 43405 тг.

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

Артикул: 6930

Потолочный светильник Xiaomi Opple Ceiling Lamp Starry Sky выполнен в современном минималистичном..
Потолочный светильник Xiaomi OPPLE Ceiling Lamp 457*75mm
45240 тг. 47321 тг.

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

Артикул: 6929

Потолочный светильник Xiaomi Opple Ceiling Lamp выполнен в современном минималистичном дизайне, о..
Портативная светодиодная USB лампа Xiaomi Mi Led
1560 тг. 1632 тг.

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

Артикул: 3649

Переносная USB лампа- фонарик Xiaomi Mi Led с гибкой ножкой поможет Вам осветить любую рабочую по..
Портативная светодиодная USB лампа Xiaomi Mi Led 2
2080 тг. 2176 тг.

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

Артикул: 4609

Удобная светодиодная лампа Xiaomi Mi Led 2 — теперь в 2 раза ярче!  Xiaomi Mi Led 2, также наз..
Умная лампочка Xiaomi Mi Smart LED Bulb Essential, E27 (международная версия)
5980 тг. 6255 тг.

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

Артикул: 6865

Xiaomi Mi Smart LED Bulb Essential - это умная лампочка от Xiaomi, которая имеет возможность выбо..
Лампа-ночник с датчиком движения Xiaomi MiJIA IR Sensor and Photosensitive Night Light
6240 тг. 6527 тг.

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

Артикул: 5488

Xiaomi Night Light — яркий представитель линейки «умных» гаджетов от компании Xiaomi совмещающий ..
LED лампочка Xiaomi Philips Master LED candle Bulb GPX4008RT, прозрачная
6760 тг. 7071 тг.

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

Артикул: 5667

Компания Philips объявила о расширении модельного ряда «умных» LED-лампочек в сотрудничестве с Xi..
Умная лампочка, E27 Xiaomi Philips Master LED candle Bulb GPX4005RT
7280 тг. 7615 тг.

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

Артикул: 5929

Компания Philips продолжает расширять модельный ряд «умных» LED-лампочек в сотрудничестве с Xiaom..
Матовая Led лампочка Xiaomi Philips Master LED candle Bulb GPX4009RT
7800 тг. 8159 тг.

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

Артикул: 5666

Компания Philips объявила о расширении модельного ряда «умных» LED-лампочек в сотрудничестве с Xi..
Умная Wifi лампа Xiaomi Yeelight LED Bulb
7800 тг. 8159 тг.

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

Артикул: 4621

Данный гаджет представляет собой светодиодную лампу со стандартным цоколем E27, оснащенную  возмо..
Лампа-ночник с датчиком движения и аккумулятором Xiaomi Yeelight Induction Night Light
8320 тг. 8703 тг.

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

Артикул: 5976

Xiaomi Yeelight Induction Night Light - это красивый и функциональный светильник, который не треб..
Пульт для потолочного светильника Xiaomi Philips Smart ceiling light remote control
8840 тг. 9247 тг.

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

Артикул: 5498

Минималистичный, но функциональный дизайн потолочной лампы Philips Ceiling Light, обеспечивает ка..
Умный ночник с магнитной подставкой-креплением Xiaomi MiJia Night Light 2
8840 тг. 9247 тг.

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

Артикул: 6582

Xiaomi MiJia Night Light 2 - это компактный умный ночник, главными особенностями которого являютс..
Умная Wifi лампа, теплый/холодный оттенки Xiaomi Yeelight LED IPL
9360 тг. 9791 тг.

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

Артикул: 4790

Компания Xiaomi продолжает развивать линейку устройств, входящих в систему "Умный дом" и выпускае..
Настольная лампа с клипсой и аккумулятором Xiaomi Yeelight J1 Pro LED Clip-on Table Lamp
9880 тг. 10334 тг.

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

Артикул: 6597

Беспроводная настольная лампа с клипсой Xiaomi Yeelight LED Clip-on Table Lamp Pro (модельYLTD12Y..
Потолочный светильник с датчиком движения Xiaomi Yeelight Meteorite LED Ceiling Light Mini
15600 тг. 16318 тг.

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

Артикул: 5928

В экосистему компании Xiaomi входит компания Yeelight, которая специализируется на производстве о..
Умная лампа ночник-свеча, Wifi, Bluetooth Xiaomi Yeelight Candela Lamp
17160 тг. 17949 тг.

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

Артикул: 5729

Большую часть аксессуаров умного дома, Xiaomi выпускает под суббрендом Mijia, но в последнее врем..
Настольная лампа с аккумулятором Xiaomi Yeelight LED Table Lamp
18200 тг. 19037 тг.

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

Артикул: 6378

Не так давно компания Xiaomi анонсировала новую настольную лампу Xiaomi Yeelight LED Table Lamp. Гл..
Прикроватная умная лампа-ночник Xiaomi Mijia Bedside Lamp 2
18200 тг. 19037 тг.

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

Артикул: 6588

В экосистеме Xiaomi Smart Home есть огромный выбор устройств освещения, которые помогут обеспечит..
Умный светильник Xiaomi MiJia Bedside Lamp
21320 тг. 22301 тг.

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

Артикул: 5521

Компания Xiaomi представила новинку - Умный ночник MiJia Bedside Lamp! В прошлом году Xiaomi уже ..
IP-веб камера Xiaomi MiJia Home Smart Camera PTZ
21840 тг. 22845 тг.

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

Артикул: 5501

Компания Xiaomi занимается производством продукции во многих сегмента рынка техники и электроники..
Ультрафиолетовая бактерицидная лампа Xiaomi HUAYI UV Disinfection Lamp SJ01
23400 тг. 24476 тг.

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

Артикул: 6611

Иногда стены — недостаточно надёжный защитник, особенно если речь идёт о незаметной угрозе, исход..
Умная лампа-ночник Xiaomi Philips Bedside Lamp
24960 тг. 26108 тг.

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

Артикул: 5955

Компания Xiaomi представила новый умный настольный светильник-ночник Philips Zhirui Bedside Lamp...
Умный ночник IPL, 16млн цветов Xiaomi YeeLight Bedside Lamp
24960 тг. 26108 тг.

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

Артикул: 4140

Во 2й половине 2015 года, компания Xiaomi представила публике необычный гаджет - умный ночник Xia..
Потолочный светильник Xiaomi Yeelight Smart LED Ceiling Lamp
41600 тг. 43514 тг.

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

Артикул: 5274

Если вы в поиске красивого стильного светильника, который будет служить вам долгие годы и украсит..
Потолочный светильник Xiaomi Philips Smart ceiling light
46800 тг. 48953 тг.

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

Артикул: 5497

Сейчас компания Xiaomi занимает практически все ниши рынка электроники - помимо смартфонов и друг..
Показано с 1 по 45 из 45 (всего 1 страниц)
Queries: 79, Total time: 182.008 ms [By time] [By id] [By file]
1 (0.567)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://micom.kz/'
/var/www/vhosts/citycom.kz/micom.kz/index.php:45,
2 (1.712)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/var/www/vhosts/citycom.kz/micom.kz/index.php:57,
3 (0.671)
SELECT *
FROM `oc_language`
WHERE status = '1'
/var/www/vhosts/citycom.kz/micom.kz/index.php:141,
4 (0.652)
SELECT *
FROM oc_currency
/var/www/vhosts/citycom.kz/micom.kz/system/library/currency.php:13, /var/www/vhosts/citycom.kz/micom.kz/index.php:221,
5 (0.596)
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
/var/www/vhosts/citycom.kz/micom.kz/system/library/tax.php:26, /var/www/vhosts/citycom.kz/micom.kz/system/library/tax.php:13, /var/www/vhosts/citycom.kz/micom.kz/index.php:224,
6 (0.571)
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
/var/www/vhosts/citycom.kz/micom.kz/system/library/tax.php:54, /var/www/vhosts/citycom.kz/micom.kz/system/library/tax.php:22, /var/www/vhosts/citycom.kz/micom.kz/index.php:224,
7 (0.473)
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'
/var/www/vhosts/citycom.kz/micom.kz/system/library/weight.php:9, /var/www/vhosts/citycom.kz/micom.kz/index.php:227,
8 (0.707)
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'
/var/www/vhosts/citycom.kz/micom.kz/system/library/length.php:9, /var/www/vhosts/citycom.kz/micom.kz/index.php:230,
9 (0.546)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/var/www/vhosts/citycom.kz/micom.kz/system/library/openbay.php:116, /var/www/vhosts/citycom.kz/micom.kz/system/library/openbay.php:10, /var/www/vhosts/citycom.kz/micom.kz/index.php:239,
10 (0.485)
SELECT *
FROM oc_event
/var/www/vhosts/citycom.kz/micom.kz/index.php:245,
11 (0.715)
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 = '134' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
/var/www/vhosts/citycom.kz/micom.kz/catalog/model/catalog/category.php:4, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:77, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
12 (1.445)
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 = '142' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
/var/www/vhosts/citycom.kz/micom.kz/catalog/model/catalog/category.php:4, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:90, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
13 (3.757)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '142' AND cd.language_id = '3' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/var/www/vhosts/citycom.kz/micom.kz/catalog/model/catalog/category.php:10, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:154, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
14 (12.935)
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 = '142'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:626, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:181, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
15 (14.140)
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 = '142' 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
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:260, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
16 (7.807)
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 = '537' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
17 (3.324)
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 = '1366' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
18 (2.487)
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 = '1278' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
19 (2.394)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND customer_group_id = '1') AS reward, (SELECT ss.name
FROM oc_stock_status ss
WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '3') AS stock_status, (SELECT wcd.unit
FROM oc_weight_class_description wcd
WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '3') AS weight_class, (SELECT lcd.unit
FROM oc_length_class_description lcd
WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '3') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1307' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
20 (2.325)
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 = '808' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
21 (2.335)
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 = '1372' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
22 (2.304)
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'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
23 (2.378)
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 = '1183' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
24 (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 = '806' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
25 (2.431)
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 = '1359' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
26 (2.909)
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 = '1286' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
27 (2.501)
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 = '1313' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
28 (3.225)
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 = '1318' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
29 (3.055)
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'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
30 (3.191)
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 = '894' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
31 (2.736)
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 = '612' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
32 (2.342)
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'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
33 (2.607)
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 = '876' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
34 (2.472)
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 = '1362' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
35 (2.289)
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 = '1333' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
36 (6.411)
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 = '1335' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
37 (3.960)
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 = '274' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
38 (2.413)
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 = '522' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
39 (2.313)
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 = '1257' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
40 (2.609)
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 = '877' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
41 (2.358)
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 = '914' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
42 (2.419)
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 = '994' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
43 (2.439)
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 = '915' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
44 (2.256)
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 = '531' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
45 (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 = '1014' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
46 (2.838)
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 = '870' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
47 (2.682)
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 = '1181' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
48 (2.724)
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 = '626' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
49 (2.330)
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 = '1187' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
50 (2.123)
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 = '1002' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
51 (2.045)
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 = '944' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
52 (2.000)
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 = '1104' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
53 (2.036)
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 = '1190' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
54 (2.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 = '872' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
55 (2.224)
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 = '864' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
56 (3.253)
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 = '1195' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
57 (2.188)
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 = '1016' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
58 (2.220)
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 = '259' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
59 (2.774)
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 = '804' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
60 (3.273)
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 = '869' AND pd.language_id = '3' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:8, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/model/catalog/product.php:263, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:183, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
61 (0.734)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '142' AND store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/catalog/model/catalog/category.php:55, /var/www/vhosts/citycom.kz/micom.kz/catalog/controller/common/column_left.php:19, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:397, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
62 (1.019)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/vhosts/citycom.kz/micom.kz/catalog/model/design/layout.php:4, /var/www/vhosts/citycom.kz/micom.kz/catalog/controller/common/column_left.php:35, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:397, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
63 (0.943)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'column_left'
ORDER BY sort_order
/var/www/vhosts/citycom.kz/micom.kz/catalog/model/design/layout.php:14, /var/www/vhosts/citycom.kz/micom.kz/catalog/controller/common/column_left.php:46, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:397, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
64 (1.110)
SELECT *
FROM oc_module
WHERE module_id = '48'
/var/www/vhosts/citycom.kz/micom.kz/catalog/model/extension/module.php:4, /var/www/vhosts/citycom.kz/micom.kz/catalog/controller/common/column_left.php:56, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:397, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
65 (0.645)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '142' AND store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/catalog/model/catalog/category.php:55, /var/www/vhosts/citycom.kz/micom.kz/catalog/controller/common/column_right.php:19, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:398, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
66 (0.535)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/vhosts/citycom.kz/micom.kz/catalog/model/design/layout.php:4, /var/www/vhosts/citycom.kz/micom.kz/catalog/controller/common/column_right.php:35, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:398, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
67 (1.340)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'column_right'
ORDER BY sort_order
/var/www/vhosts/citycom.kz/micom.kz/catalog/model/design/layout.php:14, /var/www/vhosts/citycom.kz/micom.kz/catalog/controller/common/column_right.php:44, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:398, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
68 (0.733)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '142' AND store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/catalog/model/catalog/category.php:55, /var/www/vhosts/citycom.kz/micom.kz/catalog/controller/common/content_top.php:19, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:399, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
69 (0.507)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/vhosts/citycom.kz/micom.kz/catalog/model/design/layout.php:4, /var/www/vhosts/citycom.kz/micom.kz/catalog/controller/common/content_top.php:35, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:399, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
70 (1.247)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'content_top'
ORDER BY sort_order
/var/www/vhosts/citycom.kz/micom.kz/catalog/model/design/layout.php:14, /var/www/vhosts/citycom.kz/micom.kz/catalog/controller/common/content_top.php:44, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:399, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
71 (0.770)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '142' AND store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/catalog/model/catalog/category.php:55, /var/www/vhosts/citycom.kz/micom.kz/catalog/controller/common/content_bottom.php:19, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:400, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
72 (0.560)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/vhosts/citycom.kz/micom.kz/catalog/model/design/layout.php:4, /var/www/vhosts/citycom.kz/micom.kz/catalog/controller/common/content_bottom.php:35, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:400, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
73 (1.166)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'content_bottom'
ORDER BY sort_order
/var/www/vhosts/citycom.kz/micom.kz/catalog/model/design/layout.php:14, /var/www/vhosts/citycom.kz/micom.kz/catalog/controller/common/content_bottom.php:44, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:400, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
74 (2.055)
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
/var/www/vhosts/citycom.kz/micom.kz/catalog/model/catalog/information.php:10, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_catalog_controller_common_footer.php:46, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:401, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
75 (0.642)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '142' AND store_id = '0'
/var/www/vhosts/citycom.kz/micom.kz/catalog/model/catalog/category.php:55, /var/www/vhosts/citycom.kz/micom.kz/catalog/controller/common/footer_top.php:19, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_catalog_controller_common_footer.php:74, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:401, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
76 (0.572)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/var/www/vhosts/citycom.kz/micom.kz/catalog/model/design/layout.php:4, /var/www/vhosts/citycom.kz/micom.kz/catalog/controller/common/footer_top.php:35, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_catalog_controller_common_footer.php:74, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:401, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
77 (1.207)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'footer_top'
ORDER BY sort_order
/var/www/vhosts/citycom.kz/micom.kz/catalog/model/design/layout.php:14, /var/www/vhosts/citycom.kz/micom.kz/catalog/controller/common/footer_top.php:44, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_catalog_controller_common_footer.php:74, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:401, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
78 (1.069)
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
/var/www/vhosts/citycom.kz/micom.kz/catalog/model/catalog/information.php:10, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/common/header.php:43, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:402, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,
79 (0.807)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/var/www/vhosts/citycom.kz/micom.kz/catalog/model/extension/extension.php:4, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/common/cart.php:17, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/common/header.php:201, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_loader.php:12, /var/www/vhosts/citycom.kz/micom.kz/system/modification/catalog/controller/product/category.php:402, /var/www/vhosts/citycom.kz/micom.kz/vqmod/vqcache/vq2-system_modification_system_engine_action.php:65, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:37, /var/www/vhosts/citycom.kz/micom.kz/system/modification/system/engine/front.php:30, /var/www/vhosts/citycom.kz/micom.kz/index.php:268,