SHOW FULL COLUMNS FROM `hsd_city` [ RunTime:0.011700s ]
SELECT * FROM `hsd_city` WHERE `is_show` = 1 [ RunTime:0.000781s ]
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 >= '1746755009' AND start_time <= '1746755009' AND (a.web_city='2' or a.web_city=1) order by a.order_ad asc LIMIT 0,2 [ RunTime:0.000770s ]
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.000705s ]
SHOW FULL COLUMNS FROM `hsd_shop` [ RunTime:0.019190s ]
SELECT * FROM `hsd_shop` WHERE `shop_id` = 1004 AND `is_show` = 1 LIMIT 1 [ RunTime:0.000790s ]
SELECT * FROM `hsd_city` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000555s ]
select * from `hsd_shop_ad` where is_show='1' and ad_type='1' and position_id='2' and shop_code='201505180000002' limit 0,1 [ RunTime:0.000603s ]
SHOW FULL COLUMNS FROM `hsd_shop_article` [ RunTime:0.019246s ]
SELECT * FROM `hsd_shop_article` WHERE ( `shop_code` = '201505180000002' ) LIMIT 1 [ RunTime:0.005530s ]
SHOW FULL COLUMNS FROM `hsd_mall` [ RunTime:0.017869s ]
SELECT * FROM `hsd_mall` WHERE ( `id` = 227 AND `is_show` = 1 ) LIMIT 1 [ RunTime:0.000775s ]
select * from `hsd_shop_ad` where is_show='1' and ad_type='1' and position_id='1' and shop_code='201505180000002' limit 0,5 [ RunTime:0.013697s ]
select count(*) as ids from `hsd_shop_goods` where is_show='1' and shop_code='201505180000002' [ RunTime:0.000666s ]
select * from `hsd_shop_goods` where is_show='1' and shop_code='201505180000002' order by sort_order desc, add_time desc LIMIT 0 , 20 [ RunTime:0.000694s ]
