20,000 të rinj të përfshirë në udhëtimet falas t’i kalojnë brenda BE-së
EU Discover u mundëson të rinjve të eksplorojnë Evropën.
EU Discover u mundëson të rinjve të eksplorojnë Evropën.
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
1 x Application (84.94%) | 389.81ms |
1 x Booting (15.04%) | 69.02ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
Params | |
---|---|
0 |
|
1 |
|
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 |
|
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 |
|
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 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
20 |
|
21 |
|
22 |
|
23 |
|
24 |
|
25 |
|
26 |
|
27 |
|
28 |
|
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` = 'news' and `is_published` = 1
2.76ms/app/Models/Post.php:617pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select `posts`.*, `categories_trans`.`title` as `category_name`, `categories_trans`.`slug` as `categorySlug` from `posts` left join `categories` on `posts`.`category_id` = `categories`.`id` left join `categories_trans` on `categories`.`id` = `categories_trans`.`category_id` where `posts`.`language_id` = 7 and `categories_trans`.`language_id` = 7 and `categories`.`type` = 'news' and `is_published` = 1 order by `posts`.`published_at` desc limit 12 offset 0
4.28ms/app/Models/Post.php:617pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus` where `menu_type` = '0' limit 1
6.21ms/app/Services/MenuService.php:75pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`menu_id` = 2 and `menus_items`.`menu_id` is not null and `language_id` = 7 and `parent_id` = '0' order by `menu_order` asc
5.63ms/app/Models/Menu.php:72pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (390, 391, 395, 398, 399) order by `menu_order` asc
2.2ms/app/Models/Menu.php:72pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (392, 393, 394, 396, 397, 401, 402, 403) order by `menu_order` asc
1.23ms/app/Models/Menu.php:72pickMetadata | |
---|---|
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` asc
1.67ms/app/Services/MenuService.php:85pickMetadata | |
---|---|
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` asc
3.05ms/app/Services/MenuService.php:85pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (392, 393, 394) order by `menu_order` asc
2.35ms/app/Services/MenuService.php:85pickMetadata | |
---|---|
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
2.98ms/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (392, 393, 394) order by `menu_order` asc
1.91ms/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 392 and `menus_items`.`parent_id` is not null
3.63ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 393 and `menus_items`.`parent_id` is not null
540μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 394 and `menus_items`.`parent_id` is not null
5.06ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
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` asc
830μs/app/Services/MenuService.php:85pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (396, 397) order by `menu_order` asc
250μs/app/Services/MenuService.php:85pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 395 and `menus_items`.`parent_id` is not null order by `menu_order` asc
1.21ms/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (396, 397) order by `menu_order` asc
5.58ms/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 396 and `menus_items`.`parent_id` is not null
240μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 397 and `menus_items`.`parent_id` is not null
2.11ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
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` asc
11.19ms/app/Services/MenuService.php:85pickMetadata | |
---|---|
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` asc
2.42ms/app/Services/MenuService.php:85pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (401, 402, 403) order by `menu_order` asc
4.18ms/app/Services/MenuService.php:85pickMetadata | |
---|---|
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
2.85ms/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (401, 402, 403) order by `menu_order` asc
1.83ms/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 401 and `menus_items`.`parent_id` is not null
530μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 402 and `menus_items`.`parent_id` is not null
4.14ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 403 and `menus_items`.`parent_id` is not null
1.99ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menus` where `menu_type` = '0' limit 1
2.7ms/app/Services/MenuService.php:121pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`menu_id` = 2 and `menus_items`.`menu_id` is not null and `language_id` = 7 and `parent_id` = '0' order by `menu_order` asc
4.83ms/app/Models/Menu.php:72pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (390, 391, 395, 398, 399) order by `menu_order` asc
3.64ms/app/Models/Menu.php:72pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (392, 393, 394, 396, 397, 401, 402, 403) order by `menu_order` asc
2.18ms/app/Models/Menu.php:72pickMetadata | |
---|---|
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` asc
1.17ms/app/Services/MenuService.php:131pickMetadata | |
---|---|
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` asc
3.04ms/app/Services/MenuService.php:131pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (392, 393, 394) order by `menu_order` asc
1.08ms/app/Services/MenuService.php:131pickMetadata | |
---|---|
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
6.08ms/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (392, 393, 394) order by `menu_order` asc
840μs/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 392 and `menus_items`.`parent_id` is not null
2.36ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 393 and `menus_items`.`parent_id` is not null
3.88ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 394 and `menus_items`.`parent_id` is not null
230μs/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
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` asc
1.39ms/app/Services/MenuService.php:131pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (396, 397) order by `menu_order` asc
2.49ms/app/Services/MenuService.php:131pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 395 and `menus_items`.`parent_id` is not null order by `menu_order` asc
2.17ms/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (396, 397) order by `menu_order` asc
2.4ms/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 396 and `menus_items`.`parent_id` is not null
4.58ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 397 and `menus_items`.`parent_id` is not null
2.13ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
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` asc
3.02ms/app/Services/MenuService.php:131pickMetadata | |
---|---|
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` asc
5.62ms/app/Services/MenuService.php:131pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (401, 402, 403) order by `menu_order` asc
1.89ms/app/Services/MenuService.php:131pickMetadata | |
---|---|
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
2.63ms/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (401, 402, 403) order by `menu_order` asc
1.91ms/app/Models/MenuItem.php:107pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 401 and `menus_items`.`parent_id` is not null
2.11ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 402 and `menus_items`.`parent_id` is not null
2.1ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select count(*) as aggregate from `menus_items` where `menus_items`.`parent_id` = 403 and `menus_items`.`parent_id` is not null
2.12ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `settings_languages` left join `settings_countries` on `settings_countries`.`id` = `settings_languages`.`country_id` left join `settings_countries_trans` on `settings_countries`.`id` = `settings_countries_trans`.`country_id` where `settings_languages`.`is_active` = 1 and `settings_countries_trans`.`language_id` = 7 order by `settings_countries`.`priority` asc
5.88ms/app/Models/Language.php:179pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `settings_languages` left join `settings_countries` on `settings_countries`.`id` = `settings_languages`.`country_id` left join `settings_countries_trans` on `settings_countries`.`id` = `settings_countries_trans`.`country_id` where `settings_languages`.`is_active` = 1 and `settings_countries_trans`.`language_id` = 7 and `settings_countries`.`id` = 247 order by `settings_languages`.`order_num` asc
2.44ms/app/Models/Language.php:192pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus` where `menu_type` = '1' limit 1
5.11ms/app/Services/MenuService.php:421pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`menu_id` = 3 and `menus_items`.`menu_id` is not null and `language_id` = 7 and `parent_id` = '0' order by `menu_order` asc
3ms/app/Models/Menu.php:72pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (341, 345, 351, 357) order by `menu_order` asc
2.63ms/app/Models/Menu.php:72pickMetadata | |
---|---|
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` asc
1.67ms/app/Models/Menu.php:72pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 341 and `menus_items`.`parent_id` is not null order by `menu_order` asc
2.62ms/app/Services/MenuService.php:433pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (342, 343, 344) order by `menu_order` asc
2.16ms/app/Services/MenuService.php:433pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 345 and `menus_items`.`parent_id` is not null order by `menu_order` asc
6.09ms/app/Services/MenuService.php:433pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (346, 347, 348, 349, 350) order by `menu_order` asc
2.36ms/app/Services/MenuService.php:433pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 351 and `menus_items`.`parent_id` is not null order by `menu_order` asc
2.7ms/app/Services/MenuService.php:433pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (352, 354, 355, 459) order by `menu_order` asc
1.88ms/app/Services/MenuService.php:433pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` = 357 and `menus_items`.`parent_id` is not null order by `menu_order` asc
3.07ms/app/Services/MenuService.php:433pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus_items` where `menus_items`.`parent_id` in (358, 359, 360, 361) order by `menu_order` asc
1.86ms/app/Services/MenuService.php:433pickMetadata | |
---|---|
Hints |
|
Backtrace |
|
select * from `settings_languages` left join `settings_countries` on `settings_countries`.`id` = `settings_languages`.`country_id` left join `settings_countries_trans` on `settings_countries`.`id` = `settings_countries_trans`.`country_id` where `settings_languages`.`is_active` = 1 and `settings_countries_trans`.`language_id` = 7 group by `slug` order by `settings_languages`.`order_num` asc
9.81ms/app/Models/Language.php:166pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `settings_countries_trans` where `language_id` = 7 and `country_id` = 2
3.51ms/app/Models/Country.php:53pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select settings_countries.*, settings_countries_trans.*, settings_countries_trans.country_name as CountryName from `settings_countries` left join `settings_countries_trans` on `settings_countries_trans`.`country_id` = `settings_countries`.`id` where `settings_countries`.`is_active` = 1 and `settings_countries_trans`.`language_id` = 7 group by `settings_countries_trans`.`country_name`, `settings_countries_trans`.`country_id` order by `settings_countries`.`priority` asc, `settings_countries_trans`.`country_name` asc
14.59ms/app/Models/Country.php:69pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `settings_languages` where `slug` = 'hr' limit 1
14.29ms/app/Models/Language.php:55pickMetadata | |
---|---|
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` asc
5.66ms/app/Models/Occupation.php:48pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
200
[]
[]
0 of 0array:16 [▶ "authorization" => array:1 [▶ 0 => "" ] "host" => array:1 [▶ 0 => "dev.pick.jobs" ] "connection" => array:1 [▶ 0 => "keep-alive" ] "pragma" => array:1 [▶ 0 => "no-cache" ] "cache-control" => array:1 [▶ 0 => "no-cache" ] "sec-ch-ua" => array:1 [▶ 0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" ] "sec-ch-ua-mobile" => array:1 [▶ 0 => "?0" ] "sec-ch-ua-platform" => array:1 [▶ 0 => ""Windows"" ] "upgrade-insecure-requests" => array:1 [▶ 0 => "1" ] "user-agent" => array:1 [▶ 0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" ] "accept" => array:1 [▶ 0 => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" ] "sec-fetch-site" => array:1 [▶ 0 => "none" ] "sec-fetch-mode" => array:1 [▶ 0 => "navigate" ] "sec-fetch-user" => array:1 [▶ 0 => "?1" ] "sec-fetch-dest" => array:1 [▶ 0 => "document" ] "accept-encoding" => array:1 [▶ 0 => "gzip, deflate, br, zstd" ] ]
0 of 0array:73 [▶ "REDIRECT_HTTP_AUTHORIZATION" => "" "REDIRECT_HTTPS" => "on" "REDIRECT_SSL_TLS_SNI" => "dev.pick.jobs" "REDIRECT_STATUS" => "200" "HTTP_AUTHORIZATION" => "" "HTTPS" => "on" "SSL_TLS_SNI" => "dev.pick.jobs" "SSL_SERVER_S_DN_CN" => "dev.pick.jobs" "SSL_SERVER_I_DN_C" => "PL" "SSL_SERVER_I_DN_O" => "Unizeto Technologies S.A." "SSL_SERVER_I_DN_OU" => "Certum Certification Authority" "SSL_SERVER_I_DN_CN" => "Certum Domain Validation CA SHA2" "SSL_SERVER_SAN_DNS_0" => "dev.pick.jobs" "SSL_SERVER_SAN_DNS_1" => "www.dev.pick.jobs" "SSL_VERSION_INTERFACE" => "mod_ssl/2.4.41" "SSL_VERSION_LIBRARY" => "OpenSSL/1.1.1f" "SSL_PROTOCOL" => "TLSv1.3" "SSL_SECURE_RENEG" => "false" "SSL_COMPRESS_METHOD" => "NULL" "SSL_CIPHER" => "TLS_AES_128_GCM_SHA256" "SSL_CIPHER_EXPORT" => "false" "SSL_CIPHER_USEKEYSIZE" => "128" "SSL_CIPHER_ALGKEYSIZE" => "128" "SSL_CLIENT_VERIFY" => "NONE" "SSL_SERVER_M_VERSION" => "3" "SSL_SERVER_M_SERIAL" => "3F9463232C084F0C31060B4ECC28AA8D" "SSL_SERVER_V_START" => "Sep 6 06:25:36 2024 GMT" "SSL_SERVER_V_END" => "Sep 6 06:25:35 2025 GMT" "SSL_SERVER_S_DN" => "CN=dev.pick.jobs" "SSL_SERVER_I_DN" => "CN=Certum Domain Validation CA SHA2,OU=Certum Certification Authority,O=Unizeto Technologies S.A.,C=PL" "SSL_SERVER_A_KEY" => "******" "SSL_SERVER_A_SIG" => "sha256WithRSAEncryption" "SSL_SESSION_ID" => "44cee0393f8e5d3361e3fe785996e43aa2d8f82b6a5a8d749a35862424b74a8a" "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" => "18.227.13.192" "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" => "11225" "REDIRECT_URL" => "/xk/lajme" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/xk/lajme" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744209449.161 "REQUEST_TIME" => 1744209449 ]
[]
0 of 0array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Wed, 09 Apr 2025 14:37:29 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InRGdkVoYkdVRWl3cFBOMUg2Q05lNkE9PSIsInZhbHVlIjoia2laMDVQQk5yQTZsV1FRVEdGREdTallxcStzVlpDejJteWtCUDY5Rzd4NnhidEN1NDFnb2kxXC9ER2ZtNDVYQzEiLCJtYWMiOiIzOTFiNDY4ZDY2NGFhZTI5ZGVhODlmYmNlMGZjOTYzOTYyZDdkYjNhMjI4NGM5ZGVmNTA4OGJiZjgzNjQxMTYzIn0%3D; expires=Thu, 10-Apr-2025 10:37:29 GMT; Max-Age=72000; path=/ ◀XSRF-TOKEN=eyJpdiI6InRGdkVoYkdVRWl3cFBOMUg2Q05lNkE9PSIsInZhbHVlIjoia2laMDVQQk5yQTZsV1FRVEdGREdTallxcStzVlpDejJteWtCUDY5Rzd4NnhidEN1NDFnb2kxXC9ER2ZtNDVYQzEiLCJtY ▶" 1 => "pickjobs_session=eyJpdiI6IjJCUFBtb0xycHN2bHFrWVo2bWxUOVE9PSIsInZhbHVlIjoiRDQxZFFETUt6bGljRlRjV2lFeWZUSThPRVA2ZGJkU1Q2WW9wSFwvY05FQVVHUnZIRHMzRldWMFwvT1FDUHpmcEN6IiwibWFjIjoiNmNjY2FjYWMwMDM2MDA4ZWE5ZDY4OWI0ZjQyNDQ3NjhkYjRjZWE2OWYzMmViMWIxNDRhMDYyMzdlNGUxMWU0NyJ9; expires=Thu, 10-Apr-2025 10:37:29 GMT; Max-Age=72000; path=/; httponly ◀pickjobs_session=eyJpdiI6IjJCUFBtb0xycHN2bHFrWVo2bWxUOVE9PSIsInZhbHVlIjoiRDQxZFFETUt6bGljRlRjV2lFeWZUSThPRVA2ZGJkU1Q2WW9wSFwvY05FQVVHUnZIRHMzRldWMFwvT1FDUHpmcEN ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6InRGdkVoYkdVRWl3cFBOMUg2Q05lNkE9PSIsInZhbHVlIjoia2laMDVQQk5yQTZsV1FRVEdGREdTallxcStzVlpDejJteWtCUDY5Rzd4NnhidEN1NDFnb2kxXC9ER2ZtNDVYQzEiLCJtYWMiOiIzOTFiNDY4ZDY2NGFhZTI5ZGVhODlmYmNlMGZjOTYzOTYyZDdkYjNhMjI4NGM5ZGVmNTA4OGJiZjgzNjQxMTYzIn0%3D; expires=Thu, 10-Apr-2025 10:37:29 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6InRGdkVoYkdVRWl3cFBOMUg2Q05lNkE9PSIsInZhbHVlIjoia2laMDVQQk5yQTZsV1FRVEdGREdTallxcStzVlpDejJteWtCUDY5Rzd4NnhidEN1NDFnb2kxXC9ER2ZtNDVYQzEiLCJtY ▶" 1 => "pickjobs_session=eyJpdiI6IjJCUFBtb0xycHN2bHFrWVo2bWxUOVE9PSIsInZhbHVlIjoiRDQxZFFETUt6bGljRlRjV2lFeWZUSThPRVA2ZGJkU1Q2WW9wSFwvY05FQVVHUnZIRHMzRldWMFwvT1FDUHpmcEN6IiwibWFjIjoiNmNjY2FjYWMwMDM2MDA4ZWE5ZDY4OWI0ZjQyNDQ3NjhkYjRjZWE2OWYzMmViMWIxNDRhMDYyMzdlNGUxMWU0NyJ9; expires=Thu, 10-Apr-2025 10:37:29 GMT; path=/; httponly ◀pickjobs_session=eyJpdiI6IjJCUFBtb0xycHN2bHFrWVo2bWxUOVE9PSIsInZhbHVlIjoiRDQxZFFETUt6bGljRlRjV2lFeWZUSThPRVA2ZGJkU1Q2WW9wSFwvY05FQVVHUnZIRHMzRldWMFwvT1FDUHpmcEN ▶" ] ]
0 of 0array:8 [▶ "currentLang" => App\Models\Language {#1411 ▶ +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" => "7It6vOuhZwvvEBZPBq5zrlfPw88bVydUpdZVo55C" "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/lajme" ] "PHPDEBUGBAR_STACK_DATA" => [] ]