SHOW FULL COLUMNS FROM `game_site` [ RunTime:0.000501s ]
SHOW FULL COLUMNS FROM `game_friends_links` [ RunTime:0.000377s ]
SELECT * FROM `game_friends_links` WHERE `status` = 1 ORDER BY `create_time` DESC LIMIT 18 [ RunTime:0.000215s ]
SHOW FULL COLUMNS FROM `game_plays` [ RunTime:0.000500s ]
SELECT `id`,`title` FROM `game_plays` WHERE `showarea` LIKE '%1%' AND `status` = 1 AND `state` = 1 ORDER BY `pv` DESC LIMIT 4 [ RunTime:0.000199s ]
SHOW FULL COLUMNS FROM `game_wechat` [ RunTime:0.000370s ]
SELECT `pic_url` FROM `game_wechat` ORDER BY rand() , id DESC LIMIT 1 [ RunTime:0.000150s ]
SHOW FULL COLUMNS FROM `game_friends_toplink` [ RunTime:0.000292s ]
SELECT * FROM `game_friends_toplink` WHERE `status` = 1 ORDER BY `create_time` DESC LIMIT 6 [ RunTime:0.000201s ]
SELECT `p`.`id`,`p`.`title`,`p`.`icon`,`m`.`type` FROM `game_plays` `p` INNER JOIN `game_mold` `m` ON `p`.`mold_id`=`m`.`id` WHERE `p`.`status` = '1' AND `p`.`state` = '1' ORDER BY `p`.`pv` DESC LIMIT 50 [ RunTime:0.000239s ]
SELECT p.id,p.title,p.icon,p.create_time,m.type,count(p.id) as num FROM `game_plays` `p` INNER JOIN `game_mold` `m` ON `p`.`mold_id`=`m`.`id` INNER JOIN `game_package` `ag` ON `ag`.`play_id`=`p`.`id` WHERE `p`.`status` = '1' AND `p`.`state` = '1' GROUP BY `p`.`id` ORDER BY `p`.`create_time` DESC LIMIT 6 [ RunTime:0.000269s ]