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]

Girbés-Peco, S., Joanpere-Foraster, M., Mara, L. C. & Morlà, T. (2020). The role of the democratic organization in the La borda housing cooperative in Spain. Habitat International, 102(August 202). [More] [DOI]

Morlà, T., Ríos-González, O., Mara, L. C. & Garcia-Yeste, C. (2020). Impact of the extension of learning time on the learning space of the platform for people affected by mortgages Tarragona. Learning, Culture and Social Interaction, 24. [More] [DOI]

Gómez, A., M, P., Rios, O., Mara, L. C. & T, P. (2019). Reaching Social Impact Through Communicative Methodology. Researching With Rather Than on Vulnerable Populations: The Roma Case.. Frontiers in Education, . [More] [DOI]

Mara, L. C. (2018). Innovation in the continuing vocational education and training (CVET) government-run programme in Catalonia. Phd Thesis. [More] [DOI]

Mara, L. C. (2018). Innovation in the government-run Continuing Vocational Education and Training programme for unemployed in Catalonia (Spain): Challenges and opportunities. Intangible Capital, 14(3), 370-386. [More] [DOI]

Mara, L. C. & Brunet, I. (2017). La red de los Centros de Innovación y Formación Ocupacional y la promoción de la equidad, la cohesión social y la ciudadanía activa en Cataluña (España). Revista Internacional de Organizaciones, (19), 117-142. [More] [DOI]

Brunet, I. & Mara, L. C (2016). "Las organizaciones" en La sociedad desde la sociología. Una introducción a la sociología general, pages 415-442. [More]

Brunet, I. & Mara, L. C. (2016). Formación profesional y procesos de innovación a nivel regional. Revista Venezolana de Gerencia, 21(74), 257-271. [More]

[View Less]

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": 1675524945,
                "last": 1675524945,
                "now": 1675524945
            },
            "token": "OmsP7Td4ugFrvWlOQWVQxK4uwSFiQYqQ"
        },
        "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

67 Queries Logged 70.95 ms

39 duplicate found!

2 duplicates: #6 #7

2 duplicates: #12 #14

14 duplicates: #20 #31 #35 #38 #41 #43 #45 #49 #51 #53 #55 #57 #61 #64

13 duplicates: #30 #34 #37 #40 #42 #44 #47 #50 #52 #54 #56 #59 #62

6 duplicates: #33 #36 #39 #58 #60 #63

2 duplicates: #46 #48

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

SELECT `data`

  FROM `f75oq_session`

  WHERE `session_id` = X'6237306464396666396133613134383263373933396561313030353864613166'

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.06 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

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

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

Query Time: 0.28 ms After last query: 0.46 ms Query memory: 0.020 MB Memory before query: 0.827 MB Rows returned: 0

SELECT `session_id`

  FROM `f75oq_session`

  WHERE `session_id` = X'6237306464396666396133613134383263373933396561313030353864613166' 
  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.02 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
executing	0.01 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
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: 1.77 ms After last query: 0.10 ms Query memory: 0.004 MB Memory before query: 0.832 MB

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

Explain

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

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.02 ms
init	0.00 ms
System lock	0.01 ms
update	0.13 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	1.36 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 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.36 ms After last query: 1.54 ms Query memory: 0.020 MB Memory before query: 0.906 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.02 ms
Executing hook on transaction	0.00 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.00 ms
statistics	0.01 ms
preparing	0.01 ms
executing	0.05 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.04 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.41 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 0.918 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.04 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.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.03 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.49 ms After last query: 8.48 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.03 ms
Executing hook on transaction	0.00 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.06 ms
preparing	0.02 ms
executing	0.05 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.04 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: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.37 ms After last query: 0.07 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.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.03 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.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.42 ms After last query: 1.61 ms Query memory: 0.020 MB Memory before query: 1.426 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.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.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.04 ms
cleaning up	0.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.47 ms After last query: 9.74 ms Query memory: 0.021 MB Memory before query: 1.510 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.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.04 ms
preparing	0.02 ms
executing	0.05 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
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: 3.89 ms After last query: 3.66 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.05 ms
Executing hook on transaction	0.01 ms
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	2.26 ms
init	0.03 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.11 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.03 ms
checking permissions	0.07 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.06 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.07 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
11	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
10	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:328
9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.46 ms After last query: 0.49 ms Query memory: 0.021 MB Memory before query: 1.746 MB Rows returned: 1

SELECT `extension_id`

  FROM `f75oq_extensions`

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

Explain

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

Profile

Status	Duration
starting	0.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.01 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.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.42 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 1.752 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.02 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.02 ms
statistics	0.05 ms
preparing	0.01 ms
executing	0.02 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php: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.39 ms After last query: 0.10 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.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.06 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.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: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.36 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.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.03 ms
preparing	0.01 ms
executing	0.02 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php: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.82 ms After last query: 81.42 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.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.01 ms
statistics	0.07 ms
preparing	0.02 ms
executing	0.04 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
12	JDatabaseDriver->loadObject()	JROOT/plugins/system/t4/src/t4/MVC/Router/T4.php:346
11	T4\MVC\Router\T4->getMenuByAlias()	JROOT/plugins/system/t4/src/t4/MVC/Router/T4.php:133
10	T4\MVC\Router\T4->parseRule()	Same as call in the line below.
9	call_user_func_array()	JROOT/libraries/src/Router/Router.php:596
8	Joomla\CMS\Router\Router->processParseRules()	JROOT/libraries/src/Router/SiteRouter.php:597
7	Joomla\CMS\Router\SiteRouter->processParseRules()	JROOT/libraries/src/Router/Router.php:212
6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Query Time: 0.72 ms After last query: 0.10 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.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.02 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.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.63 ms After last query: 8.58 ms Query memory: 0.023 MB Memory before query: 2.125 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.06 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.07 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
cleaning up	0.19 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.44 ms After last query: 4.19 ms Query memory: 0.006 MB Memory before query: 2.138 MB

UPDATE `f75oq_extensions`

  SET `params` = '{\"mediaversion\":\"52214b60b1c46bb8c333ea1eb743a7e5\"}'

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

Explain

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

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.03 ms
init	0.01 ms
System lock	0.08 ms
updating	0.14 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.85 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/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.73 ms After last query: 7.18 ms Query memory: 0.025 MB Memory before query: 2.268 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.09 ms
Executing hook on transaction	0.01 ms
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	2.64 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.12 ms
preparing	0.03 ms
Creating tmp table	0.06 ms
executing	0.20 ms
checking permissions	0.10 ms
checking permissions	0.07 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.08 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.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.04 ms
checking permissions	0.09 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.05 ms
freeing items	0.07 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.86 ms After last query: 0.29 ms Query memory: 0.023 MB Memory before query: 2.311 MB Rows returned: 1

Duplicate queries: #31 #35 #38 #41 #43 #45 #49 #51 #53 #55 #57 #61 #64

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.31 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.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: 8.78 ms After last query: 0.65 ms Query memory: 0.055 MB Memory before query: 2.320 MB Rows returned: 13

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

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.12 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.58 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.04 ms
executing	5.89 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
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:125
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.35 ms After last query: 0.65 ms Query memory: 0.026 MB Memory before query: 2.463 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.07 ms
Executing hook on transaction	0.01 ms
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	2.46 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.04 ms
Creating tmp table	0.07 ms
executing	0.16 ms
checking permissions	0.09 ms
checking permissions	0.04 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.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.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.16 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.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.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.12 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.05 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:125
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.54 ms After last query: 0.97 ms Query memory: 0.022 MB Memory before query: 2.561 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.04 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.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.17 ms
end	0.00 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
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: 0.84 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 2.568 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.03 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.25 ms
init	0.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.01 ms
Creating tmp table	0.03 ms
executing	0.07 ms
end	0.00 ms
query end	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
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: 3.04 ms After last query: 0.42 ms Query memory: 0.025 MB Memory before query: 2.583 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.05 ms
Executing hook on transaction	0.00 ms
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	1.89 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
Creating tmp table	0.04 ms
executing	0.09 ms
checking permissions	0.06 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.06 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.05 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.42 ms After last query: 0.24 ms Query memory: 0.022 MB Memory before query: 2.618 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.04 ms
Executing hook on transaction	0.00 ms
starting	0.00 ms
checking permissions	0.00 ms
checking permissions	0.02 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.02 ms
executing	0.03 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.07 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.24 ms After last query: 3.39 ms Query memory: 0.026 MB Memory before query: 2.676 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.09 ms
Executing hook on transaction	0.01 ms
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	2.93 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.16 ms
preparing	0.05 ms
Creating tmp table	0.06 ms
executing	0.13 ms
checking permissions	0.12 ms
checking permissions	0.04 ms
checking permissions	0.08 ms
checking permissions	0.06 ms
end	0.01 ms
query end	0.01 ms
waiting for handler commit	0.02 ms
closing tables	0.03 ms
freeing items	0.06 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.63 ms After last query: 0.16 ms Query memory: 0.024 MB Memory before query: 2.693 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.04 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.24 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.01 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
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: 1.25 ms After last query: 2135.40 ms Query memory: 0.023 MB Memory before query: 2.698 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.09 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.26 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.04 ms
executing	0.03 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
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.98 ms After last query: 0.61 ms Query memory: 0.024 MB Memory before query: 2.707 MB Rows returned: 0

Duplicate queries: #34 #37 #40 #42 #44 #47 #50 #52 #54 #56 #59 #62

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.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 ms
executing	0.48 ms
end	0.02 ms
query end	0.01 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.07 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.61 ms After last query: 0.48 ms Query memory: 0.026 MB Memory before query: 2.724 MB Rows returned: 1

Duplicate queries: #20 #35 #38 #41 #43 #45 #49 #51 #53 #55 #57 #61 #64

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.03 ms
Executing hook on transaction	0.01 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.05 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.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.53 ms After last query: 0.21 ms Query memory: 0.026 MB Memory before query: 2.739 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.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.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.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.58 ms After last query: 0.15 ms Query memory: 0.028 MB Memory before query: 2.761 MB Rows returned: 1

Duplicate queries: #36 #39 #58 #60 #63

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.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.05 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.03 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.62 ms After last query: 0.51 ms Query memory: 0.024 MB Memory before query: 2.778 MB Rows returned: 0

Duplicate queries: #30 #37 #40 #42 #44 #47 #50 #52 #54 #56 #59 #62

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.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.02 ms
executing	0.25 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
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: 0.19 ms Query memory: 0.026 MB Memory before query: 2.794 MB Rows returned: 1

Duplicate queries: #20 #31 #38 #41 #43 #45 #49 #51 #53 #55 #57 #61 #64

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.00 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.03 ms
end	0.01 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
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.64 ms After last query: 0.21 ms Query memory: 0.026 MB Memory before query: 2.809 MB Rows returned: 1

Duplicate queries: #33 #39 #58 #60 #63

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.00 ms
System lock	0.00 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.02 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.54 ms After last query: 0.53 ms Query memory: 0.024 MB Memory before query: 2.824 MB Rows returned: 0

Duplicate queries: #30 #34 #40 #42 #44 #47 #50 #52 #54 #56 #59 #62

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.02 ms
init	0.01 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.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.64 ms After last query: 0.18 ms Query memory: 0.026 MB Memory before query: 2.841 MB Rows returned: 1

Duplicate queries: #20 #31 #35 #41 #43 #45 #49 #51 #53 #55 #57 #61 #64

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.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.66 ms After last query: 0.16 ms Query memory: 0.026 MB Memory before query: 2.856 MB Rows returned: 1

Duplicate queries: #33 #36 #58 #60 #63

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.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.02 ms
preparing	0.01 ms
executing	0.05 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.52 ms After last query: 0.38 ms Query memory: 0.024 MB Memory before query: 2.870 MB Rows returned: 0

Duplicate queries: #30 #34 #37 #42 #44 #47 #50 #52 #54 #56 #59 #62

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.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.00 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.68 ms After last query: 0.21 ms Query memory: 0.026 MB Memory before query: 2.887 MB Rows returned: 1

Duplicate queries: #20 #31 #35 #38 #43 #45 #49 #51 #53 #55 #57 #61 #64

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

Call Stack

#	Caller	File and line number
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.57 ms After last query: 0.58 ms Query memory: 0.024 MB Memory before query: 2.895 MB Rows returned: 0

Duplicate queries: #30 #34 #37 #40 #44 #47 #50 #52 #54 #56 #59 #62

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.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.02 ms
preparing	0.02 ms
executing	0.24 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
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.43 ms After last query: 0.18 ms Query memory: 0.026 MB Memory before query: 2.911 MB Rows returned: 1

Duplicate queries: #20 #31 #35 #38 #41 #45 #49 #51 #53 #55 #57 #61 #64

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.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.02 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.31 ms Query memory: 0.024 MB Memory before query: 2.934 MB Rows returned: 0

Duplicate queries: #30 #34 #37 #40 #42 #47 #50 #52 #54 #56 #59 #62

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.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.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.53 ms After last query: 0.17 ms Query memory: 0.026 MB Memory before query: 2.951 MB Rows returned: 1

Duplicate queries: #20 #31 #35 #38 #41 #43 #49 #51 #53 #55 #57 #61 #64

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.03 ms
Executing hook on transaction	0.01 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.02 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.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.51 ms After last query: 0.17 ms Query memory: 0.026 MB Memory before query: 2.966 MB Rows returned: 1

Duplicate queries: #48

SELECT *

  FROM f75oq_jresearch_member

  WHERE `id` = '15'

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.01 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.02 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.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.54 ms After last query: 0.46 ms Query memory: 0.024 MB Memory before query: 2.973 MB Rows returned: 0

Duplicate queries: #30 #34 #37 #40 #42 #44 #50 #52 #54 #56 #59 #62

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.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.21 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
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.50 ms After last query: 0.18 ms Query memory: 0.026 MB Memory before query: 2.990 MB Rows returned: 1

Duplicate queries: #46

SELECT *

  FROM f75oq_jresearch_member

  WHERE `id` = '15'

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.01 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
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.15 ms Query memory: 0.026 MB Memory before query: 3.005 MB Rows returned: 1

Duplicate queries: #20 #31 #35 #38 #41 #43 #45 #51 #53 #55 #57 #61 #64

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.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.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.63 ms After last query: 0.47 ms Query memory: 0.024 MB Memory before query: 3.012 MB Rows returned: 0

Duplicate queries: #30 #34 #37 #40 #42 #44 #47 #52 #54 #56 #59 #62

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.05 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.02 ms
preparing	0.02 ms
executing	0.22 ms
end	0.01 ms
query end	0.03 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.48 ms After last query: 0.18 ms Query memory: 0.026 MB Memory before query: 3.029 MB Rows returned: 1

Duplicate queries: #20 #31 #35 #38 #41 #43 #45 #49 #53 #55 #57 #61 #64

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.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.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
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.62 ms After last query: 0.73 ms Query memory: 0.024 MB Memory before query: 3.036 MB Rows returned: 0

Duplicate queries: #30 #34 #37 #40 #42 #44 #47 #50 #54 #56 #59 #62

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.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.02 ms
preparing	0.02 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.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.48 ms After last query: 1.16 ms Query memory: 0.026 MB Memory before query: 3.053 MB Rows returned: 1

Duplicate queries: #20 #31 #35 #38 #41 #43 #45 #49 #51 #55 #57 #61 #64

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.03 ms
Executing hook on transaction	0.00 ms
starting	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
19	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_jresearch/tables/activity.php:218
18	JResearchActivity->getAuthorsFromFields()	JROOT/administrator/components/com_jresearch/tables/activity.php:239
17	JResearchActivity->getAuthors()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:301
16	JResearchAPACitationStyle->getAuthorsReferenceTextFromSinglePublication()	JROOT/components/com_jresearch/citationStyles/apa/apa_phdthesis.php:37
15	JResearchAPAPhdthesisCitationStyle->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.19 ms Query memory: 0.024 MB Memory before query: 3.061 MB Rows returned: 0

Duplicate queries: #30 #34 #37 #40 #42 #44 #47 #50 #52 #56 #59 #62

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.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.02 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.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.51 ms After last query: 0.16 ms Query memory: 0.026 MB Memory before query: 3.077 MB Rows returned: 1

Duplicate queries: #20 #31 #35 #38 #41 #43 #45 #49 #51 #53 #57 #61 #64

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.03 ms
Executing hook on transaction	0.00 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.03 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.54 ms After last query: 0.17 ms Query memory: 0.024 MB Memory before query: 3.085 MB Rows returned: 0

Duplicate queries: #30 #34 #37 #40 #42 #44 #47 #50 #52 #54 #59 #62

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.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.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: 3.101 MB Rows returned: 1

Duplicate queries: #20 #31 #35 #38 #41 #43 #45 #49 #51 #53 #55 #61 #64

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.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.02 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.15 ms Query memory: 0.026 MB Memory before query: 3.116 MB Rows returned: 1

Duplicate queries: #33 #36 #39 #60 #63

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.04 ms
init	0.01 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.04 ms
preparing	0.01 ms
executing	0.09 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.77 ms After last query: 0.24 ms Query memory: 0.024 MB Memory before query: 3.147 MB Rows returned: 0

Duplicate queries: #30 #34 #37 #40 #42 #44 #47 #50 #52 #54 #56 #62

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.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.02 ms
preparing	0.02 ms
executing	0.27 ms
end	0.01 ms
query end	0.00 ms
waiting for handler commit	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
logging slow query	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
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.70 ms After last query: 1.04 ms Query memory: 0.026 MB Memory before query: 3.163 MB Rows returned: 1

Duplicate queries: #33 #36 #39 #58 #63

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.02 ms
statistics	0.03 ms
preparing	0.05 ms
executing	0.09 ms
end	0.01 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
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
19	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_jresearch/tables/activity.php:218
18	JResearchActivity->getAuthorsFromFields()	JROOT/administrator/components/com_jresearch/tables/activity.php:239
17	JResearchActivity->getAuthors()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:301
16	JResearchAPACitationStyle->getAuthorsReferenceTextFromSinglePublication()	JROOT/components/com_jresearch/citationStyles/apa/apa_inbook.php:40
15	JResearchAPAInbookCitationStyle->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.16 ms Query memory: 0.026 MB Memory before query: 3.185 MB Rows returned: 1

Duplicate queries: #20 #31 #35 #38 #41 #43 #45 #49 #51 #53 #55 #57 #64

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.07 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.03 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
20	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
19	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_jresearch/tables/activity.php:218
18	JResearchActivity->getAuthorsFromFields()	JROOT/administrator/components/com_jresearch/tables/activity.php:239
17	JResearchActivity->getAuthors()	JROOT/components/com_jresearch/citationStyles/apa/apa.php:301
16	JResearchAPACitationStyle->getAuthorsReferenceTextFromSinglePublication()	JROOT/components/com_jresearch/citationStyles/apa/apa_inbook.php:40
15	JResearchAPAInbookCitationStyle->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.72 ms After last query: 0.24 ms Query memory: 0.024 MB Memory before query: 3.192 MB Rows returned: 0

Duplicate queries: #30 #34 #37 #40 #42 #44 #47 #50 #52 #54 #56 #59

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.01 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.35 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.07 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: 3.208 MB Rows returned: 1

Duplicate queries: #33 #36 #39 #58 #60

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.01 ms
checking permissions	0.00 ms
Opening tables	0.03 ms
init	0.00 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.03 ms
preparing	0.01 ms
executing	0.06 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.00 ms

Call Stack

#	Caller	File and line number
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.50 ms After last query: 0.14 ms Query memory: 0.026 MB Memory before query: 3.231 MB Rows returned: 1