Time: 0.0074071884155273 -- 26-04-10 09:06:28 -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentStatus select status_id from dbthird_buz.thdbuz_kaifa_shipment where shipment_id = 727 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0097999572753906 -- 26-04-10 09:06:28[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select shipment_id,shipment_no,status_id,skj_orderNo,date_format(shipment_time,'%Y-%m-%d %H:%i') shipment_time, driver_name,driver_tel,driver_card_no,truck_no,viechle_type_id,date_format(plan_arrival_time,'%Y-%m-%d %H:%i') plan_arrival_time from dbthird_buz.thdbuz_kaifa_shipment where shipment_id = 727 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023541450500488 -- 26-04-10 09:06:28[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select so.shiporder_id,so.order_id,o.owner_id,so.pickup_addr,so.consignee_addr, concat(so.shiporder_id,'_',o.owner_id) unloadUpload_key from dbthird_buz.thdbuz_kaifa_shipmentch_shiporder s_so left join dbthird.thd_shiporder so on so.shiporder_id = s_so.shiporder_id left join dbthird.thd_order o on so.order_id = o.order_id where s_so.shipment_id = 727 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037319660186768 -- 26-04-10 09:06:28[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where source_tblName='dbthird_buz.thdbuz_kaifa_shipment' and source_fldVal=727 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018551349639893 -- 26-04-10 09:06:28[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2645 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018599033355713 -- 26-04-10 09:06:28[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6333880 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017499923706055 -- 26-04-10 09:06:28[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2645 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018260478973389 -- 26-04-10 09:06:28[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6333881 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0102858543396 -- 26-04-10 09:07:18 -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentStatus select status_id from dbthird_buz.thdbuz_kaifa_shipment where shipment_id = 727 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021421909332275 -- 26-04-10 09:07:18[-883] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select shipment_id,shipment_no,status_id,skj_orderNo,date_format(shipment_time,'%Y-%m-%d %H:%i') shipment_time, driver_name,driver_tel,driver_card_no,truck_no,viechle_type_id,date_format(plan_arrival_time,'%Y-%m-%d %H:%i') plan_arrival_time from dbthird_buz.thdbuz_kaifa_shipment where shipment_id = 727 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027239322662354 -- 26-04-10 09:07:18[-883] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select so.shiporder_id,so.order_id,o.owner_id,so.pickup_addr,so.consignee_addr, concat(so.shiporder_id,'_',o.owner_id) unloadUpload_key from dbthird_buz.thdbuz_kaifa_shipmentch_shiporder s_so left join dbthird.thd_shiporder so on so.shiporder_id = s_so.shiporder_id left join dbthird.thd_order o on so.order_id = o.order_id where s_so.shipment_id = 727 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022099018096924 -- 26-04-10 09:07:18[-883] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where source_tblName='dbthird_buz.thdbuz_kaifa_shipment' and source_fldVal=727 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021378993988037 -- 26-04-10 09:07:18[-883] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 883 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021450519561768 -- 26-04-10 09:07:18[-883] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6333880 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020320415496826 -- 26-04-10 09:07:18[-883] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 883 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021281242370605 -- 26-04-10 09:07:18[-883] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6333881 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0092201232910156 -- 26-04-10 10:18:19[-1] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select shipment_id,shipment_no,status_id,skj_orderNo,date_format(shipment_time,'%Y-%m-%d %H:%i') shipment_time, driver_name,driver_tel,driver_card_no,truck_no,viechle_type_id,date_format(plan_arrival_time,'%Y-%m-%d %H:%i') plan_arrival_time from dbthird_buz.thdbuz_kaifa_shipment where shipment_id = 733 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020859241485596 -- 26-04-10 10:18:19[-1] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select so.shiporder_id,so.order_id,o.owner_id,so.pickup_addr,so.consignee_addr, concat(so.shiporder_id,'_',o.owner_id) unloadUpload_key from dbthird_buz.thdbuz_kaifa_shipmentch_shiporder s_so left join dbthird.thd_shiporder so on so.shiporder_id = s_so.shiporder_id left join dbthird.thd_order o on so.order_id = o.order_id where s_so.shipment_id = 733 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020401477813721 -- 26-04-10 10:18:19[-1] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where source_tblName='dbthird_buz.thdbuz_kaifa_shipment' and source_fldVal=733 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017930030822754 -- 26-04-10 10:18:20[-1] -- /buz/outward/index.php/OutwardOprt/kaifa?event=save_shipTruckReg select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2645 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002018928527832 -- 26-04-10 10:18:20[-1] -- /buz/outward/index.php/OutwardOprt/kaifa?event=save_shipTruckReg select * from dbthird_buz.thdbuz_kaifa_shipment where shipment_id = 733 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013355016708374 -- 26-04-10 11:29:53[-1] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select shipment_id,shipment_no,status_id,skj_orderNo,date_format(shipment_time,'%Y-%m-%d %H:%i') shipment_time, driver_name,driver_tel,driver_card_no,truck_no,viechle_type_id,date_format(plan_arrival_time,'%Y-%m-%d %H:%i') plan_arrival_time from dbthird_buz.thdbuz_kaifa_shipment where shipment_id = 733 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027821063995361 -- 26-04-10 11:29:53[-1] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select so.shiporder_id,so.order_id,o.owner_id,so.pickup_addr,so.consignee_addr, concat(so.shiporder_id,'_',o.owner_id) unloadUpload_key from dbthird_buz.thdbuz_kaifa_shipmentch_shiporder s_so left join dbthird.thd_shiporder so on so.shiporder_id = s_so.shiporder_id left join dbthird.thd_order o on so.order_id = o.order_id where s_so.shipment_id = 733 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027279853820801 -- 26-04-10 11:29:53[-1] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where source_tblName='dbthird_buz.thdbuz_kaifa_shipment' and source_fldVal=733 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02114200592041 -- 26-04-10 11:29:53[-1] -- /buz/outward/index.php/OutwardOprt/kaifa?event=save_shipTruckReg select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2645 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022621154785156 -- 26-04-10 11:29:53[-1] -- /buz/outward/index.php/OutwardOprt/kaifa?event=save_shipTruckReg select * from dbthird_buz.thdbuz_kaifa_shipment where shipment_id = 733 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011284112930298 -- 26-04-10 13:59:16[-1] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentStatus select status_id from dbthird_buz.thdbuz_kaifa_shipment where shipment_id = 733 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012161016464233 -- 26-04-10 13:59:16[-1] -- /buz/outward/index.php/Outwardoprt/kaifa?event=loadTruck&shipment_id=733&cont_id=2645 select jsapi_ticket from dbwechat.wechat_token wt left join dbwechat.wechat_publicno wp on wt.publicno_id = wp.publicno_id where wp.appid = 'ww5262fb147810c303' and wt.agentid = 1000009 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010451078414917 -- 26-04-10 13:59:16[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select shipment_id,shipment_no,status_id,skj_orderNo,date_format(shipment_time,'%Y-%m-%d %H:%i') shipment_time, driver_name,driver_tel,driver_card_no,truck_no,viechle_type_id,date_format(plan_arrival_time,'%Y-%m-%d %H:%i') plan_arrival_time from dbthird_buz.thdbuz_kaifa_shipment where shipment_id = 733 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001788854598999 -- 26-04-10 13:59:16[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select so.shiporder_id,so.order_id,o.owner_id,so.pickup_addr,so.consignee_addr, concat(so.shiporder_id,'_',o.owner_id) unloadUpload_key from dbthird_buz.thdbuz_kaifa_shipmentch_shiporder s_so left join dbthird.thd_shiporder so on so.shiporder_id = s_so.shiporder_id left join dbthird.thd_order o on so.order_id = o.order_id where s_so.shipment_id = 733 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017440319061279 -- 26-04-10 13:59:16[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where source_tblName='dbthird_buz.thdbuz_kaifa_shipment' and source_fldVal=733 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010387897491455 -- 26-04-10 13:59:50[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=upload_file select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2645 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018298625946045 -- 26-04-10 13:59:50[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=upload_file select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where source_tblName='dbthird_buz.thdbuz_kaifa_shipment' and source_fldVal=733 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015571117401123 -- 26-04-10 13:59:50[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=upload_file select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2645 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0093309879302979 -- 26-04-10 14:00:39[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=upload_file select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2645 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019950866699219 -- 26-04-10 14:00:39[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=upload_file select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where source_tblName='dbthird_buz.thdbuz_kaifa_shipment' and source_fldVal=733 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017380714416504 -- 26-04-10 14:00:39[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=upload_file select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2645 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0091660022735596 -- 26-04-10 14:00:43[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=upload_file select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2645 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020051002502441 -- 26-04-10 14:00:43[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=upload_file select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where source_tblName='dbthird_buz.thdbuz_kaifa_shipment' and source_fldVal=733 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001723051071167 -- 26-04-10 14:00:43[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=upload_file select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2645 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.008897066116333 -- 26-04-10 14:00:45[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=finish_loadTruck&shipment_id=733&cont_id=2645 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2645 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022549629211426 -- 26-04-10 14:00:45[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=finish_loadTruck&shipment_id=733&cont_id=2645 select * from dbthird_buz.thdbuz_kaifa_shipmentch_shiporder where shipment_id = 733 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013765096664429 -- 26-04-10 15:47:25 -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentStatus select status_id from dbthird_buz.thdbuz_kaifa_shipment where shipment_id = 733 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0074291229248047 -- 26-04-10 15:47:25[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select shipment_id,shipment_no,status_id,skj_orderNo,date_format(shipment_time,'%Y-%m-%d %H:%i') shipment_time, driver_name,driver_tel,driver_card_no,truck_no,viechle_type_id,date_format(plan_arrival_time,'%Y-%m-%d %H:%i') plan_arrival_time from dbthird_buz.thdbuz_kaifa_shipment where shipment_id = 733 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019791126251221 -- 26-04-10 15:47:25[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select so.shiporder_id,so.order_id,o.owner_id,so.pickup_addr,so.consignee_addr, concat(so.shiporder_id,'_',o.owner_id) unloadUpload_key from dbthird_buz.thdbuz_kaifa_shipmentch_shiporder s_so left join dbthird.thd_shiporder so on so.shiporder_id = s_so.shiporder_id left join dbthird.thd_order o on so.order_id = o.order_id where s_so.shipment_id = 733 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015490055084229 -- 26-04-10 15:47:25[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where source_tblName='dbthird_buz.thdbuz_kaifa_shipment' and source_fldVal=733 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014429092407227 -- 26-04-10 15:47:25[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2645 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014421939849854 -- 26-04-10 15:47:25[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6350287 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012269973754883 -- 26-04-10 15:47:34[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=upload_file select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2645 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018370151519775 -- 26-04-10 15:47:34[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=upload_file select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6350287 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016429424285889 -- 26-04-10 15:47:34[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=upload_file select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2645 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021309852600098 -- 26-04-10 15:47:38[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=upload_file select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2645 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021378993988037 -- 26-04-10 15:47:38[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=upload_file select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6350287 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001953125 -- 26-04-10 15:47:38[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=upload_file select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2645 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012397050857544 -- 26-04-10 15:48:09[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=upload_file select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2645 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026049613952637 -- 26-04-10 15:48:09[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=upload_file select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6350287 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023531913757324 -- 26-04-10 15:48:09[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=upload_file select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2645 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019004106521606 -- 26-04-10 15:48:11[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=finish_unloadTruck select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2645 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0084831714630127 -- 26-04-10 15:51:40[-1] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select shipment_id,shipment_no,status_id,skj_orderNo,date_format(shipment_time,'%Y-%m-%d %H:%i') shipment_time, driver_name,driver_tel,driver_card_no,truck_no,viechle_type_id,date_format(plan_arrival_time,'%Y-%m-%d %H:%i') plan_arrival_time from dbthird_buz.thdbuz_kaifa_shipment where shipment_id = 734 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020318031311035 -- 26-04-10 15:51:40[-1] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select so.shiporder_id,so.order_id,o.owner_id,so.pickup_addr,so.consignee_addr, concat(so.shiporder_id,'_',o.owner_id) unloadUpload_key from dbthird_buz.thdbuz_kaifa_shipmentch_shiporder s_so left join dbthird.thd_shiporder so on so.shiporder_id = s_so.shiporder_id left join dbthird.thd_order o on so.order_id = o.order_id where s_so.shipment_id = 734 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016391277313232 -- 26-04-10 15:51:40[-1] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentInfo select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where source_tblName='dbthird_buz.thdbuz_kaifa_shipment' and source_fldVal=734 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023910045623779 -- 26-04-10 15:51:41[-1] -- /buz/outward/index.php/OutwardOprt/kaifa?event=save_shipTruckReg select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2645 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020740032196045 -- 26-04-10 15:51:41[-1] -- /buz/outward/index.php/OutwardOprt/kaifa?event=save_shipTruckReg select * from dbthird_buz.thdbuz_kaifa_shipment where shipment_id = 734 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------