Лакофарбові матеріали - страница 9 - сторінка 9

Messages Request Timeline Exceptions Database44

7.4.333.6s3MB

$_GET: []
$_POST: []
$_SESSION: array:17 [ "key_lang" => "ua" "key_lang_name" => "ua" "key_lang_admin" => "ua" "currency" =>...
$_COOKIE: []

44 statements were executed, 15 of which were duplicates, 29 unique. Show only duplicated4.62s38.17KB

SELECT name,value FROM config13.09ms128B930000000040e6e51d0000000078366ff4default
SELECT tb.key,tb2.value FROM translate tb LEFT JOIN ua_translate tb2 ON tb.id=tb2.translate_id32.7ms128B4170000000040e6e51d0000000078366ff4default
SELECT `to`, `type` FROM `redirects` WHERE `from`=? AND `from`!='' AND `to`!='' AND active='1'42.09ms1.04KB00000000040e6e52a0000000078366ff4default
Params
0: eskaroshop.com.ua/catalog/lakofarbovi-materiali/page/9
SELECT * FROM `currency` ORDER BY `id` ASC15.54ms648B20000000040e6e52a0000000078366ff4default
SELECT id FROM modules WHERE `controller`=? AND `hidden`=?25.35ms1000B10000000040e6e52c0000000078366ff4default
Params
0: product
1:
SELECT * FROM `currency` WHERE `base`='1' 28.97ms648B10000000040e6e52c0000000078366ff4default
SELECT id FROM `price_type` WHERE `default`='1'15.28ms64B10000000040e6e5260000000078366ff4default
SELECT MIN(price) AS price FROM `price`17.68ms840B10000000040e6e52c0000000078366ff4default
Params
0: 1
SELECT MAX(price) AS price FROM `price`31.94ms840B10000000040e6e52c0000000078366ff4default
Params
0: 1
SHOW TABLES LIKE 'ua_catalog'38.36ms96B10000000040e6e5100000000078366ff4default
SELECT * FROM `catalog` `tb` LEFT JOIN `ua_catalog` tb_lang ON tb.id=tb_lang.catalog_id WHERE tb.active=? AND tb.url=? 25.07ms2.52KB10000000040e6e5100000000078366ff4default
Params
0: 1
1: lakofarbovi-materiali
SELECT COLUMN_NAME as name FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = ? AND TABLE_NAME = ? 32.05ms1.02KB150000000040e6e5100000000078366ff4default
Params
0: wgzfgqwt_main
1: catalog
SHOW TABLES LIKE 'ua_catalog'22.72ms96B10000000040e6e5100000000078366ff4default
SELECT * 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 28.47ms1.52KB210000000040e6e5100000000078366ff4default
SELECT `id`, `url` FROM `product_status`32.16ms128B20000000040e6e5100000000078366ff4default
SHOW TABLES LIKE 'ua_catalog'39.34ms96B10000000040e6e5100000000078366ff4default
SELECT * 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 15.21ms1.52KB120000000040e6e5100000000078366ff4default
SELECT GROUP_CONCAT(tb.id) FROM `catalog` tb WHERE tb.active = '1'32.6ms80B10000000040e6e5100000000078366ff4default
SELECT GROUP_CONCAT(tb.id) FROM `product` tb WHERE tb.active = '1'40.12ms80B10000000040e6e5100000000078366ff4default
SELECT id FROM modules WHERE `controller`=? AND `hidden`=?27.33ms1000B10000000040e6e5100000000078366ff4default
Params
0: params
1:
SELECT GROUP_CONCAT(DISTINCT id ) FROM catalog WHERE sub='1'33.68ms88B10000000040e6e5100000000078366ff4default
SELECT GROUP_CONCAT(DISTINCT product_id) FROM product_catalog WHERE catalog_id IN(1,9,10,11,12,13,14) 67.51ms96B10000000040e6e5100000000078366ff4default
SELECT GROUP_CONCAT(DISTINCT id ) FROM catalog WHERE sub='1'17.44ms88B10000000040e6e5100000000078366ff4default
SELECT * FROM catalog LEFT JOIN ua_catalog ON ua_catalog.catalog_id = catalog.id WHERE catalog_id=?14.54ms2.41KB10000000040e6e5340000000078366ff4default
Params
0: 1
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,9,10,11,12,13,14) AND params.sub IS NULL45.44ms64B430000000040e6e5340000000078366ff4default
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,8,8,8,8,8,8,8,12,12,12,12,12,12,15,15,15,15,15,15,15,19,19,19,19,19,19,19,28,28,28,28,28,28,28,44,508) AND pc.catalog_id IN (1,9,10,11,12,13,14) GROUP BY params.id89.27ms64B1930000000040e6e5340000000078366ff4default
SHOW TABLES LIKE 'ua_params'35.21ms96B10000000040e6e5340000000078366ff4default
SELECT 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','5','6','7','9','10','11','13','14','16','17','18','20','21','24','25','26','27','29','30','32','33','34','35','38','40','43','45','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','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','229','230','233','234','235','236','239','241','242','245','432','486','487','488','494','503','534','538','548','637','639','652','654','672','674','677','684','685','686','689','690','691','692','693','696','697','718','719','720','721','722') 84.96ms1.19KB1930000000040e6e5340000000078366ff4default
SHOW TABLES LIKE 'ua_params'31.04ms96B10000000040e6e5340000000078366ff4default
SELECT 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','5','6','7','9','10','11','13','14','16','17','18','20','21','24','25','26','27','29','30','32','33','34','35','38','40','43','45','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','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','229','230','233','234','235','236','239','241','242','245','432','486','487','488','494','503','534','538','548','637','639','652','654','672','674','677','684','685','686','689','690','691','692','693','696','697','718','719','720','721','722') GROUP BY tb.id ORDER BY tb.sort ASC 27.29ms1.02KB80000000040e6e5340000000078366ff4default
SHOW TABLES LIKE 'ua_params'23.78ms96B10000000040e6e5340000000078366ff4default
SELECT 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) 14.91ms1.19KB00000000040e6e5340000000078366ff4default
SHOW TABLES LIKE 'ua_params'14.42ms96B10000000040e6e5340000000078366ff4default
SELECT 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 26.12ms1.02KB00000000040e6e5340000000078366ff4default
SHOW TABLES LIKE 'ua_product'53.17ms96B10000000040e6e5340000000078366ff4default
SELECT 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('1','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','47','48','49','50','51','52','53','54','55','56','57','58','59','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','437','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','486','487','488','489','490','491','492','493','494','495','496','497','498','499','500','501','502','503','504','505','506','509','510','511','512','513','514','515','516','517','518','519','520','521','522','523','524','525','526','527','528','529','530','531','532','569','570','571','572','573','574','575','579','580','581','582','583','584','585','586','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','696','697','698','699','700','701','702','703','704','705','706','707','708','709','710','711','712','713','714','715','716','717','718','719','720','721','722','723','724','725','726','727','728','729','730','731','732','733','734','735','736','737','738','739','740','741','742','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','795','796','797','798','799','800','801','802','803','804','805','806','807','808','809','810','811','812','813','814','815','816','817','818','819','820','821','822','828','829','830','831','832','833','834','835','836','837','838','839','840','841','842','843','844','845','846','847','848','849','850','851','852','853','854','855','856','857','858','859','864','865','866','867','868','869','870','871','872','873','874','875','876','877','878','879','880','881','882','883','884','885','895','896','897','898','899','900','901','902','903','904') AND 1=1 AND tb.active = '1' AND pr.price_type_id = '100'30.47ms192B10000000040e6e5340000000078366ff4default
SHOW TABLES LIKE 'ua_product'26.74ms96B10000000040e6e5340000000078366ff4default
SELECT 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('1','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','47','48','49','50','51','52','53','54','55','56','57','58','59','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','437','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','486','487','488','489','490','491','492','493','494','495','496','497','498','499','500','501','502','503','504','505','506','509','510','511','512','513','514','515','516','517','518','519','520','521','522','523','524','525','526','527','528','529','530','531','532','569','570','571','572','573','574','575','579','580','581','582','583','584','585','586','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','696','697','698','699','700','701','702','703','704','705','706','707','708','709','710','711','712','713','714','715','716','717','718','719','720','721','722','723','724','725','726','727','728','729','730','731','732','733','734','735','736','737','738','739','740','741','742','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','795','796','797','798','799','800','801','802','803','804','805','806','807','808','809','810','811','812','813','814','815','816','817','818','819','820','821','822','828','829','830','831','832','833','834','835','836','837','838','839','840','841','842','843','844','845','846','847','848','849','850','851','852','853','854','855','856','857','858','859','864','865','866','867','868','869','870','871','872','873','874','875','876','877','878','879','880','881','882','883','884','885','895','896','897','898','899','900','901','902','903','904') AND 1=1 AND tb.active = '1' AND pr.price_type_id = '100' GROUP BY tb.id HAVING 1=1 ORDER BY tb.sort DESC, tb.id DESC1.52s3.52KB5230000000040e6e5450000000078366ff4default
SELECT 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('1','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','47','48','49','50','51','52','53','54','55','56','57','58','59','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','437','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','486','487','488','489','490','491','492','493','494','495','496','497','498','499','500','501','502','503','504','505','506','509','510','511','512','513','514','515','516','517','518','519','520','521','522','523','524','525','526','527','528','529','530','531','532','569','570','571','572','573','574','575','579','580','581','582','583','584','585','586','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','696','697','698','699','700','701','702','703','704','705','706','707','708','709','710','711','712','713','714','715','716','717','718','719','720','721','722','723','724','725','726','727','728','729','730','731','732','733','734','735','736','737','738','739','740','741','742','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','795','796','797','798','799','800','801','802','803','804','805','806','807','808','809','810','811','812','813','814','815','816','817','818','819','820','821','822','828','829','830','831','832','833','834','835','836','837','838','839','840','841','842','843','844','845','846','847','848','849','850','851','852','853','854','855','856','857','858','859','864','865','866','867','868','869','870','871','872','873','874','875','876','877','878','879','880','881','882','883','884','885','895','896','897','898','899','900','901','902','903','904') AND 1=1 AND tb.active = '1' AND pr.price_type_id = '100' GROUP BY tb.id HAVING 1=1 ORDER BY tb.sort DESC, tb.id DESC1.52s8.52KB0default
SHOW TABLES LIKE 'ua_product'23.99ms96B10000000040e6e5630000000078366ff4default
SELECT 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('1','20','21','22','23','24','25','26','27','28','29','30','31','32','33','34','35','36','37','38','39','47','48','49','50','51','52','53','54','55','56','57','58','59','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','437','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','486','487','488','489','490','491','492','493','494','495','496','497','498','499','500','501','502','503','504','505','506','509','510','511','512','513','514','515','516','517','518','519','520','521','522','523','524','525','526','527','528','529','530','531','532','569','570','571','572','573','574','575','579','580','581','582','583','584','585','586','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','696','697','698','699','700','701','702','703','704','705','706','707','708','709','710','711','712','713','714','715','716','717','718','719','720','721','722','723','724','725','726','727','728','729','730','731','732','733','734','735','736','737','738','739','740','741','742','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','795','796','797','798','799','800','801','802','803','804','805','806','807','808','809','810','811','812','813','814','815','816','817','818','819','820','821','822','828','829','830','831','832','833','834','835','836','837','838','839','840','841','842','843','844','845','846','847','848','849','850','851','852','853','854','855','856','857','858','859','864','865','866','867','868','869','870','871','872','873','874','875','876','877','878','879','880','881','882','883','884','885','895','896','897','898','899','900','901','902','903','904') AND 1=1 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 240,30297ms3.52KB300000000040e6e5630000000078366ff4default
SHOW TABLES LIKE 'ua_params'22.77ms96B10000000040e6e5450000000078366ff4default
SELECT 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('716','715','714','713','712','711','710','709','705','704','703','701','699','698','667','666','663','662','661','660','659','658','657','656','655','654','653','652','651','650') GROUP BY tb.id, tb3.product_id22.73ms480B00000000040e6e5450000000078366ff4default
SELECT * FROM currency ORDER BY id ASC28.41ms648B20000000040e6e5450000000078366ff4default

↑