Page Time: 0.5945s

Memory: 18.9467 MB (Peak: 28.8859 MB)

Queries (60, time: 0.3466s, 58.3%)

  1. SELECT cache_value
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 1
    Run Time: 0.000323
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  2. SELECT thread.*
    	,
    		user.gender, user.avatar_date, user.gravatar,
    		NULL AS thread_read_date,
    		0 AS thread_reply_banned,
    		0 AS thread_is_watched,
    		'' AS draft_message, NULL AS draft_extra,
    	privacy.snog_flag_view
    FROM xf_thread AS thread
    
    		LEFT JOIN xf_user AS user ON
    			(user.user_id = thread.user_id)
    	LEFT JOIN xf_user_privacy AS privacy ON
    		(privacy.user_id = thread.user_id)
    WHERE thread.thread_id = ?
    Params: 86711
    Run Time: 0.000374
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEthreadconstPRIMARYPRIMARY4const1 
    SIMPLEuserconstPRIMARYPRIMARY4const1 
    SIMPLEprivacyconstPRIMARYPRIMARY4const1 
  3. SELECT node.*, forum.*
    	,
    	permission.cache_value AS node_permission_cache,
    		NULL AS forum_read_date,advapp.posid
    ,advapp.position
    ,advapp.threadapp
    ,advapp.threadbutton
    FROM xf_forum AS forum
    INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
    
    	LEFT JOIN xf_permission_cache_content AS permission
    		ON (permission.permission_combination_id = 1
    			AND permission.content_type = 'node'
    			AND permission.content_id = forum.node_id)
    LEFT JOIN xf_snog_applications_positions AS advapp
    ON (advapp.node_id = forum.node_id AND advapp.threadapp = 1)
    WHERE node.node_id = ?
    Params: 189
    Run Time: 0.000535
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEnodeconstPRIMARYPRIMARY4const1 
    SIMPLEforumconstPRIMARYPRIMARY4const1 
    SIMPLEpermissionconstPRIMARYPRIMARY35const,const,const1 
    SIMPLEadvappALL    2Using where
  4. SELECT EWRporta2_articles.*, xf_thread.*, xf_post.*, xf_user.*, EWRporta2_authors.*
    FROM EWRporta2_articles
    	INNER JOIN xf_thread ON (xf_thread.thread_id = EWRporta2_articles.thread_id)
    	INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
    	LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
    	LEFT JOIN EWRporta2_authors ON (EWRporta2_authors.user_id = xf_thread.user_id)
    WHERE EWRporta2_articles.thread_id = ?
    Params: 86711
    Run Time: 0.000662
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  5. SELECT post.*
    	,
    		bb_code_parse_cache.parse_tree AS message_parsed, bb_code_parse_cache.cache_version AS message_cache_version,
    		user.*, IF(user.username IS NULL, post.username, user.username) AS username,
    		user_profile.*,
    		user_privacy.*,
    		signature_parse_cache.parse_tree AS signature_parsed, bb_code_parse_cache.cache_version AS signature_cache_version,
    		session_activity.view_date AS last_view_date,
    		0 AS like_date
    		,(select sum(count_received) from dark_postrating_count where user_id = post.user_id and rating in (1,14,2,13,12,8,11,6,5,10,4,7,9,3)) as positive_rating_count
    	,
    pr_cache.rating_cache,
    pr2.rating,
    		apppromotions.posid AS posid
    FROM xf_post AS post
    
    		LEFT JOIN xf_bb_code_parse_cache AS bb_code_parse_cache ON
    			(bb_code_parse_cache.content_type = 'post' AND bb_code_parse_cache.content_id = post.post_id)
    		LEFT JOIN xf_user AS user ON
    			(user.user_id = post.user_id)
    		LEFT JOIN xf_user_profile AS user_profile ON
    			(user_profile.user_id = post.user_id)
    		LEFT JOIN xf_user_privacy AS user_privacy ON
    			(user_privacy.user_id = post.user_id)
    		LEFT JOIN xf_bb_code_parse_cache AS signature_parse_cache ON
    			(signature_parse_cache.content_type = 'signature' AND signature_parse_cache.content_id = post.user_id)
    		LEFT JOIN xf_session_activity AS session_activity ON
    			(post.user_id > 0 AND session_activity.user_id = post.user_id AND session_activity.unique_key = CAST(post.user_id AS BINARY))
    left join dark_postrating_post_cache pr_cache ON (post.post_id = pr_cache.post_id)
    left join dark_postrating pr2 on (post.post_id = pr2.post_id and pr2.user_id = 0)
    			LEFT JOIN xf_snog_applications_promotions AS apppromotions 
    			ON (apppromotions.post_id = post.post_id)
    WHERE post.thread_id = ?
    	 AND (post.position >= 2650 AND post.position < 2660) 
    	AND (post.message_state IN ('visible'))
    ORDER BY post.position ASC, post.post_date ASC
    Params: 86711
    Run Time: 0.002920
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    PRIMARYpostrangethread_id_post_date,thread_id_positionthread_id_position8 10Using index condition; Using where; Using temporary; Using filesort
    PRIMARYbb_code_parse_cacheeq_refcontent_type_idcontent_type_id31const,destee_180205.post.post_id1Using where
    PRIMARYusereq_refPRIMARYPRIMARY4destee_180205.post.user_id1 
    PRIMARYuser_profileeq_refPRIMARYPRIMARY4destee_180205.post.user_id1 
    PRIMARYuser_privacyeq_refPRIMARYPRIMARY4destee_180205.post.user_id1 
    PRIMARYsignature_parse_cacheeq_refcontent_type_idcontent_type_id31const,destee_180205.post.user_id1Using where
    PRIMARYsession_activityeq_refPRIMARYPRIMARY22destee_180205.post.user_id,func1Using where
    PRIMARYpr_cacheeq_refPRIMARYPRIMARY4destee_180205.post.post_id1 
    PRIMARYpr2eq_refpost_id_user_id,post_id_rating,user_id_ratingpost_id_user_id8destee_180205.post.post_id,const1 
    PRIMARYapppromotionsALLpost_id   1Using where; Using join buffer (flat, BNL join)
    DEPENDENT SUBQUERYdark_postrating_countrefuser_id_ratinguser_id_rating4destee_180205.post.user_id1Using index condition
  6. SELECT attachment.*,
    	data.filename, data.file_size, data.file_hash, data.file_path, data.width, data.height, data.thumbnail_width, data.thumbnail_height
    FROM xf_attachment AS attachment
    INNER JOIN xf_attachment_data AS data ON
    	(data.data_id = attachment.data_id)
    WHERE attachment.content_type = ?
    	AND attachment.content_id IN (1015960)
    ORDER BY attachment.content_id, attachment.attach_date
    Params: post
    Run Time: 0.000481
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEattachmentrefcontent_type_id_datecontent_type_id_date31const,const5Using index condition; Using where
    SIMPLEdataeq_refPRIMARYPRIMARY4destee_180205.attachment.data_id1 
  7. SELECT *
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 282
    Run Time: 0.000237
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  8. SELECT *
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 282
    Run Time: 0.000192
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  9. SELECT *
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 282
    Run Time: 0.000156
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  10. SELECT *
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 282
    Run Time: 0.000219
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  11. SELECT *
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 282
    Run Time: 0.000190
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  12. SELECT *
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 282
    Run Time: 0.000212
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  13. SELECT *
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 273
    Run Time: 0.000162
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  14. SELECT *
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 282
    Run Time: 0.000121
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  15. SELECT *
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 277
    Run Time: 0.000212
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  16. SELECT *
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 282
    Run Time: 0.000184
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  17. INSERT DELAYED INTO xf_thread_view
    	(thread_id)
    VALUES
    	(?)
    Params: 86711
    Run Time: 0.000204
  18. INSERT DELAYED INTO xf_iwd_ftviews
    	(forum_id)
    VALUES
    	(?)
    Params: 189
    Run Time: 0.000143
  19. SELECT *
    FROM xf_node
    
    ORDER BY lft ASC
    Run Time: 0.000857
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_nodeALL    179Using filesort
  20. SELECT content_id, cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
    	AND content_type = 'node'
    Params: 1
    Run Time: 0.000571
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_cache_contentrefPRIMARYPRIMARY31const,const320Using where
  21. SELECT params
    FROM xf_session_activity
    WHERE user_id = ?
    AND controller_action = 'CreateThread'
    Params: 0
    Run Time: 0.000264
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_session_activityrefPRIMARYPRIMARY4const245Using where
  22. SELECT xf_thread.thread_id, 
    xf_thread.node_id,
    xf_thread.title, 
    xf_thread.reply_count,
    xf_thread.view_count, 
    xf_thread.username, 
    xf_thread.post_date,
    xf_thread.last_post_date, 
    xf_thread.last_post_user_id, 
    xf_thread.last_post_username, 
    xf_thread.prefix_id, 			 
    xf_node.title AS nodeTitle, 
    xf_user.user_id, 
    xf_user.gender, 
    xf_user.avatar_date	
    FROM xf_thread
    INNER JOIN xf_node ON xf_node.node_id = xf_thread.node_id
    INNER JOIN xf_user ON xf_user.user_id = xf_thread.user_id
    WHERE xf_thread.title LIKE '%Trump%'
    AND xf_thread.title LIKE '%Becomes%'
    AND xf_thread.title LIKE '%President%'
    AND xf_thread.discussion_state = 'visible'
    AND xf_thread.discussion_type <> 'redirect'
    AND xf_thread.post_date >= ?
    AND (xf_thread.node_id = 211 OR xf_thread.node_id = 212 OR xf_thread.node_id = 231 OR xf_thread.node_id = 302 OR xf_thread.node_id = 10 OR xf_thread.node_id = 11 OR xf_thread.node_id = 219 OR xf_thread.node_id = 86 OR xf_thread.node_id = 12 OR xf_thread.node_id = 87 OR xf_thread.node_id = 147 OR xf_thread.node_id = 149 OR xf_thread.node_id = 150 OR xf_thread.node_id = 18 OR xf_thread.node_id = 23 OR xf_thread.node_id = 189 OR xf_thread.node_id = 76 OR xf_thread.node_id = 75 OR xf_thread.node_id = 73 OR xf_thread.node_id = 50 OR xf_thread.node_id = 51 OR xf_thread.node_id = 52 OR xf_thread.node_id = 83 OR xf_thread.node_id = 22 OR xf_thread.node_id = 21 OR xf_thread.node_id = 72 OR xf_thread.node_id = 33 OR xf_thread.node_id = 74 OR xf_thread.node_id = 26 OR xf_thread.node_id = 48 OR xf_thread.node_id = 194 OR xf_thread.node_id = 25 OR xf_thread.node_id = 19 OR xf_thread.node_id = 30 OR xf_thread.node_id = 222 OR xf_thread.node_id = 172 OR xf_thread.node_id = 36 OR xf_thread.node_id = 24 OR xf_thread.node_id = 34 OR xf_thread.node_id = 35 OR xf_thread.node_id = 78 OR xf_thread.node_id = 49 OR xf_thread.node_id = 235 OR xf_thread.node_id = 301 OR xf_thread.node_id = 278 OR xf_thread.node_id = 237 OR xf_thread.node_id = 297 OR xf_thread.node_id = 299 OR xf_thread.node_id = 298 OR xf_thread.node_id = 300 OR xf_thread.node_id = 239 OR xf_thread.node_id = 240 OR xf_thread.node_id = 296 OR xf_thread.node_id = 236 OR xf_thread.node_id = 242 OR xf_thread.node_id = 243 OR xf_thread.node_id = 244 OR xf_thread.node_id = 245 OR xf_thread.node_id = 246 OR xf_thread.node_id = 247 OR xf_thread.node_id = 248 OR xf_thread.node_id = 249 OR xf_thread.node_id = 250 OR xf_thread.node_id = 251 OR xf_thread.node_id = 252 OR xf_thread.node_id = 254 OR xf_thread.node_id = 255 OR xf_thread.node_id = 256 OR xf_thread.node_id = 257 OR xf_thread.node_id = 258 OR xf_thread.node_id = 259 OR xf_thread.node_id = 260 OR xf_thread.node_id = 261 OR xf_thread.node_id = 262 OR xf_thread.node_id = 241 OR xf_thread.node_id = 263 OR xf_thread.node_id = 264 OR xf_thread.node_id = 265 OR xf_thread.node_id = 266 OR xf_thread.node_id = 267 OR xf_thread.node_id = 268 OR xf_thread.node_id = 269 OR xf_thread.node_id = 270 OR xf_thread.node_id = 271 OR xf_thread.node_id = 272 OR xf_thread.node_id = 273 OR xf_thread.node_id = 274 OR xf_thread.node_id = 275 OR xf_thread.node_id = 276 OR xf_thread.node_id = 277 OR xf_thread.node_id = 279 OR xf_thread.node_id = 280 OR xf_thread.node_id = 281 OR xf_thread.node_id = 282 OR xf_thread.node_id = 283 OR xf_thread.node_id = 284 OR xf_thread.node_id = 285 OR xf_thread.node_id = 286 OR xf_thread.node_id = 287 OR xf_thread.node_id = 288 OR xf_thread.node_id = 289 OR xf_thread.node_id = 290 OR xf_thread.node_id = 291 OR xf_thread.node_id = 292 OR xf_thread.node_id = 293 OR xf_thread.node_id = 294 OR xf_thread.node_id = 295 OR xf_thread.node_id = 174 OR xf_thread.node_id = 20 OR xf_thread.node_id = 108 OR xf_thread.node_id = 198 OR xf_thread.node_id = 59 OR xf_thread.node_id = 188 OR xf_thread.node_id = 71 OR xf_thread.node_id = 65 OR xf_thread.node_id = 61 OR xf_thread.node_id = 55 OR xf_thread.node_id = 69 OR xf_thread.node_id = 88 OR xf_thread.node_id = 93 OR xf_thread.node_id = 92 OR xf_thread.node_id = 111 OR xf_thread.node_id = 94 OR xf_thread.node_id = 110 OR xf_thread.node_id = 109 OR xf_thread.node_id = 203 OR xf_thread.node_id = 191 OR xf_thread.node_id = 232 OR xf_thread.node_id = 233 OR xf_thread.node_id = 95 OR xf_thread.node_id = 213 OR xf_thread.node_id = 13 OR xf_thread.node_id = 17 OR xf_thread.node_id = 14 OR xf_thread.node_id = 16 OR xf_thread.node_id = 204 OR xf_thread.node_id = 15)
    AND xf_thread.thread_id <> '86711'
    
    
    ORDER BY xf_thread.post_date DESC
    LIMIT ?
    Params: 0, 5
    Run Time: 0.172250
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangePRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,user_id,post_datepost_date4 45702Using where
    SIMPLExf_usereq_refPRIMARYPRIMARY4destee_180205.xf_thread.user_id1 
    SIMPLExf_nodeeq_refPRIMARYPRIMARY4destee_180205.xf_thread.node_id1 
  23. SELECT xf_thread.thread_id, 
    xf_thread.node_id,
    xf_thread.title, 
    xf_thread.reply_count,
    xf_thread.view_count, 
    xf_thread.username, 
    xf_thread.post_date,
    xf_thread.last_post_date, 
    xf_thread.last_post_user_id, 
    xf_thread.last_post_username, 
    xf_thread.prefix_id, 			 
    xf_node.title AS nodeTitle, 
    xf_user.user_id, 
    xf_user.gender, 
    xf_user.avatar_date	
    FROM xf_thread
    INNER JOIN xf_node ON xf_node.node_id = xf_thread.node_id
    INNER JOIN xf_user ON xf_user.user_id = xf_thread.user_id
    WHERE xf_thread.title LIKE '%Trump%'
    AND xf_thread.title LIKE '%Becomes%'
    AND xf_thread.discussion_state = 'visible'
    AND xf_thread.discussion_type <> 'redirect'
    AND xf_thread.post_date >= ?
    AND (xf_thread.node_id = 211 OR xf_thread.node_id = 212 OR xf_thread.node_id = 231 OR xf_thread.node_id = 302 OR xf_thread.node_id = 10 OR xf_thread.node_id = 11 OR xf_thread.node_id = 219 OR xf_thread.node_id = 86 OR xf_thread.node_id = 12 OR xf_thread.node_id = 87 OR xf_thread.node_id = 147 OR xf_thread.node_id = 149 OR xf_thread.node_id = 150 OR xf_thread.node_id = 18 OR xf_thread.node_id = 23 OR xf_thread.node_id = 189 OR xf_thread.node_id = 76 OR xf_thread.node_id = 75 OR xf_thread.node_id = 73 OR xf_thread.node_id = 50 OR xf_thread.node_id = 51 OR xf_thread.node_id = 52 OR xf_thread.node_id = 83 OR xf_thread.node_id = 22 OR xf_thread.node_id = 21 OR xf_thread.node_id = 72 OR xf_thread.node_id = 33 OR xf_thread.node_id = 74 OR xf_thread.node_id = 26 OR xf_thread.node_id = 48 OR xf_thread.node_id = 194 OR xf_thread.node_id = 25 OR xf_thread.node_id = 19 OR xf_thread.node_id = 30 OR xf_thread.node_id = 222 OR xf_thread.node_id = 172 OR xf_thread.node_id = 36 OR xf_thread.node_id = 24 OR xf_thread.node_id = 34 OR xf_thread.node_id = 35 OR xf_thread.node_id = 78 OR xf_thread.node_id = 49 OR xf_thread.node_id = 235 OR xf_thread.node_id = 301 OR xf_thread.node_id = 278 OR xf_thread.node_id = 237 OR xf_thread.node_id = 297 OR xf_thread.node_id = 299 OR xf_thread.node_id = 298 OR xf_thread.node_id = 300 OR xf_thread.node_id = 239 OR xf_thread.node_id = 240 OR xf_thread.node_id = 296 OR xf_thread.node_id = 236 OR xf_thread.node_id = 242 OR xf_thread.node_id = 243 OR xf_thread.node_id = 244 OR xf_thread.node_id = 245 OR xf_thread.node_id = 246 OR xf_thread.node_id = 247 OR xf_thread.node_id = 248 OR xf_thread.node_id = 249 OR xf_thread.node_id = 250 OR xf_thread.node_id = 251 OR xf_thread.node_id = 252 OR xf_thread.node_id = 254 OR xf_thread.node_id = 255 OR xf_thread.node_id = 256 OR xf_thread.node_id = 257 OR xf_thread.node_id = 258 OR xf_thread.node_id = 259 OR xf_thread.node_id = 260 OR xf_thread.node_id = 261 OR xf_thread.node_id = 262 OR xf_thread.node_id = 241 OR xf_thread.node_id = 263 OR xf_thread.node_id = 264 OR xf_thread.node_id = 265 OR xf_thread.node_id = 266 OR xf_thread.node_id = 267 OR xf_thread.node_id = 268 OR xf_thread.node_id = 269 OR xf_thread.node_id = 270 OR xf_thread.node_id = 271 OR xf_thread.node_id = 272 OR xf_thread.node_id = 273 OR xf_thread.node_id = 274 OR xf_thread.node_id = 275 OR xf_thread.node_id = 276 OR xf_thread.node_id = 277 OR xf_thread.node_id = 279 OR xf_thread.node_id = 280 OR xf_thread.node_id = 281 OR xf_thread.node_id = 282 OR xf_thread.node_id = 283 OR xf_thread.node_id = 284 OR xf_thread.node_id = 285 OR xf_thread.node_id = 286 OR xf_thread.node_id = 287 OR xf_thread.node_id = 288 OR xf_thread.node_id = 289 OR xf_thread.node_id = 290 OR xf_thread.node_id = 291 OR xf_thread.node_id = 292 OR xf_thread.node_id = 293 OR xf_thread.node_id = 294 OR xf_thread.node_id = 295 OR xf_thread.node_id = 174 OR xf_thread.node_id = 20 OR xf_thread.node_id = 108 OR xf_thread.node_id = 198 OR xf_thread.node_id = 59 OR xf_thread.node_id = 188 OR xf_thread.node_id = 71 OR xf_thread.node_id = 65 OR xf_thread.node_id = 61 OR xf_thread.node_id = 55 OR xf_thread.node_id = 69 OR xf_thread.node_id = 88 OR xf_thread.node_id = 93 OR xf_thread.node_id = 92 OR xf_thread.node_id = 111 OR xf_thread.node_id = 94 OR xf_thread.node_id = 110 OR xf_thread.node_id = 109 OR xf_thread.node_id = 203 OR xf_thread.node_id = 191 OR xf_thread.node_id = 232 OR xf_thread.node_id = 233 OR xf_thread.node_id = 95 OR xf_thread.node_id = 213 OR xf_thread.node_id = 13 OR xf_thread.node_id = 17 OR xf_thread.node_id = 14 OR xf_thread.node_id = 16 OR xf_thread.node_id = 204 OR xf_thread.node_id = 15)
    AND xf_thread.thread_id <> '86711'
    
    
    
    ORDER BY xf_thread.post_date DESC
    LIMIT ?
    Params: 0, 5
    Run Time: 0.144032
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangePRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,user_id,post_datepost_date4 45702Using where
    SIMPLExf_usereq_refPRIMARYPRIMARY4destee_180205.xf_thread.user_id1 
    SIMPLExf_nodeeq_refPRIMARYPRIMARY4destee_180205.xf_thread.node_id1 
  24. SELECT xf_thread.thread_id, 
    xf_thread.node_id,
    xf_thread.title, 
    xf_thread.reply_count,
    xf_thread.view_count, 
    xf_thread.username, 
    xf_thread.post_date,
    xf_thread.last_post_date, 
    xf_thread.last_post_user_id, 
    xf_thread.last_post_username, 
    xf_thread.prefix_id, 			 
    xf_node.title AS nodeTitle, 
    xf_user.user_id, 
    xf_user.gender, 
    xf_user.avatar_date		
    FROM xf_thread
    INNER JOIN xf_node ON xf_node.node_id = xf_thread.node_id
    INNER JOIN xf_user ON xf_user.user_id = xf_thread.user_id
    WHERE xf_thread.title LIKE '%Trump%'
    AND xf_thread.discussion_state = 'visible'
    AND xf_thread.discussion_type <> 'redirect'
    AND xf_thread.post_date >= ?
    AND (xf_thread.node_id = 211 OR xf_thread.node_id = 212 OR xf_thread.node_id = 231 OR xf_thread.node_id = 302 OR xf_thread.node_id = 10 OR xf_thread.node_id = 11 OR xf_thread.node_id = 219 OR xf_thread.node_id = 86 OR xf_thread.node_id = 12 OR xf_thread.node_id = 87 OR xf_thread.node_id = 147 OR xf_thread.node_id = 149 OR xf_thread.node_id = 150 OR xf_thread.node_id = 18 OR xf_thread.node_id = 23 OR xf_thread.node_id = 189 OR xf_thread.node_id = 76 OR xf_thread.node_id = 75 OR xf_thread.node_id = 73 OR xf_thread.node_id = 50 OR xf_thread.node_id = 51 OR xf_thread.node_id = 52 OR xf_thread.node_id = 83 OR xf_thread.node_id = 22 OR xf_thread.node_id = 21 OR xf_thread.node_id = 72 OR xf_thread.node_id = 33 OR xf_thread.node_id = 74 OR xf_thread.node_id = 26 OR xf_thread.node_id = 48 OR xf_thread.node_id = 194 OR xf_thread.node_id = 25 OR xf_thread.node_id = 19 OR xf_thread.node_id = 30 OR xf_thread.node_id = 222 OR xf_thread.node_id = 172 OR xf_thread.node_id = 36 OR xf_thread.node_id = 24 OR xf_thread.node_id = 34 OR xf_thread.node_id = 35 OR xf_thread.node_id = 78 OR xf_thread.node_id = 49 OR xf_thread.node_id = 235 OR xf_thread.node_id = 301 OR xf_thread.node_id = 278 OR xf_thread.node_id = 237 OR xf_thread.node_id = 297 OR xf_thread.node_id = 299 OR xf_thread.node_id = 298 OR xf_thread.node_id = 300 OR xf_thread.node_id = 239 OR xf_thread.node_id = 240 OR xf_thread.node_id = 296 OR xf_thread.node_id = 236 OR xf_thread.node_id = 242 OR xf_thread.node_id = 243 OR xf_thread.node_id = 244 OR xf_thread.node_id = 245 OR xf_thread.node_id = 246 OR xf_thread.node_id = 247 OR xf_thread.node_id = 248 OR xf_thread.node_id = 249 OR xf_thread.node_id = 250 OR xf_thread.node_id = 251 OR xf_thread.node_id = 252 OR xf_thread.node_id = 254 OR xf_thread.node_id = 255 OR xf_thread.node_id = 256 OR xf_thread.node_id = 257 OR xf_thread.node_id = 258 OR xf_thread.node_id = 259 OR xf_thread.node_id = 260 OR xf_thread.node_id = 261 OR xf_thread.node_id = 262 OR xf_thread.node_id = 241 OR xf_thread.node_id = 263 OR xf_thread.node_id = 264 OR xf_thread.node_id = 265 OR xf_thread.node_id = 266 OR xf_thread.node_id = 267 OR xf_thread.node_id = 268 OR xf_thread.node_id = 269 OR xf_thread.node_id = 270 OR xf_thread.node_id = 271 OR xf_thread.node_id = 272 OR xf_thread.node_id = 273 OR xf_thread.node_id = 274 OR xf_thread.node_id = 275 OR xf_thread.node_id = 276 OR xf_thread.node_id = 277 OR xf_thread.node_id = 279 OR xf_thread.node_id = 280 OR xf_thread.node_id = 281 OR xf_thread.node_id = 282 OR xf_thread.node_id = 283 OR xf_thread.node_id = 284 OR xf_thread.node_id = 285 OR xf_thread.node_id = 286 OR xf_thread.node_id = 287 OR xf_thread.node_id = 288 OR xf_thread.node_id = 289 OR xf_thread.node_id = 290 OR xf_thread.node_id = 291 OR xf_thread.node_id = 292 OR xf_thread.node_id = 293 OR xf_thread.node_id = 294 OR xf_thread.node_id = 295 OR xf_thread.node_id = 174 OR xf_thread.node_id = 20 OR xf_thread.node_id = 108 OR xf_thread.node_id = 198 OR xf_thread.node_id = 59 OR xf_thread.node_id = 188 OR xf_thread.node_id = 71 OR xf_thread.node_id = 65 OR xf_thread.node_id = 61 OR xf_thread.node_id = 55 OR xf_thread.node_id = 69 OR xf_thread.node_id = 88 OR xf_thread.node_id = 93 OR xf_thread.node_id = 92 OR xf_thread.node_id = 111 OR xf_thread.node_id = 94 OR xf_thread.node_id = 110 OR xf_thread.node_id = 109 OR xf_thread.node_id = 203 OR xf_thread.node_id = 191 OR xf_thread.node_id = 232 OR xf_thread.node_id = 233 OR xf_thread.node_id = 95 OR xf_thread.node_id = 213 OR xf_thread.node_id = 13 OR xf_thread.node_id = 17 OR xf_thread.node_id = 14 OR xf_thread.node_id = 16 OR xf_thread.node_id = 204 OR xf_thread.node_id = 15)
    AND xf_thread.thread_id <> '86711'
    
    
    
    
    ORDER BY xf_thread.post_date DESC
    LIMIT ?
    Params: 0, 5
    Run Time: 0.002833
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_threadrangePRIMARY,node_id_last_post_date,node_id_sticky_state_last_post,user_id,post_datepost_date4 45702Using where
    SIMPLExf_usereq_refPRIMARYPRIMARY4destee_180205.xf_thread.user_id1 
    SIMPLExf_nodeeq_refPRIMARYPRIMARY4destee_180205.xf_thread.node_id1 
  25. SELECT EWRporta2_articles.*, xf_thread.*, xf_post.*, xf_user.*, EWRporta2_authors.*
    FROM EWRporta2_articles
    	INNER JOIN xf_thread ON (xf_thread.thread_id = EWRporta2_articles.thread_id)
    	INNER JOIN xf_post ON (xf_post.post_id = xf_thread.first_post_id)
    	LEFT JOIN xf_user ON (xf_user.user_id = xf_thread.user_id)
    	LEFT JOIN EWRporta2_authors ON (EWRporta2_authors.user_id = xf_thread.user_id)
    WHERE EWRporta2_articles.thread_id = ?
    Params: 86711
    Run Time: 0.000371
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLE       Impossible WHERE noticed after reading const tables
  26. 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_Thread, Index, valid, thread_id=86711&page=266, 1558802397,
    Run Time: 0.000109
  27. select value, hits 
    from dark_azucloud_terms_pages pages 
    left join dark_azucloud_terms terms on pages.term_id = terms.id 
    where route = ? and terms.block = 0 and terms.value is not null and last_clicked > ? 
    order by hits desc, last_clicked desc
    limit ?
    Params: threads/when-trump-becomes-president-what-will-it-look-like.86711/page-266, 1543250397, 100
    Run Time: 0.000256
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEpagesrefterm_id_route,route,route_hits_last_clickedroute_hits_last_clicked452const1Using where
    SIMPLEtermseq_refPRIMARY,value,blockPRIMARY4destee_180205.pages.term_id1Using where
  28. SELECT *
    	FROM EWRporta2_layouts
    WHERE (layout_template = ?
    	)
    	AND active = 1
    ORDER BY layout_priority ASC
    Params: thread_view
    Run Time: 0.000237
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEEWRporta2_layoutsreflayout_templatelayout_template302const1Using index condition; Using where; Using filesort
  29. SELECT EWRporta2_widlinks.*, EWRporta2_widgets.widget_values, EWRporta2_widopts.widopt_values,
    	IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.widopt_id, 0) AS widopt_id,
    	IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.locked, EWRporta2_widgets.locked) AS locked,
    	IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.display, EWRporta2_widgets.display) AS display,
    	IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.groups, EWRporta2_widgets.groups) AS groups,
    	IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.ctime, EWRporta2_widgets.ctime) AS ctime,
    	IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.cdate, EWRporta2_widgets.cdate) AS cdate,
    	IF(EWRporta2_widopts.widopt_id, EWRporta2_widopts.cache, EWRporta2_widgets.cache) AS cache
    FROM EWRporta2_widlinks
    	INNER JOIN EWRporta2_widgets ON (EWRporta2_widgets.widget_id = EWRporta2_widlinks.widget_id)
    	LEFT JOIN EWRporta2_widopts ON (EWRporta2_widopts.widopt_id = EWRporta2_widlinks.widopt_id)
    WHERE layout_id = ?
    	AND EWRporta2_widgets.active = 1
    ORDER by widlink_order
    Params: thread_view
    Run Time: 0.005706
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEEWRporta2_widlinksreflayout_id,widget_idlayout_id302const41Using index condition; Using where; Using filesort
    SIMPLEEWRporta2_widgetseq_refPRIMARYPRIMARY302destee_180205.EWRporta2_widlinks.widget_id1Using where
    SIMPLEEWRporta2_widoptseq_refPRIMARYPRIMARY4destee_180205.EWRporta2_widlinks.widopt_id1 
  30. SELECT *
    FROM xf_addon
    WHERE addon_id = ?
    Params: EWRmedio
    Run Time: 0.000160
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_addonconstPRIMARYPRIMARY27const1 
  31. SELECT EWRmedio_media.*, EWRmedio_categories.*, EWRmedio_services.*, xf_user.*, EWRmedio_media.service_value2 AS service_value2,
    	ROUND((EWRmedio_media.media_comments * ?) + (EWRmedio_media.media_likes * ?) + (EWRmedio_media.media_views * ?)) AS popular_score,
    	ROUND(((EWRmedio_media.media_comments * ?) + (EWRmedio_media.media_likes * ?) + (EWRmedio_media.media_views * ?)) / CEIL((? - EWRmedio_media.media_date) / ?), 2) AS trending_score,
    	IF(NOT ISNULL(xf_user.user_id), xf_user.username, EWRmedio_media.username) AS username
    FROM EWRmedio_media
    	LEFT JOIN EWRmedio_categories ON (EWRmedio_categories.category_id = EWRmedio_media.category_id)
    	LEFT JOIN EWRmedio_services ON (EWRmedio_services.service_id = EWRmedio_media.service_id)
    	LEFT JOIN xf_user ON (xf_user.user_id = EWRmedio_media.user_id)
    WHERE EWRmedio_media.media_state = 'visible'
    	
    	AND EWRmedio_media.media_state = 'visible'
    ORDER BY EWRmedio_media.media_date DESC, EWRmedio_media.media_date DESC, EWRmedio_media.media_id DESC
    LIMIT ?, ?
    Params: 500, 100, 1, 500, 100, 1, 1558802397, 86400, 0, 2
    Run Time: 0.001122
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEEWRmedio_mediaALL    1707Using where; Using filesort
    SIMPLEEWRmedio_categorieseq_refPRIMARYPRIMARY4destee_180205.EWRmedio_media.category_id1 
    SIMPLEEWRmedio_serviceseq_refPRIMARYPRIMARY4destee_180205.EWRmedio_media.service_id1 
    SIMPLExf_usereq_refPRIMARYPRIMARY4destee_180205.EWRmedio_media.user_id1 
  32. 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.000555
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEprofile_postindex post_date4 10Using where
    SIMPLEposting_usereq_refPRIMARYPRIMARY4destee_180205.profile_post.user_id1 
    SIMPLEreceiving_usereq_refPRIMARYPRIMARY4destee_180205.profile_post.profile_user_id1 
    SIMPLEreceiving_user_privacyeq_refPRIMARYPRIMARY4destee_180205.profile_post.profile_user_id1 
    SIMPLEreceiving_user_followeq_refPRIMARY,follow_user_idPRIMARY8destee_180205.profile_post.profile_user_id,const1Using index
  33. SELECT *
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 273
    Run Time: 0.000143
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  34. SELECT *
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 410
    Run Time: 0.000110
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  35. SELECT *
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 410
    Run Time: 0.000078
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  36. SELECT *
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 333
    Run Time: 0.000076
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  37. SELECT *
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 333
    Run Time: 0.000075
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  38. SELECT *
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 273
    Run Time: 0.000074
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  39. SELECT *
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 410
    Run Time: 0.000127
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  40. SELECT *
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 410
    Run Time: 0.000121
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  41. SELECT *
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 333
    Run Time: 0.000088
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  42. SELECT *
    FROM xf_permission_combination
    WHERE permission_combination_id = ?
    Params: 410
    Run Time: 0.000109
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_permission_combinationconstPRIMARYPRIMARY4const1 
  43. SELECT COUNT(ld_id)
                FROM phc_linkdirectory as ld
    WHERE (ld.status != 'visible' OR lastcheck = 0)
    AND user_id = 0
    Run Time: 0.000179
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEldrefstatus,user_iduser_id4const1Using where
  44. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('page_nav', 'bdlinkexpander_link_direct', 'bdlinkexpander_link_expanded', 'bb_code_tag_code', 'bb_code_tag_php', 'bb_code_tag_html', 'bb_code_tag_quote', 'bb_code_tag_attach', 'bb_code_tag_spoiler', 'sonnb_xengallery_bbcode_photo', 'sonnb_xengallery_bbcode_video', 'sonnb_xengallery_bbcode_album', 'aadvapp_sidebar', 'EWRwidget_RawHtml', 'EWRwidget_MedioRecent', 'EWRwidget_StatusUpdates', 'wf_widget_wrapper', 'wf_widget_visitor_panel', 'thread_view', 'iversia_faq_navtabs', 'sonnb_xengallery_option_copyright', 'sonnbXG_copyright', 'sonnb_xengallery_navbar_template', 'siropu_ads_manager_tabs', 'xfa_blog_navigation_links', 'EWRmedio_Navtabs', 'ld_sub_nav', 'EWRporta2_Navtabs', 'xfa_blog_navigation_tab_link', 'dark_postrating', 'dark_postrating_member', 'dark_postrating_member_totals', 'message_user_info_extra', 'user_criteria_content', 'thread_list_item_icon_key', 'dark_postrating_member_notable_tabs', 'dark_postrating_account_wrapper', 'dark_postrating_navigation_visitor_tab', 'dark_postrating_visitor_panel', 'dark_postrating_member_card', 'dark_postrating_member_info', 'dark_postrating_message_user_info', 'sonnb_xengallery_nav_visitor', '_widget_renderer_template_198', '_widget_renderer_template_199', 'wf_widget_group_wrapper', '_widget_renderer_template_192', '_widget_renderer_template_194', 'destee_chat', 'siropu_chat', 'siropu_chat_disabled', 'siropu_ads_manager_tab_title', 'siropu_ads_manager_ad_type_code', 'siropu_ads_manager_ad_type_banner', 'siropu_ads_manager_ad_type_text', 'siropu_ads_manager_ad_type_link', 'siropu_ads_manager_ad_type_keyword', 'siropu_ads_manager_support_us', 'siropu_ads_manager_page_criteria_page_info', 'siropu_ads_manager_footer_links', 'siropu_ads_manager_admin_home', 'PAGE_CONTAINER')
    	AND style_id = ?
    	AND language_id = ?
    Params: 10, 1
    Run Time: 0.001105
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_template_compiledrangePRIMARYPRIMARY60 62Using where
  45. SELECT title, phrase_text
    FROM xf_phrase_compiled
    WHERE language_id = ?
    	AND title IN ('iversia_faq', 'tc_premium_page', 'media', 'ld_nav_title')
    Params: 1
    Run Time: 0.000123
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_phrase_compiledrangePRIMARYPRIMARY106 4Using where
  46. SELECT user.*
    	,
    		user_profile.*,
    		user_option.*,
    		user_privacy.*,
    		permission_combination.cache_value AS global_permission_cache,
    		user_ban.ban_date,
    		user_ban.end_date,
    		user_ban.user_reason,
    		user_ban.ban_user_id,
    		user_banned.username  AS user_banned_username
    	,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,14,2,13,12,8,11,6,5,10,4,7,9,3)) as positive_rating_count
    
    		, (user.like_count + coalesce((select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,14,2,13,12,8,11,6,5,10,4,7,9,3)), 0)) as positive_rating_count_incl_likes
    
    ,(select sum(count_received) from dark_postrating_count where user_id = user.user_id) as total_rating_count
    
    	,xfa_blog.last_entry
    	,xfa_blog.blog_key 
    	,xfa_blog.entry_count
    	
    		,xfa_blog_read.blog_read_date
    		
    FROM xf_user AS user
    
    		LEFT JOIN xf_user_profile AS user_profile ON
    			(user_profile.user_id = user.user_id)
    		LEFT JOIN xf_user_option AS user_option ON
    			(user_option.user_id = user.user_id)
    		LEFT JOIN xf_user_privacy AS user_privacy ON
    			(user_privacy.user_id = user.user_id)
    		LEFT JOIN xf_permission_combination AS permission_combination ON
    			(permission_combination.permission_combination_id = user.permission_combination_id)
    		LEFT JOIN xf_user_ban AS user_ban ON
    		 ( user_ban.user_id=user.user_id )
                    LEFT JOIN xf_user AS user_banned ON
                    (user_banned.user_id= user_ban.ban_user_id)
    	LEFT JOIN xfa_blog ON xfa_blog.user_id = user.user_id
    	
    		LEFT JOIN xfa_blog_read ON xfa_blog_read.blog_user_id = user.user_id AND xfa_blog_read.user_id = 1
    		
    WHERE user.user_id = ?
    Params: 1
    Run Time: 0.000672
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    PRIMARYuserconstPRIMARYPRIMARY4const1 
    PRIMARYuser_profileconstPRIMARYPRIMARY4const1 
    PRIMARYuser_optionconstPRIMARYPRIMARY4const1 
    PRIMARYuser_privacyconstPRIMARYPRIMARY4const1 
    PRIMARYpermission_combinationconstPRIMARYPRIMARY4const1 
    PRIMARYuser_banconstPRIMARYPRIMARY4const0unique row not found
    PRIMARYuser_bannedconstPRIMARY   1 
    PRIMARYxfa_blogconstPRIMARYPRIMARY4const1 
    PRIMARYxfa_blog_readconstuser_iduser_id8const,const1 
    SUBQUERYdark_postrating_countrefuser_id_ratinguser_id_rating4const13 
    SUBQUERYdark_postrating_countrangeuser_id_ratinguser_id_rating8 14Using index condition
    SUBQUERYdark_postrating_countrangeuser_id_ratinguser_id_rating8 14Using index condition
  47. SELECT d.*, ct.*, s.title as slider_title
    FROM xfa_slider_display AS d
                LEFT JOIN xfa_slider_content_template AS ct ON (d.content_template_id=ct.content_template_id)
                LEFT JOIN xfa_slider AS s ON (d.slider_id=s.slider_id)
    Run Time: 0.000193
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEdALL    1 
    SIMPLEcteq_refPRIMARYPRIMARY4destee_180205.d.content_template_id1 
    SIMPLEseq_refPRIMARYPRIMARY4destee_180205.d.slider_id1 
  48. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('aadvapp_sidebar', 'ld_thread_view_tools_links')
    	AND style_id = ?
    	AND language_id = ?
    Params: 10, 1
    Run Time: 0.000144
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_template_compiledrangePRIMARYPRIMARY60 2Using where
  49. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('aadvapp_sidebar', 'siropu_easy_user_ban_post_link')
    	AND style_id = ?
    	AND language_id = ?
    Params: 10, 1
    Run Time: 0.000159
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_template_compiledrangePRIMARYPRIMARY60 2Using where
  50. SELECT user.*
    	,
    		user_profile.*,
    		user_option.*,
    		user_privacy.*,
    		permission_combination.cache_value AS global_permission_cache,
    		user_ban.ban_date,
    		user_ban.end_date,
    		user_ban.user_reason,
    		user_ban.ban_user_id,
    		user_banned.username  AS user_banned_username
    	,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,14,2,13,12,8,11,6,5,10,4,7,9,3)) as positive_rating_count
    
    		, (user.like_count + coalesce((select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,14,2,13,12,8,11,6,5,10,4,7,9,3)), 0)) as positive_rating_count_incl_likes
    
    ,(select sum(count_received) from dark_postrating_count where user_id = user.user_id) as total_rating_count
    
    	,xfa_blog.last_entry
    	,xfa_blog.blog_key 
    	,xfa_blog.entry_count
    	
    		,xfa_blog_read.blog_read_date
    		
    FROM xf_user AS user
    
    		LEFT JOIN xf_user_profile AS user_profile ON
    			(user_profile.user_id = user.user_id)
    		LEFT JOIN xf_user_option AS user_option ON
    			(user_option.user_id = user.user_id)
    		LEFT JOIN xf_user_privacy AS user_privacy ON
    			(user_privacy.user_id = user.user_id)
    		LEFT JOIN xf_permission_combination AS permission_combination ON
    			(permission_combination.permission_combination_id = user.permission_combination_id)
    		LEFT JOIN xf_user_ban AS user_ban ON
    		 ( user_ban.user_id=user.user_id )
                    LEFT JOIN xf_user AS user_banned ON
                    (user_banned.user_id= user_ban.ban_user_id)
    	LEFT JOIN xfa_blog ON xfa_blog.user_id = user.user_id
    	
    		LEFT JOIN xfa_blog_read ON xfa_blog_read.blog_user_id = user.user_id AND xfa_blog_read.user_id = 2617
    		
    WHERE user.user_id = ?
    Params: 2617
    Run Time: 0.000771
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    PRIMARYuserconstPRIMARYPRIMARY4const1 
    PRIMARYuser_profileconstPRIMARYPRIMARY4const1 
    PRIMARYuser_optionconstPRIMARYPRIMARY4const1 
    PRIMARYuser_privacyconstPRIMARYPRIMARY4const1 
    PRIMARYpermission_combinationconstPRIMARYPRIMARY4const1 
    PRIMARYuser_banconstPRIMARYPRIMARY4const0unique row not found
    PRIMARYuser_bannedconstPRIMARY   1 
    PRIMARYxfa_blogconstPRIMARYPRIMARY4const1 
    PRIMARYxfa_blog_readconstuser_iduser_id8const,const0unique row not found
    SUBQUERYdark_postrating_countrefuser_id_ratinguser_id_rating4const11 
    SUBQUERYdark_postrating_countrangeuser_id_ratinguser_id_rating8 14Using index condition
    SUBQUERYdark_postrating_countrangeuser_id_ratinguser_id_rating8 14Using index condition
  51. SELECT user.*
    	,
    		user_profile.*,
    		user_option.*,
    		user_privacy.*,
    		permission_combination.cache_value AS global_permission_cache,
    		user_ban.ban_date,
    		user_ban.end_date,
    		user_ban.user_reason,
    		user_ban.ban_user_id,
    		user_banned.username  AS user_banned_username
    	,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,14,2,13,12,8,11,6,5,10,4,7,9,3)) as positive_rating_count
    
    		, (user.like_count + coalesce((select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,14,2,13,12,8,11,6,5,10,4,7,9,3)), 0)) as positive_rating_count_incl_likes
    
    ,(select sum(count_received) from dark_postrating_count where user_id = user.user_id) as total_rating_count
    
    	,xfa_blog.last_entry
    	,xfa_blog.blog_key 
    	,xfa_blog.entry_count
    	
    		,xfa_blog_read.blog_read_date
    		
    FROM xf_user AS user
    
    		LEFT JOIN xf_user_profile AS user_profile ON
    			(user_profile.user_id = user.user_id)
    		LEFT JOIN xf_user_option AS user_option ON
    			(user_option.user_id = user.user_id)
    		LEFT JOIN xf_user_privacy AS user_privacy ON
    			(user_privacy.user_id = user.user_id)
    		LEFT JOIN xf_permission_combination AS permission_combination ON
    			(permission_combination.permission_combination_id = user.permission_combination_id)
    		LEFT JOIN xf_user_ban AS user_ban ON
    		 ( user_ban.user_id=user.user_id )
                    LEFT JOIN xf_user AS user_banned ON
                    (user_banned.user_id= user_ban.ban_user_id)
    	LEFT JOIN xfa_blog ON xfa_blog.user_id = user.user_id
    	
    		LEFT JOIN xfa_blog_read ON xfa_blog_read.blog_user_id = user.user_id AND xfa_blog_read.user_id = 58137
    		
    WHERE user.user_id = ?
    Params: 58137
    Run Time: 0.000633
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    PRIMARYuserconstPRIMARYPRIMARY4const1 
    PRIMARYuser_profileconstPRIMARYPRIMARY4const1 
    PRIMARYuser_optionconstPRIMARYPRIMARY4const1 
    PRIMARYuser_privacyconstPRIMARYPRIMARY4const1 
    PRIMARYpermission_combinationconstPRIMARYPRIMARY4const1 
    PRIMARYuser_banconstPRIMARYPRIMARY4const0unique row not found
    PRIMARYuser_bannedconstPRIMARY   1 
    PRIMARYxfa_blogconstPRIMARYPRIMARY4const0unique row not found
    PRIMARYxfa_blog_readconstuser_iduser_id8const,const0unique row not found
    SUBQUERYdark_postrating_countrefuser_id_ratinguser_id_rating4const13 
    SUBQUERYdark_postrating_countrangeuser_id_ratinguser_id_rating8 14Using index condition
    SUBQUERYdark_postrating_countrangeuser_id_ratinguser_id_rating8 14Using index condition
  52. SELECT user.*
    	,
    		user_profile.*,
    		user_option.*,
    		user_privacy.*,
    		permission_combination.cache_value AS global_permission_cache,
    		user_ban.ban_date,
    		user_ban.end_date,
    		user_ban.user_reason,
    		user_ban.ban_user_id,
    		user_banned.username  AS user_banned_username
    	,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,14,2,13,12,8,11,6,5,10,4,7,9,3)) as positive_rating_count
    
    		, (user.like_count + coalesce((select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,14,2,13,12,8,11,6,5,10,4,7,9,3)), 0)) as positive_rating_count_incl_likes
    
    ,(select sum(count_received) from dark_postrating_count where user_id = user.user_id) as total_rating_count
    
    	,xfa_blog.last_entry
    	,xfa_blog.blog_key 
    	,xfa_blog.entry_count
    	
    		,xfa_blog_read.blog_read_date
    		
    FROM xf_user AS user
    
    		LEFT JOIN xf_user_profile AS user_profile ON
    			(user_profile.user_id = user.user_id)
    		LEFT JOIN xf_user_option AS user_option ON
    			(user_option.user_id = user.user_id)
    		LEFT JOIN xf_user_privacy AS user_privacy ON
    			(user_privacy.user_id = user.user_id)
    		LEFT JOIN xf_permission_combination AS permission_combination ON
    			(permission_combination.permission_combination_id = user.permission_combination_id)
    		LEFT JOIN xf_user_ban AS user_ban ON
    		 ( user_ban.user_id=user.user_id )
                    LEFT JOIN xf_user AS user_banned ON
                    (user_banned.user_id= user_ban.ban_user_id)
    	LEFT JOIN xfa_blog ON xfa_blog.user_id = user.user_id
    	
    		LEFT JOIN xfa_blog_read ON xfa_blog_read.blog_user_id = user.user_id AND xfa_blog_read.user_id = 57439
    		
    WHERE user.user_id = ?
    Params: 57439
    Run Time: 0.000621
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    PRIMARYuserconstPRIMARYPRIMARY4const1 
    PRIMARYuser_profileconstPRIMARYPRIMARY4const1 
    PRIMARYuser_optionconstPRIMARYPRIMARY4const1 
    PRIMARYuser_privacyconstPRIMARYPRIMARY4const1 
    PRIMARYpermission_combinationconstPRIMARYPRIMARY4const1 
    PRIMARYuser_banconstPRIMARYPRIMARY4const0unique row not found
    PRIMARYuser_bannedconstPRIMARY   1 
    PRIMARYxfa_blogconstPRIMARYPRIMARY4const0unique row not found
    PRIMARYxfa_blog_readconstuser_iduser_id8const,const0unique row not found
    SUBQUERYdark_postrating_countrefuser_id_ratinguser_id_rating4const7 
    SUBQUERYdark_postrating_countrangeuser_id_ratinguser_id_rating8 14Using index condition
    SUBQUERYdark_postrating_countrangeuser_id_ratinguser_id_rating8 14Using index condition
  53. SELECT user.*
    	,
    		user_profile.*,
    		user_option.*,
    		user_privacy.*,
    		permission_combination.cache_value AS global_permission_cache,
    		user_ban.ban_date,
    		user_ban.end_date,
    		user_ban.user_reason,
    		user_ban.ban_user_id,
    		user_banned.username  AS user_banned_username
    	,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,14,2,13,12,8,11,6,5,10,4,7,9,3)) as positive_rating_count
    
    		, (user.like_count + coalesce((select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,14,2,13,12,8,11,6,5,10,4,7,9,3)), 0)) as positive_rating_count_incl_likes
    
    ,(select sum(count_received) from dark_postrating_count where user_id = user.user_id) as total_rating_count
    
    	,xfa_blog.last_entry
    	,xfa_blog.blog_key 
    	,xfa_blog.entry_count
    	
    		,xfa_blog_read.blog_read_date
    		
    FROM xf_user AS user
    
    		LEFT JOIN xf_user_profile AS user_profile ON
    			(user_profile.user_id = user.user_id)
    		LEFT JOIN xf_user_option AS user_option ON
    			(user_option.user_id = user.user_id)
    		LEFT JOIN xf_user_privacy AS user_privacy ON
    			(user_privacy.user_id = user.user_id)
    		LEFT JOIN xf_permission_combination AS permission_combination ON
    			(permission_combination.permission_combination_id = user.permission_combination_id)
    		LEFT JOIN xf_user_ban AS user_ban ON
    		 ( user_ban.user_id=user.user_id )
                    LEFT JOIN xf_user AS user_banned ON
                    (user_banned.user_id= user_ban.ban_user_id)
    	LEFT JOIN xfa_blog ON xfa_blog.user_id = user.user_id
    	
    		LEFT JOIN xfa_blog_read ON xfa_blog_read.blog_user_id = user.user_id AND xfa_blog_read.user_id = 4688
    		
    WHERE user.user_id = ?
    Params: 4688
    Run Time: 0.000643
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    PRIMARYuserconstPRIMARYPRIMARY4const1 
    PRIMARYuser_profileconstPRIMARYPRIMARY4const1 
    PRIMARYuser_optionconstPRIMARYPRIMARY4const1 
    PRIMARYuser_privacyconstPRIMARYPRIMARY4const1 
    PRIMARYpermission_combinationconstPRIMARYPRIMARY4const1 
    PRIMARYuser_banconstPRIMARYPRIMARY4const0unique row not found
    PRIMARYuser_bannedconstPRIMARY   1 
    PRIMARYxfa_blogconstPRIMARYPRIMARY4const1 
    PRIMARYxfa_blog_readconstuser_iduser_id8const,const0unique row not found
    SUBQUERYdark_postrating_countrefuser_id_ratinguser_id_rating4const13 
    SUBQUERYdark_postrating_countrangeuser_id_ratinguser_id_rating8 14Using index condition
    SUBQUERYdark_postrating_countrangeuser_id_ratinguser_id_rating8 14Using index condition
  54. SELECT user.*
    	,
    		user_profile.*,
    		user_option.*,
    		user_privacy.*,
    		permission_combination.cache_value AS global_permission_cache,
    		user_ban.ban_date,
    		user_ban.end_date,
    		user_ban.user_reason,
    		user_ban.ban_user_id,
    		user_banned.username  AS user_banned_username
    	,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,14,2,13,12,8,11,6,5,10,4,7,9,3)) as positive_rating_count
    
    		, (user.like_count + coalesce((select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,14,2,13,12,8,11,6,5,10,4,7,9,3)), 0)) as positive_rating_count_incl_likes
    
    ,(select sum(count_received) from dark_postrating_count where user_id = user.user_id) as total_rating_count
    
    	,xfa_blog.last_entry
    	,xfa_blog.blog_key 
    	,xfa_blog.entry_count
    	
    		,xfa_blog_read.blog_read_date
    		
    FROM xf_user AS user
    
    		LEFT JOIN xf_user_profile AS user_profile ON
    			(user_profile.user_id = user.user_id)
    		LEFT JOIN xf_user_option AS user_option ON
    			(user_option.user_id = user.user_id)
    		LEFT JOIN xf_user_privacy AS user_privacy ON
    			(user_privacy.user_id = user.user_id)
    		LEFT JOIN xf_permission_combination AS permission_combination ON
    			(permission_combination.permission_combination_id = user.permission_combination_id)
    		LEFT JOIN xf_user_ban AS user_ban ON
    		 ( user_ban.user_id=user.user_id )
                    LEFT JOIN xf_user AS user_banned ON
                    (user_banned.user_id= user_ban.ban_user_id)
    	LEFT JOIN xfa_blog ON xfa_blog.user_id = user.user_id
    	
    		LEFT JOIN xfa_blog_read ON xfa_blog_read.blog_user_id = user.user_id AND xfa_blog_read.user_id = 26089
    		
    WHERE user.user_id = ?
    Params: 26089
    Run Time: 0.000614
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    PRIMARYuserconstPRIMARYPRIMARY4const1 
    PRIMARYuser_profileconstPRIMARYPRIMARY4const1 
    PRIMARYuser_optionconstPRIMARYPRIMARY4const1 
    PRIMARYuser_privacyconstPRIMARYPRIMARY4const1 
    PRIMARYpermission_combinationconstPRIMARYPRIMARY4const1 
    PRIMARYuser_banconstPRIMARYPRIMARY4const0unique row not found
    PRIMARYuser_bannedconstPRIMARY   1 
    PRIMARYxfa_blogconstPRIMARYPRIMARY4const1 
    PRIMARYxfa_blog_readconstuser_iduser_id8const,const1 
    SUBQUERYdark_postrating_countrefuser_id_ratinguser_id_rating4const7 
    SUBQUERYdark_postrating_countrangeuser_id_ratinguser_id_rating8 14Using index condition
    SUBQUERYdark_postrating_countrangeuser_id_ratinguser_id_rating8 14Using index condition
  55. SELECT user.*
    	,
    		user_profile.*,
    		user_option.*,
    		user_privacy.*,
    		permission_combination.cache_value AS global_permission_cache,
    		user_ban.ban_date,
    		user_ban.end_date,
    		user_ban.user_reason,
    		user_ban.ban_user_id,
    		user_banned.username  AS user_banned_username
    	,(select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,14,2,13,12,8,11,6,5,10,4,7,9,3)) as positive_rating_count
    
    		, (user.like_count + coalesce((select sum(count_received) from dark_postrating_count where user_id = user.user_id and rating in (1,14,2,13,12,8,11,6,5,10,4,7,9,3)), 0)) as positive_rating_count_incl_likes
    
    ,(select sum(count_received) from dark_postrating_count where user_id = user.user_id) as total_rating_count
    
    	,xfa_blog.last_entry
    	,xfa_blog.blog_key 
    	,xfa_blog.entry_count
    	
    		,xfa_blog_read.blog_read_date
    		
    FROM xf_user AS user
    
    		LEFT JOIN xf_user_profile AS user_profile ON
    			(user_profile.user_id = user.user_id)
    		LEFT JOIN xf_user_option AS user_option ON
    			(user_option.user_id = user.user_id)
    		LEFT JOIN xf_user_privacy AS user_privacy ON
    			(user_privacy.user_id = user.user_id)
    		LEFT JOIN xf_permission_combination AS permission_combination ON
    			(permission_combination.permission_combination_id = user.permission_combination_id)
    		LEFT JOIN xf_user_ban AS user_ban ON
    		 ( user_ban.user_id=user.user_id )
                    LEFT JOIN xf_user AS user_banned ON
                    (user_banned.user_id= user_ban.ban_user_id)
    	LEFT JOIN xfa_blog ON xfa_blog.user_id = user.user_id
    	
    		LEFT JOIN xfa_blog_read ON xfa_blog_read.blog_user_id = user.user_id AND xfa_blog_read.user_id = 12718
    		
    WHERE user.user_id = ?
    Params: 12718
    Run Time: 0.000642
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    PRIMARYuserconstPRIMARYPRIMARY4const1 
    PRIMARYuser_profileconstPRIMARYPRIMARY4const1 
    PRIMARYuser_optionconstPRIMARYPRIMARY4const1 
    PRIMARYuser_privacyconstPRIMARYPRIMARY4const1 
    PRIMARYpermission_combinationconstPRIMARYPRIMARY4const1 
    PRIMARYuser_banconstPRIMARYPRIMARY4const0unique row not found
    PRIMARYuser_bannedconstPRIMARY   1 
    PRIMARYxfa_blogconstPRIMARYPRIMARY4const1 
    PRIMARYxfa_blog_readconstuser_iduser_id8const,const0unique row not found
    SUBQUERYdark_postrating_countrefuser_id_ratinguser_id_rating4const13 
    SUBQUERYdark_postrating_countrangeuser_id_ratinguser_id_rating8 14Using index condition
    SUBQUERYdark_postrating_countrangeuser_id_ratinguser_id_rating8 14Using index condition
  56.             SELECT link.*
                    
                FROM `xf_bdlinkexpander_link` AS link
                    
                WHERE (link.url_md5 IN ('4b6a1ebb17cd22df401b629cd1ada7db', '93be8d6ee8d033b154956a1025b79248', '93cffcc1b4bf539e481c5c3b018c62a3', 'ca08b66e5d40330fb48a878a948afa47', 'be4ce859aa48f1a876b9add2fadcfe7a', 'de0770f203546af134a792a49c48da3f', '8e07e811b115c5a0c3ed9d3d31802e9f', '6303552222411a18ad0c1155e439d1f3', '1b063167253eee7c6f52a5b64ea22ce0', '59bb5631ba6d9dd5cbaa9160a088d339', '80ccfacc5b88d629eda74daa4df1fa30', '9077eddd6a392f68bcdcb5806aa4e01e', '6584febe2afaff7df13b041a98c45d18', 'b7e6b4bf30d84fd67de4900521de0596', 'a9aeac49f493de3d8dfd8228495c2cd6', 'ec397d9adb0d9bdd5df18e3c8712435c', 'c8b9f3361bcfcc2f0a8c802ffecd3e2d', 'f14553faf8f21e04b5ec0d22f2d39a37', '5a5f93880bff9aa7ab001491d8149cb0', '0ea8bfa3b0f1476e98f27678d587b5c2', '5d69044a519791352f14fbdf3204e1bd', 'd6f9a090ccc7c54da2e00b50ccf90fe4', '68385711749bf7c8aeae16db88f69cf9', '7350a40d48e7769e28b82ffd6f90fa73', '90583c0e7657ee093fe8037105d95682', 'f5503ddbefcc1de160acbbe0c358a091', '74c522dbf4fb94103e8ddfa37e33f7d6', 'fc10446f7119297f99b5c5b7677a9d3e', 'fff02ff758da169255308a890699b6fa', '33d52097c03dc67a5d2f9d2bba9a1739', '3afbd89dfd5a3a5fc657eb86efb8b1e6', '1cee1a7b1ae9545cffd6469e9368893b', 'f7f18153ebd7b004701703bb5668be53', '2ba2cbf150051efd3cb31abbaa698b43', '78c132a3ebfbc3f7f2d9387ce244c424', 'f1a105b733f02e4753b86cf1b0d96ae4', '9137044c745426b5e330397db0d5ea42', '373042ff4cf477878f48615647b34dd5', 'a3667e9f20c13ce475df2db9ed470bd0', '9621447b082f2df1cf5369f77b7c46c9', '41ac964a03d764a09a360194eff50586', 'f89002cef3aa53c9eecbbaa4a87e14d4', 'e3f76bde47546ff6cd4a28223507b0be', '1ff113763342fa314a0ba2f9a3f22903'))
    Run Time: 0.001414
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLElinkrangeurl_md5url_md599 44Using index condition
  57. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('aadvapp_sidebar', 'dark_azucloud')
    	AND style_id = ?
    	AND language_id = ?
    Params: 10, 1
    Run Time: 0.000239
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_template_compiledrangePRIMARYPRIMARY60 2Using where
  58. SELECT attachment.*,
    	data.filename, data.file_size, data.file_hash, data.file_path, data.width, data.height, data.thumbnail_width, data.thumbnail_height, data.xfa_slider_caption, data.xfa_slider_caption_url, data.xfa_slider_display_order
    FROM xf_attachment AS attachment
    INNER JOIN xf_attachment_data AS data ON
    	(data.data_id = attachment.data_id)
    WHERE attachment.content_type = ?
    	AND attachment.content_id IN (2)
    ORDER BY attachment.content_id, attachment.attach_date
    Params: xfaSlider
    Run Time: 0.000302
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLEattachmentrefcontent_type_id_datecontent_type_id_date31const,const10Using index condition; Using where
    SIMPLEdataeq_refPRIMARYPRIMARY4destee_180205.attachment.data_id1 
  59. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('aadvapp_sidebar', 'xfa_slider_home')
    	AND style_id = ?
    	AND language_id = ?
    Params: 10, 1
    Run Time: 0.000145
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_template_compiledrangePRIMARYPRIMARY60 2Using where
  60. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('aadvapp_sidebar', 'nat_bodyjs')
    	AND style_id = ?
    	AND language_id = ?
    Params: 10, 1
    Run Time: 0.000143
    Select TypeTableTypePossible KeysKeyKey LenRefRowsExtra
    SIMPLExf_template_compiledrangePRIMARYPRIMARY60 2Using where

Included Files (286, XenForo Classes: 85)

  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/Snog/CountryFlags/Listener/Dependencies.php
  29. library/XenNotices/Listener.php
  30. library/bdTagMe/Listener.php
  31. library/bdTagMe/Helper/Template.php
  32. library/bdTagMe/ShippableHelper/Updater.php
  33. library/bdTagMe/Option.php
  34. library/sonnb/XenGallery/Listener.php
  35. library/EWRmedio/Listener/Init.php
  36. library/XenForo/DataWriter/User.php
  37. library/XenForo/DataWriter.php
  38. library/EWRporta2/Listener/Init.php
  39. library/NodesAsTabs/Listen.php
  40. library/WidgetFramework/Listener.php
  41. library/WidgetFramework/Option.php
  42. library/phc/LinkDirectory/Listener/Listener.php
  43. library/XenForo/ControllerPublic/Abstract.php
  44. library/XenForo/Controller.php
  45. library/LiamW/AllRich/Addon.php
  46. library/MobileRead/ProfileBbCode/Listener/InitDependencies.php
  47. library/bdLinkExpander/Listener.php
  48. library/bdLinkExpander/ShippableHelper/Updater.php
  49. library/Siropu/Chat/Listener.php
  50. library/Siropu/EasyUserBan/Listener.php
  51. library/Snog/Applications/Listener/Dependencies.php
  52. library/XfAddOns/Blogs/Listener.php
  53. library/Siropu/AdsManager/Listener.php
  54. library/XfAddOns/Blogs/Install/Version.php
  55. library/XenForo/Router.php
  56. library/XenForo/Route/Filter.php
  57. library/XenForo/Route/Interface.php
  58. library/XenForo/Route/ResponseSuffix.php
  59. library/XenForo/Route/Prefix.php
  60. library/XenForo/Route/Prefix/Threads.php
  61. library/RemoveConversationTitle/Listener.php
  62. library/XenForo/RouteMatch.php
  63. library/NodesAsTabs/Model/Options.php
  64. library/Akinak/AdvancedPermissions/Listen.php
  65. library/Dark/PostRating/EventListener.php
  66. library/XenForo/ControllerPublic/Thread.php
  67. library/Icewind/ForumThreadViews/Listener/LoadClassController.php
  68. library/Andy/SimilarThreads/Listener.php
  69. library/Andy/Calendar/Listener.php
  70. library/EWRmedio/Listener/Controller.php
  71. library/EWRporta2/Listener/Controller.php
  72. library/Snog/Applications/Listener/Thread.php
  73. library/Icewind/ForumThreadViews/ControllerPublic/Thread.php
  74. library/sonnb/XenGallery/XenForo/ControllerPublic/Thread.php
  75. library/NodesAsTabs/ControllerPublic/Thread.php
  76. library/phc/LinkDirectory/Extend/XenForo/ControllerPublic/Thread.php
  77. library/Siropu/AdsManager/ControllerPublic/Thread.php
  78. library/Andy/SimilarThreads/ControllerPublic/Thread.php
  79. library/Andy/Calendar/ControllerPublic/Thread.php
  80. library/EWRmedio/ControllerPublic/Thread.php
  81. library/EWRporta2/ControllerPublic/Thread.php
  82. library/WidgetFramework/XenForo/ControllerPublic/Thread.php
  83. library/Snog/Applications/ControllerPublic/Thread.php
  84. library/XenForo/Input.php
  85. library/XenForo/Session.php
  86. library/Zend/Db.php
  87. library/Zend/Db/Adapter/Mysqli.php
  88. library/Zend/Db/Adapter/Abstract.php
  89. library/Zend/Db/Select.php
  90. library/Zend/Db/Expr.php
  91. library/Zend/Db/Profiler.php
  92. library/Zend/Db/Statement/Mysqli.php
  93. library/Zend/Db/Statement.php
  94. library/Zend/Db/Statement/Interface.php
  95. library/XenForo/Helper/Ip.php
  96. library/XenForo/Visitor.php
  97. library/XenForo/Model/User.php
  98. library/EWRmedio/Listener/Model.php
  99. library/EWRporta2/Listener/Model.php
  100. library/Akinak/AdvancedPermissions/Model/User.php
  101. library/bdTagMe/XenForo/Model/User.php
  102. library/Dark/PostRating/Model/User.php
  103. library/sonnb/XenGallery/XenForo/Model/User.php
  104. library/XfAddOns/Blogs/Override/Model/User.php
  105. library/EWRmedio/Model/User.php
  106. library/EWRporta2/Model/User.php
  107. library/Zend/Db/Profiler/Query.php
  108. library/XenForo/Permission.php
  109. library/XenForo/Helper/Php.php
  110. library/XenForo/Phrase.php
  111. library/XenForo/Locale.php
  112. library/Snog/CountryFlags/Listener/Visitor.php
  113. library/Snog/CountryFlags/Listener/Includes/Reader.php
  114. library/Snog/CountryFlags/Listener/Includes/Reader/Decoder.php
  115. library/Snog/CountryFlags/Listener/Includes/Reader/InvalidDatabaseException.php
  116. library/Snog/CountryFlags/Listener/Includes/Reader/Metadata.php
  117. library/Snog/CountryFlags/Listener/Includes/Reader/Util.php
  118. library/EWRporta2/Model/Perms.php
  119. library/XenForo/ControllerHelper/ForumThreadPost.php
  120. library/XenForo/ControllerHelper/Abstract.php
  121. library/XenForo/Model/Thread.php
  122. library/Snog/CountryFlags/Listener/Thread.php
  123. library/Akinak/AdvancedPermissions/Model/Thread.php
  124. library/Dark/PostRating/Model/Thread.php
  125. library/Snog/CountryFlags/Model/Thread.php
  126. library/Dark/PostRating/Model.php
  127. library/XenForo/Model/Forum.php
  128. library/Snog/Applications/Listener/Forum.php
  129. library/Akinak/AdvancedPermissions/Model/Forum.php
  130. library/Snog/Applications/Model/Forum.php
  131. library/XenForo/Helper/String.php
  132. library/XenForo/Helper/Discussion.php
  133. library/XenForo/Model/Post.php
  134. library/Snog/CountryFlags/Listener/Post.php
  135. library/Snog/Applications/Listener/Post.php
  136. library/Akinak/AdvancedPermissions/Model/Post.php
  137. library/Dark/PostRating/Model/Post.php
  138. library/XfAddOns/Blogs/Override/Model/Post.php
  139. library/EWRporta2/Model/Post.php
  140. library/bdLinkExpander/XenForo/Model/Post.php
  141. library/Snog/Applications/Model/Post.php
  142. library/EWRporta2/Model/Articles.php
  143. library/XenForo/Model/Attachment.php
  144. library/XenForo/Route/Prefix/Attachments.php
  145. library/XenForo/Model/Permission.php
  146. library/WidgetFramework/XenForo/Model/Permission.php
  147. library/XenForo/Model/Node.php
  148. library/XenForo/Route/Prefix/Categories.php
  149. library/XenForo/Route/Prefix/Forums.php
  150. library/XenForo/ControllerResponse/View.php
  151. library/XenForo/ControllerResponse/Abstract.php
  152. library/Andy/SimilarThreads/Model.php
  153. library/XenForo/NodeHandler/Page.php
  154. library/XenForo/NodeHandler/Abstract.php
  155. library/XenForo/NodeHandler/LinkForum.php
  156. library/WidgetFramework/NodeHandler/WidgetPage.php
  157. library/XenForo/NodeHandler/Category.php
  158. library/XenForo/NodeHandler/Forum.php
  159. library/XenForo/Model/Page.php
  160. library/XenForo/Model/LinkForum.php
  161. library/WidgetFramework/Model/WidgetPage.php
  162. library/XenForo/Model/Category.php
  163. library/XenForo/Db.php
  164. library/XenForo/Helper/Cookie.php
  165. library/NodesAsTabs/API.php
  166. library/XenForo/ViewRenderer/HtmlPublic.php
  167. library/XenForo/ViewRenderer/Abstract.php
  168. library/XenForo/Template/Public.php
  169. library/XenForo/Template/Abstract.php
  170. library/Dark/AzuCloud/EventListener/FrontControllerPreView.php
  171. library/Dark/AzuCloud/Model/Nakano.php
  172. library/WidgetFramework/Core.php
  173. library/XenForo/Model/Moderator.php
  174. library/sonnb/XenGallery/XenForo/Model/Moderator.php
  175. library/XenNotices/Model/Moderator.php
  176. library/XfAddOns/Blogs/Widget/Listener.php
  177. library/XenMods/HashTags/Listener/Widget.php
  178. library/Iversia/FAQ/Listener/Widgets.php
  179. library/Snog/Applications/Listener/Applications.php
  180. library/WidgetFramework/Model/Widget.php
  181. library/WidgetFramework/Helper/Sort.php
  182. library/Snog/Applications/ControllerPublic/Application.php
  183. library/XenForo/ViewPublic/Thread/View.php
  184. library/XenForo/ViewPublic/Base.php
  185. library/XenForo/View.php
  186. library/EWRporta2/Listener/ViewPublic.php
  187. library/EWRporta2/ViewPublic/Global.php
  188. library/EWRporta2/Model/Layouts.php
  189. library/EWRporta2/Model/Widlinks.php
  190. library/XenForo/BbCode/Parser.php
  191. library/XenForo/BbCode/Formatter/Base.php
  192. library/Snog/Applications/Listener/BBcode.php
  193. library/XenMods/HashTags/Listener/BbCode.php
  194. library/EWRmedio/Listener/BbCode.php
  195. library/EWRporta2/Listener/BbCode.php
  196. library/MobileRead/ProfileBbCode/Listener/Proxy.php
  197. library/bdTagMe/XenForo/BbCode/Formatter/Base.php
  198. library/sonnb/XenGallery/XenForo/BbCode/Formatter/Base.php
  199. library/Snog/Applications/BbCode/Formatter/Base.php
  200. library/XenMods/HashTags/XenForo/BbCode/Formatter/Base.php
  201. library/EWRmedio/BbCode/Formatter.php
  202. library/EWRporta2/BbCode/Formatter.php
  203. library/WidgetFramework/XenForo/BbCode/Formatter/Base.php
  204. library/MobileRead/ProfileBbCode/BbCode/Formatter/Restricted.php
  205. library/bdLinkExpander/XenForo/BbCode/Formatter/Base.php
  206. library/XfAddOns/Blogs/Template/Hook.php
  207. library/Snog/Applications/Listener/Sidebar.php
  208. library/EWRporta2/Widget/MedioRecent.php
  209. library/XenForo/Model/AddOn.php
  210. library/EWRmedio/Model/Lists.php
  211. library/EWRmedio/Model/Parser.php
  212. library/EWRmedio/Model/Media.php
  213. library/EWRporta2/Widget/StatusUpdates.php
  214. library/XenForo/Model/ProfilePost.php
  215. library/Akinak/AdvancedPermissions/Model/ProfilePost.php
  216. library/sonnb/XenGallery/XenForo/Model/ProfilePost.php
  217. library/XfAddOns/Blogs/Override/Model/ProfilePost.php
  218. library/XenForo/Model/UserProfile.php
  219. library/Akinak/AdvancedPermissions/Model/UserProfile.php
  220. library/XenForo/ViewPublic/Helper/Message.php
  221. library/XenForo/BbCode/TextWrapper.php
  222. library/WidgetFramework/WidgetRenderer.php
  223. library/WidgetFramework/WidgetRenderer/VisitorPanel.php
  224. library/XenForo/Route/Prefix/Members.php
  225. library/bdTagMe/XenForo/Route/Prefix/Members.php
  226. library/XenNotices/Model/XenNotice.php
  227. library/XenMods/HashTags/Listener/NavTabs.php
  228. library/Iversia/FAQ/Listener/TemplateHook.php
  229. library/Iversia/FAQ/Model/Category.php
  230. library/Iversia/FAQ/Route/Prefix/FAQ.php
  231. library/EWRporta2/Listener/NavTabs.php
  232. library/ThemesCorp/Premium/Helper/Tab.php
  233. library/Snog/Applications/Listener/NavTab.php
  234. library/Siropu/AdsManager/Helper/General.php
  235. library/XfAddOns/Blogs/Template/Navigation.php
  236. library/XfAddOns/Blogs/Model/MultiBlog.php
  237. library/EWRmedio/Listener/NavTabs.php
  238. library/EWRmedio/Model/Perms.php
  239. library/phc/LinkDirectory/Model/Links.php
  240. library/phc/LinkDirectory/Route/Prefix/LD.php
  241. library/NodesAsTabs/NavTabs.php
  242. library/XenForo/Route/Prefix/Pages.php
  243. library/XenForo/Route/Prefix/LinkForums.php
  244. library/WidgetFramework/WidgetGroup.php
  245. library/WidgetFramework/WidgetRenderer/TemplateWithoutWrapper.php
  246. library/WidgetFramework/WidgetRenderer/Template.php
  247. library/WidgetFramework/Model/WidgetRenderer/Template.php
  248. library/WidgetFramework/Template/Extended.php
  249. library/LiamW/AllRich/Template/Helper/Core.php
  250. library/EWRmedio/Listener/Template.php
  251. library/Dark/AzuCloud/EventListener/TemplateHook.php
  252. library/EWRporta2/Listener/Template.php
  253. library/XFA/Slider/Template.php
  254. library/XFA/Slider/Model/Display.php
  255. library/Siropu/AdsManager/Model/Ads.php
  256. library/ThemesCorp/Premium/Helper/Listener.php
  257. library/XenForo/Route/Prefix/Posts.php
  258. library/XenForo/Model/Avatar.php
  259. library/Snog/CountryFlags/Helper/Countries.php
  260. library/XenForo/ViewPublic/Helper/User.php
  261. library/bdLinkExpander/Option.php
  262. library/bdLinkExpander/Helper/Link.php
  263. library/XenForo/Helper/File.php
  264. library/bdLinkExpander/Helper/Html.php
  265. library/bdLinkExpander/Helper/Expander.php
  266. library/XenForo/Helper/Criteria.php
  267. library/s9e/MediaBBCodes.php
  268. library/EWRmedio/Route/Media.php
  269. library/EWRmedio/Template/Helper.php
  270. library/MobileRead/ProfileBbCode/Template/Helper/ProfileBbCode.php
  271. library/XenForo/Route/Prefix/ProfilePosts.php
  272. library/WidgetFramework/Helper/String.php
  273. library/WidgetFramework/Helper/Conditional.php
  274. library/XenForo/Template/Compiler/Function/Helper.php
  275. library/XenForo/Template/Compiler/Function/Interface.php
  276. library/WidgetFramework/Template/Helper/Conditional.php
  277. library/WidgetFramework/Model/Cache.php
  278. library/bdLinkExpander/Model/Link.php
  279. library/bdLinkExpander/ShippableHelper/Image.php
  280. library/XenForo/Debug.php
  281. library/Siropu/Chat/HelperDevice.php
  282. library/Siropu/Chat/ThirdParty/Mobile_Detect.php
  283. library/Siropu/Chat/Helper.php
  284. library/XFA/Slider/Model/Slider.php
  285. library/XenMods/HashTags/Listener/TemplateHook.php
  286. library/XenForo/ViewRenderer/Json.php