Мультимедіа

Караоке дитяче Auna Rockstar LightShow (10034074)

Караоке дитяче Auna Rockstar LightShow (10034074)

Завдяки функції Bluetooth караоке-система відтворює всі аудіофайли зі смартфонів та планшетів. Підключеним пристроєм легко керувати, коли він знаходиться у спеціальному тримачі. Крім того, MP3-файли можна відтворювати через порт USB на передній панелі пристрою та записувати за допомогою практичної ф..

1200грн

Караоке дитяче Auna SingSing BT (10035790)

Караоке дитяче Auna SingSing BT (10035790)

Переносна дитяча дискотека! Ауна SingSing BT - це весела караоке-система з розумними функціями і зручним для дітей дизайном. Окрім звичайних типів дисків, також відтворює медіафайли CD+G, тобто караоке-компакт-диски з субтитрами. Доречно, що на задній панелі є відеовихід RCA, який пересилає сигнал ..

850грн 450грн

Караоке дитяче Auna StarMaker (10029187)

Караоке дитяче Auna StarMaker (10029187)

Караоке дитяче Auna StarMaker, привезене з Німеччини.Караоке-система поєднує в собі повнофункціональні варіанти універсального аудіо- та відео- підключення. Також, StarMaker обладнаний барвистими різнокольоровими світлодіодними ефектами, що покращують настрій і роблять караоке-гру ще цікавішою...

1100грн 800грн

Караоке дитяче Auna StarMaker 2.0 (10035823)

Караоке дитяче Auna StarMaker 2.0 (10035823)

Не тільки для юних талантів: за допомогою караоке системи auna StarMaker 2.0 дорослі також зможуть розкрити свій прихований співочий талант. Це ідеальне доповнення до будь-якої вечірки, дитячого дня народження або сімейної урочистості. CD-привід відтворює безліч форматів: стандартні компакт-диски, а..

1300грн

Караоке система 2.1 Auna DiscoStar (10028848)

Караоке система 2.1 Auna DiscoStar (10028848)

Колонка auna DiscoStar виправдовує свою назву, перетворюючи навіть найсумніше місце на наповнений вогнями танцпол. Стриманий зовнішній вигляд, багатий набір функцій та безліч привабливих деталей роблять колонку бажаним гостем на заходах, що вимагають музичного супроводу. Повністю мобільна Bluetooth..

1450грн 1100грн

Колонка портативна активна FENTON FT215LED (170.094)

Колонка портативна активна FENTON FT215LED (170.094)

Повноцінна активна колонка потужністю 1600 Вт з можливістю підключення по BT. Ідеально підходить для аудиторій середнього розміру та вечірок, шкіл чи презентацій. З бездротовою технологією BT користувачі можуть просто підключити свій пристрій та транслювати музику через колонку.Колонка оснащена спец..

8900грн

Мікрофон студійний Auna CM280 (10011708)

Мікрофон студійний Auna CM280 (10011708)

Конденсаторний мікрофон Auna CM280 призначений для професійного запису. Широкий частотний діапазон та високоякісний цифро-аналоговий перетворювач 44,1/48 kHz дозволяють досягти найкращої студійної якості при записі вокалу, голосу та інструментів. Завдяки типовій кардіоїдній характеристиці, мікрофон ..

1300грн

Мікрофон студійний Auna MIC-600 (10035300)

Мікрофон студійний Auna MIC-600 (10035300)

Конденсаторний USB мікрофон auna MIC-600 розроблений для сучасних цифрових додатків. Запис вокалу в студії, подкасти або дублювання відео: його можна легко підключити до ПК або ноутбука за допомогою USB-кабелю, і він одразу ж готовий до використання завдяки технології Plug & Play. Студійний USB..

1300грн

Мікрофони безпровідні з радіобазою Power Dynamics PD632H (179.010)

Мікрофони безпровідні з радіобазою Power Dynamics PD632H (179.010)

Power Dynamics PD632H пропонує комплект із двома бездротовими мікрофонами. Крім того, ці мікрофони поставляються в алюмінієвому кейсі для зручності транспортування. Мікрофони PD632H дуже високої якості, зручні у використанні та важать лише 400 грам! Вони оснащені дисплеєм та функцією відключення зву..

3000грн 1500грн

Мікрофони безпровідні з радіобазою Skytec STWM722C

Мікрофони безпровідні з радіобазою Skytec STWM722C

Двохканальна бездротова мікрофонна система УВЧ із рознесеними антенами, що включає ручний мікрофон та поясний передавач із мікрофоном на гарнітурі. Обидва передавачі працюють на різних частотах. Хороша якість звуку та надійність завдяки технології рознесення. Ідеально підходить для сцени, вокалістів..

1400грн

Мікшерний пульт Auna Kemistry 3 (10021733)

Мікшерний пульт Auna Kemistry 3 (10021733)

Auna Pro Kemistry 3 - це високофункціональний 4-канальний DJ-мікшер. На додаток до широкого спектру підключень, зручного дизайну в стійці та технічних вдосконалень, таких як Bluetooth, USB і SD, пристрій також може похвалитися чітким компонуванням із чорним зручним інтерфейсом. Мікшер має всі можлив..

3500грн

Навушники Skytec SH120 (100.863)

Навушники Skytec SH120 (100.863)

Навушники SH120 - це зручні ді-джейські навушники від Skytec, які відрізняються відмінною якістю звуку та зручною формою.Мала вага та м'які амбушюри забезпечують комфорт при носінні протягом кількох годин. Регульоване оголов'я має м'яку оббивку зі шкірозамінника. Велика довжина кабелю 2 метри. Додає..

350грн 300грн

Підсилювач HiFi Auna AMP-CD950 DG (10035067)

Підсилювач HiFi Auna AMP-CD950 DG (10035067)

Підсилювач auna AMP-CD950 DG - потужний пристрій, що регулює домашній hi-fi ландшафт. Має оптичний, Bluetooth, CD та DVD входи, а також MP3 і AUX. Вбудований процесор оптимізує звук шляхом придушення шумів і еха. Гучність, високі частоти та баланс налаштовуються під індивідуальні потреби. Чотири сте..

4000грн

Підсилювач караоке Auna AMP-9200 BT (10034593)

Підсилювач караоке Auna AMP-9200 BT (10034593)

Підсилювач Auna AMP-9200 BT оснащений інтерфейсом Bluetooth, всі аудіофайли можна зручно відтворювати без дротів зі смартфона, планшета чи ноутбука в межах 20 метрів. Підсилювач має AUX аудіовхід, вхід DVD, порт USB та SD-слот. Два мікрофонні входи на передній панелі перетворюють підсилювач на повно..

2800грн 2500грн

Портативний CD-програвач OneConcept CDC 100 BT (10033715)

Портативний CD-програвач OneConcept CDC 100 BT (10033715)

Повернення легенди: портативний програвач компакт-дисків OneConcept CDC 100 BT повертає вас в еру компакт-дисків разом з сучасними технологіями! Завдяки можливості підключення Bluetooth він може підключатися до бездротових навушників у вас під рукою і надійно відтворювати аудіосигнали в форматах CD,..

600грн

Програвач ретро Стереосистема Auna Belle Epoque 1906 (10040054)

Програвач ретро Стереосистема Auna Belle Epoque 1906 (10040054)

Ретро-стереосистема auna Belle Epoque 1906 з її чарівним дизайном зводить музичний міст між минулим і майбутнім. Діапазон варіантів відтворення включає FM-радіотюнер з ручним керуванням частотою, CD привід, AUX вхід і USB-інтерфейс. На додаток до звичайних типів дисків, привід також читає компакт-ди..

2600грн 2100грн

Програвач ретро Стереосистема Auna Glastonbury (10041147)

Програвач ретро Стереосистема Auna Glastonbury (10041147)

Радіоприймач auna Glastonbury з DAB радіо та програвачем компакт-дисків - це сучасний пристрій, який прикрасить ваш житловий простір завдяки вражаючому ретро-дизайну. Чи то рок, поп, джаз, класика чи новини з усього світу – з Glastonbury ви завжди будете в курсі подій. Кришталево чистий звук у цифро..

2500грн

Програвач ретро Стереосистема Auna NR-550-B (10021731)

Програвач ретро Стереосистема Auna NR-550-B (10021731)

Стереосистема Auna NR-550-B призначена спеціально для любителя ретро-стилю, який потребує сучасного набору функцій.Через Bluetooth можна легко підключити Auna NR-550-B до смартфону та комп'ютера для відтворення улюбленої музики. USB-порт на передній панелі використовується для відтворення треків MP3..

2200грн


