Time: 0.0089700222015381 -- 26-04-05 00:05:25[彭铸-825] -- /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.0018069744110107 -- 26-04-05 00:05:25[彭铸-825] -- /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 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018479824066162 -- 26-04-05 00:05:25[彭铸-825] -- /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 = 825 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036671161651611 -- 26-04-05 00:05:25[彭铸-825] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 825,updatedby_id = 825 where extrafareApply_id = 75178 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0036680698394775 -- 26-04-05 00:05:25[彭铸-825] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 825,updatedby_id = 825 where otherfee_id = 73584 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016572952270508 -- 26-04-05 00:05:26[彭铸-825] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 825 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0081861019134521 -- 26-04-05 00:05:26[彭铸-825] -- /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.0015678405761719 -- 26-04-05 00:05:26[彭铸-825] -- /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 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001572847366333 -- 26-04-05 00:05:26[彭铸-825] -- /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 = 825 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028419494628906 -- 26-04-05 00:05:26[彭铸-825] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 825,updatedby_id = 825 where extrafareApply_id = 75178 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026068687438965 -- 26-04-05 00:05:26[彭铸-825] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 825,updatedby_id = 825 where otherfee_id = 73584 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014194965362549 -- 26-04-05 00:05:26[彭铸-825] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 825 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00844407081604 -- 26-04-05 08:22:30[黄元达-377] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 377 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0081949234008789 -- 26-04-05 08:22:31[黄元达-377] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 377 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020519971847534 -- 26-04-05 08:22:33[黄元达-377] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 377 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017321109771729 -- 26-04-05 08:23:33[黄元达-377] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 377 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090551376342773 -- 26-04-05 08:23:34[黄元达-377] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 377 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016615867614746 -- 26-04-05 08:23:35[黄元达-377] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 377 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00895094871521 -- 26-04-05 08:23:45[黄元达-377] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 377 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014133930206299 -- 26-04-05 08:23:45[黄元达-377] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 377 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013181924819946 -- 26-04-05 08:23:46[黄元达-377] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 377 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0098240375518799 -- 26-04-05 09:35:41 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0091300010681152 -- 26-04-05 09:35:41 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023410320281982 -- 26-04-05 09:35:41 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028610229492188 -- 26-04-05 09:35:41 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='ZhangTiHai' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020191669464111 -- 26-04-05 09:35:41[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 23 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01230788230896 -- 26-04-05 09:35:43[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017712116241455 -- 26-04-05 09:43:40[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019156932830811 -- 26-04-05 11:23:45[张体海-1176] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 1176 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0073919296264648 -- 26-04-05 12:08:20[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014309883117676 -- 26-04-05 12:08:20[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003140926361084 -- 26-04-05 12:08:20[张民彦-2462] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2462,updatedby_id = 2462 where extrafareApply_id = 75179 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0082111358642578 -- 26-04-05 12:09:14[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015840530395508 -- 26-04-05 12:09:14[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028290748596191 -- 26-04-05 12:09:14[张民彦-2462] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2462,updatedby_id = 2462 where extrafareApply_id = 75179 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0040390491485596 -- 26-04-05 12:09:14[张民彦-2462] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2462,updatedby_id = 2462 where otherfee_id = 8580 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019162893295288 -- 26-04-05 12:09:17[张民彦-2462] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083410739898682 -- 26-04-05 12:11:16[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015718936920166 -- 26-04-05 12:11:16[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030431747436523 -- 26-04-05 12:11:16[张民彦-2462] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2462,updatedby_id = 2462 where extrafareApply_id = 75179 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025689601898193 -- 26-04-05 12:11:16[张民彦-2462] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2462,updatedby_id = 2462 where otherfee_id = 8580 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0080289840698242 -- 26-04-05 12:11:21[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015299320220947 -- 26-04-05 12:11:21[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033910274505615 -- 26-04-05 12:11:21[张民彦-2462] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2462,updatedby_id = 2462 where extrafareApply_id = 75179 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025370121002197 -- 26-04-05 12:11:21[张民彦-2462] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2462,updatedby_id = 2462 where otherfee_id = 8580 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0070128440856934 -- 26-04-05 12:11:23[张民彦-2462] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013329982757568 -- 26-04-05 12:11:23[张民彦-2462] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0095980167388916 -- 26-04-05 12:11:37[张民彦-2462] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.007767915725708 -- 26-04-05 12:13:11[张民彦-2462] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015051364898682 -- 26-04-05 12:13:11[张民彦-2462] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010216951370239 -- 26-04-05 12:13:16[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016019344329834 -- 26-04-05 12:13:16[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027461051940918 -- 26-04-05 12:13:16[张民彦-2462] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2462,updatedby_id = 2462 where extrafareApply_id = 75179 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025680065155029 -- 26-04-05 12:13:16[张民彦-2462] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2462,updatedby_id = 2462 where otherfee_id = 8580 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0081760883331299 -- 26-04-05 12:13:16[张民彦-2462] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015300035476685 -- 26-04-05 12:13:16[张民彦-2462] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0082049369812012 -- 26-04-05 12:13:25[张民彦-2462] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.007598876953125 -- 26-04-05 12:15:28[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014297962188721 -- 26-04-05 12:15:28[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026371479034424 -- 26-04-05 12:15:28[张民彦-2462] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2462,updatedby_id = 2462 where extrafareApply_id = 75180 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02091908454895 -- 26-04-05 12:16:49[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015199184417725 -- 26-04-05 12:16:49[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029239654541016 -- 26-04-05 12:16:49[张民彦-2462] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2462,updatedby_id = 2462 where extrafareApply_id = 75180 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026249885559082 -- 26-04-05 12:16:49[张民彦-2462] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2462,updatedby_id = 2462 where otherfee_id = 8581 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0094289779663086 -- 26-04-05 14:14:08[蔡易辰-2674] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 and e.extrafare_name like '%停车费%' limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012808084487915 -- 26-04-05 14:14:53[蔡易辰-2674] -- /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 = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017900466918945 -- 26-04-05 14:14:53[蔡易辰-2674] -- /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 = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032999515533447 -- 26-04-05 14:14:53[蔡易辰-2674] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2674,updatedby_id = 2674 where extrafareApply_id = 75181 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010281085968018 -- 26-04-05 14:17:11[胡元元-2384] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2247189%22}&event=edit_fareApply&fareApply_id=47189 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 = 47189 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0051689147949219 -- 26-04-05 14:17:11[胡元元-2384] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2247189%22}&event=edit_fareApply&fareApply_id=47189 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 47189 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0039839744567871 -- 26-04-05 14:17:11[胡元元-2384] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2247189%22}&event=edit_fareApply&fareApply_id=47189 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 = 6323814 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016210079193115 -- 26-04-05 14:17:11[胡元元-2384] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2247189%22}&event=edit_fareApply&fareApply_id=47189 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2384 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017170906066895 -- 26-04-05 14:17:11[胡元元-2384] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2247189%22}&event=edit_fareApply&fareApply_id=47189 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6323814 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015521049499512 -- 26-04-05 14:17:11[胡元元-2384] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2247189%22}&event=edit_fareApply&fareApply_id=47189 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2384 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018691062927246 -- 26-04-05 14:17:14[胡元元-2384] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2247188%22}&event=edit_fareApply&fareApply_id=47188 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 = 47188 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018558502197266 -- 26-04-05 14:17:14[胡元元-2384] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2247188%22}&event=edit_fareApply&fareApply_id=47188 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 47188 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018279552459717 -- 26-04-05 14:17:14[胡元元-2384] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2247188%22}&event=edit_fareApply&fareApply_id=47188 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 = 6323812 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013489723205566 -- 26-04-05 14:17:14[胡元元-2384] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2247188%22}&event=edit_fareApply&fareApply_id=47188 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2384 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014848709106445 -- 26-04-05 14:17:14[胡元元-2384] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2247188%22}&event=edit_fareApply&fareApply_id=47188 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6323812 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013618469238281 -- 26-04-05 14:17:14[胡元元-2384] -- /buz/oa/index.php/oamgmt/oa_approval?para={%22event%22:%22edit_fareApply%22,%22fareApply_id%22:%2247188%22}&event=edit_fareApply&fareApply_id=47188 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2384 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015045881271362 -- 26-04-05 14:18:33[蔡易辰-2674] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 and e.extrafare_name like '%停车费%' limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0088269710540771 -- 26-04-05 14:19:57[蔡易辰-2674] -- /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 = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017249584197998 -- 26-04-05 14:19:57[蔡易辰-2674] -- /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 = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0050809383392334 -- 26-04-05 14:19:57[蔡易辰-2674] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2674,updatedby_id = 2674 where extrafareApply_id = 75182 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.026458024978638 -- 26-04-05 14:20:23[蔡易辰-2674] -- /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 = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018260478973389 -- 26-04-05 14:20:23[蔡易辰-2674] -- /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 = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033538341522217 -- 26-04-05 14:20:23[蔡易辰-2674] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2674,updatedby_id = 2674 where extrafareApply_id = 75182 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0028560161590576 -- 26-04-05 14:20:23[蔡易辰-2674] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2674,updatedby_id = 2674 where otherfee_id = 8582 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017838001251221 -- 26-04-05 14:21:36[蔡易辰-2674] -- /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 = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016369819641113 -- 26-04-05 14:21:36[蔡易辰-2674] -- /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 = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032041072845459 -- 26-04-05 14:21:36[蔡易辰-2674] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2674,updatedby_id = 2674 where extrafareApply_id = 75182 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026669502258301 -- 26-04-05 14:21:36[蔡易辰-2674] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2674,updatedby_id = 2674 where otherfee_id = 8582 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01101016998291 -- 26-04-05 14:21:38[蔡易辰-2674] -- /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 = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017430782318115 -- 26-04-05 14:21:38[蔡易辰-2674] -- /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 = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032110214233398 -- 26-04-05 14:21:38[蔡易辰-2674] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2674,updatedby_id = 2674 where extrafareApply_id = 75182 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0029900074005127 -- 26-04-05 14:21:38[蔡易辰-2674] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2674,updatedby_id = 2674 where otherfee_id = 8582 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0089199542999268 -- 26-04-05 14:21:42[蔡易辰-2674] -- /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 = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017259120941162 -- 26-04-05 14:21:42[蔡易辰-2674] -- /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 = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034449100494385 -- 26-04-05 14:21:42[蔡易辰-2674] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2674,updatedby_id = 2674 where extrafareApply_id = 75182 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0038459300994873 -- 26-04-05 14:21:42[蔡易辰-2674] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2674,updatedby_id = 2674 where otherfee_id = 8582 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0080718994140625 -- 26-04-05 14:28:17[蔡易辰-2674] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 and e.extrafare_name like '%停车费%' limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0082838535308838 -- 26-04-05 14:29:37[蔡易辰-2674] -- /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 = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001594066619873 -- 26-04-05 14:29:37[蔡易辰-2674] -- /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 = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002856969833374 -- 26-04-05 14:29:37[蔡易辰-2674] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2674,updatedby_id = 2674 where extrafareApply_id = 75183 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011822938919067 -- 26-04-05 14:30:02[蔡易辰-2674] -- /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 = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017151832580566 -- 26-04-05 14:30:02[蔡易辰-2674] -- /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 = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0030050277709961 -- 26-04-05 14:30:02[蔡易辰-2674] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2674,updatedby_id = 2674 where extrafareApply_id = 75183 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032708644866943 -- 26-04-05 14:30:02[蔡易辰-2674] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2674,updatedby_id = 2674 where otherfee_id = 8583 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0074350833892822 -- 26-04-05 14:30:14[蔡易辰-2674] -- /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 = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014410018920898 -- 26-04-05 14:30:14[蔡易辰-2674] -- /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 = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026490688323975 -- 26-04-05 14:30:14[蔡易辰-2674] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2674,updatedby_id = 2674 where extrafareApply_id = 75183 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027391910552979 -- 26-04-05 14:30:14[蔡易辰-2674] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2674,updatedby_id = 2674 where otherfee_id = 8583 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011951923370361 -- 26-04-05 14:30:16[蔡易辰-2674] -- /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 = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017900466918945 -- 26-04-05 14:30:16[蔡易辰-2674] -- /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 = 2674 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0034139156341553 -- 26-04-05 14:30:16[蔡易辰-2674] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dboa.oa_extrafareapply set createdby_id = 2674,updatedby_id = 2674 where extrafareApply_id = 75183 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.003115177154541 -- 26-04-05 14:30:16[蔡易辰-2674] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApply_application update dbthird.thd_otherfee set createdby_id = 2674,updatedby_id = 2674 where otherfee_id = 8583 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018228769302368 -- 26-04-05 15:09:54[张民彦-2462] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015099048614502 -- 26-04-05 15:09:54[张民彦-2462] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=delete_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0082478523254395 -- 26-04-05 15:11:28[张民彦-2462] -- /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 = 47 and cont.cont_isenable = 1 AND cont.cont_name like '%张民彦%' LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012665987014771 -- 26-04-05 15:11:32[张民彦-2462] -- /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 = 47 AND o.org_name like '%华南车队%' AND o.is_corporate = 0 LIMIT 0,50 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0073850154876709 -- 26-04-05 15:12:58[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014579296112061 -- 26-04-05 15:12:58[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012593984603882 -- 26-04-05 15:13:57[张民彦-2462] -- /buz/oa/index.php/oamgmt/get_extrafare_item select e.extrafare_name,e.extrafare_id,ifnull(dispConfig_json,'{}') dispConfig_json from dboa.oa_extrafare e left join dboa.oa_extrafareex_config e_c on e.extrafare_id = e_c.extrafare_id where e.acct_id = 47 limit 30 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013182878494263 -- 26-04-05 15:16:24[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017549991607666 -- 26-04-05 15:16:24[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.016963005065918 -- 26-04-05 15:16:27[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017759799957275 -- 26-04-05 15:16:27[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083990097045898 -- 26-04-05 15:16:46[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016250610351562 -- 26-04-05 15:16:47[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0097510814666748 -- 26-04-05 15:16:51[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001633882522583 -- 26-04-05 15:16:51[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012861013412476 -- 26-04-05 15:17:29[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015459060668945 -- 26-04-05 15:17:29[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014103174209595 -- 26-04-05 15:17:30[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017719268798828 -- 26-04-05 15:17:30[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020609855651855 -- 26-04-05 15:18:04[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016200542449951 -- 26-04-05 15:18:04[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021215915679932 -- 26-04-05 15:18:05[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013980865478516 -- 26-04-05 15:18:05[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.006976842880249 -- 26-04-05 15:18:06[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013301372528076 -- 26-04-05 15:18:07[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0086569786071777 -- 26-04-05 15:18:08[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016539096832275 -- 26-04-05 15:18:08[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.014144897460938 -- 26-04-05 15:18:25[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001533031463623 -- 26-04-05 15:18:25[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.025791883468628 -- 26-04-05 15:18:27[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016489028930664 -- 26-04-05 15:18:27[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013262033462524 -- 26-04-05 15:18:27[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018069744110107 -- 26-04-05 15:18:27[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0082042217254639 -- 26-04-05 15:18:46[张民彦-2462] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015718936920166 -- 26-04-05 15:18:46[张民彦-2462] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=save_extrafareApplyItem select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0085790157318115 -- 26-04-05 15:18:49[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016460418701172 -- 26-04-05 15:18:49[张民彦-2462] -- /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 = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0077950954437256 -- 26-04-05 15:18:49[张民彦-2462] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0076501369476318 -- 26-04-05 15:18:49[张民彦-2462] -- /buz/oa/index.php/oamgmt/oa_application?event=get_apprProcCombo select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0074479579925537 -- 26-04-05 15:18:52[张民彦-2462] -- /buz/oa/index.php/oamgmt/oa_application?event=submit select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2462 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012290000915527 -- 26-04-05 16:22:18 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014679431915283 -- 26-04-05 16:22:18 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020239353179932 -- 26-04-05 16:22:18 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='WangXiang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017001628875732 -- 26-04-05 16:22:18[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 23 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.008552074432373 -- 26-04-05 16:22:18[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.007235050201416 -- 26-04-05 16:22:21[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125161 SELECT p.*,c.cont_name apply_cont,o.org_name department,13 appr_type_id FROM dboa.oa_payment p LEFT JOIN dbsys.sys_contact c on p.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON p.department_id = o.org_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id WHERE payment_id = 125161 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014100074768066 -- 26-04-05 16:22:21[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125161 select payment_id from dbthird.thd_payment where oa_payment_id = 125161 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019550323486328 -- 26-04-05 16:22:21[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125161 SELECT s.*,cust.cust_name carrier FROM dbthird.thd_statement s LEFT JOIN dbthird.thd_customer cust ON cust.customer_id = s.customer_id WHERE s.payment_id = 139868 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018601417541504 -- 26-04-05 16:22:21[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125161 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 = 6325825 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012979507446289 -- 26-04-05 16:22:21[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125161 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014140605926514 -- 26-04-05 16:22:21[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125161 select * from dbsys.sys_contact where cont_id = 928 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014059543609619 -- 26-04-05 16:22:21[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125161 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6325825 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013020038604736 -- 26-04-05 16:22:21[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125161 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012798309326172 -- 26-04-05 16:22:21[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125161 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013341903686523 -- 26-04-05 16:22:21[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125161 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.012210130691528 -- 26-04-05 16:24:07[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01318097114563 -- 26-04-05 16:24:08[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125149 SELECT p.*,c.cont_name apply_cont,o.org_name department,13 appr_type_id FROM dboa.oa_payment p LEFT JOIN dbsys.sys_contact c on p.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON p.department_id = o.org_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id WHERE payment_id = 125149 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014820098876953 -- 26-04-05 16:24:08[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125149 select payment_id from dbthird.thd_payment where oa_payment_id = 125149 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015799999237061 -- 26-04-05 16:24:08[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125149 SELECT s.*,cust.cust_name carrier FROM dbthird.thd_statement s LEFT JOIN dbthird.thd_customer cust ON cust.customer_id = s.customer_id WHERE s.payment_id = 139866 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019290447235107 -- 26-04-05 16:24:08[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125149 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 = 6325515 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013830661773682 -- 26-04-05 16:24:08[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125149 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015139579772949 -- 26-04-05 16:24:08[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125149 select * from dbsys.sys_contact where cont_id = 928 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015091896057129 -- 26-04-05 16:24:08[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125149 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6325515 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013599395751953 -- 26-04-05 16:24:08[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125149 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013649463653564 -- 26-04-05 16:24:08[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125149 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013930797576904 -- 26-04-05 16:24:08[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125149 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083279609680176 -- 26-04-05 16:24:10[王翔-928] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=125149 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083491802215576 -- 26-04-05 16:24:10[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015372037887573 -- 26-04-05 16:24:12[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125071 SELECT p.*,c.cont_name apply_cont,o.org_name department,13 appr_type_id FROM dboa.oa_payment p LEFT JOIN dbsys.sys_contact c on p.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON p.department_id = o.org_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id WHERE payment_id = 125071 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002249002456665 -- 26-04-05 16:24:12[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125071 select payment_id from dbthird.thd_payment where oa_payment_id = 125071 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002100944519043 -- 26-04-05 16:24:12[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125071 SELECT s.*,cust.cust_name carrier FROM dbthird.thd_statement s LEFT JOIN dbthird.thd_customer cust ON cust.customer_id = s.customer_id WHERE s.payment_id = 139823 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020720958709717 -- 26-04-05 16:24:12[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125071 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 = 6323176 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016131401062012 -- 26-04-05 16:24:12[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125071 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016450881958008 -- 26-04-05 16:24:12[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125071 select * from dbsys.sys_contact where cont_id = 928 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017659664154053 -- 26-04-05 16:24:12[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125071 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6323176 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016129016876221 -- 26-04-05 16:24:12[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125071 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016121864318848 -- 26-04-05 16:24:12[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125071 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016059875488281 -- 26-04-05 16:24:12[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125071 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0083980560302734 -- 26-04-05 16:24:15[王翔-928] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=125071 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022251129150391 -- 26-04-05 16:24:15[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.015531063079834 -- 26-04-05 16:24:16[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=47206 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 = 47206 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014941692352295 -- 26-04-05 16:24:16[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=47206 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 47206 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015020370483398 -- 26-04-05 16:24:16[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=47206 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 = 6325815 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013830661773682 -- 26-04-05 16:24:16[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=47206 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001535177230835 -- 26-04-05 16:24:16[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=47206 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6325815 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013811588287354 -- 26-04-05 16:24:16[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=47206 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018093824386597 -- 26-04-05 16:24:17[王翔-928] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=47206 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013475894927979 -- 26-04-05 16:24:17[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0075249671936035 -- 26-04-05 16:32:52[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125161 SELECT p.*,c.cont_name apply_cont,o.org_name department,13 appr_type_id FROM dboa.oa_payment p LEFT JOIN dbsys.sys_contact c on p.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON p.department_id = o.org_id LEFT JOIN dbthird.v_thd_customer receiving ON p.receiving_unit_id = receiving.sys_cust_id WHERE payment_id = 125161 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014519691467285 -- 26-04-05 16:32:52[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125161 select payment_id from dbthird.thd_payment where oa_payment_id = 125161 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014529228210449 -- 26-04-05 16:32:52[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125161 SELECT s.*,cust.cust_name carrier FROM dbthird.thd_statement s LEFT JOIN dbthird.thd_customer cust ON cust.customer_id = s.customer_id WHERE s.payment_id = 139868 AND s.payment_id > 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014638900756836 -- 26-04-05 16:32:52[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125161 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 = 6325825 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0013680458068848 -- 26-04-05 16:32:52[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125161 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014560222625732 -- 26-04-05 16:32:52[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125161 select * from dbsys.sys_contact where cont_id = 928 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014941692352295 -- 26-04-05 16:32:52[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125161 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6325825 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001291036605835 -- 26-04-05 16:32:52[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125161 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0012960433959961 -- 26-04-05 16:32:52[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125161 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001323938369751 -- 26-04-05 16:32:52[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_payment&payment_id=125161 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0085561275482178 -- 26-04-05 16:33:39[王翔-928] -- /buz/oa/index.php/oamgmt/payment_application?event=approve&payment_id=125161 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0081839561462402 -- 26-04-05 16:33:39[王翔-928] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 928 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02321195602417 -- 26-04-05 17:05:15 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018508434295654 -- 26-04-05 17:05:15 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0027098655700684 -- 26-04-05 17:05:15 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='ZhangYong' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019881725311279 -- 26-04-05 17:05:15[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.009821891784668 -- 26-04-05 17:05:16[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0137619972229 -- 26-04-05 17:05:20[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46396 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 = 46396 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002065896987915 -- 26-04-05 17:05:20[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46396 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 46396 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020461082458496 -- 26-04-05 17:05:20[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46396 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 = 6236658 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014810562133789 -- 26-04-05 17:05:20[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46396 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016329288482666 -- 26-04-05 17:05:20[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46396 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6236658 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014870166778564 -- 26-04-05 17:05:20[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46396 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0070090293884277 -- 26-04-05 17:05:21[张勇-2549] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=46396 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018739938735962 -- 26-04-05 17:05:22[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.020425796508789 -- 26-04-05 17:05:23[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46403 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 = 46403 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00205397605896 -- 26-04-05 17:05:23[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46403 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 46403 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002079963684082 -- 26-04-05 17:05:23[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46403 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 = 6236700 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015630722045898 -- 26-04-05 17:05:23[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46403 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017549991607666 -- 26-04-05 17:05:23[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46403 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6236700 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015771389007568 -- 26-04-05 17:05:23[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46403 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017434120178223 -- 26-04-05 17:05:24[张勇-2549] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=46403 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017078876495361 -- 26-04-05 17:05:25[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0157151222229 -- 26-04-05 17:05:26[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46913 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 = 46913 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023210048675537 -- 26-04-05 17:05:26[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46913 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 46913 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022048950195312 -- 26-04-05 17:05:26[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46913 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 = 6300893 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017168521881104 -- 26-04-05 17:05:26[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46913 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018651485443115 -- 26-04-05 17:05:26[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46913 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6300893 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017130374908447 -- 26-04-05 17:05:26[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46913 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01960301399231 -- 26-04-05 17:05:27[张勇-2549] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=46913 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.011165142059326 -- 26-04-05 17:05:28[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018356084823608 -- 26-04-05 17:05:29[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46919 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 = 46919 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020029544830322 -- 26-04-05 17:05:29[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46919 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 46919 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020220279693604 -- 26-04-05 17:05:29[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46919 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 = 6304243 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015361309051514 -- 26-04-05 17:05:29[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46919 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002234935760498 -- 26-04-05 17:05:29[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46919 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6304243 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015368461608887 -- 26-04-05 17:05:29[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=46919 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0093939304351807 -- 26-04-05 17:05:30[张勇-2549] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=46919 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0073308944702148 -- 26-04-05 17:05:30[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.01249885559082 -- 26-04-05 17:05:32[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=47095 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 = 47095 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020368099212646 -- 26-04-05 17:05:32[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=47095 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 47095 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019900798797607 -- 26-04-05 17:05:32[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=47095 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 = 6317847 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015230178833008 -- 26-04-05 17:05:32[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=47095 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021040439605713 -- 26-04-05 17:05:32[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=47095 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6317847 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015208721160889 -- 26-04-05 17:05:32[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=47095 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013968944549561 -- 26-04-05 17:05:34[张勇-2549] -- /buz/oa/index.php/oamgmt/fareApply_application?event=approve&fareApply_id=47095 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010123014450073 -- 26-04-05 17:05:34[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017235994338989 -- 26-04-05 17:05:35[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=47103 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 = 47103 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018441677093506 -- 26-04-05 17:05:35[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=47103 SELECT * FROM dboa.oa_fareApply_item WHERE fareApply_id = 47103 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018360614776611 -- 26-04-05 17:05:35[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=47103 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 = 6318021 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017280578613281 -- 26-04-05 17:05:35[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=47103 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0024712085723877 -- 26-04-05 17:05:36[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=47103 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6318021 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017020702362061 -- 26-04-05 17:05:36[张勇-2549] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_fareApply&fareApply_id=47103 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2549 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0085959434509277 -- 26-04-05 17:09:34 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016138553619385 -- 26-04-05 17:09:34 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025041103363037 -- 26-04-05 17:09:34 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='LiuXiaoJin' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017490386962891 -- 26-04-05 17:09:34[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 49 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0068950653076172 -- 26-04-05 17:09:35[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0099160671234131 -- 26-04-05 17:09:39[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75154 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 75154 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001823902130127 -- 26-04-05 17:09:39[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75154 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 75154 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020630359649658 -- 26-04-05 17:09:39[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75154 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 75154 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033919811248779 -- 26-04-05 17:09:39[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75154 SELECT efa_tsl.extrafareapply_tslorder_id recid,efa.status_id,o.order_id,o.order_no,r.route_name,o.order_date,14 as buzSystem_id, w_sl.copilot_driver,w.driver,w.truck_no FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_tslorder efa_tsl ON efa_tsl.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbtsl.tsl_order o ON efa_tsl.order_id = o.order_id LEFT JOIN dbtsl.tsl_orderex_ftl o_ftl ON o.order_id = o_ftl.order_id LEFT JOIN dbtsl.tsl_route r ON o_ftl.route_id = r.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id WHERE efa.extrafareApply_id = 75154 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016400814056396 -- 26-04-05 17:09:39[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75154 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016429424285889 -- 26-04-05 17:09:39[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75154 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017781257629395 -- 26-04-05 17:09:39[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75154 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6326394 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016100406646729 -- 26-04-05 17:09:39[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75154 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016078948974609 -- 26-04-05 17:09:39[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75154 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0092668533325195 -- 26-04-05 17:09:42[刘晓进-2544] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=75154 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0093080997467041 -- 26-04-05 17:09:42[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0081820487976074 -- 26-04-05 17:09:44[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75152 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 75152 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016930103302002 -- 26-04-05 17:09:44[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75152 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 75152 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016131401062012 -- 26-04-05 17:09:44[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75152 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 75152 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017809867858887 -- 26-04-05 17:09:44[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75152 SELECT efa_tsl.extrafareapply_tslorder_id recid,efa.status_id,o.order_id,o.order_no,r.route_name,o.order_date,14 as buzSystem_id, w_sl.copilot_driver,w.driver,w.truck_no FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_tslorder efa_tsl ON efa_tsl.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbtsl.tsl_order o ON efa_tsl.order_id = o.order_id LEFT JOIN dbtsl.tsl_orderex_ftl o_ftl ON o.order_id = o_ftl.order_id LEFT JOIN dbtsl.tsl_route r ON o_ftl.route_id = r.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id WHERE efa.extrafareApply_id = 75152 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015060901641846 -- 26-04-05 17:09:44[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75152 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015201568603516 -- 26-04-05 17:09:44[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75152 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017800331115723 -- 26-04-05 17:09:45[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75152 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6326391 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015101432800293 -- 26-04-05 17:09:45[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75152 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0014669895172119 -- 26-04-05 17:09:45[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75152 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0079829692840576 -- 26-04-05 17:09:46[刘晓进-2544] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=75152 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021492958068848 -- 26-04-05 17:09:46[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0084550380706787 -- 26-04-05 17:09:47[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75150 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 75150 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017621517181396 -- 26-04-05 17:09:47[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75150 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 75150 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016391277313232 -- 26-04-05 17:09:47[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75150 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 75150 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018429756164551 -- 26-04-05 17:09:47[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75150 SELECT efa_tsl.extrafareapply_tslorder_id recid,efa.status_id,o.order_id,o.order_no,r.route_name,o.order_date,14 as buzSystem_id, w_sl.copilot_driver,w.driver,w.truck_no FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_tslorder efa_tsl ON efa_tsl.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbtsl.tsl_order o ON efa_tsl.order_id = o.order_id LEFT JOIN dbtsl.tsl_orderex_ftl o_ftl ON o.order_id = o_ftl.order_id LEFT JOIN dbtsl.tsl_route r ON o_ftl.route_id = r.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id WHERE efa.extrafareApply_id = 75150 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015361309051514 -- 26-04-05 17:09:47[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75150 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015771389007568 -- 26-04-05 17:09:47[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75150 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.001690149307251 -- 26-04-05 17:09:47[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75150 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6326382 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015430450439453 -- 26-04-05 17:09:47[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75150 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015370845794678 -- 26-04-05 17:09:47[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75150 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.013790130615234 -- 26-04-05 17:09:49[刘晓进-2544] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=75150 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0079960823059082 -- 26-04-05 17:09:50[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0087740421295166 -- 26-04-05 17:09:51[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75147 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 75147 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017430782318115 -- 26-04-05 17:09:51[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75147 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 75147 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019779205322266 -- 26-04-05 17:09:51[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75147 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 75147 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0026919841766357 -- 26-04-05 17:09:51[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75147 SELECT efa_tsl.extrafareapply_tslorder_id recid,efa.status_id,o.order_id,o.order_no,r.route_name,o.order_date,14 as buzSystem_id, w_sl.copilot_driver,w.driver,w.truck_no FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_tslorder efa_tsl ON efa_tsl.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbtsl.tsl_order o ON efa_tsl.order_id = o.order_id LEFT JOIN dbtsl.tsl_orderex_ftl o_ftl ON o.order_id = o_ftl.order_id LEFT JOIN dbtsl.tsl_route r ON o_ftl.route_id = r.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id WHERE efa.extrafareApply_id = 75147 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015180110931396 -- 26-04-05 17:09:51[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75147 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015649795532227 -- 26-04-05 17:09:51[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75147 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016989707946777 -- 26-04-05 17:09:51[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75147 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6326363 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015339851379395 -- 26-04-05 17:09:51[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75147 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015120506286621 -- 26-04-05 17:09:51[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75147 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0090398788452148 -- 26-04-05 17:09:53[刘晓进-2544] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=75147 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0069971084594727 -- 26-04-05 17:09:53[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.021332979202271 -- 26-04-05 17:09:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75146 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 75146 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0021910667419434 -- 26-04-05 17:09:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75146 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 75146 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020499229431152 -- 26-04-05 17:09:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75146 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 75146 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0033960342407227 -- 26-04-05 17:09:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75146 SELECT efa_tsl.extrafareapply_tslorder_id recid,efa.status_id,o.order_id,o.order_no,r.route_name,o.order_date,14 as buzSystem_id, w_sl.copilot_driver,w.driver,w.truck_no FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_tslorder efa_tsl ON efa_tsl.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbtsl.tsl_order o ON efa_tsl.order_id = o.order_id LEFT JOIN dbtsl.tsl_orderex_ftl o_ftl ON o.order_id = o_ftl.order_id LEFT JOIN dbtsl.tsl_route r ON o_ftl.route_id = r.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id WHERE efa.extrafareApply_id = 75146 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016109943389893 -- 26-04-05 17:09:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75146 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016460418701172 -- 26-04-05 17:09:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75146 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017940998077393 -- 26-04-05 17:09:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75146 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6326361 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016350746154785 -- 26-04-05 17:09:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75146 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016331672668457 -- 26-04-05 17:09:56[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=75146 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.02148699760437 -- 26-04-05 17:09:58[刘晓进-2544] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=75146 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.019421815872192 -- 26-04-05 17:09:59[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.010728120803833 -- 26-04-05 17:10:00[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=74822 select extrafareApply_tslorder_id from dboa.oa_extrafareapply_tslorder where extrafareApply_id = 74822 and order_id > 1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017590522766113 -- 26-04-05 17:10:00[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=74822 SELECT r.*,c.cont_name apply_cont,o.org_name department,3 appr_type_id FROM dboa.oa_extrafareApply r LEFT JOIN dbsys.sys_contact c on r.apply_cont_id = c.cont_id LEFT JOIN dbsys.sys_org o ON r.department_id = o.org_id WHERE extrafareApply_id = 74822 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0025432109832764 -- 26-04-05 17:10:00[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=74822 SELECT * FROM dboa.oa_extrafareApply_item WHERE extrafareApply_id = 74822 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0032310485839844 -- 26-04-05 17:10:00[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=74822 SELECT efa_tsl.extrafareapply_tslorder_id recid,efa.status_id,o.order_id,o.order_no,r.route_name,o.order_date,14 as buzSystem_id, w_sl.copilot_driver,w.driver,w.truck_no FROM dboa.oa_extrafareApply efa LEFT JOIN dboa.oa_extrafareapply_tslorder efa_tsl ON efa_tsl.extrafareApply_id = efa.extrafareApply_id LEFT JOIN dbtsl.tsl_order o ON efa_tsl.order_id = o.order_id LEFT JOIN dbtsl.tsl_orderex_ftl o_ftl ON o.order_id = o_ftl.order_id LEFT JOIN dbtsl.tsl_route r ON o_ftl.route_id = r.route_id left join dbtsl.tsl_work w on efa_tsl.work_id = w.work_id left join dbtsl.tsl_workex_specline w_sl on w_sl.work_id = w.work_id WHERE efa.extrafareApply_id = 74822 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015189647674561 -- 26-04-05 17:10:00[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=74822 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015552043914795 -- 26-04-05 17:10:00[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=74822 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016779899597168 -- 26-04-05 17:10:00[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=74822 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6296965 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015268325805664 -- 26-04-05 17:10:00[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=74822 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0015199184417725 -- 26-04-05 17:10:00[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=edit_extrafareApply&extrafareApply_id=74822 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017509937286377 -- 26-04-05 17:10:03[刘晓进-2544] -- /buz/oa/index.php/oamgmt/extrafareApply_application?event=approve&extrafareApply_id=74822 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0092728137969971 -- 26-04-05 17:10:03[刘晓进-2544] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 2544 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.022324085235596 -- 26-04-05 18:16:22 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018520355224609 -- 26-04-05 18:16:22 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.002345085144043 -- 26-04-05 18:16:22 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='GaoXiang' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.00199294090271 -- 26-04-05 18:16:22[高祥-33] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 2 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0081450939178467 -- 26-04-05 18:16:22[高祥-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 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0093309879302979 -- 26-04-05 19:39:12 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_type_id from dbwechat.wechat_publicno where appid='ww5262fb147810c303' limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018270015716553 -- 26-04-05 19:39:12 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0023889541625977 -- 26-04-05 19:39:12 -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='ZhangJin' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0020620822906494 -- 26-04-05 19:39:12[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.017103910446167 -- 26-04-05 19:39:14[张进-414] -- /buz/oa/index.php/oamgmt/oa_approval?event=query select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 414 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.009099006652832 -- 26-04-05 21:50:49 -- /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.0016989707946777 -- 26-04-05 21:50:49 -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select publicno_id,is_oneUser_forMultiOpenid from dbwechat.wechat_publicno p where p.appid='ww5262fb147810c303' and isenable=1 and publicno_type_id=2 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0022919178009033 -- 26-04-05 21:50:49 -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select b.cont_id, c.cont_name, c.acct_id, c.cont_password from dbwechat.wechat_describe b left join dbsys.sys_contact c on b.cont_id = c.cont_id where openid='WangYuan' and b.cont_id >1 and c.cont_isenable = 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0019259452819824 -- 26-04-05 21:50:49[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?appid=ww5262fb147810c303&agentid=1000004 select tag, para_value from dbsys.v_sys_acct_para where is_valid=1 and acct_id= 5 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0088450908660889 -- 26-04-05 21:50:49[王元-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.0080220699310303 -- 26-04-05 21:50:49[王元-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.0037198066711426 -- 26-04-05 21:50:49[王元-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.0028378963470459 -- 26-04-05 21:50:49[王元-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.0031180381774902 -- 26-04-05 21:50:49[王元-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.010411024093628 -- 26-04-05 21:50:53[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=47118 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 = 47118 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0017108917236328 -- 26-04-05 21:50:53[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=47118 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0018620491027832 -- 26-04-05 21:50:53[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=47118 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6319387 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016148090362549 -- 26-04-05 21:50:53[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=47118 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016019344329834 -- 26-04-05 21:50:53[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=47118 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016720294952393 -- 26-04-05 21:50:53[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=47118 select file_id,file_url,file_ext,thumb_file_url,file_type_id,remark from dbpublic.pbl_upload_file where owner_id=6319387 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.0016000270843506 -- 26-04-05 21:50:53[王元-300] -- /buz/oa/index.php/oamgmt/oa_application?event=edit_fareApply&fareApply_id=47118 select acct_id, cont_id, cont_edikey from dbsys.sys_contact where cont_id = 300 and cont_isenable=1 limit 1 ------------------------------------------------------------------------------------------------------------------------------------------------------ Time: 0.018617868423462 -- 26-04-05 21:50:53[王元-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.013170003890991 -- 26-04-05 21:50:54[王元-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.01898193359375 -- 26-04-05 21:50:54[王元-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.0092830657958984 -- 26-04-05 21:50:54[王元-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.0092360973358154 -- 26-04-05 21:50:54[王元-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.0018141269683838 -- 26-04-05 21:50:54[王元-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.0084290504455566 -- 26-04-05 21:50:58[王元-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.0061779022216797 -- 26-04-05 21:50:58[王元-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.0016961097717285 -- 26-04-05 21:50:58[王元-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.0020370483398438 -- 26-04-05 21:50:58[王元-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.0019748210906982 -- 26-04-05 21:50:58[王元-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() ) ------------------------------------------------------------------------------------------------------------------------------------------------------