Page Time: 0.1187s

Memory: 12.2971 MB (Peak: 18.5954 MB)

Queries (11, time: 0.0058s, 4.9%)

1. SELECT cache_value
   FROM xf_permission_combination
   WHERE permission_combination_id = ?

   Params: 1
   Run Time: 0.000236

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

2. SELECT user.*
   	,
   		user_profile.*,
   		user_option.*,
   		user_privacy.*,
   		0 AS following_0,
   		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
   	
   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_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
   	
   WHERE user.user_id = ?

   Params: 46
   Run Time: 0.001081

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   PRIMARY	user	const	PRIMARY	PRIMARY	4	const	1
   PRIMARY	user_profile	const	PRIMARY	PRIMARY	4	const	1
   PRIMARY	user_option	const	PRIMARY	PRIMARY	4	const	1
   PRIMARY	user_privacy	const	PRIMARY	PRIMARY	4	const	1
   PRIMARY	user_ban	const	PRIMARY	PRIMARY	4	const	0	unique row not found
   PRIMARY	user_banned	const	PRIMARY				1
   PRIMARY	xfa_blog	const	PRIMARY	PRIMARY	4	const	1
   SUBQUERY	dark_postrating_count	ref	user_id_rating	user_id_rating	4	const	13
   SUBQUERY	dark_postrating_count	range	user_id_rating	user_id_rating	8		14	Using index condition
   SUBQUERY	dark_postrating_count	range	user_id_rating	user_id_rating	8		14	Using index condition

3. SELECT *
   FROM xf_permission_combination
   WHERE permission_combination_id = ?

   Params: 277
   Run Time: 0.000232

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

4. SELECT user.*,
   	user_profile.*,
   	user_option.*
   FROM xf_user_follow AS user_follow
   INNER JOIN xf_user AS user ON
   	(user.user_id = user_follow.follow_user_id AND user.is_banned = 0)
   INNER JOIN xf_user_profile AS user_profile ON
   	(user_profile.user_id = user.user_id)
   INNER JOIN xf_user_option AS user_option ON
   	(user_option.user_id = user.user_id)
   WHERE user_follow.user_id = ?
   ORDER BY user.username
    LIMIT 41

   Params: 46
   Run Time: 0.001552

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	user_follow	ref	PRIMARY,follow_user_id	PRIMARY	4	const	1	Using index; Using temporary; Using filesort
   SIMPLE	user_option	eq_ref	PRIMARY	PRIMARY	4	destee_180205.user_follow.follow_user_id	1
   SIMPLE	user_profile	eq_ref	PRIMARY	PRIMARY	4	destee_180205.user_follow.follow_user_id	1
   SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	destee_180205.user_follow.follow_user_id	1	Using where

5. 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_Member, Following, valid, user_id=46, 1550399655,
   Run Time: 0.000131

6. SELECT COUNT(ld_id)
               FROM phc_linkdirectory as ld
   WHERE (ld.status != 'visible' OR lastcheck = 0)
   AND user_id = 0

   Run Time: 0.000254

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	ld	ref	status,user_id	user_id	4	const	1	Using where

7. SELECT title, template_compiled
   FROM xf_template_compiled
   WHERE title IN ('page_nav', 'aadvapp_sidebar', 'member_following', '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', 'wf_widget_wrapper', '_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.001361

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_template_compiled	range	PRIMARY	PRIMARY	60		47	Using where

8. 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.000200

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_phrase_compiled	range	PRIMARY	PRIMARY	106		4	Using where

9. 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.000202

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	d	ALL					1
   SIMPLE	ct	eq_ref	PRIMARY	PRIMARY	4	destee_180205.d.content_template_id	1
   SIMPLE	s	eq_ref	PRIMARY	PRIMARY	4	destee_180205.d.slider_id	1

10. 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.000330

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_template_compiled	range	PRIMARY	PRIMARY	60		2	Using where

11. 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.000215

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_template_compiled	range	PRIMARY	PRIMARY	60		2	Using where

Included Files (189, XenForo Classes: 55)

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/Members.php
61. library/RemoveConversationTitle/Listener.php
62. library/bdTagMe/XenForo/Route/Prefix/Members.php
63. library/XenForo/RouteMatch.php
64. library/NodesAsTabs/Model/Options.php
65. library/Akinak/AdvancedPermissions/Listen.php
66. library/Dark/PostRating/EventListener.php
67. library/XenForo/ControllerPublic/Member.php
68. library/Icewind/ForumThreadViews/Listener/LoadClassController.php
69. library/MobileRead/ProfileBbCode/Listener/Proxy.php
70. library/Akinak/AdvancedPermissions/ControllerPublic/Member.php
71. library/bdTagMe/XenForo/ControllerPublic/Member.php
72. library/Dark/PostRating/ControllerPublic/Member.php
73. library/sonnb/XenGallery/XenForo/ControllerPublic/Member.php
74. library/phc/LinkDirectory/Extend/XenForo/ControllerPublic/Member.php
75. library/MobileRead/ProfileBbCode/ControllerPublic/Member.php
76. library/Siropu/EasyUserBan/ControllerPublic/Member.php
77. library/XenForo/Input.php
78. library/XenForo/Session.php
79. library/Zend/Db.php
80. library/Zend/Db/Adapter/Mysqli.php
81. library/Zend/Db/Adapter/Abstract.php
82. library/Zend/Db/Select.php
83. library/Zend/Db/Expr.php
84. library/Zend/Db/Profiler.php
85. library/Zend/Db/Statement/Mysqli.php
86. library/Zend/Db/Statement.php
87. library/Zend/Db/Statement/Interface.php
88. library/XenForo/Helper/Ip.php
89. library/XenForo/Visitor.php
90. library/XenForo/Model/User.php
91. library/EWRmedio/Listener/Model.php
92. library/EWRporta2/Listener/Model.php
93. library/Akinak/AdvancedPermissions/Model/User.php
94. library/bdTagMe/XenForo/Model/User.php
95. library/Dark/PostRating/Model/User.php
96. library/sonnb/XenGallery/XenForo/Model/User.php
97. library/XfAddOns/Blogs/Override/Model/User.php
98. library/EWRmedio/Model/User.php
99. library/EWRporta2/Model/User.php
100. library/Zend/Db/Profiler/Query.php
101. library/XenForo/Permission.php
102. library/XenForo/Helper/Php.php
103. library/XenForo/Phrase.php
104. library/XenForo/Locale.php
105. library/Snog/CountryFlags/Listener/Visitor.php
106. library/Snog/CountryFlags/Listener/Includes/Reader.php
107. library/Snog/CountryFlags/Listener/Includes/Reader/Decoder.php
108. library/Snog/CountryFlags/Listener/Includes/Reader/InvalidDatabaseException.php
109. library/Snog/CountryFlags/Listener/Includes/Reader/Metadata.php
110. library/Snog/CountryFlags/Listener/Includes/Reader/Util.php
111. library/XenForo/ControllerHelper/UserProfile.php
112. library/XenForo/ControllerHelper/Abstract.php
113. library/Dark/PostRating/Model.php
114. library/XenForo/Model/UserProfile.php
115. library/Akinak/AdvancedPermissions/Model/UserProfile.php
116. library/XenForo/Model/Permission.php
117. library/WidgetFramework/XenForo/Model/Permission.php
118. library/XenForo/ControllerResponse/View.php
119. library/XenForo/ControllerResponse/Abstract.php
120. library/XenForo/Helper/Cookie.php
121. library/XenForo/ViewRenderer/HtmlPublic.php
122. library/XenForo/ViewRenderer/Abstract.php
123. library/XenForo/Template/Public.php
124. library/XenForo/Template/Abstract.php
125. library/Dark/AzuCloud/EventListener/FrontControllerPreView.php
126. library/Dark/AzuCloud/Model/Nakano.php
127. library/WidgetFramework/Core.php
128. library/XenForo/Model/Moderator.php
129. library/sonnb/XenGallery/XenForo/Model/Moderator.php
130. library/XenNotices/Model/Moderator.php
131. library/XfAddOns/Blogs/Widget/Listener.php
132. library/XenMods/HashTags/Listener/Widget.php
133. library/Iversia/FAQ/Listener/Widgets.php
134. library/Snog/Applications/Listener/Applications.php
135. library/WidgetFramework/Model/Widget.php
136. library/WidgetFramework/Helper/Sort.php
137. library/Snog/Applications/ControllerPublic/Application.php
138. library/EWRporta2/Listener/ViewPublic.php
139. library/XenForo/ViewPublic/Base.php
140. library/XenForo/View.php
141. library/XfAddOns/Blogs/Template/Hook.php
142. library/Snog/Applications/Listener/Sidebar.php
143. library/XenNotices/Model/XenNotice.php
144. library/XenMods/HashTags/Listener/NavTabs.php
145. library/Iversia/FAQ/Listener/TemplateHook.php
146. library/Iversia/FAQ/Model/Category.php
147. library/Iversia/FAQ/Route/Prefix/FAQ.php
148. library/EWRporta2/Listener/NavTabs.php
149. library/EWRporta2/Model/Perms.php
150. library/ThemesCorp/Premium/Helper/Tab.php
151. library/Snog/Applications/Listener/NavTab.php
152. library/Siropu/AdsManager/Helper/General.php
153. library/XfAddOns/Blogs/Template/Navigation.php
154. library/XfAddOns/Blogs/Model/MultiBlog.php
155. library/EWRmedio/Listener/NavTabs.php
156. library/EWRmedio/Model/Perms.php
157. library/phc/LinkDirectory/Model/Links.php
158. library/phc/LinkDirectory/Route/Prefix/LD.php
159. library/NodesAsTabs/NavTabs.php
160. library/XenForo/Model/Node.php
161. library/XenForo/Route/Prefix/Pages.php
162. library/XenForo/Route/Prefix/LinkForums.php
163. library/WidgetFramework/WidgetRenderer.php
164. library/WidgetFramework/WidgetGroup.php
165. library/WidgetFramework/WidgetRenderer/TemplateWithoutWrapper.php
166. library/WidgetFramework/WidgetRenderer/Template.php
167. library/WidgetFramework/Model/WidgetRenderer/Template.php
168. library/WidgetFramework/Template/Extended.php
169. library/XenForo/Helper/String.php
170. library/LiamW/AllRich/Template/Helper/Core.php
171. library/EWRmedio/Listener/Template.php
172. library/EWRmedio/Model/Lists.php
173. library/Dark/AzuCloud/EventListener/TemplateHook.php
174. library/EWRporta2/Listener/Template.php
175. library/XFA/Slider/Template.php
176. library/XFA/Slider/Model/Display.php
177. library/Siropu/AdsManager/Model/Ads.php
178. library/ThemesCorp/Premium/Helper/Listener.php
179. library/XenForo/Helper/Criteria.php
180. library/XenForo/Debug.php
181. library/WidgetFramework/Helper/String.php
182. library/WidgetFramework/Model/Cache.php
183. library/WidgetFramework/Helper/Conditional.php
184. library/XenForo/Template/Compiler/Function/Helper.php
185. library/XenForo/Template/Compiler/Function/Interface.php
186. library/Siropu/Chat/HelperDevice.php
187. library/Siropu/Chat/ThirdParty/Mobile_Detect.php
188. library/Siropu/Chat/Helper.php
189. library/XenForo/ViewRenderer/Json.php