SHOW FULL COLUMNS FROM `hsd_city` [ RunTime:0.011903s ]
SELECT * FROM `hsd_city` WHERE `is_show` = 1 [ RunTime:0.000604s ]
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 >= '1746754007' AND start_time <= '1746754007' AND (a.web_city='2' or a.web_city=1) order by a.order_ad asc LIMIT 0,2 [ RunTime:0.000773s ]
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.000683s ]
SHOW FULL COLUMNS FROM `hsd_shop` [ RunTime:0.012326s ]
SELECT * FROM `hsd_shop` WHERE `shop_id` = 1729 AND `is_show` = 1 LIMIT 1 [ RunTime:0.000753s ]
SELECT * FROM `hsd_city` WHERE `id` = 8 LIMIT 1 [ RunTime:0.000494s ]
select * from `hsd_shop_ad` where is_show='1' and ad_type='1' and position_id='2' and shop_code='201508070000014' limit 0,1 [ RunTime:0.000512s ]
SHOW FULL COLUMNS FROM `hsd_shop_article` [ RunTime:0.011843s ]
SELECT * FROM `hsd_shop_article` WHERE ( `shop_code` = '201508070000014' ) LIMIT 1 [ RunTime:0.005315s ]
SHOW FULL COLUMNS FROM `hsd_mall` [ RunTime:0.012839s ]
SELECT * FROM `hsd_mall` WHERE ( `id` = 337 AND `is_show` = 1 ) LIMIT 1 [ RunTime:0.000647s ]
select * from `hsd_shop_ad` where is_show='1' and ad_type='1' and position_id='1' and shop_code='201508070000014' limit 0,5 [ RunTime:0.014295s ]
select count(*) as ids from `hsd_shop_goods` where is_show='1' and shop_code='201508070000014' [ RunTime:0.000732s ]
select * from `hsd_shop_goods` where is_show='1' and shop_code='201508070000014' order by sort_order desc, add_time desc LIMIT 0 , 20 [ RunTime:0.000747s ]
