Joomla! Debug Console

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1679800300,
                "last": 1679800300,
                "now": 1679800300
            },
            "client": {
                "forwarded": "3.236.241.39"
            }
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Time

Memory

28 Queries Logged 30.89 ms

1. Query Time: 1.11 ms Query memory: 0.024 MB Memory before query: 0.734 MB Rows returned: 0

   SELECT `data`
   
     FROM `edmyp_session`
   
     WHERE `session_id` = 'e60cb770dbcee660d4f01dbbf66b68bb'

   Explain

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

   Profile

   Status	Duration
   starting	0.19 ms
   Waiting for query cache lock	0.10 ms
   starting	0.08 ms
   checking query cache for query	0.07 ms
   checking permissions	0.03 ms
   Opening tables	0.05 ms
   init	0.05 ms
   System lock	0.03 ms
   Waiting for query cache lock	0.02 ms
   System lock	0.05 ms
   optimizing	0.04 ms
   statistics	0.08 ms
   executing	0.03 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.03 ms
   freeing items	0.03 ms
   Waiting for query cache lock	0.02 ms
   freeing items	0.05 ms
   Waiting for query cache lock	0.02 ms
   freeing items	0.02 ms
   storing result in query cache	0.02 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
   12	JSessionStorageDatabase->read()	Same as call in the line below.
   11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
   10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
   9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
   8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
   7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
   6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
   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:408
   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.70 ms After last query: 0.99 ms Query memory: 0.021 MB Memory before query: 0.753 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `edmyp_session`
   
     WHERE `session_id` = 'e60cb770dbcee660d4f01dbbf66b68bb' 
     LIMIT 1

   Explain

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

   Profile

   Status	Duration
   starting	0.11 ms
   Waiting for query cache lock	0.03 ms
   starting	0.02 ms
   checking query cache for query	0.05 ms
   checking permissions	0.03 ms
   Opening tables	0.03 ms
   init	0.03 ms
   System lock	0.02 ms
   Waiting for query cache lock	0.02 ms
   System lock	0.03 ms
   optimizing	0.02 ms
   statistics	0.04 ms
   executing	0.03 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.02 ms
   freeing items	0.02 ms
   Waiting for query cache lock	0.02 ms
   freeing items	0.05 ms
   Waiting for query cache lock	0.02 ms
   freeing items	0.02 ms
   storing result in query cache	0.08 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   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:408
   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: 0.82 ms After last query: 0.13 ms Query memory: 0.003 MB Memory before query: 0.758 MB

   INSERT INTO `edmyp_session`
   (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
     VALUES 
   ('e60cb770dbcee660d4f01dbbf66b68bb', 0, 1, '1679800300', 0, '')

   Explain

   EXPLAIN not possible on query: INSERT INTO `edmyp_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('e60cb770dbcee660d4f01dbbf66b68bb', 0, 1, '1679800300', 0, '')

   Profile

   Status	Duration
   starting	0.06 ms
   checking permissions	0.03 ms
   Opening tables	0.03 ms
   init	0.03 ms
   System lock	0.02 ms
   update	0.35 ms
   Waiting for query cache lock	0.03 ms
   update	0.03 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.06 ms
   freeing items	0.05 ms
   cleaning up	0.03 ms

   Call Stack

   #	Caller	File and line number
   7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
   6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
   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:408
   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: 1.10 ms After last query: 1.47 ms Query memory: 0.022 MB Memory before query: 0.877 MB Rows returned: 2

   SELECT b.id
   
     FROM edmyp_usergroups AS a
   
     LEFT JOIN edmyp_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	3	100.00	Using where

   Profile

   Status	Duration
   starting	0.10 ms
   Waiting for query cache lock	0.02 ms
   starting	0.02 ms
   checking query cache for query	0.07 ms
   checking permissions	0.03 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   init	0.04 ms
   System lock	0.03 ms
   Waiting for query cache lock	0.02 ms
   System lock	0.03 ms
   optimizing	0.09 ms
   statistics	0.14 ms
   preparing	0.05 ms
   executing	0.02 ms
   Sending data	0.06 ms
   end	0.02 ms
   query end	0.03 ms
   closing tables	0.04 ms
   freeing items	0.03 ms
   Waiting for query cache lock	0.02 ms
   freeing items	0.05 ms
   Waiting for query cache lock	0.03 ms
   freeing items	0.02 ms
   storing result in query cache	0.02 ms
   cleaning up	0.19 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
   10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
   9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   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:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   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.72 ms After last query: 0.22 ms Query memory: 0.023 MB Memory before query: 0.883 MB Rows returned: 5

   SELECT id, rules
   
     FROM `edmyp_viewlevels`

   Explain

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

   Profile

   Status	Duration
   starting	0.03 ms
   Waiting for query cache lock	0.02 ms
   starting	0.02 ms
   checking query cache for query	0.04 ms
   checking permissions	0.03 ms
   Opening tables	0.03 ms
   init	0.03 ms
   System lock	0.03 ms
   Waiting for query cache lock	0.02 ms
   System lock	0.03 ms
   optimizing	0.02 ms
   statistics	0.03 ms
   preparing	0.03 ms
   executing	0.02 ms
   Sending data	0.07 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.03 ms
   freeing items	0.02 ms
   Waiting for query cache lock	0.02 ms
   freeing items	0.05 ms
   Waiting for query cache lock	0.02 ms
   freeing items	0.02 ms
   storing result in query cache	0.06 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
   9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
   8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
   7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
   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:599
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   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: 1.19 ms After last query: 4.64 ms Query memory: 0.022 MB Memory before query: 1.279 MB Rows returned: 2

   SELECT element
   
     FROM edmyp_extensions
   
     WHERE type = 'language' 
     AND client_id = 0 
     AND enabled = 1

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	edmyp_extensions	NULL	ref	extension	extension	82	const	4	1.25	Using index condition; Using where

   Profile

   Status	Duration
   starting	0.07 ms
   Waiting for query cache lock	0.02 ms
   starting	0.02 ms
   checking query cache for query	0.08 ms
   checking permissions	0.03 ms
   Opening tables	0.05 ms
   init	0.05 ms
   System lock	0.03 ms
   Waiting for query cache lock	0.02 ms
   System lock	0.03 ms
   optimizing	0.04 ms
   statistics	0.23 ms
   preparing	0.06 ms
   executing	0.03 ms
   Sending data	0.08 ms
   end	0.03 ms
   query end	0.03 ms
   closing tables	0.03 ms
   freeing items	0.03 ms
   Waiting for query cache lock	0.02 ms
   freeing items	0.06 ms
   Waiting for query cache lock	0.03 ms
   freeing items	0.02 ms
   storing result in query cache	0.02 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:90
   8	JLanguageMultilang::getSiteLangs()	JROOT/plugins/system/languagefilter/languagefilter.php:108
   7	PlgSystemLanguageFilter->__construct()	JROOT/libraries/cms/plugin/helper.php:255
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:170
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:669
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   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: 0.72 ms After last query: 1.75 ms Query memory: 0.022 MB Memory before query: 1.394 MB Rows returned: 1

   SELECT count(*)
   
     FROM `edmyp_cwgears_schedule`

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	Select tables optimized away

   Profile

   Status	Duration
   starting	0.04 ms
   Waiting for query cache lock	0.02 ms
   starting	0.02 ms
   checking query cache for query	0.11 ms
   checking permissions	0.03 ms
   Opening tables	0.04 ms
   init	0.03 ms
   System lock	0.03 ms
   Waiting for query cache lock	0.02 ms
   System lock	0.03 ms
   optimizing	0.03 ms
   executing	0.03 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.04 ms
   freeing items	0.02 ms
   Waiting for query cache lock	0.02 ms
   freeing items	0.05 ms
   Waiting for query cache lock	0.03 ms
   freeing items	0.02 ms
   storing result in query cache	0.02 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:74
   8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   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.64 ms After last query: 0.10 ms Query memory: 0.022 MB Memory before query: 1.400 MB Rows returned: 1

   SELECT count(*)
   
     FROM `edmyp_cwgears_schedule`
   
     WHERE time + '86400'<'1679800300'

   Explain

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

   Profile

   Status	Duration
   starting	0.03 ms
   Waiting for query cache lock	0.02 ms
   starting	0.02 ms
   checking query cache for query	0.05 ms
   checking permissions	0.03 ms
   Opening tables	0.03 ms
   init	0.03 ms
   System lock	0.02 ms
   Waiting for query cache lock	0.02 ms
   System lock	0.03 ms
   optimizing	0.03 ms
   statistics	0.03 ms
   preparing	0.03 ms
   executing	0.03 ms
   end	0.02 ms
   query end	0.02 ms
   closing tables	0.02 ms
   freeing items	0.03 ms
   Waiting for query cache lock	0.02 ms
   freeing items	0.05 ms
   Waiting for query cache lock	0.02 ms
   freeing items	0.02 ms
   storing result in query cache	0.13 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
   9	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:96
   8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   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: 1.55 ms After last query: 0.60 ms Query memory: 0.034 MB Memory before query: 1.417 MB Rows returned: 8

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

   Explain

   id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	m	NULL	range	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	5	NULL	8	10.00	Using index condition; Using where; Using filesort
   1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	u512947.m.component_id	1	100.00	Using where

   Profile

   Status	Duration
   starting	0.06 ms
   Waiting for query cache lock	0.02 ms
   starting	0.02 ms
   checking query cache for query	0.10 ms
   checking permissions	0.03 ms
   checking permissions	0.02 ms
   Opening tables	0.04 ms
   init	0.05 ms
   System lock	0.03 ms
   Waiting for query cache lock	0.02 ms
   System lock	0.04 ms
   optimizing	0.07 ms
   statistics	0.09 ms
   preparing	0.05 ms
   Sorting result	0.03 ms
   executing	0.02 ms
   Sending data	0.03 ms
   Creating sort index	0.46 ms
   end	0.03 ms
   query end	0.03 ms
   closing tables	0.05 ms
   freeing items	0.03 ms
   Waiting for query cache lock	0.02 ms
   freeing items	0.06 ms
   Waiting for query cache lock	0.03 ms
   freeing items	0.02 ms
   storing result in query cache	0.03 ms
   cleaning up	0.02 ms

   Call Stack

   #	Caller	File and line number
   20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
   19	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
   18	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
   17	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
   16	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
   15	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
   14	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
   13	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
   12	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
   11	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
   10	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
   9	JApplicationSite::getRouter()	JROOT/plugins/system/languagefilter/languagefilter.php:130
   8	PlgSystemLanguageFilter->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
   7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
   6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
   5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
   3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
   2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
   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: 2.45 ms After last query: 6.09 ms Query memory: 0.029 MB Memory before query: 1.685 MB Rows returned: 8

    SHOW FULL COLUMNS 
      FROM `edmyp_assets`

    Explain

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

    Profile

    Status	Duration
    starting	0.14 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    Opening tables	0.92 ms
    init	0.04 ms
    System lock	0.03 ms
    optimizing	0.02 ms
    statistics	0.04 ms
    preparing	0.03 ms
    executing	0.05 ms
    Opening tables	0.12 ms
    checking permissions	0.12 ms
    checking permissions	0.07 ms
    checking permissions	0.09 ms
    checking permissions	0.05 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.05 ms
    Sending data	0.11 ms
    end	0.03 ms
    query end	0.07 ms
    closing tables	0.02 ms
    removing tmp table	0.07 ms
    closing tables	0.03 ms
    freeing items	0.06 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    15	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
    14	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
    13	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
    12	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    11	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    10	JUser->authorise()	JROOT/plugins/system/sourcerer/helper.php:73
    9	PlgSystemSourcererHelper->__construct()	JROOT/plugins/system/sourcerer/sourcerer.php:95
    8	PlgSystemSourcerer->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    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.85 ms After last query: 0.49 ms Query memory: 0.026 MB Memory before query: 1.713 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.02 ms
    starting	0.04 ms
    checking query cache for query	0.07 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    init	0.04 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.02 ms
    System lock	0.04 ms
    optimizing	0.03 ms
    statistics	0.09 ms
    preparing	0.03 ms
    executing	0.02 ms
    Sending data	0.03 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.02 ms
    storing result in query cache	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    14	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    13	JTable->load()	JROOT/libraries/joomla/access/access.php:697
    12	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
    11	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    10	JUser->authorise()	JROOT/plugins/system/sourcerer/helper.php:73
    9	PlgSystemSourcererHelper->__construct()	JROOT/plugins/system/sourcerer/sourcerer.php:95
    8	PlgSystemSourcerer->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    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.07 ms After last query: 0.15 ms Query memory: 0.023 MB Memory before query: 1.718 MB Rows returned: 1
    Duplicate queries: #13

    SELECT a.rules
    
      FROM edmyp_assets AS a
    
      WHERE (a.id = 1 OR a.name = 'root.1')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

    Profile

    Status	Duration
    starting	0.03 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    checking query cache for query	0.06 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    init	0.05 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.02 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	0.19 ms
    preparing	0.04 ms
    executing	0.02 ms
    Sending data	0.21 ms
    end	0.03 ms
    query end	0.04 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.02 ms
    storing result in query cache	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    12	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
    11	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
    10	JUser->authorise()	JROOT/plugins/system/sourcerer/helper.php:73
    9	PlgSystemSourcererHelper->__construct()	JROOT/plugins/system/sourcerer/sourcerer.php:95
    8	PlgSystemSourcerer->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    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.36 ms After last query: 0.47 ms Query memory: 0.023 MB Memory before query: 1.727 MB Rows returned: 1
    Duplicate queries: #12

    SELECT a.rules
    
      FROM edmyp_assets AS a
    
      WHERE (a.id = 1 OR a.name = 'root.1')

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	NULL	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,202	NULL	2	100.00	Using union(PRIMARY,idx_asset_name); Using where

    Profile

    Status	Duration
    starting	0.08 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    checking query cache for query	0.02 ms
    checking privileges on cached	0.02 ms
    checking permissions	0.02 ms
    sending cached result to clien	0.06 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    13	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
    12	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:176
    11	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    10	JUser->authorise()	JROOT/plugins/system/sourcerer/helper.php:73
    9	PlgSystemSourcererHelper->__construct()	JROOT/plugins/system/sourcerer/sourcerer.php:95
    8	PlgSystemSourcerer->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    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.85 ms After last query: 1.53 ms Query memory: 0.006 MB Memory before query: 1.765 MB

    UPDATE `edmyp_extensions`
    
      SET `params` = '{\"mediaversion\":\"401b98f36ae5941e0dd1ad70705bb3ae\"}'
    
      WHERE `type` = 'library' 
      AND `element` = 'joomla'

    Explain

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

    Profile

    Status	Duration
    starting	0.12 ms
    checking permissions	0.03 ms
    Opening tables	0.04 ms
    init	0.04 ms
    System lock	0.17 ms
    updating	0.14 ms
    end	0.03 ms
    Waiting for query cache lock	0.02 ms
    end	0.04 ms
    query end	0.02 ms
    closing tables	0.05 ms
    freeing items	0.08 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
    13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
    12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
    11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
    10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
    9	JFactory::getDocument()	JROOT/plugins/system/sl_scrolltotop/sl_scrolltotop.php:84
    8	plgSystemSL_ScrollToTop->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    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.93 ms After last query: 3.49 ms Query memory: 0.022 MB Memory before query: 1.904 MB Rows returned: 1

    SELECT count(*)
    
      FROM `edmyp_extensions`
    
      WHERE `element` = 'cwgears' 
      AND `extension_id` = ''

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

    Profile

    Status	Duration
    starting	0.10 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    checking query cache for query	0.06 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    init	0.04 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.02 ms
    System lock	0.03 ms
    optimizing	0.05 ms
    statistics	0.08 ms
    executing	0.03 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.12 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.02 ms
    storing result in query cache	0.06 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    10	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/cwgears.php:830
    9	plgSystemCwgears->updateDownloadKeySub()	JROOT/plugins/system/cwgears/cwgears.php:130
    8	plgSystemCwgears->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
    7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
    4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
    3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
    2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
    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.98 ms After last query: 2.51 ms Query memory: 0.028 MB Memory before query: 2.054 MB Rows returned: 34

    SELECT element
    
      FROM edmyp_extensions
    
      WHERE type = 'component' 
      AND enabled = '1'

    Explain

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

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    checking query cache for query	0.05 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.02 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	0.11 ms
    preparing	0.04 ms
    executing	0.02 ms
    Sending data	0.19 ms
    end	0.03 ms
    query end	0.02 ms
    closing tables	0.03 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.09 ms
    storing result in query cache	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
    19	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
    18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    15	JUser->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
    14	SppagebuilderModelPage->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    13	JModelLegacy->getState()	JROOT/components/com_sppagebuilder/models/page.php:41
    12	SppagebuilderModelPage->getItem()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:24
    10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
    8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    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:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

17. Query Time: 1.48 ms After last query: 0.16 ms Query memory: 0.030 MB Memory before query: 2.070 MB Rows returned: 34

    SELECT a.name, a.rules
    
      FROM edmyp_assets AS a
    
      WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_coalawebcontact','com_config','com_contact','com_contactus','com_content','com_contenthistory','com_cpanel','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_nexevocontact','com_plugins','com_postinstall','com_redirect','com_search','com_sppagebuilder','com_tags','com_templates','com_users','com_wrapper') OR a.name = 'root.1')

    Explain

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

    Profile

    Status	Duration
    starting	0.05 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    checking query cache for query	0.09 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    init	0.06 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.02 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	0.22 ms
    preparing	0.04 ms
    executing	0.02 ms
    Sending data	0.52 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.02 ms
    storing result in query cache	0.03 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
    19	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
    18	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
    17	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
    16	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
    15	JUser->authorise()	JROOT/components/com_sppagebuilder/models/page.php:29
    14	SppagebuilderModelPage->populateState()	JROOT/libraries/legacy/model/legacy.php:435
    13	JModelLegacy->getState()	JROOT/components/com_sppagebuilder/models/page.php:41
    12	SppagebuilderModelPage->getItem()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:24
    10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
    8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    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:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

18. Query Time: 1.22 ms After last query: 0.93 ms Query memory: 0.038 MB Memory before query: 2.258 MB Rows returned: 1

    SELECT a.*,l.title AS language_title,ua.name AS author_name
    
      FROM edmyp_sppagebuilder as a
    
      LEFT JOIN `edmyp_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN edmyp_users AS ua 
      ON ua.id = a.created_by
    
      WHERE a.id = 17 
      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	system	idx_langcode	NO INDEX KEY COULD BE USED	NULL	NULL	1	100.00	NULL
    1	SIMPLE	ua	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

    Profile

    Status	Duration
    starting	0.07 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    checking query cache for query	0.08 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.07 ms
    Opening tables	0.07 ms
    init	0.07 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.02 ms
    System lock	0.04 ms
    optimizing	0.04 ms
    statistics	0.12 ms
    preparing	0.03 ms
    executing	0.02 ms
    Sending data	0.10 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.05 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.07 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.02 ms
    storing result in query cache	0.03 ms
    cleaning up	0.09 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    13	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/models/page.php:82
    12	SppagebuilderModelPage->getItem()	JROOT/libraries/legacy/view/legacy.php:408
    11	JViewLegacy->get()	JROOT/components/com_sppagebuilder/views/page/view.html.php:24
    10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
    8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    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:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

19. Query Time: 2.43 ms After last query: 0.33 ms Query memory: 0.033 MB Memory before query: 2.282 MB Rows returned: 24

    SHOW FULL COLUMNS 
      FROM `edmyp_sppagebuilder`

    Explain

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

    Profile

    Status	Duration
    starting	0.05 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    Opening tables	0.79 ms
    init	0.03 ms
    System lock	0.02 ms
    optimizing	0.02 ms
    statistics	0.03 ms
    preparing	0.03 ms
    executing	0.06 ms
    Opening tables	0.07 ms
    checking permissions	0.11 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.08 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.06 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.04 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    checking permissions	0.03 ms
    Sending data	0.14 ms
    end	0.03 ms
    query end	0.02 ms
    closing tables	0.02 ms
    removing tmp table	0.07 ms
    closing tables	0.03 ms
    freeing items	0.05 ms
    cleaning up	0.03 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    17	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
    16	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
    15	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
    14	JTable->__construct()	JROOT/administrator/components/com_sppagebuilder/tables/page.php:17
    13	SppagebuilderTablePage->__construct()	JROOT/libraries/joomla/table/table.php:308
    12	JTable::getInstance()	JROOT/components/com_sppagebuilder/models/page.php:176
    11	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
    10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
    8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    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:261
    1	JApplicationCms->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.81 ms After last query: 0.21 ms Query memory: 0.031 MB Memory before query: 2.336 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    checking query cache for query	0.05 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    init	0.04 ms
    System lock	0.04 ms
    Waiting for query cache lock	0.02 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	0.05 ms
    preparing	0.03 ms
    executing	0.02 ms
    Sending data	0.05 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.03 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.07 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.02 ms
    storing result in query cache	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
    13	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
    12	JTable->load()	JROOT/components/com_sppagebuilder/models/page.php:177
    11	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
    10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
    8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    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:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

21. Query Time: 0.71 ms After last query: 0.25 ms Query memory: 0.006 MB Memory before query: 2.346 MB

    UPDATE edmyp_sppagebuilder
    
      SET `hits` = (`hits` + 1)
    
      WHERE `id` = '17'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	UPDATE	edmyp_sppagebuilder	NULL	range	PRIMARY	PRIMARY	8	const	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.11 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    init	0.05 ms
    System lock	0.11 ms
    updating	0.09 ms
    end	0.03 ms
    Waiting for query cache lock	0.02 ms
    end	0.03 ms
    query end	0.02 ms
    closing tables	0.04 ms
    freeing items	0.05 ms
    cleaning up	0.07 ms

    Call Stack

    #	Caller	File and line number
    13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1228
    12	JTable->hit()	JROOT/components/com_sppagebuilder/models/page.php:178
    11	SppagebuilderModelPage->hit()	JROOT/components/com_sppagebuilder/views/page/view.html.php:37
    10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
    8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    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:261
    1	JApplicationCms->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.87 ms After last query: 3.13 ms Query memory: 0.027 MB Memory before query: 2.665 MB Rows returned: 1

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

    Explain

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

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.04 ms
    starting	0.02 ms
    checking query cache for query	0.10 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.04 ms
    Waiting for query cache lock	0.02 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	0.04 ms
    preparing	0.03 ms
    executing	0.02 ms
    Sending data	0.06 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.02 ms
    storing result in query cache	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    17	JDatabaseDriver->loadObject()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:609
    16	AddonParser::getTemplateName()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:154
    15	AddonParser::getAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:682
    14	require_once JROOT/components/com_sppagebuilder/parser/addon-parser.php	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:14
    13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
    12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
    11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
    10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
    8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    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:261
    1	JApplicationCms->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.93 ms After last query: 2.40 ms Query memory: 0.026 MB Memory before query: 2.716 MB Rows returned: 1

    SELECT `template`
    
      FROM `edmyp_template_styles`
    
      WHERE `client_id` = '0' 
      AND `home` = '1'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	edmyp_template_styles	NULL	ref	idx_home	idx_home	28	const	2	25.00	Using where

    Profile

    Status	Duration
    starting	0.11 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    checking query cache for query	0.06 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    init	0.04 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.02 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	0.09 ms
    preparing	0.04 ms
    executing	0.02 ms
    Sending data	0.06 ms
    end	0.03 ms
    query end	0.02 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.06 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.02 ms
    storing result in query cache	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
    17	JDatabaseDriver->loadObject()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:37
    16	SpPgaeBuilderBase::getTemplateName()	JROOT/administrator/components/com_sppagebuilder/builder/classes/base.php:45
    15	SpPgaeBuilderBase::loadAddons()	JROOT/components/com_sppagebuilder/parser/addon-parser.php:192
    14	AddonParser::viewAddons()	JROOT/components/com_sppagebuilder/views/page/tmpl/default.php:93
    13	include JROOT/components/com_sppagebuilder/views/page/tmpl/default.php	JROOT/libraries/legacy/view/legacy.php:677
    12	JViewLegacy->loadTemplate()	JROOT/libraries/legacy/view/legacy.php:216
    11	JViewLegacy->display()	JROOT/components/com_sppagebuilder/views/page/view.html.php:41
    10	SppagebuilderViewPage->display()	JROOT/libraries/legacy/controller/legacy.php:664
    9	JControllerLegacy->display()	JROOT/components/com_sppagebuilder/controller.php:39
    8	SppagebuilderController->display()	JROOT/libraries/legacy/controller/legacy.php:702
    7	JControllerLegacy->execute()	JROOT/components/com_sppagebuilder/sppagebuilder.php:23
    6	require_once JROOT/components/com_sppagebuilder/sppagebuilder.php	JROOT/libraries/cms/component/helper.php:405
    5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
    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:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

24. Query Time: 1.24 ms After last query: 12.09 ms Query memory: 0.022 MB Memory before query: 3.000 MB Rows returned: 1

    SELECT language,id
    
      FROM `edmyp_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	edmyp_menu	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	9	3.03	Using where

    Profile

    Status	Duration
    starting	0.15 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    checking query cache for query	0.11 ms
    checking permissions	0.03 ms
    Opening tables	0.05 ms
    init	0.06 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.02 ms
    System lock	0.04 ms
    optimizing	0.04 ms
    statistics	0.12 ms
    preparing	0.05 ms
    executing	0.02 ms
    Sending data	0.10 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.03 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.06 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.02 ms
    storing result in query cache	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    9	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/multilang.php:121
    8	JLanguageMultilang::getSiteHomePages()	JROOT/plugins/system/languagefilter/languagefilter.php:697
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    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:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

25. Query Time: 1.07 ms After last query: 0.60 ms Query memory: 0.023 MB Memory before query: 3.012 MB Rows returned: 0

    SELECT `c2`.`language`,`c2`.`id`
    
      FROM `edmyp_menu` AS `c`
    
      INNER JOIN `edmyp_associations` AS `a` 
      ON a.id = c.`id` 
      AND a.context='com_menus.item'
    
      INNER JOIN `edmyp_associations` AS `a2` 
      ON a.key = a2.key
    
      INNER JOIN `edmyp_menu` AS `c2` 
      ON a2.id = c2.`id`
    
      WHERE c.id = 128

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

    Profile

    Status	Duration
    starting	0.04 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    checking query cache for query	0.08 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.06 ms
    init	0.06 ms
    System lock	0.10 ms
    Waiting for query cache lock	0.02 ms
    System lock	0.03 ms
    optimizing	0.04 ms
    statistics	0.08 ms
    executing	0.03 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.13 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.02 ms
    storing result in query cache	0.05 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    10	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/language/associations.php:101
    9	JLanguageAssociations::getAssociations()	JROOT/administrator/components/com_menus/helpers/menus.php:284
    8	MenusHelper::getAssociations()	JROOT/plugins/system/languagefilter/languagefilter.php:714
    7	PlgSystemLanguageFilter->onAfterDispatch()	JROOT/libraries/joomla/event/event.php:69
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    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:261
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

26. Query Time: 2.31 ms After last query: 2.45 ms Query memory: 0.047 MB Memory before query: 3.064 MB Rows returned: 10

    SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
    
      FROM edmyp_modules AS m
    
      LEFT JOIN edmyp_modules_menu AS mm 
      ON mm.moduleid = m.id
    
      LEFT JOIN edmyp_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 <= '2023-03-26 03:11:40') 
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-03-26 03:11:40') 
      AND m.access IN (1,1,5) 
      AND m.client_id = 0 
      AND (mm.menuid = 128 OR mm.menuid <= 0) 
      AND m.language IN ('en-GB','*')
    
      ORDER BY m.position, m.ordering

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	m	NULL	range	PRIMARY,published,newsfeeds,idx_language	published	5	NULL	18	1.85	Using index condition; Using where; Using filesort
    1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	u512947.m.id	1	40.00	Using where; Using index
    1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	u512947.m.module,const	1	10.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.09 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    checking query cache for query	0.14 ms
    checking permissions	0.03 ms
    checking permissions	0.02 ms
    checking permissions	0.02 ms
    Opening tables	0.06 ms
    init	0.10 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.02 ms
    System lock	0.04 ms
    optimizing	0.05 ms
    statistics	0.18 ms
    preparing	0.07 ms
    Sorting result	0.03 ms
    executing	0.02 ms
    Sending data	0.03 ms
    Creating sort index	0.80 ms
    Waiting for query cache lock	0.03 ms
    Creating sort index	0.14 ms
    end	0.03 ms
    query end	0.03 ms
    closing tables	0.07 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.06 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.02 ms
    storing result in query cache	0.08 ms
    cleaning up	0.09 ms

    Call Stack

    #	Caller	File and line number
    14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
    13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
    12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
    11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
    10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
    9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
    8	JDocumentHtml->countModules()	JROOT/templates/protostar/index.php:94
    7	require JROOT/templates/protostar/index.php	JROOT/libraries/joomla/document/html.php:578
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

27. Query Time: 1.01 ms After last query: 6.31 ms Query memory: 0.024 MB Memory before query: 3.127 MB Rows returned: 0

    SELECT uikit
    
      FROM `edmyp_cwgears`
    
      WHERE url = 'https://xn--80aabegdaxnusoia3a3be7n.xn--p1ai/en/start/polo'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

    Profile

    Status	Duration
    starting	0.09 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    checking query cache for query	0.10 ms
    checking permissions	0.03 ms
    Opening tables	0.06 ms
    init	0.05 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.02 ms
    System lock	0.04 ms
    optimizing	0.03 ms
    statistics	0.04 ms
    executing	0.03 ms
    end	0.02 ms
    query end	0.03 ms
    closing tables	0.10 ms
    freeing items	0.03 ms
    Waiting for query cache lock	0.06 ms
    freeing items	0.06 ms
    Waiting for query cache lock	0.03 ms
    freeing items	0.02 ms
    storing result in query cache	0.02 ms
    cleaning up	0.15 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:48
    13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:347
    12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:69
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    10	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    9	JApplicationBase->triggerEvent()	JROOT/libraries/joomla/document/renderer/html/head.php:58
    8	JDocumentRendererHtmlHead->fetchHead()	JROOT/libraries/joomla/document/renderer/html/head.php:34
    7	JDocumentRendererHtmlHead->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->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.79 ms After last query: 0.10 ms Query memory: 0.024 MB Memory before query: 3.134 MB Rows returned: 0

    SELECT uikit_plus
    
      FROM `edmyp_cwgears`
    
      WHERE url = 'https://xn--80aabegdaxnusoia3a3be7n.xn--p1ai/en/start/polo'

    Explain

    id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	NULL	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	NULL	no matching row in const table

    Profile

    Status	Duration
    starting	0.11 ms
    Waiting for query cache lock	0.02 ms
    starting	0.02 ms
    checking query cache for query	0.04 ms
    checking permissions	0.03 ms
    Opening tables	0.03 ms
    init	0.03 ms
    System lock	0.03 ms
    Waiting for query cache lock	0.08 ms
    System lock	0.03 ms
    optimizing	0.03 ms
    statistics	0.03 ms
    executing	0.03 ms
    end	0.02 ms
    query end	0.02 ms
    closing tables	0.02 ms
    freeing items	0.02 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.05 ms
    Waiting for query cache lock	0.02 ms
    freeing items	0.02 ms
    storing result in query cache	0.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
    14	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwgears/helpers/loadcount.php:48
    13	CwGearsHelperLoadcount::getCounts()	JROOT/plugins/system/cwgears/cwgears.php:356
    12	plgSystemCwgears->onBeforeCompileHead()	JROOT/libraries/joomla/event/event.php:69
    11	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
    10	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    9	JApplicationBase->triggerEvent()	JROOT/libraries/joomla/document/renderer/html/head.php:58
    8	JDocumentRendererHtmlHead->fetchHead()	JROOT/libraries/joomla/document/renderer/html/head.php:34
    7	JDocumentRendererHtmlHead->render()	JROOT/libraries/joomla/document/html.php:411
    6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
    5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
    4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
    3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
    2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
    1	JApplicationCms->execute()	JROOT/index.php:49

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

    ---

25 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 2 × SELECT element 
     FROM edmyp_extensions

2. 2 × SELECT `template` 
     FROM `edmyp_template_styles`

3. 2 × SELECT a.rules 
     FROM edmyp_assets AS a

4. 1 × SELECT `data` 
     FROM `edmyp_session`

5. 1 × SELECT a.*,l.title AS language_title,ua.name AS author_name 
     FROM edmyp_sppagebuilder as a 
     LEFT JOIN `edmyp_languages` AS l 
     ON l.lang_code = a.language 
     LEFT JOIN edmyp_users AS ua 
     ON ua.id = a.created_by

6. 1 × SELECT uikit 
     FROM `edmyp_cwgears`

7. 1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
     FROM edmyp_modules AS m 
     LEFT JOIN edmyp_modules_menu AS mm 
     ON mm.moduleid = m.id 
     LEFT JOIN edmyp_extensions AS e 
     ON e.element = m.module 
     AND e.client_id = m.client_id

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

9. 1 × SELECT language,id 
     FROM `edmyp_menu`

10. 1 × SELECT * 
      FROM edmyp_sppagebuilder

11. 1 × SELECT count(*) 
      FROM `edmyp_extensions`

12. 1 × SELECT a.name, a.rules 
      FROM edmyp_assets AS a

13. 1 × SELECT `session_id` 
      FROM `edmyp_session`

14. 1 × SELECT * 
      FROM edmyp_assets

15. 1 × 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 edmyp_menu AS m 
      LEFT JOIN edmyp_extensions AS e 
      ON m.component_id = e.extension_id

16. 1 × SELECT count(*) 
      FROM `edmyp_cwgears_schedule`

17. 1 × SELECT count(*) 
      FROM `edmyp_cwgears_schedule

18. 1 × SELECT id, rules 
      FROM `edmyp_viewlevels

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

20. 1 × SELECT uikit_plus 
      FROM `edmyp_cwgears`