Time: 0.015707015991211 -- 25-11-23 07:28:18 -- /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.003169059753418 -- 25-11-23 07:28:18 -- /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.0036699771881104 -- 25-11-23 07:28:18 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='DengDa' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00335693359375 -- 25-11-23 07:28:18[邓炟-1787] -- /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= 35 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016967058181763 -- 25-11-23 07:28:20[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017691850662231 -- 25-11-23 07:28:22[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111818 SELECT p.*,c.cont_name apply_cont,o.org_name department,13 appr_type_id FROM dboa.oa_payment p LEFT JOIN dbsys.sys_contact c on p.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON p.department_id = o.org_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id WHERE payment_id = 111818 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038959980010986 -- 25-11-23 07:28:22[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111818 select payment_id from dbthird.thd_payment where oa_payment_id = 111818 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047390460968018 -- 25-11-23 07:28:22[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111818 SELECT s.*,cust.cust_name carrier FROM dbthird.thd_statement s LEFT JOIN dbthird.thd_customer cust ON cust.customer_id = s.customer_id WHERE s.payment_id = 129806 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047769546508789 -- 25-11-23 07:28:22[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111818 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 = 5612464 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032761096954346 -- 25-11-23 07:28:22[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111818 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034639835357666 -- 25-11-23 07:28:22[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111818 select * from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034260749816895 -- 25-11-23 07:28:22[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111818 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 5612464 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032491683959961 -- 25-11-23 07:28:22[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111818 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032320022583008 -- 25-11-23 07:28:22[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111818 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033218860626221 -- 25-11-23 07:28:22[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111818 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.036089897155762 -- 25-11-23 07:28:23[邓炟-1787] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=111818 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0209641456604 -- 25-11-23 07:28:24[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031750917434692 -- 25-11-23 07:28:24[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111817 SELECT p.*,c.cont_name apply_cont,o.org_name department,13 appr_type_id FROM dboa.oa_payment p LEFT JOIN dbsys.sys_contact c on p.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON p.department_id = o.org_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id WHERE payment_id = 111817 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042691230773926 -- 25-11-23 07:28:24[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111817 select payment_id from dbthird.thd_payment where oa_payment_id = 111817 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043148994445801 -- 25-11-23 07:28:24[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111817 SELECT s.*,cust.cust_name carrier FROM dbthird.thd_statement s LEFT JOIN dbthird.thd_customer cust ON cust.customer_id = s.customer_id WHERE s.payment_id = 129805 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043048858642578 -- 25-11-23 07:28:24[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111817 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 = 5612274 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038089752197266 -- 25-11-23 07:28:24[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111817 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038471221923828 -- 25-11-23 07:28:24[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111817 select * from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040578842163086 -- 25-11-23 07:28:24[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111817 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 5612274 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037980079650879 -- 25-11-23 07:28:24[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111817 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037899017333984 -- 25-11-23 07:28:24[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111817 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038080215454102 -- 25-11-23 07:28:24[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111817 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023030042648315 -- 25-11-23 07:28:25[邓炟-1787] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=111817 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022255182266235 -- 25-11-23 07:28:26[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019438028335571 -- 25-11-23 07:28:26[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111816 SELECT p.*,c.cont_name apply_cont,o.org_name department,13 appr_type_id FROM dboa.oa_payment p LEFT JOIN dbsys.sys_contact c on p.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON p.department_id = o.org_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id WHERE payment_id = 111816 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038077831268311 -- 25-11-23 07:28:26[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111816 select payment_id from dbthird.thd_payment where oa_payment_id = 111816 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038769245147705 -- 25-11-23 07:28:26[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111816 SELECT s.*,cust.cust_name carrier FROM dbthird.thd_statement s LEFT JOIN dbthird.thd_customer cust ON cust.customer_id = s.customer_id WHERE s.payment_id = 129804 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042691230773926 -- 25-11-23 07:28:26[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111816 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 = 5612207 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037031173706055 -- 25-11-23 07:28:26[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111816 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025552988052368 -- 25-11-23 07:28:26[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111816 select * from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038719177246094 -- 25-11-23 07:28:26[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111816 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 5612207 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036938190460205 -- 25-11-23 07:28:26[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111816 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036840438842773 -- 25-11-23 07:28:27[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111816 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003756046295166 -- 25-11-23 07:28:27[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111816 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019981145858765 -- 25-11-23 07:28:29[邓炟-1787] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=111816 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020934104919434 -- 25-11-23 07:28:30[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022118091583252 -- 25-11-23 07:28:30[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111788 SELECT p.*,c.cont_name apply_cont,o.org_name department,13 appr_type_id FROM dboa.oa_payment p LEFT JOIN dbsys.sys_contact c on p.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON p.department_id = o.org_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id WHERE payment_id = 111788 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046060085296631 -- 25-11-23 07:28:30[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111788 select payment_id from dbthird.thd_payment where oa_payment_id = 111788 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046648979187012 -- 25-11-23 07:28:30[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111788 SELECT s.*,cust.cust_name carrier FROM dbthird.thd_statement s LEFT JOIN dbthird.thd_customer cust ON cust.customer_id = s.customer_id WHERE s.payment_id = 129776 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045828819274902 -- 25-11-23 07:28:30[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111788 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 = 5610733 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041248798370361 -- 25-11-23 07:28:30[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111788 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041921138763428 -- 25-11-23 07:28:30[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111788 select * from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042870044708252 -- 25-11-23 07:28:30[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111788 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 5610733 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041260719299316 -- 25-11-23 07:28:30[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111788 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004127025604248 -- 25-11-23 07:28:30[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111788 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004148006439209 -- 25-11-23 07:28:30[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=111788 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017004013061523 -- 25-11-23 07:28:31[邓炟-1787] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=111788 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018824100494385 -- 25-11-23 07:28:32[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020473957061768 -- 25-11-23 07:28:32[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=41806 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 = 41806 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045809745788574 -- 25-11-23 07:28:32[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=41806 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 41806 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036118030548096 -- 25-11-23 07:28:32[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=41806 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 = 5611832 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030820369720459 -- 25-11-23 07:28:32[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=41806 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032651424407959 -- 25-11-23 07:28:32[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=41806 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 5611832 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030701160430908 -- 25-11-23 07:28:32[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=41806 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018450021743774 -- 25-11-23 07:28:38[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02056097984314 -- 25-11-23 07:28:38[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=41806 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 = 41806 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004040002822876 -- 25-11-23 07:28:38[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=41806 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 41806 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040550231933594 -- 25-11-23 07:28:38[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=41806 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 = 5611832 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040760040283203 -- 25-11-23 07:28:38[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=41806 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004101037979126 -- 25-11-23 07:28:38[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=41806 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 5611832 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040650367736816 -- 25-11-23 07:28:38[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=41806 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020974159240723 -- 25-11-23 07:28:39[邓炟-1787] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=41806 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020752906799316 -- 25-11-23 07:28:39[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017795085906982 -- 25-11-23 07:28:40[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=41792 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 = 41792 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040018558502197 -- 25-11-23 07:28:40[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=41792 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 41792 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039889812469482 -- 25-11-23 07:28:40[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=41792 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 = 5607304 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034570693969727 -- 25-11-23 07:28:40[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=41792 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036530494689941 -- 25-11-23 07:28:40[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=41792 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 5607304 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034379959106445 -- 25-11-23 07:28:40[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=41792 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024222850799561 -- 25-11-23 07:28:42[邓炟-1787] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=41792 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018426895141602 -- 25-11-23 07:28:42[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020596027374268 -- 25-11-23 07:28:42[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=41751 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 = 41751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045340061187744 -- 25-11-23 07:28:42[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=41751 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 41751 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041520595550537 -- 25-11-23 07:28:42[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=41751 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 = 5595541 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039710998535156 -- 25-11-23 07:28:42[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=41751 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041830539703369 -- 25-11-23 07:28:43[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=41751 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 5595541 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039892196655273 -- 25-11-23 07:28:43[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=41751 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025360822677612 -- 25-11-23 07:28:44[邓炟-1787] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=41751 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01826286315918 -- 25-11-23 07:28:44[邓炟-1787] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1787 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019032955169678 -- 25-11-23 08:47:16 -- /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.0037050247192383 -- 25-11-23 08:47:16 -- /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.004194974899292 -- 25-11-23 08:47:16 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='GaoXiang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038778781890869 -- 25-11-23 08:47:16[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01832103729248 -- 25-11-23 08:47:17[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022922992706299 -- 25-11-23 13:35:13 -- /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.003943920135498 -- 25-11-23 13:35:13 -- /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.0044419765472412 -- 25-11-23 13:35:13 -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='ZhuXiaoFeng' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041511058807373 -- 25-11-23 13:35:13[朱小凤-937] -- /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= 23 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022262096405029 -- 25-11-23 13:35:13[朱小凤-937] -- /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 = 937 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0060179233551025 -- 25-11-23 13:35:13[朱小凤-937] -- /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 = 937 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.006134033203125 -- 25-11-23 13:35:13[朱小凤-937] -- /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 = 937 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0059361457824707 -- 25-11-23 13:35:13[朱小凤-937] -- /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 = 937 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0064990520477295 -- 25-11-23 13:35:13[朱小凤-937] -- /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= 937 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022273778915405 -- 25-11-23 13:35:14[朱小凤-937] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=6935 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d %H:%i') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 6935 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042810440063477 -- 25-11-23 13:35:14[朱小凤-937] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=6935 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 5607171 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041861534118652 -- 25-11-23 13:35:14[朱小凤-937] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=6935 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 937 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041251182556152 -- 25-11-23 13:35:14[朱小凤-937] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=6935 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 937 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019728183746338 -- 25-11-23 13:36:21[朱小凤-937] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=6935 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d %H:%i') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 6935 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036849975585938 -- 25-11-23 13:36:21[朱小凤-937] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=6935 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 5607171 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035979747772217 -- 25-11-23 13:36:21[朱小凤-937] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=6935 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 937 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035150051116943 -- 25-11-23 13:36:21[朱小凤-937] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_officialSeals&officialSeals_id=6935 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 937 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019076108932495 -- 25-11-23 17:16:19[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1650774&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%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 = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031490325927734 -- 25-11-23 17:16:19[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1650774&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%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.0030500888824463 -- 25-11-23 17:16:19[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1650774&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032439231872559 -- 25-11-23 17:16:19[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1650774&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%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 (1650774) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030278921127319 -- 25-11-23 17:16:19[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1650774&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026145935058594 -- 25-11-23 17:16:19[李丹-751] -- /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.022687196731567 -- 25-11-23 17:16:19[李丹-751] -- /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.024350881576538 -- 25-11-23 17:16:19[李丹-751] -- /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.021308898925781 -- 25-11-23 17:16:22[李丹-751] -- /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.029016017913818 -- 25-11-23 17:16:25[李丹-751] -- /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.020243883132935 -- 25-11-23 17:16:38[李丹-751] -- /buz/oa/index.php/oamgmt/get_extrafare_item select extrafare_name,extrafare_id from dboa.oa_extrafare where acct_id = 15 and extrafare_name like '%人工费%' limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019139051437378 -- 25-11-23 17:16:58[李丹-751] -- /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 = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032811164855957 -- 25-11-23 17:16:58[李丹-751] -- /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 (1650774) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031569004058838 -- 25-11-23 17:16:58[李丹-751] -- /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 = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018160104751587 -- 25-11-23 17:16:59[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036017894744873 -- 25-11-23 17:16:59[李丹-751] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02115797996521 -- 25-11-23 17:17:00[李丹-751] -- /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 = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041861534118652 -- 25-11-23 17:17:00[李丹-751] -- /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 = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020700931549072 -- 25-11-23 17:17:01[李丹-751] -- /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 = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040719509124756 -- 25-11-23 17:17:02[李丹-751] -- /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 = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01594614982605 -- 25-11-23 17:17:02[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019008874893188 -- 25-11-23 17:17:33[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1650774&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%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 = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037848949432373 -- 25-11-23 17:17:33[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1650774&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%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.0036718845367432 -- 25-11-23 17:17:33[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1650774&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 751 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038919448852539 -- 25-11-23 17:17:33[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1650774&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%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 (1650774) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041940212249756 -- 25-11-23 17:17:33[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1650774&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D670%26ship_city%3D%E4%B8%8A%E6%B5%B7%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select file_id, SUBSTRING_INDEX(file_url,'www',-1) file_url,SUBSTRING_INDEX(thumb_file_url,'www',-1) thumb_file_url from dbpublic.pbl_upload_file where owner_id = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028398990631104 -- 25-11-23 17:17:33[李丹-751] -- /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.020279884338379 -- 25-11-23 17:17:34[李丹-751] -- /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.018646955490112 -- 25-11-23 17:17:34[李丹-751] -- /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.023651123046875 -- 25-11-23 19:27:49[张昭霞-2107] -- /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 = 2107 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052869319915771 -- 25-11-23 19:27:49[张昭霞-2107] -- /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 = 2107 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052239894866943 -- 25-11-23 19:27:49[张昭霞-2107] -- /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 = 2107 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0054049491882324 -- 25-11-23 19:27:49[张昭霞-2107] -- /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 = 2107 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052549839019775 -- 25-11-23 19:27:49[张昭霞-2107] -- /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= 2107 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021748065948486 -- 25-11-23 19:27:53[张昭霞-2107] -- /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 = 2107 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047018527984619 -- 25-11-23 19:27:53[张昭霞-2107] -- /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 = 2107 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045919418334961 -- 25-11-23 19:27:53[张昭霞-2107] -- /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 = 2107 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045778751373291 -- 25-11-23 19:27:53[张昭霞-2107] -- /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 = 2107 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046079158782959 -- 25-11-23 19:27:53[张昭霞-2107] -- /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= 2107 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------