SHOW FULL COLUMNS FROM `hsd_city` [ RunTime:0.012551s ]
SELECT * FROM `hsd_city` WHERE `is_show` = 1 [ RunTime:0.000546s ]
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 >= '1746754821' AND start_time <= '1746754821' AND (a.web_city='2' or a.web_city=1) order by a.order_ad asc LIMIT 0,2 [ RunTime:0.000733s ]
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.000664s ]
SELECT * FROM hsd_mall WHERE id='331' [ RunTime:0.000728s ]
SELECT count(*) FROM `hsd_shop` where is_show='1' and market_name ='331' and city_id='2' [ RunTime:0.000727s ]
select * from `hsd_mall_ad` where is_show='1' and `mall_id`='331' [ RunTime:0.000729s ]
select count(id) from hsd_shop_article where is_show='1' and shop_code='331' and article_type='2' [ RunTime:0.005077s ]
SELECT * FROM `hsd_shop_article` where is_show='1' and article_type='1' and shop_code in(select shop_code from `hsd_shop` where is_show='1' and (market_name ='331' or market_name ='泰源装饰建材广场') and city_id='2' ) order by id desc limit 0,14 [ RunTime:0.011705s ]
SHOW FULL COLUMNS FROM `hsd_shop` [ RunTime:0.013181s ]
SELECT * FROM `hsd_shop` `s` INNER JOIN `hsd_shop_goods` `sg` ON `sg`.`shop_code`=`s`.`shop_code` WHERE ( `sg`.`is_show` = '1' AND `sg`.`state` = '1' AND `s`.`market_name` = '331' ) LIMIT 0,9 [ RunTime:0.001573s ]
SELECT * FROM `hsd_shop` where is_show='1' and market_name ='331' order by is_approve desc ,is_recommend desc,is_promotions desc,shop_view desc limit 0,100 [ RunTime:0.001494s ]
SELECT count(*) FROM `hsd_shop` where is_show='1' and market_name ='331' and city_id='2' [ RunTime:0.000743s ]
SELECT * FROM `hsd_coupon` where is_show='1' and shop_code in(select shop_code from `hsd_shop` where is_show='1' and city_id='2' and market_name ='331' ) order by add_time desc limit 0,20 [ RunTime:0.005918s ]
SELECT * FROM `hsd_shop` `s` INNER JOIN `hsd_shop_goods` `sg` ON `sg`.`shop_code`=`s`.`shop_code` WHERE ( `sg`.`is_show` = '1' AND `sg`.`state` = '1' AND `s`.`market_name` = '331' ) LIMIT 0,12 [ RunTime:0.001383s ]
select * from `hsd_shop` where is_show='1' and is_recommend='1' and city_id='2' and market_name ='331' order by shop_id desc limit 0,5 [ RunTime:0.001262s ]
select * from `hsd_shop_im` where shop_type='2' and mall_id='331' and is_show='1' order by id asc limit 3 [ RunTime:0.000720s ]