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.000520
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.000211
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: 26006
Run Time: 0.000446
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: 35
Run Time: 0.000519
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: 26006
Run Time: 0.004914
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: 26006
Run Time: 0.000093
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: d47fe40c06c693aeec40356bbeb2f349, , 1714341081
Run Time: 0.000222
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=26006, 1714337481,
Run Time: 0.000106
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, 423456, a:4:{i:0;s:982:"Güya evi taşıyana kadar tank kurmayacaktım ama tabiki dayanamadım yine derme çatma bir kurulum yaptım. 90 x 45 x 40h akvaryum içten durso altta da bir 50 litrelik sump var tank komple 200 litre kadar su aldı. Neden derme çatma diyorum çünkü akvaryumu tek bir balık için kurdum ps yok uygun bir şey bulabilirsem eklenecek armatür de yok standart bir soğuk gün ışığı lamba var üstünde armatürü de bi yerlerden bulabilirsem eklerim. Neden bu kadar malzemesiz kurdum tankı diye sorarsanız dediğim gibi tek bir balık besleyeceğim evi taşıyana kadar. Evi taşıdıktan sonra da tankı tutup düzgün malzemelerle resife çeviricem en azından şimdiki plan bu şekilde :) kum ve caribsea kayalar Hasan abinin hediyesi, kaya dizaynı da şimdilik böyle Kaan bey beğenmedi gelip düzelteceğini iddia ediyor onu da görücez ilerleyen günlerde. Suyu zaten komple oturmuş tanktan çektiğim için haftasonu tankın assolistini eklemeyi planlıyorum :) ";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:78:"https://uploads.tapatalk-cdn.com/20170221/6a70ad122e0eb1250195f4ca14a05c93.jpg";}}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:78:"https://uploads.tapatalk-cdn.com/20170221/29a2716f0e35a527e024656d435e0d73.jpg";}}i:3;s:58:"
Tapatalk kullanarak iPhone aracılığıyla gönderildi";}, 1572939232, 1714337481
Run Time: 0.002028
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, 11195, 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:8:{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:2:{i:0;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"5";s:8:"original";a:2:{i:0;s:8:"[SIZE=5]";i:1;s:7:"[/SIZE]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#ffa64d";s:8:"original";a:2:{i:0;s:15:"[COLOR=#ffa64d]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;s:10:"BettAngora";}}}}i:1;s:1:"-";}}i:1;s:52:"Türkiye'nin ilk profesyonel betta üretici grubu..
";i:2;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:1:{i:0;s:7:"Youtube";}}i:3;s:1:"/";i:4;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#0000ff";s:8:"original";a:2:{i:0;s:15:"[COLOR=#0000ff]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;s:8:"Facebook";}}i:5;s:1:"/";i:6;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#b30059";s:8:"original";a:2:{i:0;s:15:"[COLOR=#b30059]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;s:9:"Instagram";}}i:7;s:11:"-BettAngora";}}}, 1572939232, 1714337481
Run Time: 0.001640
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, 424643, a:3:{i:0;s:433:"Burda da rezillik adlı çalışmamı görüyorsunuz. Arıtmanın housing'inin sıkışması ve benim açmaya çalışırken parçalamam üzerine suyu dibe inip kafa motorunun havayla karışık haykırışlarına acil bir çözül bulmam gerekti. Bu da bir adet pet şişe, kahve filtresi ve mixbed reçine ile yapılan öğrenci evi işi arıtma cihazı. Su 0 tds mi evet 0 tds tek farkı görüntüsü kötü [emoji23][emoji23]
";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:78:"https://uploads.tapatalk-cdn.com/20170315/04ac0bd732e6797e2907e4506a93f1ca.jpg";}}i:2;s:58:"
Tapatalk kullanarak iPhone aracılığıyla gönderildi";}, 1572939232, 1714337481
Run Time: 0.001230
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, 424749, a:1:{i:0;s:47:"Görüntü kötü olsa da amaç hasıl olmuş..";}, 1572939232, 1714337481
Run Time: 0.001333
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, 12750, a:1:{i:0;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:84:"http://www.akvaryumportali.com/threads/akvaryumda-azot-d%C3%B6ng%C3%BCs%C3%BC.25937/";s:8:"original";a:2:{i:0;s:92:"[URL='http://www.akvaryumportali.com/threads/akvaryumda-azot-d%C3%B6ng%C3%BCs%C3%BC.25937/']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:26:"Akvaryumda Azot Döngüsü";}}}, 1572939232, 1714337481
Run Time: 0.001573
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, 425146, a:3:{i:0;s:121:"Assosiltimiz geleli 3 hafta kadar oluyor alıştık birbirimize 200 litrede tek başına mutlu mesut yaşıyor [emoji4]
";i:1;a:4:{s:3:"tag";s:5:"media";s:6:"option";s:7:"youtube";s:8:"original";a:2:{i:0;s:15:"[MEDIA=youtube]";i:1;s:8:"[/MEDIA]";}s:8:"children";a:1:{i:0;s:11:"JQzT8pQ4uE0";}}i:2;s:58:"
Tapatalk kullanarak iPhone aracılığıyla gönderildi";}, 1572939232, 1714337481
Run Time: 0.001474
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, 425180, a:1:{i:0;s:37:"Derme çatma ama seksi olmuş Egemen.";}, 1572939232, 1714337481
Run Time: 0.001310
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, 425181, a:1:{i:0;s:50:"Bu tetik balıkları gerçekten çok asil duruyor.";}, 1572939232, 1714337481
Run Time: 0.001025
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 = 26006)
LIMIT 1
Run Time: 0.000441
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.000177
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |