Saint's Rest at The Savannah

Saint's Rest at The Savannah
        Available
        Unavailable
        Tentatively Booked
 
Follow us on Twitter Follow us on Facebook
(default) 40 queries took 50 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `listings`36361
2DESCRIBE `site_users`25251
3DESCRIBE `daily_digests`881
4DESCRIBE `auctions`19191
5DESCRIBE `auction_winners`550
6DESCRIBE `bids`11111
7DESCRIBE `saved_listings`330
8DESCRIBE `saved_searches`770
9DESCRIBE `sent_auction_notifications`221
10DESCRIBE `sent_listing_notifications`440
11DESCRIBE `sent_offer_wall_notifications`331
12DESCRIBE `email_group_users`550
13DESCRIBE `email_groups`441
14DESCRIBE `admin_email_groups`331
15DESCRIBE `offer_wall`25251
16DESCRIBE `payments`14141
17DESCRIBE `listing_images`881
18DESCRIBE `rates`880
19DESCRIBE `ratings`660
20DESCRIBE `open_weeks`550
21DESCRIBE `zipcodes`10101
22DESCRIBE `amenities`660
23DESCRIBE `groups`220
24DESCRIBE `amenities_listings`331
25DESCRIBE `listing_views`551
26DESCRIBE `site_user_owners`551
27DESCRIBE `listing_areas`12121
28DESCRIBE `settings`771
29SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`type`, `Setting`.`label`, `Setting`.`order` FROM `settings` AS `Setting` WHERE 1 = 1 12121
30SELECT `Listing`.`id`, `Listing`.`site_user_id`, `Listing`.`payment_id`, `Listing`.`title`, `Listing`.`description`, `Listing`.`address`, `Listing`.`city`, `Listing`.`state`, `Listing`.`zipcode`, `Listing`.`country`, `Listing`.`bedrooms`, `Listing`.`bathrooms`, `Listing`.`sleeps`, `Listing`.`square_feet`, `Listing`.`area`, `Listing`.`seo_url`, `Listing`.`seo_title`, `Listing`.`metatitle`, `Listing`.`calendar_url`, `Listing`.`active`, `Listing`.`other_features`, `Listing`.`getaway`, `Listing`.`getaway_price`, `Listing`.`getaway_from_date`, `Listing`.`getaway_to_date`, `Listing`.`primary_image_id`, `Listing`.`rating_count`, `Listing`.`created`, `Listing`.`modified`, `Listing`.`latitude`, `Listing`.`longitude`, `Listing`.`management_company`, `Listing`.`area_type_mountain`, `Listing`.`area_type_beach`, `Listing`.`area_type_city`, `Listing`.`area_type_other` FROM `listings` AS `Listing` left JOIN listing_images AS `ListingImage` ON (`ListingImage`.`id` = `Listing`.`primary_image_id`) WHERE `Listing`.`id` = 133 AND `Listing`.`active` = 1 LIMIT 1110
31SELECT `Listing`.`id`, `Listing`.`site_user_id`, `Listing`.`payment_id`, `Listing`.`title`, `Listing`.`description`, `Listing`.`address`, `Listing`.`city`, `Listing`.`state`, `Listing`.`zipcode`, `Listing`.`country`, `Listing`.`bedrooms`, `Listing`.`bathrooms`, `Listing`.`sleeps`, `Listing`.`square_feet`, `Listing`.`area`, `Listing`.`seo_url`, `Listing`.`seo_title`, `Listing`.`metatitle`, `Listing`.`calendar_url`, `Listing`.`active`, `Listing`.`other_features`, `Listing`.`getaway`, `Listing`.`getaway_price`, `Listing`.`getaway_from_date`, `Listing`.`getaway_to_date`, `Listing`.`primary_image_id`, `Listing`.`rating_count`, `Listing`.`created`, `Listing`.`modified`, `Listing`.`latitude`, `Listing`.`longitude`, `Listing`.`management_company`, `Listing`.`area_type_mountain`, `Listing`.`area_type_beach`, `Listing`.`area_type_city`, `Listing`.`area_type_other`, `SiteUser`.`id`, `SiteUser`.`username`, `SiteUser`.`password`, `SiteUser`.`name`, `SiteUser`.`company_name`, `SiteUser`.`address`, `SiteUser`.`city`, `SiteUser`.`state`, `SiteUser`.`zipcode`, `SiteUser`.`phone`, `SiteUser`.`email`, `SiteUser`.`cc_email`, `SiteUser`.`created`, `SiteUser`.`modified`, `SiteUser`.`active`, `SiteUser`.`marketing`, `SiteUser`.`notify_emails`, `SiteUser`.`notify_wall_emails`, `SiteUser`.`search_emails`, `SiteUser`.`group`, `SiteUser`.`accepted_terms`, `SiteUser`.`management`, `SiteUser`.`referral_code`, `SiteUser`.`remote_login_key`, `SiteUser`.`advanced_dashboard`, `Payment`.`id`, `Payment`.`site_user_id`, `Payment`.`listing_id`, `Payment`.`invoice_number`, `Payment`.`auth_id`, `Payment`.`transaction_id`, `Payment`.`subscription_id`, `Payment`.`subscription_text`, `Payment`.`subscription_code`, `Payment`.`amount`, `Payment`.`response_reason_code`, `Payment`.`response_reason_text`, `Payment`.`terms`, `Payment`.`created` FROM `listings` AS `Listing` LEFT JOIN `site_users` AS `SiteUser` ON (`Listing`.`site_user_id` = `SiteUser`.`id`) LEFT JOIN `payments` AS `Payment` ON (`Payment`.`listing_id` = `Listing`.`id`) WHERE `Listing`.`id` = 133 LIMIT 1111
32SELECT `Zipcode`.`id`, `Zipcode`.`zipcode`, `Zipcode`.`zip_type`, `Zipcode`.`city_name`, `Zipcode`.`city_type`, `Zipcode`.`state_name`, `Zipcode`.`state_abbr`, `Zipcode`.`area_code`, `Zipcode`.`latitude`, `Zipcode`.`longitude` FROM `zipcodes` AS `Zipcode` WHERE `Zipcode`.`zipcode` = (133) 0030
33SELECT `Auction`.`id`, `Auction`.`listing_id`, `Auction`.`site_user_id`, `Auction`.`reserve`, `Auction`.`buy_it_now`, `Auction`.`purchased`, `Auction`.`vacation_start_date`, `Auction`.`vacation_end_date`, `Auction`.`auction_start_date`, `Auction`.`auction_end_date`, `Auction`.`blind`, `Auction`.`description`, `Auction`.`bid_count`, `Auction`.`awarded`, `Auction`.`closed_notification`, `Auction`.`re_activate`, `Auction`.`display`, `Auction`.`created`, `Auction`.`modified` FROM `auctions` AS `Auction` WHERE `Auction`.`listing_id` = (133) 000
34SELECT `ListingImage`.`id`, `ListingImage`.`listing_id`, `ListingImage`.`thumb`, `ListingImage`.`orig`, `ListingImage`.`rotate`, `ListingImage`.`created`, `ListingImage`.`modified`, `ListingImage`.`file_hash` FROM `listing_images` AS `ListingImage` WHERE `ListingImage`.`listing_id` = (133) 12120
35SELECT `Rate`.`id`, `Rate`.`site_user_id`, `Rate`.`listing_id`, `Rate`.`title`, `Rate`.`from_date`, `Rate`.`to_date`, `Rate`.`weekly`, `Rate`.`nightly` FROM `rates` AS `Rate` WHERE `Rate`.`listing_id` = (133) 770
36SELECT `SavedListing`.`id`, `SavedListing`.`site_user_id`, `SavedListing`.`listing_id` FROM `saved_listings` AS `SavedListing` WHERE `SavedListing`.`listing_id` = (133) 000
37SELECT `Rating`.`id`, `Rating`.`rating`, `Rating`.`site_user_id`, `Rating`.`listing_id`, `Rating`.`comment`, `Rating`.`created` FROM `ratings` AS `Rating` WHERE `Rating`.`listing_id` = (133) 000
38SELECT `OpenWeeks`.`id`, `OpenWeeks`.`listing_id`, `OpenWeeks`.`open_dates`, `OpenWeeks`.`has_open_dates`, `OpenWeeks`.`updated` FROM `open_weeks` AS `OpenWeeks` WHERE `OpenWeeks`.`listing_id` = (133) 000
39SELECT `Amenity`.`id`, `Amenity`.`title`, `Amenity`.`group_id`, `Amenity`.`show_on_offer_wall`, `Amenity`.`created`, `Amenity`.`modified`, `AmenitiesListing`.`id`, `AmenitiesListing`.`amenity_id`, `AmenitiesListing`.`listing_id` FROM `amenities` AS `Amenity` JOIN `amenities_listings` AS `AmenitiesListing` ON (`AmenitiesListing`.`listing_id` = 133 AND `AmenitiesListing`.`amenity_id` = `Amenity`.`id`) WHERE 1 = 1 15150
40SELECT COUNT(*) AS `count` FROM `auctions` AS `Auction` LEFT JOIN `listings` AS `Listing` ON (`Auction`.`listing_id` = `Listing`.`id`) LEFT JOIN `site_users` AS `SiteUser` ON (`Auction`.`site_user_id` = `SiteUser`.`id`) LEFT JOIN `auction_winners` AS `AuctionWinner` ON (`AuctionWinner`.`auction_id` = `Auction`.`id`) WHERE `Auction`.`auction_end_date` >= '2025-06-30' AND `Auction`.`auction_start_date` <= '2025-06-30' 110
(ownerware) 3 queries took 6 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `events_property`35351
2DESCRIBE `listings`32321
3SELECT `EventsProperty`.`event_id`, `EventsProperty`.`user_id`, `EventsProperty`.`property_id`, `EventsProperty`.`event_name`, `EventsProperty`.`start_date`, `EventsProperty`.`end_date`, `EventsProperty`.`totalrent`, `EventsProperty`.`baserate`, `EventsProperty`.`petfees`, `EventsProperty`.`cleaningfees`, `EventsProperty`.`linens`, `EventsProperty`.`taxes`, `EventsProperty`.`otherrate`, `EventsProperty`.`markas`, `EventsProperty`.`notifyrenter`, `EventsProperty`.`rentername`, `EventsProperty`.`emailadd`, `EventsProperty`.`phone`, `EventsProperty`.`amenity`, `EventsProperty`.`special_service`, `EventsProperty`.`attachment`, `EventsProperty`.`note`, `EventsProperty`.`smcnote`, `EventsProperty`.`smc_notes`, `EventsProperty`.`owner_notes`, `EventsProperty`.`saddress`, `EventsProperty`.`saddress2`, `EventsProperty`.`city`, `EventsProperty`.`state`, `EventsProperty`.`zip`, `EventsProperty`.`additionalphone`, `EventsProperty`.`create_date`, `EventsProperty`.`modifydate`, `EventsProperty`.`imported_ovw`, `EventsProperty`.`noti_trigger` FROM `events_property` AS `EventsProperty` WHERE `property_id` = 133 004