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.000493
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.000194
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: 22536
Run Time: 0.000531
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: 105
Run Time: 0.000407
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: 22536
Run Time: 0.002348
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: 22536
Run Time: 0.000085
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 55c8c305e70c6d14a3b8c59c5d8ffaea, , 1713612464
Run Time: 0.000190
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=22536, 1713608864,
Run Time: 0.000115
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000403
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, 380166, a:3:{i:0;s:115:"Merhaba arkadaşlar,
2 sene kadar tatlı su akvaryum maceralarımdan sonra, tuzlu suya merak sarmaya başladım ve ";i:1;a:4:{s:3:"tag";s:4:"user";s:6:"option";s:4:"8887";s:8:"original";a:2:{i:0;s:11:"[USER=8887]";i:1;s:7:"[/USER]";}s:8:"children";a:1:{i:0;s:5:"@ka2n";}}i:2;s:282:" ın önerisi ile siteye geldim.
Uzun zamandır da takipteyim, bir çok konu okudum, bir çok kurulum okudum,
Şimdi kendi kurulumum için hazırlıklar yapıyorum, Hazırlıklarım bitince kendi konumu açıp fikirlerinizi bekliyor olacağım,
Tekrardan herkese selamlar :çiçek:";}, 1572939232, 1713608864
Run Time: 0.001831
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, 380170, a:1:{i:0;s:100:"Hoşgeldiniz. Keyifli paylaşımlar dilerim. En kısa sürede kendi konunuzda görüşmek üzere ;)";}, 1572939232, 1713608864
Run Time: 0.001642
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, 380175, a:1:{i:0;s:51:"Hoş geldiniz keyifli paylaşımlar hayırlı olsun";}, 1572939232, 1713608864
Run Time: 0.001632
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, 380182, a:1:{i:0;s:107:"Hoşgeldiniz bence konuyu şimdiden açın malzeme alırken danışarak hatayı en aza indirmiş olursunuz.";}, 1572939232, 1713608864
Run Time: 0.001174
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, 380183, a:4:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:34:"Onurs, post: 380182, member: 10781";s:8:"original";a:2:{i:0;s:44:"[QUOTE="Onurs, post: 380182, member: 10781"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:107:"Hoşgeldiniz bence konuyu şimdiden açın malzeme alırken danışarak hatayı en aza indirmiş olursunuz.";}}i:1;s:285:"
Teşekkür ederim ilginiz için, malzemelerin bir çoğu tamam, sadece PS ve Armatür kaldı, onları da bu işin ustası bi arkadaş yardımcı oluyor saolsun, o yüzden sıkıntı yok.
Dediğiniz gibi tek başıma olsam zaten en başında açardım ne yapmalıyım diye :)
Neyse ki ";i:2;a:4:{s:3:"tag";s:4:"user";s:6:"option";s:4:"8887";s:8:"original";a:2:{i:0;s:11:"[USER=8887]";i:1;s:7:"[/USER]";}s:8:"children";a:1:{i:0;s:5:"@ka2n";}}i:3;s:11:" var temo21";}, 1572939232, 1713608864
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, 380185, a:4:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:43:"Gökşen ÜNER, post: 380183, member: 11373";s:8:"original";a:2:{i:0;s:53:"[QUOTE="Gökşen ÜNER, post: 380183, member: 11373"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:3:{i:0;s:9:"Neyse ki ";i:1;a:4:{s:3:"tag";s:4:"user";s:6:"option";s:4:"8887";s:8:"original";a:2:{i:0;s:11:"[USER=8887]";i:1;s:7:"[/USER]";}s:8:"children";a:1:{i:0;s:5:"@ka2n";}}i:2;s:11:" var temo21";}}i:1;s:32:"
Kurulumdaki yardımları için ";i:2;a:4:{s:3:"tag";s:4:"user";s:6:"option";s:4:"8887";s:8:"original";a:2:{i:0;s:11:"[USER=8887]";i:1;s:7:"[/USER]";}s:8:"children";a:1:{i:0;s:5:"@ka2n";}}i:3;s:62:" ın Kırmızı gül istediğini pek düşünmüyorum :koptum:";}, 1572939232, 1713608864
Run Time: 0.001362
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, 380187, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:34:"Onurs, post: 380185, member: 10781";s:8:"original";a:2:{i:0;s:44:"[QUOTE="Onurs, post: 380185, member: 10781"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:3:{i:0;s:31:"Kurulumdaki yardımları için ";i:1;a:4:{s:3:"tag";s:4:"user";s:6:"option";s:4:"8887";s:8:"original";a:2:{i:0;s:11:"[USER=8887]";i:1;s:7:"[/USER]";}s:8:"children";a:1:{i:0;s:5:"@ka2n";}}i:2;s:62:" ın Kırmızı gül istediğini pek düşünmüyorum :koptum:";}}i:1;s:71:"
Kaan'ın kredisi sonsuz bende, ne istediğinin önemi yok Onur Bey ;)";}, 1572939232, 1713608864
Run Time: 0.001590
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, 380190, a:1:{i:0;s:13:"Hos geldiniz.";}, 1572939232, 1713608864
Run Time: 0.001434
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, 380197, a:3:{i:0;s:42:"O zaman biz çekilelim aradan nasıl olsa ";i:1;a:4:{s:3:"tag";s:4:"user";s:6:"option";s:4:"8887";s:8:"original";a:2:{i:0;s:11:"[USER=8887]";i:1;s:7:"[/USER]";}s:8:"children";a:1:{i:0;s:5:"@ka2n";}}i:2;s:15:" varmış ;) :D";}, 1572939232, 1713608864
Run Time: 0.001440
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, 380199, a:4:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:40:"MESUT_KERİM, post: 380197, member: 7859";s:8:"original";a:2:{i:0;s:50:"[QUOTE="MESUT_KERİM, post: 380197, member: 7859"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:3:{i:0;s:42:"O zaman biz çekilelim aradan nasıl olsa ";i:1;a:4:{s:3:"tag";s:4:"user";s:6:"option";s:4:"8887";s:8:"original";a:2:{i:0;s:11:"[USER=8887]";i:1;s:7:"[/USER]";}s:8:"children";a:1:{i:0;s:5:"@ka2n";}}i:2;s:15:" varmış ;) :D";}}i:1;s:33:"
Estafurullah olur mu öle şey ";i:2;a:4:{s:3:"tag";s:4:"user";s:6:"option";s:4:"7859";s:8:"original";a:2:{i:0;s:11:"[USER=7859]";i:1;s:7:"[/USER]";}s:8:"children";a:1:{i:0;s:13:"@MESUT_KERİM";}}i:3;s:194:" :)
Herkesin fikrini ihtiyacımız var elbette, sadece ilk etapta saolsun çok yardımcı oldu, hala da öle,
Kuruluma başladıktan sonra hepinizin fikrini almak için konuyu başlatacağım :)";}, 1572939232, 1713608864
Run Time: 0.001441
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, 380205, a:1:{i:0;s:188:"Abi sağolasın :) Hoşgeldin.
Güzel bir kurulum olur umarım. Dediğim gibi benim bilgim çok sınırlı, kurulumu anlatana kadar elimden geleni yaparım, Sonrası için de Portal var ;)";}, 1572939232, 1713608864
Run Time: 0.001498
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, 8887, a:1:{i:0;s:11:"Soft Garden";}, 1572939232, 1713608864
Run Time: 0.001715
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, 380206, a:1:{i:0;s:25:"Aramıza hoş geldiniz :)";}, 1572939232, 1713608864
Run Time: 0.001202
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, 380208, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:32:"ka2n, post: 380205, member: 8887";s:8:"original";a:2:{i:0;s:42:"[QUOTE="ka2n, post: 380205, member: 8887"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:188:"Abi sağolasın :) Hoşgeldin.
Güzel bir kurulum olur umarım. Dediğim gibi benim bilgim çok sınırlı, kurulumu anlatana kadar elimden geleni yaparım, Sonrası için de Portal var ;)";}}i:1;s:234:"
Senin sınırlı olan bilgin benim için hazine dostum :)
O zaman ne diyoruz?
:portaliseviyoruz: temo11
Herkese teşekkürler, en kısa zamanda konuyu açıp herkesin fikirlerini almak için sabırsızlanıyorum temo4";}, 1572939232, 1713608864
Run Time: 0.001599
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, 380210, a:1:{i:0;s:45:"Hoş geldiniz, keyifli paylaşımlar dilerim.";}, 1572939232, 1713608864
Run Time: 0.001251
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, 7575, a:1:{i:0;s:47:"180X120X60 Resif Tankı
100X60X55 Marine Tankı";}, 1572939232, 1713608864
Run Time: 0.001341
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, 380232, a:1:{i:0;s:52:"Hoş geldiniz Gökşen Bey, keyifli hobiler dilerim.";}, 1572939232, 1713608864
Run Time: 0.001714
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, 11537, a:1:{i:0;s:36:"BrcMst Dream Drop Reef 170x55x50-80h";}, 1572939232, 1713608864
Run Time: 0.002412
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, 380251, a:1:{i:0;s:243:"Hoşgeldiniz, inşallah istediğiniz güzellikte bir akvaryum kurmak nasip olur.
Ankarada yaşayan biri olarak kurulum aşamasında yardım edebileceğimiz bir şey olursa haber verin.
GT-N7100 cihazımdan Tapatalk kullanılarak gönderildi";}, 1572939232, 1713608864
Run Time: 0.003484
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, 11831, a:1:{i:0;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:84:"http://www.akvaryumportali.com/threads/%C4%B0lk-resif-tank%C4%B1m.23441/#post-395481";s:8:"original";a:2:{i:0;s:92:"[URL='http://www.akvaryumportali.com/threads/%C4%B0lk-resif-tank%C4%B1m.23441/#post-395481']";i:1;s:6:"[/URL]";}s:8:"children";a:1:{i:0;s:20:"-İlk Resif Tankım-";}}}, 1572939232, 1713608864
Run Time: 0.001603
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, 380252, a:1:{i:0;s:55:"Ankarada hersey bir kofteye bakıyor haberiniz olsun ;)";}, 1572939232, 1713608864
Run Time: 0.001286
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, 380256, a:1:{i:0;s:57:"Bende bir ankarali olarak arkadasima mercan hediye ederim";}, 1572939232, 1713608864
Run Time: 0.002058
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, 380266, a:1:{i:0;s:54:"Adam profile büyük harflerle yazmış İstanbul u :D";}, 1572939232, 1713608864
Run Time: 0.001210
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, 380273, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:35:"afatih, post: 380251, member: 11831";s:8:"original";a:2:{i:0;s:45:"[QUOTE="afatih, post: 380251, member: 11831"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:241:"Hoşgeldiniz, inşallah istediğiniz güzellikte bir akvaryum kurmak nasip olur.
Ankarada yaşayan biri olarak kurulum aşamasında yardım edebileceğimiz bir şey olursa haber verin.
GT-N7100 cihazımdan Tapatalk kullanılarak gönderildi";}}i:1;s:127:"
İlginiz için çok teşekkür ederim, fakat İstanbuldayım :) ama yine de kurulumu gerçekleştirelim bi duruma bakalım :))";}, 1572939232, 1713608864
Run Time: 0.001633
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 = 22536)
LIMIT 1
Run Time: 0.000570
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.000178
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |