/saveStateChange.* ajax POST |
|
3,023
|
7,210,294
|
112,932
|
433
|
143,966
|
0.00
|
214
|
2,496
|
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.56 |
5
|
90,164
|
232
|
|
|
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.13 |
1
|
865
|
11
|
|
|
0.00
|
|
|
|
1.13 |
1
|
194
|
5
|
|
|
0.00
|
|
|
|
4.51 |
0
|
833
|
6
|
|
|
0.00
|
|
|
|
1.13 |
1
|
202
|
8
|
|
|
0.00
|
|
|
|
2.25 |
1
|
130
|
4
|
|
|
0.00
|
|
|
|
1.13 |
1
|
279
|
6
|
|
|
0.00
|
|
|
|
1.13 |
1
|
103
|
4
|
|
|
0.00
|
|
|
|
0.93 |
1
|
184
|
4
|
|
|
0.00
|
|
|
|
1.13 |
0
|
280
|
4
|
|
|
0.00
|
|
|
|
1.13 |
14
|
60,073
|
297
|
|
|
0.00
|
|
|
|
1.13 |
2
|
60,081
|
171
|
|
|
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.52 |
2
|
286
|
8
|
|
|
0.00
|
|
|
|
5.29 |
0
|
283
|
4
|
|
|
0.00
|
|
|
|
2.46 |
1
|
284
|
5
|
|
|
0.00
|
|
|
|
1.62 |
1
|
819
|
8
|
|
|
0.00
|
|
|
|
1.62 |
1
|
289
|
4
|
|
|
0.00
|
|
|
|
0.08 |
1
|
194
|
5
|
|
|
0.00
|
|
|
|
1.13 |
1
|
1,702
|
12
|
|
|
0.00
|
|
|
|
1.13 |
0
|
484
|
5
|
|
|
0.00
|
|
|
|
1.13 |
2
|
209
|
8
|
|
|
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.22 |
3
|
60,062
|
229
|
|
|
0.34
|
|
|
|
1.13 |
0
|
53
|
2
|
|
|
0.00
|
|
|
|
1.13 |
1
|
491
|
7
|
|
|
0.00
|
|
|
insert into automailer (New_State, Old_State, ProblemID, Retries_Count, State, templateId, Update_UserID) values (?, ?, ?, ?, ?, ?, ?) |
1.13 |
1
|
1,675
|
9
|
|
|
0.00
|
|
|
|
2.25 |
1
|
825
|
7
|
|
|
0.00
|
|
|
|
1.61 |
2
|
3,363
|
12
|
|
|
0.00
|
|
|
|
1.13 |
1
|
1,375
|
10
|
|
|
0.00
|
|
|
|
1.31 |
1
|
1,386
|
7
|
|
|
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.07 |
2
|
60,066
|
207
|
|
|
0.00
|
|
|
|
2.71 |
1
|
60,064
|
105
|
|
|
0.00
|
|
|
|
3.70 |
1
|
60,081
|
81
|
|
|
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.61 |
1
|
940
|
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.28 |
2
|
488
|
9
|
|
|
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.28 |
2
|
826
|
11
|
|
|
0.00
|
|
|
|
1.13 |
1
|
272
|
6
|
|
|
0.00
|
|
|
|
1.13 |
1
|
278
|
5
|
|
|
0.00
|
|
|
|
1.13 |
1
|
109
|
4
|
|
|
0.00
|
|
|
|
1.13 |
1
|
134
|
4
|
|
|
0.00
|
|
|
|
1.13 |
1
|
820
|
14
|
|
|
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.16 |
2
|
141
|
8
|
|
|
0.00
|
|
|
|
9.06 |
1
|
60,067
|
123
|
|
|
0.00
|
|
|
|
6.76 |
1
|
3,395
|
11
|
|
|
0.00
|
|
|
|
0.35 |
1
|
41
|
3
|
|
|
0.00
|
|
|
|
11.89 |
1
|
60,069
|
87
|
|
|
0.00
|
|
|
|
30.07 |
1
|
60,078
|
169
|
|
|
0.00
|
|
|
|
3.38 |
1
|
1,023
|
6
|
|
|
0.00
|
|
|
|
0.33 |
2
|
294
|
14
|
|
|
0.00
|
|
|
|
0.62 |
0
|
272
|
4
|
|
|
0.00
|
|
|
|
0.31 |
2
|
512
|
8
|
|
|
0.00
|
|
|
|
0.93 |
1
|
434
|
4
|
|
|
0.00
|
|
|
|
0.83 |
0
|
270
|
5
|
|
|
0.00
|
|
|
|
0.83 |
1
|
292
|
5
|
|
|
0.00
|
|
|
|
0.31 |
1
|
987
|
12
|
|
|
0.00
|
|
|
|
2.33 |
0
|
159
|
2
|
|
|
0.00
|
|
|
|
0.34 |
2
|
268
|
5
|
|
|
0.00
|
|
|
|
0.34 |
2
|
302
|
8
|
|
|
0.00
|
|
|
|
0.34 |
2
|
506
|
9
|
|
|
0.00
|
|
|
|
7.94 |
1
|
4,656
|
18
|
|
|
0.00
|
|
|
|
0.95 |
1
|
553
|
8
|
|
|
0.00
|
|
|
|
0.95 |
1
|
276
|
4
|
|
|
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.04 |
1
|
60,478
|
94
|
|
|
0.00
|
|
|
insert into sd_servicereq_additionalparams (Data, DataId, InstanceID, ProblemID, ProjectID, FIELDID) values (?, ?, ?, ?, ?, ?) |
4.14 |
1
|
10,674
|
37
|
|
|
0.00
|
|
|
|
2.51 |
0
|
268
|
4
|
|
|
0.00
|
|
|
|
0.33 |
1
|
273
|
6
|
|
|
0.00
|
|
|
|
0.66 |
1
|
281
|
5
|
|
|
0.00
|
|
|
|
1.10 |
1
|
284
|
3
|
|
|
0.00
|
|
|
|
0.71 |
1
|
1,943
|
15
|
|
|
0.00
|
|
|
|
0.71 |
1
|
362
|
5
|
|
|
0.00
|
|
|
|
0.40 |
1
|
594
|
9
|
|
|
0.00
|
|
|
|
0.03 |
5
|
129
|
23
|
|
|
0.00
|
|
|
|
0.15 |
1
|
407
|
11
|
|
|
0.00
|
|
|
|
0.15 |
1
|
822
|
6
|
|
|
0.00
|
|
|
|
0.06 |
0
|
66
|
2
|
|
|
0.00
|
|
|
|
0.02 |
0
|
37
|
2
|
|
|
0.00
|
|
|
|
0.02 |
0
|
11
|
0
|
|
|
0.00
|
|
|
|
0.00 |
1
|
495
|
5
|
|
|
0.00
|
|
|
|
0.12 |
0
|
3
|
0
|
|
|
0.00
|
|
|
|
1.59 |
0
|
273
|
3
|
|
|
0.00
|
|
|
|
1.28 |
1
|
5,897
|
32
|
|
|
0.00
|
|
|
SELECT fieldid FROM sd_additionalparams_access_details where FIELDID = ? and ((FieldAccessCategory=1 and (AccessID in ( ?, ?, ?, ?, ?, ?, ? ) or AccessID = 0) and (AccessPermission = 0 or AccessPermission in( ? ))) or (FieldAccessCategory=9 and (AccessID in ( ?, ?, ?, ?, ?, ?, ? ) or AccessID=0) and (AccessPermission=0 or AccessPermission in( ? )))) limit ? |
1.28 |
1
|
60,066
|
135
|
|
|
0.00
|
|
|
|
0.06 |
1
|
271
|
10
|
|
|
0.00
|
|
|
|
0.42 |
1
|
146
|
4
|
|
|
0.00
|
|
|
|
0.33 |
1
|
131
|
4
|
|
|
0.00
|
|
|
|
0.23 |
1
|
55
|
2
|
|
|
0.00
|
|
|
|
0.41 |
0
|
38
|
1
|
|
|
0.00
|
|
|
SELECT fieldid FROM sd_additionalparams_access_details where FIELDID = ? and ((FieldAccessCategory=1 and (AccessID in ( ?, ?, ?, ?, ?, ?, ?, ? ) or AccessID = 0) and (AccessPermission = 0 or AccessPermission in( ? ))) or (FieldAccessCategory=9 and (AccessID in ( ?, ?, ?, ?, ?, ?, ?, ? ) or AccessID=0) and (AccessPermission=0 or AccessPermission in( ? )))) limit ? |
0.40 |
1
|
270
|
3
|
|
|
0.00
|
|
|
|
0.11 |
1
|
105
|
3
|
|
|
0.00
|
|
|
SELECT DISTINCT(r.MasterID) FROM sd_pre_post_actions_details r,sd_pre_post_actions_details su, sd_pre_post_actions_details st ,sd_pre_post_actions_details sdr,sd_pre_post_actions_details sd1,sd_pre_post_actions p,sd_pre_post_actions_details sd2,sd_pre_post_actions_details sd3 where r.MasterID = su.MasterID and r.MasterID = st.MasterID and st.MasterID = su.MasterID and sdr.MasterID = su.MasterID and sdr.MasterID = sd1.MasterID and sd1.MasterID = sd2.MasterID and sd2.MasterID = sd3.MasterID and r.MasterID= p.id and r.CategoryID =1 and r.CategoryValue =10 and st.CategoryID =3 and (st.CategoryValue=0 OR st.CategoryValue=41) and sdr.CategoryID =4 and (sdr.CategoryValue=0 OR sdr.CategoryValue in (12,14,19,10,6,37,20)) and su.CategoryID =2 and (su.CategoryValue=0 OR su.CategoryValue=69) and sd1.CategoryID =6 and (sd1.CategoryValue=0 OR sd1.CategoryValue=0) and sd2.CategoryID =7 and (sd2.CategoryValue=0 OR sd2.CategoryValue=0) and sd3.CategoryID =8 and (sd3.CategoryValue=0 OR sd3.CategoryValue=0) and p.Pre_Post_Action=1 and p.ProjectID=1 order by p.LaunchingOrder |
0.03 |
4
|
70
|
5
|
|
|
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.17 |
2
|
287
|
9
|
|
|
0.00
|
|
|
|
0.35 |
1
|
10,582
|
72
|
|
|
0.00
|
|
|
|
0.17 |
1
|
6,587
|
57
|
|
|
0.00
|
|
|
SELECT DISTINCT(r.MasterID) FROM sd_pre_post_actions_details r,sd_pre_post_actions_details su, sd_pre_post_actions_details st ,sd_pre_post_actions_details sdr,sd_pre_post_actions_details sd1,sd_pre_post_actions p,sd_pre_post_actions_details sd2,sd_pre_post_actions_details sd3 where r.MasterID = su.MasterID and r.MasterID = st.MasterID and st.MasterID = su.MasterID and sdr.MasterID = su.MasterID and sdr.MasterID = sd1.MasterID and sd1.MasterID = sd2.MasterID and sd2.MasterID = sd3.MasterID and r.MasterID= p.id and r.CategoryID =1 and r.CategoryValue =10 and st.CategoryID =3 and (st.CategoryValue=0 OR st.CategoryValue=41) and sdr.CategoryID =4 and (sdr.CategoryValue=0 OR sdr.CategoryValue in (12,14,19,10,6,37,20)) and su.CategoryID =2 and (su.CategoryValue=0 OR su.CategoryValue=69) and sd1.CategoryID =6 and (sd1.CategoryValue=0 OR sd1.CategoryValue=0) and sd2.CategoryID =7 and (sd2.CategoryValue=0 OR sd2.CategoryValue=0) and sd3.CategoryID =8 and (sd3.CategoryValue=0 OR sd3.CategoryValue=0) and p.Pre_Post_Action=2 and p.ProjectID=1 order by p.LaunchingOrder |
0.03 |
4
|
24
|
2
|
|
|
0.00
|
|
|
|
0.18 |
0
|
97
|
3
|
|
|
0.00
|
|
|
|
0.15 |
1
|
48
|
2
|
|
|
0.00
|
|
|
|
0.08 |
0
|
3
|
0
|
|
|
0.00
|
|
|
|
0.31 |
0
|
218
|
3
|
|
|
0.00
|
|
|
|
1.79 |
1
|
406
|
5
|
|
|
0.00
|
|
|
|
1.14 |
0
|
80
|
2
|
|
|
0.00
|
|
|
|
1.14 |
1
|
300
|
4
|
|
|
0.00
|
|
|
|
0.64 |
0
|
123
|
2
|
|
|
0.00
|
|
|
|
0.64 |
0
|
112
|
3
|
|
|
0.00
|
|
|
|
0.08 |
1
|
234
|
5
|
|
|
0.00
|
|
|
|
0.01 |
1
|
299
|
6
|
|
|
0.00
|
|
|
|
0.01 |
0
|
276
|
4
|
|
|
0.00
|
|
|
|
0.20 |
1
|
34
|
2
|
|
|
0.00
|
|
|
SELECT DISTINCT(r.MasterID) FROM sd_pre_post_actions_details r,sd_pre_post_actions_details su, sd_pre_post_actions_details st ,sd_pre_post_actions_details sdr,sd_pre_post_actions_details sd1,sd_pre_post_actions p,sd_pre_post_actions_details sd2,sd_pre_post_actions_details sd3 where r.MasterID = su.MasterID and r.MasterID = st.MasterID and st.MasterID = su.MasterID and sdr.MasterID = su.MasterID and sdr.MasterID = sd1.MasterID and sd1.MasterID = sd2.MasterID and sd2.MasterID = sd3.MasterID and r.MasterID= p.id and r.CategoryID =1 and r.CategoryValue =10 and st.CategoryID =3 and (st.CategoryValue=0 OR st.CategoryValue=73) and sdr.CategoryID =4 and (sdr.CategoryValue=0 OR sdr.CategoryValue in (12,10,20,6,19,37,14)) and su.CategoryID =2 and (su.CategoryValue=0 OR su.CategoryValue=69) and sd1.CategoryID =6 and (sd1.CategoryValue=0 OR sd1.CategoryValue=0) and sd2.CategoryID =7 and (sd2.CategoryValue=0 OR sd2.CategoryValue=0) and sd3.CategoryID =8 and (sd3.CategoryValue=0 OR sd3.CategoryValue=0) and p.Pre_Post_Action=1 and p.ProjectID=1 order by p.LaunchingOrder |
0.05 |
5
|
39
|
4
|
|
|
0.00
|
|
|
SELECT DISTINCT(r.MasterID) FROM sd_pre_post_actions_details r,sd_pre_post_actions_details su, sd_pre_post_actions_details st ,sd_pre_post_actions_details sdr,sd_pre_post_actions_details sd1,sd_pre_post_actions p,sd_pre_post_actions_details sd2,sd_pre_post_actions_details sd3 where r.MasterID = su.MasterID and r.MasterID = st.MasterID and st.MasterID = su.MasterID and sdr.MasterID = su.MasterID and sdr.MasterID = sd1.MasterID and sd1.MasterID = sd2.MasterID and sd2.MasterID = sd3.MasterID and r.MasterID= p.id and r.CategoryID =1 and r.CategoryValue =10 and st.CategoryID =3 and (st.CategoryValue=0 OR st.CategoryValue=73) and sdr.CategoryID =4 and (sdr.CategoryValue=0 OR sdr.CategoryValue in (12,10,20,6,19,37,14)) and su.CategoryID =2 and (su.CategoryValue=0 OR su.CategoryValue=69) and sd1.CategoryID =6 and (sd1.CategoryValue=0 OR sd1.CategoryValue=0) and sd2.CategoryID =7 and (sd2.CategoryValue=0 OR sd2.CategoryValue=0) and sd3.CategoryID =8 and (sd3.CategoryValue=0 OR sd3.CategoryValue=0) and p.Pre_Post_Action=2 and p.ProjectID=1 order by p.LaunchingOrder |
0.05 |
4
|
46
|
4
|
|
|
0.00
|
|
|
SELECT DISTINCT(r.MasterID) FROM sd_pre_post_actions_details r,sd_pre_post_actions_details su, sd_pre_post_actions_details st ,sd_pre_post_actions_details sdr,sd_pre_post_actions_details sd1,sd_pre_post_actions p,sd_pre_post_actions_details sd2,sd_pre_post_actions_details sd3 where r.MasterID = su.MasterID and r.MasterID = st.MasterID and st.MasterID = su.MasterID and sdr.MasterID = su.MasterID and sdr.MasterID = sd1.MasterID and sd1.MasterID = sd2.MasterID and sd2.MasterID = sd3.MasterID and r.MasterID= p.id and r.CategoryID =1 and r.CategoryValue =10 and st.CategoryID =3 and (st.CategoryValue=0 OR st.CategoryValue=41) and sdr.CategoryID =4 and (sdr.CategoryValue=0 OR sdr.CategoryValue in (12,10,20,6,19,37,14)) and su.CategoryID =2 and (su.CategoryValue=0 OR su.CategoryValue=69) and sd1.CategoryID =6 and (sd1.CategoryValue=0 OR sd1.CategoryValue=0) and sd2.CategoryID =7 and (sd2.CategoryValue=0 OR sd2.CategoryValue=0) and sd3.CategoryID =8 and (sd3.CategoryValue=0 OR sd3.CategoryValue=0) and p.Pre_Post_Action=2 and p.ProjectID=1 order by p.LaunchingOrder |
0.05 |
4
|
41
|
4
|
|
|
0.00
|
|
|
|
0.24 |
0
|
3
|
0
|
|
|
0.00
|
|
|
|
0.17 |
1
|
268
|
10
|
|
|
0.00
|
|
|
|
0.09 |
1
|
211
|
6
|
|
|
0.00
|
|
|
|
0.04 |
0
|
33
|
1
|
|
|
0.00
|
|
|
|
0.02 |
1
|
63
|
4
|
|
|
0.00
|
|
|
|
0.02 |
1
|
39
|
2
|
|
|
0.00
|
|
|
|
0.01 |
0
|
13
|
1
|
|
|
0.00
|
|
|
SELECT fieldid FROM sd_additionalparams_access_details where FIELDID = ? and FieldAccessCategory=1 and (AccessID in ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) or AccessID=0) and (AccessPermission=0 or AccessPermission in( ? ) ) limit ? |
0.11 |
1
|
273
|
8
|
|
|
0.00
|
|
|
select sdaddition0_.LoadInChild as col_0_0_ from sd_additionalfields_permissions sdaddition0_ where sdaddition0_.FieldID=? and (sdaddition0_.AccessToRole=0 or sdaddition0_.AccessToRole in (? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ? , ?)) |
0.07 |
0
|
428
|
7
|
|
|
0.00
|
|
|
SELECT fieldid FROM sd_additionalparams_access_details where FIELDID = ? and ((FieldAccessCategory=1 and (AccessID in ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) or AccessID = 0) and (AccessPermission = 0 or AccessPermission in( ? ))) or (FieldAccessCategory=9 and (AccessID in ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) or AccessID=0) and (AccessPermission=0 or AccessPermission in( ? )))) limit ? |
0.07 |
1
|
288
|
9
|
|
|
0.00
|
|
|
|
0.07 |
0
|
43
|
2
|
|
|
0.00
|
|
|
SELECT DISTINCT(r.MasterID) FROM sd_pre_post_actions_details r,sd_pre_post_actions_details su, sd_pre_post_actions_details st ,sd_pre_post_actions_details sdr,sd_pre_post_actions_details sd1,sd_pre_post_actions p,sd_pre_post_actions_details sd2,sd_pre_post_actions_details sd3 where r.MasterID = su.MasterID and r.MasterID = st.MasterID and st.MasterID = su.MasterID and sdr.MasterID = su.MasterID and sdr.MasterID = sd1.MasterID and sd1.MasterID = sd2.MasterID and sd2.MasterID = sd3.MasterID and r.MasterID= p.id and r.CategoryID =1 and r.CategoryValue =10 and st.CategoryID =3 and (st.CategoryValue=0 OR st.CategoryValue=76) and sdr.CategoryID =4 and (sdr.CategoryValue=0 OR sdr.CategoryValue in (12,10,19,20,6,14,37)) and su.CategoryID =2 and (su.CategoryValue=0 OR su.CategoryValue=69) and sd1.CategoryID =6 and (sd1.CategoryValue=0 OR sd1.CategoryValue=0) and sd2.CategoryID =7 and (sd2.CategoryValue=0 OR sd2.CategoryValue=0) and sd3.CategoryID =8 and (sd3.CategoryValue=0 OR sd3.CategoryValue=0) and p.Pre_Post_Action=1 and p.ProjectID=1 order by p.LaunchingOrder |
0.02 |
4
|
106
|
9
|
|
|
0.00
|
|
|
|
0.01 |
1
|
124
|
4
|
|
|
0.00
|
|
|
|
0.01 |
0
|
19
|
1
|
|
|
0.00
|
|
|
|
0.00 |
1
|
63
|
2
|
|
|
0.00
|
|
|