{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1747758036,
                "last": 1747758036,
                "now": 1747758036
            },
            "token": "1HXL52sIaTLMDY3ZH6HwF2cMVsoHN7RP"
        },
        "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
        },
        "jomsocial_userip": "18.97.14.88"
    }
}

Time

Memory

87 Queries Logged 43.22 ms

1. Query Time: 0.93 ms Query memory: 0.023 MB Memory before query: 1.060 MB Rows returned: 0

   SELECT `data`
   
     FROM `qlo7g_session`
   
     WHERE `session_id` = X'6662386131363332383533383263663765336363616534376431656364346531'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	qlo7g_session	const	PRIMARY	PRIMARY	194	const	1

   Profile

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

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Same as call in the line below.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   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:48

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

   ---

2. Query Time: 0.33 ms After last query: 0.48 ms Query memory: 0.020 MB Memory before query: 1.074 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `qlo7g_session`
   
     WHERE `session_id` = X'6662386131363332383533383263663765336363616534376431656364346531' 
     LIMIT 1

   Explain

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

   Profile

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

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

   ---

3. Query Time: 1.04 ms After last query: 0.09 ms Query memory: 0.004 MB Memory before query: 1.079 MB

   INSERT INTO `qlo7g_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'6662386131363332383533383263663765336363616534376431656364346531', 1, 1747758036, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `qlo7g_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6662386131363332383533383263663765336363616534376431656364346531', 1, 1747758036, 0, '', 0)

   Profile

   Status	Duration
   Starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.01 ms
   init for update	0.03 ms
   Update	0.14 ms
   Waiting for query cache lock	0.01 ms
   Update	0.01 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.64 ms
   Query end	0.01 ms
   closing tables	0.01 ms
   Unlocking tables	0.01 ms
   closing tables	0.01 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.02 ms
   Reset for next command	0.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:48

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

   ---

4. Query Time: 0.71 ms After last query: 0.65 ms Query memory: 0.042 MB Memory before query: 1.111 MB Rows returned: 59

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	qlo7g_extensions	ref	extension	extension	82	const	61	Using index condition; Using where

   Profile

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

   Call Stack

   #	Caller	File and line number
   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:51

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

   ---

5. Query Time: 0.21 ms After last query: 0.71 ms Query memory: 0.021 MB Memory before query: 1.164 MB Rows returned: 10

   SELECT id, rules
   
     FROM `qlo7g_viewlevels`

   Explain

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

   Profile

   Status	Duration
   Starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.01 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.01 ms
   Executing	0.01 ms
   Sending data	0.02 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.01 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	0.00 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:51

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

   ---

6. Query Time: 0.28 ms After last query: 0.07 ms Query memory: 0.021 MB Memory before query: 1.178 MB Rows returned: 2

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

   Explain

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

   Profile

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

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

   ---

7. Query Time: 0.89 ms After last query: 0.12 ms Query memory: 0.056 MB Memory before query: 1.200 MB Rows returned: 212

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM qlo7g_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	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	qlo7g_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	476	Using where; Using filesort

   Profile

   Status	Duration
   Starting	0.03 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.01 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.03 ms
   Preparing	0.01 ms
   Sorting result	0.01 ms
   Executing	0.01 ms
   Sending data	0.01 ms
   Creating sort index	0.64 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.01 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.00 ms
   Starting cleanup	0.01 ms
   Freeing items	0.01 ms
   Updating status	0.01 ms
   Reset for next command	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:51

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

   ---

8. Query Time: 0.37 ms After last query: 4.94 ms Query memory: 0.022 MB Memory before query: 1.685 MB Rows returned: 1

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	qlo7g_admintools_storage	const	PRIMARY	PRIMARY	402	const	1

   Profile

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

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   13	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_admintools/Helper/Storage.php:122
   12	Akeeba\AdminTools\Admin\Helper\Storage->load()	JROOT/administrator/components/com_admintools/Helper/Storage.php:37
   11	Akeeba\AdminTools\Admin\Helper\Storage->__construct()	JROOT/administrator/components/com_admintools/Helper/Storage.php:49
   10	Akeeba\AdminTools\Admin\Helper\Storage::getInstance()	JROOT/plugins/system/admintools/admintools/main.php:409
   9	plgSystemAdmintools->loadComponentParameters()	JROOT/plugins/system/admintools/admintools/main.php:892
   8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
   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:51

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

   ---

9. Query Time: 0.25 ms After last query: 0.23 ms Query memory: 0.021 MB Memory before query: 1.694 MB Rows returned: 0

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

   Explain

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

   Profile

   Status	Duration
   Starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.02 ms
   After opening tables	0.01 ms
   System lock	0.01 ms
   table lock	0.00 ms
   init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.01 ms
   Preparing	0.01 ms
   Executing	0.00 ms
   Sending data	0.03 ms
   End of update loop	0.01 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Query end	0.00 ms
   closing tables	0.00 ms
   Unlocking tables	0.00 ms
   closing tables	0.00 ms
   Query end	0.01 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.01 ms
   Reset for next command	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:729
   10	plgSystemAdmintools->loadWAFExceptionsSEF()	JROOT/plugins/system/admintools/admintools/main.php:640
   9	plgSystemAdmintools->loadWAFExceptions()	JROOT/plugins/system/admintools/admintools/main.php:901
   8	plgSystemAdmintools->initialize()	JROOT/plugins/system/admintools/admintools/main.php:84
   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:51

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

   ---

10. Query Time: 0.45 ms After last query: 13.49 ms Query memory: 0.021 MB Memory before query: 3.115 MB Rows returned: 0

    SELECT `source`,`keepurlparams`
    
      FROM `qlo7g_admintools_redirects`
    
      WHERE ((`dest` = 'term') OR (`dest` = 'term?id=3&tmpl=component') OR ('term?id=3&tmpl=component' LIKE `dest`)) 
      AND `published` = '1'
    
      ORDER BY `ordering` DESC 
      LIMIT 1

    Explain

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

    Profile

    Status	Duration
    Starting	0.06 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Sorting result	0.02 ms
    Executing	0.01 ms
    Sending data	0.01 ms
    Creating sort index	0.05 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.04 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:91
    10	AtsystemFeatureUrlredir->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php:308
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:144
    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:51

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

    ---

11. Query Time: 0.41 ms After last query: 1.72 ms Query memory: 0.065 MB Memory before query: 3.178 MB Rows returned: 166

    SELECT setting,value 
      FROM qlo7g_jfbconnect_config

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    15	JDatabaseDriver->loadAssocList()	JROOT/administrator/components/com_jfbconnect/models/config.php:304
    14	JFBConnectModelConfig->getSettings()	JROOT/administrator/components/com_jfbconnect/models/config.php:342
    13	JFBConnectModelConfig->get()	JROOT/components/com_jfbconnect/libraries/provider.php:49
    12	JFBConnectProvider->__construct()	JROOT/plugins/jfbconnect/provider_facebook/provider/facebook.php:38
    11	JFBConnectProviderFacebook->__construct()	JROOT/components/com_jfbconnect/libraries/factory.php:61
    10	JFBCFactory::provider()	JROOT/components/com_jfbconnect/libraries/factory.php:93
    9	JFBCFactory::getAllProviders()	JROOT/plugins/system/jfbcsystem/jfbcsystem.php:69
    8	plgSystemJFBCSystem->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:51

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

    ---

12. Query Time: 0.46 ms After last query: 1.30 ms Query memory: 0.025 MB Memory before query: 3.354 MB Rows returned: 0

    SELECT value
    
      FROM qlo7g_jfbconnect_config
    
      WHERE setting="profile_jomsocial"

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    19	JDatabaseDriver->loadResult()	JROOT/libraries/sourcecoast/plugins/socialprofile.php:649
    18	SocialProfilePlugin->loadSettings()	JROOT/plugins/socialprofiles/jomsocial/jomsocial.php:721
    17	plgSocialProfilesJomsocial->loadSettings()	JROOT/libraries/sourcecoast/plugins/socialprofile.php:195
    16	SocialProfilePlugin->onSocialProfilesGetRequiredScope()	JROOT/libraries/joomla/event/event.php:70
    15	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    14	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    13	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/plugins/jfbconnect/provider_google/profile/google.php:40
    12	JFBConnectProfileGoogle->getRequiredScope()	JROOT/plugins/jfbconnect/provider_google/provider/google.php:33
    11	JFBConnectProviderGoogle->setupAuthentication()	JROOT/components/com_jfbconnect/libraries/factory.php:62
    10	JFBCFactory::provider()	JROOT/components/com_jfbconnect/libraries/factory.php:93
    9	JFBCFactory::getAllProviders()	JROOT/plugins/system/jfbcsystem/jfbcsystem.php:69
    8	plgSystemJFBCSystem->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:51

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

    ---

13. Query Time: 0.32 ms After last query: 2.20 ms Query memory: 0.021 MB Memory before query: 3.435 MB Rows returned: 1

    SELECT manifest_cache
    
      FROM `qlo7g_extensions`
    
      WHERE element = "com_affiliatetracker"

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qlo7g_extensions	ref	element_clientid,element_folder_clientid	element_clientid	402	const	1	Using index condition

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    10	JDatabaseDriver->loadResult()	JROOT/plugins/system/affiliate_tracker/affiliate_tracker.php:201
    9	plgSystemAffiliate_tracker->checkComponentInstalled()	JROOT/plugins/system/affiliate_tracker/affiliate_tracker.php:35
    8	plgSystemAffiliate_tracker->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:51

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

    ---

14. Query Time: 0.24 ms After last query: 0.24 ms Query memory: 0.020 MB Memory before query: 3.440 MB Rows returned: 0

    SELECT `id`
    
      FROM `qlo7g_affiliate_tracker_accounts`
    
      WHERE `ref_word` = 'term' 
      AND `publish` = '1'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    9	JDatabaseDriver->loadResult()	JROOT/plugins/system/affiliate_tracker/affiliate_tracker.php:68
    8	plgSystemAffiliate_tracker->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:51

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

    ---

15. Query Time: 0.26 ms After last query: 1.63 ms Query memory: 0.023 MB Memory before query: 3.615 MB Rows returned: 39

    SELECT *
    
      FROM qlo7g_rsform_config

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:52
    11	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:19
    10	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:104
    9	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:34
    8	plgSystemRsformdeletesubmissions->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:51

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

    ---

16. Query Time: 1.15 ms After last query: 0.75 ms Query memory: 0.116 MB Memory before query: 3.654 MB Rows returned: 90

    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 qlo7g_menu AS m
    
      LEFT JOIN qlo7g_extensions AS e 
      ON m.component_id = e.extension_id
    
      WHERE m.published = 1 
      AND m.parent_id > 0 
      AND m.client_id = 0
    
      ORDER BY m.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	177	Using index condition; Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	planetgiftcards_planet.m.component_id	1	Using where

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.02 ms
    Statistics	0.05 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.73 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	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/Menu/SiteMenu.php:93
    17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
    13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
    11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
    10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
    8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
    6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1141
    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:51

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

    ---

17. Query Time: 0.35 ms After last query: 4.65 ms Query memory: 0.022 MB Memory before query: 4.171 MB Rows returned: 0
    Duplicate queries: #18

    SELECT `userid` 
      FROM `qlo7g_community_users` 
      WHERE `alias`='term'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qlo7g_community_users	ref	alias	alias	767	const	1	Using index condition

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_community/router.php:477
    11	CommunityGetUserId()	JROOT/components/com_community/router.php:228
    10	CommunityParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->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:51

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

    ---

18. Query Time: 0.21 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 4.177 MB Rows returned: 0
    Duplicate queries: #17

    SELECT `userid` 
      FROM `qlo7g_community_users` 
      WHERE `alias`='term'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qlo7g_community_users	ref	alias	alias	767	const	1	Using index condition

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    12	JDatabaseDriver->loadResult()	JROOT/components/com_community/router.php:492
    11	CommunityGetUserId()	JROOT/components/com_community/router.php:228
    10	CommunityParseRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:105
    9	Joomla\CMS\Component\Router\RouterLegacy->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:51

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

    ---

19. Query Time: 0.30 ms After last query: 0.47 ms Query memory: 0.024 MB Memory before query: 4.209 MB Rows returned: 1

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qlo7g_extensions	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	Using index condition

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.01 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.06 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.04 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.02 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 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/jomsocial.system/jomsocial.system.php:90
    7	azrulSysBot()	JROOT/libraries/joomla/event/dispatcher.php:165
    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:51

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

    ---

20. Query Time: 0.99 ms After last query: 0.10 ms Query memory: 0.006 MB Memory before query: 4.201 MB

    UPDATE `qlo7g_extensions`
    
      SET `params` = '{\"mediaversion\":\"56f1ec7421d4a3a7ee8220dbbb135df1\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init for update	0.04 ms
    Updating	0.11 ms
    End of update loop	0.01 ms
    Waiting for query cache lock	0.00 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.67 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 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/jomsocial.system/jomsocial.system.php:90
    7	azrulSysBot()	JROOT/libraries/joomla/event/dispatcher.php:165
    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:51

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

    ---

21. Query Time: 0.40 ms After last query: 0.63 ms Query memory: 0.038 MB Memory before query: 4.221 MB Rows returned: 6

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	8	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	planetgiftcards_planet.s.template,const	1	Using index condition; Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    11	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:266
    10	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/helixultimate.php:215
    9	PlgSystemHelixultimate->attachWebAsset()	JROOT/plugins/system/helixultimate/helixultimate.php:244
    8	PlgSystemHelixultimate->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:51

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

    ---

22. Query Time: 0.30 ms After last query: 0.58 ms Query memory: 0.022 MB Memory before query: 4.297 MB Rows returned: 1
    Duplicate queries: #40  #41  #42  #43  #44  #69

    SELECT *
    
      FROM `qlo7g_template_styles`
    
      WHERE `client_id` = 0 
      AND `id` = '10'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qlo7g_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.00 ms
    Unlocking tables	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.01 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	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/helixultimate/src/Platform/Helper.php:54
    11	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
    10	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/helixultimate.php:215
    9	PlgSystemHelixultimate->attachWebAsset()	JROOT/plugins/system/helixultimate/helixultimate.php:244
    8	PlgSystemHelixultimate->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:51

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

    ---

23. Query Time: 0.30 ms After last query: 0.35 ms Query memory: 0.019 MB Memory before query: 4.304 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.00 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	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.04 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 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:51

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

    ---

24. Query Time: 0.75 ms After last query: 1.68 ms Query memory: 0.023 MB Memory before query: 4.415 MB Rows returned: 2

    SHOW FULL COLUMNS 
      FROM `qlo7g_community_config`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    11	Joomla\CMS\Table\Table->__construct()	JROOT/administrator/components/com_community/tables/configuration.php:22
    10	CommunityTableConfiguration->__construct()	JROOT/libraries/src/Table/Table.php:328
    9	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_community/libraries/core.php:1069
    8	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:232
    7	CFactory::getConfig()	JROOT/components/com_community/community.php:46
    6	require_once JROOT/components/com_community/community.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:51

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

    ---

25. Query Time: 0.22 ms After last query: 0.26 ms Query memory: 0.021 MB Memory before query: 4.428 MB Rows returned: 1

    SELECT *
    
      FROM qlo7g_community_config
    
      WHERE `name` = 'config'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qlo7g_community_config	const	PRIMARY	PRIMARY	194	const	1

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    9	Joomla\CMS\Table\Table->load()	JROOT/components/com_community/libraries/core.php:1070
    8	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:232
    7	CFactory::getConfig()	JROOT/components/com_community/community.php:46
    6	require_once JROOT/components/com_community/community.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:51

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

    ---

26. Query Time: 0.20 ms After last query: 0.31 ms Query memory: 0.023 MB Memory before query: 4.529 MB Rows returned: 0
    Duplicate queries: #31

    SELECT `id` 
      FROM `qlo7g_users` 
      WHERE `id` = '0'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    15	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:187
    14	CFactory::getUser()	JROOT/components/com_community/libraries/core.php:500
    13	CFactory::getRequestUser()	JROOT/plugins/community/myfriendslocation/myfriendslocation.php:25
    12	plgCommunityMyFriendsLocation->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    11	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    10	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_community/libraries/apps.php:53
    9	CAppPlugins->loadApplications()	JROOT/components/com_community/libraries/core.php:1076
    8	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:232
    7	CFactory::getConfig()	JROOT/components/com_community/community.php:46
    6	require_once JROOT/components/com_community/community.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:51

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

    ---

27. Query Time: 0.41 ms After last query: 0.22 ms Query memory: 0.024 MB Memory before query: 4.552 MB Rows returned: 0

    SELECT  	a.`userid` as _userid , 	a.`status` as _status , 	a.`points`	as _points, 	a.`posted_on` as _posted_on, 	a.`avatar`	as _avatar , 	a.`cover`	as _cover , 	a.`thumb`	as _thumb , 	a.`invite`	as _invite, 	a.`params`	as _cparams,  	a.`view`	as _view,  a.`friends` as _friends,  a.`groups` as _groups,  a.`events` as _events,  a.`friendcount` as _friendcount,  a.`alias` as _alias,  a.`profile_id` as _profile_id,  a.`storage` as _storage,  a.`watermark_hash` as _watermark_hash,  a.`search_email` as _search_email,  a.`longitude` as longitude,  a.`latitude` as latitude,  a.`default_avatar` as _defaultAvatar,  a.`usergroup` as _usergroup,  s.`userid` as _isonline, u.*  
      FROM `qlo7g_community_users` as a  
      LEFT JOIN `qlo7g_users` u  
      ON u.`id`=a.`userid` 
      LEFT 
      OUTER JOIN `qlo7g_session` s  
      ON s.`userid`=a.`userid` 
      AND s.`client_id` !='1' 
      WHERE a.`userid`='0'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    16	JDatabaseDriver->loadObject()	JROOT/components/com_community/libraries/user.php:174
    15	CUser->init()	JROOT/components/com_community/libraries/core.php:199
    14	CFactory::getUser()	JROOT/components/com_community/libraries/core.php:500
    13	CFactory::getRequestUser()	JROOT/plugins/community/myfriendslocation/myfriendslocation.php:25
    12	plgCommunityMyFriendsLocation->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    11	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    10	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_community/libraries/apps.php:53
    9	CAppPlugins->loadApplications()	JROOT/components/com_community/libraries/core.php:1076
    8	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:232
    7	CFactory::getConfig()	JROOT/components/com_community/community.php:46
    6	require_once JROOT/components/com_community/community.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:51

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

    ---

28. Query Time: 7.51 ms After last query: 0.14 ms Query memory: 0.028 MB Memory before query: 4.565 MB Rows returned: 16

    SHOW FULL COLUMNS 
      FROM `qlo7g_community_profiles`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    20	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    19	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    18	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_community/tables/multiprofile.php:33
    17	CTableMultiProfile->__construct()	JROOT/libraries/src/Table/Table.php:328
    16	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_community/libraries/user.php:760
    15	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:200
    14	CFactory::getUser()	JROOT/components/com_community/libraries/core.php:500
    13	CFactory::getRequestUser()	JROOT/plugins/community/myfriendslocation/myfriendslocation.php:25
    12	plgCommunityMyFriendsLocation->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    11	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    10	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_community/libraries/apps.php:53
    9	CAppPlugins->loadApplications()	JROOT/components/com_community/libraries/core.php:1076
    8	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:232
    7	CFactory::getConfig()	JROOT/components/com_community/community.php:46
    6	require_once JROOT/components/com_community/community.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:51

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

    ---

29. Query Time: 0.27 ms After last query: 0.41 ms Query memory: 0.025 MB Memory before query: 4.595 MB Rows returned: 1

    SELECT `id` 
      FROM `qlo7g_community_fields` 
      WHERE `fieldcode`='FIELD_GENDER'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qlo7g_community_fields	ref	fieldcode	fieldcode	767	const	1	Using index condition

    Profile

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

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    19	JDatabaseDriver->loadResult()	JROOT/components/com_community/models/profile.php:817
    18	CommunityModelProfile->_getgenderId()	JROOT/components/com_community/models/profile.php:791
    17	CommunityModelProfile->getGender()	JROOT/components/com_community/libraries/user.php:642
    16	CUser->_getGender()	JROOT/components/com_community/libraries/user.php:792
    15	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:200
    14	CFactory::getUser()	JROOT/components/com_community/libraries/core.php:500
    13	CFactory::getRequestUser()	JROOT/plugins/community/myfriendslocation/myfriendslocation.php:25
    12	plgCommunityMyFriendsLocation->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    11	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    10	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_community/libraries/apps.php:53
    9	CAppPlugins->loadApplications()	JROOT/components/com_community/libraries/core.php:1076
    8	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:232
    7	CFactory::getConfig()	JROOT/components/com_community/community.php:46
    6	require_once JROOT/components/com_community/community.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:51

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

    ---

30. Query Time: 0.24 ms After last query: 0.03 ms Query memory: 0.025 MB Memory before query: 4.604 MB Rows returned: 0

    SELECT `value` 
      FROM `qlo7g_community_fields_values` 
      WHERE `field_id` = '2' 
      AND `user_id` = '0'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qlo7g_community_fields_values	ref	field_id,user_id,idx_user_fieldid	user_id	4	const	1	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    18	JDatabaseDriver->loadResult()	JROOT/components/com_community/models/profile.php:800
    17	CommunityModelProfile->getGender()	JROOT/components/com_community/libraries/user.php:642
    16	CUser->_getGender()	JROOT/components/com_community/libraries/user.php:792
    15	CUser->getThumbAvatar()	JROOT/components/com_community/libraries/core.php:200
    14	CFactory::getUser()	JROOT/components/com_community/libraries/core.php:500
    13	CFactory::getRequestUser()	JROOT/plugins/community/myfriendslocation/myfriendslocation.php:25
    12	plgCommunityMyFriendsLocation->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    11	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    10	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_community/libraries/apps.php:53
    9	CAppPlugins->loadApplications()	JROOT/components/com_community/libraries/core.php:1076
    8	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:232
    7	CFactory::getConfig()	JROOT/components/com_community/community.php:46
    6	require_once JROOT/components/com_community/community.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:51

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

    ---

31. Query Time: 0.24 ms After last query: 1.52 ms Query memory: 0.023 MB Memory before query: 4.652 MB Rows returned: 0
    Duplicate queries: #26

    SELECT `id` 
      FROM `qlo7g_users` 
      WHERE `id` = '0'

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    14	JDatabaseDriver->loadResult()	JROOT/components/com_community/libraries/core.php:187
    13	CFactory::getUser()	JROOT/plugins/community/myvideos/myvideos.php:26
    12	plgCommunityMyVideos->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    11	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    10	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/components/com_community/libraries/apps.php:53
    9	CAppPlugins->loadApplications()	JROOT/components/com_community/libraries/core.php:1076
    8	CConfig::getInstance()	JROOT/components/com_community/libraries/core.php:232
    7	CFactory::getConfig()	JROOT/components/com_community/community.php:46
    6	require_once JROOT/components/com_community/community.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:51

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

    ---

32. Query Time: 0.23 ms After last query: 0.80 ms Query memory: 0.021 MB Memory before query: 4.727 MB Rows returned: 0

    SELECT * 
      FROM `qlo7g_community_mailq` 
      WHERE `status`='0' 
      LIMIT 0,100

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qlo7g_community_mailq	ref	status	status	1	const	1

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    10	JDatabaseDriver->loadObjectList()	JROOT/components/com_community/models/mailq.php:139
    9	CommunityModelMailq->get()	JROOT/components/com_community/libraries/mailq.php:23
    8	CMailq->send()	JROOT/components/com_community/libraries/cron.php:116
    7	CCron->sendEmailsOnPageLoad()	JROOT/components/com_community/community.php:72
    6	require_once JROOT/components/com_community/community.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:51

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

    ---

33. Query Time: 0.51 ms After last query: 1.15 ms Query memory: 0.023 MB Memory before query: 4.764 MB Rows returned: 27
    Duplicate queries: #34

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.30 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	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:51

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

    ---

34. Query Time: 0.42 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 4.770 MB Rows returned: 27
    Duplicate queries: #33

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.24 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.01 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:51

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

    ---

35. Query Time: 0.20 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 4.775 MB Rows returned: 1
    Duplicate queries: #36  #48  #49

    select `params` 
      from qlo7g_ijseo_config

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.00 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.00 ms
    Starting cleanup	0.01 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	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:51

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

    ---

