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.000471
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.000176
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: 26787
Run Time: 0.000564
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: 189
Run Time: 0.000479
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: 26787
Run Time: 0.001646
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 | 1 | 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: 26787
Run Time: 0.000085
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: ab8d72fc38898a61787980fc88bfc223, , 1713420609
Run Time: 0.000192
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=26787, 1713417009,
Run Time: 0.000100
SELECT *
FROM `xf_widget`
WHERE `widget_page_id` = 0
ORDER BY display_order ASC
Run Time: 0.000242
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, 429571, a:1:{i:0;s:1702:"Değeri arkadaşlar,
Kenya balık ithalatımız stoklara girmiştir.
TANG
Powder blue tang
Powder blue tang
Powder blue tang
Desjardin`s Sailfin Tang
Desjardin`s Sailfin Tang
Gold eye docter Juveline Yellow color
Blue Tang - Yellow belly 1.0 - 3 cm
Blue Tang - Yellow belly 3 cm - 7 cm
Naso tang
Naso tang
ANTHIAS
Lyrtail coralfish squamipinnis (female-dişi)
Lyrtail coralfish squamipinnis (male-erkek)
WRASSE
Radiant Wrasse
Sexstriped Wrasse ( sixline wrasse )
Leopard Wrasse female
Yellow-tail Tamarin
Clown Coris
Clown Coris
Exquisite Wrasse
Exquisite Wrasse
Bluestreak cleaner wrasse
Adorned Wrasse
Adorned Wrasse
Queen Coris
Queen Coris
African Clown Wrasse (orange juveline col)
African Clown Wrasse
Yellow-breasted wrasse
Pink flasher
Mystery Wrasse
ANGEL
Emperor Angel (juveline color)
Koran Angelfish
Threespot angelfish,
Coral beauty Angelfish
Coral beauty Angelfish
African pygmy Angelfish
DAMSEL-CHROMIS-CARDINAL
Green Cromis Damsel
Green Cromis Damsel
Zebra damsel
Lined Chromis
Cloudy dascyllus
Blue Damsel
Chromis half half
Pajama cardinal
GOBY-BLENNY
Jewelled Roskskipper (redfin)
Pinkbar goby
Mossambicus Blenny
Pretty Prawn Goby
PERCULA
Skunk clownfish
Allard´s clownfish
Allard´s clownfish
Allard´s clownfish
Yellow-bellied Anemonefish
BUTTERFLY
Morris Idol
Treadfin Butterflyfish
Blackback Butterflyfish
Vagabond Butterflyfish
Longfin batfish
Longfin batfish
Copperband Butterfly (M)
DİĞERLERİ
Snubnose Pompano
Golden travally
Golden travally
Long nose file fish
Black saddled toby
Peacock Puffer
Picasso triggerfish
Black-sided hawkfish
Yellowsaddle Goatfish
Black Boxfish
Yellow box fish
Balloonfish
Foxface
Snowflake müren
Soldier fish
Saygılarımızla,";}, 1572939232, 1713417009
Run Time: 0.002478
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, 9098, a:1:{i:0;s:74:"Ergün Köroğlu ( Satış Sorumlusu )
Akvaryum Merkezi & Konsept Akvaryum";}, 1572939232, 1713417009
Run Time: 0.001298
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 = 26787)
LIMIT 1
Run Time: 0.000395
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: 130
Run Time: 0.000193
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | node | const | PRIMARY | PRIMARY | 4 | const | 1 | |