Browse Jobs

Messages Timeline Exceptions Views4 Route Queries9 Models299 Mails Gate Session Request

Request history8.1.322.02s695MBGET jobs

Booting (1.75s)time
Application (268ms)time
1 x Booting (86.74%)
1.75s
1 x Application (13.26%)
268ms

4 templates were rendered

frontend.jobsjobs.blade.php#?blade
admin.flash_msgflash_msg.blade.php#?blade
pagination::bootstrap-5bootstrap-5.blade.php#?blade
layouts.themetheme.blade.php#?blade

uri: GET jobs
middleware: web
controller: App\Http\Controllers\JobController@jobsListing
namespace
prefix
where
as: jobs_listing
file: app/Http/Controllers/JobController.php:855-920

9 statements were executed189ms

JobController.php#860clientfyi_final840μsselect * from `categories` order by `category_name` asc

Backtrace

app/Http/Controllers/JobController.php:860
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

JobController.php#861clientfyi_final370μsselect * from `countries`

Backtrace

app/Http/Controllers/JobController.php:861
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

User.php#78clientfyi_final83.41msselect `id`, `company` from `users` where `user_type` in ('employer', 'agent') order by `id` desc

Bindings	0: employer 1: agent
Backtrace	app/Models/User.php:78 app/Http/Controllers/JobController.php:908 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260

JobController.php#911clientfyi_final1.59msselect count(*) as aggregate from `jobs` where `status` = 1 and `category_id` = '63'

Bindings	0: 1 1: 63
Backtrace	app/Http/Controllers/JobController.php:911 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

JobController.php#911clientfyi_final1.4msselect * from `jobs` where `status` = 1 and `category_id` = '63' order by `updated_at` desc limit 10 offset 0

Bindings	0: 1 1: 63
Backtrace	app/Http/Controllers/JobController.php:911 vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43 vendor/laravel/framework/src/Illuminate/Routing/Route.php:260 vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

JobController.php#911clientfyi_final640μsselect * from `users` where `users`.`id` in (11832, 16793, 22602, 47222, 48221, 50831, 51403, 74806, 75169, 81724)

Backtrace

app/Http/Controllers/JobController.php:911
vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54
vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:43
vendor/laravel/framework/src/Illuminate/Routing/Route.php:260
vendor/laravel/framework/src/Illuminate/Routing/Route.php:205

theme.blade.php#101clientfyi_final680μsselect * from `categories` where `job_count` >= 1 order by `job_count` desc

Bindings	0: 1
Backtrace	view::layouts.theme:101 vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124 vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58 vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72 vendor/laravel/framework/src/Illuminate/View/View.php:207

theme.blade.php#102clientfyi_final46.88ms

SELECT jobs.state_id,jobs.state_name, COUNT(*) AS numberOfSales FROM jobs JOIN states ON states.id = jobs.state_id GROUP BY jobs.state_id,jobs.state_name ORDER BY COUNT(*) DESC limit 15

Backtrace

view::layouts.theme:102
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
vendor/laravel/framework/src/Illuminate/View/View.php:207

theme.blade.php#103clientfyi_final53.5ms

SELECT jobs.city_id,jobs.city_name, COUNT(*) AS numberOfcities FROM jobs JOIN cities ON cities.id = jobs.city_id GROUP BY jobs.city_id,jobs.city_name ORDER BY COUNT(*) DESC limit 15

Backtrace

view::layouts.theme:103
vendor/laravel/framework/src/Illuminate/Filesystem/Filesystem.php:124
vendor/laravel/framework/src/Illuminate/View/Engines/PhpEngine.php:58
vendor/laravel/framework/src/Illuminate/View/Engines/CompilerEngine.php:72
vendor/laravel/framework/src/Illuminate/View/View.php:207

App\Models\Category: 276Category.php#?
App\Models\Job: 10Job.php#?
App\Models\User: 10User.php#?
App\Models\Country: 3Country.php#?

