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 от 18р. до 1979р.
Пн-Пт с 10:00 до 19:00, Сб-Вс - выходной

Посуда от 18р. до 1979р.

Бутылка пластиковая (спортивная, эргономичная, 400 мл). Холодное сердце 2 Синий лес

Пластиковая бутылка для воды «Холодное сердце 2 Синий лес» объемом 400 мл станет подходящим подарком..

нет отзывов

230р.

Бутылка пластиковая (спортивная, эрогономичная, 400 мл). Микки Маус Акварель

Бутылка для воды спортивная детская (объём 400 мл) оливкового цвета для тех, кто любит Микки Мауса! ..

нет отзывов

298р.

Кружка керамическая (220 мл). Миньоны

Оригинальная керамическая кружка от компании Stor не оставит равнодушным вашего ребенка, ведь на ее ..

нет отзывов

159р.

Кружка керамическая (325 мл). Миньоны Один

Детская кружка "Миньоны. Один" из качественной керамики – отличное дополнение в коллекцию и прекрасн..

нет отзывов

180р.

Кружка керамическая в подарочной упаковке (325 мл). Звездные Войны Армия штурмовиков

Оригинальная керамическая кружка от компании Stor не оставит равнодушным вашего ребенка, ведь на ее ..

нет отзывов

336р.

Кружка керамическая в подарочной упаковке (325 мл). Тачки Нитро

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

нет отзывов

336р.

Кружка пластиковая (для СВЧ, 265 мл). Микки Маус Акварель

Кружка "Микки Маус. Акварель" - отличный подарок всем поклонникам приключений героев популярного мул..

нет отзывов

209р.

Кружка пластиковая (для СВЧ, 265 мл). Холодное сердце. Радужная вода

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

нет отзывов

174р.

Кружка пластиковая (для СВЧ, 350 мл). Покемон

Кружка "Покемон" - отличный подарок всем поклонникам приключений героев популярного мультфильма! Кру..

нет отзывов

245р.

Миска пластиковая с ручками (для СВЧ). Микки Маус Символы

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

нет отзывов

179р.

Миска пластиковая. Hello Kitty

Красивая и прочная тарелка "Hello Kitty" с изображением любимых героев идеальна для закусок, вторых ..

нет отзывов

159р.

Миска пластиковая. Минни Маус Цветы

Детская пластиковая тарелка с изображением Минни Маус - легкая, прочная и красивая – поможет привлеч..

нет отзывов

159р.

Стакан пластиковый (260 мл). Num Noms

Детский стакан "Num Noms" - отличное дополнение в коллекцию и прекрасный подарок для всех любителей ..

нет отзывов

72р.

Стакан пластиковый (260 мл). Холодное сердце 2 Синий лес

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

нет отзывов

75р.

Стакан пластиковый с соломинкой и крышкой (спортивный, 430 мл). Минни Хорошее настроение

Стакан с трубочкой и крышкой «Минни. Хорошее настроение» − яркий и практичный подарок для любительни..

нет отзывов

233р.

Бутылка пластиковая (спортивная 530 мл). Бэтмэн

Оригинальная бутылка для воды «Бэтмен» объемом 530 мл станет подходящим подарком для фанатов популяр..

нет отзывов

242р.

Кружка керамическая (220 мл). Принцессы и их питомцы

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

нет отзывов

159р.

Кружка керамическая (№3, 220 мл). Принцессы

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

нет отзывов

159р.

Кружка керамическая в подарочной упаковке (220 мл). Звездные Войны Последние джедаи

Детская кружка "Звездные Войны. Последние джедаи" из качественной керамики в подарочной упаковке – о..

нет отзывов

170р.

Кружка керамическая в подарочной упаковке (220 мл). Холодное сердце Олаф и Свен

Оригинальная керамическая кружка от компании Stor не оставит равнодушным вашего ребенка, ведь на ее ..

нет отзывов

170р.

Кружка пластиковая (для СВЧ, 265 мл). Принцессы Дружные приключения

Оригинальная пластиковая кружка от компании Stor не оставит равнодушным вашего ребенка, ведь на..

нет отзывов

174р.

Кружка пластиковая (для СВЧ, 350 мл). Холодное сердце 2

Кружка "Холодное сердце 2" с изображением персонажа популярного мультфильма – оригинальный и практич..

нет отзывов

245р.

Ланч-бокс пластиковый (17х14х5,6). Минни Хорошее настроение

Пластиковый ланч-бокс «Минни Хорошее настроение» идеально подходит для бутербродов, фруктов, ягод и ..

нет отзывов

284р.

Миска пластиковая. Микки Маус Символы

Детская пластиковая тарелка с изображением Микки Мауса - легкая, прочная и красивая – поможет привле..

нет отзывов

159р.

Миска пластиковая. Человек-паук Красная паутина

Детская тарелка "Человек-паук. Красная паутина" с изображением супергероя из популярного мультфильма..

нет отзывов

159р.

Подставка пластиковая под посуду (фигурная, с 3D изображением). Человек-паук Граффити

Пластиковая подставка под посуду с изображением персонажей мультфильма «Человек-паук» не только для ..

нет отзывов

215р.

Стакан пластиковый (260 мл). Свинка Пеппа

Детский стакан "Свинка Пеппа" - отличное дополнение в коллекцию и прекрасный подарок для всех любите..

нет отзывов

86р.

Кружка керамическая (220 мл). Свинка Пеппа и Дино

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

нет отзывов

228р.

Кружка керамическая в подарочной упаковке (325 мл). Эмодзи лица

Детская кружка "Эмодзи лица" из качественной керамики в яркой брендированной подарочной упаковке – г..

нет отзывов

200р.

Кружка керамическая в подарочной упаковке (№2, 325 мл). Мстители

Детская кружка "Мстители" из качественной керамики в подарочной упаковке – отличное дополнение в кол..

нет отзывов

336р.

