allvoices page load

  SQL (0.1ms)   SET SQL_AUTO_IS_NULL=0


Processing MapController#category_type_region_geolocation (for 127.0.0.1 at 2009-09-26 19:52:21) [GET]
  Session ID: 9bd29bbf299c97265f855ca39770f91a
  Parameters: {"category"=>"political-news", "type"=>"all"}
define_map_cookies
Cache miss: ads:category=1&news_type=all&type=landing ({:using=>{"category"=>1, "news_type"=>"all", "type"=>"landing"}, :expires_in=>900 seconds})
  GoogleAd Load (3.4ms)   SELECT SQL_NO_CACHE * FROM `google_ads` WHERE (enabled=1 and page_type='landing' and category_id=1 and news_type='all') 
  GoogleAd Columns (1.1ms)   SHOW FIELDS FROM `google_ads`
Cache write (will save 11.28ms): ads:category=1&news_type=all&type=landing
Cached fragment exists?: views/landing_page_events//allnews/political-news/active/1 (0.6ms)
Cache miss: false/false/allnews/political-news/active/landing_page1: ({:force=>true, :using=>{}, :expires_in=>600 seconds})
  Event::Slave Columns (1.9ms)   SHOW FIELDS FROM `events`
  Event::Slave Load (78715.8ms)   SELECT SQL_NO_CACHE events.id AS id FROM `events` WHERE (events.is_archived = 0 AND events.visible = 1 AND events.deleted=0 and events.total_score>0 AND (events.category_id = 1)) ORDER BY events.total_score DESC LIMIT 0,10
Cache write (will save 78756.47ms): false/false/allnews/political-news/active/landing_page1:
Cache miss: false/false/allnews/political-news/active/landing_pagepaginationquery: ({:force=>true, :using=>{}, :expires_in=>600 seconds})
  Event::Slave Load (1030.6ms)   SELECT SQL_NO_CACHE events.id AS PK_COUNT FROM `events` WHERE (events.is_archived = 0 AND events.visible = 1 AND events.deleted=0 and events.total_score>0 AND (events.category_id = 1)) LIMIT 101
Cache write (will save 1049.14ms): false/false/allnews/political-news/active/landing_pagepaginationquery:
  Event Load (1.1ms)   SELECT SQL_NO_CACHE updated_at FROM `events` WHERE (id = 4191378) LIMIT 1
  Event Columns (3.4ms)   SHOW FIELDS FROM `events`
Cache miss: event_4191378_MonSep2110:48:54-04002009: ({:force=>false, :using=>{}, :expires_in=>600 seconds})
  Event Load (80.0ms)   SELECT SQL_NO_CACHE events.*,
 geolocations.location_name, 
 geolocations.country,
	 geolocations.state,
	 geolocations.lat,
	 geolocations.lon,
 resources.name,
 resources.attribution_url,
 categories.category, 
 	 '' as thumbnail_url, 
 '' as ethumbnail_url, 
 '' as category_long, 
 '' as event_url,
 '' as clickable_tags FROM `events` INNER JOIN geolocations ON geolocations.id=events.geolocation_id 
 LEFT JOIN categories ON events.category_id=categories.id
 LEFT JOIN resources ON resources.id=events.attribution_resource_id WHERE (events.id = 4191378 AND events.visible=1 AND events.deleted=0 ) LIMIT 1
Cache write (will save 82.92ms): event_4191378_MonSep2110:48:54-04002009:
  Event Load (1.3ms)   SELECT SQL_NO_CACHE updated_at FROM `events` WHERE (id = 4196201) LIMIT 1
Cache miss: event_4196201_MonSep2122:56:47-04002009: ({:force=>false, :using=>{}, :expires_in=>600 seconds})
  Event Load (27.5ms)   SELECT SQL_NO_CACHE events.*,
 geolocations.location_name, 
 geolocations.country,
	 geolocations.state,
	 geolocations.lat,
	 geolocations.lon,
 resources.name,
 resources.attribution_url,
 categories.category, 
 	 '' as thumbnail_url, 
 '' as ethumbnail_url, 
 '' as category_long, 
 '' as event_url,
 '' as clickable_tags FROM `events` INNER JOIN geolocations ON geolocations.id=events.geolocation_id 
 LEFT JOIN categories ON events.category_id=categories.id
 LEFT JOIN resources ON resources.id=events.attribution_resource_id WHERE (events.id = 4196201 AND events.visible=1 AND events.deleted=0 ) LIMIT 1
Cache write (will save 30.38ms): event_4196201_MonSep2122:56:47-04002009:
  Event Load (1.2ms)   SELECT SQL_NO_CACHE updated_at FROM `events` WHERE (id = 4191325) LIMIT 1
Cache miss: event_4191325_MonSep2122:36:54-04002009: ({:force=>false, :using=>{}, :expires_in=>600 seconds})
  Event Load (7.0ms)   SELECT SQL_NO_CACHE events.*,
 geolocations.location_name, 
 geolocations.country,
	 geolocations.state,
	 geolocations.lat,
	 geolocations.lon,
 resources.name,
 resources.attribution_url,
 categories.category, 
 	 '' as thumbnail_url, 
 '' as ethumbnail_url, 
 '' as category_long, 
 '' as event_url,
 '' as clickable_tags FROM `events` INNER JOIN geolocations ON geolocations.id=events.geolocation_id 
 LEFT JOIN categories ON events.category_id=categories.id
 LEFT JOIN resources ON resources.id=events.attribution_resource_id WHERE (events.id = 4191325 AND events.visible=1 AND events.deleted=0 ) LIMIT 1
Cache write (will save 9.77ms): event_4191325_MonSep2122:36:54-04002009:
  Event Load (1.1ms)   SELECT SQL_NO_CACHE updated_at FROM `events` WHERE (id = 4193505) LIMIT 1
Cache miss: event_4193505_MonSep2122:20:49-04002009: ({:force=>false, :using=>{}, :expires_in=>600 seconds})
  Event Load (1.7ms)   SELECT SQL_NO_CACHE events.*,
 geolocations.location_name, 
 geolocations.country,
	 geolocations.state,
	 geolocations.lat,
	 geolocations.lon,
 resources.name,
 resources.attribution_url,
 categories.category, 
 	 '' as thumbnail_url, 
 '' as ethumbnail_url, 
 '' as category_long, 
 '' as event_url,
 '' as clickable_tags FROM `events` INNER JOIN geolocations ON geolocations.id=events.geolocation_id 
 LEFT JOIN categories ON events.category_id=categories.id
 LEFT JOIN resources ON resources.id=events.attribution_resource_id WHERE (events.id = 4193505 AND events.visible=1 AND events.deleted=0 ) LIMIT 1
Cache write (will save 4.72ms): event_4193505_MonSep2122:20:49-04002009:
  Event Load (1.2ms)   SELECT SQL_NO_CACHE updated_at FROM `events` WHERE (id = 4191299) LIMIT 1
Cache miss: event_4191299_MonSep2119:53:37-04002009: ({:force=>false, :using=>{}, :expires_in=>600 seconds})
  Event Load (27.2ms)   SELECT SQL_NO_CACHE events.*,
 geolocations.location_name, 
 geolocations.country,
	 geolocations.state,
	 geolocations.lat,
	 geolocations.lon,
 resources.name,
 resources.attribution_url,
 categories.category, 
 	 '' as thumbnail_url, 
 '' as ethumbnail_url, 
 '' as category_long, 
 '' as event_url,
 '' as clickable_tags FROM `events` INNER JOIN geolocations ON geolocations.id=events.geolocation_id 
 LEFT JOIN categories ON events.category_id=categories.id
 LEFT JOIN resources ON resources.id=events.attribution_resource_id WHERE (events.id = 4191299 AND events.visible=1 AND events.deleted=0 ) LIMIT 1
Cache write (will save 30.15ms): event_4191299_MonSep2119:53:37-04002009:
  Event Load (1.3ms)   SELECT SQL_NO_CACHE updated_at FROM `events` WHERE (id = 4191449) LIMIT 1
Cache miss: event_4191449_MonSep2121:27:33-04002009: ({:force=>false, :using=>{}, :expires_in=>600 seconds})
  Event Load (9.6ms)   SELECT SQL_NO_CACHE events.*,
 geolocations.location_name, 
 geolocations.country,
	 geolocations.state,
	 geolocations.lat,
	 geolocations.lon,
 resources.name,
 resources.attribution_url,
 categories.category, 
 	 '' as thumbnail_url, 
 '' as ethumbnail_url, 
 '' as category_long, 
 '' as event_url,
 '' as clickable_tags FROM `events` INNER JOIN geolocations ON geolocations.id=events.geolocation_id 
 LEFT JOIN categories ON events.category_id=categories.id
 LEFT JOIN resources ON resources.id=events.attribution_resource_id WHERE (events.id = 4191449 AND events.visible=1 AND events.deleted=0 ) LIMIT 1
Cache write (will save 12.48ms): event_4191449_MonSep2121:27:33-04002009:
  Event Load (1.2ms)   SELECT SQL_NO_CACHE updated_at FROM `events` WHERE (id = 4196467) LIMIT 1
Cache miss: event_4196467_MonSep2119:22:29-04002009: ({:force=>false, :using=>{}, :expires_in=>600 seconds})
  Event Load (29.5ms)   SELECT SQL_NO_CACHE events.*,
 geolocations.location_name, 
 geolocations.country,
	 geolocations.state,
	 geolocations.lat,
	 geolocations.lon,
 resources.name,
 resources.attribution_url,
 categories.category, 
 	 '' as thumbnail_url, 
 '' as ethumbnail_url, 
 '' as category_long, 
 '' as event_url,
 '' as clickable_tags FROM `events` INNER JOIN geolocations ON geolocations.id=events.geolocation_id 
 LEFT JOIN categories ON events.category_id=categories.id
 LEFT JOIN resources ON resources.id=events.attribution_resource_id WHERE (events.id = 4196467 AND events.visible=1 AND events.deleted=0 ) LIMIT 1
Cache write (will save 32.31ms): event_4196467_MonSep2119:22:29-04002009:
  Event Load (1.1ms)   SELECT SQL_NO_CACHE updated_at FROM `events` WHERE (id = 4193828) LIMIT 1
Cache miss: event_4193828_MonSep2117:16:16-04002009: ({:force=>false, :using=>{}, :expires_in=>600 seconds})
  Event Load (2.1ms)   SELECT SQL_NO_CACHE events.*,
 geolocations.location_name, 
 geolocations.country,
	 geolocations.state,
	 geolocations.lat,
	 geolocations.lon,
 resources.name,
 resources.attribution_url,
 categories.category, 
 	 '' as thumbnail_url, 
 '' as ethumbnail_url, 
 '' as category_long, 
 '' as event_url,
 '' as clickable_tags FROM `events` INNER JOIN geolocations ON geolocations.id=events.geolocation_id 
 LEFT JOIN categories ON events.category_id=categories.id
 LEFT JOIN resources ON resources.id=events.attribution_resource_id WHERE (events.id = 4193828 AND events.visible=1 AND events.deleted=0 ) LIMIT 1
Cache write (will save 4.94ms): event_4193828_MonSep2117:16:16-04002009:
  Event Load (1.2ms)   SELECT SQL_NO_CACHE updated_at FROM `events` WHERE (id = 4191440) LIMIT 1
Cache miss: event_4191440_MonSep2122:27:28-04002009: ({:force=>false, :using=>{}, :expires_in=>600 seconds})
  Event Load (1.6ms)   SELECT SQL_NO_CACHE events.*,
 geolocations.location_name, 
 geolocations.country,
	 geolocations.state,
	 geolocations.lat,
	 geolocations.lon,
 resources.name,
 resources.attribution_url,
 categories.category, 
 	 '' as thumbnail_url, 
 '' as ethumbnail_url, 
 '' as category_long, 
 '' as event_url,
 '' as clickable_tags FROM `events` INNER JOIN geolocations ON geolocations.id=events.geolocation_id 
 LEFT JOIN categories ON events.category_id=categories.id
 LEFT JOIN resources ON resources.id=events.attribution_resource_id WHERE (events.id = 4191440 AND events.visible=1 AND events.deleted=0 ) LIMIT 1
Cache write (will save 4.34ms): event_4191440_MonSep2122:27:28-04002009:
  Event Load (1.4ms)   SELECT SQL_NO_CACHE updated_at FROM `events` WHERE (id = 4191412) LIMIT 1
Cache miss: event_4191412_MonSep2123:04:57-04002009: ({:force=>false, :using=>{}, :expires_in=>600 seconds})
  Event Load (1.6ms)   SELECT SQL_NO_CACHE events.*,
 geolocations.location_name, 
 geolocations.country,
	 geolocations.state,
	 geolocations.lat,
	 geolocations.lon,
 resources.name,
 resources.attribution_url,
 categories.category, 
 	 '' as thumbnail_url, 
 '' as ethumbnail_url, 
 '' as category_long, 
 '' as event_url,
 '' as clickable_tags FROM `events` INNER JOIN geolocations ON geolocations.id=events.geolocation_id 
 LEFT JOIN categories ON events.category_id=categories.id
 LEFT JOIN resources ON resources.id=events.attribution_resource_id WHERE (events.id = 4191412 AND events.visible=1 AND events.deleted=0 ) LIMIT 1
Cache write (will save 4.35ms): event_4191412_MonSep2123:04:57-04002009:
  Event Load (0.5ms)   SELECT SQL_NO_CACHE updated_at FROM `events` WHERE (id = 4191378) LIMIT 1
Cache hit: event_4191378_MonSep2110:48:54-04002009: ({:force=>false, :using=>{}, :expires_in=>600 seconds})
  ContentCount Load (101.1ms)   SELECT SQL_NO_CACHE * FROM `content_counts` WHERE (countable_id=4191378 AND countable_type='Event' AND 1=1) LIMIT 1
  ContentCount Columns (3.0ms)   SHOW FIELDS FROM `content_counts`
DEPRECATION WARNING: #processed_results will be deprecated in favor of setting the is_profile instance variable. (called from fetch_event_details at /home/zork/Development/allvoices.dev/app/controllers/application.rb:1997)
  TrafficBreakdown Load (931.6ms)   SELECT SQL_NO_CACHE sum(tb.count) as cnt, c.country_name as country_name, 0 as percentage from traffic_breakdown tb, geolocations as g, country as c where countable_type='Event' and countable_id=4191378 and g.id=tb.geolocation_id and c.id=g.country_id group by c.country_name order by cnt desc
  TrafficBreakdown Columns (4.1ms)   SHOW