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 (82.66%) | 208.50ms |
1 x Booting (17.29%) | 43.62ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
select count(*) as aggregate from `posts` left join `categories` on `posts`.`category_id` = `categories`.`id` left join `categories_trans` on `categories`.`id` = `categories_trans`.`category_id` where `posts`.`language_id` = 9 and `categories_trans`.`language_id` = 9 and `categories`.`type` = 'blog' and `is_featured` = 1 and `is_published` = 1
1.46ms/app/Models/Post.php:654pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `posts`.*, `categories_trans`.`title` as `category_name`, `categories_trans`.`slug` as `categorySlug` from `posts` left join `categories` on `posts`.`category_id` = `categories`.`id` left join `categories_trans` on `categories`.`id` = `categories_trans`.`category_id` where `posts`.`language_id` = 9 and `categories_trans`.`language_id` = 9 and `categories`.`type` = 'blog' and `is_featured` = 1 and `is_published` = 1 order by `posts`.`published_at` desc limit 3 offset 0
1.62ms/app/Models/Post.php:654pickMetadata | |
---|---|
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-13 21:58:05' and (`banners`.`lasts_until` >= '2025-04-13 21:58:05' or `banners`.`lasts_until` = '0000-00-00 00:00:00') and (`banners`.`langs` like '%de%') and `banners`.`banner_position` LIKE 'landing%' order by RAND()
1.69ms/app/Repositories/BannerRepository.php:61pickMetadata | |
---|---|
Bindings |
|
Hints | |
Backtrace |
|
select * from `settings_languages` where `slug` = 'hr' limit 1
260μ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.38ms/app/Models/Occupation.php:136pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `occupations_trans` where `language_id` = 9 order by `occupation_name` asc
570μs/app/Http/Controllers/FrontEnd/FrontEndController.php:743pickMetadata | |
---|---|
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
3.22ms/app/Http/Controllers/FrontEnd/FrontEndController.php:744pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `occupations_trans` where `language_id` = 9 order by `occupation_name` asc
5.73ms/app/Providers/ViewServiceProvider.php:304pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus` where `menu_type` = '0' limit 1
2.78ms/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
1.11ms/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
360μs/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
1.17ms/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
950μ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
940μ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
1.02ms/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
610μ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
3.52ms/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
570μ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
780μs/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
1.08ms/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
900μ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
900μ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
2.46ms/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
440μ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
800μ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
1.95ms/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
3.45ms/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
770μs/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
900μ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
590μ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
600μ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
880μ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
1.81ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menus` where `menu_type` = '0' limit 1
1.81ms/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
1.21ms/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
2.11ms/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.33ms/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.34ms/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
800μ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
760μ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
940μ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
4.7ms/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
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` = 158 and `menus_items`.`parent_id` is not null
1.61ms/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
1.92ms/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
290μ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
240μ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
1.13ms/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
3.61ms/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
430μ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
830μ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
1.1ms/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
1.15ms/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
1.54ms/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
3.46ms/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
900μ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
870μ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
930μ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
910μ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
2.72ms/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` = 84 order by `settings_languages`.`order_num` asc
2.02ms/app/Models/Language.php:192pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus` where `menu_type` = '1' limit 1
320μ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
11.59ms/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
430μ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
370μs/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
230μ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
6.48ms/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
300μ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
310μ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
380μ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
330μ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
240μ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
3.59ms/app/Models/Language.php:166pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `settings_countries_trans` where `language_id` = 9 and `country_id` = 84
330μ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.09ms/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.46ms/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" => "8407bdfa4d50edeeaba2faa46dc0b50f7424166fd8d294225478743d9a2e5e9a" "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.138.200.26" "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" => "52114" "REDIRECT_URL" => "/de/arbeitsplatze/kategorien" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/de/arbeitsplatze/kategorien" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744574285.645 "REQUEST_TIME" => 1744574285 ]
[]
0 of 0array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Sun, 13 Apr 2025 19:58:05 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlBTSlpwYUVnTmxIbGxJK2twa3ZqQ2c9PSIsInZhbHVlIjoiQWlHMDFxckExWnArRHpcL2h4c0xuWXhmcmY3V21nU1FZUmNUZm1ZQXhSUGN1WUxhemZOVGVyVk9NUVlFQTZtRlciLCJtYWMiOiJkYTU2ZjE1MTg4YWI2NzJmNTJiZWFhNjUzMzkwNDkxNWE4MTJjYWQ0OWZlOWY5YTE2ODM0MmM2ZjEwNTlkZDFlIn0%3D; expires=Mon, 14-Apr-2025 15:58:05 GMT; Max-Age=72000; path=/ ◀XSRF-TOKEN=eyJpdiI6IlBTSlpwYUVnTmxIbGxJK2twa3ZqQ2c9PSIsInZhbHVlIjoiQWlHMDFxckExWnArRHpcL2h4c0xuWXhmcmY3V21nU1FZUmNUZm1ZQXhSUGN1WUxhemZOVGVyVk9NUVlFQTZtRlciLCJtY ▶" 1 => "pickjobs_session=eyJpdiI6IkNBTzgzTXVuSW9pRkdxOFZ2RWY5Mmc9PSIsInZhbHVlIjoiZlYyRUVCMGFScGRrUWJNVFBxcmJXZmdyMExod1BcL3FVc1E0NCs0NlI3WWF4eFV5NXczNTllMDJ2WHdzMTBcL2w1IiwibWFjIjoiMDdkYjZjZTc3MDFkOWE0ZGM5Nzk1NDJlMTU0Mjk0Y2FiOGViOTZkMzc0ZGJiN2EyYWM3M2QzNDFhNjMyZDEzYSJ9; expires=Mon, 14-Apr-2025 15:58:05 GMT; Max-Age=72000; path=/; httponly ◀pickjobs_session=eyJpdiI6IkNBTzgzTXVuSW9pRkdxOFZ2RWY5Mmc9PSIsInZhbHVlIjoiZlYyRUVCMGFScGRrUWJNVFBxcmJXZmdyMExod1BcL3FVc1E0NCs0NlI3WWF4eFV5NXczNTllMDJ2WHdzMTBcL2w ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IlBTSlpwYUVnTmxIbGxJK2twa3ZqQ2c9PSIsInZhbHVlIjoiQWlHMDFxckExWnArRHpcL2h4c0xuWXhmcmY3V21nU1FZUmNUZm1ZQXhSUGN1WUxhemZOVGVyVk9NUVlFQTZtRlciLCJtYWMiOiJkYTU2ZjE1MTg4YWI2NzJmNTJiZWFhNjUzMzkwNDkxNWE4MTJjYWQ0OWZlOWY5YTE2ODM0MmM2ZjEwNTlkZDFlIn0%3D; expires=Mon, 14-Apr-2025 15:58:05 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IlBTSlpwYUVnTmxIbGxJK2twa3ZqQ2c9PSIsInZhbHVlIjoiQWlHMDFxckExWnArRHpcL2h4c0xuWXhmcmY3V21nU1FZUmNUZm1ZQXhSUGN1WUxhemZOVGVyVk9NUVlFQTZtRlciLCJtY ▶" 1 => "pickjobs_session=eyJpdiI6IkNBTzgzTXVuSW9pRkdxOFZ2RWY5Mmc9PSIsInZhbHVlIjoiZlYyRUVCMGFScGRrUWJNVFBxcmJXZmdyMExod1BcL3FVc1E0NCs0NlI3WWF4eFV5NXczNTllMDJ2WHdzMTBcL2w1IiwibWFjIjoiMDdkYjZjZTc3MDFkOWE0ZGM5Nzk1NDJlMTU0Mjk0Y2FiOGViOTZkMzc0ZGJiN2EyYWM3M2QzNDFhNjMyZDEzYSJ9; expires=Mon, 14-Apr-2025 15:58:05 GMT; path=/; httponly ◀pickjobs_session=eyJpdiI6IkNBTzgzTXVuSW9pRkdxOFZ2RWY5Mmc9PSIsInZhbHVlIjoiZlYyRUVCMGFScGRrUWJNVFBxcmJXZmdyMExod1BcL3FVc1E0NCs0NlI3WWF4eFV5NXczNTllMDJ2WHdzMTBcL2w ▶" ] ]
0 of 0array:8 [▶ "currentLang" => App\Models\Language {#1398 ▶ +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" => "OtdDdrwiWrU7Lc5ZNZlVH5Psi1f2688FJFuN3blm" "defaultLang" => App\Models\Language {#1315 ▶ +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/de/arbeitsplatze/kategorien" ] "PHPDEBUGBAR_STACK_DATA" => [] ]