Seed Out Empowering the People

#	Expected Date	Expected Amount	Amount Received	Received Date	Recovery Status
No Repayment exists Yet

Messages Timeline Exceptions Views7 Route Queries61 Mails Auth Gate Session Request

2.1s33.5MBGET donate/{application_id}

Booting (1.95s)
Application (2.04s)

7 templates were rendered

Application::web.project_detail (Modules/Application/Resources/views/web/project_detail.blade.php)5blade
Params
0
app
1
donors
2
applicable
3
payment_plan_exits
4
repayments

Params
0	`app`
1	`donors`
2	`applicable`
3	`payment_plan_exits`
4	`repayments`

layouts.web.master (resources/themes/metronic/layouts/web/master.blade.php)22blade


obLevel
__env
app
request_protocol
meta_title
meta_keywords
meta_description
og_title
og_description
og_type
og_image
og_site_name
errors
donors
applicable
payment_plan_exits
repayments
vh_arr
i
city_id
city_name
city_portfolio

Params
0	`obLevel`
1	`__env`
2	`app`
3	`request_protocol`
4	`meta_title`
5	`meta_keywords`
6	`meta_description`
7	`og_title`
8	`og_description`
9	`og_type`
10	`og_image`
11	`og_site_name`
12	`errors`
13	`donors`
14	`applicable`
15	`payment_plan_exits`
16	`repayments`
17	`vh_arr`
18	`i`
19	`city_id`
20	`city_name`
21	`city_portfolio`

partials.web.head_styles (resources/themes/metronic/partials/web/head_styles.blade.php)23blade


obLevel
__env
app
request_protocol
meta_title
meta_keywords
meta_description
og_title
og_description
og_type
og_image
og_site_name
errors
donors
applicable
payment_plan_exits
repayments
vh_arr
i
city_id
city_name
city_portfolio
user

Params
0	`obLevel`
1	`__env`
2	`app`
3	`request_protocol`
4	`meta_title`
5	`meta_keywords`
6	`meta_description`
7	`og_title`
8	`og_description`
9	`og_type`
10	`og_image`
11	`og_site_name`
12	`errors`
13	`donors`
14	`applicable`
15	`payment_plan_exits`
16	`repayments`
17	`vh_arr`
18	`i`
19	`city_id`
20	`city_name`
21	`city_portfolio`
22	`user`

web.javascriptRoutes (resources/views/web/javascriptRoutes.blade.php)22blade


obLevel
__env
app
request_protocol
meta_title
meta_keywords
meta_description
og_title
og_description
og_type
og_image
og_site_name
errors
donors
applicable
payment_plan_exits
repayments
vh_arr
i
city_id
city_name
city_portfolio

Params
0	`obLevel`
1	`__env`
2	`app`
3	`request_protocol`
4	`meta_title`
5	`meta_keywords`
6	`meta_description`
7	`og_title`
8	`og_description`
9	`og_type`
10	`og_image`
11	`og_site_name`
12	`errors`
13	`donors`
14	`applicable`
15	`payment_plan_exits`
16	`repayments`
17	`vh_arr`
18	`i`
19	`city_id`
20	`city_name`
21	`city_portfolio`

partials.web.header (resources/themes/metronic/partials/web/header.blade.php)23blade


obLevel
__env
app
request_protocol
meta_title
meta_keywords
meta_description
og_title
og_description
og_type
og_image
og_site_name
errors
donors
applicable
payment_plan_exits
repayments
vh_arr
i
city_id
city_name
city_portfolio
user

Params
0	`obLevel`
1	`__env`
2	`app`
3	`request_protocol`
4	`meta_title`
5	`meta_keywords`
6	`meta_description`
7	`og_title`
8	`og_description`
9	`og_type`
10	`og_image`
11	`og_site_name`
12	`errors`
13	`donors`
14	`applicable`
15	`payment_plan_exits`
16	`repayments`
17	`vh_arr`
18	`i`
19	`city_id`
20	`city_name`
21	`city_portfolio`
22	`user`

partials.web.footer (resources/themes/metronic/partials/web/footer.blade.php)24blade


obLevel
__env
app
request_protocol
meta_title
meta_keywords
meta_description
og_title
og_description
og_type
og_image
og_site_name
errors
donors
applicable
payment_plan_exits
repayments
vh_arr
i
city_id
city_name
city_portfolio
color_class
user

Params
0	`obLevel`
1	`__env`
2	`app`
3	`request_protocol`
4	`meta_title`
5	`meta_keywords`
6	`meta_description`
7	`og_title`
8	`og_description`
9	`og_type`
10	`og_image`
11	`og_site_name`
12	`errors`
13	`donors`
14	`applicable`
15	`payment_plan_exits`
16	`repayments`
17	`vh_arr`
18	`i`
19	`city_id`
20	`city_name`
21	`city_portfolio`
22	`color_class`
23	`user`

flash.web.message (resources/views/flash/web/message.blade.php)22blade


obLevel
__env
app
request_protocol
meta_title
meta_keywords
meta_description
og_title
og_description
og_type
og_image
og_site_name
errors
donors
applicable
payment_plan_exits
repayments
vh_arr
i
city_id
city_name
city_portfolio

Params
0	`obLevel`
1	`__env`
2	`app`
3	`request_protocol`
4	`meta_title`
5	`meta_keywords`
6	`meta_description`
7	`og_title`
8	`og_description`
9	`og_type`
10	`og_image`
11	`og_site_name`
12	`errors`
13	`donors`
14	`applicable`
15	`payment_plan_exits`
16	`repayments`
17	`vh_arr`
18	`i`
19	`city_id`
20	`city_name`
21	`city_portfolio`

uri: GET donate/{application_id}
middleware: web, checkZone
as: web.application.project.detail
controller: Modules\Application\Http\Controllers\web\ProjectController@detail
namespace: Modules\Application\Http\Controllers\web
prefix: null
where
file: Modules/Application/Http/Controllers/web/ProjectController.php:88-124

61 statements were executed, 31 of which were duplicated, 30 unique1.78s

select * from `currencies`140μs/vendor/torann/currency/src/Drivers/Database.php:62seedoutm_seedout_staging

Metadata
Hints	Use `SELECT *` only if you need all columns from table The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	9. /vendor/torann/currency/src/Drivers/Database.php:62 10. /vendor/torann/currency/src/Currency.php:242 11. /vendor/torann/currency/src/Currency.php:230 12. /vendor/torann/currency/src/Currency.php:215 13. /app/Providers/AppServiceProvider.php:47 25. /public/index.php:54

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.08ms/Modules/Application/Repositories/web/facade/Filters.php:186seedoutm_seedout_staging

Metadata
Bindings	0. 9 1. Live 2. Approved 3. borrower
Backtrace	13. /Modules/Application/Repositories/web/facade/Filters.php:186 14. /Modules/Application/Repositories/web/facade/Filters.php:186 15. /Modules/Application/Repositories/web/facade/Filters.php:172 17. /Modules/Application/Providers/ApplicationServiceProvider.php:44 18. /Modules/Application/Providers/ApplicationServiceProvider.php:44 30. /public/index.php:54

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.81ms/Modules/Application/Repositories/web/facade/Filters.php:192seedoutm_seedout_staging

Metadata
Bindings	0. 9 1. Live 2. Approved 3. borrower
Backtrace	11. /Modules/Application/Repositories/web/facade/Filters.php:192 12. /Modules/Application/Repositories/web/facade/Filters.php:172 14. /Modules/Application/Providers/ApplicationServiceProvider.php:44 15. /Modules/Application/Providers/ApplicationServiceProvider.php:44 27. /public/index.php:54

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.5ms/Modules/Application/Repositories/web/facade/Filters.php:198seedoutm_seedout_staging

Metadata
Bindings	0. 9 1. Live 2. Approved 3. borrower
Backtrace	11. /Modules/Application/Repositories/web/facade/Filters.php:198 12. /Modules/Application/Repositories/web/facade/Filters.php:172 14. /Modules/Application/Providers/ApplicationServiceProvider.php:44 15. /Modules/Application/Providers/ApplicationServiceProvider.php:44 27. /public/index.php:54

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-07 16:05:22' and '2025-05-07 16:05:22' group by `categories`.`id`, `borrower`.`borrower_gender`

1ms/Modules/Application/Repositories/web/facade/Filters.php:201seedoutm_seedout_staging

Metadata
Bindings	0. 9 1. Live 2. Approved 3. borrower 4. 2025-04-07 16:05:22 5. 2025-05-07 16:05:22
Backtrace	13. /Modules/Application/Repositories/web/facade/Filters.php:201 14. /Modules/Application/Repositories/web/facade/Filters.php:201 15. /Modules/Application/Repositories/web/facade/Filters.php:172 17. /Modules/Application/Providers/ApplicationServiceProvider.php:44 18. /Modules/Application/Providers/ApplicationServiceProvider.php:44 30. /public/index.php:54

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-07 16:05:22' and '2025-05-07 16:05:22' group by `categories`.`id`, `borrower`.`borrower_gender` order by `applications`.`created_at` desc

1ms/Modules/Application/Repositories/web/facade/Filters.php:205seedoutm_seedout_staging

Metadata
Bindings	0. 9 1. Live 2. Approved 3. borrower 4. 2025-04-07 16:05:22 5. 2025-05-07 16:05:22
Backtrace	13. /Modules/Application/Repositories/web/facade/Filters.php:205 14. /Modules/Application/Repositories/web/facade/Filters.php:205 15. /Modules/Application/Repositories/web/facade/Filters.php:172 17. /Modules/Application/Providers/ApplicationServiceProvider.php:44 18. /Modules/Application/Providers/ApplicationServiceProvider.php:44 30. /public/index.php:54

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.72s/Modules/Application/Repositories/web/facade/Filters.php:254seedoutm_seedout_staging

Metadata
Bindings	0. student 1. 9 2. Live 3. Approved
Backtrace	11. /Modules/Application/Repositories/web/facade/Filters.php:254 12. /Modules/Application/Repositories/web/facade/Filters.php:209 13. /Modules/Application/Repositories/web/facade/Filters.php:172 15. /Modules/Application/Providers/ApplicationServiceProvider.php:44 16. /Modules/Application/Providers/ApplicationServiceProvider.php:44 28. /public/index.php:54

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'

1ms/Modules/Application/Repositories/web/facade/Filters.php:225seedoutm_seedout_staging

Metadata
Bindings	0. 9 1. Live 2. Approved 3. student
Backtrace	13. /Modules/Application/Repositories/web/facade/Filters.php:225 14. /Modules/Application/Repositories/web/facade/Filters.php:225 15. /Modules/Application/Repositories/web/facade/Filters.php:213 16. /Modules/Application/Repositories/web/facade/Filters.php:172 18. /Modules/Application/Providers/ApplicationServiceProvider.php:44 19. /Modules/Application/Providers/ApplicationServiceProvider.php:44 31. /public/index.php:54

Metadata

Bindings

0. 9
1. Live
2. Approved
3. student

Backtrace

13. /Modules/Application/Repositories/web/facade/Filters.php:225
14. /Modules/Application/Repositories/web/facade/Filters.php:225
15. /Modules/Application/Repositories/web/facade/Filters.php:213
16. /Modules/Application/Repositories/web/facade/Filters.php:172
18. /Modules/Application/Providers/ApplicationServiceProvider.php:44
19. /Modules/Application/Providers/ApplicationServiceProvider.php:44
31. /public/index.php:54

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`

1.02ms/Modules/Application/Repositories/web/facade/Filters.php:232seedoutm_seedout_staging

Metadata
Bindings	0. student 1. 9 2. Live 3. Approved 4. student
Backtrace	11. /Modules/Application/Repositories/web/facade/Filters.php:232 12. /Modules/Application/Repositories/web/facade/Filters.php:213 13. /Modules/Application/Repositories/web/facade/Filters.php:172 15. /Modules/Application/Providers/ApplicationServiceProvider.php:44 16. /Modules/Application/Providers/ApplicationServiceProvider.php:44 28. /public/index.php:54

select * from `applications` where `id` = '5835' and `applications`.`web_status` in ('Live', 'Success', 'Completed') and `applications`.`status` not in ('Rejected', 'Denied') limit 1

530μs/Modules/Application/Http/Controllers/web/ProjectController.php:94seedoutm_seedout_staging

Metadata
Bindings	0. 5835 1. Live 2. Success 3. Completed 4. Rejected 5. Denied
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /Modules/Application/Http/Controllers/web/ProjectController.php:94 28. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 38. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 81. /app/Http/Middleware/HttpsProtocol.php:13 86. /app/Http/Middleware/InitiateTheme.php:19 100. /public/index.php:54

select * from `students` where `students`.`id` in ('56') and `students`.`deleted_at` is null330μs/Modules/Application/Http/Controllers/web/ProjectController.php:94seedoutm_seedout_staging

Metadata
Bindings	0. 56
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	17. /Modules/Application/Http/Controllers/web/ProjectController.php:94 33. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 43. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 86. /app/Http/Middleware/HttpsProtocol.php:13 91. /app/Http/Middleware/InitiateTheme.php:19 105. /public/index.php:54

select * from `donation_account` where `donation_account`.`accountable_id` in ('5835') and `donation_account`.`accountable_type` = 'application'

220μs/Modules/Application/Http/Controllers/web/ProjectController.php:94seedoutm_seedout_staging

Metadata
Bindings	0. 5835 1. application
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /Modules/Application/Http/Controllers/web/ProjectController.php:94 35. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 45. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 88. /app/Http/Middleware/HttpsProtocol.php:13 93. /app/Http/Middleware/InitiateTheme.php:19 107. /public/index.php:54

select * from `views` where `views`.`viewable_id` in ('5835') and `views`.`viewable_type` = 'application'2.93ms/Modules/Application/Http/Controllers/web/ProjectController.php:94seedoutm_seedout_staging

Metadata
Bindings	0. 5835 1. application
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /Modules/Application/Http/Controllers/web/ProjectController.php:94 35. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 45. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 88. /app/Http/Middleware/HttpsProtocol.php:13 93. /app/Http/Middleware/InitiateTheme.php:19 107. /public/index.php:54

select * from `application_contents` where `application_contents`.`application_id` in ('5835')5.04ms/Modules/Application/Http/Controllers/web/ProjectController.php:94seedoutm_seedout_staging

Metadata
Bindings	0. 5835
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /Modules/Application/Http/Controllers/web/ProjectController.php:94 35. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 45. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 88. /app/Http/Middleware/HttpsProtocol.php:13 93. /app/Http/Middleware/InitiateTheme.php:19 107. /public/index.php:54

select * from `borrower_payment_plan` where `borrower_payment_plan`.`application_id` in ('5835') order by `expected_date` asc, `id` asc

230μs/Modules/Application/Http/Controllers/web/ProjectController.php:94seedoutm_seedout_staging

Metadata
Bindings	0. 5835
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /Modules/Application/Http/Controllers/web/ProjectController.php:94 35. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 45. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 88. /app/Http/Middleware/HttpsProtocol.php:13 93. /app/Http/Middleware/InitiateTheme.php:19 107. /public/index.php:54

select * from `donation_account` where `account_no` = '5abfd47765e1a' limit 1210μs/Modules/Cms/Repositories/web/facade/Account/account.php:94seedoutm_seedout_staging

Metadata
Bindings	0. 5abfd47765e1a
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /Modules/Cms/Repositories/web/facade/Account/account.php:94 13. /Modules/Cms/Providers/CmsServiceProvider.php:115 21. /Modules/Application/Http/Controllers/web/ProjectController.php:101 22. /Modules/Application/Http/Controllers/web/ProjectController.php:101 38. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 48. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 91. /app/Http/Middleware/HttpsProtocol.php:13 96. /app/Http/Middleware/InitiateTheme.php:19 110. /public/index.php:54

select * from `donation_account` where `account_no` = '5abfd47765e1c' limit 1210μs/Modules/Cms/Repositories/web/facade/Account/account.php:95seedoutm_seedout_staging

Metadata
Bindings	0. 5abfd47765e1c
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /Modules/Cms/Repositories/web/facade/Account/account.php:95 13. /Modules/Cms/Providers/CmsServiceProvider.php:115 21. /Modules/Application/Http/Controllers/web/ProjectController.php:101 22. /Modules/Application/Http/Controllers/web/ProjectController.php:101 38. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 48. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 91. /app/Http/Middleware/HttpsProtocol.php:13 96. /app/Http/Middleware/InitiateTheme.php:19 110. /public/index.php:54

select * from `donation_account` where `account_no` = '5abfd47765e1b' limit 1250μs/Modules/Cms/Repositories/web/facade/Account/account.php:96seedoutm_seedout_staging

Metadata
Bindings	0. 5abfd47765e1b
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /Modules/Cms/Repositories/web/facade/Account/account.php:96 13. /Modules/Cms/Providers/CmsServiceProvider.php:115 21. /Modules/Application/Http/Controllers/web/ProjectController.php:101 22. /Modules/Application/Http/Controllers/web/ProjectController.php:101 38. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 48. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 91. /app/Http/Middleware/HttpsProtocol.php:13 96. /app/Http/Middleware/InitiateTheme.php:19 110. /public/index.php:54

select * from `donation_account` where `account_no` = '5abfd45565e1b' limit 1180μs/Modules/Cms/Repositories/web/facade/Account/account.php:97seedoutm_seedout_staging

Metadata
Bindings	0. 5abfd45565e1b
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /Modules/Cms/Repositories/web/facade/Account/account.php:97 13. /Modules/Cms/Providers/CmsServiceProvider.php:115 21. /Modules/Application/Http/Controllers/web/ProjectController.php:101 22. /Modules/Application/Http/Controllers/web/ProjectController.php:101 38. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 48. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 91. /app/Http/Middleware/HttpsProtocol.php:13 96. /app/Http/Middleware/InitiateTheme.php:19 110. /public/index.php:54

select *,from_account_id as donor_account_id,sum(amount) as donation_received,created_at as donated_on from `donation_account_transactions` where `transaction_type_id` in ('2', '3', '9') and `to_account_id` = '21923' group by `from_account_id`

360μs/Modules/Cms/Repositories/web/facade/Account/AccountHelpers.php:234seedoutm_seedout_staging

Metadata
Bindings	0. 2 1. 3 2. 9 3. 21923
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /Modules/Cms/Repositories/web/facade/Account/AccountHelpers.php:234 13. /Modules/Application/Http/Controllers/web/ProjectController.php:101 14. /Modules/Application/Http/Controllers/web/ProjectController.php:101 30. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 40. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 83. /app/Http/Middleware/HttpsProtocol.php:13 88. /app/Http/Middleware/InitiateTheme.php:19 102. /public/index.php:54

select count(*) as aggregate from `views` where `viewable_id` = '5835' and `viewable_type` = 'application'2.78ms/app/helpers/statistics_helper.php:196seedoutm_seedout_staging

Metadata
Bindings	0. 5835 1. application
Backtrace	13. /app/helpers/statistics_helper.php:196 14. /app/helpers/statistics_helper.php:196 31. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 41. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 84. /app/Http/Middleware/HttpsProtocol.php:13 89. /app/Http/Middleware/InitiateTheme.php:19 103. /public/index.php:54

update `views` set `views` = `views` + 1, `updated_at` = '2025-04-07 16:05:24' where `viewable_id` = '5835' and `viewable_type` = 'application'

17.27ms/app/helpers/statistics_helper.php:197seedoutm_seedout_staging

Metadata
Bindings	0. 2025-04-07 16:05:24 1. 5835 2. application
Backtrace	11. /app/helpers/statistics_helper.php:197 28. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 38. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 81. /app/Http/Middleware/HttpsProtocol.php:13 86. /app/Http/Middleware/InitiateTheme.php:19 100. /public/index.php:54

select * from `branches` where `approved_by_ceo` = 'Approved' and `status` = 'Active' and `branches`.`deleted_at` is null

480μs/Modules/Application/Repositories/web/facade/Filters.php:56seedoutm_seedout_staging

Metadata
Bindings	0. Approved 1. Active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /Modules/Application/Repositories/web/facade/Filters.php:56 12. /Modules/Application/Repositories/web/facade/Filters.php:71 14. /Modules/Application/Http/Controllers/web/ProjectController.php:81 15. /Modules/Application/Http/Controllers/web/ProjectController.php:81 16. /Modules/Application/Http/Controllers/web/ProjectController.php:106 32. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 42. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 85. /app/Http/Middleware/HttpsProtocol.php:13 90. /app/Http/Middleware/InitiateTheme.php:19 104. /public/index.php:54

select * from `cities` where `cities`.`id` in ('2207962', '2189673', '2177387', '3150684', '2199893')310μs/Modules/Application/Repositories/web/facade/Filters.php:56seedoutm_seedout_staging

Metadata
Bindings	0. 2207962 1. 2189673 2. 2177387 3. 3150684 4. 2199893
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	18. /Modules/Application/Repositories/web/facade/Filters.php:56 19. /Modules/Application/Repositories/web/facade/Filters.php:71 21. /Modules/Application/Http/Controllers/web/ProjectController.php:81 22. /Modules/Application/Http/Controllers/web/ProjectController.php:81 23. /Modules/Application/Http/Controllers/web/ProjectController.php:106 39. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 49. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 92. /app/Http/Middleware/HttpsProtocol.php:13 97. /app/Http/Middleware/InitiateTheme.php:19 111. /public/index.php:54

select * from `countries` where `countries`.`id` in ('168')300μs/Modules/Application/Repositories/web/facade/Filters.php:56seedoutm_seedout_staging

Metadata
Bindings	0. 168
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	25. /Modules/Application/Repositories/web/facade/Filters.php:56 26. /Modules/Application/Repositories/web/facade/Filters.php:71 28. /Modules/Application/Http/Controllers/web/ProjectController.php:81 29. /Modules/Application/Http/Controllers/web/ProjectController.php:81 30. /Modules/Application/Http/Controllers/web/ProjectController.php:106 46. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 56. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 99. /app/Http/Middleware/HttpsProtocol.php:13 104. /app/Http/Middleware/InitiateTheme.php:19 118. /public/index.php:54

select * from `branches` where `approved_by_ceo` = 'Approved' and `status` = 'Active' and `branches`.`deleted_at` is null

400μs/Modules/Application/Repositories/web/facade/Filters.php:56seedoutm_seedout_staging

Metadata
Bindings	0. Approved 1. Active
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /Modules/Application/Repositories/web/facade/Filters.php:56 12. /Modules/Application/Repositories/web/facade/Filters.php:92 14. /Modules/Application/Http/Controllers/web/ProjectController.php:82 15. /Modules/Application/Http/Controllers/web/ProjectController.php:82 16. /Modules/Application/Http/Controllers/web/ProjectController.php:106 32. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 42. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 85. /app/Http/Middleware/HttpsProtocol.php:13 90. /app/Http/Middleware/InitiateTheme.php:19 104. /public/index.php:54

select * from `cities` where `cities`.`id` in ('2207962', '2189673', '2177387', '3150684', '2199893')230μs/Modules/Application/Repositories/web/facade/Filters.php:56seedoutm_seedout_staging

Metadata
Bindings	0. 2207962 1. 2189673 2. 2177387 3. 3150684 4. 2199893
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	18. /Modules/Application/Repositories/web/facade/Filters.php:56 19. /Modules/Application/Repositories/web/facade/Filters.php:92 21. /Modules/Application/Http/Controllers/web/ProjectController.php:82 22. /Modules/Application/Http/Controllers/web/ProjectController.php:82 23. /Modules/Application/Http/Controllers/web/ProjectController.php:106 39. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 49. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 92. /app/Http/Middleware/HttpsProtocol.php:13 97. /app/Http/Middleware/InitiateTheme.php:19 111. /public/index.php:54

select * from `countries` where `countries`.`id` in ('168')260μs/Modules/Application/Repositories/web/facade/Filters.php:56seedoutm_seedout_staging

Metadata
Bindings	0. 168
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	25. /Modules/Application/Repositories/web/facade/Filters.php:56 26. /Modules/Application/Repositories/web/facade/Filters.php:92 28. /Modules/Application/Http/Controllers/web/ProjectController.php:82 29. /Modules/Application/Http/Controllers/web/ProjectController.php:82 30. /Modules/Application/Http/Controllers/web/ProjectController.php:106 46. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 56. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 99. /app/Http/Middleware/HttpsProtocol.php:13 104. /app/Http/Middleware/InitiateTheme.php:19 118. /public/index.php:54

select * from `categories`200μs/Modules/Application/Repositories/web/facade/Filters.php:124seedoutm_seedout_staging

Metadata

Hints

Use SELECT * only if you need all columns from table
The SELECT statement has no WHERE clause and could examine many more rows than intended

Backtrace

9. /Modules/Application/Repositories/web/facade/Filters.php:124
10. /Modules/Application/Repositories/web/facade/Filters.php:140
12. /Modules/Application/Http/Controllers/web/ProjectController.php:83
13. /Modules/Application/Http/Controllers/web/ProjectController.php:83
14. /Modules/Application/Http/Controllers/web/ProjectController.php:106
30. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22
40. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33
83. /app/Http/Middleware/HttpsProtocol.php:13
88. /app/Http/Middleware/InitiateTheme.php:19
102. /public/index.php:54

select * from `borrower` where `borrower`.`current_process_flow_id` = '9' and `borrower`.`web_status` = 'Live' and `borrower`.`status` = 'Approved'

3.65ms/Modules/Application/Repositories/web/facade/Filters.php:155seedoutm_seedout_staging

Metadata
Bindings	0. 9 1. Live 2. Approved
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /Modules/Application/Repositories/web/facade/Filters.php:155 13. /Modules/Application/Http/Controllers/web/ProjectController.php:84 14. /Modules/Application/Http/Controllers/web/ProjectController.php:84 15. /Modules/Application/Http/Controllers/web/ProjectController.php:106 31. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 41. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 84. /app/Http/Middleware/HttpsProtocol.php:13 89. /app/Http/Middleware/InitiateTheme.php:19 103. /public/index.php:54

select * from `cms_menu` order by `order` asc730μs/Modules/Cms/Repositories/web/facade/cms.php:285seedoutm_seedout_staging

Metadata

Hints

Use SELECT * only if you need all columns from table
The SELECT statement has no WHERE clause and could examine many more rows than intended

Backtrace

11. /Modules/Cms/Repositories/web/facade/cms.php:285
12. /Modules/Cms/Repositories/web/facade/cms.php:117
13. /Modules/Cms/Repositories/web/facade/cms.php:94
15. /Modules/Application/Http/Controllers/web/ProjectController.php:109
16. /Modules/Application/Http/Controllers/web/ProjectController.php:109
32. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22
42. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33
85. /app/Http/Middleware/HttpsProtocol.php:13
90. /app/Http/Middleware/InitiateTheme.php:19
104. /public/index.php:54

select * from `applications` where `applications`.`id` = '5835' limit 1280μs/Modules/Application/Entities/ApplicationContent.php:58seedoutm_seedout_staging

Metadata
Bindings	0. 5835
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	17. /Modules/Application/Entities/ApplicationContent.php:58 22. /Modules/Cms/Repositories/web/facade/cms.php:195 23. /Modules/Cms/Repositories/web/facade/cms.php:139 24. /Modules/Cms/Repositories/web/facade/cms.php:96 26. /Modules/Application/Http/Controllers/web/ProjectController.php:109 27. /Modules/Application/Http/Controllers/web/ProjectController.php:109 43. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 53. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 96. /app/Http/Middleware/HttpsProtocol.php:13 101. /app/Http/Middleware/InitiateTheme.php:19 115. /public/index.php:54

select * from `borrower_media` where `borrower_media`.`application_id` = '5835' and `borrower_media`.`application_id` is not null limit 1

3.52ms/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:104seedoutm_seedout_staging

Metadata
Bindings	0. 5835
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	17. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:104 22. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:138 27. /Modules/Cms/Repositories/web/facade/cms.php:203 28. /Modules/Cms/Repositories/web/facade/cms.php:139 29. /Modules/Cms/Repositories/web/facade/cms.php:96 31. /Modules/Application/Http/Controllers/web/ProjectController.php:109 32. /Modules/Application/Http/Controllers/web/ProjectController.php:109 48. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 58. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 101. /app/Http/Middleware/HttpsProtocol.php:13 106. /app/Http/Middleware/InitiateTheme.php:19 120. /public/index.php:54

select * from `applications` where `applications`.`id` = '5835' limit 1180μs/Modules/Application/Entities/BorrowerMedia.php:89seedoutm_seedout_staging

Metadata
Bindings	0. 5835
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	17. /Modules/Application/Entities/BorrowerMedia.php:89 22. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:105 27. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:138 32. /Modules/Cms/Repositories/web/facade/cms.php:203 33. /Modules/Cms/Repositories/web/facade/cms.php:139 34. /Modules/Cms/Repositories/web/facade/cms.php:96 36. /Modules/Application/Http/Controllers/web/ProjectController.php:109 37. /Modules/Application/Http/Controllers/web/ProjectController.php:109 53. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 63. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 106. /app/Http/Middleware/HttpsProtocol.php:13 111. /app/Http/Middleware/InitiateTheme.php:19 125. /public/index.php:54

select * from `borrower_payment_plan` where `application_id` = '5835' order by `expected_date` asc, `id` asc180μs/app/helpers/payment_plan.php:85seedoutm_seedout_staging

Metadata
Bindings	0. 5835
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /app/helpers/payment_plan.php:85 28. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 38. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 81. /app/Http/Middleware/HttpsProtocol.php:13 86. /app/Http/Middleware/InitiateTheme.php:19 100. /public/index.php:54

select sum(amount) as total from `donation_account_transactions` where `transaction_type_id` in ('2', '3', '9') and (`from_account_id` in ('21923') or `to_account_id` in ('21923')) limit 1

260μs/Modules/Cms/Repositories/web/facade/Account/AccountReporting.php:679seedoutm_seedout_staging

Metadata
Bindings	0. 2 1. 3 2. 9 3. 21923 4. 21923
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /Modules/Cms/Repositories/web/facade/Account/AccountReporting.php:679 13. /Modules/Cms/Repositories/web/facade/Account/AccountReporting.php:597 15. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:74 16. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:74 21. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:54 26. view::Application::web.project_detail:145 33. /vendor/symfony/http-foundation/Response.php:201 47. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 57. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 100. /app/Http/Middleware/HttpsProtocol.php:13 105. /app/Http/Middleware/InitiateTheme.php:19 119. /public/index.php:54

select sum(amount) as total from `donation_account_transactions` where `transaction_type_id` in ('2', '9') and (`from_account_id` in ('21923') or `to_account_id` in ('21923')) limit 1

220μs/Modules/Cms/Repositories/web/facade/Account/AccountReporting.php:679seedoutm_seedout_staging

Metadata
Bindings	0. 2 1. 9 2. 21923 3. 21923
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /Modules/Cms/Repositories/web/facade/Account/AccountReporting.php:679 13. /Modules/Cms/Repositories/web/facade/Account/AccountReporting.php:571 15. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:97 16. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:97 21. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:102 26. view::Application::web.project_detail:147 33. /vendor/symfony/http-foundation/Response.php:201 47. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 57. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 100. /app/Http/Middleware/HttpsProtocol.php:13 105. /app/Http/Middleware/InitiateTheme.php:19 119. /public/index.php:54

select sum(amount) as total from `donation_account_transactions` where `transaction_type_id` in ('5', '13', '14') and (`from_account_id` in ('21923') or `to_account_id` in ('21923')) limit 1

220μs/Modules/Cms/Repositories/web/facade/Account/AccountReporting.php:679seedoutm_seedout_staging

Metadata
Bindings	0. 5 1. 13 2. 14 3. 21923 4. 21923
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /Modules/Cms/Repositories/web/facade/Account/AccountReporting.php:679 13. /Modules/Cms/Repositories/web/facade/Account/AccountReporting.php:610 15. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:111 16. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:111 21. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:133 26. view::Application::web.project_detail:148 33. /vendor/symfony/http-foundation/Response.php:201 47. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 57. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 100. /app/Http/Middleware/HttpsProtocol.php:13 105. /app/Http/Middleware/InitiateTheme.php:19 119. /public/index.php:54

select sum(amount) as total from `donation_account_transactions` where `transaction_type_id` in ('2', '9') and (`from_account_id` in ('21923') or `to_account_id` in ('21923')) limit 1

240μs/Modules/Cms/Repositories/web/facade/Account/AccountReporting.php:679seedoutm_seedout_staging

Metadata
Bindings	0. 2 1. 9 2. 21923 3. 21923
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /Modules/Cms/Repositories/web/facade/Account/AccountReporting.php:679 13. /Modules/Cms/Repositories/web/facade/Account/AccountReporting.php:571 15. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:97 16. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:97 21. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:102 26. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:124 31. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:79 36. view::Application::web.project_detail:149 43. /vendor/symfony/http-foundation/Response.php:201 57. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 67. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 110. /app/Http/Middleware/HttpsProtocol.php:13 115. /app/Http/Middleware/InitiateTheme.php:19 129. /public/index.php:54

select sum(amount) as total from `donation_account_transactions` where `transaction_type_id` in ('2', '9') and (`from_account_id` in ('21923') or `to_account_id` in ('21923')) limit 1

150μs/Modules/Cms/Repositories/web/facade/Account/AccountReporting.php:679seedoutm_seedout_staging

Metadata
Bindings	0. 2 1. 9 2. 21923 3. 21923
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /Modules/Cms/Repositories/web/facade/Account/AccountReporting.php:679 13. /Modules/Cms/Repositories/web/facade/Account/AccountReporting.php:571 15. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:97 16. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:97 21. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:102 26. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:124 31. view::Application::web.project_detail:151 38. /vendor/symfony/http-foundation/Response.php:201 52. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 62. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 105. /app/Http/Middleware/HttpsProtocol.php:13 110. /app/Http/Middleware/InitiateTheme.php:19 124. /public/index.php:54

select * from `cities` where `id` = '2194408' limit 1150μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 2194408
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /Modules/Application/Repositories/web/facade/CountriesFilter.php:73 13. /Modules/Application/Repositories/web/facade/CountriesFilter.php:135 15. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 16. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 21. view::Application::web.project_detail:156 28. /vendor/symfony/http-foundation/Response.php:201 42. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 52. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 95. /app/Http/Middleware/HttpsProtocol.php:13 100. /app/Http/Middleware/InitiateTheme.php:19 114. /public/index.php:54

select * from `countries` where `countries`.`id` in ('168')210μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 168
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /Modules/Application/Repositories/web/facade/CountriesFilter.php:73 20. /Modules/Application/Repositories/web/facade/CountriesFilter.php:135 22. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 23. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 28. view::Application::web.project_detail:156 35. /vendor/symfony/http-foundation/Response.php:201 49. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 59. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 102. /app/Http/Middleware/HttpsProtocol.php:13 107. /app/Http/Middleware/InitiateTheme.php:19 121. /public/index.php:54

select * from `cities` where `id` = '2194408' limit 1130μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 2194408
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /Modules/Application/Repositories/web/facade/CountriesFilter.php:73 13. /Modules/Application/Repositories/web/facade/CountriesFilter.php:135 15. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 16. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 21. view::Application::web.project_detail:157 28. /vendor/symfony/http-foundation/Response.php:201 42. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 52. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 95. /app/Http/Middleware/HttpsProtocol.php:13 100. /app/Http/Middleware/InitiateTheme.php:19 114. /public/index.php:54

select * from `countries` where `countries`.`id` in ('168')210μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 168
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /Modules/Application/Repositories/web/facade/CountriesFilter.php:73 20. /Modules/Application/Repositories/web/facade/CountriesFilter.php:135 22. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 23. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 28. view::Application::web.project_detail:157 35. /vendor/symfony/http-foundation/Response.php:201 49. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 59. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 102. /app/Http/Middleware/HttpsProtocol.php:13 107. /app/Http/Middleware/InitiateTheme.php:19 121. /public/index.php:54

select * from `views` where `viewable_id` = '5835' and `viewable_type` = 'application' limit 12.8ms/app/helpers/statistics_helper.php:207seedoutm_seedout_staging

Metadata
Bindings	0. 5835 1. application
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /app/helpers/statistics_helper.php:207 20. /vendor/symfony/http-foundation/Response.php:201 34. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 44. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 87. /app/Http/Middleware/HttpsProtocol.php:13 92. /app/Http/Middleware/InitiateTheme.php:19 106. /public/index.php:54

select sum(amount) as total from `donation_account_transactions` where `transaction_type_id` in ('2', '3', '9') and (`from_account_id` in ('21923') or `to_account_id` in ('21923')) limit 1

230μs/Modules/Cms/Repositories/web/facade/Account/AccountReporting.php:679seedoutm_seedout_staging

Metadata
Bindings	0. 2 1. 3 2. 9 3. 21923 4. 21923
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /Modules/Cms/Repositories/web/facade/Account/AccountReporting.php:679 13. /Modules/Cms/Repositories/web/facade/Account/AccountReporting.php:597 15. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:74 16. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:74 21. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:54 26. view::Application::web.project_detail:168 33. /vendor/symfony/http-foundation/Response.php:201 47. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 57. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 100. /app/Http/Middleware/HttpsProtocol.php:13 105. /app/Http/Middleware/InitiateTheme.php:19 119. /public/index.php:54

select * from `cities` where `id` = '2194408' limit 1170μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 2194408
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /Modules/Application/Repositories/web/facade/CountriesFilter.php:73 13. /Modules/Application/Repositories/web/facade/CountriesFilter.php:135 15. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 16. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 21. view::Application::web.project_detail:324 28. /vendor/symfony/http-foundation/Response.php:201 42. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 52. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 95. /app/Http/Middleware/HttpsProtocol.php:13 100. /app/Http/Middleware/InitiateTheme.php:19 114. /public/index.php:54

select * from `countries` where `countries`.`id` in ('168')230μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 168
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /Modules/Application/Repositories/web/facade/CountriesFilter.php:73 20. /Modules/Application/Repositories/web/facade/CountriesFilter.php:135 22. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 23. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 28. view::Application::web.project_detail:324 35. /vendor/symfony/http-foundation/Response.php:201 49. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 59. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 102. /app/Http/Middleware/HttpsProtocol.php:13 107. /app/Http/Middleware/InitiateTheme.php:19 121. /public/index.php:54

select count(applications.id) as disbursed_apps,sum(loan_amount) as disbursed_amount from `applications` inner join `branches` on `branches`.`id` = `applications`.`branch_id` inner join `students` on `students`.`id` = `applications`.`applicable_id` and `applications`.`applicable_type` = 'student' inner join `cities` on `cities`.`id` = `branches`.`city_id` and `cities`.`id` = `students`.`current_address_city_id` where `disbursement_status` = 'yes' and `applications`.`status` not in ('Rejected', 'Denied') and `cities`.`id` is null and `applications`.`deleted_at` is null limit 1

220μs/Modules/Cms/Repositories/web/facade/Statistics/AboutUs.php:150seedoutm_seedout_staging

Metadata
Bindings	0. student 1. yes 2. Rejected 3. Denied
Hints	`LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /Modules/Cms/Repositories/web/facade/Statistics/AboutUs.php:150 13. /Modules/Cms/Repositories/web/facade/Statistics/AboutUs.php:109 15. view::Application::web.project_detail:327 16. view::Application::web.project_detail:327 23. /vendor/symfony/http-foundation/Response.php:201 37. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 47. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 90. /app/Http/Middleware/HttpsProtocol.php:13 95. /app/Http/Middleware/InitiateTheme.php:19 109. /public/index.php:54

select * from `cities` where `id` = '2194408' limit 1140μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 2194408
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	12. /Modules/Application/Repositories/web/facade/CountriesFilter.php:73 13. /Modules/Application/Repositories/web/facade/CountriesFilter.php:135 15. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 16. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 21. view::Application::web.project_detail:337 28. /vendor/symfony/http-foundation/Response.php:201 42. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 52. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 95. /app/Http/Middleware/HttpsProtocol.php:13 100. /app/Http/Middleware/InitiateTheme.php:19 114. /public/index.php:54

select * from `countries` where `countries`.`id` in ('168')230μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 168
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /Modules/Application/Repositories/web/facade/CountriesFilter.php:73 20. /Modules/Application/Repositories/web/facade/CountriesFilter.php:135 22. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 23. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 28. view::Application::web.project_detail:337 35. /vendor/symfony/http-foundation/Response.php:201 49. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 59. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 102. /app/Http/Middleware/HttpsProtocol.php:13 107. /app/Http/Middleware/InitiateTheme.php:19 121. /public/index.php:54