| 1 | SELECT `Setting`.`id`, `Setting`.`from_name`, `Setting`.`from_email`, `Setting`.`admin_email`, `Setting`.`admin_email2`, `Setting`.`admin_contact`, `Setting`.`admin_address`, `Setting`.`admin_timings`, `Setting`.`admin_mobile`, `Setting`.`footer_text`, `Setting`.`banner_description`, `Setting`.`facebook_url`, `Setting`.`twitter_url`, `Setting`.`linkdin_url`, `Setting`.`google_url`, `Setting`.`youtube_url`, `Setting`.`instagram_url`, `Setting`.`created_by`, `Setting`.`created`, `Setting`.`modified`, `Setting`.`meta_title`, `Setting`.`meta_keywords`, `Setting`.`meta_description`, `Setting`.`analytics`, `Setting`.`logo_image`, `Setting`.`new_property_count`, `Setting`.`property_order`, `Setting`.`updated_property_count`, `Setting`.`updated_property_order`, `Setting`.`featured_property_count`, `Setting`.`featured_property_order`, `Setting`.`testimonial_count`, `Setting`.`map_content`, `Setting`.`timezone`, `Setting`.`default_language`, `Setting`.`default_currency`, `Setting`.`favicon` FROM `dxcake_17`.`settings` AS `Setting` WHERE `created_by` = 1 LIMIT 1 | | 1 | 1 | 0 |
| 2 | SELECT `Setting`.`new_property_count`, `Setting`.`property_order`, `Setting`.`updated_property_count`, `Setting`.`updated_property_order`, `Setting`.`featured_property_count`, `Setting`.`featured_property_order` FROM `dxcake_17`.`settings` AS `Setting` WHERE `Setting`.`id` = 1 LIMIT 1 | | 1 | 1 | 0 |
| 3 | SELECT `Category`.`cat_name` FROM `dxcake_17`.`categories` AS `Category` WHERE `slug` = 'Apartments' LIMIT 1 | | 1 | 1 | 0 |
| 4 | SELECT `Category`.`id` FROM `dxcake_17`.`categories` AS `Category` WHERE `slug` = 'Apartments' LIMIT 1 | | 1 | 1 | 0 |
| 5 | SELECT `Property`.`id`, `Property`.`title`, `Property`.`slug`, `Property`.`address`, `Property`.`price`, `Property`.`special_price`, `Property`.`reference_number`, `Property`.`area`, `Property`.`plot_size`, `Property`.`energy_rating`, `Property`.`land_water_supply`, `Property`.`land_electricity_supply`, `Property`.`nearest_village`, `Property`.`short_description`, `Property`.`bedrooms`, `Property`.`bathrooms`, `Property`.`pool`, `Property`.`lat`, `Property`.`lng`, `Property`.`total_building_allowance`, `Property`.`video_name`, `Category`.`cat_name`, `Category`.`slug`, `Category`.`meta_title`, `Category`.`meta_keywords`, `Category`.`meta_description`, `Village`.`title` FROM `dxcake_17`.`properties` AS `Property` LEFT JOIN `dxcake_17`.`categories` AS `Category` ON (`Property`.`category_id` = `Category`.`id`) LEFT JOIN `dxcake_17`.`villages` AS `Village` ON (`Village`.`id`=`Property`.`nearest_village`) LEFT JOIN `dxcake_17`.`property_agent_details` AS `PropertyAgentDetail` ON (`PropertyAgentDetail`.`property_id` = `Property`.`id`) WHERE `Property`.`status` = 1 AND `Property`.`trash` = 0 AND `Category`.`slug` = 'Apartments' ORDER BY `Property`.`reference_number` DESC LIMIT 12 | | 7 | 7 | 1 |
| 6 | SELECT `PropertyImage`.`id`, `PropertyImage`.`property_id`, `PropertyImage`.`name`, `PropertyImage`.`is_cover`, `PropertyImage`.`position`, `PropertyImage`.`status`, `PropertyImage`.`created`, `PropertyImage`.`modified` FROM `dxcake_17`.`property_images` AS `PropertyImage` WHERE `PropertyImage`.`status` = 1 AND `PropertyImage`.`property_id` IN (1307, 1297, 1265, 1228, 1162, 1284, 809) ORDER BY `PropertyImage`.`is_cover` DESC, `PropertyImage`.`id` DESC | | 138 | 138 | 1 |
| 7 | SELECT `Village`.`id`, `Village`.`title` FROM `dxcake_17`.`villages` AS `Village` WHERE `Village`.`status` = 1 ORDER BY `Village`.`title` ASC | | 45 | 45 | 0 |
