SELECT cache_value
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 1
Run Time: 0.000403
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT
blog.*, blog.user_id blog_exists,
user.*
,user_privacy.allow_view_blog,user_follow.follow_user_id blog_owner_follows_visitor,xfa_blog_watch.watch_id watch_id,xfa_blog_read.blog_read_date
FROM xf_user user
LEFT JOIN xfa_blog blog ON user.user_id = blog.user_id
INNER JOIN xf_user_privacy user_privacy ON user.user_id = user_privacy.user_id LEFT JOIN xf_user_follow user_follow ON user.user_id = user_follow.user_id AND follow_user_id = 0 LEFT JOIN xfa_blog_watch ON user.user_id = xfa_blog_watch.blog_user_id AND xfa_blog_watch.user_id = 0 LEFT JOIN xfa_blog_read ON user.user_id = xfa_blog_read.blog_user_id AND xfa_blog_read.user_id = 0
WHERE
user.user_id = ?
Params: 30087
Run Time: 0.000708
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | user | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | blog | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_privacy | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SIMPLE | user_follow | const | PRIMARY,follow_user_id | PRIMARY | 8 | const,const | 0 | unique row not found |
SIMPLE | xfa_blog_watch | const | ux_watch | ux_watch | 8 | const,const | 0 | unique row not found |
SIMPLE | xfa_blog_read | const | user_id | user_id | 8 | const,const | 0 | unique row not found |
SELECT xfa_blog_entry.*
,xf_user.*,deletion_log.*,liked_content.like_date,xfa_blog_entry_read.entry_read_date,user_follow.follow_user_id blog_owner_follows_visitor
FROM xfa_blog_entry
INNER JOIN xf_user ON xfa_blog_entry.user_id = xf_user.user_id LEFT JOIN xf_deletion_log deletion_log ON xfa_blog_entry.entry_id = deletion_log.content_id AND content_type = 'xfa_blog_entry'
LEFT JOIN xf_liked_content AS liked_content
ON (liked_content.content_type = 'xfa_blog_entry'
AND liked_content.content_id = xfa_blog_entry.entry_id
AND liked_content.like_user_id = 0)
LEFT JOIN xfa_blog_entry_read ON xfa_blog_entry.entry_id = xfa_blog_entry_read.entry_id AND xfa_blog_entry_read.user_id = 0 LEFT JOIN xf_user_follow user_follow ON xfa_blog_entry.user_id = user_follow.user_id AND follow_user_id = 0
WHERE
xfa_blog_entry.user_id = ?
AND (
(xfa_blog_entry.user_id = 0) OR
(xfa_blog_entry.allow_view_entry = 'followed' AND user_follow.follow_user_id > 0) OR
(xfa_blog_entry.allow_view_entry = 'list' AND FIND_IN_SET(0, allow_members_ids) > 0) OR
xfa_blog_entry.allow_view_entry = 'everyone'
)
AND position >= -15 AND position <0
ORDER BY
post_date DESC
Params: 30087
Run Time: 0.000887
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xfa_blog_entry | ref | idx_user,idx_position | idx_user | 4 | const | 1 | Using where; Using filesort |
SIMPLE | deletion_log | eq_ref | PRIMARY | PRIMARY | 31 | const,destee_180205.xfa_blog_entry.entry_id | 1 | Using where |
SIMPLE | liked_content | eq_ref | content_type_id_like_user_id,like_user_content_type_id | content_type_id_like_user_id | 35 | const,destee_180205.xfa_blog_entry.entry_id,const | 1 | Using where |
SIMPLE | xfa_blog_entry_read | eq_ref | user_id | user_id | 8 | const,destee_180205.xfa_blog_entry.entry_id | 1 | |
SIMPLE | user_follow | eq_ref | PRIMARY,follow_user_id | PRIMARY | 8 | destee_180205.xfa_blog_entry.user_id,const | 1 | Using where; Using index |
SIMPLE | xf_user | eq_ref | PRIMARY | PRIMARY | 4 | destee_180205.xfa_blog_entry.user_id | 1 | Using where |
INSERT INTO xfa_blog_view
(user_id, type, ipOrUser, views, last_visit)
VALUES
(?, ?, ?, ?, ?)
ON DUPLICATE KEY UPDATE
views = views + 1,
last_visit = VALUES(last_visit)
Params: 30087, guest, 2728283694, 1, 1524339203
Run Time: 0.000686
INSERT INTO `xfa_blog_deferred_view` (`type`, `id`) VALUES (?, ?)
Params: blog, 30087
Run Time: 0.000485
SELECT
xf_user.*,
xfa_blog_read.blog_read_date,
xfa_blog.last_entry,
xfa_blog.blog_key
FROM xfa_blog_watch
INNER JOIN xf_user ON xfa_blog_watch.blog_user_id = xf_user.user_id
INNER JOIN xfa_blog ON xf_user.user_id = xfa_blog.user_id
LEFT JOIN xfa_blog_read ON xfa_blog.user_id = xfa_blog_read.blog_user_id AND xfa_blog_read.user_id = 0
WHERE
xfa_blog_watch.user_id = ?
ORDER BY
xfa_blog.last_entry DESC
Params: 30087
Run Time: 0.000887
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xfa_blog_watch | ref | ux_watch | ux_watch | 4 | const | 1 | Using index; Using temporary; Using filesort |
SIMPLE | xf_user | eq_ref | PRIMARY | PRIMARY | 4 | destee_180205.xfa_blog_watch.blog_user_id | 1 | Using where |
SIMPLE | xfa_blog | eq_ref | PRIMARY | PRIMARY | 4 | destee_180205.xf_user.user_id | 1 | Using where |
SIMPLE | xfa_blog_read | eq_ref | user_id | user_id | 8 | const,destee_180205.xfa_blog.user_id | 1 | |
SELECT
*
FROM
xfa_blog_category
WHERE
user_id IN (30087,0)
ORDER BY user_id ASC, display_order ASC
Run Time: 0.000196
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xfa_blog_category | range | id_user | id_user | 4 | | 2 | Using index condition; Using filesort |
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, , , XfAddOns_Blogs_ControllerPublic_Blog, Index, valid, user_id=30087, 1524339203,
Run Time: 0.000203
SELECT COUNT(ld_id)
FROM phc_linkdirectory as ld
WHERE (ld.status != 'visible' OR lastcheck = 0)
AND user_id = 0
Run Time: 0.000206
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | ld | ref | status,user_id | user_id | 4 | const | 1 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('page_nav', 'bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'bb_code_tag_spoiler', 'sonnb_xengallery_bbcode_photo', 'sonnb_xengallery_bbcode_video', 'sonnb_xengallery_bbcode_album', 'ssd_ctb_forum_list_nodes', 'ssd_ctb_ad_sidebar_top', 'ssd_ctb_button_top_ctrl', 'aadvapp_sidebar', 'wf_widget_wrapper', 'wf_widget_visitor_panel', 'wf_widget_threads', 'sonnb_xengallery_widget_photo', 'sidebar_premium1', 'wf_widget_profile_posts', 'XM_HashTags_Cloud', 'xfa_blog_wf_blogs', '_widget_renderer_template_202', 'faq_widget_most_popular', 'xfa_blog_index', 'iversia_faq_navtabs', 'sonnb_xengallery_option_copyright', 'sonnbXG_copyright', 'sonnb_xengallery_navbar_template', 'siropu_ads_manager_tabs', 'xfa_blog_navigation_links', 'EWRmedio_Navtabs', 'ld_sub_nav', 'EWRporta2_Navtabs', 'xfa_blog_navigation_tab_link', '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', 'sonnb_xengallery_nav_visitor', '_widget_renderer_template_198', '_widget_renderer_template_199', 'wf_widget_group_wrapper', '_widget_renderer_template_192', '_widget_renderer_template_194', 'destee_chat', 'siropu_chat', 'siropu_chat_disabled', 'siropu_ads_manager_tab_title', 'siropu_ads_manager_ad_type_code', 'siropu_ads_manager_ad_type_banner', 'siropu_ads_manager_ad_type_text', 'siropu_ads_manager_ad_type_link', 'siropu_ads_manager_ad_type_keyword', 'siropu_ads_manager_support_us', 'siropu_ads_manager_page_criteria_page_info', 'siropu_ads_manager_footer_links', 'siropu_ads_manager_admin_home', 'PAGE_CONTAINER')
AND style_id = ?
AND language_id = ?
Params: 10, 1
Run Time: 0.001048
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 68 | Using where |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('iversia_faq', 'tc_premium_page', 'media', 'ld_nav_title')
Params: 1
Run Time: 0.000174
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | range | PRIMARY | PRIMARY | 106 | | 4 | Using where |
SELECT *
FROM `xf_widgetframework_cache`
WHERE cache_id IN ('xfa_blog_index_pc1')
Run Time: 0.000097
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_widgetframework_cache | const | PRIMARY | PRIMARY | 767 | const | 1 | |
SELECT thread.thread_id
FROM xf_thread AS thread
LEFT JOIN xf_user_privacy AS privacy ON
(privacy.user_id = thread.user_id)
WHERE (thread.node_id IN ('149')) AND (thread.discussion_state IN ('visible'))
ORDER BY thread.post_date DESC
LIMIT 6
Run Time: 0.000227
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | index | node_id_last_post_date,node_id_sticky_state_last_post | post_date | 4 | | 12 | Using where |
SELECT thread.*
,
NULL AS thread_read_date,
privacy.snog_flag_view
FROM xf_thread AS thread
LEFT JOIN xf_user_privacy AS privacy ON
(privacy.user_id = thread.user_id)
WHERE thread.thread_id IN (91250, 91248, 91239, 91234, 91233, 91229)
Run Time: 0.000195
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | thread | range | PRIMARY | PRIMARY | 4 | | 6 | Using where |
SIMPLE | privacy | eq_ref | PRIMARY | PRIMARY | 4 | destee_180205.thread.user_id | 1 | |
SELECT content_id, cache_value
FROM xf_permission_cache_content
WHERE permission_combination_id = ?
AND content_type = 'node'
Params: 1
Run Time: 0.000340
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_cache_content | ref | PRIMARY | PRIMARY | 31 | const,const | 320 | Using where |
SELECT node.*, forum.*
,advapp.posid
,advapp.position
,advapp.threadapp
,advapp.threadbutton
FROM xf_forum AS forum
INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
LEFT JOIN xf_snog_applications_positions AS advapp
ON (advapp.node_id = forum.node_id AND advapp.threadapp = 1)
WHERE node.node_id IN (149)
Run Time: 0.000227
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 | advapp | ALL | | | | | 2 | Using where |
SELECT user.*
,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,14,2,13,12,8,11,6,5,10,4,7,9,3)) 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,14,2,13,12,8,11,6,5,10,4,7,9,3)), 0)) as positive_rating_count_incl_likes
,(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.user_id IN (57917, 11469, 26089, 46)
ORDER BY user.username
Run Time: 0.000587
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
PRIMARY | user | range | PRIMARY | PRIMARY | 4 | | 4 | Using where; Using filesort |
PRIMARY | xfa_blog | eq_ref | PRIMARY | PRIMARY | 4 | destee_180205.user.user_id | 1 | Using where |
DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | destee_180205.user.user_id | 1 | |
DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | destee_180205.user.user_id | 1 | Using index condition |
DEPENDENT SUBQUERY | dark_postrating_count | ref | user_id_rating | user_id_rating | 4 | destee_180205.user.user_id | 1 | Using index condition |
SELECT *
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 273
Run Time: 0.000096
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 273
Run Time: 0.000115
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 277
Run Time: 0.000079
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 273
Run Time: 0.000085
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 273
Run Time: 0.000075
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 277
Run Time: 0.000076
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
REPLACE INTO `xf_widgetframework_cache`
SET cache_id = ?, data = ?, cache_date = ?
Params: xfa_blog_index_pc1, {"5":{"html":"<div class=\"WidgetFramework_WidgetRenderer_Threads_Sidebar avatarList\">\n<ul>\n<li class=\"thread-91250 thread-node-149\">\n<a href=\"members\/mario-william-vitale.57917\/\" class=\"avatar Av57917s\" data-avatarhtml=\"true\"><img src=\"data\/avatars\/s\/57\/57917.jpg?1507581375\" width=\"48\" height=\"48\" alt=\"Mario William vitale\" \/><\/a>\n<a href=\"threads\/my-secret-place.91250\/\">\nMy Secret Place\n<\/a>\n<div class=\"userTitle\">\n<a href=\"members\/mario-william-vitale.57917\/\" class=\"username\"><span class=\"style2\">Mario William vitale<\/span><\/a> posted <abbr class=\"DateTime\" data-time=\"1524246270\" data-diff=\"92933\" data-datestring=\"Apr 20, 2018\" data-timestring=\"1:44 PM\">Apr 20, 2018 at 1:44 PM<\/abbr>\n<\/div>\n<\/li>\n<li class=\"thread-91248 thread-node-149\">\n<a href=\"members\/rhymebad.11469\/\" class=\"avatar Av11469s\" data-avatarhtml=\"true\"><img src=\"styles\/default\/xenforo\/avatars\/avatar_s.png\" width=\"48\" height=\"48\" alt=\"rhymebad\" \/><\/a>\n<a title=\"Put these rhymes in a container which exist and consist of one or more words and galore verbs my str\" class=\"Tooltip\"\nhref=\"threads\/put-these-rhymes-in-a-container-which-exist-and-consist-of-one-or-more-words-and-galore-verbs-my-str.91248\/\">\nPut these rhymes in a container...\n<\/a>\n<div class=\"userTitle\">\n<a href=\"members\/rhymebad.11469\/\" class=\"username\"><span class=\"style2\">rhymebad<\/span><\/a> posted <abbr class=\"DateTime\" data-time=\"1524242105\" data-diff=\"97098\" data-datestring=\"Apr 20, 2018\" data-timestring=\"12:35 PM\">Apr 20, 2018 at 12:35 PM<\/abbr>\n<\/div>\n<\/li>\n<\/ul>\n<\/div>","time":1524339203},"110":{"html":"<div class=\"xengallerySidebar\" style=\"display: inline-block;\">\n<div class=\"photosSidebar \" id=\"scrollable_widget_110\" style=\"\">\n<ul>\n<li style=\"max-width: 100%;width: 230px; height: 150px;\">\n<a class=\"thumbnail \" href=\"gallery\/photos\/black-the-rottweiler.3368\/?_source=widget&widget_id=110\" title=\"Black the Rottweiler\" style=\"max-width: 100%; width: 230px; height: 150px;\">\n<img title=\"Black the Rottweiler\" alt=\"Black the Rottweiler\" src=\"data\/photos\/s\/3\/3401-1519684797-5775564c89aedb3d3d3c7800922d4f95.jpg\" style=\"top: -40px; width: 230px; height: 230px;\" \/>\n<\/a>\n<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<script type=\"text\/javascript\">\n!function($, window, document, _undefined) {\nXenForo.register('.photosSidebar a.thumbnail', 'XenForo.XenGalleryOverlayToggle');\n}(jQuery, this, document);\n<\/script>","time":1524338894,"extraData":{"requiredExternals":{"css":["sonnb_xengallery_icons","sonnb_xengallery_widget_photo","sonnb_xengallery_widget","sonnb_xengallery_photo_view"],"js":["js\/sonnb\/XenGallery\/gallery.overlay.js"]}}},"26":{"html":"<div class=\"avatarList\">\n<ul>\n<li>\n<div class=\"userTitle\"><a href=\"https:\/\/destee.com\/faq\/what-are-the-rules.24\/\">What are the rules?<\/a> <span class=\"muted\" title=\"Page Views\">37926 Views<\/span><\/div>\n<\/li>\n<li>\n<div class=\"userTitle\"><a href=\"https:\/\/destee.com\/faq\/where-can-i-post-my-poetry.8\/\">Where can I post my poetry?<\/a> <span class=\"muted\" title=\"Page Views\">11082 Views<\/span><\/div>\n<\/li>\n<li>\n<div class=\"userTitle\"><a href=\"https:\/\/destee.com\/faq\/why-cant-i-post-on-profile-pages.20\/\">Why can't I post on profile pages?<\/a> <span class=\"muted\" title=\"Page Views\">9229 Views<\/span><\/div>\n<\/li>\n<li>\n<div class=\"userTitle\"><a href=\"https:\/\/destee.com\/faq\/is-everyone-welcome-here.11\/\">Is everyone welcome here?<\/a> <span class=\"muted\" title=\"Page Views\">5514 Views<\/span><\/div>\n<\/li>\n<li>\n<div class=\"userTitle\"><a href=\"https:\/\/destee.com\/faq\/how-do-i-put-someone-on-ignore.2\/\">How do I put someone on ignore?<\/a> <span class=\"muted\" title=\"Page Views\">5489 Views<\/span><\/div>\n<\/li>\n<\/ul>\n<\/div>","time":1489793875}}, 1524339203
Run Time: 0.000860
REPLACE INTO `xf_widgetframework_cache`
SET cache_id = ?, data = ?, cache_date = ?
Params: xfa_blog_index_pc1_lock, [{"html":"0","time":1524339203}], 1524339203
Run Time: 0.000331
SELECT content.*
,
album.category_id, album.album_state, album.album_type,
album.content_count, album.photo_count, album.video_count, album.audio_count,
album.album_privacy, album.album_location,
album.cover_content_id, album.cover_content_type,
album.latest_content_ids, album.latest_photo_ids, album.latest_video_ids, album.latest_audio_ids,
album.album_date, album.album_updated_date,
album.title AS album_title, album.description AS album_description,
album.user_id AS album_user_id, album.username AS album_username,
album.comment_count AS album_comment_count,
album.view_count AS album_view_count,
album.likes AS album_likes, album.like_users AS album_like_users,
album.latest_comment_ids AS album_latest_comment_ids,
album.collection_id AS album_collection_id,
category.category_privacy
,
0 AS following_0,
IF(user.username IS NULL, content.username, user.username) AS username, user.avatar_date, user.gravatar,
content_data.*,
0 AS following_0
FROM `sonnb_xengallery_content` AS content
INNER JOIN `sonnb_xengallery_album` AS album ON
(album.album_id = content.album_id)
LEFT JOIN `sonnb_xengallery_category` AS category ON
(album.category_id = category.category_id)
LEFT JOIN `xf_user` AS user ON
(user.user_id = content.user_id)
INNER JOIN `sonnb_xengallery_content_data` AS content_data ON
(content.content_data_id = content_data.content_data_id)
WHERE (content.content_type = 'photo') AND (content.content_state = 'visible')
ORDER BY content.content_date DESC, content.position ASC
LIMIT 3
Run Time: 0.016323
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | album | ALL | PRIMARY | | | | 211 | Using temporary; Using filesort |
SIMPLE | category | eq_ref | PRIMARY | PRIMARY | 4 | destee_180205.album.category_id | 1 | |
SIMPLE | content | ref | album_id_position | album_id_position | 4 | destee_180205.album.album_id | 5 | Using where |
SIMPLE | content_data | eq_ref | PRIMARY,content_type_id | PRIMARY | 4 | destee_180205.content.content_data_id | 1 | |
SIMPLE | user | eq_ref | PRIMARY | PRIMARY | 4 | destee_180205.content.user_id | 1 | |
REPLACE INTO `xf_widgetframework_cache`
SET cache_id = ?, data = ?, cache_date = ?
Params: xfa_blog_index_pc1, {"5":{"html":"<div class=\"WidgetFramework_WidgetRenderer_Threads_Sidebar avatarList\">\n<ul>\n<li class=\"thread-91250 thread-node-149\">\n<a href=\"members\/mario-william-vitale.57917\/\" class=\"avatar Av57917s\" data-avatarhtml=\"true\"><img src=\"data\/avatars\/s\/57\/57917.jpg?1507581375\" width=\"48\" height=\"48\" alt=\"Mario William vitale\" \/><\/a>\n<a href=\"threads\/my-secret-place.91250\/\">\nMy Secret Place\n<\/a>\n<div class=\"userTitle\">\n<a href=\"members\/mario-william-vitale.57917\/\" class=\"username\"><span class=\"style2\">Mario William vitale<\/span><\/a> posted <abbr class=\"DateTime\" data-time=\"1524246270\" data-diff=\"92933\" data-datestring=\"Apr 20, 2018\" data-timestring=\"1:44 PM\">Apr 20, 2018 at 1:44 PM<\/abbr>\n<\/div>\n<\/li>\n<li class=\"thread-91248 thread-node-149\">\n<a href=\"members\/rhymebad.11469\/\" class=\"avatar Av11469s\" data-avatarhtml=\"true\"><img src=\"styles\/default\/xenforo\/avatars\/avatar_s.png\" width=\"48\" height=\"48\" alt=\"rhymebad\" \/><\/a>\n<a title=\"Put these rhymes in a container which exist and consist of one or more words and galore verbs my str\" class=\"Tooltip\"\nhref=\"threads\/put-these-rhymes-in-a-container-which-exist-and-consist-of-one-or-more-words-and-galore-verbs-my-str.91248\/\">\nPut these rhymes in a container...\n<\/a>\n<div class=\"userTitle\">\n<a href=\"members\/rhymebad.11469\/\" class=\"username\"><span class=\"style2\">rhymebad<\/span><\/a> posted <abbr class=\"DateTime\" data-time=\"1524242105\" data-diff=\"97098\" data-datestring=\"Apr 20, 2018\" data-timestring=\"12:35 PM\">Apr 20, 2018 at 12:35 PM<\/abbr>\n<\/div>\n<\/li>\n<\/ul>\n<\/div>","time":1524339203},"110":{"html":"<div class=\"xengallerySidebar\" style=\"display: inline-block;\">\n<div class=\"photosSidebar \" id=\"scrollable_widget_110\" style=\"\">\n<ul>\n<li style=\"max-width: 100%;width: 230px; height: 150px;\">\n<a class=\"thumbnail \" href=\"gallery\/photos\/black-the-rottweiler.3368\/?_source=widget&widget_id=110\" title=\"Black the Rottweiler\" style=\"max-width: 100%; width: 230px; height: 150px;\">\n<img title=\"Black the Rottweiler\" alt=\"Black the Rottweiler\" src=\"data\/photos\/s\/3\/3401-1519684797-5775564c89aedb3d3d3c7800922d4f95.jpg\" style=\"top: -40px; width: 230px; height: 230px;\" \/>\n<\/a>\n<\/li>\n<\/ul>\n<\/div>\n<\/div>\n<script type=\"text\/javascript\">\n!function($, window, document, _undefined) {\nXenForo.register('.photosSidebar a.thumbnail', 'XenForo.XenGalleryOverlayToggle');\n}(jQuery, this, document);\n<\/script>","time":1524339203,"extraData":{"requiredExternals":{"css":["sonnb_xengallery_icons","sonnb_xengallery_widget_photo","sonnb_xengallery_widget","sonnb_xengallery_photo_view"],"js":["js\/sonnb\/XenGallery\/gallery.overlay.js"]}}},"26":{"html":"<div class=\"avatarList\">\n<ul>\n<li>\n<div class=\"userTitle\"><a href=\"https:\/\/destee.com\/faq\/what-are-the-rules.24\/\">What are the rules?<\/a> <span class=\"muted\" title=\"Page Views\">37926 Views<\/span><\/div>\n<\/li>\n<li>\n<div class=\"userTitle\"><a href=\"https:\/\/destee.com\/faq\/where-can-i-post-my-poetry.8\/\">Where can I post my poetry?<\/a> <span class=\"muted\" title=\"Page Views\">11082 Views<\/span><\/div>\n<\/li>\n<li>\n<div class=\"userTitle\"><a href=\"https:\/\/destee.com\/faq\/why-cant-i-post-on-profile-pages.20\/\">Why can't I post on profile pages?<\/a> <span class=\"muted\" title=\"Page Views\">9229 Views<\/span><\/div>\n<\/li>\n<li>\n<div class=\"userTitle\"><a href=\"https:\/\/destee.com\/faq\/is-everyone-welcome-here.11\/\">Is everyone welcome here?<\/a> <span class=\"muted\" title=\"Page Views\">5514 Views<\/span><\/div>\n<\/li>\n<li>\n<div class=\"userTitle\"><a href=\"https:\/\/destee.com\/faq\/how-do-i-put-someone-on-ignore.2\/\">How do I put someone on ignore?<\/a> <span class=\"muted\" title=\"Page Views\">5489 Views<\/span><\/div>\n<\/li>\n<\/ul>\n<\/div>","time":1489793875}}, 1524339203
Run Time: 0.001054
REPLACE INTO `xf_widgetframework_cache`
SET cache_id = ?, data = ?, cache_date = ?
Params: xfa_blog_index_pc1_lock, [{"html":"0","time":1524339203}], 1524339203
Run Time: 0.000445
SELECT profile_post.*
,
posting_user.*,
IF(posting_user.username IS NULL, profile_post.username, posting_user.username) AS username,
receiving_user.username
AS profile_username,
receiving_user.gender
AS profile_gender,
receiving_user.user_state
AS profile_user_state,
receiving_user.user_group_id
AS profile_user_group_id,
receiving_user.secondary_group_ids
AS profile_secondary_group_ids,
receiving_user.display_style_group_id
AS profile_display_style_group_id,
receiving_user.is_banned
AS profile_is_banned,
receiving_user.is_admin
AS profile_is_admin,
receiving_user.is_moderator
AS profile_is_moderator,
receiving_user.avatar_date
AS profile_avatar_date,
receiving_user.gravatar
AS profile_gravatar,
receiving_user.warning_points
AS profile_warning_points,
receiving_user.permission_combination_id
AS profile_permission_combination_id,
receiving_user_privacy.allow_view_profile
AS profile_allow_view_profile,
receiving_user_privacy.allow_post_profile
AS profile_allow_post_profile,
receiving_user_privacy.allow_send_personal_conversation
AS profile_allow_send_personal_conversation,
receiving_user_privacy.allow_view_identities
AS profile_allow_view_identities,
receiving_user_privacy.allow_receive_news_feed
AS profile_allow_allow_receive_news_feed,
IF (receiving_user_follow.follow_user_id, 1, 0)
AS following_0
FROM xf_profile_post AS profile_post
LEFT JOIN xf_user AS posting_user ON
(posting_user.user_id = profile_post.user_id)
LEFT JOIN xf_user AS receiving_user ON
(receiving_user.user_id = profile_post.profile_user_id)
LEFT JOIN xf_user_privacy AS receiving_user_privacy ON
(receiving_user_privacy.user_id = profile_post.profile_user_id)
LEFT JOIN xf_user_follow AS receiving_user_follow ON
(receiving_user_follow.user_id = profile_post.profile_user_id AND follow_user_id = 0)
WHERE (profile_post.message_state IN ('visible'))
ORDER BY profile_post.post_date DESC
LIMIT 9
Run Time: 0.000564
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | profile_post | index | | post_date | 4 | | 9 | Using where |
SIMPLE | posting_user | eq_ref | PRIMARY | PRIMARY | 4 | destee_180205.profile_post.user_id | 1 | |
SIMPLE | receiving_user | eq_ref | PRIMARY | PRIMARY | 4 | destee_180205.profile_post.profile_user_id | 1 | |
SIMPLE | receiving_user_privacy | eq_ref | PRIMARY | PRIMARY | 4 | destee_180205.profile_post.profile_user_id | 1 | |
SIMPLE | receiving_user_follow | eq_ref | PRIMARY,follow_user_id | PRIMARY | 8 | destee_180205.profile_post.profile_user_id,const | 1 | Using index |
SELECT *
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 273
Run Time: 0.000092
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 279
Run Time: 0.000078
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 333
Run Time: 0.000076
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 410
Run Time: 0.000088
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 273
Run Time: 0.000117
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 273
Run Time: 0.000096
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 277
Run Time: 0.000078
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 277
Run Time: 0.000078
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT *
FROM xf_permission_combination
WHERE permission_combination_id = ?
Params: 333
Run Time: 0.000074
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_permission_combination | const | PRIMARY | PRIMARY | 4 | const | 1 | |
SELECT hashtags.*, count(*) hashcount,
sum(case when date_posted > 1524137603 then 5 when date_posted > 1523936003 then 3 else 1 end) weight
FROM xm_hashtags AS hashtags
where date_posted > 1523734403 and public = 1
GROUP BY hashtag
ORDER BY weight
DESC
LIMIT 25
Run Time: 0.000239
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | hashtags | range | date_posted | date_posted | 4 | | 1 | Using index condition; Using temporary; Using filesort |
SELECT *
FROM xf_faq_question
WHERE sticky = 1 and moderation = 0
ORDER BY display_order ASC, view_count DESC LIMIT 5
Run Time: 0.000184
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_faq_question | ALL | | | | | 66 | Using where; Using filesort |
SELECT title, phrase_text
FROM xf_phrase_compiled
WHERE language_id = ?
AND title IN ('wf_faq_sticky')
Params: 1
Run Time: 0.000102
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_phrase_compiled | const | PRIMARY | PRIMARY | 106 | const,const | 1 | |
SELECT d.*, ct.*, s.title as slider_title
FROM xfa_slider_display AS d
LEFT JOIN xfa_slider_content_template AS ct ON (d.content_template_id=ct.content_template_id)
LEFT JOIN xfa_slider AS s ON (d.slider_id=s.slider_id)
Run Time: 0.000281
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | d | ALL | | | | | 1 | |
SIMPLE | ct | eq_ref | PRIMARY | PRIMARY | 4 | destee_180205.d.content_template_id | 1 | |
SIMPLE | s | eq_ref | PRIMARY | PRIMARY | 4 | destee_180205.d.slider_id | 1 | |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('ssd_ctb_button_top_ctrl', 'aadvapp_sidebar', 'sonnbXG_copyright', 'dark_azucloud')
AND style_id = ?
AND language_id = ?
Params: 10, 1
Run Time: 0.000211
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 4 | Using where |
SELECT title, template_compiled
FROM xf_template_compiled
WHERE title IN ('ssd_ctb_button_top_ctrl', 'aadvapp_sidebar', 'nat_bodyjs')
AND style_id = ?
AND language_id = ?
Params: 10, 1
Run Time: 0.000113
Select Type | Table | Type | Possible Keys | Key | Key Len | Ref | Rows | Extra |
---|
SIMPLE | xf_template_compiled | range | PRIMARY | PRIMARY | 60 | | 3 | Using where |