optimized students/status, more offerings

gistfile1.txt

around 85ms in total:

Started GET "/portal/students/2/status.json" for 127.0.0.1 at 2016-02-25 18:28:24 -0800
Processing by Portal::StudentsController#status as JSON
  Parameters: {"id"=>"2"}
  User Load (1.2ms)  SELECT `users`.* FROM `users` WHERE `users`.`id` = 10 AND (`users`.`state` NOT IN ('disabled')) LIMIT 1
  Portal::Teacher Load (1.1ms)  SELECT `portal_teachers`.* FROM `portal_teachers` WHERE `portal_teachers`.`user_id` = 10 LIMIT 1
  Portal::Student Load (1.0ms)  SELECT `portal_students`.* FROM `portal_students` WHERE `portal_students`.`user_id` = 10 LIMIT 1
  Portal::Student Load (1.2ms)  SELECT `portal_students`.* FROM `portal_students` WHERE `portal_students`.`id` = 2 LIMIT 1
  Portal::Learner Load (1.2ms)  SELECT `portal_learners`.* FROM `portal_learners` WHERE `portal_learners`.`student_id` = 2 ORDER BY student_id ASC
  Portal::Offering Load (1.2ms)  SELECT `portal_offerings`.* FROM `portal_offerings` WHERE `portal_offerings`.`id` IN (1, 2, 3, 4, 5, 6, 7, 8, 10)
  ExternalActivity Load (1.5ms)  SELECT `external_activities`.* FROM `external_activities` WHERE `external_activities`.`id` IN (1, 9, 8, 7, 6, 5, 2, 3, 10)
  Activity Load (1.3ms)  SELECT `activities`.* FROM `activities` WHERE `activities`.`id` IN (1, 8, 7, 6, 5, 2, 3)
  Investigation Load (1.3ms)  SELECT `investigations`.* FROM `investigations` WHERE `investigations`.`id` IN (9, 10)
  Report::Learner Load (1.2ms)  SELECT `report_learners`.* FROM `report_learners` WHERE `report_learners`.`learner_id` IN (2, 3, 4, 5, 6, 7, 8, 9, 12)
  Report::LearnerActivity Load (1.6ms)  SELECT `report_learner_activity`.* FROM `report_learner_activity` WHERE `report_learner_activity`.`learner_id` IN (2, 3, 4, 5, 6, 7, 8, 9, 12)
  Activity Load (1.3ms)  SELECT `activities`.* FROM `activities` WHERE `activities`.`investigation_id` = 9 AND `activities`.`teacher_only` = 0 ORDER BY position
  Activity Load (1.3ms)  SELECT `activities`.* FROM `activities` WHERE `activities`.`investigation_id` = 10 AND `activities`.`teacher_only` = 0 ORDER BY position
Completed 200 OK in 59.7ms (Views: 0.9ms | ActiveRecord: 16.5ms | Solr: 0.0ms)