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

Find an employee for the price of one coffee a day!

Discover Talents Faster and Easier

Introducing a brand new subscription model where finding your next employee doesn't cost more than a cup of coffee a day. With this innovative approach, you will build your team faster and discover talent in the easiest way possible.

Find a student or regular job

Your career at your fingertips

Whether you're a recent graduate searching for your dream job or a student seeking part-time work to support your studies, we've got you covered. Find a job today and make your way for a brighter future.

PickJobs - 100% better

The key to a successful career

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.

Your Email

Your Password

Remember Me

Forgot password?

Do you have an account?
Register to PickJobs

Students only

Seasonal jobs

More than 10.000 jobs ads

Featured Jobs

Cashier

Croatia
12.12.2025

Nicotine filter promoter

Croatia
12.12.2025

Programmer

Croatia
12.12.2025

sdfgsdgfsdfg

Croatia
12.12.2025

premium ad title

Croatia
12.12.2025

werwerewr

Croatia
12.12.2025

radno mjesto

Croatia
12.12.2025

Master of Pharmacy (m / f)

Croatia
12.12.2025

This is another highlight on the...

Croatia
12.12.2025

This is an HTML ad

Croatia
12.12.2025

Master of Pharmacy (m / f)

Croatia
12.12.2025

premium ad title

Croatia
12.12.2025

test mail

Croatia
12.12.2025

assistant

Croatia
12.12.2025

Nurse

Croatia
12.12.2025

treasurer

Croatia
12.12.2025

Seller

Croatia
12.12.2025

administrator

Croatia
12.12.2025

Asnsn

Croatia
12.12.2025

Agronomy Intern

Croatia
12.12.2025

test

Serbia
12.12.2025

Hairdresser

Croatia
12.12.2025

Administrative assistant

Croatia
12.12.2025

Lawyer

Croatia
12.12.2025

Cashier

Croatia
12.12.2025

Nicotine filter promoter

Croatia
12.12.2025

Programmer

Croatia
12.12.2025

sdfgsdgfsdfg

Croatia
12.12.2025

premium ad title

Croatia
12.12.2025

werwerewr

Croatia
12.12.2025

radno mjesto

Croatia
12.12.2025

Master of Pharmacy (m / f)

Croatia
12.12.2025

This is another highlight on the...

Croatia
12.12.2025

This is an HTML ad

Croatia
12.12.2025

Master of Pharmacy (m / f)

Croatia
12.12.2025

premium ad title

Croatia
12.12.2025

test mail

Croatia
12.12.2025

assistant

Croatia
12.12.2025

Nurse

Croatia
12.12.2025

treasurer

Croatia
12.12.2025

Seller

Croatia
12.12.2025

administrator

Croatia
12.12.2025

Asnsn

Croatia
12.12.2025

Agronomy Intern

Croatia
12.12.2025

test

Serbia
12.12.2025

Hairdresser

Croatia
12.12.2025

Administrative assistant

Croatia
12.12.2025

Lawyer

Croatia
12.12.2025

Cashier

Croatia
12.12.2025

Nicotine filter promoter

Croatia
12.12.2025

Programmer

Croatia
12.12.2025

sdfgsdgfsdfg

Croatia
12.12.2025

premium ad title

Croatia
12.12.2025

werwerewr

Croatia
12.12.2025

All industries

Student jobs

Assistant (m / f)

Croatia
12.12.2025

Zg

Croatia
12.12.2025

Vvg

Croatia
12.12.2025

confectioner m / f

Croatia
12.12.2025

Jdhdhd

Croatia
12.12.2025

wertewrt

Croatia
12.12.2025

Truck driver - b category

Croatia
12.12.2025

Try the ad

Croatia
12.12.2025

Truck driver in international tr...

Croatia
12.12.2025

Latest News

Tips for employers

How much is it necessary to have a good mentor and what are his strengths?

A mentor is a person who, through his knowledge and experience based on research, makes the secret to success. Why this...

21.07.2020

Tips for employees

6 things you need to apply if you want to be successful in life

No matter what your definition of success is, the path to achieving it is often challenging and unpredictable.

21.07.2020

Tips for employees

Check out why and how to reduce work dependence

Many of us are obsessively focused on work, and if we are talented for something and contribute to a greater good, it ca...

20.07.2020

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 Views16 Route Queries78 Mails Gate Session Request

7.4.3503.3ms8.85MBGET gb

Booting (68.16ms)
Application (435.03ms)
1 x Application (86.43%)
435.03ms
1 x Booting (13.54%)
68.16ms

16 templates were rendered

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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


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

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

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

78 statements were executed, 52 of which were duplicated, 26 unique121.67ms

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

2.97ms/app/Models/Post.php:664pick

Metadata

Bindings

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

Backtrace

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

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

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

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

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

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

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

Metadata

Bindings

0. 55
1.

Backtrace

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

select `banners`.`url`, `banners`.`image`, `banners`.`dimensions`, `banners`.`custom_code`, `banners`.`langs`, `banners`.`banner_position`, `banners`.`id` from `banners` where `banners`.`banner_status` = 1 and `banners`.`published_at` <= '2025-04-06 07:00:25' and (`banners`.`lasts_until` >= '2025-04-06 07:00:25' or `banners`.`lasts_until` = '0000-00-00 00:00:00') and (`banners`.`langs` like '%en%') and `banners`.`banner_position` LIKE 'landing%' order by RAND()

1.67ms/app/Repositories/BannerRepository.php:61pick

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

select * from `settings_languages` where `slug` = 'hr' limit 1910μ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/FrontEndController.php:110 24. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 25. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 26. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 27. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 28. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 29. /app/Http/Controllers/Controller.php:36 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 31. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 32. /app/Http/Middleware/Localization.php:64 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 34. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 35. middleware::bindings:41 36. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 37. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 38. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 40. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 41. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 44. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select `occupations`.`id`, `occupations`.`parent_id`, coalesce(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

3.42ms/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/FrontEndController.php:110 18. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 19. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:219 20. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:176 21. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 22. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 23. /app/Http/Controllers/Controller.php:36 24. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 25. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 26. /app/Http/Middleware/Localization.php:64 27. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 28. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 29. middleware::bindings:41 30. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 31. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 32. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 33. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 34. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 35. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49 36. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 37. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 38. /vendor/laravel/framework/src/Illuminate/Session/Middleware/StartSession.php:56 39. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 40. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 41. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/AddQueuedCookiesToResponse.php:37 42. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 44. /vendor/laravel/framework/src/Illuminate/Cookie/Middleware/EncryptCookies.php:66 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:104 48. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:682 49. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:657

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

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

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

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

3.17ms/app/Providers/ViewServiceProvider.php:360pick

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

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

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

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

3.09ms/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.main:28 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 30. /vendor/laravel/framework/src/Illuminate/View/View.php:142 31. /vendor/laravel/framework/src/Illuminate/View/View.php:125 32. /vendor/laravel/framework/src/Illuminate/View/View.php:90 33. view::public.landing:548 35. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 36. /vendor/laravel/framework/src/Illuminate/View/View.php:142 37. /vendor/laravel/framework/src/Illuminate/View/View.php:125 38. /vendor/laravel/framework/src/Illuminate/View/View.php:90 39. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 40. /vendor/symfony/http-foundation/Response.php:202 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 45. /app/Http/Controllers/Controller.php:36 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /app/Http/Middleware/Localization.php:64 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select * from `menus_items` where `menus_items`.`parent_id` in (7, 8, 9, 10, 11) order by `menu_order` asc1.5ms/app/Models/Menu.php:72pick

Metadata

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

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

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

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

Metadata

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

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

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

4.49ms/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.main:28 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

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

1.07ms/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.main:28 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` in (77, 78, 79) order by `menu_order` asc1.02ms/app/Services/MenuService.php:85pick

Metadata

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

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

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

750μ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.main:28 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 30. /vendor/laravel/framework/src/Illuminate/View/View.php:142 31. /vendor/laravel/framework/src/Illuminate/View/View.php:125 32. /vendor/laravel/framework/src/Illuminate/View/View.php:90 33. view::public.landing:548 35. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 36. /vendor/laravel/framework/src/Illuminate/View/View.php:142 37. /vendor/laravel/framework/src/Illuminate/View/View.php:125 38. /vendor/laravel/framework/src/Illuminate/View/View.php:90 39. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 40. /vendor/symfony/http-foundation/Response.php:202 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 45. /app/Http/Controllers/Controller.php:36 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /app/Http/Middleware/Localization.php:64 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

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

Metadata

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

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

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

220μ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.main:28 31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 32. /vendor/laravel/framework/src/Illuminate/View/View.php:142 33. /vendor/laravel/framework/src/Illuminate/View/View.php:125 34. /vendor/laravel/framework/src/Illuminate/View/View.php:90 35. view::public.landing:548 37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 38. /vendor/laravel/framework/src/Illuminate/View/View.php:142 39. /vendor/laravel/framework/src/Illuminate/View/View.php:125 40. /vendor/laravel/framework/src/Illuminate/View/View.php:90 41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 42. /vendor/symfony/http-foundation/Response.php:202 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 47. /app/Http/Controllers/Controller.php:36 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

Metadata

Bindings

0. 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.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

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

2.17ms/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.main:28 31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 32. /vendor/laravel/framework/src/Illuminate/View/View.php:142 33. /vendor/laravel/framework/src/Illuminate/View/View.php:125 34. /vendor/laravel/framework/src/Illuminate/View/View.php:90 35. view::public.landing:548 37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 38. /vendor/laravel/framework/src/Illuminate/View/View.php:142 39. /vendor/laravel/framework/src/Illuminate/View/View.php:125 40. /vendor/laravel/framework/src/Illuminate/View/View.php:90 41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 42. /vendor/symfony/http-foundation/Response.php:202 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 47. /app/Http/Controllers/Controller.php:36 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

Metadata

Bindings

0. 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.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

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

760μ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.main:28 31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 32. /vendor/laravel/framework/src/Illuminate/View/View.php:142 33. /vendor/laravel/framework/src/Illuminate/View/View.php:125 34. /vendor/laravel/framework/src/Illuminate/View/View.php:90 35. view::public.landing:548 37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 38. /vendor/laravel/framework/src/Illuminate/View/View.php:142 39. /vendor/laravel/framework/src/Illuminate/View/View.php:125 40. /vendor/laravel/framework/src/Illuminate/View/View.php:90 41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 42. /vendor/symfony/http-foundation/Response.php:202 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 47. /app/Http/Controllers/Controller.php:36 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

Metadata

Bindings

0. 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.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

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

2.95ms/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.main:28 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

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

Metadata

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

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

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

960μ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.main:28 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 30. /vendor/laravel/framework/src/Illuminate/View/View.php:142 31. /vendor/laravel/framework/src/Illuminate/View/View.php:125 32. /vendor/laravel/framework/src/Illuminate/View/View.php:90 33. view::public.landing:548 35. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 36. /vendor/laravel/framework/src/Illuminate/View/View.php:142 37. /vendor/laravel/framework/src/Illuminate/View/View.php:125 38. /vendor/laravel/framework/src/Illuminate/View/View.php:90 39. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 40. /vendor/symfony/http-foundation/Response.php:202 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 45. /app/Http/Controllers/Controller.php:36 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /app/Http/Middleware/Localization.php:64 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select * from `menus_items` where `menus_items`.`parent_id` in (20, 21) order by `menu_order` asc4.56ms/app/Models/MenuItem.php:107pick

Metadata

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

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

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

840μ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.main:28 31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 32. /vendor/laravel/framework/src/Illuminate/View/View.php:142 33. /vendor/laravel/framework/src/Illuminate/View/View.php:125 34. /vendor/laravel/framework/src/Illuminate/View/View.php:90 35. view::public.landing:548 37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 38. /vendor/laravel/framework/src/Illuminate/View/View.php:142 39. /vendor/laravel/framework/src/Illuminate/View/View.php:125 40. /vendor/laravel/framework/src/Illuminate/View/View.php:90 41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 42. /vendor/symfony/http-foundation/Response.php:202 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 47. /app/Http/Controllers/Controller.php:36 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

Metadata

Bindings

0. 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.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

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

870μ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.main:28 31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 32. /vendor/laravel/framework/src/Illuminate/View/View.php:142 33. /vendor/laravel/framework/src/Illuminate/View/View.php:125 34. /vendor/laravel/framework/src/Illuminate/View/View.php:90 35. view::public.landing:548 37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 38. /vendor/laravel/framework/src/Illuminate/View/View.php:142 39. /vendor/laravel/framework/src/Illuminate/View/View.php:125 40. /vendor/laravel/framework/src/Illuminate/View/View.php:90 41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 42. /vendor/symfony/http-foundation/Response.php:202 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 47. /app/Http/Controllers/Controller.php:36 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

Metadata

Bindings

0. 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.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

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

1.36ms/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.main:28 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

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

850μ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.main:28 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` in (18, 37, 122) order by `menu_order` asc810μs/app/Services/MenuService.php:85pick

Metadata

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

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

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

980μ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.main:28 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 30. /vendor/laravel/framework/src/Illuminate/View/View.php:142 31. /vendor/laravel/framework/src/Illuminate/View/View.php:125 32. /vendor/laravel/framework/src/Illuminate/View/View.php:90 33. view::public.landing:548 35. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 36. /vendor/laravel/framework/src/Illuminate/View/View.php:142 37. /vendor/laravel/framework/src/Illuminate/View/View.php:125 38. /vendor/laravel/framework/src/Illuminate/View/View.php:90 39. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 40. /vendor/symfony/http-foundation/Response.php:202 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 45. /app/Http/Controllers/Controller.php:36 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /app/Http/Middleware/Localization.php:64 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select * from `menus_items` where `menus_items`.`parent_id` in (18, 37, 122) order by `menu_order` asc1.02ms/app/Models/MenuItem.php:107pick

Metadata

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

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

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

260μ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.main:28 31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 32. /vendor/laravel/framework/src/Illuminate/View/View.php:142 33. /vendor/laravel/framework/src/Illuminate/View/View.php:125 34. /vendor/laravel/framework/src/Illuminate/View/View.php:90 35. view::public.landing:548 37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 38. /vendor/laravel/framework/src/Illuminate/View/View.php:142 39. /vendor/laravel/framework/src/Illuminate/View/View.php:125 40. /vendor/laravel/framework/src/Illuminate/View/View.php:90 41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 42. /vendor/symfony/http-foundation/Response.php:202 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 47. /app/Http/Controllers/Controller.php:36 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

Metadata

Bindings

0. 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.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

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

380μ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.main:28 31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 32. /vendor/laravel/framework/src/Illuminate/View/View.php:142 33. /vendor/laravel/framework/src/Illuminate/View/View.php:125 34. /vendor/laravel/framework/src/Illuminate/View/View.php:90 35. view::public.landing:548 37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 38. /vendor/laravel/framework/src/Illuminate/View/View.php:142 39. /vendor/laravel/framework/src/Illuminate/View/View.php:125 40. /vendor/laravel/framework/src/Illuminate/View/View.php:90 41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 42. /vendor/symfony/http-foundation/Response.php:202 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 47. /app/Http/Controllers/Controller.php:36 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

Metadata

Bindings

0. 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.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

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

750μ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.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

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

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

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

1.86ms/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.main:28 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 30. /vendor/laravel/framework/src/Illuminate/View/View.php:142 31. /vendor/laravel/framework/src/Illuminate/View/View.php:125 32. /vendor/laravel/framework/src/Illuminate/View/View.php:90 33. view::public.landing:548 35. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 36. /vendor/laravel/framework/src/Illuminate/View/View.php:142 37. /vendor/laravel/framework/src/Illuminate/View/View.php:125 38. /vendor/laravel/framework/src/Illuminate/View/View.php:90 39. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 40. /vendor/symfony/http-foundation/Response.php:202 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 45. /app/Http/Controllers/Controller.php:36 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /app/Http/Middleware/Localization.php:64 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select * from `menus_items` where `menus_items`.`parent_id` in (7, 8, 9, 10, 11) order by `menu_order` asc1.09ms/app/Models/Menu.php:72pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

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

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

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

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

960μ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.main:28 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

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

920μ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.main:28 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` in (77, 78, 79) order by `menu_order` asc910μs/app/Services/MenuService.php:131pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

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

1.67ms/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.main:28 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 30. /vendor/laravel/framework/src/Illuminate/View/View.php:142 31. /vendor/laravel/framework/src/Illuminate/View/View.php:125 32. /vendor/laravel/framework/src/Illuminate/View/View.php:90 33. view::public.landing:548 35. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 36. /vendor/laravel/framework/src/Illuminate/View/View.php:142 37. /vendor/laravel/framework/src/Illuminate/View/View.php:125 38. /vendor/laravel/framework/src/Illuminate/View/View.php:90 39. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 40. /vendor/symfony/http-foundation/Response.php:202 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 45. /app/Http/Controllers/Controller.php:36 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /app/Http/Middleware/Localization.php:64 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select * from `menus_items` where `menus_items`.`parent_id` in (77, 78, 79) order by `menu_order` asc3.61ms/app/Models/MenuItem.php:107pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

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

920μ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.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

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

920μ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.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

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

830μ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.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

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

990μ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.main:28 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` in (20, 21) order by `menu_order` asc870μs/app/Services/MenuService.php:131pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

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

2.33ms/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.main:28 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 30. /vendor/laravel/framework/src/Illuminate/View/View.php:142 31. /vendor/laravel/framework/src/Illuminate/View/View.php:125 32. /vendor/laravel/framework/src/Illuminate/View/View.php:90 33. view::public.landing:548 35. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 36. /vendor/laravel/framework/src/Illuminate/View/View.php:142 37. /vendor/laravel/framework/src/Illuminate/View/View.php:125 38. /vendor/laravel/framework/src/Illuminate/View/View.php:90 39. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 40. /vendor/symfony/http-foundation/Response.php:202 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 45. /app/Http/Controllers/Controller.php:36 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /app/Http/Middleware/Localization.php:64 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

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

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

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

910μ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.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

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

950μ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.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

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

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

Metadata
Bindings	0. 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.main:28 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

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

990μ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.main:28 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` in (18, 37, 122) order by `menu_order` asc850μs/app/Services/MenuService.php:131pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

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

850μ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:146 17. /vendor/laravel/framework/src/Illuminate/Cache/Repository.php:418 18. /vendor/laravel/framework/src/Illuminate/Cache/CacheManager.php:357 19. /vendor/laravel/framework/src/Illuminate/Support/Facades/Facade.php:239 20. /app/Services/MenuService.php:152 21. /app/Providers/ViewServiceProvider.php:105 24. /vendor/laravel/framework/src/Illuminate/View/Concerns/ManagesEvents.php:179 25. /vendor/laravel/framework/src/Illuminate/View/View.php:123 26. /vendor/laravel/framework/src/Illuminate/View/View.php:90 27. view::public.layouts.main:28 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 30. /vendor/laravel/framework/src/Illuminate/View/View.php:142 31. /vendor/laravel/framework/src/Illuminate/View/View.php:125 32. /vendor/laravel/framework/src/Illuminate/View/View.php:90 33. view::public.landing:548 35. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 36. /vendor/laravel/framework/src/Illuminate/View/View.php:142 37. /vendor/laravel/framework/src/Illuminate/View/View.php:125 38. /vendor/laravel/framework/src/Illuminate/View/View.php:90 39. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 40. /vendor/symfony/http-foundation/Response.php:202 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 45. /app/Http/Controllers/Controller.php:36 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /app/Http/Middleware/Localization.php:64 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select * from `menus_items` where `menus_items`.`parent_id` in (18, 37, 122) order by `menu_order` asc850μs/app/Models/MenuItem.php:107pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

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

960μ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.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

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

1.28ms/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.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

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

260μ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.main:28
31. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
32. /vendor/laravel/framework/src/Illuminate/View/View.php:142
33. /vendor/laravel/framework/src/Illuminate/View/View.php:125
34. /vendor/laravel/framework/src/Illuminate/View/View.php:90
35. view::public.landing:548
37. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
38. /vendor/laravel/framework/src/Illuminate/View/View.php:142
39. /vendor/laravel/framework/src/Illuminate/View/View.php:125
40. /vendor/laravel/framework/src/Illuminate/View/View.php:90
41. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
42. /vendor/symfony/http-foundation/Response.php:202
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
44. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
45. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
47. /app/Http/Controllers/Controller.php:36
48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

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

2.6ms/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.main:28 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125 24. /vendor/laravel/framework/src/Illuminate/View/View.php:90 25. view::public.landing:548 27. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 28. /vendor/laravel/framework/src/Illuminate/View/View.php:142 29. /vendor/laravel/framework/src/Illuminate/View/View.php:125 30. /vendor/laravel/framework/src/Illuminate/View/View.php:90 31. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 32. /vendor/symfony/http-foundation/Response.php:202 33. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 34. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 36. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 37. /app/Http/Controllers/Controller.php:36 38. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 39. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 40. /app/Http/Middleware/Localization.php:64 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 43. middleware::bindings:41 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 46. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 49. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49

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

1.71ms/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.main:28 21. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 22. /vendor/laravel/framework/src/Illuminate/View/View.php:142 23. /vendor/laravel/framework/src/Illuminate/View/View.php:125 24. /vendor/laravel/framework/src/Illuminate/View/View.php:90 25. view::public.landing:548 27. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 28. /vendor/laravel/framework/src/Illuminate/View/View.php:142 29. /vendor/laravel/framework/src/Illuminate/View/View.php:125 30. /vendor/laravel/framework/src/Illuminate/View/View.php:90 31. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 32. /vendor/symfony/http-foundation/Response.php:202 33. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 34. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 35. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 36. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 37. /app/Http/Controllers/Controller.php:36 38. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 39. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 40. /app/Http/Middleware/Localization.php:64 41. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 43. middleware::bindings:41 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 46. /vendor/laravel/framework/src/Illuminate/Foundation/Http/Middleware/VerifyCsrfToken.php:75 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 49. /vendor/laravel/framework/src/Illuminate/View/Middleware/ShareErrorsFromSession.php:49

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

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

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

1.34ms/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.main:34 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 30. /vendor/laravel/framework/src/Illuminate/View/View.php:142 31. /vendor/laravel/framework/src/Illuminate/View/View.php:125 32. /vendor/laravel/framework/src/Illuminate/View/View.php:90 33. view::public.landing:548 35. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 36. /vendor/laravel/framework/src/Illuminate/View/View.php:142 37. /vendor/laravel/framework/src/Illuminate/View/View.php:125 38. /vendor/laravel/framework/src/Illuminate/View/View.php:90 39. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 40. /vendor/symfony/http-foundation/Response.php:202 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 45. /app/Http/Controllers/Controller.php:36 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /app/Http/Middleware/Localization.php:64 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select * from `menus_items` where `menus_items`.`parent_id` in (1, 3, 24, 25) order by `menu_order` asc1.12ms/app/Models/Menu.php:72pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

select * from `menus_items` where `menus_items`.`parent_id` in (2, 4, 5, 6, 22, 23, 26, 27, 29, 30, 31, 32, 33, 34, 35, 455) order by `menu_order` asc

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

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

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

1.02ms/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.main:34 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` in (2, 22, 26) order by `menu_order` asc970μs/app/Services/MenuService.php:433pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

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

1.18ms/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.main:34 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` in (31, 32, 33, 34, 35) order by `menu_order` asc470μs/app/Services/MenuService.php:433pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

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

1.45ms/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.main:34 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` in (27, 29, 30, 455) order by `menu_order` asc460μs/app/Services/MenuService.php:433pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

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

1.8ms/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.main:34 28. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 29. /vendor/laravel/framework/src/Illuminate/View/View.php:142 30. /vendor/laravel/framework/src/Illuminate/View/View.php:125 31. /vendor/laravel/framework/src/Illuminate/View/View.php:90 32. view::public.landing:548 34. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 35. /vendor/laravel/framework/src/Illuminate/View/View.php:142 36. /vendor/laravel/framework/src/Illuminate/View/View.php:125 37. /vendor/laravel/framework/src/Illuminate/View/View.php:90 38. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 39. /vendor/symfony/http-foundation/Response.php:202 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 43. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 44. /app/Http/Controllers/Controller.php:36 45. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 46. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 47. /app/Http/Middleware/Localization.php:64 48. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 49. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53

select * from `menus_items` where `menus_items`.`parent_id` in (4, 5, 6, 23) order by `menu_order` asc310μs/app/Services/MenuService.php:433pick

Metadata

Hints

Use SELECT * only if you need all columns from table

Backtrace

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

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

1.89ms/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.main:34 27. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 28. /vendor/laravel/framework/src/Illuminate/View/View.php:142 29. /vendor/laravel/framework/src/Illuminate/View/View.php:125 30. /vendor/laravel/framework/src/Illuminate/View/View.php:90 31. view::public.landing:548 33. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 34. /vendor/laravel/framework/src/Illuminate/View/View.php:142 35. /vendor/laravel/framework/src/Illuminate/View/View.php:125 36. /vendor/laravel/framework/src/Illuminate/View/View.php:90 37. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 38. /vendor/symfony/http-foundation/Response.php:202 39. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 43. /app/Http/Controllers/Controller.php:36 44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 46. /app/Http/Middleware/Localization.php:64 47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163 48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 49. middleware::bindings:41

select count(*) as aggregate from `settings_countries_trans` where `language_id` = 1 and `country_id` = 232520μ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.main:34
29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
30. /vendor/laravel/framework/src/Illuminate/View/View.php:142
31. /vendor/laravel/framework/src/Illuminate/View/View.php:125
32. /vendor/laravel/framework/src/Illuminate/View/View.php:90
33. view::public.landing:548
35. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
36. /vendor/laravel/framework/src/Illuminate/View/View.php:142
37. /vendor/laravel/framework/src/Illuminate/View/View.php:125
38. /vendor/laravel/framework/src/Illuminate/View/View.php:90
39. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
40. /vendor/symfony/http-foundation/Response.php:202
41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
45. /app/Http/Controllers/Controller.php:36
46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
48. /app/Http/Middleware/Localization.php:64
49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

select settings_countries.*, settings_countries_trans.*, settings_countries_trans.country_name as CountryName from `settings_countries` left join `settings_countries_trans` on `settings_countries_trans`.`country_id` = `settings_countries`.`id` where `settings_countries`.`is_active` = 1 and `settings_countries_trans`.`language_id` = 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

6.06ms/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.main:34
27. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
28. /vendor/laravel/framework/src/Illuminate/View/View.php:142
29. /vendor/laravel/framework/src/Illuminate/View/View.php:125
30. /vendor/laravel/framework/src/Illuminate/View/View.php:90
31. view::public.landing:548
33. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59
34. /vendor/laravel/framework/src/Illuminate/View/View.php:142
35. /vendor/laravel/framework/src/Illuminate/View/View.php:125
36. /vendor/laravel/framework/src/Illuminate/View/View.php:90
37. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42
38. /vendor/symfony/http-foundation/Response.php:202
39. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748
40. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720
41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680
42. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30
43. /app/Http/Controllers/Controller.php:36
44. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145
45. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
46. /app/Http/Middleware/Localization.php:64
47. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163
48. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53
49. middleware::bindings:41

select `occupations`.*, coalesce(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

10.05ms/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.main:34 29. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 30. /vendor/laravel/framework/src/Illuminate/View/View.php:142 31. /vendor/laravel/framework/src/Illuminate/View/View.php:125 32. /vendor/laravel/framework/src/Illuminate/View/View.php:90 33. view::public.landing:548 35. /vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:59 36. /vendor/laravel/framework/src/Illuminate/View/View.php:142 37. /vendor/laravel/framework/src/Illuminate/View/View.php:125 38. /vendor/laravel/framework/src/Illuminate/View/View.php:90 39. /vendor/laravel/framework/src/Illuminate/Http/Response.php:42 40. /vendor/symfony/http-foundation/Response.php:202 41. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:748 42. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:720 43. /vendor/laravel/framework/src/Illuminate/Routing/Router.php:680 44. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:30 45. /app/Http/Controllers/Controller.php:36 46. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:145 47. /vendor/laravel/framework/src/Illuminate/Routing/Pipeline.php:53 48. /app/Http/Middleware/Localization.php:64 49. /vendor/laravel/framework/src/Illuminate/Pipeline/Pipeline.php:163

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

path_info

/gb

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

[]

request_request

[]

request_headers

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

request_server

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

request_cookies

[]

response_headers

  0 of 0   
array:5 [▶
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Sun, 06 Apr 2025 05:00:25 GMT"
  ]
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkRcL0M0WDBkd3J0dURWbHJwZmVjeCtRPT0iLCJ2YWx1ZSI6IldGZGd2MjVVNFNhMnJiUE8rWHlxZ2JZVExLaTBsU3FjVWtMdUxPUGJlVkdVc0k5S2NTaXQzV2F5ZTMyWFdlcTgiLCJtYWMiOiI0YWE3Mzc5Yjc5ZmI1NDY1ODZjNGJiNGE1NjA2ZTY4ZjgyM2ZjZmY2NmQzZDQ2NGE5OGI1ODM1MTRlYzdjYWRmIn0%3D; expires=Mon, 07-Apr-2025 01:00:25 GMT; Max-Age=72000; path=/ ◀XSRF-TOKEN=eyJpdiI6IkRcL0M0WDBkd3J0dURWbHJwZmVjeCtRPT0iLCJ2YWx1ZSI6IldGZGd2MjVVNFNhMnJiUE8rWHlxZ2JZVExLaTBsU3FjVWtMdUxPUGJlVkdVc0k5S2NTaXQzV2F5ZTMyWFdlcTgiLCJtY ▶"
    1 => "pickjobs_session=eyJpdiI6Ik5uUVFRSFhSbG8wMWtZTmY0XC9naDd3PT0iLCJ2YWx1ZSI6IklGb1JPZklvdWM2SkY3S2dacEY1Rm5QN1lETEtSSG1NRU5rdmVyS0F6dDNKRXZYM0lHdlJWUGhoXC85eGJaVmJHIiwibWFjIjoiNWZmOWZlMDlkY2NlYmI0Nzk4ODliNmUxZmUwOTM4NzUxMTRiYzY1ZjdkNzJkOWY4YTgyNWQ3NWE4OTE5YmIwZCJ9; expires=Mon, 07-Apr-2025 01:00:25 GMT; Max-Age=72000; path=/; httponly ◀pickjobs_session=eyJpdiI6Ik5uUVFRSFhSbG8wMWtZTmY0XC9naDd3PT0iLCJ2YWx1ZSI6IklGb1JPZklvdWM2SkY3S2dacEY1Rm5QN1lETEtSSG1NRU5rdmVyS0F6dDNKRXZYM0lHdlJWUGhoXC85eGJaVmJ ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IkRcL0M0WDBkd3J0dURWbHJwZmVjeCtRPT0iLCJ2YWx1ZSI6IldGZGd2MjVVNFNhMnJiUE8rWHlxZ2JZVExLaTBsU3FjVWtMdUxPUGJlVkdVc0k5S2NTaXQzV2F5ZTMyWFdlcTgiLCJtYWMiOiI0YWE3Mzc5Yjc5ZmI1NDY1ODZjNGJiNGE1NjA2ZTY4ZjgyM2ZjZmY2NmQzZDQ2NGE5OGI1ODM1MTRlYzdjYWRmIn0%3D; expires=Mon, 07-Apr-2025 01:00:25 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkRcL0M0WDBkd3J0dURWbHJwZmVjeCtRPT0iLCJ2YWx1ZSI6IldGZGd2MjVVNFNhMnJiUE8rWHlxZ2JZVExLaTBsU3FjVWtMdUxPUGJlVkdVc0k5S2NTaXQzV2F5ZTMyWFdlcTgiLCJtY ▶"
    1 => "pickjobs_session=eyJpdiI6Ik5uUVFRSFhSbG8wMWtZTmY0XC9naDd3PT0iLCJ2YWx1ZSI6IklGb1JPZklvdWM2SkY3S2dacEY1Rm5QN1lETEtSSG1NRU5rdmVyS0F6dDNKRXZYM0lHdlJWUGhoXC85eGJaVmJHIiwibWFjIjoiNWZmOWZlMDlkY2NlYmI0Nzk4ODliNmUxZmUwOTM4NzUxMTRiYzY1ZjdkNzJkOWY4YTgyNWQ3NWE4OTE5YmIwZCJ9; expires=Mon, 07-Apr-2025 01:00:25 GMT; path=/; httponly ◀pickjobs_session=eyJpdiI6Ik5uUVFRSFhSbG8wMWtZTmY0XC9naDd3PT0iLCJ2YWx1ZSI6IklGb1JPZklvdWM2SkY3S2dacEY1Rm5QN1lETEtSSG1NRU5rdmVyS0F6dDNKRXZYM0lHdlJWUGhoXC85eGJaVmJ ▶"
  ]
]

session_attributes

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

1 x Application (86.43%)	435.03ms
1 x Booting (13.54%)	68.16ms

Find an employee for the price of one coffee a day!

Featured Jobs

radno mjesto

Master of Pharmacy (m / f)

This is another highlight on the...

This is an HTML ad

Master of Pharmacy (m / f)

premium ad title

Student jobs

Assistant (m / f)

Zg

Vvg

confectioner m / f

Jdhdhd

wertewrt

Truck driver - b category

Try the ad

Truck driver in international tr...

Most popular jobs

Doctor

Commercialist

sales representative

Waiter

tedst 232

fafafaf

Test

werw r er werwer

zz