Regjistrohuni tani

Kroacia Bosnja dhe Hercegovina Serbia Mali i Zi Maqedonia Veriore Ukranija Kosovë Austri Gjermani Zvicera Mbretëria e Bashkuar

Gjeni një punonjës për një kafe në ditë!

Zbuloni talentet më shpejt dhe më lehtë

Prezantimi i një modeli krejt të ri abonimi ku gjetja e punonjësit tuaj të ardhshëm nuk kushton më shumë se një filxhan kafe në ditë. Me këtë qasje inovative, ju do të ndërtoni ekipin tuaj më shpejt dhe do të zbuloni talentin në mënyrën më të lehtë të mundshme.

Regjistrohuni tani!

Gjeni një student ose punë të rregullt

Karriera juaj në majë të gishtave

Pavarësisht nëse jeni një i sapodiplomuar në kërkim të punës së ëndrrave tuaja ose një student që kërkon punë me kohë të pjesshme për të mbështetur studimet tuaja, ne ju kemi mbuluar. Gjeni një punë sot dhe hapni rrugën tuaj për një të ardhme më të ndritshme.

Regjistrohuni tani!

PickJobs - 100% punë

Çelësi për një karrierë të suksesshme

A po kërkoni një vend pune apo po kërkoni punonjës të rinj? A po eksploroni mundësitë? Krijoni profilin tuaj, kontrolloni përmbajtjen e tij dhe bëhuni konkurrues në arritjen e qëllimeve tuaja.

Regjistrohuni tani!

Regjistrohu

Adresa e postës elektronike

Fjalëkalim

Me kujto

Keni harruar fjalëkalimin tuaj?

Nuk keni llogari?
Regjistrohuni ne Pickjobs

ose

Vetëm student

Seasonal jobs

Më shumë se 10.000 shpalljeve aktive

Punë të zgjedhura

Nxitës i filtrit nikotik

Kroacia
12.12.2025

Programues

Kroacia
12.12.2025

kamerier

Kroacia
12.12.2025

Test njohurish për një psikolog...

Ukranija
12.12.2025

Agronom

Bosnja dhe Hercegovina
12.12.2025

Infermierja

Kroacia
12.12.2025

Master i Farmacisë (m / f)

Kroacia
12.12.2025

Ky është një tjetër theks në ko...

Kroacia
12.12.2025

Kjo është një reklamë HTML

Kroacia
12.12.2025

Master i Farmacisë (m/f)

Kroacia
12.12.2025

titulli premium i reklamës

Kroacia
12.12.2025

postë provë

Kroacia
12.12.2025

ndihmës

Kroacia
12.12.2025

Infermierja

Kroacia
12.12.2025

arkëtar

Kroacia
12.12.2025

shitës

Kroacia
12.12.2025

administratori

Kroacia
12.12.2025

Asnsn

Kroacia
12.12.2025

Agronomia praktikante

Kroacia
12.12.2025

provë

Serbia
12.12.2025

Parukeri

Kroacia
12.12.2025

Asistent i administratorit

Kroacia
12.12.2025

Avokat

Kroacia
12.12.2025

Arkëtar

Kroacia
12.12.2025

Nxitës i filtrit nikotik

Kroacia
12.12.2025

Programues

Kroacia
12.12.2025

kamerier

Kroacia
12.12.2025

Test njohurish për një psikolog...

Ukranija
12.12.2025

Agronom

Bosnja dhe Hercegovina
12.12.2025

Infermierja

Kroacia
12.12.2025

Master i Farmacisë (m / f)

Kroacia
12.12.2025

Ky është një tjetër theks në ko...

Kroacia
12.12.2025

Kjo është një reklamë HTML

Kroacia
12.12.2025

Master i Farmacisë (m/f)

Kroacia
12.12.2025

titulli premium i reklamës

Kroacia
12.12.2025

postë provë

Kroacia
12.12.2025

ndihmës

Kroacia
12.12.2025

Infermierja

Kroacia
12.12.2025

arkëtar

Kroacia
12.12.2025

shitës

Kroacia
12.12.2025

administratori

Kroacia
12.12.2025

Asnsn

Kroacia
12.12.2025

Agronomia praktikante

Kroacia
12.12.2025

provë

Serbia
12.12.2025

Parukeri

Kroacia
12.12.2025

Asistent i administratorit

Kroacia
12.12.2025

Avokat

Kroacia
12.12.2025

Arkëtar

Kroacia
12.12.2025

Nxitës i filtrit nikotik

Kroacia
12.12.2025

Programues

Kroacia
12.12.2025

kamerier

Kroacia
12.12.2025

Test njohurish për një psikolog...

Ukranija
12.12.2025

Agronom

Bosnja dhe Hercegovina
12.12.2025

Infermierja

Kroacia
12.12.2025

Të gjitha kategoritë

Punë studentore

Kjo është një reklamë e re ws

Kroacia
12.12.2025

Asistenti (m/f)

Kroacia
12.12.2025

Shofer kamioni - kategoria b

Kroacia
12.12.2025

pasticeri m / f

Kroacia
12.12.2025

Vvg

Kroacia
12.12.2025

Proba zvanje

Kroacia
12.12.2025

Provoni reklamën

Kroacia
12.12.2025

Shofer kamioni në trafikun ndërk...

Kroacia
12.12.2025

wertewrt

Kroacia
12.12.2025

Punët më të njohura

"TESTERËT" TË PËRMBAJTJEVE NË NJ...

Kroacia
12.12.2025

Programues

Kroacia
12.12.2025

Kuzhinier pastiçeri / pastiçeri ...

Kroacia
12.12.2025

ndihmës

Kroacia
12.12.2025

gjrhgfh

Bosnja dhe Hercegovina
12.12.2025

Tregtar-tregtar m/f

Kroacia
12.12.2025

test 232

Serbia
12.12.2025

PUNONJESI ADMINISTRATIV

Kroacia
12.12.2025

gyugk

Kroacia
12.12.2025

PickJobs Blog

Lajmet e fundit

Këshilla për punonjësit

Top më të mira se si të përmirësoni marrëdhëniet tuaja me kolegët

Meqenëse me siguri që kaloni më shumë kohë me kolegët tuaj sesa me këdo tjetër, është thelbësore të keni një marrëdhënie...

Këshilla për punëdhënësit

Sa e nevojshme është të kesh një mentor të mirë dhe cilat janë avantazhet e tij?

Një mentor është një person i cili me njohuritë dhe përvojën e tij, sipas shumë hulumtimeve, e bën sekretin e suksesit....

Këshilla për punëdhënësit

Rëndësia e aftësive të komunikimit

Zotërimi i aftësive të forta të komunikimit do t'ju ndihmojë në çdo fazë të jetës tuaj, dhe kështu vepron edhe vendi i p...

Aplikimi celular PickJobs

Shkarkoni aplikacionin falas të celularit PickJobs në pajisjen tuaj Android ose iOS, përmes Google Play Store ose App Store, dhe fitoni akses kudo, në çdo kohë.

Izjava o sufinanciranju

Krajnji primatelj financijskog instrumenta sufinanciranog iz Europskog fonda za regionalni razvoj u sklopu Operativnog programa “Konkurentnost i kohezija”

Partnerët tanë

cookies

Për përvojën më të mirë të përdoruesit dhe funksionalitetin e plotë të të gjitha tipareve të faqes në internet, PickJobs përdor cookie dhe teknologji të ngjashme. Nëse vazhdoni të përdorni këtë faqe, ne do të supozojmë se ju keni pranuar dhe pajtuar me Politikën tonë të Cookie-t. Lexoni më shumë rreth Politika e Cookie

Unë pranoj

Messages Timeline Exceptions Views16 Route Queries79 Mails Gate Session Request

7.4.3239.3ms8.52MBGET al

Booting (22.63ms)
Application (216.57ms)
1 x Application (90.5%)
216.57ms
1 x Booting (9.46%)
22.63ms

16 templates were rendered

public.landing (resources/views/public/landing.blade.php)19blade


latestNews
featuredJobs
studentsJobs
banners
featuredCompanies
jobShareParam
typeUrl
lang
regions
occupations
postType
keywords
employment_type
latitude
longitude
category
region_place_id
address
user

Params
0	`latestNews`
1	`featuredJobs`
2	`studentsJobs`
3	`banners`
4	`featuredCompanies`
5	`jobShareParam`
6	`typeUrl`
7	`lang`
8	`regions`
9	`occupations`
10	`postType`
11	`keywords`
12	`employment_type`
13	`latitude`
14	`longitude`
15	`category`
16	`region_place_id`
17	`address`
18	`user`

public.layouts.partials._loginRegForm (resources/views/public/layouts/partials/_loginRegForm.blade.php)28blade


obLevel
__env
app
errors
latestNews
featuredJobs
studentsJobs
banners
featuredCompanies
jobShareParam
typeUrl
lang
regions
occupations
postType
keywords
employment_type
latitude
longitude
category
region_place_id
address
user
data_seo
seo_data
bannerType
bType
rnd

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`latestNews`
5	`featuredJobs`
6	`studentsJobs`
7	`banners`
8	`featuredCompanies`
9	`jobShareParam`
10	`typeUrl`
11	`lang`
12	`regions`
13	`occupations`
14	`postType`
15	`keywords`
16	`employment_type`
17	`latitude`
18	`longitude`
19	`category`
20	`region_place_id`
21	`address`
22	`user`
23	`data_seo`
24	`seo_data`
25	`bannerType`
26	`bType`
27	`rnd`

public.landing_search.landing_search_form (resources/views/public/landing_search/landing_search_form.blade.php)28blade


obLevel
__env
app
errors
latestNews
featuredJobs
studentsJobs
banners
featuredCompanies
jobShareParam
typeUrl
lang
regions
occupations
postType
keywords
employment_type
latitude
longitude
category
region_place_id
address
user
data_seo
seo_data
bannerType
bType
rnd

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`latestNews`
5	`featuredJobs`
6	`studentsJobs`
7	`banners`
8	`featuredCompanies`
9	`jobShareParam`
10	`typeUrl`
11	`lang`
12	`regions`
13	`occupations`
14	`postType`
15	`keywords`
16	`employment_type`
17	`latitude`
18	`longitude`
19	`category`
20	`region_place_id`
21	`address`
22	`user`
23	`data_seo`
24	`seo_data`
25	`bannerType`
26	`bType`
27	`rnd`

public.layouts.partials.testimonials.testimonials (resources/views/public/layouts/partials/testimonials/testimonials.blade.php)29blade


obLevel
__env
app
errors
latestNews
featuredJobs
studentsJobs
banners
featuredCompanies
jobShareParam
typeUrl
lang
regions
occupations
postType
keywords
employment_type
latitude
longitude
category
region_place_id
address
user
data_seo
seo_data
bannerType
bType
rnd
testimonials

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`latestNews`
5	`featuredJobs`
6	`studentsJobs`
7	`banners`
8	`featuredCompanies`
9	`jobShareParam`
10	`typeUrl`
11	`lang`
12	`regions`
13	`occupations`
14	`postType`
15	`keywords`
16	`employment_type`
17	`latitude`
18	`longitude`
19	`category`
20	`region_place_id`
21	`address`
22	`user`
23	`data_seo`
24	`seo_data`
25	`bannerType`
26	`bType`
27	`rnd`
28	`testimonials`

public.layouts.partials.modules_stats.module_stats (resources/views/public/layouts/partials/modules_stats/module_stats.blade.php)30blade


obLevel
__env
app
errors
latestNews
featuredJobs
studentsJobs
banners
featuredCompanies
jobShareParam
typeUrl
lang
regions
occupations
postType
keywords
employment_type
latitude
longitude
category
region_place_id
address
user
data_seo
seo_data
bannerType
bType
rnd
module
module_trans_sections

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`latestNews`
5	`featuredJobs`
6	`studentsJobs`
7	`banners`
8	`featuredCompanies`
9	`jobShareParam`
10	`typeUrl`
11	`lang`
12	`regions`
13	`occupations`
14	`postType`
15	`keywords`
16	`employment_type`
17	`latitude`
18	`longitude`
19	`category`
20	`region_place_id`
21	`address`
22	`user`
23	`data_seo`
24	`seo_data`
25	`bannerType`
26	`bType`
27	`rnd`
28	`module`
29	`module_trans_sections`

public.layouts.partials._blog-single-post (resources/views/public/layouts/partials/_blog-single-post.blade.php)31blade


obLevel
__env
app
errors
latestNews
featuredJobs
studentsJobs
banners
featuredCompanies
jobShareParam
typeUrl
lang
regions
occupations
postType
keywords
employment_type
latitude
longitude
category
region_place_id
address
user
data_seo
seo_data
bannerType
bType
rnd
__currentLoopData
postSingle
loop

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`latestNews`
5	`featuredJobs`
6	`studentsJobs`
7	`banners`
8	`featuredCompanies`
9	`jobShareParam`
10	`typeUrl`
11	`lang`
12	`regions`
13	`occupations`
14	`postType`
15	`keywords`
16	`employment_type`
17	`latitude`
18	`longitude`
19	`category`
20	`region_place_id`
21	`address`
22	`user`
23	`data_seo`
24	`seo_data`
25	`bannerType`
26	`bType`
27	`rnd`
28	`__currentLoopData`
29	`postSingle`
30	`loop`

public.layouts.partials._blog-single-post (resources/views/public/layouts/partials/_blog-single-post.blade.php)31blade


obLevel
__env
app
errors
latestNews
featuredJobs
studentsJobs
banners
featuredCompanies
jobShareParam
typeUrl
lang
regions
occupations
postType
keywords
employment_type
latitude
longitude
category
region_place_id
address
user
data_seo
seo_data
bannerType
bType
rnd
__currentLoopData
postSingle
loop

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`latestNews`
5	`featuredJobs`
6	`studentsJobs`
7	`banners`
8	`featuredCompanies`
9	`jobShareParam`
10	`typeUrl`
11	`lang`
12	`regions`
13	`occupations`
14	`postType`
15	`keywords`
16	`employment_type`
17	`latitude`
18	`longitude`
19	`category`
20	`region_place_id`
21	`address`
22	`user`
23	`data_seo`
24	`seo_data`
25	`bannerType`
26	`bType`
27	`rnd`
28	`__currentLoopData`
29	`postSingle`
30	`loop`

public.layouts.partials._blog-single-post (resources/views/public/layouts/partials/_blog-single-post.blade.php)31blade


obLevel
__env
app
errors
latestNews
featuredJobs
studentsJobs
banners
featuredCompanies
jobShareParam
typeUrl
lang
regions
occupations
postType
keywords
employment_type
latitude
longitude
category
region_place_id
address
user
data_seo
seo_data
bannerType
bType
rnd
__currentLoopData
postSingle
loop

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`latestNews`
5	`featuredJobs`
6	`studentsJobs`
7	`banners`
8	`featuredCompanies`
9	`jobShareParam`
10	`typeUrl`
11	`lang`
12	`regions`
13	`occupations`
14	`postType`
15	`keywords`
16	`employment_type`
17	`latitude`
18	`longitude`
19	`category`
20	`region_place_id`
21	`address`
22	`user`
23	`data_seo`
24	`seo_data`
25	`bannerType`
26	`bType`
27	`rnd`
28	`__currentLoopData`
29	`postSingle`
30	`loop`

public.layouts.main (resources/views/public/layouts/main.blade.php)31blade


obLevel
__env
app
errors
latestNews
featuredJobs
studentsJobs
banners
featuredCompanies
jobShareParam
typeUrl
lang
regions
occupations
postType
keywords
employment_type
latitude
longitude
category
region_place_id
address
user
data_seo
seo_data
bannerType
bType
rnd
__currentLoopData
postSingle
loop

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`latestNews`
5	`featuredJobs`
6	`studentsJobs`
7	`banners`
8	`featuredCompanies`
9	`jobShareParam`
10	`typeUrl`
11	`lang`
12	`regions`
13	`occupations`
14	`postType`
15	`keywords`
16	`employment_type`
17	`latitude`
18	`longitude`
19	`category`
20	`region_place_id`
21	`address`
22	`user`
23	`data_seo`
24	`seo_data`
25	`bannerType`
26	`bType`
27	`rnd`
28	`__currentLoopData`
29	`postSingle`
30	`loop`

public.layouts.partials._head (resources/views/public/layouts/partials/_head.blade.php)32blade


obLevel
__env
app
errors
latestNews
featuredJobs
studentsJobs
banners
featuredCompanies
jobShareParam
typeUrl
lang
regions
occupations
postType
keywords
employment_type
latitude
longitude
category
region_place_id
address
user
data_seo
seo_data
bannerType
bType
rnd
__currentLoopData
postSingle
loop
userHeader

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`latestNews`
5	`featuredJobs`
6	`studentsJobs`
7	`banners`
8	`featuredCompanies`
9	`jobShareParam`
10	`typeUrl`
11	`lang`
12	`regions`
13	`occupations`
14	`postType`
15	`keywords`
16	`employment_type`
17	`latitude`
18	`longitude`
19	`category`
20	`region_place_id`
21	`address`
22	`user`
23	`data_seo`
24	`seo_data`
25	`bannerType`
26	`bType`
27	`rnd`
28	`__currentLoopData`
29	`postSingle`
30	`loop`
31	`userHeader`

public.layouts.partials._menu (resources/views/public/layouts/partials/_menu.blade.php)35blade


obLevel
__env
app
errors
latestNews
featuredJobs
studentsJobs
banners
featuredCompanies
jobShareParam
typeUrl
lang
regions
occupations
postType
keywords
employment_type
latitude
longitude
category
region_place_id
address
user
data_seo
seo_data
bannerType
bType
rnd
__currentLoopData
postSingle
loop
userHeader
headerMenuHtml
headerMenuHtmlMobile
languages

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`latestNews`
5	`featuredJobs`
6	`studentsJobs`
7	`banners`
8	`featuredCompanies`
9	`jobShareParam`
10	`typeUrl`
11	`lang`
12	`regions`
13	`occupations`
14	`postType`
15	`keywords`
16	`employment_type`
17	`latitude`
18	`longitude`
19	`category`
20	`region_place_id`
21	`address`
22	`user`
23	`data_seo`
24	`seo_data`
25	`bannerType`
26	`bType`
27	`rnd`
28	`__currentLoopData`
29	`postSingle`
30	`loop`
31	`userHeader`
32	`headerMenuHtml`
33	`headerMenuHtmlMobile`
34	`languages`

public.layouts.partials._cta (resources/views/public/layouts/partials/_cta.blade.php)32blade


obLevel
__env
app
errors
latestNews
featuredJobs
studentsJobs
banners
featuredCompanies
jobShareParam
typeUrl
lang
regions
occupations
postType
keywords
employment_type
latitude
longitude
category
region_place_id
address
user
data_seo
seo_data
bannerType
bType
rnd
__currentLoopData
postSingle
loop
userHeader

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`latestNews`
5	`featuredJobs`
6	`studentsJobs`
7	`banners`
8	`featuredCompanies`
9	`jobShareParam`
10	`typeUrl`
11	`lang`
12	`regions`
13	`occupations`
14	`postType`
15	`keywords`
16	`employment_type`
17	`latitude`
18	`longitude`
19	`category`
20	`region_place_id`
21	`address`
22	`user`
23	`data_seo`
24	`seo_data`
25	`bannerType`
26	`bType`
27	`rnd`
28	`__currentLoopData`
29	`postSingle`
30	`loop`
31	`userHeader`

public.layouts.partials._footer (resources/views/public/layouts/partials/_footer.blade.php)33blade


obLevel
__env
app
errors
latestNews
featuredJobs
studentsJobs
banners
featuredCompanies
jobShareParam
typeUrl
lang
regions
occupations
postType
keywords
employment_type
latitude
longitude
category
region_place_id
address
user
data_seo
seo_data
bannerType
bType
rnd
__currentLoopData
postSingle
loop
userHeader
footerMenu

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`latestNews`
5	`featuredJobs`
6	`studentsJobs`
7	`banners`
8	`featuredCompanies`
9	`jobShareParam`
10	`typeUrl`
11	`lang`
12	`regions`
13	`occupations`
14	`postType`
15	`keywords`
16	`employment_type`
17	`latitude`
18	`longitude`
19	`category`
20	`region_place_id`
21	`address`
22	`user`
23	`data_seo`
24	`seo_data`
25	`bannerType`
26	`bType`
27	`rnd`
28	`__currentLoopData`
29	`postSingle`
30	`loop`
31	`userHeader`
32	`footerMenu`

public.layouts.partials._TutorialModal (resources/views/public/layouts/partials/_TutorialModal.blade.php)35blade


obLevel
__env
app
errors
latestNews
featuredJobs
studentsJobs
banners
featuredCompanies
jobShareParam
typeUrl
lang
regions
occupations
postType
keywords
employment_type
latitude
longitude
category
region_place_id
address
user
data_seo
seo_data
bannerType
bType
rnd
__currentLoopData
postSingle
loop
userHeader
footerMenu
year
ycopy

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`latestNews`
5	`featuredJobs`
6	`studentsJobs`
7	`banners`
8	`featuredCompanies`
9	`jobShareParam`
10	`typeUrl`
11	`lang`
12	`regions`
13	`occupations`
14	`postType`
15	`keywords`
16	`employment_type`
17	`latitude`
18	`longitude`
19	`category`
20	`region_place_id`
21	`address`
22	`user`
23	`data_seo`
24	`seo_data`
25	`bannerType`
26	`bType`
27	`rnd`
28	`__currentLoopData`
29	`postSingle`
30	`loop`
31	`userHeader`
32	`footerMenu`
33	`year`
34	`ycopy`

public.layouts.partials.popups.in_footer (resources/views/public/layouts/partials/popups/in_footer.blade.php)40blade


obLevel
__env
app
errors
latestNews
featuredJobs
studentsJobs
banners
featuredCompanies
jobShareParam
typeUrl
lang
regions
occupations
postType
keywords
employment_type
latitude
longitude
category
region_place_id
address
user
data_seo
seo_data
bannerType
bType
rnd
__currentLoopData
postSingle
loop
userHeader
footerMenu
year
ycopy
buttonVisible
showPopup
profileFill
ids
viewHtml

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`latestNews`
5	`featuredJobs`
6	`studentsJobs`
7	`banners`
8	`featuredCompanies`
9	`jobShareParam`
10	`typeUrl`
11	`lang`
12	`regions`
13	`occupations`
14	`postType`
15	`keywords`
16	`employment_type`
17	`latitude`
18	`longitude`
19	`category`
20	`region_place_id`
21	`address`
22	`user`
23	`data_seo`
24	`seo_data`
25	`bannerType`
26	`bType`
27	`rnd`
28	`__currentLoopData`
29	`postSingle`
30	`loop`
31	`userHeader`
32	`footerMenu`
33	`year`
34	`ycopy`
35	`buttonVisible`
36	`showPopup`
37	`profileFill`
38	`ids`
39	`viewHtml`

public.layouts.partials._social_login (resources/views/public/layouts/partials/_social_login.blade.php)41blade


obLevel
__env
app
errors
latestNews
featuredJobs
studentsJobs
banners
featuredCompanies
jobShareParam
typeUrl
lang
regions
occupations
postType
keywords
employment_type
latitude
longitude
category
region_place_id
address
user
data_seo
seo_data
bannerType
bType
rnd
__currentLoopData
postSingle
loop
userHeader
footerMenu
year
ycopy
buttonVisible
v
cF
jsFile
countries
langs

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`latestNews`
5	`featuredJobs`
6	`studentsJobs`
7	`banners`
8	`featuredCompanies`
9	`jobShareParam`
10	`typeUrl`
11	`lang`
12	`regions`
13	`occupations`
14	`postType`
15	`keywords`
16	`employment_type`
17	`latitude`
18	`longitude`
19	`category`
20	`region_place_id`
21	`address`
22	`user`
23	`data_seo`
24	`seo_data`
25	`bannerType`
26	`bType`
27	`rnd`
28	`__currentLoopData`
29	`postSingle`
30	`loop`
31	`userHeader`
32	`footerMenu`
33	`year`
34	`ycopy`
35	`buttonVisible`
36	`v`
37	`cF`
38	`jsFile`
39	`countries`
40	`langs`

uri: GET al
middleware: web
controller: \App\Http\Controllers\FrontEnd\FrontEndController@landing
namespace: App\Http\Controllers
prefix
where
as: home
file: app/Http/Controllers/FrontEnd/FrontEndController.php:69-135

79 statements were executed, 52 of which were duplicated, 27 unique62.77ms

select count(*) as aggregate from `posts` left join `categories` on `posts`.`category_id` = `categories`.`id` left join `categories_trans` on `categories`.`id` = `categories_trans`.`category_id` where `posts`.`language_id` = 7 and `categories_trans`.`language_id` = 7 and (`categories`.`type` = 'blog' or `categories`.`type` = 'news') and `is_featured` = 1 and `is_published` = 1

710μs/app/Models/Post.php:664pick

Metadata

Bindings

0. 7
1. 7
2. blog
3. news
4. 1
5. 1

Backtrace

15. /app/Models/Post.php:664
16. /app/Http/Controllers/FrontEnd/FrontEndController.php:84
19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
22. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
23. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
24. /app/Http/Controllers/Controller.php:36
25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
26. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
27. /app/Http/Middleware/Localization.php:64
28. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
29. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
30. middleware::bindings:41
31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
32. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
33. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75
34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
35. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
36. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
37. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
38. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
39. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
41. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
42. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
43. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
45. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104
49. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select `posts`.*, `categories`.`type`, `categories_trans`.`title` as `category_name`, `categories_trans`.`slug` as `categorySlug` from `posts` left join `categories` on `posts`.`category_id` = `categories`.`id` left join `categories_trans` on `categories`.`id` = `categories_trans`.`category_id` where `posts`.`language_id` = 7 and `categories_trans`.`language_id` = 7 and (`categories`.`type` = 'blog' or `categories`.`type` = 'news') and `is_featured` = 1 and `is_published` = 1 order by `posts`.`published_at` desc limit 3 offset 0

600μs/app/Models/Post.php:664pick

Metadata
Bindings	0. 7 1. 7 2. blog 3. news 4. 1 5. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Models/Post.php:664 16. /app/Http/Controllers/FrontEnd/FrontEndController.php:84 19. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 21. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 22. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 23. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 24. /app/Http/Controllers/Controller.php:36 25. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 26. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 27. /app/Http/Middleware/Localization.php:64 28. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 29. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 30. middleware::bindings:41 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 32. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 33. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 35. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 36. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 37. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 38. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 39. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 41. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 42. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 43. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 45. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104 49. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682

select `region_place_id`, `region` from `jobs` where `country_id` = 55 and `region` <> '' group by `region_place_id` order by `region` asc

3.5ms/app/Http/Controllers/FrontEnd/FrontEndController.php:100pick

Metadata
Bindings	0. 55 1.
Backtrace	12. /app/Http/Controllers/FrontEnd/FrontEndController.php:100 15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 18. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 19. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 20. /app/Http/Controllers/Controller.php:36 21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 22. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 23. /app/Http/Middleware/Localization.php:64 24. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 25. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 26. middleware::bindings:41 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 28. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 29. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 31. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 32. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 34. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 35. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56 36. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 37. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 38. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 40. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 41. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104 45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:657 47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:623 48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:612 49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176

Metadata

Bindings

0. 55
1.

Backtrace

12. /app/Http/Controllers/FrontEnd/FrontEndController.php:100
15. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45
16. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219
17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176
18. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
19. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
20. /app/Http/Controllers/Controller.php:36
21. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
22. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
23. /app/Http/Middleware/Localization.php:64
24. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
25. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
26. middleware::bindings:41
27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
28. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
29. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75
30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
31. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
32. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49
33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
34. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
35. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56
36. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
37. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
38. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37
39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
40. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
41. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66
42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682
46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:657
47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:623
48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:612
49. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Kernel.php:176

select `banners`.`url`, `banners`.`image`, `banners`.`dimensions`, `banners`.`custom_code`, `banners`.`langs`, `banners`.`banner_position`, `banners`.`id` from `banners` where `banners`.`banner_status` = 1 and `banners`.`published_at` <= '2025-05-05 16:53:42' and (`banners`.`lasts_until` >= '2025-05-05 16:53:42' or `banners`.`lasts_until` = '0000-00-00 00:00:00') and (`banners`.`langs` like '%sq%') and `banners`.`banner_position` LIKE 'landing%' order by RAND()

810μs/app/Repositories/BannerRepository.php:61pick

Metadata
Bindings	0. 1 1. 2025-05-05 16:53:42 2. 2025-05-05 16:53:42 3. 0000-00-00 00:00:00 4. %sq% 5. landing%
Hints	`ORDER BY RAND()` is slow, try to avoid if you can. You can read this or this
Backtrace	14. /app/Repositories/BannerRepository.php:61 15. /app/Http/Controllers/FrontEnd/FrontEndController.php:107 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 22. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 23. /app/Http/Controllers/Controller.php:36 24. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 25. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 26. /app/Http/Middleware/Localization.php:64 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 28. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 29. middleware::bindings:41 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 31. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 32. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 34. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 35. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 36. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 37. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 38. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 40. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 41. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 44. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104 48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 49. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:657

select * from `settings_languages` where `slug` = 'hr' limit 16.02ms/app/Models/Language.php:55pick

Metadata
Bindings	0. hr
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	16. /app/Models/Language.php:55 17. /app/Models/Language.php:89 18. /app/Models/Language.php:137 19. /app/Models/Traits/ColumnManipulation.php:58 20. /app/Models/Occupation.php:130 21. /app/Http/Controllers/FrontEnd/FrontEndController.php:110 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 26. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 27. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 28. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 29. /app/Http/Controllers/Controller.php:36 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 31. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 32. /app/Http/Middleware/Localization.php:64 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 34. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 35. middleware::bindings:41 36. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 37. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 38. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 40. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 41. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 44. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select `occupations`.`id`, `occupations`.`parent_id`, coalesce(sq_occupations_trans.occupation_name, hr_occupations_trans.occupation_name) as name from `occupations` left join `occupations_trans` as `sq_occupations_trans` on `sq_occupations_trans`.`occupation_id` = `occupations`.`id` and `sq_occupations_trans`.`language_id` = 7 left join `occupations_trans` as `hr_occupations_trans` on `hr_occupations_trans`.`occupation_id` = `occupations`.`id` and `hr_occupations_trans`.`language_id` = 2 order by `name` asc

1.36ms/app/Models/Occupation.php:136pick

Metadata
Bindings	0. 7 1. 2
Hints	The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	14. /app/Models/Occupation.php:136 15. /app/Http/Controllers/FrontEnd/FrontEndController.php:110 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 22. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 23. /app/Http/Controllers/Controller.php:36 24. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 25. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 26. /app/Http/Middleware/Localization.php:64 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 28. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 29. middleware::bindings:41 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 31. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 32. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 34. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 35. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 36. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 37. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 38. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 40. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 41. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 44. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104 48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 49. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:657

select `posts`.*, `categories_trans`.`title` as `category_name`, `categories_trans`.`slug` as `categorySlug` from `posts` left join `categories` on `posts`.`category_id` = `categories`.`id` left join `categories_trans` on `categories`.`id` = `categories_trans`.`category_id` where `categories`.`type` = 'testimonials' and `posts`.`language_id` = 7 and `categories_trans`.`language_id` = 7 and `is_published` = 1 order by `posts`.`created_at` desc limit 10

3.61ms/app/Models/Post.php:423pick

Metadata
Bindings	0. testimonials 1. 7 2. 7 3. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Models/Post.php:423 15. /app/Providers/ViewServiceProvider.php:297 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 19. /vendor/laravel/framework/src/Illuminate/View/View.php:123 20. /vendor/laravel/framework/src/Illuminate/View/View.php:90 21. view::public.landing:238 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/laravel/framework/src/Illuminate/View/View.php:142 25. /vendor/laravel/framework/src/Illuminate/View/View.php:125 26. /vendor/laravel/framework/src/Illuminate/View/View.php:90 27. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 28. /vendor/symfony/http-foundation/Response.php:202 29. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 30. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 31. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 32. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 33. /app/Http/Controllers/Controller.php:36 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 35. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 36. /app/Http/Middleware/Localization.php:64 37. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 38. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 39. middleware::bindings:41 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 41. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 42. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 43. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 45. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select * from `settings_languages` where `is_active` = 1 group by `slug` order by `order_num` asc390μs/app/Models/Language.php:108pick

Metadata
Bindings	0. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	14. /app/Models/Language.php:108 15. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 16. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 17. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 18. /app/Models/Language.php:109 19. /app/Models/Language.php:122 20. /app/Providers/ViewServiceProvider.php:346 23. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 24. /vendor/laravel/framework/src/Illuminate/View/View.php:123 25. /vendor/laravel/framework/src/Illuminate/View/View.php:90 26. view::public.landing:239 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 33. /vendor/symfony/http-foundation/Response.php:202 34. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 37. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 38. /app/Http/Controllers/Controller.php:36 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 40. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 41. /app/Http/Middleware/Localization.php:64 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 44. middleware::bindings:41 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select modules.id as id,modules.is_active as is_active, modules_trans.id as trans_id,modules_trans.title as title,modules_trans.description as description from `modules` left join `modules_trans` on `modules`.`id` = `modules_trans`.`module_id` where `modules_trans`.`language_id` = 7 and `modules`.`deleted_at` = '0000-00-00 00:00:00' and `modules`.`is_active` = 1 and `modules`.`tpl` = 1 order by RAND()

360μs/app/Providers/ViewServiceProvider.php:360pick

Metadata
Bindings	0. 7 1. 0000-00-00 00:00:00 2. 1 3. 1
Hints	`ORDER BY RAND()` is slow, try to avoid if you can. You can read this or this
Backtrace	12. /app/Providers/ViewServiceProvider.php:360 15. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 16. /vendor/laravel/framework/src/Illuminate/View/View.php:123 17. /vendor/laravel/framework/src/Illuminate/View/View.php:90 18. view::public.landing:239 20. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 21. /vendor/laravel/framework/src/Illuminate/View/View.php:142 22. /vendor/laravel/framework/src/Illuminate/View/View.php:125 23. /vendor/laravel/framework/src/Illuminate/View/View.php:90 24. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 25. /vendor/symfony/http-foundation/Response.php:202 26. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 27. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 28. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 29. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 30. /app/Http/Controllers/Controller.php:36 31. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 32. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 33. /app/Http/Middleware/Localization.php:64 34. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 35. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 36. middleware::bindings:41 37. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 38. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 39. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 40. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 41. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 42. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 43. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 45. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select * from `menus` where `menu_type` = '0' limit 1300μs/app/Services/MenuService.php:75pick

Metadata
Bindings	0. 0
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /app/Services/MenuService.php:75 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 18. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 19. /app/Services/MenuService.php:106 20. /app/Providers/ViewServiceProvider.php:104 23. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 24. /vendor/laravel/framework/src/Illuminate/View/View.php:123 25. /vendor/laravel/framework/src/Illuminate/View/View.php:90 26. view::public.layouts.main:28 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`menu_id` = 2 and `menus_items`.`menu_id` is not null and `language_id` = 7 and `parent_id` = '0' order by `menu_order` asc

610μs/app/Models/Menu.php:72pick

Metadata
Bindings	0. 2 1. 7 2. 0
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Models/Menu.php:72 16. /app/Services/MenuService.php:80 17. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 18. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 19. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 20. /app/Services/MenuService.php:106 21. /app/Providers/ViewServiceProvider.php:104 24. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 25. /vendor/laravel/framework/src/Illuminate/View/View.php:123 26. /vendor/laravel/framework/src/Illuminate/View/View.php:90 27. view::public.layouts.main:28 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 30. /vendor/laravel/framework/src/Illuminate/View/View.php:142 31. /vendor/laravel/framework/src/Illuminate/View/View.php:125 32. /vendor/laravel/framework/src/Illuminate/View/View.php:90 33. view::public.landing:548 35. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 36. /vendor/laravel/framework/src/Illuminate/View/View.php:142 37. /vendor/laravel/framework/src/Illuminate/View/View.php:125 38. /vendor/laravel/framework/src/Illuminate/View/View.php:90 39. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 40. /vendor/symfony/http-foundation/Response.php:202 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 45. /app/Http/Controllers/Controller.php:36 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /app/Http/Middleware/Localization.php:64 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select * from `menus_items` where `menus_items`.`parent_id` in (390, 391, 395, 398, 399) order by `menu_order` asc400μs/app/Models/Menu.php:72pick

Metadata

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /app/Models/Menu.php:72 21. /app/Services/MenuService.php:80 22. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 23. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 24. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 25. /app/Services/MenuService.php:106 26. /app/Providers/ViewServiceProvider.php:104 29. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 30. /vendor/laravel/framework/src/Illuminate/View/View.php:123 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.layouts.main:28 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. view::public.landing:548 40. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 41. /vendor/laravel/framework/src/Illuminate/View/View.php:142 42. /vendor/laravel/framework/src/Illuminate/View/View.php:125 43. /vendor/laravel/framework/src/Illuminate/View/View.php:90 44. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 45. /vendor/symfony/http-foundation/Response.php:202 46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Models/Menu.php:72
21. /app/Services/MenuService.php:80
22. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
23. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
24. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
25. /app/Services/MenuService.php:106
26. /app/Providers/ViewServiceProvider.php:104
29. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
30. /vendor/laravel/framework/src/Illuminate/View/View.php:123
31. /vendor/laravel/framework/src/Illuminate/View/View.php:90
32. view::public.layouts.main:28
34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
35. /vendor/laravel/framework/src/Illuminate/View/View.php:142
36. /vendor/laravel/framework/src/Illuminate/View/View.php:125
37. /vendor/laravel/framework/src/Illuminate/View/View.php:90
38. view::public.landing:548
40. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
41. /vendor/laravel/framework/src/Illuminate/View/View.php:142
42. /vendor/laravel/framework/src/Illuminate/View/View.php:125
43. /vendor/laravel/framework/src/Illuminate/View/View.php:90
44. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
45. /vendor/symfony/http-foundation/Response.php:202
46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30

select * from `menus_items` where `menus_items`.`parent_id` in (392, 393, 394, 396, 397, 401, 402, 403) order by `menu_order` asc

440μs/app/Models/Menu.php:72pick

Metadata

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	25. /app/Models/Menu.php:72 26. /app/Services/MenuService.php:80 27. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 28. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 29. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 30. /app/Services/MenuService.php:106 31. /app/Providers/ViewServiceProvider.php:104 34. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 35. /vendor/laravel/framework/src/Illuminate/View/View.php:123 36. /vendor/laravel/framework/src/Illuminate/View/View.php:90 37. view::public.layouts.main:28 39. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 40. /vendor/laravel/framework/src/Illuminate/View/View.php:142 41. /vendor/laravel/framework/src/Illuminate/View/View.php:125 42. /vendor/laravel/framework/src/Illuminate/View/View.php:90 43. view::public.landing:548 45. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 46. /vendor/laravel/framework/src/Illuminate/View/View.php:142 47. /vendor/laravel/framework/src/Illuminate/View/View.php:125 48. /vendor/laravel/framework/src/Illuminate/View/View.php:90 49. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42

Hints

Use SELECT * only if you need all columns from table

Backtrace

25. /app/Models/Menu.php:72
26. /app/Services/MenuService.php:80
27. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
28. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
29. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
30. /app/Services/MenuService.php:106
31. /app/Providers/ViewServiceProvider.php:104
34. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
35. /vendor/laravel/framework/src/Illuminate/View/View.php:123
36. /vendor/laravel/framework/src/Illuminate/View/View.php:90
37. view::public.layouts.main:28
39. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
40. /vendor/laravel/framework/src/Illuminate/View/View.php:142
41. /vendor/laravel/framework/src/Illuminate/View/View.php:125
42. /vendor/laravel/framework/src/Illuminate/View/View.php:90
43. view::public.landing:548
45. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
46. /vendor/laravel/framework/src/Illuminate/View/View.php:142
47. /vendor/laravel/framework/src/Illuminate/View/View.php:125
48. /vendor/laravel/framework/src/Illuminate/View/View.php:90
49. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42

select * from `menus_items` where `menus_items`.`parent_id` = 390 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc

270μs/app/Services/MenuService.php:85pick

Metadata
Bindings	0. 390
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Services/MenuService.php:85 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 18. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 19. /app/Services/MenuService.php:106 20. /app/Providers/ViewServiceProvider.php:104 23. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 24. /vendor/laravel/framework/src/Illuminate/View/View.php:123 25. /vendor/laravel/framework/src/Illuminate/View/View.php:90 26. view::public.layouts.main:28 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` = 391 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc

3.08ms/app/Services/MenuService.php:85pick

Metadata
Bindings	0. 391
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Services/MenuService.php:85 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 18. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 19. /app/Services/MenuService.php:106 20. /app/Providers/ViewServiceProvider.php:104 23. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 24. /vendor/laravel/framework/src/Illuminate/View/View.php:123 25. /vendor/laravel/framework/src/Illuminate/View/View.php:90 26. view::public.layouts.main:28 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` in (392, 393, 394) order by `menu_order` asc270μs/app/Services/MenuService.php:85pick

Metadata

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /app/Services/MenuService.php:85 21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 23. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 24. /app/Services/MenuService.php:106 25. /app/Providers/ViewServiceProvider.php:104 28. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 29. /vendor/laravel/framework/src/Illuminate/View/View.php:123 30. /vendor/laravel/framework/src/Illuminate/View/View.php:90 31. view::public.layouts.main:28 33. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 34. /vendor/laravel/framework/src/Illuminate/View/View.php:142 35. /vendor/laravel/framework/src/Illuminate/View/View.php:125 36. /vendor/laravel/framework/src/Illuminate/View/View.php:90 37. view::public.landing:548 39. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 40. /vendor/laravel/framework/src/Illuminate/View/View.php:142 41. /vendor/laravel/framework/src/Illuminate/View/View.php:125 42. /vendor/laravel/framework/src/Illuminate/View/View.php:90 43. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 44. /vendor/symfony/http-foundation/Response.php:202 45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 49. /app/Http/Controllers/Controller.php:36

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Services/MenuService.php:85
21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
23. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
24. /app/Services/MenuService.php:106
25. /app/Providers/ViewServiceProvider.php:104
28. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
29. /vendor/laravel/framework/src/Illuminate/View/View.php:123
30. /vendor/laravel/framework/src/Illuminate/View/View.php:90
31. view::public.layouts.main:28
33. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
34. /vendor/laravel/framework/src/Illuminate/View/View.php:142
35. /vendor/laravel/framework/src/Illuminate/View/View.php:125
36. /vendor/laravel/framework/src/Illuminate/View/View.php:90
37. view::public.landing:548
39. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
40. /vendor/laravel/framework/src/Illuminate/View/View.php:142
41. /vendor/laravel/framework/src/Illuminate/View/View.php:125
42. /vendor/laravel/framework/src/Illuminate/View/View.php:90
43. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
44. /vendor/symfony/http-foundation/Response.php:202
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
49. /app/Http/Controllers/Controller.php:36

select * from `menus_items` where `menus_items`.`parent_id` = 391 and `menus_items`.`parent_id` is not null order by `menu_order` asc

300μs/app/Models/MenuItem.php:107pick

Metadata
Bindings	0. 391
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Models/MenuItem.php:107 16. /app/Services/MenuService.php:100 17. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 18. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 19. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 20. /app/Services/MenuService.php:106 21. /app/Providers/ViewServiceProvider.php:104 24. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 25. /vendor/laravel/framework/src/Illuminate/View/View.php:123 26. /vendor/laravel/framework/src/Illuminate/View/View.php:90 27. view::public.layouts.main:28 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 30. /vendor/laravel/framework/src/Illuminate/View/View.php:142 31. /vendor/laravel/framework/src/Illuminate/View/View.php:125 32. /vendor/laravel/framework/src/Illuminate/View/View.php:90 33. view::public.landing:548 35. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 36. /vendor/laravel/framework/src/Illuminate/View/View.php:142 37. /vendor/laravel/framework/src/Illuminate/View/View.php:125 38. /vendor/laravel/framework/src/Illuminate/View/View.php:90 39. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 40. /vendor/symfony/http-foundation/Response.php:202 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 45. /app/Http/Controllers/Controller.php:36 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /app/Http/Middleware/Localization.php:64 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select * from `menus_items` where `menus_items`.`parent_id` in (392, 393, 394) order by `menu_order` asc260μs/app/Models/MenuItem.php:107pick

Metadata

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /app/Models/MenuItem.php:107 21. /app/Services/MenuService.php:100 22. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 23. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 24. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 25. /app/Services/MenuService.php:106 26. /app/Providers/ViewServiceProvider.php:104 29. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 30. /vendor/laravel/framework/src/Illuminate/View/View.php:123 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.layouts.main:28 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. view::public.landing:548 40. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 41. /vendor/laravel/framework/src/Illuminate/View/View.php:142 42. /vendor/laravel/framework/src/Illuminate/View/View.php:125 43. /vendor/laravel/framework/src/Illuminate/View/View.php:90 44. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 45. /vendor/symfony/http-foundation/Response.php:202 46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Models/MenuItem.php:107
21. /app/Services/MenuService.php:100
22. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
23. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
24. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
25. /app/Services/MenuService.php:106
26. /app/Providers/ViewServiceProvider.php:104
29. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
30. /vendor/laravel/framework/src/Illuminate/View/View.php:123
31. /vendor/laravel/framework/src/Illuminate/View/View.php:90
32. view::public.layouts.main:28
34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
35. /vendor/laravel/framework/src/Illuminate/View/View.php:142
36. /vendor/laravel/framework/src/Illuminate/View/View.php:125
37. /vendor/laravel/framework/src/Illuminate/View/View.php:90
38. view::public.landing:548
40. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
41. /vendor/laravel/framework/src/Illuminate/View/View.php:142
42. /vendor/laravel/framework/src/Illuminate/View/View.php:125
43. /vendor/laravel/framework/src/Illuminate/View/View.php:90
44. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
45. /vendor/symfony/http-foundation/Response.php:202
46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30

select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 392 and `menus_items`.`parent_id` is not null

240μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick

Metadata
Bindings	0. 392
Backtrace	15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 17. /app/Models/MenuItem.php:109 18. /app/Services/MenuService.php:100 19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 21. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 22. /app/Services/MenuService.php:106 23. /app/Providers/ViewServiceProvider.php:104 26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 27. /vendor/laravel/framework/src/Illuminate/View/View.php:123 28. /vendor/laravel/framework/src/Illuminate/View/View.php:90 29. view::public.layouts.main:28 31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 32. /vendor/laravel/framework/src/Illuminate/View/View.php:142 33. /vendor/laravel/framework/src/Illuminate/View/View.php:125 34. /vendor/laravel/framework/src/Illuminate/View/View.php:90 35. view::public.landing:548 37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 38. /vendor/laravel/framework/src/Illuminate/View/View.php:142 39. /vendor/laravel/framework/src/Illuminate/View/View.php:125 40. /vendor/laravel/framework/src/Illuminate/View/View.php:90 41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 42. /vendor/symfony/http-foundation/Response.php:202 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 47. /app/Http/Controllers/Controller.php:36 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

Metadata

Bindings

0. 392

Backtrace

15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
17. /app/Models/MenuItem.php:109
18. /app/Services/MenuService.php:100
19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
21. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
22. /app/Services/MenuService.php:106
23. /app/Providers/ViewServiceProvider.php:104
26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
27. /vendor/laravel/framework/src/Illuminate/View/View.php:123
28. /vendor/laravel/framework/src/Illuminate/View/View.php:90
29. view::public.layouts.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 393 and `menus_items`.`parent_id` is not null

230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick

Metadata
Bindings	0. 393
Backtrace	15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 17. /app/Models/MenuItem.php:109 18. /app/Services/MenuService.php:100 19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 21. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 22. /app/Services/MenuService.php:106 23. /app/Providers/ViewServiceProvider.php:104 26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 27. /vendor/laravel/framework/src/Illuminate/View/View.php:123 28. /vendor/laravel/framework/src/Illuminate/View/View.php:90 29. view::public.layouts.main:28 31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 32. /vendor/laravel/framework/src/Illuminate/View/View.php:142 33. /vendor/laravel/framework/src/Illuminate/View/View.php:125 34. /vendor/laravel/framework/src/Illuminate/View/View.php:90 35. view::public.landing:548 37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 38. /vendor/laravel/framework/src/Illuminate/View/View.php:142 39. /vendor/laravel/framework/src/Illuminate/View/View.php:125 40. /vendor/laravel/framework/src/Illuminate/View/View.php:90 41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 42. /vendor/symfony/http-foundation/Response.php:202 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 47. /app/Http/Controllers/Controller.php:36 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

Metadata

Bindings

0. 393

Backtrace

15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
17. /app/Models/MenuItem.php:109
18. /app/Services/MenuService.php:100
19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
21. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
22. /app/Services/MenuService.php:106
23. /app/Providers/ViewServiceProvider.php:104
26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
27. /vendor/laravel/framework/src/Illuminate/View/View.php:123
28. /vendor/laravel/framework/src/Illuminate/View/View.php:90
29. view::public.layouts.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 394 and `menus_items`.`parent_id` is not null

220μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick

Metadata
Bindings	0. 394
Backtrace	15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 17. /app/Models/MenuItem.php:109 18. /app/Services/MenuService.php:100 19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 21. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 22. /app/Services/MenuService.php:106 23. /app/Providers/ViewServiceProvider.php:104 26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 27. /vendor/laravel/framework/src/Illuminate/View/View.php:123 28. /vendor/laravel/framework/src/Illuminate/View/View.php:90 29. view::public.layouts.main:28 31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 32. /vendor/laravel/framework/src/Illuminate/View/View.php:142 33. /vendor/laravel/framework/src/Illuminate/View/View.php:125 34. /vendor/laravel/framework/src/Illuminate/View/View.php:90 35. view::public.landing:548 37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 38. /vendor/laravel/framework/src/Illuminate/View/View.php:142 39. /vendor/laravel/framework/src/Illuminate/View/View.php:125 40. /vendor/laravel/framework/src/Illuminate/View/View.php:90 41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 42. /vendor/symfony/http-foundation/Response.php:202 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 47. /app/Http/Controllers/Controller.php:36 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

Metadata

Bindings

0. 394

Backtrace

15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
17. /app/Models/MenuItem.php:109
18. /app/Services/MenuService.php:100
19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
21. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
22. /app/Services/MenuService.php:106
23. /app/Providers/ViewServiceProvider.php:104
26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
27. /vendor/laravel/framework/src/Illuminate/View/View.php:123
28. /vendor/laravel/framework/src/Illuminate/View/View.php:90
29. view::public.layouts.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` = 395 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc

440μs/app/Services/MenuService.php:85pick

Metadata
Bindings	0. 395
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Services/MenuService.php:85 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 18. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 19. /app/Services/MenuService.php:106 20. /app/Providers/ViewServiceProvider.php:104 23. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 24. /vendor/laravel/framework/src/Illuminate/View/View.php:123 25. /vendor/laravel/framework/src/Illuminate/View/View.php:90 26. view::public.layouts.main:28 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` in (396, 397) order by `menu_order` asc280μs/app/Services/MenuService.php:85pick

Metadata

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /app/Services/MenuService.php:85 21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 23. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 24. /app/Services/MenuService.php:106 25. /app/Providers/ViewServiceProvider.php:104 28. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 29. /vendor/laravel/framework/src/Illuminate/View/View.php:123 30. /vendor/laravel/framework/src/Illuminate/View/View.php:90 31. view::public.layouts.main:28 33. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 34. /vendor/laravel/framework/src/Illuminate/View/View.php:142 35. /vendor/laravel/framework/src/Illuminate/View/View.php:125 36. /vendor/laravel/framework/src/Illuminate/View/View.php:90 37. view::public.landing:548 39. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 40. /vendor/laravel/framework/src/Illuminate/View/View.php:142 41. /vendor/laravel/framework/src/Illuminate/View/View.php:125 42. /vendor/laravel/framework/src/Illuminate/View/View.php:90 43. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 44. /vendor/symfony/http-foundation/Response.php:202 45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 49. /app/Http/Controllers/Controller.php:36

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Services/MenuService.php:85
21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
23. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
24. /app/Services/MenuService.php:106
25. /app/Providers/ViewServiceProvider.php:104
28. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
29. /vendor/laravel/framework/src/Illuminate/View/View.php:123
30. /vendor/laravel/framework/src/Illuminate/View/View.php:90
31. view::public.layouts.main:28
33. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
34. /vendor/laravel/framework/src/Illuminate/View/View.php:142
35. /vendor/laravel/framework/src/Illuminate/View/View.php:125
36. /vendor/laravel/framework/src/Illuminate/View/View.php:90
37. view::public.landing:548
39. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
40. /vendor/laravel/framework/src/Illuminate/View/View.php:142
41. /vendor/laravel/framework/src/Illuminate/View/View.php:125
42. /vendor/laravel/framework/src/Illuminate/View/View.php:90
43. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
44. /vendor/symfony/http-foundation/Response.php:202
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
49. /app/Http/Controllers/Controller.php:36

select * from `menus_items` where `menus_items`.`parent_id` = 395 and `menus_items`.`parent_id` is not null order by `menu_order` asc

290μs/app/Models/MenuItem.php:107pick

Metadata
Bindings	0. 395
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Models/MenuItem.php:107 16. /app/Services/MenuService.php:100 17. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 18. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 19. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 20. /app/Services/MenuService.php:106 21. /app/Providers/ViewServiceProvider.php:104 24. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 25. /vendor/laravel/framework/src/Illuminate/View/View.php:123 26. /vendor/laravel/framework/src/Illuminate/View/View.php:90 27. view::public.layouts.main:28 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 30. /vendor/laravel/framework/src/Illuminate/View/View.php:142 31. /vendor/laravel/framework/src/Illuminate/View/View.php:125 32. /vendor/laravel/framework/src/Illuminate/View/View.php:90 33. view::public.landing:548 35. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 36. /vendor/laravel/framework/src/Illuminate/View/View.php:142 37. /vendor/laravel/framework/src/Illuminate/View/View.php:125 38. /vendor/laravel/framework/src/Illuminate/View/View.php:90 39. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 40. /vendor/symfony/http-foundation/Response.php:202 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 45. /app/Http/Controllers/Controller.php:36 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /app/Http/Middleware/Localization.php:64 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select * from `menus_items` where `menus_items`.`parent_id` in (396, 397) order by `menu_order` asc250μs/app/Models/MenuItem.php:107pick

Metadata

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /app/Models/MenuItem.php:107 21. /app/Services/MenuService.php:100 22. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 23. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 24. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 25. /app/Services/MenuService.php:106 26. /app/Providers/ViewServiceProvider.php:104 29. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 30. /vendor/laravel/framework/src/Illuminate/View/View.php:123 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.layouts.main:28 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. view::public.landing:548 40. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 41. /vendor/laravel/framework/src/Illuminate/View/View.php:142 42. /vendor/laravel/framework/src/Illuminate/View/View.php:125 43. /vendor/laravel/framework/src/Illuminate/View/View.php:90 44. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 45. /vendor/symfony/http-foundation/Response.php:202 46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Models/MenuItem.php:107
21. /app/Services/MenuService.php:100
22. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
23. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
24. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
25. /app/Services/MenuService.php:106
26. /app/Providers/ViewServiceProvider.php:104
29. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
30. /vendor/laravel/framework/src/Illuminate/View/View.php:123
31. /vendor/laravel/framework/src/Illuminate/View/View.php:90
32. view::public.layouts.main:28
34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
35. /vendor/laravel/framework/src/Illuminate/View/View.php:142
36. /vendor/laravel/framework/src/Illuminate/View/View.php:125
37. /vendor/laravel/framework/src/Illuminate/View/View.php:90
38. view::public.landing:548
40. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
41. /vendor/laravel/framework/src/Illuminate/View/View.php:142
42. /vendor/laravel/framework/src/Illuminate/View/View.php:125
43. /vendor/laravel/framework/src/Illuminate/View/View.php:90
44. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
45. /vendor/symfony/http-foundation/Response.php:202
46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30

select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 396 and `menus_items`.`parent_id` is not null

230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick

Metadata
Bindings	0. 396
Backtrace	15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 17. /app/Models/MenuItem.php:109 18. /app/Services/MenuService.php:100 19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 21. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 22. /app/Services/MenuService.php:106 23. /app/Providers/ViewServiceProvider.php:104 26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 27. /vendor/laravel/framework/src/Illuminate/View/View.php:123 28. /vendor/laravel/framework/src/Illuminate/View/View.php:90 29. view::public.layouts.main:28 31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 32. /vendor/laravel/framework/src/Illuminate/View/View.php:142 33. /vendor/laravel/framework/src/Illuminate/View/View.php:125 34. /vendor/laravel/framework/src/Illuminate/View/View.php:90 35. view::public.landing:548 37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 38. /vendor/laravel/framework/src/Illuminate/View/View.php:142 39. /vendor/laravel/framework/src/Illuminate/View/View.php:125 40. /vendor/laravel/framework/src/Illuminate/View/View.php:90 41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 42. /vendor/symfony/http-foundation/Response.php:202 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 47. /app/Http/Controllers/Controller.php:36 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

Metadata

Bindings

0. 396

Backtrace

15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
17. /app/Models/MenuItem.php:109
18. /app/Services/MenuService.php:100
19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
21. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
22. /app/Services/MenuService.php:106
23. /app/Providers/ViewServiceProvider.php:104
26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
27. /vendor/laravel/framework/src/Illuminate/View/View.php:123
28. /vendor/laravel/framework/src/Illuminate/View/View.php:90
29. view::public.layouts.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 397 and `menus_items`.`parent_id` is not null

210μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick

Metadata
Bindings	0. 397
Backtrace	15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 17. /app/Models/MenuItem.php:109 18. /app/Services/MenuService.php:100 19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 21. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 22. /app/Services/MenuService.php:106 23. /app/Providers/ViewServiceProvider.php:104 26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 27. /vendor/laravel/framework/src/Illuminate/View/View.php:123 28. /vendor/laravel/framework/src/Illuminate/View/View.php:90 29. view::public.layouts.main:28 31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 32. /vendor/laravel/framework/src/Illuminate/View/View.php:142 33. /vendor/laravel/framework/src/Illuminate/View/View.php:125 34. /vendor/laravel/framework/src/Illuminate/View/View.php:90 35. view::public.landing:548 37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 38. /vendor/laravel/framework/src/Illuminate/View/View.php:142 39. /vendor/laravel/framework/src/Illuminate/View/View.php:125 40. /vendor/laravel/framework/src/Illuminate/View/View.php:90 41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 42. /vendor/symfony/http-foundation/Response.php:202 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 47. /app/Http/Controllers/Controller.php:36 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

Metadata

Bindings

0. 397

Backtrace

15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
17. /app/Models/MenuItem.php:109
18. /app/Services/MenuService.php:100
19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
21. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
22. /app/Services/MenuService.php:106
23. /app/Providers/ViewServiceProvider.php:104
26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
27. /vendor/laravel/framework/src/Illuminate/View/View.php:123
28. /vendor/laravel/framework/src/Illuminate/View/View.php:90
29. view::public.layouts.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` = 398 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc

280μs/app/Services/MenuService.php:85pick

Metadata
Bindings	0. 398
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Services/MenuService.php:85 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 18. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 19. /app/Services/MenuService.php:106 20. /app/Providers/ViewServiceProvider.php:104 23. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 24. /vendor/laravel/framework/src/Illuminate/View/View.php:123 25. /vendor/laravel/framework/src/Illuminate/View/View.php:90 26. view::public.layouts.main:28 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` = 399 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc

300μs/app/Services/MenuService.php:85pick

Metadata
Bindings	0. 399
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Services/MenuService.php:85 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 18. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 19. /app/Services/MenuService.php:106 20. /app/Providers/ViewServiceProvider.php:104 23. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 24. /vendor/laravel/framework/src/Illuminate/View/View.php:123 25. /vendor/laravel/framework/src/Illuminate/View/View.php:90 26. view::public.layouts.main:28 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` in (401, 402, 403) order by `menu_order` asc2.59ms/app/Services/MenuService.php:85pick

Metadata

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /app/Services/MenuService.php:85 21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 23. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 24. /app/Services/MenuService.php:106 25. /app/Providers/ViewServiceProvider.php:104 28. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 29. /vendor/laravel/framework/src/Illuminate/View/View.php:123 30. /vendor/laravel/framework/src/Illuminate/View/View.php:90 31. view::public.layouts.main:28 33. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 34. /vendor/laravel/framework/src/Illuminate/View/View.php:142 35. /vendor/laravel/framework/src/Illuminate/View/View.php:125 36. /vendor/laravel/framework/src/Illuminate/View/View.php:90 37. view::public.landing:548 39. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 40. /vendor/laravel/framework/src/Illuminate/View/View.php:142 41. /vendor/laravel/framework/src/Illuminate/View/View.php:125 42. /vendor/laravel/framework/src/Illuminate/View/View.php:90 43. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 44. /vendor/symfony/http-foundation/Response.php:202 45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 49. /app/Http/Controllers/Controller.php:36

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Services/MenuService.php:85
21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
23. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
24. /app/Services/MenuService.php:106
25. /app/Providers/ViewServiceProvider.php:104
28. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
29. /vendor/laravel/framework/src/Illuminate/View/View.php:123
30. /vendor/laravel/framework/src/Illuminate/View/View.php:90
31. view::public.layouts.main:28
33. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
34. /vendor/laravel/framework/src/Illuminate/View/View.php:142
35. /vendor/laravel/framework/src/Illuminate/View/View.php:125
36. /vendor/laravel/framework/src/Illuminate/View/View.php:90
37. view::public.landing:548
39. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
40. /vendor/laravel/framework/src/Illuminate/View/View.php:142
41. /vendor/laravel/framework/src/Illuminate/View/View.php:125
42. /vendor/laravel/framework/src/Illuminate/View/View.php:90
43. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
44. /vendor/symfony/http-foundation/Response.php:202
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
49. /app/Http/Controllers/Controller.php:36

select * from `menus_items` where `menus_items`.`parent_id` = 399 and `menus_items`.`parent_id` is not null order by `menu_order` asc

280μs/app/Models/MenuItem.php:107pick

Metadata
Bindings	0. 399
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Models/MenuItem.php:107 16. /app/Services/MenuService.php:100 17. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 18. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 19. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 20. /app/Services/MenuService.php:106 21. /app/Providers/ViewServiceProvider.php:104 24. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 25. /vendor/laravel/framework/src/Illuminate/View/View.php:123 26. /vendor/laravel/framework/src/Illuminate/View/View.php:90 27. view::public.layouts.main:28 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 30. /vendor/laravel/framework/src/Illuminate/View/View.php:142 31. /vendor/laravel/framework/src/Illuminate/View/View.php:125 32. /vendor/laravel/framework/src/Illuminate/View/View.php:90 33. view::public.landing:548 35. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 36. /vendor/laravel/framework/src/Illuminate/View/View.php:142 37. /vendor/laravel/framework/src/Illuminate/View/View.php:125 38. /vendor/laravel/framework/src/Illuminate/View/View.php:90 39. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 40. /vendor/symfony/http-foundation/Response.php:202 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 45. /app/Http/Controllers/Controller.php:36 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /app/Http/Middleware/Localization.php:64 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select * from `menus_items` where `menus_items`.`parent_id` in (401, 402, 403) order by `menu_order` asc240μs/app/Models/MenuItem.php:107pick

Metadata

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /app/Models/MenuItem.php:107 21. /app/Services/MenuService.php:100 22. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 23. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 24. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 25. /app/Services/MenuService.php:106 26. /app/Providers/ViewServiceProvider.php:104 29. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 30. /vendor/laravel/framework/src/Illuminate/View/View.php:123 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.layouts.main:28 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. view::public.landing:548 40. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 41. /vendor/laravel/framework/src/Illuminate/View/View.php:142 42. /vendor/laravel/framework/src/Illuminate/View/View.php:125 43. /vendor/laravel/framework/src/Illuminate/View/View.php:90 44. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 45. /vendor/symfony/http-foundation/Response.php:202 46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Models/MenuItem.php:107
21. /app/Services/MenuService.php:100
22. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
23. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
24. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
25. /app/Services/MenuService.php:106
26. /app/Providers/ViewServiceProvider.php:104
29. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
30. /vendor/laravel/framework/src/Illuminate/View/View.php:123
31. /vendor/laravel/framework/src/Illuminate/View/View.php:90
32. view::public.layouts.main:28
34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
35. /vendor/laravel/framework/src/Illuminate/View/View.php:142
36. /vendor/laravel/framework/src/Illuminate/View/View.php:125
37. /vendor/laravel/framework/src/Illuminate/View/View.php:90
38. view::public.landing:548
40. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
41. /vendor/laravel/framework/src/Illuminate/View/View.php:142
42. /vendor/laravel/framework/src/Illuminate/View/View.php:125
43. /vendor/laravel/framework/src/Illuminate/View/View.php:90
44. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
45. /vendor/symfony/http-foundation/Response.php:202
46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30

select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 401 and `menus_items`.`parent_id` is not null

220μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick

Metadata
Bindings	0. 401
Backtrace	15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23 17. /app/Models/MenuItem.php:109 18. /app/Services/MenuService.php:100 19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 21. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 22. /app/Services/MenuService.php:106 23. /app/Providers/ViewServiceProvider.php:104 26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 27. /vendor/laravel/framework/src/Illuminate/View/View.php:123 28. /vendor/laravel/framework/src/Illuminate/View/View.php:90 29. view::public.layouts.main:28 31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 32. /vendor/laravel/framework/src/Illuminate/View/View.php:142 33. /vendor/laravel/framework/src/Illuminate/View/View.php:125 34. /vendor/laravel/framework/src/Illuminate/View/View.php:90 35. view::public.landing:548 37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 38. /vendor/laravel/framework/src/Illuminate/View/View.php:142 39. /vendor/laravel/framework/src/Illuminate/View/View.php:125 40. /vendor/laravel/framework/src/Illuminate/View/View.php:90 41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 42. /vendor/symfony/http-foundation/Response.php:202 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 47. /app/Http/Controllers/Controller.php:36 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

Metadata

Bindings

0. 401

Backtrace

15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
17. /app/Models/MenuItem.php:109
18. /app/Services/MenuService.php:100
19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
21. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
22. /app/Services/MenuService.php:106
23. /app/Providers/ViewServiceProvider.php:104
26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
27. /vendor/laravel/framework/src/Illuminate/View/View.php:123
28. /vendor/laravel/framework/src/Illuminate/View/View.php:90
29. view::public.layouts.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 402 and `menus_items`.`parent_id` is not null

210μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick

Metadata

Bindings

0. 402

Backtrace

15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
17. /app/Models/MenuItem.php:109
18. /app/Services/MenuService.php:100
19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
21. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
22. /app/Services/MenuService.php:106
23. /app/Providers/ViewServiceProvider.php:104
26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
27. /vendor/laravel/framework/src/Illuminate/View/View.php:123
28. /vendor/laravel/framework/src/Illuminate/View/View.php:90
29. view::public.layouts.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 403 and `menus_items`.`parent_id` is not null

210μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick

Metadata

Bindings

0. 403

Backtrace

15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
17. /app/Models/MenuItem.php:109
18. /app/Services/MenuService.php:100
19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
21. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
22. /app/Services/MenuService.php:106
23. /app/Providers/ViewServiceProvider.php:104
26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
27. /vendor/laravel/framework/src/Illuminate/View/View.php:123
28. /vendor/laravel/framework/src/Illuminate/View/View.php:90
29. view::public.layouts.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus` where `menu_type` = '0' limit 13.88ms/app/Services/MenuService.php:121pick

Metadata
Bindings	0. 0
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /app/Services/MenuService.php:121 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 18. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 19. /app/Services/MenuService.php:152 20. /app/Providers/ViewServiceProvider.php:105 23. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 24. /vendor/laravel/framework/src/Illuminate/View/View.php:123 25. /vendor/laravel/framework/src/Illuminate/View/View.php:90 26. view::public.layouts.main:28 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`menu_id` = 2 and `menus_items`.`menu_id` is not null and `language_id` = 7 and `parent_id` = '0' order by `menu_order` asc

570μs/app/Models/Menu.php:72pick

Metadata
Bindings	0. 2 1. 7 2. 0
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Models/Menu.php:72 16. /app/Services/MenuService.php:126 17. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 18. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 19. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 20. /app/Services/MenuService.php:152 21. /app/Providers/ViewServiceProvider.php:105 24. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 25. /vendor/laravel/framework/src/Illuminate/View/View.php:123 26. /vendor/laravel/framework/src/Illuminate/View/View.php:90 27. view::public.layouts.main:28 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 30. /vendor/laravel/framework/src/Illuminate/View/View.php:142 31. /vendor/laravel/framework/src/Illuminate/View/View.php:125 32. /vendor/laravel/framework/src/Illuminate/View/View.php:90 33. view::public.landing:548 35. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 36. /vendor/laravel/framework/src/Illuminate/View/View.php:142 37. /vendor/laravel/framework/src/Illuminate/View/View.php:125 38. /vendor/laravel/framework/src/Illuminate/View/View.php:90 39. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 40. /vendor/symfony/http-foundation/Response.php:202 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 45. /app/Http/Controllers/Controller.php:36 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /app/Http/Middleware/Localization.php:64 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select * from `menus_items` where `menus_items`.`parent_id` in (390, 391, 395, 398, 399) order by `menu_order` asc330μs/app/Models/Menu.php:72pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Models/Menu.php:72
21. /app/Services/MenuService.php:126
22. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
23. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
24. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
25. /app/Services/MenuService.php:152
26. /app/Providers/ViewServiceProvider.php:105
29. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
30. /vendor/laravel/framework/src/Illuminate/View/View.php:123
31. /vendor/laravel/framework/src/Illuminate/View/View.php:90
32. view::public.layouts.main:28
34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
35. /vendor/laravel/framework/src/Illuminate/View/View.php:142
36. /vendor/laravel/framework/src/Illuminate/View/View.php:125
37. /vendor/laravel/framework/src/Illuminate/View/View.php:90
38. view::public.landing:548
40. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
41. /vendor/laravel/framework/src/Illuminate/View/View.php:142
42. /vendor/laravel/framework/src/Illuminate/View/View.php:125
43. /vendor/laravel/framework/src/Illuminate/View/View.php:90
44. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
45. /vendor/symfony/http-foundation/Response.php:202
46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30

select * from `menus_items` where `menus_items`.`parent_id` in (392, 393, 394, 396, 397, 401, 402, 403) order by `menu_order` asc

270μs/app/Models/Menu.php:72pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

25. /app/Models/Menu.php:72
26. /app/Services/MenuService.php:126
27. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
28. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
29. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
30. /app/Services/MenuService.php:152
31. /app/Providers/ViewServiceProvider.php:105
34. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
35. /vendor/laravel/framework/src/Illuminate/View/View.php:123
36. /vendor/laravel/framework/src/Illuminate/View/View.php:90
37. view::public.layouts.main:28
39. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
40. /vendor/laravel/framework/src/Illuminate/View/View.php:142
41. /vendor/laravel/framework/src/Illuminate/View/View.php:125
42. /vendor/laravel/framework/src/Illuminate/View/View.php:90
43. view::public.landing:548
45. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
46. /vendor/laravel/framework/src/Illuminate/View/View.php:142
47. /vendor/laravel/framework/src/Illuminate/View/View.php:125
48. /vendor/laravel/framework/src/Illuminate/View/View.php:90
49. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42

select * from `menus_items` where `menus_items`.`parent_id` = 390 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc

260μs/app/Services/MenuService.php:131pick

Metadata
Bindings	0. 390
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Services/MenuService.php:131 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 18. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 19. /app/Services/MenuService.php:152 20. /app/Providers/ViewServiceProvider.php:105 23. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 24. /vendor/laravel/framework/src/Illuminate/View/View.php:123 25. /vendor/laravel/framework/src/Illuminate/View/View.php:90 26. view::public.layouts.main:28 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` = 391 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc

320μs/app/Services/MenuService.php:131pick

Metadata
Bindings	0. 391
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Services/MenuService.php:131 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 18. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 19. /app/Services/MenuService.php:152 20. /app/Providers/ViewServiceProvider.php:105 23. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 24. /vendor/laravel/framework/src/Illuminate/View/View.php:123 25. /vendor/laravel/framework/src/Illuminate/View/View.php:90 26. view::public.layouts.main:28 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` in (392, 393, 394) order by `menu_order` asc250μs/app/Services/MenuService.php:131pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Services/MenuService.php:131
21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
23. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
24. /app/Services/MenuService.php:152
25. /app/Providers/ViewServiceProvider.php:105
28. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
29. /vendor/laravel/framework/src/Illuminate/View/View.php:123
30. /vendor/laravel/framework/src/Illuminate/View/View.php:90
31. view::public.layouts.main:28
33. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
34. /vendor/laravel/framework/src/Illuminate/View/View.php:142
35. /vendor/laravel/framework/src/Illuminate/View/View.php:125
36. /vendor/laravel/framework/src/Illuminate/View/View.php:90
37. view::public.landing:548
39. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
40. /vendor/laravel/framework/src/Illuminate/View/View.php:142
41. /vendor/laravel/framework/src/Illuminate/View/View.php:125
42. /vendor/laravel/framework/src/Illuminate/View/View.php:90
43. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
44. /vendor/symfony/http-foundation/Response.php:202
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
49. /app/Http/Controllers/Controller.php:36

select * from `menus_items` where `menus_items`.`parent_id` = 391 and `menus_items`.`parent_id` is not null order by `menu_order` asc

310μs/app/Models/MenuItem.php:107pick

Metadata
Bindings	0. 391
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Models/MenuItem.php:107 16. /app/Services/MenuService.php:146 17. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 18. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 19. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 20. /app/Services/MenuService.php:152 21. /app/Providers/ViewServiceProvider.php:105 24. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 25. /vendor/laravel/framework/src/Illuminate/View/View.php:123 26. /vendor/laravel/framework/src/Illuminate/View/View.php:90 27. view::public.layouts.main:28 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 30. /vendor/laravel/framework/src/Illuminate/View/View.php:142 31. /vendor/laravel/framework/src/Illuminate/View/View.php:125 32. /vendor/laravel/framework/src/Illuminate/View/View.php:90 33. view::public.landing:548 35. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 36. /vendor/laravel/framework/src/Illuminate/View/View.php:142 37. /vendor/laravel/framework/src/Illuminate/View/View.php:125 38. /vendor/laravel/framework/src/Illuminate/View/View.php:90 39. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 40. /vendor/symfony/http-foundation/Response.php:202 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 45. /app/Http/Controllers/Controller.php:36 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /app/Http/Middleware/Localization.php:64 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select * from `menus_items` where `menus_items`.`parent_id` in (392, 393, 394) order by `menu_order` asc2.51ms/app/Models/MenuItem.php:107pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Models/MenuItem.php:107
21. /app/Services/MenuService.php:146
22. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
23. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
24. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
25. /app/Services/MenuService.php:152
26. /app/Providers/ViewServiceProvider.php:105
29. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
30. /vendor/laravel/framework/src/Illuminate/View/View.php:123
31. /vendor/laravel/framework/src/Illuminate/View/View.php:90
32. view::public.layouts.main:28
34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
35. /vendor/laravel/framework/src/Illuminate/View/View.php:142
36. /vendor/laravel/framework/src/Illuminate/View/View.php:125
37. /vendor/laravel/framework/src/Illuminate/View/View.php:90
38. view::public.landing:548
40. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
41. /vendor/laravel/framework/src/Illuminate/View/View.php:142
42. /vendor/laravel/framework/src/Illuminate/View/View.php:125
43. /vendor/laravel/framework/src/Illuminate/View/View.php:90
44. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
45. /vendor/symfony/http-foundation/Response.php:202
46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30

select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 392 and `menus_items`.`parent_id` is not null

240μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick

Metadata

Bindings

0. 392

Backtrace

15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
17. /app/Models/MenuItem.php:109
18. /app/Services/MenuService.php:146
19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
21. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
22. /app/Services/MenuService.php:152
23. /app/Providers/ViewServiceProvider.php:105
26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
27. /vendor/laravel/framework/src/Illuminate/View/View.php:123
28. /vendor/laravel/framework/src/Illuminate/View/View.php:90
29. view::public.layouts.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 393 and `menus_items`.`parent_id` is not null

230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick

Metadata

Bindings

0. 393

Backtrace

15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
17. /app/Models/MenuItem.php:109
18. /app/Services/MenuService.php:146
19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
21. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
22. /app/Services/MenuService.php:152
23. /app/Providers/ViewServiceProvider.php:105
26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
27. /vendor/laravel/framework/src/Illuminate/View/View.php:123
28. /vendor/laravel/framework/src/Illuminate/View/View.php:90
29. view::public.layouts.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 394 and `menus_items`.`parent_id` is not null

230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick

Metadata

Bindings

0. 394

Backtrace

15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
17. /app/Models/MenuItem.php:109
18. /app/Services/MenuService.php:146
19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
21. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
22. /app/Services/MenuService.php:152
23. /app/Providers/ViewServiceProvider.php:105
26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
27. /vendor/laravel/framework/src/Illuminate/View/View.php:123
28. /vendor/laravel/framework/src/Illuminate/View/View.php:90
29. view::public.layouts.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` = 395 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc

300μs/app/Services/MenuService.php:131pick

Metadata
Bindings	0. 395
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Services/MenuService.php:131 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 18. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 19. /app/Services/MenuService.php:152 20. /app/Providers/ViewServiceProvider.php:105 23. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 24. /vendor/laravel/framework/src/Illuminate/View/View.php:123 25. /vendor/laravel/framework/src/Illuminate/View/View.php:90 26. view::public.layouts.main:28 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` in (396, 397) order by `menu_order` asc1.17ms/app/Services/MenuService.php:131pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Services/MenuService.php:131
21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
23. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
24. /app/Services/MenuService.php:152
25. /app/Providers/ViewServiceProvider.php:105
28. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
29. /vendor/laravel/framework/src/Illuminate/View/View.php:123
30. /vendor/laravel/framework/src/Illuminate/View/View.php:90
31. view::public.layouts.main:28
33. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
34. /vendor/laravel/framework/src/Illuminate/View/View.php:142
35. /vendor/laravel/framework/src/Illuminate/View/View.php:125
36. /vendor/laravel/framework/src/Illuminate/View/View.php:90
37. view::public.landing:548
39. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
40. /vendor/laravel/framework/src/Illuminate/View/View.php:142
41. /vendor/laravel/framework/src/Illuminate/View/View.php:125
42. /vendor/laravel/framework/src/Illuminate/View/View.php:90
43. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
44. /vendor/symfony/http-foundation/Response.php:202
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
49. /app/Http/Controllers/Controller.php:36

select * from `menus_items` where `menus_items`.`parent_id` = 395 and `menus_items`.`parent_id` is not null order by `menu_order` asc

970μs/app/Models/MenuItem.php:107pick

Metadata
Bindings	0. 395
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Models/MenuItem.php:107 16. /app/Services/MenuService.php:146 17. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 18. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 19. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 20. /app/Services/MenuService.php:152 21. /app/Providers/ViewServiceProvider.php:105 24. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 25. /vendor/laravel/framework/src/Illuminate/View/View.php:123 26. /vendor/laravel/framework/src/Illuminate/View/View.php:90 27. view::public.layouts.main:28 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 30. /vendor/laravel/framework/src/Illuminate/View/View.php:142 31. /vendor/laravel/framework/src/Illuminate/View/View.php:125 32. /vendor/laravel/framework/src/Illuminate/View/View.php:90 33. view::public.landing:548 35. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 36. /vendor/laravel/framework/src/Illuminate/View/View.php:142 37. /vendor/laravel/framework/src/Illuminate/View/View.php:125 38. /vendor/laravel/framework/src/Illuminate/View/View.php:90 39. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 40. /vendor/symfony/http-foundation/Response.php:202 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 45. /app/Http/Controllers/Controller.php:36 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /app/Http/Middleware/Localization.php:64 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select * from `menus_items` where `menus_items`.`parent_id` in (396, 397) order by `menu_order` asc2.28ms/app/Models/MenuItem.php:107pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Models/MenuItem.php:107
21. /app/Services/MenuService.php:146
22. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
23. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
24. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
25. /app/Services/MenuService.php:152
26. /app/Providers/ViewServiceProvider.php:105
29. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
30. /vendor/laravel/framework/src/Illuminate/View/View.php:123
31. /vendor/laravel/framework/src/Illuminate/View/View.php:90
32. view::public.layouts.main:28
34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
35. /vendor/laravel/framework/src/Illuminate/View/View.php:142
36. /vendor/laravel/framework/src/Illuminate/View/View.php:125
37. /vendor/laravel/framework/src/Illuminate/View/View.php:90
38. view::public.landing:548
40. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
41. /vendor/laravel/framework/src/Illuminate/View/View.php:142
42. /vendor/laravel/framework/src/Illuminate/View/View.php:125
43. /vendor/laravel/framework/src/Illuminate/View/View.php:90
44. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
45. /vendor/symfony/http-foundation/Response.php:202
46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30

select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 396 and `menus_items`.`parent_id` is not null

250μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick

Metadata

Bindings

0. 396

Backtrace

15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
17. /app/Models/MenuItem.php:109
18. /app/Services/MenuService.php:146
19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
21. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
22. /app/Services/MenuService.php:152
23. /app/Providers/ViewServiceProvider.php:105
26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
27. /vendor/laravel/framework/src/Illuminate/View/View.php:123
28. /vendor/laravel/framework/src/Illuminate/View/View.php:90
29. view::public.layouts.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 397 and `menus_items`.`parent_id` is not null

220μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick

Metadata

Bindings

0. 397

Backtrace

15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
17. /app/Models/MenuItem.php:109
18. /app/Services/MenuService.php:146
19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
21. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
22. /app/Services/MenuService.php:152
23. /app/Providers/ViewServiceProvider.php:105
26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
27. /vendor/laravel/framework/src/Illuminate/View/View.php:123
28. /vendor/laravel/framework/src/Illuminate/View/View.php:90
29. view::public.layouts.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` = 398 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc

260μs/app/Services/MenuService.php:131pick

Metadata
Bindings	0. 398
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Services/MenuService.php:131 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 18. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 19. /app/Services/MenuService.php:152 20. /app/Providers/ViewServiceProvider.php:105 23. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 24. /vendor/laravel/framework/src/Illuminate/View/View.php:123 25. /vendor/laravel/framework/src/Illuminate/View/View.php:90 26. view::public.layouts.main:28 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` = 399 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc

2ms/app/Services/MenuService.php:131pick

Metadata
Bindings	0. 399
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Services/MenuService.php:131 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 18. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 19. /app/Services/MenuService.php:152 20. /app/Providers/ViewServiceProvider.php:105 23. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 24. /vendor/laravel/framework/src/Illuminate/View/View.php:123 25. /vendor/laravel/framework/src/Illuminate/View/View.php:90 26. view::public.layouts.main:28 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` in (401, 402, 403) order by `menu_order` asc250μs/app/Services/MenuService.php:131pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Services/MenuService.php:131
21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
23. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
24. /app/Services/MenuService.php:152
25. /app/Providers/ViewServiceProvider.php:105
28. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
29. /vendor/laravel/framework/src/Illuminate/View/View.php:123
30. /vendor/laravel/framework/src/Illuminate/View/View.php:90
31. view::public.layouts.main:28
33. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
34. /vendor/laravel/framework/src/Illuminate/View/View.php:142
35. /vendor/laravel/framework/src/Illuminate/View/View.php:125
36. /vendor/laravel/framework/src/Illuminate/View/View.php:90
37. view::public.landing:548
39. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
40. /vendor/laravel/framework/src/Illuminate/View/View.php:142
41. /vendor/laravel/framework/src/Illuminate/View/View.php:125
42. /vendor/laravel/framework/src/Illuminate/View/View.php:90
43. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
44. /vendor/symfony/http-foundation/Response.php:202
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
49. /app/Http/Controllers/Controller.php:36

select * from `menus_items` where `menus_items`.`parent_id` = 399 and `menus_items`.`parent_id` is not null order by `menu_order` asc

290μs/app/Models/MenuItem.php:107pick

Metadata
Bindings	0. 399
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Models/MenuItem.php:107 16. /app/Services/MenuService.php:146 17. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 18. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 19. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 20. /app/Services/MenuService.php:152 21. /app/Providers/ViewServiceProvider.php:105 24. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 25. /vendor/laravel/framework/src/Illuminate/View/View.php:123 26. /vendor/laravel/framework/src/Illuminate/View/View.php:90 27. view::public.layouts.main:28 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 30. /vendor/laravel/framework/src/Illuminate/View/View.php:142 31. /vendor/laravel/framework/src/Illuminate/View/View.php:125 32. /vendor/laravel/framework/src/Illuminate/View/View.php:90 33. view::public.landing:548 35. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 36. /vendor/laravel/framework/src/Illuminate/View/View.php:142 37. /vendor/laravel/framework/src/Illuminate/View/View.php:125 38. /vendor/laravel/framework/src/Illuminate/View/View.php:90 39. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 40. /vendor/symfony/http-foundation/Response.php:202 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 45. /app/Http/Controllers/Controller.php:36 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /app/Http/Middleware/Localization.php:64 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select * from `menus_items` where `menus_items`.`parent_id` in (401, 402, 403) order by `menu_order` asc500μs/app/Models/MenuItem.php:107pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Models/MenuItem.php:107
21. /app/Services/MenuService.php:146
22. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
23. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
24. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
25. /app/Services/MenuService.php:152
26. /app/Providers/ViewServiceProvider.php:105
29. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
30. /vendor/laravel/framework/src/Illuminate/View/View.php:123
31. /vendor/laravel/framework/src/Illuminate/View/View.php:90
32. view::public.layouts.main:28
34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
35. /vendor/laravel/framework/src/Illuminate/View/View.php:142
36. /vendor/laravel/framework/src/Illuminate/View/View.php:125
37. /vendor/laravel/framework/src/Illuminate/View/View.php:90
38. view::public.landing:548
40. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
41. /vendor/laravel/framework/src/Illuminate/View/View.php:142
42. /vendor/laravel/framework/src/Illuminate/View/View.php:125
43. /vendor/laravel/framework/src/Illuminate/View/View.php:90
44. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
45. /vendor/symfony/http-foundation/Response.php:202
46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30

select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 401 and `menus_items`.`parent_id` is not null

230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick

Metadata

Bindings

0. 401

Backtrace

15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
17. /app/Models/MenuItem.php:109
18. /app/Services/MenuService.php:146
19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
21. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
22. /app/Services/MenuService.php:152
23. /app/Providers/ViewServiceProvider.php:105
26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
27. /vendor/laravel/framework/src/Illuminate/View/View.php:123
28. /vendor/laravel/framework/src/Illuminate/View/View.php:90
29. view::public.layouts.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 402 and `menus_items`.`parent_id` is not null

220μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick

Metadata

Bindings

0. 402

Backtrace

15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
17. /app/Models/MenuItem.php:109
18. /app/Services/MenuService.php:146
19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
21. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
22. /app/Services/MenuService.php:152
23. /app/Providers/ViewServiceProvider.php:105
26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
27. /vendor/laravel/framework/src/Illuminate/View/View.php:123
28. /vendor/laravel/framework/src/Illuminate/View/View.php:90
29. view::public.layouts.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 403 and `menus_items`.`parent_id` is not null

260μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick

Metadata

Bindings

0. 403

Backtrace

15. /vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23
17. /app/Models/MenuItem.php:109
18. /app/Services/MenuService.php:146
19. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
20. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
21. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
22. /app/Services/MenuService.php:152
23. /app/Providers/ViewServiceProvider.php:105
26. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
27. /vendor/laravel/framework/src/Illuminate/View/View.php:123
28. /vendor/laravel/framework/src/Illuminate/View/View.php:90
29. view::public.layouts.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `settings_languages` left join `settings_countries` on `settings_countries`.`id` = `settings_languages`.`country_id` left join `settings_countries_trans` on `settings_countries`.`id` = `settings_countries_trans`.`country_id` where `settings_languages`.`is_active` = 1 and `settings_countries_trans`.`language_id` = 7 order by `settings_countries`.`priority` asc

1.11ms/app/Models/Language.php:179pick

Metadata
Bindings	0. 1 1. 7
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	12. /app/Models/Language.php:179 13. /app/Providers/ViewServiceProvider.php:107 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 17. /vendor/laravel/framework/src/Illuminate/View/View.php:123 18. /vendor/laravel/framework/src/Illuminate/View/View.php:90 19. view::public.layouts.main:28 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125 24. /vendor/laravel/framework/src/Illuminate/View/View.php:90 25. view::public.landing:548 27. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 28. /vendor/laravel/framework/src/Illuminate/View/View.php:142 29. /vendor/laravel/framework/src/Illuminate/View/View.php:125 30. /vendor/laravel/framework/src/Illuminate/View/View.php:90 31. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 32. /vendor/symfony/http-foundation/Response.php:202 33. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 34. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 36. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 37. /app/Http/Controllers/Controller.php:36 38. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 39. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 40. /app/Http/Middleware/Localization.php:64 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 43. middleware::bindings:41 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 46. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 49. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49

select * from `settings_languages` left join `settings_countries` on `settings_countries`.`id` = `settings_languages`.`country_id` left join `settings_countries_trans` on `settings_countries`.`id` = `settings_countries_trans`.`country_id` where `settings_languages`.`is_active` = 1 and `settings_countries_trans`.`language_id` = 7 and `settings_countries`.`id` = 2 order by `settings_languages`.`order_num` asc

590μs/app/Models/Language.php:192pick

Metadata
Bindings	0. 1 1. 7 2. 2
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	12. /app/Models/Language.php:192 13. /app/Providers/ViewServiceProvider.php:108 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 17. /vendor/laravel/framework/src/Illuminate/View/View.php:123 18. /vendor/laravel/framework/src/Illuminate/View/View.php:90 19. view::public.layouts.main:28 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125 24. /vendor/laravel/framework/src/Illuminate/View/View.php:90 25. view::public.landing:548 27. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 28. /vendor/laravel/framework/src/Illuminate/View/View.php:142 29. /vendor/laravel/framework/src/Illuminate/View/View.php:125 30. /vendor/laravel/framework/src/Illuminate/View/View.php:90 31. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 32. /vendor/symfony/http-foundation/Response.php:202 33. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 34. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 36. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 37. /app/Http/Controllers/Controller.php:36 38. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 39. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 40. /app/Http/Middleware/Localization.php:64 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 43. middleware::bindings:41 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 46. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 49. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49

select * from `menus` where `menu_type` = '1' limit 1320μs/app/Services/MenuService.php:421pick

Metadata
Bindings	0. 1
Hints	Use `SELECT *` only if you need all columns from table `LIMIT` without `ORDER BY` causes non-deterministic results, depending on the query execution plan
Backtrace	15. /app/Services/MenuService.php:421 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 18. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 19. /app/Services/MenuService.php:443 20. /app/Providers/ViewServiceProvider.php:239 23. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 24. /vendor/laravel/framework/src/Illuminate/View/View.php:123 25. /vendor/laravel/framework/src/Illuminate/View/View.php:90 26. view::public.layouts.main:34 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`menu_id` = 3 and `menus_items`.`menu_id` is not null and `language_id` = 7 and `parent_id` = '0' order by `menu_order` asc

500μs/app/Models/Menu.php:72pick

Metadata
Bindings	0. 3 1. 7 2. 0
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Models/Menu.php:72 16. /app/Services/MenuService.php:424 17. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 18. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 19. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 20. /app/Services/MenuService.php:443 21. /app/Providers/ViewServiceProvider.php:239 24. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 25. /vendor/laravel/framework/src/Illuminate/View/View.php:123 26. /vendor/laravel/framework/src/Illuminate/View/View.php:90 27. view::public.layouts.main:34 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 30. /vendor/laravel/framework/src/Illuminate/View/View.php:142 31. /vendor/laravel/framework/src/Illuminate/View/View.php:125 32. /vendor/laravel/framework/src/Illuminate/View/View.php:90 33. view::public.landing:548 35. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 36. /vendor/laravel/framework/src/Illuminate/View/View.php:142 37. /vendor/laravel/framework/src/Illuminate/View/View.php:125 38. /vendor/laravel/framework/src/Illuminate/View/View.php:90 39. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 40. /vendor/symfony/http-foundation/Response.php:202 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 45. /app/Http/Controllers/Controller.php:36 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /app/Http/Middleware/Localization.php:64 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select * from `menus_items` where `menus_items`.`parent_id` in (341, 345, 351, 357) order by `menu_order` asc360μs/app/Models/Menu.php:72pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Models/Menu.php:72
21. /app/Services/MenuService.php:424
22. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
23. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
24. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
25. /app/Services/MenuService.php:443
26. /app/Providers/ViewServiceProvider.php:239
29. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
30. /vendor/laravel/framework/src/Illuminate/View/View.php:123
31. /vendor/laravel/framework/src/Illuminate/View/View.php:90
32. view::public.layouts.main:34
34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
35. /vendor/laravel/framework/src/Illuminate/View/View.php:142
36. /vendor/laravel/framework/src/Illuminate/View/View.php:125
37. /vendor/laravel/framework/src/Illuminate/View/View.php:90
38. view::public.landing:548
40. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
41. /vendor/laravel/framework/src/Illuminate/View/View.php:142
42. /vendor/laravel/framework/src/Illuminate/View/View.php:125
43. /vendor/laravel/framework/src/Illuminate/View/View.php:90
44. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
45. /vendor/symfony/http-foundation/Response.php:202
46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30

select * from `menus_items` where `menus_items`.`parent_id` in (342, 343, 344, 346, 347, 348, 349, 350, 352, 354, 355, 358, 359, 360, 361, 459) order by `menu_order` asc

290μs/app/Models/Menu.php:72pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

25. /app/Models/Menu.php:72
26. /app/Services/MenuService.php:424
27. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
28. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
29. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
30. /app/Services/MenuService.php:443
31. /app/Providers/ViewServiceProvider.php:239
34. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
35. /vendor/laravel/framework/src/Illuminate/View/View.php:123
36. /vendor/laravel/framework/src/Illuminate/View/View.php:90
37. view::public.layouts.main:34
39. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
40. /vendor/laravel/framework/src/Illuminate/View/View.php:142
41. /vendor/laravel/framework/src/Illuminate/View/View.php:125
42. /vendor/laravel/framework/src/Illuminate/View/View.php:90
43. view::public.landing:548
45. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
46. /vendor/laravel/framework/src/Illuminate/View/View.php:142
47. /vendor/laravel/framework/src/Illuminate/View/View.php:125
48. /vendor/laravel/framework/src/Illuminate/View/View.php:90
49. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42

select * from `menus_items` where `menus_items`.`parent_id` = 341 and `menus_items`.`parent_id` is not null order by `menu_order` asc

290μs/app/Services/MenuService.php:433pick

Metadata
Bindings	0. 341
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Services/MenuService.php:433 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 18. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 19. /app/Services/MenuService.php:443 20. /app/Providers/ViewServiceProvider.php:239 23. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 24. /vendor/laravel/framework/src/Illuminate/View/View.php:123 25. /vendor/laravel/framework/src/Illuminate/View/View.php:90 26. view::public.layouts.main:34 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` in (342, 343, 344) order by `menu_order` asc340μs/app/Services/MenuService.php:433pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Services/MenuService.php:433
21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
23. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
24. /app/Services/MenuService.php:443
25. /app/Providers/ViewServiceProvider.php:239
28. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
29. /vendor/laravel/framework/src/Illuminate/View/View.php:123
30. /vendor/laravel/framework/src/Illuminate/View/View.php:90
31. view::public.layouts.main:34
33. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
34. /vendor/laravel/framework/src/Illuminate/View/View.php:142
35. /vendor/laravel/framework/src/Illuminate/View/View.php:125
36. /vendor/laravel/framework/src/Illuminate/View/View.php:90
37. view::public.landing:548
39. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
40. /vendor/laravel/framework/src/Illuminate/View/View.php:142
41. /vendor/laravel/framework/src/Illuminate/View/View.php:125
42. /vendor/laravel/framework/src/Illuminate/View/View.php:90
43. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
44. /vendor/symfony/http-foundation/Response.php:202
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
49. /app/Http/Controllers/Controller.php:36

select * from `menus_items` where `menus_items`.`parent_id` = 345 and `menus_items`.`parent_id` is not null order by `menu_order` asc

330μs/app/Services/MenuService.php:433pick

Metadata
Bindings	0. 345
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Services/MenuService.php:433 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 18. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 19. /app/Services/MenuService.php:443 20. /app/Providers/ViewServiceProvider.php:239 23. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 24. /vendor/laravel/framework/src/Illuminate/View/View.php:123 25. /vendor/laravel/framework/src/Illuminate/View/View.php:90 26. view::public.layouts.main:34 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` in (346, 347, 348, 349, 350) order by `menu_order` asc260μs/app/Services/MenuService.php:433pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Services/MenuService.php:433
21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
23. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
24. /app/Services/MenuService.php:443
25. /app/Providers/ViewServiceProvider.php:239
28. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
29. /vendor/laravel/framework/src/Illuminate/View/View.php:123
30. /vendor/laravel/framework/src/Illuminate/View/View.php:90
31. view::public.layouts.main:34
33. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
34. /vendor/laravel/framework/src/Illuminate/View/View.php:142
35. /vendor/laravel/framework/src/Illuminate/View/View.php:125
36. /vendor/laravel/framework/src/Illuminate/View/View.php:90
37. view::public.landing:548
39. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
40. /vendor/laravel/framework/src/Illuminate/View/View.php:142
41. /vendor/laravel/framework/src/Illuminate/View/View.php:125
42. /vendor/laravel/framework/src/Illuminate/View/View.php:90
43. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
44. /vendor/symfony/http-foundation/Response.php:202
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
49. /app/Http/Controllers/Controller.php:36

select * from `menus_items` where `menus_items`.`parent_id` = 351 and `menus_items`.`parent_id` is not null order by `menu_order` asc

280μs/app/Services/MenuService.php:433pick

Metadata
Bindings	0. 351
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Services/MenuService.php:433 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 18. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 19. /app/Services/MenuService.php:443 20. /app/Providers/ViewServiceProvider.php:239 23. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 24. /vendor/laravel/framework/src/Illuminate/View/View.php:123 25. /vendor/laravel/framework/src/Illuminate/View/View.php:90 26. view::public.layouts.main:34 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` in (352, 354, 355, 459) order by `menu_order` asc250μs/app/Services/MenuService.php:433pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Services/MenuService.php:433
21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
23. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
24. /app/Services/MenuService.php:443
25. /app/Providers/ViewServiceProvider.php:239
28. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
29. /vendor/laravel/framework/src/Illuminate/View/View.php:123
30. /vendor/laravel/framework/src/Illuminate/View/View.php:90
31. view::public.layouts.main:34
33. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
34. /vendor/laravel/framework/src/Illuminate/View/View.php:142
35. /vendor/laravel/framework/src/Illuminate/View/View.php:125
36. /vendor/laravel/framework/src/Illuminate/View/View.php:90
37. view::public.landing:548
39. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
40. /vendor/laravel/framework/src/Illuminate/View/View.php:142
41. /vendor/laravel/framework/src/Illuminate/View/View.php:125
42. /vendor/laravel/framework/src/Illuminate/View/View.php:90
43. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
44. /vendor/symfony/http-foundation/Response.php:202
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
49. /app/Http/Controllers/Controller.php:36

select * from `menus_items` where `menus_items`.`parent_id` = 357 and `menus_items`.`parent_id` is not null order by `menu_order` asc

290μs/app/Services/MenuService.php:433pick

Metadata
Bindings	0. 357
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Services/MenuService.php:433 16. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 17. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 18. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 19. /app/Services/MenuService.php:443 20. /app/Providers/ViewServiceProvider.php:239 23. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 24. /vendor/laravel/framework/src/Illuminate/View/View.php:123 25. /vendor/laravel/framework/src/Illuminate/View/View.php:90 26. view::public.layouts.main:34 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` in (358, 359, 360, 361) order by `menu_order` asc280μs/app/Services/MenuService.php:433pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Services/MenuService.php:433
21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
23. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
24. /app/Services/MenuService.php:443
25. /app/Providers/ViewServiceProvider.php:239
28. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
29. /vendor/laravel/framework/src/Illuminate/View/View.php:123
30. /vendor/laravel/framework/src/Illuminate/View/View.php:90
31. view::public.layouts.main:34
33. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
34. /vendor/laravel/framework/src/Illuminate/View/View.php:142
35. /vendor/laravel/framework/src/Illuminate/View/View.php:125
36. /vendor/laravel/framework/src/Illuminate/View/View.php:90
37. view::public.landing:548
39. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
40. /vendor/laravel/framework/src/Illuminate/View/View.php:142
41. /vendor/laravel/framework/src/Illuminate/View/View.php:125
42. /vendor/laravel/framework/src/Illuminate/View/View.php:90
43. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
44. /vendor/symfony/http-foundation/Response.php:202
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
46. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
47. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
49. /app/Http/Controllers/Controller.php:36

select * from `settings_languages` left join `settings_countries` on `settings_countries`.`id` = `settings_languages`.`country_id` left join `settings_countries_trans` on `settings_countries`.`id` = `settings_countries_trans`.`country_id` where `settings_languages`.`is_active` = 1 and `settings_countries_trans`.`language_id` = 7 group by `slug` order by `settings_languages`.`order_num` asc

940μs/app/Models/Language.php:166pick

Metadata
Bindings	0. 1 1. 7
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	12. /app/Models/Language.php:166 13. /app/Providers/ViewServiceProvider.php:151 16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 17. /vendor/laravel/framework/src/Illuminate/View/View.php:123 18. /vendor/laravel/framework/src/Illuminate/View/View.php:90 19. view::public.layouts.partials._footer:445 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125 24. /vendor/laravel/framework/src/Illuminate/View/View.php:90 25. view::public.layouts.main:34 27. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 28. /vendor/laravel/framework/src/Illuminate/View/View.php:142 29. /vendor/laravel/framework/src/Illuminate/View/View.php:125 30. /vendor/laravel/framework/src/Illuminate/View/View.php:90 31. view::public.landing:548 33. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 34. /vendor/laravel/framework/src/Illuminate/View/View.php:142 35. /vendor/laravel/framework/src/Illuminate/View/View.php:125 36. /vendor/laravel/framework/src/Illuminate/View/View.php:90 37. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 38. /vendor/symfony/http-foundation/Response.php:202 39. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 43. /app/Http/Controllers/Controller.php:36 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 46. /app/Http/Middleware/Localization.php:64 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 49. middleware::bindings:41

select count(*) as aggregate from `settings_countries_trans` where `language_id` = 7 and `country_id` = 2360μs/app/Models/Country.php:53pick

Metadata

Bindings

0. 7
1. 2

Backtrace

14. /app/Models/Country.php:53
15. /app/Providers/ViewServiceProvider.php:152
18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
19. /vendor/laravel/framework/src/Illuminate/View/View.php:123
20. /vendor/laravel/framework/src/Illuminate/View/View.php:90
21. view::public.layouts.partials._footer:445
23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
24. /vendor/laravel/framework/src/Illuminate/View/View.php:142
25. /vendor/laravel/framework/src/Illuminate/View/View.php:125
26. /vendor/laravel/framework/src/Illuminate/View/View.php:90
27. view::public.layouts.main:34
29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
30. /vendor/laravel/framework/src/Illuminate/View/View.php:142
31. /vendor/laravel/framework/src/Illuminate/View/View.php:125
32. /vendor/laravel/framework/src/Illuminate/View/View.php:90
33. view::public.landing:548
35. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
36. /vendor/laravel/framework/src/Illuminate/View/View.php:142
37. /vendor/laravel/framework/src/Illuminate/View/View.php:125
38. /vendor/laravel/framework/src/Illuminate/View/View.php:90
39. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
40. /vendor/symfony/http-foundation/Response.php:202
41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
45. /app/Http/Controllers/Controller.php:36
46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
48. /app/Http/Middleware/Localization.php:64
49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select settings_countries.*, settings_countries_trans.*, settings_countries_trans.country_name as CountryName from `settings_countries` left join `settings_countries_trans` on `settings_countries_trans`.`country_id` = `settings_countries`.`id` where `settings_countries`.`is_active` = 1 and `settings_countries_trans`.`language_id` = 7 group by `settings_countries_trans`.`country_name`, `settings_countries_trans`.`country_id` order by `settings_countries`.`priority` asc, `settings_countries_trans`.`country_name` asc

5.93ms/app/Models/Country.php:69pick

Metadata

Bindings

0. 1
1. 7

Backtrace

12. /app/Models/Country.php:69
13. /app/Providers/ViewServiceProvider.php:152
16. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
17. /vendor/laravel/framework/src/Illuminate/View/View.php:123
18. /vendor/laravel/framework/src/Illuminate/View/View.php:90
19. view::public.layouts.partials._footer:445
21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
22. /vendor/laravel/framework/src/Illuminate/View/View.php:142
23. /vendor/laravel/framework/src/Illuminate/View/View.php:125
24. /vendor/laravel/framework/src/Illuminate/View/View.php:90
25. view::public.layouts.main:34
27. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
28. /vendor/laravel/framework/src/Illuminate/View/View.php:142
29. /vendor/laravel/framework/src/Illuminate/View/View.php:125
30. /vendor/laravel/framework/src/Illuminate/View/View.php:90
31. view::public.landing:548
33. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
34. /vendor/laravel/framework/src/Illuminate/View/View.php:142
35. /vendor/laravel/framework/src/Illuminate/View/View.php:125
36. /vendor/laravel/framework/src/Illuminate/View/View.php:90
37. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
38. /vendor/symfony/http-foundation/Response.php:202
39. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
43. /app/Http/Controllers/Controller.php:36
44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
46. /app/Http/Middleware/Localization.php:64
47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
49. middleware::bindings:41

select `occupations`.*, coalesce(sq_occupations_trans.occupation_name, hr_occupations_trans.occupation_name) as name, coalesce(sq_occupations_trans.description, hr_occupations_trans.description) as description from `occupations` left join `occupations_trans` as `sq_occupations_trans` on `sq_occupations_trans`.`occupation_id` = `occupations`.`id` and `sq_occupations_trans`.`language_id` = 7 left join `occupations_trans` as `hr_occupations_trans` on `hr_occupations_trans`.`occupation_id` = `occupations`.`id` and `hr_occupations_trans`.`language_id` = 2 order by `name` asc

1.44ms/app/Models/Occupation.php:48pick

Metadata
Bindings	0. 7 1. 2
Hints	Use `SELECT *` only if you need all columns from table The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	14. /app/Models/Occupation.php:48 15. /app/Providers/ViewServiceProvider.php:153 18. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 19. /vendor/laravel/framework/src/Illuminate/View/View.php:123 20. /vendor/laravel/framework/src/Illuminate/View/View.php:90 21. view::public.layouts.partials._footer:445 23. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 24. /vendor/laravel/framework/src/Illuminate/View/View.php:142 25. /vendor/laravel/framework/src/Illuminate/View/View.php:125 26. /vendor/laravel/framework/src/Illuminate/View/View.php:90 27. view::public.layouts.main:34 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 30. /vendor/laravel/framework/src/Illuminate/View/View.php:142 31. /vendor/laravel/framework/src/Illuminate/View/View.php:125 32. /vendor/laravel/framework/src/Illuminate/View/View.php:90 33. view::public.landing:548 35. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 36. /vendor/laravel/framework/src/Illuminate/View/View.php:142 37. /vendor/laravel/framework/src/Illuminate/View/View.php:125 38. /vendor/laravel/framework/src/Illuminate/View/View.php:90 39. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 40. /vendor/symfony/http-foundation/Response.php:202 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 45. /app/Http/Controllers/Controller.php:36 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /app/Http/Middleware/Localization.php:64 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

currentLang: App\Models\Language {#1397 +timestamps: false #fillable: array:3 [ 0 => "slug" 1 => "lan...
locale: sq
autolang: 1
_flash: array:2 [ "old" => [] "new" => [] ]
_token: kaE6Qgy9cSAVDy70Jr8n1TtnXJhSKV0kUlBiFjX3
defaultLang: App\Models\Language {#1315 +timestamps: false #fillable: array:3 [ 0 => "slug" 1 => "lan...
_previous: array:1 [ "url" => "https://dev.pick.jobs/al" ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/al

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

  0 of 0   
array:16 [▶
  "authorization" => array:1 [▶
    0 => ""
  ]
  "host" => array:1 [▶
    0 => "dev.pick.jobs"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "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"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
]

request_server

  0 of 0   
array:73 [▶
  "REDIRECT_HTTP_AUTHORIZATION" => ""
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_SSL_TLS_SNI" => "dev.pick.jobs"
  "REDIRECT_STATUS" => "200"
  "HTTP_AUTHORIZATION" => ""
  "HTTPS" => "on"
  "SSL_TLS_SNI" => "dev.pick.jobs"
  "SSL_SERVER_S_DN_CN" => "dev.pick.jobs"
  "SSL_SERVER_I_DN_C" => "PL"
  "SSL_SERVER_I_DN_O" => "Unizeto Technologies S.A."
  "SSL_SERVER_I_DN_OU" => "Certum Certification Authority"
  "SSL_SERVER_I_DN_CN" => "Certum Domain Validation CA SHA2"
  "SSL_SERVER_SAN_DNS_0" => "dev.pick.jobs"
  "SSL_SERVER_SAN_DNS_1" => "www.dev.pick.jobs"
  "SSL_VERSION_INTERFACE" => "mod_ssl/2.4.41"
  "SSL_VERSION_LIBRARY" => "OpenSSL/1.1.1f"
  "SSL_PROTOCOL" => "TLSv1.3"
  "SSL_SECURE_RENEG" => "false"
  "SSL_COMPRESS_METHOD" => "NULL"
  "SSL_CIPHER" => "TLS_AES_128_GCM_SHA256"
  "SSL_CIPHER_EXPORT" => "false"
  "SSL_CIPHER_USEKEYSIZE" => "128"
  "SSL_CIPHER_ALGKEYSIZE" => "128"
  "SSL_CLIENT_VERIFY" => "NONE"
  "SSL_SERVER_M_VERSION" => "3"
  "SSL_SERVER_M_SERIAL" => "3F9463232C084F0C31060B4ECC28AA8D"
  "SSL_SERVER_V_START" => "Sep  6 06:25:36 2024 GMT"
  "SSL_SERVER_V_END" => "Sep  6 06:25:35 2025 GMT"
  "SSL_SERVER_S_DN" => "CN=dev.pick.jobs"
  "SSL_SERVER_I_DN" => "CN=Certum Domain Validation CA SHA2,OU=Certum Certification Authority,O=Unizeto Technologies S.A.,C=PL"
  "SSL_SERVER_A_KEY" => "******"
  "SSL_SERVER_A_SIG" => "sha256WithRSAEncryption"
  "SSL_SESSION_ID" => "40374dd9043ea5da4a1671213a01ce7b62944ab6d39bc486436b5f6334a388cb"
  "SSL_SESSION_RESUMED" => "Initial"
  "HTTP_HOST" => "dev.pick.jobs"
  "HTTP_CONNECTION" => "keep-alive"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "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_SEC_FETCH_SITE" => "none"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin"
  "SERVER_SIGNATURE" => "<address>Apache/2.4.41 (Ubuntu) Server at dev.pick.jobs Port 443</address>\n"
  "SERVER_SOFTWARE" => "Apache/2.4.41 (Ubuntu)"
  "SERVER_NAME" => "dev.pick.jobs"
  "SERVER_ADDR" => "192.168.77.53"
  "SERVER_PORT" => "443"
  "REMOTE_ADDR" => "18.118.145.9"
  "DOCUMENT_ROOT" => "/var/www/pick/public"
  "REQUEST_SCHEME" => "https"
  "CONTEXT_PREFIX" => ""
  "CONTEXT_DOCUMENT_ROOT" => "/var/www/pick/public"
  "SERVER_ADMIN" => "webmaster@localhost"
  "SCRIPT_FILENAME" => "/var/www/pick/public/index.php"
  "REMOTE_PORT" => "39732"
  "REDIRECT_URL" => "/al"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/al"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1746456822.946
  "REQUEST_TIME" => 1746456822
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Mon, 05 May 2025 14:53:43 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InFuSU5rZjJrcjFDZ1VBWXAxS3VnOHc9PSIsInZhbHVlIjoiUWx3NWQ0ZUlhMkFjMVl1RTNGSTRlMG50Um9zUWdxNWtUK2ZWXC9rZTJUbXBjdlwveUVUUFY5a2lLbFROXC9KU2pIVCIsIm1hYyI6ImNhODc1ZTQ5NWExMGVmNDc0YjhlNzBjMWNlYTE2M2M1Nzc5ODAyMDkzZjRjZTE0ZjUzMTNiZjNkYWQ3ZmJkMzcifQ%3D%3D; expires=Tue, 06-May-2025 10:53:43 GMT; Max-Age=72000; path=/ ◀XSRF-TOKEN=eyJpdiI6InFuSU5rZjJrcjFDZ1VBWXAxS3VnOHc9PSIsInZhbHVlIjoiUWx3NWQ0ZUlhMkFjMVl1RTNGSTRlMG50Um9zUWdxNWtUK2ZWXC9rZTJUbXBjdlwveUVUUFY5a2lLbFROXC9KU2pIVCIsI ▶"
    1 => "pickjobs_session=eyJpdiI6InRodzRcLzdTYW9Fb3JSR052Tk1QNWZBPT0iLCJ2YWx1ZSI6ImMxYlRPQ1pOUGVQa2Q1ZDBhZEQ5WVN4RUNCUUZrZ2NENlRia3l5TklSSlBcLzdydHVuSmU5eVNtZ2JSd1plNWtvIiwibWFjIjoiNWUwY2M5NTFmMWIyMzU3MDVlNDE4ZDE5NTMyMzU5MDYwNWIyOWNiMWM2NzVkNjhhMWI3YjU3MzY2YmJmNTU0MiJ9; expires=Tue, 06-May-2025 10:53:43 GMT; Max-Age=72000; path=/; httponly ◀pickjobs_session=eyJpdiI6InRodzRcLzdTYW9Fb3JSR052Tk1QNWZBPT0iLCJ2YWx1ZSI6ImMxYlRPQ1pOUGVQa2Q1ZDBhZEQ5WVN4RUNCUUZrZ2NENlRia3l5TklSSlBcLzdydHVuSmU5eVNtZ2JSd1plNWt ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6InFuSU5rZjJrcjFDZ1VBWXAxS3VnOHc9PSIsInZhbHVlIjoiUWx3NWQ0ZUlhMkFjMVl1RTNGSTRlMG50Um9zUWdxNWtUK2ZWXC9rZTJUbXBjdlwveUVUUFY5a2lLbFROXC9KU2pIVCIsIm1hYyI6ImNhODc1ZTQ5NWExMGVmNDc0YjhlNzBjMWNlYTE2M2M1Nzc5ODAyMDkzZjRjZTE0ZjUzMTNiZjNkYWQ3ZmJkMzcifQ%3D%3D; expires=Tue, 06-May-2025 10:53:43 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InFuSU5rZjJrcjFDZ1VBWXAxS3VnOHc9PSIsInZhbHVlIjoiUWx3NWQ0ZUlhMkFjMVl1RTNGSTRlMG50Um9zUWdxNWtUK2ZWXC9rZTJUbXBjdlwveUVUUFY5a2lLbFROXC9KU2pIVCIsI ▶"
    1 => "pickjobs_session=eyJpdiI6InRodzRcLzdTYW9Fb3JSR052Tk1QNWZBPT0iLCJ2YWx1ZSI6ImMxYlRPQ1pOUGVQa2Q1ZDBhZEQ5WVN4RUNCUUZrZ2NENlRia3l5TklSSlBcLzdydHVuSmU5eVNtZ2JSd1plNWtvIiwibWFjIjoiNWUwY2M5NTFmMWIyMzU3MDVlNDE4ZDE5NTMyMzU5MDYwNWIyOWNiMWM2NzVkNjhhMWI3YjU3MzY2YmJmNTU0MiJ9; expires=Tue, 06-May-2025 10:53:43 GMT; path=/; httponly ◀pickjobs_session=eyJpdiI6InRodzRcLzdTYW9Fb3JSR052Tk1QNWZBPT0iLCJ2YWx1ZSI6ImMxYlRPQ1pOUGVQa2Q1ZDBhZEQ5WVN4RUNCUUZrZ2NENlRia3l5TklSSlBcLzdydHVuSmU5eVNtZ2JSd1plNWt ▶"
  ]
]

session_attributes

  0 of 0   
array:8 [▶
  "currentLang" => App\Models\Language {#1397 ▶
    +timestamps: false
    #fillable: array:3 [▶
      0 => "slug"
      1 => "language_name"
      2 => "country_id"
    ]
    #table: "settings_languages"
    #connection: "mysql"
    #primaryKey: "id"
    #keyType: "int"
    +incrementing: true
    #with: []
    #withCount: []
    #perPage: 15
    +exists: true
    +wasRecentlyCreated: false
    #attributes: array:12 [▶
      "id" => 7
      "slug" => "sq"
      "country_id" => 2
      "language_name" => "Shqip"
      "currency" => "all"
      "eur_conversion_rate" => "122.59"
      "conversion_date" => "2021-06-25 12:00:07"
      "order_num" => 7
      "vat" => 0.0
      "invoice_note" => "This service is not subjected to VAT payment due to Article 17 Paragraph 1 of Croatian VAT Act.\r<br>Ova usluga ne podliježe plaćanju PDV-a prema odredbama članka 17. stavka 1. Zakona o PDV-u - prijenos porezne obveze (reverse charge). ◀This service is not subjected to VAT payment due to Article 17 Paragraph 1 of Croatian VAT Act.\r<br>Ova usluga ne podliježe plaćanju PDV-a prema odredbama član ▶"
      "job_translate" => 1
      "is_active" => 1
    ]
    #original: array:12 [▶
      "id" => 7
      "slug" => "sq"
      "country_id" => 2
      "language_name" => "Shqip"
      "currency" => "all"
      "eur_conversion_rate" => "122.59"
      "conversion_date" => "2021-06-25 12:00:07"
      "order_num" => 7
      "vat" => 0.0
      "invoice_note" => "This service is not subjected to VAT payment due to Article 17 Paragraph 1 of Croatian VAT Act.\r<br>Ova usluga ne podliježe plaćanju PDV-a prema odredbama članka 17. stavka 1. Zakona o PDV-u - prijenos porezne obveze (reverse charge). ◀This service is not subjected to VAT payment due to Article 17 Paragraph 1 of Croatian VAT Act.\r<br>Ova usluga ne podliježe plaćanju PDV-a prema odredbama član ▶"
      "job_translate" => 1
      "is_active" => 1
    ]
    #changes: []
    #casts: []
    #dates: []
    #dateFormat: null
    #appends: []
    #dispatchesEvents: []
    #observables: []
    #relations: []
    #touches: []
    #hidden: []
    #visible: []
    #guarded: array:1 [▶
      0 => "*"
    ]
  }
  "locale" => "sq"
  "autolang" => 1
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "_token" => "kaE6Qgy9cSAVDy70Jr8n1TtnXJhSKV0kUlBiFjX3"
  "defaultLang" => App\Models\Language {#1315 ▶
    +timestamps: false
    #fillable: array:3 [▶
      0 => "slug"
      1 => "language_name"
      2 => "country_id"
    ]
    #table: "settings_languages"
    #connection: "mysql"
    #primaryKey: "id"
    #keyType: "int"
    +incrementing: true
    #with: []
    #withCount: []
    #perPage: 15
    +exists: true
    +wasRecentlyCreated: false
    #attributes: array:12 [▶
      "id" => 2
      "slug" => "hr"
      "country_id" => 55
      "language_name" => "Hrvatski"
      "currency" => "eur"
      "eur_conversion_rate" => "1.00"
      "conversion_date" => "2022-12-31 12:00:02"
      "order_num" => 1
      "vat" => 0.25
      "invoice_note" => ""
      "job_translate" => 1
      "is_active" => 1
    ]
    #original: array:12 [▶
      "id" => 2
      "slug" => "hr"
      "country_id" => 55
      "language_name" => "Hrvatski"
      "currency" => "eur"
      "eur_conversion_rate" => "1.00"
      "conversion_date" => "2022-12-31 12:00:02"
      "order_num" => 1
      "vat" => 0.25
      "invoice_note" => ""
      "job_translate" => 1
      "is_active" => 1
    ]
    #changes: []
    #casts: []
    #dates: []
    #dateFormat: null
    #appends: []
    #dispatchesEvents: []
    #observables: []
    #relations: []
    #touches: []
    #hidden: []
    #visible: []
    #guarded: array:1 [▶
      0 => "*"
    ]
  }
  "_previous" => array:1 [▶
    "url" => "https://dev.pick.jobs/al"
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

1 x Application (90.5%)	216.57ms
1 x Booting (9.46%)	22.63ms