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.005968s ]
SELECT * FROM aier_yy_orderitem WHERE id <> 15 [ RunTime:0.004562s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='' ORDER BY sort ASC [ RunTime:0.005800s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='2' ORDER BY sort ASC [ RunTime:0.007949s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='3' ORDER BY sort ASC [ RunTime:0.008064s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='4' ORDER BY sort ASC [ RunTime:0.005925s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='5' ORDER BY sort ASC [ RunTime:0.005842s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='6' ORDER BY sort ASC [ RunTime:0.012318s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='7' ORDER BY sort ASC [ RunTime:0.008096s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='8' ORDER BY sort ASC [ RunTime:0.006020s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='9' ORDER BY sort ASC [ RunTime:0.005845s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='10' ORDER BY sort ASC [ RunTime:0.008103s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='11' ORDER BY sort ASC [ RunTime:0.005881s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='12' ORDER BY sort ASC [ RunTime:0.005852s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='13' ORDER BY sort ASC [ RunTime:0.010296s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='14' ORDER BY sort ASC [ RunTime:0.012426s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='15' ORDER BY sort ASC [ RunTime:0.005936s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='16' ORDER BY sort ASC [ RunTime:0.005866s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='17' ORDER BY sort ASC [ RunTime:0.005927s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='18' ORDER BY sort ASC [ RunTime:0.010185s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='19' ORDER BY sort ASC [ RunTime:0.005786s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='20' ORDER BY sort ASC [ RunTime:0.005807s ]
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.008094s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='23' ORDER BY sort ASC [ RunTime:0.005818s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='24' ORDER BY sort ASC [ RunTime:0.006497s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='25' ORDER BY sort ASC [ RunTime:0.006474s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='26' ORDER BY sort ASC [ RunTime:0.008615s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='27' ORDER BY sort ASC [ RunTime:0.005726s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='28' ORDER BY sort ASC [ RunTime:0.005733s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='29' ORDER BY sort ASC [ RunTime:0.006545s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='30' ORDER BY sort ASC [ RunTime:0.006586s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='31' ORDER BY sort ASC [ RunTime:0.006456s ]
SELECT * FROM aier_yy_hospital WHERE isdel='0' AND shen='32' ORDER BY sort ASC [ RunTime:0.006236s ]