Seed Out Empowering the People

Messages Timeline Exceptions Views8 Route Queries96 Mails Auth Gate Session Request

2.63s36MBGET blog/post/{slug}

Booting (1.8s)
Application (2.57s)

8 templates were rendered

cms::web.blog.post (Modules/Cms/Resources/views/web/blog/post.blade.php)6blade
Params
0
post
1
categories
2
relatedPosts
3
category
4
rPosts
5
homeApps

Params
0	`post`
1	`categories`
2	`relatedPosts`
3	`category`
4	`rPosts`
5	`homeApps`

cms::web.blog.partials.post-right-side-bar (Modules/Cms/Resources/views/web/blog/partials/post-right-side-bar.blade.php)21blade


obLevel
__env
app
request_protocol
meta_title
meta_keywords
meta_description
og_title
og_description
og_type
og_image
og_site_name
errors
post
categories
relatedPosts
category
rPosts
homeApps
whatsapshare
relatedPost

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	`post`
14	`categories`
15	`relatedPosts`
16	`category`
17	`rPosts`
18	`homeApps`
19	`whatsapshare`
20	`relatedPost`

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


obLevel
__env
app
request_protocol
meta_title
meta_keywords
meta_description
og_title
og_description
og_type
og_image
og_site_name
errors
post
categories
relatedPosts
category
rPosts
homeApps
whatsapshare
relatedPost

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	`post`
14	`categories`
15	`relatedPosts`
16	`category`
17	`rPosts`
18	`homeApps`
19	`whatsapshare`
20	`relatedPost`

partials.web.head_styles (resources/themes/metronic/partials/web/head_styles.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
post
categories
relatedPosts
category
rPosts
homeApps
whatsapshare
relatedPost
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	`post`
14	`categories`
15	`relatedPosts`
16	`category`
17	`rPosts`
18	`homeApps`
19	`whatsapshare`
20	`relatedPost`
21	`user`

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


obLevel
__env
app
request_protocol
meta_title
meta_keywords
meta_description
og_title
og_description
og_type
og_image
og_site_name
errors
post
categories
relatedPosts
category
rPosts
homeApps
whatsapshare
relatedPost

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	`post`
14	`categories`
15	`relatedPosts`
16	`category`
17	`rPosts`
18	`homeApps`
19	`whatsapshare`
20	`relatedPost`

partials.web.header (resources/themes/metronic/partials/web/header.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
post
categories
relatedPosts
category
rPosts
homeApps
whatsapshare
relatedPost
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	`post`
14	`categories`
15	`relatedPosts`
16	`category`
17	`rPosts`
18	`homeApps`
19	`whatsapshare`
20	`relatedPost`
21	`user`

partials.web.footer (resources/themes/metronic/partials/web/footer.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
post
categories
relatedPosts
category
rPosts
homeApps
whatsapshare
relatedPost
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	`post`
14	`categories`
15	`relatedPosts`
16	`category`
17	`rPosts`
18	`homeApps`
19	`whatsapshare`
20	`relatedPost`
21	`color_class`
22	`user`

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


obLevel
__env
app
request_protocol
meta_title
meta_keywords
meta_description
og_title
og_description
og_type
og_image
og_site_name
errors
post
categories
relatedPosts
category
rPosts
homeApps
whatsapshare
relatedPost

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	`post`
14	`categories`
15	`relatedPosts`
16	`category`
17	`rPosts`
18	`homeApps`
19	`whatsapshare`
20	`relatedPost`

uri: GET blog/post/{slug}
middleware: web, checkZone
as: cms.blog.post
controller: Modules\Cms\Http\Controllers\Web\BlogController@post
namespace: Modules\Cms\Http\Controllers\Web
prefix: /blog
where
file: Modules/Cms/Http/Controllers/Web/BlogController.php:58-75

96 statements were executed, 43 of which were duplicated, 53 unique2.28s

select * from `currencies`180μ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'

940μs/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.66ms/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.44ms/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-02 09:13:15' and '2025-04-01 09:13:15' group by `categories`.`id`, `borrower`.`borrower_gender`

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

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

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

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

940μ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`

920μ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 `blog_categories` where exists (select * from `blog_posts` where `blog_posts`.`category_id` = `blog_categories`.`id`) and `status` = '1' order by `created_at` desc

420μs/Modules/Cms/Repositories/web/facade/Blog/Blog.php:96seedoutm_seedout_staging

Metadata
Bindings	0. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /Modules/Cms/Repositories/web/facade/Blog/Blog.php:96 13. /Modules/Cms/Entities/BlogPosts.php:67 14. /Modules/Cms/Entities/BlogPosts.php:67 18. /Modules/Cms/Repositories/web/facade/Blog/Blog.php:66 19. /Modules/Cms/Repositories/web/facade/Blog/Blog.php:66 21. /Modules/Cms/Http/Controllers/Web/BlogController.php:60 22. /Modules/Cms/Http/Controllers/Web/BlogController.php:60 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 `blog_posts` where `published` = '1' and `category_id` in ('8', '7', '6', '5', '4')2.34ms/Modules/Cms/Repositories/web/facade/Blog/Blog.php:66seedoutm_seedout_staging

Metadata
Bindings	0. 1 1. 8 2. 7 3. 6 4. 5 5. 4
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /Modules/Cms/Repositories/web/facade/Blog/Blog.php:66 13. /Modules/Cms/Http/Controllers/Web/BlogController.php:60 14. /Modules/Cms/Http/Controllers/Web/BlogController.php:60 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 `cms_menu` order by `order` asc720μ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/Cms/Http/Controllers/Web/BlogController.php:67
16. /Modules/Cms/Http/Controllers/Web/BlogController.php:67
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 `blog_categories` where exists (select * from `blog_posts` where `blog_posts`.`category_id` = `blog_categories`.`id`) and `status` = '1' order by `created_at` desc

260μs/Modules/Cms/Repositories/web/facade/Blog/Blog.php:96seedoutm_seedout_staging

Metadata
Bindings	0. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /Modules/Cms/Repositories/web/facade/Blog/Blog.php:96 13. /Modules/Cms/Entities/BlogPosts.php:67 14. /Modules/Cms/Entities/BlogPosts.php:67 18. /Modules/Cms/Repositories/web/facade/Blog/Blog.php:25 19. /Modules/Cms/Repositories/web/facade/Blog/Blog.php:25 21. /Modules/Cms/Http/Controllers/Web/BlogController.php:68 22. /Modules/Cms/Http/Controllers/Web/BlogController.php:68 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 `blog_posts` where `category_id` in ('8', '7', '6', '5', '4') and `published` = '1' order by `created_at` desc

2.18ms/Modules/Cms/Repositories/web/facade/Blog/Blog.php:25seedoutm_seedout_staging

Metadata
Bindings	0. 8 1. 7 2. 6 3. 5 4. 4 5. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /Modules/Cms/Repositories/web/facade/Blog/Blog.php:25 13. /Modules/Cms/Http/Controllers/Web/BlogController.php:68 14. /Modules/Cms/Http/Controllers/Web/BlogController.php:68 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 `blog_categories` where exists (select * from `blog_posts` where `blog_posts`.`category_id` = `blog_categories`.`id`) and `status` = '1' order by `created_at` desc

260μs/Modules/Cms/Repositories/web/facade/Blog/Blog.php:96seedoutm_seedout_staging

Metadata
Bindings	0. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /Modules/Cms/Repositories/web/facade/Blog/Blog.php:96 13. /Modules/Cms/Http/Controllers/Web/BlogController.php:70 14. /Modules/Cms/Http/Controllers/Web/BlogController.php:70 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 `blog_categories` where exists (select * from `blog_posts` where `blog_posts`.`category_id` = `blog_categories`.`id`) and `status` = '1' order by `created_at` desc

210μs/Modules/Cms/Repositories/web/facade/Blog/Blog.php:96seedoutm_seedout_staging

Metadata
Bindings	0. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /Modules/Cms/Repositories/web/facade/Blog/Blog.php:96 13. /Modules/Cms/Entities/BlogPosts.php:67 14. /Modules/Cms/Entities/BlogPosts.php:67 18. /Modules/Cms/Repositories/web/facade/Blog/Blog.php:54 19. /Modules/Cms/Repositories/web/facade/Blog/Blog.php:54 21. /Modules/Cms/Http/Controllers/Web/BlogController.php:71 22. /Modules/Cms/Http/Controllers/Web/BlogController.php:71 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 `blog_posts` where `category_id` in ('8', '7', '6', '5', '4') and `published` = '1' and `category_id` = '8' and `id` != '129' order by `created_at` desc

310μs/Modules/Cms/Repositories/web/facade/Blog/Blog.php:54seedoutm_seedout_staging

Metadata
Bindings	0. 8 1. 7 2. 6 3. 5 4. 4 5. 1 6. 8 7. 129
Hints	Use `SELECT *` only if you need all columns from table The `!=` operator is not standard. Use the `<>` operator to test for inequality instead.
Backtrace	11. /Modules/Cms/Repositories/web/facade/Blog/Blog.php:54 13. /Modules/Cms/Http/Controllers/Web/BlogController.php:71 14. /Modules/Cms/Http/Controllers/Web/BlogController.php:71 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 `blog_categories` where exists (select * from `blog_posts` where `blog_posts`.`category_id` = `blog_categories`.`id`) and `status` = '1' order by `created_at` desc

220μs/Modules/Cms/Repositories/web/facade/Blog/Blog.php:96seedoutm_seedout_staging

Metadata
Bindings	0. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	11. /Modules/Cms/Repositories/web/facade/Blog/Blog.php:96 13. /Modules/Cms/Http/Controllers/Web/BlogController.php:72 14. /Modules/Cms/Http/Controllers/Web/BlogController.php:72 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 `applications` where `applications`.`current_process_flow_id` = '9' and `applications`.`web_status` = 'Live' and `applications`.`status` = 'Approved' and `applications`.`deleted_at` is null and exists (select * from `application_contents` where `application_contents`.`application_id` = `applications`.`id`) order by RAND() limit 5

630.75ms/Modules/Application/Repositories/web/facade/Project.php:235seedoutm_seedout_staging

Metadata
Bindings	0. 9 1. Live 2. Approved
Hints	Use `SELECT *` only if you need all columns from table `ORDER BY RAND()` is slow, try to avoid if you can. You can read this or this
Backtrace	11. /Modules/Application/Repositories/web/facade/Project.php:235 12. /Modules/Application/Repositories/web/facade/Project.php:214 14. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 15. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `application_contents` where `application_contents`.`application_id` = '5709' and `application_contents`.`application_id` is not null limit 1

4.71ms/Modules/Application/Repositories/web/facade/Project.php:244seedoutm_seedout_staging

Metadata
Bindings	0. 5709
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/Repositories/web/facade/Project.php:244 18. /Modules/Application/Repositories/web/facade/Project.php:214 20. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 21. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `applications` where `applications`.`id` = '5709' limit 1340μs/Modules/Application/Entities/ApplicationContent.php:58seedoutm_seedout_staging

Metadata
Bindings	0. 5709
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/Application/Repositories/web/facade/Project.php:245 23. /Modules/Application/Repositories/web/facade/Project.php:214 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 26. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `students` where `students`.`id` = '2' and `students`.`deleted_at` is null limit 1300μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:22seedoutm_seedout_staging

Metadata
Bindings	0. 2
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. /Modules/Application/Repositories/web/facade/Project.php:246 23. /Modules/Application/Repositories/web/facade/Project.php:214 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 26. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `borrower_media` where `borrower_media`.`application_id` = '5709' and `borrower_media`.`application_id` is not null limit 1

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

Metadata
Bindings	0. 5709
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	17. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:104 22. /Modules/Application/Repositories/web/facade/Project.php:247 23. /Modules/Application/Repositories/web/facade/Project.php:214 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 26. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `donation_account` where `donation_account`.`accountable_id` = '5709' and `donation_account`.`accountable_id` is not null and `donation_account`.`accountable_type` = 'application' limit 1

240μs/Modules/Application/Entities/Traits/ApplicationDonationTrait.php:148seedoutm_seedout_staging

Metadata
Bindings	0. 5709 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:148 22. /Modules/Application/Repositories/web/facade/Project.php:248 23. /Modules/Application/Repositories/web/facade/Project.php:214 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 26. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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_account_id` from `donation_account_transactions` where `transaction_type_id` in ('2', '3', '9') and `to_account_id` = '21679' group by `from_account_id`

280μs/Modules/Application/Entities/Traits/ApplicationDonationTrait.php:148seedoutm_seedout_staging

Metadata
Bindings	0. 2 1. 3 2. 9 3. 21679
Backtrace	11. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:148 16. /Modules/Application/Repositories/web/facade/Project.php:248 17. /Modules/Application/Repositories/web/facade/Project.php:214 19. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 20. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 36. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 46. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 89. /app/Http/Middleware/HttpsProtocol.php:13 94. /app/Http/Middleware/InitiateTheme.php:19 108. /public/index.php:54

Metadata

Bindings

0. 2
1. 3
2. 9
3. 21679

Backtrace

11. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:148
16. /Modules/Application/Repositories/web/facade/Project.php:248
17. /Modules/Application/Repositories/web/facade/Project.php:214
19. /Modules/Cms/Http/Controllers/Web/BlogController.php:73
20. /Modules/Cms/Http/Controllers/Web/BlogController.php:73
36. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22
46. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33
89. /app/Http/Middleware/HttpsProtocol.php:13
94. /app/Http/Middleware/InitiateTheme.php:19
108. /public/index.php:54

select * from `donation_account` where `account_no` = '5abfd47765e1a' limit 1250μ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. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:79 42. /Modules/Application/Repositories/web/facade/Project.php:249 43. /Modules/Application/Repositories/web/facade/Project.php:214 45. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 46. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 62. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 72. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 115. /app/Http/Middleware/HttpsProtocol.php:13 120. /app/Http/Middleware/InitiateTheme.php:19 134. /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. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:79 42. /Modules/Application/Repositories/web/facade/Project.php:249 43. /Modules/Application/Repositories/web/facade/Project.php:214 45. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 46. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 62. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 72. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 115. /app/Http/Middleware/HttpsProtocol.php:13 120. /app/Http/Middleware/InitiateTheme.php:19 134. /public/index.php:54

select * from `donation_account` where `account_no` = '5abfd47765e1b' limit 1170μ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. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:79 42. /Modules/Application/Repositories/web/facade/Project.php:249 43. /Modules/Application/Repositories/web/facade/Project.php:214 45. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 46. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 62. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 72. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 115. /app/Http/Middleware/HttpsProtocol.php:13 120. /app/Http/Middleware/InitiateTheme.php:19 134. /public/index.php:54

select * from `donation_account` where `account_no` = '5abfd45565e1b' limit 1170μ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. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:79 42. /Modules/Application/Repositories/web/facade/Project.php:249 43. /Modules/Application/Repositories/web/facade/Project.php:214 45. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 46. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 62. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 72. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 115. /app/Http/Middleware/HttpsProtocol.php:13 120. /app/Http/Middleware/InitiateTheme.php:19 134. /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 ('21679') or `to_account_id` in ('21679')) limit 1

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

Metadata
Bindings	0. 2 1. 9 2. 21679 3. 21679
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. /Modules/Application/Repositories/web/facade/Project.php:249 37. /Modules/Application/Repositories/web/facade/Project.php:214 39. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 40. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 56. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 66. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 109. /app/Http/Middleware/HttpsProtocol.php:13 114. /app/Http/Middleware/InitiateTheme.php:19 128. /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 ('21679') or `to_account_id` in ('21679')) limit 1

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

Metadata
Bindings	0. 2 1. 9 2. 21679 3. 21679
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/Repositories/web/facade/Project.php:251 32. /Modules/Application/Repositories/web/facade/Project.php:214 34. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 35. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 51. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 61. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 104. /app/Http/Middleware/HttpsProtocol.php:13 109. /app/Http/Middleware/InitiateTheme.php:19 123. /public/index.php:54

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

Metadata
Bindings	0. 2189673
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. /Modules/Application/Repositories/web/facade/Project.php:254 22. /Modules/Application/Repositories/web/facade/Project.php:214 24. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `countries` where `countries`.`id` in ('168')290μ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. /Modules/Application/Repositories/web/facade/Project.php:254 29. /Modules/Application/Repositories/web/facade/Project.php:214 31. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 32. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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` = '2189673' limit 1150μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 2189673
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. /Modules/Application/Repositories/web/facade/Project.php:255 22. /Modules/Application/Repositories/web/facade/Project.php:214 24. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `countries` where `countries`.`id` in ('168')230μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 168
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /Modules/Application/Repositories/web/facade/CountriesFilter.php:73 20. /Modules/Application/Repositories/web/facade/CountriesFilter.php:135 22. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 23. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 28. /Modules/Application/Repositories/web/facade/Project.php:255 29. /Modules/Application/Repositories/web/facade/Project.php:214 31. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 32. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `views` where `views`.`viewable_id` = '5709' and `views`.`viewable_id` is not null and `views`.`viewable_type` = 'application' limit 1

2.83ms/Modules/Application/Repositories/web/facade/Project.php:257seedoutm_seedout_staging

Metadata
Bindings	0. 5709 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/Repositories/web/facade/Project.php:257 18. /Modules/Application/Repositories/web/facade/Project.php:214 20. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 21. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `application_contents` where `application_contents`.`application_id` = '5382' and `application_contents`.`application_id` is not null limit 1

4.47ms/Modules/Application/Repositories/web/facade/Project.php:244seedoutm_seedout_staging

Metadata
Bindings	0. 5382
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/Repositories/web/facade/Project.php:244 18. /Modules/Application/Repositories/web/facade/Project.php:214 20. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 21. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `applications` where `applications`.`id` = '5382' limit 1190μs/Modules/Application/Entities/ApplicationContent.php:58seedoutm_seedout_staging

Metadata
Bindings	0. 5382
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/Application/Repositories/web/facade/Project.php:245 23. /Modules/Application/Repositories/web/facade/Project.php:214 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 26. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `borrower` where `borrower`.`id` = '5439' and `borrower`.`deleted_at` is null limit 1380μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:22seedoutm_seedout_staging

Metadata
Bindings	0. 5439
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. /Modules/Application/Repositories/web/facade/Project.php:246 23. /Modules/Application/Repositories/web/facade/Project.php:214 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 26. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `borrower_media` where `borrower_media`.`application_id` = '5382' and `borrower_media`.`application_id` is not null limit 1

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

Metadata
Bindings	0. 5382
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/Repositories/web/facade/Project.php:247 23. /Modules/Application/Repositories/web/facade/Project.php:214 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 26. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `applications` where `applications`.`id` = '5382' limit 1220μs/Modules/Application/Entities/BorrowerMedia.php:89seedoutm_seedout_staging

Metadata
Bindings	0. 5382
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/Repositories/web/facade/Project.php:247 28. /Modules/Application/Repositories/web/facade/Project.php:214 30. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 31. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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`.`accountable_id` = '5382' and `donation_account`.`accountable_id` is not null and `donation_account`.`accountable_type` = 'application' limit 1

220μs/Modules/Application/Entities/Traits/ApplicationDonationTrait.php:148seedoutm_seedout_staging

Metadata
Bindings	0. 5382 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:148 22. /Modules/Application/Repositories/web/facade/Project.php:248 23. /Modules/Application/Repositories/web/facade/Project.php:214 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 26. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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_account_id` from `donation_account_transactions` where `transaction_type_id` in ('2', '3', '9') and `to_account_id` = '16722' group by `from_account_id`

240μs/Modules/Application/Entities/Traits/ApplicationDonationTrait.php:148seedoutm_seedout_staging

Metadata

Bindings

0. 2
1. 3
2. 9
3. 16722

Backtrace

11. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:148
16. /Modules/Application/Repositories/web/facade/Project.php:248
17. /Modules/Application/Repositories/web/facade/Project.php:214
19. /Modules/Cms/Http/Controllers/Web/BlogController.php:73
20. /Modules/Cms/Http/Controllers/Web/BlogController.php:73
36. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22
46. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33
89. /app/Http/Middleware/HttpsProtocol.php:13
94. /app/Http/Middleware/InitiateTheme.php:19
108. /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 ('16722') or `to_account_id` in ('16722')) limit 1

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

Metadata
Bindings	0. 2 1. 9 2. 16722 3. 16722
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. /Modules/Application/Repositories/web/facade/Project.php:249 37. /Modules/Application/Repositories/web/facade/Project.php:214 39. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 40. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 56. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 66. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 109. /app/Http/Middleware/HttpsProtocol.php:13 114. /app/Http/Middleware/InitiateTheme.php:19 128. /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 ('16722') or `to_account_id` in ('16722')) limit 1

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

Metadata
Bindings	0. 2 1. 9 2. 16722 3. 16722
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/Repositories/web/facade/Project.php:251 32. /Modules/Application/Repositories/web/facade/Project.php:214 34. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 35. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 51. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 61. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 104. /app/Http/Middleware/HttpsProtocol.php:13 109. /app/Http/Middleware/InitiateTheme.php:19 123. /public/index.php:54

select * from `branches` where `branches`.`id` = '22' and `branches`.`deleted_at` is null limit 1180μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_staging

Metadata
Bindings	0. 22
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. /Modules/Application/Repositories/web/facade/Project.php:254 28. /Modules/Application/Repositories/web/facade/Project.php:214 30. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 31. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 47. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 57. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 100. /app/Http/Middleware/HttpsProtocol.php:13 105. /app/Http/Middleware/InitiateTheme.php:19 119. /public/index.php:54

select * from `cities` where `id` = '3150684' limit 1150μ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. /Modules/Application/Repositories/web/facade/Project.php:254 22. /Modules/Application/Repositories/web/facade/Project.php:214 24. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `countries` where `countries`.`id` in ('168')230μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 168
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /Modules/Application/Repositories/web/facade/CountriesFilter.php:73 20. /Modules/Application/Repositories/web/facade/CountriesFilter.php:135 22. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 23. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 28. /Modules/Application/Repositories/web/facade/Project.php:254 29. /Modules/Application/Repositories/web/facade/Project.php:214 31. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 32. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 1130μ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. /Modules/Application/Repositories/web/facade/Project.php:255 22. /Modules/Application/Repositories/web/facade/Project.php:214 24. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `countries` where `countries`.`id` in ('168')210μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 168
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /Modules/Application/Repositories/web/facade/CountriesFilter.php:73 20. /Modules/Application/Repositories/web/facade/CountriesFilter.php:135 22. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 23. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 28. /Modules/Application/Repositories/web/facade/Project.php:255 29. /Modules/Application/Repositories/web/facade/Project.php:214 31. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 32. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `views` where `views`.`viewable_id` = '5382' and `views`.`viewable_id` is not null and `views`.`viewable_type` = 'application' limit 1

2.7ms/Modules/Application/Repositories/web/facade/Project.php:257seedoutm_seedout_staging

Metadata
Bindings	0. 5382 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/Repositories/web/facade/Project.php:257 18. /Modules/Application/Repositories/web/facade/Project.php:214 20. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 21. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `application_contents` where `application_contents`.`application_id` = '5439' and `application_contents`.`application_id` is not null limit 1

4.54ms/Modules/Application/Repositories/web/facade/Project.php:244seedoutm_seedout_staging

Metadata
Bindings	0. 5439
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/Repositories/web/facade/Project.php:244 18. /Modules/Application/Repositories/web/facade/Project.php:214 20. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 21. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `applications` where `applications`.`id` = '5439' limit 1290μs/Modules/Application/Entities/ApplicationContent.php:58seedoutm_seedout_staging

Metadata
Bindings	0. 5439
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/Application/Repositories/web/facade/Project.php:245 23. /Modules/Application/Repositories/web/facade/Project.php:214 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 26. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `borrower` where `borrower`.`id` = '5497' and `borrower`.`deleted_at` is null limit 1400μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:22seedoutm_seedout_staging

Metadata
Bindings	0. 5497
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. /Modules/Application/Repositories/web/facade/Project.php:246 23. /Modules/Application/Repositories/web/facade/Project.php:214 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 26. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `borrower_media` where `borrower_media`.`application_id` = '5439' and `borrower_media`.`application_id` is not null limit 1

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

Metadata
Bindings	0. 5439
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/Repositories/web/facade/Project.php:247 23. /Modules/Application/Repositories/web/facade/Project.php:214 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 26. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `applications` where `applications`.`id` = '5439' limit 1280μs/Modules/Application/Entities/BorrowerMedia.php:89seedoutm_seedout_staging

Metadata
Bindings	0. 5439
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/Repositories/web/facade/Project.php:247 28. /Modules/Application/Repositories/web/facade/Project.php:214 30. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 31. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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`.`accountable_id` = '5439' and `donation_account`.`accountable_id` is not null and `donation_account`.`accountable_type` = 'application' limit 1

250μs/Modules/Application/Entities/Traits/ApplicationDonationTrait.php:148seedoutm_seedout_staging

Metadata
Bindings	0. 5439 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:148 22. /Modules/Application/Repositories/web/facade/Project.php:248 23. /Modules/Application/Repositories/web/facade/Project.php:214 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 26. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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_account_id` from `donation_account_transactions` where `transaction_type_id` in ('2', '3', '9') and `to_account_id` = '17092' group by `from_account_id`

220μs/Modules/Application/Entities/Traits/ApplicationDonationTrait.php:148seedoutm_seedout_staging

Metadata

Bindings

0. 2
1. 3
2. 9
3. 17092

Backtrace

11. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:148
16. /Modules/Application/Repositories/web/facade/Project.php:248
17. /Modules/Application/Repositories/web/facade/Project.php:214
19. /Modules/Cms/Http/Controllers/Web/BlogController.php:73
20. /Modules/Cms/Http/Controllers/Web/BlogController.php:73
36. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22
46. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33
89. /app/Http/Middleware/HttpsProtocol.php:13
94. /app/Http/Middleware/InitiateTheme.php:19
108. /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 ('17092') or `to_account_id` in ('17092')) limit 1

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

Metadata
Bindings	0. 2 1. 9 2. 17092 3. 17092
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. /Modules/Application/Repositories/web/facade/Project.php:249 37. /Modules/Application/Repositories/web/facade/Project.php:214 39. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 40. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 56. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 66. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 109. /app/Http/Middleware/HttpsProtocol.php:13 114. /app/Http/Middleware/InitiateTheme.php:19 128. /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 ('17092') or `to_account_id` in ('17092')) limit 1

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

Metadata
Bindings	0. 2 1. 9 2. 17092 3. 17092
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/Repositories/web/facade/Project.php:251 32. /Modules/Application/Repositories/web/facade/Project.php:214 34. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 35. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 51. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 61. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 104. /app/Http/Middleware/HttpsProtocol.php:13 109. /app/Http/Middleware/InitiateTheme.php:19 123. /public/index.php:54

select * from `branches` where `branches`.`id` = '23' and `branches`.`deleted_at` is null limit 1200μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_staging

Metadata
Bindings	0. 23
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. /Modules/Application/Repositories/web/facade/Project.php:254 28. /Modules/Application/Repositories/web/facade/Project.php:214 30. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 31. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 47. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 57. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 100. /app/Http/Middleware/HttpsProtocol.php:13 105. /app/Http/Middleware/InitiateTheme.php:19 119. /public/index.php:54

select * from `cities` where `id` = '3150684' limit 1150μ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. /Modules/Application/Repositories/web/facade/Project.php:254 22. /Modules/Application/Repositories/web/facade/Project.php:214 24. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `countries` where `countries`.`id` in ('168')240μ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. /Modules/Application/Repositories/web/facade/Project.php:254 29. /Modules/Application/Repositories/web/facade/Project.php:214 31. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 32. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 1160μ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. /Modules/Application/Repositories/web/facade/Project.php:255 22. /Modules/Application/Repositories/web/facade/Project.php:214 24. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `countries` where `countries`.`id` in ('168')230μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 168
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /Modules/Application/Repositories/web/facade/CountriesFilter.php:73 20. /Modules/Application/Repositories/web/facade/CountriesFilter.php:135 22. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 23. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 28. /Modules/Application/Repositories/web/facade/Project.php:255 29. /Modules/Application/Repositories/web/facade/Project.php:214 31. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 32. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `views` where `views`.`viewable_id` = '5439' and `views`.`viewable_id` is not null and `views`.`viewable_type` = 'application' limit 1

2.83ms/Modules/Application/Repositories/web/facade/Project.php:257seedoutm_seedout_staging

Metadata
Bindings	0. 5439 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/Repositories/web/facade/Project.php:257 18. /Modules/Application/Repositories/web/facade/Project.php:214 20. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 21. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `application_contents` where `application_contents`.`application_id` = '5528' and `application_contents`.`application_id` is not null limit 1

4.46ms/Modules/Application/Repositories/web/facade/Project.php:244seedoutm_seedout_staging

Metadata
Bindings	0. 5528
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/Repositories/web/facade/Project.php:244 18. /Modules/Application/Repositories/web/facade/Project.php:214 20. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 21. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `applications` where `applications`.`id` = '5528' limit 1220μs/Modules/Application/Entities/ApplicationContent.php:58seedoutm_seedout_staging

Metadata
Bindings	0. 5528
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/Application/Repositories/web/facade/Project.php:245 23. /Modules/Application/Repositories/web/facade/Project.php:214 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 26. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `borrower` where `borrower`.`id` = '5585' and `borrower`.`deleted_at` is null limit 1360μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:22seedoutm_seedout_staging

Metadata
Bindings	0. 5585
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. /Modules/Application/Repositories/web/facade/Project.php:246 23. /Modules/Application/Repositories/web/facade/Project.php:214 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 26. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `borrower_media` where `borrower_media`.`application_id` = '5528' and `borrower_media`.`application_id` is not null limit 1

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

Metadata
Bindings	0. 5528
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/Repositories/web/facade/Project.php:247 23. /Modules/Application/Repositories/web/facade/Project.php:214 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 26. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `applications` where `applications`.`id` = '5528' limit 1320μs/Modules/Application/Entities/BorrowerMedia.php:89seedoutm_seedout_staging

Metadata
Bindings	0. 5528
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/Repositories/web/facade/Project.php:247 28. /Modules/Application/Repositories/web/facade/Project.php:214 30. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 31. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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`.`accountable_id` = '5528' and `donation_account`.`accountable_id` is not null and `donation_account`.`accountable_type` = 'application' limit 1

230μs/Modules/Application/Entities/Traits/ApplicationDonationTrait.php:148seedoutm_seedout_staging

Metadata
Bindings	0. 5528 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:148 22. /Modules/Application/Repositories/web/facade/Project.php:248 23. /Modules/Application/Repositories/web/facade/Project.php:214 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 26. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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_account_id` from `donation_account_transactions` where `transaction_type_id` in ('2', '3', '9') and `to_account_id` = '19292' group by `from_account_id`

270μs/Modules/Application/Entities/Traits/ApplicationDonationTrait.php:148seedoutm_seedout_staging

Metadata

Bindings

0. 2
1. 3
2. 9
3. 19292

Backtrace

11. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:148
16. /Modules/Application/Repositories/web/facade/Project.php:248
17. /Modules/Application/Repositories/web/facade/Project.php:214
19. /Modules/Cms/Http/Controllers/Web/BlogController.php:73
20. /Modules/Cms/Http/Controllers/Web/BlogController.php:73
36. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22
46. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33
89. /app/Http/Middleware/HttpsProtocol.php:13
94. /app/Http/Middleware/InitiateTheme.php:19
108. /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 ('19292') or `to_account_id` in ('19292')) limit 1

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

Metadata
Bindings	0. 2 1. 9 2. 19292 3. 19292
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. /Modules/Application/Repositories/web/facade/Project.php:249 37. /Modules/Application/Repositories/web/facade/Project.php:214 39. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 40. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 56. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 66. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 109. /app/Http/Middleware/HttpsProtocol.php:13 114. /app/Http/Middleware/InitiateTheme.php:19 128. /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 ('19292') or `to_account_id` in ('19292')) limit 1

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

Metadata
Bindings	0. 2 1. 9 2. 19292 3. 19292
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/Repositories/web/facade/Project.php:251 32. /Modules/Application/Repositories/web/facade/Project.php:214 34. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 35. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 51. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 61. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 104. /app/Http/Middleware/HttpsProtocol.php:13 109. /app/Http/Middleware/InitiateTheme.php:19 123. /public/index.php:54

select * from `branches` where `branches`.`id` = '13' and `branches`.`deleted_at` is null limit 1180μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_staging

Metadata
Bindings	0. 13
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. /Modules/Application/Repositories/web/facade/Project.php:254 28. /Modules/Application/Repositories/web/facade/Project.php:214 30. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 31. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 47. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 57. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 100. /app/Http/Middleware/HttpsProtocol.php:13 105. /app/Http/Middleware/InitiateTheme.php:19 119. /public/index.php:54

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

Metadata
Bindings	0. 2189673
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. /Modules/Application/Repositories/web/facade/Project.php:254 22. /Modules/Application/Repositories/web/facade/Project.php:214 24. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `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. /Modules/Application/Repositories/web/facade/Project.php:254 29. /Modules/Application/Repositories/web/facade/Project.php:214 31. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 32. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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` = '2189673' limit 1140μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 2189673
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. /Modules/Application/Repositories/web/facade/Project.php:255 22. /Modules/Application/Repositories/web/facade/Project.php:214 24. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `countries` where `countries`.`id` in ('168')270μ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. /Modules/Application/Repositories/web/facade/Project.php:255 29. /Modules/Application/Repositories/web/facade/Project.php:214 31. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 32. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `views` where `views`.`viewable_id` = '5528' and `views`.`viewable_id` is not null and `views`.`viewable_type` = 'application' limit 1

2.69ms/Modules/Application/Repositories/web/facade/Project.php:257seedoutm_seedout_staging

Metadata
Bindings	0. 5528 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/Repositories/web/facade/Project.php:257 18. /Modules/Application/Repositories/web/facade/Project.php:214 20. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 21. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `application_contents` where `application_contents`.`application_id` = '5393' and `application_contents`.`application_id` is not null limit 1

4.64ms/Modules/Application/Repositories/web/facade/Project.php:244seedoutm_seedout_staging

Metadata
Bindings	0. 5393
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/Repositories/web/facade/Project.php:244 18. /Modules/Application/Repositories/web/facade/Project.php:214 20. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 21. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `applications` where `applications`.`id` = '5393' limit 1260μs/Modules/Application/Entities/ApplicationContent.php:58seedoutm_seedout_staging

Metadata
Bindings	0. 5393
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/Application/Repositories/web/facade/Project.php:245 23. /Modules/Application/Repositories/web/facade/Project.php:214 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 26. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `borrower` where `borrower`.`id` = '5450' and `borrower`.`deleted_at` is null limit 1370μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:22seedoutm_seedout_staging

Metadata
Bindings	0. 5450
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. /Modules/Application/Repositories/web/facade/Project.php:246 23. /Modules/Application/Repositories/web/facade/Project.php:214 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 26. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `borrower_media` where `borrower_media`.`application_id` = '5393' and `borrower_media`.`application_id` is not null limit 1

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

Metadata
Bindings	0. 5393
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/Repositories/web/facade/Project.php:247 23. /Modules/Application/Repositories/web/facade/Project.php:214 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 26. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `applications` where `applications`.`id` = '5393' limit 1300μs/Modules/Application/Entities/BorrowerMedia.php:89seedoutm_seedout_staging

Metadata
Bindings	0. 5393
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/Repositories/web/facade/Project.php:247 28. /Modules/Application/Repositories/web/facade/Project.php:214 30. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 31. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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`.`accountable_id` = '5393' and `donation_account`.`accountable_id` is not null and `donation_account`.`accountable_type` = 'application' limit 1

250μs/Modules/Application/Entities/Traits/ApplicationDonationTrait.php:148seedoutm_seedout_staging

Metadata
Bindings	0. 5393 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:148 22. /Modules/Application/Repositories/web/facade/Project.php:248 23. /Modules/Application/Repositories/web/facade/Project.php:214 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 26. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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_account_id` from `donation_account_transactions` where `transaction_type_id` in ('2', '3', '9') and `to_account_id` = '16802' group by `from_account_id`

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

Metadata

Bindings

0. 2
1. 3
2. 9
3. 16802

Backtrace

11. /Modules/Application/Entities/Traits/ApplicationDonationTrait.php:148
16. /Modules/Application/Repositories/web/facade/Project.php:248
17. /Modules/Application/Repositories/web/facade/Project.php:214
19. /Modules/Cms/Http/Controllers/Web/BlogController.php:73
20. /Modules/Cms/Http/Controllers/Web/BlogController.php:73
36. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22
46. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33
89. /app/Http/Middleware/HttpsProtocol.php:13
94. /app/Http/Middleware/InitiateTheme.php:19
108. /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 ('16802') or `to_account_id` in ('16802')) limit 1

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

Metadata
Bindings	0. 2 1. 9 2. 16802 3. 16802
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. /Modules/Application/Repositories/web/facade/Project.php:249 37. /Modules/Application/Repositories/web/facade/Project.php:214 39. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 40. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 56. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 66. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 109. /app/Http/Middleware/HttpsProtocol.php:13 114. /app/Http/Middleware/InitiateTheme.php:19 128. /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 ('16802') or `to_account_id` in ('16802')) limit 1

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

Metadata
Bindings	0. 2 1. 9 2. 16802 3. 16802
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/Repositories/web/facade/Project.php:251 32. /Modules/Application/Repositories/web/facade/Project.php:214 34. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 35. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 51. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 61. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 104. /app/Http/Middleware/HttpsProtocol.php:13 109. /app/Http/Middleware/InitiateTheme.php:19 123. /public/index.php:54

select * from `branches` where `branches`.`id` = '24' and `branches`.`deleted_at` is null limit 1190μs/Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:134seedoutm_seedout_staging

Metadata
Bindings	0. 24
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. /Modules/Application/Repositories/web/facade/Project.php:254 28. /Modules/Application/Repositories/web/facade/Project.php:214 30. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 31. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 47. /Modules/Cms/Http/Middleware/CheckLocationTimeZone.php:22 57. /vendor/torann/currency/src/Middleware/CurrencyMiddleware.php:33 100. /app/Http/Middleware/HttpsProtocol.php:13 105. /app/Http/Middleware/InitiateTheme.php:19 119. /public/index.php:54

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

Metadata
Bindings	0. 2189673
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. /Modules/Application/Repositories/web/facade/Project.php:254 22. /Modules/Application/Repositories/web/facade/Project.php:214 24. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `countries` where `countries`.`id` in ('168')230μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 168
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /Modules/Application/Repositories/web/facade/CountriesFilter.php:73 20. /Modules/Application/Repositories/web/facade/CountriesFilter.php:135 22. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 23. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 28. /Modules/Application/Repositories/web/facade/Project.php:254 29. /Modules/Application/Repositories/web/facade/Project.php:214 31. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 32. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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` = '2189673' limit 1150μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 2189673
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. /Modules/Application/Repositories/web/facade/Project.php:255 22. /Modules/Application/Repositories/web/facade/Project.php:214 24. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 25. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `countries` where `countries`.`id` in ('168')230μs/Modules/Application/Repositories/web/facade/CountriesFilter.php:73seedoutm_seedout_staging

Metadata
Bindings	0. 168
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	19. /Modules/Application/Repositories/web/facade/CountriesFilter.php:73 20. /Modules/Application/Repositories/web/facade/CountriesFilter.php:135 22. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 23. /Modules/Application/Entities/Traits/ApplicantFieldsTrait.php:145 28. /Modules/Application/Repositories/web/facade/Project.php:255 29. /Modules/Application/Repositories/web/facade/Project.php:214 31. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 32. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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 `views` where `views`.`viewable_id` = '5393' and `views`.`viewable_id` is not null and `views`.`viewable_type` = 'application' limit 1

2.72ms/Modules/Application/Repositories/web/facade/Project.php:257seedoutm_seedout_staging

Metadata
Bindings	0. 5393 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/Repositories/web/facade/Project.php:257 18. /Modules/Application/Repositories/web/facade/Project.php:214 20. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 21. /Modules/Cms/Http/Controllers/Web/BlogController.php:73 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

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: kd5WucvWOY8oQiayKnJN1vvzx7aAkd0G7zjieyms
_previous: array:1 [ "url" => "https://www.seedout.me/blog/post/join-hands-with-justajoo-pakistan-flood-relie...
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" => "Z8Pa2yJ4nrLBj6gK_agshgAAAAI"...
request_cookies: []
response_headers: array:4 [ "cache-control" => array:1 [ 0 => "no-cache" ] "content-type" => array:1 [ 0...
path_info: /blog/post/join-hands-with-justajoo-pakistan-flood-relief-campaign-2022
session_attributes: array:4 [ "currency" => "USD" "_token" => "kd5WucvWOY8oQiayKnJN1vvzx7aAkd0G7zjieyms" "_previou...

Posts by Category "Pakistan Floods Disaster"

Join hands with Justajoo - Pakistan Flood Relief Campaign 2022

Join hands with Justajoo - Pakistan Flood Relief Campaign 2022

DONATE TO FLOOD VICTIMS IN PAKISTAN

Justajoo Flood Relief box, worth PKR 2,500.

Latest Project

Recent Posts

Categories

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

Get to know us

Posts by Category "Pakistan Floods Disaster"

Join hands with Justajoo - Pakistan Flood Relief Campaign 2022

Join hands with Justajoo - Pakistan Flood Relief Campaign 2022

DONATE TO FLOOD VICTIMS IN PAKISTAN

Justajoo Flood Relief box, worth PKR 2,500.

Latest Project

Recent Posts

Categories