| 1 | DESCRIBE `listings` | | 36 | 36 | 1 |
| 2 | DESCRIBE `site_users` | | 25 | 25 | 1 |
| 3 | DESCRIBE `daily_digests` | | 8 | 8 | 0 |
| 4 | DESCRIBE `auctions` | | 19 | 19 | 0 |
| 5 | DESCRIBE `auction_winners` | | 5 | 5 | 0 |
| 6 | DESCRIBE `bids` | | 11 | 11 | 0 |
| 7 | DESCRIBE `saved_listings` | | 3 | 3 | 0 |
| 8 | DESCRIBE `saved_searches` | | 7 | 7 | 0 |
| 9 | DESCRIBE `sent_auction_notifications` | | 2 | 2 | 0 |
| 10 | DESCRIBE `sent_listing_notifications` | | 4 | 4 | 0 |
| 11 | DESCRIBE `sent_offer_wall_notifications` | | 3 | 3 | 0 |
| 12 | DESCRIBE `email_group_users` | | 5 | 5 | 0 |
| 13 | DESCRIBE `email_groups` | | 4 | 4 | 0 |
| 14 | DESCRIBE `admin_email_groups` | | 3 | 3 | 0 |
| 15 | DESCRIBE `offer_wall` | | 25 | 25 | 0 |
| 16 | DESCRIBE `payments` | | 14 | 14 | 0 |
| 17 | DESCRIBE `listing_images` | | 8 | 8 | 0 |
| 18 | DESCRIBE `rates` | | 8 | 8 | 1 |
| 19 | DESCRIBE `ratings` | | 6 | 6 | 0 |
| 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 `listing_views` | | 5 | 5 | 0 |
| 26 | DESCRIBE `site_user_owners` | | 5 | 5 | 0 |
| 27 | DESCRIBE `listing_areas` | | 12 | 12 | 0 |
| 28 | DESCRIBE `settings` | | 7 | 7 | 0 |
| 29 | 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 |
| 30 | SELECT `SavedSearch`.`id`, `SavedSearch`.`title`, `SavedSearch`.`conditions`, `SavedSearch`.`selected_options`, `SavedSearch`.`site_user_id`, `SavedSearch`.`created`, `SavedSearch`.`modified`, `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` FROM `saved_searches` AS `SavedSearch` LEFT JOIN `site_users` AS `SiteUser` ON (`SavedSearch`.`site_user_id` = `SiteUser`.`id`) WHERE `SavedSearch`.`id` IS NULL LIMIT 1 | | 0 | 0 | 0 |
| 31 | SELECT `Group`.`id`, `Group`.`title` FROM `groups` AS `Group` WHERE 1 = 1 | | 9 | 9 | 0 |
| 32 | SELECT `Amenity`.`id`, `Amenity`.`title`, `Amenity`.`group_id`, `Amenity`.`show_on_offer_wall`, `Amenity`.`created`, `Amenity`.`modified` FROM `amenities` AS `Amenity` WHERE `Amenity`.`group_id` IN (1, 2, 12, 4, 5, 6, 7, 15, 16) | | 56 | 56 | 0 |
| 33 | 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` >= '2026-04-04' AND `Auction`.`auction_start_date` <= '2026-04-04' | | 1 | 1 | 0 |
