--------------------------------------------------------------- [ 2025-02-24T13:33:33+08:00 ] 110.248.61.90 GET jx.t20.site/ [ sql ] [ DB ] CONNECT:[ UseTime:0.002902s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.002519s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `type` = 'menu' AND `nickname` = '/' LIMIT 1 [ RunTime:0.001247s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.002639s ] [ 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.001304s ] [ 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.001245s ] [ 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.000947s ] [ 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.001130s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.002258s ] [ 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.001013s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE ( `type` = 'yewu_type' AND `status` = 'normal' ) ORDER BY `weigh` DESC [ RunTime:0.001206s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'menu' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000938s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'banner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000771s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_link` [ RunTime:0.002260s ] [ sql ] [ SQL ] SELECT `name`,`url` FROM `fa_link` WHERE `status` = 1 AND `expired_time` > '2025-02-24 13:33:33' ORDER BY `weight` DESC [ RunTime:0.001193s ] [ 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.001332s ] [ 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.001044s ] [ info ] Yewu where数据{"status":1} [ info ] Yewu where数据{"status":1} --------------------------------------------------------------- [ 2025-02-24T14:27:54+08:00 ] 113.215.188.67 GET jx.t20.site/ [ sql ] [ DB ] CONNECT:[ UseTime:0.001995s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.002646s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `type` = 'menu' AND `nickname` = '/' LIMIT 1 [ RunTime:0.000979s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.002709s ] [ 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.001263s ] [ 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.000986s ] [ 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.001070s ] [ 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.001054s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.002349s ] [ 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.001145s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE ( `type` = 'yewu_type' AND `status` = 'normal' ) ORDER BY `weigh` DESC [ RunTime:0.001045s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'menu' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001295s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'banner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001222s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_link` [ RunTime:0.004433s ] [ sql ] [ SQL ] SELECT `name`,`url` FROM `fa_link` WHERE `status` = 1 AND `expired_time` > '2025-02-24 14:27:54' ORDER BY `weight` DESC [ RunTime:0.001019s ] [ 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.000886s ] [ 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.000977s ] [ info ] Yewu where数据{"status":1} [ info ] Yewu where数据{"status":1} --------------------------------------------------------------- [ 2025-02-24T14:27:54+08:00 ] 113.215.188.67 GET jx.t20.site/ [ sql ] [ DB ] CONNECT:[ UseTime:0.002168s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.002515s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `type` = 'menu' AND `nickname` = '/' LIMIT 1 [ RunTime:0.001284s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.002350s ] [ 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.001235s ] [ 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.001125s ] [ 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.000986s ] [ 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.001669s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.002606s ] [ 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.001175s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE ( `type` = 'yewu_type' AND `status` = 'normal' ) ORDER BY `weigh` DESC [ RunTime:0.001148s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'menu' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001162s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'banner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.000907s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_link` [ RunTime:0.002453s ] [ sql ] [ SQL ] SELECT `name`,`url` FROM `fa_link` WHERE `status` = 1 AND `expired_time` > '2025-02-24 14:27:54' ORDER BY `weight` DESC [ RunTime:0.001489s ] [ 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.001140s ] [ 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.001088s ] [ info ] Yewu where数据{"status":1} [ info ] Yewu where数据{"status":1} --------------------------------------------------------------- [ 2025-02-24T14:28:10+08:00 ] 113.215.188.67 GET jx.t20.site/yewu_list/27.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002068s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.002895s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `type` = 'menu' AND `nickname` = 'yewu_list' LIMIT 1 [ RunTime:0.001376s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `id` = 27 LIMIT 1 [ RunTime:0.001213s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.003021s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_yewu` WHERE `type_id` IN (0,27) AND `status` = 1 LIMIT 1 [ RunTime:0.002750s ] [ 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.000942s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post_tag` [ RunTime:0.002823s ] [ 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.004124s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'menu' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001133s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'banner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001163s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE ( `type` = 'yewu_type' AND `status` = 'normal' ) ORDER BY `weigh` DESC [ RunTime:0.001425s ] [ 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.001249s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_link` [ RunTime:0.002668s ] [ sql ] [ SQL ] SELECT `name`,`url` FROM `fa_link` WHERE `status` = 1 AND `expired_time` > '2025-02-24 14:28:10' ORDER BY `weight` DESC [ RunTime:0.001082s ] [ 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.000936s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.003358s ] [ 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.001443s ] [ 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-02-24T14:28:10+08:00 ] 113.215.188.67 GET jx.t20.site/ [ sql ] [ DB ] CONNECT:[ UseTime:0.002103s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.003704s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `type` = 'menu' AND `nickname` = '/' LIMIT 1 [ RunTime:0.001248s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.002456s ] [ 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.001184s ] [ 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.000954s ] [ 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.001054s ] [ 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.001282s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.003317s ] [ 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.001346s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE ( `type` = 'yewu_type' AND `status` = 'normal' ) ORDER BY `weigh` DESC [ RunTime:0.001177s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'menu' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001103s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'banner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001019s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_link` [ RunTime:0.002779s ] [ sql ] [ SQL ] SELECT `name`,`url` FROM `fa_link` WHERE `status` = 1 AND `expired_time` > '2025-02-24 14:28:10' ORDER BY `weight` DESC [ 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,6 [ RunTime:0.001144s ] [ 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.001571s ] [ info ] Yewu where数据{"status":1} [ info ] Yewu where数据{"status":1} --------------------------------------------------------------- [ 2025-02-24T14:28:10+08:00 ] 113.215.188.67 GET jx.t20.site/yewu_list/28.html [ sql ] [ DB ] CONNECT:[ UseTime:0.003253s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.004032s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `type` = 'menu' AND `nickname` = 'yewu_list' LIMIT 1 [ RunTime:0.002054s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `id` = 28 LIMIT 1 [ RunTime:0.001035s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.002804s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_yewu` WHERE `type_id` IN (0,28) AND `status` = 1 LIMIT 1 [ RunTime:0.001281s ] [ 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.001267s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post_tag` [ RunTime:0.003147s ] [ 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.001624s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'menu' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.002044s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'banner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001939s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE ( `type` = 'yewu_type' AND `status` = 'normal' ) ORDER BY `weigh` DESC [ RunTime:0.001616s ] [ 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.002486s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_link` [ RunTime:0.004074s ] [ sql ] [ SQL ] SELECT `name`,`url` FROM `fa_link` WHERE `status` = 1 AND `expired_time` > '2025-02-24 14:28:10' ORDER BY `weight` DESC [ RunTime:0.001214s ] [ 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.001147s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.002642s ] [ 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.001308s ] [ 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-02-24T14:28:10+08:00 ] 113.215.189.160 GET jx.t20.site/yewu_list/36.html [ sql ] [ DB ] CONNECT:[ UseTime:0.002235s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.009234s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `type` = 'menu' AND `nickname` = 'yewu_list' LIMIT 1 [ RunTime:0.005062s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `id` = 36 LIMIT 1 [ RunTime:0.001238s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.004394s ] [ sql ] [ SQL ] SELECT COUNT(*) AS tp_count FROM `fa_yewu` WHERE `type_id` IN (0,36) AND `status` = 1 LIMIT 1 [ RunTime:0.002315s ] [ 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.001671s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post_tag` [ RunTime:0.003653s ] [ 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.004379s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'menu' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.002000s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'banner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001438s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE ( `type` = 'yewu_type' AND `status` = 'normal' ) ORDER BY `weigh` DESC [ RunTime:0.002163s ] [ 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.001766s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_link` [ RunTime:0.005263s ] [ sql ] [ SQL ] SELECT `name`,`url` FROM `fa_link` WHERE `status` = 1 AND `expired_time` > '2025-02-24 14:28:10' ORDER BY `weight` DESC [ RunTime:0.001771s ] [ 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.002938s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.004836s ] [ 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.004011s ] [ 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-02-24T14:28:10+08:00 ] 113.215.188.67 GET jx.t20.site/ [ sql ] [ DB ] CONNECT:[ UseTime:0.005103s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.004441s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `type` = 'menu' AND `nickname` = '/' LIMIT 1 [ RunTime:0.002186s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.004499s ] [ 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.001865s ] [ 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.002154s ] [ 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.004376s ] [ 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.001307s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.002520s ] [ 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.001018s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE ( `type` = 'yewu_type' AND `status` = 'normal' ) ORDER BY `weigh` DESC [ RunTime:0.001050s ] [ 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.000901s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_link` [ RunTime:0.002221s ] [ sql ] [ SQL ] SELECT `name`,`url` FROM `fa_link` WHERE `status` = 1 AND `expired_time` > '2025-02-24 14:28:10' ORDER BY `weight` DESC [ RunTime:0.001216s ] [ 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.001179s ] [ 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.001079s ] [ info ] Yewu where数据{"status":1} [ info ] Yewu where数据{"status":1} --------------------------------------------------------------- [ 2025-02-24T14:28:10+08:00 ] 113.215.189.160 GET jx.t20.site/ [ sql ] [ DB ] CONNECT:[ UseTime:0.003307s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.002821s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE `type` = 'menu' AND `nickname` = '/' LIMIT 1 [ RunTime:0.001084s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.002419s ] [ 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.001106s ] [ 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.001006s ] [ 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.001055s ] [ 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.001002s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.002251s ] [ 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.001322s ] [ sql ] [ SQL ] SELECT * FROM `fa_category` WHERE ( `type` = 'yewu_type' AND `status` = 'normal' ) ORDER BY `weigh` DESC [ RunTime:0.001249s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'menu' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001033s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'banner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001029s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_link` [ RunTime:0.002512s ] [ sql ] [ SQL ] SELECT `name`,`url` FROM `fa_link` WHERE `status` = 1 AND `expired_time` > '2025-02-24 14:28:10' ORDER BY `weight` DESC [ RunTime:0.000985s ] [ 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.001008s ] [ 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.000885s ] [ info ] Yewu where数据{"status":1} [ info ] Yewu where数据{"status":1} --------------------------------------------------------------- [ 2025-02-24T21:11:18+08:00 ] 120.55.55.92 POST jx.t20.site/api/index/getGlobalInfo [ sql ] [ DB ] CONNECT:[ UseTime:0.002655s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_user_token` [ RunTime:0.003768s ] [ sql ] [ SQL ] SELECT * FROM `fa_user_token` WHERE `token` = '50efd3c0c727e66bb6d42e26d768b26ab0311eca' LIMIT 1 [ RunTime:0.001650s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.004477s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `fa_category` WHERE `type` = 'yewu_type' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001883s ] --------------------------------------------------------------- [ 2025-02-24T21:11:18+08:00 ] 120.55.55.92 POST jx.t20.site/api/index/index [ sql ] [ DB ] CONNECT:[ UseTime:0.003964s ] mysql:host=mysql8;port=3306;dbname=jixie;charset=utf8 [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_user_token` [ RunTime:0.004727s ] [ sql ] [ SQL ] SELECT * FROM `fa_user_token` WHERE `token` = '50efd3c0c727e66bb6d42e26d768b26ab0311eca' LIMIT 1 [ RunTime:0.001934s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_category` [ RunTime:0.004802s ] [ sql ] [ SQL ] SELECT `id`,`name`,`nickname`,`image`,`keywords`,`description` FROM `fa_category` WHERE `type` = 'mbanner' AND `status` = 'normal' ORDER BY `weigh` DESC [ RunTime:0.001912s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_post` [ RunTime:0.003826s ] [ 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.001884s ] [ 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.001949s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_yewu` [ RunTime:0.002892s ] [ 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.002138s ] [ sql ] [ SQL ] SHOW COLUMNS FROM `fa_tag` [ RunTime:0.002869s ] [ sql ] [ SQL ] SELECT `id`,`name` FROM `fa_tag` WHERE `id` IN (14,25,29,32,31,33,27,26) [ RunTime:0.003308s ] [ info ] 获取业务分类列表 typeId[0] tagId[0] limit[8] [ info ] array ( ) [ info ] Yewu where数据{"status":1}