[ DB ] CONNECT:[ UseTime:0.001282s ] mysql:host=rm-bp16tkkx0uq4c5pv50o.mysql.rds.aliyuncs.com;port=3306;dbname=game;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tplay_urlconfig` [ RunTime:0.001225s ]
[ SQL ] SELECT `aliases`,`url` FROM `tplay_urlconfig` WHERE `status` = 1 AND `type` = 1 [ RunTime:0.000965s ]
[ SQL ] SHOW COLUMNS FROM `tplay_tag` [ RunTime:0.001142s ]
[ SQL ] SELECT `id`,`name`,`url`,`type` FROM `tplay_tag` WHERE `status` = 1 AND `type` IN (2,5) ORDER BY create_time desc [ RunTime:0.000913s ]
[ SQL ] SHOW COLUMNS FROM `tplay_sub` [ RunTime:0.000959s ]
[ 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.000716s ]
[ SQL ] UPDATE `tplay_sub` SET `click`=`click`+1 WHERE `id` = 31 [ RunTime:0.000871s ]
[ SQL ] SHOW COLUMNS FROM `tplay_down` [ RunTime:0.001043s ]
[ 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.002758s ]
[ SQL ] SHOW COLUMNS FROM `tplay_news` [ RunTime:0.001278s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tplay_news` WHERE ( status= 3 and (title like '%火焰节%') and game_cate_id = 257 ) LIMIT 1 [ RunTime:0.000839s ]
[ 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.000843s ]
[ 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.005778s ]
[ 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.002620s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tplay_sub` WHERE `game_cate_id` = 257 AND `id` <> 31 LIMIT 1 [ RunTime:0.000851s ]
[ 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.000851s ]
[ 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.003216s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tplay_sub` WHERE `game_cate_id` = 257 AND `status` = 1 LIMIT 1 [ RunTime:0.000786s ]
[ 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.000824s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tplay_news` WHERE `send_time` < 1755506921 LIMIT 1 [ RunTime:0.027282s ]
[ 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.025148s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tplay_news` WHERE `send_time` < 1755506922 LIMIT 1 [ RunTime:0.020795s ]
[ SQL ] SELECT `id`,`title`,`pic`,`update_time`,`desc`,`click`,`is_type`,`send_time` FROM `tplay_news` WHERE `send_time` < 1755506922 ORDER BY send_time desc LIMIT 0,14 [ RunTime:0.032261s ]
神行少女
少年包青天
餐厅养成记
王者荣耀
哔哩哔哩
全民主公Ⅱ
方块大作战
原神
抖音
