Main Menu
|
|
| Cover | Title | Authors | Rating | Hits | Status |
|---|---|---|---|---|---|
|
Title: 1st to Die (The Women's Murder Club) | Authors: James Patterson |
Rating:
|
Hits: 120 |
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: 168 |
Status:
 |
|
Title: PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide | Authors: Larry Ullman |
Rating:
|
Hits: 112 |
Status:
|
|
|
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1770599751,
"last": 1770599751,
"now": 1770599751
},
"client": {
"forwarded": "216.73.216.209"
}
},
"registry": {
"com_attachments": {
"current_url": "&return=aHR0cHM6Ly9pbmZvLmlnYWRwb3J0YWwub3JnL2Jvb2stbWFnYXppbmUvNTQyL3Nob3dDYXRlZ29yeS80OS9qb29tbGE%2F"
},
"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": ""
}
}
}
Time
Memory
Time: 3.86 ms / 3.86 ms Memory: 0.495 MB / 0.87 MB Application: afterLoad
Time: 35.92 ms / 39.77 ms Memory: 1.664 MB / 2.53 MB Application: afterInitialise
Time: 9.11 ms / 48.88 ms Memory: 0.384 MB / 2.91 MB Application: afterRoute
Time: 3.56 ms / 52.44 ms Memory: 0.065 MB / 2.98 MB Application: beforeRenderComponent com_booklibrary
Time: 46.91 ms / 99.35 ms Memory: 1.176 MB / 4.15 MB Application: afterRenderComponent com_booklibrary
Time: 3.45 ms / 102.80 ms Memory: 0.136 MB / 4.29 MB Application: afterDispatch
Time: 5.74 ms / 108.54 ms Memory: 0.488 MB / 4.78 MB Application: beforeRenderModule mod_footer (Footer)
Time: 0.52 ms / 109.06 ms Memory: 0.008 MB / 4.79 MB Application: afterRenderModule mod_footer (Footer)
Time: 0.04 ms / 109.10 ms Memory: 0.000 MB / 4.79 MB Application: beforeRenderModule mod_custom (Newsletter Signup)
Time: 0.24 ms / 109.34 ms Memory: 0.006 MB / 4.79 MB Application: afterRenderModule mod_custom (Newsletter Signup)
Time: 0.03 ms / 109.37 ms Memory: 0.000 MB / 4.79 MB Application: beforeRenderModule mod_custom (Social Channels)
Time: 0.05 ms / 109.42 ms Memory: 0.003 MB / 4.79 MB Application: afterRenderModule mod_custom (Social Channels)
Time: 0.02 ms / 109.44 ms Memory: 0.000 MB / 4.79 MB Application: beforeRenderModule mod_custom (Contact Info)
Time: 0.05 ms / 109.49 ms Memory: 0.003 MB / 4.79 MB Application: afterRenderModule mod_custom (Contact Info)
Time: 0.02 ms / 109.51 ms Memory: 0.000 MB / 4.79 MB Application: beforeRenderModule mod_custom (About Igad Info)
Time: 0.05 ms / 109.56 ms Memory: 0.003 MB / 4.80 MB Application: afterRenderModule mod_custom (About Igad Info)
Time: 0.02 ms / 109.58 ms Memory: 0.000 MB / 4.80 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 1.39 ms / 110.97 ms Memory: 0.039 MB / 4.84 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.06 ms / 111.03 ms Memory: 0.000 MB / 4.83 MB Application: beforeRenderModule mod_menu (User menu)
Time: 0.87 ms / 111.90 ms Memory: 0.020 MB / 4.85 MB Application: afterRenderModule mod_menu (User menu)
Time: 4.60 ms / 116.50 ms Memory: 0.188 MB / 5.04 MB Application: afterRender
Database queries total: 44.80 ms
6.19 MB (6,492,416 Bytes)
72 Queries Logged 44.80 ms
25 duplicate found!
- Query Time: 0.87 ms Query memory: 0.023 MB Memory before query: 1.163 MB Rows returned: 0
SELECT `data`
FROM `b4xfb_session`
WHERE `session_id` = 'bmi55r62feova1mk6suhfpqfgg'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.18 ms checking permissions 0.01 ms Opening tables 0.07 ms After opening tables 0.03 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.15 ms Preparing 0.01 ms Executing 0.02 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.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 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.35 ms After last query: 0.47 ms Query memory: 0.020 MB Memory before query: 1.179 MB Rows returned: 0
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'bmi55r62feova1mk6suhfpqfgg'
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.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.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.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/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.65 ms After last query: 0.09 ms Query memory: 0.004 MB Memory before query: 1.184 MB
INSERT INTO `b4xfb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('bmi55r62feova1mk6suhfpqfgg', 1, '1770599751', 0, '', 0)EXPLAIN not possible on query: INSERT INTO `b4xfb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('bmi55r62feova1mk6suhfpqfgg', 1, '1770599751', 0, '', 0)Status Duration Starting 0.07 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.03 ms Update 0.26 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.93 ms Query end 0.03 ms closing tables 0.03 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.03 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:343 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.88 ms After last query: 0.74 ms Query memory: 0.024 MB Memory before query: 1.281 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.09 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.11 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.21 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.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 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.37 ms After last query: 0.62 ms Query memory: 0.021 MB Memory before query: 1.312 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.03 ms checking permissions 0.00 ms Opening tables 0.03 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.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.40 ms After last query: 0.31 ms Query memory: 0.021 MB Memory before query: 1.324 MB Rows returned: 1
SELECT b.id
FROM b4xfb_usergroups AS a
LEFT JOIN b4xfb_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 1 Using where; Using index Status Duration Starting 0.06 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.02 ms Optimizing 0.01 ms Statistics 0.05 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 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.98 ms After last query: 0.21 ms Query memory: 0.030 MB Memory before query: 1.346 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.06 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.03 ms Statistics 0.09 ms Preparing 0.05 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.36 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 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.70 ms After last query: 3.10 ms Query memory: 0.020 MB Memory before query: 1.695 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.11 ms checking permissions 0.01 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.10 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.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 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.63 ms After last query: 8.54 ms Query memory: 0.005 MB Memory before query: 2.387 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.13 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.14 ms Updating 0.05 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.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 9 JDatabaseDriverMysqli->execute() JROOT/plugins/system/jacontenttype/jacontenttype.php:61 8 PlgSystemJacontenttype->_check() JROOT/plugins/system/jacontenttype/jacontenttype.php:43 7 PlgSystemJacontenttype->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:272 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:622 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:688 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 1.06 ms After last query: 6.48 ms Query memory: 0.048 MB Memory before query: 2.561 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.16 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.05 ms Optimizing 0.03 ms Statistics 0.10 ms Preparing 0.05 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.37 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: 1.13 ms After last query: 2.93 ms Query memory: 0.024 MB Memory before query: 2.795 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'bmi55r62feova1mk6suhfpqfgg'
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.10 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.03 ms Optimizing 0.02 ms Statistics 0.10 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.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.03 ms Reset for next command 0.00 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 16 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 15 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 14 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 13 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 12 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 11 Joomla\CMS\Application\SiteApplication->__construct() JROOT/components/com_booklibrary/router.php:247 10 booklibraryParseRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:105 9 Joomla\CMS\Component\Router\RouterLegacy->parse() JROOT/libraries/src/Router/SiteRouter.php:437 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:138 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1071 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.34 ms After last query: 0.51 ms Query memory: 0.025 MB Memory before query: 2.817 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'bmi55r62feova1mk6suhfpqfgg'
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.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.05 ms End of update loop 0.02 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 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.53 ms After last query: 0.23 ms Query memory: 0.022 MB Memory before query: 2.827 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.01 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.04 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.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 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.56 ms After last query: 2.07 ms Query memory: 0.022 MB Memory before query: 2.933 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.06 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.09 ms Preparing 0.03 ms Executing 0.02 ms Sending data 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.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 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.15 ms After last query: 0.13 ms Query memory: 0.005 MB Memory before query: 2.924 MB
UPDATE `b4xfb_extensions`
SET `params` = '{\"mediaversion\":\"678e9f60c882ac4b8c3201b1442301f6\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `b4xfb_extensions` SET `params` = '{\"mediaversion\":\"678e9f60c882ac4b8c3201b1442301f6\"}' WHERE `type` = 'library' AND `element` = 'joomla'Status Duration Starting 0.04 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.00 ms init for update 0.07 ms Updating 0.07 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.74 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.02 ms Reset for next command 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 9 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 8 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 7 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 6 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 5 Joomla\CMS\Factory::getDocument() JROOT/libraries/src/Application/WebApplication.php:1113 4 Joomla\CMS\Application\WebApplication->loadDocument() JROOT/libraries/src/Application/SiteApplication.php:133 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.39 ms After last query: 0.47 ms Query memory: 0.019 MB Memory before query: 2.947 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.04 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.03 ms Optimizing 0.02 ms Statistics 0.02 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.05 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 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.45 ms After last query: 2.05 ms Query memory: 0.020 MB Memory before query: 3.207 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.07 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.03 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.01 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: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: 4.36 ms After last query: 0.07 ms Query memory: 0.125 MB Memory before query: 3.214 MB Rows returned: 818
SELECT c.const, cl.value_const
FROM b4xfb_booklibrary_const_languages as cl
LEFT JOIN b4xfb_booklibrary_languages AS l
ON cl.fk_languagesid=l.id
LEFT JOIN b4xfb_booklibrary_const AS c
ON cl.fk_constid=c.id
WHERE l.lang_code = 'en-GB'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE l system PRIMARY,lang_code NO INDEX KEY COULD BE USED NULL NULL 1 1 SIMPLE cl ALL fk_languagesid NO INDEX KEY COULD BE USED NULL NULL 818 Using where 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 info.cl.fk_constid 1 Using where Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.09 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Executing 0.00 ms Sending data 3.82 ms End of update loop 0.02 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.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 7 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/booklibrary.php:58 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.56 ms After last query: 1.60 ms Query memory: 0.020 MB Memory before query: 3.711 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.08 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.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.06 ms Executing 0.00 ms Sending data 0.06 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.02 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 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.81 ms After last query: 0.96 ms Query memory: 0.026 MB Memory before query: 3.851 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.06 ms checking permissions 0.02 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.60 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.13 ms closing tables 0.01 ms checking permissions 0.01 ms Executing 0.00 ms Sending data 0.08 ms End of update loop 0.01 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.34 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.05 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/joomla/database/driver/mysqli.php:430 10 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 9 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 8 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Menu.php:33 7 Joomla\CMS\Table\Menu->__construct() JROOT/components/com_booklibrary/booklibrary.php:261 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.57 ms After last query: 0.67 ms Query memory: 0.021 MB Memory before query: 3.889 MB Rows returned: 1
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.07 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.09 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.01 ms Unlocking tables 0.00 ms closing tables 0.01 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 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 8 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 7 Joomla\CMS\Table\Table->load() JROOT/components/com_booklibrary/booklibrary.php:262 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.17 ms Query memory: 0.021 MB Memory before query: 3.894 MB Rows returned: 1
SELECT c.name, c.id AS catid, c.parent_id
FROM b4xfb_booklibrary_main_categories AS c
WHERE ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )
AND c.id = 49id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.07 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.04 ms Optimizing 0.02 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.02 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:1652 9 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/booklibrary.php:564 8 PHP_booklibrary::addTitleAndMetaTags() JROOT/components/com_booklibrary/booklibrary.php:2275 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.05 ms Query memory: 0.021 MB Memory before query: 3.900 MB Rows returned: 1
SELECT name, c.id AS catid, parent_id
FROM b4xfb_booklibrary_main_categories AS c
WHERE ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )
AND c.id = 47id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c 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.01 ms Reset for next command 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 9 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/booklibrary.php:573 8 PHP_booklibrary::addTitleAndMetaTags() JROOT/components/com_booklibrary/booklibrary.php:2275 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.99 ms After last query: 0.19 ms Query memory: 0.020 MB Memory before query: 3.905 MB Rows returned: 1
SELECT COUNT(DISTINCT bl.id)
FROM b4xfb_booklibrary AS bl
LEFT JOIN b4xfb_booklibrary_categories AS bc
ON bc.bookid=bl.id
LEFT JOIN b4xfb_booklibrary_main_categories AS c
ON c.id=bc.catid
WHERE c.id = '49'
AND bl.published='1'
AND bl.approved='1'
AND c.published='1'
AND ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 1 SIMPLE bc ref bookid,catid catid 5 const 3 1 SIMPLE bl eq_ref PRIMARY PRIMARY 4 info.bc.bookid 1 Using index condition; Using where Status Duration Starting 0.21 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.07 ms Optimizing 0.04 ms Statistics 0.14 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.10 ms Executing 0.01 ms Sending data 0.08 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.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 8 JDatabaseDriver->loadResult() JROOT/components/com_booklibrary/booklibrary.php:2401 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.68 ms After last query: 0.29 ms Query memory: 0.021 MB Memory before query: 3.919 MB Rows returned: 3
SELECT bl.id, bl.isbn, bl.authors, bl.rating,blr2.rating2, bl.title, bl.fk_lendid, bl.date, bl.hits, bl.URL,bl.imageURL, bl.price, bl.priceunit, bl.language, authors_name
FROM b4xfb_booklibrary AS bl
LEFT JOIN b4xfb_booklibrary_categories AS bc
ON bl.id=bc.bookid
LEFT JOIN b4xfb_booklibrary_main_categories AS c
ON c.id=bc.catid
LEFT JOIN ( SELECT ROUND(avg(blr1.rating)) as rating2, fk_bookid
FROM b4xfb_booklibrary as b
LEFT JOIN b4xfb_booklibrary_review as blr1
on blr1.fk_bookid = b.id
group by blr1.fk_bookid ) blr2
ON blr2.fk_bookid = bl.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 = bl.id
WHERE c.id = '49'
AND bl.published='1'
AND bl.approved='1'
and ( bl.langshow = 'en-GB' or bl.langshow like 'all' or bl.langshow like '' or bl.langshow like '*' or bl.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 ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )
AND c.published='1'
GROUP BY bl.id
ORDER BY title
LIMIT 0,10id select_type table type possible_keys key key_len ref rows Extra 1 PRIMARY c const PRIMARY PRIMARY 4 const 1 Using temporary; Using filesort 1 PRIMARY bc ref bookid,catid catid 5 const 3 1 PRIMARY bl eq_ref PRIMARY PRIMARY 4 info.bc.bookid 1 Using index condition; Using where 1 PRIMARY <derived2> ref key0 key0 5 info.bl.id 2 Using where 1 PRIMARY b2 eq_ref PRIMARY PRIMARY 4 info.bl.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 b index NULL PRIMARY 4 NULL 6 Using index Status Duration Starting 0.20 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.14 ms Optimizing 0.05 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.02 ms Statistics 0.10 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.05 ms Creating tmp table 0.05 ms Sorting result 0.35 ms Executing 0.01 ms Sending data 0.04 ms Executing 0.00 ms Sending data 0.14 ms Creating sort index 0.04 ms Removing tmp table 0.01 ms Creating sort index 0.01 ms End of update loop 0.01 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.00 ms closing tables 0.00 ms Removing tmp table 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.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:2436 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.49 ms After last query: 0.22 ms Query memory: 0.020 MB Memory before query: 3.929 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.06 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.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.00 ms Sending data 0.00 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.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:2448 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.84 ms After last query: 0.05 ms Query memory: 0.020 MB Memory before query: 3.935 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.13 ms checking permissions 0.01 ms Opening tables 0.06 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.16 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.03 ms Creating tmp table 0.04 ms Executing 0.00 ms Sending data 0.07 ms Removing tmp table 0.01 ms Sending data 0.01 ms End of update loop 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.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:2448 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.90 ms After last query: 0.05 ms Query memory: 0.020 MB Memory before query: 3.941 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.14 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.15 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Creating tmp table 0.04 ms Executing 0.00 ms Sending data 0.06 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.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:2448 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.06 ms Query memory: 0.021 MB Memory before query: 3.945 MB Rows returned: 1
SELECT *
FROM b4xfb_booklibrary_main_categories
WHERE id='49'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_booklibrary_main_categories 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.02 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.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 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 8 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/booklibrary.php:2465 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.86 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 3.953 MB Rows returned: 6
SELECT c.id,c.parent_id, c.language, COUNT(bc.bookid) AS books, c.title, c.image, '1' AS display
FROM b4xfb_booklibrary_main_categories as c
LEFT JOIN b4xfb_booklibrary_categories AS bc
ON c.id=bc.catid
LEFT JOIN b4xfb_booklibrary AS bl
ON bl.id=bc.bookid
AND bl.published=1
AND bl.approved=1
WHERE c.section='com_booklibrary'
AND c.published = 1
and ( bl.langshow = 'en-GB' or bl.langshow like 'all' or bl.langshow like '' or bl.langshow like '*' or bl.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 ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )
GROUP BY c.id
ORDER BY parent_id DESC, c.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c ALL cat_idx NO INDEX KEY COULD BE USED NULL NULL 6 Using where; Using temporary; Using filesort 1 SIMPLE bc ALL catid NO INDEX KEY COULD BE USED NULL NULL 6 Using where; Using join buffer (flat, BNL join) 1 SIMPLE bl eq_ref PRIMARY PRIMARY 4 info.bc.bookid 1 Using where Status Duration Starting 0.12 ms checking permissions 0.01 ms Opening tables 0.05 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.03 ms init 0.06 ms Optimizing 0.04 ms Statistics 0.06 ms Preparing 0.04 ms Creating tmp table 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.13 ms Creating sort index 0.03 ms Removing tmp table 0.01 ms Creating sort index 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.01 ms Starting cleanup 0.00 ms Freeing items 0.03 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:2513 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.09 ms Query memory: 0.020 MB Memory before query: 3.962 MB Rows returned: 1
SELECT COUNT(bc.bookid) as books
FROM b4xfb_booklibrary_main_categories as c
LEFT JOIN b4xfb_booklibrary_categories AS bc
ON c.id=bc.catid
LEFT JOIN b4xfb_booklibrary AS bl
ON bl.id=bc.bookid
WHERE c.section='com_booklibrary'
AND bl.published=1
AND bl.approved=1
AND ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )
and ( bl.langshow = 'en-GB' or bl.langshow like 'all' or bl.langshow like '' or bl.langshow like '*' or bl.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 c.id = 49
GROUP BY c.id
ORDER BY c.parent_id DESC, c.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,cat_idx PRIMARY 4 const 1 1 SIMPLE bc ref bookid,catid catid 5 const 3 1 SIMPLE bl eq_ref PRIMARY PRIMARY 4 info.bc.bookid 1 Using index condition; Using where Status Duration Starting 0.08 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.13 ms Preparing 0.01 ms Unlocking tables 0.00 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 closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.33 ms Starting cleanup 0.01 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:2529 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.50 ms After last query: 0.05 ms Query memory: 0.020 MB Memory before query: 3.969 MB Rows returned: 0
SELECT COUNT(bc.bookid) as books
FROM b4xfb_booklibrary_main_categories as c
LEFT JOIN b4xfb_booklibrary_categories AS bc
ON c.id=bc.catid
LEFT JOIN b4xfb_booklibrary AS bl
ON bl.id=bc.bookid
WHERE c.section='com_booklibrary'
AND bl.published=1
AND bl.approved=1
AND ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )
and ( bl.langshow = 'en-GB' or bl.langshow like 'all' or bl.langshow like '' or bl.langshow like '*' or bl.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 c.id = 50
GROUP BY c.id
ORDER BY c.parent_id DESC, c.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,cat_idx PRIMARY 4 const 1 1 SIMPLE bc ref bookid,catid catid 5 const 1 1 SIMPLE bl eq_ref PRIMARY PRIMARY 4 info.bc.bookid 1 Using index condition; Using where Status Duration Starting 0.07 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.04 ms Optimizing 0.03 ms Statistics 0.07 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.03 ms Executing 0.02 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.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:2529 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.03 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 3.981 MB Rows returned: 1
SELECT COUNT(bc.bookid) as books
FROM b4xfb_booklibrary_main_categories as c
LEFT JOIN b4xfb_booklibrary_categories AS bc
ON c.id=bc.catid
LEFT JOIN b4xfb_booklibrary AS bl
ON bl.id=bc.bookid
WHERE c.section='com_booklibrary'
AND bl.published=1
AND bl.approved=1
AND ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )
and ( bl.langshow = 'en-GB' or bl.langshow like 'all' or bl.langshow like '' or bl.langshow like '*' or bl.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 c.id = 51
GROUP BY c.id
ORDER BY c.parent_id DESC, c.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,cat_idx PRIMARY 4 const 1 1 SIMPLE bc ref bookid,catid catid 5 const 1 1 SIMPLE bl eq_ref PRIMARY PRIMARY 4 info.bc.bookid 1 Using index condition; Using where Status Duration Starting 0.19 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.07 ms Optimizing 0.06 ms Statistics 0.14 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.05 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.04 ms Query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.04 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.01 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 8 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/booklibrary.php:2529 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.48 ms After last query: 0.06 ms Query memory: 0.020 MB Memory before query: 3.989 MB Rows returned: 0
SELECT COUNT(bc.bookid) as books
FROM b4xfb_booklibrary_main_categories as c
LEFT JOIN b4xfb_booklibrary_categories AS bc
ON c.id=bc.catid
LEFT JOIN b4xfb_booklibrary AS bl
ON bl.id=bc.bookid
WHERE c.section='com_booklibrary'
AND bl.published=1
AND bl.approved=1
AND ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )
and ( bl.langshow = 'en-GB' or bl.langshow like 'all' or bl.langshow like '' or bl.langshow like '*' or bl.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 c.id = 46
GROUP BY c.id
ORDER BY c.parent_id DESC, c.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,cat_idx PRIMARY 4 const 1 1 SIMPLE bc ref bookid,catid catid 5 const 1 1 SIMPLE bl eq_ref PRIMARY PRIMARY 4 info.bc.bookid 1 Using index condition; Using where Status Duration Starting 0.06 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.05 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 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.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:2529 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.70 ms After last query: 0.17 ms Query memory: 0.020 MB Memory before query: 3.994 MB Rows returned: 1
SELECT COUNT(bc.bookid) as books
FROM b4xfb_booklibrary_main_categories as c
LEFT JOIN b4xfb_booklibrary_categories AS bc
ON c.id=bc.catid
LEFT JOIN b4xfb_booklibrary AS bl
ON bl.id=bc.bookid
WHERE c.section='com_booklibrary'
AND bl.published=1
AND bl.approved=1
AND ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )
and ( bl.langshow = 'en-GB' or bl.langshow like 'all' or bl.langshow like '' or bl.langshow like '*' or bl.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 c.id = 47
GROUP BY c.id
ORDER BY c.parent_id DESC, c.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,cat_idx PRIMARY 4 const 1 1 SIMPLE bc ref bookid,catid catid 5 const 2 1 SIMPLE bl eq_ref PRIMARY PRIMARY 4 info.bc.bookid 1 Using index condition; Using where Status Duration Starting 0.06 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.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.00 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 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:2529 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.44 ms After last query: 0.07 ms Query memory: 0.020 MB Memory before query: 4.000 MB Rows returned: 0
SELECT COUNT(bc.bookid) as books
FROM b4xfb_booklibrary_main_categories as c
LEFT JOIN b4xfb_booklibrary_categories AS bc
ON c.id=bc.catid
LEFT JOIN b4xfb_booklibrary AS bl
ON bl.id=bc.bookid
WHERE c.section='com_booklibrary'
AND bl.published=1
AND bl.approved=1
AND ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )
and ( bl.langshow = 'en-GB' or bl.langshow like 'all' or bl.langshow like '' or bl.langshow like '*' or bl.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 c.id = 48
GROUP BY c.id
ORDER BY c.parent_id DESC, c.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY,cat_idx PRIMARY 4 const 1 1 SIMPLE bc ref bookid,catid catid 5 const 1 1 SIMPLE bl eq_ref PRIMARY PRIMARY 4 info.bc.bookid 1 Using index condition; Using where Status Duration Starting 0.06 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.05 ms Optimizing 0.03 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Executing 0.03 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.03 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 8 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/booklibrary.php:2529 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.34 ms After last query: 0.16 ms Query memory: 0.021 MB Memory before query: 4.011 MB Rows returned: 1
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.05 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.01 ms Commit 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.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 9 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 8 Joomla\CMS\Table\Table->load() JROOT/components/com_booklibrary/booklibrary.php:2545 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.16 ms Query memory: 0.021 MB Memory before query: 4.016 MB Rows returned: 1
SELECT c.name, c.id AS catid, c.parent_id
FROM b4xfb_booklibrary_main_categories AS c
WHERE ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )
AND c.id = 49id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.02 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.05 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.03 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 10 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/booklibrary.php:564 9 PHP_booklibrary::addTitleAndMetaTags() JROOT/components/com_booklibrary/booklibrary.php:2242 8 PHP_booklibrary::constructPathway() JROOT/components/com_booklibrary/booklibrary.php:2556 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.32 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 4.023 MB Rows returned: 1
SELECT name, c.id AS catid, parent_id
FROM b4xfb_booklibrary_main_categories AS c
WHERE ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )
AND c.id = 47id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY PRIMARY 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.01 ms init 0.02 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.02 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:1652 10 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/booklibrary.php:573 9 PHP_booklibrary::addTitleAndMetaTags() JROOT/components/com_booklibrary/booklibrary.php:2242 8 PHP_booklibrary::constructPathway() JROOT/components/com_booklibrary/booklibrary.php:2556 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.40 ms After last query: 0.52 ms Query memory: 0.023 MB Memory before query: 4.030 MB Rows returned: 6
SELECT *
FROM b4xfb_booklibrary_main_categories
WHERE section = 'com_booklibrary'
AND published = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_booklibrary_main_categories ALL cat_idx NO INDEX KEY COULD BE USED NULL NULL 6 Using where 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.02 ms Optimizing 0.02 ms Statistics 0.04 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 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:1691 9 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/booklibrary.php:2250 8 PHP_booklibrary::constructPathway() JROOT/components/com_booklibrary/booklibrary.php:2556 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.52 ms After last query: 0.42 ms Query memory: 0.026 MB Memory before query: 4.125 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'bmi55r62feova1mk6suhfpqfgg'
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.03 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.03 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.05 ms Preparing 0.00 ms Unlocking tables 0.01 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.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.03 ms Reset for next command 0.00 ms # Caller File and line number 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 22 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 21 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 20 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 19 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 18 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 17 Joomla\CMS\Application\SiteApplication->__construct() JROOT/components/com_booklibrary/router.php:21 16 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 15 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 14 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 13 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 12 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 11 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 10 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 9 sefRelToAbs() JROOT/components/com_booklibrary/booklibrary.php:2257 8 PHP_booklibrary::constructPathway() JROOT/components/com_booklibrary/booklibrary.php:2556 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.55 ms After last query: 0.28 ms Query memory: 0.024 MB Memory before query: 4.134 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.00 ms Opening tables 0.01 ms After opening tables 0.08 ms System lock 0.01 ms table lock 0.03 ms init 0.05 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.03 ms Reset for next command 0.01 ms # Caller File and line number 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 17 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/router.php:108 16 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 15 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 14 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 13 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 12 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 11 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 10 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 9 sefRelToAbs() JROOT/components/com_booklibrary/booklibrary.php:2257 8 PHP_booklibrary::constructPathway() JROOT/components/com_booklibrary/booklibrary.php:2556 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.42 ms After last query: 0.64 ms Query memory: 0.020 MB Memory before query: 4.135 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.03 ms After opening tables 0.02 ms System lock 0.03 ms table lock 0.01 ms init 0.02 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.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/components/com_booklibrary/booklibrary.php:2694 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.10 ms Query memory: 0.021 MB Memory before query: 4.143 MB Rows returned: 1
SELECT c.name, c.id AS catid, c.parent_id
FROM b4xfb_booklibrary_main_categories AS c
WHERE ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )
AND c.id = 49id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY PRIMARY 4 const 1 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.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.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:1652 10 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/booklibrary.php:564 9 PHP_booklibrary::addTitleAndMetaTags() JROOT/components/com_booklibrary/booklibrary.php:2075 8 PHP_booklibrary::is_exist_subcategory_books() JROOT/components/com_booklibrary/booklibrary.php:2715 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.04 ms Query memory: 0.021 MB Memory before query: 4.149 MB Rows returned: 1
SELECT name, c.id AS catid, parent_id
FROM b4xfb_booklibrary_main_categories AS c
WHERE ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )
AND c.id = 47id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE c const PRIMARY PRIMARY 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.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 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 10 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/booklibrary.php:573 9 PHP_booklibrary::addTitleAndMetaTags() JROOT/components/com_booklibrary/booklibrary.php:2075 8 PHP_booklibrary::is_exist_subcategory_books() JROOT/components/com_booklibrary/booklibrary.php:2715 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.28 ms After last query: 0.10 ms Query memory: 0.037 MB Memory before query: 4.154 MB Rows returned: 0
SELECT *, COUNT(a.id) AS numlinks
FROM b4xfb_booklibrary_main_categories AS cc,b4xfb_booklibrary_categories AS bc
LEFT JOIN b4xfb_booklibrary AS a
ON a.id = bc.bookid
WHERE bc.catid=cc.id
AND a.published='1'
AND a.approved='1'
AND section='com_booklibrary'
AND parent_id='49'
AND cc.published='1'
GROUP BY cc.id
ORDER BY cc.orderingid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE bc ALL bookid,catid NO INDEX KEY COULD BE USED NULL NULL 6 Using where; Using temporary; Using filesort 1 SIMPLE cc eq_ref PRIMARY,cat_idx PRIMARY 4 info.bc.catid 1 Using where 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 info.bc.bookid 1 Using index condition; Using where Status Duration Starting 0.06 ms checking permissions 0.01 ms Opening tables 0.03 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.06 ms Preparing 0.02 ms Creating tmp table 0.09 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.40 ms Creating sort index 0.07 ms Removing tmp table 0.13 ms Creating sort index 0.01 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.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 9 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/booklibrary.php:2103 8 PHP_booklibrary::is_exist_subcategory_books() JROOT/components/com_booklibrary/booklibrary.php:2715 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.021 MB Memory before query: 4.159 MB Rows returned: 0
SELECT id
FROM b4xfb_booklibrary_main_categories AS cc
WHERE section='com_booklibrary'
AND parent_id='49'
AND published='1'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE cc ALL cat_idx NO INDEX KEY COULD BE USED NULL NULL 6 Using where 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.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 9 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/booklibrary.php:2109 8 PHP_booklibrary::is_exist_subcategory_books() JROOT/components/com_booklibrary/booklibrary.php:2715 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.35 ms After last query: 0.24 ms Query memory: 0.021 MB Memory before query: 4.175 MB Rows returned: 0
SELECT u.id, u.name AS username
FROM b4xfb_users AS u
WHERE u.id = 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.04 ms checking permissions 0.00 ms Opening tables 0.03 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.06 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.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/showCategory/tmpl/list.php:33 9 require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:2713 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.17 ms Query memory: 0.023 MB Memory before query: 4.188 MB Rows returned: 1
SELECT *
FROM b4xfb_menu
WHERE `id` = '542'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_menu const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.01 ms Opening tables 0.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.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.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 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 12 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 11 Joomla\CMS\Table\Table->load() JROOT/components/com_booklibrary/booklibrary.php:4459 10 showTabs_b() JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php:84 9 require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:2713 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.26 ms After last query: 1.98 ms Query memory: 0.028 MB Memory before query: 4.264 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 01:15:51')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-02-09 01:15:51')
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.25 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.06 ms Optimizing 0.05 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.36 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.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 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 20 JDatabaseDriver->loadObjectList() Same as call in the line below. 19 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 18 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452 17 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382 16 Joomla\CMS\Helper\ModuleHelper::load() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87 15 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/plugins/content/loadmodule/loadmodule.php:137 14 PlgContentLoadmodule->_load() JROOT/plugins/content/loadmodule/loadmodule.php:78 13 PlgContentLoadmodule->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_booklibrary/compat.joomla1.5.php:101 10 positions_bl() JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php:89 9 require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:2713 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.71 ms Query memory: 0.027 MB Memory before query: 4.286 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'bmi55r62feova1mk6suhfpqfgg'
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.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.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.02 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.05 ms Reset for next command 0.00 ms # Caller File and line number 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 24 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 23 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 22 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 21 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 20 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 19 Joomla\CMS\Application\SiteApplication->__construct() JROOT/components/com_booklibrary/router.php:21 18 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 17 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 16 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 15 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 14 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 13 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 12 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 11 sefRelToAbs() JROOT/components/com_booklibrary/booklibrary.html.php:325 10 HTML_booklibrary::displaySimpleSearch() JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php:232 9 require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:2713 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.32 ms After last query: 0.59 ms Query memory: 0.027 MB Memory before query: 4.312 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'bmi55r62feova1mk6suhfpqfgg'
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.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.04 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/showCategory/tmpl/list.php:407 9 require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:2713 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.322 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.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: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/showCategory/tmpl/list.php:407 9 require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:2713 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.07 ms Query memory: 0.025 MB Memory before query: 4.331 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.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/showCategory/tmpl/list.php:407 9 require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:2713 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.35 ms Query memory: 0.027 MB Memory before query: 4.356 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'bmi55r62feova1mk6suhfpqfgg'
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/showCategory/tmpl/list.php:472 9 require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:2713 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.07 ms Query memory: 0.025 MB Memory before query: 4.365 MB Rows returned: 1
SELECT a.authors_name
FROM b4xfb_booklibrary_authors AS a
WHERE a.id = 5id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a 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:186 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/showCategory/tmpl/list.php:472 9 require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:2713 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.10 ms Query memory: 0.022 MB Memory before query: 4.374 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.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.04 ms Statistics 0.06 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.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/showCategory/tmpl/list.php:533 9 require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:2713 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.26 ms Query memory: 0.027 MB Memory before query: 4.397 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'bmi55r62feova1mk6suhfpqfgg'
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/showCategory/tmpl/list.php:407 9 require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:2713 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.407 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/showCategory/tmpl/list.php:407 9 require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:2713 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.13 ms Query memory: 0.025 MB Memory before query: 4.417 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.02 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.07 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 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/showCategory/tmpl/list.php:407 9 require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:2713 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.441 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'bmi55r62feova1mk6suhfpqfgg'
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.19 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/showCategory/tmpl/list.php:472 9 require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:2713 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.06 ms Query memory: 0.025 MB Memory before query: 4.451 MB Rows returned: 1
SELECT a.authors_name
FROM b4xfb_booklibrary_authors AS a
WHERE a.id = 6id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a 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.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:186 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/showCategory/tmpl/list.php:472 9 require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:2713 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.11 ms Query memory: 0.021 MB Memory before query: 4.459 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.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.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.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/showCategory/tmpl/list.php:533 9 require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:2713 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.30 ms Query memory: 0.027 MB Memory before query: 4.480 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'bmi55r62feova1mk6suhfpqfgg'
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/showCategory/tmpl/list.php:407 9 require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:2713 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.05 ms Query memory: 0.030 MB Memory before query: 4.499 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/showCategory/tmpl/list.php:407 9 require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:2713 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.08 ms Query memory: 0.025 MB Memory before query: 4.514 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.02 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.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.02 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/showCategory/tmpl/list.php:407 9 require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:2713 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.30 ms Query memory: 0.027 MB Memory before query: 4.539 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'bmi55r62feova1mk6suhfpqfgg'
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/showCategory/tmpl/list.php:472 9 require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:2713 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.04 ms Query memory: 0.025 MB Memory before query: 4.548 MB Rows returned: 1
SELECT a.authors_name
FROM b4xfb_booklibrary_authors AS a
WHERE a.id = 3id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a 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:186 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/showCategory/tmpl/list.php:472 9 require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:2713 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.13 ms Query memory: 0.021 MB Memory before query: 4.557 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.00 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/components/com_booklibrary/views/showCategory/tmpl/list.php:533 9 require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php JROOT/components/com_booklibrary/booklibrary.html.php:120 8 HTML_booklibrary::displayBooks() JROOT/components/com_booklibrary/booklibrary.php:2713 7 PHP_booklibrary::showCategory() JROOT/components/com_booklibrary/booklibrary.php:275 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.64 ms After last query: 11.57 ms Query memory: 0.027 MB Memory before query: 4.836 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'bmi55r62feova1mk6suhfpqfgg'
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.11 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.06 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.00 ms Unlocking tables 0.01 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 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.79 ms After last query: 2.02 ms Query memory: 0.025 MB Memory before query: 4.922 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'bmi55r62feova1mk6suhfpqfgg'
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.11 ms checking permissions 0.01 ms Opening tables 0.05 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.12 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.02 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 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.40 ms After last query: 2.03 ms Query memory: 0.021 MB Memory before query: 4.976 MB Rows returned: 1
SELECT sleep_until < '2026-02-09 01:15:51'
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.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.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php: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
36 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
13 × SELECT `session_id`
FROM `b4xfb_session`6 × SELECT COUNT(bc.bookid) as books
FROM b4xfb_booklibrary_main_categories as c
LEFT JOIN b4xfb_booklibrary_categories AS bc
ON c.id=bc.catid
LEFT JOIN b4xfb_booklibrary AS bl
ON bl.id=bc.bookid4 × SELECT blc.name
FROM b4xfb_booklibrary_main_categories AS blc3 × 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_bookid3 × SELECT *
FROM b4xfb_menu3 × SELECT b.lend_from , b.lend_until
FROM b4xfb_booklibrary_lend AS b
LEFT JOIN b4xfb_booklibrary AS c
ON b.fk_bookid = c.id3 × SELECT a.authors_name
FROM b4xfb_booklibrary_authors AS a3 × 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.catid3 × SELECT name, c.id AS catid, parent_id
FROM b4xfb_booklibrary_main_categories AS c3 × SELECT c.name, c.id AS catid, c.parent_id
FROM b4xfb_booklibrary_main_categories AS c2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `b4xfb_extensions`2 × SELECT *
FROM b4xfb_booklibrary_main_categories1 × SELECT c.id,c.parent_id, c.language, COUNT(bc.bookid) AS books, c.title, c.image, '1' AS display
FROM b4xfb_booklibrary_main_categories as c
LEFT JOIN b4xfb_booklibrary_categories AS bc
ON c.id=bc.catid
LEFT JOIN b4xfb_booklibrary AS bl
ON bl.id=bc.bookid
AND bl.published=1
AND bl.approved=11 × SELECT `data`
FROM `b4xfb_session`1 × SELECT id
FROM `b4xfb_menu`1 × SELECT id
FROM b4xfb_booklibrary_main_categories AS cc1 × SELECT u.id, u.name AS username
FROM b4xfb_users AS u1 × 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 *, COUNT(a.id) AS numlinks
FROM b4xfb_booklibrary_main_categories AS cc,b4xfb_booklibrary_categories AS bc
LEFT JOIN b4xfb_booklibrary AS a
ON a.id = bc.bookid1 × SELECT COUNT(DISTINCT bl.id)
FROM b4xfb_booklibrary AS bl
LEFT JOIN b4xfb_booklibrary_categories AS bc
ON bc.bookid=bl.id
LEFT JOIN b4xfb_booklibrary_main_categories AS c
ON c.id=bc.catid1 × SELECT bl.id, bl.isbn, bl.authors, bl.rating,blr2.rating2, bl.title, bl.fk_lendid, bl.date, bl.hits, bl.URL,bl.imageURL, bl.price, bl.priceunit, bl.language, authors_name
FROM b4xfb_booklibrary AS bl
LEFT JOIN b4xfb_booklibrary_categories AS bc
ON bl.id=bc.bookid
LEFT JOIN b4xfb_booklibrary_main_categories AS c
ON c.id=bc.catid
LEFT JOIN ( SELECT ROUND(avg(blr1.rating)) as rating2, fk_bookid
FROM b4xfb_booklibrary as b
LEFT JOIN b4xfb_booklibrary_review as blr1
on blr1.fk_bookid = b.id
group by blr1.fk_bookid ) blr2
ON blr2.fk_bookid = bl.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 = bl.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 01:15:51'
FROM b4xfb_scheduler_metadata
OTHER Tables:
1 × INSERT INTO `b4xfb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('bmi55r62feova1mk6suhfpqfgg', 1, '1770599751', 0, '', 01 × UPDATE b4xfb_extensions
SET enabled=11 × UPDATE `b4xfb_extensions`
SET `params` = '{\"mediaversion\":\"678e9f60c882ac4b8c3201b1442301f6\"}'1 × SHOW FULL COLUMNS
FROM `b4xfb_menu