Created
February 26, 2016 02:29
-
-
Save pjanik/eabb213b8c9af6017572 to your computer and use it in GitHub Desktop.
optimized students/status, more offerings
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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