Joomla! Debug Console

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1529880203,
                "last": 1529880203,
                "now": 1529880203
            },
            "token": "TLhU08JKEX211McMyXnX1HPTElxfLc1l"
        },
        "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

20 Queries Logged 5.64 ms

1. Query Time: 0.21 ms Query memory: 0.004 MB Memory before query: 0.706 MB

   DELETE 
   
     FROM `ypscx_session`
   
     WHERE `time` < '1529869403'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ypscx_session	range	time	time	59	const	1	100.00	Using where

   Profile

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.03 ms
   init	0.01 ms
   System lock	0.04 ms
   updating	0.03 ms
   end	0.00 ms
   query end	0.01 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   cleaning up	0.01 ms

   Call Stack

   #	Caller	File and line number
   6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:822
   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.27 ms After last query: 0.23 ms Query memory: 0.010 MB Memory before query: 0.716 MB Rows returned: 0

   SELECT `data`
   
     FROM `ypscx_session`
   
     WHERE `session_id` = '4dcc5dc693d157946e8adaeedd32be08'

   Explain

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

   Profile

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   init	0.00 ms
   checking query cache for query	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   System lock	0.02 ms
   optimizing	0.01 ms
   statistics	0.13 ms
   executing	0.01 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.01 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   freeing items	0.00 ms
   storing result in query cache	1.20 ms
   cleaning up	0.01 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:829
   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: 0.76 ms After last query: 0.56 ms Query memory: 0.005 MB Memory before query: 0.734 MB Rows returned: 0

   SELECT `session_id`
   
     FROM `ypscx_session`
   
     WHERE `session_id` = '4dcc5dc693d157946e8adaeedd32be08' 
     LIMIT 1

   Explain

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

   Profile

   Status	Duration
   starting	0.00 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   init	0.00 ms
   checking query cache for query	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   System lock	0.01 ms
   optimizing	0.00 ms
   statistics	0.01 ms
   executing	0.00 ms
   end	0.00 ms
   query end	0.00 ms
   closing tables	0.00 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   freeing items	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   freeing items	0.00 ms
   storing result in query cache	0.25 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:831
   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.31 ms After last query: 0.08 ms Query memory: 0.005 MB Memory before query: 0.740 MB

   INSERT INTO `ypscx_session`
   (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES 
   ('4dcc5dc693d157946e8adaeedd32be08', 1, '1529880203', 0, '', 0)

   Explain

   EXPLAIN not possible on query: INSERT INTO `ypscx_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('4dcc5dc693d157946e8adaeedd32be08', 1, '1529880203', 0, '', 0)

   Profile

   Status	Duration
   starting	0.02 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.00 ms
   update	0.05 ms
   Waiting for query cache lock	0.00 ms
   update	0.01 ms
   end	0.00 ms
   query end	0.03 ms
   closing tables	0.01 ms
   freeing items	0.01 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:831
   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.]

   ---

5. Query Time: 0.06 ms After last query: 2.53 ms Query memory: 0.007 MB Memory before query: 0.899 MB Rows returned: 3

   SELECT id, rules
   
     FROM `ypscx_viewlevels`

   Explain

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

   Profile

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   init	0.00 ms
   checking query cache for query	0.00 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.01 ms
   sending cached result to clien	0.01 ms
   cleaning up	0.00 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.]

   ---

6. Query Time: 0.05 ms After last query: 0.08 ms Query memory: 0.007 MB Memory before query: 0.912 MB Rows returned: 1

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

   Explain

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

   Profile

   Status	Duration
   starting	0.00 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   init	0.00 ms
   checking query cache for query	0.01 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.00 ms
   checking permissions	0.00 ms
   sending cached result to clien	0.01 ms
   cleaning up	0.00 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.]

   ---

7. Query Time: 0.26 ms After last query: 4.22 ms Query memory: 0.006 MB Memory before query: 1.227 MB Rows returned: 1

   SELECT `enabled`
   
     FROM `ypscx_extensions`
   
     WHERE `element` = 'com_akeeba' 
     AND `type` = 'component'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ypscx_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using index condition; Using where

   Profile

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

   Call Stack

   #	Caller	File and line number
   9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
   8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:79
   7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/cms/plugin/helper.php:252
   6	JPluginHelper::import()	JROOT/libraries/cms/plugin/helper.php:181
   5	JPluginHelper::importPlugin()	JROOT/libraries/cms/application/cms.php:683
   4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:685
   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.]

   ---

8. Query Time: 0.32 ms After last query: 8.76 ms Query memory: 0.009 MB Memory before query: 2.115 MB

   UPDATE `ypscx_extensions`
   
     SET `params` = '{\"mediaversion\":\"94465ff592c434690a143c66e9af8621\"}'
   
     WHERE `type` = 'library' 
     AND `element` = 'joomla'

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ypscx_extensions	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

   Profile

   Status	Duration
   starting	0.04 ms
   checking permissions	0.00 ms
   Opening tables	0.01 ms
   init	0.01 ms
   System lock	0.07 ms
   updating	0.05 ms
   end	0.00 ms
   Waiting for query cache lock	0.00 ms
   end	0.01 ms
   query end	0.03 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/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:1155
   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.]

   ---

9. Query Time: 0.07 ms After last query: 7.96 ms Query memory: 0.008 MB Memory before query: 2.478 MB Rows returned: 1

   SELECT * 
     FROM ypscx_template_styles 
     WHERE template = 'oasis';

   Explain

   id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
   1	SIMPLE	ypscx_template_styles	ref	idx_template	idx_template	202	const	1	100.00	Using index condition

   Profile

   Status	Duration
   starting	0.01 ms
   Waiting for query cache lock	0.00 ms
   Waiting on query cache mutex	0.00 ms
   init	0.00 ms
   checking query cache for query	0.00 ms
   checking privileges on cached	0.00 ms
   checking permissions	0.01 ms
   sending cached result to clien	0.01 ms
   cleaning up	0.00 ms

   Call Stack

   #	Caller	File and line number
   11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
   10	JDatabaseDriver->loadAssocList()	JROOT/templates/oasis/vertex/parameters.php:19
   9	getTemplateName()	JROOT/templates/oasis/vertex/parameters.php:167
   8	require_once JROOT/templates/oasis/vertex/parameters.php	JROOT/templates/oasis/index.php:21
   7	require JROOT/templates/oasis/index.php	JROOT/libraries/joomla/document/html.php:653
   6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
   5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
   4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
   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.]

   ---

10. Query Time: 0.06 ms After last query: 0.06 ms Query memory: 0.008 MB Memory before query: 2.488 MB Rows returned: 1

    SELECT * 
      FROM ypscx_menu 
      WHERE template_style_id IN (13) 
      AND alias = 'home'

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ypscx_menu	ref	idx_alias	idx_alias	402	const	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1486
    10	JDatabaseDriver->loadAssocList()	JROOT/templates/oasis/vertex/parameters.php:40
    9	getTemplateName()	JROOT/templates/oasis/vertex/parameters.php:167
    8	require_once JROOT/templates/oasis/vertex/parameters.php	JROOT/templates/oasis/index.php:21
    7	require JROOT/templates/oasis/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    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.]

    ---

11. Query Time: 0.07 ms After last query: 8.09 ms Query memory: 0.009 MB Memory before query: 2.645 MB Rows returned: 0
    Duplicate queries: #12

    SELECT menutype  
      FROM  ypscx_menu 
      WHERE language = 'en-GB' 
      AND home = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ypscx_menu	ref	idx_language	idx_language	28	const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    11	JDatabaseDriver->loadResult()	JROOT/templates/oasis/vertex/responsive/responsive_mobile_menu.php:139
    10	include JROOT/templates/oasis/vertex/responsive/responsive_mobile_menu.php	JROOT/templates/oasis/vertex/responsive/responsive_mobile_top_bar.php:85
    9	require JROOT/templates/oasis/vertex/responsive/responsive_mobile_top_bar.php	JROOT/templates/oasis/vertex/includes/vertex_includes_top.php:12
    8	require_once JROOT/templates/oasis/vertex/includes/vertex_includes_top.php	JROOT/templates/oasis/index.php:593
    7	require JROOT/templates/oasis/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    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.]

    ---

12. Query Time: 0.06 ms After last query: 2.21 ms Query memory: 0.007 MB Memory before query: 3.184 MB Rows returned: 0
    Duplicate queries: #11

    SELECT menutype  
      FROM  ypscx_menu 
      WHERE language = 'en-GB' 
      AND home = 1

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	ypscx_menu	ref	idx_language	idx_language	28	const	1	100.00	Using index condition; Using where

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    9	JDatabaseDriver->loadResult()	JROOT/templates/oasis/vertex/s5flex_menu/default.php:45
    8	include JROOT/templates/oasis/vertex/s5flex_menu/default.php	JROOT/templates/oasis/index.php:612
    7	require JROOT/templates/oasis/index.php	JROOT/libraries/joomla/document/html.php:653
    6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:715
    5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:530
    4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1102
    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.]

    ---

13. Query Time: 0.14 ms After last query: 22.25 ms Query memory: 0.017 MB Memory before query: 3.212 MB Rows returned: 0

    SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
    
      FROM ypscx_fields AS a
    
      LEFT JOIN `ypscx_languages` AS l 
      ON l.lang_code = a.language
    
      LEFT JOIN ypscx_users AS uc 
      ON uc.id=a.checked_out
    
      LEFT JOIN ypscx_viewlevels AS ag 
      ON ag.id = a.access
    
      LEFT JOIN ypscx_users AS ua 
      ON ua.id = a.created_user_id
    
      LEFT JOIN ypscx_fields_groups AS g 
      ON g.id = a.group_id
    
      WHERE a.context = 'mod_custom.content' 
      AND a.access IN (1,1) 
      AND (a.group_id = 0 OR g.access IN (1,1)) 
      AND a.state = 1 
      AND (a.group_id = 0 OR g.state = 1)
    
      ORDER BY a.ordering ASC

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	100.00	Using where; Using filesort
    1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	wikipeds_antioch.a.language	1	100.00	Using where
    1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.a.checked_out	1	100.00	NULL
    1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.a.access	1	100.00	Using where
    1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.a.created_user_id	1	100.00	Using where
    1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	wikipeds_antioch.a.group_id	1	100.00	Using where

    Profile

    Status	Duration
    starting	0.02 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.01 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.02 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    24	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/model/legacy.php:307
    23	JModelLegacy->_getList()	JROOT/administrator/components/com_fields/models/fields.php:326
    22	FieldsModelFields->_getList()	JROOT/libraries/legacy/model/list.php:186
    21	JModelList->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:134
    20	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:378
    19	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
    18	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    17	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
    16	JHtmlContent::prepare()	JROOT/libraries/cms/html/html.php:233
    15	JHtml::call()	JROOT/libraries/cms/html/html.php:105
    14	JHtml::_()	JROOT/modules/mod_custom/mod_custom.php:15
    13	include JROOT/modules/mod_custom/mod_custom.php	JROOT/libraries/cms/module/helper.php:198
    12	JModuleHelper::renderModule()	JROOT/templates/oasis/html/mod_s5_tabshow/default.php:247
    11	require JROOT/templates/oasis/html/mod_s5_tabshow/default.php	JROOT/modules/mod_s5_tabshow/mod_s5_tabshow.php:40
    10	include JROOT/modules/mod_s5_tabshow/mod_s5_tabshow.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:1116
    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.]

    ---

14. Query Time: 0.22 ms After last query: 76.37 ms Query memory: 0.009 MB Memory before query: 3.767 MB Rows returned: 155

    SELECT * 
      FROM ypscx_acymailing_config

    Explain

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

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.12 ms
    init	0.00 ms
    checking query cache for query	0.00 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.02 ms
    cleaning up	0.00 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/cpanel.php:17
    11	cpanelClass->load()	JROOT/administrator/components/com_acymailing/helpers/helper.php:392
    10	acymailing_config()	JROOT/administrator/components/com_acymailing/helpers/helper.php:1371
    9	include_once JROOT/administrator/components/com_acymailing/helpers/helper.php	JROOT/plugins/system/regacymailing/regacymailing.php:21
    8	plgSystemRegacymailing->initAcy()	JROOT/plugins/system/regacymailing/regacymailing.php:145
    7	plgSystemRegacymailing->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
    6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
    5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
    4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1122
    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.23 ms After last query: 0.53 ms Query memory: 0.011 MB Memory before query: 3.881 MB Rows returned: 1

    SELECT `alias`
    
      FROM `ypscx_content`
    
      WHERE id = '114'

    Explain

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

    Profile

    Status	Duration
    starting	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.03 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.02 ms
    System lock	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    System lock	0.02 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.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	1.02 ms
    cleaning up	0.02 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    16	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
    15	ContentRouter->getArticleSegment()	JROOT/libraries/cms/component/router/view.php:117
    14	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
    13	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
    12	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
    11	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
    10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
    7	PlgSystemSef->onAfterRender()	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/cms.php:1122
    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.66 ms After last query: 0.43 ms Query memory: 0.012 MB Memory before query: 3.903 MB Rows returned: 0

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	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.00 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    17	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    16	JCategories->get()	JROOT/components/com_content/router.php:72
    15	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:121
    14	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
    13	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
    12	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
    11	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
    10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
    7	PlgSystemSef->onAfterRender()	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/cms.php:1122
    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.]

    ---

17. Query Time: 0.13 ms After last query: 0.22 ms Query memory: 0.012 MB Memory before query: 4.025 MB Rows returned: 1

    SELECT `alias`
    
      FROM `ypscx_content`
    
      WHERE id = '113'

    Explain

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

    Profile

    Status	Duration
    starting	0.00 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    System lock	0.01 ms
    optimizing	0.00 ms
    statistics	0.02 ms
    preparing	0.00 ms
    executing	0.00 ms
    Sending data	0.00 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.92 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    16	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
    15	ContentRouter->getArticleSegment()	JROOT/libraries/cms/component/router/view.php:117
    14	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
    13	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
    12	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
    11	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
    10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
    7	PlgSystemSef->onAfterRender()	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/cms.php:1122
    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.]

    ---

18. Query Time: 0.88 ms After last query: 0.08 ms Query memory: 0.012 MB Memory before query: 4.040 MB Rows returned: 0

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	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.00 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    17	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    16	JCategories->get()	JROOT/components/com_content/router.php:72
    15	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:121
    14	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
    13	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
    12	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
    11	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
    10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
    7	PlgSystemSef->onAfterRender()	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/cms.php:1122
    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.]

    ---

19. Query Time: 0.39 ms After last query: 0.20 ms Query memory: 0.011 MB Memory before query: 4.050 MB Rows returned: 1

    SELECT `alias`
    
      FROM `ypscx_content`
    
      WHERE id = '115'

    Explain

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

    Profile

    Status	Duration
    starting	0.00 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.24 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking permissions	0.00 ms
    Opening tables	0.01 ms
    init	0.01 ms
    System lock	0.00 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 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.00 ms
    end	0.00 ms
    query end	0.00 ms
    closing tables	0.01 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.00 ms
    freeing items	0.00 ms
    storing result in query cache	0.25 ms
    cleaning up	0.01 ms

    Call Stack

    #	Caller	File and line number
    17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1720
    16	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
    15	ContentRouter->getArticleSegment()	JROOT/libraries/cms/component/router/view.php:117
    14	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
    13	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
    12	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
    11	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
    10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
    7	PlgSystemSef->onAfterRender()	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/cms.php:1122
    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.]

    ---

20. Query Time: 0.49 ms After last query: 0.09 ms Query memory: 0.012 MB Memory before query: 4.064 MB Rows returned: 0

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

    Explain

    id	select_type	table	type	possible_keys	key	key_len	ref	rows	filtered	Extra
    1	SIMPLE	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.01 ms
    Waiting for query cache lock	0.00 ms
    Waiting on query cache mutex	0.27 ms
    init	0.00 ms
    checking query cache for query	0.01 ms
    checking privileges on cached	0.00 ms
    checking permissions	0.00 ms
    checking permissions	0.00 ms
    sending cached result to clien	0.01 ms
    cleaning up	0.00 ms

    Call Stack

    #	Caller	File and line number
    19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1681
    18	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:304
    17	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
    16	JCategories->get()	JROOT/components/com_content/router.php:72
    15	ContentRouter->getCategorySegment()	JROOT/libraries/cms/component/router/view.php:121
    14	JComponentRouterView->getPath()	JROOT/libraries/cms/component/router/rules/menu.php:82
    13	JComponentRouterRulesMenu->preprocess()	JROOT/libraries/cms/component/router/view.php:219
    12	JComponentRouterView->preprocess()	JROOT/libraries/cms/router/site.php:660
    11	JRouterSite->processBuildRules()	JROOT/libraries/cms/router/router.php:267
    10	JRouter->build()	JROOT/libraries/cms/router/site.php:149
    9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
    8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
    7	PlgSystemSef->onAfterRender()	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/cms.php:1122
    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 Types Logged, Sorted by Occurrences.

SELECT Tables:

1. 3 × SELECT `alias` 
     FROM `ypscx_content`

2. 3 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,    c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,    c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,    c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
     CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
     FROM ypscx_categories as c 
     LEFT JOIN ypscx_categories AS s 
     ON (s.lft <= c.lft 
     AND s.rgt >= c.rgt) OR (s.lft > c.lft 
     AND s.rgt < c.rgt)

3. 2 × SELECT menutype  
     FROM  ypscx_menu

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

5. 1 × SELECT `session_id` 
     FROM `ypscx_session`

6. 1 × SELECT id, rules 
     FROM `ypscx_viewlevels

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

8. 1 × SELECT `enabled` 
     FROM `ypscx_extensions`

9. 1 × SELECT * 
     FROM ypscx_template_styles

10. 1 × SELECT * 
      FROM ypscx_menu

11. 1 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state 
      FROM ypscx_fields AS a 
      LEFT JOIN `ypscx_languages` AS l 
      ON l.lang_code = a.language 
      LEFT JOIN ypscx_users AS uc 
      ON uc.id=a.checked_out 
      LEFT JOIN ypscx_viewlevels AS ag 
      ON ag.id = a.access 
      LEFT JOIN ypscx_users AS ua 
      ON ua.id = a.created_user_id 
      LEFT JOIN ypscx_fields_groups AS g 
      ON g.id = a.group_id

12. 1 × SELECT * 
      FROM ypscx_acymailing_confi

OTHER Tables:

1. 1 × DELETE  
     FROM `ypscx_session`

2. 1 × INSERT INTO `ypscx_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
     VALUES  ('4dcc5dc693d157946e8adaeedd32be08', 1, '1529880203', 0, '', 0

3. 1 × UPDATE `ypscx_extensions` 
     SET `params` = '{\"mediaversion\":\"94465ff592c434690a143c66e9af8621\"}'