{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1772408815,
                "last": 1772408815,
                "now": 1772408815
            },
            "client": {
                "forwarded": "216.73.216.113"
            }
        },
        "registry": {
            "com_attachments": {
                "current_url": "&return=aHR0cHM6Ly9pbmZvLmlnYWRwb3J0YWwub3JnL2Jvb2stbWFnYXppbmUvNTQyL3Nob3dDYXRlZ29yeS81MS9waHA%2F"
            },
            "current_theme": null,
            "current_direction": "ltr",
            "current_key_sufix": "__ltr"
        },
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "array": 1,
        "bl_fe_booksort": {
            "field": "title",
            "direction": ""
        }
    }
}

Time

Memory

58 Queries Logged 91.24 ms

1. Query Time: 0.86 ms Query memory: 0.023 MB Memory before query: 1.163 MB Rows returned: 0

   SELECT `data`
   
     FROM `b4xfb_session`
   
     WHERE `session_id` = 'd3gfovl36mrv7r9f91u1ju8s2v'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	b4xfb_session	const	PRIMARY	PRIMARY	766	const	1

   Profile

   Status	Duration
   Starting	0.09 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.11 ms
   Preparing	0.01 ms
   Executing	0.02 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   Query end	0.00 ms
   closing tables	0.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.19 ms
   Reset for next command	0.01 ms

   Call Stack

   #	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

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

2. Query Time: 0.93 ms After last query: 0.61 ms Query memory: 0.020 MB Memory before query: 1.178 MB Rows returned: 0
   Duplicate queries: #11  #12  #39  #49  #50  #53  #56  #57

   SELECT `session_id`
   
     FROM `b4xfb_session`
   
     WHERE `session_id` = 'd3gfovl36mrv7r9f91u1ju8s2v' 
     LIMIT 1

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	b4xfb_session	const	PRIMARY	PRIMARY	766	const	1	Using index

   Profile

   Status	Duration
   Starting	0.09 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init	0.03 ms
   Optimizing	0.02 ms
   Statistics	0.07 ms
   Preparing	0.01 ms
   Executing	0.02 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.01 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.28 ms
   Reset for next command	0.03 ms

   Call Stack

   #	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

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

3. Query Time: 3.91 ms After last query: 0.17 ms Query memory: 0.004 MB Memory before query: 1.184 MB

   INSERT INTO `b4xfb_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('d3gfovl36mrv7r9f91u1ju8s2v', 1, '1772408815', 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `b4xfb_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('d3gfovl36mrv7r9f91u1ju8s2v', 1, '1772408815', 0, '', 0)

   Profile

   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.01 ms
   table lock	0.01 ms
   init for update	0.03 ms
   Update	0.17 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	2.50 ms
   Query end	0.05 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.02 ms
   Starting cleanup	0.01 ms
   Freeing items	0.02 ms
   Updating status	0.07 ms
   Reset for next command	0.01 ms

   Call Stack

   #	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

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

4. Query Time: 1.75 ms After last query: 1.20 ms Query memory: 0.024 MB Memory before query: 1.281 MB Rows returned: 40

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `b4xfb_extensions`
   
     WHERE `type` = 'component'

   Explain

   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

   Profile

   Status	Duration
   Starting	0.14 ms
   checking permissions	0.29 ms
   Opening tables	0.08 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.02 ms
   init	0.19 ms
   Optimizing	0.03 ms
   Statistics	0.14 ms
   Preparing	0.04 ms
   Executing	0.00 ms
   Sending data	0.22 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   Query end	0.00 ms
   closing tables	0.01 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.06 ms
   Reset for next command	0.01 ms

   Call Stack

   #	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

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

5. Query Time: 2.27 ms After last query: 1.19 ms Query memory: 0.021 MB Memory before query: 1.312 MB Rows returned: 4

   SELECT id, rules
   
     FROM `b4xfb_viewlevels`

   Explain

   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

   Profile

   Status	Duration
   Starting	0.09 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.01 ms
   Statistics	0.03 ms
   Preparing	0.02 ms
   Executing	0.00 ms
   Sending data	0.05 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	1.61 ms
   Reset for next command	0.02 ms

   Call Stack

   #	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

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

6. Query Time: 3.83 ms After last query: 0.35 ms Query memory: 0.021 MB Memory before query: 1.324 MB Rows returned: 1

   SELECT b.id
   
     FROM b4xfb_usergroups AS a
   
     LEFT JOIN b4xfb_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt
   
     WHERE a.id = 1

   Explain

   id	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

   Profile

   Status	Duration
   Starting	0.19 ms
   checking permissions	0.04 ms
   Opening tables	0.05 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.17 ms
   Preparing	0.01 ms
   Unlocking tables	0.00 ms
   Preparing	0.05 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.01 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.05 ms
   Reset for next command	0.01 ms

   Call Stack

   #	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

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

7. Query Time: 5.03 ms After last query: 0.64 ms Query memory: 0.030 MB Memory before query: 1.346 MB Rows returned: 89

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM b4xfb_extensions
   
     WHERE enabled = 1 
     AND type = 'plugin' 
     AND state IN (0,1) 
     AND access IN (1)
   
     ORDER BY ordering

   Explain

   id	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

   Profile

   Status	Duration
   Starting	0.37 ms
   checking permissions	0.02 ms
   Opening tables	0.05 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.04 ms
   init	0.08 ms
   Optimizing	0.05 ms
   Statistics	0.16 ms
   Preparing	0.04 ms
   Sorting result	0.02 ms
   Executing	0.00 ms
   Sending data	0.02 ms
   Creating sort index	0.59 ms
   End of update loop	0.01 ms
   Query end	0.03 ms
   Commit	0.01 ms
   Query end	0.00 ms
   closing tables	0.01 ms
   Unlocking tables	0.00 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.07 ms
   Reset for next command	0.01 ms

   Call Stack

   #	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

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

8. Query Time: 3.36 ms After last query: 7.66 ms Query memory: 0.020 MB Memory before query: 1.695 MB Rows returned: 1

   SELECT `enabled`
   
     FROM `b4xfb_extensions`
   
     WHERE `element` = 'com_akeeba' 
     AND `type` = 'component'

   Explain

   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

   Profile

   Status	Duration
   Starting	0.18 ms
   checking permissions	0.01 ms
   Opening tables	0.04 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.02 ms
   init	1.30 ms
   Optimizing	0.11 ms
   Statistics	0.97 ms
   Preparing	0.06 ms
   Executing	0.01 ms
   Sending data	0.08 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.01 ms
   Unlocking tables	0.02 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.07 ms
   Reset for next command	0.01 ms

   Call Stack

   #	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

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

9. Query Time: 2.15 ms After last query: 10.82 ms Query memory: 0.005 MB Memory before query: 2.387 MB

   UPDATE b4xfb_extensions
   
     SET enabled=1
   
     WHERE `type`='plugin' 
     AND `element`='jacontenttype' 
     AND `folder`='ajax'

   Explain

   EXPLAIN not possible on query: UPDATE b4xfb_extensions SET enabled=1 WHERE `type`='plugin' AND `element`='jacontenttype' AND `folder`='ajax'

   Profile

   Status	Duration
   Starting	0.20 ms
   checking permissions	0.02 ms
   Opening tables	0.06 ms
   After opening tables	0.02 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init for update	1.26 ms
   Updating	0.10 ms
   End of update loop	0.01 ms
   Query end	0.01 ms
   Commit	0.02 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.06 ms
   Reset for next command	0.00 ms

   Call Stack

   #	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

   [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

   ---

10. Query Time: 1.93 ms After last query: 9.02 ms Query memory: 0.048 MB Memory before query: 2.561 MB Rows returned: 20

    SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
      FROM b4xfb_menu AS m
    
      LEFT JOIN b4xfb_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

    Explain

    id	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

    Profile

    Status	Duration
    Starting	0.39 ms
    checking permissions	0.02 ms
    Opening tables	0.08 ms
    After opening tables	0.02 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.08 ms
    Optimizing	0.05 ms
    Statistics	0.14 ms
    Preparing	0.05 ms
    Sorting result	0.02 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    Creating sort index	0.44 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.02 ms

    Call Stack

    #	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

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

11. Query Time: 0.84 ms After last query: 3.87 ms Query memory: 0.024 MB Memory before query: 2.794 MB Rows returned: 1
    Duplicate queries: #2  #12  #39  #49  #50  #53  #56  #57

    SELECT `session_id`
    
      FROM `b4xfb_session`
    
      WHERE `session_id` = 'd3gfovl36mrv7r9f91u1ju8s2v' 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b4xfb_session	const	PRIMARY	PRIMARY	766	const	1	Using index

    Profile

    Status	Duration
    Starting	0.16 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.10 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 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.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.04 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	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

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

12. Query Time: 0.99 ms After last query: 0.61 ms Query memory: 0.025 MB Memory before query: 2.817 MB Rows returned: 1
    Duplicate queries: #2  #11  #39  #49  #50  #53  #56  #57

    SELECT `session_id`
    
      FROM `b4xfb_session`
    
      WHERE `session_id` = 'd3gfovl36mrv7r9f91u1ju8s2v' 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b4xfb_session	const	PRIMARY	PRIMARY	766	const	1	Using index

    Profile

    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.05 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	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

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

13. Query Time: 0.60 ms After last query: 0.43 ms Query memory: 0.022 MB Memory before query: 2.827 MB Rows returned: 9

    SELECT id, home, template, s.params
    
      FROM b4xfb_template_styles as s
    
      LEFT JOIN b4xfb_extensions as e 
      ON e.element=s.template 
      AND e.type='template' 
      AND e.client_id=s.client_id
    
      WHERE s.client_id = 0 
      AND e.enabled = 1

    Explain

    id	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

    Profile

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.00 ms
    Opening tables	0.03 ms
    After opening tables	0.00 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.03 ms
    Statistics	0.10 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.10 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.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	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

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

14. Query Time: 0.98 ms After last query: 2.77 ms Query memory: 0.022 MB Memory before query: 2.933 MB Rows returned: 1

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `b4xfb_extensions`
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    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

    Profile

    Status	Duration
    Starting	0.15 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.02 ms
    init	0.06 ms
    Optimizing	0.06 ms
    Statistics	0.16 ms
    Preparing	0.06 ms
    Executing	0.01 ms
    Sending data	0.09 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	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

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

15. Query Time: 2.30 ms After last query: 0.27 ms Query memory: 0.005 MB Memory before query: 2.924 MB

    UPDATE `b4xfb_extensions`
    
      SET `params` = '{\"mediaversion\":\"d5328ad9c9852df2a2b4a2236e06ab88\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    EXPLAIN not possible on query: UPDATE `b4xfb_extensions` SET `params` = '{\"mediaversion\":\"d5328ad9c9852df2a2b4a2236e06ab88\"}' WHERE `type` = 'library' AND `element` = 'joomla'

    Profile

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init for update	0.09 ms
    Updating	0.10 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.87 ms
    Query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	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

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

16. Query Time: 1.07 ms After last query: 1.17 ms Query memory: 0.019 MB Memory before query: 2.947 MB Rows returned: 1

    SELECT *
    
      FROM b4xfb_languages
    
      WHERE published=1
    
      ORDER BY ordering ASC

    Explain

    id	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

    Profile

    Status	Duration
    Starting	0.21 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.08 ms
    Optimizing	0.04 ms
    Statistics	0.05 ms
    Preparing	0.03 ms
    Sorting result	0.02 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.15 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.05 ms
    Reset for next command	0.01 ms

    Call Stack

    #	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

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

17. Query Time: 0.75 ms After last query: 2.77 ms Query memory: 0.020 MB Memory before query: 3.207 MB Rows returned: 1

    SELECT title, lang_code, sef 
      FROM b4xfb_booklibrary_languages

    Explain

    id	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

    Profile

    Status	Duration
    Starting	0.13 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.04 ms
    Reset for next command	0.00 ms

    Call Stack

    #	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

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

18. Query Time: 5.82 ms After last query: 0.08 ms Query memory: 0.125 MB Memory before query: 3.214 MB Rows returned: 818

    SELECT c.const, cl.value_const 
      FROM b4xfb_booklibrary_const_languages as cl 
      LEFT JOIN b4xfb_booklibrary_languages AS l 
      ON cl.fk_languagesid=l.id 
      LEFT JOIN b4xfb_booklibrary_const AS c 
      ON cl.fk_constid=c.id 
      WHERE l.lang_code = 'en-GB'

    Explain

    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

    Profile

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.06 ms
    Optimizing	0.04 ms
    Statistics	0.13 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	4.98 ms
    End of update loop	0.04 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.02 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.04 ms
    Reset for next command	0.01 ms

    Call Stack

    #	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

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

19. Query Time: 0.62 ms After last query: 1.61 ms Query memory: 0.020 MB Memory before query: 3.711 MB Rows returned: 3

    SELECT l.lang_code 
      FROM b4xfb_languages as l

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	l	index	NULL	idx_langcode	28	NULL	3	Using index

    Profile

    Status	Duration
    Starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.07 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	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

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

20. Query Time: 3.25 ms After last query: 1.62 ms Query memory: 0.026 MB Memory before query: 3.851 MB Rows returned: 24

    SHOW FULL COLUMNS 
      FROM `b4xfb_menu`

    Explain

    EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `b4xfb_menu`

    Profile

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    closing tables	0.00 ms
    checking permissions	0.01 ms
    Opening tables	1.82 ms
    After opening tables	0.03 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.03 ms
    Executing	0.00 ms
    Filling schema table	0.02 ms
    Opening tables	0.03 ms
    After opening tables	0.00 ms
    checking permissions	0.30 ms
    closing tables	0.01 ms
    checking permissions	0.01 ms
    Executing	0.00 ms
    Sending data	0.07 ms
    End of update loop	0.02 ms
    Query end	0.01 ms
    closing tables	0.00 ms
    Removing tmp table	0.39 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.01 ms
    Freeing items	0.01 ms
    Updating status	0.05 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    11	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:430
    10	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    9	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    8	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Menu.php:33
    7	Joomla\CMS\Table\Menu->__construct()	JROOT/components/com_booklibrary/booklibrary.php:261
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

21. Query Time: 1.71 ms After last query: 0.98 ms Query memory: 0.021 MB Memory before query: 3.888 MB Rows returned: 1
    Duplicate queries: #35  #47

    SELECT *
    
      FROM b4xfb_menu
    
      WHERE `id` = '542'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b4xfb_menu	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.02 ms
    Statistics	0.11 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.04 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    8	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    7	Joomla\CMS\Table\Table->load()	JROOT/components/com_booklibrary/booklibrary.php:262
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

22. Query Time: 1.71 ms After last query: 0.78 ms Query memory: 0.021 MB Memory before query: 3.894 MB Rows returned: 1
    Duplicate queries: #36  #42

    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 = 51

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.17 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.39 ms
    Optimizing	0.39 ms
    Statistics	0.10 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.04 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    9	JDatabaseDriver->loadObject()	JROOT/components/com_booklibrary/booklibrary.php:564
    8	PHP_booklibrary::addTitleAndMetaTags()	JROOT/components/com_booklibrary/booklibrary.php:2275
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

23. Query Time: 0.54 ms After last query: 0.29 ms Query memory: 0.021 MB Memory before query: 3.900 MB Rows returned: 1
    Duplicate queries: #37  #43

    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 = 47

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.12 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    9	JDatabaseDriver->loadObject()	JROOT/components/com_booklibrary/booklibrary.php:573
    8	PHP_booklibrary::addTitleAndMetaTags()	JROOT/components/com_booklibrary/booklibrary.php:2275
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

24. Query Time: 0.60 ms After last query: 0.26 ms Query memory: 0.020 MB Memory before query: 3.905 MB Rows returned: 1

    SELECT COUNT(DISTINCT bl.id) 
    
                              
      FROM b4xfb_booklibrary AS bl
    
                              
      LEFT JOIN b4xfb_booklibrary_categories AS bc 
      ON bc.bookid=bl.id
    
                              
      LEFT JOIN b4xfb_booklibrary_main_categories AS c 
      ON c.id=bc.catid
    
                              
      WHERE c.id = '51' 
      AND bl.published='1' 
      AND bl.approved='1'
                              
      AND c.published='1' 
                              
      AND ( c.params LIKE '%,-2' or 
                       c.params = '-2' or 
                       c.params LIKE '-2,%' or
                       c.params LIKE '%,-2,%' )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	bc	ref	bookid,catid	catid	5	const	1
    1	SIMPLE	bl	eq_ref	PRIMARY	PRIMARY	4	info.bc.bookid	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.13 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.06 ms
    Executing	0.00 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Removing tmp table	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    8	JDatabaseDriver->loadResult()	JROOT/components/com_booklibrary/booklibrary.php:2401
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

25. Query Time: 3.39 ms After last query: 0.44 ms Query memory: 0.021 MB Memory before query: 3.919 MB Rows returned: 1

    SELECT bl.id, bl.isbn, bl.authors, bl.rating,blr2.rating2, bl.title, bl.fk_lendid, 
                          bl.date, bl.hits, bl.URL,bl.imageURL, bl.price, bl.priceunit, bl.language, authors_name
    
                          
      FROM b4xfb_booklibrary AS bl 
    
                          
      LEFT JOIN b4xfb_booklibrary_categories AS bc 
      ON bl.id=bc.bookid
    
                          
      LEFT JOIN b4xfb_booklibrary_main_categories AS c 
      ON c.id=bc.catid
    
                          
      LEFT JOIN ( SELECT ROUND(avg(blr1.rating)) as rating2, fk_bookid   
                          
      FROM b4xfb_booklibrary as b 
                          
      LEFT JOIN b4xfb_booklibrary_review as blr1 
      on blr1.fk_bookid = b.id 
                          
      group by blr1.fk_bookid ) blr2 
                          
      ON  blr2.fk_bookid = bl.id 
    
        
                          
      LEFT JOIN ( SELECT a.authors_name AS authors_name, b2.id AS book_primary_id 
                          
      FROM b4xfb_booklibrary_authors as a 
                          
      LEFT JOIN b4xfb_booklibrary_authors_connect AS ac2 
      ON ac2.fk_authorid=a.id 
                          
      LEFT JOIN b4xfb_booklibrary as b2 
      ON b2.id=ac2.fk_bookid ) aa 
      on book_primary_id = bl.id 
                        
                          
      WHERE c.id = '51'  
      AND bl.published='1' 
      AND bl.approved='1' 
                           
      and ( bl.langshow = 'en-GB' or bl.langshow like 'all' or bl.langshow like ''  or bl.langshow like '*' or bl.langshow is null)  
      AND ( c.langshow = 'en-GB' or c.langshow like 'all' or c.langshow like '' or  c.langshow like '*' or c.langshow is null)  
      AND ( c.params LIKE '%,-2' or 
                       c.params = '-2' or 
                       c.params LIKE '-2,%' or
                       c.params LIKE '%,-2,%' ) 
      AND c.published='1' 
    
                          
      GROUP BY bl.id 
      ORDER BY title  
     
      LIMIT 0,10

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1	Using temporary; Using filesort
    1	PRIMARY	bc	ref	bookid,catid	catid	5	const	1
    1	PRIMARY	bl	eq_ref	PRIMARY	PRIMARY	4	info.bc.bookid	1	Using index condition; Using where
    1	PRIMARY	<derived2>	ref	key0	key0	5	info.bl.id	2	Using where
    1	PRIMARY	b2	eq_ref	PRIMARY	PRIMARY	4	info.bl.id	1	Using where; Using index
    1	PRIMARY	ac2	ref	fk_bookid,fk_authorid	fk_bookid	5	info.b2.id	1	Using where
    1	PRIMARY	a	eq_ref	PRIMARY	PRIMARY	4	info.ac2.fk_authorid	1	Using where
    2	DERIVED	b	index	NULL	PRIMARY	4	NULL	6	Using index; Using temporary; Using filesort
    2	DERIVED	blr1	ALL	fk_bookid	NO INDEX KEY COULD BE USED	NULL	NULL	2	Using where; Using join buffer (flat, BNL join)

    Profile

    Status	Duration
    Starting	0.14 ms
    checking permissions	0.01 ms
    Opening tables	0.16 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.14 ms
    Optimizing	0.06 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.03 ms
    Creating tmp table	0.03 ms
    Sorting result	0.04 ms
    Statistics	0.20 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.06 ms
    Creating tmp table	0.18 ms
    Sorting result	0.03 ms
    Executing	0.00 ms
    Sending data	0.05 ms
    Executing	0.00 ms
    Sending data	1.22 ms
    Creating sort index	0.10 ms
    Removing tmp table	0.01 ms
    Creating sort index	0.23 ms
    Creating sort index	0.05 ms
    Removing tmp table	0.01 ms
    Creating sort index	0.03 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.00 ms
    Removing tmp table	0.00 ms
    closing tables	0.00 ms
    Removing tmp table	0.00 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.02 ms
    Query end	0.04 ms
    Starting cleanup	0.01 ms
    Freeing items	0.07 ms
    Updating status	0.06 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    8	JDatabaseDriver->loadObjectList()	JROOT/components/com_booklibrary/booklibrary.php:2436
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

26. Query Time: 0.88 ms After last query: 0.23 ms Query memory: 0.020 MB Memory before query: 3.926 MB Rows returned: 1

    SELECT distinct a.authors_name, a.id
                        
      FROM b4xfb_booklibrary_authors as a
                        
      LEFT JOIN b4xfb_booklibrary_authors_connect AS ac 
      ON ac.fk_authorid=a.id
                        
      LEFT JOIN b4xfb_booklibrary as b 
      ON  b.id=ac.fk_bookid
                        
      WHERE b.id ='2'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b	const	PRIMARY	PRIMARY	4	const	1	Using index; Using temporary
    1	SIMPLE	ac	ref	fk_bookid,fk_authorid	fk_bookid	5	const	1	Using index condition; Using where
    1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	info.ac.fk_authorid	1	Using index condition

    Profile

    Status	Duration
    Starting	0.17 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.07 ms
    Statistics	0.11 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 ms
    Creating tmp table	0.06 ms
    Executing	0.01 ms
    Sending data	0.05 ms
    Removing tmp table	0.01 ms
    Sending data	0.00 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    8	JDatabaseDriver->loadObjectList()	JROOT/components/com_booklibrary/booklibrary.php:2448
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

27. Query Time: 0.41 ms After last query: 0.17 ms Query memory: 0.021 MB Memory before query: 3.931 MB Rows returned: 1

    SELECT * 
                          
      FROM b4xfb_booklibrary_main_categories 
                          
      WHERE id='51'

    Explain

    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

    Profile

    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.03 ms
    Optimizing	0.03 ms
    Statistics	0.03 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.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

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    8	JDatabaseDriver->loadObjectList()	JROOT/components/com_booklibrary/booklibrary.php:2465
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

28. Query Time: 1.79 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 3.939 MB Rows returned: 6

    SELECT c.id,c.parent_id, c.language, COUNT(bc.bookid) AS books, c.title, 
                          c.image, '1' AS display 
                          
      FROM  b4xfb_booklibrary_main_categories as c
                          
      LEFT JOIN b4xfb_booklibrary_categories AS bc 
      ON c.id=bc.catid 
    
                          
      LEFT JOIN b4xfb_booklibrary AS bl 
      ON bl.id=bc.bookid 
      AND bl.published=1 
      AND bl.approved=1
                          
      WHERE  c.section='com_booklibrary'
                          
      AND c.published = 1  
      and ( bl.langshow = 'en-GB' or bl.langshow like 'all' or bl.langshow like ''  or bl.langshow like '*' or bl.langshow is null)  
      AND ( c.langshow = 'en-GB' or c.langshow like 'all' or c.langshow like '' or  c.langshow like '*' or c.langshow is null)  
      AND ( c.params LIKE '%,-2' or 
                       c.params = '-2' or 
                       c.params LIKE '-2,%' or
                       c.params LIKE '%,-2,%' )
                          
      GROUP BY c.id 
    
                          
      ORDER BY parent_id DESC, c.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	ALL	cat_idx	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where; Using temporary; Using filesort
    1	SIMPLE	bc	ALL	catid	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where; Using join buffer (flat, BNL join)
    1	SIMPLE	bl	eq_ref	PRIMARY	PRIMARY	4	info.bc.bookid	1	Using where

    Profile

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.11 ms
    Opening tables	0.14 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.23 ms
    Optimizing	0.10 ms
    Statistics	0.12 ms
    Preparing	0.06 ms
    Creating tmp table	0.06 ms
    Sorting result	0.03 ms
    Executing	0.00 ms
    Sending data	0.23 ms
    Creating sort index	0.03 ms
    Removing tmp table	0.01 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.10 ms
    Starting cleanup	0.01 ms
    Freeing items	0.02 ms
    Updating status	0.09 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    8	JDatabaseDriver->loadObjectList()	JROOT/components/com_booklibrary/booklibrary.php:2513
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

29. Query Time: 0.88 ms After last query: 0.14 ms Query memory: 0.020 MB Memory before query: 3.948 MB Rows returned: 1

    SELECT COUNT(bc.bookid) as books  
                              
      FROM  b4xfb_booklibrary_main_categories as c
     
                              
      LEFT JOIN b4xfb_booklibrary_categories AS bc 
      ON c.id=bc.catid 
    
     
                              
      LEFT JOIN b4xfb_booklibrary AS bl 
      ON bl.id=bc.bookid 
     
                              
      WHERE  c.section='com_booklibrary'
     
                              
      AND bl.published=1 
      AND bl.approved=1 
      AND ( c.params LIKE '%,-2' or 
                       c.params = '-2' or 
                       c.params LIKE '-2,%' or
                       c.params LIKE '%,-2,%' ) 
                               
      and ( bl.langshow = 'en-GB' or bl.langshow like 'all' or bl.langshow like ''  or bl.langshow like '*' or bl.langshow is null)  
      AND ( c.langshow = 'en-GB' or c.langshow like 'all' or c.langshow like '' or  c.langshow like '*' or c.langshow is null) 
                              
      AND c.id = 49 
     
                              
      GROUP BY c.id
     
                              
      ORDER BY c.parent_id DESC, c.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,cat_idx	PRIMARY	4	const	1
    1	SIMPLE	bc	ref	bookid,catid	catid	5	const	3
    1	SIMPLE	bl	eq_ref	PRIMARY	PRIMARY	4	info.bc.bookid	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.20 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.00 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.10 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.04 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.06 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    8	JDatabaseDriver->loadObjectList()	JROOT/components/com_booklibrary/booklibrary.php:2529
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

30. Query Time: 2.48 ms After last query: 0.27 ms Query memory: 0.020 MB Memory before query: 3.955 MB Rows returned: 0

    SELECT COUNT(bc.bookid) as books  
                              
      FROM  b4xfb_booklibrary_main_categories as c
     
                              
      LEFT JOIN b4xfb_booklibrary_categories AS bc 
      ON c.id=bc.catid 
    
     
                              
      LEFT JOIN b4xfb_booklibrary AS bl 
      ON bl.id=bc.bookid 
     
                              
      WHERE  c.section='com_booklibrary'
     
                              
      AND bl.published=1 
      AND bl.approved=1 
      AND ( c.params LIKE '%,-2' or 
                       c.params = '-2' or 
                       c.params LIKE '-2,%' or
                       c.params LIKE '%,-2,%' ) 
                               
      and ( bl.langshow = 'en-GB' or bl.langshow like 'all' or bl.langshow like ''  or bl.langshow like '*' or bl.langshow is null)  
      AND ( c.langshow = 'en-GB' or c.langshow like 'all' or c.langshow like '' or  c.langshow like '*' or c.langshow is null) 
                              
      AND c.id = 50 
     
                              
      GROUP BY c.id
     
                              
      ORDER BY c.parent_id DESC, c.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,cat_idx	PRIMARY	4	const	1
    1	SIMPLE	bc	ref	bookid,catid	catid	5	const	1
    1	SIMPLE	bl	eq_ref	PRIMARY	PRIMARY	4	info.bc.bookid	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.18 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.02 ms
    init	0.28 ms
    Optimizing	0.05 ms
    Statistics	0.12 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.05 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.36 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.74 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    8	JDatabaseDriver->loadObjectList()	JROOT/components/com_booklibrary/booklibrary.php:2529
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

31. Query Time: 1.15 ms After last query: 0.27 ms Query memory: 0.020 MB Memory before query: 3.960 MB Rows returned: 1

    SELECT COUNT(bc.bookid) as books  
                              
      FROM  b4xfb_booklibrary_main_categories as c
     
                              
      LEFT JOIN b4xfb_booklibrary_categories AS bc 
      ON c.id=bc.catid 
    
     
                              
      LEFT JOIN b4xfb_booklibrary AS bl 
      ON bl.id=bc.bookid 
     
                              
      WHERE  c.section='com_booklibrary'
     
                              
      AND bl.published=1 
      AND bl.approved=1 
      AND ( c.params LIKE '%,-2' or 
                       c.params = '-2' or 
                       c.params LIKE '-2,%' or
                       c.params LIKE '%,-2,%' ) 
                               
      and ( bl.langshow = 'en-GB' or bl.langshow like 'all' or bl.langshow like ''  or bl.langshow like '*' or bl.langshow is null)  
      AND ( c.langshow = 'en-GB' or c.langshow like 'all' or c.langshow like '' or  c.langshow like '*' or c.langshow is null) 
                              
      AND c.id = 51 
     
                              
      GROUP BY c.id
     
                              
      ORDER BY c.parent_id DESC, c.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,cat_idx	PRIMARY	4	const	1
    1	SIMPLE	bc	ref	bookid,catid	catid	5	const	1
    1	SIMPLE	bl	eq_ref	PRIMARY	PRIMARY	4	info.bc.bookid	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.20 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.08 ms
    Optimizing	0.07 ms
    Statistics	0.15 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.07 ms
    Executing	0.01 ms
    Sending data	0.09 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    8	JDatabaseDriver->loadObjectList()	JROOT/components/com_booklibrary/booklibrary.php:2529
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

32. Query Time: 1.55 ms After last query: 0.16 ms Query memory: 0.020 MB Memory before query: 3.966 MB Rows returned: 0

    SELECT COUNT(bc.bookid) as books  
                              
      FROM  b4xfb_booklibrary_main_categories as c
     
                              
      LEFT JOIN b4xfb_booklibrary_categories AS bc 
      ON c.id=bc.catid 
    
     
                              
      LEFT JOIN b4xfb_booklibrary AS bl 
      ON bl.id=bc.bookid 
     
                              
      WHERE  c.section='com_booklibrary'
     
                              
      AND bl.published=1 
      AND bl.approved=1 
      AND ( c.params LIKE '%,-2' or 
                       c.params = '-2' or 
                       c.params LIKE '-2,%' or
                       c.params LIKE '%,-2,%' ) 
                               
      and ( bl.langshow = 'en-GB' or bl.langshow like 'all' or bl.langshow like ''  or bl.langshow like '*' or bl.langshow is null)  
      AND ( c.langshow = 'en-GB' or c.langshow like 'all' or c.langshow like '' or  c.langshow like '*' or c.langshow is null) 
                              
      AND c.id = 46 
     
                              
      GROUP BY c.id
     
                              
      ORDER BY c.parent_id DESC, c.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,cat_idx	PRIMARY	4	const	1
    1	SIMPLE	bc	ref	bookid,catid	catid	5	const	1
    1	SIMPLE	bl	eq_ref	PRIMARY	PRIMARY	4	info.bc.bookid	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.28 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.07 ms
    Optimizing	0.06 ms
    Statistics	0.14 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.06 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    8	JDatabaseDriver->loadObjectList()	JROOT/components/com_booklibrary/booklibrary.php:2529
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

33. Query Time: 0.88 ms After last query: 0.17 ms Query memory: 0.022 MB Memory before query: 3.978 MB Rows returned: 1

    SELECT COUNT(bc.bookid) as books  
                              
      FROM  b4xfb_booklibrary_main_categories as c
     
                              
      LEFT JOIN b4xfb_booklibrary_categories AS bc 
      ON c.id=bc.catid 
    
     
                              
      LEFT JOIN b4xfb_booklibrary AS bl 
      ON bl.id=bc.bookid 
     
                              
      WHERE  c.section='com_booklibrary'
     
                              
      AND bl.published=1 
      AND bl.approved=1 
      AND ( c.params LIKE '%,-2' or 
                       c.params = '-2' or 
                       c.params LIKE '-2,%' or
                       c.params LIKE '%,-2,%' ) 
                               
      and ( bl.langshow = 'en-GB' or bl.langshow like 'all' or bl.langshow like ''  or bl.langshow like '*' or bl.langshow is null)  
      AND ( c.langshow = 'en-GB' or c.langshow like 'all' or c.langshow like '' or  c.langshow like '*' or c.langshow is null) 
                              
      AND c.id = 47 
     
                              
      GROUP BY c.id
     
                              
      ORDER BY c.parent_id DESC, c.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,cat_idx	PRIMARY	4	const	1
    1	SIMPLE	bc	ref	bookid,catid	catid	5	const	2
    1	SIMPLE	bl	eq_ref	PRIMARY	PRIMARY	4	info.bc.bookid	1	Using index condition; Using where

    Profile

    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.00 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.04 ms
    Statistics	0.10 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.04 ms
    Executing	0.00 ms
    Sending data	0.06 ms
    End of update loop	0.03 ms
    Query end	0.01 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.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    8	JDatabaseDriver->loadObjectList()	JROOT/components/com_booklibrary/booklibrary.php:2529
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

34. Query Time: 1.17 ms After last query: 0.10 ms Query memory: 0.020 MB Memory before query: 3.986 MB Rows returned: 0

    SELECT COUNT(bc.bookid) as books  
                              
      FROM  b4xfb_booklibrary_main_categories as c
     
                              
      LEFT JOIN b4xfb_booklibrary_categories AS bc 
      ON c.id=bc.catid 
    
     
                              
      LEFT JOIN b4xfb_booklibrary AS bl 
      ON bl.id=bc.bookid 
     
                              
      WHERE  c.section='com_booklibrary'
     
                              
      AND bl.published=1 
      AND bl.approved=1 
      AND ( c.params LIKE '%,-2' or 
                       c.params = '-2' or 
                       c.params LIKE '-2,%' or
                       c.params LIKE '%,-2,%' ) 
                               
      and ( bl.langshow = 'en-GB' or bl.langshow like 'all' or bl.langshow like ''  or bl.langshow like '*' or bl.langshow is null)  
      AND ( c.langshow = 'en-GB' or c.langshow like 'all' or c.langshow like '' or  c.langshow like '*' or c.langshow is null) 
                              
      AND c.id = 48 
     
                              
      GROUP BY c.id
     
                              
      ORDER BY c.parent_id DESC, c.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY,cat_idx	PRIMARY	4	const	1
    1	SIMPLE	bc	ref	bookid,catid	catid	5	const	1
    1	SIMPLE	bl	eq_ref	PRIMARY	PRIMARY	4	info.bc.bookid	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.05 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.04 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    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.58 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    8	JDatabaseDriver->loadObjectList()	JROOT/components/com_booklibrary/booklibrary.php:2529
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

35. Query Time: 2.04 ms After last query: 0.35 ms Query memory: 0.021 MB Memory before query: 3.996 MB Rows returned: 1
    Duplicate queries: #21  #47

    SELECT *
    
      FROM b4xfb_menu
    
      WHERE `id` = '542'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b4xfb_menu	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.07 ms
    Optimizing	0.03 ms
    Statistics	0.10 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.04 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.03 ms
    Freeing items	0.01 ms
    Updating status	0.69 ms
    Reset for next command	0.06 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    9	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    8	Joomla\CMS\Table\Table->load()	JROOT/components/com_booklibrary/booklibrary.php:2545
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

36. Query Time: 1.24 ms After last query: 0.88 ms Query memory: 0.021 MB Memory before query: 4.002 MB Rows returned: 1
    Duplicate queries: #22  #42

    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 = 51

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.22 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.05 ms
    Optimizing	0.06 ms
    Statistics	0.12 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.02 ms
    Query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.04 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    10	JDatabaseDriver->loadObject()	JROOT/components/com_booklibrary/booklibrary.php:564
    9	PHP_booklibrary::addTitleAndMetaTags()	JROOT/components/com_booklibrary/booklibrary.php:2242
    8	PHP_booklibrary::constructPathway()	JROOT/components/com_booklibrary/booklibrary.php:2556
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

37. Query Time: 0.40 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 4.009 MB Rows returned: 1
    Duplicate queries: #23  #43

    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 = 47

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1

    Profile

    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.02 ms
    Statistics	0.03 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.03 ms
    Sending data	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.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    10	JDatabaseDriver->loadObject()	JROOT/components/com_booklibrary/booklibrary.php:573
    9	PHP_booklibrary::addTitleAndMetaTags()	JROOT/components/com_booklibrary/booklibrary.php:2242
    8	PHP_booklibrary::constructPathway()	JROOT/components/com_booklibrary/booklibrary.php:2556
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

38. Query Time: 0.78 ms After last query: 0.68 ms Query memory: 0.023 MB Memory before query: 4.016 MB Rows returned: 6

    SELECT * 
                          
      FROM b4xfb_booklibrary_main_categories 
                          
      WHERE section = 'com_booklibrary' 
      AND published = 1

    Explain

    id	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

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.00 ms
    System lock	0.02 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.06 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    9	JDatabaseDriver->loadObjectList()	JROOT/components/com_booklibrary/booklibrary.php:2250
    8	PHP_booklibrary::constructPathway()	JROOT/components/com_booklibrary/booklibrary.php:2556
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

39. Query Time: 0.47 ms After last query: 0.68 ms Query memory: 0.026 MB Memory before query: 4.110 MB Rows returned: 1
    Duplicate queries: #2  #11  #12  #49  #50  #53  #56  #57

    SELECT `session_id`
    
      FROM `b4xfb_session`
    
      WHERE `session_id` = 'd3gfovl36mrv7r9f91u1ju8s2v' 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b4xfb_session	const	PRIMARY	PRIMARY	766	const	1	Using index

    Profile

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.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.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.03 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    22	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
    21	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
    20	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
    19	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
    18	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
    17	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/components/com_booklibrary/router.php:21
    16	booklibraryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    15	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    14	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    13	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    12	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    11	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    10	Joomla\CMS\Router\Route::_()	JROOT/components/com_booklibrary/compat.joomla1.5.php:293
    9	sefRelToAbs()	JROOT/components/com_booklibrary/booklibrary.php:2257
    8	PHP_booklibrary::constructPathway()	JROOT/components/com_booklibrary/booklibrary.php:2556
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

40. Query Time: 0.37 ms After last query: 0.08 ms Query memory: 0.024 MB Memory before query: 4.119 MB Rows returned: 1

    SELECT blc.name 
      FROM b4xfb_booklibrary_main_categories AS blc 
      WHERE blc.id = 47

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	blc	const	PRIMARY	PRIMARY	4	const	1

    Profile

    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.07 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.04 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    17	JDatabaseDriver->loadObject()	JROOT/components/com_booklibrary/router.php:108
    16	booklibraryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    15	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    14	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    13	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    12	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    11	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    10	Joomla\CMS\Router\Route::_()	JROOT/components/com_booklibrary/compat.joomla1.5.php:293
    9	sefRelToAbs()	JROOT/components/com_booklibrary/booklibrary.php:2257
    8	PHP_booklibrary::constructPathway()	JROOT/components/com_booklibrary/booklibrary.php:2556
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

41. Query Time: 0.54 ms After last query: 0.69 ms Query memory: 0.020 MB Memory before query: 4.121 MB Rows returned: 0

    SELECT id  
      FROM `b4xfb_menu` 
      WHERE menutype like '%menu%' 
      AND link LIKE '%index.php?option=com_booklibrary&view=view_book%'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b4xfb_menu	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	73	Using where

    Profile

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.14 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

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    8	JDatabaseDriver->loadResult()	JROOT/components/com_booklibrary/booklibrary.php:2694
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

42. Query Time: 0.44 ms After last query: 0.17 ms Query memory: 0.021 MB Memory before query: 4.128 MB Rows returned: 1
    Duplicate queries: #22  #36

    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 = 51

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1

    Profile

    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.03 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    10	JDatabaseDriver->loadObject()	JROOT/components/com_booklibrary/booklibrary.php:564
    9	PHP_booklibrary::addTitleAndMetaTags()	JROOT/components/com_booklibrary/booklibrary.php:2075
    8	PHP_booklibrary::is_exist_subcategory_books()	JROOT/components/com_booklibrary/booklibrary.php:2715
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

43. Query Time: 0.25 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 4.135 MB Rows returned: 1
    Duplicate queries: #23  #37

    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 = 47

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    10	JDatabaseDriver->loadObject()	JROOT/components/com_booklibrary/booklibrary.php:573
    9	PHP_booklibrary::addTitleAndMetaTags()	JROOT/components/com_booklibrary/booklibrary.php:2075
    8	PHP_booklibrary::is_exist_subcategory_books()	JROOT/components/com_booklibrary/booklibrary.php:2715
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

44. Query Time: 3.14 ms After last query: 0.08 ms Query memory: 0.037 MB Memory before query: 4.140 MB Rows returned: 0

    SELECT *, COUNT(a.id) AS numlinks 
                          
      FROM b4xfb_booklibrary_main_categories AS cc,b4xfb_booklibrary_categories AS bc
     
                          
      LEFT JOIN b4xfb_booklibrary AS a 
      ON a.id = bc.bookid
     
                          
      WHERE bc.catid=cc.id 
      AND a.published='1' 
      AND a.approved='1' 
                          
      AND section='com_booklibrary' 
                          
      AND parent_id='51' 
      AND cc.published='1'
     
                          
      GROUP BY cc.id
     
                          
      ORDER BY cc.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	bc	ALL	bookid,catid	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where; Using temporary; Using filesort
    1	SIMPLE	cc	eq_ref	PRIMARY,cat_idx	PRIMARY	4	info.bc.catid	1	Using where
    1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	info.bc.bookid	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.45 ms
    checking permissions	0.02 ms
    Opening tables	0.07 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.13 ms
    Optimizing	0.06 ms
    Statistics	0.22 ms
    Preparing	0.05 ms
    Creating tmp table	0.15 ms
    Sorting result	0.02 ms
    Executing	0.00 ms
    Sending data	0.79 ms
    Creating sort index	0.06 ms
    Removing tmp table	0.14 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.05 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.02 ms
    Updating status	0.53 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    9	JDatabaseDriver->loadObjectList()	JROOT/components/com_booklibrary/booklibrary.php:2103
    8	PHP_booklibrary::is_exist_subcategory_books()	JROOT/components/com_booklibrary/booklibrary.php:2715
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

45. Query Time: 1.38 ms After last query: 0.14 ms Query memory: 0.021 MB Memory before query: 4.145 MB Rows returned: 0

    SELECT id 
                          
      FROM b4xfb_booklibrary_main_categories AS cc  
                          
      WHERE section='com_booklibrary' 
      AND parent_id='51' 
      AND published='1'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	cc	ALL	cat_idx	NO INDEX KEY COULD BE USED	NULL	NULL	6	Using where

    Profile

    Status	Duration
    Starting	0.17 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.04 ms
    Optimizing	0.03 ms
    Statistics	0.07 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.04 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.04 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    9	JDatabaseDriver->loadObjectList()	JROOT/components/com_booklibrary/booklibrary.php:2109
    8	PHP_booklibrary::is_exist_subcategory_books()	JROOT/components/com_booklibrary/booklibrary.php:2715
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

46. Query Time: 0.82 ms After last query: 1.63 ms Query memory: 0.021 MB Memory before query: 4.161 MB Rows returned: 0

    SELECT u.id, u.name AS username 
              
      FROM b4xfb_users AS u 
              
      WHERE u.id = 0

    Explain

    id	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

    Profile

    Status	Duration
    Starting	0.28 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.09 ms
    Preparing	0.01 ms
    Executing	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    10	JDatabaseDriver->loadObjectList()	JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php:33
    9	require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php	JROOT/components/com_booklibrary/booklibrary.html.php:120
    8	HTML_booklibrary::displayBooks()	JROOT/components/com_booklibrary/booklibrary.php:2713
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

47. Query Time: 0.55 ms After last query: 0.38 ms Query memory: 0.023 MB Memory before query: 4.174 MB Rows returned: 1
    Duplicate queries: #21  #35

    SELECT *
    
      FROM b4xfb_menu
    
      WHERE `id` = '542'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b4xfb_menu	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.06 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.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.01 ms
    closing tables	0.01 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1455
    12	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    11	Joomla\CMS\Table\Table->load()	JROOT/components/com_booklibrary/booklibrary.php:4459
    10	showTabs_b()	JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php:84
    9	require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php	JROOT/components/com_booklibrary/booklibrary.html.php:120
    8	HTML_booklibrary::displayBooks()	JROOT/components/com_booklibrary/booklibrary.php:2713
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

48. Query Time: 2.13 ms After last query: 2.80 ms Query memory: 0.028 MB Memory before query: 4.250 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-03-01 23:46:55') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-03-01 23:46:55') 
      AND m.access IN (1) 
      AND m.client_id = 0 
      AND (mm.menuid = 542 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	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

    Profile

    Status	Duration
    Starting	0.18 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.07 ms
    Optimizing	0.14 ms
    Statistics	0.16 ms
    Preparing	0.06 ms
    Sorting result	0.02 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.48 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.64 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    20	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:452
    17	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:382
    16	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:87
    15	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/plugins/content/loadmodule/loadmodule.php:137
    14	PlgContentLoadmodule->_load()	JROOT/plugins/content/loadmodule/loadmodule.php:78
    13	PlgContentLoadmodule->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    11	JEventDispatcher->trigger()	JROOT/components/com_booklibrary/compat.joomla1.5.php:101
    10	positions_bl()	JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php:89
    9	require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php	JROOT/components/com_booklibrary/booklibrary.html.php:120
    8	HTML_booklibrary::displayBooks()	JROOT/components/com_booklibrary/booklibrary.php:2713
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

49. Query Time: 1.25 ms After last query: 1.11 ms Query memory: 0.027 MB Memory before query: 4.272 MB Rows returned: 1
    Duplicate queries: #2  #11  #12  #39  #50  #53  #56  #57

    SELECT `session_id`
    
      FROM `b4xfb_session`
    
      WHERE `session_id` = 'd3gfovl36mrv7r9f91u1ju8s2v' 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b4xfb_session	const	PRIMARY	PRIMARY	766	const	1	Using index

    Profile

    Status	Duration
    Starting	0.10 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.10 ms
    init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.09 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.60 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    24	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
    23	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
    22	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
    21	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
    20	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
    19	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/components/com_booklibrary/router.php:21
    18	booklibraryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    17	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    12	Joomla\CMS\Router\Route::_()	JROOT/components/com_booklibrary/compat.joomla1.5.php:293
    11	sefRelToAbs()	JROOT/components/com_booklibrary/booklibrary.html.php:325
    10	HTML_booklibrary::displaySimpleSearch()	JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php:232
    9	require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php	JROOT/components/com_booklibrary/booklibrary.html.php:120
    8	HTML_booklibrary::displayBooks()	JROOT/components/com_booklibrary/booklibrary.php:2713
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

50. Query Time: 0.65 ms After last query: 0.85 ms Query memory: 0.027 MB Memory before query: 4.298 MB Rows returned: 1
    Duplicate queries: #2  #11  #12  #39  #49  #53  #56  #57

    SELECT `session_id`
    
      FROM `b4xfb_session`
    
      WHERE `session_id` = 'd3gfovl36mrv7r9f91u1ju8s2v' 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b4xfb_session	const	PRIMARY	PRIMARY	766	const	1	Using index

    Profile

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.07 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.06 ms
    Preparing	0.01 ms
    Unlocking tables	0.02 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.03 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    23	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
    22	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
    21	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
    20	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
    19	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
    18	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/components/com_booklibrary/router.php:21
    17	booklibraryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    16	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    15	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    14	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    11	Joomla\CMS\Router\Route::_()	JROOT/components/com_booklibrary/compat.joomla1.5.php:293
    10	sefRelToAbs()	JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php:407
    9	require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php	JROOT/components/com_booklibrary/booklibrary.html.php:120
    8	HTML_booklibrary::displayBooks()	JROOT/components/com_booklibrary/booklibrary.php:2713
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

51. Query Time: 1.40 ms After last query: 0.08 ms Query memory: 0.025 MB Memory before query: 4.308 MB Rows returned: 1

    SELECT blc.name 
      FROM b4xfb_booklibrary_main_categories AS blc 
      WHERE blc.id = 51

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	blc	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.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.01 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	1.02 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    18	JDatabaseDriver->loadObject()	JROOT/components/com_booklibrary/router.php:108
    17	booklibraryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    16	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    15	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    14	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    11	Joomla\CMS\Router\Route::_()	JROOT/components/com_booklibrary/compat.joomla1.5.php:293
    10	sefRelToAbs()	JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php:407
    9	require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php	JROOT/components/com_booklibrary/booklibrary.html.php:120
    8	HTML_booklibrary::displayBooks()	JROOT/components/com_booklibrary/booklibrary.php:2713
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

52. Query Time: 1.32 ms After last query: 0.20 ms Query memory: 0.025 MB Memory before query: 4.317 MB Rows returned: 1

    SELECT bc.catid AS catid, b.title
     
      FROM b4xfb_booklibrary AS b
     
      LEFT JOIN b4xfb_booklibrary_categories AS bc 
      ON bc.bookid=b.id
     
      LEFT JOIN b4xfb_booklibrary_main_categories AS blc 
      ON blc.id=bc.catid
     
      WHERE b.id = 2

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	bc	ref	bookid	bookid	4	const	1

    Profile

    Status	Duration
    Starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.11 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 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.01 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.95 ms
    Reset for next command	0.17 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    18	JDatabaseDriver->loadObject()	JROOT/components/com_booklibrary/router.php:168
    17	booklibraryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    16	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    15	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    14	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    11	Joomla\CMS\Router\Route::_()	JROOT/components/com_booklibrary/compat.joomla1.5.php:293
    10	sefRelToAbs()	JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php:407
    9	require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php	JROOT/components/com_booklibrary/booklibrary.html.php:120
    8	HTML_booklibrary::displayBooks()	JROOT/components/com_booklibrary/booklibrary.php:2713
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

53. Query Time: 1.15 ms After last query: 0.78 ms Query memory: 0.027 MB Memory before query: 4.341 MB Rows returned: 1
    Duplicate queries: #2  #11  #12  #39  #49  #50  #56  #57

    SELECT `session_id`
    
      FROM `b4xfb_session`
    
      WHERE `session_id` = 'd3gfovl36mrv7r9f91u1ju8s2v' 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b4xfb_session	const	PRIMARY	PRIMARY	766	const	1	Using index

    Profile

    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.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.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.60 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1730
    23	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
    22	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
    21	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
    20	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
    19	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
    18	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/components/com_booklibrary/router.php:21
    17	booklibraryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    16	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    15	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    14	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    11	Joomla\CMS\Router\Route::_()	JROOT/components/com_booklibrary/compat.joomla1.5.php:293
    10	sefRelToAbs()	JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php:472
    9	require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php	JROOT/components/com_booklibrary/booklibrary.html.php:120
    8	HTML_booklibrary::displayBooks()	JROOT/components/com_booklibrary/booklibrary.php:2713
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

54. Query Time: 3.29 ms After last query: 0.10 ms Query memory: 0.025 MB Memory before query: 4.351 MB Rows returned: 1

    SELECT a.authors_name
     
      FROM b4xfb_booklibrary_authors AS a
     
      WHERE a.id = 2

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.01 ms
    Unlocking tables	0.00 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	1.33 ms
    Reset for next command	0.04 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1652
    18	JDatabaseDriver->loadObject()	JROOT/components/com_booklibrary/router.php:186
    17	booklibraryBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    16	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:528
    15	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
    14	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    13	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
    12	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:66
    11	Joomla\CMS\Router\Route::_()	JROOT/components/com_booklibrary/compat.joomla1.5.php:293
    10	sefRelToAbs()	JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php:472
    9	require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php	JROOT/components/com_booklibrary/booklibrary.html.php:120
    8	HTML_booklibrary::displayBooks()	JROOT/components/com_booklibrary/booklibrary.php:2713
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

55. Query Time: 1.73 ms After last query: 0.59 ms Query memory: 0.021 MB Memory before query: 4.360 MB Rows returned: 0

    SELECT  b.lend_from , b.lend_until  
                                              
      FROM b4xfb_booklibrary_lend  AS b 
                                              
      LEFT JOIN b4xfb_booklibrary AS c 
      ON b.fk_bookid = c.id 
                                              
      WHERE  c.id=2 
      AND c.published='1' 
                                              
      AND c.approved='1' 
      AND b.lend_return IS NULL

    Explain

    id	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

    Profile

    Status	Duration
    Starting	0.20 ms
    checking permissions	0.01 ms
    Opening tables	0.07 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.08 ms
    Optimizing	0.66 ms
    Statistics	0.15 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.02 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.04 ms
    Reset for next command	0.01 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1691
    10	JDatabaseDriver->loadObjectList()	JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php:533
    9	require JROOT/components/com_booklibrary/views/showCategory/tmpl/list.php	JROOT/components/com_booklibrary/booklibrary.html.php:120
    8	HTML_booklibrary::displayBooks()	JROOT/components/com_booklibrary/booklibrary.php:2713
    7	PHP_booklibrary::showCategory()	JROOT/components/com_booklibrary/booklibrary.php:275
    6	require_once JROOT/components/com_booklibrary/booklibrary.php	JROOT/libraries/src/Component/ComponentHelper.php:382
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:357
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

56. Query Time: 1.21 ms After last query: 15.35 ms Query memory: 0.027 MB Memory before query: 4.635 MB Rows returned: 1
    Duplicate queries: #2  #11  #12  #39  #49  #50  #53  #57

    SELECT `session_id`
    
      FROM `b4xfb_session`
    
      WHERE `session_id` = 'd3gfovl36mrv7r9f91u1ju8s2v' 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b4xfb_session	const	PRIMARY	PRIMARY	766	const	1	Using index

    Profile

    Status	Duration
    Starting	0.19 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.34 ms
    Optimizing	0.03 ms
    Statistics	0.11 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.05 ms
    Reset for next command	0.01 ms

    Call Stack

    #	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

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

57. Query Time: 0.83 ms After last query: 2.87 ms Query memory: 0.025 MB Memory before query: 4.722 MB Rows returned: 1
    Duplicate queries: #2  #11  #12  #39  #49  #50  #53  #56

    SELECT `session_id`
    
      FROM `b4xfb_session`
    
      WHERE `session_id` = 'd3gfovl36mrv7r9f91u1ju8s2v' 
      LIMIT 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b4xfb_session	const	PRIMARY	PRIMARY	766	const	1	Using index

    Profile

    Status	Duration
    Starting	0.13 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.04 ms
    Optimizing	0.02 ms
    Statistics	0.15 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.03 ms
    Executing	0.01 ms
    Sending data	0.02 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.02 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

    Call Stack

    #	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

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---

58. Query Time: 1.49 ms After last query: 2.42 ms Query memory: 0.021 MB Memory before query: 4.772 MB Rows returned: 1

    SELECT sleep_until < '2026-03-01 23:46:55' 
      FROM b4xfb_scheduler_metadata 
      WHERE type = 'metadata' 
      LIMIT 1

    Explain

    id	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

    Profile

    Status	Duration
    Starting	0.16 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.02 ms
    init	0.06 ms
    Optimizing	0.03 ms
    Statistics	0.09 ms
    Preparing	0.01 ms
    Unlocking tables	0.01 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.03 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.05 ms
    Query end	0.01 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.04 ms
    Reset for next command	0.01 ms

    Call Stack

    #	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

    [Add xdebug.file_link_format directive to your php.ini file to have links for files.]

    ---