Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 26Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 34Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 26Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 34Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 26Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 34Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 26Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 34Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 26Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 34Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 26Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 34Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 26Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 34Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 26Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 34Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 26Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 34Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 26Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 34Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 26Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 34Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 26Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 34Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 26Notice: Undefined index: OCSESSID in /var/www/admin/data/www/storage-imperial-tools/modification/system/library/db/mysqli.php on line 34 Инструмент DESKAR

Отдел продаж

+7 (499) 673-00-78 info@imperial-tools.ru

+7 (499) 673-00-78

+7 (423) 272-64-51

info@imperial-tools.ru

8 (499) 673-00-78

8 (499) 673-00-78

8 (499) 673-00-78

Заказать звонок

КАТАЛОГ
Сравнение Избранное
Корзина
  • Ваша корзина пуста!

DESKAR

О бренде:

Производство компании DESKAR расположено в городе Веньлин, провинция Чжецзян, Китайская народная республика. Компания обладает самыми передовыми производственными технологиями, имеет большое исследовательское подразделение, специализирующееся на разработке сменных пластин для токарной и фрезерной обработки металлов в станках ЧПУ мирового класса. Линию по производству держателей токарного инструмента, линию по производству концевых твердосплавных фрез линию по производству сменных пластин с покрытием PVD для токарной и фрезерно обработки. А также центр развития технологий, объединяющий научные и прикладные исследования.


Компания DESKAR энергично продвигает корпоративный дух "стремиться к совершенству, поражать мир инновациями, клиент прежде всего, продвигаться вперед", с целью "оживить национальную промышленность". Коллектив компании DESKAR придерживается принципа "клиент прежде всего" чтобы обеспечить качественную продукцию всем нашим клиентам. Компания DESKAR прошла сертификацию подтверждения сиситемы качества GB/T19001-2008/SO9001:2008.

Санкции не проблема!

Весь товар доставляется в штатном режиме несмотря на уход производителя с рынка Рф

Гарантированно низкая цена
Короткие сроки поставки
Оригинальный инструмент
Бесплатная доставка до терминала тк
Заказать инструмент

Продукция производителя "DESKAR" на сайте

Не нашли что искали?

Ничего страшного! Специально для вас поставим любой необходимый вам инструмент в любом объеме по гарантированно низкой цене!

Оставить заявку

Наверх
  • WhatsApp

  • Skype

  • Viber

    Viber

  • Telegram

  • Debug SQL
    0.00087499618530273SELECT value FROM setting WHERE `key` = 'redirector_status'
    0.00010514259338379SELECT `url_to` FROM redirector WHERE status = 1 AND url_to != '' AND url_from = 'deskar/' ORDER BY redirect_id DESC LIMIT 1
    0.00083804130554199SELECT value FROM setting WHERE store_id = '0' AND `key`='config_seo_url_type'
    3.504753112793E-5SET time_zone = '+00:00'
    0.0033810138702393DELETE FROM `session` WHERE `expire` < '2022-10-06 14:46:40'
    0.00016999244689941SELECT * FROM translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
    9.7036361694336E-5SELECT `data` FROM `session` WHERE `session_id` = '6cf1ccb1b6642c043bdfe5e18c' AND `expire` > '2022-10-06 14:46:40'
    8.1062316894531E-5SELECT * FROM store WHERE REPLACE(`ssl`, 'www.', '') = 'https://imperial-tools.ru/'
    0.0018689632415771SELECT * FROM `setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
    8.2969665527344E-5SET time_zone = '+10:00'
    0.00014710426330566SELECT * FROM currency
    0.00029706954956055SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM tax_rule tr1 LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN 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 = '119') ORDER BY tr1.priority ASC
    0.00023198127746582SELECT tr1.tax_class_id, tr2.tax_rate_id, tr2.name, tr2.rate, tr2.type, tr1.priority FROM tax_rule tr1 LEFT JOIN tax_rate tr2 ON (tr1.tax_rate_id = tr2.tax_rate_id) INNER JOIN tax_rate_to_customer_group tr2cg ON (tr2.tax_rate_id = tr2cg.tax_rate_id) LEFT JOIN zone_to_geo_zone z2gz ON (tr2.geo_zone_id = z2gz.geo_zone_id) LEFT JOIN 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 = '119') ORDER BY tr1.priority ASC
    0.00013399124145508SELECT * FROM weight_class wc LEFT JOIN weight_class_description wcd ON (wc.weight_class_id = wcd.weight_class_id) WHERE wcd.language_id = '1'
    0.00011801719665527SELECT * FROM length_class mc LEFT JOIN length_class_description mcd ON (mc.length_class_id = mcd.length_class_id) WHERE mcd.language_id = '1'
    0.00010800361633301DELETE FROM cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 12 MONTH)
    0.00017404556274414SELECT * FROM `event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC
    0.00014710426330566SELECT c.* FROM prmn_cm_city c ORDER BY sort, name
    0.00010013580322266SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'extension/module/progroman/citymanager/content'
    0.0004570484161377show tables like 'manufacturer_description'
    0.00016903877258301SHOW COLUMNS FROM `manufacturer_description` LIKE 'name';
    0.0002601146697998SELECT m.manufacturer_id, m.`sort_order`, m.name FROM `manufacturer` m ORDER BY name ASC
    0.00032687187194824SELECT `query`, keyword FROM seo_url WHERE query like 'manufacturer_id=%'
    0.00045609474182129show tables like 'manufacturer_description'
    0.00019216537475586SHOW COLUMNS FROM `manufacturer_description` LIKE 'name';
    0.00021505355834961SELECT m.manufacturer_id, m.`sort_order`, m.name FROM `manufacturer` m ORDER BY name ASC
    0.00030899047851562SELECT `query`, keyword FROM seo_url WHERE query like 'manufacturer_id=%'
    0.00014901161193848SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/manufacturer' OR route = 'ru-ru')
    0.00014090538024902SELECT DISTINCT * FROM manufacturer m LEFT JOIN manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id AND md.language_id = '1') LEFT JOIN manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '239' AND m2s.store_id = '0'
    0.00011396408081055SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    8.5115432739258E-5SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru')
    0.00048089027404785show tables like 'manufacturer_description'
    0.00018000602722168SHOW COLUMNS FROM `manufacturer_description` LIKE 'name';
    0.00022721290588379SELECT m.manufacturer_id, m.`sort_order`, m.name FROM `manufacturer` m ORDER BY name ASC
    0.00036001205444336SELECT `query`, keyword FROM seo_url WHERE query like 'manufacturer_id=%'
    0.00038003921508789SELECT p.product_id FROM `product` p WHERE p.status = 1 AND p.manufacturer_id IN (239)
    0.0024170875549316SELECT COUNT(DISTINCT p.product_id) AS total FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN 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 p.product_id IN (215248,215249,215250,215368,215369,215370,215371,215372,215453,215454,215455,215456,215490,215492,215494,215602,215603,215604,216278,216286,216610,216612,216613,216614,216615,216621,216635,216636,216637,216638,216711,216873,216874,216876,216877,216878,216879,216880,216881,217317,217387,217794,217795,217796,217813,218367,218382,218464,218465,218650,218927,218928,218929,218930,218931,219015,219016,219022,219023,219247,219248,219249,219250,219376,219600,219601,219602,219660,219661,220016,220166,220168,220169,220469,220554,220555,220556,220557,220561,220903,220904,220950,220951,220961,220962,221336,221488,222131,222485,222718,222719,222959,222960,223326,223327,223514,223515,223546,223547,223668,223669,223676,223699,223921,223924,223945,223951,224057,224165,224166,224610,224628,224765,224766,224767,224768,224769,224770,224771,224772,225048,225394,225395,225397,238987,238989,238990,238992,239253,239254,239255,239256,239263,239298,239754,241397,241577,241578,242182,245642,245735,246232,246308,246357,246358,246359,246360,246506,246514,246751,246752,246753,246754,246896,246981,246982,247317,247453,247908,248701,248813,249032,249154,249182,249257,249563,250244,250248,250250,250252,250255,250554,251001,251515,251832,251967,252232,252730,252772,252938,253027,253122,253156,253174,253317,253405,253717,253774,254126,254283,254429,254430,254607,254773,254939,255373,255375,255386,255411,255682,255879,255915,255916,255947,255998,256050,256175,256373,256524,256592,256828,256829,256830,257265,257323,257483,257496,257575,257667,257680,258372,258382,258472,258473) AND p.manufacturer_id = '239' GROUP BY p.product_id
    0.00038790702819824SELECT p.product_id FROM `product` p WHERE p.status = 1 AND p.manufacturer_id IN (239)
    0.0057680606842041SELECT p.product_id, (SELECT AVG(rating) AS total FROM review r1 WHERE r1.product_id = p.product_id AND r1.status = '1' GROUP BY r1.product_id) AS rating, (SELECT price FROM 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 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, coalesce((SELECT price FROM 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), (SELECT price FROM 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), p.price) as realprice, p.quantity FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN 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 p.product_id IN (215248,215249,215250,215368,215369,215370,215371,215372,215453,215454,215455,215456,215490,215492,215494,215602,215603,215604,216278,216286,216610,216612,216613,216614,216615,216621,216635,216636,216637,216638,216711,216873,216874,216876,216877,216878,216879,216880,216881,217317,217387,217794,217795,217796,217813,218367,218382,218464,218465,218650,218927,218928,218929,218930,218931,219015,219016,219022,219023,219247,219248,219249,219250,219376,219600,219601,219602,219660,219661,220016,220166,220168,220169,220469,220554,220555,220556,220557,220561,220903,220904,220950,220951,220961,220962,221336,221488,222131,222485,222718,222719,222959,222960,223326,223327,223514,223515,223546,223547,223668,223669,223676,223699,223921,223924,223945,223951,224057,224165,224166,224610,224628,224765,224766,224767,224768,224769,224770,224771,224772,225048,225394,225395,225397,238987,238989,238990,238992,239253,239254,239255,239256,239263,239298,239754,241397,241577,241578,242182,245642,245735,246232,246308,246357,246358,246359,246360,246506,246514,246751,246752,246753,246754,246896,246981,246982,247317,247453,247908,248701,248813,249032,249154,249182,249257,249563,250244,250248,250250,250252,250255,250554,251001,251515,251832,251967,252232,252730,252772,252938,253027,253122,253156,253174,253317,253405,253717,253774,254126,254283,254429,254430,254607,254773,254939,255373,255375,255386,255411,255682,255879,255915,255916,255947,255998,256050,256175,256373,256524,256592,256828,256829,256830,257265,257323,257483,257496,257575,257667,257680,258372,258382,258472,258473) AND p.manufacturer_id = '239' GROUP BY p.product_id ORDER BY (p.quantity>0) DESC, (p.price>0) DESC,p.sort_order ASC, LCASE(pd.name) ASC LIMIT 0,18
    0.00051307678222656SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '249182' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00043392181396484SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '249154' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00039887428283691SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '246360' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00040006637573242SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '253122' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00037407875061035SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '220561' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00036382675170898SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '216613' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00040006637573242SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '220557' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00033998489379883SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '216873' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00043296813964844SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '255375' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00041317939758301SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '252730' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00040698051452637SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '216874' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00040793418884277SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '246514' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00037503242492676SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '215453' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.0003819465637207SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '218464' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00036096572875977SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '215248' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00035595893859863SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '215602' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00035595893859863SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '215249' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00037384033203125SELECT DISTINCT *, pd.name AS name, p.image, m.name AS manufacturer, (SELECT price FROM 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 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 product_reward pr WHERE pr.product_id = p.product_id AND pr.customer_group_id = '1') AS reward, (SELECT ss.name FROM stock_status ss WHERE ss.stock_status_id = p.stock_status_id AND ss.language_id = '1') AS stock_status, (SELECT wcd.unit FROM 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 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 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 review r2 WHERE r2.product_id = p.product_id AND r2.status = '1' GROUP BY r2.product_id) AS reviews, p.sort_order FROM product p LEFT JOIN product_description pd ON (p.product_id = pd.product_id) LEFT JOIN product_to_store p2s ON (p.product_id = p2s.product_id) LEFT JOIN manufacturer m ON (p.manufacturer_id = m.manufacturer_id) WHERE p.product_id = '215603' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00012707710266113SELECT DISTINCT * FROM manufacturer m LEFT JOIN manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id AND md.language_id = '1') LEFT JOIN manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '239' AND m2s.store_id = '0'
    0.00022697448730469SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '249182' AND od.language_id = '1' ORDER BY o.sort_order
    0.00016593933105469SELECT ag.attribute_group_id, agd.name FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '249182' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00042486190795898SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '249154' AND od.language_id = '1' ORDER BY o.sort_order
    0.0002129077911377SELECT ag.attribute_group_id, agd.name FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '249154' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00022792816162109SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '246360' AND od.language_id = '1' ORDER BY o.sort_order
    0.00015497207641602SELECT ag.attribute_group_id, agd.name FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '246360' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00020599365234375SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '253122' AND od.language_id = '1' ORDER BY o.sort_order
    0.00013899803161621SELECT ag.attribute_group_id, agd.name FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '253122' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00018787384033203SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '220561' AND od.language_id = '1' ORDER BY o.sort_order
    0.0001380443572998SELECT ag.attribute_group_id, agd.name FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '220561' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.0001680850982666SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '216613' AND od.language_id = '1' ORDER BY o.sort_order
    0.00012588500976562SELECT ag.attribute_group_id, agd.name FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '216613' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00015783309936523SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '220557' AND od.language_id = '1' ORDER BY o.sort_order
    0.00012493133544922SELECT ag.attribute_group_id, agd.name FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '220557' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00017786026000977SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '216873' AND od.language_id = '1' ORDER BY o.sort_order
    0.00014305114746094SELECT ag.attribute_group_id, agd.name FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '216873' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.0001828670501709SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '255375' AND od.language_id = '1' ORDER BY o.sort_order
    0.00018095970153809SELECT ag.attribute_group_id, agd.name FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '255375' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00025606155395508SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '252730' AND od.language_id = '1' ORDER BY o.sort_order
    0.00019407272338867SELECT ag.attribute_group_id, agd.name FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '252730' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00018095970153809SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '216874' AND od.language_id = '1' ORDER BY o.sort_order
    0.0001680850982666SELECT ag.attribute_group_id, agd.name FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '216874' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00016617774963379SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '246514' AND od.language_id = '1' ORDER BY o.sort_order
    0.00012803077697754SELECT ag.attribute_group_id, agd.name FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '246514' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00022792816162109SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '215453' AND od.language_id = '1' ORDER BY o.sort_order
    0.00018501281738281SELECT ag.attribute_group_id, agd.name FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '215453' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.0002291202545166SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '218464' AND od.language_id = '1' ORDER BY o.sort_order
    0.00017905235290527SELECT ag.attribute_group_id, agd.name FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '218464' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00019478797912598SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '215248' AND od.language_id = '1' ORDER BY o.sort_order
    0.00019288063049316SELECT ag.attribute_group_id, agd.name FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '215248' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00023698806762695SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '215602' AND od.language_id = '1' ORDER BY o.sort_order
    0.00019121170043945SELECT ag.attribute_group_id, agd.name FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '215602' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00021886825561523SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '215249' AND od.language_id = '1' ORDER BY o.sort_order
    0.00018215179443359SELECT ag.attribute_group_id, agd.name FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '215249' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00020503997802734SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '215603' AND od.language_id = '1' ORDER BY o.sort_order
    0.00017213821411133SELECT ag.attribute_group_id, agd.name FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '215603' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00019598007202148SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'product/buyclick_form'
    0.00010395050048828SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'product/category_micro'
    0.00050497055053711show tables like 'manufacturer_description'
    0.00019288063049316SHOW COLUMNS FROM `manufacturer_description` LIKE 'name';
    0.00025391578674316SELECT m.manufacturer_id, m.`sort_order`, m.name FROM `manufacturer` m ORDER BY name ASC
    0.00032496452331543SELECT `query`, keyword FROM seo_url WHERE query like 'manufacturer_id=%'
    0.00013399124145508SELECT * FROM layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
    0.00010490417480469SELECT * FROM layout_module WHERE layout_id = '17' AND position = 'column_left' ORDER BY sort_order
    5.9127807617188E-5SELECT * FROM module WHERE module_id = '80'
    0.00014996528625488SELECT DISTINCT * FROM manufacturer m LEFT JOIN manufacturer_description md ON (m.manufacturer_id = md.manufacturer_id AND md.language_id = '1') LEFT JOIN manufacturer_to_store m2s ON (m.manufacturer_id = m2s.manufacturer_id) WHERE m.manufacturer_id = '239' AND m2s.store_id = '0'
    0.00012898445129395SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/ocdepartment' OR route = 'ru-ru')
    0.0047898292541504SELECT * FROM (SELECT c.parent_id, c.sort_order, cd.name, c.image, COUNT(DISTINCT p2c.product_id) AS total, cp.level, cp.path_id AS category_id, (SELECT MAX(cp2.level) FROM category_path cp2 WHERE cp2.category_id = cp.category_id) AS max_level, (SELECT GROUP_CONCAT(cp3.path_id ORDER BY cp3.level SEPARATOR '_') FROM category_path cp3 WHERE cp3.category_id = cp.category_id AND cp3.level <= cp.level) AS path FROM category_path cp LEFT JOIN (SELECT p2c.category_id, p2c.product_id FROM product_to_category p2c RIGHT JOIN (SELECT p.product_id FROM product p WHERE p.status = '1' AND p.date_available <= '2022-10-07' AND p.manufacturer_id = '239') p ON (p2c.product_id = p.product_id)) p2c ON (cp.category_id = p2c.category_id) LEFT JOIN product_to_store p2s ON (p2c.product_id = p2s.product_id) LEFT JOIN category c ON (cp.path_id = c.category_id) LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.status = '1' AND cd.language_id = '1' AND c2s.store_id = '0' AND p2s.store_id = '0' GROUP BY cp.path_id) result WHERE IF(max_level > '1', `level` >= (max_level - 1), 1) ORDER BY total DESC, sort_order, LCASE(name)
    0.00017881393432617SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'extension/module/ocdepartment/module'
    0.00018215179443359SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/column_left'
    0.00019311904907227SELECT * FROM layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
    9.8943710327148E-5SELECT * FROM layout_module WHERE layout_id = '17' AND position = 'column_right' ORDER BY sort_order
    7.7009201049805E-5SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/column_right'
    0.00010991096496582SELECT * FROM layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
    0.00011801719665527SELECT * FROM layout_module WHERE layout_id = '17' AND position = 'content_top' ORDER BY sort_order
    7.7962875366211E-5SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/content_top'
    9.8943710327148E-5SELECT * FROM layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
    0.00011014938354492SELECT * FROM layout_module WHERE layout_id = '17' AND position = 'content_bottom' ORDER BY sort_order
    8.702278137207E-5SELECT * FROM module WHERE module_id = '81'
    0.00011301040649414SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'extension/module/html'
    0.00011110305786133SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/content_bottom'
    0.00011396408081055SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru')
    0.0004119873046875SELECT * FROM information i LEFT JOIN information_description id ON (i.information_id = id.information_id) LEFT JOIN 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.00013208389282227SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    9.4890594482422E-5SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru')
    8.082389831543E-5SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'product/buyclick_form'
    8.9883804321289E-5SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    0.00089311599731445SELECT * FROM setting WHERE store_id = '0' AND `code` = 'theme_technicssoclinks'
    0.00085806846618652SELECT * FROM setting WHERE store_id = '0' AND `code` = 'theme_technicsmeslinks'
    9.5129013061523E-5SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'extension/module/callback'
    0.0001070499420166SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/footer'
    0.00010299682617188SELECT * FROM extension WHERE `type` = 'analytics'
    0.00011301040649414SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
    0.0001060962677002SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    0.00012993812561035SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '6cf1ccb1b6642c043bdfe5e18c'
    0.00010395050048828SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/compare' OR route = 'ru-ru')
    9.2983245849609E-5SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/compare' OR route = 'ru-ru')
    0.00013899803161621SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
    0.00012898445129395SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    0.00011301040649414SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'account/wishlist' OR route = 'ru-ru')
    9.9897384643555E-5SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    0.00015521049499512SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'account/wish_head'
    0.00011086463928223SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'product/compare_head'
    0.00022506713867188SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')
    0.00010395050048828SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/language'
    0.00012898445129395SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
    9.8943710327148E-5SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/currency'
    0.00011801719665527SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru')
    7.7009201049805E-5SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/search'
    9.2029571533203E-5SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')
    0.00015115737915039SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '6cf1ccb1b6642c043bdfe5e18c'
    0.00011110305786133SELECT * FROM extension WHERE `type` = 'total'
    0.00010013580322266SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru')
    9.5129013061523E-5SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '6cf1ccb1b6642c043bdfe5e18c'
    8.4877014160156E-5SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '6cf1ccb1b6642c043bdfe5e18c'
    8.5115432739258E-5SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru')
    7.2002410888672E-5SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '6cf1ccb1b6642c043bdfe5e18c'
    7.7962875366211E-5SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    0.0001380443572998SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '6cf1ccb1b6642c043bdfe5e18c'
    0.00011920928955078SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru')
    0.00011205673217773SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '6cf1ccb1b6642c043bdfe5e18c'
    8.1062316894531E-5SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'product/buyclick_form'
    0.0001060962677002SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/cart'
    0.00012898445129395SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/menu' OR route = 'ru-ru')
    0.00058984756469727SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN 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.00050806999206543SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '747' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
    0.00035715103149414SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '810' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
    0.00036883354187012SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '784' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
    0.00031614303588867SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '806' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
    0.0002589225769043SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '830' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
    0.00034403800964355SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '791' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
    0.00028085708618164SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '831' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
    0.0002131462097168SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '832' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
    0.00023603439331055SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '833' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
    0.0002288818359375SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '834' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
    0.00019216537475586SELECT * FROM category c LEFT JOIN category_description cd ON (c.category_id = cd.category_id) LEFT JOIN category_to_store c2s ON (c.category_id = c2s.category_id) WHERE c.parent_id = '836' AND cd.language_id = '1' AND c2s.store_id = '0' AND c.status = '1' ORDER BY c.sort_order, LCASE(cd.name)
    8.5115432739258E-5SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/menu'
    9.2983245849609E-5SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'extension/module/callback'
    7.8916549682617E-5SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/header_4'
    9.2029571533203E-5SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/header'
    0.00088596343994141SELECT * FROM setting WHERE store_id = '0' AND `code` = 'advertise_google'
    0.00011420249938965SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'product/manufacturer_info'