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.000451
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.000156
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: 16452
Run Time: 0.000392
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: 7
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: 16452
Run Time: 0.003387
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 |
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 (255577)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000845
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 5 | 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: 16452
Run Time: 0.000071
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 730179626bb1db5a60b1ede07d3794b8, , 1711785284
Run Time: 0.000166
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=16452, 1711781684,
Run Time: 0.000101
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000243
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, 255577, a:11:{i:0;s:496:"Merhaba internetten ve çevreden edindiğim bilgilerle kendi başıma bir girişimde bulunup canlı doğuran tankım için yem yapmaya karar verdim :)
Öncelikle Malzemeler:
1) 10-15 kök ıspanak
2) 5 6 dal maydanoz 2 3 yaprak marul
3) 1 çorba kaşığı un veya mısır unu
4) 2 diş sarımsak (1. suyuna 2. içine)
5) 1 çay kaşığı tuz - evde bulunan
6) 1 çay bardağı balık yemi
7) Yağlı kağıt
İsteğe göre malzemelere tavuk ciğeride eklenebilir denemedim.
1. aşama
";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:"13251";}}i:2;s:133:"
Ispanağımızı yıkadık köklerinden ve uzun saplarından temizledik yemi sıcak suda yumuşaması için beklettik.
2. aşama
";i:3;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:"13252";}}i:4;s:94:"
Yem yumuşadı ve ıspanağımızı haşladık suyunu süzdük robotu kurduk.
3. aşama
";i:5;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:"13253";}}i:6;s:347:"
Haşlanan ıspanağı robota koyduk bu aşamada 1 çorba kaşığı un 1 çay kaşığı tuz ve yumuşayan yemlerimizi koyduk robotta çektik.
Daha sonra Yağlı fırın kağıdına serdik kaşık yardımıyla kağıda püreyi iyice yayıp incelttim ve kuruttum.
Gördüğünüz gibi kağıt gibi oldu yağlı kağıttan kalkınca.
4. aşama
";i:7;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:"13254";}}i:8;s:64:"
kuruduktan sonra üfelendikten sonra pul yemin son durumu.
";i:9;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:"13255";}}i:10;s:261:"
Ve yemin son hali :)))
Pul yemden biraz ağır olduğu için direk dibe çöküyor. Vatoz çöpçü vs dip balıkları için uygun bir yem ayrıca canlı doğuran lepistesler molilerde yiyor tadı beğenildi anlaşılan :))
İyi Forumlar Hayırlı Günler.";}, 1572939232, 1711781684
Run Time: 0.001902
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, 255581, a:1:{i:0;s:214:"Ellerine sağlık.
Özellikle son hali güzel görünüyor. Başka katkılarla da zenginleştirilebilir.
Dibe çökmesi de bence güzel.
Suda dağılması ne durumda? Çabuk dağılıyorsa jelatin kullanılabilir.";}, 1572939232, 1711781684
Run Time: 0.001487
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, 255584, a:1:{i:0;s:220:"Sağolun teşekkür ederim. Evet havuç vs zenginleştirilir ama tadını beğenirlermi bilemiyorum şuan yiyorlar bu yemi. Suda dağılmamasının neden un bence yapıştırıp sağlamlaştırıyor suyu bulandırmıyor.";}, 1572939232, 1711781684
Run Time: 0.001029
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, 255590, a:1:{i:0;s:172:"Ne güzel pul yem.:)
Zenginleştirmek mümkün evet, içine kivi, muz, nori ve sıvı vitamin eklenebilir ama bu da tek başına gayet başarılı olmuş kutlarım.temo19";}, 1572939232, 1711781684
Run Time: 0.001001
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, 255595, a:1:{i:0;s:68:"Üşenmezsem bir ara yaparım :D
Un yerine ekmekde kullanılabilir.";}, 1572939232, 1711781684
Run Time: 0.001182
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, 255597, a:1:{i:0;s:277:"Teşekkür ederim temel abi :D aynı zamanda salatalık havuç vs de konabilir ama tadı beğenilirmi onu bilemiyorum o kadar emek verip yaparsın ama balıklar beğenmezse kötü olur mesela :D
Ben evdeki olan malzemelerle bunu yaptım toplam maliyeti 1 lira oda ıspanak :D";}, 1572939232, 1711781684
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, 255598, a:1:{i:0;s:124:"Çok haklısın ama küçük de olsa zenginleştirme yaparak denemek lazım. Pul yeme bayıldık merak etme süper olmuş.:)";}, 1572939232, 1711781684
Run Time: 0.001091
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, 255599, a:1:{i:0;s:42:"Sağol Temel abi çok teşekkür ederim :)";}, 1572939232, 1711781684
Run Time: 0.000995
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, 255613, a:1:{i:0;s:160:"Ellerinize sağlık.Hem daha taze,Hemde normal bir yeme gore daha fazla direnc kazandıracağı konusunda şuphem yok.Troplara deneyebilirim belki.
Teşekkurler";}, 1572939232, 1711781684
Run Time: 0.001123
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, 7371, 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;s:67:""Egemenlik kayıtsız ve şartsız milletindir. " M.Kemal Atatürk";}}}, 1572939232, 1711781684
Run Time: 0.001318
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, 255614, a:1:{i:0;s:246:"Eline sağlık Buğra süper yem olmuş, bunu dahada geliştirirsin yada bu formül böyle kalsın bu balıkların kabız olmamasını sağlar içinde ıspanak var, başka çeşit çeşit ve bir tanede daha çok protein ağırlıklı yaparsın...";}, 1572939232, 1711781684
Run Time: 0.001314
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, 7159, a:1:{i:0;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:34:"http://i.hizliresim.com/25yjPL.jpg";}}}, 1572939232, 1711781684
Run Time: 0.001205
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, 255734, a:1:{i:0;s:220:"Sağolun teşekkür ederim tavuk ciğerlisini deniyeceğim içine muz filan koyucam ama kokusu insanı bayıyor :D insallah yerler bunu afiyetle yiyorlar hele dibe çöktümü vatoz diğerlerine yedirmiyor kendi yiyor :D";}, 1572939232, 1711781684
Run Time: 0.001383
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 = 16452)
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: 165
Run Time: 0.000155
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT node.*
FROM xf_node AS node
WHERE node.node_id = ?
Params: 3
Run Time: 0.000153
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |