Page Time: 0.1944s

Memory: 5.6637 MB (Peak: 10.7554 MB)

Queries (22, time: 0.0813s, 41.8%)

  1. SELECT data_key, data_value
    FROM xf_data_registry
    WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routeFiltersIn', 'routeFiltersOut', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'userTitleLadder', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')
    Run Time: 0.004921
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_data_registryrangePRIMARYPRIMARY27 26Using where
  2. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000554
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  3. SELECT thread.*
    	,
    		user.gender, user.avatar_date, user.gravatar,
    		NULL AS thread_read_date,
    		0 AS thread_reply_banned,
    		0 AS thread_is_watched,
    		'' AS draft_message, NULL AS draft_extra
    FROM xf_thread AS thread
    
    		LEFT JOIN xf_user AS user ON
    			(user.user_id = thread.user_id)
    WHERE thread.thread_id = ?
    Params: 85
    Run Time: 0.001070
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadconstPRIMARYPRIMARY4const1 
    SIMPLEuserconstPRIMARYPRIMARY4const1 
  4. 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: 23
    Run Time: 0.000933
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY35const,const,const1 
  5. SELECT post.*
    	,
    		bb_code_parse_cache.parse_tree AS message_parsed, bb_code_parse_cache.cache_version AS message_cache_version,
    		user.*, IF(user.username IS NULL, post.username, user.username) AS username,
    		user_profile.*,
    		user_privacy.*,
    		signature_parse_cache.parse_tree AS signature_parsed, bb_code_parse_cache.cache_version AS signature_cache_version,
    		session_activity.view_date AS last_view_date,
    		0 AS like_date
    FROM xf_post AS post
    
    		LEFT JOIN xf_bb_code_parse_cache AS bb_code_parse_cache ON
    			(bb_code_parse_cache.content_type = 'post' AND bb_code_parse_cache.content_id = post.post_id)
    		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_privacy AS user_privacy ON
    			(user_privacy.user_id = post.user_id)
    		LEFT JOIN xf_bb_code_parse_cache AS signature_parse_cache ON
    			(signature_parse_cache.content_type = 'signature' AND signature_parse_cache.content_id = post.user_id)
    		LEFT JOIN xf_session_activity AS session_activity ON
    			(post.user_id > 0 AND session_activity.user_id = post.user_id AND session_activity.unique_key = CAST(post.user_id AS BINARY))
    WHERE post.thread_id = ?
    	 AND (post.position >= 0 AND post.position < 20) 
    	AND (post.message_state IN ('visible'))
    ORDER BY post.position ASC, post.post_date ASC
    Params: 85
    Run Time: 0.002194
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEpostrefthread_id_post_date,thread_id_positionthread_id_post_date4const9Using index condition; Using where; Using filesort
    SIMPLEbb_code_parse_cacheeq_refcontent_type_idcontent_type_id31const,360tuna_com.post.post_id1Using where
    SIMPLEusereq_refPRIMARYPRIMARY4360tuna_com.post.user_id1 
    SIMPLEuser_profileeq_refPRIMARYPRIMARY4360tuna_com.post.user_id1 
    SIMPLEuser_privacyeq_refPRIMARYPRIMARY4360tuna_com.post.user_id1 
    SIMPLEsignature_parse_cacheeq_refcontent_type_idcontent_type_id31const,360tuna_com.post.user_id1Using where
    SIMPLEsession_activityeq_refPRIMARYPRIMARY22360tuna_com.post.user_id,func1Using where
  6. SELECT attachment.*,
    	data.filename, data.file_size, data.file_hash, data.file_path, data.width, data.height, data.thumbnail_width, data.thumbnail_height
    FROM xf_attachment AS attachment
    INNER JOIN xf_attachment_data AS data ON
    	(data.data_id = attachment.data_id)
    WHERE attachment.content_type = ?
    	AND attachment.content_id IN (3899)
    ORDER BY attachment.content_id, attachment.attach_date
    Params: post
    Run Time: 0.000761
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEattachmentrefcontent_type_id_datecontent_type_id_date31const,const5Using index condition
    SIMPLEdataeq_refPRIMARYPRIMARY4360tuna_com.attachment.data_id1 
  7. INSERT  INTO xf_thread_view
    	(thread_id)
    VALUES
    	(?)
    Params: 85
    Run Time: 0.004953
  8. SELECT trader_id
    FROM xf_trader
    WHERE seller_id = ?
    AND buyer_comment <> ''
    Params: 11
    Run Time: 0.001831
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_traderALL    1291Using where
  9. SELECT trader_id
    FROM xf_trader
    WHERE buyer_id = ?
    AND seller_comment <> ''
    Params: 11
    Run Time: 0.001631
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_traderALL    1291Using where
  10. INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
    Params: 5c3ae47efd40d7fbc655326f08f6d9e7, , 1611698960
    Run Time: 0.005089
  11. INSERT INTO xf_session_activity
    	(user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date, robot_key)
    VALUES
    	(?, ?, ?, ?, ?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE
    	ip = VALUES(ip),
    	controller_name = VALUES(controller_name),
    	controller_action = VALUES(controller_action),
    	view_state = VALUES(view_state),
    	params = VALUES(params),
    	view_date = VALUES(view_date),
    	robot_key = VALUES(robot_key)
    Params: 0, , , XenForo_ControllerPublic_Thread, Index, valid, thread_id=85, 1611695360,
    Run Time: 0.004295
  12. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('page_nav', 'bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'bb_code_tag_spoiler', 'wf_widget_wrapper', 'wf_widget_threads', 'thread_view', 'wf_hook_moderator_bar', 'wf_revealer', 'PAGE_CONTAINER')
    	AND style_id = ?
    	AND language_id = ?
    Params: 7, 1
    Run Time: 0.004681
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_template_compiledrangePRIMARYPRIMARY60 13Using where
  13. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 413, a:1:{i:0;s:1430:"Hey I have a28ft mako booked in Playa Zancudo, Costa Rica for Feb 4,5,6 2007, with sportfishing unlimited www.sportfishing.co.cr Their other 28ft mako is available for the same days if we have enough interest we can get it as well. The boat is $550 per day plus tip. Hotel in San Jose runs from 80-120.us Zancudo hotels are 45-65 per day and includes laundry svc. Meals and drinks are cheap, there is lunch and drinks on the boat.. My wife, her friend and I will be there. McGolfer has expressed an interest. You would have shots at lots of Sails, blue/black marlin, tuna and some impressive dorado offshore.. Inshore gets a lot of pressure that time of the year and is not usually productive. The Itenerary would look like this. Leave Dfw Fri, Feb 2 late afternoon, arrive San Jose around 9:30, Take a cab to hotel Aeropuerto. Up O'dark thirty for the Early flight to Golfito, which leaves @6 or 6:30 am. In Golfito by 7:30 Take a cab to el muellecito(little dock) Eat breakfast at the little rest. Have all day saturday to hang out.. Fish Sun, Mon,Tue, Take the early flight out wednesday and you are back in Dfw Wed, afternoon. We are staying through the weekend to see the Taj Majal blues concert on the 10th.. We went to it year before last and it was an awesome show. Yall are welcome to do the same.. You wont want to leave.. Let me know if you have any interest as their dates fill up quickly. Bret";}, 1608575237, 1611695360
    Run Time: 0.005497
  14. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 417, a:1:{i:0;s:282:"Bret, I am very interested and put me down as committed. I will clear it with my wife (which should not be a problem). We can't pass up good fishing, drinks, and music. Only I will be fishing, not her. She may be interested in going for the ride on the boat if that is possible.";}, 1608575237, 1611695360
    Run Time: 0.005125
  15. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 424, a:1:{i:0;s:276:"Ok, Scott and Rick, I just got an email from John to confirm that the other boat is indeed available for Feb 4,5,6 2007. Thats $550 per day for the boat plus tip. split two ways. I have asked them to hold the boat for a week so we can make confirm those that want to go..";}, 1608575237, 1611695360
    Run Time: 0.004487
  16. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 433, a:1:{i:0;s:286:"Perfect. Ok, Scott and Rick, I just got an email from John to confirm that the other boat is indeed available for Feb 4,5,6 2007. Thats $550 per day for the boat plus tip. split two ways. I have asked them to hold the boat for a week so we can make confirm those that want to go..";}, 1608575237, 1611695360
    Run Time: 0.004528
  17. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 557, a:1:{i:0;s:222:"I forgot to mention, for travel to Costa Rica you will need a valid Passport.. so if you dont have one or it has expired, you had better get the ball rolling as it can take up to 2 months for the govt to get it completed..";}, 1608575237, 1611695360
    Run Time: 0.004695
  18. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 1624, a:1:{i:0;s:79:"i went to roys in zancudo last year and caught sails yellowfin and a 750lb blue";}, 1608575237, 1611695360
    Run Time: 0.004506
  19. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 1625, a:1:{i:0;s:161:"Yeah, Zancudo is a pretty cool place. My buddies down there keep their boats at Roys dock... Teamprosports, Welcome to 360 tuna.. When are you going back???";}, 1608575237, 1611695360
    Run Time: 0.004229
  20. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 1627, a:1:{i:0;s:189:"Sounds like one hell of a trip. Wish I could go. Its looking like I wont make the lump trip this year either. Hope all is well and having a kid is great! Wish you guys the best of luck.";}, 1608575237, 1611695360
    Run Time: 0.007722
  21. INSERT INTO xf_bb_code_parse_cache
    	(content_type, content_id, parse_tree, cache_version, cache_date)
    VALUES (?, ?, ?, ?, ?)
    ON DUPLICATE KEY UPDATE parse_tree = VALUES(parse_tree),
    	cache_version = VALUES(cache_version),
    	cache_date = VALUES(cache_date)
    Params: post, 3899, a:1:{i:0;s:216:"Well, I got the Sansa Flight confirmations for all this morning. Everything is done, We just need to show up and catch some fish!!! Hurry up Feb....... Here are a couple of pics from feb 05, to wet your appetite..";}, 1608575237, 1611695360
    Run Time: 0.007024
  22. SELECT data_key, data_value
    FROM xf_data_registry
    WHERE data_key IN ('wfc__1_thread_view')
    Run Time: 0.000540
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_data_registryconstPRIMARYPRIMARY27const1 

Included Files (118, XenForo Classes: 61)

  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/DataRegistry.php
  17. library/XenForo/Model.php
  18. library/Zend/Db.php
  19. library/Zend/Db/Adapter/Mysqli.php
  20. library/Zend/Db/Adapter/Abstract.php
  21. library/Zend/Db/Select.php
  22. library/Zend/Db/Expr.php
  23. library/Zend/Db/Profiler.php
  24. library/Zend/Db/Statement/Mysqli.php
  25. library/Zend/Db/Statement.php
  26. library/Zend/Db/Statement/Interface.php
  27. library/Zend/Db/Profiler/Query.php
  28. library/XenForo/CodeEvent.php
  29. library/XenForo/Options.php
  30. library/XenForo/Link.php
  31. library/XenForo/Template/Helper/Core.php
  32. library/bdMails/Listener.php
  33. library/bdMails/Helper/Transport.php
  34. library/bdMails/Option.php
  35. library/bdMails/ShippableHelper/Updater.php
  36. library/WidgetFramework/Listener.php
  37. library/WidgetFramework/Option.php
  38. library/XFResource/Sendy/Listener.php
  39. library/XenForo/Router.php
  40. library/XenForo/Route/Filter.php
  41. library/XenForo/Route/Interface.php
  42. library/XenForo/Route/ResponseSuffix.php
  43. library/XenForo/Route/Prefix.php
  44. library/WidgetFramework/Route/Filter/PageX.php
  45. library/XenForo/Route/Prefix/Threads.php
  46. library/XenForo/RouteMatch.php
  47. library/XenForo/ControllerPublic/Thread.php
  48. library/XenForo/ControllerPublic/Abstract.php
  49. library/XenForo/Controller.php
  50. library/Tinhte/NodeConverter/Listener.php
  51. library/Andy/Trader/Listener.php
  52. library/WidgetFramework/XenForo/ControllerPublic/Thread.php
  53. library/Andy/Trader/ControllerPublic/Thread.php
  54. library/XenForo/Input.php
  55. library/XenForo/Session.php
  56. library/XenForo/Helper/Ip.php
  57. library/XenForo/Visitor.php
  58. library/XenForo/Model/User.php
  59. library/Tapatalk/Listener/LoadClassModel.php
  60. library/WidgetFramework/XenForo/Model/User.php
  61. library/XenForo/Permission.php
  62. library/XenForo/Helper/Php.php
  63. library/XenForo/Phrase.php
  64. library/XenForo/Locale.php
  65. library/Sedo/DetectBrowser/Listener/Visitor.php
  66. library/Sedo/DetectBrowser/Helper/MobileDetect.php
  67. library/XenForo/ControllerHelper/ForumThreadPost.php
  68. library/XenForo/ControllerHelper/Abstract.php
  69. library/XenForo/Model/Thread.php
  70. library/WidgetFramework/XenForo/Model/Thread.php
  71. library/XenForo/Model/Forum.php
  72. library/Tinhte/NodeConverter/XenForo/Model/Forum.php
  73. library/XenForo/Helper/String.php
  74. library/XenForo/Model/Post.php
  75. library/XenForo/Model/Attachment.php
  76. library/XenForo/Route/Prefix/Attachments.php
  77. library/XenForo/Model/Node.php
  78. library/Tapatalk/Model/Node.php
  79. library/Tinhte/NodeConverter/XenForo/Model/Node.php
  80. library/XenForo/Route/Prefix/Categories.php
  81. library/XenForo/Route/Prefix/Forums.php
  82. library/XenForo/ControllerResponse/View.php
  83. library/XenForo/ControllerResponse/Abstract.php
  84. library/XenForo/Helper/Cookie.php
  85. library/Tapatalk/Listener/ControllerPostDispatch.php
  86. library/XenForo/ViewRenderer/HtmlPublic.php
  87. library/XenForo/ViewRenderer/Abstract.php
  88. library/XenForo/Template/Public.php
  89. library/XenForo/Template/Abstract.php
  90. library/WidgetFramework/Core.php
  91. library/XenForo/Model/Moderator.php
  92. library/WidgetFramework/Model/Widget.php
  93. library/WidgetFramework/Helper/Sort.php
  94. library/WidgetFramework/WidgetRenderer.php
  95. library/XenForo/ViewPublic/Thread/View.php
  96. library/XenForo/ViewPublic/Base.php
  97. library/XenForo/View.php
  98. library/WidgetFramework/XenForo/View1.php
  99. library/XenForo/BbCode/Parser.php
  100. library/XenForo/BbCode/Formatter/Base.php
  101. library/WidgetFramework/XenForo/BbCode/Formatter/Base.php
  102. library/XenForo/ViewPublic/Helper/Message.php
  103. library/XenForo/BbCode/TextWrapper.php
  104. library/WidgetFramework/WidgetRenderer/Empty.php
  105. library/WidgetFramework/WidgetRenderer/Threads.php
  106. library/WidgetFramework/Model/Cache.php
  107. library/XenForo/Route/Prefix/Members.php
  108. library/WidgetFramework/Template/Extended.php
  109. library/Tapatalk/EventListener/Hook.php
  110. library/XenForo/Route/Prefix/Posts.php
  111. library/XenForo/Model/Avatar.php
  112. library/WidgetFramework/Helper/String.php
  113. library/Tapatalk/Listener/TemplatePostRender.php
  114. library/XenForo/Debug.php
  115. library/dfp/target/index.php
  116. mobiquo/mbqFrame/3rdLib/classTTConnection.php
  117. mobiquo/smartbanner/head.inc.php
  118. library/XenForo/ViewRenderer/Json.php