Skip to content

Instantly share code, notes, and snippets.

@neotericdesign

neotericdesign/gist:637429

Created October 20, 2010 22:06
Show Gist options

  • Select an option

    Learn more about clone URLs
  • Save neotericdesign/637429 to your computer and use it in GitHub Desktop.

Select an option

Learn more about clone URLs
Save neotericdesign/637429 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Started GET "/experience/courses/calendar?second_half=true" for 127.0.0.1 at Wed Oct 20 17:05:41 -0500 2010
Processing by CoursesController#calendar as HTML
Parameters: {"locale"=>:en, "second_half"=>"true"}
RefinerySetting Load (3.0ms) SELECT `refinery_settings`.* FROM `refinery_settings`
SQL (1.7ms) SHOW TABLES
SQL (17.2ms) describe `roles_users`
Role Load (0.5ms) SELECT `roles`.* FROM `roles` WHERE (`roles`.`title` = 'Refinery') LIMIT 1
SQL (1.6ms) SHOW TABLES
SQL (1.7ms) describe `roles_users`
User Load (1.1ms) SELECT * FROM `users` INNER JOIN `roles_users` ON `users`.id = `roles_users`.user_id WHERE (`roles_users`.role_id = 1 )
SQL (1.7ms) describe `course_types`
SQL (7.1ms) describe `course_instructors`
SQL (1.8ms) describe `course_visiting_faculty`
Course Load (5.5ms) SELECT `courses`.* FROM `courses` ORDER BY start_at ASC
SQL (2.0ms) describe `course_instructors`
SQL (9.3ms) describe `course_visiting_faculty`
FacultyMember Load (5.0ms) SELECT `faculty_members`.*, t0.course_id as the_parent_record_id FROM `faculty_members` INNER JOIN `course_instructors` t0 ON `faculty_members`.id = t0.faculty_member_id WHERE (t0.course_id IN (3,14,21,23,32,33,40,25,34,4,7,8,15,26,35,24,5,9,16,27,36,6,10,11,28,29,37,18,12,19,30,38,42,43,13,22,31,39,44,45,46,47))
FacultyMember Load (2.2ms) SELECT `faculty_members`.*, t0.course_id as the_parent_record_id FROM `faculty_members` INNER JOIN `course_visiting_faculty` t0 ON `faculty_members`.id = t0.faculty_member_id WHERE (t0.course_id IN (3,14,21,23,32,33,40,25,34,4,7,8,15,26,35,24,5,9,16,27,36,6,10,11,28,29,37,18,12,19,30,38,42,43,13,22,31,39,44,45,46,47))
Page Load (1.4ms) SELECT `pages`.* FROM `pages` WHERE (`pages`.`link_url` = '/courses') LIMIT 1
SQL (1.7ms) describe `course_types`
CourseCategory Load (0.9ms) SELECT `course_categories`.* FROM `course_categories`
Rendered vendor/engines/courses/app/views/courses/_calendar_nav.html.erb (1.8ms)
Slug Load (1.4ms) SELECT `slugs`.* FROM `slugs` WHERE (`slugs`.sluggable_id = 2 AND `slugs`.sluggable_type = 'CourseCategory') ORDER BY id DESC LIMIT 1
SQL (0.8ms) SELECT COUNT(*) AS count_id FROM `courses` INNER JOIN `course_types` ON `courses`.id = `course_types`.course_id WHERE (`course_types`.course_category_id = 2 ) AND (start_at >= '2010-06-06 05:00:00' AND end_at <= '2010-10-01 04:59:59')
CACHE (0.0ms) SELECT COUNT(*) AS count_id FROM `courses` INNER JOIN `course_types` ON `courses`.id = `course_types`.course_id WHERE (`course_types`.course_category_id = 2 ) AND (start_at >= '2010-06-06 05:00:00' AND end_at <= '2010-10-01 04:59:59')
Course Load (11.1ms) SELECT `courses`.* FROM `courses` INNER JOIN `course_types` ON `courses`.id = `course_types`.course_id WHERE (`course_types`.course_category_id = 2 ) AND (start_at >= '2010-06-06 05:00:00' AND end_at <= '2010-10-01 04:59:59') ORDER BY start_at ASC
CourseCategory Load (1.0ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 4 ) LIMIT 1
FacultyMember Load (2.0ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 4 ) ORDER BY last_name ASC
FacultyMember Load (1.8ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 4 ) ORDER BY last_name ASC
CourseCategory Load (0.9ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 5 ) LIMIT 1
FacultyMember Load (2.4ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 5 ) ORDER BY last_name ASC
FacultyMember Load (3.4ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 5 ) ORDER BY last_name ASC
CourseCategory Load (0.8ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 6 ) LIMIT 1
FacultyMember Load (5.5ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 6 ) ORDER BY last_name ASC
FacultyMember Load (4.8ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 6 ) ORDER BY last_name ASC
Rendered vendor/engines/courses/app/views/courses/_calendar_entry.html.erb (195.3ms)
Slug Load (0.9ms) SELECT `slugs`.* FROM `slugs` WHERE (`slugs`.sluggable_id = 3 AND `slugs`.sluggable_type = 'CourseCategory') ORDER BY id DESC LIMIT 1
SQL (0.7ms) SELECT COUNT(*) AS count_id FROM `courses` INNER JOIN `course_types` ON `courses`.id = `course_types`.course_id WHERE (`course_types`.course_category_id = 3 ) AND (start_at >= '2010-06-06 05:00:00' AND end_at <= '2010-10-01 04:59:59')
CACHE (0.0ms) SELECT COUNT(*) AS count_id FROM `courses` INNER JOIN `course_types` ON `courses`.id = `course_types`.course_id WHERE (`course_types`.course_category_id = 3 ) AND (start_at >= '2010-06-06 05:00:00' AND end_at <= '2010-10-01 04:59:59')
Course Load (3.6ms) SELECT `courses`.* FROM `courses` INNER JOIN `course_types` ON `courses`.id = `course_types`.course_id WHERE (`course_types`.course_category_id = 3 ) AND (start_at >= '2010-06-06 05:00:00' AND end_at <= '2010-10-01 04:59:59') ORDER BY start_at ASC
CourseCategory Load (0.9ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 25 ) LIMIT 1
FacultyMember Load (2.2ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 25 ) ORDER BY last_name ASC
FacultyMember Load (4.2ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 25 ) ORDER BY last_name ASC
CourseCategory Load (0.8ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 26 ) LIMIT 1
FacultyMember Load (5.8ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 26 ) ORDER BY last_name ASC
FacultyMember Load (9.9ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 26 ) ORDER BY last_name ASC
CourseCategory Load (0.9ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 24 ) LIMIT 1
FacultyMember Load (2.6ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 24 ) ORDER BY last_name ASC
FacultyMember Load (2.0ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 24 ) ORDER BY last_name ASC
CourseCategory Load (0.8ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 27 ) LIMIT 1
FacultyMember Load (5.2ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 27 ) ORDER BY last_name ASC
FacultyMember Load (2.1ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 27 ) ORDER BY last_name ASC
CourseCategory Load (0.9ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 28 ) LIMIT 1
FacultyMember Load (2.3ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 28 ) ORDER BY last_name ASC
FacultyMember Load (3.6ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 28 ) ORDER BY last_name ASC
CourseCategory Load (1.1ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 29 ) LIMIT 1
FacultyMember Load (3.6ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 29 ) ORDER BY last_name ASC
FacultyMember Load (1.7ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 29 ) ORDER BY last_name ASC
CourseCategory Load (0.8ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 30 ) LIMIT 1
FacultyMember Load (2.3ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 30 ) ORDER BY last_name ASC
FacultyMember Load (3.3ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 30 ) ORDER BY last_name ASC
CourseCategory Load (1.0ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 31 ) LIMIT 1
FacultyMember Load (4.9ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 31 ) ORDER BY last_name ASC
FacultyMember Load (5.9ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 31 ) ORDER BY last_name ASC
Rendered vendor/engines/courses/app/views/courses/_calendar_entry.html.erb (119.9ms)
Slug Load (0.9ms) SELECT `slugs`.* FROM `slugs` WHERE (`slugs`.sluggable_id = 4 AND `slugs`.sluggable_type = 'CourseCategory') ORDER BY id DESC LIMIT 1
SQL (0.7ms) SELECT COUNT(*) AS count_id FROM `courses` INNER JOIN `course_types` ON `courses`.id = `course_types`.course_id WHERE (`course_types`.course_category_id = 4 ) AND (start_at >= '2010-06-06 05:00:00' AND end_at <= '2010-10-01 04:59:59')
CACHE (0.0ms) SELECT COUNT(*) AS count_id FROM `courses` INNER JOIN `course_types` ON `courses`.id = `course_types`.course_id WHERE (`course_types`.course_category_id = 4 ) AND (start_at >= '2010-06-06 05:00:00' AND end_at <= '2010-10-01 04:59:59')
Course Load (9.0ms) SELECT `courses`.* FROM `courses` INNER JOIN `course_types` ON `courses`.id = `course_types`.course_id WHERE (`course_types`.course_category_id = 4 ) AND (start_at >= '2010-06-06 05:00:00' AND end_at <= '2010-10-01 04:59:59') ORDER BY start_at ASC
CourseCategory Load (1.0ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 34 ) LIMIT 1
FacultyMember Load (2.6ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 34 ) ORDER BY last_name ASC
FacultyMember Load (1.8ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 34 ) ORDER BY last_name ASC
CourseCategory Load (0.8ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 35 ) LIMIT 1
FacultyMember Load (3.1ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 35 ) ORDER BY last_name ASC
FacultyMember Load (4.8ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 35 ) ORDER BY last_name ASC
CourseCategory Load (0.8ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 36 ) LIMIT 1
FacultyMember Load (4.5ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 36 ) ORDER BY last_name ASC
FacultyMember Load (2.3ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 36 ) ORDER BY last_name ASC
CourseCategory Load (0.9ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 37 ) LIMIT 1
FacultyMember Load (139.2ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 37 ) ORDER BY last_name ASC
FacultyMember Load (2.0ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 37 ) ORDER BY last_name ASC
CourseCategory Load (0.9ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 38 ) LIMIT 1
FacultyMember Load (2.3ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 38 ) ORDER BY last_name ASC
FacultyMember Load (4.3ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 38 ) ORDER BY last_name ASC
CourseCategory Load (0.9ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 39 ) LIMIT 1
FacultyMember Load (3.7ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 39 ) ORDER BY last_name ASC
FacultyMember Load (16.1ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 39 ) ORDER BY last_name ASC
Rendered vendor/engines/courses/app/views/courses/_calendar_entry.html.erb (244.8ms)
Slug Load (1.0ms) SELECT `slugs`.* FROM `slugs` WHERE (`slugs`.sluggable_id = 5 AND `slugs`.sluggable_type = 'CourseCategory') ORDER BY id DESC LIMIT 1
SQL (0.8ms) SELECT COUNT(*) AS count_id FROM `courses` INNER JOIN `course_types` ON `courses`.id = `course_types`.course_id WHERE (`course_types`.course_category_id = 5 ) AND (start_at >= '2010-06-06 05:00:00' AND end_at <= '2010-10-01 04:59:59')
CACHE (0.0ms) SELECT COUNT(*) AS count_id FROM `courses` INNER JOIN `course_types` ON `courses`.id = `course_types`.course_id WHERE (`course_types`.course_category_id = 5 ) AND (start_at >= '2010-06-06 05:00:00' AND end_at <= '2010-10-01 04:59:59')
Course Load (3.0ms) SELECT `courses`.* FROM `courses` INNER JOIN `course_types` ON `courses`.id = `course_types`.course_id WHERE (`course_types`.course_category_id = 5 ) AND (start_at >= '2010-06-06 05:00:00' AND end_at <= '2010-10-01 04:59:59') ORDER BY start_at ASC
CourseCategory Load (0.9ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 15 ) LIMIT 1
FacultyMember Load (5.4ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 15 ) ORDER BY last_name ASC
FacultyMember Load (5.7ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 15 ) ORDER BY last_name ASC
CourseCategory Load (0.9ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 16 ) LIMIT 1
FacultyMember Load (4.1ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 16 ) ORDER BY last_name ASC
FacultyMember Load (4.0ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 16 ) ORDER BY last_name ASC
CourseCategory Load (0.9ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 19 ) LIMIT 1
FacultyMember Load (4.9ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 19 ) ORDER BY last_name ASC
FacultyMember Load (4.4ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 19 ) ORDER BY last_name ASC
Rendered vendor/engines/courses/app/views/courses/_calendar_entry.html.erb (55.3ms)
Slug Load (1.1ms) SELECT `slugs`.* FROM `slugs` WHERE (`slugs`.sluggable_id = 6 AND `slugs`.sluggable_type = 'CourseCategory') ORDER BY id DESC LIMIT 1
SQL (0.7ms) SELECT COUNT(*) AS count_id FROM `courses` INNER JOIN `course_types` ON `courses`.id = `course_types`.course_id WHERE (`course_types`.course_category_id = 6 ) AND (start_at >= '2010-06-06 05:00:00' AND end_at <= '2010-10-01 04:59:59')
CACHE (0.0ms) SELECT COUNT(*) AS count_id FROM `courses` INNER JOIN `course_types` ON `courses`.id = `course_types`.course_id WHERE (`course_types`.course_category_id = 6 ) AND (start_at >= '2010-06-06 05:00:00' AND end_at <= '2010-10-01 04:59:59')
Course Load (2.8ms) SELECT `courses`.* FROM `courses` INNER JOIN `course_types` ON `courses`.id = `course_types`.course_id WHERE (`course_types`.course_category_id = 6 ) AND (start_at >= '2010-06-06 05:00:00' AND end_at <= '2010-10-01 04:59:59') ORDER BY start_at ASC
CourseCategory Load (2.1ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 42 ) LIMIT 1
FacultyMember Load (11.7ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 42 ) ORDER BY last_name ASC
FacultyMember Load (2.0ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 42 ) ORDER BY last_name ASC
CourseCategory Load (1.0ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 43 ) LIMIT 1
FacultyMember Load (8.4ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 43 ) ORDER BY last_name ASC
FacultyMember Load (5.4ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 43 ) ORDER BY last_name ASC
CourseCategory Load (0.9ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 44 ) LIMIT 1
FacultyMember Load (4.7ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 44 ) ORDER BY last_name ASC
FacultyMember Load (2.2ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 44 ) ORDER BY last_name ASC
Rendered vendor/engines/courses/app/views/courses/_calendar_entry.html.erb (63.7ms)
Slug Load (0.9ms) SELECT `slugs`.* FROM `slugs` WHERE (`slugs`.sluggable_id = 7 AND `slugs`.sluggable_type = 'CourseCategory') ORDER BY id DESC LIMIT 1
SQL (0.7ms) SELECT COUNT(*) AS count_id FROM `courses` INNER JOIN `course_types` ON `courses`.id = `course_types`.course_id WHERE (`course_types`.course_category_id = 7 ) AND (start_at >= '2010-06-06 05:00:00' AND end_at <= '2010-10-01 04:59:59')
CACHE (0.0ms) SELECT COUNT(*) AS count_id FROM `courses` INNER JOIN `course_types` ON `courses`.id = `course_types`.course_id WHERE (`course_types`.course_category_id = 7 ) AND (start_at >= '2010-06-06 05:00:00' AND end_at <= '2010-10-01 04:59:59')
Course Load (3.6ms) SELECT `courses`.* FROM `courses` INNER JOIN `course_types` ON `courses`.id = `course_types`.course_id WHERE (`course_types`.course_category_id = 7 ) AND (start_at >= '2010-06-06 05:00:00' AND end_at <= '2010-10-01 04:59:59') ORDER BY start_at ASC
CourseCategory Load (0.9ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 7 ) LIMIT 1
FacultyMember Load (4.3ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 7 ) ORDER BY last_name ASC
FacultyMember Load (2.1ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 7 ) ORDER BY last_name ASC
CourseCategory Load (0.9ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 8 ) LIMIT 1
FacultyMember Load (8.8ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 8 ) ORDER BY last_name ASC
FacultyMember Load (5.1ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 8 ) ORDER BY last_name ASC
CourseCategory Load (0.9ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 9 ) LIMIT 1
FacultyMember Load (2.5ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 9 ) ORDER BY last_name ASC
FacultyMember Load (10.5ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 9 ) ORDER BY last_name ASC
CourseCategory Load (0.8ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 10 ) LIMIT 1
FacultyMember Load (3.1ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 10 ) ORDER BY last_name ASC
FacultyMember Load (5.0ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 10 ) ORDER BY last_name ASC
CourseCategory Load (0.8ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 11 ) LIMIT 1
FacultyMember Load (5.2ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 11 ) ORDER BY last_name ASC
FacultyMember Load (2.5ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 11 ) ORDER BY last_name ASC
CourseCategory Load (1.4ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 12 ) LIMIT 1
FacultyMember Load (2.6ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 12 ) ORDER BY last_name ASC
FacultyMember Load (5.0ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 12 ) ORDER BY last_name ASC
CourseCategory Load (0.9ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 13 ) LIMIT 1
FacultyMember Load (2.9ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 13 ) ORDER BY last_name ASC
FacultyMember Load (5.0ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 13 ) ORDER BY last_name ASC
CourseCategory Load (0.9ms) SELECT * FROM `course_categories` INNER JOIN `course_types` ON `course_categories`.id = `course_types`.course_category_id WHERE (`course_types`.course_id = 22 ) LIMIT 1
FacultyMember Load (18.2ms) SELECT * FROM `faculty_members` INNER JOIN `course_instructors` ON `faculty_members`.id = `course_instructors`.faculty_member_id WHERE (`course_instructors`.course_id = 22 ) ORDER BY last_name ASC
FacultyMember Load (2.3ms) SELECT * FROM `faculty_members` INNER JOIN `course_visiting_faculty` ON `faculty_members`.id = `course_visiting_faculty`.faculty_member_id WHERE (`course_visiting_faculty`.course_id = 22 ) ORDER BY last_name ASC
Rendered vendor/engines/courses/app/views/courses/_calendar_entry.html.erb (299.6ms)
Slug Load (1.0ms) SELECT `slugs`.* FROM `slugs` WHERE (`slugs`.sluggable_id = 8 AND `slugs`.sluggable_type = 'CourseCategory') ORDER BY id DESC LIMIT 1
SQL (0.9ms) SELECT COUNT(*) AS count_id FROM `courses` INNER JOIN `course_types` ON `courses`.id = `course_types`.course_id WHERE (`course_types`.course_category_id = 8 ) AND (start_at >= '2010-06-06 05:00:00' AND end_at <= '2010-10-01 04:59:59')
CACHE (0.0ms) SELECT COUNT(*) AS count_id FROM `courses` INNER JOIN `course_types` ON `courses`.id = `course_types`.course_id WHERE (`course_types`.course_category_id = 8 ) AND (start_at >= '2010-06-06 05:00:00' AND end_at <= '2010-10-01 04:59:59')
Rendered vendor/engines/courses/app/views/courses/_calendar_entry.html.erb (0.8ms)
Rendered vendor/engines/course_categories/app/views/course_categories/_course_category.html.erb (1102.1ms)
Rendered vendor/engines/courses/app/views/courses/_calendar_nav.html.erb (2.1ms)
Rendered themes/oxbow/views/shared/_courses_subnav.html.erb (4.8ms)
Rendered themes/oxbow/views/shared/_content_page.html.erb (1.5ms)
Rendered themes/oxbow/views/shared/_head.html.erb (2.6ms)
User Load (0.8ms) SELECT `users`.* FROM `users` WHERE (`users`.`id` = 5) LIMIT 1
Rendered themes/oxbow/views/shared/_site_bar.html.erb (14.4ms)
Rendered themes/oxbow/views/shared/_search.html.erb (0.9ms)
Rendered themes/oxbow/views/shared/_header.html.erb (4.2ms)
Rendered themes/oxbow/views/shared/_footer_logo.html.erb (0.5ms)
Rendered themes/oxbow/views/shared/_campus_address.html.erb (0.3ms)
Rendered themes/oxbow/views/shared/_office_address.html.erb (0.2ms)
Rendered themes/oxbow/views/shared/_saic_logo.html.erb (0.2ms)
Rendered themes/oxbow/views/shared/_footer.html.erb (9.7ms)
Rendered vendor/engines/courses/app/views/courses/calendar.html.erb within layouts/application (1183.0ms)
CACHE (0.0ms) SELECT `users`.* FROM `users` WHERE (`users`.`id` = 5) LIMIT 1
Completed 200 OK in 1640ms (Views: 724.7ms | ActiveRecord: 557.9ms)
/Users/joe/.rvm/rubies/ruby-1.8.7-p302/lib/ruby/1.8/timeout.rb:58: [BUG] Segmentation fault
ruby 1.8.7 (2010-08-16 patchlevel 302) [i686-darwin10.3.0]
Abort trap
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment