12345 |
- [INFO] 2015-06-10 11:45:07 >> [main] com.yihu.hos.dao.BasicDao.queryDoctorDeptDao(BasicDao.java:302): queryDoctorDeptDao depNameSql --------------- Select * from B_dept where 1=1 and isshow =1 []
- [INFO] 2015-06-10 11:45:07 >> [main] com.yihu.hos.dao.BasicDao.queryDoctorDao(BasicDao.java:381): queryDoctorDao sql debug::::::::::::::::::: Select t3.* from( Select t2.*,rownum as row_num from( Select b.*,c.deptname from B_doctor b left join B_Dept c on b.deptcode = c.deptcode where 1=1 and doctorcode in ( '0120','0059','0155','0116') order by b.ordercol )t2 where rownum <=? ) t3 where t3.row_num > ?[]
- [INFO] 2015-06-10 11:45:07 >> [main] com.yihu.hos.dao.BasicDao.queryDoctorDao(BasicDao.java:390): queryDoctorDao sql doctor--------------- Select t3.* from( Select t2.*,rownum as row_num from( Select b.*,c.deptname from B_doctor b left join B_Dept c on b.deptcode = c.deptcode where 1=1 and doctorcode in ( '0120','0059','0155','0116') order by b.ordercol )t2 where rownum <=? ) t3 where t3.row_num > ?[10,0]
- [INFO] 2015-06-15 15:05:44 >> [A-deal-15] com.yihu.hos.dao.BasicDao.queryArticleList(BasicDao.java:1256): Select t3.* from( Select t2.*,rownum as row_num from( Select a.* from B_Article a where 1=1 and ((a.CreateDate <to_date('2015-06-16','yyyy-mm-dd') and a.CreateDate>= to_date('2015-06-15','yyyy-mm-dd')) or ( a.lastmodify <to_date('2015-06-16','yyyy-mm-dd') and a.lastmodify >=to_date('2015-06-15','yyyy-mm-dd'))) order by a.lastmodify desc,a.createdate desc )t2 where rownum <=? ) t3 where t3.row_num > ?[10,0]
- [INFO] 2015-06-15 15:56:38 >> [A-deal-16] com.yihu.hos.dao.BasicDao.queryArticleList(BasicDao.java:1256): Select t3.* from( Select t2.*,rownum as row_num from( Select a.* from B_Article a where 1=1 and ((a.CreateDate <to_date('2015-06-16','yyyy-mm-dd') and a.CreateDate>= to_date('2015-06-15','yyyy-mm-dd')) or ( a.lastmodify <to_date('2015-06-16','yyyy-mm-dd') and a.lastmodify >=to_date('2015-06-15','yyyy-mm-dd'))) order by a.lastmodify desc,a.createdate desc )t2 where rownum <=? ) t3 where t3.row_num > ?[10,0]
|