| 0.0005 | SELECT *
FROM (`ci_sessions`)
WHERE `session_id` = 'db01ecfb536f31a669b992e412093649'
AND last_activity > 1268202930 |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268375730, 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:\"ijfax\";s:24:\"flash:old:requested_page\";b:0;s:24:\"flash:new:requested_page\";b:0;}' WHERE session_id = 'db01ecfb536f31a669b992e412093649' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268375730, 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:\"ijfax\";s:24:\"flash:new:requested_page\";b:0;}' WHERE session_id = 'db01ecfb536f31a669b992e412093649' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268375730, 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:\"ijfax\";s:24:\"flash:new:requested_page\";b:0;s:24:\"flash:old:requested_page\";b:0;}' WHERE session_id = 'db01ecfb536f31a669b992e412093649' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268375730, 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:\"ijfax\";s:24:\"flash:old:requested_page\";b:0;}' WHERE session_id = 'db01ecfb536f31a669b992e412093649' |
| 0.0020 | SELECT coverages.*, object_assoc_coverages.publish_date
FROM (`coverages`)
JOIN `object_assoc_coverages` ON object_id = id
WHERE `id` = '234300-2008-ncaa-cross-country-south-regional'
AND `assoc` = 'domain'
AND `assoc_id` = 1 |
| 0.0004 | SELECT *
FROM (`coverages_peeps`)
WHERE `coverage_id` = '234300'
ORDER BY `event_name` ASC |
| 0.0005 | 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-12 00:35:30' AND object_assoc_videos.assoc = 'coverage' AND object_assoc_videos.assoc_id = '234300' |
| 0.0047 | 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-12 00:45:00') AND (object_assoc_videos.assoc = 'coverage' AND object_assoc_videos.assoc_id = '234300')
ORDER BY `sort_order` ASC, cat_id ASC, publish_date DESC |
| 0.0005 | SELECT COUNT(*) AS `numrows`
FROM (`object_assoc_videos`)
JOIN `videos` ON object_assoc_videos.object_id = videos.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 = '234300' |
| 0.0020 | 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 = '234300')
ORDER BY `title` ASC |
| 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 object_assoc_videos.assoc = 'coverage' AND object_assoc_videos.assoc_id = '234300' |
| 0.0017 | 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 = '234300')
ORDER BY `cat_id` ASC, publish_date DESC |
| 0.0009 | 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 = '234300')
LIMIT 1 |
| 0.0012 | SELECT *
FROM (`object_assoc_photos`)
JOIN `photos` ON object_assoc_photos.object_id = photos.id
WHERE (object_assoc_photos.assoc = 'photo_album' AND object_assoc_photos.assoc_id = '157030')
ORDER BY rand()
LIMIT 4 |
| 0.0004 | SELECT COUNT(*) AS `numrows`
FROM (`object_assoc_photos`)
JOIN `photos` ON object_assoc_photos.object_id = photos.id
WHERE object_assoc_photos.assoc = 'photo_album' AND object_assoc_photos.assoc_id = '157030' |
| 0.0021 | 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-12 00:45:00') AND (object_assoc_videos.assoc = 'coverage' AND object_assoc_videos.assoc_id = '234300')
ORDER BY `rating` ASC, publish_date DESC
LIMIT 4 |
| 0.0020 | 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 = '234300')
ORDER BY `rating` ASC, publish_date DESC
LIMIT 4 |
| 0.0013 | 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 = '234300')
ORDER BY `publish_date` DESC
LIMIT 4 |
| 0.0030 | SHOW COLUMNS FROM coverages |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268375730, 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 = 'db01ecfb536f31a669b992e412093649' |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268375730, 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:\"vvkhk\";}' WHERE session_id = 'db01ecfb536f31a669b992e412093649' |
| 0.0023 | SELECT *
FROM (`comments_coverages`)
LEFT JOIN `users` ON users.id=comments_coverages.uid
WHERE (object_id = '234300' AND flagged_count < '5')
ORDER BY `created_at` DESC
LIMIT 10 |
| 0.0012 | SELECT *
FROM (`feeds`)
WHERE (feed_type = 'coverage' and number1 = 234300 and feed_action != 'comment_coverage') or
(string1 = 'coverage' and number1 = 234300) or
(string2 = 'coverage' and number2 = 234300)
ORDER BY `created_at` DESC, id DESC
LIMIT 10 |
| 0.0012 | 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.0016 | 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 = '234300') |
| 0.0004 | SELECT COUNT(*) as count FROM comments_videos where object_id in (80732,80733,80734,80737,80738,80739,80741) and flagged_count < 5 |
| 0.0005 | SELECT COUNT(*) as count FROM ratings where id in (80732,80733,80734,80737,80738,80739,80741) and type = 'video' |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '19269' |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268375730, 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:\"vvkhk\";s:24:\"flash:new:requested_page\";s:67:\"/videos/coverage/view/234300-2008-ncaa-cross-country-south-regional\";}' WHERE session_id = 'db01ecfb536f31a669b992e412093649' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268375730, 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:\"vvkhk\";s:24:\"flash:new:requested_page\";b:0;}' WHERE session_id = 'db01ecfb536f31a669b992e412093649' |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268375730, 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:\"vvkhk\";s:24:\"flash:new:requested_page\";s:67:\"/videos/coverage/view/234300-2008-ncaa-cross-country-south-regional\";}' WHERE session_id = 'db01ecfb536f31a669b992e412093649' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268375730, 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:\"vvkhk\";s:24:\"flash:new:requested_page\";b:0;}' WHERE session_id = 'db01ecfb536f31a669b992e412093649' |
2008 NCAA Cross Country South Regional
