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р.

Кружка керамическая (325 мл). Самолеты

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

нет отзывов

114р.

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

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

нет отзывов

336р.

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

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

нет отзывов

210р.

Набор ложка + вилка, в форме самолета. Тачки

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

нет отзывов

159р.

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

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

нет отзывов

245р.

Набор посуды керамической в подарочной упаковке (№4, 3 предмета). Hello Kitty

Набор посуды в подарочной упаковке с изображением популярной кошечки Hello Kitty. Набор детской посу..

нет отзывов

799р.

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

Детский стакан "Холодное сердце. Цветы" - отличное дополнение в коллекцию и прекрасный подарок для в..

нет отзывов

72р.

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

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

нет отзывов

1198р.

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

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

нет отзывов

228р.

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

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

нет отзывов

210р.

Миска пластиковая (для СВЧ). Человек-паук Улицы

Тарелка «Человек-паук. Улицы» с изображением популярного супергероя – полезный и приятный подарок дл..

нет отзывов

242р.

Миска пластиковая. Холодное сердце 2

Тарелка "Холодное сердце 2" с изображением принцесс из популярного мультфильма. Дети будут в восторг..

нет отзывов

159р.

Бутылка пластиковая (спортивная, фигурная, 400 мл). Звездные Войны Последние джедаи

Бутылка для воды детская "Звездные Войны. Последние джедаи" (объём 400 мл) с изображением героев поп..

нет отзывов

246р.

Кружка керамическая (220 мл). Холодное сердце 2

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

нет отзывов

228р.

Подставка пластиковая под посуду. Холодное сердце. Радужная вода

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

нет отзывов

159р.

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

Пластиковая бутылка для воды «Тачки. Будет гонка!» объемом 400 мл станет подходящим подарком для пок..

нет отзывов

230р.

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

Детская кружка "София Прекрасная" из качественной керамики в ярой брендированной подарочной упаковке..

нет отзывов

210р.

Кружка-хамелеон керамическая в подарочной упаковке (№1, 325 мл). L.O.L.

Кружка-хамелеон с изображением героинь популярного бренда L.O.L. Surprise! — прекрасный по..

нет отзывов

349р.

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

Пластиковая бутылка для воды «Бэтмен» объемом 400 мл станет подходящим подарком для поклонников попу..

нет отзывов

307р.

Кружка керамическая (325 мл). Тролли

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

нет отзывов

276р.

Кружка керамическая в подарочной упаковке (220 мл). Леди Баг в розовом

Детская керамическая кружка небольшого объёма (220 мл) в подарочной упаковке с изображением любимых ..

нет отзывов

230р.

Кружка керамическая в подарочной упаковке (220 мл). Микки Набросок

Детская кружка «Микки Набросок» из прочной керамики – отличное дополнение в коллекцию и прекрасный в..

нет отзывов

276р.

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

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

нет отзывов

259р.

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

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

нет отзывов

215р.

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

Детская кружка "LOL Surprise!" из качественной керамики в яркой брендированной подарочной упаковке –..

нет отзывов

336р.

Набор посуды керамической в подарочной упаковке (3 предмета). Пупси

Набор посуды керамической с изображением единорогов POOPSIE SLIME SURPRISE! - отличное дополнение в ..

нет отзывов

499р.

Тарелка пластиковая (для СВЧ). Леди Баг

Красивая детская тарелка «Леди Баг» в фирменных в красно-черных тонах - идеальный подарок для девочк..

нет отзывов

286р.

Контейнер пластиковый (квадратный, 290 мл). Мстители Раскат грома

Пластиковый контейнер «Мстители. Раскат грома» объемом 290 мл станет полезным подарком для маленьког..

нет отзывов

256р.

Кружка керамическая в подарочной упаковке (220 мл). Щенячий патруль. Мальчик. Действие

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

нет отзывов

276р.

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

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

нет отзывов

276р.

