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.000480
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.000239
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: 13803
Run Time: 0.000547
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: 7
Run Time: 0.000461
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: 13803
Run Time: 0.001478
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: 13803
Run Time: 0.000097
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 3945e8e0f4f29ee5494ab86dcd2a4590, , 1713608736
Run Time: 0.000253
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=13803, 1713605136,
Run Time: 0.000113
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000336
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, 201389, a:1:{i:0;s:289:"Merhabalar,yunusumdaki iç parazit tam olarak geçmedi.1tanesinin karnı tam düzelmedi.sarımsaklı yemi hergünkullansam diğer yemlerle bir sorun olur mu?yani günde 1kere sarımsaklı yem,1kere normal yemden versem nasıl olur?iç parazit olmadan da bu yemihergün kullanabilir miyiz?";}, 1572939232, 1713605136
Run Time: 0.001546
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, 201396, a:1:{i:0;s:210:"Pınar Hanım Her gün verilebilir öyle olursa daha çabuk sağlığa kavuşurlar. Veya bir öğünde biraz New Life Biraz başka yem verilebilir. Parazit olmadan da bu yem kullanılabilir Bir nevi koruyucu :)";}, 1572939232, 1713605136
Run Time: 0.001360
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, 6612, a:1:{i:0;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:12:"rgb(0, 0, 0)";s:8:"original";a:2:{i:0;s:20:"[COLOR=rgb(0, 0, 0)]";i:1;s:8:"[/COLOR]";}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: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:2:{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:2:{i:0;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:7:"Georgia";s:8:"original";a:2:{i:0;s:14:"[FONT=Georgia]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:62:"Armut Deyip Geçmeyin Onun İlk Hecesi Çoğu Kişide Yoktur..";}}i:1;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:13:"lucida grande";s:8:"original";a:2:{i:0;s:20:"[FONT=lucida grande]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:1:".";}}}}i:1;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"7";s:8:"original";a:2:{i:0;s:8:"[SIZE=7]";i:1;s:7:"[/SIZE]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:13:"lucida grande";s:8:"original";a:2:{i:0;s:20:"[FONT=lucida grande]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:14:"rgb(255, 0, 0)";s:8:"original";a:2:{i:0;s:22:"[COLOR=rgb(255, 0, 0)]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;s:25:" Necip Fazıl Kısakürek";}}}}}}}}}}}}}, 1572939232, 1713605136
Run Time: 0.001658
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, 201398, a:1:{i:0;s:88:"Teşekkür ederim.yemi Afyon'dan buldum.meğer cok yakınımdaymıs da haberim yokmuş:)";}, 1572939232, 1713605136
Run Time: 0.001342
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, 201419, a:1:{i:0;s:78:"ben sizin yerinizde olsam,sarımsaklı yem alacağıma yemi sarımsaklarım :)";}, 1572939232, 1713605136
Run Time: 0.001351
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, 201425, a:1:{i:0;s:287:"Kendi çabalarımız ile yemi sarımsaklarsak dozu tutmaz çok çabuk suyu kirletir ve çok yoğun koku oluşmasına sebep olur Ayrıca Balığı iyi edeceğim diye daha fena bir şekilde hasta edebiliriz içi yanar bilmem ne olur vs vs. En İyisi Satın Almak New Life Spectrum Thera.";}, 1572939232, 1713605136
Run Time: 0.001470
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, 201427, a:1:{i:0;s:66:"çok sık kullandığım bir method. ama tabiiki tercih meselesi..";}, 1572939232, 1713605136
Run Time: 0.001371
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, 201432, a:1:{i:0;s:130:"Sarımsaklı yem yaptım kendim ama cok uğraştırıcı oluyor.balıklarıma bir şey olmadı.tercihim hazırdan yana şimdilik .";}, 1572939232, 1713605136
Run Time: 0.001301
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, 201435, a:1:{i:0;s:52:"inşallah sağlıklarına kavuşurlar. kolaygelsin..";}, 1572939232, 1713605136
Run Time: 0.001264
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, 201447, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:37:"argento76, post: 201435, member: 7949";s:8:"original";a:2:{i:0;s:47:"[quote="argento76, post: 201435, member: 7949"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:52:"inşallah sağlıklarına kavuşurlar. kolaygelsin..";}}i:1;s:18:"
Teşekkür ederim";}, 1572939232, 1713605136
Run Time: 0.001134
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 = 13803)
LIMIT 1
Run Time: 0.000552
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: 165
Run Time: 0.000240
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.000213
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |