Time: 0.021563053131104 -- 26-01-01 00:09: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.0033659934997559 -- 26-01-01 00:09: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.0042610168457031 -- 26-01-01 00:09: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='ZhangTiHai' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003525972366333 -- 26-01-01 00:09:31[张体海-1176] -- /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.01587700843811 -- 26-01-01 00:09: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.018054008483887 -- 26-01-01 00:09:31[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017196893692017 -- 26-01-01 00:09:33[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=69461 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 69461 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003831148147583 -- 26-01-01 00:09:33[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=69461 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 = 69461 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037651062011719 -- 26-01-01 00:09:33[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=69461 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 69461 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038549900054932 -- 26-01-01 00:09:33[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=69461 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 = 69461 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031991004943848 -- 26-01-01 00:09:33[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=69461 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032391548156738 -- 26-01-01 00:09:33[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=69461 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033590793609619 -- 26-01-01 00:09:33[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=69461 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5783652 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00319504737854 -- 26-01-01 00:09:33[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=69461 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016373157501221 -- 26-01-01 00:09:34[张体海-1176] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=69461 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029397010803223 -- 26-01-01 00:09:34[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017099857330322 -- 26-01-01 00:13:07[张志强-319] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015417098999023 -- 26-01-01 00:13:07[张志强-319] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016026973724365 -- 26-01-01 00:13:16[张志强-319] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023256063461304 -- 26-01-01 00:13:20[张志强-319] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016765832901001 -- 26-01-01 00:13:20[张志强-319] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 319 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01671314239502 -- 26-01-01 00:31:25 -- /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.003242015838623 -- 26-01-01 00:31:25 -- /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.0059690475463867 -- 26-01-01 00:31:25 -- /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='HuangYuHua' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00341796875 -- 26-01-01 00:31:25[黄玉华-2567] -- /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.016091823577881 -- 26-01-01 00:31:26[黄玉华-2567] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2567 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015889883041382 -- 26-01-01 03:44:05 -- /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.0031640529632568 -- 26-01-01 03:44:05 -- /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.0041470527648926 -- 26-01-01 03:44:05 -- /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='WenFeng' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034940242767334 -- 26-01-01 03:44:05[文锋-1382] -- /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= 29 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016845941543579 -- 26-01-01 03:44:05[文锋-1382] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1382 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018451929092407 -- 26-01-01 06:05:42[匡兵-2488] -- /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.016207933425903 -- 26-01-01 06:06:22[匡兵-2488] -- /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 = 2488 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031650066375732 -- 26-01-01 06:06:23[匡兵-2488] -- /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 = 2488 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049300193786621 -- 26-01-01 06:06:23[匡兵-2488] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2488,updatedby_id = 2488 where extrafareApply_id = 70243 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016457796096802 -- 26-01-01 06:12:05[匡兵-2488] -- /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 = 2488 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032298564910889 -- 26-01-01 06:12:05[匡兵-2488] -- /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 = 2488 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050420761108398 -- 26-01-01 06:12:05[匡兵-2488] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2488,updatedby_id = 2488 where extrafareApply_id = 70243 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0056390762329102 -- 26-01-01 06:12:05[匡兵-2488] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2488,updatedby_id = 2488 where otherfee_id = 2337 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016748189926147 -- 26-01-01 06:12:22[匡兵-2488] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2488 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032649040222168 -- 26-01-01 06:12:22[匡兵-2488] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2488 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015870094299316 -- 26-01-01 06:12:29[匡兵-2488] -- /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 = 2488 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031301975250244 -- 26-01-01 06:12:29[匡兵-2488] -- /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 = 2488 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046291351318359 -- 26-01-01 06:12:29[匡兵-2488] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2488,updatedby_id = 2488 where extrafareApply_id = 70243 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049638748168945 -- 26-01-01 06:12:29[匡兵-2488] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2488,updatedby_id = 2488 where otherfee_id = 2337 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028022050857544 -- 26-01-01 06:12:29[匡兵-2488] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2488 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017274856567383 -- 26-01-01 06:12:31[匡兵-2488] -- /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 = 2488 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034258365631104 -- 26-01-01 06:12:31[匡兵-2488] -- /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 = 2488 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048880577087402 -- 26-01-01 06:12:31[匡兵-2488] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2488,updatedby_id = 2488 where extrafareApply_id = 70243 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047199726104736 -- 26-01-01 06:12:31[匡兵-2488] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2488,updatedby_id = 2488 where otherfee_id = 2337 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016510009765625 -- 26-01-01 06:12:31[匡兵-2488] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2488 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01793909072876 -- 26-01-01 09:40:53 -- /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.00347900390625 -- 26-01-01 09:40:53 -- /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.0044929981231689 -- 26-01-01 09:40:53 -- /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.003654956817627 -- 26-01-01 09:40:53[刘晓进-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.016557931900024 -- 26-01-01 09:40:54[刘晓进-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.0072188377380371 -- 26-01-01 09:40:54[刘晓进-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.0044710636138916 -- 26-01-01 09:40:54[刘晓进-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.0050399303436279 -- 26-01-01 09:40:54[刘晓进-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.0046181678771973 -- 26-01-01 09:40:54[刘晓进-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.021291017532349 -- 26-01-01 09:41:01[刘晓进-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.0032320022583008 -- 26-01-01 09:41:01[刘晓进-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.0038340091705322 -- 26-01-01 09:41:01[刘晓进-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.0031609535217285 -- 26-01-01 09:41:01[刘晓进-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.0033669471740723 -- 26-01-01 09:41:01[刘晓进-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.0031759738922119 -- 26-01-01 09:41:01[刘晓进-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.0031590461730957 -- 26-01-01 09:41:01[刘晓进-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.017199993133545 -- 26-01-01 09:41:01[刘晓进-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.016463041305542 -- 26-01-01 09:41:01[刘晓进-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.018244981765747 -- 26-01-01 09:41:01[刘晓进-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.017191886901855 -- 26-01-01 09:41:01[刘晓进-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.017523050308228 -- 26-01-01 09:41:01[刘晓进-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.0034029483795166 -- 26-01-01 09:41:01[刘晓进-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.019000053405762 -- 26-01-01 09:41:09[刘晓进-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.004256010055542 -- 26-01-01 09:41:09[刘晓进-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.0040771961212158 -- 26-01-01 09:41:09[刘晓进-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.0040709972381592 -- 26-01-01 09:41:09[刘晓进-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.0040180683135986 -- 26-01-01 09:41:09[刘晓进-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.016762018203735 -- 26-01-01 09:41:19[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 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 = 43216 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032551288604736 -- 26-01-01 09:41:19[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034191608428955 -- 26-01-01 09:41:19[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5844242 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031890869140625 -- 26-01-01 09:41:19[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031850337982178 -- 26-01-01 09:41:19[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032129287719727 -- 26-01-01 09:41:19[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5844242 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003180980682373 -- 26-01-01 09:41:19[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016638994216919 -- 26-01-01 09:41:19[刘晓进-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.016576051712036 -- 26-01-01 09:41:19[刘晓进-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.016541957855225 -- 26-01-01 09:41:19[刘晓进-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.018179178237915 -- 26-01-01 09:41:19[刘晓进-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.017269134521484 -- 26-01-01 09:41:20[刘晓进-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.0034170150756836 -- 26-01-01 09:41:20[刘晓进-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.02802300453186 -- 26-01-01 09:41:32[刘晓进-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.003741979598999 -- 26-01-01 09:41:32[刘晓进-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.0035851001739502 -- 26-01-01 09:41:32[刘晓进-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.0035700798034668 -- 26-01-01 09:41:32[刘晓进-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.003544807434082 -- 26-01-01 09:41:32[刘晓进-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.018048048019409 -- 26-01-01 09:41:41[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43161 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 = 43161 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032470226287842 -- 26-01-01 09:41:41[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43161 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034360885620117 -- 26-01-01 09:41:41[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43161 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5836112 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032689571380615 -- 26-01-01 09:41:41[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43161 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032258033752441 -- 26-01-01 09:41:41[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43161 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032861232757568 -- 26-01-01 09:41:41[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43161 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5836112 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032458305358887 -- 26-01-01 09:41:41[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43161 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015978097915649 -- 26-01-01 09:41:41[刘晓进-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.019456148147583 -- 26-01-01 09:41:41[刘晓进-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.023865938186646 -- 26-01-01 09:41:41[刘晓进-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.016257047653198 -- 26-01-01 09:41:41[刘晓进-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.025943994522095 -- 26-01-01 09:41:41[刘晓进-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.0031530857086182 -- 26-01-01 09:41:41[刘晓进-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.019533157348633 -- 26-01-01 09:41:46[刘晓进-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.0034611225128174 -- 26-01-01 09:41:46[刘晓进-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.0036220550537109 -- 26-01-01 09:41:46[刘晓进-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.0035860538482666 -- 26-01-01 09:41:46[刘晓进-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.0035707950592041 -- 26-01-01 09:41:46[刘晓进-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.018562078475952 -- 26-01-01 09:41:48[刘晓进-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.0033810138702393 -- 26-01-01 09:41:48[刘晓进-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.0035309791564941 -- 26-01-01 09:41:48[刘晓进-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.0033731460571289 -- 26-01-01 09:41:48[刘晓进-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.0033688545227051 -- 26-01-01 09:41:48[刘晓进-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.0034220218658447 -- 26-01-01 09:41:48[刘晓进-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.0033919811248779 -- 26-01-01 09:41:48[刘晓进-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.024688005447388 -- 26-01-01 09:41:48[刘晓进-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.022557020187378 -- 26-01-01 09:41:48[刘晓进-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.016393899917603 -- 26-01-01 09:41:48[刘晓进-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.021404981613159 -- 26-01-01 09:41:48[刘晓进-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.017284154891968 -- 26-01-01 09:41:49[刘晓进-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.0033731460571289 -- 26-01-01 09:41:49[刘晓进-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.018718004226685 -- 26-01-01 09:41:51[刘晓进-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.0037329196929932 -- 26-01-01 09:41:51[刘晓进-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.0038690567016602 -- 26-01-01 09:41:51[刘晓进-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.003896951675415 -- 26-01-01 09:41:51[刘晓进-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.0038290023803711 -- 26-01-01 09:41:51[刘晓进-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.015464067459106 -- 26-01-01 09:41:53[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 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 = 43216 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029270648956299 -- 26-01-01 09:41:53[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031018257141113 -- 26-01-01 09:41:54[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5844242 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029251575469971 -- 26-01-01 09:41:54[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029129981994629 -- 26-01-01 09:41:54[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029411315917969 -- 26-01-01 09:41:54[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5844242 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029239654541016 -- 26-01-01 09:41:54[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017275094985962 -- 26-01-01 09:41:54[刘晓进-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.017482042312622 -- 26-01-01 09:41:54[刘晓进-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.019731044769287 -- 26-01-01 09:41:54[刘晓进-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.015676021575928 -- 26-01-01 09:41:54[刘晓进-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.016470909118652 -- 26-01-01 09:41:54[刘晓进-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.0032010078430176 -- 26-01-01 09:41:54[刘晓进-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.01669716835022 -- 26-01-01 09:41:59[刘晓进-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.0034558773040771 -- 26-01-01 09:41:59[刘晓进-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.0033078193664551 -- 26-01-01 09:41:59[刘晓进-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.0033180713653564 -- 26-01-01 09:41:59[刘晓进-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.0033140182495117 -- 26-01-01 09:41:59[刘晓进-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.020823001861572 -- 26-01-01 09:42:01[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 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 = 43216 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032310485839844 -- 26-01-01 09:42:01[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032739639282227 -- 26-01-01 09:42:01[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5844242 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003244161605835 -- 26-01-01 09:42:01[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032639503479004 -- 26-01-01 09:42:01[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003303050994873 -- 26-01-01 09:42:01[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5844242 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032360553741455 -- 26-01-01 09:42:01[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017168045043945 -- 26-01-01 09:42:02[刘晓进-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.016489028930664 -- 26-01-01 09:42:02[刘晓进-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.016607046127319 -- 26-01-01 09:42:02[刘晓进-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.016684055328369 -- 26-01-01 09:42:02[刘晓进-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.021323919296265 -- 26-01-01 09:42:02[刘晓进-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.0034759044647217 -- 26-01-01 09:42:02[刘晓进-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.019386053085327 -- 26-01-01 09:42: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.0042600631713867 -- 26-01-01 09:42: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.0040838718414307 -- 26-01-01 09:42: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.0040469169616699 -- 26-01-01 09:42: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.0040359497070312 -- 26-01-01 09:42: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.018812894821167 -- 26-01-01 09:42:07[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43161 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 = 43161 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033690929412842 -- 26-01-01 09:42:07[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43161 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003565788269043 -- 26-01-01 09:42:07[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43161 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5836112 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033998489379883 -- 26-01-01 09:42:07[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43161 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003385066986084 -- 26-01-01 09:42:07[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43161 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034248828887939 -- 26-01-01 09:42:07[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43161 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5836112 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034000873565674 -- 26-01-01 09:42:07[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43161 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017489194869995 -- 26-01-01 09:42: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.01619291305542 -- 26-01-01 09:42: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.018064022064209 -- 26-01-01 09:42: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.016608953475952 -- 26-01-01 09:42:08[刘晓进-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.015321016311646 -- 26-01-01 09:42: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.0030159950256348 -- 26-01-01 09:42: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.016655921936035 -- 26-01-01 09:42:10[刘晓进-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.0034170150756836 -- 26-01-01 09:42:10[刘晓进-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.0036139488220215 -- 26-01-01 09:42:10[刘晓进-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.0036129951477051 -- 26-01-01 09:42:10[刘晓进-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.0035688877105713 -- 26-01-01 09:42:10[刘晓进-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.020982980728149 -- 26-01-01 09:42:12[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43164 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 = 43164 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033671855926514 -- 26-01-01 09:42:12[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43164 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035319328308105 -- 26-01-01 09:42:12[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43164 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5836148 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033600330352783 -- 26-01-01 09:42:12[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43164 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033550262451172 -- 26-01-01 09:42:12[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43164 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033609867095947 -- 26-01-01 09:42:13[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43164 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5836148 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033729076385498 -- 26-01-01 09:42:13[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43164 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023604869842529 -- 26-01-01 09:42: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.017289876937866 -- 26-01-01 09:42: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.025142908096313 -- 26-01-01 09:42: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.016088962554932 -- 26-01-01 09:42: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.028815031051636 -- 26-01-01 09:42: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.0032298564910889 -- 26-01-01 09:42: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.023009061813354 -- 26-01-01 09:42:16[刘晓进-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.0037600994110107 -- 26-01-01 09:42:16[刘晓进-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.004065990447998 -- 26-01-01 09:42:16[刘晓进-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.0039739608764648 -- 26-01-01 09:42:16[刘晓进-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.003943920135498 -- 26-01-01 09:42:16[刘晓进-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.018585920333862 -- 26-01-01 09:42:19[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43164 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 = 43164 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034129619598389 -- 26-01-01 09:42:19[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43164 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034680366516113 -- 26-01-01 09:42:20[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43164 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5836148 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034489631652832 -- 26-01-01 09:42:20[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43164 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003436803817749 -- 26-01-01 09:42:20[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43164 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034420490264893 -- 26-01-01 09:42:20[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43164 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5836148 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003413200378418 -- 26-01-01 09:42:20[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43164 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018473863601685 -- 26-01-01 09:42:20[刘晓进-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.016423940658569 -- 26-01-01 09:42:20[刘晓进-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.016071081161499 -- 26-01-01 09:42:20[刘晓进-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.016705989837646 -- 26-01-01 09:42:20[刘晓进-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.016326189041138 -- 26-01-01 09:42:20[刘晓进-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.0031681060791016 -- 26-01-01 09:42:20[刘晓进-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.018354892730713 -- 26-01-01 09:42:24[刘晓进-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.0040700435638428 -- 26-01-01 09:42:24[刘晓进-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.0035560131072998 -- 26-01-01 09:42:24[刘晓进-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.0038950443267822 -- 26-01-01 09:42:24[刘晓进-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.0038800239562988 -- 26-01-01 09:42:24[刘晓进-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.019516944885254 -- 26-01-01 09:42:27[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43171 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 = 43171 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035350322723389 -- 26-01-01 09:42:27[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43171 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043308734893799 -- 26-01-01 09:42:27[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43171 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5836363 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035190582275391 -- 26-01-01 09:42:27[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43171 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035278797149658 -- 26-01-01 09:42:27[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43171 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035579204559326 -- 26-01-01 09:42:27[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43171 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5836363 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034971237182617 -- 26-01-01 09:42:27[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43171 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023113012313843 -- 26-01-01 09:42:27[刘晓进-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.017224073410034 -- 26-01-01 09:42:27[刘晓进-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.021261930465698 -- 26-01-01 09:42:27[刘晓进-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.015859127044678 -- 26-01-01 09:42:27[刘晓进-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.02590799331665 -- 26-01-01 09:42:27[刘晓进-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.0032198429107666 -- 26-01-01 09:42:27[刘晓进-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.018687009811401 -- 26-01-01 09:42:31[刘晓进-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.0038847923278809 -- 26-01-01 09:42:31[刘晓进-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.0036671161651611 -- 26-01-01 09:42:31[刘晓进-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.0036990642547607 -- 26-01-01 09:42:31[刘晓进-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.0036859512329102 -- 26-01-01 09:42:31[刘晓进-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.020110130310059 -- 26-01-01 09:57:41[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1682912&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select o.org_id,o.org_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032899379730225 -- 26-01-01 09:57:41[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1682912&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031669139862061 -- 26-01-01 09:57:41[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1682912&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033929347991943 -- 26-01-01 09:57:41[梁汉东-1251] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1682912&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D208%26ship_city%3D%E6%9D%AD%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 SELECT o.order_id,o.order_no,a.area_name dest_city,o.acct_id, o.pieces,o.weight,o.volume,o.calc_weight FROM dbthird.thd_order o LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE o.order_id in (1682912) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020823001861572 -- 26-01-01 09:57:41[梁汉东-1251] -- /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 =15 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017960071563721 -- 26-01-01 09:57:41[梁汉东-1251] -- /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 = 15 and cont.cont_isenable = 1 AND cont.cont_name like '%梁汉东%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016790151596069 -- 26-01-01 09:57:42[梁汉东-1251] -- /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 = 15 AND o.org_name like '%杭州办事处%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020662069320679 -- 26-01-01 09:57:47[梁汉东-1251] -- /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 =15 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%杭州%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018613815307617 -- 26-01-01 09:58:13[梁汉东-1251] -- /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 = 15 AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01905083656311 -- 26-01-01 10:04:01 -- /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.0032789707183838 -- 26-01-01 10:04:01 -- /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.0043740272521973 -- 26-01-01 10:04:01 -- /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='FeiFei' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035610198974609 -- 26-01-01 10:04:01[肖飞飞-477] -- /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= 15 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027995824813843 -- 26-01-01 10:04:01[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017229795455933 -- 26-01-01 10:04:10[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243257%22}&event=edit_fareApply&fareApply_id=43257 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 = 43257 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038669109344482 -- 26-01-01 10:04:10[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243257%22}&event=edit_fareApply&fareApply_id=43257 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 43257 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0055379867553711 -- 26-01-01 10:04:10[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243257%22}&event=edit_fareApply&fareApply_id=43257 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 = 5850569 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032069683074951 -- 26-01-01 10:04:10[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243257%22}&event=edit_fareApply&fareApply_id=43257 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003385066986084 -- 26-01-01 10:04:10[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243257%22}&event=edit_fareApply&fareApply_id=43257 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5850569 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032060146331787 -- 26-01-01 10:04:10[肖飞飞-477] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2243257%22}&event=edit_fareApply&fareApply_id=43257 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 477 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0158371925354 -- 26-01-01 10:06:54[袁群英-668] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 668 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016232013702393 -- 26-01-01 10:06:54[袁群英-668] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 668 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016384124755859 -- 26-01-01 10:06:56[袁群英-668] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 668 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017972230911255 -- 26-01-01 10:53:47 -- /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.003493070602417 -- 26-01-01 10:53:47 -- /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.0044369697570801 -- 26-01-01 10:53:47 -- /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='encho' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038309097290039 -- 26-01-01 10:53:47[飞力士物流管理员-476] -- /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= 15 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026786088943481 -- 26-01-01 10:53:48[飞力士物流管理员-476] -- /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 = 476 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049839019775391 -- 26-01-01 10:53:48[飞力士物流管理员-476] -- /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 = 476 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040459632873535 -- 26-01-01 10:53:48[飞力士物流管理员-476] -- /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 = 476 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045039653778076 -- 26-01-01 10:53:48[飞力士物流管理员-476] -- /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 = 476 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044770240783691 -- 26-01-01 10:53:48[飞力士物流管理员-476] -- /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= 476 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023010015487671 -- 26-01-01 10:53:51[飞力士物流管理员-476] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 476 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016274929046631 -- 26-01-01 10:53:56[飞力士物流管理员-476] -- /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 = 476 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032529830932617 -- 26-01-01 10:53:56[飞力士物流管理员-476] -- /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 = 476 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032470226287842 -- 26-01-01 10:53:56[飞力士物流管理员-476] -- /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 = 476 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032289028167725 -- 26-01-01 10:53:56[飞力士物流管理员-476] -- /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 = 476 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032479763031006 -- 26-01-01 10:53:56[飞力士物流管理员-476] -- /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= 476 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017721891403198 -- 26-01-01 10:53:58[飞力士物流管理员-476] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply select o.org_id,o.org_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 476 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035359859466553 -- 26-01-01 10:53:58[飞力士物流管理员-476] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034217834472656 -- 26-01-01 10:53:58[飞力士物流管理员-476] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 476 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024338006973267 -- 26-01-01 10:53:58[飞力士物流管理员-476] -- /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 =15 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016294956207275 -- 26-01-01 10:53:58[飞力士物流管理员-476] -- /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 = 15 and cont.cont_isenable = 1 AND cont.cont_name like '%飞力士物流管理员%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016541957855225 -- 26-01-01 10:53:58[飞力士物流管理员-476] -- /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 = 15 AND o.org_name like '%飞力士物流%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018846988677979 -- 26-01-01 12:58:09[杨林-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.016520977020264 -- 26-01-01 12:58: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.0032060146331787 -- 26-01-01 12:58: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.0050990581512451 -- 26-01-01 12:58: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 = 70244 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016474008560181 -- 26-01-01 12:59:24[杨林-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.003248929977417 -- 26-01-01 12:59:24[杨林-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.0049149990081787 -- 26-01-01 12:59:24[杨林-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 = 70244 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047869682312012 -- 26-01-01 12:59:24[杨林-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 = 2338 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016242980957031 -- 26-01-01 12:59:31[杨林-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.0031850337982178 -- 26-01-01 12:59:31[杨林-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.026270866394043 -- 26-01-01 12:59:33[杨林-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.0032639503479004 -- 26-01-01 12:59:33[杨林-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.0046041011810303 -- 26-01-01 12:59:33[杨林-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 = 70244 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051259994506836 -- 26-01-01 12:59:33[杨林-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 = 2338 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023254871368408 -- 26-01-01 12:59:34[杨林-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.025475025177002 -- 26-01-01 13:01:43[杨林-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.017258882522583 -- 26-01-01 13:02:01[杨林-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.0033531188964844 -- 26-01-01 13:02:01[杨林-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.0048401355743408 -- 26-01-01 13:02:01[杨林-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 = 70245 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017204999923706 -- 26-01-01 13:04:32[杨林-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.0033628940582275 -- 26-01-01 13:04:32[杨林-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.015810012817383 -- 26-01-01 13:04:35[杨林-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.0031118392944336 -- 26-01-01 13:04:35[杨林-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.0049209594726562 -- 26-01-01 13:04:35[杨林-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 = 70245 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046648979187012 -- 26-01-01 13:04:35[杨林-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 = 2339 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015347003936768 -- 26-01-01 13:04:35[杨林-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.016258001327515 -- 26-01-01 13:13:55[杨林-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.017481803894043 -- 26-01-01 13:14:05[杨林-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.0034358501434326 -- 26-01-01 13:14:05[杨林-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.0050699710845947 -- 26-01-01 13:14:05[杨林-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 = 70246 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027711153030396 -- 26-01-01 13:15:50[杨林-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.0031640529632568 -- 26-01-01 13:15:50[杨林-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.016244173049927 -- 26-01-01 13:15:52[杨林-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.0032119750976562 -- 26-01-01 13:15:52[杨林-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.0047922134399414 -- 26-01-01 13:15:52[杨林-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 = 70246 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048081874847412 -- 26-01-01 13:15:52[杨林-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 = 2340 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016680955886841 -- 26-01-01 13:15:52[杨林-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.016928911209106 -- 26-01-01 13:36:59[文滔-2463] -- /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 = 2463 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033199787139893 -- 26-01-01 13:37:00[文滔-2463] -- /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 = 2463 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047338008880615 -- 26-01-01 13:37:00[文滔-2463] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2463,updatedby_id = 2463 where extrafareApply_id = 70247 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016880035400391 -- 26-01-01 13:38:08[文滔-2463] -- /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.015900850296021 -- 26-01-01 13:38:32[文滔-2463] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2463 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030949115753174 -- 26-01-01 13:38:32[文滔-2463] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2463 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015697956085205 -- 26-01-01 13:38:43[文滔-2463] -- /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 = 2463 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030930042266846 -- 26-01-01 13:38:43[文滔-2463] -- /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 = 2463 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045230388641357 -- 26-01-01 13:38:43[文滔-2463] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2463,updatedby_id = 2463 where extrafareApply_id = 70247 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046150684356689 -- 26-01-01 13:38:43[文滔-2463] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2463,updatedby_id = 2463 where otherfee_id = 2341 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019486904144287 -- 26-01-01 13:38:43[文滔-2463] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2463 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016745090484619 -- 26-01-01 13:47:04[李云阳-2411] -- /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 = 2411 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032808780670166 -- 26-01-01 13:47:04[李云阳-2411] -- /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 = 2411 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004706859588623 -- 26-01-01 13:47:04[李云阳-2411] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2411,updatedby_id = 2411 where extrafareApply_id = 70248 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018381118774414 -- 26-01-01 13:47:10[李云阳-2411] -- /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.016180038452148 -- 26-01-01 13:47:24[李云阳-2411] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2411 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031580924987793 -- 26-01-01 13:47:24[李云阳-2411] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2411 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028384208679199 -- 26-01-01 13:49:32[李云阳-2411] -- /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 = 2411 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035359859466553 -- 26-01-01 13:49:32[李云阳-2411] -- /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 = 2411 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016016960144043 -- 26-01-01 13:49:32[李云阳-2411] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2411 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026226997375488 -- 26-01-01 17:12:34[符金辉-380] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 380 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016816139221191 -- 26-01-01 17:12:34[符金辉-380] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 380 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015066146850586 -- 26-01-01 17:12:36[符金辉-380] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 380 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016915082931519 -- 26-01-01 17:12:41[符金辉-380] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 380 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016817092895508 -- 26-01-01 17:12:41[符金辉-380] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 380 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015966176986694 -- 26-01-01 17:12:43[符金辉-380] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 380 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017070770263672 -- 26-01-01 17:14:32[符金辉-380] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 380 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016870021820068 -- 26-01-01 17:14:32[符金辉-380] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 380 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028949022293091 -- 26-01-01 17:14:34[符金辉-380] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 380 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025022029876709 -- 26-01-01 17:49:53[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016064882278442 -- 26-01-01 17:49:54[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016525030136108 -- 26-01-01 17:49:57[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018837928771973 -- 26-01-01 17:50:12[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1704420&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D352%26ship_city%3D%E9%83%91%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select o.org_id,o.org_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037190914154053 -- 26-01-01 17:50:12[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1704420&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D352%26ship_city%3D%E9%83%91%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select org_id,org_name from dbsys.sys_org where corp_acct_id = 15 and is_corporate = 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036759376525879 -- 26-01-01 17:50:12[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1704420&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D352%26ship_city%3D%E9%83%91%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038089752197266 -- 26-01-01 17:50:12[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1704420&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D352%26ship_city%3D%E9%83%91%E5%B7%9E%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 SELECT o.order_id,o.order_no,a.area_name dest_city,o.acct_id, o.pieces,o.weight,o.volume,o.calc_weight FROM dbthird.thd_order o LEFT JOIN dbsys.sys_area a ON o.dest_city_id = a.area_id WHERE o.order_id in (1704420) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.033136129379272 -- 26-01-01 17:50:12[秦学习-南京办-1240] -- /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 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016796112060547 -- 26-01-01 17:50:12[秦学习-南京办-1240] -- /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.018647909164429 -- 26-01-01 17:50:12[秦学习-南京办-1240] -- /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.020371913909912 -- 26-01-01 17:50:22[秦学习-南京办-1240] -- /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.018817901611328 -- 26-01-01 17:50:32[秦学习-南京办-1240] -- /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.016108989715576 -- 26-01-01 17:50:56[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003180980682373 -- 26-01-01 17:50:56[秦学习-南京办-1240] -- /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 = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032680034637451 -- 26-01-01 17:50:57[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select group_concat(order_no) order_no_str from dbthird.thd_order where order_id in (1704420) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031371116638184 -- 26-01-01 17:50:57[秦学习-南京办-1240] -- /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 = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049970149993896 -- 26-01-01 17:50:57[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 1240,updatedby_id = 1240 where extrafareApply_id = 70253 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004472017288208 -- 26-01-01 17:50:57[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 1240,updatedby_id = 1240 where otherfee_id = 71086 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028366088867188 -- 26-01-01 17:51:06[秦学习-南京办-1240] -- /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 = 15 and e.extrafare_name like '%中建材%' limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026214122772217 -- 26-01-01 19:02:05[李晓涛-2495] -- /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 = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003126859664917 -- 26-01-01 19:02:05[李晓涛-2495] -- /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 = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050499439239502 -- 26-01-01 19:02:05[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2495,updatedby_id = 2495 where extrafareApply_id = 70256 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017478942871094 -- 26-01-01 19:06:07[李晓涛-2495] -- /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 '%350%' limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017695903778076 -- 26-01-01 19:07:11[李晓涛-2495] -- /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 = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003450870513916 -- 26-01-01 19:07:12[李晓涛-2495] -- /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 = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052149295806885 -- 26-01-01 19:07:12[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2495,updatedby_id = 2495 where extrafareApply_id = 70256 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051319599151611 -- 26-01-01 19:07:12[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2495,updatedby_id = 2495 where otherfee_id = 2355 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018218994140625 -- 26-01-01 19:07:30[李晓涛-2495] -- /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.025792121887207 -- 26-01-01 19:07:35[李晓涛-2495] -- /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 = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031578540802002 -- 26-01-01 19:07:36[李晓涛-2495] -- /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 = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048739910125732 -- 26-01-01 19:07:36[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2495,updatedby_id = 2495 where extrafareApply_id = 70256 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048949718475342 -- 26-01-01 19:07:36[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2495,updatedby_id = 2495 where otherfee_id = 2355 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016552925109863 -- 26-01-01 19:08:19[李晓涛-2495] -- /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 = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029988288879395 -- 26-01-01 19:08:19[李晓涛-2495] -- /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 = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045039653778076 -- 26-01-01 19:08:19[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2495,updatedby_id = 2495 where extrafareApply_id = 70256 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044920444488525 -- 26-01-01 19:08:19[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2495,updatedby_id = 2495 where otherfee_id = 2355 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016499042510986 -- 26-01-01 19:09:14[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031960010528564 -- 26-01-01 19:09:14[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020867824554443 -- 26-01-01 19:09:18[李晓涛-2495] -- /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 = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003148078918457 -- 26-01-01 19:09:18[李晓涛-2495] -- /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 = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004986047744751 -- 26-01-01 19:09:18[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2495,updatedby_id = 2495 where extrafareApply_id = 70256 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047450065612793 -- 26-01-01 19:09:18[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2495,updatedby_id = 2495 where otherfee_id = 2355 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016601085662842 -- 26-01-01 19:09:18[李晓涛-2495] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016819000244141 -- 26-01-01 19:12:18[李晓涛-2495] -- /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 = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033040046691895 -- 26-01-01 19:12:18[李晓涛-2495] -- /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 = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047070980072021 -- 26-01-01 19:12:18[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2495,updatedby_id = 2495 where extrafareApply_id = 70257 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017030954360962 -- 26-01-01 19:14:04[李晓涛-2495] -- /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.015650033950806 -- 26-01-01 19:14:51[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031449794769287 -- 26-01-01 19:14:51[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016528129577637 -- 26-01-01 19:14:57[李晓涛-2495] -- /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 = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032269954681396 -- 26-01-01 19:14:58[李晓涛-2495] -- /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 = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045990943908691 -- 26-01-01 19:14:58[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2495,updatedby_id = 2495 where extrafareApply_id = 70257 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047459602355957 -- 26-01-01 19:14:58[李晓涛-2495] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2495,updatedby_id = 2495 where otherfee_id = 2356 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017151117324829 -- 26-01-01 19:14:58[李晓涛-2495] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2495 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017575979232788 -- 26-01-01 19:51:35[田国庆-2525] -- /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.028403997421265 -- 26-01-01 19:53:53[田国庆-2525] -- /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 = 2525 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00313401222229 -- 26-01-01 19:53:53[田国庆-2525] -- /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 = 2525 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052890777587891 -- 26-01-01 19:53:53[田国庆-2525] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2525,updatedby_id = 2525 where extrafareApply_id = 70258 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016474962234497 -- 26-01-01 19:53:59[田国庆-2525] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2525 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032279491424561 -- 26-01-01 19:53:59[田国庆-2525] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2525 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016017913818359 -- 26-01-01 19:54:12[田国庆-2525] -- /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 = 2525 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031349658966064 -- 26-01-01 19:54:12[田国庆-2525] -- /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 = 2525 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044221878051758 -- 26-01-01 19:54:12[田国庆-2525] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2525,updatedby_id = 2525 where extrafareApply_id = 70258 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045199394226074 -- 26-01-01 19:54:12[田国庆-2525] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2525,updatedby_id = 2525 where otherfee_id = 2357 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016252040863037 -- 26-01-01 19:54:26[田国庆-2525] -- /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 = 2525 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031628608703613 -- 26-01-01 19:54:26[田国庆-2525] -- /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 = 2525 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044600963592529 -- 26-01-01 19:54:26[田国庆-2525] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2525,updatedby_id = 2525 where extrafareApply_id = 70258 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045690536499023 -- 26-01-01 19:54:26[田国庆-2525] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2525,updatedby_id = 2525 where otherfee_id = 2357 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027732133865356 -- 26-01-01 19:54:35[田国庆-2525] -- /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 = 2525 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031900405883789 -- 26-01-01 19:54:36[田国庆-2525] -- /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 = 2525 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046679973602295 -- 26-01-01 19:54:36[田国庆-2525] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2525,updatedby_id = 2525 where extrafareApply_id = 70258 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043060779571533 -- 26-01-01 19:54:36[田国庆-2525] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2525,updatedby_id = 2525 where otherfee_id = 2357 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017287015914917 -- 26-01-01 19:54:50[田国庆-2525] -- /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 = 2525 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033969879150391 -- 26-01-01 19:54:50[田国庆-2525] -- /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 = 2525 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047039985656738 -- 26-01-01 19:54:50[田国庆-2525] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2525,updatedby_id = 2525 where extrafareApply_id = 70258 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044848918914795 -- 26-01-01 19:54:50[田国庆-2525] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2525,updatedby_id = 2525 where otherfee_id = 2357 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017146110534668 -- 26-01-01 19:55:01[田国庆-2525] -- /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 = 2525 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033531188964844 -- 26-01-01 19:55:01[田国庆-2525] -- /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 = 2525 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046310424804688 -- 26-01-01 19:55:01[田国庆-2525] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2525,updatedby_id = 2525 where extrafareApply_id = 70258 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045249462127686 -- 26-01-01 19:55:01[田国庆-2525] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2525,updatedby_id = 2525 where otherfee_id = 2357 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017564058303833 -- 26-01-01 19:55:12[田国庆-2525] -- /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 = 2525 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034530162811279 -- 26-01-01 19:55:12[田国庆-2525] -- /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 = 2525 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050151348114014 -- 26-01-01 19:55:12[田国庆-2525] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2525,updatedby_id = 2525 where extrafareApply_id = 70258 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046060085296631 -- 26-01-01 19:55:12[田国庆-2525] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2525,updatedby_id = 2525 where otherfee_id = 2357 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017086982727051 -- 26-01-01 19:55:12[田国庆-2525] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2525 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027806997299194 -- 26-01-01 23:08:01 -- /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.0032551288604736 -- 26-01-01 23:08:01 -- /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.0038480758666992 -- 26-01-01 23:08:01 -- /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.003446102142334 -- 26-01-01 23:08:01[刘晓进-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.034542083740234 -- 26-01-01 23:08:01[刘晓进-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.0043179988861084 -- 26-01-01 23:08:01[刘晓进-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.0034918785095215 -- 26-01-01 23:08:01[刘晓进-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.0039629936218262 -- 26-01-01 23:08:01[刘晓进-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.0039517879486084 -- 26-01-01 23:08:01[刘晓进-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.01782488822937 -- 26-01-01 23:08:05[刘晓进-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.003371000289917 -- 26-01-01 23:08:05[刘晓进-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.0035150051116943 -- 26-01-01 23:08:05[刘晓进-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.003270149230957 -- 26-01-01 23:08:05[刘晓进-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.0032660961151123 -- 26-01-01 23:08:05[刘晓进-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.0033280849456787 -- 26-01-01 23:08:05[刘晓进-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.0032939910888672 -- 26-01-01 23:08:05[刘晓进-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.018115997314453 -- 26-01-01 23:08:06[刘晓进-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.016350984573364 -- 26-01-01 23:08:06[刘晓进-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.024626970291138 -- 26-01-01 23:08:06[刘晓进-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.017387866973877 -- 26-01-01 23:08:06[刘晓进-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.019490957260132 -- 26-01-01 23:08:06[刘晓进-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.0033121109008789 -- 26-01-01 23:08:06[刘晓进-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.017558097839355 -- 26-01-01 23:08: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.0039408206939697 -- 26-01-01 23:08: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.0034070014953613 -- 26-01-01 23:08: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.0037729740142822 -- 26-01-01 23:08: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.0037631988525391 -- 26-01-01 23:08: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.019056081771851 -- 26-01-01 23:08:14[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 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 = 43216 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033679008483887 -- 26-01-01 23:08:14[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035109519958496 -- 26-01-01 23:08:14[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5844242 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033609867095947 -- 26-01-01 23:08:14[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033299922943115 -- 26-01-01 23:08:14[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003371000289917 -- 26-01-01 23:08:14[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5844242 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033330917358398 -- 26-01-01 23:08:14[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43216 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017255067825317 -- 26-01-01 23:08:15[刘晓进-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.026816129684448 -- 26-01-01 23:08:15[刘晓进-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.015433073043823 -- 26-01-01 23:08:15[刘晓进-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.016306161880493 -- 26-01-01 23:08:15[刘晓进-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.01633882522583 -- 26-01-01 23:08:15[刘晓进-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.003154993057251 -- 26-01-01 23:08:15[刘晓进-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.016726970672607 -- 26-01-01 23:08:22[刘晓进-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.0040090084075928 -- 26-01-01 23:08:22[刘晓进-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.0033528804779053 -- 26-01-01 23:08:22[刘晓进-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.0037429332733154 -- 26-01-01 23:08:22[刘晓进-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.0037338733673096 -- 26-01-01 23:08:22[刘晓进-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.026642084121704 -- 26-01-01 23:08:25[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43164 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 = 43164 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031881332397461 -- 26-01-01 23:08:25[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43164 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033900737762451 -- 26-01-01 23:08:25[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43164 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5836148 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003176212310791 -- 26-01-01 23:08:25[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43164 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031449794769287 -- 26-01-01 23:08:25[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43164 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003197193145752 -- 26-01-01 23:08:25[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43164 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5836148 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031490325927734 -- 26-01-01 23:08:25[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43164 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024649858474731 -- 26-01-01 23:08:26[刘晓进-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.020064830780029 -- 26-01-01 23:08:26[刘晓进-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.017966032028198 -- 26-01-01 23:08:26[刘晓进-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.015850067138672 -- 26-01-01 23:08:26[刘晓进-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.015821933746338 -- 26-01-01 23:08:26[刘晓进-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.0030689239501953 -- 26-01-01 23:08:26[刘晓进-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.022349119186401 -- 26-01-01 23:08:31[刘晓进-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.0038418769836426 -- 26-01-01 23:08:31[刘晓进-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.0036530494689941 -- 26-01-01 23:08:31[刘晓进-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.0036861896514893 -- 26-01-01 23:08:31[刘晓进-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.0036969184875488 -- 26-01-01 23:08:31[刘晓进-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.016852140426636 -- 26-01-01 23:08:34[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43170 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 = 43170 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029377937316895 -- 26-01-01 23:08:34[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43170 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035879611968994 -- 26-01-01 23:08:34[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43170 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5836272 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028848648071289 -- 26-01-01 23:08:34[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43170 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029041767120361 -- 26-01-01 23:08:34[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43170 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029208660125732 -- 26-01-01 23:08:34[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43170 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5836272 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028891563415527 -- 26-01-01 23:08:34[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=43170 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017225027084351 -- 26-01-01 23:08:35[刘晓进-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.027904987335205 -- 26-01-01 23:08:35[刘晓进-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.017699956893921 -- 26-01-01 23:08:35[刘晓进-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.016454935073853 -- 26-01-01 23:08:35[刘晓进-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.024560928344727 -- 26-01-01 23:08:35[刘晓进-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.0032200813293457 -- 26-01-01 23:08:35[刘晓进-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.016814947128296 -- 26-01-01 23:08:37[刘晓进-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.003486156463623 -- 26-01-01 23:08:37[刘晓进-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.0037741661071777 -- 26-01-01 23:08:37[刘晓进-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.0037200450897217 -- 26-01-01 23:08:37[刘晓进-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.0038089752197266 -- 26-01-01 23:08:37[刘晓进-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.017745018005371 -- 26-01-01 23:37:25[刘晓进-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.017115116119385 -- 26-01-01 23:37:33[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70255 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70255 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037658214569092 -- 26-01-01 23:37:33[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70255 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 = 70255 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003777027130127 -- 26-01-01 23:37:33[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70255 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70255 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0054531097412109 -- 26-01-01 23:37:33[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70255 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 = 70255 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031371116638184 -- 26-01-01 23:37:33[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70255 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031828880310059 -- 26-01-01 23:37:33[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70255 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033700466156006 -- 26-01-01 23:37:33[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70255 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5858118 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031318664550781 -- 26-01-01 23:37:33[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70255 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017559051513672 -- 26-01-01 23:37:43[刘晓进-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.017184972763062 -- 26-01-01 23:37:44[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70255 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70255 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038049221038818 -- 26-01-01 23:37:44[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70255 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 = 70255 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036780834197998 -- 26-01-01 23:37:44[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70255 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70255 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050249099731445 -- 26-01-01 23:37:44[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70255 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 = 70255 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032670497894287 -- 26-01-01 23:37:44[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70255 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032601356506348 -- 26-01-01 23:37:44[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70255 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034189224243164 -- 26-01-01 23:37:44[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70255 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5858118 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032408237457275 -- 26-01-01 23:37:44[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70255 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017753124237061 -- 26-01-01 23:37:46[刘晓进-2544] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70255 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016232013702393 -- 26-01-01 23:37:47[刘晓进-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.018132925033569 -- 26-01-01 23:37:48[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70254 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70254 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003425121307373 -- 26-01-01 23:37:48[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70254 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 = 70254 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036869049072266 -- 26-01-01 23:37:48[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70254 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70254 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051498413085938 -- 26-01-01 23:37:48[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70254 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 = 70254 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032060146331787 -- 26-01-01 23:37:48[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70254 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032069683074951 -- 26-01-01 23:37:48[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70254 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003371000289917 -- 26-01-01 23:37:48[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70254 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5858100 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031940937042236 -- 26-01-01 23:37:48[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70254 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017468929290771 -- 26-01-01 23:37:51[刘晓进-2544] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70254 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017292976379395 -- 26-01-01 23:37:51[刘晓进-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.015594005584717 -- 26-01-01 23:37:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70252 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70252 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003180980682373 -- 26-01-01 23:37:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70252 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 = 70252 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031261444091797 -- 26-01-01 23:37:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70252 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70252 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032780170440674 -- 26-01-01 23:37:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70252 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 = 70252 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002979040145874 -- 26-01-01 23:37:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70252 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029878616333008 -- 26-01-01 23:37:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70252 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031638145446777 -- 26-01-01 23:37:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70252 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5857902 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029940605163574 -- 26-01-01 23:37:52[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70252 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028825044631958 -- 26-01-01 23:37:54[刘晓进-2544] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70252 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017722129821777 -- 26-01-01 23:37:55[刘晓进-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.017981052398682 -- 26-01-01 23:37:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70251 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70251 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036108493804932 -- 26-01-01 23:37:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70251 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 = 70251 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038368701934814 -- 26-01-01 23:37:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70251 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70251 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.005173921585083 -- 26-01-01 23:37:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70251 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 = 70251 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033888816833496 -- 26-01-01 23:37:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70251 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033960342407227 -- 26-01-01 23:37:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70251 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035429000854492 -- 26-01-01 23:37:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70251 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5857899 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033679008483887 -- 26-01-01 23:37:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70251 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0173659324646 -- 26-01-01 23:38:00[刘晓进-2544] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70251 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015068769454956 -- 26-01-01 23:38:00[刘晓进-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.021843194961548 -- 26-01-01 23:38:01[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70250 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70250 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038900375366211 -- 26-01-01 23:38:01[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70250 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 = 70250 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036959648132324 -- 26-01-01 23:38:01[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70250 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70250 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045449733734131 -- 26-01-01 23:38:01[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70250 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 = 70250 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032219886779785 -- 26-01-01 23:38:01[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70250 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032451152801514 -- 26-01-01 23:38:01[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70250 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033810138702393 -- 26-01-01 23:38:01[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70250 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5857898 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032260417938232 -- 26-01-01 23:38:01[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70250 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016005039215088 -- 26-01-01 23:38:08[刘晓进-2544] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70250 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01862096786499 -- 26-01-01 23:38:09[刘晓进-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.017052888870239 -- 26-01-01 23:38:10[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70249 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70249 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034949779510498 -- 26-01-01 23:38:10[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70249 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 = 70249 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033988952636719 -- 26-01-01 23:38:10[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70249 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70249 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035789012908936 -- 26-01-01 23:38:10[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70249 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 = 70249 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032768249511719 -- 26-01-01 23:38:10[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70249 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032739639282227 -- 26-01-01 23:38:10[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70249 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034480094909668 -- 26-01-01 23:38:10[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70249 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5857896 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033040046691895 -- 26-01-01 23:38:10[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70249 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017297983169556 -- 26-01-01 23:38:27[刘晓进-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.01789402961731 -- 26-01-01 23:38:27[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70249 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70249 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035099983215332 -- 26-01-01 23:38:27[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70249 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 = 70249 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034818649291992 -- 26-01-01 23:38:27[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70249 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70249 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035150051116943 -- 26-01-01 23:38:27[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70249 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 = 70249 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034689903259277 -- 26-01-01 23:38:27[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70249 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035021305084229 -- 26-01-01 23:38:27[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70249 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035250186920166 -- 26-01-01 23:38:28[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70249 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5857896 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034821033477783 -- 26-01-01 23:38:28[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70249 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02668309211731 -- 26-01-01 23:38:29[刘晓进-2544] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=70249 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016304969787598 -- 26-01-01 23:38:29[刘晓进-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.016686916351318 -- 26-01-01 23:38:31[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70249 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 70249 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032498836517334 -- 26-01-01 23:38:31[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70249 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 = 70249 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032730102539062 -- 26-01-01 23:38:32[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70249 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 70249 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032598972320557 -- 26-01-01 23:38:32[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70249 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 = 70249 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00323486328125 -- 26-01-01 23:38:32[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70249 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032379627227783 -- 26-01-01 23:38:32[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70249 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032739639282227 -- 26-01-01 23:38:32[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70249 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5857896 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032148361206055 -- 26-01-01 23:38:32[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=70249 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01543402671814 -- 26-01-01 23:38:39[刘晓进-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.0032439231872559 -- 26-01-01 23:38:39[刘晓进-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.0030829906463623 -- 26-01-01 23:38:39[刘晓进-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.0031938552856445 -- 26-01-01 23:38:39[刘晓进-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.003101110458374 -- 26-01-01 23:38:39[刘晓进-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.028491973876953 -- 26-01-01 23:38:44[刘晓进-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 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039598941802979 -- 26-01-01 23:38:44[刘晓进-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 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037128925323486 -- 26-01-01 23:38:44[刘晓进-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 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036821365356445 -- 26-01-01 23:38:44[刘晓进-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 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037550926208496 -- 26-01-01 23:38:44[刘晓进-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 30 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017619848251343 -- 26-01-01 23:38:55[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42783 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 = 42783 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033659934997559 -- 26-01-01 23:38:55[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42783 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035531520843506 -- 26-01-01 23:38:55[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42783 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5788512 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033519268035889 -- 26-01-01 23:38:55[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42783 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033390522003174 -- 26-01-01 23:38:55[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42783 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00337815284729 -- 26-01-01 23:38:55[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42783 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5788512 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033419132232666 -- 26-01-01 23:38:55[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42783 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016793012619019 -- 26-01-01 23:38:55[刘晓进-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.016016960144043 -- 26-01-01 23:38:55[刘晓进-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.016540050506592 -- 26-01-01 23:38:55[刘晓进-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.016180992126465 -- 26-01-01 23:38:55[刘晓进-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.016052007675171 -- 26-01-01 23:38:55[刘晓进-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.0033049583435059 -- 26-01-01 23:38:55[刘晓进-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.0174400806427 -- 26-01-01 23:38:58[刘晓进-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 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038950443267822 -- 26-01-01 23:38:58[刘晓进-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 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039811134338379 -- 26-01-01 23:38:58[刘晓进-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 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039200782775879 -- 26-01-01 23:38:58[刘晓进-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 30 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038838386535645 -- 26-01-01 23:38:58[刘晓进-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 30 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016875982284546 -- 26-01-01 23:39:08[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42785 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 = 42785 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031759738922119 -- 26-01-01 23:39:08[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42785 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033571720123291 -- 26-01-01 23:39:08[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42785 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5788715 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031819343566895 -- 26-01-01 23:39:08[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42785 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031840801239014 -- 26-01-01 23:39:08[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42785 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032110214233398 -- 26-01-01 23:39:08[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42785 select file_id,file_url,file_ext,thumb_file_url,file_type_id from dbpublic.pbl_upload_file where owner_id=5788715 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003162145614624 -- 26-01-01 23:39:08[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=42785 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016237020492554 -- 26-01-01 23:39:08[刘晓进-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.027927160263062 -- 26-01-01 23:39:09[刘晓进-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.017438173294067 -- 26-01-01 23:39:09[刘晓进-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.015841007232666 -- 26-01-01 23:39:09[刘晓进-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.020067930221558 -- 26-01-01 23:39:09[刘晓进-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.0032329559326172 -- 26-01-01 23:39:09[刘晓进-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.021939039230347 -- 26-01-01 23:39:13[刘晓进-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.0038630962371826 -- 26-01-01 23:39:13[刘晓进-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.0037398338317871 -- 26-01-01 23:39:14[刘晓进-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.0036919116973877 -- 26-01-01 23:39:14[刘晓进-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.0036919116973877 -- 26-01-01 23:39:14[刘晓进-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() ) ------------------------------------------------------------------------------------------------------------------------------------------------------