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, Сб-Вс - выходной

Конструкторы

Конструктор гидравлический Робот-рука 3 в 1(желтый)

Конструктор гидравлический «Робот-рука 3 в 1» − развивающий набор для детей, которые делают первые ш..

нет отзывов

3999р.

Конструктор гидравлический Робот-рука 3 в 1(синий)

Конструктор гидравлический «Робот-рука 3 в 1» − развивающий набор для детей, которые делают первые ш..

нет отзывов

3999р.

Конструктор гидравлический Строительная техника 3 в 1 (бульдозер, автовышка, манипулятор)

Конструктор гидравлический «Строительная техника 3 в 1» − развивающий набор для детей, которые делаю..

нет отзывов

2699р.

Конструктор гидравлический Строительная техника 3 в 1 (экскаватор, кран, погрузчик)

Конструктор гидравлический «Строительная техника 3 в 1» − развивающий набор для детей, которые делаю..

нет отзывов

2699р.

Конструктор Электронный Тир

Конструктор электронный «Тир» − развивающий набор для детей, которые делают первые шаги в робототехн..

нет отзывов

1789р.

Радиоуправляемый конструктор-трансформер "Прометей" 10 в 1

Конструктор ND Play открывает безграничные возможности для инженерной и творческой мысли! Он станет ..

нет отзывов

2899р.

Сделай шаг, сделай два - конструкции с мотором

3D-конструктор для развития инженерного и творческого мышления − первый шаг в мир науки, техники и ..

нет отзывов

24000р.

Конструктор Боевой робот 3 в 1

Робот работает от солнечной батареи и трансформируется в три разные движущиеся модели. Боевой робот ..

1299р.

Конструктор. Мой первый робот

Продемонстрируйте ваше творчество и оживите созданные вами конструкции! Каждый уважающий се..

нет отзывов

33120р.

Образовательный базовый робототехнический набор 2.0

Совместимый с лего конструктор «Базовый робототехнический набор 2.0» − готовый набор для изучения р..

нет отзывов

19990р.

Пластиковый конструктор 98 деталей

Аналогичный металлическим, данный конструктор выполнен из легких пластиковых деталей. Является одной..

нет отзывов

648р.

Конструктор лошади Пламенный Пегас 3 в 1

Набор позволяет собрать 3 различные модели, работающие от солнечной батареи. Все модели движутся – д..

нет отзывов

923р.

Конструктор Электромобиль 4WD

Конструктор «Электромобиль 4WD» − развивающий набор для детей, которые делают первые шаги в робототе..

нет отзывов

2699р.

Магнитный конструктор "Geomag Hyper Glow 80"

Магнитный конструктор Geomag способствует развитию воображения и пространственного мышления у детей...

нет отзывов

1349р.

Пластиковый конструктор 121 деталь

Аналогичный металлическим, данный конструктор выполнен из легких пластиковых деталей. Является одной..

нет отзывов

945р.

Металлический конструктор 243 детали

Конструктор является одной из самых полезных игрушек для развития мелкой моторики, аккуратности, уси..

нет отзывов

648р.

Пластиковый конструктор 106 деталей

Аналогичный металлическим, данный конструктор выполнен из легких пластиковых деталей. Является одной..

нет отзывов

549р.

Конструктор пластиковый Подъемный кран, 52 детали

Соберите конструктор «Подъемный кран» и начните строить город своей мечты!Пластиковый конструктор «П..

нет отзывов

339р.

Конструктор Магические формы

Конструктор «Магические формы» − развивающий набор для детей, которые делают первые шаги в роб..

нет отзывов

1699р.

Конструктор Робот Тобби

Тобби — умный шестиногий робот — прекрасно ладит с детьми. Он работает в двух режимах: следует за об..

3599р.

Конструктор Банкабот

Банкабот — это забавный робот с мотором, дикий, но симпатичный. В основе его конструкции жестяная ба..

нет отзывов

929р.

Конструктор Дикий вепрь

Конструктор "Дикий вепрь" - это превосходная возможность для юного исследователя проявить конструкто..

нет отзывов

813р.

Конструктор пластиковый Трехколесный мотоцикл, 27 деталей

Соберите конструктор «Трехколесный мотоцикл» и встаньте на защиту своего города!Пластиковый конструк..

нет отзывов

259р.

Радиоуправляемый конструктор-трансформер "Джентельмен" 10 в 1

Конструктор ND Play открывает безграничные возможности для инженерной и творческой мысли! Он станет ..

нет отзывов

2899р.

Конструктор пластиковый Танк, 26 деталей

Пластиковый конструктор «Танк» − развивающий набор для детей, которые делают первые шаги в робототех..

нет отзывов

159р.

Конструктор Робот-манипулятор

Электронный конструктор поможет любознательному ребёнку (6+) разобраться в устройстве робота-манипул..

нет отзывов

3999р.

Конструктор Миссия на марс 4 в 1

Из этого конструктора можно собрать настоящую марсианскую станцию! Блок солнечных батарей в комплект..

нет отзывов

999р.

Трасса с машинкой на батарейке «Дино Тур» с маркировкой «ND Play» в подарочной упаковке.

Гибкий автотрек - это новый тренд  в направлении игровых трасс и игр с машинками. Трассу можно ..

нет отзывов

1149р.

Конструктор Марсоход (желтый)

Конструктор «Марсоход» − развивающий набор для детей, которые делают первые шаги в робототехни..

нет отзывов

1289р.

Конструктор пластиковый Батискаф, 36 деталей

Пластиковый конструктор «Батискаф» − развивающий набор для детей, которые делают первые шаги в робот..

нет отзывов

299р.

Debug SQL
0.00017309188842773SELECT `data` FROM `oc_session` WHERE session_id = '526bf477fc66702ae0c0d40613' AND expire > 1713490511
0.00023794174194336SELECT * FROM oc_extension WHERE `type` = 'openbay'
0.0002129077911377SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
0.00017690658569336SELECT * FROM oc_extension WHERE `type` = 'openbay'
0.0001828670501709SELECT `data` FROM `oc_session` WHERE session_id = '14291e51daa94d891b23ffbb39' AND expire > 1713490511
0.00016593933105469SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://ndplay.ru/'
0.0020520687103271SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
0.00019598007202148SELECT * FROM oc_language WHERE status = '1' ORDER BY sort_order, name
0.00014996528625488SELECT * FROM oc_currency
0.00037503242492676SELECT 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.00027704238891602SELECT 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.0001380443572998SELECT * 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.00013208389282227SELECT * 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.0043230056762695DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
0.0001530647277832SELECT * FROM oc_extension WHERE `type` = 'openbay'
0.004025936126709SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC
0.00022292137145996SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/bsfilter' OR route = 'ru-ru')
0.0001370906829834SELECT * FROM oc_bsfilter_page WHERE status = '1' AND keyword = 'konstruktory' LIMIT 1
0.00052714347839355SELECT REPLACE(`query`, 'manufacturer_id=', '') AS manufacturer_id FROM oc_seo_url WHERE `query` LIKE 'manufacturer_id=%' AND LCASE(`keyword`) = 'konstruktory' LIMIT 1
0.0001380443572998SELECT * FROM oc_bsfilter_page WHERE status = '1'
0.00020909309387207SELECT * FROM oc_seo_url WHERE keyword = 'konstruktory' AND store_id = '0'
0.00015091896057129SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/category' OR route = 'ru-ru')
0.00020790100097656SELECT * FROM oc_seo_url WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'
0.00019502639770508SELECT 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 = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
0.00019097328186035SELECT * 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=25' AND store_id = '0' AND language_id = '1'
0.00019192695617676SELECT * FROM oc_seo_url WHERE `query` = 'product/compare' AND store_id = '0' AND language_id = '1'
0.0019710063934326SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '25' AND cd.language_id = '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.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00017285346984863SELECT * FROM oc_seo_url WHERE `query` = 'category_id=189' 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.00023794174194336SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00023293495178223SELECT * FROM oc_seo_url WHERE `query` = 'category_id=67' 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.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00017118453979492SELECT * FROM oc_seo_url WHERE `query` = 'category_id=186' 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.0001838207244873SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'category_id=187' 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.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.0001521110534668SELECT * FROM oc_seo_url WHERE `query` = 'category_id=188' AND store_id = '0' AND language_id = '1'
0.0014209747314453SELECT 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 = '25'
0.27809596061707SELECT 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 = '25' GROUP BY p.product_id ORDER BY p.quantity ASC, LCASE(pd.name) ASC LIMIT 0,30
0.0035459995269775SELECT 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 = '23502' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.002249002456665SELECT 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 = '23503' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.002291202545166SELECT 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 = '23504' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0021679401397705SELECT 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 = '23505' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024287700653076SELECT 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 = '23511' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.002399206161499SELECT 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 = '19520' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.00047492980957031SELECT 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 = '23820' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0010490417480469SELECT 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 = '70' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.00046896934509277SELECT 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 = '2748' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.00046396255493164SELECT 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 = '23627' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0044329166412354SELECT 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 = '18956' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0034680366516113SELECT 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 = '69' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.00341796875SELECT 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 = '22597' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0043978691101074SELECT 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 = '19421' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0045058727264404SELECT 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 = '18945' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0043349266052246SELECT 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 = '18931' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0040700435638428SELECT 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 = '18942' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0016109943389893SELECT 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 = '23805' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0022850036621094SELECT 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 = '23506' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0041849613189697SELECT 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 = '20896' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0032789707183838SELECT 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 = '18893' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0032510757446289SELECT 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 = '18895' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0017120838165283SELECT 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 = '23811' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0029981136322021SELECT 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 = '19519' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0018160343170166SELECT 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 = '23810' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0031700134277344SELECT 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 = '20699' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0033209323883057SELECT 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 = '3190' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.00081086158752441SELECT 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 = '24412' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0018758773803711SELECT 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 = '23507' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0017249584197998SELECT 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 = '23795' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.00010299682617188SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00016212463378906SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00031614303588867SELECT 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 = '23502' 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 = '23502' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0014858245849609SELECT 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 = '23502' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00015497207641602SELECT * 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 = '23502' AND od.language_id = '1' ORDER BY o.sort_order
0.00014400482177734SELECT 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 = 23502 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00015902519226074SELECT * 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.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00018692016601562SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00027012825012207SELECT * FROM oc_seo_url WHERE `query` = 'product_id=23502' AND store_id = '0' AND language_id = '1'
0.00012612342834473SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.0001680850982666SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.0002748966217041SELECT 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 = '23503' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0014340877532959SELECT 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 = '23503' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0013210773468018SELECT 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 = '23503' AND a.attribute_group_id = '8' 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 = '23503' AND od.language_id = '1' ORDER BY o.sort_order
0.00012516975402832SELECT 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 = 23503 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.0001380443572998SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015592575073242SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00013494491577148SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00024294853210449SELECT * FROM oc_seo_url WHERE `query` = 'product_id=23503' AND store_id = '0' AND language_id = '1'
0.00011205673217773SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013494491577148SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00024914741516113SELECT 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 = '23504' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0013771057128906SELECT 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 = '23504' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0012369155883789SELECT 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 = '23504' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00013208389282227SELECT * 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 = '23504' AND od.language_id = '1' ORDER BY o.sort_order
9.9897384643555E-5SELECT 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 = 23504 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015711784362793SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00012803077697754SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.000244140625SELECT * FROM oc_seo_url WHERE `query` = 'product_id=23504' AND store_id = '0' AND language_id = '1'
0.00011181831359863SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013494491577148SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00024795532226562SELECT 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 = '23505' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0017030239105225SELECT 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 = '23505' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0013720989227295SELECT 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 = '23505' AND a.attribute_group_id = '8' 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 = '23505' AND od.language_id = '1' ORDER BY o.sort_order
0.00013303756713867SELECT 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 = 23505 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00014185905456543SELECT * 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=0' AND store_id = '0' AND language_id = '1'
0.00012612342834473SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00016379356384277SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00024199485778809SELECT * FROM oc_seo_url WHERE `query` = 'product_id=23505' AND store_id = '0' AND language_id = '1'
0.00011277198791504SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00014185905456543SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.0002598762512207SELECT 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 = '23511' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0015380382537842SELECT 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 = '23511' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.001352071762085SELECT 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 = '23511' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00013518333435059SELECT * 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 = '23511' AND od.language_id = '1' ORDER BY o.sort_order
0.00012588500976562SELECT 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 = 23511 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.00015807151794434SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00013089179992676SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00016689300537109SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00024318695068359SELECT * FROM oc_seo_url WHERE `query` = 'product_id=23511' AND store_id = '0' AND language_id = '1'
0.00011706352233887SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.0001368522644043SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00026607513427734SELECT 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 = '19520' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016920566558838SELECT 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 = '19520' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0013618469238281SELECT 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 = '19520' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0001370906829834SELECT * 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 = '19520' AND od.language_id = '1' ORDER BY o.sort_order
0.00010299682617188SELECT 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 = 19520 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00014090538024902SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016212463378906SELECT * 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.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.0002589225769043SELECT * FROM oc_seo_url WHERE `query` = 'product_id=19520' AND store_id = '0' AND language_id = '1'
0.00011205673217773SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00011420249938965SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00026798248291016SELECT 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 = '23820' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0015850067138672SELECT 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 = '23820' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0013589859008789SELECT 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 = '23820' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00014710426330566SELECT * 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 = '23820' AND od.language_id = '1' ORDER BY o.sort_order
0.00010490417480469SELECT 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 = 23820 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.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00012683868408203SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'product_id=23820' AND store_id = '0' AND language_id = '1'
0.00015878677368164SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00019502639770508SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00032997131347656SELECT 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 = '70' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0018930435180664SELECT 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 = '70' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0018558502197266SELECT 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 = '70' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00017786026000977SELECT * 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 = '70' AND od.language_id = '1' ORDER BY o.sort_order
0.00014710426330566SELECT 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 = 70 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00018906593322754SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00020694732666016SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00017309188842773SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00023603439331055SELECT * FROM oc_seo_url WHERE `query` = 'product_id=70' AND store_id = '0' AND language_id = '1'
0.00013184547424316SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00018405914306641SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00030708312988281SELECT 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 = '2748' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0019419193267822SELECT 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 = '2748' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.001708984375SELECT 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 = '2748' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00017499923706055SELECT * 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 = '2748' AND od.language_id = '1' ORDER BY o.sort_order
0.00014901161193848SELECT 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 = 2748 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00018906593322754SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00021696090698242SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00017786026000977SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00021100044250488SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00019288063049316SELECT * FROM oc_seo_url WHERE `query` = 'product_id=2748' AND store_id = '0' AND language_id = '1'
0.00015807151794434SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00018501281738281SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00034403800964355SELECT 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 = '23627' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0014548301696777SELECT 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 = '23627' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00017809867858887SELECT * 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 = '23627' 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 = 23627 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018906593322754SELECT * 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.0001981258392334SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'product_id=23627' AND store_id = '0' AND language_id = '1'
0.0001518726348877SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00017786026000977SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00030994415283203SELECT 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 = '18956' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.001708984375SELECT 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 = '18956' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0017180442810059SELECT 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 = '18956' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00013399124145508SELECT * 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 = '18956' 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 = 18956 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.0001378059387207SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00010395050048828SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00023984909057617SELECT * FROM oc_seo_url WHERE `query` = 'product_id=18956' AND store_id = '0' AND language_id = '1'
9.2983245849609E-5SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00011706352233887SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00024914741516113SELECT 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 = '69' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016939640045166SELECT 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 = '69' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0012640953063965SELECT 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 = '69' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00011515617370605SELECT * 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 = '69' AND od.language_id = '1' ORDER BY o.sort_order
0.00010418891906738SELECT 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 = 69 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.0001220703125SELECT * 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=0' AND store_id = '0' AND language_id = '1'
0.00010514259338379SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014090538024902SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00016689300537109SELECT * FROM oc_seo_url WHERE `query` = 'product_id=69' AND store_id = '0' AND language_id = '1'
8.9883804321289E-5SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00011992454528809SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00024700164794922SELECT 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 = '22597' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0015921592712402SELECT 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 = '22597' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0016019344329834SELECT 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 = '22597' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00011706352233887SELECT * 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 = '22597' AND od.language_id = '1' ORDER BY o.sort_order
0.00010299682617188SELECT 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 = 22597 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00012087821960449SELECT * 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=0' AND store_id = '0' AND language_id = '1'
0.00011014938354492SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.0001530647277832SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00019192695617676SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22597' AND store_id = '0' AND language_id = '1'
0.00010299682617188SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00012493133544922SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00023794174194336SELECT 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 = '19421' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0014309883117676SELECT 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 = '19421' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00011610984802246SELECT * 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 = '19421' AND od.language_id = '1' ORDER BY o.sort_order
0.00010299682617188SELECT 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 = 19421 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00011801719665527SELECT * 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=0' AND store_id = '0' AND language_id = '1'
0.00010490417480469SELECT * 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=25' AND store_id = '0' AND language_id = '1'
0.00020313262939453SELECT * FROM oc_seo_url WHERE `query` = 'product_id=19421' AND store_id = '0' AND language_id = '1'
0.0001680850982666SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00011682510375977SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.0002288818359375SELECT 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 = '18945' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0012459754943848SELECT 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 = '18945' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0016019344329834SELECT 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 = '18945' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00011396408081055SELECT * 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 = '18945' AND od.language_id = '1' ORDER BY o.sort_order
0.00010585784912109SELECT 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 = 18945 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00011801719665527SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00013494491577148SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00010204315185547SELECT * 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=25' AND store_id = '0' AND language_id = '1'
0.00023603439331055SELECT * FROM oc_seo_url WHERE `query` = 'product_id=18945' AND store_id = '0' AND language_id = '1'
9.2983245849609E-5SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00011706352233887SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00023508071899414SELECT 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 = '18931' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0013620853424072SELECT 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 = '18931' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0015430450439453SELECT 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 = '18931' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00010991096496582SELECT * 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 = '18931' AND od.language_id = '1' ORDER BY o.sort_order
0.00010299682617188SELECT 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 = 18931 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00011491775512695SELECT * 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=0' AND store_id = '0' AND language_id = '1'
0.0001060962677002SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00023317337036133SELECT * FROM oc_seo_url WHERE `query` = 'product_id=18931' AND store_id = '0' AND language_id = '1'
8.9883804321289E-5SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00011301040649414SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00023102760314941SELECT 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 = '18942' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0015459060668945SELECT 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 = '18942' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0015468597412109SELECT 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 = '18942' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00011277198791504SELECT * 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 = '18942' AND od.language_id = '1' ORDER BY o.sort_order
0.00010299682617188SELECT 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 = 18942 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00011801719665527SELECT * 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.00010490417480469SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014114379882812SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00023508071899414SELECT * FROM oc_seo_url WHERE `query` = 'product_id=18942' AND store_id = '0' AND language_id = '1'
9.3936920166016E-5SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00011515617370605SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00023388862609863SELECT 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 = '23805' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016729831695557SELECT 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 = '23805' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.001539945602417SELECT 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 = '23805' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00011396408081055SELECT * 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 = '23805' AND od.language_id = '1' ORDER BY o.sort_order
0.00010299682617188SELECT 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 = 23805 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00011777877807617SELECT * 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=0' AND store_id = '0' AND language_id = '1'
0.00010895729064941SELECT * 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=25' AND store_id = '0' AND language_id = '1'
0.00015711784362793SELECT * FROM oc_seo_url WHERE `query` = 'product_id=23805' AND store_id = '0' AND language_id = '1'
9.0122222900391E-5SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00011610984802246SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00023293495178223SELECT 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 = '23506' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0014350414276123SELECT 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 = '23506' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.001554012298584SELECT 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 = '23506' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00011181831359863SELECT * 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 = '23506' AND od.language_id = '1' ORDER BY o.sort_order
0.00010299682617188SELECT 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 = 23506 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00011706352233887SELECT * 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=0' AND store_id = '0' AND language_id = '1'
0.00010490417480469SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014591217041016SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00021696090698242SELECT * FROM oc_seo_url WHERE `query` = 'product_id=23506' AND store_id = '0' AND language_id = '1'
9.2983245849609E-5SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00012302398681641SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00026893615722656SELECT 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 = '20896' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0014338493347168SELECT 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 = '20896' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0014560222625732SELECT 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 = '20896' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0001678466796875SELECT * 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 = '20896' AND od.language_id = '1' ORDER BY o.sort_order
0.00014615058898926SELECT 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 = 20896 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00015115737915039SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00018811225891113SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00022983551025391SELECT * FROM oc_seo_url WHERE `query` = 'product_id=20896' AND store_id = '0' AND language_id = '1'
0.00015592575073242SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00016307830810547SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00027084350585938SELECT 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 = '18893' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0017011165618896SELECT 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 = '18893' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0013940334320068SELECT 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 = '18893' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00015592575073242SELECT * 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 = '18893' AND od.language_id = '1' ORDER BY o.sort_order
0.00014996528625488SELECT 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 = 18893 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00016188621520996SELECT * 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=0' AND store_id = '0' AND language_id = '1'
0.0001060962677002SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014615058898926SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00023198127746582SELECT * FROM oc_seo_url WHERE `query` = 'product_id=18893' AND store_id = '0' AND language_id = '1'
9.2029571533203E-5SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00014400482177734SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00028681755065918SELECT 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 = '18895' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0017471313476562SELECT 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 = '18895' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0017259120941162SELECT 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 = '18895' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00017595291137695SELECT * 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 = '18895' AND od.language_id = '1' ORDER BY o.sort_order
0.00014901161193848SELECT 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 = 18895 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.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00015711784362793SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00021791458129883SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00028300285339355SELECT * FROM oc_seo_url WHERE `query` = 'product_id=18895' AND store_id = '0' AND language_id = '1'
0.00013279914855957SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00016117095947266SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.0003361701965332SELECT 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 = '23811' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0018389225006104SELECT 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 = '23811' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0021810531616211SELECT 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 = '23811' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00015783309936523SELECT * 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 = '23811' AND od.language_id = '1' ORDER BY o.sort_order
0.00012898445129395SELECT 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 = 23811 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00021100044250488SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00023388862609863SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.0001530647277832SELECT * 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=25' AND store_id = '0' AND language_id = '1'
0.00018191337585449SELECT * FROM oc_seo_url WHERE `query` = 'product_id=23811' AND store_id = '0' AND language_id = '1'
0.00012397766113281SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00018477439880371SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00030398368835449SELECT 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 = '19519' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0017940998077393SELECT 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 = '19519' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0013809204101562SELECT 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 = '19519' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00012397766113281SELECT * 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 = '19519' AND od.language_id = '1' ORDER BY o.sort_order
0.0001060962677002SELECT 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 = 19519 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00012397766113281SELECT * 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=0' AND store_id = '0' AND language_id = '1'
0.00010490417480469SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00022196769714355SELECT * FROM oc_seo_url WHERE `query` = 'product_id=19519' AND store_id = '0' AND language_id = '1'
9.2029571533203E-5SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00011920928955078SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00025105476379395SELECT 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 = '23810' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0017621517181396SELECT 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 = '23810' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0015430450439453SELECT 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 = '23810' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00017213821411133SELECT * 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 = '23810' AND od.language_id = '1' ORDER BY o.sort_order
0.00014591217041016SELECT 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 = 23810 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00016593933105469SELECT * 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.0001981258392334SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00023889541625977SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00024890899658203SELECT * FROM oc_seo_url WHERE `query` = 'product_id=23810' AND store_id = '0' AND language_id = '1'
0.00011897087097168SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00020098686218262SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00036120414733887SELECT 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 = '20699' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016880035400391SELECT 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 = '20699' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0017740726470947SELECT 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 = '20699' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00016999244689941SELECT * 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 = '20699' AND od.language_id = '1' ORDER BY o.sort_order
0.00014996528625488SELECT 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 = 20699 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00016212463378906SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018215179443359SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00019693374633789SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00018692016601562SELECT * FROM oc_seo_url WHERE `query` = 'product_id=20699' AND store_id = '0' AND language_id = '1'
0.00011301040649414SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00012397766113281SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00026297569274902SELECT 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 = '3190' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016810894012451SELECT 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 = '3190' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0013630390167236SELECT 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 = '3190' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00011396408081055SELECT * 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 = '3190' 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 = 3190 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00012397766113281SELECT * 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=0' AND store_id = '0' AND language_id = '1'
0.00010395050048828SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014114379882812SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'product_id=3190' AND store_id = '0' AND language_id = '1'
8.9168548583984E-5SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00011706352233887SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00017189979553223SELECT 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 = '24412' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.00010204315185547SELECT * 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 = '24412' AND od.language_id = '1' ORDER BY o.sort_order
9.7990036010742E-5SELECT 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 = 24412 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00011110305786133SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00013303756713867SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00010204315185547SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014019012451172SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00012016296386719SELECT * FROM oc_seo_url WHERE `query` = 'product_id=24412' AND store_id = '0' AND language_id = '1'
9.2983245849609E-5SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00010585784912109SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00022101402282715SELECT 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 = '23507' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016160011291504SELECT 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 = '23507' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.001298189163208SELECT 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 = '23507' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00012993812561035SELECT * 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 = '23507' AND od.language_id = '1' ORDER BY o.sort_order
0.00011110305786133SELECT 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 = 23507 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00012588500976562SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001380443572998SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00010490417480469SELECT * 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=25' AND store_id = '0' AND language_id = '1'
0.00022196769714355SELECT * FROM oc_seo_url WHERE `query` = 'product_id=23507' AND store_id = '0' AND language_id = '1'
9.1791152954102E-5SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00011706352233887SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00024700164794922SELECT 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 = '23795' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0014371871948242SELECT 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 = '23795' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0016250610351562SELECT 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 = '23795' AND a.attribute_group_id = '8' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00011610984802246SELECT * 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 = '23795' AND od.language_id = '1' ORDER BY o.sort_order
0.00010490417480469SELECT 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 = 23795 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00011897087097168SELECT * 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=0' AND store_id = '0' AND language_id = '1'
0.00010800361633301SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00016093254089355SELECT * FROM oc_seo_url WHERE `query` = 'product_id=23795' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * 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=25' AND store_id = '0' AND language_id = '1'
0.0001380443572998SELECT * 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=25' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * 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=25' AND store_id = '0' AND language_id = '1'
0.00014185905456543SELECT * 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=25' AND store_id = '0' AND language_id = '1'
0.0001370906829834SELECT * 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=25' AND store_id = '0' AND language_id = '1'
0.00014090538024902SELECT * 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=25' AND store_id = '0' AND language_id = '1'
0.0001370906829834SELECT * 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=25' 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.00013399124145508SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * 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=25' AND store_id = '0' AND language_id = '1'
0.0001380443572998SELECT * 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=25' AND store_id = '0' AND language_id = '1'
0.0001370906829834SELECT * 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=25' AND store_id = '0' AND language_id = '1'
0.0001380443572998SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013279914855957SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.0001370906829834SELECT * 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=25' 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.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.0001380443572998SELECT * 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=25' AND store_id = '0' AND language_id = '1'
0.0001380443572998SELECT * 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=25' AND store_id = '0' AND language_id = '1'
0.00014996528625488SELECT * 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=25' AND store_id = '0' AND language_id = '1'
0.00014090538024902SELECT * 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=25' 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.00013494491577148SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' 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.00013995170593262SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' 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.00017809867858887SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' 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.00017786026000977SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' 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.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' 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.00013995170593262SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' 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.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' 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.00013899803161621SELECT * FROM oc_category_to_layout WHERE category_id = '25' AND store_id = '0'
0.00014996528625488SELECT * FROM oc_layout_module WHERE layout_id = '145' AND position = 'column_left' ORDER BY sort_order
0.00014996528625488SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/bsfilter' OR route = 'ru-ru')
0.00021004676818848SELECT * 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=25' 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.00018119812011719SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' 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.0001838207244873SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' 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.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' 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.00017285346984863SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' 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.0001978874206543SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' 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.00014901161193848SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' 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.00018811225891113SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00019001960754395SELECT * 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=25' 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.00018596649169922SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00018811225891113SELECT * 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=25' AND store_id = '0' AND language_id = '1'
0.0021622180938721SELECT * 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.00021195411682129SELECT * 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=172' AND store_id = '0' AND language_id = '1'
0.015474081039429SELECT 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.00023889541625977SELECT * 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=223' AND store_id = '0' AND language_id = '1'
0.014158010482788SELECT 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.0002288818359375SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.028074026107788SELECT 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.00023889541625977SELECT * 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=230' AND store_id = '0' AND language_id = '1'
0.015536785125732SELECT 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.00023007392883301SELECT * 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=20' AND store_id = '0' AND language_id = '1'
0.018757104873657SELECT 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.00024700164794922SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'category_id=205' AND store_id = '0' AND language_id = '1'
0.013342142105103SELECT 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.00027799606323242SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00024986267089844SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.01347017288208SELECT 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.00023818016052246SELECT * 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.019563913345337SELECT 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.00025200843811035SELECT * 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=221' AND store_id = '0' AND language_id = '1'
0.013206005096436SELECT 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.00022792816162109SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'extension/module/bsfilter'
0.00016522407531738SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/category_description' OR route = 'ru-ru')
0.00019693374633789SELECT 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 = '25' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
0.0017471313476562SELECT * 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.00019717216491699SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'extension/module/category_description'
0.00017404556274414SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/column_left'
0.00014114379882812SELECT * FROM oc_category_to_layout WHERE category_id = '25' AND store_id = '0'
0.00015401840209961SELECT * FROM oc_layout_module WHERE layout_id = '145' AND position = 'column_right' ORDER BY sort_order
0.00016403198242188SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/column_right'
0.00015711784362793SELECT * FROM oc_category_to_layout WHERE category_id = '25' AND store_id = '0'
0.00016903877258301SELECT * FROM oc_layout_module WHERE layout_id = '145' AND position = 'content_top' ORDER BY sort_order
0.00018310546875SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/content_top'
0.00019216537475586SELECT * FROM oc_category_to_layout WHERE category_id = '25' AND store_id = '0'
0.0001671314239502SELECT * FROM oc_layout_module WHERE layout_id = '145' AND position = 'content_bottom' ORDER BY sort_order
0.00023412704467773SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/content_bottom'
0.00019383430480957SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru')
0.00012803077697754SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/social' OR route = 'ru-ru')
0.00019001960754395SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'extension/module/social_icons'
0.00023102760314941SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')
0.00021696090698242SELECT * FROM oc_seo_url WHERE `query` = 'common/language/language' AND store_id = '0' AND language_id = '1'
0.00014305114746094SELECT * FROM oc_language WHERE status = '1' ORDER BY sort_order, name
0.00020289421081543SELECT * 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=25' AND store_id = '0' AND language_id = '1'
0.00018715858459473SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/language'
0.00014996528625488SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
0.00018787384033203SELECT * FROM oc_seo_url WHERE `query` = 'common/currency/currency' AND store_id = '0' AND language_id = '1'
0.00019216537475586SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018715858459473SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' 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.002284049987793SELECT * 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.0002589225769043SELECT * 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=172' 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.0001370906829834SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' 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.00023102760314941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00024604797363281SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00023388862609863SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00024604797363281SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0002288818359375SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00022292137145996SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'category_id=205' 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.00020909309387207SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' 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.00014090538024902SELECT * 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.00018787384033203SELECT * FROM oc_seo_url WHERE `query` = 'category_id=221' AND store_id = '0' AND language_id = '1'
0.0020349025726318SELECT * 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.00019693374633789SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00017380714416504SELECT * FROM oc_seo_url WHERE `query` = 'information_id=67' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'information_id=77' AND store_id = '0' AND language_id = '1'
0.00014996528625488SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00015902519226074SELECT * FROM oc_seo_url WHERE `query` = 'information_id=68' AND store_id = '0' AND language_id = '1'
0.00014901161193848SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'information_id=73' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00019502639770508SELECT * FROM oc_seo_url WHERE `query` = 'information_id=64' AND store_id = '0' AND language_id = '1'
0.00018310546875SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00018787384033203SELECT * FROM oc_seo_url WHERE `query` = 'information_id=66' AND store_id = '0' AND language_id = '1'
0.00017690658569336SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00018692016601562SELECT * FROM oc_seo_url WHERE `query` = 'information_id=65' AND store_id = '0' AND language_id = '1'
0.00018620491027832SELECT * FROM oc_seo_url WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '1'
0.00016188621520996SELECT * FROM oc_seo_url WHERE `query` = 'account/return/add' AND store_id = '0' AND language_id = '1'
0.00018692016601562SELECT * FROM oc_seo_url WHERE `query` = 'information/sitemap' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'information/tracking' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'account/voucher' AND store_id = '0' AND language_id = '1'
0.00014615058898926SELECT * FROM oc_seo_url WHERE `query` = 'affiliate/login' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'product/special' AND store_id = '0' AND language_id = '1'
0.00015711784362793SELECT * FROM oc_seo_url WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
0.00015902519226074SELECT * FROM oc_seo_url WHERE `query` = 'account/order' AND store_id = '0' AND language_id = '1'
0.00016093254089355SELECT * FROM oc_seo_url WHERE `query` = 'account/wishlist' AND store_id = '0' AND language_id = '1'
0.00014281272888184SELECT * FROM oc_seo_url WHERE `query` = 'account/newsletter' AND store_id = '0' AND language_id = '1'
0.0001368522644043SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'theme/bodysport' OR route = 'ru-ru')
0.00012898445129395SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/subscribe' OR route = 'ru-ru')
0.00017976760864258SELECT * FROM oc_seo_url WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'
0.00020909309387207DELETE FROM `oc_customer_online` WHERE date_added < '2024-04-19 00:35:12'
0.00012707710266113REPLACE INTO `oc_customer_online` SET `ip` = '18.116.43.119', `customer_id` = '0', `url` = 'https://ndplay.ru/konstruktory', `referer` = 'http://ndplay.ru/constructor/', `date_added` = '2024-04-19 01:35:12'
0.0001678466796875SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/footer'
0.00023102760314941SELECT * FROM oc_extension WHERE `type` = 'analytics'
0.00023198127746582SELECT * FROM oc_seo_url WHERE `query` = 'style/setting' AND store_id = '0' AND language_id = '1'
0.00019693374633789SELECT * FROM oc_seo_url WHERE `query` = 'style/setting' AND store_id = '0' AND language_id = '1'
0.00019192695617676SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
0.00021219253540039SELECT * FROM oc_seo_url WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
0.00020289421081543SELECT * FROM oc_seo_url WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'
0.00023889541625977SELECT * FROM oc_seo_url WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'
0.00020599365234375SELECT * FROM oc_seo_url WHERE `query` = 'account/wishlist' AND store_id = '0' AND language_id = '1'
0.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
0.00020289421081543SELECT * FROM oc_seo_url WHERE `query` = 'account/register' AND store_id = '0' AND language_id = '1'
0.00020313262939453SELECT * FROM oc_seo_url WHERE `query` = 'account/login' AND store_id = '0' AND language_id = '1'
0.00020289421081543SELECT * FROM oc_seo_url WHERE `query` = 'account/order' AND store_id = '0' AND language_id = '1'
0.00020790100097656SELECT * FROM oc_seo_url WHERE `query` = 'account/transaction' AND store_id = '0' AND language_id = '1'
0.00020289421081543SELECT * FROM oc_seo_url WHERE `query` = 'account/download' AND store_id = '0' AND language_id = '1'
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'
0.00024795532226562SELECT * FROM oc_seo_url WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'
0.00023412704467773SELECT * FROM oc_seo_url WHERE `query` = 'checkout/checkout' AND store_id = '0' AND language_id = '1'
0.0002281665802002SELECT * FROM oc_seo_url WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '1'
0.00021100044250488SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/text_loading'
0.00020503997802734SELECT * FROM oc_seo_url WHERE `query` = 'account/edit' AND store_id = '0' AND language_id = '1'
0.00020003318786621SELECT * FROM oc_seo_url WHERE `query` = 'account/address' AND store_id = '0' AND language_id = '1'
0.00020408630371094SELECT * FROM oc_seo_url WHERE `query` = 'account/reward' AND store_id = '0' AND language_id = '1'
0.00020289421081543SELECT * FROM oc_seo_url WHERE `query` = 'account/return' AND store_id = '0' AND language_id = '1'
0.00018906593322754SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')
0.00022292137145996SELECT * FROM oc_seo_url WHERE `query` = 'common/language/language' AND store_id = '0' AND language_id = '1'
0.00013613700866699SELECT * FROM oc_language WHERE status = '1' ORDER BY sort_order, name
0.00023007392883301SELECT * 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=25' AND store_id = '0' AND language_id = '1'
0.00020098686218262SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/language'
0.00017094612121582SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
0.00020885467529297SELECT * FROM oc_seo_url WHERE `query` = 'common/currency/currency' AND store_id = '0' AND language_id = '1'
0.00021791458129883SELECT * 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=25' 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.00016593933105469SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru')
0.00018596649169922SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/search'
0.00014090538024902SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')
0.00018906593322754SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00016999244689941SELECT * FROM oc_extension WHERE `type` = 'total'
0.00014901161193848SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru')
0.00017714500427246SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00018000602722168SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00017690658569336SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/credit' OR route = 'ru-ru')
0.00016689300537109SELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0'
0.00019598007202148SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru')
0.00020217895507812SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00018692016601562SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '14291e51daa94d891b23ffbb39'
0.00024509429931641SELECT * FROM oc_seo_url WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'
0.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'checkout/checkout' AND store_id = '0' AND language_id = '1'
0.00022315979003906SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/cart'
0.00014185905456543SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/menu' OR route = 'ru-ru')
0.0022199153900146SELECT * 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.0019509792327881SELECT * 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.00025320053100586SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00021886825561523SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00023102760314941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00024008750915527SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00021100044250488SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00018596649169922SELECT * FROM oc_seo_url WHERE `query` = 'category_id=117' AND store_id = '0' AND language_id = '1'
0.00022006034851074SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00021195411682129SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00022006034851074SELECT * FROM oc_seo_url WHERE `query` = 'category_id=195' AND store_id = '0' AND language_id = '1'
0.00023698806762695SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018787384033203SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00016617774963379SELECT * FROM oc_seo_url WHERE `query` = 'category_id=238' 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.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00027799606323242SELECT * FROM oc_seo_url WHERE `query` = 'category_id=68' AND store_id = '0' AND language_id = '1'
0.00023198127746582SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00021791458129883SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00024104118347168SELECT * FROM oc_seo_url WHERE `query` = 'category_id=242' AND store_id = '0' AND language_id = '1'
0.00022006034851074SELECT * 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=172' AND store_id = '0' AND language_id = '1'
0.00020694732666016SELECT * FROM oc_seo_url WHERE `query` = 'category_id=245' AND store_id = '0' AND language_id = '1'
0.00020885467529297SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * FROM oc_seo_url WHERE `query` = 'category_id=204' 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.00019502639770508SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.0020489692687988SELECT * 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.00020790100097656SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019693374633789SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' AND store_id = '0' AND language_id = '1'
0.00023198127746582SELECT * FROM oc_seo_url WHERE `query` = 'category_id=389' 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.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'category_id=210' AND store_id = '0' AND language_id = '1'
0.00023007392883301SELECT * 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=223' AND store_id = '0' AND language_id = '1'
0.0002439022064209SELECT * FROM oc_seo_url WHERE `query` = 'category_id=371' AND store_id = '0' AND language_id = '1'
0.00023198127746582SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020480155944824SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' AND store_id = '0' AND language_id = '1'
0.0018489360809326SELECT * 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.00023984909057617SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00021791458129883SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00023508071899414SELECT * FROM oc_seo_url WHERE `query` = 'category_id=252' AND store_id = '0' AND language_id = '1'
0.00023317337036133SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0002129077911377SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00023317337036133SELECT * FROM oc_seo_url WHERE `query` = 'category_id=259' AND store_id = '0' AND language_id = '1'
0.00023102760314941SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0002129077911377SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00025010108947754SELECT * FROM oc_seo_url WHERE `query` = 'category_id=298' 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.0002140998840332SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00024223327636719SELECT * FROM oc_seo_url WHERE `query` = 'category_id=289' AND store_id = '0' AND language_id = '1'
0.00023102760314941SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019598007202148SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00024890899658203SELECT * FROM oc_seo_url WHERE `query` = 'category_id=364' AND store_id = '0' AND language_id = '1'
0.00020790100097656SELECT * 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=18' AND store_id = '0' AND language_id = '1'
0.0018970966339111SELECT * 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.00022697448730469SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020384788513184SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00024795532226562SELECT * FROM oc_seo_url WHERE `query` = 'category_id=227' 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.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00019979476928711SELECT * FROM oc_seo_url WHERE `query` = 'category_id=301' 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.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00020194053649902SELECT * FROM oc_seo_url WHERE `query` = 'category_id=300' 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.00017905235290527SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'category_id=250' AND store_id = '0' AND language_id = '1'
0.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'category_id=256' 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.00018692016601562SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.0001990795135498SELECT * FROM oc_seo_url WHERE `query` = 'category_id=305' 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.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.0017139911651611SELECT * 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.00020599365234375SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00023794174194336SELECT * FROM oc_seo_url WHERE `query` = 'category_id=65' AND store_id = '0' AND language_id = '1'
0.00018811225891113SELECT * 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=20' AND store_id = '0' AND language_id = '1'
0.00020503997802734SELECT * FROM oc_seo_url WHERE `query` = 'category_id=326' 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.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'category_id=185' 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.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00020718574523926SELECT * FROM oc_seo_url WHERE `query` = 'category_id=327' AND store_id = '0' AND language_id = '1'
0.00019478797912598SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001678466796875SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00021004676818848SELECT * FROM oc_seo_url WHERE `query` = 'category_id=345' AND store_id = '0' AND language_id = '1'
0.00020503997802734SELECT * 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=20' AND store_id = '0' AND language_id = '1'
0.0015511512756348SELECT * 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.00018215179443359SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'category_id=205' AND store_id = '0' AND language_id = '1'
0.00022196769714355SELECT * FROM oc_seo_url WHERE `query` = 'category_id=370' 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.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=205' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'category_id=228' 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.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'category_id=205' AND store_id = '0' AND language_id = '1'
0.0019378662109375SELECT * 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.00020813941955566SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00023508071899414SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.00023007392883301SELECT * FROM oc_seo_url WHERE `query` = 'category_id=397' AND store_id = '0' AND language_id = '1'
0.0001978874206543SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00022697448730469SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.0002291202545166SELECT * FROM oc_seo_url WHERE `query` = 'category_id=398' 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.00022506713867188SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.00022387504577637SELECT * FROM oc_seo_url WHERE `query` = 'category_id=399' 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.0002281665802002SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.00022315979003906SELECT * FROM oc_seo_url WHERE `query` = 'category_id=400' AND store_id = '0' AND language_id = '1'
0.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00022506713867188SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.0018351078033447SELECT * 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.00022196769714355SELECT * 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.0002140998840332SELECT * FROM oc_seo_url WHERE `query` = 'category_id=346' AND store_id = '0' AND language_id = '1'
0.00019001960754395SELECT * 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.00022006034851074SELECT * FROM oc_seo_url WHERE `query` = 'category_id=347' AND store_id = '0' AND language_id = '1'
0.00020694732666016SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015020370483398SELECT * 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=348' 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.00016093254089355SELECT * 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` = 'category_id=178' 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.00015997886657715SELECT * 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` = 'category_id=111' 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.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0016639232635498SELECT * 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.00018596649169922SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'category_id=221' AND store_id = '0' AND language_id = '1'
0.00022983551025391SELECT * FROM oc_seo_url WHERE `query` = 'category_id=394' 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.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'category_id=221' AND store_id = '0' AND language_id = '1'
0.00017714500427246SELECT * FROM oc_seo_url WHERE `query` = 'category_id=222' AND store_id = '0' AND language_id = '1'
0.00018715858459473SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'category_id=221' AND store_id = '0' AND language_id = '1'
0.00015783309936523SELECT * FROM oc_seo_url WHERE `query` = 'category_id=102' 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.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=221' AND store_id = '0' AND language_id = '1'
0.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'product/catalog' AND store_id = '0' AND language_id = '1'
0.00018692016601562SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/menu'
0.00016999244689941SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/brands' OR route = 'ru-ru')
0.0001671314239502SELECT * 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=120' AND store_id = '0' AND language_id = '1'
0.00015497207641602SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00024199485778809SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=147' 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.00022697448730469SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=142' 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.00023603439331055SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=32' AND store_id = '0' AND language_id = '1'
0.00017809867858887SELECT * 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=113' 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.00025606155395508SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=177' AND store_id = '0' AND language_id = '1'
0.00015807151794434SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00023007392883301SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=114' AND store_id = '0' AND language_id = '1'
0.00016689300537109SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00024008750915527SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=140' 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.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=121' 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.0001978874206543SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=163' 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.00021219253540039SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=123' AND store_id = '0' AND language_id = '1'
0.00015401840209961SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001978874206543SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=18' AND store_id = '0' AND language_id = '1'
0.00011491775512695SELECT * 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=132' AND store_id = '0' AND language_id = '1'
0.00014805793762207SELECT * 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=158' 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.00018191337585449SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=61' AND store_id = '0' AND language_id = '1'
0.00012993812561035SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019717216491699SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=33' 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.00019311904907227SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=73' AND store_id = '0' AND language_id = '1'
0.00011014938354492SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00022101402282715SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=74' AND store_id = '0' AND language_id = '1'
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=173' AND store_id = '0' AND language_id = '1'
0.00012612342834473SELECT * 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=122' AND store_id = '0' AND language_id = '1'
0.00014710426330566SELECT * 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=26' AND store_id = '0' AND language_id = '1'
0.00014495849609375SELECT * 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=75' AND store_id = '0' AND language_id = '1'
0.00012707710266113SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00024318695068359SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=65' AND store_id = '0' AND language_id = '1'
0.00014305114746094SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019383430480957SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=48' AND store_id = '0' AND language_id = '1'
0.00013303756713867SELECT * 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=164' AND store_id = '0' AND language_id = '1'
0.00013303756713867SELECT * 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=124' AND store_id = '0' AND language_id = '1'
0.00010490417480469SELECT * 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=175' AND store_id = '0' AND language_id = '1'
0.00012707710266113SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019121170043945SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=76' 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.00021696090698242SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=168' AND store_id = '0' AND language_id = '1'
0.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019979476928711SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=166' AND store_id = '0' AND language_id = '1'
0.00013208389282227SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00021791458129883SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=125' AND store_id = '0' AND language_id = '1'
0.00012683868408203SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00020503997802734SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=49' AND store_id = '0' AND language_id = '1'
0.00013208389282227SELECT * 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=167' AND store_id = '0' AND language_id = '1'
0.00012397766113281SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=146' AND store_id = '0' AND language_id = '1'
0.00012922286987305SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019598007202148SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=77' 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.00017905235290527SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=78' AND store_id = '0' AND language_id = '1'
0.00015497207641602SELECT * 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=133' AND store_id = '0' AND language_id = '1'
0.00014901161193848SELECT * 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=116' AND store_id = '0' AND language_id = '1'
0.00013399124145508SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00020313262939453SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=155' 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.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=111' AND store_id = '0' AND language_id = '1'
0.0001530647277832SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00021982192993164SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=79' 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.00017881393432617SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=136' AND store_id = '0' AND language_id = '1'
0.00012683868408203SELECT * 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=176' AND store_id = '0' AND language_id = '1'
0.00013208389282227SELECT * 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=131' AND store_id = '0' AND language_id = '1'
0.00012898445129395SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017905235290527SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=169' AND store_id = '0' AND language_id = '1'
0.00012898445129395SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017905235290527SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=165' AND store_id = '0' AND language_id = '1'
0.00012803077697754SELECT * 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=80' AND store_id = '0' AND language_id = '1'
0.00012683868408203SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00021791458129883SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=128' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019717216491699SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=25' AND store_id = '0' AND language_id = '1'
0.00015401840209961SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015521049499512SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=115' AND store_id = '0' AND language_id = '1'
0.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00023388862609863SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=81' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * 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=22' AND store_id = '0' AND language_id = '1'
0.00017213821411133SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00023412704467773SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=57' AND store_id = '0' AND language_id = '1'
0.00016880035400391SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00023198127746582SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=50' 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.00022006034851074SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=141' AND store_id = '0' AND language_id = '1'
0.00016880035400391SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0002131462097168SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=29' AND store_id = '0' AND language_id = '1'
0.00015401840209961SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00022006034851074SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=82' AND store_id = '0' AND language_id = '1'
0.00014805793762207SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=109' 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.00020718574523926SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=110' AND store_id = '0' AND language_id = '1'
0.00019192695617676SELECT * 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=83' AND store_id = '0' AND language_id = '1'
0.00014686584472656SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00024986267089844SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=84' AND store_id = '0' AND language_id = '1'
0.00017380714416504SELECT * 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=143' 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.0002138614654541SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=112' 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.00023007392883301SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=85' AND store_id = '0' AND language_id = '1'
0.00016188621520996SELECT * 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=150' 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.00024604797363281SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=86' AND store_id = '0' AND language_id = '1'
0.00017690658569336SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00024700164794922SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=51' 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.00023698806762695SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=60' AND store_id = '0' AND language_id = '1'
0.00017881393432617SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00023698806762695SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=87' AND store_id = '0' AND language_id = '1'
0.00017690658569336SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00023388862609863SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=88' 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.0002140998840332SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=101' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00024294853210449SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=72' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * 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=89' 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.00022077560424805SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=90' 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.00021696090698242SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=52' AND store_id = '0' AND language_id = '1'
0.00015115737915039SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019407272338867SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=117' 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.00018191337585449SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=172' AND store_id = '0' AND language_id = '1'
0.00013518333435059SELECT * 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=58' AND store_id = '0' AND language_id = '1'
0.00013113021850586SELECT * 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=91' AND store_id = '0' AND language_id = '1'
0.00012993812561035SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001978874206543SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=97' AND store_id = '0' AND language_id = '1'
0.00012707710266113SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=119' AND store_id = '0' AND language_id = '1'
0.00013017654418945SELECT * 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=55' AND store_id = '0' AND language_id = '1'
0.00012612342834473SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018215179443359SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=28' AND store_id = '0' AND language_id = '1'
0.00012493133544922SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018882751464844SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=70' AND store_id = '0' AND language_id = '1'
0.00012612342834473SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001981258392334SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=92' AND store_id = '0' AND language_id = '1'
0.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=170' AND store_id = '0' AND language_id = '1'
0.00012707710266113SELECT * 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=56' AND store_id = '0' AND language_id = '1'
0.00012707710266113SELECT * 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=93' AND store_id = '0' AND language_id = '1'
0.00012421607971191SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001988410949707SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=94' AND store_id = '0' AND language_id = '1'
0.00012516975402832SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001978874206543SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=95' AND store_id = '0' AND language_id = '1'
0.00012707710266113SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00020217895507812SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=96' AND store_id = '0' AND language_id = '1'
0.00012493133544922SELECT * 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=69' AND store_id = '0' AND language_id = '1'
0.00016021728515625SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/brands'
0.00021696090698242SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00021481513977051SELECT * FROM oc_seo_url WHERE `query` = 'information_id=64' AND store_id = '0' AND language_id = '1'
0.00020313262939453SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00021910667419434SELECT * FROM oc_seo_url WHERE `query` = 'information_id=65' AND store_id = '0' AND language_id = '1'
0.00020289421081543SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'extension/module/menu'
0.00018095970153809SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/quicksignup' OR route = 'ru-ru')
0.00017619132995605SELECT * FROM oc_seo_url WHERE `query` = 'account/edit' AND store_id = '0' AND language_id = '1'
0.00018620491027832SELECT * FROM oc_seo_url WHERE `query` = 'account/register' AND store_id = '0' AND language_id = '1'
0.00018191337585449SELECT * FROM oc_seo_url WHERE `query` = 'account/login' AND store_id = '0' AND language_id = '1'
0.00018715858459473SELECT * FROM oc_seo_url WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'
0.00014114379882812SELECT * FROM oc_seo_url WHERE `query` = 'account/forgotten' AND store_id = '0' AND language_id = '1'
0.00015497207641602SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/quicksignup'
0.00016117095947266SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/header'
0.00023078918457031SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'product/category'