>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_navigation` [ RunTime:0.000524s ]
>🍏🍏🍏>SELECT `id`,`pid`,`name`,`url`,`value`,`data_type`,`nav_type`,`is_new_window_open` FROM `sx_navigation` WHERE `is_show` = 1 ORDER BY `sort` ASC,`id` ASC [ RunTime:0.003254s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_plugins` [ RunTime:0.000358s ]
>🍏🍏🍏>SELECT * FROM `sx_plugins` [ RunTime:0.001989s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_goods_category` [ RunTime:0.003273s ]
>🍏🍏🍏>SELECT `id`,`pid`,`icon`,`icon_active`,`realistic_images`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc`,`a_is_show` FROM `sx_goods_category` WHERE `pid` = 0 AND `is_enable` = 1 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000117s ]
>🍏🍏🍏>SELECT `id`,`pid`,`icon`,`icon_active`,`realistic_images`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc`,`a_is_show` FROM `sx_goods_category` WHERE `is_enable` = 1 AND `pid` IN (1,2,3,4,5,1000) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000118s ]
>🍏🍏🍏>SELECT `id`,`pid`,`icon`,`icon_active`,`realistic_images`,`name`,`vice_name`,`describe`,`bg_color`,`big_images`,`sort`,`is_home_recommended`,`seo_title`,`seo_keywords`,`seo_desc`,`a_is_show` FROM `sx_goods_category` WHERE `is_enable` = 1 AND `pid` IN (6,7,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,999) AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.002524s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_plugins_themestyle_config` [ RunTime:0.000509s ]
>🍏🍏🍏>SELECT * FROM `sx_plugins_themestyle_config` WHERE `is_enable` = 1 AND `is_default` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000098s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_theme_data` [ RunTime:0.002916s ]
>🍏🍏🍏>SELECT `id`,`unique`,`name`,`theme`,`type`,`data` FROM `sx_theme_data` WHERE `is_enable` = 1 AND `view` IN (-1,1) AND `theme` = 'default' [ RunTime:0.000097s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_plugins_topada_slider` [ RunTime:0.000469s ]
>🍏🍏🍏>SELECT `name`,`images_url`,`event_value`,`bg_color` FROM `sx_plugins_topada_slider` WHERE `is_enable` = 1 AND ( (is_home = 0 OR (is_home = 1 AND 'search' = 'index' AND 'index' = 'index')) ) AND ( (time_start = '' OR time_start <= '2025-12-01 10:55:37') AND (time_end = '' OR time_end >= '2025-12-01 10:55:37') ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000103s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_goods_spec_base` [ RunTime:0.000368s ]
>🍏🍏🍏>SELECT `goods_id` FROM `sx_goods_spec_base` WHERE ( `barcode` = '甲醇' OR `coding` = '甲醇' ) [ RunTime:0.002745s ]
>🍏🍏🍏>SELECT `id` FROM `sx_goods_category` WHERE `pid` = 1000 AND `is_enable` = 1 [ RunTime:0.000280s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_screening_price` [ RunTime:0.000402s ]
>🍏🍏🍏>SELECT `min_price`,`max_price` FROM `sx_screening_price` WHERE `is_enable` = 1 AND `id` = 18 LIMIT 1 [ RunTime:0.000085s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_goods_spec_value` [ RunTime:0.003088s ]
>🍎🍎🍎>SELECT `goods_id` FROM `sx_goods_spec_value` WHERE `value` = '5ml' [ RunTime:0.291649s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_goods` [ RunTime:0.005475s ]
>🍎🍎🍎>SELECT COUNT(DISTINCT `g`.`id`) AS think_count FROM `sx_goods` `g` INNER JOIN `sx_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` WHERE `g`.`is_delete_time` = '0' AND `g`.`is_shelves` = '1' AND `gci`.`category_id` = '1000' AND `g`.`id` IN ('232406','199','231975','231981','231989','232005','232016','232034','232094','232314','232331','1071','1137','1311','1359','1052','1502','1514','1786','2010','2118','2211','2814','2821','2825','2843','2844','2856','2909','3073','3554','3562','3563','3612','3726','3803','3831','3909','4040','4043','4088','4374','4383','4434','4544','4566','4618','4662','4710','4713','4729','4730','4737','4753','4756','4763','4787','4832','4846','4913','4917','4955','5061','5174','5256','5280','5304','5317','5318','5507','5536','5533','5647','5703','5868','6876','7078','7552','7566','7759','7784','7814','7876','8393','8414','8477','8484','8502','8510','8519','8549','8558','8606','8670','8679','8683','8765','8864','8867','8876','8530','8974','9106','9366','9368','9016','9392','9416','9502','9546','9710','10143','10427','10678','10689','10432','11083','11141','11162','11165','11170','11174','11242','11270','11348','11353','11472','11479','232690','11687','11690','11691','11710','11728','11981','12036','12040','12044','12159','11908','12185','12186','12189','12193','12208','12228','12256','12278','12315','12316','12434','12471','12530','12549','12556','12559','12661','12733','12759','12766','12836','13010','13067','13072','13086','13094','13095','13129','12742','12816','12722','13400','13774','13921','14198','14210','14259','14289','14300','14348','14351','14355','14374','14494','14535','14560','14569','14570','14572','14576','14581','14582','14602','14623','14633','14638','14683','14687','14724','14784','14798','14873','14912','14918','14922','14938','14947','15018','15031','15045','15070','15073','15084','15109','15113','15144','15229','15246','15253','15295','14971','15613','15920','16205','16241','16294','16448','16596','17429','17635','17667','17669','17768','17806','17810','17813','17819','17829','17882','17968','17977','18012','18087','18091','18095','18100','18114','18132','18164','18198','18338','18529','18537','18585','18821','18923','18952','19060','19070','19078','19101','19100','19206','19246','19296','19391','19410','19420','19432','19444','19480','19499','19500','19552','19557','19578','19197','19898','19964','20154','20562','20567','20649','20968','20983','21034','21141','21171','21175','21182','21193','21203','21223','21227','21230','21329','21335','21439','21471','21479','21614','21651','21669','21682','21716','21853','21891','21893','21898','21902','21913','21918','21962','21589','22010','22011','22039','22072','22116','22168','22174','22185','232952','232954','22044','22145','22431','22577','22503','22558','22824','22825','22826','22827','22828','22829','22830','22831','22832','22833','22834','22835','22836','232965','22837','22838','22839','22840','22842','22852','22853','22854','22855','22856','22857','22858','22859','22860','22791','22792','22793','22794','22795','22796','22797','22798','22799','22800','22801','22802','22803','22804','22805','22806','22807','22808','22809','22810','22811','22812','22813','22814','22815','22816','22817','22818','22819','22820','22821','22989','22990','22992','22993','22994','22995','22996','22997','22998','22999','232971','23000','23001','23002','23026','22945','23044','23164','23411','23427','23494','23545','23560','232993','23781','23788','232998','23835','24009','24024','24027','24046','24049','24112','24209','24210','24298','24254','24279','233020','24316','24364','24376','24382','24407','24417','24426','24435','24511','24517','24530','24861','24885','24892','24895','24951','24958','24979','25064','25541','25542','25543','25544','25545','25546','25547','25548','25549','25550','25551','25552','25553','25554','25555','25556','25557','25558','25559','25560','25561','25562','25563','25564','25565','25566','25567','25568','25569','25570','25571','25572','25573','25574','25220','25304','25312','25380','25601','25607','25610','25790','25855','25864','25908','25909','25921','25929','26043','26047','26215','26628','26664','26742','26983','27353','27442','27809','28033','28101','28600','28674','28681','28721','28735','28752','28971','29003','29109','29144','29157','29170','29179','29180','29204','29226','29473','29582','29602','29674','29697','29724','29727','29790','29961','29975','30003','30007','30012','30083','30147','30157','30168','30204','30287','233143','30417','30456','30457','30467','30472','30529','30569','30594','30597','30635','30787','30789','30814','30822','233155','30824','30827','31257','30942','30856','31032','31479','31555','31568','31593','31611','31700','31748','31775','31781','31809','31902','31906','31934','31954','32680','233220','33068','33069','33070','33071','33072','33114','33115','33116','33117','33118','33119','33120','33121','33122','33123','33124','33125','33073','33074','33075','33076','33077','33078','33079','33130','33126','33127','33128','33129','33080','33088','33081','33082','33089','33085','33083','33090','33086','33084','33091','33087','33169','33132','33134','33138','33140','33142','33144','33146','33219','33147','33148','33149','33150','33151','33152','33153','33154','33155','33156','33157','33158','33930','33966','34024','34218','34219','34046','33931','34048','233246','34028','33962','34104','34114','34225','33898','34289','33933','34029','33908','33944','33900','34025','33937','33938','34241','34030','33902','33964','33965','33961','34026','33939','34185','33963','33897','34238','33896','34142','34758','34720','34945','34986','34898','35594','35556','35273','35732','35641','35794','35757','35925','35927','35926','35941','36175','35896','35819','36180','36265','36728','36716','36761','36850','37018','36871','36714','36931','36916','36870','37526','37528','37516','37525','37320','37563','37334','37802','37876','37769','38663','38661','38662','38664','38677','38660','38678','38679','38684','38519','38900','38694','38997','39999','40121','39821','39830','40386','40289','40895','41764','42066','42064','42044','42851','43252','43251','43221','43250','43213','43110','44472','44550','44479','44396','44401','44480','44402','44485','44405','44410','44420','44422','44424','44486','44661','44426','44365','44494','44438','44440','44444','44495','44499','44452','44503','44455','44459','233623','44466','44467','45102','44778','44835','44981','44932','44994','45069','44809','44936','44999','45040','45054','233664','51974','52053','52758','233814','53906','53767','48390','48523','48401','48421','48113','48103','54092','52208','48620','48720','48721','48719','48734','52430','55491','55313','55421','234662','55740','56260','55565','56642','56634','56439','234810','234865','54380','54383','63028','62891','54853','63095','63230','235108','63557','63339','60945','61007','61027','60969','60780','60963','65001','235679','65058','65014','65005','65000','64995','64976','64975','64973','64966','64965','64964','65060','235678','65040','65011','64977','65012','235684','65036','65045','65015','64978','235677','65041','64997','64968','65025','64996','64981','64980','64974','235675','65017','63938','63941','63842','63943','64049','64055','63877','64043','63725','63726','63728','63841','63714','63794','63796','64024','64151','63819','63947','63817','63893','64117','63912','65220','65131','65375','65244','65371','65295','65212','65203','65173','65075','65073','65069','65323','235733','65240','65125','65336','235736','65147','65129','65349','65348','235731','235732','65142','65090','65393','65300','235734','65233','65199','65107','65106','65363','65262','65188','65248','235712','65525','65484','65491','65488','65502','235747','235773','235770','235821','235820','65856','66065','66343','66262','66478','236029','236067','67438','67670','67806','67750','67865','68075','67913','236247','67967','68483','236276','68420','236334','64281','64156','64163','64386','237369','69761','69744','69762','237492','237520','69760','69791','71765','238386','238317','238547','238278','238904','238606','238685','239422','239426','239345','240248','240541','240535','240683','241058','241059','246376','246547','246552','246883','247725','255603','255652','255650','255648','255646','255645','255702','256393','256387','257955','258135','258440','258955','259009','258961','259639','259746','260018','259995','259982','259975','260268','260497','260529','260740','260829','260967','261274','261670','261664','261732','261865','261768','262233','262340','262686','262737','76117','76179','75997','76273','76397','76254','76264','76125','76191','76265','263081','76395','76557','76635','76896','76626','76604','76772','76528','76482','76621','76808','76520','76527','76971','77212','77200','77403','79268','79789','79857','79929','80548','81540','81465','81458','81494','81543','81461','81469','81508','81509','81484','81490','81527','81531','81438','81517','81487','81680','81547','81612','81551','81568','81569','81637','81662','81713','81716','81729','81619','81721','81773','81776','81576','81644','81647','81594','81567','81599','81668','81664','81746','81630','81732','82137','82152','82292','82545','82322','83601','83613','83333','83337','83928','83948','83740','83746','84009','83862','84863','85080','85047','85066','85037','85055','85057','85072','85074','85078','85093','85035','263704','85043','85045','85049','85051','85053','85064','85069','263705','85076','85085','263706','85062','85945','86038','263747','85782','85767','85789','85800','85759','85828','85829','85831','85832','85757','85761','85765','85780','85786','85787','85788','85790','85864','85865','85868','85882','85886','85895','85901','85910','85921','85763','85769','85771','85775','85792','85795','85942','85943','85949','85950','85952','85953','85979','85984','85988','85976','85783','85785','85983','85773','85779','85796','85797','85798','85799','85998','85999','86000','86004','86008','86012','86013','86026','86029','86030','86031','86035','86039','86042','86047','86048','86054','86067','86070','85777','85801','85804','85961','85962','85794','85959','86007','85755','86362','86314','86134','86239','86218','86131','86126','86589','86791','86661','86839','86894','86812','86880','87425','87598','87599','87483','87605','87400','87410','87417','87479','87523','87621','87623','87394','87437','87443','87481','87255','87521','263819','87493','87499','263821','87423','87547','87902','87739','87862','87914','87880','87904','263824','263827','87793','87795','87937','87686','87791','87771','87789','88005','87908','88009','87719','87741','87773','87906','87939','87648','88003','88027','87858','88143','88161','88384','88172','88282','88140','88386','88213','88280','88071','88145','88444','88147','88288','88306','88354','88344','88484','88582','88507','88482','88584','88470','88554','88537','88611','88580','88586','88613','88447','88532','88588','88621','90738','90943','90725','90786','90868','90929','90959','90825','90961','91001','90730','90757','90908','90723','90904','90763','90780','90788','90796','90813','90902','90906','90920','91021','90750','90878','90830','90914','90918','90939','90969','90856','90860','90926','90931','90957','90983','90999','91007','91074','91050','91058','91102','91032','91177','91360','91052','91054','91060','91113','91149','91505','92144','92326','92151','92180','92383','92386','92146','264021','92292','92176','92288','92289','92291','92341','92350','92354','92358','92364','92367','92469','92286','92353','92449','92199','92290','92310','92389','92462','92472','92287','92337','92634','92666','92677','92590','92648','92690','92697','92700','92701','92589','92587','92670','92588','92515','92591','92671','92744','92669','92592','92816','92897','93159','93161','93359','93363','93368','93154','93160','93322','93442','93153','93155','93156','93157','93162','93164','93320','93362','93158','93163','93321','93323','93693','93696','93712','93771','93511','93513','93516','93521','93533','264070','93561','93565','93553','93683','93510','93528','93534','93540','93691','93675','93694','93951','93918','93919','93920','93925','93979','93990','93837','93885','93897','93934','93863','93938','93956','93976','93977','93981','93982','93991','94035','94042','94043','93862','93864','94065','93916','93965','93902','93861','93986','93987','93988','93989','94385','94472','94405','94379','94979','94708','95116','94698','94712','95024','94866','96465','96601','96631','96330','97049','97037','97323','97510','97563','97497','97720','98138','98800','98874','98780','98693','98695','98697','98739','98742','98743','98748','264217','98750','98751','98752','98755','98756','98758','98757','98759','98870','99148','99483','99397','99394','99881','100158','99924','100040','100466','100777','100812','100846','100971','103267','103263','103264','103266','103643','104928','105001','104977','105044','104911','105235','105283','105298','105416','105279','105402','105085','105124','105263','105223','105424','105900','105961','105613','105781','105995','106306','106232','106164','106302','106339','106134','106127','106446','106410','106565','106959','106552','106915','106589','106647','106605','106494','106889','106731','106858','106849','106921','106834','106938','106714','106572','106557','106553','107074','107391','107290','107291','107075','107430','107123','107332','107376','107107','107322','107103','107362','107333','107062','107363','107359','107392','107377','107364','107292','107047','107334','107248','106977','107912','107657','107614','107721','107700','107468','107481','107722','107879','107615','107616','107781','107617','107723','107828','107913','107812','107509','107880','107989','108140','108081','108046','108251','108069','108387','108274','108418','108141','108191','108142','108419','108364','107995','108090','108143','108420','108192','108440','108351','107981','108318','108275','108104','108144','108319','108169','108012','108490','108460','108484','108461','109575','109612','109592','109594','109628','109557','109602','109636','109542','109639','109532','109595','109608','109644','109535','109588','109626','109551','109564','109558','109536','109600','109610','109613','109630','109565','109637','109627','109622','109633','109618','109552','109563','109566','109567','109573','109583','109609','109537','109619','109596','109590','109533','109577','109611','109553','109642','109543','109640','109641','109544','109629','109597','109584','109624','109576','109593','109549','109585','109538','109617','109568','109541','109529','109606','109580','109645','109586','109574','109615','109530','109616','109625','109559','109560','109554','109601','109578','109555','109599','109623','109531','109561','109632','109634','109635','109545','109579','109546','109556','109569','109550','109581','109570','109605','109562','109539','109587','109631','109638','109582','109534','109589','109643','109540','109604','109571','109547','109598','109548','109620','109591','109572','109603','109607','109614','109621','110727','264712','110701','110640','110926','111046','111282','111038','111071','110939','111421','111558','111368','111334','111692','112092','112222','120325','120329','120238','120388','120196','120212','120334','120344','120195','120270','120411','120403','120239','120300','120311','120173','120240','120241','120281','120215','120363','120330','122102','121984','121840','122348','122427','265512','122417','122422','122413','122701','122883','122681','122896','123032','123034','122984','123680','123595','124340','124533','124830','125917','125672','125666','125847','125864','125875','126499','127658','128137','128282','128264','128339','128657','128468','128593','129024','129277','129558','129265','129506','129735','129714','130378','130191','131091','131115','139547','139564','139829','139589','139570','139780','267963','140283','267970','140372','140500','140502','140482','141270','141608','142676','142612','142671','142626','144872','144887','144896','144899','144902','147802','147762','148013','148016','148546','148321','148316','148334','148683','148711','148947','148825','148823','148793','148982','149095','149767','150177','149843','149868','149865','150523','150570','150334','150773','268519','151825','151816','152122','268526','152502','152336','152518','152317','153675','153398','153748','154041','268711','154497','154699','154855','155010','155417','155660','155931','155853','156566','156775','156825','268838','157394','157145','268853','157434','157504','157737','158350','158953','158777','158812','158956','159644','159756','159546','160511','160295','160571','161482','161592','161867','162280','162207','162282','162081','162127','269210','162205','162300','162301','162278','162360','162430','162376','162629','162754','162763','162821','162814','162683','162685','162841','162827','162862','163506','163505','164051','164082','164076','164089','164047','164064','164086','165149','165091','165127','165195','165622','165827','166603','166428','166424','166386','166563','166668','166605','166738','166839','166977','167132','167307','167247','167193','167474','167492','167782','168186','168469','168282','168542','168533','169224','169071','169285','169058','170349','170606','170706','171193','171230','171222','171160','171678','171577','171950','173710','173897','173901','174518','174628','174754','174403','174671','174767','175178','175458','175772','175865','175878','176244','176032','176039','176307','176396','176515','178473','178462','178470','178980','178858','178833','178837','179127','179046','179243','179899','179951','180429','180150','180849','180527','182624','182710','182494','182774','183265','183259','183733','184269','184759','184580','184521','184797','184804','184709','184910','184857','185127','185202','185622','185695','186122','186161','186124','186617','187044','187665','188146','188204','188231','188447','188362','188283','188706','189130','190560','191374','191604','192143','192954','274336','193446','194232','194318','274540','194269','274552','194140','194517','194784','194799','194950','194951','274718','195233','195419','195635','195633','195630','195812','196169','196287','196429','196390','197535','197494','197927','198385','198515','198257','198962','276393','200527','200504','276683','201221','201218','201219','201220','276682','201570','201375','276702','202147','202406','202495','202497','202527','202491','202492','202737','202761','203197','203089','203497','277092','203924','203896','204084','204953','204794','205283','205488','277527','277518','206197','206587','206434','206940','206936','206941','207450','207418','207522','207531','208087','208097','208305','208323','208327','208538','208539','208540','208509','208428','208699','208659','208660','208671','208817','208819','208975','209116','209117','209065','209174','209306','209310','209309','209367','209564','209493','209495','209500','209696','209639','210409','210589','211103','211255','217379','217242','217199','217370','217760','219335','220232','220241','220272','220765','221276','221439','221857','222363','222365','222654','283409','283458','283457','223028','222944','222918','283468','283482','223321','223299','224112','224638','225244','225414','225607','225575','225852','284593','284591','226342','226341','284669','226340','284668','226339','226819','284764','284763','226993','227349','227355','227678','227675','228031','228006','227755','228316','284945','284995','284993','228532','284990','284989','228595','284988','228594','284987','284986','284985','284984','228593','228592','228440','45245','45299','45231','45144','45227','45211','45266','285253','45781','45654','45705','45759','45721','46304','46502','46254','46425','46806','285419','46804','285417','46726','285414','47248','47069','47281','285439','285493','49198','49303','49276','49204','49228','49089','49099','49446','285929','49651') AND ( ( ( MATCH(g.title,g.a_cas,g.a_guige2,g.a_huohao,g.a_mfs) AGAINST ('甲醇' IN NATURAL LANGUAGE MODE) ) ) ) AND ( ( `min_price` >= '1000' AND `min_price` <= '1500' ) ) [ RunTime:1.457611s ]
>🍏🍏🍏>SELECT `id`,`pid`,`name` FROM `sx_goods_category` WHERE `id` = 1000 AND `is_enable` = 1 LIMIT 1 [ RunTime:0.000433s ]
>🍏🍏🍏>SELECT `id`,`pid`,`name` FROM `sx_goods_category` WHERE `pid` = 0 AND `is_enable` = 1 [ RunTime:0.000086s ]
>🍏🍏🍏>SELECT `id`,`pid`,`name` FROM `sx_goods_category` WHERE `id` = 0 AND `is_enable` = 1 LIMIT 1 [ RunTime:0.000084s ]
>🍏🍏🍏>SELECT `name` FROM `sx_screening_price` WHERE `id` = 18 LIMIT 1 [ RunTime:0.000080s ]
>🍏🍏🍏>SELECT MAX(`price`) AS think_max FROM `sx_goods_spec_base` [ RunTime:0.000081s ]
>🍏🍏🍏>SELECT `name`,`vice_name`,`describe`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sx_goods_category` WHERE `is_enable` = 1 AND `id` = 1000 LIMIT 1 [ RunTime:0.000194s ]
>🍏🍏🍏>SELECT `id`,`name` FROM `sx_goods_category` WHERE `pid` = 1000 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000224s ]
>🍏🍏🍏>SELECT `id`,`name`,`min_price`,`max_price` FROM `sx_screening_price` WHERE `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000093s ]
>🍎🍎🍎>SELECT `gsv`.`value` FROM `sx_goods` `g` INNER JOIN `sx_goods_category_join` `gci` ON `g`.`id`=`gci`.`goods_id` INNER JOIN `sx_goods_spec_value` `gsv` ON `g`.`id`=`gsv`.`goods_id` WHERE `g`.`is_delete_time` = '0' AND `g`.`is_shelves` = '1' AND `gci`.`category_id` = '1000' AND `g`.`id` IN ('232406','199','231975','231981','231989','232005','232016','232034','232094','232314','232331','1071','1137','1311','1359','1052','1502','1514','1786','2010','2118','2211','2814','2821','2825','2843','2844','2856','2909','3073','3554','3562','3563','3612','3726','3803','3831','3909','4040','4043','4088','4374','4383','4434','4544','4566','4618','4662','4710','4713','4729','4730','4737','4753','4756','4763','4787','4832','4846','4913','4917','4955','5061','5174','5256','5280','5304','5317','5318','5507','5536','5533','5647','5703','5868','6876','7078','7552','7566','7759','7784','7814','7876','8393','8414','8477','8484','8502','8510','8519','8549','8558','8606','8670','8679','8683','8765','8864','8867','8876','8530','8974','9106','9366','9368','9016','9392','9416','9502','9546','9710','10143','10427','10678','10689','10432','11083','11141','11162','11165','11170','11174','11242','11270','11348','11353','11472','11479','232690','11687','11690','11691','11710','11728','11981','12036','12040','12044','12159','11908','12185','12186','12189','12193','12208','12228','12256','12278','12315','12316','12434','12471','12530','12549','12556','12559','12661','12733','12759','12766','12836','13010','13067','13072','13086','13094','13095','13129','12742','12816','12722','13400','13774','13921','14198','14210','14259','14289','14300','14348','14351','14355','14374','14494','14535','14560','14569','14570','14572','14576','14581','14582','14602','14623','14633','14638','14683','14687','14724','14784','14798','14873','14912','14918','14922','14938','14947','15018','15031','15045','15070','15073','15084','15109','15113','15144','15229','15246','15253','15295','14971','15613','15920','16205','16241','16294','16448','16596','17429','17635','17667','17669','17768','17806','17810','17813','17819','17829','17882','17968','17977','18012','18087','18091','18095','18100','18114','18132','18164','18198','18338','18529','18537','18585','18821','18923','18952','19060','19070','19078','19101','19100','19206','19246','19296','19391','19410','19420','19432','19444','19480','19499','19500','19552','19557','19578','19197','19898','19964','20154','20562','20567','20649','20968','20983','21034','21141','21171','21175','21182','21193','21203','21223','21227','21230','21329','21335','21439','21471','21479','21614','21651','21669','21682','21716','21853','21891','21893','21898','21902','21913','21918','21962','21589','22010','22011','22039','22072','22116','22168','22174','22185','232952','232954','22044','22145','22431','22577','22503','22558','22824','22825','22826','22827','22828','22829','22830','22831','22832','22833','22834','22835','22836','232965','22837','22838','22839','22840','22842','22852','22853','22854','22855','22856','22857','22858','22859','22860','22791','22792','22793','22794','22795','22796','22797','22798','22799','22800','22801','22802','22803','22804','22805','22806','22807','22808','22809','22810','22811','22812','22813','22814','22815','22816','22817','22818','22819','22820','22821','22989','22990','22992','22993','22994','22995','22996','22997','22998','22999','232971','23000','23001','23002','23026','22945','23044','23164','23411','23427','23494','23545','23560','232993','23781','23788','232998','23835','24009','24024','24027','24046','24049','24112','24209','24210','24298','24254','24279','233020','24316','24364','24376','24382','24407','24417','24426','24435','24511','24517','24530','24861','24885','24892','24895','24951','24958','24979','25064','25541','25542','25543','25544','25545','25546','25547','25548','25549','25550','25551','25552','25553','25554','25555','25556','25557','25558','25559','25560','25561','25562','25563','25564','25565','25566','25567','25568','25569','25570','25571','25572','25573','25574','25220','25304','25312','25380','25601','25607','25610','25790','25855','25864','25908','25909','25921','25929','26043','26047','26215','26628','26664','26742','26983','27353','27442','27809','28033','28101','28600','28674','28681','28721','28735','28752','28971','29003','29109','29144','29157','29170','29179','29180','29204','29226','29473','29582','29602','29674','29697','29724','29727','29790','29961','29975','30003','30007','30012','30083','30147','30157','30168','30204','30287','233143','30417','30456','30457','30467','30472','30529','30569','30594','30597','30635','30787','30789','30814','30822','233155','30824','30827','31257','30942','30856','31032','31479','31555','31568','31593','31611','31700','31748','31775','31781','31809','31902','31906','31934','31954','32680','233220','33068','33069','33070','33071','33072','33114','33115','33116','33117','33118','33119','33120','33121','33122','33123','33124','33125','33073','33074','33075','33076','33077','33078','33079','33130','33126','33127','33128','33129','33080','33088','33081','33082','33089','33085','33083','33090','33086','33084','33091','33087','33169','33132','33134','33138','33140','33142','33144','33146','33219','33147','33148','33149','33150','33151','33152','33153','33154','33155','33156','33157','33158','33930','33966','34024','34218','34219','34046','33931','34048','233246','34028','33962','34104','34114','34225','33898','34289','33933','34029','33908','33944','33900','34025','33937','33938','34241','34030','33902','33964','33965','33961','34026','33939','34185','33963','33897','34238','33896','34142','34758','34720','34945','34986','34898','35594','35556','35273','35732','35641','35794','35757','35925','35927','35926','35941','36175','35896','35819','36180','36265','36728','36716','36761','36850','37018','36871','36714','36931','36916','36870','37526','37528','37516','37525','37320','37563','37334','37802','37876','37769','38663','38661','38662','38664','38677','38660','38678','38679','38684','38519','38900','38694','38997','39999','40121','39821','39830','40386','40289','40895','41764','42066','42064','42044','42851','43252','43251','43221','43250','43213','43110','44472','44550','44479','44396','44401','44480','44402','44485','44405','44410','44420','44422','44424','44486','44661','44426','44365','44494','44438','44440','44444','44495','44499','44452','44503','44455','44459','233623','44466','44467','45102','44778','44835','44981','44932','44994','45069','44809','44936','44999','45040','45054','233664','51974','52053','52758','233814','53906','53767','48390','48523','48401','48421','48113','48103','54092','52208','48620','48720','48721','48719','48734','52430','55491','55313','55421','234662','55740','56260','55565','56642','56634','56439','234810','234865','54380','54383','63028','62891','54853','63095','63230','235108','63557','63339','60945','61007','61027','60969','60780','60963','65001','235679','65058','65014','65005','65000','64995','64976','64975','64973','64966','64965','64964','65060','235678','65040','65011','64977','65012','235684','65036','65045','65015','64978','235677','65041','64997','64968','65025','64996','64981','64980','64974','235675','65017','63938','63941','63842','63943','64049','64055','63877','64043','63725','63726','63728','63841','63714','63794','63796','64024','64151','63819','63947','63817','63893','64117','63912','65220','65131','65375','65244','65371','65295','65212','65203','65173','65075','65073','65069','65323','235733','65240','65125','65336','235736','65147','65129','65349','65348','235731','235732','65142','65090','65393','65300','235734','65233','65199','65107','65106','65363','65262','65188','65248','235712','65525','65484','65491','65488','65502','235747','235773','235770','235821','235820','65856','66065','66343','66262','66478','236029','236067','67438','67670','67806','67750','67865','68075','67913','236247','67967','68483','236276','68420','236334','64281','64156','64163','64386','237369','69761','69744','69762','237492','237520','69760','69791','71765','238386','238317','238547','238278','238904','238606','238685','239422','239426','239345','240248','240541','240535','240683','241058','241059','246376','246547','246552','246883','247725','255603','255652','255650','255648','255646','255645','255702','256393','256387','257955','258135','258440','258955','259009','258961','259639','259746','260018','259995','259982','259975','260268','260497','260529','260740','260829','260967','261274','261670','261664','261732','261865','261768','262233','262340','262686','262737','76117','76179','75997','76273','76397','76254','76264','76125','76191','76265','263081','76395','76557','76635','76896','76626','76604','76772','76528','76482','76621','76808','76520','76527','76971','77212','77200','77403','79268','79789','79857','79929','80548','81540','81465','81458','81494','81543','81461','81469','81508','81509','81484','81490','81527','81531','81438','81517','81487','81680','81547','81612','81551','81568','81569','81637','81662','81713','81716','81729','81619','81721','81773','81776','81576','81644','81647','81594','81567','81599','81668','81664','81746','81630','81732','82137','82152','82292','82545','82322','83601','83613','83333','83337','83928','83948','83740','83746','84009','83862','84863','85080','85047','85066','85037','85055','85057','85072','85074','85078','85093','85035','263704','85043','85045','85049','85051','85053','85064','85069','263705','85076','85085','263706','85062','85945','86038','263747','85782','85767','85789','85800','85759','85828','85829','85831','85832','85757','85761','85765','85780','85786','85787','85788','85790','85864','85865','85868','85882','85886','85895','85901','85910','85921','85763','85769','85771','85775','85792','85795','85942','85943','85949','85950','85952','85953','85979','85984','85988','85976','85783','85785','85983','85773','85779','85796','85797','85798','85799','85998','85999','86000','86004','86008','86012','86013','86026','86029','86030','86031','86035','86039','86042','86047','86048','86054','86067','86070','85777','85801','85804','85961','85962','85794','85959','86007','85755','86362','86314','86134','86239','86218','86131','86126','86589','86791','86661','86839','86894','86812','86880','87425','87598','87599','87483','87605','87400','87410','87417','87479','87523','87621','87623','87394','87437','87443','87481','87255','87521','263819','87493','87499','263821','87423','87547','87902','87739','87862','87914','87880','87904','263824','263827','87793','87795','87937','87686','87791','87771','87789','88005','87908','88009','87719','87741','87773','87906','87939','87648','88003','88027','87858','88143','88161','88384','88172','88282','88140','88386','88213','88280','88071','88145','88444','88147','88288','88306','88354','88344','88484','88582','88507','88482','88584','88470','88554','88537','88611','88580','88586','88613','88447','88532','88588','88621','90738','90943','90725','90786','90868','90929','90959','90825','90961','91001','90730','90757','90908','90723','90904','90763','90780','90788','90796','90813','90902','90906','90920','91021','90750','90878','90830','90914','90918','90939','90969','90856','90860','90926','90931','90957','90983','90999','91007','91074','91050','91058','91102','91032','91177','91360','91052','91054','91060','91113','91149','91505','92144','92326','92151','92180','92383','92386','92146','264021','92292','92176','92288','92289','92291','92341','92350','92354','92358','92364','92367','92469','92286','92353','92449','92199','92290','92310','92389','92462','92472','92287','92337','92634','92666','92677','92590','92648','92690','92697','92700','92701','92589','92587','92670','92588','92515','92591','92671','92744','92669','92592','92816','92897','93159','93161','93359','93363','93368','93154','93160','93322','93442','93153','93155','93156','93157','93162','93164','93320','93362','93158','93163','93321','93323','93693','93696','93712','93771','93511','93513','93516','93521','93533','264070','93561','93565','93553','93683','93510','93528','93534','93540','93691','93675','93694','93951','93918','93919','93920','93925','93979','93990','93837','93885','93897','93934','93863','93938','93956','93976','93977','93981','93982','93991','94035','94042','94043','93862','93864','94065','93916','93965','93902','93861','93986','93987','93988','93989','94385','94472','94405','94379','94979','94708','95116','94698','94712','95024','94866','96465','96601','96631','96330','97049','97037','97323','97510','97563','97497','97720','98138','98800','98874','98780','98693','98695','98697','98739','98742','98743','98748','264217','98750','98751','98752','98755','98756','98758','98757','98759','98870','99148','99483','99397','99394','99881','100158','99924','100040','100466','100777','100812','100846','100971','103267','103263','103264','103266','103643','104928','105001','104977','105044','104911','105235','105283','105298','105416','105279','105402','105085','105124','105263','105223','105424','105900','105961','105613','105781','105995','106306','106232','106164','106302','106339','106134','106127','106446','106410','106565','106959','106552','106915','106589','106647','106605','106494','106889','106731','106858','106849','106921','106834','106938','106714','106572','106557','106553','107074','107391','107290','107291','107075','107430','107123','107332','107376','107107','107322','107103','107362','107333','107062','107363','107359','107392','107377','107364','107292','107047','107334','107248','106977','107912','107657','107614','107721','107700','107468','107481','107722','107879','107615','107616','107781','107617','107723','107828','107913','107812','107509','107880','107989','108140','108081','108046','108251','108069','108387','108274','108418','108141','108191','108142','108419','108364','107995','108090','108143','108420','108192','108440','108351','107981','108318','108275','108104','108144','108319','108169','108012','108490','108460','108484','108461','109575','109612','109592','109594','109628','109557','109602','109636','109542','109639','109532','109595','109608','109644','109535','109588','109626','109551','109564','109558','109536','109600','109610','109613','109630','109565','109637','109627','109622','109633','109618','109552','109563','109566','109567','109573','109583','109609','109537','109619','109596','109590','109533','109577','109611','109553','109642','109543','109640','109641','109544','109629','109597','109584','109624','109576','109593','109549','109585','109538','109617','109568','109541','109529','109606','109580','109645','109586','109574','109615','109530','109616','109625','109559','109560','109554','109601','109578','109555','109599','109623','109531','109561','109632','109634','109635','109545','109579','109546','109556','109569','109550','109581','109570','109605','109562','109539','109587','109631','109638','109582','109534','109589','109643','109540','109604','109571','109547','109598','109548','109620','109591','109572','109603','109607','109614','109621','110727','264712','110701','110640','110926','111046','111282','111038','111071','110939','111421','111558','111368','111334','111692','112092','112222','120325','120329','120238','120388','120196','120212','120334','120344','120195','120270','120411','120403','120239','120300','120311','120173','120240','120241','120281','120215','120363','120330','122102','121984','121840','122348','122427','265512','122417','122422','122413','122701','122883','122681','122896','123032','123034','122984','123680','123595','124340','124533','124830','125917','125672','125666','125847','125864','125875','126499','127658','128137','128282','128264','128339','128657','128468','128593','129024','129277','129558','129265','129506','129735','129714','130378','130191','131091','131115','139547','139564','139829','139589','139570','139780','267963','140283','267970','140372','140500','140502','140482','141270','141608','142676','142612','142671','142626','144872','144887','144896','144899','144902','147802','147762','148013','148016','148546','148321','148316','148334','148683','148711','148947','148825','148823','148793','148982','149095','149767','150177','149843','149868','149865','150523','150570','150334','150773','268519','151825','151816','152122','268526','152502','152336','152518','152317','153675','153398','153748','154041','268711','154497','154699','154855','155010','155417','155660','155931','155853','156566','156775','156825','268838','157394','157145','268853','157434','157504','157737','158350','158953','158777','158812','158956','159644','159756','159546','160511','160295','160571','161482','161592','161867','162280','162207','162282','162081','162127','269210','162205','162300','162301','162278','162360','162430','162376','162629','162754','162763','162821','162814','162683','162685','162841','162827','162862','163506','163505','164051','164082','164076','164089','164047','164064','164086','165149','165091','165127','165195','165622','165827','166603','166428','166424','166386','166563','166668','166605','166738','166839','166977','167132','167307','167247','167193','167474','167492','167782','168186','168469','168282','168542','168533','169224','169071','169285','169058','170349','170606','170706','171193','171230','171222','171160','171678','171577','171950','173710','173897','173901','174518','174628','174754','174403','174671','174767','175178','175458','175772','175865','175878','176244','176032','176039','176307','176396','176515','178473','178462','178470','178980','178858','178833','178837','179127','179046','179243','179899','179951','180429','180150','180849','180527','182624','182710','182494','182774','183265','183259','183733','184269','184759','184580','184521','184797','184804','184709','184910','184857','185127','185202','185622','185695','186122','186161','186124','186617','187044','187665','188146','188204','188231','188447','188362','188283','188706','189130','190560','191374','191604','192143','192954','274336','193446','194232','194318','274540','194269','274552','194140','194517','194784','194799','194950','194951','274718','195233','195419','195635','195633','195630','195812','196169','196287','196429','196390','197535','197494','197927','198385','198515','198257','198962','276393','200527','200504','276683','201221','201218','201219','201220','276682','201570','201375','276702','202147','202406','202495','202497','202527','202491','202492','202737','202761','203197','203089','203497','277092','203924','203896','204084','204953','204794','205283','205488','277527','277518','206197','206587','206434','206940','206936','206941','207450','207418','207522','207531','208087','208097','208305','208323','208327','208538','208539','208540','208509','208428','208699','208659','208660','208671','208817','208819','208975','209116','209117','209065','209174','209306','209310','209309','209367','209564','209493','209495','209500','209696','209639','210409','210589','211103','211255','217379','217242','217199','217370','217760','219335','220232','220241','220272','220765','221276','221439','221857','222363','222365','222654','283409','283458','283457','223028','222944','222918','283468','283482','223321','223299','224112','224638','225244','225414','225607','225575','225852','284593','284591','226342','226341','284669','226340','284668','226339','226819','284764','284763','226993','227349','227355','227678','227675','228031','228006','227755','228316','284945','284995','284993','228532','284990','284989','228595','284988','228594','284987','284986','284985','284984','228593','228592','228440','45245','45299','45231','45144','45227','45211','45266','285253','45781','45654','45705','45759','45721','46304','46502','46254','46425','46806','285419','46804','285417','46726','285414','47248','47069','47281','285439','285493','49198','49303','49276','49204','49228','49089','49099','49446','285929','49651') AND ( ( ( MATCH(g.title,g.a_cas,g.a_guige2,g.a_huohao,g.a_mfs) AGAINST ('甲醇' IN NATURAL LANGUAGE MODE) ) ) ) AND ( ( `min_price` >= '1000' AND `min_price` <= '1500' ) ) GROUP BY `gsv`.`value` [ RunTime:1.047516s ]
