Page Time: 0.4062s

Memory: 13.7680 MB (Peak: 16.8931 MB)

Queries (30, time: 0.2815s, 69.3%)

  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.000463
    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.000103
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_data_registryconstPRIMARYPRIMARY77const1 
  3. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000132
    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: 85764
    Run Time: 0.000277
    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: 2
    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 >= 210 AND post.position < 220) 
    	AND (post.message_state IN ('visible'))
    ORDER BY post.position ASC, post.post_date ASC
    Params: 85764
    Run Time: 0.001859
    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: 85764
    Run Time: 0.000627
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_postrefthread_id_post_date,thread_id_positionthread_id_position4const366Using where
  8. INSERT DELAYED INTO xf_thread_view
    	(thread_id)
    VALUES
    	(?)
    Params: 85764
    Run Time: 0.000072
  9. SELECT *
    FROM xf_node
    WHERE lft < ? AND rgt > ?
    ORDER BY lft ASC
    Params: 2, 3
    Run Time: 0.000278
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_noderangelftlft4 1Using where
  10. SELECT COUNT(*)
    FROM xf_thread_watch
    WHERE thread_id = ?
    Params: 85764
    Run Time: 0.000157
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_thread_watchrefthread_id_email_subscribethread_id_email_subscribe4const9Using index
  11. INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
    Params: b34a39d23f5f3b24f857c9cfe068e8bd, a:5:{s:12:"sessionStart";i:1406594461;s:2:"ip";i:911338532;s:9:"userAgent";s:39:"CCBot/2.0 (http://commoncrawl.org/faq/)";s:7:"isRobot";b:0;s:16:"previousActivity";i:0;}, 1406598061
    Run Time: 0.000127
  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, 911338532, 911338532, XenForo_ControllerPublic_Thread, Index, valid, thread_id=85764&page=22, 1406594461
    Run Time: 0.000105
  13. SELECT user.*
    	
    FROM xf_user AS user
    
    WHERE user.user_id = ?
    Params: 11428
    Run Time: 0.000460
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEuserconstPRIMARYPRIMARY4const1 
  14. SELECT user.*
    	
    FROM xf_user AS user
    
    WHERE user.user_id = ?
    Params: 11868
    Run Time: 0.000255
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEuserconstPRIMARYPRIMARY4const1 
  15. 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 > 1406590861)
    ORDER BY session_activity.view_date DESC
    Run Time: 0.001630
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEsession_activityALLview_date   438Using where; Using filesort
    SIMPLEusereq_refPRIMARYPRIMARY4jfuqua_xenforo.session_activity.user_id1 
    SIMPLEuser_profileeq_refPRIMARYPRIMARY4jfuqua_xenforo.user.user_id1 
    SIMPLEuser_optioneq_refPRIMARYPRIMARY4jfuqua_xenforo.user.user_id1 
  16. SELECT item.*
    	
    FROM `xf_rotating_ads_item` AS item
    	
    WHERE 1=1
    Run Time: 0.000117
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEitemALL    1 
  17. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('post_reply')
    Params: 1
    Run Time: 0.000149
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledconstPRIMARYPRIMARY231const,const1 
  18. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('preview')
    Params: 1
    Run Time: 0.000091
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledconstPRIMARYPRIMARY231const,const1 
  19. SELECT data_key, data_value
    FROM xf_data_registry
    WHERE data_key IN ('wfc_1_thread_view')
    Run Time: 0.000089
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_data_registryconstPRIMARYPRIMARY77const1 
  20. SELECT *
    FROM xf_node
    
    ORDER BY lft ASC
    Run Time: 0.000200
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_nodeALL    24Using filesort
  21.                 SELECT cache_value
                    FROM xf_permission_cache_content_type
                    WHERE permission_combination_id = ?
                        AND content_type = 'node'
    Params: 1
    Run Time: 0.000095
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_cache_content_typeconstPRIMARYPRIMARY81const,const1 
  22. 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.000624
    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 
  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:4438:"<div class="avatarList"> <ul> <li class="thread-92080 thread-node-2"> <a href="members/the-hammer.12726/" class="avatar Av12726s" data-avatarHtml="true"><img src="data/avatars/s/12/12726.jpg?1406345092" width="48" height="48" alt="The Hammer" /></a> <a href="posts/1226300/" title="Titans have 2 of 22 &quot;worst&quot; current contracts" class="Tooltip" > Titans have 2 of 22 &quot;worst&quot;... </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/the-hammer.12726/">The Hammer</a> replied <abbr class="DateTime" data-time="1406594420" data-diff="41" data-datestring="Jul 28, 2014" data-timestring="7:40 PM">Jul 28, 2014 at 7:40 PM</abbr></div> </li> <li class="thread-91834 thread-node-35"> <a href="members/cajun_titan_33.12080/" class="avatar Av12080s" data-avatarHtml="true"><img src="data/avatars/s/12/12080.jpg?1381021670" width="48" height="48" alt="Cajun_Titan_33" /></a> <a href="posts/1226299/" > Game of Thrones </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/cajun_titan_33.12080/">Cajun_Titan_33</a> replied <abbr class="DateTime" data-time="1406594299" data-diff="162" data-datestring="Jul 28, 2014" data-timestring="7:38 PM">Jul 28, 2014 at 7:38 PM</abbr></div> </li> <li class="thread-92081 thread-node-2"> <a href="members/jcbrave.9605/" class="avatar Av9605s" data-avatarHtml="true"><img src="data/avatars/s/9/9605.jpg?1406558995" width="48" height="48" alt="JCBRAVE" /></a> <a href="posts/1226297/" > Monday, July 28 </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/jcbrave.9605/">JCBRAVE</a> replied <abbr class="DateTime" data-time="1406594165" data-diff="296" data-datestring="Jul 28, 2014" data-timestring="7:36 PM">Jul 28, 2014 at 7:36 PM</abbr></div> </li> <li class="thread-84686 thread-node-35"> <a href="members/ryno.9698/" class="avatar Av9698s" data-avatarHtml="true"><img src="data/avatars/s/9/9698.jpg?1399607225" width="48" height="48" alt="Ryno" /></a> <a href="posts/1226294/" > The Walking Dead </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/ryno.9698/">Ryno</a> replied <abbr class="DateTime" data-time="1406593682" data-diff="779" data-datestring="Jul 28, 2014" data-timestring="7:28 PM">Jul 28, 2014 at 7:28 PM</abbr></div> </li> <li class="thread-92040 thread-node-2"> <a href="members/passepartout.9645/" class="avatar Av9645s" data-avatarHtml="true"><img src="data/avatars/s/9/9645.jpg?1405138272" width="48" height="48" alt="Passepartout" /></a> <a href="posts/1226293/" > Zach Mettenberger Bar Fight? </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/passepartout.9645/">Passepartout</a> replied <abbr class="DateTime" data-time="1406593530" data-diff="931" data-datestring="Jul 28, 2014" data-timestring="7:25 PM">Jul 28, 2014 at 7:25 PM</abbr></div> </li> </ul> </div>";s:4:"time";i:1406594461;}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:1406594160;}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:1406594160;}}
    Run Time: 0.000246
  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.view_count DESC
     LIMIT 5
    Run Time: 0.134010
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadrangenode_id_last_post_date,node_id_sticky_last_post_datenode_id_last_post_date4 40298Using 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:4438:"<div class="avatarList"> <ul> <li class="thread-92080 thread-node-2"> <a href="members/the-hammer.12726/" class="avatar Av12726s" data-avatarHtml="true"><img src="data/avatars/s/12/12726.jpg?1406345092" width="48" height="48" alt="The Hammer" /></a> <a href="posts/1226300/" title="Titans have 2 of 22 &quot;worst&quot; current contracts" class="Tooltip" > Titans have 2 of 22 &quot;worst&quot;... </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/the-hammer.12726/">The Hammer</a> replied <abbr class="DateTime" data-time="1406594420" data-diff="41" data-datestring="Jul 28, 2014" data-timestring="7:40 PM">Jul 28, 2014 at 7:40 PM</abbr></div> </li> <li class="thread-91834 thread-node-35"> <a href="members/cajun_titan_33.12080/" class="avatar Av12080s" data-avatarHtml="true"><img src="data/avatars/s/12/12080.jpg?1381021670" width="48" height="48" alt="Cajun_Titan_33" /></a> <a href="posts/1226299/" > Game of Thrones </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/cajun_titan_33.12080/">Cajun_Titan_33</a> replied <abbr class="DateTime" data-time="1406594299" data-diff="162" data-datestring="Jul 28, 2014" data-timestring="7:38 PM">Jul 28, 2014 at 7:38 PM</abbr></div> </li> <li class="thread-92081 thread-node-2"> <a href="members/jcbrave.9605/" class="avatar Av9605s" data-avatarHtml="true"><img src="data/avatars/s/9/9605.jpg?1406558995" width="48" height="48" alt="JCBRAVE" /></a> <a href="posts/1226297/" > Monday, July 28 </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/jcbrave.9605/">JCBRAVE</a> replied <abbr class="DateTime" data-time="1406594165" data-diff="296" data-datestring="Jul 28, 2014" data-timestring="7:36 PM">Jul 28, 2014 at 7:36 PM</abbr></div> </li> <li class="thread-84686 thread-node-35"> <a href="members/ryno.9698/" class="avatar Av9698s" data-avatarHtml="true"><img src="data/avatars/s/9/9698.jpg?1399607225" width="48" height="48" alt="Ryno" /></a> <a href="posts/1226294/" > The Walking Dead </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/ryno.9698/">Ryno</a> replied <abbr class="DateTime" data-time="1406593682" data-diff="779" data-datestring="Jul 28, 2014" data-timestring="7:28 PM">Jul 28, 2014 at 7:28 PM</abbr></div> </li> <li class="thread-92040 thread-node-2"> <a href="members/passepartout.9645/" class="avatar Av9645s" data-avatarHtml="true"><img src="data/avatars/s/9/9645.jpg?1405138272" width="48" height="48" alt="Passepartout" /></a> <a href="posts/1226293/" > Zach Mettenberger Bar Fight? </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/passepartout.9645/">Passepartout</a> replied <abbr class="DateTime" data-time="1406593530" data-diff="931" data-datestring="Jul 28, 2014" data-timestring="7:25 PM">Jul 28, 2014 at 7:25 PM</abbr></div> </li> </ul> </div>";s:4:"time";i:1406594461;}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:1406594461;}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:1406594160;}}
    Run Time: 0.000333
  26. 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.134293
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadrangenode_id_last_post_date,node_id_sticky_last_post_datenode_id_last_post_date4 40298Using where; Using filesort
    SIMPLEusereq_refPRIMARYPRIMARY4jfuqua_xenforo.thread.user_id1 
  27. 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:4438:"<div class="avatarList"> <ul> <li class="thread-92080 thread-node-2"> <a href="members/the-hammer.12726/" class="avatar Av12726s" data-avatarHtml="true"><img src="data/avatars/s/12/12726.jpg?1406345092" width="48" height="48" alt="The Hammer" /></a> <a href="posts/1226300/" title="Titans have 2 of 22 &quot;worst&quot; current contracts" class="Tooltip" > Titans have 2 of 22 &quot;worst&quot;... </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/the-hammer.12726/">The Hammer</a> replied <abbr class="DateTime" data-time="1406594420" data-diff="41" data-datestring="Jul 28, 2014" data-timestring="7:40 PM">Jul 28, 2014 at 7:40 PM</abbr></div> </li> <li class="thread-91834 thread-node-35"> <a href="members/cajun_titan_33.12080/" class="avatar Av12080s" data-avatarHtml="true"><img src="data/avatars/s/12/12080.jpg?1381021670" width="48" height="48" alt="Cajun_Titan_33" /></a> <a href="posts/1226299/" > Game of Thrones </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/cajun_titan_33.12080/">Cajun_Titan_33</a> replied <abbr class="DateTime" data-time="1406594299" data-diff="162" data-datestring="Jul 28, 2014" data-timestring="7:38 PM">Jul 28, 2014 at 7:38 PM</abbr></div> </li> <li class="thread-92081 thread-node-2"> <a href="members/jcbrave.9605/" class="avatar Av9605s" data-avatarHtml="true"><img src="data/avatars/s/9/9605.jpg?1406558995" width="48" height="48" alt="JCBRAVE" /></a> <a href="posts/1226297/" > Monday, July 28 </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/jcbrave.9605/">JCBRAVE</a> replied <abbr class="DateTime" data-time="1406594165" data-diff="296" data-datestring="Jul 28, 2014" data-timestring="7:36 PM">Jul 28, 2014 at 7:36 PM</abbr></div> </li> <li class="thread-84686 thread-node-35"> <a href="members/ryno.9698/" class="avatar Av9698s" data-avatarHtml="true"><img src="data/avatars/s/9/9698.jpg?1399607225" width="48" height="48" alt="Ryno" /></a> <a href="posts/1226294/" > The Walking Dead </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/ryno.9698/">Ryno</a> replied <abbr class="DateTime" data-time="1406593682" data-diff="779" data-datestring="Jul 28, 2014" data-timestring="7:28 PM">Jul 28, 2014 at 7:28 PM</abbr></div> </li> <li class="thread-92040 thread-node-2"> <a href="members/passepartout.9645/" class="avatar Av9645s" data-avatarHtml="true"><img src="data/avatars/s/9/9645.jpg?1405138272" width="48" height="48" alt="Passepartout" /></a> <a href="posts/1226293/" > Zach Mettenberger Bar Fight? </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/passepartout.9645/">Passepartout</a> replied <abbr class="DateTime" data-time="1406593530" data-diff="931" data-datestring="Jul 28, 2014" data-timestring="7:25 PM">Jul 28, 2014 at 7:25 PM</abbr></div> </li> </ul> </div>";s:4:"time";i:1406594461;}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:1406594461;}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:1406594461;}}
    Run Time: 0.000290
  28. 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.003826
    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 
  29. SELECT *
    FROM xf_notification
    ORDER BY notification_id
    Run Time: 0.000219
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_notificationindex PRIMARY4 12 
  30. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('wdb_popular_content')
    Params: 1
    Run Time: 0.000103
    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/Sedo/QuoteME/Listener/PreloadTemplates.php
  186. library/Ragtek/MOU/StaticMethods.php
  187. library/NFLJ/StockTrader/Listener/TemplateHook.php
  188. library/XenForo/Template/FileHandler.php
  189. library/XenForo/Helper/File.php
  190. internal_data/templates/S.4,L.1,bb_code_tag_quote_ragtek.php
  191. library/XenForo/Route/Prefix/Members.php
  192. library/XenForo/Model/Avatar.php
  193. library/FriendInviter/Listener.php
  194. library/Sedo/QuoteME/Listener/Templates.php
  195. library/quickReplyPreview/Listen.php
  196. library/WidgetFramework/Model/Cache.php
  197. library/EWRporta/Route/Index.php
  198. library/EWRporta/Listener/NavTabs.php
  199. library/DigitalPointAds/TabListener.php
  200. library/NFLJ/Sportsbook/Listener/NavTab.php
  201. library/NFLJ/Pickem/Listener/Template.php
  202. library/NFLJ/StockTrader/Listener/NavTab.php
  203. library/NodesAsTabs/NavTabs.php
  204. library/Ragtek/MOU/Model/OnlineUsers.php
  205. library/XenForo/Model/Session.php
  206. internal_data/templates/S.4,L.1,thread_view.php
  207. library/bdTagMe/Engine.php
  208. library/Tapatalk/EventListener/Hook.php
  209. library/WidgetFramework/Option.php
  210. library/SeparateStickyAndNormal/Listener.php
  211. library/XenMoods/Listener/TemplateHook.php
  212. library/Waindigo/IgnoreWhatsNew/Listener/TemplateHook.php
  213. library/Waindigo/Listener/TemplateHook.php
  214. library/Waindigo/Listener/TemplateHook/20120219.php
  215. library/Waindigo/Listener/Template.php
  216. library/Waindigo/Listener/Template/20120318.php
  217. library/DigitalPointAdPositioning/Listener/TemplateHook.php
  218. internal_data/templates/S.4,L.1,thread_view_watchers.php
  219. library/EWRporta/Listener/Template.php
  220. library/EWRporta/Model/Promotes.php
  221. library/WdbPopularContent/Listener.php
  222. library/DigitalPointAds/Listener/TemplateHook.php
  223. library/RotatingAds/Engine.php
  224. library/RotatingAds/Model.php
  225. library/EWRutiles/Listener/Template.php
  226. library/EWRutiles/Model/Perms.php
  227. internal_data/templates/S.4,L.1,page_nav.php
  228. internal_data/templates/S.4,L.1,poll_create_controls.php
  229. library/XenForo/Route/Prefix/Posts.php
  230. internal_data/templates/S.4,L.1,bdbank_message_user_info_extra.php
  231. internal_data/templates/S.4,L.1,quick_reply_preview.php
  232. library/XenForo/NodeHandler/Category.php
  233. library/XenForo/NodeHandler/Abstract.php
  234. library/XenForo/NodeHandler/Forum.php
  235. library/XenForo/NodeHandler/LinkForum.php
  236. library/XenForo/NodeHandler/Page.php
  237. library/XenForo/Model/Category.php
  238. library/XenForo/Model/LinkForum.php
  239. library/XenForo/Model/Page.php
  240. internal_data/templates/S.4,L.1,wf_widget_threads.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