SHOW FULL COLUMNS FROM `hsd_city` [ RunTime:0.012735s ]
SELECT * FROM `hsd_city` WHERE `is_show` = 1 [ RunTime:0.000550s ]
SELECT a.*,ap.ad_width,ap.ad_height FROM `hsd_ad` AS a LEFT JOIN `hsd_ad_position` AS ap ON a.position_id=ap.position_id WHERE a.position_id=79 AND a.enabled=1 AND end_time >= '1746754316' AND start_time <= '1746754316' AND (a.web_city='2' or a.web_city=1) order by a.order_ad asc LIMIT 0,2 [ RunTime:0.000743s ]
SELECT a.*,ap.ad_width,ap.ad_height FROM `hsd_ad` AS a LEFT JOIN `hsd_ad_position` AS ap ON a.position_id=ap.position_id WHERE a.position_id=61 AND a.enabled=1 AND (a.web_city='2' or a.web_city=1) order by a.order_ad DESC LIMIT 0,2 [ RunTime:0.000681s ]
SHOW FULL COLUMNS FROM `hsd_mall` [ RunTime:0.012894s ]
SELECT `mall_name`,`mall_pic_small`,`pinyin`,`id` FROM `hsd_mall` WHERE `is_show` = 1 AND `city_id` = 2 ORDER BY `is_approve` DESC,`is_recommend` DESC,`mall_level` DESC,`mall_view` DESC LIMIT 5 [ RunTime:0.001316s ]
SELECT `mall_name`,`mall_pic_small`,`pinyin`,`id`,`mall_address`,`mall_phone` FROM `hsd_mall` WHERE `is_show` = 1 AND `city_id` = 2 AND `mall_type` = 4 AND `area` = 3409 AND FIND_IN_SET('25', `industry_type`) ORDER BY `is_approve` DESC,`is_recommend` DESC,`mall_level` DESC,`mall_view` DESC LIMIT 0,20 [ RunTime:0.000602s ]
SELECT COUNT(*) AS think_count FROM `hsd_mall` WHERE `is_show` = 1 AND `city_id` = 2 AND `mall_type` = 4 AND `area` = 3409 AND FIND_IN_SET('25', `industry_type`) [ RunTime:0.000501s ]
