Time: 0.019777059555054 -- 25-07-27 00:00:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263867%22}&event=edit_extrafareApply&extrafareApply_id=63867 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 = 63867 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037758350372314 -- 25-07-27 00:00:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263867%22}&event=edit_extrafareApply&extrafareApply_id=63867 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 63867 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038118362426758 -- 25-07-27 00:00:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263867%22}&event=edit_extrafareApply&extrafareApply_id=63867 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 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 = 63867 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037879943847656 -- 25-07-27 00:00:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263867%22}&event=edit_extrafareApply&extrafareApply_id=63867 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038039684295654 -- 25-07-27 00:00:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263867%22}&event=edit_extrafareApply&extrafareApply_id=63867 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038368701934814 -- 25-07-27 00:00:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263867%22}&event=edit_extrafareApply&extrafareApply_id=63867 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 = 4984278 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038180351257324 -- 25-07-27 00:00:01[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263867%22}&event=edit_extrafareApply&extrafareApply_id=63867 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031666994094849 -- 25-07-27 00:00:14[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263866%22}&event=edit_extrafareApply&extrafareApply_id=63866 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 = 63866 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004478931427002 -- 25-07-27 00:00:14[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263866%22}&event=edit_extrafareApply&extrafareApply_id=63866 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 63866 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045428276062012 -- 25-07-27 00:00:14[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263866%22}&event=edit_extrafareApply&extrafareApply_id=63866 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 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 = 63866 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040240287780762 -- 25-07-27 00:00:14[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263866%22}&event=edit_extrafareApply&extrafareApply_id=63866 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039918422698975 -- 25-07-27 00:00:14[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263866%22}&event=edit_extrafareApply&extrafareApply_id=63866 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041170120239258 -- 25-07-27 00:00:14[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263866%22}&event=edit_extrafareApply&extrafareApply_id=63866 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 = 4984271 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039739608764648 -- 25-07-27 00:00:14[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263866%22}&event=edit_extrafareApply&extrafareApply_id=63866 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027369976043701 -- 25-07-27 00:00:32[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263866%22}&event=edit_extrafareApply&extrafareApply_id=63866 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 = 63866 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030410289764404 -- 25-07-27 00:00:32[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263866%22}&event=edit_extrafareApply&extrafareApply_id=63866 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 63866 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032689571380615 -- 25-07-27 00:00:32[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263866%22}&event=edit_extrafareApply&extrafareApply_id=63866 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 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 = 63866 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003058910369873 -- 25-07-27 00:00:32[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263866%22}&event=edit_extrafareApply&extrafareApply_id=63866 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030848979949951 -- 25-07-27 00:00:32[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263866%22}&event=edit_extrafareApply&extrafareApply_id=63866 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030581951141357 -- 25-07-27 00:00:32[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263866%22}&event=edit_extrafareApply&extrafareApply_id=63866 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 = 4984271 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030269622802734 -- 25-07-27 00:00:32[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263866%22}&event=edit_extrafareApply&extrafareApply_id=63866 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021795988082886 -- 25-07-27 00:00:39[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263815%22}&event=edit_extrafareApply&extrafareApply_id=63815 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 = 63815 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048749446868896 -- 25-07-27 00:00:39[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263815%22}&event=edit_extrafareApply&extrafareApply_id=63815 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 63815 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044867992401123 -- 25-07-27 00:00:39[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263815%22}&event=edit_extrafareApply&extrafareApply_id=63815 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 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 = 63815 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042610168457031 -- 25-07-27 00:00:39[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263815%22}&event=edit_extrafareApply&extrafareApply_id=63815 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042800903320312 -- 25-07-27 00:00:39[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263815%22}&event=edit_extrafareApply&extrafareApply_id=63815 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044310092926025 -- 25-07-27 00:00:39[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263815%22}&event=edit_extrafareApply&extrafareApply_id=63815 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 = 4981116 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042510032653809 -- 25-07-27 00:00:40[张昭霞-2107] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2263815%22}&event=edit_extrafareApply&extrafareApply_id=63815 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2107 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024085998535156 -- 25-07-27 02:55:58[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2231322%22}&event=edit_fareApply&fareApply_id=31322 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 = 31322 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049481391906738 -- 25-07-27 02:55:58[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2231322%22}&event=edit_fareApply&fareApply_id=31322 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 31322 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043680667877197 -- 25-07-27 02:55:58[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2231322%22}&event=edit_fareApply&fareApply_id=31322 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 = 4053354 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033080577850342 -- 25-07-27 02:55:58[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2231322%22}&event=edit_fareApply&fareApply_id=31322 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003399133682251 -- 25-07-27 02:55:58[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2231322%22}&event=edit_fareApply&fareApply_id=31322 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 = 4053354 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032298564910889 -- 25-07-27 02:55:58[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2231322%22}&event=edit_fareApply&fareApply_id=31322 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019685983657837 -- 25-07-27 02:56:32[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238046%22}&event=edit_fareApply&fareApply_id=38046 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 = 38046 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042128562927246 -- 25-07-27 02:56:32[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238046%22}&event=edit_fareApply&fareApply_id=38046 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38046 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042331218719482 -- 25-07-27 02:56:32[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238046%22}&event=edit_fareApply&fareApply_id=38046 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 = 4977643 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037050247192383 -- 25-07-27 02:56:32[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238046%22}&event=edit_fareApply&fareApply_id=38046 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029805898666382 -- 25-07-27 02:56:32[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238046%22}&event=edit_fareApply&fareApply_id=38046 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 = 4977643 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037178993225098 -- 25-07-27 02:56:32[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238046%22}&event=edit_fareApply&fareApply_id=38046 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017585039138794 -- 25-07-27 02:56:55[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238047%22}&event=edit_fareApply&fareApply_id=38047 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 = 38047 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037260055541992 -- 25-07-27 02:56:55[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238047%22}&event=edit_fareApply&fareApply_id=38047 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38047 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037131309509277 -- 25-07-27 02:56:55[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238047%22}&event=edit_fareApply&fareApply_id=38047 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 = 4977677 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032598972320557 -- 25-07-27 02:56:55[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238047%22}&event=edit_fareApply&fareApply_id=38047 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00341796875 -- 25-07-27 02:56:55[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238047%22}&event=edit_fareApply&fareApply_id=38047 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 = 4977677 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032670497894287 -- 25-07-27 02:56:55[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238047%22}&event=edit_fareApply&fareApply_id=38047 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0206458568573 -- 25-07-27 02:57:01[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238049%22}&event=edit_fareApply&fareApply_id=38049 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 = 38049 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038731098175049 -- 25-07-27 02:57:01[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238049%22}&event=edit_fareApply&fareApply_id=38049 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38049 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038762092590332 -- 25-07-27 02:57:01[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238049%22}&event=edit_fareApply&fareApply_id=38049 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 = 4977687 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033810138702393 -- 25-07-27 02:57:01[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238049%22}&event=edit_fareApply&fareApply_id=38049 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035438537597656 -- 25-07-27 02:57:01[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238049%22}&event=edit_fareApply&fareApply_id=38049 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 = 4977687 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033891201019287 -- 25-07-27 02:57:01[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238049%22}&event=edit_fareApply&fareApply_id=38049 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019436836242676 -- 25-07-27 02:57:13[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238049%22}&event=edit_fareApply&fareApply_id=38049 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 = 38049 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038251876831055 -- 25-07-27 02:57:13[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238049%22}&event=edit_fareApply&fareApply_id=38049 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38049 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038468837738037 -- 25-07-27 02:57:13[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238049%22}&event=edit_fareApply&fareApply_id=38049 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 = 4977687 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00382399559021 -- 25-07-27 02:57:13[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238049%22}&event=edit_fareApply&fareApply_id=38049 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038349628448486 -- 25-07-27 02:57:13[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238049%22}&event=edit_fareApply&fareApply_id=38049 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 = 4977687 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038130283355713 -- 25-07-27 02:57:13[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238049%22}&event=edit_fareApply&fareApply_id=38049 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022984027862549 -- 25-07-27 02:57:22[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238048%22}&event=edit_fareApply&fareApply_id=38048 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 = 38048 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048809051513672 -- 25-07-27 02:57:22[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238048%22}&event=edit_fareApply&fareApply_id=38048 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38048 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00484299659729 -- 25-07-27 02:57:22[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238048%22}&event=edit_fareApply&fareApply_id=38048 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 = 4977680 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043849945068359 -- 25-07-27 02:57:22[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238048%22}&event=edit_fareApply&fareApply_id=38048 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004572868347168 -- 25-07-27 02:57:22[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238048%22}&event=edit_fareApply&fareApply_id=38048 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 = 4977680 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043880939483643 -- 25-07-27 02:57:22[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238048%22}&event=edit_fareApply&fareApply_id=38048 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021060943603516 -- 25-07-27 02:57:37[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238051%22}&event=edit_fareApply&fareApply_id=38051 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 = 38051 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041899681091309 -- 25-07-27 02:57:38[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238051%22}&event=edit_fareApply&fareApply_id=38051 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38051 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042319297790527 -- 25-07-27 02:57:38[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238051%22}&event=edit_fareApply&fareApply_id=38051 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 = 4977758 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040850639343262 -- 25-07-27 02:57:38[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238051%22}&event=edit_fareApply&fareApply_id=38051 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042879581451416 -- 25-07-27 02:57:38[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238051%22}&event=edit_fareApply&fareApply_id=38051 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 = 4977758 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040698051452637 -- 25-07-27 02:57:38[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238051%22}&event=edit_fareApply&fareApply_id=38051 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021716117858887 -- 25-07-27 02:57:43[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238051%22}&event=edit_fareApply&fareApply_id=38051 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 = 38051 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033931732177734 -- 25-07-27 02:57:43[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238051%22}&event=edit_fareApply&fareApply_id=38051 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38051 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034070014953613 -- 25-07-27 02:57:43[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238051%22}&event=edit_fareApply&fareApply_id=38051 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 = 4977758 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033829212188721 -- 25-07-27 02:57:43[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238051%22}&event=edit_fareApply&fareApply_id=38051 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034301280975342 -- 25-07-27 02:57:43[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238051%22}&event=edit_fareApply&fareApply_id=38051 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 = 4977758 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034279823303223 -- 25-07-27 02:57:43[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238051%22}&event=edit_fareApply&fareApply_id=38051 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024966955184937 -- 25-07-27 02:58:05[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238051%22}&event=edit_fareApply&fareApply_id=38051 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 = 38051 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038199424743652 -- 25-07-27 02:58:05[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238051%22}&event=edit_fareApply&fareApply_id=38051 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38051 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038008689880371 -- 25-07-27 02:58:05[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238051%22}&event=edit_fareApply&fareApply_id=38051 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 = 4977758 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037810802459717 -- 25-07-27 02:58:05[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238051%22}&event=edit_fareApply&fareApply_id=38051 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038399696350098 -- 25-07-27 02:58:05[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238051%22}&event=edit_fareApply&fareApply_id=38051 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 = 4977758 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038142204284668 -- 25-07-27 02:58:05[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238051%22}&event=edit_fareApply&fareApply_id=38051 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.032156944274902 -- 25-07-27 02:58:22[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238053%22}&event=edit_fareApply&fareApply_id=38053 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 = 38053 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040249824523926 -- 25-07-27 02:58:22[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238053%22}&event=edit_fareApply&fareApply_id=38053 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38053 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040149688720703 -- 25-07-27 02:58:22[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238053%22}&event=edit_fareApply&fareApply_id=38053 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 = 4977798 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038528442382812 -- 25-07-27 02:58:22[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238053%22}&event=edit_fareApply&fareApply_id=38053 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040240287780762 -- 25-07-27 02:58:22[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238053%22}&event=edit_fareApply&fareApply_id=38053 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 = 4977798 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038540363311768 -- 25-07-27 02:58:22[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238053%22}&event=edit_fareApply&fareApply_id=38053 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018676996231079 -- 25-07-27 02:58:40[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237548%22}&event=edit_fareApply&fareApply_id=37548 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 = 37548 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040478706359863 -- 25-07-27 02:58:40[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237548%22}&event=edit_fareApply&fareApply_id=37548 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 37548 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004033088684082 -- 25-07-27 02:58:40[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237548%22}&event=edit_fareApply&fareApply_id=37548 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 = 4910910 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035600662231445 -- 25-07-27 02:58:40[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237548%22}&event=edit_fareApply&fareApply_id=37548 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00372314453125 -- 25-07-27 02:58:41[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237548%22}&event=edit_fareApply&fareApply_id=37548 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 = 4910910 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035250186920166 -- 25-07-27 02:58:41[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237548%22}&event=edit_fareApply&fareApply_id=37548 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021443128585815 -- 25-07-27 02:58:56[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237548%22}&event=edit_fareApply&fareApply_id=37548 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 = 37548 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031960010528564 -- 25-07-27 02:58:56[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237548%22}&event=edit_fareApply&fareApply_id=37548 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 37548 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031869411468506 -- 25-07-27 02:58:56[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237548%22}&event=edit_fareApply&fareApply_id=37548 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 = 4910910 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031700134277344 -- 25-07-27 02:58:56[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237548%22}&event=edit_fareApply&fareApply_id=37548 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032169818878174 -- 25-07-27 02:58:56[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237548%22}&event=edit_fareApply&fareApply_id=37548 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 = 4910910 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031869411468506 -- 25-07-27 02:58:56[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237548%22}&event=edit_fareApply&fareApply_id=37548 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024634838104248 -- 25-07-27 02:59:18[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237549%22}&event=edit_fareApply&fareApply_id=37549 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 = 37549 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043931007385254 -- 25-07-27 02:59:18[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237549%22}&event=edit_fareApply&fareApply_id=37549 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 37549 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044229030609131 -- 25-07-27 02:59:18[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237549%22}&event=edit_fareApply&fareApply_id=37549 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 = 4910949 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038890838623047 -- 25-07-27 02:59:18[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237549%22}&event=edit_fareApply&fareApply_id=37549 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040779113769531 -- 25-07-27 02:59:18[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237549%22}&event=edit_fareApply&fareApply_id=37549 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 = 4910949 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039000511169434 -- 25-07-27 02:59:18[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237549%22}&event=edit_fareApply&fareApply_id=37549 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016987800598145 -- 25-07-27 02:59:30[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237547%22}&event=edit_fareApply&fareApply_id=37547 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 = 37547 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038361549377441 -- 25-07-27 02:59:30[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237547%22}&event=edit_fareApply&fareApply_id=37547 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 37547 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038220882415771 -- 25-07-27 02:59:30[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237547%22}&event=edit_fareApply&fareApply_id=37547 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 = 4910909 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032758712768555 -- 25-07-27 02:59:30[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237547%22}&event=edit_fareApply&fareApply_id=37547 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034499168395996 -- 25-07-27 02:59:30[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237547%22}&event=edit_fareApply&fareApply_id=37547 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 = 4910909 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032861232757568 -- 25-07-27 02:59:30[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237547%22}&event=edit_fareApply&fareApply_id=37547 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016228914260864 -- 25-07-27 02:59:56[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237252%22}&event=edit_fareApply&fareApply_id=37252 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 = 37252 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037310123443604 -- 25-07-27 02:59:56[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237252%22}&event=edit_fareApply&fareApply_id=37252 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 37252 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032858848571777 -- 25-07-27 02:59:56[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237252%22}&event=edit_fareApply&fareApply_id=37252 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 = 4869687 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031349658966064 -- 25-07-27 02:59:56[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237252%22}&event=edit_fareApply&fareApply_id=37252 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033478736877441 -- 25-07-27 02:59:56[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237252%22}&event=edit_fareApply&fareApply_id=37252 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 = 4869687 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00313401222229 -- 25-07-27 02:59:56[王元-300] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237252%22}&event=edit_fareApply&fareApply_id=37252 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02519702911377 -- 25-07-27 13:47:28[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238158%22%7D&event=edit_fareApply&fareApply_id=38158 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 = 38158 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039029121398926 -- 25-07-27 13:47:28[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238158%22%7D&event=edit_fareApply&fareApply_id=38158 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38158 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004417896270752 -- 25-07-27 13:47:28[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238158%22%7D&event=edit_fareApply&fareApply_id=38158 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 = 4994953 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037798881530762 -- 25-07-27 13:47:28[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238158%22%7D&event=edit_fareApply&fareApply_id=38158 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038959980010986 -- 25-07-27 13:47:28[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238158%22%7D&event=edit_fareApply&fareApply_id=38158 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 = 4994953 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037319660186768 -- 25-07-27 13:47:28[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238158%22%7D&event=edit_fareApply&fareApply_id=38158 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024540901184082 -- 25-07-27 13:47:32[王夕玉-520] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=38158 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017409086227417 -- 25-07-27 13:47:32[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022089004516602 -- 25-07-27 15:33:22[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238160%22%7D&event=edit_fareApply&fareApply_id=38160 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 = 38160 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044150352478027 -- 25-07-27 15:33:22[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238160%22%7D&event=edit_fareApply&fareApply_id=38160 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38160 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049970149993896 -- 25-07-27 15:33:22[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238160%22%7D&event=edit_fareApply&fareApply_id=38160 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 = 4995066 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043790340423584 -- 25-07-27 15:33:22[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238160%22%7D&event=edit_fareApply&fareApply_id=38160 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004504919052124 -- 25-07-27 15:33:23[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238160%22%7D&event=edit_fareApply&fareApply_id=38160 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 = 4995066 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042879581451416 -- 25-07-27 15:33:23[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238160%22%7D&event=edit_fareApply&fareApply_id=38160 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018553018569946 -- 25-07-27 15:33:29[王夕玉-520] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=38160 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029726982116699 -- 25-07-27 15:33:29[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019299983978271 -- 25-07-27 15:33:31[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38159 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 = 38159 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038490295410156 -- 25-07-27 15:33:31[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38159 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38159 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042760372161865 -- 25-07-27 15:33:31[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38159 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 = 4995065 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037181377410889 -- 25-07-27 15:33:31[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38159 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039138793945312 -- 25-07-27 15:33:31[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38159 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 = 4995065 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036919116973877 -- 25-07-27 15:33:31[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38159 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023053169250488 -- 25-07-27 15:33:33[王夕玉-520] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=38159 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029778003692627 -- 25-07-27 15:33:33[王夕玉-520] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 520 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017416000366211 -- 25-07-27 15:43:37[姜维华-529] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238160%22%7D&event=edit_fareApply&fareApply_id=38160 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 = 38160 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039169788360596 -- 25-07-27 15:43:37[姜维华-529] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238160%22%7D&event=edit_fareApply&fareApply_id=38160 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38160 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038599967956543 -- 25-07-27 15:43:37[姜维华-529] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238160%22%7D&event=edit_fareApply&fareApply_id=38160 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 = 4995066 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033979415893555 -- 25-07-27 15:43:37[姜维华-529] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238160%22%7D&event=edit_fareApply&fareApply_id=38160 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 529 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035150051116943 -- 25-07-27 15:43:37[姜维华-529] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238160%22%7D&event=edit_fareApply&fareApply_id=38160 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 = 4995066 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033209323883057 -- 25-07-27 15:43:37[姜维华-529] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238160%22%7D&event=edit_fareApply&fareApply_id=38160 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 529 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.028345108032227 -- 25-07-27 15:43:43[姜维华-529] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238159%22%7D&event=edit_fareApply&fareApply_id=38159 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 = 38159 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043189525604248 -- 25-07-27 15:43:43[姜维华-529] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238159%22%7D&event=edit_fareApply&fareApply_id=38159 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38159 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042769908905029 -- 25-07-27 15:43:43[姜维华-529] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238159%22%7D&event=edit_fareApply&fareApply_id=38159 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 = 4995065 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037171840667725 -- 25-07-27 15:43:43[姜维华-529] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238159%22%7D&event=edit_fareApply&fareApply_id=38159 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 529 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039799213409424 -- 25-07-27 15:43:44[姜维华-529] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238159%22%7D&event=edit_fareApply&fareApply_id=38159 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 = 4995065 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037298202514648 -- 25-07-27 15:43:44[姜维华-529] -- /buz/oa/index.php/oamgmt/oa_approval?para=%7B%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2238159%22%7D&event=edit_fareApply&fareApply_id=38159 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 529 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029199123382568 -- 25-07-27 16:51:08[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1482889&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.0040850639343262 -- 25-07-27 16:51:08[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1482889&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.003957986831665 -- 25-07-27 16:51:08[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1482889&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.0041399002075195 -- 25-07-27 16:51:08[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1482889&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 (1482889) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052378177642822 -- 25-07-27 16:51:08[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1482889&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.035327911376953 -- 25-07-27 16:51:08[李丹-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.019927978515625 -- 25-07-27 16:51:08[李丹-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.02172589302063 -- 25-07-27 16:51:08[李丹-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.025214910507202 -- 25-07-27 16:51:11[李丹-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.022014141082764 -- 25-07-27 16:51:15[李丹-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.016605138778687 -- 25-07-27 16:51:29[赖碧婷-2207] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2207 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019500017166138 -- 25-07-27 16:51:29[赖碧婷-2207] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2207 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015882015228271 -- 25-07-27 16:51:29[李丹-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.017325878143311 -- 25-07-27 16:51:32[赖碧婷-2207] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2207 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017284870147705 -- 25-07-27 16:51:36[李丹-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.0035369396209717 -- 25-07-27 16:51:36[李丹-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 (1482889) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034308433532715 -- 25-07-27 16:51:36[李丹-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.021452188491821 -- 25-07-27 16:51:37[李丹-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.0042059421539307 -- 25-07-27 16:51:37[李丹-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.017319917678833 -- 25-07-27 16:51:38[李丹-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.0033848285675049 -- 25-07-27 16:51:38[李丹-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.021469116210938 -- 25-07-27 16:51:39[李丹-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.0034220218658447 -- 25-07-27 16:51:39[李丹-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.02735710144043 -- 25-07-27 16:51:39[李丹-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.028353929519653 -- 25-07-27 16:53:27[赖碧婷-2207] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2207 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.032573223114014 -- 25-07-27 16:53:27[赖碧婷-2207] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2207 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031919002532959 -- 25-07-27 16:53:29[赖碧婷-2207] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2207 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02854585647583 -- 25-07-27 16:54:09[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1483314&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.00376296043396 -- 25-07-27 16:54:09[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1483314&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.0036418437957764 -- 25-07-27 16:54:09[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1483314&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.0038278102874756 -- 25-07-27 16:54:09[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1483314&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 (1483314) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041089057922363 -- 25-07-27 16:54:09[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1483314&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.031380891799927 -- 25-07-27 16:54:09[李丹-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.023574113845825 -- 25-07-27 16:54:09[李丹-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.023181915283203 -- 25-07-27 16:54:09[李丹-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.031227111816406 -- 25-07-27 16:54:12[李丹-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.016268014907837 -- 25-07-27 16:54:16[李丹-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.01867413520813 -- 25-07-27 16:54:34[李丹-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.021013021469116 -- 25-07-27 16:54:40[李丹-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.0042610168457031 -- 25-07-27 16:54:40[李丹-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 (1483314) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041441917419434 -- 25-07-27 16:54:40[李丹-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.033797979354858 -- 25-07-27 16:54:41[李丹-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.0040009021759033 -- 25-07-27 16:54:41[李丹-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.02111291885376 -- 25-07-27 16:54:42[李丹-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.0032751560211182 -- 25-07-27 16:54:42[李丹-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.018623113632202 -- 25-07-27 16:54:43[李丹-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.0036900043487549 -- 25-07-27 16:54:43[李丹-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.024964809417725 -- 25-07-27 16:54:43[李丹-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.019579172134399 -- 25-07-27 16:56:38[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1483314&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.003917932510376 -- 25-07-27 16:56:38[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1483314&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.0037930011749268 -- 25-07-27 16:56:38[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1483314&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.0039680004119873 -- 25-07-27 16:56:38[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1483314&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 (1483314) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021605968475342 -- 25-07-27 16:56:38[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1483314&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.0244460105896 -- 25-07-27 16:56:38[李丹-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.017558097839355 -- 25-07-27 16:56:38[李丹-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.022231101989746 -- 25-07-27 16:56:39[李丹-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.019284963607788 -- 25-07-27 16:56:41[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1482889&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.0037651062011719 -- 25-07-27 16:56:41[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1482889&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.0037369728088379 -- 25-07-27 16:56:41[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1482889&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.0040168762207031 -- 25-07-27 16:56:41[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1482889&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 (1482889) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038111209869385 -- 25-07-27 16:56:41[李丹-751] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1482889&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.020787000656128 -- 25-07-27 16:56:41[李丹-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.032515048980713 -- 25-07-27 16:56:42[李丹-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.017982006072998 -- 25-07-27 16:56:42[李丹-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.018929004669189 -- 25-07-27 16:57:08 -- /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.0034029483795166 -- 25-07-27 16:57:08 -- /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.0040290355682373 -- 25-07-27 16:57:08 -- /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='ZhangTiHai' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036890506744385 -- 25-07-27 16:57:08[张体海-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.019455194473267 -- 25-07-27 16:57:08 -- /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.019032001495361 -- 25-07-27 16:57:10[张体海-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.023589134216309 -- 25-07-27 17:14: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.0034229755401611 -- 25-07-27 17:14: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.0039339065551758 -- 25-07-27 17:14:05 -- /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='ZhangJin' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036928653717041 -- 25-07-27 17:14:05[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023435115814209 -- 25-07-27 17:14:06[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025406122207642 -- 25-07-27 17:14:07[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38157 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 = 38157 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045158863067627 -- 25-07-27 17:14:07[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38157 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38157 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0045468807220459 -- 25-07-27 17:14:07[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38157 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 = 4993996 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003931999206543 -- 25-07-27 17:14:07[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38157 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041179656982422 -- 25-07-27 17:14:07[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38157 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 = 4993996 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039041042327881 -- 25-07-27 17:14:07[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38157 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01825213432312 -- 25-07-27 17:14:09[张进-414] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=38157 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02079701423645 -- 25-07-27 17:14:10[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031499862670898 -- 25-07-27 17:14:15[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37706 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 = 37706 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038728713989258 -- 25-07-27 17:14:15[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37706 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 37706 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003917932510376 -- 25-07-27 17:14:15[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37706 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 = 4935082 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033879280090332 -- 25-07-27 17:14:15[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37706 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036139488220215 -- 25-07-27 17:14:15[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37706 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 = 4935082 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033528804779053 -- 25-07-27 17:14:15[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=37706 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024701833724976 -- 25-07-27 17:14:51[张进-414] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=37706 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02169394493103 -- 25-07-27 17:14:52[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018301010131836 -- 25-07-27 17:15:47[曹志雄-822] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237706%22}&event=edit_fareApply&fareApply_id=37706 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 = 37706 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004047155380249 -- 25-07-27 17:15:47[曹志雄-822] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237706%22}&event=edit_fareApply&fareApply_id=37706 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 37706 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040309429168701 -- 25-07-27 17:15:47[曹志雄-822] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237706%22}&event=edit_fareApply&fareApply_id=37706 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 = 4935082 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035781860351562 -- 25-07-27 17:15:47[曹志雄-822] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237706%22}&event=edit_fareApply&fareApply_id=37706 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 822 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003774881362915 -- 25-07-27 17:15:47[曹志雄-822] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237706%22}&event=edit_fareApply&fareApply_id=37706 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 = 4935082 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035128593444824 -- 25-07-27 17:15:47[曹志雄-822] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2237706%22}&event=edit_fareApply&fareApply_id=37706 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 822 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------