{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1624434618,
                "last": 1624434618,
                "now": 1624434618
            },
            "token": "I3yV38OlS8bw8c2j8FdWms2177d7T90H"
        },
        "registry": {},
        "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
        },
        "myriad-6122157f595be1fe17bb6da5164eed8a-name": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-logo-type": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-logo-custom-image": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-accent-color1": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-accent-color2": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-demostyle-type": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-mainbody-overlay": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-header-textcolor": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-header-background": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-header-type": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-slideshow-textcolor": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-slideshow-overlaybackground": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-showcase-textcolor": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-showcase-background": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-fullstrip-textcolor": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-fullstrip-background": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-firstfullwidth-textcolor": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-firstfullwidth-background": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-feature-textcolor": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-feature-background": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-utility-textcolor": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-utility-background": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-secondfullwidth-textcolor": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-secondfullwidth-background": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-secondfullwidth-type": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-secondfullwidth-customsecondfullwidth-image": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-maintop-textcolor": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-maintop-background": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-extension-textcolor": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-extension-background": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-extension-type": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-extension-customextension-image": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-bottom-textcolor": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-bottom-background": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-footer-textcolor": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-footer-background": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-copyright-textcolor": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-copyright-background": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-font-family": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-font-size-is": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-menu-type": null,
        "myriad-6122157f595be1fe17bb6da5164eed8a-layout-mode": null,
        "gantry-current-template": "rt_myriad"
    }
}

Time

Memory

36 Queries Logged 73.47 ms

1. Query Time: 0.27 ms

   SELECT `data`
   
     FROM `txsc8_session`
   
     WHERE `session_id` = X'3231636631366136396266313433356238343864356565646163316636386162'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	txsc8_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

   Profile

   Status	Duration
   starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   executing	0.02 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
   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:832
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   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:392
   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.31 ms After last query: 1.28 ms

   SELECT `session_id`
   
     FROM `txsc8_session`
   
     WHERE `session_id` = X'3231636631366136396266313433356238343864356565646163316636386162' 
     LIMIT 1

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	txsc8_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

   Profile

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   executing	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:834
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   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:392
   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: 52.08 ms After last query: 0.13 ms

   INSERT INTO `txsc8_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'3231636631366136396266313433356238343864356565646163316636386162', 1, 1624434618, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `txsc8_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3231636631366136396266313433356238343864356565646163316636386162', 1, 1624434618, 0, '', 0)

   Profile

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   update	0.10 ms
   Waiting for query cache lock	0.01 ms
   update	0.01 ms
   end	0.00 ms
   query end	51.72 ms
   closing tables	0.02 ms
   freeing items	0.02 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:834
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   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:392
   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: 0.35 ms After last query: 10.63 ms

   SELECT id, rules
   
     FROM `txsc8_viewlevels`

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	txsc8_viewlevels	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5	100.00	NULL

   Profile

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.01 ms
   executing	0.00 ms
   Sending data	0.05 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1506
   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:318
   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:604
   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:203
   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: 0.47 ms After last query: 0.24 ms

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

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL
   1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100.00	Using where; Using index

   Profile

   Status	Duration
   starting	0.06 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.09 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.04 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1550
   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:318
   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:604
   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:203
   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: 0.42 ms After last query: 13.64 ms

   SELECT `value`
   
     FROM `txsc8_admintools_storage`
   
     WHERE `key` = 'cparams'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	txsc8_admintools_storage	NULL	const	PRIMARY	PRIMARY	402	const	1	100.00	NULL

   Profile

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.06 ms
   preparing	0.01 ms
   executing	0.01 ms
   Sending data	0.01 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
   13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:123
   12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:53
   11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:41
   10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:278
   9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:874
   8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
   7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   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:673
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   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:203
   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: 0.35 ms After last query: 1.61 ms

   SELECT *
   
     FROM `txsc8_admintools_wafexceptions`
   
     WHERE NOT(`option` LIKE 'com_%')

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	txsc8_admintools_wafexceptions	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where

   Profile

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.03 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.01 ms
   Sending data	0.03 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1506
   11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:592
   10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:503
   9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:883
   8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:110
   7	plgSystemAdmintools->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   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:673
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   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:203
   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: 0.48 ms After last query: 11.86 ms

   SELECT `params`
   
     FROM `txsc8_extensions`
   
     WHERE `type` = 'component' 
     AND `element` = 'com_loginguard'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	txsc8_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

   Profile

   Status	Duration
   starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.12 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.06 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
   13	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Params/Params.php:55
   12	FOF30\Params\Params->reload()	JROOT/libraries/fof30/Params/Params.php:40
   11	FOF30\Params\Params->__construct()	JROOT/libraries/fof30/Container/Container.php:309
   10	FOF30\Container\Container->FOF30\Container\{closure}()	JROOT/libraries/fof30/Pimple/Container.php:113
   9	FOF30\Pimple\Container->offsetGet()	JROOT/libraries/fof30/Container/ContainerBase.php:27
   8	FOF30\Container\ContainerBase->__get()	JROOT/plugins/system/loginguard/loginguard.php:147
   7	PlgSystemLoginguard->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   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:673
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   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:203
   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: 0.47 ms After last query: 9.43 ms
   Duplicate queries: #10

   SELECT template
   
     FROM txsc8_template_styles as s
   
     WHERE s.client_id = 0 
     AND s.home = 1

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	s	NULL	ALL	idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	8	12.50	Using where

   Profile

   Status	Duration
   starting	0.06 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.02 ms
   System lock	0.01 ms
   optimizing	0.02 ms
   statistics	0.06 ms
   preparing	0.02 ms
   executing	0.01 ms
   Sending data	0.05 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
   13	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
   12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
   11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
   10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
   9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
   7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   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:673
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   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:203
   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: 0.39 ms After last query: 0.08 ms
    Duplicate queries: #9

    SELECT template
    
      FROM txsc8_template_styles as s
    
      WHERE s.client_id = 0 
      AND s.home = 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	ALL	idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	8	12.50	Using where

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
    13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
    12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
    11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
    10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
    9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:96
    8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:54
    7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    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:673
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    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:203
    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.37 ms After last query: 3.39 ms

    SELECT extension, file, type
    
      FROM txsc8_rokcommon_configs
    
      ORDER BY priority

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	txsc8_rokcommon_configs	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	100.00	Using filesort

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:132
    8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:76
    7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    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:673
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    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:203
    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: 1.89 ms After last query: 16.14 ms

    SHOW VARIABLES LIKE "collation_database"

    Explain

    EXPLAIN not possible on query: SHOW VARIABLES LIKE "collation_database"

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.02 ms
    Opening tables	0.02 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    optimizing	0.00 ms
    statistics	0.01 ms
    preparing	0.02 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	1.45 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/database/driver/mysqli.php:345
    12	JDatabaseDriverMysqli->getCollation()	JROOT/plugins/system/admintools/feature/utf8mb4.php:28
    11	AtsystemFeatureUtf8mb4->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:753
    10	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
    9	plgSystemAdmintools->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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:674
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    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:203
    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.33 ms After last query: 0.58 ms

    SELECT *
    
      FROM `txsc8_admintools_ipautoban`
    
      WHERE `ip` = '34.239.179.228'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:74
    12	AtsystemFeatureAutoipfiltering->isIPBlocked()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:23
    11	AtsystemFeatureAutoipfiltering->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:753
    10	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
    9	plgSystemAdmintools->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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:674
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    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:203
    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.38 ms After last query: 0.11 ms

    SELECT *
    
      FROM `txsc8_admintools_storage`
    
      WHERE `key` LIKE 'timestamp_%'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	txsc8_admintools_storage	NULL	range	PRIMARY	PRIMARY	402	NULL	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1506
    14	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/feature/abstract.php:269
    13	AtsystemFeatureAbstract->loadTimestamps()	JROOT/plugins/system/admintools/feature/abstract.php:349
    12	AtsystemFeatureAbstract->getTimestamp()	JROOT/plugins/system/admintools/feature/disableobsoleteadmins.php:113
    11	AtsystemFeatureDisableobsoleteadmins->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:753
    10	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
    9	plgSystemAdmintools->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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:674
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    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:203
    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: 0.39 ms After last query: 0.80 ms

    SELECT `source`,`keepurlparams`
    
      FROM `txsc8_admintools_redirects`
    
      WHERE ((`dest` = 'downloads/category/7-research-papers-based-upon-ipacso-project.html') OR (`dest` = 'downloads/category/7-research-papers-based-upon-ipacso-project.html') OR ('downloads/category/7-research-papers-based-upon-ipacso-project.html' LIKE `dest`)) 
      AND `published` = '1'
    
      ORDER BY `ordering` DESC 
      LIMIT 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	txsc8_admintools_redirects	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1773
    12	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:89
    11	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:753
    10	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
    9	plgSystemAdmintools->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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:674
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    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:203
    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.58 ms After last query: 8.96 ms

    UPDATE `txsc8_extensions`
    
      SET `params` = '{\"mediaversion\":\"1137d10bb27cfc95c900215f46dd2647\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	UPDATE	txsc8_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.10 ms
    updating	0.10 ms
    end	0.01 ms
    Waiting for query cache lock	0.00 ms
    end	0.01 ms
    query end	1.11 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysql->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    14	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    13	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    12	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    11	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    10	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/k2/k2.php:47
    9	plgSystemK2->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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:674
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    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:203
    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.85 ms After last query: 6.08 ms

    SHOW FULL COLUMNS 
      FROM `txsc8_extensions`

    Explain

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

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.18 ms
    init	0.01 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.02 ms
    checking permissions	0.04 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Sending data	0.09 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.04 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
    11	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
    10	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
    9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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:674
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    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:203
    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: 0.45 ms After last query: 0.67 ms

    SELECT `extension_id`
    
      FROM `txsc8_extensions`
    
      WHERE type = 'component' 
      AND element = 'com_roksprocket'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	txsc8_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.10 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
    10	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:49
    9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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:674
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    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:203
    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.36 ms After last query: 0.14 ms
    Duplicate queries: #21

    SELECT *
    
      FROM txsc8_extensions
    
      WHERE `extension_id` = '10131'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	txsc8_extensions	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.05 ms
    preparing	0.02 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    10	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
    9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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:674
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    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:203
    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: 0.43 ms After last query: 0.13 ms

    SELECT `extension_id`
    
      FROM `txsc8_extensions`
    
      WHERE type = 'module' 
      AND element = 'mod_roksprocket'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	txsc8_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.10 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1740
    11	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
    10	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:72
    9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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:674
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    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:203
    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: 0.33 ms After last query: 0.13 ms
    Duplicate queries: #19

    SELECT *
    
      FROM txsc8_extensions
    
      WHERE `extension_id` = '10131'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	txsc8_extensions	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.04 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
    11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    10	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
    9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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:674
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    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:203
    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: 0.47 ms After last query: 15.58 ms

    SELECT extension_id AS id, element AS "option", params, enabled
    
      FROM txsc8_extensions
    
      WHERE `type` = 'component' 
      AND `element` = 'com_advancedmodules'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	txsc8_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	10.00	Using where

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.10 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/components/com_roksprocket/lib/RokSprocket/Addon/AdvancedModuleManager.php:92
    16	RokSprocket_Addon_AdvancedModuleManager->isComponentEnabled()	JROOT/components/com_roksprocket/lib/RokSprocket/Addon/AdvancedModuleManager.php:17
    15	RokSprocket_Addon_AdvancedModuleManager->__construct()	Same as call in the line below.
    14	ReflectionClass->newInstanceArgs()	JROOT/libraries/rokcommon/RokCommon/Service/Container/Builder.php:248
    13	RokCommon_Service_Container_Builder->createService()	JROOT/libraries/rokcommon/RokCommon/Service/Container/Builder.php:86
    12	RokCommon_Service_Container_Builder->getService()	JROOT/libraries/rokcommon/RokCommon/Service/ContainerImpl.php:377
    11	RokCommon_Service_ContainerImpl->__get()	JROOT/plugins/system/roksprocket/roksprocket.php:225
    10	plgSystemRokSprocket->loadAddons()	JROOT/plugins/system/roksprocket/roksprocket.php:91
    9	plgSystemRokSprocket->onAfterInitialise()	Same as call in the line below.
    8	call_user_func_array()	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:674
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    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:203
    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: 14.41 ms

    SELECT *
    
      FROM `txsc8_admintools_wafblacklists`
    
      WHERE `verb` IN('','GET') 
      AND `option` IN('','com_phocadownload') 
      AND `view` IN('','category') 
      AND `task` IN('','category.') 
      AND `enabled` = '1'
    
      GROUP BY `query`
    
      ORDER BY `query` ASC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	txsc8_admintools_wafblacklists	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	50.00	Using where; Using temporary; Using filesort

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.02 ms
    Creating tmp table	0.04 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.07 ms
    Creating sort index	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/admintools/feature/wafblacklist.php:87
    11	AtsystemFeatureWafblacklist->onAfterRoute()	JROOT/plugins/system/admintools/admintools/main.php:753
    10	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:145
    9	plgSystemAdmintools->onAfterRoute()	Same as call in the line below.
    8	call_user_func_array()	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:1196
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    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:203
    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: 1.44 ms After last query: 0.89 ms

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `txsc8_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_breezingforms','com_cache','com_categories','com_checkin','com_config','com_content','com_contenthistory','com_cpanel','com_fields','com_gantry','com_installer','com_jce','com_joomlaupdate','com_k2','com_languages','com_login','com_loginguard','com_mailto','com_media','com_menus','com_messages','com_modules','com_nonumberinstaller','com_phocadownload','com_plugins','com_postinstall','com_privacy','com_redirect','com_regularlabsmanager','com_roksprocket','com_tags','com_templates','com_users','com_wrapper','com_xmap')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	txsc8_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	42	100.00	Using index condition

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.07 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.26 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.75 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    14	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/advancedmodules/src/Document.php:28
    13	RegularLabs\Plugin\System\AdvancedModules\Document::loadFrontEditScript()	JROOT/plugins/system/advancedmodules/src/Helper.php:32
    12	RegularLabs\Plugin\System\AdvancedModules\Helper->onAfterRoute()	Same as call in the line below.
    11	call_user_func_array()	JROOT/plugins/system/advancedmodules/src/Plugin.php:97
    10	RegularLabs\Plugin\System\AdvancedModules\Plugin->run()	JROOT/plugins/system/advancedmodules/advancedmodules.php:62
    9	PlgSystemAdvancedModules->onAfterRoute()	Same as call in the line below.
    8	call_user_func_array()	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:1196
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    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:203
    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: 0.54 ms After last query: 12.35 ms

    SELECT cc.id, cc.title, cc.alias, cc.access as cataccess, cc.accessuserid as cataccessuserid, cc.description, cc.metakey, cc.metadesc, pc.title as parenttitle, cc.parent_id as parentid, pc.alias as parentalias 
      FROM txsc8_phocadownload_categories AS cc 
      LEFT JOIN txsc8_phocadownload_categories AS pc 
      ON pc.id = cc.parent_id 
      WHERE  cc.id= 7 
      AND  cc.access IN (1,1,5) 
      AND  cc.published = 1 
      ORDER BY cc.ordering 
      LIMIT 0, 1

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cc	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	pc	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_phocadownload/models/category.php:79
    11	PhocaDownloadModelCategory->getCategory()	JROOT/components/com_phocadownload/views/category/view.html.php:34
    10	PhocaDownloadViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocadownload/controller.php:34
    8	PhocaDownloadController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocadownload/phocadownload.php:52
    6	require_once JROOT/components/com_phocadownload/phocadownload.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:203
    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.84 ms After last query: 0.28 ms

    SELECT  cc.id, cc.title, cc.alias, cc.access as cataccess, cc.accessuserid as cataccessuserid, COUNT(c.id) AS numdoc 
      FROM txsc8_phocadownload_categories AS cc 
      LEFT JOIN txsc8_phocadownload AS c 
      ON c.catid = cc.id 
      AND c.published = 1 
      AND c.textonly = 0 
      WHERE  cc.parent_id = 7 
      AND  cc.access IN (1,1,5) 
      AND  cc.published = 1 
      GROUP BY cc.id 
      ORDER BY cc.ordering ASC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cc	NULL	index	PRIMARY,cat_idx,idx_access,idx_checkout	PRIMARY	4	NULL	24	4.17	Using where; Using temporary; Using filesort
    1	SIMPLE	c	NULL	ref	catid	catid	5	ipacsv_new.cc.id,const	12	100.00	Using where

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.09 ms
    preparing	0.03 ms
    Creating tmp table	0.03 ms
    Sorting for group	0.01 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.21 ms
    Creating sort index	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.04 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_phocadownload/models/category.php:87
    11	PhocaDownloadModelCategory->getSubcategories()	JROOT/components/com_phocadownload/views/category/view.html.php:35
    10	PhocaDownloadViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocadownload/controller.php:34
    8	PhocaDownloadController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocadownload/phocadownload.php:52
    6	require_once JROOT/components/com_phocadownload/phocadownload.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:203
    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.88 ms After last query: 0.23 ms

    SELECT c.*, cc.id AS categoryid, cc.title AS categorytitle, cc.alias AS categoryalias, cc.access as cataccess, cc.accessuserid as cataccessuserid  
      FROM txsc8_phocadownload AS c 
      LEFT JOIN txsc8_phocadownload_categories AS cc 
      ON cc.id = c.catid 
      WHERE  c.catid= 7 
      AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 
      AND c.access IN (1,1,5) ) ) 
      AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 
      AND cc.access IN (1,1,5) ) ) 
      AND  c.published = 1 
      AND  c.approved = 1 
      AND  cc.published = 1 
      AND  ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2021-06-23 07:50:19' ) 
      AND  ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2021-06-23 07:50:19' ) 
      ORDER BY c.ordering ASC 
      LIMIT 0, 20

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cc	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using filesort
    1	SIMPLE	c	NULL	ref	catid	catid	5	const,const	3	1.67	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.13 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.09 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.04 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    Creating sort index	0.15 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.05 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/components/com_phocadownload/models/category.php:71
    11	PhocaDownloadModelCategory->getFileList()	JROOT/components/com_phocadownload/views/category/view.html.php:36
    10	PhocaDownloadViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocadownload/controller.php:34
    8	PhocaDownloadController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocadownload/phocadownload.php:52
    6	require_once JROOT/components/com_phocadownload/phocadownload.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:203
    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: 0.85 ms After last query: 2.79 ms

    SELECT c.*, cc.id AS categoryid, cc.title AS categorytitle, cc.alias AS categoryalias, cc.access as cataccess, cc.accessuserid as cataccessuserid  
      FROM txsc8_phocadownload AS c 
      LEFT JOIN txsc8_phocadownload_categories AS cc 
      ON cc.id = c.catid 
      WHERE  c.catid= 7 
      AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 
      AND c.access IN (1,1,5) ) ) 
      AND ( (unaccessible_file = 1 ) OR (unaccessible_file = 0 
      AND cc.access IN (1,1,5) ) ) 
      AND  c.published = 1 
      AND  c.approved = 1 
      AND  cc.published = 1 
      AND  ( c.publish_up = '0000-00-00 00:00:00' OR c.publish_up <= '2021-06-23 07:50:19' ) 
      AND  ( c.publish_down = '0000-00-00 00:00:00' OR c.publish_down >= '2021-06-23 07:50:19' ) 
      ORDER BY c.ordering ASC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	cc	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	Using filesort
    1	SIMPLE	c	NULL	ref	catid	catid	5	const,const	3	1.67	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.09 ms
    System lock	0.01 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.04 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.05 ms
    Creating sort index	0.14 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysql->execute()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:353
    13	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/components/com_phocadownload/models/category.php:63
    12	PhocaDownloadModelCategory->getTotal()	JROOT/components/com_phocadownload/models/category.php:55
    11	PhocaDownloadModelCategory->getPagination()	JROOT/components/com_phocadownload/views/category/view.html.php:37
    10	PhocaDownloadViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocadownload/controller.php:34
    8	PhocaDownloadController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocadownload/phocadownload.php:52
    6	require_once JROOT/components/com_phocadownload/phocadownload.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:203
    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.43 ms After last query: 1.05 ms

    SELECT a.filename as filename, a.type as type, a.menulink as menulink 
      FROM txsc8_phocadownload_styles AS a 
      WHERE a.published = 1 
      ORDER BY a.type, a.ordering ASC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6	16.67	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_phocadownload/libraries/phocadownload/render/renderfront.php:22
    11	PhocaDownloadRenderFront::renderAllCSS()	JROOT/components/com_phocadownload/views/category/view.html.php:39
    10	PhocaDownloadViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_phocadownload/controller.php:34
    8	PhocaDownloadController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_phocadownload/phocadownload.php:52
    6	require_once JROOT/components/com_phocadownload/phocadownload.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    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:203
    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: 1.22 ms After last query: 61.06 ms

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params,am.mirror_id, am.params AS advancedparams, 0 AS menuid, m.publish_up, m.publish_down
    
      FROM txsc8_modules AS m
    
      LEFT JOIN txsc8_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      LEFT JOIN txsc8_advancedmodules as am 
      ON am.moduleid = m.id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	range	published,newsfeeds	published	5	NULL	14	10.00	Using index condition; Using where; Using filesort
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	ipacsv_new.m.module,const	1	10.00	Using index condition; Using where
    1	SIMPLE	am	NULL	eq_ref	PRIMARY	PRIMARY	4	ipacsv_new.m.id	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.15 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.15 ms
    preparing	0.04 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.46 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:409
    17	PlgSystemAdvancedModuleHelper->getModuleList()	JROOT/plugins/system/advancedmodules/src/Helpers/advancedmodulehelper.php:126
    16	PlgSystemAdvancedModuleHelper->onPrepareModuleList()	Same as call in the line below.
    15	call_user_func_array()	JROOT/libraries/joomla/event/dispatcher.php:165
    14	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    13	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Helper/ModuleHelper.php:366
    12	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    11	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
    10	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/libraries/gantry/core/gantry.class.php:804
    9	Gantry->getJoomlaModuleCount()	JROOT/libraries/gantry/core/gantry.class.php:757
    8	Gantry->countModules()	JROOT/templates/rt_myriad/index.php:57
    7	require JROOT/templates/rt_myriad/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1104
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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: 0.47 ms After last query: 14.19 ms

    SELECT ts.template
    
      FROM txsc8_template_styles AS ts
    
      INNER JOIN txsc8_menu AS m 
      ON ts.id=m.template_style_id
    
      WHERE m.id = 263 
      AND m.template_style_id != 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

    Profile

    Status	Duration
    starting	0.09 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.08 ms
    executing	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1550
    17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:101
    16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74
    15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25
    14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
    13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/rt_myriad/features/dropdownmenu.php:56
    10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
    9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
    8	Gantry->displayModules()	JROOT/templates/rt_myriad/index.php:63
    7	require JROOT/templates/rt_myriad/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1104
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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: 0.42 ms After last query: 0.11 ms

    SELECT template
    
      FROM txsc8_template_styles
    
      WHERE home = 1 
      AND client_id = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	txsc8_template_styles	NULL	ALL	idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	8	12.50	Using where

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1550
    17	JDatabaseDriver->loadColumn()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:116
    16	RokNavMenu::getTemplates()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:74
    15	RokNavMenu::loadCatalogs()	JROOT/modules/mod_roknavmenu/lib/RokNavMenu.php:25
    14	RokNavMenu->__construct()	JROOT/modules/mod_roknavmenu/mod_roknavmenu.php:21
    13	include JROOT/modules/mod_roknavmenu/mod_roknavmenu.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    12	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    11	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/rt_myriad/features/dropdownmenu.php:56
    10	GantryFeatureDropdownMenu->render()	JROOT/libraries/gantry/core/renderers/gantrymodulesrenderer.class.php:70
    9	GantryModulesRenderer::display()	JROOT/libraries/gantry/core/gantry.class.php:867
    8	Gantry->displayModules()	JROOT/templates/rt_myriad/index.php:63
    7	require JROOT/templates/rt_myriad/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1104
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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.79 ms After last query: 27.66 ms

    SHOW FULL COLUMNS 
      FROM `txsc8_template_styles`

    Explain

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

    Profile

    Status	Duration
    starting	0.07 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.19 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.02 ms
    preparing	0.01 ms
    executing	0.01 ms
    Opening tables	0.02 ms
    checking permissions	0.04 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    checking permissions	0.02 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.00 ms
    removing tmp table	0.04 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    18	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
    17	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:312
    16	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/gantry/gantry.php:194
    15	plgSystemGantry->getTable()	JROOT/plugins/system/gantry/gantry.php:165
    14	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
    13	plgSystemGantry->onBeforeCompileHead()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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: 0.39 ms After last query: 0.20 ms

    SELECT *
    
      FROM txsc8_template_styles
    
      WHERE `id` = '15'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	txsc8_template_styles	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.06 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1465
    16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    15	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/gantry/gantry.php:168
    14	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
    13	plgSystemGantry->onBeforeCompileHead()	Same as call in the line below.
    12	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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: 0.68 ms After last query: 16.35 ms

    SELECT m.*
    
      FROM txsc8_modules AS m
    
      LEFT JOIN txsc8_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.client_id = 0 
      AND m.id = 139 
      AND m.access IN (1,1,5) 
      AND m.published = 1 
      AND e.enabled = 1
    
      ORDER BY m.ordering

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	const	PRIMARY,published,newsfeeds	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	const,const	1	10.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.06 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.15 ms
    preparing	0.03 ms
    executing	0.01 ms
    Sending data	0.07 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/plugins/system/modulesanywhere/src/Replace.php:632
    16	RegularLabs\Plugin\System\ModulesAnywhere\Replace::getModuleFromDatabase()	JROOT/plugins/system/modulesanywhere/src/Replace.php:520
    15	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModule()	JROOT/plugins/system/modulesanywhere/src/Replace.php:306
    14	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processMatch()	JROOT/plugins/system/modulesanywhere/src/Replace.php:190
    13	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceMatches()	JROOT/plugins/system/modulesanywhere/src/Replace.php:172
    12	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replace()	JROOT/plugins/system/modulesanywhere/src/Replace.php:131
    11	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModules()	JROOT/plugins/system/modulesanywhere/src/Replace.php:89
    10	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceTags()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:99
    9	PlgSystemModulesAnywhere->changeFinalHtmlOutput()	JROOT/libraries/regularlabs/src/Plugin.php:202
    8	RegularLabs\Library\Plugin->onAfterRender()	Same as call in the line below.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->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:1124
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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: 0.57 ms After last query: 0.52 ms

    SELECT m.*
    
      FROM txsc8_modules AS m
    
      LEFT JOIN txsc8_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.client_id = 0 
      AND m.id = 141 
      AND m.access IN (1,1,5) 
      AND m.published = 1 
      AND e.enabled = 1
    
      ORDER BY m.ordering

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	const	PRIMARY,published,newsfeeds	PRIMARY	4	const	1	100.00	NULL
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	const,const	1	10.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.08 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    init	0.05 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.11 ms
    preparing	0.02 ms
    executing	0.01 ms
    Sending data	0.06 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysql->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/plugins/system/modulesanywhere/src/Replace.php:632
    16	RegularLabs\Plugin\System\ModulesAnywhere\Replace::getModuleFromDatabase()	JROOT/plugins/system/modulesanywhere/src/Replace.php:520
    15	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModule()	JROOT/plugins/system/modulesanywhere/src/Replace.php:306
    14	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processMatch()	JROOT/plugins/system/modulesanywhere/src/Replace.php:190
    13	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceMatches()	JROOT/plugins/system/modulesanywhere/src/Replace.php:172
    12	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replace()	JROOT/plugins/system/modulesanywhere/src/Replace.php:131
    11	RegularLabs\Plugin\System\ModulesAnywhere\Replace::processModules()	JROOT/plugins/system/modulesanywhere/src/Replace.php:89
    10	RegularLabs\Plugin\System\ModulesAnywhere\Replace::replaceTags()	JROOT/plugins/system/modulesanywhere/modulesanywhere.php:99
    9	PlgSystemModulesAnywhere->changeFinalHtmlOutput()	JROOT/libraries/regularlabs/src/Plugin.php:202
    8	RegularLabs\Library\Plugin->onAfterRender()	Same as call in the line below.
    7	call_user_func_array()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->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:1124
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:209
    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.]

    ---