Mara, Liviu Catalin

Personal Information

Position:

Researchers in training

Research areas:

Uncategorized

Location:

Tarragona

Description:

PhD student . BA in Political Science and Public Administration from the University of Granada and Master of Research in Sociology from the University of Barcelona. He's doing a PhD on innovation in SMEs.

Publications

Mara, L. C., Cascón-Pereira, R. & Brunet, I. (2022). Perceptions of empowerment and motivation as outcomes of a continuing vocational education and training (CVET) programme for adults. Education + Training, . [More] [DOI]

Mara, L. C., Ginieis, M. & Brunet, I. (2021). Strategies for Coping with LGBT Discrimination at Work: a Systematic Literature Review. Sex Res Soc Policy, (18), 339–354. [More] [DOI]

Mara, L. C., Brunet, I. & Olivé, J. C. (2020). Innovation skills training in a lifelong learning programme for unemployed people, in Catalonia (Spain). Innovation: The European Journal of Social Science Research, . [More] [DOI]

M., P. C., Mara, L. C., Vladia, I. & Teresa, S.-M. (2020). Social Impact of Psychological Research on Well-Being Shared in Social Media. Frontiers in Psychology, 11, 135. [More] [DOI]

Diez-Palomar, J. & Mara, L. C. (2020). Mathematics makes you feel attractive: Empowering new alternative masculinities in the context of mathematics classroom. Masculinities & Social Change, 9(1), 53-84. [More] [DOI]

[View All]

Projects

Vocational training and SMEs: the challenge of innovation in Catalonia

Personal page

http://www.analisisocial.org

Back

Joomla! Debug Console

Session

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1675520886,
                "last": 1675520886,
                "now": 1675520886
            },
            "token": "WRxU7vVZ4rddLABnn7UytlWx9HOqnD8P"
        },
        "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": []
    }
}

Profile Information

Memory Usage

Database Queries

46 Queries Logged 58.22 ms

18 duplicate found!

2 duplicates: #6 #7

2 duplicates: #12 #14

6 duplicates: #20 #31 #35 #38 #41 #43

5 duplicates: #30 #34 #37 #40 #42

3 duplicates: #33 #36 #39

Query Time: 1.34 ms Query memory: 0.023 MB Memory before query: 0.815 MB Rows returned: 0

SELECT `data`

  FROM `f75oq_session`

  WHERE `session_id` = X'6164353562396566616230376535333232623865363633663463666637616431'

Explain

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

Profile

Status	Duration
starting	0.11 ms
Executing hook on transaction	0.01 ms
starting	0.03 ms
checking permissions	0.01 ms
Opening tables	0.25 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
executing	0.01 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.02 ms
cleaning up	0.01 ms

Call Stack

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

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

Query Time: 1.01 ms After last query: 0.54 ms Query memory: 0.020 MB Memory before query: 0.826 MB Rows returned: 0

SELECT `session_id`

  FROM `f75oq_session`

  WHERE `session_id` = X'6164353562396566616230376535333232623865363633663463666637616431' 
  LIMIT 1

Explain

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

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.04 ms
executing	0.01 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
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

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

Query Time: 6.01 ms After last query: 0.12 ms Query memory: 0.004 MB Memory before query: 0.831 MB

INSERT INTO `f75oq_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
(X'6164353562396566616230376535333232623865363633663463666637616431', 1, 1675520886, 0, '', 0)

Explain

EXPLAIN not possible on query: INSERT INTO `f75oq_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6164353562396566616230376535333232623865363633663463666637616431', 1, 1675520886, 0, '', 0)

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
update	0.17 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	5.45 ms
closing tables	0.04 ms
freeing items	0.03 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.60 ms After last query: 1.66 ms Query memory: 0.020 MB Memory before query: 0.905 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.04 ms
Executing hook on transaction	0.00 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.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.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.49 ms After last query: 0.17 ms Query memory: 0.021 MB Memory before query: 0.917 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.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.13 ms
init	0.00 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.02 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: 0.79 ms After last query: 8.52 ms Query memory: 0.022 MB Memory before query: 1.314 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.11 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.22 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 ms
executing	0.06 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
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.52 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 1.321 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.04 ms
Executing hook on transaction	0.01 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.05 ms
preparing	0.02 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.03 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.77 ms After last query: 1.68 ms Query memory: 0.020 MB Memory before query: 1.425 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.10 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.27 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
logging slow query	0.05 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/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: 0.72 ms After last query: 9.99 ms Query memory: 0.021 MB Memory before query: 1.509 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.11 ms
Executing hook on transaction	0.01 ms
starting	0.02 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.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.02 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: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: 3.69 ms Query memory: 0.023 MB Memory before query: 1.716 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.06 ms
Executing hook on transaction	0.04 ms
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	2.81 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.15 ms
preparing	0.05 ms
Creating tmp table	0.09 ms
executing	0.13 ms
checking permissions	0.09 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.05 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.04 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.07 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.11 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
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.76 ms After last query: 0.45 ms Query memory: 0.021 MB Memory before query: 1.745 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.05 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.22 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.11 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.02 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: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.65 ms After last query: 0.13 ms Query memory: 0.021 MB Memory before query: 1.751 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.09 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.03 ms
statistics	0.07 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.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.41 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 1.756 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.09 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: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.42 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 1.762 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.03 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.04 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: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: 0.93 ms After last query: 80.31 ms Query memory: 0.022 MB Memory before query: 1.973 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.13 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.30 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 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.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.38 ms After last query: 0.11 ms Query memory: 0.022 MB Memory before query: 1.979 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.03 ms
preparing	0.01 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.00 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.65 ms After last query: 7.64 ms Query memory: 0.023 MB Memory before query: 2.124 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.12 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.02 ms
statistics	0.09 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
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.62 ms After last query: 3.86 ms Query memory: 0.006 MB Memory before query: 2.137 MB

UPDATE `f75oq_extensions`

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

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

Explain

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

Profile

Status	Duration
starting	0.12 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.08 ms
updating	0.14 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.89 ms
closing tables	0.06 ms
freeing items	0.05 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: 4.90 ms After last query: 10.22 ms Query memory: 0.025 MB Memory before query: 2.269 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.15 ms
Executing hook on transaction	0.01 ms
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	3.07 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.12 ms
preparing	0.03 ms
Creating tmp table	0.06 ms
executing	0.12 ms
checking permissions	0.09 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.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.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.03 ms
checking permissions	0.02 ms
checking permissions	0.07 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jresearch/tables/member.php:186
14	JResearchMember->__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/staff/member.php:26
11	JResearchModelMember->getItem()	JROOT/components/com_jresearch/views/member/view.html.php:100
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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.26 ms Query memory: 0.023 MB Memory before query: 2.311 MB Rows returned: 1

Duplicate queries: #31 #35 #38 #41 #43

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.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.25 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 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
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
13	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
12	Joomla\CMS\Table\Table->load()	JROOT/components/com_jresearch/models/staff/member.php:27
11	JResearchModelMember->getItem()	JROOT/components/com_jresearch/views/member/view.html.php:100
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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.70 ms After last query: 0.75 ms Query memory: 0.039 MB Memory before query: 2.320 MB Rows returned: 5

SELECT p.* 
  FROM `f75oq_jresearch_publication_internal_author` ia JOIN `f75oq_jresearch_publication` p 
  WHERE `p`.`id` = `ia`.`id_publication`  
  AND `ia`.`id_staff_member` = '11' 
  AND p.published = '1' 
  AND p.internal =  '1' 
  ORDER BY `p`.`year` DESC, STR_TO_DATE(p.`month`, '%M' ) DESC, p.`created` DESC 
  LIMIT 0, 5

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ia	NULL	index	PRIMARY	PRIMARY	8	NULL	536	10.00	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	p	NULL	eq_ref	PRIMARY	PRIMARY	4	aso35.ia.id_publication	1	5.00	Using where

Profile

Status	Duration
starting	0.07 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.38 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
Creating tmp table	0.10 ms
executing	0.47 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
12	JDatabaseDriver->loadAssocList()	JROOT/components/com_jresearch/models/staff/member.php:104
11	JResearchModelMember->getLatestPublications()	JROOT/components/com_jresearch/views/member/view.html.php:123
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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: 5.02 ms After last query: 0.49 ms Query memory: 0.026 MB Memory before query: 2.383 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.06 ms
Executing hook on transaction	0.00 ms
starting	0.04 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	2.56 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
Creating tmp table	0.06 ms
executing	0.13 ms
checking permissions	0.08 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.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.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.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.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.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.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.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.03 ms
checking permissions	0.02 ms
checking permissions	0.11 ms
checking permissions	0.11 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.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jresearch/tables/activity.php:156
14	JResearchActivity->__construct()	JROOT/administrator/components/com_jresearch/tables/publication.php:135
13	JResearchPublication->__construct()	JROOT/libraries/src/Table/Table.php:328
12	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jresearch/models/staff/member.php:106
11	JResearchModelMember->getLatestPublications()	JROOT/components/com_jresearch/views/member/view.html.php:123
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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.74 ms After last query: 0.59 ms Query memory: 0.022 MB Memory before query: 2.465 MB Rows returned: 1

SELECT COUNT(*) 
  FROM `f75oq_jresearch_publication_internal_author` pia, `f75oq_jresearch_publication` p 
  WHERE pia.id_publication = p.id 
        
  AND p.published = 1 
  AND p.internal = 1 
  AND pia.id_staff_member = '11'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pia	NULL	index	PRIMARY	PRIMARY	8	NULL	536	10.00	Using where; Using index
1	SIMPLE	p	NULL	eq_ref	PRIMARY	PRIMARY	4	aso35.pia.id_publication	1	5.00	Using where

Profile

Status	Duration
starting	0.12 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.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.22 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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_jresearch/models/staff/member.php:132
11	JResearchModelMember->countPublications()	JROOT/components/com_jresearch/views/member/view.html.php:129
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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.05 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 2.472 MB Rows returned: 1

SELECT p.* 
  FROM `f75oq_jresearch_project_internal_author` ia,  `f75oq_jresearch_project` p 
  WHERE `p`.`id` = `ia`.`id_project` 
  AND p.published = '1' 
  AND `ia`.`id_staff_member` = '11' 
  ORDER BY `p`.`start_date` DESC, `p`.`end_date` DESC, p.`created` DESC 
  LIMIT 0, 5

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	ia	NULL	index	PRIMARY	PRIMARY	8	NULL	45	10.00	Using where; Using index; Using temporary; Using filesort
1	SIMPLE	p	NULL	eq_ref	PRIMARY	PRIMARY	4	aso35.ia.id_project	1	10.00	Using where

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.34 ms
init	0.01 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
Creating tmp table	0.05 ms
executing	0.09 ms
end	0.00 ms
query end	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
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
12	JDatabaseDriver->loadAssocList()	JROOT/components/com_jresearch/models/staff/member.php:156
11	JResearchModelMember->getLatestProjects()	JROOT/components/com_jresearch/views/member/view.html.php:135
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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.95 ms After last query: 2.58 ms Query memory: 0.025 MB Memory before query: 2.487 MB Rows returned: 27

SHOW FULL COLUMNS 
  FROM `f75oq_jresearch_project`

Explain

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

Profile

Status	Duration
starting	0.09 ms
Executing hook on transaction	0.01 ms
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	2.79 ms
init	0.05 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.04 ms
Creating tmp table	0.09 ms
executing	0.18 ms
checking permissions	0.20 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.04 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.05 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.03 ms
checking permissions	0.05 ms
checking permissions	0.03 ms
checking permissions	0.04 ms
checking permissions	0.04 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.09 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.02 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
15	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jresearch/tables/activity.php:156
14	JResearchActivity->__construct()	JROOT/administrator/components/com_jresearch/tables/project.php:123
13	JResearchProject->__construct()	JROOT/libraries/src/Table/Table.php:328
12	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_jresearch/models/staff/member.php:158
11	JResearchModelMember->getLatestProjects()	JROOT/components/com_jresearch/views/member/view.html.php:135
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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.40 ms After last query: 0.22 ms Query memory: 0.022 MB Memory before query: 2.522 MB Rows returned: 1

SELECT COUNT(*) 
  FROM `f75oq_jresearch_project_internal_author` pia, `f75oq_jresearch_project` p 
                         
  WHERE pia.id_project = p.id 
  AND p.published = 1 
                         
  AND pia.id_staff_member = '11'

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	pia	NULL	index	PRIMARY	PRIMARY	8	NULL	45	10.00	Using where; Using index
1	SIMPLE	p	NULL	eq_ref	PRIMARY	PRIMARY	4	aso35.pia.id_project	1	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.00 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
12	JDatabaseDriver->loadResult()	JROOT/components/com_jresearch/models/staff/member.php:185
11	JResearchModelMember->countProjects()	JROOT/components/com_jresearch/views/member/view.html.php:141
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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.43 ms After last query: 4.96 ms Query memory: 0.026 MB Memory before query: 2.580 MB Rows returned: 4

SHOW FULL COLUMNS 
  FROM `f75oq_jresearch_member_position`

Explain

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

Profile

Status	Duration
starting	0.13 ms
Executing hook on transaction	0.01 ms
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	3.18 ms
init	0.06 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.03 ms
Creating tmp table	0.06 ms
executing	0.14 ms
checking permissions	0.09 ms
checking permissions	0.03 ms
checking permissions	0.02 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.03 ms
freeing items	0.07 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
19	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_jresearch/tables/member_position.php:30
16	JResearchMember_position->__construct()	JROOT/libraries/src/Table/Table.php:328
15	Joomla\CMS\Table\Table::getInstance()	JROOT/administrator/components/com_jresearch/tables/member.php:363
14	JResearchMember->getPositionObj()	JROOT/components/com_jresearch/views/member/tmpl/default.php:22
13	include JROOT/components/com_jresearch/views/member/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/member/view.html.php:170
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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.58 ms After last query: 0.21 ms Query memory: 0.024 MB Memory before query: 2.598 MB Rows returned: 1

SELECT *

  FROM f75oq_jresearch_member_position

  WHERE `id` = '3'

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
15	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_jresearch/tables/member.php:364
14	JResearchMember->getPositionObj()	JROOT/components/com_jresearch/views/member/tmpl/default.php:22
13	include JROOT/components/com_jresearch/views/member/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/member/view.html.php:170
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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.68 ms After last query: 2085.18 ms Query memory: 0.023 MB Memory before query: 2.602 MB Rows returned: 1

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

Explain

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	f75oq_jresearch_research_area	NULL	system	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL

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.23 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.01 ms
query end	0.01 ms
closing tables	0.02 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_jresearch/tables/member.php:522
14	JResearchMember->getResearchAreas()	JROOT/components/com_jresearch/views/member/tmpl/default.php:45
13	include JROOT/components/com_jresearch/views/member/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/member/view.html.php:170
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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.67 ms After last query: 0.47 ms Query memory: 0.024 MB Memory before query: 2.611 MB Rows returned: 0

Duplicate queries: #34 #37 #40 #42

SELECT `element` 
  FROM `f75oq_extensions` 
  WHERE folder = 'jresearch-pubtypes' 
  AND `enabled` = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_jresearch/helpers/publications.php:518
15	JResearchPublicationsHelper::getPublicationsSubtypes()	JROOT/components/com_jresearch/citationStyles/factory.php:41
14	JResearchCitationStyleFactory::getInstance()	JROOT/components/com_jresearch/views/member/tmpl/default.php:131
13	include JROOT/components/com_jresearch/views/member/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/member/view.html.php:170
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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.52 ms After last query: 3.55 ms Query memory: 0.026 MB Memory before query: 2.691 MB Rows returned: 1

Duplicate queries: #20 #35 #38 #41 #43

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.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
20	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_jresearch/tables/activity.php:218
19	JResearchActivity->getAuthorsFromFields()	JROOT/administrator/components/com_jresearch/tables/activity.php:239
18	JResearchActivity->getAuthors()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:301
17	JResearchAPACitationStyle->getAuthorsReferenceTextFromSinglePublication()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:155
16	JResearchAPACitationStyle->getReference()	JROOT/components/com_jresearch/citationStyles/apa/apa_article.php:38
15	JResearchAPAArticleCitationStyle->getReference()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:111
14	JResearchAPACitationStyle->getReferenceHTMLText()	JROOT/components/com_jresearch/views/member/tmpl/default.php:132
13	include JROOT/components/com_jresearch/views/member/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/member/view.html.php:170
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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.58 ms After last query: 0.16 ms Query memory: 0.026 MB Memory before query: 2.707 MB Rows returned: 1

SELECT *

  FROM f75oq_jresearch_member

  WHERE `id` = '12'

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.03 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.03 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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
20	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_jresearch/tables/activity.php:218
19	JResearchActivity->getAuthorsFromFields()	JROOT/administrator/components/com_jresearch/tables/activity.php:239
18	JResearchActivity->getAuthors()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:301
17	JResearchAPACitationStyle->getAuthorsReferenceTextFromSinglePublication()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:155
16	JResearchAPACitationStyle->getReference()	JROOT/components/com_jresearch/citationStyles/apa/apa_article.php:38
15	JResearchAPAArticleCitationStyle->getReference()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:111
14	JResearchAPACitationStyle->getReferenceHTMLText()	JROOT/components/com_jresearch/views/member/tmpl/default.php:132
13	include JROOT/components/com_jresearch/views/member/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/member/view.html.php:170
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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.74 ms After last query: 0.14 ms Query memory: 0.028 MB Memory before query: 2.729 MB Rows returned: 1

Duplicate queries: #36 #39

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.03 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.03 ms
preparing	0.02 ms
executing	0.09 ms
end	0.01 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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
20	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_jresearch/tables/activity.php:218
19	JResearchActivity->getAuthorsFromFields()	JROOT/administrator/components/com_jresearch/tables/activity.php:239
18	JResearchActivity->getAuthors()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:301
17	JResearchAPACitationStyle->getAuthorsReferenceTextFromSinglePublication()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:155
16	JResearchAPACitationStyle->getReference()	JROOT/components/com_jresearch/citationStyles/apa/apa_article.php:38
15	JResearchAPAArticleCitationStyle->getReference()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:111
14	JResearchAPACitationStyle->getReferenceHTMLText()	JROOT/components/com_jresearch/views/member/tmpl/default.php:132
13	include JROOT/components/com_jresearch/views/member/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/member/view.html.php:170
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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.76 ms After last query: 0.49 ms Query memory: 0.024 MB Memory before query: 2.745 MB Rows returned: 0

Duplicate queries: #30 #37 #40 #42

SELECT `element` 
  FROM `f75oq_extensions` 
  WHERE folder = 'jresearch-pubtypes' 
  AND `enabled` = 1

Explain

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

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.02 ms
preparing	0.02 ms
executing	0.38 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.02 ms
logging slow query	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_jresearch/helpers/publications.php:518
15	JResearchPublicationsHelper::getPublicationsSubtypes()	JROOT/components/com_jresearch/citationStyles/factory.php:41
14	JResearchCitationStyleFactory::getInstance()	JROOT/components/com_jresearch/views/member/tmpl/default.php:131
13	include JROOT/components/com_jresearch/views/member/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/member/view.html.php:170
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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.74 ms After last query: 0.18 ms Query memory: 0.026 MB Memory before query: 2.761 MB Rows returned: 1

Duplicate queries: #20 #31 #38 #41 #43

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.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.07 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.04 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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
20	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_jresearch/tables/activity.php:218
19	JResearchActivity->getAuthorsFromFields()	JROOT/administrator/components/com_jresearch/tables/activity.php:239
18	JResearchActivity->getAuthors()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:301
17	JResearchAPACitationStyle->getAuthorsReferenceTextFromSinglePublication()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:155
16	JResearchAPACitationStyle->getReference()	JROOT/components/com_jresearch/citationStyles/apa/apa_article.php:38
15	JResearchAPAArticleCitationStyle->getReference()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:111
14	JResearchAPACitationStyle->getReferenceHTMLText()	JROOT/components/com_jresearch/views/member/tmpl/default.php:132
13	include JROOT/components/com_jresearch/views/member/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/member/view.html.php:170
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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.55 ms After last query: 0.16 ms Query memory: 0.026 MB Memory before query: 2.777 MB Rows returned: 1

Duplicate queries: #33 #39

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.01 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.01 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
20	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_jresearch/tables/activity.php:218
19	JResearchActivity->getAuthorsFromFields()	JROOT/administrator/components/com_jresearch/tables/activity.php:239
18	JResearchActivity->getAuthors()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:301
17	JResearchAPACitationStyle->getAuthorsReferenceTextFromSinglePublication()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:155
16	JResearchAPACitationStyle->getReference()	JROOT/components/com_jresearch/citationStyles/apa/apa_article.php:38
15	JResearchAPAArticleCitationStyle->getReference()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:111
14	JResearchAPACitationStyle->getReferenceHTMLText()	JROOT/components/com_jresearch/views/member/tmpl/default.php:132
13	include JROOT/components/com_jresearch/views/member/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/member/view.html.php:170
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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.67 ms After last query: 0.48 ms Query memory: 0.024 MB Memory before query: 2.791 MB Rows returned: 0

Duplicate queries: #30 #34 #40 #42

SELECT `element` 
  FROM `f75oq_extensions` 
  WHERE folder = 'jresearch-pubtypes' 
  AND `enabled` = 1

Explain

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

Profile

Status	Duration
starting	0.03 ms
Executing hook on transaction	0.01 ms
starting	0.00 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.02 ms
preparing	0.01 ms
executing	0.32 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.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_jresearch/helpers/publications.php:518
15	JResearchPublicationsHelper::getPublicationsSubtypes()	JROOT/components/com_jresearch/citationStyles/factory.php:41
14	JResearchCitationStyleFactory::getInstance()	JROOT/components/com_jresearch/views/member/tmpl/default.php:131
13	include JROOT/components/com_jresearch/views/member/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/member/view.html.php:170
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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.51 ms After last query: 0.17 ms Query memory: 0.026 MB Memory before query: 2.808 MB Rows returned: 1

Duplicate queries: #20 #31 #35 #41 #43

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.02 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 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.00 ms

Call Stack

#	Caller	File and line number
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
20	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_jresearch/tables/activity.php:218
19	JResearchActivity->getAuthorsFromFields()	JROOT/administrator/components/com_jresearch/tables/activity.php:239
18	JResearchActivity->getAuthors()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:301
17	JResearchAPACitationStyle->getAuthorsReferenceTextFromSinglePublication()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:155
16	JResearchAPACitationStyle->getReference()	JROOT/components/com_jresearch/citationStyles/apa/apa_article.php:38
15	JResearchAPAArticleCitationStyle->getReference()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:111
14	JResearchAPACitationStyle->getReferenceHTMLText()	JROOT/components/com_jresearch/views/member/tmpl/default.php:132
13	include JROOT/components/com_jresearch/views/member/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/member/view.html.php:170
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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.52 ms After last query: 0.14 ms Query memory: 0.026 MB Memory before query: 2.823 MB Rows returned: 1

Duplicate queries: #33 #36

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.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.03 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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
20	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_jresearch/tables/activity.php:218
19	JResearchActivity->getAuthorsFromFields()	JROOT/administrator/components/com_jresearch/tables/activity.php:239
18	JResearchActivity->getAuthors()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:301
17	JResearchAPACitationStyle->getAuthorsReferenceTextFromSinglePublication()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:155
16	JResearchAPACitationStyle->getReference()	JROOT/components/com_jresearch/citationStyles/apa/apa_article.php:38
15	JResearchAPAArticleCitationStyle->getReference()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:111
14	JResearchAPACitationStyle->getReferenceHTMLText()	JROOT/components/com_jresearch/views/member/tmpl/default.php:132
13	include JROOT/components/com_jresearch/views/member/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/member/view.html.php:170
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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.61 ms After last query: 0.34 ms Query memory: 0.024 MB Memory before query: 2.838 MB Rows returned: 0

Duplicate queries: #30 #34 #37 #42

SELECT `element` 
  FROM `f75oq_extensions` 
  WHERE folder = 'jresearch-pubtypes' 
  AND `enabled` = 1

Explain

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

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.02 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.23 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.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_jresearch/helpers/publications.php:518
15	JResearchPublicationsHelper::getPublicationsSubtypes()	JROOT/components/com_jresearch/citationStyles/factory.php:41
14	JResearchCitationStyleFactory::getInstance()	JROOT/components/com_jresearch/views/member/tmpl/default.php:131
13	include JROOT/components/com_jresearch/views/member/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/member/view.html.php:170
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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.49 ms After last query: 0.17 ms Query memory: 0.026 MB Memory before query: 2.855 MB Rows returned: 1

Duplicate queries: #20 #31 #35 #38 #43

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.02 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.02 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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
20	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_jresearch/tables/activity.php:218
19	JResearchActivity->getAuthorsFromFields()	JROOT/administrator/components/com_jresearch/tables/activity.php:239
18	JResearchActivity->getAuthors()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:301
17	JResearchAPACitationStyle->getAuthorsReferenceTextFromSinglePublication()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:155
16	JResearchAPACitationStyle->getReference()	JROOT/components/com_jresearch/citationStyles/apa/apa_article.php:38
15	JResearchAPAArticleCitationStyle->getReference()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:111
14	JResearchAPACitationStyle->getReferenceHTMLText()	JROOT/components/com_jresearch/views/member/tmpl/default.php:132
13	include JROOT/components/com_jresearch/views/member/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/member/view.html.php:170
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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.44 ms After last query: 0.55 ms Query memory: 0.024 MB Memory before query: 2.862 MB Rows returned: 0

Duplicate queries: #30 #34 #37 #40

SELECT `element` 
  FROM `f75oq_extensions` 
  WHERE folder = 'jresearch-pubtypes' 
  AND `enabled` = 1

Explain

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

Profile

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

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
16	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_jresearch/helpers/publications.php:518
15	JResearchPublicationsHelper::getPublicationsSubtypes()	JROOT/components/com_jresearch/citationStyles/factory.php:41
14	JResearchCitationStyleFactory::getInstance()	JROOT/components/com_jresearch/views/member/tmpl/default.php:131
13	include JROOT/components/com_jresearch/views/member/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/member/view.html.php:170
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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.41 ms After last query: 0.15 ms Query memory: 0.026 MB Memory before query: 2.879 MB Rows returned: 1

Duplicate queries: #20 #31 #35 #38 #41

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.01 ms
Executing hook on transaction	0.00 ms
starting	0.00 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.02 ms
preparing	0.01 ms
executing	0.02 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
22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
21	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
20	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_jresearch/tables/activity.php:218
19	JResearchActivity->getAuthorsFromFields()	JROOT/administrator/components/com_jresearch/tables/activity.php:239
18	JResearchActivity->getAuthors()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:301
17	JResearchAPACitationStyle->getAuthorsReferenceTextFromSinglePublication()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:155
16	JResearchAPACitationStyle->getReference()	JROOT/components/com_jresearch/citationStyles/apa/apa_article.php:38
15	JResearchAPAArticleCitationStyle->getReference()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:111
14	JResearchAPACitationStyle->getReferenceHTMLText()	JROOT/components/com_jresearch/views/member/tmpl/default.php:132
13	include JROOT/components/com_jresearch/views/member/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/member/view.html.php:170
10	JResearchViewMember->_displayProfile()	JROOT/components/com_jresearch/views/member/view.html.php:33
9	JResearchViewMember->display()	JROOT/components/com_jresearch/controllers/staff.php:101
8	JResearchStaffController->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.59 ms After last query: 0.69 ms Query memory: 0.020 MB Memory before query: 2.893 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.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
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.28 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.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: 0.70 ms After last query: 23.37 ms Query memory: 0.035 MB Memory before query: 3.246 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.08 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 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.02 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.02 ms
logging slow query	0.04 ms
cleaning up	0.00 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.69 ms After last query: 0.36 ms Query memory: 0.035 MB Memory before query: 3.272 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.06 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.11 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.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:

10 × SELECT * 
  FROM f75oq_jresearch_member

5 × SELECT `element` 
  FROM `f75oq_extensions`

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
```

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 p.* 
  FROM `f75oq_jresearch_publication_internal_author` ia JOIN `f75oq_jresearch_publication` p

1 × SELECT COUNT(*) 
  FROM `f75oq_jresearch_publication_internal_author` pia, `f75oq_jresearch_publication` p

1 × SELECT p.* 
  FROM `f75oq_jresearch_project_internal_author` ia,  `f75oq_jresearch_project` p

1 × SELECT COUNT(*) 
  FROM `f75oq_jresearch_project_internal_author` pia, `f75oq_jresearch_project` p

1 × SELECT * 
  FROM f75oq_jresearch_member_position

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'6164353562396566616230376535333232623865363633663463666637616431', 1, 1675520886, 0, '', 0

1 × SHOW FULL COLUMNS 
  FROM `f75oq_extensions

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

1 × SHOW FULL COLUMNS 
  FROM `f75oq_jresearch_member

1 × SHOW FULL COLUMNS 
  FROM `f75oq_jresearch_publication

1 × SHOW FULL COLUMNS 
  FROM `f75oq_jresearch_project

1 × SHOW FULL COLUMNS 
  FROM `f75oq_jresearch_member_position