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 Инструмент Horn

Отдел продаж

+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

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

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

Horn

О бренде:

Paul Horn GmbH занимается разработкой и производством инструментов для обработки канавок, бокового точения и фрезерования пазов с 1969 года; эти инструменты занимают лидирующие позиции на рынке.

Наша продукция используется производителями автомобилей, общего машиностроения, аэрокосмической промышленности, гидравлики/пневматики, ювелирного и медицинского оборудования.

Превосходная репутация наших инструментов основана на их технологии, производительности и надежности. Они разрабатываются и производятся 1400 сотрудниками по всему миру. В Германии мы зарекомендовали себя как отраслевой лидер и технологический лидер на протяжении многих лет.

Мы предоставляем нашим клиентам высококачественный сервис и поддержку, основанные на нашем широком ассортименте высокопроизводительных инструментальных систем. Благодаря сотрудничеству с нашими зарубежными дочерними компаниями и дистрибьюторами мы можем быть ценным и ценным партнером для каждого из наших клиентов по всему миру.

Постоянное развитие и оптимизация процессов и продуктов, а также распространение знаний — наш наивысший приоритет. Постоянный рост HORN и большое удовлетворение наших клиентов подтверждают нашу бизнес-стратегию.

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

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

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

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

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

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

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

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

Наверх
  • WhatsApp

  • Skype

  • Viber

    Viber

  • Telegram

  • Debug SQL
    0.00081300735473633SELECT value FROM setting WHERE `key` = 'redirector_status'
    0.00017094612121582SELECT `url_to` FROM redirector WHERE status = 1 AND url_to != '' AND url_from = 'horn/' ORDER BY redirect_id DESC LIMIT 1
    0.00087404251098633SELECT value FROM setting WHERE store_id = '0' AND `key`='config_seo_url_type'
    4.0054321289062E-5SET time_zone = '+00:00'
    0.0020990371704102DELETE FROM `session` WHERE `expire` < '2022-10-06 13:44:40'
    0.0001521110534668SELECT * FROM translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
    0.00012612342834473SELECT `data` FROM `session` WHERE `session_id` = '8eca752e9a773092dfb096939f' AND `expire` > '2022-10-06 13:44:40'
    8.392333984375E-5SELECT * FROM store WHERE REPLACE(`ssl`, 'www.', '') = 'https://imperial-tools.ru/'
    0.0017719268798828SELECT * FROM `setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
    5.4121017456055E-5SET time_zone = '+10:00'
    0.00012493133544922SELECT * FROM currency
    0.00025105476379395SELECT 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.00015997886657715SELECT 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.00011301040649414SELECT * 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.00011181831359863SELECT * 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.00011610984802246DELETE FROM cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 12 MONTH)
    0.00024819374084473SELECT * FROM `event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC
    0.00011110305786133SELECT c.* FROM prmn_cm_city c ORDER BY sort, name
    9.2029571533203E-5SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'extension/module/progroman/citymanager/content'
    0.00047397613525391show tables like 'manufacturer_description'
    0.00020384788513184SHOW COLUMNS FROM `manufacturer_description` LIKE 'name';
    0.00021195411682129SELECT 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.00046801567077637show tables like 'manufacturer_description'
    0.00018906593322754SHOW COLUMNS FROM `manufacturer_description` LIKE 'name';
    0.0001978874206543SELECT m.manufacturer_id, m.`sort_order`, m.name FROM `manufacturer` m ORDER BY name ASC
    0.00034594535827637SELECT `query`, keyword FROM seo_url WHERE query like 'manufacturer_id=%'
    0.00017189979553223SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/manufacturer' OR route = 'ru-ru')
    0.00021004676818848SELECT 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 = '317' AND m2s.store_id = '0'
    0.0001060962677002SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    8.9883804321289E-5SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru')
    0.00055789947509766show tables like 'manufacturer_description'
    0.0001828670501709SHOW COLUMNS FROM `manufacturer_description` LIKE 'name';
    0.00023388862609863SELECT m.manufacturer_id, m.`sort_order`, m.name FROM `manufacturer` m ORDER BY name ASC
    0.00033998489379883SELECT `query`, keyword FROM seo_url WHERE query like 'manufacturer_id=%'
    0.00015997886657715SELECT p.product_id FROM `product` p WHERE p.status = 1 AND p.manufacturer_id IN (317)
    0.00047111511230469SELECT 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 (215301,215302,215303,215304,215305,215306,215307,215308,244671,244672,244673,261824,273770) AND p.manufacturer_id = '317' GROUP BY p.product_id
    0.0001218318939209SELECT p.product_id FROM `product` p WHERE p.status = 1 AND p.manufacturer_id IN (317)
    0.00076413154602051SELECT 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 (215301,215302,215303,215304,215305,215306,215307,215308,244671,244672,244673,261824,273770) AND p.manufacturer_id = '317' 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.00042200088500977SELECT 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 = '215301' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00042390823364258SELECT 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 = '244671' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00036907196044922SELECT 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 = '215308' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00036501884460449SELECT 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 = '215302' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00034093856811523SELECT 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 = '244673' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00046491622924805SELECT 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 = '244672' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00034809112548828SELECT 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 = '215304' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00032997131347656SELECT 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 = '215307' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00039982795715332SELECT 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 = '215306' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.0003809928894043SELECT 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 = '215305' 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 = '215303' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00033807754516602SELECT 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 = '273770' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00036883354187012SELECT 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 = '261824' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00012898445129395SELECT 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 = '317' AND m2s.store_id = '0'
    0.00023388862609863SELECT * 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 = '215301' AND od.language_id = '1' ORDER BY o.sort_order
    0.00017595291137695SELECT 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 = '215301' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00033998489379883SELECT * 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 = '244671' AND od.language_id = '1' ORDER BY o.sort_order
    0.00017619132995605SELECT 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 = '244671' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00021100044250488SELECT * 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 = '215308' AND od.language_id = '1' ORDER BY o.sort_order
    0.00014114379882812SELECT 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 = '215308' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00018405914306641SELECT * 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 = '215302' AND od.language_id = '1' ORDER BY o.sort_order
    0.00013494491577148SELECT 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 = '215302' 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 = '244673' AND od.language_id = '1' ORDER BY o.sort_order
    0.00012993812561035SELECT 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 = '244673' 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 = '244672' AND od.language_id = '1' ORDER BY o.sort_order
    0.00014400482177734SELECT 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 = '244672' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00018596649169922SELECT * 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 = '215304' AND od.language_id = '1' ORDER BY o.sort_order
    0.00014615058898926SELECT 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 = '215304' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00018405914306641SELECT * 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 = '215307' AND od.language_id = '1' ORDER BY o.sort_order
    0.00015902519226074SELECT 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 = '215307' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00017285346984863SELECT * 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 = '215306' AND od.language_id = '1' ORDER BY o.sort_order
    0.00017809867858887SELECT 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 = '215306' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00021815299987793SELECT * 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 = '215305' AND od.language_id = '1' ORDER BY o.sort_order
    0.00012707710266113SELECT 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 = '215305' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00019192695617676SELECT * 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 = '215303' AND od.language_id = '1' ORDER BY o.sort_order
    0.00020694732666016SELECT 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 = '215303' 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 = '273770' AND od.language_id = '1' ORDER BY o.sort_order
    0.00017404556274414SELECT 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 = '273770' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00018215179443359SELECT * 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 = '261824' AND od.language_id = '1' ORDER BY o.sort_order
    0.00017404556274414SELECT 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 = '261824' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00011706352233887SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'product/buyclick_form'
    0.00011301040649414SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'product/category_micro'
    0.00056195259094238show tables like 'manufacturer_description'
    0.00021791458129883SHOW COLUMNS FROM `manufacturer_description` LIKE 'name';
    0.00023102760314941SELECT m.manufacturer_id, m.`sort_order`, m.name FROM `manufacturer` m ORDER BY name ASC
    0.0003509521484375SELECT `query`, keyword FROM seo_url WHERE query like 'manufacturer_id=%'
    0.00015497207641602SELECT * FROM layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
    0.00012087821960449SELECT * FROM layout_module WHERE layout_id = '17' AND position = 'column_left' ORDER BY sort_order
    8.2015991210938E-5SELECT * FROM module WHERE module_id = '80'
    0.00023007392883301SELECT 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 = '317' AND m2s.store_id = '0'
    0.0001380443572998SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/ocdepartment' OR route = 'ru-ru')
    0.00087690353393555SELECT * 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-06' AND p.manufacturer_id = '317') 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.00021815299987793SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'extension/module/ocdepartment/module'
    0.00018501281738281SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/column_left'
    0.00016093254089355SELECT * FROM layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
    0.00013613700866699SELECT * FROM layout_module WHERE layout_id = '17' AND position = 'column_right' ORDER BY sort_order
    8.702278137207E-5SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/column_right'
    0.0001218318939209SELECT * FROM layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
    0.00010299682617188SELECT * FROM layout_module WHERE layout_id = '17' AND position = 'content_top' ORDER BY sort_order
    8.2969665527344E-5SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/content_top'
    0.00010919570922852SELECT * FROM layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
    9.7990036010742E-5SELECT * FROM layout_module WHERE layout_id = '17' AND position = 'content_bottom' ORDER BY sort_order
    9.2029571533203E-5SELECT * FROM module WHERE module_id = '81'
    9.2029571533203E-5SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'extension/module/html'
    8.9883804321289E-5SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/content_bottom'
    0.00012016296386719SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru')
    0.00040912628173828SELECT * 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.00011014938354492SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    9.2029571533203E-5SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru')
    8.4877014160156E-5SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'product/buyclick_form'
    0.00012803077697754SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    0.00089693069458008SELECT * FROM setting WHERE store_id = '0' AND `code` = 'theme_technicssoclinks'
    0.00091695785522461SELECT * FROM setting WHERE store_id = '0' AND `code` = 'theme_technicsmeslinks'
    0.00012493133544922SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'extension/module/callback'
    0.00012898445129395SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/footer'
    0.00010085105895996SELECT * FROM extension WHERE `type` = 'analytics'
    0.00011014938354492SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
    0.00011992454528809SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    0.00014400482177734SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '8eca752e9a773092dfb096939f'
    0.00010895729064941SELECT * 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.0001060962677002SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
    9.4175338745117E-5SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    9.2029571533203E-5SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'account/wishlist' OR route = 'ru-ru')
    8.8930130004883E-5SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    0.00019216537475586SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'account/wish_head'
    0.00011301040649414SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'product/compare_head'
    0.00019621849060059SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')
    0.00012302398681641SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/language'
    0.00012397766113281SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
    0.00010514259338379SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/currency'
    0.00010991096496582SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru')
    8.5115432739258E-5SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/search'
    0.00013995170593262SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')
    0.00010204315185547SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '8eca752e9a773092dfb096939f'
    8.9883804321289E-5SELECT * FROM extension WHERE `type` = 'total'
    0.00011992454528809SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru')
    0.00010395050048828SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '8eca752e9a773092dfb096939f'
    0.00011491775512695SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '8eca752e9a773092dfb096939f'
    0.00014400482177734SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru')
    9.2029571533203E-5SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '8eca752e9a773092dfb096939f'
    9.8943710327148E-5SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    8.7976455688477E-5SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '8eca752e9a773092dfb096939f'
    9.7990036010742E-5SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru')
    8.2969665527344E-5SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '8eca752e9a773092dfb096939f'
    0.0001070499420166SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'product/buyclick_form'
    0.0001070499420166SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/cart'
    0.00013113021850586SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/menu' OR route = 'ru-ru')
    0.00049090385437012SELECT * 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.0006098747253418SELECT * 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.00048208236694336SELECT * 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.00050687789916992SELECT * 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.0005028247833252SELECT * 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.00028586387634277SELECT * 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.00042414665222168SELECT * 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.00031495094299316SELECT * 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.00031399726867676SELECT * 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.00027203559875488SELECT * 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.00028896331787109SELECT * 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.00026702880859375SELECT * 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)
    0.00011897087097168SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/menu'
    0.0001220703125SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'extension/module/callback'
    9.2983245849609E-5SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/header_4'
    0.00012397766113281SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/header'
    0.00091099739074707SELECT * FROM setting WHERE store_id = '0' AND `code` = 'advertise_google'
    0.00015401840209961SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'product/manufacturer_info'