Prowner

Villa Amarante availability

Available
Unavailable

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config
  userAgentb05bf0e30e46ca90cc89e68c707250a3
  time1614371130
  countdown10
- Auth
  redirect/users/login
====
Request
+
Request

Cake Params
- plugin(null)
- controllerproperties
- actionpublic_calendar
- named(empty)
- pass
  0villa-amarante
- slug399/villa-amarante
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- keys
  0slug
- options(empty)
- defaults
  controllerproperties
  actionpublic_calendar
  plugin(null)
- template/:slug/*
====

Sql Logs

default

Total Time: 25 ms
Total Queries: 11 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `Property`.`id`, `Property`.`public_url` FROM `prowner`.`properties` AS `Property` WHERE `public_url` IS NOT NULL	499	499	3
SELECT `Note`.`id`, `Note`.`user_id`, `Note`.`entity`, `Note`.`entity_id`, `Note`.`title`, `Note`.`note`, `Note`.`reminder`, `Note`.`reminder_date`, `Note`.`send_to_user`, `Note`.`created`, `Note`.`modified`, `Note`.`hasreminded`, `Note`.`read_only`, `User`.`id`, `User`.`parent_user_id`, `User`.`type`, `User`.`partner_id`, `User`.`first_name`, `User`.`surname`, `User`.`email`, `User`.`telephone`, `User`.`mobile`, `User`.`address_1`, `User`.`address_2`, `User`.`address_3`, `User`.`city`, `User`.`state`, `User`.`zip`, `User`.`password`, `User`.`persistent_login_cookie`, `User`.`authentication_token`, `User`.`is_administrator`, `User`.`created`, `User`.`modified`, `User`.`stripeid`, `User`.`stripesubid`, `User`.`company`, `User`.`trial_notification`, `User`.`country`, `User`.`timezone`, `User`.`company_name`, `User`.`company_url`, `User`.`company_logo`, `User`.`company_logo_footer`, `User`.`last_access`, (CONCAT(`User`.`first_name`, `User`.`surname`)) AS `User__fullname`, (CONCAT(`User`.`first_name`, `User`.`surname`, " (", `User`.`email`, ")")) AS `User__fullname_inc_email` FROM `prowner`.`notes` AS `Note` LEFT JOIN `prowner`.`users` AS `User` ON (`Note`.`user_id` = `User`.`id`) WHERE `Note`.`user_id` = '' AND `Note`.`entity` = 'properties' AND `Note`.`entity_id` = 'villa-amarante'	0	0	2	maybe slow
SELECT `Document`.`id`, `Document`.`user_id`, `Document`.`entity`, `Document`.`entity_id`, `Document`.`document_type_id`, `Document`.`title`, `Document`.`reference`, `Document`.`start`, `Document`.`end`, `Document`.`directory`, `Document`.`filename`, `Document`.`created`, `Document`.`modified`, `Document`.`notify`, `Document`.`send_to_user`, `Document`.`hasreminded`, `DocumentType`.`id`, `DocumentType`.`name`, `User`.`id`, `User`.`parent_user_id`, `User`.`type`, `User`.`partner_id`, `User`.`first_name`, `User`.`surname`, `User`.`email`, `User`.`telephone`, `User`.`mobile`, `User`.`address_1`, `User`.`address_2`, `User`.`address_3`, `User`.`city`, `User`.`state`, `User`.`zip`, `User`.`password`, `User`.`persistent_login_cookie`, `User`.`authentication_token`, `User`.`is_administrator`, `User`.`created`, `User`.`modified`, `User`.`stripeid`, `User`.`stripesubid`, `User`.`company`, `User`.`trial_notification`, `User`.`country`, `User`.`timezone`, `User`.`company_name`, `User`.`company_url`, `User`.`company_logo`, `User`.`company_logo_footer`, `User`.`last_access`, (CONCAT(`User`.`first_name`, `User`.`surname`)) AS `User__fullname`, (CONCAT(`User`.`first_name`, `User`.`surname`, " (", `User`.`email`, ")")) AS `User__fullname_inc_email` FROM `prowner`.`documents` AS `Document` LEFT JOIN `prowner`.`document_types` AS `DocumentType` ON (`Document`.`document_type_id` = `DocumentType`.`id`) LEFT JOIN `prowner`.`users` AS `User` ON (`Document`.`user_id` = `User`.`id`) WHERE `Document`.`user_id` = '' AND `Document`.`entity` = 'properties' AND `Document`.`entity_id` = 'villa-amarante'	0	0	2	maybe slow
SELECT `Properties`.`id`, `Properties`.`user_id`, `Properties`.`name`, `Properties`.`address_1`, `Properties`.`address_2`, `Properties`.`address_3`, `Properties`.`city`, `Properties`.`state`, `Properties`.`zip`, `Properties`.`rateband_id`, `Properties`.`currency_id`, `Properties`.`created`, `Properties`.`modified`, `Properties`.`default_check_in`, `Properties`.`default_check_out`, `Properties`.`public`, `Properties`.`public_url`, `Properties`.`country` FROM `prowner`.`properties` AS `Properties` WHERE `Properties`.`user_id` = '' ORDER BY `id` asc	0	0	2	maybe slow
SELECT `Property`.`id`, `Property`.`user_id`, `Property`.`name`, `Property`.`address_1`, `Property`.`address_2`, `Property`.`address_3`, `Property`.`city`, `Property`.`state`, `Property`.`zip`, `Property`.`rateband_id`, `Property`.`currency_id`, `Property`.`created`, `Property`.`modified`, `Property`.`default_check_in`, `Property`.`default_check_out`, `Property`.`public`, `Property`.`public_url`, `Property`.`country`, `User`.`id`, `User`.`parent_user_id`, `User`.`type`, `User`.`partner_id`, `User`.`first_name`, `User`.`surname`, `User`.`email`, `User`.`telephone`, `User`.`mobile`, `User`.`address_1`, `User`.`address_2`, `User`.`address_3`, `User`.`city`, `User`.`state`, `User`.`zip`, `User`.`password`, `User`.`persistent_login_cookie`, `User`.`authentication_token`, `User`.`is_administrator`, `User`.`created`, `User`.`modified`, `User`.`stripeid`, `User`.`stripesubid`, `User`.`company`, `User`.`trial_notification`, `User`.`country`, `User`.`timezone`, `User`.`company_name`, `User`.`company_url`, `User`.`company_logo`, `User`.`company_logo_footer`, `User`.`last_access`, (CONCAT(`User`.`first_name`, `User`.`surname`)) AS `User__fullname`, (CONCAT(`User`.`first_name`, `User`.`surname`, " (", `User`.`email`, ")")) AS `User__fullname_inc_email`, `Rateband`.`id`, `Rateband`.`property_id`, `Rateband`.`name`, `Rateband`.`start`, `Rateband`.`end`, `Rateband`.`value`, `Rateband`.`created`, `Rateband`.`modified`, `Currency`.`id`, `Currency`.`name`, `Currency`.`iso`, `Currency`.`symbol` FROM `prowner`.`properties` AS `Property` LEFT JOIN `prowner`.`users` AS `User` ON (`Property`.`user_id` = `User`.`id`) LEFT JOIN `prowner`.`ratebands` AS `Rateband` ON (`Property`.`rateband_id` = `Rateband`.`id`) LEFT JOIN `prowner`.`currencies` AS `Currency` ON (`Property`.`currency_id` = `Currency`.`id`) WHERE `public_url` = '399/villa-amarante' AND `public` = '1' LIMIT 1	1	1	3	maybe slow
SELECT `Booking`.`id`, `Booking`.`person_id`, `Booking`.`property_id`, `Booking`.`send_to_user`, `Booking`.`booking_status_id`, `Booking`.`client_name`, `Booking`.`total_value`, `Booking`.`hold_days`, `Booking`.`start`, `Booking`.`end`, `Booking`.`adults`, `Booking`.`children`, `Booking`.`details`, `Booking`.`private_details`, `Booking`.`special_requests`, `Booking`.`created`, `Booking`.`modified` FROM `prowner`.`bookings` AS `Booking` WHERE `Booking`.`property_id` = (264)	0	0	2	maybe slow
SELECT `Item`.`id`, `Item`.`property_id`, `Item`.`zone_id`, `Item`.`name`, `Item`.`acquisition_value`, `Item`.`acquisition_date`, `Item`.`created`, `Item`.`modified` FROM `prowner`.`items` AS `Item` WHERE `Item`.`property_id` = (264)	0	0	2	maybe slow
SELECT `Ratebands`.`id`, `Ratebands`.`property_id`, `Ratebands`.`name`, `Ratebands`.`start`, `Ratebands`.`end`, `Ratebands`.`value`, `Ratebands`.`created`, `Ratebands`.`modified` FROM `prowner`.`ratebands` AS `Ratebands` WHERE `Ratebands`.`property_id` = (264)	0	0	2	maybe slow
SELECT `Zone`.`id`, `Zone`.`property_id`, `Zone`.`name`, `Zone`.`created`, `Zone`.`modified` FROM `prowner`.`zones` AS `Zone` WHERE `Zone`.`property_id` = (264)	0	0	2	maybe slow
SELECT `CompanyPeopleProperty`.`id`, `CompanyPeopleProperty`.`person_id`, `CompanyPeopleProperty`.`company_id`, `CompanyPeopleProperty`.`property_id`, `CompanyPeopleProperty`.`zone_id` FROM `prowner`.`company_people_properties` AS `CompanyPeopleProperty` WHERE `CompanyPeopleProperty`.`property_id` = (264)	0	0	2	maybe slow
SELECT `Booking`.`id`, `Booking`.`person_id`, `Booking`.`property_id`, `Booking`.`send_to_user`, `Booking`.`booking_status_id`, `Booking`.`client_name`, `Booking`.`total_value`, `Booking`.`hold_days`, `Booking`.`start`, `Booking`.`end`, `Booking`.`adults`, `Booking`.`children`, `Booking`.`details`, `Booking`.`private_details`, `Booking`.`special_requests`, `Booking`.`created`, `Booking`.`modified`, `Property`.`id`, `Property`.`user_id`, `Property`.`name`, `Property`.`address_1`, `Property`.`address_2`, `Property`.`address_3`, `Property`.`city`, `Property`.`state`, `Property`.`zip`, `Property`.`rateband_id`, `Property`.`currency_id`, `Property`.`created`, `Property`.`modified`, `Property`.`default_check_in`, `Property`.`default_check_out`, `Property`.`public`, `Property`.`public_url`, `Property`.`country`, `BookingStatus`.`id`, `BookingStatus`.`name`, `BookingStatus`.`background_colour`, `BookingStatus`.`border_colour`, `BookingStatus`.`text_colour`, `Person`.`id`, `Person`.`user_id`, `Person`.`first_name`, `Person`.`surname`, `Person`.`email`, `Person`.`email_alt`, `Person`.`telephone`, `Person`.`telephone_alt`, `Person`.`mobile`, `Person`.`address_1`, `Person`.`address_2`, `Person`.`address_3`, `Person`.`city`, `Person`.`state`, `Person`.`zip`, `Person`.`person_type_id`, `Person`.`role`, `Person`.`created`, `Person`.`modified` FROM `prowner`.`bookings` AS `Booking` LEFT JOIN `prowner`.`properties` AS `Property` ON (`Booking`.`property_id` = `Property`.`id`) LEFT JOIN `prowner`.`booking_statuses` AS `BookingStatus` ON (`Booking`.`booking_status_id` = `BookingStatus`.`id`) LEFT JOIN `prowner`.`people` AS `Person` ON (`Booking`.`person_id` = `Person`.`id`) WHERE `property_id` = 264	0	0	3	maybe slow

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Timer

Memory

Peak Memory Use 5.13 MB

Message	Memory use
Component initialization	2.14 MB
Controller action start	2.89 MB
Controller render start	3.75 MB
View render complete	4.07 MB

Timers

Total Request Time: 182 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	41.56
Event: Controller.initialize	41.54
Event: Controller.startup	1.35
Controller action	65.18
Event: Controller.beforeRender	10.03
» Processing toolbar data	9.69
Rendering View	3.58
» Event: View.beforeRender	0.05
» Rendering APP/View/Properties/public_calendar.ctp	0.13
» Event: View.afterRender	0.04
» Event: View.beforeLayout	0.04
» Rendering APP/View/Themed/Cakestrap/Layouts/public.ctp	2.12
» » Rendering APP/View/Themed/Cakestrap/Elements/dochead.ctp	1.42
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- property
  Property
  id264
  user_id399
  nameVilla Amarante
  address_114 G North Slob
  address_2
  address_3(null)
  cityChristiansted
  stateSt. Croix, VI
  zip00820
  rateband_id(null)
  currency_id3
  created2017-05-02 21:12:25
  modified2017-05-02 21:12:25
  default_check_in15:30
  default_check_out11:00
  public(true)
  public_url399/villa-amarante
  country(null)
  User
  id(null)
  parent_user_id(null)
  type(null)
  partner_id(null)
  first_name(null)
  surname(null)
  email(null)
  telephone(null)
  mobile(null)
  address_1(null)
  address_2(null)
  address_3(null)
  city(null)
  state(null)
  zip(null)
  password(null)
  persistent_login_cookie(null)
  authentication_token(null)
  is_administrator(null)
  created(null)
  modified(null)
  stripeid(null)
  stripesubid(null)
  company(null)
  trial_notification(null)
  country(null)
  timezone(null)
  company_name(null)
  company_url(null)
  company_logo(null)
  company_logo_footer(null)
  last_access(null)
  fullname(null)
  fullname_inc_email(null)
  Rateband
  id(null)
  property_id(null)
  name(null)
  start(null)
  end(null)
  value(null)
  created(null)
  modified(null)
  Currency
  id3
  nameUnited States Dollar
  isoUSD
  symbol$
  Booking(empty)
  Item(empty)
  Ratebands(empty)
  Zone(empty)
  CompanyPeopleProperty(empty)
- bookingsJson[]
- bookings(empty)
- property_currency£
- session_property(null)
- user_properties(empty)
- associated_documents(empty)
- associated_notes(empty)
- isLocal(false)
- authuser(null)
- title_for_layoutProwner
- $request->data(empty)
- $this->validationErrors
  Property(empty)
  Note(empty)
  User(empty)
  NoteNotification(empty)
  Document(empty)
  DocumentType(empty)
  DocumentNotification(empty)
  Properties(empty)
  Rateband(empty)
  Currency(empty)
  Booking(empty)
  Item(empty)
  Ratebands(empty)
  Zone(empty)
  CompanyPeopleProperty(empty)
  BookingStatus(empty)
  Person(empty)
- Loaded Helpers
  0Number
  1SimpleGraph
  2DebugTimer
  3Toolbar
  4Html
  5HtmlToolbar
  6Form
====

Environment

App Constants

Constant	Value
CONFIG	/var/www/vhosts/app.prowner.com/public_html/app/Config/
LOGGED_IN_USER_NAME
LOGGED_IN_USER_ID

CakePHP Constants

Constant	Value
APP	/var/www/vhosts/app.prowner.com/public_html/app/
APP_DIR	app
APPLIBS	/var/www/vhosts/app.prowner.com/public_html/app/Lib/
CACHE	/var/www/vhosts/app.prowner.com/public_html/app/tmp/cache/
CAKE	/var/www/vhosts/app.prowner.com/public_html/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/var/www/vhosts/app.prowner.com/public_html/lib
CORE_PATH	/var/www/vhosts/app.prowner.com/public_html/lib/
CAKE_VERSION	2.10.13
CSS	/var/www/vhosts/app.prowner.com/public_html/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	https://app.prowner.com
IMAGES	/var/www/vhosts/app.prowner.com/public_html/app/webroot/img/
IMAGES_URL	img/
JS	/var/www/vhosts/app.prowner.com/public_html/app/webroot/js/
JS_URL	js/
LOGS	/var/www/vhosts/app.prowner.com/public_html/app/tmp/logs/
ROOT	/var/www/vhosts/app.prowner.com/public_html
TESTS	/var/www/vhosts/app.prowner.com/public_html/app/Test/
TMP	/var/www/vhosts/app.prowner.com/public_html/app/tmp/
VENDORS	/var/www/vhosts/app.prowner.com/public_html/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/var/www/vhosts/app.prowner.com/public_html/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	5.6.40-30+ubuntu16.04.1+deb.sury.org+1
Redirect Redirect Script Url	/399/villa-amarante
Redirect Redirect Script Uri	https://app.prowner.com/399/villa-amarante
Redirect Redirect Https	on
Redirect Redirect Ssl Tls Sni	app.prowner.com
Redirect Redirect Status	200
Redirect Script Url	/399/villa-amarante
Redirect Script Uri	https://app.prowner.com/399/villa-amarante
Redirect Https	on
Redirect Ssl Tls Sni	app.prowner.com
Redirect Status	200
Script Url	/399/villa-amarante
Script Uri	https://app.prowner.com/399/villa-amarante
Https	on
Ssl Tls Sni	app.prowner.com
Http User Agent	CCBot/2.0 (https://commoncrawl.org/faq/)
Http Accept	text/html,application/xhtml+xml,application/xml;q=0.9,/;q=0.8
Http Accept Language	en-US,en;q=0.5
Http If Modified Since	Fri, 18 Sep 2020 17:18:17 GMT
Http Accept Encoding	br,gzip
Http Host	app.prowner.com
Http Connection	Keep-Alive
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
Server Signature	Apache/2.4.18 (Ubuntu) Server at app.prowner.com Port 443
Server Software	Apache/2.4.18 (Ubuntu)
Server Name	app.prowner.com
Server Addr	134.213.167.41
Server Port	443
Remote Addr	54.236.58.220
Document Root	/var/www/vhosts/app.prowner.com/public_html
Request Scheme	https
Context Prefix
Context Document Root	/var/www/vhosts/app.prowner.com/public_html
Server Admin	info@rifledesign.co.uk
Script Filename	/var/www/vhosts/app.prowner.com/public_html/app/webroot/index.php
Remote Port	58390
Redirect Url	/app/webroot/399/villa-amarante
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.1
Request Method	GET
Query String
Request Uri	/399/villa-amarante
Script Name	/app/webroot/index.php
Php Self	/app/webroot/index.php
Request Time Float	1614365730.031
Request Time	1614365730

====

Include
+
Included Files

Include Paths
- 0/var/www/vhosts/app.prowner.com/public_html/lib
- 2/usr/share/php
- 3-> /var/www/vhosts/app.prowner.com/public_html/lib/Cake/
Included Files
- core
  Cache
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component
  0CORE/Controller/Component/SessionComponent.php
  1CORE/Controller/Component/EmailComponent.php
  2CORE/Controller/Component/CookieComponent.php
  3CORE/Controller/Component/RequestHandlerComponent.php
  4CORE/Controller/Component/AuthComponent.php
  5CORE/Controller/Component/Auth/FormAuthenticate.php
  6CORE/Controller/Component/Auth/BaseAuthenticate.php
  Config
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Configure
  0CORE/Configure/PhpReader.php
  1CORE/Configure/ConfigReaderInterface.php
  Controller
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource
  0CORE/Model/Datasource/Database/Mysql.php
  1CORE/Model/Datasource/DboSource.php
  2CORE/Model/Datasource/DataSource.php
  3CORE/Model/Datasource/CakeSession.php
  Error
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ConnectionManager.php
  Network
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/CakeObject.php
  Routing
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/CakeText.php
  5CORE/Utility/ClassRegistry.php
  View
  0CORE/View/HelperCollection.php
- app
  Config
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/appConfig.php
  3APP/Config/routes.php
  4APP/Config/database.php
  Controller
  0APP/Controller/PropertiesController.php
  1APP/Controller/AppController.php
  Model
  0APP/Model/Property.php
  1APP/Model/AppModel.php
  2APP/Model/Note.php
  3APP/Model/User.php
  4APP/Model/NoteNotification.php
  5APP/Model/Document.php
  6APP/Model/DocumentType.php
  7APP/Model/DocumentNotification.php
  8APP/Model/Rateband.php
  9APP/Model/Currency.php
  10APP/Model/Booking.php
  11APP/Model/Item.php
  12APP/Model/Zone.php
  13APP/Model/CompanyPeopleProperty.php
  14APP/Model/BookingStatus.php
  15APP/Model/Person.php
  Other
  0APP/webroot/index.php
  1APP/vendor/autoload.php
  2APP/vendor/composer/autoload_real.php
  3APP/vendor/composer/ClassLoader.php
  4APP/vendor/composer/autoload_static.php
  5APP/Lib/PropertySlugRoute.php
- plugins
  DebugKit
  Component
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
====

Villa Amarante availability

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 25 ms Total Queries: 11 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 25 ms
Total Queries: 11 queries