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.000469
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.000175
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: 1075
Run Time: 0.000408
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: 95
Run Time: 0.000425
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: 1075
Run Time: 0.001327
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 | 9 | Using where; Using filesort |
SIMPLE | bb_code_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,bizimled_db.post.post_id | 1 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | bizimled_db.post.user_id | 1 | |
SIMPLE | user_profile | eq_ref | PRIMARY | PRIMARY | 4 | bizimled_db.post.user_id | 1 | |
SIMPLE | user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | bizimled_db.post.user_id | 1 | |
SIMPLE | signature_parse_cache | eq_ref | content_type_id | content_type_id | 31 | const,bizimled_db.post.user_id | 1 | Using where |
SIMPLE | session_activity | eq_ref | PRIMARY | PRIMARY | 22 | bizimled_db.post.user_id,func | 1 | Using where |
INSERT INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 1075
Run Time: 0.000074
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 2ce55d1072462e5d8ee1894ebb7c06aa, , 1713593071
Run Time: 0.000188
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=1075, 1713589471,
Run Time: 0.000089
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000234
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_widget | ALL | | | | | 16 | Using where; Using filesort |
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, 14601, a:33:{i:0;s:104:"Size bu sıralar merak saldığım elongatus varyetelerinin Yabancı bir siteden çeşitlerini buldum,
";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:71:"http://www.malawi-dream.info/Pseudotropheus_sp_elongatus_bee_Chirwa.htm";}}i:2;s:1:"
";i:3;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:69:"http://www.malawi-dream.info/Pseudotropheus_sp_elongatus_chailosi.htm";}}i:4;s:1:"
";i:5;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:69:"http://www.malawi-dream.info/Pseudotropheus_sp_elongatus_chitimba.htm";}}i:6;s:1:"
";i:7;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:71:"http://www.malawi-dream.info/Pseudotropheus_sp_elongatus_linganjala.htm";}}i:8;s:1:"
";i:9;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:86:"http://www.malawi-dream.info/Pseudotropheus_sp_elongatus_liutche-elongatus_Liutche.htm";}}i:10;s:1:"
";i:11;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:67:"http://www.malawi-dream.info/Pseudotropheus_sp_elongatus_mpanga.htm";}}i:12;s:2:"
";i:13;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:79:"http://www.malawi-dream.info/Pseudotropheus_sp_elongatus_neon_spot_Hai_Reef.htm";}}i:14;s:1:"
";i:15;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:77:"http://www.malawi-dream.info/Pseudotropheus_sp_elongatus_neon_spot_Ruarwe.htm";}}i:16;s:1:"
";i:17;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:85:"http://www.malawi-dream.info/Pseudotropheus_sp_elongatus_neon_spot_Ungi-neon_spot.htm";}}i:18;s:1:"
";i:19;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:75:"http://www.malawi-dream.info/Pseudotropheus_sp_elongatus_ornatus_Likoma.htm";}}i:20;s:1:"
";i:21;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:83:"http://www.malawi-dream.info/Pseudotropheus_sp_elongatus_ornatus_tanzanie_Chuwa.htm";}}i:22;s:1:"
";i:23;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:83:"http://www.malawi-dream.info/Pseudotropheus_sp_elongatus_slab_Nakantenga_Island.htm";}}i:24;s:1:"
";i:25;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:92:"http://www.malawi-dream.info/Pseudotropheus_sp_elongatus_slab_Thumbi_West-elongatus_slab.htm";}}i:26;s:1:"
";i:27;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:84:"http://www.malawi-dream.info/Pseudotropheus_sp_elongatus_Usisya-elongatus_Usisya.htm";}}i:28;s:1:"
";i:29;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:72:"http://www.malawi-dream.info/Pseudotropheus_sp_elongatus_yellow_tail.htm";}}i:30;s:1:"
";i:31;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:48:"http://www.gcca.net/fom/Pseudotropheus_polit.htm";}}i:32;s:57:"
Nasıl türler ama ben artık bunların hastası oldum.";}, 1572939232, 1713589471
Run Time: 0.002358
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: signature, 281, a:1:{i:0;s:24:"Afra hara ,cobue,chewere";}, 1572939232, 1713589471
Run Time: 0.001265
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, 14602, a:1:{i:0;s:300:"Nurullah hocam, ekleyin, tanıtın farklı türleri. em34: Ellerinize sağlık. Artık hobiye farklı türler girsin hocam. Gelişem,iyoruz yoksa, dikkat ediyorum platformlar sarı prenses üzerine, açılalım diyorum artık. Tabi esnafımızın farklı türleri getirmesi gerek artık.
Saygılar...";}, 1572939232, 1713589471
Run Time: 0.001186
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, 14603, a:7:{i:0;s:151:":) :)
Elangotus ürettim ettim ancak satmak zor oldu :)
Hatta şimdi üretimi bitirdiğim için damızlıklarıda satıyorum.
Benim ürettiklerim;
";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:83:"http://www.malawi-dream.info/Pseudotropheus_sp_elongatus_ornatus_tanzanie_Chuwa.htm";}}i:2;s:2:"
";i:3;a:4:{s:3:"tag";s:6:"center";s:6:"option";N;s:8:"original";a:2:{i:0;s:8:"[center]";i:1;s:9:"[/center]";}s:8:"children";a:1:{i:0;s:6:"Ya da ";}}i:4;s:3:"
";i:5;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:75:"http://www.malawi-dream.info/Pseudotropheus_sp_elongatus_ornatus_Likoma.htm";}}i:6;s:44:"
Hangisi oldugunu tam bende kestiremiyorum.";}, 1572939232, 1713589471
Run Time: 0.001373
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: signature, 9, a:1:{i:0;a:4:{s:3:"tag";s:6:"center";s:6:"option";N;s:8:"original";a:2:{i:0;s:8:"[CENTER]";i:1;s:9:"[/CENTER]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[B]";i:1;s:4:"[/B]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"5";s:8:"original";a:2:{i:0;s:8:"[SIZE=5]";i:1;s:7:"[/SIZE]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:1:"u";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[U]";i:1;s:4:"[/U]";}s:8:"children";a:1:{i:0;s:17:"TEKRARDAN DİSCUS";}}}}}}}}}, 1572939232, 1713589471
Run Time: 0.001405
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, 14604, a:1:{i:0;s:630:"Tabi Temel abim Valla öyle Tamam Yunus sarı iyi güzelde malawi bir tek bunlardan oluşmuyorki,ilk bakmak için ve acemiliği atmak için iyi yunus ve sarı,ama sonrasında her bir farklı balığa terfi etmek çok güzel bir duygu hele bu elongatuslar yokmu inanın çok farklı bir yapıları var ciklet'te ilk besleyene tavsiye etmem ama biraz tecrübe kazandıktan sonra mükemmel bir göz zevki
Can kardeşim tabiki benimki hobici gözüyle üretici gözüyle yunus sarı kadar piyasada satılmıyor olabilir,ama ben artık show akvaryumu Şöyle 200 cmlik bir tank kurmadıktan sonra yunus sarı bitmiştir benim için.";}, 1572939232, 1713589471
Run Time: 0.000919
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, 14605, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:4:"swat";s:8:"original";a:2:{i:0;s:13:"[quote=swat ]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:632:"
Tabi Temel abim Valla öyle Tamam Yunus sarı iyi güzelde malawi bir tek bunlardan oluşmuyorki,ilk bakmak için ve acemiliği atmak için iyi yunus ve sarı,ama sonrasında her bir farklı balığa terfi etmek çok güzel bir duygu hele bu elongatuslar yokmu inanın çok farklı bir yapıları var ciklet'te ilk besleyene tavsiye etmem ama biraz tecrübe kazandıktan sonra mükemmel bir göz zevki
Can kardeşim tabiki benimki hobici gözüyle üretici gözüyle yunus sarı kadar piyasada satılmıyor olabilir,ama ben artık show akvaryumu Şöyle 200 cmlik bir tank kurmadıktan sonra yunus sarı bitmiştir benim için.
";}}i:1;s:395:"
Açıkçası sp,yunus,bp,ahli vs bu balıklar çoktan bitti.Her ne kadar forumlardaki satış ilanlarında arkadaşlar fiyat konusunda uçsada sadece uçtukları ile kalıyorlar.Hatta Frontosa brundi de bitti.Eskiden 10-15cm frontosa kaç para satılıyordu şimdi 25ytlye satabilen tabiri caizse göbet atıyor.
Tanganyika türlerinde Tropheus , Malawide ise pseudotropheus türleri revaçta.";}, 1572939232, 1713589471
Run Time: 0.001240
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, 14606, a:1:{i:0;s:170:"Nurullah abi,eline koluna sağlık.Bir aralart bende bunlara kafaya takmıştım.Dişilerinin genelde gri renkte olması için vazgeçmiştim.Bu arada abi hani Afra cobeu";}, 1572939232, 1713589471
Run Time: 0.001074
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: signature, 23, a:1:{i:0;a:4:{s:3:"tag";s:6:"center";s:6:"option";N;s:8:"original";a:2:{i:0;s:8:"[center]";i:1;s:9:"[/center]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:1:"i";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[I]";i:1;s:4:"[/I]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"4";s:8:"original";a:2:{i:0;s:10:"[SIZE="4"]";i:1;s:7:"[/SIZE]";}s:8:"children";a:1:{i:0;s:25:"Sadece ve sadece MBUNA...";}}}}}}}, 1572939232, 1713589471
Run Time: 0.001269
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, 14607, a:1:{i:0;s:138:"Paylaşım için teşekkürler.Fakat eksiklikler var.Şu an Türkiye'de de popüler olan chewere yok.Birde sondaki polit fazlalık olmuş.";}, 1572939232, 1713589471
Run Time: 0.000919
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: signature, 241, a:1:{i:0;s:10:"Barış Er";}, 1572939232, 1713589471
Run Time: 0.001076
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, 14608, a:2:{i:0;a:4:{s:3:"tag";s:3:"url";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[url]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:50:"http://aquatab.net/clanky/pestirna-pro-21-stoleti/";}}i:1;s:167:"
Peki barış kardeş chewere burda var ama adamın özellikle üretimhanesini görün diye bu linki verdim pırıl pırıl yaptınmı böyle yapacaksın bu işi :)";}, 1572939232, 1713589471
Run Time: 0.000972
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, 14609, a:1:{i:0;s:44:"Gerçekten enfes aynen size katılıyorum...";}, 1572939232, 1713589471
Run Time: 0.001150
SELECT node.*, forum.*
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
INNER JOIN xf_thread AS thread ON
(thread.node_id = forum.node_id)
WHERE (thread.thread_id = 1075)
LIMIT 1
Run Time: 0.000417
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | const | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post | PRIMARY | 4 | const | 1 | |
SIMPLE | forum | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT node.*
FROM xf_node AS node
WHERE node.node_id = ?
Params: 166
Run Time: 0.000160
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT node.*
FROM xf_node AS node
WHERE node.node_id = ?
Params: 3
Run Time: 0.000142
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |