SHOW FULL COLUMNS FROM `cms_site_game` [ RunTime:0.004376s ]
SELECT COUNT(DISTINCT `g`.`id`) AS think_count FROM `cms_site_game` `sg` INNER JOIN `cms_game` `g` ON `sg`.`game_id`=`g`.`id` INNER JOIN `cms_game_tags` `gt` ON `g`.`id`=`gt`.`game_id` WHERE `sg`.`site_id` = '1439' AND `g`.`status` = '1' AND `sg`.`status` = '1' AND `gt`.`tag_id` = '1648' [ RunTime:0.003739s ]
SELECT `sg`.`id`,`sg`.`game_id`,`g`.`title`,`g`.`summery`,`g`.`tags`,`g`.`votes`,`g`.`star_rating`,`g`.`platform`,`g`.`desktop_friendly`,`g`.`mobile_friendly`,`g`.`orientation`,`g`.`thumb_small`,`g`.`thumb_middle`,`g`.`thumb_big`,`g`.`create_time`,`t`.`tag_name` FROM `cms_site_game` `sg` INNER JOIN `cms_game` `g` ON `sg`.`game_id`=`g`.`id` INNER JOIN `cms_game_tags` `gt` ON `g`.`id`=`gt`.`game_id` INNER JOIN `cms_tags` `t` ON `gt`.`tag_id`=`t`.`id` WHERE `sg`.`site_id` = '1439' AND `g`.`status` = '1' AND `sg`.`status` = '1' AND `gt`.`tag_id` = '1648' GROUP BY `g`.`id` ORDER BY `sg`.`create_time` DESC LIMIT 0,20 [ RunTime:0.003674s ]