Page Time: 4.3511s

Memory: 11.2181 MB (Peak: 13.1747 MB)

Queries (124, time: 4.1296s, 94.9%)

1. SELECT data_key, data_value
   FROM xf_data_registry
   WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routeFiltersIn', 'routeFiltersOut', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'userTitleLadder', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')

   Run Time: 0.000831

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_data_registry	range	PRIMARY	PRIMARY	27		26	Using where

2. SELECT data_key, data_value
   FROM xf_data_registry
   WHERE data_key IN ('brListenerClasses', 'brBriviumAddOns')

   Run Time: 0.000317

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_data_registry	range	PRIMARY	PRIMARY	27		2	Using where

3. SELECT data_key, data_value
   FROM xf_data_registry
   WHERE data_key IN ('ads', 'adPositions', 'adTypes')

   Run Time: 0.000371

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_data_registry	range	PRIMARY	PRIMARY	27		3	Using where

4. SELECT cache_value
   FROM xf_permission_combination
   WHERE permission_combination_id = ?

   Params: 1
   Run Time: 0.000221

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_permission_combination	const	PRIMARY	PRIMARY	4	const	1

5. SELECT category.*
   	,
   	permission.cache_value AS category_permission_cache
   FROM xf_nflj_sportsbook_category AS category
   
   	LEFT JOIN xf_permission_cache_content AS permission
   		ON (permission.permission_combination_id = 1
   			AND permission.content_type = 'sportsbook_category'
   			AND permission.content_id = category.category_id)WHERE category.allow_events =1
   ORDER BY category.category_name ASC

   Run Time: 0.083595

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	category	ALL					14826	Using where; Using filesort
   SIMPLE	permission	eq_ref	PRIMARY	PRIMARY	35	const,const,m11459_uabets.category.category_id	1	Using where

6. SELECT cache_value
   FROM xf_permission_cache_content
   WHERE permission_combination_id = ?
   	AND content_type = ?
   	AND content_id = ?

   Params: 1, sportsbook_category, 204784
   Run Time: 0.000304

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE								Impossible WHERE noticed after reading const tables

7. SELECT cache_value
   FROM xf_permission_cache_content
   WHERE permission_combination_id = ?
   	AND content_type = ?
   	AND content_id = ?

   Params: 1, sportsbook_category, 204785
   Run Time: 0.000146

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE								Impossible WHERE noticed after reading const tables

8. SELECT cache_value
   FROM xf_permission_cache_content
   WHERE permission_combination_id = ?
   	AND content_type = ?
   	AND content_id = ?

   Params: 1, sportsbook_category, 213151
   Run Time: 0.000114

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE								Impossible WHERE noticed after reading const tables

9. SELECT cache_value
   FROM xf_permission_cache_content
   WHERE permission_combination_id = ?
   	AND content_type = ?
   	AND content_id = ?

   Params: 1, sportsbook_category, 234896
   Run Time: 0.000108

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE								Impossible WHERE noticed after reading const tables

10. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 234927
    Run Time: 0.000128

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

11. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 221030
    Run Time: 0.000113

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

12. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 221031
    Run Time: 0.000126

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

13. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 220573
    Run Time: 0.000120

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

14. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 213554
    Run Time: 0.000123

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

15. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 213143
    Run Time: 0.000140

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

16. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 220538
    Run Time: 0.000175

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

17. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 220540
    Run Time: 0.000159

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

18. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 220534
    Run Time: 0.000142

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

19. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 220536
    Run Time: 0.000154

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

20. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 220532
    Run Time: 0.000137

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

21. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 220558
    Run Time: 0.000174

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

22. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 213666
    Run Time: 0.000134

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

23. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 213155
    Run Time: 0.000987

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

24. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 216370
    Run Time: 0.000209

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

25. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 202447
    Run Time: 0.000229

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

26. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 215097
    Run Time: 0.000157

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

27. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 216061
    Run Time: 0.000163

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

28. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 213146
    Run Time: 0.000131

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

29. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 217273
    Run Time: 0.000149

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

30. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 220542
    Run Time: 0.000147

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

31. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 217101
    Run Time: 0.000131

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

32. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 216375
    Run Time: 0.000186

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

33. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 201664
    Run Time: 0.000179

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

34. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 201845
    Run Time: 0.000170

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

35. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 211861
    Run Time: 0.000151

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

36. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 223652
    Run Time: 0.000148

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

37. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 208980
    Run Time: 0.000154

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

38. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 216298
    Run Time: 0.000137

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

39. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 212008
    Run Time: 0.000150

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

40. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 210939
    Run Time: 0.000150

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

41. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 210215
    Run Time: 0.000132

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

42. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 201317
    Run Time: 0.000150

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

43. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 211044
    Run Time: 0.000132

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

44. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 216339
    Run Time: 0.000134

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

45. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 201319
    Run Time: 0.000148

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

46. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 207440
    Run Time: 0.000133

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

47. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 224987
    Run Time: 0.000236

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

48. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 218139
    Run Time: 0.000151

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

49. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 207218
    Run Time: 0.000141

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

50. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 234884
    Run Time: 0.000194

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

51. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 210286
    Run Time: 0.000141

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

52. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 215911
    Run Time: 0.000142

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

53. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 217393
    Run Time: 0.000129

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

54. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 208325
    Run Time: 0.000121

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

55. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 216099
    Run Time: 0.000106

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

56. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 439
    Run Time: 0.000175

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

57. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 215568
    Run Time: 0.000137

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

58. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 203909
    Run Time: 0.000129

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

59. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 218223
    Run Time: 0.000132

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

60. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 203351
    Run Time: 0.000120

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

61. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 210247
    Run Time: 0.000154

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

62. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 227855
    Run Time: 0.000136

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

63. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 233766
    Run Time: 0.000131

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

64. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 219243
    Run Time: 0.000119

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

65. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 204630
    Run Time: 0.000129

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

66. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 234021
    Run Time: 0.000128

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

67. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 219441
    Run Time: 0.000107

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

68. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 213153
    Run Time: 0.000146

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

69. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 220544
    Run Time: 0.000114

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

70. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 215386
    Run Time: 0.000129

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

71. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 211308
    Run Time: 0.000128

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

72. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 211309
    Run Time: 0.000108

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

73. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 207553
    Run Time: 0.000108

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

74. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 207554
    Run Time: 0.000115

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

75. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 217312
    Run Time: 0.000105

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

76. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 226960
    Run Time: 0.000115

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

77. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 217562
    Run Time: 0.000128

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

78. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 226745
    Run Time: 0.000106

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

79. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 217810
    Run Time: 0.000174

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

80. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 209271
    Run Time: 0.000141

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

81. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 234331
    Run Time: 0.000118

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

82. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 224002
    Run Time: 0.000110

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

83. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 202209
    Run Time: 0.000126

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

84. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 216561
    Run Time: 0.000124

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

85. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 207120
    Run Time: 0.000114

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

86. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 216531
    Run Time: 0.000130

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

87. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 212019
    Run Time: 0.000120

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

88. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 210671
    Run Time: 0.000108

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

89. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 217103
    Run Time: 0.000107

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

90. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 210004
    Run Time: 0.000136

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

91. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 216813
    Run Time: 0.000117

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

92. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 215414
    Run Time: 0.000116

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

93. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 215501
    Run Time: 0.000122

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

94. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 202207
    Run Time: 0.000106

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

95. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 210442
    Run Time: 0.000109

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

96. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 214348
    Run Time: 0.000159

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

97. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 214349
    Run Time: 0.000114

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

98. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 210482
    Run Time: 0.000114

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

99. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = ?
    	AND content_id = ?

    Params: 1, sportsbook_category, 212479
    Run Time: 0.000139

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE								Impossible WHERE noticed after reading const tables

100. SELECT cache_value
     FROM xf_permission_cache_content
     WHERE permission_combination_id = ?
     	AND content_type = ?
     	AND content_id = ?

     Params: 1, sportsbook_category, 1197
     Run Time: 0.000138

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE								Impossible WHERE noticed after reading const tables

101. SELECT cache_value
     FROM xf_permission_cache_content
     WHERE permission_combination_id = ?
     	AND content_type = ?
     	AND content_id = ?

     Params: 1, sportsbook_category, 213141
     Run Time: 0.000149

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE								Impossible WHERE noticed after reading const tables

102. SELECT cache_value
     FROM xf_permission_cache_content
     WHERE permission_combination_id = ?
     	AND content_type = ?
     	AND content_id = ?

     Params: 1, sportsbook_category, 216294
     Run Time: 0.000155

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE								Impossible WHERE noticed after reading const tables

103. SELECT cache_value
     FROM xf_permission_cache_content
     WHERE permission_combination_id = ?
     	AND content_type = ?
     	AND content_id = ?

     Params: 1, sportsbook_category, 218659
     Run Time: 0.000152

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE								Impossible WHERE noticed after reading const tables

104. SELECT cache_value
     FROM xf_permission_cache_content
     WHERE permission_combination_id = ?
     	AND content_type = ?
     	AND content_id = ?

     Params: 1, sportsbook_category, 228213
     Run Time: 0.000183

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE								Impossible WHERE noticed after reading const tables

105. SELECT cache_value
     FROM xf_permission_cache_content
     WHERE permission_combination_id = ?
     	AND content_type = ?
     	AND content_id = ?

     Params: 1, sportsbook_category, 228215
     Run Time: 0.000136

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE								Impossible WHERE noticed after reading const tables

106. SELECT cache_value
     FROM xf_permission_cache_content
     WHERE permission_combination_id = ?
     	AND content_type = ?
     	AND content_id = ?

     Params: 1, sportsbook_category, 219649
     Run Time: 0.000136

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE								Impossible WHERE noticed after reading const tables

107. SELECT cache_value
     FROM xf_permission_cache_content
     WHERE permission_combination_id = ?
     	AND content_type = ?
     	AND content_id = ?

     Params: 1, sportsbook_category, 216341
     Run Time: 0.000131

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE								Impossible WHERE noticed after reading const tables

108. SELECT cache_value
     FROM xf_permission_cache_content
     WHERE permission_combination_id = ?
     	AND content_type = ?
     	AND content_id = ?

     Params: 1, sportsbook_category, 220795
     Run Time: 0.000193

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE								Impossible WHERE noticed after reading const tables

109. SELECT cache_value
     FROM xf_permission_cache_content
     WHERE permission_combination_id = ?
     	AND content_type = ?
     	AND content_id = ?

     Params: 1, sportsbook_category, 201290
     Run Time: 0.000135

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE								Impossible WHERE noticed after reading const tables

110. SELECT cache_value
     FROM xf_permission_cache_content
     WHERE permission_combination_id = ?
     	AND content_type = ?
     	AND content_id = ?

     Params: 1, sportsbook_category, 206882
     Run Time: 0.000118

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE								Impossible WHERE noticed after reading const tables

111. SELECT cache_value
     FROM xf_permission_cache_content
     WHERE permission_combination_id = ?
     	AND content_type = ?
     	AND content_id = ?

     Params: 1, sportsbook_category, 201212
     Run Time: 0.000170

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE								Impossible WHERE noticed after reading const tables

112. SELECT cache_value
     FROM xf_permission_cache_content
     WHERE permission_combination_id = ?
     	AND content_type = ?
     	AND content_id = ?

     Params: 1, sportsbook_category, 214556
     Run Time: 0.000162

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE								Impossible WHERE noticed after reading const tables

113. SELECT cache_value
     FROM xf_permission_cache_content
     WHERE permission_combination_id = ?
     	AND content_type = ?
     	AND content_id = ?

     Params: 1, sportsbook_category, 234912
     Run Time: 0.000135

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE								Impossible WHERE noticed after reading const tables

114. SELECT COUNT(*)
     FROM xf_nflj_sportsbook_event as event
     
     WHERE (event.category_id IN (268, 35179, 212148, 217271, 274, 201149, 1739, 6820, 2943, 1766, 6782, 10030, 198014, 8588, 194796, 8594, 8584, 1753, 194630, 1769, 1756, 8586, 66352, 4018, 1792, 6299, 216536, 1773, 6775, 285, 7167, 3, 4, 1817, 6486, 1818, 10336, 216565, 196778, 41, 5595, 293, 1834, 6310, 1835, 185632, 1836, 9320, 198082, 1715, 1293, 1295, 206704, 876, 203908, 10279, 72423, 1857, 10658, 303, 6417, 11670, 208753, 208793, 5591, 72425, 10921, 200797, 2473, 1872, 9531, 72429, 1880, 72427, 306, 1887, 1891, 6758, 1297, 313, 191393, 216945, 1904, 6666, 5096, 1913, 6426, 12, 5598, 6668, 9885, 125463, 207009, 196742, 321, 1977, 202195, 5938, 206706, 1979, 198704, 6276, 11697, 1957, 6303, 1958, 42016, 1978, 6678, 1951, 1952, 11693, 1980, 197646, 198002, 197438, 5487, 198316, 11695, 8713, 1989, 202722, 218837, 382, 4529, 1401, 2024, 6385, 2025, 196769, 15, 414, 415, 2032, 2036, 204807, 6267, 2037, 6495, 412, 2027, 200815, 4110, 10236, 1842, 423, 1843, 5886, 212023, 1844, 8564, 197439, 5874, 4117, 1107, 4118, 212006, 1845, 2067, 2073, 2065, 2066, 191452, 191453, 191447, 191454, 191448, 191449, 191450, 191451, 430, 6546, 6680, 2048, 192396, 6545, 194782, 6543, 194585, 2050, 191364, 17, 437, 2081, 206711, 6756, 18, 19, 196865, 9809, 2095, 215516, 69875, 210301, 2102, 204110, 10083, 198033, 203847, 199211, 201161, 2123, 194804, 2120, 6392, 2136, 462, 6650, 472, 470, 474, 10227, 2436, 197440, 5488, 4137, 4140, 4143, 2438, 5896, 217401, 88180, 197721, 206701, 2157, 6308, 2159, 6784, 10078, 482, 6227, 207551, 207559, 207552, 207560, 207012, 485, 2238, 244, 201165, 207004, 2242, 6423, 246, 2253, 487, 880, 1930, 1929, 6713, 1928, 216484, 216482, 889, 1456, 187703, 2259, 198115, 2331, 6816, 216405, 2333, 5888, 196861, 10573, 2359, 9591, 2366, 192394, 210237, 6633, 6985, 2368, 2374, 6421, 216357, 4173, 212020, 512, 210241, 4179, 215023, 517, 2387, 6814, 2386, 6600, 5433, 8128, 527, 2395, 16340, 199710, 35174, 1484, 2406, 6431, 4203, 10419, 16278, 2417, 6824, 2426, 6315, 2418, 198225, 2419, 2434, 544, 210245, 201139, 2453, 196725, 548, 2457, 194780, 28, 29, 196763, 196765, 559, 2196, 32746, 5490, 556, 1200, 210094, 215328, 2468, 218702, 2464, 2465, 2466, 210452, 5898, 2432, 4220, 4223, 1728, 6269, 210233, 2510, 2513, 1217, 217161, 1517, 2476, 6388, 567, 2518, 192764, 1532, 207051, 2517, 6428, 33, 6419, 198578, 2578, 192416, 197913, 2592, 6811, 8126, 16276, 2627, 2642, 197989, 5264, 214101, 2630, 2650, 6809, 5251, 5593, 198494, 205369, 1264, 2663, 6301, 201065, 5596, 34)) AND (event.event_status = 'open')

     Run Time: 0.616951

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE	event	ALL	category_date_edit				214681	Using where

115. SELECT event.*
     	,
     		category.*,
     		user.*, user_profile.*, IF(user.username IS NULL, event.username, user.username) AS username
     FROM xf_nflj_sportsbook_event AS event
     	
     		LEFT JOIN xf_nflj_sportsbook_category AS category ON
     			(category.category_id = event.category_id)
     		LEFT JOIN xf_user AS user ON
     			(user.user_id = event.user_id)
     		LEFT JOIN xf_user_profile AS user_profile ON
     			(user_profile.user_id = event.user_id)
     WHERE event.outcome_count > 0 AND (event.category_id IN (268, 35179, 212148, 217271, 274, 201149, 1739, 6820, 2943, 1766, 6782, 10030, 198014, 8588, 194796, 8594, 8584, 1753, 194630, 1769, 1756, 8586, 66352, 4018, 1792, 6299, 216536, 1773, 6775, 285, 7167, 3, 4, 1817, 6486, 1818, 10336, 216565, 196778, 41, 5595, 293, 1834, 6310, 1835, 185632, 1836, 9320, 198082, 1715, 1293, 1295, 206704, 876, 203908, 10279, 72423, 1857, 10658, 303, 6417, 11670, 208753, 208793, 5591, 72425, 10921, 200797, 2473, 1872, 9531, 72429, 1880, 72427, 306, 1887, 1891, 6758, 1297, 313, 191393, 216945, 1904, 6666, 5096, 1913, 6426, 12, 5598, 6668, 9885, 125463, 207009, 196742, 321, 1977, 202195, 5938, 206706, 1979, 198704, 6276, 11697, 1957, 6303, 1958, 42016, 1978, 6678, 1951, 1952, 11693, 1980, 197646, 198002, 197438, 5487, 198316, 11695, 8713, 1989, 202722, 218837, 382, 4529, 1401, 2024, 6385, 2025, 196769, 15, 414, 415, 2032, 2036, 204807, 6267, 2037, 6495, 412, 2027, 200815, 4110, 10236, 1842, 423, 1843, 5886, 212023, 1844, 8564, 197439, 5874, 4117, 1107, 4118, 212006, 1845, 2067, 2073, 2065, 2066, 191452, 191453, 191447, 191454, 191448, 191449, 191450, 191451, 430, 6546, 6680, 2048, 192396, 6545, 194782, 6543, 194585, 2050, 191364, 17, 437, 2081, 206711, 6756, 18, 19, 196865, 9809, 2095, 215516, 69875, 210301, 2102, 204110, 10083, 198033, 203847, 199211, 201161, 2123, 194804, 2120, 6392, 2136, 462, 6650, 472, 470, 474, 10227, 2436, 197440, 5488, 4137, 4140, 4143, 2438, 5896, 217401, 88180, 197721, 206701, 2157, 6308, 2159, 6784, 10078, 482, 6227, 207551, 207559, 207552, 207560, 207012, 485, 2238, 244, 201165, 207004, 2242, 6423, 246, 2253, 487, 880, 1930, 1929, 6713, 1928, 216484, 216482, 889, 1456, 187703, 2259, 198115, 2331, 6816, 216405, 2333, 5888, 196861, 10573, 2359, 9591, 2366, 192394, 210237, 6633, 6985, 2368, 2374, 6421, 216357, 4173, 212020, 512, 210241, 4179, 215023, 517, 2387, 6814, 2386, 6600, 5433, 8128, 527, 2395, 16340, 199710, 35174, 1484, 2406, 6431, 4203, 10419, 16278, 2417, 6824, 2426, 6315, 2418, 198225, 2419, 2434, 544, 210245, 201139, 2453, 196725, 548, 2457, 194780, 28, 29, 196763, 196765, 559, 2196, 32746, 5490, 556, 1200, 210094, 215328, 2468, 218702, 2464, 2465, 2466, 210452, 5898, 2432, 4220, 4223, 1728, 6269, 210233, 2510, 2513, 1217, 217161, 1517, 2476, 6388, 567, 2518, 192764, 1532, 207051, 2517, 6428, 33, 6419, 198578, 2578, 192416, 197913, 2592, 6811, 8126, 16276, 2627, 2642, 197989, 5264, 214101, 2630, 2650, 6809, 5251, 5593, 198494, 205369, 1264, 2663, 6301, 201065, 5596, 34)) AND (event.event_status = 'open')
     ORDER BY event.date_close ASC
      LIMIT 15 OFFSET 585

     Run Time: 2.654320

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE	event	range	category_date_edit	category_date_edit	4		89432	Using index condition; Using where; Using filesort
     SIMPLE	category	eq_ref	PRIMARY,category_id	PRIMARY	4	m11459_uabets.event.category_id	1
     SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	m11459_uabets.event.user_id	1
     SIMPLE	user_profile	eq_ref	PRIMARY	PRIMARY	4	m11459_uabets.event.user_id	1

116. SELECT event.*
     	,
     		category.*,
     		user.*, user_profile.*, IF(user.username IS NULL, event.username, user.username) AS username
     FROM xf_nflj_sportsbook_event AS event
     	
     		LEFT JOIN xf_nflj_sportsbook_category AS category ON
     			(category.category_id = event.category_id)
     		LEFT JOIN xf_user AS user ON
     			(user.user_id = event.user_id)
     		LEFT JOIN xf_user_profile AS user_profile ON
     			(user_profile.user_id = event.user_id)
     WHERE event.outcome_count > 0 AND (event.date_close < 1713733179) AND (event.event_status = 'open')
     ORDER BY event.date_close ASC
      LIMIT 9

     Run Time: 0.525616

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE	event	ALL					214681	Using where; Using filesort
     SIMPLE	category	eq_ref	PRIMARY,category_id	PRIMARY	4	m11459_uabets.event.category_id	1
     SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	m11459_uabets.event.user_id	1
     SIMPLE	user_profile	eq_ref	PRIMARY	PRIMARY	4	m11459_uabets.event.user_id	1

117. SELECT wager.user_id as userid, SUM(wager.fin_res) AS total_won, COUNT(wager.wager_settled) AS total_bets,
      SUM(case when wager_amount_won > 0 then 1 else 0 end) AS won_bets, SUM(case when wager.wager_pushed = 'Y' then 1 else 0 end) as pushed_bets,
       SUM(case when fin_res < 0 then 1 else 0 end) as lost_bets,
       SUM(case when wager.wager_settled = 'N' then 1 else 0 end) as pending_bets,
        SUM(IF(wager_settled = 'Y',wager.wager_amount_placed,0)) AS rollover,
        TRUNCATE((SUM(wager.fin_res)*100/SUM(IF(wager_settled = 'Y',wager.wager_amount_placed,0))),2) as roi,
        TRUNCATE((SUM(IF(wager_amount_won > 0, 1 + wager_odds_against/100, 0))/SUM(case when wager_amount_won > 0 then 1 else 0 end)),2) as won_kef,
        TRUNCATE((SUM(IF(wager_settled = 'Y', 1 + wager_odds_against/100, 0))/SUM(case when wager_settled = 'Y' then 1 else 0 end)),2) as all_kef,
     	user.username, user.avatar_date, user.avatar_width, user.avatar_height, user.gravatar, user.gender  
     FROM xf_nflj_sportsbook_wager AS wager
     	LEFT JOIN xf_user AS user
     		ON (user.user_id = wager.user_id)
     	LEFT JOIN xf_nflj_sportsbook_event AS event
     		ON (event.event_id = wager.event_id)				
     WHERE wager.private = 'N'				
     GROUP BY wager.user_id
     ORDER BY total_won DESC
     LIMIT ?

     Params: 40
     Run Time: 0.211636

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE	wager	ALL					34615	Using where; Using temporary; Using filesort
     SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	m11459_uabets.wager.user_id	1

118. SELECT wager.user_id as userid, TRUNCATE(SUM(wager.fin_res),2) AS total_won, COUNT(wager.wager_settled) AS total_bets,
      SUM(case when wager_amount_won > 0 then 1 else 0 end) AS won_bets, SUM(case when wager.wager_pushed = 'Y' then 1 else 0 end) as pushed_bets,
       SUM(case when fin_res < 0 then 1 else 0 end) as lost_bets,
       SUM(case when wager.wager_settled = 'N' then 1 else 0 end) as pending_bets,
        SUM(IF(wager_settled = 'Y',wager.wager_amount_placed,0)) AS rollover,
        MAX(wager.wager_amount_placed) AS maxbet,
        TRUNCATE((SUM(wager.fin_res)*100/SUM(IF(wager_settled = 'Y',wager.wager_amount_placed,0))),2) as roi,
        TRUNCATE((SUM(IF(wager_amount_won > 0, 1 + wager_odds_against/100, 0))/SUM(case when wager_amount_won > 0 then 1 else 0 end)),2) as won_kef,
        TRUNCATE((SUM(IF(wager_settled = 'Y', 1 + wager_odds_against/100, 0))/SUM(case when wager_settled = 'Y' then 1 else 0 end)),2) as all_kef,
     	user.username, event.date_close
     FROM xf_nflj_sportsbook_wager AS wager
     	LEFT JOIN xf_user AS user
     		ON (user.user_id = wager.user_id)
     	LEFT JOIN xf_nflj_sportsbook_event AS event
     		ON (event.event_id = wager.event_id)
     	LEFT JOIN xf_nflj_sportsbook_category AS category
     		ON (event.category_id = category.category_id)					
     WHERE wager.private = 'N'
     AND date_close > 1668950000
     AND event.category_id IN (2686, 8581, 201691)
     GROUP BY wager.user_id
     ORDER BY roi DESC

     Run Time: 0.014166

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE	event	range	PRIMARY,category_date_edit	category_date_edit	4		400	Using index condition; Using where; Using temporary; Using filesort
     SIMPLE	wager	ref	event_id	event_id	4	m11459_uabets.event.event_id	1	Using where
     SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	m11459_uabets.wager.user_id	1

119. INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)

     Params: 1cd7f35683eb4a1e8907bcd22eac96ac, , 1713563979
     Run Time: 0.000502

120. INSERT INTO xf_session_activity
     	(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key)
     VALUES
     	(?, ?, ?, ?, ?, ?, ?, ?, ?)
     ON DUPLICATE KEY UPDATE
     	ip = VALUES(ip),
     	controller_name = VALUES(controller_name),
     	controller_action = VALUES(controller_action),
     	view_state = VALUES(view_state),
     	params = VALUES(params),
     	view_date = VALUES(view_date),
     	robot_key = VALUES(robot_key)

     Params: 0, , , NFLJ_Sportsbook_ControllerPublic_Sportsbook, Index, valid, , 1713560379,
     Run Time: 0.000153

121. SELECT title, template_compiled
     FROM xf_template_compiled
     WHERE title IN ('page_nav', 'nflj_sportsbook_index', 'EWRporta2_Navtabs', 'nflj_sportsbook_tab_links', 'siropu_custom_tabs_child_list', 'xfa_blog_navigation_links', 'siropu_chat', 'siropu_chat_disabled', 'xfa_blog_navigation_tab_link', 'PAGE_CONTAINER')
     	AND style_id = ?
     	AND language_id = ?

     Params: 1, 2
     Run Time: 0.003819

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE	xf_template_compiled	range	PRIMARY	PRIMARY	60		10	Using where

122. SELECT title, template_compiled
     FROM xf_template_compiled
     WHERE title IN ('BRME_page_container_head')
     	AND style_id = ?
     	AND language_id = ?

     Params: 1, 2
     Run Time: 0.000472

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE	xf_template_compiled	const	PRIMARY	PRIMARY	60	const,const,const	1

123. SELECT title, template_compiled
     FROM xf_template_compiled
     WHERE title IN ('social_likes_library')
     	AND style_id = ?
     	AND language_id = ?

     Params: 1, 2
     Run Time: 0.000452

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE	xf_template_compiled	const	PRIMARY	PRIMARY	60	const,const,const	1

124. SELECT *
     FROM merc_ad_last_view
     ORDER BY view_date ASC

     Run Time: 0.000122

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE	merc_ad_last_view	system					0	const row not found

Included Files (118, XenForo Classes: 44)

1. index.php
2. library/XenForo/Autoloader.php
3. library/XenForo/Application.php
4. library/Zend/Registry.php
5. library/Lgpl/utf8.php
6. library/Zend/Config.php
7. library/config.php
8. library/XenForo/FrontController.php
9. library/XenForo/Dependencies/Public.php
10. library/XenForo/Dependencies/Abstract.php
11. library/Zend/Controller/Request/Http.php
12. library/Zend/Controller/Request/Abstract.php
13. library/Zend/Uri.php
14. library/Zend/Controller/Response/Http.php
15. library/Zend/Controller/Response/Abstract.php
16. library/XenForo/Model/DataRegistry.php
17. library/XenForo/Model.php
18. library/Zend/Db.php
19. library/Zend/Db/Adapter/Mysqli.php
20. library/Zend/Db/Adapter/Abstract.php
21. library/Zend/Db/Select.php
22. library/Zend/Db/Expr.php
23. library/Zend/Db/Profiler.php
24. library/Zend/Db/Statement/Mysqli.php
25. library/Zend/Db/Statement.php
26. library/Zend/Db/Statement/Interface.php
27. library/Zend/Db/Profiler/Query.php
28. library/XenForo/CodeEvent.php
29. library/XenForo/Options.php
30. library/XenForo/Link.php
31. library/XenForo/Template/Helper/Core.php
32. library/EWRporta2/Listener/Init.php
33. library/NFLJ/Sportsbook/Listener/Proxy.php
34. library/Brivium/BriviumHelper/EventListeners.php
35. library/Brivium/BriviumHelper/1010071/EventListeners.php
36. library/EWRporta2/Listener/Model.php
37. library/Siropu/Chat/Listener.php
38. library/Merc/AdManager/Listener/LoadClass.php
39. library/XenPlus/Listener/LoadClass.php
40. library/XenPlus/Listener/Abstract.php
41. library/ExternalExtended/Listener.php
42. library/XfAddOns/Blogs/Listener.php
43. library/XfAddOns/Blogs/Install/Version.php
44. library/bdMedal/Listener.php
45. library/DevKit/Listener/Listener.php
46. library/Esthetic/EBBC/Listener/Model.php
47. library/Brivium/CustomNodeStyle/EventListener/Listener.php
48. library/Merc/AdManager/Listener/InitDependencies.php
49. library/XenPlus/Listener/InitDependencies.php
50. library/Esthetic/EBBC/Listener/Dependencies.php
51. library/Esthetic/EBBC/Service/Config.php
52. library/XenForo/Router.php
53. library/XenForo/Route/Filter.php
54. library/XenForo/Route/Interface.php
55. library/XenForo/Route/ResponseSuffix.php
56. library/XenForo/Route/Prefix.php
57. library/NFLJ/Sportsbook/Route/Prefix/Sportsbook.php
58. library/XenForo/RouteMatch.php
59. library/NFLJ/Sportsbook/ControllerPublic/Sportsbook.php
60. library/XenForo/ControllerPublic/Abstract.php
61. library/XenForo/Controller.php
62. library/EWRporta2/Listener/Controller.php
63. library/XI/Tag/CodeEvent/Listener.php
64. library/Esthetic/EBBC/Listener/Controller.php
65. library/XenForo/Input.php
66. library/XenForo/Session.php
67. library/XenForo/Helper/Ip.php
68. library/XenForo/Visitor.php
69. library/XenForo/Model/User.php
70. library/EWRporta2/Model/User.php
71. library/XfAddOns/Blogs/Override/Model/User.php
72. library/XenForo/Permission.php
73. library/XenForo/Helper/Php.php
74. library/XenForo/Phrase.php
75. library/XenForo/Locale.php
76. library/NFLJ/Sportsbook/Model/Event.php
77. library/NFLJ/Sportsbook/Model/Category.php
78. library/NFLJ/Sportsbook/Model/Stats.php
79. library/XenForo/Model/PermissionCache.php
80. library/XenForo/Helper/String.php
81. library/XenForo/ControllerResponse/View.php
82. library/XenForo/ControllerResponse/Abstract.php
83. library/XenForo/Helper/Cookie.php
84. library/XenForo/ViewRenderer/HtmlPublic.php
85. library/XenForo/ViewRenderer/Abstract.php
86. library/XenForo/Template/Public.php
87. library/XenForo/Template/Abstract.php
88. library/EWRporta2/Listener/ViewPublic.php
89. library/Esthetic/EBBC/Listener/View.php
90. library/XenForo/ViewPublic/Base.php
91. library/XenForo/View.php
92. library/NFLJ/Sportsbook/Listener/Template.php
93. library/Brivium/MetadataEssential/EventListeners/Listener.php
94. library/Siropu/CustomTabs/Listener.php
95. library/XfAddOns/Blogs/Template/Hook.php
96. library/XenForo/Route/Prefix/Members.php
97. library/EWRporta2/Listener/NavTabs.php
98. library/EWRporta2/Model/Perms.php
99. library/Siropu/CustomTabs/Model.php
100. library/Siropu/CustomTabs/Helper.php
101. library/XenForo/Helper/Criteria.php
102. library/bdMedal/Option.php
103. library/Siropu/Chat/Helper.php
104. library/XfAddOns/Blogs/Template/Navigation.php
105. library/XfAddOns/Blogs/Model/MultiBlog.php
106. library/XenForo/Model/Avatar.php
107. library/NFLJ/Sportsbook/ViewPublic/Helper/Event.php
108. library/Merc/AdManager/Listener/TemplatePostRender.php
109. library/XenPlus/Listener/TemplatePostRender.php
110. library/Merc/AdManager/Listener/TemplateHook.php
111. library/XenPlus/Listener/TemplateHook.php
112. library/XenForo/Debug.php
113. library/xenCODE/Anonymizer/Listener.php
114. library/EWRporta2/Listener/Template.php
115. library/SocialLikes/Listener.php
116. library/XenPlus/Helper/Listener.php
117. library/Merc/AdManager/Model/Ad.php
118. library/XenForo/ViewRenderer/Json.php