SELECT hospital.shen, city.region_name FROM aier_yy_hospital AS hospital LEFT JOIN aier_yy_city AS city ON hospital.shen = city.region_id WHERE hospital.isdel='0' GROUP BY hospital.shen ORDER BY shen ASC [ RunTime:0.006042s ]
SELECT * FROM aier_yy_orderitem WHERE id <> 15 [ RunTime:0.004815s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='' ORDER BY sort ASC [ RunTime:0.006539s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='2' ORDER BY sort ASC [ RunTime:0.008732s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='3' ORDER BY sort ASC [ RunTime:0.008937s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='4' ORDER BY sort ASC [ RunTime:0.008844s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='5' ORDER BY sort ASC [ RunTime:0.006445s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='6' ORDER BY sort ASC [ RunTime:0.012706s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='7' ORDER BY sort ASC [ RunTime:0.008101s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='8' ORDER BY sort ASC [ RunTime:0.010241s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='9' ORDER BY sort ASC [ RunTime:0.005854s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='10' ORDER BY sort ASC [ RunTime:0.010208s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='11' ORDER BY sort ASC [ RunTime:0.005852s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='12' ORDER BY sort ASC [ RunTime:0.006435s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='13' ORDER BY sort ASC [ RunTime:0.013131s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='14' ORDER BY sort ASC [ RunTime:0.013474s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='15' ORDER BY sort ASC [ RunTime:0.006963s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='16' ORDER BY sort ASC [ RunTime:0.006890s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='17' ORDER BY sort ASC [ RunTime:0.006069s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='18' ORDER BY sort ASC [ RunTime:0.010444s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='19' ORDER BY sort ASC [ RunTime:0.005860s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='20' ORDER BY sort ASC [ RunTime:0.005812s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='21' ORDER BY sort ASC [ RunTime:0.005732s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='22' ORDER BY sort ASC [ RunTime:0.008140s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='23' ORDER BY sort ASC [ RunTime:0.005919s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='24' ORDER BY sort ASC [ RunTime:0.005845s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='25' ORDER BY sort ASC [ RunTime:0.006535s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='26' ORDER BY sort ASC [ RunTime:0.008912s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='27' ORDER BY sort ASC [ RunTime:0.006339s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='28' ORDER BY sort ASC [ RunTime:0.005874s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='29' ORDER BY sort ASC [ RunTime:0.006631s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='30' ORDER BY sort ASC [ RunTime:0.006675s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='31' ORDER BY sort ASC [ RunTime:0.006357s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='32' ORDER BY sort ASC [ RunTime:0.006145s ]