1       10:44:55  SQL Execute: ORACLE -  select  *   from   vw_sf_ysghhb  where  1 = 1 
 and GHMZSJ >= '20151201'
 and GHMZSJ <= '20160113'
 and YSXM00  = '王世红'
 AND GHHZCK IN (SELECT DCKBH0 FROM BM_CKDY00 WHERE SCKBH0=21)
 and PBLX00='0' 
  order by  GHMZSJ,YSXM00,GHQSSJ 

2       10:44:56  SQL Execute: ORACLE -  select  *   from   vw_sf_ysghhb  where  1 = 1 
 and GHMZSJ >= '20151201'
 and GHMZSJ <= '20160113'
 and YSXM00  = '王世红'
 AND GHHZCK IN (SELECT DCKBH0 FROM BM_CKDY00 WHERE SCKBH0=21)
 and PBLX00='0' 
  order by  GHMZSJ,YSXM00,GHQSSJ 

3       10:45:07  SQL Data In: ORACLE - Param = 1, Name = , Type = fldZSTRING, Precision = 5, Scale = 0, Data = 71042
4       10:45:07  SQL Execute: ORACLE - select GHHBID,BRID00,BRXM00,HZXH00,YYBZ00,decode(YYBZ00,'1','普通号','2','优先号','3','预约号','预约号') YYBZMC from YS_HBHZXH where GHHBID=? order by HZXH00

5       10:45:07  SQL Execute: ORACLE - select BH0000,MC0000 from BM_TYZD00 where ZDMC00='预约号源分类'