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

Отдел продаж

+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

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

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

SANT

О бренде:

ООО Zhuzhou Sant Cutting Tools Co.,Ltd — это предприятие, специализирующийся на дизайне и производстве режущих инструментов типа CNC. Широкая производственная линейка включает: инструменты токарной обработки (держатели инструментов типа P,M,D,S,W,C внутренние и внешние держатели для резьбонарезных пластин, отрезной и канавочные резцы и т.д.), а также фрезеровочные инструменты типа (корпусные фрезы для  торцевого фрезерования, инструменты ступенчатого фрезерования, фрезерная головка с быстрой подачей, резец обратного движения под силой тяжести, фасонный резец и т.д), буровой инструмент (U буры, расточный резец и т.д.) и система вспомогательных инструментов. Компания является одной из крупнейших баз по производству твердых сплавов в Китае.

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

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

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

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

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

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

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

Наверх
  • WhatsApp

  • Skype

  • Viber

    Viber

  • Telegram

  • Debug SQL
    0.00085997581481934SELECT value FROM setting WHERE `key` = 'redirector_status'
    0.00012302398681641SELECT `url_to` FROM redirector WHERE status = 1 AND url_to != '' AND url_from = 'sant/' ORDER BY redirect_id DESC LIMIT 1
    0.00088405609130859SELECT value FROM setting WHERE store_id = '0' AND `key`='config_seo_url_type'
    6.5088272094727E-5SET time_zone = '+00:00'
    0.0014297962188721DELETE FROM `session` WHERE `expire` < '2022-10-06 13:04:31'
    0.00018310546875SELECT * FROM translation WHERE store_id = '0' AND language_id = '0' AND (route = 'engb' OR route = '')
    0.00015687942504883SELECT `data` FROM `session` WHERE `session_id` = 'd04e1861ef158ae85fc1f9c70f' AND `expire` > '2022-10-06 13:04:31'
    9.8943710327148E-5SELECT * FROM store WHERE REPLACE(`ssl`, 'www.', '') = 'https://imperial-tools.ru/'
    0.0019078254699707SELECT * FROM `setting` WHERE store_id = '0' OR store_id = '0' ORDER BY store_id ASC
    9.4890594482422E-5SET time_zone = '+10:00'
    0.00017094612121582SELECT * FROM currency
    0.00031709671020508SELECT 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.00023913383483887SELECT 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.00012993812561035SELECT * 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.00011491775512695SELECT * 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.00012779235839844DELETE FROM cart WHERE (api_id > '0' OR customer_id = '0') AND date_added < DATE_SUB(NOW(), INTERVAL 12 MONTH)
    0.00019598007202148SELECT * FROM `event` WHERE `trigger` LIKE 'catalog/%' AND status = '1' ORDER BY `sort_order` ASC
    0.00012016296386719SELECT c.* FROM prmn_cm_city c ORDER BY sort, name
    0.00011110305786133SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'extension/module/progroman/citymanager/content'
    0.00046277046203613show tables like 'manufacturer_description'
    0.00020217895507812SHOW COLUMNS FROM `manufacturer_description` LIKE 'name';
    0.00021910667419434SELECT m.manufacturer_id, m.`sort_order`, m.name FROM `manufacturer` m ORDER BY name ASC
    0.00034618377685547SELECT `query`, keyword FROM seo_url WHERE query like 'manufacturer_id=%'
    0.00048494338989258show tables like 'manufacturer_description'
    0.00018000602722168SHOW COLUMNS FROM `manufacturer_description` LIKE 'name';
    0.0001990795135498SELECT m.manufacturer_id, m.`sort_order`, m.name FROM `manufacturer` m ORDER BY name ASC
    0.00035595893859863SELECT `query`, keyword FROM seo_url WHERE query like 'manufacturer_id=%'
    0.00019693374633789SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/manufacturer' OR route = 'ru-ru')
    0.00017404556274414SELECT 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 = '211' AND m2s.store_id = '0'
    0.00013399124145508SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    0.00011110305786133SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru')
    0.00046992301940918show tables like 'manufacturer_description'
    0.00019097328186035SHOW COLUMNS FROM `manufacturer_description` LIKE 'name';
    0.00020909309387207SELECT m.manufacturer_id, m.`sort_order`, m.name FROM `manufacturer` m ORDER BY name ASC
    0.00033402442932129SELECT `query`, keyword FROM seo_url WHERE query like 'manufacturer_id=%'
    0.00092506408691406SELECT p.product_id FROM `product` p WHERE p.status = 1 AND p.manufacturer_id IN (211)
    0.0076460838317871SELECT 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 (215115,215150,215199,215200,215201,215202,215203,215204,215205,215206,215207,215208,215209,215210,215211,215212,215213,215247,215253,215254,215421,215422,215423,215424,215425,215428,215496,215497,215498,215499,215500,215588,215589,215664,215681,215682,215722,215744,215820,215938,215942,215943,216697,216901,216902,216903,216908,216911,216912,216938,217144,217145,217146,217162,217209,217218,217219,217220,217233,217234,217325,217327,217339,217354,217369,217370,217371,217372,217524,217525,217526,217527,217569,217616,217618,217619,217620,217623,217632,217633,217634,217635,217910,217911,218183,218186,218190,218407,218408,218479,218500,218605,218606,218608,218738,218984,219315,219316,219317,219318,219359,219360,219361,219383,219391,219408,219470,219471,219570,219588,219604,219616,219617,219618,219619,219620,219621,219711,219712,219863,219864,219866,219910,220017,220258,220259,220260,220376,220389,220416,220417,220552,220580,220582,220606,220615,220679,220721,220781,220853,220896,221196,221214,221215,221216,221217,221218,221219,221220,221221,221222,221223,221274,221350,221400,221404,221405,221406,221407,221408,221520,221527,221538,221540,221541,221766,221834,221837,222252,222253,222254,222279,222281,222282,222484,222547,222548,222549,222550,222551,222552,222553,222554,222555,222556,222557,222558,222559,222560,222696,222697,222698,222700,222701,222702,222703,222704,222705,222706,222707,222708,222803,222804,222952,222954,222955,222986,223040,223059,223184,223242,223480,223481,223532,223880,223933,223938,223940,223941,224028,224152,224153,224154,224379,224380,224381,224730,224782,225237,225238,225239,225240,225241,225242,225243,225323,225363,230550,230695,231630,239264,239910,239911,239912,240110,240111,240112,240113,240114,240115,240116,240117,240188,240214,240273,240274,240571,240572,240573,240741,240745,240746,240747,240980,240981,241209,241282,241480,241751,241752,241753,242558,242559,242671,242672,242673,243168,243181,243182,243185,243190,243196,243197,243200,243201,243646,244160,244162,245183,245314,245315,245316,245317,245331,245345,245352,245353,245557,245632,245721,245734,245834,245853,245911,245912,245913,245914,245916,245968,245976,245978,246075,246079,246153,246241,246266,246270,246375,246414,246507,246515,246586,246593,246625,246825,246826,246828,246863,246897,246911,247284,247291,247411,247420,247427,247455,247461,247496,247567,247591,247607,247608,247609,247610,247652,247691,247706,247753,247768,247849,247852,247939,248198,248203,248239,248281,248282,248453,248491,248499,248525,248574,248598,248646,248707,248723,248753,248894,248916,248991,249047,249057,249058,249059,249133,249202,249211,249246,249247,249494,249518,249532,249534,249606,249704,249893,250068,250117,250128,250176,250177,250266,250377,250390,250392,250393,250394,250447,250701,250835,250836,250837,250838,250943,250950,250951,250953,250967,250968,250979,250990,251036,251037,251094,251096,251223,251271,251272,251273,251275,251294,251326,251344,251355,251361,251487,251492,251510,251597,251607,251640,251643,251647,251728,251772,251787,251798,251810,251813,251844,251918,251944,251954,251959,251973,251996,252011,252024,252056,252081,252085,252101,252110,252118,252130,252145,252191,252195,252203,252412,252569,252633,252672,252692,252710,252715,252723,252734,252750,252752,252796,252818,252848,252862,252922,252956,253000,253033,253037,253078,253094,253115,253138,253148,253209,253249,253294,253314,253338,253361,253371,253389,253394,253395,253403,253416,253438,253448,253493,253513,253525,253527,253609,253618,253662,253667,253706,253746,253766,253770,253789,253815,253829,253862,253872,253881,253924,253964,253972,253979,254006,254048,254058,254103,254204,254218,254222,254293,254297,254302,254308,254316,254319,254326,254373,254384,254385,254423,254427,254432,254473,254515,254559,254580,254608,254675,254707,254766,254795,254832,254834,254864,254867,254872,254892,254909,255025,255030,255033,255039,255066,255100,255127,255146,255152,255187,255210,255258,255301,255304,255385,255415,255529,255556,255560,255580,255593,255618,255676,255695,255712,255724,255742,255798,255855,255922,255977,255994,256037,256053,256160,256277,256282,256326,256339,256342,256353,256355,256459,256556,256564,256580,256685,256809,256810,256822,256881,256882,256883,256884,256885,256892,256904,256905,256906,257076,257077,257078,257105,257106,257107,257108,257109,257110,257111,257112,257113,257114,257130,257131,257240,257241,257256,257416,257579,257613,257614,257615,257661,257689,257691,257694,257696,257697,257698,257699,257700,257702,257703,257704,257705,257706,257717,257718,257719,257720,257744,257872,257945,257946,257988,257990,257991,257992,258056,258121,258170,258171,258172,258173,258174,258175,258177,258178,258203,258220,258221,258285,258286,258306,258307,258308,258309,258326,258344,258345,258346,258348,258349,258350,258378,258538,258554,258564,258586,258629,258685,258699,258783,258987,259012,259081,259484,259490,259508,261585,261597,261636,261648,261677) AND p.manufacturer_id = '211' GROUP BY p.product_id
    0.001025915145874SELECT p.product_id FROM `product` p WHERE p.status = 1 AND p.manufacturer_id IN (211)
    0.020008087158203SELECT 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 (215115,215150,215199,215200,215201,215202,215203,215204,215205,215206,215207,215208,215209,215210,215211,215212,215213,215247,215253,215254,215421,215422,215423,215424,215425,215428,215496,215497,215498,215499,215500,215588,215589,215664,215681,215682,215722,215744,215820,215938,215942,215943,216697,216901,216902,216903,216908,216911,216912,216938,217144,217145,217146,217162,217209,217218,217219,217220,217233,217234,217325,217327,217339,217354,217369,217370,217371,217372,217524,217525,217526,217527,217569,217616,217618,217619,217620,217623,217632,217633,217634,217635,217910,217911,218183,218186,218190,218407,218408,218479,218500,218605,218606,218608,218738,218984,219315,219316,219317,219318,219359,219360,219361,219383,219391,219408,219470,219471,219570,219588,219604,219616,219617,219618,219619,219620,219621,219711,219712,219863,219864,219866,219910,220017,220258,220259,220260,220376,220389,220416,220417,220552,220580,220582,220606,220615,220679,220721,220781,220853,220896,221196,221214,221215,221216,221217,221218,221219,221220,221221,221222,221223,221274,221350,221400,221404,221405,221406,221407,221408,221520,221527,221538,221540,221541,221766,221834,221837,222252,222253,222254,222279,222281,222282,222484,222547,222548,222549,222550,222551,222552,222553,222554,222555,222556,222557,222558,222559,222560,222696,222697,222698,222700,222701,222702,222703,222704,222705,222706,222707,222708,222803,222804,222952,222954,222955,222986,223040,223059,223184,223242,223480,223481,223532,223880,223933,223938,223940,223941,224028,224152,224153,224154,224379,224380,224381,224730,224782,225237,225238,225239,225240,225241,225242,225243,225323,225363,230550,230695,231630,239264,239910,239911,239912,240110,240111,240112,240113,240114,240115,240116,240117,240188,240214,240273,240274,240571,240572,240573,240741,240745,240746,240747,240980,240981,241209,241282,241480,241751,241752,241753,242558,242559,242671,242672,242673,243168,243181,243182,243185,243190,243196,243197,243200,243201,243646,244160,244162,245183,245314,245315,245316,245317,245331,245345,245352,245353,245557,245632,245721,245734,245834,245853,245911,245912,245913,245914,245916,245968,245976,245978,246075,246079,246153,246241,246266,246270,246375,246414,246507,246515,246586,246593,246625,246825,246826,246828,246863,246897,246911,247284,247291,247411,247420,247427,247455,247461,247496,247567,247591,247607,247608,247609,247610,247652,247691,247706,247753,247768,247849,247852,247939,248198,248203,248239,248281,248282,248453,248491,248499,248525,248574,248598,248646,248707,248723,248753,248894,248916,248991,249047,249057,249058,249059,249133,249202,249211,249246,249247,249494,249518,249532,249534,249606,249704,249893,250068,250117,250128,250176,250177,250266,250377,250390,250392,250393,250394,250447,250701,250835,250836,250837,250838,250943,250950,250951,250953,250967,250968,250979,250990,251036,251037,251094,251096,251223,251271,251272,251273,251275,251294,251326,251344,251355,251361,251487,251492,251510,251597,251607,251640,251643,251647,251728,251772,251787,251798,251810,251813,251844,251918,251944,251954,251959,251973,251996,252011,252024,252056,252081,252085,252101,252110,252118,252130,252145,252191,252195,252203,252412,252569,252633,252672,252692,252710,252715,252723,252734,252750,252752,252796,252818,252848,252862,252922,252956,253000,253033,253037,253078,253094,253115,253138,253148,253209,253249,253294,253314,253338,253361,253371,253389,253394,253395,253403,253416,253438,253448,253493,253513,253525,253527,253609,253618,253662,253667,253706,253746,253766,253770,253789,253815,253829,253862,253872,253881,253924,253964,253972,253979,254006,254048,254058,254103,254204,254218,254222,254293,254297,254302,254308,254316,254319,254326,254373,254384,254385,254423,254427,254432,254473,254515,254559,254580,254608,254675,254707,254766,254795,254832,254834,254864,254867,254872,254892,254909,255025,255030,255033,255039,255066,255100,255127,255146,255152,255187,255210,255258,255301,255304,255385,255415,255529,255556,255560,255580,255593,255618,255676,255695,255712,255724,255742,255798,255855,255922,255977,255994,256037,256053,256160,256277,256282,256326,256339,256342,256353,256355,256459,256556,256564,256580,256685,256809,256810,256822,256881,256882,256883,256884,256885,256892,256904,256905,256906,257076,257077,257078,257105,257106,257107,257108,257109,257110,257111,257112,257113,257114,257130,257131,257240,257241,257256,257416,257579,257613,257614,257615,257661,257689,257691,257694,257696,257697,257698,257699,257700,257702,257703,257704,257705,257706,257717,257718,257719,257720,257744,257872,257945,257946,257988,257990,257991,257992,258056,258121,258170,258171,258172,258173,258174,258175,258177,258178,258203,258220,258221,258285,258286,258306,258307,258308,258309,258326,258344,258345,258346,258348,258349,258350,258378,258538,258554,258564,258586,258629,258685,258699,258783,258987,259012,259081,259484,259490,259508,261585,261597,261636,261648,261677) AND p.manufacturer_id = '211' 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.00051093101501465SELECT 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 = '246586' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00035309791564941SELECT 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 = '218738' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00035500526428223SELECT 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 = '251037' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00036001205444336SELECT 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 = '247849' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00044798851013184SELECT 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 = '230550' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00038409233093262SELECT 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 = '231630' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00042891502380371SELECT 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 = '248198' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00041985511779785SELECT 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 = '222252' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00039792060852051SELECT 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 = '245345' 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 = '215204' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00043821334838867SELECT 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 = '215205' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00044107437133789SELECT 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 = '246911' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00037884712219238SELECT 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 = '217569' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00038599967956543SELECT 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 = '259490' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00041508674621582SELECT 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 = '253924' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00039100646972656SELECT 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 = '247607' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00039196014404297SELECT 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 = '221219' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00040388107299805SELECT 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 = '221221' AND pd.language_id = '1' AND p.status = '1' AND p.date_available <= NOW() AND p2s.store_id = '0'
    0.00013995170593262SELECT 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 = '211' AND m2s.store_id = '0'
    0.00026512145996094SELECT * 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 = '246586' AND od.language_id = '1' ORDER BY o.sort_order
    0.00016498565673828SELECT 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 = '246586' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00032615661621094SELECT * 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 = '218738' AND od.language_id = '1' ORDER BY o.sort_order
    0.00019621849060059SELECT 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 = '218738' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00018906593322754SELECT * 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 = '251037' AND od.language_id = '1' ORDER BY o.sort_order
    0.00016188621520996SELECT 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 = '251037' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00019598007202148SELECT * 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 = '247849' AND od.language_id = '1' ORDER BY o.sort_order
    0.0001370906829834SELECT 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 = '247849' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00025010108947754SELECT * 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 = '230550' AND od.language_id = '1' ORDER BY o.sort_order
    0.00014901161193848SELECT 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 = '230550' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00017404556274414SELECT * 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 = '231630' AND od.language_id = '1' ORDER BY o.sort_order
    0.00014686584472656SELECT 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 = '231630' 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 = '248198' AND od.language_id = '1' ORDER BY o.sort_order
    0.00016307830810547SELECT 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 = '248198' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00022220611572266SELECT * 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 = '222252' 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 = '222252' 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 = '245345' AND od.language_id = '1' ORDER BY o.sort_order
    0.00013589859008789SELECT 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 = '245345' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.0001828670501709SELECT * FROM product_option po LEFT JOIN `option` o ON (po.option_id = o.option_id) LEFT JOIN option_description od ON (o.option_id = od.option_id) WHERE po.product_id = '215204' AND od.language_id = '1' ORDER BY o.sort_order
    0.00012397766113281SELECT 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 = '215204' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00015997886657715SELECT * 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 = '215205' AND od.language_id = '1' ORDER BY o.sort_order
    0.00013017654418945SELECT 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 = '215205' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00019001960754395SELECT * 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 = '246911' AND od.language_id = '1' ORDER BY o.sort_order
    0.00014495849609375SELECT 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 = '246911' 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 = '217569' 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 = '217569' 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 = '259490' AND od.language_id = '1' ORDER BY o.sort_order
    0.00013184547424316SELECT 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 = '259490' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.0001838207244873SELECT * 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 = '253924' AND od.language_id = '1' ORDER BY o.sort_order
    0.00013589859008789SELECT 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 = '253924' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00022006034851074SELECT * 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 = '247607' 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 = '247607' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00016379356384277SELECT * 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 = '221219' 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 = '221219' 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 = '221221' AND od.language_id = '1' ORDER BY o.sort_order
    0.00014305114746094SELECT ag.attribute_group_id, agd.name FROM product_attribute pa LEFT JOIN attribute a ON (pa.attribute_id = a.attribute_id) LEFT JOIN attribute_group ag ON (a.attribute_group_id = ag.attribute_group_id) LEFT JOIN attribute_group_description agd ON (ag.attribute_group_id = agd.attribute_group_id) WHERE pa.product_id = '221221' AND agd.language_id = '1' GROUP BY ag.attribute_group_id ORDER BY ag.sort_order, agd.name
    0.00010895729064941SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'product/buyclick_form'
    8.2969665527344E-5SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'product/category_micro'
    0.00050997734069824show tables like 'manufacturer_description'
    0.00021100044250488SHOW COLUMNS FROM `manufacturer_description` LIKE 'name';
    0.00022792816162109SELECT m.manufacturer_id, m.`sort_order`, m.name FROM `manufacturer` m ORDER BY name ASC
    0.00037980079650879SELECT `query`, keyword FROM seo_url WHERE query like 'manufacturer_id=%'
    0.00017094612121582SELECT * FROM layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
    0.00017404556274414SELECT * FROM layout_module WHERE layout_id = '17' AND position = 'column_left' ORDER BY sort_order
    9.918212890625E-5SELECT * FROM module WHERE module_id = '80'
    0.00020909309387207SELECT 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 = '211' AND m2s.store_id = '0'
    0.00013089179992676SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/module/ocdepartment' OR route = 'ru-ru')
    0.020066976547241SELECT * 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 = '211') 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.00027012825012207SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'extension/module/ocdepartment/module'
    0.00025105476379395SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/column_left'
    0.00017905235290527SELECT * FROM layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
    0.00013303756713867SELECT * FROM layout_module WHERE layout_id = '17' AND position = 'column_right' ORDER BY sort_order
    0.0001220703125SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/column_right'
    0.00018906593322754SELECT * FROM layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
    0.00014615058898926SELECT * FROM layout_module WHERE layout_id = '17' AND position = 'content_top' ORDER BY sort_order
    0.00012779235839844SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/content_top'
    0.00012302398681641SELECT * FROM layout_route WHERE 'product/manufacturer/info' LIKE route AND store_id = '0' ORDER BY route DESC LIMIT 1
    9.3936920166016E-5SELECT * FROM layout_module WHERE layout_id = '17' AND position = 'content_bottom' ORDER BY sort_order
    7.2002410888672E-5SELECT * FROM module WHERE module_id = '81'
    0.00010108947753906SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'extension/module/html'
    0.00013113021850586SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/content_bottom'
    0.00017189979553223SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/footer' OR route = 'ru-ru')
    0.00042605400085449SELECT * 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.0001220703125SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    0.00012898445129395SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru')
    0.00012898445129395SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'product/buyclick_form'
    0.00013995170593262SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    0.0014901161193848SELECT * FROM setting WHERE store_id = '0' AND `code` = 'theme_technicssoclinks'
    0.0015230178833008SELECT * FROM setting WHERE store_id = '0' AND `code` = 'theme_technicsmeslinks'
    0.00014209747314453SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'extension/module/callback'
    0.00010395050048828SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/footer'
    0.00011587142944336SELECT * FROM extension WHERE `type` = 'analytics'
    0.0001370906829834SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
    9.7036361694336E-5SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    0.00012111663818359SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'd04e1861ef158ae85fc1f9c70f'
    0.00020098686218262SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/compare' OR route = 'ru-ru')
    0.0001671314239502SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'product/compare' OR route = 'ru-ru')
    0.00013613700866699SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/header' OR route = 'ru-ru')
    0.00011396408081055SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    8.392333984375E-5SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'account/wishlist' OR route = 'ru-ru')
    8.5830688476562E-5SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    0.00019407272338867SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'account/wish_head'
    0.00011587142944336SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'product/compare_head'
    0.00021576881408691SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/language' OR route = 'ru-ru')
    0.0001370906829834SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/language'
    0.0001530647277832SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/currency' OR route = 'ru-ru')
    0.00012302398681641SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/currency'
    0.00014901161193848SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/search' OR route = 'ru-ru')
    9.7036361694336E-5SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/search'
    0.00011205673217773SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/cart' OR route = 'ru-ru')
    0.00014090538024902SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'd04e1861ef158ae85fc1f9c70f'
    0.00010585784912109SELECT * FROM extension WHERE `type` = 'total'
    0.00013089179992676SELECT * 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 = 'd04e1861ef158ae85fc1f9c70f'
    0.00010108947753906SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'd04e1861ef158ae85fc1f9c70f'
    0.00010585784912109SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/total/total' OR route = 'ru-ru')
    9.5844268798828E-5SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'd04e1861ef158ae85fc1f9c70f'
    0.00015711784362793SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'extension/theme/technics' OR route = 'ru-ru')
    0.00014209747314453SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'd04e1861ef158ae85fc1f9c70f'
    0.0001220703125SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'checkout/checkout' OR route = 'ru-ru')
    0.00012898445129395SELECT * FROM cart WHERE api_id = '0' AND customer_id = '0' AND session_id = 'd04e1861ef158ae85fc1f9c70f'
    0.00011086463928223SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'product/buyclick_form'
    0.00013303756713867SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/cart'
    0.00013899803161621SELECT * FROM translation WHERE store_id = '0' AND language_id = '1' AND (route = 'common/menu' OR route = 'ru-ru')
    0.00061202049255371SELECT * 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.00066089630126953SELECT * 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.00056290626525879SELECT * 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.00055980682373047SELECT * 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.00062012672424316SELECT * 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.00049996376037598SELECT * 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.00051379203796387SELECT * 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.00034785270690918SELECT * 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.00023317337036133SELECT * 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.00025606155395508SELECT * 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.00025105476379395SELECT * 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.00023913383483887SELECT * 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.00010013580322266SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/menu'
    0.00011515617370605SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'extension/module/callback'
    0.00014185905456543SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/header_4'
    0.00013184547424316SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'common/header'
    0.001507043838501SELECT * FROM setting WHERE store_id = '0' AND `code` = 'advertise_google'
    0.00020098686218262SELECT * FROM theme WHERE store_id = '0' AND theme = 'technics' AND route = 'product/manufacturer_info'