Хрватска
Босна и Херцеговина
Србија
Црна Гора
Украина
Албанија
Косово
Австрија
Германија
Швајцарија
Обединдето КралствоСовети за работодавците
Преземете ја бесплатната апликација за мобилни телефони PickJobs на вашиот Android или iOS уред, преку Google Play Store или App Store и добијте пристап до каде било, во кое било време.
Krajnji primatelj financijskog instrumenta sufinanciranog iz Europskog fonda za regionalni razvoj u sklopu Operativnog programa “Konkurentnost i kohezija”
За најдобро корисничко искуство и целосна функционалност на сите одлики на веб-страницата, PickJobs користи колачиња и слични технологии. Ако продолжите да ја користите оваа страница, ќе сметаме дека сте ги прифатиле и ја почитувате нашата политика за колачиња. Прочитајте повеќе за Политика за колачиња
Преземете ја бесплатната апликација за мобилни телефони PickJobs на вашиот Android или iOS уред, преку Google Play Store или App Store и добијте пристап до каде било, во кое било време.
| 1 x Application (76.39%) | 83.70ms |
| 1 x Booting (23.49%) | 25.74ms |
| 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` = 'тренер' and `posts_tags`.`post_id` <> 0 and `posts`.`language_id` = 6 and `posts`.`is_published` = 1 and `categories`.`type` <> 'faq' and `categories_trans`.`language_id` = 6 group by `posts`.`id`720μ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` = 'тренер' and `posts_tags`.`post_id` <> 0 and `posts`.`language_id` = 6 and `posts`.`is_published` = 1 and `categories`.`type` <> 'faq' and `categories_trans`.`language_id` = 6 group by `posts`.`id` order by `is_featured` desc, `published_at` desc limit 12 offset 01.14ms/app/Models/Tag.php:42pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus` where `menu_type` = '0' limit 1270μ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` = 6 and `parent_id` = '0' order by `menu_order` asc540μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (376, 377, 381, 384, 385) order by `menu_order` asc340μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (378, 379, 380, 382, 383, 386, 387, 389) order by `menu_order` asc270μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 376 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` = 377 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc300μs/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (378, 379, 380) order by `menu_order` asc260μs/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 377 and `menus_items`.`parent_id` is not null order by `menu_order` asc290μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (378, 379, 380) order by `menu_order` asc310μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 378 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` = 379 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` = 380 and `menus_items`.`parent_id` is not null230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 381 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 (382, 383) order by `menu_order` asc250μs/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 381 and `menus_items`.`parent_id` is not null order by `menu_order` asc320μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (382, 383) order by `menu_order` asc270μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 382 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` = 383 and `menus_items`.`parent_id` is not null250μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 384 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc260μs/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 385 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc300μs/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (386, 387, 389) order by `menu_order` asc250μs/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 385 and `menus_items`.`parent_id` is not null order by `menu_order` asc290μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (386, 387, 389) order by `menu_order` asc250μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 386 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` = 387 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` = 389 and `menus_items`.`parent_id` is not null240μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus` where `menu_type` = '0' limit 1250μ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` = 6 and `parent_id` = '0' order by `menu_order` asc520μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (376, 377, 381, 384, 385) order by `menu_order` asc350μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (378, 379, 380, 382, 383, 386, 387, 389) order by `menu_order` asc270μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 376 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` = 377 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc290μs/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (378, 379, 380) order by `menu_order` asc250μs/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 377 and `menus_items`.`parent_id` is not null order by `menu_order` asc290μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (378, 379, 380) order by `menu_order` asc250μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 378 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` = 379 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` = 380 and `menus_items`.`parent_id` is not null250μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 381 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc310μs/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (382, 383) order by `menu_order` asc250μs/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 381 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 (382, 383) order by `menu_order` asc250μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 382 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` = 383 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` = 384 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` = 385 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc290μs/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (386, 387, 389) order by `menu_order` asc250μs/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 385 and `menus_items`.`parent_id` is not null order by `menu_order` asc290μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (386, 387, 389) order by `menu_order` asc250μs/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 386 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` = 387 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` = 389 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` = 6 order by `settings_countries`.`priority` asc1.1ms/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` = 6 and `settings_countries`.`id` = 230 order by `settings_languages`.`order_num` asc620μs/app/Models/Language.php:192pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus` where `menu_type` = '1' limit 1250μ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` = 6 and `parent_id` = '0' order by `menu_order` asc520μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (318, 322, 328, 334) order by `menu_order` asc390μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (319, 320, 321, 323, 324, 325, 326, 327, 329, 331, 332, 335, 337, 339, 340, 458) order by `menu_order` asc400μs/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 318 and `menus_items`.`parent_id` is not null order by `menu_order` asc320μs/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (319, 320, 321) order by `menu_order` asc250μs/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 322 and `menus_items`.`parent_id` is not null order by `menu_order` asc310μs/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (323, 324, 325, 326, 327) order by `menu_order` asc260μs/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 328 and `menus_items`.`parent_id` is not null order by `menu_order` asc300μs/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (329, 331, 332, 458) order by `menu_order` asc260μs/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 334 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 (335, 337, 339, 340) 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` = 6 group by `slug` order by `settings_languages`.`order_num` asc1.01ms/app/Models/Language.php:166pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `settings_countries_trans` where `language_id` = 6 and `country_id` = 230380μ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` = 6 group by `settings_countries_trans`.`country_name`, `settings_countries_trans`.`country_id` order by `settings_countries`.`priority` asc, `settings_countries_trans`.`country_name` asc6.27ms/app/Models/Country.php:69pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `settings_languages` where `slug` = 'hr' limit 1290μs/app/Models/Language.php:55pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `occupations`.*, coalesce(mk_occupations_trans.occupation_name, hr_occupations_trans.occupation_name) as name, coalesce(mk_occupations_trans.description, hr_occupations_trans.description) as description from `occupations` left join `occupations_trans` as `mk_occupations_trans` on `mk_occupations_trans`.`occupation_id` = `occupations`.`id` and `mk_occupations_trans`.`language_id` = 6 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.5ms/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" => "0fff51a1cf9a6d8178b646d475b3b9e5f57397a415524b4666b420d13e8d2f53" "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" => "216.73.216.165" "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" => "44160" "REDIRECT_URL" => "/mk/tags/тренер" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/mk/tags/%D1%82%D1%80%D0%B5%D0%BD%D0%B5%D1%80" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1755657183.665 "REQUEST_TIME" => 1755657183 ]
[]
0 of 0array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Wed, 20 Aug 2025 02:33:03 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkJnc2lQNUZmQ0d3OHpvUnpLb3RzU0E9PSIsInZhbHVlIjoiY0R1VUs5TllnYml4Q0V2SkpJY0lTc3ZxSDRBbkVucU1DR2xiSzdmbWNieG96UzNWTjdNVWRLemlyS2VNakdwTiIsIm1hYyI6ImYzODA2NDUzNWY2YjA1OWYzNjIzYTU1ZjAzNWFiMmExYmNiYTEzZjY0ZjI2MGJmNmI3YWRlYTI2MGVlZTE4NzUifQ%3D%3D; expires=Wed, 20-Aug-2025 22:33:03 GMT; Max-Age=72000; path=/ ◀XSRF-TOKEN=eyJpdiI6IkJnc2lQNUZmQ0d3OHpvUnpLb3RzU0E9PSIsInZhbHVlIjoiY0R1VUs5TllnYml4Q0V2SkpJY0lTc3ZxSDRBbkVucU1DR2xiSzdmbWNieG96UzNWTjdNVWRLemlyS2VNakdwTiIsIm1hY ▶" 1 => "pickjobs_session=eyJpdiI6Im1lUzdzWEpQZ0VEQ3dcL2ppaHFnNCtnPT0iLCJ2YWx1ZSI6IlMxYkhYdCtjamRkYkljb1VYOHJ5RTNYMVFjSFlVeUZwVHJOUWxoRDdsOXczYUR6V0llU0NCSGNFaWpXUGU2ZGsiLCJtYWMiOiI1NzFlMmRlOThhM2MxYTU4MmExNzBhMWU4NWU4NGFhZmQxMzFkYmJjMDViYzg4NzA3NDM0MDJlNzI0ZmM1NDAxIn0%3D; expires=Wed, 20-Aug-2025 22:33:03 GMT; Max-Age=72000; path=/; httponly ◀pickjobs_session=eyJpdiI6Im1lUzdzWEpQZ0VEQ3dcL2ppaHFnNCtnPT0iLCJ2YWx1ZSI6IlMxYkhYdCtjamRkYkljb1VYOHJ5RTNYMVFjSFlVeUZwVHJOUWxoRDdsOXczYUR6V0llU0NCSGNFaWpXUGU2ZGs ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkJnc2lQNUZmQ0d3OHpvUnpLb3RzU0E9PSIsInZhbHVlIjoiY0R1VUs5TllnYml4Q0V2SkpJY0lTc3ZxSDRBbkVucU1DR2xiSzdmbWNieG96UzNWTjdNVWRLemlyS2VNakdwTiIsIm1hYyI6ImYzODA2NDUzNWY2YjA1OWYzNjIzYTU1ZjAzNWFiMmExYmNiYTEzZjY0ZjI2MGJmNmI3YWRlYTI2MGVlZTE4NzUifQ%3D%3D; expires=Wed, 20-Aug-2025 22:33:03 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkJnc2lQNUZmQ0d3OHpvUnpLb3RzU0E9PSIsInZhbHVlIjoiY0R1VUs5TllnYml4Q0V2SkpJY0lTc3ZxSDRBbkVucU1DR2xiSzdmbWNieG96UzNWTjdNVWRLemlyS2VNakdwTiIsIm1hY ▶" 1 => "pickjobs_session=eyJpdiI6Im1lUzdzWEpQZ0VEQ3dcL2ppaHFnNCtnPT0iLCJ2YWx1ZSI6IlMxYkhYdCtjamRkYkljb1VYOHJ5RTNYMVFjSFlVeUZwVHJOUWxoRDdsOXczYUR6V0llU0NCSGNFaWpXUGU2ZGsiLCJtYWMiOiI1NzFlMmRlOThhM2MxYTU4MmExNzBhMWU4NWU4NGFhZmQxMzFkYmJjMDViYzg4NzA3NDM0MDJlNzI0ZmM1NDAxIn0%3D; expires=Wed, 20-Aug-2025 22:33:03 GMT; path=/; httponly ◀pickjobs_session=eyJpdiI6Im1lUzdzWEpQZ0VEQ3dcL2ppaHFnNCtnPT0iLCJ2YWx1ZSI6IlMxYkhYdCtjamRkYkljb1VYOHJ5RTNYMVFjSFlVeUZwVHJOUWxoRDdsOXczYUR6V0llU0NCSGNFaWpXUGU2ZGs ▶" ] ]
0 of 0array:8 [▶ "currentLang" => App\Models\Language {#1425 ▶ +timestamps: false #fillable: array:3 [▶ 0 => "slug" 1 => "language_name" 2 => "country_id" ] #table: "settings_languages" #connection: "mysql" #primaryKey: "id" #keyType: "int" +incrementing: true #with: [] #withCount: [] #perPage: 15 +exists: true +wasRecentlyCreated: false #attributes: array:12 [▶ "id" => 6 "slug" => "mk" "country_id" => 230 "language_name" => "Македонски" "currency" => "mkd" "eur_conversion_rate" => "61.61" "conversion_date" => "2021-04-23 00:00:04" "order_num" => 6 "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" => 6 "slug" => "mk" "country_id" => 230 "language_name" => "Македонски" "currency" => "mkd" "eur_conversion_rate" => "61.61" "conversion_date" => "2021-04-23 00:00:04" "order_num" => 6 "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" => "mk" "autolang" => 1 "_flash" => array:2 [▶ "old" => [] "new" => [] ] "_token" => "vtHfDB2DINUyNbX2OqHorxL0qiw0q2v8Mfj7aa4z" "defaultLang" => App\Models\Language {#1323 ▶ +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/mk/tags/%D1%82%D1%80%D0%B5%D0%BD%D0%B5%D1%80" ] "PHPDEBUGBAR_STACK_DATA" => [] ]