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.003520
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using where |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000599
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
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: 499
Run Time: 0.000733
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
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: 3
Run Time: 0.001086
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | permission | const | PRIMARY | PRIMARY | 35 | const,const,const | 1 | |
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: 499
Run Time: 0.001429
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | ref | thread_id_post_date,thread_id_position | thread_id_post_date | 4 | const | 10 | Using index condition; Using where; Using filesort |
SIMPLE | bb_code_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,360tuna_com.post.post_id | 1 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | 360tuna_com.post.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | 360tuna_com.post.user_id | 1 | |
SIMPLE | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | 360tuna_com.post.user_id | 1 | |
SIMPLE | signature_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,360tuna_com.post.user_id | 1 | Using where |
SIMPLE | session_activity | eq_ref | PRIMARY | PRIMARY | 22 | 360tuna_com.post.user_id,func | 1 | Using where |
INSERT INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 499
Run Time: 0.006704
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: a3942ac7d69fa5c33b1a8c9495628f36, , 1611698875
Run Time: 0.005141
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=499, 1611695275,
Run Time: 0.003446
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.003118
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 13 | Using where |
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, 4386, a:2:{i:0;s:800:"I've been a lot into trolling and just now I'm getting into jigging and I'm loving it!
I have some conventionals that work reelly good, tn40, tn50, toriums 20 & 30for smaller fish, and I am now looking for a good spinning reel, I can't at the time spend the big bucks on a high end stella or satliga, so I'm considering the best I can buy for around $200 dlls to try jiging on spinning gear.
So far I've looked into the QUANTUM CABO CSP80PTS, and the FIN NOR AHAB OFF SHORE, Altough I just read on this forum that the fin nor does not have the infinite anti reverse...
Wich one you you choose or what other reel in that price range would you recomend?
Thx!
Here's a link to a small video of some YT fishing in San Carlos last Sat. 1 trolling 3 casting a live jig on 15# spinning. Lots of Fun.
";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:42:"http://www.youtube.com/watch?v=HuFgitZuWu0";s:8:"original";a:2:{i:0;s:50:"[URL="http://www.youtube.com/watch?v=HuFgitZuWu0"]";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:42:"http://www.youtube.com/watch?v=HuFgitZuWu0";}}}, 1608575237, 1611695275
Run Time: 0.004748
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, 4393, a:1:{i:0;s:138:"Shimano Spheros 14000.
PM jig, he has used this reel, and actually caught tuna with it. I am lookin to get one as soon as I arrange funds.";}, 1608575237, 1611695275
Run Time: 0.004285
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, 4394, a:1:{i:0;s:552:"I got to pre-fish the Cabo80 last Sept and the drag was set at 15lbs with 65lb PP. I cranked up the drag on a frisky 60lb YFT and after the fish was gaffed the drag pulled 20lbs with more room to turn. I am going to get one this season and put it on a good 7'6" 50lb spinner and hurl poppers to the other side of the Gulf.
I have also fished a Stella 20K, 10K & 8K, Diawa 6500Z, and Penn 9500 & 8500. The older Penns tend to have issues when fishing spectra outside the rated line class even though I didn't have any problems with any of the above.";}, 1608575237, 1611695275
Run Time: 0.004004
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, 4398, a:1:{i:0;s:286:"Thx for the reply guys, I've onlye heard good things about the Cabo...I really want to hear from people that have alredy used it and abused it. Good to hear an opinion from someone that has actually used it!
Thx and lets wait for some more cooments and suggestions.
Fernando PQ Almada";}, 1608575237, 1611695275
Run Time: 0.005675
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, 4399, a:1:{i:0;s:155:"Viewing your film, I gather you were the only person on board. Gaffing your own fish and having too many lines out in the water by yourself is a challenge.";}, 1608575237, 1611695275
Run Time: 0.003819
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, 4400, a:1:{i:0;s:514:"YEs, I was fishing by myself on that day..what happened is that I got stood up on the previous trip and I stayed at the dock...so this time I got stood up again!!! and there was no way I was going to loose 2 days of fishing in a row LOL...so I decided to go by myself and I got lucky to get into a hot bite really close to the coast line, I was out only for 3 hours.
I always take te camera with me, but never tought about shooting video by myself, it was a lot of fun and a lot of running around!
Thx,
Fernando";}, 1608575237, 1611695275
Run Time: 0.003978
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, 4419, a:1:{i:0;s:391:"The cabo will get the job done. I have used and abused mine for two seasons(cabo 60) and the thing is still as good as new, except for the boat rash. Another good reel is the thunnus. While I am not a fan of the reel, it can catch tuna. The first time I ever used the reel and on my first cast, I landed tuna on topwater. While its not my favorite, its affordable and gets the job done.";}, 1608575237, 1611695275
Run Time: 0.004044
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, 4424, a:1:{i:0;s:103:"Hey Fernando, where's San Carlos?
flights from Dallas? more info! need yellows in my freezer!
-Brian";}, 1608575237, 1611695275
Run Time: 0.003299
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, 4439, a:1:{i:0;s:283:"Thx! I just placed my order fro the cabo 80, should last for a while if I take good care of it...I did a lot of research and the pro's are a lot more than the cons...so I guess it's worth a try.
is there a way to get an extra spool for the cabo?
Thx a lot for your replys
Fernando";}, 1608575237, 1611695275
Run Time: 0.005683
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, 4440, a:1:{i:0;s:857:"Hey Fernando, where's San Carlos?
flights from Dallas? more info! need yellows in my freezer!
-Brian
Hi lite-liner....
San CArlos is only a 4 hour drive from nogales AZ, there might be flights from dallas to Hermosillo, our state capital, if not, getting from Tucson or Nogales AZ to SC is really easy, plenty of bus lines and shuttles.
Our YT season is just starting now, today one of our boats landed 4 in a half a day trip and lost another one to a sea lion. The bigest one weighted at 32 lbs.
Our average YT are in the 20's
If you decide to try san carlos, drop me an email, I'll make sure to make things easy here.
our top water season begins in May and October is the best month, the last tournament on Oct. 4&5 had 150 billfish released, some nice dorado and a few wahoo...the tuna did not show up this year as thjey did last year.
Fernando";}, 1608575237, 1611695275
Run Time: 0.004950
SELECT data_key, data_value
FROM xf_data_registry
WHERE data_key IN ('wfc__1_thread_view')
Run Time: 0.000440
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_data_registry | const | PRIMARY | PRIMARY | 27 | const | 1 | |