PainTracker™ is an easy-to-use, web-based service that helps clinicians assess and track key patient-reported outcomes of post-injury, post-operative, acute, subacute, and chronic pain. Please sign in below.
Learn more about PainTracker AIM-CP.
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | SELECT `Session`.`id`, `Session`.`user_id`, `Session`.`data`, `Session`.`expires` FROM `cpro`.`cake_sessions` AS `Session` WHERE `Session`.`id` = 'nbmru5t83tpavakv1nd3503uq3' LIMIT 1 | 1 | 1 | 1 | |
| 2 | SELECT `UserAclLeaf`.`id`, `UserAclLeaf`.`user_id`, `UserAclLeaf`.`acl_alias`, `User`.`id`, `User`.`username`, `User`.`password`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, `User`.`change_pw_flag`, `User`.`clinic_id`, `User`.`language`, `User`.`last4ssn`, `User`.`registered`, `User`.`study_group`, `User`.`external_id`, `User`.`email_confirmed`, `User`.`phone1`, `User`.`birthdate`, `User`.`agreed_to_terms`, `User`.`phone1_confirmed`, `User`.`alt_contact_email`, `User`.`comm_pref`, (IFNULL(`User`.`email`, `User`.`phone1`)) AS `User__email_or_phone` FROM `cpro`.`user_acl_leafs` AS `UserAclLeaf` LEFT JOIN `cpro`.`users` AS `User` ON (`UserAclLeaf`.`user_id` = `User`.`id`) WHERE `UserAclLeaf`.`user_id` IS NULL | 0 | 0 | 1 | |
| 3 | BEGIN | 0 | 0 | 0 | |
| 4 | INSERT INTO `cpro`.`logs` (`user_id`, `controller`, `action`, `params`, `time`, `user_agent`, `ip_address`) VALUES (0, 'users', 'login', '', '2025-12-14 21-53-29', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', '(none)') | 1 | 1 | 2 | |
| 5 | COMMIT | 0 | 0 | 0 | |
| 6 | SELECT `Clinic`.`id`, `Clinic`.`site_id`, `Clinic`.`name`, `Clinic`.`friendly_name`, `Clinic`.`support_name`, `Clinic`.`state`, `Clinic`.`support_email`, `Clinic`.`support_phone`, `Clinic`.`patient_status_email`, `Clinic`.`one_usual_care_session`, `Clinic`.`irb_contact`, `Site`.`id`, `Site`.`name`, `Site`.`friendly_name`, `Site`.`timezone`, `Site`.`research_staff_email_alias`, `Site`.`research_staff_signature`, `Site`.`new_aim_consent_mod_date` FROM `cpro`.`clinics` AS `Clinic` LEFT JOIN `cpro`.`sites` AS `Site` ON (`Clinic`.`site_id` = `Site`.`id`) WHERE 1 = 1 | 2 | 2 | 1 | |
| 7 | SELECT `User`.`id`, `User`.`username`, `User`.`password`, `User`.`first_name`, `User`.`last_name`, `User`.`email`, `User`.`change_pw_flag`, `User`.`clinic_id`, `User`.`language`, `User`.`last4ssn`, `User`.`registered`, `User`.`study_group`, `User`.`external_id`, `User`.`email_confirmed`, `User`.`phone1`, `User`.`birthdate`, `User`.`agreed_to_terms`, `User`.`phone1_confirmed`, `User`.`alt_contact_email`, `User`.`comm_pref`, (IFNULL(`User`.`email`, `User`.`phone1`)) AS `User__email_or_phone` FROM `cpro`.`users` AS `User` WHERE `User`.`clinic_id` IN (1, 2) | 45 | 45 | 2 |