Shkarkoni aplikacionin falas të celularit PickJobs në pajisjen tuaj Android ose iOS, përmes Google Play Store ose App Store, dhe fitoni akses kudo, në çdo kohë.
Krajnji primatelj financijskog instrumenta sufinanciranog iz Europskog fonda za regionalni razvoj u sklopu Operativnog programa “Konkurentnost i kohezija”
Për përvojën më të mirë të përdoruesit dhe funksionalitetin e plotë të të gjitha tipareve të faqes në internet, PickJobs përdor cookie dhe teknologji të ngjashme. Nëse vazhdoni të përdorni këtë faqe, ne do të supozojmë se ju keni pranuar dhe pajtuar me Politikën tonë të Cookie-t. Lexoni më shumë rreth Politika e Cookie
Shkarkoni aplikacionin falas të celularit PickJobs në pajisjen tuaj Android ose iOS, përmes Google Play Store ose App Store, dhe fitoni akses kudo, në çdo kohë.
| 1 x Application (75.89%) | 332.74ms |
| 1 x Booting (20.12%) | 88.24ms |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 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 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 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 | |
| Params | |
|---|---|
| 0 | |
| 1 | |
| 2 | |
| 3 | |
| 4 | |
| 5 | |
| 6 | |
| 7 | |
| 8 | |
| 9 | |
| 10 | |
| 11 | |
| 12 | |
| 13 | |
| 14 | |
| 15 | |
| 16 | |
| 17 | |
| 18 | |
| 19 | |
| 20 | |
| 21 | |
| 22 | |
| 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 | |
Kroacia
Bosnja dhe Hercegovina
Serbia
Mali i Zi
Maqedonia Veriore
Ukranija
Shqipëri
Austri
Gjermani
Zvicera
Mbretëria e Bashkuarselect * from `categories` left join `categories_trans` on `categories`.`id` = `categories_trans`.`category_id` where `categories_trans`.`language_id` = 7 and `categories`.`type` = 'faq' and `categories_trans`.`slug` = 'Media-dhe-dokumentet' limit 13.98ms/app/Models/Category.php:149pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `posts` left join `categories` on `posts`.`category_id` = `categories`.`id` left join `categories_trans` on `categories`.`id` = `categories_trans`.`category_id` where `posts`.`language_id` = 7 and `categories_trans`.`language_id` = 7 and `categories`.`type` = 'faq' and `is_published` = 1 and `posts`.`category_id` = 695.45ms/app/Models/Post.php:617pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus` where `menu_type` = '0' limit 112ms/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` = 7 and `parent_id` = '0' order by `menu_order` asc1.79ms/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (390, 391, 395, 398, 399) order by `menu_order` asc2.14ms/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (392, 393, 394, 396, 397, 401, 402, 403) order by `menu_order` asc1.92ms/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 390 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc2.67ms/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 391 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc1.33ms/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (392, 393, 394) order by `menu_order` asc2.64ms/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 391 and `menus_items`.`parent_id` is not null order by `menu_order` asc3.34ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (392, 393, 394) order by `menu_order` asc1.51ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 392 and `menus_items`.`parent_id` is not null2.53ms/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` = 393 and `menus_items`.`parent_id` is not null1.36ms/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` = 394 and `menus_items`.`parent_id` is not null2.54ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 395 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc2.21ms/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (396, 397) order by `menu_order` asc3ms/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 395 and `menus_items`.`parent_id` is not null order by `menu_order` asc1.92ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (396, 397) order by `menu_order` asc2.09ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 396 and `menus_items`.`parent_id` is not null2.23ms/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` = 397 and `menus_items`.`parent_id` is not null380μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 398 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc1.61ms/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 399 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc2.63ms/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (401, 402, 403) order by `menu_order` asc1.9ms/app/Services/MenuService.php:85pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 399 and `menus_items`.`parent_id` is not null order by `menu_order` asc1.98ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (401, 402, 403) order by `menu_order` asc2.53ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 401 and `menus_items`.`parent_id` is not null2.02ms/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` = 402 and `menus_items`.`parent_id` is not null1.95ms/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` = 403 and `menus_items`.`parent_id` is not null2.29ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus` where `menu_type` = '0' limit 11.69ms/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` = 7 and `parent_id` = '0' order by `menu_order` asc2.95ms/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (390, 391, 395, 398, 399) order by `menu_order` asc2.73ms/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (392, 393, 394, 396, 397, 401, 402, 403) order by `menu_order` asc2.05ms/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 390 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc3.12ms/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 391 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc1.59ms/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (392, 393, 394) order by `menu_order` asc2.67ms/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 391 and `menus_items`.`parent_id` is not null order by `menu_order` asc2.58ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (392, 393, 394) order by `menu_order` asc1.99ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 392 and `menus_items`.`parent_id` is not null710μ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` = 393 and `menus_items`.`parent_id` is not null1.54ms/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` = 394 and `menus_items`.`parent_id` is not null2.49ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 395 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc2.43ms/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (396, 397) order by `menu_order` asc2.74ms/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 395 and `menus_items`.`parent_id` is not null order by `menu_order` asc1.64ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (396, 397) order by `menu_order` asc3.2ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 396 and `menus_items`.`parent_id` is not null1.56ms/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` = 397 and `menus_items`.`parent_id` is not null2.81ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 398 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc1.57ms/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 399 and `menus_items`.`parent_id` is not null order by `menu_order` asc, `menu_order` asc2.82ms/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (401, 402, 403) order by `menu_order` asc3.21ms/app/Services/MenuService.php:131pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 399 and `menus_items`.`parent_id` is not null order by `menu_order` asc1.7ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (401, 402, 403) order by `menu_order` asc2.57ms/app/Models/MenuItem.php:107pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 401 and `menus_items`.`parent_id` is not null1.97ms/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` = 402 and `menus_items`.`parent_id` is not null2.25ms/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` = 403 and `menus_items`.`parent_id` is not null1.08ms/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` = 7 order by `settings_countries`.`priority` asc5.83ms/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` = 7 and `settings_countries`.`id` = 247 order by `settings_languages`.`order_num` asc6.63ms/app/Models/Language.php:192pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus` where `menu_type` = '1' limit 19.44ms/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` = 7 and `parent_id` = '0' order by `menu_order` asc1.1ms/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (341, 345, 351, 357) order by `menu_order` asc1.44ms/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (342, 343, 344, 346, 347, 348, 349, 350, 352, 354, 355, 358, 359, 360, 361, 459) order by `menu_order` asc2.07ms/app/Models/Menu.php:72pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 341 and `menus_items`.`parent_id` is not null order by `menu_order` asc1.67ms/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (342, 343, 344) order by `menu_order` asc11.31ms/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 345 and `menus_items`.`parent_id` is not null order by `menu_order` asc1.01ms/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (346, 347, 348, 349, 350) order by `menu_order` asc2.53ms/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 351 and `menus_items`.`parent_id` is not null order by `menu_order` asc1.38ms/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (352, 354, 355, 459) order by `menu_order` asc1.1ms/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 357 and `menus_items`.`parent_id` is not null order by `menu_order` asc4.75ms/app/Services/MenuService.php:433pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (358, 359, 360, 361) order by `menu_order` asc820μ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` = 7 group by `slug` order by `settings_languages`.`order_num` asc3.92ms/app/Models/Language.php:166pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select count(*) as aggregate from `settings_countries_trans` where `language_id` = 7 and `country_id` = 22.17ms/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` = 7 group by `settings_countries_trans`.`country_name`, `settings_countries_trans`.`country_id` order by `settings_countries`.`priority` asc, `settings_countries_trans`.`country_name` asc11.01ms/app/Models/Country.php:69pick| Metadata | |
|---|---|
| Bindings |
|
| Backtrace |
|
select * from `settings_languages` where `slug` = 'hr' limit 17.21ms/app/Models/Language.php:55pick| Metadata | |
|---|---|
| Bindings |
|
| Hints |
|
| Backtrace |
|
select `occupations`.*, coalesce(sq_occupations_trans.occupation_name, hr_occupations_trans.occupation_name) as name, coalesce(sq_occupations_trans.description, hr_occupations_trans.description) as description from `occupations` left join `occupations_trans` as `sq_occupations_trans` on `sq_occupations_trans`.`occupation_id` = `occupations`.`id` and `sq_occupations_trans`.`language_id` = 7 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.55ms/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 => ""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" => "e05e6b4d5bacf459ef6ded05df0982bd35919f4c8e586b1a636744ade3073f3f" "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" => "13.58.74.190" "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" => "31359" "REDIRECT_URL" => "/xk/faq/Media-dhe-dokumentet" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/xk/faq/Media-dhe-dokumentet" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744148579.87 "REQUEST_TIME" => 1744148579 ]
[]
0 of 0array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Tue, 08 Apr 2025 21:43:00 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImlcL0t2WnhCaTYxcGFLYVZKcjhyK2pnPT0iLCJ2YWx1ZSI6IlFjMDBiWERTZFV0eWhqaDhKTXBKMG4wenhjemg4MEp5RFVuRFBkdmpUeVhVblNjSnpxbTBuV3AxNlwvbG5UMCtQIiwibWFjIjoiYzc1MWE1MDUxMjBjZjJiNzQ2OWI4ODYxMDUxOTZiOTcxOGMzNzM4ODkzMGFiYjllZWU0NDU1OGMzYTBmZDA3NyJ9; expires=Wed, 09-Apr-2025 17:43:00 GMT; Max-Age=72000; path=/ ◀XSRF-TOKEN=eyJpdiI6ImlcL0t2WnhCaTYxcGFLYVZKcjhyK2pnPT0iLCJ2YWx1ZSI6IlFjMDBiWERTZFV0eWhqaDhKTXBKMG4wenhjemg4MEp5RFVuRFBkdmpUeVhVblNjSnpxbTBuV3AxNlwvbG5UMCtQIiwib ▶" 1 => "pickjobs_session=eyJpdiI6Imh2NTRZa0dsT3NvNXl3NkVhRXBvekE9PSIsInZhbHVlIjoiTHZ6b3NTK25aZnVNQVVIV0VFbHlHbEdjdjM1RjRDaEdBV3FpekVDOVczcTJ6dkZyQ0pIaGtaNUFmS244dkVpQSIsIm1hYyI6IjVhMmI2ZWI5ZTg5MzQ3YjdjOGE4YjcwOTNiODMwNWMxYjAxMDlkMjNjZmNiMGJkZGQxZGU4ZmFhNmRmMTQ1MTcifQ%3D%3D; expires=Wed, 09-Apr-2025 17:43:00 GMT; Max-Age=72000; path=/; httponly ◀pickjobs_session=eyJpdiI6Imh2NTRZa0dsT3NvNXl3NkVhRXBvekE9PSIsInZhbHVlIjoiTHZ6b3NTK25aZnVNQVVIV0VFbHlHbEdjdjM1RjRDaEdBV3FpekVDOVczcTJ6dkZyQ0pIaGtaNUFmS244dkVpQSI ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6ImlcL0t2WnhCaTYxcGFLYVZKcjhyK2pnPT0iLCJ2YWx1ZSI6IlFjMDBiWERTZFV0eWhqaDhKTXBKMG4wenhjemg4MEp5RFVuRFBkdmpUeVhVblNjSnpxbTBuV3AxNlwvbG5UMCtQIiwibWFjIjoiYzc1MWE1MDUxMjBjZjJiNzQ2OWI4ODYxMDUxOTZiOTcxOGMzNzM4ODkzMGFiYjllZWU0NDU1OGMzYTBmZDA3NyJ9; expires=Wed, 09-Apr-2025 17:43:00 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImlcL0t2WnhCaTYxcGFLYVZKcjhyK2pnPT0iLCJ2YWx1ZSI6IlFjMDBiWERTZFV0eWhqaDhKTXBKMG4wenhjemg4MEp5RFVuRFBkdmpUeVhVblNjSnpxbTBuV3AxNlwvbG5UMCtQIiwib ▶" 1 => "pickjobs_session=eyJpdiI6Imh2NTRZa0dsT3NvNXl3NkVhRXBvekE9PSIsInZhbHVlIjoiTHZ6b3NTK25aZnVNQVVIV0VFbHlHbEdjdjM1RjRDaEdBV3FpekVDOVczcTJ6dkZyQ0pIaGtaNUFmS244dkVpQSIsIm1hYyI6IjVhMmI2ZWI5ZTg5MzQ3YjdjOGE4YjcwOTNiODMwNWMxYjAxMDlkMjNjZmNiMGJkZGQxZGU4ZmFhNmRmMTQ1MTcifQ%3D%3D; expires=Wed, 09-Apr-2025 17:43:00 GMT; path=/; httponly ◀pickjobs_session=eyJpdiI6Imh2NTRZa0dsT3NvNXl3NkVhRXBvekE9PSIsInZhbHVlIjoiTHZ6b3NTK25aZnVNQVVIV0VFbHlHbEdjdjM1RjRDaEdBV3FpekVDOVczcTJ6dkZyQ0pIaGtaNUFmS244dkVpQSI ▶" ] ]
0 of 0array:8 [▶ "currentLang" => App\Models\Language {#1415 ▶ +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" => 7 "slug" => "sq" "country_id" => 2 "language_name" => "Shqip" "currency" => "all" "eur_conversion_rate" => "122.59" "conversion_date" => "2021-06-25 12:00:07" "order_num" => 7 "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" => 7 "slug" => "sq" "country_id" => 2 "language_name" => "Shqip" "currency" => "all" "eur_conversion_rate" => "122.59" "conversion_date" => "2021-06-25 12:00:07" "order_num" => 7 "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" => "sq" "autolang" => 1 "_flash" => array:2 [▶ "old" => [] "new" => [] ] "_token" => "SD8eI3YNVh0a6sG0Due8XcQsiRA5UqLNLYbRVZ0V" "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/xk/faq/Media-dhe-dokumentet" ] "PHPDEBUGBAR_STACK_DATA" => [] ]