Main Menu
 |
| W Jason Gilmore |
|
This Author W Jason Gilmore - has books at our site Beginning PHP and MySQL 5: From Novice to Professional, Second Edition (Beginning from Novice to Professional) |
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1781561302,
"last": 1781561302,
"now": 1781561302
},
"client": {
"forwarded": "216.73.216.116"
}
},
"registry": {
"com_attachments": {
"current_url": "&return=aHR0cHM6Ly9pbmZvLmlnYWRwb3J0YWwub3JnL2Jvb2stbWFnYXppbmUvNTQyL3ZpZXdfYXV0aG9yLzQvdy1qYXNvbi1naWxtb3JlPw%3D%3D"
},
"current_theme": null,
"current_direction": "ltr",
"current_key_sufix": "__ltr"
},
"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
},
"array": 1
}
}
Time
Memory
Time: 10.73 ms / 10.73 ms Memory: 0.495 MB / 0.87 MB Application: afterLoad
Time: 71.01 ms / 81.74 ms Memory: 1.569 MB / 2.43 MB Application: afterInitialise
Time: 13.71 ms / 95.45 ms Memory: 0.386 MB / 2.82 MB Application: afterRoute
Time: 6.41 ms / 101.86 ms Memory: 0.127 MB / 2.95 MB Application: beforeRenderComponent com_booklibrary
Time: 43.62 ms / 145.48 ms Memory: 0.804 MB / 3.75 MB Application: afterRenderComponent com_booklibrary
Time: 5.48 ms / 150.96 ms Memory: 0.136 MB / 3.89 MB Application: afterDispatch
Time: 10.35 ms / 161.32 ms Memory: 0.427 MB / 4.31 MB Application: beforeRenderModule mod_footer (Footer)
Time: 1.03 ms / 162.35 ms Memory: 0.008 MB / 4.32 MB Application: afterRenderModule mod_footer (Footer)
Time: 0.06 ms / 162.41 ms Memory: 0.000 MB / 4.32 MB Application: beforeRenderModule mod_custom (Newsletter Signup)
Time: 0.42 ms / 162.83 ms Memory: 0.006 MB / 4.33 MB Application: afterRenderModule mod_custom (Newsletter Signup)
Time: 0.05 ms / 162.87 ms Memory: 0.000 MB / 4.32 MB Application: beforeRenderModule mod_custom (Social Channels)
Time: 0.09 ms / 162.97 ms Memory: 0.003 MB / 4.33 MB Application: afterRenderModule mod_custom (Social Channels)
Time: 0.06 ms / 163.03 ms Memory: 0.000 MB / 4.33 MB Application: beforeRenderModule mod_custom (Contact Info)
Time: 0.10 ms / 163.13 ms Memory: 0.003 MB / 4.33 MB Application: afterRenderModule mod_custom (Contact Info)
Time: 0.04 ms / 163.17 ms Memory: 0.000 MB / 4.33 MB Application: beforeRenderModule mod_custom (About Igad Info)
Time: 0.08 ms / 163.25 ms Memory: 0.003 MB / 4.33 MB Application: afterRenderModule mod_custom (About Igad Info)
Time: 0.04 ms / 163.29 ms Memory: 0.000 MB / 4.33 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 1.74 ms / 165.03 ms Memory: 0.034 MB / 4.36 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.10 ms / 165.13 ms Memory: 0.000 MB / 4.36 MB Application: beforeRenderModule mod_menu (User menu)
Time: 1.35 ms / 166.48 ms Memory: 0.020 MB / 4.38 MB Application: afterRenderModule mod_menu (User menu)
Time: 5.88 ms / 172.35 ms Memory: 0.144 MB / 4.53 MB Application: afterRender
Database queries total: 53.75 ms
5.14 MB (5,386,088 Bytes)
37 Queries Logged 53.75 ms
- Query Time: 2.68 ms Query memory: 0.023 MB Memory before query: 1.163 MB Rows returned: 0
SELECT `data`
FROM `b4xfb_session`
WHERE `session_id` = '6cekk0doc08u76akqvtsgbn676'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_session const PRIMARY PRIMARY 766 const 1 Status Duration Starting 2.07 ms checking permissions 0.06 ms Opening tables 0.08 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.03 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.17 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 1.10 ms Reset for next command 0.01 ms # Caller File and line number 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 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:660 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:620 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:498 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:455 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:755 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 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:343 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.27 ms After last query: 0.99 ms Query memory: 0.020 MB Memory before query: 1.179 MB Rows returned: 0
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = '6cekk0doc08u76akqvtsgbn676'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_session const PRIMARY PRIMARY 766 const 1 Using index Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.20 ms Reset for next command 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 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:343 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 4.83 ms After last query: 0.13 ms Query memory: 0.004 MB Memory before query: 1.184 MB
INSERT INTO `b4xfb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('6cekk0doc08u76akqvtsgbn676', 1, '1781561302', 0, '', 0)EXPLAIN not possible on query: INSERT INTO `b4xfb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('6cekk0doc08u76akqvtsgbn676', 1, '1781561302', 0, '', 0)Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init for update 0.02 ms Update 1.34 ms End of update loop 0.01 ms Query end 0.00 ms Commit 3.11 ms Query end 0.03 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.02 ms Starting cleanup 0.01 ms Freeing items 0.02 ms Updating status 0.06 ms Reset for next command 0.01 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:152 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 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:343 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 1.83 ms After last query: 1.31 ms Query memory: 0.024 MB Memory before query: 1.282 MB Rows returned: 40
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `b4xfb_extensions`
WHERE `type` = 'component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_extensions ref extension extension 82 const 40 Using index condition Status Duration Starting 0.13 ms checking permissions 0.01 ms Opening tables 0.10 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.02 ms init 0.06 ms Optimizing 0.05 ms Statistics 0.14 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.33 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.02 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.03 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Component/ComponentHelper.php:423 10 Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() Same as call in the line below. 9 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 8 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Component/ComponentHelper.php:431 7 Joomla\CMS\Component\ComponentHelper::load() JROOT/libraries/src/Component/ComponentHelper.php:497 6 Joomla\CMS\Component\ComponentHelper::getComponents() JROOT/libraries/src/Component/ComponentHelper.php:44 5 Joomla\CMS\Component\ComponentHelper::getComponent() JROOT/libraries/src/Component/ComponentHelper.php:103 4 Joomla\CMS\Component\ComponentHelper::getParams() JROOT/libraries/src/Application/SiteApplication.php:596 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.36 ms After last query: 1.95 ms Query memory: 0.021 MB Memory before query: 1.313 MB Rows returned: 4
SELECT id, rules
FROM `b4xfb_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 Status Duration Starting 0.17 ms checking permissions 0.01 ms Opening tables 0.26 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.10 ms End of update loop 0.01 ms Query end 0.06 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 1.11 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1496 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:310 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:606 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.81 ms After last query: 0.34 ms Query memory: 0.021 MB Memory before query: 1.324 MB Rows returned: 1
SELECT b.id
FROM b4xfb_usergroups AS a
LEFT JOIN b4xfb_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 1 Using where; Using index Status Duration Starting 0.16 ms checking permissions 0.01 ms Opening tables 0.10 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.21 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.04 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.03 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 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:310 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:606 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.73 ms After last query: 0.50 ms Query memory: 0.030 MB Memory before query: 1.346 MB Rows returned: 84
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM b4xfb_extensions
WHERE enabled = 1
AND type = 'plugin'
AND state IN (0,1)
AND access IN (1)
ORDER BY orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_extensions ALL extension NO INDEX KEY COULD BE USED NULL NULL 239 Using where; Using filesort Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.10 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.58 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 3.81 ms Reset for next command 0.03 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 10 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Plugin/PluginHelper.php:343 9 Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() Same as call in the line below. 8 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 7 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Plugin/PluginHelper.php:348 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:606 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.29 ms After last query: 22.03 ms Query memory: 0.004 MB Memory before query: 2.293 MB
UPDATE b4xfb_extensions
SET enabled=1
WHERE `type`='plugin'
AND `element`='jacontenttype'
AND `folder`='ajax'EXPLAIN not possible on query: UPDATE b4xfb_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init for update 0.24 ms Updating 1.47 ms End of update loop 0.03 ms Query end 0.01 ms Commit 0.02 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/plugins/system/jacontenttype/jacontenttype.php:61 8 PlgSystemJacontenttype->_check() JROOT/plugins/system/jacontenttype/jacontenttype.php:43 7 PlgSystemJacontenttype->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:272 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:622 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.57 ms After last query: 10.09 ms Query memory: 0.048 MB Memory before query: 2.529 MB Rows returned: 20
SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM b4xfb_menu AS m
LEFT JOIN b4xfb_extensions AS e
ON m.component_id = e.extension_id
WHERE m.published = 1
AND m.parent_id > 0
AND m.client_id = 0
ORDER BY m.lftid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 21 Using index condition; Using where; Using filesort 1 SIMPLE e eq_ref PRIMARY PRIMARY 4 info.m.component_id 1 Using where Status Duration Starting 0.20 ms checking permissions 0.01 ms Opening tables 0.12 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.14 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.54 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.02 ms Query end 0.05 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:374 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:64 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:488 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:405 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1070 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.71 ms After last query: 5.23 ms Query memory: 0.024 MB Memory before query: 2.700 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = '6cekk0doc08u76akqvtsgbn676'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_session const PRIMARY PRIMARY 766 const 1 Using index Status Duration Starting 0.12 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.05 ms Statistics 0.11 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 16 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 15 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 14 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 13 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 12 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 11 Joomla\CMS\Application\SiteApplication->__construct() JROOT/components/com_booklibrary/router.php:247 10 booklibraryParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1071 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.39 ms After last query: 0.55 ms Query memory: 0.025 MB Memory before query: 2.722 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = '6cekk0doc08u76akqvtsgbn676'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_session const PRIMARY PRIMARY 766 const 1 Using index Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 20 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 19 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 18 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 17 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 16 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 15 Joomla\CMS\Application\SiteApplication->__construct() JROOT/components/com_booklibrary/router.php:247 14 booklibraryParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 13 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:437 12 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 11 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 10 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 9 Joomla\CMS\Router\SiteRouter->parse() JROOT/plugins/system/joomlatools/joomlatools.php:275 8 PlgSystemJoomlatools->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:1080 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.80 ms After last query: 0.31 ms Query memory: 0.022 MB Memory before query: 2.733 MB Rows returned: 9
SELECT id, home, template, s.params
FROM b4xfb_template_styles as s
LEFT JOIN b4xfb_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
WHERE s.client_id = 0
AND e.enabled = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE e ref element_clientid,element_folder_clientid,extension extension 82 const 9 Using index condition; Using where 1 SIMPLE s ref idx_template idx_template 202 info.e.element 1 Using index condition; Using where Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.12 ms Preparing 0.07 ms Executing 0.01 ms Sending data 0.16 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 11 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:488 10 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/t3/includes/core/t3.php:320 9 T3::detect() JROOT/plugins/system/t3/t3.php:81 8 plgSystemT3->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:1080 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.98 ms After last query: 3.40 ms Query memory: 0.022 MB Memory before query: 2.901 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `b4xfb_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.12 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.22 ms Preparing 0.04 ms Executing 0.00 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 14 JDatabaseDriver->loadObject() JROOT/libraries/src/Helper/LibraryHelper.php:167 13 Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() Same as call in the line below. 12 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 11 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Helper/LibraryHelper.php:175 10 Joomla\CMS\Helper\LibraryHelper::loadLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:43 9 Joomla\CMS\Helper\LibraryHelper::getLibrary() JROOT/libraries/src/Helper/LibraryHelper.php:90 8 Joomla\CMS\Helper\LibraryHelper::getParams() JROOT/libraries/src/Version.php:321 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1113 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.30 ms After last query: 0.30 ms Query memory: 0.005 MB Memory before query: 2.892 MB
UPDATE `b4xfb_extensions`
SET `params` = '{\"mediaversion\":\"abc2908f27ec145ccbef4fa9cb023fb3\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `b4xfb_extensions` SET `params` = '{\"mediaversion\":\"abc2908f27ec145ccbef4fa9cb023fb3\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.00 ms init for update 0.07 ms Updating 0.10 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.85 ms Query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1113 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.44 ms After last query: 1.21 ms Query memory: 0.019 MB Memory before query: 2.916 MB Rows returned: 1
SELECT *
FROM b4xfb_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 Using where; Using filesort Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.10 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.03 ms Sorting result 0.67 ms Executing 0.01 ms Sending data 0.02 ms Creating sort index 0.12 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 7 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 6 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Language/LanguageHelper.php:150 5 Joomla\CMS\Language\LanguageHelper::getLanguages() JROOT/libraries/src/Application/SiteApplication.php:330 4 Joomla\CMS\Application\SiteApplication->getParams() JROOT/libraries/src/Application/SiteApplication.php:138 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.14 ms After last query: 5.14 ms Query memory: 0.020 MB Memory before query: 3.173 MB Rows returned: 1
SELECT title, lang_code, sef
FROM b4xfb_booklibrary_languagesid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_booklibrary_languages system NULL NO INDEX KEY COULD BE USED NULL NULL 1 Status Duration Starting 0.12 ms checking permissions 0.01 ms Opening tables 0.10 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.03 ms Optimizing 0.09 ms Statistics 0.08 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 1.41 ms Reset for next command 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 7 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/booklibrary.php:34 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 5.02 ms After last query: 0.13 ms Query memory: 0.126 MB Memory before query: 3.181 MB Rows returned: 818
SELECT c.const, cl.value_const
FROM b4xfb_booklibrary_const_languages as cl
LEFT JOIN b4xfb_booklibrary_languages AS l
ON cl.fk_languagesid=l.id
LEFT JOIN b4xfb_booklibrary_const AS c
ON cl.fk_constid=c.id
WHERE l.lang_code = 'en-GB'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE l system PRIMARY,lang_code NO INDEX KEY COULD BE USED NULL NULL 1 1 SIMPLE cl ALL fk_languagesid NO INDEX KEY COULD BE USED NULL NULL 818 Using where 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 info.cl.fk_constid 1 Using where Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.11 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.04 ms Optimizing 0.04 ms Statistics 0.14 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.03 ms Executing 0.00 ms Sending data 4.30 ms End of update loop 0.03 ms Query end 0.01 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.02 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 7 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/booklibrary.php:58 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 3.17 ms After last query: 2.45 ms Query memory: 0.020 MB Memory before query: 3.679 MB Rows returned: 3
SELECT l.lang_code
FROM b4xfb_languages as lid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE l index NULL idx_langcode 28 NULL 3 Using index Status Duration Starting 0.12 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.04 ms System lock 0.02 ms table lock 0.01 ms init 1.59 ms Optimizing 0.03 ms Statistics 0.03 ms Preparing 0.04 ms Executing 0.00 ms Sending data 0.11 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 7 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/booklibrary.php:68 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 2.67 ms After last query: 5.81 ms Query memory: 0.027 MB Memory before query: 3.829 MB Rows returned: 24
SHOW FULL COLUMNS
FROM `b4xfb_menu`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `b4xfb_menu`Status Duration Starting 0.14 ms checking permissions 0.01 ms closing tables 0.00 ms checking permissions 0.01 ms Opening tables 1.44 ms After opening tables 0.03 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms checking permissions 0.14 ms closing tables 0.01 ms checking permissions 0.01 ms Executing 0.00 ms Sending data 0.08 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.00 ms Removing tmp table 0.26 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 13 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:430 12 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 11 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 10 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Menu.php:33 9 Joomla\CMS\Table\Menu->__construct() JROOT/components/com_booklibrary/booklibrary.php:540 8 PHP_booklibrary::addTitleAndMetaTags() JROOT/components/com_booklibrary/booklibrary.php:2729 7 PHP_booklibrary::showAuthor() JROOT/components/com_booklibrary/booklibrary.php:234 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.57 ms After last query: 0.83 ms Query memory: 0.022 MB Memory before query: 3.867 MB Rows returned: 1Duplicate queries: #25
SELECT *
FROM b4xfb_menu
WHERE `id` = '542'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_menu const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.02 ms Statistics 0.09 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.04 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.32 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 9 Joomla\CMS\Table\Table->load() JROOT/components/com_booklibrary/booklibrary.php:541 8 PHP_booklibrary::addTitleAndMetaTags() JROOT/components/com_booklibrary/booklibrary.php:2729 7 PHP_booklibrary::showAuthor() JROOT/components/com_booklibrary/booklibrary.php:234 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.02 ms After last query: 0.19 ms Query memory: 0.021 MB Memory before query: 3.872 MB Rows returned: 1
SELECT b.title, c.id AS catid
FROM b4xfb_booklibrary AS b
LEFT JOIN b4xfb_booklibrary_categories AS bc
ON b.id=bc.bookid
LEFT JOIN b4xfb_booklibrary_main_categories AS c
ON c.id=bc.catid
WHERE ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )
AND b.id=4
GROUP BY b.idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b const PRIMARY PRIMARY 4 const 1 1 SIMPLE bc ref bookid,catid bookid 4 const 1 Using where 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 info.bc.catid 1 Using where Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.27 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.03 ms Statistics 0.19 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.04 ms Executing 0.01 ms Sending data 0.11 ms End of update loop 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 9 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/booklibrary.php:590 8 PHP_booklibrary::addTitleAndMetaTags() JROOT/components/com_booklibrary/booklibrary.php:2729 7 PHP_booklibrary::showAuthor() JROOT/components/com_booklibrary/booklibrary.php:234 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.40 ms After last query: 0.14 ms Query memory: 0.005 MB Memory before query: 3.871 MB
UPDATE b4xfb_booklibrary_authors
SET hits = hits + 1
WHERE id = 4EXPLAIN not possible on query: UPDATE b4xfb_booklibrary_authors SET hits = hits + 1 WHERE id = 4Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.11 ms After opening tables 0.02 ms System lock 0.00 ms table lock 0.01 ms init for update 0.06 ms Updating 0.16 ms End of update loop 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.86 ms closing tables 0.03 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 8 JDatabase->query() JROOT/components/com_booklibrary/booklibrary.php:2756 7 PHP_booklibrary::showAuthor() JROOT/components/com_booklibrary/booklibrary.php:234 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.14 ms After last query: 0.12 ms Query memory: 0.030 MB Memory before query: 3.877 MB Rows returned: 29
SHOW FULL COLUMNS
FROM `b4xfb_booklibrary_authors`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `b4xfb_booklibrary_authors`Status Duration Starting 0.04 ms checking permissions 0.01 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.50 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.12 ms closing tables 0.01 ms checking permissions 0.01 ms Executing 0.00 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.15 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.40 ms Reset for next command 0.01 ms # Caller File and line number 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 12 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:430 11 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 10 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 9 Joomla\CMS\Table\Table->__construct() JROOT/components/com_booklibrary/booklibrary.class.authors.php:51 8 mosBookLibrary_authors->__construct() JROOT/components/com_booklibrary/booklibrary.php:2763 7 PHP_booklibrary::showAuthor() JROOT/components/com_booklibrary/booklibrary.php:234 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.43 ms After last query: 0.29 ms Query memory: 0.022 MB Memory before query: 3.916 MB Rows returned: 1
SELECT *
FROM b4xfb_booklibrary_authors
WHERE `id` = '4'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_booklibrary_authors const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 9 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 8 Joomla\CMS\Table\Table->load() JROOT/components/com_booklibrary/booklibrary.php:2764 7 PHP_booklibrary::showAuthor() JROOT/components/com_booklibrary/booklibrary.php:234 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.34 ms After last query: 0.16 ms Query memory: 0.021 MB Memory before query: 3.925 MB Rows returned: 1Duplicate queries: #20
SELECT *
FROM b4xfb_menu
WHERE `id` = '542'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_menu const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.08 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 9 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 8 Joomla\CMS\Table\Table->load() JROOT/components/com_booklibrary/booklibrary.php:2795 7 PHP_booklibrary::showAuthor() JROOT/components/com_booklibrary/booklibrary.php:234 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.73 ms After last query: 0.22 ms Query memory: 0.020 MB Memory before query: 3.931 MB Rows returned: 1
SELECT b.id,b.title,bc.catid
FROM b4xfb_booklibrary AS b
LEFT JOIN b4xfb_booklibrary_categories AS bc
ON bc.bookid=b.id
LEFT JOIN b4xfb_booklibrary_main_categories AS c
ON c.id=bc.catid
LEFT JOIN b4xfb_booklibrary_authors_connect AS ac
ON ac.fk_bookid = b.id
LEFT JOIN b4xfb_booklibrary_authors AS a
ON a.id=ac.fk_authorid
WHERE authors_name LIKE '%W Jason Gilmore%'
AND a.id = 4
GROUP BY idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 Using temporary; Using filesort 1 SIMPLE ac ref fk_bookid,fk_authorid fk_authorid 5 const 1 Using where 1 SIMPLE b eq_ref PRIMARY PRIMARY 4 info.ac.fk_bookid 1 Using index condition 1 SIMPLE bc ref bookid bookid 4 info.b.id 1 Using where Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.07 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.12 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.03 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.09 ms Creating sort index 0.05 ms Removing tmp table 0.01 ms Creating sort index 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 8 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/booklibrary.php:2910 7 PHP_booklibrary::showAuthor() JROOT/components/com_booklibrary/booklibrary.php:234 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.41 ms After last query: 0.08 ms Query memory: 0.020 MB Memory before query: 3.936 MB Rows returned: 0
SELECT name, email
FROM b4xfb_users
WHERE id = 92id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.12 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.08 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.11 ms Reset for next command 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 8 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/booklibrary.php:2979 7 PHP_booklibrary::showAuthor() JROOT/components/com_booklibrary/booklibrary.php:234 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.22 ms After last query: 0.05 ms Query memory: 0.020 MB Memory before query: 3.941 MB Rows returned: 1
SELECT associate_authors
FROM b4xfb_booklibrary_authors
WHERE id = '4';id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_booklibrary_authors const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.17 ms Reset for next command 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 8 JDatabaseDriver->loadResult() JROOT/components/com_booklibrary/booklibrary.php:2987 7 PHP_booklibrary::showAuthor() JROOT/components/com_booklibrary/booklibrary.php:234 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.24 ms After last query: 0.10 ms Query memory: 0.020 MB Memory before query: 3.948 MB Rows returned: 1
SELECT authors_name
FROM b4xfb_booklibrary_authors
WHERE id = '4';id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_booklibrary_authors const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.10 ms Reset for next command 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 8 JDatabaseDriver->loadResult() JROOT/components/com_booklibrary/booklibrary.php:3012 7 PHP_booklibrary::showAuthor() JROOT/components/com_booklibrary/booklibrary.php:234 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.46 ms After last query: 0.04 ms Query memory: 0.020 MB Memory before query: 3.953 MB Rows returned: 1
SELECT b.id,b.title,bc.catid
FROM b4xfb_booklibrary AS b
LEFT JOIN b4xfb_booklibrary_categories AS bc
ON bc.bookid=b.id
LEFT JOIN b4xfb_booklibrary_main_categories AS c
ON c.id=bc.catid
LEFT JOIN b4xfb_booklibrary_authors_connect AS a
ON a.fk_bookid = b.id
WHERE a.fk_authorid IN (4)
GROUP BY idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a ref fk_bookid,fk_authorid fk_authorid 5 const 1 Using where; Using temporary; Using filesort 1 SIMPLE b eq_ref PRIMARY PRIMARY 4 info.a.fk_bookid 1 Using index condition 1 SIMPLE bc ref bookid bookid 4 info.b.id 1 Using where Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.09 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.03 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.04 ms Creating sort index 0.02 ms Removing tmp table 0.01 ms Creating sort index 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.88 ms Reset for next command 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 8 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/booklibrary.php:3036 7 PHP_booklibrary::showAuthor() JROOT/components/com_booklibrary/booklibrary.php:234 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.27 ms After last query: 0.82 ms Query memory: 0.026 MB Memory before query: 3.974 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = '6cekk0doc08u76akqvtsgbn676'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_session const PRIMARY PRIMARY 766 const 1 Using index Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 21 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 20 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 19 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 18 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 17 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 16 Joomla\CMS\Application\SiteApplication->__construct() JROOT/components/com_booklibrary/router.php:21 15 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 14 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 12 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 9 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 8 sefRelToAbs() JROOT/components/com_booklibrary/booklibrary.php:3042 7 PHP_booklibrary::showAuthor() JROOT/components/com_booklibrary/booklibrary.php:234 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.36 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 3.983 MB Rows returned: 1
SELECT blc.name
FROM b4xfb_booklibrary_main_categories AS blc
WHERE blc.id = 47id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE blc const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.13 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 16 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/router.php:108 15 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 14 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 12 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 9 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 8 sefRelToAbs() JROOT/components/com_booklibrary/booklibrary.php:3042 7 PHP_booklibrary::showAuthor() JROOT/components/com_booklibrary/booklibrary.php:234 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.45 ms After last query: 0.58 ms Query memory: 0.025 MB Memory before query: 4.000 MB Rows returned: 1
SELECT bc.catid AS catid, b.title
FROM b4xfb_booklibrary AS b
LEFT JOIN b4xfb_booklibrary_categories AS bc
ON bc.bookid=b.id
LEFT JOIN b4xfb_booklibrary_main_categories AS blc
ON blc.id=bc.catid
WHERE b.id = 4id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b const PRIMARY PRIMARY 4 const 1 1 SIMPLE bc ref bookid bookid 4 const 1 Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.00 ms System lock 0.01 ms table lock 0.01 ms init 0.11 ms Optimizing 0.03 ms Statistics 0.06 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 16 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/router.php:168 15 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 14 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 12 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 9 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 8 sefRelToAbs() JROOT/components/com_booklibrary/booklibrary.php:3042 7 PHP_booklibrary::showAuthor() JROOT/components/com_booklibrary/booklibrary.php:234 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.13 ms After last query: 4.15 ms Query memory: 0.028 MB Memory before query: 4.151 MB Rows returned: 14
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM b4xfb_modules AS m
LEFT JOIN b4xfb_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN b4xfb_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 <= '2026-06-15 22:08:22')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-06-15 22:08:22')
AND m.access IN (1)
AND m.client_id = 0
AND (mm.menuid = 542 OR mm.menuid <= 0)
ORDER BY m.position, m.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE m ALL PRIMARY,published,newsfeeds NO INDEX KEY COULD BE USED NULL NULL 61 Using where; Using filesort 1 SIMPLE e ref element_clientid,element_folder_clientid element_clientid 403 info.m.module,const 1 Using index condition; Using where 1 SIMPLE mm ref PRIMARY PRIMARY 4 info.m.id 2 Using where; Using index Status Duration Starting 0.10 ms checking permissions 0.01 ms Opening tables 0.09 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.09 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.49 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.02 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 2.55 ms Reset for next command 0.02 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 20 JDatabaseDriver->loadObjectList() Same as call in the line below. 19 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 18 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452 17 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382 16 Joomla\CMS\Helper\ModuleHelper::load() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87 15 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/plugins/content/loadmodule/loadmodule.php:137 14 PlgContentLoadmodule->_load() JROOT/plugins/content/loadmodule/loadmodule.php:78 13 PlgContentLoadmodule->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_booklibrary/compat.joomla1.5.php:101 10 positions_bl() JROOT/components/com_booklibrary/views/view_author/tmpl/default.php:38 9 require JROOT/components/com_booklibrary/views/view_author/tmpl/default.php JROOT/components/com_booklibrary/booklibrary.html.php:697 8 HTML_booklibrary::displayAuthor() JROOT/components/com_booklibrary/booklibrary.php:3073 7 PHP_booklibrary::showAuthor() JROOT/components/com_booklibrary/booklibrary.php:234 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 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:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.51 ms After last query: 19.48 ms Query memory: 0.027 MB Memory before query: 4.367 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = '6cekk0doc08u76akqvtsgbn676'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_session const PRIMARY PRIMARY 766 const 1 Using index Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.02 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 24 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 23 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 22 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 21 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 20 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 19 Joomla\CMS\Application\SiteApplication->__construct() JROOT/components/com_booklibrary/router.php:21 18 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 17 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 16 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 15 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 14 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 13 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 12 Joomla\CMS\Router\Route::_() JROOT/modules/mod_breadcrumbs/helper.php:54 11 ModBreadCrumbsHelper::getList() JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php:16 10 include JROOT/modules/mod_breadcrumbs/mod_breadcrumbs.php JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:201 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 8 Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 7 Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1041 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.66 ms After last query: 3.10 ms Query memory: 0.025 MB Memory before query: 4.452 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = '6cekk0doc08u76akqvtsgbn676'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_session const PRIMARY PRIMARY 766 const 1 Using index Status Duration Starting 0.12 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.07 ms Statistics 0.10 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 21 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 20 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 19 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 18 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 17 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 16 Joomla\CMS\Application\SiteApplication->__construct() JROOT/components/com_booklibrary/router.php:21 15 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 14 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 12 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 9 Joomla\CMS\Router\Route::_() JROOT/plugins/system/t3/includes/menu/megamenu.php:166 8 T3MenuMegamenu->__construct() JROOT/plugins/system/t3/includes/renderer/megamenurender.php:84 7 JDocumentRendererMegamenuRender->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1041 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.42 ms After last query: 3.01 ms Query memory: 0.021 MB Memory before query: 4.494 MB Rows returned: 1
SELECT sleep_until < '2026-06-15 22:08:22'
FROM b4xfb_scheduler_metadata
WHERE type = 'metadata'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_scheduler_metadata const unique_type unique_type 98 const 1 Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 9 JDatabaseDriver->loadResult() JROOT/plugins/system/joomlatoolsscheduler/joomlatoolsscheduler.php:128 8 PlgSystemJoomlatoolsscheduler->onAfterRender() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/plugins/system/joomlatoolsscheduler/joomlatoolsscheduler.php:167 6 PlgSystemJoomlatoolsscheduler->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/CMSApplication.php:1047 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49
30 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
6 × SELECT `session_id`
FROM `b4xfb_session`2 × SELECT *
FROM b4xfb_menu2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `b4xfb_extensions`1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM b4xfb_modules AS m
LEFT JOIN b4xfb_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN b4xfb_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id1 × SELECT bc.catid AS catid, b.title
FROM b4xfb_booklibrary AS b
LEFT JOIN b4xfb_booklibrary_categories AS bc
ON bc.bookid=b.id
LEFT JOIN b4xfb_booklibrary_main_categories AS blc
ON blc.id=bc.catid1 × SELECT blc.name
FROM b4xfb_booklibrary_main_categories AS blc1 × SELECT b.id,b.title,bc.catid
FROM b4xfb_booklibrary AS b
LEFT JOIN b4xfb_booklibrary_categories AS bc
ON bc.bookid=b.id
LEFT JOIN b4xfb_booklibrary_main_categories AS c
ON c.id=bc.catid
LEFT JOIN b4xfb_booklibrary_authors_connect AS a
ON a.fk_bookid = b.id1 × SELECT authors_name
FROM b4xfb_booklibrary_authors1 × SELECT associate_authors
FROM b4xfb_booklibrary_authors1 × SELECT name, email
FROM b4xfb_users1 × SELECT b.id,b.title,bc.catid
FROM b4xfb_booklibrary AS b
LEFT JOIN b4xfb_booklibrary_categories AS bc
ON bc.bookid=b.id
LEFT JOIN b4xfb_booklibrary_main_categories AS c
ON c.id=bc.catid
LEFT JOIN b4xfb_booklibrary_authors_connect AS ac
ON ac.fk_bookid = b.id
LEFT JOIN b4xfb_booklibrary_authors AS a
ON a.id=ac.fk_authorid1 × SELECT *
FROM b4xfb_booklibrary_authors1 × SELECT `data`
FROM `b4xfb_session`1 × SELECT b.title, c.id AS catid
FROM b4xfb_booklibrary AS b
LEFT JOIN b4xfb_booklibrary_categories AS bc
ON b.id=bc.bookid
LEFT JOIN b4xfb_booklibrary_main_categories AS c
ON c.id=bc.catid1 × SELECT l.lang_code
FROM b4xfb_languages as1 × SELECT c.const, cl.value_const
FROM b4xfb_booklibrary_const_languages as cl
LEFT JOIN b4xfb_booklibrary_languages AS l
ON cl.fk_languagesid=l.id
LEFT JOIN b4xfb_booklibrary_const AS c
ON cl.fk_constid=c.id1 × SELECT title, lang_code, sef
FROM b4xfb_booklibrary_language1 × SELECT *
FROM b4xfb_languages1 × SELECT id, home, template, s.params
FROM b4xfb_template_styles as s
LEFT JOIN b4xfb_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM b4xfb_menu AS m
LEFT JOIN b4xfb_extensions AS e
ON m.component_id = e.extension_id1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM b4xfb_extensions1 × SELECT b.id
FROM b4xfb_usergroups AS a
LEFT JOIN b4xfb_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT id, rules
FROM `b4xfb_viewlevels1 × SELECT sleep_until < '2026-06-15 22:08:22'
FROM b4xfb_scheduler_metadata
OTHER Tables:
1 × INSERT INTO `b4xfb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('6cekk0doc08u76akqvtsgbn676', 1, '1781561302', 0, '', 01 × UPDATE b4xfb_extensions
SET enabled=11 × UPDATE `b4xfb_extensions`
SET `params` = '{\"mediaversion\":\"abc2908f27ec145ccbef4fa9cb023fb3\"}'1 × SHOW FULL COLUMNS
FROM `b4xfb_menu1 × UPDATE b4xfb_booklibrary_authors
SET hits = hits + 11 × SHOW FULL COLUMNS
FROM `b4xfb_booklibrary_authors