Groomup

Messages Timeline Exceptions Views2 Route Queries1 Models0 Mails Gate Session Request

7.4.33128ms17MBGET salons/city

Booting (93.29ms)
Application (33.08ms)
1 x Booting (72.68%)
93.29ms
1 x Application (25.78%)
33.08ms

2 templates were rendered

demo.salons (resources/views/demo/salons.blade.php)1blade
Params
0
shops
includes.home-menu (resources/views/includes/home-menu.blade.php)4blade
Params
0
__env
1
app
2
errors
3
shops

Params
0	`shops`

Params
0	`__env`
1	`app`
2	`errors`
3	`shops`

uri: GET salons/city
middleware: web
controller: App\Http\Controllers\LandingPageController@salonByCity
namespace
prefix
where
file: app/Http/Controllers/LandingPageController.php:125-137

1 statements were executed1.18ms

select `shops`.*, (select count(*) from `salon_reviews` where `shops`.`id` = `salon_reviews`.`salon_id`) as `reviews_count` from `shops` where `address` LIKE '%Peshawar%' and `status` = 1

1.18ms/app/Http/Controllers/LandingPageController.php:134groomup_v1

Metadata
Bindings	0. %Peshawar% 1. 1
Backtrace	14. /app/Http/Controllers/LandingPageController.php:134 15. /vendor/laravel/framework/src/Illuminate/Routing/Controller.php:54 16. /vendor/laravel/framework/src/Illuminate/Routing/ControllerDispatcher.php:45 17. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:254 18. /vendor/laravel/framework/src/Illuminate/Routing/Route.php:197

_token: vncCWPDIk1dYTnm9pg9WJBsXaeC6sxnoZo8Z7z8s
_previous: array:1 [ "url" => "https://groomup.pk/salons/city?location=Peshawar" ]
_flash: array:2 [ "old" => [] "new" => [] ]
PHPDEBUGBAR_STACK_DATA: []

path_info

/salons/city

status_code

status_text

format

html

content_type

text/html; charset=UTF-8

request_query

  0 of 0   
array:1 [▼
  "location" => "Peshawar"
]

request_request

  0 of 0   
array:1 [▼
  "location" => "Peshawar"
]

request_headers

  0 of 0   
array:15 [▼
  "accept-encoding" => array:1 [▶
    0 => "gzip, deflate, br, zstd"
  ]
  "sec-fetch-dest" => array:1 [▶
    0 => "document"
  ]
  "sec-fetch-user" => array:1 [▶
    0 => "?1"
  ]
  "sec-fetch-mode" => array:1 [▶
    0 => "navigate"
  ]
  "sec-fetch-site" => array:1 [▶
    0 => "none"
  ]
  "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"
  ]
  "user-agent" => array:1 [▶
    0 => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  ]
  "upgrade-insecure-requests" => array:1 [▶
    0 => "1"
  ]
  "sec-ch-ua-platform" => array:1 [▶
    0 => ""Windows""
  ]
  "sec-ch-ua-mobile" => array:1 [▶
    0 => "?0"
  ]
  "sec-ch-ua" => array:1 [▶
    0 => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache"
  ]
  "pragma" => array:1 [▶
    0 => "no-cache"
  ]
  "connection" => array:1 [▶
    0 => "keep-alive"
  ]
  "host" => array:1 [▶
    0 => "groomup.pk"
  ]
]

request_server

  0 of 0   
array:51 [▼
  "USER" => "www-data"
  "HOME" => "/var/www"
  "SCRIPT_NAME" => "/index.php"
  "REQUEST_URI" => "/salons/city?location=Peshawar"
  "QUERY_STRING" => "location=Peshawar"
  "REQUEST_METHOD" => "GET"
  "SERVER_PROTOCOL" => "HTTP/1.1"
  "GATEWAY_INTERFACE" => "CGI/1.1"
  "REDIRECT_QUERY_STRING" => "location=Peshawar"
  "REDIRECT_URL" => "/salons/city"
  "REMOTE_PORT" => "48768"
  "SCRIPT_FILENAME" => "/var/www/html/groomup.xintsolutions.com/public/index.php"
  "SERVER_ADMIN" => "zeeshan.khalid@xintsolutions.com"
  "CONTEXT_DOCUMENT_ROOT" => "/var/www/html/groomup.xintsolutions.com/public"
  "CONTEXT_PREFIX" => ""
  "REQUEST_SCHEME" => "https"
  "DOCUMENT_ROOT" => "/var/www/html/groomup.xintsolutions.com/public"
  "REMOTE_ADDR" => "3.147.76.86"
  "SERVER_PORT" => "443"
  "SERVER_ADDR" => "78.46.88.51"
  "SERVER_NAME" => "groomup.pk"
  "SERVER_SOFTWARE" => " "
  "SERVER_SIGNATURE" => "<address>  Server at groomup.pk Port 443</address>\n"
  "PATH" => "/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin"
  "HTTP_ACCEPT_ENCODING" => "gzip, deflate, br, zstd"
  "HTTP_SEC_FETCH_DEST" => "document"
  "HTTP_SEC_FETCH_USER" => "?1"
  "HTTP_SEC_FETCH_MODE" => "navigate"
  "HTTP_SEC_FETCH_SITE" => "none"
  "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_USER_AGENT" => "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)"
  "HTTP_UPGRADE_INSECURE_REQUESTS" => "1"
  "HTTP_SEC_CH_UA_PLATFORM" => ""Windows""
  "HTTP_SEC_CH_UA_MOBILE" => "?0"
  "HTTP_SEC_CH_UA" => ""Chromium";v="130", "HeadlessChrome";v="130", "Not?A_Brand";v="99""
  "HTTP_CACHE_CONTROL" => "no-cache"
  "HTTP_PRAGMA" => "no-cache"
  "HTTP_CONNECTION" => "keep-alive"
  "HTTP_HOST" => "groomup.pk"
  "proxy-nokeepalive" => "1"
  "SSL_TLS_SNI" => "groomup.pk"
  "HTTPS" => "on"
  "UNIQUE_ID" => "aD3quTFoTv36ZIE65D2ZawAAAEY"
  "REDIRECT_STATUS" => "200"
  "REDIRECT_SSL_TLS_SNI" => "groomup.pk"
  "REDIRECT_HTTPS" => "on"
  "REDIRECT_UNIQUE_ID" => "aD3quTFoTv36ZIE65D2ZawAAAEY"
  "FCGI_ROLE" => "RESPONDER"
  "PHP_SELF" => "/index.php"
  "REQUEST_TIME_FLOAT" => 1748888249.732
  "REQUEST_TIME" => 1748888249
]

request_cookies

[]

response_headers

  0 of 0   
array:5 [▼
  "content-type" => array:1 [▶
    0 => "text/html; charset=UTF-8"
  ]
  "cache-control" => array:1 [▶
    0 => "no-cache, private"
  ]
  "date" => array:1 [▶
    0 => "Mon, 02 Jun 2025 18:17:29 GMT"
  ]
  "set-cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImJzYWFxckc0bS9CYXVJZWxaVS96b2c9PSIsInZhbHVlIjoiaXoxSW1nOXhtdmdtek4xd1ZJYW9rSFlONVZOTFg3dFIzRWVxSnVIdGdPdDVrRjhNektVSXFxNnJrNjFRN25pamRIM1dtSDZRWVJ5WncvTHRuU1FvZFR2ellZMGNyMjd0YVc2aHNFbUR0L1pncktjbjZQOGRra3M4ODY5eUNSMW0iLCJtYWMiOiI4NzdmM2QzOTk0N2JjZDkwNzhmNjIzYTVhYjk5MGQzNjJhYWZkNzBiOWZkYjYwZmMxY2ExM2ZmZWJkMDdkMmI4In0%3D; expires=Mon, 02-Jun-2025 20:17:29 GMT; Max-Age=7200; path=/; samesite=lax ◀XSRF-TOKEN=eyJpdiI6ImJzYWFxckc0bS9CYXVJZWxaVS96b2c9PSIsInZhbHVlIjoiaXoxSW1nOXhtdmdtek4xd1ZJYW9rSFlONVZOTFg3dFIzRWVxSnVIdGdPdDVrRjhNektVSXFxNnJrNjFRN25pamRIM1dtS ▶"
    1 => "groomup_session=eyJpdiI6Ikt2Z0dnVVJ5bXd2dWpvcTVTUUN1U2c9PSIsInZhbHVlIjoiR09rR3kvYmdDdFdCanBIRnRNZVRUREZ6Sk8yaURSQWM1RnY1aTlFU0NFZjBzeVZjbDJHVS82a3ZvRlpOUmRKcTRUZDZFeEowK3B3WStSeVVTb3RhVWpvZGpIUnFIRkZ3MG0xQ3FVK3NQbkRqUlhqeUlkT2kwM3NNUElIcFNtZG0iLCJtYWMiOiI2MWY4NmFlZWM1ODNmZTNmNWVmMjlkN2Q3MGNiNDE5OGFhMjU5YWZiYjM5OTA2Nzk4MDQ0NGZhMGFjNzBhZWUwIn0%3D; expires=Mon, 02-Jun-2025 20:17:29 GMT; Max-Age=7200; path=/; httponly; samesite=lax ◀groomup_session=eyJpdiI6Ikt2Z0dnVVJ5bXd2dWpvcTVTUUN1U2c9PSIsInZhbHVlIjoiR09rR3kvYmdDdFdCanBIRnRNZVRUREZ6Sk8yaURSQWM1RnY1aTlFU0NFZjBzeVZjbDJHVS82a3ZvRlpOUmRKcTRU ▶"
  ]
  "Set-Cookie" => array:2 [▶
    0 => "XSRF-TOKEN=eyJpdiI6ImJzYWFxckc0bS9CYXVJZWxaVS96b2c9PSIsInZhbHVlIjoiaXoxSW1nOXhtdmdtek4xd1ZJYW9rSFlONVZOTFg3dFIzRWVxSnVIdGdPdDVrRjhNektVSXFxNnJrNjFRN25pamRIM1dtSDZRWVJ5WncvTHRuU1FvZFR2ellZMGNyMjd0YVc2aHNFbUR0L1pncktjbjZQOGRra3M4ODY5eUNSMW0iLCJtYWMiOiI4NzdmM2QzOTk0N2JjZDkwNzhmNjIzYTVhYjk5MGQzNjJhYWZkNzBiOWZkYjYwZmMxY2ExM2ZmZWJkMDdkMmI4In0%3D; expires=Mon, 02-Jun-2025 20:17:29 GMT; path=/ ◀XSRF-TOKEN=eyJpdiI6ImJzYWFxckc0bS9CYXVJZWxaVS96b2c9PSIsInZhbHVlIjoiaXoxSW1nOXhtdmdtek4xd1ZJYW9rSFlONVZOTFg3dFIzRWVxSnVIdGdPdDVrRjhNektVSXFxNnJrNjFRN25pamRIM1dtS ▶"
    1 => "groomup_session=eyJpdiI6Ikt2Z0dnVVJ5bXd2dWpvcTVTUUN1U2c9PSIsInZhbHVlIjoiR09rR3kvYmdDdFdCanBIRnRNZVRUREZ6Sk8yaURSQWM1RnY1aTlFU0NFZjBzeVZjbDJHVS82a3ZvRlpOUmRKcTRUZDZFeEowK3B3WStSeVVTb3RhVWpvZGpIUnFIRkZ3MG0xQ3FVK3NQbkRqUlhqeUlkT2kwM3NNUElIcFNtZG0iLCJtYWMiOiI2MWY4NmFlZWM1ODNmZTNmNWVmMjlkN2Q3MGNiNDE5OGFhMjU5YWZiYjM5OTA2Nzk4MDQ0NGZhMGFjNzBhZWUwIn0%3D; expires=Mon, 02-Jun-2025 20:17:29 GMT; path=/; httponly ◀groomup_session=eyJpdiI6Ikt2Z0dnVVJ5bXd2dWpvcTVTUUN1U2c9PSIsInZhbHVlIjoiR09rR3kvYmdDdFdCanBIRnRNZVRUREZ6Sk8yaURSQWM1RnY1aTlFU0NFZjBzeVZjbDJHVS82a3ZvRlpOUmRKcTRU ▶"
  ]
]

session_attributes

  0 of 0   
array:4 [▼
  "_token" => "vncCWPDIk1dYTnm9pg9WJBsXaeC6sxnoZo8Z7z8s"
  "_previous" => array:1 [▶
    "url" => "https://groomup.pk/salons/city?location=Peshawar"
  ]
  "_flash" => array:2 [▶
    "old" => []
    "new" => []
  ]
  "PHPDEBUGBAR_STACK_DATA" => []
]

1 x Booting (72.68%)	93.29ms
1 x Application (25.78%)	33.08ms

Salons