Bosna i Hercegovina
Srbija
Crna Gora
Sjeverna Makedonija
Ukrajina
Albania
Kosovo
Austrija
Njemačka
Švicarska
Velika Britanija
PickJobs mobilna aplikacija
Preuzmite besplatnu PickJobs mobilnu aplikaciju na svom Android ili iOS uređaju, putem Google Play Store-a ili App Store-a te ostvarite pristup bilo gdje i bilo kada.
Preuzmite besplatnu PickJobs mobilnu aplikaciju na svom Android ili iOS uređaju, putem Google Play Store-a ili App Store-a te ostvarite pristup bilo gdje i bilo kada.
Krajnji primatelj financijskog instrumenta sufinanciranog iz Europskog fonda za regionalni razvoj u sklopu Operativnog programa “Konkurentnost i kohezija”
Za najbolje korisničko iskustvo i potpunu funkcionalnost svih značajki web stranice, PickJobs koristi kolačiće i slične tehnologije. Ako nastavite koristiti ovu stranicu, smatrat ćemo da ste prihvatili i usuglasili se s našim Pravilima o kolačićima. Pročitajte više o Kolačićima
Preuzmite besplatnu PickJobs mobilnu aplikaciju na svom Android ili iOS uređaju, putem Google Play Store-a ili App Store-a te ostvarite pristup bilo gdje i bilo kada.
| 1 x Application (85.15%) | 303.91ms |
| 1 x Booting (14.83%) | 52.93ms |
| 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` = 2 and `categories_trans`.`language_id` = 2 and `categories`.`type` = 'blog' and `is_featured` = 1 and `is_published` = 15.75ms/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` = 2 and `categories_trans`.`language_id` = 2 and `categories`.`type` = 'blog' and `is_featured` = 1 and `is_published` = 1 order by `posts`.`published_at` desc limit 3 offset 03.48ms/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-07 22:29:50' and (`banners`.`lasts_until` >= '2025-04-07 22:29:50' or `banners`.`lasts_until` = '0000-00-00 00:00:00') and (`banners`.`langs` like '%hr%') and `banners`.`banner_position` LIKE 'landing%' order by RAND()3.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(hr_occupations_trans.occupation_name) as name from `occupations` 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` asc860μs/app/Models/Occupation.php:136pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `occupations_trans` where `language_id` = 2 order by `occupation_name` asc510μs/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.41ms/app/Http/Controllers/FrontEnd/FrontEndController.php:744pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `occupations_trans` where `language_id` = 2 order by `occupation_name` asc5.78ms/app/Providers/ViewServiceProvider.php:304pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus` where `menu_type` = '0' limit 15.16ms/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` = 2 and `parent_id` = '0' order by `menu_order` asc5.29ms/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (38, 39, 40, 43, 47, 466) order by `menu_order` asc1.12ms/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (41, 42, 44, 46, 81, 82, 83, 123, 464) order by `menu_order` asc1.06ms/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 38 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc1.41ms/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 39 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc2.03ms/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (81, 82, 83, 464) order by `menu_order` asc2.51ms/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 39 and `menus_items`.`parent_id` is not null order by `menu_order` asc3ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (81, 82, 83, 464) order by `menu_order` asc2.16ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 81 and `menus_items`.`parent_id` is not null230μ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` = 82 and `menus_items`.`parent_id` is not null4.52ms/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` = 83 and `menus_items`.`parent_id` is not null1.48ms/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` = 464 and `menus_items`.`parent_id` is not null1.47ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 40 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc1.38ms/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (41, 42) order by `menu_order` asc2.27ms/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 40 and `menus_items`.`parent_id` is not null order by `menu_order` asc840μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (41, 42) order by `menu_order` asc4.91ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 41 and `menus_items`.`parent_id` is not null1.78ms/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` = 42 and `menus_items`.`parent_id` is not null900μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 43 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc1.64ms/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 47 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc1.1ms/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (44, 46, 123) order by `menu_order` asc1.82ms/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 47 and `menus_items`.`parent_id` is not null order by `menu_order` asc1.65ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (44, 46, 123) order by `menu_order` asc2.58ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 46 and `menus_items`.`parent_id` is not null3.53ms/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` = 44 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` = 123 and `menus_items`.`parent_id` is not null440μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 466 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc2.36ms/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus` where `menu_type` = '0' limit 11.18ms/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` = 2 and `parent_id` = '0' order by `menu_order` asc1.57ms/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (38, 39, 40, 43, 47, 466) order by `menu_order` asc960μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (41, 42, 44, 46, 81, 82, 83, 123, 464) order by `menu_order` asc2.32ms/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 38 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc5.44ms/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 39 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc1.17ms/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (81, 82, 83, 464) order by `menu_order` asc2.02ms/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 39 and `menus_items`.`parent_id` is not null order by `menu_order` asc1.11ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (81, 82, 83, 464) order by `menu_order` asc1.11ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 81 and `menus_items`.`parent_id` is not null1.83ms/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` = 82 and `menus_items`.`parent_id` is not null2.22ms/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` = 83 and `menus_items`.`parent_id` is not null2.83ms/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` = 464 and `menus_items`.`parent_id` is not null1.79ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 40 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc1.41ms/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (41, 42) order by `menu_order` asc1.49ms/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 40 and `menus_items`.`parent_id` is not null order by `menu_order` asc1.64ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (41, 42) order by `menu_order` asc5.1ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 41 and `menus_items`.`parent_id` is not null1.48ms/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` = 42 and `menus_items`.`parent_id` is not null1.46ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 43 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` = 47 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc1.51ms/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (44, 46, 123) order by `menu_order` asc1.54ms/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 47 and `menus_items`.`parent_id` is not null order by `menu_order` asc1.6ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (44, 46, 123) order by `menu_order` asc1.02ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 46 and `menus_items`.`parent_id` is not null2.83ms/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` = 44 and `menus_items`.`parent_id` is not null1.37ms/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` = 123 and `menus_items`.`parent_id` is not null790μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 466 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc2.68ms/app/Services/MenuService.php:131pick| 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` = 2 order by `settings_countries`.`priority` asc3.45ms/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` = 2 and `settings_countries`.`id` = 55 order by `settings_languages`.`order_num` asc5.16ms/app/Models/Language.php:192pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus` where `menu_type` = '1' limit 1820μs/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` = 2 and `parent_id` = '0' order by `menu_order` asc3.13ms/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (48, 52, 58, 63) order by `menu_order` asc1.88ms/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (49, 50, 51, 53, 54, 55, 56, 57, 59, 61, 62, 64, 65, 66, 67, 121, 453, 462, 463, 465) order by `menu_order` asc3.09ms/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 48 and `menus_items`.`parent_id` is not null order by `menu_order` asc1.43ms/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (49, 50, 51, 121, 463, 465) order by `menu_order` asc1.56ms/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 52 and `menus_items`.`parent_id` is not null order by `menu_order` asc1.51ms/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (53, 54, 55, 56, 57) order by `menu_order` asc1.58ms/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 58 and `menus_items`.`parent_id` is not null order by `menu_order` asc1.82ms/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (59, 61, 62, 453, 462) order by `menu_order` asc2.22ms/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 63 and `menus_items`.`parent_id` is not null order by `menu_order` asc480μs/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (64, 65, 66, 67) order by `menu_order` asc1.45ms/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` = 2 group by `slug` order by `settings_languages`.`order_num` asc3.39ms/app/Models/Language.php:166pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `settings_countries_trans` where `language_id` = 2 and `country_id` = 551.78ms/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` = 2 group by `settings_countries_trans`.`country_name`, `settings_countries_trans`.`country_id` order by `settings_countries`.`priority` asc, `settings_countries_trans`.`country_name` asc10.48ms/app/Models/Country.php:69pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select `occupations`.*, coalesce(hr_occupations_trans.occupation_name) as name, coalesce(hr_occupations_trans.description) as description from `occupations` 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` asc3.88ms/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" => "df6a60b46d488ba1ca6d58f96a0c19e54590b54027b4d0f62e8d5526eb625684" "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.191.232.50" "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" => "45980" "REDIRECT_URL" => "/hr/poslovi/kategorije" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/hr/poslovi/kategorije" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744057790.707 "REQUEST_TIME" => 1744057790 ]
[]
0 of 0array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Mon, 07 Apr 2025 20:29:50 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImxFNm9zbnE4czFrT25JaVZXbkM2N3c9PSIsInZhbHVlIjoiRHF5NWFiaHlrem9CZlhyTXNSenlWOFVPN3VTb2JROXVqXC9ZbVVhaHI2bHI2WlZEWHpleXJ5aUQwVlpBWkVKVVUiLCJtYWMiOiJkMWY0MTkzZjA1NjdhZGU3MjlmYzc2ZDE3MDJjMjZiMTc1NjMwMjdjNjc1ODBkMTg4YzRhYmFmNzhjMjIyYjcwIn0%3D; expires=Tue, 08-Apr-2025 16:29:51 GMT; Max-Age=72000; path=/ ◀XSRF-TOKEN=eyJpdiI6ImxFNm9zbnE4czFrT25JaVZXbkM2N3c9PSIsInZhbHVlIjoiRHF5NWFiaHlrem9CZlhyTXNSenlWOFVPN3VTb2JROXVqXC9ZbVVhaHI2bHI2WlZEWHpleXJ5aUQwVlpBWkVKVVUiLCJtY ▶" 1 => "pickjobs_session=eyJpdiI6Im5pQjBcL2xMMXFUbGpMUGdVMjh5UVRBPT0iLCJ2YWx1ZSI6IkRmc0NVRnBRdTZNb2tESE95Q3dDQ2ZKVHFxVzJnbFJueFBRWTBhNDdCVkNpWUloXC9WUldCbEM4YUh1ZzlZRXlIIiwibWFjIjoiYjRiODYzYTE5NGMzY2ZmNzdjZWQ0MTVlNDk4ODQxOTVkNzZkZmNjOGExYjFhYzM3NzI2YTkzMzRiN2I0OTAyMyJ9; expires=Tue, 08-Apr-2025 16:29:51 GMT; Max-Age=72000; path=/; httponly ◀pickjobs_session=eyJpdiI6Im5pQjBcL2xMMXFUbGpMUGdVMjh5UVRBPT0iLCJ2YWx1ZSI6IkRmc0NVRnBRdTZNb2tESE95Q3dDQ2ZKVHFxVzJnbFJueFBRWTBhNDdCVkNpWUloXC9WUldCbEM4YUh1ZzlZRXl ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImxFNm9zbnE4czFrT25JaVZXbkM2N3c9PSIsInZhbHVlIjoiRHF5NWFiaHlrem9CZlhyTXNSenlWOFVPN3VTb2JROXVqXC9ZbVVhaHI2bHI2WlZEWHpleXJ5aUQwVlpBWkVKVVUiLCJtYWMiOiJkMWY0MTkzZjA1NjdhZGU3MjlmYzc2ZDE3MDJjMjZiMTc1NjMwMjdjNjc1ODBkMTg4YzRhYmFmNzhjMjIyYjcwIn0%3D; expires=Tue, 08-Apr-2025 16:29:51 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImxFNm9zbnE4czFrT25JaVZXbkM2N3c9PSIsInZhbHVlIjoiRHF5NWFiaHlrem9CZlhyTXNSenlWOFVPN3VTb2JROXVqXC9ZbVVhaHI2bHI2WlZEWHpleXJ5aUQwVlpBWkVKVVUiLCJtY ▶" 1 => "pickjobs_session=eyJpdiI6Im5pQjBcL2xMMXFUbGpMUGdVMjh5UVRBPT0iLCJ2YWx1ZSI6IkRmc0NVRnBRdTZNb2tESE95Q3dDQ2ZKVHFxVzJnbFJueFBRWTBhNDdCVkNpWUloXC9WUldCbEM4YUh1ZzlZRXlIIiwibWFjIjoiYjRiODYzYTE5NGMzY2ZmNzdjZWQ0MTVlNDk4ODQxOTVkNzZkZmNjOGExYjFhYzM3NzI2YTkzMzRiN2I0OTAyMyJ9; expires=Tue, 08-Apr-2025 16:29:51 GMT; path=/; httponly ◀pickjobs_session=eyJpdiI6Im5pQjBcL2xMMXFUbGpMUGdVMjh5UVRBPT0iLCJ2YWx1ZSI6IkRmc0NVRnBRdTZNb2tESE95Q3dDQ2ZKVHFxVzJnbFJueFBRWTBhNDdCVkNpWUloXC9WUldCbEM4YUh1ZzlZRXl ▶" ] ]
0 of 0array:8 [▶ "currentLang" => App\Models\Language {#1390 ▶ +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 => "*" ] } "locale" => "hr" "autolang" => 1 "_flash" => array:2 [▶ "old" => [] "new" => [] ] "_token" => "Po61HxOXr8mxANFdFMQZvZWFh2QuQslPWWQPamLZ" "defaultLang" => App\Models\Language {#1307 ▶ +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/hr/poslovi/kategorije" ] "PHPDEBUGBAR_STACK_DATA" => [] ]