Endempfänger von Finanzierungsinstrument kofinanziert aus dem Europäischen Fonds für regionale Entwicklung im Rahmen des operationellen Programms „Wettbewerbsfähigkeit und Kohäsion“.
Für die beste Benutzererfahrung und volle Funktionalität aller Webseiteneigenschaften verwendet PickJobs Cookies und ähnliche Technologien. Wenn Sie fortsetzen diese Webseite zu nutzen, gehen wir davon aus, dass Sie unsere Cookies-Regeln akzeptieren und damit einverstanden sind. Lesen Sie mehr über Cookies-Richtlinie
1 x Application (86.01%) | 136.73ms |
1 x Booting (13.92%) | 22.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` = 'montage-und-installation' limit 1
390μs/app/Http/Controllers/FrontEnd/JobController.php:68pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `jobs_descriptions` where `slug` = 'montage-und-installation' limit 1
3.48ms/app/Http/Controllers/FrontEnd/JobController.php:78pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `jobs_descriptions` where `job_id` = 0 limit 1
260μs/app/Http/Controllers/FrontEnd/JobController.php:90pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `occupations_trans` where `occupations_trans`.`slug` = 'montage-und-installation'
410μs/app/Http/Controllers/FrontEnd/JobController.php:128pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `settings_languages` where `slug` = 'hr' limit 1
230μs/app/Models/Language.php:55pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select `occupations`.`id`, `occupations`.`parent_id`, coalesce(de_occupations_trans.occupation_name, hr_occupations_trans.occupation_name) as name from `occupations` left join `occupations_trans` as `de_occupations_trans` on `de_occupations_trans`.`occupation_id` = `occupations`.`id` and `de_occupations_trans`.`language_id` = 9 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.23ms/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-17 23:10:21' and (`banners`.`lasts_until` >= '2025-04-17 23:10:21' or `banners`.`lasts_until` = '0000-00-00 00:00:00') and (`banners`.`langs` like '%de%') and `banners`.`banner_position` LIKE 'blog%' order by RAND()
780μs/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
7.25ms/app/Http/Controllers/FrontEnd/JobController.php:185pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menus` where `menu_type` = '0' limit 1
240μ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` = 9 and `parent_id` = '0' order by `menu_order` asc
490μs/app/Models/Menu.php:72pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (155, 156, 160, 163, 164) order by `menu_order` asc
990μs/app/Models/Menu.php:72pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (157, 158, 159, 161, 162, 166, 167, 168) order by `menu_order` asc
1.02ms/app/Models/Menu.php:72pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 155 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc
2.16ms/app/Services/MenuService.php:85pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 156 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc
290μs/app/Services/MenuService.php:85pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (157, 158, 159) order by `menu_order` asc
250μs/app/Services/MenuService.php:85pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 156 and `menus_items`.`parent_id` is not null order by `menu_order` asc
280μs/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (157, 158, 159) 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` = 157 and `menus_items`.`parent_id` is not null
1.23ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 158 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` = 159 and `menus_items`.`parent_id` is not null
2.5ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 160 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` in (161, 162) order by `menu_order` asc
230μs/app/Services/MenuService.php:85pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 160 and `menus_items`.`parent_id` is not null order by `menu_order` asc
260μs/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (161, 162) order by `menu_order` asc
240μs/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 161 and `menus_items`.`parent_id` is not null
1.81ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 162 and `menus_items`.`parent_id` is not null
210μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 163 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc
240μs/app/Services/MenuService.php:85pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 164 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` in (166, 167, 168) order by `menu_order` asc
1.98ms/app/Services/MenuService.php:85pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 164 and `menus_items`.`parent_id` is not null order by `menu_order` asc
270μs/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (166, 167, 168) order by `menu_order` asc
230μs/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 166 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` = 167 and `menus_items`.`parent_id` is not null
2.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` = 168 and `menus_items`.`parent_id` is not null
210μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menus` where `menu_type` = '0' limit 1
240μ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` = 9 and `parent_id` = '0' order by `menu_order` asc
510μs/app/Models/Menu.php:72pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (155, 156, 160, 163, 164) order by `menu_order` asc
720μs/app/Models/Menu.php:72pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (157, 158, 159, 161, 162, 166, 167, 168) order by `menu_order` asc
3.62ms/app/Models/Menu.php:72pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 155 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc
260μs/app/Services/MenuService.php:131pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 156 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` in (157, 158, 159) order by `menu_order` asc
240μs/app/Services/MenuService.php:131pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 156 and `menus_items`.`parent_id` is not null order by `menu_order` asc
280μs/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (157, 158, 159) order by `menu_order` asc
240μs/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 157 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` = 158 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` = 159 and `menus_items`.`parent_id` is not null
3.51ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 160 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` in (161, 162) order by `menu_order` asc
230μs/app/Services/MenuService.php:131pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 160 and `menus_items`.`parent_id` is not null order by `menu_order` asc
260μs/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (161, 162) order by `menu_order` asc
230μs/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 161 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` = 162 and `menus_items`.`parent_id` is not null
200μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 163 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` = 164 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc
3.8ms/app/Services/MenuService.php:131pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (166, 167, 168) order by `menu_order` asc
250μs/app/Services/MenuService.php:131pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 164 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 (166, 167, 168) order by `menu_order` asc
290μs/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 166 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` = 167 and `menus_items`.`parent_id` is not null
400μ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` = 168 and `menus_items`.`parent_id` is not null
260μs/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` = 9 order by `settings_countries`.`priority` asc
4.05ms/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` = 9 and `settings_countries`.`id` = 214 order by `settings_languages`.`order_num` asc
580μ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` = 9 and `categories_trans`.`language_id` = 9 and `posts`.`is_featured` = 1 and `is_published` = 1
1.1ms/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` = 9 and `categories_trans`.`language_id` = 9 and `posts`.`is_featured` = 1 and `is_published` = 1 order by `posts`.`created_at` desc limit 4 offset 0
5.47ms/app/Models/Post.php:386pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus` where `menu_type` = '1' limit 1
270μ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` = 9 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 (134, 138, 144, 150) order by `menu_order` asc
360μs/app/Models/Menu.php:72pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (135, 136, 137, 139, 140, 141, 142, 143, 145, 147, 149, 151, 152, 153, 154, 460) order by `menu_order` asc
1.02ms/app/Models/Menu.php:72pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 134 and `menus_items`.`parent_id` is not null order by `menu_order` asc
300μs/app/Services/MenuService.php:433pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (135, 136, 137) order by `menu_order` asc
260μs/app/Services/MenuService.php:433pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 138 and `menus_items`.`parent_id` is not null order by `menu_order` asc
290μs/app/Services/MenuService.php:433pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (139, 140, 141, 142, 143) order by `menu_order` asc
230μs/app/Services/MenuService.php:433pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 144 and `menus_items`.`parent_id` is not null order by `menu_order` asc
290μs/app/Services/MenuService.php:433pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (145, 147, 149, 460) order by `menu_order` asc
250μs/app/Services/MenuService.php:433pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 150 and `menus_items`.`parent_id` is not null order by `menu_order` asc
290μs/app/Services/MenuService.php:433pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (151, 152, 153, 154) 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` = 9 group by `slug` order by `settings_languages`.`order_num` asc
1.06ms/app/Models/Language.php:166pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `settings_countries_trans` where `language_id` = 9 and `country_id` = 84
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` = 9 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.39ms/app/Models/Country.php:69pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `occupations`.*, coalesce(de_occupations_trans.occupation_name, hr_occupations_trans.occupation_name) as name, coalesce(de_occupations_trans.description, hr_occupations_trans.description) as description from `occupations` left join `occupations_trans` as `de_occupations_trans` on `de_occupations_trans`.`occupation_id` = `occupations`.`id` and `de_occupations_trans`.`language_id` = 9 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.47ms/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" => "b8cb259c7ab49af745550af6dc66950dbf611acaf8f20ca7efba5ec9667b6434" "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.144.31.171" "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" => "58268" "REDIRECT_URL" => "/ch/arbeitsplatze/montage-und-installation" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/ch/arbeitsplatze/montage-und-installation" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744924221.021 "REQUEST_TIME" => 1744924221 ]
[]
0 of 0array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Thu, 17 Apr 2025 21:10:21 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjhcL3hKbisxaUR2bEMzT0NHeGNDWUN3PT0iLCJ2YWx1ZSI6IkNIRzhSZFVPVm1IcVwvKzFEbjNcL3A3WDhQUCtvdzMzR0QyVUZKeURLNmpOdmNGWHo1K1FJeFVcL1orbHNaSGtIRWUiLCJtYWMiOiJlNzU0MDVkN2Y5M2U4YjgzMTkxNDQyNmI1NDY0NDhhY2YwN2FmMDUwYTI2YTk2ZGVlMTZlNmYxYzE0N2MyNjU3In0%3D; expires=Fri, 18-Apr-2025 17:10:21 GMT; Max-Age=72000; path=/ ◀XSRF-TOKEN=eyJpdiI6IjhcL3hKbisxaUR2bEMzT0NHeGNDWUN3PT0iLCJ2YWx1ZSI6IkNIRzhSZFVPVm1IcVwvKzFEbjNcL3A3WDhQUCtvdzMzR0QyVUZKeURLNmpOdmNGWHo1K1FJeFVcL1orbHNaSGtIRWUiL ▶" 1 => "pickjobs_session=eyJpdiI6ImVZclZkMEdTNHpyQlhCWjM2eHF4RXc9PSIsInZhbHVlIjoiOFVrT1wvOVwvVENnM0ZrcHcxWGNKOXl0WU1McWxWRGNKTk5pZjdEYWFaeWJoUkhaN2dVQlhFQjgyemd4XC9YSlQwWSIsIm1hYyI6ImQ0YzRlZGNlNzdhNjYzZGNmMTc4YjY5N2UwZmZhZDJkOWJiNGY1MWJmZTI0ZjYxYWE1YTI4MTMyMGY1YzI3MDAifQ%3D%3D; expires=Fri, 18-Apr-2025 17:10:21 GMT; Max-Age=72000; path=/; httponly ◀pickjobs_session=eyJpdiI6ImVZclZkMEdTNHpyQlhCWjM2eHF4RXc9PSIsInZhbHVlIjoiOFVrT1wvOVwvVENnM0ZrcHcxWGNKOXl0WU1McWxWRGNKTk5pZjdEYWFaeWJoUkhaN2dVQlhFQjgyemd4XC9YSlQ ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IjhcL3hKbisxaUR2bEMzT0NHeGNDWUN3PT0iLCJ2YWx1ZSI6IkNIRzhSZFVPVm1IcVwvKzFEbjNcL3A3WDhQUCtvdzMzR0QyVUZKeURLNmpOdmNGWHo1K1FJeFVcL1orbHNaSGtIRWUiLCJtYWMiOiJlNzU0MDVkN2Y5M2U4YjgzMTkxNDQyNmI1NDY0NDhhY2YwN2FmMDUwYTI2YTk2ZGVlMTZlNmYxYzE0N2MyNjU3In0%3D; expires=Fri, 18-Apr-2025 17:10:21 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IjhcL3hKbisxaUR2bEMzT0NHeGNDWUN3PT0iLCJ2YWx1ZSI6IkNIRzhSZFVPVm1IcVwvKzFEbjNcL3A3WDhQUCtvdzMzR0QyVUZKeURLNmpOdmNGWHo1K1FJeFVcL1orbHNaSGtIRWUiL ▶" 1 => "pickjobs_session=eyJpdiI6ImVZclZkMEdTNHpyQlhCWjM2eHF4RXc9PSIsInZhbHVlIjoiOFVrT1wvOVwvVENnM0ZrcHcxWGNKOXl0WU1McWxWRGNKTk5pZjdEYWFaeWJoUkhaN2dVQlhFQjgyemd4XC9YSlQwWSIsIm1hYyI6ImQ0YzRlZGNlNzdhNjYzZGNmMTc4YjY5N2UwZmZhZDJkOWJiNGY1MWJmZTI0ZjYxYWE1YTI4MTMyMGY1YzI3MDAifQ%3D%3D; expires=Fri, 18-Apr-2025 17:10:21 GMT; path=/; httponly ◀pickjobs_session=eyJpdiI6ImVZclZkMEdTNHpyQlhCWjM2eHF4RXc9PSIsInZhbHVlIjoiOFVrT1wvOVwvVENnM0ZrcHcxWGNKOXl0WU1McWxWRGNKTk5pZjdEYWFaeWJoUkhaN2dVQlhFQjgyemd4XC9YSlQ ▶" ] ]
0 of 0array:8 [▶ "currentLang" => App\Models\Language {#1406 ▶ +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" => 9 "slug" => "de" "country_id" => 84 "language_name" => "Deutsch" "currency" => "eur" "eur_conversion_rate" => "1.00" "conversion_date" => "2022-12-31 12:00:02" "order_num" => 9 "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" => 9 "slug" => "de" "country_id" => 84 "language_name" => "Deutsch" "currency" => "eur" "eur_conversion_rate" => "1.00" "conversion_date" => "2022-12-31 12:00:02" "order_num" => 9 "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" => "de" "autolang" => 1 "_flash" => array:2 [▶ "old" => [] "new" => [] ] "_token" => "DuS6QnRicXg94C9SiXwIGS8CdJleebdfaEDyWO7t" "defaultLang" => App\Models\Language {#1405 ▶ +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/ch/arbeitsplatze/montage-und-installation" ] "PHPDEBUGBAR_STACK_DATA" => [] ]