Seed Out Empowering the People

#	Expected Date	Expected Amount	Amount Received	Received Date	Recovery Status
1	Aug 1st, 2022	$18.00	$18.00	Aug 17th, 2022	Repaid
2	Sep 1st, 2022	$18.00	$18.00	Sep 12th, 2022	Repaid
3	Oct 1st, 2022	$18.00	$18.00	Oct 10th, 2022	Repaid
4	Nov 1st, 2022	$18.00	$18.00	Nov 14th, 2022	Repaid
5	Dec 1st, 2022	$18.00	$18.00	Dec 10th, 2022	Repaid
6	Feb 1st, 2023	$18.00	$18.00	Feb 15th, 2023	Repaid
7	Mar 1st, 2023	$18.00	$18.00	Apr 10th, 2023	Repaid
8	Apr 1st, 2023	$18.00	$18.00	May 12th, 2023	Repaid
9	Jun 1st, 2023	$18.00	$18.00	Jun 1st, 2023	Repaid
10	Jul 1st, 2023	$18.00	$18.00	Jul 24th, 2023	Repaid
11	Aug 1st, 2023	$18.00	$18.00	Aug 10th, 2023	Repaid
12	Sep 1st, 2023	$18.00	$0.00		Pending
13	Oct 1st, 2023	$18.00	$0.00		Pending
14	Nov 1st, 2023	$18.00	$0.00		Pending
15	Dec 1st, 2023	$18.00	$0.00		Pending
16	Jan 1st, 2024	$18.00	$0.00		Pending
17	Feb 1st, 2024	$18.00	$0.00		Pending
18	Mar 1st, 2024	$18.00	$0.00		Pending
19	Apr 1st, 2024	$18.00	$0.00		Pending
20	May 1st, 2024	$18.00	$0.00		Pending
21	Jun 1st, 2024	$18.00	$0.00		Pending
22	Jul 1st, 2024	$18.00	$0.00		Pending
23	Aug 1st, 2024	$18.00	$0.00		Pending
24	Sep 1st, 2024	$18.00	$0.00		Pending
25	Oct 1st, 2024	$18.00	$0.00		Pending
26	Nov 1st, 2024	$18.00	$0.00		Pending
27	Dec 1st, 2024	$18.00	$0.00		Pending
28	Jan 1st, 2025	$18.00	$0.00		Pending

Messages Timeline Exceptions Views7 Route Queries70 Mails Auth Gate Session Request

1.93s34.25MBGET donate/{application_id}

Booting (1.78s)
Application (1.86s)

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)27blade


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
donor
img_flag
donor_user
city_id
city_name
city_portfolio
payment
key

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	`donor`
20	`img_flag`
21	`donor_user`
22	`city_id`
23	`city_name`
24	`city_portfolio`
25	`payment`
26	`key`

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


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
donor
img_flag
donor_user
city_id
city_name
city_portfolio
payment
key
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	`donor`
20	`img_flag`
21	`donor_user`
22	`city_id`
23	`city_name`
24	`city_portfolio`
25	`payment`
26	`key`
27	`user`

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


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
donor
img_flag
donor_user
city_id
city_name
city_portfolio
payment
key

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	`donor`
20	`img_flag`
21	`donor_user`
22	`city_id`
23	`city_name`
24	`city_portfolio`
25	`payment`
26	`key`

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


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
donor
img_flag
donor_user
city_id
city_name
city_portfolio
payment
key
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	`donor`
20	`img_flag`
21	`donor_user`
22	`city_id`
23	`city_name`
24	`city_portfolio`
25	`payment`
26	`key`
27	`user`

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


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
donor
img_flag
donor_user
city_id
city_name
city_portfolio
payment
key
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	`donor`
20	`img_flag`
21	`donor_user`
22	`city_id`
23	`city_name`
24	`city_portfolio`
25	`payment`
26	`key`
27	`color_class`
28	`user`

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


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
donor
img_flag
donor_user
city_id
city_name
city_portfolio
payment
key

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	`donor`
20	`img_flag`
21	`donor_user`
22	`city_id`
23	`city_name`
24	`city_portfolio`
25	`payment`
26	`key`

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

70 statements were executed, 32 of which were duplicated, 38 unique1.63s

select * from `currencies`330μ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.02ms/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.62ms/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.41ms/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-26 06:55:01' and '2025-05-26 06:55:01' group by `categories`.`id`, `borrower`.`borrower_gender`

960μs/Modules/Application/Repositories/web/facade/Filters.php:201seedoutm_seedout_staging

Metadata
Bindings	0. 9 1. Live 2. Approved 3. borrower 4. 2025-04-26 06:55:01 5. 2025-05-26 06:55:01
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-26 06:55:01' and '2025-05-26 06:55:01' group by `categories`.`id`, `borrower`.`borrower_gender` order by `applications`.`created_at` desc

920μs/Modules/Application/Repositories/web/facade/Filters.php:205seedoutm_seedout_staging

Metadata
Bindings	0. 9 1. Live 2. Approved 3. borrower 4. 2025-04-26 06:55:01 5. 2025-05-26 06:55:01
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.57s/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'

840μs/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`

850μs/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` = '4477' and `applications`.`web_status` in ('Live', 'Success', 'Completed') and `applications`.`status` not in ('Rejected', 'Denied') limit 1

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

Metadata
Bindings	0. 4477 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 `borrower` where `borrower`.`id` in ('4534') and `borrower`.`deleted_at` is null510μs/Modules/Application/Http/Controllers/web/ProjectController.php:94seedoutm_seedout_staging

Metadata
Bindings	0. 4534
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 ('4477') and `donation_account`.`accountable_type` = 'application'

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

Metadata
Bindings	0. 4477 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 ('4477') and `views`.`viewable_type` = 'application'2.89ms/Modules/Application/Http/Controllers/web/ProjectController.php:94seedoutm_seedout_staging

Metadata
Bindings	0. 4477 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 ('4477')5.12ms/Modules/Application/Http/Controllers/web/ProjectController.php:94seedoutm_seedout_staging

Metadata
Bindings	0. 4477
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 ('4477') order by `expected_date` asc, `id` asc

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

Metadata
Bindings	0. 4477
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 1320μ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 1250μ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 1230μ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 1190μ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` = '12856' group by `from_account_id`

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

Metadata
Bindings	0. 2 1. 3 2. 9 3. 12856
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 * from `donation_account` where `donation_account`.`id` in ('5806')200μs/Modules/Cms/Repositories/web/facade/Account/AccountHelpers.php:234seedoutm_seedout_staging

Metadata
Bindings	0. 5806
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	18. /Modules/Cms/Repositories/web/facade/Account/AccountHelpers.php:234 20. /Modules/Application/Http/Controllers/web/ProjectController.php:101 21. /Modules/Application/Http/Controllers/web/ProjectController.php:101 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 `donor` where `donor`.`id` in ('2633') and `donor`.`deleted_at` is null260μs/Modules/Cms/Repositories/web/facade/Account/AccountHelpers.php:234seedoutm_seedout_staging

Metadata
Bindings	0. 2633
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	23. /Modules/Cms/Repositories/web/facade/Account/AccountHelpers.php:234 25. /Modules/Application/Http/Controllers/web/ProjectController.php:101 26. /Modules/Application/Http/Controllers/web/ProjectController.php:101 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 count(*) as aggregate from `views` where `viewable_id` = '4477' and `viewable_type` = 'application'2.79ms/app/helpers/statistics_helper.php:196seedoutm_seedout_staging

Metadata
Bindings	0. 4477 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-26 06:55:03' where `viewable_id` = '4477' and `viewable_type` = 'application'

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

Metadata
Bindings	0. 2025-04-26 06:55:03 1. 4477 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

370μ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')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: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')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: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

340μ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')140μ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')220μ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`170μ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.61ms/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` asc660μ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` = '4477' limit 1270μs/Modules/Application/Entities/ApplicationContent.php:58seedoutm_seedout_staging

Metadata
Bindings	0. 4477
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` = '4477' and `borrower_media`.`application_id` is not null limit 1

2.62ms/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:98seedoutm_seedout_staging

Metadata
Bindings	0. 4477
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:98 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` = '4477' limit 1250μs/Modules/Application/Entities/BorrowerMedia.php:89seedoutm_seedout_staging

Metadata
Bindings	0. 4477
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:99 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` = '4477' order by `expected_date` asc, `id` asc660μs/app/helpers/payment_plan.php:85seedoutm_seedout_staging

Metadata
Bindings	0. 4477
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 * from `borrower_payment_plan` where `application_id` = '4477' and `status` in ('Pending', 'Repaid', 'Approved') order by `expected_date` asc

670μs/Modules/Application/Http/Controllers/web/ProjectController.php:117seedoutm_seedout_staging

Metadata
Bindings	0. 4477 1. Pending 2. Repaid 3. Approved
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /Modules/Application/Http/Controllers/web/ProjectController.php:117 27. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 37. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 80. /app/Http/Middleware/HttpsProtocol.php:13 85. /app/Http/Middleware/InitiateTheme.php:19 99. /public/index.php:54

select * from `borrower_media` where `borrower_media`.`borrower_id` = '4534' and `borrower_media`.`borrower_id` is not null limit 1

220μsview::Application::web.project_detail:101seedoutm_seedout_staging

Metadata
Bindings	0. 4534
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. view::Application::web.project_detail:101 24. /vendor/symfony/http-foundation/Response.php:201 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 `applications` where `applications`.`id` = '4477' limit 1250μs/Modules/Application/Entities/BorrowerMedia.php:34seedoutm_seedout_staging

Metadata
Bindings	0. 4477
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:34 22. view::Application::web.project_detail:101 29. /vendor/symfony/http-foundation/Response.php:201 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 sum(amount) as total from `donation_account_transactions` where `transaction_type_id` in ('2', '3', '9') and (`from_account_id` in ('12856') or `to_account_id` in ('12856')) limit 1

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

Metadata
Bindings	0. 2 1. 3 2. 9 3. 12856 4. 12856
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 ('12856') or `to_account_id` in ('12856')) limit 1

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

Metadata
Bindings	0. 2 1. 9 2. 12856 3. 12856
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 ('12856') or `to_account_id` in ('12856')) limit 1

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

Metadata
Bindings	0. 5 1. 13 2. 14 3. 12856 4. 12856
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 ('12856') or `to_account_id` in ('12856')) limit 1

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

Metadata
Bindings	0. 2 1. 9 2. 12856 3. 12856
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 ('12856') or `to_account_id` in ('12856')) limit 1

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

Metadata
Bindings	0. 2 1. 9 2. 12856 3. 12856
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 `branches` where `branches`.`id` = '20' and `branches`.`deleted_at` is null limit 1210μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_staging

Metadata
Bindings	0. 20
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:134 22. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:144 27. view::Application::web.project_detail:156 34. /vendor/symfony/http-foundation/Response.php:201 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 `cities` where `id` = '2177387' limit 1160μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 2177387
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')220μ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` = '2177387' limit 1140μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 2177387
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')250μ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` = '4477' and `viewable_type` = 'application' limit 11.91ms/app/helpers/statistics_helper.php:207seedoutm_seedout_staging

Metadata
Bindings	0. 4477 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 ('12856') or `to_account_id` in ('12856')) limit 1

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

Metadata
Bindings	0. 2 1. 3 2. 9 3. 12856 4. 12856
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 `donation_account` where `donation_account`.`id` = '5806' limit 1150μs/Modules/Cms/Repositories/web/facade/Account/AccountHelpers.php:96seedoutm_seedout_staging

Metadata
Bindings	0. 5806
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	18. /Modules/Cms/Repositories/web/facade/Account/AccountHelpers.php:96 19. /Modules/Cms/Repositories/web/facade/Account/AccountHelpers.php:96 21. view::Application::web.project_detail:252 22. view::Application::web.project_detail:252 29. /vendor/symfony/http-foundation/Response.php:201 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 `donor` where `donor`.`id` = '2633' and `donor`.`deleted_at` is null limit 1190μs/Modules/Cms/Repositories/web/facade/Account/AccountHelpers.php:106seedoutm_seedout_staging

Metadata
Bindings	0. 2633
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/Cms/Repositories/web/facade/Account/AccountHelpers.php:106 19. view::Application::web.project_detail:252 20. view::Application::web.project_detail:252 27. /vendor/symfony/http-foundation/Response.php:201 41. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 51. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 94. /app/Http/Middleware/HttpsProtocol.php:13 99. /app/Http/Middleware/InitiateTheme.php:19 113. /public/index.php:54

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

Metadata
Bindings	0. 2177387
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')170μ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

160μ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` = '2177387' limit 1120μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 2177387
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