Guttman Realty Advisors New York

Tel: 212.242.7800

Shelton Ice Cream Shop

Property Code :

STCTSICS

Images

There are no images

To choose a picture, press SHIFT key and click on the image of your choice

Add to specials

Address

Address :

Cross Streets :

City :

Shelton

State :

ZIP :

Description

All brand new ice cream equipment and loads of refrigeration

General Info1

Terms

Published : No

History
Request History
4 previous requests available
====
Session
Session
- Config
  userAgent36cec36c85b7fb0b2fae74351c337291
  time1337591754
  timeout10
- Message
  auth
  messageYou are not authorized to access that location.
  layoutdefault
  params(empty)
- Auth
  redirect/debug_kit/toolbar_access/history_state/4
====
Request
Request

Cake Params
- pass
  029
- named(empty)
- controllerlistings
- actionview
- plugin(null)
- form(empty)
- url
  urllistings/view/29
- isAjax(false)
$_GET
- urllistings/view/29
Cookie
- 0(empty)
Current Route
- 0/:controller/:action/*
- 1#^(?:/([^\/]+))?(?:/([^\/]+))?(?:/(.*))?[\/]*$#
- 2
  0controller
  1action
- 3
  plugin(null)
  controller(null)
  actionindex
- 4(empty)
====

Sql Log

Sql Logs

default

Nr	Query	Affected	Num. rows	Took (ms)
1	DESCRIBE `aros`	7	7	1
2	DESCRIBE `acos`	7	7	1
3	DESCRIBE `aros_acos`	7	7	1
4	DESCRIBE `listings`	27	27	2
5	DESCRIBE `options_construction_types`	4	4	1
6	DESCRIBE `options_appearances`	6	6	1
7	DESCRIBE `options_attachments`	4	4	1
8	DESCRIBE `options_classes`	6	6	1
9	DESCRIBE `options_styles`	6	6	1
10	DESCRIBE `options_basements`	4	4	1
11	DESCRIBE `options_sales_property_types`	4	4	1
12	DESCRIBE `sales_features`	30	30	2
13	DESCRIBE `options_garages`	6	6	1
14	DESCRIBE `options_driveways`	6	6	1
15	DESCRIBE `options_pools`	6	6	1
16	DESCRIBE `sales_appliances`	15	15	1
17	DESCRIBE `options_heats`	6	6	1
18	DESCRIBE `options_fuels`	6	6	1
19	DESCRIBE `options_waters`	6	6	1
20	DESCRIBE `sales_terms`	7	7	2
21	DESCRIBE `sales_rooms`	15	15	2
22	DESCRIBE `options_dining_rooms`	4	4	1
23	DESCRIBE `options_bedrooms`	4	4	1
24	DESCRIBE `sales_schools`	6	6	1
25	DESCRIBE `sales_images`	5	5	1
26	DESCRIBE `fileuploads`	13	13	2
27	DESCRIBE `sales_features_lists`	4	4	1
28	DESCRIBE `options_sales_features`	4	4	1
29	DESCRIBE `specials`	13	13	2
30	SELECT `Listing`.`id`, `Listing`.`code`, `Listing`.`listing_type`, `Listing`.`title`, `Listing`.`address`, `Listing`.`cross_streets`, `Listing`.`city`, `Listing`.`state`, `Listing`.`zip`, `Listing`.`options_class_id`, `Listing`.`options_style_id`, `Listing`.`options_sales_property_type_id`, `Listing`.`options_construction_type_id`, `Listing`.`is_new_construction`, `Listing`.`year_built`, `Listing`.`options_appearance_id`, `Listing`.`footage`, `Listing`.`options_attachment_id`, `Listing`.`lot_size`, `Listing`.`lot_footage`, `Listing`.`building_size`, `Listing`.`zone`, `Listing`.`options_basement_id`, `Listing`.`general_info`, `Listing`.`is_published`, `Listing`.`created`, `Listing`.`modified`, `OptionsConstructionType`.`id`, `OptionsConstructionType`.`name`, `OptionsConstructionType`.`created`, `OptionsConstructionType`.`modified`, `OptionsAppearance`.`id`, `OptionsAppearance`.`name`, `OptionsAppearance`.`form`, `OptionsAppearance`.`table_name`, `OptionsAppearance`.`created`, `OptionsAppearance`.`modified`, `OptionsAttachment`.`id`, `OptionsAttachment`.`name`, `OptionsAttachment`.`created`, `OptionsAttachment`.`modified`, `OptionsClass`.`id`, `OptionsClass`.`name`, `OptionsClass`.`form`, `OptionsClass`.`table_name`, `OptionsClass`.`created`, `OptionsClass`.`modified`, `OptionsStyle`.`id`, `OptionsStyle`.`name`, `OptionsStyle`.`form`, `OptionsStyle`.`table_name`, `OptionsStyle`.`created`, `OptionsStyle`.`modified`, `OptionsBasement`.`id`, `OptionsBasement`.`name`, `OptionsBasement`.`created`, `OptionsBasement`.`modified`, `OptionsSalesPropertyType`.`id`, `OptionsSalesPropertyType`.`name`, `OptionsSalesPropertyType`.`created`, `OptionsSalesPropertyType`.`modified`, `SalesFeature`.`has_porch`, `SalesFeature`.`has_patio`, `SalesFeature`.`has_deck`, `SalesFeature`.`has_skylight`, `SalesFeature`.`has_fireplace`, `SalesFeature`.`has_ww_carpet`, `SalesFeature`.`has_hardwood_floor`, `SalesFeature`.`has_handicap_access`, `SalesFeature`.`has_basement`, `SalesFeature`.`has_basement_finished`, `SalesFeature`.`has_driveway`, `SalesFeature`.`options_driveway_id`, `SalesFeature`.`has_garage`, `SalesFeature`.`options_garage_id`, `SalesFeature`.`has_pool`, `SalesFeature`.`options_pool_id`, `SalesFeature`.`has_sprinklers`, `SalesFeature`.`has_water_view`, `SalesFeature`.`is_waterfront`, `SalesFeature`.`is_water_frontage`, `SalesFeature`.`has_beach_rights`, `SalesFeature`.`has_docking_rights`, `SalesFeature`.`has_storage`, `SalesFeature`.`has_common_garden`, `SalesFeature`.`has_private_garden`, `SalesFeature`.`has_elevator`, `SalesFeature`.`created`, `SalesFeature`.`modified`, `SalesFeature`.`id`, `SalesFeature`.`listing_id`, `SalesAppliance`.`id`, `SalesAppliance`.`listing_id`, `SalesAppliance`.`has_stove`, `SalesAppliance`.`has_fridge`, `SalesAppliance`.`has_dishwasher`, `SalesAppliance`.`has_washer`, `SalesAppliance`.`has_dryer`, `SalesAppliance`.`has_separate_hw_water`, `SalesAppliance`.`options_heat_id`, `SalesAppliance`.`options_fuel_id`, `SalesAppliance`.`options_water_id`, `SalesAppliance`.`has_sewer`, `SalesAppliance`.`has_ac`, `SalesAppliance`.`created`, `SalesAppliance`.`modified`, `SalesTerm`.`id`, `SalesTerm`.`listing_id`, `SalesTerm`.`price`, `SalesTerm`.`taxes`, `SalesTerm`.`maintenance`, `SalesTerm`.`other_charges`, `SalesTerm`.`common_charge`, `SalesRoom`.`id`, `SalesRoom`.`listing_id`, `SalesRoom`.`rooms`, `SalesRoom`.`options_bedroom_id`, `SalesRoom`.`bathrooms`, `SalesRoom`.`bathroom_full`, `SalesRoom`.`bathroom_half`, `SalesRoom`.`kitchens`, `SalesRoom`.`has_kitchen_eat_in`, `SalesRoom`.`options_dining_room_id`, `SalesRoom`.`has_family_room`, `SalesRoom`.`has_office_room`, `SalesRoom`.`has_attic`, `SalesRoom`.`created`, `SalesRoom`.`modified`, `SalesSchool`.`id`, `SalesSchool`.`listing_id`, `SalesSchool`.`school_district_name`, `SalesSchool`.`school_district_number`, `SalesSchool`.`created`, `SalesSchool`.`modified`, `SalesImage`.`id`, `SalesImage`.`listing_id`, `SalesImage`.`fileupload_id`, `SalesImage`.`created`, `SalesImage`.`modified` FROM `listings` AS `Listing` LEFT JOIN `options_construction_types` AS `OptionsConstructionType` ON (`Listing`.`options_construction_type_id` = `OptionsConstructionType`.`id`) LEFT JOIN `options_appearances` AS `OptionsAppearance` ON (`Listing`.`options_appearance_id` = `OptionsAppearance`.`id`) LEFT JOIN `options_attachments` AS `OptionsAttachment` ON (`Listing`.`options_attachment_id` = `OptionsAttachment`.`id`) LEFT JOIN `options_classes` AS `OptionsClass` ON (`Listing`.`options_class_id` = `OptionsClass`.`id`) LEFT JOIN `options_styles` AS `OptionsStyle` ON (`Listing`.`options_style_id` = `OptionsStyle`.`id`) LEFT JOIN `options_basements` AS `OptionsBasement` ON (`Listing`.`options_basement_id` = `OptionsBasement`.`id`) LEFT JOIN `options_sales_property_types` AS `OptionsSalesPropertyType` ON (`Listing`.`options_sales_property_type_id` = `OptionsSalesPropertyType`.`id`) LEFT JOIN `sales_features` AS `SalesFeature` ON (`SalesFeature`.`listing_id` = `Listing`.`id`) LEFT JOIN `sales_appliances` AS `SalesAppliance` ON (`SalesAppliance`.`listing_id` = `Listing`.`id`) LEFT JOIN `sales_terms` AS `SalesTerm` ON (`SalesTerm`.`listing_id` = `Listing`.`id`) LEFT JOIN `sales_rooms` AS `SalesRoom` ON (`SalesRoom`.`listing_id` = `Listing`.`id`) LEFT JOIN `sales_schools` AS `SalesSchool` ON (`SalesSchool`.`listing_id` = `Listing`.`id`) LEFT JOIN `sales_images` AS `SalesImage` ON (`SalesImage`.`listing_id` = `Listing`.`id`) WHERE `Listing`.`id` = 29 LIMIT 1	1	1	9
31	SELECT `OptionsSalesPropertyType`.`id`, `OptionsSalesPropertyType`.`name`, `OptionsSalesPropertyType`.`created`, `OptionsSalesPropertyType`.`modified` FROM `options_sales_property_types` AS `OptionsSalesPropertyType` WHERE `OptionsSalesPropertyType`.`id` = 0	0	0	1
32	SELECT `SalesFeature`.`has_porch`, `SalesFeature`.`has_patio`, `SalesFeature`.`has_deck`, `SalesFeature`.`has_skylight`, `SalesFeature`.`has_fireplace`, `SalesFeature`.`has_ww_carpet`, `SalesFeature`.`has_hardwood_floor`, `SalesFeature`.`has_handicap_access`, `SalesFeature`.`has_basement`, `SalesFeature`.`has_basement_finished`, `SalesFeature`.`has_driveway`, `SalesFeature`.`options_driveway_id`, `SalesFeature`.`has_garage`, `SalesFeature`.`options_garage_id`, `SalesFeature`.`has_pool`, `SalesFeature`.`options_pool_id`, `SalesFeature`.`has_sprinklers`, `SalesFeature`.`has_water_view`, `SalesFeature`.`is_waterfront`, `SalesFeature`.`is_water_frontage`, `SalesFeature`.`has_beach_rights`, `SalesFeature`.`has_docking_rights`, `SalesFeature`.`has_storage`, `SalesFeature`.`has_common_garden`, `SalesFeature`.`has_private_garden`, `SalesFeature`.`has_elevator`, `SalesFeature`.`created`, `SalesFeature`.`modified`, `SalesFeature`.`id`, `SalesFeature`.`listing_id` FROM `sales_features` AS `SalesFeature` WHERE `SalesFeature`.`listing_id` = 29	0	0	1
33	SELECT `SalesAppliance`.`id`, `SalesAppliance`.`listing_id`, `SalesAppliance`.`has_stove`, `SalesAppliance`.`has_fridge`, `SalesAppliance`.`has_dishwasher`, `SalesAppliance`.`has_washer`, `SalesAppliance`.`has_dryer`, `SalesAppliance`.`has_separate_hw_water`, `SalesAppliance`.`options_heat_id`, `SalesAppliance`.`options_fuel_id`, `SalesAppliance`.`options_water_id`, `SalesAppliance`.`has_sewer`, `SalesAppliance`.`has_ac`, `SalesAppliance`.`created`, `SalesAppliance`.`modified` FROM `sales_appliances` AS `SalesAppliance` WHERE `SalesAppliance`.`listing_id` = 29	0	0	1
34	SELECT `SalesTerm`.`id`, `SalesTerm`.`listing_id`, `SalesTerm`.`price`, `SalesTerm`.`taxes`, `SalesTerm`.`maintenance`, `SalesTerm`.`other_charges`, `SalesTerm`.`common_charge` FROM `sales_terms` AS `SalesTerm` WHERE `SalesTerm`.`listing_id` = 29	0	0	2
35	SELECT `SalesRoom`.`id`, `SalesRoom`.`listing_id`, `SalesRoom`.`rooms`, `SalesRoom`.`options_bedroom_id`, `SalesRoom`.`bathrooms`, `SalesRoom`.`bathroom_full`, `SalesRoom`.`bathroom_half`, `SalesRoom`.`kitchens`, `SalesRoom`.`has_kitchen_eat_in`, `SalesRoom`.`options_dining_room_id`, `SalesRoom`.`has_family_room`, `SalesRoom`.`has_office_room`, `SalesRoom`.`has_attic`, `SalesRoom`.`created`, `SalesRoom`.`modified` FROM `sales_rooms` AS `SalesRoom` WHERE `SalesRoom`.`listing_id` = 29	0	0	3
36	SELECT `SalesSchool`.`id`, `SalesSchool`.`listing_id`, `SalesSchool`.`school_district_name`, `SalesSchool`.`school_district_number`, `SalesSchool`.`created`, `SalesSchool`.`modified` FROM `sales_schools` AS `SalesSchool` WHERE `SalesSchool`.`listing_id` = 29	0	0	3
37	SELECT `SalesImage`.`id`, `SalesImage`.`listing_id`, `SalesImage`.`fileupload_id`, `SalesImage`.`created`, `SalesImage`.`modified` FROM `sales_images` AS `SalesImage` WHERE `SalesImage`.`listing_id` = 29	0	0	1
38	SELECT `Fileupload`.`id`, `Fileupload`.`form_name`, `Fileupload`.`foreign_id`, `Fileupload`.`file_name`, `Fileupload`.`mime_type`, `Fileupload`.`extension`, `Fileupload`.`dir`, `Fileupload`.`file_size`, `Fileupload`.`caption`, `Fileupload`.`full_path`, `Fileupload`.`show_top_ten`, `Fileupload`.`created`, `Fileupload`.`modified` FROM `fileuploads` AS `Fileupload` WHERE `Fileupload`.`form_name` = 'listings' AND `Fileupload`.`foreign_id` = (29)	0	0	1
39	SELECT `OptionsBedroom`.`id`, `OptionsBedroom`.`name` FROM `options_bedrooms` AS `OptionsBedroom` WHERE 1 = 1	13	13	0
40	DESCRIBE `configurations`	7	7	1
41	DESCRIBE `logs`	9	9	1
42	DESCRIBE `users`	10	10	1
43	DESCRIBE `groups`	4	4	1
44	DESCRIBE `profiles`	10	10	1
45	SELECT `Configuration`.`id`, `Configuration`.`namespace`, `Configuration`.`config_key`, `Configuration`.`config_value`, `Configuration`.`is_public`, `Configuration`.`created`, `Configuration`.`modified` FROM `configurations` AS `Configuration` WHERE `Configuration`.`config_key` = 'meta_keywords' AND `Configuration`.`namespace` = 'app' LIMIT 1	0	0	1
46	SELECT `Configuration`.`id`, `Configuration`.`namespace`, `Configuration`.`config_key`, `Configuration`.`config_value`, `Configuration`.`is_public`, `Configuration`.`created`, `Configuration`.`modified` FROM `configurations` AS `Configuration` WHERE `Configuration`.`config_key` = 'meta_description' AND `Configuration`.`namespace` = 'app' LIMIT 1	0	0	1

toggle (11) query explains for default

Query: SELECT `Listing`.`id`, `Listing`.`code`, `Listing`.`listing_type`, `Listing`.`title`, `Listing`.`address`, `Listing`.`cross_streets`, `Listing`.`city`, `Listing`.`state`, `Listing`.`zip`, `Listing`.`options_class_id`, `Listing`.`options_style_id`, `Listing`.`options_sales_property_type_id`, `Listing`.`options_construction_type_id`, `Listing`.`is_new_construction`, `Listing`.`year_built`, `Listing`.`options_appearance_id`, `Listing`.`footage`, `Listing`.`options_attachment_id`, `Listing`.`lot_size`, `Listing`.`lot_footage`, `Listing`.`building_size`, `Listing`.`zone`, `Listing`.`options_basement_id`, `Listing`.`general_info`, `Listing`.`is_published`, `Listing`.`created`, `Listing`.`modified`, `OptionsConstructionType`.`id`, `OptionsConstructionType`.`name`, `OptionsConstructionType`.`created`, `OptionsConstructionType`.`modified`, `OptionsAppearance`.`id`, `OptionsAppearance`.`name`, `OptionsAppearance`.`form`, `OptionsAppearance`.`table_name`, `OptionsAppearance`.`created`, `OptionsAppearance`.`modified`, `OptionsAttachment`.`id`, `OptionsAttachment`.`name`, `OptionsAttachment`.`created`, `OptionsAttachment`.`modified`, `OptionsClass`.`id`, `OptionsClass`.`name`, `OptionsClass`.`form`, `OptionsClass`.`table_name`, `OptionsClass`.`created`, `OptionsClass`.`modified`, `OptionsStyle`.`id`, `OptionsStyle`.`name`, `OptionsStyle`.`form`, `OptionsStyle`.`table_name`, `OptionsStyle`.`created`, `OptionsStyle`.`modified`, `OptionsBasement`.`id`, `OptionsBasement`.`name`, `OptionsBasement`.`created`, `OptionsBasement`.`modified`, `OptionsSalesPropertyType`.`id`, `OptionsSalesPropertyType`.`name`, `OptionsSalesPropertyType`.`created`, `OptionsSalesPropertyType`.`modified`, `SalesFeature`.`has_porch`, `SalesFeature`.`has_patio`, `SalesFeature`.`has_deck`, `SalesFeature`.`has_skylight`, `SalesFeature`.`has_fireplace`, `SalesFeature`.`has_ww_carpet`, `SalesFeature`.`has_hardwood_floor`, `SalesFeature`.`has_handicap_access`, `SalesFeature`.`has_basement`, `SalesFeature`.`has_basement_finished`, `SalesFeature`.`has_driveway`, `SalesFeature`.`options_driveway_id`, `SalesFeature`.`has_garage`, `SalesFeature`.`options_garage_id`, `SalesFeature`.`has_pool`, `SalesFeature`.`options_pool_id`, `SalesFeature`.`has_sprinklers`, `SalesFeature`.`has_water_view`, `SalesFeature`.`is_waterfront`, `SalesFeature`.`is_water_frontage`, `SalesFeature`.`has_beach_rights`, `SalesFeature`.`has_docking_rights`, `SalesFeature`.`has_storage`, `SalesFeature`.`has_common_garden`, `SalesFeature`.`has_private_garden`, `SalesFeature`.`has_elevator`, `SalesFeature`.`created`, `SalesFeature`.`modified`, `SalesFeature`.`id`, `SalesFeature`.`listing_id`, `SalesAppliance`.`id`, `SalesAppliance`.`listing_id`, `SalesAppliance`.`has_stove`, `SalesAppliance`.`has_fridge`, `SalesAppliance`.`has_dishwasher`, `SalesAppliance`.`has_washer`, `SalesAppliance`.`has_dryer`, `SalesAppliance`.`has_separate_hw_water`, `SalesAppliance`.`options_heat_id`, `SalesAppliance`.`options_fuel_id`, `SalesAppliance`.`options_water_id`, `SalesAppliance`.`has_sewer`, `SalesAppliance`.`has_ac`, `SalesAppliance`.`created`, `SalesAppliance`.`modified`, `SalesTerm`.`id`, `SalesTerm`.`listing_id`, `SalesTerm`.`price`, `SalesTerm`.`taxes`, `SalesTerm`.`maintenance`, `SalesTerm`.`other_charges`, `SalesTerm`.`common_charge`, `SalesRoom`.`id`, `SalesRoom`.`listing_id`, `SalesRoom`.`rooms`, `SalesRoom`.`options_bedroom_id`, `SalesRoom`.`bathrooms`, `SalesRoom`.`bathroom_full`, `SalesRoom`.`bathroom_half`, `SalesRoom`.`kitchens`, `SalesRoom`.`has_kitchen_eat_in`, `SalesRoom`.`options_dining_room_id`, `SalesRoom`.`has_family_room`, `SalesRoom`.`has_office_room`, `SalesRoom`.`has_attic`, `SalesRoom`.`created`, `SalesRoom`.`modified`, `SalesSchool`.`id`, `SalesSchool`.`listing_id`, `SalesSchool`.`school_district_name`, `SalesSchool`.`school_district_number`, `SalesSchool`.`created`, `SalesSchool`.`modified`, `SalesImage`.`id`, `SalesImage`.`listing_id`, `SalesImage`.`fileupload_id`, `SalesImage`.`created`, `SalesImage`.`modified` FROM `listings` AS `Listing` LEFT JOIN `options_construction_types` AS `OptionsConstructionType` ON (`Listing`.`options_construction_type_id` = `OptionsConstructionType`.`id`) LEFT JOIN `options_appearances` AS `OptionsAppearance` ON (`Listing`.`options_appearance_id` = `OptionsAppearance`.`id`) LEFT JOIN `options_attachments` AS `OptionsAttachment` ON (`Listing`.`options_attachment_id` = `OptionsAttachment`.`id`) LEFT JOIN `options_classes` AS `OptionsClass` ON (`Listing`.`options_class_id` = `OptionsClass`.`id`) LEFT JOIN `options_styles` AS `OptionsStyle` ON (`Listing`.`options_style_id` = `OptionsStyle`.`id`) LEFT JOIN `options_basements` AS `OptionsBasement` ON (`Listing`.`options_basement_id` = `OptionsBasement`.`id`) LEFT JOIN `options_sales_property_types` AS `OptionsSalesPropertyType` ON (`Listing`.`options_sales_property_type_id` = `OptionsSalesPropertyType`.`id`) LEFT JOIN `sales_features` AS `SalesFeature` ON (`SalesFeature`.`listing_id` = `Listing`.`id`) LEFT JOIN `sales_appliances` AS `SalesAppliance` ON (`SalesAppliance`.`listing_id` = `Listing`.`id`) LEFT JOIN `sales_terms` AS `SalesTerm` ON (`SalesTerm`.`listing_id` = `Listing`.`id`) LEFT JOIN `sales_rooms` AS `SalesRoom` ON (`SalesRoom`.`listing_id` = `Listing`.`id`) LEFT JOIN `sales_schools` AS `SalesSchool` ON (`SalesSchool`.`listing_id` = `Listing`.`id`) LEFT JOIN `sales_images` AS `SalesImage` ON (`SalesImage`.`listing_id` = `Listing`.`id`) WHERE `Listing`.`id` = 29 LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	SalesFeature	system					0	const row not found
1	SIMPLE	SalesAppliance	system					0	const row not found
1	SIMPLE	SalesRoom	system					0	const row not found
1	SIMPLE	Listing	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	OptionsConstructionType	const	PRIMARY				1
1	SIMPLE	OptionsAppearance	const	PRIMARY				1
1	SIMPLE	OptionsAttachment	const	PRIMARY				1
1	SIMPLE	OptionsClass	const	PRIMARY				1
1	SIMPLE	OptionsStyle	const	PRIMARY				1
1	SIMPLE	OptionsBasement	const	PRIMARY				1
1	SIMPLE	OptionsSalesPropertyType	const	PRIMARY	PRIMARY	4	const	0	unique row not found
1	SIMPLE	SalesSchool	ALL					32
1	SIMPLE	SalesImage	ALL					1
1	SIMPLE	SalesTerm	ALL					34

Query: SELECT `OptionsSalesPropertyType`.`id`, `OptionsSalesPropertyType`.`name`, `OptionsSalesPropertyType`.`created`, `OptionsSalesPropertyType`.`modified` FROM `options_sales_property_types` AS `OptionsSalesPropertyType` WHERE `OptionsSalesPropertyType`.`id` = 0

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Query: SELECT `SalesFeature`.`has_porch`, `SalesFeature`.`has_patio`, `SalesFeature`.`has_deck`, `SalesFeature`.`has_skylight`, `SalesFeature`.`has_fireplace`, `SalesFeature`.`has_ww_carpet`, `SalesFeature`.`has_hardwood_floor`, `SalesFeature`.`has_handicap_access`, `SalesFeature`.`has_basement`, `SalesFeature`.`has_basement_finished`, `SalesFeature`.`has_driveway`, `SalesFeature`.`options_driveway_id`, `SalesFeature`.`has_garage`, `SalesFeature`.`options_garage_id`, `SalesFeature`.`has_pool`, `SalesFeature`.`options_pool_id`, `SalesFeature`.`has_sprinklers`, `SalesFeature`.`has_water_view`, `SalesFeature`.`is_waterfront`, `SalesFeature`.`is_water_frontage`, `SalesFeature`.`has_beach_rights`, `SalesFeature`.`has_docking_rights`, `SalesFeature`.`has_storage`, `SalesFeature`.`has_common_garden`, `SalesFeature`.`has_private_garden`, `SalesFeature`.`has_elevator`, `SalesFeature`.`created`, `SalesFeature`.`modified`, `SalesFeature`.`id`, `SalesFeature`.`listing_id` FROM `sales_features` AS `SalesFeature` WHERE `SalesFeature`.`listing_id` = 29

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Query: SELECT `SalesAppliance`.`id`, `SalesAppliance`.`listing_id`, `SalesAppliance`.`has_stove`, `SalesAppliance`.`has_fridge`, `SalesAppliance`.`has_dishwasher`, `SalesAppliance`.`has_washer`, `SalesAppliance`.`has_dryer`, `SalesAppliance`.`has_separate_hw_water`, `SalesAppliance`.`options_heat_id`, `SalesAppliance`.`options_fuel_id`, `SalesAppliance`.`options_water_id`, `SalesAppliance`.`has_sewer`, `SalesAppliance`.`has_ac`, `SalesAppliance`.`created`, `SalesAppliance`.`modified` FROM `sales_appliances` AS `SalesAppliance` WHERE `SalesAppliance`.`listing_id` = 29

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Query: SELECT `SalesTerm`.`id`, `SalesTerm`.`listing_id`, `SalesTerm`.`price`, `SalesTerm`.`taxes`, `SalesTerm`.`maintenance`, `SalesTerm`.`other_charges`, `SalesTerm`.`common_charge` FROM `sales_terms` AS `SalesTerm` WHERE `SalesTerm`.`listing_id` = 29

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	SalesTerm	ALL					34	Using where

Query: SELECT `SalesRoom`.`id`, `SalesRoom`.`listing_id`, `SalesRoom`.`rooms`, `SalesRoom`.`options_bedroom_id`, `SalesRoom`.`bathrooms`, `SalesRoom`.`bathroom_full`, `SalesRoom`.`bathroom_half`, `SalesRoom`.`kitchens`, `SalesRoom`.`has_kitchen_eat_in`, `SalesRoom`.`options_dining_room_id`, `SalesRoom`.`has_family_room`, `SalesRoom`.`has_office_room`, `SalesRoom`.`has_attic`, `SalesRoom`.`created`, `SalesRoom`.`modified` FROM `sales_rooms` AS `SalesRoom` WHERE `SalesRoom`.`listing_id` = 29

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Query: SELECT `SalesSchool`.`id`, `SalesSchool`.`listing_id`, `SalesSchool`.`school_district_name`, `SalesSchool`.`school_district_number`, `SalesSchool`.`created`, `SalesSchool`.`modified` FROM `sales_schools` AS `SalesSchool` WHERE `SalesSchool`.`listing_id` = 29

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	SalesSchool	ALL					32	Using where

Query: SELECT `SalesImage`.`id`, `SalesImage`.`listing_id`, `SalesImage`.`fileupload_id`, `SalesImage`.`created`, `SalesImage`.`modified` FROM `sales_images` AS `SalesImage` WHERE `SalesImage`.`listing_id` = 29

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Query: SELECT `Fileupload`.`id`, `Fileupload`.`form_name`, `Fileupload`.`foreign_id`, `Fileupload`.`file_name`, `Fileupload`.`mime_type`, `Fileupload`.`extension`, `Fileupload`.`dir`, `Fileupload`.`file_size`, `Fileupload`.`caption`, `Fileupload`.`full_path`, `Fileupload`.`show_top_ten`, `Fileupload`.`created`, `Fileupload`.`modified` FROM `fileuploads` AS `Fileupload` WHERE `Fileupload`.`form_name` = 'listings' AND `Fileupload`.`foreign_id` = (29)

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Query: SELECT `Configuration`.`id`, `Configuration`.`namespace`, `Configuration`.`config_key`, `Configuration`.`config_value`, `Configuration`.`is_public`, `Configuration`.`created`, `Configuration`.`modified` FROM `configurations` AS `Configuration` WHERE `Configuration`.`config_key` = 'meta_keywords' AND `Configuration`.`namespace` = 'app' LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

Query: SELECT `Configuration`.`id`, `Configuration`.`namespace`, `Configuration`.`config_key`, `Configuration`.`config_value`, `Configuration`.`is_public`, `Configuration`.`created`, `Configuration`.`modified` FROM `configurations` AS `Configuration` WHERE `Configuration`.`config_key` = 'meta_description' AND `Configuration`.`namespace` = 'app' LIMIT 1

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE								Impossible WHERE noticed after reading const tables

====

Timer

Memory

Peak Memory Use 16.67 MB

Message	Memory use
Component intitailization	12.12 MB
Controller action start	12.18 MB
Controller render start	14.77 MB
View render complete	16.24 MB

Timers

Total Request Time: 895 (ms)

Message	Time in ms	Graph
Core Processing (Derived)	237.93
Component initialization and startup	9.88
Controller action	226.14
Render Controller Action	20.93
» Rendering View	19.06
» » Rendering APP/views/listings/view.ctp	15.85
» » » Rendering APP/views/elements/backend_view_functions.ctp	0.36
» » » Rendering APP/views/elements/listings/general_info.ctp	0.40
» » Rendering APP/views/layouts/no_sidebar.ctp	1.93
» » » Rendering APP/views/elements/javascripts.ctp	0.26
» » » Rendering APP/views/elements/homepage_search_form.ctp	0.20
» » » Rendering APP/views/elements/top_nav.ctp	0.16
» » » Rendering APP/views/elements/footer.ctp	0.16
» » » Rendering APP/views/elements/bottom_credits.ctp	0.22

====

Log

Logs

error.log

There were no log entries made this request

debug.log

There were no log entries made this request

====
Variables
View Variables
- data
  Listing
  id29
  codeSTCTSICS
  listing_type
  titleShelton Ice Cream Shop
  address
  cross_streets
  cityShelton
  stateCT
  zip
  options_class_id(null)
  options_style_id(null)
  options_sales_property_type_id0
  options_construction_type_id(null)
  is_new_construction(null)
  year_built0
  options_appearance_id(null)
  footage
  options_attachment_id(null)
  lot_size
  lot_footage
  building_size
  zone
  options_basement_id(null)
  general_infoAll brand new ice cream equipment and loads of refrigeration
  is_published0
  created2010-08-03 13:32:23
  modified2010-08-03 13:32:23
  OptionsConstructionType
  id(null)
  name(null)
  created(null)
  modified(null)
  OptionsAppearance
  id(null)
  name(null)
  form(null)
  table_name(null)
  created(null)
  modified(null)
  OptionsAttachment
  id(null)
  name(null)
  created(null)
  modified(null)
  OptionsClass
  id(null)
  name(null)
  form(null)
  table_name(null)
  created(null)
  modified(null)
  OptionsStyle
  id(null)
  name(null)
  form(null)
  table_name(null)
  created(null)
  modified(null)
  OptionsBasement
  id(null)
  name(null)
  created(null)
  modified(null)
  OptionsSalesPropertyType
  id(null)
  name(null)
  created(null)
  modified(null)
  SalesFeature
  has_porch(null)
  has_patio(null)
  has_deck(null)
  has_skylight(null)
  has_fireplace(null)
  has_ww_carpet(null)
  has_hardwood_floor(null)
  has_handicap_access(null)
  has_basement(null)
  has_basement_finished(null)
  has_driveway(null)
  options_driveway_id(null)
  has_garage(null)
  options_garage_id(null)
  has_pool(null)
  options_pool_id(null)
  has_sprinklers(null)
  has_water_view(null)
  is_waterfront(null)
  is_water_frontage(null)
  has_beach_rights(null)
  has_docking_rights(null)
  has_storage(null)
  has_common_garden(null)
  has_private_garden(null)
  has_elevator(null)
  created(null)
  modified(null)
  id(null)
  listing_id(null)
  SalesAppliance
  id(null)
  listing_id(null)
  has_stove(null)
  has_fridge(null)
  has_dishwasher(null)
  has_washer(null)
  has_dryer(null)
  has_separate_hw_water(null)
  options_heat_id(null)
  options_fuel_id(null)
  options_water_id(null)
  has_sewer(null)
  has_ac(null)
  created(null)
  modified(null)
  SalesTerm
  id(null)
  listing_id(null)
  price(null)
  taxes(null)
  maintenance(null)
  other_charges(null)
  common_charge(null)
  SalesRoom
  id(null)
  listing_id(null)
  rooms(null)
  options_bedroom_id(null)
  bathrooms(null)
  bathroom_full(null)
  bathroom_half(null)
  kitchens(null)
  has_kitchen_eat_in(null)
  options_dining_room_id(null)
  has_family_room(null)
  has_office_room(null)
  has_attic(null)
  created(null)
  modified(null)
  SalesImage
  img(empty)
  thumb(null)
  SalesAllImages(empty)
- values_other
  -1N/A
  0No
  1Yes
  2Other
- values_private
  -1N/A
  0No
  1Private
  2Common
- values_bedrooms
  -1N/A
  13
  1Studio
  21
  32
  43
  54
  65
  76
  87
  98
  109
  1210
- is_logged_in(true)
- $this->data(null)
- $this->validationErrors(empty)
- Loaded Helpers
  0form
  1html
  2validation
  3javascript
  4toolbar
  5htmlToolbar
  6number
  7simpleGraph
  8session
====
Server
Server
- PATH/bin:/usr/bin:/sbin:/usr/sbin
- RAILS_ENVproduction
- FCGI_ROLERESPONDER
- REDIRECT_REDIRECT_UNIQUE_IDT7l7KkWj3HIAAHIY4j4AAAAM
- REDIRECT_REDIRECT_SCRIPT_URL/listings/view/29
- REDIRECT_REDIRECT_SCRIPT_URIhttp://www.guttmanrealty.com/listings/view/29
- REDIRECT_REDIRECT_dsid19454419
- REDIRECT_REDIRECT_ds_id_19454419
- REDIRECT_REDIRECT_DH_USERguttmanrealty
- REDIRECT_REDIRECT_STATUS200
- REDIRECT_UNIQUE_IDT7l7KkWj3HIAAHIY4j4AAAAM
- REDIRECT_SCRIPT_URL/listings/view/29
- REDIRECT_SCRIPT_URIhttp://www.guttmanrealty.com/listings/view/29
- REDIRECT_dsid19454419
- REDIRECT_ds_id_19454419
- REDIRECT_DH_USERguttmanrealty
- REDIRECT_STATUS200
- UNIQUE_IDT7l7KkWj3HIAAHIY4j4AAAAM
- SCRIPT_URL/listings/view/29
- SCRIPT_URIhttp://www.guttmanrealty.com/listings/view/29
- dsid19454419
- ds_id_19454419
- DH_USERguttmanrealty
- HTTP_X_CC_IDccc02-01
- HTTP_HOSTwww.guttmanrealty.com
- HTTP_USER_AGENTCCBot/1.0 (+http://www.commoncrawl.org/bot.html)
- HTTP_ACCEPTtext/html,application/xhtml+xml,text/xml;q=0.9,text/plain;q=0.8,image/png,*/*;q=0.5
- HTTP_ACCEPT_LANGUAGEen-us,en;q=0.5
- HTTP_ACCEPT_ENCODINGgzip
- HTTP_ACCEPT_CHARSETISO-8859-1,utf-8;q=0.7,*;q=0.7
- HTTP_CONNECTIONclose
- HTTP_CACHE_CONTROLno-cache
- HTTP_PRAGMAno-cache
- HTTP_COOKIEIPRO=sf1o1ffj5ijboml0k6c2f8k4j3
- SERVER_SIGNATURE
- SERVER_SOFTWAREApache
- SERVER_NAMEwww.guttmanrealty.com
- SERVER_ADDR69.163.223.32
- SERVER_PORT80
- REMOTE_ADDR38.107.179.220
- DOCUMENT_ROOT/home/guttmanrealty/guttmanrealty.com
- SERVER_ADMINwebmaster@guttmanrealty.com
- SCRIPT_FILENAME/home/guttmanrealty/guttmanrealty.com/app/webroot/index.php
- REMOTE_PORT42655
- REDIRECT_QUERY_STRINGurl=listings/view/29
- REDIRECT_URL/app/webroot/listings/view/29
- GATEWAY_INTERFACECGI/1.1
- SERVER_PROTOCOLHTTP/1.1
- REQUEST_METHODGET
- QUERY_STRINGurl=listings/view/29
- REQUEST_URI/listings/view/29
- SCRIPT_NAME/app/webroot/index.php
- PHP_SELF/app/webroot/index.php
- REQUEST_TIME1337555754
- argv
  0url=listings/view/29
- argc1
- $this->validationErrors(empty)
====

Quick Search:

Shelton Ice Cream Shop

Images

Address

Description

General Info1

Terms

Request History

Session

Request

Cake Params

$_GET

Cookie

Current Route

Sql Logs

default

Memory

Timers

Logs

error.log

debug.log

View Variables

Server