Kalender


By Year	By Month	By Week	Today	Search	Jump to month

Events for

2020
January 2020	Volzet :: Volzet Volzet :: Volzet
February 2020	VOLZET :: Volzet Volzet :: Volzet
March 2020	Volzet :: Volzet Volzet :: Volzet
May 2020	onder voorbehoud :: Volzet Volzet :: Volzet
July 2020	VOLZET - Open terassen weekend :: Volzet VOLZET :: Volzet

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 2,
            "timer": {
                "start": 1715522335,
                "last": 1715522335,
                "now": 1715522336
            },
            "client": {
                "forwarded": "3.145.107.181"
            },
            "token": "LWKo9bFzvbtsjosA507vjxCRQcmEObf5"
        },
        "registry": {
            "published_fv_ses": "0",
            "justmine_fv_ses": "0"
        },
        "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
        },
        "com_mailto": {
            "links": {
                "9f4e95f5f99a5015377dcad490baa4bcd6d241f4": {
                    "link": "https://doppioelle.be/index.php/kalender/year.listevents/2020/08/03/16",
                    "expiry": 1715522336
                }
            }
        }
    }
}

Profile Information

Memory Usage

Database Queries

32 Queries Logged 19.08 ms

7 duplicate found!

7 duplicates: #8 #27 #28 #29 #30 #31 #32

Query Time: 0.39 ms Query memory: 0.023 MB Memory before query: 0.816 MB Rows returned: 1

SELECT `data`

  FROM `fj375_session`

  WHERE `session_id` = X'6166613262626163363861396261396534363333363430363961663662653031'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fj375_session	const	PRIMARY	PRIMARY	194	const	1

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.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
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:661
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
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:386
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.61 ms After last query: 0.38 ms Query memory: 0.022 MB Memory before query: 0.856 MB Rows returned: 35

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

  FROM `fj375_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fj375_extensions	ref	extension	extension	82	const	35	Using index condition; Using where

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.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.18 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.58 ms After last query: 0.31 ms Query memory: 0.020 MB Memory before query: 0.872 MB Rows returned: 4

SELECT id, rules

  FROM `fj375_viewlevels`

Explain

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

Profile

Status	Duration
Starting	0.11 ms
checking permissions	0.01 ms
Opening tables	0.05 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.02 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.05 ms
Reset for next command	0.03 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
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:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.43 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 0.883 MB Rows returned: 1

SELECT b.id

  FROM fj375_usergroups AS a

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

  WHERE a.id = 1

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	1	Using where; Using index

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.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
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:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.68 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 0.905 MB Rows returned: 81

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

  FROM fj375_extensions

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

  ORDER BY ordering

Explain

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

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.03 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.26 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
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:356
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.63 ms After last query: 5.35 ms Query memory: 0.024 MB Memory before query: 1.276 MB Rows returned: 12

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

  LEFT JOIN fj375_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	22	Using index condition; Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	doppioelle_be.m.component_id	1	Using where

Profile

Status	Duration
Starting	0.07 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.02 ms
Optimizing	0.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.14 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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: 2.18 ms Query memory: 0.080 MB Memory before query: 1.406 MB Rows returned: 6

SELECT id, home, template, s.params

  FROM fj375_template_styles as s

  LEFT JOIN fj375_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	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	6
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	doppioelle_be.s.template,const	1	Using index condition; Using where

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.02 ms
Statistics	0.05 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.12 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
11	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:266
10	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/helixultimate.php:216
9	PlgSystemHelixultimate->attachWebAsset()	JROOT/plugins/system/helixultimate/helixultimate.php:245
8	PlgSystemHelixultimate->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.30 ms After last query: 0.58 ms Query memory: 0.022 MB Memory before query: 1.418 MB Rows returned: 1

Duplicate queries: #27 #28 #29 #30 #31 #32

SELECT *

  FROM `fj375_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '6'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fj375_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.02 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.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
11	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
10	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/helixultimate.php:216
9	PlgSystemHelixultimate->attachWebAsset()	JROOT/plugins/system/helixultimate/helixultimate.php:245
8	PlgSystemHelixultimate->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
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.30 ms After last query: 0.16 ms Query memory: 0.023 MB Memory before query: 1.442 MB Rows returned: 1

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

  FROM `fj375_extensions`

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

Explain

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

Profile

Status	Duration
Starting	0.02 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
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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:225
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: 0.09 ms Query memory: 0.005 MB Memory before query: 1.432 MB

UPDATE `fj375_extensions`

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

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

Explain

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

Profile

Status	Duration
Starting	0.03 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 for update	0.04 ms
Updating	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.09 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1137
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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:225
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.30 ms After last query: 0.35 ms Query memory: 0.019 MB Memory before query: 1.482 MB Rows returned: 1

SELECT *

  FROM fj375_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
Starting	0.02 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
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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:225
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.59 ms After last query: 4.80 ms Query memory: 0.027 MB Memory before query: 1.847 MB Rows returned: 35

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

  FROM `fj375_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jevents','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_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	fj375_assets	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	160	Using where

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.03 ms
Optimizing	0.01 ms
Statistics	0.07 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.18 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
21	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
20	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
19	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
18	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
17	Joomla\CMS\User\User->authorise()	JROOT/components/com_jevents/libraries/helper.php:1193
16	JEVHelper::isAdminUser()	JROOT/components/com_jevents/libraries/helper.php:1151
15	JEVHelper::getAid()	JROOT/components/com_jevents/libraries/datamodel.php:49
14	JEventsDataModel->__construct()	JROOT/components/com_jevents/views/default/abstract/abstract.php:65
13	JEventsDefaultView->__construct()	JROOT/components/com_jevents/views/geraint/abstract/abstract.php:32
12	JEventsGeraintView->__construct()	JROOT/libraries/src/MVC/Factory/LegacyFactory.php:89
11	Joomla\CMS\MVC\Factory\LegacyFactory->createView()	JROOT/libraries/src/MVC/Controller/BaseController.php:590
10	Joomla\CMS\MVC\Controller\BaseController->createView()	JROOT/libraries/src/MVC/Controller/BaseController.php:833
9	Joomla\CMS\MVC\Controller\BaseController->getView()	JROOT/components/com_jevents/controllers/year.php:68
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:225
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.17 ms After last query: 1.22 ms Query memory: 0.028 MB Memory before query: 2.005 MB Rows returned: 31

SHOW FULL COLUMNS 
  FROM `fj375_content`

Explain

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

Profile

Status	Duration
Starting	0.02 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.21 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
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.10 ms
closing tables	0.01 ms
Executing	0.01 ms
Sending data	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.00 ms
Removing tmp table	0.52 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
24	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
23	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
22	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
21	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:328
20	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:15
19	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
18	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:19
17	DefaultViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
16	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:7
15	DefaultViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
14	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:6
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:225
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.85 ms After last query: 0.99 ms Query memory: 0.029 MB Memory before query: 2.081 MB Rows returned: 0

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

  FROM fj375_fields AS a

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

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

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

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

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

  WHERE a.context = 'com_content.article' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  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 temporary; Using filesort
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	doppioelle_be.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	doppioelle_be.a.checked_out	1
1	SIMPLE	ag	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	doppioelle_be.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	doppioelle_be.a.group_id	1	Using where

Profile

Status	Duration
Starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.05 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.09 ms
Preparing	0.03 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.19 ms
Creating sort index	0.03 ms
Removing tmp table	0.05 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
27	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
26	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
25	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
24	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
23	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
22	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
21	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
20	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:23
19	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
18	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:19
17	DefaultViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
16	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:7
15	DefaultViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
14	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:6
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:225
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.51 ms After last query: 0.32 ms Query memory: 0.030 MB Memory before query: 2.129 MB Rows returned: 3

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

  FROM fj375_modules AS m

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

  LEFT JOIN fj375_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 <= '2024-05-12 13:58:56') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-05-12 13:58:56') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 103 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	5	const,const	4	Using where; Using filesort
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	doppioelle_be.m.id	1	Using where; Using index
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	doppioelle_be.m.module,const	1	Using index condition; Using where

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.03 ms
Optimizing	0.03 ms
Statistics	0.04 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.09 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
31	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
30	JDatabaseDriver->loadObjectList()	Same as call in the line below.
29	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
28	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
27	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
26	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
25	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/plugins/content/loadmodule/loadmodule.php:169
24	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:81
23	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
22	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
21	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
20	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_jevents/views/default/helpers/defaultloadmodules.php:23
19	DefaultLoadModules()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
18	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader16.php:19
17	DefaultViewHelperHeader16()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
16	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/helpers/defaultviewhelperheader.php:7
15	DefaultViewHelperHeader()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
14	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:6
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:225
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.65 ms After last query: 2.73 ms Query memory: 0.030 MB Memory before query: 2.196 MB Rows returned: 18

SHOW FULL COLUMNS 
  FROM `fj375_jev_users`

Explain

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

Profile

Status	Duration
Starting	0.03 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.17 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
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.06 ms
closing tables	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Removing tmp table	0.06 ms
closing tables	0.01 ms
Unlocking tables	0.00 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
29	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
28	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
27	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
26	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jevents/tables/jevuser.php:75
25	TableUser->__construct()	JROOT/components/com_jevents/libraries/helper.php:1616
24	JEVHelper::getAuthorisedUser()	JROOT/components/com_jevents/libraries/helper.php:1471
23	JEVHelper::isEventCreator()	JROOT/components/com_jevents/libraries/filters/Published.php:61
22	jevPublishedFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
21	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
20	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:3515
19	JEventsDBModel->listIcalEventsByYear()	JROOT/components/com_jevents/libraries/dbmodel.php:3469
18	JEventsDBModel->countIcalEventsByYear()	JROOT/components/com_jevents/libraries/datamodel.php:566
17	JEventsDataModel->getYearData()	JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php:10
16	include JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:225
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.64 ms After last query: 0.37 ms Query memory: 0.030 MB Memory before query: 2.238 MB Rows returned: 4

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

  WHERE (c.extension='com_jevents' OR c.extension='system') 
  AND c.access IN (1,1) 
  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 filesort

Profile

Status	Duration
Starting	0.10 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.04 ms
Statistics	0.06 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.04 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
27	Joomla\CMS\Categories\Categories->_load()	JROOT/components/com_jevents/helpers/category.php:53
26	JEventsCategories->_load()	JROOT/libraries/src/Categories/Categories.php:184
25	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_jevents/libraries/dbmodel.php:411
24	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1020
23	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
22	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
21	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
20	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:3515
19	JEventsDBModel->listIcalEventsByYear()	JROOT/components/com_jevents/libraries/dbmodel.php:3469
18	JEventsDBModel->countIcalEventsByYear()	JROOT/components/com_jevents/libraries/datamodel.php:566
17	JEventsDataModel->getYearData()	JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php:10
16	include JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.35 ms After last query: 0.11 ms Query memory: 0.029 MB Memory before query: 2.270 MB Rows returned: 3

SELECT c.id

  FROM fj375_categories AS c

  WHERE c.access   IN (1,1)
 
  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	ref	cat_idx,idx_access,idx_language	cat_idx	207	const,const,const	3	Using index condition; Using where; Using filesort

Profile

Status	Duration
Starting	0.03 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.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
25	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:547
24	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/datamodel.php:1020
23	JEventsDataModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/filters/Category.php:47
22	jevCategoryFilter->__construct()	JROOT/components/com_jevents/libraries/filters.php:180
21	jevFilterProcessing->__construct()	JROOT/components/com_jevents/libraries/filters.php:251
20	jevFilterProcessing::getInstance()	JROOT/components/com_jevents/libraries/dbmodel.php:3515
19	JEventsDBModel->listIcalEventsByYear()	JROOT/components/com_jevents/libraries/dbmodel.php:3469
18	JEventsDBModel->countIcalEventsByYear()	JROOT/components/com_jevents/libraries/datamodel.php:566
17	JEventsDataModel->getYearData()	JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php:10
16	include JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.34 ms After last query: 0.13 ms Query memory: 0.027 MB Memory before query: 2.288 MB Rows returned: 1

SELECT c.id

  FROM fj375_categories AS c

  WHERE c.access   IN (1,1)
 
  AND c.published = 1
  
  AND c.language in ('en-GB','*')
 
  AND c.extension = 'com_jevents'
 
  AND ((c.lft>=39 
  AND c.rgt<=40 ))

  ORDER BY c.lft asc

Explain

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

Profile

Status	Duration
Starting	0.03 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.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
21	JDatabaseDriver->loadColumn()	JROOT/components/com_jevents/libraries/dbmodel.php:547
20	JEventsDBModel->accessibleCategoryList()	JROOT/components/com_jevents/libraries/dbmodel.php:3526
19	JEventsDBModel->listIcalEventsByYear()	JROOT/components/com_jevents/libraries/dbmodel.php:3469
18	JEventsDBModel->countIcalEventsByYear()	JROOT/components/com_jevents/libraries/datamodel.php:566
17	JEventsDataModel->getYearData()	JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php:10
16	include JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:225
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.38 ms After last query: 0.07 ms Query memory: 0.027 MB Memory before query: 2.314 MB Rows returned: 18

SELECT rpt.rp_id
 
  FROM fj375_jevents_repetition as rpt 
 
  INNER JOIN fj375_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN fj375_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN fj375_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN fj375_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,16)
 
  AND rpt.endrepeat >= '2020-01-01 00:00:00' 
  AND rpt.startrepeat <= '2020-12-31 23:59:59' 
  AND ev.state=1
 
  AND ev.access IN (1,1)  
  AND icsf.state=1 
  AND icsf.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	icsf	system	PRIMARY,stateidx	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	rpt	ALL	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	NO INDEX KEY COULD BE USED	NULL	NULL	1624	Using where
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	doppioelle_be.rpt.eventid	1	Using where
1	SIMPLE	det	eq_ref	PRIMARY	PRIMARY	4	doppioelle_be.rpt.eventdetail_id	1	Using index
1	SIMPLE	rr	ref	eventid	eventid	4	doppioelle_be.rpt.eventid	1	Using index

Profile

Status	Duration
Starting	0.05 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.02 ms
Optimizing	0.02 ms
Statistics	0.09 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Executing	0.01 ms
Sending data	0.90 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.03 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/components/com_jevents/libraries/dbmodel.php:3264
21	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
20	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3611
19	JEventsDBModel->listIcalEventsByYear()	JROOT/components/com_jevents/libraries/dbmodel.php:3469
18	JEventsDBModel->countIcalEventsByYear()	JROOT/components/com_jevents/libraries/datamodel.php:566
17	JEventsDataModel->getYearData()	JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php:10
16	include JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:225
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: 3.60 ms After last query: 0.09 ms Query memory: 0.059 MB Memory before query: 2.327 MB Rows returned: 10

SELECT ev.*, rpt.*, rr.*, det.*, ev.state as published 
 , 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 fj375_jevents_repetition as rpt 
 
  INNER JOIN fj375_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id
 
  INNER JOIN fj375_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid 
 
  INNER JOIN fj375_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id
 
  LEFT JOIN fj375_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid
 
  WHERE ev.catid IN(-1,16)
 
  AND rpt.endrepeat >= '2020-01-01 00:00:00' 
  AND rpt.startrepeat <= '2020-12-31 23:59:59' 
  AND ev.state=1
 
  AND ev.access IN (1,1)  
  AND icsf.state=1 
  AND icsf.access IN (1,1) 
  ORDER BY rpt.startrepeat asc 
  LIMIT 0,10

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	icsf	system	PRIMARY,stateidx	NO INDEX KEY COULD BE USED	NULL	NULL	1
1	SIMPLE	rpt	range	eventid,eventstart,eventend,eventdetail,startrepeat,startend,endrepeat	startrepeat	5	NULL	1144	Using where
1	SIMPLE	ev	eq_ref	PRIMARY,icsid,stateidx,evaccess	PRIMARY	4	doppioelle_be.rpt.eventid	1	Using where
1	SIMPLE	det	eq_ref	PRIMARY	PRIMARY	4	doppioelle_be.rpt.eventdetail_id	1
1	SIMPLE	rr	ref	eventid	eventid	4	doppioelle_be.rpt.eventid	1

Profile

Status	Duration
Starting	0.12 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.06 ms
Optimizing	0.05 ms
Statistics	0.07 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	3.00 ms
End of update loop	0.02 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
21	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/dbmodel.php:3274
20	JEventsDBModel->_cachedlistIcalEvents()	JROOT/components/com_jevents/libraries/jevCache.php:74
19	jevCache->call()	JROOT/components/com_jevents/libraries/dbmodel.php:3611
18	JEventsDBModel->listIcalEventsByYear()	JROOT/components/com_jevents/libraries/datamodel.php:583
17	JEventsDataModel->getYearData()	JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php:10
16	include JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.42 ms After last query: 0.42 ms Query memory: 0.027 MB Memory before query: 2.449 MB Rows returned: 4

SELECT c.* 
  FROM fj375_categories as c 
  WHERE 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	ref	cat_idx	cat_idx	202	const	4	Using index condition; Using where; Using filesort

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.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.07 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/commonfunctions.php:191
19	JEV_CommonFunctions::getCategoryData()	JROOT/components/com_jevents/libraries/commonfunctions.php:144
18	JEV_CommonFunctions::setColor()	JROOT/components/com_jevents/libraries/jeventcal.php:598
17	jEventCal->bgcolor()	JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php:44
16	include JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:225
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.38 ms After last query: 0.16 ms Query memory: 0.026 MB Memory before query: 2.472 MB Rows returned: 3

SELECT a.id, a.parent_id

  FROM fj375_categories AS a

  WHERE a.parent_id > 0 
  AND a.extension = "com_jevents" 
  AND a.published = 1 
  AND a.language in ('en-GB','*')

  ORDER BY a.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	cat_idx,idx_language	cat_idx	203	const,const	3	Using index condition; Using where; Using filesort

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.02 ms
Statistics	0.04 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.04 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:42
18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php:47
16	include JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.33 ms After last query: 0.02 ms Query memory: 0.026 MB Memory before query: 2.485 MB Rows returned: 0

SELECT * 
  FROM fj375_jev_defaults 
  WHERE state=1 
  AND name= 'icalevent.list_row' 
  AND value<>'' 
  AND language in ('en-GB','*')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fj375_jev_defaults	ref	name,langcodename	name	152	const	5	Using index condition; Using where

Profile

Status	Duration
Starting	0.03 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.02 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:76
18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php:47
16	include JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:225
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.38 ms After last query: 0.33 ms Query memory: 0.027 MB Memory before query: 2.509 MB Rows returned: 0

SELECT `c2`.`language`,`c2`.`id`

  FROM `fj375_menu` AS `c`

  INNER JOIN `fj375_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item'

  INNER JOIN `fj375_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key`

  INNER JOIN `fj375_menu` AS `c2` 
  ON a2.id = c2.`id`

  WHERE c.id = 103

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

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.02 ms
Optimizing	0.02 ms
Statistics	0.08 ms
Preparing	0.01 ms
Executing	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Associations.php:115
21	Joomla\CMS\Language\Associations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:321
20	MenusHelper::getAssociations()	JROOT/components/com_jevents/libraries/jicaleventrepeat.php:292
19	jIcalEventRepeat->viewDetailLink()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:553
18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php:47
16	include JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:225
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.37 ms After last query: 0.56 ms Query memory: 0.028 MB Memory before query: 2.583 MB Rows returned: 4

SELECT cat.id, cat.title as name, pcat.title as pname, cat.description, cat.params  
  FROM fj375_categories  as cat 
  LEFT JOIN fj375_categories as pcat 
  on pcat.id=cat.parent_id 
  WHERE cat.extension='com_jevents' 
  ORDER BY cat.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	cat	ref	cat_idx	cat_idx	202	const	4	Using index condition; Using where; Using filesort
1	SIMPLE	pcat	eq_ref	PRIMARY	PRIMARY	4	doppioelle_be.cat.parent_id	1	Using where

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.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.05 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/components/com_jevents/libraries/jeventcal.php:507
22	jEventCal->getCategoryData()	JROOT/components/com_jevents/libraries/jeventcal.php:477
21	jEventCal->getCategoryName()	JROOT/components/com_jevents/libraries/jicaleventdb.php:681
20	jIcalEventDB->getCategoryName()	JROOT/components/com_jevents/libraries/jeventcal.php:467
19	jEventCal->catname()	JROOT/components/com_jevents/views/default/helpers/defaultloadedfromtemplate.php:640
18	DefaultLoadedFromTemplate()	JROOT/components/com_jevents/views/default/abstract/abstract.php:187
17	JEventsDefaultView->__call()	JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php:47
16	include JROOT/components/com_jevents/views/default/year/tmpl/listevents_body.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php:4
15	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents_body.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
14	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/components/com_jevents/views/default/year/tmpl/listevents.php:11
13	include JROOT/components/com_jevents/views/default/year/tmpl/listevents.php	JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php:4
12	include JROOT/components/com_jevents/views/geraint/year/tmpl/listevents.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
11	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
10	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/administrator/components/com_jevents/views/abstract/abstract.php:132
9	JEventsAbstractView->display()	JROOT/components/com_jevents/controllers/year.php:88
8	YearController->listevents()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jevents/jevents.php:364
6	require_once JROOT/components/com_jevents/jevents.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
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:225
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.55 ms After last query: 6.12 ms Query memory: 0.023 MB Memory before query: 2.706 MB Rows returned: 1

Duplicate queries: #8 #28 #29 #30 #31 #32

SELECT *

  FROM `fj375_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '6'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fj375_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.09 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.03 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.02 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
15	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
14	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
13	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/helixultimate.php:390
12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.32 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 2.715 MB Rows returned: 1

Duplicate queries: #8 #27 #29 #30 #31 #32

SELECT *

  FROM `fj375_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '6'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fj375_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.02 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.02 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
15	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
14	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:119
13	HelixUltimate\Framework\Core\HelixUltimate->__construct()	JROOT/plugins/system/helixultimate/helixultimate.php:402
12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 2.724 MB Rows returned: 1

Duplicate queries: #8 #27 #28 #30 #31 #32

SELECT *

  FROM `fj375_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '6'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fj375_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.02 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.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
16	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
15	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:1989
14	HelixUltimate\Framework\Core\HelixUltimate->addCustomAssets()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:148
13	HelixUltimate\Framework\Core\HelixUltimate->__call()	JROOT/plugins/system/helixultimate/helixultimate.php:425
12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.25 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 2.732 MB Rows returned: 1

Duplicate queries: #8 #27 #28 #29 #31 #32

SELECT *

  FROM `fj375_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '6'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fj375_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.02 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
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
16	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
15	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:1989
14	HelixUltimate\Framework\Core\HelixUltimate->addCustomAssets()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:148
13	HelixUltimate\Framework\Core\HelixUltimate->__call()	JROOT/plugins/system/helixultimate/helixultimate.php:426
12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.29 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 2.740 MB Rows returned: 1

