--------------------------------------------------------------- [ 2025-05-28T04:30:17+08:00 ] 125.122.33.83 GET jx.t20.site/ [ sql ] [ DB ] CONNECT:[ UseTime:0.003430s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.003075s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `type` = 'menu' AND `nickname` = '/' LIMIT 1 [ RunTime:0.001146s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.002720s ] [ 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.001146s ] [ 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.003686s ] [ 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.003618s ] [ 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.003180s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.003375s ] [ 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.001474s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE ( `type` = 'yewu_type' AND `status` = 'normal' ) ORDER BY `weigh` DESC [ RunTime:0.001278s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'menu' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001667s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'banner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001529s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_link` [ RunTime:0.002714s ] [ sql ] [ SQL ] SELECT `name`,`url` FROM `fa_link` WHERE `status` = 1 AND `expired_time` > '2025-05-28 04:30:17' ORDER BY `weight` DESC [ RunTime:0.001156s ] [ 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.001338s ] [ 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.001807s ] [ info ] Yewu where数据{"status":1} [ info ] Yewu where数据{"status":1} --------------------------------------------------------------- [ 2025-05-28T05:45:06+08:00 ] 120.55.55.92 POST jx.t20.site/api/index/getGlobalInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.003378s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_user_token` [ RunTime:0.006971s ] [ sql ] [ SQL ] SELECT * FROM `fa_user_token` WHERE `token` = '50efd3c0c727e66bb6d42e26d768b26ab0311eca' LIMIT 1 [ RunTime:0.002076s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.005810s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `fa_category` WHERE `type` = 'yewu_type' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.002780s ] --------------------------------------------------------------- [ 2025-05-28T05:45:06+08:00 ] 120.55.55.92 POST jx.t20.site/api/index/index [ sql ] [ DB ] CONNECT:[ UseTime:0.003403s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_user_token` [ RunTime:0.003912s ] [ sql ] [ SQL ] SELECT * FROM `fa_user_token` WHERE `token` = '50efd3c0c727e66bb6d42e26d768b26ab0311eca' LIMIT 1 [ RunTime:0.002420s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.006861s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'mbanner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.002615s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.005243s ] [ 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.002682s ] [ 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.003630s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.006447s ] [ 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.001746s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_tag` [ RunTime:0.003091s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `fa_tag` WHERE `id` IN (14,25,29,32,31,33,27,26) [ RunTime:0.001189s ] [ info ] 获取业务分类列表 typeId[0] tagId[0] limit[8] [ info ] array ( ) [ info ] Yewu where数据{"status":1}