Page Time: 1.4683s

Memory: 11.9135 MB (Peak: 13.5015 MB)

Queries (71, time: 1.2553s, 85.5%)

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

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

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

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

   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,
   		0 AS forum_is_watched
   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.category_id = ?

   Params: 4
   Run Time: 0.000936

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	category	const	PRIMARY,category_id	PRIMARY	4	const	1
   SIMPLE	permission	const	PRIMARY	PRIMARY	35	const,const,const	1

6. 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.075943

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

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

   Params: 1, sportsbook_category, 219288
   Run Time: 0.000300

   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, 219635
   Run Time: 0.000176

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

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

    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, 234893
    Run Time: 0.000143

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

    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, 234926
    Run Time: 0.000173

    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, 234925
    Run Time: 0.000507

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

    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, 212624
    Run Time: 0.000372

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

    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, 235072
    Run Time: 0.000431

    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, 199145
    Run Time: 0.000603

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

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

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

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

    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, 210902
    Run Time: 0.000405

    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, 213146
    Run Time: 0.000173

    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, 210939
    Run Time: 0.000176

    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, 216389
    Run Time: 0.000219

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

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

    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, 409
    Run Time: 0.000220

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

    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, 216812
    Run Time: 0.000159

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

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

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

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

    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, 219439
    Run Time: 0.000130

    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, 215919
    Run Time: 0.000171

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

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

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

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

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

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

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

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

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

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

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

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

    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, 219072
    Run Time: 0.000130

    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, 199020
    Run Time: 0.000228

    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, 207120
    Run Time: 0.000153

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

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

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

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

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

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

    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, 235018
    Run Time: 0.000130

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

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

62. SELECT COUNT(*)
    FROM xf_nflj_sportsbook_event as event
    
    WHERE (event.category_id IN (268, 217271, 274, 285, 293, 203908, 303, 306, 313, 207009, 321, 382, 408, 415, 412, 430, 437, 204110, 462, 482, 485, 487, 512, 527, 523, 556, 565, 567, 197913, 5251, 4)) AND (event.event_status = 'open')

    Run Time: 0.318034

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	event	range	category_date_edit	category_date_edit	4		10905	Using index condition; Using where

63. 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, 217271, 274, 285, 293, 203908, 303, 306, 313, 207009, 321, 382, 408, 415, 412, 430, 437, 204110, 462, 482, 485, 487, 512, 527, 523, 556, 565, 567, 197913, 5251, 4)) AND (event.event_status = 'open')
    ORDER BY event.date_close ASC
     LIMIT 10

    Run Time: 0.277668

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

64. SELECT SUM(event.view_count) views, SUM(event.comment_count) comments, SUM(event.outcome_count) outcomes, SUM(event.wagers_placed) wagers,
    	SUM(event.amount_staked) handle, SUM(event.amount_paidout) paidout, COUNT(*) AS events
    FROM xf_nflj_sportsbook_event AS event
    WHERE event.category_id IN	(268, 217271, 274, 285, 293, 203908, 303, 306, 313, 207009, 321, 382, 408, 415, 412, 430, 437, 204110, 462, 482, 485, 487, 512, 527, 523, 556, 565, 567, 197913, 5251, 4)
    	AND event.event_status NOT IN ('pending','deleted')
    ORDER BY views DESC

    Run Time: 0.289647

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	event	range	category_date_edit	category_date_edit	4		10905	Using index condition; Using where; Using temporary

65. 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, 217271, 274, 285, 293, 203908, 303, 306, 313, 207009, 321, 382, 408, 415, 412, 430, 437, 204110, 462, 482, 485, 487, 512, 527, 523, 556, 565, 567, 197913, 5251, 4)) AND (event.date_close < 1713588330) AND (event.event_status = 'open')
    ORDER BY event.date_close ASC
     LIMIT 5

    Run Time: 0.274667

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

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

    Params: c1843a3f78c470ce351d33d01e1e932d, , 1713419130
    Run Time: 0.000310

67. 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, Category, valid, category_id=4, 1713415530,
    Run Time: 0.000138

68. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('page_nav', 'nflj_sportsbook_category_sidebar_list', 'nflj_sportsbook_category', '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.003606

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

69. 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.000433

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

70. 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.000315

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

71. SELECT *
    FROM merc_ad_last_view
    ORDER BY view_date ASC

    Run Time: 0.000108

    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 (121, XenForo Classes: 45)

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/ControllerHelper/Sportsbook.php
78. library/XenForo/ControllerHelper/Abstract.php
79. library/NFLJ/Sportsbook/Model/Category.php
80. library/XenForo/Helper/String.php
81. library/NFLJ/Sportsbook/Model/Stats.php
82. library/XenForo/Model/PermissionCache.php
83. library/XenForo/ControllerResponse/View.php
84. library/XenForo/ControllerResponse/Abstract.php
85. library/XenForo/Helper/Cookie.php
86. library/XenForo/ViewRenderer/HtmlPublic.php
87. library/XenForo/ViewRenderer/Abstract.php
88. library/XenForo/Template/Public.php
89. library/XenForo/Template/Abstract.php
90. library/NFLJ/Sportsbook/ViewPublic/Category.php
91. library/XenForo/ViewPublic/Base.php
92. library/XenForo/View.php
93. library/EWRporta2/Listener/ViewPublic.php
94. library/Esthetic/EBBC/Listener/View.php
95. library/NFLJ/Sportsbook/Listener/Template.php
96. library/Brivium/MetadataEssential/EventListeners/Listener.php
97. library/Siropu/CustomTabs/Listener.php
98. library/XfAddOns/Blogs/Template/Hook.php
99. library/XenForo/Route/Prefix/Members.php
100. library/EWRporta2/Listener/NavTabs.php
101. library/EWRporta2/Model/Perms.php
102. library/Siropu/CustomTabs/Model.php
103. library/Siropu/CustomTabs/Helper.php
104. library/XenForo/Helper/Criteria.php
105. library/bdMedal/Option.php
106. library/Siropu/Chat/Helper.php
107. library/XfAddOns/Blogs/Template/Navigation.php
108. library/XfAddOns/Blogs/Model/MultiBlog.php
109. library/XenForo/Model/Avatar.php
110. library/NFLJ/Sportsbook/ViewPublic/Helper/Event.php
111. library/Merc/AdManager/Listener/TemplatePostRender.php
112. library/XenPlus/Listener/TemplatePostRender.php
113. library/Merc/AdManager/Listener/TemplateHook.php
114. library/XenPlus/Listener/TemplateHook.php
115. library/XenForo/Debug.php
116. library/xenCODE/Anonymizer/Listener.php
117. library/EWRporta2/Listener/Template.php
118. library/SocialLikes/Listener.php
119. library/XenPlus/Helper/Listener.php
120. library/Merc/AdManager/Model/Ad.php
121. library/XenForo/ViewRenderer/Json.php