Page Time: 0.1112s

Memory: 3.8788 MB (Peak: 7.3487 MB)

Queries (38, time: 0.0169s, 15.2%)

1. SELECT cache_value
   FROM xf_permission_combination
   WHERE permission_combination_id = ?

   Params: 1
   Run Time: 0.000118

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_permission_combination	const	PRIMARY	PRIMARY	4	const	1

2. SELECT *
   FROM xf_search
   WHERE search_id = ?

   Params: 26281883
   Run Time: 0.000938

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE								Impossible WHERE noticed after reading const tables

3. 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 200

   Run Time: 0.007124

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	profile_post	index		post_date	4		200	Using where
   SIMPLE	posting_user	eq_ref	PRIMARY	PRIMARY	4	ccxsccxs_dd.profile_post.user_id	1
   SIMPLE	receiving_user	eq_ref	PRIMARY	PRIMARY	4	ccxsccxs_dd.profile_post.profile_user_id	1
   SIMPLE	receiving_user_privacy	eq_ref	PRIMARY	PRIMARY	4	ccxsccxs_dd.profile_post.profile_user_id	1
   SIMPLE	receiving_user_follow	eq_ref	PRIMARY,follow_user_id	PRIMARY	8	ccxsccxs_dd.profile_post.profile_user_id,const	1	Using index

4. SELECT user_ban.*,
   	user.username,
   	banning_user.username AS banning_username
   FROM xf_user_ban AS user_ban
   LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
   LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
   WHERE user_ban.user_id = ?

   Params: 99002
   Run Time: 0.000518

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
   SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
   SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

5. SELECT user_ban.*,
   	user.username,
   	banning_user.username AS banning_username
   FROM xf_user_ban AS user_ban
   LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
   LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
   WHERE user_ban.user_id = ?

   Params: 99002
   Run Time: 0.000140

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
   SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
   SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

6. SELECT user_ban.*,
   	user.username,
   	banning_user.username AS banning_username
   FROM xf_user_ban AS user_ban
   LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
   LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
   WHERE user_ban.user_id = ?

   Params: 99002
   Run Time: 0.000146

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
   SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
   SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

7. SELECT user_ban.*,
   	user.username,
   	banning_user.username AS banning_username
   FROM xf_user_ban AS user_ban
   LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
   LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
   WHERE user_ban.user_id = ?

   Params: 99002
   Run Time: 0.000125

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
   SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
   SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

8. SELECT user_ban.*,
   	user.username,
   	banning_user.username AS banning_username
   FROM xf_user_ban AS user_ban
   LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
   LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
   WHERE user_ban.user_id = ?

   Params: 95875
   Run Time: 0.000594

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
   SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
   SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

9. SELECT user_ban.*,
   	user.username,
   	banning_user.username AS banning_username
   FROM xf_user_ban AS user_ban
   LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
   LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
   WHERE user_ban.user_id = ?

   Params: 95875
   Run Time: 0.000122

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
   SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
   SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

10. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 95875
    Run Time: 0.000123

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

11. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 95875
    Run Time: 0.000120

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

12. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 95875
    Run Time: 0.000118

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

13. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 95875
    Run Time: 0.000116

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

14. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 95875
    Run Time: 0.000115

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

15. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 98817
    Run Time: 0.000246

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

16. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 98313
    Run Time: 0.000350

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

17. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 95864
    Run Time: 0.000345

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

18. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 98796
    Run Time: 0.000310

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

19. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 98467
    Run Time: 0.000305

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

20. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 98486
    Run Time: 0.000292

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

21. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 98313
    Run Time: 0.000143

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

22. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 95875
    Run Time: 0.000147

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

23. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 95875
    Run Time: 0.000139

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

24. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 95875
    Run Time: 0.000133

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

25. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 32349
    Run Time: 0.000312

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

26. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 95875
    Run Time: 0.000133

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

27. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 95875
    Run Time: 0.000147

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

28. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 95875
    Run Time: 0.000128

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

29. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 98486
    Run Time: 0.000131

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

30. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 95875
    Run Time: 0.000126

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

31. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 69076
    Run Time: 0.000290

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

32. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 69076
    Run Time: 0.000144

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

33. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 98192
    Run Time: 0.000308

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

34. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 98192
    Run Time: 0.000134

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

35. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 98192
    Run Time: 0.000128

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

36. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 98090
    Run Time: 0.000289

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

37. SELECT user_ban.*,
    	user.username,
    	banning_user.username AS banning_username
    FROM xf_user_ban AS user_ban
    LEFT JOIN xf_user AS user ON (user.user_id = user_ban.user_id)
    LEFT JOIN xf_user AS banning_user ON (banning_user.user_id = user_ban.ban_user_id)
    WHERE user_ban.user_id = ?

    Params: 3294
    Run Time: 0.000340

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	user_ban	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	user	const	PRIMARY	PRIMARY	4	const	1
    SIMPLE	banning_user	const	PRIMARY	PRIMARY	4	const	1

38. INSERT INTO `xf_search` (`search_results`, `result_count`, `search_type`, `search_query`, `search_constraints`, `search_order`, `search_grouping`, `user_results`, `warnings`, `user_id`, `search_date`, `query_hash`) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

    Params: [["profilePost",31258],["profilePost",31223],["profilePost",31201],["profilePost",31200],["profilePost",31199],["profilePost",31196],["profilePost",31190],["profilePost",31189],["profilePost",31188],["profilePost",31185],["profilePost",31183],["profilePost",31182],["profilePost",31181],["profilePost",31176],["profilePost",31175],["profilePost",31174],["profilePost",31173],["profilePost",31172],["profilePost",31169],["profilePost",31168],["profilePost",31160],["profilePost",31158],["profilePost",31157],["profilePost",31156],["profilePost",31155],["profilePost",31144],["profilePost",31143],["profilePost",31135],["profilePost",31134],["profilePost",31131],["profilePost",31128],["profilePost",31127],["profilePost",31121],["profilePost",31120],["profilePost",31119],["profilePost",31110],["profilePost",31108],["profilePost",31101],["profilePost",31100],["profilePost",31099],["profilePost",31098],["profilePost",31097],["profilePost",31093],["profilePost",31090],["profilePost",31089],["profilePost",31088],["profilePost",31086],["profilePost",31076],["profilePost",31074],["profilePost",31073],["profilePost",31072],["profilePost",31071],["profilePost",31070],["profilePost",31069],["profilePost",31068],["profilePost",31066],["profilePost",31062],["profilePost",31061],["profilePost",31060],["profilePost",31057],["profilePost",31056],["profilePost",31050],["profilePost",31049],["profilePost",31045],["profilePost",31039],["profilePost",31035],["profilePost",31032],["profilePost",31031],["profilePost",31029],["profilePost",31026],["profilePost",31025],["profilePost",31023],["profilePost",31021],["profilePost",31019],["profilePost",31018],["profilePost",31017],["profilePost",31015],["profilePost",31009],["profilePost",31008],["profilePost",31006],["profilePost",31002],["profilePost",30993],["profilePost",30992],["profilePost",30990],["profilePost",30987],["profilePost",30978],["profilePost",30975],["profilePost",30970],["profilePost",30969],["profilePost",30964],["profilePost",30962],["profilePost",30958],["profilePost",30957],["profilePost",30955],["profilePost",30954],["profilePost",30949],["profilePost",30948],["profilePost",30946],["profilePost",30945],["profilePost",30944],["profilePost",30943],["profilePost",30942],["profilePost",30941],["profilePost",30940],["profilePost",30939],["profilePost",30937],["profilePost",30924],["profilePost",30923],["profilePost",30922],["profilePost",30921],["profilePost",30920],["profilePost",30917],["profilePost",30916],["profilePost",30911],["profilePost",30910],["profilePost",30908],["profilePost",30906],["profilePost",30905],["profilePost",30904],["profilePost",30903],["profilePost",30902],["profilePost",30899],["profilePost",30898],["profilePost",30897],["profilePost",30895],["profilePost",30889],["profilePost",30887],["profilePost",30873],["profilePost",30869],["profilePost",30868],["profilePost",30859],["profilePost",30857],["profilePost",30836],["profilePost",30835],["profilePost",30831],["profilePost",30830],["profilePost",30829],["profilePost",30828],["profilePost",30826],["profilePost",30825],["profilePost",30824],["profilePost",30822],["profilePost",30817],["profilePost",30816],["profilePost",30814],["profilePost",30813],["profilePost",30812],["profilePost",30811],["profilePost",30810],["profilePost",30805],["profilePost",30804],["profilePost",30802],["profilePost",30799],["profilePost",30798],["profilePost",30796],["profilePost",30795],["profilePost",30794],["profilePost",30793],["profilePost",30792],["profilePost",30791],["profilePost",30789],["profilePost",30788]], 162, new-profile-posts, , [], date, 0, , [], 0, 1714064364, e5e90eac995176ca784929f242361827
    Run Time: 0.001484

Included Files (92, XenForo Classes: 43)

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/Memcached.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/WidgetFramework/ShippableHelper/Updater.php
31. library/Brivium/BriviumHelper/EventListeners.php
32. library/Brivium/BriviumHelper/1010071/EventListeners.php
33. library/VNXF/Loto/Listener.php
34. library/UserInfo/Listener.php
35. library/VietXfAdvStats/Listener.php
36. library/Dark/TaigaChat/EventListener/Listener.php
37. library/bdMedal/Listener.php
38. library/HDJuegos/WaterMarkAdd/Listener.php
39. library/LiamW/AllRich/Addon.php
40. library/XenForo/Router.php
41. library/XenForo/Route/Filter.php
42. library/XenForo/Route/Interface.php
43. library/XenForo/Route/ResponseSuffix.php
44. library/XenForo/Route/Prefix.php
45. library/XenForo/Route/Prefix/FindNew.php
46. library/vtLai/UrlKhongDau/Listener.php
47. library/XenForo/RouteMatch.php
48. library/XenForo/ControllerPublic/FindNew.php
49. library/XenForo/ControllerPublic/Abstract.php
50. library/XenForo/Controller.php
51. library/Vinavb/CustomNodeIcon/Listener.php
52. library/XenPlaza/XPlimitLink/Listener/Listener.php
53. library/Brivium/CommentEachPost/ControllerPublic/FindNew.php
54. library/XenForo/Input.php
55. library/XenForo/Session.php
56. library/Zend/Db.php
57. library/Zend/Db/Adapter/Mysqli.php
58. library/Zend/Db/Adapter/Abstract.php
59. library/Zend/Db/Select.php
60. library/Zend/Db/Expr.php
61. library/Zend/Db/Profiler.php
62. library/Zend/Db/Statement/Mysqli.php
63. library/Zend/Db/Statement.php
64. library/Zend/Db/Statement/Interface.php
65. library/XenForo/Helper/Ip.php
66. library/XenForo/Visitor.php
67. library/XenForo/Model/User.php
68. library/UserInfo/User.php
69. library/WidgetFramework/XenForo/Model/User.php
70. library/VietXfAdvStats/XenForo/Model/User.php
71. library/Zend/Db/Profiler/Query.php
72. library/XenForo/Permission.php
73. library/XenForo/Helper/Php.php
74. library/XenForo/Phrase.php
75. library/XenForo/Locale.php
76. library/XenForo/Model/ProfilePost.php
77. library/WidgetFramework/XenForo/Model/ProfilePost.php
78. library/XenForo/Model/Search.php
79. library/XenForo/Model/UserProfile.php
80. library/XenForo/Model/Banning.php
81. library/XenForo/ControllerResponse/Redirect.php
82. library/XenForo/ControllerResponse/Abstract.php
83. library/XenForo/Helper/Cookie.php
84. library/XenForo/ViewRenderer/HtmlPublic.php
85. library/XenForo/ViewRenderer/Abstract.php
86. library/XenForo/Template/Public.php
87. library/XenForo/Template/Abstract.php
88. library/WidgetFramework/Core.php
89. library/XenForo/Model/Moderator.php
90. library/WidgetFramework/Model/Widget.php
91. library/WidgetFramework/Helper/Sort.php
92. library/XenForo/Debug.php