Page Time: 0.4869s

Memory: 13.1776 MB (Peak: 15.6066 MB)

Queries (28, time: 0.3553s, 73.0%)

  1. SELECT data_key, data_value
    FROM xf_data_registry
    WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'cron', 'simpleCache', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'smilies', 'bbCode', 'threadPrefixes', 'trophyUserTitles', 'reportCounts', 'moderationCounts', 'notices', 'userFieldsInfo')
    Run Time: 0.000368
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_data_registryrangePRIMARYPRIMARY77 20Using where
  2. SELECT data_value
    FROM xf_data_registry
    WHERE data_key = ?
    Params: moods
    Run Time: 0.000131
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_data_registryconstPRIMARYPRIMARY77const1 
  3. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000112
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  4. SELECT thread.*
    	,
    		user.avatar_date, user.gravatar,
    		NULL AS thread_read_date,
    		0 AS thread_is_watched
    FROM xf_thread AS thread
    
    		LEFT JOIN xf_user AS user ON
    			(user.user_id = thread.user_id)
    WHERE thread.thread_id = ?
    Params: 48817
    Run Time: 0.000238
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadconstPRIMARYPRIMARY4const1 
    SIMPLEuserconstPRIMARYPRIMARY4const1 
  5. SELECT node.*, forum.*
    	,
    	permission.cache_value AS node_permission_cache,
    		NULL AS forum_read_date
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    	LEFT JOIN xf_permission_cache_content AS permission
    		ON (permission.permission_combination_id = 1
    			AND permission.content_type = 'node'
    			AND permission.content_id = forum.node_id)
    WHERE node.node_id = ?
    Params: 6
    Run Time: 0.000265
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY85const,const,const1 
  6. SELECT post.*
    	,
    		user.*, IF(user.username IS NULL, post.username, user.username) AS username,
    		user_profile.*,
    		user_option.*,
    		0 AS like_date
    FROM xf_post AS post
    
    		LEFT JOIN xf_user AS user ON
    			(user.user_id = post.user_id)
    		LEFT JOIN xf_user_profile AS user_profile ON
    			(user_profile.user_id = post.user_id)
    		LEFT JOIN xf_user_option AS user_option ON
    			(user_option.user_id = post.user_id)
    WHERE post.thread_id = ?
    	 AND (post.position >= 0 AND post.position < 10) 
    	AND (post.message_state IN ('visible'))
    ORDER BY post.position ASC, post.post_date ASC
    Params: 48817
    Run Time: 0.002677
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEpostrangethread_id_post_date,thread_id_positionthread_id_position8 9Using where; Using filesort
    SIMPLEusereq_refPRIMARYPRIMARY4jfuqua_xenforo.post.user_id1 
    SIMPLEuser_profileeq_refPRIMARYPRIMARY4jfuqua_xenforo.post.user_id1 
    SIMPLEuser_optioneq_refPRIMARYPRIMARY4jfuqua_xenforo.post.user_id1 
  7. SELECT `user_id`, `position`
     	FROM `xf_post`
     	WHERE `thread_id` = ?
    ORDER BY `position` ASC
    Params: 48817
    Run Time: 0.000479
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_postrefthread_id_post_date,thread_id_positionthread_id_position4const16Using where
  8. INSERT DELAYED INTO xf_thread_view
    	(thread_id)
    VALUES
    	(?)
    Params: 48817
    Run Time: 0.000061
  9. SELECT *
    FROM xf_node
    WHERE lft < ? AND rgt > ?
    ORDER BY lft ASC
    Params: 40, 41
    Run Time: 0.000229
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_nodeALLlft   24Using where; Using filesort
  10. SELECT COUNT(*)
    FROM xf_thread_watch
    WHERE thread_id = ?
    Params: 48817
    Run Time: 0.000106
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_thread_watchrefthread_id_email_subscribethread_id_email_subscribe4const1Using index
  11. INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
    Params: 9d73815e85d23a910586c0470f4e1efd, a:5:{s:12:"sessionStart";i:1406387650;s:2:"ip";i:387363794;s:9:"userAgent";s:39:"CCBot/2.0 (http://commoncrawl.org/faq/)";s:7:"isRobot";b:0;s:16:"previousActivity";i:0;}, 1406391250
    Run Time: 0.000093
  12. INSERT INTO xf_session_activity
    	(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date)
    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)
    Params: 0, 387363794, 387363794, XenForo_ControllerPublic_Thread, Index, valid, thread_id=48817, 1406387650
    Run Time: 0.000060
  13. SELECT session_activity.*
    	,
    	user.*,
    	user_profile.*,
    	user_option.*
    FROM xf_session_activity AS session_activity
    
    	LEFT JOIN xf_user AS user ON
    		(user.user_id = session_activity.user_id)
    	LEFT JOIN xf_user_profile AS user_profile ON
    		(user_profile.user_id = user.user_id)
    	LEFT JOIN xf_user_option AS user_option ON
    		(user_option.user_id = user.user_id)
    WHERE (session_activity.view_date > 1406384050)
    ORDER BY session_activity.view_date DESC
    Run Time: 0.001364
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEsession_activityALLview_date   262Using where; Using filesort
    SIMPLEusereq_refPRIMARYPRIMARY4jfuqua_xenforo.session_activity.user_id1 
    SIMPLEuser_profileeq_refPRIMARYPRIMARY4jfuqua_xenforo.user.user_id1 
    SIMPLEuser_optioneq_refPRIMARYPRIMARY4jfuqua_xenforo.user.user_id1 
  14. SELECT item.*
    	
    FROM `xf_rotating_ads_item` AS item
    	
    WHERE 1=1
    Run Time: 0.000185
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEitemALL    1 
  15. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('post_reply')
    Params: 1
    Run Time: 0.000180
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledconstPRIMARYPRIMARY231const,const1 
  16. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('preview')
    Params: 1
    Run Time: 0.000115
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledconstPRIMARYPRIMARY231const,const1 
  17. SELECT data_key, data_value
    FROM xf_data_registry
    WHERE data_key IN ('wfc_1_thread_view')
    Run Time: 0.000109
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_data_registryconstPRIMARYPRIMARY77const1 
  18. SELECT *
    FROM xf_node
    
    ORDER BY lft ASC
    Run Time: 0.000331
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_nodeALL    24Using filesort
  19.                 SELECT cache_value
                    FROM xf_permission_cache_content_type
                    WHERE permission_combination_id = ?
                        AND content_type = 'node'
    Params: 1
    Run Time: 0.000154
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_cache_content_typeconstPRIMARYPRIMARY81const,const1 
  20. SELECT thread.*
    	,
    	user.gender, user.avatar_date, user.gravatar
    FROM xf_thread AS thread 
    
    	LEFT JOIN xf_user AS user ON
    		(user.user_id = thread.last_post_user_id)
    WHERE (thread.node_id IN (1, 2, 3, 63, 54, 55, 56, 57, 58, 60, 9, 10, 26, 27, 35, 14, 44, 19, 6, 41, 62)) AND (thread.discussion_state IN ('visible'))
    ORDER BY thread.last_post_date DESC
     LIMIT 5
    Run Time: 0.001023
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadindexnode_id_last_post_date,node_id_sticky_last_post_datelast_post_date4 8Using where
    SIMPLEusereq_refPRIMARYPRIMARY4jfuqua_xenforo.thread.last_post_user_id1 
  21. INSERT INTO xf_data_registry
    	(data_key, data_value)
    VALUES
    	(?, ?)
    ON DUPLICATE KEY UPDATE
    	data_value = VALUES(data_value)
    Params: wfc_1_thread_view, a:3:{s:14:"thread_view_11";a:2:{s:4:"html";s:4582:"<div class="avatarList"> <ul> <li class="thread-92071 thread-node-2"> <a href="members/titanium.3/" class="avatar Av3s" data-avatarHtml="true"><img src="data/avatars/s/0/3.jpg?1344207003" width="48" height="48" alt="Titanium" /></a> <a href="posts/1225609/" title="Titans Online to Broadcast LIVE from Titans Training Camp!" class="Tooltip" > Titans Online to Broadcast LIVE... </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/titanium.3/">Titanium</a> replied <abbr class="DateTime" data-time="1406387347" data-diff="303" data-datestring="Jul 26, 2014" data-timestring="10:09 AM">Jul 26, 2014 at 10:09 AM</abbr></div> </li> <li class="thread-92007 thread-node-2"> <a href="members/tennessy-xo.11963/" class="avatar Av11963s" data-avatarHtml="true"><img src="data/avatars/s/11/11963.jpg?1404872047" width="48" height="48" alt="Tennessy XO" /></a> <a href="posts/1225607/" > Titans Hall of Fans </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/tennessy-xo.11963/">Tennessy XO</a> replied <abbr class="DateTime" data-time="1406387207" data-diff="443" data-datestring="Jul 26, 2014" data-timestring="10:06 AM">Jul 26, 2014 at 10:06 AM</abbr></div> </li> <li class="thread-92055 thread-node-2"> <a href="members/titanium.3/" class="avatar Av3s" data-avatarHtml="true"><img src="data/avatars/s/0/3.jpg?1344207003" width="48" height="48" alt="Titanium" /></a> <a href="posts/1225606/" > Rally Cry </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/titanium.3/">Titanium</a> replied <abbr class="DateTime" data-time="1406386819" data-diff="831" data-datestring="Jul 26, 2014" data-timestring="10:00 AM">Jul 26, 2014 at 10:00 AM</abbr></div> </li> <li class="thread-92049 thread-node-2"> <a href="members/rth.9662/" class="avatar Av9662s" data-avatarHtml="true"><img src="data/avatars/s/9/9662.jpg?1380483334" width="48" height="48" alt="RTH" /></a> <a href="posts/1225601/" title="NFL Network visiting 30 teams at camp, Titans not one" class="Tooltip" > NFL Network visiting 30 teams at... </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/rth.9662/">RTH</a> replied <abbr class="DateTime" data-time="1406385307" data-diff="2343" data-datestring="Jul 26, 2014" data-timestring="9:35 AM">Jul 26, 2014 at 9:35 AM</abbr></div> </li> <li class="thread-29420 thread-node-2"> <a href="members/torontotitanfan.3436/" class="avatar Av3436s" data-avatarHtml="true"><img src="data/avatars/s/3/3436.jpg?1389796585" width="48" height="48" alt="TorontoTitanFan" /></a> <a href="posts/1225600/" title="League Conduct Policy Appears Arbitrary" class="Tooltip" > League Conduct Policy Appears... </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/torontotitanfan.3436/">TorontoTitanFan</a> replied <abbr class="DateTime" data-time="1406385251" data-diff="2399" data-datestring="Jul 26, 2014" data-timestring="9:34 AM">Jul 26, 2014 at 9:34 AM</abbr></div> </li> </ul> </div>";s:4:"time";i:1406387650;}s:14:"thread_view_12";a:2:{s:4:"html";s:4321:"<div class="avatarList"> <ul> <li class="thread-29406 thread-node-35"> <a href="members/puck.170/" class="avatar Av170s" data-avatarHtml="true"><img src="data/avatars/s/0/170.jpg?1360983749" width="48" height="48" alt="Puck" /></a> <a href="threads/movie-thread.29406/" > Movie Thread </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/puck.170/">Puck</a> posted <span class="DateTime" title="Jul 21, 2007 at 7:33 PM">Jul 21, 2007</span></div> </li> <li class="thread-69217 thread-node-2"> <a href="members/grindtime.11605/" class="avatar Av11605s" data-avatarHtml="true"><img src="styles/aurora/xenforo/avatars/avatar_s.png" width="48" height="48" alt="grindtime" /></a> <a href="threads/where-is-vy-all-things-vince-young-goes-here.69217/" title="Where is VY? (all things Vince Young goes here)" class="Tooltip" > Where is VY? (all things Vince... </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/grindtime.11605/">grindtime</a> posted <span class="DateTime" title="Feb 10, 2011 at 3:55 PM">Feb 10, 2011</span></div> </li> <li class="thread-16142 thread-node-10"> <a href="members/sec-330-bipolar.1948/" class="avatar Av1948s" data-avatarHtml="true"><img src="data/avatars/s/1/1948.jpg?1342847269" width="48" height="48" alt="SEC 330 BIPOLAR" /></a> <a href="threads/a-place-to-post-funny-things-you-come-across-on-the-web.16142/" title="A place to post funny things you come across on the web" class="Tooltip" > A place to post funny things you... </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/sec-330-bipolar.1948/">SEC 330 BIPOLAR</a> posted <span class="DateTime" title="Jan 9, 2006 at 5:18 PM">Jan 9, 2006</span></div> </li> <li class="thread-36840 thread-node-2"> <a href="members/got.41/" class="avatar Av41s" data-avatarHtml="true"><img src="data/avatars/s/0/41.jpg?1398969832" width="48" height="48" alt="GoT" /></a> <a href="threads/daily-reminder.36840/" > Daily Reminder </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/got.41/">GoT</a> posted <span class="DateTime" title="May 28, 2008 at 10:43 AM">May 28, 2008</span></div> </li> <li class="thread-30729 thread-node-10"> <a href="members/gunny.694/" class="avatar Av694s" data-avatarHtml="true"><img src="data/avatars/s/0/694.jpg?1399331465" width="48" height="48" alt="Gunny" /></a> <a href="threads/the-what-song-are-you-playing-thread.30729/" title="The what song are you playing thread" class="Tooltip" > The what song are you playing... </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/gunny.694/">Gunny</a> posted <span class="DateTime" title="Sep 4, 2007 at 7:37 AM">Sep 4, 2007</span></div> </li> </ul> </div>";s:4:"time";i:1406387349;}s:14:"thread_view_13";a:2:{s:4:"html";s:4665:"<div class="avatarList"> <ul> <li class="thread-53734 thread-node-2"> <a href="members/creeping-cruds.3142/" class="avatar Av3142s" data-avatarHtml="true"><img src="data/avatars/s/3/3142.jpg?1405539802" width="48" height="48" alt="Creeping-Cruds" /></a> <a href="threads/omg-you-guys-were-right-about-fisher-all-along.53734/" title="OMG! You guys were right about Fisher all along" class="Tooltip" > OMG! You guys were right about... </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"> <a href="members/creeping-cruds.3142/">Creeping-Cruds</a> posted, High fives: <a href="posts/542310/likes" class="OverlayTrigger">45</a> </div> </li> <li class="thread-66776 thread-node-2"> <a href="members/sawdustman.10257/" class="avatar Av10257s" data-avatarHtml="true"><img src="data/avatars/s/10/10257.jpg?1342457136" width="48" height="48" alt="SawdustMan" /></a> <a href="threads/a-picture-is-worth-1000-words.66776/" > A picture is worth 1000 words </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"> <a href="members/sawdustman.10257/">SawdustMan</a> posted, High fives: <a href="posts/664308/likes" class="OverlayTrigger">38</a> </div> </li> <li class="thread-78774 thread-node-2"> <a href="members/ravensshallburn.9584/" class="avatar Av9584s" data-avatarHtml="true"><img src="data/avatars/s/9/9584.jpg?1378394493" width="48" height="48" alt="RavensShallBurn" /></a> <a href="threads/no-more-nate-hate-ever.78774/" > No more Nate hate... EVER </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"> <a href="members/ravensshallburn.9584/">RavensShallBurn</a> posted, High fives: <a href="posts/818664/likes" class="OverlayTrigger">36</a> </div> </li> <li class="thread-87538 thread-node-2"> <a href="members/smash.2205/" class="avatar Av2205s" data-avatarHtml="true"><img src="data/avatars/s/2/2205.jpg?1342598364" width="48" height="48" alt="Smash" /></a> <a href="threads/c-g-eugene-amano-released.87538/" > C/G Eugene Amano Released </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"> <a href="members/smash.2205/">Smash</a> posted, High fives: <a href="posts/1022447/likes" class="OverlayTrigger">26</a> </div> </li> <li class="thread-77912 thread-node-2"> <a href="members/deuce-wayne.3817/" class="avatar Av3817s" data-avatarHtml="true"><img src="data/avatars/s/3/3817.jpg?1406214652" width="48" height="48" alt="Deuce Wayne" /></a> <a href="threads/nate-washington-is-my-hero.77912/" > Nate Washington is my hero. </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"> <a href="members/deuce-wayne.3817/">Deuce Wayne</a> posted, High fives: <a href="posts/806490/likes" class="OverlayTrigger">25</a> </div> </li> </ul> </div>";s:4:"time";i:1406387349;}}
    Run Time: 0.000357
  22. SELECT thread.*
    	,
    	user.avatar_date, user.gravatar
    FROM xf_thread AS thread 
    
    	LEFT JOIN xf_user AS user ON
    		(user.user_id = thread.user_id)
    WHERE (thread.node_id IN (1, 2, 3, 63, 54, 55, 56, 57, 58, 60, 9, 10, 26, 27, 35, 14, 44, 19, 6, 41, 62)) AND (thread.discussion_state IN ('visible'))
    ORDER BY thread.view_count DESC
     LIMIT 5
    Run Time: 0.161005
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadrangenode_id_last_post_date,node_id_sticky_last_post_datenode_id_last_post_date4 40285Using where; Using filesort
    SIMPLEusereq_refPRIMARYPRIMARY4jfuqua_xenforo.thread.user_id1 
  23. INSERT INTO xf_data_registry
    	(data_key, data_value)
    VALUES
    	(?, ?)
    ON DUPLICATE KEY UPDATE
    	data_value = VALUES(data_value)
    Params: wfc_1_thread_view, a:3:{s:14:"thread_view_11";a:2:{s:4:"html";s:4582:"<div class="avatarList"> <ul> <li class="thread-92071 thread-node-2"> <a href="members/titanium.3/" class="avatar Av3s" data-avatarHtml="true"><img src="data/avatars/s/0/3.jpg?1344207003" width="48" height="48" alt="Titanium" /></a> <a href="posts/1225609/" title="Titans Online to Broadcast LIVE from Titans Training Camp!" class="Tooltip" > Titans Online to Broadcast LIVE... </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/titanium.3/">Titanium</a> replied <abbr class="DateTime" data-time="1406387347" data-diff="303" data-datestring="Jul 26, 2014" data-timestring="10:09 AM">Jul 26, 2014 at 10:09 AM</abbr></div> </li> <li class="thread-92007 thread-node-2"> <a href="members/tennessy-xo.11963/" class="avatar Av11963s" data-avatarHtml="true"><img src="data/avatars/s/11/11963.jpg?1404872047" width="48" height="48" alt="Tennessy XO" /></a> <a href="posts/1225607/" > Titans Hall of Fans </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/tennessy-xo.11963/">Tennessy XO</a> replied <abbr class="DateTime" data-time="1406387207" data-diff="443" data-datestring="Jul 26, 2014" data-timestring="10:06 AM">Jul 26, 2014 at 10:06 AM</abbr></div> </li> <li class="thread-92055 thread-node-2"> <a href="members/titanium.3/" class="avatar Av3s" data-avatarHtml="true"><img src="data/avatars/s/0/3.jpg?1344207003" width="48" height="48" alt="Titanium" /></a> <a href="posts/1225606/" > Rally Cry </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/titanium.3/">Titanium</a> replied <abbr class="DateTime" data-time="1406386819" data-diff="831" data-datestring="Jul 26, 2014" data-timestring="10:00 AM">Jul 26, 2014 at 10:00 AM</abbr></div> </li> <li class="thread-92049 thread-node-2"> <a href="members/rth.9662/" class="avatar Av9662s" data-avatarHtml="true"><img src="data/avatars/s/9/9662.jpg?1380483334" width="48" height="48" alt="RTH" /></a> <a href="posts/1225601/" title="NFL Network visiting 30 teams at camp, Titans not one" class="Tooltip" > NFL Network visiting 30 teams at... </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/rth.9662/">RTH</a> replied <abbr class="DateTime" data-time="1406385307" data-diff="2343" data-datestring="Jul 26, 2014" data-timestring="9:35 AM">Jul 26, 2014 at 9:35 AM</abbr></div> </li> <li class="thread-29420 thread-node-2"> <a href="members/torontotitanfan.3436/" class="avatar Av3436s" data-avatarHtml="true"><img src="data/avatars/s/3/3436.jpg?1389796585" width="48" height="48" alt="TorontoTitanFan" /></a> <a href="posts/1225600/" title="League Conduct Policy Appears Arbitrary" class="Tooltip" > League Conduct Policy Appears... </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/torontotitanfan.3436/">TorontoTitanFan</a> replied <abbr class="DateTime" data-time="1406385251" data-diff="2399" data-datestring="Jul 26, 2014" data-timestring="9:34 AM">Jul 26, 2014 at 9:34 AM</abbr></div> </li> </ul> </div>";s:4:"time";i:1406387650;}s:14:"thread_view_12";a:2:{s:4:"html";s:4321:"<div class="avatarList"> <ul> <li class="thread-29406 thread-node-35"> <a href="members/puck.170/" class="avatar Av170s" data-avatarHtml="true"><img src="data/avatars/s/0/170.jpg?1360983749" width="48" height="48" alt="Puck" /></a> <a href="threads/movie-thread.29406/" > Movie Thread </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/puck.170/">Puck</a> posted <span class="DateTime" title="Jul 21, 2007 at 7:33 PM">Jul 21, 2007</span></div> </li> <li class="thread-69217 thread-node-2"> <a href="members/grindtime.11605/" class="avatar Av11605s" data-avatarHtml="true"><img src="styles/aurora/xenforo/avatars/avatar_s.png" width="48" height="48" alt="grindtime" /></a> <a href="threads/where-is-vy-all-things-vince-young-goes-here.69217/" title="Where is VY? (all things Vince Young goes here)" class="Tooltip" > Where is VY? (all things Vince... </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/grindtime.11605/">grindtime</a> posted <span class="DateTime" title="Feb 10, 2011 at 3:55 PM">Feb 10, 2011</span></div> </li> <li class="thread-16142 thread-node-10"> <a href="members/sec-330-bipolar.1948/" class="avatar Av1948s" data-avatarHtml="true"><img src="data/avatars/s/1/1948.jpg?1342847269" width="48" height="48" alt="SEC 330 BIPOLAR" /></a> <a href="threads/a-place-to-post-funny-things-you-come-across-on-the-web.16142/" title="A place to post funny things you come across on the web" class="Tooltip" > A place to post funny things you... </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/sec-330-bipolar.1948/">SEC 330 BIPOLAR</a> posted <span class="DateTime" title="Jan 9, 2006 at 5:18 PM">Jan 9, 2006</span></div> </li> <li class="thread-36840 thread-node-2"> <a href="members/got.41/" class="avatar Av41s" data-avatarHtml="true"><img src="data/avatars/s/0/41.jpg?1398969832" width="48" height="48" alt="GoT" /></a> <a href="threads/daily-reminder.36840/" > Daily Reminder </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/got.41/">GoT</a> posted <span class="DateTime" title="May 28, 2008 at 10:43 AM">May 28, 2008</span></div> </li> <li class="thread-30729 thread-node-10"> <a href="members/gunny.694/" class="avatar Av694s" data-avatarHtml="true"><img src="data/avatars/s/0/694.jpg?1399331465" width="48" height="48" alt="Gunny" /></a> <a href="threads/the-what-song-are-you-playing-thread.30729/" title="The what song are you playing thread" class="Tooltip" > The what song are you playing... </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/gunny.694/">Gunny</a> posted <span class="DateTime" title="Sep 4, 2007 at 7:37 AM">Sep 4, 2007</span></div> </li> </ul> </div>";s:4:"time";i:1406387650;}s:14:"thread_view_13";a:2:{s:4:"html";s:4665:"<div class="avatarList"> <ul> <li class="thread-53734 thread-node-2"> <a href="members/creeping-cruds.3142/" class="avatar Av3142s" data-avatarHtml="true"><img src="data/avatars/s/3/3142.jpg?1405539802" width="48" height="48" alt="Creeping-Cruds" /></a> <a href="threads/omg-you-guys-were-right-about-fisher-all-along.53734/" title="OMG! You guys were right about Fisher all along" class="Tooltip" > OMG! You guys were right about... </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"> <a href="members/creeping-cruds.3142/">Creeping-Cruds</a> posted, High fives: <a href="posts/542310/likes" class="OverlayTrigger">45</a> </div> </li> <li class="thread-66776 thread-node-2"> <a href="members/sawdustman.10257/" class="avatar Av10257s" data-avatarHtml="true"><img src="data/avatars/s/10/10257.jpg?1342457136" width="48" height="48" alt="SawdustMan" /></a> <a href="threads/a-picture-is-worth-1000-words.66776/" > A picture is worth 1000 words </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"> <a href="members/sawdustman.10257/">SawdustMan</a> posted, High fives: <a href="posts/664308/likes" class="OverlayTrigger">38</a> </div> </li> <li class="thread-78774 thread-node-2"> <a href="members/ravensshallburn.9584/" class="avatar Av9584s" data-avatarHtml="true"><img src="data/avatars/s/9/9584.jpg?1378394493" width="48" height="48" alt="RavensShallBurn" /></a> <a href="threads/no-more-nate-hate-ever.78774/" > No more Nate hate... EVER </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"> <a href="members/ravensshallburn.9584/">RavensShallBurn</a> posted, High fives: <a href="posts/818664/likes" class="OverlayTrigger">36</a> </div> </li> <li class="thread-87538 thread-node-2"> <a href="members/smash.2205/" class="avatar Av2205s" data-avatarHtml="true"><img src="data/avatars/s/2/2205.jpg?1342598364" width="48" height="48" alt="Smash" /></a> <a href="threads/c-g-eugene-amano-released.87538/" > C/G Eugene Amano Released </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"> <a href="members/smash.2205/">Smash</a> posted, High fives: <a href="posts/1022447/likes" class="OverlayTrigger">26</a> </div> </li> <li class="thread-77912 thread-node-2"> <a href="members/deuce-wayne.3817/" class="avatar Av3817s" data-avatarHtml="true"><img src="data/avatars/s/3/3817.jpg?1406214652" width="48" height="48" alt="Deuce Wayne" /></a> <a href="threads/nate-washington-is-my-hero.77912/" > Nate Washington is my hero. </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"> <a href="members/deuce-wayne.3817/">Deuce Wayne</a> posted, High fives: <a href="posts/806490/likes" class="OverlayTrigger">25</a> </div> </li> </ul> </div>";s:4:"time";i:1406387349;}}
    Run Time: 0.000244
  24. SELECT thread.*
    	,
    	user.avatar_date, user.gravatar
    FROM xf_thread AS thread 
    
    	LEFT JOIN xf_user AS user ON
    		(user.user_id = thread.user_id)
    WHERE (thread.node_id IN (1, 2, 3, 63, 54, 55, 56, 57, 58, 60, 9, 10, 26, 27, 35, 14, 44, 19, 6, 41, 62)) AND (thread.discussion_state IN ('visible'))
    ORDER BY thread.first_post_likes DESC, thread.last_post_date DESC
     LIMIT 5
    Run Time: 0.180885
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadrangenode_id_last_post_date,node_id_sticky_last_post_datenode_id_last_post_date4 40285Using where; Using filesort
    SIMPLEusereq_refPRIMARYPRIMARY4jfuqua_xenforo.thread.user_id1 
  25. INSERT INTO xf_data_registry
    	(data_key, data_value)
    VALUES
    	(?, ?)
    ON DUPLICATE KEY UPDATE
    	data_value = VALUES(data_value)
    Params: wfc_1_thread_view, a:3:{s:14:"thread_view_11";a:2:{s:4:"html";s:4582:"<div class="avatarList"> <ul> <li class="thread-92071 thread-node-2"> <a href="members/titanium.3/" class="avatar Av3s" data-avatarHtml="true"><img src="data/avatars/s/0/3.jpg?1344207003" width="48" height="48" alt="Titanium" /></a> <a href="posts/1225609/" title="Titans Online to Broadcast LIVE from Titans Training Camp!" class="Tooltip" > Titans Online to Broadcast LIVE... </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/titanium.3/">Titanium</a> replied <abbr class="DateTime" data-time="1406387347" data-diff="303" data-datestring="Jul 26, 2014" data-timestring="10:09 AM">Jul 26, 2014 at 10:09 AM</abbr></div> </li> <li class="thread-92007 thread-node-2"> <a href="members/tennessy-xo.11963/" class="avatar Av11963s" data-avatarHtml="true"><img src="data/avatars/s/11/11963.jpg?1404872047" width="48" height="48" alt="Tennessy XO" /></a> <a href="posts/1225607/" > Titans Hall of Fans </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/tennessy-xo.11963/">Tennessy XO</a> replied <abbr class="DateTime" data-time="1406387207" data-diff="443" data-datestring="Jul 26, 2014" data-timestring="10:06 AM">Jul 26, 2014 at 10:06 AM</abbr></div> </li> <li class="thread-92055 thread-node-2"> <a href="members/titanium.3/" class="avatar Av3s" data-avatarHtml="true"><img src="data/avatars/s/0/3.jpg?1344207003" width="48" height="48" alt="Titanium" /></a> <a href="posts/1225606/" > Rally Cry </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/titanium.3/">Titanium</a> replied <abbr class="DateTime" data-time="1406386819" data-diff="831" data-datestring="Jul 26, 2014" data-timestring="10:00 AM">Jul 26, 2014 at 10:00 AM</abbr></div> </li> <li class="thread-92049 thread-node-2"> <a href="members/rth.9662/" class="avatar Av9662s" data-avatarHtml="true"><img src="data/avatars/s/9/9662.jpg?1380483334" width="48" height="48" alt="RTH" /></a> <a href="posts/1225601/" title="NFL Network visiting 30 teams at camp, Titans not one" class="Tooltip" > NFL Network visiting 30 teams at... </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/rth.9662/">RTH</a> replied <abbr class="DateTime" data-time="1406385307" data-diff="2343" data-datestring="Jul 26, 2014" data-timestring="9:35 AM">Jul 26, 2014 at 9:35 AM</abbr></div> </li> <li class="thread-29420 thread-node-2"> <a href="members/torontotitanfan.3436/" class="avatar Av3436s" data-avatarHtml="true"><img src="data/avatars/s/3/3436.jpg?1389796585" width="48" height="48" alt="TorontoTitanFan" /></a> <a href="posts/1225600/" title="League Conduct Policy Appears Arbitrary" class="Tooltip" > League Conduct Policy Appears... </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/torontotitanfan.3436/">TorontoTitanFan</a> replied <abbr class="DateTime" data-time="1406385251" data-diff="2399" data-datestring="Jul 26, 2014" data-timestring="9:34 AM">Jul 26, 2014 at 9:34 AM</abbr></div> </li> </ul> </div>";s:4:"time";i:1406387650;}s:14:"thread_view_12";a:2:{s:4:"html";s:4321:"<div class="avatarList"> <ul> <li class="thread-29406 thread-node-35"> <a href="members/puck.170/" class="avatar Av170s" data-avatarHtml="true"><img src="data/avatars/s/0/170.jpg?1360983749" width="48" height="48" alt="Puck" /></a> <a href="threads/movie-thread.29406/" > Movie Thread </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/puck.170/">Puck</a> posted <span class="DateTime" title="Jul 21, 2007 at 7:33 PM">Jul 21, 2007</span></div> </li> <li class="thread-69217 thread-node-2"> <a href="members/grindtime.11605/" class="avatar Av11605s" data-avatarHtml="true"><img src="styles/aurora/xenforo/avatars/avatar_s.png" width="48" height="48" alt="grindtime" /></a> <a href="threads/where-is-vy-all-things-vince-young-goes-here.69217/" title="Where is VY? (all things Vince Young goes here)" class="Tooltip" > Where is VY? (all things Vince... </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/grindtime.11605/">grindtime</a> posted <span class="DateTime" title="Feb 10, 2011 at 3:55 PM">Feb 10, 2011</span></div> </li> <li class="thread-16142 thread-node-10"> <a href="members/sec-330-bipolar.1948/" class="avatar Av1948s" data-avatarHtml="true"><img src="data/avatars/s/1/1948.jpg?1342847269" width="48" height="48" alt="SEC 330 BIPOLAR" /></a> <a href="threads/a-place-to-post-funny-things-you-come-across-on-the-web.16142/" title="A place to post funny things you come across on the web" class="Tooltip" > A place to post funny things you... </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/sec-330-bipolar.1948/">SEC 330 BIPOLAR</a> posted <span class="DateTime" title="Jan 9, 2006 at 5:18 PM">Jan 9, 2006</span></div> </li> <li class="thread-36840 thread-node-2"> <a href="members/got.41/" class="avatar Av41s" data-avatarHtml="true"><img src="data/avatars/s/0/41.jpg?1398969832" width="48" height="48" alt="GoT" /></a> <a href="threads/daily-reminder.36840/" > Daily Reminder </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/got.41/">GoT</a> posted <span class="DateTime" title="May 28, 2008 at 10:43 AM">May 28, 2008</span></div> </li> <li class="thread-30729 thread-node-10"> <a href="members/gunny.694/" class="avatar Av694s" data-avatarHtml="true"><img src="data/avatars/s/0/694.jpg?1399331465" width="48" height="48" alt="Gunny" /></a> <a href="threads/the-what-song-are-you-playing-thread.30729/" title="The what song are you playing thread" class="Tooltip" > The what song are you playing... </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"><a href="members/gunny.694/">Gunny</a> posted <span class="DateTime" title="Sep 4, 2007 at 7:37 AM">Sep 4, 2007</span></div> </li> </ul> </div>";s:4:"time";i:1406387650;}s:14:"thread_view_13";a:2:{s:4:"html";s:4665:"<div class="avatarList"> <ul> <li class="thread-53734 thread-node-2"> <a href="members/creeping-cruds.3142/" class="avatar Av3142s" data-avatarHtml="true"><img src="data/avatars/s/3/3142.jpg?1405539802" width="48" height="48" alt="Creeping-Cruds" /></a> <a href="threads/omg-you-guys-were-right-about-fisher-all-along.53734/" title="OMG! You guys were right about Fisher all along" class="Tooltip" > OMG! You guys were right about... </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"> <a href="members/creeping-cruds.3142/">Creeping-Cruds</a> posted, High fives: <a href="posts/542310/likes" class="OverlayTrigger">45</a> </div> </li> <li class="thread-66776 thread-node-2"> <a href="members/sawdustman.10257/" class="avatar Av10257s" data-avatarHtml="true"><img src="data/avatars/s/10/10257.jpg?1342457136" width="48" height="48" alt="SawdustMan" /></a> <a href="threads/a-picture-is-worth-1000-words.66776/" > A picture is worth 1000 words </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"> <a href="members/sawdustman.10257/">SawdustMan</a> posted, High fives: <a href="posts/664308/likes" class="OverlayTrigger">38</a> </div> </li> <li class="thread-78774 thread-node-2"> <a href="members/ravensshallburn.9584/" class="avatar Av9584s" data-avatarHtml="true"><img src="data/avatars/s/9/9584.jpg?1378394493" width="48" height="48" alt="RavensShallBurn" /></a> <a href="threads/no-more-nate-hate-ever.78774/" > No more Nate hate... EVER </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"> <a href="members/ravensshallburn.9584/">RavensShallBurn</a> posted, High fives: <a href="posts/818664/likes" class="OverlayTrigger">36</a> </div> </li> <li class="thread-87538 thread-node-2"> <a href="members/smash.2205/" class="avatar Av2205s" data-avatarHtml="true"><img src="data/avatars/s/2/2205.jpg?1342598364" width="48" height="48" alt="Smash" /></a> <a href="threads/c-g-eugene-amano-released.87538/" > C/G Eugene Amano Released </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"> <a href="members/smash.2205/">Smash</a> posted, High fives: <a href="posts/1022447/likes" class="OverlayTrigger">26</a> </div> </li> <li class="thread-77912 thread-node-2"> <a href="members/deuce-wayne.3817/" class="avatar Av3817s" data-avatarHtml="true"><img src="data/avatars/s/3/3817.jpg?1406214652" width="48" height="48" alt="Deuce Wayne" /></a> <a href="threads/nate-washington-is-my-hero.77912/" > Nate Washington is my hero. </a> <div id="PreviewTooltip"> <span class="arrow"><span></span></span> <div class="section"> <div class="primaryContent previewContent"> <span class="PreviewContents">Loading...</span> </div> </div> </div> <div class="userTitle"> <a href="members/deuce-wayne.3817/">Deuce Wayne</a> posted, High fives: <a href="posts/806490/likes" class="OverlayTrigger">25</a> </div> </li> </ul> </div>";s:4:"time";i:1406387650;}}
    Run Time: 0.000256
  26. SELECT wager.user_id, wager.wager_amount_won, 
    	user.username, user.avatar_date, user.avatar_width, user.avatar_height, user.gravatar, 
    	cat.*, 
    	outcome.outcome_title, outcome.outcome_id,	
    	event.event_id, event.title  
    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)
    	LEFT JOIN xf_nflj_sportsbook_category AS cat 
    		ON (cat.category_id = event.category_id)	
    WHERE wager.wager_settled = "Y"
    	AND wager.wager_amount_won > 0
    ORDER BY event.date_settle DESC
    LIMIT ?
    Params: 3
    Run Time: 0.003901
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEwagerrangewager_amount_wonwager_amount_won7 760Using where; Using temporary; Using filesort
    SIMPLEusereq_refPRIMARYPRIMARY4jfuqua_xenforo.wager.user_id1 
    SIMPLEoutcomeeq_refPRIMARYPRIMARY4jfuqua_xenforo.wager.outcome_id1 
    SIMPLEeventeq_refPRIMARYPRIMARY4jfuqua_xenforo.outcome.event_id1 
    SIMPLEcateq_refPRIMARYPRIMARY4jfuqua_xenforo.event.category_id1 
  27. SELECT *
    FROM xf_notification
    ORDER BY notification_id
    Run Time: 0.000231
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_notificationindex PRIMARY4 12 
  28. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('wdb_popular_content')
    Params: 1
    Run Time: 0.000117
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledconstPRIMARYPRIMARY231const,const1 

Included Files (255, XenForo Classes: 71)

  1. index.php
  2. library/XenForo/Autoloader.php
  3. library/XenForo/Application.php
  4. library/Zend/Registry.php
  5. library/Lgpl/utf8.php
  6. library/Zend/Config.php
  7. library/config.php
  8. library/XenForo/FrontController.php
  9. library/XenForo/Dependencies/Public.php
  10. library/XenForo/Dependencies/Abstract.php
  11. library/Zend/Controller/Request/Http.php
  12. library/Zend/Controller/Request/Abstract.php
  13. library/Zend/Uri.php
  14. library/Zend/Controller/Response/Http.php
  15. library/Zend/Controller/Response/Abstract.php
  16. library/XenForo/Model.php
  17. library/XenForo/Model/DataRegistry.php
  18. library/XenForo/CodeEvent.php
  19. library/Zend/Db.php
  20. library/Zend/Db/Adapter/Mysqli.php
  21. library/Zend/Db/Adapter/Abstract.php
  22. library/Zend/Db/Select.php
  23. library/Zend/Db/Expr.php
  24. library/Zend/Db/Profiler.php
  25. library/Zend/Db/Statement/Mysqli.php
  26. library/Zend/Db/Statement.php
  27. library/Zend/Db/Statement/Interface.php
  28. library/Zend/Db/Profiler/Query.php
  29. library/XenForo/Options.php
  30. library/XenForo/Link.php
  31. library/XenForo/Template/Helper/Core.php
  32. library/bdTagMe/Listener.php
  33. library/bdTagMe/Template/Helper.php
  34. library/WidgetFramework/Listener.php
  35. library/WidgetFramework/Core.php
  36. library/XenForo/Model/Moderator.php
  37. library/Tapatalk/Listener/LoadClassModel.php
  38. library/EWRporta/Listener/Model.php
  39. library/SK/MarkThreadRead/Listeners.php
  40. library/XenMoods/Listener/LoadClassModel.php
  41. library/PtoBRforRSS/Listener.php
  42. library/RegFormTimer/Listener.php
  43. library/Waindigo/IgnoreWhatsNew/Listener/LoadClassModel.php
  44. library/Waindigo/Listener/LoadClass.php
  45. library/Waindigo/Listener/LoadClass/20120202.php
  46. library/TMS/Listener/Listener.php
  47. library/EWRutiles/Listener/Model.php
  48. library/ThreadWatchers/Listener.php
  49. library/bdBank/Listeners.php
  50. library/FhTools/SigOnce/EventListener/LoadClassModel.php
  51. library/MasterForums/Listener.php
  52. library/NFLJ/Sportsbook/Listener/WidgetFramework.php
  53. library/NFLJ/StockTrader/Listener/WidgetFramework.php
  54. library/NFLJ/Pickem/Listener/WidgetFramework.php
  55. library/RotatingAds/Listener.php
  56. library/WidgetFramework/Model/Widget.php
  57. library/WidgetFramework/WidgetRenderer.php
  58. library/WidgetFramework/WidgetRenderer/Empty.php
  59. library/XenForo/Input.php
  60. library/WidgetFramework/WidgetRenderer/OnlineStaff.php
  61. library/WidgetFramework/WidgetRenderer/OnlineUsers.php
  62. library/WidgetFramework/WidgetRenderer/Stats.php
  63. library/WidgetFramework/WidgetRenderer/ShareThisPage.php
  64. library/WidgetFramework/WidgetRenderer/UsersFind.php
  65. library/WidgetFramework/WidgetRenderer/Users.php
  66. library/WidgetFramework/WidgetRenderer/Threads.php
  67. library/NFLJ/Sportsbook/WidgetRenderer/RecentEvents.php
  68. library/WidgetFramework/WidgetRenderer/HtmlWithoutWrapper.php
  69. library/WidgetFramework/WidgetRenderer/Html.php
  70. library/WidgetFramework/WidgetRenderer/Poll.php
  71. library/NFLJ/Sportsbook/WidgetRenderer/RecentWinners.php
  72. library/NFLJ/StockTrader/WidgetRenderer/TopPortfolios.php
  73. library/NFLJ/Pickem/WidgetRenderer/Leaderboard.php
  74. library/XenMoods/Listener/InitDependencies.php
  75. library/BannedAvatar/Listener.php
  76. library/EWRporta/Listener/Init.php
  77. library/EWRporta/Helper/Index.php
  78. library/bdBank/Exception.php
  79. library/Zend/Exception.php
  80. library/bdBank/Model/Bank.php
  81. library/XenForo/Router.php
  82. library/XenForo/Route/ResponseSuffix.php
  83. library/XenForo/Route/Interface.php
  84. library/XenForo/Route/Prefix.php
  85. library/XenForo/Route/Prefix/Threads.php
  86. library/EWRporta/Listener/Route.php
  87. library/EWRporta/Route/Thread.php
  88. library/XenForo/RouteMatch.php
  89. library/XenForo/ControllerPublic/Thread.php
  90. library/XenForo/ControllerPublic/Abstract.php
  91. library/XenForo/Controller.php
  92. library/EWRutiles/Listener/Controller.php
  93. library/NodesAsTabs/Listen.php
  94. library/AddPoll/Listener.php
  95. library/ProfileViewCount/Listener.php
  96. library/GritterNotifications/Listener.php
  97. library/DigitalPointAds/Listener/LoadClassController.php
  98. library/Waindigo/IgnoreWhatsNew/Listener/LoadClassController.php
  99. library/EWRporta/Listener/Controller.php
  100. library/NFLJ/Sportsbook/Listener/LoadClassController.php
  101. library/ModerateCountry/RegisterListener.php
  102. library/Social/Listener.php
  103. library/NFLJ/StockTrader/Listener/LoadClassController.php
  104. library/SigRestrict/Listener.php
  105. library/EWRutiles/ControllerPublic/Thread.php
  106. library/WidgetFramework/Extend/ControllerPublic/Thread.php
  107. library/NodesAsTabs/ControllerPublic/Thread.php
  108. library/AddPoll/ControllerPublic/Thread.php
  109. library/DigitalPointAds/ControllerPublic/Thread.php
  110. library/EWRporta/ControllerPublic/Thread.php
  111. library/ThreadWatchers/ControllerPublic/Thread.php
  112. library/SK/MarkThreadRead/ControllerPublic/Thread.php
  113. library/bdBank/XenForo/ControllerPublic/Thread.php
  114. library/XenForo/Session.php
  115. library/XenForo/Visitor.php
  116. library/XenForo/Model/User.php
  117. library/Tapatalk/Model/User.php
  118. library/XenMoods/XFCP/Model/User.php
  119. library/WidgetFramework/Extend/Model/User.php
  120. library/XenForo/Permission.php
  121. library/XenForo/Phrase.php
  122. library/XenForo/Locale.php
  123. library/EWRporta/Model/Perms.php
  124. library/XenForo/ControllerHelper/ForumThreadPost.php
  125. library/XenForo/ControllerHelper/Abstract.php
  126. library/XenForo/Model/Thread.php
  127. library/Waindigo/IgnoreWhatsNew/Model/Thread.php
  128. library/WidgetFramework/Extend/Model/Thread.php
  129. library/ThreadWatchers/Model/Thread.php
  130. library/bdBank/XenForo/Model/Thread.php
  131. library/MasterForums/Model/Thread.php
  132. library/XenForo/Model/Forum.php
  133. library/XenForo/Helper/String.php
  134. library/XenForo/Helper/Discussion.php
  135. library/XenForo/Model/Post.php
  136. library/EWRporta/Model/Post.php
  137. library/EWRutiles/Model/Post.php
  138. library/FhTools/SigOnce/Model/Post.php
  139. library/bdTagMe/XenForo/Model/Post.php
  140. library/XenForo/Model/Attachment.php
  141. library/EWRporta/Model/Attachment.php
  142. library/bdBank/XenForo/Model/Attachment.php
  143. library/XenForo/Model/Node.php
  144. library/Tapatalk/Model/Node.php
  145. library/XenForo/Route/Prefix/Categories.php
  146. library/EWRporta/Route/Categories.php
  147. library/XenForo/Route/BuilderInterface.php
  148. library/XenForo/Route/Prefix/Forums.php
  149. library/XenForo/ControllerResponse/View.php
  150. library/XenForo/ControllerResponse/Abstract.php
  151. library/XenForo/Helper/Cookie.php
  152. library/NodesAsTabs/Model/Options.php
  153. library/XenForo/ViewRenderer/HtmlPublic.php
  154. library/XenForo/ViewRenderer/Abstract.php
  155. library/XenForo/Template/Public.php
  156. library/XenForo/Template/Abstract.php
  157. library/XenMoods/Listener/FrontControllerPreView.php
  158. library/XenMoods/Model/Mood.php
  159. library/XenForo/ViewPublic/Thread/View.php
  160. library/XenForo/ViewPublic/Base.php
  161. library/XenForo/View.php
  162. library/DigitalPointAdPositioning/Listener/LoadClassView.php
  163. library/EWRporta/Listener/ViewPublic.php
  164. library/DigitalPointAds/Listener/LoadClassView.php
  165. library/DigitalPointAdPositioning/ViewPublic/Thread/View.php
  166. library/EWRporta/ViewPublic/Custom.php
  167. library/DigitalPointAds/ViewPublic/Thread/View.php
  168. library/XenForo/BbCode/Parser.php
  169. library/XenForo/BbCode/Formatter/Base.php
  170. library/EWRporta/Listener/BbCode.php
  171. library/EWRutiles/Listener/BbCode.php
  172. library/Ragtek/AATQ/StaticMethods.php
  173. library/Spoiler/listener.php
  174. library/EWRporta/BbCode/Formatter.php
  175. library/EWRutiles/BbCode/Formatter.php
  176. library/Ragtek/AATQ/Extend/BbCode/Formatter/Base.php
  177. library/PtoBRforRSS/BbCode/Formatter/Base.php
  178. library/bdTagMe/XenForo/BbCode/Formatter/Base.php
  179. library/Spoiler/formatter.php
  180. library/bdTagMe/Option.php
  181. library/XenForo/ViewPublic/Helper/Message.php
  182. library/XenForo/BbCode/TextWrapper.php
  183. library/WThreadRow/Listener.php
  184. library/NFLJ/Sportsbook/Listener/TemplateHook.php
  185. library/WidgetFramework/Model/Cache.php
  186. library/Sedo/QuoteME/Listener/PreloadTemplates.php
  187. library/Ragtek/MOU/StaticMethods.php
  188. library/NFLJ/StockTrader/Listener/TemplateHook.php
  189. library/EWRporta/Route/Index.php
  190. library/XenForo/Route/Prefix/Members.php
  191. library/EWRporta/Listener/NavTabs.php
  192. library/DigitalPointAds/TabListener.php
  193. library/FriendInviter/Listener.php
  194. library/NFLJ/Sportsbook/Listener/NavTab.php
  195. library/NFLJ/Pickem/Listener/Template.php
  196. library/NFLJ/StockTrader/Listener/NavTab.php
  197. library/NodesAsTabs/NavTabs.php
  198. library/Ragtek/MOU/Model/OnlineUsers.php
  199. library/XenForo/Model/Session.php
  200. library/XenForo/Template/FileHandler.php
  201. library/XenForo/Helper/File.php
  202. internal_data/templates/S.4,L.1,thread_view.php
  203. library/bdTagMe/Engine.php
  204. library/Tapatalk/EventListener/Hook.php
  205. library/WidgetFramework/Option.php
  206. library/SeparateStickyAndNormal/Listener.php
  207. library/XenMoods/Listener/TemplateHook.php
  208. library/Waindigo/IgnoreWhatsNew/Listener/TemplateHook.php
  209. library/Waindigo/Listener/TemplateHook.php
  210. library/Waindigo/Listener/TemplateHook/20120219.php
  211. library/Waindigo/Listener/Template.php
  212. library/Waindigo/Listener/Template/20120318.php
  213. library/quickReplyPreview/Listen.php
  214. library/DigitalPointAdPositioning/Listener/TemplateHook.php
  215. internal_data/templates/S.4,L.1,thread_view_watchers.php
  216. library/Sedo/QuoteME/Listener/Templates.php
  217. library/EWRporta/Listener/Template.php
  218. library/EWRporta/Model/Promotes.php
  219. library/WdbPopularContent/Listener.php
  220. library/DigitalPointAds/Listener/TemplateHook.php
  221. library/RotatingAds/Engine.php
  222. library/RotatingAds/Model.php
  223. library/EWRutiles/Listener/Template.php
  224. library/EWRutiles/Model/Perms.php
  225. internal_data/templates/S.4,L.1,page_nav.php
  226. internal_data/templates/S.4,L.1,poll_create_controls.php
  227. library/XenForo/Route/Prefix/Posts.php
  228. internal_data/templates/S.4,L.1,bdbank_message_user_info_extra.php
  229. internal_data/templates/S.4,L.1,quick_reply_preview.php
  230. internal_data/templates/S.4,L.1,rotating_ads_second_post.php
  231. library/XenForo/NodeHandler/Category.php
  232. library/XenForo/NodeHandler/Abstract.php
  233. library/XenForo/NodeHandler/Forum.php
  234. library/XenForo/NodeHandler/LinkForum.php
  235. library/XenForo/NodeHandler/Page.php
  236. library/XenForo/Model/Category.php
  237. library/XenForo/Model/LinkForum.php
  238. library/XenForo/Model/Page.php
  239. internal_data/templates/S.4,L.1,wf_widget_threads.php
  240. library/XenForo/Model/Avatar.php
  241. internal_data/templates/S.4,L.1,wf_widget_wrapper.php
  242. library/NFLJ/Sportsbook/Model/Stats.php
  243. internal_data/templates/S.4,L.1,xi_sportsbook_widget_framework_recent_winners.php
  244. library/NFLJ/Sportsbook/Route/Prefix/Outcome.php
  245. library/NFLJ/Sportsbook/Route/Prefix/Event.php
  246. library/XenForo/Debug.php
  247. internal_data/templates/S.4,L.1,PAGE_CONTAINER.php
  248. library/GritterNotifications/Model/Notification.php
  249. library/XenForo/Helper/Criteria.php
  250. internal_data/templates/S.4,L.1,GritterNotifications.php
  251. internal_data/templates/S.4,L.1,xi_sportsbook_tab_links.php
  252. internal_data/templates/S.4,L.1,xi_stocktrader_tab_links.php
  253. library/XenForo/ViewRenderer/Json.php
  254. internal_data/templates/S.4,L.1,wThreadRow_require.php
  255. internal_data/templates/S.4,L.1,bdtagme_PAGE_CONTAINER.php