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.000631
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.000176
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: 2622
Run Time: 0.000440
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: 42
Run Time: 0.000410
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: 2622
Run Time: 0.002412
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 | 18 | 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: 2622
Run Time: 0.000088
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: b2ef304c5b014cbb1d23a6bb0b4b10c4, , 1713533038
Run Time: 0.000232
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=2622, 1713529438,
Run Time: 0.000106
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000255
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, 27534, a:1:{i:0;s:292:"Arkadaşlar ve abiler yeni bir akvaryum yapımına giriştiğmi belki duymuşsunuzdur.Akvaryumun her şeyini kendim yapmayı düşünüyorum,sizce deniz kumunu akvaryuma koyabilirmiyim?Şu küçük kardeşinize bir yardım edin. :d (görüşleriniz benim için çok önemlidir)
saygılar...";}, 1572939232, 1713529438
Run Time: 0.001920
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, 1485, a:1:{i:0;s:30:"Akvaryum kurmaya çalışıyor";}, 1572939232, 1713529438
Run Time: 0.001409
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, 27535, a:2:{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;s:72:"Abiler akvayumda deniz kumu kullan1labilir mi?(kumu denizden toplucam9:D";}}i:1;s:631:"
Bu konu daha oncede yazidi cizildi. Hep uzaktan okudum. Tuz barindirir akvaryuma salar, rovasataya ciktiginda faul yapar, start verildi kum padokta kaldi.
Bunlar isin gercekleri degil, hem akvaryumlara tuz eklemek iyidir diyip sonra deniz kumu tuz salar olmaz demek... Ne demek ?
Kapali yuzey bir kum tabasi ne tuzu barindiracak elbette yikanir temizlenir kullanilir. Cok ince yapili oldugundan taban kalinligi onemlidir. Fazlasi zarar, azi zarar, ortasi dsb calisir, ince tabasi normal.hele baliklar moliysee degme baliklarin keyfine, ben o zaman yikamadan eklerim.
Umarim mesaj anlasilmistir.(:
Not:cep mesaj imla klavyeden.";}, 1572939232, 1713529438
Run Time: 0.001276
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, 27536, a:1:{i:0;s:107:"Abi ben yunus cichlid(doğru yazdım sanırım:D) beslemeyi düşünüyorum, onlar için nasıldır ?sence.";}, 1572939232, 1713529438
Run Time: 0.001266
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, 27537, a:1:{i:0;s:145:"Kumu temiz bir şekilde yıkaman gerekir, salınım yapabileceğinden cikletlere iyi gelir diye düşünüyorum ama çok çok iyi yıkamalısın.";}, 1572939232, 1713529438
Run Time: 0.001312
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, 260, a:1:{i:0;s:9:"Emrah ECE";}, 1572939232, 1713529438
Run Time: 0.001288
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, 27538, a:1:{i:0;s:84:"Kumu iyice yıkarsan ve bol bol evire çevire durularsan deniz kumu kullanabilirsin.";}, 1572939232, 1713529438
Run Time: 0.001868
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, 147, a:1:{i:0;s:139:"Üzerimize kılıç çekilmedikçe, ülkemize saldırılmadıkça, milletimiz cefa çekmedikçe bizden kimseye zarar gelmez! Bilge Kağan''";}, 1572939232, 1713529438
Run Time: 0.001384
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, 27539, a:1:{i:0;s:59:"Tamam o zaman gerekenleri yapıp deniz kumu kullanacağım.";}, 1572939232, 1713529438
Run Time: 0.001439
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, 27540, a:1:{i:0;s:287:"Selam;
Kurulumunda başarılar dilerim, umarım aşamaları görsel olarak paylaşırsınız. Başarınıza görsel şahit olalım ve yorum katkılarıyla en güzelini hep birlikte kurmaya çalışalım. :) Malum kum konusunda olmaz diye yanıt almadığınız tek platformdasınız. :F";}, 1572939232, 1713529438
Run Time: 0.001313
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, 27541, a:1:{i:0;s:171:"Güzel kardeşim birşey eklemek isterim Denizle falan uğraşma, inşaat kumunu tertemiz yıka kullan,ben kullanıyorum...
(İşte Şimdi heryerde öcü ilan edileceğiz)";}, 1572939232, 1713529438
Run Time: 0.001204
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, 27542, a:1:{i:0;s:134:"Abi bakırköyde inşatta girince dövmesinler yahu.Bide benim bildiğim inşatta bir çok çeşit kum kullanıyolar hangisi olabilir.";}, 1572939232, 1713529438
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, 27543, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:9:"YIKIKTEMO";s:8:"original";a:2:{i:0;s:18:"[quote=YIKIKTEMO ]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:289:"
Selam;
Kurulumunda başarılar dilerim, umarım aşamaları görsel olarak paylaşırsınız. Başarınıza görsel şahit olalım ve yorum katkılarıyla en güzelini hep birlikte kurmaya çalışalım. :) Malum kum konusunda olmaz diye yanıt almadığınız tek platformdasınız. :F
";}}i:1;s:140:"
Tabi ki temel abi .Böyle kaliteli biir forumda paylaşmıcam da nerde paylaşcam.Hem siz abilerimin yorumları benim için çok önemlidir";}, 1572939232, 1713529438
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, 27544, a:1:{i:0;s:331:"Barış; Emrah doğru bir noktaya değinmiş.Deniz kumunu yıkamak oldukça zahmetli ve bir okadarda zor bir iştir. :hasta: Buna nazaran inşaat kumunu yıkamak daha kolay. Bir inşaat tan rica etsen ücretsiz dahi alabilirisin. ;) Bu kumlar aynı deniz kumu görünümünde fakat tatlı su kumudur. Yani genellikle dere kumu. ;)";}, 1572939232, 1713529438
Run Time: 0.001443
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, 27545, a:1:{i:0;s:79:"Ya abi o zaman dereden toplasam olmaz mı?Buralarda hiç inşaatçı yokta huh:";}, 1572939232, 1713529438
Run Time: 0.001271
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, 27546, a:1:{i:0;s:54:"Dere varmı ? dere varsa kum ala ama çok iyi yıka ;)";}, 1572939232, 1713529438
Run Time: 0.001243
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, 27547, a:1:{i:0;s:65:"Köyde var abi bakırköyde ne arar:dGidince bi ara toplarım. :D";}, 1572939232, 1713529438
Run Time: 0.001114
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, 27548, a:1:{i:0;s:215:"Bakırköy de köy ya işte gizli: sakat işler yapıyorsun ama, baştan söylemedi deme, akvaryumcudan kum alman senin için daha hayırlısı ama illede kullanacağım diyorsan inşaatlardan rica edersin verirler.";}, 1572939232, 1713529438
Run Time: 0.001174
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, 27549, a:1:{i:0;s:50:"Dediğim dere 10 cm ya var ya yok abi :F :D dance:";}, 1572939232, 1713529438
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, 27550, a:1:{i:0;s:268:"Akvaryumcuya gidipte kum almak saçma zaten.Ben dökümcüden bedava 100kg silis kum aldım.Akvaryumcudan alsaydım 200tl kum.3 tane çok sevdiğim arkadaşım,Antalya ve Mersin sahilindeki kumları akvaryumlarında kullanıyorlar.Anlatıldığı gibide yıkamadılar.";}, 1572939232, 1713529438
Run Time: 0.001130
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, 23, a:1:{i:0;a:4:{s:3:"tag";s:6:"center";s:6:"option";N;s:8:"original";a:2:{i:0;s:8:"[center]";i:1;s:9:"[/center]";}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;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"4";s:8:"original";a:2:{i:0;s:10:"[SIZE="4"]";i:1;s:7:"[/SIZE]";}s:8:"children";a:1:{i:0;s:25:"Sadece ve sadece MBUNA...";}}}}}}}, 1572939232, 1713529438
Run Time: 0.001491
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, 27551, a:1:{i:0;s:53:"Ama genede güvenlik için yıkamak gerekmez mi? huh:";}, 1572939232, 1713529438
Run Time: 0.001324
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 = 2622)
LIMIT 1
Run Time: 0.000674
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.000189
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |