{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1738007116,
                "last": 1738007116,
                "now": 1738007116
            },
            "token": "YHhBulgSn7abSxuz0IFiRP6UxZnHGCPF"
        },
        "registry": {
            "plg_system_eprivacygeoip_cache": {
                "cc": "US",
                "abbr": "USA",
                "name": "United States"
            }
        },
        "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
        }
    },
    "__com_easysocial": {
        "easysocial": {
            "before_registration": "L2ZvcnVtcy9kZXNpZ24tY2hhbGxhbmdlcy1jaGFycmV0dGVzLXRoZW1lZC1jaGFsbGVuZ2VzLzM0NzQtY2hhcmV0dGUtMTUtcXVpbnRhLWhvdXNlLmh0bWw="
        }
    }
}

Time

Memory

68 Queries Logged 22.47 ms

1. Query Time: 0.23 ms Query memory: 0.022 MB Memory before query: 0.771 MB Rows returned: 0

   SELECT `data`
   
     FROM `jom3_session`
   
     WHERE `session_id` = X'3634676d66396b6171746c633337646639686b30763773333338'

   Explain

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

   Profile

   Status	Duration
   Starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.02 ms
   After opening tables	0.00 ms
   System lock	0.00 ms
   table lock	0.00 ms
   init	0.02 ms
   Optimizing	0.01 ms
   Statistics	0.05 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.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
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
   15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
   14	JSessionStorageDatabase->read()	Same as call in the line below.
   13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
   12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
   11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
   10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:661
   9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:621
   8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:499
   7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:456
   6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:826
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

2. Query Time: 0.06 ms After last query: 0.12 ms Query memory: 0.020 MB Memory before query: 0.782 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `jom3_session`
   
     WHERE `session_id` = X'3634676d66396b6171746c633337646639686b30763773333338' 
     LIMIT 1

   Explain

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

   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.00 ms
   Optimizing	0.00 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.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:1740
   8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

3. Query Time: 0.47 ms After last query: 0.03 ms Query memory: 0.003 MB Memory before query: 0.786 MB

   INSERT INTO `jom3_session`
   (`session_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   (X'3634676d66396b6171746c633337646639686b30763773333338', 1, 1738007116, 0, '')

   Explain

   EXPLAIN not possible on query: INSERT INTO `jom3_session` (`session_id`,`guest`,`time`,`userid`,`username`) VALUES (X'3634676d66396b6171746c633337646639686b30763773333338', 1, 1738007116, 0, '')

   Profile

   Status	Duration
   Starting	0.05 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 for update	0.01 ms
   Update	0.07 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.27 ms
   Writing to binlog	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
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
   7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
   6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:828
   5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
   4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
   3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:386
   2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
   1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

   ---

4. Query Time: 0.37 ms After last query: 0.20 ms Query memory: 0.037 MB Memory before query: 0.815 MB Rows returned: 47

   SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
   
     FROM `jom3_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	jom3_extensions	ref	extension	extension	82	const	47	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.02 ms
   Optimizing	0.02 ms
   Statistics	0.04 ms
   Preparing	0.02 ms
   Executing	0.00 ms
   Sending data	0.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.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:1701
   11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
   10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Same as call in the line below.
   9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
   7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
   6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
   5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
   4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

5. Query Time: 0.07 ms After last query: 0.16 ms Query memory: 0.020 MB Memory before query: 0.836 MB Rows returned: 5

   SELECT id, rules
   
     FROM `jom3_viewlevels`

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	jom3_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.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
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
   8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
   7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

6. Query Time: 0.13 ms After last query: 0.03 ms Query memory: 0.020 MB Memory before query: 0.846 MB Rows returned: 2

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

   Explain

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

   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.00 ms
   Unlocking tables	0.00 ms
   Preparing	0.01 ms
   Executing	0.00 ms
   Sending data	0.01 ms
   End of update loop	0.00 ms
   Query end	0.00 ms
   Commit	0.00 ms
   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:318
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

7. Query Time: 0.31 ms After last query: 0.04 ms Query memory: 0.022 MB Memory before query: 0.867 MB Rows returned: 126

   SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
   
     FROM jom3_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	jom3_extensions	ALL	extension	NO INDEX KEY COULD BE USED	NULL	NULL	390	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.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.00 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
   10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:351
   9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Same as call in the line below.
   8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
   7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:356
   6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
   5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
   4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

8. Query Time: 0.13 ms After last query: 3.12 ms Query memory: 0.061 MB Memory before query: 1.943 MB Rows returned: 1

   SELECT * 
     FROM `jom3_social_config` 
     WHERE `type` = 'site'

   Explain

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

   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.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.00 ms
   Reset for next command	0.00 ms

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
   15	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:46
   14	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
   13	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/config.php:43
   12	EasySocialModelConfig->getConfig()	JROOT/administrator/components/com_easysocial/includes/config/config.php:103
   11	SocialConfig->load()	JROOT/administrator/components/com_easysocial/includes/config/config.php:25
   10	SocialConfig->__construct()	JROOT/administrator/components/com_easysocial/includes/config/config.php:40
   9	SocialConfig::getInstance()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:503
   8	ES::config()	JROOT/administrator/components/com_easysocial/includes/plugins.php:37
   7	EasySocialPlugins->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

9. Query Time: 0.10 ms After last query: 1.46 ms Query memory: 0.022 MB Memory before query: 2.065 MB Rows returned: 1
   Duplicate queries: #10

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

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
   1	SIMPLE	s	ALL	idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	13	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.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.00 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/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
   12	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:105
   11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
   10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
   9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
   8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
   7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
   6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
   5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
   4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
   3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
   2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
   1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

   ---

10. Query Time: 0.05 ms After last query: 0.02 ms Query memory: 0.022 MB Memory before query: 2.072 MB Rows returned: 1
    Duplicate queries: #9

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	13	Using where

    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.00 ms
    Optimizing	0.00 ms
    Statistics	0.01 ms
    Preparing	0.00 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.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:1740
    14	JDatabaseDriver->loadResult()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:31
    13	RokCommon_PlatformInfo_Joomla->getDefaultTemplate()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:67
    12	RokCommon_PlatformInfo_Joomla->getDefaultTemplatePath()	JROOT/libraries/rokcommon/RokCommon/PlatformInfo/Joomla.php:106
    11	RokCommon_PlatformInfo_Joomla->setPlatformParameters()	JROOT/libraries/rokcommon/RokCommon/Service.php:71
    10	RokCommon_Service::getContainer()	JROOT/libraries/rokcommon/include.php:38
    9	require_once JROOT/libraries/rokcommon/include.php	JROOT/plugins/system/rokcommon/rokcommon.php:95
    8	plgSystemRokCommon->loadCommonLib()	JROOT/plugins/system/rokcommon/rokcommon.php:53
    7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

11. Query Time: 0.08 ms After last query: 0.38 ms Query memory: 0.020 MB Memory before query: 2.171 MB Rows returned: 2

    SELECT extension, file, type
    
      FROM jom3_rokcommon_configs
    
      ORDER BY priority

    Explain

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

    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.00 ms
    Optimizing	0.00 ms
    Statistics	0.00 ms
    Preparing	0.00 ms
    Sorting result	0.00 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	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/libraries/joomla/database/driver.php:1701
    9	JDatabaseDriver->loadObjectList()	JROOT/plugins/system/rokcommon/rokcommon.php:131
    8	plgSystemRokCommon->processRegisteredConfigs()	JROOT/plugins/system/rokcommon/rokcommon.php:75
    7	plgSystemRokCommon->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

12. Query Time: 0.39 ms After last query: 2.30 ms Query memory: 0.076 MB Memory before query: 2.405 MB Rows returned: 51

    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 jom3_menu AS m
    
      LEFT JOIN jom3_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	53	Using index condition; Using where; Using filesort
    1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	3dallusions_joomla_d9.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.01 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    Creating sort index	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
    32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    31	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
    30	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Same as call in the line below.
    29	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    28	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
    27	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:78
    26	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
    25	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:142
    24	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:417
    23	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
    22	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:65
    21	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
    20	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:533
    19	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
    18	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/platform/joomla/platform.php:124
    17	Weeblr\Wblib\Forai\Platform\JoomlaPlatform->getRouter()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/platform/joomla/platform.php:104
    16	Weeblr\Wblib\Forai\Platform\JoomlaPlatform->boot()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/factory.php:396
    15	Weeblr\Wblib\Forai\Factory->buildPlatform()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/factory.php:281
    14	Weeblr\Wblib\Forai\Factory->buildObject()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/factory.php:228
    13	Weeblr\Wblib\Forai\Factory->getObject()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/factory.php:116
    12	Weeblr\Wblib\Forai\Factory->getThe()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/system/hook.php:171
    11	Weeblr\Wblib\Forai\System\Hook->execute()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/system/hook.php:151
    10	Weeblr\Wblib\Forai\System\Hook->filter()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/wblib.php:134
    9	Weeblr\Wblib\Forai\Wblib->boot()	JROOT/plugins/system/forai/boot.php:41
    8	include_once JROOT/plugins/system/forai/boot.php	JROOT/plugins/system/forai/forai.php:70
    7	plgSystemForai->__construct()	JROOT/libraries/src/Plugin/PluginHelper.php:280
    6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
    5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:667
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

13. Query Time: 0.13 ms After last query: 1.07 ms Query memory: 0.024 MB Memory before query: 2.642 MB Rows returned: 1

    SELECT id,template 
      FROM jom3_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	jom3_template_styles	ALL	idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	13	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.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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_widgetkit/widgetkit.php:28
    16	plgSystemWidgetkit->{closure}()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Container.php:246
    15	YOOtheme\Framework\Container->offsetGet()	JROOT/administrator/components/com_widgetkit/src/Application.php:49
    14	YOOtheme\Widgetkit\Application->YOOtheme\Widgetkit\{closure}()	Same as call in the line below.
    13	call_user_func_array()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Event/EventDispatcher.php:116
    12	YOOtheme\Framework\Event\EventDispatcher->trigger()	JROOT/administrator/components/com_widgetkit/vendor/yootheme/framework/src/Application.php:149
    11	YOOtheme\Framework\Application->boot()	JROOT/administrator/components/com_widgetkit/widgetkit.php:113
    10	include JROOT/administrator/components/com_widgetkit/widgetkit.php	JROOT/administrator/components/com_widgetkit/widgetkit-app.php:8
    9	include JROOT/administrator/components/com_widgetkit/widgetkit-app.php	JROOT/plugins/system/widgetkit/widgetkit.php:16
    8	plgSystemWidgetkit->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

14. Query Time: 0.31 ms After last query: 0.38 ms Query memory: 0.022 MB Memory before query: 2.666 MB Rows returned: 18

    SHOW FULL COLUMNS 
      FROM `jom3_extensions`

    Explain

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

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.00 ms
    closing tables	0.00 ms
    Opening tables	0.13 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
    Filling schema table	0.00 ms
    Opening tables	0.00 ms
    After opening tables	0.00 ms
    checking permissions	0.05 ms
    closing tables	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
    Removing tmp table	0.04 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/libraries/joomla/database/driver/mysqli.php:448
    13	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    12	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    11	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
    10	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:328
    9	Joomla\CMS\Table\Table::getInstance()	JROOT/plugins/system/roksprocket/roksprocket.php:45
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

15. Query Time: 0.09 ms After last query: 0.04 ms Query memory: 0.020 MB Memory before query: 2.693 MB Rows returned: 1

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

    Explain

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

    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.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    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/libraries/src/Table/Extension.php:124
    9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:46
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

16. Query Time: 0.07 ms After last query: 0.02 ms Query memory: 0.020 MB Memory before query: 2.698 MB Rows returned: 1
    Duplicate queries: #18

    SELECT *
    
      FROM jom3_extensions
    
      WHERE `extension_id` = '10269'

    Explain

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

    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.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.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:1465
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:54
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 0.06 ms After last query: 0.02 ms Query memory: 0.021 MB Memory before query: 2.704 MB Rows returned: 1

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

    Explain

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

    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.00 ms
    Optimizing	0.00 ms
    Statistics	0.01 ms
    Preparing	0.00 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.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:1740
    10	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
    9	Joomla\CMS\Table\Extension->find()	JROOT/plugins/system/roksprocket/roksprocket.php:69
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

18. Query Time: 0.06 ms After last query: 0.01 ms Query memory: 0.020 MB Memory before query: 2.709 MB Rows returned: 1
    Duplicate queries: #16

    SELECT *
    
      FROM jom3_extensions
    
      WHERE `extension_id` = '10269'

    Explain

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

    Profile

    Status	Duration
    Starting	0.00 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.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.00 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.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:1465
    10	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    9	Joomla\CMS\Table\Table->load()	JROOT/plugins/system/roksprocket/roksprocket.php:76
    8	plgSystemRokSprocket->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

19. Query Time: 0.14 ms After last query: 3.08 ms Query memory: 0.025 MB Memory before query: 2.901 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    Starting	0.02 ms
    checking permissions	0.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
    22	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    21	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
    20	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/platform/joomla/platform.php:1196
    19	Weeblr\Wblib\Forai\Platform\JoomlaPlatform->getLanguageDirection()	JROOT/plugins/system/forai/vendor/weeblr/forai/controller/assistant.php:86
    18	Weeblr\Forai\Controller\Assistant->__construct()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/factory.php:322
    17	Weeblr\Wblib\Forai\Factory->buildObject()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/factory.php:221
    16	Weeblr\Wblib\Forai\Factory->getObject()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/factory.php:103
    15	Weeblr\Wblib\Forai\Factory->getA()	JROOT/plugins/system/forai/vendor/weeblr/forai/hooks.php:70
    14	Weeblr\Forai\Hooks->add()	JROOT/plugins/system/forai/vendor/weeblr/forai/forai.php:83
    13	Weeblr\Forai\ForaiApp->__construct()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/factory.php:427
    12	Weeblr\Wblib\Forai\Factory->buildApp()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/factory.php:301
    11	Weeblr\Wblib\Forai\Factory->buildObject()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/factory.php:244
    10	Weeblr\Wblib\Forai\Factory->getObject()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/factory.php:130
    9	Weeblr\Wblib\Forai\Factory->getThis()	JROOT/plugins/system/forai/forai.php:96
    8	plgSystemForai->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:668
    4	Joomla\CMS\Application\CMSApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:686
    3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

20. Query Time: 0.24 ms After last query: 2.16 ms Query memory: 0.022 MB Memory before query: 3.118 MB Rows returned: 11

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	NO INDEX KEY COULD BE USED	NULL	NULL	13	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	3dallusions_joomla_d9.s.template,const	1	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.02 ms
    Optimizing	0.01 ms
    Statistics	0.04 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
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
    14	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/templates/yootheme/packages/theme-joomla/src/ThemeLoader.php:97
    13	YOOtheme\Theme\Joomla\ThemeLoader::getTemplate()	JROOT/templates/yootheme/packages/theme-joomla/src/ThemeLoader.php:33
    12	YOOtheme\Theme\Joomla\ThemeLoader::initTheme()	JROOT/templates/yootheme/packages/container/src/Container.php:262
    11	YOOtheme\Container->call()	JROOT/templates/yootheme/packages/application/src/Application/EventLoader.php:58
    10	YOOtheme\Application\EventLoader->YOOtheme\Application\{closure}()	JROOT/templates/yootheme/packages/utils/src/EventDispatcher.php:115
    9	YOOtheme\EventDispatcher->handleDefault()	JROOT/templates/yootheme/packages/utils/src/EventDispatcher.php:45
    8	YOOtheme\EventDispatcher->dispatch()	JROOT/templates/yootheme/packages/platform-joomla/src/Dispatcher.php:64
    7	YOOtheme\Joomla\Dispatcher->YOOtheme\Joomla\{closure}()	JROOT/libraries/joomla/event/dispatcher.php:165
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

21. Query Time: 0.10 ms After last query: 0.26 ms Query memory: 0.023 MB Memory before query: 3.147 MB Rows returned: 1

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

    Explain

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

    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.00 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:1662
    18	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
    17	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Same as call in the line below.
    16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
    14	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
    13	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
    12	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/bdthemes_shortcodes/bdthemes_shortcodes.php:61
    8	plgSystemBdthemes_Shortcodes->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

22. Query Time: 0.32 ms After last query: 0.05 ms Query memory: 0.006 MB Memory before query: 3.138 MB

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

    Explain

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

    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 for update	0.02 ms
    Updating	0.05 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.19 ms
    Writing to binlog	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
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
    13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
    12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
    11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
    10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
    9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/bdthemes_shortcodes/bdthemes_shortcodes.php:61
    8	plgSystemBdthemes_Shortcodes->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

23. Query Time: 0.20 ms After last query: 2.65 ms Query memory: 0.040 MB Memory before query: 3.212 MB Rows returned: 78

    SELECT * 
      FROM `jom3_social_access_rules` 
      WHERE `
      group` = 'user' 
      AND `state` = '1'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jom3_social_access_rules	ALL	state,group	NO INDEX KEY COULD BE USED	NULL	NULL	172	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.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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    18	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:46
    17	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    16	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/accessrules.php:138
    15	EasySocialModelAccessRules->getAllRules()	JROOT/administrator/components/com_easysocial/includes/access/access.php:127
    14	SocialAccess->getDefaultValues()	JROOT/administrator/components/com_easysocial/includes/access/access.php:93
    13	SocialAccess->loadAccess()	JROOT/administrator/components/com_easysocial/includes/access/access.php:42
    12	SocialAccess->__construct()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:2117
    11	ES::access()	JROOT/administrator/components/com_easysocial/includes/dependencies.php:122
    10	EasySocial->__construct()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:202
    9	ES::__callStatic()	JROOT/plugins/system/easysocialautologin/easysocialautologin.php:42
    8	PlgSystemEasySocialAutologin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

24. Query Time: 0.08 ms After last query: 0.53 ms Query memory: 0.023 MB Memory before query: 3.246 MB Rows returned: 0

    SELECT `params` 
      FROM `jom3_social_access` 
      WHERE `uid` = NULL 
      AND `type` = 'profiles'

    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.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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    17	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:46
    16	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    15	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/access.php:55
    14	EasySocialModelAccess->getParams()	JROOT/administrator/components/com_easysocial/includes/access/access.php:99
    13	SocialAccess->loadAccess()	JROOT/administrator/components/com_easysocial/includes/access/access.php:42
    12	SocialAccess->__construct()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:2117
    11	ES::access()	JROOT/administrator/components/com_easysocial/includes/dependencies.php:122
    10	EasySocial->__construct()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:202
    9	ES::__callStatic()	JROOT/plugins/system/easysocialautologin/easysocialautologin.php:42
    8	PlgSystemEasySocialAutologin->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1190
    4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
    3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

25. Query Time: 0.45 ms After last query: 1.48 ms Query memory: 0.025 MB Memory before query: 3.451 MB Rows returned: 47

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `jom3_assets`
    
      WHERE `name` IN ('root.1','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easysocial','com_fields','com_finder','com_flexbanners','com_forai','com_fpss','com_installer','com_jce','com_jchoptimize','com_jmap','com_joomlaupdate','com_jotcache','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_remository','com_roksprocket','com_search','com_socialbacklinks','com_speedcache','com_tags','com_templates','com_uniterevolution2','com_users','com_widgetkit','com_wrapper')

    Explain

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

    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.04 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.28 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/libraries/joomla/database/driver.php:1701
    20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
    19	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
    18	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
    17	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
    16	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
    15	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/articles.php:115
    14	ContentModelArticles->populateState()	JROOT/components/com_content/models/featured.php:45
    13	ContentModelFeatured->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
    12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:55
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

26. Query Time: 0.67 ms After last query: 0.37 ms Query memory: 0.023 MB Memory before query: 3.544 MB Rows returned: 0

    SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
      CASE WHEN c.published = 2 
      AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
      CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,fp.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
      CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
    							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
    
      FROM jom3_content AS a
    
      INNER JOIN jom3_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      LEFT JOIN jom3_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN jom3_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN jom3_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN jom3_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN jom3_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-01-27 19:45:16') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-01-27 19:45:16')
    
      ORDER BY c.lft, a.featured DESC, fp.ordering,  
      CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC , a.created DESC  
      LIMIT 4

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fp	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using temporary; Using filesort
    1	SIMPLE	a	eq_ref	PRIMARY,idx_access,idx_state,idx_catid	PRIMARY	4	3dallusions_joomla_d9.fp.content_id	1	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	3dallusions_joomla_d9.a.catid	1	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	3dallusions_joomla_d9.a.created_by	1	Using where
    1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	3dallusions_joomla_d9.a.modified_by	1	Using where
    1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	3dallusions_joomla_d9.c.parent_id	1	Using where
    1	SIMPLE	v	ALL	PRIMARY	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using join buffer (flat, BNL join)

    Profile

    Status	Duration
    Starting	0.10 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.05 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.02 ms
    Creating tmp table	0.05 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.17 ms
    Creating sort index	0.02 ms
    Removing tmp table	0.04 ms
    Creating sort index	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.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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
    15	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:194
    14	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
    13	ContentModelArticles->getItems()	JROOT/components/com_content/models/featured.php:126
    12	ContentModelFeatured->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:56
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

27. Query Time: 0.19 ms After last query: 0.12 ms Query memory: 0.022 MB Memory before query: 3.551 MB Rows returned: 1

    SELECT COUNT(*)
    
      FROM jom3_content AS a
    
      INNER JOIN jom3_content_frontpage AS fp 
      ON fp.content_id = a.id
    
      LEFT JOIN jom3_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN jom3_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN jom3_users AS uam 
      ON uam.id = a.modified_by
    
      LEFT JOIN jom3_categories as parent 
      ON parent.id = c.parent_id
    
      LEFT JOIN jom3_content_rating AS v 
      ON a.id = v.content_id
    
      WHERE a.access IN (1,1,5) 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND a.state = 1 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-01-27 19:45:16') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-01-27 19:45:16')

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	fp	index	PRIMARY	PRIMARY	4	NULL	1	Using index
    1	SIMPLE	a	eq_ref	PRIMARY,idx_access,idx_state,idx_catid	PRIMARY	4	3dallusions_joomla_d9.fp.content_id	1	Using where
    1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	3dallusions_joomla_d9.a.catid	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.02 ms
    Statistics	0.05 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.01 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    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/src/MVC/Model/BaseDatabaseModel.php:354
    14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:289
    13	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:239
    12	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/libraries/src/MVC/View/HtmlView.php:425
    11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/featured/view.html.php:57
    10	ContentViewFeatured->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:664
    9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
    8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
    7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
    6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
    5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
    4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
    3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
    2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

28. Query Time: 0.40 ms After last query: 1.98 ms Query memory: 0.040 MB Memory before query: 4.022 MB Rows returned: 27

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM jom3_modules AS m
    
      LEFT JOIN jom3_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN jom3_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 <= '2025-01-27 19:45:16') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2025-01-27 19:45:16') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 101 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	range	PRIMARY,published,newsfeeds	published	5	NULL	39	Using index condition; Using where; Using filesort
    1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	3dallusions_joomla_d9.m.id	1	Using where; Using index
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	3dallusions_joomla_d9.m.module,const	1	Using index condition; Using where

    Profile

    Status	Duration
    Starting	0.04 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.02 ms
    Optimizing	0.02 ms
    Statistics	0.04 ms
    Preparing	0.02 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	0.00 ms
    Creating sort index	0.17 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:1701
    18	JDatabaseDriver->loadObjectList()	Same as call in the line below.
    17	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
    16	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
    15	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
    14	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
    13	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:601
    12	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:54
    11	Warp\Joomla\Helper\WidgetsHelper->count()	JROOT/templates/jp-rooms/layouts/theme.config.php:28
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

29. Query Time: 0.27 ms After last query: 2.26 ms Query memory: 0.027 MB Memory before query: 4.247 MB Rows returned: 3

    SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
    				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
    				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
    				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
      CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
    
      FROM `jom3_categories` AS `s`
    
      INNER JOIN `jom3_categories` AS `c` 
      ON (s.lft <= c.lft 
      AND c.lft < s.rgt) OR (c.lft < s.lft 
      AND s.rgt < c.rgt)
    
      WHERE (c.extension='com_content' OR c.extension='system') 
      AND c.access IN (1,1,5) 
      AND c.published = 1 
      AND s.id = 70
    
      ORDER BY c.lft

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
    1	SIMPLE	c	range|filter	cat_idx,idx_access,idx_left_right	idx_left_right|cat_idx	4|207	NULL	10 (73%)	Using index condition; Using where; Using rowid filter

    Profile

    Status	Duration
    Starting	0.05 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.03 ms
    Optimizing	0.01 ms
    Statistics	0.05 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.01 ms
    Sorting result	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
    27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
    25	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
    24	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/Filter.php:134
    23	RokSprocket_Provider_Joomla_Filter->category()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstractJoomlaPlatformFilter.php:120
    22	RokSprocket_Provider_AbstractJoomlaPlatformFilter->process()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:46
    21	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    20	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    19	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    18	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    17	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    16	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    15	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    14	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

30. Query Time: 8.59 ms After last query: 0.09 ms Query memory: 6.670 MB Memory before query: 4.280 MB Rows returned: 692

    SELECT a.id, a.title, a.alias, a.introtext, a.`fulltext`, a.catid, a.state, a.access, a.created, a.created_by, a.created_by_alias, a.modified, a.featured, a.language, a.hits, a.publish_up, a.publish_down, a.images, a.urls, a.language, a.metakey, a.metadesc, a.metadata,c.title AS category_title, c.alias AS category_alias,ua.name AS author_name,um.name AS last_modified_by,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,vl.title AS access_title,l.title AS language_title
    
      FROM jom3_content as a
    
      LEFT JOIN jom3_categories AS c 
      ON c.id = a.catid
    
      LEFT JOIN jom3_users AS ua 
      ON ua.id = a.created_by
    
      LEFT JOIN jom3_users AS um 
      ON um.id = a.modified_by
    
      LEFT JOIN jom3_content_rating AS v 
      ON a.id = v.content_id
    
      LEFT JOIN jom3_viewlevels AS vl 
      ON a.access = vl.id
    
      LEFT JOIN jom3_languages AS l 
      ON a.language = l.lang_code
    
      LEFT JOIN jom3_contentitem_tag_map AS ct 
      ON ct.content_item_id = a.id
    
      LEFT JOIN jom3_tags AS t 
      ON t.id = ct.tag_id
    
      WHERE ((a.access IN(1,1,5) 
      AND (a.state = 1 or a.state = 2) 
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2025-01-27 19:45:16') 
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2025-01-27 19:45:16') 
      AND (a.state != -2)) 
      AND a.catid IN (70))
    
      GROUP BY id
    
      ORDER BY a.modified DESC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	749	Using where; Using temporary; Using filesort
    1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	3dallusions_joomla_d9.a.created_by	1	Using where
    1	SIMPLE	um	eq_ref	PRIMARY	PRIMARY	4	3dallusions_joomla_d9.a.modified_by	1	Using where
    1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	3dallusions_joomla_d9.a.id	1	Using where
    1	SIMPLE	vl	eq_ref	PRIMARY	PRIMARY	4	3dallusions_joomla_d9.a.access	1
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	3dallusions_joomla_d9.a.language	1	Using where
    1	SIMPLE	ct	index	NULL	idx_core_content_id	4	NULL	4	Using where; Using index; Using join buffer (flat, BNL join)

    Profile

    Status	Duration
    Starting	0.04 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.02 ms
    Optimizing	0.02 ms
    Statistics	0.07 ms
    Preparing	0.00 ms
    Unlocking tables	0.00 ms
    Preparing	0.02 ms
    Creating tmp table	0.03 ms
    Sorting result	0.01 ms
    Executing	0.00 ms
    Sending data	5.12 ms
    Creating sort index	2.58 ms
    Removing tmp table	0.56 ms
    Creating sort index	0.01 ms
    End of update loop	0.01 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
    23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    22	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:58
    21	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    20	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    19	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    18	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    17	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    16	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    15	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    14	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

31. Query Time: 0.37 ms After last query: 1.63 ms Query memory: 0.026 MB Memory before query: 11.644 MB Rows returned: 0

    SELECT ct.content_item_id as article_id, t.title as tag
    
      FROM jom3_contentitem_tag_map as ct
    
      LEFT JOIN jom3_tags AS t 
      ON t.id = ct.tag_id
    
      WHERE ct.content_item_id in (6475,6476,6478,6479,6481,6485,6516,6536,6545,6546,6548,6568,6575,6582,6587,6593,6597,6619,6627,6643,6645,6651,6673,6687,6710,6714,6727,6748,6749,6750,6762,6765,6766,6768,6773,6776,6778,6779,6780,6782,6786,6787,6790,6793,6794,6798,6799,6802,6803,6804,6810,6812,6813,6834,6835,6851,6852,6858,6861,6864,6892,6897,6925,6927,6928,6940,6942,6946,6956,6971,6991,7002,7007,7036,7046,7080,7081,7090,7111,7112,7118,7123,7128,7144,7160,7170,7175,7177,7187,7197,7198,7210,7212,7214,7215,7219,7221,7226,7240,7247,7248,7260,7263,7266,7269,7270,7272,7273,7274,7276,7277,7287,7288,7315,7316,7318,7319,7346,7348,7353,7354,7365,7368,7369,7376,7377,7379,7383,7388,7391,7398,7399,7403,7404,7405,7406,7410,7413,7414,7421,7426,7428,7431,7433,7437,7439,7442,7446,7450,7451,7458,7460,7462,7473,7475,7476,7478,7480,7482,7483,7485,7487,7488,7502,7507,7509,7513,7523,7533,7535,7540,7544,7551,7557,7564,7566,7570,7582,7584,7593,7594,7605,7607,7609,7614,7623,7632,7637,7646,7654,7669,7682,7683,7686,7693,7694,7697,7698,7700,7701,7702,7703,7704,7705,7706,7707,7708,7709,7710,7711,7712,7713,7714,7715,7716,7717,7718,7719,7720,7721,7722,7723,7724,7725,7726,7727,7728,7729,7730,7731,7732,7733,7735,7737,7738,7739,7740,7741,7742,7743,7744,7745,7746,7747,7748,7749,7750,7752,7753,7754,7755,7756,7757,7758,7759,7760,7761,7762,7763,7764,7765,7766,7768,7770,7771,7772,7775,7776,7777,7778,7779,7780,7781,7782,7783,7785,7786,7787,7788,7789,7790,7791,7792,7793,7794,7795,7796,7797,7798,7799,7800,7801,7803,7804,7805,7806,7807,7808,7809,7811,7812,7813,7814,7815,7816,7817,7818,7819,7820,7821,7822,7823,7824,7825,7826,7827,7828,7829,7830,7831,7832,7833,7834,7835,7838,7839,7840,7841,7842,7843,7844,7846,7847,7848,7851,7852,7853,7854,7855,7856,7857,7858,7859,7860,7861,7862,7863,7864,7865,7866,7867,7868,7869,7870,7871,7872,7873,7874,7875,7876,7877,7878,7880,7881,7882,7883,7884,7885,7886,7887,7888,7889,7890,7891,7892,7893,7894,7895,7896,7898,7899,7900,7901,7902,7903,7904,7905,7906,7907,7908,7909,7910,7911,7912,7913,7914,7916,7917,7918,7919,7920,7921,7922,7923,7924,7925,7926,7927,7928,7929,7930,7931,7934,7935,7936,7938,7939,7940,7941,7942,7943,7944,7945,7946,7947,7949,7950,7952,7953,7954,7955,7956,7957,7958,7959,7960,7961,7962,7963,7964,7965,7966,7967,7968,7969,7970,7971,7972,7973,7978,7979,7982,7984,7985,7986,7987,7988,7989,7990,7991,7992,7993,7994,7995,7996,7997,7998,7999,8000,8001,8002,8003,8004,8005,8006,8007,8008,8010,8011,8012,8015,8017,8018,8019,8021,8022,8023,8031,8032,8034,8035,8036,8038,8041,8042,8043,8044,8045,8046,8047,8048,8049,8050,8055,8056,8057,8058,8059,8060,8061,8063,8065,8066,8068,8069,8073,8074,8076,8077,8078,8079,8080,8081,8082,8083,8085,8086,8088,8089,8091,8092,8093,8098,8100,8101,8103,8104,8107,8109,8110,8111,8112,8114,8115,8116,8126,8129,8130,8131,8134,8135,8136,8137,8138,8139,8141,8144,8146,8150,8151,8152,8154,8156,8157,8158,8159,8163,8164,8165,8166,8167,8168,8169,8170,8171,8172,8173,8174,8175,8176,8177,8178,8179,8180,8181,8182,8183,8184,8185,8186,8189,8190,8191,8192,8193,8194,8195,8196,8199,8200,8201,8202,8203,8204,8205,8206,8207,8208,8209,8210,8211,8212,8213,8214,8215,8216,8217,8218,8220,8221,8223,8224,8225,8226,8227,8228,8229,8230,8231,8232,8233,8234,8235,8236,8237,8238,8239,8240,8241,8242,8245,8246,8247,8248,8249,8251,8252,8253,8254,8255,8256,8257,8258,8259,8260,8261,8262,8263,8264,8265,8266,8267,8268,8269,8270,8271,8272,8273,8274,8275,8276,8279,8280,8281,8282,8283,8284,8285,8286,8287,8288,8289,8290,8291,8292,8293,8294,8295,8296,8297,8298,8299)

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	ct	index	NULL	idx_core_content_id	4	NULL	4	Using where; Using index
    1	SIMPLE	t	eq_ref	PRIMARY	PRIMARY	4	3dallusions_joomla_d9.ct.tag_id	1

    Profile

    Status	Duration
    Starting	0.12 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.04 ms
    Statistics	0.02 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    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
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    24	JDatabaseDriver->loadAssocList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla/TagMerge.php:26
    23	RokSprocket_Provider_Joomla_TagMerge->populateTags()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/Joomla.php:159
    22	RokSprocket_Provider_Joomla->populateTags()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:62
    21	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    20	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    19	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    18	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    17	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    16	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    15	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    14	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

32. Query Time: 0.43 ms After last query: 20.68 ms Query memory: 0.046 MB Memory before query: 14.266 MB Rows returned: 210

    SELECT i.provider_id as id, i.
      order, i.params
    
      FROM jom3_roksprocket_items as i
    
      WHERE i.module_id = '312' 
      AND i.provider = 'joomla'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	i	ALL	idx_module,idx_module_order	NO INDEX KEY COULD BE USED	NULL	NULL	624	Using where

    Profile

    Status	Duration
    Starting	0.05 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    System lock	0.00 ms
    table lock	0.01 ms
    init	0.03 ms
    Optimizing	0.02 ms
    Statistics	0.06 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.17 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:1701
    23	JDatabaseDriver->loadObjectList()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:139
    22	RokSprocket_Provider_AbstarctJoomlaBasedProvider->mapPerItemData()	JROOT/components/com_roksprocket/lib/RokSprocket/Provider/AbstarctJoomlaBasedProvider.php:64
    21	RokSprocket_Provider_AbstarctJoomlaBasedProvider->getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:294
    20	RokSprocket::getItems()	JROOT/components/com_roksprocket/lib/RokSprocket.php:230
    19	RokSprocket::getItemsWithParams()	JROOT/components/com_roksprocket/lib/RokSprocket.php:55
    18	RokSprocket->getData()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:52
    17	ModRokSprocket->_realGetData()	JROOT/components/com_roksprocket/lib/RokSprocket/PlatformHelper/Joomla.php:80
    16	RokSprocket_PlatformHelper_Joomla->getFromCache()	JROOT/modules/mod_roksprocket/lib/ModRokSprocket.php:37
    15	ModRokSprocket->getData()	JROOT/modules/mod_roksprocket/mod_roksprocket.php:38
    14	include JROOT/modules/mod_roksprocket/mod_roksprocket.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

33. Query Time: 0.33 ms After last query: 28.70 ms Query memory: 0.009 MB Memory before query: 5.866 MB

    UPDATE `jom3_flexbanners` 
      SET finished=1, state=0
              
      WHERE (enddate < '2025-01-27 19:45:16' 
      and enddate <> '0000-00-00 00:00:00'  
      and state<>2 
      and state<>-2)
                 OR (impmade >= maximpressions 
      AND maximpressions <> 0 )
                 OR (clicks >= maxclicks 
      AND maxclicks <> 0)

    Explain

    EXPLAIN not possible on query: UPDATE `jom3_flexbanners` SET finished=1, state=0 WHERE (enddate < '2025-01-27 19:45:16' and enddate <> '0000-00-00 00:00:00' and state<>2 and state<>-2) OR (impmade >= maximpressions AND maximpressions <> 0 ) OR (clicks >= maxclicks AND maxclicks <> 0)

    Profile

    Status	Duration
    Starting	0.07 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 for update	0.06 ms
    Updating	0.04 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Writing to binlog	0.03 ms
    Commit	0.01 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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    17	JDatabase->query()	JROOT/components/com_flexbanners/helpers/flexbanners.php:78
    16	disableOldBanners()	JROOT/components/com_flexbanners/helpers/flexbanners.php:20
    15	require_once JROOT/components/com_flexbanners/helpers/flexbanners.php	JROOT/modules/mod_flexbanners/mod_flexbanners.php:11
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

34. Query Time: 0.10 ms After last query: 0.02 ms Query memory: 0.008 MB Memory before query: 5.875 MB

    UPDATE `jom3_flexbanners` 
      SET state=1
              
      WHERE startdate<= '2025-01-27 19:45:16' 
      and finished=0  
      and startdate <> '0000-00-00 00:00:00' 
      and state<>2 
      and state<>-2

    Explain

    EXPLAIN not possible on query: UPDATE `jom3_flexbanners` SET state=1 WHERE startdate<= '2025-01-27 19:45:16' and finished=0 and startdate <> '0000-00-00 00:00:00' and state<>2 and state<>-2

    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 for update	0.01 ms
    Updating	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Writing to binlog	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.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    17	JDatabase->query()	JROOT/components/com_flexbanners/helpers/flexbanners.php:88
    16	activateBanners()	JROOT/components/com_flexbanners/helpers/flexbanners.php:21
    15	require_once JROOT/components/com_flexbanners/helpers/flexbanners.php	JROOT/modules/mod_flexbanners/mod_flexbanners.php:11
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

35. Query Time: 0.15 ms After last query: 0.01 ms Query memory: 0.008 MB Memory before query: 5.883 MB

    UPDATE `jom3_flexbanners` 
      SET dailyimpressions=0, lastreset='2025-01-27'
              
      WHERE lastreset< '2025-01-27' or lastreset IS NULL

    Explain

    EXPLAIN not possible on query: UPDATE `jom3_flexbanners` SET dailyimpressions=0, lastreset='2025-01-27' WHERE lastreset< '2025-01-27' or lastreset IS NULL

    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 for update	0.01 ms
    Updating	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.00 ms
    Writing to binlog	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.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/database.php:33
    17	JDatabase->query()	JROOT/components/com_flexbanners/helpers/flexbanners.php:66
    16	resetImpressions()	JROOT/components/com_flexbanners/helpers/flexbanners.php:22
    15	require_once JROOT/components/com_flexbanners/helpers/flexbanners.php	JROOT/modules/mod_flexbanners/mod_flexbanners.php:11
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

36. Query Time: 0.28 ms After last query: 0.10 ms Query memory: 0.023 MB Memory before query: 5.911 MB Rows returned: 1

    SELECT a.id,a.catid,a.imageurl,a.flash,a.cloud_imageurl,a.imagealt,a.type,a.customcode,a.startdate,a.enddate,a.lastreset,a.impmade,a.clicks,a.maximpressions,a.maxclicks,a.linkid,a.language,a.newwin,a.restrictbyid,a.dailyimpressions,s.height,s.width
    
      FROM jom3_flexbanners AS a
    
      INNER JOIN jom3_flexbannerssize AS s USING (sizeid)
    
      INNER JOIN jom3_categories AS c
    
      WHERE a.locationid = 3  
      AND a.state = 1 
      AND a.finished = 0 
      AND (a.language = "en-GB" or a.language = "*") 
      AND c.id = a.catid 
      AND c.access IN ( 1,1,5 )

    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	24	Using where
    1	SIMPLE	s	eq_ref	PRIMARY	PRIMARY	4	3dallusions_joomla_d9.a.sizeid	1
    1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	3dallusions_joomla_d9.a.catid	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.03 ms
    Optimizing	0.02 ms
    Statistics	0.05 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
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:136
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

37. Query Time: 0.39 ms After last query: 0.05 ms Query memory: 0.025 MB Memory before query: 5.921 MB Rows returned: 41

    SHOW FULL COLUMNS 
      FROM `jom3_flexbanners`

    Explain

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

    Profile

    Status	Duration
    Starting	0.01 ms
    checking permissions	0.00 ms
    closing tables	0.00 ms
    Opening tables	0.14 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
    Filling schema table	0.01 ms
    Opening tables	0.01 ms
    After opening tables	0.00 ms
    checking permissions	0.07 ms
    closing tables	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
    Removing tmp table	0.05 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
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    19	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
    18	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:261
    17	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:180
    16	Joomla\CMS\Table\Table->__construct()	JROOT/components/com_flexbanners/helpers/flexbanner.php:109
    15	flexAdBanner->__construct()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:162
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

38. Query Time: 0.11 ms After last query: 0.19 ms Query memory: 0.024 MB Memory before query: 5.974 MB Rows returned: 1

    SELECT *
    
      FROM jom3_flexbanners
    
      WHERE `id` = '14'

    Explain

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

    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.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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    15	Joomla\CMS\Table\Table->load()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:163
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

39. Query Time: 0.34 ms After last query: 0.11 ms Query memory: 0.008 MB Memory before query: 5.985 MB

    UPDATE `jom3_flexbanners` 
      SET `clientid`='10',`linkid`='9',`sizeid`='2',`imageurl`='images/banners/Cebas_234x60.jpg',`imagealt`='',`customcode`='',`restrictbyid`='0',`frontpage`='0',`clicks`='3237',`impmade`='9457273',`startdate`='0000-00-00 00:00:00',`enddate`='0000-00-00 00:00:00',`maximpressions`='0',`maxclicks`='0',`dailyimpressions`='2654',`lastreset`='2025-01-27',`state`='1',`finished`='0',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`locationid`='3',`type`='0',`name`='Cebas_234x60',`cloud_imageurl`='',`published`='0',`catid`='93',`ordering`='14',`created`='2017-02-19 22:40:50',`created_by`='0',`created_by_alias`='0',`language`='*',`newwin`='1',`modified`='0000-00-00 00:00:00',`modified_by`='0',`params`='',`version`='1' 
      WHERE `id` = '14'

    Explain

    EXPLAIN not possible on query: UPDATE `jom3_flexbanners` SET `clientid`='10',`linkid`='9',`sizeid`='2',`imageurl`='images/banners/Cebas_234x60.jpg',`imagealt`='',`customcode`='',`restrictbyid`='0',`frontpage`='0',`clicks`='3237',`impmade`='9457273',`startdate`='0000-00-00 00:00:00',`enddate`='0000-00-00 00:00:00',`maximpressions`='0',`maxclicks`='0',`dailyimpressions`='2654',`lastreset`='2025-01-27',`state`='1',`finished`='0',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`locationid`='3',`type`='0',`name`='Cebas_234x60',`cloud_imageurl`='',`published`='0',`catid`='93',`ordering`='14',`created`='2017-02-19 22:40:50',`created_by`='0',`created_by_alias`='0',`language`='*',`newwin`='1',`modified`='0000-00-00 00:00:00',`modified_by`='0',`params`='',`version`='1' WHERE `id` = '14'

    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 for update	0.02 ms
    Updating	0.05 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.21 ms
    Writing to binlog	0.00 ms
    Commit	0.01 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:2304
    16	JDatabaseDriver->updateObject()	JROOT/libraries/src/Table/Table.php:817
    15	Joomla\CMS\Table\Table->store()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:201
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

40. Query Time: 0.32 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 5.986 MB Rows returned: 1

    SELECT a.id,a.catid,a.imageurl,a.flash,a.cloud_imageurl,a.imagealt,a.type,a.customcode,a.startdate,a.enddate,a.lastreset,a.impmade,a.clicks,a.maximpressions,a.maxclicks,a.linkid,a.language,a.newwin,a.restrictbyid,a.dailyimpressions,s.height,s.width
    
      FROM jom3_flexbanners AS a
    
      INNER JOIN jom3_flexbannerssize AS s USING (sizeid)
    
      INNER JOIN jom3_categories AS c
    
      WHERE a.locationid = 8  
      AND a.state = 1 
      AND a.finished = 0 
      AND (a.language = "en-GB" or a.language = "*") 
      AND c.id = a.catid 
      AND c.access IN ( 1,1,5 )

    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	24	Using where
    1	SIMPLE	s	eq_ref	PRIMARY	PRIMARY	4	3dallusions_joomla_d9.a.sizeid	1
    1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	3dallusions_joomla_d9.a.catid	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.03 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.02 ms
    Executing	0.00 ms
    Sending data	0.14 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:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:136
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

41. Query Time: 0.07 ms After last query: 0.04 ms Query memory: 0.024 MB Memory before query: 6.001 MB Rows returned: 1

    SELECT *
    
      FROM jom3_flexbanners
    
      WHERE `id` = '17'

    Explain

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

    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.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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    15	Joomla\CMS\Table\Table->load()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:163
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

42. Query Time: 0.30 ms After last query: 0.06 ms Query memory: 0.008 MB Memory before query: 6.013 MB

    UPDATE `jom3_flexbanners` 
      SET `clientid`='3',`linkid`='10',`sizeid`='2',`imageurl`='images/banners/VIShopper_234x60.jpg',`imagealt`='',`customcode`='',`restrictbyid`='0',`frontpage`='0',`clicks`='3379',`impmade`='9457251',`startdate`='0000-00-00 00:00:00',`enddate`='0000-00-00 00:00:00',`maximpressions`='0',`maxclicks`='0',`dailyimpressions`='2654',`lastreset`='2025-01-27',`state`='1',`finished`='0',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`locationid`='8',`type`='0',`name`='VIShopper_234x60',`cloud_imageurl`='',`published`='0',`catid`='93',`ordering`='17',`created`='2017-02-19 23:49:14',`created_by`='0',`created_by_alias`='0',`language`='*',`newwin`='1',`modified`='2017-02-20 00:23:03',`modified_by`='30205',`params`='',`version`='2' 
      WHERE `id` = '17'

    Explain

    EXPLAIN not possible on query: UPDATE `jom3_flexbanners` SET `clientid`='3',`linkid`='10',`sizeid`='2',`imageurl`='images/banners/VIShopper_234x60.jpg',`imagealt`='',`customcode`='',`restrictbyid`='0',`frontpage`='0',`clicks`='3379',`impmade`='9457251',`startdate`='0000-00-00 00:00:00',`enddate`='0000-00-00 00:00:00',`maximpressions`='0',`maxclicks`='0',`dailyimpressions`='2654',`lastreset`='2025-01-27',`state`='1',`finished`='0',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`locationid`='8',`type`='0',`name`='VIShopper_234x60',`cloud_imageurl`='',`published`='0',`catid`='93',`ordering`='17',`created`='2017-02-19 23:49:14',`created_by`='0',`created_by_alias`='0',`language`='*',`newwin`='1',`modified`='2017-02-20 00:23:03',`modified_by`='30205',`params`='',`version`='2' WHERE `id` = '17'

    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 for update	0.01 ms
    Updating	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.21 ms
    Writing to binlog	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:2304
    16	JDatabaseDriver->updateObject()	JROOT/libraries/src/Table/Table.php:817
    15	Joomla\CMS\Table\Table->store()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:201
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

43. Query Time: 0.34 ms After last query: 0.06 ms Query memory: 0.023 MB Memory before query: 6.016 MB Rows returned: 2

    SELECT a.id,a.catid,a.imageurl,a.flash,a.cloud_imageurl,a.imagealt,a.type,a.customcode,a.startdate,a.enddate,a.lastreset,a.impmade,a.clicks,a.maximpressions,a.maxclicks,a.linkid,a.language,a.newwin,a.restrictbyid,a.dailyimpressions,s.height,s.width
    
      FROM jom3_flexbanners AS a
    
      INNER JOIN jom3_flexbannerssize AS s USING (sizeid)
    
      INNER JOIN jom3_categories AS c
    
      WHERE a.locationid = 9  
      AND a.state = 1 
      AND a.finished = 0 
      AND (a.language = "en-GB" or a.language = "*") 
      AND c.id = a.catid 
      AND c.access IN ( 1,1,5 )

    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	24	Using where
    1	SIMPLE	s	eq_ref	PRIMARY	PRIMARY	4	3dallusions_joomla_d9.a.sizeid	1
    1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	3dallusions_joomla_d9.a.catid	1	Using where

    Profile

    Status	Duration
    Starting	0.06 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.03 ms
    Optimizing	0.01 ms
    Statistics	0.03 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.14 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:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:136
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

44. Query Time: 0.09 ms After last query: 0.04 ms Query memory: 0.024 MB Memory before query: 6.033 MB Rows returned: 1

    SELECT *
    
      FROM jom3_flexbanners
    
      WHERE `id` = '16'

    Explain

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

    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.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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    15	Joomla\CMS\Table\Table->load()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:163
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

45. Query Time: 0.19 ms After last query: 0.05 ms Query memory: 0.008 MB Memory before query: 6.045 MB

    UPDATE `jom3_flexbanners` 
      SET `clientid`='8',`linkid`='7',`sizeid`='2',`imageurl`='images/banners/Lumion_234x60.jpg',`imagealt`='',`customcode`='',`restrictbyid`='0',`frontpage`='0',`clicks`='2956',`impmade`='8957855',`startdate`='0000-00-00 00:00:00',`enddate`='0000-00-00 00:00:00',`maximpressions`='0',`maxclicks`='0',`dailyimpressions`='2654',`lastreset`='2025-01-27',`state`='1',`finished`='0',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`locationid`='9',`type`='0',`name`='Lumion_234x60',`cloud_imageurl`='',`published`='0',`catid`='93',`ordering`='16',`created`='2017-02-19 23:44:49',`created_by`='0',`created_by_alias`='0',`language`='*',`newwin`='1',`modified`='0000-00-00 00:00:00',`modified_by`='0',`params`='',`version`='1' 
      WHERE `id` = '16'

    Explain

    EXPLAIN not possible on query: UPDATE `jom3_flexbanners` SET `clientid`='8',`linkid`='7',`sizeid`='2',`imageurl`='images/banners/Lumion_234x60.jpg',`imagealt`='',`customcode`='',`restrictbyid`='0',`frontpage`='0',`clicks`='2956',`impmade`='8957855',`startdate`='0000-00-00 00:00:00',`enddate`='0000-00-00 00:00:00',`maximpressions`='0',`maxclicks`='0',`dailyimpressions`='2654',`lastreset`='2025-01-27',`state`='1',`finished`='0',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`locationid`='9',`type`='0',`name`='Lumion_234x60',`cloud_imageurl`='',`published`='0',`catid`='93',`ordering`='16',`created`='2017-02-19 23:44:49',`created_by`='0',`created_by_alias`='0',`language`='*',`newwin`='1',`modified`='0000-00-00 00:00:00',`modified_by`='0',`params`='',`version`='1' WHERE `id` = '16'

    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 for update	0.02 ms
    Updating	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.10 ms
    Writing to binlog	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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:2304
    16	JDatabaseDriver->updateObject()	JROOT/libraries/src/Table/Table.php:817
    15	Joomla\CMS\Table\Table->store()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:201
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

46. Query Time: 0.52 ms After last query: 25.44 ms Query memory: 0.023 MB Memory before query: 6.059 MB Rows returned: 1

    SELECT a.id,a.catid,a.imageurl,a.flash,a.cloud_imageurl,a.imagealt,a.type,a.customcode,a.startdate,a.enddate,a.lastreset,a.impmade,a.clicks,a.maximpressions,a.maxclicks,a.linkid,a.language,a.newwin,a.restrictbyid,a.dailyimpressions,s.height,s.width
    
      FROM jom3_flexbanners AS a
    
      INNER JOIN jom3_flexbannerssize AS s USING (sizeid)
    
      INNER JOIN jom3_categories AS c
    
      WHERE a.locationid = 7  
      AND a.state = 1 
      AND a.finished = 0 
      AND (a.language = "en-GB" or a.language = "*") 
      AND c.id = a.catid 
      AND c.access IN ( 1,1,5 )

    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	24	Using where
    1	SIMPLE	s	eq_ref	PRIMARY	PRIMARY	4	3dallusions_joomla_d9.a.sizeid	1
    1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	3dallusions_joomla_d9.a.catid	1	Using where

    Profile

    Status	Duration
    Starting	0.05 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.04 ms
    Optimizing	0.01 ms
    Statistics	0.06 ms
    Preparing	0.02 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.01 ms
    Starting cleanup	0.00 ms
    Freeing items	0.01 ms
    Updating status	0.01 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:136
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

47. Query Time: 0.11 ms After last query: 0.09 ms Query memory: 0.024 MB Memory before query: 6.074 MB Rows returned: 1

    SELECT *
    
      FROM jom3_flexbanners
    
      WHERE `id` = '19'

    Explain

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

    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.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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    15	Joomla\CMS\Table\Table->load()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:163
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

48. Query Time: 0.30 ms After last query: 0.12 ms Query memory: 0.008 MB Memory before query: 6.086 MB

    UPDATE `jom3_flexbanners` 
      SET `clientid`='2',`linkid`='1',`sizeid`='2',`imageurl`='images/banners/GrowFX_234x60.jpg',`imagealt`='',`customcode`='',`restrictbyid`='0',`frontpage`='0',`clicks`='3349',`impmade`='9454406',`startdate`='0000-00-00 00:00:00',`enddate`='0000-00-00 00:00:00',`maximpressions`='0',`maxclicks`='0',`dailyimpressions`='2656',`lastreset`='2025-01-27',`state`='1',`finished`='0',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`locationid`='7',`type`='0',`name`='GrowFX_234x60',`cloud_imageurl`='',`published`='0',`catid`='93',`ordering`='19',`created`='2017-02-19 23:58:09',`created_by`='0',`created_by_alias`='0',`language`='*',`newwin`='1',`modified`='0000-00-00 00:00:00',`modified_by`='0',`params`='',`version`='1' 
      WHERE `id` = '19'

    Explain

    EXPLAIN not possible on query: UPDATE `jom3_flexbanners` SET `clientid`='2',`linkid`='1',`sizeid`='2',`imageurl`='images/banners/GrowFX_234x60.jpg',`imagealt`='',`customcode`='',`restrictbyid`='0',`frontpage`='0',`clicks`='3349',`impmade`='9454406',`startdate`='0000-00-00 00:00:00',`enddate`='0000-00-00 00:00:00',`maximpressions`='0',`maxclicks`='0',`dailyimpressions`='2656',`lastreset`='2025-01-27',`state`='1',`finished`='0',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`locationid`='7',`type`='0',`name`='GrowFX_234x60',`cloud_imageurl`='',`published`='0',`catid`='93',`ordering`='19',`created`='2017-02-19 23:58:09',`created_by`='0',`created_by_alias`='0',`language`='*',`newwin`='1',`modified`='0000-00-00 00:00:00',`modified_by`='0',`params`='',`version`='1' WHERE `id` = '19'

    Profile

    Status	Duration
    Starting	0.03 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 for update	0.03 ms
    Updating	0.06 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.14 ms
    Writing to binlog	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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:2304
    16	JDatabaseDriver->updateObject()	JROOT/libraries/src/Table/Table.php:817
    15	Joomla\CMS\Table\Table->store()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:201
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

49. Query Time: 0.29 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 6.088 MB Rows returned: 1

    SELECT a.id,a.catid,a.imageurl,a.flash,a.cloud_imageurl,a.imagealt,a.type,a.customcode,a.startdate,a.enddate,a.lastreset,a.impmade,a.clicks,a.maximpressions,a.maxclicks,a.linkid,a.language,a.newwin,a.restrictbyid,a.dailyimpressions,s.height,s.width
    
      FROM jom3_flexbanners AS a
    
      INNER JOIN jom3_flexbannerssize AS s USING (sizeid)
    
      INNER JOIN jom3_categories AS c
    
      WHERE a.locationid = 4  
      AND a.state = 1 
      AND a.finished = 0 
      AND (a.language = "en-GB" or a.language = "*") 
      AND c.id = a.catid 
      AND c.access IN ( 1,1,5 )

    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	24	Using where
    1	SIMPLE	s	eq_ref	PRIMARY	PRIMARY	4	3dallusions_joomla_d9.a.sizeid	1
    1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	3dallusions_joomla_d9.a.catid	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.03 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.12 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:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:136
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

50. Query Time: 0.09 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 6.104 MB Rows returned: 1

    SELECT *
    
      FROM jom3_flexbanners
    
      WHERE `id` = '18'

    Explain

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

    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.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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    15	Joomla\CMS\Table\Table->load()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:163
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

51. Query Time: 0.25 ms After last query: 0.11 ms Query memory: 0.008 MB Memory before query: 6.116 MB

    UPDATE `jom3_flexbanners` 
      SET `clientid`='1',`linkid`='2',`sizeid`='2',`imageurl`='images/banners/Corona_234x60.jpg',`imagealt`='',`customcode`='',`restrictbyid`='0',`frontpage`='0',`clicks`='3649',`impmade`='9454302',`startdate`='0000-00-00 00:00:00',`enddate`='0000-00-00 00:00:00',`maximpressions`='0',`maxclicks`='0',`dailyimpressions`='2656',`lastreset`='2025-01-27',`state`='1',`finished`='0',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`locationid`='4',`type`='0',`name`='Corona_234x60',`cloud_imageurl`='',`published`='0',`catid`='93',`ordering`='18',`created`='2017-02-19 23:52:49',`created_by`='0',`created_by_alias`='0',`language`='*',`newwin`='1',`modified`='0000-00-00 00:00:00',`modified_by`='0',`params`='',`version`='1' 
      WHERE `id` = '18'

    Explain

    EXPLAIN not possible on query: UPDATE `jom3_flexbanners` SET `clientid`='1',`linkid`='2',`sizeid`='2',`imageurl`='images/banners/Corona_234x60.jpg',`imagealt`='',`customcode`='',`restrictbyid`='0',`frontpage`='0',`clicks`='3649',`impmade`='9454302',`startdate`='0000-00-00 00:00:00',`enddate`='0000-00-00 00:00:00',`maximpressions`='0',`maxclicks`='0',`dailyimpressions`='2656',`lastreset`='2025-01-27',`state`='1',`finished`='0',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`locationid`='4',`type`='0',`name`='Corona_234x60',`cloud_imageurl`='',`published`='0',`catid`='93',`ordering`='18',`created`='2017-02-19 23:52:49',`created_by`='0',`created_by_alias`='0',`language`='*',`newwin`='1',`modified`='0000-00-00 00:00:00',`modified_by`='0',`params`='',`version`='1' WHERE `id` = '18'

    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 for update	0.02 ms
    Updating	0.03 ms
    End of update loop	0.01 ms
    Query end	0.00 ms
    Commit	0.14 ms
    Writing to binlog	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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:2304
    16	JDatabaseDriver->updateObject()	JROOT/libraries/src/Table/Table.php:817
    15	Joomla\CMS\Table\Table->store()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:201
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

52. Query Time: 0.27 ms After last query: 0.09 ms Query memory: 0.023 MB Memory before query: 6.118 MB Rows returned: 1

    SELECT a.id,a.catid,a.imageurl,a.flash,a.cloud_imageurl,a.imagealt,a.type,a.customcode,a.startdate,a.enddate,a.lastreset,a.impmade,a.clicks,a.maximpressions,a.maxclicks,a.linkid,a.language,a.newwin,a.restrictbyid,a.dailyimpressions,s.height,s.width
    
      FROM jom3_flexbanners AS a
    
      INNER JOIN jom3_flexbannerssize AS s USING (sizeid)
    
      INNER JOIN jom3_categories AS c
    
      WHERE a.locationid = 6  
      AND a.state = 1 
      AND a.finished = 0 
      AND (a.language = "en-GB" or a.language = "*") 
      AND c.id = a.catid 
      AND c.access IN ( 1,1,5 )

    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	24	Using where
    1	SIMPLE	s	eq_ref	PRIMARY	PRIMARY	4	3dallusions_joomla_d9.a.sizeid	1
    1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	3dallusions_joomla_d9.a.catid	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.02 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.13 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:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:136
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

53. Query Time: 0.07 ms After last query: 0.06 ms Query memory: 0.024 MB Memory before query: 6.134 MB Rows returned: 1

    SELECT *
    
      FROM jom3_flexbanners
    
      WHERE `id` = '21'

    Explain

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

    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.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.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    15	Joomla\CMS\Table\Table->load()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:163
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

54. Query Time: 0.17 ms After last query: 0.08 ms Query memory: 0.008 MB Memory before query: 6.146 MB

    UPDATE `jom3_flexbanners` 
      SET `clientid`='11',`linkid`='11',`sizeid`='2',`imageurl`='images/banners/LWCad_234x60.jpg',`imagealt`='',`customcode`='',`restrictbyid`='0',`frontpage`='0',`clicks`='3521',`impmade`='9454088',`startdate`='0000-00-00 00:00:00',`enddate`='0000-00-00 00:00:00',`maximpressions`='0',`maxclicks`='0',`dailyimpressions`='2657',`lastreset`='2025-01-27',`state`='1',`finished`='0',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`locationid`='6',`type`='0',`name`='LWCad',`cloud_imageurl`='',`published`='0',`catid`='93',`ordering`='21',`created`='2017-02-20 00:29:23',`created_by`='0',`created_by_alias`='0',`language`='*',`newwin`='1',`modified`='0000-00-00 00:00:00',`modified_by`='0',`params`='',`version`='1' 
      WHERE `id` = '21'

    Explain

    EXPLAIN not possible on query: UPDATE `jom3_flexbanners` SET `clientid`='11',`linkid`='11',`sizeid`='2',`imageurl`='images/banners/LWCad_234x60.jpg',`imagealt`='',`customcode`='',`restrictbyid`='0',`frontpage`='0',`clicks`='3521',`impmade`='9454088',`startdate`='0000-00-00 00:00:00',`enddate`='0000-00-00 00:00:00',`maximpressions`='0',`maxclicks`='0',`dailyimpressions`='2657',`lastreset`='2025-01-27',`state`='1',`finished`='0',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`locationid`='6',`type`='0',`name`='LWCad',`cloud_imageurl`='',`published`='0',`catid`='93',`ordering`='21',`created`='2017-02-20 00:29:23',`created_by`='0',`created_by_alias`='0',`language`='*',`newwin`='1',`modified`='0000-00-00 00:00:00',`modified_by`='0',`params`='',`version`='1' WHERE `id` = '21'

    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 for update	0.01 ms
    Updating	0.03 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.09 ms
    Writing to binlog	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
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:2304
    16	JDatabaseDriver->updateObject()	JROOT/libraries/src/Table/Table.php:817
    15	Joomla\CMS\Table\Table->store()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:201
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

55. Query Time: 0.26 ms After last query: 0.08 ms Query memory: 0.023 MB Memory before query: 6.148 MB Rows returned: 2

    SELECT a.id,a.catid,a.imageurl,a.flash,a.cloud_imageurl,a.imagealt,a.type,a.customcode,a.startdate,a.enddate,a.lastreset,a.impmade,a.clicks,a.maximpressions,a.maxclicks,a.linkid,a.language,a.newwin,a.restrictbyid,a.dailyimpressions,s.height,s.width
    
      FROM jom3_flexbanners AS a
    
      INNER JOIN jom3_flexbannerssize AS s USING (sizeid)
    
      INNER JOIN jom3_categories AS c
    
      WHERE a.locationid = 1  
      AND a.state = 1 
      AND a.finished = 0 
      AND (a.language = "en-GB" or a.language = "*") 
      AND c.id = a.catid 
      AND c.access IN ( 1,1,5 )

    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	24	Using where
    1	SIMPLE	s	eq_ref	PRIMARY	PRIMARY	4	3dallusions_joomla_d9.a.sizeid	1
    1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	3dallusions_joomla_d9.a.catid	1	Using where

    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.03 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.12 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
    16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    15	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:136
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

56. Query Time: 0.06 ms After last query: 0.04 ms Query memory: 0.024 MB Memory before query: 6.166 MB Rows returned: 1

    SELECT *
    
      FROM jom3_flexbanners
    
      WHERE `id` = '24'

    Explain

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

    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.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.00 ms
    Reset for next command	0.00 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    16	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    15	Joomla\CMS\Table\Table->load()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:163
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

57. Query Time: 0.20 ms After last query: 0.06 ms Query memory: 0.008 MB Memory before query: 6.178 MB

    UPDATE `jom3_flexbanners` 
      SET `clientid`='10',`linkid`='9',`sizeid`='8',`imageurl`='images/banners/finalrender_728x90.jpg',`imagealt`='finalRender Hybrid Render Engine',`customcode`='',`restrictbyid`='0',`frontpage`='0',`clicks`='1755',`impmade`='4531172',`startdate`='0000-00-00 00:00:00',`enddate`='0000-00-00 00:00:00',`maximpressions`='0',`maxclicks`='0',`dailyimpressions`='1327',`lastreset`='2025-01-27',`state`='1',`finished`='0',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`locationid`='1',`type`='0',`name`='finalRender',`flash`='',`cloud_imageurl`='',`published`='0',`catid`='93',`ordering`='24',`created`='2018-08-27 06:13:26',`created_by`='0',`created_by_alias`='0',`language`='*',`newwin`='1',`modified`='2018-11-20 20:38:26',`modified_by`='30205',`params`='',`version`='2' 
      WHERE `id` = '24'

    Explain

    EXPLAIN not possible on query: UPDATE `jom3_flexbanners` SET `clientid`='10',`linkid`='9',`sizeid`='8',`imageurl`='images/banners/finalrender_728x90.jpg',`imagealt`='finalRender Hybrid Render Engine',`customcode`='',`restrictbyid`='0',`frontpage`='0',`clicks`='1755',`impmade`='4531172',`startdate`='0000-00-00 00:00:00',`enddate`='0000-00-00 00:00:00',`maximpressions`='0',`maxclicks`='0',`dailyimpressions`='1327',`lastreset`='2025-01-27',`state`='1',`finished`='0',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`locationid`='1',`type`='0',`name`='finalRender',`flash`='',`cloud_imageurl`='',`published`='0',`catid`='93',`ordering`='24',`created`='2018-08-27 06:13:26',`created_by`='0',`created_by_alias`='0',`language`='*',`newwin`='1',`modified`='2018-11-20 20:38:26',`modified_by`='30205',`params`='',`version`='2' WHERE `id` = '24'

    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 for update	0.02 ms
    Updating	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.09 ms
    Writing to binlog	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:2304
    16	JDatabaseDriver->updateObject()	JROOT/libraries/src/Table/Table.php:817
    15	Joomla\CMS\Table\Table->store()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:201
    14	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    13	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    12	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    11	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/layouts/theme.config.php:74
    10	include JROOT/templates/jp-rooms/layouts/theme.config.php	JROOT/templates/jp-rooms/layouts/theme.php:10
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

58. Query Time: 0.28 ms After last query: 3.97 ms Query memory: 0.024 MB Memory before query: 6.538 MB Rows returned: 3

    SELECT a.id,a.catid,a.imageurl,a.flash,a.cloud_imageurl,a.imagealt,a.type,a.customcode,a.startdate,a.enddate,a.lastreset,a.impmade,a.clicks,a.maximpressions,a.maxclicks,a.linkid,a.language,a.newwin,a.restrictbyid,a.dailyimpressions,s.height,s.width
    
      FROM jom3_flexbanners AS a
    
      INNER JOIN jom3_flexbannerssize AS s USING (sizeid)
    
      INNER JOIN jom3_categories AS c
    
      WHERE a.locationid = 2  
      AND a.state = 1 
      AND a.finished = 0 
      AND (a.language = "en-GB" or a.language = "*") 
      AND c.id = a.catid 
      AND c.access IN ( 1,1,5 )

    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	24	Using where
    1	SIMPLE	s	eq_ref	PRIMARY	PRIMARY	4	3dallusions_joomla_d9.a.sizeid	1
    1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	3dallusions_joomla_d9.a.catid	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.03 ms
    Optimizing	0.01 ms
    Statistics	0.02 ms
    Preparing	0.01 ms
    Executing	0.00 ms
    Sending data	0.13 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
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    17	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:136
    16	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-rooms/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-rooms/layouts/theme.php:188
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

59. Query Time: 0.08 ms After last query: 0.05 ms Query memory: 0.024 MB Memory before query: 6.558 MB Rows returned: 1

    SELECT *
    
      FROM jom3_flexbanners
    
      WHERE `id` = '1'

    Explain

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

    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.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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
    18	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:747
    17	Joomla\CMS\Table\Table->load()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:163
    16	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-rooms/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-rooms/layouts/theme.php:188
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

60. Query Time: 0.18 ms After last query: 0.08 ms Query memory: 0.009 MB Memory before query: 6.571 MB

    UPDATE `jom3_flexbanners` 
      SET `clientid`='1',`linkid`='2',`sizeid`='8',`imageurl`='images/banners/Corona_728x90.jpg',`imagealt`='',`customcode`='<a href=\"https://corona-renderer.com/\" target=\"_blank\"><img src=\"http://www.3dallusions.com/images/banners/Corona_728x90.jpg\" VSPACE=\"5\" border=\"0\" /></a>',`restrictbyid`='0',`frontpage`='0',`clicks`='3231',`impmade`='8910759',`startdate`='0000-00-00 00:00:00',`enddate`='0000-00-00 00:00:00',`maximpressions`='0',`maxclicks`='0',`dailyimpressions`='2655',`lastreset`='2025-01-27',`state`='1',`finished`='0',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`locationid`='2',`type`='0',`name`='Corona_728x90',`flash`='',`cloud_imageurl`='',`published`='0',`catid`='93',`ordering`='1',`created`='2017-01-16 00:14:01',`created_by`='0',`created_by_alias`='0',`language`='*',`newwin`='1',`modified`='2018-08-27 05:08:12',`modified_by`='30205',`params`='',`version`='11' 
      WHERE `id` = '1'

    Explain

    EXPLAIN not possible on query: UPDATE `jom3_flexbanners` SET `clientid`='1',`linkid`='2',`sizeid`='8',`imageurl`='images/banners/Corona_728x90.jpg',`imagealt`='',`customcode`='<a href=\"https://corona-renderer.com/\" target=\"_blank\"><img src=\"http://www.3dallusions.com/images/banners/Corona_728x90.jpg\" VSPACE=\"5\" border=\"0\" /></a>',`restrictbyid`='0',`frontpage`='0',`clicks`='3231',`impmade`='8910759',`startdate`='0000-00-00 00:00:00',`enddate`='0000-00-00 00:00:00',`maximpressions`='0',`maxclicks`='0',`dailyimpressions`='2655',`lastreset`='2025-01-27',`state`='1',`finished`='0',`checked_out`='0',`checked_out_time`='0000-00-00 00:00:00',`locationid`='2',`type`='0',`name`='Corona_728x90',`flash`='',`cloud_imageurl`='',`published`='0',`catid`='93',`ordering`='1',`created`='2017-01-16 00:14:01',`created_by`='0',`created_by_alias`='0',`language`='*',`newwin`='1',`modified`='2018-08-27 05:08:12',`modified_by`='30205',`params`='',`version`='11' WHERE `id` = '1'

    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 for update	0.01 ms
    Updating	0.02 ms
    End of update loop	0.00 ms
    Query end	0.00 ms
    Commit	0.09 ms
    Writing to binlog	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
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:2304
    18	JDatabaseDriver->updateObject()	JROOT/libraries/src/Table/Table.php:817
    17	Joomla\CMS\Table\Table->store()	JROOT/modules/mod_flexbanners/mod_flexbanners.php:201
    16	include JROOT/modules/mod_flexbanners/mod_flexbanners.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-rooms/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-rooms/layouts/theme.php:188
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

61. Query Time: 0.08 ms After last query: 1.33 ms Query memory: 0.027 MB Memory before query: 6.629 MB Rows returned: 0

    SELECT * 
      FROM `jom3_social_themes` 
      WHERE `element` = 'wireframe'

    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.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
    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
    28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    27	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:46
    26	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    25	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/themes.php:247
    24	EasySocialModelThemes->getParams()	JROOT/administrator/components/com_easysocial/includes/template/template.php:96
    23	SocialTemplate->getConfig()	JROOT/administrator/components/com_easysocial/includes/template/template.php:56
    22	SocialTemplate->__construct()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:33
    21	SocialThemes->__construct()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:48
    20	SocialThemes::factory()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:193
    19	ES::__callStatic()	JROOT/administrator/components/com_easysocial/includes/stylesheet/stylesheet.php:852
    18	SocialStylesheet->attach()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:57
    17	ES::initialize()	JROOT/modules/mod_easysocial_login/mod_easysocial_login.php:24
    16	include JROOT/modules/mod_easysocial_login/mod_easysocial_login.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-rooms/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-rooms/layouts/theme.php:204
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

62. Query Time: 0.06 ms After last query: 0.14 ms Query memory: 0.027 MB Memory before query: 6.664 MB Rows returned: 5

    SELECT * 
      FROM `jom3_social_backgrounds` 
      WHERE `state`='1'

    Explain

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

    Profile

    Status	Duration
    Starting	0.00 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.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
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    25	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:46
    24	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    23	SocialDb->__call()	JROOT/administrator/components/com_easysocial/models/background.php:100
    22	EasySocialModelBackground->getPresetBackgrounds()	JROOT/components/com_easysocial/themes/wireframe/structure/custom.css.php:124
    21	include JROOT/components/com_easysocial/themes/wireframe/structure/custom.css.php	JROOT/administrator/components/com_easysocial/includes/template/template.php:261
    20	SocialTemplate->parse()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:226
    19	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/stylesheet/stylesheet.php:853
    18	SocialStylesheet->attach()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:57
    17	ES::initialize()	JROOT/modules/mod_easysocial_login/mod_easysocial_login.php:24
    16	include JROOT/modules/mod_easysocial_login/mod_easysocial_login.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-rooms/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-rooms/layouts/theme.php:204
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

63. Query Time: 0.30 ms After last query: 3.02 ms Query memory: 0.027 MB Memory before query: 8.496 MB Rows returned: 5

    SELECT * 
      FROM `jom3_menu` 
      WHERE `published` = '1' 
      AND `link` LIKE 'index.php?option=com_easysocial%' 
      AND `client_id` = '0'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jom3_menu	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	123	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.00 ms
    Executing	0.00 ms
    Sending data	0.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.00 ms

    Call Stack

    #	Caller	File and line number
    26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
    25	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:46
    24	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    23	SocialDb->__call()	JROOT/administrator/components/com_easysocial/includes/router.php:673
    22	ESR::getMenus()	JROOT/administrator/components/com_easysocial/includes/router.php:892
    21	ESR::getItemId()	JROOT/administrator/components/com_easysocial/includes/router/router.php:362
    20	SocialRouterAdapter->route()	JROOT/administrator/components/com_easysocial/includes/router/router.php:118
    19	SocialRouter->route()	JROOT/administrator/components/com_easysocial/includes/router.php:1086
    18	ESR::__callStatic()	JROOT/modules/mod_easysocial_login/tmpl/horizontal.php:28
    17	require JROOT/modules/mod_easysocial_login/tmpl/horizontal.php	JROOT/modules/mod_easysocial_login/mod_easysocial_login.php:42
    16	include JROOT/modules/mod_easysocial_login/mod_easysocial_login.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-rooms/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-rooms/layouts/theme.php:204
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

64. Query Time: 0.11 ms After last query: 0.21 ms Query memory: 0.028 MB Memory before query: 8.520 MB Rows returned: 1

    SELECT template 
      FROM `jom3_template_styles` AS s 
      LEFT JOIN `jom3_extensions` AS e 
      ON e.type = `template` 
      AND e.element=s.template 
      AND e.client_id=s.client_id 
      WHERE s.client_id = '1' 
      AND home = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	s	ref	idx_client_id,idx_client_id_home	idx_client_id	1	const	2	Using where
    1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	extension	484	3dallusions_joomla_d9.s.template,3dallusions_joomla_d9.s.template	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.01 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.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
    30	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
    29	JDatabaseDriver->loadResult()	JROOT/administrator/components/com_easysocial/includes/db/helpers/base.php:46
    28	SocialDBHelper->__call()	JROOT/administrator/components/com_easysocial/includes/db/db.php:303
    27	SocialDb->__call()	JROOT/administrator/components/com_easysocial/includes/assets/assets.php:279
    26	SocialAssets::getJoomlaTemplate()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:187
    25	SocialThemes::resolve()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:491
    24	ES::call()	JROOT/administrator/components/com_easysocial/includes/easysocial.php:1396
    23	ES::resolve()	JROOT/administrator/components/com_easysocial/includes/template/template.php:127
    22	SocialTemplate->getTemplate()	JROOT/administrator/components/com_easysocial/includes/themes/themes.php:223
    21	SocialThemes->output()	JROOT/administrator/components/com_easysocial/includes/template/helpers/form.php:150
    20	ThemesHelperForm->token()	JROOT/administrator/components/com_easysocial/includes/template/template.php:364
    19	SocialTemplate->html()	JROOT/administrator/components/com_easysocial/includes/modules/modules.php:481
    18	SocialModules->html()	JROOT/modules/mod_easysocial_login/tmpl/horizontal.php:76
    17	require JROOT/modules/mod_easysocial_login/tmpl/horizontal.php	JROOT/modules/mod_easysocial_login/mod_easysocial_login.php:42
    16	include JROOT/modules/mod_easysocial_login/mod_easysocial_login.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
    15	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
    14	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:92
    13	Warp\Joomla\Helper\WidgetsHelper->load()	JROOT/templates/jp-rooms/warp/systems/joomla/layouts/widgets.php:10
    12	include JROOT/templates/jp-rooms/warp/systems/joomla/layouts/widgets.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    11	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/warp/systems/joomla/src/Warp/Joomla/Helper/WidgetsHelper.php:69
    10	Warp\Joomla\Helper\WidgetsHelper->render()	JROOT/templates/jp-rooms/layouts/theme.php:204
    9	include JROOT/templates/jp-rooms/layouts/theme.php	JROOT/templates/jp-rooms/warp/src/Warp/Helper/TemplateHelper.php:49
    8	Warp\Helper\TemplateHelper->render()	JROOT/templates/jp-rooms/index.php:16
    7	require JROOT/templates/jp-rooms/index.php	JROOT/libraries/src/Document/HtmlDocument.php:678
    6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:740
    5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:555
    4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1098
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

65. Query Time: 0.07 ms After last query: 0.49 ms Query memory: 0.023 MB Memory before query: 8.472 MB Rows returned: 0

    SELECT *
     
      FROM jom3_jmap_metainfo
     
      WHERE `linkurl` = 'https://www.3dallusions.com/forums/design-challanges-charrettes-themed-challenges/3474-charette-15-quinta-house.html'
     
      AND `published` = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
    1	SIMPLE	jom3_jmap_metainfo	ref	published	published	1	const	1	Using where

    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.01 ms
    Statistics	0.01 ms
    Preparing	0.00 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.00 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/jmap/jmap.php:429
    12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

66. Query Time: 0.05 ms After last query: 0.01 ms Query memory: 0.021 MB Memory before query: 8.479 MB Rows returned: 0

    SELECT *
     
      FROM jom3_jmap_canonicals
     
      WHERE `linkurl` = 'https://www.3dallusions.com/forums/design-challanges-charrettes-themed-challenges/3474-charette-15-quinta-house.html'

    Explain

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

    Profile

    Status	Duration
    Starting	0.00 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.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
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    13	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:508
    12	plgSystemJMap->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

67. Query Time: 0.05 ms After last query: 0.39 ms Query memory: 0.030 MB Memory before query: 8.512 MB Rows returned: 2

    SELECT `key`, `value` 
      FROM `jom3_forai_config`;

    Explain

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

    Profile

    Status	Duration
    Starting	0.00 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.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
    34	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
    33	JDatabaseDriver->loadAssocList()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/platform/joomla/dbconnection.php:98
    32	Weeblr\Wblib\Forai\Platform\Joomla\Dbconnection->loadAssocList()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/db/db.php:477
    31	Weeblr\Wblib\Forai\Db\Db->loadAssocList()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/db/helper.php:213
    30	Weeblr\Wblib\Forai\Db\Helper->selectAssocList()	JROOT/plugins/system/forai/vendor/weeblr/forai/model/config.php:117
    29	Weeblr\Forai\Model\Config->preload()	JROOT/plugins/system/forai/vendor/weeblr/forai/model/config.php:79
    28	Weeblr\Forai\Model\Config->__construct()	JROOT/plugins/system/forai/vendor/weeblr/forai/factory.php:78
    27	Weeblr\Forai\ForaiApp->Weeblr\Forai\{closure}()	Same as call in the line below.
    26	call_user_func_array()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/platform/joomla/platform.php:2269
    25	Weeblr\Wblib\Forai\Platform\JoomlaPlatform->executeHook()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/system/hook.php:176
    24	Weeblr\Wblib\Forai\System\Hook->execute()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/system/hook.php:151
    23	Weeblr\Wblib\Forai\System\Hook->filter()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/factory.php:307
    22	Weeblr\Wblib\Forai\Factory->buildObject()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/factory.php:244
    21	Weeblr\Wblib\Forai\Factory->getObject()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/factory.php:130
    20	Weeblr\Wblib\Forai\Factory->getThis()	JROOT/plugins/system/forai/vendor/weeblr/forai/controller/assistant.php:137
    19	Weeblr\Forai\Controller\Assistant->canInjectAssistant()	JROOT/plugins/system/forai/vendor/weeblr/forai/controller/assistant.php:235
    18	Weeblr\Forai\Controller\Assistant->shouldInjectAssistant()	JROOT/plugins/system/forai/vendor/weeblr/forai/controller/assistant.php:321
    17	Weeblr\Forai\Controller\Assistant->injectAssets()	Same as call in the line below.
    16	call_user_func_array()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/platform/joomla/platform.php:2273
    15	Weeblr\Wblib\Forai\Platform\JoomlaPlatform->executeHook()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/system/hook.php:180
    14	Weeblr\Wblib\Forai\System\Hook->execute()	JROOT/plugins/system/forai/vendor/weeblr/wblib/v2/packages/system/hook.php:116
    13	Weeblr\Wblib\Forai\System\Hook->run()	JROOT/plugins/system/forai/forai.php:393
    12	plgSystemForai->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:70
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    10	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    9	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67
    8	Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead()	JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38
    7	Joomla\CMS\Document\Renderer\Html\HeadRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:511
    6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:803
    5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:577
    4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1112
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---

68. Query Time: 0.05 ms After last query: 0.52 ms Query memory: 0.020 MB Memory before query: 8.738 MB Rows returned: 0

    SELECT *
     
      FROM jom3_jmap_headings
     
      WHERE `linkurl` = 'https://www.3dallusions.com/forums/design-challanges-charrettes-themed-challenges/3474-charette-15-quinta-house.html'

    Explain

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

    Profile

    Status	Duration
    Starting	0.00 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.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
    9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
    8	JDatabaseDriver->loadObject()	JROOT/plugins/system/jmap/jmap.php:824
    7	plgSystemJMap->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
    4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1118
    3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
    2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
    1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

    ---