SHOW FULL COLUMNS FROM `game_site` [ RunTime:0.000473s ]
SHOW FULL COLUMNS FROM `game_friends_links` [ RunTime:0.000347s ]
SELECT * FROM `game_friends_links` WHERE `status` = 1 ORDER BY `create_time` DESC LIMIT 18 [ RunTime:0.000207s ]
SHOW FULL COLUMNS FROM `game_plays` [ RunTime:0.000395s ]
SELECT `id`,`title` FROM `game_plays` WHERE `showarea` LIKE '%1%' AND `status` = 1 AND `state` = 1 ORDER BY `pv` DESC LIMIT 4 [ RunTime:0.000220s ]
SHOW FULL COLUMNS FROM `game_wechat` [ RunTime:0.000349s ]
SELECT `pic_url` FROM `game_wechat` ORDER BY rand() , id DESC LIMIT 1 [ RunTime:0.000152s ]
SHOW FULL COLUMNS FROM `game_friends_toplink` [ RunTime:0.000305s ]
SELECT * FROM `game_friends_toplink` WHERE `status` = 1 ORDER BY `create_time` DESC LIMIT 6 [ RunTime:0.000178s ]
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.000211s ]
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.000227s ]