_token: Oyfg6oaT5rjFKY0uT72iELOe1natJtX4AW7g9n7x
_previous: array:1 [ "url" => "https://pingjob.com/jobs?category=63" ]
_flash: array:2 [ "old" => [] "new" => [] ]

path_info

/jobs

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "category" => "63"
]

request_request

[]

request_headers

  0 of 0   
array:25 [▼
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""HeadlessChrome";v="129", "Not=A?Brand";v="8", "Chromium";v="129""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "cdn-loop" => array:1 [▶
    0 => "cloudflare; loops=1"
  ]
  "priority" => array:1 [▶
    0 => "u=0, i"
  ]
  "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)"
  ]
  "cf-connecting-ip" => array:1 [▶
    0 => "18.221.201.67"
  ]
  "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"
  ]
  "cf-visitor" => array:1 [▶
    0 => "{"scheme":"https"}"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "x-forwarded-proto" => array:1 [▶
    0 => "https"
  ]
  "cf-ipcountry" => array:1 [▶
    0 => "US"
  ]
  "accept-encoding" => array:1 [▶
    0 => "gzip, br"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "cf-ray" => array:1 [▶
    0 => "92c39dd8782d79d9-ORD"
  ]
  "connection" => array:1 [▶
    0 => "close"
  ]
  "x-accel-internal" => array:1 [▶
    0 => "/internal-nginx-static-location"
  ]
  "x-forwarded-for" => array:1 [▶
    0 => "18.221.201.67"
  ]
  "x-real-ip" => array:1 [▶
    0 => "172.70.127.158"
  ]
  "host" => array:1 [▶
    0 => "pingjob.com"
  ]
]

request_cookies

[]

response_headers

  0 of 0   
array:7 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "private, must-revalidate"
  ]
  "date" => array:1 [▶
    0 => "Sun, 06 Apr 2025 19:15:56 GMT"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "expires" => array:1 [▶
    0 => "-1"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjlaYkloS2ttN0hIK1p6WTVlWktIb0E9PSIsInZhbHVlIjoiWDBqeUcydG5xeGNkK1NDRGRCYkc1bEdYdWRpS0UzTFZSbGFTZUc3OHo0c3NUWTVSKzI3Vnp5V1ZyL1I3WXR5Zm54WEtWRXdxdjI1SlNtSi9mSTdRVE1kaUg5cmdEZUtUd0lWN0NydFhlOWUyeGI1TUhwNysxVGhpOWNjNTcrNW4iLCJtYWMiOiJiOTViNTkwNTdmMGU4ZjFmOGI0NTEyMDA2N2JmNDQ0YTRmM2RmNzI5YmJhZmZiZDJlOTMyOTlkMjNjMjNlMDA5IiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 21:15:56 GMT; Max-Age=7200; path=/; secure; samesite=lax ◀XSRF-TOKEN=eyJpdiI6IjlaYkloS2ttN0hIK1p6WTVlWktIb0E9PSIsInZhbHVlIjoiWDBqeUcydG5xeGNkK1NDRGRCYkc1bEdYdWRpS0UzTFZSbGFTZUc3OHo0c3NUWTVSKzI3Vnp5V1ZyL1I3WXR5Zm54WEtWR ▶"
    1 => "laravel_session=eyJpdiI6Ind6bDF5VUkyT0VUdm9GUW5JMHBtQkE9PSIsInZhbHVlIjoiNldKU21QVTluV25PWFUrc2JyL1pEckhTbFV4R1kvblRHYzdTd0o0bEp5a0M0bmI0VDdoMVVZQWlhV0ErMjFuMWRYOUZlVEhYYXJJNzBVMEtQK1RKdU5JWWJWRFlYNHNwbXlhdXBYRVlOOGdBd2xNaWFvb3hMZ1MyTjVnNThINnQiLCJtYWMiOiI4NDk3ZjJmNjZhNzZkMzljNjRiM2NhYzA1OTY1MjE5YzFmNzFmMTU5OWMwMDA0ZjVkNmFjMzdmNzc4OGM1NmFkIiwidGFnIjoiIn0%3D; expires=Sun, 06 Apr 2025 21:15:56 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀laravel_session=eyJpdiI6Ind6bDF5VUkyT0VUdm9GUW5JMHBtQkE9PSIsInZhbHVlIjoiNldKU21QVTluV25PWFUrc2JyL1pEckhTbFV4R1kvblRHYzdTd0o0bEp5a0M0bmI0VDdoMVVZQWlhV0ErMjFuMWRY ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6IjlaYkloS2ttN0hIK1p6WTVlWktIb0E9PSIsInZhbHVlIjoiWDBqeUcydG5xeGNkK1NDRGRCYkc1bEdYdWRpS0UzTFZSbGFTZUc3OHo0c3NUWTVSKzI3Vnp5V1ZyL1I3WXR5Zm54WEtWRXdxdjI1SlNtSi9mSTdRVE1kaUg5cmdEZUtUd0lWN0NydFhlOWUyeGI1TUhwNysxVGhpOWNjNTcrNW4iLCJtYWMiOiJiOTViNTkwNTdmMGU4ZjFmOGI0NTEyMDA2N2JmNDQ0YTRmM2RmNzI5YmJhZmZiZDJlOTMyOTlkMjNjMjNlMDA5IiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 21:15:56 GMT; path=/; secure ◀XSRF-TOKEN=eyJpdiI6IjlaYkloS2ttN0hIK1p6WTVlWktIb0E9PSIsInZhbHVlIjoiWDBqeUcydG5xeGNkK1NDRGRCYkc1bEdYdWRpS0UzTFZSbGFTZUc3OHo0c3NUWTVSKzI3Vnp5V1ZyL1I3WXR5Zm54WEtWR ▶"
    1 => "laravel_session=eyJpdiI6Ind6bDF5VUkyT0VUdm9GUW5JMHBtQkE9PSIsInZhbHVlIjoiNldKU21QVTluV25PWFUrc2JyL1pEckhTbFV4R1kvblRHYzdTd0o0bEp5a0M0bmI0VDdoMVVZQWlhV0ErMjFuMWRYOUZlVEhYYXJJNzBVMEtQK1RKdU5JWWJWRFlYNHNwbXlhdXBYRVlOOGdBd2xNaWFvb3hMZ1MyTjVnNThINnQiLCJtYWMiOiI4NDk3ZjJmNjZhNzZkMzljNjRiM2NhYzA1OTY1MjE5YzFmNzFmMTU5OWMwMDA0ZjVkNmFjMzdmNzc4OGM1NmFkIiwidGFnIjoiIn0%3D; expires=Sun, 06-Apr-2025 21:15:56 GMT; path=/; httponly ◀laravel_session=eyJpdiI6Ind6bDF5VUkyT0VUdm9GUW5JMHBtQkE9PSIsInZhbHVlIjoiNldKU21QVTluV25PWFUrc2JyL1pEckhTbFV4R1kvblRHYzdTd0o0bEp5a0M0bmI0VDdoMVVZQWlhV0ErMjFuMWRY ▶"
  ]
]

session_attributes

  0 of 0   
array:3 [▼
  "_token" => "Oyfg6oaT5rjFKY0uT72iELOe1natJtX4AW7g9n7x"
  "_previous" => array:1 [▶
    "url" => "https://pingjob.com/jobs?category=63"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
]

AutoshowClear Show all

	Date ↕	Method	URL	Data
#1	2025-04-06 19:15:56	GET	/jobs?category=63	4 9 299

Search Jobs

Filter from the left sidebar to find your desired job

Filter Jobs

SQL Server DBA

SQL Server Developer

SQL DBA

SQL Server DBA

SQL Server DBA

SQL Developer

Database Developer

SQL Data and Analytics Specialist

Database Developer

SQL Database Administrator

Jobs by States

Jobs by City

1 x Booting (86.74%)	1.75s
1 x Application (13.26%)	268ms