jcreed · November 17, 2015 21:42 · BenKanouse · Nov 17, 2015
diff --git a/WA-3876 - working locally b/WA-3876 - working locally
 Started GET "/search?utf8=%E2%9C%93&last_name=z&first_name=a&cas_id=&professional_pin=&state=&email=&application_status=350&local_status=&decision_code=&designation_submitted_date=&designation=&application_last_changed_on=&reviewer=&_submit=1" for 127.0.0.1 at 2015-11-17 16:32:58 -0500
  Processing by Search::SearchesController#show as HTML
  Parameters: {"utf8"=>"✓", "last_name"=>"z", "first_name"=>"a", "cas_id"=>"", "professional_pin"=>"", "state"=>"", "email"=>"", "application_status"=>"350", "local_status"=>"", "decision_code"=>"", "designation_submitted_date"=>"", "designation"=>"", "application_last_changed_on"=>"", "reviewer"=>"", "_submit"=>"1"}
   (0.1ms)  SHOW search_path
  User Load (5.5ms)  SELECT "users".* FROM "users" WHERE "users"."id" = 106 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
   (0.1ms)  BEGIN /*application:Webadmit,controller:searches,action:show*/
   (0.4ms)  UPDATE "users" SET "last_request_at" = '2015-11-17 21:32:59.447698', "perishable_token" = '4ikt8BwAdieeafkdrgG', "updated_at" = '2015-11-17 21:32:59.449253' WHERE "users"."id" = 106
   (0.4ms)  COMMIT /*application:Webadmit,controller:searches,action:show*/
  Permissions::UserIdentity Load (2.4ms)  SELECT "user_identities".* FROM "user_identities" WHERE "user_identities"."id" = 27962 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
   (0.1ms)  BEGIN /*application:Webadmit,controller:searches,action:show*/
   (0.6ms)  SELECT 1 FROM "users" WHERE ("users"."email" = '[email protected]' AND "users"."id" != 106) LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
   (0.3ms)  UPDATE "users" SET "perishable_token" = 'oiWmDYlsRoiHYSekuC5', "updated_at" = '2015-11-17 21:32:59.571687' WHERE "users"."id" = 106
   (0.8ms)  COMMIT /*application:Webadmit,controller:searches,action:show*/
  Permissions::Role Load (3.2ms)  SELECT "roles".id FROM "roles" INNER JOIN "user_identity_roles" ON "roles"."id" = "user_identity_roles"."role_id" WHERE "user_identity_roles"."user_identity_id" = 27962 /*application:Webadmit,controller:searches,action:show*/
  Permissions::Right Load (5.0ms)  SELECT DISTINCT "rights".id, "rights".* FROM "rights" INNER JOIN "right_assignments" ON "right_assignments"."right_id" = "rights"."id" WHERE "right_assignments"."role_id" IN (73, 40, 64, 40, 40) /*application:Webadmit,controller:searches,action:show*/
  Organization Load (5.3ms)  SELECT "organizations".* FROM "organizations" INNER JOIN "user_identity_organizations" ON "organizations"."id" = "user_identity_organizations"."organization_id" WHERE "user_identity_organizations"."user_identity_id" = 27962 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  Association Load (4.7ms)  SELECT "associations".* FROM "associations" INNER JOIN "user_identity_cases" ON "associations"."id" = "user_identity_cases"."association_id" WHERE "user_identity_cases"."user_identity_id" = 27962 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  Splash Load (4.1ms)  SELECT "splashes".* FROM "splashes" INNER JOIN "cas_splashes" ON "cas_splashes"."splash_id" = "splashes"."id" WHERE "cas_splashes"."association_id" = 45 AND (ends_at >= to_timestamp(1447795983) OR ends_at = NULL) /*application:Webadmit,controller:searches,action:show*/
 Creating scope :accessible_by. Overwriting existing method Program.accessible_by.
  Program Load (1.0ms)  SELECT "programs".id FROM "programs" INNER JOIN "user_identity_programs" ON "programs"."id" = "user_identity_programs"."program_id" WHERE "programs"."type" IN ('Program') AND "user_identity_programs"."user_identity_id" = 27962 /*application:Webadmit,controller:searches,action:show*/
  Field Load (3.2ms)  SELECT "fields".* FROM "fields" WHERE "fields"."identifier" = '' AND ( fields.id IN (SELECT field_id
 FROM associations_fields
 WHERE association_id in (45))
 OR fields.organization_id IS NOT NULL
 ) AND (organization_id IS NULL OR organization_id IN (2969)) LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
 Update: #sort  sort_field
 Updating state hash: {"scopes"=>{"sort_field"=>"#sort"}, "triggers"=>{"#sort"=>nil}}
   (0.1ms)  BEGIN /*application:Webadmit,controller:searches,action:show*/
  Permissions::Role Load (0.3ms)  SELECT "roles".* FROM "roles" WHERE "roles"."id" = 64 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
   (0.2ms)  SELECT 1 FROM "associations" WHERE ("associations"."cas_id" = 3 AND "associations"."id" != 45 AND "associations"."cycle_id" = 5) LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
   (0.3ms)  UPDATE "associations" SET "updated_at" = '2015-11-17 21:33:04.179593' WHERE "associations"."id" = 45
  Association Load (0.3ms)  SELECT "associations".* FROM "associations" WHERE "associations"."id" = 45 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
   (0.2ms)  SELECT 1 FROM "organizations" WHERE ("organizations"."identifier" = 'GROUP5' AND "organizations"."id" != 2969 AND "organizations"."association_id" = 45) LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
   (0.3ms)  UPDATE "organizations" SET "updated_at" = '2015-11-17 21:33:04.272451' WHERE "organizations"."id" = 2969
   (4.9ms)  COMMIT /*application:Webadmit,controller:searches,action:show*/
  Program Load (0.5ms)  SELECT "programs".id FROM "programs" INNER JOIN "user_identity_programs" ON "programs"."id" = "user_identity_programs"."program_id" WHERE "programs"."type" IN ('Program') AND "user_identity_programs"."user_identity_id" = 27962 /*application:Webadmit,controller:searches,action:show*/
  Field Load (0.5ms)  SELECT "fields".* FROM "fields" WHERE "fields"."identifier" = 'utf8' AND ( fields.id IN (SELECT field_id
 FROM associations_fields
 WHERE association_id in (45))
 OR fields.organization_id IS NOT NULL
 ) AND (organization_id IS NULL OR organization_id IN (2969)) LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".id FROM "programs" INNER JOIN "user_identity_programs" ON "programs"."id" = "user_identity_programs"."program_id" WHERE "programs"."type" IN ('Program') AND "user_identity_programs"."user_identity_id" = 27962
  Field Load (0.8ms)  SELECT "fields".* FROM "fields" WHERE "fields"."identifier" = 'last_name' AND ( fields.id IN (SELECT field_id
 FROM associations_fields
 WHERE association_id in (45))
 OR fields.organization_id IS NOT NULL
 ) AND (organization_id IS NULL OR organization_id IN (2969)) LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
   (0.1ms)  BEGIN /*application:Webadmit,controller:searches,action:show*/
   (0.1ms)  COMMIT /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".id FROM "programs" INNER JOIN "user_identity_programs" ON "programs"."id" = "user_identity_programs"."program_id" WHERE "programs"."type" IN ('Program') AND "user_identity_programs"."user_identity_id" = 27962
  Field Load (0.8ms)  SELECT "fields".* FROM "fields" WHERE "fields"."identifier" = 'first_name' AND ( fields.id IN (SELECT field_id
 FROM associations_fields
 WHERE association_id in (45))
 OR fields.organization_id IS NOT NULL
 ) AND (organization_id IS NULL OR organization_id IN (2969)) LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
   (0.0ms)  BEGIN /*application:Webadmit,controller:searches,action:show*/
   (0.1ms)  COMMIT /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".id FROM "programs" INNER JOIN "user_identity_programs" ON "programs"."id" = "user_identity_programs"."program_id" WHERE "programs"."type" IN ('Program') AND "user_identity_programs"."user_identity_id" = 27962
  Field Load (0.7ms)  SELECT "fields".* FROM "fields" WHERE "fields"."identifier" = 'cas_id' AND ( fields.id IN (SELECT field_id
 FROM associations_fields
 WHERE association_id in (45))
 OR fields.organization_id IS NOT NULL
 ) AND (organization_id IS NULL OR organization_id IN (2969)) LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".id FROM "programs" INNER JOIN "user_identity_programs" ON "programs"."id" = "user_identity_programs"."program_id" WHERE "programs"."type" IN ('Program') AND "user_identity_programs"."user_identity_id" = 27962
  Field Load (0.6ms)  SELECT "fields".* FROM "fields" WHERE "fields"."identifier" = 'professional_pin' AND ( fields.id IN (SELECT field_id
 FROM associations_fields
 WHERE association_id in (45))
 OR fields.organization_id IS NOT NULL
 ) AND (organization_id IS NULL OR organization_id IN (2969)) LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".id FROM "programs" INNER JOIN "user_identity_programs" ON "programs"."id" = "user_identity_programs"."program_id" WHERE "programs"."type" IN ('Program') AND "user_identity_programs"."user_identity_id" = 27962
  Field Load (0.6ms)  SELECT "fields".* FROM "fields" WHERE "fields"."identifier" = 'state' AND ( fields.id IN (SELECT field_id
 FROM associations_fields
 WHERE association_id in (45))
 OR fields.organization_id IS NOT NULL
 ) AND (organization_id IS NULL OR organization_id IN (2969)) LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".id FROM "programs" INNER JOIN "user_identity_programs" ON "programs"."id" = "user_identity_programs"."program_id" WHERE "programs"."type" IN ('Program') AND "user_identity_programs"."user_identity_id" = 27962
  Field Load (0.6ms)  SELECT "fields".* FROM "fields" WHERE "fields"."identifier" = 'email' AND ( fields.id IN (SELECT field_id
 FROM associations_fields
 WHERE association_id in (45))
 OR fields.organization_id IS NOT NULL
 ) AND (organization_id IS NULL OR organization_id IN (2969)) LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".id FROM "programs" INNER JOIN "user_identity_programs" ON "programs"."id" = "user_identity_programs"."program_id" WHERE "programs"."type" IN ('Program') AND "user_identity_programs"."user_identity_id" = 27962
  Field Load (0.6ms)  SELECT "fields".* FROM "fields" WHERE "fields"."identifier" = 'application_status' AND ( fields.id IN (SELECT field_id
 FROM associations_fields
 WHERE association_id in (45))
 OR fields.organization_id IS NOT NULL
 ) AND (organization_id IS NULL OR organization_id IN (2969)) LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
   (0.1ms)  BEGIN /*application:Webadmit,controller:searches,action:show*/
   (0.1ms)  COMMIT /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".id FROM "programs" INNER JOIN "user_identity_programs" ON "programs"."id" = "user_identity_programs"."program_id" WHERE "programs"."type" IN ('Program') AND "user_identity_programs"."user_identity_id" = 27962
  Field Load (0.8ms)  SELECT "fields".* FROM "fields" WHERE "fields"."identifier" = 'local_status' AND ( fields.id IN (SELECT field_id
 FROM associations_fields
 WHERE association_id in (45))
 OR fields.organization_id IS NOT NULL
 ) AND (organization_id IS NULL OR organization_id IN (2969)) LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".id FROM "programs" INNER JOIN "user_identity_programs" ON "programs"."id" = "user_identity_programs"."program_id" WHERE "programs"."type" IN ('Program') AND "user_identity_programs"."user_identity_id" = 27962
  Field Load (0.7ms)  SELECT "fields".* FROM "fields" WHERE "fields"."identifier" = 'decision_code' AND ( fields.id IN (SELECT field_id
 FROM associations_fields
 WHERE association_id in (45))
 OR fields.organization_id IS NOT NULL
 ) AND (organization_id IS NULL OR organization_id IN (2969)) LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".id FROM "programs" INNER JOIN "user_identity_programs" ON "programs"."id" = "user_identity_programs"."program_id" WHERE "programs"."type" IN ('Program') AND "user_identity_programs"."user_identity_id" = 27962
  Field Load (0.6ms)  SELECT "fields".* FROM "fields" WHERE "fields"."identifier" = 'designation_submitted_date' AND ( fields.id IN (SELECT field_id
 FROM associations_fields
 WHERE association_id in (45))
 OR fields.organization_id IS NOT NULL
 ) AND (organization_id IS NULL OR organization_id IN (2969)) LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".id FROM "programs" INNER JOIN "user_identity_programs" ON "programs"."id" = "user_identity_programs"."program_id" WHERE "programs"."type" IN ('Program') AND "user_identity_programs"."user_identity_id" = 27962
  Field Load (0.6ms)  SELECT "fields".* FROM "fields" WHERE "fields"."identifier" = 'designation' AND ( fields.id IN (SELECT field_id
 FROM associations_fields
 WHERE association_id in (45))
 OR fields.organization_id IS NOT NULL
 ) AND (organization_id IS NULL OR organization_id IN (2969)) LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".id FROM "programs" INNER JOIN "user_identity_programs" ON "programs"."id" = "user_identity_programs"."program_id" WHERE "programs"."type" IN ('Program') AND "user_identity_programs"."user_identity_id" = 27962
  Field Load (0.6ms)  SELECT "fields".* FROM "fields" WHERE "fields"."identifier" = 'application_last_changed_on' AND ( fields.id IN (SELECT field_id
 FROM associations_fields
 WHERE association_id in (45))
 OR fields.organization_id IS NOT NULL
 ) AND (organization_id IS NULL OR organization_id IN (2969)) LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".id FROM "programs" INNER JOIN "user_identity_programs" ON "programs"."id" = "user_identity_programs"."program_id" WHERE "programs"."type" IN ('Program') AND "user_identity_programs"."user_identity_id" = 27962
  Field Load (0.6ms)  SELECT "fields".* FROM "fields" WHERE "fields"."identifier" = 'reviewer' AND ( fields.id IN (SELECT field_id
 FROM associations_fields
 WHERE association_id in (45))
 OR fields.organization_id IS NOT NULL
 ) AND (organization_id IS NULL OR organization_id IN (2969)) LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".id FROM "programs" INNER JOIN "user_identity_programs" ON "programs"."id" = "user_identity_programs"."program_id" WHERE "programs"."type" IN ('Program') AND "user_identity_programs"."user_identity_id" = 27962
  Field Load (0.4ms)  SELECT "fields".* FROM "fields" WHERE "fields"."identifier" = '_submit' AND ( fields.id IN (SELECT field_id
 FROM associations_fields
 WHERE association_id in (45))
 OR fields.organization_id IS NOT NULL
 ) AND (organization_id IS NULL OR organization_id IN (2969)) LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".id FROM "programs" INNER JOIN "user_identity_programs" ON "programs"."id" = "user_identity_programs"."program_id" WHERE "programs"."type" IN ('Program') AND "user_identity_programs"."user_identity_id" = 27962
  Field Load (0.5ms)  SELECT "fields".* FROM "fields" WHERE "fields"."identifier" = 'action' AND ( fields.id IN (SELECT field_id
 FROM associations_fields
 WHERE association_id in (45))
 OR fields.organization_id IS NOT NULL
 ) AND (organization_id IS NULL OR organization_id IN (2969)) LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".id FROM "programs" INNER JOIN "user_identity_programs" ON "programs"."id" = "user_identity_programs"."program_id" WHERE "programs"."type" IN ('Program') AND "user_identity_programs"."user_identity_id" = 27962
  Field Load (0.5ms)  SELECT "fields".* FROM "fields" WHERE "fields"."identifier" = 'controller' AND ( fields.id IN (SELECT field_id
 FROM associations_fields
 WHERE association_id in (45))
 OR fields.organization_id IS NOT NULL
 ) AND (organization_id IS NULL OR organization_id IN (2969)) LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".id FROM "programs" INNER JOIN "user_identity_programs" ON "programs"."id" = "user_identity_programs"."program_id" WHERE "programs"."type" IN ('Program') AND "user_identity_programs"."user_identity_id" = 27962
  CACHE (0.0ms)  SELECT "programs".id FROM "programs" INNER JOIN "user_identity_programs" ON "programs"."id" = "user_identity_programs"."program_id" WHERE "programs"."type" IN ('Program') AND "user_identity_programs"."user_identity_id" = 27962
  Field Load (11.4ms)  SELECT "fields".* FROM "fields" WHERE ( fields.id IN (SELECT field_id
 FROM associations_fields
 WHERE association_id in (45))
 OR fields.organization_id IS NOT NULL
 ) AND (organization_id IS NULL OR organization_id IN (2969)) AND (search_order IS NOT NULL) ORDER BY search_order /*application:Webadmit,controller:searches,action:show*/
 Creating scope :active. Overwriting existing method LocalStatus.active.
 Creating scope :inactive. Overwriting existing method LocalStatus.inactive.
  CACHE (0.0ms)  SELECT "programs".id FROM "programs" INNER JOIN "user_identity_programs" ON "programs"."id" = "user_identity_programs"."program_id" WHERE "programs"."type" IN ('Program') AND "user_identity_programs"."user_identity_id" = 27962
   (0.1ms)  SHOW search_path
  Applicant Load (2.0ms)  SELECT "applicants".id FROM "applicants" INNER JOIN "list_exclude" ON "applicants"."id" = "list_exclude"."applicant_id" WHERE "list_exclude"."list_id" IS NULL /*application:Webadmit,controller:searches,action:show*/
  Applicant Load (1.5ms)  SELECT "applicants".id FROM "applicants" INNER JOIN "list_include" ON "applicants"."id" = "list_include"."applicant_id" WHERE "list_include"."list_id" IS NULL /*application:Webadmit,controller:searches,action:show*/
  Program Load (0.7ms)  SELECT "programs".* FROM "programs" INNER JOIN "user_identity_programs" ON "programs"."id" = "user_identity_programs"."program_id" WHERE "programs"."type" IN ('Program') AND "user_identity_programs"."user_identity_id" = 27962 /*application:Webadmit,controller:searches,action:show*/
  Organization Load (0.5ms)  SELECT "organizations".* FROM "organizations" WHERE "organizations"."id" = 2969 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  Association Load (0.3ms)  SELECT "associations".* FROM "associations" WHERE "associations"."id" = 45 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  Field Load (2.4ms)  SELECT "fields".* FROM "fields" WHERE "fields"."default_sort" = 't' AND ( fields.id IN (SELECT field_id
 FROM associations_fields
 WHERE association_id in (45))
 OR fields.organization_id IS NOT NULL
 ) AND (organization_id IS NULL OR organization_id IN (2969)) LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "fields".* FROM "fields" WHERE "fields"."default_sort" = 't' AND ( fields.id IN (SELECT field_id
 FROM associations_fields
 WHERE association_id in (45))
 OR fields.organization_id IS NOT NULL
 ) AND (organization_id IS NULL OR organization_id IN (2969)) LIMIT 1
  Applicant Load (34949.7ms)  SELECT DISTINCT "applicants".id, "applicants".*, LOWER("applicants"."cas_id"), LOWER("applicants"."email"), LOWER("applicants"."first_name"), LOWER("applicants"."last_name") FROM "applicants" INNER JOIN "designations" ON "designations"."applicant_id" = "applicants"."id" INNER JOIN "programs" ON "programs"."id" = "designations"."program_id" AND "programs"."type" IN ('Program') INNER JOIN "user_identity_programs" ON "user_identity_programs"."program_id" = "programs"."id" INNER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') LEFT OUTER JOIN "applicant_designation_details" ON "applicant_designation_details"."applicant_id" = "applicants"."id" AND "applicant_designation_details"."id" IN (SELECT "applicant_designation_details"."id" FROM "applicant_designation_details" WHERE "applicant_designation_details"."program_id" IN (9871, 9874, 9875, 9899) AND "applicant_designation_details"."applicant_id" IN (SELECT DISTINCT "applicants"."id" FROM "applicants" INNER JOIN "designations" ON "designations"."applicant_id" = "applicants"."id" INNER JOIN "programs" ON "programs"."id" = "designations"."program_id" AND "programs"."type" IN ('Program') INNER JOIN "user_identity_programs" ON "user_identity_programs"."program_id" = "programs"."id" WHERE "user_identity_programs"."user_identity_id" = 27962)) WHERE "user_identity_programs"."user_identity_id" = 27962 AND "statuses"."show" = 't' AND (("applicants"."last_name" ILIKE '%z%' AND "applicants"."first_name" ILIKE '%a%' AND "applicant_designation_details"."application_status_id" = '350')) ORDER BY lower("applicants"."last_name") ASC, lower("applicants"."first_name") ASC LIMIT 25 OFFSET 0 /*application:Webadmit,controller:searches,action:show*/
  Applicant Count (34622.3ms)  SELECT COUNT(*) FROM (SELECT DISTINCT "applicants".id, "applicants".*, LOWER("applicants"."cas_id"), LOWER("applicants"."email"), LOWER("applicants"."first_name"), LOWER("applicants"."last_name") FROM "applicants" INNER JOIN "designations" ON "designations"."applicant_id" = "applicants"."id" INNER JOIN "programs" ON "programs"."id" = "designations"."program_id" AND "programs"."type" IN ('Program') INNER JOIN "user_identity_programs" ON "user_identity_programs"."program_id" = "programs"."id" INNER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') LEFT OUTER JOIN "applicant_designation_details" ON "applicant_designation_details"."applicant_id" = "applicants"."id" AND "applicant_designation_details"."id" IN (SELECT "applicant_designation_details"."id" FROM "applicant_designation_details" WHERE "applicant_designation_details"."program_id" IN (9871, 9874, 9875, 9899) AND "applicant_designation_details"."applicant_id" IN (SELECT DISTINCT "applicants"."id" FROM "applicants" INNER JOIN "designations" ON "designations"."applicant_id" = "applicants"."id" INNER JOIN "programs" ON "programs"."id" = "designations"."program_id" AND "programs"."type" IN ('Program') INNER JOIN "user_identity_programs" ON "user_identity_programs"."program_id" = "programs"."id" WHERE "user_identity_programs"."user_identity_id" = 27962)) WHERE "user_identity_programs"."user_identity_id" = 27962 AND "statuses"."show" = 't' AND (("applicants"."last_name" ILIKE '%z%' AND "applicants"."first_name" ILIKE '%a%' AND "applicant_designation_details"."application_status_id" = '350')) ORDER BY lower("applicants"."last_name") ASC, lower("applicants"."first_name") ASC) AS count_table /*application:Webadmit,controller:searches,action:show*/
  HelpText Load (1.2ms)  SELECT "help_texts".* FROM "help_texts" WHERE "help_texts"."key" = 'search' LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  Field Load (4.6ms)  SELECT "fields".* FROM "fields" WHERE ( fields.id IN (SELECT field_id
 FROM associations_fields
 WHERE association_id in (45))
 OR fields.organization_id IS NOT NULL
 ) AND (organization_id IS NULL OR organization_id IN (2969)) AND (assignment_sort_order IS NOT NULL) ORDER BY "fields"."assignment_sort_order" /*application:Webadmit,controller:searches,action:show*/
 Rendered search/base_searches/_sort_options.html.haml (8.9ms)
   (3.8ms)  SELECT 1 FROM "assignment_type_bases" INNER JOIN "assignment_type_bases_programs" ON "assignment_type_bases_programs"."assignment_type_base_id" = "assignment_type_bases"."id" INNER JOIN "programs" ON "programs"."id" = "assignment_type_bases_programs"."program_id" AND "programs"."type" IN ('Program') INNER JOIN "user_identity_programs" ON "user_identity_programs"."program_id" = "programs"."id" WHERE "assignment_type_bases"."type" IN ('Assignments::AssignmentType') AND "user_identity_programs"."user_identity_id" = 27962 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
   (1.0ms)  SELECT 1 FROM "assignment_type_bases" INNER JOIN "assignment_type_bases_programs" ON "assignment_type_bases_programs"."assignment_type_base_id" = "assignment_type_bases"."id" INNER JOIN "programs" ON "programs"."id" = "assignment_type_bases_programs"."program_id" AND "programs"."type" IN ('Program') INNER JOIN "user_identity_programs" ON "user_identity_programs"."program_id" = "programs"."id" WHERE "assignment_type_bases"."type" IN ('Interviews::InterviewType') AND "user_identity_programs"."user_identity_id" = 27962 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
   (4.2ms)  SELECT 1 FROM "question_bases" INNER JOIN "custom_fields_programs" ON "custom_fields_programs"."custom_field_id" = "question_bases"."id" WHERE "question_bases"."type" IN ('CustomField') AND "custom_fields_programs"."program_id" IN (9871, 9874, 9875, 9899) LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
   (5.0ms)  SELECT COUNT(*) FROM "criteria" INNER JOIN "requirements" ON "criteria"."requirement_id" = "requirements"."id" AND "criteria"."requirement_type" = 'Requirement' WHERE "requirements"."type" IN ('Requirement') AND "requirements"."organization_id" = 2969 AND "requirements"."type" = 'Requirement' AND "criteria"."requirement_id" IN (SELECT "requirements"."id" FROM "requirements" WHERE "requirements"."type" IN ('Requirement') AND "requirements"."active" = 't') /*application:Webadmit,controller:searches,action:show*/
  ApplicationStatus Load (0.4ms)  SELECT "statuses".* FROM "statuses" WHERE "statuses"."association_id" = 45 AND "statuses"."show" = 't' AND "statuses"."type" IN ('ApplicationStatus') ORDER BY "order", "statuses"."order" /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "applicants".id FROM "applicants" INNER JOIN "list_exclude" ON "applicants"."id" = "list_exclude"."applicant_id" WHERE "list_exclude"."list_id" IS NULL
  CACHE (0.0ms)  SELECT "applicants".id FROM "applicants" INNER JOIN "list_include" ON "applicants"."id" = "list_include"."applicant_id" WHERE "list_include"."list_id" IS NULL
  CACHE (0.0ms)  SELECT "fields".* FROM "fields" WHERE "fields"."default_sort" = 't' AND ( fields.id IN (SELECT field_id
 FROM associations_fields
 WHERE association_id in (45))
 OR fields.organization_id IS NOT NULL
 ) AND (organization_id IS NULL OR organization_id IN (2969)) LIMIT 1
  CACHE (0.0ms)  SELECT "fields".* FROM "fields" WHERE "fields"."default_sort" = 't' AND ( fields.id IN (SELECT field_id
 FROM associations_fields
 WHERE association_id in (45))
 OR fields.organization_id IS NOT NULL
 ) AND (organization_id IS NULL OR organization_id IN (2969)) LIMIT 1
   (34806.7ms)  SELECT COUNT(DISTINCT "applicants".id) FROM "applicants" INNER JOIN "designations" ON "designations"."applicant_id" = "applicants"."id" INNER JOIN "programs" ON "programs"."id" = "designations"."program_id" AND "programs"."type" IN ('Program') INNER JOIN "user_identity_programs" ON "user_identity_programs"."program_id" = "programs"."id" INNER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') LEFT OUTER JOIN "applicant_designation_details" ON "applicant_designation_details"."applicant_id" = "applicants"."id" AND "applicant_designation_details"."id" IN (SELECT "applicant_designation_details"."id" FROM "applicant_designation_details" WHERE "applicant_designation_details"."program_id" IN (9871, 9874, 9875, 9899) AND "applicant_designation_details"."applicant_id" IN (SELECT DISTINCT "applicants"."id" FROM "applicants" INNER JOIN "designations" ON "designations"."applicant_id" = "applicants"."id" INNER JOIN "programs" ON "programs"."id" = "designations"."program_id" AND "programs"."type" IN ('Program') INNER JOIN "user_identity_programs" ON "user_identity_programs"."program_id" = "programs"."id" WHERE "user_identity_programs"."user_identity_id" = 27962)) WHERE "user_identity_programs"."user_identity_id" = 27962 AND "statuses"."show" = 't' AND (("applicants"."last_name" ILIKE '%z%' AND "applicants"."first_name" ILIKE '%a%' AND "applicant_designation_details"."application_status_id" = '350')) /*application:Webadmit,controller:searches,action:show*/
 Rendered lists/_count.html.haml (34925.8ms)
 Rendered search/base_searches/_field.html.haml (2.3ms)
 Rendered search/base_searches/_field.html.haml (0.3ms)
 Rendered search/base_searches/_field.html.haml (0.5ms)
 Rendered search/base_searches/_field.html.haml (0.5ms)
 WARNING: Using implicit order scope on State. Please migrate to 'accessible_by' and 'ordered'.
  State Load (1.1ms)  SELECT "states".* FROM "states" /*application:Webadmit,controller:searches,action:show*/
 Rendered search/base_searches/_field.html.haml (33.4ms)
 Rendered search/base_searches/_field.html.haml (0.4ms)
  CACHE (0.0ms)  SELECT "statuses".* FROM "statuses" WHERE "statuses"."association_id" = 45 AND "statuses"."show" = 't' AND "statuses"."type" IN ('ApplicationStatus') ORDER BY "order", "statuses"."order"
 Rendered search/base_searches/_field.html.haml (2.9ms)
  LocalStatus Load (5.5ms)  SELECT DISTINCT "local_statuses".id, "local_statuses".* FROM "local_statuses" INNER JOIN "local_statuses_programs" ON "local_statuses_programs"."local_status_id" = "local_statuses"."id" WHERE "local_statuses"."active" = 't' AND (local_statuses_programs.program_id in (9871,9874,9875,9899)) ORDER BY "local_statuses"."order" /*application:Webadmit,controller:searches,action:show*/
 Rendered search/base_searches/_field.html.haml (123.6ms)
  Decision Load (2.6ms)  SELECT "decisions".* FROM "decisions" WHERE "decisions"."association_id" = 45 ORDER BY "decisions"."position", "decisions"."name" /*application:Webadmit,controller:searches,action:show*/
 Rendered search/base_searches/_field.html.haml (17.2ms)
 Rendered search/base_searches/_field.html.haml (0.4ms)
  Program Load (0.6ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" IN (9871, 9874, 9875, 9899) ORDER BY "programs"."name" /*application:Webadmit,controller:searches,action:show*/
 Rendered search/base_searches/_field.html.haml (3.4ms)
 Rendered search/base_searches/_field.html.haml (0.4ms)
  Permissions::UserIdentity Load (0.7ms)  SELECT "user_identities".* FROM "user_identities" INNER JOIN "user_identity_organizations" ON "user_identities"."id" = "user_identity_organizations"."user_identity_id" WHERE "user_identity_organizations"."organization_id" = 2969 /*application:Webadmit,controller:searches,action:show*/
  SQL (1.1ms)  SELECT "user_identities"."id" AS t0_r0, "user_identities"."user_id" AS t0_r1, "user_identities"."type" AS t0_r2, "user_identities"."ui_state" AS t0_r3, "user_identities"."clipboard_id" AS t0_r4, "user_identities"."active" AS t0_r5, "user_identities"."updated_at" AS t0_r6, "user_identities"."created_at" AS t0_r7, "user_identities"."admin_note" AS t0_r8, "users"."id" AS t1_r0, "users"."association_id" AS t1_r1, "users"."organization_id" AS t1_r2, "users"."username" AS t1_r3, "users"."created_at" AS t1_r4, "users"."updated_at" AS t1_r5, "users"."email" AS t1_r6, "users"."crypted_password" AS t1_r7, "users"."password_salt" AS t1_r8, "users"."persistence_token" AS t1_r9, "users"."single_access_token" AS t1_r10, "users"."perishable_token" AS t1_r11, "users"."login_count" AS t1_r12, "users"."failed_login_count" AS t1_r13, "users"."current_login_at" AS t1_r14, "users"."last_login_at" AS t1_r15, "users"."current_login_ip" AS t1_r16, "users"."last_login_ip" AS t1_r17, "users"."first_name" AS t1_r18, "users"."last_name" AS t1_r19, "users"."phone_number" AS t1_r20, "users"."ui_state" AS t1_r21, "users"."system_user" AS t1_r22, "users"."clipboard_id" AS t1_r23, "users"."last_splash_id" AS t1_r24, "users"."extension" AS t1_r25, "users"."type" AS t1_r26, "users"."is_active" AS t1_r27, "users"."primary" AS t1_r28, "users"."last_user_identity_id" AS t1_r29, "users"."position" AS t1_r30, "users"."hide_cycle_switcher_hint" AS t1_r31, "users"."last_request_at" AS t1_r32, "users"."password_updated_at" AS t1_r33 FROM "user_identities" LEFT OUTER JOIN "users" ON "users"."id" = "user_identities"."user_id" WHERE "user_identities"."id" IN (27968, 27960, 27961, 27962, 27963, 27964, 27965, 29026, 29245, 35153, 31868, 31869, 43152) AND "user_identities"."active" = 't' ORDER BY users.email /*application:Webadmit,controller:searches,action:show*/
 Rendered search/base_searches/_field.html.haml (109.5ms)
 Rendered search/base_searches/_search.html.haml (35260.2ms)
   (3.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first') /*application:Webadmit,controller:searches,action:show*/
  SQL (1.2ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 411090 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  Program Load (0.4ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9874 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  LocalStatus Load (0.4ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34544 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  Decision Load (0.2ms)  SELECT "decisions".* FROM "decisions" WHERE "decisions"."id" = 455 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  Program Load (0.4ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9871 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  LocalStatus Load (0.4ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34571 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first')
  SQL (1.4ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 410459 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  Program Load (0.4ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9899 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34544 LIMIT 1
  CACHE (0.0ms)  SELECT "decisions".* FROM "decisions" WHERE "decisions"."id" = 455 LIMIT 1
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9871 LIMIT 1
  CACHE (0.0ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34571 LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first')
  SQL (1.4ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 428318 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9874 LIMIT 1
  LocalStatus Load (0.2ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34558 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first')
  SQL (2.0ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 432930 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9871 LIMIT 1
  LocalStatus Load (0.3ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34543 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "decisions".* FROM "decisions" WHERE "decisions"."id" = 455 LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first')
  SQL (2.8ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 431240 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9899 LIMIT 1
  LocalStatus Load (0.3ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34546 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "decisions".* FROM "decisions" WHERE "decisions"."id" = 455 LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first')
  SQL (2.9ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 407710 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9871 LIMIT 1
  CACHE (0.0ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34546 LIMIT 1
  CACHE (0.0ms)  SELECT "decisions".* FROM "decisions" WHERE "decisions"."id" = 455 LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first')
  SQL (1.6ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 408642 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9871 LIMIT 1
  CACHE (0.0ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34546 LIMIT 1
  CACHE (0.0ms)  SELECT "decisions".* FROM "decisions" WHERE "decisions"."id" = 455 LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first')
  SQL (1.5ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 431009 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9899 LIMIT 1
  LocalStatus Load (0.3ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34565 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "decisions".* FROM "decisions" WHERE "decisions"."id" = 455 LIMIT 1
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9871 LIMIT 1
  CACHE (0.0ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34571 LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first')
  SQL (2.1ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 517592 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9871 LIMIT 1
  CACHE (0.0ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34544 LIMIT 1
  CACHE (0.0ms)  SELECT "decisions".* FROM "decisions" WHERE "decisions"."id" = 455 LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first')
  SQL (1.6ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 414033 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9899 LIMIT 1
  CACHE (0.0ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34546 LIMIT 1
  CACHE (0.0ms)  SELECT "decisions".* FROM "decisions" WHERE "decisions"."id" = 455 LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first')
  SQL (1.5ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 421772 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9871 LIMIT 1
  LocalStatus Load (0.3ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34566 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  Decision Load (0.2ms)  SELECT "decisions".* FROM "decisions" WHERE "decisions"."id" = 451 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first')
  SQL (2.1ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 462063 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9871 LIMIT 1
  CACHE (0.0ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34546 LIMIT 1
  CACHE (0.0ms)  SELECT "decisions".* FROM "decisions" WHERE "decisions"."id" = 455 LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first')
  SQL (1.6ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 415103 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9899 LIMIT 1
  CACHE (0.0ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34546 LIMIT 1
  CACHE (0.0ms)  SELECT "decisions".* FROM "decisions" WHERE "decisions"."id" = 455 LIMIT 1
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9871 LIMIT 1
  CACHE (0.0ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34571 LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first')
  SQL (1.5ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 415665 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9871 LIMIT 1
  CACHE (0.0ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34546 LIMIT 1
  CACHE (0.0ms)  SELECT "decisions".* FROM "decisions" WHERE "decisions"."id" = 455 LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first')
  SQL (1.4ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 484943 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9899 LIMIT 1
  CACHE (0.0ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34546 LIMIT 1
  CACHE (0.0ms)  SELECT "decisions".* FROM "decisions" WHERE "decisions"."id" = 455 LIMIT 1
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9871 LIMIT 1
  CACHE (0.0ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34571 LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first')
  SQL (1.9ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 417964 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9871 LIMIT 1
  LocalStatus Load (0.3ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34548 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "decisions".* FROM "decisions" WHERE "decisions"."id" = 455 LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first')
  SQL (1.3ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 427648 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9871 LIMIT 1
  CACHE (0.0ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34546 LIMIT 1
  CACHE (0.0ms)  SELECT "decisions".* FROM "decisions" WHERE "decisions"."id" = 455 LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first')
  SQL (1.7ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 437794 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9871 LIMIT 1
  CACHE (0.0ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34558 LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first')
  SQL (1.3ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 447879 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9871 LIMIT 1
  LocalStatus Load (0.3ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34547 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "decisions".* FROM "decisions" WHERE "decisions"."id" = 455 LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first')
  SQL (1.3ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 461980 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9899 LIMIT 1
  CACHE (0.0ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34546 LIMIT 1
  CACHE (0.0ms)  SELECT "decisions".* FROM "decisions" WHERE "decisions"."id" = 455 LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first')
  SQL (1.6ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 427795 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9899 LIMIT 1
  CACHE (0.0ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34566 LIMIT 1
  CACHE (0.0ms)  SELECT "decisions".* FROM "decisions" WHERE "decisions"."id" = 451 LIMIT 1
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9871 LIMIT 1
  CACHE (0.0ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34571 LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first')
  SQL (1.7ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 516394 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9899 LIMIT 1
  CACHE (0.0ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34571 LIMIT 1
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9874 LIMIT 1
  CACHE (0.0ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34565 LIMIT 1
  CACHE (0.0ms)  SELECT "decisions".* FROM "decisions" WHERE "decisions"."id" = 455 LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first')
  SQL (1.4ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 566423 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9899 LIMIT 1
  CACHE (0.0ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34571 LIMIT 1
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9874 LIMIT 1
  CACHE (0.0ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34546 LIMIT 1
  CACHE (0.0ms)  SELECT "decisions".* FROM "decisions" WHERE "decisions"."id" = 455 LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first')
  SQL (1.5ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 410706 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9871 LIMIT 1
  CACHE (0.0ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34546 LIMIT 1
  CACHE (0.0ms)  SELECT "decisions".* FROM "decisions" WHERE "decisions"."id" = 455 LIMIT 1
  CACHE (0.0ms)  SELECT COUNT(*) FROM "features" INNER JOIN "feature_assignments" ON "features"."id" = "feature_assignments"."feature_id" WHERE "feature_assignments"."assignee_id" = 45 AND "feature_assignments"."assignee_type" = 'Association' AND "features"."name" IN ('format_applicant_last_name_first')
  SQL (1.4ms)  SELECT "designations"."id" AS t0_r0, "designations"."identifier" AS t0_r1, "designations"."school_code" AS t0_r2, "designations"."school_name" AS t0_r3, "designations"."school_state" AS t0_r4, "designations"."deadline" AS t0_r5, "designations"."school_short" AS t0_r6, "designations"."school_abbr" AS t0_r7, "designations"."format" AS t0_r8, "designations"."no_lors" AS t0_r9, "designations"."comments" AS t0_r10, "designations"."local_status_id" AS t0_r11, "designations"."applicant_id" AS t0_r12, "designations"."previously_applied" AS t0_r13, "designations"."mailed" AS t0_r14, "designations"."mailed_date" AS t0_r15, "designations"."decision_id" AS t0_r16, "designations"."application_status_id" AS t0_r17, "designations"."program_id" AS t0_r18, "designations"."date_locked" AS t0_r19, "designations"."association_id" AS t0_r20, "designations"."designation_submitted" AS t0_r21, "designations"."application_status_last_updated" AS t0_r22, "designations"."decision_last_updated" AS t0_r23, "designations"."decision_last_updated_by_id" AS t0_r24, "designations"."local_status_last_updated" AS t0_r25, "designations"."local_status_last_updated_by_id" AS t0_r26, "designations"."verified_date" AS t0_r27, "designations"."complete_date" AS t0_r28, "designations"."academic_update_status_id" AS t0_r29, "designations"."academic_update_started_date" AS t0_r30, "designations"."academic_update_submitted_date" AS t0_r31, "designations"."academic_update_verified_date" AS t0_r32, "designations"."first_complete_date" AS t0_r33, "designations"."rank" AS t0_r34, "designations"."early_decision_id" AS t0_r35, "designations"."verified_datetime" AS t0_r36, "designations"."area_of_interest_id" AS t0_r37, "designations"."department_id" AS t0_r38, "designations"."designation_term_id" AS t0_r39, "designations"."application_type_id" AS t0_r40, "designations"."created_at" AS t0_r41, "designations"."updated_at" AS t0_r42, "designations"."enrollment_year" AS t0_r43, "designations"."decision_last_updated_by_user_id" AS t0_r44, "designations"."local_status_last_updated_by_user_id" AS t0_r45, "designations"."designation_degree_id" AS t0_r46, "designations"."organization_institution_number" AS t0_r47, "designations"."campus_id" AS t0_r48, "designations"."postmatch_consideration" AS t0_r49, "designations"."previous_application_year" AS t0_r50, "designations"."previous_matriculation_year" AS t0_r51, "designations"."previous_matriculation_comments" AS t0_r52, "designations"."previous_matriculation_school_id" AS t0_r53, "designations"."previous_matriculation_school_name" AS t0_r54, "designations"."previous_matriculation_indicator" AS t0_r55, "statuses"."id" AS t1_r0, "statuses"."association_id" AS t1_r1, "statuses"."title" AS t1_r2, "statuses"."created_at" AS t1_r3, "statuses"."updated_at" AS t1_r4, "statuses"."show" AS t1_r5, "statuses"."order" AS t1_r6, "statuses"."identifier" AS t1_r7, "statuses"."type" AS t1_r8 FROM "designations" LEFT OUTER JOIN "statuses" ON "statuses"."id" = "designations"."application_status_id" AND "statuses"."type" IN ('ApplicationStatus') JOIN programs ON designations.program_id = programs.id WHERE "designations"."applicant_id" = 409838 AND (designations.program_id in (9871,9874,9875,9899) AND statuses.show = 't') ORDER BY programs.name ASC /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "programs".* FROM "programs" WHERE "programs"."type" IN ('Program') AND "programs"."id" = 9874 LIMIT 1
  CACHE (0.0ms)  SELECT "local_statuses".* FROM "local_statuses" WHERE "local_statuses"."id" = 34546 LIMIT 1
  CACHE (0.0ms)  SELECT "decisions".* FROM "decisions" WHERE "decisions"."id" = 455 LIMIT 1
 Rendered lists/_applicants.html.haml (1234.8ms)
 Rendered search/base_searches/show.html.haml within layouts/slim_detail (37035.2ms)
 Rendered layouts/_htmlhead.html.haml (6.3ms)
  Permissions::UserIdentity Load (0.3ms)  SELECT "user_identities".* FROM "user_identities" WHERE "user_identities"."user_id" = 106 AND "user_identities"."active" = 't' /*application:Webadmit,controller:searches,action:show*/
  Association Load (0.5ms)  SELECT "associations".* FROM "associations" INNER JOIN "user_identity_cases" ON "associations"."id" = "user_identity_cases"."association_id" WHERE "user_identity_cases"."user_identity_id" = 27962 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  Cycle Load (1.3ms)  SELECT "cycles".* FROM "cycles" WHERE "cycles"."id" = 5 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  Organization Load (0.5ms)  SELECT "organizations".* FROM "organizations" INNER JOIN "user_identity_organizations" ON "organizations"."id" = "user_identity_organizations"."organization_id" WHERE "user_identity_organizations"."user_identity_id" = 27962 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  Association Load (0.5ms)  SELECT "associations".* FROM "associations" INNER JOIN "user_identity_cases" ON "associations"."id" = "user_identity_cases"."association_id" WHERE "user_identity_cases"."user_identity_id" = 4811 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  Cycle Load (0.1ms)  SELECT "cycles".* FROM "cycles" WHERE "cycles"."id" = 3 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  Organization Load (0.4ms)  SELECT "organizations".* FROM "organizations" INNER JOIN "user_identity_organizations" ON "organizations"."id" = "user_identity_organizations"."organization_id" WHERE "user_identity_organizations"."user_identity_id" = 4811 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  Association Load (0.3ms)  SELECT "associations".* FROM "associations" INNER JOIN "user_identity_cases" ON "associations"."id" = "user_identity_cases"."association_id" WHERE "user_identity_cases"."user_identity_id" = 10227 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  Cycle Load (0.3ms)  SELECT "cycles".* FROM "cycles" WHERE "cycles"."id" = 4 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  Organization Load (0.4ms)  SELECT "organizations".* FROM "organizations" INNER JOIN "user_identity_organizations" ON "organizations"."id" = "user_identity_organizations"."organization_id" WHERE "user_identity_organizations"."user_identity_id" = 10227 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  Association Load (0.5ms)  SELECT "associations".* FROM "associations" INNER JOIN "user_identity_cases" ON "associations"."id" = "user_identity_cases"."association_id" WHERE "user_identity_cases"."user_identity_id" = 61918 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  Cycle Load (0.3ms)  SELECT "cycles".* FROM "cycles" WHERE "cycles"."id" = 38 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  Organization Load (1.5ms)  SELECT "organizations".* FROM "organizations" INNER JOIN "user_identity_organizations" ON "organizations"."id" = "user_identity_organizations"."organization_id" WHERE "user_identity_organizations"."user_identity_id" = 61918 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
 Rendered layouts/_cycle_switcher_hint.html.haml (47.9ms)
  Institution Load (2.7ms)  SELECT "institutions".* FROM "institutions" INNER JOIN "user_identity_institutions" ON "institutions"."id" = "user_identity_institutions"."institution_id" WHERE "user_identity_institutions"."user_identity_id" = 27962 LIMIT 1 /*application:Webadmit,controller:searches,action:show*/
  CACHE (0.0ms)  SELECT "cycles".* FROM "cycles" WHERE "cycles"."id" = 5 LIMIT 1
 Rendered layouts/_flash.html.haml (2.0ms)
 Rendered layouts/_masthead.html.haml (184.5ms)
 Rendered sidebar/_applicants.html.haml (3.6ms)
  List Load (28.2ms)  SELECT "lists".* FROM "lists" CROSS JOIN user_identities AS user_identities_cross LEFT OUTER JOIN list_user_settings ON lists.id = list_user_settings.list_id AND user_identities_cross.id = list_user_settings.user_identity_id WHERE (("lists"."user_identity_id" = 27962 OR ("lists"."visibility" = 2 AND "lists"."organization_id" = 2969))) AND (("lists"."user_identity_id" = 27962 OR ("lists"."visibility" = 2 AND "lists"."organization_id" = 2969))) AND (user_identities_cross.id = 27962 AND (list_user_settings.show_on_toolbar OR (list_user_settings.show_on_toolbar IS NULL AND lists.show_on_toolbar))) ORDER BY "lists"."order" /*application:Webadmit,controller:searches,action:show*/
 Rendered sidebar/_lists.html.haml (34.2ms)
  SQL (83.5ms)  SELECT "exports"."id" AS t0_r0, "exports"."export_format_id" AS t0_r1, "exports"."headings" AS t0_r2, "exports"."static_list_id" AS t0_r3, "exports"."name" AS t0_r4, "exports"."user_id" AS t0_r5, "exports"."dynamic_list" AS t0_r6, "exports"."show_on_toolbar" AS t0_r7, "exports"."visibility" AS t0_r8, "exports"."column_count" AS t0_r9, "exports"."type" AS t0_r10, "exports"."report_on" AS t0_r11, "exports"."decision_id" AS t0_r12, "exports"."report_comparison_type" AS t0_r13, "exports"."order" AS t0_r14, "exports"."user_identity_id" AS t0_r15, "exports"."report_template_identifier" AS t0_r16, "exports"."program_type_id" AS t0_r17, "exports"."updated_at" AS t0_r18, "exports"."created_at" AS t0_r19, "exports"."column_grouping_type_id" AS t0_r20, "exports"."export_limit_association_id" AS t0_r21, "export_user_settings"."id" AS t1_r0, "export_user_settings"."export_id" AS t1_r1, "export_user_settings"."show_on_toolbar" AS t1_r2, "export_user_settings"."user_id" AS t1_r3, "export_user_settings"."user_identity_id" AS t1_r4, "export_user_settings"."updated_at" AS t1_r5, "export_user_settings"."created_at" AS t1_r6 FROM "exports" INNER JOIN "user_identities" ON "user_identities"."id" = "exports"."user_identity_id" INNER JOIN "user_identity_organizations" ON "user_identity_organizations"."user_identity_id" = "user_identities"."id" LEFT OUTER JOIN "export_user_settings" ON "export_user_settings"."export_id" = "exports"."id" WHERE (user_identities.id = 27962 OR ( exports.visibility = 2 AND user_identity_organizations.organization_id = 2969 )) AND (export_user_settings.id IS NULL OR export_user_settings.user_identity_id = 27962) AND (export_user_settings.show_on_toolbar OR (export_user_settings.show_on_toolbar IS NULL AND exports.show_on_toolbar)) ORDER BY name ASC /*application:Webadmit,controller:searches,action:show*/
 Rendered export/lists/_toolbar_exports.html.haml (0.9ms)
 Rendered sidebar/_reports.html.haml (204.1ms)
 Rendered sidebar/_management.html.haml (7.5ms)
 Rendered sidebar/_help.html.haml (2.7ms)
 Rendered layouts/_sidebar.html.haml (266.8ms)
 Rendered layouts/_footer.html.haml (3.8ms)
 Completed 200 OK in 113043ms (Views: 2564.7ms | ActiveRecord: 104739.1ms)