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.000549
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.000219
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: 15835
Run Time: 0.000444
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: 32
Run Time: 0.000440
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: 15835
Run Time: 0.004101
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 | 20 | 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 |
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 (245227)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000399
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 1 | Using index condition |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | bizimled_db.attachment.data_id | 1 | |
INSERT INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 15835
Run Time: 0.000103
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: ab69546389ba0847e5e64af520338350, , 1711731201
Run Time: 0.000196
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=15835, 1711727601,
Run Time: 0.000147
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000299
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, 245227, a:2:{i:0;s:80:"Bu sıralar amcamların evde bir şeyler değişti nasıl sizce eksik var mi?
";i:1;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:62:"http://www.akvaryumportali.com/attachments/cam00096-jpg.11586/";}}}, 1572939232, 1711727601
Run Time: 0.002018
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, 245230, a:1:{i:0;s:49:"Akvaryum tam görünmüyor kaç köşe acaba...:D";}, 1572939232, 1711727601
Run Time: 0.001189
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, 7159, a:1:{i:0;a:4:{s:3:"tag";s:3:"img";s:6:"option";N;s:8:"original";a:2:{i:0;s:5:"[IMG]";i:1;s:6:"[/IMG]";}s:8:"children";a:1:{i:0;s:34:"http://i.hizliresim.com/25yjPL.jpg";}}}, 1572939232, 1711727601
Run Time: 0.001670
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, 245231, a:1:{i:0;s:21:"Saolunun ust 2 si abi";}, 1572939232, 1711727601
Run Time: 0.001180
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, 245249, a:1:{i:0;s:129:"Murat kardeşim şöyle önden bir fotoğraf koysan ve tank hakkında bilgi versen daha iyi olur böyle pek birşey anlayamadık.";}, 1572939232, 1711727601
Run Time: 0.001135
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, 245257, a:1:{i:0;s:615:"Abi akvaryum amcamlarda ama akvaryumun bakmı her şeyi bana ait ksaca benden para cıkmıyor amcam emekli deniz subayı denizlere hayran o yuzden böyle bir şey yaptık çok ani oldu şöyle veriyim bilgileri 150*50*h75 hiç deniz akvaryumu kurmadım ama bu mazemelerin iyi oldugunu düşünüyorum bu arada camın kalınlığı 20mm
Elimde olan malzemeler:
schuran 120 ps
70 cm - 70 Watt led armatür
redsea coral pro kova tuz
kum ise mercan kırığı yaklaşık 30-40-50 kg var ölçmedim :D
yüzen kaya 30 kg
ve haftada en az % 30-25 arası su değişimi olacak başka her hangi bir sorunuz varsa alabilirim.";}, 1572939232, 1711727601
Run Time: 0.001062
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, 245270, a:1:{i:0;s:96:"Murat akvaryumu kuralı ne kadar oldu?
Mercan göremedim sadece balık mı besleyeceksiniz... :)";}, 1572939232, 1711727601
Run Time: 0.000992
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, 245274, a:1:{i:0;s:114:"İnternetten sipariş verildi en geç 1 hafta içinde gelecek akıvaryum proje 1ay önce vardı ortlama 2-3 hafta.";}, 1572939232, 1711727601
Run Time: 0.001150
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, 245276, a:1:{i:0;s:236:"Murat kurulumun hayırlı olsun.
Bu yükseklikte led armatürle mercan olayı biraz zor.Fazla ışık tercih etmeyen türler seçilmesi gerekir.Almadan önce danışırsan daha iyi olur.Bence güzel bir marine tank olur bu ölçülerde.";}, 1572939232, 1711727601
Run Time: 0.001046
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, 7575, a:1:{i:0;s:47:"180X120X60 Resif Tankı
100X60X55 Marine Tankı";}, 1572939232, 1711727601
Run Time: 0.001488
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, 245280, a:1:{i:0;s:47:":D Sağ ol abi mercan daha almadım ne alayım.";}, 1572939232, 1711727601
Run Time: 0.001084
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, 245326, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:36:"murat064, post: 245280, member: 9000";s:8:"original";a:2:{i:0;s:46:"[quote="murat064, post: 245280, member: 9000"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:43:":D saol abi mercan daha almadım ne alyımm";}}i:1;s:229:"
Öncelikle hayırlı olsun kurulum. Güzel bir kaç bakımı kolay olan mercanlardan mushroom, zoa, düğme polipler v.s. başlayabilirsin. Temizlik ekibi var mı? Bu arada yoksa öncelikle onları edin derim. Snail, conch gibi.";}, 1572939232, 1711727601
Run Time: 0.001464
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, 245329, a:1:{i:0;s:155:"Yaklaşık 550 lt gibi bir su hacminiz var....Bence hiçbirşey almayın,önce PS inizi kuvvetlendirin.Kalp çalışmazsa sistem çöker...Hayırlı olsun";}, 1572939232, 1711727601
Run Time: 0.001049
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, 1378, a:1:{i:0;s:13:"Ozan Gürçay";}, 1572939232, 1711727601
Run Time: 0.001177
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, 245336, a:1:{i:0;s:63:"Sağ ol Veysel abi, dediklerinden siparişi verdim 2 şer tane.";}, 1572939232, 1711727601
Run Time: 0.001431
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, 245356, a:5:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:36:"murat064, post: 245336, member: 9000";s:8:"original";a:2:{i:0;s:46:"[quote="murat064, post: 245336, member: 9000"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:56:"Saol veysek abi dedikletinden siparisi verdem 2 ser tane";}}i:1;s:1:"
";i:2;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:36:"murat064, post: 245336, member: 9000";s:8:"original";a:2:{i:0;s:46:"[quote="murat064, post: 245336, member: 9000"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:63:"Sağ ol Veysel abi, dediklerinden siparişi verdim 2 şer tane.";}}i:3;s:88:"
Murat yazdıklarını göndermeden bir kontrol edip gönder, acele etme derim...temo2
";i:4;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:104:"http://www.akvaryumportali.com/threads/%C4%B0mla-konusunda-yard%C4%B1m-alman%C4%B1z-%C4%B0%C3%A7in.8071/";s:8:"original";a:2:{i:0;s:112:"[URL='http://www.akvaryumportali.com/threads/%C4%B0mla-konusunda-yard%C4%B1m-alman%C4%B1z-%C4%B0%C3%A7in.8071/']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:59:"İmla Konusunda Yardım Almanız İçin | Akvaryum Portalı";}}}, 1572939232, 1711727601
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: post, 245372, a:2:{i:0;s:16:"Kusra bakma abi
";i:1;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:37:"Alparslan, post: 245356, member: 7159";s:8:"original";a:2:{i:0;s:47:"[quote="Alparslan, post: 245356, member: 7159"]";i:1;s:8:"[/quote]";}s:8:"children";a:2:{i:0;s:87:"Murat yazdıklarını göndermeden bir kontrol edip gönder, acele etme derim...temo2
";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:104:"http://www.akvaryumportali.com/threads/%C4%B0mla-konusunda-yard%C4%B1m-alman%C4%B1z-%C4%B0%C3%A7in.8071/";s:8:"original";a:2:{i:0;s:112:"[URL='http://www.akvaryumportali.com/threads/%C4%B0mla-konusunda-yard%C4%B1m-alman%C4%B1z-%C4%B0%C3%A7in.8071/']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:59:"İmla Konusunda Yardım Almanız İçin | Akvaryum Portalı";}}}}}, 1572939232, 1711727601
Run Time: 0.001202
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, 245604, a:1:{i:0;s:92:"Arkadaşım tank'a Biraz Fazla Yüklenmissin Gibi Geliyor . Biraz Hafifletmende Fayda Var...";}, 1572939232, 1711727601
Run Time: 0.001087
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, 245612, a:1:{i:0;s:83:"Fazlami su koymadan cam kaya kum ortalama 300kgfln su ile 700 800 kg gibi degisiyor";}, 1572939232, 1711727601
Run Time: 0.001207
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, 245658, a:1:{i:0;s:62:"Benim anlatmak istediğim kayalara biraz fazla yuklenmissin :)";}, 1572939232, 1711727601
Run Time: 0.001289
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, 249880, a:1:{i:0;s:67:"Murat ne oldu tank ne durumda değişti mi olduğu gibi duruyor mu?";}, 1572939232, 1711727601
Run Time: 0.001276
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, 250612, a:1:{i:0;s:127:"Biraz oldu kayalar azaldı mercan vs çoğaldı balık durumu 1 çift siyah palyaço 1 çift normal palyaço var şakada yok :D";}, 1572939232, 1711727601
Run Time: 0.001125
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, 250621, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:36:"murat064, post: 250612, member: 9000";s:8:"original";a:2:{i:0;s:46:"[quote="murat064, post: 250612, member: 9000"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:127:"Biraz oldu kayalar azaldı mercan vs çoğaldı balık durumu 1 çift siyah palyaço 1 çift normal palyaço var şakada yok :D";}}i:1;s:48:"
Foto video at palyaçoları görelim Murat...:)";}, 1572939232, 1711727601
Run Time: 0.001841
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 = 15835)
LIMIT 1
Run Time: 0.000461
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: 31
Run Time: 0.000174
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |