| 0.0007 |
SELECT *
FROM (`sessions`)
WHERE `session_id` = 'd23097cf8ec283668b08afe27e8d00c1'
AND `user_agent` = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)'
|
| 0.0006 |
UPDATE `sessions` SET `last_activity` = 1280438505, `session_id` = 'c9e72d22419deb2210ebd1d1f365f3b2' WHERE session_id = 'd23097cf8ec283668b08afe27e8d00c1'
|
| 0.0043 |
DELETE FROM `sessions`
WHERE `last_activity` < 1280431305
|
| 0.0530 |
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 = 76
|
| 0.0537 |
select
leaderboard_id LeaderboardId,
leaderboards.leaderboard_title LeaderboardTitle
from
leaderboards
where
leaderboard_key = 'Global'
and leaderboards.game_id = 76
|
| 0.0007 |
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 = 76
|
| 6.7086 |
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 = 76 and
scores.leaderboard_id = 80 and
scores.identifier_tag = ''
order by
scores.score desc,
scores.score_date desc
limit 0, 10
|
