| 0.0006 | SELECT *
FROM (`ci_sessions`)
WHERE `session_id` = '38886bef441d23c0ad0a7489b4af35a2'
AND last_activity > 1268085695 |
| 0.0005 | UPDATE ci_sessions SET last_activity = 1268258495, 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:\"coidx\";s:24:\"flash:new:requested_page\";b:0;}' WHERE session_id = '38886bef441d23c0ad0a7489b4af35a2' |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268258495, 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:\"coidx\";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 = 1268258495, 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:\"coidx\";s:24:\"flash:old:requested_page\";b:0;}' WHERE session_id = '38886bef441d23c0ad0a7489b4af35a2' |
| 0.0010 | SELECT * FROM object_assoc_videos WHERE object_id = '98344' AND publish_date <= '2010-03-10 16:15:00' AND object_assoc_videos.assoc != 'domain' AND object_assoc_videos.assoc_id != '1681' ORDER BY oid DESC |
| 0.0014 | UPDATE videos SET views = views + 1 WHERE id = '98344' LIMIT 1 |
| 0.0023 | SHOW COLUMNS FROM videos |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268258495, 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.0008 | UPDATE ci_sessions SET last_activity = 1268258495, 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:\"yunuh\";}' WHERE session_id = '38886bef441d23c0ad0a7489b4af35a2' |
| 0.0005 | SELECT *
FROM (`ratings`)
WHERE `id` = '98344'
AND `type` = 'video' |
| 0.0005 | SELECT `used_ips`
FROM (`ratings`)
WHERE `id` = '98344'
AND `type` = 'video' AND `used_ips` LIKE '%38.107.191.105%' |
| 0.0003 | SELECT id FROM favorites WHERE uid = '' AND domain = '1' AND object_id = '98344' AND object_type = 'video' |
| 0.0032 | SELECT uid FROM favorites JOIN accounts ON accounts.user_id = favorites.uid WHERE object_type = 'video' AND object_id = '98344' AND accounts.did = '1' |
| 0.0003 | SELECT `uid`
FROM (`flocasts_employees`) |
| 0.0005 | SELECT *
FROM (`contributers`)
WHERE `uid` = 0
AND `did` = 1 |
| 0.0026 | SELECT * FROM videos, object_assoc_videos WHERE videos.id = object_assoc_videos.object_id AND id = '98344' ORDER BY publish_date DESC LIMIT 1 |
| 0.0003 | SELECT *
FROM (`app_objects`)
WHERE `object_type` = 'video' |
| 0.0005 | SELECT `assoc_id`
FROM (`object_assoc_videos`)
WHERE object_assoc_videos.assoc = 'speaker' AND object_assoc_videos.object_id = '98344' |
| 0.0003 | SELECT *
FROM (`app_objects`)
WHERE `object_type` = 'speaker' |
| 0.0006 | SELECT `assoc_id`
FROM (`object_assoc_speakers`)
WHERE object_assoc_speakers.assoc = 'domain' AND object_assoc_speakers.object_id = '1681' |
| 0.0003 | SELECT *
FROM (`app_objects`)
WHERE `object_type` = 'speaker' |
| 0.0004 | SELECT `assoc_id`
FROM (`object_assoc_speakers`)
WHERE object_assoc_speakers.assoc = 'domain' AND object_assoc_speakers.object_id = '1812' |
| 0.0003 | SELECT *
FROM (`app_objects`)
WHERE `object_type` = 'speaker' |
| 0.0004 | SELECT `assoc_id`
FROM (`object_assoc_speakers`)
WHERE object_assoc_speakers.assoc = 'domain' AND object_assoc_speakers.object_id = '2141' |
| 0.0003 | SELECT *
FROM (`app_objects`)
WHERE `object_type` = 'video' |
| 0.0005 | SELECT `assoc_id`
FROM (`object_assoc_videos`)
WHERE object_assoc_videos.assoc = 'coverage' AND object_assoc_videos.object_id = '98344' |
| 0.0003 | SELECT *
FROM (`app_objects`)
WHERE `object_type` = 'coverage' |
| 0.0002 | SELECT `assoc_id`
FROM (`object_assoc_coverages`)
WHERE object_assoc_coverages.assoc = 'domain' AND object_assoc_coverages.object_id = '234381' |
| 0.0005 | UPDATE ci_sessions SET last_activity = 1268258495, 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:\"yunuh\";s:24:\"flash:new:requested_page\";s:83:\"/videos/speaker/1681-solomon-haile/98344-full-flcc-boys-championship-better-quality\";}' WHERE session_id = '38886bef441d23c0ad0a7489b4af35a2' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268258495, 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:\"yunuh\";s:24:\"flash:new:requested_page\";b:0;}' WHERE session_id = '38886bef441d23c0ad0a7489b4af35a2' |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268258495, 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:\"yunuh\";s:24:\"flash:new:requested_page\";s:83:\"/videos/speaker/1681-solomon-haile/98344-full-flcc-boys-championship-better-quality\";}' WHERE session_id = '38886bef441d23c0ad0a7489b4af35a2' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268258495, 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:\"yunuh\";s:24:\"flash:new:requested_page\";b:0;}' WHERE session_id = '38886bef441d23c0ad0a7489b4af35a2' |