ส่งให้แล้วครับ
Date Time Type Exec Time SQL Text
50-11-09 14:32:16.328 SQL 325,172 select h.lab_order_number,v.pcode,a.pcode as apcode, h.lab_receive_number,h.vn,h.hn,h.order_date ,h.order_time, h.lock_result,h.receive_time as service13,h.report_time as service14 ,h.confirm_report,d.name as doctor_name, concat(pt.pname,pt.fname,' ',pt.lname) as ptname , h.form_name ,v.rcpt_money as opaid,a.rcpt_money as ipaid , v.age_y as vage_y,a.age_y as aage_y ,h.department,concat(w.name,' - ',adm.bedno) as ward_name from lab_head h left outer join patient pt on pt.hn=h.hn left outer join doctor d on d.code=h.doctor_code left outer join vn_stat v on v.vn=h.vn left outer join an_stat a on a.an=h.vn left outer join ward w on w.ward = a.ward left outer join iptadm adm on adm.an = a.an where h.lab_order_number in (238,239,267,271,270,272,273,274,275,373,411,482,510,519,541,576,591,590,608,821,825,857,858,879,881,882,883,884,885,1016,1017,1024,1025,1026,1027,1028,1029,1030,1048,1053,1063,1179,1210,1223,1225,1311,1310,1314,1335,1340,1341,1342,1343,1344,1345,1449,1466,1516,1528,1529,1626,1629,1639,1642,1677,1678,1899,1932,2033,2048,2068,2069,2070,2072,2173,2176,2208,2211,2213,2261,2475,2512,2593,2595,2607,2630,2633,2634,2635,2676,2705,2708,2740,2829,3020,3088,3093,3110,3114,3128,3157,3156,3186,3271,3382,3383,3423,3486,3487,3513,3530,3609,3689,3738,3742,3743,3744,3750,3762,3878,3933,4069,4091,4134,4180,4187,4193,4339,4357,4373,4450,4463,4465,4466,4567,4589,4590,4592,4603,4631,4659,4729,4730,4799,4876,4892,4894,4907,4927,4931,4939,4941,4946,5009,5195,5196,5269,5291,5444,5510,5513,5519,5520,5521,5522,5523,5524,5525,5527,5528,5529,5530,5531,5532,5533,5544,5585,5596,5597,5647,5648,5664,5706,5913,5939,6018,6019,6020,6107,6134,6147,6161,6173,6217,6259,6268,6283,6292,6327,6328,6387,6389,6427,6476,6477,6490,6500,6508,6528,6565,6654,6692,6696,6712,6725,6737,6780,6785,6790,6809,6829,6830,6876,6906,6907,6912,6914,6923,6959,7115,7126,7130,7131,7144,7148,7151,7155,7176,7181,7220,7224,7249,7267,7485,7488,7600,7641,7650,7651,7652,7675,7864,7988,8023,8048,8058,8079,8088,8182,8415,8425,8428,8429,8439,8520,8523,8530,8584,8589,8593,8599,8609,8623,8624,8630,8637,8651,8652,8658,8660,8699,8718,8727,8750,8751,8752,8761,8762,8806,8857,8896,8903,8907,8923,9011,9028,9059,9060,9096,9165,9190,9193,9281,9303,9307,9308,9320,9321,9440,9639,9767,9768,9796,9804,9805,9817,9818,9835,9856,9933,9968,9974,9994,9999,10000,10016,10078,10080,10132,10133,10140,10271,10385,10386,10388,10401,10402,10484,10487,10628,10755,10756,11020,11361,11528,11633,11720,11728,11729,11738,11853,12123,12137,12158,12270,12424,12431,12520,12530,12842,12859,12986,12996,13027,13382,13405,13420,13439,13448,13564,13565,13810,13830,13831,13832,13833,13834,13835,13836,13837,13838,13839,13846,13871,14504,14638,15096,15101,15110,15138,15143,15145,15267,15579,16067,16075,16086,16200) order by h.order_date,h.order_time
หัวข้อ: ระบบงาน Lab click รายงานผล Lab ทำให้ระบบ HOSxP ช้าทั้งระบบ (อ่าน 8781 ครั้ง)