/* Query 1 - 2025-08-03 02:20:26 [265.22ms]  */
select * from `users` where `uli_id` in ('701440') and `parent_id` is null and `users`.`deleted_at` is null;
/*==================================================*/
/* Query 2 - 2025-08-03 02:20:26 [8.1ms]  */
select * from `user_progress` where `user_id` in ('23363');
/*==================================================*/
/* Query 1 - 2025-08-03 02:20:28 [24.03ms]  */
select `id` from `users` where `uli_id` = '701440' and `parent_id` is null and `users`.`deleted_at` is null limit 1;
/*==================================================*/
/* Query 2 - 2025-08-03 02:20:28 [5.49ms]  */
select `users`.`id` as `id`, `users`.`name`, `users`.`email`, `users`.`grp_id`, `users`.`uli_id`, `users`.`lti_id`, `users`.`report_link`, `users`.`hash`, `users`.`is_demo_user`, `groups`.`sli_id`, `groups`.`timer_id`, `groups`.`lang`, `groups`.`no_of_rounds`, `groups`.`has_timer`, `groups`.`commonDB_group_id`, `groups`.`lti_group_id`, `groups`.`show_feedback`, `groups`.`reportType`, `groups`.`vac_enabled` from `users` inner join `groups` on `groups`.`id` = `users`.`grp_id` where `users`.`id` = '23363' and `users`.`deleted_at` is null limit 1;
/*==================================================*/
/* Query 3 - 2025-08-03 02:20:28 [2.17ms]  */
select * from `users` where `users`.`parent_id` = '23363' and `users`.`deleted_at` is null limit 1;
/*==================================================*/
/* Query 4 - 2025-08-03 02:20:28 [1.51ms]  */
select `name`, `value` from `user_progress` where `user_id` = '23363';
/*==================================================*/
/* Query 5 - 2025-08-03 02:20:28 [8.03ms]  */
select `name`, `value`, `round_no` from `user_round_progress` where `user_id` = '23363';
/*==================================================*/
/* Query 6 - 2025-08-03 02:20:28 [1.51ms]  */
select * from `stl_instances` where `stl_instances`.`id` = '1' limit 1;
/*==================================================*/
/* Query 7 - 2025-08-03 02:20:28 [1.42ms]  */
select * from `stl_instances` limit 1;
/*==================================================*/
/* Query 8 - 2025-08-03 02:20:28 [5.32ms]  */
select `total_time`, `time_remaining` from `user_timer_details` where `user_id` = '23363' limit 1;
/*==================================================*/
/* Query 1 - 2025-08-03 14:25:50 [27.39ms]  */
select * from `users` where `uli_id` in ('701682') and `parent_id` is null and `users`.`deleted_at` is null;
/*==================================================*/
/* Query 2 - 2025-08-03 14:25:50 [1.76ms]  */
select * from `user_progress` where 0 = 1;
/*==================================================*/
/* Query 1 - 2025-08-03 14:26:01 [8.64ms]  */
INSERT INTO user_progress (user_id, name, value) VALUES  (23384, 'isIntroSeen', 1) , (23384, 'started', 1) , (23384, 'startedTime', 1754231152)   ON DUPLICATE KEY UPDATE `value` = VALUES(`value`);
/*==================================================*/
/* Query 2 - 2025-08-03 14:26:01 [1.31ms]  */
select `name`, `value` from `user_progress` where `user_id` = '23384';
/*==================================================*/
/* Query 1 - 2025-08-03 14:26:12 [7.52ms]  */
INSERT INTO user_coachee_round_progress (user_id, stl_coachee_id, round_no, name, value) VALUES  (23384, 1, 1, 'isCoachingStarted', 1) , (23384, 1, 1, 'stlCoacheeId', 1) , (23384, 1, 1, 'roundNo', 1)   ON DUPLICATE KEY UPDATE `value` = VALUES(`value`);
/*==================================================*/
/* Query 2 - 2025-08-03 14:26:12 [1.35ms]  */
select `name`, `value`, `round_no`, `stl_coachee_id` from `user_coachee_round_progress` where `user_id` = '23384';
/*==================================================*/
/* Query 1 - 2025-08-03 14:26:48 [1.7ms]  */
select * from `stl_models` where `stl_id` = '1' limit 1;
/*==================================================*/
/* Query 2 - 2025-08-03 14:26:48 [1.68ms]  */
select * from `model_details` where `model_id` = '1';
/*==================================================*/
/* Query 3 - 2025-08-03 14:26:48 [1.59ms]  */
select * from `statement_option_responses` where `option_id` = '9';
/*==================================================*/
/* Query 4 - 2025-08-03 14:26:48 [1.49ms]  */
select * from `statement_option_metrics` where `option_id` = '9';
/*==================================================*/
/* Query 5 - 2025-08-03 14:26:48 [1.65ms]  */
select * from `user_metrics` where `user_id` = '23384';
/*==================================================*/
/* Query 6 - 2025-08-03 14:26:48 [1.57ms]  */
select * from `user_coachee_metrics` where `user_id` = '23384' and `stl_coachee_id` = '1';
/*==================================================*/
/* Query 7 - 2025-08-03 14:26:48 [7.72ms]  */
insert into `user_conversations` (`user_id`, `stl_conversation_id`) values ('23384', '105');
/*==================================================*/
/* Query 8 - 2025-08-03 14:26:48 [6.63ms]  */
insert into `user_selected_statement_options` (`response_id`, `stl_statement_id`, `stl_conversation_id`, `option_id`, `user_id`) values ('3', '5', '105', '9', '23384');
/*==================================================*/
/* Query 9 - 2025-08-03 14:26:48 [1.57ms]  */
select * from `user_round_progress` where `round_no` = '1' and `user_id` = '23384' and `name` = 'completedConversations' limit 1;
/*==================================================*/
/* Query 10 - 2025-08-03 14:26:48 [6.43ms]  */
update `user_round_progress` set `value` = '4', `updated_at` = '2025-08-03 14:26:48' where `id` = '585269';
/*==================================================*/
/* Query 11 - 2025-08-03 14:26:48 [1.55ms]  */
select * from `user_coachee_round_progress` where `stl_coachee_id` = '1' and `round_no` = '1' and `user_id` = '23384' and `name` = 'completedConversations' limit 1;
/*==================================================*/
/* Query 12 - 2025-08-03 14:26:48 [6.34ms]  */
update `user_coachee_round_progress` set `value` = '4', `updated_at` = '2025-08-03 14:26:48' where `id` = '853553';
/*==================================================*/
/* Query 13 - 2025-08-03 14:26:48 [1.6ms]  */
select * from `user_coachee_round_phase_details` where `stl_coachee_id` = '1' and `stl_round_phase_id` = '2' and `user_id` = '23384' limit 1;
/*==================================================*/
/* Query 14 - 2025-08-03 14:26:48 [6.07ms]  */
update `user_coachee_round_phase_details` set `completed_conversations` = '2', `updated_at` = '2025-08-03 14:26:48' where `id` = '631316';
/*==================================================*/
/* Query 15 - 2025-08-03 14:26:48 [1.57ms]  */
select `name`, `value`, `round_no`, `stl_coachee_id` from `user_coachee_round_progress` where `user_id` = '23384';
/*==================================================*/
/* Query 16 - 2025-08-03 14:26:48 [1.45ms]  */
select `name`, `value`, `round_no` from `user_round_progress` where `user_id` = '23384';
/*==================================================*/
/* Query 17 - 2025-08-03 14:26:48 [1.52ms]  */
select * from `events`;
/*==================================================*/
/* Query 18 - 2025-08-03 14:26:48 [1.36ms]  */
select * from `event_conditions`;
/*==================================================*/
/* Query 19 - 2025-08-03 14:26:48 [1.33ms]  */
select * from `event_types`;
/*==================================================*/
/* Query 20 - 2025-08-03 14:26:48 [1.31ms]  */
select * from `event_sources`;
/*==================================================*/
/* Query 21 - 2025-08-03 14:26:48 [1.39ms]  */
select * from `event_options`;
/*==================================================*/
/* Query 22 - 2025-08-03 14:26:48 [1.31ms]  */
select * from `event_option_response`;
/*==================================================*/
/* Query 23 - 2025-08-03 14:26:48 [1.39ms]  */
select * from `stl_events` where `stl_id` = '1' and `round_no` = '1';
/*==================================================*/
/* Query 24 - 2025-08-03 14:26:48 [1.56ms]  */
select * from `user_conversation_metrics` where `user_id` = '23384' and `round_no` = '1';
/*==================================================*/
/* Query 25 - 2025-08-03 14:26:48 [1.66ms]  */
select * from `user_events` where `user_id` = '23384' and `round_no` = '1';
/*==================================================*/
/* Query 26 - 2025-08-03 14:26:48 [1.38ms]  */
select `name`, `value` from `user_round_progress` where `user_id` = '23384' and `round_no` = '1';
/*==================================================*/
/* Query 1 - 2025-08-03 14:27:05 [1.5ms]  */
select * from `user_timer_details` where `user_id` = '23384' limit 1;
/*==================================================*/
/* Query 2 - 2025-08-03 14:27:05 [6.43ms]  */
update `user_timer_details` set `time_remaining` = '540', `updated_at` = '2025-08-03 14:27:05' where `id` = '22363';
/*==================================================*/
/* Query 1 - 2025-08-03 14:27:49 [1.4ms]  */
select * from `stl_models` where `stl_id` = '1' limit 1;
/*==================================================*/
/* Query 2 - 2025-08-03 14:27:49 [1.22ms]  */
select * from `model_details` where `model_id` = '1';
/*==================================================*/
/* Query 3 - 2025-08-03 14:27:49 [1.27ms]  */
select * from `statement_option_responses` where `option_id` = '15';
/*==================================================*/
/* Query 4 - 2025-08-03 14:27:49 [1.16ms]  */
select * from `statement_option_metrics` where `option_id` = '15';
/*==================================================*/
/* Query 5 - 2025-08-03 14:27:49 [1.31ms]  */
select * from `user_metrics` where `user_id` = '23384';
/*==================================================*/
/* Query 6 - 2025-08-03 14:27:49 [1.28ms]  */
select * from `user_coachee_metrics` where `user_id` = '23384' and `stl_coachee_id` = '1';
/*==================================================*/
/* Query 7 - 2025-08-03 14:27:49 [7.25ms]  */
insert into `user_conversations` (`user_id`, `stl_conversation_id`) values ('23384', '111');
/*==================================================*/
/* Query 8 - 2025-08-03 14:27:49 [6.85ms]  */
insert into `user_selected_statement_options` (`response_id`, `stl_statement_id`, `stl_conversation_id`, `option_id`, `user_id`) values ('9', '11', '111', '15', '23384');
/*==================================================*/
/* Query 9 - 2025-08-03 14:27:49 [1.4ms]  */
select * from `user_round_progress` where `round_no` = '1' and `user_id` = '23384' and `name` = 'completedConversations' limit 1;
/*==================================================*/
/* Query 10 - 2025-08-03 14:27:49 [8.14ms]  */
update `user_round_progress` set `value` = '9', `updated_at` = '2025-08-03 14:27:49' where `id` = '585269';
/*==================================================*/
/* Query 11 - 2025-08-03 14:27:49 [1.45ms]  */
select * from `user_coachee_round_progress` where `stl_coachee_id` = '1' and `round_no` = '1' and `user_id` = '23384' and `name` = 'completedConversations' limit 1;
/*==================================================*/
/* Query 12 - 2025-08-03 14:27:49 [7.4ms]  */
update `user_coachee_round_progress` set `value` = '9', `updated_at` = '2025-08-03 14:27:49' where `id` = '853553';
/*==================================================*/
/* Query 13 - 2025-08-03 14:27:49 [1.46ms]  */
select * from `user_coachee_round_phase_details` where `stl_coachee_id` = '1' and `stl_round_phase_id` = '2' and `user_id` = '23384' limit 1;
/*==================================================*/
/* Query 14 - 2025-08-03 14:27:49 [7.63ms]  */
update `user_coachee_round_phase_details` set `completed_conversations` = '7', `updated_at` = '2025-08-03 14:27:49' where `id` = '631316';
/*==================================================*/
/* Query 15 - 2025-08-03 14:27:49 [1.36ms]  */
select `name`, `value`, `round_no`, `stl_coachee_id` from `user_coachee_round_progress` where `user_id` = '23384';
/*==================================================*/
/* Query 16 - 2025-08-03 14:27:49 [1.53ms]  */
select `name`, `value`, `round_no` from `user_round_progress` where `user_id` = '23384';
/*==================================================*/
/* Query 17 - 2025-08-03 14:27:49 [1.35ms]  */
select * from `events`;
/*==================================================*/
/* Query 18 - 2025-08-03 14:27:49 [1.28ms]  */
select * from `event_conditions`;
/*==================================================*/
/* Query 19 - 2025-08-03 14:27:49 [1.19ms]  */
select * from `event_types`;
/*==================================================*/
/* Query 20 - 2025-08-03 14:27:49 [1.22ms]  */
select * from `event_sources`;
/*==================================================*/
/* Query 21 - 2025-08-03 14:27:49 [1.28ms]  */
select * from `event_options`;
/*==================================================*/
/* Query 22 - 2025-08-03 14:27:49 [1.29ms]  */
select * from `event_option_response`;
/*==================================================*/
/* Query 23 - 2025-08-03 14:27:49 [1.37ms]  */
select * from `stl_events` where `stl_id` = '1' and `round_no` = '1';
/*==================================================*/
/* Query 24 - 2025-08-03 14:27:49 [1.26ms]  */
select * from `user_conversation_metrics` where `user_id` = '23384' and `round_no` = '1';
/*==================================================*/
/* Query 25 - 2025-08-03 14:27:49 [1.25ms]  */
select * from `user_events` where `user_id` = '23384' and `round_no` = '1';
/*==================================================*/
/* Query 26 - 2025-08-03 14:27:49 [1.27ms]  */
select `name`, `value` from `user_round_progress` where `user_id` = '23384' and `round_no` = '1';
/*==================================================*/
/* Query 1 - 2025-08-03 14:28:20 [1.37ms]  */
select * from `user_timer_details` where `user_id` = '23384' limit 1;
/*==================================================*/
/* Query 2 - 2025-08-03 14:28:20 [6.38ms]  */
update `user_timer_details` set `time_remaining` = '465', `updated_at` = '2025-08-03 14:28:20' where `id` = '22363';
/*==================================================*/
/* Query 1 - 2025-08-03 14:29:05 [1.13ms]  */
select * from `user_timer_details` where `user_id` = '23384' limit 1;
/*==================================================*/
/* Query 2 - 2025-08-03 14:29:05 [6.88ms]  */
update `user_timer_details` set `time_remaining` = '420', `updated_at` = '2025-08-03 14:29:05' where `id` = '22363';
/*==================================================*/
/* Query 1 - 2025-08-03 14:30:20 [1.55ms]  */
select * from `user_timer_details` where `user_id` = '23384' limit 1;
/*==================================================*/
/* Query 2 - 2025-08-03 14:30:20 [6.74ms]  */
update `user_timer_details` set `time_remaining` = '345', `updated_at` = '2025-08-03 14:30:20' where `id` = '22363';
/*==================================================*/
/* Query 1 - 2025-08-03 14:31:20 [1.04ms]  */
select * from `user_timer_details` where `user_id` = '23384' limit 1;
/*==================================================*/
/* Query 2 - 2025-08-03 14:31:20 [6.54ms]  */
update `user_timer_details` set `time_remaining` = '285', `updated_at` = '2025-08-03 14:31:20' where `id` = '22363';
/*==================================================*/
