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`
230μ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'
1.13ms/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.82ms/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.58ms/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-03-02 02:28:19' and '2025-04-01 02:28:19' group by `categories`.`id`, `borrower`.`borrower_gender`
1.07ms/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-03-02 02:28:19' and '2025-04-01 02:28:19' group by `categories`.`id`, `borrower`.`borrower_gender` order by `applications`.`created_at` desc
1.05ms/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.58s/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.06ms/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`
970μs/Modules/Application/Repositories/web/facade/Filters.php:232seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `donation_account` where `donation_account`.`id` = '2231' limit 1
340μs/Modules/User/Http/Controllers/Web/UserController.php:399seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `donor` where `donor`.`id` in ('730') 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` = '730' and `viewable_type` = 'donor'
2.91ms/app/helpers/statistics_helper.php:196seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
update `views` set `views` = `views` + 1, `updated_at` = '2025-03-02 02:28:21' where `viewable_id` = '730' and `viewable_type` = 'donor'
17.29ms/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` = '2231' and `to_account_id` not in ('1', '2', '3', '1061', '7000', '5760', '14258', '15089') group by `to_account_id`
460μ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` = '2231' and `to_account_id` not in ('1', '2', '3', '1061', '7000', '5760', '14258', '15089') group by `to_account_id` limit 30 offset 0
970μs/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` = '2231' group by `to_account_id`
380μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `donation_account` where `donation_account`.`id` in ('3758', '3777', '4076', '4327', '4556', '5025', '5031', '5162', '5197', '5325', '5578', '5623', '7722', '7912', '8061', '8197', '8225', '8373', '8613', '9263', '9754', '9791', '11672', '12541', '13100', '13193', '13842', '13953', '14356', '14805', '14847', '15963', '17079', '17718', '21703')
510μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `applications` where `applications`.`id` in ('1683', '1693', '1861', '2033', '2174', '2425', '2430', '2518', '2546', '2632', '2797', '2828', '3239', '3341', '3410', '3488', '3504', '3526', '3566', '3690', '3823', '3834', '4212', '4402', '4541', '4551', '4692', '4727', '4898', '5091', '5104', '5230', '5427', '5480', '5720') and `applications`.`deleted_at` is null
1.06ms/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `borrower` where `borrower`.`id` in ('1737', '1747', '1916', '2088', '2228', '2479', '2484', '2572', '2600', '2687', '2852', '2883', '3293', '3396', '3465', '3542', '3558', '3581', '3621', '3746', '3879', '3890', '4269', '4459', '4598', '4608', '4748', '4782', '4955', '5148', '5161', '5287', '5484', '5538', '5717') and `borrower`.`deleted_at` is null
2.03ms/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209seedoutm_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` = '9' 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` = '7' 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
170μ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
140μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '12' and `branches`.`deleted_at` is null limit 1
120μ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
150μ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
150μ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
150μ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
150μ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
120μ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
120μ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` = '22' and `branches`.`deleted_at` is null limit 1
120μ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
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
190μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '14' 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` = '23' and `branches`.`deleted_at` is null limit 1
110μ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` = '15' and `branches`.`deleted_at` is null limit 1
190μ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
170μ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
170μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '23' and `branches`.`deleted_at` is null limit 1
190μ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
190μ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
170μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '15' 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` = '23' and `branches`.`deleted_at` is null limit 1
120μ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` = '21' and `branches`.`deleted_at` is null limit 1
190μ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
190μ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
190μ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
190μ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
190μ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
190μ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 `cities` where `cities`.`id` = '3150684' 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
160μ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 * from `cities` where `cities`.`id` = '2189673' limit 1
150μ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` = '2231' and `transaction_type_id` in ('2', '3', '9') order by `created_at` asc
380μ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` = '2231' and `transaction_type_id` in ('5', '13', '14') order by `created_at` asc
2.61ms/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:76seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `views` where `viewable_id` = '730' and `viewable_type` = 'donor' limit 1
920μs/app/helpers/statistics_helper.php:207seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `cms_menu` order by `order` asc
710μs/Modules/Cms/Repositories/web/facade/cms.php:285seedoutm_seedout_stagingMetadata | |
---|---|
Hints |
|
Backtrace |
|