| 0.0006 | SELECT *
FROM (`ci_sessions`)
WHERE `session_id` = '0299171dfb0517baccecf8546dd2f80c'
AND last_activity > 1268252421 |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268425221, 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:18:\"track_race_options\";a:4:{s:5:\"level\";s:0:\"\";s:6:\"gender\";s:0:\"\";s:10:\"event_name\";s:0:\"\";s:9:\"meet_name\";s:0:\"\";}s:24:\"flash:old:requested_page\";b:0;}' WHERE session_id = '0299171dfb0517baccecf8546dd2f80c' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268425221, 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:3:{s:7:\"user_id\";i:0;s:8:\"sess_did\";i:0;s:18:\"track_race_options\";a:4:{s:5:\"level\";s:0:\"\";s:6:\"gender\";s:0:\"\";s:10:\"event_name\";s:0:\"\";s:9:\"meet_name\";s:0:\"\";}}' WHERE session_id = '0299171dfb0517baccecf8546dd2f80c' |
| 0.0016 | SELECT * FROM videos, object_assoc_videos WHERE videos.id = object_assoc_videos.object_id AND id = '99958' ORDER BY publish_date DESC LIMIT 1 |
| 0.0017 | SELECT *
FROM (`videos`)
JOIN `object_assoc_videos` ON object_assoc_videos.object_id = videos.id
WHERE `id` = 99958
AND `assoc` = 'domain'
AND `assoc_id` = 1 |
| 0.0009 | SELECT *
FROM (`users`)
WHERE `id` = '59662' |
| 0.0008 | SELECT *
FROM (`tagged`)
JOIN `tags` ON tags.tag_id = tagged.f_tag_id
WHERE tagged.object_type = 'video'
AND tagged.object_id = 99958
AND tagged.did = 1
AND `tagged_uid` = 0
ORDER BY tagged.tagged_at DESC |
| 0.0003 | SELECT id FROM favorites WHERE uid = '' AND domain = '1' AND object_id = 99958 AND object_type = 'video' |
| 0.0025 | SELECT uid FROM favorites JOIN accounts ON accounts.user_id = favorites.uid WHERE object_type = 'video' AND object_id = 99958 AND accounts.did = '1' |
| 0.0006 | SELECT *
FROM (`tagged`)
JOIN `tags` ON tags.tag_id = tagged.f_tag_id
WHERE tagged.object_type = 'video'
AND tagged.object_id = 99958
AND tagged.did = 1
AND tagged_uid != 0
ORDER BY tagged.tagged_at DESC |
| 0.0054 | SELECT *
FROM (`ratings`)
WHERE `id` = 99958
AND `type` = 'video' |
| 0.0004 | SELECT `used_ips`
FROM (`ratings`)
WHERE `id` = 99958
AND `type` = 'video' AND `used_ips` LIKE '%38.107.191.108%' |
| 0.0003 | SELECT *
FROM (`app_objects`)
WHERE `object_type` = 'video' |
| 0.0030 | SHOW COLUMNS FROM videos |
| 0.0009 | SELECT *
FROM (`videos`)
WHERE `id` = 99958 |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268425221, 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:18:\"track_race_options\";a:4:{s:5:\"level\";s:0:\"\";s:6:\"gender\";s:0:\"\";s:10:\"event_name\";s:0:\"\";s:9:\"meet_name\";s:0:\"\";}}' WHERE session_id = '0299171dfb0517baccecf8546dd2f80c' |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268425221, 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:18:\"track_race_options\";a:4:{s:5:\"level\";s:0:\"\";s:6:\"gender\";s:0:\"\";s:10:\"event_name\";s:0:\"\";s:9:\"meet_name\";s:0:\"\";}s:17:\"FreakAuth_captcha\";s:5:\"temzt\";}' WHERE session_id = '0299171dfb0517baccecf8546dd2f80c' |
| 0.0003 | SELECT *
FROM (`app_objects`)
WHERE `object_type` = 'video' |
| 0.0020 | SELECT *
FROM (`comments_videos`)
LEFT JOIN `users` ON users.id=comments_videos.uid
WHERE (object_id = '99958' AND flagged_count < '5')
ORDER BY `created_at` DESC |
| 0.0007 | SELECT * FROM object_assoc_videos WHERE object_id = '99958' AND publish_date <= '2010-03-12 14:30:00' AND object_assoc_videos.assoc != 'domain' ORDER BY oid DESC |
| 0.0007 | SELECT COUNT(*) AS `numrows`
FROM (`object_assoc_videos`)
JOIN `videos` ON object_assoc_videos.object_id = videos.id
WHERE `video_type` = 'user' AND user_id = '59662' and id != 99958 AND (visible_to = 'everyone' ) AND object_assoc_videos.assoc = 'domain' AND object_assoc_videos.assoc_id = '1' |
| 0.0028 | SELECT *
FROM (`object_assoc_videos`)
JOIN `videos` ON object_assoc_videos.object_id = videos.id
WHERE (video_type = 'user' AND user_id = '59662' and id != 99958 AND (visible_to = 'everyone' )) AND (object_assoc_videos.assoc = 'domain' AND object_assoc_videos.assoc_id = '1')
ORDER BY `publish_date` DESC
LIMIT 12 |
| 0.0007 | SELECT * FROM object_assoc_videos WHERE object_id = '99970' AND publish_date <= '2010-03-12 14:30:00' ORDER BY oid DESC |
| 0.0007 | SELECT * FROM object_assoc_videos WHERE object_id = '99969' AND publish_date <= '2010-03-12 14:30:00' ORDER BY oid DESC |
| 0.0006 | SELECT * FROM object_assoc_videos WHERE object_id = '99951' AND publish_date <= '2010-03-12 14:30:00' ORDER BY oid DESC |
| 0.0007 | SELECT * FROM object_assoc_videos WHERE object_id = '99950' AND publish_date <= '2010-03-12 14:30:00' ORDER BY oid DESC |
| 0.0006 | SELECT * FROM object_assoc_videos WHERE object_id = '99949' AND publish_date <= '2010-03-12 14:30:00' ORDER BY oid DESC |
| 0.0006 | SELECT * FROM object_assoc_videos WHERE object_id = '99948' AND publish_date <= '2010-03-12 14:30:00' ORDER BY oid DESC |
| 0.0007 | SELECT * FROM object_assoc_videos WHERE object_id = '99947' AND publish_date <= '2010-03-12 14:30:00' ORDER BY oid DESC |
| 0.0006 | SELECT * FROM object_assoc_videos WHERE object_id = '99946' AND publish_date <= '2010-03-12 14:30:00' ORDER BY oid DESC |
| 0.0007 | SELECT * FROM object_assoc_videos WHERE object_id = '99945' AND publish_date <= '2010-03-12 14:30:00' ORDER BY oid DESC |
| 0.0007 | SELECT * FROM object_assoc_videos WHERE object_id = '99944' AND publish_date <= '2010-03-12 14:30:00' ORDER BY oid DESC |
| 0.0007 | SELECT * FROM object_assoc_videos WHERE object_id = '99943' AND publish_date <= '2010-03-12 14:30:00' ORDER BY oid DESC |
| 0.0006 | SELECT * FROM object_assoc_videos WHERE object_id = '99942' AND publish_date <= '2010-03-12 14:30:00' ORDER BY oid DESC |
| 0.0002 | SELECT `uid`
FROM (`flocasts_employees`) |
| 0.0005 | SELECT *
FROM (`contributers`)
WHERE `uid` = 0
AND `did` = 1 |
| 0.0009 | SELECT * FROM videos, object_assoc_videos WHERE videos.id = object_assoc_videos.object_id AND id = '99958' ORDER BY publish_date DESC LIMIT 1 |
| 0.0006 | SELECT *
FROM (`app_objects`)
WHERE `object_type` = 'video' |
| 0.0003 | SELECT `assoc_id`
FROM (`object_assoc_videos`)
WHERE object_assoc_videos.assoc = 'speaker' AND object_assoc_videos.object_id = '99958' |
| 0.0003 | SELECT *
FROM (`app_objects`)
WHERE `object_type` = 'video' |
| 0.0008 | SELECT `assoc_id`
FROM (`object_assoc_videos`)
WHERE object_assoc_videos.assoc = 'coverage' AND object_assoc_videos.object_id = '99958' |
| 0.0005 | UPDATE ci_sessions SET last_activity = 1268425221, 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:18:\"track_race_options\";a:4:{s:5:\"level\";s:0:\"\";s:6:\"gender\";s:0:\"\";s:10:\"event_name\";s:0:\"\";s:9:\"meet_name\";s:0:\"\";}s:17:\"FreakAuth_captcha\";s:5:\"temzt\";s:24:\"flash:new:requested_page\";s:24:\"/videos/play/99958-video\";}' WHERE session_id = '0299171dfb0517baccecf8546dd2f80c' |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268425221, 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:18:\"track_race_options\";a:4:{s:5:\"level\";s:0:\"\";s:6:\"gender\";s:0:\"\";s:10:\"event_name\";s:0:\"\";s:9:\"meet_name\";s:0:\"\";}s:17:\"FreakAuth_captcha\";s:5:\"temzt\";s:24:\"flash:new:requested_page\";b:0;}' WHERE session_id = '0299171dfb0517baccecf8546dd2f80c' |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268425221, 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:18:\"track_race_options\";a:4:{s:5:\"level\";s:0:\"\";s:6:\"gender\";s:0:\"\";s:10:\"event_name\";s:0:\"\";s:9:\"meet_name\";s:0:\"\";}s:17:\"FreakAuth_captcha\";s:5:\"temzt\";s:24:\"flash:new:requested_page\";s:24:\"/videos/play/99958-video\";}' WHERE session_id = '0299171dfb0517baccecf8546dd2f80c' |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268425221, 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:18:\"track_race_options\";a:4:{s:5:\"level\";s:0:\"\";s:6:\"gender\";s:0:\"\";s:10:\"event_name\";s:0:\"\";s:9:\"meet_name\";s:0:\"\";}s:17:\"FreakAuth_captcha\";s:5:\"temzt\";s:24:\"flash:new:requested_page\";b:0;}' WHERE session_id = '0299171dfb0517baccecf8546dd2f80c' |
