Donate

Joomla! Debug Console

Session

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

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

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

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
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

EXPLAIN not possible on query: INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3036383865336437353266353035643562346333333438363664663962653263', 1, 1734882442, 0, '', 0)

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
update	0.07 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	4.60 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
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.39 ms After last query: 3.82 ms Query memory: 0.021 MB Memory before query: 1.301 MB Rows returned: 37

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

  FROM `jos_extensions`

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

Explain

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

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.12 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 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.17 ms After last query: 3.43 ms Query memory: 0.020 MB Memory before query: 1.376 MB Rows returned: 17

SELECT id, rules

  FROM `jos_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 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.23 ms After last query: 0.07 ms Query memory: 0.020 MB Memory before query: 1.389 MB Rows returned: 2

SELECT b.id

  FROM jos_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 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.56 ms After last query: 1.25 ms Query memory: 0.022 MB Memory before query: 1.409 MB Rows returned: 113

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

  FROM jos_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_extensions	NULL	ref	extension	extension	82	const	136	0.60	Using where; Using filesort

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.35 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 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: 1.46 ms After last query: 57.64 ms Query memory: 0.089 MB Memory before query: 2.621 MB Rows returned: 142

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

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

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

  ORDER BY m.lft

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	605	9.54	Using where; Using filesort
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	facltesting_jos3.m.component_id	1	100.00	Using where

Profile

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.04 ms
executing	1.03 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 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.60 ms After last query: 11.14 ms Query memory: 0.022 MB Memory before query: 3.013 MB Rows returned: 3

SELECT id, home, template, s.params

  FROM jos_template_styles as s

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

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_client_id	1	const	3	100.00	NULL
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	facltesting_jos3.s.template,const	1	4.50	Using index condition; Using where

Profile

Status	Duration
starting	0.12 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.04 ms
executing	0.09 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
14	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ThemeLoader.php:101
13	YOOtheme\Theme\Joomla\ThemeLoader->getTemplate()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/ThemeLoader.php:51
12	YOOtheme\Theme\Joomla\ThemeLoader->initTheme()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:276
11	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:291
10	YOOtheme\Container->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:115
9	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/vendor/yootheme/utils/src/EventDispatcher.php:45
8	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/vendor/yootheme/platform-joomla/src/ActionLoader.php:43
7	YOOtheme\Joomla\ActionLoader->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
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.32 ms After last query: 5.22 ms Query memory: 0.022 MB Memory before query: 3.158 MB Rows returned: 1

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

  FROM `jos_extensions`

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

Explain

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

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.10 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: 1.61 ms After last query: 0.09 ms Query memory: 0.004 MB Memory before query: 3.149 MB

UPDATE `jos_extensions`

  SET `params` = '{\"mediaversion\":\"2f0b558a18a5fc5a1de1f9b389dda3d3\"}'

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

Explain

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

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.04 ms
updating	0.08 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	1.37 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 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.21 ms After last query: 2.94 ms Query memory: 0.019 MB Memory before query: 3.160 MB Rows returned: 1

SELECT *

  FROM jos_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.04 ms
cleaning up	0.00 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.27 ms After last query: 14.39 ms Query memory: 0.023 MB Memory before query: 3.423 MB Rows returned: 1

SELECT extension_id, manifest_cache

  FROM jos_extensions

  WHERE element = 'com_facl' 
  AND type = 'component'

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
16	JDatabaseDriver->loadObject()	JROOT/libraries/Logical/Version/Version.php:72
15	Logical\Version\Version->getSystemRecord()	JROOT/libraries/Logical/Version/Version.php:48
14	Logical\Version\Version->__construct()	JROOT/libraries/Logical/View/BaseView.php:139
13	Logical\View\BaseView->__construct()	JROOT/libraries/Logical/View/CollectionView.php:69
12	Logical\View\CollectionView->__construct()	JROOT/libraries/Logical/View/RecordView.php:90
11	Logical\View\RecordView->__construct()	JROOT/administrator/components/com_facl/view/donations/html.php:40
10	FaclViewDonationsHtml->__construct()	JROOT/libraries/Logical/Controller/DisplayController.php:153
9	Logical\Controller\DisplayController->getView()	JROOT/libraries/Logical/Controller/DisplayController.php:69
8	Logical\Controller\DisplayController->execute()	JROOT/libraries/Logical/Controller/DispatchController.php:172
7	Logical\Controller\DispatchController->execute()	JROOT/components/com_facl/facl.php:32
6	require_once JROOT/components/com_facl/facl.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: 2.90 ms After last query: 10.33 ms Query memory: 0.023 MB Memory before query: 3.510 MB Rows returned: 1

Duplicate queries: #17 #25 #28

SELECT *

  FROM jos_facl_schemas

  WHERE asset_id = 'com_facl.donations'

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	1.30 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	1.39 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/Logical/Table/Table.php:260
16	Logical\Table\Table->getFields()	JROOT/libraries/Logical/Table/Table.php:1054
15	Logical\Table\Table->getSelectQuery()	JROOT/libraries/Logical/Model/CollectionModel.php:504
14	Logical\Model\CollectionModel->getListQuery()	JROOT/administrator/components/com_facl/model/donations.php:197
13	FaclModelDonations->getListQuery()	JROOT/libraries/Logical/Model/CollectionModel.php:421
12	Logical\Model\CollectionModel->getList()	JROOT/administrator/components/com_facl/model/donations.php:178
11	FaclModelDonations->getList()	JROOT/libraries/Logical/View/CollectionView.php:90
10	Logical\View\CollectionView->render()	JROOT/libraries/Logical/View/RecordView.php:152
9	Logical\View\RecordView->render()	JROOT/libraries/Logical/Controller/DisplayController.php:83
8	Logical\Controller\DisplayController->execute()	JROOT/libraries/Logical/Controller/DispatchController.php:172
7	Logical\Controller\DispatchController->execute()	JROOT/components/com_facl/facl.php:32
6	require_once JROOT/components/com_facl/facl.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.23 ms After last query: 0.07 ms Query memory: 0.024 MB Memory before query: 3.523 MB Rows returned: 14

SHOW FULL COLUMNS 
  FROM `jos_facl_donations`

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.31 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.33 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
executing	0.04 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/Logical/Table/Table.php:334
17	Logical\Table\Table->updateSchema()	JROOT/libraries/Logical/Table/Table.php:270
16	Logical\Table\Table->getFields()	JROOT/libraries/Logical/Table/Table.php:1054
15	Logical\Table\Table->getSelectQuery()	JROOT/libraries/Logical/Model/CollectionModel.php:504
14	Logical\Model\CollectionModel->getListQuery()	JROOT/administrator/components/com_facl/model/donations.php:197
13	FaclModelDonations->getListQuery()	JROOT/libraries/Logical/Model/CollectionModel.php:421
12	Logical\Model\CollectionModel->getList()	JROOT/administrator/components/com_facl/model/donations.php:178
11	FaclModelDonations->getList()	JROOT/libraries/Logical/View/CollectionView.php:90
10	Logical\View\CollectionView->render()	JROOT/libraries/Logical/View/RecordView.php:152
9	Logical\View\RecordView->render()	JROOT/libraries/Logical/Controller/DisplayController.php:83
8	Logical\Controller\DisplayController->execute()	JROOT/libraries/Logical/Controller/DispatchController.php:172
7	Logical\Controller\DispatchController->execute()	JROOT/components/com_facl/facl.php:32
6	require_once JROOT/components/com_facl/facl.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.74 ms After last query: 0.11 ms Query memory: 0.008 MB Memory before query: 3.543 MB

UPDATE jos_facl_schemas

  SET fields = '{\"donation_id\":{\"Field\":\"donation_id\",\"Type\":\"int\",\"Collation\":null,\"Null\":\"NO\",\"Key\":\"PRI\",\"Default\":null,\"Extra\":\"auto_increment\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"transaction_internal_id\":{\"Field\":\"transaction_internal_id\",\"Type\":\"int\",\"Collation\":null,\"Null\":\"NO\",\"Key\":\"\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"event_id\":{\"Field\":\"event_id\",\"Type\":\"int\",\"Collation\":null,\"Null\":\"NO\",\"Key\":\"MUL\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"sale_id\":{\"Field\":\"sale_id\",\"Type\":\"int\",\"Collation\":null,\"Null\":\"NO\",\"Key\":\"MUL\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"person_id\":{\"Field\":\"person_id\",\"Type\":\"int\",\"Collation\":null,\"Null\":\"NO\",\"Key\":\"MUL\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_status\":{\"Field\":\"donation_status\",\"Type\":\"enum(\'PENDING\',\'COMPLETE\',\'REFUNDED\',\'DELETED\')\",\"Collation\":\"utf8mb4_unicode_ci\",\"Null\":\"NO\",\"Key\":\"\",\"Default\":\"PENDING\",\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_date\":{\"Field\":\"donation_date\",\"Type\":\"datetime\",\"Collation\":null,\"Null\":\"NO\",\"Key\":\"\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_campaign\":{\"Field\":\"donation_campaign\",\"Type\":\"varchar(255)\",\"Collation\":\"utf8mb4_unicode_ci\",\"Null\":\"NO\",\"Key\":\"\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_channel\":{\"Field\":\"donation_channel\",\"Type\":\"enum(\'MAIL\',\'PHONE\',\'IN_PERSON\',\'ONLINE\',\'FB\',\'UNKNOWN\')\",\"Collation\":\"utf8mb4_unicode_ci\",\"Null\":\"NO\",\"Key\":\"\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_method\":{\"Field\":\"donation_method\",\"Type\":\"enum(\'CASH\',\'CHECK\',\'CREDIT\',\'EXTERNAL\',\'PLEDGE\',\'NON_MONETARY_RESPONSE\',\'UNKNOWN\')\",\"Collation\":\"utf8mb4_unicode_ci\",\"Null\":\"NO\",\"Key\":\"\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_amount\":{\"Field\":\"donation_amount\",\"Type\":\"decimal(12,2)\",\"Collation\":null,\"Null\":\"NO\",\"Key\":\"\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_note\":{\"Field\":\"donation_note\",\"Type\":\"text\",\"Collation\":\"utf8mb4_unicode_ci\",\"Null\":\"NO\",\"Key\":\"\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_lead\":{\"Field\":\"donation_lead\",\"Type\":\"enum(\'YES\',\'NO\')\",\"Collation\":\"utf8mb4_unicode_ci\",\"Null\":\"NO\",\"Key\":\"\",\"Default\":\"NO\",\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_tku_date\":{\"Field\":\"donation_tku_date\",\"Type\":\"datetime\",\"Collation\":null,\"Null\":\"YES\",\"Key\":\"\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"}}'
	, cached_on = '2024-12-22 15:47:22'

  WHERE asset_id = 'com_facl.donations'

Explain

EXPLAIN not possible on query: UPDATE jos_facl_schemas SET fields = '{\"donation_id\":{\"Field\":\"donation_id\",\"Type\":\"int\",\"Collation\":null,\"Null\":\"NO\",\"Key\":\"PRI\",\"Default\":null,\"Extra\":\"auto_increment\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"transaction_internal_id\":{\"Field\":\"transaction_internal_id\",\"Type\":\"int\",\"Collation\":null,\"Null\":\"NO\",\"Key\":\"\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"event_id\":{\"Field\":\"event_id\",\"Type\":\"int\",\"Collation\":null,\"Null\":\"NO\",\"Key\":\"MUL\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"sale_id\":{\"Field\":\"sale_id\",\"Type\":\"int\",\"Collation\":null,\"Null\":\"NO\",\"Key\":\"MUL\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"person_id\":{\"Field\":\"person_id\",\"Type\":\"int\",\"Collation\":null,\"Null\":\"NO\",\"Key\":\"MUL\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_status\":{\"Field\":\"donation_status\",\"Type\":\"enum(\'PENDING\',\'COMPLETE\',\'REFUNDED\',\'DELETED\')\",\"Collation\":\"utf8mb4_unicode_ci\",\"Null\":\"NO\",\"Key\":\"\",\"Default\":\"PENDING\",\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_date\":{\"Field\":\"donation_date\",\"Type\":\"datetime\",\"Collation\":null,\"Null\":\"NO\",\"Key\":\"\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_campaign\":{\"Field\":\"donation_campaign\",\"Type\":\"varchar(255)\",\"Collation\":\"utf8mb4_unicode_ci\",\"Null\":\"NO\",\"Key\":\"\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_channel\":{\"Field\":\"donation_channel\",\"Type\":\"enum(\'MAIL\',\'PHONE\',\'IN_PERSON\',\'ONLINE\',\'FB\',\'UNKNOWN\')\",\"Collation\":\"utf8mb4_unicode_ci\",\"Null\":\"NO\",\"Key\":\"\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_method\":{\"Field\":\"donation_method\",\"Type\":\"enum(\'CASH\',\'CHECK\',\'CREDIT\',\'EXTERNAL\',\'PLEDGE\',\'NON_MONETARY_RESPONSE\',\'UNKNOWN\')\",\"Collation\":\"utf8mb4_unicode_ci\",\"Null\":\"NO\",\"Key\":\"\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_amount\":{\"Field\":\"donation_amount\",\"Type\":\"decimal(12,2)\",\"Collation\":null,\"Null\":\"NO\",\"Key\":\"\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_note\":{\"Field\":\"donation_note\",\"Type\":\"text\",\"Collation\":\"utf8mb4_unicode_ci\",\"Null\":\"NO\",\"Key\":\"\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_lead\":{\"Field\":\"donation_lead\",\"Type\":\"enum(\'YES\',\'NO\')\",\"Collation\":\"utf8mb4_unicode_ci\",\"Null\":\"NO\",\"Key\":\"\",\"Default\":\"NO\",\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_tku_date\":{\"Field\":\"donation_tku_date\",\"Type\":\"datetime\",\"Collation\":null,\"Null\":\"YES\",\"Key\":\"\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"}}' , cached_on = '2024-12-22 15:47:22' WHERE asset_id = 'com_facl.donations'

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.02 ms
updating	0.06 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	1.51 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/Logical/Table/Table.php:340
17	Logical\Table\Table->updateSchema()	JROOT/libraries/Logical/Table/Table.php:270
16	Logical\Table\Table->getFields()	JROOT/libraries/Logical/Table/Table.php:1054
15	Logical\Table\Table->getSelectQuery()	JROOT/libraries/Logical/Model/CollectionModel.php:504
14	Logical\Model\CollectionModel->getListQuery()	JROOT/administrator/components/com_facl/model/donations.php:197
13	FaclModelDonations->getListQuery()	JROOT/libraries/Logical/Model/CollectionModel.php:421
12	Logical\Model\CollectionModel->getList()	JROOT/administrator/components/com_facl/model/donations.php:178
11	FaclModelDonations->getList()	JROOT/libraries/Logical/View/CollectionView.php:90
10	Logical\View\CollectionView->render()	JROOT/libraries/Logical/View/RecordView.php:152
9	Logical\View\RecordView->render()	JROOT/libraries/Logical/Controller/DisplayController.php:83
8	Logical\Controller\DisplayController->execute()	JROOT/libraries/Logical/Controller/DispatchController.php:172
7	Logical\Controller\DispatchController->execute()	JROOT/components/com_facl/facl.php:32
6	require_once JROOT/components/com_facl/facl.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.19 ms After last query: 2.94 ms Query memory: 0.024 MB Memory before query: 3.546 MB Rows returned: 1

Duplicate queries: #14 #25 #28

SELECT *

  FROM jos_facl_schemas

  WHERE asset_id = 'com_facl.donations'

Explain

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

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
17	JDatabaseDriver->loadAssoc()	JROOT/libraries/Logical/Table/Table.php:260
16	Logical\Table\Table->getFields()	JROOT/libraries/Logical/Model/DataModel.php:295
15	Logical\Model\DataModel->getFields()	JROOT/administrator/components/com_facl/model/donations.php:151
14	FaclModelDonations->prepareFilters()	JROOT/libraries/Logical/Model/CollectionModel.php:468
13	Logical\Model\CollectionModel->appendFilters()	JROOT/libraries/Logical/Model/CollectionModel.php:426
12	Logical\Model\CollectionModel->getList()	JROOT/administrator/components/com_facl/model/donations.php:178
11	FaclModelDonations->getList()	JROOT/libraries/Logical/View/CollectionView.php:90
10	Logical\View\CollectionView->render()	JROOT/libraries/Logical/View/RecordView.php:152
9	Logical\View\RecordView->render()	JROOT/libraries/Logical/Controller/DisplayController.php:83
8	Logical\Controller\DisplayController->execute()	JROOT/libraries/Logical/Controller/DispatchController.php:172
7	Logical\Controller\DispatchController->execute()	JROOT/components/com_facl/facl.php:32
6	require_once JROOT/components/com_facl/facl.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: 92.10 ms After last query: 0.93 ms Query memory: 0.022 MB Memory before query: 3.623 MB Rows returned: 1

SELECT COUNT(*)

  FROM `jos_facl_donations` AS `a`

  LEFT JOIN jos_facl_transactions AS transaction 
  ON transaction.transaction_internal_id = a.transaction_internal_id

  LEFT JOIN jos_facl_events AS event 
  ON event.event_id = a.event_id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5656	100.00	NULL
1	SIMPLE	transaction	NULL	eq_ref	PRIMARY	PRIMARY	4	facltesting_jos3.a.transaction_internal_id	1	100.00	Using where; Using index
1	SIMPLE	event	NULL	eq_ref	PRIMARY	PRIMARY	4	facltesting_jos3.a.event_id	1	100.00	Using index

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	1.17 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.03 ms
executing	90.61 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/Logical/Model/CollectionModel.php:617
14	Logical\Model\CollectionModel->_getListCount()	JROOT/libraries/Logical/Model/CollectionModel.php:581
13	Logical\Model\CollectionModel->getTotal()	JROOT/libraries/Logical/Model/CollectionModel.php:430
12	Logical\Model\CollectionModel->getList()	JROOT/administrator/components/com_facl/model/donations.php:178
11	FaclModelDonations->getList()	JROOT/libraries/Logical/View/CollectionView.php:90
10	Logical\View\CollectionView->render()	JROOT/libraries/Logical/View/RecordView.php:152
9	Logical\View\RecordView->render()	JROOT/libraries/Logical/Controller/DisplayController.php:83
8	Logical\Controller\DisplayController->execute()	JROOT/libraries/Logical/Controller/DispatchController.php:172
7	Logical\Controller\DispatchController->execute()	JROOT/components/com_facl/facl.php:32
6	require_once JROOT/components/com_facl/facl.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: 8.28 ms After last query: 0.15 ms Query memory: 0.038 MB Memory before query: 3.625 MB Rows returned: 20

SELECT a.`donation_id`,a.`transaction_internal_id`,a.`event_id`,a.`sale_id`,a.`person_id`,a.`donation_status`,a.`donation_date`,a.`donation_campaign`,a.`donation_channel`,a.`donation_method`,a.`donation_amount`,a.`donation_note`,a.`donation_lead`,a.`donation_tku_date`,transaction.*,event.*

  FROM `jos_facl_donations` AS `a`

  LEFT JOIN jos_facl_transactions AS transaction 
  ON transaction.transaction_internal_id = a.transaction_internal_id

  LEFT JOIN jos_facl_events AS event 
  ON event.event_id = a.event_id

  ORDER BY a.donation_date DESC 
  LIMIT 20

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5656	100.00	Using filesort
1	SIMPLE	transaction	NULL	eq_ref	PRIMARY	PRIMARY	4	facltesting_jos3.a.transaction_internal_id	1	100.00	Using where
1	SIMPLE	event	NULL	eq_ref	PRIMARY	PRIMARY	4	facltesting_jos3.a.event_id	1	100.00	NULL

Profile

Status	Duration
starting	0.08 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.03 ms
executing	7.81 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.11 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/Logical/Model/CollectionModel.php:447
12	Logical\Model\CollectionModel->getList()	JROOT/administrator/components/com_facl/model/donations.php:178
11	FaclModelDonations->getList()	JROOT/libraries/Logical/View/CollectionView.php:90
10	Logical\View\CollectionView->render()	JROOT/libraries/Logical/View/RecordView.php:152
9	Logical\View\RecordView->render()	JROOT/libraries/Logical/Controller/DisplayController.php:83
8	Logical\Controller\DisplayController->execute()	JROOT/libraries/Logical/Controller/DispatchController.php:172
7	Logical\Controller\DispatchController->execute()	JROOT/components/com_facl/facl.php:32
6	require_once JROOT/components/com_facl/facl.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.61 ms After last query: 9.99 ms Query memory: 0.026 MB Memory before query: 3.733 MB Rows returned: 1

SELECT id, alias

  FROM jos_menu

  WHERE link = 'index.php?option=com_facl&view=donations' 
  AND access IN (1,1,5) 
  AND published = 1

Explain

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

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.34 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/Logical/Application/Router.php:109
23	Logical\Application\Router->getMenuItem()	JROOT/libraries/Logical/Application/Router.php:61
22	Logical\Application\Router->BuildRoute()	JROOT/components/com_facl/router.php:24
21	FaclBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
20	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
19	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
18	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
17	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
16	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
15	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
14	Joomla\CMS\Router\Route::_()	JROOT/administrator/components/com_facl/view/donations/html.php:146
13	FaclViewDonationsHtml->prepareListView()	JROOT/administrator/components/com_facl/view/donations/html.php:77
12	FaclViewDonationsHtml->prepareToRender()	JROOT/libraries/Logical/View/BaseView.php:336
11	Logical\View\BaseView->render()	JROOT/libraries/Logical/View/CollectionView.php:99
10	Logical\View\CollectionView->render()	JROOT/libraries/Logical/View/RecordView.php:152
9	Logical\View\RecordView->render()	JROOT/libraries/Logical/Controller/DisplayController.php:83
8	Logical\Controller\DisplayController->execute()	JROOT/libraries/Logical/Controller/DispatchController.php:172
7	Logical\Controller\DispatchController->execute()	JROOT/components/com_facl/facl.php:32
6	require_once JROOT/components/com_facl/facl.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.45 ms After last query: 4.56 ms Query memory: 0.026 MB Memory before query: 3.859 MB Rows returned: 37

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

  FROM `jos_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_convertforms','com_cpanel','com_facl','com_faclarchives','com_fields','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')

Explain

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

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.18 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
22	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
21	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
20	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
19	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
18	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/facluser/impostor.php:82
17	PlgSystemFacluserImpostor->authorise()	JROOT/libraries/Logical/Model/BaseModel.php:169
16	Logical\Model\BaseModel->allowAction()	JROOT/libraries/Logical/Model/RecordModel.php:93
15	Logical\Model\RecordModel->allowAction()	JROOT/administrator/components/com_facl/model/donations.php:644
14	FaclModelDonations->allowAction()	JROOT/administrator/components/com_facl/view/donations/html.php:158
13	FaclViewDonationsHtml->prepareListView()	JROOT/administrator/components/com_facl/view/donations/html.php:77
12	FaclViewDonationsHtml->prepareToRender()	JROOT/libraries/Logical/View/BaseView.php:336
11	Logical\View\BaseView->render()	JROOT/libraries/Logical/View/CollectionView.php:99
10	Logical\View\CollectionView->render()	JROOT/libraries/Logical/View/RecordView.php:152
9	Logical\View\RecordView->render()	JROOT/libraries/Logical/Controller/DisplayController.php:83
8	Logical\Controller\DisplayController->execute()	JROOT/libraries/Logical/Controller/DispatchController.php:172
7	Logical\Controller\DispatchController->execute()	JROOT/components/com_facl/facl.php:32
6	require_once JROOT/components/com_facl/facl.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.26 ms After last query: 0.14 ms Query memory: 0.026 MB Memory before query: 3.908 MB Rows returned: 2

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

  FROM `jos_assets`

  WHERE `name` LIKE 'com_facl.%' OR `name` = 'com_facl' OR `parent_id` = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jos_assets	NULL	ALL	idx_asset_name,idx_parent_id	NO INDEX KEY COULD BE USED	NULL	NULL	110	28.00	Using where

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.07 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
22	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
21	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
20	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
19	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
18	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/facluser/impostor.php:82
17	PlgSystemFacluserImpostor->authorise()	JROOT/libraries/Logical/Model/BaseModel.php:169
16	Logical\Model\BaseModel->allowAction()	JROOT/libraries/Logical/Model/RecordModel.php:93
15	Logical\Model\RecordModel->allowAction()	JROOT/administrator/components/com_facl/model/donations.php:644
14	FaclModelDonations->allowAction()	JROOT/administrator/components/com_facl/view/donations/html.php:158
13	FaclViewDonationsHtml->prepareListView()	JROOT/administrator/components/com_facl/view/donations/html.php:77
12	FaclViewDonationsHtml->prepareToRender()	JROOT/libraries/Logical/View/BaseView.php:336
11	Logical\View\BaseView->render()	JROOT/libraries/Logical/View/CollectionView.php:99
10	Logical\View\CollectionView->render()	JROOT/libraries/Logical/View/RecordView.php:152
9	Logical\View\RecordView->render()	JROOT/libraries/Logical/Controller/DisplayController.php:83
8	Logical\Controller\DisplayController->execute()	JROOT/libraries/Logical/Controller/DispatchController.php:172
7	Logical\Controller\DispatchController->execute()	JROOT/components/com_facl/facl.php:32
6	require_once JROOT/components/com_facl/facl.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.91 ms After last query: 6.68 ms Query memory: 0.027 MB Memory before query: 3.923 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `jos_assets`

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.04 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.32 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
executing	0.05 ms
checking permissions	0.05 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
end	0.02 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
25	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
24	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
23	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Asset.php:61
22	Joomla\CMS\Table\Asset->__construct()	JROOT/libraries/src/Access/Access.php:783
21	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
20	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
19	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
18	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/facluser/impostor.php:82
17	PlgSystemFacluserImpostor->authorise()	JROOT/libraries/Logical/Model/BaseModel.php:169
16	Logical\Model\BaseModel->allowAction()	JROOT/libraries/Logical/Model/RecordModel.php:93
15	Logical\Model\RecordModel->allowAction()	JROOT/administrator/components/com_facl/model/donations.php:644
14	FaclModelDonations->allowAction()	JROOT/administrator/components/com_facl/view/donations/html.php:158
13	FaclViewDonationsHtml->prepareListView()	JROOT/administrator/components/com_facl/view/donations/html.php:77
12	FaclViewDonationsHtml->prepareToRender()	JROOT/libraries/Logical/View/BaseView.php:336
11	Logical\View\BaseView->render()	JROOT/libraries/Logical/View/CollectionView.php:99
10	Logical\View\CollectionView->render()	JROOT/libraries/Logical/View/RecordView.php:152
9	Logical\View\RecordView->render()	JROOT/libraries/Logical/Controller/DisplayController.php:83
8	Logical\Controller\DisplayController->execute()	JROOT/libraries/Logical/Controller/DispatchController.php:172
7	Logical\Controller\DispatchController->execute()	JROOT/components/com_facl/facl.php:32
6	require_once JROOT/components/com_facl/facl.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.16 ms After last query: 0.67 ms Query memory: 0.025 MB Memory before query: 4.009 MB Rows returned: 0

Duplicate queries: #27

SELECT *

  FROM jos_assets

  WHERE `name` = 'com_facl.donations'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
23	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
22	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
21	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
20	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
19	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
18	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/facluser/impostor.php:82
17	PlgSystemFacluserImpostor->authorise()	JROOT/libraries/Logical/Model/BaseModel.php:169
16	Logical\Model\BaseModel->allowAction()	JROOT/libraries/Logical/Model/RecordModel.php:93
15	Logical\Model\RecordModel->allowAction()	JROOT/administrator/components/com_facl/model/donations.php:644
14	FaclModelDonations->allowAction()	JROOT/administrator/components/com_facl/view/donations/html.php:158
13	FaclViewDonationsHtml->prepareListView()	JROOT/administrator/components/com_facl/view/donations/html.php:77
12	FaclViewDonationsHtml->prepareToRender()	JROOT/libraries/Logical/View/BaseView.php:336
11	Logical\View\BaseView->render()	JROOT/libraries/Logical/View/CollectionView.php:99
10	Logical\View\CollectionView->render()	JROOT/libraries/Logical/View/RecordView.php:152
9	Logical\View\RecordView->render()	JROOT/libraries/Logical/Controller/DisplayController.php:83
8	Logical\Controller\DisplayController->execute()	JROOT/libraries/Logical/Controller/DispatchController.php:172
7	Logical\Controller\DispatchController->execute()	JROOT/components/com_facl/facl.php:32
6	require_once JROOT/components/com_facl/facl.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.18 ms After last query: 0.98 ms Query memory: 0.026 MB Memory before query: 4.031 MB Rows returned: 1

Duplicate queries: #14 #17 #28

SELECT *

  FROM jos_facl_schemas

  WHERE asset_id = 'com_facl.donations'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/Logical/Table/Table.php:260
23	Logical\Table\Table->getFields()	JROOT/libraries/Logical/Table/Table.php:1054
22	Logical\Table\Table->getSelectQuery()	JROOT/libraries/Logical/Model/CollectionModel.php:504
21	Logical\Model\CollectionModel->getListQuery()	JROOT/administrator/components/com_facl/model/donations.php:197
20	FaclModelDonations->getListQuery()	JROOT/libraries/Logical/Model/RecordModel.php:58
19	Logical\Model\RecordModel->getItem()	JROOT/plugins/system/facluser/impostor.php:142
18	PlgSystemFacluserImpostor->getEventId()	JROOT/plugins/system/facluser/impostor.php:87
17	PlgSystemFacluserImpostor->authorise()	JROOT/libraries/Logical/Model/BaseModel.php:169
16	Logical\Model\BaseModel->allowAction()	JROOT/libraries/Logical/Model/RecordModel.php:93
15	Logical\Model\RecordModel->allowAction()	JROOT/administrator/components/com_facl/model/donations.php:644
14	FaclModelDonations->allowAction()	JROOT/administrator/components/com_facl/view/donations/html.php:158
13	FaclViewDonationsHtml->prepareListView()	JROOT/administrator/components/com_facl/view/donations/html.php:77
12	FaclViewDonationsHtml->prepareToRender()	JROOT/libraries/Logical/View/BaseView.php:336
11	Logical\View\BaseView->render()	JROOT/libraries/Logical/View/CollectionView.php:99
10	Logical\View\CollectionView->render()	JROOT/libraries/Logical/View/RecordView.php:152
9	Logical\View\RecordView->render()	JROOT/libraries/Logical/Controller/DisplayController.php:83
8	Logical\Controller\DisplayController->execute()	JROOT/libraries/Logical/Controller/DispatchController.php:172
7	Logical\Controller\DispatchController->execute()	JROOT/components/com_facl/facl.php:32
6	require_once JROOT/components/com_facl/facl.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.23 ms After last query: 0.17 ms Query memory: 0.041 MB Memory before query: 4.041 MB Rows returned: 0

Duplicate queries: #29

SELECT a.`donation_id`,a.`transaction_internal_id`,a.`event_id`,a.`sale_id`,a.`person_id`,a.`donation_status`,a.`donation_date`,a.`donation_campaign`,a.`donation_channel`,a.`donation_method`,a.`donation_amount`,a.`donation_note`,a.`donation_lead`,a.`donation_tku_date`,transaction.*,event.*

  FROM `jos_facl_donations` AS `a`

  LEFT JOIN jos_facl_transactions AS transaction 
  ON transaction.transaction_internal_id = a.transaction_internal_id

  LEFT JOIN jos_facl_events AS event 
  ON event.event_id = a.event_id

  WHERE a.donation_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/libraries/Logical/Model/RecordModel.php:65
19	Logical\Model\RecordModel->getItem()	JROOT/plugins/system/facluser/impostor.php:142
18	PlgSystemFacluserImpostor->getEventId()	JROOT/plugins/system/facluser/impostor.php:87
17	PlgSystemFacluserImpostor->authorise()	JROOT/libraries/Logical/Model/BaseModel.php:169
16	Logical\Model\BaseModel->allowAction()	JROOT/libraries/Logical/Model/RecordModel.php:93
15	Logical\Model\RecordModel->allowAction()	JROOT/administrator/components/com_facl/model/donations.php:644
14	FaclModelDonations->allowAction()	JROOT/administrator/components/com_facl/view/donations/html.php:158
13	FaclViewDonationsHtml->prepareListView()	JROOT/administrator/components/com_facl/view/donations/html.php:77
12	FaclViewDonationsHtml->prepareToRender()	JROOT/libraries/Logical/View/BaseView.php:336
11	Logical\View\BaseView->render()	JROOT/libraries/Logical/View/CollectionView.php:99
10	Logical\View\CollectionView->render()	JROOT/libraries/Logical/View/RecordView.php:152
9	Logical\View\RecordView->render()	JROOT/libraries/Logical/Controller/DisplayController.php:83
8	Logical\Controller\DisplayController->execute()	JROOT/libraries/Logical/Controller/DispatchController.php:172
7	Logical\Controller\DispatchController->execute()	JROOT/components/com_facl/facl.php:32
6	require_once JROOT/components/com_facl/facl.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.12 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 4.053 MB Rows returned: 0

