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.000484
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.000222
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: 8201
Run Time: 0.000537
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: 6
Run Time: 0.000408
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: 8201
Run Time: 0.001480
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 | 4 | 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: 8201
Run Time: 0.000081
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: d6f4a430656fd14ddafd6cd47ee6945f, , 1713600806
Run Time: 0.000231
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=8201, 1713597206,
Run Time: 0.000110
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000264
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, 95977, a:17:{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;a:4:{s:3:"tag";s:1:"i";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[I]";i:1;s:4:"[/I]";}s:8:"children";a:2:{i:0;s:1191:"Boyut (cm): 100*30*40(h)
Kapasite (litre): 120 Litre
Canlılar: 4d.1e Sarıprenses-Leopar Vatoz-2tane Bronz Çöpçü
Malzemeler: Tetretec Ex 700 Dış Filtre, Tetratec Ht 300 W Isıtıcı, Tetretec Aps 100 Hava Motoru,Led Aydınlatma(5 adet mavi su geçirmez modül(5*5=25 led),5 adet beyaz su geçirmez modül(5*5=25 led),Toplamda 50 led)
Akvaryum Bakımı: Haftada bir kere 20% su değişimi ve dip çekimi
Kullanılan Yemler: Sera Granugreen, NLS Cichlid Formula,Nls Thera A+,Sera Flora,Tetra Pro Vegetable,Tetramin,Aim Blood Worms(Kurutulmuş Kan Kurdu),Sera Wels Chips.
Kullanılan İlaçlar ve/veya Katkılar: Ayda bir kere bemiks vitamin ve hastalık durumunda bir miktar kaya tuzu
Taban Malzemesi olarak 20 kilo 0.1mm Silis Kum kullanıldı.Kayalar doğadan topladığım,lav taşına benzer gözenekli taşlardır.
Evet arkadaşlar sonunda tam anlamıyla tamamlanan 1 e 4 d sarı prenses akvaryumumun fotoğraflarını paylaşıyorum.Telefonla çekim yaptığım için resimlerin kalitesi biraz düşük olabilir kusura bakamayın.Ayrıca arka camdaki siyah desenlerin nedeni arka fonunla cam arasına biraz su kaçmışta ondan:D...
İyi Seyirler...
";i:1;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#0000ff";s:8:"original";a:2:{i:0;s:17:"[COLOR="#0000ff"]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"5";s:8:"original";a:2:{i:0;s:10:"[SIZE="5"]";i:1;s:7:"[/SIZE]";}s:8:"children";a:1:{i:0;s:48:"Maşallah demeyi esirgemezseniz çok sevinirim:)";}}}}}}}}i:1;s:70:"
:nazar::nazar::nazar::nazar::nazar::nazar::nazar:: nazar:
";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:34:"http://i53.tinypic.com/1zgggtu.jpg";}}i:3;s:4:"
";i:4;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:43:"http://img341.imageshack.us/i/48088479.jpg/";s:8:"original";a:2:{i:0;s:49:"[URL=http://img341.imageshack.us/i/48088479.jpg/]";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:51:"http://img341.imageshack.us/img341/474/48088479.jpg";}}}}i:5;s:4:"
";i:6;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:43:"http://img525.imageshack.us/i/36975953.jpg/";s:8:"original";a:2:{i:0;s:49:"[URL=http://img525.imageshack.us/i/36975953.jpg/]";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:52:"http://img525.imageshack.us/img525/7046/36975953.jpg";}}}}i:7;s:4:"
";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:34:"http://i55.tinypic.com/2wgvzat.jpg";}}i:9;s:4:"
";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:43:"http://img703.imageshack.us/i/61229812.jpg/";}}i:11;s:2:"
";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:34:"http://i51.tinypic.com/210doja.jpg";}}i:13;s:4:"
";i:14;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:43:"http://img249.imageshack.us/i/32123623.jpg/";s:8:"original";a:2:{i:0;s:49:"[URL=http://img249.imageshack.us/i/32123623.jpg/]";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:52:"http://img249.imageshack.us/img249/5074/32123623.jpg";}}}}i:15;s:4:"
";i:16;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#008080";s:8:"original";a:2:{i:0;s:17:"[COLOR="#008080"]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:4:"size";s:6:"option";s:1:"6";s:8:"original";a:2:{i:0;s:10:"[SIZE="6"]";i:1;s:7:"[/SIZE]";}s:8:"children";a:1:{i:0;s:95:"Video...Kalitesi resimlerden biraz daha iyi...
[video]http://tinypic.com/r/33uddlk/7[/video]";}}}}}, 1572939232, 1713597206
Run Time: 0.001950
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, 4990, a:1:{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;a:4:{s:3:"tag";s:1:"i";s:6:"option";N;s:8:"original";a:2:{i:0;s:3:"[I]";i:1;s:4:"[/I]";}s:8:"children";a:1:{i:0;a:4:{s:3:"tag";s:5:"color";s:6:"option";s:7:"#008080";s:8:"original";a:2:{i:0;s:17:"[COLOR="#008080"]";i:1;s:8:"[/COLOR]";}s:8:"children";a:1:{i:0;s:266:"100*30*40(h)(120 lt.) 1e.-4d. SP/1e.-3d.İceman Tankı ^^Tatratec Ex 700-Tetratec Aps 100-Tatratec HT300^^///70*26,5*34(h)(64 lt.) Canlı Doğuran Tankı ^^Atman Hf400-Minjiang MJ 100-Resun AC 2000 Air Pump///Hacettepe Üni. Öğrenci ^^Tam bir TETRATEC aşığı^^
";}}}}}}}, 1572939232, 1713597206
Run Time: 0.001807
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, 95978, 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:68:"Cevap: Sonunda Tam Anlamıyla Tamamlanan Sarı Prenses Akvaryumum...";}}i:1;s:428:"
Yunus Emre tebrikler çok güzel olmuş. Duru ve sade görünüyor. Arka fon çok güzelmiş, sanki deniz tabanı uzayıp gidiyor, üst kısım ise güneşin aydınlatması gibi bir hava yaratmış. Fon mu bu yoksa fotoğraf yansımaları mı ? Kamış hava katmış akvaryuma, sol tarafa hafif yükesk bir dekor yaparsan çok daha güzel görünür.
Maşallah maşallah, keyifli ve sağlıklı yürütmeni dilerim. :nazar:";}, 1572939232, 1713597206
Run Time: 0.001400
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, 95979, a:5:{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:68:"Cevap: Sonunda Tam Anlamıyla Tamamlanan Sarı Prenses Akvaryumum...";}}i:1;s:2:"
";i:2;a:4:{s:3:"tag";s:5:"quote";s:6:"option";s:22:"YIKIKTEMO, post: 95978";s:8:"original";a:2:{i:0;s:32:"[quote="YIKIKTEMO, post: 95978"]";i:1;s:8:"[/QUOTE]";}s:8:"children";a:1:{i:0;s:426:"Yunus Emre tebrikler çok güzel olmuş. Duru ve sade görünüyor. Arka fon çok güzelmiş, sanki deniz tabanı uzayıp gidiyor, üst kısım ise güneşin aydınlatması gibi bir hava yaratmış. Fon mu bu yoksa fotoğraf yansımaları mı ? Kamış hava katmış akvaryuma, sol tarafa hafif yükesk bir dekor yaparsan çok daha güzel görünür.
Maşallah maşallah, keyifli ve sağlıklı yürütmeni dilerim. :nazar:";}}i:3;s:751:"
Teşekkür ederim Temel Abi...
Hani denize dalınca alttan yukarı bakarsınız hafif dalgalı olur yüzey,forun üst kısmı da öyle.O yüzeye beyaz ve mavi ledler vurunca güneş gibi olmuş.Bir de bilir misiniz bilmiyorum hani plastik kapaklı akvaryumların florosan yerleri tam 1 m. olmaz yanlardan boşluklar vardır.Yaklaşık 80 cm olur.Bu yüzden yanlara led takamadım.Ledlerin hepsi tam o kısımdan vurunca tek bir noktadan güneş ışığı gibi oldu.Yani tamamen fonla alakalı birşey fotograf yansımaları kaynaklı değil.Bambuyu bir türlü büyütemedim.Yapraklarını sürekli didikliyorlar.Fotoğraftan da anlayacağınız gibi yaprakları delik deşik:)
Fonun resmini koyayım daha iyi anlaşılır sanırım abi...
";i:4;a:4:{s:3:"tag";s:3:"url";s:6:"option";s:42:"http://img411.imageshack.us/i/adszzkf.png/";s:8:"original";a:2:{i:0;s:48:"[URL=http://img411.imageshack.us/i/adszzkf.png/]";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:51:"http://img411.imageshack.us/img411/3973/adszzkf.png";}}}}}, 1572939232, 1713597206
Run Time: 0.002888
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, 95980, 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:68:"Cevap: Sonunda Tam Anlamıyla Tamamlanan Sarı Prenses Akvaryumum...";}}i:1;s:189:"
Tek kelimeyle mükemmel bir fon. Tuzlu su akvaryumlarına harika yakışır bu fon. Bambunun su üstünde kalan kısmı gelişir diye düşünüyorum. Arka fonda aklım kaldı yanlız. ;)";}, 1572939232, 1713597206
Run Time: 0.001610
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 = 8201)
LIMIT 1
Run Time: 0.000519
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.000256
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.000192
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |