| 0.0005 | SELECT *
FROM (`ci_sessions`)
WHERE `session_id` = '38886bef441d23c0ad0a7489b4af35a2'
AND last_activity > 1268085250 |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268258050, 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:17:\"FreakAuth_captcha\";s:5:\"tfqgb\";s:24:\"flash:new:requested_page\";b:0;}' WHERE session_id = '38886bef441d23c0ad0a7489b4af35a2' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268258050, 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:17:\"FreakAuth_captcha\";s:5:\"tfqgb\";s:24:\"flash:new:requested_page\";b:0;s:24:\"flash:old:requested_page\";b:0;}' WHERE session_id = '38886bef441d23c0ad0a7489b4af35a2' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268258050, 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:17:\"FreakAuth_captcha\";s:5:\"tfqgb\";s:24:\"flash:old:requested_page\";b:0;}' WHERE session_id = '38886bef441d23c0ad0a7489b4af35a2' |
| 0.0031 | SELECT coverages.*, object_assoc_coverages.publish_date
FROM (`coverages`)
JOIN `object_assoc_coverages` ON object_id = id
WHERE `id` = '234199-2008-new-york-city-marathon'
AND `assoc` = 'domain'
AND `assoc_id` = 1 |
| 0.0011 | SELECT COUNT(*) AS `numrows`
FROM (`object_assoc_videos`)
JOIN `videos` ON object_assoc_videos.object_id = videos.id
WHERE `video_type` = 'flocast' and video_table_2 = '' AND publish_date <= '2010-03-10 15:54:10' AND object_assoc_videos.assoc = 'coverage' AND object_assoc_videos.assoc_id = '234199' |
| 0.0046 | SELECT videos.*, object_assoc_videos.*
FROM (`object_assoc_videos`)
JOIN `videos` ON object_assoc_videos.object_id = videos.id
LEFT JOIN `videos_categories` ON videos_categories.id = videos.cat_id
WHERE ((video_type = 'flocast' OR video_type = 'client_video') and video_table_2 = '' AND publish_date <= '2010-03-10 16:00:00') AND (object_assoc_videos.assoc = 'coverage' AND object_assoc_videos.assoc_id = '234199')
ORDER BY `sort_order` ASC, cat_id ASC, publish_date DESC |
| 0.0010 | SELECT *
FROM (`object_assoc_photos_album`)
JOIN `photos_album` ON object_assoc_photos_album.object_id = photos_album.id
WHERE (num1 = 1) AND (object_assoc_photos_album.assoc = 'coverage' AND object_assoc_photos_album.assoc_id = '234199')
LIMIT 1 |
| 0.0017 | SELECT *
FROM (`object_assoc_photos`)
JOIN `photos` ON object_assoc_photos.object_id = photos.id
WHERE (object_assoc_photos.assoc = 'coverage' AND object_assoc_photos.assoc_id = '234199')
ORDER BY rand()
LIMIT 4 |
| 0.0023 | SELECT *
FROM (`object_assoc_videos`)
JOIN `videos` ON object_assoc_videos.object_id = videos.id
WHERE ((video_type = 'flocast' OR video_type = 'client_video') and video_table_2 = '' AND publish_date <= '2010-03-10 16:00:00') AND (object_assoc_videos.assoc = 'coverage' AND object_assoc_videos.assoc_id = '234199')
ORDER BY `rating` ASC, publish_date DESC
LIMIT 4 |
| 0.0022 | SELECT *
FROM (`object_assoc_videos`)
JOIN `videos` ON object_assoc_videos.object_id = videos.id
JOIN `videos_track` ON videos_track.id = object_assoc_videos.object_id
WHERE (videos.video_type = 'flocast' and videos.video_table_2 = 'videos_track') AND (object_assoc_videos.assoc = 'coverage' AND object_assoc_videos.assoc_id = '234199')
ORDER BY `rating` ASC, publish_date DESC
LIMIT 4 |
| 0.0015 | SELECT *
FROM (`object_assoc_videos`)
JOIN `videos` ON object_assoc_videos.object_id = videos.id
WHERE (video_type = 'user') AND (object_assoc_videos.assoc = 'coverage' AND object_assoc_videos.assoc_id = '234199')
ORDER BY `publish_date` DESC
LIMIT 4 |
| 0.0038 | SHOW COLUMNS FROM coverages |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268258050, 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:3:{s:7:\"user_id\";i:0;s:8:\"sess_did\";i:0;s:24:\"flash:old:requested_page\";b:0;}' WHERE session_id = '38886bef441d23c0ad0a7489b4af35a2' |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268258050, 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:4:{s:7:\"user_id\";i:0;s:8:\"sess_did\";i:0;s:24:\"flash:old:requested_page\";b:0;s:17:\"FreakAuth_captcha\";s:5:\"umtta\";}' WHERE session_id = '38886bef441d23c0ad0a7489b4af35a2' |
| 0.0022 | SELECT *
FROM (`comments_coverages`)
LEFT JOIN `users` ON users.id=comments_coverages.uid
WHERE (object_id = '234199' AND flagged_count < '5')
ORDER BY `created_at` DESC
LIMIT 10 |
| 0.0110 | SELECT *
FROM (`feeds`)
WHERE (feed_type = 'coverage' and number1 = 234199 and feed_action != 'comment_coverage') or
(string1 = 'coverage' and number1 = 234199) or
(string2 = 'coverage' and number2 = 234199)
ORDER BY `created_at` DESC, id DESC
LIMIT 10 |
| 0.0015 | SELECT *
FROM (`object_assoc_photos`)
JOIN `photos` ON object_assoc_photos.object_id = photos.id
WHERE (object_assoc_photos.assoc = 'coverage' AND object_assoc_photos.assoc_id = '234199')
ORDER BY rand()
LIMIT 1 |
| 0.0025 | SELECT *
FROM (`object_assoc_videos`)
JOIN `videos` ON object_assoc_videos.object_id = videos.id
WHERE (object_assoc_videos.assoc = 'coverage' AND object_assoc_videos.assoc_id = '234199') |
| 0.0005 | SELECT COUNT(*) as count FROM comments_videos where object_id in (76990,76991,76993,76999,77000,77001,77003,77080,77173,77175,77391,77393,77513,77619,77623,77629,77648,77653,77662,77688,77757) and flagged_count < 5 |
| 0.0008 | SELECT COUNT(*) as count FROM ratings where id in (76990,76991,76993,76999,77000,77001,77003,77080,77173,77175,77391,77393,77513,77619,77623,77629,77648,77653,77662,77688,77757) and type = 'video' |
| 0.0007 | UPDATE ci_sessions SET last_activity = 1268258050, 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:24:\"flash:old:requested_page\";b:0;s:17:\"FreakAuth_captcha\";s:5:\"umtta\";s:24:\"flash:new:requested_page\";s:56:\"/videos/coverage/view/234199-2008-new-york-city-marathon\";}' WHERE session_id = '38886bef441d23c0ad0a7489b4af35a2' |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268258050, 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:24:\"flash:old:requested_page\";b:0;s:17:\"FreakAuth_captcha\";s:5:\"umtta\";s:24:\"flash:new:requested_page\";b:0;}' WHERE session_id = '38886bef441d23c0ad0a7489b4af35a2' |
| 0.0005 | UPDATE ci_sessions SET last_activity = 1268258050, 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:24:\"flash:old:requested_page\";b:0;s:17:\"FreakAuth_captcha\";s:5:\"umtta\";s:24:\"flash:new:requested_page\";s:56:\"/videos/coverage/view/234199-2008-new-york-city-marathon\";}' WHERE session_id = '38886bef441d23c0ad0a7489b4af35a2' |
| 0.0022 | UPDATE ci_sessions SET last_activity = 1268258050, 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:24:\"flash:old:requested_page\";b:0;s:17:\"FreakAuth_captcha\";s:5:\"umtta\";s:24:\"flash:new:requested_page\";b:0;}' WHERE session_id = '38886bef441d23c0ad0a7489b4af35a2' |
2008 New York City Marathon
