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

Подарочная упаковка

Пакет подарочный большой Миньоны новогодние-5, 330*455*100 мм

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

нет отзывов

164р.

Пакет подарочный большой Щенячий патруль-5, 250*350*100 мм

Подарочный пакет «Щенячий патруль» розового цвета с изображением щенков из популярного мультсериала...

нет отзывов

152р.

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

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

нет отзывов

329р.

Пакет подарочный "Снегурочка с олененком", 335*406*155 мм

Подарочный пакет «Снегурочка с олененком» поможет стильно упаковать новогодние подарки для детей, ро..

нет отзывов

184р.

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

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

нет отзывов

332р.

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

Подарочный пакет «Леди Баг» красно-зеленый с изображением супергероини из популярного мультфильма. П..

нет отзывов

158р.

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

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

нет отзывов

80р.

LOL. Пакет подарочный большой-2, 220*310*100 мм

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

нет отзывов

88р.

Minnie Mouse.Пакет подарочный большой - 3, 400*300*140 мм

Большой подарочный пакет «Minnie Mouse» размером 400*300*140 мм создан для фанаток мультфильмов Disn..

нет отзывов

365р.

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

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

нет отзывов

119р.

Упаковочная бумага LOL , 700*1000 мм, 2 шт в рулоне

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

нет отзывов

97р.

Щенячий патруль. Упаковочная бумага-4, 700*1000 мм, 2 шт в рулоне

Привлекательная упаковочная бумага детская с изображением Скай и Эверест – щенков-спасателей из попу..

нет отзывов

123р.

Пакет подарочный большой Hot Wheels-2, 250*350*100 мм

Яркий подарочный пакет с изображением автомобилей Хот Вилс (Hot Wheels) для упаковки подарков мальчи..

нет отзывов

152р.

Упаковочная бумага в рулоне Леди Баг - 1

Детская упаковочная бумага "Леди Баг" привлекает внимание оригинальным дизайном и высоким уровнем ка..

нет отзывов

97р.

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

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

нет отзывов

101р.

Пакет подарочный "Дед Мороз -2", 335*406*155 мм

Подарочный пакет «Дед Мороз-2» поможет стильно упаковать новогодние подарки для детей, родителей и д..

нет отзывов

184р.

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

Подарочный пакет «Леди Баг и Супер-Кот» голубого цвета с изображением супергероев из популярного мул..

нет отзывов

158р.

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

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

нет отзывов

158р.

Minions 2. Упаковочная бумага (красная), 700*1000 мм, 2 шт в рулоне (рисованные)

Детская упаковочная бумага "Миньоны 2" (красная) привлекает внимание оригинальным дизайном и высоким..

нет отзывов

112р.

Пакет подарочный большой Superman-3, 250*350*100 мм

Большой подарочный пакет синего цвета с изображением супергероя – Супермена (Superman). Подарочный ..

нет отзывов

152р.

Пакет подарочный Супер Енот, 335*406*155 мм

Большой подарочный пакет "Супер Енот" отлично подойдёт для любителей супергероев. На пакете с двух с..

нет отзывов

185р.

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

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

нет отзывов

184р.

Пакет подарочный "Мяу-Коты", 335*406*155 мм

Подарочный пакет «Мяу-Коты» поможет стильно упаковать подарки для детей, родителей и друзей на..

нет отзывов

219р.

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

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

нет отзывов

329р.

Упаковочная бумага Пони, 700*1000 мм, 2 шт в рулоне

Упаковка подарка для девочки превратится в настоящий праздник с упаковочной бумагой детской «Пони» в..

нет отзывов

112р.

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

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

нет отзывов

230р.

Холодное Сердце. Пакет подарочный большой - 3, 400*300*140 мм

Большой подарочный пакет «Холодное Сердце» размером 400*300*140 мм создан для фанаток популярного му..

нет отзывов

332р.

Пакет подарочный большой Tom&Jerry-1, 335*406*155 мм

Яркий подарочный пакет с изображением популярных героев - Тома и Джерри для упаковки подарков ребенк..

нет отзывов

230р.

Щенячий патруль.Пакет подарочный большой - 1 (сине -красный),400*300*140 мм

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

нет отзывов

332р.

Сказочный патруль. Пакет подарочный большой (зелено-голубой), 335*406*155 мм

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

нет отзывов

158р.

Debug SQL
0.00023102760314941SELECT `data` FROM `oc_session` WHERE session_id = '5259d6db0fb2f56ae170afcd01' AND expire > 1713481182
0.00026178359985352SELECT * FROM oc_extension WHERE `type` = 'openbay'
0.00021600723266602SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
0.00019192695617676SELECT * FROM oc_extension WHERE `type` = 'openbay'
0.00019311904907227SELECT `data` FROM `oc_session` WHERE session_id = 'dad73f521d72894a16f5c72573' AND expire > 1713481182
0.00017690658569336SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://ndplay.ru/'
0.0019571781158447SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
0.00018215179443359SELECT * FROM oc_language WHERE status = '1' ORDER BY sort_order, name
0.00017309188842773SELECT * FROM oc_currency
0.00037598609924316SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM oc_tax_rule tr1 LEFT JOIN oc_tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN oc_tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN oc_zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN oc_geo_zone gz ON (tr2.geo_zone_id = gz.geo_zone_id) WHERE tr1.based = 'shipping' AND tr2cg.customer_group_id = '1' AND z2gz.country_id = '176' AND (z2gz.zone_id = '0' OR z2gz.zone_id = '83') ORDER BY tr1.priority ASC
0.00034093856811523SELECT 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.0001981258392334SELECT * 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.00019693374633789SELECT * 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.0038108825683594DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
0.00014209747314453SELECT * FROM oc_extension WHERE `type` = 'openbay'
0.0036928653717041SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC
0.00025200843811035SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/bsfilter' OR route = 'ru-ru')
0.00039291381835938SELECT GROUP_CONCAT(REPLACE(`query`, 'category_id=', '') ORDER BY FIELD(keyword, 'prazdnik', 'podarochnaya-upakovka') SEPARATOR '_') AS path FROM oc_seo_url WHERE `query` LIKE 'category_id=%' AND (keyword = 'prazdnik' OR keyword = 'podarochnaya-upakovka')
0.00018095970153809SELECT * FROM oc_bsfilter_page WHERE status = '1' AND keyword = 'prazdnik' LIMIT 1
0.00012803077697754SELECT * FROM oc_bsfilter_page WHERE status = '1' AND keyword = 'podarochnaya-upakovka' LIMIT 1
0.00023603439331055SELECT * FROM oc_bsfilter_page WHERE status = '1'
0.0002288818359375SELECT * FROM oc_seo_url WHERE keyword = 'prazdnik' AND store_id = '0'
0.00020599365234375SELECT * FROM oc_seo_url WHERE keyword = 'podarochnaya-upakovka' AND store_id = '0'
0.00019216537475586SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/category' OR route = 'ru-ru')
0.0002601146697998SELECT * FROM oc_seo_url WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'
0.00023102760314941SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '162' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
0.00023293495178223SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0002131462097168SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00021100044250488SELECT 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 = '178' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
0.00023198127746582SELECT * 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=162' AND store_id = '0' AND language_id = '1'
0.00021696090698242SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00023698806762695SELECT * FROM oc_seo_url WHERE `query` = 'product/compare' AND store_id = '0' AND language_id = '1'
0.0017879009246826SELECT * 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 = '178' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
0.00025486946105957SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017690658569336SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00021195411682129SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00022506713867188SELECT * FROM oc_seo_url WHERE `query` = 'category_id=224' 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.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00021195411682129SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.0002291202545166SELECT * FROM oc_seo_url WHERE `query` = 'category_id=225' AND store_id = '0' AND language_id = '1'
0.0027191638946533SELECT 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 = '178'
0.43296480178833SELECT 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 = '178' GROUP BY p.product_id ORDER BY p.quantity ASC, LCASE(pd.name) ASC LIMIT 60,30
0.0032877922058105SELECT 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 = '20894' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0031881332397461SELECT 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 = '21464' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0020449161529541SELECT 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 = '23467' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0023500919342041SELECT 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 = '22347' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0026609897613525SELECT 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 = '22517' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0030179023742676SELECT 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 = '21426' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0031671524047852SELECT 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 = '19305' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0031101703643799SELECT 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 = '20565' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0011160373687744SELECT 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 = '22270' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0031969547271729SELECT 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 = '20560' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0032830238342285SELECT 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 = '19050' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0031499862670898SELECT 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 = '20926' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0032761096954346SELECT 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 = '20779' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0031819343566895SELECT 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 = '19015' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0025529861450195SELECT 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 = '21268' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.002324104309082SELECT 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 = '22348' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.003079891204834SELECT 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 = '21457' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0030491352081299SELECT 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 = '21427' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024399757385254SELECT 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 = '20580' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0030159950256348SELECT 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 = '20782' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.00065898895263672SELECT 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 = '24223' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0022299289703369SELECT 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 = '22799' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0018291473388672SELECT 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 = '23456' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0018739700317383SELECT 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 = '23444' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0028579235076904SELECT 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 = '20922' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0023801326751709SELECT 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 = '22056' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0020289421081543SELECT 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 = '22514' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0028581619262695SELECT 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 = '21234' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024058818817139SELECT 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 = '22516' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0028529167175293SELECT 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 = '21407' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.00016212463378906SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00014901161193848SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00031304359436035SELECT 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 = '20894' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0017681121826172SELECT 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 = '20894' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00016212463378906SELECT * 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 = '20894' AND od.language_id = '1' ORDER BY o.sort_order
0.0001220703125SELECT 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 = 20894 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00013494491577148SELECT * 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=50' AND store_id = '0' AND language_id = '1'
0.00011587142944336SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00012516975402832SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012302398681641SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00021004676818848SELECT * FROM oc_seo_url WHERE `query` = 'product_id=20894' AND store_id = '0' AND language_id = '1'
0.00012993812561035SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013303756713867SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00032210350036621SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '21464' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0018360614776611SELECT 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 = '21464' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00015902519226074SELECT * 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 = '21464' AND od.language_id = '1' ORDER BY o.sort_order
0.00011897087097168SELECT 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 = 21464 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.00020217895507812SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=95' AND store_id = '0' AND language_id = '1'
0.00011706352233887SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00012493133544922SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001227855682373SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00025606155395508SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21464' AND store_id = '0' AND language_id = '1'
0.00013518333435059SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013303756713867SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.0003049373626709SELECT 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 = '23467' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0014698505401611SELECT 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 = '23467' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00015902519226074SELECT * 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 = '23467' AND od.language_id = '1' ORDER BY o.sort_order
0.00012087821960449SELECT 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 = 23467 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00013399124145508SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=28' AND store_id = '0' AND language_id = '1'
0.00011801719665527SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00012588500976562SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012493133544922SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00020885467529297SELECT * FROM oc_seo_url WHERE `query` = 'product_id=23467' AND store_id = '0' AND language_id = '1'
0.00012803077697754SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00021910667419434SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
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 = '22347' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0017399787902832SELECT 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 = '22347' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00016498565673828SELECT * 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 = '22347' AND od.language_id = '1' ORDER BY o.sort_order
0.00012683868408203SELECT 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 = 22347 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.00014281272888184SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00011491775512695SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00013303756713867SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012612342834473SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00027704238891602SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22347' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00018501281738281SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00032711029052734SELECT 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 = '22517' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0021529197692871SELECT 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 = '22517' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0002291202545166SELECT * 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 = '22517' AND od.language_id = '1' ORDER BY o.sort_order
0.00021195411682129SELECT 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 = 22517 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.0002129077911377SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0002601146697998SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=69' AND store_id = '0' AND language_id = '1'
0.00020289421081543SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00020194053649902SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00020503997802734SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.0001990795135498SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22517' AND store_id = '0' AND language_id = '1'
0.00020194053649902SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00020098686218262SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00036811828613281SELECT 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 = '21426' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0017850399017334SELECT 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 = '21426' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0002288818359375SELECT * 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 = '21426' AND od.language_id = '1' ORDER BY o.sort_order
0.00018787384033203SELECT 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 = 21426 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00019383430480957SELECT * 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=25' AND store_id = '0' AND language_id = '1'
0.00016689300537109SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00015687942504883SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00028800964355469SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21426' AND store_id = '0' AND language_id = '1'
0.00019311904907227SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00019478797912598SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00037002563476562SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '19305' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0020029544830322SELECT 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 = '19305' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00027918815612793SELECT * 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 = '19305' AND od.language_id = '1' ORDER BY o.sort_order
0.0002589225769043SELECT 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 = 19305 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00023913383483887SELECT * 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=32' AND store_id = '0' AND language_id = '1'
0.00017690658569336SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017809867858887SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00024199485778809SELECT * FROM oc_seo_url WHERE `query` = 'product_id=19305' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00020885467529297SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00035405158996582SELECT 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 = '20565' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0020790100097656SELECT 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 = '20565' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00021195411682129SELECT * 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 = '20565' AND od.language_id = '1' ORDER BY o.sort_order
0.00017809867858887SELECT 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 = 20565 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00019311904907227SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00024509429931641SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=32' 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.00017714500427246SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017619132995605SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00031113624572754SELECT * FROM oc_seo_url WHERE `query` = 'product_id=20565' AND store_id = '0' AND language_id = '1'
0.00026893615722656SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00026082992553711SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00043797492980957SELECT 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 = '22270' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0020730495452881SELECT 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 = '22270' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00021719932556152SELECT * 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 = '22270' AND od.language_id = '1' ORDER BY o.sort_order
0.00018906593322754SELECT 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 = 22270 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00020289421081543SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00025010108947754SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=57' AND store_id = '0' AND language_id = '1'
0.00017809867858887SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00026416778564453SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22270' AND store_id = '0' AND language_id = '1'
0.00018191337585449SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00019001960754395SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00036096572875977SELECT 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 = '20560' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0018088817596436SELECT 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 = '20560' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00022006034851074SELECT * 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 = '20560' AND od.language_id = '1' ORDER BY o.sort_order
0.00018596649169922SELECT 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 = 20560 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00017905235290527SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00024795532226562SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=32' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017380714416504SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00027012825012207SELECT * FROM oc_seo_url WHERE `query` = 'product_id=20560' AND store_id = '0' AND language_id = '1'
0.00019598007202148SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00020098686218262SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00046586990356445SELECT 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 = '19050' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.002140998840332SELECT 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 = '19050' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00022101402282715SELECT * 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 = '19050' AND od.language_id = '1' ORDER BY o.sort_order
0.00018787384033203SELECT 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 = 19050 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00024509429931641SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00030612945556641SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=32' AND store_id = '0' AND language_id = '1'
0.00024604797363281SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00020885467529297SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0002448558807373SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00015497207641602SELECT * FROM oc_seo_url WHERE `query` = 'product_id=19050' AND store_id = '0' AND language_id = '1'
0.00020694732666016SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00023794174194336SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00041699409484863SELECT 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 = '20926' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0023970603942871SELECT 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 = '20926' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0002598762512207SELECT * 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 = '20926' AND od.language_id = '1' ORDER BY o.sort_order
0.00023293495178223SELECT 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 = 20926 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00025010108947754SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00030207633972168SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=95' AND store_id = '0' AND language_id = '1'
0.00018596649169922SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00016283988952637SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00013399124145508SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00023102760314941SELECT * FROM oc_seo_url WHERE `query` = 'product_id=20926' AND store_id = '0' AND language_id = '1'
0.00014591217041016SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013995170593262SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.0003201961517334SELECT 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 = '20779' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0020060539245605SELECT 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 = '20779' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00016689300537109SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '20779' AND od.language_id = '1' ORDER BY o.sort_order
0.00013113021850586SELECT 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 = 20779 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00013995170593262SELECT * 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=70' AND store_id = '0' AND language_id = '1'
0.00012302398681641SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00012707710266113SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012779235839844SELECT * 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_id=20779' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013589859008789SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00031304359436035SELECT 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 = '19015' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0017049312591553SELECT 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 = '19015' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00016403198242188SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '19015' 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 = 19015 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00014209747314453SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00020790100097656SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=25' AND store_id = '0' AND language_id = '1'
0.00012588500976562SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00013089179992676SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00020599365234375SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00033903121948242SELECT * FROM oc_seo_url WHERE `query` = 'product_id=19015' AND store_id = '0' AND language_id = '1'
0.00014090538024902SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00014591217041016SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00031709671020508SELECT 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 = '21268' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0017449855804443SELECT 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 = '21268' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00016903877258301SELECT * 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 = '21268' 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 = 21268 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00014305114746094SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019192695617676SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=50' AND store_id = '0' AND language_id = '1'
0.00011992454528809SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00012397766113281SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012993812561035SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00019288063049316SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21268' AND store_id = '0' AND language_id = '1'
0.00012803077697754SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.0001378059387207SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00029993057250977SELECT 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 = '22348' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0015029907226562SELECT 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 = '22348' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00016117095947266SELECT * 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 = '22348' AND od.language_id = '1' ORDER BY o.sort_order
0.00012683868408203SELECT 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 = 22348 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00014305114746094SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014901161193848SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00011301040649414SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00012898445129395SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012588500976562SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00023603439331055SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22348' AND store_id = '0' AND language_id = '1'
0.00013613700866699SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00014090538024902SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00030303001403809SELECT 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 = '21457' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0017869472503662SELECT 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 = '21457' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00016403198242188SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '21457' AND od.language_id = '1' ORDER BY o.sort_order
0.00013113021850586SELECT 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 = 21457 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00014615058898926SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018596649169922SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=25' AND store_id = '0' AND language_id = '1'
0.00011801719665527SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00012803077697754SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012922286987305SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00025701522827148SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21457' AND store_id = '0' AND language_id = '1'
0.00013494491577148SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013589859008789SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00029706954956055SELECT 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 = '21427' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0014479160308838SELECT 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 = '21427' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00015902519226074SELECT * 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 = '21427' 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 = 21427 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00014591217041016SELECT * 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=25' AND store_id = '0' AND language_id = '1'
0.00011992454528809SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00012683868408203SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012397766113281SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00024795532226562SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21427' AND store_id = '0' AND language_id = '1'
0.00013995170593262SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013899803161621SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00029706954956055SELECT 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 = '20580' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0019779205322266SELECT 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 = '20580' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0001680850982666SELECT * 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 = '20580' AND od.language_id = '1' ORDER BY o.sort_order
0.00013113021850586SELECT 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 = 20580 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.00019288063049316SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=50' AND store_id = '0' AND language_id = '1'
0.00012016296386719SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00012707710266113SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012493133544922SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00022506713867188SELECT * FROM oc_seo_url WHERE `query` = 'product_id=20580' AND store_id = '0' AND language_id = '1'
0.0001380443572998SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.0001378059387207SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
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 = '20782' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.00164794921875SELECT 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 = '20782' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00015902519226074SELECT * 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 = '20782' AND od.language_id = '1' ORDER BY o.sort_order
0.00012803077697754SELECT 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 = 20782 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.00019407272338867SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=72' 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.00012707710266113SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012683868408203SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'product_id=20782' AND store_id = '0' AND language_id = '1'
0.00013613700866699SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013613700866699SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00022411346435547SELECT 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 = '24223' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.00012898445129395SELECT * 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 = '24223' AND od.language_id = '1' ORDER BY o.sort_order
0.00012016296386719SELECT 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 = 24223 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.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00011301040649414SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00013208389282227SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012516975402832SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'product_id=24223' AND store_id = '0' AND language_id = '1'
0.00013589859008789SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013589859008789SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00028204917907715SELECT 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 = '22799' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016639232635498SELECT 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 = '22799' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00016093254089355SELECT * 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 = '22799' AND od.language_id = '1' ORDER BY o.sort_order
0.00012111663818359SELECT 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 = 22799 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.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=150' AND store_id = '0' AND language_id = '1'
0.00011992454528809SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00012898445129395SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012516975402832SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00023293495178223SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22799' AND store_id = '0' AND language_id = '1'
0.00013589859008789SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013589859008789SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00029993057250977SELECT 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 = '23456' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016219615936279SELECT 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 = '23456' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0001671314239502SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '23456' 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 = 23456 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00014305114746094SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00020003318786621SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=131' AND store_id = '0' AND language_id = '1'
0.0001528263092041SELECT * 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=162' AND store_id = '0' AND language_id = '1'
0.00013113021850586SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00021982192993164SELECT * FROM oc_seo_url WHERE `query` = 'product_id=23456' AND store_id = '0' AND language_id = '1'
0.00014400482177734SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00014305114746094SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00031399726867676SELECT 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 = '23444' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0018699169158936SELECT 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 = '23444' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00017189979553223SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '23444' AND od.language_id = '1' ORDER BY o.sort_order
0.00012993812561035SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 23444 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.00019216537475586SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=56' AND store_id = '0' AND language_id = '1'
0.00012302398681641SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00012421607971191SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012898445129395SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00020599365234375SELECT * FROM oc_seo_url WHERE `query` = 'product_id=23444' AND store_id = '0' AND language_id = '1'
0.00013399124145508SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00014185905456543SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00030803680419922SELECT 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 = '20922' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016288757324219SELECT 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 = '20922' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00016021728515625SELECT * 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 = '20922' AND od.language_id = '1' ORDER BY o.sort_order
0.00012993812561035SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 20922 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00014209747314453SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=114' AND store_id = '0' AND language_id = '1'
0.00012087821960449SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00012683868408203SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012588500976562SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00021815299987793SELECT * FROM oc_seo_url WHERE `query` = 'product_id=20922' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.0001530647277832SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00031399726867676SELECT 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 = '22056' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0019500255584717SELECT 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 = '22056' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00017285346984863SELECT * 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 = '22056' AND od.language_id = '1' ORDER BY o.sort_order
0.00013184547424316SELECT 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 = 22056 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.00018906593322754SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=32' AND store_id = '0' AND language_id = '1'
0.00012111663818359SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00012588500976562SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012683868408203SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00013613700866699SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22056' AND store_id = '0' AND language_id = '1'
0.00014090538024902SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.0001370906829834SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00030016899108887SELECT 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 = '22514' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016169548034668SELECT 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 = '22514' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00016307830810547SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '22514' AND od.language_id = '1' ORDER BY o.sort_order
0.00012707710266113SELECT 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 = 22514 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.00018692016601562SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=28' AND store_id = '0' AND language_id = '1'
0.0001220703125SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00012898445129395SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012397766113281SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00012803077697754SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22514' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013279914855957SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.0003049373626709SELECT 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 = '21234' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0015568733215332SELECT 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 = '21234' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00015902519226074SELECT * 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 = '21234' AND od.language_id = '1' ORDER BY o.sort_order
0.00012993812561035SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 21234 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00014305114746094SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017118453979492SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=117' AND store_id = '0' AND language_id = '1'
0.00011897087097168SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00013399124145508SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012707710266113SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21234' AND store_id = '0' AND language_id = '1'
0.00013589859008789SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013899803161621SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00029706954956055SELECT 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 = '22516' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0017530918121338SELECT 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 = '22516' AND a.attribute_group_id = '9' 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 = '22516' AND od.language_id = '1' ORDER BY o.sort_order
0.00012397766113281SELECT 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 = 22516 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00013995170593262SELECT * 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=95' AND store_id = '0' AND language_id = '1'
0.00012302398681641SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00012707710266113SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012302398681641SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00013089179992676SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22516' AND store_id = '0' AND language_id = '1'
0.00013303756713867SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00024199485778809SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00032711029052734SELECT 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 = '21407' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016100406646729SELECT 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 = '21407' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00016689300537109SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '21407' 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 = 21407 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.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=60' AND store_id = '0' AND language_id = '1'
0.00012993812561035SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00013017654418945SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012302398681641SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00023484230041504SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21407' AND store_id = '0' AND language_id = '1'
0.0001528263092041SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012707710266113SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00020885467529297SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00015807151794434SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001218318939209SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012111663818359SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00014877319335938SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012111663818359SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001220703125SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00014591217041016SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012111663818359SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012111663818359SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00014615058898926SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00011920928955078SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00011992454528809SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00014591217041016SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001218318939209SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012302398681641SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00011920928955078SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00011897087097168SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.00011706352233887SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012111663818359SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00011897087097168SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012111663818359SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012302398681641SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00011992454528809SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.0001218318939209SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012111663818359SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00014305114746094SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00011706352233887SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012016296386719SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.00011801719665527SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001220703125SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.00011587142944336SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012302398681641SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00014901161193848SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012111663818359SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00011992454528809SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00014591217041016SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012803077697754SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001227855682373SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.00012302398681641SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00033998489379883SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019288063049316SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00015521049499512SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.0002748966217041SELECT * 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=162' AND store_id = '0' AND language_id = '1'
0.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.00018692016601562SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018882751464844SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00025200843811035SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001828670501709SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00015878677368164SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00022697448730469SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016212463378906SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00022697448730469SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00015497207641602SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001530647277832SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.00015592575073242SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00015401840209961SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00020384788513184SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017285346984863SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001518726348877SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.0001680850982666SELECT * 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` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00023508071899414SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00014209747314453SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00022411346435547SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014519691467285SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016689300537109SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00025391578674316SELECT * 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=162' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.00020003318786621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00022697448730469SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00015497207641602SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00022101402282715SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00013208389282227SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00015902519226074SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.0002140998840332SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017690658569336SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00025415420532227SELECT * 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=162' AND store_id = '0' AND language_id = '1'
0.00018215179443359SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00023388862609863SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001988410949707SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017905235290527SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00024580955505371SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016117095947266SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018715858459473SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00021910667419434SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00022602081298828SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00015687942504883SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00022602081298828SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00015783309936523SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00021481513977051SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017380714416504SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001380443572998SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00019621849060059SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012898445129395SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.00013089179992676SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00012683868408203SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.0002291202545166SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001978874206543SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.0002448558807373SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017380714416504SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016188621520996SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.0002291202545166SELECT * FROM oc_seo_url WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_category_to_layout WHERE category_id = '178' AND store_id = '0'
0.00020003318786621SELECT * FROM oc_layout_module WHERE layout_id = '145' AND position = 'column_left' ORDER BY sort_order
0.00020098686218262SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/bsfilter' OR route = 'ru-ru')
0.39337110519409SELECT MIN(`min`) AS `min`, MAX(`max`) AS `max` FROM (SELECT product_id, LEAST(price, discount_special, MIN(option_price)) AS `min`, GREATEST(price, discount_special, MAX(option_price)) AS `max` FROM (SELECT p.product_id, p.price, COALESCE(IF(pov.price_prefix = '-', p.price - pov.price, NULL), IF(pov.price_prefix = '+', p.price + pov.price, NULL), IF(pov.price_prefix = '*', p.price + p.price * pov.price, NULL), IF(pov.price_prefix = '%', p.price + p.price * (pov.price / 100), NULL), IF(pov.price_prefix = '=', pov.price, NULL), p.price + pov.price, p.price) AS option_price, COALESCE((SELECT MIN(pd.price) FROM oc_product_discount pd WHERE pd.product_id = p.product_id AND pd.customer_group_id = '1' AND pd.quantity > '0' AND ((pd.date_start = '0000-00-00' OR pd.date_start < '2024-04-18') AND (pd.date_end = '0000-00-00' OR pd.date_end > '2024-04-18'))), (SELECT MIN(ps.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 < '2024-04-18') AND (ps.date_end = '0000-00-00' OR ps.date_end > '2024-04-18'))), p.price) AS discount_special FROM oc_product p LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_product_option_value pov ON (p.product_id = pov.product_id) WHERE p2s.store_id = '0' AND p.status = '1' AND p.price > '0' AND p2c.category_id = '178' AND p.date_available <= '2024-04-18') prices GROUP BY product_id) results
0.00033092498779297SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018215179443359SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00020003318786621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00024700164794922SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015902519226074SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.0002131462097168SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018692016601562SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.00019192695617676SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018811225891113SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.00018620491027832SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019502639770508SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00021696090698242SELECT * 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=162' AND store_id = '0' AND language_id = '1'
0.00018787384033203SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019121170043945SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019121170043945SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00017690658569336SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016689300537109SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00020003318786621SELECT * 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=162' AND store_id = '0' AND language_id = '1'
0.0001680850982666SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.00014281272888184SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00015807151794434SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.0001990795135498SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00020718574523926SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00019192695617676SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019288063049316SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001990795135498SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.0001981258392334SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00020194053649902SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.0001981258392334SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.00019598007202148SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0002129077911377SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00023984909057617SELECT * 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=162' AND store_id = '0' AND language_id = '1'
0.00020003318786621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.00017905235290527SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00015020370483398SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00023221969604492SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017619132995605SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.00016188621520996SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00021100044250488SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017690658569336SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017285346984863SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00020384788513184SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017619132995605SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00020909309387207SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020909309387207SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00020694732666016SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00022101402282715SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019407272338867SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019502639770508SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00022506713867188SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019192695617676SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019502639770508SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00022578239440918SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019288063049316SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019598007202148SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.00019693374633789SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019383430480957SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00022506713867188SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019216537475586SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019502639770508SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.00019192695617676SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019502639770508SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00022792816162109SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001978874206543SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019621849060059SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00022983551025391SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019311904907227SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019407272338867SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020694732666016SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001978874206543SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001990795135498SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.0021350383758545SELECT * 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.00023794174194336SELECT * 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=172' AND store_id = '0' AND language_id = '1'
0.015525102615356SELECT 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.00026082992553711SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0002291202545166SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' AND store_id = '0' AND language_id = '1'
0.014161109924316SELECT 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.00029420852661133SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00022602081298828SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.028589963912964SELECT 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.00028896331787109SELECT * 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=230' AND store_id = '0' AND language_id = '1'
0.0158371925354SELECT 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.00028586387634277SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00022602081298828SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.018978118896484SELECT 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.00029611587524414SELECT * 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=205' AND store_id = '0' AND language_id = '1'
0.014286994934082SELECT 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.00028395652770996SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00028395652770996SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.013504028320312SELECT 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.0022258758544922SELECT * 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.00028395652770996SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00022101402282715SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00026512145996094SELECT * FROM oc_seo_url WHERE `query` = 'category_id=346' AND store_id = '0' AND language_id = '1'
0.016154050827026SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '346'
0.00028896331787109SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00022983551025391SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00026297569274902SELECT * FROM oc_seo_url WHERE `query` = 'category_id=347' AND store_id = '0' AND language_id = '1'
0.012768030166626SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '347'
0.00024604797363281SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00021696090698242SELECT * FROM oc_seo_url WHERE `query` = 'category_id=348' AND store_id = '0' AND language_id = '1'
0.012862920761108SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '348'
0.00028300285339355SELECT * 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=162' AND store_id = '0' AND language_id = '1'
0.00021505355834961SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.014595031738281SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '178'
0.00025105476379395SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018215179443359SELECT * FROM oc_seo_url WHERE `query` = 'category_id=111' AND store_id = '0' AND language_id = '1'
0.013181924819946SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '111'
0.0002140998840332SELECT * 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=162' AND store_id = '0' AND language_id = '1'
0.019022941589355SELECT 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.0002131462097168SELECT * 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=221' AND store_id = '0' AND language_id = '1'
0.012713193893433SELECT 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.00020122528076172SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'extension/module/bsfilter'
0.00016283988952637SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/category_description' OR route = 'ru-ru')
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 = '162' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
0.00018215179443359SELECT 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 = '178' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
0.0018408298492432SELECT * 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.00020599365234375SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'extension/module/category_description'
0.00017809867858887SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/column_left'
0.0001521110534668SELECT * FROM oc_category_to_layout WHERE category_id = '178' AND store_id = '0'
0.00016999244689941SELECT * FROM oc_layout_module WHERE layout_id = '145' AND position = 'column_right' ORDER BY sort_order
0.00017094612121582SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/column_right'
0.0001370906829834SELECT * FROM oc_category_to_layout WHERE category_id = '178' AND store_id = '0'
0.00014591217041016SELECT * FROM oc_layout_module WHERE layout_id = '145' AND position = 'content_top' ORDER BY sort_order
0.00016403198242188SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/content_top'
0.00014591217041016SELECT * FROM oc_category_to_layout WHERE category_id = '178' AND store_id = '0'
0.00015997886657715SELECT * FROM oc_layout_module WHERE layout_id = '145' AND position = 'content_bottom' ORDER BY sort_order
0.00022006034851074SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/content_bottom'
0.0001981258392334SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru')
0.00018787384033203SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/social' OR route = 'ru-ru')
0.00021910667419434SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'extension/module/social_icons'
0.00018715858459473SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')
0.00020408630371094SELECT * FROM oc_seo_url WHERE `query` = 'common/language/language' AND store_id = '0' AND language_id = '1'
0.00015616416931152SELECT * FROM oc_language WHERE status = '1' ORDER BY sort_order, name
0.00021696090698242SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016689300537109SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00018692016601562SELECT * 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.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'common/currency/currency' AND store_id = '0' AND language_id = '1'
0.00021195411682129SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013399124145508SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018191337585449SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00018906593322754SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/currency'
0.0021340847015381SELECT * 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.00022101402282715SELECT * 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=172' AND store_id = '0' AND language_id = '1'
0.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018906593322754SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' AND store_id = '0' AND language_id = '1'
0.00020003318786621SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012588500976562SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00019598007202148SELECT * 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=230' 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.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00019693374633789SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'category_id=205' AND store_id = '0' AND language_id = '1'
0.00019598007202148SELECT * 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=396' AND store_id = '0' AND language_id = '1'
0.00019979476928711SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019693374633789SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'category_id=221' AND store_id = '0' AND language_id = '1'
0.001643180847168SELECT * 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.00017976760864258SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00017786026000977SELECT * FROM oc_seo_url WHERE `query` = 'information_id=67' AND store_id = '0' AND language_id = '1'
0.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'information_id=77' AND store_id = '0' AND language_id = '1'
0.00016212463378906SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'information_id=68' AND store_id = '0' AND language_id = '1'
0.00016188621520996SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00017213821411133SELECT * FROM oc_seo_url WHERE `query` = 'information_id=73' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00016689300537109SELECT * FROM oc_seo_url WHERE `query` = 'information_id=64' AND store_id = '0' AND language_id = '1'
0.00016212463378906SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'information_id=66' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.0001678466796875SELECT * FROM oc_seo_url WHERE `query` = 'information_id=65' AND store_id = '0' AND language_id = '1'
0.00016880035400391SELECT * FROM oc_seo_url WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '1'
0.00011205673217773SELECT * FROM oc_seo_url WHERE `query` = 'account/return/add' AND store_id = '0' AND language_id = '1'
0.00019693374633789SELECT * FROM oc_seo_url WHERE `query` = 'information/sitemap' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'information/tracking' AND store_id = '0' AND language_id = '1'
0.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer' AND store_id = '0' AND language_id = '1'
0.00014901161193848SELECT * FROM oc_seo_url WHERE `query` = 'account/voucher' AND store_id = '0' AND language_id = '1'
0.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'affiliate/login' AND store_id = '0' AND language_id = '1'
0.00014591217041016SELECT * FROM oc_seo_url WHERE `query` = 'product/special' AND store_id = '0' AND language_id = '1'
0.00014185905456543SELECT * FROM oc_seo_url WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'account/order' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * FROM oc_seo_url WHERE `query` = 'account/wishlist' AND store_id = '0' AND language_id = '1'
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'account/newsletter' AND store_id = '0' AND language_id = '1'
0.00014710426330566SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'theme/bodysport' OR route = 'ru-ru')
0.00014090538024902SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/subscribe' OR route = 'ru-ru')
0.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'
0.00021004676818848DELETE FROM `oc_customer_online` WHERE date_added < '2024-04-18 21:59:44'
0.00015377998352051REPLACE INTO `oc_customer_online` SET `ip` = '3.144.187.103', `customer_id` = '0', `url` = 'https://ndplay.ru/prazdnik/podarochnaya-upakovka?page=3', `referer` = '', `date_added` = '2024-04-18 22:59:44'
0.00017189979553223SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/footer'
0.00020003318786621SELECT * FROM oc_extension WHERE `type` = 'analytics'
0.00023293495178223SELECT * FROM oc_seo_url WHERE `query` = 'style/setting' AND store_id = '0' AND language_id = '1'
0.00022602081298828SELECT * FROM oc_seo_url WHERE `query` = 'style/setting' AND store_id = '0' AND language_id = '1'
0.00019693374633789SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
0.00021481513977051SELECT * FROM oc_seo_url WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
0.0002140998840332SELECT * FROM oc_seo_url WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'
0.00024700164794922SELECT * FROM oc_seo_url WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'
0.00022196769714355SELECT * FROM oc_seo_url WHERE `query` = 'account/wishlist' AND store_id = '0' AND language_id = '1'
0.00021505355834961SELECT * FROM oc_seo_url WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
0.00023317337036133SELECT * FROM oc_seo_url WHERE `query` = 'account/register' AND store_id = '0' AND language_id = '1'
0.0002140998840332SELECT * FROM oc_seo_url WHERE `query` = 'account/login' AND store_id = '0' AND language_id = '1'
0.00021195411682129SELECT * FROM oc_seo_url WHERE `query` = 'account/order' AND store_id = '0' AND language_id = '1'
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'account/transaction' AND store_id = '0' AND language_id = '1'
0.00021219253540039SELECT * FROM oc_seo_url WHERE `query` = 'account/download' AND store_id = '0' AND language_id = '1'
0.0002131462097168SELECT * FROM oc_seo_url WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'
0.00024604797363281SELECT * FROM oc_seo_url WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'
0.00025200843811035SELECT * FROM oc_seo_url WHERE `query` = 'checkout/checkout' AND store_id = '0' AND language_id = '1'
0.00024294853210449SELECT * FROM oc_seo_url WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '1'
0.00022697448730469SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/text_loading'
0.00022101402282715SELECT * FROM oc_seo_url WHERE `query` = 'account/edit' AND store_id = '0' AND language_id = '1'
0.0002131462097168SELECT * FROM oc_seo_url WHERE `query` = 'account/address' AND store_id = '0' AND language_id = '1'
0.00022006034851074SELECT * FROM oc_seo_url WHERE `query` = 'account/reward' AND store_id = '0' AND language_id = '1'
0.00021982192993164SELECT * FROM oc_seo_url WHERE `query` = 'account/return' AND store_id = '0' AND language_id = '1'
0.00026798248291016SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')
0.00023603439331055SELECT * FROM oc_seo_url WHERE `query` = 'common/language/language' AND store_id = '0' AND language_id = '1'
0.00018596649169922SELECT * FROM oc_language WHERE status = '1' ORDER BY sort_order, name
0.00023913383483887SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020408630371094SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00020408630371094SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00020503997802734SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/language'
0.00018000602722168SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
0.00016689300537109SELECT * FROM oc_seo_url WHERE `query` = 'common/currency/currency' AND store_id = '0' AND language_id = '1'
0.00021886825561523SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019383430480957SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001981258392334SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.0001988410949707SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/currency'
0.00024199485778809SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru')
0.00019216537475586SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/search'
0.00017714500427246SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')
0.00022697448730469SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00017690658569336SELECT * FROM oc_extension WHERE `type` = 'total'
0.00017499923706055SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru')
0.00017499923706055SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00018596649169922SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00017690658569336SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/credit' OR route = 'ru-ru')
0.00015401840209961SELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0'
0.00017094612121582SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru')
0.00012612342834473SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00017285346984863SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'dad73f521d72894a16f5c72573'
0.00022506713867188SELECT * FROM oc_seo_url WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'
0.00021791458129883SELECT * FROM oc_seo_url WHERE `query` = 'checkout/checkout' AND store_id = '0' AND language_id = '1'
0.00020003318786621SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/cart'
0.00017309188842773SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/menu' OR route = 'ru-ru')
0.0021240711212158SELECT * 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.0015890598297119SELECT * 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.00024199485778809SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020194053649902SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00020790100097656SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' 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.00014591217041016SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'category_id=117' 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.00018310546875SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00018787384033203SELECT * FROM oc_seo_url WHERE `query` = 'category_id=195' AND store_id = '0' AND language_id = '1'
0.00020408630371094SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.0001988410949707SELECT * FROM oc_seo_url WHERE `query` = 'category_id=238' AND store_id = '0' AND language_id = '1'
0.00020599365234375SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001828670501709SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.000244140625SELECT * FROM oc_seo_url WHERE `query` = 'category_id=68' AND store_id = '0' AND language_id = '1'
0.00020408630371094SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00020194053649902SELECT * FROM oc_seo_url WHERE `query` = 'category_id=242' 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.00016093254089355SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'category_id=245' 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.00016117095947266SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'category_id=204' AND store_id = '0' AND language_id = '1'
0.00018191337585449SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.0015029907226562SELECT * 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.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018191337585449SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' AND store_id = '0' AND language_id = '1'
0.00022482872009277SELECT * FROM oc_seo_url WHERE `query` = 'category_id=389' 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.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'category_id=210' AND store_id = '0' AND language_id = '1'
0.0001838207244873SELECT * 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=223' AND store_id = '0' AND language_id = '1'
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'category_id=371' 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.00017189979553223SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' AND store_id = '0' AND language_id = '1'
0.001896858215332SELECT * 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.00020480155944824SELECT * 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.00018596649169922SELECT * FROM oc_seo_url WHERE `query` = 'category_id=252' 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.00014185905456543SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00019192695617676SELECT * FROM oc_seo_url WHERE `query` = 'category_id=259' 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.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00019288063049316SELECT * FROM oc_seo_url WHERE `query` = 'category_id=298' 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.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'category_id=289' 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.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00021505355834961SELECT * FROM oc_seo_url WHERE `query` = 'category_id=364' 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.00016212463378906SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.0017490386962891SELECT * 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.00020098686218262SELECT * 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.00025510787963867SELECT * FROM oc_seo_url WHERE `query` = 'category_id=227' 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.00017905235290527SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00019502639770508SELECT * FROM oc_seo_url WHERE `query` = 'category_id=301' 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.00017619132995605SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00019311904907227SELECT * FROM oc_seo_url WHERE `query` = 'category_id=300' 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.00015401840209961SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'category_id=250' 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.00017714500427246SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.0001828670501709SELECT * FROM oc_seo_url WHERE `query` = 'category_id=256' 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.00017786026000977SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00019598007202148SELECT * FROM oc_seo_url WHERE `query` = 'category_id=305' 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.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.0015687942504883SELECT * 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.00021696090698242SELECT * 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=20' AND store_id = '0' AND language_id = '1'
0.00022697448730469SELECT * FROM oc_seo_url WHERE `query` = 'category_id=65' AND store_id = '0' AND language_id = '1'
0.00018978118896484SELECT * 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=20' AND store_id = '0' AND language_id = '1'
0.00020194053649902SELECT * FROM oc_seo_url WHERE `query` = 'category_id=326' 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.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00021195411682129SELECT * FROM oc_seo_url WHERE `query` = 'category_id=185' 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.00019311904907227SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00022315979003906SELECT * FROM oc_seo_url WHERE `query` = 'category_id=327' 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.00018310546875SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00020813941955566SELECT * FROM oc_seo_url WHERE `query` = 'category_id=345' 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.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.0019359588623047SELECT * 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.00023889541625977SELECT * 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=205' AND store_id = '0' AND language_id = '1'
0.00022101402282715SELECT * FROM oc_seo_url WHERE `query` = 'category_id=370' 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.00014710426330566SELECT * 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` = '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.0001680850982666SELECT * FROM oc_seo_url WHERE `query` = 'category_id=205' AND store_id = '0' AND language_id = '1'
0.0016582012176514SELECT * 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.00020194053649902SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00026297569274902SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.00023508071899414SELECT * FROM oc_seo_url WHERE `query` = 'category_id=397' 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.00022697448730469SELECT * 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=398' 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.00022506713867188SELECT * 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=399' AND store_id = '0' AND language_id = '1'
0.00021815299987793SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00022506713867188SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.00022411346435547SELECT * FROM oc_seo_url WHERE `query` = 'category_id=400' AND store_id = '0' AND language_id = '1'
0.00021719932556152SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00028109550476074SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.0020599365234375SELECT * 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.00023484230041504SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020003318786621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0002601146697998SELECT * FROM oc_seo_url WHERE `query` = 'category_id=346' 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.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00021100044250488SELECT * FROM oc_seo_url WHERE `query` = 'category_id=347' AND store_id = '0' AND language_id = '1'
0.00019407272338867SELECT * 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=162' AND store_id = '0' AND language_id = '1'
0.00025200843811035SELECT * FROM oc_seo_url WHERE `query` = 'category_id=348' 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.00017189979553223SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00020384788513184SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' 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.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016188621520996SELECT * FROM oc_seo_url WHERE `query` = 'category_id=111' 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.00015902519226074SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0017549991607666SELECT * 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.00021004676818848SELECT * 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=221' AND store_id = '0' AND language_id = '1'
0.00024199485778809SELECT * FROM oc_seo_url WHERE `query` = 'category_id=394' AND store_id = '0' AND language_id = '1'
0.00024509429931641SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001988410949707SELECT * FROM oc_seo_url WHERE `query` = 'category_id=221' AND store_id = '0' AND language_id = '1'
0.00017905235290527SELECT * FROM oc_seo_url WHERE `query` = 'category_id=222' AND store_id = '0' AND language_id = '1'
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018310546875SELECT * 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.00015997886657715SELECT * 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=221' AND store_id = '0' AND language_id = '1'
0.00018906593322754SELECT * FROM oc_seo_url WHERE `query` = 'product/catalog' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/menu'
0.00015807151794434SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/brands' OR route = 'ru-ru')
0.00016403198242188SELECT * 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=120' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * 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=147' AND store_id = '0' AND language_id = '1'
0.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=142' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00021004676818848SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=32' 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.00020003318786621SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=113' 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.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=177' 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.00022006034851074SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=114' 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.00019288063049316SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=140' 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.00018811225891113SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=121' 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=163' AND store_id = '0' AND language_id = '1'
0.00014615058898926SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018692016601562SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=123' AND store_id = '0' AND language_id = '1'
0.00018215179443359SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00020194053649902SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=18' AND store_id = '0' AND language_id = '1'
0.00014591217041016SELECT * 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=132' AND store_id = '0' AND language_id = '1'
0.0001678466796875SELECT * 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=158' 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.00021100044250488SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=61' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00021481513977051SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=33' 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.00020909309387207SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=73' AND store_id = '0' AND language_id = '1'
0.00014781951904297SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0002448558807373SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=74' AND store_id = '0' AND language_id = '1'
0.00014781951904297SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00020194053649902SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=173' 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=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.00020408630371094SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=26' AND store_id = '0' AND language_id = '1'
0.00014591217041016SELECT * 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=75' 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.00022196769714355SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=65' 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.00020503997802734SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=48' 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.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=164' 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.0001678466796875SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=124' AND store_id = '0' AND language_id = '1'
0.00012302398681641SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017809867858887SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=175' AND store_id = '0' AND language_id = '1'
0.00013184547424316SELECT * 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=76' 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.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=168' AND store_id = '0' AND language_id = '1'
0.00012302398681641SELECT * 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=166' 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.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=125' 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.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=49' 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.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=167' AND store_id = '0' AND language_id = '1'
0.00012588500976562SELECT * 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=146' 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.00020813941955566SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=77' 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.00019121170043945SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=78' AND store_id = '0' AND language_id = '1'
9.7990036010742E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014281272888184SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=133' AND store_id = '0' AND language_id = '1'
9.8943710327148E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017619132995605SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=116' AND store_id = '0' AND language_id = '1'
9.7990036010742E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014710426330566SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=155' AND store_id = '0' AND language_id = '1'
9.7990036010742E-5SELECT * 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=111' AND store_id = '0' AND language_id = '1'
9.7990036010742E-5SELECT * 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=79' AND store_id = '0' AND language_id = '1'
9.8943710327148E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014281272888184SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=136' AND store_id = '0' AND language_id = '1'
9.7990036010742E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=176' AND store_id = '0' AND language_id = '1'
9.8943710327148E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017714500427246SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=131' AND store_id = '0' AND language_id = '1'
9.9897384643555E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015115737915039SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=169' AND store_id = '0' AND language_id = '1'
9.7990036010742E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014901161193848SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=165' AND store_id = '0' AND language_id = '1'
9.918212890625E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0002589225769043SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=80' AND store_id = '0' AND language_id = '1'
9.8943710327148E-5SELECT * 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=128' AND store_id = '0' AND language_id = '1'
9.8943710327148E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001521110534668SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=25' AND store_id = '0' AND language_id = '1'
0.00011682510375977SELECT * 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=115' AND store_id = '0' AND language_id = '1'
9.918212890625E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016689300537109SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=81' AND store_id = '0' AND language_id = '1'
9.7990036010742E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001518726348877SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=22' 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.00015783309936523SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=57' AND store_id = '0' AND language_id = '1'
9.7990036010742E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015497207641602SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=50' AND store_id = '0' AND language_id = '1'
0.00010108947753906SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=141' 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.0001518726348877SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=29' AND store_id = '0' AND language_id = '1'
9.7990036010742E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=82' AND store_id = '0' AND language_id = '1'
9.8943710327148E-5SELECT * 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=109' 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.00013494491577148SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=110' AND store_id = '0' AND language_id = '1'
9.7990036010742E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=83' AND store_id = '0' AND language_id = '1'
9.7036361694336E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=84' AND store_id = '0' AND language_id = '1'
0.00011301040649414SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014710426330566SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=143' AND store_id = '0' AND language_id = '1'
0.00010013580322266SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001370906829834SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=112' AND store_id = '0' AND language_id = '1'
9.7036361694336E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=85' AND store_id = '0' AND language_id = '1'
0.00010204315185547SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014591217041016SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=150' AND store_id = '0' AND language_id = '1'
9.7990036010742E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=86' AND store_id = '0' AND language_id = '1'
0.00010013580322266SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=51' AND store_id = '0' AND language_id = '1'
0.00010013580322266SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015807151794434SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=60' AND store_id = '0' AND language_id = '1'
9.918212890625E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=87' AND store_id = '0' AND language_id = '1'
9.7990036010742E-5SELECT * 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=88' AND store_id = '0' AND language_id = '1'
0.00010085105895996SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00013208389282227SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=101' AND store_id = '0' AND language_id = '1'
9.918212890625E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016093254089355SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=72' AND store_id = '0' AND language_id = '1'
9.7990036010742E-5SELECT * 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=89' AND store_id = '0' AND language_id = '1'
9.8943710327148E-5SELECT * 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=90' AND store_id = '0' AND language_id = '1'
9.918212890625E-5SELECT * 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=52' AND store_id = '0' AND language_id = '1'
9.7990036010742E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014019012451172SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=117' AND store_id = '0' AND language_id = '1'
9.7990036010742E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014996528625488SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=172' AND store_id = '0' AND language_id = '1'
9.9897384643555E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015711784362793SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=58' AND store_id = '0' AND language_id = '1'
9.8943710327148E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017189979553223SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=91' AND store_id = '0' AND language_id = '1'
9.7990036010742E-5SELECT * 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=97' AND store_id = '0' AND language_id = '1'
9.9897384643555E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001380443572998SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=119' AND store_id = '0' AND language_id = '1'
9.7990036010742E-5SELECT * 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=55' AND store_id = '0' AND language_id = '1'
9.7990036010742E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015401840209961SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=28' AND store_id = '0' AND language_id = '1'
9.8943710327148E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015878677368164SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=70' AND store_id = '0' AND language_id = '1'
9.7036361694336E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017023086547852SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=92' AND store_id = '0' AND language_id = '1'
9.8943710327148E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=170' AND store_id = '0' AND language_id = '1'
9.8943710327148E-5SELECT * 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=56' AND store_id = '0' AND language_id = '1'
9.7990036010742E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001680850982666SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=93' AND store_id = '0' AND language_id = '1'
9.9897384643555E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001680850982666SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=94' AND store_id = '0' AND language_id = '1'
9.7990036010742E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=95' AND store_id = '0' AND language_id = '1'
9.7990036010742E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017309188842773SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=96' AND store_id = '0' AND language_id = '1'
9.7990036010742E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=69' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/brands'
0.0001368522644043SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00013613700866699SELECT * FROM oc_seo_url WHERE `query` = 'information_id=64' AND store_id = '0' AND language_id = '1'
0.00012612342834473SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00013399124145508SELECT * FROM oc_seo_url WHERE `query` = 'information_id=65' AND store_id = '0' AND language_id = '1'
0.00012302398681641SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'extension/module/menu'
0.00015401840209961SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/quicksignup' OR route = 'ru-ru')
0.0001678466796875SELECT * FROM oc_seo_url WHERE `query` = 'account/edit' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'account/register' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'account/login' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'account/forgotten' AND store_id = '0' AND language_id = '1'
0.00017213821411133SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/quicksignup'
0.00017499923706055SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/header'
0.0002589225769043SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'product/category'