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`
170μ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'
970μ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.68ms/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.44ms/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-14 19:01:36' and '2025-05-14 19:01:36' group by `categories`.`id`, `borrower`.`borrower_gender`
980μ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-14 19:01:36' and '2025-05-14 19:01:36' group by `categories`.`id`, `borrower`.`borrower_gender` order by `applications`.`created_at` desc
1ms/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.53s/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'
920μ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`
890μs/Modules/Application/Repositories/web/facade/Filters.php:232seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `donation_account` where `donation_account`.`id` = '7997' limit 1
360μs/Modules/User/Http/Controllers/Web/UserController.php:399seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `donor` where `donor`.`id` in ('3084') and `donor`.`deleted_at` is null
340μs/Modules/User/Http/Controllers/Web/UserController.php:399seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `views` where `viewable_id` = '3084' and `viewable_type` = 'donor'
2.88ms/app/helpers/statistics_helper.php:196seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
update `views` set `views` = `views` + 1, `updated_at` = '2025-04-14 19:01:38' where `viewable_id` = '3084' and `viewable_type` = 'donor'
16.92ms/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` = '7997' and `to_account_id` not in ('1', '2', '3', '1061', '7000', '5760', '14258', '15089') group by `to_account_id`
320μ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` = '7997' and `to_account_id` not in ('1', '2', '3', '1061', '7000', '5760', '14258', '15089') group by `to_account_id` limit 30 offset 0
490μ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` = '7997' group by `to_account_id`
310μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `donation_account` where `donation_account`.`id` in ('5369', '8865', '9450', '13463', '14394')
260μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `applications` where `applications`.`id` in ('2666', '3614', '3748', '4592', '4917') and `applications`.`deleted_at` is null
340μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `borrower` where `borrower`.`id` in ('2721', '3669', '3804', '4649', '4974') and `borrower`.`deleted_at` is null
710μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '14' 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` = '22' 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` = '20' 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
130μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `cities` where `cities`.`id` = '2189673' limit 1
130μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:59seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `cities` where `cities`.`id` = '3150684' limit 1
90μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:59seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `cities` where `cities`.`id` = '2177387' limit 1
80μ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` = '7997' and `transaction_type_id` in ('2', '3', '9') order by `created_at` asc
150μ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` = '7997' and `transaction_type_id` in ('5', '13', '14') order by `created_at` asc
320μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:76seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `views` where `viewable_id` = '3084' and `viewable_type` = 'donor' limit 1
1.48ms/app/helpers/statistics_helper.php:207seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `cms_menu` order by `order` asc
790μs/Modules/Cms/Repositories/web/facade/cms.php:285seedoutm_seedout_stagingMetadata | |
---|---|
Hints |
|
Backtrace |
|