Duplicate queries: #8 #27 #28 #29 #30 #32

SELECT *

  FROM `fj375_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '6'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fj375_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.02 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.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.04 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
17	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
16	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
15	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:1989
14	HelixUltimate\Framework\Core\HelixUltimate->addCustomAssets()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:148
13	HelixUltimate\Framework\Core\HelixUltimate->__call()	JROOT/plugins/system/helixultimate/helixultimate.php:427
12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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.31 ms After last query: 0.31 ms Query memory: 0.021 MB Memory before query: 2.782 MB Rows returned: 1

Duplicate queries: #8 #27 #28 #29 #30 #31

SELECT *

  FROM `fj375_template_styles`

  WHERE `client_id` = 0 
  AND `id` = '6'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	fj375_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

Profile

Status	Duration
Starting	0.02 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
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
9	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
8	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/helixultimate.php:563
7	PlgSystemHelixultimate->onAfterRender()	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/CMSApplication.php:1118
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
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:

7 × SELECT * 
  FROM `fj375_template_styles`

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

2 × SELECT c.id 
  FROM fj375_categories AS c

1 × SELECT `data` 
  FROM `fj375_session`

1 × SELECT id, rules 
  FROM `fj375_viewlevels

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

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM fj375_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 fj375_menu AS m 
  LEFT JOIN fj375_extensions AS e 
  ON m.component_id = e.extension_id

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

```
1 × SELECT * 
  FROM fj375_languages
```

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

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

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM fj375_modules AS m 
  LEFT JOIN fj375_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN fj375_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_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 `fj375_categories` AS `c`

1 × SELECT rpt.rp_id  
  FROM fj375_jevents_repetition as rpt   
  INNER JOIN fj375_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id  
  INNER JOIN fj375_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid   
  INNER JOIN fj375_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id  
  LEFT JOIN fj375_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid

1 × SELECT ev.*, rpt.*, rr.*, det.*, ev.state as published   , 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 fj375_jevents_repetition as rpt   
  INNER JOIN fj375_jevents_vevent as ev 
  ON rpt.eventid = ev.ev_id  
  INNER JOIN fj375_jevents_icsfile as icsf 
  ON icsf.ics_id=ev.icsid   
  INNER JOIN fj375_jevents_vevdetail as det 
  ON det.evdet_id = rpt.eventdetail_id  
  LEFT JOIN fj375_jevents_rrule as rr 
  ON rr.eventid = rpt.eventid

1 × SELECT c.* 
  FROM fj375_categories as c

1 × SELECT a.id, a.parent_id 
  FROM fj375_categories AS a

1 × SELECT * 
  FROM fj375_jev_defaults

1 × SELECT `c2`.`language`,`c2`.`id` 
  FROM `fj375_menu` AS `c` 
  INNER JOIN `fj375_associations` AS `a` 
  ON a.id = c.`id` 
  AND a.context='com_menus.item' 
  INNER JOIN `fj375_associations` AS `a2` 
  ON `a`.`key` = `a2`.`key` 
  INNER JOIN `fj375_menu` AS `c2` 
  ON a2.id = c2.`id`

1 × SELECT cat.id, cat.title as name, pcat.title as pname, cat.description, cat.params  
  FROM fj375_categories  as cat 
  LEFT JOIN fj375_categories as pcat 
  on pcat.id=cat.parent_id

OTHER Tables:

1 × UPDATE `fj375_extensions` 
  SET `params` = '{\"mediaversion\":\"cc10f5a7e78943c5bd35db69dbc8831e\"}'

1 × SHOW FULL COLUMNS 
  FROM `fj375_content

1 × SHOW FULL COLUMNS 
  FROM `fj375_jev_users

Nav view search

Navigation

Search

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

32 Queries Logged 19.08 ms

7 duplicate found!

24 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: