Innovation skills training in a lifelong learning programme for unemployed people, in Catalonia (Spain)

Mara, Liviu Catalin; Brunet, Ignasi; Olivé, Joan Cabré
Abstract:: Innovation skills are valuable in the context of knowledge-based economy and they are present in many political agendas. This article adopts the European Union’s perspective of lifelong learning and the role of innovation in the Strategic Framework - Education and Training 2020, and it intends to explore innovation training in a lifelong learning programme for unemployed in Catalonia (Spain). The study analyses quantitative and qualitative data of the 281 responses from students who have studied, or they were studying in the programme, in 2016. Through the exploration of the innovation skills we identified the following groups: new tools, innovative sectors, new methodologies, new work processes and ICT skills. The study also identified two types of strategies that favour training of the innovation skills, promoted either by the expert who teaches or by the centre’s work philosophy. Finally, we discuss limitations and future research in this line.
Year:: 2020
Type of Publication:: Article
Keywords:: innovation; skills; lifelong learning; knowledge based economy; online questionaire
Journal:: Innovation: The European Journal of Social Science Research
DOI:: https://doi.org/10.1080/13511610.2020.1774353

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1675523409,
                "last": 1675523409,
                "now": 1675523409
            },
            "token": "ioa0RGBbLGPla8NAlFiug7MTFdyfzvQW"
        },
        "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
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        }
    },
    "__jresearch": {
        "citedRecords": []
    },
    "__com_jresearch": {
        "publication": {
            "596": {
                "visited": true
            }
        }
    }
}

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

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

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f75oq_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 `f75oq_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3063653665646236303737373461363339396466336536373634643637303263', 1, 1675523409, 0, '', 0)

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.01 ms
update	0.12 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	1.03 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.98 ms After last query: 16.38 ms Query memory: 0.020 MB Memory before query: 1.423 MB Rows returned: 4

SELECT id, rules

  FROM `f75oq_viewlevels`

Explain

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

Profile

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.52 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.05 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
logging slow query	0.03 ms
cleaning up	0.01 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.66 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 1.435 MB Rows returned: 1

SELECT b.id

  FROM f75oq_usergroups AS a

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

  WHERE a.id = 1

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

Profile

Status	Duration
starting	0.05 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.29 ms
init	0.01 ms
System lock	0.01 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.01 ms
closing tables	0.01 ms
freeing items	0.02 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: 1.00 ms After last query: 49.00 ms Query memory: 0.022 MB Memory before query: 2.086 MB Rows returned: 1

Duplicate queries: #7

SELECT template

  FROM f75oq_template_styles as s

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	10	10.00	Using where

Profile

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.47 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.05 ms
end	0.01 ms
query end	0.01 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
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.47 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 2.093 MB Rows returned: 1

Duplicate queries: #6

SELECT template

  FROM f75oq_template_styles as s

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	10	10.00	Using where

Profile

Status	Duration
starting	0.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 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.04 ms
preparing	0.02 ms
executing	0.05 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.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.69 ms After last query: 10.32 ms Query memory: 0.020 MB Memory before query: 2.199 MB Rows returned: 2

SELECT extension, file, type

  FROM f75oq_rokcommon_configs

  ORDER BY priority

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:131
8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.45 ms After last query: 43.55 ms Query memory: 0.021 MB Memory before query: 2.411 MB Rows returned: 1

SELECT `template`

  FROM `f75oq_template_styles`

  WHERE `client_id` = 0 
  AND `home` = 1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f75oq_template_styles	NULL	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	10	10.00	Using where

Profile

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

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helix3/helix3.php:240
9	plgSystemHelix3->getTemplateName()	JROOT/plugins/system/helix3/helix3.php:38
8	plgSystemHelix3->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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: 4.74 ms After last query: 27.59 ms Query memory: 0.023 MB Memory before query: 2.744 MB Rows returned: 18

SHOW FULL COLUMNS 
  FROM `f75oq_extensions`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
11	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
10	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:328
9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.75 ms After last query: 1.32 ms Query memory: 0.021 MB Memory before query: 2.773 MB Rows returned: 1

SELECT `extension_id`

  FROM `f75oq_extensions`

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

Explain

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

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.34 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.02 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
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:47
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.51 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 2.780 MB Rows returned: 1

Duplicate queries: #14

SELECT *

  FROM f75oq_extensions

  WHERE `extension_id` = '10041'

Explain

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

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 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.01 ms

Call Stack

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

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

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

SELECT `extension_id`

  FROM `f75oq_extensions`

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

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.02 ms
end	0.02 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
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:70
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.31 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 2.790 MB Rows returned: 1

Duplicate queries: #12

SELECT *

  FROM f75oq_extensions

  WHERE `extension_id` = '10041'

Explain

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

Profile

Status	Duration
starting	0.02 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 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.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.25 ms After last query: 116.59 ms Query memory: 0.022 MB Memory before query: 3.130 MB Rows returned: 0

SELECT *

  FROM f75oq_menu

  WHERE alias ='en' 
  AND published=1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f75oq_menu	NULL	ref	idx_alias	idx_alias	402	const	1	10.00	Using where

Profile

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.61 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.02 ms
executing	0.04 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.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/plugins/system/t4/src/t4/MVC/Router/T4.php:346
11	T4\MVC\Router\T4->getMenuByAlias()	JROOT/plugins/system/t4/src/t4/MVC/Router/T4.php:133
10	T4\MVC\Router\T4->parseRule()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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.47 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 3.136 MB Rows returned: 0

SELECT *

  FROM f75oq_menu

  WHERE alias ='members-list.html' 
  AND published=1

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f75oq_menu	NULL	ref	idx_alias	idx_alias	402	const	1	10.00	Using where

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	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.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.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/plugins/system/t4/src/t4/MVC/Router/T4.php:346
11	T4\MVC\Router\T4->getMenuByAlias()	JROOT/plugins/system/t4/src/t4/MVC/Router/T4.php:133
10	T4\MVC\Router\T4->parseRule()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
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.81 ms After last query: 51.38 ms Query memory: 0.023 MB Memory before query: 3.540 MB Rows returned: 2

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

  FROM f75oq_template_styles AS s

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

  ORDER BY s.id

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	const	2	76.92	Using where

Profile

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

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/gantry5/src/classes/Gantry/Joomla/StyleHelper.php:69
14	Gantry\Joomla\StyleHelper::loadStyles()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Assignments.php:63
13	Gantry\Framework\Assignments->loadAssignments()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:301
12	Gantry\Component\Assignments\AbstractAssignments->init()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:99
11	Gantry\Component\Assignments\AbstractAssignments->scores()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Assignments/AbstractAssignments.php:86
10	Gantry\Component\Assignments\AbstractAssignments->select()	JROOT/plugins/system/gantry5/gantry5.php:315
9	plgSystemGantry5->onAfterRouteSite()	JROOT/plugins/system/gantry5/gantry5.php:108
8	plgSystemGantry5->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php: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: 1.74 ms After last query: 13.50 ms Query memory: 0.006 MB Memory before query: 3.618 MB

UPDATE `f75oq_extensions`

  SET `params` = '{\"mediaversion\":\"66515f7fdcdc091eb5158e61f606f6bf\"}'

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

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:376
8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.89 ms After last query: 16.30 ms Query memory: 0.022 MB Memory before query: 3.761 MB Rows returned: 11

SELECT * 
  FROM f75oq_rokcandy 
  WHERE published=1

Explain

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

Profile

Status	Duration
starting	0.07 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.33 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.04 ms
freeing items	0.02 ms
logging slow query	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:27
13	RokCandyHelper::getUserMacros()	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/Cache/Controller/CallbackController.php:45
10	Joomla\CMS\Cache\Controller\CallbackController->call()	JROOT/administrator/components/com_rokcandy/helpers/rokcandy.php:17
9	RokCandyHelper::getMacros()	JROOT/plugins/system/rokcandy/rokcandy.php:28
8	plgSystemRokCandy->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 6.29 ms After last query: 31.39 ms Query memory: 0.026 MB Memory before query: 3.965 MB Rows returned: 66

SHOW FULL COLUMNS 
  FROM `f75oq_jresearch_publication`

Explain

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

Profile

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	2.81 ms
init	0.04 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.06 ms
Creating tmp table	0.07 ms
executing	0.14 ms
checking permissions	0.09 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.06 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.06 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.19 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.03 ms
freeing items	0.09 ms
cleaning up	0.01 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/src/Table/Table.php:261
17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
16	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jresearch/tables/activity.php:156
15	JResearchActivity->__construct()	JROOT/administrator/components/com_jresearch/tables/publication.php:135
14	JResearchPublication->__construct()	JROOT/libraries/src/Table/Table.php:328
13	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jresearch/models/modelform.php:58
12	JResearchModelForm->getTable()	JROOT/components/com_jresearch/models/publications/publication.php:26
11	JResearchModelPublication->getItem()	JROOT/components/com_jresearch/views/publication/view.html.php:61
10	JResearchViewPublication->_displayPublication()	JROOT/components/com_jresearch/views/publication/view.html.php:35
9	JResearchViewPublication->display()	JROOT/components/com_jresearch/controllers/publications.php:209
8	JResearchPublicationsController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jresearch/jresearch.php:58
6	require_once JROOT/components/com_jresearch/jresearch.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.86 ms After last query: 0.29 ms Query memory: 0.040 MB Memory before query: 4.059 MB Rows returned: 1

SELECT *

  FROM f75oq_jresearch_publication

  WHERE `id` = '596'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
13	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_jresearch/tables/publication.php:182
12	JResearchPublication->load()	JROOT/components/com_jresearch/models/publications/publication.php:27
11	JResearchModelPublication->getItem()	JROOT/components/com_jresearch/views/publication/view.html.php:61
10	JResearchViewPublication->_displayPublication()	JROOT/components/com_jresearch/views/publication/view.html.php:35
9	JResearchViewPublication->display()	JROOT/components/com_jresearch/controllers/publications.php:209
8	JResearchPublicationsController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jresearch/jresearch.php:58
6	require_once JROOT/components/com_jresearch/jresearch.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.09 ms After last query: 2.44 ms Query memory: 0.023 MB Memory before query: 4.059 MB Rows returned: 3

SELECT `id` 
  FROM 
        (SELECT `id_staff_member` as id, `
  order` 
  FROM f75oq_jresearch_publication_internal_author 
        
  WHERE `id_publication` = '596' UNION 
        (SELECT `author_name` as id, `
  order` 
  FROM f75oq_jresearch_publication_external_author
        
  WHERE `id_publication` = '596')) R1 
  order by R1.`
  order`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	<derived2>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	100.00	Using filesort
2	DERIVED	f75oq_jresearch_publication_internal_author	NULL	ref	PRIMARY	PRIMARY	4	const	2	100.00	NULL
3	UNION	f75oq_jresearch_publication_external_author	NULL	ref	PRIMARY	PRIMARY	4	const	1	100.00	NULL
NULL	UNION RESULT	<union2,3>	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Using temporary

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.38 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.02 ms
logging slow query	0.05 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
14	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_jresearch/tables/activity.php:175
13	JResearchActivity->_loadAuthors()	JROOT/administrator/components/com_jresearch/tables/publication.php:185
12	JResearchPublication->load()	JROOT/components/com_jresearch/models/publications/publication.php:27
11	JResearchModelPublication->getItem()	JROOT/components/com_jresearch/views/publication/view.html.php:61
10	JResearchViewPublication->_displayPublication()	JROOT/components/com_jresearch/views/publication/view.html.php:35
9	JResearchViewPublication->display()	JROOT/components/com_jresearch/controllers/publications.php:209
8	JResearchPublicationsController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jresearch/jresearch.php:58
6	require_once JROOT/components/com_jresearch/jresearch.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.54 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 4.067 MB Rows returned: 1

Duplicate queries: #24

SELECT firstname, lastname 
  FROM `f75oq_jresearch_member` 
  WHERE `id` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f75oq_jresearch_member	NULL	const	PRIMARY	PRIMARY	4	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.17 ms
init	0.01 ms
System lock	0.01 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
closing tables	0.02 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_jresearch/helpers/staff.php:28
14	JResearchStaffHelper::getMemberName()	JROOT/administrator/components/com_jresearch/tables/activity.php:180
13	JResearchActivity->_loadAuthors()	JROOT/administrator/components/com_jresearch/tables/publication.php:185
12	JResearchPublication->load()	JROOT/components/com_jresearch/models/publications/publication.php:27
11	JResearchModelPublication->getItem()	JROOT/components/com_jresearch/views/publication/view.html.php:61
10	JResearchViewPublication->_displayPublication()	JROOT/components/com_jresearch/views/publication/view.html.php:35
9	JResearchViewPublication->display()	JROOT/components/com_jresearch/controllers/publications.php:209
8	JResearchPublicationsController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jresearch/jresearch.php:58
6	require_once JROOT/components/com_jresearch/jresearch.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.29 ms After last query: 0.07 ms Query memory: 0.023 MB Memory before query: 4.074 MB Rows returned: 1

Duplicate queries: #23

SELECT firstname, lastname 
  FROM `f75oq_jresearch_member` 
  WHERE `id` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f75oq_jresearch_member	NULL	const	PRIMARY	PRIMARY	4	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.01 ms
Opening tables	0.01 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
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
15	JDatabaseDriver->loadAssoc()	JROOT/administrator/components/com_jresearch/helpers/staff.php:28
14	JResearchStaffHelper::getMemberName()	JROOT/administrator/components/com_jresearch/tables/activity.php:180
13	JResearchActivity->_loadAuthors()	JROOT/administrator/components/com_jresearch/tables/publication.php:185
12	JResearchPublication->load()	JROOT/components/com_jresearch/models/publications/publication.php:27
11	JResearchModelPublication->getItem()	JROOT/components/com_jresearch/views/publication/view.html.php:61
10	JResearchViewPublication->_displayPublication()	JROOT/components/com_jresearch/views/publication/view.html.php:35
9	JResearchViewPublication->display()	JROOT/components/com_jresearch/controllers/publications.php:209
8	JResearchPublicationsController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jresearch/jresearch.php:58
6	require_once JROOT/components/com_jresearch/jresearch.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.78 ms After last query: 0.11 ms Query memory: 0.006 MB Memory before query: 4.084 MB

UPDATE f75oq_jresearch_publication

  SET `hits` = (`hits` + 1)

  WHERE `id` = '596'

Explain

EXPLAIN not possible on query: UPDATE f75oq_jresearch_publication SET `hits` = (`hits` + 1) WHERE `id` = '596'

Profile

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

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1264
11	Joomla\CMS\Table\Table->hit()	JROOT/components/com_jresearch/views/publication/view.html.php:79
10	JResearchViewPublication->_displayPublication()	JROOT/components/com_jresearch/views/publication/view.html.php:35
9	JResearchViewPublication->display()	JROOT/components/com_jresearch/controllers/publications.php:209
8	JResearchPublicationsController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jresearch/jresearch.php:58
6	require_once JROOT/components/com_jresearch/jresearch.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.78 ms After last query: 4.04 ms Query memory: 0.025 MB Memory before query: 4.119 MB Rows returned: 17

SELECT * 
  FROM `f75oq_jresearch_publication_type`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f75oq_jresearch_publication_type	NULL	index	NULL	PRIMARY	62	NULL	17	100.00	Using index

Profile

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.33 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	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:1550
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_jresearch/helpers/exporters/bibtex.php:145
16	JResearchPublicationBibtexExporter->_getSupportedTypes()	JROOT/administrator/components/com_jresearch/helpers/exporters/bibtex.php:81
15	JResearchPublicationBibtexExporter->parseSingle()	JROOT/administrator/components/com_jresearch/helpers/exporters/bibtex.php:47
14	JResearchPublicationBibtexExporter->parse()	JROOT/components/com_jresearch/views/publication/tmpl/default.php:22
13	include JROOT/components/com_jresearch/views/publication/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jresearch/views/publication/view.html.php:111
10	JResearchViewPublication->_displayPublication()	JROOT/components/com_jresearch/views/publication/view.html.php:35
9	JResearchViewPublication->display()	JROOT/components/com_jresearch/controllers/publications.php:209
8	JResearchPublicationsController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jresearch/jresearch.php:58
6	require_once JROOT/components/com_jresearch/jresearch.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: 4.80 ms After last query: 0.09 ms Query memory: 0.027 MB Memory before query: 4.132 MB Rows returned: 29

SHOW FULL COLUMNS 
  FROM `f75oq_jresearch_member`

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
22	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
21	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
20	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jresearch/tables/member.php:186
19	JResearchMember->__construct()	JROOT/libraries/src/Table/Table.php:328
18	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_jresearch/tables/activity.php:217
17	JResearchActivity->getAuthorsFromFields()	JROOT/administrator/components/com_jresearch/tables/activity.php:239
16	JResearchActivity->getAuthors()	JROOT/administrator/components/com_jresearch/helpers/exporters/bibtex.php:89
15	JResearchPublicationBibtexExporter->parseSingle()	JROOT/administrator/components/com_jresearch/helpers/exporters/bibtex.php:47
14	JResearchPublicationBibtexExporter->parse()	JROOT/components/com_jresearch/views/publication/tmpl/default.php:22
13	include JROOT/components/com_jresearch/views/publication/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jresearch/views/publication/view.html.php:111
10	JResearchViewPublication->_displayPublication()	JROOT/components/com_jresearch/views/publication/view.html.php:35
9	JResearchViewPublication->display()	JROOT/components/com_jresearch/controllers/publications.php:209
8	JResearchPublicationsController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jresearch/jresearch.php:58
6	require_once JROOT/components/com_jresearch/jresearch.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.85 ms After last query: 0.18 ms Query memory: 0.026 MB Memory before query: 4.176 MB Rows returned: 1

SELECT *

  FROM f75oq_jresearch_member

  WHERE `id` = '11'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
18	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_jresearch/tables/activity.php:218
17	JResearchActivity->getAuthorsFromFields()	JROOT/administrator/components/com_jresearch/tables/activity.php:239
16	JResearchActivity->getAuthors()	JROOT/administrator/components/com_jresearch/helpers/exporters/bibtex.php:89
15	JResearchPublicationBibtexExporter->parseSingle()	JROOT/administrator/components/com_jresearch/helpers/exporters/bibtex.php:47
14	JResearchPublicationBibtexExporter->parse()	JROOT/components/com_jresearch/views/publication/tmpl/default.php:22
13	include JROOT/components/com_jresearch/views/publication/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jresearch/views/publication/view.html.php:111
10	JResearchViewPublication->_displayPublication()	JROOT/components/com_jresearch/views/publication/view.html.php:35
9	JResearchViewPublication->display()	JROOT/components/com_jresearch/controllers/publications.php:209
8	JResearchPublicationsController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jresearch/jresearch.php:58
6	require_once JROOT/components/com_jresearch/jresearch.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.85 ms After last query: 0.17 ms Query memory: 0.026 MB Memory before query: 4.191 MB Rows returned: 1

SELECT *

  FROM f75oq_jresearch_member

  WHERE `id` = '1'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f75oq_jresearch_member	NULL	const	PRIMARY	PRIMARY	4	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.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.04 ms
end	0.00 ms
query end	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
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
19	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
18	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_jresearch/tables/activity.php:218
17	JResearchActivity->getAuthorsFromFields()	JROOT/administrator/components/com_jresearch/tables/activity.php:239
16	JResearchActivity->getAuthors()	JROOT/administrator/components/com_jresearch/helpers/exporters/bibtex.php:89
15	JResearchPublicationBibtexExporter->parseSingle()	JROOT/administrator/components/com_jresearch/helpers/exporters/bibtex.php:47
14	JResearchPublicationBibtexExporter->parse()	JROOT/components/com_jresearch/views/publication/tmpl/default.php:22
13	include JROOT/components/com_jresearch/views/publication/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jresearch/views/publication/view.html.php:111
10	JResearchViewPublication->_displayPublication()	JROOT/components/com_jresearch/views/publication/view.html.php:35
9	JResearchViewPublication->display()	JROOT/components/com_jresearch/controllers/publications.php:209
8	JResearchPublicationsController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jresearch/jresearch.php:58
6	require_once JROOT/components/com_jresearch/jresearch.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.82 ms After last query: 0.23 ms Query memory: 0.025 MB Memory before query: 4.204 MB Rows returned: 45

SELECT * 
  FROM `f75oq_jresearch_property`

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f75oq_jresearch_property	NULL	index	NULL	PRIMARY	122	NULL	45	100.00	Using index

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.23 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	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:1550
17	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_jresearch/helpers/exporters/bibtex.php:122
16	JResearchPublicationBibtexExporter->_getSupportedFields()	JROOT/administrator/components/com_jresearch/helpers/exporters/bibtex.php:92
15	JResearchPublicationBibtexExporter->parseSingle()	JROOT/administrator/components/com_jresearch/helpers/exporters/bibtex.php:47
14	JResearchPublicationBibtexExporter->parse()	JROOT/components/com_jresearch/views/publication/tmpl/default.php:22
13	include JROOT/components/com_jresearch/views/publication/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jresearch/views/publication/view.html.php:111
10	JResearchViewPublication->_displayPublication()	JROOT/components/com_jresearch/views/publication/view.html.php:35
9	JResearchViewPublication->display()	JROOT/components/com_jresearch/controllers/publications.php:209
8	JResearchPublicationsController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jresearch/jresearch.php:58
6	require_once JROOT/components/com_jresearch/jresearch.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.50 ms After last query: 0.90 ms Query memory: 0.026 MB Memory before query: 4.224 MB Rows returned: 44

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

  FROM `f75oq_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_attachments','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_djimageslider','com_fields','com_finder','com_gantry5','com_installer','com_j2xml','com_joomlaupdate','com_jresearch','com_k2','com_k2import','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_rokcandy','com_roksprocket','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper')

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f75oq_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	45	100.00	Using index condition

Profile

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.47 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.13 ms
preparing	0.02 ms
executing	0.32 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.03 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:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
15	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_jresearch/helpers/access.php:31
14	JResearchAccessHelper::getActions()	JROOT/components/com_jresearch/views/publication/tmpl/default.php:23
13	include JROOT/components/com_jresearch/views/publication/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jresearch/views/publication/view.html.php:111
10	JResearchViewPublication->_displayPublication()	JROOT/components/com_jresearch/views/publication/view.html.php:35
9	JResearchViewPublication->display()	JROOT/components/com_jresearch/controllers/publications.php:209
8	JResearchPublicationsController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jresearch/jresearch.php:58
6	require_once JROOT/components/com_jresearch/jresearch.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.80 ms After last query: 6.25 ms Query memory: 0.023 MB Memory before query: 4.365 MB Rows returned: 0

SELECT id, name, published 
  FROM f75oq_jresearch_research_area 
  WHERE id IN (1) 
  AND id > 1

Explain

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

Profile

Status	Duration
starting	0.10 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.33 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
executing	0.01 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jresearch/tables/activity.php:509
14	JResearchActivity->getResearchAreas()	JROOT/components/com_jresearch/views/publication/tmpl/default.php:50
13	include JROOT/components/com_jresearch/views/publication/tmpl/default.php	JROOT/libraries/src/MVC/View/HtmlView.php:701
12	Joomla\CMS\MVC\View\HtmlView->loadTemplate()	JROOT/libraries/src/MVC/View/HtmlView.php:230
11	Joomla\CMS\MVC\View\HtmlView->display()	JROOT/components/com_jresearch/views/publication/view.html.php:111
10	JResearchViewPublication->_displayPublication()	JROOT/components/com_jresearch/views/publication/view.html.php:35
9	JResearchViewPublication->display()	JROOT/components/com_jresearch/controllers/publications.php:209
8	JResearchPublicationsController->show()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_jresearch/jresearch.php:58
6	require_once JROOT/components/com_jresearch/jresearch.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.25 ms After last query: 2.36 ms Query memory: 0.022 MB Memory before query: 4.364 MB Rows returned: 1

SELECT language,id

  FROM `f75oq_menu`

  WHERE home = 1 
  AND published = 1 
  AND client_id = 0

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f75oq_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	127	1.00	Using where

Profile

Status	Duration
starting	0.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.74 ms
end	0.01 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.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
9	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/Multilanguage.php:107
8	Joomla\CMS\Language\Multilanguage::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:751
7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/SiteApplication.php:199
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php: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.07 ms After last query: 157.58 ms Query memory: 0.035 MB Memory before query: 5.303 MB Rows returned: 8

SELECT `a`.`menutype`,`a`.`title`

  FROM `f75oq_menu_types` AS `a`

  WHERE `a`.`client_id` = 0

Explain

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

Profile

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.47 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 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.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
44	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
43	JDatabaseDriver->loadAssocList()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138
42	Gantry\Framework\Menu->getMenuOptions()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:115
41	Gantry\Framework\Menu->getMenus()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Menu/AbstractMenu.php:274
40	Gantry\Component\Menu\AbstractMenu->instance()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:702
39	Twig\Template->getAttribute()	JROOT/logs/gantry5/g5_hydrogen/twig/94/940a3a68475bf59c96f6a33f3e06b2524e96bc0e3450b576208b81ef897d6342.php:32
38	__TwigTemplate_c75f571f9ac50d58105c71d45ddd7f63822a59a7a33fbdbe7532b8351dd0de1b->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
36	Twig\Template->display()	JROOT/logs/gantry5/g5_hydrogen/twig/1c/1ce3096772910767c12a62ad47d005d4b52e19265373f98cf82ba7fbf5f76581.php:85
35	__TwigTemplate_6f0c1a5db7e4e68f2505044393aefb8285f7bc60a05180e6ca50a2aac0c8e0ff->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
33	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
32	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
30	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825
28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:700
21	Twig\Template->getAttribute()	JROOT/logs/gantry5/g5_hydrogen/twig/9a/9aa4be2c79e95009b4ff6ed39000078616560767aaac92e63c95127e0d17042a.php:47
20	__TwigTemplate_4a21d6e91bc238aa51d7755770265dbae59c32d7d10d55f89c7d0607235544fe->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
18	Twig\Template->display()	JROOT/logs/gantry5/g5_hydrogen/twig/9f/9fdf820a97d8f11266ec4837f20e7e9704466287405cec60ba4804312583ab43.php:35
17	__TwigTemplate_78bf7ae53dd9ebd8134db8bde3215fc8c0238529f665265d19eea7970b97a507->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
15	Twig\Template->display()	JROOT/logs/gantry5/g5_hydrogen/twig/ba/bab96452dff626db5b9bf8c87db4c350eea54d92988290b948e6289de13f0e76.php:35
14	__TwigTemplate_08d6e4429705492892fdf088bbc7981e1c5b9a597b7679271958daa67a087786->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
12	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
11	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_hydrogen/index.php:35
7	require JROOT/templates/g5_hydrogen/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.]

Query Time: 0.53 ms After last query: 2.29 ms Query memory: 0.035 MB Memory before query: 5.329 MB Rows returned: 9

SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id

  FROM f75oq_menu AS m

  WHERE m.menutype = 'mainmenu' 
  AND m.parent_id > 0 
  AND m.client_id = 0 
  AND m.published >= 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	ref	idx_client_id_parent_id_alias_language,idx_menutype	idx_menutype	98	const	9	22.46	Using where; Using filesort

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 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.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
45	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
44	JDatabaseDriver->loadAssocList()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791
43	Gantry\Framework\Menu->getMenuItemIds()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:310
42	Gantry\Framework\Menu->getItemsFromPlatform()	JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:753
41	Gantry\Framework\Menu->getList()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Menu/AbstractMenu.php:316
40	Gantry\Component\Menu\AbstractMenu->instance()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:702
39	Twig\Template->getAttribute()	JROOT/logs/gantry5/g5_hydrogen/twig/94/940a3a68475bf59c96f6a33f3e06b2524e96bc0e3450b576208b81ef897d6342.php:32
38	__TwigTemplate_c75f571f9ac50d58105c71d45ddd7f63822a59a7a33fbdbe7532b8351dd0de1b->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
37	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
36	Twig\Template->display()	JROOT/logs/gantry5/g5_hydrogen/twig/1c/1ce3096772910767c12a62ad47d005d4b52e19265373f98cf82ba7fbf5f76581.php:85
35	__TwigTemplate_6f0c1a5db7e4e68f2505044393aefb8285f7bc60a05180e6ca50a2aac0c8e0ff->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
34	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
33	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
32	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
31	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
30	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
29	Gantry\Component\Theme\AbstractTheme->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825
28	Gantry\Framework\Theme->getContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718
27	Gantry\Framework\Theme->renderContent()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643
26	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
25	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
24	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627
23	Gantry\Framework\Theme->prepareLayout()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468
22	Gantry\Framework\Theme->segments()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:700
21	Twig\Template->getAttribute()	JROOT/logs/gantry5/g5_hydrogen/twig/9a/9aa4be2c79e95009b4ff6ed39000078616560767aaac92e63c95127e0d17042a.php:47
20	__TwigTemplate_4a21d6e91bc238aa51d7755770265dbae59c32d7d10d55f89c7d0607235544fe->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
19	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
18	Twig\Template->display()	JROOT/logs/gantry5/g5_hydrogen/twig/9f/9fdf820a97d8f11266ec4837f20e7e9704466287405cec60ba4804312583ab43.php:35
17	__TwigTemplate_78bf7ae53dd9ebd8134db8bde3215fc8c0238529f665265d19eea7970b97a507->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
16	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
15	Twig\Template->display()	JROOT/logs/gantry5/g5_hydrogen/twig/ba/bab96452dff626db5b9bf8c87db4c350eea54d92988290b948e6289de13f0e76.php:35
14	__TwigTemplate_08d6e4429705492892fdf088bbc7981e1c5b9a597b7679271958daa67a087786->doDisplay()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453
13	Twig\Template->displayWithErrorHandling()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420
12	Twig\Template->display()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432
11	Twig\Template->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47
10	Twig\TemplateWrapper->render()	JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384
9	Twig\Environment->render()	JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176
8	Gantry\Component\Theme\AbstractTheme->render()	JROOT/templates/g5_hydrogen/index.php:35
7	require JROOT/templates/g5_hydrogen/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.]

29 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

2 × SELECT template 
  FROM f75oq_template_styles as s

2 × SELECT `extension_id` 
  FROM `f75oq_extensions`

```
2 × SELECT * 
  FROM f75oq_extensions
```
```
2 × SELECT * 
  FROM f75oq_menu
```

2 × SELECT firstname, lastname 
  FROM `f75oq_jresearch_member`

2 × SELECT * 
  FROM f75oq_jresearch_member

1 × SELECT `data` 
  FROM `f75oq_session`

1 × SELECT `session_id` 
  FROM `f75oq_session`

1 × SELECT id, rules 
  FROM `f75oq_viewlevels

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

1 × SELECT extension, file, type 
  FROM f75oq_rokcommon_configs

1 × SELECT `template` 
  FROM `f75oq_template_styles`

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

```
1 × SELECT * 
  FROM f75oq_rokcandy
```

1 × SELECT * 
  FROM f75oq_jresearch_publication

1 × SELECT `id` 
  FROM          (SELECT `id_staff_member` as id, `
  order` 
  FROM f75oq_jresearch_publication_internal_author

1 × SELECT * 
  FROM `f75oq_jresearch_publication_type

1 × SELECT * 
  FROM `f75oq_jresearch_property

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

1 × SELECT id, name, published 
  FROM f75oq_jresearch_research_area

1 × SELECT language,id 
  FROM `f75oq_menu`

1 × SELECT `a`.`menutype`,`a`.`title` 
  FROM `f75oq_menu_types` AS `a`

1 × SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id 
  FROM f75oq_menu AS m

OTHER Tables:

1 × INSERT INTO `f75oq_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'3063653665646236303737373461363339396466336536373634643637303263', 1, 1675523409, 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `f75oq_extensions

1 × UPDATE `f75oq_extensions` 
  SET `params` = '{\"mediaversion\":\"66515f7fdcdc091eb5158e61f606f6bf\"}'

1 × SHOW FULL COLUMNS 
  FROM `f75oq_jresearch_publication

1 × UPDATE f75oq_jresearch_publication 
  SET `hits` = (`hits` + 1)

1 × SHOW FULL COLUMNS 
  FROM `f75oq_jresearch_member

Innovation skills training in a lifelong learning programme for unemployed people, in Catalonia (Spain)

Joomla! Debug Console

Session

Profile Information

Time

Memory

Memory Usage

Database Queries

35 Queries Logged 43.97 ms

6 duplicate found!

29 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

OTHER Tables: