Skip to content

Instantly share code, notes, and snippets.

@dgtized

dgtized/gist:7456864

Created November 13, 2013 21:39
Show Gist options
  • Save dgtized/7456864 to your computer and use it in GitHub Desktop.
Save dgtized/7456864 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
Started GET "/api/participants/to_test_at_site/1?page=1&order_by=last_name&order_direction=asc&properties=name,protocols&active=true" for 127.0.0.1 at 2013-11-13 15:26:33 -0600
Processing by ParticipantsController#to_test as HTML
Parameters: {"page"=>"1", "order_by"=>"last_name", "order_direction"=>"asc", "properties"=>"name,protocols", "active"=>"true", "site_id"=>"1"}
User Load (0.7ms) SELECT "users".* FROM "users" WHERE "users"."id" = 2 LIMIT 1
AuthenticationPolicy Load (0.4ms) SELECT "authentication_policies".* FROM "authentication_policies" WHERE "authentication_policies"."id" = 1 LIMIT 1
Organization Load (0.4ms) SELECT "organizations".* FROM "organizations" WHERE "organizations"."name" = 'Intoximeters' LIMIT 1
Role Load (0.6ms) SELECT "roles".* FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = 2
Site Load (0.4ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" = 1 LIMIT 1
CACHE (0.0ms) SELECT "organizations".* FROM "organizations" WHERE "organizations"."name" = 'Intoximeters' LIMIT 1
(0.8ms) SELECT COUNT(*) FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = 2 AND ((((roles.name = 'support') AND (roles.resource_type IS NULL) AND (roles.resource_
id IS NULL)) OR ((roles.name = 'support') AND (roles.resource_type = 'Organization') AND (roles.resource_id IS NULL)) OR ((roles.name = 'support') AND (roles.resource_type = 'Organization') AND (roles.resource_id = 2))))
CACHE (0.0ms) SELECT "roles".* FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = 2
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" = 1 LIMIT 1
CACHE (0.0ms) SELECT "organizations".* FROM "organizations" WHERE "organizations"."name" = 'Intoximeters' LIMIT 1
CACHE (0.0ms) SELECT COUNT(*) FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = 2 AND ((((roles.name = 'support') AND (roles.resource_type IS NULL) AND (roles.reso
urce_id IS NULL)) OR ((roles.name = 'support') AND (roles.resource_type = 'Organization') AND (roles.resource_id IS NULL)) OR ((roles.name = 'support') AND (roles.resource_type = 'Organization') AND (roles.resource_id = 2))))
Role Load (0.5ms) SELECT "roles".* FROM "roles" INNER JOIN "users_roles" ON "roles"."id" = "users_roles"."role_id" WHERE "users_roles"."user_id" = 2 AND "roles"."resource_type" = 'Site'
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" = 1 LIMIT 1
Site Load (0.6ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" = $1 LIMIT 1 [["id", "1"]]
Participant Load (5.5ms) SELECT DISTINCT "participants".* FROM "participants" INNER JOIN "programs" ON "programs"."participant_id" = "participants"."id" LEFT JOIN program_protocols pp ON pp.program_id = programs.id LEFT JOIN
allowed_sites allow ON allow.program_protocol_id = pp.id WHERE "programs"."is_locked" = 'f' AND (programs.primary_site_id IN (1) OR allow.site_id IN (1))
Participant Load (4.2ms) SELECT DISTINCT "participants".* FROM "participants" INNER JOIN "programs" ON "programs"."participant_id" = "participants"."id" LEFT JOIN program_protocols pp ON pp.program_id = programs.id LEFT JOIN
allowed_sites allow ON allow.program_protocol_id = pp.id WHERE "programs"."is_locked" = 'f' AND (programs.primary_site_id IN (1) OR allow.site_id IN (1)) LIMIT 1000 OFFSET 0
Program Load (1.8ms) SELECT "programs".* FROM "programs" WHERE "programs"."participant_id" IN (164, 724, 722, 377, 419, 942, 2, 721, 50, 924, 637, 918, 295, 624, 285, 629, 653, 482, 52, 680, 138, 129, 140, 360, 183, 63, 411,
750, 861, 701, 283, 543)
ProgramProtocol Load (1.9ms) SELECT "program_protocols".* FROM "program_protocols" WHERE "program_protocols"."program_id" IN (164, 724, 722, 377, 419, 942, 2, 721, 50, 924, 637, 918, 295, 624, 285, 629, 653, 482, 52, 680, 138
, 129, 140, 360, 183, 63, 411, 750, 861, 701, 283, 543)
SQL (0.7ms) SELECT "sites".*, "t0"."program_protocol_id" AS ar_association_key_name FROM "sites" INNER JOIN "allowed_sites" "t0" ON "sites"."id" = "t0"."site_id" WHERE "t0"."program_protocol_id" IN (271, 1172, 1173, 1170, 617
, 687, 688, 1528, 1529, 3, 4, 1169, 88, 1499, 1032, 1490, 484, 485, 1012, 466, 467, 1019, 1020, 1059, 786, 92, 1102, 227, 217, 229, 591, 300, 111, 673, 1219, 1220, 1400, 1137, 1138, 463, 882)
Protocol Load (0.5ms) SELECT "protocols".* FROM "protocols" WHERE "protocols"."id" IN (4, 1, 2, 3)
Program Load (0.7ms) SELECT "programs".* FROM "programs" WHERE "programs"."id" IN (164, 722, 377, 419, 721, 285, 653, 680)
Program Load (0.8ms) SELECT "programs".* FROM "programs" WHERE "programs"."id" IN (724, 942, 2, 924, 295, 624, 629, 482, 138, 360, 63, 411, 750, 861, 701, 283)
Program Load (0.6ms) SELECT "programs".* FROM "programs" WHERE "programs"."id" IN (724, 419, 295, 285, 629, 129, 140, 183, 543)
Program Load (0.5ms) SELECT "programs".* FROM "programs" WHERE "programs"."id" IN (942, 2, 50, 637, 918, 52, 750, 701)
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" = 1 LIMIT 1
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" = 1 LIMIT 1
SiteSession Load (0.4ms) SELECT "site_sessions".* FROM "site_sessions" WHERE "site_sessions"."site_id" = 1
Site Load (0.4ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" IN (1)
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" = 1 LIMIT 1
CACHE (0.0ms) SELECT "site_sessions".* FROM "site_sessions" WHERE "site_sessions"."site_id" = 1
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" IN (1)
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" = 1 LIMIT 1
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" = 1 LIMIT 1
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" = 1 LIMIT 1
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" = 1 LIMIT 1
CACHE (0.0ms) SELECT "site_sessions".* FROM "site_sessions" WHERE "site_sessions"."site_id" = 1
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" IN (1)
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" = 1 LIMIT 1
CACHE (0.0ms) SELECT "site_sessions".* FROM "site_sessions" WHERE "site_sessions"."site_id" = 1
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" IN (1)
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" = 1 LIMIT 1
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" = 1 LIMIT 1
CACHE (0.0ms) SELECT "site_sessions".* FROM "site_sessions" WHERE "site_sessions"."site_id" = 1
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" IN (1)
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" = 1 LIMIT 1
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" = 1 LIMIT 1
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" = 1 LIMIT 1
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" = 1 LIMIT 1
CACHE (0.0ms) SELECT "site_sessions".* FROM "site_sessions" WHERE "site_sessions"."site_id" = 1
<snip>
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" = 1 LIMIT 1
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" = 1 LIMIT 1
CACHE (0.0ms) SELECT "site_sessions".* FROM "site_sessions" WHERE "site_sessions"."site_id" = 1
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" IN (1)
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" = 1 LIMIT 1
CACHE (0.0ms) SELECT "site_sessions".* FROM "site_sessions" WHERE "site_sessions"."site_id" = 1
CACHE (0.0ms) SELECT "sites".* FROM "sites" WHERE "sites"."id" IN (1)
Rendered shared/index.rabl within layouts/application (511.7ms)
Completed 200 OK in 728ms (Views: 501.0ms | ActiveRecord: 38.8ms)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment