SHOW FULL COLUMNS FROM `game_site` [ RunTime:0.000470s ]
SELECT * FROM `game_site` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000380s ]
SHOW FULL COLUMNS FROM `game_friends_links` [ RunTime:0.000353s ]
SELECT * FROM `game_friends_links` WHERE `status` = 1 ORDER BY `create_time` DESC LIMIT 18 [ RunTime:0.000217s ]
SHOW FULL COLUMNS FROM `game_plays` [ RunTime:0.000392s ]
SELECT `id`,`title` FROM `game_plays` WHERE `showarea` LIKE '%1%' AND `status` = 1 AND `state` = 1 ORDER BY `pv` DESC LIMIT 4 [ RunTime:0.000195s ]
SHOW FULL COLUMNS FROM `game_wechat` [ RunTime:0.000321s ]
SELECT `pic_url` FROM `game_wechat` ORDER BY rand() , id DESC LIMIT 1 [ RunTime:0.000153s ]
SHOW FULL COLUMNS FROM `game_friends_toplink` [ RunTime:0.000302s ]
SELECT * FROM `game_friends_toplink` WHERE `status` = 1 ORDER BY `create_time` DESC LIMIT 6 [ RunTime:0.000169s ]
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.000221s ]
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.000212s ]