>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_navigation` [ RunTime:0.000341s ]
>🍏🍏🍏>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.000098s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_plugins` [ RunTime:0.000285s ]
>🍏🍏🍏>SELECT * FROM `sx_plugins` [ RunTime:0.000108s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_goods_category` [ RunTime:0.000340s ]
>🍏🍏🍏>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.000098s ]
>🍏🍏🍏>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.000092s ]
>🍏🍏🍏>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.000133s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_plugins_themestyle_config` [ RunTime:0.000289s ]
>🍏🍏🍏>SELECT * FROM `sx_plugins_themestyle_config` WHERE `is_enable` = 1 AND `is_default` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000107s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_theme_data` [ RunTime:0.000291s ]
>🍏🍏🍏>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.000109s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_plugins_topada_slider` [ RunTime:0.000286s ]
>🍏🍏🍏>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 11:01:12') AND (time_end = '' OR time_end >= '2025-12-01 11:01:12') ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000277s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_goods_spec_base` [ RunTime:0.000299s ]
>🍏🍏🍏>SELECT `goods_id` FROM `sx_goods_spec_base` WHERE ( `barcode` = '环己烷' OR `coding` = '环己烷' ) [ RunTime:0.000090s ]
>🍏🍏🍏>SELECT `id` FROM `sx_goods_category` WHERE `pid` = 339 AND `is_enable` = 1 [ RunTime:0.000204s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_screening_price` [ RunTime:0.000255s ]
>🍏🍏🍏>SELECT `min_price`,`max_price` FROM `sx_screening_price` WHERE `is_enable` = 1 AND `id` = 10 LIMIT 1 [ RunTime:0.000112s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_goods_spec_value` [ RunTime:0.000228s ]
>🍏🍏🍏>SELECT `goods_id` FROM `sx_goods_spec_value` WHERE `value` = '12X500ml' [ RunTime:0.067974s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_goods` [ RunTime:0.000530s ]
>🍎🍎🍎>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` = '339' AND `g`.`id` IN ('1763','1766','5310','7081','11144','12165','12744','12747','14566','15117','17432','19559','22562','29150','35672','176317','202459','202438','202404','202392','202778','202748','202650','202651','202662','202774','202603','202668','202801','202621','202716','202732','202731','202658','202803','202755','202712','202791','202757','208391','208393','217260','217383','217256','217263','217346','217344','217349','217326','217506','217325','281919','217399','217400','217446','217445','217299','217298','217333','217324','217334','217250','217380','217381','217382','217497','217498','217436','217437','217314','217319','217313','217507','281941','217513','217321','217511','217316','217249','217317','217318','281920','217203','217206','217204','217207','217246','217247','217244','217226','217225','217228','217234','217248','217428','217427','217435','217432','217490','217488','217359','217487','217217','217208','217394','217390','217392','217393','217291','217430','217297','217303','217304','217501','217500','217535','217355','217353','217357','217356','217433','217375','217374','217475','217480','217367','217369','217368','217376','217377','217477','217476','217478','217787','217754','281959','217755','217773','217774','217775','217778','217654','217661','217662','217579','217739','217740','217741','217666','217667','217832','217833','217668','217574','217652','217851','217853','217573','217766','217581','217580','217835','281945','217551','217733','217732','217734','217553','217735','217636','217659','217617','217618','217643','217644','217790','217725','217726','217637','217638','217645','217791','217724','217748','217750','217751','217752','217753','217749','217682','281965','217586','217565','217701','217702','217569','217570','217616','217828','217582','217583','281950','217763','217762','218869','218931','218932','218851','218850','218954','218955','218914','218936','218860','218859','218961','218864','218867','218929','218927','218926','282793','218901','218892','218891','218960','218949','218948','218951','218846','218847','218958','218959','218889','282795','218852','218855','218918','218885','218886','219124','282828','219123','219146','219127','219224','219143','219218','219217','219141','219136','219027','219171','219138','219139','219219','219128','219147','219148','219132','219133','219080','219081','219088','219020','219037','219042','282825','219090','219023','219038','219034','219033','219089','219091','219167','219165','219543','219463','219468','219476','219524','219523','219424','219380','219359','219358','219323','219325','219526','219525','219434','219431','219507','219331','219330','219472','219473','219519','219508','219426','219425','282854','219366','219367','282855','219332','219518','219365','219494','219517','219318','219248','219487','219360','219362','219361','219328','219439','219540','219370','219326','219537','219437','219255','219645','219810','219704','219816','219817','219774','219772','219773','219568','219709','219573','219574','219572','219668','282879','219604','219603','219569','219667','219779','219783','219606','282866','219647','219653','219683','219812','219813','219547','219724','219788','219607','219792','282872','219785','219701','219582','282906','220050','220033','219888','219889','219884','219882','219997','219865','219878','219868','220056','220006','220007','219863','282923','219879','219880','282905','219995','219877','282920','220051','219998','220001','282922','219900','219896','219895','219885','219866','220022','219875','219858','219859','219861','219860','282931','220036','219876','220143','220097','220163','220151','282946','220121','220265','282953','220178','220181','282935','220120','220189','220202','220166','220165','220095','220098','220099','282937','220119','220396','220439','220279','282978','220351','220480','220284','220382','220280','220360','220465','220376','220385','220384','220299','220466','220343','220339','220302','220350','282976','220409','220338','220492','220365','220352','220394','220349','220363','220315','220355','220533','282998','220361','220345','220435','220405','220397','282968','220387','220750','220588','220799','283035','283018','283036','220698','220541','220685','220604','220755','220701','220643','220538','283038','220540','220575','220712','220688','220552','220646','283003','220717','220551','220548','220549','220759','220674','220539','220652','220542','220608','283030','220816','220818','283049','283046','220826','220830') AND ( ( ( MATCH(g.title,g.a_cas,g.a_guige2,g.a_huohao,g.a_mfs) AGAINST ('环己烷' IN NATURAL LANGUAGE MODE) ) ) ) AND ( ( `min_price` >= '100' AND `min_price` <= '300' ) ) [ RunTime:0.307977s ]
>🍏🍏🍏>SELECT `id`,`pid`,`name` FROM `sx_goods_category` WHERE `id` = 339 AND `is_enable` = 1 LIMIT 1 [ RunTime:0.000277s ]
>🍏🍏🍏>SELECT `id`,`pid`,`name` FROM `sx_goods_category` WHERE `pid` = 25 AND `is_enable` = 1 [ RunTime:0.000105s ]
>🍏🍏🍏>SELECT `id`,`pid`,`name` FROM `sx_goods_category` WHERE `id` = 25 AND `is_enable` = 1 LIMIT 1 [ RunTime:0.000091s ]
>🍏🍏🍏>SELECT `id`,`pid`,`name` FROM `sx_goods_category` WHERE `pid` = 3 AND `is_enable` = 1 [ RunTime:0.000097s ]
>🍏🍏🍏>SELECT `id`,`pid`,`name` FROM `sx_goods_category` WHERE `id` = 3 AND `is_enable` = 1 LIMIT 1 [ RunTime:0.000087s ]
>🍏🍏🍏>SELECT `id`,`pid`,`name` FROM `sx_goods_category` WHERE `pid` = 0 AND `is_enable` = 1 [ RunTime:0.000084s ]
>🍏🍏🍏>SELECT `name` FROM `sx_screening_price` WHERE `id` = 10 LIMIT 1 [ RunTime:0.000084s ]
>🍏🍏🍏>SELECT MAX(`price`) AS think_max FROM `sx_goods_spec_base` [ RunTime:0.000082s ]
>🍏🍏🍏>SELECT `name`,`vice_name`,`describe`,`seo_title`,`seo_keywords`,`seo_desc` FROM `sx_goods_category` WHERE `is_enable` = 1 AND `id` = 339 LIMIT 1 [ RunTime:0.000180s ]
>🍏🍏🍏>SELECT `id`,`name` FROM `sx_goods_category` WHERE `pid` = 339 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000191s ]
>🍏🍏🍏>SELECT `id`,`name`,`min_price`,`max_price` FROM `sx_screening_price` WHERE `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000100s ]
>🍎🍎🍎>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` = '339' AND `g`.`id` IN ('1763','1766','5310','7081','11144','12165','12744','12747','14566','15117','17432','19559','22562','29150','35672','176317','202459','202438','202404','202392','202778','202748','202650','202651','202662','202774','202603','202668','202801','202621','202716','202732','202731','202658','202803','202755','202712','202791','202757','208391','208393','217260','217383','217256','217263','217346','217344','217349','217326','217506','217325','281919','217399','217400','217446','217445','217299','217298','217333','217324','217334','217250','217380','217381','217382','217497','217498','217436','217437','217314','217319','217313','217507','281941','217513','217321','217511','217316','217249','217317','217318','281920','217203','217206','217204','217207','217246','217247','217244','217226','217225','217228','217234','217248','217428','217427','217435','217432','217490','217488','217359','217487','217217','217208','217394','217390','217392','217393','217291','217430','217297','217303','217304','217501','217500','217535','217355','217353','217357','217356','217433','217375','217374','217475','217480','217367','217369','217368','217376','217377','217477','217476','217478','217787','217754','281959','217755','217773','217774','217775','217778','217654','217661','217662','217579','217739','217740','217741','217666','217667','217832','217833','217668','217574','217652','217851','217853','217573','217766','217581','217580','217835','281945','217551','217733','217732','217734','217553','217735','217636','217659','217617','217618','217643','217644','217790','217725','217726','217637','217638','217645','217791','217724','217748','217750','217751','217752','217753','217749','217682','281965','217586','217565','217701','217702','217569','217570','217616','217828','217582','217583','281950','217763','217762','218869','218931','218932','218851','218850','218954','218955','218914','218936','218860','218859','218961','218864','218867','218929','218927','218926','282793','218901','218892','218891','218960','218949','218948','218951','218846','218847','218958','218959','218889','282795','218852','218855','218918','218885','218886','219124','282828','219123','219146','219127','219224','219143','219218','219217','219141','219136','219027','219171','219138','219139','219219','219128','219147','219148','219132','219133','219080','219081','219088','219020','219037','219042','282825','219090','219023','219038','219034','219033','219089','219091','219167','219165','219543','219463','219468','219476','219524','219523','219424','219380','219359','219358','219323','219325','219526','219525','219434','219431','219507','219331','219330','219472','219473','219519','219508','219426','219425','282854','219366','219367','282855','219332','219518','219365','219494','219517','219318','219248','219487','219360','219362','219361','219328','219439','219540','219370','219326','219537','219437','219255','219645','219810','219704','219816','219817','219774','219772','219773','219568','219709','219573','219574','219572','219668','282879','219604','219603','219569','219667','219779','219783','219606','282866','219647','219653','219683','219812','219813','219547','219724','219788','219607','219792','282872','219785','219701','219582','282906','220050','220033','219888','219889','219884','219882','219997','219865','219878','219868','220056','220006','220007','219863','282923','219879','219880','282905','219995','219877','282920','220051','219998','220001','282922','219900','219896','219895','219885','219866','220022','219875','219858','219859','219861','219860','282931','220036','219876','220143','220097','220163','220151','282946','220121','220265','282953','220178','220181','282935','220120','220189','220202','220166','220165','220095','220098','220099','282937','220119','220396','220439','220279','282978','220351','220480','220284','220382','220280','220360','220465','220376','220385','220384','220299','220466','220343','220339','220302','220350','282976','220409','220338','220492','220365','220352','220394','220349','220363','220315','220355','220533','282998','220361','220345','220435','220405','220397','282968','220387','220750','220588','220799','283035','283018','283036','220698','220541','220685','220604','220755','220701','220643','220538','283038','220540','220575','220712','220688','220552','220646','283003','220717','220551','220548','220549','220759','220674','220539','220652','220542','220608','283030','220816','220818','283049','283046','220826','220830') AND ( ( ( MATCH(g.title,g.a_cas,g.a_guige2,g.a_huohao,g.a_mfs) AGAINST ('环己烷' IN NATURAL LANGUAGE MODE) ) ) ) AND ( ( `min_price` >= '100' AND `min_price` <= '300' ) ) GROUP BY `gsv`.`value` [ RunTime:0.315236s ]
