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.000481
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_data_registry | range | PRIMARY | PRIMARY | 27 | | 26 | Using where |
SELECT session_data
FROM xf_session
WHERE session_id = ?
AND expiry_date >= ?
Params: da6cad1d2d8bc36fd3fcd656cfcb37f6, 1716088554
Run Time: 0.000222
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_session | const | PRIMARY,expiry_date | PRIMARY | 34 | const | 1 | |
SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000191
| 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: 5938
Run Time: 0.000425
| 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: 106
Run Time: 0.000378
| 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 ASCParams: 5938
Run Time: 0.003576
| 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 | 10 | 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: 5938
Run Time: 0.000079
UPDATE `xf_session` SET `expiry_date` = ? WHERE (session_id = 'da6cad1d2d8bc36fd3fcd656cfcb37f6')
Params: 1716092154
Run Time: 0.000210
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=5938, 1716088554,
Run Time: 0.000104
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000251
| 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, 63519, a:6:{i:0;s:511:"Genel konu görüntüleme ayarı:
Aşağıdaki fotoğraflarda profil ve forum seçeneklerinizi ayarlama yolu bulunmaktadır. Bu kısımlardan yapacağınız ayarlar görüntüleme şeklinizi belirleyecektir. Forum eylemleri - seçenekleri düzenle kısmından konu ve mesaj gösterimi ayar kısmından eğer ' Normal Eski Mesajlar önce ' olarak ayarlarsanız yazacağınız mesaj konunun sonuna eklenecektir. Bu ayar alışık olduğumuz ayardır. Ayarlara ulaşma yolu foroğraflarda gösterilmiştir.
1.) ";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:34:"http://i43.tinypic.com/29zbuhf.jpg";}}i:2;s:6:"
2.) ";i:3;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:33:"http://i40.tinypic.com/o9re6f.jpg";}}i:4;s:6:"
3.) ";i:5;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://i41.tinypic.com/2mdl1s5.jpg";}}}, 1572939232, 1716088554
Run Time: 0.001706
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, 63520, a:1:{i:0;s:51:"Teşekkür ederim Temel abi. Güzel bi anlatım. :)";}, 1572939232, 1716088554
Run Time: 0.001295
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, 4243, a:1:{i:0;s:97:"İncecik ip üzerine koca ayaklar bindi, kirpiklerim titrer korkularımdan düşersem yanarım...";}, 1572939232, 1716088554
Run Time: 0.001164
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, 63521, a:1:{i:0;s:26:"Teşekkürler Temel hocam.";}, 1572939232, 1716088554
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: signature, 2106, a:1:{i:0;a:4:{s:3:"tag";s:6:"indent";s:6:"option";N;s:8:"original";a:2:{i:0;s:8:"[INDENT]";i:1;s:9:"[/INDENT]";}s:8:"children";a:1:{i:0;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:1:{i:0;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#ff0000";s:8:"original";a:2:{i:0;s:15:"[COLOR=#ff0000]";i:1;s:8:"[/COLOR]";}s:8:"children";a:5:{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:1:{i:0;s:20:"Yavuz Kaçar AB rh +";}}}}i:1;s:1:"
";i:2;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:1:{i:0;s:36:"90*50*50 Sump Sistem Hafif Bitkili. ";}}}}i:3;s:1:"
";i:4;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:1:{i:0;s:34:"Hayvan Sever. Doğayı Sev ve Koru";}}}}}}}}}}}, 1572939232, 1716088554
Run Time: 0.001295
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, 63522, a:1:{i:0;s:583:"Bilgilendirme için teşekkürler,
Erman bey için hatırlatma:
Yeni mesajlar menüsünde sizin kullanıcı isminiz ile ilgili problemin benzeri @Tanganyika_Lake için farklı biçimde geçerlidir,bu kullanıcınınismi hiç görünmemektedir.
Tahminim karakter sayısı ile ilgili olmakla birlikte,benim sistemim ve tarayıcıma özel de olabilir,şu an ubuntu dan yazıyorum ve boş görünüyor ama dün akşam pardus ile isim görünüyor buton görünmüyordu.
Windows kullanan arkadaşlarda da bu sorun varsa bildirmelerini rica ederim,bana özel ise boşuna meşgul etmeyelim.";}, 1572939232, 1716088554
Run Time: 0.001268
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, 2915, a:1:{i:0;s:32:"Bitkili,dipte gezenler akvaryumu";}, 1572939232, 1716088554
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, 63523, a:1:{i:0;s:129:"Mozilla ve İE uzun karakterler olduğu için son mesaj ikonu görünmüyor. İsim görüntülemede sıkıntı yok Serdar abi....";}, 1572939232, 1716088554
Run Time: 0.001063
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, 63524, a:8:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:18:"murer, post: 63523";s:8:"original";a:2:{i:0;s:28:"[quote="murer, post: 63523"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:129:"Mozilla ve İE uzun karakterler olduğu için son mesaj ikonu görünmüyor. İsim görüntülemede sıkıntı yok Serdar abi....";}}i:1;s:148:"
Ben şu anda işletim sistemi olarak Ubuntu 9.10 kullanıyorum ve sırası ile
Chromium,Firefox ve Opera tarayıcılarının görüntüleri:
";i:2;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://i41.tinypic.com/2vnpg0h.jpg";}}i:3;s:1:",";i:4;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://i44.tinypic.com/23h6pzm.png";}}i:5;s:1:",";i:6;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:33:"http://i42.tinypic.com/a1k28x.png";}}i:7;s:172:"
Not:Pardus 2009.1 ile açtım,her üç tarayıcıda Ubuntu daki Opera görüntüsü gibi,isim var ikon yok.
Sadece tarayıcı değil,işletim sistemi de etkili oluyor.";}, 1572939232, 1716088554
Run Time: 0.001293
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, 63525, a:1:{i:0;s:317:"İşletim sistemim Windows Vista Home Basic, service pack 1 ve 2 yüklü, tarayıcım İE v.8 ve Mozilla v.3.6 Serdar abi.
Senin 3. resimdeki gibi görüntülüyorum bende, yani Erman'ın ve Tanganyika_Lake Yavuz'un isimlerinin yanında ikonu göremiyorum.
Erman bunun ile uğraşıyordu ama ne yaptı bilmiyorum....";}, 1572939232, 1716088554
Run Time: 0.001580
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, 63526, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:18:"murer, post: 63525";s:8:"original";a:2:{i:0;s:28:"[quote="murer, post: 63525"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:317:"İşletim sistemim Windows Vista Home Basic, service pack 1 ve 2 yüklü, tarayıcım İE v.8 ve Mozilla v.3.6 Serdar abi.
Senin 3. resimdeki gibi görüntülüyorum bende, yani Erman'ın ve Tanganyika_Lake Yavuz'un isimlerinin yanında ikonu göremiyorum.
Erman bunun ile uğraşıyordu ama ne yaptı bilmiyorum....";}}i:1;s:290:"
Ermanın kullanıcı ismi düzelmişti dün akşam,yanında ikon vardı,uzun isimler Yavuz ve yeni üye olan Celal bey(Florasan Reflektörü)ilgili bölüme sığmıyor,Yavuzda sadece ikon görünmezken,Celal beyin kullanıcı adının birkaç harfi de görüntülenemiyordu dün akşam.";}, 1572939232, 1716088554
Run Time: 0.002392
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, 63527, a:1:{i:0;s:149:"Abilerim forum kenarlıklarını kaldıracağım birazdan. Dolayısı ile forum genişleyecek. Forum genişleyince öyle bir sorunumuz kalmayacak. ;)";}, 1572939232, 1716088554
Run Time: 0.001318
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, 63528, a:1:{i:0;s:89:"Serdar abi profil alanı darlığından kaynaklanıyor. Genişletiriz biraz sorun değil.";}, 1572939232, 1716088554
Run Time: 0.001108
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 = 5938)
LIMIT 1
Run Time: 0.000536
| 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: 104
Run Time: 0.000235
| 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: 103
Run Time: 0.000217
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |