Page Time: 0.6485s

Memory: 6.7257 MB (Peak: 32.7265 MB)

Queries (421, time: 0.1458s, 22.5%)

  1. SELECT *
    FROM xf_brivium_addon
    ORDER BY addon_id
    Run Time: 0.000293
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_brivium_addonindex PRIMARY77 1 
  2. INSERT INTO xf_data_registry
    	(data_key, data_value)
    VALUES
    	(?, ?)
    ON DUPLICATE KEY UPDATE
    	data_value = VALUES(data_value)
    Params: brBriviumAddOns, a:0:{}
    Run Time: 0.000299
  3. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000226
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  4. 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 10
    Run Time: 0.001000
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEprofile_postindex post_date4 10Using where
    SIMPLEposting_usereq_refPRIMARYPRIMARY4zfgpkire_xenforo.profile_post.user_id1 
    SIMPLEreceiving_usereq_refPRIMARYPRIMARY4zfgpkire_xenforo.profile_post.profile_user_id1 
    SIMPLEreceiving_user_privacyeq_refPRIMARYPRIMARY4zfgpkire_xenforo.profile_post.profile_user_id1 
    SIMPLEreceiving_user_followeq_refPRIMARY,follow_user_idPRIMARY8zfgpkire_xenforo.profile_post.profile_user_id,const1Using index
  5. SELECT *
    FROM xf_node
    WHERE display_in_list = 1
    ORDER BY lft ASC
    Run Time: 0.000391
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_nodeALLdisplay_in_list   63Using where; Using filesort
  6. SELECT content_id, cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = 'node'
    Params: 1
    Run Time: 0.000351
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_cache_contentrefPRIMARYPRIMARY31const,const68Using where
  7. SELECT forum.*
    	,
    		NULL AS forum_read_date
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE forum.node_id IN (273, 275, 252, 254, 253, 248, 30, 34, 268, 269, 270, 272, 31, 211, 33, 32, 35, 212, 36, 37, 39, 40, 41, 43, 53, 45, 125, 126, 127, 128, 129, 46, 130, 131, 132, 133, 134, 47, 140, 141, 142, 48, 143, 144, 145, 49, 135, 136, 137, 138, 139, 271, 66, 173, 174, 69, 77, 124, 78, 79, 80, 210)
    Run Time: 0.000544
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumALLPRIMARY   63Using where
    SIMPLEnodeeq_refPRIMARYPRIMARY4zfgpkire_xenforo.forum.node_id1Using index
  8. SELECT session_activity.*
    	,
    	user.*
    FROM xf_session_activity AS session_activity
    
    	LEFT JOIN xf_user AS user ON
    		(user.user_id = session_activity.user_id)
    WHERE (session_activity.view_date > 1544077822)
    ORDER BY session_activity.view_date DESC
    Run Time: 0.043777
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEsession_activityrangeview_dateview_date4 3350Using where
    SIMPLEusereq_refPRIMARYPRIMARY4zfgpkire_xenforo.session_activity.user_id1 
  9. SELECT * FROM xf_thread WHERE   node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC LIMIT 10
    Run Time: 0.000229
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadindexnode_id_last_post_date,node_id_sticky_state_last_postlast_post_date4 19Using where
  10. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '95622'
    Run Time: 0.000069
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  11. SELECT last_post_date FROM xf_thread WHERE  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001538
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3941Using where; Using index; Using filesort
  12. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 252
    Run Time: 0.000320
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  13. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56268 AND user_id = '0'
    Run Time: 0.000068
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  14. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000101
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  15. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '18325'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  16. SELECT last_post_date FROM xf_thread WHERE  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001360
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3941Using where; Using index; Using filesort
  17. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 252
    Run Time: 0.000251
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  18. SELECT thread_id FROM xf_thread_read WHERE thread_id = 9309 AND user_id = '0'
    Run Time: 0.000081
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  19. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000100
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  20. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96631'
    Run Time: 0.000065
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  21. SELECT last_post_date FROM xf_thread WHERE  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001328
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3941Using where; Using index; Using filesort
  22. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 252
    Run Time: 0.000258
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  23. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56976 AND user_id = '0'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  24. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000087
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  25. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '39493'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  26. SELECT last_post_date FROM xf_thread WHERE  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001345
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3941Using where; Using index; Using filesort
  27. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 253
    Run Time: 0.000269
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  28. SELECT thread_id FROM xf_thread_read WHERE thread_id = 20208 AND user_id = '0'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  29. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000087
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  30. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96627'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  31. SELECT last_post_date FROM xf_thread WHERE  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001331
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3941Using where; Using index; Using filesort
  32. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 37
    Run Time: 0.000260
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  33. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56973 AND user_id = '0'
    Run Time: 0.000092
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  34. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000086
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  35. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96624'
    Run Time: 0.000104
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  36. SELECT last_post_date FROM xf_thread WHERE  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001323
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3941Using where; Using index; Using filesort
  37. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 30
    Run Time: 0.000241
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  38. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56970 AND user_id = '0'
    Run Time: 0.000080
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  39. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000085
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  40. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96617'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  41. SELECT last_post_date FROM xf_thread WHERE  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001339
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3941Using where; Using index; Using filesort
  42. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 268
    Run Time: 0.000248
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  43. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56963 AND user_id = '0'
    Run Time: 0.000081
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  44. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000089
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  45. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96615'
    Run Time: 0.000065
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  46. SELECT last_post_date FROM xf_thread WHERE  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001335
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3941Using where; Using index; Using filesort
  47. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 30
    Run Time: 0.000253
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  48. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56962 AND user_id = '0'
    Run Time: 0.000080
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  49. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000087
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  50. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96613'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  51. SELECT last_post_date FROM xf_thread WHERE  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001322
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3941Using where; Using index; Using filesort
  52. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 30
    Run Time: 0.000241
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  53. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56960 AND user_id = '0'
    Run Time: 0.000080
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  54. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000089
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  55. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96604'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  56. SELECT last_post_date FROM xf_thread WHERE  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001323
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3941Using where; Using index; Using filesort
  57. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 30
    Run Time: 0.000235
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  58. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56951 AND user_id = '0'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  59. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000089
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  60. SELECT * FROM xf_thread WHERE   node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC LIMIT 10
    Run Time: 0.000154
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadindexnode_id_last_post_date,node_id_sticky_state_last_postlast_post_date4 19Using where
  61. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '95622'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  62. SELECT last_post_date FROM xf_thread WHERE  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001317
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3941Using where; Using index; Using filesort
  63. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 252
    Run Time: 0.000282
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  64. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56268 AND user_id = '0'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  65. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000098
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  66. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '18325'
    Run Time: 0.000065
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  67. SELECT last_post_date FROM xf_thread WHERE  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001300
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3941Using where; Using index; Using filesort
  68. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 252
    Run Time: 0.000245
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  69. SELECT thread_id FROM xf_thread_read WHERE thread_id = 9309 AND user_id = '0'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  70. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000085
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  71. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96631'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  72. SELECT last_post_date FROM xf_thread WHERE  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001308
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3941Using where; Using index; Using filesort
  73. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 252
    Run Time: 0.000253
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  74. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56976 AND user_id = '0'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  75. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000088
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  76. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '39493'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  77. SELECT last_post_date FROM xf_thread WHERE  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001326
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3941Using where; Using index; Using filesort
  78. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 253
    Run Time: 0.000233
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  79. SELECT thread_id FROM xf_thread_read WHERE thread_id = 20208 AND user_id = '0'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  80. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000088
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  81. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96627'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  82. SELECT last_post_date FROM xf_thread WHERE  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001301
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3941Using where; Using index; Using filesort
  83. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 37
    Run Time: 0.000242
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  84. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56973 AND user_id = '0'
    Run Time: 0.000068
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  85. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000087
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  86. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96624'
    Run Time: 0.000070
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  87. SELECT last_post_date FROM xf_thread WHERE  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001320
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3941Using where; Using index; Using filesort
  88. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 30
    Run Time: 0.000237
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  89. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56970 AND user_id = '0'
    Run Time: 0.000068
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  90. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000087
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  91. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96617'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  92. SELECT last_post_date FROM xf_thread WHERE  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001316
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3941Using where; Using index; Using filesort
  93. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 268
    Run Time: 0.000236
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  94. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56963 AND user_id = '0'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  95. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000086
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  96. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96615'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  97. SELECT last_post_date FROM xf_thread WHERE  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001305
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3941Using where; Using index; Using filesort
  98. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 30
    Run Time: 0.000238
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  99. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56962 AND user_id = '0'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  100. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000087
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  101. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96613'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  102. SELECT last_post_date FROM xf_thread WHERE  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001333
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3941Using where; Using index; Using filesort
  103. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 30
    Run Time: 0.000246
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  104. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56960 AND user_id = '0'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  105. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000085
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  106. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96604'
    Run Time: 0.000065
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  107. SELECT last_post_date FROM xf_thread WHERE  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.001316
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 3941Using where; Using index; Using filesort
  108. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 30
    Run Time: 0.000264
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  109. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56951 AND user_id = '0'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  110. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000085
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  111. SELECT * FROM xf_thread WHERE node_id IN(30,31,32,33,34,35,211,212,36,37,52,261,268,269,270,272) AND  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC LIMIT 10
    Run Time: 0.000146
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadindexnode_id_last_post_date,node_id_sticky_state_last_postlast_post_date4 29Using where
  112. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96627'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  113. SELECT last_post_date FROM xf_thread WHERE node_id IN(30,31,32,33,34,35,211,212,36,37,52,261,268,269,270,272) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000523
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 2670Using where; Using index; Using filesort
  114. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 37
    Run Time: 0.000287
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  115. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56973 AND user_id = '0'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  116. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000087
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  117. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96624'
    Run Time: 0.000070
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  118. SELECT last_post_date FROM xf_thread WHERE node_id IN(30,31,32,33,34,35,211,212,36,37,52,261,268,269,270,272) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000472
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 2670Using where; Using index; Using filesort
  119. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 30
    Run Time: 0.000242
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  120. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56970 AND user_id = '0'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  121. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000085
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  122. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96617'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  123. SELECT last_post_date FROM xf_thread WHERE node_id IN(30,31,32,33,34,35,211,212,36,37,52,261,268,269,270,272) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000492
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 2670Using where; Using index; Using filesort
  124. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 268
    Run Time: 0.000231
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  125. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56963 AND user_id = '0'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  126. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000084
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  127. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96615'
    Run Time: 0.000065
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  128. SELECT last_post_date FROM xf_thread WHERE node_id IN(30,31,32,33,34,35,211,212,36,37,52,261,268,269,270,272) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000483
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 2670Using where; Using index; Using filesort
  129. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 30
    Run Time: 0.000231
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  130. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56962 AND user_id = '0'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  131. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000085
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  132. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96613'
    Run Time: 0.000079
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  133. SELECT last_post_date FROM xf_thread WHERE node_id IN(30,31,32,33,34,35,211,212,36,37,52,261,268,269,270,272) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000493
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 2670Using where; Using index; Using filesort
  134. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 30
    Run Time: 0.000242
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  135. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56960 AND user_id = '0'
    Run Time: 0.000081
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  136. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000085
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  137. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96604'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  138. SELECT last_post_date FROM xf_thread WHERE node_id IN(30,31,32,33,34,35,211,212,36,37,52,261,268,269,270,272) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000495
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 2670Using where; Using index; Using filesort
  139. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 30
    Run Time: 0.000239
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  140. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56951 AND user_id = '0'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  141. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000086
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  142. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96588'
    Run Time: 0.000070
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  143. SELECT last_post_date FROM xf_thread WHERE node_id IN(30,31,32,33,34,35,211,212,36,37,52,261,268,269,270,272) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000502
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 2670Using where; Using index; Using filesort
  144. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 272
    Run Time: 0.000230
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  145. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56936 AND user_id = '0'
    Run Time: 0.000065
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  146. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000085
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  147. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96196'
    Run Time: 0.000092
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  148. SELECT last_post_date FROM xf_thread WHERE node_id IN(30,31,32,33,34,35,211,212,36,37,52,261,268,269,270,272) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000490
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 2670Using where; Using index; Using filesort
  149. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 30
    Run Time: 0.000224
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  150. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56711 AND user_id = '0'
    Run Time: 0.000065
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  151. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000097
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  152. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '95988'
    Run Time: 0.000077
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  153. SELECT last_post_date FROM xf_thread WHERE node_id IN(30,31,32,33,34,35,211,212,36,37,52,261,268,269,270,272) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000476
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 2670Using where; Using index; Using filesort
  154. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 30
    Run Time: 0.000235
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  155. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56516 AND user_id = '0'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  156. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000084
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  157. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '95956'
    Run Time: 0.000065
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  158. SELECT last_post_date FROM xf_thread WHERE node_id IN(30,31,32,33,34,35,211,212,36,37,52,261,268,269,270,272) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000488
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 2670Using where; Using index; Using filesort
  159. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 31
    Run Time: 0.000240
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  160. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56485 AND user_id = '0'
    Run Time: 0.000082
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  161. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000085
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  162. SELECT * FROM xf_thread WHERE node_id IN(40,41,43,53,38,39) AND  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC LIMIT 10
    Run Time: 0.000156
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_last_post_date4 244Using where; Using filesort
  163. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '95125'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  164. SELECT last_post_date FROM xf_thread WHERE node_id IN(40,41,43,53,38,39) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000112
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 244Using where; Using index; Using filesort
  165. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 39
    Run Time: 0.000290
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  166. SELECT thread_id FROM xf_thread_read WHERE thread_id = 55837 AND user_id = '0'
    Run Time: 0.000065
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  167. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000086
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  168. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '14810'
    Run Time: 0.000081
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  169. SELECT last_post_date FROM xf_thread WHERE node_id IN(40,41,43,53,38,39) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000113
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 244Using where; Using index; Using filesort
  170. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 53
    Run Time: 0.000250
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  171. SELECT thread_id FROM xf_thread_read WHERE thread_id = 6715 AND user_id = '0'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  172. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000086
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  173. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '89879'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  174. SELECT last_post_date FROM xf_thread WHERE node_id IN(40,41,43,53,38,39) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000112
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 244Using where; Using index; Using filesort
  175. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 39
    Run Time: 0.000249
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  176. SELECT thread_id FROM xf_thread_read WHERE thread_id = 52440 AND user_id = '0'
    Run Time: 0.000065
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  177. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000085
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  178. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '29184'
    Run Time: 0.000079
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  179. SELECT last_post_date FROM xf_thread WHERE node_id IN(40,41,43,53,38,39) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000112
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 244Using where; Using index; Using filesort
  180. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 43
    Run Time: 0.000242
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  181. SELECT thread_id FROM xf_thread_read WHERE thread_id = 15348 AND user_id = '0'
    Run Time: 0.000068
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  182. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000085
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  183. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '22634'
    Run Time: 0.000065
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  184. SELECT last_post_date FROM xf_thread WHERE node_id IN(40,41,43,53,38,39) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000110
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 244Using where; Using index; Using filesort
  185. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 53
    Run Time: 0.000233
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  186. SELECT thread_id FROM xf_thread_read WHERE thread_id = 12319 AND user_id = '0'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  187. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000087
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  188. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '87457'
    Run Time: 0.000090
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  189. SELECT last_post_date FROM xf_thread WHERE node_id IN(40,41,43,53,38,39) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000112
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 244Using where; Using index; Using filesort
  190. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 39
    Run Time: 0.000242
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  191. SELECT thread_id FROM xf_thread_read WHERE thread_id = 51197 AND user_id = '0'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  192. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000085
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  193. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '85196'
    Run Time: 0.000065
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  194. SELECT last_post_date FROM xf_thread WHERE node_id IN(40,41,43,53,38,39) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000111
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 244Using where; Using index; Using filesort
  195. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 39
    Run Time: 0.000248
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  196. SELECT thread_id FROM xf_thread_read WHERE thread_id = 49914 AND user_id = '0'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  197. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000086
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  198. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '57068'
    Run Time: 0.000070
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  199. SELECT last_post_date FROM xf_thread WHERE node_id IN(40,41,43,53,38,39) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000112
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 244Using where; Using index; Using filesort
  200. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 53
    Run Time: 0.000234
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  201. SELECT thread_id FROM xf_thread_read WHERE thread_id = 31380 AND user_id = '0'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  202. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000086
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  203. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '43643'
    Run Time: 0.000083
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  204. SELECT last_post_date FROM xf_thread WHERE node_id IN(40,41,43,53,38,39) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000112
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 244Using where; Using index; Using filesort
  205. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 40
    Run Time: 0.000259
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  206. SELECT thread_id FROM xf_thread_read WHERE thread_id = 22188 AND user_id = '0'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  207. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000084
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  208. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '44922'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  209. SELECT last_post_date FROM xf_thread WHERE node_id IN(40,41,43,53,38,39) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000123
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 244Using where; Using index; Using filesort
  210. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 43
    Run Time: 0.000232
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  211. SELECT thread_id FROM xf_thread_read WHERE thread_id = 22984 AND user_id = '0'
    Run Time: 0.000078
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  212. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000099
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  213. SELECT * FROM xf_thread WHERE node_id IN(45,46,47,48,49) AND  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC LIMIT 10
    Run Time: 0.000166
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_last_post_date4 132Using where; Using filesort
  214. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '57558'
    Run Time: 0.000065
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  215. SELECT last_post_date FROM xf_thread WHERE node_id IN(45,46,47,48,49) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000112
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 132Using where; Using index; Using filesort
  216. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 46
    Run Time: 0.000276
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  217. SELECT thread_id FROM xf_thread_read WHERE thread_id = 31668 AND user_id = '0'
    Run Time: 0.000065
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  218. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000085
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  219. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '18463'
    Run Time: 0.000072
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  220. SELECT last_post_date FROM xf_thread WHERE node_id IN(45,46,47,48,49) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000088
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 132Using where; Using index; Using filesort
  221. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 46
    Run Time: 0.000230
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  222. SELECT thread_id FROM xf_thread_read WHERE thread_id = 9421 AND user_id = '0'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  223. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000085
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  224. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '1493'
    Run Time: 0.000374
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  225. SELECT last_post_date FROM xf_thread WHERE node_id IN(45,46,47,48,49) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000123
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 132Using where; Using index; Using filesort
  226. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 46
    Run Time: 0.000488
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  227. SELECT thread_id FROM xf_thread_read WHERE thread_id = 403 AND user_id = '0'
    Run Time: 0.000081
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  228. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000086
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  229. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '82999'
    Run Time: 0.000074
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  230. SELECT last_post_date FROM xf_thread WHERE node_id IN(45,46,47,48,49) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000101
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 132Using where; Using index; Using filesort
  231. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 46
    Run Time: 0.000259
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  232. SELECT thread_id FROM xf_thread_read WHERE thread_id = 48346 AND user_id = '0'
    Run Time: 0.000078
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  233. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000099
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  234. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '27831'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  235. SELECT last_post_date FROM xf_thread WHERE node_id IN(45,46,47,48,49) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000096
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 132Using where; Using index; Using filesort
  236. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 46
    Run Time: 0.000299
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  237. SELECT thread_id FROM xf_thread_read WHERE thread_id = 14738 AND user_id = '0'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  238. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000085
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  239. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '22476'
    Run Time: 0.000065
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  240. SELECT last_post_date FROM xf_thread WHERE node_id IN(45,46,47,48,49) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000108
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 132Using where; Using index; Using filesort
  241. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 46
    Run Time: 0.000254
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  242. SELECT thread_id FROM xf_thread_read WHERE thread_id = 12271 AND user_id = '0'
    Run Time: 0.000080
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  243. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000098
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  244. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '1215'
    Run Time: 0.000076
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  245. SELECT last_post_date FROM xf_thread WHERE node_id IN(45,46,47,48,49) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000097
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 132Using where; Using index; Using filesort
  246. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 46
    Run Time: 0.000248
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  247. SELECT thread_id FROM xf_thread_read WHERE thread_id = 350 AND user_id = '0'
    Run Time: 0.000079
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  248. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000087
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  249. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '1678'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  250. SELECT last_post_date FROM xf_thread WHERE node_id IN(45,46,47,48,49) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000099
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 132Using where; Using index; Using filesort
  251. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 46
    Run Time: 0.000267
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  252. SELECT thread_id FROM xf_thread_read WHERE thread_id = 447 AND user_id = '0'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  253. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000085
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  254. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '17081'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  255. SELECT last_post_date FROM xf_thread WHERE node_id IN(45,46,47,48,49) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000093
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 132Using where; Using index; Using filesort
  256. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 46
    Run Time: 0.000236
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  257. SELECT thread_id FROM xf_thread_read WHERE thread_id = 8391 AND user_id = '0'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  258. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000082
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  259. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '88897'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  260. SELECT last_post_date FROM xf_thread WHERE node_id IN(45,46,47,48,49) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000107
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 132Using where; Using index; Using filesort
  261. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 45
    Run Time: 0.000228
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  262. SELECT thread_id FROM xf_thread_read WHERE thread_id = 51950 AND user_id = '0'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  263. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000083
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  264. SELECT * FROM xf_thread WHERE node_id IN(253,254,248) AND  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC LIMIT 10
    Run Time: 0.000155
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadindexnode_id_last_post_date,node_id_sticky_state_last_postlast_post_date4 38Using where
  265. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '39493'
    Run Time: 0.000076
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  266. SELECT last_post_date FROM xf_thread WHERE node_id IN(253,254,248) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000492
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 2023Using where; Using index; Using filesort
  267. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 253
    Run Time: 0.000244
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  268. SELECT thread_id FROM xf_thread_read WHERE thread_id = 20208 AND user_id = '0'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  269. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000084
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  270. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96372'
    Run Time: 0.000068
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  271. SELECT last_post_date FROM xf_thread WHERE node_id IN(253,254,248) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000421
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 2023Using where; Using index; Using filesort
  272. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 248
    Run Time: 0.000225
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  273. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56809 AND user_id = '0'
    Run Time: 0.000083
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  274. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000087
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  275. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96194'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  276. SELECT last_post_date FROM xf_thread WHERE node_id IN(253,254,248) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000395
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 2023Using where; Using index; Using filesort
  277. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 248
    Run Time: 0.000276
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  278. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56709 AND user_id = '0'
    Run Time: 0.000076
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  279. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000098
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  280. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96173'
    Run Time: 0.000075
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  281. SELECT last_post_date FROM xf_thread WHERE node_id IN(253,254,248) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000377
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 2023Using where; Using index; Using filesort
  282. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 248
    Run Time: 0.000235
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  283. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56688 AND user_id = '0'
    Run Time: 0.000075
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  284. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000084
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  285. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96152'
    Run Time: 0.000076
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  286. SELECT last_post_date FROM xf_thread WHERE node_id IN(253,254,248) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000468
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 2023Using where; Using index; Using filesort
  287. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 248
    Run Time: 0.000224
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  288. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56667 AND user_id = '0'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  289. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000083
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  290. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96149'
    Run Time: 0.000091
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  291. SELECT last_post_date FROM xf_thread WHERE node_id IN(253,254,248) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000368
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 2023Using where; Using index; Using filesort
  292. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 248
    Run Time: 0.000251
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  293. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56664 AND user_id = '0'
    Run Time: 0.000078
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  294. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000085
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  295. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96140'
    Run Time: 0.000076
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  296. SELECT last_post_date FROM xf_thread WHERE node_id IN(253,254,248) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000389
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 2023Using where; Using index; Using filesort
  297. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 248
    Run Time: 0.000294
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  298. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56658 AND user_id = '0'
    Run Time: 0.000065
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  299. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000082
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  300. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96003'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  301. SELECT last_post_date FROM xf_thread WHERE node_id IN(253,254,248) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000377
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 2023Using where; Using index; Using filesort
  302. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 248
    Run Time: 0.000241
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  303. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56528 AND user_id = '0'
    Run Time: 0.000077
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  304. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000084
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  305. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '95050'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  306. SELECT last_post_date FROM xf_thread WHERE node_id IN(253,254,248) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000375
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 2023Using where; Using index; Using filesort
  307. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 248
    Run Time: 0.000229
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  308. SELECT thread_id FROM xf_thread_read WHERE thread_id = 55762 AND user_id = '0'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  309. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000084
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  310. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '95882'
    Run Time: 0.000067
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  311. SELECT last_post_date FROM xf_thread WHERE node_id IN(253,254,248) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000371
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 2023Using where; Using index; Using filesort
  312. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 248
    Run Time: 0.000234
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  313. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56458 AND user_id = '0'
    Run Time: 0.000082
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  314. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000084
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  315. SELECT * FROM xf_thread WHERE node_id IN(252,259,260,273,275) AND  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC LIMIT 10
    Run Time: 0.000188
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadindexnode_id_last_post_date,node_id_sticky_state_last_postlast_post_date4 160Using where
  316. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '95622'
    Run Time: 0.000084
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  317. SELECT last_post_date FROM xf_thread WHERE node_id IN(252,259,260,273,275) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000156
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 492Using where; Using index; Using filesort
  318. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 252
    Run Time: 0.000275
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  319. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56268 AND user_id = '0'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  320. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000082
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  321. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '18325'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  322. SELECT last_post_date FROM xf_thread WHERE node_id IN(252,259,260,273,275) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000142
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 492Using where; Using index; Using filesort
  323. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 252
    Run Time: 0.000218
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  324. SELECT thread_id FROM xf_thread_read WHERE thread_id = 9309 AND user_id = '0'
    Run Time: 0.000075
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  325. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000084
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  326. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '96631'
    Run Time: 0.000087
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  327. SELECT last_post_date FROM xf_thread WHERE node_id IN(252,259,260,273,275) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000143
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 492Using where; Using index; Using filesort
  328. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 252
    Run Time: 0.000243
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  329. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56976 AND user_id = '0'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  330. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000083
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  331. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '95623'
    Run Time: 0.000063
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  332. SELECT last_post_date FROM xf_thread WHERE node_id IN(252,259,260,273,275) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000143
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 492Using where; Using index; Using filesort
  333. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 252
    Run Time: 0.000221
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  334. SELECT thread_id FROM xf_thread_read WHERE thread_id = 56269 AND user_id = '0'
    Run Time: 0.000077
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  335. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000086
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  336. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '56130'
    Run Time: 0.000075
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  337. SELECT last_post_date FROM xf_thread WHERE node_id IN(252,259,260,273,275) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000144
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 492Using where; Using index; Using filesort
  338. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 252
    Run Time: 0.000240
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  339. SELECT thread_id FROM xf_thread_read WHERE thread_id = 30682 AND user_id = '0'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  340. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000082
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  341. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '8540'
    Run Time: 0.000063
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  342. SELECT last_post_date FROM xf_thread WHERE node_id IN(252,259,260,273,275) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000143
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 492Using where; Using index; Using filesort
  343. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 252
    Run Time: 0.000228
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  344. SELECT thread_id FROM xf_thread_read WHERE thread_id = 2524 AND user_id = '0'
    Run Time: 0.000065
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  345. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000088
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  346. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '33597'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  347. SELECT last_post_date FROM xf_thread WHERE node_id IN(252,259,260,273,275) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000142
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 492Using where; Using index; Using filesort
  348. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 252
    Run Time: 0.000239
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  349. SELECT thread_id FROM xf_thread_read WHERE thread_id = 17332 AND user_id = '0'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  350. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000083
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  351. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '70087'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  352. SELECT last_post_date FROM xf_thread WHERE node_id IN(252,259,260,273,275) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000154
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 492Using where; Using index; Using filesort
  353. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 252
    Run Time: 0.000219
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  354. SELECT thread_id FROM xf_thread_read WHERE thread_id = 39752 AND user_id = '0'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  355. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000083
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  356. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '25616'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  357. SELECT last_post_date FROM xf_thread WHERE node_id IN(252,259,260,273,275) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000140
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 492Using where; Using index; Using filesort
  358. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 252
    Run Time: 0.000218
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  359. SELECT thread_id FROM xf_thread_read WHERE thread_id = 13734 AND user_id = '0'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  360. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000083
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  361. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '18468'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  362. SELECT last_post_date FROM xf_thread WHERE node_id IN(252,259,260,273,275) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000140
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 492Using where; Using index; Using filesort
  363. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 252
    Run Time: 0.000220
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  364. SELECT thread_id FROM xf_thread_read WHERE thread_id = 9426 AND user_id = '0'
    Run Time: 0.000082
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  365. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000083
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  366. SELECT * FROM xf_thread WHERE node_id IN(66,67,68,70,71,72,74,77,121,122,123,124,78,79,80,172,171,170,164,165,163,156,173,174,26,166,69,172,147,24,206,226
    ) AND  node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date
     DESC LIMIT 10
    Run Time: 0.000146
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadindexnode_id_last_post_date,node_id_sticky_state_last_postlast_post_date4 135Using where
  367. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '94255'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  368. SELECT last_post_date FROM xf_thread WHERE node_id IN(66,67,68,70,71,72,74,77,121,122,123,124,78,79,80,172,171,170,164,165,163,156,173,174,26,166,69,172,147,24,206,226
    ) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000171
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 581Using where; Using index; Using filesort
  369. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 79
    Run Time: 0.000294
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  370. SELECT thread_id FROM xf_thread_read WHERE thread_id = 55065 AND user_id = '0'
    Run Time: 0.000065
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  371. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000083
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  372. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '26162'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  373. SELECT last_post_date FROM xf_thread WHERE node_id IN(66,67,68,70,71,72,74,77,121,122,123,124,78,79,80,172,171,170,164,165,163,156,173,174,26,166,69,172,147,24,206,226
    ) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000152
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 581Using where; Using index; Using filesort
  374. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 77
    Run Time: 0.000224
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  375. SELECT thread_id FROM xf_thread_read WHERE thread_id = 13962 AND user_id = '0'
    Run Time: 0.000075
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  376. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000084
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  377. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '26530'
    Run Time: 0.000063
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  378. SELECT last_post_date FROM xf_thread WHERE node_id IN(66,67,68,70,71,72,74,77,121,122,123,124,78,79,80,172,171,170,164,165,163,156,173,174,26,166,69,172,147,24,206,226
    ) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000151
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 581Using where; Using index; Using filesort
  379. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 173
    Run Time: 0.000239
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  380. SELECT thread_id FROM xf_thread_read WHERE thread_id = 14147 AND user_id = '0'
    Run Time: 0.000063
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  381. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000085
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  382. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '93529'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  383. SELECT last_post_date FROM xf_thread WHERE node_id IN(66,67,68,70,71,72,74,77,121,122,123,124,78,79,80,172,171,170,164,165,163,156,173,174,26,166,69,172,147,24,206,226
    ) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000150
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 581Using where; Using index; Using filesort
  384. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 77
    Run Time: 0.000228
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  385. SELECT thread_id FROM xf_thread_read WHERE thread_id = 54490 AND user_id = '0'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  386. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000082
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  387. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '15790'
    Run Time: 0.000063
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  388. SELECT last_post_date FROM xf_thread WHERE node_id IN(66,67,68,70,71,72,74,77,121,122,123,124,78,79,80,172,171,170,164,165,163,156,173,174,26,166,69,172,147,24,206,226
    ) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000151
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 581Using where; Using index; Using filesort
  389. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 173
    Run Time: 0.000219
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  390. SELECT thread_id FROM xf_thread_read WHERE thread_id = 7461 AND user_id = '0'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  391. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000081
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  392. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '70322'
    Run Time: 0.000091
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  393. SELECT last_post_date FROM xf_thread WHERE node_id IN(66,67,68,70,71,72,74,77,121,122,123,124,78,79,80,172,171,170,164,165,163,156,173,174,26,166,69,172,147,24,206,226
    ) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000151
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 581Using where; Using index; Using filesort
  394. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 69
    Run Time: 0.000229
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  395. SELECT thread_id FROM xf_thread_read WHERE thread_id = 39907 AND user_id = '0'
    Run Time: 0.000066
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  396. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000083
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  397. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '61813'
    Run Time: 0.000063
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  398. SELECT last_post_date FROM xf_thread WHERE node_id IN(66,67,68,70,71,72,74,77,121,122,123,124,78,79,80,172,171,170,164,165,163,156,173,174,26,166,69,172,147,24,206,226
    ) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000151
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 581Using where; Using index; Using filesort
  399. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 69
    Run Time: 0.000218
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  400. SELECT thread_id FROM xf_thread_read WHERE thread_id = 34624 AND user_id = '0'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  401. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000084
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  402. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '7116'
    Run Time: 0.000063
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  403. SELECT last_post_date FROM xf_thread WHERE node_id IN(66,67,68,70,71,72,74,77,121,122,123,124,78,79,80,172,171,170,164,165,163,156,173,174,26,166,69,172,147,24,206,226
    ) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000149
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 581Using where; Using index; Using filesort
  404. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 69
    Run Time: 0.000237
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  405. SELECT thread_id FROM xf_thread_read WHERE thread_id = 2227 AND user_id = '0'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  406. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000083
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  407. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '7251'
    Run Time: 0.000075
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  408. SELECT last_post_date FROM xf_thread WHERE node_id IN(66,67,68,70,71,72,74,77,121,122,123,124,78,79,80,172,171,170,164,165,163,156,173,174,26,166,69,172,147,24,206,226
    ) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000152
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 581Using where; Using index; Using filesort
  409. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 69
    Run Time: 0.000229
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  410. SELECT thread_id FROM xf_thread_read WHERE thread_id = 2274 AND user_id = '0'
    Run Time: 0.000063
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  411. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000083
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  412. SELECT COUNT(*) AS dem FROM `xf_attachment` WHERE content_type = 'post' AND content_id = '28023'
    Run Time: 0.000063
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_attachmentrefcontent_type_id_datecontent_type_id_date31const,const1Using where; Using index
  413. SELECT last_post_date FROM xf_thread WHERE node_id IN(66,67,68,70,71,72,74,77,121,122,123,124,78,79,80,172,171,170,164,165,163,156,173,174,26,166,69,172,147,24,206,226
    ) AND node_id NOT IN(9000) AND discussion_state = 'visible' ORDER BY last_post_date DESC
    Run Time: 0.000153
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangenode_id_last_post_date,node_id_sticky_state_last_postnode_id_sticky_state_last_post4 581Using where; Using index; Using filesort
  414. SELECT node.*, forum.*
    	
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    WHERE node.node_id = ?
    Params: 174
    Run Time: 0.000227
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
  415. SELECT thread_id FROM xf_thread_read WHERE thread_id = 14830 AND user_id = '0'
    Run Time: 0.000064
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  416. SELECT * FROM xf_thread_prefix WHERE prefix_id = 0
    Run Time: 0.000084
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  417. INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)
    Params: a682e28e3db4fa2b566c2ceb18f530ec, , 1544945422
    Run Time: 0.000262
  418. 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_Forum, Index, valid, node_name=, 1544941822,
    Run Time: 0.001052
  419. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('page_nav', 'node_forum_level_2', 'node_category_level_1', 'node_forum_level_n', 'node_forum_level_1', 'forum_list', 'wf_hook_moderator_bar', 'wf_revealer', 'dark_taigachat', 'dark_taigachat_list', 'PAGE_CONTAINER')
    	AND style_id = ?
    	AND language_id = ?
    Params: 2, 2
    Run Time: 0.000414
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_template_compiledrangePRIMARYPRIMARY60 11Using where
  420. INSERT INTO xf_data_registry
    	(data_key, data_value)
    VALUES
    	(?, ?)
    ON DUPLICATE KEY UPDATE
    	data_value = VALUES(data_value)
    Params: simpleCache, a:3:{s:7:"widgets";a:7:{i:1;a:9:{s:9:"widget_id";i:1;s:5:"title";s:0:"";s:5:"class";s:36:"WidgetFramework_WidgetRenderer_Empty";s:8:"position";s:10:"forum_list";s:13:"display_order";i:1;s:6:"active";i:1;s:7:"options";a:7:{s:14:"noVisitorPanel";i:0;s:10:"expression";s:0:"";s:21:"deactivate_for_mobile";i:0;s:10:"layout_row";i:0;s:10:"layout_col";i:0;s:14:"layout_sizeRow";i:0;s:14:"layout_sizeCol";i:0;}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:7;a:9:{s:9:"widget_id";i:7;s:5:"title";s:0:"";s:5:"class";s:36:"WidgetFramework_WidgetRenderer_Empty";s:8:"position";s:14:"member_notable";s:13:"display_order";i:10;s:6:"active";i:1;s:7:"options";a:0:{}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:12;a:9:{s:9:"widget_id";i:12;s:5:"title";s:24:"Sinh nhật Thành viên";s:5:"class";s:39:"WidgetFramework_WidgetRenderer_Birthday";s:8:"position";s:21:"hook:ad_below_content";s:13:"display_order";i:10;s:6:"active";i:0;s:7:"options";a:12:{s:5:"limit";i:0;s:11:"avatar_only";i:0;s:21:"whitelist_user_groups";a:0:{}s:21:"blacklist_user_groups";a:0:{}s:9:"tab_group";s:9:"tamduy121";s:13:"cache_seconds";s:0:"";s:10:"expression";s:0:"";s:21:"deactivate_for_mobile";i:0;s:10:"layout_row";i:0;s:10:"layout_col";i:0;s:14:"layout_sizeRow";i:0;s:14:"layout_sizeCol";i:0;}s:18:"template_for_hooks";a:1:{s:21:"hook:ad_below_content";a:2:{i:0;s:14:"PAGE_CONTAINER";i:1;s:16:"ad_below_content";}}s:14:"widget_page_id";i:0;}i:8;a:9:{s:9:"widget_id";i:8;s:5:"title";s:0:"";s:5:"class";s:40:"WidgetFramework_WidgetRenderer_UsersFind";s:8:"position";s:14:"member_notable";s:13:"display_order";i:20;s:6:"active";i:1;s:7:"options";a:0:{}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:9;a:9:{s:9:"widget_id";i:9;s:5:"title";s:0:"";s:5:"class";s:39:"WidgetFramework_WidgetRenderer_Birthday";s:8:"position";s:14:"member_notable";s:13:"display_order";i:30;s:6:"active";i:1;s:7:"options";a:12:{s:5:"limit";i:0;s:11:"avatar_only";i:0;s:21:"whitelist_user_groups";a:0:{}s:21:"blacklist_user_groups";a:0:{}s:9:"tab_group";s:0:"";s:13:"cache_seconds";s:0:"";s:10:"expression";s:0:"";s:21:"deactivate_for_mobile";i:0;s:10:"layout_row";i:0;s:10:"layout_col";i:0;s:14:"layout_sizeRow";i:0;s:14:"layout_sizeCol";i:0;}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:10;a:9:{s:9:"widget_id";i:10;s:5:"title";s:0:"";s:5:"class";s:41:"WidgetFramework_WidgetRenderer_UsersStaff";s:8:"position";s:14:"member_notable";s:13:"display_order";i:40;s:6:"active";i:1;s:7:"options";a:0:{}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}i:11;a:9:{s:9:"widget_id";i:11;s:5:"title";s:0:"";s:5:"class";s:47:"WidgetFramework_WidgetRenderer_FacebookFacepile";s:8:"position";s:14:"member_notable";s:13:"display_order";i:50;s:6:"active";i:1;s:7:"options";a:0:{}s:18:"template_for_hooks";a:0:{}s:14:"widget_page_id";i:0;}}s:17:"invalidated_cache";a:10:{i:9;i:1544926857;i:2;i:1418450480;i:3;i:1418450483;i:6;i:1418450484;i:12;i:1544926857;i:13;i:1418531352;i:5;i:1418629710;i:1;i:1421485453;i:14;i:1421485432;i:4;i:1421485439;}s:20:"taigachat_lastUpdate";i:1544941822;}
    Run Time: 0.016745
  421. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('VNXF_Stats')
    	AND style_id = ?
    	AND language_id = ?
    Params: 2, 2
    Run Time: 0.000161
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_template_compiledconstPRIMARYPRIMARY60const,const,const1 

Included Files (126, XenForo Classes: 62)

  1. index.php
  2. library/XenForo/Autoloader.php
  3. library/XenForo/Application.php
  4. library/Zend/Registry.php
  5. library/Lgpl/utf8.php
  6. library/Zend/Config.php
  7. library/config.php
  8. library/XenForo/FrontController.php
  9. library/XenForo/Dependencies/Public.php
  10. library/XenForo/Dependencies/Abstract.php
  11. library/Zend/Controller/Request/Http.php
  12. library/Zend/Controller/Request/Abstract.php
  13. library/Zend/Uri.php
  14. library/Zend/Controller/Response/Http.php
  15. library/Zend/Controller/Response/Abstract.php
  16. library/XenForo/Model/DataRegistry.php
  17. library/XenForo/Model.php
  18. library/Zend/Cache.php
  19. library/Zend/Cache/Backend/File.php
  20. library/Zend/Cache/Backend/ExtendedInterface.php
  21. library/Zend/Cache/Backend/Interface.php
  22. library/Zend/Cache/Backend.php
  23. library/Zend/Cache/Core.php
  24. library/XenForo/CodeEvent.php
  25. library/XenForo/Options.php
  26. library/XenForo/Link.php
  27. library/XenForo/Template/Helper/Core.php
  28. library/WidgetFramework/Listener.php
  29. library/WidgetFramework/Option.php
  30. library/Brivium/BriviumHelper/EventListeners.php
  31. library/Brivium/BriviumHelper/1010071/EventListeners.php
  32. library/VNXF/Stats/Listener.php
  33. library/Dark/TaigaChat/EventListener/Listener.php
  34. library/Brivium/BriviumHelper/Model/ListenerClass.php
  35. library/Brivium/BriviumHelper/1010071/Model/ListenerClass.php
  36. library/Zend/Db.php
  37. library/Zend/Db/Adapter/Mysqli.php
  38. library/Zend/Db/Adapter/Abstract.php
  39. library/Zend/Db/Select.php
  40. library/Zend/Db/Expr.php
  41. library/Zend/Db/Profiler.php
  42. library/Zend/Db/Statement/Mysqli.php
  43. library/Zend/Db/Statement.php
  44. library/Zend/Db/Statement/Interface.php
  45. library/Zend/Db/Profiler/Query.php
  46. library/XenForo/Router.php
  47. library/XenForo/Route/Filter.php
  48. library/XenForo/Route/Interface.php
  49. library/XenForo/Route/ResponseSuffix.php
  50. library/XenForo/Route/Prefix.php
  51. library/WidgetFramework/Route/Filter/PageX.php
  52. library/XenForo/Route/Prefix/Index.php
  53. library/Dark/vB4Redir/EventListener/LoadClassRoutePrefix.php
  54. library/WidgetFramework/XenForo/Route/Prefix/Index.php
  55. library/XenForo/RouteMatch.php
  56. library/XenForo/ControllerPublic/Index.php
  57. library/XenForo/ControllerPublic/Abstract.php
  58. library/XenForo/Controller.php
  59. library/Sedo/MobileStyleSelector/Listener/ControllerPublic.php
  60. library/WidgetFramework/XenForo/ControllerPublic/Index.php
  61. library/XenForo/Input.php
  62. library/XenForo/Session.php
  63. library/XenForo/Helper/Ip.php
  64. library/XenForo/Visitor.php
  65. library/XenForo/Model/User.php
  66. library/WidgetFramework/XenForo/Model/User.php
  67. library/XenForo/Permission.php
  68. library/XenForo/Phrase.php
  69. library/XenForo/Locale.php
  70. library/Sedo/MobileStyleSelector/Listener/Visitor.php
  71. library/Sedo/MobileStyleSelector/Listener/ControllerPreDispatch.php
  72. library/WidgetFramework/Helper/Index.php
  73. library/XenForo/ControllerResponse/ReroutePath.php
  74. library/XenForo/ControllerResponse/Abstract.php
  75. library/XenForo/Route/Prefix/Forums.php
  76. library/Dark/vB4Redir/Route/Prefix/Forums.php
  77. library/XenForo/ControllerPublic/Forum.php
  78. library/VNXF/Stats/ControllerPublic/Forum.php
  79. library/WidgetFramework/XenForo/ControllerPublic/Forum.php
  80. library/XenForo/Model/ProfilePost.php
  81. library/WidgetFramework/XenForo/Model/ProfilePost.php
  82. library/XenForo/Model/UserProfile.php
  83. library/XenForo/Model/Node.php
  84. library/XenForo/NodeHandler/Category.php
  85. library/XenForo/NodeHandler/Abstract.php
  86. library/XenForo/NodeHandler/Forum.php
  87. library/XenForo/Model/Category.php
  88. library/XenForo/Model/Forum.php
  89. library/XenForo/Helper/String.php
  90. library/XenForo/Model/Session.php
  91. library/Dark/TaigaChat/Model/SessionOverride.php
  92. library/XenForo/ControllerResponse/View.php
  93. library/VNXF/Stats/Model.php
  94. library/XenForo/Helper/Cookie.php
  95. library/XenForo/ViewRenderer/HtmlPublic.php
  96. library/XenForo/ViewRenderer/Abstract.php
  97. library/XenForo/Template/Public.php
  98. library/XenForo/Template/Abstract.php
  99. library/WidgetFramework/Core.php
  100. library/XenForo/Model/Moderator.php
  101. library/WidgetFramework/Model/Widget.php
  102. library/WidgetFramework/Helper/Sort.php
  103. library/WidgetFramework/WidgetRenderer.php
  104. library/XenForo/ViewPublic/Forum/List.php
  105. library/XenForo/ViewPublic/Base.php
  106. library/XenForo/View.php
  107. library/WidgetFramework/XenForo/View1.php
  108. library/XenForo/ViewPublic/Helper/Node.php
  109. library/Brivium/TableBBCode/EventListeners/Listener.php
  110. library/WidgetFramework/WidgetRenderer/Empty.php
  111. library/XenForo/Route/Prefix/Members.php
  112. library/Dark/TaigaChat/EventListener/NavigationTabs.php
  113. library/WidgetFramework/Template/Extended.php
  114. library/Dark/TaigaChat/Model/TaigaChat.php
  115. library/Dark/TaigaChat/Helper/Global.php
  116. library/ChipXF/RemoteImageUploader/Listeners.php
  117. library/ChipXF/RemoteImageUploader/Helper.php
  118. library/XenForo/Route/Prefix/Categories.php
  119. library/XenForo/Route/Prefix/Posts.php
  120. library/XenForo/Route/Prefix/Threads.php
  121. library/Dark/vB4Redir/Route/Prefix/Threads.php
  122. library/VNXF/Stats/Route.php
  123. library/XenForo/Model/Avatar.php
  124. library/XenForo/Route/Prefix/ProfilePosts.php
  125. library/XenForo/Debug.php
  126. library/XenForo/ViewRenderer/Json.php