| 0.0007 | SELECT *
FROM (`ci_sessions`)
WHERE `session_id` = '0299171dfb0517baccecf8546dd2f80c'
AND last_activity > 1268251689 |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268424489, user_agent = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', ip_address = '38.107.191.106', user_id = 0, sess_did = NULL, session_data = 'a:4:{s:7:\"user_id\";i:0;s:8:\"sess_did\";i:0;s:18:\"track_race_options\";a:4:{s:5:\"level\";s:0:\"\";s:6:\"gender\";s:0:\"\";s:10:\"event_name\";s:0:\"\";s:9:\"meet_name\";s:0:\"\";}s:24:\"flash:new:requested_page\";b:0;}' WHERE session_id = '0299171dfb0517baccecf8546dd2f80c' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268424489, user_agent = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', ip_address = '38.107.191.106', user_id = 0, sess_did = NULL, session_data = 'a:5:{s:7:\"user_id\";i:0;s:8:\"sess_did\";i:0;s:18:\"track_race_options\";a:4:{s:5:\"level\";s:0:\"\";s:6:\"gender\";s:0:\"\";s:10:\"event_name\";s:0:\"\";s:9:\"meet_name\";s:0:\"\";}s:24:\"flash:new:requested_page\";b:0;s:24:\"flash:old:requested_page\";b:0;}' WHERE session_id = '0299171dfb0517baccecf8546dd2f80c' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268424489, user_agent = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', ip_address = '38.107.191.106', user_id = 0, sess_did = NULL, session_data = 'a:4:{s:7:\"user_id\";i:0;s:8:\"sess_did\";i:0;s:18:\"track_race_options\";a:4:{s:5:\"level\";s:0:\"\";s:6:\"gender\";s:0:\"\";s:10:\"event_name\";s:0:\"\";s:9:\"meet_name\";s:0:\"\";}s:24:\"flash:old:requested_page\";b:0;}' WHERE session_id = '0299171dfb0517baccecf8546dd2f80c' |
| 0.0015 | SELECT *
FROM (`users`)
WHERE `user_name` = 'kevin18runner' |
| 0.0149 | SELECT *
FROM (`user_profile_portlets`)
WHERE `user_id` = 7511 and (did = 1 || did = 0) |
| 0.0005 | SELECT count(*) as cnt
FROM (`team_donations`)
INNER JOIN `teams` ON teams.id = team_donations.team_id
INNER JOIN `memberships` ON memberships.belongs2_id = teams.id
INNER JOIN `users` ON users.id = memberships.uid
WHERE memberships.belongs2 = 'team' AND users.id = 7511
AND now() between team_donations.start_date and team_donations.end_date |
| 0.0007 | SELECT *
FROM (`photos_album`)
WHERE `uid` = '7511'
AND `profile_album` = 1 |
| 0.0082 | SELECT *
FROM (`photos`)
WHERE `uid` = '7511'
AND `profile_default` = 1 |
| 0.0008 | SELECT *
FROM (`user_profile`)
WHERE `id` = '7511' |
| 0.0011 | SELECT *
FROM (`memberships`)
JOIN `teams` ON teams.id=memberships.belongs2_id
WHERE memberships.did = 1
AND memberships.belongs2 = 'team'
AND memberships.uid = '7511'
AND memberships.status = 'approved'
AND `member_relation` IN ('member', 'coach', 'assistant_coach')
ORDER BY `member_access` ASC, joined_at DESC |
| 0.0009 | SELECT *
FROM (`memberships`)
JOIN `teams` ON teams.id=memberships.belongs2_id
WHERE memberships.did = 1
AND memberships.belongs2 = 'team'
AND memberships.uid = '7511'
AND memberships.status = 'approved'
AND `member_relation` IN ('fan', 'super_fan', 'parent', 'alumni', 'recruit')
ORDER BY `member_access` ASC, joined_at DESC |
| 0.0006 | SELECT *
FROM (`requests`)
WHERE `request_type` = 'friend'
AND `request_action` = 'friend_invite'
AND `sender_id` = 0
AND `receiver_id` = '7511'
AND `did` = 1 |
| 0.0007 | SELECT *
FROM (`user_profile`)
WHERE `id` = '7511' |
| 0.0005 | SELECT COUNT(*) AS `numrows`
FROM (`object_assoc_videos`)
JOIN `videos` ON object_assoc_videos.object_id = videos.id
WHERE `video_type` = 'user' AND user_id = '7511' AND object_assoc_videos.assoc = 'domain' AND object_assoc_videos.assoc_id = '1' |
| 0.0006 | SELECT count(*) as count
FROM (`photos`)
WHERE `uid` = '7511' |
| 0.0265 | SELECT COUNT(*) as friends_count
FROM (`friends`)
WHERE (uid1 = 7511 or uid2 = 7511) and status='approved'
ORDER BY `created_at` DESC |
| 0.0004 | SELECT *
FROM (`apps`)
WHERE `app_key` = 'running_logs' |
| 0.0030 | SELECT *
FROM (`running_logs_prefs`)
WHERE `uid` = '7511'
ORDER BY `id` DESC
LIMIT 1 |
| 0.0003 | SELECT `uid`
FROM (`flocasts_employees`) |
| 0.0005 | SELECT *
FROM (`contributers`)
WHERE `uid` = 0
AND `did` = 1 |
| 0.0005 | UPDATE ci_sessions SET last_activity = 1268424489, user_agent = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', ip_address = '38.107.191.106', user_id = 0, sess_did = 1, session_data = 'a:5:{s:7:\"user_id\";i:0;s:8:\"sess_did\";i:0;s:18:\"track_race_options\";a:4:{s:5:\"level\";s:0:\"\";s:6:\"gender\";s:0:\"\";s:10:\"event_name\";s:0:\"\";s:9:\"meet_name\";s:0:\"\";}s:24:\"flash:old:requested_page\";b:0;s:24:\"flash:new:requested_page\";s:22:\"/members/kevin18runner\";}' WHERE session_id = '0299171dfb0517baccecf8546dd2f80c' |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268424489, user_agent = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', ip_address = '38.107.191.106', user_id = 0, sess_did = 1, session_data = 'a:5:{s:7:\"user_id\";i:0;s:8:\"sess_did\";i:0;s:18:\"track_race_options\";a:4:{s:5:\"level\";s:0:\"\";s:6:\"gender\";s:0:\"\";s:10:\"event_name\";s:0:\"\";s:9:\"meet_name\";s:0:\"\";}s:24:\"flash:old:requested_page\";b:0;s:24:\"flash:new:requested_page\";b:0;}' WHERE session_id = '0299171dfb0517baccecf8546dd2f80c' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268424489, user_agent = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', ip_address = '38.107.191.106', user_id = 0, sess_did = 1, session_data = 'a:5:{s:7:\"user_id\";i:0;s:8:\"sess_did\";i:0;s:18:\"track_race_options\";a:4:{s:5:\"level\";s:0:\"\";s:6:\"gender\";s:0:\"\";s:10:\"event_name\";s:0:\"\";s:9:\"meet_name\";s:0:\"\";}s:24:\"flash:old:requested_page\";b:0;s:24:\"flash:new:requested_page\";s:22:\"/members/kevin18runner\";}' WHERE session_id = '0299171dfb0517baccecf8546dd2f80c' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268424489, user_agent = 'CCBot/1.0 (+http://www.commoncrawl.org/bot.html)', ip_address = '38.107.191.106', user_id = 0, sess_did = 1, session_data = 'a:5:{s:7:\"user_id\";i:0;s:8:\"sess_did\";i:0;s:18:\"track_race_options\";a:4:{s:5:\"level\";s:0:\"\";s:6:\"gender\";s:0:\"\";s:10:\"event_name\";s:0:\"\";s:9:\"meet_name\";s:0:\"\";}s:24:\"flash:old:requested_page\";b:0;s:24:\"flash:new:requested_page\";b:0;}' WHERE session_id = '0299171dfb0517baccecf8546dd2f80c' |
