SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000123
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT user.*
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,5,6,8,10)) as positive_rating_count
, (user.like_count + coalesce((select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,5,6,8,10)), 0)) as positive_rating_count_incl_likes
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (14,11,12)) as negative_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (2,3,4,7,9,13)) as neutral_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id) as total_rating_count
,xfa_blog.last_entry
,xfa_blog.blog_key
,xfa_blog.entry_count
FROM xf_user AS user
LEFT JOIN xfa_blog ON xfa_blog.user_id = user.user_id
WHERE user.username IN ('Ranza')Run Time: 0.062218
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| PRIMARY | user | const | username | username | 152 | const | 1 | |
| PRIMARY | xfa_blog | const | PRIMARY | PRIMARY | 4 | const | 0 | Unique row not found |
| SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | const | 7 | |
| SUBQUERY | dark_postrating_count | range | user_id_rating | user_id_rating | 8 | | 6 | Using index condition |
| SUBQUERY | dark_postrating_count | range | user_id_rating | user_id_rating | 8 | | 3 | Using index condition |
| SUBQUERY | dark_postrating_count | range | user_id_rating | user_id_rating | 8 | | 5 | Using index condition |
| SUBQUERY | dark_postrating_count | range | user_id_rating | user_id_rating | 8 | | 5 | Using index condition |
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: db3cb3f0675180727c7b8aa22f8e1bba, , 1576154192
Run Time: 0.000175
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_Search, Search, valid, order=relevance, 1576150592,
Run Time: 0.000108
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('no_results_found')Params: 2
Run Time: 0.000063
| Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
|---|
| SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |