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

Отдел продаж

+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

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

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

YG-1

О бренде:

YG-1 разрабатывает свою продукцию с нуля, потому что YG-1,
все еще хочет создать уникальный инструмент, еще не известный на рынке.
YG-1 способна разрабатывать интересные продукты
которые удивят клиентов во всем мире, ищущих
технологии, которые изменят обычную механическую обработку.
Новинки с замечательным кроем и в результате в отличном состоянии
поверхности разрабатываются благодаря лучшим
отбор сырья, прохождение
благодаря точным процессам обработки
строгий контроль качества. Институты YG-1 ищут
каждый день, чтобы лидировать в индустрии режущего инструмента с
превосходство в технике.

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

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

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

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

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

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

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

Наверх
  • WhatsApp

  • Skype

  • Viber

    Viber

  • Telegram

  • Debug SQL
    0.00082707405090332SELECT value FROM setting WHERE `key` = 'redirector_status'
    0.00013899803161621SELECT `url_to` FROM redirector WHERE status = 1 AND url_to != '' AND url_from = 'yg-1/' ORDER BY redirect_id DESC LIMIT 1
    0.0009000301361084SELECT value FROM setting WHERE store_id = '0' AND `key`='config_seo_url_type'
    3.6954879760742E-5SET time_zone = '+00:00'
    0.0022060871124268DELETE FROM `session` WHERE `expire` < '2022-10-06 13:42:22'
    0.00017499923706055SELECT * FROM translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
    8.7976455688477E-5SELECT `data` FROM `session` WHERE `session_id` = '9c5ea9dd1d001c9e488d14d9b5' AND `expire` > '2022-10-06 13:42:22'
    9.1075897216797E-5SELECT * FROM store WHERE REPLACE(`ssl`, 'www.', '') = 'https://imperial-tools.ru/'
    0.002004861831665SELECT * FROM `setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
    7.8916549682617E-5SET time_zone = '+10:00'
    0.0001518726348877SELECT * FROM currency
    0.00030183792114258SELECT 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.00023317337036133SELECT 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.0001530647277832SELECT * 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.00011277198791504SELECT * 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.00011801719665527DELETE FROM cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 12 MONTH)
    0.00017619132995605SELECT * FROM `event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC
    0.00011706352233887SELECT c.* FROM prmn_cm_city c ORDER BY sort, name
    0.00010204315185547SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'extension/module/progroman/citymanager/content'
    0.00052285194396973show tables like 'manufacturer_description'
    0.00021195411682129SHOW COLUMNS FROM `manufacturer_description` LIKE 'name';
    0.00025415420532227SELECT m.manufacturer_id, m.`sort_order`, m.name FROM `manufacturer` m ORDER BY name ASC
    0.00037097930908203SELECT `query`, keyword FROM seo_url WHERE query like 'manufacturer_id=%'
    0.00047087669372559show tables like 'manufacturer_description'
    0.00019097328186035SHOW COLUMNS FROM `manufacturer_description` LIKE 'name';
    0.00021481513977051SELECT m.manufacturer_id, m.`sort_order`, m.name FROM `manufacturer` m ORDER BY name ASC
    0.00034403800964355SELECT `query`, keyword FROM seo_url WHERE query like 'manufacturer_id=%'
    0.00021791458129883SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/manufacturer' OR route = 'ru-ru')
    0.0001518726348877SELECT 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 = '291' AND m2s.store_id = '0'
    0.00012898445129395SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    8.6069107055664E-5SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru')
    0.00051093101501465show tables like 'manufacturer_description'
    0.0001978874206543SHOW COLUMNS FROM `manufacturer_description` LIKE 'name';
    0.00024890899658203SELECT m.manufacturer_id, m.`sort_order`, m.name FROM `manufacturer` m ORDER BY name ASC
    0.00036287307739258SELECT `query`, keyword FROM seo_url WHERE query like 'manufacturer_id=%'
    0.001802921295166SELECT p.product_id FROM `product` p WHERE p.status = 1 AND p.manufacturer_id IN (291)
    0.0015320777893066SELECT p.product_id FROM `product` p WHERE p.status = 1 AND p.manufacturer_id IN (291)
    0.026028871536255SELECT 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 (215198,215485,215487,215514,215525,215568,215571,215605,215606,215623,215650,215651,215652,215653,215654,215655,215656,215657,215658,215659,215660,215706,215707,215708,215709,215710,215711,215712,215713,215714,215715,215780,215852,215939,216177,216178,216310,216326,216496,216598,216679,216764,216807,216830,216963,217062,217063,217191,217250,217251,217252,217253,217254,217255,217256,217257,217258,217259,217315,217316,217319,217320,217321,217322,217323,217324,217332,217333,217334,217335,217336,217337,217338,217395,217448,217495,217508,217509,217510,217529,217578,217579,217580,217581,217582,217583,217694,217695,217812,217966,217967,218035,218114,218240,218333,218335,218336,218337,218338,218339,218340,218341,218343,218345,218347,218348,218349,218350,218351,218352,218353,218354,218355,218356,218471,218472,218535,218706,218707,218730,218731,218732,218733,218763,218807,218808,218809,218810,218811,218812,218813,218816,218819,218821,218822,218823,218824,218825,218826,218827,218834,218863,218864,218865,218866,218867,218868,218869,218870,218871,218872,218873,218874,218875,218876,218877,218878,218879,218880,218881,218882,218883,218884,218885,218886,218887,218888,219217,219218,219253,219384,219392,219437,219474,219475,219477,219478,219493,219523,219543,219544,219545,219546,219547,219553,219565,219568,219569,219593,219605,219635,219930,220025,220026,220027,220028,220098,220307,220308,220309,220310,220533,220539,220546,220649,220650,220651,220652,220707,221046,221551,221552,221553,221627,221628,221629,221637,221779,221842,221903,221904,221905,222104,222105,222106,222107,222116,222117,222118,222119,222120,222121,222610,222612,222613,222614,222615,222616,222617,222618,222620,222621,222622,222624,222625,222626,222627,222628,222629,222642,222802,222851,222852,222853,222990,223039,223083,223134,223181,223182,223354,223355,223431,223556,223783,223784,223808,223809,223824,223850,223883,223884,223953,223974,223989,223990,223991,223992,224023,224024,224034,224035,224237,224238,224239,224240,224571,224573,224775,224776,224926,224927,224969,224970,224971,224972,224973,224974,224975,224976,225025,225026,225054,225055,225056,225251,225252,225253,225254,225356,225357,225358,225359,225444,225445,225446,225575,239069,239071,239072,239073,239074,239076,239078,239079,239080,239081,239082,239083,239084,239085,239086,239087,239088,239089,239090,239091,239092,239093,239094,239095,239096,239097,239098,239099,239100,239101,239252,239405,239406,239407,239408,239570,239571,239916,239917,239918,239919,239920,239921,239922,239923,239924,239925,239926,239927,240180,240430,240431,240432,240536,240539,240574,240575,240576,240577,240578,240579,240582,240668,240669,240670,240780,240781,240897,240898,240899,240900,240976,241200,241201,241214,241344,241345,241346,241486,241487,241488,241523,241524,241648,241650,241670,241671,241672,241674,241676,241681,241687,241733,241734,242328,242525,242527,242528,242529,243152,243153,243154,243155,243156,243158,243212,243214,243908,244462,244583,244584,244611,244738,244900,244901,245007,245008,245294,245295,245336,245337,245437,245438,245439,245440,245478,245479,245480,245481,245812,246009,246010,246011,246012,246013,246014,246015,246016,246017,246018,246019,246109,246110,246111,246112,246286,246287,246321,246332,246333,246334,246710,246781,246782,246783,246834,246835,246836,246841,246848,246860,247005,247006,247014,247044,247045,247300,247301,247302,247303,247304,247305,247309,247310,247366,247367,247368,247371,247372,247373,247374,247375,247376,247377,247378,247379,247380,247381,247386,247394,247395,247449,247450,247466,247467,247582,247583,247584,247772,248007,248008,248009,248010,248023,248221,248240,248241,248612,248613,248614,248615,248616,248625,248629,248630,248631,248700,248733,248734,248735,248736,248737,248764,248765,248766,248767,248918,249033,249034,249035,249036,249037,249038,249039,249040,249041,249054,249242,249297,249298,249509,249523,249854,249886,250055,250056,250057,250058,250059,250060,250194,250195,250196,250197,250198,250199,250200,250201,250282,250283,250284,250285,250313,250449,250450,250556,250558,250559,250560,250594,250595,250597,250618,250619,250620,250786,250793,250794,250845,250846,250847,250848,250849,251045,251046,251047,251269,251302,251310,251334,251346,251360,251383,251418,251420,251430,251456,251496,251499,251509,251528,251531,251532,251538,251612,251626,251654,251655,251669,251676,251683,251698,251757,251789,251792,251793,251834,251835,251858,251859,251883,251888,251896,251974,251978,251985,252017,252036,252062,252064,252073,252075,252124,252129,252131,252148,252150,252151,252155,252166,252169,252173,252175,252178,252182,252189,252211,252231,252347,252440,252537,252615,252616,252643,252656,252663,252669,252675,252695,252696,252725,252739,252808,252813,252825,252831,252845,252859,252864,252880,252884,252915,252918,252928,252942,252993,252996,253007,253029,253079,253113,253118,253133,253162,253169,253176,253205,253244,253264,253273,253284,253295,253308,253374,253377,253409,253415,253427,253476,253495,253550,253555,253634,253638,253672,253689,253694,253705,253728,253763,253769,253781,253811,253854,253879,253902,253966,253973,253999,254039,254045,254072,254074,254120,254151,254153,254155,254177,254178,254193,254206,254208,254223,254230,254243,254282,254296,254341,254348,254359,254368,254377,254417,254420,254462,254488,254489,254505,254512,254576,254588,254594,254605,254613,254626,254647,254651,254676,254713,254720,254729,254777,254794,254819,254821,254841,254850,254902,254910,254925,254931,254938,254942,255004,255010,255014,255018,255038,255075,255082,255095,255097,255103,255109,255111,255129,255130,255174,255194,255196,255198,255201,255220,255230,255248,255271,255307,255347,255354,255371,255381,255391,255394,255402,255419,255425,255434,255489,255499,255583,255585,255596,255601,255609,255620,255707,255708,255717,255731,255801,255823,255881,255910,255926,255945,255974,255979,256008,256058,256064,256065,256107,256116,256136,256137,256150,256156,256165,256197,256205,256225,256284,256286,256290,256371,256380,256384,256408,256437,256447,256452,256453,256570,256600,256671,256672,256713,256714,256715,256716,256747,256748,256749,256750,256858,256862,256868,256869,256870,256871,256886,256910,256916,256917,256918,256923,256928,256929,256959,256999,257000,257054,257055,257056,257115,257125,257126,257318,257329,257330,257343,257344,257363,257374,257387,257433,257449,257503,257512,257513,257580,257584,257627,257678,257693,257695,257740,257755,257756,257757,257760,257780,257825,257826,257827,257828,257849,257850,257851,257852,257853,257854,257855,257856,257857,257859,257891,257892,257893,257930,257931,257961,257964,257966,257967,257968,257969,258029,258030,258031,258051,258060,258061,258084,258102,258208,258209,258210,258226,258249,258266,258273,258313,258331,258332,258333,258368,258387,258404,258412,258436,258437,258483,258484,258681,258689,258746,258807,258917,259007,259032,259064,259077,259102,259136,259160,259161,259167,259171,259187,259199,259211,259219,259239,259243,259263,259276,259281,259285,259293,259302,259326,259352,259365,259368,259387,259390,259392,259393,259434,259447,259523,259536,259537,259540,259553,259554,259560,259572,259586,259587,261738,261747,261809,261813,261814,261838,261845,261859,261867,261874,261897,261903,261916,261930,273793,273800) AND p.manufacturer_id = '291' 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.00055503845214844SELECT 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 = '223974' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00040817260742188SELECT 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 = '219437' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00036311149597168SELECT 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 = '246109' 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 = '253295' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00038003921508789SELECT 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 = '249041' 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 = '255248' 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 = '249039' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00032901763916016SELECT 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 = '249040' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00035285949707031SELECT 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 = '252864' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00032806396484375SELECT 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 = '249038' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00034713745117188SELECT 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 = '257125' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.0003359317779541SELECT 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 = '257126' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00033879280090332SELECT 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 = '258484' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00036191940307617SELECT 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 = '251789' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00046610832214355SELECT 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 = '259586' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00034785270690918SELECT 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 = '259523' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.0003960132598877SELECT 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 = '261867' 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 = '247014' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.0001220703125SELECT 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 = '291' AND m2s.store_id = '0'
    0.00027894973754883SELECT * 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 = '223974' 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 = '223974' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.0005338191986084SELECT * 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 = '219437' AND od.language_id = '1' ORDER BY o.sort_order
    0.00018310546875SELECT 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 = '219437' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.0002281665802002SELECT * 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 = '246109' 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 = '246109' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00023603439331055SELECT * 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 = '253295' 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 = '253295' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00020194053649902SELECT * 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 = '249041' AND od.language_id = '1' ORDER BY o.sort_order
    0.00016403198242188SELECT 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 = '249041' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00019693374633789SELECT * 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 = '255248' AND od.language_id = '1' ORDER BY o.sort_order
    0.00014996528625488SELECT 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 = '255248' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00020194053649902SELECT * 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 = '249039' AND od.language_id = '1' ORDER BY o.sort_order
    0.00016117095947266SELECT 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 = '249039' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00020885467529297SELECT * 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 = '249040' AND od.language_id = '1' ORDER BY o.sort_order
    0.00016403198242188SELECT 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 = '249040' 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 = '252864' AND od.language_id = '1' ORDER BY o.sort_order
    0.00015401840209961SELECT 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 = '252864' 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 = '249038' AND od.language_id = '1' ORDER BY o.sort_order
    0.00014209747314453SELECT 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 = '249038' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00017499923706055SELECT * 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 = '257125' AND od.language_id = '1' ORDER BY o.sort_order
    0.00013399124145508SELECT 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 = '257125' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00019121170043945SELECT * 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 = '257126' AND od.language_id = '1' ORDER BY o.sort_order
    0.00014996528625488SELECT 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 = '257126' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00021195411682129SELECT * 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 = '258484' AND od.language_id = '1' ORDER BY o.sort_order
    0.00014996528625488SELECT 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 = '258484' 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 = '251789' AND od.language_id = '1' ORDER BY o.sort_order
    0.00013113021850586SELECT 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 = '251789' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00017714500427246SELECT * 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 = '259586' AND od.language_id = '1' ORDER BY o.sort_order
    0.0001368522644043SELECT 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 = '259586' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00016689300537109SELECT * 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 = '259523' 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 = '259523' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00017213821411133SELECT * 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 = '261867' AND od.language_id = '1' ORDER BY o.sort_order
    0.00014805793762207SELECT 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 = '261867' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.0001981258392334SELECT * 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 = '247014' 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 = '247014' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.0001220703125SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'product/buyclick_form'
    8.702278137207E-5SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'product/category_micro'
    0.00048208236694336show tables like 'manufacturer_description'
    0.00034403800964355SHOW COLUMNS FROM `manufacturer_description` LIKE 'name';
    0.00029206275939941SELECT m.manufacturer_id, m.`sort_order`, m.name FROM `manufacturer` m ORDER BY name ASC
    0.00038814544677734SELECT `query`, keyword FROM seo_url WHERE query like 'manufacturer_id=%'
    0.00020694732666016SELECT * FROM layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
    0.00015091896057129SELECT * FROM layout_module WHERE layout_id = '17' AND position = 'column_left' ORDER BY sort_order
    7.7962875366211E-5SELECT * FROM module WHERE module_id = '80'
    0.0002591609954834SELECT 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 = '291' AND m2s.store_id = '0'
    0.00013494491577148SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/ocdepartment' OR route = 'ru-ru')
    0.00040888786315918SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'extension/module/ocdepartment/module'
    0.0002448558807373SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/column_left'
    0.0001828670501709SELECT * FROM layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
    0.0001378059387207SELECT * FROM layout_module WHERE layout_id = '17' AND position = 'column_right' ORDER BY sort_order
    0.00013399124145508SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/column_right'
    0.00015997886657715SELECT * FROM layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
    0.0001380443572998SELECT * FROM layout_module WHERE layout_id = '17' AND position = 'content_top' ORDER BY sort_order
    9.8943710327148E-5SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/content_top'
    0.001255989074707SELECT * FROM layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
    0.0001990795135498SELECT * FROM layout_module WHERE layout_id = '17' AND position = 'content_bottom' ORDER BY sort_order
    8.9168548583984E-5SELECT * FROM module WHERE module_id = '81'
    0.00010585784912109SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'extension/module/html'
    0.00011587142944336SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/content_bottom'
    0.00012493133544922SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru')
    0.0004730224609375SELECT * 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.0001528263092041SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    0.00017285346984863SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru')
    0.00011491775512695SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'product/buyclick_form'
    0.00011205673217773SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    0.0015771389007568SELECT * FROM setting WHERE store_id = '0' AND `code` = 'theme_technicssoclinks'
    0.001107931137085SELECT * FROM setting WHERE store_id = '0' AND `code` = 'theme_technicsmeslinks'
    0.0002448558807373SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'extension/module/callback'
    0.0001680850982666SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/footer'
    0.00014710426330566SELECT * FROM extension WHERE `type` = 'analytics'
    0.0001530647277832SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
    0.00012493133544922SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    0.00015997886657715SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9c5ea9dd1d001c9e488d14d9b5'
    0.00018191337585449SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/compare' OR route = 'ru-ru')
    0.00013995170593262SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/compare' OR route = 'ru-ru')
    0.00013303756713867SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
    0.00013494491577148SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    0.00013518333435059SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'account/wishlist' OR route = 'ru-ru')
    0.00012588500976562SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    0.00030398368835449SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'account/wish_head'
    0.00018715858459473SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'product/compare_head'
    0.00034904479980469SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')
    0.00023388862609863SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/language'
    0.00017118453979492SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
    0.00012803077697754SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/currency'
    0.00013399124145508SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru')
    0.00015401840209961SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/search'
    0.00015091896057129SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')
    0.00019502639770508SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9c5ea9dd1d001c9e488d14d9b5'
    0.00013613700866699SELECT * FROM extension WHERE `type` = 'total'
    0.00012588500976562SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/sub_total' OR route = 'ru-ru')
    0.00012302398681641SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9c5ea9dd1d001c9e488d14d9b5'
    0.00012397766113281SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9c5ea9dd1d001c9e488d14d9b5'
    0.00012111663818359SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru')
    0.00010204315185547SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9c5ea9dd1d001c9e488d14d9b5'
    0.00010800361633301SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    0.00013184547424316SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9c5ea9dd1d001c9e488d14d9b5'
    0.00011897087097168SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru')
    0.0001368522644043SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = '9c5ea9dd1d001c9e488d14d9b5'
    0.0001370906829834SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'product/buyclick_form'
    0.0001220703125SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/cart'
    0.0001521110534668SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/menu' OR route = 'ru-ru')
    0.0004570484161377SELECT * 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.00043320655822754SELECT * 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.00052595138549805SELECT * 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.00043296813964844SELECT * 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.0005190372467041SELECT * 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.00034189224243164SELECT * 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.00037479400634766SELECT * 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.00043487548828125SELECT * 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.0002751350402832SELECT * 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.00037789344787598SELECT * 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.0003352165222168SELECT * 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.0002741813659668SELECT * 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.00011205673217773SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/menu'
    0.0001680850982666SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'extension/module/callback'
    0.00011205673217773SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/header_4'
    0.00013303756713867SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/header'
    0.00099301338195801SELECT * FROM setting WHERE store_id = '0' AND `code` = 'advertise_google'
    0.00014114379882812SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'product/manufacturer_info'