SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000114
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,2,4,5,7,8,10)) as positive_rating_count
, ((select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,2,4,5,7,8,10)) + like_count) 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,13)) as negative_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (3,6,9)) as neutral_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id) as total_rating_count
, rating.fb_percent, rating.fb_positive, xc_trade_preference.*
FROM xf_user AS user
LEFT JOIN xc_trade_user AS rating ON rating.user_id=user.user_id
LEFT JOIN xc_trade_preference AS xc_trade_preference ON xc_trade_preference.pr_user_id=user.user_id
WHERE user.user_id = ?
Params: 190159
Run Time: 0.000818
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
PRIMARY | rating | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
PRIMARY | xc_trade_preference | const | PRIMARY | PRIMARY | 4 | const | 0 | unique row not found |
SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | const | 1 | |
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 | | 4 | Using index condition |
SUBQUERY | dark_postrating_count | range | user_id_rating | user_id_rating | 8 | | 7 | Using index condition |
SUBQUERY | dark_postrating_count | range | user_id_rating | user_id_rating | 8 | | 7 | Using index condition |
SELECT search_index.content_type, search_index.content_id
FROM xf_search_index AS search_index
WHERE search_index.user_id = ?
ORDER BY search_index.item_date DESC
LIMIT 200
Params: 190159
Run Time: 0.000254
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | search_index | ref | user_id_item_date | user_id_item_date | 4 | const | 6 | Using where |
SELECT
post.*
,
thread.*, thread.user_id AS thread_user_id, thread.username AS thread_username,
thread.post_date AS thread_post_date,
post.user_id, post.username, post.post_date,
node.title AS node_title, node.node_name,
user.*, IF(user.username IS NULL, post.username, user.username) AS username,
permission.cache_value AS node_permission_cache, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 1) as dark_postrating_1_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 14) as dark_postrating_14_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 2) as dark_postrating_2_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 3) as dark_postrating_3_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 4) as dark_postrating_4_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 5) as dark_postrating_5_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 6) as dark_postrating_6_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 7) as dark_postrating_7_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 8) as dark_postrating_8_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 9) as dark_postrating_9_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 10) as dark_postrating_10_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 11) as dark_postrating_11_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 12) as dark_postrating_12_count
, (select count(*) from dark_postrating pr USE INDEX (`post_id_rating`) where pr.post_id = post.post_id and pr.rating = 13) as dark_postrating_13_count
,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (1,2,4,5,7,8,10)) as positive_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (14,11,12,13)) as negative_rating_count
,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (3,6,9)) as neutral_rating_count
,
pr2.rating, rating.fb_percent, rating.fb_positive, rating.fb_positivetotal, rating.fb_negative, rating.fb_neutral,
permission_combination.cache_value AS global_permission_cache
FROM xf_post AS post
INNER JOIN xf_thread AS thread ON
(thread.thread_id = post.thread_id)
INNER JOIN xf_node AS node ON
(node.node_id = thread.node_id)
LEFT JOIN xf_user AS user ON
(user.user_id = post.user_id)
LEFT JOIN xf_permission_cache_content AS permission
ON (permission.permission_combination_id = 1
AND permission.content_type = 'node'
AND permission.content_id = thread.node_id)
LEFT JOIN dark_postrating pr2 ON (post.post_id = pr2.post_id and pr2.user_id = 0)
LEFT JOIN xc_trade_user AS rating ON rating.user_id=post.user_id
LEFT JOIN xf_permission_combination AS permission_combination ON
(permission_combination.permission_combination_id = user.permission_combination_id)
WHERE post.post_id IN (28515125, 28505495, 28505492, 28153074, 27499279, 27174390)
Run Time: 0.007063
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | post | range | PRIMARY,thread_id_post_date,thread_id_position | PRIMARY | 4 | | 6 | Using where |
PRIMARY | user | eq_ref | PRIMARY | PRIMARY | 4 | foromtb_www.post.user_id | 1 | |
PRIMARY | thread | eq_ref | PRIMARY,node_id_last_post_date,node_id_sticky_state_last_post | PRIMARY | 4 | foromtb_www.post.thread_id | 1 | |
PRIMARY | node | eq_ref | PRIMARY | PRIMARY | 4 | foromtb_www.thread.node_id | 1 | |
PRIMARY | permission | eq_ref | PRIMARY | PRIMARY | 35 | const,const,foromtb_www.thread.node_id | 1 | Using where |
PRIMARY | pr2 | eq_ref | post_id_user_id,post_id_rating,user_id_rating | post_id_user_id | 8 | foromtb_www.post.post_id,const | 1 | |
PRIMARY | rating | eq_ref | PRIMARY | PRIMARY | 4 | foromtb_www.post.user_id | 1 | |
PRIMARY | permission_combination | eq_ref | PRIMARY | PRIMARY | 4 | foromtb_www.user.permission_combination_id | 1 | Using where |
DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | foromtb_www.post.user_id | 1 | Using index condition |
DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | foromtb_www.post.user_id | 1 | Using index condition |
DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | foromtb_www.post.user_id | 1 | Using index condition |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.post.post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.post.post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.post.post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.post.post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.post.post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.post.post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.post.post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.post.post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.post.post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.post.post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.post.post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.post.post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.post.post_id,const | 1 | Using index |
DEPENDENT SUBQUERY | pr | ref | post_id_rating | post_id_rating | 8 | foromtb_www.post.post_id,const | 1 | Using index |
INSERT INTO `xf_search` (`search_results`, `result_count`, `search_type`, `search_query`, `search_constraints`, `search_order`, `search_grouping`, `user_results`, `warnings`, `user_id`, `search_date`, `query_hash`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Params: [["post",28515125],["post",28505495],["post",28505492],["post",28153074],["post",27499279],["post",27174390]], 6, user, , {"user_id":190159,"content":false}, date, 0, , [], 0, 1714084516, 31ea5af93fcc2f58f0f5a0ac60b133a5
Run Time: 0.000518
INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
Params: 74d6e9f328831ed54c4993a2e2b26532, , 1714088116
Run Time: 0.000124