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.000603
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.000213
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: 15048
Run Time: 0.000439
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: 105
Run Time: 0.000805
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: 15048
Run Time: 0.002448
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: 15048
Run Time: 0.000092
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 336a53c6293fd093e7c75ab9d7141a78, a:8:{s:12:"sessionStart";i:1713534852;s:2:"ip";s:4:"݈";s:11:"sessionCsrf";s:16:"glpPJrDP7LP6mdcT";s:9:"userAgent";s:103:"Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)";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;}}, 1713538452
Run Time: 0.000220
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=15048, 1713534852,
Run Time: 0.000160
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000334
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, 231760, a:1:{i:0;s:708:"Merhaba degerli portal sakinleri. Ben istanbuldan İlhan.
16 yasimdan beri tatli su dunyasinin cesitli canlilariyla ilgilenmekteyim.(su an 24 yasindayim) Universite , hayat şu bu derken birkac sene ara verdigim akvaryum sevdasindan daha fazla uzak kalamayip hic direnmeden donus yapmis bulunmaktayim. Birkac gundur portaldayim ve diger forumlar dahil eski tanidigim kardeslerim ve abilerimden pek eser kalmamis. ( sayili birkac kisi disinda) neyse kisa keselim. Yeniden hepinize merhaba. Portaldaki paylasimlari cok begendim ve cevreme de tavsiye ediyorum. Kisa zaman sonra tankimi kurup tanitmayi dusunuyorum.
Simdiden hepinize hayirli bayramlar dilerim.
GT-I9300 cihazımdan Tapatalk 4 ile gönderildi";}, 1572939232, 1713534852
Run Time: 0.001567
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, 8771, a:1:{i:0;s:14:"Using Tapatalk";}, 1572939232, 1713534852
Run Time: 0.001965
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, 231767, a:1:{i:0;s:138:"İlhan Bey hoş geldiniz. En kısa zamanda akvaryumunuzu kurup, paylaşımlarınızı bekliyoruz.
Sizinde kurban bayramınız kutlu olsun.";}, 1572939232, 1713534852
Run Time: 0.001361
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, 7750, a:1:{i:0;s:98:"135 litre Canlı Doğuran, Sarı Ateş Neon, Mavi Melek, Kiraz, mavi inci, siyah gül Karides.";}, 1572939232, 1713534852
Run Time: 0.001392
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, 231774, a:1:{i:0;s:37:"Hoş geldiniz hayırlı bayramlar...";}, 1572939232, 1713534852
Run Time: 0.001221
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, 7159, 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:34:"http://i.hizliresim.com/25yjPL.jpg";}}}, 1572939232, 1713534852
Run Time: 0.001659
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, 231781, a:1:{i:0;s:43:"Hoşgeldiniz ne tür bir tank kuruyorsunuz.";}, 1572939232, 1713534852
Run Time: 0.001064
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, 6637, a:1:{i:0;s:100:"><((((º>`·.¸¸.·´¯`·.¸.·´¯`·...¸><((((º>`·.¸¸.·´¯`· .¸.·´¯`·...¸><((((º>";}, 1572939232, 1713534852
Run Time: 0.001123
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, 231785, a:1:{i:0;s:65:"Hoşgeldiniz İlhan bey;
Yeni kurulumunuzu merakla bekliyoruz.:)";}, 1572939232, 1713534852
Run Time: 0.001034
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, 231787, a:1:{i:0;s:833:"Yeniden merhaba:-)
Kurmak istedigim tank olculeri 120x60x60 vr ic yandan bunun 20 cm yerini sump olarak kullanmayi dusunuyorum. Yani izlenebilir alan 100x60x60 olacak. Bunun disindaki verdigim tum kararlar ve hesaplamalar surekli degisiyor. Bu iste sinir diyr bisey yok arkadaslar. Sonuna kadar sıkı bir DIYci oldugum icin sehpanin modellemesi, kullanilacak materyalden tutunda armature kadar tamamiyle el yapimi kendi isciligim olacak. Defalarca yazdim cizdim bilgisayarda tasarimlarim oldu ama gelistirmeye calistigim iki detay var. Biri kaynak kullanmadan demir profil yapip mdf giydirmek digeri de silikon kullabmadan lamine dokum cama teknik cam cubukla kaynak yaparak akvaryumu olusturmak. Varin bide siz el atin dostlar. Cok mu cok diy kafasi yoksa bayramin kafasi mi bu :-)
GT-I9300 cihazımdan Tapatalk 4 ile gönderildi";}, 1572939232, 1713534852
Run Time: 0.001042
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, 231797, a:1:{i:0;s:139:"Selam hoşgeldiniz ilhan bey bende sıkı bir dıy cıyım herşeyi kendim yapmak istiyorum sehpayı kendim yaptım. :) hayırlı bayramlar";}, 1572939232, 1713534852
Run Time: 0.001172
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, 231872, a:1:{i:0;s:34:"Hoş geldiniz İlhan bey foruma.:)";}, 1572939232, 1713534852
Run Time: 0.001253
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, 231878, a:1:{i:0;s:30:"Hoş geldiniz sefa getirdiniz.";}, 1572939232, 1713534852
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, 231901, a:1:{i:0;s:460:"Hoş geldin İlhan kardeşim, düşüncelerine teşekkürler. Önemli olan yapılan tüm işlere saygı duymak ve insanların bulunduğu yörelerdeki alım ve ulaşma imkanına saygı duyarak yorum yapmaktır. Bu bazılarında vardır, bazılarında yoktur.
Kendin yap tarafını çok severim malum ama akvaryumuna kamera takıp izleyenleri de hobiye sevgi, sorumluluk aldığı canlılara bu denli saygısından dolayı da ayrı bir hayranlığım vardır.;)";}, 1572939232, 1713534852
Run Time: 0.001350
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, 231904, a:1:{i:0;s:75:"Ben kendi tankımdaki çoğu sistemi kendim yaptım, benimde elimden gelir.";}, 1572939232, 1713534852
Run Time: 0.001057
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 = 15048)
LIMIT 1
Run Time: 0.000562
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: 103
Run Time: 0.000208
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |