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.001204
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using where |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('brListenerClasses', 'brBriviumAddOns')
Run Time: 0.000348
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 2 | Using where |
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('ads', 'adPositions', 'adTypes')
Run Time: 0.000270
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 3 | Using where |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000385
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
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.053764
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | category | ALL | | | | | 15013 | Using where; Using filesort |
SIMPLE | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,m11459_uabets.category.category_id | 1 | Using where |
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.000309
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
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.000172
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 208258
Run Time: 0.000156
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
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.000142
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
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.000157
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 224765
Run Time: 0.000148
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 234783
Run Time: 0.000147
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 223109
Run Time: 0.000183
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 223108
Run Time: 0.000148
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 198911
Run Time: 0.000143
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 222693
Run Time: 0.000144
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
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.000155
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
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.000145
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
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.000140
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 207264
Run Time: 0.000140
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 201364
Run Time: 0.000247
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
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.000143
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 217101
Run Time: 0.000139
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 216891
Run Time: 0.000145
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
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.000151
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 214819
Run Time: 0.000138
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 201505
Run Time: 0.000200
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
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.000153
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
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.000176
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
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.000176
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
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.000160
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 215913
Run Time: 0.000153
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 201077
Run Time: 0.000196
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 201076
Run Time: 0.000167
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 211710
Run Time: 0.000190
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 215568
Run Time: 0.000165
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
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.000220
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
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.000162
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 217400
Run Time: 0.000194
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 227856
Run Time: 0.000162
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 227860
Run Time: 0.000179
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 234727
Run Time: 0.000161
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 210595
Run Time: 0.000163
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 216790
Run Time: 0.000205
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 219240
Run Time: 0.000160
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 234715
Run Time: 0.000166
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 222952
Run Time: 0.000156
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 224963
Run Time: 0.000167
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 234706
Run Time: 0.000215
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
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.000223
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
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.000249
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
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.000258
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
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.000231
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
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.000161
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 201075
Run Time: 0.000155
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 215501
Run Time: 0.000193
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
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.000178
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
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.000179
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 204818
Run Time: 0.000144
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 204817
Run Time: 0.000143
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 208751
Run Time: 0.000165
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
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.000166
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 198171
Run Time: 0.000151
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 234768
Run Time: 0.000213
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 224939
Run Time: 0.000162
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 198912
Run Time: 0.000145
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT COUNT(*)
FROM xf_nflj_sportsbook_event as event
WHERE (event.category_id IN (268, 212148, 1739, 6820, 201151, 1766, 6782, 280, 10030, 198014, 1753, 194630, 8586, 66352, 1792, 6299, 1275, 1773, 6775, 201501, 201167, 3, 4, 1282, 1817, 6486, 1818, 10336, 41, 5595, 198062, 10778, 293, 2360, 192728, 9320, 198082, 297, 203908, 1857, 10658, 303, 6417, 11670, 1863, 5591, 72425, 10921, 1872, 9531, 72429, 1881, 306, 1887, 210239, 206705, 9441, 1891, 6758, 1297, 313, 10895, 191393, 317, 1908, 216945, 1904, 6666, 1913, 6426, 207048, 12, 5598, 6668, 197248, 9885, 125463, 207009, 321, 1977, 202195, 5938, 206706, 1979, 11697, 1957, 6303, 1958, 42016, 1978, 6678, 1951, 1952, 11693, 1980, 197646, 198002, 197438, 5487, 11695, 8713, 218837, 377, 382, 374, 1021, 408, 4107, 4529, 1401, 15, 2032, 2036, 6267, 2037, 6495, 1413, 2027, 192419, 1842, 1843, 5886, 212023, 1844, 8564, 5874, 1107, 4118, 2067, 1419, 149036, 2073, 2065, 2066, 191452, 191453, 191447, 197785, 197470, 191454, 191450, 191451, 197471, 6546, 6680, 2048, 192396, 6545, 194782, 6543, 194585, 2050, 191364, 17, 2081, 18, 19, 2095, 69875, 204110, 10578, 10083, 198033, 199211, 201161, 2123, 194804, 2120, 6392, 10604, 2133, 2136, 6650, 2147, 2436, 5488, 4142, 2438, 217401, 217399, 212572, 212574, 88177, 88178, 7675, 2157, 6308, 2159, 6784, 9902, 6227, 207551, 207559, 207552, 207560, 1446, 485, 208618, 209758, 201165, 2242, 6423, 246, 487, 493, 1929, 6713, 1928, 6312, 216482, 889, 1456, 187703, 2259, 2331, 2333, 5888, 2359, 9591, 2366, 192394, 198151, 6633, 6985, 2368, 2374, 6421, 4173, 512, 198670, 202558, 2384, 215023, 2387, 6814, 2386, 6600, 8128, 11711, 527, 2395, 16340, 1484, 2406, 6431, 5154, 10419, 16278, 2417, 6824, 2421, 6519, 2434, 1498, 201139, 2453, 196725, 2457, 194780, 28, 29, 196763, 196765, 2462, 2196, 5490, 1200, 210094, 2468, 5898, 2432, 204809, 204819, 204820, 204822, 204823, 204824, 204825, 204826, 204810, 204811, 204812, 204813, 204814, 204815, 204816, 201069, 2487, 1728, 6269, 2513, 5095, 1512, 217161, 1517, 2476, 6388, 567, 2518, 192764, 1532, 2517, 6428, 33, 6419, 198578, 2578, 4238, 2592, 8126, 16276, 2627, 2642, 197989, 5264, 214101, 2630, 2650, 6809, 5251, 5593, 198494, 1264, 2663, 6301, 201065, 5596, 34, 2678, 583)) AND (event.event_status = 'open')
Run Time: 0.555480
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | event | ALL | category_date_edit | | | | 258090 | Using where |
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, 212148, 1739, 6820, 201151, 1766, 6782, 280, 10030, 198014, 1753, 194630, 8586, 66352, 1792, 6299, 1275, 1773, 6775, 201501, 201167, 3, 4, 1282, 1817, 6486, 1818, 10336, 41, 5595, 198062, 10778, 293, 2360, 192728, 9320, 198082, 297, 203908, 1857, 10658, 303, 6417, 11670, 1863, 5591, 72425, 10921, 1872, 9531, 72429, 1881, 306, 1887, 210239, 206705, 9441, 1891, 6758, 1297, 313, 10895, 191393, 317, 1908, 216945, 1904, 6666, 1913, 6426, 207048, 12, 5598, 6668, 197248, 9885, 125463, 207009, 321, 1977, 202195, 5938, 206706, 1979, 11697, 1957, 6303, 1958, 42016, 1978, 6678, 1951, 1952, 11693, 1980, 197646, 198002, 197438, 5487, 11695, 8713, 218837, 377, 382, 374, 1021, 408, 4107, 4529, 1401, 15, 2032, 2036, 6267, 2037, 6495, 1413, 2027, 192419, 1842, 1843, 5886, 212023, 1844, 8564, 5874, 1107, 4118, 2067, 1419, 149036, 2073, 2065, 2066, 191452, 191453, 191447, 197785, 197470, 191454, 191450, 191451, 197471, 6546, 6680, 2048, 192396, 6545, 194782, 6543, 194585, 2050, 191364, 17, 2081, 18, 19, 2095, 69875, 204110, 10578, 10083, 198033, 199211, 201161, 2123, 194804, 2120, 6392, 10604, 2133, 2136, 6650, 2147, 2436, 5488, 4142, 2438, 217401, 217399, 212572, 212574, 88177, 88178, 7675, 2157, 6308, 2159, 6784, 9902, 6227, 207551, 207559, 207552, 207560, 1446, 485, 208618, 209758, 201165, 2242, 6423, 246, 487, 493, 1929, 6713, 1928, 6312, 216482, 889, 1456, 187703, 2259, 2331, 2333, 5888, 2359, 9591, 2366, 192394, 198151, 6633, 6985, 2368, 2374, 6421, 4173, 512, 198670, 202558, 2384, 215023, 2387, 6814, 2386, 6600, 8128, 11711, 527, 2395, 16340, 1484, 2406, 6431, 5154, 10419, 16278, 2417, 6824, 2421, 6519, 2434, 1498, 201139, 2453, 196725, 2457, 194780, 28, 29, 196763, 196765, 2462, 2196, 5490, 1200, 210094, 2468, 5898, 2432, 204809, 204819, 204820, 204822, 204823, 204824, 204825, 204826, 204810, 204811, 204812, 204813, 204814, 204815, 204816, 201069, 2487, 1728, 6269, 2513, 5095, 1512, 217161, 1517, 2476, 6388, 567, 2518, 192764, 1532, 2517, 6428, 33, 6419, 198578, 2578, 4238, 2592, 8126, 16276, 2627, 2642, 197989, 5264, 214101, 2630, 2650, 6809, 5251, 5593, 198494, 1264, 2663, 6301, 201065, 5596, 34, 2678, 583)) AND (event.event_status = 'open')
ORDER BY event.date_close ASC
LIMIT 15 OFFSET 2190
Run Time: 2.048800
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | event | range | category_date_edit | category_date_edit | 4 | | 83762 | 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 | |
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 < 1711796156) AND (event.event_status = 'open')
ORDER BY event.date_close ASC
LIMIT 9
Run Time: 0.447192
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | event | ALL | | | | | 258090 | 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 | |
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.210344
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | wager | ALL | | | | | 34801 | Using where; Using temporary; Using filesort |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | m11459_uabets.wager.user_id | 1 | |
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.012710
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 | |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 0acd0369d4c77041661a31dda36c9e6c, , 1711626956
Run Time: 0.000363
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, , 1711623356,
Run Time: 0.000245
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.002413
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 10 | Using where |
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.000331
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |
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.000235
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 | |
SELECT *
FROM merc_ad_last_view
ORDER BY view_date ASC
Run Time: 0.000110
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | merc_ad_last_view | system | | | | | 0 | const row not found |