timlinquist · May 17, 2011 17:53
diff --git a/theblock.ohhai.com b/theblock.ohhai.com
 Started GET "/" for 127.0.0.1 at Tue May 17 10:52:57 -0700 2011
  SQL (2.0ms)  describe `areas_stores`
  SQL (1.4ms)  describe `comarketing_pages_stores`
  SQL (2.0ms)  describe `pages_stores`
  SQL (1.9ms)  describe `areas_stores`
 HERE OPTIONS={}
  SQL (2.6ms)  SHOW TABLES
 HERE OPTIONS={:relationship_name=>:unit_attributes, :class_name=>"SelfStorageUnitAttributes"}
  SQL (2.5ms)  SHOW TABLES
  Processing by ContentController#index as HTML
  ClientDomain Load (54.6ms)  SELECT `client_domains`.`id` AS t0_r0, `client_domains`.`client_id` AS t0_r1, `client_domains`.`domain` AS t0_r2, `client_domains`.`google_verification_id` AS t0_r3, `client_domains`.`google_analytics_id` AS t0_r4, `client_domains`.`indextools_id` AS t0_r5, `client_domains`.`parent_id` AS t0_r6, `client_domains`.`association_id` AS t0_r7, `client_domains`.`association_type` AS t0_r8, `client_domains`.`staging_host_name` AS t0_r9, `client_domains`.`template_path` AS t0_r10, `client_domains`.`template_name` AS t0_r11, `client_domains`.`google_maps_key` AS t0_r12, `client_domains`.`indextools_datacenter` AS t0_r13, `client_domains`.`namespace` AS t0_r14, `clients`.`id` AS t1_r0, `clients`.`industry_id` AS t1_r1, `clients`.`branded_name` AS t1_r2, `clients`.`status_code` AS t1_r3, `clients`.`logo_file_name` AS t1_r4, `clients`.`advertising_start_date` AS t1_r5, `clients`.`advertising_end_date` AS t1_r6, `clients`.`street` AS t1_r7, `clients`.`city` AS t1_r8, `clients`.`state` AS t1_r9, `clients`.`zip` AS t1_r10, `clients`.`url` AS t1_r11, `clients`.`alt_url` AS t1_r12, `clients`.`overture_id` AS t1_r13, `clients`.`indextools_id` AS t1_r14, `clients`.`created_on` AS t1_r15, `clients`.`updated_on` AS t1_r16, `clients`.`fax_number` AS t1_r17, `clients`.`layout` AS t1_r18, `clients`.`development_url` AS t1_r19, `clients`.`photo_width` AS t1_r20, `clients`.`photo_height` AS t1_r21, `clients`.`platform_version` AS t1_r22, `clients`.`google_analytics_id` AS t1_r23, `clients`.`google_conversion_id` AS t1_r24, `clients`.`website_golive` AS t1_r25, `clients`.`google_verification_id` AS t1_r26, `clients`.`contact_email` AS t1_r27, `clients`.`client_name` AS t1_r28, `clients`.`zip_search_radius` AS t1_r29, `clients`.`indextools_username` AS t1_r30, `clients`.`indextools_password` AS t1_r31, `clients`.`display_store_branded_name` AS t1_r32, `clients`.`preferences` AS t1_r33, `clients`.`marketing_analyst_id` AS t1_r34, `clients`.`search_analyst_id` AS t1_r35, `clients`.`logo_content_type` AS t1_r36, `clients`.`custom_css` AS t1_r37, `clients`.`logo_updated_at` AS t1_r38, `clients`.`logo_file_size` AS t1_r39, `clients`.`javascript_framework` AS t1_r40, `clients`.`keyword_text` AS t1_r41, `clients`.`store_type_text` AS t1_r42, `clients`.`seo_specialist_id` AS t1_r43, `clients`.`google_cse_id` AS t1_r44, `clients`.`organization_id` AS t1_r45, `clients`.`default_call_plan_id` AS t1_r46, `clients`.`mobile_plan` AS t1_r47, `clients`.`contract_signed_date` AS t1_r48, `clients`.`kickoff_date` AS t1_r49, `clients`.`project_manager_user_id` AS t1_r50, `clients`.`page_builder_user_id` AS t1_r51, `clients`.`data_coordinator_user_id` AS t1_r52, `clients`.`quality_assurance_user_id` AS t1_r53, `clients`.`web_developer_user_id` AS t1_r54, `clients`.`basecamp_project_id` AS t1_r55, `clients`.`project_name` AS t1_r56, `clients`.`project_type` AS t1_r57, `clients`.`industry_sub_type` AS t1_r58, `clients`.`pre_basecamp` AS t1_r59, `parents_client_domains`.`id` AS t2_r0, `parents_client_domains`.`client_id` AS t2_r1, `parents_client_domains`.`domain` AS t2_r2, `parents_client_domains`.`google_verification_id` AS t2_r3, `parents_client_domains`.`google_analytics_id` AS t2_r4, `parents_client_domains`.`indextools_id` AS t2_r5, `parents_client_domains`.`parent_id` AS t2_r6, `parents_client_domains`.`association_id` AS t2_r7, `parents_client_domains`.`association_type` AS t2_r8, `parents_client_domains`.`staging_host_name` AS t2_r9, `parents_client_domains`.`template_path` AS t2_r10, `parents_client_domains`.`template_name` AS t2_r11, `parents_client_domains`.`google_maps_key` AS t2_r12, `parents_client_domains`.`indextools_datacenter` AS t2_r13, `parents_client_domains`.`namespace` AS t2_r14 FROM `client_domains` LEFT OUTER JOIN `clients` ON `clients`.`id` = `client_domains`.`client_id` LEFT OUTER JOIN `client_domains` `parents_client_domains` ON `parents_client_domains`.`id` = `client_domains`.`parent_id` WHERE `client_domains`.`domain` = 'theblockoncampus.com' LIMIT 1
  Mobile Load (0.3ms)  SELECT `mobiles`.* FROM `mobiles` WHERE (`mobiles`.inheritable_id = 1206 AND `mobiles`.inheritable_type = 'Client') AND (name = 'plan') LIMIT 1
  Industry Load (0.4ms)  SELECT `industries`.* FROM `industries` WHERE `industries`.`id` = 6 LIMIT 1
  Seo Load (0.4ms)  SELECT `seos`.* FROM `seos` WHERE (`seos`.inheritable_id = 6 AND `seos`.inheritable_type = 'Industry') AND (name = 'plan') LIMIT 1
  Mobile Load (0.1ms)  SELECT `mobiles`.* FROM `mobiles` WHERE (inheritable_id IS NULL AND inheritable_type IS NULL) AND (name = 'plan') LIMIT 1
  Store Load (21.9ms)  SELECT `stores`.* FROM `stores` WHERE `stores`.`id` = 3086 AND (`stores`.client_id = 1206) LIMIT 1
  StoreAttribute Load (0.3ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3086)
  Hour Load (0.4ms)  SELECT `hours`.* FROM `hours` WHERE (`hours`.store_id = 3086) ORDER BY position
  CACHE (0.0ms)  SELECT `mobiles`.* FROM `mobiles` WHERE (`mobiles`.inheritable_id = 1206 AND `mobiles`.inheritable_type = 'Client') AND (name = 'plan') LIMIT 1
  CACHE (0.0ms)  SELECT `seos`.* FROM `seos` WHERE (`seos`.inheritable_id = 6 AND `seos`.inheritable_type = 'Industry') AND (name = 'plan') LIMIT 1
  CACHE (0.0ms)  SELECT `mobiles`.* FROM `mobiles` WHERE (inheritable_id IS NULL AND inheritable_type IS NULL) AND (name = 'plan') LIMIT 1
  SQL (2.2ms)  describe `areas_stores`
  Area Load (0.7ms)  SELECT areas.* FROM areas INNER JOIN areas_stores ats ON ats.area_id = areas.id INNER JOIN navigation_area_types atc ON atc.area_type_id = areas.area_type_id WHERE ats.store_id = 3086 AND atc.client_id = 1206 ORDER BY atc.position
  SQL (0.2ms)   select stores.id
 from stores, areas_stores
 where stores.id = areas_stores.store_id
 and stores.show_on_website = 1
 and stores.client_id = 1206
 and areas_stores.area_id = 16
  SQL (0.2ms)   select stores.id
 from stores, areas_stores
 where stores.id = areas_stores.store_id
 and stores.show_on_website = 1
 and stores.client_id = 1206
 and areas_stores.area_id = 277

 Rendered content/_facility_breadcrumb.html.erb (338.5ms)
  DrivingDirections Load (1.4ms)  SELECT `driving_directions`.* FROM `driving_directions` WHERE (`driving_directions`.store_id = 3086) LIMIT 1
  SQL (0.2ms)   select stores.id
 from stores, areas_stores
 where stores.id = areas_stores.store_id
 and stores.show_on_website = 1
 and stores.client_id = 1206
 and areas_stores.area_id = 277

  SQL (0.3ms)   select stores.id
 from stores, areas_stores
 where stores.id = areas_stores.store_id
 and stores.show_on_website = 1
 and stores.client_id = 1206
 and areas_stores.area_id = 277
  SQL (1.3ms)  SELECT COUNT(*) FROM `photos` WHERE `photos`.`type` = 'StorePhoto' AND (`photos`.store_id = 3086)
  StorePhoto Load (0.3ms)  SELECT `photos`.* FROM `photos` WHERE `photos`.`type` = 'StorePhoto' AND (`photos`.store_id = 3086)
  Store Load (0.2ms)  SELECT `stores`.* FROM `stores` WHERE `stores`.`id` = 3086 LIMIT 1
  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3086)
  Client Load (5.2ms)  SELECT `clients`.* FROM `clients` WHERE `clients`.`id` = 1206 LIMIT 1
  CACHE (0.0ms)  SELECT `stores`.* FROM `stores` WHERE `stores`.`id` = 3086 LIMIT 1
  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3086)
  CACHE (0.0ms)  SELECT `clients`.* FROM `clients` WHERE `clients`.`id` = 1206 LIMIT 1
 Rendered content/_slideshow.html.erb (1640.1ms)
  CACHE (0.0ms)  SELECT `clients`.* FROM `clients` WHERE `clients`.`id` = 1206 LIMIT 1
  SQL (0.3ms)  SELECT COUNT(*) FROM `specials` WHERE (`specials`.client_id = 1206)
  Special Load (0.3ms)  SELECT `specials`.* FROM `specials` WHERE (`specials`.client_id = 1206) ORDER BY position LIMIT 1
 DEPRECATION WARNING: :popup has been deprecated. (called from _app_views_content_facility_page_html_erb__820393845_2577667620_0 at /Users/timlinquist/Projects/private/g5/core/app/views/content/facility_page.html.erb:65)
  Description Load (21.3ms)  SELECT `descriptions`.* FROM `descriptions` WHERE (`descriptions`.store_id = 3086) LIMIT 1
 Rendered content/facility/_hours.html.erb (137.1ms)
  SQL (1.1ms)  SELECT COUNT(*) FROM `offerings` WHERE (`offerings`.store_id = 3086)
  Offering Load (0.4ms)  SELECT `offerings`.* FROM `offerings` WHERE (`offerings`.store_id = 3086) ORDER BY position
 Rendered content/facility/_features.html.erb (795.9ms)
  Area Load (0.5ms)  	 select areas.*, count(1) as client_store_count, stores.facility_page_link
 from areas, areas_stores, stores
 where areas.id = areas_stores.area_id AND
 areas_stores.store_id = stores.id AND
 stores.show_on_website = 1 AND
 (stores.client_id = 1206 OR stores.parent_client_id = 1206)
 group by areas_stores.area_id

  SQL (0.4ms)  SELECT areas.id FROM areas INNER JOIN areas_stores ast ON ast.area_id = areas.id INNER JOIN stores ON stores.id = ast.store_id INNER JOIN navigation_area_types nav ON nav.client_id = 1206 AND nav.area_type_id = areas.area_type_id WHERE (stores.client_id = 1206 OR stores.parent_client_id = 1206) AND stores.show_on_website = 1 ORDER BY stores.id, nav.position
  NavigationAreaType Load (0.2ms)  SELECT `navigation_area_types`.* FROM `navigation_area_types` WHERE (`navigation_area_types`.client_id = 1206) ORDER BY position
  Store Load (0.3ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))
  Store Load (0.3ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1

  StoreAttribute Load (0.2ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3047)
  Store Load (0.3ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 731 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3047)
  Area Load (0.2ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3047
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  SQL (140.7ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 731 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  Store Load (0.3ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 731 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3047)
  Store Load (0.3ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 111 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  Store Load (0.3ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1607 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))
  StoreAttribute Load (0.4ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3049)
  Area Load (0.3ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3049
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;
  SQL (0.4ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 1607 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  Store Load (0.3ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1607 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1
  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3049)
  Store Load (0.4ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 360 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))
  StoreAttribute Load (0.4ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3048)
  Area Load (0.3ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3048
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;
  SQL (0.2ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 360 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  Store Load (2.5ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 360 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1
  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3048)
  Store Load (8.8ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 4 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))
  Store Load (0.2ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 4 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1

  StoreAttribute Load (0.4ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3090)
  Store Load (0.3ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 578 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3090)
  Area Load (0.2ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3090
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  SQL (0.4ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 578 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  Store Load (0.2ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 578 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3090)
  Store Load (0.3ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 9 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  Store Load (0.3ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1186 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))
  StoreAttribute Load (0.2ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3093)
  Area Load (0.3ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3093
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;
  SQL (0.2ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 1186 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  Store Load (0.3ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 42 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))
  StoreAttribute Load (0.2ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3091)
  Area Load (0.3ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3091
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;
  SQL (0.3ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 42 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  Store Load (0.3ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1574 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))
  StoreAttribute Load (0.3ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3092)
  Area Load (0.4ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3092
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;
  SQL (0.2ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 1574 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  Store Load (0.2ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1574 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1
  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3092)
  Store Load (0.3ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1185 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))
  StoreAttribute Load (0.2ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3096)
  Area Load (0.1ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3096
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;
  SQL (0.3ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 1185 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  Store Load (0.3ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1185 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1
  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3096)
  Store Load (0.2ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 506 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))
  StoreAttribute Load (0.2ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3097)
  Area Load (0.3ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3097
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;
  SQL (0.2ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 506 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  Store Load (0.2ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 506 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1
  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3097)
  Store Load (0.6ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 16 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))
  Store Load (0.3ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 277 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  StoreAttribute Load (0.3ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3051)
  Area Load (0.8ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3051
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  SQL (0.3ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 277 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  Store Load (0.4ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 656 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  StoreAttribute Load (0.2ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3060)
  Area Load (0.2ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3060
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  SQL (0.3ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 656 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  Store Load (3.9ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 205 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  StoreAttribute Load (0.2ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3073)
  Area Load (0.3ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3073
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  SQL (0.2ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 205 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  Store Load (0.3ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1608 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  StoreAttribute Load (0.2ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3057)
  Area Load (0.3ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3057
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  SQL (0.3ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 1608 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  Store Load (0.2ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1608 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3057)
  Store Load (1.6ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 61 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  StoreAttribute Load (0.3ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3053)
  Area Load (0.2ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3053
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  SQL (0.1ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 61 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  Store Load (0.2ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1610 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  StoreAttribute Load (0.3ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3063)
  Area Load (0.2ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3063
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  SQL (0.2ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 1610 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  Store Load (0.5ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1610 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3063)
  Store Load (0.4ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1609 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  StoreAttribute Load (0.2ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3062)
  Area Load (0.3ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3062
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  SQL (0.3ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 1609 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  Store Load (0.2ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1609 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3062)
  Store Load (0.4ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 341 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  StoreAttribute Load (0.4ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3052)
  Area Load (0.2ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3052
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  SQL (0.2ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 341 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  Store Load (0.3ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 413 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  StoreAttribute Load (0.3ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3050)
  Area Load (0.2ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3050
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  SQL (0.2ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 413 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  Store Load (0.3ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1575 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  StoreAttribute Load (0.2ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3068)
  Area Load (0.2ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3068
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  SQL (0.2ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 1575 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  Store Load (0.4ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1575 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3068)
  Store Load (0.2ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 209 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  StoreAttribute Load (0.3ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3054)
  Area Load (0.2ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3054
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  SQL (0.4ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 209 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
 Rendered content/_other_facilities.html.erb (1567.6ms)
  CompCode Load (0.2ms)  SELECT `comp_codes`.* FROM `comp_codes` WHERE (`comp_codes`.store_id = 3086) LIMIT 1
 Rendered content/_compare.html.erb (889.9ms)
 Rendered content/_dev_assets.html.erb (20.3ms)
 Rendered content/_head.html.erb (54.9ms)
  SQL (2.1ms)  describe `pages_stores`
  SQL (2.4ms)  SELECT COUNT(DISTINCT `store_menu_items`.`id`) FROM `store_menu_items` LEFT OUTER JOIN `pages` ON `pages`.`id` = `store_menu_items`.`page_id` WHERE (`store_menu_items`.store_id = 3086)
  StoreMenuItem Load (0.2ms)  SELECT `store_menu_items`.* FROM `store_menu_items` WHERE (`store_menu_items`.store_id = 3086) ORDER BY position
  Page Load (0.2ms)  SELECT `pages`.* FROM `pages` WHERE (`pages`.`id` IN (8250,8283,8251,8252,8248))
 Rendered /Users/timlinquist/projects/private/g5/clients/theblockoncampus.com/app/views/layouts/partials/_cws_header.html.erb (1071.8ms)
 Creating scope :find_all_by_category. Overwriting existing method Attachment.find_all_by_category.
  Attachment Load (0.2ms)  SELECT `attachments`.`id` AS t0_r0, `attachments`.`asset_id` AS t0_r1, `attachments`.`position` AS t0_r2, `attachments`.`attachable_id` AS t0_r3, `attachments`.`attachable_type` AS t0_r4, `attachments`.`category` AS t0_r5, `attachments`.`title` AS t0_r6, `attachments`.`description` AS t0_r7, `attachments`.`custom_fields` AS t0_r8, `attachments`.`created_at` AS t0_r9, `attachments`.`updated_at` AS t0_r10, `attachments`.`alt_text` AS t0_r11, `assets`.`id` AS t1_r0, `assets`.`data_file_name` AS t1_r1, `assets`.`data_content_type` AS t1_r2, `assets`.`data_file_size` AS t1_r3, `assets`.`data_updated_at` AS t1_r4, `assets`.`asset_category_id` AS t1_r5, `asset_categories`.`id` AS t2_r0, `asset_categories`.`client_id` AS t2_r1, `asset_categories`.`name` AS t2_r2, `asset_categories`.`width` AS t2_r3, `asset_categories`.`height` AS t2_r4 FROM `attachments` LEFT OUTER JOIN `assets` ON `assets`.`id` = `attachments`.`asset_id` LEFT OUTER JOIN `asset_categories` ON `asset_categories`.`id` = `assets`.`asset_category_id` WHERE `asset_categories`.`name` = 'fac-slides' AND (`attachments`.attachable_id = 3086 AND `attachments`.attachable_type = 'Store') ORDER BY position LIMIT 1
 Rendered /Users/timlinquist/projects/private/g5/clients/theblockoncampus.com/app/views/content/_asset_slideshow.html.erb (1146.4ms)
 Rendered /Users/timlinquist/projects/private/g5/clients/theblockoncampus.com/app/views/content/_facility_page.html.erb (1.3ms)
 Rendered /Users/timlinquist/projects/private/g5/clients/theblockoncampus.com/app/views/content/_parts_address_hcard.html.erb (2.5ms)
  Page Load (0.2ms)  SELECT `pages`.* FROM `pages` WHERE `pages`.`archived` = 0 AND `pages`.`name` = 'faq_block' AND (`pages`.client_id = 1206) LIMIT 1
  Page Load (0.2ms)  SELECT `pages`.* FROM `pages` WHERE `pages`.`archived` = 0 AND `pages`.`name` = 'block_residents' AND (`pages`.client_id = 1206) LIMIT 1
  ClientDomain Load (0.2ms)  SELECT `client_domains`.* FROM `client_domains` WHERE `client_domains`.`association_type` = 'Client' AND (`client_domains`.client_id = 1206) LIMIT 1
 Rendered content/_hcard.html.erb (1.2ms)
 Rendered content/_footer.html.erb (12.0ms)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3047)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 731 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3047)
  CACHE (0.0ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3047
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  CACHE (0.0ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 731 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 731 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3047)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 111 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1607 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))
  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3049)
  CACHE (0.0ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3049
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;
  CACHE (0.0ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 1607 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1607 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1
  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3049)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 360 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))
  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3048)
  CACHE (0.0ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3048
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;
  CACHE (0.0ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 360 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 360 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1
  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3048)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 4 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 4 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3090)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 578 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3090)
  CACHE (0.0ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3090
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  CACHE (0.0ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 578 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 578 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3090)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 9 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1186 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))
  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3093)
  CACHE (0.0ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3093
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;
  CACHE (0.0ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 1186 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 42 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))
  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3091)
  CACHE (0.0ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3091
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;
  CACHE (0.0ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 42 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1574 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))
  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3092)
  CACHE (0.0ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3092
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;
  CACHE (0.0ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 1574 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1574 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1
  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3092)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1185 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))
  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3096)
  CACHE (0.0ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3096
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;
  CACHE (0.0ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 1185 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1185 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1
  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3096)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 506 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))
  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3097)
  CACHE (0.0ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3097
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;
  CACHE (0.0ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 506 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 506 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1
  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3097)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 16 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 277 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3051)
  CACHE (0.0ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3051
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  CACHE (0.0ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 277 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 656 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3060)
  CACHE (0.0ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3060
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  CACHE (0.0ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 656 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 205 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3073)
  CACHE (0.0ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3073
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  CACHE (0.0ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 205 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1608 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3057)
  CACHE (0.0ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3057
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  CACHE (0.0ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 1608 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1608 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3057)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 61 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3053)
  CACHE (0.0ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3053
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  CACHE (0.0ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 61 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1610 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3063)
  CACHE (0.0ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3063
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  CACHE (0.0ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 1610 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1610 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3063)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1609 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3062)
  CACHE (0.0ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3062
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  CACHE (0.0ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 1609 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1609 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3062)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 341 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3052)
  CACHE (0.0ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3052
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  CACHE (0.0ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 341 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 413 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3050)
  CACHE (0.0ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3050
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  CACHE (0.0ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 413 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1575 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3068)
  CACHE (0.0ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3068
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  CACHE (0.0ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 1575 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 1575 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true)) 
 LIMIT 1

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3068)
  CACHE (0.0ms)   SELECT * FROM stores 
 INNER JOIN areas_stores ON stores.id = areas_stores.store_id 
 WHERE (areas_stores.area_id = 209 AND ((client_id = 1206 OR parent_client_id = 1206) AND show_on_website = true))

  CACHE (0.0ms)  SELECT `store_attributes`.* FROM `store_attributes` WHERE (`store_attributes`.store_id = 3054)
  CACHE (0.0ms)   select areas.*,
 nat.position,
 if(areas.area_type_id = 40, 99, nat.position) as sort_order
 from areas, areas_stores ast, navigation_area_types nat
 where
 nat.area_type_id = areas.area_type_id
 and
 areas.id = ast.area_id
 and
 ast.store_id = 3054
 and
 nat.client_id = 1206
 order by sort_order desc
 limit 1;

  CACHE (0.0ms)  SELECT COUNT(*) FROM `stores` INNER JOIN `areas_stores` ON `stores`.id = `areas_stores`.store_id WHERE (`areas_stores`.area_id = 209 ) AND ((client_id = 1206 OR parent_client_id = 1206) 
 AND show_on_website = true)
 Rendered content/_other_facilities.html.erb (886.0ms)
 Rendered content/_signature_brand.html.erb (0.8ms)
 Rendered content/_tracking.html.erb (0.9ms)
 Rendered /Users/timlinquist/projects/private/g5/clients/theblockoncampus.com/app/views/layouts/partials/_cws_footer.html.erb (1001.0ms)
 Rendered content/facility_page.html.erb within layouts/cwsapartments (10914.9ms)
 Completed 200 OK in 13624ms (Views: 10815.9ms | ActiveRecord: 317.3ms)
No results found