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.000457
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.000162
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: 7141
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: 97
Run Time: 0.000369
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: 7141
Run Time: 0.001892
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 | 6 | 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: 7141
Run Time: 0.000079
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 9c24b9ab0b41ce46273daef917ed4d25, , 1713494379
Run Time: 0.000191
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=7141, 1713490779,
Run Time: 0.000121
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000258
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, 82102, a:14:{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:15:"Uçan balıklar";}}i:1;s:112:"
[video=youtube;JIbCKctKm58]http://www.youtube.com/watch?v=JIbCKctKm58&feature=player_embedded[/video]
";i:2;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:43:"http://img580.imageshack.us/i/82287103.jpg/";s:8:"original";a:2:{i:0;s:49:"[URL=http://img580.imageshack.us/i/82287103.jpg/]";i:1;s:6:"[/URL]";}s:8:"children";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:52:"http://img580.imageshack.us/img580/4356/82287103.jpg";}}}}i:3;s:54:"
Dünyada 50 cinstan fazla uçan balık var.
";i:4;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:43:"http://img832.imageshack.us/i/99355992.jpg/";s:8:"original";a:2:{i:0;s:49:"[URL=http://img832.imageshack.us/i/99355992.jpg/]";i:1;s:6:"[/URL]";}s:8:"children";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:52:"http://img832.imageshack.us/img832/2866/99355992.jpg";}}}}i:5;s:657:"
Uçan balık, Exocoetidae familyasını oluşturan balık türlerinin ortak adı.
50 cinsten oluşan familyaya ait balıklar yüzgeçlerini kanat olarak kullanıp kısa mesafeleri uçabilirler. Çoğunun görünüşleri sardalyalara benzer ama bunlarla akrabalıkları yoktur.
Uçan balıklar özellikle tropik ve subtropik denizlerde bulunurlar. Bu familyanın Türkiye'de ki Exocoetus volitans türü, güney Ege denizi veAkdeniz'de bulunur.
Uçan balıklar 1,5 metre yükseklik ile 2,5 metreye kadar uçabilirler. Bazen uçuş yükseklikleri 5 metreye bile varabilir ve böylece bazen yanlışlıkla küçük teknelerin içine düşebilirler
";i:6;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:43:"http://img175.imageshack.us/i/33963507.jpg/";s:8:"original";a:2:{i:0;s:49:"[URL=http://img175.imageshack.us/i/33963507.jpg/]";i:1;s:6:"[/URL]";}s:8:"children";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:52:"http://img175.imageshack.us/img175/9224/33963507.jpg";}}}}i:7;s:4:"
";i:8;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:42:"http://img39.imageshack.us/i/50499418.jpg/";s:8:"original";a:2:{i:0;s:48:"[URL=http://img39.imageshack.us/i/50499418.jpg/]";i:1;s:6:"[/URL]";}s:8:"children";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:50:"http://img39.imageshack.us/img39/8738/50499418.jpg";}}}}i:9;s:18:"
Uploaded with ";i:10;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:20:"http://imageshack.us";s:8:"original";a:2:{i:0;s:26:"[URL=http://imageshack.us]";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:13:"ImageShack.us";}}i:11;s:1384:"
Akdeniz uçan balığı (Exocoetus volitans), Exocoetidae familyasına Akdeniz'e özgü bir balık türü. Antik çağın büyük düşünürü Aristoteles'in yazılarında bile sözü edilmektedir.
Akdeniz uçan balığı 200 metreye kadar uçabilir. Güney Ege ve Akdeniz'de dibe inmeden deniz yüzeyinde yaşar. Bazen büyük balıklardan kurtulmak, bazen de 80 km/sa.'i bulan yüzme hızı gereği, su yüzeyinden 25-50 cm yükselip büyük kanatlarıyla 2-13 sn. ve 50-250 m'lik planör uçuşları yapar. Bu uçma şekli kuşların uçuşu gibi değildir; balık sudan dışarıya sıçrar, göğüs ve karın yüzgeçlerini gerip yelken olarak kullanır ve böylece 200 metreye kadar havada ilerleyebilir. Tekrar suyla temasa geldiğinde, kuyruk yüzgeci ile yaptığı çok hızlı bir haraket ile tekrar havalanabilir. Bunu birkaç kez peşpeşe tekrarlayabilir. Genelde balıkların bu uçma kabiliyetlerini kendilerini yemek isteyen büyük balıklardan kaçmak için kullandıkları düşünülür.Saros körfezindede bulunurlar kıyıya yakın sığ kumlukta insan tarafından sıkıştırılınca kaçmak için hızlanıp 40-50 cm su yüzeyinden yükselerek 70-80 metre uçar. Alexander von Humboldt ise uçan balıkların bunu sırf keyiflerinden yaptıklarını savunmuştur.
Planktonlar, omurgasızlar ve yavru balıklarla beslenir. Boyu 20-30 cm. olabili
";i:12;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:43:"http://img214.imageshack.us/i/90819013.jpg/";s:8:"original";a:2:{i:0;s:49:"[URL=http://img214.imageshack.us/i/90819013.jpg/]";i:1;s:6:"[/URL]";}s:8:"children";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:52:"http://img214.imageshack.us/img214/3742/90819013.jpg";}}}}i:13;s:102:"
Uçan balıklar özellikle tropik ve subtropik denizlerde bulunurlar.
Saygılar.
Erdal Duneray";}, 1572939232, 1713490779
Run Time: 0.002002
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, 82103, a:1:{i:0;s:79:"İlk defa böyle bir balık türü ile karşılaştım.Gerçekten çok ilginç.";}, 1572939232, 1713490779
Run Time: 0.001036
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, 393, a:2:{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;s:21:"HOBİYE UZUN BİR ARA";i:1;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:0:{}}}}i:1;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#FF0000";s:8:"original";a:2:{i:0;s:17:"[COLOR="#FF0000"]";i:1;s:8:"[/COLOR]";}s:8:"children";a:0:{}}}, 1572939232, 1713490779
Run Time: 0.001471
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, 82104, a:1:{i:0;s:23:"İnanılmaz ama gercek.";}, 1572939232, 1713490779
Run Time: 0.001107
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, 82105, a:1:{i:0;s:15:"Çok ilginç...";}, 1572939232, 1713490779
Run Time: 0.000888
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, 82106, a:1:{i:0;s:103:"Bu zamana kadar hiç böyle bir şey ne gördüm ne de duydum. Çok ilginç ve olağan üstü bir şey.";}, 1572939232, 1713490779
Run Time: 0.000925
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, 5398, a:1:{i:0;s:184:"4 sarı prenses: 1 e 3 d----4 mavi prenses 1 e 3 d
Mavi prensesten 3. parti yolda: ) Sarı prenseslerden 1. parti yola.:) Sultan papağanımız efe (3) yaşında erkek bir sultancık.";}, 1572939232, 1713490779
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, 82107, 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:22:"Cevap: Uçan balıklar";}}i:1;s:115:"
Uçan Balık, bir de bunun oyuncak olanı var bizim çocuğa almıştık. Air swimmers o da eğlenceli bi şey :)";}, 1572939232, 1713490779
Run Time: 0.000980
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 = 7141)
LIMIT 1
Run Time: 0.000443
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: 98
Run Time: 0.000170
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: 166
Run Time: 0.000144
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.000181
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |