Page Time: 0.4636s

Memory: 11.8395 MB (Peak: 14.4772 MB)

Queries (29, time: 0.3330s, 71.8%)

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.005495

   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.000709

   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 `lg_league` as `l`
   where `l`.`leagueid`=?

   Params: 79
   Run Time: 0.000633

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	l	const	PRIMARY,ix_leagueid	PRIMARY	4	const	1

4. select f.iconpath,f.feedtext,f.feeddate,f.typeid,f.gameid,f.leagueid,f.seasonid
   from lg_news_feed f
   where
   	f.leagueid=?
   	
   	and
   typeid <> 6
   order by f.feeddate desc,f.feedid desc
   limit ?

   Params: 79, 50
   Run Time: 0.312538

   Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
   SIMPLE	f	index	IX_TYPE,leagueid	ix_date	4		899	Using where

5. select username from xf_user where user_id=?

   Params: 66784
   Run Time: 0.000561

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

6. select username from xf_user where user_id=?

   Params: 27756
   Run Time: 0.000386

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

7. select username from xf_user where user_id=?

   Params: 66735
   Run Time: 0.000451

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

8. select username from xf_user where user_id=?

   Params: 65582
   Run Time: 0.000397

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

9. select username from xf_user where user_id=?

   Params: 18657
   Run Time: 0.000506

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

10. select username from xf_user where user_id=?

    Params: 66667
    Run Time: 0.000384

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

11. select username from xf_user where user_id=?

    Params: 17971
    Run Time: 0.000385

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

12. select username from xf_user where user_id=?

    Params: 66646
    Run Time: 0.000740

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

13. select username from xf_user where user_id=?

    Params: 37058
    Run Time: 0.000504

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

14. select username from xf_user where user_id=?

    Params: 43799
    Run Time: 0.000354

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

15. select username from xf_user where user_id=?

    Params: 63186
    Run Time: 0.000387

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

16. select username from xf_user where user_id=?

    Params: 59235
    Run Time: 0.000436

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

17. select username from xf_user where user_id=?

    Params: 28607
    Run Time: 0.000502

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

18. select username from xf_user where user_id=?

    Params: 38451
    Run Time: 0.000395

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

19. select username from xf_user where user_id=?

    Params: 19886
    Run Time: 0.000365

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

20. select username from xf_user where user_id=?

    Params: 51895
    Run Time: 0.000715

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

21. select username from xf_user where user_id=?

    Params: 20553
    Run Time: 0.000739

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

22. select t.teamid,t.teamname as teamname from lg_team_user as tu join lg_team as t on tu.teamid=t.teamid where tu.leagueid=? and tu.seasonid=? group by tu.teamid order by t.teamname

    Params: 79, 206
    Run Time: 0.000724

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	tu	ref	PRIMARY,leagueid,leagueid_2	PRIMARY	4	const,const	1	Using where; Using index; Using temporary; Using filesort
    SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	leaguegaming.tu.TeamID	1

23. select * from lg_news_feed_type

    Run Time: 0.000323

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	lg_news_feed_type	ALL					18

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

    Params: 29a796a92832e292d03266de77e5025f, a:8:{s:12:"sessionStart";i:1656878147;s:2:"ip";s:4:""崙";s:11:"sessionCsrf";s:16:"bIsMvjm32MtLTln6";s:9:"userAgent";s:40:"CCBot/2.0 (https://commoncrawl.org/faq/)";s:7:"robotId";s:0:"";s:16:"previousActivity";i:0;s:10:"isIpBanned";a:2:{s:6:"result";b:0;s:7:"version";i:1650286823;}s:15:"isIpDiscouraged";a:2:{s:6:"result";b:0;s:7:"version";i:1643217033;}}, 1656881747
    Run Time: 0.000800

25. 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, "崙, "崙, lg_ControllerPublic_index, League, valid, , 1656878147,
    Run Time: 0.000252

26. select * from lg_site_defaults

    Run Time: 0.000419

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	lg_site_defaults	ALL					1

27. select `l`.`forumid`,`l`.`leagueid`,`l`.`listorder`,`l`.`leaguename`,`l`.`admingroupid` as `a`,`l`.`streams` as `q`,`seasonid` as `s` ,`l`.`systemid` as `x` from `lg_league` as `l` 
    where `l`.`leagueid`=?

    Params: 79
    Run Time: 0.000714

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	l	const	PRIMARY,ix_leagueid	PRIMARY	4	const	1

28. select * from `lg_league_link` where `leagueid`=? order by levelid,`listorder`

    Params: 79
    Run Time: 0.000728

    Select Type	Table	Type	Possible Keys	Key	Key Len	Ref	Rows	Extra
    SIMPLE	lg_league_link	ref	leagueid	leagueid	1	const	16	Using index condition; Using filesort

29. SELECT title, template_compiled
    FROM xf_template_compiled
    WHERE title IN ('page_nav', 'lg_league_page', 'siropu_custom_tabs_child_list', 'resources_tab_links', 'dark_taigachat', 'dark_taigachat_list', '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', 'rellect_adblock_detector_js', 'steam_helper_criteria_privs', 'steam_navtabs', 'steam_public_index', 'PAGE_CONTAINER')
    	AND style_id = ?
    	AND language_id = ?

    Params: 2, 1
    Run Time: 0.001420

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

Included Files (101, XenForo Classes: 42)

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\Milano\SmileyManager\Listener.php
33. library\Steam\Listener.php
34. library\XenResource\Listener\Proxy.php
35. library\XenForo\Router.php
36. library\XenForo\Route\Filter.php
37. library\XenForo\Route\Interface.php
38. library\XenForo\Route\ResponseSuffix.php
39. library\XenForo\Route\Prefix.php
40. library\lg\index.php
41. C:\projects\leaguegaming\libs\smarty_init.php
42. C:\projects\leaguegaming\libs\smarty-3.1.44\libs\Smarty.class.php
43. C:\projects\leaguegaming\libs\smarty-3.1.44\libs\bootstrap.php
44. C:\projects\leaguegaming\libs\smarty-3.1.44\libs\Autoloader.php
45. C:\projects\leaguegaming\libs\smarty-3.1.44\libs\sysplugins\smarty_internal_data.php
46. C:\projects\leaguegaming\libs\smarty-3.1.44\libs\sysplugins\smarty_internal_extension_handler.php
47. C:\projects\leaguegaming\libs\smarty-3.1.44\libs\sysplugins\smarty_internal_templatebase.php
48. C:\projects\leaguegaming\libs\smarty-3.1.44\libs\sysplugins\smarty_internal_template.php
49. C:\projects\leaguegaming\libs\smarty-3.1.44\libs\sysplugins\smarty_resource.php
50. C:\projects\leaguegaming\libs\smarty-3.1.44\libs\sysplugins\smarty_variable.php
51. C:\projects\leaguegaming\libs\smarty-3.1.44\libs\sysplugins\smarty_template_source.php
52. C:\projects\leaguegaming\libs\smarty-3.1.44\libs\sysplugins\smarty_template_resource_base.php
53. C:\projects\leaguegaming\libs\smarty-3.1.44\libs\sysplugins\smarty_internal_resource_file.php
54. library\lg\Route\Prefix\index.php
55. library\lg\Listeners\listener.php
56. library\XenForo\RouteMatch.php
57. library\lg\ControllerPublic\index.php
58. library\XenForo\ControllerPublic\Abstract.php
59. library\XenForo\Controller.php
60. library\Dark\PostRating\EventListener.php
61. library\XenForo\Input.php
62. library\XenForo\Session.php
63. library\XenForo\Helper\Ip.php
64. library\XenForo\Visitor.php
65. library\XenForo\Model\User.php
66. library\Dark\TaigaChat\EventListener\Listener.php
67. library\Dark\PostRating\Model\User.php
68. library\lg\Model\xenforouser.php
69. library\XenResource\Listener\Proxy\ModelUser.php
70. library\XenForo\Permission.php
71. library\XenForo\Helper\Php.php
72. library\XenForo\Phrase.php
73. library\XenForo\Locale.php
74. library\lg\Helper\lg_league_functions.php
75. library\lg\ControllerPublic\lg_league.php
76. library\lg\Model\leaguepage.php
77. C:\projects\leaguegaming\libs\smarty-3.1.44\libs\sysplugins\smarty_template_compiled.php
78. C:\projects\leaguegaming\smarty\templates_c\c3df48f92a4480c034ccfc7bdb419eb4633de9cc_0.file.lg_league_page_team_news.tpl.php
79. C:\projects\leaguegaming\libs\smarty-3.1.44\libs\sysplugins\smarty_internal_runtime_foreach.php
80. library\XenForo\ControllerResponse\View.php
81. library\XenForo\ControllerResponse\Abstract.php
82. library\XenForo\Helper\Cookie.php
83. library\XenForo\ViewRenderer\HtmlPublic.php
84. library\XenForo\ViewRenderer\Abstract.php
85. library\XenForo\Template\Public.php
86. library\XenForo\Template\Abstract.php
87. library\UserNameHelper\Listener.php
88. library\XenForo\ViewPublic\Base.php
89. library\XenForo\View.php
90. library\rellect\AdblockDetector\Listener\Hook.php
91. library\Siropu\CustomTabs\Listener.php
92. library\XenResource\Listener\Template.php
93. library\XenForo\Route\Prefix\Members.php
94. library\Dark\TaigaChat\EventListener\NavigationTabs.php
95. library\XenForo\Route\Prefix\Forums.php
96. library\Siropu\CustomTabs\Helper.php
97. library\XenForo\Helper\Criteria.php
98. library\lg\Listeners\Navigation.php
99. library\rellect\AdblockDetector\Model\AdBlock.php
100. library\XenForo\Debug.php
101. library\XenForo\ViewRenderer\Json.php