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.000570
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.000167
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: 6140
Run Time: 0.000437
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: 77
Run Time: 0.000372
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: 6140
Run Time: 0.004654
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: 6140
Run Time: 0.000084
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 3796e66a412db891135838596e203082, , 1714027104
Run Time: 0.000198
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=6140, 1714023504,
Run Time: 0.000112
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000260
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, 65795, a:11:{i:0;s:421:"Pratik Ozan merhaba der.super:gif super:gif super:gif
Bu paylaşımda minik akvaryumların sifonlamısıyla oynıycaz.tek balıklı betta akvaryumu ne biliyim fanus olur bunlara sifonlama yapmanın tekniğini Do it yourself olarak çözecez.Bu kıl işlerle uğraşma demeyin ha. :D Mesela akvaryum küçük buna nasıl sifonlama yapacaksın bir çekişte su biter.Aşağıdaki projeyi devreye alacağız o zaman.
";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:26:"http://www.yukleresim.com/";s:8:"original";a:2:{i:0;s:32:"[URL=http://www.yukleresim.com/]";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:57:"http://www.yukleresim.com/images/0pyyxz45ep0aw9qqblv2.gif";}}}}i:2;s:232:"
Amaç şişe içinden havayı boşalttığımızda yani şişeyi sıkıp bıraktığımızda şişe eksilen hava yerine akvaryumdan su çekecek.ne kadar hava eksilirse o kadar hızlı su çeker. super:gif super:gif super:gif
";i:3;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:26:"http://www.yukleresim.com/";s:8:"original";a:2:{i:0;s:32:"[URL=http://www.yukleresim.com/]";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:55:"http://www.yukleresim.com/images/th03llff4wjehqtrzh.jpg";}}}}i:4;s:462:"
Kola şişesinin kapağına iki delik açıyoruz.deliklerin birine hava hortumu takıyoruz hortum akvaryum dib temizliği yapacak uzunlukta olacak.öbür deliğin üstüne yarım şekilde cekvalf görevi görecek bir naylon yapıştırıyoruz.şişeyi sıkınca hava rahat çıkacak şişe içinden ama bıraktığımızda naylon deliği kapatarak cekvalf görevi görecek.mecburen boşluk akvaryumdan su çekerek kapanacak. super:gif super:gif super:gif
";i:5;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:26:"http://www.yukleresim.com/";s:8:"original";a:2:{i:0;s:32:"[URL=http://www.yukleresim.com/]";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:57:"http://www.yukleresim.com/images/04k4ubk8u5kpev0m120c.jpg";}}}}i:6;s:277:"
Bu kadar basit.Umarım işe yarar.İlk önce daha basit bir plan yaptım ama üstteki daha çok hoşuma gitti.İlk yaptığım aşağıdaki. Sıvı sabun pompasıaynı işi görür çalışması su içinde pompaya basmaya dayanıyor.suyu istediğimiz hızda alabiliriz.
";i:7;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:26:"http://www.yukleresim.com/";s:8:"original";a:2:{i:0;s:32:"[URL=http://www.yukleresim.com/]";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:56:"http://www.yukleresim.com/images/quy57s3wrd00epkwrn2.bmp";}}}}i:8;s:4:"
";i:9;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:26:"http://www.yukleresim.com/";s:8:"original";a:2:{i:0;s:32:"[URL=http://www.yukleresim.com/]";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:57:"http://www.yukleresim.com/images/6ndbonb4p9v95zbqeku7.bmp";}}}}i:10;s:81:"
görüşmek üzere.pratik Ozan saygılar sunar. super:gif super:gif super:gif";}, 1572939232, 1714023504
Run Time: 0.002579
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, 10, a:1:{i:0;s:61:"Ozan Sıdal- İstanbul...Het türlü aleti yapılır bozulur.";}, 1572939232, 1714023504
Run Time: 0.002053
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, 65796, a:1:{i:0;s:307:"Dıy konuları gezerken rastladım bu çalışmana Ozan. Hayret aslında dıy yapımlar ilk dikkatimi çeken konulardır fakat nasıl olduysa bu çalışmanı gözden kaçırmışım. :cekingen:
Ozan gene döktürmüşsün kardeşim tebrik ederim. Harika bir çalışma olmuş eline emeğine sağlık.em34:";}, 1572939232, 1714023504
Run Time: 0.001424
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, 1714023504
Run Time: 0.001516
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, 65797, a:1:{i:0;s:232:"Ben de kaçırmışım bunu itiraf etmek gerekirse. Şık bir paylaşım ellerine sağlık Ozan. Proje tam bizim cımbızla bitkili akvaryum peyzajı yapan İsmai'in minik akvaryumuna göre. Değerlendirir bunu inşallah. :basardim:";}, 1572939232, 1714023504
Run Time: 0.001608
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, 65798, a:1:{i:0;s:141:"Haydaa. Ben de yeni gördüm. :S Epey bi gözden kaçmış konu.
Ozan abi her zamanki gibi değerli çalışmalarından biri. Tebrik ederim.";}, 1572939232, 1714023504
Run Time: 0.001224
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, 317, a:1:{i:0;s:101:"Gün gelecek aydınlıkta dahi zikretmekten korktuğunuz hakikati , karanlıklarda zikredeceksiniz...";}, 1572939232, 1714023504
Run Time: 0.001673
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, 65799, a:1:{i:0;s:93:"Eyvallah abilerim benim.Biraz zaman bulsam neler olacak pratik Ozan her an devrede. super:gif";}, 1572939232, 1714023504
Run Time: 0.001233
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, 65800, a:1:{i:0;s:137:"Orta boy akvaryumlarda da damacana pompası kullanılabilir.Aslında ben bunu önceden düşünydüm fakat ozan benden önce davranmış.";}, 1572939232, 1714023504
Run Time: 0.000903
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, 2461, a:1:{i:0;s:62:"Kendini bugüne kaptıranlar kendine kurşun sallayanlardır..";}, 1572939232, 1714023504
Run Time: 0.001663
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 = 6140)
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: 167
Run Time: 0.000174
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.000150
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |