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.000558
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.000215
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: 14092
Run Time: 0.000476
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.000436
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: 14092
Run Time: 0.003447
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 | 14 | 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 (208930, 208980)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000385
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | range | content_type_id_date | content_type_id_date | 31 | | 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: 14092
Run Time: 0.000094
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 0a63eed724400e0b13fe156efa2c145b, , 1713560585
Run Time: 0.000188
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=14092, 1713556985,
Run Time: 0.000133
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000295
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, 208930, a:2:{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:4:"5810";}}i:1;s:49:"
Alpi ile buluştuk akvaryumcuları dolaşıyoruz";}, 1572939232, 1713556985
Run Time: 0.001583
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, 208931, a:1:{i:0;s:86:"Vay, habersiz akvaryum gezisi ha. Yazdım bunu :)
Varmı kayda değer birşeyler bari?";}, 1572939232, 1713556985
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, 208932, a:1:{i:0;s:94:"Alpi yılanı deliğinde bulur ama çıkarmaz, yılan zaten peşinden gider.:D Gezin bakalım.";}, 1572939232, 1713556985
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: post, 208944, a:1:{i:0;s:29:"Yeni tank yolda hatta arabada";}, 1572939232, 1713556985
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, 208975, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:34:"YIKIKTEMO, post: 208932, member: 2";s:8:"original";a:2:{i:0;s:44:"[quote="YIKIKTEMO, post: 208932, member: 2"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:94:"Alpi yılanı deliğinde bulur ama çıkarmaz, yılan zaten peşinden gider.:D Gezin bakalım.";}}i:1;s:105:"
Size dedik İDEF fuarındayım diye halil'e de söyledim Bülent abiyede biriniz gelmediniz kardeşim.";}, 1572939232, 1713556985
Run Time: 0.001263
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, 208980, a:2:{i:0;s:201:"Sultan Süleyman ve Malkoç oğlu akvaryumcular seferinde.
Sefer başarılı geçti ganimet güzel ve sağlam,yaw Muhteşem yüz yıl dizisine benzedi.
Bülent abide olsaydı üç 190 olurduk...:D
";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:65:"http://www.akvaryumportali.com/attachments/g%C3%BCl1099-jpg.5824/";}}}, 1572939232, 1713556985
Run Time: 0.001203
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, 1713556985
Run Time: 0.001452
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, 208984, a:1:{i:0;s:288:"Yakışıklı kardeşim benim Allah nazardan saklasın gönlünün güzelligi yüzüne vurmuş, ayrıca usta fotoğrafcı güzel insan Ertugrul abime ilgisinden dolayı ne kadar teşekkür etsem azdır, en kısa zamanda çok daha kalabalık bir buluşma yapabilirsek ne kadar güzel olur.";}, 1572939232, 1713556985
Run Time: 0.001146
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, 208998, a:1:{i:0;s:137:"Süleyman abi teşekkür ederim,yeni toplantı çok güzel bol kahkaha lı olacak belli,Teoman abi ile çok iyi anlaşacağın kesin...:)";}, 1572939232, 1713556985
Run Time: 0.001073
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, 208999, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:37:"MOVACIKLI, post: 208975, member: 6831";s:8:"original";a:2:{i:0;s:47:"[quote="MOVACIKLI, post: 208975, member: 6831"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:102:"Size dedik İDEF fuarındayım diye halil'e de söyledim Bülent abiyede biriniz gelmediniz kardeşim.";}}i:1;s:181:"
Hastalıktan falan da anlamazsınız, gözümü açacak halim yoktu telefonuna baktığıma dua et sen, mıstafa :). Mezara girsek gene buluşmada yoktun diye kızacaksınız yahu.";}, 1572939232, 1713556985
Run Time: 0.001354
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, 209006, a:1:{i:0;s:51:"İnsan sevdiğine sitem edermiş ne güzel işte :)";}, 1572939232, 1713556985
Run Time: 0.001043
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, 209012, a:1:{i:0;s:266:"Ne güzel gülen güzel yüzler maşallah, bakalım kaybolmadan bulabilirsem :D İstanbul'da Alpi seni bende akvaryumcu gezisi isterim bak ona göre işallah planlar değişmez de gelirim. Önceden bir yarım gün İstanbul gezisinden başka gelmişliğim yok.:cool:";}, 1572939232, 1713556985
Run Time: 0.001663
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, 209144, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:35:"bulents, post: 208999, member: 6772";s:8:"original";a:2:{i:0;s:45:"[quote="bulents, post: 208999, member: 6772"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:180:"Hastalıktan falan da anlamazsınız, gözümü açacak halim yoktu telefonuna baktığıma dua et sen, mıstafa :). Mezara girsek gene buluşmada yoktun diye kızacaksınız yahu.";}}i:1;s:62:"
Allah korusun Abi yeterki sen iyi ol benimkisi sadece latife.";}, 1572939232, 1713556985
Run Time: 0.001212
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, 209210, a:1:{i:0;s:71:"Yediğiniz içtiğiniz sizde kalsın.ne yaptınız onu anlatın baari:)";}, 1572939232, 1713556985
Run Time: 0.001211
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, 209363, a:1:{i:0;s:109:"Murat çaylarımızıda içtik bana kaya gibi durso sistemli bir tank aldık ( alpi başına bela aldı yani)";}, 1572939232, 1713556985
Run Time: 0.001097
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 = 14092)
LIMIT 1
Run Time: 0.000426
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.000183
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |