SHOW FULL COLUMNS FROM `hs_resale_layout` [ RunTime:0.001292s ]
SELECT COUNT(*) AS think_count FROM `hs_resale_layout` `a` INNER JOIN `hs_resale` `b` ON `b`.`id`=`a`.`community_id` [ RunTime:0.000285s ]
SELECT a.id,a.title,b.district,b.community_name,a.house_type,a.living_rooms,a.area,a.tags,a.total_price,a.price,a.image_list FROM `hs_resale_layout` `a` INNER JOIN `hs_resale` `b` ON `b`.`id`=`a`.`community_id` ORDER BY `a`.`id` DESC LIMIT 0,10 [ RunTime:0.000271s ]
