Joomla! Debug Console
{ "__default": { "session": { "counter": 1, "timer": { "start": 1675527525, "last": 1675527525, "now": 1675527525 }, "token": "RlEeimYcIyP68ywxXfQCwKwN7EKQZFdV" }, "registry": { "com_jresearch": { "projects": { "523": { "list": { "start": 0 } } } } }, "user": { "id": 0, "name": null, "username": null, "email": null, "password": null, "password_clear": "", "block": null, "sendEmail": 0, "registerDate": null, "lastvisitDate": null, "activation": null, "params": null, "groups": [], "guest": 1, "lastResetTime": null, "resetCount": null, "requireReset": null, "aid": 0 }, "plg_system_languagefilter": { "language": "en-GB" } }, "__jresearch": { "citedRecords": [] } }
Time
Memory
Time: 47.71 ms / 47.71 ms Memory: 0.544 MB / 0.87 MB Application: afterLoad
Time: 321.88 ms / 369.59 ms Memory: 2.060 MB / 2.93 MB Application: afterInitialise
Time: 117.21 ms / 486.81 ms Memory: 0.814 MB / 3.74 MB Application: afterRoute
Time: 0.20 ms / 487.01 ms Memory: 0.004 MB / 3.75 MB Application: beforeRenderComponent com_jresearch
Time: 168.39 ms / 655.40 ms Memory: 0.713 MB / 4.46 MB Application: afterRenderComponent com_jresearch
Time: 9.03 ms / 664.43 ms Memory: 0.023 MB / 4.49 MB Application: afterDispatch
Time: 250.59 ms / 915.02 ms Memory: 1.414 MB / 5.90 MB Application: afterRender
Database queries total: 52.60 ms
6.40 MB (6,715,184 Bytes)
48 Queries Logged 52.60 ms
23 duplicate found!
- Query Time: 1.08 ms Query memory: 0.023 MB Memory before query: 1.266 MB Rows returned: 0
SELECT `data`
FROM `f75oq_session`
WHERE `session_id` = X'3365313134613564303432623236656134353434336539326131303765666465'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 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.41 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms executing 0.01 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # 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 - Query Time: 0.39 ms After last query: 3.20 ms Query memory: 0.020 MB Memory before query: 1.278 MB Rows returned: 0
SELECT `session_id`
FROM `f75oq_session`
WHERE `session_id` = X'3365313134613564303432623236656134353434336539326131303765666465'
LIMIT 1id 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 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.03 ms executing 0.03 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 # 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 - Query Time: 3.03 ms After last query: 0.09 ms Query memory: 0.004 MB Memory before query: 1.283 MB
INSERT INTO `f75oq_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3365313134613564303432623236656134353434336539326131303765666465', 1, 1675527525, 0, '', 0)EXPLAIN not possible on query: INSERT INTO `f75oq_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3365313134613564303432623236656134353434336539326131303765666465', 1, 1675527525, 0, '', 0)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 update 0.12 ms end 0.01 ms query end 0.01 ms waiting for handler commit 2.60 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # 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 - Query Time: 0.95 ms After last query: 16.32 ms Query memory: 0.020 MB Memory before query: 1.422 MB Rows returned: 4
SELECT id, rules
FROM `f75oq_viewlevels`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 Status Duration starting 0.10 ms Executing hook on transaction 0.01 ms starting 0.02 ms checking permissions 0.01 ms Opening tables 0.44 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.04 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms logging slow query 0.05 ms cleaning up 0.01 ms # 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 - Query Time: 0.98 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 1.434 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 = 1id 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 Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.35 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.03 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # 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 - Query Time: 1.13 ms After last query: 49.49 ms Query memory: 0.022 MB Memory before query: 2.085 MB Rows returned: 1Duplicate queries: #7
SELECT template
FROM f75oq_template_styles as s
WHERE s.client_id = 0
AND s.home = 1id 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 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.48 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.07 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.04 ms cleaning up 0.01 ms # 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 - Query Time: 0.55 ms After last query: 0.11 ms Query memory: 0.023 MB Memory before query: 2.092 MB Rows returned: 1Duplicate queries: #6
SELECT template
FROM f75oq_template_styles as s
WHERE s.client_id = 0
AND s.home = 1id 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 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.06 ms preparing 0.02 ms executing 0.06 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # 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 - Query Time: 0.88 ms After last query: 11.43 ms Query memory: 0.020 MB Memory before query: 2.198 MB Rows returned: 2
SELECT extension, file, type
FROM f75oq_rokcommon_configs
ORDER BY priorityid 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 Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.30 ms init 0.01 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.02 ms freeing items 0.02 ms logging slow query 0.04 ms cleaning up 0.01 ms # 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 - Query Time: 0.63 ms After last query: 44.62 ms Query memory: 0.021 MB Memory before query: 2.409 MB Rows returned: 1
SELECT `template`
FROM `f75oq_template_styles`
WHERE `client_id` = 0
AND `home` = 1id 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 Status Duration starting 0.09 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.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.01 ms freeing items 0.02 ms cleaning up 0.01 ms # 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 - Query Time: 4.24 ms After last query: 28.32 ms Query memory: 0.023 MB Memory before query: 2.742 MB Rows returned: 18
SHOW FULL COLUMNS
FROM `f75oq_extensions`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `f75oq_extensions`Status Duration starting 0.14 ms Executing hook on transaction 0.01 ms starting 0.15 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 2.39 ms init 0.04 ms System lock 0.02 ms optimizing 0.03 ms statistics 0.12 ms preparing 0.04 ms Creating tmp table 0.07 ms executing 0.12 ms checking permissions 0.14 ms checking permissions 0.04 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.05 ms checking permissions 0.03 ms checking permissions 0.02 ms checking permissions 0.01 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.07 ms cleaning up 0.02 ms # 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 - Query Time: 0.83 ms After last query: 1.57 ms Query memory: 0.021 MB Memory before query: 2.772 MB Rows returned: 1
SELECT `extension_id`
FROM `f75oq_extensions`
WHERE type = 'component'
AND element = 'com_roksprocket'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 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.36 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.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 # 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 - Query Time: 0.43 ms After last query: 0.14 ms Query memory: 0.021 MB Memory before query: 2.778 MB Rows returned: 1Duplicate queries: #14
SELECT *
FROM f75oq_extensions
WHERE `extension_id` = '10041'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 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.02 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 # 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 - Query Time: 0.43 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 2.782 MB Rows returned: 1
SELECT `extension_id`
FROM `f75oq_extensions`
WHERE type = 'module'
AND element = 'mod_roksprocket'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 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.08 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.03 ms cleaning up 0.01 ms # 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 - Query Time: 0.36 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 2.788 MB Rows returned: 1Duplicate queries: #12
SELECT *
FROM f75oq_extensions
WHERE `extension_id` = '10041'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 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.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.01 ms # 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 - Query Time: 0.99 ms After last query: 114.30 ms Query memory: 0.022 MB Memory before query: 3.128 MB Rows returned: 0
SELECT *
FROM f75oq_menu
WHERE alias ='en'
AND published=1id 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 Status Duration starting 0.07 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.42 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.03 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # 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 - Query Time: 0.57 ms After last query: 0.18 ms Query memory: 0.022 MB Memory before query: 3.134 MB Rows returned: 1
SELECT *
FROM f75oq_menu
WHERE alias ='about-aso'
AND published=1id 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 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.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.00 ms # 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 - Query Time: 0.78 ms After last query: 53.98 ms Query memory: 0.023 MB Memory before query: 3.538 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.idid 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 Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 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.01 ms freeing items 0.02 ms cleaning up 0.01 ms # 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 - Query Time: 1.67 ms After last query: 13.68 ms Query memory: 0.006 MB Memory before query: 3.616 MB
UPDATE `f75oq_extensions`
SET `params` = '{\"mediaversion\":\"0a2170c3a9b91da023846661131310bb\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `f75oq_extensions` SET `params` = '{\"mediaversion\":\"0a2170c3a9b91da023846661131310bb\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.02 ms Opening tables 0.03 ms init 0.01 ms System lock 0.11 ms updating 0.18 ms end 0.01 ms query end 0.00 ms waiting for handler commit 1.02 ms closing tables 0.02 ms freeing items 0.02 ms cleaning up 0.01 ms # 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 - Query Time: 7.41 ms After last query: 69.44 ms Query memory: 0.054 MB Memory before query: 3.886 MB Rows returned: 10
SELECT DISTINCT proj.*
FROM f75oq_jresearch_project proj
LEFT JOIN f75oq_jresearch_project_research_area AS ra
ON proj.id = ra.id_project
LEFT JOIN f75oq_jresearch_all_project_authors AS apa
ON proj.id = apa.pid
WHERE `published` = 1
ORDER BY start_date DESC
LIMIT 10id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE proj NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 20 10.00 Using where; Using temporary; Using filesort 1 SIMPLE ra NULL ref PRIMARY PRIMARY 4 aso35.proj.id 1 100.00 Using index; Distinct 1 SIMPLE apa NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where; Distinct; Using join buffer (hash join) Status Duration starting 0.17 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 4.37 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.03 ms Creating tmp table 0.16 ms executing 1.94 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.02 ms closing tables 0.12 ms freeing items 0.04 ms logging slow query 0.08 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 12 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_jresearch/models/projects/projects.php:23 11 JResearchModelProjects->getItems() JROOT/components/com_jresearch/views/projects/view.html.php:61 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 3.41 ms After last query: 5.07 ms Query memory: 0.026 MB Memory before query: 4.006 MB Rows returned: 27
SHOW FULL COLUMNS
FROM `f75oq_jresearch_project`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `f75oq_jresearch_project`Status Duration starting 0.09 ms Executing hook on transaction 0.00 ms starting 0.07 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 1.97 ms init 0.03 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.08 ms preparing 0.02 ms Creating tmp table 0.05 ms executing 0.10 ms checking permissions 0.07 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 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.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.02 ms checking permissions 0.02 ms checking permissions 0.06 ms end 0.01 ms query end 0.00 ms waiting for handler commit 0.02 ms closing tables 0.07 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 20 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 19 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 18 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_jresearch/tables/activity.php:156 17 JResearchActivity->__construct() JROOT/administrator/components/com_jresearch/tables/project.php:123 16 JResearchProject->__construct() JROOT/libraries/src/Table/Table.php:328 15 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/MVC/Factory/LegacyFactory.php:110 14 Joomla\CMS\MVC\Factory\LegacyFactory->createTable() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:392 13 Joomla\CMS\MVC\Model\BaseDatabaseModel->_createTable() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:485 12 Joomla\CMS\MVC\Model\BaseDatabaseModel->getTable() JROOT/components/com_jresearch/models/projects/projects.php:27 11 JResearchModelProjects->getItems() JROOT/components/com_jresearch/views/projects/view.html.php:61 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 0.56 ms After last query: 11.07 ms Query memory: 0.023 MB Memory before query: 4.078 MB Rows returned: 14
SELECT DISTINCT YEAR(start_date) as year
FROM `f75oq_jresearch_project`
ORDER BY `start_date` DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE f75oq_jresearch_project NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 20 100.00 Using temporary; Using filesort 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.01 ms preparing 0.01 ms Creating tmp table 0.03 ms executing 0.12 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.05 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 14 JDatabaseDriver->loadColumn() JROOT/administrator/components/com_jresearch/helpers/projects.php:20 13 JResearchProjectsHelper::getYears() JROOT/components/com_jresearch/views/projects/view.html.php:140 12 JResearchViewProjects->_projectsFilter() JROOT/components/com_jresearch/views/projects/view.html.php:91 11 JResearchViewProjects->_setFilters() JROOT/components/com_jresearch/views/projects/view.html.php:63 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 1.11 ms After last query: 24.09 ms Query memory: 0.023 MB Memory before query: 4.096 MB Rows returned: 1
SELECT COUNT(DISTINCT id)
FROM f75oq_jresearch_project proj
LEFT JOIN f75oq_jresearch_project_research_area AS ra
ON proj.id = ra.id_project
LEFT JOIN f75oq_jresearch_all_project_authors AS apa
ON proj.id = apa.pid
WHERE `published` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE proj NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 20 10.00 Using where 1 SIMPLE ra NULL ref PRIMARY PRIMARY 4 aso35.proj.id 1 100.00 Using index 1 SIMPLE apa NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 1 100.00 Using where; Using join buffer (hash join) Status Duration starting 0.14 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.08 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.21 ms executing 0.24 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms logging slow query 0.04 ms cleaning up 0.01 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 14 JDatabaseDriver->loadResult() JROOT/components/com_jresearch/models/modellist.php:55 13 JResearchModelList->_getListCount() JROOT/libraries/src/MVC/Model/ListModel.php:289 12 Joomla\CMS\MVC\Model\ListModel->getTotal() JROOT/libraries/src/MVC/Model/ListModel.php:239 11 Joomla\CMS\MVC\Model\ListModel->getPagination() JROOT/components/com_jresearch/views/projects/view.html.php:69 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 0.79 ms After last query: 33.71 ms Query memory: 0.023 MB Memory before query: 4.114 MB Rows returned: 0
SELECT *
FROM f75oq_jresearch_research_area
WHERE id IN (1)
AND id > 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.30 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms executing 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.02 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_jresearch/tables/activity.php:499 14 JResearchActivity->getResearchAreas() JROOT/components/com_jresearch/views/projects/tmpl/default.php:35 13 include JROOT/components/com_jresearch/views/projects/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/projects/view.html.php:75 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 4.99 ms After last query: 0.13 ms Query memory: 0.027 MB Memory before query: 4.124 MB Rows returned: 29
SHOW FULL COLUMNS
FROM `f75oq_jresearch_member`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `f75oq_jresearch_member`Status Duration starting 0.06 ms Executing hook on transaction 0.01 ms starting 0.04 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 2.56 ms init 0.03 ms System lock 0.01 ms optimizing 0.05 ms statistics 0.24 ms preparing 0.07 ms Creating tmp table 0.10 ms executing 0.16 ms checking permissions 0.11 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.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.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.04 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.04 ms checking permissions 0.03 ms checking permissions 0.13 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.08 ms cleaning up 0.01 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 21 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 20 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 19 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 18 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_jresearch/tables/member.php:186 17 JResearchMember->__construct() JROOT/libraries/src/Table/Table.php:328 16 Joomla\CMS\Table\Table::getInstance() JROOT/administrator/components/com_jresearch/tables/activity.php:217 15 JResearchActivity->getAuthorsFromFields() JROOT/administrator/components/com_jresearch/tables/project.php:401 14 JResearchProject->getLeaders() JROOT/components/com_jresearch/views/projects/tmpl/default.php:65 13 include JROOT/components/com_jresearch/views/projects/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/projects/view.html.php:75 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 0.84 ms After last query: 0.22 ms Query memory: 0.025 MB Memory before query: 4.168 MB Rows returned: 1
SELECT *
FROM f75oq_jresearch_member
WHERE `id` = '2'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 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.34 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.01 ms executing 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.06 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 16 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_jresearch/tables/activity.php:218 15 JResearchActivity->getAuthorsFromFields() JROOT/administrator/components/com_jresearch/tables/project.php:401 14 JResearchProject->getLeaders() JROOT/components/com_jresearch/views/projects/tmpl/default.php:65 13 include JROOT/components/com_jresearch/views/projects/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/projects/view.html.php:75 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 0.69 ms After last query: 0.18 ms Query memory: 0.025 MB Memory before query: 4.182 MB Rows returned: 1Duplicate queries: #30
SELECT *
FROM f75oq_jresearch_member
WHERE `id` = '4'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 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.02 ms statistics 0.03 ms preparing 0.01 ms executing 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 16 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_jresearch/tables/activity.php:218 15 JResearchActivity->getAuthorsFromFields() JROOT/administrator/components/com_jresearch/tables/project.php:401 14 JResearchProject->getLeaders() JROOT/components/com_jresearch/views/projects/tmpl/default.php:65 13 include JROOT/components/com_jresearch/views/projects/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/projects/view.html.php:75 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 0.90 ms After last query: 0.15 ms Query memory: 0.025 MB Memory before query: 4.195 MB Rows returned: 1Duplicate queries: #41
SELECT *
FROM f75oq_jresearch_member
WHERE `id` = '12'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 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.05 ms preparing 0.02 ms executing 0.05 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 # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 16 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_jresearch/tables/activity.php:218 15 JResearchActivity->getAuthorsFromFields() JROOT/administrator/components/com_jresearch/tables/project.php:401 14 JResearchProject->getLeaders() JROOT/components/com_jresearch/views/projects/tmpl/default.php:65 13 include JROOT/components/com_jresearch/views/projects/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/projects/view.html.php:75 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 0.37 ms After last query: 2.26 ms Query memory: 0.023 MB Memory before query: 4.265 MB Rows returned: 0
SELECT *
FROM f75oq_jresearch_research_area
WHERE id IN (1)
AND id > 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE Status Duration starting 0.05 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.00 ms System lock 0.01 ms optimizing 0.01 ms executing 0.01 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 # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_jresearch/tables/activity.php:499 14 JResearchActivity->getResearchAreas() JROOT/components/com_jresearch/views/projects/tmpl/default.php:35 13 include JROOT/components/com_jresearch/views/projects/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/projects/view.html.php:75 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 0.24 ms After last query: 0.15 ms Query memory: 0.023 MB Memory before query: 4.275 MB Rows returned: 0
SELECT *
FROM f75oq_jresearch_research_area
WHERE id IN (1)
AND id > 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_jresearch/tables/activity.php:499 14 JResearchActivity->getResearchAreas() JROOT/components/com_jresearch/views/projects/tmpl/default.php:35 13 include JROOT/components/com_jresearch/views/projects/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/projects/view.html.php:75 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 0.48 ms After last query: 0.14 ms Query memory: 0.025 MB Memory before query: 4.291 MB Rows returned: 1Duplicate queries: #26
SELECT *
FROM f75oq_jresearch_member
WHERE `id` = '4'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 Status Duration starting 0.01 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.00 ms System lock 0.00 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 closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 16 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_jresearch/tables/activity.php:218 15 JResearchActivity->getAuthorsFromFields() JROOT/administrator/components/com_jresearch/tables/project.php:401 14 JResearchProject->getLeaders() JROOT/components/com_jresearch/views/projects/tmpl/default.php:65 13 include JROOT/components/com_jresearch/views/projects/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/projects/view.html.php:75 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 0.26 ms After last query: 0.19 ms Query memory: 0.023 MB Memory before query: 4.297 MB Rows returned: 0
SELECT *
FROM f75oq_jresearch_research_area
WHERE id IN (1)
AND id > 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_jresearch/tables/activity.php:499 14 JResearchActivity->getResearchAreas() JROOT/components/com_jresearch/views/projects/tmpl/default.php:35 13 include JROOT/components/com_jresearch/views/projects/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/projects/view.html.php:75 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 0.26 ms After last query: 0.14 ms Query memory: 0.023 MB Memory before query: 4.303 MB Rows returned: 0
SELECT *
FROM f75oq_jresearch_research_area
WHERE id IN (1)
AND id > 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE Status Duration starting 0.02 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.00 ms optimizing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_jresearch/tables/activity.php:499 14 JResearchActivity->getResearchAreas() JROOT/components/com_jresearch/views/projects/tmpl/default.php:35 13 include JROOT/components/com_jresearch/views/projects/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/projects/view.html.php:75 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 0.48 ms After last query: 0.13 ms Query memory: 0.026 MB Memory before query: 4.325 MB Rows returned: 1
SELECT *
FROM f75oq_jresearch_member
WHERE `id` = '2'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 Status Duration starting 0.01 ms Executing hook on transaction 0.00 ms starting 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.00 ms System lock 0.00 ms optimizing 0.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 # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 16 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_jresearch/tables/activity.php:218 15 JResearchActivity->getAuthorsFromFields() JROOT/administrator/components/com_jresearch/tables/project.php:401 14 JResearchProject->getLeaders() JROOT/components/com_jresearch/views/projects/tmpl/default.php:65 13 include JROOT/components/com_jresearch/views/projects/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/projects/view.html.php:75 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 0.27 ms After last query: 0.16 ms Query memory: 0.023 MB Memory before query: 4.332 MB Rows returned: 0
SELECT *
FROM f75oq_jresearch_research_area
WHERE id IN (1)
AND id > 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE 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.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_jresearch/tables/activity.php:499 14 JResearchActivity->getResearchAreas() JROOT/components/com_jresearch/views/projects/tmpl/default.php:35 13 include JROOT/components/com_jresearch/views/projects/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/projects/view.html.php:75 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 0.44 ms After last query: 0.14 ms Query memory: 0.025 MB Memory before query: 4.353 MB Rows returned: 1
SELECT *
FROM f75oq_jresearch_member
WHERE `id` = '2'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 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.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 # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 16 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_jresearch/tables/activity.php:218 15 JResearchActivity->getAuthorsFromFields() JROOT/administrator/components/com_jresearch/tables/project.php:401 14 JResearchProject->getLeaders() JROOT/components/com_jresearch/views/projects/tmpl/default.php:65 13 include JROOT/components/com_jresearch/views/projects/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/projects/view.html.php:75 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 0.27 ms After last query: 0.16 ms Query memory: 0.023 MB Memory before query: 4.358 MB Rows returned: 0
SELECT *
FROM f75oq_jresearch_research_area
WHERE id IN (1)
AND id > 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE 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 executing 0.01 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 # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_jresearch/tables/activity.php:499 14 JResearchActivity->getResearchAreas() JROOT/components/com_jresearch/views/projects/tmpl/default.php:35 13 include JROOT/components/com_jresearch/views/projects/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/projects/view.html.php:75 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 0.65 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 4.372 MB Rows returned: 1
SELECT *
FROM f75oq_jresearch_member
WHERE `id` = '2'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 Status Duration starting 0.11 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.07 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.04 ms preparing 0.01 ms executing 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 16 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_jresearch/tables/activity.php:218 15 JResearchActivity->getAuthorsFromFields() JROOT/administrator/components/com_jresearch/tables/project.php:401 14 JResearchProject->getLeaders() JROOT/components/com_jresearch/views/projects/tmpl/default.php:65 13 include JROOT/components/com_jresearch/views/projects/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/projects/view.html.php:75 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 0.33 ms After last query: 0.18 ms Query memory: 0.023 MB Memory before query: 4.379 MB Rows returned: 0
SELECT *
FROM f75oq_jresearch_research_area
WHERE id IN (1)
AND id > 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE 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 executing 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_jresearch/tables/activity.php:499 14 JResearchActivity->getResearchAreas() JROOT/components/com_jresearch/views/projects/tmpl/default.php:35 13 include JROOT/components/com_jresearch/views/projects/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/projects/view.html.php:75 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 0.62 ms After last query: 0.14 ms Query memory: 0.025 MB Memory before query: 4.396 MB Rows returned: 1
SELECT *
FROM f75oq_jresearch_member
WHERE `id` = '1'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 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.03 ms preparing 0.01 ms executing 0.11 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 # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 16 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_jresearch/tables/activity.php:218 15 JResearchActivity->getAuthorsFromFields() JROOT/administrator/components/com_jresearch/tables/project.php:401 14 JResearchProject->getLeaders() JROOT/components/com_jresearch/views/projects/tmpl/default.php:65 13 include JROOT/components/com_jresearch/views/projects/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/projects/view.html.php:75 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 0.31 ms After last query: 0.16 ms Query memory: 0.023 MB Memory before query: 4.409 MB Rows returned: 0
SELECT *
FROM f75oq_jresearch_research_area
WHERE id IN (1)
AND id > 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE 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 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.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_jresearch/tables/activity.php:499 14 JResearchActivity->getResearchAreas() JROOT/components/com_jresearch/views/projects/tmpl/default.php:35 13 include JROOT/components/com_jresearch/views/projects/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/projects/view.html.php:75 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 0.53 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 4.420 MB Rows returned: 1Duplicate queries: #27
SELECT *
FROM f75oq_jresearch_member
WHERE `id` = '12'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 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.02 ms init 0.00 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 # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 16 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_jresearch/tables/activity.php:218 15 JResearchActivity->getAuthorsFromFields() JROOT/administrator/components/com_jresearch/tables/project.php:401 14 JResearchProject->getLeaders() JROOT/components/com_jresearch/views/projects/tmpl/default.php:65 13 include JROOT/components/com_jresearch/views/projects/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/projects/view.html.php:75 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 0.47 ms After last query: 0.16 ms Query memory: 0.023 MB Memory before query: 4.427 MB Rows returned: 0
SELECT *
FROM f75oq_jresearch_research_area
WHERE id IN (1)
AND id > 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL NULL Impossible WHERE 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 executing 0.02 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 # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/administrator/components/com_jresearch/tables/activity.php:499 14 JResearchActivity->getResearchAreas() JROOT/components/com_jresearch/views/projects/tmpl/default.php:35 13 include JROOT/components/com_jresearch/views/projects/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/projects/view.html.php:75 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 0.70 ms After last query: 0.13 ms Query memory: 0.025 MB Memory before query: 4.445 MB Rows returned: 1
SELECT *
FROM f75oq_jresearch_member
WHERE `id` = '2'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 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.03 ms preparing 0.01 ms executing 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 16 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_jresearch/tables/activity.php:218 15 JResearchActivity->getAuthorsFromFields() JROOT/administrator/components/com_jresearch/tables/project.php:401 14 JResearchProject->getLeaders() JROOT/components/com_jresearch/views/projects/tmpl/default.php:65 13 include JROOT/components/com_jresearch/views/projects/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/projects/view.html.php:75 10 JResearchViewProjects->_displayDefaultList() JROOT/components/com_jresearch/views/projects/view.html.php:25 9 JResearchViewProjects->display() JROOT/components/com_jresearch/controllers/projects.php:69 8 JResearchProjectsController->display() 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 - Query Time: 0.51 ms After last query: 8.98 ms Query memory: 0.020 MB Memory before query: 4.464 MB Rows returned: 1
SELECT *
FROM `f75oq_template_styles`
WHERE `client_id` = 0
AND `id` = '133'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE f75oq_template_styles NULL const PRIMARY,idx_client_id,idx_client_id_home PRIMARY 4 const 1 100.00 NULL 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.04 ms init 0.01 ms System lock 0.02 ms optimizing 0.02 ms statistics 0.06 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 # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 8 JDatabaseDriver->loadObject() JROOT/plugins/system/helix3/helix3.php:75 7 plgSystemHelix3->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.98 ms After last query: 0.31 ms Query memory: 0.020 MB Memory before query: 4.471 MB Rows returned: 1
SELECT language,id
FROM `f75oq_menu`
WHERE home = 1
AND published = 1
AND client_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE f75oq_menu NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 127 1.00 Using where 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.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.51 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 # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/Multilanguage.php:107 8 Joomla\CMS\Language\Multilanguage::getSiteHomePages() JROOT/plugins/system/languagefilter/languagefilter.php:751 7 PlgSystemLanguageFilter->onAfterDispatch() JROOT/libraries/joomla/event/event.php:70 6 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 5 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 4 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/SiteApplication.php:199 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.48 ms After last query: 162.84 ms Query memory: 0.038 MB Memory before query: 5.338 MB Rows returned: 40
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM f75oq_modules AS m
LEFT JOIN f75oq_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN f75oq_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-02-04 16:18:46')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-02-04 16:18:46')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 523 OR mm.menuid <= 0)
AND m.language IN ('en-GB','*')
ORDER BY m.position, m.orderingid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL PRIMARY,published,newsfeeds,idx_language NO INDEX KEY COULD BE USED NULL NULL 104 0.96 Using where; Using filesort 1 SIMPLE e NULL ref element_clientid,element_folder_clientid element_clientid 403 aso35.m.module,const 1 10.00 Using index condition; Using where 1 SIMPLE mm NULL ref PRIMARY PRIMARY 4 aso35.m.id 3 40.00 Using where; Using index Status Duration starting 0.17 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.56 ms init 0.01 ms System lock 0.01 ms optimizing 0.05 ms statistics 0.12 ms preparing 0.05 ms executing 0.98 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.02 ms freeing items 0.04 ms logging slow query 0.05 ms cleaning up 0.01 ms # Caller File and line number 52 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 51 JDatabaseDriver->loadObjectList() Same as call in the line below. 50 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 49 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/ModuleHelper.php:441 48 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/libraries/src/Helper/ModuleHelper.php:371 47 Joomla\CMS\Helper\ModuleHelper::load() JROOT/libraries/src/Helper/ModuleHelper.php:87 46 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/gantry5/src/classes/Gantry/Framework/Platform.php:341 45 Gantry\Framework\Platform->displayModules() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:702 44 Twig\Template->getAttribute() JROOT/logs/gantry5/g5_hydrogen/twig/61/610adaca9df51a89810f530b36533d19f5f45f58f2b0b2ca0b4d7a5e1f100953.php:43 43 __TwigTemplate_2e109472f22f0a9ac9b67700fd8e84ddcf5b0917919f630b7ae8d201cd7d8dc0->block_particle() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:214 42 Twig\Template->displayBlock() JROOT/logs/gantry5/g5_hydrogen/twig/8a/8ab86153a9cac02987127742db25b8e009e9407c40ceef24c065c583490fbe3e.php:73 41 __TwigTemplate_c2a83ab1df11cf0bea204ddb3a125914e41b49c83ce40d173fe4fd4010497d95->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 40 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 39 Twig\Template->display() JROOT/logs/gantry5/g5_hydrogen/twig/61/610adaca9df51a89810f530b36533d19f5f45f58f2b0b2ca0b4d7a5e1f100953.php:35 38 __TwigTemplate_2e109472f22f0a9ac9b67700fd8e84ddcf5b0917919f630b7ae8d201cd7d8dc0->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 37 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 36 Twig\Template->display() JROOT/logs/gantry5/g5_hydrogen/twig/42/429f70e577b00ad4b02c159a346ced57f4c51ed166c724248523cb087818362f.php:53 35 __TwigTemplate_6f0ef1c02ba7737b8862265f456a1a80b605f53ec456a6e2dd8d59195f0773e6->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 34 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 33 Twig\Template->display() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432 32 Twig\Template->render() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47 31 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384 30 Twig\Environment->render() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176 29 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 28 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 27 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 26 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 25 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 24 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 23 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 22 Gantry\Framework\Theme->segments() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:700 21 Twig\Template->getAttribute() JROOT/logs/gantry5/g5_hydrogen/twig/9a/9aa4be2c79e95009b4ff6ed39000078616560767aaac92e63c95127e0d17042a.php:47 20 __TwigTemplate_4a21d6e91bc238aa51d7755770265dbae59c32d7d10d55f89c7d0607235544fe->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 19 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 18 Twig\Template->display() JROOT/logs/gantry5/g5_hydrogen/twig/9f/9fdf820a97d8f11266ec4837f20e7e9704466287405cec60ba4804312583ab43.php:35 17 __TwigTemplate_78bf7ae53dd9ebd8134db8bde3215fc8c0238529f665265d19eea7970b97a507->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 16 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 15 Twig\Template->display() JROOT/logs/gantry5/g5_hydrogen/twig/ba/bab96452dff626db5b9bf8c87db4c350eea54d92988290b948e6289de13f0e76.php:35 14 __TwigTemplate_08d6e4429705492892fdf088bbc7981e1c5b9a597b7679271958daa67a087786->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 13 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 12 Twig\Template->display() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432 11 Twig\Template->render() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47 10 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384 9 Twig\Environment->render() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176 8 Gantry\Component\Theme\AbstractTheme->render() JROOT/templates/g5_hydrogen/index.php:35 7 require JROOT/templates/g5_hydrogen/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.61 ms After last query: 12.01 ms Query memory: 0.035 MB Memory before query: 5.427 MB Rows returned: 8
SELECT `a`.`menutype`,`a`.`title`
FROM `f75oq_menu_types` AS `a`
WHERE `a`.`client_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ALL NULL NO INDEX KEY COULD BE USED NULL NULL 8 12.50 Using where 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.01 ms statistics 0.01 ms preparing 0.02 ms executing 0.03 ms end 0.00 ms query end 0.00 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.02 ms logging slow query 0.04 ms cleaning up 0.00 ms # Caller File and line number 44 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 43 JDatabaseDriver->loadAssocList() JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:138 42 Gantry\Framework\Menu->getMenuOptions() JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:115 41 Gantry\Framework\Menu->getMenus() JROOT/libraries/gantry5/src/classes/Gantry/Component/Menu/AbstractMenu.php:274 40 Gantry\Component\Menu\AbstractMenu->instance() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:702 39 Twig\Template->getAttribute() JROOT/logs/gantry5/g5_hydrogen/twig/94/940a3a68475bf59c96f6a33f3e06b2524e96bc0e3450b576208b81ef897d6342.php:32 38 __TwigTemplate_c75f571f9ac50d58105c71d45ddd7f63822a59a7a33fbdbe7532b8351dd0de1b->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 37 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 36 Twig\Template->display() JROOT/logs/gantry5/g5_hydrogen/twig/1c/1ce3096772910767c12a62ad47d005d4b52e19265373f98cf82ba7fbf5f76581.php:85 35 __TwigTemplate_6f0c1a5db7e4e68f2505044393aefb8285f7bc60a05180e6ca50a2aac0c8e0ff->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 34 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 33 Twig\Template->display() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432 32 Twig\Template->render() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47 31 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384 30 Twig\Environment->render() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176 29 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 28 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 27 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 26 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 25 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 24 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 23 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 22 Gantry\Framework\Theme->segments() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:700 21 Twig\Template->getAttribute() JROOT/logs/gantry5/g5_hydrogen/twig/9a/9aa4be2c79e95009b4ff6ed39000078616560767aaac92e63c95127e0d17042a.php:47 20 __TwigTemplate_4a21d6e91bc238aa51d7755770265dbae59c32d7d10d55f89c7d0607235544fe->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 19 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 18 Twig\Template->display() JROOT/logs/gantry5/g5_hydrogen/twig/9f/9fdf820a97d8f11266ec4837f20e7e9704466287405cec60ba4804312583ab43.php:35 17 __TwigTemplate_78bf7ae53dd9ebd8134db8bde3215fc8c0238529f665265d19eea7970b97a507->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 16 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 15 Twig\Template->display() JROOT/logs/gantry5/g5_hydrogen/twig/ba/bab96452dff626db5b9bf8c87db4c350eea54d92988290b948e6289de13f0e76.php:35 14 __TwigTemplate_08d6e4429705492892fdf088bbc7981e1c5b9a597b7679271958daa67a087786->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 13 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 12 Twig\Template->display() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432 11 Twig\Template->render() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47 10 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384 9 Twig\Environment->render() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176 8 Gantry\Component\Theme\AbstractTheme->render() JROOT/templates/g5_hydrogen/index.php:35 7 require JROOT/templates/g5_hydrogen/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.74 ms After last query: 2.30 ms Query memory: 0.035 MB Memory before query: 5.515 MB Rows returned: 9
SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id
FROM f75oq_menu AS m
WHERE m.menutype = 'mainmenu'
AND m.parent_id > 0
AND m.client_id = 0
AND m.published >= 0
ORDER BY m.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ref idx_client_id_parent_id_alias_language,idx_menutype idx_menutype 98 const 9 22.46 Using where; Using filesort Status Duration starting 0.08 ms Executing hook on transaction 0.01 ms starting 0.01 ms checking permissions 0.01 ms Opening tables 0.05 ms init 0.01 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.09 ms preparing 0.04 ms executing 0.14 ms end 0.01 ms query end 0.01 ms waiting for handler commit 0.01 ms closing tables 0.01 ms freeing items 0.03 ms cleaning up 0.01 ms # Caller File and line number 45 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 44 JDatabaseDriver->loadAssocList() JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:791 43 Gantry\Framework\Menu->getMenuItemIds() JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:310 42 Gantry\Framework\Menu->getItemsFromPlatform() JROOT/libraries/gantry5/src/classes/Gantry/Framework/Menu.php:753 41 Gantry\Framework\Menu->getList() JROOT/libraries/gantry5/src/classes/Gantry/Component/Menu/AbstractMenu.php:316 40 Gantry\Component\Menu\AbstractMenu->instance() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:702 39 Twig\Template->getAttribute() JROOT/logs/gantry5/g5_hydrogen/twig/94/940a3a68475bf59c96f6a33f3e06b2524e96bc0e3450b576208b81ef897d6342.php:32 38 __TwigTemplate_c75f571f9ac50d58105c71d45ddd7f63822a59a7a33fbdbe7532b8351dd0de1b->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 37 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 36 Twig\Template->display() JROOT/logs/gantry5/g5_hydrogen/twig/1c/1ce3096772910767c12a62ad47d005d4b52e19265373f98cf82ba7fbf5f76581.php:85 35 __TwigTemplate_6f0c1a5db7e4e68f2505044393aefb8285f7bc60a05180e6ca50a2aac0c8e0ff->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 34 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 33 Twig\Template->display() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432 32 Twig\Template->render() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47 31 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384 30 Twig\Environment->render() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176 29 Gantry\Component\Theme\AbstractTheme->render() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:825 28 Gantry\Framework\Theme->getContent() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:718 27 Gantry\Framework\Theme->renderContent() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:643 26 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 25 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 24 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:627 23 Gantry\Framework\Theme->prepareLayout() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/ThemeTrait.php:468 22 Gantry\Framework\Theme->segments() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:700 21 Twig\Template->getAttribute() JROOT/logs/gantry5/g5_hydrogen/twig/9a/9aa4be2c79e95009b4ff6ed39000078616560767aaac92e63c95127e0d17042a.php:47 20 __TwigTemplate_4a21d6e91bc238aa51d7755770265dbae59c32d7d10d55f89c7d0607235544fe->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 19 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 18 Twig\Template->display() JROOT/logs/gantry5/g5_hydrogen/twig/9f/9fdf820a97d8f11266ec4837f20e7e9704466287405cec60ba4804312583ab43.php:35 17 __TwigTemplate_78bf7ae53dd9ebd8134db8bde3215fc8c0238529f665265d19eea7970b97a507->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 16 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 15 Twig\Template->display() JROOT/logs/gantry5/g5_hydrogen/twig/ba/bab96452dff626db5b9bf8c87db4c350eea54d92988290b948e6289de13f0e76.php:35 14 __TwigTemplate_08d6e4429705492892fdf088bbc7981e1c5b9a597b7679271958daa67a087786->doDisplay() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:453 13 Twig\Template->displayWithErrorHandling() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:420 12 Twig\Template->display() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Template.php:432 11 Twig\Template->render() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/TemplateWrapper.php:47 10 Twig\TemplateWrapper->render() JROOT/libraries/gantry5/compat/vendor/twig/twig/src/Environment.php:384 9 Twig\Environment->render() JROOT/libraries/gantry5/src/classes/Gantry/Component/Theme/AbstractTheme.php:176 8 Gantry\Component\Theme\AbstractTheme->render() JROOT/templates/g5_hydrogen/index.php:35 7 require JROOT/templates/g5_hydrogen/index.php JROOT/libraries/src/Document/HtmlDocument.php:678 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:740 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:555 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1098 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:778 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:231 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
26 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
10 × SELECT *
FROM f75oq_jresearch_research_area10 × SELECT *
FROM f75oq_jresearch_member2 × SELECT template
FROM f75oq_template_styles as s2 × SELECT `extension_id`
FROM `f75oq_extensions`2 × SELECT *
FROM f75oq_extensions2 × SELECT *
FROM f75oq_menu1 × SELECT `data`
FROM `f75oq_session`1 × SELECT `session_id`
FROM `f75oq_session`1 × SELECT id, rules
FROM `f75oq_viewlevels1 × SELECT b.id
FROM f75oq_usergroups AS a
LEFT JOIN f75oq_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT extension, file, type
FROM f75oq_rokcommon_configs1 × SELECT `template`
FROM `f75oq_template_styles`1 × SELECT s.id, s.template, s.home, s.title AS long_title, s.params
FROM f75oq_template_styles AS s1 × SELECT DISTINCT proj.*
FROM f75oq_jresearch_project proj
LEFT JOIN f75oq_jresearch_project_research_area AS ra
ON proj.id = ra.id_project
LEFT JOIN f75oq_jresearch_all_project_authors AS apa
ON proj.id = apa.pid1 × SELECT DISTINCT YEAR(start_date) as year
FROM `f75oq_jresearch_project`1 × SELECT COUNT(DISTINCT id)
FROM f75oq_jresearch_project proj
LEFT JOIN f75oq_jresearch_project_research_area AS ra
ON proj.id = ra.id_project
LEFT JOIN f75oq_jresearch_all_project_authors AS apa
ON proj.id = apa.pid1 × SELECT *
FROM `f75oq_template_styles`1 × SELECT language,id
FROM `f75oq_menu`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM f75oq_modules AS m
LEFT JOIN f75oq_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN f75oq_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT `a`.`menutype`,`a`.`title`
FROM `f75oq_menu_types` AS `a`1 × SELECT m.id, m.alias, m.path AS route, m.level, m.parent_id
FROM f75oq_menu AS m
OTHER Tables:
1 × INSERT INTO `f75oq_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3365313134613564303432623236656134353434336539326131303765666465', 1, 1675527525, 0, '', 01 × SHOW FULL COLUMNS
FROM `f75oq_extensions1 × UPDATE `f75oq_extensions`
SET `params` = '{\"mediaversion\":\"0a2170c3a9b91da023846661131310bb\"}'1 × SHOW FULL COLUMNS
FROM `f75oq_jresearch_project1 × SHOW FULL COLUMNS
FROM `f75oq_jresearch_member