Main Menu
Book / Magazine: PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide
| Title: | PHP 6 and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide |
| Categories: | Joomla |
| BookID: | 2 |
| Authors: | Larry Ullman |
| ISBN-10(13): | 032152599X |
| Publisher: | Peachpit Press |
| Publication date: | 2007-12-29 |
| Number of pages: | 648 |
| Language: | English |
| Price: | 31.49 USD |
| Rating: |
|
| Picture: |
|
| Description: |
Product Description It hasn't taken Web developers long to discover that when it comes to creating dynamic, database-driven Web sites, MySQL and PHP provide a winning open source combination. Add this book to the mix, and there's no limit to the powerful, interactive Web sites that developers can create. With step-by-step instructions, complete scripts, and expert tips to guide readers, veteran author and database designer Larry Ullman gets right down to business: After grounding readers with separate discussions of first the scripting language (PHP) and then the database program (MySQL), he goes on to cover security, sessions and cookies, and using additional Web tools, with several sections devoted to creating sample applications. This guide is indispensable for intermediate- to advanced level Web designers who want to replace their static sites with something dynamic. In this edition, the bulk of the new material covers the latest versions of both technologies: PHP 6 (due out in 2008) and MySQL 5 (available now). The book's publication date is likely to beat the official release of PHP 6, making it one of the first books available on the subject. |
Reviews
Add Review
Joomla! Debug Console
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1770612529,
"last": 1770612529,
"now": 1770612529
},
"client": {
"forwarded": "216.73.216.209"
}
},
"registry": {
"com_attachments": {
"current_url": "&return=aHR0cHM6Ly9pbmZvLmlnYWRwb3J0YWwub3JnL2Jvb2stbWFnYXppbmUvNTQyL3ZpZXdfYmwvNDkvam9vbWxhLzMvcGhwLTYtYW5kLW15c3FsLTUtZm9yLWR5bmFtaWMtd2ViLXNpdGVzLXZpc3VhbC1xdWlja3Byby1ndWlkZT8%3D"
},
"current_theme": null,
"current_direction": "ltr",
"current_key_sufix": "__ltr"
},
"user": {
"id": 0,
"name": null,
"username": null,
"email": null,
"password": null,
"password_clear": "",
"block": null,
"sendEmail": 0,
"registerDate": null,
"lastvisitDate": null,
"activation": null,
"params": null,
"groups": [],
"guest": 1,
"lastResetTime": null,
"resetCount": null,
"requireReset": null,
"aid": 0
},
"array": 1
}
}
Time
Memory
Time: 7.52 ms / 7.52 ms Memory: 0.495 MB / 0.87 MB Application: afterLoad
Time: 38.89 ms / 46.41 ms Memory: 1.665 MB / 2.53 MB Application: afterInitialise
Time: 10.88 ms / 57.29 ms Memory: 0.385 MB / 2.92 MB Application: afterRoute
Time: 4.26 ms / 61.55 ms Memory: 0.065 MB / 2.98 MB Application: beforeRenderComponent com_booklibrary
Time: 42.26 ms / 103.81 ms Memory: 1.035 MB / 4.01 MB Application: afterRenderComponent com_booklibrary
Time: 3.90 ms / 107.72 ms Memory: 0.136 MB / 4.15 MB Application: afterDispatch
Time: 7.58 ms / 115.30 ms Memory: 0.489 MB / 4.64 MB Application: beforeRenderModule mod_footer (Footer)
Time: 0.97 ms / 116.27 ms Memory: 0.008 MB / 4.65 MB Application: afterRenderModule mod_footer (Footer)
Time: 0.06 ms / 116.33 ms Memory: 0.000 MB / 4.65 MB Application: beforeRenderModule mod_custom (Newsletter Signup)
Time: 0.34 ms / 116.67 ms Memory: 0.006 MB / 4.65 MB Application: afterRenderModule mod_custom (Newsletter Signup)
Time: 0.04 ms / 116.71 ms Memory: 0.000 MB / 4.65 MB Application: beforeRenderModule mod_custom (Social Channels)
Time: 0.09 ms / 116.80 ms Memory: 0.003 MB / 4.65 MB Application: afterRenderModule mod_custom (Social Channels)
Time: 0.04 ms / 116.83 ms Memory: 0.000 MB / 4.65 MB Application: beforeRenderModule mod_custom (Contact Info)
Time: 0.08 ms / 116.91 ms Memory: 0.003 MB / 4.66 MB Application: afterRenderModule mod_custom (Contact Info)
Time: 0.04 ms / 116.95 ms Memory: 0.000 MB / 4.65 MB Application: beforeRenderModule mod_custom (About Igad Info)
Time: 0.08 ms / 117.02 ms Memory: 0.003 MB / 4.66 MB Application: afterRenderModule mod_custom (About Igad Info)
Time: 0.03 ms / 117.06 ms Memory: 0.000 MB / 4.66 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 1.64 ms / 118.69 ms Memory: 0.038 MB / 4.70 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
Time: 0.07 ms / 118.76 ms Memory: 0.000 MB / 4.69 MB Application: beforeRenderModule mod_menu (User menu)
Time: 0.98 ms / 119.74 ms Memory: 0.021 MB / 4.71 MB Application: afterRenderModule mod_menu (User menu)
Time: 4.40 ms / 124.14 ms Memory: 0.183 MB / 4.90 MB Application: afterRender
Database queries total: 40.79 ms
5.82 MB (6,098,056 Bytes)
61 Queries Logged 40.79 ms
16 duplicate found!
- Query Time: 1.03 ms Query memory: 0.023 MB Memory before query: 1.164 MB Rows returned: 0
SELECT `data`
FROM `b4xfb_session`
WHERE `session_id` = 'ftrma9h2o9o2okb4j5ur1skslv'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.10 ms checking permissions 0.01 ms Opening tables 0.10 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.02 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.35 ms Preparing 0.03 ms Executing 0.02 ms End of update loop 0.01 ms Query end 0.01 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.01 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.32 ms After last query: 0.55 ms Query memory: 0.020 MB Memory before query: 1.179 MB Rows returned: 0
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'ftrma9h2o9o2okb4j5ur1skslv'
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.02 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Executing 0.01 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.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.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.36 ms After last query: 0.12 ms Query memory: 0.004 MB Memory before query: 1.185 MB
INSERT INTO `b4xfb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('ftrma9h2o9o2okb4j5ur1skslv', 1, '1770612529', 0, '', 0)EXPLAIN not possible on query: INSERT INTO `b4xfb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('ftrma9h2o9o2okb4j5ur1skslv', 1, '1770612529', 0, '', 0)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.13 ms init for update 0.04 ms Update 0.21 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.75 ms Query end 0.01 ms closing tables 0.02 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:343 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Query Time: 0.96 ms After last query: 0.84 ms Query memory: 0.024 MB Memory before query: 1.282 MB Rows returned: 40
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `b4xfb_extensions`
WHERE `type` = 'component'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_extensions ref extension extension 82 const 40 Using index condition Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.08 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.11 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.33 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.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.45 ms After last query: 0.75 ms Query memory: 0.021 MB Memory before query: 1.313 MB Rows returned: 4
SELECT id, rules
FROM `b4xfb_viewlevels`id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_viewlevels ALL NULL NO INDEX KEY COULD BE USED NULL NULL 4 Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.10 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.07 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 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.39 ms After last query: 0.10 ms Query memory: 0.021 MB Memory before query: 1.325 MB Rows returned: 1
SELECT b.id
FROM b4xfb_usergroups AS a
LEFT JOIN b4xfb_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE a const PRIMARY PRIMARY 4 const 1 1 SIMPLE b range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 1 Using where; Using index Status Duration Starting 0.04 ms checking permissions 0.00 ms Opening tables 0.05 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.10 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.01 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: 1.13 ms After last query: 0.21 ms Query memory: 0.030 MB Memory before query: 1.347 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.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.04 ms Statistics 0.04 ms Preparing 0.01 ms Sorting result 0.01 ms Executing 0.16 ms Sending data 0.01 ms Creating sort index 0.42 ms End of update loop 0.03 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.05 ms closing tables 0.01 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 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.91 ms After last query: 4.16 ms Query memory: 0.020 MB Memory before query: 1.696 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.26 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.03 ms Statistics 0.16 ms Preparing 0.03 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 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.66 ms After last query: 10.63 ms Query memory: 0.005 MB Memory before query: 2.388 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.11 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 for update 0.15 ms Updating 0.07 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.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.52 ms After last query: 7.32 ms Query memory: 0.048 MB Memory before query: 2.562 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.12 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.03 ms Statistics 0.13 ms Preparing 0.03 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 0.52 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.04 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 17 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() Same as call in the line below. 16 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 15 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 14 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:76 13 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 12 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:131 11 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:374 10 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 9 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:64 8 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 7 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:488 6 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:405 5 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/libraries/src/Application/CMSApplication.php:1070 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:798 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.66 ms After last query: 4.35 ms Query memory: 0.024 MB Memory before query: 2.796 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'ftrma9h2o9o2okb4j5ur1skslv'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_session const PRIMARY PRIMARY 766 const 1 Using index Status Duration Starting 0.13 ms checking permissions 0.01 ms Opening tables 0.03 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.06 ms Preparing 0.00 ms Unlocking tables 0.03 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.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 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.28 ms After last query: 0.46 ms Query memory: 0.025 MB Memory before query: 2.818 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'ftrma9h2o9o2okb4j5ur1skslv'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_session const PRIMARY PRIMARY 766 const 1 Using index Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 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.77 ms After last query: 0.24 ms Query memory: 0.022 MB Memory before query: 2.829 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.06 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.11 ms Preparing 0.05 ms Executing 0.00 ms Sending data 0.18 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.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.53 ms After last query: 2.15 ms Query memory: 0.022 MB Memory before query: 2.935 MB Rows returned: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `b4xfb_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_extensions ref element_clientid,element_folder_clientid,extension extension 484 const,const 1 Using index condition Status Duration Starting 0.09 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.09 ms Preparing 0.02 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 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.36 ms After last query: 0.19 ms Query memory: 0.005 MB Memory before query: 2.925 MB
UPDATE `b4xfb_extensions`
SET `params` = '{\"mediaversion\":\"b4267f1b5d7177a87abe5492da221181\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'EXPLAIN not possible on query: UPDATE `b4xfb_extensions` SET `params` = '{\"mediaversion\":\"b4267f1b5d7177a87abe5492da221181\"}' WHERE `type` = 'library' AND `element` = 'joomla'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 for update 0.05 ms Updating 0.11 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.83 ms Query end 0.04 ms closing tables 0.01 ms Unlocking tables 0.01 ms closing tables 0.01 ms Query end 0.04 ms Starting cleanup 0.01 ms Freeing items 0.01 ms Updating status 0.05 ms Reset for next command 0.01 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.74 ms After last query: 0.56 ms Query memory: 0.019 MB Memory before query: 2.949 MB Rows returned: 1
SELECT *
FROM b4xfb_languages
WHERE published=1
ORDER BY ordering ASCid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_languages ALL NULL NO INDEX KEY COULD BE USED NULL NULL 3 Using where; Using filesort Status Duration Starting 0.07 ms checking permissions 0.01 ms Opening tables 0.08 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.02 ms Creating sort index 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.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 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.49 ms After last query: 2.81 ms Query memory: 0.020 MB Memory before query: 3.208 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.06 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.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.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 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.30 ms After last query: 0.07 ms Query memory: 0.125 MB Memory before query: 3.215 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.05 ms checking permissions 0.00 ms Opening tables 0.06 ms After opening tables 0.03 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.03 ms Statistics 0.08 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.02 ms Executing 0.00 ms Sending data 3.71 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.01 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.01 ms # Caller File and line number 8 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 7 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/booklibrary.php:58 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.47 ms After last query: 1.78 ms Query memory: 0.020 MB Memory before query: 3.713 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.07 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.02 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.07 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 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.20 ms After last query: 2.05 ms Query memory: 0.021 MB Memory before query: 3.862 MB Rows returned: 1Duplicate queries: #24
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.12 ms checking permissions 0.01 ms Opening tables 0.11 ms After opening tables 0.23 ms System lock 0.01 ms table lock 0.01 ms init 0.06 ms Optimizing 0.03 ms Statistics 0.22 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.01 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.11 ms Starting cleanup 0.01 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:1652 9 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/booklibrary.php:564 8 PHP_booklibrary::addTitleAndMetaTags() JROOT/components/com_booklibrary/booklibrary.php:3202 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.08 ms Query memory: 0.021 MB Memory before query: 3.868 MB Rows returned: 1Duplicate queries: #25
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.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.02 ms Optimizing 0.01 ms Statistics 0.15 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.11 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:1652 9 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/booklibrary.php:573 8 PHP_booklibrary::addTitleAndMetaTags() JROOT/components/com_booklibrary/booklibrary.php:3202 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.04 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 3.874 MB Rows returned: 1Duplicate queries: #26
SELECT b.title, c.id AS catid
FROM b4xfb_booklibrary AS b
LEFT JOIN b4xfb_booklibrary_categories AS bc
ON b.id=bc.bookid
LEFT JOIN b4xfb_booklibrary_main_categories AS c
ON c.id=bc.catid
WHERE ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )
AND b.id=3
GROUP BY b.idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b const PRIMARY PRIMARY 4 const 1 1 SIMPLE bc ref bookid,catid bookid 4 const 1 Using where 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 info.bc.catid 1 Using where Status Duration Starting 0.17 ms checking permissions 0.01 ms Opening tables 0.11 ms After opening tables 0.02 ms System lock 0.04 ms table lock 0.01 ms init 0.03 ms Optimizing 0.03 ms Statistics 0.37 ms Preparing 0.01 ms Unlocking tables 0.00 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 closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 9 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/booklibrary.php:590 8 PHP_booklibrary::addTitleAndMetaTags() JROOT/components/com_booklibrary/booklibrary.php:3202 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.08 ms Query memory: 0.021 MB Memory before query: 3.877 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.02 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.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 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 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 8 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/booklibrary.php:3208 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.61 ms After last query: 0.14 ms Query memory: 0.021 MB Memory before query: 3.885 MB Rows returned: 1Duplicate queries: #20
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.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.01 ms init 0.16 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.14 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 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:3210 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.65 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 3.892 MB Rows returned: 1Duplicate queries: #21
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.13 ms table lock 0.10 ms init 0.03 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.11 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:2242 8 PHP_booklibrary::constructPathway() JROOT/components/com_booklibrary/booklibrary.php:3210 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.05 ms Query memory: 0.021 MB Memory before query: 3.898 MB Rows returned: 1Duplicate queries: #22
SELECT b.title, c.id AS catid
FROM b4xfb_booklibrary AS b
LEFT JOIN b4xfb_booklibrary_categories AS bc
ON b.id=bc.bookid
LEFT JOIN b4xfb_booklibrary_main_categories AS c
ON c.id=bc.catid
WHERE ( c.params LIKE '%,-2' or c.params = '-2' or c.params LIKE '-2,%' or c.params LIKE '%,-2,%' )
AND b.id=3
GROUP BY b.idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b const PRIMARY PRIMARY 4 const 1 1 SIMPLE bc ref bookid,catid bookid 4 const 1 Using where 1 SIMPLE c eq_ref PRIMARY PRIMARY 4 info.bc.catid 1 Using where Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.23 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.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:590 9 PHP_booklibrary::addTitleAndMetaTags() JROOT/components/com_booklibrary/booklibrary.php:2242 8 PHP_booklibrary::constructPathway() JROOT/components/com_booklibrary/booklibrary.php:3210 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.38 ms After last query: 0.11 ms Query memory: 0.023 MB Memory before query: 3.901 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.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.04 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 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:3210 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.66 ms Query memory: 0.026 MB Memory before query: 3.933 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'ftrma9h2o9o2okb4j5ur1skslv'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_session const PRIMARY PRIMARY 766 const 1 Using index Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.01 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 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 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:3210 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.20 ms After last query: 0.06 ms Query memory: 0.024 MB Memory before query: 3.942 MB Rows returned: 1
SELECT blc.name
FROM b4xfb_booklibrary_main_categories AS blc
WHERE blc.id = 47id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE blc const PRIMARY PRIMARY 4 const 1 Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.00 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 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:3210 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.64 ms Query memory: 0.026 MB Memory before query: 3.958 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'ftrma9h2o9o2okb4j5ur1skslv'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_session const PRIMARY PRIMARY 766 const 1 Using index Status Duration Starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 21 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 20 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 19 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 18 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 17 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 16 Joomla\CMS\Application\SiteApplication->__construct() JROOT/components/com_booklibrary/router.php:21 15 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 14 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 12 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 9 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 8 sefRelToAbs() JROOT/components/com_booklibrary/booklibrary.php:3212 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.08 ms Query memory: 0.024 MB Memory before query: 3.967 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.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.03 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.24 ms Reset for next command 0.01 ms # Caller File and line number 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 16 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/router.php:108 15 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 14 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 12 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 9 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 8 sefRelToAbs() JROOT/components/com_booklibrary/booklibrary.php:3212 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.80 ms After last query: 0.15 ms Query memory: 0.005 MB Memory before query: 3.975 MB
UPDATE b4xfb_booklibrary
SET featured_clicks = featured_clicks - 1
WHERE featured_clicks > 0
and id = 3EXPLAIN not possible on query: UPDATE b4xfb_booklibrary SET featured_clicks = featured_clicks - 1 WHERE featured_clicks > 0 and id = 3Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init for update 0.28 ms Updating 0.07 ms End of update loop 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.02 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/database.php:33 8 JDatabase->query() JROOT/components/com_booklibrary/booklibrary.php:3219 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.92 ms After last query: 0.07 ms Query memory: 0.006 MB Memory before query: 3.986 MB
UPDATE b4xfb_booklibrary
SET hits = hits + 1
WHERE id = 3EXPLAIN not possible on query: UPDATE b4xfb_booklibrary SET hits = hits + 1 WHERE id = 3Status 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 for update 0.29 ms Updating 0.38 ms End of update loop 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.02 ms closing tables 0.00 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 8 JDatabase->query() JROOT/components/com_booklibrary/booklibrary.php:3224 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.31 ms After last query: 0.07 ms Query memory: 0.005 MB Memory before query: 3.992 MB
UPDATE b4xfb_booklibrary
SET featured_shows = featured_shows - 1
WHERE featured_shows > 0EXPLAIN not possible on query: UPDATE b4xfb_booklibrary SET featured_shows = featured_shows - 1 WHERE featured_shows > 0Status 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 for update 0.02 ms Updating 0.08 ms End of update loop 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/database.php:33 8 JDatabase->query() JROOT/components/com_booklibrary/booklibrary.php:3229 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.58 ms After last query: 0.06 ms Query memory: 0.030 MB Memory before query: 3.999 MB Rows returned: 39
SHOW FULL COLUMNS
FROM `b4xfb_booklibrary`EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `b4xfb_booklibrary`Status Duration Starting 0.03 ms checking permissions 0.00 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.77 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.02 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.11 ms closing tables 0.01 ms checking permissions 0.00 ms Executing 0.00 ms Sending data 0.05 ms End of update loop 0.13 ms Query end 0.01 ms closing tables 0.00 ms Removing tmp table 0.13 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:1691 12 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:430 11 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 10 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 9 Joomla\CMS\Table\Table->__construct() JROOT/components/com_booklibrary/booklibrary.class.php:96 8 mosBooklibrary->__construct() JROOT/components/com_booklibrary/booklibrary.php:3231 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.58 ms After last query: 0.60 ms Query memory: 0.021 MB Memory before query: 4.051 MB Rows returned: 1
SELECT *
FROM b4xfb_booklibrary
WHERE `id` = '3'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_booklibrary 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.01 ms init 0.03 ms Optimizing 0.06 ms Statistics 0.06 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 9 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 8 Joomla\CMS\Table\Table->load() JROOT/components/com_booklibrary/booklibrary.php:3232 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.34 ms After last query: 0.09 ms Query memory: 0.020 MB Memory before query: 4.054 MB Rows returned: 0
SELECT src,type,youtube
FROM b4xfb_booklibrary_video_source AS v
LEFT JOIN b4xfb_booklibrary AS b
ON v.fk_book_id=b.id
WHERE v.fk_book_id =3id 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.06 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.04 ms Preparing 0.01 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 8 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/booklibrary.php:3240 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.04 ms Query memory: 0.020 MB Memory before query: 4.059 MB Rows returned: 0
SELECT src,type
FROM b4xfb_booklibrary_audio_source AS a
LEFT JOIN b4xfb_booklibrary AS b
ON a.fk_book_id=b.id
WHERE a.fk_book_id =3id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.04 ms After opening tables 0.02 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.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.00 ms Updating status 0.01 ms Reset for next command 0.15 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:3249 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.04 ms Query memory: 0.020 MB Memory before query: 4.064 MB Rows returned: 0
SELECT src,kind,scrlang,label
FROM b4xfb_booklibrary_track_source AS t
LEFT JOIN b4xfb_booklibrary AS b
ON t.fk_book_id = b.id
WHERE t.fk_book_id = 3id 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.06 ms checking permissions 0.00 ms Opening tables 0.06 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.12 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 8 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/booklibrary.php:3258 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.06 ms Query memory: 0.021 MB Memory before query: 4.069 MB Rows returned: 1
SELECT catid
FROM b4xfb_booklibrary_categories
WHERE bookid='3'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_booklibrary_categories ref bookid bookid 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.04 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 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 10 JDatabaseDriver->loadColumn() JROOT/components/com_booklibrary/booklibrary.class.php:166 9 mosBooklibrary->setCategs() JROOT/components/com_booklibrary/booklibrary.class.php:223 8 mosBooklibrary->getAccessBook() JROOT/components/com_booklibrary/booklibrary.php:3261 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.10 ms Query memory: 0.021 MB Memory before query: 4.075 MB Rows returned: 1
SELECT params
FROM b4xfb_booklibrary_main_categories
WHERE id IN (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.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:1540 9 JDatabaseDriver->loadColumn() JROOT/components/com_booklibrary/booklibrary.class.php:254 8 mosBooklibrary->getAccessBook() JROOT/components/com_booklibrary/booklibrary.php:3261 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.04 ms Query memory: 0.021 MB Memory before query: 4.080 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:3269 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.10 ms After last query: 0.10 ms Query memory: 0.026 MB Memory before query: 4.086 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.03 ms checking permissions 0.00 ms closing tables 0.00 ms checking permissions 0.00 ms Opening tables 0.57 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Filling schema table 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms checking permissions 0.10 ms closing tables 0.01 ms checking permissions 0.01 ms Executing 0.00 ms Sending data 0.06 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Removing tmp table 0.10 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:1691 12 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:430 11 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:245 10 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:164 9 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Menu.php:33 8 Joomla\CMS\Table\Menu->__construct() JROOT/components/com_booklibrary/booklibrary.php:3287 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.25 ms Query memory: 0.021 MB Memory before query: 4.122 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.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.00 ms init 0.02 ms Optimizing 0.03 ms Statistics 0.07 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.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1455 9 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:731 8 Joomla\CMS\Table\Table->load() JROOT/components/com_booklibrary/booklibrary.php:3288 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.56 ms After last query: 0.20 ms Query memory: 0.020 MB Memory before query: 4.196 MB Rows returned: 0
SELECT username
FROM b4xfb_users
WHERE email='0'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_users ref email email 402 const 1 Using index condition Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.08 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.17 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.03 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.04 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 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 8 JDatabaseDriver->loadResult() JROOT/components/com_booklibrary/booklibrary.php:3375 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.06 ms Query memory: 0.021 MB Memory before query: 4.201 MB Rows returned: 1
SELECT GROUP_CONCAT(a.authors_name SEPARATOR ', ')
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.title ='PHP 6
and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ac ALL fk_bookid,fk_authorid NO INDEX KEY COULD BE USED NULL NULL 6 Using where 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 info.ac.fk_authorid 1 Using index condition 1 SIMPLE b eq_ref PRIMARY PRIMARY 4 info.ac.fk_bookid 1 Using index condition; Using where Status Duration Starting 0.06 ms checking permissions 0.00 ms Opening tables 0.11 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.04 ms Executing 0.00 ms Sending data 0.12 ms End of update loop 0.00 ms Removing tmp table 0.00 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 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:3382 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.04 ms Query memory: 0.021 MB Memory before query: 4.207 MB Rows returned: 1
SELECT *
FROM b4xfb_booklibrary_categories AS bc
LEFT JOIN b4xfb_booklibrary_main_categories AS mc
ON bc.catid=mc.id
AND ( mc.params LIKE '%,-2' or mc.params = '-2' or mc.params LIKE '-2,%' or mc.params LIKE '%,-2,%' )
WHERE bc.bookid=3id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE bc ref bookid bookid 4 const 1 1 SIMPLE mc eq_ref PRIMARY PRIMARY 4 info.bc.catid 1 Using where Status Duration Starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.03 ms Preparing 0.02 ms Executing 0.00 ms Sending data 0.03 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:3393 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.22 ms After last query: 0.05 ms Query memory: 0.020 MB Memory before query: 4.213 MB Rows returned: 0
SELECT title
FROM b4xfb_booklibrary
WHERE authors ='Larry Ullman'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_booklibrary ALL NULL NO INDEX KEY COULD BE USED NULL NULL 6 Using where Status Duration Starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.01 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.02 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.01 ms Reset for next command 0.00 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 8 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/booklibrary.php:3398 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.28 ms After last query: 0.05 ms Query memory: 0.020 MB Memory before query: 4.219 MB Rows returned: 1
SELECT a.id, a.published, a.authors_name
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.title ='PHP 6
and MySQL 5 for Dynamic Web Sites: Visual QuickPro Guide'id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE ac ALL fk_bookid,fk_authorid NO INDEX KEY COULD BE USED NULL NULL 6 Using where 1 SIMPLE a eq_ref PRIMARY PRIMARY 4 info.ac.fk_authorid 1 Using index condition 1 SIMPLE b eq_ref PRIMARY PRIMARY 4 info.ac.fk_bookid 1 Using index condition; Using where 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.01 ms Executing 0.00 ms Sending data 0.06 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 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 8 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/booklibrary.php:3406 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.10 ms Query memory: 0.021 MB Memory before query: 4.225 MB Rows returned: 1
SELECT *
FROM b4xfb_booklibrary_main_categories
WHERE id=49id 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.02 ms checking permissions 0.00 ms Opening tables 0.01 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.00 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.02 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 8 JDatabaseDriver->loadObjectList() JROOT/components/com_booklibrary/booklibrary.php:3444 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.04 ms Query memory: 0.020 MB Memory before query: 4.232 MB Rows returned: 0
select *
from b4xfb_booklibrary_files AS s
where s.fk_book_id=3
ORDER BY s.idid 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.04 ms After opening tables 0.00 ms System lock 0.00 ms table lock 0.01 ms init 0.02 ms Optimizing 0.02 ms Statistics 0.01 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.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:3466 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.50 ms After last query: 3.33 ms Query memory: 0.028 MB Memory before query: 4.324 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 04:48:49')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-02-09 04:48:49')
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.12 ms checking permissions 0.01 ms Opening tables 0.12 ms After opening tables 0.01 ms System lock 0.01 ms table lock 0.01 ms init 0.05 ms Optimizing 0.04 ms Statistics 0.17 ms Preparing 0.04 ms Sorting result 0.01 ms Executing 0.00 ms Sending data 0.01 ms Creating sort index 0.59 ms End of update loop 0.01 ms Query end 0.00 ms Commit 0.01 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1691 20 JDatabaseDriver->loadObjectList() Same as call in the line below. 19 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 18 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452 17 Joomla\CMS\Helper\ModuleHelper::getModuleList() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382 16 Joomla\CMS\Helper\ModuleHelper::load() JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87 15 Joomla\CMS\Helper\ModuleHelper::getModules() JROOT/plugins/content/loadmodule/loadmodule.php:137 14 PlgContentLoadmodule->_load() JROOT/plugins/content/loadmodule/loadmodule.php:78 13 PlgContentLoadmodule->onContentPrepare() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/components/com_booklibrary/compat.joomla1.5.php:101 10 positions_bl() JROOT/components/com_booklibrary/views/view_book/tmpl/default.php:96 9 require JROOT/components/com_booklibrary/views/view_book/tmpl/default.php JROOT/components/com_booklibrary/booklibrary.html.php:712 8 HTML_booklibrary::displayBook() JROOT/components/com_booklibrary/booklibrary.php:3469 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.88 ms Query memory: 0.027 MB Memory before query: 4.345 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'ftrma9h2o9o2okb4j5ur1skslv'
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.07 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.03 ms Optimizing 0.02 ms Statistics 0.05 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 24 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 23 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 22 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 21 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 20 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 19 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 18 Joomla\CMS\Application\SiteApplication->__construct() JROOT/components/com_booklibrary/router.php:21 17 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 16 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 15 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 14 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 13 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 12 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 11 Joomla\CMS\Router\Route::_() JROOT/components/com_booklibrary/compat.joomla1.5.php:293 10 sefRelToAbs() JROOT/components/com_booklibrary/views/view_book/tmpl/default.php:230 9 require JROOT/components/com_booklibrary/views/view_book/tmpl/default.php JROOT/components/com_booklibrary/booklibrary.html.php:712 8 HTML_booklibrary::displayBook() JROOT/components/com_booklibrary/booklibrary.php:3469 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 6 require_once JROOT/components/com_booklibrary/booklibrary.php JROOT/libraries/src/Component/ComponentHelper.php:382 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:357 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:195 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.45 ms After last query: 0.07 ms Query memory: 0.025 MB Memory before query: 4.355 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.10 ms checking permissions 0.01 ms Opening tables 0.02 ms After opening tables 0.00 ms System lock 0.01 ms table lock 0.01 ms init 0.02 ms Optimizing 0.01 ms Statistics 0.06 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 closing tables 0.00 ms Unlocking tables 0.00 ms closing tables 0.00 ms Query end 0.00 ms Starting cleanup 0.00 ms Freeing items 0.00 ms Updating status 0.03 ms Reset for next command 0.00 ms # Caller File and line number 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1652 18 JDatabaseDriver->loadObject() JROOT/components/com_booklibrary/router.php: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/view_book/tmpl/default.php:230 9 require JROOT/components/com_booklibrary/views/view_book/tmpl/default.php JROOT/components/com_booklibrary/booklibrary.html.php:712 8 HTML_booklibrary::displayBook() JROOT/components/com_booklibrary/booklibrary.php:3469 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.23 ms Query memory: 0.021 MB Memory before query: 4.364 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.05 ms checking permissions 0.01 ms Opening tables 0.06 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.07 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.01 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.05 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/view_book/tmpl/default.php:522 9 require JROOT/components/com_booklibrary/views/view_book/tmpl/default.php JROOT/components/com_booklibrary/booklibrary.html.php:712 8 HTML_booklibrary::displayBook() JROOT/components/com_booklibrary/booklibrary.php:3469 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.58 ms Query memory: 0.027 MB Memory before query: 4.387 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'ftrma9h2o9o2okb4j5ur1skslv'
LIMIT 1id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE b4xfb_session const PRIMARY PRIMARY 766 const 1 Using index Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms After opening tables 0.01 ms System lock 0.00 ms table lock 0.01 ms init 0.01 ms Optimizing 0.01 ms Statistics 0.04 ms Preparing 0.00 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.00 ms Query end 0.00 ms Commit 0.00 ms Query end 0.00 ms closing tables 0.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/view_book/tmpl/default.php:711 9 require JROOT/components/com_booklibrary/views/view_book/tmpl/default.php JROOT/components/com_booklibrary/booklibrary.html.php:712 8 HTML_booklibrary::displayBook() JROOT/components/com_booklibrary/booklibrary.php:3469 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.14 ms Query memory: 0.022 MB Memory before query: 4.396 MB Rows returned: 0
SELECT id
FROM b4xfb_booklibrary_review
WHERE fk_bookid='3'
ORDER BY idid select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE NULL NULL NULL NO INDEX KEY COULD BE USED NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration Starting 0.03 ms checking permissions 0.01 ms Opening tables 0.04 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.01 ms Preparing 0.00 ms Executing 0.01 ms End of update loop 0.00 ms Query end 0.00 ms closing tables 0.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.02 ms Reset for next command 0.00 ms # Caller File and line number 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1540 11 JDatabaseDriver->loadColumn() JROOT/components/com_booklibrary/booklibrary.class.php:308 10 mosBooklibrary->getReviews() JROOT/components/com_booklibrary/views/view_book/tmpl/default.php:740 9 require JROOT/components/com_booklibrary/views/view_book/tmpl/default.php JROOT/components/com_booklibrary/booklibrary.html.php:712 8 HTML_booklibrary::displayBook() JROOT/components/com_booklibrary/booklibrary.php:3469 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.34 ms Query memory: 0.027 MB Memory before query: 4.418 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'ftrma9h2o9o2okb4j5ur1skslv'
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/view_book/tmpl/default.php:812 9 require JROOT/components/com_booklibrary/views/view_book/tmpl/default.php JROOT/components/com_booklibrary/booklibrary.html.php:712 8 HTML_booklibrary::displayBook() JROOT/components/com_booklibrary/booklibrary.php:3469 7 PHP_booklibrary::showItemBL() JROOT/components/com_booklibrary/booklibrary.php:249 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.62 ms After last query: 14.17 ms Query memory: 0.027 MB Memory before query: 4.696 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'ftrma9h2o9o2okb4j5ur1skslv'
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.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.07 ms Preparing 0.01 ms Unlocking tables 0.01 ms Preparing 0.02 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.01 ms Query end 0.01 ms Starting cleanup 0.00 ms Freeing items 0.01 ms Updating status 0.02 ms Reset for next command 0.00 ms # Caller File and line number 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.46 ms After last query: 2.25 ms Query memory: 0.025 MB Memory before query: 4.783 MB Rows returned: 1
SELECT `session_id`
FROM `b4xfb_session`
WHERE `session_id` = 'ftrma9h2o9o2okb4j5ur1skslv'
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.06 ms Preparing 0.01 ms Unlocking tables 0.00 ms Preparing 0.01 ms Executing 0.00 ms Sending data 0.01 ms End of update loop 0.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.02 ms Reset for next command 0.00 ms # Caller File and line number 22 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1730 21 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 20 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:152 19 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:757 18 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:134 17 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 16 Joomla\CMS\Application\SiteApplication->__construct() JROOT/components/com_booklibrary/router.php:21 15 booklibraryBuildRoute() JROOT/libraries/src/Component/Router/RouterLegacy.php:69 14 Joomla\CMS\Component\Router\RouterLegacy->build() JROOT/libraries/src/Router/SiteRouter.php:528 13 Joomla\CMS\Router\SiteRouter->buildSefRoute() JROOT/libraries/src/Router/SiteRouter.php:498 12 Joomla\CMS\Router\SiteRouter->_buildSefRoute() JROOT/libraries/src/Router/Router.php:281 11 Joomla\CMS\Router\Router->build() JROOT/libraries/src/Router/SiteRouter.php:154 10 Joomla\CMS\Router\SiteRouter->build() JROOT/libraries/src/Router/Route.php:66 9 Joomla\CMS\Router\Route::_() JROOT/plugins/system/t3/includes/menu/megamenu.php:166 8 T3MenuMegamenu->__construct() JROOT/plugins/system/t3/includes/renderer/megamenurender.php:84 7 JDocumentRendererMegamenuRender->render() JROOT/libraries/src/Document/HtmlDocument.php:491 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:783 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:557 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1041 3 Joomla\CMS\Application\CMSApplication->render() JROOT/libraries/src/Application/SiteApplication.php:780 2 Joomla\CMS\Application\SiteApplication->render() JROOT/libraries/src/Application/CMSApplication.php:201 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - Query Time: 0.60 ms After last query: 1.91 ms Query memory: 0.021 MB Memory before query: 4.836 MB Rows returned: 1
SELECT sleep_until < '2026-02-09 04:48:49'
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.07 ms checking permissions 0.01 ms Opening tables 0.08 ms After opening tables 0.02 ms System lock 0.01 ms table lock 0.01 ms init 0.04 ms Optimizing 0.02 ms Statistics 0.07 ms Preparing 0.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.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: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
45 Query Types Logged, Sorted by Occurrences.
SELECT Tables:
10 × SELECT `session_id`
FROM `b4xfb_session`3 × SELECT *
FROM b4xfb_booklibrary_main_categories2 × SELECT blc.name
FROM b4xfb_booklibrary_main_categories AS blc2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `b4xfb_extensions`2 × SELECT b.title, c.id AS catid
FROM b4xfb_booklibrary AS b
LEFT JOIN b4xfb_booklibrary_categories AS bc
ON b.id=bc.bookid
LEFT JOIN b4xfb_booklibrary_main_categories AS c
ON c.id=bc.catid2 × SELECT name, c.id AS catid, parent_id
FROM b4xfb_booklibrary_main_categories AS c2 × SELECT c.name, c.id AS catid, c.parent_id
FROM b4xfb_booklibrary_main_categories AS c1 × SELECT username
FROM b4xfb_users1 × SELECT params
FROM b4xfb_booklibrary_main_categories1 × SELECT *
FROM b4xfb_menu1 × SELECT *
FROM b4xfb_booklibrary_categories AS bc
LEFT JOIN b4xfb_booklibrary_main_categories AS mc
ON bc.catid=mc.id
AND ( mc.params LIKE '%,-2' or mc.params = '-2' or mc.params LIKE '-2,%' or mc.params LIKE '%,-2,%' )1 × SELECT GROUP_CONCAT(a.authors_name SEPARATOR ', ')
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_bookid1 × SELECT src,kind,scrlang,label
FROM b4xfb_booklibrary_track_source AS t
LEFT JOIN b4xfb_booklibrary AS b
ON t.fk_book_id = b.id1 × SELECT title
FROM b4xfb_booklibrary1 × SELECT a.id, a.published, a.authors_name
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_bookid1 × select *
from b4xfb_booklibrary_files AS s1 × 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 a.authors_name
FROM b4xfb_booklibrary_authors AS a1 × SELECT b.lend_from , b.lend_until
FROM b4xfb_booklibrary_lend AS b
LEFT JOIN b4xfb_booklibrary AS c
ON b.fk_bookid = c.id1 × SELECT id
FROM b4xfb_booklibrary_review1 × SELECT catid
FROM b4xfb_booklibrary_categories1 × SELECT `data`
FROM `b4xfb_session`1 × SELECT src,type
FROM b4xfb_booklibrary_audio_source AS a
LEFT JOIN b4xfb_booklibrary AS b
ON a.fk_book_id=b.id1 × SELECT src,type,youtube
FROM b4xfb_booklibrary_video_source AS v
LEFT JOIN b4xfb_booklibrary AS b
ON v.fk_book_id=b.id1 × SELECT *
FROM b4xfb_booklibrary1 × SELECT *
FROM b4xfb_booklibrary_main_categories1 × 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 04:48:49'
FROM b4xfb_scheduler_metadata
OTHER Tables:
1 × INSERT INTO `b4xfb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES ('ftrma9h2o9o2okb4j5ur1skslv', 1, '1770612529', 0, '', 01 × UPDATE b4xfb_extensions
SET enabled=11 × UPDATE `b4xfb_extensions`
SET `params` = '{\"mediaversion\":\"b4267f1b5d7177a87abe5492da221181\"}'1 × UPDATE b4xfb_booklibrary
SET featured_clicks = featured_clicks - 11 × UPDATE b4xfb_booklibrary
SET hits = hits + 11 × UPDATE b4xfb_booklibrary
SET featured_shows = featured_shows - 11 × SHOW FULL COLUMNS
FROM `b4xfb_booklibrary1 × SHOW FULL COLUMNS
FROM `b4xfb_menu