Зареєструватись

Хорватія Боснія і Герцеговина Сербія Чорногорія Північна Македонія Албанія Косово Австрія Німеччина Швейцарія Об'єднане Королівство

Вакансії в категорії Сільське господарство та агробізнес

Тільки студентські

Seasonal jobs

понад 10.000 активних оголошень

Агроном

Zagreb, Хорватія
Відкрито до 12.12.2025

Переглянути

Агрономія міжнар

Zagreb, Хорватія
Відкрито до 12.12.2025

Переглянути

Тест на агронома

Zagrađe, Хорватія
Відкрито до 12.12.2025

Переглянути

Вікторина для Томісальви

Berlin, Німеччина
Відкрито до 12.12.2025

Переглянути

Агроном

Zagrad, Хорватія
Відкрито до 12.12.2025

Переглянути

Агроном

Počitelj, Боснія і Герцеговина
Відкрито до 12.12.2025

Переглянути

Агроном

Zagora, Боснія і Герцеговина
Відкрито до 12.12.2025

Переглянути

Сільськогосподарський працівник (м / ж)

Хорватія
Відкрито до 12.12.2025

Переглянути

садівник

Zürich, Швейцарія
Відкрито до 12.12.2025

Переглянути

Продавець хлібобулочних виробів

Donji Kraljevec, Хорватія
Відкрито до 12.12.2025

Переглянути

Робітник сільського господарства (м/ж)

Хорватія
Відкрито до 12.12.2025

Переглянути

Мобільний додаток PickJobs

Завантажте безкоштовний мобільний додаток PickJobs на свій Android або iOS, через Google Play Store або App Store та отримайте доступ до можливостей будь-де та в будь-який час.

Ви шукаєте роботу? Шукаєте нових працівників? Ви розглядаєте нові можливості? Створіть свій профіль, контролюйте його вміст і станьте конкурентоспроможним у досягненні своїх цілей.

Заява про співфінансування

Кінцевим одержувачем фінансового інструменту, співфінансованого з Європейського фонду відповідального за регіональний розвиток в рамках Оперативної програми є «Конкурентоспроможність та згуртованість»

Наші партнери

Політика щодо cookie

Для найкращого користувацького досвіду та повної функціональності всіх опцій сайту, PickJobs використовує файли cookie та подібні технології. Якщо ви продовжуєте використовувати цей сайт, ми вважатимемо, що ви прийняли та погодилися з нашою Політикою щодо cookie. Докладніше про Політику щодо cookie.

Приймаю

Messages Timeline Exceptions Views14 Route Queries80 Mails Gate Session Request

7.4.3251.2ms8.58MBGET ua/robochi-miscya/{path}

Booting (30.88ms)
Application (220.18ms)
1 x Application (87.65%)
220.18ms
1 x Booting (12.29%)
30.88ms

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 ua/robochi-miscya/{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 unique58.97ms

select * from `jobs` where `unique_id` = 'silske-gospodarstvo-ta-agrobiznes' limit 1490μs/app/Http/Controllers/FrontEnd/JobController.php:68pick

Metadata
Bindings	0. silske-gospodarstvo-ta-agrobiznes
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` = 'silske-gospodarstvo-ta-agrobiznes' limit 13.88ms/app/Http/Controllers/FrontEnd/JobController.php:78pick

Metadata
Bindings	0. silske-gospodarstvo-ta-agrobiznes
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 1280μ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` = 'silske-gospodarstvo-ta-agrobiznes'360μs/app/Http/Controllers/FrontEnd/JobController.php:128pick

Metadata
Bindings	0. silske-gospodarstvo-ta-agrobiznes
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(uk_occupations_trans.occupation_name, hr_occupations_trans.occupation_name) as name from `occupations` left join `occupations_trans` as `uk_occupations_trans` on `uk_occupations_trans`.`occupation_id` = `occupations`.`id` and `uk_occupations_trans`.`language_id` = 5 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.26ms/app/Models/Occupation.php:136pick

Metadata
Bindings	0. 5 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-04-25 00:04:00' and (`banners`.`lasts_until` >= '2025-04-25 00:04:00' or `banners`.`lasts_until` = '0000-00-00 00:00:00') and (`banners`.`langs` like '%uk%') and `banners`.`banner_position` LIKE 'blog%' order by RAND()

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

Metadata
Bindings	0. 1 1. 2025-04-25 00:04:00 2. 2025-04-25 00:04:00 3. 0000-00-00 00:00:00 4. %uk% 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

7.47ms/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 15.05ms/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` = 5 and `parent_id` = '0' order by `menu_order` asc

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

Metadata
Bindings	0. 2 1. 5 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 (243, 244, 248, 251, 252) order by `menu_order` asc1.94ms/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 (245, 246, 247, 249, 250, 254, 255, 256) order by `menu_order` asc

250μ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` = 243 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc

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

Metadata
Bindings	0. 243
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` = 244 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc

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

Metadata
Bindings	0. 244
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 (245, 246, 247) order by `menu_order` asc240μ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` = 244 and `menus_items`.`parent_id` is not null order by `menu_order` asc

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

Metadata
Bindings	0. 244
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 (245, 246, 247) order by `menu_order` asc250μs/app/Models/MenuItem.php:107pick

Metadata

Metadata
Hints	Use `SELECT *` only if you need all columns from table
Backtrace	20. /app/Models/MenuItem.php:107 21. /app/Services/MenuService.php:100 22. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 23. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 24. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 25. /app/Services/MenuService.php:106 26. /app/Providers/ViewServiceProvider.php:104 29. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 30. /vendor/laravel/framework/src/Illuminate/View/View.php:123 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.layouts.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` = 245 and `menus_items`.`parent_id` is not null

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

Metadata
Bindings	0. 245
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. 245

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` = 246 and `menus_items`.`parent_id` is not null

1.33ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick

Metadata
Bindings	0. 246
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. 246

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` = 247 and `menus_items`.`parent_id` is not null

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

Metadata
Bindings	0. 247
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. 247

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` = 248 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc

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

Metadata
Bindings	0. 248
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 (249, 250) order by `menu_order` asc230μ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` = 248 and `menus_items`.`parent_id` is not null order by `menu_order` asc

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

Metadata
Bindings	0. 248
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 (249, 250) order by `menu_order` asc270μ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` = 249 and `menus_items`.`parent_id` is not null

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

Metadata
Bindings	0. 249
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. 249

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` = 250 and `menus_items`.`parent_id` is not null

1.08ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick

Metadata
Bindings	0. 250
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. 250

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` = 251 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc

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

Metadata
Bindings	0. 251
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` = 252 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc

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

Metadata
Bindings	0. 252
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 (254, 255, 256) order by `menu_order` asc250μ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` = 252 and `menus_items`.`parent_id` is not null order by `menu_order` asc

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

Metadata
Bindings	0. 252
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 (254, 255, 256) order by `menu_order` asc300μ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` = 254 and `menus_items`.`parent_id` is not null

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

Metadata
Bindings	0. 254
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. 254

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` = 255 and `menus_items`.`parent_id` is not null

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

Metadata
Bindings	0. 255
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. 255

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` = 256 and `menus_items`.`parent_id` is not null

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

Metadata
Bindings	0. 256
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. 256

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 1310μ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` = 5 and `parent_id` = '0' order by `menu_order` asc

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

Metadata
Bindings	0. 2 1. 5 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 (243, 244, 248, 251, 252) order by `menu_order` asc300μs/app/Models/Menu.php:72pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Models/Menu.php:72
21. /app/Services/MenuService.php:126
22. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
23. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
24. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
25. /app/Services/MenuService.php:152
26. /app/Providers/ViewServiceProvider.php:105
29. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
30. /vendor/laravel/framework/src/Illuminate/View/View.php:123
31. /vendor/laravel/framework/src/Illuminate/View/View.php:90
32. view::public.layouts.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 (245, 246, 247, 249, 250, 254, 255, 256) order by `menu_order` asc

260μ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` = 243 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc

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

Metadata
Bindings	0. 243
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` = 244 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc

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

Metadata
Bindings	0. 244
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 (245, 246, 247) order by `menu_order` asc250μs/app/Services/MenuService.php:131pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Services/MenuService.php:131
21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
23. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
24. /app/Services/MenuService.php:152
25. /app/Providers/ViewServiceProvider.php:105
28. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
29. /vendor/laravel/framework/src/Illuminate/View/View.php:123
30. /vendor/laravel/framework/src/Illuminate/View/View.php:90
31. view::public.layouts.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` = 244 and `menus_items`.`parent_id` is not null order by `menu_order` asc

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

Metadata
Bindings	0. 244
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 (245, 246, 247) order by `menu_order` asc330μ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` = 245 and `menus_items`.`parent_id` is not null

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

Metadata

Bindings

0. 245

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` = 246 and `menus_items`.`parent_id` is not null

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

Metadata

Bindings

0. 246

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` = 247 and `menus_items`.`parent_id` is not null

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

Metadata

Bindings

0. 247

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` = 248 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc

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

Metadata
Bindings	0. 248
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 (249, 250) order by `menu_order` asc260μs/app/Services/MenuService.php:131pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Services/MenuService.php:131
21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
23. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
24. /app/Services/MenuService.php:152
25. /app/Providers/ViewServiceProvider.php:105
28. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
29. /vendor/laravel/framework/src/Illuminate/View/View.php:123
30. /vendor/laravel/framework/src/Illuminate/View/View.php:90
31. view::public.layouts.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` = 248 and `menus_items`.`parent_id` is not null order by `menu_order` asc

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

Metadata
Bindings	0. 248
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 (249, 250) order by `menu_order` asc240μ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` = 249 and `menus_items`.`parent_id` is not null

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

Metadata

Bindings

0. 249

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` = 250 and `menus_items`.`parent_id` is not null

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

Metadata

Bindings

0. 250

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` = 251 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc

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

Metadata
Bindings	0. 251
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` = 252 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. 252
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 (254, 255, 256) order by `menu_order` asc250μs/app/Services/MenuService.php:131pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Services/MenuService.php:131
21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
23. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
24. /app/Services/MenuService.php:152
25. /app/Providers/ViewServiceProvider.php:105
28. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
29. /vendor/laravel/framework/src/Illuminate/View/View.php:123
30. /vendor/laravel/framework/src/Illuminate/View/View.php:90
31. view::public.layouts.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` = 252 and `menus_items`.`parent_id` is not null order by `menu_order` asc

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

Metadata
Bindings	0. 252
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 (254, 255, 256) order by `menu_order` asc240μ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` = 254 and `menus_items`.`parent_id` is not null

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

Metadata

Bindings

0. 254

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` = 255 and `menus_items`.`parent_id` is not null

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

Metadata

Bindings

0. 255

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` = 256 and `menus_items`.`parent_id` is not null

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

Metadata

Bindings

0. 256

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` = 5 order by `settings_countries`.`priority` asc

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

Metadata
Bindings	0. 1 1. 5
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` = 5 and `settings_countries`.`id` = 229 order by `settings_languages`.`order_num` asc

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

Metadata
Bindings	0. 1 1. 5 2. 229
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` = 5 and `categories_trans`.`language_id` = 5 and `posts`.`is_featured` = 1 and `is_published` = 1

530μs/app/Models/Post.php:386pick

Metadata

Bindings

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

690μs/app/Models/Post.php:386pick

Metadata
Bindings	0. blog 1. 5 2. 5 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` = 5 and `parent_id` = '0' order by `menu_order` asc

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

Metadata
Bindings	0. 3 1. 5 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 (222, 226, 232, 238) order by `menu_order` asc360μs/app/Models/Menu.php:72pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Models/Menu.php:72
21. /app/Services/MenuService.php:424
22. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
23. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
24. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
25. /app/Services/MenuService.php:443
26. /app/Providers/ViewServiceProvider.php:239
29. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
30. /vendor/laravel/framework/src/Illuminate/View/View.php:123
31. /vendor/laravel/framework/src/Illuminate/View/View.php:90
32. view::public.layouts.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 (223, 224, 225, 227, 228, 229, 230, 231, 233, 235, 237, 239, 240, 241, 242, 457) order by `menu_order` asc

300μ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` = 222 and `menus_items`.`parent_id` is not null order by `menu_order` asc

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

Metadata
Bindings	0. 222
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 (223, 224, 225) order by `menu_order` asc240μ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` = 226 and `menus_items`.`parent_id` is not null order by `menu_order` asc

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

Metadata
Bindings	0. 226
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 (227, 228, 229, 230, 231) order by `menu_order` asc300μ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` = 232 and `menus_items`.`parent_id` is not null order by `menu_order` asc

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

Metadata
Bindings	0. 232
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 (233, 235, 237, 457) 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` = 238 and `menus_items`.`parent_id` is not null order by `menu_order` asc

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

Metadata
Bindings	0. 238
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 (239, 240, 241, 242) 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 `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` = 5 group by `slug` order by `settings_languages`.`order_num` asc

1.24ms/app/Models/Language.php:166pick

Metadata
Bindings	0. 1 1. 5
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` = 5 and `country_id` = 229370μs/app/Models/Country.php:53pick

Metadata

Bindings

0. 5
1. 229

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` = 5 group by `settings_countries_trans`.`country_name`, `settings_countries_trans`.`country_id` order by `settings_countries`.`priority` asc, `settings_countries_trans`.`country_name` asc

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

Metadata

Bindings

0. 1
1. 5

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(uk_occupations_trans.occupation_name, hr_occupations_trans.occupation_name) as name, coalesce(uk_occupations_trans.description, hr_occupations_trans.description) as description from `occupations` left join `occupations_trans` as `uk_occupations_trans` on `uk_occupations_trans`.`occupation_id` = `occupations`.`id` and `uk_occupations_trans`.`language_id` = 5 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.52ms/app/Models/Occupation.php:48pick

Metadata
Bindings	0. 5 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 {#1442 +timestamps: false #fillable: array:3 [ 0 => "slug" 1 => "lan...
locale: uk
autolang: 1
_flash: array:2 [ "old" => [] "new" => [] ]
_token: ES5ey84uS0Pa5Idr2spnvQOHmvoNJVZAjnl00lGZ
defaultLang: App\Models\Language {#1441 +timestamps: false #fillable: array:3 [ 0 => "slug" 1 => "lan...
_previous: array:1 [ "url" => "https://dev.pick.jobs/ua/robochi-miscya/silske-gospodarstvo-ta-agrobiznes" ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/ua/robochi-miscya/silske-gospodarstvo-ta-agrobiznes

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 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "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" => "a6121ee1a5f3943b4c170dab443feb4b8fb0de352f2494404599aa7f2ea3e101"
  "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" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  "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.219.197.191"
  "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" => "29166"
  "REDIRECT_URL" => "/ua/robochi-miscya/silske-gospodarstvo-ta-agrobiznes"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "REQUEST_METHOD" => "GET"
  "QUERY_STRING" => ""
  "REQUEST_URI" => "/ua/robochi-miscya/silske-gospodarstvo-ta-agrobiznes"
  "SCRIPT_NAME" => "/index.php"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1745532240.331
  "REQUEST_TIME" => 1745532240
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Thu, 24 Apr 2025 22:04:00 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkMrWVdlalRNRXdXY2JJVzAyM3VPRkE9PSIsInZhbHVlIjoiVW1sQmR4c01wUFh5SHN2NGdCYzZGTVNTTVJFSituYkwwR09tQ0lCdjFKNVwvbXhISlRrYWN2OVJ3MGdCeGttYzUiLCJtYWMiOiI5MGJlZmE1MzMwMjRiNjdhZGY3NGE5ODU4NTVhNDQzNDM1ZDk5MjZjZmViZjFmNmUyNTc0NGJiMWQwODBjMmM0In0%3D; expires=Fri, 25-Apr-2025 18:04:00 GMT; Max-Age=72000; path=/ ◀XSRF-TOKEN=eyJpdiI6IkMrWVdlalRNRXdXY2JJVzAyM3VPRkE9PSIsInZhbHVlIjoiVW1sQmR4c01wUFh5SHN2NGdCYzZGTVNTTVJFSituYkwwR09tQ0lCdjFKNVwvbXhISlRrYWN2OVJ3MGdCeGttYzUiLCJtY ▶"
    1 => "pickjobs_session=eyJpdiI6IitYZjhGRnFoWitDMlRNRFwvN2ZNbmxBPT0iLCJ2YWx1ZSI6IjVaNkdVS2k1bUVjdTRvVjVvZWFKVkltRnJyamJ5WXk1SGdTTXhuZ2xFTERYcHRKeGlLRlFVTVRPZFFsaWRNa2wiLCJtYWMiOiI1NWRmZDhkMjNiMzY3OWJhYTZhMjU2Yzc0YWRkYWY4NzhkMjY4YjViYTUwYWRhYTllOTVjOWM4YmJjYmViYTk1In0%3D; expires=Fri, 25-Apr-2025 18:04:00 GMT; Max-Age=72000; path=/; httponly ◀pickjobs_session=eyJpdiI6IitYZjhGRnFoWitDMlRNRFwvN2ZNbmxBPT0iLCJ2YWx1ZSI6IjVaNkdVS2k1bUVjdTRvVjVvZWFKVkltRnJyamJ5WXk1SGdTTXhuZ2xFTERYcHRKeGlLRlFVTVRPZFFsaWRNa2w ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkMrWVdlalRNRXdXY2JJVzAyM3VPRkE9PSIsInZhbHVlIjoiVW1sQmR4c01wUFh5SHN2NGdCYzZGTVNTTVJFSituYkwwR09tQ0lCdjFKNVwvbXhISlRrYWN2OVJ3MGdCeGttYzUiLCJtYWMiOiI5MGJlZmE1MzMwMjRiNjdhZGY3NGE5ODU4NTVhNDQzNDM1ZDk5MjZjZmViZjFmNmUyNTc0NGJiMWQwODBjMmM0In0%3D; expires=Fri, 25-Apr-2025 18:04:00 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkMrWVdlalRNRXdXY2JJVzAyM3VPRkE9PSIsInZhbHVlIjoiVW1sQmR4c01wUFh5SHN2NGdCYzZGTVNTTVJFSituYkwwR09tQ0lCdjFKNVwvbXhISlRrYWN2OVJ3MGdCeGttYzUiLCJtY ▶"
    1 => "pickjobs_session=eyJpdiI6IitYZjhGRnFoWitDMlRNRFwvN2ZNbmxBPT0iLCJ2YWx1ZSI6IjVaNkdVS2k1bUVjdTRvVjVvZWFKVkltRnJyamJ5WXk1SGdTTXhuZ2xFTERYcHRKeGlLRlFVTVRPZFFsaWRNa2wiLCJtYWMiOiI1NWRmZDhkMjNiMzY3OWJhYTZhMjU2Yzc0YWRkYWY4NzhkMjY4YjViYTUwYWRhYTllOTVjOWM4YmJjYmViYTk1In0%3D; expires=Fri, 25-Apr-2025 18:04:00 GMT; path=/; httponly ◀pickjobs_session=eyJpdiI6IitYZjhGRnFoWitDMlRNRFwvN2ZNbmxBPT0iLCJ2YWx1ZSI6IjVaNkdVS2k1bUVjdTRvVjVvZWFKVkltRnJyamJ5WXk1SGdTTXhuZ2xFTERYcHRKeGlLRlFVTVRPZFFsaWRNa2w ▶"
  ]
]

session_attributes

  0 of 0   
array:8 [▶
  "currentLang" => App\Models\Language {#1442 ▶
    +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" => 5
      "slug" => "uk"
      "country_id" => 229
      "language_name" => "Українська"
      "currency" => "uah"
      "eur_conversion_rate" => "32.12"
      "conversion_date" => "2022-03-25 12:00:03"
      "order_num" => 5
      "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" => 5
      "slug" => "uk"
      "country_id" => 229
      "language_name" => "Українська"
      "currency" => "uah"
      "eur_conversion_rate" => "32.12"
      "conversion_date" => "2022-03-25 12:00:03"
      "order_num" => 5
      "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" => "uk"
  "autolang" => 1
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "_token" => "ES5ey84uS0Pa5Idr2spnvQOHmvoNJVZAjnl00lGZ"
  "defaultLang" => App\Models\Language {#1441 ▶
    +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/ua/robochi-miscya/silske-gospodarstvo-ta-agrobiznes"
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

Вакансії в категорії Сільське господарство та агробізнес

Fidelio papers d.o.o.

Агроном

Watsons Україна

Агрономія міжнар

Pravo vrijeme

Тест на агронома

Watsons Україна

Вікторина для Томісальви

Watsons Україна

Агроном

Watsons Україна

Агроном

Fidelio papers d.o.o.

Агроном

poljoprivredna firma

Сільськогосподарський працівник (м / ж)

Tvrtka D.o.o.

садівник

Elvonet

Продавець хлібобулочних виробів

bla bla bla

Робітник сільського господарства (м/ж)

Мобільний додаток PickJobs

Що нового

FAQ

Про нас

Правові норми

Заява про співфінансування

Наші партнери

Політика щодо cookie

Мобільний додаток PickJobs

1 x Application (87.65%)	220.18ms
1 x Booting (12.29%)	30.88ms