Joomla! Debug Console

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1638968702,
                "last": 1638968702,
                "now": 1638968702
            },
            "token": "8bKB2LMuOT92YBikfu8j2Mgh7heXbVKi"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        },
        "plg_system_languagefilter": {
            "language": "en-GB"
        }
    }
}

Time

Memory

16 Queries Logged 14.13 ms

1. Query Time: 0.47 ms Query memory: 0.023 MB Memory before query: 0.657 MB Rows returned: 0

   SELECT `data`
   
     FROM `abcde_session`
   
     WHERE `session_id` = 'rsv0rjjke8thr4cs48kvcp4oq4'

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   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:82
   10	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:648
   9	JSession->_start()	JROOT/libraries/joomla/session/session.php:608
   8	JSession->start()	JROOT/libraries/joomla/session/session.php:486
   7	JSession->get()	JROOT/libraries/joomla/session/session.php:443
   6	JSession->isNew()	JROOT/libraries/cms/application/cms.php:830
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::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.30 ms After last query: 0.39 ms Query memory: 0.019 MB Memory before query: 0.672 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `abcde_session`
   
     WHERE `session_id` = 'rsv0rjjke8thr4cs48kvcp4oq4' 
     LIMIT 1

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:832
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::getApplication()	JROOT/index.php:46

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

   ---

3. Query Time: 4.32 ms After last query: 0.11 ms Query memory: 0.003 MB Memory before query: 0.677 MB

   INSERT INTO `abcde_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('rsv0rjjke8thr4cs48kvcp4oq4', 1, '1638968702', 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `abcde_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('rsv0rjjke8thr4cs48kvcp4oq4', 1, '1638968702', 0, '', 0)

   Profile

   Status	Duration
   starting	0.05 ms
   checking permissions	0.01 ms
   Opening tables	0.01 ms
   init	0.02 ms
   System lock	0.01 ms
   update	0.09 ms
   end	0.01 ms
   query end	3.82 ms
   closing tables	0.03 ms
   freeing items	0.03 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:216
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:832
   5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
   4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
   3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:413
   2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
   1	JFactory::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.47 ms After last query: 1.37 ms Query memory: 0.021 MB Memory before query: 0.757 MB Rows returned: 5

   SELECT id, rules
   
     FROM `abcde_viewlevels`

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:1061
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->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.52 ms After last query: 0.16 ms Query memory: 0.021 MB Memory before query: 0.769 MB Rows returned: 2

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

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1530
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:978
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:1093
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:453
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:309
   6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
   5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
   4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:603
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->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.45 ms After last query: 12.70 ms Query memory: 0.021 MB Memory before query: 2.260 MB Rows returned: 4

   select id, title, alias 
     from abcde_jumi 
     where published = 1

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1791
   11	JDatabaseDriver->loadRowList()	JROOT/plugins/system/jumirouter/jumirouter.php:57
   10	parseJumiRouter()	JROOT/libraries/cms/router/router.php:597
   9	JRouter->processParseRules()	JROOT/libraries/cms/router/site.php:584
   8	JRouterSite->processParseRules()	JROOT/libraries/cms/router/router.php:571
   7	JRouter->_processParseRules()	JROOT/libraries/cms/router/router.php:225
   6	JRouter->parse()	JROOT/libraries/cms/router/site.php:133
   5	JRouterSite->parse()	JROOT/libraries/cms/application/cms.php:1147
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->execute()	JROOT/index.php:49

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

   ---

7. Query Time: 1.91 ms After last query: 0.51 ms Query memory: 0.006 MB Memory before query: 2.270 MB

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

   Explain

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

   Profile

   Status	Duration
   starting	0.07 ms
   checking permissions	0.01 ms
   Opening tables	0.03 ms
   init	0.02 ms
   System lock	0.09 ms
   updating	0.08 ms
   end	0.01 ms
   query end	1.42 ms
   closing tables	0.03 ms
   freeing items	0.03 ms
   cleaning up	0.03 ms

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:116
   13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:321
   12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:280
   11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:760
   10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
   9	JFactory::getDocument()	JROOT/plugins/system/k2/k2.php:460
   8	plgSystemK2->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1156
   4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:795
   3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->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.99 ms After last query: 5.84 ms Query memory: 0.077 MB Memory before query: 2.819 MB Rows returned: 1

   SELECT a.*, a.tagids AS spsimpleportfolio_tag_id, a.created AS created_on,l.title AS language_title,ua.name AS author_name
   
     FROM abcde_spsimpleportfolio_items as a
   
     LEFT JOIN `abcde_languages` AS l 
     ON l.lang_code = a.language
   
     LEFT JOIN abcde_users AS ua 
     ON ua.id = a.created_by
   
     WHERE a.id = 35 
     AND a.published = 1 
     AND a.language in ('en-GB','*')

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	a	NULL	const	PRIMARY	PRIMARY	8	const	1	100.00	NULL
   1	SIMPLE	l	NULL	const	idx_langcode	idx_langcode	28	const	1	100.00	NULL
   1	SIMPLE	ua	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

   Profile

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

   Call Stack

   #	Caller	File and line number
   13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1642
   12	JDatabaseDriver->loadObject()	JROOT/components/com_spsimpleportfolio/models/item.php:55
   11	SpsimpleportfolioModelItem->getItem()	JROOT/libraries/legacy/view/legacy.php:422
   10	JViewLegacy->get()	JROOT/components/com_spsimpleportfolio/views/item/view.html.php:21
   9	SpsimpleportfolioViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
   8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:709
   7	JControllerLegacy->execute()	JROOT/components/com_spsimpleportfolio/spsimpleportfolio.php:14
   6	require_once JROOT/components/com_spsimpleportfolio/spsimpleportfolio.php	JROOT/libraries/cms/component/helper.php:389
   5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
   4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
   3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->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.31 ms After last query: 0.29 ms Query memory: 0.023 MB Memory before query: 2.866 MB Rows returned: 1

   SELECT `id`,`title`,`alias`
   
     FROM `abcde_spsimpleportfolio_tags`
   
     WHERE `id` IN (10)
   
     ORDER BY id ASC

   Explain

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

   Profile

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

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
   13	JDatabaseDriver->loadObjectList()	JROOT/components/com_spsimpleportfolio/models/items.php:169
   12	SpsimpleportfolioModelItems->getItemTags()	JROOT/components/com_spsimpleportfolio/models/item.php:64
   11	SpsimpleportfolioModelItem->getItem()	JROOT/libraries/legacy/view/legacy.php:422
   10	JViewLegacy->get()	JROOT/components/com_spsimpleportfolio/views/item/view.html.php:21
   9	SpsimpleportfolioViewItem->display()	JROOT/libraries/legacy/controller/legacy.php:671
   8	JControllerLegacy->display()	JROOT/libraries/legacy/controller/legacy.php:709
   7	JControllerLegacy->execute()	JROOT/components/com_spsimpleportfolio/spsimpleportfolio.php:14
   6	require_once JROOT/components/com_spsimpleportfolio/spsimpleportfolio.php	JROOT/libraries/cms/component/helper.php:389
   5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:364
   4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
   3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
   1	JApplicationCms->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.62 ms After last query: 1.10 ms Query memory: 0.023 MB Memory before query: 2.914 MB Rows returned: 6

    SHOW FULL COLUMNS 
      FROM `abcde_template_styles`

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    12	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:244
    11	JTable->getFields()	JROOT/libraries/joomla/table/table.php:163
    10	JTable->__construct()	JROOT/administrator/components/com_templates/tables/style.php:30
    9	TemplatesTableStyle->__construct()	JROOT/libraries/joomla/table/table.php:311
    8	JTable::getInstance()	JROOT/plugins/system/helix3/helix3.php:37
    7	plgSystemHelix3->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->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.32 ms After last query: 0.28 ms Query memory: 0.021 MB Memory before query: 2.931 MB Rows returned: 1

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

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1445
    9	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:729
    8	JTable->load()	JROOT/plugins/system/helix3/helix3.php:38
    7	plgSystemHelix3->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

12. Query Time: 1.06 ms After last query: 1.63 ms Query memory: 0.027 MB Memory before query: 2.987 MB Rows returned: 45

    SELECT `id`,`name`,`rules`,`parent_id`
    
      FROM `abcde_assets`
    
      WHERE `name` IN ('root.1','com_acymailing','com_admin','com_ajax','com_akeeba','com_artadminer','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creditbureau','com_dpattachments','com_fields','com_finder','com_helloworld','com_installer','com_joomlaupdate','com_jumi','com_jvframework','com_jvportfolio','com_jvss','com_k2','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_redirect','com_search','com_sppagebuilder','com_spsimpleportfolio','com_tags','com_templates','com_users','com_vchart','com_wrapper')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	abcde_assets	NULL	range	idx_asset_name	idx_asset_name	202	NULL	47	100.00	Using index condition

    Profile

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

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    16	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/access/access.php:427
    15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:211
    14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:529
    13	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:181
    12	JAccess::check()	JROOT/libraries/joomla/user/user.php:393
    11	JUser->authorise()	JROOT/plugins/system/sourcerer/src/Params.php:42
    10	RegularLabs\Plugin\System\Sourcerer\Params::get()	JROOT/plugins/system/sourcerer/src/Plugin.php:167
    9	RegularLabs\Plugin\System\Sourcerer\Plugin->passChecks()	JROOT/plugins/system/sourcerer/src/Plugin.php:57
    8	RegularLabs\Plugin\System\Sourcerer\Plugin->run()	JROOT/plugins/system/sourcerer/sourcerer.php:57
    7	PlgSystemSourcerer->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->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.79 ms After last query: 0.88 ms Query memory: 0.021 MB Memory before query: 3.097 MB Rows returned: 3

    SELECT language,id
    
      FROM `abcde_menu`
    
      WHERE home = 1 
      AND published = 1 
      AND client_id = 0

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	abcde_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	218	1.00	Using where

    Profile

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

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:106
    8	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:718
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/site.php:196
    3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:265
    1	JApplicationCms->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.58 ms After last query: 19.27 ms Query memory: 0.033 MB Memory before query: 3.767 MB Rows returned: 130

    SELECT * 
      FROM abcde_acymailing_config

    Explain

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

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/cpanel.php:17
    13	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:392
    12	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1369
    11	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/modules/mod_acymailing/mod_acymailing.php:12
    10	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/cms/module/helper.php:198
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1117
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->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.44 ms After last query: 0.64 ms Query memory: 0.022 MB Memory before query: 3.866 MB Rows returned: 2

    SELECT * 
      FROM abcde_acymailing_list 
      WHERE type = 'list'  
      ORDER BY ordering ASC

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	abcde_acymailing_list	NULL	ref	typeorderingindex,typeuseridindex	typeorderingindex	1	const	2	100.00	Using index condition

    Profile

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

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_acymailing/classes/list.php:30
    11	listClass->getLists()	JROOT/modules/mod_acymailing/mod_acymailing.php:104
    10	include JROOT/modules/mod_acymailing/mod_acymailing.php	JROOT/libraries/cms/module/helper.php:198
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1117
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->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.59 ms After last query: 1.71 ms Query memory: 0.023 MB Memory before query: 3.961 MB Rows returned: 2

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `abcde_menu` AS `c`
    
      INNER JOIN `abcde_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `abcde_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `abcde_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 854

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	c	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using index
    1	SIMPLE	a	NULL	const	PRIMARY,idx_key	PRIMARY	206	const,const	1	100.00	NULL
    1	SIMPLE	a2	NULL	ref	idx_key	idx_key	128	const	2	100.00	Using index
    1	SIMPLE	c2	NULL	eq_ref	PRIMARY	PRIMARY	4	rhsmed1.a2.id	1	100.00	NULL

    Profile

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

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    14	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
    13	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:314
    12	MenusHelper::getAssociations()	JROOT/modules/mod_languages/helper.php:61
    11	ModLanguagesHelper::getList()	JROOT/modules/mod_languages/mod_languages.php:17
    10	include JROOT/modules/mod_languages/mod_languages.php	JROOT/libraries/cms/module/helper.php:198
    9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
    8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
    7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:486
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:777
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:552
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1117
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:777
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:271
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

16 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 1 × SELECT `data` 
     FROM `abcde_session`

2. 1 × SELECT `session_id` 
     FROM `abcde_session`

3. 1 × SELECT id, rules 
     FROM `abcde_viewlevels

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

5. 1 × select id, title, alias 
     from abcde_jumi

6. 1 × SELECT a.*, a.tagids AS spsimpleportfolio_tag_id, a.created AS created_on,l.title AS language_title,ua.name AS author_name 
     FROM abcde_spsimpleportfolio_items as a 
     LEFT JOIN `abcde_languages` AS l 
     ON l.lang_code = a.language 
     LEFT JOIN abcde_users AS ua 
     ON ua.id = a.created_by

7. 1 × SELECT `id`,`title`,`alias` 
     FROM `abcde_spsimpleportfolio_tags`

8. 1 × SELECT * 
     FROM abcde_template_styles

9. 1 × SELECT `id`,`name`,`rules`,`parent_id` 
     FROM `abcde_assets`

10. 1 × SELECT language,id 
      FROM `abcde_menu`

11. 1 × SELECT * 
      FROM abcde_acymailing_confi

12. 1 × SELECT * 
      FROM abcde_acymailing_list

13. 1 × SELECT `c2`.`language`,`c2`.`id` 
      FROM `abcde_menu` AS `c` 
      INNER JOIN `abcde_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item' 
      INNER JOIN `abcde_associations` AS `a2` 
      ON a.key = a2.key 
      INNER JOIN `abcde_menu` AS `c2` 
      ON a2.id = c2.`id`

OTHER Tables:

1. 1 × INSERT INTO `abcde_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  ('rsv0rjjke8thr4cs48kvcp4oq4', 1, '1638968702', 0, '', 0

2. 1 × UPDATE `abcde_extensions` 
     SET `params` = '{\"mediaversion\":\"fb859d88d97a77151c4a1091ae299b24\"}'

3. 1 × SHOW FULL COLUMNS 
     FROM `abcde_template_styles