Crafts - Page 2 | VlogTrends - The Best Vloggers In The World

Messages Timeline Exceptions Views30 Route Queries37 Models130 Mails Gate Session Request

7.4.3277ms7MBGET tags/{slug}

Booting (76.37ms)
Application (200ms)
1 x Application (72.35%)
200.32ms
1 x Booting (27.58%)
76.37ms

30 templates were rendered

vlogs.showtag (resources/views/vlogs/showtag.blade.php)8blade
Params
0
vlogs
1
review_summaries
2
review_excerpts
3
tag
4
orderby
5
page
6
title
7
description
pagination::bootstrap-4 (resources/views/vendor/pagination/bootstrap-4.blade.php)2blade
Params
0
paginator
1
elements

Params
0	`vlogs`
1	`review_summaries`
2	`review_excerpts`
3	`tag`
4	`orderby`
5	`page`
6	`title`
7	`description`

Params
0	`paginator`
1	`elements`

layouts.master (resources/views/layouts/master.blade.php)18blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`

layouts.partials.head (resources/views/layouts/partials/head.blade.php)18blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`

cookieConsent::index (resources/views/vendor/cookieConsent/index.blade.php)20blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b
alreadyConsentedWithCookies
cookieConsentConfig

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`
18	`alreadyConsentedWithCookies`
19	`cookieConsentConfig`

cookieConsent::dialogContents (resources/views/vendor/cookieConsent/dialogContents.blade.php)20blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b
alreadyConsentedWithCookies
cookieConsentConfig

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`
18	`alreadyConsentedWithCookies`
19	`cookieConsentConfig`

layouts.partials.nav (resources/views/layouts/partials/nav.blade.php)18blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`

layouts.partials.searchsuggestions (resources/views/layouts/partials/searchsuggestions.blade.php)19blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b
searchsuggestions

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`
18	`searchsuggestions`

layouts.partials.blogpost-box-htmlplus (resources/views/layouts/partials/blogpost-box-htmlplus.blade.php)21blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b
searchsuggestions
blogpost
size

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`
18	`searchsuggestions`
19	`blogpost`
20	`size`

layouts.partials.blogpost-box-htmlplus (resources/views/layouts/partials/blogpost-box-htmlplus.blade.php)21blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b
searchsuggestions
blogpost
size

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`
18	`searchsuggestions`
19	`blogpost`
20	`size`

layouts.partials.blogpost-box-htmlplus (resources/views/layouts/partials/blogpost-box-htmlplus.blade.php)21blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b
searchsuggestions
blogpost
size

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`
18	`searchsuggestions`
19	`blogpost`
20	`size`

layouts.partials.blogpost-box-htmlplus (resources/views/layouts/partials/blogpost-box-htmlplus.blade.php)21blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b
searchsuggestions
blogpost
size

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`
18	`searchsuggestions`
19	`blogpost`
20	`size`

layouts.partials.blogpost-box-htmlplus (resources/views/layouts/partials/blogpost-box-htmlplus.blade.php)21blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b
searchsuggestions
blogpost
size

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`
18	`searchsuggestions`
19	`blogpost`
20	`size`

layouts.partials.blogpost-box-htmlplus (resources/views/layouts/partials/blogpost-box-htmlplus.blade.php)21blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b
searchsuggestions
blogpost
size

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`
18	`searchsuggestions`
19	`blogpost`
20	`size`

layouts.partials.searchsuggestions (resources/views/layouts/partials/searchsuggestions.blade.php)19blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b
searchsuggestions

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`
18	`searchsuggestions`

layouts.partials.blogpost-box-htmlplus (resources/views/layouts/partials/blogpost-box-htmlplus.blade.php)21blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b
searchsuggestions
blogpost
size

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`
18	`searchsuggestions`
19	`blogpost`
20	`size`

layouts.partials.blogpost-box-htmlplus (resources/views/layouts/partials/blogpost-box-htmlplus.blade.php)21blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b
searchsuggestions
blogpost
size

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`
18	`searchsuggestions`
19	`blogpost`
20	`size`

layouts.partials.blogpost-box-htmlplus (resources/views/layouts/partials/blogpost-box-htmlplus.blade.php)21blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b
searchsuggestions
blogpost
size

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`
18	`searchsuggestions`
19	`blogpost`
20	`size`

layouts.partials.blogpost-box-htmlplus (resources/views/layouts/partials/blogpost-box-htmlplus.blade.php)21blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b
searchsuggestions
blogpost
size

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`
18	`searchsuggestions`
19	`blogpost`
20	`size`

layouts.partials.blogpost-box-htmlplus (resources/views/layouts/partials/blogpost-box-htmlplus.blade.php)21blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b
searchsuggestions
blogpost
size

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`
18	`searchsuggestions`
19	`blogpost`
20	`size`

layouts.partials.blogpost-box-htmlplus (resources/views/layouts/partials/blogpost-box-htmlplus.blade.php)21blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b
searchsuggestions
blogpost
size

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`
18	`searchsuggestions`
19	`blogpost`
20	`size`

layouts.partials.header (resources/views/layouts/partials/header.blade.php)18blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`

layouts.partials.messages (resources/views/layouts/partials/messages.blade.php)18blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`

reports.modal (resources/views/reports/modal.blade.php)18blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`

modals.confirm (resources/views/modals/confirm.blade.php)18blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`

modals.confirm-function (resources/views/modals/confirm-function.blade.php)18blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`

layouts.partials.login (resources/views/layouts/partials/login.blade.php)18blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`

layouts.partials.register (resources/views/layouts/partials/register.blade.php)18blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`

layouts.partials.footer (resources/views/layouts/partials/footer.blade.php)18blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`

layouts.partials.footerscripts (resources/views/layouts/partials/footerscripts.blade.php)18blade


obLevel
__env
app
sprite
errors
vlogs
review_summaries
review_excerpts
tag
orderby
page
title
description
__currentLoopData
vlog
loop
reviewsummary
b

Params
0	`obLevel`
1	`__env`
2	`app`
3	`sprite`
4	`errors`
5	`vlogs`
6	`review_summaries`
7	`review_excerpts`
8	`tag`
9	`orderby`
10	`page`
11	`title`
12	`description`
13	`__currentLoopData`
14	`vlog`
15	`loop`
16	`reviewsummary`
17	`b`

uri: GET tags/{slug}
middleware: web, onboarding
controller: App\Http\Controllers\VlogController@showtag
namespace: App\Http\Controllers
prefix
where
as: vlogs.showtag
file: app/Http/Controllers/VlogController.php:2270-2341

37 statements were executed22.55ms

select tag_id, tag_id as id, name, normalized, created_at, updated_at, normalized AS slug from `taggable_tags` where `normalized` in ('Crafts') limit 1

540μs/app/MyTag.php:82vtdb

Metadata
Bindings	0. Crafts
Backtrace	15. /app/MyTag.php:82 16. /app/Http/Controllers/VlogController.php:2272 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select `tag_id` from `taggable_tags` where `normalized` in ('crafts')360μs/vendor/cviebrock/eloquent-taggable/src/Services/TagService.php:122vtdb

Metadata
Bindings	0. crafts
Backtrace	13. /vendor/cviebrock/eloquent-taggable/src/Services/TagService.php:122 14. /vendor/cviebrock/eloquent-taggable/src/Taggable.php:276 20. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 23. /app/Http/Controllers/VlogController.php:2316 26. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45

select `vlogs`.* from `vlogs` inner join `taggable_taggables` as `taggable_taggables_scopewithanytags_1` on `vlogs`.`id` = `taggable_taggables_scopewithanytags_1`.`taggable_id` and `taggable_taggables_scopewithanytags_1`.`taggable_type` = 'App\Vlog' where `taggable_taggables_scopewithanytags_1`.`tag_id` in (703) and `vlogs`.`moderation_status` = 1 group by `vlogs`.`id` order by avgrating DESC, youtube_statistics_subscribercount DESC

2.51ms/app/Http/Controllers/VlogController.php:2316vtdb

Metadata
Bindings	0. App\Vlog 1. 703 2. 1
Backtrace	14. /app/Http/Controllers/VlogController.php:2316 17. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196 20. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:685

select `taggable_tags`.*, `taggable_taggables`.`taggable_id` as `pivot_taggable_id`, `taggable_taggables`.`tag_id` as `pivot_tag_id`, `taggable_taggables`.`taggable_type` as `pivot_taggable_type`, `taggable_taggables`.`created_at` as `pivot_created_at`, `taggable_taggables`.`updated_at` as `pivot_updated_at` from `taggable_tags` inner join `taggable_taggables` on `taggable_tags`.`tag_id` = `taggable_taggables`.`tag_id` where `taggable_taggables`.`taggable_id` in (5623, 5624, 5625, 5627, 5628, 5630, 5631, 5632, 5633, 5634, 5635, 5636, 5637, 5638, 5639, 5640, 5641, 5642, 5643, 5644, 5645, 5646, 5670, 5672, 5673, 5674, 5675, 6074) and `taggable_taggables`.`taggable_type` = 'App\Vlog'

1.09ms/app/Http/Controllers/VlogController.php:2316vtdb

Metadata
Bindings	0. App\Vlog
Backtrace	18. /app/Http/Controllers/VlogController.php:2316 21. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 22. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 23. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196 24. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:685

SELECT vlogs.id as vlog_id, youtube_statistics_subscribercount AS subs, IFNULL(avg(rating), 0) as avgrating_overall, count(*) as count_ratings, IFNULL(avg(rating_credibility), 0) as avgrating_credibility, IFNULL(avg(rating_production), 0) as avgrating_production, IFNULL(avg(rating_entertainment), 0) as avgrating_entertainment, avg(rating+rating_credibility+rating_production+rating_entertainment)/4 as avgrating FROM vlogs LEFT JOIN reviews ON vlogs.id=reviews.vlog_id AND reviews.moderation_status=1  WHERE vlogs.id IN (5646,5625,5672,5673,5675,5670,5674,5628,6074,5634,5627,5624,5631,5635,5623,5637,5632,5630,5633,5636,5638,5642,5640,5639,5644,5643,5641,5645)  GROUP BY vlogs.id  ORDER BY avgrating, subs;

1.48ms/vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261vtdb

Metadata
Backtrace	9. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:261 10. /app/Http/Controllers/VlogController.php:298 11. /app/Http/Controllers/VlogController.php:2319 14. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 15. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239

select vlog_id, count(*) as count_reviews from `reviews` where `vlog_id` in (5646, 5625, 5672, 5673, 5675, 5670, 5674, 5628, 6074, 5634, 5627, 5624, 5631, 5635, 5623, 5637, 5632, 5630, 5633, 5636, 5638, 5642, 5640, 5639, 5644, 5643, 5641, 5645) and `title` <> '' and `title` <> 'NULL' and `moderation_status` = 1 group by `vlog_id`

780μs/app/Http/Controllers/VlogController.php:330vtdb

Metadata
Bindings	0. 5646 1. 5625 2. 5672 3. 5673 4. 5675 5. 5670 6. 5674 7. 5628 8. 6074 9. 5634 10. 5627 11. 5624 12. 5631 13. 5635 14. 5623 15. 5637 16. 5632 17. 5630 18. 5633 19. 5636 20. 5638 21. 5642 22. 5640 23. 5639 24. 5644 25. 5643 26. 5641 27. 5645 28. 29. NULL 30. 1
Backtrace	12. /app/Http/Controllers/VlogController.php:330 13. /app/Http/Controllers/VlogController.php:2319 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5646 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

550μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5646 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5625 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

580μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5625 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5672 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

510μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5672 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5673 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

500μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5673 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5675 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

480μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5675 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5670 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

510μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5670 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5674 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

510μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5674 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5628 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

530μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5628 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 6074 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

470μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 6074 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5634 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

470μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5634 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5627 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

500μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5627 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5624 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

530μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5624 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5631 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

530μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5631 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5635 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

510μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5635 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5623 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

640μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5623 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5637 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

520μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5637 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5632 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

490μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5632 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5630 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

510μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5630 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5633 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

500μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5633 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5636 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

510μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5636 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5638 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

520μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5638 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5642 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

480μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5642 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5640 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

480μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5640 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5639 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

460μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5639 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5644 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

480μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5644 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5643 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

520μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5643 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5641 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

490μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5641 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select r.id as review_id, r.title as review_title, r.content as review_content, r.user_id, users.slug as user_slug, concat(users.first_name, " ", users.last_name) as user_name, r.created_at, r.vlog_id, love_reactant_reaction_totals.weight as reaction_weight, love_reactant_reaction_totals.count as reaction_count,  ROUND(((r.rating+r.rating_credibility+r.rating_production+r.rating_entertainment)/4),1) AS avgrating from `reviews` as `r` left join `love_reactant_reaction_totals` on `love_reactant_reaction_totals`.`reactant_id` = `r`.`love_reactant_id` left join `users` on `users`.`id` = `r`.`user_id` where `vlog_id` = 5645 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

460μs/app/Http/Controllers/ReviewController.php:111vtdb

Metadata
Bindings	0. 5645 1.
Backtrace	12. /app/Http/Controllers/ReviewController.php:111 13. /app/Http/Controllers/VlogController.php:2320 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:239 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:196

select `id`, `title`, `slug`, `thumbnail_url`, `thumbnail_alt` from `blog_posts` where `slug` in ('sailing-cruising-youtube', 'photography-youtube', 'travel-youtube', 'true-crime-youtube', 'hiit-workouts', 'crafts-life-hacks') order by FIELD (slug, "sailing-cruising-youtube", "photography-youtube", "travel-youtube", "true-crime-youtube", "hiit-workouts", "crafts-life-hacks") ASC

530μs/app/Http/Controllers/SearchController.php:28vtdb

Metadata
Bindings	0. sailing-cruising-youtube 1. photography-youtube 2. travel-youtube 3. true-crime-youtube 4. hiit-workouts 5. crafts-life-hacks
Backtrace	14. /app/Http/Controllers/SearchController.php:28 15. view::layouts.partials.nav:2 17. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 18. /vendor/laravel/framework/src/Illuminate/View/View.php:139 19. /vendor/laravel/framework/src/Illuminate/View/View.php:122

select tag_id, tag_id as id, name, normalized, created_at, updated_at, normalized AS slug from `taggable_tags` where `normalized` in ('travel', 'sports', 'lifestyle', 'sailing', 'cruising', 'photography')

530μs/app/MyTag.php:77vtdb

Metadata
Bindings	0. travel 1. sports 2. lifestyle 3. sailing 4. cruising 5. photography
Backtrace	14. /app/MyTag.php:77 15. /app/Http/Controllers/SearchController.php:55 16. view::layouts.partials.nav:2 18. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 19. /vendor/laravel/framework/src/Illuminate/View/View.php:139

select `id`, `vlog_name`, `slug`, `avatar` from `vlogs` where `vlogs`.`id` in ('18', '1', '6', '5185', '5562', '4489') and `vlogs`.`moderation_status` = 1

490μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23vtdb

Metadata
Bindings	0. 18 1. 1 2. 6 3. 5185 4. 5562 5. 4489 6. 1
Backtrace	16. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 19. /app/Http/Controllers/SearchController.php:58 20. view::layouts.partials.nav:2 22. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:57 23. /vendor/laravel/framework/src/Illuminate/View/View.php:139

App\BlogPost: 6
App\Vlog: 34
App\MyTag: 90

_token: EBzapqLGVnI4ykjuAnII97GhFMGi1u9lZ4lAak5J
PHPDEBUGBAR_STACK_DATA: []

telescope

View in Telescope

path_info

/tags/Crafts

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▶
  "page" => "2"
]

request_request

  0 of 0   
array:1 [▶
  "page" => "2"
]

request_headers

  0 of 0   
array:17 [▶
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "accept" => array:1 [▶
    0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "host" => array:1 [▶
    0 => "dev.vlogtrends.com"
  ]
  "content-length" => array:1 [▶
    0 => ""
  ]
  "content-type" => array:1 [▶
    0 => ""
  ]
]

request_server

  0 of 0   
array:41 [▶
  "USER" => "www-data"
  "HOME" => "/var/www"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_SITE" => "none"
  "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CONNECTION" => "keep-alive"
  "HTTP_HOST" => "dev.vlogtrends.com"
  "SCRIPT_FILENAME" => "/var/www/vlogtrends/public/index.php"
  "REDIRECT_STATUS" => "200"
  "SERVER_NAME" => "dev.vlogtrends.com"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "116.202.0.150"
  "REMOTE_PORT" => "55627"
  "REMOTE_ADDR" => "216.73.216.14"
  "SERVER_SOFTWARE" => "nginx/1.18.0"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "HTTPS" => "on"
  "REQUEST_SCHEME" => "https"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "DOCUMENT_ROOT" => "/var/www/vlogtrends/public"
  "DOCUMENT_URI" => "/index.php"
  "REQUEST_URI" => "/tags/Crafts?page=2"
  "SCRIPT_NAME" => "/index.php"
  "CONTENT_LENGTH" => ""
  "CONTENT_TYPE" => ""
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => "page=2"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1749715786.2235
  "REQUEST_TIME" => 1749715786
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Thu, 12 Jun 2025 08:09:46 GMT"
  ]
  "set-cookie" => array:1 [▶
    0 => "XSRF-TOKEN=EBzapqLGVnI4ykjuAnII97GhFMGi1u9lZ4lAak5J; expires=Fri, 31-May-2075 08:09:46 GMT; Max-Age=1576800000; path=/; domain=dev.vlogtrends.com; secure; samesite=lax ◀XSRF-TOKEN=EBzapqLGVnI4ykjuAnII97GhFMGi1u9lZ4lAak5J; expires=Fri, 31-May-2075 08:09:46 GMT; Max-Age=1576800000; path=/; domain=dev.vlogtrends.com; secure; sames ▶"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "XSRF-TOKEN=EBzapqLGVnI4ykjuAnII97GhFMGi1u9lZ4lAak5J; expires=Fri, 31-May-2075 08:09:46 GMT; domain=dev.vlogtrends.com; path=/; secure"
  ]
]

session_attributes

  0 of 0   
array:2 [▶
  "_token" => "EBzapqLGVnI4ykjuAnII97GhFMGi1u9lZ4lAak5J"
  "PHPDEBUGBAR_STACK_DATA" => []
]

1 x Application (72.35%)	200.32ms
1 x Booting (27.58%)	76.37ms