The Polar Express - Ball Ground

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1713555717,
                "last": 1713555717,
                "now": 1713555717
            },
            "token": "v1i7YUvRgP0St783aaT0zb8t1mqNfLfy"
        },
        "registry": {
            "current_theme": null,
            "current_direction": "ltr",
            "current_key_sufix": "__ltr"
        },
        "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
        },
        "eb_device_type": "desktop"
    }
}

Time

Memory

70 Queries Logged 39.33 ms

1. Query Time: 0.14 ms Query memory: 0.023 MB Memory before query: 3.640 MB Rows returned: 0

   SELECT `data`
   
     FROM `trsst_session`
   
     WHERE `session_id` = X'6532663435353730656536366232306339646664643937313539303934653065'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	trsst_session	const	PRIMARY	PRIMARY	194	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
   Executing	0.01 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	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/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Same as call in the line below.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

2. Query Time: 0.13 ms After last query: 0.63 ms Query memory: 0.020 MB Memory before query: 3.811 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `trsst_session`
   
     WHERE `session_id` = X'6532663435353730656536366232306339646664643937313539303934653065' 
     LIMIT 1

   Explain

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

   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
   Executing	0.00 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	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
   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:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

3. Query Time: 0.12 ms After last query: 0.04 ms Query memory: 0.004 MB Memory before query: 3.816 MB

   INSERT INTO `trsst_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   (X'6532663435353730656536366232306339646664643937313539303934653065', 1, 1713555717, 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `trsst_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'6532663435353730656536366232306339646664643937313539303934653065', 1, 1713555717, 0, '', 0)

   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 for update	0.01 ms
   Update	0.04 ms
   Waiting for query cache lock	0.00 ms
   Update	0.00 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Waiting for query cache lock	0.00 ms
   Unlocking tables	0.01 ms
   Closing tables	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
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
   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:344
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

