Time: 0.016603946685791 -- 26-01-02 03:38:32[韦忠禄-2499] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2499 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032558441162109 -- 26-01-02 03:38:32[韦忠禄-2499] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2499 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050759315490723 -- 26-01-02 03:38:32[韦忠禄-2499] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2499,updatedby_id = 2499 where extrafareApply_id = 70259 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026251077651978 -- 26-01-02 03:38:55[韦忠禄-2499] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2499 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032889842987061 -- 26-01-02 03:38:55[韦忠禄-2499] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2499 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049741268157959 -- 26-01-02 03:38:55[韦忠禄-2499] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2499,updatedby_id = 2499 where extrafareApply_id = 70259 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0055129528045654 -- 26-01-02 03:38:55[韦忠禄-2499] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2499,updatedby_id = 2499 where otherfee_id = 2379 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019982099533081 -- 26-01-02 03:39:08[韦忠禄-2499] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 and e.extrafare_name like '%停车费%' limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017196893692017 -- 26-01-02 03:39:25[韦忠禄-2499] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2499 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034070014953613 -- 26-01-02 03:39:25[韦忠禄-2499] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2499 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015676975250244 -- 26-01-02 03:39:30[韦忠禄-2499] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2499 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030698776245117 -- 26-01-02 03:39:30[韦忠禄-2499] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2499 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044059753417969 -- 26-01-02 03:39:30[韦忠禄-2499] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2499,updatedby_id = 2499 where extrafareApply_id = 70259 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040891170501709 -- 26-01-02 03:39:30[韦忠禄-2499] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2499,updatedby_id = 2499 where otherfee_id = 2379 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017129182815552 -- 26-01-02 03:39:30[韦忠禄-2499] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2499 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017549991607666 -- 26-01-02 09:11:02[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022328853607178 -- 26-01-02 09:11:05[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083198547363281 -- 26-01-02 09:11:05[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045039653778076 -- 26-01-02 09:11:05[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052499771118164 -- 26-01-02 09:11:05[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050199031829834 -- 26-01-02 09:11:05[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 2544 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018296003341675 -- 26-01-02 09:11:07[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43304 SELECT fa.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc, apply.cont_name apply_cont,org.org_name department,12 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account, date_format(fa.apply_date,'%Y-%m-%d %H:%i') apply_date FROM dboa.oa_fareApply fa LEFT JOIN dboa.oa_appr_process o ON fa.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON fa.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON fa.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON fa.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON fa.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_customer receiving ON fa.receiving_unit_id = receiving.customer_id WHERE fa.fareApply_id = 43304 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033659934997559 -- 26-01-02 09:11:07[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43304 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003565788269043 -- 26-01-02 09:11:07[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43304 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5858237 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034070014953613 -- 26-01-02 09:11:07[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43304 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034310817718506 -- 26-01-02 09:11:07[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43304 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034060478210449 -- 26-01-02 09:11:07[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43304 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5858237 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033719539642334 -- 26-01-02 09:11:07[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43304 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018410205841064 -- 26-01-02 09:11:07[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =49 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%刘晓进%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027029991149902 -- 26-01-02 09:11:07[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 49 and cont.cont_isenable = 1 AND cont.cont_name like '%刘晓进%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019483089447021 -- 26-01-02 09:11:07[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 49 AND o.org_name like '%运营部%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016211986541748 -- 26-01-02 09:11:07[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 49 AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018234968185425 -- 26-01-02 09:11:08[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select DISTINCT IFNULL(p_e.parent_id,1) parent_id from dbsys.sys_project p left join dbsys.sys_project_ext p_e on p.project_id = p_e.project_id where p.acct_id = 49 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039510726928711 -- 26-01-02 09:11:08[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select p.project_id AS `value`,p.project_name AS `title` from dbsys.sys_project p where p.acct_id = 49 and p.project_id not in (1,1251,1253) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016618013381958 -- 26-01-02 09:11:11[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039730072021484 -- 26-01-02 09:11:11[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036771297454834 -- 26-01-02 09:11:11[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036771297454834 -- 26-01-02 09:11:11[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036671161651611 -- 26-01-02 09:11:11[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 2544 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016433954238892 -- 26-01-02 09:11:12[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43305 SELECT fa.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc, apply.cont_name apply_cont,org.org_name department,12 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account, date_format(fa.apply_date,'%Y-%m-%d %H:%i') apply_date FROM dboa.oa_fareApply fa LEFT JOIN dboa.oa_appr_process o ON fa.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON fa.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON fa.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON fa.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON fa.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_customer receiving ON fa.receiving_unit_id = receiving.customer_id WHERE fa.fareApply_id = 43305 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031440258026123 -- 26-01-02 09:11:12[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43305 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003331184387207 -- 26-01-02 09:11:12[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43305 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5858239 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031578540802002 -- 26-01-02 09:11:12[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43305 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031318664550781 -- 26-01-02 09:11:12[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43305 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003197193145752 -- 26-01-02 09:11:12[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43305 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5858239 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031459331512451 -- 26-01-02 09:11:12[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43305 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028793096542358 -- 26-01-02 09:11:13[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =49 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%刘晓进%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016731023788452 -- 26-01-02 09:11:13[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 49 and cont.cont_isenable = 1 AND cont.cont_name like '%刘晓进%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015116930007935 -- 26-01-02 09:11:13[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 49 AND o.org_name like '%运营部%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017165184020996 -- 26-01-02 09:11:13[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 49 AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017946004867554 -- 26-01-02 09:11:13[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select DISTINCT IFNULL(p_e.parent_id,1) parent_id from dbsys.sys_project p left join dbsys.sys_project_ext p_e on p.project_id = p_e.project_id where p.acct_id = 49 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031819343566895 -- 26-01-02 09:11:13[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select p.project_id AS `value`,p.project_name AS `title` from dbsys.sys_project p where p.acct_id = 49 and p.project_id not in (1,1251,1253) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027832984924316 -- 26-01-02 09:11:17[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035109519958496 -- 26-01-02 09:11:17[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037388801574707 -- 26-01-02 09:11:17[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037260055541992 -- 26-01-02 09:11:17[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037729740142822 -- 26-01-02 09:11:17[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 2544 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018213033676147 -- 26-01-02 09:11:22[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43215 SELECT fa.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc, apply.cont_name apply_cont,org.org_name department,12 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account, date_format(fa.apply_date,'%Y-%m-%d %H:%i') apply_date FROM dboa.oa_fareApply fa LEFT JOIN dboa.oa_appr_process o ON fa.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON fa.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON fa.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON fa.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON fa.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_customer receiving ON fa.receiving_unit_id = receiving.customer_id WHERE fa.fareApply_id = 43215 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032370090484619 -- 26-01-02 09:11:22[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43215 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039970874786377 -- 26-01-02 09:11:22[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43215 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5844162 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032391548156738 -- 26-01-02 09:11:22[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43215 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032391548156738 -- 26-01-02 09:11:22[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43215 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032908916473389 -- 26-01-02 09:11:22[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43215 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5844162 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032539367675781 -- 26-01-02 09:11:22[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43215 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019609928131104 -- 26-01-02 09:11:22[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =49 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%刘晓进%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018780946731567 -- 26-01-02 09:11:22[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 49 and cont.cont_isenable = 1 AND cont.cont_name like '%刘晓进%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017427921295166 -- 26-01-02 09:11:23[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 49 AND o.org_name like '%运营部%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028827905654907 -- 26-01-02 09:11:23[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 49 AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016423940658569 -- 26-01-02 09:11:23[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select DISTINCT IFNULL(p_e.parent_id,1) parent_id from dbsys.sys_project p left join dbsys.sys_project_ext p_e on p.project_id = p_e.project_id where p.acct_id = 49 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032169818878174 -- 26-01-02 09:11:23[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select p.project_id AS `value`,p.project_name AS `title` from dbsys.sys_project p where p.acct_id = 49 and p.project_id not in (1,1251,1253) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017577886581421 -- 26-01-02 10:11:51[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034580230712891 -- 26-01-02 10:11:52[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051670074462891 -- 26-01-02 10:11:52[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2496,updatedby_id = 2496 where extrafareApply_id = 70260 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017086029052734 -- 26-01-02 10:12:26[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033571720123291 -- 26-01-02 10:12:26[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049731731414795 -- 26-01-02 10:12:26[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2496,updatedby_id = 2496 where extrafareApply_id = 70260 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049688816070557 -- 26-01-02 10:12:26[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2496,updatedby_id = 2496 where otherfee_id = 2380 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017706155776978 -- 26-01-02 10:12:30[张永利-2496] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016844987869263 -- 26-01-02 10:12:53[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033211708068848 -- 26-01-02 10:12:53[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0053567886352539 -- 26-01-02 10:12:53[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2496,updatedby_id = 2496 where extrafareApply_id = 70260 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051970481872559 -- 26-01-02 10:12:53[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2496,updatedby_id = 2496 where otherfee_id = 2380 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016102075576782 -- 26-01-02 10:12:54[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032298564910889 -- 26-01-02 10:12:55[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016972064971924 -- 26-01-02 10:12:57[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033609867095947 -- 26-01-02 10:12:57[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047669410705566 -- 26-01-02 10:12:57[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2496,updatedby_id = 2496 where extrafareApply_id = 70260 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052490234375 -- 26-01-02 10:12:57[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2496,updatedby_id = 2496 where otherfee_id = 2380 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023695945739746 -- 26-01-02 10:13:00[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032849311828613 -- 26-01-02 10:13:00[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046780109405518 -- 26-01-02 10:13:00[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2496,updatedby_id = 2496 where extrafareApply_id = 70260 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052578449249268 -- 26-01-02 10:13:00[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2496,updatedby_id = 2496 where otherfee_id = 2380 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023725986480713 -- 26-01-02 10:13:00[张永利-2496] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017416954040527 -- 26-01-02 10:13:39[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034420490264893 -- 26-01-02 10:13:39[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047600269317627 -- 26-01-02 10:13:39[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2496,updatedby_id = 2496 where extrafareApply_id = 70261 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015903949737549 -- 26-01-02 10:14:07[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031161308288574 -- 26-01-02 10:14:07[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046150684356689 -- 26-01-02 10:14:07[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2496,updatedby_id = 2496 where extrafareApply_id = 70261 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043308734893799 -- 26-01-02 10:14:07[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2496,updatedby_id = 2496 where otherfee_id = 2381 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024734020233154 -- 26-01-02 10:14:09[张永利-2496] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030520915985107 -- 26-01-02 10:14:43[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003119945526123 -- 26-01-02 10:14:43[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004457950592041 -- 26-01-02 10:14:43[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2496,updatedby_id = 2496 where extrafareApply_id = 70261 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047290325164795 -- 26-01-02 10:14:43[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2496,updatedby_id = 2496 where otherfee_id = 2381 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017209053039551 -- 26-01-02 10:14:44[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033450126647949 -- 26-01-02 10:14:44[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016638040542603 -- 26-01-02 10:14:47[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032730102539062 -- 26-01-02 10:14:47[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047848224639893 -- 26-01-02 10:14:47[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2496,updatedby_id = 2496 where extrafareApply_id = 70261 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044100284576416 -- 26-01-02 10:14:47[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2496,updatedby_id = 2496 where otherfee_id = 2381 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028139114379883 -- 26-01-02 10:14:51[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003399133682251 -- 26-01-02 10:14:51[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050039291381836 -- 26-01-02 10:14:51[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2496,updatedby_id = 2496 where extrafareApply_id = 70261 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046501159667969 -- 26-01-02 10:14:51[张永利-2496] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2496,updatedby_id = 2496 where otherfee_id = 2381 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025279998779297 -- 26-01-02 10:14:51[张永利-2496] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2496 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016188144683838 -- 26-01-02 11:04:57 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031378269195557 -- 26-01-02 11:04:57 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041041374206543 -- 26-01-02 11:04:57 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='WuLingGang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034120082855225 -- 26-01-02 11:04:57[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017759084701538 -- 26-01-02 11:04:58[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016985893249512 -- 26-01-02 11:05:01[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115647 SELECT p.*,c.cont_name apply_cont,o.org_name department,13 appr_type_id FROM dboa.oa_payment p LEFT JOIN dbsys.sys_contact c on p.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON p.department_id = o.org_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id WHERE payment_id = 115647 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036540031433105 -- 26-01-02 11:05:01[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115647 select payment_id from dbthird.thd_payment where oa_payment_id = 115647 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036790370941162 -- 26-01-02 11:05:01[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115647 SELECT s.*,cust.cust_name carrier FROM dbthird.thd_statement s LEFT JOIN dbthird.thd_customer cust ON cust.customer_id = s.customer_id WHERE s.payment_id = 133181 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0054271221160889 -- 26-01-02 11:05:01[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115647 SELECT pr.*,pr.payrecord_id as recid, DATE_FORMAT(pr.pay_date,'%Y-%m-%d') pay_date,c.cont_name operator FROM dboa.oa_payrecord pr LEFT JOIN dbsys.sys_contact c ON pr.operator_id = c.cont_id WHERE pr.owner_id = 5854860 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031521320343018 -- 26-01-02 11:05:01[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115647 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032930374145508 -- 26-01-02 11:05:02[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115647 select * from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003695011138916 -- 26-01-02 11:05:02[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115647 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5854860 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031421184539795 -- 26-01-02 11:05:02[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115647 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031118392944336 -- 26-01-02 11:05:02[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115647 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031478404998779 -- 26-01-02 11:05:02[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115647 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026976823806763 -- 26-01-02 11:05:03[吴凌刚-279] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=115647 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016563892364502 -- 26-01-02 11:05:03[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017936944961548 -- 26-01-02 11:05:04[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115646 SELECT p.*,c.cont_name apply_cont,o.org_name department,13 appr_type_id FROM dboa.oa_payment p LEFT JOIN dbsys.sys_contact c on p.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON p.department_id = o.org_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id WHERE payment_id = 115646 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034120082855225 -- 26-01-02 11:05:04[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115646 select payment_id from dbthird.thd_payment where oa_payment_id = 115646 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035049915313721 -- 26-01-02 11:05:04[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115646 SELECT s.*,cust.cust_name carrier FROM dbthird.thd_statement s LEFT JOIN dbthird.thd_customer cust ON cust.customer_id = s.customer_id WHERE s.payment_id = 133180 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038628578186035 -- 26-01-02 11:05:04[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115646 SELECT pr.*,pr.payrecord_id as recid, DATE_FORMAT(pr.pay_date,'%Y-%m-%d') pay_date,c.cont_name operator FROM dboa.oa_payrecord pr LEFT JOIN dbsys.sys_contact c ON pr.operator_id = c.cont_id WHERE pr.owner_id = 5854816 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033228397369385 -- 26-01-02 11:05:04[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115646 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033500194549561 -- 26-01-02 11:05:04[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115646 select * from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034568309783936 -- 26-01-02 11:05:04[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115646 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5854816 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033199787139893 -- 26-01-02 11:05:04[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115646 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033040046691895 -- 26-01-02 11:05:04[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115646 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033369064331055 -- 26-01-02 11:05:04[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=115646 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018187999725342 -- 26-01-02 11:05:05[吴凌刚-279] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=115646 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016403913497925 -- 26-01-02 11:05:06[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017809867858887 -- 26-01-02 11:05:07[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43256 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 43256 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040960311889648 -- 26-01-02 11:05:07[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43256 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43256 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039529800415039 -- 26-01-02 11:05:07[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43256 SELECT pr.*,pr.payrecord_id as recid, DATE_FORMAT(pr.pay_date,'%Y-%m-%d') pay_date,c.cont_name operator FROM dboa.oa_payrecord pr LEFT JOIN dbsys.sys_contact c ON pr.operator_id = c.cont_id WHERE pr.owner_id = 5850512 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034098625183105 -- 26-01-02 11:05:07[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43256 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035710334777832 -- 26-01-02 11:05:07[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43256 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5850512 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034008026123047 -- 26-01-02 11:05:07[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43256 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017159938812256 -- 26-01-02 11:05:11[吴凌刚-279] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=43256 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021807909011841 -- 26-01-02 11:05:12[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019339084625244 -- 26-01-02 11:05:12[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=7237 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 7237 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034430027008057 -- 26-01-02 11:05:12[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=7237 select org_id,org_name from dbsys.sys_org where corp_acct_id = 5 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033299922943115 -- 26-01-02 11:05:12[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=7237 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035099983215332 -- 26-01-02 11:05:12[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=7237 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5851925 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033848285675049 -- 26-01-02 11:05:12[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_officialSeals&officialSeals_id=7237 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016078948974609 -- 26-01-02 11:05:14[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=pbl_updateApprStatus select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017182111740112 -- 26-01-02 11:05:14[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017452001571655 -- 26-01-02 11:05:36[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.045116901397705 -- 26-01-02 11:05:36[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037870407104492 -- 26-01-02 11:05:36[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042128562927246 -- 26-01-02 11:05:36[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042879581451416 -- 26-01-02 11:05:36[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 279 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024707078933716 -- 26-01-02 11:05:38[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43253 SELECT fa.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc, apply.cont_name apply_cont,org.org_name department,12 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account, date_format(fa.apply_date,'%Y-%m-%d %H:%i') apply_date FROM dboa.oa_fareApply fa LEFT JOIN dboa.oa_appr_process o ON fa.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON fa.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON fa.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON fa.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON fa.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_customer receiving ON fa.receiving_unit_id = receiving.customer_id WHERE fa.fareApply_id = 43253 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031929016113281 -- 26-01-02 11:05:38[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43253 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038721561431885 -- 26-01-02 11:05:39[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43253 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5849816 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030620098114014 -- 26-01-02 11:05:39[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43253 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030529499053955 -- 26-01-02 11:05:39[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43253 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030760765075684 -- 26-01-02 11:05:39[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43253 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5849816 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030848979949951 -- 26-01-02 11:05:39[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43253 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026238918304443 -- 26-01-02 11:05:39[吴凌刚-279] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =5 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%吴凌刚%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016685009002686 -- 26-01-02 11:05:39[吴凌刚-279] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 5 and cont.cont_isenable = 1 AND cont.cont_name like '%吴凌刚%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015624046325684 -- 26-01-02 11:05:39[吴凌刚-279] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 5 AND o.org_name like '%项目二部%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016701936721802 -- 26-01-02 11:05:39[吴凌刚-279] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 5 AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016945123672485 -- 26-01-02 11:05:39[吴凌刚-279] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select DISTINCT IFNULL(p_e.parent_id,1) parent_id from dbsys.sys_project p left join dbsys.sys_project_ext p_e on p.project_id = p_e.project_id where p.acct_id = 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034351348876953 -- 26-01-02 11:05:39[吴凌刚-279] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select p.project_id AS `value`,p.project_name AS `title` from dbsys.sys_project p where p.acct_id = 5 and p.project_id not in (24,196,1,10,242) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01697301864624 -- 26-01-02 11:05:48[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0066421031951904 -- 26-01-02 11:05:48[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003364086151123 -- 26-01-02 11:05:48[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038440227508545 -- 26-01-02 11:05:48[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037140846252441 -- 26-01-02 11:05:48[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 279 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018162965774536 -- 26-01-02 11:17:19[闫华超-2464] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017109155654907 -- 26-01-02 11:17:30[闫华超-2464] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2464 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033249855041504 -- 26-01-02 11:17:30[闫华超-2464] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2464 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051708221435547 -- 26-01-02 11:17:30[闫华超-2464] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2464,updatedby_id = 2464 where extrafareApply_id = 70262 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017379999160767 -- 26-01-02 11:18:12[闫华超-2464] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2464 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033929347991943 -- 26-01-02 11:18:12[闫华超-2464] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2464 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024434089660645 -- 26-01-02 11:18:14[闫华超-2464] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2464 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033619403839111 -- 26-01-02 11:18:14[闫华超-2464] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2464 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049448013305664 -- 26-01-02 11:18:14[闫华超-2464] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2464,updatedby_id = 2464 where extrafareApply_id = 70262 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004774808883667 -- 26-01-02 11:18:14[闫华超-2464] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2464,updatedby_id = 2464 where otherfee_id = 2382 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016669034957886 -- 26-01-02 11:18:14[闫华超-2464] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2464 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017964124679565 -- 26-01-02 11:20:23[闫华超-2464] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017177104949951 -- 26-01-02 11:20:31[闫华超-2464] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2464 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033769607543945 -- 26-01-02 11:20:31[闫华超-2464] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2464 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047199726104736 -- 26-01-02 11:20:31[闫华超-2464] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2464,updatedby_id = 2464 where extrafareApply_id = 70263 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019292116165161 -- 26-01-02 11:20:58[闫华超-2464] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2464 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034019947052002 -- 26-01-02 11:20:58[闫华超-2464] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2464 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016638994216919 -- 26-01-02 11:21:00[闫华超-2464] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2464 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032980442047119 -- 26-01-02 11:21:00[闫华超-2464] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2464 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045280456542969 -- 26-01-02 11:21:00[闫华超-2464] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2464,updatedby_id = 2464 where extrafareApply_id = 70263 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045490264892578 -- 26-01-02 11:21:00[闫华超-2464] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2464,updatedby_id = 2464 where otherfee_id = 2383 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020509004592896 -- 26-01-02 11:21:00[闫华超-2464] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2464 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022258996963501 -- 26-01-02 11:28:10[杨林-2511] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026199102401733 -- 26-01-02 11:28:25[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035400390625 -- 26-01-02 11:28:25[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050821304321289 -- 26-01-02 11:28:25[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2511,updatedby_id = 2511 where extrafareApply_id = 70264 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017271041870117 -- 26-01-02 11:30:31[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034291744232178 -- 26-01-02 11:30:31[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048160552978516 -- 26-01-02 11:30:31[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2511,updatedby_id = 2511 where extrafareApply_id = 70264 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046391487121582 -- 26-01-02 11:30:31[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2511,updatedby_id = 2511 where otherfee_id = 2384 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015742063522339 -- 26-01-02 11:30:37[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031349658966064 -- 26-01-02 11:30:37[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045661926269531 -- 26-01-02 11:30:37[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2511,updatedby_id = 2511 where extrafareApply_id = 70264 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044119358062744 -- 26-01-02 11:30:37[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2511,updatedby_id = 2511 where otherfee_id = 2384 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01617693901062 -- 26-01-02 11:30:40[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003183126449585 -- 26-01-02 11:30:40[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027064800262451 -- 26-01-02 11:30:44[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003216028213501 -- 26-01-02 11:30:44[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045819282531738 -- 26-01-02 11:30:44[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2511,updatedby_id = 2511 where extrafareApply_id = 70264 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043458938598633 -- 26-01-02 11:30:44[杨林-2511] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2511,updatedby_id = 2511 where otherfee_id = 2384 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028483867645264 -- 26-01-02 11:30:44[杨林-2511] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2511 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016445159912109 -- 26-01-02 14:29:18 -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032100677490234 -- 26-01-02 14:29:18 -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041029453277588 -- 26-01-02 14:29:18 -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='HuangYuHua' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033528804779053 -- 26-01-02 14:29:18[黄玉华-2567] -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 49 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01691198348999 -- 26-01-02 14:29:19[黄玉华-2567] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 2567 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052590370178223 -- 26-01-02 14:29:19[黄玉华-2567] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 2567 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037398338317871 -- 26-01-02 14:29:19[黄玉华-2567] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 2567 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038471221923828 -- 26-01-02 14:29:19[黄玉华-2567] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 2567 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039539337158203 -- 26-01-02 14:29:19[黄玉华-2567] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 2567 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016597032546997 -- 26-01-02 14:29:25[黄玉华-2567] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43296 SELECT fa.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc, apply.cont_name apply_cont,org.org_name department,12 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account, date_format(fa.apply_date,'%Y-%m-%d %H:%i') apply_date FROM dboa.oa_fareApply fa LEFT JOIN dboa.oa_appr_process o ON fa.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON fa.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON fa.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON fa.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON fa.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_customer receiving ON fa.receiving_unit_id = receiving.customer_id WHERE fa.fareApply_id = 43296 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030968189239502 -- 26-01-02 14:29:25[黄玉华-2567] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43296 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2567 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032610893249512 -- 26-01-02 14:29:25[黄玉华-2567] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43296 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5854136 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030090808868408 -- 26-01-02 14:29:25[黄玉华-2567] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43296 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2567 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030109882354736 -- 26-01-02 14:29:25[黄玉华-2567] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43296 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2567 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030510425567627 -- 26-01-02 14:29:25[黄玉华-2567] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43296 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5854136 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030109882354736 -- 26-01-02 14:29:25[黄玉华-2567] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43296 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2567 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021479845046997 -- 26-01-02 14:29:25[黄玉华-2567] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =49 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%盐城聚艺运输有限公司郑州分公司%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015929937362671 -- 26-01-02 14:29:25[黄玉华-2567] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 49 and cont.cont_isenable = 1 AND cont.cont_name like '%黄玉华%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016565084457397 -- 26-01-02 14:29:25[黄玉华-2567] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 49 AND o.org_name like '%总经办%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016808032989502 -- 26-01-02 14:29:25[黄玉华-2567] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 49 AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017050981521606 -- 26-01-02 14:29:26[黄玉华-2567] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select DISTINCT IFNULL(p_e.parent_id,1) parent_id from dbsys.sys_project p left join dbsys.sys_project_ext p_e on p.project_id = p_e.project_id where p.acct_id = 49 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033779144287109 -- 26-01-02 14:29:26[黄玉华-2567] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select p.project_id AS `value`,p.project_name AS `title` from dbsys.sys_project p where p.acct_id = 49 and p.project_id not in (1,1251,1253) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017729997634888 -- 26-01-02 14:29:34[黄玉华-2567] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 2567 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040619373321533 -- 26-01-02 14:29:34[黄玉华-2567] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 2567 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039169788360596 -- 26-01-02 14:29:34[黄玉华-2567] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 2567 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038580894470215 -- 26-01-02 14:29:34[黄玉华-2567] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 2567 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038878917694092 -- 26-01-02 14:29:34[黄玉华-2567] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 2567 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016296148300171 -- 26-01-02 14:47:46 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032169818878174 -- 26-01-02 14:47:46 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042710304260254 -- 26-01-02 14:47:46 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='ZengLong' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034010410308838 -- 26-01-02 14:47:46[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 49 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025434970855713 -- 26-01-02 14:47:46[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016188144683838 -- 26-01-02 14:47:48[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70122 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70122 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035898685455322 -- 26-01-02 14:47:48[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70122 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 70122 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034708976745605 -- 26-01-02 14:47:48[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70122 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70122 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047991275787354 -- 26-01-02 14:47:48[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70122 SELECT efa_tsl.extrafareapply_tslorder_id recid,efa.status_id,o.order_id,o.order_no,r.route_name,o.order_date,14 as buzSystem_id, w_sl.copilot_driver,w.driver,w.truck_no FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_tslorder efa_tsl ON efa_tsl.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbtsl.tsl_order o ON efa_tsl.order_id = o.order_id LEFT JOIN dbtsl.tsl_orderex_ftl o_ftl ON o.order_id = o_ftl.order_id LEFT JOIN dbtsl.tsl_route r ON o_ftl.route_id = r.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id WHERE efa.extrafareApply_id = 70122 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029940605163574 -- 26-01-02 14:47:48[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70122 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030109882354736 -- 26-01-02 14:47:49[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70122 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031611919403076 -- 26-01-02 14:47:49[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70122 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5846041 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029730796813965 -- 26-01-02 14:47:49[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70122 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026892900466919 -- 26-01-02 14:47:50[曾隆-2542] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70122 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017134189605713 -- 26-01-02 14:47:51[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017346858978271 -- 26-01-02 14:47:52[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70120 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70120 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003856897354126 -- 26-01-02 14:47:52[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70120 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 70120 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037491321563721 -- 26-01-02 14:47:52[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70120 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70120 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046050548553467 -- 26-01-02 14:47:52[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70120 SELECT efa_tsl.extrafareapply_tslorder_id recid,efa.status_id,o.order_id,o.order_no,r.route_name,o.order_date,14 as buzSystem_id, w_sl.copilot_driver,w.driver,w.truck_no FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_tslorder efa_tsl ON efa_tsl.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbtsl.tsl_order o ON efa_tsl.order_id = o.order_id LEFT JOIN dbtsl.tsl_orderex_ftl o_ftl ON o.order_id = o_ftl.order_id LEFT JOIN dbtsl.tsl_route r ON o_ftl.route_id = r.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id WHERE efa.extrafareApply_id = 70120 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032351016998291 -- 26-01-02 14:47:52[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70120 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032570362091064 -- 26-01-02 14:47:52[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70120 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034420490264893 -- 26-01-02 14:47:52[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70120 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5846017 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032460689544678 -- 26-01-02 14:47:52[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70120 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017874956130981 -- 26-01-02 14:47:53[曾隆-2542] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70120 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023044109344482 -- 26-01-02 14:47:54[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021158933639526 -- 26-01-02 14:47:59[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70119 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70119 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035891532897949 -- 26-01-02 14:47:59[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70119 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 70119 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00388503074646 -- 26-01-02 14:47:59[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70119 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70119 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036659240722656 -- 26-01-02 14:47:59[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70119 SELECT efa_tsl.extrafareapply_tslorder_id recid,efa.status_id,o.order_id,o.order_no,r.route_name,o.order_date,14 as buzSystem_id, w_sl.copilot_driver,w.driver,w.truck_no FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_tslorder efa_tsl ON efa_tsl.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbtsl.tsl_order o ON efa_tsl.order_id = o.order_id LEFT JOIN dbtsl.tsl_orderex_ftl o_ftl ON o.order_id = o_ftl.order_id LEFT JOIN dbtsl.tsl_route r ON o_ftl.route_id = r.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id WHERE efa.extrafareApply_id = 70119 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033349990844727 -- 26-01-02 14:47:59[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70119 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033609867095947 -- 26-01-02 14:47:59[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70119 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035278797149658 -- 26-01-02 14:47:59[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70119 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5846014 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033349990844727 -- 26-01-02 14:47:59[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70119 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016024112701416 -- 26-01-02 14:48:00[曾隆-2542] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70119 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016026020050049 -- 26-01-02 14:48:01[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016546964645386 -- 26-01-02 14:48:02[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70118 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70118 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003648042678833 -- 26-01-02 14:48:02[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70118 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 70118 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035488605499268 -- 26-01-02 14:48:02[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70118 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70118 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049381256103516 -- 26-01-02 14:48:02[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70118 SELECT efa_tsl.extrafareapply_tslorder_id recid,efa.status_id,o.order_id,o.order_no,r.route_name,o.order_date,14 as buzSystem_id, w_sl.copilot_driver,w.driver,w.truck_no FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_tslorder efa_tsl ON efa_tsl.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbtsl.tsl_order o ON efa_tsl.order_id = o.order_id LEFT JOIN dbtsl.tsl_orderex_ftl o_ftl ON o.order_id = o_ftl.order_id LEFT JOIN dbtsl.tsl_route r ON o_ftl.route_id = r.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id WHERE efa.extrafareApply_id = 70118 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030820369720459 -- 26-01-02 14:48:02[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70118 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003108024597168 -- 26-01-02 14:48:02[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70118 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032470226287842 -- 26-01-02 14:48:02[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70118 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5846004 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003101110458374 -- 26-01-02 14:48:02[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70118 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01622200012207 -- 26-01-02 14:48:04[曾隆-2542] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70118 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015470027923584 -- 26-01-02 14:48:04[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016397953033447 -- 26-01-02 14:48:06[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70117 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70117 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033450126647949 -- 26-01-02 14:48:06[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70117 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 70117 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037109851837158 -- 26-01-02 14:48:06[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70117 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70117 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047211647033691 -- 26-01-02 14:48:06[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70117 SELECT efa_tsl.extrafareapply_tslorder_id recid,efa.status_id,o.order_id,o.order_no,r.route_name,o.order_date,14 as buzSystem_id, w_sl.copilot_driver,w.driver,w.truck_no FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_tslorder efa_tsl ON efa_tsl.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbtsl.tsl_order o ON efa_tsl.order_id = o.order_id LEFT JOIN dbtsl.tsl_orderex_ftl o_ftl ON o.order_id = o_ftl.order_id LEFT JOIN dbtsl.tsl_route r ON o_ftl.route_id = r.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id WHERE efa.extrafareApply_id = 70117 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031368732452393 -- 26-01-02 14:48:06[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70117 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031599998474121 -- 26-01-02 14:48:06[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70117 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033059120178223 -- 26-01-02 14:48:06[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70117 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5845983 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031411647796631 -- 26-01-02 14:48:06[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70117 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020247936248779 -- 26-01-02 14:48:07[曾隆-2542] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70117 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016960144042969 -- 26-01-02 14:48:08[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021892070770264 -- 26-01-02 14:48:08[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70116 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70116 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036249160766602 -- 26-01-02 14:48:08[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70116 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 70116 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035309791564941 -- 26-01-02 14:48:08[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70116 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70116 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0053310394287109 -- 26-01-02 14:48:08[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70116 SELECT efa_tsl.extrafareapply_tslorder_id recid,efa.status_id,o.order_id,o.order_no,r.route_name,o.order_date,14 as buzSystem_id, w_sl.copilot_driver,w.driver,w.truck_no FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_tslorder efa_tsl ON efa_tsl.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbtsl.tsl_order o ON efa_tsl.order_id = o.order_id LEFT JOIN dbtsl.tsl_orderex_ftl o_ftl ON o.order_id = o_ftl.order_id LEFT JOIN dbtsl.tsl_route r ON o_ftl.route_id = r.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id WHERE efa.extrafareApply_id = 70116 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033960342407227 -- 26-01-02 14:48:08[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70116 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034031867980957 -- 26-01-02 14:48:08[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70116 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035679340362549 -- 26-01-02 14:48:08[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70116 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5845968 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034191608428955 -- 26-01-02 14:48:08[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70116 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016819000244141 -- 26-01-02 14:48:09[曾隆-2542] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70116 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015960931777954 -- 26-01-02 14:48:10[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017868995666504 -- 26-01-02 14:48:11[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70115 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70115 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036230087280273 -- 26-01-02 14:48:11[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70115 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 70115 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035400390625 -- 26-01-02 14:48:11[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70115 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70115 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037181377410889 -- 26-01-02 14:48:11[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70115 SELECT efa_tsl.extrafareapply_tslorder_id recid,efa.status_id,o.order_id,o.order_no,r.route_name,o.order_date,14 as buzSystem_id, w_sl.copilot_driver,w.driver,w.truck_no FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_tslorder efa_tsl ON efa_tsl.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbtsl.tsl_order o ON efa_tsl.order_id = o.order_id LEFT JOIN dbtsl.tsl_orderex_ftl o_ftl ON o.order_id = o_ftl.order_id LEFT JOIN dbtsl.tsl_route r ON o_ftl.route_id = r.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id WHERE efa.extrafareApply_id = 70115 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034101009368896 -- 26-01-02 14:48:11[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70115 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034329891204834 -- 26-01-02 14:48:11[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70115 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035829544067383 -- 26-01-02 14:48:11[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70115 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5845956 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034160614013672 -- 26-01-02 14:48:11[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70115 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017970085144043 -- 26-01-02 14:48:12[曾隆-2542] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70115 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016425132751465 -- 26-01-02 14:48:13[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017212152481079 -- 26-01-02 14:48:14[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70111 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70111 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035281181335449 -- 26-01-02 14:48:14[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70111 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 70111 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003856897354126 -- 26-01-02 14:48:14[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70111 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70111 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036070346832275 -- 26-01-02 14:48:14[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70111 SELECT efa_tsl.extrafareapply_tslorder_id recid,efa.status_id,o.order_id,o.order_no,r.route_name,o.order_date,14 as buzSystem_id, w_sl.copilot_driver,w.driver,w.truck_no FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_tslorder efa_tsl ON efa_tsl.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbtsl.tsl_order o ON efa_tsl.order_id = o.order_id LEFT JOIN dbtsl.tsl_orderex_ftl o_ftl ON o.order_id = o_ftl.order_id LEFT JOIN dbtsl.tsl_route r ON o_ftl.route_id = r.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id WHERE efa.extrafareApply_id = 70111 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033669471740723 -- 26-01-02 14:48:14[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70111 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033259391784668 -- 26-01-02 14:48:14[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70111 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035078525543213 -- 26-01-02 14:48:14[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70111 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5845870 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032639503479004 -- 26-01-02 14:48:14[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70111 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022387027740479 -- 26-01-02 14:48:15[曾隆-2542] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70111 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021084070205688 -- 26-01-02 14:48:16[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016134023666382 -- 26-01-02 14:48:17[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70107 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70107 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033040046691895 -- 26-01-02 14:48:17[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70107 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 70107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036370754241943 -- 26-01-02 14:48:17[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70107 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70107 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034060478210449 -- 26-01-02 14:48:17[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70107 SELECT efa_tsl.extrafareapply_tslorder_id recid,efa.status_id,o.order_id,o.order_no,r.route_name,o.order_date,14 as buzSystem_id, w_sl.copilot_driver,w.driver,w.truck_no FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_tslorder efa_tsl ON efa_tsl.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbtsl.tsl_order o ON efa_tsl.order_id = o.order_id LEFT JOIN dbtsl.tsl_orderex_ftl o_ftl ON o.order_id = o_ftl.order_id LEFT JOIN dbtsl.tsl_route r ON o_ftl.route_id = r.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id WHERE efa.extrafareApply_id = 70107 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030701160430908 -- 26-01-02 14:48:17[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70107 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030851364135742 -- 26-01-02 14:48:17[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70107 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032939910888672 -- 26-01-02 14:48:17[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70107 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5845625 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030629634857178 -- 26-01-02 14:48:17[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70107 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017287969589233 -- 26-01-02 14:48:18[曾隆-2542] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70107 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020902872085571 -- 26-01-02 14:48:18[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017116069793701 -- 26-01-02 14:48:19[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43296 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 43296 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039200782775879 -- 26-01-02 14:48:19[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43296 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43296 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038509368896484 -- 26-01-02 14:48:19[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43296 SELECT pr.*,pr.payrecord_id as recid, DATE_FORMAT(pr.pay_date,'%Y-%m-%d') pay_date,c.cont_name operator FROM dboa.oa_payrecord pr LEFT JOIN dbsys.sys_contact c ON pr.operator_id = c.cont_id WHERE pr.owner_id = 5854136 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032021999359131 -- 26-01-02 14:48:19[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43296 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033230781555176 -- 26-01-02 14:48:19[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43296 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5854136 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031838417053223 -- 26-01-02 14:48:19[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43296 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021830081939697 -- 26-01-02 14:48:22[曾隆-2542] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=43296 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019013166427612 -- 26-01-02 14:48:23[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019243955612183 -- 26-01-02 14:48:24[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43215 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 43215 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036089420318604 -- 26-01-02 14:48:24[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43215 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43215 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036180019378662 -- 26-01-02 14:48:24[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43215 SELECT pr.*,pr.payrecord_id as recid, DATE_FORMAT(pr.pay_date,'%Y-%m-%d') pay_date,c.cont_name operator FROM dboa.oa_payrecord pr LEFT JOIN dbsys.sys_contact c ON pr.operator_id = c.cont_id WHERE pr.owner_id = 5844162 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030879974365234 -- 26-01-02 14:48:24[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43215 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032370090484619 -- 26-01-02 14:48:24[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43215 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5844162 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003108024597168 -- 26-01-02 14:48:24[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43215 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017719984054565 -- 26-01-02 14:48:26[曾隆-2542] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=43215 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016016006469727 -- 26-01-02 14:48:26[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017039060592651 -- 26-01-02 14:53:40[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43215 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 43215 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00388503074646 -- 26-01-02 14:53:40[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43215 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43215 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003978967666626 -- 26-01-02 14:53:40[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43215 SELECT pr.*,pr.payrecord_id as recid, DATE_FORMAT(pr.pay_date,'%Y-%m-%d') pay_date,c.cont_name operator FROM dboa.oa_payrecord pr LEFT JOIN dbsys.sys_contact c ON pr.operator_id = c.cont_id WHERE pr.owner_id = 5844162 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033550262451172 -- 26-01-02 14:53:40[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43215 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035049915313721 -- 26-01-02 14:53:40[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43215 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5844162 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032520294189453 -- 26-01-02 14:53:40[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43215 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018651008605957 -- 26-01-02 14:53:42[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016623020172119 -- 26-01-02 14:57:18[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43296 SELECT fa.*,c.cont_name apply_cont,o.org_name department,12 appr_type_id FROM dboa.oa_fareApply fa LEFT JOIN dbsys.sys_contact c on fa.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON fa.department_id = o.org_id WHERE fareApply_id = 43296 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038011074066162 -- 26-01-02 14:57:18[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43296 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43296 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037078857421875 -- 26-01-02 14:57:18[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43296 SELECT pr.*,pr.payrecord_id as recid, DATE_FORMAT(pr.pay_date,'%Y-%m-%d') pay_date,c.cont_name operator FROM dboa.oa_payrecord pr LEFT JOIN dbsys.sys_contact c ON pr.operator_id = c.cont_id WHERE pr.owner_id = 5854136 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032470226287842 -- 26-01-02 14:57:18[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43296 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033431053161621 -- 26-01-02 14:57:18[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43296 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5854136 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031559467315674 -- 26-01-02 14:57:18[曾隆-2542] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=43296 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2542 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017451047897339 -- 26-01-02 16:02:11 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033960342407227 -- 26-01-02 16:02:11 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039699077606201 -- 26-01-02 16:02:11 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='GuoRongBo' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036060810089111 -- 26-01-02 16:02:11[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017737865447998 -- 26-01-02 16:02:11[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028536081314087 -- 26-01-02 16:02:12[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_purcApply&purcapply_id=3942 select a.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(a.purch_apply_date,'%Y-%m-%d') apply_date,1 appr_type_id,p.appr_proc_name, date_format(a.purch_end_date,'%Y-%m-%d') purch_end_date from dbpurc.purc_apply a LEFT JOIN dbsys.sys_contact c ON a.purch_apply_id = c.cont_id LEFT JOIN dbsys.sys_org org ON a.purch_department_id = org.org_id LEFT JOIN dbsys.sys_contact cr on a.createdby_id = cr.cont_id LEFT JOIN dbsys.sys_contact up on a.updatedby_id = up.cont_id LEFT JOIN dboa.oa_appr_process p ON a.appr_proc_id = p.appr_proc_id where a.purcapply_id = 3942 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0059950351715088 -- 26-01-02 16:02:12[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_purcApply&purcapply_id=3942 select * from dbpurc.purc_apply_product where purcapply_id = 3942 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030639171600342 -- 26-01-02 16:02:12[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_purcApply&purcapply_id=3942 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019187927246094 -- 26-01-02 16:02:20[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=pbl_updateApprStatus select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028717994689941 -- 26-01-02 16:02:21[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020355939865112 -- 26-01-02 16:02:25[郭荣波-35] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 35 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016605854034424 -- 26-01-02 16:17:31 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032451152801514 -- 26-01-02 16:17:31 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043540000915527 -- 26-01-02 16:17:31 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='YuZeXu' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034430027008057 -- 26-01-02 16:17:31[余泽旭-927] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 23 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017462968826294 -- 26-01-02 16:17:32[余泽旭-927] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 927 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017834901809692 -- 26-01-02 17:05:23[侯江华-2476] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019118070602417 -- 26-01-02 17:08:39 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032329559326172 -- 26-01-02 17:08:39 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004162073135376 -- 26-01-02 17:08:39 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='ZhangYong' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034329891204834 -- 26-01-02 17:08:39[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01702094078064 -- 26-01-02 17:08:40[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020470857620239 -- 26-01-02 19:51:28 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034170150756836 -- 26-01-02 19:51:28 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003931999206543 -- 26-01-02 19:51:28 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='WangXiang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035829544067383 -- 26-01-02 19:51:28[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 23 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020662069320679 -- 26-01-02 19:51:29[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016748905181885 -- 26-01-02 19:55:52 -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033471584320068 -- 26-01-02 19:55:52 -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003899097442627 -- 26-01-02 19:55:52 -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='LiuXiaoJin' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035519599914551 -- 26-01-02 19:55:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 49 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018226861953735 -- 26-01-02 19:55:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042109489440918 -- 26-01-02 19:55:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039529800415039 -- 26-01-02 19:55:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039288997650146 -- 26-01-02 19:55:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038869380950928 -- 26-01-02 19:55:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 2544 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019128084182739 -- 26-01-02 19:55:55[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43304 SELECT fa.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc, apply.cont_name apply_cont,org.org_name department,12 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account, date_format(fa.apply_date,'%Y-%m-%d %H:%i') apply_date FROM dboa.oa_fareApply fa LEFT JOIN dboa.oa_appr_process o ON fa.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON fa.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON fa.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON fa.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON fa.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_customer receiving ON fa.receiving_unit_id = receiving.customer_id WHERE fa.fareApply_id = 43304 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034630298614502 -- 26-01-02 19:55:55[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43304 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035488605499268 -- 26-01-02 19:55:55[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43304 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5858237 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033612251281738 -- 26-01-02 19:55:55[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43304 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033540725708008 -- 26-01-02 19:55:55[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43304 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033988952636719 -- 26-01-02 19:55:55[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43304 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5858237 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033550262451172 -- 26-01-02 19:55:55[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43304 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017601013183594 -- 26-01-02 19:55:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =49 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%刘晓进%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023119926452637 -- 26-01-02 19:55:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 49 and cont.cont_isenable = 1 AND cont.cont_name like '%刘晓进%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020761966705322 -- 26-01-02 19:55:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 49 AND o.org_name like '%运营部%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016519069671631 -- 26-01-02 19:55:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 49 AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016573190689087 -- 26-01-02 19:55:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select DISTINCT IFNULL(p_e.parent_id,1) parent_id from dbsys.sys_project p left join dbsys.sys_project_ext p_e on p.project_id = p_e.project_id where p.acct_id = 49 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032279491424561 -- 26-01-02 19:55:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select p.project_id AS `value`,p.project_name AS `title` from dbsys.sys_project p where p.acct_id = 49 and p.project_id not in (1,1251,1253) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017443180084229 -- 26-01-02 19:56:02[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003957986831665 -- 26-01-02 19:56:02[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037901401519775 -- 26-01-02 19:56:02[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037579536437988 -- 26-01-02 19:56:02[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 2544 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037500858306885 -- 26-01-02 19:56:02[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 2544 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01665210723877 -- 26-01-02 19:56:24[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016649007797241 -- 26-01-02 23:02:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270158%22}&event=edit_extrafareApply&extrafareApply_id=70158 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70158 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037040710449219 -- 26-01-02 23:02:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270158%22}&event=edit_extrafareApply&extrafareApply_id=70158 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 70158 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036990642547607 -- 26-01-02 23:02:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270158%22}&event=edit_extrafareApply&extrafareApply_id=70158 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70158 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038330554962158 -- 26-01-02 23:02:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270158%22}&event=edit_extrafareApply&extrafareApply_id=70158 SELECT efa_to.extrafareapply_thdorder_id recid,efa.status_id,o.order_id,o.order_no,a.area_name dest_city,o.pieces,o.weight,3 as buzSystem_id FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_thdorder efa_to ON efa_to.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbthird.thd_order o ON efa_to.order_id = o.order_id LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE efa.extrafareApply_id = 70158 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031590461730957 -- 26-01-02 23:02:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270158%22}&event=edit_extrafareApply&extrafareApply_id=70158 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003115177154541 -- 26-01-02 23:02:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270158%22}&event=edit_extrafareApply&extrafareApply_id=70158 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032739639282227 -- 26-01-02 23:02:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270158%22}&event=edit_extrafareApply&extrafareApply_id=70158 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5849588 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031249523162842 -- 26-01-02 23:02:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270158%22}&event=edit_extrafareApply&extrafareApply_id=70158 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0177321434021 -- 26-01-02 23:03:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270157%22}&event=edit_extrafareApply&extrafareApply_id=70157 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70157 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039331912994385 -- 26-01-02 23:03:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270157%22}&event=edit_extrafareApply&extrafareApply_id=70157 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 70157 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037970542907715 -- 26-01-02 23:03:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270157%22}&event=edit_extrafareApply&extrafareApply_id=70157 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70157 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039341449737549 -- 26-01-02 23:03:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270157%22}&event=edit_extrafareApply&extrafareApply_id=70157 SELECT efa_to.extrafareapply_thdorder_id recid,efa.status_id,o.order_id,o.order_no,a.area_name dest_city,o.pieces,o.weight,3 as buzSystem_id FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_thdorder efa_to ON efa_to.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbthird.thd_order o ON efa_to.order_id = o.order_id LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE efa.extrafareApply_id = 70157 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033140182495117 -- 26-01-02 23:03:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270157%22}&event=edit_extrafareApply&extrafareApply_id=70157 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003331184387207 -- 26-01-02 23:03:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270157%22}&event=edit_extrafareApply&extrafareApply_id=70157 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034890174865723 -- 26-01-02 23:03:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270157%22}&event=edit_extrafareApply&extrafareApply_id=70157 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5849584 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033199787139893 -- 26-01-02 23:03:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270157%22}&event=edit_extrafareApply&extrafareApply_id=70157 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016489028930664 -- 26-01-02 23:03:08[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270091%22}&event=edit_extrafareApply&extrafareApply_id=70091 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70091 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033509731292725 -- 26-01-02 23:03:08[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270091%22}&event=edit_extrafareApply&extrafareApply_id=70091 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 70091 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036320686340332 -- 26-01-02 23:03:08[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270091%22}&event=edit_extrafareApply&extrafareApply_id=70091 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70091 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037579536437988 -- 26-01-02 23:03:08[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270091%22}&event=edit_extrafareApply&extrafareApply_id=70091 SELECT efa_to.extrafareapply_thdorder_id recid,efa.status_id,o.order_id,o.order_no,a.area_name dest_city,o.pieces,o.weight,3 as buzSystem_id FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_thdorder efa_to ON efa_to.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbthird.thd_order o ON efa_to.order_id = o.order_id LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE efa.extrafareApply_id = 70091 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031330585479736 -- 26-01-02 23:03:08[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270091%22}&event=edit_extrafareApply&extrafareApply_id=70091 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003119945526123 -- 26-01-02 23:03:08[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270091%22}&event=edit_extrafareApply&extrafareApply_id=70091 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032579898834229 -- 26-01-02 23:03:08[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270091%22}&event=edit_extrafareApply&extrafareApply_id=70091 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5844967 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031230449676514 -- 26-01-02 23:03:08[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270091%22}&event=edit_extrafareApply&extrafareApply_id=70091 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016045093536377 -- 26-01-02 23:03:15[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270091%22}&event=edit_extrafareApply&extrafareApply_id=70091 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70091 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031411647796631 -- 26-01-02 23:03:15[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270091%22}&event=edit_extrafareApply&extrafareApply_id=70091 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 70091 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003148078918457 -- 26-01-02 23:03:15[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270091%22}&event=edit_extrafareApply&extrafareApply_id=70091 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70091 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031490325927734 -- 26-01-02 23:03:15[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270091%22}&event=edit_extrafareApply&extrafareApply_id=70091 SELECT efa_to.extrafareapply_thdorder_id recid,efa.status_id,o.order_id,o.order_no,a.area_name dest_city,o.pieces,o.weight,3 as buzSystem_id FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_thdorder efa_to ON efa_to.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbthird.thd_order o ON efa_to.order_id = o.order_id LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE efa.extrafareApply_id = 70091 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031540393829346 -- 26-01-02 23:03:15[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270091%22}&event=edit_extrafareApply&extrafareApply_id=70091 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031490325927734 -- 26-01-02 23:03:15[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270091%22}&event=edit_extrafareApply&extrafareApply_id=70091 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031778812408447 -- 26-01-02 23:03:15[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270091%22}&event=edit_extrafareApply&extrafareApply_id=70091 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5844967 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031170845031738 -- 26-01-02 23:03:15[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270091%22}&event=edit_extrafareApply&extrafareApply_id=70091 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01977014541626 -- 26-01-02 23:03:21[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270039%22}&event=edit_extrafareApply&extrafareApply_id=70039 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70039 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034549236297607 -- 26-01-02 23:03:21[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270039%22}&event=edit_extrafareApply&extrafareApply_id=70039 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 70039 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033631324768066 -- 26-01-02 23:03:21[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270039%22}&event=edit_extrafareApply&extrafareApply_id=70039 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70039 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034787654876709 -- 26-01-02 23:03:21[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270039%22}&event=edit_extrafareApply&extrafareApply_id=70039 SELECT efa_to.extrafareapply_thdorder_id recid,efa.status_id,o.order_id,o.order_no,a.area_name dest_city,o.pieces,o.weight,3 as buzSystem_id FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_thdorder efa_to ON efa_to.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbthird.thd_order o ON efa_to.order_id = o.order_id LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE efa.extrafareApply_id = 70039 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032191276550293 -- 26-01-02 23:03:21[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270039%22}&event=edit_extrafareApply&extrafareApply_id=70039 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032260417938232 -- 26-01-02 23:03:21[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270039%22}&event=edit_extrafareApply&extrafareApply_id=70039 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033800601959229 -- 26-01-02 23:03:21[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270039%22}&event=edit_extrafareApply&extrafareApply_id=70039 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5836145 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032260417938232 -- 26-01-02 23:03:21[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270039%22}&event=edit_extrafareApply&extrafareApply_id=70039 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017442941665649 -- 26-01-02 23:03:26[张昭霞-2107] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70039 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016117811203003 -- 26-01-02 23:03:26[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021815061569214 -- 26-01-02 23:03:27[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270039%22}&event=edit_extrafareApply&extrafareApply_id=70039 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70039 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030210018157959 -- 26-01-02 23:03:27[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270039%22}&event=edit_extrafareApply&extrafareApply_id=70039 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 70039 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030281543731689 -- 26-01-02 23:03:27[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270039%22}&event=edit_extrafareApply&extrafareApply_id=70039 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70039 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030219554901123 -- 26-01-02 23:03:27[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270039%22}&event=edit_extrafareApply&extrafareApply_id=70039 SELECT efa_to.extrafareapply_thdorder_id recid,efa.status_id,o.order_id,o.order_no,a.area_name dest_city,o.pieces,o.weight,3 as buzSystem_id FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_thdorder efa_to ON efa_to.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbthird.thd_order o ON efa_to.order_id = o.order_id LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE efa.extrafareApply_id = 70039 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029997825622559 -- 26-01-02 23:03:28[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270039%22}&event=edit_extrafareApply&extrafareApply_id=70039 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030171871185303 -- 26-01-02 23:03:28[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270039%22}&event=edit_extrafareApply&extrafareApply_id=70039 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030109882354736 -- 26-01-02 23:03:28[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270039%22}&event=edit_extrafareApply&extrafareApply_id=70039 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5836145 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029761791229248 -- 26-01-02 23:03:28[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2270039%22}&event=edit_extrafareApply&extrafareApply_id=70039 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019496917724609 -- 26-01-02 23:03:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269916%22}&event=edit_extrafareApply&extrafareApply_id=69916 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,of.costAlloc_type_id,receive.cust_disp_name receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(of.otherfee_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_otherfee of ON r.extrafareApply_id = of.extrafareApply_id LEFT JOIN dbthird.v_thd_customer receive ON receive.sys_cust_id = r.receiving_unit_id and receive.acct_id = r.acct_id WHERE r.extrafareApply_id = 69916 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003371000289917 -- 26-01-02 23:03:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269916%22}&event=edit_extrafareApply&extrafareApply_id=69916 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034201145172119 -- 26-01-02 23:03:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269916%22}&event=edit_extrafareApply&extrafareApply_id=69916 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035388469696045 -- 26-01-02 23:03:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269916%22}&event=edit_extrafareApply&extrafareApply_id=69916 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5825417 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033760070800781 -- 26-01-02 23:03:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269916%22}&event=edit_extrafareApply&extrafareApply_id=69916 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021551132202148 -- 26-01-02 23:03:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =9 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%兴华兄弟货运%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018299102783203 -- 26-01-02 23:03:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 9 and cont.cont_isenable = 1 AND cont.cont_name like '%张昭霞%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016952037811279 -- 26-01-02 23:03:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.org_name like '%运输部%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019244909286499 -- 26-01-02 23:03:41[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269832%22}&event=edit_extrafareApply&extrafareApply_id=69832 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,of.costAlloc_type_id,receive.cust_disp_name receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(of.otherfee_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_otherfee of ON r.extrafareApply_id = of.extrafareApply_id LEFT JOIN dbthird.v_thd_customer receive ON receive.sys_cust_id = r.receiving_unit_id and receive.acct_id = r.acct_id WHERE r.extrafareApply_id = 69832 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034201145172119 -- 26-01-02 23:03:41[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269832%22}&event=edit_extrafareApply&extrafareApply_id=69832 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034410953521729 -- 26-01-02 23:03:41[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269832%22}&event=edit_extrafareApply&extrafareApply_id=69832 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035650730133057 -- 26-01-02 23:03:41[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269832%22}&event=edit_extrafareApply&extrafareApply_id=69832 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5817960 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034301280975342 -- 26-01-02 23:03:41[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269832%22}&event=edit_extrafareApply&extrafareApply_id=69832 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.03072714805603 -- 26-01-02 23:03:41[张昭霞-2107] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =9 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%协创%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017222166061401 -- 26-01-02 23:03:41[张昭霞-2107] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 9 and cont.cont_isenable = 1 AND cont.cont_name like '%张昭霞%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024372100830078 -- 26-01-02 23:03:41[张昭霞-2107] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.org_name like '%运输部%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018523931503296 -- 26-01-02 23:03:47[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269749%22}&event=edit_extrafareApply&extrafareApply_id=69749 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,of.costAlloc_type_id,receive.cust_disp_name receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(of.otherfee_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_otherfee of ON r.extrafareApply_id = of.extrafareApply_id LEFT JOIN dbthird.v_thd_customer receive ON receive.sys_cust_id = r.receiving_unit_id and receive.acct_id = r.acct_id WHERE r.extrafareApply_id = 69749 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032081604003906 -- 26-01-02 23:03:47[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269749%22}&event=edit_extrafareApply&extrafareApply_id=69749 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032670497894287 -- 26-01-02 23:03:47[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269749%22}&event=edit_extrafareApply&extrafareApply_id=69749 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033700466156006 -- 26-01-02 23:03:47[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269749%22}&event=edit_extrafareApply&extrafareApply_id=69749 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5811981 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032048225402832 -- 26-01-02 23:03:47[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269749%22}&event=edit_extrafareApply&extrafareApply_id=69749 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029031991958618 -- 26-01-02 23:03:47[张昭霞-2107] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =9 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%河南泽骋-浩运%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016168117523193 -- 26-01-02 23:03:47[张昭霞-2107] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 9 and cont.cont_isenable = 1 AND cont.cont_name like '%张昭霞%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016198873519897 -- 26-01-02 23:03:47[张昭霞-2107] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.org_name like '%运输部%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01793098449707 -- 26-01-02 23:03:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269750%22}&event=edit_extrafareApply&extrafareApply_id=69750 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 69750 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036177635192871 -- 26-01-02 23:03:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269750%22}&event=edit_extrafareApply&extrafareApply_id=69750 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 69750 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038740634918213 -- 26-01-02 23:03:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269750%22}&event=edit_extrafareApply&extrafareApply_id=69750 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 69750 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036242008209229 -- 26-01-02 23:03:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269750%22}&event=edit_extrafareApply&extrafareApply_id=69750 SELECT efa_to.extrafareapply_thdorder_id recid,efa.status_id,o.order_id,o.order_no,a.area_name dest_city,o.pieces,o.weight,3 as buzSystem_id FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_thdorder efa_to ON efa_to.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbthird.thd_order o ON efa_to.order_id = o.order_id LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE efa.extrafareApply_id = 69750 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033788681030273 -- 26-01-02 23:03:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269750%22}&event=edit_extrafareApply&extrafareApply_id=69750 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034029483795166 -- 26-01-02 23:03:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269750%22}&event=edit_extrafareApply&extrafareApply_id=69750 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035479068756104 -- 26-01-02 23:03:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269750%22}&event=edit_extrafareApply&extrafareApply_id=69750 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5812021 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033800601959229 -- 26-01-02 23:03:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269750%22}&event=edit_extrafareApply&extrafareApply_id=69750 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020251035690308 -- 26-01-02 23:04:04[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269706%22}&event=edit_extrafareApply&extrafareApply_id=69706 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 69706 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035459995269775 -- 26-01-02 23:04:04[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269706%22}&event=edit_extrafareApply&extrafareApply_id=69706 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 69706 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037219524383545 -- 26-01-02 23:04:04[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269706%22}&event=edit_extrafareApply&extrafareApply_id=69706 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 69706 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038461685180664 -- 26-01-02 23:04:04[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269706%22}&event=edit_extrafareApply&extrafareApply_id=69706 SELECT efa_to.extrafareapply_thdorder_id recid,efa.status_id,o.order_id,o.order_no,a.area_name dest_city,o.pieces,o.weight,3 as buzSystem_id FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_thdorder efa_to ON efa_to.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbthird.thd_order o ON efa_to.order_id = o.order_id LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE efa.extrafareApply_id = 69706 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031111240386963 -- 26-01-02 23:04:04[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269706%22}&event=edit_extrafareApply&extrafareApply_id=69706 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031228065490723 -- 26-01-02 23:04:04[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269706%22}&event=edit_extrafareApply&extrafareApply_id=69706 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032808780670166 -- 26-01-02 23:04:04[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269706%22}&event=edit_extrafareApply&extrafareApply_id=69706 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5805435 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030889511108398 -- 26-01-02 23:04:04[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269706%22}&event=edit_extrafareApply&extrafareApply_id=69706 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00307297706604 -- 26-01-02 23:04:04[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269706%22}&event=edit_extrafareApply&extrafareApply_id=69706 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018883943557739 -- 26-01-02 23:04:12[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269608%22}&event=edit_extrafareApply&extrafareApply_id=69608 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,of.costAlloc_type_id,receive.cust_disp_name receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(of.otherfee_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_otherfee of ON r.extrafareApply_id = of.extrafareApply_id LEFT JOIN dbthird.v_thd_customer receive ON receive.sys_cust_id = r.receiving_unit_id and receive.acct_id = r.acct_id WHERE r.extrafareApply_id = 69608 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033230781555176 -- 26-01-02 23:04:12[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269608%22}&event=edit_extrafareApply&extrafareApply_id=69608 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033621788024902 -- 26-01-02 23:04:12[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269608%22}&event=edit_extrafareApply&extrafareApply_id=69608 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035209655761719 -- 26-01-02 23:04:12[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269608%22}&event=edit_extrafareApply&extrafareApply_id=69608 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5792927 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033268928527832 -- 26-01-02 23:04:12[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269608%22}&event=edit_extrafareApply&extrafareApply_id=69608 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024522066116333 -- 26-01-02 23:04:12[张昭霞-2107] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =9 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%协创%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017598867416382 -- 26-01-02 23:04:13[张昭霞-2107] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 9 and cont.cont_isenable = 1 AND cont.cont_name like '%张昭霞%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017391920089722 -- 26-01-02 23:04:13[张昭霞-2107] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.org_name like '%运输部%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019185066223145 -- 26-01-02 23:04:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269421%22}&event=edit_extrafareApply&extrafareApply_id=69421 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 69421 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033791065216064 -- 26-01-02 23:04:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269421%22}&event=edit_extrafareApply&extrafareApply_id=69421 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 69421 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036830902099609 -- 26-01-02 23:04:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269421%22}&event=edit_extrafareApply&extrafareApply_id=69421 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 69421 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038371086120605 -- 26-01-02 23:04:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269421%22}&event=edit_extrafareApply&extrafareApply_id=69421 SELECT efa_to.extrafareapply_thdorder_id recid,efa.status_id,o.order_id,o.order_no,a.area_name dest_city,o.pieces,o.weight,3 as buzSystem_id FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_thdorder efa_to ON efa_to.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbthird.thd_order o ON efa_to.order_id = o.order_id LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE efa.extrafareApply_id = 69421 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031449794769287 -- 26-01-02 23:04:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269421%22}&event=edit_extrafareApply&extrafareApply_id=69421 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031919479370117 -- 26-01-02 23:04:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269421%22}&event=edit_extrafareApply&extrafareApply_id=69421 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032811164855957 -- 26-01-02 23:04:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269421%22}&event=edit_extrafareApply&extrafareApply_id=69421 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5782731 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003148078918457 -- 26-01-02 23:04:34[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2269421%22}&event=edit_extrafareApply&extrafareApply_id=69421 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018892049789429 -- 26-01-02 23:38:48 -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036699771881104 -- 26-01-02 23:38:48 -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042431354522705 -- 26-01-02 23:38:48 -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='WuLingGang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039350986480713 -- 26-01-02 23:38:48[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016779899597168 -- 26-01-02 23:38:48[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00718092918396 -- 26-01-02 23:38:48[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038630962371826 -- 26-01-02 23:38:48[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039780139923096 -- 26-01-02 23:38:48[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037820339202881 -- 26-01-02 23:38:48[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 279 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018007040023804 -- 26-01-02 23:38:50[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43253 SELECT fa.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc, apply.cont_name apply_cont,org.org_name department,12 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account, date_format(fa.apply_date,'%Y-%m-%d %H:%i') apply_date FROM dboa.oa_fareApply fa LEFT JOIN dboa.oa_appr_process o ON fa.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON fa.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON fa.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON fa.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON fa.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_customer receiving ON fa.receiving_unit_id = receiving.customer_id WHERE fa.fareApply_id = 43253 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032448768615723 -- 26-01-02 23:38:50[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43253 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033528804779053 -- 26-01-02 23:38:50[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43253 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5849816 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003201961517334 -- 26-01-02 23:38:50[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43253 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031580924987793 -- 26-01-02 23:38:50[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43253 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00319504737854 -- 26-01-02 23:38:50[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43253 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5849816 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031781196594238 -- 26-01-02 23:38:50[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43253 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 279 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018876075744629 -- 26-01-02 23:38:50[吴凌刚-279] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =5 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%吴凌刚%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01784086227417 -- 26-01-02 23:38:50[吴凌刚-279] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 5 and cont.cont_isenable = 1 AND cont.cont_name like '%吴凌刚%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01701807975769 -- 26-01-02 23:38:51[吴凌刚-279] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 5 AND o.org_name like '%项目二部%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016739130020142 -- 26-01-02 23:38:51[吴凌刚-279] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 5 AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018208980560303 -- 26-01-02 23:38:51[吴凌刚-279] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select DISTINCT IFNULL(p_e.parent_id,1) parent_id from dbsys.sys_project p left join dbsys.sys_project_ext p_e on p.project_id = p_e.project_id where p.acct_id = 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037131309509277 -- 26-01-02 23:38:51[吴凌刚-279] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select p.project_id AS `value`,p.project_name AS `title` from dbsys.sys_project p where p.acct_id = 5 and p.project_id not in (24,196,1,10,242) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01661491394043 -- 26-01-02 23:38:52[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0055088996887207 -- 26-01-02 23:38:52[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035910606384277 -- 26-01-02 23:38:52[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035951137542725 -- 26-01-02 23:38:52[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 279 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035231113433838 -- 26-01-02 23:38:52[吴凌刚-279] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 279 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------