Ukoliko vam je potrebna pomoć ili imate pitanja oko kreiranja računa, objavljivanja oglasa, upravljanja prijavama itd. Pogledajte dokument FAQ i slobodno nas kontaktirajte e-poštom na info@pick.jobs ili na broj telefona +385 (0)1 618 49 17
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
1 x Application (85.07%) | 101.28ms |
1 x Booting (14.84%) | 17.66ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
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 |
|
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 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
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 |
|
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 |
|
select count(*) as aggregate from `settings_countries_trans` where `language_id` = 2 and `country_id` = 55
560μs/app/Models/Country.php:53pickMetadata | |
---|---|
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` asc
6.65ms/app/Models/Country.php:69pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select occupations.id, occupations_trans.occupation_name from `occupations` left join `occupations_trans` on `occupations_trans`.`occupation_id` = `occupations`.`id` and `occupations_trans`.`language_id` = 2 where `occupations`.`parent_id` = 0 and `occupations_trans`.`occupation_name` <> '' order by `occupations_trans`.`occupation_name` asc
790μs/app/Http/Controllers/FrontEnd/UserRegisterController.php:193pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menus` where `menu_type` = '0' limit 1
310μs/app/Services/MenuService.php:75pickMetadata | |
---|---|
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` asc
550μs/app/Models/Menu.php:72pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (38, 39, 40, 43, 47, 466) order by `menu_order` asc
360μs/app/Models/Menu.php:72pickMetadata | |
---|---|
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` asc
280μs/app/Models/Menu.php:72pickMetadata | |
---|---|
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` asc
280μs/app/Services/MenuService.php:85pickMetadata | |
---|---|
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` asc
300μs/app/Services/MenuService.php:85pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (81, 82, 83, 464) order by `menu_order` asc
260μs/app/Services/MenuService.php:85pickMetadata | |
---|---|
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
300μs/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (81, 82, 83, 464) order by `menu_order` asc
340μs/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 81 and `menus_items`.`parent_id` is not null
240μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 82 and `menus_items`.`parent_id` is not null
230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 83 and `menus_items`.`parent_id` is not null
210μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 464 and `menus_items`.`parent_id` is not null
230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
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` asc
300μs/app/Services/MenuService.php:85pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (41, 42) order by `menu_order` asc
250μs/app/Services/MenuService.php:85pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 40 and `menus_items`.`parent_id` is not null order by `menu_order` asc
310μs/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (41, 42) order by `menu_order` asc
260μs/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 41 and `menus_items`.`parent_id` is not null
230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 42 and `menus_items`.`parent_id` is not null
230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
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` asc
270μs/app/Services/MenuService.php:85pickMetadata | |
---|---|
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` asc
340μs/app/Services/MenuService.php:85pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (44, 46, 123) order by `menu_order` asc
280μs/app/Services/MenuService.php:85pickMetadata | |
---|---|
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
300μs/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (44, 46, 123) order by `menu_order` asc
260μs/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 46 and `menus_items`.`parent_id` is not null
230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 44 and `menus_items`.`parent_id` is not null
230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 123 and `menus_items`.`parent_id` is not null
230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
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` asc
260μs/app/Services/MenuService.php:85pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus` where `menu_type` = '0' limit 1
250μs/app/Services/MenuService.php:121pickMetadata | |
---|---|
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` asc
520μs/app/Models/Menu.php:72pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (38, 39, 40, 43, 47, 466) order by `menu_order` asc
330μs/app/Models/Menu.php:72pickMetadata | |
---|---|
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` asc
280μs/app/Models/Menu.php:72pickMetadata | |
---|---|
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` asc
270μs/app/Services/MenuService.php:131pickMetadata | |
---|---|
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` asc
310μs/app/Services/MenuService.php:131pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (81, 82, 83, 464) order by `menu_order` asc
260μs/app/Services/MenuService.php:131pickMetadata | |
---|---|
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
300μs/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (81, 82, 83, 464) order by `menu_order` asc
260μs/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 81 and `menus_items`.`parent_id` is not null
230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 82 and `menus_items`.`parent_id` is not null
230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 83 and `menus_items`.`parent_id` is not null
250μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 464 and `menus_items`.`parent_id` is not null
230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
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` asc
300μs/app/Services/MenuService.php:131pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (41, 42) order by `menu_order` asc
260μs/app/Services/MenuService.php:131pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 40 and `menus_items`.`parent_id` is not null order by `menu_order` asc
430μs/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (41, 42) order by `menu_order` asc
270μs/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 41 and `menus_items`.`parent_id` is not null
230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 42 and `menus_items`.`parent_id` is not null
230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
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` asc
250μs/app/Services/MenuService.php:131pickMetadata | |
---|---|
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` asc
280μs/app/Services/MenuService.php:131pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (44, 46, 123) order by `menu_order` asc
250μs/app/Services/MenuService.php:131pickMetadata | |
---|---|
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
290μs/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (44, 46, 123) order by `menu_order` asc
250μs/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 46 and `menus_items`.`parent_id` is not null
250μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 44 and `menus_items`.`parent_id` is not null
220μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 123 and `menus_items`.`parent_id` is not null
230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
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` asc
270μs/app/Services/MenuService.php:131pickMetadata | |
---|---|
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` asc
930μs/app/Models/Language.php:179pickMetadata | |
---|---|
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` asc
620μs/app/Models/Language.php:192pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus` where `menu_type` = '1' limit 1
250μs/app/Services/MenuService.php:421pickMetadata | |
---|---|
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` asc
500μs/app/Models/Menu.php:72pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (48, 52, 58, 63) order by `menu_order` asc
370μs/app/Models/Menu.php:72pickMetadata | |
---|---|
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` asc
330μs/app/Models/Menu.php:72pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 48 and `menus_items`.`parent_id` is not null order by `menu_order` asc
310μs/app/Services/MenuService.php:433pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (49, 50, 51, 121, 463, 465) order by `menu_order` asc
270μs/app/Services/MenuService.php:433pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 52 and `menus_items`.`parent_id` is not null order by `menu_order` asc
350μs/app/Services/MenuService.php:433pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (53, 54, 55, 56, 57) order by `menu_order` asc
290μs/app/Services/MenuService.php:433pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 58 and `menus_items`.`parent_id` is not null order by `menu_order` asc
350μs/app/Services/MenuService.php:433pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (59, 61, 62, 453, 462) order by `menu_order` asc
250μs/app/Services/MenuService.php:433pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 63 and `menus_items`.`parent_id` is not null order by `menu_order` asc
310μs/app/Services/MenuService.php:433pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (64, 65, 66, 67) order by `menu_order` asc
260μs/app/Services/MenuService.php:433pickMetadata | |
---|---|
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` asc
940μs/app/Models/Language.php:166pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `settings_countries_trans` where `language_id` = 2 and `country_id` = 55
350μs/app/Models/Country.php:53pickMetadata | |
---|---|
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` asc
5.84ms/app/Models/Country.php:69pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `settings_languages` where `slug` = 'hr' limit 1
260μs/app/Models/Language.php:55pickMetadata | |
---|---|
Bindings |
|
Hints |
|
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` asc
1ms/app/Models/Occupation.php:48pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
200
[]
[]
0 of 0array:17 [▶ "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" ] "cookie" => array:1 [▶ 0 => "PHPSESSID=6lmoghdv6v5ev0jbuemfe3gqq8; XSRF-TOKEN=eyJpdiI6IlVWM01yZTN2dUlGNkw1bUZwYzRoWUE9PSIsInZhbHVlIjoiNWplR3lrT0JCRUlVUStxNjBLVnREdUNYRER6bW90dnJkUXdrWjRid1dDWENPWWY1aDRYOVlmdTFMKzhZcWFnQSIsIm1hYyI6IjE3ZmJkNGY4MWVmYTZiNDU5NjE4OGQ2ZDBlMWEyODY4OTU1ZGY0ODEzYzg3MmU5ZTY3MDdlMmQzODZhNDM3NWYifQ%3D%3D; pickjobs_session=eyJpdiI6InRqRHdUZEd0dHNjdUJxMndcLzVRd3VRPT0iLCJ2YWx1ZSI6IlkydmJnOGxFWnd0dzlzbFBhZ3JaTTk5OU1oM3pvdkJiVmdKa0p6RzVlbW8zZGF6VW1pQkhJYXI3b2F2RnhZTzAiLCJtYWMiOiI1NDIzMmU3NjU4NzE5ZjBhMjI3ZWMxYTBmNGRlMjdlZGM2NzkzMjYzNTlhNDMzZjc1ZjQ4ZjUyMjQ0ZTFjYjU4In0%3D ◀PHPSESSID=6lmoghdv6v5ev0jbuemfe3gqq8; XSRF-TOKEN=eyJpdiI6IlVWM01yZTN2dUlGNkw1bUZwYzRoWUE9PSIsInZhbHVlIjoiNWplR3lrT0JCRUlVUStxNjBLVnREdUNYRER6bW90dnJkUXdrWjRid1d ▶" ] ]
0 of 0array:74 [▶ "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" => "de1f9fafe8a20d73efeaf45f13cd47b7027bd0cd91beec0b8e874beda40911f2" "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" "HTTP_COOKIE" => "PHPSESSID=6lmoghdv6v5ev0jbuemfe3gqq8; XSRF-TOKEN=eyJpdiI6IlVWM01yZTN2dUlGNkw1bUZwYzRoWUE9PSIsInZhbHVlIjoiNWplR3lrT0JCRUlVUStxNjBLVnREdUNYRER6bW90dnJkUXdrWjRid1dDWENPWWY1aDRYOVlmdTFMKzhZcWFnQSIsIm1hYyI6IjE3ZmJkNGY4MWVmYTZiNDU5NjE4OGQ2ZDBlMWEyODY4OTU1ZGY0ODEzYzg3MmU5ZTY3MDdlMmQzODZhNDM3NWYifQ%3D%3D; pickjobs_session=eyJpdiI6InRqRHdUZEd0dHNjdUJxMndcLzVRd3VRPT0iLCJ2YWx1ZSI6IlkydmJnOGxFWnd0dzlzbFBhZ3JaTTk5OU1oM3pvdkJiVmdKa0p6RzVlbW8zZGF6VW1pQkhJYXI3b2F2RnhZTzAiLCJtYWMiOiI1NDIzMmU3NjU4NzE5ZjBhMjI3ZWMxYTBmNGRlMjdlZGM2NzkzMjYzNTlhNDMzZjc1ZjQ4ZjUyMjQ0ZTFjYjU4In0%3D ◀PHPSESSID=6lmoghdv6v5ev0jbuemfe3gqq8; XSRF-TOKEN=eyJpdiI6IlVWM01yZTN2dUlGNkw1bUZwYzRoWUE9PSIsInZhbHVlIjoiNWplR3lrT0JCRUlVUStxNjBLVnREdUNYRER6bW90dnJkUXdrWjRid1d ▶" "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.189.28.82" "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" => "18828" "REDIRECT_URL" => "/hr/registracija" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/hr/registracija" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1739961881.433 "REQUEST_TIME" => 1739961881 ]
0 of 0array:3 [▶ "PHPSESSID" => null "XSRF-TOKEN" => "aNiW32QTmDA0CSP3hkzCqN4FYxmwKPm7gHItmgrz" "pickjobs_session" => "YJ0Zi25IGaHh1844IBaglKehGt8A0luiQvWYvqwI" ]
0 of 0array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Wed, 19 Feb 2025 10:44:41 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ikx6cXhmWG9VdVwvS1pJQ0Z2bVp4d1RBPT0iLCJ2YWx1ZSI6InNTRFNPV2JUallSNDFFU0hmWStUMHZROWpsTmgydE1hNGhSNFFHMVVmaHE2bW1vZnIwMEg5K0VvdFpVY1l1QkYiLCJtYWMiOiIzMDQ1NDllZjQwMzg5ZDhlNDdhZDkzMTFlZjc4Y2FjY2FjNzkyNWM4MjJiZWQ2M2E3ZGQ2YTc2ZDMwZGQ2M2VlIn0%3D; expires=Thu, 20-Feb-2025 06:44:41 GMT; Max-Age=72000; path=/ ◀XSRF-TOKEN=eyJpdiI6Ikx6cXhmWG9VdVwvS1pJQ0Z2bVp4d1RBPT0iLCJ2YWx1ZSI6InNTRFNPV2JUallSNDFFU0hmWStUMHZROWpsTmgydE1hNGhSNFFHMVVmaHE2bW1vZnIwMEg5K0VvdFpVY1l1QkYiLCJtY ▶" 1 => "pickjobs_session=eyJpdiI6ImhGdGJMN1Jtck8rNmJlbjFFS0toSGc9PSIsInZhbHVlIjoiWkpaaVIydW1scTM0VG5SUWo0eDVZU0dtYktPTXhrK3hreGRUUnFQSE1CWng0V1M2S25TajA5dVJyNGQwU1wvTUQiLCJtYWMiOiI3ZDJlOWI1ZGQ5ZGExMTY0OTM0MTBiNmZmZjIyODgyYjQ2YjcwNDVkMzk3Y2QzZDM1NGFlMGIxYzEzMzEwOThhIn0%3D; expires=Thu, 20-Feb-2025 06:44:41 GMT; Max-Age=72000; path=/; httponly ◀pickjobs_session=eyJpdiI6ImhGdGJMN1Jtck8rNmJlbjFFS0toSGc9PSIsInZhbHVlIjoiWkpaaVIydW1scTM0VG5SUWo0eDVZU0dtYktPTXhrK3hreGRUUnFQSE1CWng0V1M2S25TajA5dVJyNGQwU1wvTUQ ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6Ikx6cXhmWG9VdVwvS1pJQ0Z2bVp4d1RBPT0iLCJ2YWx1ZSI6InNTRFNPV2JUallSNDFFU0hmWStUMHZROWpsTmgydE1hNGhSNFFHMVVmaHE2bW1vZnIwMEg5K0VvdFpVY1l1QkYiLCJtYWMiOiIzMDQ1NDllZjQwMzg5ZDhlNDdhZDkzMTFlZjc4Y2FjY2FjNzkyNWM4MjJiZWQ2M2E3ZGQ2YTc2ZDMwZGQ2M2VlIn0%3D; expires=Thu, 20-Feb-2025 06:44:41 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6Ikx6cXhmWG9VdVwvS1pJQ0Z2bVp4d1RBPT0iLCJ2YWx1ZSI6InNTRFNPV2JUallSNDFFU0hmWStUMHZROWpsTmgydE1hNGhSNFFHMVVmaHE2bW1vZnIwMEg5K0VvdFpVY1l1QkYiLCJtY ▶" 1 => "pickjobs_session=eyJpdiI6ImhGdGJMN1Jtck8rNmJlbjFFS0toSGc9PSIsInZhbHVlIjoiWkpaaVIydW1scTM0VG5SUWo0eDVZU0dtYktPTXhrK3hreGRUUnFQSE1CWng0V1M2S25TajA5dVJyNGQwU1wvTUQiLCJtYWMiOiI3ZDJlOWI1ZGQ5ZGExMTY0OTM0MTBiNmZmZjIyODgyYjQ2YjcwNDVkMzk3Y2QzZDM1NGFlMGIxYzEzMzEwOThhIn0%3D; expires=Thu, 20-Feb-2025 06:44:41 GMT; path=/; httponly ◀pickjobs_session=eyJpdiI6ImhGdGJMN1Jtck8rNmJlbjFFS0toSGc9PSIsInZhbHVlIjoiWkpaaVIydW1scTM0VG5SUWo0eDVZU0dtYktPTXhrK3hreGRUUnFQSE1CWng0V1M2S25TajA5dVJyNGQwU1wvTUQ ▶" ] ]
0 of 0array:8 [▶ "currentLang" => App\Models\Language {#1425 ▶ +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" => "aNiW32QTmDA0CSP3hkzCqN4FYxmwKPm7gHItmgrz" "_previous" => array:1 [▶ "url" => "https://dev.pick.jobs/hr/registracija" ] "defaultLang" => App\Models\Language {#1424 ▶ +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 => "*" ] } "PHPDEBUGBAR_STACK_DATA" => [] ]