4. Query Time: 0.37 ms After last query: 1.35 ms Query memory: 0.042 MB Memory before query: 4.052 MB Rows returned: 60

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `trsst_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	trsst_extensions	ref	extension	extension	82	const	56	Using index condition; 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.00 ms
   Init	0.01 ms
   Optimizing	0.01 ms
   Statistics	0.04 ms
   Preparing	0.01 ms
   Executing	0.00 ms
   Sending data	0.19 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	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/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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

5. Query Time: 0.13 ms After last query: 1.14 ms Query memory: 0.021 MB Memory before query: 4.297 MB Rows returned: 5

   SELECT id, rules
   
     FROM `trsst_viewlevels`

   Explain

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

   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.00 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
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	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: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:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php: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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

6. Query Time: 0.17 ms After last query: 0.05 ms Query memory: 0.021 MB Memory before query: 4.309 MB Rows returned: 2

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

   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	4	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.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.02 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	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/libraries/src/Access/Access.php:980
   9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:321
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php: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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Query Time: 1.42 ms After last query: 0.35 ms Query memory: 0.035 MB Memory before query: 4.379 MB Rows returned: 180

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM trsst_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	trsst_extensions	ref	extension	extension	82	const	299	Using index condition; Using where; Using filesort

   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.04 ms
   Preparing	0.01 ms
   Sorting result	0.00 ms
   Executing	0.01 ms
   Sending data	0.00 ms
   Creating sort index	1.20 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	0.00 ms
   Starting cleanup	0.00 ms
   Freeing items	0.00 ms
   Updating status	0.01 ms
   Reset for next command	0.02 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:354
   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:359
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Query Time: 0.26 ms After last query: 7.54 ms Query memory: 0.022 MB Memory before query: 6.018 MB Rows returned: 1

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	trsst_admintools_storage	const	PRIMARY	PRIMARY	402	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.00 ms
   Init	0.01 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.01 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	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
   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:283
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Query Time: 0.15 ms After last query: 1.07 ms Query memory: 0.021 MB Memory before query: 6.227 MB Rows returned: 0

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	trsst_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.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.02 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   Closing tables	0.00 ms
   Unlocking tables	0.00 ms
   Closing tables	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: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:283
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
   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:196
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Query Time: 0.24 ms After last query: 24.20 ms Query memory: 0.023 MB Memory before query: 11.388 MB Rows returned: 1

    SELECT `template`
    
      FROM `trsst_template_styles`
    
      WHERE `client_id` = 0 
      AND `home` = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_template_styles	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	8	Using where

    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.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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:1662
    13	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:1320
    12	AddonParser::getTemplateName()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:206
    11	AddonParser::getAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:1454
    10	require_once JROOT/components/com_sppagebuilder/parser/addon-parser.php	JROOT/components/com_sppagebuilder/builder/classes/addon.php:28
    9	require_once JROOT/components/com_sppagebuilder/builder/classes/addon.php	JROOT/components/com_sppagebuilder/helpers/autoload.php:42
    8	BuilderAutoload::loadClasses()	JROOT/plugins/system/sppagebuilder/sppagebuilder.php:29
    7	require_once JROOT/plugins/system/sppagebuilder/sppagebuilder.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
    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:625
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Query Time: 0.18 ms After last query: 25.72 ms Query memory: 0.022 MB Memory before query: 17.238 MB Rows returned: 0

    SELECT *
    
      FROM `trsst_admintools_ipautoban`
    
      WHERE `ip` = '3.142.196.27'

    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.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.01 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.00 ms
    Executing	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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:1662
    12	JDatabaseDriver->loadObject()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:74
    11	AtsystemFeatureAutoipfiltering->isIPBlocked()	JROOT/plugins/system/admintools/feature/autoipfiltering.php:23
    10	AtsystemFeatureAutoipfiltering->onAfterInitialise()	JROOT/plugins/system/admintools/admintools/main.php: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:626
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Query Time: 0.15 ms After last query: 0.04 ms Query memory: 0.021 MB Memory before query: 17.243 MB Rows returned: 0

    SELECT `ip`
    
      FROM `trsst_admintools_ipblock`

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_admintools_ipblock	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.00 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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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:1550
    12	JDatabaseDriver->loadColumn()	JROOT/plugins/system/admintools/feature/ipblacklist.php:143
    11	AtsystemFeatureIpblacklist->isIPBlocked()	JROOT/plugins/system/admintools/feature/ipblacklist.php:37
    10	AtsystemFeatureIpblacklist->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:626
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Query Time: 0.18 ms After last query: 0.03 ms Query memory: 0.022 MB Memory before query: 17.249 MB Rows returned: 1

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_admintools_storage	range	PRIMARY	PRIMARY	402	NULL	1	Using where

    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.02 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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    13	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/admintools/feature/abstract.php:277
    12	AtsystemFeatureAbstract->loadTimestamps()	JROOT/plugins/system/admintools/feature/abstract.php:356
    11	AtsystemFeatureAbstract->getTimestamp()	JROOT/plugins/system/admintools/feature/disableobsoleteadmins.php:115
    10	AtsystemFeatureDisableobsoleteadmins->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:626
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Query Time: 0.16 ms After last query: 0.22 ms Query memory: 0.021 MB Memory before query: 17.258 MB Rows returned: 0

    SELECT `source`,`keepurlparams`
    
      FROM `trsst_admintools_redirects`
    
      WHERE ((`dest` = 'events/calendar/the-polar-express-ball-ground') OR (`dest` = 'events/calendar/the-polar-express-ball-ground') OR ('events/calendar/the-polar-express-ball-ground' 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	trsst_admintools_redirects	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.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
    Sorting result	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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: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:626
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Query Time: 0.14 ms After last query: 5.37 ms Query memory: 0.023 MB Memory before query: 18.297 MB Rows returned: 33

    SELECT *
    
      FROM trsst_rsform_config

    Explain

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

    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.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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/administrator/components/com_rsform/helpers/config.php:50
    11	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
    10	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:102
    9	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:26
    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:626
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Query Time: 0.98 ms After last query: 1.85 ms Query memory: 0.129 MB Memory before query: 18.641 MB Rows returned: 73

    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 trsst_menu AS m
    
      LEFT JOIN trsst_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	2	Using index condition; Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	flpdev_joom3.m.component_id	1	Using where

    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.03 ms
    Preparing	0.01 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.76 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    21	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
    20	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    19	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    18	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
    17	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    16	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
    15	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
    14	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    13	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
    12	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    11	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
    10	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    9	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/dropfiles/dropfiles.php:37
    8	PlgSystemDropfiles->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:626
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 4.03 ms After last query: 4.32 ms Query memory: 0.022 MB Memory before query: 19.555 MB Rows returned: 0

    SELECT * 
      FROM ( SELECT * 
      FROM trsst_redj_redirects 
      WHERE ( ( (CAST('/events/calendar/the-polar-express-ball-ground' AS BINARY) REGEXP BINARY fromurl)>0 
      AND (case_sensitive<>0) 
      AND (decode_url<>0) 
      AND (request_only<>0) ) OR ( (CAST('/events/calendar/the-polar-express-ball-ground' AS BINARY) REGEXP BINARY fromurl)>0 
      AND (case_sensitive<>0) 
      AND (decode_url=0) 
      AND (request_only<>0) ) OR ( (CAST('https://www.familylifemagazines.com/events/calendar/the-polar-express-ball-ground' AS BINARY) REGEXP BINARY fromurl)>0 
      AND (case_sensitive<>0) 
      AND (decode_url<>0) 
      AND (request_only=0) ) OR ( (CAST('https://www.familylifemagazines.com/events/calendar/the-polar-express-ball-ground' AS BINARY) REGEXP BINARY fromurl)>0 
      AND (case_sensitive<>0) 
      AND (decode_url=0) 
      AND (request_only=0) ) OR ( ('/events/calendar/the-polar-express-ball-ground' REGEXP fromurl)>0 
      AND (case_sensitive=0) 
      AND (decode_url<>0) 
      AND (request_only<>0) ) OR ( ('/events/calendar/the-polar-express-ball-ground' REGEXP fromurl)>0 
      AND (case_sensitive=0) 
      AND (decode_url=0) 
      AND (request_only<>0) ) OR ( ('https://www.familylifemagazines.com/events/calendar/the-polar-express-ball-ground' REGEXP fromurl)>0 
      AND (case_sensitive=0) 
      AND (decode_url<>0) 
      AND (request_only=0) ) OR ( ('https://www.familylifemagazines.com/events/calendar/the-polar-express-ball-ground' REGEXP fromurl)>0 
      AND (case_sensitive=0) 
      AND (decode_url=0) 
      AND (request_only=0) ) ) 
      AND published=1 
      ORDER BY ordering ) AS A 
      WHERE A.skip='' OR ( (CAST('https://www.familylifemagazines.com/events/calendar/the-polar-express-ball-ground' AS BINARY) REGEXP BINARY A.skip)=0 
      AND (case_sensitive<>0) 
      AND (decode_url<>0) ) OR ( (CAST('https://www.familylifemagazines.com/events/calendar/the-polar-express-ball-ground' AS BINARY) REGEXP BINARY A.skip)=0 
      AND (case_sensitive<>0) 
      AND (decode_url=0) ) OR ( ('https://www.familylifemagazines.com/events/calendar/the-polar-express-ball-ground' REGEXP A.skip)=0 
      AND (case_sensitive=0) 
      AND (decode_url<>0) ) OR ( ('https://www.familylifemagazines.com/events/calendar/the-polar-express-ball-ground' REGEXP A.skip)=0 
      AND (case_sensitive=0) 
      AND (decode_url=0) )

    Explain

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

    Profile

    Status	Duration
    Starting	0.08 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.07 ms
    Optimizing	0.04 ms
    Statistics	0.01 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	3.63 ms
    End of update loop	0.02 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Removing tmp table	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.02 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/plugins/system/redj/redj.php:1441
    9	plgSystemReDJ->setRedirect()	JROOT/plugins/system/redj/redj.php:1290
    8	plgSystemReDJ->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:626
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Query Time: 0.27 ms After last query: 10.69 ms Query memory: 0.021 MB Memory before query: 21.536 MB Rows returned: 1

    SELECT `query`
    
      FROM trsst_eb_urls
    
      WHERE md5_key = '86e7ef541e95e1fbf8e00eb1a1e8016e'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using index condition

    Profile

    Status	Duration
    Starting	0.02 ms
    Checking permissions	0.00 ms
    Opening tables	0.04 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.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	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:1740
    10	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:525
    9	EventbookingRouter->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:1074
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Query Time: 0.25 ms After last query: 0.11 ms Query memory: 0.021 MB Memory before query: 21.607 MB Rows returned: 1

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_admintools_wafblacklists	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	Using where; Using temporary; 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.00 ms
    Init	0.02 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Creating tmp table	0.02 ms
    Sorting result	0.00 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Creating sort index	0.01 ms
    Removing tmp table	0.00 ms
    Creating sort index	0.00 ms
    End of update loop	0.00 ms
    Query end	0.02 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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/plugins/system/admintools/feature/wafblacklist.php:92
    10	AtsystemFeatureWafblacklist->onAfterRoute()	JROOT/plugins/system/admintools/admintools/main.php:308
    9	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:154
    8	plgSystemAdmintools->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Query Time: 0.23 ms After last query: 0.32 ms Query memory: 0.021 MB Memory before query: 21.633 MB Rows returned: 4

    SELECT id, home, template, s.params
    
      FROM trsst_template_styles as s
    
      LEFT JOIN trsst_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	e	ref	element_clientid,element_folder_clientid,extension	extension	82	const	3	Using index condition; Using where
    1	SIMPLE	s	ref	idx_template,idx_client_id,idx_client_id_home	idx_template	202	flpdev_joom3.e.element	1	Using index condition; 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.00 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.05 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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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/libraries/src/Application/SiteApplication.php:486
    10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/t3/includes/core/t3.php:353
    9	T3::detect()	JROOT/plugins/system/t3/t3.php:87
    8	plgSystemT3->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1122
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Query Time: 0.25 ms After last query: 1.97 ms Query memory: 0.022 MB Memory before query: 21.912 MB Rows returned: 1

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_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.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.08 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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.02 ms

    Call Stack

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

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

    ---

22. Query Time: 0.21 ms After last query: 0.08 ms Query memory: 0.005 MB Memory before query: 21.903 MB

    UPDATE `trsst_extensions`
    
      SET `params` = '{\"mediaversion\":\"631517004ca3317fb5b0c4e4aea84d54\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

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

    Profile

    Status	Duration
    Starting	0.01 ms
    Checking permissions	0.02 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.07 ms
    Updating	0.03 ms
    End of update loop	0.00 ms
    Waiting for query cache lock	0.00 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Waiting for query cache lock	0.00 ms
    Unlocking tables	0.01 ms
    Closing tables	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/src/Helper/LibraryHelper.php:117
    9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1130
    4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. Query Time: 0.14 ms After last query: 0.95 ms Query memory: 0.019 MB Memory before query: 22.135 MB Rows returned: 1

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_languages	system	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.01 ms
    Statistics	0.01 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.00 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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Query Time: 0.38 ms After last query: 5.41 ms Query memory: 0.057 MB Memory before query: 23.970 MB Rows returned: 284

    SELECT `config_key`,`config_value`
    
      FROM trsst_eb_configs

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    Checking permissions	0.02 ms
    Opening tables	0.03 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.19 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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/administrator/components/com_eventbooking/libraries/rad/config/config.php:42
    11	RADConfig->__construct()	JROOT/components/com_eventbooking/helper/helper.php:872
    10	EventbookingHelper::getConfig()	JROOT/components/com_eventbooking/controller/display.php:21
    9	EventbookingController->loadAssets()	JROOT/components/com_eventbooking/controller/controller.php:31
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Query Time: 0.13 ms After last query: 0.30 ms Query memory: 0.022 MB Memory before query: 24.114 MB Rows returned: 1

    SELECT *
    
      FROM trsst_eb_themes
    
      WHERE published = 1

    Explain

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

    Profile

    Status	Duration
    Starting	0.01 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.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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    11	JDatabaseDriver->loadObject()	JROOT/components/com_eventbooking/helper/helper.php:1114
    10	EventbookingHelper::getDefaultTheme()	JROOT/components/com_eventbooking/controller/display.php:58
    9	EventbookingController->loadAssets()	JROOT/components/com_eventbooking/controller/controller.php:31
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Query Time: 0.65 ms After last query: 4.68 ms Query memory: 0.085 MB Memory before query: 25.074 MB Rows returned: 1

    SELECT a.*,DATEDIFF(event_date, '2024-04-19 15:41:57') AS number_event_dates,TIMESTAMPDIFF(MINUTE, a.late_fee_date, '2024-04-19 15:41:57') AS late_fee_date_diff,TIMESTAMPDIFF(MINUTE, a.event_date, '2024-04-19 15:41:57') AS event_start_minutes,TIMESTAMPDIFF(SECOND, registration_start_date, '2024-04-19 15:41:57') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, cut_off_date, '2024-04-19 15:41:57') AS cut_off_minutes,TIMESTAMPDIFF(MINUTE, '2024-04-19 15:41:57', early_bird_discount_date) AS date_diff,(IFNULL(SUM(b.number_registrants), 0) + a.private_booking_count) AS total_registrants,`c`.`name` AS `location_name`,`c`.`alias` AS `location_alias`,c.address AS location_address, c.lat, c.long,cat.tax_rate AS cat_tax_rate
    
      FROM trsst_eb_events AS a
    
      LEFT JOIN trsst_eb_registrants AS b 
      ON (a.id = b.event_id 
      AND b.group_id=0 
      AND (b.published = 1 OR (b.published = 0 
      AND b.payment_method LIKE "os_offline%")))
    
      LEFT JOIN trsst_eb_locations AS c 
      ON a.location_id = c.id 
    
      LEFT JOIN trsst_eb_categories AS cat 
      ON a.main_category_id = cat.id
    
      WHERE a.id = 5834
    
      GROUP BY a.id

    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	ref	idx_event_id,idx_published,idx_payment_method	idx_event_id	5	const	1	Using where
    1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	cat	eq_ref	PRIMARY	PRIMARY	4	const	1

    Profile

    Status	Duration
    Starting	0.07 ms
    Checking permissions	0.00 ms
    Opening tables	0.11 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Init	0.06 ms
    Optimizing	0.02 ms
    Statistics	0.08 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.04 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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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:1662
    12	JDatabaseDriver->loadObject()	JROOT/components/com_eventbooking/model/event.php:73
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Query Time: 0.44 ms After last query: 3.30 ms Query memory: 0.085 MB Memory before query: 25.917 MB Rows returned: 1

    SELECT a.*, (IFNULL(SUM(b.number_registrants), 0) + a.private_booking_count) AS total_registrants,DATEDIFF(event_date, '2024-04-19 15:41:57') AS number_event_dates,TIMESTAMPDIFF(MINUTE, a.event_date, '2024-04-19 15:41:57') AS event_start_minutes,DATEDIFF('2024-04-19 15:41:57', a.late_fee_date) AS late_fee_date_diff,TIMESTAMPDIFF(SECOND, registration_start_date, '2024-04-19 15:41:57') AS registration_start_minutes,TIMESTAMPDIFF(MINUTE, cut_off_date, '2024-04-19 15:41:57') AS cut_off_minutes,TIMESTAMPDIFF(MINUTE, '2024-04-19 15:41:57', early_bird_discount_date) AS date_diff,l.lat, l.long, l.address AS location_address,`l`.`name` AS `location_name`,c.tax_rate AS cat_tax_rate
    
      FROM trsst_eb_events AS a
    
      LEFT JOIN trsst_eb_categories AS c 
      ON a.main_category_id = c.id
    
      LEFT JOIN trsst_eb_locations AS l 
      ON a.location_id = l.id
    
      LEFT JOIN trsst_eb_registrants AS b 
      ON (a.id = b.event_id 
      AND b.group_id=0 
      AND (b.published = 1 OR (b.published = 0 
      AND b.payment_method LIKE "os_offline%")))
    
      WHERE a.id = 5834
    
      GROUP BY a.id

    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	c	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	l	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	b	ref	idx_event_id,idx_published,idx_payment_method	idx_event_id	5	const	1	Using where

    Profile

    Status	Duration
    Starting	0.06 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.05 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.03 ms
    Executing	0.00 ms
    Sending data	0.07 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    14	JDatabaseDriver->loadObject()	JROOT/components/com_eventbooking/helper/database.php:111
    13	EventbookingHelperDatabase::getEvent()	JROOT/components/com_eventbooking/helper/registration.php:5781
    12	EventbookingHelperRegistration::calculateEventTaxRate()	JROOT/components/com_eventbooking/model/event.php:88
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Query Time: 0.17 ms After last query: 0.04 ms Query memory: 0.024 MB Memory before query: 25.945 MB Rows returned: 0

    SELECT *
    
      FROM trsst_eb_taxes
    
      WHERE published = 1 
      LIMIT 2

    Explain

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

    Profile

    Status	Duration
    Starting	0.01 ms
    Checking permissions	0.00 ms
    Opening tables	0.03 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.01 ms
    End of update loop	0.00 ms
    Query end	0.01 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/components/com_eventbooking/helper/registration.php:5744
    15	EventbookingHelperRegistration::getUniqueTaxRate()	JROOT/components/com_eventbooking/helper/registration.php:5806
    14	EventbookingHelperRegistration::calculateEventTaxRate()	JROOT/components/com_eventbooking/helper/database.php:115
    13	EventbookingHelperDatabase::getEvent()	JROOT/components/com_eventbooking/helper/registration.php:5781
    12	EventbookingHelperRegistration::calculateEventTaxRate()	JROOT/components/com_eventbooking/model/event.php:88
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. Query Time: 0.46 ms After last query: 0.92 ms Query memory: 0.124 MB Memory before query: 26.129 MB Rows returned: 242

    SELECT *
    
      FROM trsst_eb_locations

    Explain

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

    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.02 ms
    Table lock	0.00 ms
    Init	0.01 ms
    Optimizing	0.00 ms
    Statistics	0.00 ms
    Preparing	0.00 ms
    Executing	0.00 ms
    Sending data	0.36 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 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/components/com_eventbooking/helper/data.php:588
    13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:852
    12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:90
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Query Time: 0.19 ms After last query: 0.19 ms Query memory: 0.024 MB Memory before query: 26.548 MB Rows returned: 1

    SELECT a.*, b.event_id
    
      FROM trsst_eb_categories AS a
    
      INNER JOIN trsst_eb_event_categories AS b 
      ON a.id = b.category_id
    
      WHERE b.event_id IN (5834)
    
      ORDER BY b.id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	b	ref	idx_event_id,idx_category_id	idx_event_id	5	const	1	Using where
    1	SIMPLE	a	eq_ref	PRIMARY	PRIMARY	4	flpdev_joom3.b.category_id	1

    Profile

    Status	Duration
    Starting	0.02 ms
    Checking permissions	0.00 ms
    Opening tables	0.03 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
    Sorting result	0.00 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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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/components/com_eventbooking/helper/data.php:615
    13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:852
    12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:90
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Query Time: 0.29 ms After last query: 3.10 ms Query memory: 0.026 MB Memory before query: 27.125 MB Rows returned: 1

    SELECT enabled
    
      FROM `trsst_extensions`
    
      WHERE `element` = 'com_sppagebuilder' 
      AND `type` = 'component'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; 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.00 ms
    Init	0.01 ms
    Optimizing	0.02 ms
    Statistics	0.10 ms
    Preparing	0.02 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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    22	JDatabaseDriver->loadResult()	JROOT/plugins/content/sppagebuilder/sppagebuilder.php:306
    21	PlgContentSppagebuilder->isSppagebuilderEnabled()	JROOT/plugins/content/sppagebuilder/sppagebuilder.php:49
    20	PlgContentSppagebuilder->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:283
    19	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    18	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/cms/html/content.php:39
    17	JHtmlContent::prepare()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:647
    13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:852
    12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:90
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Query Time: 0.21 ms After last query: 3.67 ms Query memory: 0.026 MB Memory before query: 27.892 MB Rows returned: 1
    Duplicate queries: #33  #39  #40  #62  #63  #69  #70

    select `params` 
      from trsst_ijseo_config

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_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.00 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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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
    22	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/ijseo/ijseo.php:1055
    21	plgSystemIjseo->getComponentParams()	JROOT/plugins/system/ijseo/ijseo.php:1064
    20	plgSystemIjseo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    17	JHtmlContent::prepare()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:647
    13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:852
    12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:90
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Query Time: 0.13 ms After last query: 0.03 ms Query memory: 0.027 MB Memory before query: 27.909 MB Rows returned: 1
    Duplicate queries: #32  #39  #40  #62  #63  #69  #70

    select `params` 
      from trsst_ijseo_config

    Explain

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

    Profile

    Status	Duration
    Starting	0.01 ms
    Checking permissions	0.02 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Init	0.00 ms
    Optimizing	0.00 ms
    Statistics	0.00 ms
    Preparing	0.00 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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    22	JDatabaseDriver->loadColumn()	JROOT/plugins/system/ijseo/ijseo.php:1056
    21	plgSystemIjseo->getComponentParams()	JROOT/plugins/system/ijseo/ijseo.php:1064
    20	plgSystemIjseo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    17	JHtmlContent::prepare()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:647
    13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:852
    12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:90
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Query Time: 0.12 ms After last query: 0.04 ms Query memory: 0.025 MB Memory before query: 27.926 MB Rows returned: 1
    Duplicate queries: #35  #41  #42

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.01 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.00 ms
    Statistics	0.00 ms
    Preparing	0.00 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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/ijseo/ijseo.php:1075
    20	plgSystemIjseo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    17	JHtmlContent::prepare()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:647
    13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:852
    12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:90
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. Query Time: 0.08 ms After last query: 0.02 ms Query memory: 0.026 MB Memory before query: 27.936 MB Rows returned: 1
    Duplicate queries: #34  #41  #42

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.01 ms
    Checking permissions	0.00 ms
    Opening tables	0.00 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.00 ms
    Preparing	0.00 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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    21	JDatabaseDriver->loadColumn()	JROOT/plugins/system/ijseo/ijseo.php:1076
    20	plgSystemIjseo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    17	JHtmlContent::prepare()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:647
    13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:852
    12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:90
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. Query Time: 0.14 ms After last query: 0.02 ms Query memory: 0.025 MB Memory before query: 27.946 MB Rows returned: 0
    Duplicate queries: #37  #43  #44

    select * 
      from trsst_ijseo_keys as a 
      where 1<=(SELECT DATEDIFF('2024-04-19 19:41:57',a.checkdate)) OR a.checkdate='0000-00-00 00:00:00' 
      order by checkdate asc 
      limit 0,10

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    Checking permissions	0.00 ms
    Opening tables	0.00 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.01 ms
    Sorting result	0.00 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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
    21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/ijseo/ijseo.php:1085
    20	plgSystemIjseo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    17	JHtmlContent::prepare()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:647
    13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:852
    12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:90
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

37. Query Time: 0.12 ms After last query: 0.01 ms Query memory: 0.026 MB Memory before query: 27.956 MB Rows returned: 0
    Duplicate queries: #36  #43  #44

    select * 
      from trsst_ijseo_keys as a 
      where 1<=(SELECT DATEDIFF('2024-04-19 19:41:57',a.checkdate)) OR a.checkdate='0000-00-00 00:00:00' 
      order by checkdate asc 
      limit 0,10

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    Checking permissions	0.00 ms
    Opening tables	0.00 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
    Sorting result	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    21	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/ijseo/ijseo.php:1089
    20	plgSystemIjseo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    17	JHtmlContent::prepare()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:647
    13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:852
    12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:90
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

38. Query Time: 0.81 ms After last query: 1.37 ms Query memory: 0.033 MB Memory before query: 28.199 MB Rows returned: 60

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `trsst_assets`
    
      WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_baforms','com_banners','com_breezingforms','com_cache','com_categories','com_checkin','com_cjlib','com_communitysurveys','com_config','com_contact','com_contactenhanced','com_content','com_contenthistory','com_cpanel','com_dropfiles','com_droppics','com_easyblog','com_eventbooking','com_fields','com_finder','com_ijoomla_seo','com_installer','com_jaextmanager','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_monthlyarchive','com_mymaplocations','com_newsfeeds','com_osmap','com_plugins','com_postinstall','com_privacy','com_redirect','com_redj','com_rsform','com_search','com_smartslider3','com_sppagebuilder','com_tags','com_templates','com_testimonial_pro','com_users','com_vdata','com_watchfulli','com_weblinks','com_wrapper','com_zoo')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_assets	range	idx_asset_name	idx_asset_name	202	NULL	61	Using index condition

    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.05 ms
    Optimizing	0.01 ms
    Statistics	0.11 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.52 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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
    29	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    28	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    27	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    26	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    25	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    24	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    23	Joomla\CMS\User\User->authorise()	JROOT/plugins/system/sourcerer/src/Params.php:47
    22	RegularLabs\Plugin\System\Sourcerer\Params::get()	JROOT/plugins/system/sourcerer/sourcerer.php:84
    21	PlgSystemSourcerer->handleOnContentPrepare()	JROOT/libraries/regularlabs/src/Plugin.php:157
    20	RegularLabs\Library\Plugin->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    17	JHtmlContent::prepare()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:647
    13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:852
    12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:90
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

39. Query Time: 0.12 ms After last query: 1.32 ms Query memory: 0.026 MB Memory before query: 28.501 MB Rows returned: 1
    Duplicate queries: #32  #33  #40  #62  #63  #69  #70

    select `params` 
      from trsst_ijseo_config

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_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.00 ms
    Optimizing	0.00 ms
    Statistics	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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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/plugins/system/ijseo/ijseo.php:1055
    21	plgSystemIjseo->getComponentParams()	JROOT/plugins/system/ijseo/ijseo.php:1064
    20	plgSystemIjseo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    17	JHtmlContent::prepare()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:651
    13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:852
    12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:90
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

40. Query Time: 0.13 ms After last query: 0.02 ms Query memory: 0.026 MB Memory before query: 28.511 MB Rows returned: 1
    Duplicate queries: #32  #33  #39  #62  #63  #69  #70

    select `params` 
      from trsst_ijseo_config

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_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.00 ms
    Optimizing	0.00 ms
    Statistics	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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    22	JDatabaseDriver->loadColumn()	JROOT/plugins/system/ijseo/ijseo.php:1056
    21	plgSystemIjseo->getComponentParams()	JROOT/plugins/system/ijseo/ijseo.php:1064
    20	plgSystemIjseo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    17	JHtmlContent::prepare()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:651
    13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:852
    12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:90
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

41. Query Time: 0.12 ms After last query: 0.04 ms Query memory: 0.025 MB Memory before query: 28.527 MB Rows returned: 1
    Duplicate queries: #34  #35  #42

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

    Explain

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

    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.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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
    21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/ijseo/ijseo.php:1075
    20	plgSystemIjseo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    17	JHtmlContent::prepare()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:651
    13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:852
    12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:90
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

42. Query Time: 0.14 ms After last query: 0.01 ms Query memory: 0.026 MB Memory before query: 28.536 MB Rows returned: 1
    Duplicate queries: #34  #35  #41

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

    Explain

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

    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.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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:1550
    21	JDatabaseDriver->loadColumn()	JROOT/plugins/system/ijseo/ijseo.php:1076
    20	plgSystemIjseo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    17	JHtmlContent::prepare()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:651
    13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:852
    12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:90
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

43. Query Time: 0.23 ms After last query: 0.02 ms Query memory: 0.025 MB Memory before query: 28.547 MB Rows returned: 0
    Duplicate queries: #36  #37  #44

    select * 
      from trsst_ijseo_keys as a 
      where 1<=(SELECT DATEDIFF('2024-04-19 19:41:57',a.checkdate)) OR a.checkdate='0000-00-00 00:00:00' 
      order by checkdate asc 
      limit 0,10

    Explain

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

    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
    Sorting result	0.02 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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
    21	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/ijseo/ijseo.php:1085
    20	plgSystemIjseo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    17	JHtmlContent::prepare()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:651
    13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:852
    12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:90
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

44. Query Time: 0.19 ms After last query: 0.04 ms Query memory: 0.026 MB Memory before query: 28.556 MB Rows returned: 0
    Duplicate queries: #36  #37  #43

    select * 
      from trsst_ijseo_keys as a 
      where 1<=(SELECT DATEDIFF('2024-04-19 19:41:57',a.checkdate)) OR a.checkdate='0000-00-00 00:00:00' 
      order by checkdate asc 
      limit 0,10

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	26	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.00 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Sorting result	0.00 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.01 ms
    Reset for next command	0.02 ms

    Call Stack

    #	Caller	File and line number
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    21	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/ijseo/ijseo.php:1089
    20	plgSystemIjseo->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    19	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    18	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    17	JHtmlContent::prepare()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
    15	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
    14	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/components/com_eventbooking/helper/data.php:651
    13	EventbookingHelperData::preProcessEventData()	JROOT/components/com_eventbooking/helper/helper.php:852
    12	EventbookingHelper::callOverridableHelperMethod()	JROOT/components/com_eventbooking/model/event.php:90
    11	EventbookingModelEvent->getEventData()	JROOT/components/com_eventbooking/view/event/html.php:186
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

45. Query Time: 18.43 ms After last query: 1.13 ms Query memory: 0.006 MB Memory before query: 28.350 MB

    UPDATE trsst_eb_events
    
      SET hits = hits + 1
    
      WHERE id = 5834

    Explain

    EXPLAIN not possible on query: UPDATE trsst_eb_events SET hits = hits + 1 WHERE id = 5834

    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 for update	0.03 ms
    Updating	0.05 ms
    End of update loop	0.00 ms
    Waiting for query cache lock	0.00 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	18.20 ms
    Closing tables	0.01 ms
    Unlocking tables	0.00 ms
    Closing tables	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/components/com_eventbooking/model/event.php:180
    11	EventbookingModelEvent->updateHits()	JROOT/components/com_eventbooking/view/event/html.php:219
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

46. Query Time: 0.21 ms After last query: 0.46 ms Query memory: 0.022 MB Memory before query: 28.471 MB Rows returned: 0

    SELECT *
    
      FROM trsst_eb_event_group_prices
    
      WHERE event_id = 5834
    
      ORDER BY id

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_eb_event_group_prices	ref	trsst_eb_event_prices_FKIndex1	trsst_eb_event_prices_FKIndex1	5	const	1	Using where

    Profile

    Status	Duration
    Starting	0.02 ms
    Checking permissions	0.00 ms
    Opening tables	0.03 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
    Sorting result	0.00 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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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_eventbooking/helper/database.php:193
    11	EventbookingHelperDatabase::getGroupRegistrationRates()	JROOT/components/com_eventbooking/view/event/html.php:293
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

47. Query Time: 0.14 ms After last query: 0.56 ms Query memory: 0.023 MB Memory before query: 28.541 MB Rows returned: 3

    SELECT id, parent, alias
    
      FROM trsst_eb_categories

    Explain

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

    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.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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/components/com_eventbooking/helper/route.php:636
    13	EventbookingHelperRoute::buildCategories()	JROOT/components/com_eventbooking/helper/route.php:591
    12	EventbookingHelperRoute::getCategoryIdsTree()	JROOT/components/com_eventbooking/helper/route.php:152
    11	EventbookingHelperRoute::getEventRoute()	JROOT/components/com_eventbooking/view/event/html.php:297
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

48. Query Time: 0.15 ms After last query: 0.79 ms Query memory: 0.025 MB Memory before query: 28.678 MB Rows returned: 1

    SELECT id
    
      FROM trsst_eb_urls
    
      WHERE md5_key = '86e7ef541e95e1fbf8e00eb1a1e8016e'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using where; Using index

    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.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
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    18	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:486
    17	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    16	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    15	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    11	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/view/event/html.php:300
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

49. Query Time: 0.15 ms After last query: 1.85 ms Query memory: 0.027 MB Memory before query: 28.939 MB Rows returned: 1

    SELECT id
    
      FROM trsst_eb_urls
    
      WHERE md5_key = '6a55f66fd32160ae1688cb9f24fc7980'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_eb_urls	ref	idx_md5_key	idx_md5_key	99	const	1	Using where; Using index

    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.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
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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
    24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    23	JDatabaseDriver->loadResult()	JROOT/components/com_eventbooking/router.php:486
    22	EventbookingRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    21	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    20	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    19	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    18	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    17	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    16	Joomla\CMS\Router\Route::_()	JROOT/components/com_eventbooking/themes/default/common/event_properties.php:430
    15	include JROOT/components/com_eventbooking/themes/default/common/event_properties.php	JROOT/components/com_eventbooking/helper/html.php:688
    14	EventbookingHelperHtml::loadCommonLayout()	JROOT/components/com_eventbooking/themes/default/event/default.php:184
    13	include JROOT/components/com_eventbooking/themes/default/event/default.php	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:271
    12	RADViewHtml->render()	JROOT/administrator/components/com_eventbooking/libraries/rad/view/html.php:156
    11	RADViewHtml->display()	JROOT/components/com_eventbooking/view/event/html.php:308
    10	EventbookingViewEventHtml->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:335
    9	RADController->display()	JROOT/components/com_eventbooking/controller/controller.php:74
    8	EventbookingController->display()	JROOT/administrator/components/com_eventbooking/libraries/rad/controller/controller.php:285
    7	RADController->execute()	JROOT/components/com_eventbooking/eventbooking.php:40
    6	require_once JROOT/components/com_eventbooking/eventbooking.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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

50. Query Time: 0.44 ms After last query: 0.71 ms Query memory: 0.020 MB Memory before query: 28.797 MB Rows returned: 0
    Duplicate queries: #51

    select `menutype` 
      from trsst_menu 
      where  1=1  
      and link like '%option=com_eventbooking%' 
      and link like '%view=event%' 
      and link like '%id=5834%' 
      and `published`=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_menu	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	280	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.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.26 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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/plugins/system/ijseo/ijseo.php:231
    9	plgSystemIjseo->isMenu()	JROOT/plugins/system/ijseo/ijseo.php:164
    8	plgSystemIjseo->getMetaValues()	JROOT/plugins/system/ijseo/ijseo.php:72
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

51. Query Time: 0.36 ms After last query: 0.02 ms Query memory: 0.021 MB Memory before query: 28.802 MB Rows returned: 0
    Duplicate queries: #50

    select `menutype` 
      from trsst_menu 
      where  1=1  
      and link like '%option=com_eventbooking%' 
      and link like '%view=event%' 
      and link like '%id=5834%' 
      and `published`=1

    Explain

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

    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.24 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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:232
    9	plgSystemIjseo->isMenu()	JROOT/plugins/system/ijseo/ijseo.php:164
    8	plgSystemIjseo->getMetaValues()	JROOT/plugins/system/ijseo/ijseo.php:72
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

52. Query Time: 0.09 ms After last query: 0.04 ms Query memory: 0.020 MB Memory before query: 28.807 MB Rows returned: 0
    Duplicate queries: #53

    select * 
      from trsst_ijseo_meta_pages 
      where `link`='https://www.familylifemagazines.com/events/calendar/the-polar-express-ball-ground'

    Explain

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

    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.00 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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    8	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/ijseo/ijseo.php:86
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

53. Query Time: 0.15 ms After last query: 0.01 ms Query memory: 0.020 MB Memory before query: 28.811 MB Rows returned: 0
    Duplicate queries: #52

    select * 
      from trsst_ijseo_meta_pages 
      where `link`='https://www.familylifemagazines.com/events/calendar/the-polar-express-ball-ground'

    Explain

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

    Profile

    Status	Duration
    Starting	0.01 ms
    Checking permissions	0.00 ms
    Opening tables	0.00 ms
    After opening tables	0.03 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.02 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    8	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/ijseo/ijseo.php:87
    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:196
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

54. Query Time: 0.71 ms After last query: 11.15 ms Query memory: 0.028 MB Memory before query: 31.019 MB Rows returned: 17

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM trsst_modules AS m
    
      LEFT JOIN trsst_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN trsst_extensions AS e 
      ON e.element = m.module 
      AND e.client_id = m.client_id
    
      WHERE m.published = 1 
      AND e.enabled = 1 
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2024-04-19 19:41:57') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2024-04-19 19:41:57') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 829 OR mm.menuid <= 0)
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	45	Using index condition; Using where; Using filesort
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	flpdev_joom3.m.module,const	1	Using index condition; Using where
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	flpdev_joom3.m.id	3	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.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	0.43 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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:1701
    19	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    18	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    17	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:432
    16	Joomla\CMS\Helper\_ModuleHelper::getModuleList()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:362
    15	Joomla\CMS\Helper\_ModuleHelper::load()	JROOT/plugins/system/t3/includes/core/t3.php(533) : eval()'d code:87
    14	Joomla\CMS\Helper\_ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
    13	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/plugins/system/t3/includes/core/template.php:643
    12	T3Template->countModules()	JROOT/templates/t3_bs3_blank/tpls/blocks/header.php:22
    11	include JROOT/templates/t3_bs3_blank/tpls/blocks/header.php	JROOT/plugins/system/t3/includes/core/template.php:202
    10	T3Template->loadBlock()	JROOT/templates/t3_bs3_blank/tpls/default-content-left.php:31
    9	include JROOT/templates/t3_bs3_blank/tpls/default-content-left.php	JROOT/plugins/system/t3/includes/core/template.php:228
    8	T3Template->loadLayout()	JROOT/templates/t3_bs3_blank/index.php:34
    7	require JROOT/templates/t3_bs3_blank/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

55. Query Time: 0.19 ms After last query: 4.79 ms Query memory: 0.089 MB Memory before query: 31.575 MB Rows returned: 1

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_easyblog_configs	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	3	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.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.05 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    24	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
    23	Joomla\CMS\Table\Table->load()	JROOT/administrator/components/com_easyblog/includes/easyblog.php:536
    22	EB::config()	JROOT/components/com_easyblog/router.php:36
    21	EasyBlogRouterBase::buildRoute()	JROOT/components/com_easyblog/router.php:1368
    20	EasyBlogBuildRoute()	JROOT/libraries/src/Component/Router/RouterLegacy.php:69
    19	Joomla\CMS\Component\Router\RouterLegacy->build()	JROOT/libraries/src/Router/SiteRouter.php:532
    18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
    17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
    16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
    15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
    14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
    13	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_menu/helper.php:139
    12	ModMenuHelper::getList()	JROOT/modules/mod_menu/mod_menu.php:15
    11	include JROOT/modules/mod_menu/mod_menu.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

56. Query Time: 0.48 ms After last query: 4.97 ms Query memory: 0.023 MB Memory before query: 31.831 MB Rows returned: 9

    SELECT `name`,`element`
    
      FROM `trsst_extensions`
    
      WHERE `type` = 'plugin' 
      AND `folder` = 'finder' 
      AND `enabled` = 1

    Explain

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

    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.01 ms
    Optimizing	0.01 ms
    Statistics	0.06 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.21 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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/administrator/components/com_finder/helpers/language.php:126
    12	FinderHelperLanguage::loadPluginLanguage()	JROOT/modules/mod_finder/mod_finder.php:51
    11	include JROOT/modules/mod_finder/mod_finder.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

57. Query Time: 0.19 ms After last query: 1.73 ms Query memory: 0.024 MB Memory before query: 32.069 MB Rows returned: 10

    SELECT `title`
    
      FROM `trsst_finder_taxonomy`
    
      WHERE `parent_id` = 1 
      AND `state` = 1 
      AND `access` IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_finder_taxonomy	ref	parent_id,state,access,idx_parent_published	parent_id	4	const	8	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.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.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    16	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_finder/helpers/indexer/taxonomy.php:258
    15	FinderIndexerTaxonomy::getBranchTitles()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:750
    14	FinderIndexerQuery->processString()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:236
    13	FinderIndexerQuery->__construct()	JROOT/modules/mod_finder/helper.php:84
    12	ModFinderHelper::getQuery()	JROOT/modules/mod_finder/mod_finder.php:54
    11	include JROOT/modules/mod_finder/mod_finder.php	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:256
    10	Joomla\CMS\Helper\ModuleHelper::renderRawModule()	JROOT/plugins/system/t3/includes/joomla4/ModuleHelper.php:65
    9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
    7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

58. Query Time: 0.15 ms After last query: 2.20 ms Query memory: 0.022 MB Memory before query: 32.280 MB Rows returned: 1

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params
    
      FROM trsst_modules AS m
    
      WHERE m.id = 207 
      AND m.published = 1 
      AND m.access IN (1,1,5)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	m	const	PRIMARY,published	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.00 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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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:1662
    13	JDatabaseDriver->loadObject()	JROOT/plugins/system/t3/includes/menu/megamenu.php:330
    12	T3MenuMegamenu->module()	JROOT/plugins/system/t3/includes/menu/megamenu.php:302
    11	T3MenuMegamenu->mega()	JROOT/plugins/system/t3/includes/menu/megamenu.php:257
    10	T3MenuMegamenu->item()	JROOT/plugins/system/t3/includes/menu/megamenu.php:232
    9	T3MenuMegamenu->nav()	JROOT/plugins/system/t3/includes/menu/megamenu.php:185
    8	T3MenuMegamenu->render()	JROOT/plugins/system/t3/includes/renderer/megamenurender.php:88
    7	JDocumentRendererMegamenuRender->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

59. Query Time: 0.19 ms After last query: 0.86 ms Query memory: 0.022 MB Memory before query: 32.330 MB Rows returned: 0
    Duplicate queries: #60

    select c.`canonical` 
      from trsst_ijseo_canonical c 
      where c.`id` = (select `parent_id` 
      from trsst_ijseo_canonical 
      where `link`='https://www.familylifemagazines.com/events/calendar/the-polar-express-ball-ground' 
      and `parent_id` <> 0 
      limit 0,1) 
      and c.`state`=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    2	SUBQUERY	trsst_ijseo_canonical	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.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
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Statistics	0.00 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    Preparing	0.00 ms
    Executing	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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/plugins/system/ijseo/ijseo.php:1917
    13	plgSystemIjseo->generateCanonicalURL()	JROOT/plugins/system/ijseo/ijseo.php:1986
    12	plgSystemIjseo->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:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

60. Query Time: 0.20 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 32.337 MB Rows returned: 0
    Duplicate queries: #59

    select c.`canonical` 
      from trsst_ijseo_canonical c 
      where c.`id` = (select `parent_id` 
      from trsst_ijseo_canonical 
      where `link`='https://www.familylifemagazines.com/events/calendar/the-polar-express-ball-ground' 
      and `parent_id` <> 0 
      limit 0,1) 
      and c.`state`=1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	PRIMARY	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables
    2	SUBQUERY	trsst_ijseo_canonical	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where

    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.01 ms
    Optimizing	0.00 ms
    Optimizing	0.01 ms
    Statistics	0.01 ms
    Preparing	0.01 ms
    Statistics	0.00 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Preparing	0.00 ms
    Executing	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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:1550
    14	JDatabaseDriver->loadColumn()	JROOT/plugins/system/ijseo/ijseo.php:1918
    13	plgSystemIjseo->generateCanonicalURL()	JROOT/plugins/system/ijseo/ijseo.php:1986
    12	plgSystemIjseo->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:501
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

61. Query Time: 0.14 ms After last query: 0.55 ms Query memory: 0.021 MB Memory before query: 32.408 MB Rows returned: 1

    SELECT `value`
    
      FROM `trsst_admintools_storage`
    
      WHERE `key` = 'criticalfiles'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_admintools_storage	const	PRIMARY	PRIMARY	402	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.00 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.00 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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:1740
    11	JDatabaseDriver->loadResult()	JROOT/plugins/system/admintools/feature/criticalfiles.php:204
    10	AtsystemFeatureCriticalfiles->load()	JROOT/plugins/system/admintools/feature/criticalfiles.php:32
    9	AtsystemFeatureCriticalfiles->onAfterRender()	JROOT/plugins/system/admintools/admintools/main.php:308
    8	plgSystemAdmintools->runFeature()	JROOT/plugins/system/admintools/admintools/main.php:187
    7	plgSystemAdmintools->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:1050
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

62. Query Time: 0.12 ms After last query: 1.02 ms Query memory: 0.020 MB Memory before query: 32.489 MB Rows returned: 1
    Duplicate queries: #32  #33  #39  #40  #63  #69  #70

    select `params` 
      from trsst_ijseo_config

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_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.00 ms
    Optimizing	0.00 ms
    Statistics	0.00 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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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/plugins/system/ijseo/ijseo.php:36
    9	plgSystemIjseo->getParams()	JROOT/plugins/system/ijseo/ijseo.php:1820
    8	plgSystemIjseo->titleplg()	JROOT/plugins/system/ijseo/ijseo.php:1595
    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:1050
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

63. Query Time: 0.16 ms After last query: 0.01 ms Query memory: 0.021 MB Memory before query: 32.494 MB Rows returned: 1
    Duplicate queries: #32  #33  #39  #40  #62  #69  #70

    select `params` 
      from trsst_ijseo_config

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_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.02 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    Table lock	0.00 ms
    Init	0.00 ms
    Optimizing	0.00 ms
    Statistics	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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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:37
    9	plgSystemIjseo->getParams()	JROOT/plugins/system/ijseo/ijseo.php:1820
    8	plgSystemIjseo->titleplg()	JROOT/plugins/system/ijseo/ijseo.php:1595
    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:1050
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

64. Query Time: 0.21 ms After last query: 1.65 ms Query memory: 0.021 MB Memory before query: 32.688 MB Rows returned: 1

    SELECT manifest_cache
    
      FROM trsst_extensions
    
      WHERE type='component' 
      AND element='com_baforms'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	Using index condition; 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.00 ms
    Init	0.01 ms
    Optimizing	0.01 ms
    Statistics	0.07 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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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:1740
    10	JDatabaseDriver->loadResult()	JROOT/components/com_baforms/helpers/baforms.php:560
    9	baformsHelper::aboutUs()	JROOT/components/com_baforms/helpers/baforms.php:458
    8	baformsHelper::prepareHelper()	JROOT/plugins/system/baforms/baforms.php:39
    7	plgSystemBaforms->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:1050
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

65. Query Time: 0.14 ms After last query: 0.12 ms Query memory: 0.026 MB Memory before query: 32.704 MB Rows returned: 1

    SELECT `key`
    
      FROM trsst_baforms_api
    
      WHERE service = 'balbooa_activation'

    Explain

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

    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.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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:1740
    10	JDatabaseDriver->loadResult()	JROOT/components/com_baforms/helpers/baforms.php:545
    9	baformsHelper::checkFormsActivation()	JROOT/components/com_baforms/helpers/baforms.php:459
    8	baformsHelper::prepareHelper()	JROOT/plugins/system/baforms/baforms.php:39
    7	plgSystemBaforms->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:1050
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

66. Query Time: 0.12 ms After last query: 0.48 ms Query memory: 0.020 MB Memory before query: 32.730 MB Rows returned: 1

    SELECT params 
      FROM `trsst_ijseo_config`

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_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.00 ms
    Optimizing	0.00 ms
    Statistics	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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	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
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
    8	JDatabaseDriver->loadColumn()	JROOT/plugins/content/ijseo_plugin/ijseo_plugin.php:1288
    7	plgContentIjseo_plugin->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:1050
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

67. Query Time: 0.20 ms After last query: 0.13 ms Query memory: 0.020 MB Memory before query: 32.797 MB Rows returned: 0
    Duplicate queries: #68

    SELECT i.*
                
      FROM trsst_ijseo_ilinks AS i
                
      LEFT JOIN trsst_ijseo_ilinks_articles AS ia 
      ON i.id = ia.ilink_id
                
      WHERE ( i.published =1 
      AND ia.article_id = '5834'  
      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	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)

    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.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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.02 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
    8	JDatabaseDriverMysqli->execute()	JROOT/plugins/content/ijseo_plugin/ijseo_plugin.php:1328
    7	plgContentIjseo_plugin->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:1050
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

68. Query Time: 0.16 ms After last query: 0.01 ms Query memory: 0.020 MB Memory before query: 32.801 MB Rows returned: 0
    Duplicate queries: #67

    SELECT i.*
                
      FROM trsst_ijseo_ilinks AS i
                
      LEFT JOIN trsst_ijseo_ilinks_articles AS ia 
      ON i.id = ia.ilink_id
                
      WHERE ( i.published =1 
      AND ia.article_id = '5834'  
      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	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)

    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.02 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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    8	JDatabaseDriver->loadAssocList()	JROOT/plugins/content/ijseo_plugin/ijseo_plugin.php:1329
    7	plgContentIjseo_plugin->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:1050
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

69. Query Time: 0.15 ms After last query: 0.03 ms Query memory: 0.020 MB Memory before query: 32.806 MB Rows returned: 1
    Duplicate queries: #32  #33  #39  #40  #62  #63  #70

    select `params` 
      from trsst_ijseo_config

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_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.00 ms
    Optimizing	0.00 ms
    Statistics	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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/plugins/content/ijseo_plugin/ijseo_plugin.php:32
    9	plgContentIjseo_plugin->getParams()	JROOT/plugins/content/ijseo_plugin/ijseo_plugin.php:1520
    8	plgContentIjseo_plugin->titleplg()	JROOT/plugins/content/ijseo_plugin/ijseo_plugin.php:1516
    7	plgContentIjseo_plugin->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:1050
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

70. Query Time: 0.15 ms After last query: 0.02 ms Query memory: 0.021 MB Memory before query: 32.810 MB Rows returned: 1
    Duplicate queries: #32  #33  #39  #40  #62  #63  #69

    select `params` 
      from trsst_ijseo_config

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	trsst_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.00 ms
    Optimizing	0.00 ms
    Statistics	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
    Closing tables	0.00 ms
    Unlocking tables	0.00 ms
    Closing tables	0.00 ms
    Starting cleanup	0.00 ms
    Freeing items	0.00 ms
    Updating status	0.00 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/content/ijseo_plugin/ijseo_plugin.php:33
    9	plgContentIjseo_plugin->getParams()	JROOT/plugins/content/ijseo_plugin/ijseo_plugin.php:1520
    8	plgContentIjseo_plugin->titleplg()	JROOT/plugins/content/ijseo_plugin/ijseo_plugin.php:1516
    7	plgContentIjseo_plugin->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:1050
    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:202
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---