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.000812
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.000350
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: 16349
Run Time: 0.000606
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: 99
Run Time: 0.000613
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: 16349
Run Time: 0.003826
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 | 17 | 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 |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, data.file_path, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xf_attachment AS attachment
INNER JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE attachment.content_type = ?
AND attachment.content_id IN (253809)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.002552
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 2 | Using index condition |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | bizimled_db.attachment.data_id | 1 | |
INSERT INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 16349
Run Time: 0.000092
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 3ca8604835d413633246a5f7517f1d28, , 1713471793
Run Time: 0.000226
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=16349, 1713468193,
Run Time: 0.000115
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000393
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, 253792, a:1:{i:0;s:27:"Neden köşede duruyorlar ?";}, 1572939232, 1713468193
Run Time: 0.001788
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, 253801, a:1:{i:0;s:81:"Resim video çek kardeş
Ayrıntılı açıklarsan yardımcı olacak arkadaşlar";}, 1572939232, 1713468193
Run Time: 0.001561
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, 253802, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:40:"enes batuhan, post: 253792, member: 9270";s:8:"original";a:2:{i:0;s:50:"[quote="enes batuhan, post: 253792, member: 9270"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:24:"neden köşede duruyor ?";}}i:1;s:65:"
Stresse girmiş olabilir, hastalanmış olabilir.
Yem yiyor mu?";}, 1572939232, 1713468193
Run Time: 0.001427
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, 253803, a:1:{i:0;s:13:"Evet yiyorlar";}, 1572939232, 1713468193
Run Time: 0.001136
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, 253807, a:1:{i:0;s:75:"Akvaryumun ve balıkların geneli hakkında bilgi ve resim video ekleyin...";}, 1572939232, 1713468193
Run Time: 0.001121
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, 7159, 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:34:"http://i.hizliresim.com/25yjPL.jpg";}}}, 1572939232, 1713468193
Run Time: 0.001449
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, 253808, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:40:"enes batuhan, post: 253803, member: 9270";s:8:"original";a:2:{i:0;s:50:"[quote="enes batuhan, post: 253803, member: 9270"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:13:"Evet yiyorlar";}}i:1;s:159:"
Yem yemesi iştahlıysa hastalık sorunu yoktur bence, bir arada beklemeleri stress belirtileri akvaryumda bakteriyel döngünün oturmadığının habercisi.";}, 1572939232, 1713468193
Run Time: 0.001183
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, 253809, a:3:{i:0;a:4:{s:3:"tag";s:6:"attach";s:6:"option";s:4:"full";s:8:"original";a:2:{i:0;s:13:"[ATTACH=full]";i:1;s:9:"[/ATTACH]";}s:8:"children";a:1:{i:0;s:5:"12948";}}i:1;s:1:" ";i:2;a:4:{s:3:"tag";s:6:"attach";s:6:"option";s:4:"full";s:8:"original";a:2:{i:0;s:13:"[ATTACH=full]";i:1;s:9:"[/ATTACH]";}s:8:"children";a:1:{i:0;s:5:"12949";}}}, 1572939232, 1713468193
Run Time: 0.001145
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, 253811, a:1:{i:0;s:75:"Akvaryum hakkında bilgi verin;
Sıcaklık?
Filtreleme nedir Debisi nasıl?";}, 1572939232, 1713468193
Run Time: 0.001383
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, 253812, a:1:{i:0;s:72:"Video da olsa süper olucak yeni soğuk su ekledin herhalde ondanda olur";}, 1572939232, 1713468193
Run Time: 0.001625
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, 253813, a:1:{i:0;s:85:"Akvaryum 40 litre hava motoru var iç filitre vr ısıtıcı yok ama haftaya alıcam";}, 1572939232, 1713468193
Run Time: 0.001316
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, 253814, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:38:"TencoMelih, post: 253812, member: 9241";s:8:"original";a:2:{i:0;s:48:"[quote="TencoMelih, post: 253812, member: 9241"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:72:"Video da olsa süper olucak yeni soğuk su ekledin herhalde ondanda olur";}}i:1;s:22:"
Video ekliyemedim :-(";}, 1572939232, 1713468193
Run Time: 0.001025
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, 253815, a:1:{i:0;s:95:"Su soğuk olduğundan veriyorlar böyle bir tepki benim fikrim soğuktan renkleri bile atmış.";}, 1572939232, 1713468193
Run Time: 0.001133
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, 253816, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:40:"enes batuhan, post: 253813, member: 9270";s:8:"original";a:2:{i:0;s:50:"[quote="enes batuhan, post: 253813, member: 9270"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:85:"Akvaryum 40 litre hava motoru var iç filitre vr ısıtıcı yok ama haftaya alıcam";}}i:1;s:306:"
Balıkları eklemeden önce akvaryumu kuralı kaç hafta olmuştu? Lepistes su değerlerine çok hassastır, bir akvaryumun en az 1,5 hafta içine azcık yem atılarak çalışması lazım. Ev çok soğuksa ısıtıcı olmadığı için ondanda stresse girmiş olabilir. Suyun ısısı çok mu düşük?";}, 1572939232, 1713468193
Run Time: 0.001172
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, 253819, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:35:"ErenTmz, post: 253816, member: 8565";s:8:"original";a:2:{i:0;s:45:"[quote="ErenTmz, post: 253816, member: 8565"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:305:"Balıkları eklemeden önce akvaryumu kuralı kaç hafta olmuştu? Lepistes su değerlerine çok hassastır, bir akvaryumun en az 1,5 hafta içine azcık yem atılarak çalışması lazım. Ev çok soğuksa ısıtıcı olmadığı için ondanda stresse girmiş olabilir. Suyun ısısı çok mu düşük?";}}i:1;s:109:"
Bn lepistesleri almadan önce japonlar vardı verdim onları ve dün lepisteleri aldım 18 derece sıcaklık";}, 1572939232, 1713468193
Run Time: 0.001225
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, 253820, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:40:"enes batuhan, post: 253819, member: 9270";s:8:"original";a:2:{i:0;s:50:"[quote="enes batuhan, post: 253819, member: 9270"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:108:"Bn lepistesleri almadan önce japonlar vardı verdim onları ve dün lepisteleri aldım 18 derece sıcaklık";}}i:1;s:486:"
Sıcaklık biraz düşük, daha adapte olamamışlar, eski yaşadıkları su büyük ihtimal 25-27 derece arası idi akvaryumcuda. Isıtıcı alıp yavaş yavaş ısıyı 25e sabitleyin sonra adapte olmalarını bekleyin. 18 derece ise ısıyı ısıtıcı taktığınız da ilk önce 20-21 e ayarlayın 1 saat sonra bir kaç derece daha ısıyı artırın sonra olması gereken ısıyı 1 gün içinde tamamlayın. Aniden ısıyı yükseltirseniz balıklarınız beyaz benek olabilir.";}, 1572939232, 1713468193
Run Time: 0.001130
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, 253821, a:1:{i:0;s:68:"Japonlar soğuktan fazla etkilenmez onun için lepistesler etkilenir";}, 1572939232, 1713468193
Run Time: 0.001158
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, 253823, a:1:{i:0;s:14:"Teşekkürler.";}, 1572939232, 1713468193
Run Time: 0.001038
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 = 16349)
LIMIT 1
Run Time: 0.000595
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: 166
Run Time: 0.000216
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.000162
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |