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.001323
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.000317
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.000261
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.000215
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT wager.*,
wager.outcome_title as out_title, wager_date_placed as date_placed,
user.username, user.avatar_date, user.avatar_width, user.avatar_height, user.gender, user.gravatar,
outcome.*,
event.title, event.event_status, event.category_id, event.description, event.date_create, event.date_open,
event.date_close, event.date_settle, event.date_edit, event.prefix_id
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_outcome AS outcome
ON (outcome.outcome_id = wager.outcome_id)
LEFT JOIN xf_nflj_sportsbook_event AS event
ON (event.event_id = outcome.event_id)
WHERE wager.user_id = 0
AND event.event_status NOT IN ("pending","deleted")
ORDER BY wager.wager_date_placed DESC
LIMIT 10
Run Time: 0.000729
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | wager | ref | outcome_id,user_id | user_id | 4 | const | 1 | Using where; Using filesort |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | outcome | eq_ref | PRIMARY,event_id | PRIMARY | 8 | m11459_uabets.wager.outcome_id | 1 | |
SIMPLE | event | eq_ref | PRIMARY | PRIMARY | 4 | m11459_uabets.outcome.event_id | 1 | Using where |
SELECT COUNT(*) AS count
FROM xf_nflj_sportsbook_wager AS wager
LEFT JOIN xf_nflj_sportsbook_outcome AS outcome
ON (outcome.outcome_id = wager.outcome_id)
LEFT JOIN xf_nflj_sportsbook_event AS event
ON (event.event_id = wager.event_id)
WHERE wager.user_id = 0
AND event.event_status NOT IN ("pending","deleted")
Run Time: 0.000209
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | wager | ref | event_id,user_id | user_id | 4 | const | 1 | |
SIMPLE | event | eq_ref | PRIMARY | PRIMARY | 4 | m11459_uabets.wager.event_id | 1 | Using where |
SELECT SUM(wager.wager_amount_placed) AS total_wagered
FROM xf_nflj_sportsbook_wager AS wager
LEFT JOIN xf_user AS user
ON (user.user_id = wager.user_id)
WHERE wager_settled = 'Y' AND wager.user_id = 0
GROUP BY wager.user_id
ORDER BY total_wagered DESC
LIMIT 1
Run Time: 0.005656
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | wager | ref | user_id,wager_settled | user_id | 4 | const | 1 | Using where |
SELECT COUNT(*) as total_won, SUM(wager.wager_amount_won) AS total_amount_won
FROM xf_nflj_sportsbook_wager AS wager
LEFT JOIN xf_user AS user
ON (user.user_id = wager.user_id)
WHERE wager.user_id = 0
AND wager.wager_settled = "Y"
AND wager.wager_pushed = "N"
AND wager.wager_amount_won != 0
GROUP BY wager.user_id
ORDER BY total_amount_won DESC
LIMIT 1
Run Time: 0.005068
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | wager | ref | wager_amount_won,user_id,wager_settled | user_id | 4 | const | 1 | Using where |
SELECT COUNT(*) as total_pushed, SUM(wager.wager_amount_placed) AS total_amount_pushed
FROM xf_nflj_sportsbook_wager AS wager
LEFT JOIN xf_user AS user
ON (user.user_id = wager.user_id)
WHERE wager.user_id = 0
AND wager.wager_settled = "Y"
AND wager.wager_pushed = "Y"
GROUP BY wager.user_id
ORDER BY total_amount_pushed DESC
LIMIT 1
Run Time: 0.000257
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | wager | ref | user_id,wager_settled | user_id | 4 | const | 1 | Using where |
SELECT COUNT(*) as total_lost, SUM(wager.wager_amount_placed) AS total_amount_lost
FROM xf_nflj_sportsbook_wager AS wager
LEFT JOIN xf_user AS user
ON (user.user_id = wager.user_id)
WHERE wager.user_id = 0
AND wager.wager_settled = "Y"
AND wager.wager_pushed = "N"
AND wager.wager_amount_won = 0
GROUP BY wager.user_id
ORDER BY total_amount_lost DESC
LIMIT 1
Run Time: 0.001656
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | wager | ref | wager_amount_won,user_id,wager_settled | user_id | 4 | const | 1 | Using where |
SELECT COUNT( * ) AS count,
wager.wager_id,
user.username,
event.event_status
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_outcome AS outcome
ON ( outcome.outcome_id = wager.outcome_id )
LEFT JOIN xf_nflj_sportsbook_event AS event
ON ( event.event_id = outcome.event_id )
WHERE wager.user_id = 0
GROUP BY event.event_status
ORDER BY event.event_status DESC
Run Time: 0.000316
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | wager | ref | user_id | user_id | 4 | const | 1 | Using temporary; Using filesort |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | outcome | eq_ref | PRIMARY | PRIMARY | 8 | m11459_uabets.wager.outcome_id | 1 | |
SIMPLE | event | eq_ref | PRIMARY | PRIMARY | 4 | m11459_uabets.outcome.event_id | 1 | Using where |
SELECT field_value as fv FROM xf_user_field_value
WHERE user_id = 0
AND CAST(field_id AS CHAR) = 'lost_bankrolls'
Run Time: 0.000455
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_user_field_value | ref | PRIMARY | PRIMARY | 4 | const | 1 | Using where |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 1d9723b2905c1bc0ab50f9ddb32c53ac, , 1713538746
Run Time: 0.000182
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, Wagers, valid, , 1713535146,
Run Time: 0.000205
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'nflj_sportsbook_wagers', '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.001657
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.000257
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.000176
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.000135
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | merc_ad_last_view | system | | | | | 0 | const row not found |