--------------------------------------------------------------- [ 2025-04-25T07:19:16+08:00 ] 125.122.33.96 GET jx.t20.site/ [ sql ] [ DB ] CONNECT:[ UseTime:0.002756s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.003114s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `type` = 'menu' AND `nickname` = '/' LIMIT 1 [ RunTime:0.001293s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.003785s ] [ sql ] [ SQL ] SELECT `id`,`type_id`,`tag_id`,`title`,`icon`,`extr_info`,`keywords`,`description`,`create_time`,`update_time`,`is_hot`,`status` FROM `fa_post` WHERE `type_id` = 31 AND `status` = 1 ORDER BY `is_hot` DESC,`update_time` DESC LIMIT 0,8 [ RunTime:0.001470s ] [ sql ] [ SQL ] SELECT `id`,`type_id`,`tag_id`,`title`,`icon`,`extr_info`,`keywords`,`description`,`create_time`,`update_time`,`is_hot`,`status` FROM `fa_post` WHERE `type_id` = 29 AND `status` = 1 ORDER BY `is_hot` DESC,`update_time` DESC LIMIT 0,12 [ RunTime:0.001326s ] [ sql ] [ SQL ] SELECT `id`,`type_id`,`tag_id`,`title`,`icon`,`extr_info`,`keywords`,`description`,`create_time`,`update_time`,`is_hot`,`status` FROM `fa_post` WHERE `type_id` = 30 AND `status` = 1 ORDER BY `is_hot` DESC,`update_time` DESC LIMIT 0,12 [ RunTime:0.001276s ] [ sql ] [ SQL ] SELECT `id`,`type_id`,`tag_id`,`title`,`icon`,`extr_info`,`keywords`,`description`,`create_time`,`update_time`,`is_hot`,`status` FROM `fa_post` WHERE `type_id` = 32 AND `status` = 1 ORDER BY `is_hot` DESC,`update_time` DESC LIMIT 0,12 [ RunTime:0.001601s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.002668s ] [ sql ] [ SQL ] SELECT `id`,`type_id`,`tag_id`,`title`,`description`,`name`,`icon`,`extr_info`,`create_time`,`update_time`,`sale_status` FROM `fa_yewu` WHERE `status` = 1 ORDER BY `weight` DESC,`update_time` DESC LIMIT 0,12 [ RunTime:0.001285s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE ( `type` = 'yewu_type' AND `status` = 'normal' ) ORDER BY `weigh` DESC [ RunTime:0.001213s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'menu' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001277s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'banner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001472s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_link` [ RunTime:0.003124s ] [ sql ] [ SQL ] SELECT `name`,`url` FROM `fa_link` WHERE `status` = 1 AND `expired_time` > '2025-04-25 07:19:16' ORDER BY `weight` DESC [ RunTime:0.001170s ] [ sql ] [ SQL ] SELECT `id`,`type_id`,`tag_id`,`title`,`description`,`name`,`icon`,`extr_info`,`create_time`,`update_time`,`sale_status` FROM `fa_yewu` WHERE `status` = 1 ORDER BY `weight` DESC,`update_time` DESC LIMIT 0,6 [ RunTime:0.002501s ] [ sql ] [ SQL ] SELECT `id`,`type_id`,`tag_id`,`title`,`icon`,`extr_info`,`keywords`,`description`,`create_time`,`update_time`,`is_hot`,`status` FROM `fa_post` WHERE `type_id` = 32 AND `status` = 1 ORDER BY `is_hot` DESC,`update_time` DESC LIMIT 0,6 [ RunTime:0.001557s ] [ info ] Yewu where数据{"status":1} [ info ] Yewu where数据{"status":1} --------------------------------------------------------------- [ 2025-04-25T07:19:17+08:00 ] 125.122.33.96 GET jx.t20.site/ [ sql ] [ DB ] CONNECT:[ UseTime:0.002161s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.003070s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `type` = 'menu' AND `nickname` = '/' LIMIT 1 [ RunTime:0.002565s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.004476s ] [ sql ] [ SQL ] SELECT `id`,`type_id`,`tag_id`,`title`,`icon`,`extr_info`,`keywords`,`description`,`create_time`,`update_time`,`is_hot`,`status` FROM `fa_post` WHERE `type_id` = 31 AND `status` = 1 ORDER BY `is_hot` DESC,`update_time` DESC LIMIT 0,8 [ RunTime:0.001621s ] [ sql ] [ SQL ] SELECT `id`,`type_id`,`tag_id`,`title`,`icon`,`extr_info`,`keywords`,`description`,`create_time`,`update_time`,`is_hot`,`status` FROM `fa_post` WHERE `type_id` = 29 AND `status` = 1 ORDER BY `is_hot` DESC,`update_time` DESC LIMIT 0,12 [ RunTime:0.001460s ] [ sql ] [ SQL ] SELECT `id`,`type_id`,`tag_id`,`title`,`icon`,`extr_info`,`keywords`,`description`,`create_time`,`update_time`,`is_hot`,`status` FROM `fa_post` WHERE `type_id` = 30 AND `status` = 1 ORDER BY `is_hot` DESC,`update_time` DESC LIMIT 0,12 [ RunTime:0.001411s ] [ sql ] [ SQL ] SELECT `id`,`type_id`,`tag_id`,`title`,`icon`,`extr_info`,`keywords`,`description`,`create_time`,`update_time`,`is_hot`,`status` FROM `fa_post` WHERE `type_id` = 32 AND `status` = 1 ORDER BY `is_hot` DESC,`update_time` DESC LIMIT 0,12 [ RunTime:0.001654s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.003021s ] [ sql ] [ SQL ] SELECT `id`,`type_id`,`tag_id`,`title`,`description`,`name`,`icon`,`extr_info`,`create_time`,`update_time`,`sale_status` FROM `fa_yewu` WHERE `status` = 1 ORDER BY `weight` DESC,`update_time` DESC LIMIT 0,12 [ RunTime:0.001473s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE ( `type` = 'yewu_type' AND `status` = 'normal' ) ORDER BY `weigh` DESC [ RunTime:0.001154s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'menu' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001149s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'banner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001414s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_link` [ RunTime:0.002693s ] [ sql ] [ SQL ] SELECT `name`,`url` FROM `fa_link` WHERE `status` = 1 AND `expired_time` > '2025-04-25 07:19:17' ORDER BY `weight` DESC [ RunTime:0.001391s ] [ sql ] [ SQL ] SELECT `id`,`type_id`,`tag_id`,`title`,`description`,`name`,`icon`,`extr_info`,`create_time`,`update_time`,`sale_status` FROM `fa_yewu` WHERE `status` = 1 ORDER BY `weight` DESC,`update_time` DESC LIMIT 0,6 [ RunTime:0.000922s ] [ sql ] [ SQL ] SELECT `id`,`type_id`,`tag_id`,`title`,`icon`,`extr_info`,`keywords`,`description`,`create_time`,`update_time`,`is_hot`,`status` FROM `fa_post` WHERE `type_id` = 32 AND `status` = 1 ORDER BY `is_hot` DESC,`update_time` DESC LIMIT 0,6 [ RunTime:0.001381s ] [ info ] Yewu where数据{"status":1} [ info ] Yewu where数据{"status":1} --------------------------------------------------------------- [ 2025-04-25T08:19:08+08:00 ] 120.55.55.92 POST jx.t20.site/api/index/getGlobalInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.003431s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_user_token` [ RunTime:0.004339s ] [ sql ] [ SQL ] SELECT * FROM `fa_user_token` WHERE `token` = '50efd3c0c727e66bb6d42e26d768b26ab0311eca' LIMIT 1 [ RunTime:0.001840s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.006736s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `fa_category` WHERE `type` = 'yewu_type' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.004523s ] --------------------------------------------------------------- [ 2025-04-25T08:19:08+08:00 ] 120.55.55.92 POST jx.t20.site/api/index/index [ sql ] [ DB ] CONNECT:[ UseTime:0.003345s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_user_token` [ RunTime:0.004340s ] [ sql ] [ SQL ] SELECT * FROM `fa_user_token` WHERE `token` = '50efd3c0c727e66bb6d42e26d768b26ab0311eca' LIMIT 1 [ RunTime:0.004572s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.005062s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'mbanner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.005862s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.005382s ] [ sql ] [ SQL ] SELECT `id`,`type_id`,`tag_id`,`title`,`icon`,`extr_info`,`keywords`,`description`,`create_time`,`update_time`,`is_hot`,`status` FROM `fa_post` WHERE `type_id` = 31 AND `status` = 1 ORDER BY `is_hot` DESC,`update_time` DESC LIMIT 0,8 [ RunTime:0.003375s ] [ sql ] [ SQL ] SELECT `id`,`type_id`,`tag_id`,`title`,`icon`,`extr_info`,`keywords`,`description`,`create_time`,`update_time`,`is_hot`,`status` FROM `fa_post` WHERE `type_id` = 32 AND `status` = 1 ORDER BY `is_hot` DESC,`update_time` DESC LIMIT 0,6 [ RunTime:0.003987s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.002924s ] [ sql ] [ SQL ] SELECT `id`,`type_id`,`tag_id`,`title`,`description`,`name`,`icon`,`extr_info`,`create_time`,`update_time`,`sale_status` FROM `fa_yewu` WHERE `status` = 1 ORDER BY `weight` DESC,`update_time` DESC LIMIT 0,8 [ RunTime:0.001501s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_tag` [ RunTime:0.003002s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `fa_tag` WHERE `id` IN (14,25,29,32,31,33,27,26) [ RunTime:0.000963s ] [ info ] 获取业务分类列表 typeId[0] tagId[0] limit[8] [ info ] array ( ) [ info ] Yewu where数据{"status":1}