Page Time: 3.3556s

Memory: 10.6443 MB (Peak: 12.1291 MB)

Queries (98, time: 3.1771s, 94.7%)

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

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

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

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

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

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

   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, 215563
   Run Time: 0.000231

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    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, 202447
    Run Time: 0.000194

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

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

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

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

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

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

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

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

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

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

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

    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, 210213
    Run Time: 0.000177

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

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

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

39. 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.000142

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

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

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

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

    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, 219363
    Run Time: 0.000214

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

    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, 234909
    Run Time: 0.000196

    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, 235019
    Run Time: 0.000184

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

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

88. SELECT COUNT(*)
    FROM xf_nflj_sportsbook_event as event
    
    WHERE (event.category_id IN (268, 1708, 9596, 1709, 35179, 200506, 1725, 200835, 8667, 212148, 217271, 274, 201149, 1739, 201151, 200786, 1742, 3569, 3571, 8387, 2944, 2945, 1766, 10030, 1792, 1275, 1773, 1797, 192105, 3, 4, 1282, 1817, 1818, 216565, 196778, 41, 198700, 201007, 192701, 293, 1834, 6310, 9320, 1839, 202119, 1293, 1295, 206704, 876, 1857, 10658, 6417, 5591, 72425, 10921, 2473, 1872, 9531, 72429, 1880, 72427, 306, 1887, 9441, 1891, 1297, 313, 216945, 1904, 5096, 1316, 1913, 1924, 207048, 12, 5598, 6668, 197248, 9885, 125463, 207009, 321, 1977, 202195, 5938, 1979, 191446, 11697, 1957, 6303, 1958, 42016, 1978, 6678, 1951, 1952, 11693, 201373, 1980, 5487, 201331, 11695, 8713, 1989, 202722, 197844, 382, 367, 2020, 408, 4107, 4529, 2024, 2025, 15, 414, 2032, 1080, 2036, 6267, 2037, 1413, 2027, 4109, 10236, 1842, 1843, 212023, 1844, 5874, 212006, 2067, 1419, 149036, 2073, 2065, 191453, 191447, 197470, 191454, 191451, 197471, 430, 6546, 6680, 6543, 216381, 17, 437, 2081, 18, 19, 9809, 2095, 210301, 2102, 213144, 196933, 10083, 199211, 201161, 2123, 194804, 2120, 2136, 192533, 470, 2436, 5488, 2438, 8342, 88177, 88172, 2157, 2159, 4995, 6595, 482, 6227, 207551, 207552, 2203, 485, 2242, 246, 487, 880, 1930, 1929, 889, 1456, 187703, 2259, 198115, 2331, 2333, 5888, 215434, 10573, 2359, 9591, 6633, 2374, 216357, 4173, 512, 2384, 215023, 2387, 2386, 6600, 5433, 8128, 11711, 2396, 527, 2395, 2409, 2406, 10600, 10419, 2417, 2418, 198225, 2421, 6519, 2454, 544, 1498, 2453, 548, 2457, 28, 29, 196763, 196765, 2196, 5490, 1200, 2468, 2432, 1728, 565, 210233, 5095, 1217, 1512, 217161, 1517, 2476, 6388, 567, 2518, 1532, 2517, 210948, 33, 6419, 2578, 2592, 210291, 8126, 16276, 2627, 16325, 5452, 5264, 214101, 2630, 185678, 6263, 2650, 6809, 5251, 5593, 198494, 1264, 2663, 34, 604, 3522)) AND (event.event_status = 'open')

    Run Time: 0.630423

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

89. 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, 1708, 9596, 1709, 35179, 200506, 1725, 200835, 8667, 212148, 217271, 274, 201149, 1739, 201151, 200786, 1742, 3569, 3571, 8387, 2944, 2945, 1766, 10030, 1792, 1275, 1773, 1797, 192105, 3, 4, 1282, 1817, 1818, 216565, 196778, 41, 198700, 201007, 192701, 293, 1834, 6310, 9320, 1839, 202119, 1293, 1295, 206704, 876, 1857, 10658, 6417, 5591, 72425, 10921, 2473, 1872, 9531, 72429, 1880, 72427, 306, 1887, 9441, 1891, 1297, 313, 216945, 1904, 5096, 1316, 1913, 1924, 207048, 12, 5598, 6668, 197248, 9885, 125463, 207009, 321, 1977, 202195, 5938, 1979, 191446, 11697, 1957, 6303, 1958, 42016, 1978, 6678, 1951, 1952, 11693, 201373, 1980, 5487, 201331, 11695, 8713, 1989, 202722, 197844, 382, 367, 2020, 408, 4107, 4529, 2024, 2025, 15, 414, 2032, 1080, 2036, 6267, 2037, 1413, 2027, 4109, 10236, 1842, 1843, 212023, 1844, 5874, 212006, 2067, 1419, 149036, 2073, 2065, 191453, 191447, 197470, 191454, 191451, 197471, 430, 6546, 6680, 6543, 216381, 17, 437, 2081, 18, 19, 9809, 2095, 210301, 2102, 213144, 196933, 10083, 199211, 201161, 2123, 194804, 2120, 2136, 192533, 470, 2436, 5488, 2438, 8342, 88177, 88172, 2157, 2159, 4995, 6595, 482, 6227, 207551, 207552, 2203, 485, 2242, 246, 487, 880, 1930, 1929, 889, 1456, 187703, 2259, 198115, 2331, 2333, 5888, 215434, 10573, 2359, 9591, 6633, 2374, 216357, 4173, 512, 2384, 215023, 2387, 2386, 6600, 5433, 8128, 11711, 2396, 527, 2395, 2409, 2406, 10600, 10419, 2417, 2418, 198225, 2421, 6519, 2454, 544, 1498, 2453, 548, 2457, 28, 29, 196763, 196765, 2196, 5490, 1200, 2468, 2432, 1728, 565, 210233, 5095, 1217, 1512, 217161, 1517, 2476, 6388, 567, 2518, 1532, 2517, 210948, 33, 6419, 2578, 2592, 210291, 8126, 16276, 2627, 16325, 5452, 5264, 214101, 2630, 185678, 6263, 2650, 6809, 5251, 5593, 198494, 1264, 2663, 34, 604, 3522)) AND (event.event_status = 'open')
    ORDER BY event.date_close ASC
     LIMIT 15 OFFSET 60

    Run Time: 1.843671

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

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

    Run Time: 0.419965

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

91. 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.169327

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

92. 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.010214

    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

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

    Params: f9b25bc4ec1deaaf290cf67d0615dbd4, , 1713285748
    Run Time: 0.000246

94. 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, , 1713282148,
    Run Time: 0.000134

95. 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.003082

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

96. 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.000449

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

97. 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.000320

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

98. SELECT *
    FROM merc_ad_last_view
    ORDER BY view_date ASC

    Run Time: 0.000103

    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