Condo Purchase #33

History
+
Request History
4 previous requests available
====
Session
+
Session
- Config(array)
  userAgent16b8cd1ceede409b1a452a9019b512ab
  time1715042853
  countdown10
- country(array)
  id2
  currency(array)
  exchange_rate1.2195
  codeKYD
  symbol_postions0
  nameCayman
  slugcayman-islands
  timezoneEST
====
Request
+
Request

Cake Params
- pluginproject
- controllerprojects
- actionsingle_project_listing
- named(empty)
- pass(array)
  0condo-purchase-33
  1directory
Post data

No post data.

Query string

No querystring data.

Cookie
- 0(empty)
Current Route
- keys(empty)
- options(empty)
- defaults(array)
  pluginproject
  controllerprojects
  actionsingle_project_listing
- template/project-list/*
====

Sql Logs

default

Total Time: 852 ms
Total Queries: 14 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `StaticPage`.`slug` FROM `demoe3_getezquotes`.`static_pages` AS `StaticPage` WHERE 1 = 1	30	30	0
SELECT `Country`.`slug` FROM `demoe3_getezquotes`.`countries` AS `Country` WHERE 1 = 1	15	15	0
SELECT `Country`.`slug`, `Country`.`name`, `Country`.`id`, `Country`.`timezone` FROM `demoe3_getezquotes`.`countries` AS `Country` WHERE `is_default` = 1 ORDER BY `country_order` ASC, `name` ASC LIMIT 1	1	1	0
SELECT `CurrencyCountry`.`currency_id`, `Currency`.`exchange_rate`, `Currency`.`code`, `Currency`.`symbol_postions` FROM `demoe3_getezquotes`.`currency_countries` AS `CurrencyCountry` LEFT JOIN `demoe3_getezquotes`.`currencies` AS `Currency` ON (`CurrencyCountry`.`currency_id` = `Currency`.`id`) WHERE `CurrencyCountry`.`country_id` = 2 LIMIT 1	1	1	0
SELECT `Project`.`id`, `Project`.`category_id`, `Project`.`slug`, `Project`.`name`, `Project`.`is_deleted`, `Project`.`created`, `Project`.`show_name`, `Project`.`alias_name`, `Project`.`country_id`, `Project`.`is_admin_approved`, `Project`.`user_id`, `Project`.`running_status`, `Project`.`level_of_urgency`, `Project`.`due_date`, `Project`.`anticipated_start_date`, `Project`.`postal_code`, `Project`.`city_name`, `Project`.`meet_day`, `Project`.`additional_information`, `Project`.`meeting`, `Project`.`description`, `Project`.`project_documents_link`, `QuoteType`.`name`, `QuoteType`.`slug`, `Country`.`name`, `Category`.`name`, `User`.`first_name`, `User`.`country_id`, `User`.`profile_image`, `User`.`last_name`, `User`.`show_name`, `Project`.`job_start`, `Project`.`business_contact`, `Project`.`contact_specific_time`, `Project`.`contact_time`, `Project`.`show_contact_info`, `Project`.`project_status_question`, `Project`.`status`, `Project`.`posted_on`, `User`.`email`, `User`.`username`, `User`.`contact_number`, `Category`.`is_allow_multiple` FROM `demoe3_getezquotes`.`projects` AS `Project` LEFT JOIN `demoe3_getezquotes`.`countries` AS `Country` ON (`Project`.`country_id` = `Country`.`id`) LEFT JOIN `demoe3_getezquotes`.`categories` AS `Category` ON (`Project`.`category_id` = `Category`.`id`) LEFT JOIN `demoe3_getezquotes`.`quote_types` AS `QuoteType` ON (`Project`.`quote_type` = `QuoteType`.`id`) LEFT JOIN `demoe3_getezquotes`.`users` AS `User` ON (`Project`.`user_id` = `User`.`id`) WHERE `Project`.`slug` = 'condo-purchase-33' AND `Project`.`status` = 1 AND `Project`.`is_admin_approved` = 1 AND `Project`.`is_posted` = 1 AND `Project`.`is_deleted` = 0 AND `Project`.`country_id` = 2 AND `User`.`is_deleted` = 0 AND `User`.`is_blocked` = 0 LIMIT 1	1	1	544	maybe slow
SELECT `ProjectAttachment`.`id`, `ProjectAttachment`.`project_id`, `ProjectAttachment`.`user_id`, `ProjectAttachment`.`attachment`, `ProjectAttachment`.`attachment_file_name`, `ProjectAttachment`.`created`, `ProjectAttachment`.`modified` FROM `demoe3_getezquotes`.`project_attachments` AS `ProjectAttachment` WHERE `ProjectAttachment`.`project_id` = (27)	0	0	29	maybe slow
SELECT `ProjectCategoryOption`.`id`, `ProjectCategoryOption`.`project_id`, `ProjectCategoryOption`.`project_question`, `ProjectCategoryOption`.`selected_option`, `ProjectCategoryOption`.`field_name`, `ProjectCategoryOption`.`text_field_type`, `ProjectCategoryOption`.`project_question_id`, `ProjectCategoryOption`.`selected_option_id`, `ProjectCategoryOption`.`sensitive_information`, `ProjectCategoryOption`.`project_question_order`, `ProjectCategoryOption`.`created`, `ProjectCategoryOption`.`modified` FROM `demoe3_getezquotes`.`project_category_options` AS `ProjectCategoryOption` WHERE `ProjectCategoryOption`.`project_id` = (27) ORDER BY `ProjectCategoryOption`.`project_question_order` ASC	10	10	47	maybe slow
SELECT `Quote`.`id`, `Quote`.`user_id`, `Quote`.`psps_id`, `Quote`.`project_id`, `Quote`.`project_category_id`, `Quote`.`user_purchased_plan_id`, `Quote`.`quote_type`, `Quote`.`intro`, `Quote`.`full_cost`, `Quote`.`payment_terms`, `Quote`.`contingencies`, `Quote`.`full_cost_description`, `Quote`.`variance_description`, `Quote`.`fee_for_services`, `Quote`.`service_description`, `Quote`.`labour_cost`, `Quote`.`materials_cost`, `Quote`.`equipment_cost`, `Quote`.`labour_cost_description`, `Quote`.`materials_cost_description`, `Quote`.`equipment_cost_description`, `Quote`.`variable_range_description`, `Quote`.`low_range_amount`, `Quote`.`high_range_amount`, `Quote`.`psps_introduction`, `Quote`.`project_proposal`, `Quote`.`quote_status`, `Quote`.`award_date`, `Quote`.`is_reviewed`, `Quote`.`consumer_review_posted`, `Quote`.`hourly_rate_charges`, `Quote`.`total_cost`, `Quote`.`total_cost_usd`, `Quote`.`currency_code`, `Quote`.`conversion_currency`, `Quote`.`conversion_rate`, `Quote`.`time_to_completion`, `Quote`.`status`, `Quote`.`is_read`, `Quote`.`is_deleted`, `Quote`.`created`, `Quote`.`modified`, `Project`.`id`, `Project`.`user_id`, `Project`.`name`, `Project`.`slug`, `Project`.`country_id`, `Project`.`postal_code`, `Project`.`city_name`, `Project`.`city_id`, `Project`.`project_type`, `Project`.`category_id`, `Project`.`quote_type`, `Project`.`due_date`, `Project`.`anticipated_start_date`, `Project`.`project_acceptance_due_date`, `Project`.`start_date`, `Project`.`award_date`, `Project`.`expiry_date`, `Project`.`close_date`, `Project`.`estimated_date`, `Project`.`completed_date`, `Project`.`canceled_date`, `Project`.`decline_date`, `Project`.`job_start`, `Project`.`project_documents_link`, `Project`.`description`, `Project`.`attachments_file_name`, `Project`.`attachments`, `Project`.`level_of_urgency`, `Project`.`meeting`, `Project`.`meet_day`, `Project`.`business_contact`, `Project`.`contact_specific_time`, `Project`.`contact_time`, `Project`.`show_contact_info`, `Project`.`show_name`, `Project`.`alias_name`, `Project`.`is_admin_approved`, `Project`.`posted_on`, `Project`.`approval_date`, `Project`.`status`, `Project`.`is_deleted`, `Project`.`deleted_date`, `Project`.`is_posted`, `Project`.`running_status`, `Project`.`decline_reason`, `Project`.`created`, `Project`.`modified`, `Project`.`project_status_question`, `Project`.`additional_information`, `Project`.`project_need_financing`, `Project`.`project_need_require_doc`, `Project`.`financing_type`, `Project`.`hourly_rate_applied`, `Project`.`hourly_rate_charges`, `Project`.`need_hire_project_manager`, `Project`.`actual_completion_cost`, `Project`.`last_date_request_additional_info`, `Project`.`currency_code`, `Project`.`conversion_currency_code`, `Project`.`conversion_currency_exchange_rate`, `Project`.`action_performed_by`, `Project`.`rebid_reminder_before_24`, `ServiceProvider`.`id`, `ServiceProvider`.`session_id`, `ServiceProvider`.`facebook_id`, `ServiceProvider`.`google_id`, `ServiceProvider`.`twitter_id`, `ServiceProvider`.`auth_type`, `ServiceProvider`.`first_name`, `ServiceProvider`.`last_name`, `ServiceProvider`.`email`, `ServiceProvider`.`username`, `ServiceProvider`.`show_name`, `ServiceProvider`.`password`, `ServiceProvider`.`contact_number`, `ServiceProvider`.`address`, `ServiceProvider`.`country_id`, `ServiceProvider`.`state_id`, `ServiceProvider`.`city_id`, `ServiceProvider`.`activation_key`, `ServiceProvider`.`email_token`, `ServiceProvider`.`email_token_exp`, `ServiceProvider`.`user_type`, `ServiceProvider`.`user_group_id`, `ServiceProvider`.`status`, `ServiceProvider`.`encrypted_user_key`, `ServiceProvider`.`business_name`, `ServiceProvider`.`business_description`, `ServiceProvider`.`website`, `ServiceProvider`.`logo`, `ServiceProvider`.`profile_image`, `ServiceProvider`.`background_profile_image`, `ServiceProvider`.`receive_deal_notification`, `ServiceProvider`.`allow_psps_contact_regarding_financing`, `ServiceProvider`.`deal_services`, `ServiceProvider`.`service_area`, `ServiceProvider`.`trade`, `ServiceProvider`.`license`, `ServiceProvider`.`expiration`, `ServiceProvider`.`business_since`, `ServiceProvider`.`helpful_information`, `ServiceProvider`.`emergency_service_charges`, `ServiceProvider`.`service_provider_type_id`, `ServiceProvider`.`have_worker_compensation_insurance`, `ServiceProvider`.`worker_compensation_insurance_expiry`, `ServiceProvider`.`have_public_liability_insurance`, `ServiceProvider`.`public_liability_insurance_expiry`, `ServiceProvider`.`is_blocked`, `ServiceProvider`.`is_deleted`, `ServiceProvider`.`user_ip`, `ServiceProvider`.`profile_completed`, `ServiceProvider`.`is_apporoved`, `ServiceProvider`.`is_notify_me`, `ServiceProvider`.`is_show_contact_info`, `ServiceProvider`.`is_featured`, `ServiceProvider`.`is_psps`, `ServiceProvider`.`is_first`, `ServiceProvider`.`is_unethical`, `ServiceProvider`.`psps_rating`, `ServiceProvider`.`average_response_time`, `ServiceProvider`.`last_login`, `ServiceProvider`.`account_disable_email`, `ServiceProvider`.`is_online`, `ServiceProvider`.`created`, `ServiceProvider`.`modified`, (SELECT GROUP_CONCAT(`categories`.`name` SEPARATOR ', ') FROM user_industries LEFT JOIN categories ON `user_industries`.`category_id`=`categories`.`id` WHERE user_id = `ServiceProvider`.`id`) AS `ServiceProvider__industry`, (SELECT GROUP_CONCAT(`categories`.`name` SEPARATOR ', ') FROM user_categories LEFT JOIN categories ON `user_categories`.`category_id`=`categories`.`id` WHERE user_id = `ServiceProvider`.`id`) AS `ServiceProvider__user_categories`, (SELECT GROUP_CONCAT(`payment_methods`.`name` SEPARATOR ', ') FROM user_payment_methods LEFT JOIN payment_methods ON `user_payment_methods`.`payment_method_id`=`payment_methods`.`id` WHERE user_id = `ServiceProvider`.`id` ) AS `ServiceProvider__user_payment_methods`, (SELECT name FROM countries where id = `ServiceProvider`.`country_id` ) AS `ServiceProvider__country`, (SELECT name FROM cities where id = `ServiceProvider`.`city_id` ) AS `ServiceProvider__city`, (SELECT IFNULL(ROUND(AVG(`user_reviews`.`overall_rating`)), 0) FROM user_reviews WHERE status = 1 AND is_deleted =0 AND is_active = 1 AND service_provider_id = `ServiceProvider`.`id` AND review_for='service_provider' AND `user_reviews`.`overall_rating` IS NOT NULL) AS `ServiceProvider__user_reviews`, (SELECT count(`user_reviews`.`id`) FROM user_reviews WHERE status = 1 AND is_deleted =0 AND is_active = 1 AND service_provider_id = `ServiceProvider`.`id` AND `user_reviews`.`parent_id`=0 AND review_for='service_provider') AS `ServiceProvider__nu_of_reviews`, (SELECT count(`project_quotes`.`id`) FROM project_quotes WHERE quote_status =1 AND psps_id = `ServiceProvider`.`id`) AS `ServiceProvider__project_awarded`, (SELECT count(`psps_photos_deals`.`id`) FROM psps_photos_deals WHERE is_deal = 1 and user_id = `ServiceProvider`.`id` AND deal_status = 'accepted') AS `ServiceProvider__user_deals`, `ProjectOwner`.`id`, `ProjectOwner`.`session_id`, `ProjectOwner`.`facebook_id`, `ProjectOwner`.`google_id`, `ProjectOwner`.`twitter_id`, `ProjectOwner`.`auth_type`, `ProjectOwner`.`first_name`, `ProjectOwner`.`last_name`, `ProjectOwner`.`email`, `ProjectOwner`.`username`, `ProjectOwner`.`show_name`, `ProjectOwner`.`password`, `ProjectOwner`.`contact_number`, `ProjectOwner`.`address`, `ProjectOwner`.`country_id`, `ProjectOwner`.`state_id`, `ProjectOwner`.`city_id`, `ProjectOwner`.`activation_key`, `ProjectOwner`.`email_token`, `ProjectOwner`.`email_token_exp`, `ProjectOwner`.`user_type`, `ProjectOwner`.`user_group_id`, `ProjectOwner`.`status`, `ProjectOwner`.`encrypted_user_key`, `ProjectOwner`.`business_name`, `ProjectOwner`.`business_description`, `ProjectOwner`.`website`, `ProjectOwner`.`logo`, `ProjectOwner`.`profile_image`, `ProjectOwner`.`background_profile_image`, `ProjectOwner`.`receive_deal_notification`, `ProjectOwner`.`allow_psps_contact_regarding_financing`, `ProjectOwner`.`deal_services`, `ProjectOwner`.`service_area`, `ProjectOwner`.`trade`, `ProjectOwner`.`license`, `ProjectOwner`.`expiration`, `ProjectOwner`.`business_since`, `ProjectOwner`.`helpful_information`, `ProjectOwner`.`emergency_service_charges`, `ProjectOwner`.`service_provider_type_id`, `ProjectOwner`.`have_worker_compensation_insurance`, `ProjectOwner`.`worker_compensation_insurance_expiry`, `ProjectOwner`.`have_public_liability_insurance`, `ProjectOwner`.`public_liability_insurance_expiry`, `ProjectOwner`.`is_blocked`, `ProjectOwner`.`is_deleted`, `ProjectOwner`.`user_ip`, `ProjectOwner`.`profile_completed`, `ProjectOwner`.`is_apporoved`, `ProjectOwner`.`is_notify_me`, `ProjectOwner`.`is_show_contact_info`, `ProjectOwner`.`is_featured`, `ProjectOwner`.`is_psps`, `ProjectOwner`.`is_first`, `ProjectOwner`.`is_unethical`, `ProjectOwner`.`psps_rating`, `ProjectOwner`.`average_response_time`, `ProjectOwner`.`last_login`, `ProjectOwner`.`account_disable_email`, `ProjectOwner`.`is_online`, `ProjectOwner`.`created`, `ProjectOwner`.`modified`, `QuoteType`.`id`, `QuoteType`.`name`, `QuoteType`.`description`, `QuoteType`.`slug`, `QuoteType`.`status`, `QuoteType`.`show_in_list`, `QuoteType`.`created`, `QuoteType`.`modified` FROM `demoe3_getezquotes`.`project_quotes` AS `Quote` LEFT JOIN `demoe3_getezquotes`.`projects` AS `Project` ON (`Quote`.`project_id` = `Project`.`id`) LEFT JOIN `demoe3_getezquotes`.`users` AS `ServiceProvider` ON (`Quote`.`psps_id` = `ServiceProvider`.`id`) LEFT JOIN `demoe3_getezquotes`.`users` AS `ProjectOwner` ON (`Quote`.`user_id` = `ProjectOwner`.`id`) LEFT JOIN `demoe3_getezquotes`.`quote_types` AS `QuoteType` ON (`Quote`.`quote_type` = `QuoteType`.`id`) WHERE `Quote`.`psps_id` IS NULL AND `Quote`.`project_id` = 27 LIMIT 1	0	0	209	maybe slow
SELECT `BannerPosition`.`id`, `BannerPosition`.`page_slug`, `BannerPosition`.`page_name`, `BannerPosition`.`allow_category`, `BannerPosition`.`is_random`, `BannerPosition`.`banner_type`, `BannerPosition`.`no_of_banners`, `BannerPosition`.`banner_order`, `BannerPosition`.`time_interval`, `BannerPosition`.`banner_width`, `BannerPosition`.`banner_height`, `BannerPosition`.`banner_position_image`, `BannerPosition`.`created`, `BannerPosition`.`modified` FROM `demoe3_getezquotes`.`banner_positions` AS `BannerPosition` WHERE `BannerPosition`.`page_slug` = 'projects-popup' LIMIT 1	1	1	11	maybe slow
SELECT `Banner`.`id`, `Banner`.`user_id`, `Banner`.`user_purchased_banner_package_id`, `Banner`.`banner_position_package_id`, `Banner`.`title`, `Banner`.`banner_type`, `Banner`.`link`, `Banner`.`advertiser_name`, `Banner`.`banner_position_id`, `Banner`.`category_id`, `Banner`.`banner_price`, `Banner`.`image`, `Banner`.`start_date`, `Banner`.`end_date`, `Banner`.`unix_start_date`, `Banner`.`unix_end_date`, `Banner`.`actual_end_date`, `Banner`.`duration`, `Banner`.`duration_unit`, `Banner`.`payment_status`, `Banner`.`banner_status`, `Banner`.`is_active`, `Banner`.`is_admin_approved`, `Banner`.`is_deleted`, `Banner`.`reason`, `Banner`.`created`, `Banner`.`modified` FROM `demoe3_getezquotes`.`banners` AS `Banner` WHERE `Banner`.`banner_position_id` = 21 AND `Banner`.`start_date` <= 1715039254 AND `Banner`.`end_date` > 1715039254 AND `Banner`.`is_admin_approved` = 1 AND `Banner`.`is_active` = 1 AND `Banner`.`banner_type` = 'static_banner' AND `Banner`.`payment_status` = 'completed' ORDER BY rand() ASC, `Banner`.`Created` DESC	0	0	1	maybe slow
SELECT `Country`.`id`, `Country`.`slug`, `Country`.`name`, `Country`.`country_code`, `Country`.`is_default`, `Country`.`country_flag` FROM `demoe3_getezquotes`.`countries` AS `Country` WHERE `Country`.`show_in_menu` = 1 AND `Country`.`status` = 1 ORDER BY `country_order` ASC, `name` ASC	3	3	0
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`users` AS `User` WHERE `user_type` = 'service-provider' AND ((`is_blocked` = 0) AND (`is_deleted` = 0) AND (`is_apporoved` = 1) AND (`status` = 1) AND (`activation_key` = ''))	1	1	11	maybe slow
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`users` AS `User` WHERE `user_type` = 'user'	1	1	0
SELECT COUNT(*) AS `count` FROM `demoe3_getezquotes`.`projects` AS `Projects` LEFT JOIN `demoe3_getezquotes`.`users` AS `User` ON (`Projects`.`user_id` = `User`.`id`) WHERE `Projects`.`status` = 1 AND `Projects`.`is_admin_approved` = 1 AND `Projects`.`is_posted` = 1 AND `Projects`.`is_deleted` = 0 AND `User`.`is_deleted` = 0 AND `User`.`is_blocked` = 0	1	1	0

Query Explain:

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

====

Timer

Memory

Peak Memory Use 31.79 MB

Message	Memory use
Component initialization	9.16 MB
Controller action start	9.93 MB
Controller render start	11.15 MB
View render complete	15.33 MB

Timers

Total Request Time: 1894 (ms)

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	163.03
Event: Controller.initialize	40.83
Event: Controller.startup	3.29
Controller action	874.37
Event: Controller.beforeRender	81.83
» Processing toolbar data	81.19
Rendering View	615.41
» Event: View.beforeRender	0.07
» Rendering APP/Plugin/Project/View/Projects/single_project_listing.ctp	507.33
» » Rendering APP/View/Elements/share_buttons.ctp	24.93
» » Rendering APP/View/Elements/Banners/popup_banners.ctp	126.48
» Event: View.afterRender	0.04
» Event: View.beforeLayout	0.04
» Rendering APP/View/Layouts/default.ctp	88.43
» » Rendering APP/View/Elements/header_js.ctp	3.07
» » Rendering APP/View/Elements/header.ctp	25.43
» » Rendering APP/View/Elements/footer.ctp	57.49
» » » Rendering APP/View/Elements/city_search_popup_psps.ctp	5.11
Event: View.afterLayout	0.00

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- projectdata(array)
  Project(array)
  id27
  category_id777
  slugcondo-purchase-33
  nameCondo Purchase #33
  is_deleted0
  created1702701096
  show_name
  alias_name
  country_id2
  is_admin_approved1
  user_id5
  running_status0
  level_of_urgencymedium
  due_date1704052800
  anticipated_start_date(null)
  postal_codeKY1 1000-1200
  city_nameGeorge Town
  meet_day
  additional_information(null)
  meeting0
  descriptionfddgfdg ds f gsdd
  project_documents_link
  job_startwithin_3_month
  business_contact
  contact_specific_time
  contact_time
  show_contact_info0
  project_status_questionplanning_budgeting
  status1
  posted_on1702701344
  QuoteType(array)
  nameVariable Range Quote
  slugvariable-range-quote
  Country(array)
  nameCayman
  Category(array)
  nameBuy Condo Real Estate
  is_allow_multiple1
  User(array)
  first_nameAlex
  country_id2
  profile_image
  last_nameHaylock
  show_namerealname
  emailhaylock@haylockssl.com
  usernamemikel
  contact_number2345678907
  ProjectAttachment(empty)
  ProjectCategoryOption(array)
  0(array)
  id86
  project_id27
  project_questionWhat type of buyer are you ?
  selected_optionSingle Buyer
  field_namecon_buye_ty
  text_field_typecheckbox
  project_question_id2356
  selected_option_id7983
  sensitive_information0
  project_question_order1
  created1702701265
  modified1702701265
  1(array)
  id87
  project_id27
  project_questionWhat type of condo property are you interested in ?
  selected_optionCondo
  field_namecondo_real_estate
  text_field_typeselect
  project_question_id77
  selected_option_id292
  sensitive_information0
  project_question_order1
  created1702701266
  modified1702701266
  2(array)
  id88
  project_id27
  project_questionEnter a location you would like the condo !
  selected_optionWest Bay Road
  field_namecondo_locationr
  text_field_typetext
  project_question_id79
  selected_option_id
  sensitive_information0
  project_question_order2
  created1702701266
  modified1702701266
  3(array)
  id89
  project_id27
  project_questionHow many square feet should the condo be ?
  selected_option1200 - 2000 sqft
  field_namecondo_square_feet
  text_field_typeselect
  project_question_id80
  selected_option_id331
  sensitive_information0
  project_question_order3
  created1702701266
  modified1702701266
  4(array)
  id90
  project_id27
  project_questionHow many rooms should the condo have ?
  selected_option3
  field_namecondo_rooms
  text_field_typeselect
  project_question_id81
  selected_option_id338
  sensitive_information0
  project_question_order4
  created1702701266
  modified1702701266
  5(array)
  id91
  project_id27
  project_questionHow many bathrooms ?
  selected_option2
  field_namecondo_bathrooms
  text_field_typeselect
  project_question_id82
  selected_option_id343
  sensitive_information0
  project_question_order5
  created1702701266
  modified1702701266
  6(array)
  id92
  project_id27
  project_questionWhat type of amenities do you require ?
  selected_optionAC or Climate Control,Cable TV or Satellite,Child Friendly,Beach Front,Pool,Hot Tub / Jacuzzi,Ample
  field_namecondo_amen
  text_field_typecheckbox
  project_question_id110
  selected_option_id538,539,540,541,542,543,544,601,602
  sensitive_information0
  project_question_order6
  created1702701266
  modified1702701266
  7(array)
  id93
  project_id27
  project_questionHow old must the condo be ?
  selected_optionBuilt more than 20 years ago
  field_namecondo_age
  text_field_typeselect
  project_question_id83
  selected_option_id352
  sensitive_information0
  project_question_order7
  created1702701266
  modified1702701266
  8(array)
  id94
  project_id27
  project_questionHow much money can you spend ?
  selected_optionUp to $200,000
  field_namecondo_amount
  text_field_typeselect
  project_question_id84
  selected_option_id353
  sensitive_information0
  project_question_order8
  created1702701266
  modified1702701266
  9(array)
  id95
  project_id27
  project_questionSelect Currency:
  selected_optionBBD
  field_nameby_cin_cur
  text_field_typeselect
  project_question_id3016
  selected_option_id10464
  sensitive_information0
  project_question_order9
  created1702701266
  modified1702701266
- meta_descriptionfddgfdg ds f gsdd
- title_for_layoutCondo Purchase #33
- pageTitleProject Listings
- modelProject
- allNotifications0
- $request->data(empty)
- $this->validationErrors(array)
  StaticPage(empty)
  Country(empty)
  CurrencyCountry(empty)
  Currency(empty)
  Notification(empty)
  Project(empty)
  Category(empty)
  QuoteType(empty)
  User(empty)
  ProjectAttachment(empty)
  ProjectCategoryOption(empty)
- Loaded Helpers(array)
  0Number
  1SimpleGraph
  2DebugTimer
  3Toolbar
  4GeneralFunctions
  5Session
  6Html
  7Form
  8HtmlToolbar
====

Environment

App Constants

Constant	Value
MAIN_FOLDER
ADMIN_FOLDER	admin/
SITE_ROOT_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/
SITE_WEBROOT_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/
WEBSITE_URL	http://getezquotes.demoe3.com/
SET_COOKIE_TIME	2592000
HOST_URL	getezquotes.demoe3.com
WEBSITE_ADMIN_URL	http://getezquotes.demoe3.com/admin/
WEBSITE_IMG_URL	http://getezquotes.demoe3.com/img/
WEBSITE_ADMIN_IMG_URL	http://getezquotes.demoe3.com/admin/img/
WEBSITE_APP_WEBROOT_ROOT_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/
DEFAULT_COUNTRY_CODE	CYM
DEFAULT_STATE_CODE	GUY
DEFAULT_CITY_NAME	George Town
DEFAULT_CITY_ZIPCODE	KY1-1100
COORDINATOR_RATING_FORM_FIELD_NAME	coordinator_review_rating_
APP_UPLOADS_ROOT_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/
PERCENT_SYMBOL	%
WEBSITE_IMG_FILE_URL	http://getezquotes.demoe3.com/image.php
DATEPICKER_DATE_FORMATE	m-d-Y
DATE_FROM_DB	'%m-%d-%Y'
DATE_SEPERATOR	-
TIME_SEPARATOR	:
DATE_TIME_SPACE_SEPARATOR
TIME_FORMATE_24_HOUR	H:i
DATE_FORMATE	m-d-Y
DATE_FORMATE_WITH_TIMEZONE	dS F Y, h:i:s A T
DATE_TIME_FORMATE	m-d-Y h:m:s
COMDOWN_DATE_FORMATE	Y/m/d h:i:s
TIME_FORMATE	h:i a
TIMEFORMATE_JS	H:i a
INVOICE_DATE_FORMATE	F d, Y
ADMIN_MASSAGE_DATE_FORMATE	m-d-Y h:i A
PROPOSAL_DATE_FORMAT	d M Y
LESTEST_ACTIVITY_TIME	h:i A
LESTEST_ACTIVITY_TIME_STAMP	1714434453
DATE_FORMATE_JS	mm-dd-yyyy
DATE_TIME_FORMATE_JS	mm-dd-yyyy hh:ii P
DATE_TIME_FORMATE_JS_12_HOURS	dd-mm-yyyy HH:ii P
DATETIME_FORMATE	m-d-Y h:i a
DATETIME_FORMATE_JS	m-d-Y H:i a
REVIEW_DATE_FORMATE	m-d-Y
PROJECT_DETAIL_DATE_FORMATE	m/d/Y
STUFF_ROOT_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff
STUFF_FOLDER_URL	http://getezquotes.demoe3.com/stuff/
ONTHEFLY_IMAGE_ROOT_PATH	stuff/
CATEGORY_IMAGE_URL	http://getezquotes.demoe3.com/stuff/category_images/
CATEGORY_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/category_images/
CATEGORY_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/category_images/
CATEGORY_BROCHURE_URL	http://getezquotes.demoe3.com/stuff/category_brochure/
CATEGORY_BROCHURE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/category_brochure/
CATEGORY_BROCHURE_ONTHEFLY_IMAGE_PATH	stuff/category_brochure/
BANNER_POSTION_IMAGE_URL	http://getezquotes.demoe3.com/stuff/banner_position_images/
BANNER_POSTION_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/banner_position_images/
BANNER_POSTION_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/banner_position_images/
SERVICE_ASSOCIATION_IMAGE_URL	http://getezquotes.demoe3.com/stuff/service_association/
SERVICE_ASSOCIATION_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/service_association/
SERVICE_ASSOCIATION_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/service_association/
BANNER_IMAGE_URL	http://getezquotes.demoe3.com/stuff/banner_image/
BANNER_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/banner_image/
BANNER_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/banner_image/
PROJECT_ATTACHMENTS_URL	http://getezquotes.demoe3.com/stuff/project_attachments/
PROJECT_ATTACHMENTS_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/project_attachments/
PROJECT_ATTACHMENTS_ONTHEFLY_IMAGE_PATH	stuff/project_attachments/
QUOTE_ATTACHMENTS_URL	http://getezquotes.demoe3.com/stuff/quote_attachments/
QUOTE_ATTACHMENTS_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/quote_attachments/
QUOTE_ATTACHMENTS_ONTHEFLY_IMAGE_PATH	stuff/quote_attachments/
COUPON_IMAGE_URL	http://getezquotes.demoe3.com/stuff/coupons_images/
COUPON_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/coupons_images/
COUPON_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/coupons_images/
LOGO_IMAGE_URL	http://getezquotes.demoe3.com/stuff/logo/
LOGO_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/logo/
LOGO_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/logo/
PORTFOLIO_IMAGE_URL	http://getezquotes.demoe3.com/stuff/portfolio/
PORTFOLIO_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/portfolio/
PORTFOLIO_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/portfolio/
COUNTRY_FLAG_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/countryflag/
COUNTRY_FLAG_ONTHEFLY_IMAGE_PATH	stuff/countryflag/
PHOTO_DEAL_IMAGE_URL	http://getezquotes.demoe3.com/stuff/photo_deal/
PHOTO_DEAL_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/photo_deal/
PHOTO_DEAL_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/photo_deal/
PROFILE_IMAGE_IMAGE_URL	http://getezquotes.demoe3.com/stuff/profile_image/
PROFILE_IMAGE_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/profile_image/
WEBSITE_LOGO_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/website_logo/
PROFILE_IMAGE_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/profile_image/
WEBSITE_LOGO_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/website_logo/
BACKGROUND_PROFILE_IMAGE_ROOT_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/background_profile_image/
BACKGROUND_PROFILE_IMAGE_URL	http://getezquotes.demoe3.com/stuff/background_profile_image/
BACKGROUND_PROFILE_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/background_profile_image/
BACKGROUND_PROFILE_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/background_profile_image/
TESTIMONIAL_IMAGE_URL	http://getezquotes.demoe3.com/stuff/testimonial/
TESTIMONIAL_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/testimonial/
TESTIMONIAL_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/testimonial/
DEPARTMENT_IMAGE_URL	http://getezquotes.demoe3.com/stuff/department/
DEPARTMENT_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/department/
DEPARTMENT_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/department/
ATTACHMENT_IMAGE_URL	http://getezquotes.demoe3.com/stuff/attachment/
ATTACHMENT_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/attachment/
ATTACHMENT_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/attachment/
CHAT_ATT_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/chatattachment/
CHAT_ATT_ONTHEFLY_IMAGE_PATH	stuff/chatattachment/
PM_REQUEST_SERVICES_IMAGE_URL	http://getezquotes.demoe3.com/stuff/project_management_request_services/
PM_REQUEST_SERVICES_IMAGE_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/project_management_request_services/
PM_REQUEST_SERVICES_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/project_management_request_services/
HOME_SLIDER_IMAGE_URL	http://getezquotes.demoe3.com/stuff/slider_images/
HOME_SLIDER_IMAGE_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/slider_images/
HOME_SLIDER_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/slider_images/
COORDINATOR_DOCUMENTS_URL	http://getezquotes.demoe3.com/stuff/coordinator_documents/
COORDINATOR_DOCUMENT_UPLOAD_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/coordinator_documents/
COORDINATOR_DOCUMENT_ONTHEFLY_PATH	stuff/coordinator_documents/
SETTINGS_IMAGE_URL	http://getezquotes.demoe3.com/stuff/settings/
SETTINGS_IMAGE_DIRECTORY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/settings/
SETTINGS_IMAGE_ONTHEFLY_IMAGE_PATH	stuff/settings/
PASSWORD_ENCODED_ALGORITHM	sha1
PDF_FILE_UPLOAD_DIRECTROY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/pdf/
PDF_DIRECTROY_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/stuff/pdf/
SUCCESS	success
INVALID	invalid
ERROR	error
CONVERSION_CURRENCY_USD	USD
NOT_YET_AWARDED	Not Yet Awarded
RATING_FORM_FIELD_NAME	post_review_rating_

CakePHP Constants

Constant	Value
APP	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/
APP_DIR	app
APPLIBS	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/Lib/
CACHE	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/tmp/cache/
CAKE	/home/demoe3/web/getezquotes.demoe3.com/public_html/lib/Cake/
CAKE_CORE_INCLUDE_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/lib
CORE_PATH	/home/demoe3/web/getezquotes.demoe3.com/public_html/lib/
CAKE_VERSION	2.5.3
CSS	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/css/
CSS_URL	css/
DS	/
FULL_BASE_URL	http://getezquotes.demoe3.com
IMAGES	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/img/
IMAGES_URL	img/
JS	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/js/
JS_URL	js/
LOGS	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/tmp/logs/
ROOT	/home/demoe3/web/getezquotes.demoe3.com/public_html
TESTS	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/Test/
TMP	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/tmp/
VENDORS	/home/demoe3/web/getezquotes.demoe3.com/public_html/vendors/
WEBROOT_DIR	webroot
WWW_ROOT	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/

PHP Environment

Environment Variable	Value
Php Version	5.6.40-5+ubuntu14.04.1+deb.sury.org+1
Redirect Redirect Status	200
Redirect Status	200
Http Host	getezquotes.demoe3.com
Http X Real Ip	3.133.12.172
Http X Forwarded For	3.133.12.172
Http Connection	close
Http Accept	/
Http User Agent	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
Path	/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin
Server Signature
Server Software	Apache/2.4.7 (Ubuntu) mod_fcgid/2.3.9 OpenSSL/1.0.1f
Server Name	getezquotes.demoe3.com
Server Addr	144.217.149.181
Server Port	80
Remote Addr	144.217.149.181
Document Root	/home/demoe3/web/getezquotes.demoe3.com/public_html
Request Scheme	http
Context Prefix
Context Document Root	/home/demoe3/web/getezquotes.demoe3.com/public_html
Server Admin	info@getezquotes.demoe3.com
Script Filename	/home/demoe3/web/getezquotes.demoe3.com/public_html/app/webroot/index.php
Remote Port	39952
Redirect Url	/app/webroot/project-list/condo-purchase-33/directory
Gateway Interface	CGI/1.1
Server Protocol	HTTP/1.0
Request Method	GET
Query String
Request Uri	/project-list/condo-purchase-33/directory
Script Name	/app/webroot/index.php
Php Self	/app/webroot/index.php
Request Time Float	1715039253.076
Request Time	1715039253

====

Include
+
Included Files

Include Paths
- 0/home/demoe3/web/getezquotes.demoe3.com/public_html/lib
- 2/usr/share/php
- 3-> /home/demoe3/web/getezquotes.demoe3.com/public_html/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/ContainableBehavior.php
  1CORE/Model/Behavior/TreeBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/EmailComponent.php
  1CORE/Controller/Component/SessionComponent.php
  2CORE/Controller/Component/CookieComponent.php
  3CORE/Controller/Component/AuthComponent.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Configure(array)
  0CORE/Configure/PhpReader.php
  1CORE/Configure/ConfigReaderInterface.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Model.php
  1CORE/Model/BehaviorCollection.php
  2CORE/Model/ModelBehavior.php
  3CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  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/Object.php
  Routing(array)
  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(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/String.php
  5CORE/Utility/ClassRegistry.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Component(array)
  0APP/Controller/Component/GeneralFunctionsComponent.php
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/global_constants.php
  3APP/Config/routes.php
  4APP/Config/database.php
  Controller(array)
  0APP/Controller/AppController.php
  Model(array)
  0APP/Model/AppModel.php
  1APP/Model/Country.php
  2APP/Model/Currency.php
  3APP/Model/Category.php
  4APP/Model/QuoteType.php
  Other(array)
  0APP/webroot/index.php
- plugins(array)
  Contact(array)
  Config(array)
  0Contact/Config/routes.php
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Other(array)
  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/Panel/VariablesPanel.php
  9DebugKit/Lib/Panel/EnvironmentPanel.php
  10DebugKit/Lib/Panel/IncludePanel.php
  11DebugKit/Lib/DebugTimer.php
  Log(array)
  0DebugKit/Lib/Log/Engine/DebugKitLog.php
  Message(array)
  Config(array)
  0Message/Config/routes.php
  Project(array)
  Config(array)
  0Project/Config/routes.php
  Controller(array)
  0Project/Controller/ProjectsController.php
  1Project/Controller/ProjectAppController.php
  Model(array)
  0Project/Model/Project.php
  1Project/Model/ProjectAppModel.php
  Search(array)
  Behavior(array)
  0Search/Model/Behavior/SearchableBehavior.php
  Staticpages(array)
  Config(array)
  0Staticpages/Config/routes.php
  Model(array)
  0Staticpages/Model/StaticPage.php
  1Staticpages/Model/StaticpagesAppModel.php
  Supports(array)
  Config(array)
  0Supports/Config/routes.php
  Testimonials(array)
  Config(array)
  0Testimonials/Config/routes.php
  Users(array)
  Config(array)
  0Users/Config/routes.php
====

Contact Us

ABOUT US

GUIDES

BROWSE

HELP

USEFUL LINKS

Our Numbers

default

Total Time: 852 ms
Total Queries: 14 queries

Query Explain:

Memory

Timers

Project Listings

Contact Us

ABOUT US

GUIDES

BROWSE

HELP

USEFUL LINKS

Our Numbers

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 852 ms Total Queries: 14 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 852 ms
Total Queries: 14 queries