0.0004 |
SELECT * FROM `games` JOIN `games_folders` ON `games`.`game_id` = `games_folders`.`game_id` WHERE `slug` = 'current'
|
0.0035 |
SELECT * FROM `games` JOIN `games_folders` ON `games`.`game_id` = `games_folders`.`game_id` WHERE `published` = 1 ORDER BY `games`.`game_id` DESC LIMIT 9999999
|
0.0115 |
SELECT * FROM `games` JOIN `games_folders` ON `games`.`game_id` = `games_folders`.`game_id` JOIN (select game_id, max(created) created from plays group by game_id order by max(created) desc) plays ON `games`.`game_id`=`plays`.`game_id` WHERE `published` = 1 ORDER BY `plays`.`created` DESC LIMIT 30
|
0.0003 |
SELECT `users_groups`.`group_id` as `id`, `groups`.`name`, `groups`.`description` FROM `users_groups` JOIN `groups` ON `users_groups`.`group_id`=`groups`.`id` WHERE `users_groups`.`user_id` IS NULL
|