(default) 26 queries took 3 ms
NrQueryErrorAffectedNum. rowsTook (ms)
1DESCRIBE `auctions`19191
2DESCRIBE `auction_winners`550
3DESCRIBE `bids`11110
4DESCRIBE `saved_listings`330
5DESCRIBE `saved_searches`771
6DESCRIBE `sent_auction_notifications`220
7DESCRIBE `sent_listing_notifications`440
8DESCRIBE `sent_offer_wall_notifications`330
9DESCRIBE `email_group_users`550
10DESCRIBE `email_groups`440
11DESCRIBE `admin_email_groups`330
12DESCRIBE `offer_wall`25250
13DESCRIBE `payments`14140
14DESCRIBE `listing_images`880
15DESCRIBE `rates`880
16DESCRIBE `open_weeks`550
17DESCRIBE `zipcodes`10100
18DESCRIBE `amenities`660
19DESCRIBE `groups`221
20DESCRIBE `amenities_listings`330
21DESCRIBE `settings`770
22SELECT `Setting`.`id`, `Setting`.`name`, `Setting`.`value`, `Setting`.`description`, `Setting`.`type`, `Setting`.`label`, `Setting`.`order` FROM `settings` AS `Setting` WHERE 1 = 1 12120
23SELECT `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` = 112 LIMIT 1110
24SELECT COUNT(*) AS `count` FROM `ratings` AS `Rating` WHERE `Rating`.`listing_id` = 112 110
25SELECT `Rating`.`id`, `Rating`.`rating`, `Rating`.`site_user_id`, `Rating`.`listing_id`, `Rating`.`comment`, `Rating`.`created` FROM `ratings` AS `Rating` WHERE `Rating`.`listing_id` = 112 LIMIT 20000
26SELECT 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' 110