67 E. Water St., Rosemary Beach, FL 32413
0 Stars
There are 0 comments for this property.
| Nr | Query | Error | Affected | Num. rows | Took (ms) |
|---|---|---|---|---|---|
| 1 | DESCRIBE `ratings` | 6 | 6 | 0 | |
| 2 | DESCRIBE `listings` | 36 | 36 | 1 | |
| 3 | DESCRIBE `site_users` | 25 | 25 | 1 | |
| 4 | DESCRIBE `daily_digests` | 8 | 8 | 0 | |
| 5 | DESCRIBE `auctions` | 19 | 19 | 0 | |
| 6 | DESCRIBE `auction_winners` | 5 | 5 | 0 | |
| 7 | DESCRIBE `bids` | 11 | 11 | 0 | |
| 8 | DESCRIBE `saved_listings` | 3 | 3 | 0 | |
| 9 | DESCRIBE `saved_searches` | 7 | 7 | 0 | |
| 10 | DESCRIBE `sent_auction_notifications` | 2 | 2 | 0 | |
| 11 | DESCRIBE `sent_listing_notifications` | 4 | 4 | 0 | |
| 12 | DESCRIBE `sent_offer_wall_notifications` | 3 | 3 | 1 | |
| 13 | DESCRIBE `email_group_users` | 5 | 5 | 0 | |
| 14 | DESCRIBE `email_groups` | 4 | 4 | 0 | |
| 15 | DESCRIBE `admin_email_groups` | 3 | 3 | 0 | |
| 16 | DESCRIBE `offer_wall` | 25 | 25 | 1 | |
| 17 | DESCRIBE `payments` | 14 | 14 | 1 | |
| 18 | DESCRIBE `listing_images` | 8 | 8 | 1 | |
| 19 | DESCRIBE `rates` | 8 | 8 | 1 | |
| 20 | DESCRIBE `open_weeks` | 5 | 5 | 0 | |
| 21 | DESCRIBE `zipcodes` | 10 | 10 | 0 | |
| 22 | DESCRIBE `amenities` | 6 | 6 | 0 | |
| 23 | DESCRIBE `groups` | 2 | 2 | 0 | |
| 24 | DESCRIBE `amenities_listings` | 3 | 3 | 0 | |
| 25 | DESCRIBE `settings` | 7 | 7 | 1 | |
| 26 | SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`type`, `Setting`.`label`, `Setting`.`order` FROM `settings` AS `Setting` WHERE 1 = 1 | 12 | 12 | 0 | |
| 27 | SELECT `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` WHERE `Listing`.`id` = 149 LIMIT 1 | 1 | 1 | 0 | |
| 28 | SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`listing_id` = 149 | 1 | 1 | 0 | |
| 29 | SELECT `Rating`.`id`, `Rating`.`rating`, `Rating`.`site_user_id`, `Rating`.`listing_id`, `Rating`.`comment`, `Rating`.`created` FROM `ratings` AS `Rating` WHERE `Rating`.`listing_id` = 149 LIMIT 20 | 0 | 0 | 0 | |
| 30 | SELECT 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' | 1 | 1 | 0 |