Vacation Rental

info@freezylist.com

Search Property

List View Map View

1. Select The Property Type

2. Choose A Continent

3. Focus Your Search Area

4. Select A Country In Your Region

(Optional). Narrow Your International Search

5. Travelling Within the USA? (Choose a State)

(Optional). Narrow Your US Vacation Search Results

Advanced Filters (Optional)

Availability

Price Range

(Optional): Explore Other Search Options

Results Per Page

LESS FILTERS ADVANCED FILTERS START OVER

Messages Timeline Exceptions Views6 Route Queries2 Mails Auth Gate Session Request

29.25ms2MBGET property/vacation/search

Booting (16.61ms)
Application (21.71ms)

6 templates were rendered

frontend.property.vacation_search (resources/views/frontend/property/vacation_search.blade.php)2blade
Params
0
regions
1
subRegions
frontend.layouts.app (resources/views/frontend/layouts/app.blade.php)14blade
Params
0
obLevel
1
__env
2
app
3
errors
4
regions
5
subRegions
6
logged_in_user
7
region
8
key
9
sRegion
10
__currentLoopData
11
bed
12
loop
13
bath
includes.partials.logged-in-as (resources/views/includes/partials/logged-in-as.blade.php)14blade
Params
0
obLevel
1
__env
2
app
3
errors
4
regions
5
subRegions
6
logged_in_user
7
region
8
key
9
sRegion
10
__currentLoopData
11
bed
12
loop
13
bath
frontend.includes.header (resources/views/frontend/includes/header.blade.php)14blade
Params
0
obLevel
1
__env
2
app
3
errors
4
regions
5
subRegions
6
logged_in_user
7
region
8
key
9
sRegion
10
__currentLoopData
11
bed
12
loop
13
bath
includes.partials.messages (resources/views/includes/partials/messages.blade.php)14blade
Params
0
obLevel
1
__env
2
app
3
errors
4
regions
5
subRegions
6
logged_in_user
7
region
8
key
9
sRegion
10
__currentLoopData
11
bed
12
loop
13
bath
frontend.includes.footer (resources/views/frontend/includes/footer.blade.php)14blade
Params
0
obLevel
1
__env
2
app
3
errors
4
regions
5
subRegions
6
logged_in_user
7
region
8
key
9
sRegion
10
__currentLoopData
11
bed
12
loop
13
bath

uri: GET property/vacation/search
middleware: web
controller: App\Http\Controllers\Frontend\PropertyController@vacationSearch
as: frontend.vacationSearch
namespace: App\Http\Controllers\Frontend
prefix: null
where
file: app/Http/Controllers/Frontend/PropertyController.php:1252-1258

2 statements were executed4.13ms

select * from `regions`3.05ms/app/Http/Controllers/Frontend/PropertyController.php:1254freezylist

Metadata
Hints	Use `SELECT *` only if you need all columns from table The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	14. /app/Http/Controllers/Frontend/PropertyController.php:1254 22. /app/Http/Middleware/LocaleMiddleware.php:57 67. /public/index.php:52

- EXPLAIN #1: `regions` (SIMPLE)71
Metadata
id 1
select_type SIMPLE
table regions
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 7
filtered 100
Extra null

select * from `sub_regions`1.08ms/app/Http/Controllers/Frontend/PropertyController.php:1255freezylist

Metadata
Hints	Use `SELECT *` only if you need all columns from table The `SELECT` statement has no `WHERE` clause and could examine many more rows than intended
Backtrace	14. /app/Http/Controllers/Frontend/PropertyController.php:1255 22. /app/Http/Middleware/LocaleMiddleware.php:57 67. /public/index.php:52

- EXPLAIN #1: `sub_regions` (SIMPLE)161
Metadata
id 1
select_type SIMPLE
table sub_regions
partitions null
type ALL
possible_keys null
key null
key_len null
ref null
rows 16
filtered 100
Extra null

web: array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]
api: array:2 [ "name" => "Guest" "user" => array:1 [ "guest" => true ] ]

_token: bSH7pL7MS1gBKxf7z3zntVx9079yljxzgypvCOW8
_previous: array:1 [ "url" => "https://freezylist.lusites.xyz/property/vacation/search" ]
PHPDEBUGBAR_STACK_DATA: []

format: html
content_type: text/html; charset=UTF-8
status_text: OK
status_code: 200
request_query: []
request_request: []
request_headers: array:17 [ "priority" => array:1 [ 0 => "u=0, i" ] "accept-encoding" => array:1 [ 0 =>...
request_server: array:40 [ "USER" => "freezylist" "HOME" => "/home/freezylist" "HTTP_PRIORITY" => "u=0, i" "...
request_cookies: []
response_headers: array:5 [ "cache-control" => array:1 [ 0 => "no-cache, private" ] "date" => array:1 [ ...
path_info: /property/vacation/search
session_attributes: array:3 [ "_token" => "bSH7pL7MS1gBKxf7z3zntVx9079yljxzgypvCOW8" "_previous" => array:1 [ "u...