Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 20Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 28Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 20Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 28Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 20Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 28Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 20Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 28Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 20Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 28Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 20Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 28Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 20Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 28Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 20Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 28Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 20Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 28Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 20Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 28Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 20Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 28Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 20Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 28Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 20Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 28Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 20Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 28Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 20Notice: Undefined index: OCSESSID in /var/www/vhosts/tehnovse.ru/terminal.tehnovse.ru/system/storage/modification/system/library/db/mysqli.php on line 28 Отвод канализационный 40х67 град.

ВАШ АДРЕС МАГАЗИНА

ВРЕМЯ РАБОТЫ ВАШЕГО МАГАЗИНА с 9-00 до 20 - 00

tvoyapochta@tvoyapochta.ru +7 (999) 999-9999
ВАШЕ НАИМЕНОВАНИЕ МАГАЗИНА

Отвод канализационный 40х67 град.Артикул: 10695458

Цена, р. 48р.
Производитель:  Ostendorf

Доступно для заказа: много

Гарантия

Гарантия сервисного центра производителя
Товар сертифицирован
Гарантия производителя: 36 мес.

Debug SQL
0.00072002410888672SELECT `data` FROM `oc_session` WHERE session_id = '9b5248101752ed9f319bc58a63' AND expire > 1751433672
0.00036096572875977SELECT * FROM oc_extension WHERE `type` = 'openbay'
0.00034785270690918SELECT * FROM oc_translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
0.00026988983154297SELECT * FROM oc_extension WHERE `type` = 'openbay'
0.00081992149353027SELECT `data` FROM `oc_session` WHERE session_id = '1938a8e477d7a4f2094c7d3d0e' AND expire > 1751433672
0.00028204917907715SELECT * FROM oc_store WHERE REPLACE(`ssl`, 'www.', '') = 'https://tvoymagazin.terminal.tehnovse.ru/'
0.00047421455383301SELECT * FROM `oc_setting` WHERE store_id = '0' OR store_id = '100' ORDER BY store_id ASC
0.00035810470581055SELECT * FROM oc_language WHERE status = '1' ORDER BY sort_order, name
0.00034213066101074SELECT * FROM oc_currency
0.00022387504577637SELECT 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 = '2761') ORDER BY tr1.priority ASC
0.00026416778564453SELECT * 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.00026082992553711SELECT * 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.00047421455383301DELETE FROM oc_cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 1 HOUR)
0.00037288665771484SELECT * FROM oc_translation WHERE store_id = '100' AND language_id = '1' AND (route = 'extension/module/ocfilter' OR route = 'ru-ru')
0.0003969669342041SELECT * FROM oc_extension WHERE `type` = 'openbay'
0.00038695335388184SELECT * FROM `oc_event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC
0.0003819465637207SELECT * FROM oc_translation WHERE store_id = '100' AND language_id = '1' AND (route = 'product/product' OR route = 'ru-ru')
0.00029087066650391SELECT 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 = '1297' AND cd.language_id = '1' AND c2s.store_id = '100' AND c.status = '1'
0.0020699501037598SELECT DISTINCT *, p2s.price as price, p2s.quantity as quantity, p2s.is_special as is_special, p2s.is_hit as is_hit, p2s.special_percent as special_percent, p2s.status as status, pd.name AS name, p.image, p.noindex AS noindex, m.name AS manufacturer, (SELECT cd.name FROM oc_product_to_category p2c LEFT JOIN oc_category_description cd ON(p2c.category_id=cd.category_id) WHERE p.product_id=p2c.product_id LIMIT 1) as category, (SELECT p2c.category_id FROM oc_product_to_category p2c WHERE p.product_id=p2c.product_id LIMIT 1) as category_id, (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 = '3069130' AND pd.language_id = '1' AND p2s.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '100'
0.00069785118103027SELECT * FROM oc_product_discount WHERE product_id = '3069130' AND customer_group_id = '1' AND quantity > 1 AND ((date_start = '0000-00-00' OR date_start < NOW()) AND (date_end = '0000-00-00' OR date_end > NOW())) ORDER BY quantity ASC, priority ASC, price ASC
0.0020389556884766SELECT * 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 = '3069130' AND od.language_id = '1' ORDER BY o.sort_order
0.00075912475585938SELECT 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 = '3069130' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
0.0009009838104248SELECT * FROM oc_product_related pr LEFT JOIN oc_product p ON (pr.related_id = p.product_id) LEFT JOIN oc_product_to_store p2s ON (p.product_id = p2s.product_id) WHERE pr.product_id = '3069130' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '100'
0.0006721019744873SELECT 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 = 3069130 AND status = '1' AND pr.customer_group_id = '1' ORDER BY sort_order ASC
0.00094699859619141UPDATE oc_product SET viewed = (viewed + 1) WHERE product_id = '3069130'
0.00047993659973145SELECT * FROM oc_product_to_layout WHERE product_id = '3069130' AND store_id = '100'
0.0002601146697998SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '100' ORDER BY route DESC LIMIT 1
0.00026798248291016SELECT * FROM oc_layout_module WHERE layout_id = '2' AND position = 'column_left' ORDER BY sort_order
0.00029683113098145SELECT * FROM oc_theme WHERE store_id = '100' AND theme = 'terminal' AND route = 'common/column_left'
0.00029397010803223SELECT * FROM oc_product_to_layout WHERE product_id = '3069130' AND store_id = '100'
0.00026583671569824SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '100' ORDER BY route DESC LIMIT 1
0.00023794174194336SELECT * FROM oc_layout_module WHERE layout_id = '2' AND position = 'column_right' ORDER BY sort_order
0.00031900405883789SELECT * FROM oc_theme WHERE store_id = '100' AND theme = 'terminal' AND route = 'common/column_right'
0.00027894973754883SELECT * FROM oc_product_to_layout WHERE product_id = '3069130' AND store_id = '100'
0.00026297569274902SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '100' ORDER BY route DESC LIMIT 1
0.00024700164794922SELECT * FROM oc_layout_module WHERE layout_id = '2' AND position = 'content_top' ORDER BY sort_order
0.00023794174194336SELECT * FROM oc_theme WHERE store_id = '100' AND theme = 'terminal' AND route = 'common/content_top'
0.00028419494628906SELECT * FROM oc_product_to_layout WHERE product_id = '3069130' AND store_id = '100'
0.00027680397033691SELECT * FROM oc_layout_route WHERE 'product/product' LIKE route AND store_id = '100' ORDER BY route DESC LIMIT 1
0.00027608871459961SELECT * FROM oc_layout_module WHERE layout_id = '2' AND position = 'content_bottom' ORDER BY sort_order
0.00023102760314941SELECT * FROM oc_module WHERE module_id = '34'
0.00028705596923828SELECT * FROM oc_translation WHERE store_id = '100' AND language_id = '1' AND (route = 'extension/module/featured_article' OR route = 'ru-ru')
0.00078415870666504SELECT * FROM oc_product_related_article np LEFT JOIN oc_article p ON (np.article_id = p.article_id) LEFT JOIN oc_article_to_store p2s ON (p.article_id = p2s.article_id) WHERE np.product_id = '3069130' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '100' LIMIT 4
0.00029492378234863SELECT * FROM oc_theme WHERE store_id = '100' AND theme = 'terminal' AND route = 'common/content_bottom'
0.00028705596923828SELECT * FROM oc_translation WHERE store_id = '100' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru')
0.00028109550476074SELECT * 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 = '100' AND i.status = '1' ORDER BY i.sort_order, LCASE(id.title) ASC
0.00029206275939941SELECT * FROM oc_theme WHERE store_id = '100' AND theme = 'terminal' AND route = 'common/footer'
0.00028705596923828SELECT * FROM oc_extension WHERE `type` = 'analytics'
0.00035810470581055SELECT * FROM oc_translation WHERE store_id = '100' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
0.00029110908508301SELECT * FROM oc_translation WHERE store_id = '100' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')
0.00025510787963867SELECT * FROM oc_language WHERE status = '1' ORDER BY sort_order, name
0.00028395652770996SELECT * FROM oc_theme WHERE store_id = '100' AND theme = 'terminal' AND route = 'common/language'
0.00028514862060547SELECT * FROM oc_translation WHERE store_id = '100' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
0.00026392936706543SELECT * FROM oc_theme WHERE store_id = '100' AND theme = 'terminal' AND route = 'common/currency'
0.00028705596923828SELECT * FROM oc_translation WHERE store_id = '100' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
0.00027179718017578SELECT * FROM oc_theme WHERE store_id = '100' AND theme = 'terminal' AND route = 'common/currency'
0.00026893615722656SELECT * FROM oc_translation WHERE store_id = '100' AND language_id = '1' AND (route = 'blog/menu' OR route = 'ru-ru')
0.00029492378234863SELECT * FROM oc_blog_category c LEFT JOIN oc_blog_category_description cd ON (c.blog_category_id = cd.blog_category_id) LEFT JOIN oc_blog_category_to_store c2s ON (c.blog_category_id = c2s.blog_category_id) WHERE cd.language_id = '1' AND c2s.store_id = '100' AND c.status = '1' ORDER BY c.parent_id, c.sort_order, cd.name
0.00027108192443848SELECT * FROM oc_theme WHERE store_id = '100' AND theme = 'terminal' AND route = 'blog/menu'
0.00029087066650391SELECT * FROM oc_translation WHERE store_id = '100' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru')
0.00027799606323242SELECT * FROM oc_theme WHERE store_id = '100' AND theme = 'terminal' AND route = 'common/search'
0.00027799606323242SELECT * FROM oc_translation WHERE store_id = '100' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')
0.00075197219848633SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '1938a8e477d7a4f2094c7d3d0e'
0.00028300285339355SELECT * FROM oc_extension WHERE `type` = 'total'
0.0002591609954834SELECT * FROM oc_translation WHERE store_id = '100' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru')
0.000244140625SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '1938a8e477d7a4f2094c7d3d0e'
0.00028586387634277SELECT * FROM oc_translation WHERE store_id = '100' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru')
0.00026798248291016SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '1938a8e477d7a4f2094c7d3d0e'
0.00022792816162109SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '1938a8e477d7a4f2094c7d3d0e'
0.00028896331787109SELECT * FROM oc_theme WHERE store_id = '100' AND theme = 'terminal' AND route = 'common/cart'
0.00026297569274902SELECT * FROM oc_translation WHERE store_id = '100' AND language_id = '1' AND (route = 'extension/module/sphinx' OR route = 'ru-ru')
0.0002748966217041SELECT * FROM oc_theme WHERE store_id = '100' AND theme = 'terminal' AND route = 'extension/module/sphinxautocomplete'
0.00029897689819336SELECT * FROM oc_translation WHERE store_id = '100' AND language_id = '1' AND (route = 'common/menu' OR route = 'ru-ru')
0.00028300285339355SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 0 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00026798248291016SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 346 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00025510787963867SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 347 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00031399726867676SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 359 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00027799606323242SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 415 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00026512145996094SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 437 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00028085708618164SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 452 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00027894973754883SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 466 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00027704238891602SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 480 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00028300285339355SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 572 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00026893615722656SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 488 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00029397010803223SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 481 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00025796890258789SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 520 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00023794174194336SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 509 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00028300285339355SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 596 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00026798248291016SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 577 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00026702880859375SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 562 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00027990341186523SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 538 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00029206275939941SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 546 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00027012825012207SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 604 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00023484230041504SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 223 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00026988983154297SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 275 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00026178359985352SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 224 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00026488304138184SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 306 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00019502639770508SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 333 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.001215934753418SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 255 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00022196769714355SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 340 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00023889541625977SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 345 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00024199485778809SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 608 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00021505355834961SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 609 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00027990341186523SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 1261 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00024104118347168SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 852 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00024104118347168SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 1370 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.0002589225769043SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 1318 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00025010108947754SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 1072 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00024890899658203SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 1223 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00025510787963867SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 1986 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00023388862609863SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2113 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00023102760314941SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2083 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00023913383483887SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2010 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00025701522827148SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2026 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00022006034851074SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 1987 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00018501281738281SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2130 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00018191337585449SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2117 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00024104118347168SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2086 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00019288063049316SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2056 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00021505355834961SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2040 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00020313262939453SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2050 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00020384788513184SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2064 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00023603439331055SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2122 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00019311904907227SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2757 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00018405914306641SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2758 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00027585029602051SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2876 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00020790100097656SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2446 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00025296211242676SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2472 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00024890899658203SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2447 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00026106834411621SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2467 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00023317337036133SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2695 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00021791458129883SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2534 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00021195411682129SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2608 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.0002288818359375SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2714 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00023102760314941SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2888 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00019693374633789SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3088 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00024914741516113SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3094 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00020718574523926SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2889 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00020098686218262SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3048 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00018095970153809SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3099 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00021004676818848SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3438 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00022101402282715SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3439 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00030899047851562SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 4289 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00024604797363281SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3873 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00029993057250977SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3512 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00031590461730957SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 4128 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00031208992004395SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 4256 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00028014183044434SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 4310 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00027585029602051SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3827 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00031018257141113SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3850 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00032305717468262SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 4317 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00034499168395996SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 4453 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00028896331787109SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 4457 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00023508071899414SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 4318 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00020718574523926SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 4364 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.0002291202545166SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 4343 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00020909309387207SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 4450 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00023388862609863SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 4418 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00020599365234375SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 4426 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.0002288818359375SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 4463 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00020503997802734SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 4405 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00023198127746582SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 4409 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00021696090698242SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 4433 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.0002288818359375SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 4444 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00021791458129883SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 1684 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00023603439331055SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 1829 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00022602081298828SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 1723 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00020599365234375SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 1790 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00020098686218262SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 1924 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00021481513977051SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 1685 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.0002598762512207SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 1397 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00022387504577637SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 1582 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.0002748966217041SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 1608 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00019693374633789SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 1398 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.0001990795135498SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 1677 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00032615661621094SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 1476 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00023794174194336SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 1648 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00021886825561523SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 1666 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00019097328186035SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 1540 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00020718574523926SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 1 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00021791458129883SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 99 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00022101402282715SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 66 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00021100044250488SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00022315979003906SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 77 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00021505355834961SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 83 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00020694732666016SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 90 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00020813941955566SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 17 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00023078918457031SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 148 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00019192695617676SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 104 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00020599365234375SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 127 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00021719932556152SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 113 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00021100044250488SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3108 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00020980834960938SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3179 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00021791458129883SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3109 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00019311904907227SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3157 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00020813941955566SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3186 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00020813941955566SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3137 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.0002140998840332SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3145 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00023007392883301SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3164 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00021600723266602SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3222 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00021576881408691SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3357 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.0002131462097168SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3389 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00020813941955566SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3429 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00021600723266602SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3397 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00019097328186035SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3411 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.0002129077911377SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3406 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00019192695617676SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3358 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00018787384033203SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 3418 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.0002291202545166SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2133 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00017213821411133SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2186 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00020384788513184SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2305 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00021600723266602SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2419 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00021600723266602SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2311 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00019288063049316SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2212 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.0002140998840332SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2415 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00020885467529297SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2347 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00020790100097656SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2444 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00020599365234375SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2377 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00022101402282715SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2150 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00025701522827148SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2284 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00021910667419434SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2314 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00027012825012207SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2385 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00026202201843262SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2308 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00021600723266602SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2134 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00023198127746582SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2335 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00021505355834961SELECT c.category_id, c.top, cd.name, c2s.status, c2s.sort_order FROM oc_category AS c JOIN oc_category_description AS cd ON c.category_id = cd.category_id JOIN oc_category_to_store AS c2s ON c.category_id = c2s.category_id AND c2s.store_id = 100 WHERE c.parent_id = 2215 AND cd.language_id = 1 AND c2s.status = 1 ORDER BY c2s.sort_order ASC, LCASE(cd.name) ASC
0.00023293495178223SELECT * FROM oc_translation WHERE store_id = '100' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru')
0.00020194053649902SELECT * FROM oc_theme WHERE store_id = '100' AND theme = 'terminal' AND route = 'common/search'
0.00024199485778809SELECT * FROM oc_translation WHERE store_id = '100' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')
0.00021100044250488SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '1938a8e477d7a4f2094c7d3d0e'
0.00020313262939453SELECT * FROM oc_extension WHERE `type` = 'total'
0.00021886825561523SELECT * FROM oc_translation WHERE store_id = '100' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru')
0.00021696090698242SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '1938a8e477d7a4f2094c7d3d0e'
0.0002129077911377SELECT * FROM oc_translation WHERE store_id = '100' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru')
0.00019502639770508SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '1938a8e477d7a4f2094c7d3d0e'
0.00019502639770508SELECT * FROM oc_cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '1938a8e477d7a4f2094c7d3d0e'
0.00020813941955566SELECT * FROM oc_theme WHERE store_id = '100' AND theme = 'terminal' AND route = 'common/cart'
0.00020694732666016SELECT * FROM oc_theme WHERE store_id = '100' AND theme = 'terminal' AND route = 'common/menu'
0.00023913383483887SELECT * FROM oc_theme WHERE store_id = '100' AND theme = 'terminal' AND route = 'common/header'
0.00025701522827148SELECT * FROM oc_theme WHERE store_id = '100' AND theme = 'terminal' AND route = 'product/product'