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.000489
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.000159
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: 24471
Run Time: 0.000424
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.000391
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: 24471
Run Time: 0.001280
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 | 7 | 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 |
SELECT attachment.*,
data.filename, data.file_size, data.file_hash, data.file_path, data.width, data.height, data.thumbnail_width, data.thumbnail_height
FROM xf_attachment AS attachment
INNER JOIN xf_attachment_data AS data ON
(data.data_id = attachment.data_id)
WHERE attachment.content_type = ?
AND attachment.content_id IN (410433)
ORDER BY attachment.content_id, attachment.attach_date
Params: post
Run Time: 0.000329
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | attachment | ref | content_type_id_date | content_type_id_date | 31 | const,const | 2 | Using index condition |
SIMPLE | data | eq_ref | PRIMARY | PRIMARY | 4 | bizimled_db.attachment.data_id | 1 | |
INSERT INTO xf_thread_view
(thread_id)
VALUES
(?)
Params: 24471
Run Time: 0.000076
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 8215acee14090d29e56c48b11db70b0d, , 1713588888
Run Time: 0.000211
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=24471, 1713585288,
Run Time: 0.000105
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000245
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, 410433, a:5:{i:0;s:413:"Kaliteli işlevsel ekipmanları tam bir kurulum için hazırda bekletiyordum kurulum işi aksayınca satmaya karar verdim. Yer ankara.
1-Led aydınlatma: 240watt, ledler yurtdışından özel hazırlanıp geldi mavi ve beyazlar ayrı ayrı kontroledilebiliyor verdiği ışık cidden muazzam, kasa burda yapıldı gayet kibar ve ince üzerinde askı apartı mevcut (bana maliyeti 1600tl) satış fiyatı 1100tl
";i:1;a:4:{s:3:"tag";s:6:"attach";s:6:"option";s:4:"full";s:8:"original";a:2:{i:0;s:13:"[ATTACH=full]";i:1;s:9:"[/ATTACH]";}s:8:"children";a:1:{i:0;s:5:"41036";}}i:2;s:1:" ";i:3;a:4:{s:3:"tag";s:6:"attach";s:6:"option";s:4:"full";s:8:"original";a:2:{i:0;s:13:"[ATTACH=full]";i:1;s:9:"[/ATTACH]";}s:8:"children";a:1:{i:0;s:5:"41037";}}i:4;s:395:"
2-Reef Octopus XP1000SSS Protein Skimmer: Aquamarketim faturalı 6 ay kullanıldı tertemiz eksiksiz kutusunda (sıfır fiyatı 910tl) satış fiyatı 600tl
3-Jebao DCT4000 kontrol üniteli kafa motoru: Akvaryum merkezi faturalı 6 ay kullanıldı tertemiz eksiksiz kutusunda (sıfır fiyatı 250tl) satış fiyatı 175tl
Toplu alım olursa fiyatta yardımcı olurum. İletişim: 05304165576";}, 1572939232, 1713585288
Run Time: 0.001433
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, 410534, a:1:{i:0;s:56:"Kafa motoru sevdiğim bir abime gitti hayırlı olsun :)";}, 1572939232, 1713585288
Run Time: 0.001010
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, 410866, a:1:{i:0;s:26:"Pazarlık payı vardır :)";}, 1572939232, 1713585288
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, 410938, a:1:{i:0;s:70:"Bu ps kaçmaz bide bu fiyatlara :) tertemiz ve çok güzel topluyor :)";}, 1572939232, 1713585288
Run Time: 0.001049
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, 411031, a:1:{i:0;s:1138:"Led armatür hakkında biraz bilgi vereyim 100cm uzunluğunda ince kibar üzerinde askı aparatı takılı olan bi kasası var. Kasa üzerinde sessiz 2 fan ve fanların yanında bi beyaz bi mavi blok olmak üzere toplam 4 blok led var. Ledler reflektörle desteklenmiştir. Armatür toplam 240watt ışık veriyor. Her blok 60watt ve toplam 20ledden oluşuyor. 4 bloğun ikisi mavi ikisi beyaz ledlerde kombinlendi ve mavi ile beyazlar ayrı ayrı yanabiliyor. Ben gündüz hepsi açılır akşam keyif için sadece maviler açılır diye böyle düşünmüştüm. Led kombinleri full spectrum olarak seçilip yurt dışında özel olarak hazırlatılmıştır. Blok detayları aşağıdaki gibidir.
Mavi kanal:
5 adet 380-385 NM Uv epileds
5 adet 420-430 NM deep Blue epileds
20 adet 450-455 NM royal Blue Cree
5 adet 470 NM Blue Cree
5 adet 490-495 NM cyan epileds
Beyaz kanal:
2 adet 3000-3500 Kelvin warm White Cree
2 adet 4000-4500 Kelvin white Cree
4 adet 6500-7000 Kelvin Cold white Cree
6 adet 8000-9000 Kelvin Cree
12 adet 10000 Kelvin Cree
4 adet 620 NM cherry red Cree
5 adet 470 NM Blue Cree
5 adet 490-495 NM cyan epileds";}, 1572939232, 1713585288
Run Time: 0.001029
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, 411193, a:1:{i:0;s:28:"Led armatür ve ps güncel..";}, 1572939232, 1713585288
Run Time: 0.001070
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, 413785, a:1:{i:0;s:8:"Güncell";}, 1572939232, 1713585288
Run Time: 0.000973
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 = 24471)
LIMIT 1
Run Time: 0.000398
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.000191
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |