SELECT name,value FROM config772μs128B930000000009a29c4f000000005316d5bfdefaultSELECT tb.key,tb2.value FROM translate tb LEFT JOIN ua_translate tb2 ON tb.id=tb2.translate_id2.56ms128B4170000000009a29c4f000000005316d5bfdefaultSELECT `to`, `type` FROM `redirects` WHERE `from`=? AND `from`!='' AND `to`!='' AND active='1'992μs1.04KB00000000009a29c78000000005316d5bfdefault| Params |
|
SELECT * FROM `currency` ORDER BY `id` ASC5.81ms648B20000000009a29c78000000005316d5bfdefaultSELECT id FROM modules WHERE `controller`=? AND `hidden`=?756μs1000B10000000009a29c7e000000005316d5bfdefault| Params |
|
SELECT * FROM `currency` WHERE `base`='1' 1.13ms648B10000000009a29c7e000000005316d5bfdefaultSELECT id FROM `price_type` WHERE `default`='1'962μs64B10000000009a29c74000000005316d5bfdefaultSELECT MIN(price) AS price FROM `price`1.29ms840B10000000009a29c7e000000005316d5bfdefault| Params |
|
SELECT MAX(price) AS price FROM `price`963μs840B10000000009a29c7e000000005316d5bfdefault| Params |
|
SHOW TABLES LIKE 'ua_catalog'1.3ms96B10000000009a29c42000000005316d5bfdefaultSELECT * FROM `catalog` `tb` LEFT JOIN `ua_catalog` tb_lang ON tb.id=tb_lang.catalog_id WHERE tb.active=? AND tb.url=? 807μs2.52KB00000000009a29c42000000005316d5bfdefault| Params |
|
SELECT COLUMN_NAME as name FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? 2.01ms1.02KB150000000009a29c42000000005316d5bfdefault| Params |
|
SHOW TABLES LIKE 'ua_catalog'1.24ms96B10000000009a29c42000000005316d5bfdefaultSELECT * FROM `catalog` `tb` LEFT JOIN `ua_catalog` tb_lang ON tb.id=tb_lang.catalog_id WHERE tb.active='1' GROUP BY tb.id ORDER BY tb.sort ASC, tb.id ASC, tb.id DESC 1.05ms1.52KB210000000009a29c42000000005316d5bfdefaultSELECT `id`, `url` FROM `product_status`1.05ms128B20000000009a29c42000000005316d5bfdefaultSHOW TABLES LIKE 'ua_catalog'2.64ms96B10000000009a29c42000000005316d5bfdefaultSELECT * FROM `catalog` `tb` LEFT JOIN `ua_catalog` tb_lang ON tb.id=tb_lang.catalog_id WHERE tb.active='1' AND tb.sub IS NULL GROUP BY tb.id ORDER BY tb.sort ASC, tb.id ASC, tb.id DESC 1.02ms1.52KB120000000009a29c42000000005316d5bfdefaultSELECT GROUP_CONCAT(tb.id) FROM `catalog` tb WHERE tb.active = '1'1.39ms80B10000000009a29c42000000005316d5bfdefaultSELECT GROUP_CONCAT(tb.id) FROM `product` tb WHERE tb.active = '1'1.53ms80B10000000009a29c42000000005316d5bfdefaultSELECT id FROM modules WHERE `controller`=? AND `hidden`=?3.37ms1000B10000000009a29c42000000005316d5bfdefault| Params |
|
SELECT params.id FROM params
LEFT JOIN params_catalog pc ON params.id = pc.params_id
WHERE params.active = '1' AND pc.catalog_id IN (1,2,4,5,6,8,9,10,11,12,13,14,16,17,21,24,27,28,29,30,31) AND params.sub IS NULL
1.44ms64B1420000000009a29c42000000005316d5bfdefault
SELECT params.id FROM params
LEFT JOIN params_product pp ON params.id = pp.params_id
LEFT JOIN product ON product.id = pp.product_id
LEFT JOIN product_catalog pc ON pc.product_id = product.id
WHERE product.active='1' AND params.active='1' AND params.sub IN(1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,1,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,8,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,12,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,15,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,19,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,28,44,44,44,44,44,44,44,44,44,44,44,61,508,508,508,508,508,508,508,508,508,508,508) AND pc.catalog_id IN (1,2,4,5,6,8,9,10,11,12,13,14,16,17,21,24,27,28,29,30,31)
GROUP BY params.id
602μs64B3630000000009a29c42000000005316d5bfdefaultSHOW TABLES LIKE 'ua_params'2.67ms96B10000000009a29c42000000005316d5bfdefaultSELECT tb.*, tb_lang.*, (SELECT GROUP_CONCAT(DISTINCT tb2.url) from params tb2 WHERE tb2.id IN (tb.id,0) ORDER BY tb.sort ASC) as filter_url FROM `params` `tb` LEFT JOIN `ua_params` tb_lang ON tb.id=tb_lang.params_id WHERE tb.active = '1' AND tb.id IN('3','4','5','6','7','9','10','11','13','14','16','17','18','20','21','24','25','26','27','29','30','32','33','34','35','36','37','38','40','43','45','46','47','48','52','53','54','55','56','58','71','73','74','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','94','95','96','97','98','99','103','104','105','106','107','108','109','110','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','156','158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','175','176','177','178','179','180','181','182','183','184','185','186','187','188','189','190','191','192','193','194','195','196','197','198','199','200','201','202','203','204','205','206','207','208','209','210','211','212','213','214','215','216','217','221','222','223','224','225','226','227','228','229','230','233','234','235','236','237','238','239','240','241','242','243','244','245','260','261','262','263','266','267','270','271','274','275','277','281','282','283','284','286','287','288','290','292','293','294','295','296','298','300','303','406','415','419','432','444','453','456','463','476','477','479','484','486','487','488','489','494','500','503','504','510','511','515','516','528','531','532','534','535','538','540','544','548','550','552','557','560','588','589','590','591','592','593','594','595','600','604','605','609','611','617','620','621','622','623','626','628','632','634','637','639','642','643','644','645','650','652','653','654','659','661','664','668','671','672','673','674','677','679','683','684','685','686','687','689','690','691','692','693','695','696','697','703','704','705','706','708','709','710','711','718','719','720','721','722','723','725','727','728','729','730','731','732','733','734','735','736','737','739','740','741','742','743','744','745','746','747','748','749','750','751','752','753','754') 1.71ms1.19KB3630000000009a29c42000000005316d5bfdefaultSHOW TABLES LIKE 'ua_params'3.16ms96B10000000009a29c42000000005316d5bfdefaultSELECT tb.*, tb_lang.* FROM `params` `tb` LEFT JOIN `ua_params` tb_lang ON tb.id=tb_lang.params_id LEFT JOIN (SELECT * FROM params WHERE sub IS NOT NULL) tb2 ON tb2.sub = tb.id WHERE tb.sub IS NULL AND tb.active = '1' AND tb2.id IN ('3','4','5','6','7','9','10','11','13','14','16','17','18','20','21','24','25','26','27','29','30','32','33','34','35','36','37','38','40','43','45','46','47','48','52','53','54','55','56','58','71','73','74','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','94','95','96','97','98','99','103','104','105','106','107','108','109','110','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','156','158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','175','176','177','178','179','180','181','182','183','184','185','186','187','188','189','190','191','192','193','194','195','196','197','198','199','200','201','202','203','204','205','206','207','208','209','210','211','212','213','214','215','216','217','221','222','223','224','225','226','227','228','229','230','233','234','235','236','237','238','239','240','241','242','243','244','245','260','261','262','263','266','267','270','271','274','275','277','281','282','283','284','286','287','288','290','292','293','294','295','296','298','300','303','406','415','419','432','444','453','456','463','476','477','479','484','486','487','488','489','494','500','503','504','510','511','515','516','528','531','532','534','535','538','540','544','548','550','552','557','560','588','589','590','591','592','593','594','595','600','604','605','609','611','617','620','621','622','623','626','628','632','634','637','639','642','643','644','645','650','652','653','654','659','661','664','668','671','672','673','674','677','679','683','684','685','686','687','689','690','691','692','693','695','696','697','703','704','705','706','708','709','710','711','718','719','720','721','722','723','725','727','728','729','730','731','732','733','734','735','736','737','739','740','741','742','743','744','745','746','747','748','749','750','751','752','753','754') GROUP BY tb.id ORDER BY tb.sort ASC 1.99ms1.02KB90000000009a29c42000000005316d5bfdefaultSHOW TABLES LIKE 'ua_params'2.54ms96B10000000009a29c42000000005316d5bfdefaultSELECT tb.*, tb_lang.*, (SELECT GROUP_CONCAT(DISTINCT tb2.url) from params tb2 WHERE tb2.id IN (tb.id,'') ORDER BY tb.sort ASC) as filter_url FROM `params` `tb` LEFT JOIN `ua_params` tb_lang ON tb.id=tb_lang.params_id WHERE tb.active = '1' AND tb.id IN(0) 4.06ms1.19KB00000000009a29c42000000005316d5bfdefaultSHOW TABLES LIKE 'ua_params'2.82ms96B10000000009a29c42000000005316d5bfdefaultSELECT tb.*, tb_lang.* FROM `params` `tb` LEFT JOIN `ua_params` tb_lang ON tb.id=tb_lang.params_id LEFT JOIN (SELECT * FROM params WHERE sub IS NOT NULL) tb2 ON tb2.sub = tb.id WHERE tb.sub IS NULL AND tb.active = '1' AND tb2.id IN (0) GROUP BY tb.id ORDER BY tb.sort ASC 1.09ms1.02KB00000000009a29c42000000005316d5bfdefaultSHOW TABLES LIKE 'ua_product'1.45ms96B10000000009a29c42000000005316d5bfdefaultSELECT count(*) as count, min(pr.price * c.rate) as min, max(pr.price * c.rate) as max FROM `product` `tb` LEFT JOIN `ua_product` tb_lang ON tb.id=tb_lang.product_id
LEFT JOIN price pr ON tb.id = pr.product_id
LEFT JOIN currency c ON pr.currency_id = c.id
WHERE tb.id IN('4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','40','41','42','43','44','47','48','49','50','51','52','53','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99','100','101','102','103','104','105','106','107','108','109','110','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','156','157','158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','175','176','177','178','179','180','181','182','183','184','185','186','187','188','189','190','191','195','196','197','198','199','200','201','202','203','204','205','206','207','208','209','210','211','212','213','214','215','216','217','218','219','220','221','222','223','224','225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','255','256','257','258','259','260','261','262','263','264','265','266','267','268','269','270','271','272','273','274','275','276','277','278','279','280','281','282','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','353','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412','413','414','415','416','417','418','419','420','421','422','423','424','425','426','427','428','429','430','431','432','433','434','435','436','438','439','440','441','442','443','444','445','446','447','448','449','450','451','452','453','454','455','456','457','458','459','460','461','462','463','464','465','466','467','468','469','470','471','472','473','474','475','476','477','478','479','480','481','482','483','484','485','486','487','488','489','490','491','493','494','495','496','497','498','499','500','501','502','503','504','505','506','507','508','509','510','511','512','513','514','515','516','518','519','520','521','522','523','524','525','526','527','528','529','530','531','532','533','534','535','536','537','538','540','541','542','543','544','545','546','547','548','549','550','551','552','553','554','556','557','558','559','560','561','562','563','564','565','566','567','568','569','570','571','572','573','574','575','576','577','578','579','580','581','582','583','584','585','586','587','588','589','590','591','592','593','594','595','596','597','598','599','600','601','602','603','604','605','606','607','608','609','610','611','612','613','614','615','616','617','618','619','620','621','622','623','624','625','626','627','628','629','630','631','632','633','634','635','636','637','638','639','640','641','642','643','644','645','646','647','648','649','650','651','652','653','654','655','656','657','658','659','660','661','662','663','664','665','666','667','668','669','670','671','672','673','674','675','676','677','678','679','680','681','682','683','684','685','686','687','688','689','690','691','692','693','694','695','697','698','699','700','701','703','704','705','706','707','709','710','711','712','713','714','715','716','717','718','720','721','722','723','725','726','727','728','730','731','732','733','735','736','737','738','739','740','741','743','744','745','746','747','748','749','750','751','752','753','754','755','756','757','758','759','760','761','762','763','764','765','766','767','768','769','770','771','772','773','774','775','776','777','778','779','780','781','782','783','784','785','786','787','788','789','790','791','792','793','794','796','797','798','799','800','801','802','803','804','805','806','807','808','809','810','811','812','813','814','815','816','818','819','820','821','822','823','824','825','826','827','829','830','831','835','837','838','839','840','841','842','843','844','845','846','847','848','849','850','851','852','853','854','855','856','857','858','859','860','861','862','863','864','865','866','867','868','869','870','871','872','873','874','875','876','877','878','879','880','881','882','883','884','885','886','887','889','890','891','892','893','894','895','896','897','898','899','900','901','902','903','904','905','906','907','908','909','910','911','912','914','915','916','917','919','920','921','922','924','925','926','927','928','929','930','931','932','933','934','935','936','937','938','939','940','941','942','943','944','945','946','947','948','949','950','951','952','953','954','955','956','957','958','959','960','961','962','963','964','965','967','968','969','970','971','972','973','974','975','976','977','978','979','980','981','982','983','984','985','986','987','988','989','990','991','992') AND (tb_lang . name like '%Elaster%' OR tb_lang . body_m like '%Elaster%' OR tb_lang . body like '%Elaster%' OR tb . code like '%Elaster%') AND tb.active = '1' AND pr.price_type_id = '100' 16.94ms192B10000000009a29c42000000005316d5bfdefaultSHOW TABLES LIKE 'ua_product'2.43ms96B10000000009a29c42000000005316d5bfdefaultSELECT tb.*,
tb_lang.*,
tb5.name as status,
pr.id as price_id,
pr.price,
pr.code,
pr.basePrice,
pr.discount,
pr.stock,
pr.discount_end,
pc.catalog_id as catalog_id,
fv.user_id AS favorite,
c.rate as currency_rate,
pr.price * c.rate as price_sort FROM `product` `tb` LEFT JOIN `ua_product` tb_lang ON tb.id=tb_lang.product_id
LEFT JOIN price pr ON tb.id = pr.product_id
LEFT JOIN currency c ON pr.currency_id = c.id
LEFT JOIN product_catalog pc ON pc.product_id = tb.id
LEFT JOIN favorites fv ON fv.product_id = tb.id AND fv.user_id = 0
LEFT JOIN params_product pp ON pp.product_id = tb.id
LEFT JOIN product_status_set tb4 ON tb4.product_id=tb.id
LEFT JOIN product_status tb6 ON tb.id=tb4.status_id
LEFT JOIN ua_product_status tb5 ON tb4.status_id=tb5.product_status_id
WHERE tb.id IN('4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','40','41','42','43','44','47','48','49','50','51','52','53','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99','100','101','102','103','104','105','106','107','108','109','110','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','156','157','158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','175','176','177','178','179','180','181','182','183','184','185','186','187','188','189','190','191','195','196','197','198','199','200','201','202','203','204','205','206','207','208','209','210','211','212','213','214','215','216','217','218','219','220','221','222','223','224','225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','255','256','257','258','259','260','261','262','263','264','265','266','267','268','269','270','271','272','273','274','275','276','277','278','279','280','281','282','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','353','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412','413','414','415','416','417','418','419','420','421','422','423','424','425','426','427','428','429','430','431','432','433','434','435','436','438','439','440','441','442','443','444','445','446','447','448','449','450','451','452','453','454','455','456','457','458','459','460','461','462','463','464','465','466','467','468','469','470','471','472','473','474','475','476','477','478','479','480','481','482','483','484','485','486','487','488','489','490','491','493','494','495','496','497','498','499','500','501','502','503','504','505','506','507','508','509','510','511','512','513','514','515','516','518','519','520','521','522','523','524','525','526','527','528','529','530','531','532','533','534','535','536','537','538','540','541','542','543','544','545','546','547','548','549','550','551','552','553','554','556','557','558','559','560','561','562','563','564','565','566','567','568','569','570','571','572','573','574','575','576','577','578','579','580','581','582','583','584','585','586','587','588','589','590','591','592','593','594','595','596','597','598','599','600','601','602','603','604','605','606','607','608','609','610','611','612','613','614','615','616','617','618','619','620','621','622','623','624','625','626','627','628','629','630','631','632','633','634','635','636','637','638','639','640','641','642','643','644','645','646','647','648','649','650','651','652','653','654','655','656','657','658','659','660','661','662','663','664','665','666','667','668','669','670','671','672','673','674','675','676','677','678','679','680','681','682','683','684','685','686','687','688','689','690','691','692','693','694','695','697','698','699','700','701','703','704','705','706','707','709','710','711','712','713','714','715','716','717','718','720','721','722','723','725','726','727','728','730','731','732','733','735','736','737','738','739','740','741','743','744','745','746','747','748','749','750','751','752','753','754','755','756','757','758','759','760','761','762','763','764','765','766','767','768','769','770','771','772','773','774','775','776','777','778','779','780','781','782','783','784','785','786','787','788','789','790','791','792','793','794','796','797','798','799','800','801','802','803','804','805','806','807','808','809','810','811','812','813','814','815','816','818','819','820','821','822','823','824','825','826','827','829','830','831','835','837','838','839','840','841','842','843','844','845','846','847','848','849','850','851','852','853','854','855','856','857','858','859','860','861','862','863','864','865','866','867','868','869','870','871','872','873','874','875','876','877','878','879','880','881','882','883','884','885','886','887','889','890','891','892','893','894','895','896','897','898','899','900','901','902','903','904','905','906','907','908','909','910','911','912','914','915','916','917','919','920','921','922','924','925','926','927','928','929','930','931','932','933','934','935','936','937','938','939','940','941','942','943','944','945','946','947','948','949','950','951','952','953','954','955','956','957','958','959','960','961','962','963','964','965','967','968','969','970','971','972','973','974','975','976','977','978','979','980','981','982','983','984','985','986','987','988','989','990','991','992') AND (tb_lang . name like '%Elaster%' OR tb_lang . body_m like '%Elaster%' OR tb_lang . body like '%Elaster%' OR tb . code like '%Elaster%') AND tb.active = '1' AND pr.price_type_id = '100' GROUP BY tb.id HAVING 1=1 ORDER BY tb.sort DESC, tb.id DESC 49.61ms3.52KB40000000009a29c10000000005316d5bfdefaultSELECT tb.*,
tb_lang.*,
tb5.name as status,
pr.id as price_id,
pr.price,
pr.code,
pr.basePrice,
pr.discount,
pr.stock,
pr.discount_end,
pc.catalog_id as catalog_id,
fv.user_id AS favorite,
c.rate as currency_rate,
pr.price * c.rate as price_sort FROM `product` `tb` LEFT JOIN `ua_product` tb_lang ON tb.id=tb_lang.product_id
LEFT JOIN price pr ON tb.id = pr.product_id
LEFT JOIN currency c ON pr.currency_id = c.id
LEFT JOIN product_catalog pc ON pc.product_id = tb.id
LEFT JOIN favorites fv ON fv.product_id = tb.id AND fv.user_id = 0
LEFT JOIN params_product pp ON pp.product_id = tb.id
LEFT JOIN product_status_set tb4 ON tb4.product_id=tb.id
LEFT JOIN product_status tb6 ON tb.id=tb4.status_id
LEFT JOIN ua_product_status tb5 ON tb4.status_id=tb5.product_status_id
WHERE tb.id IN('4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','40','41','42','43','44','47','48','49','50','51','52','53','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99','100','101','102','103','104','105','106','107','108','109','110','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','156','157','158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','175','176','177','178','179','180','181','182','183','184','185','186','187','188','189','190','191','195','196','197','198','199','200','201','202','203','204','205','206','207','208','209','210','211','212','213','214','215','216','217','218','219','220','221','222','223','224','225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','255','256','257','258','259','260','261','262','263','264','265','266','267','268','269','270','271','272','273','274','275','276','277','278','279','280','281','282','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','353','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412','413','414','415','416','417','418','419','420','421','422','423','424','425','426','427','428','429','430','431','432','433','434','435','436','438','439','440','441','442','443','444','445','446','447','448','449','450','451','452','453','454','455','456','457','458','459','460','461','462','463','464','465','466','467','468','469','470','471','472','473','474','475','476','477','478','479','480','481','482','483','484','485','486','487','488','489','490','491','493','494','495','496','497','498','499','500','501','502','503','504','505','506','507','508','509','510','511','512','513','514','515','516','518','519','520','521','522','523','524','525','526','527','528','529','530','531','532','533','534','535','536','537','538','540','541','542','543','544','545','546','547','548','549','550','551','552','553','554','556','557','558','559','560','561','562','563','564','565','566','567','568','569','570','571','572','573','574','575','576','577','578','579','580','581','582','583','584','585','586','587','588','589','590','591','592','593','594','595','596','597','598','599','600','601','602','603','604','605','606','607','608','609','610','611','612','613','614','615','616','617','618','619','620','621','622','623','624','625','626','627','628','629','630','631','632','633','634','635','636','637','638','639','640','641','642','643','644','645','646','647','648','649','650','651','652','653','654','655','656','657','658','659','660','661','662','663','664','665','666','667','668','669','670','671','672','673','674','675','676','677','678','679','680','681','682','683','684','685','686','687','688','689','690','691','692','693','694','695','697','698','699','700','701','703','704','705','706','707','709','710','711','712','713','714','715','716','717','718','720','721','722','723','725','726','727','728','730','731','732','733','735','736','737','738','739','740','741','743','744','745','746','747','748','749','750','751','752','753','754','755','756','757','758','759','760','761','762','763','764','765','766','767','768','769','770','771','772','773','774','775','776','777','778','779','780','781','782','783','784','785','786','787','788','789','790','791','792','793','794','796','797','798','799','800','801','802','803','804','805','806','807','808','809','810','811','812','813','814','815','816','818','819','820','821','822','823','824','825','826','827','829','830','831','835','837','838','839','840','841','842','843','844','845','846','847','848','849','850','851','852','853','854','855','856','857','858','859','860','861','862','863','864','865','866','867','868','869','870','871','872','873','874','875','876','877','878','879','880','881','882','883','884','885','886','887','889','890','891','892','893','894','895','896','897','898','899','900','901','902','903','904','905','906','907','908','909','910','911','912','914','915','916','917','919','920','921','922','924','925','926','927','928','929','930','931','932','933','934','935','936','937','938','939','940','941','942','943','944','945','946','947','948','949','950','951','952','953','954','955','956','957','958','959','960','961','962','963','964','965','967','968','969','970','971','972','973','974','975','976','977','978','979','980','981','982','983','984','985','986','987','988','989','990','991','992') AND (tb_lang . name like '%Elaster%' OR tb_lang . body_m like '%Elaster%' OR tb_lang . body like '%Elaster%' OR tb . code like '%Elaster%') AND tb.active = '1' AND pr.price_type_id = '100' GROUP BY tb.id HAVING 1=1 ORDER BY tb.sort DESC, tb.id DESC 49.63ms8.52KB0defaultSHOW TABLES LIKE 'ua_product'3.29ms96B10000000009a29c10000000005316d5bfdefaultSELECT tb.*,
tb_lang.*,
tb5.name as status,
pr.id as price_id,
pr.price,
pr.code,
pr.basePrice,
pr.discount,
pr.stock,
pr.discount_end,
pc.catalog_id as catalog_id,
fv.user_id AS favorite,
c.rate as currency_rate,
pr.price * c.rate as price_sort FROM `product` `tb` LEFT JOIN `ua_product` tb_lang ON tb.id=tb_lang.product_id
LEFT JOIN price pr ON tb.id = pr.product_id
LEFT JOIN currency c ON pr.currency_id = c.id
LEFT JOIN product_catalog pc ON pc.product_id = tb.id
LEFT JOIN favorites fv ON fv.product_id = tb.id AND fv.user_id = 0
LEFT JOIN params_product pp ON pp.product_id = tb.id
LEFT JOIN product_status_set tb4 ON tb4.product_id=tb.id
LEFT JOIN product_status tb6 ON tb.id=tb4.status_id
LEFT JOIN ua_product_status tb5 ON tb4.status_id=tb5.product_status_id
WHERE tb.id IN('4','5','6','7','8','9','10','11','12','13','14','15','16','17','18','19','40','41','42','43','44','47','48','49','50','51','52','53','60','61','62','63','64','65','66','67','68','69','70','71','72','73','74','75','76','77','78','79','80','81','82','83','84','85','86','87','88','89','90','91','92','93','94','95','96','97','98','99','100','101','102','103','104','105','106','107','108','109','110','111','112','113','114','115','116','117','118','119','120','121','122','123','124','125','126','127','128','129','130','131','132','133','134','135','136','137','138','139','140','141','142','143','144','145','146','147','148','149','150','151','152','153','154','155','156','157','158','159','160','161','162','163','164','165','166','167','168','169','170','171','172','173','174','175','176','177','178','179','180','181','182','183','184','185','186','187','188','189','190','191','195','196','197','198','199','200','201','202','203','204','205','206','207','208','209','210','211','212','213','214','215','216','217','218','219','220','221','222','223','224','225','226','227','228','229','230','231','232','233','234','235','236','237','238','239','240','241','242','243','244','245','246','247','248','249','250','251','252','253','255','256','257','258','259','260','261','262','263','264','265','266','267','268','269','270','271','272','273','274','275','276','277','278','279','280','281','282','283','284','285','286','287','288','289','290','291','292','293','294','295','296','297','298','299','300','301','302','303','304','305','306','307','308','309','310','311','312','313','314','315','316','317','318','319','320','321','322','323','324','325','326','327','328','329','330','331','332','333','334','335','336','337','338','339','340','341','342','343','344','345','346','347','348','349','350','351','352','353','354','355','356','357','358','359','360','361','362','363','364','365','366','367','368','369','370','371','372','373','374','375','376','377','378','379','380','381','382','383','384','385','386','387','388','389','390','391','392','393','394','395','396','397','398','399','400','401','402','403','404','405','406','407','408','409','410','411','412','413','414','415','416','417','418','419','420','421','422','423','424','425','426','427','428','429','430','431','432','433','434','435','436','438','439','440','441','442','443','444','445','446','447','448','449','450','451','452','453','454','455','456','457','458','459','460','461','462','463','464','465','466','467','468','469','470','471','472','473','474','475','476','477','478','479','480','481','482','483','484','485','486','487','488','489','490','491','493','494','495','496','497','498','499','500','501','502','503','504','505','506','507','508','509','510','511','512','513','514','515','516','518','519','520','521','522','523','524','525','526','527','528','529','530','531','532','533','534','535','536','537','538','540','541','542','543','544','545','546','547','548','549','550','551','552','553','554','556','557','558','559','560','561','562','563','564','565','566','567','568','569','570','571','572','573','574','575','576','577','578','579','580','581','582','583','584','585','586','587','588','589','590','591','592','593','594','595','596','597','598','599','600','601','602','603','604','605','606','607','608','609','610','611','612','613','614','615','616','617','618','619','620','621','622','623','624','625','626','627','628','629','630','631','632','633','634','635','636','637','638','639','640','641','642','643','644','645','646','647','648','649','650','651','652','653','654','655','656','657','658','659','660','661','662','663','664','665','666','667','668','669','670','671','672','673','674','675','676','677','678','679','680','681','682','683','684','685','686','687','688','689','690','691','692','693','694','695','697','698','699','700','701','703','704','705','706','707','709','710','711','712','713','714','715','716','717','718','720','721','722','723','725','726','727','728','730','731','732','733','735','736','737','738','739','740','741','743','744','745','746','747','748','749','750','751','752','753','754','755','756','757','758','759','760','761','762','763','764','765','766','767','768','769','770','771','772','773','774','775','776','777','778','779','780','781','782','783','784','785','786','787','788','789','790','791','792','793','794','796','797','798','799','800','801','802','803','804','805','806','807','808','809','810','811','812','813','814','815','816','818','819','820','821','822','823','824','825','826','827','829','830','831','835','837','838','839','840','841','842','843','844','845','846','847','848','849','850','851','852','853','854','855','856','857','858','859','860','861','862','863','864','865','866','867','868','869','870','871','872','873','874','875','876','877','878','879','880','881','882','883','884','885','886','887','889','890','891','892','893','894','895','896','897','898','899','900','901','902','903','904','905','906','907','908','909','910','911','912','914','915','916','917','919','920','921','922','924','925','926','927','928','929','930','931','932','933','934','935','936','937','938','939','940','941','942','943','944','945','946','947','948','949','950','951','952','953','954','955','956','957','958','959','960','961','962','963','964','965','967','968','969','970','971','972','973','974','975','976','977','978','979','980','981','982','983','984','985','986','987','988','989','990','991','992') AND (tb_lang . name like '%Elaster%' OR tb_lang . body_m like '%Elaster%' OR tb_lang . body like '%Elaster%' OR tb . code like '%Elaster%') AND tb.active = '1' AND pr.price_type_id = '100' GROUP BY tb.id HAVING 1=1 ORDER BY tb.sort DESC, tb.id DESC LIMIT 0,3035.45ms3.52KB40000000009a29c10000000005316d5bfdefaultSHOW TABLES LIKE 'ua_params'3.44ms96B10000000009a29c10000000005316d5bfdefaultSELECT GROUP_CONCAT(tb3.price_id) as concat_prices,tb_lang.name, tb.id as id, tb2_lang.name as parent_name, tb3.product_id, tb3.price_id as price_id, tb3.params_sub as sub FROM `params` `tb` LEFT JOIN `ua_params` tb_lang ON tb.id=tb_lang.params_id
LEFT JOIN params_price tb3 ON tb3.params_id = tb.id
LEFT JOIN ua_params tb2_lang ON tb3.params_sub = tb2_lang.params_id
WHERE tb.id IN ( SELECT params_id FROM params_price ) AND tb3.product_id IN('902','901','900','899') GROUP BY tb.id, tb3.product_id 2.79ms480B00000000009a29c10000000005316d5bfdefaultSELECT * FROM currency ORDER BY id ASC17.45ms648B20000000009a29c10000000005316d5bfdefault