[ DB ] CONNECT:[ UseTime:0.001388s ] mysql:host=rm-bp16tkkx0uq4c5pv50o.mysql.rds.aliyuncs.com;port=3306;dbname=game;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tplay_urlconfig` [ RunTime:0.001267s ]
[ SQL ] SELECT `aliases`,`url` FROM `tplay_urlconfig` WHERE `status` = 1 AND `type` = 1 [ RunTime:0.000921s ]
[ SQL ] SHOW COLUMNS FROM `tplay_tag` [ RunTime:0.001171s ]
[ SQL ] SELECT `id`,`name`,`url`,`type` FROM `tplay_tag` WHERE `status` = 1 AND `type` IN (2,5) ORDER BY create_time desc [ RunTime:0.001019s ]
[ SQL ] SHOW COLUMNS FROM `tplay_sub` [ RunTime:0.001133s ]
[ SQL ] SELECT `id`,`game_cate_id`,`title`,`index_key`,`desc`,`pic`,`new_key`,`update_time` FROM `tplay_sub` WHERE `id` = 12 LIMIT 1 [ RunTime:0.000767s ]
[ SQL ] UPDATE `tplay_sub` SET `click`=`click`+1 WHERE `id` = 12 [ RunTime:0.001007s ]
[ SQL ] SHOW COLUMNS FROM `tplay_down` [ RunTime:0.001093s ]
[ 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` = 5 LIMIT 1 [ RunTime:0.002853s ]
[ SQL ] SHOW COLUMNS FROM `tplay_news` [ RunTime:0.001063s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tplay_news` WHERE ( status= 3 and (title like '%活动%') and game_cate_id = 5 ) LIMIT 1 [ RunTime:0.000980s ]
[ 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 = 5 ) ORDER BY send_time desc LIMIT 0,8 [ RunTime:0.000936s ]
[ 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.003879s ]
[ 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.001873s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tplay_sub` WHERE `game_cate_id` = 5 AND `id` <> 12 LIMIT 1 [ RunTime:0.000784s ]
[ SQL ] SELECT `id`,`game_cate_id`,`title`,`pic`,`desc`,`update_time` FROM `tplay_sub` WHERE `game_cate_id` = 5 AND `id` <> 12 ORDER BY update_time desc LIMIT 0,2 [ RunTime:0.000790s ]
[ 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.000866s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tplay_sub` WHERE `game_cate_id` = 5 AND `status` = 1 LIMIT 1 [ RunTime:0.000746s ]
[ SQL ] SELECT `id`,`game_cate_id`,`title`,`pic`,`desc`,`update_time` FROM `tplay_sub` WHERE `game_cate_id` = 5 AND `status` = 1 ORDER BY update_time desc LIMIT 0,24 [ RunTime:0.000811s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tplay_news` WHERE `send_time` < 1755506896 LIMIT 1 [ RunTime:0.021328s ]
[ SQL ] SELECT `id`,`title`,`pic`,`update_time`,`desc`,`click`,`is_type`,`send_time` FROM `tplay_news` WHERE `send_time` < 1755506896 ORDER BY click desc LIMIT 0,14 [ RunTime:0.023936s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tplay_news` WHERE `send_time` < 1755506896 LIMIT 1 [ RunTime:0.021186s ]
[ SQL ] SELECT `id`,`title`,`pic`,`update_time`,`desc`,`click`,`is_type`,`send_time` FROM `tplay_news` WHERE `send_time` < 1755506896 ORDER BY send_time desc LIMIT 0,14 [ RunTime:0.025177s ]
神行少女
少年包青天
餐厅养成记
王者荣耀
哔哩哔哩
全民主公Ⅱ
方块大作战
原神
抖音
