headernew2013

P171742 ADELE Stakeholder Engagement Plan (SEP) January 8, 2021

: Hits: 6

P171742 ADELE Stakeholder Engagement Plan (SEP) January 8, 2021

P171742 ADELE Labor Management Procedure January 8, 2021

: Hits: 7

P171742 ADELE Labor Management Procedure January 8, 2021

P171742 ADELE DBE and MoWIE Risk Assess ESAP and ToR Januray 08 2021

: Hits: 6

P171742 ADELE DBE and MoWIE Risk Assess ESAP and ToR Januray 08 2021

P171742 ADELE DRAFT Environmental and Social Commitment Plan (ESCP) EEU MoWIE and DBE January 8, 2021

: Hits: 8

P171742 ADELE DRAFT Environmental and Social Commitment Plan (ESCP) EEU MoWIE and DBE January 8, 2021

P171742 ADELE Stakeholder Engagement Plan (SEP)-EEU January 8, 2021

: Hits: 8

P171742 ADELE Stakeholder Engagement Plan (SEP)-EEU January 8, 2021

Contact Us

Media Center

Electrical Tips

CUSTOMER CARE

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1611602596,
                "last": 1611602596,
                "now": 1611602596
            },
            "token": "7LtMB1Z9YU0AxnrimEQQyA8UR48he7wY"
        },
        "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: 48.35 ms / 48.35 ms Memory: 1.371 MB / 1.49 MB Application: afterLoad

Time: 191.51 ms / 239.86 ms Memory: 4.787 MB / 6.28 MB Application: afterInitialise

Time: 33.90 ms / 273.76 ms Memory: 0.637 MB / 6.91 MB Application: afterRoute

Time: 3.10 ms / 276.85 ms Memory: 0.032 MB / 6.94 MB Application: beforeRenderComponent com_content

Time: 25.45 ms / 302.30 ms Memory: 0.765 MB / 7.71 MB Application: Before Access::preloadComponents (all components)

Time: 2.54 ms / 304.84 ms Memory: 0.052 MB / 7.76 MB Application: After Access::preloadComponents (all components)

Time: 0.12 ms / 304.96 ms Memory: 0.000 MB / 7.76 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Time: 1.90 ms / 306.85 ms Memory: 0.032 MB / 7.79 MB Application: After Access::getAssetRules (id:8 name:com_content)

Time: 199.13 ms / 505.98 ms Memory: 1.839 MB / 9.63 MB Application: afterRenderComponent com_content

Time: 10.66 ms / 516.64 ms Memory: 0.101 MB / 9.73 MB Application: afterDispatch

Time: 93.78 ms / 610.42 ms Memory: 0.966 MB / 10.70 MB Application: beforeRenderModule mod_menu (Main Menu)

Time: 19.49 ms / 629.91 ms Memory: 0.165 MB / 10.86 MB Application: afterRenderModule mod_menu (Main Menu)

Time: 0.15 ms / 630.07 ms Memory: 0.000 MB / 10.86 MB Application: beforeRenderModule mod_search (Search)

Time: 3.76 ms / 633.83 ms Memory: 0.017 MB / 10.88 MB Application: afterRenderModule mod_search (Search)

Time: 0.13 ms / 633.96 ms Memory: 0.000 MB / 10.87 MB Application: beforeRenderModule mod_ultimatefacebooklikeboxslider (Ultimate Facebook Like Box Slider)

Time: 2.34 ms / 636.31 ms Memory: 0.018 MB / 10.89 MB Application: afterRenderModule mod_ultimatefacebooklikeboxslider (Ultimate Facebook Like Box Slider)

Time: 0.32 ms / 636.62 ms Memory: 0.001 MB / 10.89 MB Application: beforeRenderModule mod_menu (CUSTOMER CARE)

Time: 10.27 ms / 646.89 ms Memory: 0.056 MB / 10.94 MB Application: afterRenderModule mod_menu (CUSTOMER CARE)

Time: 0.24 ms / 647.13 ms Memory: 0.000 MB / 10.94 MB Application: beforeRenderModule mod_menu (Electrical Tips)

Time: 5.06 ms / 652.19 ms Memory: 0.028 MB / 10.97 MB Application: afterRenderModule mod_menu (Electrical Tips)

Time: 0.24 ms / 652.43 ms Memory: 0.000 MB / 10.97 MB Application: beforeRenderModule mod_menu (Media Center)

Time: 9.10 ms / 661.53 ms Memory: 0.057 MB / 11.02 MB Application: afterRenderModule mod_menu (Media Center)

Time: 0.24 ms / 661.77 ms Memory: 0.000 MB / 11.02 MB Application: beforeRenderModule mod_menu (Contact Us )

Time: 7.75 ms / 669.52 ms Memory: 0.050 MB / 11.07 MB Application: afterRenderModule mod_menu (Contact Us )

Time: 0.24 ms / 669.75 ms Memory: 0.000 MB / 11.07 MB Application: beforeRenderModule mod_custom (Apply for Job)

Time: 2.80 ms / 672.56 ms Memory: 0.007 MB / 11.07 MB Application: afterRenderModule mod_custom (Apply for Job)

Time: 0.13 ms / 672.69 ms Memory: 0.000 MB / 11.07 MB Application: beforeRenderModule mod_custom (ERP Links)

Time: 1.73 ms / 674.42 ms Memory: 0.005 MB / 11.08 MB Application: afterRenderModule mod_custom (ERP Links)

Time: 0.13 ms / 674.55 ms Memory: 0.000 MB / 11.07 MB Application: beforeRenderModule mod_custom (Careers@EEU)

Time: 1.80 ms / 676.34 ms Memory: 0.005 MB / 11.08 MB Application: afterRenderModule mod_custom (Careers@EEU)

Time: 0.13 ms / 676.47 ms Memory: 0.000 MB / 11.08 MB Application: beforeRenderModule mod_custom (Emergency operation free call center)

Time: 1.73 ms / 678.20 ms Memory: 0.005 MB / 11.08 MB Application: afterRenderModule mod_custom (Emergency operation free call center)

Time: 0.14 ms / 678.33 ms Memory: 0.000 MB / 11.08 MB Application: beforeRenderModule mod_menu (CUSTOMER CARE)

Time: 8.13 ms / 686.46 ms Memory: 0.008 MB / 11.09 MB Application: afterRenderModule mod_menu (CUSTOMER CARE)

Time: 0.15 ms / 686.61 ms Memory: 0.000 MB / 11.09 MB Application: beforeRenderModule mod_articles_popular (Most Read Posts)

Time: 14.40 ms / 701.01 ms Memory: 0.107 MB / 11.19 MB Application: afterRenderModule mod_articles_popular (Most Read Posts)

Time: 0.23 ms / 701.24 ms Memory: 0.000 MB / 11.13 MB Application: beforeRenderModule mod_articles_archive (Archived Articles)

Time: 5.41 ms / 706.65 ms Memory: 0.035 MB / 11.16 MB Application: afterRenderModule mod_articles_archive (Archived Articles)

Time: 0.17 ms / 706.82 ms Memory: 0.000 MB / 11.16 MB Application: beforeRenderModule mod_jevents_cal (Calendar)

Time: 46.39 ms / 753.21 ms Memory: 1.094 MB / 12.26 MB Application: Before Access::getAssetRules (id:102 name:com_jevents)

Time: 0.20 ms / 753.41 ms Memory: 0.005 MB / 12.26 MB Application: After Access::getAssetRules (id:102 name:com_jevents)

Time: 69.65 ms / 823.06 ms Memory: 1.172 MB / 13.43 MB Application: afterRenderModule mod_jevents_cal (Calendar)

Time: 0.46 ms / 823.51 ms Memory: 0.014 MB / 13.45 MB Application: beforeRenderModule mod_slideshowck (Slideshow CK)

Time: 27.77 ms / 851.28 ms Memory: 0.298 MB / 13.75 MB Application: afterRenderModule mod_slideshowck (Slideshow CK)

Time: 0.28 ms / 851.55 ms Memory: 0.000 MB / 13.72 MB Application: beforeRenderModule mod_custom (Header)

Time: 1.76 ms / 853.32 ms Memory: 0.005 MB / 13.72 MB Application: afterRenderModule mod_custom (Header)

Time: 16.19 ms / 869.51 ms Memory: 0.162 MB / 13.89 MB Application: afterRender

Database queries total: 92.31 ms

Memory Usage

Database Queries

26 Queries Logged 92.31 ms

Query Time: 0.58 ms Query memory: 0.013 MB Memory before query: 3.220 MB Rows returned: 0

SELECT `data`

  FROM `pnu4z_session`

  WHERE `session_id` = 't48mc6bekq5kttid6ggnumga01'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pnu4z_session	const	PRIMARY	PRIMARY	766	const	1

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.25 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1730
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:854
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:133
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:451
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.34 ms After last query: 3.97 ms Query memory: 0.008 MB Memory before query: 3.338 MB Rows returned: 0

SELECT `session_id`

  FROM `pnu4z_session`

  WHERE `session_id` = 't48mc6bekq5kttid6ggnumga01' 
  LIMIT 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pnu4z_session	const	PRIMARY	PRIMARY	766	const	1	Using index

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1730
7	JDatabaseDriver->loadResult()	JROOT\libraries\src\Application\CMSApplication.php:214
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT\libraries\src\Application\CMSApplication.php:856
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:133
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:451
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.62 ms After last query: 0.37 ms Query memory: 0.005 MB Memory before query: 3.347 MB

INSERT INTO `pnu4z_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('t48mc6bekq5kttid6ggnumga01', 1, '1611602596', 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `pnu4z_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('t48mc6bekq5kttid6ggnumga01', 1, '1611602596', 0, '', 0)

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
update	0.27 ms
end	0.01 ms
query end	1.11 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT\libraries\src\Application\CMSApplication.php:254
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT\libraries\src\Application\CMSApplication.php:856
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT\libraries\src\Application\CMSApplication.php:133
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:451
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.83 ms After last query: 8.68 ms Query memory: 0.018 MB Memory before query: 3.608 MB Rows returned: 36

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

  FROM `pnu4z_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pnu4z_extensions	ref	extension	extension	82	const	36	Using index condition

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.41 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
11	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Component\ComponentHelper.php:423
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:431
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT\libraries\src\Component\ComponentHelper.php:497
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:596
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:303
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.36 ms After last query: 7.65 ms Query memory: 0.009 MB Memory before query: 3.844 MB Rows returned: 5

SELECT id, rules

  FROM `pnu4z_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1496
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:310
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:606
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:303
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.45 ms After last query: 0.38 ms Query memory: 0.010 MB Memory before query: 3.860 MB Rows returned: 2

SELECT b.id

  FROM pnu4z_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1540
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:310
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:606
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:303
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.58 ms After last query: 1.93 ms Query memory: 0.011 MB Memory before query: 3.932 MB Rows returned: 79

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

  FROM pnu4z_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pnu4z_extensions	ref	extension	extension	82	const	97	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.01 ms
Sorting result	0.65 ms
Sending data	0.31 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
10	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Plugin\PluginHelper.php:343
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:348
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:606
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:303
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: 2.51 ms After last query: 28.37 ms Query memory: 0.031 MB Memory before query: 4.822 MB Rows returned: 69

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 pnu4z_menu AS m

  LEFT JOIN pnu4z_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	99	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	eeuprjoom.m.component_id	1	Using where

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.04 ms
executing	0.01 ms
Sorting result	0.55 ms
Sending data	1.46 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
29	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Menu\SiteMenu.php:93
28	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
27	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
26	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Menu\SiteMenu.php:101
25	Joomla\CMS\Menu\SiteMenu->load()	JROOT\libraries\src\Menu\AbstractMenu.php:76
24	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT\libraries\src\Menu\SiteMenu.php:62
23	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT\libraries\src\Menu\AbstractMenu.php:131
22	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT\libraries\src\Application\CMSApplication.php:482
21	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT\libraries\src\Application\SiteApplication.php:275
20	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT\libraries\src\Application\SiteApplication.php:436
19	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT\libraries\src\HTML\HTMLHelper.php:365
18	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT\libraries\src\HTML\HTMLHelper.php:712
17	Joomla\CMS\HTML\HTMLHelper::script()	Same as call in the line below.
16	call_user_func_array()	JROOT\libraries\src\HTML\HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT\libraries\src\HTML\HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT\libraries\cms\html\jquery.php:52
13	JHtmlJquery::framework()	Same as call in the line below.
12	call_user_func_array()	JROOT\libraries\src\HTML\HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT\libraries\src\HTML\HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT\plugins\system\helixultimate\platform\options.php:17
9	require_once JROOT\plugins\system\helixultimate\platform\options.php	JROOT\plugins\system\helixultimate\platform\platform.php:13
8	require_once JROOT\plugins\system\helixultimate\platform\platform.php	JROOT\plugins\system\helixultimate\helixultimate.php:15
7	require_once JROOT\plugins\system\helixultimate\helixultimate.php	JROOT\libraries\src\Plugin\PluginHelper.php:253
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:721
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:688
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:303
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.72 ms After last query: 5.41 ms Query memory: 0.028 MB Memory before query: 5.147 MB Rows returned: 4

SELECT id, home, template, s.params

  FROM pnu4z_template_styles as s

  LEFT JOIN pnu4z_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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	5	Using index condition; Using where
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.06 ms
executing	0.01 ms
Sending data	0.21 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Application\SiteApplication.php:488
19	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT\libraries\src\HTML\HTMLHelper.php:365
18	Joomla\CMS\HTML\HTMLHelper::includeRelativeFiles()	JROOT\libraries\src\HTML\HTMLHelper.php:712
17	Joomla\CMS\HTML\HTMLHelper::script()	Same as call in the line below.
16	call_user_func_array()	JROOT\libraries\src\HTML\HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT\libraries\src\HTML\HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT\libraries\cms\html\jquery.php:52
13	JHtmlJquery::framework()	Same as call in the line below.
12	call_user_func_array()	JROOT\libraries\src\HTML\HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT\libraries\src\HTML\HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT\plugins\system\helixultimate\platform\options.php:17
9	require_once JROOT\plugins\system\helixultimate\platform\options.php	JROOT\plugins\system\helixultimate\platform\platform.php:13
8	require_once JROOT\plugins\system\helixultimate\platform\platform.php	JROOT\plugins\system\helixultimate\helixultimate.php:15
7	require_once JROOT\plugins\system\helixultimate\helixultimate.php	JROOT\libraries\src\Plugin\PluginHelper.php:253
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:721
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:688
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:303
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.52 ms After last query: 4.47 ms Query memory: 0.022 MB Memory before query: 5.219 MB Rows returned: 1

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

  FROM `pnu4z_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pnu4z_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.10 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
28	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1652
27	JDatabaseDriver->loadObject()	JROOT\libraries\src\Helper\LibraryHelper.php:167
26	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
25	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
24	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Helper\LibraryHelper.php:175
23	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT\libraries\src\Helper\LibraryHelper.php:43
22	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT\libraries\src\Helper\LibraryHelper.php:90
21	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT\libraries\src\Version.php:321
20	Joomla\CMS\Version->getMediaVersion()	JROOT\libraries\src\Factory.php:778
19	Joomla\CMS\Factory::createDocument()	JROOT\libraries\src\Factory.php:234
18	Joomla\CMS\Factory::getDocument()	JROOT\libraries\src\HTML\HTMLHelper.php:731
17	Joomla\CMS\HTML\HTMLHelper::script()	Same as call in the line below.
16	call_user_func_array()	JROOT\libraries\src\HTML\HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT\libraries\src\HTML\HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT\libraries\cms\html\jquery.php:52
13	JHtmlJquery::framework()	Same as call in the line below.
12	call_user_func_array()	JROOT\libraries\src\HTML\HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT\libraries\src\HTML\HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT\plugins\system\helixultimate\platform\options.php:17
9	require_once JROOT\plugins\system\helixultimate\platform\options.php	JROOT\plugins\system\helixultimate\platform\platform.php:13
8	require_once JROOT\plugins\system\helixultimate\platform\platform.php	JROOT\plugins\system\helixultimate\helixultimate.php:15
7	require_once JROOT\plugins\system\helixultimate\helixultimate.php	JROOT\libraries\src\Plugin\PluginHelper.php:253
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:721
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:688
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:303
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: 2.02 ms After last query: 0.59 ms Query memory: 0.016 MB Memory before query: 5.223 MB

UPDATE `pnu4z_extensions`

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

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

Explain

EXPLAIN not possible on query: UPDATE `pnu4z_extensions` SET `params` = '{\"mediaversion\":\"a9dd77621ccd3925c1c807a19e1a4a6a\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.11 ms
updating	0.27 ms
end	0.02 ms
query end	1.40 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT\libraries\src\Helper\LibraryHelper.php:117
22	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT\libraries\src\Version.php:372
21	Joomla\CMS\Version->setMediaVersion()	JROOT\libraries\src\Version.php:331
20	Joomla\CMS\Version->getMediaVersion()	JROOT\libraries\src\Factory.php:778
19	Joomla\CMS\Factory::createDocument()	JROOT\libraries\src\Factory.php:234
18	Joomla\CMS\Factory::getDocument()	JROOT\libraries\src\HTML\HTMLHelper.php:731
17	Joomla\CMS\HTML\HTMLHelper::script()	Same as call in the line below.
16	call_user_func_array()	JROOT\libraries\src\HTML\HTMLHelper.php:239
15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT\libraries\src\HTML\HTMLHelper.php:146
14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT\libraries\cms\html\jquery.php:52
13	JHtmlJquery::framework()	Same as call in the line below.
12	call_user_func_array()	JROOT\libraries\src\HTML\HTMLHelper.php:239
11	Joomla\CMS\HTML\HTMLHelper::call()	JROOT\libraries\src\HTML\HTMLHelper.php:146
10	Joomla\CMS\HTML\HTMLHelper::_()	JROOT\plugins\system\helixultimate\platform\options.php:17
9	require_once JROOT\plugins\system\helixultimate\platform\options.php	JROOT\plugins\system\helixultimate\platform\platform.php:13
8	require_once JROOT\plugins\system\helixultimate\platform\platform.php	JROOT\plugins\system\helixultimate\helixultimate.php:15
7	require_once JROOT\plugins\system\helixultimate\helixultimate.php	JROOT\libraries\src\Plugin\PluginHelper.php:253
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:721
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT\libraries\src\Application\SiteApplication.php:688
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:303
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: 99.72 ms Query memory: 0.009 MB Memory before query: 6.925 MB Rows returned: 1

SELECT *

  FROM pnu4z_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.01 ms
Sorting result	0.05 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
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:303
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.54 ms After last query: 27.89 ms Query memory: 0.018 MB Memory before query: 7.714 MB Rows returned: 34

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

  FROM `pnu4z_assets`

  WHERE `name` IN ('root.1','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_fsf','com_installer','com_jce','com_jevents','com_joomlaupdate','com_jsecurelite','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pnu4z_assets	range	idx_asset_name	idx_asset_name	202	NULL	37	Using index condition

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.11 ms
optimizing	0.02 ms
statistics	0.27 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.73 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
20	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Access\Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT\libraries\src\Access\Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT\libraries\src\Access\Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT\libraries\src\Access\Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT\libraries\src\User\User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT\components\com_content\models\articles.php:114
14	ContentModelArticles->populateState()	JROOT\components\com_content\models\featured.php:44
13	ContentModelFeatured->populateState()	JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:435
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT\libraries\src\MVC\View\HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT\components\com_content\views\featured\view.html.php:54
10	ContentViewFeatured->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
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:303
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: 54.35 ms After last query: 6.40 ms Query memory: 0.023 MB Memory before query: 7.855 MB Rows returned: 9

SELECT DISTINCT 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

  FROM pnu4z_content AS a

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

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

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

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

  WHERE a.featured = 1 
  AND a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-25 19:23:16') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-25 19:23:16')

  ORDER BY c.lft,  
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
  LIMIT 9

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ALL	PRIMARY,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	53	Using where; Using temporary; Using filesort
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_featured_catid	idx_featured_catid	5	const,eeuprjoom.c.id	3	Using index condition; Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	eeuprjoom.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	eeuprjoom.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	eeuprjoom.c.parent_id	1	Using where

Profile

Status	Duration
starting	0.24 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.11 ms
optimizing	0.06 ms
statistics	0.15 ms
preparing	0.10 ms
executing	0.01 ms
Creating tmp table	1.33 ms
Copying to tmp table	49.17 ms
Sorting result	1.14 ms
Sending data	0.40 ms
end	0.01 ms
removing tmp table	1.35 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
16	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:308
15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT\libraries\src\MVC\Model\ListModel.php:187
14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT\components\com_content\models\articles.php:558
13	ContentModelArticles->getItems()	JROOT\components\com_content\models\featured.php:125
12	ContentModelFeatured->getItems()	JROOT\libraries\src\MVC\View\HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT\components\com_content\views\featured\view.html.php:55
10	ContentViewFeatured->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
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:303
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: 4.15 ms After last query: 9.45 ms Query memory: 0.013 MB Memory before query: 8.198 MB Rows returned: 1

SELECT COUNT(*)

  FROM pnu4z_content AS a

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

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

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

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

  WHERE a.featured = 1 
  AND a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-25 19:23:16') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-25 19:23:16')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ALL	PRIMARY,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	53	Using where
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid,idx_featured_catid	idx_featured_catid	5	const,eeuprjoom.c.id	3	Using index condition; Using where

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.05 ms
statistics	0.15 ms
preparing	0.01 ms
Unlocking tables	0.08 ms
executing	0.01 ms
Sending data	3.40 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1730
15	JDatabaseDriver->loadResult()	JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:335
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT\libraries\src\MVC\Model\ListModel.php:282
13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT\libraries\src\MVC\Model\ListModel.php:232
12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT\libraries\src\MVC\View\HtmlView.php:423
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT\components\com_content\views\featured\view.html.php:56
10	ContentViewFeatured->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
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:303
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.08 ms After last query: 23.33 ms Query memory: 0.022 MB Memory before query: 8.747 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 `pnu4z_categories` AS `s`

  INNER JOIN `pnu4z_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 = 9

  ORDER BY c.lft

Explain

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

Profile

Status	Duration
starting	0.14 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.07 ms
optimizing	0.04 ms
statistics	0.19 ms
preparing	0.01 ms
Unlocking tables	0.04 ms
executing	0.01 ms
Sorting result	0.17 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
21	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Categories\Categories.php:314
20	Joomla\CMS\Categories\Categories->_load()	JROOT\libraries\src\Categories\Categories.php:186
19	Joomla\CMS\Categories\Categories->get()	JROOT\administrator\components\com_fields\models\fields.php:197
18	FieldsModelFields->getListQuery()	JROOT\libraries\src\MVC\Model\ListModel.php:133
17	Joomla\CMS\MVC\Model\ListModel->_getListQuery()	JROOT\libraries\src\MVC\Model\ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT\administrator\components\com_fields\helpers\fields.php:136
15	FieldsHelper::getFields()	JROOT\plugins\system\fields\fields.php:427
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
12	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT\components\com_content\views\featured\view.html.php:98
10	ContentViewFeatured->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
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:303
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.94 ms After last query: 2.06 ms Query memory: 0.021 MB Memory before query: 8.812 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

  FROM pnu4z_fields AS a

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

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

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

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

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

  LEFT JOIN `pnu4z_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (9,0)) 
  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	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	eeuprjoom.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	eeuprjoom.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	eeuprjoom.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	eeuprjoom.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	eeuprjoom.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	eeuprjoom.a.id	1	Using where; Using index

Profile

Status	Duration
starting	0.17 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.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.08 ms
optimizing	0.05 ms
statistics	0.11 ms
preparing	0.08 ms
executing	0.01 ms
Sorting result	0.04 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
19	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT\administrator\components\com_fields\models\fields.php:327
17	FieldsModelFields->_getList()	JROOT\libraries\src\MVC\Model\ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT\administrator\components\com_fields\helpers\fields.php:136
15	FieldsHelper::getFields()	JROOT\plugins\system\fields\fields.php:427
14	PlgSystemFields->onContentPrepare()	Same as call in the line below.
13	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
12	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT\components\com_content\views\featured\view.html.php:98
10	ContentViewFeatured->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT\components\com_content\controller.php:113
8	ContentController->display()	JROOT\libraries\src\MVC\Controller\BaseController.php:710
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT\components\com_content\content.php:43
6	require_once JROOT\components\com_content\content.php	JROOT\libraries\src\Component\ComponentHelper.php:382
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT\libraries\src\Component\ComponentHelper.php:357
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT\libraries\src\Application\SiteApplication.php:194
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:303
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: 2.36 ms After last query: 101.84 ms Query memory: 0.014 MB Memory before query: 9.662 MB Rows returned: 6

SHOW FULL COLUMNS 
  FROM `pnu4z_template_styles`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	1.20 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.06 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
closing tables	0.01 ms
executing	0.01 ms
Sending data	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.51 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
14	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:430
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\administrator\components\com_templates\tables\style.php:30
10	TemplatesTableStyle->__construct()	JROOT\libraries\src\Table\Table.php:312
9	Joomla\CMS\Table\Table::getInstance()	JROOT\plugins\system\helixultimate\helixultimate.php:41
8	plgSystemHelixultimate->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\SiteApplication.php:199
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:303
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.47 ms After last query: 2.53 ms Query memory: 0.010 MB Memory before query: 9.702 MB Rows returned: 1

SELECT *

  FROM pnu4z_template_styles

  WHERE `id` = '9'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pnu4z_template_styles	const	PRIMARY	PRIMARY	4	const	1

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.02 ms
executing	0.01 ms
Sending data	0.11 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1455
10	JDatabaseDriver->loadAssoc()	JROOT\libraries\src\Table\Table.php:731
9	Joomla\CMS\Table\Table->load()	JROOT\plugins\system\helixultimate\helixultimate.php:42
8	plgSystemHelixultimate->onAfterDispatch()	Same as call in the line below.
7	call_user_func_array()	JROOT\libraries\joomla\event\event.php:70
6	JEvent->update()	JROOT\libraries\joomla\event\dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT\libraries\src\Application\BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT\libraries\src\Application\SiteApplication.php:199
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:303
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.98 ms After last query: 63.00 ms Query memory: 0.017 MB Memory before query: 10.642 MB Rows returned: 28

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

  FROM pnu4z_modules AS m

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

  LEFT JOIN pnu4z_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 <= '2021-01-25 19:23:16') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-01-25 19:23:16') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 101 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	36	Using index condition; Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	eeuprjoom.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	eeuprjoom.m.module,const	1	Using index condition; Using where

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.05 ms
statistics	0.11 ms
preparing	0.08 ms
executing	0.01 ms
Sorting result	0.35 ms
Sending data	0.98 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
18	JDatabaseDriver->loadObjectList()	Same as call in the line below.
17	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Helper\ModuleHelper.php:433
15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT\libraries\src\Helper\ModuleHelper.php:363
14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT\libraries\src\Helper\ModuleHelper.php:87
13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT\libraries\src\Document\HtmlDocument.php:581
12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT\plugins\system\helixultimate\core\helixultimate.php:562
11	HelixUltimate->count_modules()	JROOT\plugins\system\helixultimate\core\helixultimate.php:370
10	HelixUltimate->get_current_row()	JROOT\plugins\system\helixultimate\core\helixultimate.php:304
9	HelixUltimate->get_recursive_layout()	JROOT\plugins\system\helixultimate\core\helixultimate.php:272
8	HelixUltimate->render_layout()	JROOT\templates\shaper_helixultimate\index.php:120
7	require JROOT\templates\shaper_helixultimate\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:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:309
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: 6.91 ms After last query: 112.08 ms Query memory: 0.021 MB Memory before query: 11.141 MB Rows returned: 3

SELECT DISTINCT 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

  FROM pnu4z_content AS a

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

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

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

  LEFT JOIN pnu4z_categories as parent 
  ON parent.id = c.parent_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 (8,9) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-01-25 19:23:16') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-01-25 19:23:16') 
  AND a.created >= DATE_SUB('2021-01-25 19:23:16', INTERVAL 30 DAY)

  ORDER BY a.hits DESC 
  LIMIT 3

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	ALL	PRIMARY,idx_access	NO INDEX KEY COULD BE USED	NULL	NULL	53	Using where; Using temporary; Using filesort
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	eeuprjoom.c.id	4	Using index condition; Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	eeuprjoom.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	eeuprjoom.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	eeuprjoom.c.parent_id	1	Using where

Profile

Status	Duration
starting	0.24 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.12 ms
optimizing	0.06 ms
statistics	0.16 ms
preparing	0.10 ms
executing	0.01 ms
Creating tmp table	1.26 ms
Copying to tmp table	3.65 ms
Sorting result	0.08 ms
Sending data	0.32 ms
end	0.01 ms
removing tmp table	0.59 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
15	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\MVC\Model\BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT\libraries\src\MVC\Model\ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT\components\com_content\models\articles.php:558
12	ContentModelArticles->getItems()	JROOT\modules\mod_articles_popular\helper.php:76
11	ModArticlesPopularHelper::getList()	JROOT\modules\mod_articles_popular\mod_articles_popular.php:15
10	include JROOT\modules\mod_articles_popular\mod_articles_popular.php	JROOT\libraries\src\Helper\ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:309
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: 6.72 ms Query memory: 0.012 MB Memory before query: 11.168 MB Rows returned: 1

SELECT MONTH(`created`) AS created_month,MIN(`created`) AS created,YEAR(`created`) AS created_year

  FROM pnu4z_content

  WHERE state = 2

  GROUP BY YEAR(`created`), MONTH(`created`)

  ORDER BY YEAR(`created`) DESC, MONTH(`created`) DESC 
  LIMIT 10

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	pnu4z_content	ref	idx_state	idx_state	1	const	5	Using where; Using temporary; Using filesort

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.01 ms
Creating tmp table	0.03 ms
Copying to tmp table	0.06 ms
Sorting result	0.02 ms
Sending data	0.02 ms
end	0.01 ms
removing tmp table	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
12	JDatabaseDriver->loadObjectList()	JROOT\modules\mod_articles_archive\helper.php:51
11	ModArchiveHelper::getList()	JROOT\modules\mod_articles_archive\mod_articles_archive.php:17
10	include JROOT\modules\mod_articles_archive\mod_articles_archive.php	JROOT\libraries\src\Helper\ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:309
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: 2.63 ms After last query: 75.46 ms Query memory: 0.023 MB Memory before query: 13.115 MB Rows returned: 18

SHOW FULL COLUMNS 
  FROM `pnu4z_jev_users`

Explain

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

Profile

Status	Duration
starting	0.03 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	1.14 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.06 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
closing tables	0.01 ms
executing	0.01 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.50 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
25	JDatabaseDriver->loadObjectList()	JROOT\libraries\joomla\database\driver\mysqli.php:430
24	JDatabaseDriverMysqli->getTableColumns()	JROOT\libraries\src\Table\Table.php:245
23	Joomla\CMS\Table\Table->getFields()	JROOT\libraries\src\Table\Table.php:164
22	Joomla\CMS\Table\Table->__construct()	JROOT\administrator\components\com_jevents\tables\jevuser.php:69
21	TableUser->__construct()	JROOT\components\com_jevents\libraries\helper.php:2308
20	JEVHelper::getAuthorisedUser()	JROOT\components\com_jevents\libraries\helper.php:1201
19	JEVHelper::isEventCreator()	JROOT\components\com_jevents\libraries\filters\Published.php:50
18	jevPublishedFilter->__construct()	JROOT\components\com_jevents\libraries\filters.php:142
17	jevFilterProcessing->__construct()	JROOT\components\com_jevents\libraries\filters.php:200
16	jevFilterProcessing::getInstance()	JROOT\components\com_jevents\libraries\dbmodel.php:2323
15	JEventsDBModel->listIcalEvents()	JROOT\components\com_jevents\libraries\dbmodel.php:2698
14	JEventsDBModel->listIcalEventsByMonth()	JROOT\components\com_jevents\libraries\datamodel.php:243
13	JEventsDataModel->getCalendarData()	JROOT\modules\mod_jevents_cal\tmpl\flat\calendar.php:78
12	FlatModCalView->_displayCalendarMod()	JROOT\modules\mod_jevents_cal\tmpl\default\calendar.php:487
11	DefaultModCalView->getCal()	JROOT\modules\mod_jevents_cal\mod_jevents_cal.php:46
10	include JROOT\modules\mod_jevents_cal\mod_jevents_cal.php	JROOT\libraries\src\Helper\ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:309
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.89 ms After last query: 9.67 ms Query memory: 0.025 MB Memory before query: 13.285 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 `pnu4z_categories` AS `c`

  WHERE (c.extension='com_jevents' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	range	cat_idx,idx_access	cat_idx	207	NULL	4	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.13 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.06 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.04 ms
executing	0.01 ms
Sorting result	0.11 ms
Sending data	0.09 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
24	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Categories\Categories.php:314
23	Joomla\CMS\Categories\Categories->_load()	JROOT\components\com_jevents\helpers\category.php:47
22	JEventsCategories->_load()	JROOT\libraries\src\Categories\Categories.php:186
21	Joomla\CMS\Categories\Categories->get()	JROOT\components\com_jevents\libraries\dbmodel.php:90
20	JEventsDBModel->accessibleCategoryList()	JROOT\components\com_jevents\libraries\datamodel.php:886
19	JEventsDataModel->accessibleCategoryList()	JROOT\components\com_jevents\libraries\filters\Category.php:39
18	jevCategoryFilter->__construct()	JROOT\components\com_jevents\libraries\filters.php:142
17	jevFilterProcessing->__construct()	JROOT\components\com_jevents\libraries\filters.php:200
16	jevFilterProcessing::getInstance()	JROOT\components\com_jevents\libraries\dbmodel.php:2323
15	JEventsDBModel->listIcalEvents()	JROOT\components\com_jevents\libraries\dbmodel.php:2698
14	JEventsDBModel->listIcalEventsByMonth()	JROOT\components\com_jevents\libraries\datamodel.php:243
13	JEventsDataModel->getCalendarData()	JROOT\modules\mod_jevents_cal\tmpl\flat\calendar.php:78
12	FlatModCalView->_displayCalendarMod()	JROOT\modules\mod_jevents_cal\tmpl\default\calendar.php:487
11	DefaultModCalView->getCal()	JROOT\modules\mod_jevents_cal\mod_jevents_cal.php:46
10	include JROOT\modules\mod_jevents_cal\mod_jevents_cal.php	JROOT\libraries\src\Helper\ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:309
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.19 ms After last query: 0.78 ms Query memory: 0.018 MB Memory before query: 13.313 MB Rows returned: 1

SELECT c.id

  FROM pnu4z_categories AS c

  WHERE c.access   IN (1,1,5)
 
  AND c.published = 1
  
  AND c.language in ('en-GB','*')
 
  AND c.extension = 'com_jevents'
 

  ORDER BY c.lft asc

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	range	cat_idx,idx_access,idx_language	cat_idx	207	NULL	2	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.71 ms
preparing	0.04 ms
executing	0.01 ms
Sorting result	0.08 ms
Sending data	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1540
21	JDatabaseDriver->loadColumn()	JROOT\components\com_jevents\libraries\dbmodel.php:172
20	JEventsDBModel->accessibleCategoryList()	JROOT\components\com_jevents\libraries\datamodel.php:886
19	JEventsDataModel->accessibleCategoryList()	JROOT\components\com_jevents\libraries\filters\Category.php:39
18	jevCategoryFilter->__construct()	JROOT\components\com_jevents\libraries\filters.php:142
17	jevFilterProcessing->__construct()	JROOT\components\com_jevents\libraries\filters.php:200
16	jevFilterProcessing::getInstance()	JROOT\components\com_jevents\libraries\dbmodel.php:2323
15	JEventsDBModel->listIcalEvents()	JROOT\components\com_jevents\libraries\dbmodel.php:2698
14	JEventsDBModel->listIcalEventsByMonth()	JROOT\components\com_jevents\libraries\datamodel.php:243
13	JEventsDataModel->getCalendarData()	JROOT\modules\mod_jevents_cal\tmpl\flat\calendar.php:78
12	FlatModCalView->_displayCalendarMod()	JROOT\modules\mod_jevents_cal\tmpl\default\calendar.php:487
11	DefaultModCalView->getCal()	JROOT\modules\mod_jevents_cal\mod_jevents_cal.php:46
10	include JROOT\modules\mod_jevents_cal\mod_jevents_cal.php	JROOT\libraries\src\Helper\ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:309
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.25 ms After last query: 4.82 ms Query memory: 0.030 MB Memory before query: 13.354 MB Rows returned: 0

SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* ,  ev.state as published, ev.created as created 
 , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup
 , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn
 , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup
 , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn
 
  FROM pnu4z_jevents_repetition as rpt
 
  INNER JOIN pnu4z_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN pnu4z_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN pnu4z_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN pnu4z_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,17)
 
  AND rpt.endrepeat >= '2021-01-01 00:00:00' 
  AND rpt.startrepeat <= '2021-01-31 23:59:59'
 
  AND NOT (rpt.startrepeat < '2021-01-01 00:00:00' 
  AND det.multiday=0)  
  AND ev.state=1
 
  AND ev.access IN (1,1,5)  
  AND icsf.state=1 
  AND icsf.access IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	rpt	range	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	startrepeat	5	NULL	1	Using index condition; Using where
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	eeuprjoom.rpt.eventid	1	Using where
1	SIMPLE	icsf	eq_ref	PRIMARY,stateidx	PRIMARY	4	eeuprjoom.ev.icsid	1	Using where
1	SIMPLE	det	eq_ref	PRIMARY,multiday	PRIMARY	4	eeuprjoom.rpt.eventdetail_id	1	Using where
1	SIMPLE	rr	ALL	eventid	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.23 ms
checking permissions	0.01 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
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.10 ms
optimizing	0.06 ms
statistics	0.18 ms
preparing	0.10 ms
executing	0.01 ms
Sending data	0.12 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.02 ms
updating status	0.08 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT\libraries\joomla\database\driver.php:1691
17	JDatabaseDriver->loadObjectList()	JROOT\components\com_jevents\libraries\dbmodel.php:2570
16	JEventsDBModel->_cachedlistIcalEvents()	JROOT\components\com_jevents\libraries\dbmodel.php:2519
15	JEventsDBModel->listIcalEvents()	JROOT\components\com_jevents\libraries\dbmodel.php:2698
14	JEventsDBModel->listIcalEventsByMonth()	JROOT\components\com_jevents\libraries\datamodel.php:243
13	JEventsDataModel->getCalendarData()	JROOT\modules\mod_jevents_cal\tmpl\flat\calendar.php:78
12	FlatModCalView->_displayCalendarMod()	JROOT\modules\mod_jevents_cal\tmpl\default\calendar.php:487
11	DefaultModCalView->getCal()	JROOT\modules\mod_jevents_cal\mod_jevents_cal.php:46
10	include JROOT\modules\mod_jevents_cal\mod_jevents_cal.php	JROOT\libraries\src\Helper\ModuleHelper.php:201
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT\libraries\src\Document\Renderer\Html\ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT\libraries\src\Document\Renderer\Html\ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT\libraries\src\Document\HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT\libraries\src\Document\HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT\libraries\src\Document\HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT\libraries\src\Application\CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT\libraries\src\Application\SiteApplication.php:780
2	Joomla\CMS\Application\SiteApplication->render()	JROOT\libraries\src\Application\CMSApplication.php:309
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.]

24 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

2 × SELECT DISTINCT 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
 
  FROM pnu4z_content AS a
 
  LEFT JOIN pnu4z_categories AS c 
  ON c.id = a.catid
 
  LEFT JOIN pnu4z_users AS ua 
  ON ua.id = a.created_by
 
  LEFT JOIN pnu4z_users AS uam 
  ON uam.id = a.modified_by
 
  LEFT JOIN pnu4z_categories as parent 
  ON parent.id = c.parent_id

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

1 × SELECT *
 
  FROM pnu4z_template_styles

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
 
  FROM pnu4z_fields AS a
 
  LEFT JOIN `pnu4z_languages` AS l 
  ON l.lang_code = a.language
 
  LEFT JOIN pnu4z_users AS uc 
  ON uc.id=a.checked_out
 
  LEFT JOIN pnu4z_viewlevels AS ag 
  ON ag.id = a.access
 
  LEFT JOIN pnu4z_users AS ua 
  ON ua.id = a.created_user_id
 
  LEFT JOIN pnu4z_fields_groups AS g 
  ON g.id = a.group_id
 
  LEFT JOIN `pnu4z_fields_categories` AS fc 
  ON fc.field_id = a.id

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 `pnu4z_categories` AS `s`
 
  INNER JOIN `pnu4z_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
 
  FROM pnu4z_modules AS m
 
  LEFT JOIN pnu4z_modules_menu AS mm 
  ON mm.moduleid = m.id
 
  LEFT JOIN pnu4z_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT MONTH(`created`) AS created_month,MIN(`created`) AS created,YEAR(`created`) AS created_year
 
  FROM pnu4z_content

1 × SELECT det.evdet_id as detailid, rpt.*, ev.*, rr.*, det.* ,  ev.state as published, ev.created as created   , YEAR(rpt.startrepeat) as yup, MONTH(rpt.startrepeat ) as mup, DAYOFMONTH(rpt.startrepeat ) as dup  , YEAR(rpt.endrepeat  ) as ydn, MONTH(rpt.endrepeat   ) as mdn, DAYOFMONTH(rpt.endrepeat   ) as ddn  , HOUR(rpt.startrepeat) as hup, MINUTE(rpt.startrepeat ) as minup, SECOND(rpt.startrepeat ) as sup  , HOUR(rpt.endrepeat  ) as hdn, MINUTE(rpt.endrepeat   ) as mindn, SECOND(rpt.endrepeat   ) as sdn  
  FROM pnu4z_jevents_repetition as rpt  
  INNER JOIN pnu4z_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id  
  INNER JOIN pnu4z_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid   
  INNER JOIN pnu4z_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id  
  LEFT JOIN pnu4z_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid

1 × SELECT c.id
 
  FROM pnu4z_categories AS c

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 `pnu4z_categories` AS `c`

1 × SELECT COUNT(*)
 
  FROM pnu4z_content AS a
 
  LEFT JOIN pnu4z_categories AS c 
  ON c.id = a.catid
 
  LEFT JOIN pnu4z_users AS ua 
  ON ua.id = a.created_by
 
  LEFT JOIN pnu4z_users AS uam 
  ON uam.id = a.modified_by
 
  LEFT JOIN pnu4z_categories as parent 
  ON parent.id = c.parent_id

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

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

1 × SELECT id, rules
 
  FROM `pnu4z_viewlevels

1 × SELECT `session_id`
 
  FROM `pnu4z_session`

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

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 pnu4z_menu AS m
 
  LEFT JOIN pnu4z_extensions AS e 
  ON m.component_id = e.extension_id

```
1 × SELECT *
 
  FROM pnu4z_languages
```

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

1 × SELECT `data`
 
  FROM `pnu4z_session`

OTHER Tables:

1 × SHOW FULL COLUMNS 
  FROM `pnu4z_jev_users

1 × SHOW FULL COLUMNS 
  FROM `pnu4z_template_styles

1 × UPDATE `pnu4z_extensions`
 
  SET `params` = '{\"mediaversion\":\"a9dd77621ccd3925c1c807a19e1a4a6a\"}'

1 × INSERT INTO `pnu4z_session`
 (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
 ('t48mc6bekq5kttid6ggnumga01', 1, '1611602596', 0, '', 0