--------------------------------------------------------------- [ 2025-05-18T07:07:21+08:00 ] 123.52.173.36 GET jx.t20.site/ [ sql ] [ DB ] CONNECT:[ UseTime:0.003049s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.002797s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `type` = 'menu' AND `nickname` = '/' LIMIT 1 [ RunTime:0.001250s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.002524s ] [ 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.001441s ] [ 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.001367s ] [ 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.001143s ] [ 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.001280s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.002824s ] [ 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.001162s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE ( `type` = 'yewu_type' AND `status` = 'normal' ) ORDER BY `weigh` DESC [ RunTime:0.001242s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'menu' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001186s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'banner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001235s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_link` [ RunTime:0.003024s ] [ sql ] [ SQL ] SELECT `name`,`url` FROM `fa_link` WHERE `status` = 1 AND `expired_time` > '2025-05-18 07:07:21' ORDER BY `weight` DESC [ RunTime:0.001230s ] [ 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.001266s ] [ 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.001131s ] [ info ] Yewu where数据{"status":1} [ info ] Yewu where数据{"status":1} --------------------------------------------------------------- [ 2025-05-18T07:32:07+08:00 ] 112.111.159.216 GET jx.t20.site/ [ sql ] [ DB ] CONNECT:[ UseTime:0.002214s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.002899s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `type` = 'menu' AND `nickname` = '/' LIMIT 1 [ RunTime:0.001358s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.002874s ] [ 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.001504s ] [ 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.000959s ] [ 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.000970s ] [ 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.001264s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.002910s ] [ 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.001364s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE ( `type` = 'yewu_type' AND `status` = 'normal' ) ORDER BY `weigh` DESC [ RunTime:0.001110s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'menu' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001222s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'banner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000882s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_link` [ RunTime:0.003103s ] [ sql ] [ SQL ] SELECT `name`,`url` FROM `fa_link` WHERE `status` = 1 AND `expired_time` > '2025-05-18 07:32:07' ORDER BY `weight` DESC [ RunTime:0.001521s ] [ 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.001193s ] [ 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.001543s ] [ info ] Yewu where数据{"status":1} [ info ] Yewu where数据{"status":1} --------------------------------------------------------------- [ 2025-05-18T12:01:59+08:00 ] 125.122.33.107 GET jx.t20.site/ [ sql ] [ DB ] CONNECT:[ UseTime:0.002603s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.003135s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `type` = 'menu' AND `nickname` = '/' LIMIT 1 [ RunTime:0.001249s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.002827s ] [ 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.002408s ] [ 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.001569s ] [ 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.001440s ] [ 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.001499s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.002605s ] [ 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.001767s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE ( `type` = 'yewu_type' AND `status` = 'normal' ) ORDER BY `weigh` DESC [ RunTime:0.001461s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'menu' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001368s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'banner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001049s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_link` [ RunTime:0.002796s ] [ sql ] [ SQL ] SELECT `name`,`url` FROM `fa_link` WHERE `status` = 1 AND `expired_time` > '2025-05-18 12:01:59' ORDER BY `weight` DESC [ RunTime:0.001613s ] [ 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.001152s ] [ 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.001367s ] [ info ] Yewu where数据{"status":1} [ info ] Yewu where数据{"status":1} --------------------------------------------------------------- [ 2025-05-18T12:02:04+08:00 ] 125.122.33.107 GET jx.t20.site/ [ sql ] [ DB ] CONNECT:[ UseTime:0.002470s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.003009s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `type` = 'menu' AND `nickname` = '/' LIMIT 1 [ RunTime:0.001344s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.002924s ] [ 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.001457s ] [ 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.001191s ] [ 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.001277s ] [ 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.001514s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.002777s ] [ 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.001387s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE ( `type` = 'yewu_type' AND `status` = 'normal' ) ORDER BY `weigh` DESC [ RunTime:0.001252s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'menu' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001333s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'banner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001281s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_link` [ RunTime:0.002753s ] [ sql ] [ SQL ] SELECT `name`,`url` FROM `fa_link` WHERE `status` = 1 AND `expired_time` > '2025-05-18 12:02:04' ORDER BY `weight` DESC [ RunTime:0.001439s ] [ 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.001212s ] [ 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.001765s ] [ info ] Yewu where数据{"status":1} [ info ] Yewu where数据{"status":1} --------------------------------------------------------------- [ 2025-05-18T13:18:30+08:00 ] 120.55.55.92 POST jx.t20.site/api/index/getGlobalInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.006015s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_user_token` [ RunTime:0.005096s ] [ sql ] [ SQL ] SELECT * FROM `fa_user_token` WHERE `token` = '50efd3c0c727e66bb6d42e26d768b26ab0311eca' LIMIT 1 [ RunTime:0.002354s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.004635s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `fa_category` WHERE `type` = 'yewu_type' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.002000s ] --------------------------------------------------------------- [ 2025-05-18T13:18:30+08:00 ] 120.55.55.92 POST jx.t20.site/api/index/index [ sql ] [ DB ] CONNECT:[ UseTime:0.003905s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_user_token` [ RunTime:0.004807s ] [ sql ] [ SQL ] SELECT * FROM `fa_user_token` WHERE `token` = '50efd3c0c727e66bb6d42e26d768b26ab0311eca' LIMIT 1 [ RunTime:0.002231s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.005098s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'mbanner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.003109s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.004367s ] [ 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.001682s ] [ 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.002598s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.004602s ] [ 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.002482s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_tag` [ RunTime:0.002331s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `fa_tag` WHERE `id` IN (14,25,29,32,31,33,27,26) [ RunTime:0.001075s ] [ info ] 获取业务分类列表 typeId[0] tagId[0] limit[8] [ info ] array ( ) [ info ] Yewu where数据{"status":1}