API tools faq
paste
Advertisement
doranchak

Untitled

doranchak
Oct 18th, 2018
114
0
Never
Add comment
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 8.86 KB | None | 0 0
raw download clone embed print report
  1. 119359 OUTTIME TOTAL: find1 select distinct mo from com.legaledge.harmony.summary.CriminalDefendantQuickSearch as mo where (mo.defendantNameSearch like :defendantNameSearch or mo.combinedNameSearch like :combinedNameSearch) order by mo.defendantName, params [key (combinedNameSearch) value (bryant, william%) key (defendantNameSearch) value (bryant, william%) ], limit 1000: 119359
  2. 106343 OUTTIME TOTAL: find1 select distinct mo from com.legaledge.harmony.summary.CriminalDefendantQuickSearch as mo where (mo.defendantNameSearch like :defendantNameSearch or mo.combinedNameSearch like :combinedNameSearch) order by mo.defendantName, params [key (combinedNameSearch) value (daniels, shawn%) key (defendantNameSearch) value (daniels, shawn%) ], limit 1000: 106343
  3. 42924 OUTTIME TOTAL: getSerializableIdSkipSecurity com.legaledge.harmony.model.objects.Person(165427969) true: 42924
  4. 33469 OUTTIME TOTAL: find1 from Organization o where upper(o.type.stringValue) = 'Jail', params null map, limit null: 33469
  5. 31516 OUTTIME TOTAL: find1 select distinct mo from com.legaledge.harmony.summary.CriminalDefendantQuickSearch as mo where (mo.defendantNameSearch like :defendantNameSearch or mo.combinedNameSearch like :combinedNameSearch) order by mo.defendantName, params [key (combinedNameSearch) value (jones, quincy%) key (defendantNameSearch) value (jones, quincy%) ], limit 1000: 31516
  6. 30843 OUTTIME TOTAL: find1 from Organization o where upper(o.type.stringValue) = 'Jail', params null map, limit null: 30843
  7. 26811 OUTTIME TOTAL: find1 select distinct mo from com.legaledge.harmony.summary.CaseEvents as mo where (mo.personId=5703796) and (mo.completionDate is null or mo.completionDate='') order by mo.startDate, params [], limit null: 26811
  8. 24642 OUTTIME TOTAL: find1 from Organization o where upper(o.type.stringValue) = 'Jail', params null map, limit null: 24642
  9. 23064 OUTTIME TOTAL: find1 from Organization o where upper(o.type.stringValue) = 'Jail', params null map, limit null: 23064
  10. 22280 OUTTIME TOTAL: find1 select distinct mo from com.legaledge.harmony.summary.CriminalDefendantQuickSearch as mo where (mo.defendantNameSearch like :defendantNameSearch or mo.combinedNameSearch like :combinedNameSearch) order by mo.defendantName, params [key (combinedNameSearch) value (quevi, marcus%) key (defendantNameSearch) value (quevi, marcus%) ], limit 1000: 22280
  11. 20985 OUTTIME TOTAL: find1 from Organization o where upper(o.type.stringValue) = 'Jail', params null map, limit null: 20985
  12. 19765 OUTTIME TOTAL: find1 from Organization o where upper(o.type.stringValue) = 'Jail', params null map, limit null: 19765
  13. 18672 OUTTIME TOTAL: find1 select distinct mo from com.legaledge.harmony.summary.CaseEvents as mo where (mo.personId=5703796) and (mo.completionDate is null or mo.completionDate='') order by mo.startDate, params [], limit null: 18672
  14. 18642 OUTTIME TOTAL: find1 from Organization o where upper(o.type.stringValue) = 'Jail', params null map, limit null: 18642
  15. 18579 OUTTIME TOTAL: find1 from Organization o where upper(o.type.stringValue) = 'Jail', params null map, limit null: 18579
  16. 16906 OUTTIME TOTAL: find1 from Organization o where upper(o.type.stringValue) = 'Jail', params null map, limit null: 16906
  17. 16108 OUTTIME TOTAL: find1 from Organization o where upper(o.type.stringValue) = 'Jail', params null map, limit null: 16108
  18. 15280 OUTTIME TOTAL: find1 from Organization o where upper(o.type.stringValue) = 'Jail', params null map, limit null: 15280
  19. 15235 OUTTIME TOTAL: find1 from Organization o where upper(o.type.stringValue) = 'Jail', params null map, limit null: 15235
  20. 14640 OUTTIME TOTAL: find1 from Organization o where upper(o.type.stringValue) = 'Jail', params null map, limit null: 14640
  21. 14532 OUTTIME TOTAL: find1 select distinct mo from com.legaledge.harmony.summary.MinimalPersonAddress as mo where (mo.personId = 182398488) order by mo.active desc, mo.createdTime desc, params [], limit null: 14532
  22. 14265 OUTTIME TOTAL: find1 select distinct mo from com.legaledge.harmony.summary.AttorneyCaseloadOpenDash as mo where (mo.personId = 70923045) and (mo.assignmentEndDateRaw is null or mo.assignmentEndDateRaw = '' or mo.assignmentEndDateRaw >= getDate()) order by mo.fileNumber, mo.appearanceStartDateRaw desc, params [], limit 2500: 14265
  23. 14203 OUTTIME TOTAL: find1 select distinct mo from com.legaledge.harmony.summary.AttorneyCaseloadOpenDash as mo where (mo.personId = 5702696) and (mo.assignmentEndDateRaw is null or mo.assignmentEndDateRaw = '' or mo.assignmentEndDateRaw >= getDate()) order by mo.fileNumber, mo.appearanceStartDateRaw desc, params [], limit 2500: 14203
  24. 13829 OUTTIME TOTAL: find1 select distinct mo from com.legaledge.harmony.summary.CaseIdentifiers as mo where (mo.caseId = 63687285), params [], limit null: 13829
  25. 13750 OUTTIME TOTAL: find1 select distinct mo from com.legaledge.harmony.summary.MinimalDefendantDefender as mo where (mo.criminalDefendantId = 182211718) order by mo.sortableStartDate desc, params [], limit null: 13750
  26. 13719 OUTTIME TOTAL: find1 select distinct mo from com.legaledge.harmony.summary.CaseIdentifiers as mo where (mo.caseId = 63687285), params [], limit null: 13719
  27. 13536 OUTTIME TOTAL: find1 from Organization o where upper(o.type.stringValue) = 'Jail', params null map, limit null: 13536
  28. 12781 OUTTIME TOTAL: find1 from Organization o where upper(o.type.stringValue) = 'Jail', params null map, limit null: 12781
  29. 12688 OUTTIME TOTAL: find1 from Organization o where upper(o.type.stringValue) = 'Jail', params null map, limit null: 12688
  30. 12266 OUTTIME TOTAL: find1 select distinct mo from com.legaledge.harmony.summary.DefendantAppearance as mo where (mo.defendantId = 160838940) order by mo.startDate desc, mo.startTime desc, params [], limit null: 12266
  31. 12202 OUTTIME TOTAL: find1 select distinct mo from com.legaledge.harmony.summary.CriminalDefendantQuickSearch as mo where (mo.defendantNameSearch like :defendantNameSearch or mo.combinedNameSearch like :combinedNameSearch) order by mo.defendantName, params [key (combinedNameSearch) value (aluise, david%) key (defendantNameSearch) value (aluise, david%) ], limit 1000: 12202
  32. 11938 OUTTIME TOTAL: find1 select distinct mo from com.legaledge.harmony.summary.CriminalDefendantQuickSearch as mo where (mo.defendantNameSearch like :defendantNameSearch or mo.combinedNameSearch like :combinedNameSearch) order by mo.defendantName, params [key (combinedNameSearch) value (drake, john%) key (defendantNameSearch) value (drake, john%) ], limit 1000: 11938
  33. 11719 OUTTIME TOTAL: find1 from Organization o where upper(o.type.stringValue) = 'Jail', params null map, limit null: 11719
  34. 11609 OUTTIME TOTAL: find1 from Organization o where upper(o.type.stringValue) = 'Jail', params null map, limit null: 11609
  35. 11140 OUTTIME TOTAL: find1 select distinct mo from com.legaledge.harmony.summary.PersonCharges as mo where (mo.defendantId = 182211718 and mo.status in ('CPCMS') and mo.status is not null) order by mo.paragraph, mo.status desc, params [], limit null: 11140
  36. 10750 OUTTIME TOTAL: find1 select distinct mo from com.legaledge.harmony.summary.CaseIdentifiers as mo where (mo.caseId = 60773660), params [], limit null: 10750
  37. 10735 OUTTIME TOTAL: find1 select distinct mo from com.legaledge.harmony.summary.AttorneyCaseloadOpenDash as mo where (mo.personId = 54256467) and (mo.assignmentEndDateRaw is null or mo.assignmentEndDateRaw = '' or mo.assignmentEndDateRaw >= getDate()) order by mo.fileNumber, mo.appearanceStartDateRaw desc, params [], limit 2500: 10735
  38. 10406 OUTTIME TOTAL: find1 from InterviewTracking it where it.startTime between CONVERT(VARCHAR(10),GETDATE(),10)+' '+'00:00:00' and CONVERT(VARCHAR(10),dateadd(day,1,GETDATE()),10)+' '+'23:23:59' order by it.startTime, vals null array, types null array, limit null: 10406
  39. 10378 OUTTIME TOTAL: find1 from Organization o where upper(o.type.stringValue) = 'Jail', params null map, limit null: 10378
  40. 10281 OUTTIME TOTAL: find1 select distinct mo from com.legaledge.harmony.summary.CriminalDefendantQuickSearch as mo where (mo.defendantNameSearch like :defendantNameSearch or mo.combinedNameSearch like :combinedNameSearch) order by mo.defendantName, params [key (combinedNameSearch) value (Seif, Shawn%) key (defendantNameSearch) value (Seif, Shawn%) ], limit 1000: 10281
  41. 10188 OUTTIME TOTAL: find1 select distinct mo from com.legaledge.harmony.summary.AttorneyCaseloadOpenDash as mo where (mo.personId = 5608392) and (mo.assignmentEndDateRaw is null or mo.assignmentEndDateRaw = '' or mo.assignmentEndDateRaw >= getDate()) order by mo.fileNumber, mo.appearanceStartDateRaw desc, params [], limit 2500: 10188
  42. 10110 OUTTIME TOTAL: find1 select distinct mo from com.legaledge.harmony.summary.CaseIdentifiers as mo where (mo.caseId = 75360768), params [], limit null: 10110
  43. 10078 OUTTIME TOTAL: find1 from Organization o where upper(o.type.stringValue) = 'Jail', params null map, limit null: 10078
  44. 10000 OUTTIME TOTAL: find1 from Organization o where upper(o.type.stringValue) = 'Jail', params null map, limit null: 10000
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement
Public Pastes
Advertisement
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy.  OK, I Understand
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!