/saveStateChange.* ajax POST |
|
3,070
|
9,437
|
2,287
|
474
|
149,060
|
0.00
|
203
|
2,419
|
select sdservicer0_.ProblemId as ProblemI1_264_0_, sdservicer0_.AlertID as AlertID2_264_0_, sdservicer0_.AlternativeEmail as Alternat3_264_0_, sdservicer0_.ApprovalManager as Approval4_264_0_, sdservicer0_.AssetNumber as AssetNum5_264_0_, sdservicer0_.Attachment as Attachme6_264_0_, sdservicer0_.Category as Category7_264_0_, sdservicer0_.CcMailId as CcMailId8_264_0_, sdservicer0_.ContactNumber as ContactN9_264_0_, sdservicer0_.ConversionType as Convers10_264_0_, sdservicer0_.CreationTime as Creatio11_264_0_, sdservicer0_.CSI as CSI12_264_0_, sdservicer0_.CurrentStatus as Current13_264_0_, sdservicer0_.DelegatedFrom_ApprovalManager as Delegat14_264_0_, sdservicer0_.DelegatedFrom_Owner as Delegat15_264_0_, sdservicer0_.DepartmentID as Departm16_264_0_, sdservicer0_.DerivedField1 as Derived17_264_0_, sdservicer0_.DerivedField2 as Derived18_264_0_, sdservicer0_.DerivedField3 as Derived19_264_0_, sdservicer0_.Enclosure as Enclosu20_264_0_, sdservicer0_.ExpectedClosureTime as Expecte21_264_0_, sdservicer0_.GroupID as GroupID22_264_0_, sdservicer0_.ImpactID as ImpactI23_264_0_, sdservicer0_.IncidentType as Inciden24_264_0_, sdservicer0_.isLinked as isLinke25_264_0_, sdservicer0_.IsRead as IsRead26_264_0_, sdservicer0_.IsRead_UserID as IsRead_27_264_0_, sdservicer0_.IsTransferred as IsTrans28_264_0_, sdservicer0_.LastOperatedTime as LastOpe29_264_0_, sdservicer0_.LevelOneStatus as LevelOn30_264_0_, sdservicer0_.LevelTwoStatus as LevelTw31_264_0_, sdservicer0_.LocationID as Locatio32_264_0_, sdservicer0_.Owner as Owner33_264_0_, sdservicer0_.ParentID as ParentI34_264_0_, sdservicer0_.Platform as Platfor35_264_0_, sdservicer0_.Priority as Priorit36_264_0_, sdservicer0_.ProbDescription as ProbDes37_264_0_, sdservicer0_.ProjectTransferComment as Project38_264_0_, sdservicer0_.ProxySubmittedBy as ProxySu39_264_0_, sdservicer0_.ReferenceID as Referen40_264_0_, sdservicer0_.RepeatCall as RepeatC41_264_0_, sdservicer0_.RequestID as Request42_264_0_, sdservicer0_.REQUESTTYPE as REQUEST43_264_0_, sdservicer0_.Resolution_CauseID as Resolut44_264_0_, sdservicer0_.ResolutionComment as Resolut45_264_0_, sdservicer0_.Resolution_Days as Resolut46_264_0_, sdservicer0_.Resolution_Hours as Resolut47_264_0_, sdservicer0_.Resolution_Minutes as Resolut48_264_0_, sdservicer0_.ProjectID as Project57_264_0_, sdservicer0_.ServiceID as Service58_264_0_, sdservicer0_.Severity as Severit49_264_0_, sdservicer0_.SLAViolationComment as SLAViol50_264_0_, sdservicer0_.SubCategory as SubCate51_264_0_, sdservicer0_.SubmittedBy as Submitt52_264_0_, sdservicer0_.SubmittedThrough as Submitt53_264_0_, sdservicer0_.Title as Title54_264_0_, sdservicer0_.UrgencyID as Urgency55_264_0_, sdservicer0_.version as version56_264_0_ from sd_servicereqmaster sdservicer0_ where sdservicer0_.ProblemId=? |
3.00 |
22
|
60,101
|
879
|
|
|
0.00
|
|
|
|
6.00 |
1
|
1
|
1
|
|
|
0.00
|
|
|
select this_.sno as sno1_336_0_, this_.AccessID as AccessID2_336_0_, this_.AccountExpireDate as AccountE3_336_0_, this_.BadLoginCount as BadLogin4_336_0_, this_.BaseDN as BaseDN5_336_0_, this_.Cell_No as Cell_No6_336_0_, this_.City as City7_336_0_, this_.Collookup as Collooku8_336_0_, this_.DepartmentID as Departme9_336_0_, this_.EmailAddress as EmailAd10_336_0_, this_.EmployeeID as Employe11_336_0_, this_.FullName as FullNam12_336_0_, this_.GOC as GOC13_336_0_, this_.ImmediateManagerID as Immedia14_336_0_, this_.IsAccountLocked as IsAccou15_336_0_, this_.IsManager as IsManag16_336_0_, this_.LastAssignedTime as LastAss17_336_0_, this_.LastLoginTime as LastLog18_336_0_, this_.LocationID as Locatio19_336_0_, this_.ManagerID as Manager20_336_0_, this_.ProfilePicture as Profile21_336_0_, this_.RecentLoginTime as RecentL22_336_0_, this_.SpecializationID as Special23_336_0_, this_.TelephoneNumber as Telepho24_336_0_, this_.uiInterface as uiInter25_336_0_, this_.UserID as UserID27_336_0_, this_.Wing as Wing26_336_0_ from usermgmt_master this_ where this_.UserID=? |
1.00 |
2
|
91
|
8
|
|
|
0.00
|
|
|
|
1.00 |
1
|
53
|
4
|
|
|
0.00
|
|
|
|
4.00 |
0
|
0
|
0
|
|
|
0.00
|
|
|
|
2.00 |
1
|
152
|
5
|
|
|
0.00
|
|
|
|
2.00 |
1
|
166
|
5
|
|
|
0.00
|
|
|
|
1.00 |
1
|
51
|
5
|
|
|
0.00
|
|
|
|
1.00 |
2
|
41
|
3
|
|
|
0.00
|
|
|
|
1.00 |
1
|
39
|
3
|
|
|
0.00
|
|
|
|
1.00 |
2
|
271
|
12
|
|
|
0.00
|
|
|
insert into sd_encldetails (Access, EnclComment, EnclName, EnclSubmittedBy, EnclSubmittedTime, EnclText, ProblemId) values (?, ?, ?, ?, ?, ?, ?) |
1.00 |
1
|
20
|
3
|
|
|
0.00
|
|
|
|
1.00 |
13
|
241
|
10
|
|
|
0.00
|
|
|
|
1.00 |
9
|
2,060
|
107
|
|
|
0.00
|
|
|
|
5.71 |
0
|
102
|
2
|
|
|
0.00
|
|
|
|
8.81 |
1
|
831
|
11
|
|
|
0.00
|
|
|
|
5.71 |
1
|
306
|
7
|
|
|
0.00
|
|
|
|
1.00 |
1
|
102
|
2
|
|
|
0.00
|
|
|
|
1.00 |
0
|
86
|
2
|
|
|
0.00
|
|
|
update sd_servicereqmaster set AlertID=?, AlternativeEmail=?, ApprovalManager=?, AssetNumber=?, Attachment=?, Category=?, CcMailId=?, ContactNumber=?, ConversionType=?, CreationTime=?, CSI=?, CurrentStatus=?, DelegatedFrom_ApprovalManager=?, DelegatedFrom_Owner=?, DepartmentID=?, DerivedField1=?, DerivedField2=?, DerivedField3=?, Enclosure=?, ExpectedClosureTime=?, GroupID=?, ImpactID=?, IncidentType=?, isLinked=?, IsRead=?, IsRead_UserID=?, IsTransferred=?, LastOperatedTime=?, LevelOneStatus=?, LevelTwoStatus=?, LocationID=?, Owner=?, ParentID=?, Platform=?, Priority=?, ProbDescription=?, ProjectTransferComment=?, ProxySubmittedBy=?, ReferenceID=?, RepeatCall=?, RequestID=?, REQUESTTYPE=?, Resolution_CauseID=?, ResolutionComment=?, Resolution_Days=?, Resolution_Hours=?, Resolution_Minutes=?, ProjectID=?, ServiceID=?, Severity=?, SLAViolationComment=?, SubCategory=?, SubmittedBy=?, SubmittedThrough=?, Title=?, UrgencyID=?, version=? where ProblemId=? |
2.00 |
6
|
3,588
|
88
|
|
|
0.73
|
|
|
|
1.00 |
1
|
43
|
4
|
|
|
0.00
|
|
|
|
1.00 |
1
|
55
|
3
|
|
|
0.00
|
|
|
insert into automailer (New_State, Old_State, ProblemID, Retries_Count, State, templateId, Update_UserID) values (?, ?, ?, ?, ?, ?, ?) |
1.00 |
2
|
266
|
11
|
|
|
0.00
|
|
|
|
2.00 |
2
|
87
|
11
|
|
|
0.00
|
|
|
|
1.00 |
3
|
140
|
12
|
|
|
0.00
|
|
|
|
1.00 |
2
|
322
|
10
|
|
|
0.00
|
|
|
|
1.00 |
2
|
797
|
16
|
|
|
0.00
|
|
|
select userdetail0_.UserID as UserID1_333_0_, userdetail0_.tfauth_status as tfauth_s2_333_0_, userdetail0_.DeletionAllowed as Deletion3_333_0_, userdetail0_.DomainID as DomainID4_333_0_, userdetail0_.Guid as Guid5_333_0_, userdetail0_.isAvailable as isAvaila6_333_0_, userdetail0_.IsFirstLogIn as IsFirstL7_333_0_, userdetail0_.IsLoginAllowed as IsLoginA8_333_0_, userdetail0_.login_failed_attempt as login_fa9_333_0_, userdetail0_.NotifiedAlertCount as Notifie10_333_0_, userdetail0_.OUName as OUName11_333_0_, userdetail0_.Password as Passwor12_333_0_, userdetail0_.Server as Server13_333_0_, userdetail0_.SystemID as SystemI14_333_0_, userdetail0_.UserName as UserNam15_333_0_, userdetail0_.UserPreSyncStatus as UserPre16_333_0_, userdetail0_.UserStatus as UserSta17_333_0_, userdetail0_.whenChanged as whenCha18_333_0_ from userdetails userdetail0_ where userdetail0_.UserID=? |
2.00 |
2
|
49
|
10
|
|
|
0.00
|
|
|
select usermgmtma0_.sno as sno1_336_, usermgmtma0_.AccessID as AccessID2_336_, usermgmtma0_.AccountExpireDate as AccountE3_336_, usermgmtma0_.BadLoginCount as BadLogin4_336_, usermgmtma0_.BaseDN as BaseDN5_336_, usermgmtma0_.Cell_No as Cell_No6_336_, usermgmtma0_.City as City7_336_, usermgmtma0_.Collookup as Collooku8_336_, usermgmtma0_.DepartmentID as Departme9_336_, usermgmtma0_.EmailAddress as EmailAd10_336_, usermgmtma0_.EmployeeID as Employe11_336_, usermgmtma0_.FullName as FullNam12_336_, usermgmtma0_.GOC as GOC13_336_, usermgmtma0_.ImmediateManagerID as Immedia14_336_, usermgmtma0_.IsAccountLocked as IsAccou15_336_, usermgmtma0_.IsManager as IsManag16_336_, usermgmtma0_.LastAssignedTime as LastAss17_336_, usermgmtma0_.LastLoginTime as LastLog18_336_, usermgmtma0_.LocationID as Locatio19_336_, usermgmtma0_.ManagerID as Manager20_336_, usermgmtma0_.ProfilePicture as Profile21_336_, usermgmtma0_.RecentLoginTime as RecentL22_336_, usermgmtma0_.SpecializationID as Special23_336_, usermgmtma0_.TelephoneNumber as Telepho24_336_, usermgmtma0_.uiInterface as uiInter25_336_, usermgmtma0_.UserID as UserID27_336_, usermgmtma0_.Wing as Wing26_336_ from usermgmt_master usermgmtma0_ where usermgmtma0_.UserID=? |
2.86 |
3
|
214
|
25
|
|
|
0.00
|
|
|
|
2.00 |
1
|
287
|
6
|
|
|
0.00
|
|
|
|
2.86 |
1
|
451
|
7
|
|
|
0.00
|
|
|
select escalation0_.slno as slno1_85_, escalation0_.EmailEsca_1 as EmailEsc2_85_, escalation0_.EmailEsca_2 as EmailEsc3_85_, escalation0_.EmailEsca_3 as EmailEsc4_85_, escalation0_.Esca_1 as Esca_5_85_, escalation0_.Esca1_BreachTime as Esca6_85_, escalation0_.Esca1_SendTime as Esca7_85_, escalation0_.Esca_2 as Esca_8_85_, escalation0_.Esca2_BreachTime as Esca9_85_, escalation0_.Esca2_SendTime as Esca10_85_, escalation0_.Esca_3 as Esca_11_85_, escalation0_.Esca3_BreachTime as Esca12_85_, escalation0_.Esca3_SendTime as Esca13_85_, escalation0_.Estimated_Esca1_BreachTime as Estimat14_85_, escalation0_.Estimated_Esca2_BreachTime as Estimat15_85_, escalation0_.Estimated_Esca3_BreachTime as Estimat16_85_, escalation0_.Estimated_GracePeriod_BreachTime as Estimat17_85_, escalation0_.Estimated_SLABreachTime as Estimat18_85_, escalation0_.IsActualResolutionTimeConsider as IsActua19_85_, escalation0_.IsEsca1_Breached as IsEsca20_85_, escalation0_.IsEsca2_Breached as IsEsca21_85_, escalation0_.IsEsca3_Breached as IsEsca22_85_, escalation0_.IsSLA_Breached as IsSLA_B23_85_, escalation0_.IsTicketActive as IsTicke24_85_, escalation0_.LastCalculatedTime as LastCal25_85_, escalation0_.Previous_Status as Previou26_85_, escalation0_.ProblemID as Problem27_85_, escalation0_.SiteID as SiteID28_85_, escalation0_.SLA_BreachTime as SLA_Bre29_85_, escalation0_.SlaID as SlaID30_85_, escalation0_.TicketGenStatus as TicketG31_85_, escalation0_.TotalTimeConsider as TotalTi32_85_ from escalation_lookup escalation0_ where escalation0_.ProblemID=? |
1.00 |
2
|
72
|
8
|
|
|
0.00
|
|
|
select this_.ProblemId as ProblemI1_264_0_, this_.AlertID as AlertID2_264_0_, this_.AlternativeEmail as Alternat3_264_0_, this_.ApprovalManager as Approval4_264_0_, this_.AssetNumber as AssetNum5_264_0_, this_.Attachment as Attachme6_264_0_, this_.Category as Category7_264_0_, this_.CcMailId as CcMailId8_264_0_, this_.ContactNumber as ContactN9_264_0_, this_.ConversionType as Convers10_264_0_, this_.CreationTime as Creatio11_264_0_, this_.CSI as CSI12_264_0_, this_.CurrentStatus as Current13_264_0_, this_.DelegatedFrom_ApprovalManager as Delegat14_264_0_, this_.DelegatedFrom_Owner as Delegat15_264_0_, this_.DepartmentID as Departm16_264_0_, this_.DerivedField1 as Derived17_264_0_, this_.DerivedField2 as Derived18_264_0_, this_.DerivedField3 as Derived19_264_0_, this_.Enclosure as Enclosu20_264_0_, this_.ExpectedClosureTime as Expecte21_264_0_, this_.GroupID as GroupID22_264_0_, this_.ImpactID as ImpactI23_264_0_, this_.IncidentType as Inciden24_264_0_, this_.isLinked as isLinke25_264_0_, this_.IsRead as IsRead26_264_0_, this_.IsRead_UserID as IsRead_27_264_0_, this_.IsTransferred as IsTrans28_264_0_, this_.LastOperatedTime as LastOpe29_264_0_, this_.LevelOneStatus as LevelOn30_264_0_, this_.LevelTwoStatus as LevelTw31_264_0_, this_.LocationID as Locatio32_264_0_, this_.Owner as Owner33_264_0_, this_.ParentID as ParentI34_264_0_, this_.Platform as Platfor35_264_0_, this_.Priority as Priorit36_264_0_, this_.ProbDescription as ProbDes37_264_0_, this_.ProjectTransferComment as Project38_264_0_, this_.ProxySubmittedBy as ProxySu39_264_0_, this_.ReferenceID as Referen40_264_0_, this_.RepeatCall as RepeatC41_264_0_, this_.RequestID as Request42_264_0_, this_.REQUESTTYPE as REQUEST43_264_0_, this_.Resolution_CauseID as Resolut44_264_0_, this_.ResolutionComment as Resolut45_264_0_, this_.Resolution_Days as Resolut46_264_0_, this_.Resolution_Hours as Resolut47_264_0_, this_.Resolution_Minutes as Resolut48_264_0_, this_.ProjectID as Project57_264_0_, this_.ServiceID as Service58_264_0_, this_.Severity as Severit49_264_0_, this_.SLAViolationComment as SLAViol50_264_0_, this_.SubCategory as SubCate51_264_0_, this_.SubmittedBy as Submitt52_264_0_, this_.SubmittedThrough as Submitt53_264_0_, this_.Title as Title54_264_0_, this_.UrgencyID as Urgency55_264_0_, this_.version as version56_264_0_ from sd_servicereqmaster this_ where this_.ParentID=? |
1.00 |
3
|
344
|
15
|
|
|
0.00
|
|
|
select this_.ProblemId as ProblemI1_264_0_, this_.AlertID as AlertID2_264_0_, this_.AlternativeEmail as Alternat3_264_0_, this_.ApprovalManager as Approval4_264_0_, this_.AssetNumber as AssetNum5_264_0_, this_.Attachment as Attachme6_264_0_, this_.Category as Category7_264_0_, this_.CcMailId as CcMailId8_264_0_, this_.ContactNumber as ContactN9_264_0_, this_.ConversionType as Convers10_264_0_, this_.CreationTime as Creatio11_264_0_, this_.CSI as CSI12_264_0_, this_.CurrentStatus as Current13_264_0_, this_.DelegatedFrom_ApprovalManager as Delegat14_264_0_, this_.DelegatedFrom_Owner as Delegat15_264_0_, this_.DepartmentID as Departm16_264_0_, this_.DerivedField1 as Derived17_264_0_, this_.DerivedField2 as Derived18_264_0_, this_.DerivedField3 as Derived19_264_0_, this_.Enclosure as Enclosu20_264_0_, this_.ExpectedClosureTime as Expecte21_264_0_, this_.GroupID as GroupID22_264_0_, this_.ImpactID as ImpactI23_264_0_, this_.IncidentType as Inciden24_264_0_, this_.isLinked as isLinke25_264_0_, this_.IsRead as IsRead26_264_0_, this_.IsRead_UserID as IsRead_27_264_0_, this_.IsTransferred as IsTrans28_264_0_, this_.LastOperatedTime as LastOpe29_264_0_, this_.LevelOneStatus as LevelOn30_264_0_, this_.LevelTwoStatus as LevelTw31_264_0_, this_.LocationID as Locatio32_264_0_, this_.Owner as Owner33_264_0_, this_.ParentID as ParentI34_264_0_, this_.Platform as Platfor35_264_0_, this_.Priority as Priorit36_264_0_, this_.ProbDescription as ProbDes37_264_0_, this_.ProjectTransferComment as Project38_264_0_, this_.ProxySubmittedBy as ProxySu39_264_0_, this_.ReferenceID as Referen40_264_0_, this_.RepeatCall as RepeatC41_264_0_, this_.RequestID as Request42_264_0_, this_.REQUESTTYPE as REQUEST43_264_0_, this_.Resolution_CauseID as Resolut44_264_0_, this_.ResolutionComment as Resolut45_264_0_, this_.Resolution_Days as Resolut46_264_0_, this_.Resolution_Hours as Resolut47_264_0_, this_.Resolution_Minutes as Resolut48_264_0_, this_.ProjectID as Project57_264_0_, this_.ServiceID as Service58_264_0_, this_.Severity as Severit49_264_0_, this_.SLAViolationComment as SLAViol50_264_0_, this_.SubCategory as SubCate51_264_0_, this_.SubmittedBy as Submitt52_264_0_, this_.SubmittedThrough as Submitt53_264_0_, this_.Title as Title54_264_0_, this_.UrgencyID as Urgency55_264_0_, this_.version as version56_264_0_ from sd_servicereqmaster this_ where this_.isLinked=? |
1.00 |
3
|
271
|
12
|
|
|
0.00
|
|
|
|
1.00 |
1
|
70
|
6
|
|
|
0.00
|
|
|
|
1.00 |
1
|
49
|
2
|
|
|
0.00
|
|
|
|
1.00 |
1
|
19
|
1
|
|
|
0.00
|
|
|
|
1.00 |
2
|
54
|
6
|
|
|
0.00
|
|
|
|
1.00 |
2
|
80
|
6
|
|
|
0.00
|
|
|
|
1.00 |
2
|
102
|
7
|
|
|
0.00
|
|
|
select sdaddition0_.FIELDID as col_0_0_, sdaddition0_.MACROID as col_1_0_, sdaddition0_.FIELD_STORAGE_TYPE as col_2_0_, sdaddition0_.FIELD_DISPLAYNAME as col_3_0_, sdaddition0_.ORDERBY as col_4_0_, sdaddition0_.CustomValidationScript as col_5_0_, sdaddition0_.ClientSideValidationScript as col_6_0_, sdaddition0_.URL as col_7_0_, sdaddition0_.DependentFieldPopulaterQuery as col_8_0_ from sd_additionalparams sdaddition0_ where sdaddition0_.FIELDID in (? , ?) order by sdaddition0_.ORDERBY, sdaddition0_.FIELDID |
0.38 |
1
|
102
|
5
|
|
|
0.00
|
|
|
|
2.62 |
1
|
53
|
4
|
|
|
0.00
|
|
|
|
6.81 |
1
|
286
|
4
|
|
|
0.00
|
|
|
|
6.19 |
1
|
177
|
3
|
|
|
0.00
|
|
|
|
9.90 |
0
|
282
|
3
|
|
|
0.00
|
|
|
|
28.48 |
5
|
822
|
30
|
|
|
0.00
|
|
|
|
0.62 |
1
|
72
|
5
|
|
|
0.00
|
|
|
|
1.24 |
2
|
271
|
18
|
|
|
0.00
|
|
|
|
1.86 |
1
|
117
|
3
|
|
|
0.00
|
|
|
|
3.10 |
1
|
108
|
3
|
|
|
0.00
|
|
|
|
3.10 |
1
|
126
|
4
|
|
|
0.00
|
|
|
|
0.62 |
2
|
31
|
2
|
|
|
0.00
|
|
|
|
0.62 |
1
|
47
|
3
|
|
|
0.00
|
|
|
|
0.62 |
1
|
31
|
2
|
|
|
0.00
|
|
|
select sdaddition0_.FIELDID as FIELDID1_180_0_, sdaddition0_.AssetColumn as AssetCol2_180_0_, sdaddition0_.ClientSideValidationScript as ClientSi3_180_0_, sdaddition0_.CustomValidationScript as CustomVa4_180_0_, sdaddition0_.DependentFieldPopulaterQuery as Dependen5_180_0_, sdaddition0_.FIELD_DISPLAYNAME as FIELD_DI6_180_0_, sdaddition0_.field_name as field_na7_180_0_, sdaddition0_.FIELD_STORAGE_TYPE as FIELD_ST8_180_0_, sdaddition0_.GridControlFieldID as GridCont9_180_0_, sdaddition0_.IsAssetField as IsAsset10_180_0_, sdaddition0_.IsMobileChangeVisibility as IsMobil11_180_0_, sdaddition0_.IsMobileListVisibility as IsMobil12_180_0_, sdaddition0_.IsMobileVisibility as IsMobil13_180_0_, sdaddition0_.MACROID as MACROID14_180_0_, sdaddition0_.ORDERBY as ORDERBY15_180_0_, sdaddition0_.ScriptProperties as ScriptP16_180_0_, sdaddition0_.ProjectID as Project19_180_0_, sdaddition0_.Status as Status17_180_0_, sdaddition0_.URL as URL18_180_0_ from sd_additionalparams sdaddition0_ where sdaddition0_.FIELDID=? |
5.57 |
2
|
13,251
|
48
|
|
|
0.00
|
|
|
insert into sd_servicereq_additionalparams (Data, DataId, InstanceID, ProblemID, ProjectID, FIELDID) values (?, ?, ?, ?, ?, ?) |
4.95 |
3
|
60,010
|
406
|
|
|
0.00
|
|
|
|
3.10 |
1
|
266
|
5
|
|
|
0.00
|
|
|
|
0.62 |
1
|
41
|
4
|
|
|
0.00
|
|
|