| 0.0005 | SELECT *
FROM (`ci_sessions`)
WHERE `session_id` = '0299171dfb0517baccecf8546dd2f80c'
AND last_activity > 1268251588 |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268424388, 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:24:\"flash:new:requested_page\";b:0;s:24:\"flash:old:requested_page\";b:0;}' WHERE session_id = '0299171dfb0517baccecf8546dd2f80c' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268424388, 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:24:\"flash:old:requested_page\";b:0;}' WHERE session_id = '0299171dfb0517baccecf8546dd2f80c' |
| 0.0155 | SELECT blogs.*, `publish_date`
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (is_official = '1' AND flagged_count <=5 and publish_date <= '2010-03-12 14:06:28') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
ORDER BY object_assoc_blogs.publish_date DESC
LIMIT 10 |
| 0.0116 | SELECT blogs.*, `publish_date`
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (is_official = '0' AND flagged_count <=5 and publish_date <= '2010-03-12 14:06:28') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
ORDER BY object_assoc_blogs.publish_date DESC
LIMIT 9 |
| 0.0129 | SELECT blogs.id, blogs.uid, blogs.title, blogs.old_format, `publish_date`
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (is_official = '1' AND flagged_count <=5 and publish_date <= '2010-03-12 14:06:28') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
ORDER BY object_assoc_blogs.publish_date DESC
LIMIT 12 |
| 0.0114 | SELECT blogs.id, blogs.uid, blogs.title, blogs.old_format, `publish_date`
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (is_official = '0' AND flagged_count <=5 and publish_date <= '2010-03-12 14:06:28') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
ORDER BY object_assoc_blogs.publish_date DESC
LIMIT 12 |
| 0.0019 | SELECT bloggers.uid, users.first_name, users.last_name, users.user_name
FROM (`bloggers`)
JOIN `users` ON bloggers.uid = users.id
WHERE bloggers.domain = '1'
ORDER BY users.last_name ASC |
| 0.0104 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
ORDER BY object_assoc_blogs.publish_date ASC
LIMIT 1 |
| 0.0015 | SELECT `uid`
FROM (`flocasts_employees`) |
| 0.0005 | SELECT *
FROM (`contributers`)
WHERE `uid` = 0
AND `did` = 1 |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '35583' |
| 0.0007 | SELECT *
FROM (`photos`)
WHERE `uid` = '35583'
AND `profile_default` = 1 |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '35583' |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '18315' |
| 0.0007 | SELECT *
FROM (`photos`)
WHERE `uid` = '18315'
AND `profile_default` = 1 |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '18315' |
| 0.0009 | SELECT *
FROM (`users`)
WHERE `id` = '64831' |
| 0.0006 | SELECT *
FROM (`photos`)
WHERE `uid` = '64831'
AND `profile_default` = 1 |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '64831' |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '12942' |
| 0.0008 | SELECT *
FROM (`photos`)
WHERE `uid` = '12942'
AND `profile_default` = 1 |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '12942' |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '21' |
| 0.0014 | SELECT *
FROM (`photos`)
WHERE `uid` = '21'
AND `profile_default` = 1 |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '21' |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '61373' |
| 0.0006 | SELECT *
FROM (`photos`)
WHERE `uid` = '61373'
AND `profile_default` = 1 |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '61373' |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '64830' |
| 0.0006 | SELECT *
FROM (`photos`)
WHERE `uid` = '64830'
AND `profile_default` = 1 |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '64830' |
| 0.0009 | SELECT *
FROM (`users`)
WHERE `id` = '20374' |
| 0.0040 | SELECT *
FROM (`photos`)
WHERE `uid` = '20374'
AND `profile_default` = 1 |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '20374' |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '18315' |
| 0.0005 | SELECT *
FROM (`photos`)
WHERE `uid` = '18315'
AND `profile_default` = 1 |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '18315' |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '64830' |
| 0.0005 | SELECT *
FROM (`photos`)
WHERE `uid` = '64830'
AND `profile_default` = 1 |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '64830' |
| 0.0009 | SELECT *
FROM (`users`)
WHERE `id` = '15774' |
| 0.0009 | SELECT *
FROM (`photos`)
WHERE `uid` = '15774'
AND `profile_default` = 1 |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '15774' |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '71038' |
| 0.0006 | SELECT *
FROM (`photos`)
WHERE `uid` = '71038'
AND `profile_default` = 1 |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '71038' |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '69316' |
| 0.0005 | SELECT *
FROM (`photos`)
WHERE `uid` = '69316'
AND `profile_default` = 1 |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '69316' |
| 0.0009 | SELECT *
FROM (`users`)
WHERE `id` = '46131' |
| 0.0006 | SELECT *
FROM (`photos`)
WHERE `uid` = '46131'
AND `profile_default` = 1 |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '46131' |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '76927' |
| 0.0005 | SELECT *
FROM (`photos`)
WHERE `uid` = '76927'
AND `profile_default` = 1 |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '76927' |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '75257' |
| 0.0011 | SELECT *
FROM (`photos`)
WHERE `uid` = '75257'
AND `profile_default` = 1 |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '75257' |
| 0.0013 | SELECT *
FROM (`users`)
WHERE `id` = '76589' |
| 0.0005 | SELECT *
FROM (`photos`)
WHERE `uid` = '76589'
AND `profile_default` = 1 |
| 0.0007 | SELECT *
FROM (`users`)
WHERE `id` = '76589' |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '77196' |
| 0.0012 | SELECT *
FROM (`photos`)
WHERE `uid` = '77196'
AND `profile_default` = 1 |
| 0.0013 | SELECT *
FROM (`users`)
WHERE `id` = '77196' |
| 0.0009 | SELECT *
FROM (`users`)
WHERE `id` = '21858' |
| 0.0006 | SELECT *
FROM (`photos`)
WHERE `uid` = '21858'
AND `profile_default` = 1 |
| 0.0008 | SELECT *
FROM (`users`)
WHERE `id` = '21858' |
| 0.0109 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2010-03-01 00:00:00' AND publish_date < '2010-04-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0108 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2010-02-01 00:00:00' AND publish_date < '2010-03-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0104 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2010-01-01 00:00:00' AND publish_date < '2010-02-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0087 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2009-12-01 00:00:00' AND publish_date < '2010-01-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0082 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2009-11-01 00:00:00' AND publish_date < '2009-12-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0093 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2009-10-01 00:00:00' AND publish_date < '2009-11-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0092 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2009-09-01 00:00:00' AND publish_date < '2009-10-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0102 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2009-08-01 00:00:00' AND publish_date < '2009-09-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0085 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2009-07-01 00:00:00' AND publish_date < '2009-08-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0096 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2009-06-01 00:00:00' AND publish_date < '2009-07-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0105 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2009-05-01 00:00:00' AND publish_date < '2009-06-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0113 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2009-04-01 00:00:00' AND publish_date < '2009-05-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0098 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2009-03-01 00:00:00' AND publish_date < '2009-04-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0104 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2009-02-01 00:00:00' AND publish_date < '2009-03-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0104 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2009-01-01 00:00:00' AND publish_date < '2009-02-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0083 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2008-12-01 00:00:00' AND publish_date < '2009-01-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0082 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2008-11-01 00:00:00' AND publish_date < '2008-12-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0013 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2008-10-01 00:00:00' AND publish_date < '2008-11-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0034 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2008-09-01 00:00:00' AND publish_date < '2008-10-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0020 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2008-08-01 00:00:00' AND publish_date < '2008-09-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0045 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2008-07-01 00:00:00' AND publish_date < '2008-08-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0009 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2008-06-01 00:00:00' AND publish_date < '2008-07-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0050 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2008-05-01 00:00:00' AND publish_date < '2008-06-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0045 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2008-04-01 00:00:00' AND publish_date < '2008-05-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0036 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2008-03-01 00:00:00' AND publish_date < '2008-04-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0036 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2008-02-01 00:00:00' AND publish_date < '2008-03-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0024 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2008-01-01 00:00:00' AND publish_date < '2008-02-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0024 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2007-12-01 00:00:00' AND publish_date < '2008-01-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0012 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2007-11-01 00:00:00' AND publish_date < '2007-12-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0012 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2007-10-01 00:00:00' AND publish_date < '2007-11-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0006 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2007-09-01 00:00:00' AND publish_date < '2007-10-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0007 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2007-08-01 00:00:00' AND publish_date < '2007-09-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0008 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2007-07-01 00:00:00' AND publish_date < '2007-08-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0006 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2007-06-01 00:00:00' AND publish_date < '2007-07-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0012 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2007-05-01 00:00:00' AND publish_date < '2007-06-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0006 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2007-04-01 00:00:00' AND publish_date < '2007-05-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0006 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2007-03-01 00:00:00' AND publish_date < '2007-04-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0004 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2007-02-01 00:00:00' AND publish_date < '2007-03-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0004 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2007-01-01 00:00:00' AND publish_date < '2007-02-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0004 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2006-12-01 00:00:00' AND publish_date < '2007-01-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0005 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2006-11-01 00:00:00' AND publish_date < '2006-12-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0007 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2006-10-01 00:00:00' AND publish_date < '2006-11-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0087 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2006-09-01 00:00:00' AND publish_date < '2006-10-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0004 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2006-08-01 00:00:00' AND publish_date < '2006-09-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0085 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2006-07-01 00:00:00' AND publish_date < '2006-08-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0004 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2006-06-01 00:00:00' AND publish_date < '2006-07-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0085 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2006-05-01 00:00:00' AND publish_date < '2006-06-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0086 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2006-04-01 00:00:00' AND publish_date < '2006-05-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0085 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2006-03-01 00:00:00' AND publish_date < '2006-04-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0085 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2006-02-01 00:00:00' AND publish_date < '2006-03-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0084 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2006-01-01 00:00:00' AND publish_date < '2006-02-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0084 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2005-12-01 00:00:00' AND publish_date < '2006-01-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0004 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2005-11-01 00:00:00' AND publish_date < '2005-12-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0084 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2005-10-01 00:00:00' AND publish_date < '2005-11-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0084 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2005-09-01 00:00:00' AND publish_date < '2005-10-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0083 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2005-08-01 00:00:00' AND publish_date < '2005-09-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0087 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2005-07-01 00:00:00' AND publish_date < '2005-08-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0084 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2005-06-01 00:00:00' AND publish_date < '2005-07-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0105 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2005-05-01 00:00:00' AND publish_date < '2005-06-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0004 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2005-04-01 00:00:00' AND publish_date < '2005-05-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0084 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2005-03-01 00:00:00' AND publish_date < '2005-04-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0086 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2005-02-01 00:00:00' AND publish_date < '2005-03-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0083 | SELECT object_assoc_blogs.publish_date
FROM (`object_assoc_blogs`)
JOIN `blogs` ON object_assoc_blogs.object_id = blogs.id
WHERE (publish_date >= '2005-01-01 00:00:00' AND publish_date < '2005-02-01 00:00:00') AND (object_assoc_blogs.assoc = 'domain' AND object_assoc_blogs.assoc_id = '1')
LIMIT 1 |
| 0.0004 | UPDATE ci_sessions SET last_activity = 1268424388, 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:24:\"flash:new:requested_page\";s:6:\"/blogs\";}' WHERE session_id = '0299171dfb0517baccecf8546dd2f80c' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268424388, 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:24:\"flash:new:requested_page\";b:0;}' WHERE session_id = '0299171dfb0517baccecf8546dd2f80c' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268424388, 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:24:\"flash:new:requested_page\";s:6:\"/blogs\";}' WHERE session_id = '0299171dfb0517baccecf8546dd2f80c' |
| 0.0003 | UPDATE ci_sessions SET last_activity = 1268424388, 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:24:\"flash:new:requested_page\";b:0;}' WHERE session_id = '0299171dfb0517baccecf8546dd2f80c' |
