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.000425
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.000154
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: 13208
Run Time: 0.000394
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: 40
Run Time: 0.000367
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: 13208
Run Time: 0.002173
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 | 11 | 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: 13208
Run Time: 0.000083
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 068f30d178e6e43e70df1a1b90bd588c, , 1713589913
Run Time: 0.000204
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=13208, 1713586313,
Run Time: 0.000117
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000251
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, 188459, a:2:{i:0;s:111:"Çok güzel bir sistem yapmışlar,benim hedefim de böyle olacak inşallah,odayı doldursam mı acep...:)
";i:1;a:4:{s:3:"tag";s:5:"media";s:6:"option";s:7:"youtube";s:8:"original";a:2:{i:0;s:15:"[media=youtube]";i:1;s:8:"[/media]";}s:8:"children";a:1:{i:0;s:11:"HmPavjZKUcs";}}}, 1572939232, 1713586313
Run Time: 0.001526
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, 1713586313
Run Time: 0.001165
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, 188464, a:1:{i:0;s:147:"Hayretle izledim videoyu.Yapana helal olsun.Alparslan evden kovulmak istemiyorsan böyle bir sistem kurmayı aklından bile geçirme bence :koptum:";}, 1572939232, 1713586313
Run Time: 0.001044
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, 6093, a:1:{i:0;s:31:"108 litre bitkili 55 litre boş";}, 1572939232, 1713586313
Run Time: 0.001257
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, 188480, a:1:{i:0;s:114:"Orda en az 40-50 bin lira sermaye yatıyor. Ne kadar zamanda çıkarır önce düşün, araştır sonra doldur. :)";}, 1572939232, 1713586313
Run Time: 0.000982
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, 188483, a:1:{i:0;s:49:"Sen kendini evden kovduracaksın herhalde Alpi.:)";}, 1572939232, 1713586313
Run Time: 0.001093
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, 188485, a:4:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:35:"BulentS, post: 188480, member: 6772";s:8:"original";a:2:{i:0;s:45:"[quote="BulentS, post: 188480, member: 6772"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:114:"Orda en az 40-50 bin lira sermaye yatıyor. Ne kadar zamanda çıkarır önce düşün, araştır sonra doldur. :)";}}i:1;s:208:"
Bülent abi benim amacım para kazanmak değil sevdiğim işi yapmak,iyi yapılan her iş az veya çok nasıl olsa para kazandırır,eğer amacım para kazanmak olsaydı borsa işine yönelirdim... :)
";i:2;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:40:"domurcukgül, post: 188483, member: 7353";s:8:"original";a:2:{i:0;s:50:"[quote="domurcukgül, post: 188483, member: 7353"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:49:"Sen kendini evden kovduracaksın herhalde Alpi.:)";}}i:3;s:121:"
Uğur abi evde alıştırma yapıyorum ileride inşallah bir yer edinip büyük çapta düşünmüyor değilim... :)";}, 1572939232, 1713586313
Run Time: 0.001069
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, 188487, a:1:{i:0;s:168:"Alparslan kardeşim sen kafana koyduğun şeyi yaparsın:)en son kurulumda kapıyı bacayı söküp akvaryumu koyduysan bunlar o kadarda uzak değil gibi görünüyor:D";}, 1572939232, 1713586313
Run Time: 0.000993
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, 188492, a:2:{i:0;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:33:"cirol, post: 188487, member: 2439";s:8:"original";a:2:{i:0;s:43:"[quote="cirol, post: 188487, member: 2439"]";i:1;s:8:"[/quote]";}s:8:"children";a:1:{i:0;s:168:"Alparslan kardeşim sen kafana koyduğun şeyi yaparsın:)en son kurulumda kapıyı bacayı söküp akvaryumu koyduysan bunlar o kadarda uzak değil gibi görünüyor:D";}}i:1;s:92:"
Aynen öyle abi hedef belli şu an öğreniyorum ilerde imkan olursa niye olmasın...:)";}, 1572939232, 1713586313
Run Time: 0.001153
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, 188536, a:1:{i:0;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:88:"http://bangordailynews.com/2011/05/22/living/searching-for-nemo-try-looking-in-franklin/";s:8:"original";a:2:{i:0;s:96:"[url="http://bangordailynews.com/2011/05/22/living/searching-for-nemo-try-looking-in-franklin/"]";i:1;s:6:"[/url]";}s:8:"children";a:1:{i:0;s:123:" Tropical fish in Maine? Franklin facility breeds them for sale — Living — Bangor Daily News — BDN Maine";}}}, 1572939232, 1713586313
Run Time: 0.001357
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, 188559, a:1:{i:0;s:408:"Görünen sistem var olan üretime çok fazla ve karmaşık kanımca. O kadar karmaşa ve detay içinde daha farklı bir üretim yaratılabilmesi.
Üretim hevesine gelince, sağdan soldan toplama ile bu işler olmaz, sular kesilir elbet, elektrikler gider, insanlar bıkar, krediler tükenir işler yarım kalır. Mevcut çapınızı bilerek, fazla da kendimizi maddi ve manevi aşmadan düşünmek gerekir.";}, 1572939232, 1713586313
Run Time: 0.001345
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, 188565, a:1:{i:0;s:125:"Temel abi bu düşünceler çok ileriye dönük,şayet ele bir şey geçerse olacak şeyler can çıkmadan umut bitmiyor...:)";}, 1572939232, 1713586313
Run Time: 0.001234
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, 188598, a:1:{i:0;s:103:"Alparsan sen müreni evcilleştirmiş adamsın yeterki eline imkan geçsin başaracağına inanıyorum.";}, 1572939232, 1713586313
Run Time: 0.001370
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, 7124, a:1:{i:0;s:99:"Bilmediğini bilen varsa ısrarla iddaalaşmak erdemlik, paylaşım ve tartışma ortamı olamaz...";}, 1572939232, 1713586313
Run Time: 0.001803
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 = 13208)
LIMIT 1
Run Time: 0.000401
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: 172
Run Time: 0.000175
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |