Seed Out Empowering the People

Messages Timeline Exceptions Views7 Route Queries45 Mails Auth Gate Session Request

2.22s33.5MBGET donor/profile/{id}

Booting (2.07s)
Application (2.16s)

7 templates were rendered

user::web.user.donor_profile (Modules/User/Resources/views/web/user/donor_profile.blade.php)7blade
Params
0
donor
1
borrowersOfDonors
2
city_chart
3
gender_chart
4
category_chart
5
type
6
last_login_time

Params
0	`donor`
1	`borrowersOfDonors`
2	`city_chart`
3	`gender_chart`
4	`category_chart`
5	`type`
6	`last_login_time`

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
donor
borrowersOfDonors
city_chart
gender_chart
category_chart
type
last_login_time
data
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	`donor`
14	`borrowersOfDonors`
15	`city_chart`
16	`gender_chart`
17	`category_chart`
18	`type`
19	`last_login_time`
20	`data`
21	`key`

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
donor
borrowersOfDonors
city_chart
gender_chart
category_chart
type
last_login_time
data
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	`donor`
14	`borrowersOfDonors`
15	`city_chart`
16	`gender_chart`
17	`category_chart`
18	`type`
19	`last_login_time`
20	`data`
21	`key`
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
donor
borrowersOfDonors
city_chart
gender_chart
category_chart
type
last_login_time
data
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	`donor`
14	`borrowersOfDonors`
15	`city_chart`
16	`gender_chart`
17	`category_chart`
18	`type`
19	`last_login_time`
20	`data`
21	`key`

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
donor
borrowersOfDonors
city_chart
gender_chart
category_chart
type
last_login_time
data
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	`donor`
14	`borrowersOfDonors`
15	`city_chart`
16	`gender_chart`
17	`category_chart`
18	`type`
19	`last_login_time`
20	`data`
21	`key`
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
donor
borrowersOfDonors
city_chart
gender_chart
category_chart
type
last_login_time
data
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	`donor`
14	`borrowersOfDonors`
15	`city_chart`
16	`gender_chart`
17	`category_chart`
18	`type`
19	`last_login_time`
20	`data`
21	`key`
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
donor
borrowersOfDonors
city_chart
gender_chart
category_chart
type
last_login_time
data
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	`donor`
14	`borrowersOfDonors`
15	`city_chart`
16	`gender_chart`
17	`category_chart`
18	`type`
19	`last_login_time`
20	`data`
21	`key`

uri: GET donor/profile/{id}
middleware: web, checkZone
as: web.donor.donor_profile
controller: Modules\User\Http\Controllers\Web\UserController@donorProfile
namespace: Modules\User\Http\Controllers\Web
prefix: /donor
where
file: Modules/User/Http/Controllers/Web/UserController.php:397-416

45 statements were executed, 10 of which were duplicated, 35 unique1.81s

select * from `currencies`880μ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.73ms/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.45ms/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-03-03 13:09:38' and '2025-04-02 13:09:38' 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-03-03 13:09:38 5. 2025-04-02 13:09:38
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-03-03 13:09:38' and '2025-04-02 13:09:38' group by `categories`.`id`, `borrower`.`borrower_gender` order by `applications`.`created_at` desc

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

Metadata
Bindings	0. 9 1. Live 2. Approved 3. borrower 4. 2025-03-03 13:09:38 5. 2025-04-02 13:09:38
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.76s/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'

1.55ms/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.55ms/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 `donation_account` where `donation_account`.`id` = '8131' limit 1300μs/Modules/User/Http/Controllers/Web/UserController.php:399seedoutm_seedout_staging

Metadata
Bindings	0. 8131
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	13. /Modules/User/Http/Controllers/Web/UserController.php:399 29. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 39. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 82. /app/Http/Middleware/HttpsProtocol.php:13 87. /app/Http/Middleware/InitiateTheme.php:19 101. /public/index.php:54

select * from `donation_cart_guest` where `donation_cart_guest`.`id` in ('351')210μs/Modules/User/Http/Controllers/Web/UserController.php:399seedoutm_seedout_staging

Metadata
Bindings	0. 351
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	18. /Modules/User/Http/Controllers/Web/UserController.php:399 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 count(*) as aggregate from `views` where `viewable_id` = '351' and `viewable_type` = 'guest'3.07ms/app/helpers/statistics_helper.php:196seedoutm_seedout_staging

Metadata
Bindings	0. 351 1. guest
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-03-03 13:09:40' where `viewable_id` = '351' and `viewable_type` = 'guest'

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

Metadata
Bindings	0. 2025-03-03 13:09:40 1. 351 2. guest
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 count(*) as aggregate from `donation_account_transactions` where `transaction_type_id` in ('2', '3', '9') and `from_account_id` = '8131' and `to_account_id` not in ('1', '2', '3', '1061', '7000', '5760', '14258', '15089') group by `to_account_id`

430μs/Modules/User/Http/Controllers/Web/UserController.php:409seedoutm_seedout_staging

Metadata
Bindings	0. 2 1. 3 2. 9 3. 8131 4. 1 5. 2 6. 3 7. 1061 8. 7000 9. 5760 10. 14258 11. 15089
Backtrace	11. /Modules/User/Http/Controllers/Web/UserController.php:409 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 *,to_account_id as borrower_account_id,sum(CASE transaction_type_id WHEN 2 THEN  amount ELSE 0 END) as donated from `donation_account_transactions` where `transaction_type_id` in ('2', '3', '9') and `from_account_id` = '8131' and `to_account_id` not in ('1', '2', '3', '1061', '7000', '5760', '14258', '15089') group by `to_account_id` limit 30 offset 0

660μs/Modules/User/Http/Controllers/Web/UserController.php:409seedoutm_seedout_staging

Metadata
Bindings	0. 2 1. 3 2. 9 3. 8131 4. 1 5. 2 6. 3 7. 1061 8. 7000 9. 5760 10. 14258 11. 15089
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/User/Http/Controllers/Web/UserController.php:409 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 donated, to_account_id from `donation_account_transactions` where `transaction_type_id` in ('2', '3', '9') and `to_account_id` not in ('1', '2', '3', '1061', '7000', '5760', '14258', '15089') and `from_account_id` = '8131' group by `to_account_id`

390μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209seedoutm_seedout_staging

Metadata
Bindings	0. 2 1. 3 2. 9 3. 1 4. 2 5. 3 6. 1061 7. 7000 8. 5760 9. 14258 10. 15089 11. 8131
Backtrace	11. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209 12. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:36 14. /Modules/User/Http/Controllers/Web/UserController.php:410 15. /Modules/User/Http/Controllers/Web/UserController.php:410 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

Metadata

Bindings

0. 2
1. 3
2. 9
3. 1
4. 2
5. 3
6. 1061
7. 7000
8. 5760
9. 14258
10. 15089
11. 8131

Backtrace

11. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209
12. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:36
14. /Modules/User/Http/Controllers/Web/UserController.php:410
15. /Modules/User/Http/Controllers/Web/UserController.php:410
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 `donation_account` where `donation_account`.`id` in ('7449')250μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209seedoutm_seedout_staging

Metadata
Bindings	0. 7449
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	18. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209 19. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:36 21. /Modules/User/Http/Controllers/Web/UserController.php:410 22. /Modules/User/Http/Controllers/Web/UserController.php:410 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` in ('3064') and `applications`.`deleted_at` is null420μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209seedoutm_seedout_staging

Metadata
Bindings	0. 3064
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	23. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209 24. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:36 26. /Modules/User/Http/Controllers/Web/UserController.php:410 27. /Modules/User/Http/Controllers/Web/UserController.php:410 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` where `borrower`.`id` in ('3119') and `borrower`.`deleted_at` is null680μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209seedoutm_seedout_staging

Metadata
Bindings	0. 3119
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	28. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:209 29. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:36 31. /Modules/User/Http/Controllers/Web/UserController.php:410 32. /Modules/User/Http/Controllers/Web/UserController.php:410 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 `branches` where `branches`.`id` = '21' and `branches`.`deleted_at` is null limit 1260μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_staging

Metadata
Bindings	0. 21
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/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:226 23. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:36 25. /Modules/User/Http/Controllers/Web/UserController.php:410 26. /Modules/User/Http/Controllers/Web/UserController.php:410 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 `cities` where `cities`.`id` = '3150684' limit 1210μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:59seedoutm_seedout_staging

Metadata
Bindings	0. 3150684
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/DonorCharts/DonorCharts.php:59 19. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:59 21. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:60 22. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:37 24. /Modules/User/Http/Controllers/Web/UserController.php:410 25. /Modules/User/Http/Controllers/Web/UserController.php:410 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 `amount`, `created_at` from `donation_account_transactions` where `from_account_id` = '8131' and `transaction_type_id` in ('2', '3', '9') order by `created_at` asc

300μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 8131 1. 2 2. 3 3. 9
Backtrace	11. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:73 12. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:106 13. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:40 15. /Modules/User/Http/Controllers/Web/UserController.php:410 16. /Modules/User/Http/Controllers/Web/UserController.php:410 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

Metadata

Bindings

0. 8131
1. 2
2. 3
3. 9

Backtrace

11. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:73
12. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:106
13. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:40
15. /Modules/User/Http/Controllers/Web/UserController.php:410
16. /Modules/User/Http/Controllers/Web/UserController.php:410
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 `amount`, `created_at` from `donation_account_transactions` where `to_account_id` = '8131' and `transaction_type_id` in ('5', '13', '14') order by `created_at` asc

580μs/Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:76seedoutm_seedout_staging

Metadata
Bindings	0. 8131 1. 5 2. 13 3. 14
Backtrace	11. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:76 12. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:106 13. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:40 15. /Modules/User/Http/Controllers/Web/UserController.php:410 16. /Modules/User/Http/Controllers/Web/UserController.php:410 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

Metadata

Bindings

0. 8131
1. 5
2. 13
3. 14

Backtrace

11. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:76
12. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:106
13. /Modules/Cms/Repositories/web/facade/DonorCharts/DonorCharts.php:40
15. /Modules/User/Http/Controllers/Web/UserController.php:410
16. /Modules/User/Http/Controllers/Web/UserController.php:410
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 `views` where `viewable_id` = '351' and `viewable_type` = 'guest' limit 12.37ms/app/helpers/statistics_helper.php:207seedoutm_seedout_staging

Metadata
Bindings	0. 351 1. guest
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 * from `donation_account` where `donation_account`.`id` = '7449' limit 1280μsview::user::web.user.donor_profile:153seedoutm_seedout_staging

Metadata
Bindings	0. 7449
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::user::web.user.donor_profile:153 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` = '3064' and `applications`.`deleted_at` is null limit 1400μsview::user::web.user.donor_profile:153seedoutm_seedout_staging

Metadata
Bindings	0. 3064
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::user::web.user.donor_profile:153 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 `borrower_media` where `borrower_media`.`application_id` = '3064' and `borrower_media`.`application_id` is not null limit 1

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

Metadata
Bindings	0. 3064
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. view::user::web.user.donor_profile:154 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 `applications` where `applications`.`id` = '3064' limit 1380μs/Modules/Application/Entities/BorrowerMedia.php:89seedoutm_seedout_staging

Metadata
Bindings	0. 3064
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. view::user::web.user.donor_profile:154 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 `borrower` where `borrower`.`id` = '3119' and `borrower`.`deleted_at` is null limit 1630μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:22seedoutm_seedout_staging

Metadata
Bindings	0. 3119
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:22 22. view::user::web.user.donor_profile:155 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 `donation_account` where `donation_account`.`accountable_id` = '3064' and `donation_account`.`accountable_id` is not null and `donation_account`.`accountable_type` = 'application' limit 1

260μs/Modules/Application/Entities/Traits/ApplicationDonationTrait.php:97seedoutm_seedout_staging

Metadata
Bindings	0. 3064 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	17. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:97 22. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:102 27. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:124 32. view::user::web.user.donor_profile:158 39. /vendor/symfony/http-foundation/Response.php:201 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 `donation_account` where `account_no` = '5abfd47765e1a' limit 1270μ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/Entities/Traits/ApplicationDonationTrait.php:97 22. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:97 27. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:102 32. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:124 37. view::user::web.user.donor_profile:158 44. /vendor/symfony/http-foundation/Response.php:201 58. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 68. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 111. /app/Http/Middleware/HttpsProtocol.php:13 116. /app/Http/Middleware/InitiateTheme.php:19 130. /public/index.php:54

select * from `donation_account` where `account_no` = '5abfd47765e1c' limit 1240μ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/Entities/Traits/ApplicationDonationTrait.php:97 22. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:97 27. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:102 32. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:124 37. view::user::web.user.donor_profile:158 44. /vendor/symfony/http-foundation/Response.php:201 58. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 68. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 111. /app/Http/Middleware/HttpsProtocol.php:13 116. /app/Http/Middleware/InitiateTheme.php:19 130. /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/Entities/Traits/ApplicationDonationTrait.php:97 22. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:97 27. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:102 32. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:124 37. view::user::web.user.donor_profile:158 44. /vendor/symfony/http-foundation/Response.php:201 58. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 68. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 111. /app/Http/Middleware/HttpsProtocol.php:13 116. /app/Http/Middleware/InitiateTheme.php:19 130. /public/index.php:54

select * from `donation_account` where `account_no` = '5abfd45565e1b' limit 1230μ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/Entities/Traits/ApplicationDonationTrait.php:97 22. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:97 27. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:102 32. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:124 37. view::user::web.user.donor_profile:158 44. /vendor/symfony/http-foundation/Response.php:201 58. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 68. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 111. /app/Http/Middleware/HttpsProtocol.php:13 116. /app/Http/Middleware/InitiateTheme.php:19 130. /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 ('7449') or `to_account_id` in ('7449')) limit 1

1.13ms/Modules/Cms/Repositories/web/facade/Account/AccountReporting.php:679seedoutm_seedout_staging

Metadata
Bindings	0. 2 1. 9 2. 7449 3. 7449
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::user::web.user.donor_profile:158 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` = '21' and `branches`.`deleted_at` is null limit 1250μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_staging

Metadata
Bindings	0. 21
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::user::web.user.donor_profile:160 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` = '3150684' limit 1190μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 3150684
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::user::web.user.donor_profile:160 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')370μ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::user::web.user.donor_profile:160 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` = '3150684' limit 1210μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 3150684
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::user::web.user.donor_profile:160 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')350μ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::user::web.user.donor_profile:160 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` = '3150684' limit 1190μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 3150684
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::user::web.user.donor_profile:160 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')360μ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::user::web.user.donor_profile:160 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` = '3150684' limit 1190μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 3150684
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::user::web.user.donor_profile:160 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')360μ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::user::web.user.donor_profile:160 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 `cms_menu` order by `order` asc1.26ms/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:107
14. /Modules/Cms/Repositories/web/facade/cms.php:326
16. view::partials.web.header:139
17. view::partials.web.header:139
23. view::layouts.web.master:109
29. view::user::web.user.donor_profile:406
36. /vendor/symfony/http-foundation/Response.php:201
50. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22
60. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33
103. /app/Http/Middleware/HttpsProtocol.php:13
108. /app/Http/Middleware/InitiateTheme.php:19
122. /public/index.php:54

users: array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
web: array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
api: array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]

currency: USD
_token: PKieT1RIFOBTewvJk35C8CRwTwPj0hZC6hMHul6f
_previous: array:1 [ "url" => "https://www.seedout.me/donor/profile/8131" ]
PHPDEBUGBAR_STACK_DATA: []

format: html
content_type: text/html; charset=UTF-8
status_text: OK
status_code: 200
request_query: []
request_request: []
request_headers: array:20 [ "host" => array:1 [ 0 => "www.seedout.me" ] "x-forwarded-for" => array:1 [ ...
request_server: array:67 [ "TZ" => "Asia/Karachi" "REDIRECT_REDIRECT_UNIQUE_ID" => "Z8VjwgwDqnjuEOIsVtvqrgAAAAc"...
request_cookies: []
response_headers: array:4 [ "cache-control" => array:1 [ 0 => "no-cache" ] "content-type" => array:1 [ 0...
path_info: /donor/profile/8131
session_attributes: array:4 [ "currency" => "USD" "_token" => "PKieT1RIFOBTewvJk35C8CRwTwPj0hZC6hMHul6f" "_previou...

Syed irfan

Syed irfan's Donations

Donation in City

Donation by Gender

Donation by Sector

Seed Out is tax exempted under Income Tax Ordinance section 2(36)c.

Get to know us

Syed irfan

Syed irfan's Donations

Donation in City

Donation by Gender

Donation by Sector