--------------------------------------------------------------- [ 2025-11-13T18:17:26+08:00 ] 59.82.135.147 GET jx.t20.site/ [ sql ] [ DB ] CONNECT:[ UseTime:0.001229s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.001552s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `type` = 'menu' AND `nickname` = '/' LIMIT 1 [ RunTime:0.000414s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.001262s ] [ 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.000424s ] [ 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.000402s ] [ 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.000654s ] [ 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.000310s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.001063s ] [ 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.000379s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE ( `type` = 'yewu_type' AND `status` = 'normal' ) ORDER BY `weigh` DESC [ RunTime:0.000337s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'menu' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000621s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'banner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000403s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_link` [ RunTime:0.001715s ] [ sql ] [ SQL ] SELECT `name`,`url` FROM `fa_link` WHERE `status` = 1 AND `expired_time` > '2025-11-13 18:17:26' ORDER BY `weight` DESC [ RunTime:0.000557s ] [ 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.000578s ] [ 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.000516s ] [ info ] Yewu where数据{"status":1} [ info ] Yewu where数据{"status":1} --------------------------------------------------------------- [ 2025-11-13T18:17:26+08:00 ] 59.82.135.147 GET jx.t20.site/ [ sql ] [ DB ] CONNECT:[ UseTime:0.001404s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.001397s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `type` = 'menu' AND `nickname` = '/' LIMIT 1 [ RunTime:0.000812s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.001216s ] [ 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.000436s ] [ 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.000344s ] [ 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.000318s ] [ 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.000288s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.001538s ] [ 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.000391s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE ( `type` = 'yewu_type' AND `status` = 'normal' ) ORDER BY `weigh` DESC [ RunTime:0.000449s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'menu' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000769s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'banner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000330s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_link` [ RunTime:0.001375s ] [ sql ] [ SQL ] SELECT `name`,`url` FROM `fa_link` WHERE `status` = 1 AND `expired_time` > '2025-11-13 18:17:26' ORDER BY `weight` DESC [ RunTime:0.000311s ] [ 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.000479s ] [ 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.000386s ] [ info ] Yewu where数据{"status":1} [ info ] Yewu where数据{"status":1} --------------------------------------------------------------- [ 2025-11-13T18:17:27+08:00 ] 59.82.135.147 GET jx.t20.site/yewu_list/27.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001261s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.001288s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `type` = 'menu' AND `nickname` = 'yewu_list' LIMIT 1 [ RunTime:0.000319s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `id` = 27 LIMIT 1 [ RunTime:0.000373s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.001455s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_yewu` WHERE `type_id` IN (0,27) AND `status` = 1 LIMIT 1 [ RunTime:0.000385s ] [ sql ] [ SQL ] SELECT `id`,`type_id`,`tag_id`,`title`,`description`,`name`,`icon`,`extr_info`,`create_time`,`update_time`,`sale_status` FROM `fa_yewu` WHERE `type_id` IN (0,27) AND `status` = 1 ORDER BY `weight` DESC,`update_time` DESC LIMIT 0,10 [ RunTime:0.000387s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post_tag` [ RunTime:0.001464s ] [ sql ] [ SQL ] SELECT `tag`.`id`,`tag`.`name` FROM fa_post_tag as pt LEFT JOIN `fa_tag` `tag` ON `pt`.`tag_id`=`tag`.`id` WHERE `tag`.`status` = 1 AND `pt`.`yewu_id` > 0 ORDER BY `tag`.`is_hot` DESC,`tag`.`update_time` DESC LIMIT 0,100 [ RunTime:0.001982s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'menu' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000777s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'banner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000851s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE ( `type` = 'yewu_type' AND `status` = 'normal' ) ORDER BY `weigh` DESC [ RunTime:0.000538s ] [ 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.000570s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_link` [ RunTime:0.001231s ] [ sql ] [ SQL ] SELECT `name`,`url` FROM `fa_link` WHERE `status` = 1 AND `expired_time` > '2025-11-13 18:17:27' ORDER BY `weight` DESC [ RunTime:0.000319s ] [ 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.000449s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.001611s ] [ 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.000511s ] [ info ] yewu_list id[27] tagId[0] [ info ] yewu_type row {"id":27,"title":"\u56de\u8f6c\u7a91\u5b89\u88c5|\u6c34\u6ce5\u56de\u8f6c\u7a91|\u77f3\u7070\u56de\u8f6c\u7a91|\u6c27\u5316\u950c\u56de\u8f6c\u7a91|\u51b6\u91d1\u56de\u8f6c\u7a91|\u56fa\u5e9f\u711a\u70e7\u7a91","pid":0,"type":"yewu_type","name":"\u56de\u8f6c\u7a91","nickname":"\u56de\u8f6c\u7a91","flag":"","image":"","keywords":"\u56de\u8f6c\u7a91,\u6c34\u6ce5\u56de\u8f6c\u7a91,\u77f3\u7070\u56de\u8f6c\u7a91,\u6c27\u5316\u950c\u56de\u8f6c\u7a91,\u51b6\u91d1\u56de\u8f6c\u7a91,\u56fa\u5e9f\u711a\u70e7\u7a91","description":"\u6c47\u5ddd\u673a\u68b0\u627f\u63a5\u5404\u7c7b\u578b\u5de5\u4e1a\u7089\u7a91\u8bbe\u5907\u5982\u6c34\u6ce5\u56de\u8f6c\u7a91\uff0c\u77f3\u7070\u56de\u8f6c\u7a91\uff0c\u6c27\u5316\u950c\u56de\u8f6c\u7a91\uff0c\u51b6\u91d1\u56de\u8f6c\u7a91\uff0c\u56fa\u5e9f\u711a\u70e7\u7a91\u7684\u9500\u552e\u4e0e\u5b89\u88c5\u3001\u5de5\u827a\u6d41\u7a0b\u8bbe\u8ba1\u4e1a\u52a1\u3002","diyname":"","createtime":1669369318,"updatetime":1676815329,"weigh":90,"status":"normal","type_text":"\u4e1a\u52a1\u7c7b\u578b","flag_text":""} [ info ] 获取业务分类列表分页 typeId[27] tagId[0] page[10] [ info ] Yewu list paginate where数据{"status":1} [ info ] Yewu where数据{"status":1} [ info ] Yewu where数据{"status":1} --------------------------------------------------------------- [ 2025-11-13T18:17:28+08:00 ] 59.82.135.147 GET jx.t20.site/ [ sql ] [ DB ] CONNECT:[ UseTime:0.001332s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.001560s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `type` = 'menu' AND `nickname` = '/' LIMIT 1 [ RunTime:0.000351s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.001133s ] [ 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.000334s ] [ 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.000669s ] [ 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.000256s ] [ 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.000328s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.001208s ] [ 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.000415s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE ( `type` = 'yewu_type' AND `status` = 'normal' ) ORDER BY `weigh` DESC [ RunTime:0.000484s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'menu' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000636s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'banner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000327s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_link` [ RunTime:0.001861s ] [ sql ] [ SQL ] SELECT `name`,`url` FROM `fa_link` WHERE `status` = 1 AND `expired_time` > '2025-11-13 18:17:28' ORDER BY `weight` DESC [ RunTime:0.000390s ] [ 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.000441s ] [ 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.000435s ] [ info ] Yewu where数据{"status":1} [ info ] Yewu where数据{"status":1} --------------------------------------------------------------- [ 2025-11-13T18:17:28+08:00 ] 59.82.135.147 GET jx.t20.site/yewu_list/28.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001539s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.001398s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `type` = 'menu' AND `nickname` = 'yewu_list' LIMIT 1 [ RunTime:0.000418s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `id` = 28 LIMIT 1 [ RunTime:0.000368s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.001723s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_yewu` WHERE `type_id` IN (0,28) AND `status` = 1 LIMIT 1 [ RunTime:0.000343s ] [ sql ] [ SQL ] SELECT `id`,`type_id`,`tag_id`,`title`,`description`,`name`,`icon`,`extr_info`,`create_time`,`update_time`,`sale_status` FROM `fa_yewu` WHERE `type_id` IN (0,28) AND `status` = 1 ORDER BY `weight` DESC,`update_time` DESC LIMIT 0,10 [ RunTime:0.000413s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post_tag` [ RunTime:0.001176s ] [ sql ] [ SQL ] SELECT `tag`.`id`,`tag`.`name` FROM fa_post_tag as pt LEFT JOIN `fa_tag` `tag` ON `pt`.`tag_id`=`tag`.`id` WHERE `tag`.`status` = 1 AND `pt`.`yewu_id` > 0 ORDER BY `tag`.`is_hot` DESC,`tag`.`update_time` DESC LIMIT 0,100 [ RunTime:0.000599s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'menu' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000431s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'banner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000517s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE ( `type` = 'yewu_type' AND `status` = 'normal' ) ORDER BY `weigh` DESC [ RunTime:0.000337s ] [ 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.000565s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_link` [ RunTime:0.001147s ] [ sql ] [ SQL ] SELECT `name`,`url` FROM `fa_link` WHERE `status` = 1 AND `expired_time` > '2025-11-13 18:17:28' ORDER BY `weight` DESC [ RunTime:0.000425s ] [ 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.000366s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.001122s ] [ 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.000596s ] [ info ] yewu_list id[28] tagId[0] [ info ] yewu_type row {"id":28,"title":"\u9009\u77ff\u8bbe\u5907234","pid":0,"type":"yewu_type","name":"\u9009\u77ff\u8bbe\u5907","nickname":"\u9009\u77ff\u8bbe\u5907","flag":"","image":"","keywords":"\u673a\u68b0\u8bbe\u5907\uff0c\u4e8c\u624b\u8bbe\u5907\uff0c\u77ff\u5c71\u8bbe\u5907","description":"\u751f\u4ea7\u3001\u8bbe\u8ba1\u3001\u5236\u9020\u3001\u9500\u552e\u5404\u7c7b\u5168\u65b0\u53ca\u4e8c\u624b\u673a\u68b0\u77ff\u5c71\u8bbe\u5907\uff0c\u7403\u78e8\u673a\u3001\u70d8\u5e72\u673a\u3001\u56de\u8f6c\u7a91\u3001\u5de5\u4e1a\u7089\u7a91\u3001\u7834\u788e\u673a\u3001\u632f\u52a8\u7b5b\u3001\u5236\u7802\u673a\u3001\u4e0a\u6599\u673a\u3001\u8f93\u9001\u673a\u3001\u914d\u6599\u8bbe\u5907\u7b49\u3002","diyname":"","createtime":1669369364,"updatetime":1676814758,"weigh":80,"status":"normal","type_text":"\u4e1a\u52a1\u7c7b\u578b","flag_text":""} [ info ] 获取业务分类列表分页 typeId[28] tagId[0] page[10] [ info ] Yewu list paginate where数据{"status":1} [ info ] Yewu where数据{"status":1} [ info ] Yewu where数据{"status":1} --------------------------------------------------------------- [ 2025-11-13T18:17:28+08:00 ] 59.82.135.147 GET jx.t20.site/ [ sql ] [ DB ] CONNECT:[ UseTime:0.001355s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.001657s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `type` = 'menu' AND `nickname` = '/' LIMIT 1 [ RunTime:0.000363s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.001418s ] [ 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.000425s ] [ 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.000327s ] [ 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.000444s ] [ 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.000362s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.001020s ] [ 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.000335s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE ( `type` = 'yewu_type' AND `status` = 'normal' ) ORDER BY `weigh` DESC [ RunTime:0.000295s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'menu' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000470s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'banner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000259s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_link` [ RunTime:0.002150s ] [ sql ] [ SQL ] SELECT `name`,`url` FROM `fa_link` WHERE `status` = 1 AND `expired_time` > '2025-11-13 18:17:28' ORDER BY `weight` DESC [ RunTime:0.000443s ] [ 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.000451s ] [ 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.000398s ] [ info ] Yewu where数据{"status":1} [ info ] Yewu where数据{"status":1} --------------------------------------------------------------- [ 2025-11-13T18:17:28+08:00 ] 59.82.135.147 GET jx.t20.site/yewu_list/36.html [ sql ] [ DB ] CONNECT:[ UseTime:0.001318s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.001722s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `type` = 'menu' AND `nickname` = 'yewu_list' LIMIT 1 [ RunTime:0.000522s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `id` = 36 LIMIT 1 [ RunTime:0.000436s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.001545s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_yewu` WHERE `type_id` IN (0,36) AND `status` = 1 LIMIT 1 [ RunTime:0.000398s ] [ sql ] [ SQL ] SELECT `id`,`type_id`,`tag_id`,`title`,`description`,`name`,`icon`,`extr_info`,`create_time`,`update_time`,`sale_status` FROM `fa_yewu` WHERE `type_id` IN (0,36) AND `status` = 1 ORDER BY `weight` DESC,`update_time` DESC LIMIT 0,10 [ RunTime:0.000827s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post_tag` [ RunTime:0.001329s ] [ sql ] [ SQL ] SELECT `tag`.`id`,`tag`.`name` FROM fa_post_tag as pt LEFT JOIN `fa_tag` `tag` ON `pt`.`tag_id`=`tag`.`id` WHERE `tag`.`status` = 1 AND `pt`.`yewu_id` > 0 ORDER BY `tag`.`is_hot` DESC,`tag`.`update_time` DESC LIMIT 0,100 [ RunTime:0.000644s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'menu' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000572s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'banner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000335s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE ( `type` = 'yewu_type' AND `status` = 'normal' ) ORDER BY `weigh` DESC [ RunTime:0.000404s ] [ 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.000428s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_link` [ RunTime:0.001511s ] [ sql ] [ SQL ] SELECT `name`,`url` FROM `fa_link` WHERE `status` = 1 AND `expired_time` > '2025-11-13 18:17:28' ORDER BY `weight` DESC [ RunTime:0.000357s ] [ 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.000365s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.001094s ] [ 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.000394s ] [ info ] yewu_list id[36] tagId[0] [ info ] yewu_type row {"id":36,"title":"\u673a\u68b0\u8bbe\u5907","pid":0,"type":"yewu_type","name":"\u673a\u68b0\u8bbe\u5907","nickname":"\u673a\u68b0\u8bbe\u5907","flag":"","image":"","keywords":"\u4e8c\u624b\u673a\u68b0\u8bbe\u5907\uff0c\u9009\u77ff\u8bbe\u5907\uff0c\u70d8\u5e72\u8bbe\u5907\uff0c\u7834\u788e\u8bbe\u5907","description":"\u9500\u552e\u5404\u7c7b\u4e8c\u624b\u673a\u68b0\u8bbe\u5907\uff0c\u9009\u77ff\u8bbe\u5907\uff0c\u70d8\u5e72\u8bbe\u5907\uff0c\u7834\u788e\u8bbe\u5907","diyname":"","createtime":1676366009,"updatetime":1676802673,"weigh":70,"status":"normal","type_text":"\u4e1a\u52a1\u7c7b\u578b","flag_text":""} [ info ] 获取业务分类列表分页 typeId[36] tagId[0] page[10] [ info ] Yewu list paginate where数据{"status":1} [ info ] Yewu where数据{"status":1} [ info ] Yewu where数据{"status":1} --------------------------------------------------------------- [ 2025-11-13T18:17:28+08:00 ] 59.82.135.147 GET jx.t20.site/ [ sql ] [ DB ] CONNECT:[ UseTime:0.001529s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.001720s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `type` = 'menu' AND `nickname` = '/' LIMIT 1 [ RunTime:0.000666s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.001404s ] [ 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.000508s ] [ 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.000388s ] [ 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.000328s ] [ 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.000374s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.001600s ] [ 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.000518s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE ( `type` = 'yewu_type' AND `status` = 'normal' ) ORDER BY `weigh` DESC [ RunTime:0.000388s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'menu' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000552s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'banner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000737s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_link` [ RunTime:0.001696s ] [ sql ] [ SQL ] SELECT `name`,`url` FROM `fa_link` WHERE `status` = 1 AND `expired_time` > '2025-11-13 18:17:28' ORDER BY `weight` DESC [ RunTime:0.000370s ] [ 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.000395s ] [ 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.000377s ] [ info ] Yewu where数据{"status":1} [ info ] Yewu where数据{"status":1} --------------------------------------------------------------- [ 2025-11-13T23:27:07+08:00 ] 120.55.55.92 POST jx.t20.site/api/index/getGlobalInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.001342s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_user_token` [ RunTime:0.001308s ] [ sql ] [ SQL ] SELECT * FROM `fa_user_token` WHERE `token` = '50efd3c0c727e66bb6d42e26d768b26ab0311eca' LIMIT 1 [ RunTime:0.000413s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.001425s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `fa_category` WHERE `type` = 'yewu_type' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000497s ] --------------------------------------------------------------- [ 2025-11-13T23:27:07+08:00 ] 120.55.55.92 POST jx.t20.site/api/index/index [ sql ] [ DB ] CONNECT:[ UseTime:0.001342s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_user_token` [ RunTime:0.001385s ] [ sql ] [ SQL ] SELECT * FROM `fa_user_token` WHERE `token` = '50efd3c0c727e66bb6d42e26d768b26ab0311eca' LIMIT 1 [ RunTime:0.000425s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.001523s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'mbanner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000345s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.000962s ] [ 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.000349s ] [ 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.000331s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.001070s ] [ 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.000478s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_tag` [ RunTime:0.001020s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `fa_tag` WHERE `id` IN (14,25,29,32,31,33,27,26) [ RunTime:0.000431s ] [ info ] 获取业务分类列表 typeId[0] tagId[0] limit[8] [ info ] array ( ) [ info ] Yewu where数据{"status":1}