{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1772859048,
                "last": 1772859048,
                "now": 1772859048
            },
            "client": {
                "forwarded": "216.73.216.13"
            },
            "token": "tleReXMmYOi6ZsGjyxqM7CxlEGLI0qIM"
        },
        "registry": {
            "mailto": {
                "mailto": {
                    "form": {
                        "data": {
                            "link": "6eb2bd2ac4fff3b89da9a938d8995f9f98d15299",
                            "sender": "",
                            "subject": "",
                            "emailfrom": "",
                            "emailto": ""
                        }
                    }
                }
            }
        },
        "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
        }
    }
}

Time

Memory

14 Queries Logged 20.21 ms

1. Query Time: 3.54 ms

   SHOW VARIABLES LIKE 'query_cache_type'

   Explain

   EXPLAIN not possible on query: SHOW VARIABLES LIKE 'query_cache_type'

   Profile

   Status	Duration
   starting	0.05 ms
   Executing hook on transaction	0.00 ms
   starting	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.03 ms
   init	0.00 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.04 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.00 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1465
   11	JDatabaseDriver->loadAssoc()	JROOT\libraries\joomla\database\driver\pdomysql.php:604
   10	JDatabaseDriverPdomysql->hasQueryCacheEnabled()	JROOT\libraries\joomla\database\driver\pdomysql.php:160
   9	JDatabaseDriverPdomysql->connect()	JROOT\libraries\src\Filter\InputFilter.php:72
   8	Joomla\CMS\Filter\InputFilter->__construct()	JROOT\libraries\src\Filter\InputFilter.php:105
   7	Joomla\CMS\Filter\InputFilter::getInstance()	JROOT\libraries\src\Input\Input.php:64
   6	Joomla\CMS\Input\Input->__construct()	JROOT\libraries\src\Application\WebApplication.php:214
   5	Joomla\CMS\Application\WebApplication->__construct()	JROOT\libraries\src\Application\CMSApplication.php:110
   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.95 ms After last query: 0.10 ms

   SHOW VARIABLES LIKE 'have_profiling'

   Explain

   EXPLAIN not possible on query: SHOW VARIABLES LIKE 'have_profiling'

   Profile

   Status	Duration
   starting	0.02 ms
   Executing hook on transaction	0.00 ms
   starting	0.00 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.01 ms
   executing	0.00 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.00 ms
   closing tables	0.00 ms
   freeing items	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1465
   11	JDatabaseDriver->loadAssoc()	JROOT\libraries\joomla\database\driver\pdomysql.php:590
   10	JDatabaseDriverPdomysql->hasProfiling()	JROOT\libraries\joomla\database\driver\pdomysql.php:165
   9	JDatabaseDriverPdomysql->connect()	JROOT\libraries\src\Filter\InputFilter.php:72
   8	Joomla\CMS\Filter\InputFilter->__construct()	JROOT\libraries\src\Filter\InputFilter.php:105
   7	Joomla\CMS\Filter\InputFilter::getInstance()	JROOT\libraries\src\Input\Input.php:64
   6	Joomla\CMS\Input\Input->__construct()	JROOT\libraries\src\Application\WebApplication.php:214
   5	Joomla\CMS\Application\WebApplication->__construct()	JROOT\libraries\src\Application\CMSApplication.php:110
   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: 0.61 ms After last query: 13.41 ms

   SELECT `data`
   
     FROM `a5xmg_session`
   
     WHERE `session_id` = X'6b763567376f713735696265626236646a72326e697536316d38'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a5xmg_session	NULL	const	PRIMARY	PRIMARY	602	const	1	100	NULL

   Profile

   Status	Duration
   starting	0.02 ms
   Executing hook on transaction	0.00 ms
   starting	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.00 ms
   System lock	0.00 ms
   update	0.05 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	5.27 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverPdo->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.]

   ---

4. Query Time: 0.51 ms After last query: 2.88 ms

   SELECT `session_id`
   
     FROM `a5xmg_session`
   
     WHERE `session_id` = X'6b763567376f713735696265626236646a72326e697536316d38' 
     LIMIT 1

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a5xmg_session	NULL	const	PRIMARY	PRIMARY	602	const	1	100	Using index

   Profile

   Status	Duration
   starting	0.04 ms
   Executing hook on transaction	0.00 ms
   starting	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   init	0.00 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.01 ms
   executing	0.05 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.00 ms
   closing tables	0.00 ms
   freeing items	0.02 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverPdo->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.]

   ---

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

   INSERT INTO `a5xmg_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'6b763567376f713735696265626236646a72326e697536316d38', 1, 1772859048, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `a5xmg_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6b763567376f713735696265626236646a72326e697536316d38', 1, 1772859048, 0, '', 0)

   Profile

   Status	Duration
   starting	0.02 ms
   Executing hook on transaction	0.00 ms
   starting	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.00 ms
   System lock	0.00 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   preparing	0.01 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.00 ms
   closing tables	0.00 ms
   freeing items	0.01 ms
   cleaning up	0.00 ms

   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: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.]

   ---

6. Query Time: 0.55 ms After last query: 6.52 ms

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `a5xmg_extensions`
   
     WHERE `type` = 'component' 
     AND `state` = 0 
     AND `enabled` = 1

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a5xmg_extensions	NULL	ref	extension	extension	62	const	28	1	Using where

   Profile

   Status	Duration
   starting	0.04 ms
   Executing hook on transaction	0.00 ms
   starting	0.00 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   init	0.00 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.03 ms
   preparing	0.01 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.00 ms
   closing tables	0.00 ms
   freeing items	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1701
   11	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Component\ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
   9	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Component\ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT\libraries\src\Component\ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT\libraries\src\Component\ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT\libraries\src\Component\ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT\libraries\src\Application\SiteApplication.php:594
   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.40 ms After last query: 4.76 ms

   SELECT id, rules
   
     FROM `a5xmg_viewlevels`

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a5xmg_viewlevels	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	4	100	NULL

   Profile

   Status	Duration
   starting	0.02 ms
   Executing hook on transaction	0.00 ms
   starting	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.00 ms
   System lock	0.00 ms
   optimizing	0.01 ms
   statistics	0.02 ms
   preparing	0.03 ms
   executing	0.09 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.00 ms
   closing tables	0.00 ms
   freeing items	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverPdo->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.]

   ---

8. Query Time: 0.48 ms After last query: 0.11 ms

   SELECT b.id
   
     FROM a5xmg_usergroups AS a
   
     LEFT JOIN a5xmg_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	NULL
   1	SIMPLE	b	NULL	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	2	100	Using where; Using index

   Profile

   Status	Duration
   starting	0.09 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   Opening tables	0.03 ms
   init	0.00 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.02 ms
   executing	0.04 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.00 ms
   freeing items	0.03 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverPdo->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.]

   ---

9. Query Time: 0.57 ms After last query: 0.73 ms

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

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a5xmg_extensions	NULL	ref	extension	extension	62	const	47	0.78	Using where; Using filesort

   Profile

   Status	Duration
   starting	0.06 ms
   Executing hook on transaction	0.00 ms
   starting	0.01 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   init	0.00 ms
   System lock	0.01 ms
   optimizing	0.01 ms
   statistics	0.05 ms
   preparing	0.01 ms
   executing	0.02 ms
   end	0.00 ms
   query end	0.00 ms
   waiting for handler commit	0.01 ms
   closing tables	0.00 ms
   freeing items	0.02 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Plugin\PluginHelper.php:351
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
   8	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Plugin\PluginHelper.php:356
   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.]

   ---

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

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	1	10	Using index condition; Using where; Using filesort
    1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	jubatech.m.component_id	1	100	Using where

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.00 ms
    System lock	0.02 ms
    updating	0.05 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	3.65 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Menu\SiteMenu.php:93
    17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
    16	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Menu\SiteMenu.php:101
    14	Joomla\CMS\Menu\SiteMenu->load()	JROOT\libraries\src\Menu\AbstractMenu.php:78
    13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT\libraries\src\Menu\SiteMenu.php:62
    12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT\libraries\src\Menu\AbstractMenu.php:142
    11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT\libraries\src\Application\CMSApplication.php:423
    10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT\libraries\src\Application\SiteApplication.php:275
    9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT\libraries\src\Router\SiteRouter.php:65
    8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT\libraries\src\Router\Router.php:189
    7	Joomla\CMS\Router\Router::getInstance()	JROOT\libraries\src\Application\CMSApplication.php:539
    6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT\libraries\src\Application\SiteApplication.php:403
    5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT\libraries\src\Application\CMSApplication.php:1147
    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.]

    ---

11. Query Time: 0.78 ms After last query: 18.43 ms

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a5xmg_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	100	NULL

    Profile

    Status	Duration
    starting	0.03 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.02 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT\libraries\src\Helper\LibraryHelper.php:167
    13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
    12	call_user_func_array()	JROOT\libraries\src\Cache\Controller\CallbackController.php:173
    11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT\libraries\src\Helper\LibraryHelper.php:175
    10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT\libraries\src\Helper\LibraryHelper.php:43
    9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT\libraries\src\Helper\LibraryHelper.php:90
    8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT\libraries\src\Version.php:321
    7	Joomla\CMS\Version->getMediaVersion()	JROOT\libraries\src\Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT\libraries\src\Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT\libraries\src\Application\WebApplication.php:1131
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT\libraries\src\Application\SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php: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: 4.30 ms After last query: 0.18 ms

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

    Explain

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

    Profile

    Status	Duration
    starting	0.02 ms
    Executing hook on transaction	0.00 ms
    starting	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.00 ms
    System lock	0.00 ms
    optimizing	0.01 ms
    statistics	0.03 ms
    preparing	0.01 ms
    executing	0.02 ms
    end	0.00 ms
    query end	0.00 ms
    waiting for handler commit	0.00 ms
    closing tables	0.00 ms
    freeing items	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverPdo->execute()	JROOT\libraries\src\Helper\LibraryHelper.php:117
    9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT\libraries\src\Version.php:372
    8	Joomla\CMS\Version->setMediaVersion()	JROOT\libraries\src\Version.php:331
    7	Joomla\CMS\Version->getMediaVersion()	JROOT\libraries\src\Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT\libraries\src\Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT\libraries\src\Application\WebApplication.php:1131
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT\libraries\src\Application\SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php: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.47 ms After last query: 2.76 ms

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    7	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1701
    6	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Language\LanguageHelper.php:150
    5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT\libraries\src\Application\SiteApplication.php:330
    4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT\libraries\src\Application\SiteApplication.php:138
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT\libraries\src\Application\SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT\libraries\src\Application\CMSApplication.php: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.51 ms After last query: 0.26 ms

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

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	s	NULL	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	4	25	Using where
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	jubatech.s.template,const	1	4.57	Using index condition; Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    6	JDatabaseDriverPdo->execute()	JROOT\libraries\joomla\database\driver.php:1701
    5	JDatabaseDriver->loadObjectList()	JROOT\libraries\src\Application\SiteApplication.php:486
    4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT\libraries\src\Application\SiteApplication.php:168
    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.]

    ---

13 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
     FROM `a5xmg_extensions`

2. 1 × SELECT `data`
    
     FROM `a5xmg_session`

3. 1 × SELECT `session_id`
    
     FROM `a5xmg_session`

4. 1 × SELECT id, rules
    
     FROM `a5xmg_viewlevels

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

6. 1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
    
     FROM a5xmg_extensions

7. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
    
     FROM a5xmg_menu AS m
    
     LEFT JOIN a5xmg_extensions AS e 
     ON m.component_id = e.extension_id

8. 1 × SELECT *
    
     FROM a5xmg_languages

9. 1 × SELECT id, home, template, s.params
    
     FROM a5xmg_template_styles as s
    
     LEFT JOIN a5xmg_extensions as e 
     ON e.element=s.template 
     AND e.type='template' 
     AND e.client_id=s.client_id

OTHER Tables:

1. 1 × SHOW VARIABLES LIKE 'query_cache_type

2. 1 × SHOW VARIABLES LIKE 'have_profiling

3. 1 × INSERT INTO `a5xmg_session`
    (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
    (X'6b763567376f713735696265626236646a72326e697536316d38', 1, 1772859048, 0, '', 0

4. 1 × UPDATE `a5xmg_extensions`
    
     SET `params` = '{\"mediaversion\":\"ae2c6c9185f28caef0757a6cb0e160eb\"}'