Regjistrohuni tani

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

Punë nga kategoria Mediat dhe marëdheniet me publikun

Vetëm student

Seasonal jobs

Më shumë se 10.000 shpalljeve aktive

Nxitës i filtrit nikotik

Zagreb, Kroacia
Hapur deri 12.12.2025

Nje veshtrim

Promotor Alkoholnih Pića

Zadar, Kroacia
Hapur deri 12.12.2025

Nje veshtrim

Plesač

Zagreb, Kroacia
Hapur deri 12.12.2025

Nje veshtrim

Menaxher dixhital PR

Pula, Kroacia
Hapur deri 12.12.2025

Nje veshtrim

Hostesa

Zagreb, Kroacia
Hapur deri 12.12.2025

Nje veshtrim

Shef i departamentit të PR

Split, Kroacia
Hapur deri 12.12.2025

Nje veshtrim

Akrobat

Rijeka, Kroacia
Hapur deri 12.12.2025

Nje veshtrim

Zonjë

Split, Kroacia
Hapur deri 12.12.2025

Nje veshtrim

Promotor

Šibenik, Kroacia
Hapur deri 12.12.2025

Nje veshtrim

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ë.

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.

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 Views14 Route Queries80 Mails Gate Session Request

7.4.3318ms8.49MBGET al/punet/{path}

Booting (36.52ms)
Application (281.41ms)
1 x Application (88.49%)
281.41ms
1 x Booting (11.48%)
36.52ms

14 templates were rendered

public.landing-custom-search (resources/views/public/landing-custom-search.blade.php)17blade


lang
occupations
pagination
region_place_id
html
jcat
title
title2
banners
total_pages
keywords
keywordsTitle
regions
latitude
longitude
category
address

Params
0	`lang`
1	`occupations`
2	`pagination`
3	`region_place_id`
4	`html`
5	`jcat`
6	`title`
7	`title2`
8	`banners`
9	`total_pages`
10	`keywords`
11	`keywordsTitle`
12	`regions`
13	`latitude`
14	`longitude`
15	`category`
16	`address`

public.landing_search.landing_search (resources/views/public/landing_search/landing_search.blade.php)27blade


obLevel
__env
app
errors
lang
occupations
pagination
region_place_id
html
jcat
title
title2
banners
total_pages
keywords
keywordsTitle
regions
latitude
longitude
category
address
titl
dt
description
ctitle
data_seo
seo_data

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lang`
5	`occupations`
6	`pagination`
7	`region_place_id`
8	`html`
9	`jcat`
10	`title`
11	`title2`
12	`banners`
13	`total_pages`
14	`keywords`
15	`keywordsTitle`
16	`regions`
17	`latitude`
18	`longitude`
19	`category`
20	`address`
21	`titl`
22	`dt`
23	`description`
24	`ctitle`
25	`data_seo`
26	`seo_data`

public.layouts.custom-search (resources/views/public/layouts/custom-search.blade.php)27blade


obLevel
__env
app
errors
lang
occupations
pagination
region_place_id
html
jcat
title
title2
banners
total_pages
keywords
keywordsTitle
regions
latitude
longitude
category
address
titl
dt
description
ctitle
data_seo
seo_data

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lang`
5	`occupations`
6	`pagination`
7	`region_place_id`
8	`html`
9	`jcat`
10	`title`
11	`title2`
12	`banners`
13	`total_pages`
14	`keywords`
15	`keywordsTitle`
16	`regions`
17	`latitude`
18	`longitude`
19	`category`
20	`address`
21	`titl`
22	`dt`
23	`description`
24	`ctitle`
25	`data_seo`
26	`seo_data`

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


obLevel
__env
app
errors
lang
occupations
pagination
region_place_id
html
jcat
title
title2
banners
total_pages
keywords
keywordsTitle
regions
latitude
longitude
category
address
titl
dt
description
ctitle
data_seo
seo_data

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lang`
5	`occupations`
6	`pagination`
7	`region_place_id`
8	`html`
9	`jcat`
10	`title`
11	`title2`
12	`banners`
13	`total_pages`
14	`keywords`
15	`keywordsTitle`
16	`regions`
17	`latitude`
18	`longitude`
19	`category`
20	`address`
21	`titl`
22	`dt`
23	`description`
24	`ctitle`
25	`data_seo`
26	`seo_data`

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


obLevel
__env
app
errors
lang
occupations
pagination
region_place_id
html
jcat
title
title2
banners
total_pages
keywords
keywordsTitle
regions
latitude
longitude
category
address
titl
dt
description
ctitle
data_seo
seo_data
headerMenuHtml
headerMenuHtmlMobile
languages

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lang`
5	`occupations`
6	`pagination`
7	`region_place_id`
8	`html`
9	`jcat`
10	`title`
11	`title2`
12	`banners`
13	`total_pages`
14	`keywords`
15	`keywordsTitle`
16	`regions`
17	`latitude`
18	`longitude`
19	`category`
20	`address`
21	`titl`
22	`dt`
23	`description`
24	`ctitle`
25	`data_seo`
26	`seo_data`
27	`headerMenuHtml`
28	`headerMenuHtmlMobile`
29	`languages`

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


obLevel
__env
app
errors
lang
occupations
pagination
region_place_id
html
jcat
title
title2
banners
total_pages
keywords
keywordsTitle
regions
latitude
longitude
category
address
titl
dt
description
ctitle
data_seo
seo_data

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lang`
5	`occupations`
6	`pagination`
7	`region_place_id`
8	`html`
9	`jcat`
10	`title`
11	`title2`
12	`banners`
13	`total_pages`
14	`keywords`
15	`keywordsTitle`
16	`regions`
17	`latitude`
18	`longitude`
19	`category`
20	`address`
21	`titl`
22	`dt`
23	`description`
24	`ctitle`
25	`data_seo`
26	`seo_data`

public.landing_search.landing_favorites (resources/views/public/landing_search/landing_favorites.blade.php)27blade


obLevel
__env
app
errors
lang
occupations
pagination
region_place_id
html
jcat
title
title2
banners
total_pages
keywords
keywordsTitle
regions
latitude
longitude
category
address
titl
dt
description
ctitle
data_seo
seo_data

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lang`
5	`occupations`
6	`pagination`
7	`region_place_id`
8	`html`
9	`jcat`
10	`title`
11	`title2`
12	`banners`
13	`total_pages`
14	`keywords`
15	`keywordsTitle`
16	`regions`
17	`latitude`
18	`longitude`
19	`category`
20	`address`
21	`titl`
22	`dt`
23	`description`
24	`ctitle`
25	`data_seo`
26	`seo_data`

public.landing_search.landing_kalkulator (resources/views/public/landing_search/landing_kalkulator.blade.php)27blade


obLevel
__env
app
errors
lang
occupations
pagination
region_place_id
html
jcat
title
title2
banners
total_pages
keywords
keywordsTitle
regions
latitude
longitude
category
address
titl
dt
description
ctitle
data_seo
seo_data

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lang`
5	`occupations`
6	`pagination`
7	`region_place_id`
8	`html`
9	`jcat`
10	`title`
11	`title2`
12	`banners`
13	`total_pages`
14	`keywords`
15	`keywordsTitle`
16	`regions`
17	`latitude`
18	`longitude`
19	`category`
20	`address`
21	`titl`
22	`dt`
23	`description`
24	`ctitle`
25	`data_seo`
26	`seo_data`

public.layouts.partials._custom-featured (resources/views/public/layouts/partials/_custom-featured.blade.php)32blade


obLevel
__env
app
errors
lang
occupations
pagination
region_place_id
html
jcat
title
title2
banners
total_pages
keywords
keywordsTitle
regions
latitude
longitude
category
address
titl
dt
description
ctitle
data_seo
seo_data
bannerType
bType
rnd
featuredPosts
postType

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lang`
5	`occupations`
6	`pagination`
7	`region_place_id`
8	`html`
9	`jcat`
10	`title`
11	`title2`
12	`banners`
13	`total_pages`
14	`keywords`
15	`keywordsTitle`
16	`regions`
17	`latitude`
18	`longitude`
19	`category`
20	`address`
21	`titl`
22	`dt`
23	`description`
24	`ctitle`
25	`data_seo`
26	`seo_data`
27	`bannerType`
28	`bType`
29	`rnd`
30	`featuredPosts`
31	`postType`

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


obLevel
__env
app
errors
lang
occupations
pagination
region_place_id
html
jcat
title
title2
banners
total_pages
keywords
keywordsTitle
regions
latitude
longitude
category
address
titl
dt
description
ctitle
data_seo
seo_data
bannerType
bType
rnd

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lang`
5	`occupations`
6	`pagination`
7	`region_place_id`
8	`html`
9	`jcat`
10	`title`
11	`title2`
12	`banners`
13	`total_pages`
14	`keywords`
15	`keywordsTitle`
16	`regions`
17	`latitude`
18	`longitude`
19	`category`
20	`address`
21	`titl`
22	`dt`
23	`description`
24	`ctitle`
25	`data_seo`
26	`seo_data`
27	`bannerType`
28	`bType`
29	`rnd`

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


obLevel
__env
app
errors
lang
occupations
pagination
region_place_id
html
jcat
title
title2
banners
total_pages
keywords
keywordsTitle
regions
latitude
longitude
category
address
titl
dt
description
ctitle
data_seo
seo_data
bannerType
bType
rnd
footerMenu

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lang`
5	`occupations`
6	`pagination`
7	`region_place_id`
8	`html`
9	`jcat`
10	`title`
11	`title2`
12	`banners`
13	`total_pages`
14	`keywords`
15	`keywordsTitle`
16	`regions`
17	`latitude`
18	`longitude`
19	`category`
20	`address`
21	`titl`
22	`dt`
23	`description`
24	`ctitle`
25	`data_seo`
26	`seo_data`
27	`bannerType`
28	`bType`
29	`rnd`
30	`footerMenu`

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


obLevel
__env
app
errors
lang
occupations
pagination
region_place_id
html
jcat
title
title2
banners
total_pages
keywords
keywordsTitle
regions
latitude
longitude
category
address
titl
dt
description
ctitle
data_seo
seo_data
bannerType
bType
rnd
footerMenu
year
ycopy

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lang`
5	`occupations`
6	`pagination`
7	`region_place_id`
8	`html`
9	`jcat`
10	`title`
11	`title2`
12	`banners`
13	`total_pages`
14	`keywords`
15	`keywordsTitle`
16	`regions`
17	`latitude`
18	`longitude`
19	`category`
20	`address`
21	`titl`
22	`dt`
23	`description`
24	`ctitle`
25	`data_seo`
26	`seo_data`
27	`bannerType`
28	`bType`
29	`rnd`
30	`footerMenu`
31	`year`
32	`ycopy`

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


obLevel
__env
app
errors
lang
occupations
pagination
region_place_id
html
jcat
title
title2
banners
total_pages
keywords
keywordsTitle
regions
latitude
longitude
category
address
titl
dt
description
ctitle
data_seo
seo_data
bannerType
bType
rnd
footerMenu
year
ycopy
buttonVisible
showPopup
profileFill
ids
viewHtml

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lang`
5	`occupations`
6	`pagination`
7	`region_place_id`
8	`html`
9	`jcat`
10	`title`
11	`title2`
12	`banners`
13	`total_pages`
14	`keywords`
15	`keywordsTitle`
16	`regions`
17	`latitude`
18	`longitude`
19	`category`
20	`address`
21	`titl`
22	`dt`
23	`description`
24	`ctitle`
25	`data_seo`
26	`seo_data`
27	`bannerType`
28	`bType`
29	`rnd`
30	`footerMenu`
31	`year`
32	`ycopy`
33	`buttonVisible`
34	`showPopup`
35	`profileFill`
36	`ids`
37	`viewHtml`

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


obLevel
__env
app
errors
lang
occupations
pagination
region_place_id
html
jcat
title
title2
banners
total_pages
keywords
keywordsTitle
regions
latitude
longitude
category
address
titl
dt
description
ctitle
data_seo
seo_data
bannerType
bType
rnd
footerMenu
year
ycopy
buttonVisible
v
cF
jsFile
countries
langs

Params
0	`obLevel`
1	`__env`
2	`app`
3	`errors`
4	`lang`
5	`occupations`
6	`pagination`
7	`region_place_id`
8	`html`
9	`jcat`
10	`title`
11	`title2`
12	`banners`
13	`total_pages`
14	`keywords`
15	`keywordsTitle`
16	`regions`
17	`latitude`
18	`longitude`
19	`category`
20	`address`
21	`titl`
22	`dt`
23	`description`
24	`ctitle`
25	`data_seo`
26	`seo_data`
27	`bannerType`
28	`bType`
29	`rnd`
30	`footerMenu`
31	`year`
32	`ycopy`
33	`buttonVisible`
34	`v`
35	`cF`
36	`jsFile`
37	`countries`
38	`langs`

uri: GET al/punet/{path}
middleware: web
controller: \App\Http\Controllers\FrontEnd\JobController@preview
namespace: App\Http\Controllers
prefix
where
file: app/Http/Controllers/FrontEnd/JobController.php:47-547

80 statements were executed, 52 of which were duplicated, 28 unique175.74ms

select * from `jobs` where `unique_id` = 'mediat-dhe-maredheniet-me-publikun' limit 16.19ms/app/Http/Controllers/FrontEnd/JobController.php:68pick

Metadata
Bindings	0. mediat-dhe-maredheniet-me-publikun
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/Http/Controllers/FrontEnd/JobController.php:68 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 `jobs_descriptions` where `slug` = 'mediat-dhe-maredheniet-me-publikun' limit 14.6ms/app/Http/Controllers/FrontEnd/JobController.php:78pick

Metadata
Bindings	0. mediat-dhe-maredheniet-me-publikun
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/Http/Controllers/FrontEnd/JobController.php:78 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 `jobs_descriptions` where `job_id` = 0 limit 1250μs/app/Http/Controllers/FrontEnd/JobController.php:90pick

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/Http/Controllers/FrontEnd/JobController.php:90 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 `occupations_trans` where `occupations_trans`.`slug` = 'mediat-dhe-maredheniet-me-publikun'5.13ms/app/Http/Controllers/FrontEnd/JobController.php:128pick

Metadata
Bindings	0. mediat-dhe-maredheniet-me-publikun
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	12. /app/Http/Controllers/FrontEnd/JobController.php:128 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 * from `settings_languages` where `slug` = 'hr' limit 1250μs/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/JobController.php:135 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.21ms/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/JobController.php:135 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 `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 03:38:26' and (`banners`.`lasts_until` >= '2025-05-05 03:38:26' or `banners`.`lasts_until` = '0000-00-00 00:00:00') and (`banners`.`langs` like '%sq%') and `banners`.`banner_position` LIKE 'blog%' order by RAND()

760μs/app/Repositories/BannerRepository.php:110pick

Metadata
Bindings	0. 1 1. 2025-05-05 03:38:26 2. 2025-05-05 03:38:26 3. 0000-00-00 00:00:00 4. %sq% 5. blog%
Hints	`ORDER BY RAND()` is slow, try to avoid if you can. You can read this or this
Backtrace	14. /app/Repositories/BannerRepository.php:110 15. /app/Http/Controllers/FrontEnd/JobController.php:179 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 `region_place_id`, `region` from `jobs` where `country_id` = 55 and `region` <> '' group by `region_place_id` order by `region` asc

11.98ms/app/Http/Controllers/FrontEnd/JobController.php:185pick

Metadata
Bindings	0. 55 1.
Backtrace	12. /app/Http/Controllers/FrontEnd/JobController.php:185 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/JobController.php:185
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 * from `menus` where `menu_type` = '0' limit 1270μ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.custom-search:4 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-custom-search:77 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

3.19ms/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.custom-search:4 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-custom-search:77 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

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.custom-search:4 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-custom-search:77 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.custom-search:4
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-custom-search:77
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

260μ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.custom-search:4 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-custom-search:77 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.custom-search:4
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-custom-search:77
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

590μ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.custom-search:4 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-custom-search:77 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

970μs/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.custom-search:4 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-custom-search:77 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` asc3.56ms/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.custom-search:4 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-custom-search:77 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.custom-search:4
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-custom-search:77
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

290μ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.custom-search:4 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-custom-search:77 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` 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.custom-search:4 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-custom-search:77 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.custom-search:4
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-custom-search:77
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

11.01ms/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.custom-search:4 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-custom-search:77 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.custom-search:4
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-custom-search:77
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.custom-search:4 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-custom-search:77 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.custom-search:4
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-custom-search:77
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

910μ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.custom-search:4 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-custom-search:77 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.custom-search:4
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-custom-search:77
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

1.12ms/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.custom-search:4 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-custom-search:77 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` asc840μ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.custom-search:4 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-custom-search:77 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.custom-search:4
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-custom-search:77
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

3.28ms/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.custom-search:4 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-custom-search:77 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` asc940μ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.custom-search:4 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-custom-search:77 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.custom-search:4
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-custom-search:77
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

2.24ms/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.custom-search:4 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-custom-search:77 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.custom-search:4
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-custom-search:77
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

940μ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.custom-search:4 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-custom-search:77 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.custom-search:4
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-custom-search:77
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

1.88ms/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.custom-search:4 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-custom-search:77 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

4.23ms/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.custom-search:4 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-custom-search:77 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` asc410μ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.custom-search:4 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-custom-search:77 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.custom-search:4
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-custom-search:77
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

2.29ms/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.custom-search:4 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-custom-search:77 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` asc1.39ms/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.custom-search:4 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-custom-search:77 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.custom-search:4
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-custom-search:77
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

390μ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.custom-search:4 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-custom-search:77 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.custom-search:4
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-custom-search:77
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

1.6ms/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.custom-search:4 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-custom-search:77 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. 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.custom-search:4
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-custom-search:77
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

7.27ms/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.custom-search:4 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-custom-search:77 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. 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.custom-search:4
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-custom-search:77
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 1230μs/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.custom-search:4 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-custom-search:77 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

1.87ms/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.custom-search:4 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-custom-search:77 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` asc1.01ms/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.custom-search:4
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-custom-search:77
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

870μ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.custom-search:4
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-custom-search:77
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

870μ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.custom-search:4 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-custom-search:77 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

880μ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.custom-search:4 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-custom-search:77 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` asc1.38ms/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.custom-search:4
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-custom-search:77
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

700μ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.custom-search:4 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-custom-search:77 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` asc1.06ms/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.custom-search:4
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-custom-search:77
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

1.15ms/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.custom-search:4
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-custom-search:77
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

460μ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.custom-search:4
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-custom-search:77
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

1.32ms/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.custom-search:4
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-custom-search:77
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

290μ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.custom-search:4 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-custom-search:77 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` asc4.19ms/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.custom-search:4
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-custom-search:77
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

890μ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.custom-search:4 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-custom-search:77 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.4ms/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.custom-search:4
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-custom-search:77
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

850μ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.custom-search:4
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-custom-search:77
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

790μ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.custom-search:4
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-custom-search:77
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

1.35ms/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.custom-search:4 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-custom-search:77 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

3.58ms/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.custom-search:4 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-custom-search:77 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` asc3.63ms/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.custom-search:4
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-custom-search:77
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

890μ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.custom-search:4 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-custom-search:77 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` asc980μ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.custom-search:4
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-custom-search:77
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

860μ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.custom-search:4
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-custom-search:77
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

760μ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.custom-search:4
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-custom-search:77
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

2.84ms/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.custom-search:4
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-custom-search:77
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

3.89ms/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.custom-search:4 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-custom-search:77 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

6.07ms/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.custom-search:4 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-custom-search:77 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 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 `categories`.`type` = 'blog' and `posts`.`language_id` = 7 and `categories_trans`.`language_id` = 7 and `posts`.`is_featured` = 1 and `is_published` = 1

1.44ms/app/Models/Post.php:386pick

Metadata

Bindings

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

Backtrace

15. /app/Models/Post.php:386
16. /app/Providers/ViewServiceProvider.php:320
19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
20. /vendor/laravel/framework/src/Illuminate/View/View.php:123
21. /vendor/laravel/framework/src/Illuminate/View/View.php:90
22. view::public.layouts.custom-search:40
24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
25. /vendor/laravel/framework/src/Illuminate/View/View.php:142
26. /vendor/laravel/framework/src/Illuminate/View/View.php:125
27. /vendor/laravel/framework/src/Illuminate/View/View.php:90
28. view::public.landing-custom-search:77
30. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
31. /vendor/laravel/framework/src/Illuminate/View/View.php:142
32. /vendor/laravel/framework/src/Illuminate/View/View.php:125
33. /vendor/laravel/framework/src/Illuminate/View/View.php:90
34. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
35. /vendor/symfony/http-foundation/Response.php:202
36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
39. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
40. /app/Http/Controllers/Controller.php:36
41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
43. /app/Http/Middleware/Localization.php:64
44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
46. middleware::bindings:41
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/Foundation/Http/Middleware/VerifyCsrfToken.php:75

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` = 'blog' and `posts`.`language_id` = 7 and `categories_trans`.`language_id` = 7 and `posts`.`is_featured` = 1 and `is_published` = 1 order by `posts`.`created_at` desc limit 4 offset 0

2.22ms/app/Models/Post.php:386pick

Metadata
Bindings	0. blog 1. 7 2. 7 3. 1 4. 1
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	15. /app/Models/Post.php:386 16. /app/Providers/ViewServiceProvider.php:320 19. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 20. /vendor/laravel/framework/src/Illuminate/View/View.php:123 21. /vendor/laravel/framework/src/Illuminate/View/View.php:90 22. view::public.layouts.custom-search:40 24. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 25. /vendor/laravel/framework/src/Illuminate/View/View.php:142 26. /vendor/laravel/framework/src/Illuminate/View/View.php:125 27. /vendor/laravel/framework/src/Illuminate/View/View.php:90 28. view::public.landing-custom-search:77 30. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 31. /vendor/laravel/framework/src/Illuminate/View/View.php:142 32. /vendor/laravel/framework/src/Illuminate/View/View.php:125 33. /vendor/laravel/framework/src/Illuminate/View/View.php:90 34. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 35. /vendor/symfony/http-foundation/Response.php:202 36. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 37. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 38. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 39. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 40. /app/Http/Controllers/Controller.php:36 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 43. /app/Http/Middleware/Localization.php:64 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 46. middleware::bindings:41 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/Foundation/Http/Middleware/VerifyCsrfToken.php:75

select * from `menus` where `menu_type` = '1' limit 1270μ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.custom-search:53 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-custom-search:77 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

5.62ms/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.custom-search:53 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-custom-search:77 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` asc350μ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.custom-search:53
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-custom-search:77
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

310μ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.custom-search:53
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-custom-search:77
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

4.06ms/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.custom-search:53 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-custom-search:77 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` 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.custom-search:53
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-custom-search:77
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

350μ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.custom-search:53 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-custom-search:77 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` asc1.55ms/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.custom-search:53
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-custom-search:77
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

2.52ms/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.custom-search:53 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-custom-search:77 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` asc1.04ms/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.custom-search:53
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-custom-search:77
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

2.86ms/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.custom-search:53 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-custom-search:77 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` asc950μ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.custom-search:53
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-custom-search:77
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

2.55ms/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.custom-search:53 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-custom-search:77 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` = 21.08ms/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.custom-search:53
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-custom-search:77
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

11.23ms/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.custom-search:53
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-custom-search:77
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

9.98ms/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.custom-search:53 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-custom-search:77 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 {#1406 +timestamps: false #fillable: array:3 [ 0 => "slug" 1 => "lan...
locale: sq
autolang: 1
_flash: array:2 [ "old" => [] "new" => [] ]
_token: kf66K4l6U3ayHRhk7rVy588TZfH0VNtBiyJpGe6Q
defaultLang: App\Models\Language {#1405 +timestamps: false #fillable: array:3 [ 0 => "slug" 1 => "lan...
_previous: array:1 [ "url" => "https://dev.pick.jobs/al/punet/mediat-dhe-maredheniet-me-publikun" ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/al/punet/mediat-dhe-maredheniet-me-publikun

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" => "3a09a8e1d6800e7fc1f89c5410c43b07b4f25cdabb25bcde6930a76d2939bfa8"
  "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.191.166.168"
  "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" => "26774"
  "REDIRECT_URL" => "/al/punet/mediat-dhe-maredheniet-me-publikun"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/al/punet/mediat-dhe-maredheniet-me-publikun"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1746409106.766
  "REQUEST_TIME" => 1746409106
]

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 01:38:26 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im1GQUxZdzg0RER2T0Y4T2JNWW1sNHc9PSIsInZhbHVlIjoibENGRVwvTFJYaFh4d293Wm5Pb25yWEhcLzBkaTNVb1ZVeGZMb1B4WEdBVE1tams5M05TSll1UXFQOUt0dDNtMDRXIiwibWFjIjoiMmE2MDQ4NTU1ZTRkZmE4YmM1ZmQwYzgwZmZkOWZiZTdkMjhiOTBhMmU0NzFkZTcyNzhkY2Q2YTliZWRmYjFlYiJ9; expires=Mon, 05-May-2025 21:38:27 GMT; Max-Age=72000; path=/ ◀XSRF-TOKEN=eyJpdiI6Im1GQUxZdzg0RER2T0Y4T2JNWW1sNHc9PSIsInZhbHVlIjoibENGRVwvTFJYaFh4d293Wm5Pb25yWEhcLzBkaTNVb1ZVeGZMb1B4WEdBVE1tams5M05TSll1UXFQOUt0dDNtMDRXIiwib ▶"
    1 => "pickjobs_session=eyJpdiI6IkhPU0ZiaHpXWHBDcHBPNjJcL0NsNzlnPT0iLCJ2YWx1ZSI6ImR4dEEzTDREXC84cFdJOWxyNkNcLzJJdmxcL092a0szRXR6NjVWa2pKXC9qMHY3em5UR0NSMjN1ek9oV1BwdldPTlJqIiwibWFjIjoiZjBlNDA0OWNkNDJiODdhODg5ZThhYzBmMGVkZmQ0NTA5YTg4MDgzNTc1YjZhMTk3Y2UzNGJjZjVhNGE3YzhjMSJ9; expires=Mon, 05-May-2025 21:38:27 GMT; Max-Age=72000; path=/; httponly ◀pickjobs_session=eyJpdiI6IkhPU0ZiaHpXWHBDcHBPNjJcL0NsNzlnPT0iLCJ2YWx1ZSI6ImR4dEEzTDREXC84cFdJOWxyNkNcLzJJdmxcL092a0szRXR6NjVWa2pKXC9qMHY3em5UR0NSMjN1ek9oV1Bwdld ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6Im1GQUxZdzg0RER2T0Y4T2JNWW1sNHc9PSIsInZhbHVlIjoibENGRVwvTFJYaFh4d293Wm5Pb25yWEhcLzBkaTNVb1ZVeGZMb1B4WEdBVE1tams5M05TSll1UXFQOUt0dDNtMDRXIiwibWFjIjoiMmE2MDQ4NTU1ZTRkZmE4YmM1ZmQwYzgwZmZkOWZiZTdkMjhiOTBhMmU0NzFkZTcyNzhkY2Q2YTliZWRmYjFlYiJ9; expires=Mon, 05-May-2025 21:38:27 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Im1GQUxZdzg0RER2T0Y4T2JNWW1sNHc9PSIsInZhbHVlIjoibENGRVwvTFJYaFh4d293Wm5Pb25yWEhcLzBkaTNVb1ZVeGZMb1B4WEdBVE1tams5M05TSll1UXFQOUt0dDNtMDRXIiwib ▶"
    1 => "pickjobs_session=eyJpdiI6IkhPU0ZiaHpXWHBDcHBPNjJcL0NsNzlnPT0iLCJ2YWx1ZSI6ImR4dEEzTDREXC84cFdJOWxyNkNcLzJJdmxcL092a0szRXR6NjVWa2pKXC9qMHY3em5UR0NSMjN1ek9oV1BwdldPTlJqIiwibWFjIjoiZjBlNDA0OWNkNDJiODdhODg5ZThhYzBmMGVkZmQ0NTA5YTg4MDgzNTc1YjZhMTk3Y2UzNGJjZjVhNGE3YzhjMSJ9; expires=Mon, 05-May-2025 21:38:27 GMT; path=/; httponly ◀pickjobs_session=eyJpdiI6IkhPU0ZiaHpXWHBDcHBPNjJcL0NsNzlnPT0iLCJ2YWx1ZSI6ImR4dEEzTDREXC84cFdJOWxyNkNcLzJJdmxcL092a0szRXR6NjVWa2pKXC9qMHY3em5UR0NSMjN1ek9oV1Bwdld ▶"
  ]
]

session_attributes

  0 of 0   
array:8 [▶
  "currentLang" => App\Models\Language {#1406 ▶
    +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" => "kf66K4l6U3ayHRhk7rVy588TZfH0VNtBiyJpGe6Q"
  "defaultLang" => App\Models\Language {#1405 ▶
    +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/punet/mediat-dhe-maredheniet-me-publikun"
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

Punë nga kategoria Mediat dhe marëdheniet me publikun

Pravo vrijeme

Nxitës i filtrit nikotik

Pravo vrijeme

Promotor Alkoholnih Pića

Pravo vrijeme

Plesač

Pravo vrijeme

Menaxher dixhital PR

Pravo vrijeme

Hostesa

Pravo vrijeme

Shef i departamentit të PR

Pravo vrijeme

Akrobat

Pravo vrijeme

Zonjë

Pravo vrijeme

Promotor

Aplikimi celular PickJobs

Lajme

FAQ

Rreth nesh

Juridik

Izjava o sufinanciranju

Partnerët tanë

cookies

Aplikimi celular PickJobs

1 x Application (88.49%)	281.41ms
1 x Booting (11.48%)	36.52ms