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.000494
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.003191
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: 6917
Run Time: 0.001713
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: 5
Run Time: 0.000724
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: 6917
Run Time: 0.004147
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | post | range | thread_id_post_date,thread_id_position | thread_id_position | 8 | | 20 | Using index condition; 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: 6917
Run Time: 0.000080
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 52db067678129af714818bc71498a709, , 1714078087
Run Time: 0.000194
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=6917, 1714074487,
Run Time: 0.000110
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000304
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, 79070, a:1:{i:0;s:485:"Selamler..
Akvaryumumda 3 moli 3lepistes var.Ama ben hangileri dişi hangileri erkek hala ayırt edemiyorm.Balıklarımı aldığım yerde "dişi istiyorum" diye aldığım balıkla adamın bana "bu erkek olan bu dişi olan" dediği iki balık arasında hiçbir fark göremiyorum.
Molilerin kuyruğuna bakmam söylenmişti ama kuyrukları da aynı sanki.
Moli ve lepisteslerin erkek ve dişi olanlarının fotolarıyla açıklarsanız çok memnun kalıcam.
Teşekkürler...";}, 1572939232, 1714074487
Run Time: 0.001639
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, 4977, a:1:{i:0;s:19:"..AsLA KaBullenME..";}, 1572939232, 1714074487
Run Time: 0.001869
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, 79071, a:1:{i:0;s:148:"Canlı doğuran türlerinde, cinsiyet ayrımı anal yüzgeçlerinden belli olur, erkeklerinde Gonopod (Piştov:F) bulunur. dişilerde bulunmaz Mert.";}, 1572939232, 1714074487
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, 79072, a:1:{i:0;s:62:"Teşekkür ederim.. Lepisteslerde de aynı şey geçerli dimi?";}, 1572939232, 1714074487
Run Time: 0.001269
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, 79073, a:1:{i:0;s:126:"Bu türde bariz belirgin bir yapı farkı vardır. Renkli ve daha küçük yapıdadır erkekleri. Kolayca ayrım yapabilirsin.";}, 1572939232, 1714074487
Run Time: 0.001238
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, 79074, a:1:{i:0;s:60:"Üstteki dişi alttaki erkek mi oluyor. Öğrenmiş miyim :)";}, 1572939232, 1714074487
Run Time: 0.001126
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, 79075, a:3:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:22:"bozüyük, post: 79074";s:8:"original";a:2:{i:0;s:32:"[quote="bozüyük, post: 79074"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:60:"Üstteki dişi alttaki erkek mi oluyor. Öğrenmiş miyim :)";}}i:1;s:80:"
Aynen öyle oluyor. :) Peki aşağıda hangisi erkek ve dişi ? :helalolsun:
";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:"http://content.answers.com/main/content/img/BritannicaConcise/images/11329.jpg";}}}, 1572939232, 1714074487
Run Time: 0.001621
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, 79076, a:1:{i:0;s:32:"Sanırım üst erkek alt dişi..";}, 1572939232, 1714074487
Run Time: 0.001888
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, 79077, a:1:{i:0;s:13:"Doğrumudur??";}, 1572939232, 1714074487
Run Time: 0.001334
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, 79078, a:1:{i:0;s:21:"Tebrikler olay budur.";}, 1572939232, 1714074487
Run Time: 0.001134
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, 79079, a:1:{i:0;s:632:"Tamamdır öğrendim :) Çok teşekkür ederim Temel abi. Umarım yeni gelen arkadaşlarda bu konuyu okuyarak burdan bilgi alırlar.
Az önce balıklara baktım da.. Lepisteslerde sorun yok.2 dişi 1 erkek. Ama molilerde bu kadar şanslı değilim :( 2 erkek 1 dişi var.
Bu konu hakkında soru sormak istiyorum.
2 dişi 1 erkek ideal diyosunuz. Ama moliler böyle değil malesef.Okuduklarıma göre bu iki erkek moli dişi için kavga edecekler.Fakat yaklaşık iki saat önce onları izlerken dişi ver erkek yan yana falan yüzüyorlardı. Ve yanılmıyosam çiftleştiler. Ama diğer erkek hiç karşı çıkmadı bu duruma :)";}, 1572939232, 1714074487
Run Time: 0.001385
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, 79080, a:1:{i:0;s:227:"Lepisteslerin erkekleri çok kibardır.Renkleride çok hoştur.Dişiler makyajsız ve gösterişsiz oluyorlar.Erkekler kokoş yani :D :D
Mert balık takas yapalım .İstersen dişilerle erkekleri yüz yüze konuşalım ? :D";}, 1572939232, 1714074487
Run Time: 0.001217
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, 79081, a:1:{i:0;s:91:"Tamam Kerem sana bir erkek moli verebilirim.Yarın gitar kursunda konuşuruz daha detaylı.";}, 1572939232, 1714074487
Run Time: 0.000997
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, 79082, a:1:{i:0;s:196:"Yarın 30 ağustos resmi tatilmiş heryer sanırım kurs yoktur . Bendede erkek çok 1 dişi 3 erkek moli var . :( Ama erkekleri götürüp dişiyle takas olabilir .Akvaryumcuyla konuşmak lazım.";}, 1572939232, 1714074487
Run Time: 0.001147
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, 79083, a:1:{i:0;s:105:"yaa bir şey sorcaktım bende koiler var ama cinsiyetlerini anlıyamıyorm yardım eder misiniz:smiley33:";}, 1572939232, 1714074487
Run Time: 0.000997
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, 79084, a:1:{i:0;s:194:"Aşağıdaki tecrübeler yardımcı olabilir. Üretimini yapan genç kardeşimizin tecrübeleri de var. Koi ve Japon balıkları ayrı tabi ama fikir verecektir üremeleri yakınlık arz ediyor.";}, 1572939232, 1714074487
Run Time: 0.001095
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, 79085, a:1:{i:0;s:50:"Aşağıdaki vatozum Koilerle sorun yaratır mı ?";}, 1572939232, 1714074487
Run Time: 0.001093
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, 79086, a:1:{i:0;s:39:"Sorun yaratacağını düşünmüyorum.";}, 1572939232, 1714074487
Run Time: 0.001108
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, 79087, a:1:{i:0;s:111:"Tamam ama arada siyah beyaz bir tane koi var karnı şiş. 7-8 cm boyunda onu tırtıklıyor toplam 6 koi var.";}, 1572939232, 1714074487
Run Time: 0.001023
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, 79088, a:1:{i:0;s:70:"Tırtıklıyor derken ? Balıkta bir zarar veya yara oluşturuyor mu ?";}, 1572939232, 1714074487
Run Time: 0.001350
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, 79089, a:1:{i:0;s:74:"Yara falan yok. tırtıklıyor yani dokunup duruyor alın size akvaryumum.";}, 1572939232, 1714074487
Run Time: 0.001049
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 = 6917)
LIMIT 1
Run Time: 0.000613
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.000221
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.000160
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |