Page Time: 4.1358s

Memory: 11.2180 MB (Peak: 13.1842 MB)

Queries (109, time: 3.9342s, 95.1%)

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.001470

   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.000285

   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.000279

   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.000244

   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.081917

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	category	ALL					14514	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, 219635
   Run Time: 0.000261

   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, 226742
   Run Time: 0.000152

   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, 226450
   Run Time: 0.000174

   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, 204784
   Run Time: 0.000265

   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, 204785
    Run Time: 0.000152

    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, 213151
    Run Time: 0.000144

    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, 234896
    Run Time: 0.000167

    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, 234895
    Run Time: 0.000133

    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, 234927
    Run Time: 0.000131

    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, 212625
    Run Time: 0.000210

    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, 235074
    Run Time: 0.000140

    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, 220573
    Run Time: 0.000165

    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, 213554
    Run Time: 0.000160

    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, 213143
    Run Time: 0.000139

    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, 220538
    Run Time: 0.000150

    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, 220536
    Run Time: 0.000145

    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, 220532
    Run Time: 0.000132

    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, 213666
    Run Time: 0.000129

    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, 206484
    Run Time: 0.000150

    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, 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

26. 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.000177

    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, 215097
    Run Time: 0.000169

    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.000135

    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, 220542
    Run Time: 0.000133

    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, 216375
    Run Time: 0.000148

    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, 201664
    Run Time: 0.000161

    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, 208980
    Run Time: 0.000142

    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, 216754
    Run Time: 0.000151

    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, 212008
    Run Time: 0.000158

    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, 228205
    Run Time: 0.000161

    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, 222925
    Run Time: 0.000150

    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, 210215
    Run Time: 0.000139

    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, 201319
    Run Time: 0.000163

    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, 207440
    Run Time: 0.000139

    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, 224987
    Run Time: 0.000137

    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, 218139
    Run Time: 0.000163

    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, 207218
    Run Time: 0.000170

    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, 208363
    Run Time: 0.000187

    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, 201512
    Run Time: 0.000154

    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, 210619
    Run Time: 0.000136

    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, 216143
    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, 210286
    Run Time: 0.000151

    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, 215597
    Run Time: 0.000133

    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, 217393
    Run Time: 0.000135

    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, 431
    Run Time: 0.000198

    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, 208325
    Run Time: 0.000167

    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, 439
    Run Time: 0.000136

    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, 203909
    Run Time: 0.000186

    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, 216897
    Run Time: 0.000151

    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, 203351
    Run Time: 0.000152

    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, 210247
    Run Time: 0.000134

    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, 227855
    Run Time: 0.000149

    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, 219242
    Run Time: 0.000132

    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, 234020
    Run Time: 0.000131

    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, 219440
    Run Time: 0.000155

    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, 220544
    Run Time: 0.000136

    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, 215386
    Run Time: 0.000134

    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, 211308
    Run Time: 0.000166

    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, 211309
    Run Time: 0.000135

    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, 207553
    Run Time: 0.000141

    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, 216288
    Run Time: 0.000147

    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, 226960
    Run Time: 0.000140

    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, 217562
    Run Time: 0.000138

    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, 226745
    Run Time: 0.000147

    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, 209271
    Run Time: 0.000165

    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, 234331
    Run Time: 0.000134

    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, 202209
    Run Time: 0.000163

    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, 222893
    Run Time: 0.000134

    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, 216541
    Run Time: 0.000181

    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, 210715
    Run Time: 0.000160

    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, 216561
    Run Time: 0.000180

    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, 219074
    Run Time: 0.000161

    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, 212019
    Run Time: 0.000154

    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, 210671
    Run Time: 0.000140

    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, 210004
    Run Time: 0.000147

    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, 216408
    Run Time: 0.000136

    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, 202207
    Run Time: 0.000134

    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, 210442
    Run Time: 0.000149

    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, 216243
    Run Time: 0.000166

    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, 210285
    Run Time: 0.000182

    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, 212479
    Run Time: 0.000178

    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, 213141
    Run Time: 0.000198

    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, 218659
    Run Time: 0.000142

    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, 228213
    Run Time: 0.000138

    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, 228215
    Run Time: 0.000149

    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, 216542
    Run Time: 0.000138

    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, 207052
    Run Time: 0.000137

    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, 220795
    Run Time: 0.000178

    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, 201290
    Run Time: 0.000204

    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, 206882
    Run Time: 0.000208

    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, 214556
    Run Time: 0.000230

    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, 234911
    Run Time: 0.000150

    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, 235021
    Run Time: 0.000168

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

99. SELECT COUNT(*)
    FROM xf_nflj_sportsbook_event as event
    
    WHERE (event.category_id IN (268, 35179, 200506, 200835, 8667, 274, 201149, 1739, 6820, 2943, 1766, 6782, 10030, 198014, 8588, 8584, 1753, 1769, 1756, 8586, 66352, 1792, 6299, 1275, 1773, 6775, 201501, 285, 1784, 7167, 201167, 3, 4, 6416, 4022, 1817, 6486, 1818, 10336, 216565, 196778, 41, 1826, 293, 1834, 6310, 1835, 185632, 1836, 9320, 198082, 297, 1293, 1295, 206704, 876, 203908, 10279, 72423, 1857, 10658, 303, 6417, 11670, 1863, 5591, 72425, 10921, 200797, 1872, 9531, 72429, 1880, 72427, 1881, 306, 1887, 210239, 1891, 6758, 1297, 4058, 313, 191393, 216945, 1904, 6666, 5096, 1316, 1913, 6426, 207048, 12, 5598, 6668, 9885, 125463, 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, 201777, 408, 4529, 1401, 2024, 6385, 2025, 196769, 15, 415, 2032, 212010, 2033, 2036, 204807, 6267, 2037, 6495, 412, 2027, 200815, 192419, 4109, 10236, 1842, 423, 1843, 5886, 212023, 1844, 8564, 197439, 5874, 1107, 212006, 1845, 2067, 1419, 149036, 2073, 2065, 2066, 191452, 191453, 191447, 197470, 191454, 191448, 191449, 191450, 191451, 197471, 430, 6546, 6680, 2048, 6545, 194782, 6543, 194585, 2050, 191364, 17, 437, 2081, 206711, 6756, 18, 19, 196865, 9809, 2095, 215516, 69875, 2102, 204110, 213144, 10083, 198033, 203847, 199211, 201161, 2118, 2123, 194804, 2120, 6392, 198331, 2133, 2136, 462, 6650, 470, 474, 10227, 2436, 197440, 5488, 2438, 5896, 217401, 197721, 206701, 2157, 6308, 2159, 6784, 10078, 6227, 207551, 207559, 207552, 207560, 2238, 201165, 207004, 2242, 6423, 246, 2253, 487, 880, 1930, 1929, 6713, 1928, 889, 1456, 2259, 198115, 2331, 6816, 216405, 2333, 5888, 196861, 10573, 2359, 9591, 2366, 192394, 210237, 6633, 6985, 2368, 2374, 6421, 216357, 512, 210241, 4179, 215023, 2387, 6814, 2386, 6600, 5433, 8128, 527, 2395, 16340, 199710, 35174, 198010, 149037, 1484, 2406, 6431, 4203, 5154, 10419, 16278, 2417, 6824, 2426, 6315, 2418, 198225, 2419, 2434, 1497, 544, 1498, 201139, 2453, 196725, 548, 2457, 194780, 28, 29, 196763, 196765, 2196, 32746, 5490, 556, 1200, 215328, 2468, 218702, 2464, 2465, 2466, 210452, 5898, 2432, 4220, 1728, 6269, 565, 210233, 2510, 2513, 5095, 1217, 1512, 217161, 1517, 2476, 6388, 567, 2518, 192764, 1532, 2517, 6428, 33, 6419, 198578, 2578, 192416, 197913, 2592, 6811, 8126, 16276, 2627, 2642, 197989, 5264, 214101, 2630, 6619, 6912, 2650, 6809, 5251, 5593, 198494, 1264, 2663, 6301, 201065, 5596, 34, 1603)) AND (event.event_status = 'open')

    Run Time: 0.595210

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

