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.000459
| 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.000154
| 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: 13289
Run Time: 0.000401
| 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: 109
Run Time: 0.000395
| 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 ASCParams: 13289
Run Time: 0.002321
| 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: 13289
Run Time: 0.000085
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: add4fa3219e58ad1f9fccc003749ebfd, , 1713562351
Run Time: 0.000179
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=13289, 1713558751,
Run Time: 0.000099
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000231
| 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, 190212, a:1:{i:0;s:177:"Taban bitkileri pvc tele tutturulmuş geliyor. Biz bunu nasıl yerleştirmemiz gerekir? Pvc telle kuma gömerek mi acaba? Tecrübesi olan arkadaş yardımcı olursa sevinirim...";}, 1572939232, 1713558751
Run Time: 0.001336
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, 7969, a:1:{i:0;s:25:"80*50*60 Marine saltwater";}, 1572939232, 1713558751
Run Time: 0.001379
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, 190234, a:1:{i:0;s:80:"Pvcde Olanlar genelde Moss Veya Riccia Türleri. Size gelen bitki türü nedir ?";}, 1572939232, 1713558751
Run Time: 0.001050
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, 6612, a:1:{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;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;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:2:{i:0;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:7:"Georgia";s:8:"original";a:2:{i:0;s:14:"[FONT=Georgia]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:62:"Armut Deyip Geçmeyin Onun İlk Hecesi Çoğu Kişide Yoktur..";}}i:1;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:13:"lucida grande";s:8:"original";a:2:{i:0;s:20:"[FONT=lucida grande]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;s:1:".";}}}}i:1;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"7";s:8:"original";a:2:{i:0;s:8:"[SIZE=7]";i:1;s:7:"[/SIZE]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:4:"font";s:6:"option";s:13:"lucida grande";s:8:"original";a:2:{i:0;s:20:"[FONT=lucida grande]";i:1;s:7:"[/FONT]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:14:"rgb(255, 0, 0)";s:8:"original";a:2:{i:0;s:22:"[COLOR=rgb(255, 0, 0)]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;s:25:" Necip Fazıl Kısakürek";}}}}}}}}}}}}}, 1572939232, 1713558751
Run Time: 0.001206
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, 190246, a:1:{i:0;s:279:"Bildiğim kadarıyla hiç bozmadan akvaryumda uygun yere olduğu gibi bırakırsanız, zamanla yayılacaktır.Pvc nin görünmesini istemiyorsanız çok az bir şekilde kum ile kamufle edebilirsiniz.Yine de üstadlardan gereken bilgiyi almanızı tercih ederim. Saygılarımla...";}, 1572939232, 1713558751
Run Time: 0.001543
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, 6093, a:1:{i:0;s:31:"108 litre bitkili 55 litre boş";}, 1572939232, 1713558751
Run Time: 0.001416
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, 190248, a:1:{i:0;s:104:"Riccia bitkisi. Olduğu gibi bıraktığımda hepsi akvaryuma dağıldı, onun için yardım istedim. :)";}, 1572939232, 1713558751
Run Time: 0.000945
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, 190253, a:1:{i:0;s:198:"Kökleri pvcyi tamamiyle sarmamışsa tutmamışsa biraz ip ya da misine yardımı ile tutturabilirsin.Geliştikçe ip kamufle olur içine sinmezse geliştikten sonra ipi yada misineyi kesebilirsin.";}, 1572939232, 1713558751
Run Time: 0.001746
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, 190258, a:1:{i:0;s:98:"Bunlar köklü filan değil ki, bildiğimiz çim gibi birşey. Sadece pvc ye sıkıştırılmış.";}, 1572939232, 1713558751
Run Time: 0.001428
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, 190344, a:1:{i:0;s:358:"Riccia aslında su üstü bitkisidir. Taban bitkisi olarak kullanılmak istenirse, kullanmak istediğimiz alan kadar hazırlanmış tel örgünün üzerine, bir miktar riccia bitkisi yayılarak üzerine ikinci kat tel örgü kapatılır. Böylece riccialar arada kalarak akvaryuma yayılmaları önlenir. Çift taraflı telin içinden nasıl çıktılar ki?";}, 1572939232, 1713558751
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: 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, 1713558751
Run Time: 0.001306
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, 190363, a:1:{i:0;s:140:"bende onu anlamadım işten geldiğimde hepsi yüzüyordu. şimdi yenileri geldi üzerine biraz kum örttüm bakalım aradan çıkacaklarmı";}, 1572939232, 1713558751
Run Time: 0.001037
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, 190405, a:1:{i:0;s:340:"Telin aralarından çıkmışsa, yeni kırpılmıştır. Su yüzeyinde misine yardımıyla böleceğiniz bir bölgede, uzamalarını bekleyerek tekrar iki telin arasına yerleştiriniz. Beklemek istemiyorum derseniz, daha ince gözlü bir malzeme kullanmanız gerekecek. Kumun fayda edeceğini düşünmüyorum. Java yosunu daha uygun gibi.";}, 1572939232, 1713558751
Run Time: 0.001557
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, 190422, a:1:{i:0;s:68:"kum aralarından çıkmaz mı bu bitki. jbl bitki kumu kullanıyorum";}, 1572939232, 1713558751
Run Time: 0.002357
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, 190469, a:1:{i:0;s:133:"Yukarıda da belirtmiştim. Bitki aslında taban değil, su üstü bitkisidir. Köksüzdür. Kumun altında kalanlar çürüyecektir.";}, 1572939232, 1713558751
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 = 13289)
LIMIT 1
Run Time: 0.000419
| 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: 3
Run Time: 0.000193
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |