FAQ

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1606159632,
                "last": 1606159632,
                "now": 1606159632
            },
            "token": "pj3zFnRbE5csONNAVMALz8PCdFGGupiY"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profile Information

Time

Memory

Time: 5.70 ms / 5.70 ms Memory: 0.502 MB / 0.87 MB Application: afterLoad

Time: 36.70 ms / 42.40 ms Memory: 1.442 MB / 2.31 MB Application: afterInitialise

Time: 10.95 ms / 53.34 ms Memory: 0.780 MB / 3.09 MB Application: afterRoute

Time: 0.64 ms / 53.98 ms Memory: 0.011 MB / 3.11 MB Application: beforeRenderComponent com_gantry5

Time: 0.08 ms / 54.06 ms Memory: 0.002 MB / 3.11 MB Application: afterRenderComponent com_gantry5

Time: 1.16 ms / 55.21 ms Memory: 0.021 MB / 3.13 MB Application: afterDispatch

Time: 13.53 ms / 68.75 ms Memory: 1.372 MB / 4.50 MB Application: beforeRenderModule mod_roksprocket (Exclusive News)

Time: 8.31 ms / 77.06 ms Memory: 0.352 MB / 4.85 MB Application: afterRenderModule mod_roksprocket (Exclusive News)

Time: 0.33 ms / 77.39 ms Memory: 0.000 MB / 4.83 MB Application: beforeRenderModule mod_gantry5_particle (Top Menu)

Time: 1.96 ms / 79.35 ms Memory: 0.155 MB / 4.98 MB Application: afterRenderModule mod_gantry5_particle (Top Menu)

Time: 0.60 ms / 79.95 ms Memory: 0.005 MB / 4.99 MB Application: beforeRenderModule mod_banners (Radio Banner)

Time: 3.44 ms / 83.39 ms Memory: 0.095 MB / 5.08 MB Application: afterRenderModule mod_banners (Radio Banner)

Time: 4.97 ms / 88.36 ms Memory: 0.390 MB / 5.47 MB Application: beforeRenderModule mod_gantry5_particle (Featured SubMenu Particle)

Time: 1.58 ms / 89.94 ms Memory: 0.022 MB / 5.49 MB Application: afterRenderModule mod_gantry5_particle (Featured SubMenu Particle)

Time: 2.30 ms / 92.24 ms Memory: 0.022 MB / 5.52 MB Application: beforeRenderModule mod_search (Search)

Time: 0.67 ms / 92.91 ms Memory: 0.016 MB / 5.53 MB Application: afterRenderModule mod_search (Search)

Time: 0.70 ms / 93.62 ms Memory: 0.000 MB / 5.46 MB Application: beforeRenderModule mod_gantry5_particle (More Features (Title))

Time: 0.43 ms / 94.05 ms Memory: 0.012 MB / 5.47 MB Application: afterRenderModule mod_gantry5_particle (More Features (Title))

Time: 0.22 ms / 94.26 ms Memory: 0.000 MB / 5.47 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 0.74 ms / 95.00 ms Memory: 0.014 MB / 5.48 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Time: 2.09 ms / 97.09 ms Memory: 0.006 MB / 5.49 MB Application: beforeRenderModule mod_roksprocket (FAQ Section)

Time: 5.19 ms / 102.28 ms Memory: 0.133 MB / 5.62 MB Application: afterRenderModule mod_roksprocket (FAQ Section)

Time: 4.72 ms / 107.00 ms Memory: 0.000 MB / 5.59 MB Application: beforeRenderModule mod_custom (About 365)

Time: 0.26 ms / 107.25 ms Memory: 0.006 MB / 5.60 MB Application: afterRenderModule mod_custom (About 365)

Time: 0.23 ms / 107.49 ms Memory: 0.000 MB / 5.60 MB Application: beforeRenderModule mod_gantry5_particle (Our Offices)

Time: 0.66 ms / 108.15 ms Memory: 0.018 MB / 5.62 MB Application: afterRenderModule mod_gantry5_particle (Our Offices)

Time: 0.29 ms / 108.45 ms Memory: 0.010 MB / 5.63 MB Application: beforeRenderModule mod_news_show_sp2 (Latest News)

Time: 0.89 ms / 109.33 ms Memory: 0.105 MB / 5.73 MB Application: Before Access::preloadComponents (all components)

Time: 1.04 ms / 110.37 ms Memory: 0.070 MB / 5.80 MB Application: After Access::preloadComponents (all components)

Time: 0.03 ms / 110.41 ms Memory: 0.000 MB / 5.80 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Time: 0.28 ms / 110.69 ms Memory: 0.071 MB / 5.87 MB Application: After Access::getAssetRules (id:8 name:com_content)

Time: 8.20 ms / 118.89 ms Memory: 0.295 MB / 6.17 MB Application: afterRenderModule mod_news_show_sp2 (Latest News)

Time: 0.53 ms / 119.42 ms Memory: 0.000 MB / 6.11 MB Application: beforeRenderModule mod_gantry5_particle (For Advertisement)

Time: 0.75 ms / 120.18 ms Memory: 0.017 MB / 6.12 MB Application: afterRenderModule mod_gantry5_particle (For Advertisement)

Time: 0.69 ms / 120.87 ms Memory: 0.000 MB / 6.12 MB Application: beforeRenderModule mod_gantry5_particle (Copyright (Branding))

Time: 0.40 ms / 121.27 ms Memory: 0.010 MB / 6.13 MB Application: afterRenderModule mod_gantry5_particle (Copyright (Branding))

Time: 0.23 ms / 121.50 ms Memory: 0.000 MB / 6.13 MB Application: beforeRenderModule mod_gantry5_particle (Social Icons | Footer)

Time: 0.51 ms / 122.00 ms Memory: 0.013 MB / 6.14 MB Application: afterRenderModule mod_gantry5_particle (Social Icons | Footer)

Time: 17.88 ms / 139.89 ms Memory: 0.620 MB / 6.76 MB Application: afterRender

Database queries total: 24.01 ms

Memory Usage

Database Queries

44 Queries Logged 24.01 ms

6 duplicate found!

2 duplicates: #8 #9

2 duplicates: #13 #15

2 duplicates: #24 #31

Query Time: 0.28 ms Query memory: 0.023 MB Memory before query: 1.172 MB Rows returned: 0

SELECT `data`

  FROM `yyhs1_session`

  WHERE `session_id` = 'ucleveiqccntgetu4iv72jio1e'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yyhs1_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Same as call in the line below.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.21 ms After last query: 0.32 ms Query memory: 0.020 MB Memory before query: 1.188 MB Rows returned: 0

SELECT `session_id`

  FROM `yyhs1_session`

  WHERE `session_id` = 'ucleveiqccntgetu4iv72jio1e' 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yyhs1_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.83 ms After last query: 0.09 ms Query memory: 0.004 MB Memory before query: 1.193 MB

INSERT INTO `yyhs1_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('ucleveiqccntgetu4iv72jio1e', 1, 1606159632, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `yyhs1_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('ucleveiqccntgetu4iv72jio1e', 1, 1606159632, 0, '', 0)

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
update	0.11 ms
end	0.01 ms
query end	1.54 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.52 ms After last query: 0.55 ms Query memory: 0.024 MB Memory before query: 1.291 MB Rows returned: 36

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `yyhs1_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yyhs1_extensions	NULL	ref	extension	extension	82	const	37	1.00	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.18 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.24 ms After last query: 0.48 ms Query memory: 0.021 MB Memory before query: 1.319 MB Rows returned: 5

SELECT id, rules

  FROM `yyhs1_viewlevels`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yyhs1_viewlevels	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.02 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.35 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 1.331 MB Rows returned: 2

SELECT b.id

  FROM yyhs1_usergroups AS a

  LEFT JOIN yyhs1_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 9

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where; Using index

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.05 ms After last query: 0.16 ms Query memory: 0.030 MB Memory before query: 1.353 MB Rows returned: 81

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM yyhs1_extensions

  WHERE enabled = 1 
  AND type = 'plugin' 
  AND state IN (0,1) 
  AND access IN (1,1,5)

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yyhs1_extensions	NULL	ref	extension	extension	82	const	101	0.60	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.73 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.33 ms After last query: 4.18 ms Query memory: 0.022 MB Memory before query: 1.841 MB Rows returned: 1

Duplicate queries: #9

SELECT template

  FROM yyhs1_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	5	20.00	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.22 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 1.849 MB Rows returned: 1

Duplicate queries: #8

SELECT template

  FROM yyhs1_template_styles as s

  WHERE s.client_id = 0 
  AND s.home = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_home	NO INDEX KEY COULD BE USED	NULL	NULL	5	20.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.25 ms After last query: 0.98 ms Query memory: 0.021 MB Memory before query: 1.967 MB Rows returned: 2

SELECT extension, file, type

  FROM yyhs1_rokcommon_configs

  ORDER BY priority

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yyhs1_rokcommon_configs	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	100.00	Using filesort

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:131
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.76 ms After last query: 5.78 ms Query memory: 0.026 MB Memory before query: 2.120 MB Rows returned: 18

SHOW FULL COLUMNS 
  FROM `yyhs1_extensions`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `yyhs1_extensions`

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.18 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.02 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.04 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
11	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
10	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.34 ms After last query: 0.29 ms Query memory: 0.021 MB Memory before query: 2.149 MB Rows returned: 1

SELECT `extension_id`

  FROM `yyhs1_extensions`

  WHERE type = 'component' 
  AND element = 'com_roksprocket'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yyhs1_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.09 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:47
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.25 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 2.156 MB Rows returned: 1

Duplicate queries: #15

SELECT *

  FROM yyhs1_extensions

  WHERE `extension_id` = '10017'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yyhs1_extensions	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.26 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 2.160 MB Rows returned: 1

SELECT `extension_id`

  FROM `yyhs1_extensions`

  WHERE type = 'module' 
  AND element = 'mod_roksprocket'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yyhs1_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:70
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.22 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 2.166 MB Rows returned: 1

Duplicate queries: #13

SELECT *

  FROM yyhs1_extensions

  WHERE `extension_id` = '10017'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yyhs1_extensions	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:626
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.01 ms After last query: 11.80 ms Query memory: 0.056 MB Memory before query: 2.408 MB Rows returned: 41

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM yyhs1_menu AS m

  LEFT JOIN yyhs1_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	41	10.00	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	365.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.47 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.46 ms After last query: 3.16 ms Query memory: 0.022 MB Memory before query: 2.629 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM yyhs1_template_styles as s

  LEFT JOIN yyhs1_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	5	20.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	365.s.template,const	1	4.47	Using index condition; Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/gantry5/gantry5.php:195
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1119
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.34 ms After last query: 2.16 ms Query memory: 0.026 MB Memory before query: 2.982 MB Rows returned: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `yyhs1_extensions`

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yyhs1_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.02 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
23	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
22	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
21	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
20	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
19	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
18	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
17	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
16	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
15	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
14	Joomla\CMS\Factory::getDocument()	JROOT/libraries/gantry5/classes/Gantry/Framework/Theme.php:163
13	Gantry\Framework\Theme->init()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:67
12	Gantry\Component\Theme\AbstractTheme->__construct()	JROOT/templates/it_365news/includes/theme.php:28
11	plgSystemGantry5->{closure}()	JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:118
10	Pimple\Container->offsetGet()	JROOT/plugins/system/gantry5/gantry5.php:234
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1119
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.48 ms After last query: 0.16 ms Query memory: 0.008 MB Memory before query: 2.977 MB

UPDATE `yyhs1_extensions`

  SET `params` = '{\"mediaversion\":\"e9943061e57515539dcc99720375386c\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	yyhs1_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.06 ms
updating	0.07 ms
end	0.02 ms
query end	1.18 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
18	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
17	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
16	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
15	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
14	Joomla\CMS\Factory::getDocument()	JROOT/libraries/gantry5/classes/Gantry/Framework/Theme.php:163
13	Gantry\Framework\Theme->init()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:67
12	Gantry\Component\Theme\AbstractTheme->__construct()	JROOT/templates/it_365news/includes/theme.php:28
11	plgSystemGantry5->{closure}()	JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:118
10	Pimple\Container->offsetGet()	JROOT/plugins/system/gantry5/gantry5.php:234
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1119
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.32 ms After last query: 1.06 ms Query memory: 0.023 MB Memory before query: 3.081 MB Rows returned: 1

SELECT s.id, s.template, s.home, s.title AS long_title, s.params

  FROM yyhs1_template_styles AS s

  WHERE s.client_id = 0 
  AND s.template = 'it_365news'

  ORDER BY s.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ref	idx_template	idx_template	202	const	1	20.00	Using index condition; Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry5/classes/Gantry/Joomla/StyleHelper.php:46
14	Gantry\Joomla\StyleHelper::loadStyles()	JROOT/libraries/gantry5/classes/Gantry/Framework/Assignments.php:50
13	Gantry\Framework\Assignments->loadAssignments()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:303
12	Gantry\Component\Assignments\AbstractAssignments->init()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:104
11	Gantry\Component\Assignments\AbstractAssignments->scores()	JROOT/libraries/gantry5/classes/Gantry/Component/Assignments/AbstractAssignments.php:91
10	Gantry\Component\Assignments\AbstractAssignments->select()	JROOT/plugins/system/gantry5/gantry5.php:246
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:57
8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1119
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.29 ms After last query: 0.46 ms Query memory: 0.019 MB Memory before query: 3.098 MB Rows returned: 1

SELECT *

  FROM yyhs1_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yyhs1_languages	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using filesort

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.41 ms After last query: 1.76 ms Query memory: 0.022 MB Memory before query: 3.218 MB Rows returned: 3

SELECT s.id, e.extension_id, s.template AS name, s.title, s.params

  FROM yyhs1_template_styles AS s

  LEFT JOIN yyhs1_extensions AS e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1 
  AND e.state = 0

  ORDER BY s.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	index	idx_template	PRIMARY	4	NULL	5	20.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	365.s.template,const	1	4.47	Using index condition; Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry5/classes/Gantry/Admin/ThemeList.php:142
12	Gantry\Admin\ThemeList::loadStyles()	JROOT/libraries/gantry5/classes/Gantry/Admin/ThemeList.php:70
11	Gantry\Admin\ThemeList::getStyles()	JROOT/libraries/gantry5/classes/Gantry/Framework/Outlines.php:75
10	Gantry\Framework\Outlines->load()	JROOT/libraries/gantry5/classes/Gantry/Framework/Base/Gantry.php:256
9	Gantry\Framework\Base\Gantry::Gantry\Framework\Base\{closure}()	JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:114
8	Pimple\Container->offsetGet()	JROOT/templates/it_365news/index.php:20
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.34 ms After last query: 1.04 ms Query memory: 0.023 MB Memory before query: 3.246 MB Rows returned: 1

SELECT *

  FROM yyhs1_extensions

  WHERE `type` = 'template' 
  AND `element` = 'it_365news' 
  AND `client_id` = '0'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yyhs1_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	const,const	1	10.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
13	Joomla\CMS\Table\Table->load()	JROOT/libraries/gantry5/classes/Gantry/Framework/ThemeInstaller.php:57
12	Gantry\Framework\ThemeInstaller->loadExtension()	JROOT/libraries/gantry5/classes/Gantry/Framework/ThemeInstaller.php:33
11	Gantry\Framework\ThemeInstaller->__construct()	JROOT/libraries/gantry5/classes/Gantry/Framework/Outlines.php:77
10	Gantry\Framework\Outlines->load()	JROOT/libraries/gantry5/classes/Gantry/Framework/Base/Gantry.php:256
9	Gantry\Framework\Base\Gantry::Gantry\Framework\Base\{closure}()	JROOT/libraries/gantry5/vendor/pimple/pimple/src/Pimple/Container.php:114
8	Pimple\Container->offsetGet()	JROOT/templates/it_365news/index.php:20
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.48 ms After last query: 9.28 ms Query memory: 0.055 MB Memory before query: 4.464 MB Rows returned: 14

Duplicate queries: #31

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM yyhs1_modules AS m

  LEFT JOIN yyhs1_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN yyhs1_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-11-23 19:27:12') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-11-23 19:27:12') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 137 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	55	1.60	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	365.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	365.m.id	1	40.00	Using where; Using index

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.12 ms
preparing	0.04 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.82 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
50	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
49	JDatabaseDriver->loadObjectList()	Same as call in the line below.
48	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
47	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
46	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
45	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
44	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:250
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:43
41	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/it_365news/twig/f2/f2ff36a794daa850eae0a4b3f39a4dc14eec53f06a54e68ccb960bf118b2584e.php:62
39	__TwigTemplate_aa1c7e4612c63d664400af12afc59b5e3f82876b64256d820f958384dd8f688d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
37	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:24
36	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
34	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e8/e837b0e77494fe86fa726e9b6783d40fbdd0abdae4d16f7dda121c4c579311d3.php:42
33	__TwigTemplate_7ec3f87dfad764fe14b3cd6b36f1c346dae1ce68d7cce1c63ec13b54706fa0ea->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/86/86298a263794e3099fdf5e24242a7a883541c5c213ebfb1c0892edff0f6310e2.php:36
19	__TwigTemplate_a729ec9118ca8fb878c02d183e7bcb1c96698282275674b5c4b5167e0a9d62a9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
17	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/19/19d3058543c7a55dd53d9932287a2738bd8aaae97b5a6234fe3f6bc3d904f521.php:24
16	__TwigTemplate_85b09c088f504dae6c79c5cc4b15879c63de5fbed8e647ce0b73a8ec7c0a73da->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
14	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/7c/7c44216ac0fb0865a55cd72003ff0dcd3412198ee2d47fbaa7a06558baf8e80b.php:24
13	__TwigTemplate_e1e88e6a22dc2adf95e76e8d267aa8958396aed65ea2d141d97605492463a86e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.42 ms After last query: 4.84 ms Query memory: 0.040 MB Memory before query: 4.655 MB Rows returned: 3

SELECT i.provider_id as id, i.
  order, i.params

  FROM yyhs1_roksprocket_items as i

  WHERE i.module_id = '97' 
  AND i.provider = 'simple'

  ORDER BY i.
  order

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	ref	idx_module,idx_module_order	idx_module_order	137	const	2	10.00	Using index condition; Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
58	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
57	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:37
56	RokSprocket_Provider_Simple_Storage_Joomla->getItemsFromDB()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Abstract.php:50
55	RokSprocket_Provider_Simple_Storage_Abstract->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple.php:105
54	RokSprocket_Provider_Simple->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
53	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
52	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
51	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
50	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
49	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
48	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
47	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:212
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:251
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:43
41	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/it_365news/twig/f2/f2ff36a794daa850eae0a4b3f39a4dc14eec53f06a54e68ccb960bf118b2584e.php:62
39	__TwigTemplate_aa1c7e4612c63d664400af12afc59b5e3f82876b64256d820f958384dd8f688d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
37	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:24
36	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
34	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e8/e837b0e77494fe86fa726e9b6783d40fbdd0abdae4d16f7dda121c4c579311d3.php:42
33	__TwigTemplate_7ec3f87dfad764fe14b3cd6b36f1c346dae1ce68d7cce1c63ec13b54706fa0ea->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/86/86298a263794e3099fdf5e24242a7a883541c5c213ebfb1c0892edff0f6310e2.php:36
19	__TwigTemplate_a729ec9118ca8fb878c02d183e7bcb1c96698282275674b5c4b5167e0a9d62a9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
17	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/19/19d3058543c7a55dd53d9932287a2738bd8aaae97b5a6234fe3f6bc3d904f521.php:24
16	__TwigTemplate_85b09c088f504dae6c79c5cc4b15879c63de5fbed8e647ce0b73a8ec7c0a73da->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
14	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/7c/7c44216ac0fb0865a55cd72003ff0dcd3412198ee2d47fbaa7a06558baf8e80b.php:24
13	__TwigTemplate_e1e88e6a22dc2adf95e76e8d267aa8958396aed65ea2d141d97605492463a86e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.28 ms After last query: 0.39 ms Query memory: 0.041 MB Memory before query: 4.703 MB Rows returned: 3

SELECT i.provider_id as id, i.
  order, i.params

  FROM yyhs1_roksprocket_items as i

  WHERE i.module_id = '97' 
  AND i.provider = 'simple'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	ref	idx_module,idx_module_order	idx_module	137	const	2	10.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
59	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
58	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:59
57	RokSprocket_Provider_Simple_Storage_Joomla->mapPerItemData()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:40
56	RokSprocket_Provider_Simple_Storage_Joomla->getItemsFromDB()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Abstract.php:50
55	RokSprocket_Provider_Simple_Storage_Abstract->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple.php:105
54	RokSprocket_Provider_Simple->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
53	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
52	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
51	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
50	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
49	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
48	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
47	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:212
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:251
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:43
41	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/it_365news/twig/f2/f2ff36a794daa850eae0a4b3f39a4dc14eec53f06a54e68ccb960bf118b2584e.php:62
39	__TwigTemplate_aa1c7e4612c63d664400af12afc59b5e3f82876b64256d820f958384dd8f688d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
37	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:24
36	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
34	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e8/e837b0e77494fe86fa726e9b6783d40fbdd0abdae4d16f7dda121c4c579311d3.php:42
33	__TwigTemplate_7ec3f87dfad764fe14b3cd6b36f1c346dae1ce68d7cce1c63ec13b54706fa0ea->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/86/86298a263794e3099fdf5e24242a7a883541c5c213ebfb1c0892edff0f6310e2.php:36
19	__TwigTemplate_a729ec9118ca8fb878c02d183e7bcb1c96698282275674b5c4b5167e0a9d62a9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
17	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/19/19d3058543c7a55dd53d9932287a2738bd8aaae97b5a6234fe3f6bc3d904f521.php:24
16	__TwigTemplate_85b09c088f504dae6c79c5cc4b15879c63de5fbed8e647ce0b73a8ec7c0a73da->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
14	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/7c/7c44216ac0fb0865a55cd72003ff0dcd3412198ee2d47fbaa7a06558baf8e80b.php:24
13	__TwigTemplate_e1e88e6a22dc2adf95e76e8d267aa8958396aed65ea2d141d97605492463a86e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.26 ms After last query: 4.12 ms Query memory: 0.050 MB Memory before query: 4.994 MB Rows returned: 3

SELECT a.menutype

  FROM yyhs1_menu_types AS a

  WHERE a.client_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	33.33	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
69	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
68	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_menus/helpers/menus.php:154
67	MenusHelper::getMenuTypes()	JROOT/libraries/gantry5/classes/Gantry/Framework/Menu.php:71
66	Gantry\Framework\Menu->getMenus()	JROOT/libraries/gantry5/classes/Gantry/Component/Menu/AbstractMenu.php:115
65	Gantry\Component\Menu\AbstractMenu->instance()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
64	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/be/bef64e33a485eff449c97a71a7e9c8d0058b389fdc53b93df3ae734b628f3e1b.php:20
63	__TwigTemplate_c5ee128fe6be35b3dc3fc616a910a7f44c76dbf4c718d5156a049e2095765fa0->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
62	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
61	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/0f/0f5242577f551ce3cd11de7997c81af42efcf55dba3c52a6a0052446e883ee95.php:60
60	__TwigTemplate_be9329c2f90e601fae52635e39b8797e491b5cf7e9bfa2ad8de935390c18dae2->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
59	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
58	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
57	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
56	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
55	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
54	Gantry\Framework\Theme->getContent()	JROOT/modules/mod_gantry5_particle/helper.php:115
53	ModGantry5ParticleHelper::render()	JROOT/modules/mod_gantry5_particle/helper.php:127
52	ModGantry5ParticleHelper::cache()	Same as call in the line below.
51	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
50	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:554
49	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/modules/mod_gantry5_particle/helper.php:138
48	ModGantry5ParticleHelper::moduleCache()	JROOT/modules/mod_gantry5_particle/mod_gantry5_particle.php:41
47	include JROOT/modules/mod_gantry5_particle/mod_gantry5_particle.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:212
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:251
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:43
41	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/it_365news/twig/f2/f2ff36a794daa850eae0a4b3f39a4dc14eec53f06a54e68ccb960bf118b2584e.php:62
39	__TwigTemplate_aa1c7e4612c63d664400af12afc59b5e3f82876b64256d820f958384dd8f688d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
37	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:24
36	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
34	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e8/e837b0e77494fe86fa726e9b6783d40fbdd0abdae4d16f7dda121c4c579311d3.php:42
33	__TwigTemplate_7ec3f87dfad764fe14b3cd6b36f1c346dae1ce68d7cce1c63ec13b54706fa0ea->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/86/86298a263794e3099fdf5e24242a7a883541c5c213ebfb1c0892edff0f6310e2.php:36
19	__TwigTemplate_a729ec9118ca8fb878c02d183e7bcb1c96698282275674b5c4b5167e0a9d62a9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
17	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/19/19d3058543c7a55dd53d9932287a2738bd8aaae97b5a6234fe3f6bc3d904f521.php:24
16	__TwigTemplate_85b09c088f504dae6c79c5cc4b15879c63de5fbed8e647ce0b73a8ec7c0a73da->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
14	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/7c/7c44216ac0fb0865a55cd72003ff0dcd3412198ee2d47fbaa7a06558baf8e80b.php:24
13	__TwigTemplate_e1e88e6a22dc2adf95e76e8d267aa8958396aed65ea2d141d97605492463a86e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.33 ms After last query: 1.94 ms Query memory: 0.037 MB Memory before query: 5.012 MB Rows returned: 0

SELECT *

  FROM yyhs1_banners

  WHERE '2020-11-23 19:27:12' >= 'reset' 
  AND `reset` != '0000-00-00 00:00:00' 
  AND `reset`!= NULL 
  AND (`checked_out` = 0 OR `checked_out` = 0)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
50	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
49	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_banners/helpers/banners.php:79
48	BannersHelper::updateReset()	JROOT/modules/mod_banners/mod_banners.php:19
47	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:212
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:251
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:43
41	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/it_365news/twig/f2/f2ff36a794daa850eae0a4b3f39a4dc14eec53f06a54e68ccb960bf118b2584e.php:62
39	__TwigTemplate_aa1c7e4612c63d664400af12afc59b5e3f82876b64256d820f958384dd8f688d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
37	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:24
36	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
34	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e8/e837b0e77494fe86fa726e9b6783d40fbdd0abdae4d16f7dda121c4c579311d3.php:42
33	__TwigTemplate_7ec3f87dfad764fe14b3cd6b36f1c346dae1ce68d7cce1c63ec13b54706fa0ea->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/86/86298a263794e3099fdf5e24242a7a883541c5c213ebfb1c0892edff0f6310e2.php:36
19	__TwigTemplate_a729ec9118ca8fb878c02d183e7bcb1c96698282275674b5c4b5167e0a9d62a9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
17	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/19/19d3058543c7a55dd53d9932287a2738bd8aaae97b5a6234fe3f6bc3d904f521.php:24
16	__TwigTemplate_85b09c088f504dae6c79c5cc4b15879c63de5fbed8e647ce0b73a8ec7c0a73da->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
14	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/7c/7c44216ac0fb0865a55cd72003ff0dcd3412198ee2d47fbaa7a06558baf8e80b.php:24
13	__TwigTemplate_e1e88e6a22dc2adf95e76e8d267aa8958396aed65ea2d141d97605492463a86e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.57 ms After last query: 0.51 ms Query memory: 0.039 MB Memory before query: 5.053 MB Rows returned: 1

SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions

  FROM yyhs1_banners as a

  LEFT JOIN yyhs1_banner_clients AS cl 
  ON cl.id = a.cid

  WHERE a.state=1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-11-23 19:27:12') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-11-23 19:27:12') 
  AND (a.imptotal = 0 OR a.impmade <= a.imptotal) 
  AND a.catid IN (14)

  ORDER BY a.sticky DESC,a.ordering 
  LIMIT 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_banner_catid	idx_banner_catid	4	const	1	20.00	Using index condition; Using where; Using filesort
1	SIMPLE	cl	NULL	eq_ref	PRIMARY	PRIMARY	4	365.a.cid	1	100.00	NULL

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
53	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
52	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
51	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
50	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_banners/models/banners.php:205
49	BannersModelBanners->getItems()	JROOT/modules/mod_banners/helper.php:44
48	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
47	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:212
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:251
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:43
41	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/it_365news/twig/f2/f2ff36a794daa850eae0a4b3f39a4dc14eec53f06a54e68ccb960bf118b2584e.php:62
39	__TwigTemplate_aa1c7e4612c63d664400af12afc59b5e3f82876b64256d820f958384dd8f688d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
37	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:24
36	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
34	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e8/e837b0e77494fe86fa726e9b6783d40fbdd0abdae4d16f7dda121c4c579311d3.php:42
33	__TwigTemplate_7ec3f87dfad764fe14b3cd6b36f1c346dae1ce68d7cce1c63ec13b54706fa0ea->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/86/86298a263794e3099fdf5e24242a7a883541c5c213ebfb1c0892edff0f6310e2.php:36
19	__TwigTemplate_a729ec9118ca8fb878c02d183e7bcb1c96698282275674b5c4b5167e0a9d62a9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
17	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/19/19d3058543c7a55dd53d9932287a2738bd8aaae97b5a6234fe3f6bc3d904f521.php:24
16	__TwigTemplate_85b09c088f504dae6c79c5cc4b15879c63de5fbed8e647ce0b73a8ec7c0a73da->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
14	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/7c/7c44216ac0fb0865a55cd72003ff0dcd3412198ee2d47fbaa7a06558baf8e80b.php:24
13	__TwigTemplate_e1e88e6a22dc2adf95e76e8d267aa8958396aed65ea2d141d97605492463a86e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.21 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 5.080 MB

UPDATE yyhs1_banners

  SET impmade = (impmade + 1)

  WHERE id IN (1)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	yyhs1_banners	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.03 ms
updating	0.06 ms
end	0.01 ms
query end	0.96 ms
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
50	JDatabaseDriverMysqli->execute()	JROOT/components/com_banners/models/banners.php:249
49	BannersModelBanners->impress()	JROOT/modules/mod_banners/helper.php:48
48	ModBannersHelper::getList()	JROOT/modules/mod_banners/mod_banners.php:20
47	include JROOT/modules/mod_banners/mod_banners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:212
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:251
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:43
41	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/it_365news/twig/f2/f2ff36a794daa850eae0a4b3f39a4dc14eec53f06a54e68ccb960bf118b2584e.php:62
39	__TwigTemplate_aa1c7e4612c63d664400af12afc59b5e3f82876b64256d820f958384dd8f688d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
37	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:24
36	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
34	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e8/e837b0e77494fe86fa726e9b6783d40fbdd0abdae4d16f7dda121c4c579311d3.php:42
33	__TwigTemplate_7ec3f87dfad764fe14b3cd6b36f1c346dae1ce68d7cce1c63ec13b54706fa0ea->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/86/86298a263794e3099fdf5e24242a7a883541c5c213ebfb1c0892edff0f6310e2.php:36
19	__TwigTemplate_a729ec9118ca8fb878c02d183e7bcb1c96698282275674b5c4b5167e0a9d62a9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
17	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/19/19d3058543c7a55dd53d9932287a2738bd8aaae97b5a6234fe3f6bc3d904f521.php:24
16	__TwigTemplate_85b09c088f504dae6c79c5cc4b15879c63de5fbed8e647ce0b73a8ec7c0a73da->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
14	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/7c/7c44216ac0fb0865a55cd72003ff0dcd3412198ee2d47fbaa7a06558baf8e80b.php:24
13	__TwigTemplate_e1e88e6a22dc2adf95e76e8d267aa8958396aed65ea2d141d97605492463a86e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.33 ms After last query: 3.79 ms Query memory: 0.058 MB Memory before query: 5.439 MB Rows returned: 14

Duplicate queries: #24

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM yyhs1_modules AS m

  LEFT JOIN yyhs1_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN yyhs1_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2020-11-23 19:27:12') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2020-11-23 19:27:12') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 137 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds	published	5	NULL	55	1.60	Using index condition; Using where; Using filesort
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	365.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	365.m.id	1	40.00	Using where; Using index

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.80 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
60	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
59	JDatabaseDriver->loadObjectList()	Same as call in the line below.
58	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
57	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
56	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:293
55	Gantry\Framework\Platform->getModuleList()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:286
54	Gantry\Framework\Platform->getModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:200
53	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
52	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/51/51c0410ae57867dac8e656c1005614c2f1c7acf281f8e77e5681ba32bbe6b00d.php:32
51	__TwigTemplate_75ba4b91cf0076338cbb506779186e630a627c1d3d3911288f4800689cba7f98->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
50	Twig_Template->displayBlock()	JROOT/cache/gantry5/it_365news/twig/f2/f2ff36a794daa850eae0a4b3f39a4dc14eec53f06a54e68ccb960bf118b2584e.php:62
49	__TwigTemplate_aa1c7e4612c63d664400af12afc59b5e3f82876b64256d820f958384dd8f688d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
48	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
47	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/51/51c0410ae57867dac8e656c1005614c2f1c7acf281f8e77e5681ba32bbe6b00d.php:24
46	__TwigTemplate_75ba4b91cf0076338cbb506779186e630a627c1d3d3911288f4800689cba7f98->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
45	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
44	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/be/bef64e33a485eff449c97a71a7e9c8d0058b389fdc53b93df3ae734b628f3e1b.php:148
43	__TwigTemplate_c5ee128fe6be35b3dc3fc616a910a7f44c76dbf4c718d5156a049e2095765fa0->getdisplayParticle()	JROOT/cache/gantry5/it_365news/twig/be/bef64e33a485eff449c97a71a7e9c8d0058b389fdc53b93df3ae734b628f3e1b.php:357
42	__TwigTemplate_c5ee128fe6be35b3dc3fc616a910a7f44c76dbf4c718d5156a049e2095765fa0->getdisplayItem()	JROOT/cache/gantry5/it_365news/twig/be/bef64e33a485eff449c97a71a7e9c8d0058b389fdc53b93df3ae734b628f3e1b.php:515
41	__TwigTemplate_c5ee128fe6be35b3dc3fc616a910a7f44c76dbf4c718d5156a049e2095765fa0->getdisplayItems()	JROOT/cache/gantry5/it_365news/twig/be/bef64e33a485eff449c97a71a7e9c8d0058b389fdc53b93df3ae734b628f3e1b.php:460
40	__TwigTemplate_c5ee128fe6be35b3dc3fc616a910a7f44c76dbf4c718d5156a049e2095765fa0->getdisplayContainers()	JROOT/cache/gantry5/it_365news/twig/be/bef64e33a485eff449c97a71a7e9c8d0058b389fdc53b93df3ae734b628f3e1b.php:575
39	__TwigTemplate_c5ee128fe6be35b3dc3fc616a910a7f44c76dbf4c718d5156a049e2095765fa0->getdisplaySubmenu()	JROOT/cache/gantry5/it_365news/twig/be/bef64e33a485eff449c97a71a7e9c8d0058b389fdc53b93df3ae734b628f3e1b.php:400
38	__TwigTemplate_c5ee128fe6be35b3dc3fc616a910a7f44c76dbf4c718d5156a049e2095765fa0->getdisplayItem()	JROOT/cache/gantry5/it_365news/twig/be/bef64e33a485eff449c97a71a7e9c8d0058b389fdc53b93df3ae734b628f3e1b.php:515
37	__TwigTemplate_c5ee128fe6be35b3dc3fc616a910a7f44c76dbf4c718d5156a049e2095765fa0->getdisplayItems()	JROOT/cache/gantry5/it_365news/twig/be/bef64e33a485eff449c97a71a7e9c8d0058b389fdc53b93df3ae734b628f3e1b.php:71
36	__TwigTemplate_c5ee128fe6be35b3dc3fc616a910a7f44c76dbf4c718d5156a049e2095765fa0->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
34	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/0f/0f5242577f551ce3cd11de7997c81af42efcf55dba3c52a6a0052446e883ee95.php:60
33	__TwigTemplate_be9329c2f90e601fae52635e39b8797e491b5cf7e9bfa2ad8de935390c18dae2->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/86/86298a263794e3099fdf5e24242a7a883541c5c213ebfb1c0892edff0f6310e2.php:36
19	__TwigTemplate_a729ec9118ca8fb878c02d183e7bcb1c96698282275674b5c4b5167e0a9d62a9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
17	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/19/19d3058543c7a55dd53d9932287a2738bd8aaae97b5a6234fe3f6bc3d904f521.php:24
16	__TwigTemplate_85b09c088f504dae6c79c5cc4b15879c63de5fbed8e647ce0b73a8ec7c0a73da->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
14	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/7c/7c44216ac0fb0865a55cd72003ff0dcd3412198ee2d47fbaa7a06558baf8e80b.php:24
13	__TwigTemplate_e1e88e6a22dc2adf95e76e8d267aa8958396aed65ea2d141d97605492463a86e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.66 ms After last query: 3.25 ms Query memory: 0.040 MB Memory before query: 5.472 MB Rows returned: 0

SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM yyhs1_fields AS a

  LEFT JOIN `yyhs1_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN yyhs1_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN yyhs1_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN yyhs1_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN yyhs1_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_custom.content' 
  AND a.access IN (1,1,5) 
  AND (a.group_id = 0 OR g.access IN (1,1,5)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using index condition; Using where; Using filesort
1	SIMPLE	l	NULL	eq_ref	idx_langcode	idx_langcode	28	365.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	365.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	365.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	365.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	365.a.group_id	1	100.00	Using where

Profile

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.06 ms
System lock	0.01 ms
optimizing	0.05 ms
statistics	0.10 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.04 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
57	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
56	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
55	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
54	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
53	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
52	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:478
51	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
50	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
49	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
48	JHtmlContent::prepare()	Same as call in the line below.
47	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
46	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
45	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:161
44	Gantry\Framework\Platform->filter()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
43	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/29/29702e48ebdff521c6f12247548835768bf1b9811f6beed1360c1aeb2c755576.php:31
42	__TwigTemplate_0625bfa2b44f739577ba47378c3dc7904b7257484ccf6cd36fed024257c30885->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
41	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
40	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/be/bef64e33a485eff449c97a71a7e9c8d0058b389fdc53b93df3ae734b628f3e1b.php:148
39	__TwigTemplate_c5ee128fe6be35b3dc3fc616a910a7f44c76dbf4c718d5156a049e2095765fa0->getdisplayParticle()	JROOT/cache/gantry5/it_365news/twig/be/bef64e33a485eff449c97a71a7e9c8d0058b389fdc53b93df3ae734b628f3e1b.php:357
38	__TwigTemplate_c5ee128fe6be35b3dc3fc616a910a7f44c76dbf4c718d5156a049e2095765fa0->getdisplayItem()	JROOT/cache/gantry5/it_365news/twig/be/bef64e33a485eff449c97a71a7e9c8d0058b389fdc53b93df3ae734b628f3e1b.php:515
37	__TwigTemplate_c5ee128fe6be35b3dc3fc616a910a7f44c76dbf4c718d5156a049e2095765fa0->getdisplayItems()	JROOT/cache/gantry5/it_365news/twig/be/bef64e33a485eff449c97a71a7e9c8d0058b389fdc53b93df3ae734b628f3e1b.php:71
36	__TwigTemplate_c5ee128fe6be35b3dc3fc616a910a7f44c76dbf4c718d5156a049e2095765fa0->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
34	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/0f/0f5242577f551ce3cd11de7997c81af42efcf55dba3c52a6a0052446e883ee95.php:60
33	__TwigTemplate_be9329c2f90e601fae52635e39b8797e491b5cf7e9bfa2ad8de935390c18dae2->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/86/86298a263794e3099fdf5e24242a7a883541c5c213ebfb1c0892edff0f6310e2.php:36
19	__TwigTemplate_a729ec9118ca8fb878c02d183e7bcb1c96698282275674b5c4b5167e0a9d62a9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
17	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/19/19d3058543c7a55dd53d9932287a2738bd8aaae97b5a6234fe3f6bc3d904f521.php:24
16	__TwigTemplate_85b09c088f504dae6c79c5cc4b15879c63de5fbed8e647ce0b73a8ec7c0a73da->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
14	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/7c/7c44216ac0fb0865a55cd72003ff0dcd3412198ee2d47fbaa7a06558baf8e80b.php:24
13	__TwigTemplate_e1e88e6a22dc2adf95e76e8d267aa8958396aed65ea2d141d97605492463a86e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.48 ms After last query: 7.33 ms Query memory: 0.042 MB Memory before query: 5.523 MB Rows returned: 5

SELECT i.provider_id as id, i.
  order, i.params

  FROM yyhs1_roksprocket_items as i

  WHERE i.module_id = '139' 
  AND i.provider = 'simple'

  ORDER BY i.
  order

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	ref	idx_module,idx_module_order	idx_module_order	137	const	5	10.00	Using index condition; Using where

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
58	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
57	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:37
56	RokSprocket_Provider_Simple_Storage_Joomla->getItemsFromDB()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Abstract.php:50
55	RokSprocket_Provider_Simple_Storage_Abstract->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple.php:105
54	RokSprocket_Provider_Simple->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
53	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
52	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
51	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
50	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
49	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
48	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
47	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:212
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:251
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:43
41	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/it_365news/twig/f2/f2ff36a794daa850eae0a4b3f39a4dc14eec53f06a54e68ccb960bf118b2584e.php:62
39	__TwigTemplate_aa1c7e4612c63d664400af12afc59b5e3f82876b64256d820f958384dd8f688d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
37	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:24
36	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
34	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e8/e837b0e77494fe86fa726e9b6783d40fbdd0abdae4d16f7dda121c4c579311d3.php:42
33	__TwigTemplate_7ec3f87dfad764fe14b3cd6b36f1c346dae1ce68d7cce1c63ec13b54706fa0ea->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/86/86298a263794e3099fdf5e24242a7a883541c5c213ebfb1c0892edff0f6310e2.php:36
19	__TwigTemplate_a729ec9118ca8fb878c02d183e7bcb1c96698282275674b5c4b5167e0a9d62a9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
17	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/19/19d3058543c7a55dd53d9932287a2738bd8aaae97b5a6234fe3f6bc3d904f521.php:24
16	__TwigTemplate_85b09c088f504dae6c79c5cc4b15879c63de5fbed8e647ce0b73a8ec7c0a73da->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
14	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/7c/7c44216ac0fb0865a55cd72003ff0dcd3412198ee2d47fbaa7a06558baf8e80b.php:24
13	__TwigTemplate_e1e88e6a22dc2adf95e76e8d267aa8958396aed65ea2d141d97605492463a86e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.32 ms After last query: 0.21 ms Query memory: 0.041 MB Memory before query: 5.568 MB Rows returned: 5

SELECT i.provider_id as id, i.
  order, i.params

  FROM yyhs1_roksprocket_items as i

  WHERE i.module_id = '139' 
  AND i.provider = 'simple'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	i	NULL	ref	idx_module,idx_module_order	idx_module	137	const	5	10.00	Using where

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.06 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
59	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
58	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:59
57	RokSprocket_Provider_Simple_Storage_Joomla->mapPerItemData()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Joomla.php:40
56	RokSprocket_Provider_Simple_Storage_Joomla->getItemsFromDB()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple/Storage/Abstract.php:50
55	RokSprocket_Provider_Simple_Storage_Abstract->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Simple.php:105
54	RokSprocket_Provider_Simple->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
53	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
52	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
51	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
50	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
49	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
48	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
47	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:212
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:251
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:43
41	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/it_365news/twig/f2/f2ff36a794daa850eae0a4b3f39a4dc14eec53f06a54e68ccb960bf118b2584e.php:62
39	__TwigTemplate_aa1c7e4612c63d664400af12afc59b5e3f82876b64256d820f958384dd8f688d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
37	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:24
36	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
34	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e8/e837b0e77494fe86fa726e9b6783d40fbdd0abdae4d16f7dda121c4c579311d3.php:42
33	__TwigTemplate_7ec3f87dfad764fe14b3cd6b36f1c346dae1ce68d7cce1c63ec13b54706fa0ea->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/86/86298a263794e3099fdf5e24242a7a883541c5c213ebfb1c0892edff0f6310e2.php:36
19	__TwigTemplate_a729ec9118ca8fb878c02d183e7bcb1c96698282275674b5c4b5167e0a9d62a9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
17	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/19/19d3058543c7a55dd53d9932287a2738bd8aaae97b5a6234fe3f6bc3d904f521.php:24
16	__TwigTemplate_85b09c088f504dae6c79c5cc4b15879c63de5fbed8e647ce0b73a8ec7c0a73da->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
14	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/7c/7c44216ac0fb0865a55cd72003ff0dcd3412198ee2d47fbaa7a06558baf8e80b.php:24
13	__TwigTemplate_e1e88e6a22dc2adf95e76e8d267aa8958396aed65ea2d141d97605492463a86e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.81 ms After last query: 8.99 ms Query memory: 0.044 MB Memory before query: 5.736 MB Rows returned: 36

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `yyhs1_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_gantry5','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_roksprocket','com_search','com_tags','com_templates','com_users','com_wrapper')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yyhs1_assets	NULL	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	152	24.34	Using where

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.14 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.33 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
59	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
58	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
57	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
56	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
55	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
54	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
53	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:442
52	ContentModelArticles->getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:133
51	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT/libraries/src/MVC/Model/ListModel.php:187
50	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
49	ContentModelArticles->getItems()	JROOT/modules/mod_news_show_sp2/helper.php:98
48	modNSSP2JHelper::getList()	JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php:148
47	include JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:212
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:251
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:43
41	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/it_365news/twig/f2/f2ff36a794daa850eae0a4b3f39a4dc14eec53f06a54e68ccb960bf118b2584e.php:62
39	__TwigTemplate_aa1c7e4612c63d664400af12afc59b5e3f82876b64256d820f958384dd8f688d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
37	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:24
36	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
34	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e8/e837b0e77494fe86fa726e9b6783d40fbdd0abdae4d16f7dda121c4c579311d3.php:42
33	__TwigTemplate_7ec3f87dfad764fe14b3cd6b36f1c346dae1ce68d7cce1c63ec13b54706fa0ea->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/86/86298a263794e3099fdf5e24242a7a883541c5c213ebfb1c0892edff0f6310e2.php:36
19	__TwigTemplate_a729ec9118ca8fb878c02d183e7bcb1c96698282275674b5c4b5167e0a9d62a9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
17	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/19/19d3058543c7a55dd53d9932287a2738bd8aaae97b5a6234fe3f6bc3d904f521.php:24
16	__TwigTemplate_85b09c088f504dae6c79c5cc4b15879c63de5fbed8e647ce0b73a8ec7c0a73da->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
14	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/7c/7c44216ac0fb0865a55cd72003ff0dcd3412198ee2d47fbaa7a06558baf8e80b.php:24
13	__TwigTemplate_e1e88e6a22dc2adf95e76e8d267aa8958396aed65ea2d141d97605492463a86e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.05 ms After last query: 0.51 ms Query memory: 0.057 MB Memory before query: 5.870 MB Rows returned: 4

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM yyhs1_content AS a

  LEFT JOIN yyhs1_categories AS c 
  ON c.id = a.catid

  LEFT JOIN yyhs1_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN yyhs1_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN yyhs1_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN yyhs1_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid IN (12) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2020-11-23 19:27:12') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2020-11-23 19:27:12')

  ORDER BY a.created ASC 
  LIMIT 4

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	5	16.00	Using index condition; Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	365.a.created_by	1	100.00	Using where
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	365.a.modified_by	1	100.00	Using where
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	365.a.id	1	100.00	Using where

Profile

Status	Duration
starting	0.21 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.10 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.15 ms
preparing	0.04 ms
Sorting result	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.23 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
53	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
52	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
51	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
50	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
49	ContentModelArticles->getItems()	JROOT/modules/mod_news_show_sp2/helper.php:98
48	modNSSP2JHelper::getList()	JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php:148
47	include JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:212
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:251
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:43
41	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/it_365news/twig/f2/f2ff36a794daa850eae0a4b3f39a4dc14eec53f06a54e68ccb960bf118b2584e.php:62
39	__TwigTemplate_aa1c7e4612c63d664400af12afc59b5e3f82876b64256d820f958384dd8f688d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
37	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:24
36	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
34	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e8/e837b0e77494fe86fa726e9b6783d40fbdd0abdae4d16f7dda121c4c579311d3.php:42
33	__TwigTemplate_7ec3f87dfad764fe14b3cd6b36f1c346dae1ce68d7cce1c63ec13b54706fa0ea->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/86/86298a263794e3099fdf5e24242a7a883541c5c213ebfb1c0892edff0f6310e2.php:36
19	__TwigTemplate_a729ec9118ca8fb878c02d183e7bcb1c96698282275674b5c4b5167e0a9d62a9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
17	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/19/19d3058543c7a55dd53d9932287a2738bd8aaae97b5a6234fe3f6bc3d904f521.php:24
16	__TwigTemplate_85b09c088f504dae6c79c5cc4b15879c63de5fbed8e647ce0b73a8ec7c0a73da->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
14	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/7c/7c44216ac0fb0865a55cd72003ff0dcd3412198ee2d47fbaa7a06558baf8e80b.php:24
13	__TwigTemplate_e1e88e6a22dc2adf95e76e8d267aa8958396aed65ea2d141d97605492463a86e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.40 ms After last query: 0.46 ms Query memory: 0.038 MB Memory before query: 5.932 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `yyhs1_contentitem_tag_map` AS m 

  INNER JOIN `yyhs1_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 1 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	365.m.tag_id	1	100.00	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.07 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
52	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
51	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
50	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
49	ContentModelArticles->getItems()	JROOT/modules/mod_news_show_sp2/helper.php:98
48	modNSSP2JHelper::getList()	JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php:148
47	include JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:212
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:251
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:43
41	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/it_365news/twig/f2/f2ff36a794daa850eae0a4b3f39a4dc14eec53f06a54e68ccb960bf118b2584e.php:62
39	__TwigTemplate_aa1c7e4612c63d664400af12afc59b5e3f82876b64256d820f958384dd8f688d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
37	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:24
36	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
34	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e8/e837b0e77494fe86fa726e9b6783d40fbdd0abdae4d16f7dda121c4c579311d3.php:42
33	__TwigTemplate_7ec3f87dfad764fe14b3cd6b36f1c346dae1ce68d7cce1c63ec13b54706fa0ea->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/86/86298a263794e3099fdf5e24242a7a883541c5c213ebfb1c0892edff0f6310e2.php:36
19	__TwigTemplate_a729ec9118ca8fb878c02d183e7bcb1c96698282275674b5c4b5167e0a9d62a9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
17	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/19/19d3058543c7a55dd53d9932287a2738bd8aaae97b5a6234fe3f6bc3d904f521.php:24
16	__TwigTemplate_85b09c088f504dae6c79c5cc4b15879c63de5fbed8e647ce0b73a8ec7c0a73da->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
14	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/7c/7c44216ac0fb0865a55cd72003ff0dcd3412198ee2d47fbaa7a06558baf8e80b.php:24
13	__TwigTemplate_e1e88e6a22dc2adf95e76e8d267aa8958396aed65ea2d141d97605492463a86e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.32 ms After last query: 0.18 ms Query memory: 0.038 MB Memory before query: 5.955 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `yyhs1_contentitem_tag_map` AS m 

  INNER JOIN `yyhs1_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 2 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	365.m.tag_id	1	100.00	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
52	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
51	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
50	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
49	ContentModelArticles->getItems()	JROOT/modules/mod_news_show_sp2/helper.php:98
48	modNSSP2JHelper::getList()	JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php:148
47	include JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:212
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:251
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:43
41	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/it_365news/twig/f2/f2ff36a794daa850eae0a4b3f39a4dc14eec53f06a54e68ccb960bf118b2584e.php:62
39	__TwigTemplate_aa1c7e4612c63d664400af12afc59b5e3f82876b64256d820f958384dd8f688d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
37	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:24
36	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
34	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e8/e837b0e77494fe86fa726e9b6783d40fbdd0abdae4d16f7dda121c4c579311d3.php:42
33	__TwigTemplate_7ec3f87dfad764fe14b3cd6b36f1c346dae1ce68d7cce1c63ec13b54706fa0ea->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/86/86298a263794e3099fdf5e24242a7a883541c5c213ebfb1c0892edff0f6310e2.php:36
19	__TwigTemplate_a729ec9118ca8fb878c02d183e7bcb1c96698282275674b5c4b5167e0a9d62a9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
17	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/19/19d3058543c7a55dd53d9932287a2738bd8aaae97b5a6234fe3f6bc3d904f521.php:24
16	__TwigTemplate_85b09c088f504dae6c79c5cc4b15879c63de5fbed8e647ce0b73a8ec7c0a73da->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
14	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/7c/7c44216ac0fb0865a55cd72003ff0dcd3412198ee2d47fbaa7a06558baf8e80b.php:24
13	__TwigTemplate_e1e88e6a22dc2adf95e76e8d267aa8958396aed65ea2d141d97605492463a86e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.33 ms After last query: 0.17 ms Query memory: 0.038 MB Memory before query: 5.979 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `yyhs1_contentitem_tag_map` AS m 

  INNER JOIN `yyhs1_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 3 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	365.m.tag_id	1	100.00	Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
52	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
51	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
50	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
49	ContentModelArticles->getItems()	JROOT/modules/mod_news_show_sp2/helper.php:98
48	modNSSP2JHelper::getList()	JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php:148
47	include JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:212
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:251
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:43
41	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/it_365news/twig/f2/f2ff36a794daa850eae0a4b3f39a4dc14eec53f06a54e68ccb960bf118b2584e.php:62
39	__TwigTemplate_aa1c7e4612c63d664400af12afc59b5e3f82876b64256d820f958384dd8f688d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
37	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:24
36	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
34	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e8/e837b0e77494fe86fa726e9b6783d40fbdd0abdae4d16f7dda121c4c579311d3.php:42
33	__TwigTemplate_7ec3f87dfad764fe14b3cd6b36f1c346dae1ce68d7cce1c63ec13b54706fa0ea->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/86/86298a263794e3099fdf5e24242a7a883541c5c213ebfb1c0892edff0f6310e2.php:36
19	__TwigTemplate_a729ec9118ca8fb878c02d183e7bcb1c96698282275674b5c4b5167e0a9d62a9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
17	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/19/19d3058543c7a55dd53d9932287a2738bd8aaae97b5a6234fe3f6bc3d904f521.php:24
16	__TwigTemplate_85b09c088f504dae6c79c5cc4b15879c63de5fbed8e647ce0b73a8ec7c0a73da->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
14	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/7c/7c44216ac0fb0865a55cd72003ff0dcd3412198ee2d47fbaa7a06558baf8e80b.php:24
13	__TwigTemplate_e1e88e6a22dc2adf95e76e8d267aa8958396aed65ea2d141d97605492463a86e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.32 ms After last query: 0.19 ms Query memory: 0.038 MB Memory before query: 6.003 MB Rows returned: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `yyhs1_contentitem_tag_map` AS m 

  INNER JOIN `yyhs1_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 4 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	365.m.tag_id	1	100.00	Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
52	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
51	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
50	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
49	ContentModelArticles->getItems()	JROOT/modules/mod_news_show_sp2/helper.php:98
48	modNSSP2JHelper::getList()	JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php:148
47	include JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:212
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:251
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:43
41	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/it_365news/twig/f2/f2ff36a794daa850eae0a4b3f39a4dc14eec53f06a54e68ccb960bf118b2584e.php:62
39	__TwigTemplate_aa1c7e4612c63d664400af12afc59b5e3f82876b64256d820f958384dd8f688d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
37	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:24
36	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
34	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e8/e837b0e77494fe86fa726e9b6783d40fbdd0abdae4d16f7dda121c4c579311d3.php:42
33	__TwigTemplate_7ec3f87dfad764fe14b3cd6b36f1c346dae1ce68d7cce1c63ec13b54706fa0ea->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/86/86298a263794e3099fdf5e24242a7a883541c5c213ebfb1c0892edff0f6310e2.php:36
19	__TwigTemplate_a729ec9118ca8fb878c02d183e7bcb1c96698282275674b5c4b5167e0a9d62a9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
17	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/19/19d3058543c7a55dd53d9932287a2738bd8aaae97b5a6234fe3f6bc3d904f521.php:24
16	__TwigTemplate_85b09c088f504dae6c79c5cc4b15879c63de5fbed8e647ce0b73a8ec7c0a73da->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
14	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/7c/7c44216ac0fb0865a55cd72003ff0dcd3412198ee2d47fbaa7a06558baf8e80b.php:24
13	__TwigTemplate_e1e88e6a22dc2adf95e76e8d267aa8958396aed65ea2d141d97605492463a86e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.60 ms After last query: 0.26 ms Query memory: 0.044 MB Memory before query: 6.026 MB Rows returned: 16

SHOW FULL COLUMNS 
  FROM `yyhs1_users`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `yyhs1_users`

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.15 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Opening tables	0.01 ms
checking permissions	0.03 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.03 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
60	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
59	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
58	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
57	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
56	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:40
55	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
54	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
53	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:880
52	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
51	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
50	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
49	Joomla\CMS\Factory::getUser()	JROOT/modules/mod_news_show_sp2/helper.php:103
48	modNSSP2JHelper::getList()	JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php:148
47	include JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:212
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:251
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:43
41	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/it_365news/twig/f2/f2ff36a794daa850eae0a4b3f39a4dc14eec53f06a54e68ccb960bf118b2584e.php:62
39	__TwigTemplate_aa1c7e4612c63d664400af12afc59b5e3f82876b64256d820f958384dd8f688d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
37	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:24
36	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
34	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e8/e837b0e77494fe86fa726e9b6783d40fbdd0abdae4d16f7dda121c4c579311d3.php:42
33	__TwigTemplate_7ec3f87dfad764fe14b3cd6b36f1c346dae1ce68d7cce1c63ec13b54706fa0ea->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/86/86298a263794e3099fdf5e24242a7a883541c5c213ebfb1c0892edff0f6310e2.php:36
19	__TwigTemplate_a729ec9118ca8fb878c02d183e7bcb1c96698282275674b5c4b5167e0a9d62a9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
17	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/19/19d3058543c7a55dd53d9932287a2738bd8aaae97b5a6234fe3f6bc3d904f521.php:24
16	__TwigTemplate_85b09c088f504dae6c79c5cc4b15879c63de5fbed8e647ce0b73a8ec7c0a73da->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
14	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/7c/7c44216ac0fb0865a55cd72003ff0dcd3412198ee2d47fbaa7a06558baf8e80b.php:24
13	__TwigTemplate_e1e88e6a22dc2adf95e76e8d267aa8958396aed65ea2d141d97605492463a86e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.24 ms After last query: 0.14 ms Query memory: 0.039 MB Memory before query: 6.070 MB Rows returned: 1

SELECT *

  FROM `yyhs1_users`

  WHERE `id` = 380

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	yyhs1_users	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
55	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
54	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:86
53	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
52	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
51	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
50	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
49	Joomla\CMS\Factory::getUser()	JROOT/modules/mod_news_show_sp2/helper.php:103
48	modNSSP2JHelper::getList()	JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php:148
47	include JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:212
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:251
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:43
41	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/it_365news/twig/f2/f2ff36a794daa850eae0a4b3f39a4dc14eec53f06a54e68ccb960bf118b2584e.php:62
39	__TwigTemplate_aa1c7e4612c63d664400af12afc59b5e3f82876b64256d820f958384dd8f688d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
37	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:24
36	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
34	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e8/e837b0e77494fe86fa726e9b6783d40fbdd0abdae4d16f7dda121c4c579311d3.php:42
33	__TwigTemplate_7ec3f87dfad764fe14b3cd6b36f1c346dae1ce68d7cce1c63ec13b54706fa0ea->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/86/86298a263794e3099fdf5e24242a7a883541c5c213ebfb1c0892edff0f6310e2.php:36
19	__TwigTemplate_a729ec9118ca8fb878c02d183e7bcb1c96698282275674b5c4b5167e0a9d62a9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
17	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/19/19d3058543c7a55dd53d9932287a2738bd8aaae97b5a6234fe3f6bc3d904f521.php:24
16	__TwigTemplate_85b09c088f504dae6c79c5cc4b15879c63de5fbed8e647ce0b73a8ec7c0a73da->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
14	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/7c/7c44216ac0fb0865a55cd72003ff0dcd3412198ee2d47fbaa7a06558baf8e80b.php:24
13	__TwigTemplate_e1e88e6a22dc2adf95e76e8d267aa8958396aed65ea2d141d97605492463a86e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.27 ms After last query: 0.32 ms Query memory: 0.039 MB Memory before query: 6.098 MB Rows returned: 1

SELECT `g`.`id`,`g`.`title`

  FROM `yyhs1_usergroups` AS g

  INNER JOIN `yyhs1_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 380

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY	PRIMARY	4	const	1	100.00	Using index
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	365.m.group_id	1	100.00	NULL

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
55	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
54	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:111
53	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
52	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
51	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
50	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
49	Joomla\CMS\Factory::getUser()	JROOT/modules/mod_news_show_sp2/helper.php:103
48	modNSSP2JHelper::getList()	JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php:148
47	include JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:212
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:251
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:43
41	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/it_365news/twig/f2/f2ff36a794daa850eae0a4b3f39a4dc14eec53f06a54e68ccb960bf118b2584e.php:62
39	__TwigTemplate_aa1c7e4612c63d664400af12afc59b5e3f82876b64256d820f958384dd8f688d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
37	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:24
36	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
34	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e8/e837b0e77494fe86fa726e9b6783d40fbdd0abdae4d16f7dda121c4c579311d3.php:42
33	__TwigTemplate_7ec3f87dfad764fe14b3cd6b36f1c346dae1ce68d7cce1c63ec13b54706fa0ea->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/86/86298a263794e3099fdf5e24242a7a883541c5c213ebfb1c0892edff0f6310e2.php:36
19	__TwigTemplate_a729ec9118ca8fb878c02d183e7bcb1c96698282275674b5c4b5167e0a9d62a9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
17	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/19/19d3058543c7a55dd53d9932287a2738bd8aaae97b5a6234fe3f6bc3d904f521.php:24
16	__TwigTemplate_85b09c088f504dae6c79c5cc4b15879c63de5fbed8e647ce0b73a8ec7c0a73da->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
14	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/7c/7c44216ac0fb0865a55cd72003ff0dcd3412198ee2d47fbaa7a06558baf8e80b.php:24
13	__TwigTemplate_e1e88e6a22dc2adf95e76e8d267aa8958396aed65ea2d141d97605492463a86e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.56 ms After last query: 0.48 ms Query memory: 0.042 MB Memory before query: 6.128 MB Rows returned: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `yyhs1_categories` AS `s`

  INNER JOIN `yyhs1_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 12

  ORDER BY c.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	Using filesort
1	SIMPLE	c	NULL	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	18	33.95	Using where

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.05 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.11 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
62	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
61	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
60	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
59	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
58	ContentRouter->getCategorySegment()	Same as call in the line below.
57	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
56	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
55	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
54	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
53	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
52	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
51	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:102
50	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:52
49	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_news_show_sp2/helper.php:108
48	modNSSP2JHelper::getList()	JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php:148
47	include JROOT/modules/mod_news_show_sp2/mod_news_show_sp2.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
46	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
45	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:212
44	Gantry\Framework\Platform->displayModule()	JROOT/libraries/gantry5/classes/Gantry/Framework/Platform.php:251
43	Gantry\Framework\Platform->displayModules()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:679
42	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:43
41	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->block_particle()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:215
40	Twig_Template->displayBlock()	JROOT/cache/gantry5/it_365news/twig/f2/f2ff36a794daa850eae0a4b3f39a4dc14eec53f06a54e68ccb960bf118b2584e.php:62
39	__TwigTemplate_aa1c7e4612c63d664400af12afc59b5e3f82876b64256d820f958384dd8f688d->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
38	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
37	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e9/e9c5e33c9202a39e1219682cf2a07ea26a0192247a889624365d3e25111cb68e.php:24
36	__TwigTemplate_6901570f07c556cb80cd944adc8962e50aa71bdaa6b220c6ff71e0194762f573->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
35	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
34	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/e8/e837b0e77494fe86fa726e9b6783d40fbdd0abdae4d16f7dda121c4c579311d3.php:42
33	__TwigTemplate_7ec3f87dfad764fe14b3cd6b36f1c346dae1ce68d7cce1c63ec13b54706fa0ea->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
32	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
31	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
30	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
29	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
28	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:766
27	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:666
26	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:593
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:579
22	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/ThemeTrait.php:422
21	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:677
20	Twig_Template->getAttribute()	JROOT/cache/gantry5/it_365news/twig/86/86298a263794e3099fdf5e24242a7a883541c5c213ebfb1c0892edff0f6310e2.php:36
19	__TwigTemplate_a729ec9118ca8fb878c02d183e7bcb1c96698282275674b5c4b5167e0a9d62a9->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
18	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
17	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/19/19d3058543c7a55dd53d9932287a2738bd8aaae97b5a6234fe3f6bc3d904f521.php:24
16	__TwigTemplate_85b09c088f504dae6c79c5cc4b15879c63de5fbed8e647ce0b73a8ec7c0a73da->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
15	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
14	Twig_Template->display()	JROOT/cache/gantry5/it_365news/twig/7c/7c44216ac0fb0865a55cd72003ff0dcd3412198ee2d47fbaa7a06558baf8e80b.php:24
13	__TwigTemplate_e1e88e6a22dc2adf95e76e8d267aa8958396aed65ea2d141d97605492463a86e->doDisplay()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:432
12	Twig_Template->displayWithErrorHandling()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:403
11	Twig_Template->display()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Template.php:411
10	Twig_Template->render()	JROOT/libraries/gantry5/vendor/twig/twig/lib/Twig/Environment.php:363
9	Twig_Environment->render()	JROOT/libraries/gantry5/classes/Gantry/Component/Theme/AbstractTheme.php:163
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/it_365news/index.php:28
7	require JROOT/templates/it_365news/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

32 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

4 × SELECT i.provider_id as id, i.
  order, i.params 
  FROM yyhs1_roksprocket_items as i

4 × SELECT `m`.`tag_id`,`t`.* 
  FROM `yyhs1_contentitem_tag_map` AS m  
  INNER JOIN `yyhs1_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

```
3 × SELECT * 
  FROM yyhs1_extensions
```

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `yyhs1_extensions`

2 × SELECT template 
  FROM yyhs1_template_styles as s

2 × SELECT `extension_id` 
  FROM `yyhs1_extensions`

2 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM yyhs1_modules AS m 
  LEFT JOIN yyhs1_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN yyhs1_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT `data` 
  FROM `yyhs1_session`

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `yyhs1_usergroups` AS g 
  INNER JOIN `yyhs1_user_usergroup_map` AS m 
  ON m.group_id = g.id

```
1 × SELECT * 
  FROM `yyhs1_users`
```

1 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM yyhs1_content AS a 
  LEFT JOIN yyhs1_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN yyhs1_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN yyhs1_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN yyhs1_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN yyhs1_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `yyhs1_assets`

1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM yyhs1_fields AS a 
  LEFT JOIN `yyhs1_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN yyhs1_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN yyhs1_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN yyhs1_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN yyhs1_fields_groups AS g 
  ON g.id = a.group_id

1 × SELECT a.id as id,a.type as type,a.name as name,a.clickurl as clickurl,a.cid as cid,a.description as description,a.params as params,a.custombannercode as custombannercode,a.track_impressions as track_impressions,cl.track_impressions as client_track_impressions 
  FROM yyhs1_banners as a 
  LEFT JOIN yyhs1_banner_clients AS cl 
  ON cl.id = a.cid

```
1 × SELECT * 
  FROM yyhs1_banners
```

1 × SELECT a.menutype 
  FROM yyhs1_menu_types AS a

```
1 × SELECT * 
  FROM yyhs1_languages
```

1 × SELECT s.id, e.extension_id, s.template AS name, s.title, s.params 
  FROM yyhs1_template_styles AS s 
  LEFT JOIN yyhs1_extensions AS e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT `session_id` 
  FROM `yyhs1_session`

1 × SELECT s.id, s.template, s.home, s.title AS long_title, s.params 
  FROM yyhs1_template_styles AS s

1 × SELECT id, home, template, s.params 
  FROM yyhs1_template_styles as s 
  LEFT JOIN yyhs1_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM yyhs1_menu AS m 
  LEFT JOIN yyhs1_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT extension, file, type 
  FROM yyhs1_rokcommon_configs

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM yyhs1_extensions

1 × SELECT b.id 
  FROM yyhs1_usergroups AS a 
  LEFT JOIN yyhs1_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT id, rules 
  FROM `yyhs1_viewlevels

1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `yyhs1_categories` AS `s` 
  INNER JOIN `yyhs1_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

OTHER Tables:

1 × INSERT INTO `yyhs1_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('ucleveiqccntgetu4iv72jio1e', 1, 1606159632, 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `yyhs1_extensions

1 × UPDATE `yyhs1_extensions` 
  SET `params` = '{\"mediaversion\":\"e9943061e57515539dcc99720375386c\"}'

1 × UPDATE yyhs1_banners 
  SET impmade = (impmade + 1)

1 × SHOW FULL COLUMNS 
  FROM `yyhs1_users

World

Technology

Sport

Travel

More Features, Please!

How to advertise on 365News? +

How to contact the editor for reply? +

How to register in 365News +

How to subscribe to the Latest News section? +

Can I write news for 365News site? +

About 365

Our Offices

Latest News

How far can we go?

Produce energy easy...

Capture everything w...

Everything Smart: wa...

Big Reach

Very Flexible

Banner Ads

Video Ads

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

44 Queries Logged 24.01 ms

6 duplicate found!

32 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: