SHOW FULL COLUMNS FROM `wa_site_settings` [ RunTime:0.002123s ]
SELECT * FROM `wa_site_settings` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000938s ]
SHOW FULL COLUMNS FROM `wa_esports_hotels` [ RunTime:0.002017s ]
SELECT COUNT(*) AS think_count FROM `wa_esports_hotels` WHERE `is_published` = 1 AND ( `title` LIKE '%渝中区%' OR `brand` LIKE '%渝中区%' OR `address` LIKE '%渝中区%' OR `tags` LIKE '%渝中区%' ) [ RunTime:0.003524s ]
SELECT `id`,`title`,`slug`,`subtitle`,`brand`,`brand_type`,`cover_image`,`province`,`city`,`district`,`room_count`,`price_range`,`star_rating`,`opening_year`,`esports_config`,`description`,`is_featured`,`view_count` FROM `wa_esports_hotels` WHERE `is_published` = 1 AND ( `title` LIKE '%渝中区%' OR `brand` LIKE '%渝中区%' OR `address` LIKE '%渝中区%' OR `tags` LIKE '%渝中区%' ) ORDER BY `is_featured` DESC,`sort_order` ASC,`view_count` DESC LIMIT 0,12 [ RunTime:0.004340s ]
SELECT `province` FROM `wa_esports_hotels` WHERE `is_published` = 1 GROUP BY `province` ORDER BY count(*) DESC [ RunTime:0.003492s ]
SELECT `brand` FROM `wa_esports_hotels` WHERE `is_published` = 1 GROUP BY `brand` ORDER BY count(*) DESC [ RunTime:0.003471s ]
