Page Time: 0.2259s

Memory: 10.4071 MB (Peak: 11.9078 MB)

Queries (19, time: 0.0163s, 7.2%)

1. SELECT data_key, data_value
   FROM xf_data_registry
   WHERE data_key IN ('options', 'languages', 'contentTypes', 'codeEventListeners', 'cron', 'simpleCache', 'routesPublic', 'nodeTypes', 'bannedIps', 'discouragedIps', 'styles', 'displayStyles', 'smilies', 'bbCode', 'threadPrefixes', 'trophyUserTitles', 'reportCounts', 'moderationCounts', 'userModerationCounts', 'notices', 'userFieldsInfo')

   Run Time: 0.000638

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

2. SELECT data_value
   FROM xf_data_registry
   WHERE data_key = ?

   Params: moods
   Run Time: 0.000152

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_data_registry	const	PRIMARY	PRIMARY	77	const	1

3. SELECT data_value
   FROM xf_data_registry
   WHERE data_key = ?

   Params: adData
   Run Time: 0.000118

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_data_registry	const	PRIMARY	PRIMARY	77	const	1

4. SELECT cache_value
   FROM xf_permission_combination
   WHERE permission_combination_id = ?

   Params: 1
   Run Time: 0.000077

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

5. SELECT *
   FROM xf_node
   WHERE display_in_list = 1
   ORDER BY lft ASC

   Run Time: 0.000136

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_node	ALL	display_in_list				27	Using where; Using filesort

6. SELECT cache_value
   FROM xf_permission_cache_content_type
   WHERE permission_combination_id = ?
           AND content_type = 'node'

   Params: 1
   Run Time: 0.000080

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_permission_cache_content_type	const	PRIMARY	PRIMARY	81	const,const	1

7. SELECT forum.*
           ,
                   NULL AS forum_read_date
   FROM xf_forum AS forum
   INNER JOIN xf_node AS node ON (node.node_id = forum.node_id)
   
   WHERE forum.node_id IN (31, 32, 33, 39, 42, 14, 15, 16, 17, 19, 3, 38, 4, 10, 8, 44, 45, 18, 11, 20, 2)

   Run Time: 0.000158

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	forum	ALL	PRIMARY				21	Using where
   SIMPLE	node	eq_ref	PRIMARY	PRIMARY	4	forum_muznews.forum.node_id	1	Using index

8. SELECT session_activity.*
           ,
           user.*,
           user_profile.*,
           user_option.*
   FROM xf_session_activity AS session_activity
   
           LEFT JOIN xf_user AS user ON
                   (user.user_id = session_activity.user_id)
           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)
   WHERE (session_activity.view_date > 1382476709)
   ORDER BY session_activity.view_date DESC

   Run Time: 0.000711

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	session_activity	ALL	view_date				22	Using where; Using filesort
   SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	forum_muznews.session_activity.user_id	1
   SIMPLE	user_profile	eq_ref	PRIMARY	PRIMARY	4	forum_muznews.user.user_id	1
   SIMPLE	user_option	eq_ref	PRIMARY	PRIMARY	4	forum_muznews.user.user_id	1

9. SELECT data_value
   FROM xf_data_registry
   WHERE data_key = ?

   Params: boardTotals
   Run Time: 0.000122

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	xf_data_registry	const	PRIMARY	PRIMARY	77	const	1

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

    Params: fb1f74b1a64b0fe0d061e7d4a0544d59, a:9:{s:12:"sessionStart";i:1382477609;s:2:"ip";i:3488738662;s:9:"userAgent";s:89:"Mozilla/5.0 (compatible; archive.org_bot +http://www.archive.org/details/archive.org_bot)";s:7:"isRobot";b:0;s:7:"referer";s:20:"https://muztalks.com/";s:10:"fromSearch";b:0;s:16:"previousActivity";i:0;s:10:"isIpBanned";b:0;s:13:"isDiscouraged";b:0;}, 1382481209
    Run Time: 0.000125

11. INSERT INTO xf_session_activity
            (user_id, unique_key, ip, controller_name, controller_action, view_state, params, view_date)
    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)

    Params: 0, 3488738662, 3488738662, XenForo_ControllerPublic_Index, Index, valid, , 1382477609
    Run Time: 0.000123

12. SELECT cache_data
    FROM xf_xen_ams_cache
    WHERE cache_key = ?

    Params: xen_ams
    Run Time: 0.000066

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_xen_ams_cache	const	PRIMARY	PRIMARY	77	const	1

13. SELECT
      up.dob_year,
      u.*,
      uo.show_dob_year, uo.show_dob_date
    FROM
      `xf_user_profile` AS up
    LEFT JOIN `xf_user` AS u ON u.user_id=up.user_id
    LEFT JOIN `xf_user_option` AS uo ON uo.user_id=u.user_id
    WHERE
      up.dob_day > 0
     AND (up.dob_day = 22 AND up.dob_month = 10) AND uo.show_dob_date = 1 AND is_banned = 0 ORDER BY user_id

    Run Time: 0.000265

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	up	ALL	PRIMARY				1057	Using where; Using temporary; Using filesort
    SIMPLE	uo	eq_ref	PRIMARY	PRIMARY	4	forum_muznews.up.user_id	1	Using where
    SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	forum_muznews.uo.user_id	1	Using where

14.         SELECT thread.*,
                   post.*,
                 user.*
            FROM xf_post AS post
            LEFT JOIN xf_thread AS thread ON
    (thread.thread_id = post.thread_id)
        LEFT JOIN xf_user AS user ON
    (user.user_id = post.user_id)
            WHERE
            post.message_state = 'visible'
            ORDER BY post.post_date DESC
            LIMIT 56

    Run Time: 0.013241

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	post	ALL					24091	Using where; Using filesort
    SIMPLE	thread	eq_ref	PRIMARY	PRIMARY	4	forum_muznews.post.thread_id	1
    SIMPLE	user	eq_ref	PRIMARY	PRIMARY	4	forum_muznews.post.user_id	1

15. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
            AND content_type = ?
            AND content_id = ?

    Params: 1, node, 32
    Run Time: 0.000079

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	85	const,const,const	1

16. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
            AND content_type = ?
            AND content_id = ?

    Params: 1, node, 16
    Run Time: 0.000063

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	85	const,const,const	1

17. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
            AND content_type = ?
            AND content_id = ?

    Params: 1, node, 8
    Run Time: 0.000063

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	85	const,const,const	1

18. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
            AND content_type = ?
            AND content_id = ?

    Params: 1, node, 33
    Run Time: 0.000063

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	85	const,const,const	1

19. SELECT cache_value
    FROM xf_permission_cache_content
    WHERE permission_combination_id = ?
            AND content_type = ?
            AND content_id = ?

    Params: 1, node, 39
    Run Time: 0.000064

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	xf_permission_cache_content	const	PRIMARY	PRIMARY	85	const,const,const	1

Included Files (122, XenForo Classes: 57)

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.php
17. library/XenForo/Model/DataRegistry.php
18. library/XenForo/CodeEvent.php
19. library/Zend/Db.php
20. library/Zend/Db/Adapter/Mysqli.php
21. library/Zend/Db/Adapter/Abstract.php
22. library/Zend/Db/Select.php
23. library/Zend/Db/Expr.php
24. library/Zend/Db/Profiler.php
25. library/Zend/Db/Statement/Mysqli.php
26. library/Zend/Db/Statement.php
27. library/Zend/Db/Statement/Interface.php
28. library/Zend/Db/Profiler/Query.php
29. library/XenForo/Options.php
30. library/XenForo/Link.php
31. library/XenForo/Template/Helper/Core.php
32. library/XenMoods/Listener/InitDependencies.php
33. library/XenAms/Listener/InitDependencies.php
34. library/XenForo/Router.php
35. library/XenForo/Route/ResponseSuffix.php
36. library/XenForo/Route/Interface.php
37. library/XenForo/Route/Prefix.php
38. library/XenForo/Route/Prefix/Index.php
39. library/XenForo/RouteMatch.php
40. library/XenForo/ControllerPublic/Index.php
41. library/XenForo/ControllerPublic/Abstract.php
42. library/XenForo/Controller.php
43. library/TMS/Listener/Listener.php
44. library/EWRutiles/Listener/Controller.php
45. library/Social/Listener.php
46. library/XenForo/Input.php
47. library/XenForo/Session.php
48. library/XenForo/Visitor.php
49. library/XenForo/Model/User.php
50. library/XenMoods/Listener/LoadClassModel.php
51. library/EWRutiles/Listener/Model.php
52. library/Minimalism/OnlineStatus/Plugin.php
53. library/XenMoods/XFCP/Model/User.php
54. library/XenForo/Permission.php
55. library/XenForo/Phrase.php
56. library/XenForo/Locale.php
57. library/XenForo/Model/Node.php
58. library/XenForo/NodeHandler/Category.php
59. library/XenForo/NodeHandler/Abstract.php
60. library/XenForo/NodeHandler/Forum.php
61. library/XenForo/Model/Category.php
62. library/XenForo/Model/Forum.php
63. library/XenForo/Helper/String.php
64. library/XenForo/Model/Session.php
65. library/XenForo/ControllerResponse/View.php
66. library/XenForo/ControllerResponse/Abstract.php
67. library/XenForo/Helper/Cookie.php
68. library/XenForo/ViewRenderer/HtmlPublic.php
69. library/XenForo/ViewRenderer/Abstract.php
70. library/XenForo/Template/Public.php
71. library/XenForo/Template/Abstract.php
72. library/XenMoods/Listener/FrontControllerPreView.php
73. library/XenMoods/Model/Mood.php
74. library/XenAms/Listener/FrontControllerPreView.php
75. library/XenAms/Model/ManageAdLocations.php
76. library/XenAms/Model/AdViews.php
77. library/XenForo/ViewPublic/Forum/List.php
78. library/XenForo/ViewPublic/Base.php
79. library/XenForo/View.php
80. library/XenForo/ViewPublic/Helper/Node.php
81. library/Ragtek/NPSBB/StaticMethods.php
82. library/XfRu/Infractions/EventListener/Common.php
83. library/Anonymizer/Listener/Listener.php
84. library/XenForo/Route/Prefix/Members.php
85. library/XenForo/Template/FileHandler.php
86. library/XenForo/Helper/File.php
87. internal_data/templates/S.2,L.3,forum_list.php
88. internal_data/templates/S.2,L.3,node_category_level_1.php
89. library/XenForo/Route/Prefix/Categories.php
90. internal_data/templates/S.2,L.3,node_forum_level_2.php
91. library/XenForo/Route/Prefix/Forums.php
92. library/XfRu/Birthdays/EventListener/Template.php
93. library/Minimalism/Listener.php
94. library/sape/sape/sape.php
95. e5e2a8595d4fd1f2337e6bdec5e972fe/sape.php
96. library/XfRu/Infractions/Helper/Infraction.php
97. library/XenAms/Listener/TemplateHooks.php
98. library/XenMoods/Listener/TemplateHook.php
99. library/EWRutiles/Listener/Template.php
100. library/XenForo/Route/Prefix/Posts.php
101. library/XfRu/Birthdays/Model/Birthday.php
102. library/XenForo/Helper/Criteria.php
103. library/XenForo/Debug.php
104. internal_data/templates/S.2,L.3,PAGE_CONTAINER.php
105. internal_data/templates/S.2,L.3,MinimalismExtraUserInfo.php
106. internal_data/templates/S.2,L.3,MinimalismSidebarArrow.php
107. library/Ragtek/FW/Latest.php
108. library/XenForo/Model/Post.php
109. library/EWRutiles/Model/Post.php
110. library/Minimalism/OnlineStatus/Index.php
111. library/XenForo/Model/PermissionCache.php
112. internal_data/templates/S.2,L.3,ragtek_latest_posts_sidebarblock.php
113. library/Ragtek/FW/Sidebar.php
114. library/XfRu/Infractions/Permissions.php
115. library/XenForo/ViewRenderer/Json.php
116. internal_data/templates/S.2,L.3,MinimalismSidebar_js.php
117. internal_data/templates/S.2,L.3,MinimalismNodes_js.php
118. internal_data/templates/S.2,L.3,MinimalismPoll_js.php
119. internal_data/templates/S.2,L.3,MinimalismAvatarHover_js.php
120. internal_data/templates/S.2,L.3,MinimalismMessageMeta_js.php
121. internal_data/templates/S.2,L.3,MinimalismToTop_js.php
122. internal_data/templates/S.2,L.3,anonymizer_script.php