Duplicate queries: #24

SELECT *

  FROM jos_assets

  WHERE `name` = 'com_facl.donations'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.01 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
23	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
22	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Access/Access.php:784
21	Joomla\CMS\Access\Access::getAssetId()	JROOT/libraries/src/Access/Access.php:544
20	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
19	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
18	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/facluser/impostor.php:82
17	PlgSystemFacluserImpostor->authorise()	JROOT/libraries/Logical/Model/BaseModel.php:169
16	Logical\Model\BaseModel->allowAction()	JROOT/libraries/Logical/Model/RecordModel.php:93
15	Logical\Model\RecordModel->allowAction()	JROOT/administrator/components/com_facl/model/donations.php:644
14	FaclModelDonations->allowAction()	JROOT/administrator/components/com_facl/view/donations/html.php:162
13	FaclViewDonationsHtml->prepareListView()	JROOT/administrator/components/com_facl/view/donations/html.php:77
12	FaclViewDonationsHtml->prepareToRender()	JROOT/libraries/Logical/View/BaseView.php:336
11	Logical\View\BaseView->render()	JROOT/libraries/Logical/View/CollectionView.php:99
10	Logical\View\CollectionView->render()	JROOT/libraries/Logical/View/RecordView.php:152
9	Logical\View\RecordView->render()	JROOT/libraries/Logical/Controller/DisplayController.php:83
8	Logical\Controller\DisplayController->execute()	JROOT/libraries/Logical/Controller/DispatchController.php:172
7	Logical\Controller\DispatchController->execute()	JROOT/components/com_facl/facl.php:32
6	require_once JROOT/components/com_facl/facl.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.12 ms After last query: 0.12 ms Query memory: 0.026 MB Memory before query: 4.060 MB Rows returned: 1

Duplicate queries: #14 #17 #25

SELECT *

  FROM jos_facl_schemas

  WHERE asset_id = 'com_facl.donations'

Explain

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

Profile

Status	Duration
starting	0.01 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
24	JDatabaseDriver->loadAssoc()	JROOT/libraries/Logical/Table/Table.php:260
23	Logical\Table\Table->getFields()	JROOT/libraries/Logical/Table/Table.php:1054
22	Logical\Table\Table->getSelectQuery()	JROOT/libraries/Logical/Model/CollectionModel.php:504
21	Logical\Model\CollectionModel->getListQuery()	JROOT/administrator/components/com_facl/model/donations.php:197
20	FaclModelDonations->getListQuery()	JROOT/libraries/Logical/Model/RecordModel.php:58
19	Logical\Model\RecordModel->getItem()	JROOT/plugins/system/facluser/impostor.php:142
18	PlgSystemFacluserImpostor->getEventId()	JROOT/plugins/system/facluser/impostor.php:87
17	PlgSystemFacluserImpostor->authorise()	JROOT/libraries/Logical/Model/BaseModel.php:169
16	Logical\Model\BaseModel->allowAction()	JROOT/libraries/Logical/Model/RecordModel.php:93
15	Logical\Model\RecordModel->allowAction()	JROOT/administrator/components/com_facl/model/donations.php:644
14	FaclModelDonations->allowAction()	JROOT/administrator/components/com_facl/view/donations/html.php:162
13	FaclViewDonationsHtml->prepareListView()	JROOT/administrator/components/com_facl/view/donations/html.php:77
12	FaclViewDonationsHtml->prepareToRender()	JROOT/libraries/Logical/View/BaseView.php:336
11	Logical\View\BaseView->render()	JROOT/libraries/Logical/View/CollectionView.php:99
10	Logical\View\CollectionView->render()	JROOT/libraries/Logical/View/RecordView.php:152
9	Logical\View\RecordView->render()	JROOT/libraries/Logical/Controller/DisplayController.php:83
8	Logical\Controller\DisplayController->execute()	JROOT/libraries/Logical/Controller/DispatchController.php:172
7	Logical\Controller\DispatchController->execute()	JROOT/components/com_facl/facl.php:32
6	require_once JROOT/components/com_facl/facl.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.20 ms After last query: 0.16 ms Query memory: 0.041 MB Memory before query: 4.071 MB Rows returned: 0

Duplicate queries: #26

SELECT a.`donation_id`,a.`transaction_internal_id`,a.`event_id`,a.`sale_id`,a.`person_id`,a.`donation_status`,a.`donation_date`,a.`donation_campaign`,a.`donation_channel`,a.`donation_method`,a.`donation_amount`,a.`donation_note`,a.`donation_lead`,a.`donation_tku_date`,transaction.*,event.*

  FROM `jos_facl_donations` AS `a`

  LEFT JOIN jos_facl_transactions AS transaction 
  ON transaction.transaction_internal_id = a.transaction_internal_id

  LEFT JOIN jos_facl_events AS event 
  ON event.event_id = a.event_id

  WHERE a.donation_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
20	JDatabaseDriver->loadObject()	JROOT/libraries/Logical/Model/RecordModel.php:65
19	Logical\Model\RecordModel->getItem()	JROOT/plugins/system/facluser/impostor.php:142
18	PlgSystemFacluserImpostor->getEventId()	JROOT/plugins/system/facluser/impostor.php:87
17	PlgSystemFacluserImpostor->authorise()	JROOT/libraries/Logical/Model/BaseModel.php:169
16	Logical\Model\BaseModel->allowAction()	JROOT/libraries/Logical/Model/RecordModel.php:93
15	Logical\Model\RecordModel->allowAction()	JROOT/administrator/components/com_facl/model/donations.php:644
14	FaclModelDonations->allowAction()	JROOT/administrator/components/com_facl/view/donations/html.php:162
13	FaclViewDonationsHtml->prepareListView()	JROOT/administrator/components/com_facl/view/donations/html.php:77
12	FaclViewDonationsHtml->prepareToRender()	JROOT/libraries/Logical/View/BaseView.php:336
11	Logical\View\BaseView->render()	JROOT/libraries/Logical/View/CollectionView.php:99
10	Logical\View\CollectionView->render()	JROOT/libraries/Logical/View/RecordView.php:152
9	Logical\View\RecordView->render()	JROOT/libraries/Logical/Controller/DisplayController.php:83
8	Logical\Controller\DisplayController->execute()	JROOT/libraries/Logical/Controller/DispatchController.php:172
7	Logical\Controller\DispatchController->execute()	JROOT/components/com_facl/facl.php:32
6	require_once JROOT/components/com_facl/facl.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.50 ms After last query: 5.36 ms Query memory: 0.027 MB Memory before query: 4.113 MB Rows returned: 0

SELECT id, alias

  FROM jos_menu

  WHERE link = 'index.php?option=com_facl&view=donations&layout=donate' 
  AND access IN (1,1,5) 
  AND published = 1

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.33 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/Logical/Application/Router.php:109
25	Logical\Application\Router->getMenuItem()	JROOT/libraries/Logical/Application/Router.php:61
24	Logical\Application\Router->BuildRoute()	JROOT/components/com_facl/router.php:24
23	FaclBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
22	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
16	Joomla\CMS\Router\Route::_()	JROOT/components/com_facl/view/donations/tmpl/default_donation_buttons.php:26
15	include JROOT/components/com_facl/view/donations/tmpl/default_donation_buttons.php	JROOT/libraries/Logical/View/BaseView.php:444
14	Logical\View\BaseView->loadTemplate()	JROOT/components/com_facl/view/donations/tmpl/default.php:30
13	include JROOT/components/com_facl/view/donations/tmpl/default.php	JROOT/libraries/Logical/View/BaseView.php:444
12	Logical\View\BaseView->loadTemplate()	JROOT/libraries/Logical/View/BaseView.php:338
11	Logical\View\BaseView->render()	JROOT/libraries/Logical/View/CollectionView.php:99
10	Logical\View\CollectionView->render()	JROOT/libraries/Logical/View/RecordView.php:152
9	Logical\View\RecordView->render()	JROOT/libraries/Logical/Controller/DisplayController.php:83
8	Logical\Controller\DisplayController->execute()	JROOT/libraries/Logical/Controller/DispatchController.php:172
7	Logical\Controller\DispatchController->execute()	JROOT/components/com_facl/facl.php:32
6	require_once JROOT/components/com_facl/facl.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.53 ms After last query: 12.99 ms Query memory: 0.032 MB Memory before query: 4.150 MB Rows returned: 5

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

  FROM jos_modules AS m

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

  LEFT JOIN jos_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-12-22 15:47:22') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-12-22 15:47:22') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 121 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

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

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.17 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
39	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
38	JDatabaseDriver->loadObjectList()	Same as call in the line below.
37	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
36	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
35	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
34	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
33	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
32	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:276
31	YOOtheme\Container->call()	JROOT/templates/yootheme/vendor/yootheme/container/src/Container.php:291
30	YOOtheme\Container->YOOtheme\{closure}()	Same as call in the line below.
29	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:86
28	YOOtheme\View->__call()	JROOT/templates/yootheme/templates/header-mobile.php:29
27	require JROOT/templates/yootheme/templates/header-mobile.php	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:274
26	YOOtheme\View->evaluate()	JROOT/templates/yootheme/vendor/yootheme/view/src/View/FileLoader.php:16
25	YOOtheme\View\FileLoader->__invoke()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:162
24	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/src/Theme/ViewHelper.php:69
23	YOOtheme\Theme\ViewHelper->YOOtheme\Theme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:162
22	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/UrlListener.php:23
21	YOOtheme\Theme\Joomla\UrlListener->resolveRelativeUrl()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:162
20	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:237
19	YOOtheme\View->render()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:69
18	YOOtheme\View->__invoke()	JROOT/templates/yootheme/templates/header.php:96
17	require JROOT/templates/yootheme/templates/header.php	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:274
16	YOOtheme\View->evaluate()	JROOT/templates/yootheme/vendor/yootheme/view/src/View/FileLoader.php:16
15	YOOtheme\View\FileLoader->__invoke()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:162
14	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/src/Theme/ViewHelper.php:69
13	YOOtheme\Theme\ViewHelper->YOOtheme\Theme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:162
12	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme-joomla/src/UrlListener.php:23
11	YOOtheme\Theme\Joomla\UrlListener->resolveRelativeUrl()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:162
10	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:237
9	YOOtheme\View->render()	JROOT/templates/yootheme/vendor/yootheme/view/src/View.php:69
8	YOOtheme\View->__invoke()	JROOT/templates/yootheme/index.php:143
7	require JROOT/templates/yootheme/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
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.]

22 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

```
4 × SELECT * 
  FROM jos_facl_schemas
```

3 × SELECT a.`donation_id`,a.`transaction_internal_id`,a.`event_id`,a.`sale_id`,a.`person_id`,a.`donation_status`,a.`donation_date`,a.`donation_campaign`,a.`donation_channel`,a.`donation_method`,a.`donation_amount`,a.`donation_note`,a.`donation_lead`,a.`donation_tku_date`,transaction.*,event.* 
  FROM `jos_facl_donations` AS `a` 
  LEFT JOIN jos_facl_transactions AS transaction 
  ON transaction.transaction_internal_id = a.transaction_internal_id 
  LEFT JOIN jos_facl_events AS event 
  ON event.event_id = a.event_id

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

```
2 × SELECT id, alias 
  FROM jos_menu
```

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `jos_assets`

```
2 × SELECT * 
  FROM jos_assets
```

1 × SELECT `data` 
  FROM `jos_session`

1 × SELECT `session_id` 
  FROM `jos_session`

1 × SELECT id, rules 
  FROM `jos_viewlevels

1 × SELECT b.id 
  FROM jos_usergroups AS a 
  LEFT JOIN jos_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 jos_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 jos_menu AS m 
  LEFT JOIN jos_extensions AS e 
  ON m.component_id = e.extension_id

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

```
1 × SELECT * 
  FROM jos_languages
```

1 × SELECT extension_id, manifest_cache 
  FROM jos_extensions

1 × SELECT COUNT(*) 
  FROM `jos_facl_donations` AS `a` 
  LEFT JOIN jos_facl_transactions AS transaction 
  ON transaction.transaction_internal_id = a.transaction_internal_id 
  LEFT JOIN jos_facl_events AS event 
  ON event.event_id = a.event_i

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

OTHER Tables:

1 × INSERT INTO `jos_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3036383865336437353266353035643562346333333438363664663962653263', 1, 1734882442, 0, '', 0

1 × UPDATE `jos_extensions` 
  SET `params` = '{\"mediaversion\":\"2f0b558a18a5fc5a1de1f9b389dda3d3\"}'

1 × SHOW FULL COLUMNS 
  FROM `jos_facl_donations

1 × UPDATE jos_facl_schemas 
  SET fields = '{\"donation_id\":{\"Field\":\"donation_id\",\"Type\":\"int\",\"Collation\":null,\"Null\":\"NO\",\"Key\":\"PRI\",\"Default\":null,\"Extra\":\"auto_increment\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"transaction_internal_id\":{\"Field\":\"transaction_internal_id\",\"Type\":\"int\",\"Collation\":null,\"Null\":\"NO\",\"Key\":\"\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"event_id\":{\"Field\":\"event_id\",\"Type\":\"int\",\"Collation\":null,\"Null\":\"NO\",\"Key\":\"MUL\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"sale_id\":{\"Field\":\"sale_id\",\"Type\":\"int\",\"Collation\":null,\"Null\":\"NO\",\"Key\":\"MUL\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"person_id\":{\"Field\":\"person_id\",\"Type\":\"int\",\"Collation\":null,\"Null\":\"NO\",\"Key\":\"MUL\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_status\":{\"Field\":\"donation_status\",\"Type\":\"enum(\'PENDING\',\'COMPLETE\',\'REFUNDED\',\'DELETED\')\",\"Collation\":\"utf8mb4_unicode_ci\",\"Null\":\"NO\",\"Key\":\"\",\"Default\":\"PENDING\",\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_date\":{\"Field\":\"donation_date\",\"Type\":\"datetime\",\"Collation\":null,\"Null\":\"NO\",\"Key\":\"\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_campaign\":{\"Field\":\"donation_campaign\",\"Type\":\"varchar(255)\",\"Collation\":\"utf8mb4_unicode_ci\",\"Null\":\"NO\",\"Key\":\"\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_channel\":{\"Field\":\"donation_channel\",\"Type\":\"enum(\'MAIL\',\'PHONE\',\'IN_PERSON\',\'ONLINE\',\'FB\',\'UNKNOWN\')\",\"Collation\":\"utf8mb4_unicode_ci\",\"Null\":\"NO\",\"Key\":\"\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_method\":{\"Field\":\"donation_method\",\"Type\":\"enum(\'CASH\',\'CHECK\',\'CREDIT\',\'EXTERNAL\',\'PLEDGE\',\'NON_MONETARY_RESPONSE\',\'UNKNOWN\')\",\"Collation\":\"utf8mb4_unicode_ci\",\"Null\":\"NO\",\"Key\":\"\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_amount\":{\"Field\":\"donation_amount\",\"Type\":\"decimal(12,2)\",\"Collation\":null,\"Null\":\"NO\",\"Key\":\"\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_note\":{\"Field\":\"donation_note\",\"Type\":\"text\",\"Collation\":\"utf8mb4_unicode_ci\",\"Null\":\"NO\",\"Key\":\"\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_lead\":{\"Field\":\"donation_lead\",\"Type\":\"enum(\'YES\',\'NO\')\",\"Collation\":\"utf8mb4_unicode_ci\",\"Null\":\"NO\",\"Key\":\"\",\"Default\":\"NO\",\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"},\"donation_tku_date\":{\"Field\":\"donation_tku_date\",\"Type\":\"datetime\",\"Collation\":null,\"Null\":\"YES\",\"Key\":\"\",\"Default\":null,\"Extra\":\"\",\"Privileges\":\"select,insert,update,references\",\"Comment\":\"\"}}'  , cached_on = '2024-12-22 15:47:22'

1 × SHOW FULL COLUMNS 
  FROM `jos_assets

All gifts to Foundation for Applied Conservative Leadership are 100% TAX-DEDUCTIBLE.

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

31 Queries Logged 121.74 ms

8 duplicate found!

22 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: