Skip to content

Instantly share code, notes, and snippets.

@pjanik
Created February 26, 2016 02:29
Show Gist options
  • Save pjanik/eabb213b8c9af6017572 to your computer and use it in GitHub Desktop.
Save pjanik/eabb213b8c9af6017572 to your computer and use it in GitHub Desktop.
optimized students/status, more offerings
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)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment