| 0.0005 |
INSERT INTO `sessions` (`session_id`, `ip_address`, `user_agent`, `last_activity`) VALUES ('73ff98725127705c3bc205f99aaf0a00', '10.211.162.33', 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', 1268340690)
|
| 0.0007 |
select
games.game_id GameID,
games.game_description GameDescription,
games.game_name GameName,
games.game_image GameImage,
games.game_image_small GameImageSmall,
games.game_link GameLink,
games.application_key ApplicationKey,
games.application_secret ApplicationSecret,
developers.publisher_name PublisherName
from
games
inner join developers on developers.user_id = games.publisher_user_id
where
1 = 1
and games.game_id = 63
|
| 0.0509 |
select
leaderboard_id LeaderboardId,
leaderboards.leaderboard_title LeaderboardTitle
from
leaderboards
where
leaderboard_key = 'Global'
and leaderboards.game_id = 63
|
| 0.0277 |
select
leaderboard_id,
leaderboards.score_criteria,
show_top,
format_prefix,
format_thousands,
format_decimal,
format_precision,
format_suffix
from
leaderboards
inner join games on games.game_id = leaderboards.game_id
where
leaderboard_key = 'Global' and
games.game_id = 63
|
| 0.0672 |
select
users.user_id UserID,
users.username Username,
users.birth_date BirthDate,
users.email_address EmailAddress,
users.gender_id GenderID,
users.country_id CountryID,
users.postal_code PostalCode,
users.unique_identifier UniqueIdentifier,
users.last_login LastLogin,
users.last_action LastAction,
users.last_game_id LastGameID,
users.is_online IsOnline,
profiles.website Website,
profiles.about_text AboutText,
profiles.avatar_image AvatarImage,
profiles.avatar_image_small AvatarImageSmall,
profiles.avatar_image_small AvatarImageTiny,
profiles.display_age DisplayAge,
profiles.display_gender DisplayGender,
profiles.location Location,
games.game_id GameID,
games.game_name GameName,
games.game_image GameImage,
games.game_image_small GameImageSmall,
games.publisher_name PublisherName,
games.publisher_user_id PublisherID,
games.game_link GameLink,
scores.score Score,
scores.score_date ScoreDate
from
scores
inner join users on scores.user_id = users.user_id
inner join games on scores.game_id = games.game_id
left outer join profiles on users.user_id = profiles.user_id
where
games.game_id = 63 and
scores.leaderboard_id = 46 and
scores.identifier_tag = ''
order by
scores.score desc,
scores.score_date desc
limit 0, 10
|
