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.000470
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.000185
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: 17438
Run Time: 0.000431
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: 148
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 ASC
Params: 17438
Run Time: 0.001607
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 | 17 | 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: 17438
Run Time: 0.000074
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 6f037b9a17210bad75c3f3b83912d064, , 1713595774
Run Time: 0.000181
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=17438, 1713592174,
Run Time: 0.000105
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000391
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, 272729, a:1:{i:0;s:132:"Merhaba arkadaşlar Gaziantep'de oturuyorum bu balığı arıyorum yardımcı olabilecek satan kargo yapabilecek olan var mı acaba?";}, 1572939232, 1713592174
Run Time: 0.001611
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, 272732, a:1:{i:0;s:40:"Civar illerden gönderi kabul ediyoruz.";}, 1572939232, 1713592174
Run Time: 0.001053
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, 9643, 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:10:{i:0;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:12:"rgb(0, 0, 0)";s:8:"original";a:2:{i:0;s:20:"[COLOR=rgb(0, 0, 0)]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;s:1:"
";}}i:1;s:1:"
";i:2;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#808080";s:8:"original";a:2:{i:0;s:15:"[COLOR=#808080]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;s:15:"Doğru kararlar";}}i:3;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:12:"rgb(0, 0, 0)";s:8:"original";a:2:{i:0;s:20:"[COLOR=rgb(0, 0, 0)]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;s:1:" ";}}i:4;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#ff4d4d";s:8:"original";a:2:{i:0;s:15:"[COLOR=#ff4d4d]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;s:11:"tecrübeden";}}i:5;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:12:"rgb(0, 0, 0)";s:8:"original";a:2:{i:0;s:20:"[COLOR=rgb(0, 0, 0)]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;s:1:" ";}}i:6;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#808080";s:8:"original";a:2:{i:0;s:15:"[COLOR=#808080]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;s:18:"gelir ama tecrübe";}}i:7;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:12:"rgb(0, 0, 0)";s:8:"original";a:2:{i:0;s:20:"[COLOR=rgb(0, 0, 0)]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;s:1:" ";}}i:8;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#ff4d4d";s:8:"original";a:2:{i:0;s:15:"[COLOR=#ff4d4d]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;s:7:"kötü ";}}i:9;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#808080";s:8:"original";a:2:{i:0;s:15:"[COLOR=#808080]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;s:21:"kararlardan oluşur. ";}}}}}, 1572939232, 1713592174
Run Time: 0.001367
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, 272810, a:1:{i:0;s:211:"Adana kaç saat Murat, orada kesin vardır bu şekil tuzlu su akvaryumuyla uğraşan hobici veya akvaryumcu. Bir araştırmak lazım. Oradan otobüs kargosuyla gelir araştır bakalım Adana akvaryumcular diye.";}, 1572939232, 1713592174
Run Time: 0.000994
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, 272813, a:1:{i:0;s:242:"Veysel abi, var orada ama canlı gönderimi yapmıyor gittim yellow tang ve chromisleri oradan aldım zaten baya konuştum adamla sorumluluğu kabul edersen 50 liraya gönderirim otobüsle diyor benim gidiş gelişim Adana'ya 60 lira zaten :D";}, 1572939232, 1713592174
Run Time: 0.001144
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, 272844, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:38:"muradtekin, post: 272813, member: 9244";s:8:"original";a:2:{i:0;s:48:"[QUOTE="muradtekin, post: 272813, member: 9244"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:242:"Veysel abi, var orada ama canlı gönderimi yapmıyor gittim yellow tang ve chromisleri oradan aldım zaten baya konuştum adamla sorumluluğu kabul edersen 50 liraya gönderirim otobüsle diyor benim gidiş gelişim Adana'ya 60 lira zaten :D";}}i:1;s:269:"
Balık artı kargo mu 50 tl. Yoksa sadece kargo mu 50 lira. Sadece balıksa gayet iyi orada burada aramaya gerek yok. Söylersin 1o liralık birde pilli hava motoru takar 60 lira ileride elektrik kesintilerinde pilli hava motoru ile idare edersin ben öyle yapıyorum.";}, 1572939232, 1713592174
Run Time: 0.001307
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, 272845, a:1:{i:0;s:18:"balık + 50 Veysel";}, 1572939232, 1713592174
Run Time: 0.001006
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, 272854, a:1:{i:0;s:120:"Kendin gideceksin gezeceksin bir balık yerine bir kaç balık vs alıp döneceksin bu daha risk harcama bakımından.:D";}, 1572939232, 1713592174
Run Time: 0.000998
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, 272862, a:1:{i:0;s:200:"bende öyle düşünüyorum Veysel abi, ama maddi olarak biraz ayarlıyayım kendimi bir balık için gitmiyeyim sadece :) aklımda ne mercanlar var ama sps yok töbe o senin gibi üstatların işi :)";}, 1572939232, 1713592174
Run Time: 0.000889
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, 272863, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:38:"muradtekin, post: 272862, member: 9244";s:8:"original";a:2:{i:0;s:48:"[QUOTE="muradtekin, post: 272862, member: 9244"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:200:"bende öyle düşünüyorum Veysel abi, ama maddi olarak biraz ayarlıyayım kendimi bir balık için gitmiyeyim sadece :) aklımda ne mercanlar var ama sps yok töbe o senin gibi üstatların işi :)";}}i:1;s:306:"
Zor sps bende çırağım daha üstat için daha 40 fırın ekmek yemem lazım. Ama planlama iyi yapılması gerekiyor ve gerçekten akvaryuma baktığın zaman akvaryumun ne söylediğini bilmek ve anlamak gerekiyor. Şuan tek parça sps var renklerini veriyor ama büyüme çok yavaş yok dencek kadar.";}, 1572939232, 1713592174
Run Time: 0.001913
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, 272865, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:34:"veysel, post: 272863, member: 6836";s:8:"original";a:2:{i:0;s:44:"[QUOTE="veysel, post: 272863, member: 6836"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:305:"Zor sps bende çırağım daha üstat için daha 40 fırın ekmek yemem lazım. Ama planlama iyi yapılması gerekiyor ve gerçekten akvaryuma baktığın zaman akvaryumun ne söylediğini bilmek ve anlamak gerekiyor. Şuan tek parça sps var renklerini veriyor ama büyüme çok yavaş yok dencek kadar.";}}i:1;s:119:"
ne gerek var teste para vermeye üstat ol tamam :P şaka maka benim şimdiye kadar yaptığım tek test ph ölçmek :)";}, 1572939232, 1713592174
Run Time: 0.001248
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, 272871, a:1:{i:0;s:130:"Dün görseydim ilanı gönderirdim :D 35 liraya ben aldım liste fiyatından 5 lirada otobüse verirdin 40 lira :) sağlık olsun";}, 1572939232, 1713592174
Run Time: 0.001148
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, 272872, a:1:{i:0;s:65:"Aynen sağlık olsun efendim
Sent from my iPhone using Tapatalk";}, 1572939232, 1713592174
Run Time: 0.001014
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, 272873, a:1:{i:0;s:112:"Çok bölgeci ve damsel ile uyumsuz olduğundan 35 e bi arkadaşa sattım ama tavsiye ederim bulursan kaçırma.";}, 1572939232, 1713592174
Run Time: 0.001488
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, 272896, a:1:{i:0;s:52:"Benim sixline ile damsel yan yana yüzüyor bazen :)";}, 1572939232, 1713592174
Run Time: 0.001097
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, 272902, a:1:{i:0;s:143:"Damsel daha sert olduğundan vuruyor hep ve sixline taşların altına değil o kadar korkuyor ki taşın içine giriyor bulamıyorum bazen. :)";}, 1572939232, 1713592174
Run Time: 0.000901
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, 272921, a:1:{i:0;s:59:"Bu sixline wrasse küçük kabuklu salyangoz filan yer mi ?";}, 1572939232, 1713592174
Run Time: 0.000928
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, 273014, a:1:{i:0;s:101:"Ben görmedim camları kemiriyor :)yosun yiyor bildiğim kadar ağız yapısını görsen yosunluk :)";}, 1572939232, 1713592174
Run Time: 0.000932
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 = 17438)
LIMIT 1
Run Time: 0.000414
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: 184
Run Time: 0.000220
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |