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.000543
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.000263
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: 3012
Run Time: 0.000553
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.000596
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: 3012
Run Time: 0.002916
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 | 13 | 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: 3012
Run Time: 0.000081
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: bf9814a7eda2b2394e4948d7636e1324, , 1713388711
Run Time: 0.000209
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=3012, 1713385111,
Run Time: 0.000118
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000299
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, 32509, a:4:{i:0;s:190:"Havuzumun içinde bulunan japon şemsiyesi saksısında, aşağıda fotoğrafı görünen küçük salyangozlardan var. Eğer zararlıysa vaktiyle önlemini alabilmek için sormak istedim.
";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:60:"http://i22.photobucket.com/albums/b332/sapagasioglu/ssss.jpg";}}i:2;s:2:"
";i:3;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:68:"http://i22.photobucket.com/albums/b332/sapagasioglu/Picture061-1.jpg";}}}, 1572939232, 1713385111
Run Time: 0.001812
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, 1523, a:1:{i:0;s:14:"Saygılarımla";}, 1572939232, 1713385111
Run Time: 0.003010
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, 32510, a:1:{i:0;s:126:"Sanmıyorum zararı olacağını ben. Biraz doğal bırakmak lazım şartları. Koi havuzunda ne zararı olabilir salyangozun.";}, 1572939232, 1713385111
Run Time: 0.001315
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, 32511, a:1:{i:0;s:96:"O zaman bırakayım onlar da havuzumda yaşasınlar. Canlı çeşitliliği beni de mutlu ediyor.";}, 1572939232, 1713385111
Run Time: 0.001288
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, 32512, a:1:{i:0;s:305:"Caner abi selamlar aynı salyangozdan bendede var zararsızdır ama aynı ramshornlar gibi biraz fazla ürerler, sudan çıkamazlar yakından bakıldığında çok şık desenleri olduğunu göreceksiniz size yararıda olacaktır artık yemleri yerler yosunları yerler çok iyi bir gelişme bu tebrikler.";}, 1572939232, 1713385111
Run Time: 0.001693
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, 260, a:1:{i:0;s:9:"Emrah ECE";}, 1572939232, 1713385111
Run Time: 0.001320
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, 32513, a:1:{i:0;s:286:"Emrah, bu salyangozlar bayadır saksıdalar. Fotoğrsfı yeni çekebildim. Biraz daha büyüdüklerinde saksıdan çıkarıp havuza atarım. Şimdi eklersem benim piranhalar yer zavallıları :)
-----------------------------------------------
Yoksa hep böyle küçük mü kalacaklar?";}, 1572939232, 1713385111
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, 32514, a:1:{i:0;s:185:"Yok bunlar büyüyorlar hocam. Benim üretim tankıma da bulaştı. Kurtulana kadar canım çıktı valla. :D Ama koiler için bir zararının olacağını zannetmiyorum.
Saygılar...";}, 1572939232, 1713385111
Run Time: 0.001260
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, 1713385111
Run Time: 0.001186
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, 32515, a:1:{i:0;s:27:"Teşekkürler Hüseyin bey.";}, 1572939232, 1713385111
Run Time: 0.001143
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, 32516, a:1:{i:0;s:64:"Caner abi nohutun yarısı kadar olacaklar dahada büyümez .Ş.";}, 1572939232, 1713385111
Run Time: 0.001503
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, 32517, 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:49:" Fotoğraftaki salyangoz türü zararlı mıdır?";}}i:1;s:156:"
Deneme amacıyla 2 aslyangozu saksıdan alıp havuza bıraktım. Bırakır bırakmaz yem oldular :cekingen:
Sanırım saksıda kalmaları daha iyi olacak.";}, 1572939232, 1713385111
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, 32518, a:4:{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:49:" Fotoğraftaki salyangoz türü zararlı mıdır?";}}i:1;s:2:"
";i:2;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:8:"molossus";s:8:"original";a:2:{i:0;s:17:"[quote=molossus ]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:156:"
Deneme amacıyla 2 aslyangozu saksıdan alıp havuza bıraktım. Bırakır bırakmaz yem oldular :cekingen:
Sanırım saksıda kalmaları daha iyi olacak.
";}}i:3;s:240:"
İtiraf etmeliyim ki sizin canlı yem araştırmalarınızı ve bu sefer tamam dediğiniz videolarınızı keyifle izlemiştim. Başlığı açarken salyangozun bu amaca hizmet edeceğini düşünmemiştim. Sanrım yine yanlış adres. :D";}, 1572939232, 1713385111
Run Time: 0.001272
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, 32519, 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:49:" Fotoğraftaki salyangoz türü zararlı mıdır?";}}i:1;s:61:"
Temel bey, haklısınız :) Meğer yem salyangozlarmış :F";}, 1572939232, 1713385111
Run Time: 0.001282
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, 32520, a:4:{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:49:" Fotoğraftaki salyangoz türü zararlı mıdır?";}}i:1;s:2:"
";i:2;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:9:"YIKIKTEMO";s:8:"original";a:2:{i:0;s:18:"[quote=YIKIKTEMO ]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:240:"
İtiraf etmeliyim ki sizin canlı yem araştırmalarınızı ve bu sefer tamam dediğiniz videolarınızı keyifle izlemiştim. Başlığı açarken salyangozun bu amaca hizmet edeceğini düşünmemiştim. Sanrım yine yanlış adres. :D
";}}i:3;s:74:"
ALLAH iyiliğini versin Temel Abi. Hiç güleceğim yoktu valla :D :D :D";}, 1572939232, 1713385111
Run Time: 0.001114
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, 32521, a:3:{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:9:"salyangoz";}}i:1;s:237:"
Bence arkadaşımızında belirttiği gibi salyangozların zararrı yok. Ancak zamanla çoğalıp sadece görsel bir bozukluk meydana gelir tüm zararları bu...Hatta camdaki salyangozları elinle ez balıklarına yem olur.. çılgın:";i:2;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:8:"molossus";s:8:"original";a:2:{i:0;s:17:"[quote=molossus ]";i:1;s:8:"[/quote]";}s:8:"children";a:5:{i:0;s:191:"
Havuzumun içinde bulunan japon şemsiyesi saksısında, aşağıda fotoğrafı görünen küçük salyangozlardan var. Eğer zararlıysa vaktiyle önlemini alabilmek için sormak istedim.
";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:60:"http://i22.photobucket.com/albums/b332/sapagasioglu/ssss.jpg";}}i:2;s:2:"
";i:3;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:68:"http://i22.photobucket.com/albums/b332/sapagasioglu/Picture061-1.jpg";}}i:4;s:1:"
";}}}, 1572939232, 1713385111
Run Time: 0.001117
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 = 3012)
LIMIT 1
Run Time: 0.000527
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.000191
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.000151
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |