1 |
0.64 ms |
SELECT t0.id AS id_1, t0.date AS date_2, t0.public_id AS public_id_3, t0.program_id AS program_id_4, t0.case_profile_id AS case_profile_id_5 FROM case_program t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.date AS date_2, t0.public_id AS public_id_3, t0.program_id AS program_id_4, t0.case_profile_id AS case_profile_id_5 FROM case_program t0 WHERE t0.id = '25';
|
2 |
0.77 ms |
SELECT t0.id AS id_1, t0.description AS description_2, t0.duration_unit AS duration_unit_3, t0.goals AS goals_4, t0.notes AS notes_5, t0.classification AS classification_6, t0.is_disabled AS is_disabled_7 FROM progs_bank t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.description AS description_2, t0.duration_unit AS duration_unit_3, t0.goals AS goals_4, t0.notes AS notes_5, t0.classification AS classification_6, t0.is_disabled AS is_disabled_7 FROM progs_bank t0 WHERE t0.id = 25;
|
3 |
0.71 ms |
SELECT t0.id AS id_1, t0.title AS title_2, t0.prog_bank_id AS prog_bank_id_3 FROM task_group t0 WHERE t0.prog_bank_id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.prog_bank_id AS prog_bank_id_3 FROM task_group t0 WHERE t0.prog_bank_id = 25;
|
4 |
0.62 ms |
SELECT t0.id AS id_1, t0.hours_count AS hours_count_2, t0.created_at AS created_at_3, t0.notes AS notes_4, t0.case_program_id AS case_program_id_5, t0.service_provider_id AS service_provider_id_6, t0.task_group_id AS task_group_id_7, t0.user_id AS user_id_8 FROM pt_session t0 WHERE t0.case_program_id = ? ORDER BY t0.created_at DESC
SELECT t0.id AS id_1, t0.hours_count AS hours_count_2, t0.created_at AS created_at_3, t0.notes AS notes_4, t0.case_program_id AS case_program_id_5, t0.service_provider_id AS service_provider_id_6, t0.task_group_id AS task_group_id_7, t0.user_id AS user_id_8 FROM pt_session t0 WHERE t0.case_program_id = 25 ORDER BY t0.created_at DESC;
|
5 |
0.52 ms |
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.job AS job_2, s0_.main_salary AS main_salary_3, s0_.salary_per_hour AS salary_per_hour_4, s0_.address AS address_5, s0_.phone_number AS phone_number_6, s0_.session_percentage AS session_percentage_7, s0_.is_active AS is_active_8, s0_.main_service_id AS main_service_id_9 FROM service_provider s0_
SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.job AS job_2, s0_.main_salary AS main_salary_3, s0_.salary_per_hour AS salary_per_hour_4, s0_.address AS address_5, s0_.phone_number AS phone_number_6, s0_.session_percentage AS session_percentage_7, s0_.is_active AS is_active_8, s0_.main_service_id AS main_service_id_9 FROM service_provider s0_;
|
6 |
0.54 ms |
SELECT t0.id AS id_1, t0.explanation AS explanation_2, t0.notes AS notes_3, t0.duration AS duration_4, t0.attachment_file_name AS attachment_file_name_5, t0.task_group_id AS task_group_id_6 FROM program_task t0 WHERE t0.task_group_id = ?
SELECT t0.id AS id_1, t0.explanation AS explanation_2, t0.notes AS notes_3, t0.duration AS duration_4, t0.attachment_file_name AS attachment_file_name_5, t0.task_group_id AS task_group_id_6 FROM program_task t0 WHERE t0.task_group_id = 45;
|
7 |
0.64 ms |
SELECT t0.id AS id_1, t0.explanation AS explanation_2, t0.notes AS notes_3, t0.duration AS duration_4, t0.attachment_file_name AS attachment_file_name_5, t0.task_group_id AS task_group_id_6 FROM program_task t0 WHERE t0.task_group_id = ?
SELECT t0.id AS id_1, t0.explanation AS explanation_2, t0.notes AS notes_3, t0.duration AS duration_4, t0.attachment_file_name AS attachment_file_name_5, t0.task_group_id AS task_group_id_6 FROM program_task t0 WHERE t0.task_group_id = 46;
|