SELECT * FROM `common_user` WHERE `uid` = 1013182 LIMIT 1 [ RunTime:0.000669s ]
SHOW FULL COLUMNS FROM `common_game_category` [ RunTime:0.001286s ]
SELECT `game_category_name`,`game_category_id`,`cover_image`,`category_url_name` FROM `common_game_category` WHERE `status` = 1 ORDER BY `sort` [ RunTime:0.000698s ]
SHOW FULL COLUMNS FROM `common_recommend_position` [ RunTime:0.001104s ]
SELECT * FROM `common_recommend_position` WHERE `status` = 1 ORDER BY `sort` [ RunTime:0.000668s ]
SHOW FULL COLUMNS FROM `common_game` [ RunTime:0.001310s ]
SELECT * FROM `common_game` WHERE `url_name` = 'car-vs-zombies' AND `game_status` = 1 LIMIT 1 [ RunTime:0.000696s ]
SELECT * FROM `common_game_category` WHERE `game_category_id` = 13 [ RunTime:0.000629s ]
SHOW FULL COLUMNS FROM `user_collect_game` [ RunTime:0.001035s ]
SELECT * FROM `user_collect_game` WHERE `game_id` = 1688 AND `uid` = 1013182 AND `channel_id` = 10001 AND `app_id` = 3052 LIMIT 1 [ RunTime:0.000623s ]
SHOW FULL COLUMNS FROM `common_game_rate_record` [ RunTime:0.000948s ]
SELECT * FROM `common_game_rate_record` WHERE `uid` = 1013182 AND `game_id` = 1688 LIMIT 1 [ RunTime:0.000739s ]
SELECT * FROM `common_game_rate_record` WHERE `game_id` = 1688 AND `rate_status` = 1 [ RunTime:0.000735s ]
SELECT * FROM `common_game_rate_record` WHERE `game_id` = 1688 AND `rate_status` = 2 [ RunTime:0.000705s ]
UPDATE `common_game` SET `game_play_num` = `game_play_num` + 1 WHERE `game_id` = 1688 [ RunTime:0.001099s ]
SHOW FULL COLUMNS FROM `user_recently_play` [ RunTime:0.001058s ]
SELECT * FROM `user_recently_play` WHERE `game_id` = 1688 AND `uid` = 1013182 AND `channel_id` = 10001 AND `app_id` = 3052 LIMIT 1 [ RunTime:0.000668s ]
SELECT * FROM `common_game` WHERE `game_id` = 1688 AND `game_status` = 1 LIMIT 1 [ RunTime:0.000693s ]
SELECT * FROM `common_game_category` WHERE `game_category_id` = 13 [ RunTime:0.000638s ]
SHOW FULL COLUMNS FROM `game_top_charts` [ RunTime:0.001057s ]
SELECT * FROM `game_top_charts` WHERE `game_id` = 1688 ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.001641s ]
SHOW FULL COLUMNS FROM `common_game_detail` [ RunTime:0.001020s ]
SELECT COUNT(*) AS think_count FROM `common_game_detail` WHERE `game_id` = 1688 AND `status` = 1 LIMIT 1 [ RunTime:0.000948s ]
SELECT `detail_id`,`game_id`,`detail_type`,`detail_main_img`,`detail_main_h_img`,`detail_title`,`detail_label`,`content` FROM `common_game_detail` WHERE `game_id` = 1688 AND `status` = 1 ORDER BY `create_time` DESC LIMIT 0,10 [ RunTime:0.000639s ]
SHOW FULL COLUMNS FROM `common_game_category_map` [ RunTime:0.000935s ]
SELECT COUNT(*) AS think_count FROM ( SELECT `cm`.*,count(*) AS think_count FROM `common_game_category_map` `gcm` LEFT JOIN `common_game` `cm` ON `gcm`.`game_id`=`cm`.`game_id` WHERE `cm`.`game_status` = '1' AND `gcm`.`category_id` = '13' GROUP BY `cm`.`game_id` ) `_group_count_` LIMIT 1 [ RunTime:0.001929s ]
SELECT `cm`.*,count(*) AS think_count FROM `common_game_category_map` `gcm` LEFT JOIN `common_game` `cm` ON `gcm`.`game_id`=`cm`.`game_id` WHERE `cm`.`game_status` = '1' AND `gcm`.`category_id` = '13' GROUP BY `cm`.`game_id` ORDER BY `cm`.`game_play_num` DESC LIMIT 0,9 [ RunTime:0.001563s ]
SELECT * FROM `common_game_category` WHERE `game_category_id` = 13 [ RunTime:0.000646s ]
SELECT * FROM `common_game_category` WHERE `game_category_id` IN (13,1,3) [ RunTime:0.000613s ]
SELECT * FROM `common_game_category` WHERE `game_category_id` IN (2,13) [ RunTime:0.000593s ]
SELECT * FROM `common_game_category` WHERE `game_category_id` IN (2,13) [ RunTime:0.000626s ]
SELECT * FROM `common_game_category` WHERE `game_category_id` = 13 [ RunTime:0.000596s ]
SELECT * FROM `common_game_category` WHERE `game_category_id` = 13 [ RunTime:0.000602s ]
SELECT * FROM `common_game_category` WHERE `game_category_id` = 13 [ RunTime:0.000597s ]
SELECT * FROM `common_game_category` WHERE `game_category_id` = 13 [ RunTime:0.000612s ]