Менеджер / Бригадир
- Berlin, Німеччина
- Відкрито до 12.12.2025
Ssbbsbshs
- Zagreb, Хорватія
- Відкрито до 12.12.2025
Підсобний робітник на будівництві
- Vinkovci, Хорватія
- Відкрито до 12.12.2025
Кінцевим одержувачем фінансового інструменту, співфінансованого з Європейського фонду відповідального за регіональний розвиток в рамках Оперативної програми є «Конкурентоспроможність та згуртованість»
Для найкращого користувацького досвіду та повної функціональності всіх опцій сайту, PickJobs використовує файли cookie та подібні технології. Якщо ви продовжуєте використовувати цей сайт, ми вважатимемо, що ви прийняли та погодилися з нашою Політикою щодо cookie. Докладніше про Політику щодо cookie.
1 x Application (86.1%) | 558.79ms |
1 x Booting (13.89%) | 90.12ms |
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` = 'budivnictvo' limit 1
670μs/app/Http/Controllers/FrontEnd/JobController.php:68pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `jobs_descriptions` where `slug` = 'budivnictvo' limit 1
5.71ms/app/Http/Controllers/FrontEnd/JobController.php:78pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `jobs_descriptions` where `job_id` = 0 limit 1
4.92ms/app/Http/Controllers/FrontEnd/JobController.php:90pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `occupations_trans` where `occupations_trans`.`slug` = 'budivnictvo'
410μs/app/Http/Controllers/FrontEnd/JobController.php:128pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `settings_languages` where `slug` = 'hr' limit 1
290μs/app/Models/Language.php:55pickMetadata | |
---|---|
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` asc
1.85ms/app/Models/Occupation.php:136pickMetadata | |
---|---|
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-27 02:37:08' and (`banners`.`lasts_until` >= '2025-04-27 02:37:08' or `banners`.`lasts_until` = '0000-00-00 00:00:00') and (`banners`.`langs` like '%uk%') and `banners`.`banner_position` LIKE 'blog%' order by RAND()
3.14ms/app/Repositories/BannerRepository.php:110pickMetadata | |
---|---|
Bindings |
|
Hints | |
Backtrace |
|
select `region_place_id`, `region` from `jobs` where `country_id` = 55 and `region` <> '' group by `region_place_id` order by `region` asc
8.98ms/app/Http/Controllers/FrontEnd/JobController.php:185pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menus` where `menu_type` = '0' limit 1
400μ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` = 5 and `parent_id` = '0' order by `menu_order` asc
1.46ms/app/Models/Menu.php:72pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (243, 244, 248, 251, 252) order by `menu_order` asc
4.97ms/app/Models/Menu.php:72pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (245, 246, 247, 249, 250, 254, 255, 256) order by `menu_order` asc
370μs/app/Models/Menu.php:72pickMetadata | |
---|---|
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` asc
2.71ms/app/Services/MenuService.php:85pickMetadata | |
---|---|
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` asc
1.01ms/app/Services/MenuService.php:85pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (245, 246, 247) order by `menu_order` asc
500μs/app/Services/MenuService.php:85pickMetadata | |
---|---|
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
1.13ms/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (245, 246, 247) order by `menu_order` asc
3.68ms/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 245 and `menus_items`.`parent_id` is not null
1.05ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 246 and `menus_items`.`parent_id` is not null
2.49ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 247 and `menus_items`.`parent_id` is not null
3.59ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
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` asc
1.33ms/app/Services/MenuService.php:85pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (249, 250) order by `menu_order` asc
4.71ms/app/Services/MenuService.php:85pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 248 and `menus_items`.`parent_id` is not null order by `menu_order` asc
1.11ms/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (249, 250) order by `menu_order` asc
3.07ms/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 249 and `menus_items`.`parent_id` is not null
1.04ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 250 and `menus_items`.`parent_id` is not null
8.57ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
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` asc
1.77ms/app/Services/MenuService.php:85pickMetadata | |
---|---|
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` asc
960μs/app/Services/MenuService.php:85pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (254, 255, 256) order by `menu_order` asc
690μs/app/Services/MenuService.php:85pickMetadata | |
---|---|
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
1.61ms/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (254, 255, 256) order by `menu_order` asc
1.16ms/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 254 and `menus_items`.`parent_id` is not null
1.08ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 255 and `menus_items`.`parent_id` is not null
1.16ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 256 and `menus_items`.`parent_id` is not null
760μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menus` where `menu_type` = '0' limit 1
290μ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` = 5 and `parent_id` = '0' order by `menu_order` asc
6.92ms/app/Models/Menu.php:72pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (243, 244, 248, 251, 252) order by `menu_order` asc
440μs/app/Models/Menu.php:72pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (245, 246, 247, 249, 250, 254, 255, 256) order by `menu_order` asc
330μs/app/Models/Menu.php:72pickMetadata | |
---|---|
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` asc
410μs/app/Services/MenuService.php:131pickMetadata | |
---|---|
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` asc
400μs/app/Services/MenuService.php:131pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (245, 246, 247) order by `menu_order` asc
1.73ms/app/Services/MenuService.php:131pickMetadata | |
---|---|
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
1.36ms/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (245, 246, 247) order by `menu_order` asc
4.77ms/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 245 and `menus_items`.`parent_id` is not null
1.12ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 246 and `menus_items`.`parent_id` is not null
1.76ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 247 and `menus_items`.`parent_id` is not null
890μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
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` asc
2.39ms/app/Services/MenuService.php:131pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (249, 250) order by `menu_order` asc
1.56ms/app/Services/MenuService.php:131pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 248 and `menus_items`.`parent_id` is not null order by `menu_order` asc
10.17ms/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (249, 250) order by `menu_order` asc
2.09ms/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 249 and `menus_items`.`parent_id` is not null
13.2ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 250 and `menus_items`.`parent_id` is not null
14.53ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
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` asc
1ms/app/Services/MenuService.php:131pickMetadata | |
---|---|
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` asc
3.32ms/app/Services/MenuService.php:131pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (254, 255, 256) order by `menu_order` asc
1.3ms/app/Services/MenuService.php:131pickMetadata | |
---|---|
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
2.98ms/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (254, 255, 256) order by `menu_order` asc
310μs/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 254 and `menus_items`.`parent_id` is not null
270μ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` = 255 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` = 256 and `menus_items`.`parent_id` is not null
1.21ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
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` asc
5.29ms/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` = 5 and `settings_countries`.`id` = 229 order by `settings_languages`.`order_num` asc
740μs/app/Models/Language.php:192pickMetadata | |
---|---|
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` = 1
640μs/app/Models/Post.php:386pickMetadata | |
---|---|
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 0
7.47ms/app/Models/Post.php:386pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus` where `menu_type` = '1' limit 1
340μ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` = 5 and `parent_id` = '0' order by `menu_order` asc
920μs/app/Models/Menu.php:72pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (222, 226, 232, 238) order by `menu_order` asc
6.03ms/app/Models/Menu.php:72pickMetadata | |
---|---|
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` asc
1.4ms/app/Models/Menu.php:72pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 222 and `menus_items`.`parent_id` is not null order by `menu_order` asc
6.91ms/app/Services/MenuService.php:433pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (223, 224, 225) order by `menu_order` asc
9.49ms/app/Services/MenuService.php:433pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 226 and `menus_items`.`parent_id` is not null order by `menu_order` asc
520μs/app/Services/MenuService.php:433pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (227, 228, 229, 230, 231) order by `menu_order` asc
310μs/app/Services/MenuService.php:433pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 232 and `menus_items`.`parent_id` is not null order by `menu_order` asc
330μs/app/Services/MenuService.php:433pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (233, 235, 237, 457) order by `menu_order` asc
270μs/app/Services/MenuService.php:433pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 238 and `menus_items`.`parent_id` is not null order by `menu_order` asc
320μs/app/Services/MenuService.php:433pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (239, 240, 241, 242) order by `menu_order` asc
1.18ms/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` = 5 group by `slug` order by `settings_languages`.`order_num` asc
1.71ms/app/Models/Language.php:166pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `settings_countries_trans` where `language_id` = 5 and `country_id` = 229
630μ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` = 5 group by `settings_countries_trans`.`country_name`, `settings_countries_trans`.`country_id` order by `settings_countries`.`priority` asc, `settings_countries_trans`.`country_name` asc
48.1ms/app/Models/Country.php:69pickMetadata | |
---|---|
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` asc
8.29ms/app/Models/Occupation.php:48pickMetadata | |
---|---|
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" => "bf6a8fce45cb75c11f45cdf16cf3526dcd40fa1e47bf699c49cd4c262d18fc23" "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.145.0.168" "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" => "34083" "REDIRECT_URL" => "/ua/robochi-miscya/budivnictvo" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/ua/robochi-miscya/budivnictvo" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1745714228.777 "REQUEST_TIME" => 1745714228 ]
[]
0 of 0array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Sun, 27 Apr 2025 00:37:08 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjVlQ2dwemQ1S0FvY20xcDBrTTFhcEE9PSIsInZhbHVlIjoiZnl5RlJhWkdnM041RlZNZnNQVkJ1VkZCUVVBdElmeTdyNzNBUnRKTnhVUnV2TnZtZ2JIbEhUN3E2eEpWb1wvTG8iLCJtYWMiOiIwOWViZWQ1NGNhYTAwNWJkMzNjZTZmN2Y0ZmFmNDZiNTE3YjY5N2JlZDJjZGEwNWQxZmZhOTVmNWQ2OTQ4MjAwIn0%3D; expires=Sun, 27-Apr-2025 20:37:09 GMT; Max-Age=72000; path=/ ◀XSRF-TOKEN=eyJpdiI6IjVlQ2dwemQ1S0FvY20xcDBrTTFhcEE9PSIsInZhbHVlIjoiZnl5RlJhWkdnM041RlZNZnNQVkJ1VkZCUVVBdElmeTdyNzNBUnRKTnhVUnV2TnZtZ2JIbEhUN3E2eEpWb1wvTG8iLCJtY ▶" 1 => "pickjobs_session=eyJpdiI6Ik82OWZxMHBPeUlUa2djcVU5bE1pRWc9PSIsInZhbHVlIjoiTzJLaXg2eVZsSE42ckpEd05kcjJ5dUxvUEIzNk1Ic2FqcGFPcmZQYmpzVzBxR1pQT3RoWEpRQWEzWXlhWnJXUiIsIm1hYyI6Ijk3ZTRiZmJiYTg0NzdlOWQ0NTg2ZGU0Yjg2ZDJkNWIxZTM0MTAzYmI2MzQxNmY5N2JjYjdjYTcyYjYwMDk2YWIifQ%3D%3D; expires=Sun, 27-Apr-2025 20:37:09 GMT; Max-Age=72000; path=/; httponly ◀pickjobs_session=eyJpdiI6Ik82OWZxMHBPeUlUa2djcVU5bE1pRWc9PSIsInZhbHVlIjoiTzJLaXg2eVZsSE42ckpEd05kcjJ5dUxvUEIzNk1Ic2FqcGFPcmZQYmpzVzBxR1pQT3RoWEpRQWEzWXlhWnJXUiI ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjVlQ2dwemQ1S0FvY20xcDBrTTFhcEE9PSIsInZhbHVlIjoiZnl5RlJhWkdnM041RlZNZnNQVkJ1VkZCUVVBdElmeTdyNzNBUnRKTnhVUnV2TnZtZ2JIbEhUN3E2eEpWb1wvTG8iLCJtYWMiOiIwOWViZWQ1NGNhYTAwNWJkMzNjZTZmN2Y0ZmFmNDZiNTE3YjY5N2JlZDJjZGEwNWQxZmZhOTVmNWQ2OTQ4MjAwIn0%3D; expires=Sun, 27-Apr-2025 20:37:09 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjVlQ2dwemQ1S0FvY20xcDBrTTFhcEE9PSIsInZhbHVlIjoiZnl5RlJhWkdnM041RlZNZnNQVkJ1VkZCUVVBdElmeTdyNzNBUnRKTnhVUnV2TnZtZ2JIbEhUN3E2eEpWb1wvTG8iLCJtY ▶" 1 => "pickjobs_session=eyJpdiI6Ik82OWZxMHBPeUlUa2djcVU5bE1pRWc9PSIsInZhbHVlIjoiTzJLaXg2eVZsSE42ckpEd05kcjJ5dUxvUEIzNk1Ic2FqcGFPcmZQYmpzVzBxR1pQT3RoWEpRQWEzWXlhWnJXUiIsIm1hYyI6Ijk3ZTRiZmJiYTg0NzdlOWQ0NTg2ZGU0Yjg2ZDJkNWIxZTM0MTAzYmI2MzQxNmY5N2JjYjdjYTcyYjYwMDk2YWIifQ%3D%3D; expires=Sun, 27-Apr-2025 20:37:09 GMT; path=/; httponly ◀pickjobs_session=eyJpdiI6Ik82OWZxMHBPeUlUa2djcVU5bE1pRWc9PSIsInZhbHVlIjoiTzJLaXg2eVZsSE42ckpEd05kcjJ5dUxvUEIzNk1Ic2FqcGFPcmZQYmpzVzBxR1pQT3RoWEpRQWEzWXlhWnJXUiI ▶" ] ]
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" => "2bUzP2pNoY3588bFkHcFE5vRVlf0Dhi9X4rGHXE2" "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/budivnictvo" ] "PHPDEBUGBAR_STACK_DATA" => [] ]