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.000468
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.000183
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: 900
Run Time: 0.000454
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: 96
Run Time: 0.000397
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: 900
Run Time: 0.001205
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 | 6 | 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: 900
Run Time: 0.000083
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 813dda50c6597d95cb7c44907425bc2f, , 1713563625
Run Time: 0.000200
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=900, 1713560025,
Run Time: 0.000111
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000265
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, 10900, a:12:{i:0;s:407:"İki gün önce erkek bettayı dişi bettanın bulunduğu akvaryuma aldım(iki bölümlü). İki gündür erkek köpük yapmadı. Dün akşam dişinin köpük yapıp kendi yumurtalarını köpüğün içerisine yerleştirdiğini gördüm. Büyük bir ihtimal yumurtalar döllenmediği için yavru çıkmaycaktır. Ama yinede yerlerini değiştirip, erkek bettayı yumurtaların bulunduğu bölüme aldım.
";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:20:"http://imageshack.us";s:8:"original";a:2:{i:0;s:26:"[URL=http://imageshack.us]";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:55:"http://img224.imageshack.us/img224/2715/82087584ua4.png";}}}}i:2;s:1:"
";i:3;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:48:"http://g.imageshack.us/img224/82087584ua4.png/1/";s:8:"original";a:2:{i:0;s:54:"[URL=http://g.imageshack.us/img224/82087584ua4.png/1/]";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:61:"http://img224.imageshack.us/img224/82087584ua4.png/1/w320.png";}}}}i:4;s:2:"
";i:5;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:20:"http://imageshack.us";s:8:"original";a:2:{i:0;s:26:"[URL=http://imageshack.us]";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:55:"http://img512.imageshack.us/img512/1434/44808726gl2.png";}}}}i:6;s:1:"
";i:7;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:48:"http://g.imageshack.us/img512/44808726gl2.png/1/";s:8:"original";a:2:{i:0;s:54:"[URL=http://g.imageshack.us/img512/44808726gl2.png/1/]";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:61:"http://img512.imageshack.us/img512/44808726gl2.png/1/w320.png";}}}}i:8;s:2:"
";i:9;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:20:"http://imageshack.us";s:8:"original";a:2:{i:0;s:26:"[URL=http://imageshack.us]";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:55:"http://img266.imageshack.us/img266/3449/51070810wv0.png";}}}}i:10;s:1:"
";i:11;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:48:"http://g.imageshack.us/img266/51070810wv0.png/1/";s:8:"original";a:2:{i:0;s:54:"[URL=http://g.imageshack.us/img266/51070810wv0.png/1/]";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:61:"http://img266.imageshack.us/img266/51070810wv0.png/1/w640.png";}}}}}, 1572939232, 1713560025
Run Time: 0.001989
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, 28, a:1:{i:0;s:43:"Muhammed Ali TAVUR - Büyükada / İstanbul";}, 1572939232, 1713560025
Run Time: 0.001331
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, 10901, a:1:{i:0;s:209:"İyi yapmışsın Muhammed, önümüzdeki bir kaç gün gözlem yaparsan daha iyi bir fikir sahibi olabilir ve duruma göre hareket edersin.
Umarım sağlıklı bir yavru alma sürecine girersin.
Saygılar...";}, 1572939232, 1713560025
Run Time: 0.001679
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, 10902, a:1:{i:0;s:460:"Sağolasın abi, ama yavruların çıkacağını zannetmiyorum. Bettaları göndermek için bahane arıyordum :D büyük akvaryum getirmek için, aradığım bahaneyi buldum galiba 3 aylık bekleme sürecinde dişinin emekleri boşa gitti. Seninde dediğin gibi bir kaç gün daha gözetlerim. Bir arkadaşımda 5 adet erkek vardı. Onun üretim tecrübesi hiç olmamış, bri ara sözü geçmişte sana dişi veririm diye, bir sonuç alamazsam ona vereceğim.";}, 1572939232, 1713560025
Run Time: 0.000995
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, 10903, a:1:{i:0;s:146:"Hayırlısı olsun artık, elbette karar senindir. Hobiden zevk alınacak bir çok tür var. Bu türlerden yeni bir akvaryum kurabilirsin elbette.";}, 1572939232, 1713560025
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, 10904, a:1:{i:0;s:486:"Bettayı hep sevmişimdir. Daha önceki tecrübelerimde yavruda almıştım. Hatta büyütüp akvaryumcudan bitki ve yem olarak takasa vermiştim :) . Yer sıkıntısı olduğu için o akvaryuma kaldırmam lazım 50 cm lik bir akvaryum onun yerine 90*60*40 gibi bişey yaptırmayı düşünüyorum. Orda da kısmet olursa discus beslerim diyorum yada ciklet. Ama bu bettaların peşini bırakmayacağım arkadaşım akvaryumunu da kontrol altına alırım birlikte bişeyler yaparız :D";}, 1572939232, 1713560025
Run Time: 0.001843
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, 10905, a:1:{i:0;s:116:"Erkeğin formsuz anlamına geliyor bu. % 99 yumurtalar çıkmazve erkek o yuvayı dağıtacaktır büyük ihtimalle.";}, 1572939232, 1713560025
Run Time: 0.001695
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 = 900)
LIMIT 1
Run Time: 0.000716
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: 98
Run Time: 0.000346
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: 166
Run Time: 0.000355
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.000237
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |