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.000461
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.000195
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: 22442
Run Time: 0.000505
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: 41
Run Time: 0.000415
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: 22442
Run Time: 0.002176
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 | 14 | 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 |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, data.file_path, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xf_attachment AS attachment
INNER JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE attachment.content_type = ?
AND attachment.content_id IN (378451, 378471)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000472
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | range | content_type_id_date | content_type_id_date | 31 | | 2 | Using index condition |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | bizimled_db.attachment.data_id | 1 | |
INSERT INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 22442
Run Time: 0.000077
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: e9bb7bfcf41b4090ee1be8fbec60bac7, , 1713920250
Run Time: 0.000186
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=22442, 1713916650,
Run Time: 0.000162
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000249
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, 378451, a:3:{i:0;s:509:"Merhabalar çalıştığım yerde deniz suyundan içme suyu üreten bir ünite mevcut testlerinden biride tuz ölçerdi akvaryum da denemek maksadıyla Marmara suyunu ölçtüm 28.7 değeri çıktı kitapçığında bu değerin Litre/Gram biriminde olduğunu öğrendim. Refraktometrelerin tuzluluk değil sudaki tuz yoğunluğunu ölçtüğünü farkettim.Sizce bu cihaz ile 33 gr. 35 gr. arasında değer tutturarak tank idame ettirebilir miyim? Cihazın fotoğrafını aşağıya ekliyorum. İyi akşamlar ";i:1;a:4:{s:3:"tag";s:6:"attach";s:6:"option";s:4:"full";s:8:"original";a:2:{i:0;s:13:"[ATTACH=full]";i:1;s:9:"[/ATTACH]";}s:8:"children";a:1:{i:0;s:5:"33749";}}i:2;s:54:"
D5803 cihazımdan Tapatalk kullanılarak gönderildi";}, 1572939232, 1713916650
Run Time: 0.002084
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, 378453, a:1:{i:0;s:21:"Olur dostum
BARREEF";}, 1572939232, 1713916650
Run Time: 0.001713
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, 378456, a:1:{i:0;s:19:"Cihazın adı nedir";}, 1572939232, 1713916650
Run Time: 0.001481
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, 378457, a:1:{i:0;s:327:"Marka modeli var sadece ticari alınan bir ürün olmadığı için kullanan arkadaşlar da tuz ölçer olarak biliyor. Özellikle deniz suyundaki tuzu ölçmek üzere bir cihaz olduğu yazıyor kataloğunda ve sıcaklıktan bağımsız olarak ölçüm yaptığı yazıyor.
D5803 cihazımdan Tapatalk kullanılarak gönderildi";}, 1572939232, 1713916650
Run Time: 0.001667
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, 378459, a:1:{i:0;s:146:"Yoğunluk değil tuzluluk ölçtüğü için sıcaklıktan etkilenmediğini düşünüyorum
D5803 cihazımdan Tapatalk kullanılarak gönderildi";}, 1572939232, 1713916650
Run Time: 0.001273
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, 378463, a:1:{i:0;s:48:"Marka modeli alabilir miyiz? Merak ettim şimdi.";}, 1572939232, 1713916650
Run Time: 0.002011
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, 8613, a:1:{i:0;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"4";s:8:"original";a:2:{i:0;s:8:"[SIZE=4]";i:1;s:7:"[/SIZE]";}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:100:"Capitalism works like a PS. Bubbles work hard to reach to the top, but we all now who can get there.";}}}}}, 1572939232, 1713916650
Run Time: 0.002046
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, 378465, a:1:{i:0;s:140:"WTW Cond 315i birkaç türk sitesinde çıkıyor ama daha çok yabancı kaynak mevcut.
D5803 cihazımdan Tapatalk kullanılarak gönderildi";}, 1572939232, 1713916650
Run Time: 0.001247
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, 378470, a:1:{i:0;s:566:"Uğur bey öncelikle hayırlı olsun. Sizin tankınızın ölçümünüde gösterirseniz daha iyi olur. Fakat birde şöyle bir durum var her marka tuz aynı gramajda aynı tuz yoğunluğunu sağlamıyor. Yani a marka tuz litre başına 33 gram atıldığında 1.024 sağlıyorken b marka tuz ancak litre başına 40 gram atılarak bu yoğunluğa ulaşabiliyor. En sağlıklısı bana göre refraktometre. Yinede başlamak için bir nokta. Bence akvaryumunuzun ölçümünü burada tuz markanız ile birlikte paylaşın Fatih bey daha kolay yardımcı olacaktır. :)";}, 1572939232, 1713916650
Run Time: 0.002371
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, 378471, a:3:{i:0;s:219:"Teşekkürler tankın suyunu ölçüp tekrar paylaşım yapıcam bahsettiğiniz durum benim de aklıma geldi ancak internet üzerinden şu tipte tablolar buldum, şimdilik 35 gram değerine riayet edicem. İşte tablo ";i:1;a:4:{s:3:"tag";s:6:"attach";s:6:"option";s:4:"full";s:8:"original";a:2:{i:0;s:13:"[ATTACH=full]";i:1;s:9:"[/ATTACH]";}s:8:"children";a:1:{i:0;s:5:"33750";}}i:2;s:54:"
D5803 cihazımdan Tapatalk kullanılarak gönderildi";}, 1572939232, 1713916650
Run Time: 0.001662
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, 378472, a:1:{i:0;s:343:"Uğur bey sorun yaşayacağınızı sanmıyorum çünkü aralarda dağlar kadar fark olmuyor genelde. Fakat yinede emin olmak gerekir. En kötü ihtimal ile 1.025 değilde 1.024 olur zaten tahminimce. Ama sorun şu ki tankınızın değerini 10.0 okursanız ne olacak ? litre başına 25 gram tuz mu ekleyeceksiniz ? :) Bence çok tehlikeli :)";}, 1572939232, 1713916650
Run Time: 0.001244
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, 378475, a:1:{i:0;s:163:"Sanırım evet deniz suyu ile de sofra tuzu ekleyerekte bardakta denedim verdiği sonuçlar bana makul geldi.
D5803 cihazımdan Tapatalk kullanılarak gönderildi";}, 1572939232, 1713916650
Run Time: 0.006633
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, 378477, a:1:{i:0;s:100:"Peki, sonuçlarınızı bekliyorum Uğur bey. İnşallah sorun yaşamazsınız. Sağlıklı hobiler.";}, 1572939232, 1713916650
Run Time: 0.001255
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, 378478, a:1:{i:0;s:51:"Wtw kaliteli markadır ph metre sini kullanıyorum.";}, 1572939232, 1713916650
Run Time: 0.001353
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, 378479, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:40:"DeathAnqeLs, post: 378477, member: 11993";s:8:"original";a:2:{i:0;s:50:"[QUOTE="DeathAnqeLs, post: 378477, member: 11993"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:100:"Peki, sonuçlarınızı bekliyorum Uğur bey. İnşallah sorun yaşamazsınız. Sağlıklı hobiler.";}}i:1;s:92:"
Teşekkürler ederim, İyi Akşamlar
D5803 cihazımdan Tapatalk kullanılarak gönderildi";}, 1572939232, 1713916650
Run Time: 0.001308
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 = 22442)
LIMIT 1
Run Time: 0.000406
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: 31
Run Time: 0.000166
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |