Хорватія
Боснія і Герцеговина
Сербія
Чорногорія
Північна Македонія
Албанія
Косово
Австрія
Німеччина
Швейцарія
Об'єднане Королівство
Мобільний додаток PickJobs
Завантажте безкоштовний мобільний додаток PickJobs на свій Android або iOS, через Google Play Store або App Store та отримайте доступ до можливостей будь-де та в будь-який час.
Завантажте безкоштовний мобільний додаток PickJobs на свій Android або iOS, через Google Play Store або App Store та отримайте доступ до можливостей будь-де та в будь-який час.
Кінцевим одержувачем фінансового інструменту, співфінансованого з Європейського фонду відповідального за регіональний розвиток в рамках Оперативної програми є «Конкурентоспроможність та згуртованість»
Для найкращого користувацького досвіду та повної функціональності всіх опцій сайту, PickJobs використовує файли cookie та подібні технології. Якщо ви продовжуєте використовувати цей сайт, ми вважатимемо, що ви прийняли та погодилися з нашою Політикою щодо cookie. Докладніше про Політику щодо cookie.
Завантажте безкоштовний мобільний додаток PickJobs на свій Android або iOS, через Google Play Store або App Store та отримайте доступ до можливостей будь-де та в будь-який час.
| 1 x Application (85.75%) | 355.06ms |
| 1 x Booting (14.22%) | 58.88ms |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
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` = 5 and `categories_trans`.`language_id` = 5 and `categories`.`type` = 'blog' and `is_featured` = 1 and `is_published` = 11.89ms/app/Models/Post.php:654pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
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 `posts`.`language_id` = 5 and `categories_trans`.`language_id` = 5 and `categories`.`type` = 'blog' and `is_featured` = 1 and `is_published` = 1 order by `posts`.`published_at` desc limit 3 offset 02.95ms/app/Models/Post.php:654pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
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-14 00:57:09' and (`banners`.`lasts_until` >= '2025-04-14 00:57:09' or `banners`.`lasts_until` = '0000-00-00 00:00:00') and (`banners`.`langs` like '%uk%') and `banners`.`banner_position` LIKE 'landing%' order by RAND()2.45ms/app/Repositories/BannerRepository.php:61pick| Metadata | |
|---|---|
| Bindings |
|
| Hints | |
| Backtrace |
|
select * from `settings_languages` where `slug` = 'hr' limit 1290μs/app/Models/Language.php:55pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `occupations`.`id`, `occupations`.`parent_id`, coalesce(uk_occupations_trans.occupation_name, hr_occupations_trans.occupation_name) as name from `occupations` left join `occupations_trans` as `uk_occupations_trans` on `uk_occupations_trans`.`occupation_id` = `occupations`.`id` and `uk_occupations_trans`.`language_id` = 5 left join `occupations_trans` as `hr_occupations_trans` on `hr_occupations_trans`.`occupation_id` = `occupations`.`id` and `hr_occupations_trans`.`language_id` = 2 order by `name` asc1.54ms/app/Models/Occupation.php:136pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `occupations_trans` where `language_id` = 5 order by `occupation_name` asc6.03ms/app/Http/Controllers/FrontEnd/FrontEndController.php:743pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `region_place_id`, `region` from `jobs` where `country_id` = 55 and `region` <> '' group by `region_place_id` order by `region` asc3.49ms/app/Http/Controllers/FrontEnd/FrontEndController.php:744pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `occupations_trans` where `language_id` = 5 order by `occupation_name` asc3.03ms/app/Providers/ViewServiceProvider.php:304pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus` where `menu_type` = '0' limit 15.95ms/app/Services/MenuService.php:75pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`menu_id` = 2 and `menus_items`.`menu_id` is not null and `language_id` = 5 and `parent_id` = '0' order by `menu_order` asc550μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (243, 244, 248, 251, 252) order by `menu_order` asc2.43ms/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (245, 246, 247, 249, 250, 254, 255, 256) order by `menu_order` asc270μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 243 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc290μs/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 244 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc310μs/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (245, 246, 247) order by `menu_order` asc1.53ms/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 244 and `menus_items`.`parent_id` is not null order by `menu_order` asc3.64ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (245, 246, 247) order by `menu_order` asc250μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 245 and `menus_items`.`parent_id` is not null3.01ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 246 and `menus_items`.`parent_id` is not null240μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 247 and `menus_items`.`parent_id` is not null230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 248 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc310μs/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (249, 250) order by `menu_order` asc240μs/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 248 and `menus_items`.`parent_id` is not null order by `menu_order` asc280μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (249, 250) order by `menu_order` asc5.8ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 249 and `menus_items`.`parent_id` is not null240μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 250 and `menus_items`.`parent_id` is not null240μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 251 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc1.31ms/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 252 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc320μs/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (254, 255, 256) order by `menu_order` asc800μs/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 252 and `menus_items`.`parent_id` is not null order by `menu_order` asc1.89ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (254, 255, 256) order by `menu_order` asc250μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 254 and `menus_items`.`parent_id` is not null250μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 255 and `menus_items`.`parent_id` is not null14.57ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 256 and `menus_items`.`parent_id` is not null310μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus` where `menu_type` = '0' limit 1290μs/app/Services/MenuService.php:121pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`menu_id` = 2 and `menus_items`.`menu_id` is not null and `language_id` = 5 and `parent_id` = '0' order by `menu_order` asc540μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (243, 244, 248, 251, 252) order by `menu_order` asc360μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (245, 246, 247, 249, 250, 254, 255, 256) order by `menu_order` asc3.32ms/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 243 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc3.41ms/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 244 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc320μs/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (245, 246, 247) order by `menu_order` asc270μs/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 244 and `menus_items`.`parent_id` is not null order by `menu_order` asc300μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (245, 246, 247) order by `menu_order` asc260μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 245 and `menus_items`.`parent_id` is not null260μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 246 and `menus_items`.`parent_id` is not null3.96ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 247 and `menus_items`.`parent_id` is not null4.35ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 248 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc370μs/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (249, 250) order by `menu_order` asc280μs/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 248 and `menus_items`.`parent_id` is not null order by `menu_order` asc320μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (249, 250) order by `menu_order` asc280μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 249 and `menus_items`.`parent_id` is not null260μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 250 and `menus_items`.`parent_id` is not null1.54ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 251 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc310μs/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 252 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc1.37ms/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (254, 255, 256) order by `menu_order` asc1.1ms/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 252 and `menus_items`.`parent_id` is not null order by `menu_order` asc10.61ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (254, 255, 256) order by `menu_order` asc1.05ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 254 and `menus_items`.`parent_id` is not null2.08ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 255 and `menus_items`.`parent_id` is not null300μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 256 and `menus_items`.`parent_id` is not null260μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `settings_languages` left join `settings_countries` on `settings_countries`.`id` = `settings_languages`.`country_id` left join `settings_countries_trans` on `settings_countries`.`id` = `settings_countries_trans`.`country_id` where `settings_languages`.`is_active` = 1 and `settings_countries_trans`.`language_id` = 5 order by `settings_countries`.`priority` asc1.26ms/app/Models/Language.php:179pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `settings_languages` left join `settings_countries` on `settings_countries`.`id` = `settings_languages`.`country_id` left join `settings_countries_trans` on `settings_countries`.`id` = `settings_countries_trans`.`country_id` where `settings_languages`.`is_active` = 1 and `settings_countries_trans`.`language_id` = 5 and `settings_countries`.`id` = 229 order by `settings_languages`.`order_num` asc6.9ms/app/Models/Language.php:192pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus` where `menu_type` = '1' limit 112.81ms/app/Services/MenuService.php:421pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`menu_id` = 3 and `menus_items`.`menu_id` is not null and `language_id` = 5 and `parent_id` = '0' order by `menu_order` asc790μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (222, 226, 232, 238) order by `menu_order` asc500μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (223, 224, 225, 227, 228, 229, 230, 231, 233, 235, 237, 239, 240, 241, 242, 457) order by `menu_order` asc470μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 222 and `menus_items`.`parent_id` is not null order by `menu_order` asc380μs/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (223, 224, 225) order by `menu_order` asc340μs/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 226 and `menus_items`.`parent_id` is not null order by `menu_order` asc2.31ms/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (227, 228, 229, 230, 231) order by `menu_order` asc480μs/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 232 and `menus_items`.`parent_id` is not null order by `menu_order` asc390μs/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (233, 235, 237, 457) order by `menu_order` asc290μs/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 238 and `menus_items`.`parent_id` is not null order by `menu_order` asc350μs/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (239, 240, 241, 242) order by `menu_order` asc280μs/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `settings_languages` left join `settings_countries` on `settings_countries`.`id` = `settings_languages`.`country_id` left join `settings_countries_trans` on `settings_countries`.`id` = `settings_countries_trans`.`country_id` where `settings_languages`.`is_active` = 1 and `settings_countries_trans`.`language_id` = 5 group by `slug` order by `settings_languages`.`order_num` asc2.55ms/app/Models/Language.php:166pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `settings_countries_trans` where `language_id` = 5 and `country_id` = 2292.15ms/app/Models/Country.php:53pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select settings_countries.*, settings_countries_trans.*, settings_countries_trans.country_name as CountryName from `settings_countries` left join `settings_countries_trans` on `settings_countries_trans`.`country_id` = `settings_countries`.`id` where `settings_countries`.`is_active` = 1 and `settings_countries_trans`.`language_id` = 5 group by `settings_countries_trans`.`country_name`, `settings_countries_trans`.`country_id` order by `settings_countries`.`priority` asc, `settings_countries_trans`.`country_name` asc39.4ms/app/Models/Country.php:69pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `occupations`.*, coalesce(uk_occupations_trans.occupation_name, hr_occupations_trans.occupation_name) as name, coalesce(uk_occupations_trans.description, hr_occupations_trans.description) as description from `occupations` left join `occupations_trans` as `uk_occupations_trans` on `uk_occupations_trans`.`occupation_id` = `occupations`.`id` and `uk_occupations_trans`.`language_id` = 5 left join `occupations_trans` as `hr_occupations_trans` on `hr_occupations_trans`.`occupation_id` = `occupations`.`id` and `hr_occupations_trans`.`language_id` = 2 order by `name` asc8.19ms/app/Models/Occupation.php:48pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
200
[]
[]
0 of 0array: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" ] ]
0 of 0array: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" => "785d87db575652fda847e48a6216778aa1248179cfbc7446e06cf0bd3c380201" "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" => "3.138.86.166" "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" => "37695" "REDIRECT_URL" => "/ua/robochi-miscya/katehoriyi" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/ua/robochi-miscya/katehoriyi" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744585029.06 "REQUEST_TIME" => 1744585029 ]
[]
0 of 0array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Sun, 13 Apr 2025 22:57:09 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImZHbHZub21BNVZnRFRjaVwvREV3MENnPT0iLCJ2YWx1ZSI6Inp4bU9iQ2RRZ1hrZWVuWFRuQ2l3YVBMYlBiclZod1BPUlo0eVljXC9GSVlJTjdYRXJDOGlCOEtoQkl4czVKd1ZOIiwibWFjIjoiYjhhN2Q5MjBlZmZkYWVjYjNmNDkyNmQyOTY4MzI0MTA0NjQxOWU1YjkyMzMxZGE5OGUwN2U0YTMyM2VkZTFlZSJ9; expires=Mon, 14-Apr-2025 18:57:09 GMT; Max-Age=72000; path=/ ◀XSRF-TOKEN=eyJpdiI6ImZHbHZub21BNVZnRFRjaVwvREV3MENnPT0iLCJ2YWx1ZSI6Inp4bU9iQ2RRZ1hrZWVuWFRuQ2l3YVBMYlBiclZod1BPUlo0eVljXC9GSVlJTjdYRXJDOGlCOEtoQkl4czVKd1ZOIiwib ▶" 1 => "pickjobs_session=eyJpdiI6IitwbVZuZXdtOHBOVW1US1g4NjJyV1E9PSIsInZhbHVlIjoibW1ISnk1cFBPcktZME0yTTZWa2ZlXC9kZTVEdVRpMStXa3FmWklsRHlGQ2F4UVBDaHFCTmprUkMwYVgycXJUc1QiLCJtYWMiOiI4YTMyNDM1MjZlMzNiZDliNTBkMWFmOWQ3NjUwN2FiOWY2ODM5MTcxNDdmNzg4NzRjN2QxNTc4M2JhNDI0Njc2In0%3D; expires=Mon, 14-Apr-2025 18:57:09 GMT; Max-Age=72000; path=/; httponly ◀pickjobs_session=eyJpdiI6IitwbVZuZXdtOHBOVW1US1g4NjJyV1E9PSIsInZhbHVlIjoibW1ISnk1cFBPcktZME0yTTZWa2ZlXC9kZTVEdVRpMStXa3FmWklsRHlGQ2F4UVBDaHFCTmprUkMwYVgycXJUc1Q ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImZHbHZub21BNVZnRFRjaVwvREV3MENnPT0iLCJ2YWx1ZSI6Inp4bU9iQ2RRZ1hrZWVuWFRuQ2l3YVBMYlBiclZod1BPUlo0eVljXC9GSVlJTjdYRXJDOGlCOEtoQkl4czVKd1ZOIiwibWFjIjoiYjhhN2Q5MjBlZmZkYWVjYjNmNDkyNmQyOTY4MzI0MTA0NjQxOWU1YjkyMzMxZGE5OGUwN2U0YTMyM2VkZTFlZSJ9; expires=Mon, 14-Apr-2025 18:57:09 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImZHbHZub21BNVZnRFRjaVwvREV3MENnPT0iLCJ2YWx1ZSI6Inp4bU9iQ2RRZ1hrZWVuWFRuQ2l3YVBMYlBiclZod1BPUlo0eVljXC9GSVlJTjdYRXJDOGlCOEtoQkl4czVKd1ZOIiwib ▶" 1 => "pickjobs_session=eyJpdiI6IitwbVZuZXdtOHBOVW1US1g4NjJyV1E9PSIsInZhbHVlIjoibW1ISnk1cFBPcktZME0yTTZWa2ZlXC9kZTVEdVRpMStXa3FmWklsRHlGQ2F4UVBDaHFCTmprUkMwYVgycXJUc1QiLCJtYWMiOiI4YTMyNDM1MjZlMzNiZDliNTBkMWFmOWQ3NjUwN2FiOWY2ODM5MTcxNDdmNzg4NzRjN2QxNTc4M2JhNDI0Njc2In0%3D; expires=Mon, 14-Apr-2025 18:57:09 GMT; path=/; httponly ◀pickjobs_session=eyJpdiI6IitwbVZuZXdtOHBOVW1US1g4NjJyV1E9PSIsInZhbHVlIjoibW1ISnk1cFBPcktZME0yTTZWa2ZlXC9kZTVEdVRpMStXa3FmWklsRHlGQ2F4UVBDaHFCTmprUkMwYVgycXJUc1Q ▶" ] ]
0 of 0array:8 [▶ "currentLang" => App\Models\Language {#1434 ▶ +timestamps: false #fillable: array:3 [▶ 0 => "slug" 1 => "language_name" 2 => "country_id" ] #table: "settings_languages" #connection: "mysql" #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] #perPage: 15 +exists: true +wasRecentlyCreated: false #attributes: array:12 [▶ "id" => 5 "slug" => "uk" "country_id" => 229 "language_name" => "Українська" "currency" => "uah" "eur_conversion_rate" => "32.12" "conversion_date" => "2022-03-25 12:00:03" "order_num" => 5 "vat" => 0.0 "invoice_note" => "This service is not subjected to VAT payment due to Article 17 Paragraph 1 of Croatian VAT Act.\r<br>Ova usluga ne podliježe plaćanju PDV-a prema odredbama članka 17. stavka 1. Zakona o PDV-u - prijenos porezne obveze (reverse charge). ◀This service is not subjected to VAT payment due to Article 17 Paragraph 1 of Croatian VAT Act.\r<br>Ova usluga ne podliježe plaćanju PDV-a prema odredbama član ▶" "job_translate" => 1 "is_active" => 1 ] #original: array:12 [▶ "id" => 5 "slug" => "uk" "country_id" => 229 "language_name" => "Українська" "currency" => "uah" "eur_conversion_rate" => "32.12" "conversion_date" => "2022-03-25 12:00:03" "order_num" => 5 "vat" => 0.0 "invoice_note" => "This service is not subjected to VAT payment due to Article 17 Paragraph 1 of Croatian VAT Act.\r<br>Ova usluga ne podliježe plaćanju PDV-a prema odredbama članka 17. stavka 1. Zakona o PDV-u - prijenos porezne obveze (reverse charge). ◀This service is not subjected to VAT payment due to Article 17 Paragraph 1 of Croatian VAT Act.\r<br>Ova usluga ne podliježe plaćanju PDV-a prema odredbama član ▶" "job_translate" => 1 "is_active" => 1 ] #changes: [] #casts: [] #dates: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: [] #touches: [] #hidden: [] #visible: [] #guarded: array:1 [▶ 0 => "*" ] } "locale" => "uk" "autolang" => 1 "_flash" => array:2 [▶ "old" => [] "new" => [] ] "_token" => "y2U1XtDuNTsgg1VI99YxiCSh6nsUJ2t4l1u6WrYV" "defaultLang" => App\Models\Language {#1351 ▶ +timestamps: false #fillable: array:3 [▶ 0 => "slug" 1 => "language_name" 2 => "country_id" ] #table: "settings_languages" #connection: "mysql" #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] #perPage: 15 +exists: true +wasRecentlyCreated: false #attributes: array:12 [▶ "id" => 2 "slug" => "hr" "country_id" => 55 "language_name" => "Hrvatski" "currency" => "eur" "eur_conversion_rate" => "1.00" "conversion_date" => "2022-12-31 12:00:02" "order_num" => 1 "vat" => 0.25 "invoice_note" => "" "job_translate" => 1 "is_active" => 1 ] #original: array:12 [▶ "id" => 2 "slug" => "hr" "country_id" => 55 "language_name" => "Hrvatski" "currency" => "eur" "eur_conversion_rate" => "1.00" "conversion_date" => "2022-12-31 12:00:02" "order_num" => 1 "vat" => 0.25 "invoice_note" => "" "job_translate" => 1 "is_active" => 1 ] #changes: [] #casts: [] #dates: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: [] #touches: [] #hidden: [] #visible: [] #guarded: array:1 [▶ 0 => "*" ] } "_previous" => array:1 [▶ "url" => "https://dev.pick.jobs/ua/robochi-miscya/katehoriyi" ] "PHPDEBUGBAR_STACK_DATA" => [] ]