Page Time: 1.0152s

Memory: 4.5908 MB (Peak: 7.2117 MB)

Queries (14, time: 0.4656s, 45.9%)

1. SELECT data_key, data_value
   FROM xf_data_registry
   WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'deferredRun', 'simpleCache', 'addOns', 'defaultStyleProperties', 'routeFiltersIn', 'routeFiltersOut', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'userBanners', 'smilies', 'bbCode', 'threadPrefixes', 'userTitleLadder', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')

   Run Time: 0.144530

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_data_registry	range	PRIMARY	PRIMARY	27		26	Using where

2. SELECT cache_value
   FROM xf_permission_combination
   WHERE permission_combination_id = ?

   Params: 1
   Run Time: 0.024511

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

3. SELECT *
   FROM xf_search
   WHERE search_id = ?

   Params: 1333950
   Run Time: 0.023662

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

4. SELECT profile_post.*
   	,
   	posting_user.*,
   	IF(posting_user.username IS NULL, profile_post.username, posting_user.username) AS username,
   	receiving_user.username
   		AS profile_username,
   	receiving_user.gender
   		AS profile_gender,
   	receiving_user.user_state
   		AS profile_user_state,
   	receiving_user.user_group_id
   		AS profile_user_group_id,
   	receiving_user.secondary_group_ids
   		AS profile_secondary_group_ids,
   	receiving_user.display_style_group_id
   		AS profile_display_style_group_id,
   	receiving_user.is_banned
   		AS profile_is_banned,
   	receiving_user.is_admin
   		AS profile_is_admin,
   	receiving_user.is_moderator
   		AS profile_is_moderator,
   	receiving_user.avatar_date
   		AS profile_avatar_date,
   	receiving_user.gravatar
   		AS profile_gravatar,
   	receiving_user.warning_points
   		AS profile_warning_points,
   	receiving_user.permission_combination_id
   		AS profile_permission_combination_id,
   	receiving_user_privacy.allow_view_profile
   		AS profile_allow_view_profile,
   	receiving_user_privacy.allow_post_profile
   		AS profile_allow_post_profile,
   	receiving_user_privacy.allow_send_personal_conversation
   		AS profile_allow_send_personal_conversation,
   	receiving_user_privacy.allow_view_identities
   		AS profile_allow_view_identities,
   	receiving_user_privacy.allow_receive_news_feed
   		AS profile_allow_allow_receive_news_feed,
   	IF (receiving_user_follow.follow_user_id, 1, 0)
   		AS following_0
   FROM xf_profile_post AS profile_post
   
   	LEFT JOIN xf_user AS posting_user ON
   		(posting_user.user_id = profile_post.user_id)
   	LEFT JOIN xf_user AS receiving_user ON
   		(receiving_user.user_id = profile_post.profile_user_id)
   	LEFT JOIN xf_user_privacy AS receiving_user_privacy ON
   		(receiving_user_privacy.user_id = profile_post.profile_user_id)
   	LEFT JOIN xf_user_follow AS receiving_user_follow ON
   		(receiving_user_follow.user_id = profile_post.profile_user_id AND follow_user_id = 0)
   WHERE (profile_post.message_state IN ('visible'))
   ORDER BY profile_post.post_date DESC
    LIMIT 200

   Run Time: 0.027763

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	profile_post	ALL					778	Using where; Using filesort
   SIMPLE	posting_user	eq_ref	PRIMARY	PRIMARY	4	taxiderm_xf.profile_post.user_id	1
   SIMPLE	receiving_user	eq_ref	PRIMARY	PRIMARY	4	taxiderm_xf.profile_post.profile_user_id	1
   SIMPLE	receiving_user_privacy	eq_ref	PRIMARY	PRIMARY	4	taxiderm_xf.profile_post.profile_user_id	1
   SIMPLE	receiving_user_follow	eq_ref	PRIMARY,follow_user_id	PRIMARY	8	taxiderm_xf.profile_post.profile_user_id,const	1	Using index

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: 60403
   Run Time: 0.023561

   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: 60403
   Run Time: 0.023348

   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: 60403
   Run Time: 0.023346

   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: 60403
   Run Time: 0.023325

   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: 60403
   Run Time: 0.023320

   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: 60403
    Run Time: 0.023326

    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: 60403
    Run Time: 0.023282

    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: 60403
    Run Time: 0.023312

    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. 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",1798],["profilePost",1797],["profilePost",1796],["profilePost",1795],["profilePost",1794],["profilePost",1793],["profilePost",1792],["profilePost",1791],["profilePost",1790],["profilePost",1789],["profilePost",1788],["profilePost",1787],["profilePost",1786],["profilePost",1785],["profilePost",1784],["profilePost",1783],["profilePost",1782],["profilePost",1781],["profilePost",1780],["profilePost",1779],["profilePost",1778],["profilePost",1777],["profilePost",1776],["profilePost",1775],["profilePost",1774],["profilePost",1773],["profilePost",1772],["profilePost",1771],["profilePost",1770],["profilePost",1768],["profilePost",1767],["profilePost",1765],["profilePost",1764],["profilePost",1763],["profilePost",1762],["profilePost",1761],["profilePost",1759],["profilePost",1758],["profilePost",1757],["profilePost",1756],["profilePost",1755],["profilePost",1754],["profilePost",1753],["profilePost",1752],["profilePost",1751],["profilePost",1750],["profilePost",1749],["profilePost",1748],["profilePost",1747],["profilePost",1746],["profilePost",1745],["profilePost",1744],["profilePost",1743],["profilePost",1742],["profilePost",1741],["profilePost",1740],["profilePost",1739],["profilePost",1738],["profilePost",1737],["profilePost",1736],["profilePost",1735],["profilePost",1734],["profilePost",1733],["profilePost",1732],["profilePost",1731],["profilePost",1730],["profilePost",1729],["profilePost",1728],["profilePost",1727],["profilePost",1726],["profilePost",1725],["profilePost",1724],["profilePost",1723],["profilePost",1722],["profilePost",1720],["profilePost",1719],["profilePost",1718],["profilePost",1717],["profilePost",1716],["profilePost",1715],["profilePost",1713],["profilePost",1712],["profilePost",1711],["profilePost",1709],["profilePost",1708],["profilePost",1707],["profilePost",1704],["profilePost",1699],["profilePost",1698],["profilePost",1697],["profilePost",1696],["profilePost",1695],["profilePost",1694],["profilePost",1693],["profilePost",1692],["profilePost",1691],["profilePost",1690],["profilePost",1688],["profilePost",1687],["profilePost",1686],["profilePost",1685],["profilePost",1684],["profilePost",1683],["profilePost",1682],["profilePost",1681],["profilePost",1680],["profilePost",1679],["profilePost",1678],["profilePost",1677],["profilePost",1676],["profilePost",1675],["profilePost",1674],["profilePost",1672],["profilePost",1669],["profilePost",1668],["profilePost",1667],["profilePost",1666],["profilePost",1665],["profilePost",1664],["profilePost",1663],["profilePost",1662],["profilePost",1661],["profilePost",1660],["profilePost",1659],["profilePost",1658],["profilePost",1657],["profilePost",1656],["profilePost",1655],["profilePost",1654],["profilePost",1653],["profilePost",1652],["profilePost",1650],["profilePost",1649],["profilePost",1648],["profilePost",1647],["profilePost",1646],["profilePost",1645],["profilePost",1644],["profilePost",1643],["profilePost",1642],["profilePost",1641],["profilePost",1639],["profilePost",1638],["profilePost",1636],["profilePost",1635],["profilePost",1634],["profilePost",1633],["profilePost",1632],["profilePost",1631],["profilePost",1630],["profilePost",1628],["profilePost",1626],["profilePost",1625],["profilePost",1624],["profilePost",1623],["profilePost",1621],["profilePost",1620],["profilePost",1619],["profilePost",1618],["profilePost",1617],["profilePost",1616],["profilePost",1615],["profilePost",1614],["profilePost",1611],["profilePost",1610],["profilePost",1609],["profilePost",1608],["profilePost",1607],["profilePost",1606],["profilePost",1605],["profilePost",1604],["profilePost",1603],["profilePost",1602],["profilePost",1601],["profilePost",1600],["profilePost",1599],["profilePost",1598],["profilePost",1596],["profilePost",1595],["profilePost",1594],["profilePost",1593],["profilePost",1592],["profilePost",1591],["profilePost",1590],["profilePost",1589],["profilePost",1587],["profilePost",1586],["profilePost",1585],["profilePost",1584]], 189, new-profile-posts, , [], date, 0, , [], 0, 1594653020, e5e90eac995176ca784929f242361827
    Run Time: 0.028092

14. INSERT INTO `xf_session` (`session_id`, `session_data`, `expiry_date`) VALUES (?, ?, ?)

    Params: a8c063ce15984a4bc6cce37c236ee44c, , 1594656620
    Run Time: 0.030257

Included Files (95, XenForo Classes: 44)

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/Db.php
19. library/Zend/Db/Adapter/Mysqli.php
20. library/Zend/Db/Adapter/Abstract.php
21. library/Zend/Db/Select.php
22. library/Zend/Db/Expr.php
23. library/Zend/Db/Profiler.php
24. library/Zend/Db/Statement/Mysqli.php
25. library/Zend/Db/Statement.php
26. library/Zend/Db/Statement/Interface.php
27. library/Zend/Db/Profiler/Query.php
28. library/XenForo/CodeEvent.php
29. library/XenForo/Options.php
30. library/XenForo/Link.php
31. library/XenForo/Template/Helper/Core.php
32. library/bdMails/Listener.php
33. library/bdMails/Helper/Transport.php
34. library/bdMails/Option.php
35. library/bdMails/Transport/AmazonSes.php
36. library/bdMails/Transport/Abstract.php
37. library/Zend/Mail/Transport/Abstract.php
38. library/Zend/Mime.php
39. library/XenForo/Mail.php
40. library/Zend/Mail.php
41. library/Zend/Mime/Message.php
42. library/Zend/Mime/Part.php
43. library/bdMails/ShippableHelper/Updater.php
44. library/CTA/FeaturedThreads/Listener.php
45. library/NodesAsTabs/Listen.php
46. library/XenGallery/Listener.php
47. library/WidgetFramework/Listener.php
48. library/WidgetFramework/Option.php
49. library/XFResource/Sendy/Listener.php
50. library/XenForo/Router.php
51. library/XenForo/Route/Filter.php
52. library/XenForo/Route/Interface.php
53. library/XenForo/Route/ResponseSuffix.php
54. library/XenForo/Route/Prefix.php
55. library/WidgetFramework/Route/Filter/PageX.php
56. library/XenForo/Route/Prefix/FindNew.php
57. library/XenForo/RouteMatch.php
58. library/XenForo/ControllerPublic/FindNew.php
59. library/XenForo/ControllerPublic/Abstract.php
60. library/XenForo/Controller.php
61. library/CTA/FeaturedThreads/ControllerPublic/FindNew.php
62. library/XenGallery/ControllerPublic/FindNew.php
63. library/XenForo/Input.php
64. library/XenForo/Session.php
65. library/XenForo/Helper/Ip.php
66. library/XenForo/Visitor.php
67. library/XenForo/Model/User.php
68. library/WidgetFramework/XenForo/Model/User.php
69. library/CTA/FeaturedThreads/Model/User.php
70. library/XenGallery/Model/User.php
71. library/XenForo/Permission.php
72. library/XenForo/Helper/Php.php
73. library/XenForo/Phrase.php
74. library/XenForo/Locale.php
75. library/Sedo/DetectBrowser/Listener/Visitor.php
76. library/Sedo/DetectBrowser/Helper/MobileDetect.php
77. library/UnreadPostCount/Listener.php
78. library/XenForo/Model/ProfilePost.php
79. library/WidgetFramework/XenForo/Model/ProfilePost.php
80. library/XenForo/Model/Search.php
81. library/XenForo/Model/UserProfile.php
82. library/XenForo/Model/Banning.php
83. library/XenForo/ControllerResponse/Redirect.php
84. library/XenForo/ControllerResponse/Abstract.php
85. library/XenForo/Helper/Cookie.php
86. library/XenForo/ViewRenderer/HtmlPublic.php
87. library/XenForo/ViewRenderer/Abstract.php
88. library/XenForo/Template/Public.php
89. library/XenForo/Template/Abstract.php
90. library/WidgetFramework/Core.php
91. library/XenForo/Model/Moderator.php
92. library/XenGallery/Model/Moderator.php
93. library/WidgetFramework/Model/Widget.php
94. library/WidgetFramework/Helper/Sort.php
95. library/XenForo/Debug.php