Time: 0.021775007247925 -- 25-05-04 15:42:45[麦浩升-364] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016108989715576 -- 25-05-04 15:42:45[麦浩升-364] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018786907196045 -- 25-05-04 15:42:47[麦浩升-364] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 364 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030105113983154 -- 25-05-04 16:35:35[周玉广-847] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 847 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017705917358398 -- 25-05-04 16:35:35[周玉广-847] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 847 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018610000610352 -- 25-05-04 16:35:37[周玉广-847] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 847 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021299839019775 -- 25-05-04 17:51:28[阳彦柱-828] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2260684%22}&event=edit_extrafareApply&extrafareApply_id=60684 SELECT r.*,createdby.cont_name createdby,updatedby.cont_name updatedby,of.costAlloc_type_id,receive.cust_disp_name receiving_unit, o.appr_proc_name appr_proc,rc.cont_name apply_cont,org.org_name department,IFNULL(of.otherfee_id,0) otherfee_id,r.createdby_id FROM dboa.oa_extrafareApply r LEFT JOIN dboa.oa_appr_process o ON r.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact rc ON r.apply_cont_id = rc.cont_id LEFT JOIN dbsys.sys_org org ON r.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON r.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON r.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_otherfee of ON r.extrafareApply_id = of.extrafareApply_id LEFT JOIN dbthird.v_thd_customer receive ON receive.sys_cust_id = r.receiving_unit_id and receive.acct_id = r.acct_id WHERE r.extrafareApply_id = 60684 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00382399559021 -- 25-05-04 17:51:28[阳彦柱-828] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2260684%22}&event=edit_extrafareApply&extrafareApply_id=60684 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 828 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037481784820557 -- 25-05-04 17:51:28[阳彦柱-828] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2260684%22}&event=edit_extrafareApply&extrafareApply_id=60684 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 828 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039000511169434 -- 25-05-04 17:51:28[阳彦柱-828] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2260684%22}&event=edit_extrafareApply&extrafareApply_id=60684 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 = 4501150 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037510395050049 -- 25-05-04 17:51:28[阳彦柱-828] -- /buz/oa/index.php/oamgmt/oa_application?para={%22event%22:%22edit_extrafareApply%22,%22extrafareApply_id%22:%2260684%22}&event=edit_extrafareApply&extrafareApply_id=60684 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 828 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.032464981079102 -- 25-05-04 17:51:29[阳彦柱-828] -- /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.028423070907593 -- 25-05-04 17:51:29[阳彦柱-828] -- /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.022563934326172 -- 25-05-04 17:51:29[阳彦柱-828] -- /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.015570878982544 -- 25-05-04 17:51:36[阳彦柱-828] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2234731%22}&event=edit_fareApply&fareApply_id=34731 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 = 34731 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035140514373779 -- 25-05-04 17:51:36[阳彦柱-828] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2234731%22}&event=edit_fareApply&fareApply_id=34731 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 34731 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042319297790527 -- 25-05-04 17:51:36[阳彦柱-828] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2234731%22}&event=edit_fareApply&fareApply_id=34731 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 = 4501176 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028681755065918 -- 25-05-04 17:51:36[阳彦柱-828] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2234731%22}&event=edit_fareApply&fareApply_id=34731 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 828 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031189918518066 -- 25-05-04 17:51:36[阳彦柱-828] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2234731%22}&event=edit_fareApply&fareApply_id=34731 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 = 4501176 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028719902038574 -- 25-05-04 17:51:36[阳彦柱-828] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2234731%22}&event=edit_fareApply&fareApply_id=34731 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 828 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------