| 0.0005 | SELECT *
FROM (`ci_sessions`)
WHERE `session_id` = 'db01ecfb536f31a669b992e412093649'
AND last_activity > 1268203650 |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268376450, 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:\"gvhak\";s:24:\"flash:new:requested_page\";s:10:\"/dashboard\";}' WHERE session_id = 'db01ecfb536f31a669b992e412093649' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268376450, 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:\"gvhak\";s:24:\"flash:new:requested_page\";s:10:\"/dashboard\";s:24:\"flash:old:requested_page\";s:10:\"/dashboard\";}' WHERE session_id = 'db01ecfb536f31a669b992e412093649' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268376450, 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:\"gvhak\";s:24:\"flash:old:requested_page\";s:10:\"/dashboard\";}' WHERE session_id = 'db01ecfb536f31a669b992e412093649' |
| 0.0112 | SELECT *
FROM (`mini_sites_brooks`)
LIMIT 1 |
| 0.0022 | SELECT *
FROM (`banners`)
WHERE (did = '1' AND object = 'minisite' AND object_id = 3) AND publish_date <= '2010-03-12 00:47:30'
ORDER BY `publish_date` DESC, id DESC
LIMIT 10 |
| 0.0073 | SELECT *
FROM (`mini_sites_brooks_events`)
WHERE `active` = 1
ORDER BY `start_time` ASC
LIMIT 3 |
| 0.0023 | 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 01:00:00') AND (object_assoc_videos.assoc = 'coverage' AND object_assoc_videos.assoc_id = '234514')
ORDER BY `sort_order` ASC, cat_id ASC, publish_date DESC
LIMIT 4 |
| 0.0007 | SELECT *
FROM (`object_assoc_products`)
JOIN `products` ON object_assoc_products.object_id = products.id
WHERE (url1 != '' and url1 is not null) AND (object_assoc_products.assoc = 'minisite' AND object_assoc_products.assoc_id = '3')
ORDER BY RAND()
LIMIT 3 |
| 0.0007 | SELECT *
FROM (`mini_sites_brooks`)
LIMIT 1 |
| 0.0005 | SELECT *
FROM (`mini_sites_brooks_events`)
WHERE `active` = 1
ORDER BY `start_time` DESC
LIMIT 4 |
| 0.0003 | SELECT *
FROM (`app_objects`)
WHERE `object_type` = 'video' |
| 0.0023 | SHOW COLUMNS FROM videos |
| 0.1243 | SELECT users.user_name, users.first_name, users.last_name, users.name_display_mode, comments_videos.*, comments_videos.uid as comment_uid, videos.id, videos.title, videos.user_id, videos.comments_count, videos.thumb_file, videos.thumb_path, videos.thumb_ext, videos.video_source, videos.file, videos.video_table_2
FROM (`videos`)
JOIN `comments_videos` ON comments_videos.object_id = videos.id
LEFT JOIN `users` ON users.id = comments_videos.uid
JOIN `object_assoc_videos` ON object_assoc_videos.object_id = videos.id
WHERE object_assoc_videos.assoc = 'speaker'
AND object_assoc_videos.assoc_id in (691, 687, 688, 692, 689, 693, 694, 696, 701, 698, 738, 739, 129)
AND comments_videos.did = 1
AND comments_videos.flagged_count < '5'
AND videos.visible_to = 'everyone'
ORDER BY comments_videos.created_at DESC
LIMIT 20 |
| 0.0002 | SELECT `uid`
FROM (`flocasts_employees`) |
| 0.0005 | SELECT *
FROM (`contributers`)
WHERE `uid` = 0
AND `did` = 1 |
| 0.0004 | SELECT coverages.name
FROM coverages
JOIN object_assoc_videos
ON (object_assoc_videos.assoc_id = coverages.id)
WHERE object_assoc_videos.object_id = '9662' AND object_assoc_videos.assoc = 'coverage' |
| 0.0013 | SELECT * FROM videos, object_assoc_videos WHERE videos.id = object_assoc_videos.object_id AND id = '9662' ORDER BY publish_date DESC LIMIT 1 |
| 0.0007 | SELECT * FROM object_assoc_videos WHERE object_id = '9662' AND publish_date <= '2010-03-12 01:00:00' ORDER BY oid DESC |
| 0.0016 | SELECT *
FROM (`speakers`)
JOIN `object_assoc_speakers` ON object_assoc_speakers.object_id = speakers.id
WHERE `id` = '129'
AND `assoc` = 'domain'
AND `assoc_id` = 1 |
| 0.0003 | SELECT `fname`, `lname`
FROM (`speakers`)
WHERE `id` = '129' |
| 0.0006 | SELECT coverages.name
FROM coverages
JOIN object_assoc_videos
ON (object_assoc_videos.assoc_id = coverages.id)
WHERE object_assoc_videos.object_id = '13409' AND object_assoc_videos.assoc = 'coverage' |
| 0.0012 | SELECT * FROM videos, object_assoc_videos WHERE videos.id = object_assoc_videos.object_id AND id = '13409' ORDER BY publish_date DESC LIMIT 1 |
| 0.0007 | SELECT * FROM object_assoc_videos WHERE object_id = '13409' AND publish_date <= '2010-03-12 01:00:00' ORDER BY oid DESC |
| 0.0011 | SELECT *
FROM (`speakers`)
JOIN `object_assoc_speakers` ON object_assoc_speakers.object_id = speakers.id
WHERE `id` = '696'
AND `assoc` = 'domain'
AND `assoc_id` = 1 |
| 0.0003 | SELECT `fname`, `lname`
FROM (`speakers`)
WHERE `id` = '696' |
| 0.0016 | SELECT *
FROM (`object_assoc_coverages`)
JOIN `coverages` ON object_assoc_coverages.object_id = coverages.id
WHERE (id = '247') AND (object_assoc_coverages.assoc = 'domain' AND object_assoc_coverages.assoc_id = '1')
ORDER BY `publish_date` DESC |
| 0.0003 | SELECT `name`
FROM (`coverages`)
WHERE `id` = '247' |
| 0.0002 | SELECT coverages.name
FROM coverages
JOIN object_assoc_videos
ON (object_assoc_videos.assoc_id = coverages.id)
WHERE object_assoc_videos.object_id = '13409' AND object_assoc_videos.assoc = 'coverage' |
| 0.0010 | SELECT * FROM videos, object_assoc_videos WHERE videos.id = object_assoc_videos.object_id AND id = '13409' ORDER BY publish_date DESC LIMIT 1 |
| 0.0005 | SELECT * FROM object_assoc_videos WHERE object_id = '13409' AND publish_date <= '2010-03-12 01:00:00' ORDER BY oid DESC |
| 0.0009 | SELECT *
FROM (`speakers`)
JOIN `object_assoc_speakers` ON object_assoc_speakers.object_id = speakers.id
WHERE `id` = '696'
AND `assoc` = 'domain'
AND `assoc_id` = 1 |
| 0.0002 | SELECT `fname`, `lname`
FROM (`speakers`)
WHERE `id` = '696' |
| 0.0039 | SELECT *
FROM (`object_assoc_coverages`)
JOIN `coverages` ON object_assoc_coverages.object_id = coverages.id
WHERE (id = '247') AND (object_assoc_coverages.assoc = 'domain' AND object_assoc_coverages.assoc_id = '1')
ORDER BY `publish_date` DESC |
| 0.0002 | SELECT `name`
FROM (`coverages`)
WHERE `id` = '247' |
| 0.0004 | SELECT coverages.name
FROM coverages
JOIN object_assoc_videos
ON (object_assoc_videos.assoc_id = coverages.id)
WHERE object_assoc_videos.object_id = '13293' AND object_assoc_videos.assoc = 'coverage' |
| 0.0013 | SELECT * FROM videos, object_assoc_videos WHERE videos.id = object_assoc_videos.object_id AND id = '13293' ORDER BY publish_date DESC LIMIT 1 |
| 0.0007 | SELECT * FROM object_assoc_videos WHERE object_id = '13293' AND publish_date <= '2010-03-12 01:00:00' ORDER BY oid DESC |
| 0.0011 | SELECT *
FROM (`speakers`)
JOIN `object_assoc_speakers` ON object_assoc_speakers.object_id = speakers.id
WHERE `id` = '739'
AND `assoc` = 'domain'
AND `assoc_id` = 1 |
| 0.0004 | SELECT `fname`, `lname`
FROM (`speakers`)
WHERE `id` = '739' |
| 0.0013 | SELECT *
FROM (`object_assoc_coverages`)
JOIN `coverages` ON object_assoc_coverages.object_id = coverages.id
WHERE (id = '247') AND (object_assoc_coverages.assoc = 'domain' AND object_assoc_coverages.assoc_id = '1')
ORDER BY `publish_date` DESC |
| 0.0002 | SELECT `name`
FROM (`coverages`)
WHERE `id` = '247' |
| 0.0002 | SELECT coverages.name
FROM coverages
JOIN object_assoc_videos
ON (object_assoc_videos.assoc_id = coverages.id)
WHERE object_assoc_videos.object_id = '13409' AND object_assoc_videos.assoc = 'coverage' |
| 0.0018 | SELECT * FROM videos, object_assoc_videos WHERE videos.id = object_assoc_videos.object_id AND id = '13409' ORDER BY publish_date DESC LIMIT 1 |
| 0.0005 | SELECT * FROM object_assoc_videos WHERE object_id = '13409' AND publish_date <= '2010-03-12 01:00:00' ORDER BY oid DESC |
| 0.0009 | SELECT *
FROM (`speakers`)
JOIN `object_assoc_speakers` ON object_assoc_speakers.object_id = speakers.id
WHERE `id` = '696'
AND `assoc` = 'domain'
AND `assoc_id` = 1 |
| 0.0002 | SELECT `fname`, `lname`
FROM (`speakers`)
WHERE `id` = '696' |
| 0.0013 | SELECT *
FROM (`object_assoc_coverages`)
JOIN `coverages` ON object_assoc_coverages.object_id = coverages.id
WHERE (id = '247') AND (object_assoc_coverages.assoc = 'domain' AND object_assoc_coverages.assoc_id = '1')
ORDER BY `publish_date` DESC |
| 0.0002 | SELECT `name`
FROM (`coverages`)
WHERE `id` = '247' |
| 0.0004 | SELECT coverages.name
FROM coverages
JOIN object_assoc_videos
ON (object_assoc_videos.assoc_id = coverages.id)
WHERE object_assoc_videos.object_id = '13406' AND object_assoc_videos.assoc = 'coverage' |
| 0.0013 | SELECT * FROM videos, object_assoc_videos WHERE videos.id = object_assoc_videos.object_id AND id = '13406' ORDER BY publish_date DESC LIMIT 1 |
| 0.0007 | SELECT * FROM object_assoc_videos WHERE object_id = '13406' AND publish_date <= '2010-03-12 01:00:00' ORDER BY oid DESC |
| 0.0024 | SELECT *
FROM (`speakers`)
JOIN `object_assoc_speakers` ON object_assoc_speakers.object_id = speakers.id
WHERE `id` = '698'
AND `assoc` = 'domain'
AND `assoc_id` = 1 |
| 0.0003 | SELECT `fname`, `lname`
FROM (`speakers`)
WHERE `id` = '698' |
| 0.0013 | SELECT *
FROM (`object_assoc_coverages`)
JOIN `coverages` ON object_assoc_coverages.object_id = coverages.id
WHERE (id = '247') AND (object_assoc_coverages.assoc = 'domain' AND object_assoc_coverages.assoc_id = '1')
ORDER BY `publish_date` DESC |
| 0.0002 | SELECT `name`
FROM (`coverages`)
WHERE `id` = '247' |
| 0.0011 | SELECT coverages.name
FROM coverages
JOIN object_assoc_videos
ON (object_assoc_videos.assoc_id = coverages.id)
WHERE object_assoc_videos.object_id = '13406' AND object_assoc_videos.assoc = 'coverage' |
| 0.0044 | SELECT * FROM videos, object_assoc_videos WHERE videos.id = object_assoc_videos.object_id AND id = '13406' ORDER BY publish_date DESC LIMIT 1 |
| 0.0005 | SELECT * FROM object_assoc_videos WHERE object_id = '13406' AND publish_date <= '2010-03-12 01:00:00' ORDER BY oid DESC |
| 0.0009 | SELECT *
FROM (`speakers`)
JOIN `object_assoc_speakers` ON object_assoc_speakers.object_id = speakers.id
WHERE `id` = '698'
AND `assoc` = 'domain'
AND `assoc_id` = 1 |
| 0.0009 | SELECT `fname`, `lname`
FROM (`speakers`)
WHERE `id` = '698' |
| 0.0013 | SELECT *
FROM (`object_assoc_coverages`)
JOIN `coverages` ON object_assoc_coverages.object_id = coverages.id
WHERE (id = '247') AND (object_assoc_coverages.assoc = 'domain' AND object_assoc_coverages.assoc_id = '1')
ORDER BY `publish_date` DESC |
| 0.0002 | SELECT `name`
FROM (`coverages`)
WHERE `id` = '247' |
| 0.0002 | SELECT coverages.name
FROM coverages
JOIN object_assoc_videos
ON (object_assoc_videos.assoc_id = coverages.id)
WHERE object_assoc_videos.object_id = '13293' AND object_assoc_videos.assoc = 'coverage' |
| 0.0024 | SELECT * FROM videos, object_assoc_videos WHERE videos.id = object_assoc_videos.object_id AND id = '13293' ORDER BY publish_date DESC LIMIT 1 |
| 0.0031 | SELECT * FROM object_assoc_videos WHERE object_id = '13293' AND publish_date <= '2010-03-12 01:00:00' ORDER BY oid DESC |
| 0.0028 | SELECT *
FROM (`speakers`)
JOIN `object_assoc_speakers` ON object_assoc_speakers.object_id = speakers.id
WHERE `id` = '739'
AND `assoc` = 'domain'
AND `assoc_id` = 1 |
| 0.0045 | SELECT `fname`, `lname`
FROM (`speakers`)
WHERE `id` = '739' |
| 0.0013 | SELECT *
FROM (`object_assoc_coverages`)
JOIN `coverages` ON object_assoc_coverages.object_id = coverages.id
WHERE (id = '247') AND (object_assoc_coverages.assoc = 'domain' AND object_assoc_coverages.assoc_id = '1')
ORDER BY `publish_date` DESC |
| 0.0002 | SELECT `name`
FROM (`coverages`)
WHERE `id` = '247' |
| 0.0005 | SELECT coverages.name
FROM coverages
JOIN object_assoc_videos
ON (object_assoc_videos.assoc_id = coverages.id)
WHERE object_assoc_videos.object_id = '7448' AND object_assoc_videos.assoc = 'coverage' |
| 0.0013 | SELECT * FROM videos, object_assoc_videos WHERE videos.id = object_assoc_videos.object_id AND id = '7448' ORDER BY publish_date DESC LIMIT 1 |
| 0.0007 | SELECT * FROM object_assoc_videos WHERE object_id = '7448' AND publish_date <= '2010-03-12 01:00:00' ORDER BY oid DESC |
| 0.0009 | SELECT *
FROM (`speakers`)
JOIN `object_assoc_speakers` ON object_assoc_speakers.object_id = speakers.id
WHERE `id` = '696'
AND `assoc` = 'domain'
AND `assoc_id` = 1 |
| 0.0002 | SELECT `fname`, `lname`
FROM (`speakers`)
WHERE `id` = '696' |
| 0.0015 | SELECT *
FROM (`object_assoc_coverages`)
JOIN `coverages` ON object_assoc_coverages.object_id = coverages.id
WHERE (id = '155') AND (object_assoc_coverages.assoc = 'domain' AND object_assoc_coverages.assoc_id = '1')
ORDER BY `publish_date` DESC |
| 0.0003 | SELECT `name`
FROM (`coverages`)
WHERE `id` = '155' |
| 0.0003 | SELECT coverages.name
FROM coverages
JOIN object_assoc_videos
ON (object_assoc_videos.assoc_id = coverages.id)
WHERE object_assoc_videos.object_id = '9662' AND object_assoc_videos.assoc = 'coverage' |
| 0.0010 | SELECT * FROM videos, object_assoc_videos WHERE videos.id = object_assoc_videos.object_id AND id = '9662' ORDER BY publish_date DESC LIMIT 1 |
| 0.0005 | SELECT * FROM object_assoc_videos WHERE object_id = '9662' AND publish_date <= '2010-03-12 01:00:00' ORDER BY oid DESC |
| 0.0009 | SELECT *
FROM (`speakers`)
JOIN `object_assoc_speakers` ON object_assoc_speakers.object_id = speakers.id
WHERE `id` = '129'
AND `assoc` = 'domain'
AND `assoc_id` = 1 |
| 0.0002 | SELECT `fname`, `lname`
FROM (`speakers`)
WHERE `id` = '129' |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268376450, 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:17:\"FreakAuth_captcha\";s:5:\"gvhak\";s:24:\"flash:old:requested_page\";s:10:\"/dashboard\";s:24:\"flash:new:requested_page\";s:7:\"/brooks\";}' WHERE session_id = 'db01ecfb536f31a669b992e412093649' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268376450, 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:17:\"FreakAuth_captcha\";s:5:\"gvhak\";s:24:\"flash:old:requested_page\";s:10:\"/dashboard\";s:24:\"flash:new:requested_page\";s:10:\"/dashboard\";}' WHERE session_id = 'db01ecfb536f31a669b992e412093649' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268376450, 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:17:\"FreakAuth_captcha\";s:5:\"gvhak\";s:24:\"flash:old:requested_page\";s:10:\"/dashboard\";s:24:\"flash:new:requested_page\";s:7:\"/brooks\";}' WHERE session_id = 'db01ecfb536f31a669b992e412093649' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268376450, 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:17:\"FreakAuth_captcha\";s:5:\"gvhak\";s:24:\"flash:old:requested_page\";s:10:\"/dashboard\";s:24:\"flash:new:requested_page\";s:10:\"/dashboard\";}' WHERE session_id = 'db01ecfb536f31a669b992e412093649' |