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 |
|
20 |
|
21 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
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 |
|
20 |
|
21 |
|
22 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
select * from `currencies`
290μ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'
960μ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.63ms/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-03-03 11:03:11' and '2025-04-02 11:03:11' group by `categories`.`id`, `borrower`.`borrower_gender`
970μ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-03-03 11:03:11' and '2025-04-02 11:03:11' group by `categories`.`id`, `borrower`.`borrower_gender` order by `applications`.`created_at` desc
970μ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.6s/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'
930μ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`
920μs/Modules/Application/Repositories/web/facade/Filters.php:232seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `donation_account` where `donation_account`.`id` = '12605' limit 1
310μs/Modules/User/Http/Controllers/Web/UserController.php:399seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `donor` where `donor`.`id` in ('6569') 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` = '6569' and `viewable_type` = 'donor'
2.84ms/app/helpers/statistics_helper.php:196seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
update `views` set `views` = `views` + 1, `updated_at` = '2025-03-03 11:03:13' where `viewable_id` = '6569' and `viewable_type` = 'donor'
17.1ms/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` = '12605' and `to_account_id` not in ('1', '2', '3', '1061', '7000', '5760', '14258', '15089') group by `to_account_id`
370μ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` = '12605' and `to_account_id` not in ('1', '2', '3', '1061', '7000', '5760', '14258', '15089') group by `to_account_id` limit 30 offset 0
510μ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` = '12605' group by `to_account_id`
250μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `donation_account` where `donation_account`.`id` in ('8385', '14719')
230μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `applications` where `applications`.`id` in ('3527', '5056') and `applications`.`deleted_at` is null
330μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `borrower` where `borrower`.`id` in ('3582', '5112') and `borrower`.`deleted_at` is null
490μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `branches` where `branches`.`id` = '9' 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` = '15' and `branches`.`deleted_at` is null limit 1
210μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `cities` where `cities`.`id` = '2207962' limit 1
190μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:59seedoutm_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 `amount`, `created_at` from `donation_account_transactions` where `from_account_id` = '12605' and `transaction_type_id` in ('2', '3', '9') order by `created_at` asc
210μ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` = '12605' and `transaction_type_id` in ('5', '13', '14') order by `created_at` asc
370μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:76seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `views` where `viewable_id` = '6569' and `viewable_type` = 'donor' limit 1
1.99ms/app/helpers/statistics_helper.php:207seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `donation_account` where `donation_account`.`id` = '8385' limit 1
180μsview::user::web.user.donor_profile:77seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `applications` where `applications`.`id` = '3527' and `applications`.`deleted_at` is null limit 1
250μsview::user::web.user.donor_profile:77seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `borrower_media` where `borrower_media`.`application_id` = '3527' and `borrower_media`.`application_id` is not null limit 1
2.48ms/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:98seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `applications` where `applications`.`id` = '3527' limit 1
240μs/Modules/Application/Entities/BorrowerMedia.php:89seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `borrower` where `borrower`.`id` = '3582' and `borrower`.`deleted_at` is null limit 1
360μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:22seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `donation_account` where `donation_account`.`accountable_id` = '3527' and `donation_account`.`accountable_id` is not null and `donation_account`.`accountable_type` = 'application' limit 1
230μs/Modules/Application/Entities/Traits/ApplicationDonationTrait.php:97seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `donation_account` where `account_no` = '5abfd47765e1a' limit 1
220μs/Modules/Cms/Repositories/web/facade/Account/account.php:94seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `donation_account` where `account_no` = '5abfd47765e1c' limit 1
220μs/Modules/Cms/Repositories/web/facade/Account/account.php:95seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `donation_account` where `account_no` = '5abfd47765e1b' limit 1
170μs/Modules/Cms/Repositories/web/facade/Account/account.php:96seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `donation_account` where `account_no` = '5abfd45565e1b' limit 1
170μs/Modules/Cms/Repositories/web/facade/Account/account.php:97seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select sum(amount) as total from `donation_account_transactions` where `transaction_type_id` in ('2', '9') and (`from_account_id` in ('8385') or `to_account_id` in ('8385')) limit 1
820μs/Modules/Cms/Repositories/web/facade/Account/AccountReporting.php:679seedoutm_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 `cities` where `id` = '2207962' limit 1
150μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `countries` where `countries`.`id` in ('168')
240μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `cities` where `id` = '2207962' limit 1
140μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `countries` where `countries`.`id` in ('168')
230μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `cities` where `id` = '2207962' limit 1
130μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `countries` where `countries`.`id` in ('168')
210μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `cities` where `id` = '2207962' limit 1
120μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `countries` where `countries`.`id` in ('168')
240μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `donation_account` where `donation_account`.`id` = '14719' limit 1
110μsview::user::web.user.donor_profile:77seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `applications` where `applications`.`id` = '5056' and `applications`.`deleted_at` is null limit 1
220μsview::user::web.user.donor_profile:77seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `borrower_media` where `borrower_media`.`application_id` = '5056' and `borrower_media`.`application_id` is not null limit 1
3.16ms/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:98seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `applications` where `applications`.`id` = '5056' limit 1
260μs/Modules/Application/Entities/BorrowerMedia.php:89seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `borrower` where `borrower`.`id` = '5112' and `borrower`.`deleted_at` is null limit 1
330μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:22seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `donation_account` where `donation_account`.`accountable_id` = '5056' and `donation_account`.`accountable_id` is not null and `donation_account`.`accountable_type` = 'application' limit 1
190μs/Modules/Application/Entities/Traits/ApplicationDonationTrait.php:97seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select sum(amount) as total from `donation_account_transactions` where `transaction_type_id` in ('2', '9') and (`from_account_id` in ('14719') or `to_account_id` in ('14719')) limit 1
350μs/Modules/Cms/Repositories/web/facade/Account/AccountReporting.php:679seedoutm_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 `cities` where `id` = '2189673' limit 1
130μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `countries` where `countries`.`id` in ('168')
200μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `cities` where `id` = '2189673' limit 1
130μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `countries` where `countries`.`id` in ('168')
220μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `cities` where `id` = '2189673' limit 1
90μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `countries` where `countries`.`id` in ('168')
230μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `cities` where `id` = '2189673' limit 1
170μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `countries` where `countries`.`id` in ('168')
220μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_stagingMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `cms_menu` order by `order` asc
730μs/Modules/Cms/Repositories/web/facade/cms.php:285seedoutm_seedout_stagingMetadata | |
---|---|
Hints |
|
Backtrace |
|