[ DB ] CONNECT:[ UseTime:0.001334s ] mysql:host=rm-bp16tkkx0uq4c5pv50o.mysql.rds.aliyuncs.com;port=3306;dbname=game;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tplay_urlconfig` [ RunTime:0.001335s ]
[ SQL ] SELECT `aliases`,`url` FROM `tplay_urlconfig` WHERE `status` = 1 AND `type` = 1 [ RunTime:0.000883s ]
[ SQL ] SHOW COLUMNS FROM `tplay_tag` [ RunTime:0.001150s ]
[ SQL ] SELECT `id`,`name`,`url`,`type` FROM `tplay_tag` WHERE `status` = 1 AND `type` IN (2,5) ORDER BY create_time desc [ RunTime:0.000896s ]
[ SQL ] SHOW COLUMNS FROM `tplay_sub` [ RunTime:0.001010s ]
[ SQL ] SELECT `id`,`game_cate_id`,`title`,`index_key`,`desc`,`pic`,`new_key`,`update_time` FROM `tplay_sub` WHERE `id` = 31 LIMIT 1 [ RunTime:0.000896s ]
[ SQL ] UPDATE `tplay_sub` SET `click`=`click`+1 WHERE `id` = 31 [ RunTime:0.000809s ]
[ SQL ] SHOW COLUMNS FROM `tplay_down` [ RunTime:0.001011s ]
[ SQL ] SELECT `id`,`title`,`pic`,`key`,`desc`,`status`,`send_time`,`content`,`yx_cate`,`yx_name`,`size`,`d_pic`,`type`,`edition`,`platform`,`tags`,`android_address` FROM `tplay_down` WHERE `yx_name` = 257 LIMIT 1 [ RunTime:0.002723s ]
[ SQL ] SHOW COLUMNS FROM `tplay_news` [ RunTime:0.000999s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tplay_news` WHERE ( status= 3 and (title like '%火焰节%') and game_cate_id = 257 ) LIMIT 1 [ RunTime:0.000712s ]
[ SQL ] SELECT `id`,`title`,`pic`,`update_time`,`desc`,`click`,`is_type`,`send_time` FROM `tplay_news` WHERE ( status= 3 and (title like '%火焰节%') and game_cate_id = 257 ) ORDER BY send_time desc LIMIT 0,8 [ RunTime:0.000765s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tplay_down` `a` LEFT JOIN `tplay_admin` `b` ON `b`.`id`=`a`.`admin_id` LEFT JOIN `tplay_game_type` `c` ON `c`.`id`=`a`.`yx_cate` LIMIT 1 [ RunTime:0.003824s ]
[ SQL ] SELECT `a`.`is_top`,`a`.`id`,`a`.`title`,`b`.`nickname`,`a`.`click`,`a`.`status`,`a`.`send_time`,`a`.`size`,`a`.`type`,c.title as name,`pic`,`size`,`desc` FROM `tplay_down` `a` LEFT JOIN `tplay_admin` `b` ON `b`.`id`=`a`.`admin_id` LEFT JOIN `tplay_game_type` `c` ON `c`.`id`=`a`.`yx_cate` ORDER BY a.click desc,a.send_time desc LIMIT 0,9 [ RunTime:0.001692s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tplay_sub` WHERE `game_cate_id` = 257 AND `id` <> 31 LIMIT 1 [ RunTime:0.000772s ]
[ SQL ] SELECT `id`,`game_cate_id`,`title`,`pic`,`desc`,`update_time` FROM `tplay_sub` WHERE `game_cate_id` = 257 AND `id` <> 31 ORDER BY update_time desc LIMIT 0,2 [ RunTime:0.000710s ]
[ SQL ] SELECT id,pic,title FROM `tplay_down` WHERE id >= (SELECT floor(RAND() * (SELECT MAX(id) FROM `tplay_down`))) and status = 3 and type = 1 ORDER BY id LIMIT 10 [ RunTime:0.000838s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tplay_sub` WHERE `game_cate_id` = 257 AND `status` = 1 LIMIT 1 [ RunTime:0.000718s ]
[ SQL ] SELECT `id`,`game_cate_id`,`title`,`pic`,`desc`,`update_time` FROM `tplay_sub` WHERE `game_cate_id` = 257 AND `status` = 1 ORDER BY update_time desc LIMIT 0,24 [ RunTime:0.000751s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tplay_news` WHERE `send_time` < 1755506921 LIMIT 1 [ RunTime:0.021357s ]
[ SQL ] SELECT `id`,`title`,`pic`,`update_time`,`desc`,`click`,`is_type`,`send_time` FROM `tplay_news` WHERE `send_time` < 1755506921 ORDER BY click desc LIMIT 0,14 [ RunTime:0.025719s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tplay_news` WHERE `send_time` < 1755506921 LIMIT 1 [ RunTime:0.021183s ]
[ SQL ] SELECT `id`,`title`,`pic`,`update_time`,`desc`,`click`,`is_type`,`send_time` FROM `tplay_news` WHERE `send_time` < 1755506921 ORDER BY send_time desc LIMIT 0,14 [ RunTime:0.024681s ]
神行少女
少年包青天
餐厅养成记
王者荣耀
哔哩哔哩
全民主公Ⅱ
方块大作战
原神
抖音
