{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1656275761,
                "last": 1656275761,
                "now": 1656275761
            },
            "token": "Zj54EfYh94oE634E7toRLF7zbsynjGhU"
        },
        "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
        },
        "ionosphere-346485262694ca5853c2dac5c3523d31-name": null,
        "ionosphere-346485262694ca5853c2dac5c3523d31-accent-color": null,
        "ionosphere-346485262694ca5853c2dac5c3523d31-accent-overlay": null,
        "ionosphere-346485262694ca5853c2dac5c3523d31-body-color": null,
        "ionosphere-346485262694ca5853c2dac5c3523d31-body-overlay": null,
        "ionosphere-346485262694ca5853c2dac5c3523d31-bg-background": null,
        "ionosphere-346485262694ca5853c2dac5c3523d31-bg-overlay": null,
        "ionosphere-346485262694ca5853c2dac5c3523d31-bg-pattern": null,
        "ionosphere-346485262694ca5853c2dac5c3523d31-headerwidth": null,
        "ionosphere-346485262694ca5853c2dac5c3523d31-footerwidth": null,
        "ionosphere-346485262694ca5853c2dac5c3523d31-font-family": null,
        "ionosphere-346485262694ca5853c2dac5c3523d31-font-size-is": null,
        "ionosphere-346485262694ca5853c2dac5c3523d31-menu-type": null,
        "ionosphere-346485262694ca5853c2dac5c3523d31-layout-mode": null,
        "ionosphere-346485262694ca5853c2dac5c3523d31-typography-style": null
    }
}

Time

Memory

19 Queries Logged 33.65 ms

1. Query Time: 1.36 ms

   SELECT `data`
   
     FROM `mmp_xoz01_session`
   
     WHERE `session_id` = '153ckg5hp71tpqobqmruvrk3m7'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	mmp_xoz01_session	const	PRIMARY	PRIMARY	766	const	1	100.00	NULL

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1730
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Same as call in the line below.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:755
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:343
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

2. Query Time: 3.48 ms After last query: 2.52 ms

   SELECT `session_id`
   
     FROM `mmp_xoz01_session`
   
     WHERE `session_id` = '153ckg5hp71tpqobqmruvrk3m7' 
     LIMIT 1

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1730
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:343
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

3. Query Time: 0.54 ms After last query: 0.18 ms

   INSERT INTO `mmp_xoz01_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('153ckg5hp71tpqobqmruvrk3m7', 1, '1656275761', 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `mmp_xoz01_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('153ckg5hp71tpqobqmruvrk3m7', 1, '1656275761', 0, '', 0)

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverPdo->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:152
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:757
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:134
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:343
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

4. Query Time: 0.42 ms After last query: 18.33 ms

   SELECT id, rules
   
     FROM `mmp_xoz01_viewlevels`

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1496
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

5. Query Time: 0.59 ms After last query: 0.15 ms

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

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1540
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:606
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

6. Query Time: 0.53 ms After last query: 72.98 ms
   Duplicate queries: #7

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

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1730
   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:95
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
   7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Query Time: 0.72 ms After last query: 0.12 ms
   Duplicate queries: #6

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

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1730
   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:95
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
   7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Query Time: 3.29 ms After last query: 11.23 ms

   SELECT extension, file, type
   
     FROM mmp_xoz01_rokcommon_configs
   
     ORDER BY priority

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1691
   9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:131
   8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
   7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:622
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Query Time: 5.50 ms After last query: 84.55 ms

   SHOW FULL COLUMNS 
     FROM `mmp_xoz01_extensions`

   Explain

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

   Profile

   No SHOW PROFILE (maybe because there are more than 100 queries)

   Call Stack

   #	Caller	File and line number
   15	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1691
   14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:320
   13	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
   12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
   11	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
   10	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
   9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
   8	plgSystemRokSprocket->onAfterInitialise()	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:623
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Query Time: 0.83 ms After last query: 1.04 ms

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	mmp_xoz01_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1730
    10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:121
    9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:47
    8	plgSystemRokSprocket->onAfterInitialise()	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:623
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Query Time: 2.84 ms After last query: 0.18 ms
    Duplicate queries: #13

    SELECT *
    
      FROM mmp_xoz01_extensions
    
      WHERE `extension_id` = '10041'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1455
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
    8	plgSystemRokSprocket->onAfterInitialise()	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:623
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Query Time: 0.50 ms After last query: 0.16 ms

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	mmp_xoz01_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1730
    10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:121
    9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:70
    8	plgSystemRokSprocket->onAfterInitialise()	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:623
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Query Time: 0.15 ms After last query: 0.12 ms
    Duplicate queries: #11

    SELECT *
    
      FROM mmp_xoz01_extensions
    
      WHERE `extension_id` = '10041'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1455
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
    8	plgSystemRokSprocket->onAfterInitialise()	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:623
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:688
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Query Time: 0.75 ms After last query: 128.17 ms

    UPDATE `mmp_xoz01_extensions`
    
      SET `params` = '{\"mediaversion\":\"0e7b369a688ed057d0bb7d214c644025\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	mmp_xoz01_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverPdo->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/gdpr/gdpr.php:834
    8	plgSystemGdpr->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1080
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:798
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Query Time: 3.19 ms After last query: 31.99 ms

    SELECT id,placeholder
    
      FROM `mmp_xoz01_gdpr_checkbox`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1691
    8	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/gdpr/gdpr.php:1084
    7	plgSystemGdpr->onAfterDispatch()	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/SiteApplication.php:199
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:195
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Query Time: 4.16 ms After last query: 159.81 ms

    SELECT ts.template
    
      FROM mmp_xoz01_template_styles AS ts
    
      INNER JOIN mmp_xoz01_menu AS m 
      ON ts.id=m.template_style_id
    
      WHERE m.id = 101 
      AND m.template_style_id != 0

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1540
    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:201
    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_ionosphere_responsive/features/fusionmenu.php:60
    10	GantryFeatureFusionMenu->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_ionosphere_responsive/index.php:110
    7	require JROOT/templates/rt_ionosphere_responsive/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 0.29 ms After last query: 0.18 ms

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

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1540
    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:201
    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_ionosphere_responsive/features/fusionmenu.php:60
    10	GantryFeatureFusionMenu->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_ionosphere_responsive/index.php:110
    7	require JROOT/templates/rt_ionosphere_responsive/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1027
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Query Time: 1.11 ms After last query: 252.73 ms

    SHOW FULL COLUMNS 
      FROM `mmp_xoz01_template_styles`

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1691
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/pdomysql.php:320
    19	JDatabaseDriverPdomysql->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
    18	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
    17	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
    16	TemplatesTableStyle->__construct()	JROOT/libraries/src/Table/Table.php:312
    15	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/gantry/gantry.php:194
    14	plgSystemGantry->getTable()	JROOT/plugins/system/gantry/gantry.php:165
    13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
    12	plgSystemGantry->onBeforeCompileHead()	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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Query Time: 3.41 ms After last query: 0.25 ms

    SELECT *
    
      FROM mmp_xoz01_template_styles
    
      WHERE `id` = '12'

    Explain

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

    Profile

    No SHOW PROFILE (maybe because there are more than 100 queries)

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverPdo->execute()	JROOT/libraries/joomla/database/driver.php:1455
    15	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    14	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/gantry/gantry.php:168
    13	plgSystemGantry->isGantryTemplate()	JROOT/plugins/system/gantry/gantry.php:234
    12	plgSystemGantry->onBeforeCompileHead()	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:491
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1041
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:780
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:201
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 2 × SELECT `extension_id` 
     FROM `mmp_xoz01_extensions`

2. 2 × SELECT template 
     FROM mmp_xoz01_template_styles as s

3. 2 × SELECT * 
     FROM mmp_xoz01_extensions

4. 1 × SELECT `data` 
     FROM `mmp_xoz01_session`

5. 1 × SELECT `session_id` 
     FROM `mmp_xoz01_session`

6. 1 × SELECT id, rules 
     FROM `mmp_xoz01_viewlevels

7. 1 × SELECT b.id 
     FROM mmp_xoz01_usergroups AS a 
     LEFT JOIN mmp_xoz01_usergroups AS b 
     ON b.lft <= a.lft 
     AND b.rgt >= a.rgt

8. 1 × SELECT extension, file, type 
     FROM mmp_xoz01_rokcommon_configs

9. 1 × SELECT id,placeholder 
     FROM `mmp_xoz01_gdpr_checkbox

10. 1 × SELECT ts.template 
      FROM mmp_xoz01_template_styles AS ts 
      INNER JOIN mmp_xoz01_menu AS m 
      ON ts.id=m.template_style_id

11. 1 × SELECT template 
      FROM mmp_xoz01_template_styles

12. 1 × SELECT * 
      FROM mmp_xoz01_template_styles

OTHER Tables:

1. 1 × INSERT INTO `mmp_xoz01_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  ('153ckg5hp71tpqobqmruvrk3m7', 1, '1656275761', 0, '', 0

2. 1 × SHOW FULL COLUMNS 
     FROM `mmp_xoz01_extensions

3. 1 × UPDATE `mmp_xoz01_extensions` 
     SET `params` = '{\"mediaversion\":\"0e7b369a688ed057d0bb7d214c644025\"}'

4. 1 × SHOW FULL COLUMNS 
     FROM `mmp_xoz01_template_styles