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.000440
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.000184
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: 7634
Run Time: 0.000429
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: 104
Run Time: 0.000383
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: 7634
Run Time: 0.002007
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: 7634
Run Time: 0.000161
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 4942f46f425e0381298befab256d47f8, , 1711703195
Run Time: 0.000183
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=7634, 1711699595,
Run Time: 0.000141
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000325
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, 87821, a:3:{i:0;s:155:"Özellikle İstanbul anadolu yakasında oturan hobici dostlar, bir hafta sonu kadıköy sahilinde çay ve simit partisi yapsak, kimler katılmak ister?
";i:1;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://img132.imageshack.us/img132/3764/simitcay.jpg";}}i:2;s:278:"
Koyu sohbet, bol bol çay ve simit, mis gibi sahil havası?
Meşhur balonun sahil tarafındaki küçük cafeterya'yı düşünmekteyim. Hafta sonunuzda 1 saatinizi ayırır mısınız?
Dip not : Havalar soğudu bahanesini kullanmayalım, katılımı arttıralım ;) :)";}, 1572939232, 1711699595
Run Time: 0.002214
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, 87822, a:1:{i:0;s:67:"Olabilir evet, katılıma bakalım bir duruma göre hareket edelim.";}, 1572939232, 1711699595
Run Time: 0.001228
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, 87823, a:1:{i:0;s:88:"Belli olmaz belkim bende gelirim:) Ama sabahın erken saatlerinde olursa katılabilirim.";}, 1572939232, 1711699595
Run Time: 0.000961
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, 87824, a:1:{i:0;s:177:"Herkes geç saat ister Özgür erken gelirim diyor :D :D :D
Temel abi sensiz olmaz zaten. Bak katılım çok olursa annemi kandırır, kek-börek falan yaptırabilirim ;) ;) ;)";}, 1572939232, 1711699595
Run Time: 0.000985
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, 87825, a:1:{i:0;s:133:"Bizim iş öğlene doğru başlıyor o yüzden :).
Bu arada balon çalışıyor mu çalışıyorsa onada cıkıp resim çekelim :D";}, 1572939232, 1711699595
Run Time: 0.001309
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, 87826, a:1:{i:0;s:69:"Hava durumuna bağlı Özgür. Rüzgar yoksa sorun yok. Çıkarız ;)";}, 1572939232, 1711699595
Run Time: 0.001111
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, 87827, a:1:{i:0;s:96:"Merhaba,
Güzel bir fikir. Son görüşmeden bu yana sanırım üç yıl geçti. Ben gelirim.";}, 1572939232, 1711699595
Run Time: 0.001127
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, 87828, a:1:{i:0;s:67:"Özledik valla Tamer abi seni. Takım sohbeti yok ama ona göre. :F";}, 1572939232, 1711699595
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, 87829, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:22:"YIKIKTEMO, post: 87828";s:8:"original";a:2:{i:0;s:32:"[quote="YIKIKTEMO, post: 87828"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:37:" Takım sohbeti yok ama ona göre. :F";}}i:1;s:260:"
İlk başta jeton düşmedi valla. Sonradan anladım. Şu mevzu değil mi? Ben unuttum hocam bu konuları ya. İnan aklıma bile gelemedi okuduğumda. Ben bıraktığınız yerde değil sevgili kardeşim. :cicek:
Görüşmek üzere. :hepiniziseviyorum:";}, 1572939232, 1711699595
Run Time: 0.000978
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, 87830, a:1:{i:0;s:142:"hasanaytekin
YIKIKTEMO (Temel Sert)
zgrkaralar (Özgür Karalar)
taygun (Tamer Aygün)
Okey 4'lüsü tamam gibi görünüyor ;)
Evet başka?";}, 1572939232, 1711699595
Run Time: 0.001090
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, 87831, a:1:{i:0;s:134:"Gün ve saati kararlaştırdığınızda, bende dahil olabilirim. Benim yerime gelirseniz her saat ve gün olabilir, çaylarda benden.";}, 1572939232, 1711699595
Run Time: 0.001221
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, 87832, a:1:{i:0;s:82:"Günü ve saati belirlerseniz işin durumuna göre bende katılmaya çalışırım";}, 1572939232, 1711699595
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, 87833, a:1:{i:0;s:57:"Abi bende gelmek isterim ama yaş 12.Nasıl geliyim?:por:";}, 1572939232, 1711699595
Run Time: 0.001014
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, 87834, a:1:{i:0;s:190:"Abilerim kardeşlerim, genelde müsait olduğunuz gün ve saatleri yazar mısınız? Bir plan yapalım.
@berkan; aileden izin alıp gelebilirsen bekleriz. Hatta ailenle bile gelebilirsin ;)";}, 1572939232, 1711699595
Run Time: 0.000968
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, 87835, a:1:{i:0;s:354:"Bilgisayarı abime yollamamdan dolayı artık gündüzleri telefondan girebiliyorum. Fakat mesaj yazmak çok zor oluyor telefondan. Akşamları ise babamın leptopundan kaldığım yerden devam ediyorum :) Takipteyim yani ;)
Bende katılırım. Şimdiye kadar gidilecek bir çok yer önerdim hiç katılım olmadı. Umarım bu etkinlikle toplanırız.";}, 1572939232, 1711699595
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, 2334, a:2:{i:0;s:24:"58 LT Nano Reef - ";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:109:"http://akvaryumportali.com/threads/sumpl%C4%B1-nano-reef-kurulumu-tuzlu-suya-geri-d%C3%B6n%C3%BC%C5%9F.12404/";s:8:"original";a:2:{i:0;s:117:"[url="http://akvaryumportali.com/threads/sumpl%C4%B1-nano-reef-kurulumu-tuzlu-suya-geri-d%C3%B6n%C3%BC%C5%9F.12404/"]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:75:"Sumplı Nano Reef Kurulumu ( Tuzlu Suya Geri Dönüş ) | Akvaryum Portalı";}}}, 1572939232, 1711699595
Run Time: 0.001222
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, 87836, a:1:{i:0;s:120:"Biz de avrupa yakasında bir çıkartma yaparız :) Uygun zaman olursa tabi.
Volkan Abi , akımı başlatsın artık :)";}, 1572939232, 1711699595
Run Time: 0.001196
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, 9, 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:"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: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:1:{i:0;a:4:{s:3:"tag";s:1:"u";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[U]";i:1;s:4:"[/U]";}s:8:"children";a:1:{i:0;s:17:"TEKRARDAN DİSCUS";}}}}}}}}}, 1572939232, 1711699595
Run Time: 0.001408
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, 87837, a:1:{i:0;s:337:"Gördüğüm kadarıyla konu sulanmaya doğru gidiyor.
Aslında Hasan Bey'in ilk mesajında resimin çekildiği yerde buluşsak ne güzel olur. Deniz kıyısı. Açık hava, oranın kapalısı da var. Anladım kadarıyla resim Çengelköy Çınaraltı'nda çekilmiş. Balığı sevenler deniz kenarında buluşmazlar mı?
Saygılar";}, 1572939232, 1711699595
Run Time: 0.001035
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, 87838, a:1:{i:0;s:253:"Tamer abi uygun bir hafta sonu yaparız fotoğraftaki yerde olur güzel yer. Önemli olan süreyi dengelemek bildiğin gibi. Bu konu gündem de haftaya pazar günü olarak bir gün belirleyelim ve yorumlara veya uygunlğuna bakarak netleştirelim bence.";}, 1572939232, 1711699595
Run Time: 0.001667
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, 87839, a:1:{i:0;s:102:"Güzel bir buluşma olacak gibi görünüyor.Tarih uygun olursa bende katılırım.:hepiniziseviyorum:";}, 1572939232, 1711699595
Run Time: 0.000939
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, 1711699595
Run Time: 0.001327
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, 87840, a:1:{i:0;s:91:"Bana uyar Temel. Haftaya Pazar günü 9.Aralık'tır. İki saat de birbirimiz görsek olur.";}, 1572939232, 1711699595
Run Time: 0.000948
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 = 7634)
LIMIT 1
Run Time: 0.000398
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: 103
Run Time: 0.000163
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |