Already Applied: M 1 F: 0 PWD: 0 EC: 0
Already Accepted: M 0 F: 0 PWD: 0 EC: 0
Already Rejected: M 1 F: 0 PWD: 0 EC: 0
Computer Operation_Joyparatsc_B-01
Computer Operation_Joyparatsc_B-01
Computer Operation_Joyparatsc_B-01
| 1 x Application (97.12%) | 603ms |
| 1 x Booting (2.88%) | 17.88ms |
| Backtrace |
|
select * from `sessions` where `id` = 'YIS5HTidDpvqdPYSbTxPVWe0hO2kYeaOqSKD2ftw' limit 1| Bindings |
|
| Backtrace |
|
select `trainings`.*, (select count(*) from `training_members` where `trainings`.`id` = `training_members`.`training_id` and `status` = 'active' and exists (select * from `users` where `training_members`.`user_id` = `users`.`id` and `gender` = 'male')) as `active_males_count`, (select count(*) from `training_members` where `trainings`.`id` = `training_members`.`training_id` and `status` = 'active' and exists (select * from `users` where `training_members`.`user_id` = `users`.`id` and `gender` = 'female')) as `active_females_count`, (select count(*) from `training_members` where `trainings`.`id` = `training_members`.`training_id` and `status` = 'active' and exists (select * from `users` where `training_members`.`user_id` = `users`.`id` and `pwd` is not null)) as `active_pwd_count`, (select count(*) from `training_members` where `trainings`.`id` = `training_members`.`training_id` and `status` = 'active' and exists (select * from `users` where `training_members`.`user_id` = `users`.`id` and `ethnic_minority` = 'yes')) as `active_ethnic_count`, (select count(*) from `training_members` where `trainings`.`id` = `training_members`.`training_id` and `status` = 'rejected' and exists (select * from `users` where `training_members`.`user_id` = `users`.`id` and `gender` = 'male')) as `rejected_males_count`, (select count(*) from `training_members` where `trainings`.`id` = `training_members`.`training_id` and `status` = 'rejected' and exists (select * from `users` where `training_members`.`user_id` = `users`.`id` and `gender` = 'female')) as `rejected_females_count`, (select count(*) from `training_members` where `trainings`.`id` = `training_members`.`training_id` and `status` = 'rejected' and exists (select * from `users` where `training_members`.`user_id` = `users`.`id` and `pwd` is not null)) as `rejected_pwd_count`, (select count(*) from `training_members` where `trainings`.`id` = `training_members`.`training_id` and `status` = 'rejected' and exists (select * from `users` where `training_members`.`user_id` = `users`.`id` and `ethnic_minority` = 'yes')) as `rejected_ethnic_count`, (select count(*) from `training_members` where `trainings`.`id` = `training_members`.`training_id` and exists (select * from `users` where `training_members`.`user_id` = `users`.`id` and `gender` = 'male')) as `males_count`, (select count(*) from `training_members` where `trainings`.`id` = `training_members`.`training_id` and exists (select * from `users` where `training_members`.`user_id` = `users`.`id` and `gender` = 'female')) as `females_count`, (select count(*) from `training_members` where `trainings`.`id` = `training_members`.`training_id` and exists (select * from `users` where `training_members`.`user_id` = `users`.`id` and `pwd` is not null)) as `pwd_count`, (select count(*) from `training_members` where `trainings`.`id` = `training_members`.`training_id` and exists (select * from `users` where `training_members`.`user_id` = `users`.`id` and `ethnic_minority` = 'yes')) as `ethnic_count`, (select count(*) from `training_members` where `trainings`.`id` = `training_members`.`training_id` and `status` = 'active') as `members_count` from `trainings` where `id` = '3087' limit 1| Bindings |
|
| Backtrace |
|
select * from `institutes` where `institutes`.`id` in (264)| Backtrace |
|
select * from `users` where `users`.`id` in (315)| Backtrace |
|
select * from `training_members` where `status` = 'active' and `training_members`.`training_id` in (3087)| Bindings |
|
| Backtrace |
|
select * from `trainings` where (`start_date` <= '2025-03-15' and `end_date` >= '2025-03-15' and `id` = '3087' and `status` = 'accept') or (`end_date` < '2025-03-15' and `id` = '3087' and `status` = 'completed') limit 1| Bindings |
|
| Backtrace |
|
select * from `upazilas` where `upazilas`.`id` = 369 limit 1| Bindings |
|
| Backtrace |
|
select * from `districts` where `districts`.`id` = 47 limit 1| Bindings |
|
| Backtrace |
|
select `institute_types`.*, `training_institute_types`.`training_id` as `pivot_training_id`, `training_institute_types`.`institute_type_id` as `pivot_institute_type_id` from `institute_types` inner join `training_institute_types` on `institute_types`.`id` = `training_institute_types`.`institute_type_id` where `training_institute_types`.`training_id` = 3087| Bindings |
|
| Backtrace |
|
select * from `training_types` where `training_types`.`id` = 12 limit 1| Bindings |
|
| Backtrace |
|
select * from `training_files` where `training_files`.`training_id` = 3087 and `training_files`.`training_id` is not null| Bindings |
|
| Backtrace |
|
select exists(select * from `training_members` where `user_id` is null and `training_id` = 3087) as `exists`| Bindings |
|
| Backtrace |
|
select * from `sessions` where `id` = 'YIS5HTidDpvqdPYSbTxPVWe0hO2kYeaOqSKD2ftw' limit 1| Bindings |
|
| Backtrace |
|
insert into `sessions` (`payload`, `last_activity`, `user_id`, `ip_address`, `user_agent`, `id`) values ('YTozOntzOjY6Il90b2tlbiI7czo0MDoiS3pBeUhLSFlJYkRiOTU0MkdqUWd2Znd2dm0wREI0QVNOUHVrZXVPeSI7czo5OiJfcHJldmlvdXMiO2E6MTp7czozOiJ1cmwiO3M6NTI6Imh0dHBzOi8vYXByb21pcy5hcHAvaW5zdGl0dXRlLXRyYWluaW5ncy8zMDg3L2RldGFpbHMiO31zOjY6Il9mbGFzaCI7YToyOntzOjM6Im9sZCI7YTowOnt9czozOiJuZXciO2E6MDp7fX19', 1741986910, '', '3.149.29.120', 'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)', 'YIS5HTidDpvqdPYSbTxPVWe0hO2kYeaOqSKD2ftw')| Bindings |
|
| Backtrace |
|
200
[]
[]
0 of 0array:15 [▼ "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua" => array:1 [▶ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "connection" => array:1 [▶ 0 => "keep-alive" ] "host" => array:1 [▶ 0 => "apromis.app" ] ]
[]
0 of 0array:6 [▼ "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Fri, 14 Mar 2025 21:15:10 GMT" ] "vary" => array:1 [▶ 0 => "X-Inertia" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjFmUWY5Y2lQRmx6bzBtNWpxUFdPd2c9PSIsInZhbHVlIjoiVjlja1hpbng4SjdaWjFSeXJlcmc1YytPeVZIaHhlUGxwdlExTnZPR3V4T3FFcVd6VERsemtla1QrSGx5QmM3QUNIUzRUeFdKRVZlTWFYR0t3a3NxanZHZGJOdGswa2NaUXJQZTZ2dXA5NmR3U1dEZEh0ZEdMNFhPU2dvNWpIeHoiLCJtYWMiOiJjZmJiN2RiODI5M2EyZmUwZWYxZGM1OTdiYmFmZmMxMGU4YmY1OTNhNDBlMjgxNWY1OWUxNzhhMjhkMjExMjI1IiwidGFnIjoiIn0%3D; expires=Fri, 14 Mar 2025 23:15:10 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjFmUWY5Y2lQRmx6bzBtNWpxUFdPd2c9PSIsInZhbHVlIjoiVjlja1hpbng4SjdaWjFSeXJlcmc1YytPeVZIaHhlUGxwdlExTnZPR3V4T3FFcVd6VERsemtla1QrSGx5QmM3QUNIUzRUe ▶" 1 => "institute_report_session=eyJpdiI6Img2c3BWZ0J1OXNwU2tETGxFMEJ5OFE9PSIsInZhbHVlIjoiRzlqRTk5R0hCRTJJSFBwMEN5RFBtSlQ1bW9uUDdmQ0gvWHQ5c1NHMkpabmUrUXBiTnltRFozVXNScHRCdWR3eWV5Y2JzbnNSbCtuQVJuQ0FISGljamNLV0pKbXZWOFpWTEFDT2wybmYreFNtQzdUUE1VR2VUWEh1TVRsQzE1VnYiLCJtYWMiOiI0OGE3MzllMTRiOTA3NWQzYjJhY2RjZjI4ZWY1NDBkZDc1ZmU1OWI0NjU5YTI2YjA3NzQ4ZTI2ZGM1Zjc4OTFiIiwidGFnIjoiIn0%3D; expires=Fri, 14 Mar 2025 23:15:10 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀institute_report_session=eyJpdiI6Img2c3BWZ0J1OXNwU2tETGxFMEJ5OFE9PSIsInZhbHVlIjoiRzlqRTk5R0hCRTJJSFBwMEN5RFBtSlQ1bW9uUDdmQ0gvWHQ5c1NHMkpabmUrUXBiTnltRFozVXNScHR ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjFmUWY5Y2lQRmx6bzBtNWpxUFdPd2c9PSIsInZhbHVlIjoiVjlja1hpbng4SjdaWjFSeXJlcmc1YytPeVZIaHhlUGxwdlExTnZPR3V4T3FFcVd6VERsemtla1QrSGx5QmM3QUNIUzRUeFdKRVZlTWFYR0t3a3NxanZHZGJOdGswa2NaUXJQZTZ2dXA5NmR3U1dEZEh0ZEdMNFhPU2dvNWpIeHoiLCJtYWMiOiJjZmJiN2RiODI5M2EyZmUwZWYxZGM1OTdiYmFmZmMxMGU4YmY1OTNhNDBlMjgxNWY1OWUxNzhhMjhkMjExMjI1IiwidGFnIjoiIn0%3D; expires=Fri, 14-Mar-2025 23:15:10 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjFmUWY5Y2lQRmx6bzBtNWpxUFdPd2c9PSIsInZhbHVlIjoiVjlja1hpbng4SjdaWjFSeXJlcmc1YytPeVZIaHhlUGxwdlExTnZPR3V4T3FFcVd6VERsemtla1QrSGx5QmM3QUNIUzRUe ▶" 1 => "institute_report_session=eyJpdiI6Img2c3BWZ0J1OXNwU2tETGxFMEJ5OFE9PSIsInZhbHVlIjoiRzlqRTk5R0hCRTJJSFBwMEN5RFBtSlQ1bW9uUDdmQ0gvWHQ5c1NHMkpabmUrUXBiTnltRFozVXNScHRCdWR3eWV5Y2JzbnNSbCtuQVJuQ0FISGljamNLV0pKbXZWOFpWTEFDT2wybmYreFNtQzdUUE1VR2VUWEh1TVRsQzE1VnYiLCJtYWMiOiI0OGE3MzllMTRiOTA3NWQzYjJhY2RjZjI4ZWY1NDBkZDc1ZmU1OWI0NjU5YTI2YjA3NzQ4ZTI2ZGM1Zjc4OTFiIiwidGFnIjoiIn0%3D; expires=Fri, 14-Mar-2025 23:15:10 GMT; path=/; httponly ◀institute_report_session=eyJpdiI6Img2c3BWZ0J1OXNwU2tETGxFMEJ5OFE9PSIsInZhbHVlIjoiRzlqRTk5R0hCRTJJSFBwMEN5RFBtSlQ1bW9uUDdmQ0gvWHQ5c1NHMkpabmUrUXBiTnltRFozVXNScHR ▶" ] ]
0 of 0array:3 [▼ "_token" => "KzAyHKHYIbDb9542GjQgvfwvvm0DB4ASNPukeuOy" "_previous" => array:1 [▶ "url" => "https://apromis.app/institute-trainings/3087/details" ] "_flash" => array:2 [▶ "old" => [] "new" => [] ] ]