Мультимедіа
Queries: 329, Total time: 382.351 ms [By time] [By id] [By file]
1 (10.297)
SELECT `data`
FROM `oc_session`
WHERE session_id = '42aac7e8d229497f39b1030d27' AND expire > 1738942798
/profiles/s/st/sto/stockishop/stockishop.com/system/library/session/db.php:21
2 (0.597)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/openbay.php:61
3 (0.728)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
4 (0.709)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/openbay.php:61
5 (0.726)
SET SQL_BIG_SELECTS = 1
/profiles/s/st/sto/stockishop/stockishop.com/system/library/ocfilter/opencart.php:29
6 (1.574)
SHOW TABLES LIKE 'oc_ocfilter_setting'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/ocfilter/setting.php:10
7 (0.774)
SELECT *
FROM oc_ocfilter_setting
/profiles/s/st/sto/stockishop/stockishop.com/system/library/ocfilter/setting.php:18
8 (0.883)
SELECT `data`
FROM `oc_session`
WHERE session_id = '49b43db82731a0e4288d5de904' AND expire > 1738942798
/profiles/s/st/sto/stockishop/stockishop.com/system/library/session/db.php:21
9 (0.757)
SELECT *
FROM oc_store
WHERE REPLACE(`ssl`, 'www.', '') = 'https://stockishop.com/'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/controller/startup/startup.php:6
10 (1.568)
SELECT *
FROM `oc_setting`
WHERE store_id = '0' OR store_id = '0'
ORDER BY store_id ASC
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/controller/startup/startup.php:25
11 (0.618)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/localisation/language.php:15
12 (0.701)
SELECT *
FROM oc_store
ORDER BY url
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/setting/store.php:7
13 (0.624)
SELECT *
FROM oc_language
WHERE status = '1'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/agoo/multilang.php:32
14 (0.530)
SELECT *
FROM oc_currency
/profiles/s/st/sto/stockishop/stockishop.com/system/library/cart/currency.php:10
15 (0.466)
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 = '220' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '0')
ORDER BY tr1.priority ASC
/profiles/s/st/sto/stockishop/stockishop.com/system/library/cart/tax.php:44
16 (0.385)
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 = '2'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/cart/weight.php:10
17 (0.376)
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 = '2'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/cart/length.php:10
18 (0.652)
DELETE
FROM oc_cart
WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:86
19 (0.380)
SELECT *
FROM oc_extension
WHERE `type` = 'openbay'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/openbay.php:61
20 (0.474)
SELECT *
FROM `oc_event`
WHERE `trigger` LIKE 'catalog/%' AND status = '1'
ORDER BY `sort_order` ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/setting/event.php:4
21 (0.376)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/category' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
22 (0.327)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'product_option_image_pro'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/lib/v0015/traits/installed.php:12
23 (0.347)
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 = '18' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/category.php:19
24 (0.340)
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 = '18' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/category.php:25
25 (0.344)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '18' AND store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/category.php:70
26 (0.327)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/design/layout.php:4
27 (0.365)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND `code` = 'ocfilter'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/ocfilter/core.php:78
28 (30.926)
SELECT COUNT(DISTINCT p.product_id) AS total
FROM oc_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '18'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:622
29 (48.845)
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_category_path cp
LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id)
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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '18' GROUP BY p.product_id
ORDER BY (p.quantity>0) DESC, LCASE(pd.name) ASC, LCASE(pd.name) ASC LIMIT 18,18
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:240
30 (1.330)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
31 (1.805)
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 pr.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 = '2') 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 = '2') 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 = '2') 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 = '728' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
32 (1.165)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
33 (1.520)
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 pr.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 = '2') 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 = '2') 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 = '2') 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 = '1046' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
34 (1.170)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
35 (1.559)
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 pr.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 = '2') 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 = '2') 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 = '2') 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 = '549' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
36 (0.985)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
37 (1.574)
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 pr.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 = '2') 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 = '2') 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 = '2') 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 = '1063' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
38 (1.096)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
39 (1.507)
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 pr.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 = '2') 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 = '2') 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 = '2') 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 = '1099' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
40 (1.056)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
41 (1.502)
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 pr.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 = '2') 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 = '2') 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 = '2') 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 = '1041' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
42 (1.063)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
43 (1.525)
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 pr.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 = '2') 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 = '2') 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 = '2') AS length_class, (SELECT AVG(rating) AS total
FROM oc_review r1
WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total
FROM oc_review r2
WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order
FROM oc_product p
LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id)
LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id)
LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id)
WHERE p.product_id = '1061' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
44 (1.195)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
45 (1.536)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '2') 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 = '2') 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 = '2') 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 = '1059' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
46 (1.035)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
47 (1.514)
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 pr.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 = '2') 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 = '2') 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 = '2') 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 = '757' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
48 (1.042)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
49 (1.421)
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 pr.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 = '2') 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 = '2') 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 = '2') 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 = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
50 (1.180)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
51 (1.638)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '2') 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 = '2') 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 = '2') 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 = '949' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
52 (1.063)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
53 (1.602)
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 pr.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 = '2') 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 = '2') 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 = '2') 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 = '744' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
54 (1.243)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
55 (1.362)
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 pr.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 = '2') 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 = '2') 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 = '2') 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 = '1199' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
56 (1.089)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
57 (1.537)
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 pr.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 = '2') 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 = '2') 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 = '2') 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 = '953' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
58 (1.064)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
59 (1.601)
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 pr.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 = '2') 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 = '2') 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 = '2') 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 = '308' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
60 (1.112)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
61 (1.512)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '2') 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 = '2') 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 = '2') 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 = '1196' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
62 (1.066)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
63 (1.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 pr.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 = '2') 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 = '2') 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 = '2') 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 = '1123' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
64 (1.028)
SHOW COLUMNS
FROM `oc_option_description` LIKE 'description'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:443
65 (1.523)
SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price
FROM oc_product_discount pd2
WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW()))
ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price
FROM oc_product_special ps
WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW()))
ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points
FROM oc_product_reward pr
WHERE pr.product_id = p.product_id AND pr.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 = '2') 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 = '2') 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 = '2') 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 = '1208' AND pd.language_id = '2' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:11
66 (0.755)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 728
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
67 (0.837)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 1567 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
68 (0.737)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 1567
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
69 (0.723)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 1566 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
70 (0.738)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 1566
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
71 (1.142)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 728 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
72 (0.647)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '728' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
73 (0.639)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '728' AND pov.product_option_id = '1567' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
74 (0.977)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 728 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
75 (0.630)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '728' AND pov.product_option_id = '1566' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
76 (0.824)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 1046
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
77 (0.727)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 2219 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
78 (0.756)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 2219
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
79 (0.730)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 2218 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
80 (0.847)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 2218
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
81 (1.074)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 1046 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
82 (0.624)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '1046' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
83 (0.615)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '1046' AND pov.product_option_id = '2218' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
84 (1.200)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 1046 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
85 (0.681)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '1046' AND pov.product_option_id = '2219' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
86 (0.969)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 549
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
87 (0.811)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 1202 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
88 (0.558)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 1202
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
89 (0.910)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 1201 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
90 (0.871)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 1201
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
91 (1.176)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 549 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
92 (0.456)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '549' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
93 (0.845)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '549' AND pov.product_option_id = '1201' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
94 (1.066)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 549 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
95 (0.525)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '549' AND pov.product_option_id = '1202' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
96 (0.532)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 1063
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
97 (0.612)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 2253 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
98 (0.572)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 2253
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
99 (0.587)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 2252 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
100 (0.553)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 2252
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
101 (0.582)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 1063 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
102 (0.607)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '1063' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
103 (0.633)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '1063' AND pov.product_option_id = '2252' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
104 (0.482)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 1063 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
105 (0.463)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '1063' AND pov.product_option_id = '2253' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
106 (0.696)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 1099
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
107 (0.625)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 3422 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
108 (0.573)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 3422
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
109 (0.671)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 3421 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
110 (0.656)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 3421
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
111 (1.323)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 1099 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
112 (0.714)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '1099' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
113 (0.459)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '1099' AND pov.product_option_id = '3422' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
114 (1.092)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 1099 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
115 (0.851)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '1099' AND pov.product_option_id = '3421' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
116 (1.090)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 1041
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
117 (0.927)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 2209 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
118 (0.806)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 2209
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
119 (1.085)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 2208 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
120 (0.923)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 2208
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
121 (1.415)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 1041 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
122 (0.710)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '1041' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
123 (0.699)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '1041' AND pov.product_option_id = '2209' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
124 (1.209)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 1041 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
125 (0.549)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '1041' AND pov.product_option_id = '2208' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
126 (0.930)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 1061
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
127 (0.767)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 2248 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
128 (0.613)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 2248
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
129 (0.592)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 2249 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
130 (0.515)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 2249
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
131 (1.161)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 1061 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
132 (0.732)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '1061' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
133 (0.734)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '1061' AND pov.product_option_id = '2249' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
134 (1.190)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 1061 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
135 (0.725)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '1061' AND pov.product_option_id = '2248' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
136 (0.916)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 1059
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
137 (1.038)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 2245 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
138 (0.841)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 2245
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
139 (0.754)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 2244 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
140 (0.819)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 2244
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
141 (1.352)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 1059 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
142 (0.641)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '1059' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
143 (0.595)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '1059' AND pov.product_option_id = '2244' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
144 (1.252)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 1059 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
145 (0.772)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '1059' AND pov.product_option_id = '2245' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
146 (0.793)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 757
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
147 (0.616)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 1625 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
148 (0.402)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 1625
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
149 (0.378)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 1626 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
150 (0.320)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 1626
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
151 (0.388)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 757 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
152 (0.439)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '757' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
153 (0.430)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '757' AND pov.product_option_id = '1625' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
154 (0.432)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 757 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
155 (0.442)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '757' AND pov.product_option_id = '1626' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
156 (0.807)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 1002
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
157 (0.828)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 2131 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
158 (0.776)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 2131
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
159 (0.787)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 2130 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
160 (0.749)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 2130
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
161 (1.235)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 1002 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
162 (0.659)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '1002' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
163 (0.584)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '1002' AND pov.product_option_id = '2131' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
164 (1.205)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 1002 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
165 (0.516)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '1002' AND pov.product_option_id = '2130' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
166 (0.892)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 949
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
167 (0.937)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 2024 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
168 (0.773)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 2024
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
169 (0.841)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 2025 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
170 (0.839)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 2025
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
171 (1.170)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 949 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
172 (0.695)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '949' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
173 (0.643)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '949' AND pov.product_option_id = '2024' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
174 (1.211)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 949 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
175 (0.610)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '949' AND pov.product_option_id = '2025' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
176 (1.020)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 744
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
177 (0.904)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 2985 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
178 (0.888)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 2985
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
179 (0.779)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 2986 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
180 (0.897)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 2986
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
181 (1.345)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 744 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
182 (0.498)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '744' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
183 (0.505)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '744' AND pov.product_option_id = '2986' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
184 (1.373)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 744 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
185 (0.731)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '744' AND pov.product_option_id = '2985' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
186 (1.081)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 1199
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
187 (0.828)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 3443 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
188 (1.002)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 3443
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
189 (0.937)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 3444 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
190 (0.785)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 3444
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
191 (1.252)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 1199 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
192 (0.605)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '1199' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
193 (0.582)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '1199' AND pov.product_option_id = '3444' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
194 (1.182)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 1199 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
195 (0.663)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '1199' AND pov.product_option_id = '3443' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
196 (0.832)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 953
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
197 (0.867)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 3362 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
198 (0.886)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 3362
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
199 (0.890)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 3361 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
200 (0.627)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 3361
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
201 (1.160)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 953 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
202 (0.608)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '953' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
203 (0.592)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '953' AND pov.product_option_id = '3362' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
204 (1.319)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 953 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
205 (0.605)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '953' AND pov.product_option_id = '3361' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
206 (0.844)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 308
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
207 (0.785)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 3441 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
208 (0.766)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 3441
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
209 (0.799)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 3442 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
210 (0.868)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 3442
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
211 (1.232)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 308 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
212 (0.619)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '308' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
213 (0.592)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '308' AND pov.product_option_id = '3442' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
214 (1.314)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 308 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
215 (0.686)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '308' AND pov.product_option_id = '3441' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
216 (0.976)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 1196
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
217 (0.794)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 3436 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
218 (0.727)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 3436
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
219 (0.899)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 3435 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
220 (0.776)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 3435
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
221 (2.219)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 1196 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
222 (0.607)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '1196' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
223 (0.650)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '1196' AND pov.product_option_id = '3436' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
224 (1.946)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 1196 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
225 (0.687)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '1196' AND pov.product_option_id = '3435' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
226 (0.940)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 1123
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
227 (0.896)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 2374 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
228 (0.639)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 2374
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
229 (0.721)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 2375 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
230 (0.798)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 2375
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
231 (2.337)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 1123 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
232 (0.741)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '1123' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
233 (0.739)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '1123' AND pov.product_option_id = '2374' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
234 (1.889)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 1123 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
235 (0.660)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '1123' AND pov.product_option_id = '2375' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
236 (0.904)
SELECT product_option_id
FROM oc_product_option
WHERE product_id = 1208
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:250
237 (0.746)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 3471 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
238 (0.761)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 3471
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
239 (0.800)
SELECT PMOS.*, PS.product_option_id
FROM oc_poip_main_option_settings PMOS, oc_product_option PS
WHERE PS.product_option_id = 3472 AND PS.option_id = PMOS.option_id
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:187
240 (0.762)
SELECT *
FROM oc_poip_option_settings
WHERE product_option_id = 3472
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/ext/poip.php:219
241 (1.516)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 1208 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id AND ( (POV.product_option_value_id IS NULL) OR (NOT POV.subtract OR POV.quantity > 0) )
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
242 (0.811)
SELECT *
FROM oc_product_option po
LEFT JOIN `oc_option` o ON (po.option_id = o.option_id)
LEFT JOIN oc_option_description od ON (o.option_id = od.option_id)
WHERE po.product_id = '1208' AND od.language_id = '2'
ORDER BY o.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:388
243 (0.620)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '1208' AND pov.product_option_id = '3472' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
244 (1.290)
SELECT POIP.*, OV.image thumb, OD.name option_name, OVD.name value_name, PO.option_id, POV.option_value_id, POV.product_option_value_id pov_product_option_value_id
FROM oc_poip_option_image POIP
LEFT JOIN oc_product_option_value POV ON ( POIP.product_option_id = POV.product_option_id AND (POIP.product_option_value_id = POV.product_option_value_id OR POIP.product_option_value_id = -1) )
LEFT JOIN oc_option_value OV ON (POV.option_value_id = OV.option_value_id)
LEFT JOIN oc_option_value_description OVD ON (OVD.option_value_id = OV.option_value_id AND OVD.language_id = 2) ,`oc_option` O
LEFT JOIN oc_option_description OD ON (OD.option_id = O.option_id AND OD.language_id = 2) ,oc_product_option PO
WHERE POIP.product_id = 1208 AND PO.product_option_id = POIP.product_option_id AND PO.option_id = O.option_id
ORDER BY O.sort_order ASC, POIP.product_option_id ASC, OV.sort_order ASC, POIP.product_option_value_id, POIP.sort_order ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/extension/liveopencart/product_option_image_pro.php:576
245 (0.777)
SELECT *
FROM oc_product_option_value pov
LEFT JOIN oc_option_value ov ON (pov.option_value_id = ov.option_value_id)
LEFT JOIN oc_option_value_description ovd ON (ov.option_value_id = ovd.option_value_id)
WHERE pov.product_id = '1208' AND pov.product_option_id = '3471' AND ovd.language_id = '2'
ORDER BY ov.sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/product.php:393
246 (0.820)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/ocfilter' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
247 (0.741)
SELECT p.page_id, p.params, p.params_count, p.category_id, pd.name, pd.heading_title, (SELECT GROUP_CONCAT(DISTINCT cp.path_id
ORDER BY cp.`level` SEPARATOR '_') AS path
FROM oc_category_path cp
WHERE cp.category_id = p.category_id) AS path, (SELECT su.keyword
FROM oc_seo_url su
WHERE su.language_id = '2' AND su.store_id = '0' AND su.`query` = CONCAT('ocfilter_page_id=', p.page_id) LIMIT 1) AS keyword
FROM oc_ocfilter_page p
LEFT JOIN oc_ocfilter_page_description pd ON (p.page_id = pd.page_id)
WHERE p.status = '1' AND p.dynamic = '0' AND pd.language_id = '2' AND p.category_id = '18' AND p.category = '1'
ORDER BY p.page_id DESC
/profiles/s/st/sto/stockishop/stockishop.com/system/library/ocfilter/core.php:78
248 (9.699)
SELECT COUNT(DISTINCT p.product_id) AS total, p.manufacturer_id AS vid
FROM oc_product p
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN oc_category_path cp ON (p2c.category_id = cp.category_id)
WHERE p.status = '1' AND p.date_available <= '2025-02-07' AND cp.path_id = '18' GROUP BY vid
/profiles/s/st/sto/stockishop/stockishop.com/system/library/ocfilter/core.php:78
249 (10.586)
SELECT COUNT(DISTINCT p.product_id) AS total, IF(p.quantity > '0', '2', '1') AS vid
FROM oc_product p
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN oc_category_path cp ON (p2c.category_id = cp.category_id)
WHERE p.status = '1' AND p.date_available <= '2025-02-07' AND cp.path_id = '18' GROUP BY vid
/profiles/s/st/sto/stockishop/stockishop.com/system/library/ocfilter/core.php:78
250 (5.197)
SELECT COUNT(DISTINCT p.product_id) AS total, CONCAT(fv2p.filter_id, '.', fv2p.source) AS fk, fv2p.value_id AS vid
FROM oc_ocfilter_filter_value_to_product fv2p
LEFT JOIN oc_product p ON (fv2p.product_id = p.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN oc_category_path cp ON (p2c.category_id = cp.category_id)
WHERE p.status = '1' AND p.date_available <= '2025-02-07' AND cp.path_id = '18' GROUP BY fk, vid
/profiles/s/st/sto/stockishop/stockishop.com/system/library/ocfilter/core.php:78
251 (0.708)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '18' AND store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/category.php:70
252 (0.666)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/design/layout.php:4
253 (0.626)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'column_left'
ORDER BY sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/design/layout.php:23
254 (0.612)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/ocfilter' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
255 (0.619)
SELECT *
FROM oc_ocfilter_setting
WHERE `key` = 'placement_layout'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/ocfilter/setting.php:68
256 (0.615)
SELECT CONCAT(f.filter_id, '.', f.source) AS filter_key
FROM oc_ocfilter_filter f
LEFT JOIN oc_ocfilter_filter_to_store f2s ON (f.filter_id = f2s.filter_id AND f.source = f2s.source)
LEFT JOIN oc_ocfilter_filter_to_category f2c ON (f.filter_id = f2c.filter_id)
LEFT JOIN oc_category_path cp ON (f2c.category_id = cp.category_id)
WHERE f.status = '1' AND f2s.store_id = '0' AND (cp.path_id = '18' OR f2c.category_id = '0') GROUP BY f.filter_id, f.source
/profiles/s/st/sto/stockishop/stockishop.com/system/library/ocfilter/core.php:78
257 (2.703)
SELECT MIN(price) AS `min`, MAX(price) AS `max`
FROM (SELECT ocf_ps.price
FROM oc_product_special ocf_ps
LEFT JOIN oc_product p ON (ocf_ps.product_id = p.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN oc_category_path cp ON (p2c.category_id = cp.category_id)
WHERE ocf_ps.price > '0' AND ocf_ps.customer_group_id = '1' AND ((ocf_ps.date_start = '0000-00-00' OR ocf_ps.date_start < '2025-02-07') AND (ocf_ps.date_end = '0000-00-00' OR ocf_ps.date_end > '2025-02-07')) AND p.status = '1' AND p.date_available <= '2025-02-07' AND cp.path_id = '18') result
/profiles/s/st/sto/stockishop/stockishop.com/system/library/ocfilter/core.php:78
258 (1.653)
SELECT MIN(price) AS `min`, MAX(price) AS `max`
FROM (SELECT option_price AS price
FROM (SELECT COALESCE( IF(ocf_pov.price_prefix = '-', p.price - ocf_pov.price, NULL), IF(ocf_pov.price_prefix = '+', p.price + ocf_pov.price, NULL), IF(ocf_pov.price_prefix = '=', ocf_pov.price, NULL), IF(ocf_pov.price_prefix = '*', p.price + p.price * ocf_pov.price, NULL), IF(ocf_pov.price_prefix = '%', p.price + p.price * (ocf_pov.price / 100), NULL), p.price ) AS option_price
FROM oc_product_option_value ocf_pov
LEFT JOIN oc_product p ON (ocf_pov.product_id = p.product_id)
LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id)
LEFT JOIN oc_category_path cp ON (p2c.category_id = cp.category_id)
WHERE ocf_pov.price > '0'/* AND ocf_pov.quantity > '0'*/ AND p.status = '1' AND p.date_available <= '2025-02-07' AND cp.path_id = '18') results
WHERE option_price > '0') results2
/profiles/s/st/sto/stockishop/stockishop.com/system/library/ocfilter/core.php:78
259 (0.587)
SELECT p.page_id, p.params, p.params_count, p.category_id, pd.name, pd.heading_title, (SELECT GROUP_CONCAT(DISTINCT cp.path_id
ORDER BY cp.`level` SEPARATOR '_') AS path
FROM oc_category_path cp
WHERE cp.category_id = p.category_id) AS path, (SELECT su.keyword
FROM oc_seo_url su
WHERE su.language_id = '2' AND su.store_id = '0' AND su.`query` = CONCAT('ocfilter_page_id=', p.page_id) LIMIT 1) AS keyword
FROM oc_ocfilter_page p
LEFT JOIN oc_ocfilter_page_description pd ON (p.page_id = pd.page_id)
WHERE p.status = '1' AND p.dynamic = '0' AND pd.language_id = '2' AND p.category_id = '18' AND p.module = '1'
ORDER BY p.page_id DESC
/profiles/s/st/sto/stockishop/stockishop.com/system/library/ocfilter/core.php:78
260 (0.618)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'extension/module/ocfilter48/module'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
261 (0.780)
SELECT *
FROM oc_module
WHERE module_id = '46'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/setting/module.php:11
262 (0.859)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/column_left'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
263 (0.786)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '18' AND store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/category.php:70
264 (0.625)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/design/layout.php:4
265 (0.587)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'column_right'
ORDER BY sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/design/layout.php:23
266 (0.744)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/column_right'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
267 (0.760)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '18' AND store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/category.php:70
268 (0.631)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/design/layout.php:4
269 (0.616)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'content_top'
ORDER BY sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/design/layout.php:23
270 (0.749)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '18' AND store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/category.php:70
271 (0.736)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/design/layout.php:4
272 (0.729)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'agootemplates/widgets/langmark/langmark'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
273 (0.739)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/content_top'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
274 (0.753)
SELECT *
FROM oc_category_to_layout
WHERE category_id = '18' AND store_id = '0'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/category.php:70
275 (0.627)
SELECT *
FROM oc_layout_route
WHERE 'product/category' LIKE route AND store_id = '0'
ORDER BY route DESC LIMIT 1
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/design/layout.php:4
276 (0.629)
SELECT *
FROM oc_layout_module
WHERE layout_id = '3' AND position = 'content_bottom'
ORDER BY sort_order
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/design/layout.php:23
277 (0.629)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/content_bottom'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
278 (0.752)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/buyoneclick' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
279 (0.709)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/footer' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
280 (0.761)
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 = '2' AND i2s.store_id = '0' AND i.status = '1'
ORDER BY i.sort_order, LCASE(id.title) ASC
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/catalog/information.php:10
281 (0.630)
SELECT value
FROM oc_setting
WHERE `key` = 'module_microdatapro_key'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/microdatapro.php:137
282 (0.923)
DELETE
FROM `oc_customer_online`
WHERE date_added < '2025-02-07 16:39:58'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/tool/online.php:4
283 (0.990)
REPLACE INTO `oc_customer_online` SET `ip` = '18.97.9.173', `customer_id` = '0', `url` = 'https://stockishop.com/multimedia/page-2', `referer` = '', `date_added` = '2025-02-07 17:39:58', `bot_name` = 'Bot'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/tool/online.php:15
284 (0.768)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/footer'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
285 (0.693)
SELECT value
FROM oc_setting
WHERE `key` = 'module_microdatapro_key'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/microdatapro.php:137
286 (0.645)
SELECT value
FROM oc_setting
WHERE `key` = 'module_microdatapro_key'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/microdatapro.php:137
287 (0.633)
SELECT value
FROM oc_setting
WHERE `key` = 'module_microdatapro_key'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/microdatapro.php:137
288 (0.546)
SELECT *
FROM oc_extension
WHERE `type` = 'analytics'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/setting/extension.php:4
289 (0.651)
SELECT *
FROM oc_extension
WHERE `type` = 'module' AND `code` = 'related_options'
/profiles/s/st/sto/stockishop/stockishop.com/system/library/liveopencart/lib/v0007/traits/installed.php:12
290 (0.561)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/header' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
291 (0.551)
SELECT *
FROM oc_store
ORDER BY url
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/setting/store.php:7
292 (0.574)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/language' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
293 (0.806)
SELECT *
FROM oc_language
WHERE status = '1'
ORDER BY sort_order, name
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/localisation/language.php:15
294 (0.840)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'agootemplates/record/langmark'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
295 (0.678)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/currency' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
296 (0.609)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/currency'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
297 (0.629)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/search' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
298 (0.515)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/search'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
299 (0.621)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/cart' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
300 (0.991)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '49b43db82731a0e4288d5de904'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:20
301 (0.768)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '49b43db82731a0e4288d5de904'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:120
302 (0.313)
SELECT *
FROM oc_extension
WHERE `type` = 'total'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/setting/extension.php:4
303 (0.533)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/sub_total' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
304 (0.526)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '49b43db82731a0e4288d5de904'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:20
305 (0.527)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '49b43db82731a0e4288d5de904'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:120
306 (0.327)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '49b43db82731a0e4288d5de904'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:20
307 (0.225)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '49b43db82731a0e4288d5de904'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:120
308 (0.509)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '49b43db82731a0e4288d5de904'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:20
309 (0.607)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '49b43db82731a0e4288d5de904'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:120
310 (0.606)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/total/total' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
311 (0.626)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '49b43db82731a0e4288d5de904'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:20
312 (0.501)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '49b43db82731a0e4288d5de904'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:120
313 (0.378)
SELECT *
FROM oc_cart
WHERE customer_id = '0' AND session_id = '49b43db82731a0e4288d5de904'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:20
314 (0.297)
SELECT *
FROM oc_cart
WHERE api_id = '0' AND customer_id = '0' AND session_id = '49b43db82731a0e4288d5de904'
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/system/library/cart/cart.php:120
315 (0.333)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/cart'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
316 (0.506)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'common/menu' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
317 (0.471)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '0' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/category.php:25
318 (0.543)
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 = '20' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/category.php:25
319 (0.635)
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 = '59' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/category.php:25
320 (0.482)
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 = '26' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/category.php:25
321 (0.609)
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 = '18' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/category.php:25
322 (0.633)
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 = '25' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/category.php:25
323 (0.483)
SELECT *
FROM oc_category c
LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id)
LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id)
WHERE c.parent_id = '33' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/category.php:25
324 (0.597)
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 = '70' AND cd.language_id = '2' AND c2s.store_id = '0' AND c.status = '1'
ORDER BY c.sort_order, LCASE(cd.name)
/profiles/s/st/sto/stockishop/stockishop.com/op/modification/catalog/model/catalog/category.php:25
325 (0.638)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/menu'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
326 (0.617)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'common/header'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4
327 (0.476)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'product/search' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
328 (0.510)
SELECT *
FROM oc_translation
WHERE store_id = '0' AND language_id = '2' AND (route = 'extension/module/buyoneclick' OR route = 'uk-ua')
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/translation.php:6
329 (0.397)
SELECT *
FROM oc_theme
WHERE store_id = '0' AND theme = 'default' AND route = 'product/category'
/profiles/s/st/sto/stockishop/stockishop.com/catalog/model/design/theme.php:4