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.000485
| 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.000219
| 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: 21923
Run Time: 0.000459
| 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: 149
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 ASCParams: 21923
Run Time: 0.007775
| 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 | 15 | 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: 21923
Run Time: 0.000124
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 61b5c6e8803f6f9f991e69ea6ac00914, , 1714603821
Run Time: 0.000562
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=21923, 1714600221,
Run Time: 0.000144
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000349
| 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, 367210, a:1:{i:0;s:1487:"Merhabalar bayadır giremedim işlerimden dolayı akvaryumdaki canlıları verdikten sonra akvaryum yatmakta arkadaşımın ilanlarındaki ekipmanları ve ürünlelrden sonra satışa çıkaracaktım elimdeki malzemeler
100x50x55 akvaryum yandan dursolu sağlam profil kasa ben kasaada modifiye yapmıştım istenirse kendiniz ahşaptan profil üzerine koyarsınız ben bu halde kullandım sorunsuz
500 tl kum hediye
rw15 dalga motoru sorunsuz deneyip alırısınız dalga ayarları çalışmakta sensörü çalışmakta 150
canlı kaya 40kg yada 50 yakın kaya var aptasya maptasiya yok cyano myano bakıp alın akvaryumda duruyor suyun içinde bayadır morarmaya başlamıştı hepsi 30 kg olarak istenirse 10 liradan alabilirsiniz
twins su tamamlama 150 lira sorunsuz motoru kendim ekledim sağlamdır deneyip alabilirsiniz
refraktometre 100 lira sağlam ayarlı tds metre hediyemdir
mag float keçesini kendim yaptım çalışıyor usten jiletli modeli 70 tl
curve 9 550 tl ( bana ait değil tertemizdir alan pişman olmaz temizlenip evde yatmaktadır deneyip alabilirsiniz
eheime ısıtıcı 50 tl 300 watt çalışır vaziyette
eheime zaman ayarlı otomatik yem 100tl
ocean runner 6500 kuru sulu kafa motoru 200 tl
05445980314 whatsapp
05415980314 arama yapmak için kullanabilirsiniz
göztepe çemenzar eski şafak hastanesinin orada yerim
39 watt lagoonblue florasanlar var 20 lira tanesi 4-5 adet var giesmann marka olması lazm
fotolar eklenecek";}, 1572939232, 1714600221
Run Time: 0.003687
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, 367349, a:18:{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:76:"http://images.tapatalk-cdn.com/15/10/24/d178ecac8b72004d8b3d270b4c3729a0.jpg";}}i:1;s:1:"
";i:2;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:76:"http://images.tapatalk-cdn.com/15/10/24/1441d8793cc2041f1fa151094cd861fc.jpg";}}i:3;s:1:"
";i:4;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:76:"http://images.tapatalk-cdn.com/15/10/24/5cbdd1f1d7bfa876f975895bd4540677.jpg";}}i:5;s:1:"
";i:6;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:76:"http://images.tapatalk-cdn.com/15/10/24/8dfeab38b3dbb460f0e227d8691e6456.jpg";}}i:7;s:1:"
";i:8;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:76:"http://images.tapatalk-cdn.com/15/10/24/76c680ced3a7ef0e400170f8f40c66ab.jpg";}}i:9;s:1:"
";i:10;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:76:"http://images.tapatalk-cdn.com/15/10/24/c7a3fa9163edd7af879f659d85199c2e.jpg";}}i:11;s:1:"
";i:12;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:76:"http://images.tapatalk-cdn.com/15/10/24/10de65f3eadbd84ea4d22db22fb28137.jpg";}}i:13;s:1:"
";i:14;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:76:"http://images.tapatalk-cdn.com/15/10/24/c4d3fb551912d221afa33109b05a2add.jpg";}}i:15;s:1:"
";i:16;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:76:"http://images.tapatalk-cdn.com/15/10/24/041424a24323bc838ff263d0d27b6ff3.jpg";}}i:17;s:38:"
Sent from my iPhone using Tapatalk";}, 1572939232, 1714600221
Run Time: 0.019428
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, 368063, a:1:{i:0;s:97:"Rw15 satildi akvaryum kum kaya dahil 400lt digerleri guncel
Sent from my iPhone using Tapatalk";}, 1572939232, 1714600221
Run Time: 0.003370
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, 368065, a:1:{i:0;s:65:"Bilal bey, rw15, hediyeler ve hoş sohpet için teşekkür ederim";}, 1572939232, 1714600221
Run Time: 0.001695
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, 368066, a:1:{i:0;s:95:"Herzaman beklerim hayirli ugurlu olsun ben tesekkurederim
Sent from my iPhone using Tapatalk";}, 1572939232, 1714600221
Run Time: 0.001913
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, 369242, a:1:{i:0;s:21:"kafa motoru duruyormu";}, 1572939232, 1714600221
Run Time: 0.002060
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, 369278, a:1:{i:0;s:238:"Duruyor detayli resmini atayim size boru kisimlari yapistirildi calisiyor ama sorunsuz yani giris ve cikisina boru yapistirildi o sekilde ayarlandi izah ederim fotolari cekip kullaniliyor yani sorunsuz
Sent from my iPhone using Tapatalk";}, 1572939232, 1714600221
Run Time: 0.003751
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, 369304, a:1:{i:0;s:251:"Bilal bey merhaba, benim kafa motoruna ihtiyacım var fakat ikinci el bir motor ileride bir sorun çıkartır mı diye de düşünüyorum açıkçası. Sizdeki motor ne kadardır kullanılıyor, garantisi var mı, sessiz mi merak ediyorum.
Saygılar.";}, 1572939232, 1714600221
Run Time: 0.007144
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, 369305, a:1:{i:0;s:186:"6500 luk abi biraz sesli bendeki saglamdir ben vana ile ayarlamistim calistiririz sesine bakarsiniz isterseniz ama seslidir cik kuvvetli oldugu icin
Sent from my iPhone using Tapatalk";}, 1572939232, 1714600221
Run Time: 0.002453
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, 369306, a:1:{i:0;s:71:"birde detaylı resim atabilir misiniz Wathsaap tan Tel: 0532 394 24 60";}, 1572939232, 1714600221
Run Time: 0.002571
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, 369307, a:1:{i:0;s:76:"Sessiz olması gerekiyor çünki evimde kullanacağım. Gece rahatsız eder.";}, 1572939232, 1714600221
Run Time: 0.003259
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, 369308, a:1:{i:0;s:212:"Suan stdyoda degilim akvaryum studyoda pazar gunu atabilirim ben 3 metre yukari basiyordum bu kafamotoru ile benim aump ustendi degisk bi sistemdi soradan alttan sumpa gectim
Sent from my iPhone using Tapatalk";}, 1572939232, 1714600221
Run Time: 0.002833
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, 369312, a:1:{i:0;s:28:"Debi ayarı çalışıyormu.";}, 1572939232, 1714600221
Run Time: 0.003613
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, 369313, a:1:{i:0;s:88:"Aynen sesli size gelmez bendeki iyi gunler dilerim
Sent from my iPhone using Tapatalk";}, 1572939232, 1714600221
Run Time: 0.001380
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, 370425, a:1:{i:0;s:228:"Isitici su tamamlama aritma refraktometre akvaryum kum kaya kafa motoru skimmer otomatik yem toplu 1000 tl al kur evine
Skimmer nyos olan es 2800 model curve 9 arkadasimin onun fiyati ayri
Sent from my iPhone using Tapatalk";}, 1572939232, 1714600221
Run Time: 0.002800
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 = 21923)
LIMIT 1
Run Time: 0.000502
| 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: 184
Run Time: 0.000236
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |