Udhëtarët e BE-së nuk janë ende në dijeni të drejtave të tyre
Për ata që udhëtojnë shpesh ose për ata që kanë përjetuar situata zhgënjyese gjatë udhëtimeve të tyre, një çift i inform...
Për ata që udhëtojnë shpesh ose për ata që kanë përjetuar situata zhgënjyese gjatë udhëtimeve të tyre, një çift i inform...
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 (75.36%) | 336.48ms |
1 x Booting (24.62%) | 109.91ms |
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
Params | |
---|---|
0 |
|
1 |
|
2 |
|
3 |
|
4 |
|
5 |
|
6 |
|
7 |
|
8 |
|
9 |
|
10 |
|
11 |
|
12 |
|
13 |
|
14 |
|
15 |
|
16 |
|
17 |
|
18 |
|
19 |
|
Params | |
---|---|
0 |
|
1 |
|
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 |
|
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 |
|
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 |
|
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 |
|
25 |
|
26 |
|
27 |
|
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 |
|
29 |
|
select * from `categories` left join `categories_trans` on `categories`.`id` = `categories_trans`.`category_id` where `categories_trans`.`language_id` = 7 and `categories`.`type` = 'blog' and `categories_trans`.`slug` = 'keshilla-juridike' limit 1
4.36ms/app/Models/Category.php:149pickMetadata | |
---|---|
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` = 'blog' and `is_published` = 1 and `posts`.`category_id` = 79
1.82ms/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` = 'blog' and `is_published` = 1 and `posts`.`category_id` = 79 order by `posts`.`published_at` desc limit 12 offset 0
3.34ms/app/Models/Post.php:617pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus` where `menu_type` = '0' limit 1
3.01ms/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
1.78ms/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
5.67ms/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.41ms/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
2ms/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
1.13ms/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
560μs/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
5.48ms/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
1.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
1.86ms/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
1.64ms/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.6ms/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
1.61ms/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.6ms/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
1.44ms/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
1.74ms/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
3.65ms/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
2ms/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
1.51ms/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
1.58ms/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
1.57ms/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.45ms/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
6.69ms/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
1.49ms/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.5ms/vendor/laravel/framework/src/Illuminate/Support/Traits/ForwardsCalls.php:23pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `menus` where `menu_type` = '0' limit 1
1.43ms/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
2.34ms/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
1.55ms/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.56ms/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.88ms/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
1.28ms/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.7ms/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
2.15ms/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
2.89ms/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.6ms/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
1.84ms/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
1.22ms/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.92ms/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
710μs/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
1.74ms/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
1.03ms/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
2.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.37ms/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
1.7ms/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
2.76ms/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
2.38ms/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
3.09ms/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.58ms/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.13ms/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
1.95ms/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.5ms/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
10.12ms/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` = 2 order by `settings_languages`.`order_num` asc
6.47ms/app/Models/Language.php:192pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select * from `menus` where `menu_type` = '1' limit 1
4.19ms/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
570μs/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
4.86ms/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
700μs/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
1.16ms/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.83ms/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
980μs/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
1.13ms/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
3.77ms/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.11ms/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
1.05ms/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.12ms/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
3.46ms/app/Models/Language.php:166pickMetadata | |
---|---|
Bindings |
|
Hints |
|
Backtrace |
|
select count(*) as aggregate from `settings_countries_trans` where `language_id` = 7 and `country_id` = 2
2.73ms/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
16.05ms/app/Models/Country.php:69pickMetadata | |
---|---|
Bindings |
|
Backtrace |
|
select * from `settings_languages` where `slug` = 'hr' limit 1
8.75ms/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
1.5ms/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" => "f1924b8c9116d85187d2838b257cd4dd7210c295f03949c2839631037b33b4a3" "SSL_SESSION_RESUMED" => "Initial" "HTTP_HOST" => "dev.pick.jobs" "HTTP_CONNECTION" => "keep-alive" "HTTP_PRAGMA" => "no-cache" "HTTP_CACHE_CONTROL" => "no-cache" "HTTP_SEC_CH_UA" => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129"" "HTTP_SEC_CH_UA_MOBILE" => "?0" "HTTP_SEC_CH_UA_PLATFORM" => ""Windows"" "HTTP_UPGRADE_INSECURE_REQUESTS" => "1" "HTTP_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)" "HTTP_ACCEPT" => "text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,*/*;q=0.8,application/signed-exchange;v=b3;q=0.7" "HTTP_SEC_FETCH_SITE" => "none" "HTTP_SEC_FETCH_MODE" => "navigate" "HTTP_SEC_FETCH_USER" => "?1" "HTTP_SEC_FETCH_DEST" => "document" "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd" "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin" "SERVER_SIGNATURE" => "<address>Apache/2.4.41 (Ubuntu) Server at dev.pick.jobs Port 443</address>\n" "SERVER_SOFTWARE" => "Apache/2.4.41 (Ubuntu)" "SERVER_NAME" => "dev.pick.jobs" "SERVER_ADDR" => "192.168.77.53" "SERVER_PORT" => "443" "REMOTE_ADDR" => "3.14.88.3" "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" => "38947" "REDIRECT_URL" => "/al/blog/keshilla-juridike" "GATEWAY_INTERFACE" => "CGI/1.1" "SERVER_PROTOCOL" => "HTTP/1.1" "REQUEST_METHOD" => "GET" "QUERY_STRING" => "" "REQUEST_URI" => "/al/blog/keshilla-juridike" "SCRIPT_NAME" => "/index.php" "PHP_SELF" => "/index.php" "REQUEST_TIME_FLOAT" => 1744172517.723 "REQUEST_TIME" => 1744172517 ]
[]
0 of 0array:5 [▶ "cache-control" => array:1 [▶ 0 => "no-cache, private" ] "date" => array:1 [▶ 0 => "Wed, 09 Apr 2025 04:21:57 GMT" ] "content-type" => array:1 [▶ 0 => "text/html; charset=UTF-8" ] "set-cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkYrMytsZ3I2bFIxc01iMVZHZGFlc1E9PSIsInZhbHVlIjoiTkxPeERSejJhNjlFdjZ5YTlraDNzUE9FdG0wdHJKR2tzOE9HN0xRZWN1Nk1nRUNtT1dkeldPVXhLMFcrc21MbiIsIm1hYyI6ImZhNTYyZWUyYmJhY2Q5ZjVjNWNmYjg1NWRlMGEwNzE5ZTNhNzFjNzM0ZWU5MzVkYjFjMTRjNjBhZDk1OWIxZjAifQ%3D%3D; expires=Thu, 10-Apr-2025 00:21:58 GMT; Max-Age=72000; path=/ ◀XSRF-TOKEN=eyJpdiI6IkYrMytsZ3I2bFIxc01iMVZHZGFlc1E9PSIsInZhbHVlIjoiTkxPeERSejJhNjlFdjZ5YTlraDNzUE9FdG0wdHJKR2tzOE9HN0xRZWN1Nk1nRUNtT1dkeldPVXhLMFcrc21MbiIsIm1hY ▶" 1 => "pickjobs_session=eyJpdiI6IjF3SFBOYjVlWUdLSVo1a2pTVWYwcmc9PSIsInZhbHVlIjoiNzVMZWw2WFZUb1c4RVlHeGQ2YndKQXdcLytaVEF5NGU0MVY4SDhSc1ZZZGlVXC81dHM4SGhUeUVVTWZ1WEZRc1hxIiwibWFjIjoiNjRkNGY3NWZkZTIwYWZkM2EyMzRkMDFhMzYxODIwNGQ5ZmVhNTFmNmYwN2E3M2Y1ZGE2MjExOTgyMGUzY2E3MiJ9; expires=Thu, 10-Apr-2025 00:21:58 GMT; Max-Age=72000; path=/; httponly ◀pickjobs_session=eyJpdiI6IjF3SFBOYjVlWUdLSVo1a2pTVWYwcmc9PSIsInZhbHVlIjoiNzVMZWw2WFZUb1c4RVlHeGQ2YndKQXdcLytaVEF5NGU0MVY4SDhSc1ZZZGlVXC81dHM4SGhUeUVVTWZ1WEZRc1h ▶" ] "Set-Cookie" => array:2 [▶ 0 => "XSRF-TOKEN=eyJpdiI6IkYrMytsZ3I2bFIxc01iMVZHZGFlc1E9PSIsInZhbHVlIjoiTkxPeERSejJhNjlFdjZ5YTlraDNzUE9FdG0wdHJKR2tzOE9HN0xRZWN1Nk1nRUNtT1dkeldPVXhLMFcrc21MbiIsIm1hYyI6ImZhNTYyZWUyYmJhY2Q5ZjVjNWNmYjg1NWRlMGEwNzE5ZTNhNzFjNzM0ZWU5MzVkYjFjMTRjNjBhZDk1OWIxZjAifQ%3D%3D; expires=Thu, 10-Apr-2025 00:21:58 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6IkYrMytsZ3I2bFIxc01iMVZHZGFlc1E9PSIsInZhbHVlIjoiTkxPeERSejJhNjlFdjZ5YTlraDNzUE9FdG0wdHJKR2tzOE9HN0xRZWN1Nk1nRUNtT1dkeldPVXhLMFcrc21MbiIsIm1hY ▶" 1 => "pickjobs_session=eyJpdiI6IjF3SFBOYjVlWUdLSVo1a2pTVWYwcmc9PSIsInZhbHVlIjoiNzVMZWw2WFZUb1c4RVlHeGQ2YndKQXdcLytaVEF5NGU0MVY4SDhSc1ZZZGlVXC81dHM4SGhUeUVVTWZ1WEZRc1hxIiwibWFjIjoiNjRkNGY3NWZkZTIwYWZkM2EyMzRkMDFhMzYxODIwNGQ5ZmVhNTFmNmYwN2E3M2Y1ZGE2MjExOTgyMGUzY2E3MiJ9; expires=Thu, 10-Apr-2025 00:21:58 GMT; path=/; httponly ◀pickjobs_session=eyJpdiI6IjF3SFBOYjVlWUdLSVo1a2pTVWYwcmc9PSIsInZhbHVlIjoiNzVMZWw2WFZUb1c4RVlHeGQ2YndKQXdcLytaVEF5NGU0MVY4SDhSc1ZZZGlVXC81dHM4SGhUeUVVTWZ1WEZRc1h ▶" ] ]
0 of 0array:8 [▶ "currentLang" => App\Models\Language {#1406 ▶ +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" => "yZ6SWIK7kmP09j5nNo6FDf9tP0oRoeOfnXvzLYZX" "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/al/blog/keshilla-juridike" ] "PHPDEBUGBAR_STACK_DATA" => [] ]