SHOW FULL COLUMNS FROM `hsd_city` [ RunTime:0.015428s ]
SELECT * FROM `hsd_city` WHERE `is_show` = 1 [ RunTime:0.000578s ]
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 >= '1746754894' AND start_time <= '1746754894' AND (a.web_city='2' or a.web_city=1) order by a.order_ad asc LIMIT 0,2 [ RunTime:0.000751s ]
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.000696s ]
SHOW FULL COLUMNS FROM `hsd_shop` [ RunTime:0.013187s ]
SELECT * FROM `hsd_shop` WHERE `shop_id` = 1742 AND `is_show` = 1 LIMIT 1 [ RunTime:0.000808s ]
SELECT * FROM `hsd_city` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000476s ]
select * from `hsd_shop_ad` where is_show='1' and ad_type='1' and position_id='2' and shop_code='201508130000003' limit 0,1 [ RunTime:0.000521s ]
SHOW FULL COLUMNS FROM `hsd_shop_article` [ RunTime:0.012185s ]
SELECT * FROM `hsd_shop_article` WHERE ( `shop_code` = '201508130000003' ) LIMIT 1 [ RunTime:0.005142s ]
SHOW FULL COLUMNS FROM `hsd_mall` [ RunTime:0.014143s ]
SELECT * FROM `hsd_mall` WHERE ( `id` = 339 AND `is_show` = 1 ) LIMIT 1 [ RunTime:0.000738s ]
select * from `hsd_shop_ad` where is_show='1' and ad_type='1' and position_id='1' and shop_code='201508130000003' limit 0,5 [ RunTime:0.013970s ]
select count(*) as ids from `hsd_shop_goods` where is_show='1' and shop_code='201508130000003' [ RunTime:0.000758s ]
select * from `hsd_shop_goods` where is_show='1' and shop_code='201508130000003' order by sort_order desc, add_time desc LIMIT 0 , 20 [ RunTime:0.000805s ]
