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.000526
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.000249
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: 21185
Run Time: 0.000522
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: 148
Run Time: 0.000485
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: 21185
Run Time: 0.009109
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | range | thread_id_post_date,thread_id_position | thread_id_position | 8 | | 20 | Using index condition; 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 (352334)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.001765
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 | 3 | 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: 21185
Run Time: 0.000125
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: da750b4490e963769df2c5dd9a6884af, , 1713567982
Run Time: 0.000236
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=21185, 1713564382,
Run Time: 0.000161
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000424
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, 350716, a:1:{i:0;s:418:"Merhaba arkadaşlar,
Kurulumum pek eski, pekte yeni sayılmayacak bir kurulum ancak mercan konusunda fakir bir deniz akvaryumum var. Su değerleri normal görünüyor ama yaşayıp yaşamayacağından emin olmadığım mercanları almak istediğimde en aşa 70-80 tl fiyat görüyorum. Ankara'da elinde ufak tefek ya da yeni fraglalardan fiyat olarak makul olabilecek mercanlar arıyorum.
Şimdiden teşekkür ederim.";}, 1572939232, 1713564382
Run Time: 0.004443
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, 350724, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:36:"Karakus, post: 350716, member: 10764";s:8:"original";a:2:{i:0;s:46:"[QUOTE="Karakus, post: 350716, member: 10764"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:418:"Merhaba arkadaşlar,
Kurulumum pek eski, pekte yeni sayılmayacak bir kurulum ancak mercan konusunda fakir bir deniz akvaryumum var. Su değerleri normal görünüyor ama yaşayıp yaşamayacağından emin olmadığım mercanları almak istediğimde en aşa 70-80 tl fiyat görüyorum. Ankara'da elinde ufak tefek ya da yeni fraglalardan fiyat olarak makul olabilecek mercanlar arıyorum.
Şimdiden teşekkür ederim.";}}i:1;s:73:"
Hairy mushroom deneyebelirsin, Bayram sonrası satışa çıkaracağım.";}, 1572939232, 1713564382
Run Time: 0.004650
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, 7680, a:1:{i:0;s:64:"Yerdeki balık mı, daldaki balık mı ? Git, gör, bekle, al...";}, 1572939232, 1713564382
Run Time: 0.003606
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, 350757, a:1:{i:0;s:13:"Takipteyim :)";}, 1572939232, 1713564382
Run Time: 0.003085
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, 350798, a:1:{i:0;s:178:"2 kafa küçük hairy mushroom birde ufak xenia hediye edeyim arkadaşım. Ankara'da nerdesiniz? Hobi paylaştıkça güzel.
iPhone 'den Tapatalk aracılığı ile gönderildi";}, 1572939232, 1713564382
Run Time: 0.003420
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, 350819, a:1:{i:0;s:86:"Çok sevinirim Halil bey. İş olarak Bahçelievlerde, ev olarak Mamak tarafındayım.";}, 1572939232, 1713564382
Run Time: 0.002590
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, 350820, a:1:{i:0;s:168:"Anladım bahçelide uzak mamak dahada uzak ben batıkent çakırlardayım bu tarafa yolunuz düşerse verebilirim.
iPhone 'den Tapatalk aracılığı ile gönderildi";}, 1572939232, 1713564382
Run Time: 0.004281
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, 350822, a:1:{i:0;s:140:"Kayınvalide o tarafta oturuyor o yüzden geliyorum o tarafa ara ara. Perşembe günü müsaitliğiniz nasıl yada bayramdan sonrası için?";}, 1572939232, 1713564382
Run Time: 0.003282
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, 350824, a:1:{i:0;s:148:"Tamam size 2 küçük kafa mushroom ve bir küçük xenia benden Perşembe günü verebilirim.
iPhone 'den Tapatalk aracılığı ile gönderildi";}, 1572939232, 1713564382
Run Time: 0.002983
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, 350825, a:1:{i:0;s:25:"ö.m atıyorum Halil bey.";}, 1572939232, 1713564382
Run Time: 0.003363
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, 350844, a:1:{i:0;s:66:"Tebrik ederim halil bey dediğiniz gibi hobi paylaştıkça güzel";}, 1572939232, 1713564382
Run Time: 0.003504
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, 350879, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:36:"Yakuppp, post: 350844, member: 10705";s:8:"original";a:2:{i:0;s:46:"[QUOTE="Yakuppp, post: 350844, member: 10705"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:66:"Tebrik ederim halil bey dediğiniz gibi hobi paylaştıkça güzel";}}i:1;s:246:"
Bizimki birşey değil bizde acemiyiz daha bu hobide bu forumda nice insanlar var hobi adına ne kadar güzel işler yapıyorlar asıl onları takdir etmek gerekir. Yinede teşekkür ederim.
iPhone 'den Tapatalk aracılığı ile gönderildi";}, 1572939232, 1713564382
Run Time: 0.002793
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, 352315, a:1:{i:0;s:110:"Suyunuzun durumu nedir ? Tankınız ne kadar zamandır kurulu ! Duruma göre bende hediye edebilirim bişeyler";}, 1572939232, 1713564382
Run Time: 0.003391
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, 8835, a:3:{i:0;a:4:{s:3:"tag";s:5:"right";s:6:"option";N;s:8:"original";a:2:{i:0;s:7:"[RIGHT]";i:1;s:8:"[/RIGHT]";}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;s:7:"By Nebi";}}}}i:1;s:1:"
";i:2;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:0:{}}}, 1572939232, 1713564382
Run Time: 0.003139
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, 352316, a:1:{i:0;s:52:"Nebi Bey el attıysa duruma Fatih yaşadın valla :)";}, 1572939232, 1713564382
Run Time: 0.002947
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, 352322, a:1:{i:0;s:317:"Nebi bey akvaryum Nisan-Mayıs civarı kuruldu. Su değerlerim iyi ancak xenia larda çözemediğim bir gariplik var açmıyorlar yada eriyip ölüyorlar :S
Akvaryumda zoa ve polip var onlarda sıkıntı yok. En son Halil bey saolsun hairy ile xenia verdi hairy iyi gibi xenia nın gözüne bakıyorum nolcak diye :D";}, 1572939232, 1713564382
Run Time: 0.002634
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, 352332, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:36:"Karakus, post: 352322, member: 10764";s:8:"original";a:2:{i:0;s:46:"[QUOTE="Karakus, post: 352322, member: 10764"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:316:"Nebi bey akvaryum Nisan-Mayıs civarı kuruldu. Su değerlerim iyi ancak xenia larda çözemediğim bir gariplik var açmıyorlar yada eriyip ölüyorlar :S
Akvaryumda zoa ve polip var onlarda sıkıntı yok. En son Halil bey saolsun hairy ile xenia verdi hairy iyi gibi xenia nın gözüne bakıyorum nolcak diye :D";}}i:1;s:118:"
Xenia ilginc bir canlidır her şeyi tam olan tankta bile bakarsınız açmayan veya ölen tek canlı xenia olmustur.";}, 1572939232, 1713564382
Run Time: 0.004390
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, 352334, a:6:{i:0;s:27:"Genel görüntü böyle.
";i:1;a:4:{s:3:"tag";s:6:"attach";s:6:"option";s:4:"full";s:8:"original";a:2:{i:0;s:13:"[ATTACH=full]";i:1;s:9:"[/ATTACH]";}s:8:"children";a:1:{i:0;s:5:"29961";}}i:2;s:1:" ";i:3;a:4:{s:3:"tag";s:6:"attach";s:6:"option";s:4:"full";s:8:"original";a:2:{i:0;s:13:"[ATTACH=full]";i:1;s:9:"[/ATTACH]";}s:8:"children";a:1:{i:0;s:5:"29962";}}i:4;s:1:" ";i:5;a:4:{s:3:"tag";s:6:"attach";s:6:"option";s:4:"full";s:8:"original";a:2:{i:0;s:13:"[ATTACH=full]";i:1;s:9:"[/ATTACH]";}s:8:"children";a:1:{i:0;s:5:"29963";}}}, 1572939232, 1713564382
Run Time: 0.003451
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, 352335, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:34:"veysel, post: 352332, member: 6836";s:8:"original";a:2:{i:0;s:44:"[QUOTE="veysel, post: 352332, member: 6836"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:117:"Xenia ilginc bir canlidır her şeyi tam olan tankta bile bakarsınız açmayan veya ölen tek canlı xenia olmustur.";}}i:1;s:82:"
Ya da herşeyin ölüp açmadığı suda canavar gibi olurlar :D Tamamen şans :)";}, 1572939232, 1713564382
Run Time: 0.002591
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, 8887, a:1:{i:0;s:11:"Soft Garden";}, 1572939232, 1713564382
Run Time: 0.002248
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, 352349, a:1:{i:0;s:124:"Mushroomlar toparlıyor ama xenia henüz bir faaliyette değil gibi :(
iPhone 'den Tapatalk aracılığı ile gönderildi";}, 1572939232, 1713564382
Run Time: 0.002661
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, 352356, a:1:{i:0;s:31:"İnşallah erimeden toparlar :(";}, 1572939232, 1713564382
Run Time: 0.002432
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, 352370, a:1:{i:0;s:66:"Tamam etimesgut tarafına geçtiğinizde haberleşelim.
By Nebi";}, 1572939232, 1713564382
Run Time: 0.002603
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 = 21185)
LIMIT 1
Run Time: 0.000560
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: 184
Run Time: 0.000254
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |