SELECT cache_value FROM xf_permission_combination WHERE permission_combination_id = ?
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 = ?
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 | 1 | |
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 | 3 | |
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
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 | 18 | 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 (20641356, 20171503, 19886153, 19884313, 19360460, 19127209, 16617187, 14134236, 14134173, 14028329, 11404730, 10217098, 9476327, 9418158, 9361610, 9356369, 9271358, 9268722)
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 | 18 | 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_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
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)
SELECT activity.*, user.username FROM xc_trade_activity AS activity LEFT JOIN xf_user AS user ON user.user_id=activity.user_id WHERE activity.user_id=? ORDER BY activity.dateline DESC LIMIT 0, ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | activity | ref | user_id_dateline | user_id_dateline | 4 | const | 1 | Using where |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | foromtb_www.activity.user_id | 1 |
SELECT title, template_compiled FROM xf_template_compiled WHERE title IN ('page_nav', 'message_page', 'nflj_showcase_tab_links', 'xcxt_navtabs', 'waindigo_you_are_using_as_user_loginasuser', 'waindigo_moderator_bar_loginasuser', 'dark_postrating', 'dark_postrating_member', 'dark_postrating_member_totals', 'message_user_info_extra', 'user_criteria_content', 'thread_list_item_icon_key', 'dark_postrating_member_notable_tabs', 'dark_postrating_account_wrapper', 'dark_postrating_navigation_visitor_tab', 'dark_postrating_visitor_panel', 'dark_postrating_member_card', 'dark_postrating_member_info', 'dark_postrating_message_user_info', 'xcfw_copyright', 'xcxt_headinclude', 'xcxt_trading_preferences_link_list', 'xcxt_visitor_panel_addon', 'PAGE_CONTAINER') AND style_id = ? AND language_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | 24 | Using where |
SELECT title, phrase_text FROM xf_phrase_compiled WHERE language_id = ? AND title IN ('no_results_found', 'xcxt_trade')
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | 2 | Using where |
SELECT * FROM xf_notification ORDER BY notification_id
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_notification | index | PRIMARY | 4 | 1 |
SELECT title, template_compiled FROM xf_template_compiled WHERE title IN ('GritterNotifications') AND style_id = ? AND language_id = ?
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|---|---|---|---|---|---|---|---|
SIMPLE | xf_template_compiled | const | PRIMARY | PRIMARY | 60 | const,const,const | 1 |