Croatia Bosnia and Herzegovina Serbia Crna Gora North Macedonia Ukraine Albania Kosovo Austria Deutschland Switzerland

Jobs from category Banking

Students only

Seasonal jobs

More than 10.000 jobs ads

Proba Oglasa V1

Zagreb, Croatia
Open until 12.12.2025

View Job

iOS programer

Sarajevo, Bosnia and Herzegovina
Open until 12.12.2025

View Job

Test22

Sarajevo, Bosnia and Herzegovina
Open until 12.12.2025

View Job

Test

Sarajevo, Bosnia and Herzegovina
Open until 12.12.2025

View Job

Test basic

Sarajevo, Bosnia and Herzegovina
Open until 12.12.2025

View Job

Test basic2

Sarajevo, Bosnia and Herzegovina
Open until 12.12.2025

View Job

Test

Sarajevo, Bosnia and Herzegovina
Open until 12.12.2025

View Job

the name of the new job

Varaždin, Croatia
Open until 12.12.2025

View Job

Social worker

Sisak, Croatia
Open until 12.12.2025

View Job

Beautician

Ivanec, Croatia
Open until 12.12.2025

View Job

seamstress

Vratišinec, Croatia
Open until 12.12.2025

View Job

Sales Officer

Zagreb, Croatia
Open until 12.12.2025

View Job

Basic test

Sarajevo, Bosnia and Herzegovina
Open until 12.12.2025

View Job

Referent u banci

Zagreb, Croatia
Open until 12.12.2025

View Job

Download PickJobs mobile app

Download free PickJobs mobile app on your Android or iOS device, via Google Play Store or App Store and gain access anywhere, anytime.

Looking for a job or are you looking for a new employees? Exploring possibilities? Create your profile, control its content and become competitive in achieving your goals.

Statement of co-financing

Final recipient of the financial instrument co-financed from the European Regional Development Fund under the Operational Program "Competitiveness and Cohesion"

Our partners

Cookie Policy

For the best user experience and full funcionality of all site features, PickJobs is using cookies and similar technologies. If you continue to use this site we will consider that you have accepted and agreed with our Cookie Policy. Read more about Cookie Policy

I accept

Messages Timeline Exceptions Views14 Route Queries80 Mails Gate Session Request

7.4.3166.18ms8.51MBGET gb/jobs/{path}

Booting (22.34ms)
Application (143.75ms)
1 x Application (86.5%)
143.75ms
1 x Booting (13.44%)
22.34ms

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 gb/jobs/{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 unique71.34ms

select * from `jobs` where `unique_id` = 'banking' limit 1390μs/app/Http/Controllers/FrontEnd/JobController.php:68pick

Metadata
Bindings	0. banking
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` = 'banking' limit 13.83ms/app/Http/Controllers/FrontEnd/JobController.php:78pick

Metadata
Bindings	0. banking
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 1240μ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` = 'banking'330μs/app/Http/Controllers/FrontEnd/JobController.php:128pick

Metadata
Bindings	0. banking
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 1220μ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(en_occupations_trans.occupation_name, hr_occupations_trans.occupation_name) as name from `occupations` left join `occupations_trans` as `en_occupations_trans` on `en_occupations_trans`.`occupation_id` = `occupations`.`id` and `en_occupations_trans`.`language_id` = 1 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.3ms/app/Models/Occupation.php:136pick

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

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

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

Metadata
Bindings	0. 1 1. 2025-05-03 16:37:29 2. 2025-05-03 16:37:29 3. 0000-00-00 00:00:00 4. %en% 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

8.86ms/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 1250μs/app/Services/MenuService.php:75pick

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

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

1.14ms/app/Models/Menu.php:72pick

Metadata
Bindings	0. 2 1. 1 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 (7, 8, 9, 10, 11) order by `menu_order` asc310μs/app/Models/Menu.php:72pick

Metadata

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

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

select * from `menus_items` where `menus_items`.`parent_id` in (18, 20, 21, 37, 77, 78, 79, 122) order by `menu_order` asc

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

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

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

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

Metadata
Bindings	0. 8
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 (77, 78, 79) 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` = 8 and `menus_items`.`parent_id` is not null order by `menu_order` asc

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

Metadata
Bindings	0. 8
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 (77, 78, 79) order by `menu_order` asc230μ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` = 77 and `menus_items`.`parent_id` is not null

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

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

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

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

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

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

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

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

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

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

Metadata
Bindings	0. 9
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 (20, 21) 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` = 9 and `menus_items`.`parent_id` is not null order by `menu_order` asc

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

Metadata
Bindings	0. 9
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 (20, 21) order by `menu_order` asc240μs/app/Models/MenuItem.php:107pick

Metadata

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

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

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

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

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

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

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

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

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

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

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

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

Metadata
Bindings	0. 11
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 (18, 37, 122) 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` = 11 and `menus_items`.`parent_id` is not null order by `menu_order` asc

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

Metadata
Bindings	0. 11
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 (18, 37, 122) order by `menu_order` asc240μs/app/Models/MenuItem.php:107pick

Metadata

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

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

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

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

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

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

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

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

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

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

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

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

2.24ms/app/Models/Menu.php:72pick

Metadata
Bindings	0. 2 1. 1 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 (7, 8, 9, 10, 11) order by `menu_order` asc310μ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 (18, 20, 21, 37, 77, 78, 79, 122) 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` = 7 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc

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

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

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

Metadata
Bindings	0. 8
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 (77, 78, 79) order by `menu_order` asc3.81ms/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` = 8 and `menus_items`.`parent_id` is not null order by `menu_order` asc

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

Metadata
Bindings	0. 8
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 (77, 78, 79) order by `menu_order` asc290μ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` = 77 and `menus_items`.`parent_id` is not null

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

Metadata

Bindings

0. 77

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

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

Metadata

Bindings

0. 78

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

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

Metadata

Bindings

0. 79

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` = 9 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. 9
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 (20, 21) order by `menu_order` asc240μ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` = 9 and `menus_items`.`parent_id` is not null order by `menu_order` asc

3.4ms/app/Models/MenuItem.php:107pick

Metadata
Bindings	0. 9
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 (20, 21) order by `menu_order` asc250μ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` = 21 and `menus_items`.`parent_id` is not null

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

Metadata

Bindings

0. 21

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

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

Metadata

Bindings

0. 20

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

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

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

3.35ms/app/Models/MenuItem.php:107pick

Metadata
Bindings	0. 11
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 (18, 37, 122) order by `menu_order` asc290μ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` = 37 and `menus_items`.`parent_id` is not null

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

Metadata

Bindings

0. 37

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

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

Metadata

Bindings

0. 18

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

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

Metadata

Bindings

0. 122

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

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

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

4.13ms/app/Models/Language.php:192pick

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

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

Metadata

Bindings

0. blog
1. 1
2. 1
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` = 1 and `categories_trans`.`language_id` = 1 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. 1 2. 1 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 1230μ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` = 1 and `parent_id` = '0' order by `menu_order` asc

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

Metadata
Bindings	0. 3 1. 1 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 (1, 3, 24, 25) 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 (2, 4, 5, 6, 22, 23, 26, 27, 29, 30, 31, 32, 33, 34, 35, 455) order by `menu_order` asc

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

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

Metadata
Bindings	0. 1
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 (2, 22, 26) order by `menu_order` asc230μ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` = 24 and `menus_items`.`parent_id` is not null order by `menu_order` asc

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

Metadata
Bindings	0. 24
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 (31, 32, 33, 34, 35) order by `menu_order` asc280μs/app/Services/MenuService.php:433pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

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

Metadata
Bindings	0. 25
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 (27, 29, 30, 455) 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` = 3 and `menus_items`.`parent_id` is not null order by `menu_order` asc

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

Metadata
Bindings	0. 3
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 (4, 5, 6, 23) order by `menu_order` asc250μs/app/Services/MenuService.php:433pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

20. /app/Services/MenuService.php:433
21. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418
22. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357
23. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239
24. /app/Services/MenuService.php:443
25. /app/Providers/ViewServiceProvider.php:239
28. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179
29. /vendor/laravel/framework/src/Illuminate/View/View.php:123
30. /vendor/laravel/framework/src/Illuminate/View/View.php:90
31. view::public.layouts.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` = 1 group by `slug` order by `settings_languages`.`order_num` asc

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

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

Metadata

Bindings

0. 1
1. 232

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

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

Metadata

Bindings

0. 1
1. 1

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

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

currentLang: App\Models\Language {#1406 +timestamps: false #fillable: array:3 [ 0 => "slug" 1 => "lan...
locale: en
autolang: 1
_flash: array:2 [ "old" => [] "new" => [] ]
_token: qzrKoVXICgDCNV8KD09zSYlLiX5vcjKfS0H4c02f
defaultLang: App\Models\Language {#1405 +timestamps: false #fillable: array:3 [ 0 => "slug" 1 => "lan...
_previous: array:1 [ "url" => "https://dev.pick.jobs/gb/jobs/banking" ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/gb/jobs/banking

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

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

request_server

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

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sat, 03 May 2025 14:37:29 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkZWVnVJUUdMYkVQVXhJRDZiNTYrWlE9PSIsInZhbHVlIjoiXC9WN3JrQXdod0JxK0hIWmt0aU1RYlJKQitpUnBcL1ZoSTVWa2VBZ01ncEtUQU5HMFBLRWdNRWdueitFdWJFTmVaIiwibWFjIjoiZTBiZGFhNzEzY2VjZDU1MzU1ZGI4NTY5YjRjNjU5Zjg4MTc5NjQzNWU4NmNhZTkxZmZhZmJjOTM1OWI1OGEzOCJ9; expires=Sun, 04-May-2025 10:37:29 GMT; Max-Age=72000; path=/ ◀XSRF-TOKEN=eyJpdiI6IkZWVnVJUUdMYkVQVXhJRDZiNTYrWlE9PSIsInZhbHVlIjoiXC9WN3JrQXdod0JxK0hIWmt0aU1RYlJKQitpUnBcL1ZoSTVWa2VBZ01ncEtUQU5HMFBLRWdNRWdueitFdWJFTmVaIiwib ▶"
    1 => "pickjobs_session=eyJpdiI6Ik1ONkNtakxrRzZmand0UXhMVGZSb2c9PSIsInZhbHVlIjoiYW5ZeEZ5SWRLRnYza2VpTXZLbW5LRVFmR1RhU3dSOEV3MWZIbkZ3ejV1UEhjajBLWVp5VWs1MDFMVzFMUHQxdCIsIm1hYyI6IjY4NTQ2ZjQ0NTc1MjEwNzE0MmJiZTIyMmQ4N2M5ZTVjZDY5YmM5YjY1ODMzNWQ3OTJkZDY4MzlmMTZlZTcxNDIifQ%3D%3D; expires=Sun, 04-May-2025 10:37:29 GMT; Max-Age=72000; path=/; httponly ◀pickjobs_session=eyJpdiI6Ik1ONkNtakxrRzZmand0UXhMVGZSb2c9PSIsInZhbHVlIjoiYW5ZeEZ5SWRLRnYza2VpTXZLbW5LRVFmR1RhU3dSOEV3MWZIbkZ3ejV1UEhjajBLWVp5VWs1MDFMVzFMUHQxdCI ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkZWVnVJUUdMYkVQVXhJRDZiNTYrWlE9PSIsInZhbHVlIjoiXC9WN3JrQXdod0JxK0hIWmt0aU1RYlJKQitpUnBcL1ZoSTVWa2VBZ01ncEtUQU5HMFBLRWdNRWdueitFdWJFTmVaIiwibWFjIjoiZTBiZGFhNzEzY2VjZDU1MzU1ZGI4NTY5YjRjNjU5Zjg4MTc5NjQzNWU4NmNhZTkxZmZhZmJjOTM1OWI1OGEzOCJ9; expires=Sun, 04-May-2025 10:37:29 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkZWVnVJUUdMYkVQVXhJRDZiNTYrWlE9PSIsInZhbHVlIjoiXC9WN3JrQXdod0JxK0hIWmt0aU1RYlJKQitpUnBcL1ZoSTVWa2VBZ01ncEtUQU5HMFBLRWdNRWdueitFdWJFTmVaIiwib ▶"
    1 => "pickjobs_session=eyJpdiI6Ik1ONkNtakxrRzZmand0UXhMVGZSb2c9PSIsInZhbHVlIjoiYW5ZeEZ5SWRLRnYza2VpTXZLbW5LRVFmR1RhU3dSOEV3MWZIbkZ3ejV1UEhjajBLWVp5VWs1MDFMVzFMUHQxdCIsIm1hYyI6IjY4NTQ2ZjQ0NTc1MjEwNzE0MmJiZTIyMmQ4N2M5ZTVjZDY5YmM5YjY1ODMzNWQ3OTJkZDY4MzlmMTZlZTcxNDIifQ%3D%3D; expires=Sun, 04-May-2025 10:37:29 GMT; path=/; httponly ◀pickjobs_session=eyJpdiI6Ik1ONkNtakxrRzZmand0UXhMVGZSb2c9PSIsInZhbHVlIjoiYW5ZeEZ5SWRLRnYza2VpTXZLbW5LRVFmR1RhU3dSOEV3MWZIbkZ3ejV1UEhjajBLWVp5VWs1MDFMVzFMUHQxdCI ▶"
  ]
]

session_attributes

  0 of 0   
array:8 [▶
  "currentLang" => App\Models\Language {#1406 ▶
    +timestamps: false
    #fillable: array:3 [▶
      0 => "slug"
      1 => "language_name"
      2 => "country_id"
    ]
    #table: "settings_languages"
    #connection: "mysql"
    #primaryKey: "id"
    #keyType: "int"
    +incrementing: true
    #with: []
    #withCount: []
    #perPage: 15
    +exists: true
    +wasRecentlyCreated: false
    #attributes: array:12 [▶
      "id" => 1
      "slug" => "en"
      "country_id" => 232
      "language_name" => "English"
      "currency" => "eur"
      "eur_conversion_rate" => "1.00"
      "conversion_date" => "2022-12-31 12:00:02"
      "order_num" => 0
      "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" => 1
      "slug" => "en"
      "country_id" => 232
      "language_name" => "English"
      "currency" => "eur"
      "eur_conversion_rate" => "1.00"
      "conversion_date" => "2022-12-31 12:00:02"
      "order_num" => 0
      "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" => "en"
  "autolang" => 1
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "_token" => "qzrKoVXICgDCNV8KD09zSYlLiX5vcjKfS0H4c02f"
  "defaultLang" => App\Models\Language {#1405 ▶
    +timestamps: false
    #fillable: array:3 [▶
      0 => "slug"
      1 => "language_name"
      2 => "country_id"
    ]
    #table: "settings_languages"
    #connection: "mysql"
    #primaryKey: "id"
    #keyType: "int"
    +incrementing: true
    #with: []
    #withCount: []
    #perPage: 15
    +exists: true
    +wasRecentlyCreated: false
    #attributes: array:12 [▶
      "id" => 2
      "slug" => "hr"
      "country_id" => 55
      "language_name" => "Hrvatski"
      "currency" => "eur"
      "eur_conversion_rate" => "1.00"
      "conversion_date" => "2022-12-31 12:00:02"
      "order_num" => 1
      "vat" => 0.25
      "invoice_note" => ""
      "job_translate" => 1
      "is_active" => 1
    ]
    #original: array:12 [▶
      "id" => 2
      "slug" => "hr"
      "country_id" => 55
      "language_name" => "Hrvatski"
      "currency" => "eur"
      "eur_conversion_rate" => "1.00"
      "conversion_date" => "2022-12-31 12:00:02"
      "order_num" => 1
      "vat" => 0.25
      "invoice_note" => ""
      "job_translate" => 1
      "is_active" => 1
    ]
    #changes: []
    #casts: []
    #dates: []
    #dateFormat: null
    #appends: []
    #dispatchesEvents: []
    #observables: []
    #relations: []
    #touches: []
    #hidden: []
    #visible: []
    #guarded: array:1 [▶
      0 => "*"
    ]
  }
  "_previous" => array:1 [▶
    "url" => "https://dev.pick.jobs/gb/jobs/banking"
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

Jobs from category Banking

Pravo vrijeme

Proba Oglasa V1

Luba Solutions

iOS programer

Elvonet

Test22

Elvonet

Test

Elvonet

Test basic

Elvonet

Test basic2

Elvonet

Test

Elvonet

the name of the new job

UTILITER

Social worker

Watsons Україна

Beautician

Elvonet

seamstress

FIRASTONE d.o.o.

Sales Officer

Elvonet

Basic test

Natalijapick

Referent u banci

Download PickJobs mobile app

What's New

FAQ

About

Legal

Statement of co-financing

Our partners

Cookie Policy

Download PickJobs mobile app

1 x Application (86.5%)	143.75ms
1 x Booting (13.44%)	22.34ms