Debug SQL
0.00022101402282715SELECT `data` FROM `oc_session` WHERE session_id = 'df62626926aa82f651b183ec0b' AND expire > 1713475489
0.0002748966217041SELECT * FROM oc_extension WHERE `type` = 'openbay'
0.0001838207244873SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
0.00015807151794434SELECT * FROM oc_extension WHERE `type` = 'openbay'
0.0001680850982666SELECT `data` FROM `oc_session` WHERE session_id = 'cc705687a6ed658fee57d460d9' AND expire > 1713475489
0.00014591217041016SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://ndplay.ru/'
0.0019090175628662SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
0.00017189979553223SELECT * FROM oc_language WHERE status = '1' ORDER BY sort_order, name
0.00016307830810547SELECT * FROM oc_currency
0.00035786628723145SELECT 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.00035810470581055SELECT 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.00018000602722168SELECT * 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.00017309188842773SELECT * 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.0039050579071045DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
0.00020098686218262SELECT * FROM oc_extension WHERE `type` = 'openbay'
0.0036900043487549SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC
0.00020718574523926SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/bsfilter' OR route = 'ru-ru')
0.00041699409484863SELECT GROUP_CONCAT(REPLACE(`query`, 'category_id=', '') ORDER BY FIELD(keyword, 'posuda', 'price', '18-1979', '10018', '10340') SEPARATOR '_') AS path FROM oc_seo_url WHERE `query` LIKE 'category_id=%' AND (keyword = 'posuda' OR keyword = 'price' OR keyword = '18-1979' OR keyword = '10018' OR keyword = '10340')
0.00016903877258301SELECT * FROM oc_bsfilter_page WHERE status = '1' AND keyword = 'posuda' LIMIT 1
0.00016093254089355SELECT * FROM oc_bsfilter_page WHERE status = '1' AND keyword = 'price' LIMIT 1
0.00016403198242188SELECT * FROM oc_bsfilter_page WHERE status = '1' AND keyword = '18-1979' LIMIT 1
0.00016379356384277SELECT * FROM oc_bsfilter_page WHERE status = '1' AND keyword = '10018' LIMIT 1
0.00015997886657715SELECT * FROM oc_bsfilter_page WHERE status = '1' AND keyword = '10340' LIMIT 1
0.22317504882812SELECT value_id, option_id, total FROM (SELECT p.manufacturer_id AS value_id, 'm' AS option_id, COUNT(p.manufacturer_id) AS total FROM oc_product p LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p2c.category_id = '18' AND (p.price BETWEEN '18' AND '1979' OR EXISTS (SELECT pd.product_id 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')) AND pd.price BETWEEN '18' AND '1979') OR EXISTS (SELECT ps.product_id 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')) AND ps.price BETWEEN '18' AND '1979')) AND p.product_id IN(SELECT oov2p1.product_id FROM oc_bsfilter_option_value_to_product oov2p1 WHERE oov2p1.option_id = '10018' AND (oov2p1.value_id = '10340')) GROUP BY p.manufacturer_id UNION ALL SELECT p.stock_status_id AS value_id, 's' AS option_id, COUNT(p.stock_status_id) AS total FROM oc_product p LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) WHERE p.status = '1' AND p2c.category_id = '18' AND (p.price BETWEEN '18' AND '1979' OR EXISTS (SELECT pd.product_id 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')) AND pd.price BETWEEN '18' AND '1979') OR EXISTS (SELECT ps.product_id 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')) AND ps.price BETWEEN '18' AND '1979')) AND p.product_id IN(SELECT oov2p1.product_id FROM oc_bsfilter_option_value_to_product oov2p1 WHERE oov2p1.option_id = '10018' AND (oov2p1.value_id = '10340')) GROUP BY p.stock_status_id UNION ALL SELECT oov2p.value_id, oov2p.option_id, COUNT(p.product_id) AS total FROM oc_bsfilter_option_value_to_product oov2p LEFT JOIN oc_product_to_category p2c ON (oov2p.product_id = p2c.product_id) LEFT JOIN oc_product p ON (oov2p.product_id = p.product_id) WHERE oov2p.value_id > '0' AND p.status = '1' AND p2c.category_id = '18' AND (p.price BETWEEN '18' AND '1979' OR EXISTS (SELECT pd.product_id 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')) AND pd.price BETWEEN '18' AND '1979') OR EXISTS (SELECT ps.product_id 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')) AND ps.price BETWEEN '18' AND '1979')) AND p.product_id IN(SELECT oov2p1.product_id FROM oc_bsfilter_option_value_to_product oov2p1 WHERE oov2p1.option_id = '10018' AND (oov2p1.value_id = '10340')) GROUP BY oov2p.option_id, oov2p.value_id UNION ALL SELECT oov2p.value_id, oov2p.option_id, COUNT(p.product_id) AS total FROM oc_product p LEFT JOIN oc_product_to_category p2c ON (p.product_id = p2c.product_id) LEFT JOIN oc_bsfilter_option_value_to_product oov2p ON (p.product_id = oov2p.product_id) WHERE oov2p.option_id = '10018' AND p.status = '1' AND p2c.category_id = '18' AND (p.price BETWEEN '18' AND '1979' OR EXISTS (SELECT pd.product_id 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')) AND pd.price BETWEEN '18' AND '1979') OR EXISTS (SELECT ps.product_id 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')) AND ps.price BETWEEN '18' AND '1979')) GROUP BY oov2p.option_id, oov2p.value_id) results
0.76095795631409SELECT 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 = '18' AND p.date_available <= '2024-04-18' AND p.product_id IN(SELECT oov2p1.product_id FROM oc_bsfilter_option_value_to_product oov2p1 WHERE oov2p1.option_id = '10018' AND (oov2p1.value_id = '10340'))) prices GROUP BY product_id) results
0.00020003318786621SELECT * FROM oc_bsfilter_page WHERE status = '1'
0.00023484230041504SELECT * FROM oc_seo_url WHERE keyword = 'posuda' AND store_id = '0'
0.00020503997802734SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/category' OR route = 'ru-ru')
0.00024890899658203SELECT * FROM oc_seo_url WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'
0.00023794174194336SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '18' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
0.00024294853210449SELECT * 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=18' AND store_id = '0' AND language_id = '1'
0.00024199485778809SELECT * FROM oc_seo_url WHERE `query` = 'product/compare' AND store_id = '0' AND language_id = '1'
0.0017390251159668SELECT * 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.0002439022064209SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00022196769714355SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00025582313537598SELECT * FROM oc_seo_url WHERE `query` = 'category_id=252' AND store_id = '0' AND language_id = '1'
0.0002439022064209SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00022387504577637SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00024318695068359SELECT * FROM oc_seo_url WHERE `query` = 'category_id=259' AND store_id = '0' AND language_id = '1'
0.00024199485778809SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00022411346435547SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00025701522827148SELECT * FROM oc_seo_url WHERE `query` = 'category_id=298' AND store_id = '0' AND language_id = '1'
0.0002739429473877SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00022411346435547SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00023603439331055SELECT * FROM oc_seo_url WHERE `query` = 'category_id=289' 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.00020599365234375SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00025296211242676SELECT * FROM oc_seo_url WHERE `query` = 'category_id=364' AND store_id = '0' AND language_id = '1'
0.03901195526123SELECT 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 = '18' AND (p.price BETWEEN '18' AND '1979' OR EXISTS (SELECT pd.product_id 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')) AND pd.price BETWEEN '18' AND '1979') OR EXISTS (SELECT ps.product_id 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')) AND ps.price BETWEEN '18' AND '1979')) AND p.product_id IN(SELECT oov2p1.product_id FROM oc_bsfilter_option_value_to_product oov2p1 WHERE oov2p1.option_id = '10018' AND (oov2p1.value_id = '10340'))
0.81423497200012SELECT 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 = '18' AND (p.price BETWEEN '18' AND '1979' OR EXISTS (SELECT pd.product_id 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')) AND pd.price BETWEEN '18' AND '1979') OR EXISTS (SELECT ps.product_id 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')) AND ps.price BETWEEN '18' AND '1979')) AND p.product_id IN(SELECT oov2p1.product_id FROM oc_bsfilter_option_value_to_product oov2p1 WHERE oov2p1.option_id = '10018' AND (oov2p1.value_id = '10340')) GROUP BY p.product_id ORDER BY p.quantity ASC, LCASE(pd.name) ASC LIMIT 30,30
0.0025069713592529SELECT 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 = '22427' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0022311210632324SELECT 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 = '20819' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0025749206542969SELECT 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 = '293' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0026428699493408SELECT 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 = '2026' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0025739669799805SELECT 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 = '19496' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0025739669799805SELECT 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 = '21238' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0025029182434082SELECT 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 = '19955' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024440288543701SELECT 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 = '19958' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0023930072784424SELECT 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 = '3089' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024049282073975SELECT 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 = '19143' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0023918151855469SELECT 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 = '402' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024378299713135SELECT 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 = '20041' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024170875549316SELECT 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 = '3103' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0023679733276367SELECT 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 = '21046' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0023670196533203SELECT 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 = '21990' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024819374084473SELECT 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 = '22002' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024511814117432SELECT 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 = '296' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024299621582031SELECT 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 = '2723' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024600028991699SELECT 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 = '2726' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024049282073975SELECT 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 = '2446' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0023880004882812SELECT 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 = '3081' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.002345085144043SELECT 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 = '19963' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0023400783538818SELECT 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 = '22045' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0023341178894043SELECT 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 = '20040' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0023150444030762SELECT 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 = '3102' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0027480125427246SELECT 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 = '21097' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024299621582031SELECT 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 = '628' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024840831756592SELECT 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 = '21542' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.002532958984375SELECT 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 = '3076' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024960041046143SELECT 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 = '3077' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.00013589859008789SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00018000602722168SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00027990341186523SELECT 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 = '22427' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0018210411071777SELECT 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 = '22427' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00015401840209961SELECT * 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 = '22427' AND od.language_id = '1' ORDER BY o.sort_order
0.00014114379882812SELECT 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 = 22427 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00016379356384277SELECT * 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=28' AND store_id = '0' AND language_id = '1'
0.00014686584472656SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00016617774963379SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00031590461730957SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22427' AND store_id = '0' AND language_id = '1'
0.00012683868408203SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.0001978874206543SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00027298927307129SELECT 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 = '20819' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0019521713256836SELECT 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 = '20819' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00021791458129883SELECT * 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 = '20819' AND od.language_id = '1' ORDER BY o.sort_order
0.00026082992553711SELECT 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 = 20819 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00021815299987793SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=57' AND store_id = '0' AND language_id = '1'
0.0001530647277832SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00024509429931641SELECT * FROM oc_seo_url WHERE `query` = 'product_id=20819' AND store_id = '0' AND language_id = '1'
0.00017905235290527SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.0002140998840332SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00037813186645508SELECT 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 = '293' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0021300315856934SELECT 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 = '293' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00019693374633789SELECT * 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 = '293' AND od.language_id = '1' ORDER BY o.sort_order
0.00017619132995605SELECT 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 = 293 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00019502639770508SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00025200843811035SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=50' AND store_id = '0' AND language_id = '1'
0.00020503997802734SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00020599365234375SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.0002140998840332SELECT * FROM oc_seo_url WHERE `query` = 'product_id=293' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00019407272338867SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00035309791564941SELECT 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 = '2026' 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 = '2026' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00018596649169922SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '2026' AND od.language_id = '1' ORDER BY o.sort_order
0.00018191337585449SELECT 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 = 2026 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00019407272338867SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00025606155395508SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=50' AND store_id = '0' AND language_id = '1'
0.00019192695617676SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00021505355834961SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00033402442932129SELECT * FROM oc_seo_url WHERE `query` = 'product_id=2026' AND store_id = '0' AND language_id = '1'
0.00016593933105469SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.0001978874206543SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
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 = '19496' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0018148422241211SELECT 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 = '19496' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00018310546875SELECT * 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 = '19496' AND od.language_id = '1' ORDER BY o.sort_order
0.00017619132995605SELECT 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 = 19496 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00019192695617676SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00025582313537598SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=49' AND store_id = '0' AND language_id = '1'
0.00019311904907227SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00020980834960938SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00033283233642578SELECT * FROM oc_seo_url WHERE `query` = 'product_id=19496' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00019192695617676SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00030899047851562SELECT 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 = '21238' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0015230178833008SELECT 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 = '21238' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00017905235290527SELECT * 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 = '21238' AND od.language_id = '1' ORDER BY o.sort_order
0.0001828670501709SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 21238 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00020003318786621SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00025486946105957SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=52' AND store_id = '0' AND language_id = '1'
0.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00022697448730469SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00024604797363281SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21238' AND store_id = '0' AND language_id = '1'
0.0001828670501709SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00024604797363281SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00030899047851562SELECT 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 = '19955' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.001511812210083SELECT 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 = '19955' 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 = '19955' AND od.language_id = '1' ORDER BY o.sort_order
0.00018215179443359SELECT 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 = 19955 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00023508071899414SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=57' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00022196769714355SELECT * FROM oc_seo_url WHERE `query` = 'product_id=19955' AND store_id = '0' AND language_id = '1'
0.00015592575073242SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00017094612121582SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00028085708618164SELECT 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 = '19958' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0014870166778564SELECT 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 = '19958' 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 = '19958' AND od.language_id = '1' ORDER BY o.sort_order
0.00016498565673828SELECT 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 = 19958 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00023484230041504SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=28' AND store_id = '0' AND language_id = '1'
0.00017905235290527SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00019407272338867SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00022697448730469SELECT * FROM oc_seo_url WHERE `query` = 'product_id=19958' AND store_id = '0' AND language_id = '1'
0.0001528263092041SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00015902519226074SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00029397010803223SELECT 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 = '3089' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0014500617980957SELECT 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 = '3089' 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 = '3089' AND od.language_id = '1' ORDER BY o.sort_order
0.00016593933105469SELECT 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 = 3089 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00017690658569336SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00025105476379395SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=83' AND store_id = '0' AND language_id = '1'
0.00015687942504883SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00017309188842773SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00019311904907227SELECT * FROM oc_seo_url WHERE `query` = 'product_id=3089' AND store_id = '0' AND language_id = '1'
0.00013589859008789SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00015401840209961SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00027203559875488SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '19143' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016930103302002SELECT 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 = '19143' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00014901161193848SELECT * 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 = '19143' AND od.language_id = '1' ORDER BY o.sort_order
0.0001521110534668SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 19143 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00022387504577637SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=57' AND store_id = '0' AND language_id = '1'
0.00015401840209961SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00018310546875SELECT * FROM oc_seo_url WHERE `query` = 'product_id=19143' 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 = 'cc705687a6ed658fee57d460d9'
0.00026297569274902SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '402' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0013949871063232SELECT 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 = '402' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00015711784362793SELECT * 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 = '402' AND od.language_id = '1' ORDER BY o.sort_order
0.00014805793762207SELECT 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 = 402 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00016188621520996SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00022196769714355SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=55' AND store_id = '0' AND language_id = '1'
0.00015401840209961SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * 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` = 'product_id=402' AND store_id = '0' AND language_id = '1'
0.00013589859008789SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00015616416931152SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.0002598762512207SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '20041' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0015518665313721SELECT 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 = '20041' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00015711784362793SELECT * 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 = '20041' AND od.language_id = '1' ORDER BY o.sort_order
0.00014805793762207SELECT 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 = 20041 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00022387504577637SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=57' AND store_id = '0' AND language_id = '1'
0.00015497207641602SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00021910667419434SELECT * FROM oc_seo_url WHERE `query` = 'product_id=20041' AND store_id = '0' AND language_id = '1'
0.00014185905456543SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00015997886657715SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00027012825012207SELECT 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 = '3103' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016388893127441SELECT 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 = '3103' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00015711784362793SELECT * 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 = '3103' AND od.language_id = '1' ORDER BY o.sort_order
0.00014686584472656SELECT 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 = 3103 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00016188621520996SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00021100044250488SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=71' AND store_id = '0' AND language_id = '1'
0.0001521110534668SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00019407272338867SELECT * FROM oc_seo_url WHERE `query` = 'product_id=3103' AND store_id = '0' AND language_id = '1'
0.00013494491577148SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00015401840209961SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00027012825012207SELECT 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 = '21046' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0015230178833008SELECT 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 = '21046' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00015807151794434SELECT * 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 = '21046' AND od.language_id = '1' ORDER BY o.sort_order
0.00014781951904297SELECT 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 = 21046 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00016212463378906SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00021505355834961SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=28' AND store_id = '0' AND language_id = '1'
0.00015592575073242SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.0001521110534668SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00016117095947266SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21046' AND store_id = '0' AND language_id = '1'
0.00014209747314453SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00016403198242188SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00025796890258789SELECT 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 = '21990' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0013880729675293SELECT 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 = '21990' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00015997886657715SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '21990' AND od.language_id = '1' ORDER BY o.sort_order
0.00014901161193848SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 21990 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00022292137145996SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=57' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00030684471130371SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21990' AND store_id = '0' AND language_id = '1'
0.00014615058898926SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00016093254089355SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00028491020202637SELECT 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 = '22002' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0014309883117676SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '22002' 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 = '22002' AND od.language_id = '1' ORDER BY o.sort_order
0.00017499923706055SELECT 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 = 22002 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00017118453979492SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00022482872009277SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=33' AND store_id = '0' AND language_id = '1'
0.00015521049499512SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.0001678466796875SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00030207633972168SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22002' AND store_id = '0' AND language_id = '1'
0.00016283988952637SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00016617774963379SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00028300285339355SELECT 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 = '296' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0017271041870117SELECT 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 = '296' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00018882751464844SELECT * 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 = '296' AND od.language_id = '1' ORDER BY o.sort_order
0.00018000602722168SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 296 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00019598007202148SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00026082992553711SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=84' AND store_id = '0' AND language_id = '1'
0.00019216537475586SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00020289421081543SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.0002129077911377SELECT * FROM oc_seo_url WHERE `query` = 'product_id=296' AND store_id = '0' AND language_id = '1'
0.00016283988952637SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00019121170043945SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00031018257141113SELECT 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 = '2723' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0013980865478516SELECT 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 = '2723' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00019311904907227SELECT * 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 = '2723' AND od.language_id = '1' ORDER BY o.sort_order
0.00013899803161621SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 2723 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0002589225769043SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=84' AND store_id = '0' AND language_id = '1'
0.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00019693374633789SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00027799606323242SELECT * FROM oc_seo_url WHERE `query` = 'product_id=2723' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00020480155944824SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00033092498779297SELECT 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 = '2726' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0021109580993652SELECT 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 = '2726' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00019478797912598SELECT * 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 = '2726' AND od.language_id = '1' ORDER BY o.sort_order
0.00018310546875SELECT 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 = 2726 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00019621849060059SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00024008750915527SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=49' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00024604797363281SELECT * FROM oc_seo_url WHERE `query` = 'product_id=2726' AND store_id = '0' AND language_id = '1'
0.0001530647277832SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00018501281738281SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00031685829162598SELECT 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 = '2446' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0014948844909668SELECT 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 = '2446' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0001521110534668SELECT * 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 = '2446' 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 = 2446 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.00019621849060059SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=28' 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.00014805793762207SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00015783309936523SELECT * FROM oc_seo_url WHERE `query` = 'product_id=2446' AND store_id = '0' AND language_id = '1'
0.00011491775512695SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00014090538024902SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00025296211242676SELECT 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 = '3081' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016911029815674SELECT 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 = '3081' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00013589859008789SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '3081' 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 = 3081 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.00020503997802734SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=84' AND store_id = '0' AND language_id = '1'
0.00013399124145508SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014901161193848SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'product_id=3081' AND store_id = '0' AND language_id = '1'
0.00011491775512695SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013494491577148SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00025010108947754SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '19963' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0013809204101562SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '19963' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00017881393432617SELECT * 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 = '19963' AND od.language_id = '1' ORDER BY o.sort_order
0.00016498565673828SELECT 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 = 19963 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.00023603439331055SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=28' AND store_id = '0' AND language_id = '1'
0.00017285346984863SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00019598007202148SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00022506713867188SELECT * FROM oc_seo_url WHERE `query` = 'product_id=19963' AND store_id = '0' AND language_id = '1'
0.0001521110534668SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00017380714416504SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00028300285339355SELECT 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 = '22045' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016717910766602SELECT 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 = '22045' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00017499923706055SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '22045' AND od.language_id = '1' ORDER BY o.sort_order
0.00016498565673828SELECT 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 = 22045 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.00024080276489258SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=57' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00019717216491699SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.0001978874206543SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22045' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00017595291137695SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00027608871459961SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '20040' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0013670921325684SELECT 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 = '20040' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00017714500427246SELECT * 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 = '20040' AND od.language_id = '1' ORDER BY o.sort_order
0.00016403198242188SELECT 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 = 20040 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00024199485778809SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=57' AND store_id = '0' AND language_id = '1'
0.00017619132995605SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00019311904907227SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00024199485778809SELECT * FROM oc_seo_url WHERE `query` = 'product_id=20040' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00017094612121582SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00030207633972168SELECT 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 = '3102' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.001317024230957SELECT 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 = '3102' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00013899803161621SELECT * 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 = '3102' AND od.language_id = '1' ORDER BY o.sort_order
0.00013494491577148SELECT 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 = 3102 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.00019598007202148SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=56' 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.00014996528625488SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00017309188842773SELECT * FROM oc_seo_url WHERE `query` = 'product_id=3102' AND store_id = '0' AND language_id = '1'
0.00011515617370605SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.0001370906829834SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00024104118347168SELECT 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 = '21097' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0013449192047119SELECT 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 = '21097' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00013184547424316SELECT * 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 = '21097' AND od.language_id = '1' ORDER BY o.sort_order
0.00012493133544922SELECT 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 = 21097 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.0001978874206543SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=56' AND store_id = '0' AND language_id = '1'
0.00013494491577148SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014686584472656SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00015401840209961SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21097' AND store_id = '0' AND language_id = '1'
0.00011301040649414SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013089179992676SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00024700164794922SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '628' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016129016876221SELECT 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 = '628' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00013494491577148SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '628' 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 = 628 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.00019598007202148SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=51' 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.00014615058898926SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'product_id=628' AND store_id = '0' AND language_id = '1'
0.00011205673217773SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013089179992676SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00024199485778809SELECT 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 = '21542' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0013670921325684SELECT 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 = '21542' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00013518333435059SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '21542' 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 = 21542 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001978874206543SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=51' AND store_id = '0' AND language_id = '1'
0.00013303756713867SELECT * 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=18' AND store_id = '0' AND language_id = '1'
0.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21542' AND store_id = '0' AND language_id = '1'
0.00011301040649414SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00014781951904297SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00023293495178223SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '3076' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0015759468078613SELECT 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 = '3076' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00013303756713867SELECT * 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 = '3076' AND od.language_id = '1' ORDER BY o.sort_order
0.00012612342834473SELECT 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 = 3076 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.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=96' 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.00014615058898926SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'product_id=3076' AND store_id = '0' AND language_id = '1'
0.00011897087097168SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013089179992676SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00024008750915527SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '3077' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0015871524810791SELECT 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 = '3077' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00013184547424316SELECT * 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 = '3077' 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 = 3077 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00020599365234375SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=82' AND store_id = '0' AND language_id = '1'
0.00013399124145508SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00017118453979492SELECT * FROM oc_seo_url WHERE `query` = 'product_id=3077' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00017309188842773SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.0001680850982666SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014686584472656SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012087821960449SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014305114746094SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014305114746094SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014591217041016SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00016283988952637SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014305114746094SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00014305114746094SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014591217041016SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014591217041016SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00018119812011719SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014209747314453SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00011992454528809SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014114379882812SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014114379882812SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013995170593262SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00016188621520996SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013995170593262SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013494491577148SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.0002129077911377SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018692016601562SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00019693374633789SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00020503997802734SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018787384033203SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00018906593322754SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00020503997802734SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018692016601562SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00018811225891113SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00018906593322754SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00018787384033203SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00018596649169922SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.0002129077911377SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00022006034851074SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00019311904907227SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019502639770508SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00019502639770508SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00019693374633789SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00017094612121582SELECT * 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.00016689300537109SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.0001678466796875SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00017309188842773SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001680850982666SELECT * 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.0001680850982666SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00019216537475586SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00018906593322754SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00022196769714355SELECT * 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=18' 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.00019407272338867SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.0002288818359375SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019121170043945SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.0002138614654541SELECT * 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=18' 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.0001988410949707SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00022482872009277SELECT * 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=18' AND store_id = '0' AND language_id = '1'
0.00024008750915527SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00021505355834961SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00023698806762695SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020003318786621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.0001988410949707SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00022196769714355SELECT * 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=18' 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.00016689300537109SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00023484230041504SELECT * 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=18' AND store_id = '0' AND language_id = '1'
0.00019478797912598SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017309188842773SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00017285346984863SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00019407272338867SELECT * FROM oc_seo_url WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'
0.00014114379882812SELECT * FROM oc_category_to_layout WHERE category_id = '18' AND store_id = '0'
0.00016212463378906SELECT * FROM oc_layout_module WHERE layout_id = '145' AND position = 'column_left' ORDER BY sort_order
0.00015902519226074SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/bsfilter' OR route = 'ru-ru')
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00021696090698242SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00023293495178223SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017619132995605SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00023794174194336SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00021696090698242SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00023412704467773SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0002129077911377SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00023198127746582SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019598007202148SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00019979476928711SELECT * 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=18' 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.00019717216491699SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00018620491027832SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00018596649169922SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00019311904907227SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00017905235290527SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00018692016601562SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00018715858459473SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00019288063049316SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00018882751464844SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00020980834960938SELECT * 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=18' 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.00018906593322754SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00021100044250488SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018906593322754SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00021100044250488SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019192695617676SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00021100044250488SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00018692016601562SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00021100044250488SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019311904907227SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00021100044250488SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018906593322754SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00018787384033203SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00021100044250488SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00021004676818848SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018596649169922SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00021004676818848SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018596649169922SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00018811225891113SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00018596649169922SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00018811225891113SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00019001960754395SELECT * 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.00012493133544922SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.0018551349639893SELECT * 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.00021004676818848SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017309188842773SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.01533317565918SELECT 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.00026893615722656SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00022387504577637SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' AND store_id = '0' AND language_id = '1'
0.013858795166016SELECT 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.0021638870239258SELECT * 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.00026488304138184SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00021004676818848SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.0002288818359375SELECT * FROM oc_seo_url WHERE `query` = 'category_id=252' AND store_id = '0' AND language_id = '1'
0.022315979003906SELECT 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 = '252'
0.00028300285339355SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00021791458129883SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00030207633972168SELECT * FROM oc_seo_url WHERE `query` = 'category_id=259' AND store_id = '0' AND language_id = '1'
0.014256954193115SELECT 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 = '259'
0.00027298927307129SELECT * 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=18' AND store_id = '0' AND language_id = '1'
0.00025510787963867SELECT * FROM oc_seo_url WHERE `query` = 'category_id=298' AND store_id = '0' AND language_id = '1'
0.013587951660156SELECT 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 = '298'
0.00024914741516113SELECT * 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=18' AND store_id = '0' AND language_id = '1'
0.0002589225769043SELECT * FROM oc_seo_url WHERE `query` = 'category_id=289' AND store_id = '0' AND language_id = '1'
0.013592004776001SELECT 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 = '289'
0.00024604797363281SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0002281665802002SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00027918815612793SELECT * FROM oc_seo_url WHERE `query` = 'category_id=364' AND store_id = '0' AND language_id = '1'
0.012115955352783SELECT 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 = '364'
0.00020909309387207SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.027712106704712SELECT 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.00022792816162109SELECT * 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=230' AND store_id = '0' AND language_id = '1'
0.015358924865723SELECT 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.00021219253540039SELECT * 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=20' AND store_id = '0' AND language_id = '1'
0.019217967987061SELECT 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.00030899047851562SELECT * 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=205' AND store_id = '0' AND language_id = '1'
0.012800931930542SELECT 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.00025010108947754SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00024008750915527SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.013039112091064SELECT 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.00023412704467773SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.019438028335571SELECT 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.00027012825012207SELECT * 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=221' AND store_id = '0' AND language_id = '1'
0.012856960296631SELECT 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.00020408630371094SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'extension/module/bsfilter'
0.00016307830810547SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/category_description' OR route = 'ru-ru')
0.0001990795135498SELECT DISTINCT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.category_id = '18' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1'
0.0016520023345947SELECT * 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.00018715858459473SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'extension/module/category_description'
0.00017619132995605SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/column_left'
0.00013494491577148SELECT * FROM oc_category_to_layout WHERE category_id = '18' AND store_id = '0'
0.0001530647277832SELECT * FROM oc_layout_module WHERE layout_id = '145' AND position = 'column_right' ORDER BY sort_order
0.00016403198242188SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/column_right'
0.00013113021850586SELECT * FROM oc_category_to_layout WHERE category_id = '18' AND store_id = '0'
0.00014305114746094SELECT * FROM oc_layout_module WHERE layout_id = '145' AND position = 'content_top' ORDER BY sort_order
0.00016093254089355SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/content_top'
0.00012683868408203SELECT * FROM oc_category_to_layout WHERE category_id = '18' AND store_id = '0'
0.00013995170593262SELECT * FROM oc_layout_module WHERE layout_id = '145' AND position = 'content_bottom' ORDER BY sort_order
0.00015902519226074SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/content_bottom'
0.00014901161193848SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru')
0.00014710426330566SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/social' OR route = 'ru-ru')
0.00017595291137695SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'extension/module/social_icons'
0.0001990795135498SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')
0.0002138614654541SELECT * FROM oc_seo_url WHERE `query` = 'common/language/language' AND store_id = '0' AND language_id = '1'
0.00014805793762207SELECT * FROM oc_language WHERE status = '1' ORDER BY sort_order, name
0.0002138614654541SELECT * 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=18' AND store_id = '0' AND language_id = '1'
0.0001988410949707SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/language'
0.00015997886657715SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
0.00019717216491699SELECT * FROM oc_seo_url WHERE `query` = 'common/currency/currency' 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.00018596649169922SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00019001960754395SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/currency'
0.0017881393432617SELECT * 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.00022315979003906SELECT * 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=172' 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.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' 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.00016498565673828SELECT * 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` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017905235290527SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016689300537109SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' 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.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=205' 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.00022792816162109SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' 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.00016093254089355SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'category_id=221' AND store_id = '0' AND language_id = '1'
0.0019419193267822SELECT * 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.0002131462097168SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00019693374633789SELECT * FROM oc_seo_url WHERE `query` = 'information_id=67' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00019192695617676SELECT * FROM oc_seo_url WHERE `query` = 'information_id=77' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'information_id=68' AND store_id = '0' AND language_id = '1'
0.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00017189979553223SELECT * FROM oc_seo_url WHERE `query` = 'information_id=73' AND store_id = '0' AND language_id = '1'
0.00015401840209961SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'information_id=64' AND store_id = '0' AND language_id = '1'
0.00014996528625488SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00015902519226074SELECT * FROM oc_seo_url WHERE `query` = 'information_id=66' AND store_id = '0' AND language_id = '1'
0.00015616416931152SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00015711784362793SELECT * FROM oc_seo_url WHERE `query` = 'information_id=65' AND store_id = '0' AND language_id = '1'
0.00015807151794434SELECT * FROM oc_seo_url WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '1'
0.00013494491577148SELECT * FROM oc_seo_url WHERE `query` = 'account/return/add' AND store_id = '0' AND language_id = '1'
0.00015902519226074SELECT * FROM oc_seo_url WHERE `query` = 'information/sitemap' AND store_id = '0' AND language_id = '1'
0.00015020370483398SELECT * FROM oc_seo_url WHERE `query` = 'information/tracking' AND store_id = '0' AND language_id = '1'
0.00013399124145508SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer' AND store_id = '0' AND language_id = '1'
0.0001380443572998SELECT * FROM oc_seo_url WHERE `query` = 'account/voucher' AND store_id = '0' AND language_id = '1'
0.00013279914855957SELECT * FROM oc_seo_url WHERE `query` = 'affiliate/login' AND store_id = '0' AND language_id = '1'
0.00013208389282227SELECT * FROM oc_seo_url WHERE `query` = 'product/special' AND store_id = '0' AND language_id = '1'
0.00013089179992676SELECT * FROM oc_seo_url WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
0.00010800361633301SELECT * FROM oc_seo_url WHERE `query` = 'account/order' AND store_id = '0' AND language_id = '1'
0.00010895729064941SELECT * FROM oc_seo_url WHERE `query` = 'account/wishlist' AND store_id = '0' AND language_id = '1'
0.0001070499420166SELECT * FROM oc_seo_url WHERE `query` = 'account/newsletter' AND store_id = '0' AND language_id = '1'
0.00011205673217773SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'theme/bodysport' OR route = 'ru-ru')
0.00010299682617188SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/subscribe' OR route = 'ru-ru')
0.00017118453979492SELECT * FROM oc_seo_url WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'
0.00020289421081543DELETE FROM `oc_customer_online` WHERE date_added < '2024-04-18 20:24:52'
0.00012803077697754REPLACE INTO `oc_customer_online` SET `ip` = '44.201.97.0', `customer_id` = '0', `url` = 'https://ndplay.ru/posuda/price/18-1979/10018/10340?page=2', `referer` = '', `date_added` = '2024-04-18 21:24:52'
0.00016498565673828SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/footer'
0.00015687942504883SELECT * FROM oc_extension WHERE `type` = 'analytics'
0.00018191337585449SELECT * FROM oc_seo_url WHERE `query` = 'style/setting' AND store_id = '0' AND language_id = '1'
0.00017213821411133SELECT * FROM oc_seo_url WHERE `query` = 'style/setting' AND store_id = '0' AND language_id = '1'
0.00014805793762207SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
0.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'
0.00014805793762207SELECT * FROM oc_seo_url WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'
0.00016188621520996SELECT * FROM oc_seo_url WHERE `query` = 'account/wishlist' AND store_id = '0' AND language_id = '1'
0.00015902519226074SELECT * FROM oc_seo_url WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
0.00016212463378906SELECT * FROM oc_seo_url WHERE `query` = 'account/register' AND store_id = '0' AND language_id = '1'
0.00015711784362793SELECT * FROM oc_seo_url WHERE `query` = 'account/login' AND store_id = '0' AND language_id = '1'
0.00016283988952637SELECT * FROM oc_seo_url WHERE `query` = 'account/order' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'account/transaction' AND store_id = '0' AND language_id = '1'
0.00015807151794434SELECT * FROM oc_seo_url WHERE `query` = 'account/download' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'
0.00018906593322754SELECT * FROM oc_seo_url WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'
0.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'checkout/checkout' AND store_id = '0' AND language_id = '1'
0.00018310546875SELECT * FROM oc_seo_url WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '1'
0.0001838207244873SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/text_loading'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'account/edit' AND store_id = '0' AND language_id = '1'
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'account/address' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'account/reward' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'account/return' AND store_id = '0' AND language_id = '1'
0.00014901161193848SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'common/language/language' AND store_id = '0' AND language_id = '1'
0.00013995170593262SELECT * FROM oc_language WHERE status = '1' ORDER BY sort_order, name
0.00019407272338867SELECT * 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=18' AND store_id = '0' AND language_id = '1'
0.00018000602722168SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/language'
0.00014281272888184SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
0.0001828670501709SELECT * FROM oc_seo_url WHERE `query` = 'common/currency/currency' AND store_id = '0' AND language_id = '1'
0.00023603439331055SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00023794174194336SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00022411346435547SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/currency'
0.00017595291137695SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru')
0.00018405914306641SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/search'
0.00015401840209961SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')
0.00017905235290527SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00014305114746094SELECT * FROM oc_extension WHERE `type` = 'total'
0.00019502639770508SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru')
0.00018906593322754SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.0001220703125SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00015497207641602SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/credit' OR route = 'ru-ru')
0.00012016296386719SELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0'
0.00014805793762207SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru')
0.0001528263092041SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00014591217041016SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'cc705687a6ed658fee57d460d9'
0.00020217895507812SELECT * FROM oc_seo_url WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'
0.00019407272338867SELECT * FROM oc_seo_url WHERE `query` = 'checkout/checkout' AND store_id = '0' AND language_id = '1'
0.00020194053649902SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/cart'
0.00015497207641602SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/menu' OR route = 'ru-ru')
0.0018329620361328SELECT * 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.0014960765838623SELECT * 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.00020503997802734SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017309188842773SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00018692016601562SELECT * FROM oc_seo_url WHERE `query` = 'category_id=25' AND store_id = '0' AND language_id = '1'
0.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00016093254089355SELECT * FROM oc_seo_url WHERE `query` = 'category_id=117' 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.00016093254089355SELECT * 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=195' AND store_id = '0' AND language_id = '1'
0.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016188621520996SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00017809867858887SELECT * FROM oc_seo_url WHERE `query` = 'category_id=238' 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.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.0002291202545166SELECT * FROM oc_seo_url WHERE `query` = 'category_id=68' 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.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00015878677368164SELECT * FROM oc_seo_url WHERE `query` = 'category_id=242' AND store_id = '0' AND language_id = '1'
0.00016283988952637SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'category_id=245' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013995170593262SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00012898445129395SELECT * FROM oc_seo_url WHERE `query` = 'category_id=204' AND store_id = '0' AND language_id = '1'
0.00022196769714355SELECT * 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=172' AND store_id = '0' AND language_id = '1'
0.0017259120941162SELECT * 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.00018405914306641SELECT * 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=223' AND store_id = '0' AND language_id = '1'
0.00020813941955566SELECT * FROM oc_seo_url WHERE `query` = 'category_id=389' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001521110534668SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' AND store_id = '0' AND language_id = '1'
0.00014805793762207SELECT * FROM oc_seo_url WHERE `query` = 'category_id=210' AND store_id = '0' AND language_id = '1'
0.00016117095947266SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015497207641602SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' AND store_id = '0' AND language_id = '1'
0.00019598007202148SELECT * FROM oc_seo_url WHERE `query` = 'category_id=371' AND store_id = '0' AND language_id = '1'
0.00016283988952637SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' AND store_id = '0' AND language_id = '1'
0.0015490055084229SELECT * 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.00017905235290527SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00016283988952637SELECT * FROM oc_seo_url WHERE `query` = 'category_id=252' AND store_id = '0' AND language_id = '1'
0.00016689300537109SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014519691467285SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00016093254089355SELECT * FROM oc_seo_url WHERE `query` = 'category_id=259' AND store_id = '0' AND language_id = '1'
0.00016188621520996SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014209747314453SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00016212463378906SELECT * FROM oc_seo_url WHERE `query` = 'category_id=298' AND store_id = '0' AND language_id = '1'
0.00016188621520996SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013995170593262SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00017118453979492SELECT * FROM oc_seo_url WHERE `query` = 'category_id=289' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00019311904907227SELECT * FROM oc_seo_url WHERE `query` = 'category_id=364' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.0016109943389893SELECT * 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.00018191337585449SELECT * 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=230' AND store_id = '0' AND language_id = '1'
0.00015497207641602SELECT * FROM oc_seo_url WHERE `query` = 'category_id=227' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015616416931152SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'category_id=301' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015592575073242SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'category_id=300' AND store_id = '0' AND language_id = '1'
0.00016093254089355SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001518726348877SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00015902519226074SELECT * FROM oc_seo_url WHERE `query` = 'category_id=250' AND store_id = '0' AND language_id = '1'
0.00016212463378906SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001530647277832SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00016212463378906SELECT * FROM oc_seo_url WHERE `query` = 'category_id=256' AND store_id = '0' AND language_id = '1'
0.00016093254089355SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'category_id=305' AND store_id = '0' AND language_id = '1'
0.00016188621520996SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001521110534668SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.0016639232635498SELECT * FROM oc_category c LEFT JOIN oc_category_description cd ON (c.category_id = cd.category_id) LEFT JOIN oc_category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '20' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
0.00017905235290527SELECT * 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=20' AND store_id = '0' AND language_id = '1'
0.00020599365234375SELECT * FROM oc_seo_url WHERE `query` = 'category_id=65' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014710426330566SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'category_id=326' AND store_id = '0' AND language_id = '1'
0.00016212463378906SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014805793762207SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00014305114746094SELECT * FROM oc_seo_url WHERE `query` = 'category_id=185' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014686584472656SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'category_id=327' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014305114746094SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00018692016601562SELECT * FROM oc_seo_url WHERE `query` = 'category_id=345' 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.00014305114746094SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.0017189979553223SELECT * 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.00018501281738281SELECT * 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=205' AND store_id = '0' AND language_id = '1'
0.00020003318786621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=370' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015115737915039SELECT * FROM oc_seo_url WHERE `query` = 'category_id=205' AND store_id = '0' AND language_id = '1'
0.00015521049499512SELECT * FROM oc_seo_url WHERE `query` = 'category_id=228' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014710426330566SELECT * FROM oc_seo_url WHERE `query` = 'category_id=205' AND store_id = '0' AND language_id = '1'
0.0016498565673828SELECT * 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.00017905235290527SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020909309387207SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.00020503997802734SELECT * FROM oc_seo_url WHERE `query` = 'category_id=397' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020194053649902SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.00020503997802734SELECT * FROM oc_seo_url WHERE `query` = 'category_id=398' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020003318786621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'category_id=399' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020194053649902SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'category_id=400' AND store_id = '0' AND language_id = '1'
0.00016093254089355SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020384788513184SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.0015377998352051SELECT * 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.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014710426330566SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00019502639770508SELECT * FROM oc_seo_url WHERE `query` = 'category_id=346' AND store_id = '0' AND language_id = '1'
0.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018787384033203SELECT * FROM oc_seo_url WHERE `query` = 'category_id=347' AND store_id = '0' AND language_id = '1'
0.00016283988952637SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001368522644043SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00018882751464844SELECT * FROM oc_seo_url WHERE `query` = 'category_id=348' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013589859008789SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00017213821411133SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013589859008789SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0001368522644043SELECT * FROM oc_seo_url WHERE `query` = 'category_id=111' AND store_id = '0' AND language_id = '1'
0.00016093254089355SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013399124145508SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0014228820800781SELECT * 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.00016188621520996SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001368522644043SELECT * FROM oc_seo_url WHERE `query` = 'category_id=221' AND store_id = '0' AND language_id = '1'
0.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'category_id=394' 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.00012993812561035SELECT * FROM oc_seo_url WHERE `query` = 'category_id=221' AND store_id = '0' AND language_id = '1'
0.00012803077697754SELECT * FROM oc_seo_url WHERE `query` = 'category_id=222' AND store_id = '0' AND language_id = '1'
0.0001378059387207SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012612342834473SELECT * FROM oc_seo_url WHERE `query` = 'category_id=221' AND store_id = '0' AND language_id = '1'
0.00011205673217773SELECT * FROM oc_seo_url WHERE `query` = 'category_id=102' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00012588500976562SELECT * FROM oc_seo_url WHERE `query` = 'category_id=221' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'product/catalog' AND store_id = '0' AND language_id = '1'
0.00013995170593262SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/menu'
0.00010895729064941SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/brands' OR route = 'ru-ru')
0.00015711784362793SELECT * 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=120' 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.00019407272338867SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=147' AND store_id = '0' AND language_id = '1'
0.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019311904907227SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=142' AND store_id = '0' AND language_id = '1'
0.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00020718574523926SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=32' AND store_id = '0' AND language_id = '1'
0.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=113' AND store_id = '0' AND language_id = '1'
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00022697448730469SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=177' AND store_id = '0' AND language_id = '1'
0.00015401840209961SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019192695617676SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=114' 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.00019598007202148SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=140' 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.00018906593322754SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=121' 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.0001978874206543SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=163' AND store_id = '0' AND language_id = '1'
0.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018906593322754SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=123' 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.00018310546875SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=18' 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.00017309188842773SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=132' AND store_id = '0' AND language_id = '1'
0.00012516975402832SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017881393432617SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=158' 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.00018787384033203SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=61' 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.00018191337585449SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=33' 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.00018882751464844SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=73' AND store_id = '0' AND language_id = '1'
0.00012683868408203SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=74' 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.00017786026000977SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=173' 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.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=122' AND store_id = '0' AND language_id = '1'
0.00010299682617188SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015902519226074SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=26' 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.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=75' 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.00016212463378906SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=65' 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.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=48' AND store_id = '0' AND language_id = '1'
0.00010180473327637SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001518726348877SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=164' 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.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=124' AND store_id = '0' AND language_id = '1'
0.00010108947753906SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015497207641602SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=175' 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.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=76' 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.00015401840209961SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=168' 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.0001518726348877SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=166' AND store_id = '0' AND language_id = '1'
0.00010180473327637SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=125' AND store_id = '0' AND language_id = '1'
0.00010418891906738SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00020217895507812SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=49' AND store_id = '0' AND language_id = '1'
0.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00020003318786621SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=167' 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.0001990795135498SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=146' AND store_id = '0' AND language_id = '1'
0.00011396408081055SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00024104118347168SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=77' AND store_id = '0' AND language_id = '1'
0.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00026702880859375SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=78' AND store_id = '0' AND language_id = '1'
0.00019502639770508SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00024604797363281SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=133' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00023984909057617SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=116' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00024890899658203SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=155' AND store_id = '0' AND language_id = '1'
0.00019407272338867SELECT * 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=111' AND store_id = '0' AND language_id = '1'
0.00019407272338867SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00026607513427734SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=79' AND store_id = '0' AND language_id = '1'
0.00019502639770508SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00024890899658203SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=136' AND store_id = '0' AND language_id = '1'
0.00017118453979492SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00023913383483887SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=176' AND store_id = '0' AND language_id = '1'
0.00013995170593262SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00020503997802734SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=131' 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.00020694732666016SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=169' 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.00020909309387207SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=165' 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.00022315979003906SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=80' 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.00019693374633789SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=128' 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.0002129077911377SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=25' AND store_id = '0' AND language_id = '1'
0.00018191337585449SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00021910667419434SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=115' AND store_id = '0' AND language_id = '1'
0.00011491775512695SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00024199485778809SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=81' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00023007392883301SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=22' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00023698806762695SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=57' AND store_id = '0' AND language_id = '1'
0.00017309188842773SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00023317337036133SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=50' 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.00022411346435547SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=141' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00023102760314941SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=29' AND store_id = '0' AND language_id = '1'
0.00017309188842773SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00024700164794922SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=82' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00021195411682129SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=109' AND store_id = '0' AND language_id = '1'
0.00017213821411133SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=110' AND store_id = '0' AND language_id = '1'
0.00015711784362793SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00022006034851074SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=83' 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.00021505355834961SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=84' 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.0001978874206543SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=143' AND store_id = '0' AND language_id = '1'
0.0001521110534668SELECT * 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=112' AND store_id = '0' AND language_id = '1'
0.00010395050048828SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019407272338867SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=85' 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.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=150' 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.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=86' 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.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=51' 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.00018906593322754SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=60' AND store_id = '0' AND language_id = '1'
0.00010490417480469SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00021195411682129SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=87' 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.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=88' 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.00014114379882812SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=101' AND store_id = '0' AND language_id = '1'
0.00012803077697754SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018787384033203SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=72' 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.00019502639770508SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=89' AND store_id = '0' AND language_id = '1'
0.00010299682617188SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019502639770508SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=90' 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.00018787384033203SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=52' 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.00016617774963379SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=117' 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.00017809867858887SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=172' AND store_id = '0' AND language_id = '1'
0.00012516975402832SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018596649169922SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=58' AND store_id = '0' AND language_id = '1'
0.00012612342834473SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=91' 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.00020003318786621SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=97' 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.00016617774963379SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=119' AND store_id = '0' AND language_id = '1'
0.00012516975402832SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=55' 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.00015592575073242SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=28' 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.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=70' AND store_id = '0' AND language_id = '1'
0.00010108947753906SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017213821411133SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=92' 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.00015401840209961SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=170' 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.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=56' AND store_id = '0' AND language_id = '1'
9.9897384643555E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=93' AND store_id = '0' AND language_id = '1'
9.9897384643555E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=94' AND store_id = '0' AND language_id = '1'
0.00010299682617188SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=95' 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.00019288063049316SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=96' AND store_id = '0' AND language_id = '1'
0.00015592575073242SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00023102760314941SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=69' AND store_id = '0' AND language_id = '1'
0.00016212463378906SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer' AND store_id = '0' AND language_id = '1'
0.00018501281738281SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/brands'
0.00018692016601562SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00018787384033203SELECT * FROM oc_seo_url WHERE `query` = 'information_id=64' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'information_id=65' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'extension/module/menu'
0.00015711784362793SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/quicksignup' OR route = 'ru-ru')
0.00013208389282227SELECT * FROM oc_seo_url WHERE `query` = 'account/edit' AND store_id = '0' AND language_id = '1'
0.00011897087097168SELECT * FROM oc_seo_url WHERE `query` = 'account/register' AND store_id = '0' AND language_id = '1'
0.00016617774963379SELECT * FROM oc_seo_url WHERE `query` = 'account/login' AND store_id = '0' AND language_id = '1'
0.00011420249938965SELECT * FROM oc_seo_url WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'
0.00011014938354492SELECT * FROM oc_seo_url WHERE `query` = 'account/forgotten' AND store_id = '0' AND language_id = '1'
0.00013589859008789SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/quicksignup'
0.00013518333435059SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/header'
0.0002138614654541SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'product/category'