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

Messages Timeline Exceptions Views30 Route Queries46 Models198 Mails Gate Session Request

7.4.3340ms8MBGET tags/{slug}

Booting (81.42ms)
Application (258ms)
1 x Application (75.97%)
257.99ms
1 x Booting (23.98%)
81.42ms

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

46 statements were executed30.33ms

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

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

Metadata
Bindings	0. family
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 ('family')380μs/vendor/cviebrock/eloquent-taggable/src/Services/TagService.php:122vtdb

Metadata
Bindings	0. family
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 (7) and `vlogs`.`moderation_status` = 1 group by `vlogs`.`id` order by avgrating DESC, youtube_statistics_subscribercount DESC

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

Metadata
Bindings	0. App\Vlog 1. 7 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 (6, 7, 4403, 4584, 4607, 4608, 4609, 4610, 4611, 4612, 4613, 4614, 4615, 4616, 4617, 4618, 4619, 4620, 4621, 4622, 4623, 4624, 4625, 4828, 4855, 4864, 4865, 4874, 4886, 4896, 4899, 5417, 5543, 5548, 5577, 5578, 5726) and `taggable_taggables`.`taggable_type` = 'App\Vlog'

1.44ms/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 (6,4608,7,4584,4607,4612,4828,4613,5417,4609,4403,4615,4618,4616,4617,5726,4625,4610,4619,4620,4621,4614,4611,4864,5578,4622,4896,4865,5577,5548,4874,4886,4623,5543,4855,4624,4899)  GROUP BY vlogs.id  ORDER BY avgrating, subs;

1.21ms/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 (6, 4608, 7, 4584, 4607, 4612, 4828, 4613, 5417, 4609, 4403, 4615, 4618, 4616, 4617, 5726, 4625, 4610, 4619, 4620, 4621, 4614, 4611, 4864, 5578, 4622, 4896, 4865, 5577, 5548, 4874, 4886, 4623, 5543, 4855, 4624, 4899) and `title` <> '' and `title` <> 'NULL' and `moderation_status` = 1 group by `vlog_id`

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

Metadata
Bindings	0. 6 1. 4608 2. 7 3. 4584 4. 4607 5. 4612 6. 4828 7. 4613 8. 5417 9. 4609 10. 4403 11. 4615 12. 4618 13. 4616 14. 4617 15. 5726 16. 4625 17. 4610 18. 4619 19. 4620 20. 4621 21. 4614 22. 4611 23. 4864 24. 5578 25. 4622 26. 4896 27. 4865 28. 5577 29. 5548 30. 4874 31. 4886 32. 4623 33. 5543 34. 4855 35. 4624 36. 4899 37. 38. NULL 39. 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` = 6 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

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

Metadata
Bindings	0. 6 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` = 4608 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

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

Metadata
Bindings	0. 4608 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` = 7 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

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

Metadata
Bindings	0. 7 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` = 4584 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. 4584 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` = 4607 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. 4607 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` = 4612 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. 4612 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` = 4828 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. 4828 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` = 4613 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. 4613 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` = 5417 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. 5417 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` = 4609 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. 4609 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` = 4403 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

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

Metadata
Bindings	0. 4403 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` = 4615 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

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

Metadata
Bindings	0. 4615 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` = 4618 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. 4618 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` = 4616 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. 4616 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` = 4617 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. 4617 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` = 5726 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

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

Metadata
Bindings	0. 5726 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` = 4625 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. 4625 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` = 4610 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. 4610 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` = 4619 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. 4619 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` = 4620 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. 4620 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` = 4621 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

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

Metadata
Bindings	0. 4621 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` = 4614 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. 4614 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` = 4611 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

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

Metadata
Bindings	0. 4611 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` = 4864 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. 4864 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` = 5578 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. 5578 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` = 4622 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. 4622 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` = 4896 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. 4896 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` = 4865 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. 4865 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` = 5577 and `r`.`title` <> '' order by `love_reactant_reaction_totals`.`weight` desc, `love_reactant_reaction_totals`.`count` desc, `r`.`created_at` desc limit 5

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

Metadata
Bindings	0. 5577 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` = 5548 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. 5548 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` = 4874 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. 4874 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` = 4886 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. 4886 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` = 4623 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. 4623 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` = 5543 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. 5543 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` = 4855 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. 4855 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` = 4624 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. 4624 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` = 4899 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. 4899 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

730μ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')

780μ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

850μ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: 43
App\MyTag: 149

_token: sDlF2O4tYEOr2Yx88BjmfwqAWHHyvGJVpmeTGgPl
PHPDEBUGBAR_STACK_DATA: []

telescope

View in Telescope

path_info

/tags/family

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" => "43419"
  "REMOTE_ADDR" => "216.73.216.211"
  "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/family?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" => 1749373977.8107
  "REQUEST_TIME" => 1749373977
]

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 => "Sun, 08 Jun 2025 09:12:58 GMT"
  ]
  "set-cookie" => array:1 [▶
    0 => "XSRF-TOKEN=sDlF2O4tYEOr2Yx88BjmfwqAWHHyvGJVpmeTGgPl; expires=Mon, 27-May-2075 09:12:58 GMT; Max-Age=1576800000; path=/; domain=dev.vlogtrends.com; secure; samesite=lax ◀XSRF-TOKEN=sDlF2O4tYEOr2Yx88BjmfwqAWHHyvGJVpmeTGgPl; expires=Mon, 27-May-2075 09:12:58 GMT; Max-Age=1576800000; path=/; domain=dev.vlogtrends.com; secure; sames ▶"
  ]
  "Set-Cookie" => array:1 [▶
    0 => "XSRF-TOKEN=sDlF2O4tYEOr2Yx88BjmfwqAWHHyvGJVpmeTGgPl; expires=Mon, 27-May-2075 09:12:58 GMT; domain=dev.vlogtrends.com; path=/; secure"
  ]
]

session_attributes

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

1 x Application (75.97%)	257.99ms
1 x Booting (23.98%)	81.42ms