Main Menu
Book / Magazine: All books
|
|
| Cover | Title | Authors | Rating | Hits | Category | Status |
|---|---|---|---|---|---|---|
|
Title: 1st to Die (The Women's Murder Club) |
Authors:
James Patterson
|
Rating:
|
Hits: 121 | Category: Joomla |
Status:
Lent from - until 2018-05-06 / 2018-05-06 |
|
Title: Beginning Joomla!: From Novice to Professional (Beginning from Novice to Professional) |
Authors:
Dan Rahmel
|
Rating:
|
Hits: 169 | Category: Joomla |
Status:
 |
|
Title: Beginning PHP and MySQL 5: From Novice to Professional, Second Edition (Beginning from Novice to Professional) |
Authors:
W Jason Gilmore
|
Rating:
|
Hits: 121 | Category: Development |
Status:
|
|
Title: Double Star |
Authors:
Robert A. Heinlein
|
Rating:
|
Hits: 83 | Category: PHP |
Status:
|
|
Title: Foundation |
Authors:
Isaac Asimov
|
Rating:
|
Hits: 66 | Category: Development |
Status:
|
|
Title: PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide |
Authors:
Larry Ullman
|
Rating:
|
Hits: 112 | Category: Joomla |
Status:
|
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1770606286,
"last": 1770606286,
"now": 1770606286
},
"client": {
"forwarded": "216.73.216.209"
}
},
"registry": {
"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,
"bl_fe_booksort": {
"field": "title",
"direction": "asc"
}
}
}
Time
Memory
Time: 1.97 ms / 1.97 ms Memory: 0.500 MB / 0.87 MB Application: afterLoad
Time: 24.71 ms / 26.68 ms Memory: 1.672 MB / 2.54 MB Application: afterInitialise
Time: 6.94 ms / 33.62 ms Memory: 0.383 MB / 2.93 MB Application: afterRoute
Time: 3.58 ms / 37.20 ms Memory: 0.065 MB / 2.99 MB Application: beforeRenderComponent com_booklibrary
Time: 33.76 ms / 70.97 ms Memory: 1.014 MB / 4.00 MB Application: afterRenderComponent com_booklibrary
Time: 2.21 ms / 73.18 ms Memory: 0.202 MB / 4.21 MB Application: afterDispatch
Time: 6.35 ms / 79.53 ms Memory: 0.464 MB / 4.67 MB Application: beforeRenderModule mod_footer (Footer)
Time: 0.45 ms / 79.98 ms Memory: 0.008 MB / 4.68 MB Application: afterRenderModule mod_footer (Footer)
Time: 0.04 ms / 80.02 ms Memory: 0.000 MB / 4.68 MB Application: beforeRenderModule mod_custom (Newsletter Signup)
Time: 0.21 ms / 80.23 ms Memory: 0.006 MB / 4.68 MB Application: afterRenderModule mod_custom (Newsletter Signup)
Time: 0.03 ms / 80.27 ms Memory: 0.000 MB / 4.68 MB Application: beforeRenderModule mod_custom (Social Channels)
Time: 0.06 ms / 80.32 ms Memory: 0.003 MB / 4.68 MB Application: afterRenderModule mod_custom (Social Channels)
Time: 0.02 ms / 80.34 ms Memory: 0.000 MB / 4.68 MB Application: beforeRenderModule mod_custom (Contact Info)
Time: 0.09 ms / 80.43 ms Memory: 0.003 MB / 4.69 MB Application: afterRenderModule mod_custom (Contact Info)
Time: 0.02 ms / 80.46 ms Memory: 0.000 MB / 4.69 MB Application: beforeRenderModule mod_custom (About Igad Info)
Time: 0.05 ms / 80.51 ms Memory: 0.003 MB / 4.69 MB Application: afterRenderModule mod_custom (About Igad Info)
Time: 0.02 ms / 80.53 ms Memory: 0.000 MB / 4.69 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 1.60 ms / 82.13 ms Memory: 0.037 MB / 4.73 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.06 ms / 82.19 ms Memory: 0.000 MB / 4.72 MB Application: beforeRenderModule mod_menu (User menu)
Time: 0.55 ms / 82.73 ms Memory: 0.020 MB / 4.74 MB Application: afterRenderModule mod_menu (User menu)
Time: 4.03 ms / 86.76 ms Memory: 0.234 MB / 4.98 MB Application: afterRender
Database queries total: 35.84 ms
6.04 MB (6,331,296 Bytes)
66 Queries Logged 35.84 ms
25 duplicate found!
- Query Time: 0.48 ms Query memory: 0.023 MB Memory before query: 1.170 MB Rows returned: 0
SELECT `data`
FROM `b4xfb_session`
WHERE `session_id` = 'arhh9b5ahjfd1q1qgk3cjmpmgu'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 0.07 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.03 ms Optimizing 0.02 ms Statistics 0.11 ms Preparing 0.01 ms Executing 0.01 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.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 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.32 ms After last query: 0.35 ms Query memory: 0.020 MB Memory before query: 1.185 MB Rows returned: 0
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'arhh9b5ahjfd1q1qgk3cjmpmgu'
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.04 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.04 ms Preparing 0.01 ms Executing 0.01 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.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.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: 1.12 ms After last query: 0.08 ms Query memory: 0.004 MB Memory before query: 1.191 MB
INSERT INTO `b4xfb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('arhh9b5ahjfd1q1qgk3cjmpmgu', 1, '1770606286', 0, '', 0)EXPLAIN not possible on query: INSERT INTO `b4xfb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('arhh9b5ahjfd1q1qgk3cjmpmgu', 1, '1770606286', 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 0.11 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.72 ms Query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.03 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 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: 0.57 ms After last query: 0.56 ms Query memory: 0.024 MB Memory before query: 1.288 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.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 0.03 ms Optimizing 0.02 ms Statistics 0.08 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.15 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.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 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: 0.25 ms After last query: 0.49 ms Query memory: 0.021 MB Memory before query: 1.319 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.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.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.04 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.02 ms Reset for next command 0.00 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: 0.35 ms After last query: 0.13 ms Query memory: 0.021 MB Memory before query: 1.331 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.04 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.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.01 ms Updating status 0.02 ms Reset for next command 0.00 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: 0.72 ms After last query: 0.19 ms Query memory: 0.030 MB Memory before query: 1.353 MB Rows returned: 89
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.04 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.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.35 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.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 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: 0.66 ms After last query: 2.82 ms Query memory: 0.020 MB Memory before query: 1.702 MB Rows returned: 1
SELECT `enabled`
FROM `b4xfb_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_extensions ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 Using index condition; Using where Status Duration Starting 0.13 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.03 ms Statistics 0.10 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.04 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.02 ms Reset for next command 0.00 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 8 JDatabaseDriver->loadResult() JROOT/plugins/system/backuponupdate/backuponupdate.php:79 7 require_once JROOT/plugins/system/backuponupdate/backuponupdate.php JROOT/libraries/src/Plugin/PluginHelper.php:253 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: 0.58 ms After last query: 5.74 ms Query memory: 0.005 MB Memory before query: 2.400 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.10 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init for update 0.12 ms Updating 0.07 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.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.02 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: 0.92 ms After last query: 5.55 ms Query memory: 0.048 MB Memory before query: 2.574 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.15 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.05 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.24 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.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.51 ms After last query: 2.06 ms Query memory: 0.024 MB Memory before query: 2.808 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'arhh9b5ahjfd1q1qgk3cjmpmgu'
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.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 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.01 ms End of update loop 0.00 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.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 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.37 ms After last query: 0.41 ms Query memory: 0.025 MB Memory before query: 2.830 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'arhh9b5ahjfd1q1qgk3cjmpmgu'
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.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.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.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.01 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.58 ms After last query: 0.24 ms Query memory: 0.022 MB Memory before query: 2.840 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.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.05 ms Statistics 0.08 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.09 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.00 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.64 ms After last query: 1.64 ms Query memory: 0.022 MB Memory before query: 2.946 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.09 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.04 ms Optimizing 0.03 ms Statistics 0.13 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.01 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.05 ms Reset for next command 0.01 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.21 ms After last query: 0.17 ms Query memory: 0.005 MB Memory before query: 2.936 MB
UPDATE `b4xfb_extensions`
SET `params` = '{\"mediaversion\":\"a4685b8e8a7c0bfa8af61083fd89712e\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `b4xfb_extensions` SET `params` = '{\"mediaversion\":\"a4685b8e8a7c0bfa8af61083fd89712e\"}' 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.00 ms System lock 0.00 ms table lock 0.00 ms init for update 0.07 ms Updating 0.08 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.79 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.03 ms Reset for next command 0.03 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: 0.49 ms After last query: 0.46 ms Query memory: 0.019 MB Memory before query: 2.960 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.08 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.05 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.06 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.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 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: 0.38 ms After last query: 1.44 ms Query memory: 0.020 MB Memory before query: 3.219 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.10 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.01 ms Optimizing 0.01 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.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 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: 3.86 ms After last query: 0.05 ms Query memory: 0.125 MB Memory before query: 3.226 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.04 ms checking permissions 0.00 ms Opening tables 0.04 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.06 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Executing 0.00 ms Sending data 3.46 ms End of update loop 0.02 ms Query end 0.01 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.02 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: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: 0.41 ms After last query: 1.03 ms Query memory: 0.020 MB Memory before query: 3.724 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.06 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.02 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.04 ms Executing 0.00 ms Sending data 0.04 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.02 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: 1.16 ms After last query: 0.91 ms Query memory: 0.027 MB Memory before query: 3.865 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.04 ms checking permissions 0.01 ms closing tables 0.00 ms checking permissions 0.01 ms Opening tables 0.43 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.02 ms Preparing 0.02 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms checking permissions 0.10 ms closing tables 0.01 ms checking permissions 0.01 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.17 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 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:1150 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.34 ms Query memory: 0.022 MB Memory before query: 3.903 MB Rows returned: 1Duplicate queries: #30
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.05 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.02 ms Statistics 0.06 ms Preparing 0.00 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.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 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:1150 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.18 ms Query memory: 0.020 MB Memory before query: 3.903 MB Rows returned: 1
SELECT COUNT(DISTINCT b.id)
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 bc.catid = c.id
WHERE b.published='1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b ALL NULL NO INDEX KEY COULD BE USED NULL NULL 6 Using where 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.03 ms After opening tables 0.00 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.05 ms Executing 0.00 ms Sending data 0.06 ms End of update loop 0.01 ms Removing tmp table 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.01 ms Updating status 0.02 ms Reset for next command 0.03 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:1266 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.92 ms After last query: 0.19 ms Query memory: 0.044 MB Memory before query: 3.917 MB Rows returned: 6
SELECT b.*,blr2.rating2, c.title as category, c.id AS category_id, c.ordering as category_ordering ,authors_name
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 bc.catid = c.id
LEFT JOIN ( SELECT ROUND(avg(blr1.rating)) as rating2, fk_bookid
FROM b4xfb_booklibrary as bl
LEFT JOIN b4xfb_booklibrary_review as blr1
on blr1.fk_bookid = bl.id
group by blr1.fk_bookid ) blr2
ON blr2.fk_bookid = b.id
LEFT JOIN ( SELECT a.authors_name AS authors_name, b2.id AS book_primary_id
FROM b4xfb_booklibrary_authors as a
LEFT JOIN b4xfb_booklibrary_authors_connect AS ac2
ON ac2.fk_authorid=a.id
LEFT JOIN b4xfb_booklibrary as b2
ON b2.id=ac2.fk_bookid ) aa
on book_primary_id = b.id
WHERE ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )
and ( b.langshow = 'en-GB' or b.langshow like 'all' or b.langshow like '' or b.langshow like '*' or b.langshow is null)
AND ( c.langshow = 'en-GB' or c.langshow like 'all' or c.langshow like '' or c.langshow like '*' or c.langshow is null)
AND b.published='1'
GROUP BY b.id
ORDER BY title asc
LIMIT 0,10id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY bc ALL bookid,catid NO INDEX KEY COULD BE USED NULL NULL 6 Using where; Using temporary; Using filesort 1 PRIMARY b eq_ref PRIMARY PRIMARY 4 info.bc.bookid 1 Using index condition; Using where 1 PRIMARY c eq_ref PRIMARY PRIMARY 4 info.bc.catid 1 Using where 1 PRIMARY <derived2> ref key0 key0 5 info.b.id 2 Using where 1 PRIMARY b2 eq_ref PRIMARY PRIMARY 4 info.b.id 1 Using where; Using index 1 PRIMARY ac2 ref fk_bookid,fk_authorid fk_bookid 5 info.b2.id 1 Using where 1 PRIMARY a eq_ref PRIMARY PRIMARY 4 info.ac2.fk_authorid 1 Using where 2 DERIVED blr1 system NULL NO INDEX KEY COULD BE USED NULL NULL 0 Const row not found 2 DERIVED bl index NULL PRIMARY 4 NULL 6 Using index Status Duration Starting 0.18 ms checking permissions 0.01 ms Opening tables 0.12 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.18 ms Optimizing 0.04 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.01 ms Statistics 0.07 ms Preparing 0.03 ms Creating tmp table 0.06 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.06 ms Executing 0.00 ms Sending data 1.34 ms Creating sort index 0.21 ms Removing tmp table 0.14 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.01 ms closing tables 0.00 ms Removing tmp table 0.00 ms closing tables 0.00 ms Removing tmp table 0.01 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.02 ms Updating status 0.03 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:1309 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.71 ms After last query: 0.32 ms Query memory: 0.020 MB Memory before query: 3.955 MB Rows returned: 1
SELECT distinct a.authors_name, a.id
FROM b4xfb_booklibrary_authors as a
LEFT JOIN b4xfb_booklibrary_authors_connect AS ac
ON ac.fk_authorid=a.id
LEFT JOIN b4xfb_booklibrary as b
ON b.id=ac.fk_bookid
WHERE b.id ='5'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b const PRIMARY PRIMARY 4 const 1 Using index; Using temporary 1 SIMPLE ac ref fk_bookid,fk_authorid fk_bookid 5 const 1 Using index condition; Using where 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 info.ac.fk_authorid 1 Using index condition Status Duration Starting 0.10 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.02 ms Creating tmp table 0.03 ms Executing 0.00 ms Sending data 0.09 ms Removing tmp table 0.01 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.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 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 8 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/booklibrary.php:1326 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.06 ms Query memory: 0.020 MB Memory before query: 3.962 MB Rows returned: 1
SELECT distinct a.authors_name, a.id
FROM b4xfb_booklibrary_authors as a
LEFT JOIN b4xfb_booklibrary_authors_connect AS ac
ON ac.fk_authorid=a.id
LEFT JOIN b4xfb_booklibrary as b
ON b.id=ac.fk_bookid
WHERE b.id ='6'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b const PRIMARY PRIMARY 4 const 1 Using index; Using temporary 1 SIMPLE ac ref fk_bookid,fk_authorid fk_bookid 5 const 1 Using index condition; Using where 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 info.ac.fk_authorid 1 Using index condition 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.00 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Creating tmp table 0.02 ms Executing 0.00 ms Sending data 0.03 ms Removing tmp table 0.00 ms Sending data 0.00 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.02 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:1326 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.19 ms Query memory: 0.020 MB Memory before query: 3.967 MB Rows returned: 1
SELECT distinct a.authors_name, a.id
FROM b4xfb_booklibrary_authors as a
LEFT JOIN b4xfb_booklibrary_authors_connect AS ac
ON ac.fk_authorid=a.id
LEFT JOIN b4xfb_booklibrary as b
ON b.id=ac.fk_bookid
WHERE b.id ='4'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b const PRIMARY PRIMARY 4 const 1 Using index; Using temporary 1 SIMPLE ac ref fk_bookid,fk_authorid fk_bookid 5 const 1 Using index condition; Using where 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 info.ac.fk_authorid 1 Using index condition Status Duration Starting 0.04 ms checking permissions 0.03 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.04 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Creating tmp table 0.02 ms Executing 0.00 ms Sending data 0.03 ms Removing tmp table 0.01 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.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/driver.php:1691 8 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/booklibrary.php:1326 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.56 ms After last query: 0.06 ms Query memory: 0.020 MB Memory before query: 3.973 MB Rows returned: 1
SELECT distinct a.authors_name, a.id
FROM b4xfb_booklibrary_authors as a
LEFT JOIN b4xfb_booklibrary_authors_connect AS ac
ON ac.fk_authorid=a.id
LEFT JOIN b4xfb_booklibrary as b
ON b.id=ac.fk_bookid
WHERE b.id ='2'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b const PRIMARY PRIMARY 4 const 1 Using index; Using temporary 1 SIMPLE ac ref fk_bookid,fk_authorid fk_bookid 5 const 1 Using index condition; Using where 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 info.ac.fk_authorid 1 Using index condition Status Duration Starting 0.03 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.01 ms Statistics 0.04 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.01 ms Creating tmp table 0.02 ms Executing 0.00 ms Sending data 0.03 ms Removing tmp table 0.00 ms Sending data 0.00 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.06 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.21 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:1326 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.22 ms Query memory: 0.020 MB Memory before query: 3.979 MB Rows returned: 1
SELECT distinct a.authors_name, a.id
FROM b4xfb_booklibrary_authors as a
LEFT JOIN b4xfb_booklibrary_authors_connect AS ac
ON ac.fk_authorid=a.id
LEFT JOIN b4xfb_booklibrary as b
ON b.id=ac.fk_bookid
WHERE b.id ='1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b const PRIMARY PRIMARY 4 const 1 Using index; Using temporary 1 SIMPLE ac ref fk_bookid,fk_authorid fk_bookid 5 const 1 Using index condition; Using where 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 info.ac.fk_authorid 1 Using index condition Status Duration Starting 0.04 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.05 ms Preparing 0.01 ms Unlocking tables 0.03 ms Preparing 0.02 ms Creating tmp table 0.02 ms Executing 0.00 ms Sending data 0.03 ms Removing tmp table 0.01 ms Sending data 0.00 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.03 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:1326 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.28 ms After last query: 0.05 ms Query memory: 0.020 MB Memory before query: 3.985 MB Rows returned: 1
SELECT distinct a.authors_name, a.id
FROM b4xfb_booklibrary_authors as a
LEFT JOIN b4xfb_booklibrary_authors_connect AS ac
ON ac.fk_authorid=a.id
LEFT JOIN b4xfb_booklibrary as b
ON b.id=ac.fk_bookid
WHERE b.id ='3'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b const PRIMARY PRIMARY 4 const 1 Using index; Using temporary 1 SIMPLE ac ref fk_bookid,fk_authorid fk_bookid 5 const 1 Using index condition; Using where 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 info.ac.fk_authorid 1 Using index condition Status Duration Starting 0.03 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.01 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Creating tmp table 0.01 ms Executing 0.00 ms Sending data 0.02 ms Removing tmp table 0.00 ms Sending data 0.00 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.02 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:1326 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.33 ms After last query: 0.17 ms Query memory: 0.021 MB Memory before query: 3.997 MB Rows returned: 1Duplicate queries: #21
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.00 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.00 ms init 0.02 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.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.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:1350 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.26 ms After last query: 0.16 ms Query memory: 0.020 MB Memory before query: 4.000 MB Rows returned: 0
SELECT fk_bookid
FROM `b4xfb_booklibrary_users_favorits`
WHERE fk_userid =0id 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.02 ms checking permissions 0.00 ms Opening tables 0.06 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.00 ms Executing 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.02 ms Reset for next command 0.00 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 8 JDatabaseDriver->loadColumn() JROOT/components/com_booklibrary/booklibrary.php:1365 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.24 ms Query memory: 0.020 MB Memory before query: 4.007 MB Rows returned: 0
SELECT id
FROM b4xfb_menu
WHERE menutype like '%menu%'
AND link LIKE '%index.php?option=com_booklibrary&view=view_book%'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_menu ALL NULL NO INDEX KEY COULD BE USED NULL NULL 73 Using where Status Duration Starting 0.03 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.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.10 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.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.05 ms Reset for next command 0.00 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:1549 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.74 ms Query memory: 0.028 MB Memory before query: 4.040 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'arhh9b5ahjfd1q1qgk3cjmpmgu'
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.01 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.01 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.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 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 23 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 22 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 21 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 20 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 19 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 18 Joomla\CMS\Application\SiteApplication->__construct() JROOT/components/com_booklibrary/router.php:21 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/books/tmpl/list.php:275 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.05 ms Query memory: 0.025 MB Memory before query: 4.051 MB Rows returned: 1
SELECT blc.name
FROM b4xfb_booklibrary_main_categories AS blc
WHERE blc.id = 49id 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.01 ms Optimizing 0.01 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.02 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 18 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/router.php:108 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/books/tmpl/list.php:275 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.39 ms After last query: 0.21 ms Query memory: 0.025 MB Memory before query: 4.062 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 = 5id 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.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.00 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 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.02 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 18 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/router.php:168 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/books/tmpl/list.php:275 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.31 ms Query memory: 0.027 MB Memory before query: 4.087 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'arhh9b5ahjfd1q1qgk3cjmpmgu'
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.00 ms init 0.01 ms Optimizing 0.01 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.03 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.02 ms Reset for next command 0.00 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 23 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 22 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 21 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 20 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 19 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 18 Joomla\CMS\Application\SiteApplication->__construct() JROOT/components/com_booklibrary/router.php:21 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/books/tmpl/list.php:371 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.21 ms Query memory: 0.025 MB Memory before query: 4.097 MB Rows returned: 1
SELECT blc.name
FROM b4xfb_booklibrary_main_categories AS blc
WHERE blc.id = 49id 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.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.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.02 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 18 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/router.php:108 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/books/tmpl/list.php:371 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.81 ms After last query: 0.20 ms Query memory: 0.022 MB Memory before query: 4.105 MB Rows returned: 1
SELECT b.lend_from , b.lend_until
FROM b4xfb_booklibrary_lend AS b
LEFT JOIN b4xfb_booklibrary AS c
ON b.fk_bookid = c.id
WHERE c.id=5
AND c.published='1'
AND c.approved='1'
AND b.lend_return IS NULLid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b system fk_bookid NO INDEX KEY COULD BE USED NULL NULL 1 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.47 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.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 10 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/views/books/tmpl/list.php:386 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.48 ms Query memory: 0.027 MB Memory before query: 4.128 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'arhh9b5ahjfd1q1qgk3cjmpmgu'
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.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.01 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.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 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 23 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 22 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 21 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 20 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 19 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 18 Joomla\CMS\Application\SiteApplication->__construct() JROOT/components/com_booklibrary/router.php:21 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/books/tmpl/list.php:275 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.23 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 4.138 MB Rows returned: 1
SELECT blc.name
FROM b4xfb_booklibrary_main_categories AS blc
WHERE blc.id = 49id 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.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.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.01 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 18 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/router.php:108 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/books/tmpl/list.php:275 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.29 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 4.148 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 = 6id 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.03 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.01 ms Statistics 0.05 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.03 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 18 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/router.php:168 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/books/tmpl/list.php:275 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.31 ms After last query: 0.16 ms Query memory: 0.021 MB Memory before query: 4.156 MB Rows returned: 0
SELECT b.lend_from , b.lend_until
FROM b4xfb_booklibrary_lend AS b
LEFT JOIN b4xfb_booklibrary AS c
ON b.fk_bookid = c.id
WHERE c.id=6
AND c.published='1'
AND c.approved='1'
AND b.lend_return IS NULLid 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.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.00 ms Executing 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 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 10 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/views/books/tmpl/list.php:386 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.25 ms After last query: 0.23 ms Query memory: 0.027 MB Memory before query: 4.177 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'arhh9b5ahjfd1q1qgk3cjmpmgu'
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.00 ms init 0.01 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 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 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 23 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 22 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 21 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 20 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 19 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 18 Joomla\CMS\Application\SiteApplication->__construct() JROOT/components/com_booklibrary/router.php:21 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/books/tmpl/list.php:275 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.025 MB Memory before query: 4.187 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.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.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.01 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 18 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/router.php:108 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/books/tmpl/list.php:275 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.31 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 4.196 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.04 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 0.02 ms Optimizing 0.01 ms Statistics 0.05 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.02 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 18 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/router.php:168 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/books/tmpl/list.php:275 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.25 ms After last query: 0.28 ms Query memory: 0.027 MB Memory before query: 4.221 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'arhh9b5ahjfd1q1qgk3cjmpmgu'
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.04 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 0.01 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 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.02 ms Reset for next command 0.00 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 23 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 22 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 21 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 20 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 19 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 18 Joomla\CMS\Application\SiteApplication->__construct() JROOT/components/com_booklibrary/router.php:21 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/books/tmpl/list.php:371 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.06 ms Query memory: 0.025 MB Memory before query: 4.230 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.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.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.03 ms Freeing items 0.00 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:1652 18 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/router.php:108 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/books/tmpl/list.php:371 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.09 ms Query memory: 0.021 MB Memory before query: 4.239 MB Rows returned: 0
SELECT b.lend_from , b.lend_until
FROM b4xfb_booklibrary_lend AS b
LEFT JOIN b4xfb_booklibrary AS c
ON b.fk_bookid = c.id
WHERE c.id=4
AND c.published='1'
AND c.approved='1'
AND b.lend_return IS NULLid 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.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.00 ms Executing 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 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 10 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/views/books/tmpl/list.php:386 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.24 ms Query memory: 0.027 MB Memory before query: 4.261 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'arhh9b5ahjfd1q1qgk3cjmpmgu'
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.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.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 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.02 ms Reset for next command 0.00 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 23 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 22 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 21 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 20 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 19 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 18 Joomla\CMS\Application\SiteApplication->__construct() JROOT/components/com_booklibrary/router.php:21 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/books/tmpl/list.php:275 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.025 MB Memory before query: 4.271 MB Rows returned: 1Duplicate queries: #53
SELECT blc.name
FROM b4xfb_booklibrary_main_categories AS blc
WHERE blc.id = 51id 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.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.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.00 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.02 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 18 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/router.php:108 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/books/tmpl/list.php:275 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.30 ms After last query: 0.06 ms Query memory: 0.025 MB Memory before query: 4.280 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 = 2id 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.03 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.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.02 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 18 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/router.php:168 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/books/tmpl/list.php:275 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.30 ms After last query: 0.31 ms Query memory: 0.027 MB Memory before query: 4.304 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'arhh9b5ahjfd1q1qgk3cjmpmgu'
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.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.04 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.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 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 23 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 22 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 21 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 20 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 19 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 18 Joomla\CMS\Application\SiteApplication->__construct() JROOT/components/com_booklibrary/router.php:21 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/books/tmpl/list.php:371 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.06 ms Query memory: 0.025 MB Memory before query: 4.314 MB Rows returned: 1Duplicate queries: #50
SELECT blc.name
FROM b4xfb_booklibrary_main_categories AS blc
WHERE blc.id = 51id 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.02 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 0.01 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.02 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 18 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/router.php:108 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/books/tmpl/list.php:371 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.09 ms Query memory: 0.021 MB Memory before query: 4.323 MB Rows returned: 0
SELECT b.lend_from , b.lend_until
FROM b4xfb_booklibrary_lend AS b
LEFT JOIN b4xfb_booklibrary AS c
ON b.fk_bookid = c.id
WHERE c.id=2
AND c.published='1'
AND c.approved='1'
AND b.lend_return IS NULLid 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.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.04 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.00 ms Executing 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.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 10 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/views/books/tmpl/list.php:386 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.88 ms After last query: 0.42 ms Query memory: 0.027 MB Memory before query: 4.344 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'arhh9b5ahjfd1q1qgk3cjmpmgu'
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.13 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.02 ms Statistics 0.09 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 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.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 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 23 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 22 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 21 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 20 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 19 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 18 Joomla\CMS\Application\SiteApplication->__construct() JROOT/components/com_booklibrary/router.php:21 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/books/tmpl/list.php:275 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.31 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 4.354 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.02 ms After opening tables 0.00 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.05 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.02 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 18 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/router.php:108 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/books/tmpl/list.php:275 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.37 ms After last query: 0.09 ms Query memory: 0.025 MB Memory before query: 4.364 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 = 1id 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.04 ms checking permissions 0.00 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.06 ms Preparing 0.00 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 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.02 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 18 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/router.php:168 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/books/tmpl/list.php:275 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.26 ms After last query: 0.13 ms Query memory: 0.021 MB Memory before query: 4.388 MB Rows returned: 0
SELECT b.lend_from , b.lend_until
FROM b4xfb_booklibrary_lend AS b
LEFT JOIN b4xfb_booklibrary AS c
ON b.fk_bookid = c.id
WHERE c.id=1
AND c.published='1'
AND c.approved='1'
AND b.lend_return IS NULLid 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.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.00 ms Executing 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.02 ms Reset for next command 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 10 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/views/books/tmpl/list.php:386 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.25 ms After last query: 0.23 ms Query memory: 0.027 MB Memory before query: 4.410 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'arhh9b5ahjfd1q1qgk3cjmpmgu'
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.00 ms init 0.01 ms Optimizing 0.01 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.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 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 23 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 22 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 21 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 20 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 19 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 18 Joomla\CMS\Application\SiteApplication->__construct() JROOT/components/com_booklibrary/router.php:21 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/books/tmpl/list.php:275 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.025 MB Memory before query: 4.419 MB Rows returned: 1
SELECT blc.name
FROM b4xfb_booklibrary_main_categories AS blc
WHERE blc.id = 49id 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.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.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.02 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 18 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/router.php:108 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/books/tmpl/list.php:275 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.04 ms Query memory: 0.025 MB Memory before query: 4.429 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 = 3id 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.03 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.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.02 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 18 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/router.php:168 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/books/tmpl/list.php:275 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.14 ms Query memory: 0.021 MB Memory before query: 4.438 MB Rows returned: 0
SELECT b.lend_from , b.lend_until
FROM b4xfb_booklibrary_lend AS b
LEFT JOIN b4xfb_booklibrary AS c
ON b.fk_bookid = c.id
WHERE c.id=3
AND c.published='1'
AND c.approved='1'
AND b.lend_return IS NULLid 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.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.00 ms Executing 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.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 10 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/views/books/tmpl/list.php:386 9 require JROOT/components/com_booklibrary/views/books/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:1571 7 PHP_booklibrary::books() JROOT/components/com_booklibrary/booklibrary.php:204 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.43 ms After last query: 6.65 ms Query memory: 0.028 MB Memory before query: 4.667 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-02-09 03:04:46')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-02-09 03:04:46')
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.20 ms checking permissions 0.01 ms Opening tables 0.08 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.06 ms Statistics 0.10 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.42 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.05 ms Reset for next command 0.01 ms # Caller File and line number 20 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 19 JDatabaseDriver->loadObjectList() Same as call in the line below. 18 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 17 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452 16 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382 15 Joomla\CMS\Helper\ModuleHelper::load() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87 14 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/libraries/src/Document/HtmlDocument.php:581 13 Joomla\CMS\Document\HtmlDocument->countModules() JROOT/plugins/system/t3/includes/core/template.php:645 12 T3Template->countModules() JROOT/templates/ja_charity/tpls/blocks/topbar.php:24 11 include JROOT/templates/ja_charity/tpls/blocks/topbar.php JROOT/plugins/system/t3/includes/core/template.php:195 10 T3Template->loadBlock() JROOT/templates/ja_charity/tpls/default-book.php:33 9 include JROOT/templates/ja_charity/tpls/default-book.php JROOT/plugins/system/t3/includes/core/template.php:221 8 T3Template->loadLayout() JROOT/templates/ja_charity/index.php:33 7 require JROOT/templates/ja_charity/index.php JROOT/libraries/src/Document/HtmlDocument.php:658 6 Joomla\CMS\Document\HtmlDocument->_loadTemplate() JROOT/libraries/src/Document/HtmlDocument.php:720 5 Joomla\CMS\Document\HtmlDocument->_fetchTemplate() JROOT/libraries/src/Document/HtmlDocument.php:535 4 Joomla\CMS\Document\HtmlDocument->parse() JROOT/libraries/src/Application/CMSApplication.php:1027 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.68 ms After last query: 2.39 ms Query memory: 0.027 MB Memory before query: 4.728 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'arhh9b5ahjfd1q1qgk3cjmpmgu'
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.14 ms checking permissions 0.01 ms Opening tables 0.04 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.03 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.01 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.36 ms After last query: 1.52 ms Query memory: 0.031 MB Memory before query: 4.824 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'arhh9b5ahjfd1q1qgk3cjmpmgu'
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.02 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.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.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.56 ms After last query: 1.78 ms Query memory: 0.021 MB Memory before query: 4.905 MB Rows returned: 1
SELECT sleep_until < '2026-02-09 03:04:46'
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.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 0.03 ms Optimizing 0.01 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.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.02 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 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
28 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
14 × SELECT `session_id`
FROM `b4xfb_session`9 × SELECT blc.name
FROM b4xfb_booklibrary_main_categories AS blc6 × SELECT b.lend_from , b.lend_until
FROM b4xfb_booklibrary_lend AS b
LEFT JOIN b4xfb_booklibrary AS c
ON b.fk_bookid = c.id6 × 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.catid6 × SELECT distinct a.authors_name, a.id
FROM b4xfb_booklibrary_authors as a
LEFT JOIN b4xfb_booklibrary_authors_connect AS ac
ON ac.fk_authorid=a.id
LEFT JOIN b4xfb_booklibrary as b
ON b.id=ac.fk_bookid2 × SELECT *
FROM b4xfb_menu2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `b4xfb_extensions`1 × SELECT `data`
FROM `b4xfb_session`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 id
FROM b4xfb_menu1 × SELECT fk_bookid
FROM `b4xfb_booklibrary_users_favorits`1 × SELECT b.*,blr2.rating2, c.title as category, c.id AS category_id, c.ordering as category_ordering ,authors_name
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 bc.catid = c.id
LEFT JOIN ( SELECT ROUND(avg(blr1.rating)) as rating2, fk_bookid
FROM b4xfb_booklibrary as bl
LEFT JOIN b4xfb_booklibrary_review as blr1
on blr1.fk_bookid = bl.id
group by blr1.fk_bookid ) blr2
ON blr2.fk_bookid = b.id
LEFT JOIN ( SELECT a.authors_name AS authors_name, b2.id AS book_primary_id
FROM b4xfb_booklibrary_authors as a
LEFT JOIN b4xfb_booklibrary_authors_connect AS ac2
ON ac2.fk_authorid=a.id
LEFT JOIN b4xfb_booklibrary as b2
ON b2.id=ac2.fk_bookid ) aa
on book_primary_id = b.id1 × SELECT COUNT(DISTINCT b.id)
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 bc.catid = c.id1 × 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 `enabled`
FROM `b4xfb_extensions`1 × 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-02-09 03:04:46'
FROM b4xfb_scheduler_metadata
OTHER Tables:
1 × INSERT INTO `b4xfb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('arhh9b5ahjfd1q1qgk3cjmpmgu', 1, '1770606286', 0, '', 01 × UPDATE b4xfb_extensions
SET enabled=11 × UPDATE `b4xfb_extensions`
SET `params` = '{\"mediaversion\":\"a4685b8e8a7c0bfa8af61083fd89712e\"}'1 × SHOW FULL COLUMNS
FROM `b4xfb_menu