Debug SQL
0.00027108192443848SELECT `data` FROM `oc_session` WHERE session_id = 'c353e74c6a50d90168fc927bdc' AND expire > 1713469911
0.00022602081298828SELECT * FROM oc_extension WHERE `type` = 'openbay'
0.00021100044250488SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
0.00018596649169922SELECT * FROM oc_extension WHERE `type` = 'openbay'
0.00016403198242188SELECT `data` FROM `oc_session` WHERE session_id = 'f7b001af990094f470fdfdb85e' AND expire > 1713469911
0.00016999244689941SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://ndplay.ru/'
0.0019330978393555SELECT * 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.0002291202545166SELECT * FROM oc_currency
0.00036883354187012SELECT 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.00033211708068848SELECT 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.00019216537475586SELECT * 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.00019598007202148SELECT * 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.0036921501159668DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
0.00017714500427246SELECT * FROM oc_extension WHERE `type` = 'openbay'
0.0036039352416992SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC
0.00026607513427734SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/bsfilter' OR route = 'ru-ru')
0.00018405914306641SELECT * FROM oc_bsfilter_page WHERE status = '1' AND keyword = 'posuda' LIMIT 1
0.00018501281738281SELECT * FROM oc_bsfilter_page WHERE status = '1' AND keyword = 'price' LIMIT 1
0.0001990795135498SELECT * FROM oc_bsfilter_page WHERE status = '1' AND keyword = '18-1979' LIMIT 1
0.00016188621520996SELECT * FROM oc_bsfilter_page WHERE status = '1' AND keyword = '10018' LIMIT 1
0.00021195411682129SELECT * FROM oc_bsfilter_page WHERE status = '1' AND keyword = '10340' LIMIT 1
0.22484683990479SELECT 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.75739407539368SELECT 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.00015807151794434SELECT * FROM oc_bsfilter_page WHERE status = '1'
0.00018405914306641SELECT * FROM oc_seo_url WHERE keyword = 'posuda' AND store_id = '0'
0.00014901161193848SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/category' OR route = 'ru-ru')
0.00019621849060059SELECT * FROM oc_seo_url WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'
0.0001828670501709SELECT 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.00018811225891113SELECT * 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.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'product/compare' AND store_id = '0' AND language_id = '1'
0.0018110275268555SELECT * 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.0001990795135498SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00021719932556152SELECT * 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` = 'category_id=252' AND store_id = '0' AND language_id = '1'
0.00018715858459473SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * 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` = 'category_id=259' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016307830810547SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00019383430480957SELECT * FROM oc_seo_url WHERE `query` = 'category_id=298' 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.00016117095947266SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * FROM oc_seo_url WHERE `query` = 'category_id=289' AND store_id = '0' AND language_id = '1'
0.00017905235290527SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016379356384277SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.0002131462097168SELECT * FROM oc_seo_url WHERE `query` = 'category_id=364' AND store_id = '0' AND language_id = '1'
0.037469148635864SELECT 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.81403303146362SELECT 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 90,30
0.0025768280029297SELECT 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 = '3139' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024549961090088SELECT 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 = '19497' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0023999214172363SELECT 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 = '378' 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 = '464' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024769306182861SELECT 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 = '19961' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.00076699256896973SELECT 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 = '19513' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024240016937256SELECT 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 = '1237' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0021548271179199SELECT 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 = '22398' 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 = '19989' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.002406120300293SELECT 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 = '2729' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.002457857131958SELECT 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 = '21973' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0023958683013916SELECT 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 = '19966' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0026059150695801SELECT 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 = '3062' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.002418041229248SELECT 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 = '19991' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0027070045471191SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '21100' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0023219585418701SELECT 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 = '22426' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024850368499756SELECT 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 = '332' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.002446174621582SELECT 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 = '20208' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.002112865447998SELECT 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 = '22399' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024700164794922SELECT 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 = '2440' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024759769439697SELECT 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 = '21171' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.002418041229248SELECT 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 = '22029' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024399757385254SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM oc_product_discount pd2 WHERE pd2.product_id = p.product_id AND pd2.customer_group_id = '1' AND pd2.quantity = '1' AND ((pd2.date_start = '0000-00-00' OR pd2.date_start < NOW()) AND (pd2.date_end = '0000-00-00' OR pd2.date_end > NOW())) ORDER BY pd2.priority ASC, pd2.price ASC LIMIT 1) AS discount, (SELECT price FROM oc_product_special ps WHERE ps.product_id = p.product_id AND ps.customer_group_id = '1' AND ((ps.date_start = '0000-00-00' OR ps.date_start < NOW()) AND (ps.date_end = '0000-00-00' OR ps.date_end > NOW())) ORDER BY ps.priority ASC, ps.price ASC LIMIT 1) AS special, (SELECT points FROM oc_product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM oc_stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM oc_weight_class_description wcd WHERE p.weight_class_id = wcd.weight_class_id AND wcd.language_id = '1') AS weight_class, (SELECT lcd.unit FROM oc_length_class_description lcd WHERE p.length_class_id = lcd.length_class_id AND lcd.language_id = '1') AS length_class, (SELECT AVG(rating) AS total FROM oc_review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT COUNT(*) AS total FROM oc_review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM oc_product p LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN oc_manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '20943' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0027129650115967SELECT 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 = '21096' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024070739746094SELECT 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 = '20234' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.002479076385498SELECT 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 = '21909' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024800300598145SELECT 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 = '21183' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0025660991668701SELECT 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 = '21965' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.002485990524292SELECT 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 = '21237' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.0024878978729248SELECT 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 = '20769' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
0.00021100044250488SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00021100044250488SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00033187866210938SELECT 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 = '3139' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0017399787902832SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '3139' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00019717216491699SELECT * 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 = '3139' AND od.language_id = '1' ORDER BY o.sort_order
0.00019311904907227SELECT 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 = 3139 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00020885467529297SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00027799606323242SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=86' AND store_id = '0' AND language_id = '1'
0.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00022602081298828SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.0002591609954834SELECT * FROM oc_seo_url WHERE `query` = 'product_id=3139' AND store_id = '0' AND language_id = '1'
0.00018310546875SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00020003318786621SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.0003211498260498SELECT 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 = '19497' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0014998912811279SELECT 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 = '19497' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00019407272338867SELECT * 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 = '19497' AND od.language_id = '1' ORDER BY o.sort_order
0.00018787384033203SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 19497 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00020384788513184SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00027918815612793SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=49' AND store_id = '0' AND language_id = '1'
0.00020313262939453SELECT * FROM oc_seo_url WHERE `query` = 'product/product' 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.0003359317779541SELECT * FROM oc_seo_url WHERE `query` = 'product_id=19497' AND store_id = '0' AND language_id = '1'
0.00018215179443359SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00020599365234375SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00031709671020508SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '378' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0015740394592285SELECT 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 = '378' 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 = '378' AND od.language_id = '1' ORDER BY o.sort_order
0.00018811225891113SELECT 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 = 378 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00020885467529297SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00026893615722656SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=52' AND store_id = '0' AND language_id = '1'
0.00020194053649902SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00022602081298828SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00027704238891602SELECT * FROM oc_seo_url WHERE `query` = 'product_id=378' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00020003318786621SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00032305717468262SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '464' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0017249584197998SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '464' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0015218257904053SELECT 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 = '464' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00019383430480957SELECT * 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 = '464' AND od.language_id = '1' ORDER BY o.sort_order
0.00018882751464844SELECT 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 = 464 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00022196769714355SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00027108192443848SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=52' AND store_id = '0' AND language_id = '1'
0.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'product/product' 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.00022006034851074SELECT * FROM oc_seo_url WHERE `query` = 'product_id=464' AND store_id = '0' AND language_id = '1'
0.00017905235290527SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00020718574523926SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00031614303588867SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '19961' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0017929077148438SELECT 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 = '19961' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00019407272338867SELECT * 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 = '19961' AND od.language_id = '1' ORDER BY o.sort_order
0.00019001960754395SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 19961 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00020813941955566SELECT * 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=50' AND store_id = '0' AND language_id = '1'
0.00022387504577637SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00022602081298828SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00025296211242676SELECT * FROM oc_seo_url WHERE `query` = 'product_id=19961' AND store_id = '0' AND language_id = '1'
0.00017905235290527SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00020003318786621SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00032901763916016SELECT 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 = '19513' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016109943389893SELECT 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 = '19513' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0013790130615234SELECT 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 = '19513' AND a.attribute_group_id = '7' 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 = '19513' AND od.language_id = '1' ORDER BY o.sort_order
0.00015616416931152SELECT 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 = 19513 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00017189979553223SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00022602081298828SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=55' AND store_id = '0' AND language_id = '1'
0.00016188621520996SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.0002291202545166SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.0002741813659668SELECT * FROM oc_seo_url WHERE `query` = 'product_id=19513' AND store_id = '0' AND language_id = '1'
0.00018787384033203SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.0001678466796875SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00030303001403809SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '1237' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0017390251159668SELECT 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 = '1237' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00025510787963867SELECT * 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 = '1237' AND od.language_id = '1' ORDER BY o.sort_order
0.00015807151794434SELECT 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 = 1237 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.0002291202545166SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=28' AND store_id = '0' AND language_id = '1'
0.00014090538024902SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00015711784362793SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.0001680850982666SELECT * FROM oc_seo_url WHERE `query` = 'product_id=1237' AND store_id = '0' AND language_id = '1'
0.00012516975402832SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.0001530647277832SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00029301643371582SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '22398' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0014710426330566SELECT 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 = '22398' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00014400482177734SELECT * 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 = '22398' AND od.language_id = '1' ORDER BY o.sort_order
0.0001380443572998SELECT 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 = 22398 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00014996528625488SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018811225891113SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=121' AND store_id = '0' AND language_id = '1'
0.00014114379882812SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00017690658569336SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00027298927307129SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22398' AND store_id = '0' AND language_id = '1'
0.00015592575073242SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00015091896057129SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00026988983154297SELECT 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 = '19989' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0017039775848389SELECT 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 = '19989' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00017690658569336SELECT * 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 = '19989' AND od.language_id = '1' ORDER BY o.sort_order
0.00017309188842773SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 19989 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00018620491027832SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00026988983154297SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=82' AND store_id = '0' AND language_id = '1'
0.00011301040649414SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.0002140998840332SELECT * 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_id=19989' AND store_id = '0' AND language_id = '1'
0.00017118453979492SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.0001838207244873SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00033116340637207SELECT 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 = '2729' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0020489692687988SELECT 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 = '2729' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0001988410949707SELECT * 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 = '2729' AND od.language_id = '1' ORDER BY o.sort_order
0.0001370906829834SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 2729 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00017213821411133SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001981258392334SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=50' AND store_id = '0' AND language_id = '1'
0.00013089179992676SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.0001530647277832SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00020813941955566SELECT * FROM oc_seo_url WHERE `query` = 'product_id=2729' AND store_id = '0' AND language_id = '1'
0.00011515617370605SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.0001680850982666SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00031304359436035SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '21973' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0014910697937012SELECT 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 = '21973' 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 = '21973' AND od.language_id = '1' ORDER BY o.sort_order
0.00012397766113281SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 21973 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00028491020202637SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=56' AND store_id = '0' AND language_id = '1'
0.00013089179992676SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014615058898926SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00027298927307129SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21973' AND store_id = '0' AND language_id = '1'
0.00011992454528809SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.0001370906829834SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
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 = '19966' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.00164794921875SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '19966' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00013208389282227SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '19966' 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 = 19966 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.0001378059387207SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=28' AND store_id = '0' AND language_id = '1'
0.00012898445129395SELECT * 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.00017690658569336SELECT * FROM oc_seo_url WHERE `query` = 'product_id=19966' 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 = 'f7b001af990094f470fdfdb85e'
0.00024604797363281SELECT 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 = '3062' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0015830993652344SELECT 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 = '3062' 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 = '3062' AND od.language_id = '1' ORDER BY o.sort_order
0.0001220703125SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 3062 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.0001368522644043SELECT * 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=49' AND store_id = '0' AND language_id = '1'
0.00012898445129395SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00016021728515625SELECT * FROM oc_seo_url WHERE `query` = 'product_id=3062' AND store_id = '0' AND language_id = '1'
0.00011110305786133SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013017654418945SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
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 = '19991' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016770362854004SELECT 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 = '19991' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00016307830810547SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '19991' AND od.language_id = '1' ORDER BY o.sort_order
0.00012397766113281SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 19991 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00014114379882812SELECT * 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=28' AND store_id = '0' AND language_id = '1'
0.00015783309936523SELECT * 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.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'product_id=19991' AND store_id = '0' AND language_id = '1'
0.00014305114746094SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013613700866699SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00023984909057617SELECT 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 = '21100' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016729831695557SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '21100' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00013279914855957SELECT * 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 = '21100' AND od.language_id = '1' ORDER BY o.sort_order
0.00015592575073242SELECT 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 = 21100 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.0001380443572998SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=28' AND store_id = '0' AND language_id = '1'
0.00013017654418945SELECT * FROM oc_seo_url WHERE `query` = 'product/product' 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.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21100' AND store_id = '0' AND language_id = '1'
0.00011301040649414SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00012993812561035SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00026893615722656SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '22426' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016288757324219SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '22426' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00013017654418945SELECT * 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 = '22426' AND od.language_id = '1' ORDER BY o.sort_order
0.00012302398681641SELECT 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 = 22426 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.00023007392883301SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=52' 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.00014281272888184SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00026798248291016SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22426' AND store_id = '0' AND language_id = '1'
0.00011086463928223SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013017654418945SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.000244140625SELECT 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 = '332' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0013821125030518SELECT a.attribute_id, ad.name, pa.show_attribute, pa.text FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_description ad ON (a.attribute_id = ad.attribute_id) WHERE pa.product_id = '332' 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 = '332' AND od.language_id = '1' ORDER BY o.sort_order
0.00014090538024902SELECT 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 = 332 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.0001368522644043SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00020289421081543SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=88' 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.00014495849609375SELECT * 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=332' AND store_id = '0' AND language_id = '1'
0.00011086463928223SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.0001370906829834SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00024604797363281SELECT 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 = '20208' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0013680458068848SELECT 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 = '20208' 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 = '20208' AND od.language_id = '1' ORDER BY o.sort_order
0.0001218318939209SELECT 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 = 20208 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.0001370906829834SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=32' AND store_id = '0' AND language_id = '1'
0.00012898445129395SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00024294853210449SELECT * FROM oc_seo_url WHERE `query` = 'product_id=20208' AND store_id = '0' AND language_id = '1'
0.00011301040649414SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013494491577148SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
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 = '22399' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0012869834899902SELECT 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 = '22399' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00012707710266113SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '22399' AND od.language_id = '1' ORDER BY o.sort_order
0.00012111663818359SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 22399 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.00019192695617676SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=33' AND store_id = '0' AND language_id = '1'
0.00012993812561035SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014305114746094SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00025415420532227SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22399' AND store_id = '0' AND language_id = '1'
0.00011014938354492SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00012683868408203SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.0003199577331543SELECT 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 = '2440' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0013260841369629SELECT 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 = '2440' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00012803077697754SELECT * 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 = '2440' AND od.language_id = '1' ORDER BY o.sort_order
0.00012111663818359SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 2440 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.00019288063049316SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=58' AND store_id = '0' AND language_id = '1'
0.00012803077697754SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00014114379882812SELECT * FROM oc_seo_url WHERE `query` = 'product_id=2440' AND store_id = '0' AND language_id = '1'
0.00011086463928223SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.0001530647277832SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00024914741516113SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '21171' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016951560974121SELECT 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 = '21171' 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 = '21171' AND od.language_id = '1' ORDER BY o.sort_order
0.00012087821960449SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 21171 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.00018811225891113SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=25' AND store_id = '0' AND language_id = '1'
0.00012898445129395SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014591217041016SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00019407272338867SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21171' AND store_id = '0' AND language_id = '1'
0.00011587142944336SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00012993812561035SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00027704238891602SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '22029' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0013430118560791SELECT 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 = '22029' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0001370906829834SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '22029' AND od.language_id = '1' ORDER BY o.sort_order
0.00012302398681641SELECT 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 = 22029 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.00018191337585449SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=57' AND store_id = '0' AND language_id = '1'
0.00012803077697754SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00015711784362793SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00014209747314453SELECT * FROM oc_seo_url WHERE `query` = 'product_id=22029' AND store_id = '0' AND language_id = '1'
0.00010991096496582SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013113021850586SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00023698806762695SELECT 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 = '20943' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0013570785522461SELECT 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 = '20943' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00014591217041016SELECT * 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 = '20943' AND od.language_id = '1' ORDER BY o.sort_order
0.00012397766113281SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 20943 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00013995170593262SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019717216491699SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=25' AND store_id = '0' AND language_id = '1'
0.00013208389282227SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014710426330566SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00023794174194336SELECT * FROM oc_seo_url WHERE `query` = 'product_id=20943' AND store_id = '0' AND language_id = '1'
0.00012612342834473SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013303756713867SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
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 = '21096' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0015530586242676SELECT 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 = '21096' 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 = '21096' AND od.language_id = '1' ORDER BY o.sort_order
0.00012516975402832SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 21096 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00013995170593262SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019407272338867SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=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.00014710426330566SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21096' AND store_id = '0' AND language_id = '1'
0.00011301040649414SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013208389282227SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
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 = '20234' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0014708042144775SELECT 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 = '20234' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00013613700866699SELECT * 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 = '20234' AND od.language_id = '1' ORDER BY o.sort_order
0.00012683868408203SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 20234 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.00017285346984863SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=32' AND store_id = '0' AND language_id = '1'
0.00013113021850586SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014805793762207SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00026082992553711SELECT * FROM oc_seo_url WHERE `query` = 'product_id=20234' AND store_id = '0' AND language_id = '1'
0.00011396408081055SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013399124145508SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00025677680969238SELECT 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 = '21909' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.001331090927124SELECT 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 = '21909' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0013358592987061SELECT 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 = '21909' AND a.attribute_group_id = '7' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00010895729064941SELECT * 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 = '21909' 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 = 21909 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00013995170593262SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=0' AND store_id = '0' AND language_id = '1'
0.00012898445129395SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00026202201843262SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21909' AND store_id = '0' AND language_id = '1'
9.2983245849609E-5SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013494491577148SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
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 = '21183' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0016121864318848SELECT 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 = '21183' 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 = '21183' AND od.language_id = '1' ORDER BY o.sort_order
0.00012397766113281SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 21183 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019311904907227SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=25' AND store_id = '0' AND language_id = '1'
0.00013208389282227SELECT * FROM oc_seo_url WHERE `query` = 'product/product' 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.00018692016601562SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21183' AND store_id = '0' AND language_id = '1'
0.00011396408081055SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013208389282227SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00024509429931641SELECT 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 = '21965' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0013558864593506SELECT 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 = '21965' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00013399124145508SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '21965' AND od.language_id = '1' ORDER BY o.sort_order
0.00012397766113281SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 21965 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00014019012451172SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00020813941955566SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=82' AND store_id = '0' AND language_id = '1'
0.0001370906829834SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00012397766113281SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00028514862060547SELECT * FROM oc_seo_url WHERE `query` = 'product_id=21965' AND store_id = '0' AND language_id = '1'
8.9883804321289E-5SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013303756713867SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00026988983154297SELECT 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 = '21237' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0015809535980225SELECT 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 = '21237' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.00013399124145508SELECT * FROM oc_product_option po LEFT JOIN `oc_option` o ON (po.option_id = o.option_id) LEFT JOIN oc_option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '21237' AND od.language_id = '1' ORDER BY o.sort_order
0.00012683868408203SELECT rd.* FROM oc_product_recurring pr JOIN oc_recurring_description rd ON (rd.language_id = 1 AND rd.recurring_id = pr.recurring_id) JOIN oc_recurring r ON r.recurring_id = rd.recurring_id WHERE pr.product_id = 21237 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00021100044250488SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=95' AND store_id = '0' AND language_id = '1'
0.00013113021850586SELECT * FROM oc_seo_url WHERE `query` = 'product/product' AND store_id = '0' AND language_id = '1'
0.00014710426330566SELECT * 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_id=21237' AND store_id = '0' AND language_id = '1'
0.00011897087097168SELECT * FROM oc_customer_wishlist WHERE customer_id = '0'
0.00013518333435059SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00025105476379395SELECT ag.attribute_group_id, agd.name FROM oc_product_attribute pa LEFT JOIN oc_attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN oc_attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN oc_attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '20769' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0015628337860107SELECT 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 = '20769' AND a.attribute_group_id = '9' AND ad.language_id = '1' AND pa.language_id = '1' ORDER BY a.sort_order, ad.name
0.0001368522644043SELECT * 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 = '20769' 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 = 20769 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.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=108' 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.00014901161193848SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.0001838207244873SELECT * FROM oc_seo_url WHERE `query` = 'product_id=20769' 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.00014996528625488SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.0001678466796875SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014901161193848SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014686584472656SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014615058898926SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00014376640319824SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014615058898926SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014495849609375SELECT * 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/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.00016593933105469SELECT * 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.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001218318939209SELECT * FROM oc_seo_url WHERE `query` = 'category_id=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.00014305114746094SELECT * 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.00014495849609375SELECT * 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/category' AND store_id = '0' AND language_id = '1'
0.00014281272888184SELECT * 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.00014090538024902SELECT * 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.0001680850982666SELECT * 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.00016283988952637SELECT * 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.00016593933105469SELECT * 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.00017189979553223SELECT * 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.00017094612121582SELECT * 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.00017213821411133SELECT * 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.00017189979553223SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00011801719665527SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00014376640319824SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.0001678466796875SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015592575073242SELECT * 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.00014400482177734SELECT * 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/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.00014591217041016SELECT * 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.00016999244689941SELECT * 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=18' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014781951904297SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014805793762207SELECT * 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/category' AND store_id = '0' AND language_id = '1'
0.00012016296386719SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014686584472656SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00017189979553223SELECT * FROM oc_seo_url WHERE `query` = '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.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00014686584472656SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00018191337585449SELECT * FROM oc_seo_url WHERE `query` = 'product/category' 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.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001220703125SELECT * 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/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.00017213821411133SELECT * 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.00016903877258301SELECT * 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.00017094612121582SELECT * 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.00014495849609375SELECT * 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.00014495849609375SELECT * 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.00012111663818359SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014710426330566SELECT * 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/category' 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.00015115737915039SELECT * 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.00021815299987793SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017714500427246SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00021719932556152SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019598007202148SELECT * 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.00019502639770508SELECT * 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.00019407272338867SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00021886825561523SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018405914306641SELECT * 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.00019192695617676SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00023508071899414SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001978874206543SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00021219253540039SELECT * 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.00021600723266602SELECT * 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.00021505355834961SELECT * FROM oc_seo_url WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_category_to_layout WHERE category_id = '18' AND store_id = '0'
0.00018119812011719SELECT * FROM oc_layout_module WHERE layout_id = '145' AND position = 'column_left' ORDER BY sort_order
0.00017309188842773SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/bsfilter' OR route = 'ru-ru')
0.00023508071899414SELECT * 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.00024008750915527SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00021719932556152SELECT * 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.0001990795135498SELECT * 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.00017189979553223SELECT * 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.00018596649169922SELECT * 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.00019001960754395SELECT * 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.00018692016601562SELECT * 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.00018095970153809SELECT * 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.00024986267089844SELECT * 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.00022006034851074SELECT * 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.00017499923706055SELECT * 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.00018906593322754SELECT * 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.00018882751464844SELECT * 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.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00017809867858887SELECT * 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.00020909309387207SELECT * 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=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.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.00018787384033203SELECT * 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.00020980834960938SELECT * 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.00023889541625977SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00023722648620605SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'category_id=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.00022101402282715SELECT * 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.00019598007202148SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00019693374633789SELECT * 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.00016307830810547SELECT * 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/category' AND store_id = '0' AND language_id = '1'
0.00021100044250488SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00022602081298828SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019598007202148SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' 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.00019192695617676SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00025391578674316SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019097328186035SELECT * 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.00021815299987793SELECT * 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.00022792816162109SELECT * 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.00019192695617676SELECT * 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.00019502639770508SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00023102760314941SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00025105476379395SELECT * 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.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.00019502639770508SELECT * 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.0001978874206543SELECT * 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.00019192695617676SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00019097328186035SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00020384788513184SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018906593322754SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00211501121521SELECT * 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.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.015366077423096SELECT 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.0002739429473877SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00022315979003906SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' AND store_id = '0' AND language_id = '1'
0.014105081558228SELECT 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.0017650127410889SELECT * 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.000244140625SELECT * 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.00026488304138184SELECT * FROM oc_seo_url WHERE `query` = 'category_id=252' AND store_id = '0' AND language_id = '1'
0.021993160247803SELECT 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.00024580955505371SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00021910667419434SELECT * 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` = 'category_id=259' 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 = '259'
0.00020194053649902SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.0001981258392334SELECT * FROM oc_seo_url WHERE `query` = 'category_id=298' AND store_id = '0' AND language_id = '1'
0.013153076171875SELECT 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.0002291202545166SELECT * 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.00019502639770508SELECT * FROM oc_seo_url WHERE `query` = 'category_id=289' AND store_id = '0' AND language_id = '1'
0.013919830322266SELECT 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.00028800964355469SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00023484230041504SELECT * FROM oc_seo_url WHERE `query` = 'category_id=364' AND store_id = '0' AND language_id = '1'
0.012331962585449SELECT 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.00023818016052246SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.026778936386108SELECT COUNT(DISTINCT p.product_id) AS total FROM oc_category_path cp LEFT JOIN oc_product_to_category p2c ON (cp.category_id = p2c.category_id) LEFT JOIN oc_product p ON (p2c.product_id = p.product_id) LEFT JOIN oc_product_description pd ON (p.product_id = pd.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0' AND cp.path_id = '18'
0.00023889541625977SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018715858459473SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.014687061309814SELECT 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.0001978874206543SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017809867858887SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.018171072006226SELECT 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.00020194053649902SELECT * 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=205' AND store_id = '0' AND language_id = '1'
0.012386083602905SELECT 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.00019693374633789SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00022697448730469SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.012304067611694SELECT 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.00020003318786621SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.018278121948242SELECT 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.0001978874206543SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017809867858887SELECT * FROM oc_seo_url WHERE `query` = 'category_id=221' AND store_id = '0' AND language_id = '1'
0.012359857559204SELECT 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.00021505355834961SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'extension/module/bsfilter'
0.00011610984802246SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/category_description' OR route = 'ru-ru')
0.00018596649169922SELECT 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.0018119812011719SELECT * 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.00018811225891113SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'extension/module/category_description'
0.0002598762512207SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/column_left'
0.00021982192993164SELECT * FROM oc_category_to_layout WHERE category_id = '18' AND store_id = '0'
0.00019979476928711SELECT * FROM oc_layout_module WHERE layout_id = '145' AND position = 'column_right' ORDER BY sort_order
0.00017595291137695SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/column_right'
9.8943710327148E-5SELECT * 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.0002129077911377SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/content_top'
0.00016689300537109SELECT * FROM oc_category_to_layout WHERE category_id = '18' AND store_id = '0'
0.00018811225891113SELECT * FROM oc_layout_module WHERE layout_id = '145' AND position = 'content_bottom' ORDER BY sort_order
0.00018191337585449SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/content_bottom'
0.00018811225891113SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru')
0.00010991096496582SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/social' OR route = 'ru-ru')
0.00017285346984863SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'extension/module/social_icons'
0.00017595291137695SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')
0.0001978874206543SELECT * FROM oc_seo_url WHERE `query` = 'common/language/language' AND store_id = '0' AND language_id = '1'
0.00013589859008789SELECT * FROM oc_language WHERE status = '1' ORDER BY sort_order, name
0.00018906593322754SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001680850982666SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * 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.00017809867858887SELECT * FROM oc_seo_url WHERE `query` = 'common/currency/currency' 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.00012803077697754SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00017285346984863SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/currency'
0.0020291805267334SELECT * 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.00020217895507812SELECT * 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=172' 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.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' AND store_id = '0' AND language_id = '1'
0.00018715858459473SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016283988952637SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013613700866699SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' 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.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=205' 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.00022292137145996SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.00018310546875SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015616416931152SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' 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.00016903877258301SELECT * FROM oc_seo_url WHERE `query` = 'category_id=221' AND store_id = '0' AND language_id = '1'
0.0018930435180664SELECT * 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.00018906593322754SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00017309188842773SELECT * FROM oc_seo_url WHERE `query` = 'information_id=67' AND store_id = '0' AND language_id = '1'
0.00012993812561035SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00016403198242188SELECT * FROM oc_seo_url WHERE `query` = 'information_id=77' AND store_id = '0' AND language_id = '1'
0.0001521110534668SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00015807151794434SELECT * FROM oc_seo_url WHERE `query` = 'information_id=68' AND store_id = '0' AND language_id = '1'
0.0001518726348877SELECT * 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=73' AND store_id = '0' AND language_id = '1'
0.0001521110534668SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'information_id=64' AND store_id = '0' AND language_id = '1'
0.00014805793762207SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00015592575073242SELECT * FROM oc_seo_url WHERE `query` = 'information_id=66' AND store_id = '0' AND language_id = '1'
0.00014686584472656SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00013399124145508SELECT * FROM oc_seo_url WHERE `query` = 'information_id=65' AND store_id = '0' AND language_id = '1'
0.00015902519226074SELECT * 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.00015807151794434SELECT * FROM oc_seo_url WHERE `query` = 'information/sitemap' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * FROM oc_seo_url WHERE `query` = 'information/tracking' AND store_id = '0' AND language_id = '1'
0.00013494491577148SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer' AND store_id = '0' AND language_id = '1'
0.0001378059387207SELECT * FROM oc_seo_url WHERE `query` = 'account/voucher' AND store_id = '0' AND language_id = '1'
0.0001370906829834SELECT * FROM oc_seo_url WHERE `query` = 'affiliate/login' AND store_id = '0' AND language_id = '1'
0.00013399124145508SELECT * FROM oc_seo_url WHERE `query` = 'product/special' AND store_id = '0' AND language_id = '1'
0.00012993812561035SELECT * FROM oc_seo_url WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
0.00013208389282227SELECT * FROM oc_seo_url WHERE `query` = 'account/order' AND store_id = '0' AND language_id = '1'
0.00011110305786133SELECT * FROM oc_seo_url WHERE `query` = 'account/wishlist' AND store_id = '0' AND language_id = '1'
0.0001380443572998SELECT * FROM oc_seo_url WHERE `query` = 'account/newsletter' AND store_id = '0' AND language_id = '1'
0.00012898445129395SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'theme/bodysport' OR route = 'ru-ru')
0.00012707710266113SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/subscribe' OR route = 'ru-ru')
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'
0.00019192695617676DELETE FROM `oc_customer_online` WHERE date_added < '2024-04-18 18:51:54'
0.00011610984802246REPLACE INTO `oc_customer_online` SET `ip` = '44.201.97.0', `customer_id` = '0', `url` = 'https://ndplay.ru/posuda/price/18-1979/10018/10340?page=4', `referer` = '', `date_added` = '2024-04-18 19:51:54'
0.00015902519226074SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/footer'
0.0001828670501709SELECT * FROM oc_extension WHERE `type` = 'analytics'
0.00018811225891113SELECT * FROM oc_seo_url WHERE `query` = 'style/setting' AND store_id = '0' AND language_id = '1'
0.0001678466796875SELECT * FROM oc_seo_url WHERE `query` = 'style/setting' AND store_id = '0' AND language_id = '1'
0.00014591217041016SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
0.00016212463378906SELECT * FROM oc_seo_url WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
0.00015401840209961SELECT * FROM oc_seo_url WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'
0.00014591217041016SELECT * FROM oc_seo_url WHERE `query` = 'common/home' AND store_id = '0' AND language_id = '1'
0.0001530647277832SELECT * FROM oc_seo_url WHERE `query` = 'account/wishlist' AND store_id = '0' AND language_id = '1'
0.00014996528625488SELECT * FROM oc_seo_url WHERE `query` = 'account/account' AND store_id = '0' AND language_id = '1'
0.00015497207641602SELECT * FROM oc_seo_url WHERE `query` = 'account/register' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * FROM oc_seo_url WHERE `query` = 'account/login' AND store_id = '0' AND language_id = '1'
0.00011181831359863SELECT * FROM oc_seo_url WHERE `query` = 'account/order' AND store_id = '0' AND language_id = '1'
0.0001521110534668SELECT * FROM oc_seo_url WHERE `query` = 'account/transaction' AND store_id = '0' AND language_id = '1'
0.0001530647277832SELECT * FROM oc_seo_url WHERE `query` = 'account/download' AND store_id = '0' AND language_id = '1'
0.0001518726348877SELECT * FROM oc_seo_url WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'
0.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'
0.00020480155944824SELECT * FROM oc_seo_url WHERE `query` = 'checkout/checkout' AND store_id = '0' AND language_id = '1'
0.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'information/contact' AND store_id = '0' AND language_id = '1'
0.00017786026000977SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/text_loading'
0.00015497207641602SELECT * FROM oc_seo_url WHERE `query` = 'account/edit' AND store_id = '0' AND language_id = '1'
0.00011396408081055SELECT * FROM oc_seo_url WHERE `query` = 'account/address' AND store_id = '0' AND language_id = '1'
0.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'account/reward' AND store_id = '0' AND language_id = '1'
0.0001528263092041SELECT * FROM oc_seo_url WHERE `query` = 'account/return' AND store_id = '0' AND language_id = '1'
0.00012302398681641SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')
0.00017809867858887SELECT * FROM oc_seo_url WHERE `query` = 'common/language/language' AND store_id = '0' AND language_id = '1'
0.00013518333435059SELECT * FROM oc_language WHERE status = '1' ORDER BY sort_order, name
0.00022006034851074SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018692016601562SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00018191337585449SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/language'
0.00019311904907227SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
0.00023603439331055SELECT * FROM oc_seo_url WHERE `query` = 'common/currency/currency' AND store_id = '0' AND language_id = '1'
0.00021505355834961SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00021910667419434SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00025701522827148SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/currency'
0.00018692016601562SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru')
0.00021004676818848SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/search'
0.00018882751464844SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')
0.00022387504577637SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00013589859008789SELECT * FROM oc_extension WHERE `type` = 'total'
0.00018405914306641SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru')
0.00014209747314453SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00016403198242188SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00016617774963379SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/credit' OR route = 'ru-ru')
0.00014686584472656SELECT SUM(amount) AS total FROM oc_customer_transaction WHERE customer_id = '0'
0.00016307830810547SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru')
0.00016593933105469SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00016307830810547SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'f7b001af990094f470fdfdb85e'
0.00022006034851074SELECT * FROM oc_seo_url WHERE `query` = 'checkout/cart' AND store_id = '0' AND language_id = '1'
0.00020790100097656SELECT * 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.00016212463378906SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/menu' OR route = 'ru-ru')
0.0021190643310547SELECT * 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.0017130374908447SELECT * 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.00023889541625977SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020790100097656SELECT * 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=25' AND store_id = '0' AND language_id = '1'
0.00026392936706543SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020599365234375SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00020599365234375SELECT * FROM oc_seo_url WHERE `query` = 'category_id=117' 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.0002439022064209SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.0002129077911377SELECT * FROM oc_seo_url WHERE `query` = 'category_id=195' 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.00021004676818848SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00022602081298828SELECT * FROM oc_seo_url WHERE `query` = 'category_id=238' AND store_id = '0' AND language_id = '1'
0.00022697448730469SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020790100097656SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00027203559875488SELECT * FROM oc_seo_url WHERE `query` = 'category_id=68' AND store_id = '0' AND language_id = '1'
0.00023198127746582SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00020885467529297SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.0002131462097168SELECT * FROM oc_seo_url WHERE `query` = 'category_id=242' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018596649169922SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00020217895507812SELECT * FROM oc_seo_url WHERE `query` = 'category_id=245' 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.00020194053649902SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'category_id=204' AND store_id = '0' AND language_id = '1'
0.00018811225891113SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016188621520996SELECT * FROM oc_seo_url WHERE `query` = 'category_id=172' AND store_id = '0' AND language_id = '1'
0.0015869140625SELECT * 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.00020194053649902SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' AND store_id = '0' AND language_id = '1'
0.00020503997802734SELECT * FROM oc_seo_url WHERE `query` = 'category_id=389' 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.00020217895507812SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'category_id=210' AND store_id = '0' AND language_id = '1'
0.00019502639770508SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' AND store_id = '0' AND language_id = '1'
0.00021505355834961SELECT * FROM oc_seo_url WHERE `query` = 'category_id=371' 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.00017786026000977SELECT * FROM oc_seo_url WHERE `query` = 'category_id=223' AND store_id = '0' AND language_id = '1'
0.0018019676208496SELECT * 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.00023794174194336SELECT * 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.00018596649169922SELECT * FROM oc_seo_url WHERE `query` = 'category_id=252' 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.00016498565673828SELECT * 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` = 'category_id=259' AND store_id = '0' AND language_id = '1'
0.00018215179443359SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00019288063049316SELECT * FROM oc_seo_url WHERE `query` = 'category_id=298' AND store_id = '0' AND language_id = '1'
0.00017309188842773SELECT * 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.00019288063049316SELECT * FROM oc_seo_url WHERE `query` = 'category_id=289' AND store_id = '0' AND language_id = '1'
0.00018191337585449SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016283988952637SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.00019121170043945SELECT * FROM oc_seo_url WHERE `query` = 'category_id=364' AND store_id = '0' AND language_id = '1'
0.00018715858459473SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016093254089355SELECT * FROM oc_seo_url WHERE `query` = 'category_id=18' AND store_id = '0' AND language_id = '1'
0.0017600059509277SELECT * 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.00020384788513184SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001828670501709SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00015783309936523SELECT * FROM oc_seo_url WHERE `query` = 'category_id=227' AND store_id = '0' AND language_id = '1'
0.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00019407272338867SELECT * FROM oc_seo_url WHERE `query` = 'category_id=301' 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.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00019192695617676SELECT * FROM oc_seo_url WHERE `query` = 'category_id=300' 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.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'category_id=250' 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.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'category_id=256' AND store_id = '0' AND language_id = '1'
0.00018215179443359SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00018405914306641SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.00020313262939453SELECT * FROM oc_seo_url WHERE `query` = 'category_id=305' AND store_id = '0' AND language_id = '1'
0.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'category_id=230' AND store_id = '0' AND language_id = '1'
0.0017929077148438SELECT * 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.00020122528076172SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00023102760314941SELECT * FROM oc_seo_url WHERE `query` = 'category_id=65' AND store_id = '0' AND language_id = '1'
0.0001838207244873SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001978874206543SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00020289421081543SELECT * FROM oc_seo_url WHERE `query` = 'category_id=326' 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.00016617774963379SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'category_id=185' 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.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00020003318786621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=327' 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.00019693374633789SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.00020790100097656SELECT * FROM oc_seo_url WHERE `query` = 'category_id=345' AND store_id = '0' AND language_id = '1'
0.00018215179443359SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016689300537109SELECT * FROM oc_seo_url WHERE `query` = 'category_id=20' AND store_id = '0' AND language_id = '1'
0.0017671585083008SELECT * 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.00020003318786621SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'category_id=205' AND store_id = '0' AND language_id = '1'
0.00022006034851074SELECT * FROM oc_seo_url WHERE `query` = 'category_id=370' AND store_id = '0' AND language_id = '1'
0.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001680850982666SELECT * FROM oc_seo_url WHERE `query` = 'category_id=205' AND store_id = '0' AND language_id = '1'
0.00017285346984863SELECT * FROM oc_seo_url WHERE `query` = 'category_id=228' AND store_id = '0' AND language_id = '1'
0.00018191337585449SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0001680850982666SELECT * FROM oc_seo_url WHERE `query` = 'category_id=205' AND store_id = '0' AND language_id = '1'
0.0017499923706055SELECT * 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.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.0002288818359375SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.00026202201843262SELECT * FROM oc_seo_url WHERE `query` = 'category_id=397' 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.00022315979003906SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.00022101402282715SELECT * FROM oc_seo_url WHERE `query` = 'category_id=398' AND store_id = '0' AND language_id = '1'
0.00021791458129883SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00022101402282715SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.00022411346435547SELECT * FROM oc_seo_url WHERE `query` = 'category_id=399' AND store_id = '0' AND language_id = '1'
0.00018310546875SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00025606155395508SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
0.00021982192993164SELECT * FROM oc_seo_url WHERE `query` = 'category_id=400' 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.00022387504577637SELECT * FROM oc_seo_url WHERE `query` = 'category_id=396' AND store_id = '0' AND language_id = '1'
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 = '162' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
0.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00014495849609375SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00021696090698242SELECT * FROM oc_seo_url WHERE `query` = 'category_id=346' AND store_id = '0' AND language_id = '1'
0.00018787384033203SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015807151794434SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00020909309387207SELECT * FROM oc_seo_url WHERE `query` = 'category_id=347' 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.00015807151794434SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00021100044250488SELECT * FROM oc_seo_url WHERE `query` = 'category_id=348' AND store_id = '0' AND language_id = '1'
0.00018596649169922SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00017285346984863SELECT * FROM oc_seo_url WHERE `query` = 'category_id=178' AND store_id = '0' AND language_id = '1'
0.00018119812011719SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00015807151794434SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.00015616416931152SELECT * FROM oc_seo_url WHERE `query` = 'category_id=111' AND store_id = '0' AND language_id = '1'
0.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'product/category' AND store_id = '0' AND language_id = '1'
0.00016093254089355SELECT * FROM oc_seo_url WHERE `query` = 'category_id=162' AND store_id = '0' AND language_id = '1'
0.0017940998077393SELECT * 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.00020599365234375SELECT * 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=221' AND store_id = '0' AND language_id = '1'
0.0002281665802002SELECT * FROM oc_seo_url WHERE `query` = 'category_id=394' 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.00017309188842773SELECT * FROM oc_seo_url WHERE `query` = 'category_id=221' AND store_id = '0' AND language_id = '1'
0.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'category_id=222' 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.00014901161193848SELECT * FROM oc_seo_url WHERE `query` = 'category_id=221' AND store_id = '0' AND language_id = '1'
0.00016093254089355SELECT * FROM oc_seo_url WHERE `query` = 'category_id=102' 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.00017213821411133SELECT * FROM oc_seo_url WHERE `query` = 'category_id=221' AND store_id = '0' AND language_id = '1'
0.0001838207244873SELECT * FROM oc_seo_url WHERE `query` = 'product/catalog' AND store_id = '0' AND language_id = '1'
0.00018215179443359SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/menu'
0.00013589859008789SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/brands' OR route = 'ru-ru')
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019383430480957SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=120' AND store_id = '0' AND language_id = '1'
0.00013184547424316SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019693374633789SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=147' AND store_id = '0' AND language_id = '1'
0.00014996528625488SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019288063049316SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=142' AND store_id = '0' AND language_id = '1'
0.00014710426330566SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00020503997802734SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=32' 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.00018501281738281SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=113' 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.0001981258392334SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=177' AND store_id = '0' AND language_id = '1'
0.00015521049499512SELECT * 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=114' 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.00019288063049316SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=140' 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.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=121' 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.00019502639770508SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=163' 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.0001680850982666SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=123' 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.00020003318786621SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=18' AND store_id = '0' AND language_id = '1'
0.00014591217041016SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019001960754395SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=132' AND store_id = '0' AND language_id = '1'
0.00015497207641602SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019407272338867SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=158' 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.00020694732666016SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=61' 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.00020408630371094SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=33' 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.00020790100097656SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=73' AND store_id = '0' AND language_id = '1'
0.00014519691467285SELECT * 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=74' 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.00017786026000977SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=173' 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.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=122' AND store_id = '0' AND language_id = '1'
9.8943710327148E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019717216491699SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=26' AND store_id = '0' AND language_id = '1'
0.00012707710266113SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018596649169922SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=75' 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.0001828670501709SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=65' 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.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=48' AND store_id = '0' AND language_id = '1'
0.0001220703125SELECT * 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=164' 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=124' 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.00017499923706055SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=175' AND store_id = '0' AND language_id = '1'
0.00012707710266113SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018787384033203SELECT * 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.00017404556274414SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=168' 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.00017189979553223SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=166' 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.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=125' 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.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=49' AND store_id = '0' AND language_id = '1'
0.00012397766113281SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014901161193848SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=167' 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.00019598007202148SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=146' AND store_id = '0' AND language_id = '1'
9.8943710327148E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017094612121582SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=77' AND store_id = '0' AND language_id = '1'
9.918212890625E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001680850982666SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=78' 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.00014996528625488SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=133' AND store_id = '0' AND language_id = '1'
0.00015997886657715SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00013899803161621SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=116' AND store_id = '0' AND language_id = '1'
9.918212890625E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014591217041016SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=155' 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.00013613700866699SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=111' AND store_id = '0' AND language_id = '1'
9.8943710327148E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00019502639770508SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=79' 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.00017309188842773SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=136' 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.0001530647277832SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=176' AND store_id = '0' AND language_id = '1'
9.918212890625E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014305114746094SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=131' AND store_id = '0' AND language_id = '1'
9.918212890625E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001518726348877SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=169' AND store_id = '0' AND language_id = '1'
9.8943710327148E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014805793762207SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=165' AND store_id = '0' AND language_id = '1'
9.8943710327148E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016593933105469SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=80' AND store_id = '0' AND language_id = '1'
9.8943710327148E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00017118453979492SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=128' 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.0002739429473877SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=25' 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.00014090538024902SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=115' 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.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=81' 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.0001530647277832SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=22' AND store_id = '0' AND language_id = '1'
9.8943710327148E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015783309936523SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=57' AND store_id = '0' AND language_id = '1'
0.00010299682617188SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015902519226074SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=50' 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.00014400482177734SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=141' 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=29' 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.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=82' AND store_id = '0' AND language_id = '1'
9.8943710327148E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001370906829834SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=109' AND store_id = '0' AND language_id = '1'
9.9897384643555E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001380443572998SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=110' 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.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=83' AND store_id = '0' AND language_id = '1'
9.8943710327148E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016498565673828SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=84' AND store_id = '0' AND language_id = '1'
9.8943710327148E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00014615058898926SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=143' 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.0001370906829834SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=112' AND store_id = '0' AND language_id = '1'
9.8943710327148E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001671314239502SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=85' 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.00014710426330566SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=150' 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.00018095970153809SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=86' AND store_id = '0' AND language_id = '1'
0.00010013580322266SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015711784362793SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=51' AND store_id = '0' AND language_id = '1'
9.8943710327148E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015902519226074SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=60' AND store_id = '0' AND language_id = '1'
0.00012993812561035SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016689300537109SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=87' AND store_id = '0' AND language_id = '1'
0.00010013580322266SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001680850982666SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=88' AND store_id = '0' AND language_id = '1'
9.7990036010742E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00013303756713867SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=101' AND store_id = '0' AND language_id = '1'
0.00013089179992676SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016188621520996SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=72' AND store_id = '0' AND language_id = '1'
9.8943710327148E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=89' AND store_id = '0' AND language_id = '1'
9.918212890625E-5SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00016999244689941SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=90' AND store_id = '0' AND language_id = '1'
0.00012707710266113SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015711784362793SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=52' 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.00014090538024902SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=117' 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.00018000602722168SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=172' AND store_id = '0' AND language_id = '1'
0.00014114379882812SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0002741813659668SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=58' AND store_id = '0' AND language_id = '1'
0.00011801719665527SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.0001680850982666SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=91' AND store_id = '0' AND language_id = '1'
0.00011706352233887SELECT * 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=97' AND store_id = '0' AND language_id = '1'
0.0001368522644043SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00020408630371094SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=119' 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.00018596649169922SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=55' AND store_id = '0' AND language_id = '1'
0.00014519691467285SELECT * 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=28' 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.00021600723266602SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=70' AND store_id = '0' AND language_id = '1'
0.00017809867858887SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00018692016601562SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=92' AND store_id = '0' AND language_id = '1'
0.00010585784912109SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00015687942504883SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=170' 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.00016117095947266SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=56' 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.00018787384033203SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=93' 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.00025010108947754SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=94' AND store_id = '0' AND language_id = '1'
0.00017595291137695SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00021696090698242SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=95' AND store_id = '0' AND language_id = '1'
0.00014686584472656SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer/info' AND store_id = '0' AND language_id = '1'
0.00024986267089844SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=96' 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.00024104118347168SELECT * FROM oc_seo_url WHERE `query` = 'manufacturer_id=69' AND store_id = '0' AND language_id = '1'
0.00016093254089355SELECT * FROM oc_seo_url WHERE `query` = 'product/manufacturer' AND store_id = '0' AND language_id = '1'
0.00015091896057129SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/brands'
0.0001978874206543SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.00015115737915039SELECT * FROM oc_seo_url WHERE `query` = 'information_id=64' AND store_id = '0' AND language_id = '1'
0.00013303756713867SELECT * FROM oc_seo_url WHERE `query` = 'information/information' AND store_id = '0' AND language_id = '1'
0.0001370906829834SELECT * FROM oc_seo_url WHERE `query` = 'information_id=65' AND store_id = '0' AND language_id = '1'
0.0001370906829834SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'extension/module/menu'
0.0001060962677002SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/quicksignup' OR route = 'ru-ru')
0.00011992454528809SELECT * FROM oc_seo_url WHERE `query` = 'account/edit' AND store_id = '0' AND language_id = '1'
0.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'account/register' AND store_id = '0' AND language_id = '1'
0.0001990795135498SELECT * FROM oc_seo_url WHERE `query` = 'account/login' AND store_id = '0' AND language_id = '1'
0.0001988410949707SELECT * FROM oc_seo_url WHERE `query` = 'account/logout' AND store_id = '0' AND language_id = '1'
0.00020098686218262SELECT * FROM oc_seo_url WHERE `query` = 'account/forgotten' AND store_id = '0' AND language_id = '1'
0.00020599365234375SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/quicksignup'
0.00020503997802734SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'common/header'
0.00021100044250488SELECT * FROM oc_theme WHERE store_id = '0' AND theme = 'bodysport' AND route = 'product/category'