Croatia
Bosnia and Herzegovina
Serbia
Crna Gora
North Macedonia
Ukraine
Albania
Kosovo
Austria
Deutschland
SwitzerlandTips for employers
Download free PickJobs mobile app on your Android or iOS device, via Google Play Store or App Store and gain access anywhere, anytime.
Final recipient of the financial instrument co-financed from the European Regional Development Fund under the Operational Program "Competitiveness and Cohesion"
For the best user experience and full funcionality of all site features, PickJobs is using cookies and similar technologies. If you continue to use this site we will consider that you have accepted and agreed with our Cookie Policy. Read more about Cookie Policy
Download free PickJobs mobile app on your Android or iOS device, via Google Play Store or App Store and gain access anywhere, anytime.
| 1 x Application (76.6%) | 76.37ms |
| 1 x Booting (23.28%) | 23.21ms |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 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 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 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 | |
| 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 | |
select count(*) as aggregate from `tags` left join `posts_tags` on `posts_tags`.`tag_id` = `tags`.`id` left join `posts` on `posts`.`id` = `posts_tags`.`post_id` left join `categories` on `categories`.`id` = `posts`.`category_id` left join `categories_trans` on `categories`.`id` = `categories_trans`.`category_id` where `tags`.`tag_name` = 'skills' and `posts_tags`.`post_id` <> 0 and `posts`.`language_id` = 1 and `posts`.`is_published` = 1 and `categories`.`type` <> 'faq' and `categories_trans`.`language_id` = 1 group by `posts`.`id`610μs/app/Models/Tag.php:42pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select *, `posts`.`slug` as `post_slug`, `categories_trans`.`slug` as `category_slug`, `posts`.`title` as `post_title`, `categories_trans`.`title` as `category_title`, `posts`.`id` as `post_id`, `posts`.`image` as `post_image` from `tags` left join `posts_tags` on `posts_tags`.`tag_id` = `tags`.`id` left join `posts` on `posts`.`id` = `posts_tags`.`post_id` left join `categories` on `categories`.`id` = `posts`.`category_id` left join `categories_trans` on `categories`.`id` = `categories_trans`.`category_id` where `tags`.`tag_name` = 'skills' and `posts_tags`.`post_id` <> 0 and `posts`.`language_id` = 1 and `posts`.`is_published` = 1 and `categories`.`type` <> 'faq' and `categories_trans`.`language_id` = 1 group by `posts`.`id` order by `is_featured` desc, `published_at` desc limit 12 offset 0970μs/app/Models/Tag.php:42pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus` where `menu_type` = '0' limit 1250μs/app/Services/MenuService.php:75pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`menu_id` = 2 and `menus_items`.`menu_id` is not null and `language_id` = 1 and `parent_id` = '0' order by `menu_order` asc500μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (7, 8, 9, 10, 11) order by `menu_order` asc360μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (18, 20, 21, 37, 77, 78, 79, 122) order by `menu_order` asc290μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 7 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc290μs/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 8 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc310μs/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (77, 78, 79) order by `menu_order` asc240μs/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 8 and `menus_items`.`parent_id` is not null order by `menu_order` asc280μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (77, 78, 79) order by `menu_order` asc340μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 77 and `menus_items`.`parent_id` is not null230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 78 and `menus_items`.`parent_id` is not null230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 79 and `menus_items`.`parent_id` is not null220μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 9 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc280μs/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (20, 21) order by `menu_order` asc240μs/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 9 and `menus_items`.`parent_id` is not null order by `menu_order` asc310μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (20, 21) order by `menu_order` asc240μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 21 and `menus_items`.`parent_id` is not null210μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 20 and `menus_items`.`parent_id` is not null210μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 10 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc270μs/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 11 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc290μs/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (18, 37, 122) order by `menu_order` asc260μs/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 11 and `menus_items`.`parent_id` is not null order by `menu_order` asc280μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (18, 37, 122) order by `menu_order` asc240μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 37 and `menus_items`.`parent_id` is not null210μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 18 and `menus_items`.`parent_id` is not null230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 122 and `menus_items`.`parent_id` is not null220μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus` where `menu_type` = '0' limit 1230μs/app/Services/MenuService.php:121pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`menu_id` = 2 and `menus_items`.`menu_id` is not null and `language_id` = 1 and `parent_id` = '0' order by `menu_order` asc480μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (7, 8, 9, 10, 11) order by `menu_order` asc370μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (18, 20, 21, 37, 77, 78, 79, 122) order by `menu_order` asc310μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 7 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc260μs/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 8 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc270μs/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (77, 78, 79) order by `menu_order` asc250μs/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 8 and `menus_items`.`parent_id` is not null order by `menu_order` asc280μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (77, 78, 79) order by `menu_order` asc290μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 77 and `menus_items`.`parent_id` is not null220μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 78 and `menus_items`.`parent_id` is not null220μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 79 and `menus_items`.`parent_id` is not null220μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 9 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc280μs/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (20, 21) order by `menu_order` asc260μs/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 9 and `menus_items`.`parent_id` is not null order by `menu_order` asc280μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (20, 21) order by `menu_order` asc260μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 21 and `menus_items`.`parent_id` is not null220μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 20 and `menus_items`.`parent_id` is not null220μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 10 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc250μs/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 11 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc270μs/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (18, 37, 122) order by `menu_order` asc250μs/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 11 and `menus_items`.`parent_id` is not null order by `menu_order` asc280μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (18, 37, 122) order by `menu_order` asc230μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 37 and `menus_items`.`parent_id` is not null220μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 18 and `menus_items`.`parent_id` is not null240μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 122 and `menus_items`.`parent_id` is not null230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| 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` = 1 order by `settings_countries`.`priority` asc1.12ms/app/Models/Language.php:179pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `settings_languages` left join `settings_countries` on `settings_countries`.`id` = `settings_languages`.`country_id` left join `settings_countries_trans` on `settings_countries`.`id` = `settings_countries_trans`.`country_id` where `settings_languages`.`is_active` = 1 and `settings_countries_trans`.`language_id` = 1 and `settings_countries`.`id` = 232 order by `settings_languages`.`order_num` asc630μs/app/Models/Language.php:192pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus` where `menu_type` = '1' limit 1220μs/app/Services/MenuService.php:421pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`menu_id` = 3 and `menus_items`.`menu_id` is not null and `language_id` = 1 and `parent_id` = '0' order by `menu_order` asc480μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (1, 3, 24, 25) order by `menu_order` asc360μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (2, 4, 5, 6, 22, 23, 26, 27, 29, 30, 31, 32, 33, 34, 35, 455) order by `menu_order` asc270μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 1 and `menus_items`.`parent_id` is not null order by `menu_order` asc290μs/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (2, 22, 26) order by `menu_order` asc240μs/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 24 and `menus_items`.`parent_id` is not null order by `menu_order` asc290μs/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (31, 32, 33, 34, 35) order by `menu_order` asc270μs/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 25 and `menus_items`.`parent_id` is not null order by `menu_order` asc290μs/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (27, 29, 30, 455) order by `menu_order` asc260μs/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 3 and `menus_items`.`parent_id` is not null order by `menu_order` asc290μs/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (4, 5, 6, 23) order by `menu_order` asc250μs/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `settings_languages` left join `settings_countries` on `settings_countries`.`id` = `settings_languages`.`country_id` left join `settings_countries_trans` on `settings_countries`.`id` = `settings_countries_trans`.`country_id` where `settings_languages`.`is_active` = 1 and `settings_countries_trans`.`language_id` = 1 group by `slug` order by `settings_languages`.`order_num` asc900μs/app/Models/Language.php:166pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `settings_countries_trans` where `language_id` = 1 and `country_id` = 232350μs/app/Models/Country.php:53pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select settings_countries.*, settings_countries_trans.*, settings_countries_trans.country_name as CountryName from `settings_countries` left join `settings_countries_trans` on `settings_countries_trans`.`country_id` = `settings_countries`.`id` where `settings_countries`.`is_active` = 1 and `settings_countries_trans`.`language_id` = 1 group by `settings_countries_trans`.`country_name`, `settings_countries_trans`.`country_id` order by `settings_countries`.`priority` asc, `settings_countries_trans`.`country_name` asc6.31ms/app/Models/Country.php:69pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `settings_languages` where `slug` = 'hr' limit 1280μs/app/Models/Language.php:55pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `occupations`.*, coalesce(en_occupations_trans.occupation_name, hr_occupations_trans.occupation_name) as name, coalesce(en_occupations_trans.description, hr_occupations_trans.description) as description from `occupations` left join `occupations_trans` as `en_occupations_trans` on `en_occupations_trans`.`occupation_id` = `occupations`.`id` and `en_occupations_trans`.`language_id` = 1 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` asc1.4ms/app/Models/Occupation.php:48pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
200
[]
[]
0 of 0array:16 [▶ "authorization" => array:1 [▶ 0 => "" ] "host" => array:1 [▶ 0 => "dev.pick.jobs" ] "connection" => array:1 [▶ 0 => "keep-alive" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "sec-ch-ua" => array:1 [▶ 0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" ] "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" => "07c4985b9dd8bf970af9c407f350ab2cd184c6520308e9988e566bfe85406362" "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" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99"" "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.20.206.27" "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" => "59497" "REDIRECT_URL" => "/gb/tags/skills" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/gb/tags/skills" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1746309005.419 "REQUEST_TIME" => 1746309005 ]
[]
0 of 0array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Sat, 03 May 2025 21:50:05 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImhoN3ROV0xtV0lLWDVWNitielY5dEE9PSIsInZhbHVlIjoiWkJtVjhqQ3JOTHBVa25TeEhLTWhBZVI0cHhneGlHVjBNbWNSV2ljZTN3Mm4xZ1JqZ3V6cTFtOGY1dk12NFpYdCIsIm1hYyI6ImRmODg1M2YxNWQ3YWMyOWQwYmUzMTU3NGI4Nzg3ZjlkNjViNDA0YmIwODJhNzU4ZTNiYWFhM2ZjNTI2NzU4YmMifQ%3D%3D; expires=Sun, 04-May-2025 17:50:05 GMT; Max-Age=72000; path=/ ◀XSRF-TOKEN=eyJpdiI6ImhoN3ROV0xtV0lLWDVWNitielY5dEE9PSIsInZhbHVlIjoiWkJtVjhqQ3JOTHBVa25TeEhLTWhBZVI0cHhneGlHVjBNbWNSV2ljZTN3Mm4xZ1JqZ3V6cTFtOGY1dk12NFpYdCIsIm1hY ▶" 1 => "pickjobs_session=eyJpdiI6IjUzcFJcLzRWclduc3FpMG9OVHRCczBBPT0iLCJ2YWx1ZSI6IkF0QVl1R0ZTbTRabzhTZnl6WFwvcUk4ZkpwRjFrR0NOSU0xK1MyZ1VKaUFLeFE3VStod21WRFVEWGMyNW4wK3lvIiwibWFjIjoiMzRmNmIwZjdhMzc3MDc3N2Q1MjMwYjY4MzgzOWRkNjE1YjVmNjRiNGM0MmUxOTg2NzY3ZGE2NTMzMmU5Yjg1YSJ9; expires=Sun, 04-May-2025 17:50:05 GMT; Max-Age=72000; path=/; httponly ◀pickjobs_session=eyJpdiI6IjUzcFJcLzRWclduc3FpMG9OVHRCczBBPT0iLCJ2YWx1ZSI6IkF0QVl1R0ZTbTRabzhTZnl6WFwvcUk4ZkpwRjFrR0NOSU0xK1MyZ1VKaUFLeFE3VStod21WRFVEWGMyNW4wK3l ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImhoN3ROV0xtV0lLWDVWNitielY5dEE9PSIsInZhbHVlIjoiWkJtVjhqQ3JOTHBVa25TeEhLTWhBZVI0cHhneGlHVjBNbWNSV2ljZTN3Mm4xZ1JqZ3V6cTFtOGY1dk12NFpYdCIsIm1hYyI6ImRmODg1M2YxNWQ3YWMyOWQwYmUzMTU3NGI4Nzg3ZjlkNjViNDA0YmIwODJhNzU4ZTNiYWFhM2ZjNTI2NzU4YmMifQ%3D%3D; expires=Sun, 04-May-2025 17:50:05 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImhoN3ROV0xtV0lLWDVWNitielY5dEE9PSIsInZhbHVlIjoiWkJtVjhqQ3JOTHBVa25TeEhLTWhBZVI0cHhneGlHVjBNbWNSV2ljZTN3Mm4xZ1JqZ3V6cTFtOGY1dk12NFpYdCIsIm1hY ▶" 1 => "pickjobs_session=eyJpdiI6IjUzcFJcLzRWclduc3FpMG9OVHRCczBBPT0iLCJ2YWx1ZSI6IkF0QVl1R0ZTbTRabzhTZnl6WFwvcUk4ZkpwRjFrR0NOSU0xK1MyZ1VKaUFLeFE3VStod21WRFVEWGMyNW4wK3lvIiwibWFjIjoiMzRmNmIwZjdhMzc3MDc3N2Q1MjMwYjY4MzgzOWRkNjE1YjVmNjRiNGM0MmUxOTg2NzY3ZGE2NTMzMmU5Yjg1YSJ9; expires=Sun, 04-May-2025 17:50:05 GMT; path=/; httponly ◀pickjobs_session=eyJpdiI6IjUzcFJcLzRWclduc3FpMG9OVHRCczBBPT0iLCJ2YWx1ZSI6IkF0QVl1R0ZTbTRabzhTZnl6WFwvcUk4ZkpwRjFrR0NOSU0xK1MyZ1VKaUFLeFE3VStod21WRFVEWGMyNW4wK3l ▶" ] ]
0 of 0array:8 [▶ "currentLang" => App\Models\Language {#1417 ▶ +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" => 1 "slug" => "en" "country_id" => 232 "language_name" => "English" "currency" => "eur" "eur_conversion_rate" => "1.00" "conversion_date" => "2022-12-31 12:00:02" "order_num" => 0 "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" => 1 "slug" => "en" "country_id" => 232 "language_name" => "English" "currency" => "eur" "eur_conversion_rate" => "1.00" "conversion_date" => "2022-12-31 12:00:02" "order_num" => 0 "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" => "en" "autolang" => 1 "_flash" => array:2 [▶ "old" => [] "new" => [] ] "_token" => "FkgsQTifNHbOigZjuu7EJ80nRoByYU0OfVKjBJCj" "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/gb/tags/skills" ] "PHPDEBUGBAR_STACK_DATA" => [] ]