Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
select * from `currencies`
140μs/vendor/torann/currency/src/Drivers/Database.php:62seedoutm_seedout_stagingMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `applications` where `applications`.`current_process_flow_id` = '9' and `applications`.`web_status` = 'Live' and `applications`.`status` = 'Approved' and `applications`.`deleted_at` is null and `applicable_type` = 'borrower'
850μs/Modules/Application/Repositories/web/facade/Filters.php:186seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `categories`.`id`, `categories`.`category`, count(borrower.id) as borrower from `applications` inner join `borrower` on `borrower`.`id` = `applications`.`applicable_id` inner join `categories` on `borrower`.`category_id` = `categories`.`id` where `applications`.`current_process_flow_id` = '9' and `applications`.`web_status` = 'Live' and `applications`.`status` = 'Approved' and `applications`.`deleted_at` is null and `applicable_type` = 'borrower' group by `categories`.`id`
1.55ms/Modules/Application/Repositories/web/facade/Filters.php:192seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `borrower`.`id`, `borrower_gender`, count(borrower.id) as borrower from `applications` inner join `borrower` on `borrower`.`id` = `applications`.`applicable_id` inner join `categories` on `borrower`.`category_id` = `categories`.`id` where `applications`.`current_process_flow_id` = '9' and `applications`.`web_status` = 'Live' and `applications`.`status` = 'Approved' and `applications`.`deleted_at` is null and `applicable_type` = 'borrower' group by `categories`.`id`, `borrower`.`borrower_gender`
1.42ms/Modules/Application/Repositories/web/facade/Filters.php:198seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `applications` inner join `borrower` on `borrower`.`id` = `applications`.`applicable_id` inner join `categories` on `borrower`.`category_id` = `categories`.`id` where `applications`.`current_process_flow_id` = '9' and `applications`.`web_status` = 'Live' and `applications`.`status` = 'Approved' and `applications`.`deleted_at` is null and `applicable_type` = 'borrower' and `applications`.`expiry_date` between '2025-04-20 03:54:43' and '2025-05-20 03:54:43' group by `categories`.`id`, `borrower`.`borrower_gender`
830μs/Modules/Application/Repositories/web/facade/Filters.php:201seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `applications` inner join `borrower` on `borrower`.`id` = `applications`.`applicable_id` inner join `categories` on `borrower`.`category_id` = `categories`.`id` where `applications`.`current_process_flow_id` = '9' and `applications`.`web_status` = 'Live' and `applications`.`status` = 'Approved' and `applications`.`deleted_at` is null and `applicable_type` = 'borrower' and `applications`.`expiry_date` between '2025-04-20 03:54:43' and '2025-05-20 03:54:43' group by `categories`.`id`, `borrower`.`borrower_gender` order by `applications`.`created_at` desc
930μs/Modules/Application/Repositories/web/facade/Filters.php:205seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `cities`.`id`, `cities`.`city_name`, count(applications.id) as apps_count from `applications` left join `branches` on `branches`.`id` = `applications`.`branch_id` left join `students` on `applications`.`applicable_id` = `students`.`id` and `applications`.`applicable_type` = 'student' inner join `cities` on `cities`.`id` = `branches`.`city_id` or `cities`.`id` = `students`.`current_address_city_id` where `applications`.`current_process_flow_id` = '9' and `applications`.`web_status` = 'Live' and `applications`.`status` = 'Approved' and `applications`.`deleted_at` is null group by `cities`.`id`
1.63s/Modules/Application/Repositories/web/facade/Filters.php:254seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `applications` where `applications`.`current_process_flow_id` = '9' and `applications`.`web_status` = 'Live' and `applications`.`status` = 'Approved' and `applications`.`deleted_at` is null and `applications`.`applicable_type` = 'student'
1.04ms/Modules/Application/Repositories/web/facade/Filters.php:225seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `students`.`gender`, count(applications.id) as students from `applications` inner join `students` on `applications`.`applicable_id` = `students`.`id` and `applications`.`applicable_type` = 'student' where `applications`.`current_process_flow_id` = '9' and `applications`.`web_status` = 'Live' and `applications`.`status` = 'Approved' and `applications`.`deleted_at` is null and `applications`.`applicable_type` = 'student' group by `students`.`gender`
930μs/Modules/Application/Repositories/web/facade/Filters.php:232seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `donation_account` where `donation_account`.`id` = '67' limit 1
230μs/Modules/User/Http/Controllers/Web/UserController.php:399seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `donor` where `donor`.`id` in ('67') and `donor`.`deleted_at` is null
330μs/Modules/User/Http/Controllers/Web/UserController.php:399seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `views` where `viewable_id` = '67' and `viewable_type` = 'donor'
4.16ms/app/helpers/statistics_helper.php:196seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
update `views` set `views` = `views` + 1, `updated_at` = '2025-04-20 03:54:45' where `viewable_id` = '67' and `viewable_type` = 'donor'
21.71ms/app/helpers/statistics_helper.php:197seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `donation_account_transactions` where `transaction_type_id` in ('2', '3', '9') and `from_account_id` = '67' and `to_account_id` not in ('1', '2', '3', '1061', '7000', '5760', '14258', '15089') group by `to_account_id`
540μs/Modules/User/Http/Controllers/Web/UserController.php:409seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select *,to_account_id as borrower_account_id,sum(CASE transaction_type_id WHEN 2 THEN amount ELSE 0 END) as donated from `donation_account_transactions` where `transaction_type_id` in ('2', '3', '9') and `from_account_id` = '67' and `to_account_id` not in ('1', '2', '3', '1061', '7000', '5760', '14258', '15089') group by `to_account_id` limit 30 offset 0
1.05ms/Modules/User/Http/Controllers/Web/UserController.php:409seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select sum(amount) as donated, to_account_id from `donation_account_transactions` where `transaction_type_id` in ('2', '3', '9') and `to_account_id` not in ('1', '2', '3', '1061', '7000', '5760', '14258', '15089') and `from_account_id` = '67' group by `to_account_id`
450μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `donation_account` where `donation_account`.`id` in ('233', '657', '1101', '1629', '1687', '3194', '3885', '4762', '4861', '5197', '5578', '8061', '8197', '9450', '10716', '13636', '14298', '14396', '17718')
530μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `applications` where `applications`.`id` in ('63', '130', '978', '1354', '1390', '1554', '1751', '2291', '2333', '2546', '2797', '3410', '3488', '3748', '1321', '4654', '4864', '4919', '5480') and `applications`.`deleted_at` is null
710μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `borrower` where `borrower`.`id` in ('58', '129', '1035', '4135', '1409', '1445', '1609', '1805', '2345', '2387', '2600', '2852', '3465', '3542', '3804', '4709', '4921', '4976', '5538') and `borrower`.`deleted_at` is null
1.44ms/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '16' and `branches`.`deleted_at` is null limit 1
250μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '10' and `branches`.`deleted_at` is null limit 1
180μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '13' and `branches`.`deleted_at` is null limit 1
180μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '21' and `branches`.`deleted_at` is null limit 1
180μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '11' and `branches`.`deleted_at` is null limit 1
150μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '16' and `branches`.`deleted_at` is null limit 1
130μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '9' and `branches`.`deleted_at` is null limit 1
180μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '24' and `branches`.`deleted_at` is null limit 1
180μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '16' and `branches`.`deleted_at` is null limit 1
210μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '9' and `branches`.`deleted_at` is null limit 1
200μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '9' and `branches`.`deleted_at` is null limit 1
160μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '22' and `branches`.`deleted_at` is null limit 1
130μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '20' and `branches`.`deleted_at` is null limit 1
210μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '22' and `branches`.`deleted_at` is null limit 1
220μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '21' and `branches`.`deleted_at` is null limit 1
210μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '21' and `branches`.`deleted_at` is null limit 1
130μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '21' and `branches`.`deleted_at` is null limit 1
150μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '20' and `branches`.`deleted_at` is null limit 1
220μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '18' and `branches`.`deleted_at` is null limit 1
250μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `cities` where `cities`.`id` = '2189673' limit 1
160μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:59seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `cities` where `cities`.`id` = '2207962' limit 1
150μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:59seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `cities` where `cities`.`id` = '3150684' limit 1
150μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:59seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `cities` where `cities`.`id` = '2177387' limit 1
160μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:59seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `amount`, `created_at` from `donation_account_transactions` where `from_account_id` = '67' and `transaction_type_id` in ('2', '3', '9') order by `created_at` asc
280μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:73seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `amount`, `created_at` from `donation_account_transactions` where `to_account_id` = '67' and `transaction_type_id` in ('5', '13', '14') order by `created_at` asc
1.66ms/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:76seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `views` where `viewable_id` = '67' and `viewable_type` = 'donor' limit 1
570μs/app/helpers/statistics_helper.php:207seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `cms_menu` order by `order` asc
810μs/Modules/Cms/Repositories/web/facade/cms.php:285seedoutm_seedout_stagingMetadata | |
---|---|
Hints |
|
Backtrace |
|