36. Query Time: 0.17 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 4.780 MB Rows returned: 1
    Duplicate queries: #35  #48  #49

    select `params` 
      from qlo7g_ijseo_config

    Explain

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

    Profile

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

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

    ---

37. Query Time: 0.18 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 4.790 MB Rows returned: 1
    Duplicate queries: #38

    select `params` 
      from qlo7g_menu 
      where id=444

    Explain

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

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 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:576
    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:51

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

    ---

38. Query Time: 0.19 ms After last query: 0.01 ms Query memory: 0.021 MB Memory before query: 4.795 MB Rows returned: 1
    Duplicate queries: #37

    select `params` 
      from qlo7g_menu 
      where id=444

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	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:577
    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:51

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

    ---

39. Query Time: 0.93 ms After last query: 14.06 ms Query memory: 0.027 MB Memory before query: 4.934 MB Rows returned: 59

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `qlo7g_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_admintools','com_affiliatetracker','com_ajax','com_akeeba','com_allvideoshare','com_associations','com_banners','com_bfstop','com_broadcast','com_cache','com_categories','com_checkin','com_community','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_enmasse','com_ffexplorer','com_fields','com_finder','com_ijoomla_seo','com_installer','com_invitex','com_jce','com_jchat','com_jfbconnect','com_jmailalerts','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_oauth','com_plugins','com_postinstall','com_privacy','com_profiles','com_redirect','com_rsform','com_rstbox','com_sa','com_search','com_socialads','com_tags','com_templates','com_tjfields','com_tjprivacy','com_users','com_weblinks','com_wrapper')

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    12	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    11	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    10	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    9	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    8	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/jfbcsystem/jfbcsystem.php:209
    7	plgSystemJFBCSystem->onBeforeRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1102
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

40. Query Time: 0.25 ms After last query: 0.88 ms Query memory: 0.023 MB Memory before query: 5.080 MB Rows returned: 1
    Duplicate queries: #22  #41  #42  #43  #44  #69

    SELECT *
    
      FROM `qlo7g_template_styles`
    
      WHERE `client_id` = 0 
      AND `id` = '10'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qlo7g_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

    Profile

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

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    15	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
    14	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
    13	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/helixultimate.php:383
    12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

41. Query Time: 0.23 ms After last query: 0.22 ms Query memory: 0.024 MB Memory before query: 5.089 MB Rows returned: 1
    Duplicate queries: #22  #40  #42  #43  #44  #69

    SELECT *
    
      FROM `qlo7g_template_styles`
    
      WHERE `client_id` = 0 
      AND `id` = '10'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qlo7g_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

    Profile

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

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    16	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
    15	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
    14	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:117
    13	HelixUltimate\Framework\Core\HelixUltimate->__construct()	JROOT/plugins/system/helixultimate/helixultimate.php:395
    12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

42. Query Time: 0.19 ms After last query: 0.12 ms Query memory: 0.024 MB Memory before query: 5.098 MB Rows returned: 1
    Duplicate queries: #22  #40  #41  #43  #44  #69

    SELECT *
    
      FROM `qlo7g_template_styles`
    
      WHERE `client_id` = 0 
      AND `id` = '10'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qlo7g_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
    16	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
    15	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:1922
    14	HelixUltimate\Framework\Core\HelixUltimate->addCustomAssets()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:146
    13	HelixUltimate\Framework\Core\HelixUltimate->__call()	JROOT/plugins/system/helixultimate/helixultimate.php:418
    12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

43. Query Time: 0.17 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 5.106 MB Rows returned: 1
    Duplicate queries: #22  #40  #41  #42  #44  #69

    SELECT *
    
      FROM `qlo7g_template_styles`
    
      WHERE `client_id` = 0 
      AND `id` = '10'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qlo7g_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
    16	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
    15	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:1922
    14	HelixUltimate\Framework\Core\HelixUltimate->addCustomAssets()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:146
    13	HelixUltimate\Framework\Core\HelixUltimate->__call()	JROOT/plugins/system/helixultimate/helixultimate.php:419
    12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

44. Query Time: 0.17 ms After last query: 0.11 ms Query memory: 0.024 MB Memory before query: 5.114 MB Rows returned: 1
    Duplicate queries: #22  #40  #41  #42  #43  #69

    SELECT *
    
      FROM `qlo7g_template_styles`
    
      WHERE `client_id` = 0 
      AND `id` = '10'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qlo7g_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

    Profile

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

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
    16	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
    15	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:1922
    14	HelixUltimate\Framework\Core\HelixUltimate->addCustomAssets()	JROOT/plugins/system/helixultimate/src/Core/HelixUltimate.php:146
    13	HelixUltimate\Framework\Core\HelixUltimate->__call()	JROOT/plugins/system/helixultimate/helixultimate.php:420
    12	PlgSystemHelixultimate->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

45. Query Time: 0.19 ms After last query: 0.82 ms Query memory: 0.020 MB Memory before query: 5.132 MB Rows returned: 1

    SELECT params 
      FROM `qlo7g_ijseo_config`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    8	JDatabaseDriver->loadColumn()	JROOT/plugins/system/ijseo/ijseo.php:1001
    7	plgSystemIjseo->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

46. Query Time: 0.28 ms After last query: 0.10 ms Query memory: 0.020 MB Memory before query: 5.144 MB Rows returned: 0
    Duplicate queries: #47

    SELECT i.*
    				
      FROM qlo7g_ijseo_ilinks AS i
    				
      LEFT JOIN qlo7g_ijseo_ilinks_articles AS ia 
      ON i.id = ia.ilink_id
    				
      WHERE ( i.published =1 
      AND ia.article_id = ''  
      AND i.include_in = 1 )
    				OR ( i.published =1 
      AND i.include_in = 0 )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	i	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
    1	SIMPLE	ia	ref	PRIMARY	PRIMARY	4	planetgiftcards_planet.i.id	1	Using where; Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    8	JDatabase->query()	JROOT/plugins/system/ijseo/ijseo.php:1041
    7	plgSystemIjseo->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

47. Query Time: 0.31 ms After last query: 0.02 ms Query memory: 0.020 MB Memory before query: 5.149 MB Rows returned: 0
    Duplicate queries: #46

    SELECT i.*
    				
      FROM qlo7g_ijseo_ilinks AS i
    				
      LEFT JOIN qlo7g_ijseo_ilinks_articles AS ia 
      ON i.id = ia.ilink_id
    				
      WHERE ( i.published =1 
      AND ia.article_id = ''  
      AND i.include_in = 1 )
    				OR ( i.published =1 
      AND i.include_in = 0 )

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	i	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
    1	SIMPLE	ia	ref	PRIMARY	PRIMARY	4	planetgiftcards_planet.i.id	1	Using where; Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    8	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/ijseo/ijseo.php:1042
    7	plgSystemIjseo->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

48. Query Time: 0.18 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 5.153 MB Rows returned: 1
    Duplicate queries: #35  #36  #49

    select `params` 
      from qlo7g_ijseo_config

    Explain

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

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.01 ms
    table lock	0.00 ms
    init	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 of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.00 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:33
    9	plgSystemIjseo->getParams()	JROOT/plugins/system/ijseo/ijseo.php:1217
    8	plgSystemIjseo->titleplg()	JROOT/plugins/system/ijseo/ijseo.php:1213
    7	plgSystemIjseo->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

49. Query Time: 0.15 ms After last query: 0.01 ms Query memory: 0.021 MB Memory before query: 5.158 MB Rows returned: 1
    Duplicate queries: #35  #36  #48

    select `params` 
      from qlo7g_ijseo_config

    Explain

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

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.01 ms
    Optimizing	0.00 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	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:34
    9	plgSystemIjseo->getParams()	JROOT/plugins/system/ijseo/ijseo.php:1217
    8	plgSystemIjseo->titleplg()	JROOT/plugins/system/ijseo/ijseo.php:1213
    7	plgSystemIjseo->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

50. Query Time: 0.22 ms After last query: 1.19 ms Query memory: 0.021 MB Memory before query: 5.170 MB Rows returned: 14
    Duplicate queries: #51  #53  #54  #57  #63  #67  #70  #71  #73  #74  #77  #83  #87

    SELECT namekey,value 
      FROM `qlo7g_invitex_config`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    10	JDatabaseDriver->loadObjectList()	JROOT/components/com_invitex/helper.php:275
    9	CominvitexHelper->getconfigData()	JROOT/components/com_invitex/helper.php:42
    8	CominvitexHelper->__construct()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:68
    7	PlgSystemplug_Sys_Invitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

51. Query Time: 0.21 ms After last query: 0.08 ms Query memory: 0.021 MB Memory before query: 5.198 MB Rows returned: 14
    Duplicate queries: #50  #53  #54  #57  #63  #67  #70  #71  #73  #74  #77  #83  #87

    SELECT namekey,value 
      FROM `qlo7g_invitex_config`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/components/com_invitex/helper.php:275
    8	CominvitexHelper->getconfigData()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:69
    7	PlgSystemplug_Sys_Invitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

52. Query Time: 0.26 ms After last query: 0.18 ms Query memory: 0.020 MB Memory before query: 5.204 MB Rows returned: 1
    Duplicate queries: #72

    SELECT max(sent_at) AS last_email_date 
      FROM qlo7g_invitex_imports_emails 
      WHERE sent=1

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    9	JDatabaseDriver->loadResult()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:253
    8	PlgSystemplug_Sys_Invitex->process_email_queue()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:230
    7	PlgSystemplug_Sys_Invitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

53. Query Time: 0.19 ms After last query: 0.09 ms Query memory: 0.022 MB Memory before query: 5.217 MB Rows returned: 14
    Duplicate queries: #50  #51  #54  #57  #63  #67  #70  #71  #73  #74  #77  #83  #87

    SELECT namekey,value 
      FROM `qlo7g_invitex_config`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_invitex/helper.php:275
    11	CominvitexHelper->getconfigData()	JROOT/components/com_invitex/helper.php:42
    10	CominvitexHelper->__construct()	JROOT/components/com_invitex/models/invites.php:37
    9	InvitexModelInvites->__construct()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:276
    8	PlgSystemplug_Sys_Invitex->process_email_queue()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:230
    7	PlgSystemplug_Sys_Invitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

54. Query Time: 0.22 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 5.224 MB Rows returned: 14
    Duplicate queries: #50  #51  #53  #57  #63  #67  #70  #71  #73  #74  #77  #83  #87

    SELECT namekey,value 
      FROM `qlo7g_invitex_config`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_invitex/helper.php:275
    10	CominvitexHelper->getconfigData()	JROOT/components/com_invitex/models/invites.php:38
    9	InvitexModelInvites->__construct()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:276
    8	PlgSystemplug_Sys_Invitex->process_email_queue()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:230
    7	PlgSystemplug_Sys_Invitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

55. Query Time: 0.44 ms After last query: 0.16 ms Query memory: 0.023 MB Memory before query: 5.297 MB Rows returned: 13
    Duplicate queries: #75

    SELECT e.id as
    			refid,e.guest,e.invitee_email,e.invitee_name,e.resend_count,e.inviter_id as id,
    			u.email as inviter_email, i.message,
    			e.expires,i.invite_type,i.invite_url,i.invite_type_tag
    						
      FROM qlo7g_invitex_imports_emails AS e
    						
      LEFT JOIN qlo7g_invitex_imports AS i 
      ON e.import_id = i.id
    						
      LEFT JOIN qlo7g_users AS u 
      ON i.inviter_id = u.id
    						
      WHERE i.message_type='email' 
      AND e.unsubscribe=0 
      AND e.sent=0 OR e.resend=1 
      LIMIT 30

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	120	Using where
    1	SIMPLE	i	eq_ref	PRIMARY	PRIMARY	4	planetgiftcards_planet.e.import_id	1	Using where
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	planetgiftcards_planet.i.inviter_id	1	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    10	JDatabaseDriver->loadObjectList()	JROOT/components/com_invitex/models/invites.php:1519
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:279
    8	PlgSystemplug_Sys_Invitex->process_email_queue()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:230
    7	PlgSystemplug_Sys_Invitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

56. Query Time: 0.24 ms After last query: 0.05 ms Query memory: 0.025 MB Memory before query: 5.318 MB Rows returned: 126
    Duplicate queries: #60  #62  #76  #80  #82

    select LOWER(email) 
      from qlo7g_users

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qlo7g_users	index	NULL	email	402	NULL	126	Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    11	JDatabaseDriver->loadColumn()	JROOT/components/com_invitex/models/invites.php:2933
    10	InvitexModelInvites->getRegistered()	JROOT/components/com_invitex/models/invites.php:1523
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:279
    8	PlgSystemplug_Sys_Invitex->process_email_queue()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:230
    7	PlgSystemplug_Sys_Invitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

57. Query Time: 0.32 ms After last query: 29.70 ms Query memory: 0.023 MB Memory before query: 21.215 MB Rows returned: 14
    Duplicate queries: #50  #51  #53  #54  #63  #67  #70  #71  #73  #74  #77  #83  #87

    SELECT namekey,value 
      FROM `qlo7g_invitex_config`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_invitex/helper.php:275
    12	CominvitexHelper->getconfigData()	JROOT/components/com_invitex/helper.php:42
    11	CominvitexHelper->__construct()	JROOT/components/com_invitex/models/invites.php:1801
    10	InvitexModelInvites->send_message_cron()	JROOT/components/com_invitex/models/invites.php:1780
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:279
    8	PlgSystemplug_Sys_Invitex->process_email_queue()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:230
    7	PlgSystemplug_Sys_Invitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

58. Query Time: 0.59 ms After last query: 1.76 ms Query memory: 0.021 MB Memory before query: 21.273 MB Rows returned: 0
    Duplicate queries: #78

    SELECT i.id,i.provider_email 
      FROM qlo7g_invitex_imports_emails as ie ,
    		qlo7g_invitex_imports as i 
      WHERE i.provider_email IN ('twitter','linkedin','sms') 
      AND
    		ie.sent<>1 
      AND ie.import_id=i.id 
      group by i.id,i.provider_email

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ie	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	120	Using where; Using temporary; Using filesort
    1	SIMPLE	i	eq_ref	PRIMARY	PRIMARY	4	planetgiftcards_planet.ie.import_id	1	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_invitex/models/invites.php:1827
    10	InvitexModelInvites->send_message_cron()	JROOT/components/com_invitex/models/invites.php:1780
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:279
    8	PlgSystemplug_Sys_Invitex->process_email_queue()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:230
    7	PlgSystemplug_Sys_Invitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

59. Query Time: 1.06 ms After last query: 0.05 ms Query memory: 0.029 MB Memory before query: 21.278 MB Rows returned: 9
    Duplicate queries: #79

    SELECT e.id as refid,e.invitee_email,e.invitee_name,e.* , u.id as
    		inviter_id, u.name as inviter_name, u.email as inviter_email,
    		i.message,i.invite_type,i.invite_url,i.invite_type_tag
    						
      FROM qlo7g_invitex_imports_emails AS e
    						
      LEFT JOIN qlo7g_invitex_imports AS i 
      ON e.import_id = i.id
    						
      LEFT JOIN qlo7g_users AS u 
      ON i.inviter_id = u.id
    						
      WHERE i.message_type='email' 
      AND e.unsubscribe=0 
      AND e.sent=1 
      AND e.invitee_id=0  
      AND e.remind=1  
      ORDER BY e.id DESC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	index	NULL	PRIMARY	4	NULL	120	Using where
    1	SIMPLE	i	eq_ref	PRIMARY	PRIMARY	4	planetgiftcards_planet.e.import_id	1	Using where
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	planetgiftcards_planet.i.inviter_id	1

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_invitex/models/invites.php:2058
    10	InvitexModelInvites->send_reminder()	JROOT/components/com_invitex/models/invites.php:1781
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:279
    8	PlgSystemplug_Sys_Invitex->process_email_queue()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:230
    7	PlgSystemplug_Sys_Invitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

60. Query Time: 0.50 ms After last query: 7.81 ms Query memory: 0.025 MB Memory before query: 29.233 MB Rows returned: 126
    Duplicate queries: #56  #62  #76  #80  #82

    select LOWER(email) 
      from qlo7g_users

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qlo7g_users	index	NULL	email	402	NULL	126	Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/components/com_invitex/models/invites.php:2933
    11	InvitexModelInvites->getRegistered()	JROOT/components/com_invitex/models/invites.php:2089
    10	InvitexModelInvites->send_reminder()	JROOT/components/com_invitex/models/invites.php:1781
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:279
    8	PlgSystemplug_Sys_Invitex->process_email_queue()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:230
    7	PlgSystemplug_Sys_Invitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

61. Query Time: 1.50 ms After last query: 24.41 ms Query memory: 0.121 MB Memory before query: 21.290 MB Rows returned: 105
    Duplicate queries: #81

    SELECT e.id as refid,e.invitee_email,e.invitee_name,e.* , u.id as
    		inviter_id, u.name as inviter_name, u.email as inviter_email,
    		i.message,i.invite_type,i.invite_url,i.invite_type_tag
    						
      FROM qlo7g_invitex_imports_emails AS e
    						
      LEFT JOIN qlo7g_invitex_imports AS i 
      ON e.import_id = i.id
    						
      LEFT JOIN qlo7g_users AS u 
      ON i.inviter_id = u.id
    						
      WHERE i.message_type='email' 
      AND e.unsubscribe=0 
      AND e.sent=1 
      AND e.invitee_id=0  
      ORDER BY e.id DESC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	index	NULL	PRIMARY	4	NULL	120	Using where
    1	SIMPLE	i	eq_ref	PRIMARY	PRIMARY	4	planetgiftcards_planet.e.import_id	1	Using where
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	planetgiftcards_planet.i.inviter_id	1

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_invitex/models/invites.php:2058
    10	InvitexModelInvites->send_reminder()	JROOT/components/com_invitex/models/invites.php:1782
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:279
    8	PlgSystemplug_Sys_Invitex->process_email_queue()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:230
    7	PlgSystemplug_Sys_Invitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

62. Query Time: 0.46 ms After last query: 7.61 ms Query memory: 0.025 MB Memory before query: 29.458 MB Rows returned: 126
    Duplicate queries: #56  #60  #76  #80  #82

    select LOWER(email) 
      from qlo7g_users

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qlo7g_users	index	NULL	email	402	NULL	126	Using index

    Profile

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.02 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.08 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.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_invitex/models/invites.php:2933
    11	InvitexModelInvites->getRegistered()	JROOT/components/com_invitex/models/invites.php:2089
    10	InvitexModelInvites->send_reminder()	JROOT/components/com_invitex/models/invites.php:1782
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:279
    8	PlgSystemplug_Sys_Invitex->process_email_queue()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:230
    7	PlgSystemplug_Sys_Invitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

63. Query Time: 0.53 ms After last query: 24.52 ms Query memory: 0.022 MB Memory before query: 21.302 MB Rows returned: 14
    Duplicate queries: #50  #51  #53  #54  #57  #67  #70  #71  #73  #74  #77  #83  #87

    SELECT namekey,value 
      FROM `qlo7g_invitex_config`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_invitex/helper.php:275
    11	CominvitexHelper->getconfigData()	JROOT/components/com_invitex/models/invites.php:2303
    10	InvitexModelInvites->send_friendsEmail()	JROOT/components/com_invitex/models/invites.php:1783
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:279
    8	PlgSystemplug_Sys_Invitex->process_email_queue()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:230
    7	PlgSystemplug_Sys_Invitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

64. Query Time: 0.39 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 21.308 MB Rows returned: 4
    Duplicate queries: #84

    select distinct LOWER(invitee_email) 
      from qlo7g_invitex_imports_emails 
      where unsubscribe=1

    Explain

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

    Profile

    Status	Duration
    Starting	0.04 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.02 ms
    Creating tmp table	0.04 ms
    Executing	0.01 ms
    Sending data	0.10 ms
    Removing tmp table	0.02 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	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_invitex/models/invites.php:2952
    11	InvitexModelInvites->getBlocked()	JROOT/components/com_invitex/models/invites.php:2306
    10	InvitexModelInvites->send_friendsEmail()	JROOT/components/com_invitex/models/invites.php:1783
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:279
    8	PlgSystemplug_Sys_Invitex->process_email_queue()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:230
    7	PlgSystemplug_Sys_Invitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

65. Query Time: 0.72 ms After last query: 0.02 ms Query memory: 0.027 MB Memory before query: 21.324 MB Rows returned: 0
    Duplicate queries: #85

    select distinct LOWER(email) 
      from qlo7g_invitex_stored_emails 
      where unsubscribe=1

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/components/com_invitex/models/invites.php:2957
    11	InvitexModelInvites->getBlocked()	JROOT/components/com_invitex/models/invites.php:2306
    10	InvitexModelInvites->send_friendsEmail()	JROOT/components/com_invitex/models/invites.php:1783
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:279
    8	PlgSystemplug_Sys_Invitex->process_email_queue()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:230
    7	PlgSystemplug_Sys_Invitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

66. Query Time: 0.54 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 21.335 MB Rows returned: 0
    Duplicate queries: #86

    select * 
      from qlo7g_invitex_stored_emails 
      where importedcount >=3 
      and
    		sent_count=0 
      AND email NOT IN ('steve@fscs.ca','solutions@fscs.ca','ali@givebackpromotions.org','admin@oshawalawyers.com') 
      AND email NOT IN(SELECT email 
      from qlo7g_users)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	qlo7g_invitex_stored_emails	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	300	Using where
    2	DEPENDENT SUBQUERY	qlo7g_users	ref	email	email	402	func	1	Using where; Using index; Full scan on NULL key

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_invitex/models/invites.php:2314
    10	InvitexModelInvites->send_friendsEmail()	JROOT/components/com_invitex/models/invites.php:1783
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:279
    8	PlgSystemplug_Sys_Invitex->process_email_queue()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:230
    7	PlgSystemplug_Sys_Invitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

67. Query Time: 0.18 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 21.341 MB Rows returned: 14
    Duplicate queries: #50  #51  #53  #54  #57  #63  #70  #71  #73  #74  #77  #83  #87

    SELECT namekey,value 
      FROM `qlo7g_invitex_config`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_invitex/helper.php:275
    12	CominvitexHelper->getconfigData()	JROOT/components/com_invitex/helper.php:42
    11	CominvitexHelper->__construct()	JROOT/components/com_invitex/models/invites.php:2316
    10	InvitexModelInvites->send_friendsEmail()	JROOT/components/com_invitex/models/invites.php:1783
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:279
    8	PlgSystemplug_Sys_Invitex->process_email_queue()	JROOT/plugins/system/plug_sys_invitex/plug_sys_invitex.php:230
    7	PlgSystemplug_Sys_Invitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

68. Query Time: 0.48 ms After last query: 2.90 ms Query memory: 0.027 MB Memory before query: 5.485 MB Rows returned: 88

    SELECT * 
      FROM qlo7g_acymailing_config

    Explain

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

    Profile

    Status	Duration
    Starting	0.09 ms
    checking permissions	0.01 ms
    Opening tables	0.04 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.09 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	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_acymailing/compat/joomla.php:464
    13	acymailing_loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
    12	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:434
    11	acymailing_config()	JROOT/administrator/components/com_acymailing/compat/joomla.php:803
    10	include_once JROOT/administrator/components/com_acymailing/compat/joomla.php	JROOT/administrator/components/com_acymailing/helpers/helper.php:21
    9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:22
    8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:146
    7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

69. Query Time: 0.38 ms After last query: 3.13 ms Query memory: 0.021 MB Memory before query: 6.015 MB Rows returned: 1
    Duplicate queries: #22  #40  #41  #42  #43  #44

    SELECT *
    
      FROM `qlo7g_template_styles`
    
      WHERE `client_id` = 0 
      AND `id` = '10'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qlo7g_template_styles	const	PRIMARY,idx_client_id,idx_client_id_home	PRIMARY	4	const	1

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    10	JDatabaseDriver->loadObject()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:54
    9	HelixUltimate\Framework\Platform\Helper::getTemplateStyle()	JROOT/plugins/system/helixultimate/src/Platform/Helper.php:336
    8	HelixUltimate\Framework\Platform\Helper::loadTemplateData()	JROOT/plugins/system/helixultimate/helixultimate.php:522
    7	PlgSystemHelixultimate->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

70. Query Time: 0.22 ms After last query: 0.14 ms Query memory: 0.021 MB Memory before query: 6.017 MB Rows returned: 14
    Duplicate queries: #50  #51  #53  #54  #57  #63  #67  #71  #73  #74  #77  #83  #87

    SELECT namekey,value 
      FROM `qlo7g_invitex_config`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    10	JDatabaseDriver->loadObjectList()	JROOT/components/com_invitex/helper.php:275
    9	CominvitexHelper->getconfigData()	JROOT/components/com_invitex/helper.php:42
    8	CominvitexHelper->__construct()	JROOT/plugins/system/invitex/invitex.php:71
    7	PlgSystemInvitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

71. Query Time: 0.17 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 6.022 MB Rows returned: 14
    Duplicate queries: #50  #51  #53  #54  #57  #63  #67  #70  #73  #74  #77  #83  #87

    SELECT namekey,value 
      FROM `qlo7g_invitex_config`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/components/com_invitex/helper.php:275
    8	CominvitexHelper->getconfigData()	JROOT/plugins/system/invitex/invitex.php:72
    7	PlgSystemInvitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

72. Query Time: 0.23 ms After last query: 0.12 ms Query memory: 0.020 MB Memory before query: 6.027 MB Rows returned: 1
    Duplicate queries: #52

    SELECT max(sent_at) AS last_email_date 
      FROM qlo7g_invitex_imports_emails 
      WHERE sent=1

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    9	JDatabaseDriver->loadResult()	JROOT/plugins/system/invitex/invitex.php:275
    8	PlgSystemInvitex->process_email_queue()	JROOT/plugins/system/invitex/invitex.php:252
    7	PlgSystemInvitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

73. Query Time: 0.19 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 6.032 MB Rows returned: 14
    Duplicate queries: #50  #51  #53  #54  #57  #63  #67  #70  #71  #74  #77  #83  #87

    SELECT namekey,value 
      FROM `qlo7g_invitex_config`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_invitex/helper.php:275
    11	CominvitexHelper->getconfigData()	JROOT/components/com_invitex/helper.php:42
    10	CominvitexHelper->__construct()	JROOT/components/com_invitex/models/invites.php:37
    9	InvitexModelInvites->__construct()	JROOT/plugins/system/invitex/invitex.php:298
    8	PlgSystemInvitex->process_email_queue()	JROOT/plugins/system/invitex/invitex.php:252
    7	PlgSystemInvitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

74. Query Time: 0.16 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 6.039 MB Rows returned: 14
    Duplicate queries: #50  #51  #53  #54  #57  #63  #67  #70  #71  #73  #77  #83  #87

    SELECT namekey,value 
      FROM `qlo7g_invitex_config`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_invitex/helper.php:275
    10	CominvitexHelper->getconfigData()	JROOT/components/com_invitex/models/invites.php:38
    9	InvitexModelInvites->__construct()	JROOT/plugins/system/invitex/invitex.php:298
    8	PlgSystemInvitex->process_email_queue()	JROOT/plugins/system/invitex/invitex.php:252
    7	PlgSystemInvitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

75. Query Time: 0.42 ms After last query: 0.14 ms Query memory: 0.023 MB Memory before query: 6.046 MB Rows returned: 13
    Duplicate queries: #55

    SELECT e.id as
    			refid,e.guest,e.invitee_email,e.invitee_name,e.resend_count,e.inviter_id as id,
    			u.email as inviter_email, i.message,
    			e.expires,i.invite_type,i.invite_url,i.invite_type_tag
    						
      FROM qlo7g_invitex_imports_emails AS e
    						
      LEFT JOIN qlo7g_invitex_imports AS i 
      ON e.import_id = i.id
    						
      LEFT JOIN qlo7g_users AS u 
      ON i.inviter_id = u.id
    						
      WHERE i.message_type='email' 
      AND e.unsubscribe=0 
      AND e.sent=0 OR e.resend=1 
      LIMIT 30

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	120	Using where
    1	SIMPLE	i	eq_ref	PRIMARY	PRIMARY	4	planetgiftcards_planet.e.import_id	1	Using where
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	planetgiftcards_planet.i.inviter_id	1	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    10	JDatabaseDriver->loadObjectList()	JROOT/components/com_invitex/models/invites.php:1519
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/invitex/invitex.php:301
    8	PlgSystemInvitex->process_email_queue()	JROOT/plugins/system/invitex/invitex.php:252
    7	PlgSystemInvitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

76. Query Time: 0.21 ms After last query: 0.03 ms Query memory: 0.025 MB Memory before query: 6.067 MB Rows returned: 126
    Duplicate queries: #56  #60  #62  #80  #82

    select LOWER(email) 
      from qlo7g_users

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qlo7g_users	index	NULL	email	402	NULL	126	Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    11	JDatabaseDriver->loadColumn()	JROOT/components/com_invitex/models/invites.php:2933
    10	InvitexModelInvites->getRegistered()	JROOT/components/com_invitex/models/invites.php:1523
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/invitex/invitex.php:301
    8	PlgSystemInvitex->process_email_queue()	JROOT/plugins/system/invitex/invitex.php:252
    7	PlgSystemInvitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

77. Query Time: 0.64 ms After last query: 37.25 ms Query memory: 0.023 MB Memory before query: 22.023 MB Rows returned: 14
    Duplicate queries: #50  #51  #53  #54  #57  #63  #67  #70  #71  #73  #74  #83  #87

    SELECT namekey,value 
      FROM `qlo7g_invitex_config`

    Explain

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

    Profile

    Status	Duration
    Starting	0.11 ms
    checking permissions	0.01 ms
    Opening tables	0.05 ms
    After opening tables	0.01 ms
    System lock	0.01 ms
    table lock	0.01 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.01 ms
    Sending data	0.09 ms
    End of update loop	0.01 ms
    Query end	0.01 ms
    Commit	0.01 ms
    Query end	0.00 ms
    closing tables	0.01 ms
    Unlocking tables	0.00 ms
    closing tables	0.01 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.02 ms
    Reset for next command	0.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_invitex/helper.php:275
    12	CominvitexHelper->getconfigData()	JROOT/components/com_invitex/helper.php:42
    11	CominvitexHelper->__construct()	JROOT/components/com_invitex/models/invites.php:1801
    10	InvitexModelInvites->send_message_cron()	JROOT/components/com_invitex/models/invites.php:1780
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/invitex/invitex.php:301
    8	PlgSystemInvitex->process_email_queue()	JROOT/plugins/system/invitex/invitex.php:252
    7	PlgSystemInvitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

78. Query Time: 0.45 ms After last query: 0.21 ms Query memory: 0.021 MB Memory before query: 22.030 MB Rows returned: 0
    Duplicate queries: #58

    SELECT i.id,i.provider_email 
      FROM qlo7g_invitex_imports_emails as ie ,
    		qlo7g_invitex_imports as i 
      WHERE i.provider_email IN ('twitter','linkedin','sms') 
      AND
    		ie.sent<>1 
      AND ie.import_id=i.id 
      group by i.id,i.provider_email

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ie	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	120	Using where; Using temporary; Using filesort
    1	SIMPLE	i	eq_ref	PRIMARY	PRIMARY	4	planetgiftcards_planet.ie.import_id	1	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_invitex/models/invites.php:1827
    10	InvitexModelInvites->send_message_cron()	JROOT/components/com_invitex/models/invites.php:1780
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/invitex/invitex.php:301
    8	PlgSystemInvitex->process_email_queue()	JROOT/plugins/system/invitex/invitex.php:252
    7	PlgSystemInvitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

79. Query Time: 0.54 ms After last query: 0.04 ms Query memory: 0.029 MB Memory before query: 22.036 MB Rows returned: 9
    Duplicate queries: #59

    SELECT e.id as refid,e.invitee_email,e.invitee_name,e.* , u.id as
    		inviter_id, u.name as inviter_name, u.email as inviter_email,
    		i.message,i.invite_type,i.invite_url,i.invite_type_tag
    						
      FROM qlo7g_invitex_imports_emails AS e
    						
      LEFT JOIN qlo7g_invitex_imports AS i 
      ON e.import_id = i.id
    						
      LEFT JOIN qlo7g_users AS u 
      ON i.inviter_id = u.id
    						
      WHERE i.message_type='email' 
      AND e.unsubscribe=0 
      AND e.sent=1 
      AND e.invitee_id=0  
      AND e.remind=1  
      ORDER BY e.id DESC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	index	NULL	PRIMARY	4	NULL	120	Using where
    1	SIMPLE	i	eq_ref	PRIMARY	PRIMARY	4	planetgiftcards_planet.e.import_id	1	Using where
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	planetgiftcards_planet.i.inviter_id	1

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_invitex/models/invites.php:2058
    10	InvitexModelInvites->send_reminder()	JROOT/components/com_invitex/models/invites.php:1781
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/invitex/invitex.php:301
    8	PlgSystemInvitex->process_email_queue()	JROOT/plugins/system/invitex/invitex.php:252
    7	PlgSystemInvitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

80. Query Time: 0.46 ms After last query: 8.22 ms Query memory: 0.025 MB Memory before query: 29.995 MB Rows returned: 126
    Duplicate queries: #56  #60  #62  #76  #82

    select LOWER(email) 
      from qlo7g_users

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qlo7g_users	index	NULL	email	402	NULL	126	Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/components/com_invitex/models/invites.php:2933
    11	InvitexModelInvites->getRegistered()	JROOT/components/com_invitex/models/invites.php:2089
    10	InvitexModelInvites->send_reminder()	JROOT/components/com_invitex/models/invites.php:1781
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/invitex/invitex.php:301
    8	PlgSystemInvitex->process_email_queue()	JROOT/plugins/system/invitex/invitex.php:252
    7	PlgSystemInvitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

81. Query Time: 1.22 ms After last query: 27.12 ms Query memory: 0.121 MB Memory before query: 22.048 MB Rows returned: 105
    Duplicate queries: #61

    SELECT e.id as refid,e.invitee_email,e.invitee_name,e.* , u.id as
    		inviter_id, u.name as inviter_name, u.email as inviter_email,
    		i.message,i.invite_type,i.invite_url,i.invite_type_tag
    						
      FROM qlo7g_invitex_imports_emails AS e
    						
      LEFT JOIN qlo7g_invitex_imports AS i 
      ON e.import_id = i.id
    						
      LEFT JOIN qlo7g_users AS u 
      ON i.inviter_id = u.id
    						
      WHERE i.message_type='email' 
      AND e.unsubscribe=0 
      AND e.sent=1 
      AND e.invitee_id=0  
      ORDER BY e.id DESC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	e	index	NULL	PRIMARY	4	NULL	120	Using where
    1	SIMPLE	i	eq_ref	PRIMARY	PRIMARY	4	planetgiftcards_planet.e.import_id	1	Using where
    1	SIMPLE	u	eq_ref	PRIMARY	PRIMARY	4	planetgiftcards_planet.i.inviter_id	1

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_invitex/models/invites.php:2058
    10	InvitexModelInvites->send_reminder()	JROOT/components/com_invitex/models/invites.php:1782
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/invitex/invitex.php:301
    8	PlgSystemInvitex->process_email_queue()	JROOT/plugins/system/invitex/invitex.php:252
    7	PlgSystemInvitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

82. Query Time: 0.56 ms After last query: 11.82 ms Query memory: 0.025 MB Memory before query: 30.219 MB Rows returned: 126
    Duplicate queries: #56  #60  #62  #76  #80

    select LOWER(email) 
      from qlo7g_users

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	qlo7g_users	index	NULL	email	402	NULL	126	Using index

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/components/com_invitex/models/invites.php:2933
    11	InvitexModelInvites->getRegistered()	JROOT/components/com_invitex/models/invites.php:2089
    10	InvitexModelInvites->send_reminder()	JROOT/components/com_invitex/models/invites.php:1782
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/invitex/invitex.php:301
    8	PlgSystemInvitex->process_email_queue()	JROOT/plugins/system/invitex/invitex.php:252
    7	PlgSystemInvitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

83. Query Time: 0.56 ms After last query: 28.32 ms Query memory: 0.022 MB Memory before query: 22.060 MB Rows returned: 14
    Duplicate queries: #50  #51  #53  #54  #57  #63  #67  #70  #71  #73  #74  #77  #87

    SELECT namekey,value 
      FROM `qlo7g_invitex_config`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    12	JDatabaseDriver->loadObjectList()	JROOT/components/com_invitex/helper.php:275
    11	CominvitexHelper->getconfigData()	JROOT/components/com_invitex/models/invites.php:2303
    10	InvitexModelInvites->send_friendsEmail()	JROOT/components/com_invitex/models/invites.php:1783
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/invitex/invitex.php:301
    8	PlgSystemInvitex->process_email_queue()	JROOT/plugins/system/invitex/invitex.php:252
    7	PlgSystemInvitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

84. Query Time: 0.36 ms After last query: 0.06 ms Query memory: 0.022 MB Memory before query: 22.066 MB Rows returned: 4
    Duplicate queries: #64

    select distinct LOWER(invitee_email) 
      from qlo7g_invitex_imports_emails 
      where unsubscribe=1

    Explain

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

    Profile

    Status	Duration
    Starting	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.00 ms
    init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.02 ms
    Creating tmp table	0.04 ms
    Executing	0.00 ms
    Sending data	0.08 ms
    Removing tmp table	0.02 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Query end	0.00 ms
    closing tables	0.00 ms
    Unlocking tables	0.00 ms
    closing tables	0.00 ms
    Query end	0.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	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_invitex/models/invites.php:2952
    11	InvitexModelInvites->getBlocked()	JROOT/components/com_invitex/models/invites.php:2306
    10	InvitexModelInvites->send_friendsEmail()	JROOT/components/com_invitex/models/invites.php:1783
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/invitex/invitex.php:301
    8	PlgSystemInvitex->process_email_queue()	JROOT/plugins/system/invitex/invitex.php:252
    7	PlgSystemInvitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

85. Query Time: 0.73 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 22.072 MB Rows returned: 0
    Duplicate queries: #65

    select distinct LOWER(email) 
      from qlo7g_invitex_stored_emails 
      where unsubscribe=1

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    12	JDatabaseDriver->loadColumn()	JROOT/components/com_invitex/models/invites.php:2957
    11	InvitexModelInvites->getBlocked()	JROOT/components/com_invitex/models/invites.php:2306
    10	InvitexModelInvites->send_friendsEmail()	JROOT/components/com_invitex/models/invites.php:1783
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/invitex/invitex.php:301
    8	PlgSystemInvitex->process_email_queue()	JROOT/plugins/system/invitex/invitex.php:252
    7	PlgSystemInvitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

86. Query Time: 0.54 ms After last query: 0.03 ms Query memory: 0.021 MB Memory before query: 22.078 MB Rows returned: 0
    Duplicate queries: #66

    select * 
      from qlo7g_invitex_stored_emails 
      where importedcount >=3 
      and
    		sent_count=0 
      AND email NOT IN ('steve@fscs.ca','solutions@fscs.ca','ali@givebackpromotions.org','admin@oshawalawyers.com') 
      AND email NOT IN(SELECT email 
      from qlo7g_users)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	qlo7g_invitex_stored_emails	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	300	Using where
    2	DEPENDENT SUBQUERY	qlo7g_users	ref	email	email	402	func	1	Using where; Using index; Full scan on NULL key

    Profile

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

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    11	JDatabaseDriver->loadObjectList()	JROOT/components/com_invitex/models/invites.php:2314
    10	InvitexModelInvites->send_friendsEmail()	JROOT/components/com_invitex/models/invites.php:1783
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/invitex/invitex.php:301
    8	PlgSystemInvitex->process_email_queue()	JROOT/plugins/system/invitex/invitex.php:252
    7	PlgSystemInvitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---

87. Query Time: 0.20 ms After last query: 0.02 ms Query memory: 0.023 MB Memory before query: 22.083 MB Rows returned: 14
    Duplicate queries: #50  #51  #53  #54  #57  #63  #67  #70  #71  #73  #74  #77  #83

    SELECT namekey,value 
      FROM `qlo7g_invitex_config`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    13	JDatabaseDriver->loadObjectList()	JROOT/components/com_invitex/helper.php:275
    12	CominvitexHelper->getconfigData()	JROOT/components/com_invitex/helper.php:42
    11	CominvitexHelper->__construct()	JROOT/components/com_invitex/models/invites.php:2316
    10	InvitexModelInvites->send_friendsEmail()	JROOT/components/com_invitex/models/invites.php:1783
    9	InvitexModelInvites->mailto()	JROOT/plugins/system/invitex/invitex.php:301
    8	PlgSystemInvitex->process_email_queue()	JROOT/plugins/system/invitex/invitex.php:252
    7	PlgSystemInvitex->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:51

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

    ---