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.000899
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.000291
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.000231
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.000259
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,
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: 29
Run Time: 0.000625
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 | |
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.062743
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | category | ALL | | | | | 14479 | 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, 208258
Run Time: 0.000266
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.000174
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.000168
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, 213151
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, 224766
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, 234783
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, 223109
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, 198911
Run Time: 0.000217
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.000175
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, 220538
Run Time: 0.000152
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.000164
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, 212015
Run Time: 0.000217
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, 202447
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, 210293
Run Time: 0.000168
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.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, 215782
Run Time: 0.000217
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, 216059
Run Time: 0.000149
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.000168
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, 210561
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, 208980
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, 212008
Run Time: 0.000149
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, 216892
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, 228205
Run Time: 0.000141
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, 228206
Run Time: 0.000164
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, 214726
Run Time: 0.000154
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, 222925
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, 198056
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, 210215
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, 216599
Run Time: 0.000150
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.000169
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.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, 224987
Run Time: 0.000180
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, 218139
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, 207218
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, 219218
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, 216718
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, 210619
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, 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 |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 215597
Run Time: 0.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, 215913
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, 213765
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, 201078
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, 211710
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, 211965
Run Time: 0.000146
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, 216731
Run Time: 0.000146
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, 218223
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, 212805
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, 207341
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, 212154
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, 203351
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, 227855
Run Time: 0.000146
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.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, 227856
Run Time: 0.000141
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.000154
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, 234728
Run Time: 0.000187
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, 210597
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, 209992
Run Time: 0.000141
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, 216791
Run Time: 0.000141
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, 234716
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, 222953
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, 224964
Run Time: 0.000141
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, 234707
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, 201838
Run Time: 0.000141
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.000203
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.000141
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, 201890
Run Time: 0.000141
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.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, 226960
Run Time: 0.000140
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | | | | | | | | Impossible WHERE noticed after reading const tables |
SELECT cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = ?
AND content_id = ?
Params: 1, sportsbook_category, 218533
Run Time: 0.000146
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.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, 201075
Run Time: 0.000141
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, 212019
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, 210295
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, 210004
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, 202276
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, 228133
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, 215841
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, 210442
Run Time: 0.000141
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, 222897
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, 210285
Run Time: 0.000146
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.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, 228213
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, 228215
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, 215436
Run Time: 0.000207
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, 216740
Run Time: 0.000141
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, 208750
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, 220795
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, 201290
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, 206882
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, 205322
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, 202026
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, 201212
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, 214556
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, 198171
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, 234770
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, 224940
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 COUNT(*)
FROM xf_nflj_sportsbook_event as event
WHERE (event.category_id IN (1725, 201149, 1739, 6820, 1742, 1766, 6782, 10030, 198014, 8588, 1753, 194630, 8586, 66352, 1792, 6299, 1773, 6775, 201501, 1785, 1784, 7167, 1817, 6486, 1818, 10336, 196778, 5595, 198062, 1826, 1852, 1829, 10778, 10885, 9320, 198082, 10279, 72423, 1857, 10658, 6417, 11670, 1863, 5591, 72425, 10921, 1875, 1872, 9531, 72429, 1880, 72427, 1881, 201210, 1887, 9441, 1891, 6758, 1908, 1904, 6666, 187661, 1913, 6426, 5598, 6668, 9885, 125463, 1977, 202195, 5938, 1979, 11697, 1957, 6303, 1958, 42016, 1978, 6678, 1951, 1952, 11693, 201373, 1980, 197646, 197438, 5487, 198316, 11695, 8713, 1989, 211244, 2032, 2033, 2036, 204807, 6267, 2037, 6495, 2027, 192419, 10236, 1842, 1843, 5886, 1844, 8564, 197439, 5874, 2067, 2073, 2065, 2066, 191452, 191453, 191447, 191454, 191449, 191450, 191451, 197471, 6546, 2048, 192396, 6545, 6543, 194585, 2050, 2081, 206711, 6756, 2095, 69875, 10578, 201143, 10083, 198033, 199211, 201161, 2123, 194804, 2120, 6392, 10604, 198331, 2133, 2136, 6650, 2147, 10227, 2436, 197440, 5488, 2438, 5896, 217401, 217399, 212574, 2157, 6308, 2159, 6784, 9902, 207551, 207559, 207552, 207560, 10380, 2203, 2211, 209758, 201165, 207004, 2242, 6423, 1929, 6713, 1928, 6312, 2258, 2259, 2331, 6816, 2333, 5888, 2359, 9591, 2366, 192394, 6633, 6985, 2368, 216986, 216988, 2374, 6421, 198670, 202558, 2384, 215023, 2387, 6814, 2386, 6600, 8128, 11711, 2395, 16340, 199710, 2406, 6431, 10600, 10419, 16278, 2417, 6824, 2418, 198225, 2419, 2421, 6519, 2434, 201139, 210303, 2453, 196725, 201109, 2457, 194780, 196763, 196765, 2462, 2196, 32746, 5490, 215328, 2468, 218702, 2464, 2465, 2466, 2467, 210452, 5898, 2432, 204821, 204822, 204824, 204813, 204814, 204815, 191455, 2481, 2487, 2484, 2486, 1728, 6269, 2510, 2513, 2476, 6388, 2518, 192764, 2517, 6428, 6419, 198578, 2578, 2592, 8126, 16276, 2627, 5264, 214101, 2630, 2650, 6809, 5593, 198494, 2663, 6301, 201065, 5596, 2678, 29)) AND (event.event_status = 'open')
Run Time: 0.472531
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | event | ALL | category_date_edit | | | | 177424 | 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 (1725, 201149, 1739, 6820, 1742, 1766, 6782, 10030, 198014, 8588, 1753, 194630, 8586, 66352, 1792, 6299, 1773, 6775, 201501, 1785, 1784, 7167, 1817, 6486, 1818, 10336, 196778, 5595, 198062, 1826, 1852, 1829, 10778, 10885, 9320, 198082, 10279, 72423, 1857, 10658, 6417, 11670, 1863, 5591, 72425, 10921, 1875, 1872, 9531, 72429, 1880, 72427, 1881, 201210, 1887, 9441, 1891, 6758, 1908, 1904, 6666, 187661, 1913, 6426, 5598, 6668, 9885, 125463, 1977, 202195, 5938, 1979, 11697, 1957, 6303, 1958, 42016, 1978, 6678, 1951, 1952, 11693, 201373, 1980, 197646, 197438, 5487, 198316, 11695, 8713, 1989, 211244, 2032, 2033, 2036, 204807, 6267, 2037, 6495, 2027, 192419, 10236, 1842, 1843, 5886, 1844, 8564, 197439, 5874, 2067, 2073, 2065, 2066, 191452, 191453, 191447, 191454, 191449, 191450, 191451, 197471, 6546, 2048, 192396, 6545, 6543, 194585, 2050, 2081, 206711, 6756, 2095, 69875, 10578, 201143, 10083, 198033, 199211, 201161, 2123, 194804, 2120, 6392, 10604, 198331, 2133, 2136, 6650, 2147, 10227, 2436, 197440, 5488, 2438, 5896, 217401, 217399, 212574, 2157, 6308, 2159, 6784, 9902, 207551, 207559, 207552, 207560, 10380, 2203, 2211, 209758, 201165, 207004, 2242, 6423, 1929, 6713, 1928, 6312, 2258, 2259, 2331, 6816, 2333, 5888, 2359, 9591, 2366, 192394, 6633, 6985, 2368, 216986, 216988, 2374, 6421, 198670, 202558, 2384, 215023, 2387, 6814, 2386, 6600, 8128, 11711, 2395, 16340, 199710, 2406, 6431, 10600, 10419, 16278, 2417, 6824, 2418, 198225, 2419, 2421, 6519, 2434, 201139, 210303, 2453, 196725, 201109, 2457, 194780, 196763, 196765, 2462, 2196, 32746, 5490, 215328, 2468, 218702, 2464, 2465, 2466, 2467, 210452, 5898, 2432, 204821, 204822, 204824, 204813, 204814, 204815, 191455, 2481, 2487, 2484, 2486, 1728, 6269, 2510, 2513, 2476, 6388, 2518, 192764, 2517, 6428, 6419, 198578, 2578, 2592, 8126, 16276, 2627, 5264, 214101, 2630, 2650, 6809, 5593, 198494, 2663, 6301, 201065, 5596, 2678, 29)) AND (event.event_status = 'open')
ORDER BY event.date_close ASC
LIMIT 10 OFFSET 1210
Run Time: 1.460587
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | event | range | category_date_edit | category_date_edit | 4 | | 52226 | 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 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 (1725, 201149, 1739, 6820, 1742, 1766, 6782, 10030, 198014, 8588, 1753, 194630, 8586, 66352, 1792, 6299, 1773, 6775, 201501, 1785, 1784, 7167, 1817, 6486, 1818, 10336, 196778, 5595, 198062, 1826, 1852, 1829, 10778, 10885, 9320, 198082, 10279, 72423, 1857, 10658, 6417, 11670, 1863, 5591, 72425, 10921, 1875, 1872, 9531, 72429, 1880, 72427, 1881, 201210, 1887, 9441, 1891, 6758, 1908, 1904, 6666, 187661, 1913, 6426, 5598, 6668, 9885, 125463, 1977, 202195, 5938, 1979, 11697, 1957, 6303, 1958, 42016, 1978, 6678, 1951, 1952, 11693, 201373, 1980, 197646, 197438, 5487, 198316, 11695, 8713, 1989, 211244, 2032, 2033, 2036, 204807, 6267, 2037, 6495, 2027, 192419, 10236, 1842, 1843, 5886, 1844, 8564, 197439, 5874, 2067, 2073, 2065, 2066, 191452, 191453, 191447, 191454, 191449, 191450, 191451, 197471, 6546, 2048, 192396, 6545, 6543, 194585, 2050, 2081, 206711, 6756, 2095, 69875, 10578, 201143, 10083, 198033, 199211, 201161, 2123, 194804, 2120, 6392, 10604, 198331, 2133, 2136, 6650, 2147, 10227, 2436, 197440, 5488, 2438, 5896, 217401, 217399, 212574, 2157, 6308, 2159, 6784, 9902, 207551, 207559, 207552, 207560, 10380, 2203, 2211, 209758, 201165, 207004, 2242, 6423, 1929, 6713, 1928, 6312, 2258, 2259, 2331, 6816, 2333, 5888, 2359, 9591, 2366, 192394, 6633, 6985, 2368, 216986, 216988, 2374, 6421, 198670, 202558, 2384, 215023, 2387, 6814, 2386, 6600, 8128, 11711, 2395, 16340, 199710, 2406, 6431, 10600, 10419, 16278, 2417, 6824, 2418, 198225, 2419, 2421, 6519, 2434, 201139, 210303, 2453, 196725, 201109, 2457, 194780, 196763, 196765, 2462, 2196, 32746, 5490, 215328, 2468, 218702, 2464, 2465, 2466, 2467, 210452, 5898, 2432, 204821, 204822, 204824, 204813, 204814, 204815, 191455, 2481, 2487, 2484, 2486, 1728, 6269, 2510, 2513, 2476, 6388, 2518, 192764, 2517, 6428, 6419, 198578, 2578, 2592, 8126, 16276, 2627, 5264, 214101, 2630, 2650, 6809, 5593, 198494, 2663, 6301, 201065, 5596, 2678, 29)
AND event.event_status NOT IN ('pending','deleted')
ORDER BY views DESC
Run Time: 0.422986
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | event | ALL | category_date_edit | | | | 177424 | Using where; Using temporary |
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 (1725, 201149, 1739, 6820, 1742, 1766, 6782, 10030, 198014, 8588, 1753, 194630, 8586, 66352, 1792, 6299, 1773, 6775, 201501, 1785, 1784, 7167, 1817, 6486, 1818, 10336, 196778, 5595, 198062, 1826, 1852, 1829, 10778, 10885, 9320, 198082, 10279, 72423, 1857, 10658, 6417, 11670, 1863, 5591, 72425, 10921, 1875, 1872, 9531, 72429, 1880, 72427, 1881, 201210, 1887, 9441, 1891, 6758, 1908, 1904, 6666, 187661, 1913, 6426, 5598, 6668, 9885, 125463, 1977, 202195, 5938, 1979, 11697, 1957, 6303, 1958, 42016, 1978, 6678, 1951, 1952, 11693, 201373, 1980, 197646, 197438, 5487, 198316, 11695, 8713, 1989, 211244, 2032, 2033, 2036, 204807, 6267, 2037, 6495, 2027, 192419, 10236, 1842, 1843, 5886, 1844, 8564, 197439, 5874, 2067, 2073, 2065, 2066, 191452, 191453, 191447, 191454, 191449, 191450, 191451, 197471, 6546, 2048, 192396, 6545, 6543, 194585, 2050, 2081, 206711, 6756, 2095, 69875, 10578, 201143, 10083, 198033, 199211, 201161, 2123, 194804, 2120, 6392, 10604, 198331, 2133, 2136, 6650, 2147, 10227, 2436, 197440, 5488, 2438, 5896, 217401, 217399, 212574, 2157, 6308, 2159, 6784, 9902, 207551, 207559, 207552, 207560, 10380, 2203, 2211, 209758, 201165, 207004, 2242, 6423, 1929, 6713, 1928, 6312, 2258, 2259, 2331, 6816, 2333, 5888, 2359, 9591, 2366, 192394, 6633, 6985, 2368, 216986, 216988, 2374, 6421, 198670, 202558, 2384, 215023, 2387, 6814, 2386, 6600, 8128, 11711, 2395, 16340, 199710, 2406, 6431, 10600, 10419, 16278, 2417, 6824, 2418, 198225, 2419, 2421, 6519, 2434, 201139, 210303, 2453, 196725, 201109, 2457, 194780, 196763, 196765, 2462, 2196, 32746, 5490, 215328, 2468, 218702, 2464, 2465, 2466, 2467, 210452, 5898, 2432, 204821, 204822, 204824, 204813, 204814, 204815, 191455, 2481, 2487, 2484, 2486, 1728, 6269, 2510, 2513, 2476, 6388, 2518, 192764, 2517, 6428, 6419, 198578, 2578, 2592, 8126, 16276, 2627, 5264, 214101, 2630, 2650, 6809, 5593, 198494, 2663, 6301, 201065, 5596, 2678, 29)) AND (event.date_close < 1711886775) AND (event.event_status = 'open')
ORDER BY event.date_close ASC
LIMIT 5
Run Time: 1.664875
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | event | range | category_date_edit | category_date_edit | 4 | | 52226 | 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.*
FROM xf_nflj_sportsbook_event AS event
WHERE event.event_id = ?
Params: 1588348210
Run Time: 0.000425
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | event | const | PRIMARY | PRIMARY | 4 | const | 1 | |
begin
Run Time: 0.000107
UPDATE `xf_nflj_sportsbook_event` SET `event_status` = ? WHERE (event_id = 1588348210)
Params: awaiting_settlement
Run Time: 0.000513
REPLACE DELAYED INTO xf_search_index
(content_type, content_id,
title, message, metadata,
item_date, user_id, discussion_id)
VALUES
('sportsbook_event', 1588348210, 'Hapoel Azur - Maccabi Ironi Amishav Petah Tikva', '', '_md_user_264 _md_content_sportsbook_event _md_event_id_1588348210 _md_eventcat_198331', 1711710063, 264, 0)
Run Time: 0.000234
SELECT category.*
FROM xf_nflj_sportsbook_category AS category
WHERE category.category_id = ?
Params: 198331
Run Time: 0.000381
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | category | const | PRIMARY,category_id | PRIMARY | 4 | const | 1 | |
UPDATE `xf_nflj_sportsbook_category` SET `last_event_title` = ?, `last_event_id` = ? WHERE (category_id = 198331)
Params: Hapoel Azur - Maccabi Ironi Amishav Petah Tikva, 1588348210
Run Time: 0.000494
commit
Run Time: 0.000704
SELECT event.*
FROM xf_nflj_sportsbook_event AS event
WHERE event.event_id = ?
Params: 1588220012
Run Time: 0.000297
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | event | const | PRIMARY | PRIMARY | 4 | const | 1 | |
begin
Run Time: 0.000058
UPDATE `xf_nflj_sportsbook_event` SET `event_status` = ? WHERE (event_id = 1588220012)
Params: awaiting_settlement
Run Time: 0.000274
REPLACE DELAYED INTO xf_search_index
(content_type, content_id,
title, message, metadata,
item_date, user_id, discussion_id)
VALUES
('sportsbook_event', 1588220012, 'Lunds BK - Rosengard', '', '_md_user_264 _md_content_sportsbook_event _md_event_id_1588220012 _md_eventcat_2513', 1711584062, 264, 0)
Run Time: 0.000105
SELECT category.*
FROM xf_nflj_sportsbook_category AS category
WHERE category.category_id = ?
Params: 2513
Run Time: 0.000306
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | category | const | PRIMARY,category_id | PRIMARY | 4 | const | 1 | |
UPDATE `xf_nflj_sportsbook_category` SET `last_event` = ?, `last_event_title` = ?, `last_event_id` = ? WHERE (category_id = 2513)
Params: 1711584062, Lunds BK - Rosengard, 1588220012
Run Time: 0.000162
commit
Run Time: 0.000791
SELECT event.*
FROM xf_nflj_sportsbook_event AS event
WHERE event.event_id = ?
Params: 1588097139
Run Time: 0.000343
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | event | const | PRIMARY | PRIMARY | 4 | const | 1 | |
begin
Run Time: 0.000052
UPDATE `xf_nflj_sportsbook_event` SET `event_status` = ? WHERE (event_id = 1588097139)
Params: awaiting_settlement
Run Time: 0.000219
REPLACE DELAYED INTO xf_search_index
(content_type, content_id,
title, message, metadata,
item_date, user_id, discussion_id)
VALUES
('sportsbook_event', 1588097139, 'Hertha Berlin II - Lokomotiv Leipzig', '', '_md_user_264 _md_content_sportsbook_event _md_event_id_1588097139 _md_eventcat_6545', 1711370462, 264, 0)
Run Time: 0.003149
SELECT category.*
FROM xf_nflj_sportsbook_category AS category
WHERE category.category_id = ?
Params: 6545
Run Time: 0.000294
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | category | const | PRIMARY,category_id | PRIMARY | 4 | const | 1 | |
commit
Run Time: 0.000742
SELECT event.*
FROM xf_nflj_sportsbook_event AS event
WHERE event.event_id = ?
Params: 1588219528
Run Time: 0.000351
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | event | const | PRIMARY | PRIMARY | 4 | const | 1 | |
begin
Run Time: 0.000084
UPDATE `xf_nflj_sportsbook_event` SET `event_status` = ? WHERE (event_id = 1588219528)
Params: awaiting_settlement
Run Time: 0.000288
REPLACE DELAYED INTO xf_search_index
(content_type, content_id,
title, message, metadata,
item_date, user_id, discussion_id)
VALUES
('sportsbook_event', 1588219528, 'Osterlen FF - Nosaby IF', '', '_md_user_264 _md_content_sportsbook_event _md_event_id_1588219528 _md_eventcat_2484', 1711677663, 264, 0)
Run Time: 0.001343
SELECT category.*
FROM xf_nflj_sportsbook_category AS category
WHERE category.category_id = ?
Params: 2484
Run Time: 0.000308
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | category | const | PRIMARY,category_id | PRIMARY | 4 | const | 1 | |
UPDATE `xf_nflj_sportsbook_category` SET `last_event` = ?, `last_event_title` = ?, `last_event_id` = ? WHERE (category_id = 2484)
Params: 1711677663, Osterlen FF - Nosaby IF, 1588219528
Run Time: 0.000189
commit
Run Time: 0.000528
SELECT event.*
FROM xf_nflj_sportsbook_event AS event
WHERE event.event_id = ?
Params: 1588219529
Run Time: 0.000284
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | event | const | PRIMARY | PRIMARY | 4 | const | 1 | |
begin
Run Time: 0.000070
UPDATE `xf_nflj_sportsbook_event` SET `event_status` = ? WHERE (event_id = 1588219529)
Params: awaiting_settlement
Run Time: 0.000298
REPLACE DELAYED INTO xf_search_index
(content_type, content_id,
title, message, metadata,
item_date, user_id, discussion_id)
VALUES
('sportsbook_event', 1588219529, 'IFK Karlshamn - IFK Hassleholm', '', '_md_user_264 _md_content_sportsbook_event _md_event_id_1588219529 _md_eventcat_2484', 1711677663, 264, 0)
Run Time: 0.000203
SELECT category.*
FROM xf_nflj_sportsbook_category AS category
WHERE category.category_id = ?
Params: 2484
Run Time: 0.000510
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | category | const | PRIMARY,category_id | PRIMARY | 4 | const | 1 | |
UPDATE `xf_nflj_sportsbook_category` SET `last_event_title` = ?, `last_event_id` = ? WHERE (category_id = 2484)
Params: IFK Karlshamn - IFK Hassleholm, 1588219529
Run Time: 0.000132
commit
Run Time: 0.000730
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 33361b15a2d59e272ed2a97189a86707, , 1711717575
Run Time: 0.000207
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=29, 1711713975,
Run Time: 0.000175
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.002776
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 11 | 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.000299
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.000268
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.000092
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | merc_ad_last_view | system | | | | | 0 | const row not found |