Grade Graph Subscription

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1685807030,
                "last": 1685807030,
                "now": 1685807030
            },
            "token": "z2BIIM3G8QfMLcsmWYk8REeiKsgXgvF3"
        },
        "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
        }
    }
}

Time

Memory

70 Queries Logged 64.13 ms

1. Query Time: 0.50 ms Query memory: 0.020 MB Memory before query: 1.030 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `kd8eh_session`
   
     WHERE `session_id` = X'6f67643272707232386e71763574697136326576726868723170' 
     LIMIT 1

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->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:828
   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:386
   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: 6.20 ms After last query: 0.09 ms Query memory: 0.004 MB Memory before query: 1.036 MB

   INSERT INTO `kd8eh_session`
   (`session_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   (X'6f67643272707232386e71763574697136326576726868723170', 1, 1685807030, 0, '')

   Explain

   EXPLAIN not possible on query: INSERT INTO `kd8eh_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES (X'6f67643272707232386e71763574697136326576726868723170', 1, 1685807030, 0, '')

   Profile

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.01 ms
   update	0.09 ms
   end	0.01 ms
   query end	0.03 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   delayed commit ok initiated	5.63 ms
   delayed commit ok done	0.03 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   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:386
   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: 1.09 ms After last query: 0.34 ms Query memory: 0.040 MB Memory before query: 1.067 MB Rows returned: 47

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `kd8eh_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	kd8eh_extensions	NULL	ref	extension	extension	82	const	48	1.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.02 ms
   statistics	0.06 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sending data	0.18 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.03 ms
   cleaned up	0.00 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->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:225
   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.]

   ---

4. Query Time: 0.49 ms After last query: 0.40 ms Query memory: 0.021 MB Memory before query: 1.110 MB Rows returned: 7

   SELECT id, rules
   
     FROM `kd8eh_viewlevels`

   Explain

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

   Profile

   Status	Duration
   starting	0.03 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   init	0.01 ms
   System lock	0.01 ms
   optimizing	0.00 ms
   statistics	0.01 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
   cleaned up	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->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:225
   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.66 ms After last query: 0.09 ms Query memory: 0.021 MB Memory before query: 1.123 MB Rows returned: 2

   SELECT b.id
   
     FROM kd8eh_usergroups AS a
   
     LEFT JOIN kd8eh_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.05 ms
   checking permissions	0.01 ms
   checking permissions	0.01 ms
   Opening tables	0.01 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.02 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaned up	0.00 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->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:225
   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: 1.94 ms After last query: 0.11 ms Query memory: 0.051 MB Memory before query: 1.145 MB Rows returned: 131

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM kd8eh_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	kd8eh_extensions	NULL	ref	extension	extension	82	const	207	0.60	Using index condition; Using where; Using filesort

   Profile

   Status	Duration
   starting	0.07 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.04 ms
   preparing	0.02 ms
   Sorting result	0.01 ms
   executing	0.00 ms
   Sending data	0.01 ms
   Creating sort index	0.79 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaned up	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->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:225
   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.70 ms After last query: 2.90 ms Query memory: 0.022 MB Memory before query: 1.569 MB Rows returned: 0
   Duplicate queries: #8

   SELECT `manifest_cache`
   
     FROM `kd8eh_extensions`
   
     WHERE `type` = 'component' 
     AND `name` = 'com_admintools'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	kd8eh_extensions	NULL	ref	extension	extension	82	const	48	10.00	Using where

   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.06 ms
   preparing	0.02 ms
   executing	0.00 ms
   Sending data	0.13 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaned up	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   13	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
   12	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
   11	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:159
   10	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
   9	FOF30\Container\Container::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:813
   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:667
   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:225
   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.64 ms After last query: 1.02 ms Query memory: 0.022 MB Memory before query: 1.595 MB Rows returned: 0
   Duplicate queries: #7

   SELECT `manifest_cache`
   
     FROM `kd8eh_extensions`
   
     WHERE `type` = 'component' 
     AND `name` = 'com_admintools'

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	kd8eh_extensions	NULL	ref	extension	extension	82	const	48	10.00	Using where

   Profile

   Status	Duration
   starting	0.04 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.01 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.15 ms
   end	0.01 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.04 ms
   cleaned up	0.00 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   13	JDatabaseDriver->loadResult()	JROOT/libraries/fof30/Container/Container.php:787
   12	FOF30\Container\Container->getDefaultMediaVersion()	JROOT/libraries/fof30/Container/Container.php:675
   11	FOF30\Container\Container->__construct()	JROOT/libraries/fof30/Container/Container.php:290
   10	FOF30\Container\Container::makeInstance()	JROOT/libraries/fof30/Container/Container.php:140
   9	FOF30\Container\Container::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:813
   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:667
   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:225
   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.59 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 1.602 MB Rows returned: 1

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

   Explain

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

   Profile

   Status	Duration
   starting	0.18 ms
   checking permissions	0.01 ms
   Opening tables	0.01 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.01 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.02 ms
   cleaned up	0.00 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->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:831
   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:667
   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:225
   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.47 ms After last query: 0.18 ms Query memory: 0.021 MB Memory before query: 1.609 MB Rows returned: 0

    SELECT *
    
      FROM `kd8eh_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	kd8eh_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.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaned up	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    11	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/admintools/main.php:549
    10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:460
    9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:843
    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:667
    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:225
    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.64 ms After last query: 1.68 ms Query memory: 0.032 MB Memory before query: 1.867 MB Rows returned: 131

    SELECT `config_key`,`config_value`
    
      FROM kd8eh_osmembership_configs

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_osmembership/libraries/mpf/config/config.php:41
    10	MPFConfig->__construct()	JROOT/components/com_osmembership/helper/helper.php:61
    9	OSMembershipHelper::getConfig()	JROOT/administrator/components/com_osmembership/loader.php:88
    8	require_once JROOT/administrator/components/com_osmembership/loader.php	JROOT/plugins/system/membershippro/membershippro.php:55
    7	plgSystemMembershipPro->__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:667
    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:225
    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: 3.74 ms After last query: 0.35 ms Query memory: 0.004 MB Memory before query: 1.918 MB

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

    Explain

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

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.07 ms
    updating	0.07 ms
    end	0.01 ms
    query end	0.05 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    delayed commit ok initiated	3.13 ms
    delayed commit ok done	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/jacontenttype/jacontenttype.php:61
    8	PlgSystemJacontenttype->_check()	JROOT/plugins/system/jacontenttype/jacontenttype.php:43
    7	PlgSystemJacontenttype->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php: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:667
    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:225
    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.65 ms After last query: 0.51 ms Query memory: 0.024 MB Memory before query: 1.961 MB Rows returned: 1

    SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
    
      FROM `kd8eh_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	kd8eh_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.09 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.07 ms
    preparing	0.01 ms
    executing	0.00 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
    cleaned up	0.00 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    16	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
    15	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    14	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    13	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    12	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    11	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/kunena/kunena.php:63
    7	plgSystemKunena->__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:667
    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:225
    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: 5.95 ms After last query: 0.11 ms Query memory: 0.006 MB Memory before query: 1.954 MB

    UPDATE `kd8eh_extensions`
    
      SET `params` = '{\"mediaversion\":\"7bd872e70930ea2e01c8cd6a92bc5454\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

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

    Profile

    Status	Duration
    starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.05 ms
    updating	0.07 ms
    end	0.01 ms
    query end	0.06 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    delayed commit ok initiated	5.34 ms
    delayed commit ok done	0.02 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    12	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    11	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    10	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    9	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    8	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/kunena/kunena.php:63
    7	plgSystemKunena->__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:667
    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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Query Time: 2.58 ms After last query: 2.88 ms Query memory: 0.073 MB Memory before query: 2.425 MB Rows returned: 42

    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 kd8eh_menu AS m
    
      LEFT JOIN kd8eh_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	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	61	3.33	Using index condition; Using where; Using filesort
    1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	auroraedtech.m.component_id	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.28 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.02 ms
    statistics	0.06 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.67 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.03 ms
    cleaned up	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    20	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
    19	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    18	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    17	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
    16	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    15	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
    14	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
    13	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    12	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
    11	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    10	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
    9	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    8	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/jmap/jmap.php:762
    7	plgSystemJMap->__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:667
    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:225
    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: 0.89 ms After last query: 3.42 ms Query memory: 0.022 MB Memory before query: 2.601 MB Rows returned: 1

    SHOW VARIABLES LIKE "collation_database"

    Explain

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

    Profile

    Status	Duration
    starting	0.05 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
    preparing	0.02 ms
    executing	0.37 ms
    Sending data	0.02 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.03 ms
    cleaned up	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/database/driver/mysqli.php:345
    11	JDatabaseDriverMysqli->getCollation()	JROOT/plugins/system/admintools/feature/utf8mb4.php:28
    10	AtsystemFeatureUtf8mb4->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:710
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
    8	plgSystemAdmintools->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:668
    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:225
    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.50 ms After last query: 0.24 ms Query memory: 0.022 MB Memory before query: 2.611 MB Rows returned: 0

    SELECT *
    
      FROM `kd8eh_admintools_ipautoban`
    
      WHERE `ip` = '3.239.129.52'

    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.03 ms
    executing	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaned up	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:74
    11	AtsystemFeatureAutoipfiltering->isIPBlocked()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:23
    10	AtsystemFeatureAutoipfiltering->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:710
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
    8	plgSystemAdmintools->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:668
    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:225
    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.48 ms After last query: 0.22 ms Query memory: 0.021 MB Memory before query: 2.623 MB Rows returned: 0

    SELECT `source`,`keepurlparams`
    
      FROM `kd8eh_admintools_redirects`
    
      WHERE ((`dest` = 'plugins-all/subscription/gradegraph/sign-up') OR (`dest` = 'plugins-all/subscription/gradegraph/sign-up') OR ('plugins-all/subscription/gradegraph/sign-up' 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	kd8eh_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.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.02 ms
    preparing	0.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.03 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaned up	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1773
    11	JDatabaseDriver->loadRow()	JROOT/plugins/system/admintools/feature/urlredir.php:89
    10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:710
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:135
    8	plgSystemAdmintools->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:668
    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:225
    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.58 ms After last query: 2.06 ms Query memory: 0.021 MB Memory before query: 2.807 MB Rows returned: 1

    SELECT `query`
    
      FROM kd8eh_osmembership_sefurls
    
      WHERE md5_key="baaa0bf086901a1cf0b0868a2df0823e"

    Explain

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

    Profile

    Status	Duration
    starting	0.04 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.01 ms
    preparing	0.01 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
    cleaned up	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    10	JDatabaseDriver->loadResult()	JROOT/components/com_osmembership/router.php:247
    9	OSMembershipRouter->parse()	JROOT/libraries/src/Router/SiteRouter.php:438
    8	Joomla\CMS\Router\SiteRouter->parseSefRoute()	JROOT/libraries/src/Router/Router.php:482
    7	Joomla\CMS\Router\Router->_parseSefRoute()	JROOT/libraries/src/Router/Router.php:227
    6	Joomla\CMS\Router\Router->parse()	JROOT/libraries/src/Router/SiteRouter.php:139
    5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1142
    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:225
    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.67 ms After last query: 0.12 ms Query memory: 0.021 MB Memory before query: 2.815 MB Rows returned: 1

    SELECT *
    
      FROM `kd8eh_admintools_wafblacklists`
    
      WHERE `verb` IN('','GET') 
      AND `option` IN('','com_osmembership') 
      AND `view` IN('','register') 
      AND `task` IN('','register.') 
      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	kd8eh_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.05 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.02 ms
    Creating tmp table	0.03 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.04 ms
    Creating sort index	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaned up	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/admintools/feature/wafblacklist.php:87
    10	AtsystemFeatureWafblacklist->onAfterRoute()	JROOT/plugins/system/admintools/admintools/main.php:710
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:145
    8	plgSystemAdmintools->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:1190
    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:225
    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.71 ms After last query: 0.24 ms Query memory: 0.022 MB Memory before query: 2.822 MB Rows returned: 7

    SELECT id, home, template, s.params
    
      FROM kd8eh_template_styles as s
    
      LEFT JOIN kd8eh_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	e	NULL	ref	element_clientid,element_folder_clientid,extension	extension	82	const	7	1.00	Using index condition; Using where
    1	SIMPLE	s	NULL	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	auroraedtech.e.element	1	77.78	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    optimizing	0.02 ms
    statistics	0.07 ms
    preparing	0.02 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.02 ms
    cleaned up	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:320
    9	T3::detect()	JROOT/plugins/system/t3/t3.php:81
    8	plgSystemT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    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:225
    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.62 ms After last query: 1.90 ms Query memory: 0.019 MB Memory before query: 2.911 MB Rows returned: 1

    SELECT *
    
      FROM kd8eh_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	kd8eh_languages	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	50.00	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.04 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.01 ms
    preparing	0.01 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.10 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaned up	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    7	JDatabaseDriverMysqli->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:225
    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.86 ms After last query: 3.35 ms Query memory: 0.039 MB Memory before query: 3.120 MB Rows returned: 1

    SELECT *
    
      FROM kd8eh_osmembership_plans
    
      WHERE id=12

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	kd8eh_osmembership_plans	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.01 ms
    init	0.04 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.07 ms
    preparing	0.11 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.03 ms
    cleaned up	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/components/com_osmembership/helper/database.php:70
    11	OSMembershipHelperDatabase::getPlan()	JROOT/components/com_osmembership/view/register/html.php:53
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Query Time: 0.55 ms After last query: 0.18 ms Query memory: 0.022 MB Memory before query: 3.140 MB Rows returned: 2

    SELECT name
    
      FROM kd8eh_osmembership_plugins
    
      WHERE published = 1 
      AND `access` IN (1,1,5) 
      AND (support_recurring_subscription = 1 OR name = "os_offline")
    
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.05 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
    cleaned up	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_osmembership/helper/payments.php:173
    11	OSMembershipHelperPayments::getDefautPaymentMethod()	JROOT/components/com_osmembership/view/register/html.php:156
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    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.85 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 3.147 MB Rows returned: 2

    SELECT *
    
      FROM kd8eh_osmembership_plugins
    
      WHERE published = 1 
      AND `access` IN (1,1,5) 
      AND (support_recurring_subscription = 1 OR name LIKE "os_offline%")
    
      ORDER BY `ordering`

    Explain

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

    Profile

    Status	Duration
    starting	0.18 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    init	0.03 ms
    System lock	0.01 ms
    optimizing	0.01 ms
    statistics	0.12 ms
    preparing	0.02 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
    cleaned up	0.01 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_osmembership/helper/payments.php:53
    11	OSMembershipHelperPayments::getPaymentMethods()	JROOT/components/com_osmembership/view/register/html.php:164
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    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.95 ms After last query: 0.31 ms Query memory: 0.028 MB Memory before query: 3.178 MB Rows returned: 47

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `kd8eh_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_droptables','com_fields','com_finder','com_guru','com_ijoomla_seo','com_installer','com_jaextmanager','com_jce','com_jmap','com_joomlaupdate','com_kunena','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nextend2','com_osmembership','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsform','com_search','com_smartslider3','com_tags','com_templates','com_users','com_wrapper')

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    17	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    16	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    14	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    13	Joomla\CMS\User\User->authorise()	JROOT/components/com_osmembership/helper/helper.php:1290
    12	OSMembershipHelper::getProfileFields()	JROOT/components/com_osmembership/helper/helper.php:137
    11	OSMembershipHelper::callOverridableHelperMethod()	JROOT/components/com_osmembership/view/register/html.php:172
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    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: 1.27 ms After last query: 0.28 ms Query memory: 0.062 MB Memory before query: 3.243 MB Rows returned: 21

    SELECT *
    
      FROM kd8eh_osmembership_fields
    
      WHERE published = 1 
      AND (plan_id = 0 OR id IN (SELECT field_id 
      FROM kd8eh_osmembership_field_plan 
      WHERE plan_id = 12 OR plan_id < 0)) 
      AND id NOT IN (SELECT field_id 
      FROM kd8eh_osmembership_field_plan 
      WHERE plan_id = -12) 
      AND `access` IN (1,1,5) 
      AND show_on_subscription_form = 1
    
      ORDER BY ordering

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	kd8eh_osmembership_fields	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	24	4.17	Using where; Using filesort
    3	SUBQUERY	kd8eh_osmembership_field_plan	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6	16.67	Using where
    2	SUBQUERY	kd8eh_osmembership_field_plan	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	6	44.44	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_osmembership/helper/helper.php:1329
    12	OSMembershipHelper::getProfileFields()	JROOT/components/com_osmembership/helper/helper.php:137
    11	OSMembershipHelper::callOverridableHelperMethod()	JROOT/components/com_osmembership/view/register/html.php:172
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    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.68 ms After last query: 0.78 ms Query memory: 0.024 MB Memory before query: 3.541 MB Rows returned: 1
    Duplicate queries: #38

    SELECT country_2_code
    
      FROM kd8eh_osmembership_countries
    
      WHERE LOWER(name) = 'united states'

    Explain

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

    Profile

    Status	Duration
    starting	0.04 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.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.18 ms
    end	0.08 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaned up	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    17	JDatabaseDriver->loadResult()	JROOT/components/com_osmembership/helper/helper.php:1918
    16	OSMembershipHelper::getCountryCode()	JROOT/components/com_osmembership/helper/subscription.php:600
    15	OSMembershipHelperSubscription::calculateSubscriptionTaxRate()	JROOT/components/com_osmembership/helper/helper.php:137
    14	OSMembershipHelper::callOverridableHelperMethod()	JROOT/components/com_osmembership/helper/subscription.php:44
    13	OSMembershipHelperSubscription::calculateRecurringSubscriptionFee()	JROOT/components/com_osmembership/helper/helper.php:137
    12	OSMembershipHelper::callOverridableHelperMethod()	JROOT/components/com_osmembership/helper/helper.php:1020
    11	OSMembershipHelper::calculateSubscriptionFee()	JROOT/components/com_osmembership/view/register/html.php:189
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    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.51 ms After last query: 0.11 ms Query memory: 0.024 MB Memory before query: 3.550 MB Rows returned: 0

    SELECT rate
    
      FROM kd8eh_osmembership_taxes
    
      WHERE published = 1 
      AND plan_id = 12 
      AND (country = "" OR country = 'United States') 
      AND state = "" 
      AND vies = 0
    
      ORDER BY country DESC

    Explain

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

    Profile

    Status	Duration
    starting	0.04 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.01 ms
    preparing	0.01 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaned up	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/components/com_osmembership/helper/helper.php:1122
    16	OSMembershipHelper::calculateTaxRate()	JROOT/components/com_osmembership/helper/subscription.php:645
    15	OSMembershipHelperSubscription::calculateSubscriptionTaxRate()	JROOT/components/com_osmembership/helper/helper.php:137
    14	OSMembershipHelper::callOverridableHelperMethod()	JROOT/components/com_osmembership/helper/subscription.php:44
    13	OSMembershipHelperSubscription::calculateRecurringSubscriptionFee()	JROOT/components/com_osmembership/helper/helper.php:137
    12	OSMembershipHelper::callOverridableHelperMethod()	JROOT/components/com_osmembership/helper/helper.php:1020
    11	OSMembershipHelper::calculateSubscriptionFee()	JROOT/components/com_osmembership/view/register/html.php:189
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    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: 0.57 ms After last query: 0.06 ms Query memory: 0.024 MB Memory before query: 3.559 MB Rows returned: 0

    SELECT rate
    
      FROM kd8eh_osmembership_taxes
    
      WHERE published = 1 
      AND plan_id = 0 
      AND (country = "" OR country = 'United States') 
      AND state = "" 
      AND vies = 0
    
      ORDER BY country DESC

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/components/com_osmembership/helper/helper.php:1156
    16	OSMembershipHelper::calculateTaxRate()	JROOT/components/com_osmembership/helper/subscription.php:645
    15	OSMembershipHelperSubscription::calculateSubscriptionTaxRate()	JROOT/components/com_osmembership/helper/helper.php:137
    14	OSMembershipHelper::callOverridableHelperMethod()	JROOT/components/com_osmembership/helper/subscription.php:44
    13	OSMembershipHelperSubscription::calculateRecurringSubscriptionFee()	JROOT/components/com_osmembership/helper/helper.php:137
    12	OSMembershipHelper::callOverridableHelperMethod()	JROOT/components/com_osmembership/helper/helper.php:1020
    11	OSMembershipHelper::calculateSubscriptionFee()	JROOT/components/com_osmembership/view/register/html.php:189
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    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.68 ms After last query: 0.21 ms Query memory: 0.042 MB Memory before query: 3.566 MB Rows returned: 74

    SELECT `message_key`,`message`
    
      FROM kd8eh_osmembership_messages

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_osmembership/libraries/mpf/config/config.php:41
    13	MPFConfig->__construct()	JROOT/components/com_osmembership/helper/helper.php:1574
    12	OSMembershipHelper::getMessages()	JROOT/components/com_osmembership/view/register/html.php:616
    11	OSMembershipViewRegisterHtml->getFormMessage()	JROOT/components/com_osmembership/view/register/html.php:201
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    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.44 ms After last query: 0.13 ms Query memory: 0.022 MB Memory before query: 3.607 MB Rows returned: 1

    SELECT *
    
      FROM kd8eh_osmembership_categories
    
      WHERE id=2

    Explain

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

    Profile

    Status	Duration
    starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 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.01 ms
    end	0.02 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaned up	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/components/com_osmembership/helper/database.php:38
    12	OSMembershipHelperDatabase::getCategory()	JROOT/components/com_osmembership/view/register/html.php:738
    11	OSMembershipViewRegisterHtml->getFormMessage()	JROOT/components/com_osmembership/view/register/html.php:201
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    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.65 ms After last query: 0.95 ms Query memory: 0.023 MB Memory before query: 3.640 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM kd8eh_osmembership_coupons
    
      WHERE published = 1 
      AND `access` IN (1,1,5) 
      AND (valid_from = '0000-00-00 00:00:00' OR valid_from <= '2023-06-03 10:43:50') 
      AND (valid_to = '0000-00-00 00:00:00' OR DATE(valid_to) >= '2023-06-03 10:43:50') 
      AND (times = 0 OR times > used) 
      AND (user_id = 0 OR user_id =0) 
      AND (plan_id = 0 OR id IN (SELECT coupon_id 
      FROM kd8eh_osmembership_coupon_plans 
      WHERE plan_id = 12))

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	PRIMARY	kd8eh_osmembership_coupons	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	2	50.00	Using where
    2	DEPENDENT SUBQUERY	kd8eh_osmembership_coupon_plans	NULL	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.07 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.02 ms
    preparing	0.02 ms
    optimizing	0.01 ms
    statistics	0.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    executing	0.00 ms
    Sending data	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.04 ms
    cleaned up	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_osmembership/helper/subscription.php:829
    11	OSMembershipHelperSubscription::isCouponAvailableForPlan()	JROOT/components/com_osmembership/view/register/html.php:232
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    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.50 ms After last query: 0.24 ms Query memory: 0.022 MB Memory before query: 3.650 MB Rows returned: 0

    SELECT DISTINCT(country)
    
      FROM kd8eh_osmembership_taxes
    
      WHERE published = 1

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/components/com_osmembership/helper/helper.php:1038
    11	OSMembershipHelper::isCountryBaseTax()	JROOT/components/com_osmembership/view/register/html.php:339
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    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.42 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 3.657 MB Rows returned: 0

    SELECT rate
    
      FROM kd8eh_osmembership_taxes
    
      WHERE published = 1 
      AND plan_id = 12
    
      ORDER BY `rate` DESC

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/components/com_osmembership/helper/helper.php:1213
    11	OSMembershipHelper::calculateMaxTaxRate()	JROOT/components/com_osmembership/view/register/html.php:340
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    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.51 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 3.663 MB Rows returned: 0

    SELECT rate
    
      FROM kd8eh_osmembership_taxes
    
      WHERE published = 1 
      AND plan_id = 0
    
      ORDER BY `rate` DESC

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    12	JDatabaseDriver->loadObject()	JROOT/components/com_osmembership/helper/helper.php:1247
    11	OSMembershipHelper::calculateMaxTaxRate()	JROOT/components/com_osmembership/view/register/html.php:340
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

37. Query Time: 0.45 ms After last query: 0.05 ms Query memory: 0.022 MB Memory before query: 3.669 MB Rows returned: 0
    Duplicate queries: #47

    SELECT DISTINCT(country)
    
      FROM kd8eh_osmembership_taxes
    
      WHERE `state` != "" 
      AND published = 1

    Explain

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

    Profile

    Status	Duration
    starting	0.02 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.01 ms
    preparing	0.01 ms
    Creating tmp table	0.02 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaned up	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/components/com_osmembership/helper/helper.php:1070
    11	OSMembershipHelper::getTaxStateCountries()	JROOT/components/com_osmembership/view/register/html.php:341
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

38. Query Time: 0.62 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 3.675 MB Rows returned: 1
    Duplicate queries: #28

    SELECT country_2_code
    
      FROM kd8eh_osmembership_countries
    
      WHERE LOWER(name) = 'united states'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_osmembership/helper/helper.php:1918
    11	OSMembershipHelper::getCountryCode()	JROOT/components/com_osmembership/view/register/html.php:342
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

39. Query Time: 0.45 ms After last query: 1.78 ms Query memory: 0.026 MB Memory before query: 3.763 MB Rows returned: 1
    Duplicate queries: #40  #50  #51  #58  #59  #69  #70

    select `params` 
      from kd8eh_ijseo_config

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    22	JDatabase->query()	JROOT/plugins/system/ijseo/ijseo.php:757
    21	plgSystemIjseo->getComponentParams()	JROOT/plugins/system/ijseo/ijseo.php:766
    20	plgSystemIjseo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    17	JHtmlContent::prepare()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_osmembership/view/register/tmpl/default.php:119
    13	include JROOT/components/com_osmembership/view/register/tmpl/default.php	JROOT/administrator/components/com_osmembership/libraries/mpf/view/html.php:224
    12	MPFViewHtml->render()	JROOT/administrator/components/com_osmembership/libraries/mpf/view/html.php:121
    11	MPFViewHtml->display()	JROOT/components/com_osmembership/view/register/html.php:350
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

40. Query Time: 0.45 ms After last query: 0.04 ms Query memory: 0.026 MB Memory before query: 3.774 MB Rows returned: 1
    Duplicate queries: #39  #50  #51  #58  #59  #69  #70

    select `params` 
      from kd8eh_ijseo_config

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    22	JDatabaseDriver->loadColumn()	JROOT/plugins/system/ijseo/ijseo.php:758
    21	plgSystemIjseo->getComponentParams()	JROOT/plugins/system/ijseo/ijseo.php:766
    20	plgSystemIjseo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    17	JHtmlContent::prepare()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_osmembership/view/register/tmpl/default.php:119
    13	include JROOT/components/com_osmembership/view/register/tmpl/default.php	JROOT/administrator/components/com_osmembership/libraries/mpf/view/html.php:224
    12	MPFViewHtml->render()	JROOT/administrator/components/com_osmembership/libraries/mpf/view/html.php:121
    11	MPFViewHtml->display()	JROOT/components/com_osmembership/view/register/html.php:350
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

41. Query Time: 0.43 ms After last query: 0.08 ms Query memory: 0.026 MB Memory before query: 3.789 MB Rows returned: 1
    Duplicate queries: #42

    select max(`checkdate`) 
      from kd8eh_ijseo_keys 
      limit 0,1

    Explain

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

    Profile

    Status	Duration
    starting	0.10 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.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaned up	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    21	JDatabase->query()	JROOT/plugins/system/ijseo/ijseo.php:777
    20	plgSystemIjseo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    17	JHtmlContent::prepare()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_osmembership/view/register/tmpl/default.php:119
    13	include JROOT/components/com_osmembership/view/register/tmpl/default.php	JROOT/administrator/components/com_osmembership/libraries/mpf/view/html.php:224
    12	MPFViewHtml->render()	JROOT/administrator/components/com_osmembership/libraries/mpf/view/html.php:121
    11	MPFViewHtml->display()	JROOT/components/com_osmembership/view/register/html.php:350
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

42. Query Time: 0.34 ms After last query: 0.03 ms Query memory: 0.026 MB Memory before query: 3.800 MB Rows returned: 1
    Duplicate queries: #41

    select max(`checkdate`) 
      from kd8eh_ijseo_keys 
      limit 0,1

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    21	JDatabaseDriver->loadColumn()	JROOT/plugins/system/ijseo/ijseo.php:778
    20	plgSystemIjseo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    17	JHtmlContent::prepare()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_osmembership/view/register/tmpl/default.php:119
    13	include JROOT/components/com_osmembership/view/register/tmpl/default.php	JROOT/administrator/components/com_osmembership/libraries/mpf/view/html.php:224
    12	MPFViewHtml->render()	JROOT/administrator/components/com_osmembership/libraries/mpf/view/html.php:121
    11	MPFViewHtml->display()	JROOT/components/com_osmembership/view/register/html.php:350
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

43. Query Time: 0.43 ms After last query: 0.05 ms Query memory: 0.026 MB Memory before query: 3.810 MB Rows returned: 0
    Duplicate queries: #44

    select * 
      from kd8eh_ijseo_keys as a 
      where 1<=(SELECT DATEDIFF('2023-06-03 15:43:50',a.checkdate)) OR a.checkdate='0000-00-00 00:00:00' 
      order by checkdate asc 
      limit 0,10

    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	1	100.00	Using where; Using filesort

    Profile

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

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    21	JDatabase->query()	JROOT/plugins/system/ijseo/ijseo.php:787
    20	plgSystemIjseo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    17	JHtmlContent::prepare()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_osmembership/view/register/tmpl/default.php:119
    13	include JROOT/components/com_osmembership/view/register/tmpl/default.php	JROOT/administrator/components/com_osmembership/libraries/mpf/view/html.php:224
    12	MPFViewHtml->render()	JROOT/administrator/components/com_osmembership/libraries/mpf/view/html.php:121
    11	MPFViewHtml->display()	JROOT/components/com_osmembership/view/register/html.php:350
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

44. Query Time: 3.13 ms After last query: 0.04 ms Query memory: 0.026 MB Memory before query: 3.821 MB Rows returned: 0
    Duplicate queries: #43

    select * 
      from kd8eh_ijseo_keys as a 
      where 1<=(SELECT DATEDIFF('2023-06-03 15:43:50',a.checkdate)) OR a.checkdate='0000-00-00 00:00:00' 
      order by checkdate asc 
      limit 0,10

    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	1	100.00	Using where; Using filesort

    Profile

    Status	Duration
    starting	0.04 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
    preparing	0.01 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.05 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaned up	0.00 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    21	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/ijseo/ijseo.php:790
    20	plgSystemIjseo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    17	JHtmlContent::prepare()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_osmembership/view/register/tmpl/default.php:119
    13	include JROOT/components/com_osmembership/view/register/tmpl/default.php	JROOT/administrator/components/com_osmembership/libraries/mpf/view/html.php:224
    12	MPFViewHtml->render()	JROOT/administrator/components/com_osmembership/libraries/mpf/view/html.php:121
    11	MPFViewHtml->display()	JROOT/components/com_osmembership/view/register/html.php:350
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

45. Query Time: 0.95 ms After last query: 2.90 ms Query memory: 0.037 MB Memory before query: 3.987 MB Rows returned: 245

    SELECT name AS value, IF(CHAR_LENGTH(`name`) > 0, `name`, `name`) AS text 
      FROM kd8eh_osmembership_countries 
      WHERE published = 1 
      ORDER BY ordering

    Explain

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

    Profile

    Status	Duration
    starting	0.07 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.02 ms
    Sorting result	0.01 ms
    executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.36 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaned up	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_osmembership/libraries/mpf/form/field/countries.php:70
    18	MPFFormFieldCountries->getOptions()	JROOT/administrator/components/com_osmembership/libraries/mpf/form/field/list.php:98
    17	MPFFormFieldList->getInput()	JROOT/administrator/components/com_osmembership/libraries/mpf/form/field.php:415
    16	MPFFormField->getControlGroup()	JROOT/components/com_osmembership/view/register/tmpl/default_form.php:119
    15	include JROOT/components/com_osmembership/view/register/tmpl/default_form.php	JROOT/administrator/components/com_osmembership/libraries/mpf/view/html.php:255
    14	MPFViewHtml->loadTemplate()	JROOT/components/com_osmembership/view/register/tmpl/default.php:128
    13	include JROOT/components/com_osmembership/view/register/tmpl/default.php	JROOT/administrator/components/com_osmembership/libraries/mpf/view/html.php:224
    12	MPFViewHtml->render()	JROOT/administrator/components/com_osmembership/libraries/mpf/view/html.php:121
    11	MPFViewHtml->display()	JROOT/components/com_osmembership/view/register/html.php:350
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

46. Query Time: 0.75 ms After last query: 0.60 ms Query memory: 0.028 MB Memory before query: 4.023 MB Rows returned: 51

    SELECT state_2_code AS value, state_name AS text
    
      FROM kd8eh_osmembership_states AS a
    
      INNER JOIN kd8eh_osmembership_countries AS b 
      ON a.country_id = b.country_id
    
      WHERE b.name = 'United States' 
      AND a.published = 1
    
      ORDER BY a.state_name

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	b	NULL	ref	idx_country_name	idx_country_name	195	const	1	100.00	Using temporary; Using filesort
    1	SIMPLE	a	NULL	ref	state_3_code,state_2_code,idx_country_id	state_3_code	4	auroraedtech.b.country_id	29	10.00	Using where

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.01 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
    Creating tmp table	0.02 ms
    Sorting result	0.01 ms
    executing	0.00 ms
    Sending data	0.15 ms
    Creating sort index	0.04 ms
    end	0.01 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaned up	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_osmembership/libraries/mpf/form/field/state.php:58
    18	MPFFormFieldState->getOptions()	JROOT/administrator/components/com_osmembership/libraries/mpf/form/field/list.php:98
    17	MPFFormFieldList->getInput()	JROOT/administrator/components/com_osmembership/libraries/mpf/form/field.php:415
    16	MPFFormField->getControlGroup()	JROOT/components/com_osmembership/view/register/tmpl/default_form.php:119
    15	include JROOT/components/com_osmembership/view/register/tmpl/default_form.php	JROOT/administrator/components/com_osmembership/libraries/mpf/view/html.php:255
    14	MPFViewHtml->loadTemplate()	JROOT/components/com_osmembership/view/register/tmpl/default.php:128
    13	include JROOT/components/com_osmembership/view/register/tmpl/default.php	JROOT/administrator/components/com_osmembership/libraries/mpf/view/html.php:224
    12	MPFViewHtml->render()	JROOT/administrator/components/com_osmembership/libraries/mpf/view/html.php:121
    11	MPFViewHtml->display()	JROOT/components/com_osmembership/view/register/html.php:350
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

47. Query Time: 0.45 ms After last query: 0.10 ms Query memory: 0.026 MB Memory before query: 4.064 MB Rows returned: 0
    Duplicate queries: #37

    SELECT DISTINCT(country)
    
      FROM kd8eh_osmembership_taxes
    
      WHERE `state` != "" 
      AND published = 1

    Explain

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

    Profile

    Status	Duration
    starting	0.03 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.01 ms
    preparing	0.01 ms
    Creating tmp table	0.02 ms
    executing	0.00 ms
    Sending data	0.02 ms
    end	0.00 ms
    query end	0.01 ms
    removing tmp table	0.01 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    cleaned up	0.00 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    20	JDatabaseDriver->loadColumn()	JROOT/components/com_osmembership/helper/helper.php:1070
    19	OSMembershipHelper::getTaxStateCountries()	JROOT/administrator/components/com_osmembership/libraries/mpf/form/field/state.php:93
    18	MPFFormFieldState->getOptions()	JROOT/administrator/components/com_osmembership/libraries/mpf/form/field/list.php:98
    17	MPFFormFieldList->getInput()	JROOT/administrator/components/com_osmembership/libraries/mpf/form/field.php:415
    16	MPFFormField->getControlGroup()	JROOT/components/com_osmembership/view/register/tmpl/default_form.php:119
    15	include JROOT/components/com_osmembership/view/register/tmpl/default_form.php	JROOT/administrator/components/com_osmembership/libraries/mpf/view/html.php:255
    14	MPFViewHtml->loadTemplate()	JROOT/components/com_osmembership/view/register/tmpl/default.php:128
    13	include JROOT/components/com_osmembership/view/register/tmpl/default.php	JROOT/administrator/components/com_osmembership/libraries/mpf/view/html.php:224
    12	MPFViewHtml->render()	JROOT/administrator/components/com_osmembership/libraries/mpf/view/html.php:121
    11	MPFViewHtml->display()	JROOT/components/com_osmembership/view/register/html.php:350
    10	OSMembershipViewRegisterHtml->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:343
    9	MPFController->display()	JROOT/components/com_osmembership/controller/display.php:114
    8	OSMembershipController->display()	JROOT/administrator/components/com_osmembership/libraries/mpf/controller/controller.php:277
    7	MPFController->execute()	JROOT/components/com_osmembership/osmembership.php:43
    6	require_once JROOT/components/com_osmembership/osmembership.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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

48. Query Time: 0.76 ms After last query: 1.11 ms Query memory: 0.021 MB Memory before query: 3.978 MB Rows returned: 22
    Duplicate queries: #49

    select `menutype` 
      from kd8eh_menu 
      where  1=1  
      and link like '%option=%' 
      and link like '%view=%' 
      and link like '%id=%' 
      and `published`=1

    Explain

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

    Profile

    Status	Duration
    starting	0.07 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.01 ms
    preparing	0.01 ms
    executing	0.00 ms
    Sending data	0.27 ms
    end	0.01 ms
    query end	0.01 ms
    closing tables	0.01 ms
    freeing items	0.02 ms
    cleaned up	0.01 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    10	JDatabase->query()	JROOT/plugins/system/ijseo/ijseo.php:174
    9	plgSystemIjseo->isMenu()	JROOT/plugins/system/ijseo/ijseo.php:112
    8	plgSystemIjseo->getMetaValues()	JROOT/plugins/system/ijseo/ijseo.php:60
    7	plgSystemIjseo->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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

49. Query Time: 0.61 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 3.984 MB Rows returned: 22
    Duplicate queries: #48

    select `menutype` 
      from kd8eh_menu 
      where  1=1  
      and link like '%option=%' 
      and link like '%view=%' 
      and link like '%id=%' 
      and `published`=1

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    10	JDatabaseDriver->loadColumn()	JROOT/plugins/system/ijseo/ijseo.php:175
    9	plgSystemIjseo->isMenu()	JROOT/plugins/system/ijseo/ijseo.php:112
    8	plgSystemIjseo->getMetaValues()	JROOT/plugins/system/ijseo/ijseo.php:60
    7	plgSystemIjseo->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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

50. Query Time: 0.36 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 3.988 MB Rows returned: 1
    Duplicate queries: #39  #40  #51  #58  #59  #69  #70

    select `params` 
      from kd8eh_ijseo_config

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    11	JDatabase->query()	JROOT/plugins/system/ijseo/ijseo.php:757
    10	plgSystemIjseo->getComponentParams()	JROOT/plugins/system/ijseo/ijseo.php:567
    9	plgSystemIjseo->getMenusMeta()	JROOT/plugins/system/ijseo/ijseo.php:121
    8	plgSystemIjseo->getMetaValues()	JROOT/plugins/system/ijseo/ijseo.php:60
    7	plgSystemIjseo->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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

51. Query Time: 0.36 ms After last query: 0.02 ms Query memory: 0.021 MB Memory before query: 3.994 MB Rows returned: 1
    Duplicate queries: #39  #40  #50  #58  #59  #69  #70

    select `params` 
      from kd8eh_ijseo_config

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    11	JDatabaseDriver->loadColumn()	JROOT/plugins/system/ijseo/ijseo.php:758
    10	plgSystemIjseo->getComponentParams()	JROOT/plugins/system/ijseo/ijseo.php:567
    9	plgSystemIjseo->getMenusMeta()	JROOT/plugins/system/ijseo/ijseo.php:121
    8	plgSystemIjseo->getMetaValues()	JROOT/plugins/system/ijseo/ijseo.php:60
    7	plgSystemIjseo->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:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

52. Query Time: 0.41 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 4.003 MB Rows returned: 1