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`
590μ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.84ms/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`
2.79ms/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`
2.52ms/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-26 07:20:50' and '2025-05-26 07:20:50' group by `categories`.`id`, `borrower`.`borrower_gender`
1.6ms/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-26 07:20:50' and '2025-05-26 07:20:50' group by `categories`.`id`, `borrower`.`borrower_gender` order by `applications`.`created_at` desc
1.63ms/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'
980μs/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`
990μs/Modules/Application/Repositories/web/facade/Filters.php:232seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `donation_account` where `donation_account`.`id` = '7021' limit 1
350μs/Modules/User/Http/Controllers/Web/UserController.php:399seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `donor` where `donor`.`id` in ('2668') and `donor`.`deleted_at` is null
310μs/Modules/User/Http/Controllers/Web/UserController.php:399seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `views` where `viewable_id` = '2668' and `viewable_type` = 'donor'
4.12ms/app/helpers/statistics_helper.php:196seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
update `views` set `views` = `views` + 1, `updated_at` = '2025-04-26 07:20:52' where `viewable_id` = '2668' and `viewable_type` = 'donor'
22.41ms/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` = '7021' and `to_account_id` not in ('1', '2', '3', '1061', '7000', '5760', '14258', '15089') group by `to_account_id`
620μ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` = '7021' and `to_account_id` not in ('1', '2', '3', '1061', '7000', '5760', '14258', '15089') group by `to_account_id` limit 30 offset 0
1.19ms/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` = '7021' group by `to_account_id`
480μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `donation_account` where `donation_account`.`id` in ('5067', '5333', '5439', '7372', '7431', '7468', '8074', '8373', '9722', '10122', '11771', '12320', '13636', '14356', '14396', '14414', '14609', '14741', '16553')
470μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `applications` where `applications`.`id` in ('2449', '2640', '2715', '3013', '3054', '3073', '3420', '3526', '3808', '3932', '4215', '4350', '4654', '4898', '4919', '4929', '4996', '5065', '5353') and `applications`.`deleted_at` is null
800μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `borrower` where `borrower`.`id` in ('2503', '2695', '2770', '3068', '3109', '3128', '3475', '3581', '3864', '3988', '4272', '4406', '4709', '4955', '4976', '4986', '5053', '5122', '5410') 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` = '11' 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
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
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
170μ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
190μ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
160μ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
160μ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
160μ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
200μ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
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
160μ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
160μ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
200μ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
160μ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
160μ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
160μ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
200μ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
160μ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
180μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_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
130μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:59seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `cities` where `cities`.`id` = '2177387' limit 1
150μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:59seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `cities` where `cities`.`id` = '2189673' limit 1
120μ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` = '7021' and `transaction_type_id` in ('2', '3', '9') order by `created_at` asc
320μ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` = '7021' and `transaction_type_id` in ('5', '13', '14') order by `created_at` asc
1.42ms/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:76seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `views` where `viewable_id` = '2668' and `viewable_type` = 'donor' limit 1
5.31ms/app/helpers/statistics_helper.php:207seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `cms_menu` order by `order` asc
900μs/Modules/Cms/Repositories/web/facade/cms.php:285seedoutm_seedout_stagingMetadata | |
---|---|
Hints |
|
Backtrace |
|