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.000554
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.000209
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: 8025
Run Time: 0.000489
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: 6
Run Time: 0.000742
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: 8025
Run Time: 0.003511
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 | 5 | 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: 8025
Run Time: 0.000107
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 5f0ddff9299a11c6991723300728eea0, a:8:{s:12:"sessionStart";i:1711704106;s:2:"ip";s:4:"_'";s:11:"sessionCsrf";s:16:"byVeCTRUEXAWyxXD";s:9:"userAgent";s:9:"claudebot";s:7:"robotId";s:0:"";s:16:"previousActivity";i:0;s:10:"isIpBanned";a:2:{s:6:"result";b:0;s:7:"version";i:1572939125;}s:15:"isIpDiscouraged";a:2:{s:6:"result";b:0;s:7:"version";i:1572939125;}}, 1711707706
Run Time: 0.000238
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=8025, 1711704106,
Run Time: 0.000192
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000359
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, 93693, a:9:{i:0;s:387:"Arkadaşlar yeni kurduğum akvaryumdan birkaç fotoğraf paylaşmak istedim.. Görüşlerinizi alabilir miyim? Akvaryum dekoru sizce nasıl ? Akvaryumum 350 litre. İçinde şu an 5 tane Sarı Prenses var ama ileride Yunus almayı düşünüyorum. Aydınlatma çok az ışık veren bir lambam var. Sarı Prenseslerim daha 3-4 cm ler. Akvaryumda yeni oldukları için saklanıyorlar.
";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:43:"http://ap-depo.com/share-D8C5_4D49A4E7.html";s:8:"original";a:2:{i:0;s:49:"[url=http://ap-depo.com/share-D8C5_4D49A4E7.html]";i:1;s:6:"[/url]";}s:8:"children";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:42:"http://ap-depo.com/image-D8C5_4D49A4E7.jpg";}}}}i:2;s:4:"
";i:3;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:43:"http://ap-depo.com/share-BEC0_4D49A5B6.html";s:8:"original";a:2:{i:0;s:49:"[url=http://ap-depo.com/share-BEC0_4D49A5B6.html]";i:1;s:6:"[/url]";}s:8:"children";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:42:"http://ap-depo.com/image-BEC0_4D49A5B6.jpg";}}}}i:4;s:4:"
";i:5;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:43:"http://ap-depo.com/share-5118_4D49A638.html";s:8:"original";a:2:{i:0;s:49:"[url=http://ap-depo.com/share-5118_4D49A638.html]";i:1;s:6:"[/url]";}s:8:"children";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:42:"http://ap-depo.com/image-5118_4D49A638.jpg";}}}}i:6;s:4:"
";i:7;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:43:"http://ap-depo.com/share-5118_4D49A638.html";s:8:"original";a:2:{i:0;s:49:"[url=http://ap-depo.com/share-5118_4D49A638.html]";i:1;s:6:"[/url]";}s:8:"children";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:42:"http://ap-depo.com/image-5118_4D49A638.jpg";}}}}i:8;s:58:"
:nazar::nazar::nazar::nazar::nazar::nazar::nazar::nazar:";}, 1572939232, 1711704106
Run Time: 0.001873
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, 4766, a:1:{i:0;s:35:"Burak Özgür
350 lt. Sarı Prenses";}, 1572939232, 1711704106
Run Time: 0.002050
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, 93694, a:2:{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:24:"Cevap: Malavi Akvaryumum";}}i:1;s:311:"
Burak akvaryum tanıtımına akvaryumun genel ekipman, hacim, balık türleri, yemler hakkında, kullanılan su hakkında, aydınlatması hakkında en küçük bir bilgi vermemişsin. Bunları güzelce sıralarsan konu başına ekleriz.
Arka fon olmayışı iyi olmamış ve aydınlatma sorunun var galiba.";}, 1572939232, 1711704106
Run Time: 0.001993
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, 93695, a:2:{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:24:"Cevap: Malavi Akvaryumum";}}i:1;s:243:"
Akvaryumum 350 litre. İçinde şu an 5 tane Sarı Prenses var ama ileride Yunus almayı düşünüyorum. Aydınlatma çok az ışık veren bir lambam var.
Sarı Prenseslerim daha 3-4 cm ler. Akvaryumda yeni oldukları için saklanıyorlar.";}, 1572939232, 1711704106
Run Time: 0.002149
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, 93696, a:2:{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:24:"Cevap: Malavi Akvaryumum";}}i:1;s:146:"
Bence içindeki mercanı çıkarın balıklar sürtünüp zarar görmesin.Birde su çok bulanık gibi filtre ve ısıtıcı ne kullanıyorsunuz.";}, 1572939232, 1711704106
Run Time: 0.001390
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, 4072, a:1:{i:0;s:83:"Ne kadar değişirsen değiş, Nerede mutlu olduysan hep oraya çevirirsin kafanı.";}, 1572939232, 1711704106
Run Time: 0.001577
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, 93697, a:2:{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:24:"Cevap: Malavi Akvaryumum";}}i:1;s:205:"
Bana kalırsa tüm dekorları kaldırın kum hariç tabi :) ufak en fazla yumruk kadar büyüklükte kayalıkları 2 köşeyede dizin ve üst üste bırakın ortasıda boş olsun bence öyle güzel olur.";}, 1572939232, 1711704106
Run Time: 0.001460
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, 5511, a:1:{i:0;s:47:"Suskunluğum korkumdan değil asaletimdendir...";}, 1572939232, 1711704106
Run Time: 0.001428
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 = 8025)
LIMIT 1
Run Time: 0.000698
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.000245
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.000247
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |