>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_navigation` [ RunTime:0.000340s ]
>🍏🍏🍏>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.000102s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_plugins` [ RunTime:0.000291s ]
>🍏🍏🍏>SELECT * FROM `sx_plugins` [ RunTime:0.000113s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_goods_category` [ RunTime:0.000331s ]
>🍏🍏🍏>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.000102s ]
>🍏🍏🍏>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.000105s ]
>🍏🍏🍏>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.000131s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_plugins_themestyle_config` [ RunTime:0.000332s ]
>🍏🍏🍏>SELECT * FROM `sx_plugins_themestyle_config` WHERE `is_enable` = 1 AND `is_default` = 1 ORDER BY `sort` DESC,`id` DESC [ RunTime:0.000104s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_theme_data` [ RunTime:0.000270s ]
>🍏🍏🍏>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.000098s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_plugins_topada_slider` [ RunTime:0.000296s ]
>🍏🍏🍏>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:48:20') AND (time_end = '' OR time_end >= '2025-12-01 10:48:20') ) ORDER BY `sort` ASC,`id` ASC [ RunTime:0.000312s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_goods_spec_base` [ RunTime:0.000288s ]
>🍏🍏🍏>SELECT `goods_id` FROM `sx_goods_spec_base` WHERE ( `barcode` = '15721-02-5' OR `coding` = '15721-02-5' ) [ RunTime:0.000108s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_goods_spec_value` [ RunTime:0.000246s ]
>🍏🍏🍏>SELECT `goods_id` FROM `sx_goods_spec_value` WHERE `value` = '200μg' [ RunTime:0.066154s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_goods` [ RunTime:0.000604s ]
>🍎🍎🍎>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 `g`.`id` IN ('101208','164605','164609','164608','164607') AND ( ( ( MATCH(g.title,g.a_cas,g.a_guige2,g.a_huohao,g.a_mfs) AGAINST ('15721-02-5' IN NATURAL LANGUAGE MODE) ) ) ) [ RunTime:2.585935s ]
>🍎🍎🍎>SELECT `g`.* 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 `g`.`id` IN ('101208','164605','164609','164608','164607') AND ( ( ( MATCH(g.title,g.a_cas,g.a_guige2,g.a_huohao,g.a_mfs) AGAINST ('15721-02-5' IN NATURAL LANGUAGE MODE) ) ) ) GROUP BY `g`.`id` ORDER BY `g`.`sort_level` DESC,`g`.`access_count` DESC,`g`.`sales_count` DESC,`g`.`id` DESC LIMIT 0,20 [ RunTime:2.763657s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_brand` [ RunTime:0.032297s ]
>🍏🍏🍏>SELECT `name`,`id` FROM `sx_brand` WHERE `id` = 100 [ RunTime:0.000109s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_goods_photo` [ RunTime:0.000251s ]
>🍏🍏🍏>SELECT * FROM `sx_goods_photo` WHERE `goods_id` IN (164609,164608,164607,164605,101208) AND `is_show` = 1 ORDER BY `sort` ASC [ RunTime:0.008194s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_goods_spec_type` [ RunTime:0.000252s ]
>🍏🍏🍏>SELECT * FROM `sx_goods_spec_type` WHERE `goods_id` IN (164609,164608,164607,164605,101208) ORDER BY `id` ASC [ RunTime:0.004653s ]
>🍏🍏🍏>SELECT `id`,`title`,`is_exist_many_spec` FROM `sx_goods` WHERE `id` = 101208 LIMIT 1 [ RunTime:0.000185s ]
>🍏🍏🍏>SELECT `goods_spec_base_id` FROM `sx_goods_spec_value` WHERE `goods_id` = 101208 AND `value` = '200μg' [ RunTime:0.001039s ]
>🍏🍏🍏>SELECT `goods_spec_base_id`,`value` FROM `sx_goods_spec_value` WHERE `goods_spec_base_id` = 126403 ORDER BY `id` ASC [ RunTime:0.000208s ]
>🍏🍏🍏>SELECT * FROM `sx_goods_spec_base` WHERE `id` = 126403 LIMIT 1 [ RunTime:0.000598s ]
>🍏🍏🍏>SELECT plugins_points_exchange_integral as integral,plugins_points_exchange_price as price,`id` FROM `sx_goods` WHERE `id` = 101208 [ RunTime:0.000176s ]
>🍏🍏🍏>SELECT `id`,`title`,`is_exist_many_spec` FROM `sx_goods` WHERE `id` = 164605 LIMIT 1 [ RunTime:0.000173s ]
>🍏🍏🍏>SELECT `goods_spec_base_id` FROM `sx_goods_spec_value` WHERE `goods_id` = 164605 AND `value` = '200μg' [ RunTime:0.000206s ]
>🍏🍏🍏>SELECT `goods_spec_base_id`,`value` FROM `sx_goods_spec_value` WHERE `goods_spec_base_id` = 192912 ORDER BY `id` ASC [ RunTime:0.000232s ]
>🍏🍏🍏>SELECT * FROM `sx_goods_spec_base` WHERE `id` = 192912 LIMIT 1 [ RunTime:0.000796s ]
>🍏🍏🍏>SELECT plugins_points_exchange_integral as integral,plugins_points_exchange_price as price,`id` FROM `sx_goods` WHERE `id` = 164605 [ RunTime:0.000209s ]
>🍏🍏🍏>SELECT `id`,`title`,`is_exist_many_spec` FROM `sx_goods` WHERE `id` = 164609 LIMIT 1 [ RunTime:0.000163s ]
>🍏🍏🍏>SELECT `goods_spec_base_id` FROM `sx_goods_spec_value` WHERE `goods_id` = 164609 AND `value` = '200μg' [ RunTime:0.000194s ]
>🍏🍏🍏>SELECT `goods_spec_base_id`,`value` FROM `sx_goods_spec_value` WHERE `goods_spec_base_id` = 192933 ORDER BY `id` ASC [ RunTime:0.000204s ]
>🍏🍏🍏>SELECT * FROM `sx_goods_spec_base` WHERE `id` = 192933 LIMIT 1 [ RunTime:0.000159s ]
>🍏🍏🍏>SELECT plugins_points_exchange_integral as integral,plugins_points_exchange_price as price,`id` FROM `sx_goods` WHERE `id` = 164609 [ RunTime:0.000173s ]
>🍏🍏🍏>SELECT `id`,`title`,`is_exist_many_spec` FROM `sx_goods` WHERE `id` = 164608 LIMIT 1 [ RunTime:0.000154s ]
>🍏🍏🍏>SELECT `goods_spec_base_id` FROM `sx_goods_spec_value` WHERE `goods_id` = 164608 AND `value` = '200μg' [ RunTime:0.000184s ]
>🍏🍏🍏>SELECT `goods_spec_base_id`,`value` FROM `sx_goods_spec_value` WHERE `goods_spec_base_id` = 192946 ORDER BY `id` ASC [ RunTime:0.000196s ]
>🍏🍏🍏>SELECT * FROM `sx_goods_spec_base` WHERE `id` = 192946 LIMIT 1 [ RunTime:0.000175s ]
>🍏🍏🍏>SELECT plugins_points_exchange_integral as integral,plugins_points_exchange_price as price,`id` FROM `sx_goods` WHERE `id` = 164608 [ RunTime:0.000147s ]
>🍏🍏🍏>SELECT `id`,`title`,`is_exist_many_spec` FROM `sx_goods` WHERE `id` = 164607 LIMIT 1 [ RunTime:0.000149s ]
>🍏🍏🍏>SELECT `goods_spec_base_id` FROM `sx_goods_spec_value` WHERE `goods_id` = 164607 AND `value` = '200μg' [ RunTime:0.000172s ]
>🍏🍏🍏>SELECT `goods_spec_base_id`,`value` FROM `sx_goods_spec_value` WHERE `goods_spec_base_id` = 192965 ORDER BY `id` ASC [ RunTime:0.000157s ]
>🍏🍏🍏>SELECT * FROM `sx_goods_spec_base` WHERE `id` = 192965 LIMIT 1 [ RunTime:0.000162s ]
>🍏🍏🍏>SELECT plugins_points_exchange_integral as integral,plugins_points_exchange_price as price,`id` FROM `sx_goods` WHERE `id` = 164607 [ RunTime:0.000145s ]
>🍏🍏🍏>SELECT * FROM `sx_goods_photo` WHERE `goods_id` = 164609 AND `is_show` = 1 ORDER BY `sort` ASC [ RunTime:0.000221s ]
>🍏🍏🍏>SELECT `images` FROM `sx_goods_photo` WHERE `goods_id` = 164609 AND `is_show` = 1 ORDER BY `sort` ASC LIMIT 1 [ RunTime:0.000182s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_goods_v_desc` [ RunTime:0.000304s ]
>🍏🍏🍏>SELECT `name_identifiers` FROM `sx_goods_v_desc` WHERE `gid` = 164609 LIMIT 1 [ RunTime:0.000958s ]
>🍏🍏🍏>SELECT `chemical_physical` FROM `sx_goods_v_desc` WHERE `gid` = 164609 LIMIT 1 [ RunTime:0.000149s ]
>🍏🍏🍏>SELECT `safe_attribute` FROM `sx_goods_v_desc` WHERE `gid` = 164609 LIMIT 1 [ RunTime:0.000144s ]
>🍏🍏🍏>SELECT `bibliography` FROM `sx_goods_v_desc` WHERE `gid` = 164609 LIMIT 1 [ RunTime:0.000141s ]
>🍏🍏🍏>SELECT `content_web` FROM `sx_goods_v_desc` WHERE `gid` = 164609 LIMIT 1 [ RunTime:0.000151s ]
>🍏🍏🍏>SELECT * FROM `sx_goods_photo` WHERE `goods_id` = 164608 AND `is_show` = 1 ORDER BY `sort` ASC [ RunTime:0.000202s ]
>🍏🍏🍏>SELECT `images` FROM `sx_goods_photo` WHERE `goods_id` = 164608 AND `is_show` = 1 ORDER BY `sort` ASC LIMIT 1 [ RunTime:0.000195s ]
>🍏🍏🍏>SELECT `name_identifiers` FROM `sx_goods_v_desc` WHERE `gid` = 164608 LIMIT 1 [ RunTime:0.000154s ]
>🍏🍏🍏>SELECT `chemical_physical` FROM `sx_goods_v_desc` WHERE `gid` = 164608 LIMIT 1 [ RunTime:0.000151s ]
>🍏🍏🍏>SELECT `safe_attribute` FROM `sx_goods_v_desc` WHERE `gid` = 164608 LIMIT 1 [ RunTime:0.000158s ]
>🍏🍏🍏>SELECT `bibliography` FROM `sx_goods_v_desc` WHERE `gid` = 164608 LIMIT 1 [ RunTime:0.000142s ]
>🍏🍏🍏>SELECT `content_web` FROM `sx_goods_v_desc` WHERE `gid` = 164608 LIMIT 1 [ RunTime:0.000162s ]
>🍏🍏🍏>SELECT * FROM `sx_goods_photo` WHERE `goods_id` = 164607 AND `is_show` = 1 ORDER BY `sort` ASC [ RunTime:0.000204s ]
>🍏🍏🍏>SELECT `images` FROM `sx_goods_photo` WHERE `goods_id` = 164607 AND `is_show` = 1 ORDER BY `sort` ASC LIMIT 1 [ RunTime:0.000204s ]
>🍏🍏🍏>SELECT `name_identifiers` FROM `sx_goods_v_desc` WHERE `gid` = 164607 LIMIT 1 [ RunTime:0.000146s ]
>🍏🍏🍏>SELECT `chemical_physical` FROM `sx_goods_v_desc` WHERE `gid` = 164607 LIMIT 1 [ RunTime:0.000156s ]
>🍏🍏🍏>SELECT `safe_attribute` FROM `sx_goods_v_desc` WHERE `gid` = 164607 LIMIT 1 [ RunTime:0.000169s ]
>🍏🍏🍏>SELECT `bibliography` FROM `sx_goods_v_desc` WHERE `gid` = 164607 LIMIT 1 [ RunTime:0.000142s ]
>🍏🍏🍏>SELECT `content_web` FROM `sx_goods_v_desc` WHERE `gid` = 164607 LIMIT 1 [ RunTime:0.000138s ]
>🍏🍏🍏>SELECT * FROM `sx_goods_photo` WHERE `goods_id` = 164605 AND `is_show` = 1 ORDER BY `sort` ASC [ RunTime:0.000184s ]
>🍏🍏🍏>SELECT `images` FROM `sx_goods_photo` WHERE `goods_id` = 164605 AND `is_show` = 1 ORDER BY `sort` ASC LIMIT 1 [ RunTime:0.000177s ]
>🍏🍏🍏>SELECT `name_identifiers` FROM `sx_goods_v_desc` WHERE `gid` = 164605 LIMIT 1 [ RunTime:0.000155s ]
>🍏🍏🍏>SELECT `chemical_physical` FROM `sx_goods_v_desc` WHERE `gid` = 164605 LIMIT 1 [ RunTime:0.000139s ]
>🍏🍏🍏>SELECT `safe_attribute` FROM `sx_goods_v_desc` WHERE `gid` = 164605 LIMIT 1 [ RunTime:0.000144s ]
>🍏🍏🍏>SELECT `bibliography` FROM `sx_goods_v_desc` WHERE `gid` = 164605 LIMIT 1 [ RunTime:0.000149s ]
>🍏🍏🍏>SELECT `content_web` FROM `sx_goods_v_desc` WHERE `gid` = 164605 LIMIT 1 [ RunTime:0.000136s ]
>🍏🍏🍏>SELECT * FROM `sx_goods_photo` WHERE `goods_id` = 101208 AND `is_show` = 1 ORDER BY `sort` ASC [ RunTime:0.000219s ]
>🍏🍏🍏>SELECT `images` FROM `sx_goods_photo` WHERE `goods_id` = 101208 AND `is_show` = 1 ORDER BY `sort` ASC LIMIT 1 [ RunTime:0.000180s ]
>🍏🍏🍏>SELECT `name_identifiers` FROM `sx_goods_v_desc` WHERE `gid` = 101208 LIMIT 1 [ RunTime:0.000157s ]
>🍏🍏🍏>SELECT `chemical_physical` FROM `sx_goods_v_desc` WHERE `gid` = 101208 LIMIT 1 [ RunTime:0.000143s ]
>🍏🍏🍏>SELECT `safe_attribute` FROM `sx_goods_v_desc` WHERE `gid` = 101208 LIMIT 1 [ RunTime:0.000138s ]
>🍏🍏🍏>SELECT `bibliography` FROM `sx_goods_v_desc` WHERE `gid` = 101208 LIMIT 1 [ RunTime:0.000140s ]
>🍏🍏🍏>SELECT `content_web` FROM `sx_goods_v_desc` WHERE `gid` = 101208 LIMIT 1 [ RunTime:0.000142s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_gcas` [ RunTime:0.000395s ]
>🍏🍏🍏>SELECT * FROM `sx_gcas` WHERE `is_enable` = 1 AND `title` = '13058-04-3' LIMIT 1 [ RunTime:0.000694s ]
>🍏🍏🍏>SELECT * FROM `sx_gcas` WHERE `is_enable` = 1 AND `title` = '6699-20-3' LIMIT 1 [ RunTime:0.000618s ]
>🍏🍏🍏>SELECT * FROM `sx_gcas` WHERE `is_enable` = 1 AND `title` = '116057-53-5' LIMIT 1 [ RunTime:0.000669s ]
>🍏🍏🍏>SELECT * FROM `sx_gcas` WHERE `is_enable` = 1 AND `title` = '1186-30-7' LIMIT 1 [ RunTime:0.000675s ]
>🍏🍏🍏>SELECT * FROM `sx_gcas` WHERE `is_enable` = 1 AND `title` = '84573-16-0' LIMIT 1 [ RunTime:0.000559s ]
>🍏🍏🍏>SELECT MAX(`price`) AS think_max FROM `sx_goods_spec_base` [ RunTime:0.000092s ]
>🍏🍏🍏>SELECT `id`,`name` FROM `sx_goods_category` WHERE `pid` = 0 AND `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000085s ]
>🍏🍏🍏>SHOW FULL COLUMNS FROM `sx_screening_price` [ RunTime:0.000285s ]
>🍏🍏🍏>SELECT `id`,`name`,`min_price`,`max_price` FROM `sx_screening_price` WHERE `is_enable` = 1 ORDER BY `sort` ASC [ RunTime:0.000087s ]
>🍎🍎🍎>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 `g`.`id` IN ('101208','164605','164609','164608','164607') AND ( ( ( MATCH(g.title,g.a_cas,g.a_guige2,g.a_huohao,g.a_mfs) AGAINST ('15721-02-5' IN NATURAL LANGUAGE MODE) ) ) ) GROUP BY `gsv`.`value` [ RunTime:2.522206s ]
