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.000560
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.000244
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: 5442
Run Time: 0.000651
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: 10
Run Time: 0.000634
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: 5442
Run Time: 0.002150
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 | 5 | 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: 5442
Run Time: 0.000090
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 74fc92590b242ebff260fe58a9721d7a, , 1713617229
Run Time: 0.000209
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=5442, 1713613629,
Run Time: 0.000122
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000348
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, 57169, a:1:{i:0;s:635:"Arkadaşlar dün akvaryumun 2 florhasanıda vefat etti :) şimdi bakıyorum burada (almanyada) Akvaryumlar için olan florhasanlar çok pahalı.. Birde normal florhasanlar var onlar çok ucuz. Aradaki farkı anlayamadım.. neden onlar çok pahalıda öbürleri çok ucuz.
şimdi siz Daylight veya enaz 6000 kelvin olması lazım diyeceksiniz ama internetten (ebay) 3 tlye bulduğum florhasan daylight ve kelvin değeride 6000 idi (satıcının dediğine göre.) diger akvaryum için olan markalıları 30 liradan satıyorlar.. Ben neden normal 3 liralık florhasan kullanmamamız gerektiğini çözemedim.. Beni bir ikna edermisiniz ?";}, 1572939232, 1713613629
Run Time: 0.002445
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, 908, a:1:{i:0;s:175:"3 adet 120 litre akvaryum içinde 2 çift Melek, 20 Neon, 4 kırmızı dere kereviti, 6 Vatoz, 4 Kılıçkuyruk, 4 Lepistes, 20 yavru lepistes, ben bu işi abarttım galiba :)";}, 1572939232, 1713613629
Run Time: 0.002859
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, 57170, a:2:{i:0;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[b]";i:1;s:4:"[/b]";}s:8:"children";a:1:{i:0;s:76:"akvaryumda neden özel floresan kullanilmali? Beni bir ikna edermisiniz ?";}}i:1;s:958:"
Konuya yaklasirken degerlendirmeyi birkac acidan yapmak gerekir. Akvaryum icin uretilen florasanlarin bir cogunun ambalajinda balik ve ya bitki resmi goruruz. Bunun anlami bitkilerin gelisim ihtiyacinin karsilanmasi ve baliklarin diger canlilarin renklerinin gorsel ortaya cikarilmasi icin uretilmis olduklaridir.
Siradan florasanlar ile bunu saglayamazsiniz ve yanlis isiklandirma akvaryumlardaki atik yukune gore bunlarla istenmeyen yosunu tetikler. Fiyatlarinin pahali olusu ise hobi icin satilmasi yaninda bir hobiye uygun uretilmesidir.
Eger ucuza akvaryumda kullanilacak florasan araniyorsa markalari arastirip kelvin, lumen vb degerlerinden uygun olani satin alinabilir. Ornek olarak siradan bir gun isigi florasan esnafta ornek olarak 20 lira ise elektrikcilerin toplandigi istanbul bankalar caddsi gibi yerlerde 9-10 liraya bulunabilir. 3 liraya akvaryuma florasan eklenir eger sari veya donuk beyaz sizin icin sorun yaratmayacaksa.
Cep mesaj...";}, 1572939232, 1713613629
Run Time: 0.001054
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, 57171, a:2:{i:0;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[b]";i:1;s:4:"[/b]";}s:8:"children";a:1:{i:0;s:75:" akvaryumda neden özel floresan kullanilmali? Beni bir ikna edermisiniz ?";}}i:1;s:279:"
cevabın için sağol abi.. şimdi birtane floresan buldum.. Markası modeli Osram T8 L 18W/865 LUMILUX Daylight
Fiyatı uygun.. 6500 k, 1300 lumen, fiyatıda 5 tl... Akvaryum için uygundur diyor satan firma.. ama birdaha bir görüş alayım dedim.. Belki kullanan vardır...";}, 1572939232, 1713613629
Run Time: 0.001336
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, 57172, a:1:{i:0;s:215:"Akvaryumunuzun özelliklerini belirtmemişsiniz,
T8 18W dediğinize göre 60 cm.boyunda flouresant dan bahsediyoruz.
Akvaryumunuz bitkili ise,Osram lumilux yerine aynı markanın FLUORA isimli ürününü kullanın.";}, 1572939232, 1713613629
Run Time: 0.001240
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, 2915, a:1:{i:0;s:32:"Bitkili,dipte gezenler akvaryumu";}, 1572939232, 1713613629
Run Time: 0.001459
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, 57173, a:2:{i:0;a:4:{s:3:"tag";s:1:"b";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[b]";i:1;s:4:"[/b]";}s:8:"children";a:1:{i:0;s:75:" akvaryumda neden özel floresan kullanilmali? Beni bir ikna edermisiniz ?";}}i:1;s:127:"
Osram florasanları ben oldum olası sevemedim. Aslında akvaryuma uyumlu pek bir modeline de rastlamadım desem yalan olmaz.";}, 1572939232, 1713613629
Run Time: 0.001020
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 = 5442)
LIMIT 1
Run Time: 0.000770
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: 165
Run Time: 0.000268
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT node.*
FROM xf_node AS node
WHERE node.node_id = ?
Params: 3
Run Time: 0.000241
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |