[ DB ] CONNECT:[ UseTime:0.001383s ] mysql:host=rm-bp16tkkx0uq4c5pv50o.mysql.rds.aliyuncs.com;port=3306;dbname=game;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tplay_urlconfig` [ RunTime:0.001242s ]
[ SQL ] SELECT `aliases`,`url` FROM `tplay_urlconfig` WHERE `status` = 1 AND `type` = 1 [ RunTime:0.000867s ]
[ SQL ] SHOW COLUMNS FROM `tplay_tag` [ RunTime:0.001208s ]
[ SQL ] SELECT `id`,`name`,`url`,`type` FROM `tplay_tag` WHERE `status` = 1 AND `type` IN (2,5) ORDER BY create_time desc [ RunTime:0.000873s ]
[ SQL ] SHOW COLUMNS FROM `tplay_banner` [ RunTime:0.000968s ]
[ SQL ] SELECT `title`,`url`,`pic` FROM `tplay_banner` WHERE `status` = 1 ORDER BY sort desc [ RunTime:0.000651s ]
[ SQL ] SHOW COLUMNS FROM `tplay_news` [ RunTime:0.000954s ]
[ SQL ] SELECT `id`,`title`,`is_type`,`type`,`update_time`,`send_time` FROM `tplay_news` WHERE `status` = 3 AND ( `is_type` = 2 or `is_type` = 1 ) ORDER BY send_time desc LIMIT 16 [ RunTime:0.032299s ]
[ SQL ] SHOW COLUMNS FROM `tplay_down` [ RunTime:0.001230s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tplay_down` WHERE `status` = 3 AND `type` = 1 AND `android_address` <> '' AND `related_version` = '200' LIMIT 1 [ RunTime:0.001867s ]
[ SQL ] SELECT `id`,`pic`,`title`,`desc`,`size`,`send_time`,`type`,`click`,`update_time`,`yx_cate`,`score`,`comment` FROM `tplay_down` WHERE `status` = 3 AND `type` = 1 AND `android_address` <> '' AND `related_version` = '200' ORDER BY update_time desc LIMIT 0,24 [ RunTime:0.002160s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tplay_down` WHERE `status` = 3 AND `type` = 2 LIMIT 1 [ RunTime:0.001423s ]
[ SQL ] SELECT `id`,`pic`,`title`,`desc`,`size`,`send_time`,`type`,`click`,`update_time`,`yx_cate`,`score`,`comment` FROM `tplay_down` WHERE `status` = 3 AND `type` = 2 ORDER BY update_time desc LIMIT 0,24 [ RunTime:0.001638s ]
[ SQL ] SELECT `title`,`id`,`type`,`update_time`,`pic` FROM `tplay_news` WHERE `status` = 3 AND `is_type` = 2 AND `update_time` BETWEEN 1735660800 AND 1767196800 ORDER BY click desc [ RunTime:0.028292s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tplay_news` WHERE `status` = 3 AND `is_type` = 3 LIMIT 1 [ RunTime:0.020735s ]
[ SQL ] SELECT `id`,`title`,`pic`,`update_time`,`desc`,`click`,`is_type`,`send_time` FROM `tplay_news` WHERE `status` = 3 AND `is_type` = 3 ORDER BY send_time desc LIMIT 0,16 [ RunTime:0.022215s ]
[ SQL ] SELECT `a`.`title`,`a`.`id`,`a`.`pic`,`a`.`size`,`a`.`type`,b.title as name FROM `tplay_down` `a` LEFT JOIN `tplay_game_type` `b` ON `b`.`id`=`a`.`yx_cate` WHERE `a`.`status` = '3' AND ( `apple_address` <> '' OR `android_address` <> '' ) AND `a`.`send_time` >= '1739818821' ORDER BY a.click desc [ RunTime:0.002237s ]
[ SQL ] SELECT `a`.`title`,`a`.`id`,`a`.`pic`,`a`.`size`,`a`.`type`,b.title as name FROM `tplay_down` `a` LEFT JOIN `tplay_game_type` `b` ON `b`.`id`=`a`.`yx_cate` WHERE `a`.`status` = '3' AND `a`.`type` = '1' AND ( `apple_address` <> '' OR `android_address` <> '' ) ORDER BY a.click desc [ RunTime:0.005828s ]
[ SQL ] SELECT `a`.`title`,`a`.`id`,`a`.`pic`,`a`.`size`,`a`.`type`,b.title as name FROM `tplay_down` `a` LEFT JOIN `tplay_game_type` `b` ON `b`.`id`=`a`.`yx_cate` WHERE `a`.`status` = '3' AND `a`.`type` = '1' AND ( `apple_address` <> '' OR `android_address` <> '' ) ORDER BY a.send_time desc [ RunTime:0.005607s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tplay_down` WHERE `status` = 3 AND `is_top` = 2 AND `type` = 1 LIMIT 1 [ RunTime:0.001474s ]
[ SQL ] SELECT `id`,`pic`,`title`,`desc`,`size`,`send_time`,`type`,`click`,`update_time`,`yx_cate`,`score`,`comment` FROM `tplay_down` WHERE `status` = 3 AND `is_top` = 2 AND `type` = 1 ORDER BY update_time desc LIMIT 0,24 [ RunTime:0.001471s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tplay_down` WHERE `status` = 3 AND `is_top` = 2 AND `type` = 2 LIMIT 1 [ RunTime:0.001162s ]
[ SQL ] SELECT `id`,`pic`,`title`,`desc`,`size`,`send_time`,`type`,`click`,`update_time`,`yx_cate`,`score`,`comment` FROM `tplay_down` WHERE `status` = 3 AND `is_top` = 2 AND `type` = 2 ORDER BY update_time desc LIMIT 0,24 [ RunTime:0.001361s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tplay_news` WHERE `status` = 3 AND `is_type` = 4 LIMIT 1 [ RunTime:0.020894s ]
[ SQL ] SELECT `id`,`title`,`pic`,`update_time`,`desc`,`click`,`is_type`,`send_time` FROM `tplay_news` WHERE `status` = 3 AND `is_type` = 4 ORDER BY send_time desc LIMIT 0,16 [ RunTime:0.023088s ]
[ SQL ] SELECT `id`,`name`,`url` FROM `tplay_tag` WHERE `type` = 4 AND `id` = 6 ORDER BY create_time desc LIMIT 1 [ RunTime:0.000747s ]
[ SQL ] SELECT `id`,`name`,`url`,`type` FROM `tplay_tag` WHERE `id` IN (7,8,9) AND `type` = 4 ORDER BY create_time desc [ RunTime:0.000712s ]
[ SQL ] SELECT `id`,`name`,`url` FROM `tplay_tag` WHERE `type` = 4 AND `id` = 13 ORDER BY create_time desc LIMIT 1 [ RunTime:0.000651s ]
[ SQL ] SELECT `id`,`name`,`url`,`type` FROM `tplay_tag` WHERE `id` IN (10,11,12) AND `type` = 4 ORDER BY create_time desc [ RunTime:0.000676s ]
[ SQL ] SHOW COLUMNS FROM `tplay_sub` [ RunTime:0.001030s ]
[ SQL ] SELECT `id`,`title`,`pic` FROM `tplay_sub` WHERE `status` = 1 ORDER BY update_time desc [ RunTime:0.000838s ]
[ SQL ] SHOW COLUMNS FROM `tplay_game_recommend_wap` [ RunTime:0.000857s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `tplay_game_recommend_wap` LIMIT 1 [ RunTime:0.000622s ]
[ SQL ] SELECT `id`,`game_id`,`sorts`,`admin_id`,`time` FROM `tplay_game_recommend_wap` ORDER BY sorts desc, id desc LIMIT 0,20 [ RunTime:0.000641s ]
[ SQL ] select id,title,pic,send_time,game_cate_id,is_type from `tplay_news` where status = 3 and is_type in (1,2) and send_time >= 1750186821 order by click desc limit 24 [ RunTime:0.024770s ]
[ SQL ] SHOW COLUMNS FROM `tplay_game_cate` [ RunTime:0.001019s ]
[ SQL ] SELECT `id`,`name` FROM `tplay_game_cate` WHERE `id` IN (3830,264,602,157,2,1943,2928,574,4869) [ RunTime:0.000926s ]
[ SQL ] (select id,title,pic,send_time,game_cate_id,is_type from `tplay_news` where game_cate_id = 3830 and status = 3 and is_type in (1,2) order by send_time desc limit 24) UNION (select id,title,pic,send_time,game_cate_id,is_type from `tplay_news` where game_cate_id = 264 and status = 3 and is_type in (1,2) order by send_time desc limit 24) UNION (select id,title,pic,send_time,game_cate_id,is_type from `tplay_news` where game_cate_id = 602 and status = 3 and is_type in (1,2) order by send_time desc limit 24) UNION (select id,title,pic,send_time,game_cate_id,is_type from `tplay_news` where game_cate_id = 157 and status = 3 and is_type in (1,2) order by send_time desc limit 24) UNION (select id,title,pic,send_time,game_cate_id,is_type from `tplay_news` where game_cate_id = 2 and status = 3 and is_type in (1,2) order by send_time desc limit 24) UNION (select id,title,pic,send_time,game_cate_id,is_type from `tplay_news` where game_cate_id = 1943 and status = 3 and is_type in (1,2) order by send_time desc limit 24) UNION (select id,title,pic,send_time,game_cate_id,is_type from `tplay_news` where game_cate_id = 2928 and status = 3 and is_type in (1,2) order by send_time desc limit 24) UNION (select id,title,pic,send_time,game_cate_id,is_type from `tplay_news` where game_cate_id = 574 and status = 3 and is_type in (1,2) order by send_time desc limit 24) UNION (select id,title,pic,send_time,game_cate_id,is_type from `tplay_news` where game_cate_id = 4869 and status = 3 and is_type in (1,2) order by send_time desc limit 24) [ RunTime:0.027685s ]