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.000536
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.000173
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: 24036
Run Time: 0.000369
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: 35
Run Time: 0.000386
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: 24036
Run Time: 0.002141
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 |
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 (404976, 404977)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000364
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: 24036
Run Time: 0.000074
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 813eebd909cd4f7287e704f973a3b956, , 1713492086
Run Time: 0.000222
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=24036, 1713488486,
Run Time: 0.000143
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000240
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, 404976, a:2:{i:0;s:134:"Arkadaşlar herkese slm sonunda yeni tank bitti tank Süleyman usta yapımı dolap ben denize ait fikir ve yorumlarınızı beklerim";i:1;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:"39552";}}}, 1572939232, 1713488486
Run Time: 0.001684
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, 404977, a:1:{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:"39553";}}}, 1572939232, 1713488486
Run Time: 0.001010
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, 404993, a:1:{i:0;s:50:"Çok şık olmuş, hayırlı kurulumlar... :nazar:";}, 1572939232, 1713488486
Run Time: 0.001138
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, 1713488486
Run Time: 0.001763
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, 405003, a:1:{i:0;s:42:"Gayet temiz şık olmuş, hayırlı olsun.";}, 1572939232, 1713488486
Run Time: 0.001003
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, 405027, a:1:{i:0;s:125:"Herkese güzel yorumları için teşekkür ederim. Birde armatüru asmak işin askı aparatini bağlamak için taç yapiyorum";}, 1572939232, 1713488486
Run Time: 0.001009
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, 405058, a:1:{i:0;s:61:"Serkan bence armatür için taç yapma, armatürü tavana as.";}, 1572939232, 1713488486
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: signature, 1736, a:1:{i:0;s:27:"İBRAHİM CENGİZ
155x80x60";}, 1572939232, 1713488486
Run Time: 0.001493
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, 405080, a:1:{i:0;s:16:"Hayırlı olsun.";}, 1572939232, 1713488486
Run Time: 0.001598
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, 405082, a:1:{i:0;s:16:"Hayırlı olsun.";}, 1572939232, 1713488486
Run Time: 0.001034
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, 405084, a:1:{i:0;s:36:"Tesekkur ederim Veysel bey mesut bey";}, 1572939232, 1713488486
Run Time: 0.000980
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, 405086, a:1:{i:0;s:391:"Serkan armatür askıları var krom borulardan bulamazsan bile büktür bende yapıcam öyle bişeyler tavandan düştü düşecek korkusundan bunaldım
Şimdi yan taraftaki akvaryumu yeni akvaryuma geçireceksen kumu sıfırla ve kesinlikle yarı suyunu almayı unutma bakteri kültürünü ihmal etme kardeşim
O ne resmi şöyle bir büyüttüm malzeme çöplüğüne dönmüş orası:)";}, 1572939232, 1713488486
Run Time: 0.000952
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, 405094, a:1:{i:0;s:238:"16 milim alemunyum boru buktum hazir tacı o yüzden yapıyorum ta a monte edicem meslek icabı boru vs temini kolay benim için taç bu akşam bitiyor kaplamasını az önce kestim hafta sonuna inş tasiyacam akvaryumu
Mercanda lazım :)";}, 1572939232, 1713488486
Run Time: 0.001328
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, 405101, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:35:"Metyis, post: 405094, member: 11645";s:8:"original";a:2:{i:0;s:45:"[QUOTE="Metyis, post: 405094, member: 11645"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:238:"16 milim alemunyum boru buktum hazir tacı o yüzden yapıyorum ta a monte edicem meslek icabı boru vs temini kolay benim için taç bu akşam bitiyor kaplamasını az önce kestim hafta sonuna inş tasiyacam akvaryumu
Mercanda lazım :)";}}i:1;s:69:"
Elimizde olanlatdan fraglarız kolay o iş sen yeterki suyu hazırla";}, 1572939232, 1713488486
Run Time: 0.000941
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, 405105, a:1:{i:0;s:103:"Resimlere bakınca 1 ay önceki bizim evin halleri aklıma geldi. Tankın ölçülerinide öğrensek:p";}, 1572939232, 1713488486
Run Time: 0.001201
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, 405123, a:1:{i:0;s:21:"Tank olcusu 150*70*55";}, 1572939232, 1713488486
Run Time: 0.000956
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, 405125, a:1:{i:0;s:521:"70 yerine 80 yaptırssydın ya Serkan on numara olmuş güle güle kullan çok şık bir kaya dizaynı yap kardeşim söyle baktım mı tank bozasımız gelsin
Ben bu aralar bu cümleyi çok kullanıyorum bozacam heralde potala bir hafta ara vermem lazım gibi duruyo
Bu deniz işi böyle heralde sitede gezdikçe bişeyler alasım bozup kurasım geliyo avm ye gidip gezicem alış veriş yok diyipte aaaaa her yerde indirim vardı deyip kart limiti bitirmek gibi
Bozup kurmayın kardeşim canımız çeliyo yaw:)";}, 1572939232, 1713488486
Run Time: 0.000959
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, 405127, a:1:{i:0;s:98:"Öyle bu dördüncü tank besuncidebolucak 200 luk tank hayalim var 80 derinliği onda dusunuyorum";}, 1572939232, 1713488486
Run Time: 0.000922
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, 405158, a:1:{i:0;s:62:"Yav bizim Angara ekibiyle köfte falan yemişmiydiniz aceba.:D";}, 1572939232, 1713488486
Run Time: 0.001032
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, 405160, a:1:{i:0;s:72:"Abi serkan rekora doğru gidiyor galiba dikkat et rekor gitmesin elden:)";}, 1572939232, 1713488486
Run Time: 0.001267
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, 405161, a:1:{i:0;s:29:"Yemedik ama yeriz bi gün ins";}, 1572939232, 1713488486
Run Time: 0.001101
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, 405166, a:1:{i:0;s:149:"İnsallah neden olmasın toplaşırız müsait bir zaman ayarlayıp. Uzak gibi görünsekte birbirlerimize burası sayesinde hep yakınız aslında.";}, 1572939232, 1713488486
Run Time: 0.000997
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 = 24036)
LIMIT 1
Run Time: 0.000440
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: 31
Run Time: 0.000202
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |