Time: 0.019127130508423 -- 25-08-13 04:28:28 -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027481079101562 -- 25-08-13 04:28:29[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 300 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.056206941604614 -- 25-08-13 04:28:30[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 300 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0060060024261475 -- 25-08-13 04:28:30[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 300 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0061919689178467 -- 25-08-13 04:28:30[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 300 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0072729587554932 -- 25-08-13 04:28:30[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 300 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026393890380859 -- 25-08-13 04:28:30[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=38619 SELECT fa.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc, apply.cont_name apply_cont,org.org_name department,12 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account, date_format(fa.apply_date,'%Y-%m-%d %H-%i') apply_date FROM dboa.oa_fareApply fa LEFT JOIN dboa.oa_appr_process o ON fa.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON fa.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON fa.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON fa.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON fa.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_customer receiving ON fa.receiving_unit_id = receiving.customer_id WHERE fa.fareApply_id = 38619 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039710998535156 -- 25-08-13 04:28:30[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=38619 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040650367736816 -- 25-08-13 04:28:30[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=38619 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 = 5077837 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038890838623047 -- 25-08-13 04:28:30[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=38619 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038740634918213 -- 25-08-13 04:28:30[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=38619 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003917932510376 -- 25-08-13 04:28:31[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=38619 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 = 5077837 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038769245147705 -- 25-08-13 04:28:31[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=38619 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01793098449707 -- 25-08-13 04:28:31[王元-300] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =5 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%刘春明%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021834135055542 -- 25-08-13 04:28:31[王元-300] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 5 and cont.cont_isenable = 1 AND cont.cont_name like '%王元%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020143032073975 -- 25-08-13 04:28:31[王元-300] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 5 AND o.org_name like '%项目一部%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017182111740112 -- 25-08-13 04:28:31[王元-300] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 5 AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020071983337402 -- 25-08-13 04:28:31[王元-300] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select DISTINCT IFNULL(p_e.parent_id,1) parent_id from dbsys.sys_project p left join dbsys.sys_project_ext p_e on p.project_id = p_e.project_id where p.acct_id = 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040171146392822 -- 25-08-13 04:28:31[王元-300] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select p.project_id AS `value`,p.project_name AS `title` from dbsys.sys_project p where p.acct_id = 5 and p.project_id not in (24,196,1,10,242) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020603179931641 -- 25-08-13 04:28:37[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 300 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0075290203094482 -- 25-08-13 04:28:37[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 300 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044081211090088 -- 25-08-13 04:28:37[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 300 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043540000915527 -- 25-08-13 04:28:37[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 300 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043540000915527 -- 25-08-13 04:28:37[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 300 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020416021347046 -- 25-08-13 04:28:37[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=38618 SELECT fa.*,createdby.cont_name createdby,updatedby.cont_name updatedby,o.appr_proc_name appr_proc, apply.cont_name apply_cont,org.org_name department,12 appr_type_id, receiving.opening_bank receiving_opening_bank,receiving.bank_account receiving_bank_account, date_format(fa.apply_date,'%Y-%m-%d %H-%i') apply_date FROM dboa.oa_fareApply fa LEFT JOIN dboa.oa_appr_process o ON fa.appr_proc_id = o.appr_proc_id LEFT JOIN dbsys.sys_contact apply ON fa.apply_cont_id = apply.cont_id LEFT JOIN dbsys.sys_org org ON fa.department_id = org.org_id LEFT JOIN dbsys.sys_contact createdby ON fa.createdby_id = createdby.cont_id LEFT JOIN dbsys.sys_contact updatedby ON fa.updatedby_id = updatedby.cont_id LEFT JOIN dbthird.thd_customer receiving ON fa.receiving_unit_id = receiving.customer_id WHERE fa.fareApply_id = 38618 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003715991973877 -- 25-08-13 04:28:37[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=38618 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039491653442383 -- 25-08-13 04:28:37[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=38618 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 = 5077831 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036990642547607 -- 25-08-13 04:28:37[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=38618 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037119388580322 -- 25-08-13 04:28:37[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=38618 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037610530853271 -- 25-08-13 04:28:38[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=38618 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 = 5077831 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037069320678711 -- 25-08-13 04:28:38[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=38618 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019896030426025 -- 25-08-13 04:28:38[王元-300] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =5 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%刘春明%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020501136779785 -- 25-08-13 04:28:38[王元-300] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 5 and cont.cont_isenable = 1 AND cont.cont_name like '%王元%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024604082107544 -- 25-08-13 04:28:38[王元-300] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 5 AND o.org_name like '%项目一部%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021523952484131 -- 25-08-13 04:28:38[王元-300] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 5 AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016494989395142 -- 25-08-13 04:28:38[王元-300] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select DISTINCT IFNULL(p_e.parent_id,1) parent_id from dbsys.sys_project p left join dbsys.sys_project_ext p_e on p.project_id = p_e.project_id where p.acct_id = 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032649040222168 -- 25-08-13 04:28:38[王元-300] -- /buz/oa/index.php/oamgmt/get_projectItem_noChild select p.project_id AS `value`,p.project_name AS `title` from dbsys.sys_project p where p.acct_id = 5 and p.project_id not in (24,196,1,10,242) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019694089889526 -- 25-08-13 04:28:47[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT extrafareApply_id doc_id,extrafareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,3 as appr_type_id,0 is_urgent FROM dboa.oa_extrafareApply WHERE createdby_id = 300 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0060439109802246 -- 25-08-13 04:28:47[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT fareApply_id doc_id,fareApply_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,12 as appr_type_id,0 is_urgent FROM dboa.oa_fareapply WHERE createdby_id = 300 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042150020599365 -- 25-08-13 04:28:47[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT payment_id doc_id,payment_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,13 as appr_type_id,0 is_urgent FROM dboa.oa_payment WHERE createdby_id = 300 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041830539703369 -- 25-08-13 04:28:47[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT officialSeals_id doc_id,officialSeals_no doc_no,status_id,DATE_FORMAT(apply_date,'%Y-%m-%d') apply_date,14 as appr_type_id,is_urgent FROM dboa.oa_officialSeals WHERE createdby_id = 300 AND (apply_date >= now() - interval 7 day) AND (apply_date <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0041749477386475 -- 25-08-13 04:28:47[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=query SELECT task_id doc_id, task_no doc_no, status_id, DATE_FORMAT(createdon, '%Y-%m-%d') apply_date, 4 as appr_type_id, 0 is_urgent FROM dboa.oa_task WHERE createdby_id= 300 AND (createdon >= now() - interval 7 day ) AND (createdon <= now() ) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030649185180664 -- 25-08-13 05:25:03[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1504155&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select o.org_id,o.org_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044960975646973 -- 25-08-13 05:25:03[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1504155&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%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.0043380260467529 -- 25-08-13 05:25:03[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1504155&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044970512390137 -- 25-08-13 05:25:03[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1504155&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%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 (1504155) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046999454498291 -- 25-08-13 05:25:03[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1504155&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%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.028345108032227 -- 25-08-13 05:25:03[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =9 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025360822677612 -- 25-08-13 05:25:04[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 9 and cont.cont_isenable = 1 AND cont.cont_name like '%秦学习-南京办%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.029891967773438 -- 25-08-13 05:25:04[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.org_name like '%南京办事处%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024580955505371 -- 25-08-13 05:25:12[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =9 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 AND cust_disp_name like '%秦学习%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018374919891357 -- 25-08-13 05:25:21[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.org_name like '%运输部%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027781963348389 -- 25-08-13 05:25:45[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033500194549561 -- 25-08-13 05:25:45[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034310817718506 -- 25-08-13 05:25:45[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select group_concat(order_no) order_no_str from dbthird.thd_order where order_id in (1504155) limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032799243927002 -- 25-08-13 05:25:45[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048410892486572 -- 25-08-13 05:25:45[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 1240,updatedby_id = 1240 where extrafareApply_id = 64816 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044279098510742 -- 25-08-13 05:25:45[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 1240,updatedby_id = 1240 where otherfee_id = 66409 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022243022918701 -- 25-08-13 05:25:57[秦学习-南京办-1240] -- /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.015182018280029 -- 25-08-13 05:29:33[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030150413513184 -- 25-08-13 05:29:33[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030431747436523 -- 25-08-13 05:29:33[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.27579998970032 -- 25-08-13 05:29:44[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/get_order_item SELECT o.order_id,o.order_no,o.owner_id FROM dbthird.thd_order o left join dbthird.thd_order_extend o_e on o_e.order_id = o.order_id WHERE o.acct_id = 9 AND o.order_no like '%080069%' order by o.order_id desc LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022288084030151 -- 25-08-13 05:29:53[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_order select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043501853942871 -- 25-08-13 05:29:53[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_order select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043799877166748 -- 25-08-13 05:29:53[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_order select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020583868026733 -- 25-08-13 05:29:56[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003993034362793 -- 25-08-13 05:29:56[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040559768676758 -- 25-08-13 05:29:57[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0052490234375 -- 25-08-13 05:29:57[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 1240,updatedby_id = 1240 where extrafareApply_id = 64816 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00531005859375 -- 25-08-13 05:29:57[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 1240,updatedby_id = 1240 where otherfee_id = 66409 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020130157470703 -- 25-08-13 05:30:10[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039670467376709 -- 25-08-13 05:30:10[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039958953857422 -- 25-08-13 05:30:10[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.005234956741333 -- 25-08-13 05:30:10[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 1240,updatedby_id = 1240 where extrafareApply_id = 64816 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050392150878906 -- 25-08-13 05:30:10[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 1240,updatedby_id = 1240 where otherfee_id = 66409 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017164945602417 -- 25-08-13 05:30:12[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select admin_id cont_id from dbsys.sys_acct where acct_id = 9 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033340454101562 -- 25-08-13 05:30:12[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 312 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033969879150391 -- 25-08-13 05:30:12[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0046820640563965 -- 25-08-13 05:30:12[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 1240,updatedby_id = 1240 where extrafareApply_id = 64816 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048398971557617 -- 25-08-13 05:30:12[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 1240,updatedby_id = 1240 where otherfee_id = 66409 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01708197593689 -- 25-08-13 05:30:12[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015071153640747 -- 25-08-13 05:32:04[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1504155&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select o.org_id,o.org_name from dbsys.sys_contact c left join dbsys.sys_org o on c.cont_deforgid = o.org_id where c.cont_id = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002997875213623 -- 25-08-13 05:32:04[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1504155&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%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.0030031204223633 -- 25-08-13 05:32:04[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1504155&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%E5%B8%82%26is_apply%3D1&extrafareApply_id=0 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1240 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030918121337891 -- 25-08-13 05:32:04[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1504155&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%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 (1504155) ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003277063369751 -- 25-08-13 05:32:04[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_extrafareApply&order_ids=1504155&from_url=https%3A%2F%2Fwechat.flysman.com%2Fbuz%2Fthird%2Findex.php%2Fthirdoprt%2Ftrans_arng_desk_new%3Fship_city_id%3D173%26ship_city%3D%E5%8D%97%E4%BA%AC%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.027698993682861 -- 25-08-13 05:32:04[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/get_carrier_item SELECT cust.customer_id AS `id`,cust_disp_name AS `text`,address,cust.city_id,tel, city.area_name city,pb.pricebook_id,cust.inv_cust_id, IF(IFNULL(cust.account_name,'')<>'',cust.account_name,cust.cust_name) account_name,cust.opening_bank,cust.bank_account,sys_cust_id FROM dbthird.v_thd_customer cust left join dbsys.sys_customer_ext c_e on c_e.customer_id = cust.sys_cust_id left join dbsys.sys_area city on cust.city_id = city.area_id LEFT JOIN dbthird.thd_pricebook_customer pb_c ON pb_c.customer_id = cust.customer_id left join dbthird.thd_price_book pb on pb.pricebook_id = pb_c.pricebook_id and pb.pricebook_type = 2 WHERE cust.isenable=1 and cust.acct_id =9 AND IFNULL(cust_type,0)>=256 and ifnull(c_e.is_blacklist,0) = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022755861282349 -- 25-08-13 05:32:04[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/get_cont_item SELECT cont.cont_id,cont.cont_name,org.org_id department_id,org.org_name department,org.parent_id,cont.cont_account FROM dbsys.sys_contact cont LEFT JOIN dbsys.sys_org org ON org.org_id = cont.cont_deforgid WHERE cont.acct_id = 9 and cont.cont_isenable = 1 AND cont.cont_name like '%秦学习-南京办%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0206618309021 -- 25-08-13 05:32:04[秦学习-南京办-1240] -- /buz/oa/index.php/oamgmt/get_org_item SELECT o.org_id,o.org_name,p.org_name parent_name,o.parent_id FROM dbsys.sys_org o LEFT JOIN dbsys.sys_org p ON p.org_id = o.parent_id WHERE o.acct_id = 9 AND o.org_name like '%南京办事处%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017263174057007 -- 25-08-13 09:11:37[李振撼-1423] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1423 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019444942474365 -- 25-08-13 09:11:37[李振撼-1423] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1423 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015301942825317 -- 25-08-13 09:11:39[李振撼-1423] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1423 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019053936004639 -- 25-08-13 09:14:11[温文妙-1525] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%226342%22}&event=edit_officialSeals&officialSeals_id=6342 select o.*,c.cont_name apply_cont,org.org_name department,cr.cont_name createdby,up.cont_name updatedby, date_format(o.apply_date,'%Y-%m-%d') apply_date,14 appr_type_id,a.appr_proc_name, com.org_name seals_company from dboa.oa_officialSeals o left join dbsys.sys_contact c on o.apply_cont_id = c.cont_id left join dbsys.sys_org org on o.department_id = org.org_id left join dbsys.sys_contact cr on o.createdby_id = cr.cont_id left join dbsys.sys_contact up on o.updatedby_id = up.cont_id left join dboa.oa_appr_process a on o.appr_proc_id = a.appr_proc_id left join dbsys.sys_org com on o.seals_company_id = com.org_id where o.officialSeals_id = 6342 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037319660186768 -- 25-08-13 09:14:11[温文妙-1525] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%226342%22}&event=edit_officialSeals&officialSeals_id=6342 select org_id,org_name from dbsys.sys_org where corp_acct_id = 2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036060810089111 -- 25-08-13 09:14:11[温文妙-1525] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%226342%22}&event=edit_officialSeals&officialSeals_id=6342 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1525 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037140846252441 -- 25-08-13 09:14:11[温文妙-1525] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%226342%22}&event=edit_officialSeals&officialSeals_id=6342 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 = 5083719 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0035469532012939 -- 25-08-13 09:14:11[温文妙-1525] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_officialSeals%22,%22officialSeals_id%22:%226342%22}&event=edit_officialSeals&officialSeals_id=6342 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1525 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018539905548096 -- 25-08-13 09:20:23[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020235061645508 -- 25-08-13 09:20:25[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38541 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 = 38541 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044200420379639 -- 25-08-13 09:20:25[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38541 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38541 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044569969177246 -- 25-08-13 09:20:25[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38541 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 = 5064420 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038540363311768 -- 25-08-13 09:20:25[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38541 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040369033813477 -- 25-08-13 09:20:25[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38541 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 = 5064420 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038478374481201 -- 25-08-13 09:20:25[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38541 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.027539968490601 -- 25-08-13 09:20:26[高祥-33] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=38541 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017600059509277 -- 25-08-13 09:20:26[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026194095611572 -- 25-08-13 09:20:27[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38540 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 = 38540 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004392147064209 -- 25-08-13 09:20:27[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38540 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38540 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0043938159942627 -- 25-08-13 09:20:27[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38540 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 = 5064397 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039341449737549 -- 25-08-13 09:20:27[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38540 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040860176086426 -- 25-08-13 09:20:27[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38540 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 = 5064397 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003882884979248 -- 25-08-13 09:20:27[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38540 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021655082702637 -- 25-08-13 09:20:37[高祥-33] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=38540 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023147106170654 -- 25-08-13 09:20:38[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02160906791687 -- 25-08-13 09:20:39[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38539 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 = 38539 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0047340393066406 -- 25-08-13 09:20:39[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38539 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38539 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00478196144104 -- 25-08-13 09:20:39[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38539 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 = 5064378 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.004237174987793 -- 25-08-13 09:20:39[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38539 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0044357776641846 -- 25-08-13 09:20:39[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38539 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 = 5064378 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042200088500977 -- 25-08-13 09:20:39[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38539 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019686937332153 -- 25-08-13 09:20:44[高祥-33] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=38539 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.023485898971558 -- 25-08-13 09:20:45[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019225835800171 -- 25-08-13 09:33:54[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026043176651001 -- 25-08-13 09:33:55[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38619 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 = 38619 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036249160766602 -- 25-08-13 09:33:55[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38619 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38619 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040369033813477 -- 25-08-13 09:33:55[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38619 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 = 5077837 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034561157226562 -- 25-08-13 09:33:55[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38619 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036411285400391 -- 25-08-13 09:33:55[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38619 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 = 5077837 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034580230712891 -- 25-08-13 09:33:55[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38619 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021646976470947 -- 25-08-13 09:33:56[高祥-33] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=38619 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02783989906311 -- 25-08-13 09:33:57[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015097856521606 -- 25-08-13 09:33:58[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38618 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 = 38618 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034499168395996 -- 25-08-13 09:33:58[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38618 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38618 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034260749816895 -- 25-08-13 09:33:58[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38618 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 = 5077831 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029079914093018 -- 25-08-13 09:33:58[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38618 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031750202178955 -- 25-08-13 09:33:58[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38618 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 = 5077831 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002932071685791 -- 25-08-13 09:33:58[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38618 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020192861557007 -- 25-08-13 09:33:58[高祥-33] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=38618 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02913498878479 -- 25-08-13 09:33:59[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024816989898682 -- 25-08-13 09:34:00[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38551 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 = 38551 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0053949356079102 -- 25-08-13 09:34:00[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38551 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38551 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0053291320800781 -- 25-08-13 09:34:00[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38551 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 = 5067920 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048120021820068 -- 25-08-13 09:34:00[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38551 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0049879550933838 -- 25-08-13 09:34:00[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38551 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 = 5067920 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0048229694366455 -- 25-08-13 09:34:00[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38551 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.031412124633789 -- 25-08-13 09:34:00[高祥-33] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=38551 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016647100448608 -- 25-08-13 09:34:01[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021086931228638 -- 25-08-13 09:34:01[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38516 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 = 38516 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034549236297607 -- 25-08-13 09:34:01[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38516 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38516 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034229755401611 -- 25-08-13 09:34:01[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38516 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 = 5059218 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029289722442627 -- 25-08-13 09:34:01[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38516 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0031058788299561 -- 25-08-13 09:34:02[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38516 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 = 5059218 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029330253601074 -- 25-08-13 09:34:02[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38516 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024547100067139 -- 25-08-13 09:34:02[高祥-33] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=38516 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019045829772949 -- 25-08-13 09:34:03[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030993938446045 -- 25-08-13 09:34:04[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38512 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 = 38512 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039129257202148 -- 25-08-13 09:34:04[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38512 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38512 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039510726928711 -- 25-08-13 09:34:04[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38512 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 = 5058516 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037858486175537 -- 25-08-13 09:34:04[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38512 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040161609649658 -- 25-08-13 09:34:04[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38512 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 = 5058516 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037989616394043 -- 25-08-13 09:34:04[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38512 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016391038894653 -- 25-08-13 09:34:04[高祥-33] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=38512 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021817922592163 -- 25-08-13 09:34:05[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019675970077515 -- 25-08-13 09:34:06[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38510 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 = 38510 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039520263671875 -- 25-08-13 09:34:06[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38510 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38510 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039329528808594 -- 25-08-13 09:34:06[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38510 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 = 5058411 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037729740142822 -- 25-08-13 09:34:06[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38510 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040180683135986 -- 25-08-13 09:34:06[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38510 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 = 5058411 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037791728973389 -- 25-08-13 09:34:06[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38510 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018165111541748 -- 25-08-13 09:34:07[高祥-33] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=38510 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017107009887695 -- 25-08-13 09:34:07[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019223928451538 -- 25-08-13 09:34:08[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38509 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 = 38509 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038480758666992 -- 25-08-13 09:34:08[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38509 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38509 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00388503074646 -- 25-08-13 09:34:08[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38509 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 = 5058353 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037541389465332 -- 25-08-13 09:34:08[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38509 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039219856262207 -- 25-08-13 09:34:08[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38509 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 = 5058353 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003741979598999 -- 25-08-13 09:34:08[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38509 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026340007781982 -- 25-08-13 09:34:09[高祥-33] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=38509 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021175146102905 -- 25-08-13 09:34:09[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.024508953094482 -- 25-08-13 09:34:11[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38508 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 = 38508 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036799907684326 -- 25-08-13 09:34:11[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38508 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38508 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037329196929932 -- 25-08-13 09:34:11[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38508 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 = 5058278 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032148361206055 -- 25-08-13 09:34:11[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38508 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034070014953613 -- 25-08-13 09:34:11[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38508 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 = 5058278 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032150745391846 -- 25-08-13 09:34:11[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38508 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.030757904052734 -- 25-08-13 09:34:13[高祥-33] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=38508 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01955509185791 -- 25-08-13 09:34:13[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019254207611084 -- 25-08-13 09:34:14[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38506 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 = 38506 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042498111724854 -- 25-08-13 09:34:14[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38506 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 38506 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0042591094970703 -- 25-08-13 09:34:14[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38506 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 = 5058127 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037341117858887 -- 25-08-13 09:34:14[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38506 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039768218994141 -- 25-08-13 09:34:14[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38506 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 = 5058127 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0037398338317871 -- 25-08-13 09:34:14[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=38506 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018131017684937 -- 25-08-13 09:34:15[高祥-33] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=38506 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0205979347229 -- 25-08-13 09:34:16[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 33 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------