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.000454
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.000152
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: 27574
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: 149
Run Time: 0.000382
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: 27574
Run Time: 0.001718
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 | 12 | 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: 27574
Run Time: 0.000075
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: b99cb3e45d5419dace6858f9db795d8f, , 1713506765
Run Time: 0.000177
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=27574, 1713503165,
Run Time: 0.000105
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000239
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, 431178, a:8:{i:0;s:745:"Akvaryum 60-25-30h -50 litre
Arkadan sumpli - sump dahil akvaryum boyu 75 cm
Bullet (U) tek parca ekstre clear cam
Akvaryum olculerinde beyaz dolabi
Armatur edison led 3 kanalli 38 watt Beyaz, mavi
Sogutucu 4 lu JBL fan
Ps tunze 9002
Sump motoru nevjet 800
Kum kalin mercan kirigi
5-8 kg canli kaya
Bir cift nemo
Bir cift damsel
Bicolor bleny
Muhtelif lps mercanlar
Kurulum bir yil once yapildi suanda calisir durumda, arzu eden oturmus suyuda alabilir, akvaryum ve sistem cok temizdir, yer ankara iletisim om. Toplu satis 1500 TL.
Not: resimler guncel olup, an itibariyle timera bagli aydinlatmada sadece ortadaki mavi kanal yanmaktadir. Diger iki kanal mavi beyaz kombinasyonu olarak timerla oglene dogru yanmaktadir.
";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:29:"https://hizliresim.com/LnNJmZ";s:8:"original";a:2:{i:0;s:37:"[URL='https://hizliresim.com/LnNJmZ']";i:1;s:6:"[/URL]";}s:8:"children";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:35:"https://i.hizliresim.com/LnNJmZ.jpg";}}}}i:2;s:4:"
";i:3;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:29:"https://hizliresim.com/dGD6mD";s:8:"original";a:2:{i:0;s:37:"[URL='https://hizliresim.com/dGD6mD']";i:1;s:6:"[/URL]";}s:8:"children";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:35:"https://i.hizliresim.com/dGD6mD.jpg";}}}}i:4;s:4:"
";i:5;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:29:"https://hizliresim.com/G0Nqar";s:8:"original";a:2:{i:0;s:37:"[URL='https://hizliresim.com/G0Nqar']";i:1;s:6:"[/URL]";}s:8:"children";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:35:"https://i.hizliresim.com/G0Nqar.jpg";}}}}i:6;s:2:"
";i:7;a:4:{s:3:"tag";s:4:"list";s:6:"option";N;s:8:"original";a:2:{i:0;s:6:"[LIST]";i:1;s:7:"[/LIST]";}s:8:"children";a:1:{i:0;s:2:"
";}}}, 1572939232, 1713503165
Run Time: 0.001876
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, 431185, a:1:{i:0;s:34:"Fiyatta duzeltme 1350 tl olacak...";}, 1572939232, 1713503165
Run Time: 0.001061
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, 431753, a:1:{i:0;s:31:"Ekipman vs ile takasta olabilir";}, 1572939232, 1713503165
Run Time: 0.001128
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, 431779, a:1:{i:0;s:370:"Parca satisa gecilmistir
Akvaryum 60-25-30h -50 litre - Arkadan sumpli - sump dahil akvaryum boyu 75 cm - Bullet (U) tek parca ekstre clear cam 500 tl
Akvaryum olculerinde beyaz dolabi 200 tl
Armatur edison led 3 kanalli 38 watt Beyaz, mavi 300 tl
Ps tunze 9002 200 tl
nemo 50 tl
Bir cift damsel. 80 tl (yumurtluyorlar ve yavrulari cikiyor)
Bicolor bleny. 80 tl";}, 1572939232, 1713503165
Run Time: 0.000889
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, 431813, a:1:{i:0;s:137:"Bu akvaryumu ilk gördüğümden beri çok beğeniyorum, satıldığına üzüldüm. Keşke istanbulda olsaydı. Hayırlı satışlar. :)";}, 1572939232, 1713503165
Run Time: 0.000868
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, 431818, a:1:{i:0;s:229:"Tesekkur ederim Emrah bey, guzelligi emekten geliyor... Bu akvaryum kendi kendine yeten makul seviyede canli kapasitesi olan şık ve kullanisli bir sistem ancak kardesim icin kurmustum zamansizlik yuzunden kendini satista buldu.";}, 1572939232, 1713503165
Run Time: 0.000933
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, 431876, a:1:{i:0;s:65:"Sehir disi isteyen arkadaslar canlilar haric kargo yapilabilir...";}, 1572939232, 1713503165
Run Time: 0.000906
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, 432633, a:1:{i:0;s:137:"Akvaryum canlilar haric muazzam bir paketleme ile kargo yapilabilir. İlan günceldir. U sekilli tasarim ile seyir keyfi ust seviyededir.";}, 1572939232, 1713503165
Run Time: 0.000903
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, 433114, a:1:{i:0;s:67:"Takas onerileriniz gorusulebilir, gercekten cok guzel bir akvaryum.";}, 1572939232, 1713503165
Run Time: 0.000932
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, 433250, a:1:{i:0;s:78:"Bu da güzel olmuş
Tapatalk kullanarak iPhone aracılığıyla gönderildi";}, 1572939232, 1713503165
Run Time: 0.001120
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, 433679, a:2:{i:0;s:447:"Yeni kuruluma fiyat olarakta, gorsellik olarakta cok uygun bir sistem, kurulumuda cok kolay toplam hacim 50 litre oldugundan oturmus bir akvaryumdan alinacak su ile rahatca kurulum yapilabilir boylelikle diatom vs sureci daha kisa olacagindan canli giriside daha erken yapilabilir, dolabin icinde yaklasik 40 litre tatli su deposuda mevcut yaklasik bir ay sistemi idare ediyor gercekten guzel, kullanisli, hobiciyi yormayan, eksiksiz bir sistem.
";i:1;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:29:"https://hizliresim.com/7yblQa";s:8:"original";a:2:{i:0;s:35:"[url=https://hizliresim.com/7yblQa]";i:1;s:6:"[/url]";}s:8:"children";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:35:"https://i.hizliresim.com/7yblQa.jpg";}}}}}, 1572939232, 1713503165
Run Time: 0.000978
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, 433709, a:1:{i:0;s:27:"Tel no atarmısın özelden";}, 1572939232, 1713503165
Run Time: 0.000932
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 = 27574)
LIMIT 1
Run Time: 0.000375
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.000166
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |