| 0.0006 | SELECT *
FROM (`ci_sessions`)
WHERE `session_id` = 'db01ecfb536f31a669b992e412093649'
AND last_activity > 1268203808 |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268376608, 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 = 1268376608, 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 = 1268376608, 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.0041 | SELECT *
FROM (`object_assoc_coverages`)
JOIN `coverages` ON object_assoc_coverages.object_id = coverages.id
WHERE (start_date <= '2010-03-12 01:00:00') AND (object_assoc_coverages.assoc = 'domain' AND object_assoc_coverages.assoc_id = '1')
ORDER BY `publish_date` DESC
LIMIT 7 |
| 0.1815 | SELECT DISTINCT s_assoc.object_id, s_assoc.*, videos.*, s_assoc.assoc_id as sid
FROM object_assoc_videos as domains
JOIN videos ON videos.id = domains.object_id
JOIN object_assoc_videos as s_assoc ON s_assoc.object_id = domains.object_id
WHERE domains.assoc = 'domain' AND domains.assoc_id = '1' AND s_assoc.assoc = 'speaker'
AND s_assoc.assoc_id != '0'
AND s_assoc.publish_date <= '2010-03-12 01:00:00'
GROUP BY s_assoc.object_id
ORDER BY s_assoc.publish_date DESC
LIMIT 7 |
| 0.0524 | SELECT *
FROM (`object_assoc_videos`)
JOIN `videos` ON object_assoc_videos.object_id = videos.id
WHERE (video_type = 'user' AND video_source != 'youtube' AND publish_date <= '2010-03-12 01:00:00' and visible_to = 'everyone') AND (object_assoc_videos.assoc = 'domain' AND object_assoc_videos.assoc_id = '1')
ORDER BY `publish_date` DESC
LIMIT 7 |
| 0.0008 | SELECT * FROM object_assoc_videos WHERE object_id = '99532' AND publish_date <= '2010-03-12 01:00:00' ORDER BY oid DESC |
| 0.0005 | SELECT * FROM object_assoc_videos WHERE object_id = '98344' AND publish_date <= '2010-03-12 01:00:00' ORDER BY oid DESC |
| 0.0005 | SELECT * FROM object_assoc_videos WHERE object_id = '98324' AND publish_date <= '2010-03-12 01:00:00' ORDER BY oid DESC |
| 0.0005 | SELECT * FROM object_assoc_videos WHERE object_id = '98313' AND publish_date <= '2010-03-12 01:00:00' ORDER BY oid DESC |
| 0.0005 | SELECT * FROM object_assoc_videos WHERE object_id = '96078' AND publish_date <= '2010-03-12 01:00:00' ORDER BY oid DESC |
| 0.0009 | SELECT * FROM object_assoc_videos WHERE object_id = '96130' AND publish_date <= '2010-03-12 01:00:00' ORDER BY oid DESC |
| 0.0007 | SELECT * FROM object_assoc_videos WHERE object_id = '96127' AND publish_date <= '2010-03-12 01:00:00' ORDER BY oid DESC |
| 0.0005 | SELECT * FROM object_assoc_videos WHERE object_id = '100245' AND publish_date <= '2010-03-12 01:00:00' ORDER BY oid DESC |
| 0.0005 | SELECT * FROM object_assoc_videos WHERE object_id = '100244' AND publish_date <= '2010-03-12 01:00:00' ORDER BY oid DESC |
| 0.0005 | SELECT * FROM object_assoc_videos WHERE object_id = '100243' AND publish_date <= '2010-03-12 01:00:00' ORDER BY oid DESC |
| 0.0008 | SELECT * FROM object_assoc_videos WHERE object_id = '100242' AND publish_date <= '2010-03-12 01:00:00' ORDER BY oid DESC |
| 0.0007 | SELECT * FROM object_assoc_videos WHERE object_id = '100241' AND publish_date <= '2010-03-12 01:00:00' ORDER BY oid DESC |
| 0.0007 | SELECT * FROM object_assoc_videos WHERE object_id = '100240' AND publish_date <= '2010-03-12 01:00:00' ORDER BY oid DESC |
| 0.0007 | SELECT * FROM object_assoc_videos WHERE object_id = '100239' AND publish_date <= '2010-03-12 01:00:00' ORDER BY oid DESC |
| 0.0005 | UPDATE ci_sessions SET last_activity = 1268376608, 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:\"/videos\";}' WHERE session_id = 'db01ecfb536f31a669b992e412093649' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268376608, 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 = 1268376608, 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:\"/videos\";}' WHERE session_id = 'db01ecfb536f31a669b992e412093649' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268376608, 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' |