100. 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, 200506, 200835, 8667, 274, 201149, 1739, 6820, 2943, 1766, 6782, 10030, 198014, 8588, 8584, 1753, 1769, 1756, 8586, 66352, 1792, 6299, 1275, 1773, 6775, 201501, 285, 1784, 7167, 201167, 3, 4, 6416, 4022, 1817, 6486, 1818, 10336, 216565, 196778, 41, 1826, 293, 1834, 6310, 1835, 185632, 1836, 9320, 198082, 297, 1293, 1295, 206704, 876, 203908, 10279, 72423, 1857, 10658, 303, 6417, 11670, 1863, 5591, 72425, 10921, 200797, 1872, 9531, 72429, 1880, 72427, 1881, 306, 1887, 210239, 1891, 6758, 1297, 4058, 313, 191393, 216945, 1904, 6666, 5096, 1316, 1913, 6426, 207048, 12, 5598, 6668, 9885, 125463, 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, 201777, 408, 4529, 1401, 2024, 6385, 2025, 196769, 15, 415, 2032, 212010, 2033, 2036, 204807, 6267, 2037, 6495, 412, 2027, 200815, 192419, 4109, 10236, 1842, 423, 1843, 5886, 212023, 1844, 8564, 197439, 5874, 1107, 212006, 1845, 2067, 1419, 149036, 2073, 2065, 2066, 191452, 191453, 191447, 197470, 191454, 191448, 191449, 191450, 191451, 197471, 430, 6546, 6680, 2048, 6545, 194782, 6543, 194585, 2050, 191364, 17, 437, 2081, 206711, 6756, 18, 19, 196865, 9809, 2095, 215516, 69875, 2102, 204110, 213144, 10083, 198033, 203847, 199211, 201161, 2118, 2123, 194804, 2120, 6392, 198331, 2133, 2136, 462, 6650, 470, 474, 10227, 2436, 197440, 5488, 2438, 5896, 217401, 197721, 206701, 2157, 6308, 2159, 6784, 10078, 6227, 207551, 207559, 207552, 207560, 2238, 201165, 207004, 2242, 6423, 246, 2253, 487, 880, 1930, 1929, 6713, 1928, 889, 1456, 2259, 198115, 2331, 6816, 216405, 2333, 5888, 196861, 10573, 2359, 9591, 2366, 192394, 210237, 6633, 6985, 2368, 2374, 6421, 216357, 512, 210241, 4179, 215023, 2387, 6814, 2386, 6600, 5433, 8128, 527, 2395, 16340, 199710, 35174, 198010, 149037, 1484, 2406, 6431, 4203, 5154, 10419, 16278, 2417, 6824, 2426, 6315, 2418, 198225, 2419, 2434, 1497, 544, 1498, 201139, 2453, 196725, 548, 2457, 194780, 28, 29, 196763, 196765, 2196, 32746, 5490, 556, 1200, 215328, 2468, 218702, 2464, 2465, 2466, 210452, 5898, 2432, 4220, 1728, 6269, 565, 210233, 2510, 2513, 5095, 1217, 1512, 217161, 1517, 2476, 6388, 567, 2518, 192764, 1532, 2517, 6428, 33, 6419, 198578, 2578, 192416, 197913, 2592, 6811, 8126, 16276, 2627, 2642, 197989, 5264, 214101, 2630, 6619, 6912, 2650, 6809, 5251, 5593, 198494, 1264, 2663, 6301, 201065, 5596, 34, 1603)) AND (event.event_status = 'open')
     ORDER BY event.date_close ASC
      LIMIT 15 OFFSET 60

     Run Time: 2.566947

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE	event	range	category_date_edit	category_date_edit	4		93593	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

101. 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 < 1713706928) AND (event.event_status = 'open')
     ORDER BY event.date_close ASC
      LIMIT 9

     Run Time: 0.504345

     Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
     SIMPLE	event	ALL					189226	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

102. 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.154073

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

103. 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.010425

     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

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

     Params: 1c48da66fedd034933b90ba35e686a33, , 1713537728
     Run Time: 0.000177

105. 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, , 1713534128,
     Run Time: 0.000150

106. 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.003254

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

107. 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.000404

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

108. 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.000310

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

109. SELECT *
     FROM merc_ad_last_view
     ORDER BY view_date ASC

     Run Time: 0.000106

     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