| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|
| 1 | DESCRIBE `aros` | | 7 | 7 | 3 |
| 2 | DESCRIBE `acos` | | 7 | 7 | 1 |
| 3 | DESCRIBE `aros_acos` | | 7 | 7 | 6 |
| 4 | DESCRIBE `listings` | | 27 | 27 | 4 |
| 5 | DESCRIBE `options_construction_types` | | 4 | 4 | 1 |
| 6 | DESCRIBE `options_appearances` | | 6 | 6 | 1 |
| 7 | DESCRIBE `options_attachments` | | 4 | 4 | 2 |
| 8 | DESCRIBE `options_classes` | | 6 | 6 | 2 |
| 9 | DESCRIBE `options_styles` | | 6 | 6 | 5 |
| 10 | DESCRIBE `options_basements` | | 4 | 4 | 7 |
| 11 | DESCRIBE `options_sales_property_types` | | 4 | 4 | 6 |
| 12 | DESCRIBE `sales_features` | | 30 | 30 | 6 |
| 13 | DESCRIBE `options_garages` | | 6 | 6 | 2 |
| 14 | DESCRIBE `options_driveways` | | 6 | 6 | 1 |
| 15 | DESCRIBE `options_pools` | | 6 | 6 | 1 |
| 16 | DESCRIBE `sales_appliances` | | 15 | 15 | 3 |
| 17 | DESCRIBE `options_heats` | | 6 | 6 | 3 |
| 18 | DESCRIBE `options_fuels` | | 6 | 6 | 4 |
| 19 | DESCRIBE `options_waters` | | 6 | 6 | 7 |
| 20 | DESCRIBE `sales_terms` | | 7 | 7 | 3 |
| 21 | DESCRIBE `sales_rooms` | | 15 | 15 | 1 |
| 22 | DESCRIBE `options_dining_rooms` | | 4 | 4 | 3 |
| 23 | DESCRIBE `options_bedrooms` | | 4 | 4 | 1 |
| 24 | DESCRIBE `sales_schools` | | 6 | 6 | 2 |
| 25 | DESCRIBE `sales_images` | | 5 | 5 | 2 |
| 26 | DESCRIBE `fileuploads` | | 13 | 13 | 2 |
| 27 | DESCRIBE `sales_features_lists` | | 4 | 4 | 2 |
| 28 | DESCRIBE `options_sales_features` | | 4 | 4 | 5 |
| 29 | DESCRIBE `specials` | | 13 | 13 | 3 |
| 30 | SELECT `Special`.`id`, `Special`.`src`, `Special`.`sales_id`, `Special`.`foreign_key`, `Special`.`table_name`, `Special`.`mls_number`, `Special`.`title`, `Special`.`city`, `Special`.`price`, `Special`.`img_url`, `Special`.`url`, `Special`.`created`, `Special`.`modified` FROM `specials` AS `Special` WHERE 1 = 1 | | 0 | 0 | 4 |
| 31 | 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 1 = 1 | | 26 | 26 | 33 |
| 32 | 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` IN (1, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 29) | | 0 | 0 | 9 |
| 33 | DESCRIBE `configurations` | | 7 | 7 | 10 |
| 34 | DESCRIBE `logs` | | 9 | 9 | 7 |
| 35 | DESCRIBE `users` | | 10 | 10 | 10 |
| 36 | DESCRIBE `groups` | | 4 | 4 | 9 |
| 37 | DESCRIBE `profiles` | | 10 | 10 | 4 |
| 38 | 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 | 7 |
| 39 | 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 | 6 |
Query: SELECT `Special`.`id`, `Special`.`src`, `Special`.`sales_id`, `Special`.`foreign_key`, `Special`.`table_name`, `Special`.`mls_number`, `Special`.`title`, `Special`.`city`, `Special`.`price`, `Special`.`img_url`, `Special`.`url`, `Special`.`created`, `Special`.`modified` FROM `specials` AS `Special` WHERE 1 = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | Special | system | | | | | 0 | const row not found |
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 1 = 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 | ALL | | | | | 26 | |
| 1 | SIMPLE | SalesSchool | ALL | | | | | 32 | |
| 1 | SIMPLE | SalesImage | ALL | | | | | 1 | |
| 1 | SIMPLE | OptionsConstructionType | eq_ref | PRIMARY | PRIMARY | 4 | guttmanrealty.Listing.options_construction_type_id | 1 | |
| 1 | SIMPLE | OptionsAppearance | eq_ref | PRIMARY | PRIMARY | 4 | guttmanrealty.Listing.options_appearance_id | 1 | |
| 1 | SIMPLE | OptionsAttachment | eq_ref | PRIMARY | PRIMARY | 4 | guttmanrealty.Listing.options_attachment_id | 1 | |
| 1 | SIMPLE | OptionsClass | eq_ref | PRIMARY | PRIMARY | 4 | guttmanrealty.Listing.options_class_id | 1 | |
| 1 | SIMPLE | OptionsStyle | eq_ref | PRIMARY | PRIMARY | 4 | guttmanrealty.Listing.options_style_id | 1 | |
| 1 | SIMPLE | OptionsBasement | eq_ref | PRIMARY | PRIMARY | 4 | guttmanrealty.Listing.options_basement_id | 1 | |
| 1 | SIMPLE | OptionsSalesPropertyType | eq_ref | PRIMARY | PRIMARY | 4 | guttmanrealty.Listing.options_sales_property_type_id | 1 | |
| 1 | SIMPLE | SalesTerm | ALL | | | | | 34 | |
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` IN (1, 5, 6, 7, 8, 9, 10, 11, 12, 13, 14, 15, 16, 17, 18, 19, 20, 21, 22, 23, 24, 25, 26, 27, 28, 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 |