Time: 0.010791063308716 -- 26-04-13 10:48:27 -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentStatus select status_id from dbthird_buz.thdbuz_kaifa_shipment where shipment_id = 739 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011490106582642 -- 26-04-13 10:48:27 -- /buz/outward/index.php/Outwardoprt/kaifa?event=loadTruck&shipment_id=739&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.021569967269897 -- 26-04-13 10:48:27[-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 = 739 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019540786743164 -- 26-04-13 10:48:27[-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 = 739 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015349388122559 -- 26-04-13 10:48:27[-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=739 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011761903762817 -- 26-04-13 10:48:47[-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.0018718242645264 -- 26-04-13 10:48:48[-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=739 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016191005706787 -- 26-04-13 10:48:48[-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.012558937072754 -- 26-04-13 10:48:51[-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.0017039775848389 -- 26-04-13 10:48:52[-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=739 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014359951019287 -- 26-04-13 10:48:52[-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.0076699256896973 -- 26-04-13 10:48:53[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=finish_loadTruck&shipment_id=739&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.0019881725311279 -- 26-04-13 10:48:53[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=finish_loadTruck&shipment_id=739&cont_id=2645 select * from dbthird_buz.thdbuz_kaifa_shipmentch_shiporder where shipment_id = 739 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0088489055633545 -- 26-04-13 13:53:40[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentStatus select status_id from dbthird_buz.thdbuz_kaifa_shipment where shipment_id = 739 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020215034484863 -- 26-04-13 13:53:40[-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 = 739 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025870800018311 -- 26-04-13 13:53:40[-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 = 739 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022270679473877 -- 26-04-13 13:53:40[-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=739 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021250247955322 -- 26-04-13 13:53:40[-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.002126932144165 -- 26-04-13 13:53:40[-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=6359796 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017354011535645 -- 26-04-13 13:53:45[-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.0021460056304932 -- 26-04-13 13:53:45[-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=6359796 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019090175628662 -- 26-04-13 13:53:45[-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.008620023727417 -- 26-04-13 13:53:49[-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.0018870830535889 -- 26-04-13 13:53:49[-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=6359796 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016429424285889 -- 26-04-13 13:53:49[-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.027684926986694 -- 26-04-13 13:53:53[-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.0021429061889648 -- 26-04-13 13:53:53[-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=6359796 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019290447235107 -- 26-04-13 13:53:53[-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.0069591999053955 -- 26-04-13 13:53:57[-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.0014638900756836 -- 26-04-13 13:53:57[-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=6359796 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012919902801514 -- 26-04-13 13:53:57[-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.0078411102294922 -- 26-04-13 13:53:58[-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.01653003692627 -- 26-04-13 14:43:44 -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentStatus select status_id from dbthird_buz.thdbuz_kaifa_shipment where shipment_id = 740 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0084760189056396 -- 26-04-13 14:43:44 -- /buz/outward/index.php/Outwardoprt/kaifa?event=loadTruck&shipment_id=740&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.0095798969268799 -- 26-04-13 14:43:44[-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 = 740 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023071765899658 -- 26-04-13 14:43:44[-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 = 740 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019071102142334 -- 26-04-13 14:43:44[-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=740 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0078320503234863 -- 26-04-13 14:46:15[-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.0017268657684326 -- 26-04-13 14:46:15[-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=740 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014731884002686 -- 26-04-13 14:46:15[-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.0080609321594238 -- 26-04-13 14:46:19[-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.0017421245574951 -- 26-04-13 14:46:19[-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=740 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015041828155518 -- 26-04-13 14:46:19[-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.018333911895752 -- 26-04-13 14:46:21[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=finish_loadTruck&shipment_id=740&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.0030460357666016 -- 26-04-13 14:46:21[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=finish_loadTruck&shipment_id=740&cont_id=2645 select * from dbthird_buz.thdbuz_kaifa_shipmentch_shiporder where shipment_id = 740 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024178028106689 -- 26-04-13 16:16:50 -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentStatus select status_id from dbthird_buz.thdbuz_kaifa_shipment where shipment_id = 740 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015816926956177 -- 26-04-13 16:16:50[-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 = 740 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020241737365723 -- 26-04-13 16:16:50[-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 = 740 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015997886657715 -- 26-04-13 16:16:50[-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=740 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014679431915283 -- 26-04-13 16:16:50[-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.0014469623565674 -- 26-04-13 16:16:50[-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=6361085 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016971111297607 -- 26-04-13 16:17:19[-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.0016188621520996 -- 26-04-13 16:17:19[-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=6361085 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014488697052002 -- 26-04-13 16:17:19[-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.020186901092529 -- 26-04-13 16:17:23[-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.00211501121521 -- 26-04-13 16:17:23[-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=6361085 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019299983978271 -- 26-04-13 16:17:23[-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.008552074432373 -- 26-04-13 16:17:27[-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.0018229484558105 -- 26-04-13 16:17:27[-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=6361085 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016179084777832 -- 26-04-13 16:17:27[-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.012718915939331 -- 26-04-13 16:17:31[-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.0016050338745117 -- 26-04-13 16:17:31[-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=6361085 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014312267303467 -- 26-04-13 16:17:31[-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.018992900848389 -- 26-04-13 16:17:33[-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.011270046234131 -- 26-04-13 19:37:48 -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentStatus select status_id from dbthird_buz.thdbuz_kaifa_shipment where shipment_id = 741 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0081570148468018 -- 26-04-13 19:37:48 -- /buz/outward/index.php/Outwardoprt/kaifa?event=loadTruck&shipment_id=741&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.013437986373901 -- 26-04-13 19:37:48[-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 = 741 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002432107925415 -- 26-04-13 19:37:48[-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 = 741 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019130706787109 -- 26-04-13 19:37:48[-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=741 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0091900825500488 -- 26-04-13 19:37:54[-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.0019688606262207 -- 26-04-13 19:37:55[-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=741 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017211437225342 -- 26-04-13 19:37:55[-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.013317108154297 -- 26-04-13 19:38:00[-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.0025060176849365 -- 26-04-13 19:38:00[-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=741 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022368431091309 -- 26-04-13 19:38:00[-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.0076868534088135 -- 26-04-13 19:38:09[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=finish_loadTruck&shipment_id=741&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.0021319389343262 -- 26-04-13 19:38:09[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=finish_loadTruck&shipment_id=741&cont_id=2645 select * from dbthird_buz.thdbuz_kaifa_shipmentch_shiporder where shipment_id = 741 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0096421241760254 -- 26-04-13 21:25:09[-2645] -- /buz/outward/index.php/OutwardOprt/kaifa?event=get_shipmentStatus select status_id from dbthird_buz.thdbuz_kaifa_shipment where shipment_id = 741 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021239995956421 -- 26-04-13 21:25:09[-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 = 741 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022990703582764 -- 26-04-13 21:25:09[-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 = 741 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019052028656006 -- 26-04-13 21:25:09[-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=741 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018150806427002 -- 26-04-13 21:25:09[-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.0018270015716553 -- 26-04-13 21:25:09[-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=6363313 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010449171066284 -- 26-04-13 21:25:17[-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.0022091865539551 -- 26-04-13 21:25:17[-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=6363313 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019841194152832 -- 26-04-13 21:25:17[-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.011109113693237 -- 26-04-13 21:25:22[-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.0019409656524658 -- 26-04-13 21:25:22[-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=6363313 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017311573028564 -- 26-04-13 21:25:22[-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.0075230598449707 -- 26-04-13 21:25:36[-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.0016090869903564 -- 26-04-13 21:25:36[-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=6363313 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014009475708008 -- 26-04-13 21:25:36[-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.010355949401855 -- 26-04-13 21:25:48[-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 ------------------------------------------------------------------------------------------------------------------------------------------------------