Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 20Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 28Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 20Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 28Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 20Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 28Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 20Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 28Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 20Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 28Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 20Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 28Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 20Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 28Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 20Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 28Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 20Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 28Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 20Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 28Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 20Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 28Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 20Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 28Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 20Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 28Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 20Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 28Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 20Notice: Undefined index: OCSESSID in D:\Sites\NDPlay\www\base\system\storages\modification\system\library\db\mysqli.php on line 28 Товары для праздника - купить оптом и в розницу в интернет-магазине ND Play
Пн-Пт с 10:00 до 19:00, Сб-Вс - выходной

Праздник

Batman. Пакет подарочный большой (желтый), 335*406*155 мм

Подарочный пакет большой Batman — это не просто дополнение к подарку, это — "визитная карточка" само..

нет отзывов

230р.

Harry Potter. Пакет подарочный большой (белый с гербами), 335*406*155 мм (чиби)

Большой подарочный пакет «Harry Potter» размером 335*406*155 мм создан для поклонников популярных..

нет отзывов

299р.

Jurassic World Пакет подарочный большой - 1, 400*300*140 мм

Большой подарочный пакет «Jurassic World» размером 400*300*140 мм создан для поклонников динозавров!..

нет отзывов

332р.

LOL. Набор коробочек, 6 шт (90*60*100 мм)

Детский праздник станет ярче и веселее с аксессуарами серии LOL Surprise! В наборе 6 коробочек, выпо..

нет отзывов

110р.

LOL. Набор шпажек для канапе и капкейков, 12 шт

Набор шпажек для канапе и капкейков (12 шт) с картонными топперами с изображением кукол L.O.L. Surpr..

нет отзывов

194р.

LOL. Пакет подарочный большой (розовый паттерн с картинкой), 250*350*100 мм

Большой подарочный пакет "LOL Surprise!" (розовый паттерн с картинкой) — это не просто дополнение к ..

нет отзывов

106р.

LOL. Пакет подарочный большой (черный с бирюзовым), 335*406*155 мм

Большой подарочный пакет «LOL Surprise» размером 335*406*155 мм создан для фанаток популярных кукол!..

нет отзывов

253р.

LOL. Пакет подарочный малый (бирюзовый с закатом), 180*227*100 мм

Детский праздник станет ярче и веселее с аксессуарами серии LOL Surprise! Подарочный пакет изготовле..

нет отзывов

62р.

Love is. Пакет подарочный большой фиолетовый, 220*310*100 мм

Подарочный пакет из серии «Love is» порадует вашего любимого человека и станет прекрасным дополнени..

нет отзывов

122р.

Marvel. Пакет подарочный большой-4, 330*455*100 мм

Большой подарочный пакет «Marvel» размером 330*455*100 мм создан для фанатов популярных суперг..

нет отзывов

329р.

Minions 2. Пакет подарочный большой-1, 220*310*100 мм (3D дизайн)

Большой подарочный пакет "Миньоны" голубого цвета с изображением героев популярного мультфильма. Под..

нет отзывов

88р.

Влад А4. Гирлянда поздравительная

Поздравительная гирлянда «Влад А4» с анимированным изображением популярного блогера Влада А4 сделает..

нет отзывов

220р.

Конверты для денег. Открытка №48

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

нет отзывов

60р.

Конверты для денег. Открытка №51

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

нет отзывов

60р.

Конверты для денег. Открытка №55

Прикольный конверт для денег с изображением черепашки и надписью "Ни в чём себе не отказывай!" допол..

нет отзывов

60р.

Конверты для денег. Открытка №61

Оригинальная открытка конверт для денег «На самое необходимое!». Размер: 8х16 см...

нет отзывов

60р.

Конверты для денег. Открытка №65

Открытка конверт для денег «Эх, как запою!» изготовлена из картона с изображением забавного медведя...

нет отзывов

60р.

Леди Баг и Супер-Кот. Салфетки бумажные трехслойные 33*33 см, 20 шт, (новый стайл-гайд)

Набор салфеток бумажных трехслойных "Леди Баг и Супер-Кот" (20 шт, 33х33 см). Красивые праздничные с..

нет отзывов

176р.

Набор бумажных тарелок Тигр - 5, 6 шт d=180 мм

Набор одноразовых тарелок «Тигр» – стильное и практичное украшение для праздничного стола. Красочные..

нет отзывов

83р.

Набор бумажных тарелок Тортик, 6 шт d=180 мм

Одноразовые тарелки "Тортик" диаметром 18 см выполнены из специальной плотной бумаги, герметичны и н..

нет отзывов

87р.

Набор коробочек Леди Баг и Супер-Кот, 6 шт

Набор праздничных коробочек с изображением героев мультфильма "Леди Баг и Супер-Кот" - для веселого ..

нет отзывов

110р.

Набор коробочек Сказочный патруль, 6 шт

Подарите ребенку возможность провести праздник с любимыми героями популярного мультфильма телеканала..

нет отзывов

110р.

Пакет подарочный большой (желтый), 250*350*100 мм

Подарочный пакет — это не просто дополнение к подарку, это — “визитная карточка” самого подарка и пе..

нет отзывов

138р.

Пакет подарочный большой Кактус-котик, 335*406*155 мм

Большой подарочный пакет «Русалка-принцесса» размером 335*406*155 мм создан для любителей милых диза..

нет отзывов

184р.

Пакет подарочный Динозаврик новогодний, 335*406*155 мм

Большой подарочный пакет "Динозаврик новогодний" — "визитная карточка" самого подарка и первые эмоци..

нет отзывов

185р.

Парафиновая свеча в торт "Тортик" (цифра 4), в блистере

Свечи для торта - неотъемлемый аксессуар любого дня рождения. Парафиновая свеча в торт "Тортик" - во..

нет отзывов

55р.

Парафиновая свеча в торт "Тортик" (цифра 9) для девочек, в блистере

Свечи для торта - неотъемлемый аксессуар любого дня рождения. Парафиновая свеча в торт "Тортик" - во..

нет отзывов

69р.

Batman. Набор бумажных стаканов, 6 шт*250 мл

Набор бумажных стаканчиков "Бэтмен" – необходимый элемент декора для детского праздничного стола и д..

нет отзывов

79р.

Harry Potter. Гирлянда поздравительная "Персонажи" (флажки)

Гирлянда для праздничного декора помещения с изображением героев популярного фильма "Гарри Поттер". ..

нет отзывов

158р.

L.O.L. Surprise! Пакет подарочный большой - 1 (розовый), 400*300*140 мм

Большой подарочный пакет «L.O.L. Surprise!» размером 400*300*140 мм создан для фанаток популярных ку..

нет отзывов

365р.

Debug SQL
0.00028705596923828SELECT `data` FROM `oc_session` WHERE session_id = '00b8335a47392bdd3ddf2fb9c8' AND expire > 1713460154
0.0002601146697998SELECT * FROM oc_extension WHERE `type` = 'openbay'
0.00021600723266602SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
0.00020909309387207SELECT * FROM oc_extension WHERE `type` = 'openbay'
0.00018978118896484SELECT `data` FROM `oc_session` WHERE session_id = 'ca45738b1f27beb88a0c9d364d' AND expire > 1713460154
0.00015997886657715SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://ndplay.ru/'
0.0019948482513428SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
0.00019001960754395SELECT * FROM oc_language WHERE status = '1' ORDER BY sort_order, name
0.00017499923706055SELECT * FROM oc_currency
0.00037598609924316SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '83') ORDER BY tr1.priority ASC
0.00037384033203125SELECT 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 = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '83') ORDER BY tr1.priority ASC
0.00019288063049316SELECT * 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 = '1'
0.00020599365234375SELECT * 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 = '1'
0.0038821697235107DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
0.0002129077911377SELECT * FROM oc_extension WHERE `type` = 'openbay'
0.0038571357727051SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC
0.00026202201843262SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/bsfilter' OR route = 'ru-ru')
0.00034093856811523SELECT GROUP_CONCAT(REPLACE(`query`, 'category_id=', '') ORDER BY FIELD(keyword, 'prazdnik') SEPARATOR '_') AS path FROM oc_seo_url WHERE `query` LIKE 'category_id=%' AND (keyword = 'prazdnik')
0.00016498565673828SELECT * FROM oc_bsfilter_page WHERE status = '1' AND keyword = 'prazdnik' LIMIT 1
0.00052905082702637SELECT REPLACE(`query`, 'manufacturer_id=', '') AS manufacturer_id FROM oc_seo_url WHERE `query` LIKE 'manufacturer_id=%' AND LCASE(`keyword`) = 'prazdnik' LIMIT 1
0.00015902519226074SELECT * FROM oc_bsfilter_page WHERE status = '1'
0.00024104118347168SELECT * FROM oc_seo_url WHERE keyword = 'prazdnik' AND store_id = '0'
0.00019001960754395SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/category' OR route = 'ru-ru')
0.00024294853210449SELECT * FROM oc_seo_url WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'
0.00022506713867188SELECT 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 = '162' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
0.00023794174194336SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00021219253540039SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00023388862609863SELECT * FROM oc_seo_url WHERE `query` = 'product/compare' AND store_id = '0' AND language_id = '1'
0.0019290447235107SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '162' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
0.00024604797363281SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020980834960938SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00025510787963867SELECT * FROM oc_seo_url WHERE `query` = 'category_id=346' AND store_id = '0' AND language_id = '1'
0.00026392936706543SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020909309387207SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00025486946105957SELECT * FROM oc_seo_url WHERE `query` = 'category_id=347' AND store_id = '0' AND language_id = '1'
0.00024890899658203SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020813941955566SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00025606155395508SELECT * FROM oc_seo_url WHERE `query` = 'category_id=348' AND store_id = '0' AND language_id = '1'
0.0002291202545166SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00023913383483887SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00021100044250488SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00022792816162109SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020885467529297SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00020503997802734SELECT * FROM oc_seo_url WHERE `query` = 'category_id=111' AND store_id = '0' AND language_id = '1'
0.007328987121582SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '162'
1.2557320594788SELECT p.product_id, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special FROM oc_product_to_category p2c LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND p2c.category_id = '162' GROUP BY p.product_id ORDER BY p.quantity ASC, LCASE(pd.name) ASC LIMIT 0,30
0.0024540424346924SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '21310' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0019731521606445SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '23412' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0021109580993652SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '22518' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0038630962371826SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '19301' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0023598670959473SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '21266' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0028190612792969SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '20562' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.001035213470459SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '22801' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0023000240325928SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '19307' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.00082707405090332SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '23977' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0022242069244385SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '23413' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0041830539703369SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '20574' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0010149478912354SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '24027' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0031518936157227SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '20462' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0031061172485352SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '20463' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0031511783599854SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '20467' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0032718181610107SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '20725' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0027070045471191SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '20728' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0025348663330078SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '21146' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0020668506622314SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '22264' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0021309852600098SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '21581' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0028738975524902SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '19009' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.002795934677124SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '19028' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0029599666595459SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '21147' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0023188591003418SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '22757' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.00088691711425781SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '24136' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0025138854980469SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '21597' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024349689483643SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '21606' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0023369789123535SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '19381' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0025100708007812SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '19619' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024120807647705SELECT 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 = '1') 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 = '1') 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 = '1') 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 = '22269' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.00014686584472656SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.0001978874206543SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00033283233642578SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '21310' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016829967498779SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '21310' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00012707710266113SELECT * 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 = '21310' AND od.language_id = '1' ORDER BY o.sort_order
0.00010395050048828SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 21310 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00013399124145508SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00022292137145996SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=33' AND store_id = '0' AND language_id = '1'
0.00011610984802246SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00012516975402832SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00025701522827148SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21310' AND store_id = '0' AND language_id = '1'
9.3936920166016E-5SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00015807151794434SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00032305717468262SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '23412' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0014898777008057SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '23412' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00015091896057129SELECT * 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 = '23412' AND od.language_id = '1' ORDER BY o.sort_order
0.0001521110534668SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 23412 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00023484230041504SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=65' AND store_id = '0' AND language_id = '1'
0.00015401840209961SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00024104118347168SELECT * FROM oc_seo_url WHERE `query` = 'product_id=23412' AND store_id = '0' AND language_id = '1'
0.00012302398681641SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00020718574523926SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00037503242492676SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '22518' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.001507043838501SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '22518' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00019502639770508SELECT * 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 = '22518' AND od.language_id = '1' ORDER BY o.sort_order
0.00019001960754395SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 22518 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00020909309387207SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00025486946105957SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=141' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00022006034851074SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22518' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00022292137145996SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00037002563476562SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '19301' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016989707946777SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '19301' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00016403198242188SELECT * 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 = '19301' AND od.language_id = '1' ORDER BY o.sort_order
0.0001828670501709SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 19301 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00020289421081543SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0002589225769043SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=32' AND store_id = '0' AND language_id = '1'
0.00020003318786621SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00018596649169922SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00027704238891602SELECT * FROM oc_seo_url WHERE `query` = 'product_id=19301' AND store_id = '0' AND language_id = '1'
0.00017118453979492SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00020909309387207SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00034904479980469SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '21266' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0017249584197998SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '21266' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00018596649169922SELECT * 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 = '21266' AND od.language_id = '1' ORDER BY o.sort_order
0.0001981258392334SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 21266 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00020503997802734SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00027298927307129SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=32' AND store_id = '0' AND language_id = '1'
0.00020408630371094SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00022101402282715SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00028300285339355SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21266' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00020718574523926SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00031089782714844SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '20562' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016050338745117SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '20562' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0001978874206543SELECT * 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 = '20562' AND od.language_id = '1' ORDER BY o.sort_order
0.00019478797912598SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 20562 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00020694732666016SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00025105476379395SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=32' AND store_id = '0' AND language_id = '1'
0.00020694732666016SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00023102760314941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00031089782714844SELECT * FROM oc_seo_url WHERE `query` = 'product_id=20562' AND store_id = '0' AND language_id = '1'
0.00016593933105469SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00019097328186035SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00033807754516602SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '22801' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.002345085144043SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '22801' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00018978118896484SELECT * 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 = '22801' AND od.language_id = '1' ORDER BY o.sort_order
0.00017690658569336SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 22801 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0002129077911377SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=32' AND store_id = '0' AND language_id = '1'
0.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00017690658569336SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00028491020202637SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22801' AND store_id = '0' AND language_id = '1'
0.00016093254089355SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00018095970153809SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00031495094299316SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '19307' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0018730163574219SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '19307' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0001828670501709SELECT * 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 = '19307' AND od.language_id = '1' ORDER BY o.sort_order
0.0001671314239502SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 19307 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00013113021850586SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=32' AND store_id = '0' AND language_id = '1'
0.00014686584472656SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00019407272338867SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00024318695068359SELECT * FROM oc_seo_url WHERE `query` = 'product_id=19307' AND store_id = '0' AND language_id = '1'
0.00015401840209961SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00016379356384277SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00022387504577637SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '23977' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.00016689300537109SELECT * 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 = '23977' AND od.language_id = '1' ORDER BY o.sort_order
0.0001671314239502SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 23977 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00015878677368164SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00023293495178223SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=177' AND store_id = '0' AND language_id = '1'
0.00017189979553223SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00017285346984863SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018692016601562SELECT * FROM oc_seo_url WHERE `query` = 'product_id=23977' AND store_id = '0' AND language_id = '1'
0.00014781951904297SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.0001530647277832SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00025200843811035SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '23413' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016410350799561SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '23413' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00018000602722168SELECT * 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 = '23413' AND od.language_id = '1' ORDER BY o.sort_order
0.00013995170593262SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 23413 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00020909309387207SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=82' AND store_id = '0' AND language_id = '1'
0.00014209747314453SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.0001521110534668SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00021910667419434SELECT * FROM oc_seo_url WHERE `query` = 'product_id=23413' AND store_id = '0' AND language_id = '1'
0.00012612342834473SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00019407272338867SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00032210350036621SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '20574' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0018291473388672SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '20574' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00018787384033203SELECT * 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 = '20574' AND od.language_id = '1' ORDER BY o.sort_order
0.00018000602722168SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 20574 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00019598007202148SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00025200843811035SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=50' AND store_id = '0' AND language_id = '1'
0.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00019407272338867SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00029516220092773SELECT * FROM oc_seo_url WHERE `query` = 'product_id=20574' AND store_id = '0' AND language_id = '1'
0.00013518333435059SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00019288063049316SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00025010108947754SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '24027' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0001671314239502SELECT * 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 = '24027' AND od.language_id = '1' ORDER BY o.sort_order
0.00017595291137695SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 24027 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00024914741516113SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=173' AND store_id = '0' AND language_id = '1'
0.00018692016601562SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019407272338867SELECT * FROM oc_seo_url WHERE `query` = 'product_id=24027' AND store_id = '0' AND language_id = '1'
0.0001521110534668SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00016689300537109SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00028800964355469SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '20462' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0014679431915283SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '20462' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00016403198242188SELECT * 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 = '20462' AND od.language_id = '1' ORDER BY o.sort_order
0.00017309188842773SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 20462 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018811225891113SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00015401840209961SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.0001680850982666SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00022506713867188SELECT * FROM oc_seo_url WHERE `query` = 'product_id=20462' AND store_id = '0' AND language_id = '1'
0.00014591217041016SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00015401840209961SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00027704238891602SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '20463' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0014660358428955SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '20463' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00013494491577148SELECT * 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 = '20463' AND od.language_id = '1' ORDER BY o.sort_order
0.00013899803161621SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 20463 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00014305114746094SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015902519226074SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00012707710266113SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00013995170593262SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001990795135498SELECT * FROM oc_seo_url WHERE `query` = 'product_id=20463' AND store_id = '0' AND language_id = '1'
0.00011610984802246SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.0001518726348877SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00027203559875488SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '20467' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0015020370483398SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '20467' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00018191337585449SELECT * 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 = '20467' AND od.language_id = '1' ORDER BY o.sort_order
0.00014305114746094SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 20467 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00021195411682129SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00014185905456543SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00025296211242676SELECT * FROM oc_seo_url WHERE `query` = 'product_id=20467' AND store_id = '0' AND language_id = '1'
0.00011897087097168SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00014495849609375SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00026583671569824SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '20725' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0013821125030518SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '20725' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00013589859008789SELECT * 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 = '20725' AND od.language_id = '1' ORDER BY o.sort_order
0.00016188621520996SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 20725 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00016093254089355SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018191337585449SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00024104118347168SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019311904907227SELECT * FROM oc_seo_url WHERE `query` = 'product_id=20725' AND store_id = '0' AND language_id = '1'
0.00013303756713867SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00016498565673828SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00029301643371582SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '20728' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0017948150634766SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '20728' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00013995170593262SELECT * 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 = '20728' AND od.language_id = '1' ORDER BY o.sort_order
0.00015997886657715SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 20728 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00016617774963379SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018596649169922SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00015616416931152SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00017189979553223SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019288063049316SELECT * FROM oc_seo_url WHERE `query` = 'product_id=20728' AND store_id = '0' AND language_id = '1'
0.00011777877807617SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.0001528263092041SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00027608871459961SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '21146' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0015411376953125SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '21146' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0001380443572998SELECT * 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 = '21146' AND od.language_id = '1' ORDER BY o.sort_order
0.00013208389282227SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 21146 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00014615058898926SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019288063049316SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=25' AND store_id = '0' AND language_id = '1'
0.0001380443572998SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00013995170593262SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21146' AND store_id = '0' AND language_id = '1'
0.00011897087097168SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00014305114746094SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.0002751350402832SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '22264' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0017919540405273SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '22264' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00013089179992676SELECT * 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 = '22264' AND od.language_id = '1' ORDER BY o.sort_order
0.0001368522644043SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 22264 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00012302398681641SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00025486946105957SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22264' AND store_id = '0' AND language_id = '1'
0.00012302398681641SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00015497207641602SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00029087066650391SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '21581' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016429424285889SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '21581' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00013995170593262SELECT * 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 = '21581' AND od.language_id = '1' ORDER BY o.sort_order
0.00013613700866699SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 21581 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00014281272888184SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001530647277832SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00012588500976562SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21581' AND store_id = '0' AND language_id = '1'
0.0001220703125SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013303756713867SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00029897689819336SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '19009' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0017380714416504SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '19009' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00013113021850586SELECT * 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 = '19009' AND od.language_id = '1' ORDER BY o.sort_order
0.00014495849609375SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 19009 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00028896331787109SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00022506713867188SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=25' AND store_id = '0' AND language_id = '1'
0.00017189979553223SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014710426330566SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00030207633972168SELECT * FROM oc_seo_url WHERE `query` = 'product_id=19009' AND store_id = '0' AND language_id = '1'
0.00017189979553223SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00017094612121582SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00029611587524414SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '19028' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0015020370483398SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '19028' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00014305114746094SELECT * 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 = '19028' AND od.language_id = '1' ORDER BY o.sort_order
0.00011706352233887SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 19028 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.0001218318939209SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001990795135498SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=60' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00017714500427246SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00028300285339355SELECT * FROM oc_seo_url WHERE `query` = 'product_id=19028' AND store_id = '0' AND language_id = '1'
0.00013399124145508SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013303756713867SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00034689903259277SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '21147' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0018770694732666SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '21147' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00016307830810547SELECT * 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 = '21147' AND od.language_id = '1' ORDER BY o.sort_order
0.00011301040649414SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 21147 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014114379882812SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00015592575073242SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016188621520996SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21147' AND store_id = '0' AND language_id = '1'
0.00011181831359863SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.0001678466796875SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.0002739429473877SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '22757' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0018551349639893SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '22757' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00015997886657715SELECT * 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 = '22757' AND od.language_id = '1' ORDER BY o.sort_order
0.00015711784362793SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 22757 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00025510787963867SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22757' AND store_id = '0' AND language_id = '1'
0.0001370906829834SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00017094612121582SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00022697448730469SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '24136' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0001530647277832SELECT * 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 = '24136' AND od.language_id = '1' ORDER BY o.sort_order
0.00017380714416504SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 24136 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00016093254089355SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00021100044250488SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.0001678466796875SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'product_id=24136' AND store_id = '0' AND language_id = '1'
0.00013399124145508SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00017404556274414SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00027894973754883SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '21597' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0017189979553223SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '21597' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00017189979553223SELECT * 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 = '21597' AND od.language_id = '1' ORDER BY o.sort_order
0.00013995170593262SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 21597 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00012993812561035SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014209747314453SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21597' AND store_id = '0' AND language_id = '1'
0.00010395050048828SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00019192695617676SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00025606155395508SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '21606' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0014388561248779SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '21606' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00014209747314453SELECT * 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 = '21606' AND od.language_id = '1' ORDER BY o.sort_order
0.0001370906829834SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 21606 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00014996528625488SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016283988952637SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00015616416931152SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.0001678466796875SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21606' AND store_id = '0' AND language_id = '1'
0.00013995170593262SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00016403198242188SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00028896331787109SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '19381' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0014739036560059SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '19381' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00012087821960449SELECT * 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 = '19381' AND od.language_id = '1' ORDER BY o.sort_order
0.00013899803161621SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 19381 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00014019012451172SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019192695617676SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=33' AND store_id = '0' AND language_id = '1'
0.00012993812561035SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014305114746094SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00022602081298828SELECT * FROM oc_seo_url WHERE `query` = 'product_id=19381' AND store_id = '0' AND language_id = '1'
0.00011920928955078SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00014019012451172SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.0002439022064209SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '19619' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.001478910446167SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '19619' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0001220703125SELECT * 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 = '19619' AND od.language_id = '1' ORDER BY o.sort_order
0.00011396408081055SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 19619 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00012302398681641SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017809867858887SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=65' AND store_id = '0' AND language_id = '1'
0.0001070499420166SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00012111663818359SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00025391578674316SELECT * FROM oc_seo_url WHERE `query` = 'product_id=19619' AND store_id = '0' AND language_id = '1'
9.7990036010742E-5SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00011682510375977SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00024008750915527SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '22269' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0013818740844727SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '22269' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00014281272888184SELECT * 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 = '22269' AND od.language_id = '1' ORDER BY o.sort_order
0.00012993812561035SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 22269 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=32' AND store_id = '0' AND language_id = '1'
0.00013113021850586SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014209747314453SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00021696090698242SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22269' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001378059387207SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016283988952637SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014281272888184SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00015807151794434SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012516975402832SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00014686584472656SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00011706352233887SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00014114379882812SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012803077697754SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012016296386719SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012993812561035SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00014901161193848SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013589859008789SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00015497207641602SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012803077697754SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00015115737915039SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012016296386719SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00014305114746094SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00011491775512695SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00015377998352051SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012111663818359SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012087821960449SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00014209747314453SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00011706352233887SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018787384033203SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015807151794434SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00015020370483398SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012516975402832SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00020194053649902SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016093254089355SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019693374633789SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016617774963379SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018906593322754SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015902519226074SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00021505355834961SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018692016601562SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00020194053649902SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016617774963379SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019717216491699SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017309188842773SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019407272338867SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0002140998840332SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017309188842773SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018787384033203SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016212463378906SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00020003318786621SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016689300537109SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018787384033203SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017213821411133SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001981258392334SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018787384033203SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00020384788513184SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015497207641602SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018310546875SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014996528625488SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018191337585449SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014710426330566SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017976760864258SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014710426330566SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015902519226074SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018191337585449SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014710426330566SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014996528625488SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001518726348877SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018215179443359SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014805793762207SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015497207641602SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016283988952637SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017118453979492SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019192695617676SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012397766113281SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012612342834473SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012588500976562SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012993812561035SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017714500427246SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012898445129395SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019288063049316SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014591217041016SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017285346984863SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013184547424316SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018906593322754SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014019012451172SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015807151794434SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016689300537109SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013589859008789SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001518726348877SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014686584472656SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016212463378906SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00014901161193848SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017189979553223SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001680850982666SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019693374633789SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017905235290527SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016093254089355SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012588500976562SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00011706352233887SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014615058898926SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017309188842773SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00022292137145996SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001521110534668SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014090538024902SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012397766113281SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00011992454528809SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00014710426330566SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00011610984802246SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019979476928711SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014686584472656SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001988410949707SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013303756713867SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00021815299987793SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017881393432617SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016689300537109SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001990795135498SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018787384033203SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014805793762207SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014615058898926SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016880035400391SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017905235290527SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00015902519226074SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014090538024902SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00015401840209961SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012302398681641SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00014901161193848SELECT * FROM oc_seo_url WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'
0.00010108947753906SELECT * FROM oc_category_to_layout WHERE category_id = '162' AND store_id = '0'
0.00011897087097168SELECT * FROM oc_layout_module WHERE layout_id = '145' AND position = 'column_left' ORDER BY sort_order
0.00011515617370605SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/bsfilter' OR route = 'ru-ru')
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00022602081298828SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00021100044250488SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017714500427246SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018906593322754SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017380714416504SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018882751464844SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00023293495178223SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00021505355834961SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019311904907227SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016379356384277SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018692016601562SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019383430480957SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014615058898926SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014686584472656SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015497207641602SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019192695617676SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00021195411682129SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018811225891113SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00021505355834961SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019502639770508SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0002140998840332SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00022411346435547SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020909309387207SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00020003318786621SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019216537475586SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014781951904297SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017213821411133SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013399124145508SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0002288818359375SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015687942504883SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017786026000977SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014281272888184SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017285346984863SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014114379882812SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001828670501709SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013995170593262SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017189979553223SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014591217041016SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017118453979492SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015807151794434SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017118453979492SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014209747314453SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014281272888184SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014305114746094SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001678466796875SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014185905456543SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017213821411133SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017309188842773SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013995170593262SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013995170593262SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014281272888184SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001680850982666SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001680850982666SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001368522644043SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013613700866699SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013995170593262SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001370906829834SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001370906829834SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016689300537109SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013613700866699SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016283988952637SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001368522644043SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001680850982666SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001380443572998SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001370906829834SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001370906829834SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013995170593262SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001380443572998SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001370906829834SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001368522644043SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014305114746094SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016379356384277SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001368522644043SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017285346984863SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001380443572998SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001678466796875SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013589859008789SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013494491577148SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014305114746094SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00014209747314453SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00011396408081055SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001368522644043SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00011086463928223SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0020720958709717SELECT * 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 = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012612342834473SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.01552414894104SELECT 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '172'
0.00021100044250488SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' AND store_id = '0' AND language_id = '1'
0.013792037963867SELECT 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '223'
0.00025796890258789SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020194053649902SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.027272939682007SELECT 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '18'
0.00024580955505371SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018596649169922SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.015013933181763SELECT 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '230'
0.00020194053649902SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017809867858887SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.018211126327515SELECT 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '20'
0.00022602081298828SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017285346984863SELECT * FROM oc_seo_url WHERE `query` = 'category_id=205' AND store_id = '0' AND language_id = '1'
0.012501001358032SELECT 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '205'
0.00020599365234375SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00023007392883301SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.012778997421265SELECT 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '396'
0.0019481182098389SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '162' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
0.00021481513977051SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00021505355834961SELECT * FROM oc_seo_url WHERE `query` = 'category_id=346' AND store_id = '0' AND language_id = '1'
0.014975070953369SELECT 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '346'
0.00025105476379395SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017285346984863SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00021719932556152SELECT * FROM oc_seo_url WHERE `query` = 'category_id=347' AND store_id = '0' AND language_id = '1'
0.012181043624878SELECT 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '347'
0.00020194053649902SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0002140998840332SELECT * FROM oc_seo_url WHERE `query` = 'category_id=348' AND store_id = '0' AND language_id = '1'
0.012346029281616SELECT 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '348'
0.00020003318786621SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016689300537109SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.014119148254395SELECT 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '178'
0.00022196769714355SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001678466796875SELECT * FROM oc_seo_url WHERE `query` = 'category_id=111' AND store_id = '0' AND language_id = '1'
0.013041973114014SELECT 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '111'
0.00021004676818848SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.018832921981812SELECT 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '162'
0.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018191337585449SELECT * FROM oc_seo_url WHERE `query` = 'category_id=221' AND store_id = '0' AND language_id = '1'
0.012673854827881SELECT 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 = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '221'
0.00019979476928711SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'extension/module/bsfilter'
0.00016999244689941SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/category_description' OR route = 'ru-ru')
0.00019192695617676SELECT 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 = '162' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
0.0021870136260986SELECT * 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 = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
0.00021982192993164SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'extension/module/category_description'
0.0001828670501709SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/column_left'
0.00013589859008789SELECT * FROM oc_category_to_layout WHERE category_id = '162' AND store_id = '0'
0.00015020370483398SELECT * FROM oc_layout_module WHERE layout_id = '145' AND position = 'column_right' ORDER BY sort_order
0.0001981258392334SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/column_right'
0.00012707710266113SELECT * FROM oc_category_to_layout WHERE category_id = '162' AND store_id = '0'
0.0001380443572998SELECT * FROM oc_layout_module WHERE layout_id = '145' AND position = 'content_top' ORDER BY sort_order
0.00016307830810547SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/content_top'
0.00014400482177734SELECT * FROM oc_category_to_layout WHERE category_id = '162' AND store_id = '0'
0.0001378059387207SELECT * FROM oc_layout_module WHERE layout_id = '145' AND position = 'content_bottom' ORDER BY sort_order
0.00015592575073242SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/content_bottom'
0.00017690658569336SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru')
0.00014996528625488SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/social' OR route = 'ru-ru')
0.00028085708618164SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'extension/module/social_icons'
0.00019502639770508SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')
0.00025701522827148SELECT * FROM oc_seo_url WHERE `query` = 'common/language/language' AND store_id = '0' AND language_id = '1'
0.00016093254089355SELECT * FROM oc_language WHERE status = '1' ORDER BY sort_order, name
0.00020194053649902SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00020909309387207SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/language'
0.00016307830810547SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
0.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'common/currency/currency' AND store_id = '0' AND language_id = '1'
0.00019383430480957SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016283988952637SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/currency'
0.0018692016601562SELECT * 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 = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
0.00020503997802734SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017285346984863SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' AND store_id = '0' AND language_id = '1'
0.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00018215179443359SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017690658569336SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014901161193848SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=205' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001978874206543SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013518333435059SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001981258392334SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014710426330566SELECT * FROM oc_seo_url WHERE `query` = 'category_id=221' AND store_id = '0' AND language_id = '1'
0.0017879009246826SELECT * 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 = '1' AND i2s.store_id = '0' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'information_id=67' AND store_id = '0' AND language_id = '1'
0.0001521110534668SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.0001680850982666SELECT * FROM oc_seo_url WHERE `query` = 'information_id=77' AND store_id = '0' AND language_id = '1'
0.00012493133544922SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00013303756713867SELECT * FROM oc_seo_url WHERE `query` = 'information_id=68' AND store_id = '0' AND language_id = '1'
0.00012397766113281SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00013303756713867SELECT * FROM oc_seo_url WHERE `query` = 'information_id=73' AND store_id = '0' AND language_id = '1'
0.00012397766113281SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00013089179992676SELECT * FROM oc_seo_url WHERE `query` = 'information_id=64' AND store_id = '0' AND language_id = '1'
0.0001220703125SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00012993812561035SELECT * FROM oc_seo_url WHERE `query` = 'information_id=66' AND store_id = '0' AND language_id = '1'
0.00012397766113281SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00013184547424316SELECT * FROM oc_seo_url WHERE `query` = 'information_id=65' AND store_id = '0' AND language_id = '1'
0.00013303756713867SELECT * FROM oc_seo_url WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '1'
0.00011014938354492SELECT * FROM oc_seo_url WHERE `query` = 'account/return/add' AND store_id = '0' AND language_id = '1'
0.00013089179992676SELECT * FROM oc_seo_url WHERE `query` = 'information/sitemap' AND store_id = '0' AND language_id = '1'
0.00012302398681641SELECT * FROM oc_seo_url WHERE `query` = 'information/tracking' AND store_id = '0' AND language_id = '1'
0.00010585784912109SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer' AND store_id = '0' AND language_id = '1'
0.00013494491577148SELECT * FROM oc_seo_url WHERE `query` = 'account/voucher' AND store_id = '0' AND language_id = '1'
0.0001070499420166SELECT * FROM oc_seo_url WHERE `query` = 'affiliate/login' AND store_id = '0' AND language_id = '1'
0.0001060962677002SELECT * FROM oc_seo_url WHERE `query` = 'product/special' AND store_id = '0' AND language_id = '1'
0.0001060962677002SELECT * FROM oc_seo_url WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
0.0001070499420166SELECT * FROM oc_seo_url WHERE `query` = 'account/order' AND store_id = '0' AND language_id = '1'
0.00010800361633301SELECT * FROM oc_seo_url WHERE `query` = 'account/wishlist' AND store_id = '0' AND language_id = '1'
0.0001060962677002SELECT * FROM oc_seo_url WHERE `query` = 'account/newsletter' AND store_id = '0' AND language_id = '1'
0.00010919570922852SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'theme/bodysport' OR route = 'ru-ru')
0.00010085105895996SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/subscribe' OR route = 'ru-ru')
0.00014591217041016SELECT * FROM oc_seo_url WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'
0.00016593933105469DELETE FROM `oc_customer_online` WHERE date_added < '2024-04-18 16:09:16'
9.9897384643555E-5REPLACE INTO `oc_customer_online` SET `ip` = '18.116.40.177', `customer_id` = '0', `url` = 'https://ndplay.ru/prazdnik', `referer` = 'https://ndplay.ru/tovary-dlya-prazdnika/svechi-dlya-torta/nabor-svechej-dlya-torta-skazochnyj-patrul-4-sht', `date_added` = '2024-04-18 17:09:16'
0.00013494491577148SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/footer'
0.0001528263092041SELECT * FROM oc_extension WHERE `type` = 'analytics'
0.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'style/setting' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'style/setting' AND store_id = '0' AND language_id = '1'
0.00014281272888184SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
0.00015711784362793SELECT * FROM oc_seo_url WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
0.00015616416931152SELECT * FROM oc_seo_url WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'
0.00018310546875SELECT * FROM oc_seo_url WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'
0.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'account/wishlist' AND store_id = '0' AND language_id = '1'
0.0001530647277832SELECT * FROM oc_seo_url WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
0.00015807151794434SELECT * FROM oc_seo_url WHERE `query` = 'account/register' AND store_id = '0' AND language_id = '1'
0.0001518726348877SELECT * FROM oc_seo_url WHERE `query` = 'account/login' AND store_id = '0' AND language_id = '1'
0.00015377998352051SELECT * FROM oc_seo_url WHERE `query` = 'account/order' AND store_id = '0' AND language_id = '1'
0.00015497207641602SELECT * FROM oc_seo_url WHERE `query` = 'account/transaction' AND store_id = '0' AND language_id = '1'
0.00015711784362793SELECT * FROM oc_seo_url WHERE `query` = 'account/download' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * FROM oc_seo_url WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'
0.00018715858459473SELECT * FROM oc_seo_url WHERE `query` = 'checkout/checkout' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '1'
0.00017285346984863SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/text_loading'
0.00015401840209961SELECT * FROM oc_seo_url WHERE `query` = 'account/edit' AND store_id = '0' AND language_id = '1'
0.0001530647277832SELECT * FROM oc_seo_url WHERE `query` = 'account/address' AND store_id = '0' AND language_id = '1'
0.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'account/reward' AND store_id = '0' AND language_id = '1'
0.00015401840209961SELECT * FROM oc_seo_url WHERE `query` = 'account/return' AND store_id = '0' AND language_id = '1'
0.00017189979553223SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'common/language/language' AND store_id = '0' AND language_id = '1'
0.00013184547424316SELECT * FROM oc_language WHERE status = '1' ORDER BY sort_order, name
0.00018906593322754SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001678466796875SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/language'
0.00013995170593262SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
0.00017786026000977SELECT * FROM oc_seo_url WHERE `query` = 'common/currency/currency' AND store_id = '0' AND language_id = '1'
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/currency'
0.00014710426330566SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru')
0.00016498565673828SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/search'
0.00014400482177734SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')
0.00018000602722168SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00013995170593262SELECT * FROM oc_extension WHERE `type` = 'total'
0.00016880035400391SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru')
0.00014185905456543SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.0001380443572998SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00014090538024902SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/credit' OR route = 'ru-ru')
0.00011897087097168SELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0'
0.0001678466796875SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru')
0.00013995170593262SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00013995170593262SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'ca45738b1f27beb88a0c9d364d'
0.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'
0.00031781196594238SELECT * FROM oc_seo_url WHERE `query` = 'checkout/checkout' AND store_id = '0' AND language_id = '1'
0.00016880035400391SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/cart'
0.00014114379882812SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/menu' OR route = 'ru-ru')
0.0020260810852051SELECT * 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 = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
0.0016720294952393SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '172' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
0.00020384788513184SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.0001680850982666SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014090538024902SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00013613700866699SELECT * FROM oc_seo_url WHERE `query` = 'category_id=117' AND store_id = '0' AND language_id = '1'
0.00016689300537109SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001370906829834SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'category_id=195' AND store_id = '0' AND language_id = '1'
0.00017380714416504SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001380443572998SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.0001528263092041SELECT * FROM oc_seo_url WHERE `query` = 'category_id=238' AND store_id = '0' AND language_id = '1'
0.00016212463378906SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001370906829834SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00023198127746582SELECT * FROM oc_seo_url WHERE `query` = 'category_id=68' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001370906829834SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00012898445129395SELECT * FROM oc_seo_url WHERE `query` = 'category_id=242' AND store_id = '0' AND language_id = '1'
0.00013399124145508SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00027704238891602SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00018310546875SELECT * FROM oc_seo_url WHERE `query` = 'category_id=245' AND store_id = '0' AND language_id = '1'
0.00018310546875SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'category_id=204' AND store_id = '0' AND language_id = '1'
0.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016188621520996SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.0019290447235107SELECT * 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 = '223' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
0.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017690658569336SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' AND store_id = '0' AND language_id = '1'
0.00022602081298828SELECT * FROM oc_seo_url WHERE `query` = 'category_id=389' AND store_id = '0' AND language_id = '1'
0.00018310546875SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'category_id=210' AND store_id = '0' AND language_id = '1'
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' AND store_id = '0' AND language_id = '1'
0.00021791458129883SELECT * FROM oc_seo_url WHERE `query` = 'category_id=371' AND store_id = '0' AND language_id = '1'
0.0002129077911377SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020503997802734SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' AND store_id = '0' AND language_id = '1'
0.0019450187683105SELECT * 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 = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
0.00020599365234375SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'category_id=252' AND store_id = '0' AND language_id = '1'
0.00020813941955566SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00017189979553223SELECT * FROM oc_seo_url WHERE `query` = 'category_id=259' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001530647277832SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00018310546875SELECT * FROM oc_seo_url WHERE `query` = 'category_id=298' AND store_id = '0' AND language_id = '1'
0.00017189979553223SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015115737915039SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00018191337585449SELECT * FROM oc_seo_url WHERE `query` = 'category_id=289' AND store_id = '0' AND language_id = '1'
0.00017213821411133SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015711784362793SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00020289421081543SELECT * FROM oc_seo_url WHERE `query` = 'category_id=364' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014996528625488SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.0017309188842773SELECT * 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 = '230' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
0.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020694732666016SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'category_id=227' AND store_id = '0' AND language_id = '1'
0.00017309188842773SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'category_id=301' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00018191337585449SELECT * FROM oc_seo_url WHERE `query` = 'category_id=300' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'category_id=250' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016283988952637SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00017213821411133SELECT * FROM oc_seo_url WHERE `query` = 'category_id=256' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.0001828670501709SELECT * FROM oc_seo_url WHERE `query` = 'category_id=305' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016188621520996SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.0019268989562988SELECT * 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 = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
0.00022506713867188SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00021505355834961SELECT * FROM oc_seo_url WHERE `query` = 'category_id=65' AND store_id = '0' AND language_id = '1'
0.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'category_id=326' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015711784362793SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00015521049499512SELECT * FROM oc_seo_url WHERE `query` = 'category_id=185' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00019192695617676SELECT * FROM oc_seo_url WHERE `query` = 'category_id=327' AND store_id = '0' AND language_id = '1'
0.00017189979553223SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015902519226074SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'category_id=345' AND store_id = '0' AND language_id = '1'
0.00017309188842773SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015711784362793SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00148606300354SELECT * 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 = '205' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
0.00019288063049316SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'category_id=205' AND store_id = '0' AND language_id = '1'
0.00021100044250488SELECT * FROM oc_seo_url WHERE `query` = 'category_id=370' AND store_id = '0' AND language_id = '1'
0.00017905235290527SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'category_id=205' AND store_id = '0' AND language_id = '1'
0.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'category_id=228' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015807151794434SELECT * FROM oc_seo_url WHERE `query` = 'category_id=205' AND store_id = '0' AND language_id = '1'
0.0017960071563721SELECT * 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 = '396' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
0.00019693374633789SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00022292137145996SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.00021910667419434SELECT * FROM oc_seo_url WHERE `query` = 'category_id=397' AND store_id = '0' AND language_id = '1'
0.00018191337585449SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.00019192695617676SELECT * FROM oc_seo_url WHERE `query` = 'category_id=398' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0002140998840332SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.0002140998840332SELECT * FROM oc_seo_url WHERE `query` = 'category_id=399' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.00021195411682129SELECT * FROM oc_seo_url WHERE `query` = 'category_id=400' AND store_id = '0' AND language_id = '1'
0.00017285346984863SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00021505355834961SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.0016779899597168SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '162' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
0.00019598007202148SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015807151794434SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00020384788513184SELECT * FROM oc_seo_url WHERE `query` = 'category_id=346' AND store_id = '0' AND language_id = '1'
0.00017786026000977SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001518726348877SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'category_id=347' AND store_id = '0' AND language_id = '1'
0.00017619132995605SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'category_id=348' AND store_id = '0' AND language_id = '1'
0.00017905235290527SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014996528625488SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001521110534668SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014805793762207SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00014805793762207SELECT * FROM oc_seo_url WHERE `query` = 'category_id=111' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014901161193848SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0014898777008057SELECT * 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 = '221' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
0.00019192695617676SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=221' AND store_id = '0' AND language_id = '1'
0.00021696090698242SELECT * FROM oc_seo_url WHERE `query` = 'category_id=394' AND store_id = '0' AND language_id = '1'
0.00017690658569336SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014090538024902SELECT * FROM oc_seo_url WHERE `query` = 'category_id=221' AND store_id = '0' AND language_id = '1'
0.00016522407531738SELECT * FROM oc_seo_url WHERE `query` = 'category_id=222' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016188621520996SELECT * FROM oc_seo_url WHERE `query` = 'category_id=221' AND store_id = '0' AND language_id = '1'
0.00014686584472656SELECT * FROM oc_seo_url WHERE `query` = 'category_id=102' AND store_id = '0' AND language_id = '1'
0.00018596649169922SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'category_id=221' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'product/catalog' AND store_id = '0' AND language_id = '1'
0.00017690658569336SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/menu'
0.00014710426330566SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/brands' OR route = 'ru-ru')
0.00014305114746094SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018596649169922SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=120' AND store_id = '0' AND language_id = '1'
0.00014090538024902SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00022983551025391SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=147' AND store_id = '0' AND language_id = '1'
0.00018596649169922SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00022792816162109SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=142' AND store_id = '0' AND language_id = '1'
0.00018191337585449SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00023794174194336SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=32' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00022411346435547SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=113' AND store_id = '0' AND language_id = '1'
0.0001828670501709SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00023508071899414SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=177' AND store_id = '0' AND language_id = '1'
0.00014996528625488SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00022387504577637SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=114' AND store_id = '0' AND language_id = '1'
0.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00022721290588379SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=140' AND store_id = '0' AND language_id = '1'
0.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00022315979003906SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=121' AND store_id = '0' AND language_id = '1'
0.00018119812011719SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00023102760314941SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=163' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00020909309387207SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=123' AND store_id = '0' AND language_id = '1'
0.00016093254089355SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00021505355834961SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=18' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019311904907227SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=132' AND store_id = '0' AND language_id = '1'
0.00016021728515625SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0002129077911377SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=158' AND store_id = '0' AND language_id = '1'
0.00016093254089355SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018811225891113SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=61' AND store_id = '0' AND language_id = '1'
0.00016093254089355SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00022292137145996SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=33' AND store_id = '0' AND language_id = '1'
0.00016117095947266SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00022411346435547SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=73' AND store_id = '0' AND language_id = '1'
0.00015902519226074SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00022196769714355SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=74' AND store_id = '0' AND language_id = '1'
0.00016283988952637SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019502639770508SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=173' AND store_id = '0' AND language_id = '1'
0.00015902519226074SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00020003318786621SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=122' AND store_id = '0' AND language_id = '1'
0.00015902519226074SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=26' AND store_id = '0' AND language_id = '1'
0.00015711784362793SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00024104118347168SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=75' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00023603439331055SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=65' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019693374633789SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=48' AND store_id = '0' AND language_id = '1'
0.0001370906829834SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019216537475586SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=164' AND store_id = '0' AND language_id = '1'
0.0001368522644043SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017285346984863SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=124' AND store_id = '0' AND language_id = '1'
0.0001380443572998SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019288063049316SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=175' AND store_id = '0' AND language_id = '1'
0.00013613700866699SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00020289421081543SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=76' AND store_id = '0' AND language_id = '1'
0.0001378059387207SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=168' AND store_id = '0' AND language_id = '1'
0.0001370906829834SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=166' AND store_id = '0' AND language_id = '1'
0.0001370906829834SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017213821411133SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=125' AND store_id = '0' AND language_id = '1'
0.00013494491577148SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019693374633789SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=49' AND store_id = '0' AND language_id = '1'
0.00013995170593262SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018811225891113SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=167' AND store_id = '0' AND language_id = '1'
0.00013589859008789SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001828670501709SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=146' AND store_id = '0' AND language_id = '1'
0.00010108947753906SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016617774963379SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=77' AND store_id = '0' AND language_id = '1'
0.00010108947753906SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016689300537109SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=78' AND store_id = '0' AND language_id = '1'
0.00010108947753906SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014591217041016SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=133' AND store_id = '0' AND language_id = '1'
0.00010299682617188SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014281272888184SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=116' AND store_id = '0' AND language_id = '1'
0.00010204315185547SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014901161193848SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=155' AND store_id = '0' AND language_id = '1'
0.00010418891906738SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=111' AND store_id = '0' AND language_id = '1'
0.00010013580322266SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=79' AND store_id = '0' AND language_id = '1'
0.0001068115234375SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=136' AND store_id = '0' AND language_id = '1'
0.00010108947753906SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015497207641602SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=176' AND store_id = '0' AND language_id = '1'
0.00010013580322266SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=131' AND store_id = '0' AND language_id = '1'
0.00010299682617188SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001530647277832SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=169' AND store_id = '0' AND language_id = '1'
0.00010085105895996SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=165' AND store_id = '0' AND language_id = '1'
0.00010013580322266SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=80' AND store_id = '0' AND language_id = '1'
0.00010108947753906SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014519691467285SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=128' AND store_id = '0' AND language_id = '1'
0.00010085105895996SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015497207641602SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=25' AND store_id = '0' AND language_id = '1'
0.00010180473327637SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00013995170593262SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=115' AND store_id = '0' AND language_id = '1'
0.00010013580322266SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=81' AND store_id = '0' AND language_id = '1'
0.00010299682617188SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015497207641602SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=22' AND store_id = '0' AND language_id = '1'
0.00010013580322266SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=57' AND store_id = '0' AND language_id = '1'
0.00010299682617188SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015807151794434SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=50' AND store_id = '0' AND language_id = '1'
0.00010204315185547SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014710426330566SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=141' AND store_id = '0' AND language_id = '1'
9.9897384643555E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015616416931152SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=29' AND store_id = '0' AND language_id = '1'
0.00010204315185547SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017023086547852SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=82' AND store_id = '0' AND language_id = '1'
0.00010085105895996SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=109' AND store_id = '0' AND language_id = '1'
0.00010204315185547SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001368522644043SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=110' AND store_id = '0' AND language_id = '1'
0.00010299682617188SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001678466796875SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=83' AND store_id = '0' AND language_id = '1'
0.00010013580322266SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=84' AND store_id = '0' AND language_id = '1'
0.00010013580322266SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014901161193848SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=143' AND store_id = '0' AND language_id = '1'
0.00010204315185547SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014019012451172SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=112' AND store_id = '0' AND language_id = '1'
0.00010180473327637SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=85' AND store_id = '0' AND language_id = '1'
0.00010299682617188SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014901161193848SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=150' AND store_id = '0' AND language_id = '1'
0.00010108947753906SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017118453979492SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=86' AND store_id = '0' AND language_id = '1'
0.00010108947753906SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015902519226074SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=51' AND store_id = '0' AND language_id = '1'
0.00010204315185547SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016283988952637SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=60' AND store_id = '0' AND language_id = '1'
0.00010204315185547SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=87' AND store_id = '0' AND language_id = '1'
0.00010013580322266SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017285346984863SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=88' AND store_id = '0' AND language_id = '1'
0.00010395050048828SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00013613700866699SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=101' AND store_id = '0' AND language_id = '1'
0.00010418891906738SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=72' AND store_id = '0' AND language_id = '1'
9.9897384643555E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=89' AND store_id = '0' AND language_id = '1'
9.9897384643555E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=90' AND store_id = '0' AND language_id = '1'
0.00010299682617188SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016117095947266SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=52' AND store_id = '0' AND language_id = '1'
0.00010299682617188SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014090538024902SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=117' AND store_id = '0' AND language_id = '1'
0.00010204315185547SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015497207641602SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=172' AND store_id = '0' AND language_id = '1'
0.00010204315185547SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016093254089355SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=58' AND store_id = '0' AND language_id = '1'
9.9897384643555E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=91' AND store_id = '0' AND language_id = '1'
0.00010013580322266SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=97' AND store_id = '0' AND language_id = '1'
0.00010299682617188SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014185905456543SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=119' AND store_id = '0' AND language_id = '1'
0.00010108947753906SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016093254089355SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=55' AND store_id = '0' AND language_id = '1'
9.9897384643555E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=28' AND store_id = '0' AND language_id = '1'
0.00010299682617188SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=70' AND store_id = '0' AND language_id = '1'
0.00010108947753906SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=92' AND store_id = '0' AND language_id = '1'
0.00010108947753906SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015902519226074SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=170' AND store_id = '0' AND language_id = '1'
0.00010108947753906SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=56' AND store_id = '0' AND language_id = '1'
9.9897384643555E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=93' AND store_id = '0' AND language_id = '1'
0.00010204315185547SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=94' AND store_id = '0' AND language_id = '1'
0.00010108947753906SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017309188842773SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=95' AND store_id = '0' AND language_id = '1'
0.00010180473327637SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=96' AND store_id = '0' AND language_id = '1'
0.00010395050048828SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=69' AND store_id = '0' AND language_id = '1'
0.00010800361633301SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer' AND store_id = '0' AND language_id = '1'
0.0001380443572998SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/brands'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'information_id=64' AND store_id = '0' AND language_id = '1'
0.00013399124145508SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.0001380443572998SELECT * FROM oc_seo_url WHERE `query` = 'information_id=65' AND store_id = '0' AND language_id = '1'
0.00012898445129395SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'extension/module/menu'
0.00014805793762207SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/quicksignup' OR route = 'ru-ru')
0.00015783309936523SELECT * FROM oc_seo_url WHERE `query` = 'account/edit' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'account/register' AND store_id = '0' AND language_id = '1'
0.00015497207641602SELECT * FROM oc_seo_url WHERE `query` = 'account/login' AND store_id = '0' AND language_id = '1'
0.00013184547424316SELECT * FROM oc_seo_url WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'
0.00015497207641602SELECT * FROM oc_seo_url WHERE `query` = 'account/forgotten' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/quicksignup'
0.0001678466796875SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/header'
0.00021600723266602SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'product/category'