| 0.0006 | SELECT *
FROM (`ci_sessions`)
WHERE `session_id` = '38886bef441d23c0ad0a7489b4af35a2'
AND last_activity > 1268085978 |
| 0.0009 | UPDATE ci_sessions SET last_activity = 1268258778, 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:6:{s:7:\"user_id\";i:0;s:8:\"sess_did\";i:0;s:16:\"redirect_url_key\";s:46:\"http://track.webglia.com/contests/beijing2008/\";s:17:\"FreakAuth_captcha\";s:5:\"xuznv\";s:24:\"flash:new:requested_page\";b:0;s:24:\"flash:old:requested_page\";b:0;}' WHERE session_id = '38886bef441d23c0ad0a7489b4af35a2' |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268258778, 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:16:\"redirect_url_key\";s:46:\"http://track.webglia.com/contests/beijing2008/\";s:17:\"FreakAuth_captcha\";s:5:\"xuznv\";s:24:\"flash:old:requested_page\";b:0;}' WHERE session_id = '38886bef441d23c0ad0a7489b4af35a2' |
| 0.0007 | SELECT *
FROM (`news`)
WHERE `domain` = '1'
ORDER BY `date` DESC
LIMIT 1 |
| 0.0044 | SELECT articles.*, object_assoc_articles.publish_date
FROM (`object_assoc_articles`)
JOIN `articles` ON object_assoc_articles.object_id = articles.id
WHERE (object_assoc_articles.publish_date <=' 2010-03-10 16:06:18') AND (object_assoc_articles.assoc = 'domain' AND object_assoc_articles.assoc_id = '1')
ORDER BY object_assoc_articles.publish_date DESC
LIMIT 4 |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '29267' |
| 0.0008 | SELECT *
FROM (`photos`)
WHERE `uid` = '29267'
AND `profile_default` = 1 |
| 0.0009 | SELECT *
FROM (`users`)
WHERE `id` = '51849' |
| 0.0153 | SELECT *
FROM (`photos`)
WHERE `uid` = '51849'
AND `profile_default` = 1 |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '15347' |
| 0.0080 | SELECT *
FROM (`photos`)
WHERE `uid` = '15347'
AND `profile_default` = 1 |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '29267' |
| 0.0005 | SELECT *
FROM (`photos`)
WHERE `uid` = '29267'
AND `profile_default` = 1 |
| 0.0122 | SELECT `id`, `uid`, `title`, `publish_date`
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (is_official = '1' AND flagged_count <=5 and publish_date <= '2010-03-10 16:06:18') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
ORDER BY object_assoc_blogs.publish_date DESC
LIMIT 6 |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '35583' |
| 0.0007 | SELECT *
FROM (`photos`)
WHERE `uid` = '35583'
AND `profile_default` = 1 |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '35583' |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '18315' |
| 0.0007 | SELECT *
FROM (`photos`)
WHERE `uid` = '18315'
AND `profile_default` = 1 |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '18315' |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '64831' |
| 0.0006 | SELECT *
FROM (`photos`)
WHERE `uid` = '64831'
AND `profile_default` = 1 |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '64831' |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '12942' |
| 0.0006 | SELECT *
FROM (`photos`)
WHERE `uid` = '12942'
AND `profile_default` = 1 |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '12942' |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '21' |
| 0.0013 | SELECT *
FROM (`photos`)
WHERE `uid` = '21'
AND `profile_default` = 1 |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '21' |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '61373' |
| 0.0006 | SELECT *
FROM (`photos`)
WHERE `uid` = '61373'
AND `profile_default` = 1 |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '61373' |
| 0.0212 | SELECT *
FROM (`photos_album`)
WHERE `did` = '1' AND visible_to = 'everyone' AND featured = '1'
ORDER BY `created_at` DESC
LIMIT 6 |
| 0.0004 | SELECT *
FROM (`app_objects`)
WHERE `object_type` = 'photo_album' |
| 0.0006 | SELECT *
FROM (`object_assoc_photos_album`)
WHERE `object_id` = '157048' |
| 0.0003 | SELECT *
FROM (`app_objects`)
WHERE `object_type` = 'photo' |
| 0.0018 | SELECT *
FROM (`object_assoc_photos`)
JOIN `photos` ON photos.id = object_assoc_photos.object_id
WHERE `assoc` = 'photo_album'
AND `assoc_id` = '157048'
ORDER BY rand() |
| 0.0014 | SELECT *
FROM (`users`)
WHERE `id` = '59663' |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '59663' |
| 0.0003 | SELECT *
FROM (`app_objects`)
WHERE `object_type` = 'photo_album' |
| 0.0008 | SELECT *
FROM (`object_assoc_photos_album`)
WHERE `object_id` = '157047' |
| 0.0004 | SELECT *
FROM (`app_objects`)
WHERE `object_type` = 'photo' |
| 0.0018 | SELECT *
FROM (`object_assoc_photos`)
JOIN `photos` ON photos.id = object_assoc_photos.object_id
WHERE `assoc` = 'photo_album'
AND `assoc_id` = '157047'
ORDER BY rand() |
| 0.0011 | SELECT *
FROM (`users`)
WHERE `id` = '59663' |
| 0.0011 | SELECT *
FROM (`users`)
WHERE `id` = '59663' |
| 0.0005 | SELECT *
FROM (`app_objects`)
WHERE `object_type` = 'photo_album' |
| 0.0006 | SELECT *
FROM (`object_assoc_photos_album`)
WHERE `object_id` = '157046' |
| 0.0003 | SELECT *
FROM (`app_objects`)
WHERE `object_type` = 'photo' |
| 0.0017 | SELECT *
FROM (`object_assoc_photos`)
JOIN `photos` ON photos.id = object_assoc_photos.object_id
WHERE `assoc` = 'photo_album'
AND `assoc_id` = '157046'
ORDER BY rand() |
| 0.0015 | SELECT *
FROM (`users`)
WHERE `id` = '59663' |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '59663' |
| 0.0003 | SELECT *
FROM (`app_objects`)
WHERE `object_type` = 'photo_album' |
| 0.0006 | SELECT *
FROM (`object_assoc_photos_album`)
WHERE `object_id` = '157030' |
| 0.0020 | SELECT *
FROM (`app_objects`)
WHERE `object_type` = 'photo' |
| 0.0093 | SELECT *
FROM (`object_assoc_photos`)
JOIN `photos` ON photos.id = object_assoc_photos.object_id
WHERE `assoc` = 'photo_album'
AND `assoc_id` = '157030'
ORDER BY rand() |
| 0.0029 | SELECT *
FROM (`users`)
WHERE `id` = '59663' |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '59663' |
| 0.0005 | SELECT *
FROM (`app_objects`)
WHERE `object_type` = 'photo_album' |
| 0.0006 | SELECT *
FROM (`object_assoc_photos_album`)
WHERE `object_id` = '157027' |
| 0.0003 | SELECT *
FROM (`app_objects`)
WHERE `object_type` = 'photo' |
| 0.0019 | SELECT *
FROM (`object_assoc_photos`)
JOIN `photos` ON photos.id = object_assoc_photos.object_id
WHERE `assoc` = 'photo_album'
AND `assoc_id` = '157027'
ORDER BY rand() |
| 0.0013 | SELECT *
FROM (`users`)
WHERE `id` = '15774' |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '15774' |
| 0.0003 | SELECT *
FROM (`app_objects`)
WHERE `object_type` = 'photo_album' |
| 0.0011 | SELECT *
FROM (`object_assoc_photos_album`)
WHERE `object_id` = '15785' |
| 0.0017 | SELECT *
FROM (`photos`)
WHERE `album_id` = '15785'
AND `album_default` = 1 |
| 0.0009 | SELECT *
FROM (`users`)
WHERE `id` = '45741' |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '45741' |
| 0.0002 | SELECT `uid`
FROM (`flocasts_employees`) |
| 0.0005 | SELECT *
FROM (`contributers`)
WHERE `uid` = 0
AND `did` = 1 |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268258778, 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:6:{s:7:\"user_id\";i:0;s:8:\"sess_did\";i:0;s:16:\"redirect_url_key\";s:46:\"http://track.webglia.com/contests/beijing2008/\";s:17:\"FreakAuth_captcha\";s:5:\"xuznv\";s:24:\"flash:old:requested_page\";b:0;s:24:\"flash:new:requested_page\";s:5:\"/wire\";}' WHERE session_id = '38886bef441d23c0ad0a7489b4af35a2' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268258778, 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:6:{s:7:\"user_id\";i:0;s:8:\"sess_did\";i:0;s:16:\"redirect_url_key\";s:46:\"http://track.webglia.com/contests/beijing2008/\";s:17:\"FreakAuth_captcha\";s:5:\"xuznv\";s:24:\"flash:old:requested_page\";b:0;s:24:\"flash:new:requested_page\";b:0;}' WHERE session_id = '38886bef441d23c0ad0a7489b4af35a2' |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268258778, 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:6:{s:7:\"user_id\";i:0;s:8:\"sess_did\";i:0;s:16:\"redirect_url_key\";s:46:\"http://track.webglia.com/contests/beijing2008/\";s:17:\"FreakAuth_captcha\";s:5:\"xuznv\";s:24:\"flash:old:requested_page\";b:0;s:24:\"flash:new:requested_page\";s:5:\"/wire\";}' WHERE session_id = '38886bef441d23c0ad0a7489b4af35a2' |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268258778, 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:6:{s:7:\"user_id\";i:0;s:8:\"sess_did\";i:0;s:16:\"redirect_url_key\";s:46:\"http://track.webglia.com/contests/beijing2008/\";s:17:\"FreakAuth_captcha\";s:5:\"xuznv\";s:24:\"flash:old:requested_page\";b:0;s:24:\"flash:new:requested_page\";b:0;}' WHERE session_id = '38886bef441d23c0ad0a7489b4af35a2' |
