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.000733
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.000219
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: 2610
Run Time: 0.000470
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: 81
Run Time: 0.000543
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: 2610
Run Time: 0.005582
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 | 11 | 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: 2610
Run Time: 0.000079
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: d3ba62a95ed22995d74b7661c3d5bfe5, , 1713516229
Run Time: 0.000184
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=2610, 1713512629,
Run Time: 0.000113
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000297
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, 27248, a:9:{i:0;s:52:"Varan 1:60*15*20(Yeni alınan camlar ile yapıldı)
";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:51:"http://img13.imageshack.us/img13/4353/dsc02939m.jpg";}}i:2;s:52:"
Varan 2:60*13*15(Evdeki artık camlarla yapıldı)
";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:51:"http://img35.imageshack.us/img35/1205/dsc02940s.jpg";}}i:4;s:542:"
Bölmeler arasındaki cam ayıraçlar alttan 2 cm boşluk bırakılarak yapıştırıldı ve tabana ilk önce biyolojik sünger serildi boydan boya ve üstüne lav taşı kumu yayıldı.En köşeye Atman'ın 450lt/saat kafa motoru yerleştirilerek sirkülaston sağlandı.Motor çıkışına elektrik tesisatı borusundan şelale yapıldı.Her bölmeye 2 delikten su akmakta.Motor biraz güçlü olduğu için yanında bulunan ayar kısımından ayarı en düşüğe getirildi.Yukarıdan dökülen su tabandan emiliyor ve motora ulaşıyor.
";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:53:"http://img35.imageshack.us/img35/2027/dsc02941gvq.jpg";}}i:6;s:1:"
";i:7;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:51:"http://img34.imageshack.us/img34/4481/dsc02938c.jpg";}}i:8;s:85:"
foto: çekmek yaptıktan sonra aklımıza geldi,kusura bakmayın artık :cekingen:";}, 1572939232, 1713512629
Run Time: 0.003517
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, 396, 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:2:{i:0;s:8:"Cem EMRE";i:1;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:72:"
İstanbulBildiklerim,bilmediklerim yanında,evrendeki yerim kadardır.";}}}}}, 1572939232, 1713512629
Run Time: 0.002651
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, 27249, a:1:{i:0;s:142:"Siyam balıklı (Betta'lı) halini merakla bekliyoruz.. Siyam balığı akvaryumu diye hor görmeyin Cem , atın şuna 2 tane kayıt kuşak :F";}, 1572939232, 1713512629
Run Time: 0.001638
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, 264, a:1:{i:0;s:42:"130*45*55 High Tech Bitkili Karma Akvaryum";}, 1572939232, 1713512629
Run Time: 0.001726
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, 27250, a:1:{i:0;s:32:"Cem bol yavrulu günler dilerim.";}, 1572939232, 1713512629
Run Time: 0.001461
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, 1713512629
Run Time: 0.001396
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, 27251, a:1:{i:0;s:335:"Ara bölme camları yüksek olmuş ya kumu çıkarmak zorunda kalacaksın yada camları biraz kesmek zorunda. İlk çalıştırmada 3/4 su koyarak deneme yapın yoksa sonuç bazen hüsran oluyor. Çok güzel bir çalışma olmuş tebrikler. Motorun olduğu tarafa seramik ve elyafta eklenirse filrasyon daha iyi olacak kanısındayım.";}, 1572939232, 1713512629
Run Time: 0.001345
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, 1192, a:1:{i:0;s:80:"raif arda<br />full red, germen platinium tuxedo ribon fin, full black sharkfin.";}, 1572939232, 1713512629
Run Time: 0.001850
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, 27252, a:1:{i:0;s:394:"İş yerinde ki monitörüm pek iyi değil diye resimleri karanlık görüyorum. Gördüğüm kadarıyla akvaryumun üstünden geçen bir boru mevcut. Burdan akvaryuma su akıcak galiba(iki delik demişsin, her akvaryuma iki delik mi yoksa sadece birer tanemi) Eğer öyle bir şeyse erkeğin yapacağı köpüğü dağıtma ihtimali yüksek bu da üretim için uygun olmayacağını gösterir.";}, 1572939232, 1713512629
Run Time: 0.001597
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, 27253, a:1:{i:0;s:246:"Su çok çok az gönderiliyor,yuvayı dağıtacağını sanmıyorum.Arkadaş bettaları koydu,şu anda besliyor.Benimkine haftasonu koyarız herhalde.Camlar yüksek olmuş derken?Şu an ağzına kadar doluyken bile rahat çalışıyor Raif Bey...";}, 1572939232, 1713512629
Run Time: 0.001443
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, 27254, a:1:{i:0;s:61:"Bizim bu tarafa gelirsen gösteririm? Zamanla olacakları :)";}, 1572939232, 1713512629
Run Time: 0.001839
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, 27255, a:1:{i:0;s:157:"Cem tebrikler, yapımı gene zekice olmuş. Üstten yağmurlama sistemiyle su düşecek sanırım. Sevimli bir Betta akvaryumu olmuş ellerinize sağlık. ;)";}, 1572939232, 1713512629
Run Time: 0.001314
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, 27256, 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:18:" 2 adet Betta'lık";}}i:1;s:43:"
Yavrulu bir foto yokmu :D
Güzel olmuş";}, 1572939232, 1713512629
Run Time: 0.001083
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, 1509, a:1:{i:0;s:27:"30x30x30H Nano Planted Tank";}, 1572939232, 1713512629
Run Time: 0.001832
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, 27257, 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:18:" 2 adet Betta'lık";}}i:1;s:161:"
Güzel bir çalışma Cem abi. Tebrik ederim. Emek harcanmış bir yapıt. İnşallah istediğiniz kadar yavru alır , sağlıcakla beslersiniz.
Saygılar...";}, 1572939232, 1713512629
Run Time: 0.001321
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, 317, a:1:{i:0;s:101:"Gün gelecek aydınlıkta dahi zikretmekten korktuğunuz hakikati , karanlıklarda zikredeceksiniz...";}, 1572939232, 1713512629
Run Time: 0.001463
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, 27258, 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:18:" 2 adet Betta'lık";}}i:1;s:144:"
Yavrular dün bana geldiler.Kuyruklar kırmızı gövde süt pembe.Bir ara elden ayaktan kesilmeden önce çeker koyarım fotoğraflarını :)";}, 1572939232, 1713512629
Run Time: 0.001588
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 = 2610)
LIMIT 1
Run Time: 0.000707
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: 167
Run Time: 0.000259
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.000248
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |