Хорватія
Боснія і Герцеговина
Сербія
Чорногорія
Північна Македонія
Албанія
Косово
Австрія
Німеччина
Швейцарія
Об'єднане Королівство
Аснсн
- Zagreb, Хорватія
- Відкрито до 12.12.2025
Польовий геодезист
- Skoplje, Північна Македонія
- Відкрито до 12.12.2025
Jjkl
- Zagreb, Хорватія
- Відкрито до 12.12.2025
Завантажте безкоштовний мобільний додаток PickJobs на свій Android або iOS, через Google Play Store або App Store та отримайте доступ до можливостей будь-де та в будь-який час.
Кінцевим одержувачем фінансового інструменту, співфінансованого з Європейського фонду відповідального за регіональний розвиток в рамках Оперативної програми є «Конкурентоспроможність та згуртованість»
Для найкращого користувацького досвіду та повної функціональності всіх опцій сайту, PickJobs використовує файли cookie та подібні технології. Якщо ви продовжуєте використовувати цей сайт, ми вважатимемо, що ви прийняли та погодилися з нашою Політикою щодо cookie. Докладніше про Політику щодо cookie.
Завантажте безкоштовний мобільний додаток PickJobs на свій Android або iOS, через Google Play Store або App Store та отримайте доступ до можливостей будь-де та в будь-який час.
| 1 x Application (86.8%) | 296.71ms |
| 1 x Booting (13.18%) | 45.05ms |
| 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 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 23 | |
| 24 | |
| 25 | |
| 26 | |
| 27 | |
| 28 | |
| 29 | |
| 30 | |
| 31 | |
| 32 | |
| 33 | |
| 34 | |
| 35 | |
| 36 | |
| 37 | |
| 38 | |
select * from `jobs` where `unique_id` = 'geodeziya-ta-geologiya' limit 1460μs/app/Http/Controllers/FrontEnd/JobController.php:68pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `jobs_descriptions` where `slug` = 'geodeziya-ta-geologiya' limit 14.46ms/app/Http/Controllers/FrontEnd/JobController.php:78pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `jobs_descriptions` where `job_id` = 0 limit 14.2ms/app/Http/Controllers/FrontEnd/JobController.php:90pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `occupations_trans` where `occupations_trans`.`slug` = 'geodeziya-ta-geologiya'1.19ms/app/Http/Controllers/FrontEnd/JobController.php:128pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `settings_languages` where `slug` = 'hr' limit 11.13ms/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.38ms/app/Models/Occupation.php:136pick| 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-23 04:47:48' and (`banners`.`lasts_until` >= '2025-04-23 04:47:48' or `banners`.`lasts_until` = '0000-00-00 00:00:00') and (`banners`.`langs` like '%uk%') and `banners`.`banner_position` LIKE 'blog%' order by RAND()1.47ms/app/Repositories/BannerRepository.php:110pick| 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` asc7.54ms/app/Http/Controllers/FrontEnd/JobController.php:185pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus` where `menu_type` = '0' limit 1300μs/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` asc4.42ms/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` asc1.6ms/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` asc920μ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` asc1.03ms/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` asc940μ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` asc870μs/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` asc1.05ms/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` asc950μ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 null6.54ms/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 null880μ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 null950μ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` asc4.94ms/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` asc950μ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` asc2.25ms/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` asc1.25ms/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 null1.46ms/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 null890μ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` asc2.38ms/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` asc2.28ms/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` asc2.86ms/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` asc5.01ms/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 null950μ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 null1.65ms/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 null880μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus` where `menu_type` = '0' limit 1220μ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` asc1.73ms/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` asc990μ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.27ms/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` asc1ms/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` asc940μ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` asc250μ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` asc2.67ms/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` asc1.13ms/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 null920μ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 null4.86ms/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 null3.71ms/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` asc1.12ms/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` asc1.01ms/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` asc990μ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` asc1ms/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 null930μ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 null4.85ms/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` asc3.45ms/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` asc340μs/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` asc2.3ms/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` asc320μs/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.32ms/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 null970μ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 null2.38ms/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 null3.66ms/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.77ms/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` asc5.34ms/app/Models/Language.php:192pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `posts` left join `categories` on `posts`.`category_id` = `categories`.`id` left join `categories_trans` on `categories`.`id` = `categories_trans`.`category_id` where `categories`.`type` = 'blog' and `posts`.`language_id` = 5 and `categories_trans`.`language_id` = 5 and `posts`.`is_featured` = 1 and `is_published` = 12.47ms/app/Models/Post.php:386pick| 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 `categories`.`type` = 'blog' and `posts`.`language_id` = 5 and `categories_trans`.`language_id` = 5 and `posts`.`is_featured` = 1 and `is_published` = 1 order by `posts`.`created_at` desc limit 4 offset 01.67ms/app/Models/Post.php:386pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus` where `menu_type` = '1' limit 15.94ms/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` asc1.46ms/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` asc970μ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` asc1.14ms/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` asc1.72ms/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` asc2.13ms/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` asc1.57ms/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` asc280μ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` asc1.22ms/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` asc1.15ms/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` asc1.02ms/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` asc1.36ms/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` asc950μs/app/Models/Language.php:166pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `settings_countries_trans` where `language_id` = 5 and `country_id` = 229500μs/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` asc11.16ms/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` asc1.87ms/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" => "8fcdbbbdb36afcb054033b6e442411728d4aa23784d7d61b84857ba45e858850" "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.143.144.209" "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" => "41357" "REDIRECT_URL" => "/ua/robochi-miscya/geodeziya-ta-geologiya" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/ua/robochi-miscya/geodeziya-ta-geologiya" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1745376468.215 "REQUEST_TIME" => 1745376468 ]
[]
0 of 0array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Wed, 23 Apr 2025 02:47:48 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IllhN3I4UGpJSXlyRFVhcWFHcG8zc0E9PSIsInZhbHVlIjoiZ1llKzV0NnFaQnpuZE9pR3pcL2Y5YUNhUk1BTmZ5RXhtYVFrdVNFUVBYN3N6RUhYRmFyK0VkOFRxZVBWd05LdVQiLCJtYWMiOiIxN2RhZjgxM2YxMjJlMGEwODM4YzEzMGEzOGY4OTk0N2EyOGRhNDcxMjY5Y2EyYjAyNzkwMmU4MzU4ZTk5YjNiIn0%3D; expires=Wed, 23-Apr-2025 22:47:48 GMT; Max-Age=72000; path=/ ◀XSRF-TOKEN=eyJpdiI6IllhN3I4UGpJSXlyRFVhcWFHcG8zc0E9PSIsInZhbHVlIjoiZ1llKzV0NnFaQnpuZE9pR3pcL2Y5YUNhUk1BTmZ5RXhtYVFrdVNFUVBYN3N6RUhYRmFyK0VkOFRxZVBWd05LdVQiLCJtY ▶" 1 => "pickjobs_session=eyJpdiI6IjhGVnlLTXYwN0ZMWmRMdXFERjE0bVE9PSIsInZhbHVlIjoiOWtTaUo4ZHRDM2xRcUYwSmowRWlvTWp1bWlhc0Y4MGdTS2NJNU1ITWVyZEJ6dmFRRk9wN3lMSGZFMTd5anNBTiIsIm1hYyI6IjFjNTIwZTJjMDAzMDhiNTY3MmFmZTkxNDgyZGUzNDRmNTI2NGNkMjc0YWVmOTg3MzA2ODQ0Mjg1OTAwODc0NDkifQ%3D%3D; expires=Wed, 23-Apr-2025 22:47:48 GMT; Max-Age=72000; path=/; httponly ◀pickjobs_session=eyJpdiI6IjhGVnlLTXYwN0ZMWmRMdXFERjE0bVE9PSIsInZhbHVlIjoiOWtTaUo4ZHRDM2xRcUYwSmowRWlvTWp1bWlhc0Y4MGdTS2NJNU1ITWVyZEJ6dmFRRk9wN3lMSGZFMTd5anNBTiI ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IllhN3I4UGpJSXlyRFVhcWFHcG8zc0E9PSIsInZhbHVlIjoiZ1llKzV0NnFaQnpuZE9pR3pcL2Y5YUNhUk1BTmZ5RXhtYVFrdVNFUVBYN3N6RUhYRmFyK0VkOFRxZVBWd05LdVQiLCJtYWMiOiIxN2RhZjgxM2YxMjJlMGEwODM4YzEzMGEzOGY4OTk0N2EyOGRhNDcxMjY5Y2EyYjAyNzkwMmU4MzU4ZTk5YjNiIn0%3D; expires=Wed, 23-Apr-2025 22:47:48 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IllhN3I4UGpJSXlyRFVhcWFHcG8zc0E9PSIsInZhbHVlIjoiZ1llKzV0NnFaQnpuZE9pR3pcL2Y5YUNhUk1BTmZ5RXhtYVFrdVNFUVBYN3N6RUhYRmFyK0VkOFRxZVBWd05LdVQiLCJtY ▶" 1 => "pickjobs_session=eyJpdiI6IjhGVnlLTXYwN0ZMWmRMdXFERjE0bVE9PSIsInZhbHVlIjoiOWtTaUo4ZHRDM2xRcUYwSmowRWlvTWp1bWlhc0Y4MGdTS2NJNU1ITWVyZEJ6dmFRRk9wN3lMSGZFMTd5anNBTiIsIm1hYyI6IjFjNTIwZTJjMDAzMDhiNTY3MmFmZTkxNDgyZGUzNDRmNTI2NGNkMjc0YWVmOTg3MzA2ODQ0Mjg1OTAwODc0NDkifQ%3D%3D; expires=Wed, 23-Apr-2025 22:47:48 GMT; path=/; httponly ◀pickjobs_session=eyJpdiI6IjhGVnlLTXYwN0ZMWmRMdXFERjE0bVE9PSIsInZhbHVlIjoiOWtTaUo4ZHRDM2xRcUYwSmowRWlvTWp1bWlhc0Y4MGdTS2NJNU1ITWVyZEJ6dmFRRk9wN3lMSGZFMTd5anNBTiI ▶" ] ]
0 of 0array:8 [▶ "currentLang" => App\Models\Language {#1442 ▶ +timestamps: false #fillable: array:3 [▶ 0 => "slug" 1 => "language_name" 2 => "country_id" ] #table: "settings_languages" #connection: "mysql" #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] #perPage: 15 +exists: true +wasRecentlyCreated: false #attributes: array:12 [▶ "id" => 5 "slug" => "uk" "country_id" => 229 "language_name" => "Українська" "currency" => "uah" "eur_conversion_rate" => "32.12" "conversion_date" => "2022-03-25 12:00:03" "order_num" => 5 "vat" => 0.0 "invoice_note" => "This service is not subjected to VAT payment due to Article 17 Paragraph 1 of Croatian VAT Act.\r<br>Ova usluga ne podliježe plaćanju PDV-a prema odredbama članka 17. stavka 1. Zakona o PDV-u - prijenos porezne obveze (reverse charge). ◀This service is not subjected to VAT payment due to Article 17 Paragraph 1 of Croatian VAT Act.\r<br>Ova usluga ne podliježe plaćanju PDV-a prema odredbama član ▶" "job_translate" => 1 "is_active" => 1 ] #original: array:12 [▶ "id" => 5 "slug" => "uk" "country_id" => 229 "language_name" => "Українська" "currency" => "uah" "eur_conversion_rate" => "32.12" "conversion_date" => "2022-03-25 12:00:03" "order_num" => 5 "vat" => 0.0 "invoice_note" => "This service is not subjected to VAT payment due to Article 17 Paragraph 1 of Croatian VAT Act.\r<br>Ova usluga ne podliježe plaćanju PDV-a prema odredbama članka 17. stavka 1. Zakona o PDV-u - prijenos porezne obveze (reverse charge). ◀This service is not subjected to VAT payment due to Article 17 Paragraph 1 of Croatian VAT Act.\r<br>Ova usluga ne podliježe plaćanju PDV-a prema odredbama član ▶" "job_translate" => 1 "is_active" => 1 ] #changes: [] #casts: [] #dates: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: [] #touches: [] #hidden: [] #visible: [] #guarded: array:1 [▶ 0 => "*" ] } "locale" => "uk" "autolang" => 1 "_flash" => array:2 [▶ "old" => [] "new" => [] ] "_token" => "3Z4pTwjzxPczFsSpvp034heigrq6soPFvNYVu9fe" "defaultLang" => App\Models\Language {#1441 ▶ +timestamps: false #fillable: array:3 [▶ 0 => "slug" 1 => "language_name" 2 => "country_id" ] #table: "settings_languages" #connection: "mysql" #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] #perPage: 15 +exists: true +wasRecentlyCreated: false #attributes: array:12 [▶ "id" => 2 "slug" => "hr" "country_id" => 55 "language_name" => "Hrvatski" "currency" => "eur" "eur_conversion_rate" => "1.00" "conversion_date" => "2022-12-31 12:00:02" "order_num" => 1 "vat" => 0.25 "invoice_note" => "" "job_translate" => 1 "is_active" => 1 ] #original: array:12 [▶ "id" => 2 "slug" => "hr" "country_id" => 55 "language_name" => "Hrvatski" "currency" => "eur" "eur_conversion_rate" => "1.00" "conversion_date" => "2022-12-31 12:00:02" "order_num" => 1 "vat" => 0.25 "invoice_note" => "" "job_translate" => 1 "is_active" => 1 ] #changes: [] #casts: [] #dates: [] #dateFormat: null #appends: [] #dispatchesEvents: [] #observables: [] #relations: [] #touches: [] #hidden: [] #visible: [] #guarded: array:1 [▶ 0 => "*" ] } "_previous" => array:1 [▶ "url" => "https://dev.pick.jobs/ua/robochi-miscya/geodeziya-ta-geologiya" ] "PHPDEBUGBAR_STACK_DATA" => [] ]